Symfony Profiler

SELECT
  parentId AS parentId
FROM
  objects
WHERE
  id = ?

SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = 30528;

SELECT
  object_localized_SysTextelement_de_DE.id as id,
  object_localized_SysTextelement_de_DE.type as `type`
FROM
  object_localized_SysTextelement_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (
    path like '/020 System-Textelements/01/%'
  )
  AND object_localized_SysTextelement_de_DE.type IN ('object', 'variant')

SELECT object_localized_SysTextelement_de_DE.id as id, object_localized_SysTextelement_de_DE.type as `type` FROM object_localized_SysTextelement_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (path like '/020 System-Textelements/01/%') AND  object_localized_SysTextelement_de_DE.type IN ('object','variant');

SELECT
  *
FROM
  plugin_pim_dataport
WHERE
  id = ?
LIMIT
  1

SELECT * FROM plugin_pim_dataport WHERE id = 42 LIMIT 1;

SELECT
  object_localized_SysCollection_de_DE.id as id,
  object_localized_SysCollection_de_DE.type as `type`
FROM
  object_localized_SysCollection_de_DE
WHERE
  (
    id IN (
      30530, 30528, 30527, 29119, 2, 1, 30698,
      30587, 30586, 30588
    )
  )
  AND (
    path like '/040 System-Collections/%'
  )
  AND object_localized_SysCollection_de_DE.type IN ('object', 'variant')

SELECT object_localized_SysCollection_de_DE.id as id, object_localized_SysCollection_de_DE.type as `type` FROM object_localized_SysCollection_de_DE WHERE (id IN (30530,30528,30527,29119,2,1,30698,30587,30586,30588)) AND (path like '/040 System-Collections/%') AND  object_localized_SysCollection_de_DE.type IN ('object','variant');

SELECT
  object_localized_SysCollection_de_DE.id as id,
  object_localized_SysCollection_de_DE.type as `type`
FROM
  object_localized_SysCollection_de_DE
WHERE
  (
    id IN (
      30530, 30528, 30527, 29119, 2, 1, 30698,
      30587, 30586, 30588
    )
  )
  AND (
    path like '/040 System-Collections/%'
    and path not like '/040 System-Collections/000/08H%'
  )
  AND object_localized_SysCollection_de_DE.type IN ('object', 'variant')

SELECT object_localized_SysCollection_de_DE.id as id, object_localized_SysCollection_de_DE.type as `type` FROM object_localized_SysCollection_de_DE WHERE (id IN (30530,30528,30527,29119,2,1,30698,30587,30586,30588)) AND (path like '/040 System-Collections/%' and path not like '/040 System-Collections/000/08H%') AND  object_localized_SysCollection_de_DE.type IN ('object','variant');

SELECT
  sourceid
FROM
  (
    SELECT
      sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.sourceid = objects.id
      AND dependencies.sourcetype = 'object'
      AND objects.classId = 'SysTextelement'
    WHERE
      targettype = 'object'
      AND targetid = '30530'
    UNION
    SELECT
      targetid AS sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.targetid = objects.id
      AND dependencies.targettype = 'object'
      AND objects.classId = 'SysTextelement'
    WHERE
      sourcetype = 'object'
      AND sourceid = '30530'
    UNION
    SELECT
      objects.id AS sourceid
    FROM
      objects
    WHERE
      objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
  ) t

SELECT sourceid FROM (
                        SELECT sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype='object' AND objects.classId='SysTextelement'
                        
                        
                        WHERE targettype='object' AND targetid='30530'
                    UNION
                        SELECT targetid AS sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.targetid=objects.id AND dependencies.targettype='object' AND objects.classId='SysTextelement'
                        
                        
                        WHERE sourcetype='object' AND sourceid='30530'
                    UNION 
                        SELECT objects.id AS sourceid
                        FROM objects 
                        WHERE objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
                    ) t
                ;

SELECT
  sourceid
FROM
  (
    SELECT
      sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.sourceid = objects.id
      AND dependencies.sourcetype = 'object'
      AND objects.classId = 'System'
    WHERE
      targettype = 'object'
      AND targetid = '30530'
    UNION
    SELECT
      targetid AS sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.targetid = objects.id
      AND dependencies.targettype = 'object'
      AND objects.classId = 'System'
    WHERE
      sourcetype = 'object'
      AND sourceid = '30530'
    UNION
    SELECT
      objects.id AS sourceid
    FROM
      objects
    WHERE
      objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
  ) t

SELECT sourceid FROM (
                        SELECT sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype='object' AND objects.classId='System'
                        
                        
                        WHERE targettype='object' AND targetid='30530'
                    UNION
                        SELECT targetid AS sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.targetid=objects.id AND dependencies.targettype='object' AND objects.classId='System'
                        
                        
                        WHERE sourcetype='object' AND sourceid='30530'
                    UNION 
                        SELECT objects.id AS sourceid
                        FROM objects 
                        WHERE objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
                    ) t
                ;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'SysCollection';

SELECT
  sourceid,
  CONCAT(path, `key`) AS path
FROM
  dependencies
  INNER JOIN objects ON dependencies.sourceid = objects.id
  AND dependencies.targettype = "object"
  AND objects.classId = 'SysCollection'
WHERE
  targetid = ?
  AND targettype = ?
  AND sourcetype = ?

SELECT sourceid, CONCAT(path, `key`) AS path
                    FROM dependencies 
                    INNER JOIN objects ON dependencies.sourceid=objects.id AND dependencies.targettype="object" AND objects.classId='SysCollection'
                    
                    
                    WHERE targetid = 30530 AND targettype='object' AND sourcetype = 'object';

SELECT
  sourceid
FROM
  (
    SELECT
      sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.sourceid = objects.id
      AND dependencies.sourcetype = 'object'
      AND objects.classId = 'SysProduct'
    WHERE
      targettype = 'object'
      AND targetid = '30530'
    UNION
    SELECT
      targetid AS sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.targetid = objects.id
      AND dependencies.targettype = 'object'
      AND objects.classId = 'SysProduct'
    WHERE
      sourcetype = 'object'
      AND sourceid = '30530'
    UNION
    SELECT
      objects.id AS sourceid
    FROM
      objects
    WHERE
      objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
  ) t

SELECT sourceid FROM (
                        SELECT sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype='object' AND objects.classId='SysProduct'
                        
                        
                        WHERE targettype='object' AND targetid='30530'
                    UNION
                        SELECT targetid AS sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.targetid=objects.id AND dependencies.targettype='object' AND objects.classId='SysProduct'
                        
                        
                        WHERE sourcetype='object' AND sourceid='30530'
                    UNION 
                        SELECT objects.id AS sourceid
                        FROM objects 
                        WHERE objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
                    ) t
                ;

SELECT
  1
FROM
  plugin_pim_fieldmapping
WHERE
  dataportId = ?
  AND fieldName = ?
  AND calculation NOT LIKE ?
  AND (
    calculation REGEXP '\\$params\\[[\'"]response[\'"]\\]->setContent'
    OR calculation REGEXP '\\$params\\[[\'"]response[\'"]\\]->addContent'
  )

SELECT 1 FROM plugin_pim_fieldmapping WHERE dataportId = 42 AND fieldName = '__result_callback' AND calculation NOT LIKE '%X-Data-Director-Run%' AND (calculation REGEXP '\\$params\\[[\'"]response[\'"]\\]->setContent' OR calculation REGEXP '\\$params\\[[\'"]response[\'"]\\]->addContent');

SELECT
  sourceid
FROM
  (
    SELECT
      sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.sourceid = objects.id
      AND dependencies.sourcetype = 'object'
      AND objects.classId = 'FindfixSelection'
    WHERE
      targettype = 'object'
      AND targetid = '30530'
    UNION
    SELECT
      targetid AS sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.targetid = objects.id
      AND dependencies.targettype = 'object'
      AND objects.classId = 'FindfixSelection'
    WHERE
      sourcetype = 'object'
      AND sourceid = '30530'
    UNION
    SELECT
      objects.id AS sourceid
    FROM
      objects
    WHERE
      objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
  ) t

SELECT sourceid FROM (
                        SELECT sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype='object' AND objects.classId='FindfixSelection'
                        
                        
                        WHERE targettype='object' AND targetid='30530'
                    UNION
                        SELECT targetid AS sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.targetid=objects.id AND dependencies.targettype='object' AND objects.classId='FindfixSelection'
                        
                        
                        WHERE sourcetype='object' AND sourceid='30530'
                    UNION 
                        SELECT objects.id AS sourceid
                        FROM objects 
                        WHERE objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
                    ) t
                ;

SELECT
  sourceid
FROM
  (
    SELECT
      sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.sourceid = objects.id
      AND dependencies.sourcetype = 'object'
      AND objects.classId = 'FindfixFilter'
    WHERE
      targettype = 'object'
      AND targetid = '30530'
    UNION
    SELECT
      targetid AS sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.targetid = objects.id
      AND dependencies.targettype = 'object'
      AND objects.classId = 'FindfixFilter'
    WHERE
      sourcetype = 'object'
      AND sourceid = '30530'
    UNION
    SELECT
      objects.id AS sourceid
    FROM
      objects
    WHERE
      objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
  ) t

SELECT sourceid FROM (
                        SELECT sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype='object' AND objects.classId='FindfixFilter'
                        
                        
                        WHERE targettype='object' AND targetid='30530'
                    UNION
                        SELECT targetid AS sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.targetid=objects.id AND dependencies.targettype='object' AND objects.classId='FindfixFilter'
                        
                        
                        WHERE sourcetype='object' AND sourceid='30530'
                    UNION 
                        SELECT objects.id AS sourceid
                        FROM objects 
                        WHERE objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
                    ) t
                ;

SELECT
  *
FROM
  plugin_pim_rawitemField
WHERE
  dataportId = ?
ORDER BY
  priority

SELECT * FROM plugin_pim_rawitemField WHERE dataportId = 42 ORDER BY priority;

SELECT
  object_localized_SysProduct_de_DE.id as id,
  object_localized_SysProduct_de_DE.type as `type`
FROM
  object_localized_SysProduct_de_DE
WHERE
  (
    id IN (
      30698, 30587, 30586, 30588, 30528, 30527,
      29119, 2
    )
  )
  AND object_localized_SysProduct_de_DE.type IN ('object', 'variant')

SELECT object_localized_SysProduct_de_DE.id as id, object_localized_SysProduct_de_DE.type as `type` FROM object_localized_SysProduct_de_DE WHERE (id IN (30698,30587,30586,30588,30528,30527,29119,2)) AND  object_localized_SysProduct_de_DE.type IN ('object','variant');

(
  SELECT
    id
  FROM
    objects
  WHERE
    path LIKE ?
)

(SELECT id FROM objects WHERE path LIKE '/040 System-Collections/1/01BA/BA01/01/%');

SET
  SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

SELECT
  object_localized_System_de_DE.id as id,
  object_localized_System_de_DE.type as `type`
FROM
  object_localized_System_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (
    published = '1'
    and path like '/030 Systems/00/%'
  )
  AND object_localized_System_de_DE.type IN ('object', 'variant')

SELECT object_localized_System_de_DE.id as id, object_localized_System_de_DE.type as `type` FROM object_localized_System_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (published='1' and path like '/030 Systems/00/%') AND  object_localized_System_de_DE.type IN ('object','variant');

SELECT
  object_localized_SysTextelementFolder_de_DE.id as id,
  object_localized_SysTextelementFolder_de_DE.type as `type`
FROM
  object_localized_SysTextelementFolder_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (
    path like '/020 System-Textelements/01/%'
  )
  AND object_localized_SysTextelementFolder_de_DE.type IN ('object', 'variant')

SELECT object_localized_SysTextelementFolder_de_DE.id as id, object_localized_SysTextelementFolder_de_DE.type as `type` FROM object_localized_SysTextelementFolder_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (path like '/020 System-Textelements/01/%') AND  object_localized_SysTextelementFolder_de_DE.type IN ('object','variant');

SELECT
  object_localized_System_de_DE.id as id,
  object_localized_System_de_DE.type as `type`
FROM
  object_localized_System_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (published = '1')
  AND object_localized_System_de_DE.type IN ('object', 'variant')

SELECT object_localized_System_de_DE.id as id, object_localized_System_de_DE.type as `type` FROM object_localized_System_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (published = '1') AND  object_localized_System_de_DE.type IN ('object','variant');

SELECT
  sourceid
FROM
  (
    SELECT
      sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.sourceid = objects.id
      AND dependencies.sourcetype = 'object'
      AND objects.classId = 'SysTextelementFolder'
    WHERE
      targettype = 'object'
      AND targetid = '30530'
    UNION
    SELECT
      targetid AS sourceid
    FROM
      dependencies
      INNER JOIN objects ON dependencies.targetid = objects.id
      AND dependencies.targettype = 'object'
      AND objects.classId = 'SysTextelementFolder'
    WHERE
      sourcetype = 'object'
      AND sourceid = '30530'
    UNION
    SELECT
      objects.id AS sourceid
    FROM
      objects
    WHERE
      objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
  ) t

