Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

237 Database Queries

53 Different statements

464.40 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT id FROM targeting_rules WHERE active = 1  ORDER BY `prio` ASC
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
                LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                    WHERE o_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_store_CAR WHERE oo_id = ?
SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_brick_store_Dimensions_CAR WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Transmission_CAR WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Bodywork_CAR WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Engine_CAR WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_SaleInformation_CAR WHERE o_id = ? AND fieldname = ?
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT * FROM object_relations_CAR WHERE src_id = ?
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '143'
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
                LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                    WHERE o_id = ?
SELECT * FROM object_store_CAR WHERE oo_id = ?
SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_brick_store_Dimensions_CAR WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Transmission_CAR WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Bodywork_CAR WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_Engine_CAR WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_brick_store_SaleInformation_CAR WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_relations_CAR WHERE src_id = ?
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT COUNT(*) AS `totalCount` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder'))
SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder'))
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT COUNT(*) AS `totalCount` FROM `object_2` WHERE ((reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder'))
SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ((reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder'))
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
                LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                    WHERE o_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_store_2 WHERE oo_id = ?
SELECT * FROM object_relations_2 WHERE src_id = ?
SELECT COUNT(*) AS `totalCount` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder'))
SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder'))
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
                LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                    WHERE o_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_store_1 WHERE oo_id = ?
SELECT * FROM object_relations_1 WHERE src_id = ?
SELECT COUNT(*) AS `totalCount` FROM `object_2` WHERE ((reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder'))
SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ((reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder'))
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT COUNT(*) AS `totalCount` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder'))
SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder'))
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
                LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                    WHERE o_id = ?
SELECT * FROM object_store_1 WHERE oo_id = ?
SELECT * FROM object_relations_1 WHERE src_id = ?
SELECT COUNT(*) AS `totalCount` FROM `object_2` WHERE ((reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder'))
SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ((reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder'))
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1  ORDER BY `prio` ASC
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
            LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                WHERE o_id = ?
SELECT object_localized_AP_en.o_id as o_id, `object_localized_AP_en`.`o_type` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND  object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
                LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                    WHERE o_id = ?
SELECT * FROM object_store_AP WHERE oo_id = ?
SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_brick_store_SaleInformation_AP WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_relations_AP WHERE src_id = ?
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT objects.*, tree_locks.locked as o_locked FROM objects
                LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object'
                    WHERE o_id = ?
SELECT * FROM object_store_AP WHERE oo_id = ?
SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM assets_metadata WHERE cid = ?
SELECT * FROM object_brick_store_SaleInformation_AP WHERE o_id = ? AND fieldname = ?
SELECT * FROM object_relations_AP WHERE src_id = ?
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC
SELECT COUNT(*) AS `totalCount` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND  object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1)
SELECT COUNT(*) AS `totalCount` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND  object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1)
SELECT object_localized_AP_en.o_id as o_id, `object_localized_AP_en`.`o_type` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND  object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1)
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '486'
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT * FROM tmp_store WHERE id = ?
DELETE FROM tmp_store WHERE id = ?
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM tmp_store WHERE id = ?
DELETE FROM tmp_store WHERE id = ?
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '487'
SELECT * FROM tmp_store WHERE id = ?
DELETE FROM tmp_store WHERE id = ?
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM tmp_store WHERE id = ?
DELETE FROM tmp_store WHERE id = ?
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '489'
SELECT * FROM tmp_store WHERE id = ?
DELETE FROM tmp_store WHERE id = ?
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM tmp_store WHERE id = ?
DELETE FROM tmp_store WHERE id = ?
INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT * FROM documents_elements WHERE documentId = ?
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)
SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)

#▲	Time	Info
1	10.87 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "site_domain_07cdbc04ad1b1e1679a206203523d33f" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_domain_07cdbc04ad1b1e1679a206203523d33f');
2	2.55 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-300-SL~p143" "sourcePathQuery" => "/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-300-SL~p143" "sourceEntireUri" => "https://pimcore.agmarketing.group/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-300-SL~p143" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = : sourcePath AND ( `type` = : typePath OR `type` = : typeAuto ) ) OR ( source = : sourcePathQuery AND `type` = : typePathQuery ) OR ( source = : sourceEntireUri AND `type` = : typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-300-SL~p143' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-300-SL~p143' AND `type` = 'path_query') OR (source = 'https://pimcore.agmarketing.group/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-300-SL~p143' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
3	0.94 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "system_route_redirect" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('system_route_redirect');
4	0.94 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "Mercedes-Benz-300-SL~p143" "path" => "/en/shop/Products/Cars/Sports-Cars/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/en/shop/Products/Cars/Sports-Cars/' AND `key` = 'Mercedes-Benz-300-SL~p143';
5	0.70 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-300-SL~p143"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-300-SL~p143';
6	0.76 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "Sports-Cars" "path" => "/en/shop/Products/Cars/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/en/shop/Products/Cars/' AND `key` = 'Sports-Cars';
7	0.72 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en/shop/Products/Cars/Sports-Cars"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en/shop/Products/Cars/Sports-Cars';
8	0.19 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "Cars" "path" => "/en/shop/Products/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/en/shop/Products/' AND `key` = 'Cars';
9	0.77 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en/shop/Products/Cars"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en/shop/Products/Cars';
10	0.71 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "Products" "path" => "/en/shop/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/en/shop/' AND `key` = 'Products';
11	0.65 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en/shop/Products"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en/shop/Products';
12	0.44 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "shop" "path" => "/en/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/en/' AND `key` = 'shop';
13	0.93 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en/shop"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en/shop';
14	0.19 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "en" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/' AND `key` = 'en';
15	0.63 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "document_3" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_3');
16	0.99 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "document_properties_3" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_properties_3');
17	3.16 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
18	0.26 ms	SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC;
19	0.15 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 1;
20	0.15 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 2;
21	0.14 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 3;
22	0.12 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 4;
23	0.12 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 6;
24	0.12 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 7;
25	0.14 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 8;
26	1.49 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 9;
27	0.33 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 10;
28	5.73 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1');
29	0.31 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1');
30	0.26 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1');
31	0.27 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "Sports-Cars-Fan" "path" => "/Customer Management/segments/calculated/Interest-Target-Groups/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = : path AND `o_key` = : key SELECT o_id FROM objects WHERE o_path = '/Customer Management/segments/calculated/Interest-Target-Groups/' AND `o_key` = 'Sports-Cars-Fan';
32	1.61 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_875" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_875');
33	1.77 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = : path AND `o_key` = : key SELECT o_id FROM objects WHERE o_path = '/Customer Management/segments/calculated/VisitingCount/' AND `o_key` = 'at least once';
34	3.72 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_860" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_860');
35	0.38 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = : path AND `o_key` = : key SELECT o_id FROM objects WHERE o_path = '/Customer Management/segments/calculated/VisitingCount/' AND `o_key` = 'at least once';
36	1.84 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1');
37	3.44 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = : path AND `o_key` = : key SELECT o_id FROM objects WHERE o_path = '/Customer Management/segments/calculated/VisitingCount/' AND `o_key` = 'at least once';
38	0.38 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1');
39	0.24 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = : path AND `o_key` = : key SELECT o_id FROM objects WHERE o_path = '/Customer Management/segments/calculated/VisitingCount/' AND `o_key` = 'at least once';
40	0.17 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1');
41	2.53 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_143" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_143');
42	2.54 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`143`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 143;
43	1.48 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`143`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 143;
44	0.30 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CAR"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CAR';
45	5.27 ms	SELECT * FROM object_store_CAR WHERE oo_id = ? Parameters: [`143`] View formatted query View runnable query Explain query SELECT * FROM object_store_CAR WHERE oo_id = ? SELECT * FROM object_store_CAR WHERE oo_id = 143;
46	1.83 ms	SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`143`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CAR WHERE ooo_id = 143 AND language IN ('en','de','fr');
47	2.94 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "asset_121" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('asset_121');
48	1.36 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`121`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 121;
49	1.52 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`"121"`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = '121';
50	0.46 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`121`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 121;
51	3.69 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`"121"`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = '121';
52	1.93 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "asset_122" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('asset_122');
53	1.67 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`122`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 122;
54	2.14 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`"122"`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = '122';
55	0.19 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`122`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 122;
56	0.14 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`"122"`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = '122';
57	0.95 ms	SELECT * FROM object_brick_store_Dimensions_CAR WHERE o_id = ? AND fieldname = ? Parameters: [`143 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Dimensions_CAR WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Dimensions_CAR WHERE o_id = 143 AND fieldname = 'attributes';
58	0.75 ms	SELECT * FROM object_brick_store_Transmission_CAR WHERE o_id = ? AND fieldname = ? Parameters: [`143 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Transmission_CAR WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Transmission_CAR WHERE o_id = 143 AND fieldname = 'attributes';
59	1.08 ms	SELECT * FROM object_brick_store_Bodywork_CAR WHERE o_id = ? AND fieldname = ? Parameters: [`143 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Bodywork_CAR WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Bodywork_CAR WHERE o_id = 143 AND fieldname = 'attributes';
60	0.94 ms	SELECT * FROM object_brick_store_Engine_CAR WHERE o_id = ? AND fieldname = ? Parameters: [`143 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Engine_CAR WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Engine_CAR WHERE o_id = 143 AND fieldname = 'attributes';
61	1.78 ms	SELECT * FROM object_brick_store_SaleInformation_CAR WHERE o_id = ? AND fieldname = ? Parameters: [`143 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_CAR WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_CAR WHERE o_id = 143 AND fieldname = 'saleInformation';
62	1.51 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "quantityvalue_units_table" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('quantityvalue_units_table');
63	0.99 ms	SELECT * FROM object_relations_CAR WHERE src_id = ? Parameters: [`143`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CAR WHERE src_id = ? SELECT * FROM object_relations_CAR WHERE src_id = 143;
64	1.54 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '143' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '143' SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '143';
65	1.91 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_142" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_142');
66	2.51 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`142`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 142;
67	0.42 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`142`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 142;
68	0.85 ms	SELECT * FROM object_store_CAR WHERE oo_id = ? Parameters: [`142`] View formatted query View runnable query Explain query SELECT * FROM object_store_CAR WHERE oo_id = ? SELECT * FROM object_store_CAR WHERE oo_id = 142;
69	1.19 ms	SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`142`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_CAR WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_CAR WHERE ooo_id = 142 AND language IN ('en','de','fr');
70	0.24 ms	SELECT * FROM object_brick_store_Dimensions_CAR WHERE o_id = ? AND fieldname = ? Parameters: [`142 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Dimensions_CAR WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Dimensions_CAR WHERE o_id = 142 AND fieldname = 'attributes';
71	0.68 ms	SELECT * FROM object_brick_store_Transmission_CAR WHERE o_id = ? AND fieldname = ? Parameters: [`142 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Transmission_CAR WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Transmission_CAR WHERE o_id = 142 AND fieldname = 'attributes';
72	0.51 ms	SELECT * FROM object_brick_store_Bodywork_CAR WHERE o_id = ? AND fieldname = ? Parameters: [`142 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Bodywork_CAR WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Bodywork_CAR WHERE o_id = 142 AND fieldname = 'attributes';
73	0.16 ms	SELECT * FROM object_brick_store_Engine_CAR WHERE o_id = ? AND fieldname = ? Parameters: [`142 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_Engine_CAR WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_Engine_CAR WHERE o_id = 142 AND fieldname = 'attributes';
74	0.13 ms	SELECT * FROM object_brick_store_SaleInformation_CAR WHERE o_id = ? AND fieldname = ? Parameters: [`142 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_CAR WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_CAR WHERE o_id = 142 AND fieldname = 'saleInformation';
75	0.49 ms	SELECT * FROM object_relations_CAR WHERE src_id = ? Parameters: [`142`] View formatted query View runnable query Explain query SELECT * FROM object_relations_CAR WHERE src_id = ? SELECT * FROM object_relations_CAR WHERE src_id = 142;
76	3.25 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_140" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_140');
77	2.02 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_134" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_134');
78	0.71 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_559" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_559');
79	2.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"CA"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'CA';
80	6.68 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_545" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_545');
81	1.00 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_390" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_390');
82	1.50 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_564" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_564');
83	2.38 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_389" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_389');
84	0.96 ms	SELECT COUNT() AS `totalCount` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND object_1.o_type IN ('object','folder')) Parameters: [`"Interest Manufacturer"`] View formatted query View runnable query Explain query SELECT COUNT() AS `totalCount` FROM `object_1` WHERE ( reference = ? and (calculated = 1) AND object_1.o_type IN ('object', 'folder') ) SELECT COUNT(*) AS `totalCount` FROM `object_1` WHERE (reference = 'Interest Manufacturer' and (calculated = 1) AND object_1.o_type IN ('object','folder'));
85	0.76 ms	SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND object_1.o_type IN ('object','folder')) Parameters: [`"Interest Manufacturer"`] View formatted query View runnable query Explain query SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE ( reference = ? and (calculated = 1) AND object_1.o_type IN ('object', 'folder') ) SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE (reference = 'Interest Manufacturer' and (calculated = 1) AND object_1.o_type IN ('object','folder'));
86	2.12 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_960" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_960');
87	0.62 ms	SELECT COUNT() AS `totalCount` FROM `object_2` WHERE ((reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder')) Parameters: [`"Mercedes" 960`] View formatted query View runnable query Explain query SELECT COUNT() AS `totalCount` FROM `object_2` WHERE ( (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object', 'folder') ) SELECT COUNT(*) AS `totalCount` FROM `object_2` WHERE ((reference = 'Mercedes') AND (group__id = 960) AND object_2.o_type IN ('object','folder'));
88	0.55 ms	SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ((reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder')) Parameters: [`"Mercedes" 960`] View formatted query View runnable query Explain query SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ( (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object', 'folder') ) SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ((reference = 'Mercedes') AND (group__id = 960) AND object_2.o_type IN ('object','folder'));
89	2.04 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_993" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_993');
90	1.27 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`993`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 993;
91	1.49 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`993`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 993;
92	0.25 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"2"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '2';
93	0.77 ms	SELECT * FROM object_store_2 WHERE oo_id = ? Parameters: [`993`] View formatted query View runnable query Explain query SELECT * FROM object_store_2 WHERE oo_id = ? SELECT * FROM object_store_2 WHERE oo_id = 993;
94	0.73 ms	SELECT * FROM object_relations_2 WHERE src_id = ? Parameters: [`993`] View formatted query View runnable query Explain query SELECT * FROM object_relations_2 WHERE src_id = ? SELECT * FROM object_relations_2 WHERE src_id = 993;
95	0.58 ms	SELECT COUNT() AS `totalCount` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND object_1.o_type IN ('object','folder')) Parameters: [`"Interest Car Class"`] View formatted query View runnable query Explain query SELECT COUNT() AS `totalCount` FROM `object_1` WHERE ( reference = ? and (calculated = 1) AND object_1.o_type IN ('object', 'folder') ) SELECT COUNT(*) AS `totalCount` FROM `object_1` WHERE (reference = 'Interest Car Class' and (calculated = 1) AND object_1.o_type IN ('object','folder'));
96	1.95 ms	SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND object_1.o_type IN ('object','folder')) Parameters: [`"Interest Car Class"`] View formatted query View runnable query Explain query SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE ( reference = ? and (calculated = 1) AND object_1.o_type IN ('object', 'folder') ) SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE (reference = 'Interest Car Class' and (calculated = 1) AND object_1.o_type IN ('object','folder'));
97	1.69 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_962" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_962');
98	0.77 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`962`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 962;
99	1.42 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`962`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 962;
100	0.92 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '1';
101	0.96 ms	SELECT * FROM object_store_1 WHERE oo_id = ? Parameters: [`962`] View formatted query View runnable query Explain query SELECT * FROM object_store_1 WHERE oo_id = ? SELECT * FROM object_store_1 WHERE oo_id = 962;
102	0.26 ms	SELECT * FROM object_relations_1 WHERE src_id = ? Parameters: [`962`] View formatted query View runnable query Explain query SELECT * FROM object_relations_1 WHERE src_id = ? SELECT * FROM object_relations_1 WHERE src_id = 962;
103	0.23 ms	SELECT COUNT() AS `totalCount` FROM `object_2` WHERE ((reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder')) Parameters: [`"sports car" 962`] View formatted query View runnable query Explain query SELECT COUNT() AS `totalCount` FROM `object_2` WHERE ( (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object', 'folder') ) SELECT COUNT(*) AS `totalCount` FROM `object_2` WHERE ((reference = 'sports car') AND (group__id = 962) AND object_2.o_type IN ('object','folder'));
104	0.67 ms	SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ((reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder')) Parameters: [`"sports car" 962`] View formatted query View runnable query Explain query SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ( (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object', 'folder') ) SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ((reference = 'sports car') AND (group__id = 962) AND object_2.o_type IN ('object','folder'));
105	1.33 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_963" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_963');
106	0.74 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_7" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_7');
107	1.21 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BS"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BS';
108	1.23 ms	SELECT COUNT() AS `totalCount` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND object_1.o_type IN ('object','folder')) Parameters: [`"Interest Body Style"`] View formatted query View runnable query Explain query SELECT COUNT() AS `totalCount` FROM `object_1` WHERE ( reference = ? and (calculated = 1) AND object_1.o_type IN ('object', 'folder') ) SELECT COUNT(*) AS `totalCount` FROM `object_1` WHERE (reference = 'Interest Body Style' and (calculated = 1) AND object_1.o_type IN ('object','folder'));
109	4.48 ms	SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE (reference = ? and (calculated = 1) AND object_1.o_type IN ('object','folder')) Parameters: [`"Interest Body Style"`] View formatted query View runnable query Explain query SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE ( reference = ? and (calculated = 1) AND object_1.o_type IN ('object', 'folder') ) SELECT object_1.o_id as o_id, `object_1`.`o_type` FROM `object_1` WHERE (reference = 'Interest Body Style' and (calculated = 1) AND object_1.o_type IN ('object','folder'));
110	1.31 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_964" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_964');
111	0.51 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`964`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 964;
112	0.54 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`964`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 964;
113	1.16 ms	SELECT * FROM object_store_1 WHERE oo_id = ? Parameters: [`964`] View formatted query View runnable query Explain query SELECT * FROM object_store_1 WHERE oo_id = ? SELECT * FROM object_store_1 WHERE oo_id = 964;
114	0.30 ms	SELECT * FROM object_relations_1 WHERE src_id = ? Parameters: [`964`] View formatted query View runnable query Explain query SELECT * FROM object_relations_1 WHERE src_id = ? SELECT * FROM object_relations_1 WHERE src_id = 964;
115	0.71 ms	SELECT COUNT() AS `totalCount` FROM `object_2` WHERE ((reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder')) Parameters: [`"2-door coupé" 964`] View formatted query View runnable query Explain query SELECT COUNT() AS `totalCount` FROM `object_2` WHERE ( (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object', 'folder') ) SELECT COUNT(*) AS `totalCount` FROM `object_2` WHERE ((reference = '2-door coupé') AND (group__id = 964) AND object_2.o_type IN ('object','folder'));
116	0.86 ms	SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ((reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder')) Parameters: [`"2-door coupé" 964`] View formatted query View runnable query Explain query SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ( (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object', 'folder') ) SELECT object_2.o_id as o_id, `object_2`.`o_type` FROM `object_2` WHERE ((reference = '2-door coupé') AND (group__id = 964) AND object_2.o_type IN ('object','folder'));
117	1.93 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_973" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_973');
118	1.83 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_693" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_693');
119	0.32 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_OSTC"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_OSTC';
120	0.28 ms	SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC;
121	1.25 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "system_resource_columns_ecommerceframework_pricing_rule" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('system_resource_columns_ecommerceframework_pricing_rule');
122	0.17 ms	SELECT * FROM ecommerceframework_pricing_rule WHERE id='9' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ecommerceframework_pricing_rule WHERE id = '9' SELECT * FROM ecommerceframework_pricing_rule WHERE id='9';
123	2.57 ms	SELECT * FROM ecommerceframework_pricing_rule WHERE id='10' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ecommerceframework_pricing_rule WHERE id = '10' SELECT * FROM ecommerceframework_pricing_rule WHERE id='10';
124	0.77 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_556" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_556');
125	0.23 ms	SELECT * FROM ecommerceframework_pricing_rule WHERE id='8' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ecommerceframework_pricing_rule WHERE id = '8' SELECT * FROM ecommerceframework_pricing_rule WHERE id='8';
126	1.54 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_75" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_75');
127	3.43 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_74" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_74');
128	0.40 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "citroen-2cv-head lights" "path" => "/Product Data/Accessories/lights/head lights/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = : path AND `o_key` = : key SELECT o_id FROM objects WHERE o_path = '/Product Data/Accessories/lights/head lights/' AND `o_key` = 'citroen-2cv-head lights';
129	0.46 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_438" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_438');
130	1.43 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"AP"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'AP';
131	0.29 ms	SELECT * FROM ecommerceframework_pricing_rule WHERE id='6' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ecommerceframework_pricing_rule WHERE id = '6' SELECT * FROM ecommerceframework_pricing_rule WHERE id='6';
132	2.61 ms	SELECT * FROM ecommerceframework_pricing_rule WHERE id='7' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ecommerceframework_pricing_rule WHERE id = '7' SELECT * FROM ecommerceframework_pricing_rule WHERE id='7';
133	0.64 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_399" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_399');
134	0.56 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_873" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_873');
135	2.12 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_135" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_135');
136	1.04 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`135`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 135;
137	1.26 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`135`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 135;
138	1.30 ms	SELECT object_localized_AP_en.o_id as o_id, `object_localized_AP_en`.`o_type` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1) Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_AP_en.o_id as o_id, `object_localized_AP_en`.`o_type` FROM `object_localized_AP_en` WHERE ( ( compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object', 'folder') ) AND object_localized_AP_en.o_published = 1 ) SELECT object_localized_AP_en.o_id as o_id, `object_localized_AP_en`.`o_type` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1);
139	2.84 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_486" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_486');
140	1.36 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`486`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 486;
141	13.03 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`486`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 486;
142	2.28 ms	SELECT * FROM object_store_AP WHERE oo_id = ? Parameters: [`486`] View formatted query View runnable query Explain query SELECT * FROM object_store_AP WHERE oo_id = ? SELECT * FROM object_store_AP WHERE oo_id = 486;
143	0.27 ms	SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`486`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_AP WHERE ooo_id = 486 AND language IN ('en','de','fr');
144	3.50 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "asset_125" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('asset_125');
145	0.88 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`125`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 125;
146	0.86 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`"125"`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = '125';
147	0.19 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`125`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 125;
148	0.16 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`"125"`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = '125';
149	0.75 ms	SELECT * FROM object_brick_store_SaleInformation_AP WHERE o_id = ? AND fieldname = ? Parameters: [`486 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_AP WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_AP WHERE o_id = 486 AND fieldname = 'saleInformation';
150	0.78 ms	SELECT * FROM object_relations_AP WHERE src_id = ? Parameters: [`486`] View formatted query View runnable query Explain query SELECT * FROM object_relations_AP WHERE src_id = ? SELECT * FROM object_relations_AP WHERE src_id = 486;
151	2.40 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_487" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_487');
152	2.52 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_489" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_489');
153	2.29 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`489`] View formatted query View runnable query Explain query SELECT o_type, o_className, o_classId FROM objects WHERE o_id = ? SELECT o_type,o_className,o_classId FROM objects WHERE o_id = 489;
154	0.95 ms	SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? Parameters: [`489`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ? SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = 489;
155	0.15 ms	SELECT * FROM object_store_AP WHERE oo_id = ? Parameters: [`489`] View formatted query View runnable query Explain query SELECT * FROM object_store_AP WHERE oo_id = ? SELECT * FROM object_store_AP WHERE oo_id = 489;
156	0.71 ms	SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`489`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_AP WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_AP WHERE ooo_id = 489 AND language IN ('en','de','fr');
157	16.54 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "asset_124" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('asset_124');
158	0.82 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`124`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 124;
159	0.85 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`"124"`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = '124';
160	0.22 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`124`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 124;
161	0.18 ms	SELECT * FROM assets_metadata WHERE cid = ? Parameters: [`"124"`] View formatted query View runnable query Explain query SELECT * FROM assets_metadata WHERE cid = ? SELECT * FROM assets_metadata WHERE cid = '124';
162	0.73 ms	SELECT * FROM object_brick_store_SaleInformation_AP WHERE o_id = ? AND fieldname = ? Parameters: [`489 "saleInformation"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SaleInformation_AP WHERE o_id = ? AND fieldname = ? SELECT * FROM object_brick_store_SaleInformation_AP WHERE o_id = 489 AND fieldname = 'saleInformation';
163	1.32 ms	SELECT * FROM object_relations_AP WHERE src_id = ? Parameters: [`489`] View formatted query View runnable query Explain query SELECT * FROM object_relations_AP WHERE src_id = ? SELECT * FROM object_relations_AP WHERE src_id = 489;
164	5.82 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_394" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_394');
165	4.10 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_364" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_364');
166	1.36 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_396" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_396');
167	3.10 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_365" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_365');
168	1.24 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_397" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_397');
169	0.57 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_362" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_362');
170	0.66 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "document_1" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_1');
171	5.06 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "document_properties_1" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_properties_1');
172	6.74 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "nav_ea3dea8fae8432be2613c1d55f55b7ab" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('nav_ea3dea8fae8432be2613c1d55f55b7ab');
173	3.10 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "translation_data_messages_en" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('translation_data_messages_en');
174	0.28 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 1;
175	0.12 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`1 1 1`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(1, 1) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 1;
176	0.28 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "de" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/' AND `key` = 'de';
177	1.07 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "document_136" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_136');
178	2.33 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "fr" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/' AND `key` = 'fr';
179	0.38 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/fr"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/fr';
180	6.14 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "nav_d74f487a3074b19f20c1eac992827746" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('nav_d74f487a3074b19f20c1eac992827746');
181	2.37 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_2" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_2');
182	0.98 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_744" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_744');
183	0.80 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_1" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_1');
184	0.84 ms	SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC Parameters: [`142`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ( ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ) ORDER BY `o_key` ASC SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = 142 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC;
185	0.86 ms	SELECT COUNT() AS `totalCount` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1) Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS `totalCount` FROM `object_localized_AP_en` WHERE ( ( compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object', 'folder') ) AND object_localized_AP_en.o_published = 1 ) SELECT COUNT(*) AS `totalCount` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1);
186	0.22 ms	SELECT COUNT() AS `totalCount` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1) Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS `totalCount` FROM `object_localized_AP_en` WHERE ( ( compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object', 'folder') ) AND object_localized_AP_en.o_published = 1 ) SELECT COUNT(*) AS `totalCount` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1);
187	0.13 ms	SELECT object_localized_AP_en.o_id as o_id, `object_localized_AP_en`.`o_type` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1) Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_AP_en.o_id as o_id, `object_localized_AP_en`.`o_type` FROM `object_localized_AP_en` WHERE ( ( compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object', 'folder') ) AND object_localized_AP_en.o_published = 1 ) SELECT object_localized_AP_en.o_id as o_id, `object_localized_AP_en`.`o_type` FROM `object_localized_AP_en` WHERE ((compatibleTo LIKE "%,143,%" OR compatibleTo LIKE "%,142,%" OR compatibleTo LIKE "%,140,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1);
188	1.38 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '486' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '486' SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '486';
189	5.16 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_393" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_393');
190	0.64 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "object_392" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('object_392');
191	5.13 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_125__b7583f8144a46fcda6dfdc7606dd5636"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_125__b7583f8144a46fcda6dfdc7606dd5636';
192	21.93 ms	DELETE FROM tmp_store WHERE id = ? Parameters: [`"thumb_125__b7583f8144a46fcda6dfdc7606dd5636"`] View formatted query View runnable query Explain query DELETE FROM tmp_store WHERE id = ? DELETE FROM tmp_store WHERE id = 'thumb_125__b7583f8144a46fcda6dfdc7606dd5636';
193	8.02 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_125__b7583f8144a46fcda6dfdc7606dd5636" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:5:"items";a:2:{i:0;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";d:29.2;s:6:"height";d:55.16014234875445;s:1:"y";d:11.743772241992882;s:1:"x";d:20.8;}}i:1;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";i:350;s:6:"height";i:235;s:11:"positioning";s:6:"center";s:11:"forceResize";b:0;}}}s:6:"medias";a:0:{}s:4:"name";s:42:"grid_auto_68755c44df8e34c9cb83bcebc04f5703";s:11:"description";s:0:"";s:5:"group";s:10:"E-Commerce";s:6:"format";s:6:"SOURCE";s:7:"quality";i:85;s:14:"highResolution";d:0;s:13:"preserveColor";b:0;s:16:"preserveMetaData";b:0;s:12:"rasterizeSVG";b:0;s:12:"downloadable";b:0;s:16:"modificationDate";i:1566220974;s:12:"creationDate";i:1562150477;s:14:"filenameSuffix";N;s:15:"forcePictureTag";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1731637159 ":col4" => 1732241959 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( : col0, : col1, : col2, : col3, : col4, : col5 ) ON DUPLICATE KEY UPDATE `id` = : col0, `data` = : col1, `tag` = : col2, `date` = : col3, `expiryDate` = : col4, `serialized` = : col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
194	0.60 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_125__b7583f8144a46fcda6dfdc7606dd5636"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_125__b7583f8144a46fcda6dfdc7606dd5636';
195	10.46 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_125__3767b978740e1472ca6ca977234b50a1"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_125__3767b978740e1472ca6ca977234b50a1';
196	3.75 ms	DELETE FROM tmp_store WHERE id = ? Parameters: [`"thumb_125__3767b978740e1472ca6ca977234b50a1"`] View formatted query View runnable query Explain query DELETE FROM tmp_store WHERE id = ? DELETE FROM tmp_store WHERE id = 'thumb_125__3767b978740e1472ca6ca977234b50a1';
197	3.21 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_125__3767b978740e1472ca6ca977234b50a1" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:5:"items";a:2:{i:0;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";d:29.2;s:6:"height";d:55.16014234875445;s:1:"y";d:11.743772241992882;s:1:"x";d:20.8;}}i:1;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";i:350;s:6:"height";i:235;s:11:"positioning";s:6:"center";s:11:"forceResize";b:0;}}}s:6:"medias";a:0:{}s:4:"name";s:42:"grid_auto_68755c44df8e34c9cb83bcebc04f5703";s:11:"description";s:0:"";s:5:"group";s:10:"E-Commerce";s:6:"format";s:6:"SOURCE";s:7:"quality";i:85;s:14:"highResolution";d:2;s:13:"preserveColor";b:0;s:16:"preserveMetaData";b:0;s:12:"rasterizeSVG";b:0;s:12:"downloadable";b:0;s:16:"modificationDate";i:1566220974;s:12:"creationDate";i:1562150477;s:14:"filenameSuffix";N;s:15:"forcePictureTag";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1731637159 ":col4" => 1732241959 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( : col0, : col1, : col2, : col3, : col4, : col5 ) ON DUPLICATE KEY UPDATE `id` = : col0, `data` = : col1, `tag` = : col2, `date` = : col3, `expiryDate` = : col4, `serialized` = : col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
198	0.61 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '487' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '487' SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '487';
199	1.72 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_126__4a4468aa9e0ed473750e968ee08971ff"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_126__4a4468aa9e0ed473750e968ee08971ff';
200	2.71 ms	DELETE FROM tmp_store WHERE id = ? Parameters: [`"thumb_126__4a4468aa9e0ed473750e968ee08971ff"`] View formatted query View runnable query Explain query DELETE FROM tmp_store WHERE id = ? DELETE FROM tmp_store WHERE id = 'thumb_126__4a4468aa9e0ed473750e968ee08971ff';
201	2.63 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_126__4a4468aa9e0ed473750e968ee08971ff" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:5:"items";a:2:{i:0;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";i:20;s:6:"height";d:35.587188612099645;s:1:"y";d:34.163701067615655;s:1:"x";d:6.8;}}i:1;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";i:350;s:6:"height";i:235;s:11:"positioning";s:6:"center";s:11:"forceResize";b:0;}}}s:6:"medias";a:0:{}s:4:"name";s:42:"grid_auto_d1725d6c3e4820bb8b6bed5a2c05f50a";s:11:"description";s:0:"";s:5:"group";s:10:"E-Commerce";s:6:"format";s:6:"SOURCE";s:7:"quality";i:85;s:14:"highResolution";d:0;s:13:"preserveColor";b:0;s:16:"preserveMetaData";b:0;s:12:"rasterizeSVG";b:0;s:12:"downloadable";b:0;s:16:"modificationDate";i:1566220974;s:12:"creationDate";i:1562150477;s:14:"filenameSuffix";N;s:15:"forcePictureTag";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1731637159 ":col4" => 1732241959 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( : col0, : col1, : col2, : col3, : col4, : col5 ) ON DUPLICATE KEY UPDATE `id` = : col0, `data` = : col1, `tag` = : col2, `date` = : col3, `expiryDate` = : col4, `serialized` = : col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
202	0.65 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_126__4a4468aa9e0ed473750e968ee08971ff"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_126__4a4468aa9e0ed473750e968ee08971ff';
203	1.57 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_126__8907342b0440c97d745e8345bdc60840"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_126__8907342b0440c97d745e8345bdc60840';
204	8.05 ms	DELETE FROM tmp_store WHERE id = ? Parameters: [`"thumb_126__8907342b0440c97d745e8345bdc60840"`] View formatted query View runnable query Explain query DELETE FROM tmp_store WHERE id = ? DELETE FROM tmp_store WHERE id = 'thumb_126__8907342b0440c97d745e8345bdc60840';
205	3.19 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_126__8907342b0440c97d745e8345bdc60840" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:5:"items";a:2:{i:0;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";i:20;s:6:"height";d:35.587188612099645;s:1:"y";d:34.163701067615655;s:1:"x";d:6.8;}}i:1;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";i:350;s:6:"height";i:235;s:11:"positioning";s:6:"center";s:11:"forceResize";b:0;}}}s:6:"medias";a:0:{}s:4:"name";s:42:"grid_auto_d1725d6c3e4820bb8b6bed5a2c05f50a";s:11:"description";s:0:"";s:5:"group";s:10:"E-Commerce";s:6:"format";s:6:"SOURCE";s:7:"quality";i:85;s:14:"highResolution";d:2;s:13:"preserveColor";b:0;s:16:"preserveMetaData";b:0;s:12:"rasterizeSVG";b:0;s:12:"downloadable";b:0;s:16:"modificationDate";i:1566220974;s:12:"creationDate";i:1562150477;s:14:"filenameSuffix";N;s:15:"forcePictureTag";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1731637159 ":col4" => 1732241959 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( : col0, : col1, : col2, : col3, : col4, : col5 ) ON DUPLICATE KEY UPDATE `id` = : col0, `data` = : col1, `tag` = : col2, `date` = : col3, `expiryDate` = : col4, `serialized` = : col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
206	0.71 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '489' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '489' SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '489';
207	1.84 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_124__4dcede82c4026097269d5317cd985582"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_124__4dcede82c4026097269d5317cd985582';
208	10.85 ms	DELETE FROM tmp_store WHERE id = ? Parameters: [`"thumb_124__4dcede82c4026097269d5317cd985582"`] View formatted query View runnable query Explain query DELETE FROM tmp_store WHERE id = ? DELETE FROM tmp_store WHERE id = 'thumb_124__4dcede82c4026097269d5317cd985582';
209	10.97 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_124__4dcede82c4026097269d5317cd985582" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:5:"items";a:2:{i:0;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";d:16.4;s:6:"height";d:26.334519572953738;s:1:"y";d:71.53024911032028;s:1:"x";d:22.2;}}i:1;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";i:350;s:6:"height";i:235;s:11:"positioning";s:6:"center";s:11:"forceResize";b:0;}}}s:6:"medias";a:0:{}s:4:"name";s:42:"grid_auto_b5ed6f72323b2d5c4d77c7a453ee4491";s:11:"description";s:0:"";s:5:"group";s:10:"E-Commerce";s:6:"format";s:6:"SOURCE";s:7:"quality";i:85;s:14:"highResolution";d:0;s:13:"preserveColor";b:0;s:16:"preserveMetaData";b:0;s:12:"rasterizeSVG";b:0;s:12:"downloadable";b:0;s:16:"modificationDate";i:1566220974;s:12:"creationDate";i:1562150477;s:14:"filenameSuffix";N;s:15:"forcePictureTag";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1731637159 ":col4" => 1732241959 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( : col0, : col1, : col2, : col3, : col4, : col5 ) ON DUPLICATE KEY UPDATE `id` = : col0, `data` = : col1, `tag` = : col2, `date` = : col3, `expiryDate` = : col4, `serialized` = : col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
210	0.44 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_124__4dcede82c4026097269d5317cd985582"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_124__4dcede82c4026097269d5317cd985582';
211	3.57 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_124__15f5cf9761350ddfcc5aaaf4d4efa0ff"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_124__15f5cf9761350ddfcc5aaaf4d4efa0ff';
212	8.14 ms	DELETE FROM tmp_store WHERE id = ? Parameters: [`"thumb_124__15f5cf9761350ddfcc5aaaf4d4efa0ff"`] View formatted query View runnable query Explain query DELETE FROM tmp_store WHERE id = ? DELETE FROM tmp_store WHERE id = 'thumb_124__15f5cf9761350ddfcc5aaaf4d4efa0ff';
213	9.53 ms	INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5; Parameters: [":col0" => "thumb_124__15f5cf9761350ddfcc5aaaf4d4efa0ff" ":col1" => "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":16:{s:5:"items";a:2:{i:0;a:2:{s:6:"method";s:11:"cropPercent";s:9:"arguments";a:4:{s:5:"width";d:16.4;s:6:"height";d:26.334519572953738;s:1:"y";d:71.53024911032028;s:1:"x";d:22.2;}}i:1;a:2:{s:6:"method";s:5:"cover";s:9:"arguments";a:4:{s:5:"width";i:350;s:6:"height";i:235;s:11:"positioning";s:6:"center";s:11:"forceResize";b:0;}}}s:6:"medias";a:0:{}s:4:"name";s:42:"grid_auto_b5ed6f72323b2d5c4d77c7a453ee4491";s:11:"description";s:0:"";s:5:"group";s:10:"E-Commerce";s:6:"format";s:6:"SOURCE";s:7:"quality";i:85;s:14:"highResolution";d:2;s:13:"preserveColor";b:0;s:16:"preserveMetaData";b:0;s:12:"rasterizeSVG";b:0;s:12:"downloadable";b:0;s:16:"modificationDate";i:1566220974;s:12:"creationDate";i:1562150477;s:14:"filenameSuffix";N;s:15:"forcePictureTag";b:0;}" ":col2" => "thumbnail_deferred" ":col3" => 1731637159 ":col4" => 1732241959 ":col5" => 1] View formatted query View runnable query Explain query INSERT INTO `tmp_store` ( `id`, `data`, `tag`, `date`, `expiryDate`, `serialized` ) VALUES ( : col0, : col1, : col2, : col3, : col4, : col5 ) ON DUPLICATE KEY UPDATE `id` = : col0, `data` = : col1, `tag` = : col2, `date` = : col3, `expiryDate` = : col4, `serialized` = : col5; INSERT INTO `tmp_store` (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (:col0, :col1, :col2, :col3, :col4, :col5) ON DUPLICATE KEY UPDATE `id` = :col0, `data` = :col1, `tag` = :col2, `date` = :col3, `expiryDate` = :col4, `serialized` = :col5;;
214	5.21 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "document_12" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_12');
215	3.20 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "document_target_groups_12" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_target_groups_12');
216	0.42 ms	SELECT * FROM documents_elements WHERE documentId = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT * FROM documents_elements WHERE documentId = ? SELECT * FROM documents_elements WHERE documentId = 12;
217	1.67 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637159 [ "document_properties_12" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637159 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_properties_12');
218	5.41 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_74" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_74');
219	2.56 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_97" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_97');
220	11.69 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_99" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_99');
221	0.96 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_100" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_100');
222	1.50 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_101" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_101');
223	0.79 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_102" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_102');
224	0.84 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_103" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_103');
225	3.50 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_104" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_104');
226	0.78 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_48" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_48');
227	0.91 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_52" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_52');
228	3.26 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_112" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_112');
229	0.76 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_49" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_49');
230	1.41 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_113" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_113');
231	0.75 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_39" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_39');
232	0.75 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_50" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_50');
233	0.72 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_38" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_38');
234	2.56 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_51" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_51');
235	0.75 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_95" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_95');
236	1.28 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_110" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_110');
237	0.74 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1731637160 [ "document_88" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1731637160 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('document_88');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Symfony Profiler

https://pimcore.agmarketing.group/_fragment?_path=_locale%3Den%26_format%3Dhtml%26_controller%3DAppBundle%253ADefault%253Adefault

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

https://pimcore.agmarketing.group/_fragment?_path=_locale%3Den%26_format%3Dhtml%26_controller%3DAppBundle%253ADefault%253Adefault

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping