Symfony Profiler

Query Metrics

181 Database Queries

41 Different statements

63.01 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM users WHERE `type` = ? AND id = ?
SELECT * FROM users_workspaces_asset WHERE userId = ?
SELECT * FROM users_workspaces_document WHERE userId = ?
SELECT * FROM users_workspaces_object WHERE userId = ?
SELECT name FROM classes WHERE id = ?
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT * FROM plugin_pim_dataport ORDER BY name
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1
SELECT id FROM website_settings
SELECT * FROM website_settings WHERE id = ?
SELECT * FROM website_settings WHERE id = ?
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 id FROM objects WHERE path LIKE ?)
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 * FROM translations_admin LIMIT 1;
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
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 name FROM classes WHERE id = ?
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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 name FROM classes WHERE id = ?
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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 name FROM classes WHERE id = ?
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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 id FROM objects WHERE path LIKE ?)
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 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 * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 id FROM objects WHERE path LIKE ?)
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 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 name FROM classes WHERE id = ?
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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 name FROM classes WHERE id = ?
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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 id FROM objects WHERE path LIKE ?)
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 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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 name FROM classes WHERE id = ?
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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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 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 parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
SELECT parentId AS parentId 
                        FROM objects 
                        WHERE id = ?
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')

#▲	Time	Info
1	0.31 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
2	0.49 ms	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 6`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 6;
3	0.31 ms	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 6;
4	0.27 ms	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 6;
5	0.21 ms	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 6;
6	0.32 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SysCollection"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SysCollection';
7	0.15 ms	SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED Parameters: [] View formatted query View runnable query Explain query SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
8	0.39 ms	SELECT * FROM plugin_pim_dataport ORDER BY name Parameters: [] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport ORDER BY name SELECT * FROM plugin_pim_dataport ORDER BY name;
9	0.25 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`42`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 42 LIMIT 1;
10	0.22 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`41`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 41 LIMIT 1;
11	0.21 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`43`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 43 LIMIT 1;
12	0.16 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`39`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 39 LIMIT 1;
13	0.16 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`38`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 38 LIMIT 1;
14	0.16 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`20`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 20 LIMIT 1;
15	0.12 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`34`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 34 LIMIT 1;
16	0.10 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 4 LIMIT 1;
17	0.15 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`15`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 15 LIMIT 1;
18	0.16 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`52`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 52 LIMIT 1;
19	0.14 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`56`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 56 LIMIT 1;
20	0.15 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`40`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 40 LIMIT 1;
21	0.22 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`57`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 57 LIMIT 1;
22	0.13 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`53`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 53 LIMIT 1;
23	0.13 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`55`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 55 LIMIT 1;
24	0.13 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`29`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 29 LIMIT 1;
25	0.15 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`50`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 50 LIMIT 1;
26	0.21 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`51`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 51 LIMIT 1;
27	0.15 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`49`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 49 LIMIT 1;
28	0.12 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`54`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 54 LIMIT 1;
29	0.13 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`18`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 18 LIMIT 1;
30	0.16 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`45`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 45 LIMIT 1;
31	0.14 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`46`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 46 LIMIT 1;
32	0.19 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`48`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 48 LIMIT 1;
33	0.16 ms	SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 Parameters: [`47`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_dataport WHERE id = ? LIMIT 1 SELECT * FROM plugin_pim_dataport WHERE id = 47 LIMIT 1;
34	0.20 ms	SELECT id FROM website_settings Parameters: [] View formatted query View runnable query Explain query SELECT id FROM website_settings SELECT id FROM website_settings;
35	0.16 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
36	0.22 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 2;
37	0.15 ms	SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED Parameters: [] View formatted query View runnable query Explain query SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
38	0.30 ms	SELECT * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority Parameters: [`42`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority SELECT * FROM plugin_pim_rawitemField WHERE dataportId = 42 ORDER BY priority;
39	0.24 ms	SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED Parameters: [] View formatted query View runnable query Explain query SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
40	0.30 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
41	0.15 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
42	0.16 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
43	0.16 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
44	0.15 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 1;
45	0.34 ms	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 = ? Parameters: [`30530 "object" "object"`] View formatted query View runnable query Explain query 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';
46	0.17 ms	(SELECT id FROM objects WHERE path LIKE ?) Parameters: [`"/040 System-Collections/1/01BA/BA01/01/%"`] View formatted query View runnable query Explain query ( SELECT id FROM objects WHERE path LIKE ? ) (SELECT id FROM objects WHERE path LIKE '/040 System-Collections/1/01BA/BA01/01/%');
47	3.50 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
48	0.34 ms	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
49	0.23 ms	SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED Parameters: [] View formatted query View runnable query Explain query SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
50	0.41 ms	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') Parameters: [`42 "__result_callback" "%X-Data-Director-Run%"`] View formatted query View runnable query Explain query 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');
51	0.24 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"System"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'System';
52	0.69 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
53	0.17 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
54	0.10 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
55	0.24 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
56	0.18 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
57	0.52 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
58	0.50 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
59	0.17 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
60	0.11 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
61	0.19 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
62	0.15 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
63	0.42 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
64	0.23 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"FindfixFilter"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'FindfixFilter';
65	0.59 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
66	0.21 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
67	0.18 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
68	0.16 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
69	0.16 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
70	0.62 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
71	0.20 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"FindfixSelection"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'FindfixSelection';
72	0.58 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
73	0.15 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
74	0.11 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
75	0.12 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
76	0.14 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
77	0.52 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
78	0.55 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
79	0.20 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
80	0.22 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
81	0.19 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
82	0.12 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
83	0.73 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
84	0.26 ms	SELECT * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority Parameters: [`34`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority SELECT * FROM plugin_pim_rawitemField WHERE dataportId = 34 ORDER BY priority;
85	0.35 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
86	0.21 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
87	0.19 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
88	0.19 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
89	0.14 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 1;
90	0.35 ms	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 = ? Parameters: [`30530 "object" "object"`] View formatted query View runnable query Explain query 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';
91	0.20 ms	(SELECT id FROM objects WHERE path LIKE ?) Parameters: [`"/040 System-Collections/1/01BA/BA01/01/%"`] View formatted query View runnable query Explain query ( SELECT id FROM objects WHERE path LIKE ? ) (SELECT id FROM objects WHERE path LIKE '/040 System-Collections/1/01BA/BA01/01/%');
92	3.16 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
93	0.42 ms	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') Parameters: [`34 "__result_callback" "%X-Data-Director-Run%"`] View formatted query View runnable query Explain query 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 = 34 AND fieldName = '__result_callback' AND calculation NOT LIKE '%X-Data-Director-Run%' AND (calculation REGEXP '\\$params\\[[\'"]response[\'"]\\]->setContent' OR calculation REGEXP '\\$params\\[[\'"]response[\'"]\\]->addContent');
94	0.25 ms	SELECT * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority SELECT * FROM plugin_pim_rawitemField WHERE dataportId = 4 ORDER BY priority;
95	0.19 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
96	0.19 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
97	0.21 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
98	0.17 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
99	0.14 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 1;
100	0.34 ms	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 = ? Parameters: [`30530 "object" "object"`] View formatted query View runnable query Explain query 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';
101	0.22 ms	(SELECT id FROM objects WHERE path LIKE ?) Parameters: [`"/040 System-Collections/1/01BA/BA01/01/%"`] View formatted query View runnable query Explain query ( SELECT id FROM objects WHERE path LIKE ? ) (SELECT id FROM objects WHERE path LIKE '/040 System-Collections/1/01BA/BA01/01/%');
102	0.64 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
103	0.35 ms	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') Parameters: [`4 "__result_callback" "%X-Data-Director-Run%"`] View formatted query View runnable query Explain query 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 = 4 AND fieldName = '__result_callback' AND calculation NOT LIKE '%X-Data-Director-Run%' AND (calculation REGEXP '\\$params\\[[\'"]response[\'"]\\]->setContent' OR calculation REGEXP '\\$params\\[[\'"]response[\'"]\\]->addContent');
104	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SysTextelement"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SysTextelement';
105	0.54 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
106	0.16 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
107	0.18 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
108	0.14 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
109	0.14 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
110	0.65 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
111	0.19 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SysProduct"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SysProduct';
112	0.56 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
113	0.19 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
114	0.15 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
115	0.15 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
116	0.17 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
117	0.47 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
118	0.63 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
119	0.21 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
120	0.15 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
121	0.12 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
122	0.12 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
123	0.64 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
124	0.71 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
125	0.25 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
126	0.17 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
127	0.24 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
128	0.16 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
129	0.51 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
130	0.63 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
131	0.21 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
132	0.20 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
133	0.17 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
134	0.21 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
135	0.55 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
136	0.31 ms	SELECT * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority Parameters: [`29`] View formatted query View runnable query Explain query SELECT * FROM plugin_pim_rawitemField WHERE dataportId = ? ORDER BY priority SELECT * FROM plugin_pim_rawitemField WHERE dataportId = 29 ORDER BY priority;
137	0.41 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
138	0.20 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
139	0.14 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
140	0.13 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
141	0.25 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 1;
142	0.45 ms	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 = ? Parameters: [`30530 "object" "object"`] View formatted query View runnable query Explain query 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';
143	0.25 ms	(SELECT id FROM objects WHERE path LIKE ?) Parameters: [`"/040 System-Collections/1/01BA/BA01/01/%"`] View formatted query View runnable query Explain query ( SELECT id FROM objects WHERE path LIKE ? ) (SELECT id FROM objects WHERE path LIKE '/040 System-Collections/1/01BA/BA01/01/%');
144	0.53 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
145	0.54 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
146	0.38 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
147	0.21 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
148	0.16 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
149	0.17 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
150	0.58 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
151	0.59 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
152	0.17 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
153	0.14 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
154	0.15 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
155	0.12 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
156	0.64 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
157	0.52 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
158	0.15 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
159	0.13 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
160	0.14 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
161	0.13 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
162	0.68 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
163	0.21 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SysTextelementFolder"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SysTextelementFolder';
164	0.67 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
165	0.21 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
166	0.20 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
167	0.16 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
168	0.16 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
169	0.70 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
170	0.61 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
171	0.20 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
172	0.21 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
173	0.21 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
174	0.17 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
175	4.31 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
176	0.63 ms	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 Parameters: [] View formatted query View runnable query Explain query 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 ;
177	0.21 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30528`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30528;
178	0.15 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`30527`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 30527;
179	0.17 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`29119`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 29119;
180	0.16 ms	SELECT parentId AS parentId FROM objects WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT parentId AS parentId FROM objects WHERE id = ? SELECT parentId AS parentId FROM objects WHERE id = 2;
181	4.18 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.

Symfony Profiler

GET http://pimcore.dev.remmers.cloud/admin/BlackbitDataDirector/importconfig/can-be-executed?_dc=1776776211462&id=30530&type=object

Configuration Settings

Theme

Page Width