SELECT sourceid FROM (
                        SELECT sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype='object' AND objects.classId='SysTextelementFolder'
                        
                        
                        WHERE targettype='object' AND targetid='30530'
                    UNION
                        SELECT targetid AS sourceid FROM dependencies
                        INNER JOIN objects ON dependencies.targetid=objects.id AND dependencies.targettype='object' AND objects.classId='SysTextelementFolder'
                        
                        
                        WHERE sourcetype='object' AND sourceid='30530'
                    UNION 
                        SELECT objects.id AS sourceid
                        FROM objects 
                        WHERE objects.path LIKE '/040 System-Collections/1/01BA/BA01/01/%'
                    ) t
                ;

SELECT
  object_localized_SysTextelement_de_DE.id as id,
  object_localized_SysTextelement_de_DE.type as `type`
FROM
  object_localized_SysTextelement_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (
    published = '1'
    and Path like '/020 System-Textelements/01/%'
  )
  AND object_localized_SysTextelement_de_DE.type IN ('object', 'variant')

SELECT object_localized_SysTextelement_de_DE.id as id, object_localized_SysTextelement_de_DE.type as `type` FROM object_localized_SysTextelement_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (published='1' and Path like '/020 System-Textelements/01/%') AND  object_localized_SysTextelement_de_DE.type IN ('object','variant');

SELECT
  object_localized_SysCollection_de_DE.id as id,
  object_localized_SysCollection_de_DE.type as `type`
FROM
  object_localized_SysCollection_de_DE
WHERE
  (
    id IN (
      30530, 30528, 30527, 29119, 2, 1, 30698,
      30587, 30586, 30588
    )
  )
  AND (
    published = '1'
    and path like '/040 System-Collections/%'
  )
  AND object_localized_SysCollection_de_DE.type IN ('object', 'variant')

SELECT object_localized_SysCollection_de_DE.id as id, object_localized_SysCollection_de_DE.type as `type` FROM object_localized_SysCollection_de_DE WHERE (id IN (30530,30528,30527,29119,2,1,30698,30587,30586,30588)) AND (published='1' and path like '/040 System-Collections/%') AND  object_localized_SysCollection_de_DE.type IN ('object','variant');

SELECT
  object_localized_SysTextelement_de_DE.id as id,
  object_localized_SysTextelement_de_DE.type as `type`
FROM
  object_localized_SysTextelement_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (
    published = '1'
    and path like '/020 System-Textelements/01/05SE/05SSP/%'
  )
  AND object_localized_SysTextelement_de_DE.type IN ('object', 'variant')

SELECT object_localized_SysTextelement_de_DE.id as id, object_localized_SysTextelement_de_DE.type as `type` FROM object_localized_SysTextelement_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (published='1' and path like '/020 System-Textelements/01/05SE/05SSP/%') AND  object_localized_SysTextelement_de_DE.type IN ('object','variant');

SELECT
  object_localized_FindfixSelection_de_DE.id as id,
  object_localized_FindfixSelection_de_DE.type as `type`
FROM
  object_localized_FindfixSelection_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (
    path like '/050 FindFix-Product-Finder/DE/%'
  )
  AND object_localized_FindfixSelection_de_DE.type IN ('object', 'variant')

SELECT object_localized_FindfixSelection_de_DE.id as id, object_localized_FindfixSelection_de_DE.type as `type` FROM object_localized_FindfixSelection_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (path like '/050 FindFix-Product-Finder/DE/%') AND  object_localized_FindfixSelection_de_DE.type IN ('object','variant');

SELECT
  object_localized_FindfixFilter_de_DE.id as id,
  object_localized_FindfixFilter_de_DE.type as `type`
FROM
  object_localized_FindfixFilter_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (
    published = '1'
    and path like '/060 FindFix-Categories/%'
  )
  AND object_localized_FindfixFilter_de_DE.type IN ('object', 'variant')

SELECT object_localized_FindfixFilter_de_DE.id as id, object_localized_FindfixFilter_de_DE.type as `type` FROM object_localized_FindfixFilter_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (published='1' and path like '/060 FindFix-Categories/%') AND  object_localized_FindfixFilter_de_DE.type IN ('object','variant');

SELECT
  object_localized_FindfixFilter_de_DE.id as id,
  object_localized_FindfixFilter_de_DE.type as `type`
FROM
  object_localized_FindfixFilter_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (
    path like '/060 FindFix-Categories/%'
  )
  AND object_localized_FindfixFilter_de_DE.type IN ('object', 'variant')

SELECT object_localized_FindfixFilter_de_DE.id as id, object_localized_FindfixFilter_de_DE.type as `type` FROM object_localized_FindfixFilter_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (path like '/060 FindFix-Categories/%') AND  object_localized_FindfixFilter_de_DE.type IN ('object','variant');

SELECT
  object_localized_SysTextelement_de_DE.id as id,
  object_localized_SysTextelement_de_DE.type as `type`
FROM
  object_localized_SysTextelement_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (id = '31008')
  AND object_localized_SysTextelement_de_DE.type IN ('object', 'variant')

SELECT object_localized_SysTextelement_de_DE.id as id, object_localized_SysTextelement_de_DE.type as `type` FROM object_localized_SysTextelement_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (id='31008') AND  object_localized_SysTextelement_de_DE.type IN ('object','variant');

SELECT
  object_localized_SysCollection_de_DE.id as id,
  object_localized_SysCollection_de_DE.type as `type`
FROM
  object_localized_SysCollection_de_DE
WHERE
  (
    id IN (
      30530, 30528, 30527, 29119, 2, 1, 30698,
      30587, 30586, 30588
    )
  )
  AND (
    path like '/040 System-Collections/000/%'
  )
  AND object_localized_SysCollection_de_DE.type IN ('object', 'variant')

SELECT object_localized_SysCollection_de_DE.id as id, object_localized_SysCollection_de_DE.type as `type` FROM object_localized_SysCollection_de_DE WHERE (id IN (30530,30528,30527,29119,2,1,30698,30587,30586,30588)) AND (path like '/040 System-Collections/000/%') AND  object_localized_SysCollection_de_DE.type IN ('object','variant');

SELECT
  object_localized_FindfixSelection_de_DE.id as id,
  object_localized_FindfixSelection_de_DE.type as `type`
FROM
  object_localized_FindfixSelection_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (
    published = '1'
    and path like '/050 FindFix-Product-Finder/%'
  )
  AND object_localized_FindfixSelection_de_DE.type IN ('object', 'variant')

SELECT object_localized_FindfixSelection_de_DE.id as id, object_localized_FindfixSelection_de_DE.type as `type` FROM object_localized_FindfixSelection_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (published='1' and path like '/050 FindFix-Product-Finder/%') AND  object_localized_FindfixSelection_de_DE.type IN ('object','variant');

SELECT
  object_localized_System_de_DE.id as id,
  object_localized_System_de_DE.type as `type`
FROM
  object_localized_System_de_DE
WHERE
  (
    id IN (
      30698, 30587, 30586, 30588, 30528, 30527,
      29119, 2
    )
  )
  AND object_localized_System_de_DE.type IN ('object', 'variant')

SELECT object_localized_System_de_DE.id as id, object_localized_System_de_DE.type as `type` FROM object_localized_System_de_DE WHERE (id IN (30698,30587,30586,30588,30528,30527,29119,2)) AND  object_localized_System_de_DE.type IN ('object','variant');

SELECT
  *
FROM
  users
WHERE
  `type` = ?
  AND id = ?

SELECT * FROM users WHERE `type` = 'user' AND id = 6;

SELECT
  object_localized_System_de_DE.id as id,
  object_localized_System_de_DE.type as `type`
FROM
  object_localized_System_de_DE
WHERE
  (
    (
      id IN (
        30698, 30587, 30586, 30588, 30528, 30527,
        29119, 2
      )
    )
  )
  AND (id = '28639')
  AND object_localized_System_de_DE.type IN ('object', 'variant')

SELECT object_localized_System_de_DE.id as id, object_localized_System_de_DE.type as `type` FROM object_localized_System_de_DE WHERE ((id IN (30698,30587,30586,30588,30528,30527,29119,2))) AND (id='28639') AND  object_localized_System_de_DE.type IN ('object','variant');

SELECT
  *
FROM
  plugin_pim_dataport
ORDER BY
  name

SELECT * FROM plugin_pim_dataport ORDER BY name;

SELECT
  *
FROM
  website_settings
WHERE
  id = ?

SELECT * FROM website_settings WHERE id = 1;

SELECT
  *
FROM
  translations_admin
LIMIT
  1;

SELECT * FROM translations_admin LIMIT 1;;

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 6;

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 6;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 6;

SELECT
  id
FROM
  website_settings

SELECT id FROM website_settings;