Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

132 Database Queries

33 Different statements

1143.06 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?,?)
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT * FROM documents_editables WHERE documentId = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT * FROM targeting_target_groups WHERE id = ?
SELECT * FROM targeting_target_groups WHERE id = ?
SELECT * FROM targeting_target_groups WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?,?)
SELECT name FROM classes WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '2073'
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT name FROM classes WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT COUNT(*) 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 as o_type FROM object_1 WHERE reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder')
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT COUNT(*) 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 as o_type FROM object_2 WHERE (reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder')
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT COUNT(*) 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 as o_type FROM object_1 WHERE reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder')
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT COUNT(*) 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 as o_type FROM object_2 WHERE (reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder')
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM website_settings WHERE name = ? AND (siteId IS NULL OR siteId = '' OR siteId = ?) AND  (language IS NULL OR language = '' OR language = ?) ORDER BY siteId,language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1  ORDER BY `prio` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?)
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
SELECT object_localized_AP_mn.o_id as o_id, object_localized_AP_mn.o_type as o_type FROM object_localized_AP_mn WHERE (compatibleTo LIKE "%,2073,%" AND  object_localized_AP_mn.o_type IN ('object','folder')) AND object_localized_AP_mn.o_published = 1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?,?)
SELECT * FROM translations_messages LIMIT 1;
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_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,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT id FROM documents WHERE path = :path AND `key` = :key
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?,?)
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT * FROM documents_editables WHERE documentId = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?)

#▲	Time	Info
1	0.39 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00site_domain_a1cb33e0ffd14c1d49594bf03aed9a60" 3 => "site_domain_a1cb33e0ffd14c1d49594bf03aed9a60"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_a1cb33e0ffd14c1d49594bf03aed9a60','site_domain_a1cb33e0ffd14c1d49594bf03aed9a60');
2	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?) Parameters: [`1 => 1727533070 2 => "system\x00tags\x00" 3 => "site\x00tags\x00" 4 => "site_domain_a1cb33e0ffd14c1d49594bf03aed9a60\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0','site\0tags\0','site_domain_a1cb33e0ffd14c1d49594bf03aed9a60\0tags\0');
3	0.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" => "/shop/Products/CAR-ACCESSORIES/Interior-Accessories/LITTLE-TREE-LITTLE-TREE-ctk-52431-24-nertegc-VENT-CLIP-paarny-Black-ice~p2073" "sourcePathQuery" => "/shop/Products/CAR-ACCESSORIES/Interior-Accessories/LITTLE-TREE-LITTLE-TREE-ctk-52431-24-nertegc-VENT-CLIP-paarny-Black-ice~p2073" "sourceEntireUri" => "http://202.131.233.39/shop/Products/CAR-ACCESSORIES/Interior-Accessories/LITTLE-TREE-LITTLE-TREE-ctk-52431-24-nertegc-VENT-CLIP-paarny-Black-ice~p2073" "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 = '/shop/Products/CAR-ACCESSORIES/Interior-Accessories/LITTLE-TREE-LITTLE-TREE-ctk-52431-24-nertegc-VENT-CLIP-paarny-Black-ice~p2073' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/shop/Products/CAR-ACCESSORIES/Interior-Accessories/LITTLE-TREE-LITTLE-TREE-ctk-52431-24-nertegc-VENT-CLIP-paarny-Black-ice~p2073' AND `type` = 'path_query') OR (source = 'http://202.131.233.39/shop/Products/CAR-ACCESSORIES/Interior-Accessories/LITTLE-TREE-LITTLE-TREE-ctk-52431-24-nertegc-VENT-CLIP-paarny-Black-ice~p2073' 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;
4	0.27 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00system_route_redirect" 3 => "system_route_redirect"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect','system_route_redirect');
5	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?,?) Parameters: [`1 => 1727533070 2 => "system\x00tags\x00" 3 => "redirect\x00tags\x00" 4 => "route\x00tags\x00" 5 => "system_route_redirect\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0','redirect\0tags\0','route\0tags\0','system_route_redirect\0tags\0');
6	0.27 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
7	0.50 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "LITTLE-TREE-LITTLE-TREE-ctk-52431-24-nertegc-VENT-CLIP-paarny-Black-ice~p2073" "path" => "/shop/Products/CAR-ACCESSORIES/Interior-Accessories/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = :path AND `key` = :key SELECT id FROM documents WHERE path = '/shop/Products/CAR-ACCESSORIES/Interior-Accessories/' AND `key` = 'LITTLE-TREE-LITTLE-TREE-ctk-52431-24-nertegc-VENT-CLIP-paarny-Black-ice~p2073';
8	0.23 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/shop/Products/CAR-ACCESSORIES/Interior-Accessories/LITTLE-TREE-LITTLE-TREE-ctk-52431-24-nertegc-VENT-CLIP-paarny-Black-ice~p2073"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/shop/Products/CAR-ACCESSORIES/Interior-Accessories/LITTLE-TREE-LITTLE-TREE-ctk-52431-24-nertegc-VENT-CLIP-paarny-Black-ice~p2073';
9	0.19 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "Interior-Accessories" "path" => "/shop/Products/CAR-ACCESSORIES/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = :path AND `key` = :key SELECT id FROM documents WHERE path = '/shop/Products/CAR-ACCESSORIES/' AND `key` = 'Interior-Accessories';
10	0.17 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/shop/Products/CAR-ACCESSORIES/Interior-Accessories"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/shop/Products/CAR-ACCESSORIES/Interior-Accessories';
11	0.15 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "CAR-ACCESSORIES" "path" => "/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 = '/shop/Products/' AND `key` = 'CAR-ACCESSORIES';
12	0.16 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/shop/Products/CAR-ACCESSORIES"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/shop/Products/CAR-ACCESSORIES';
13	0.15 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "Products" "path" => "/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 = '/shop/' AND `key` = 'Products';
14	0.15 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/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 = '/shop/Products';
15	0.15 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "shop" "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` = 'shop';
16	0.15 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/shop"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/shop';
17	0.17 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "" "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` = '';
18	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00document_1" 3 => "document_1"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1','document_1');
19	0.16 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533070 2 => "document_1\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0');
20	0.21 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00document_properties_1" 3 => "document_properties_1"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1','document_properties_1');
21	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?) Parameters: [`1 => 1727533070 2 => "document_properties\x00tags\x00" 3 => "document_1\x00tags\x00" 4 => "document_properties_1\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0','document_1\0tags\0','document_properties_1\0tags\0');
22	0.68 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;
23	0.43 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;
24	0.63 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00document_target_groups_1" 3 => "document_target_groups_1"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_target_groups_1','document_target_groups_1');
25	0.45 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1;
26	0.41 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00object_563" 3 => "object_563"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_563','object_563');
27	0.35 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "object_563\x00tags\x00" 3 => "class_EF_FD\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_563\0tags\0','class_EF_FD\0tags\0');
28	0.31 ms	SELECT * FROM targeting_target_groups WHERE id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM targeting_target_groups WHERE id = ? SELECT * FROM targeting_target_groups WHERE id = 4;
29	0.25 ms	SELECT * FROM targeting_target_groups WHERE id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM targeting_target_groups WHERE id = ? SELECT * FROM targeting_target_groups WHERE id = 5;
30	0.26 ms	SELECT * FROM targeting_target_groups WHERE id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM targeting_target_groups WHERE id = ? SELECT * FROM targeting_target_groups WHERE id = 6;
31	0.53 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00object_2073" 3 => "object_2073"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2073','object_2073');
32	0.42 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?,?) Parameters: [`1 => 1727533070 2 => "object_2073\x00tags\x00" 3 => "class_CAR\x00tags\x00" 4 => "asset_6637\x00tags\x00" 5 => "asset_6638\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2073\0tags\0','class_CAR\0tags\0','asset_6637\0tags\0','asset_6638\0tags\0');
33	0.31 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';
34	0.72 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00quantityvalue_units_table" 3 => "quantityvalue_units_table"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0quantityvalue_units_table','quantityvalue_units_table');
35	0.35 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533070 2 => "quantityvalue_units_table\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('quantityvalue_units_table\0tags\0');
36	0.62 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '2073' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '2073' SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '2073';
37	0.50 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00object_6161" 3 => "object_6161"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6161','object_6161');
38	0.42 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "object_6161\x00tags\x00" 3 => "class_MA\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6161\0tags\0','class_MA\0tags\0');
39	0.44 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00object_1143" 3 => "object_1143"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1143','object_1143');
40	0.37 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "object_1143\x00tags\x00" 3 => "class_CA\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1143\0tags\0','class_CA\0tags\0');
41	0.35 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';
42	0.50 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00object_1135" 3 => "object_1135"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1135','object_1135');
43	0.36 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "object_1135\x00tags\x00" 3 => "class_CA\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1135\0tags\0','class_CA\0tags\0');
44	0.45 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00object_1128" 3 => "object_1128"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1128','object_1128');
45	0.35 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "object_1128\x00tags\x00" 3 => "class_CA\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1128\0tags\0','class_CA\0tags\0');
46	0.36 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00object_564" 3 => "object_564"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_564','object_564');
47	0.37 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "object_564\x00tags\x00" 3 => "class_CA\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_564\0tags\0','class_CA\0tags\0');
48	0.37 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533070 2 => "\x00tags\x00object_389" 3 => "object_389"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_389','object_389');
49	0.37 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533070 2 => "object_389\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533070 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_389\0tags\0');
50	260.40 ms	SELECT COUNT() 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() FROM object_1 WHERE reference = ? and (calculated = 1) AND object_1.o_type IN ('object', 'folder') SELECT COUNT(*) FROM object_1 WHERE reference = 'Interest Manufacturer' and (calculated = 1) AND object_1.o_type IN ('object','folder');
51	251.96 ms	SELECT object_1.o_id as o_id, object_1.o_type as 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 as 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 as o_type FROM object_1 WHERE reference = 'Interest Manufacturer' and (calculated = 1) AND object_1.o_type IN ('object','folder');
52	0.42 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533071 2 => "\x00tags\x00object_960" 3 => "object_960"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533071 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_960','object_960');
53	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533071 2 => "object_960\x00tags\x00" 3 => "class_1\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533071 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_960\0tags\0','class_1\0tags\0');
54	3.94 ms	SELECT COUNT() FROM object_2 WHERE (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder') Parameters: [`"LITTLE TREE" 960`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_2 WHERE (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object', 'folder') SELECT COUNT(*) FROM object_2 WHERE (reference = 'LITTLE TREE') AND (group__id = 960) AND object_2.o_type IN ('object','folder');
55	3.85 ms	SELECT object_2.o_id as o_id, object_2.o_type as o_type FROM object_2 WHERE (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder') Parameters: [`"LITTLE TREE" 960`] View formatted query View runnable query Explain query SELECT object_2.o_id as o_id, object_2.o_type as 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 as o_type FROM object_2 WHERE (reference = 'LITTLE TREE') AND (group__id = 960) AND object_2.o_type IN ('object','folder');
56	0.42 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533071 2 => "\x00tags\x00object_6264" 3 => "object_6264"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533071 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6264','object_6264');
57	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533071 2 => "object_6264\x00tags\x00" 3 => "class_2\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533071 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6264\0tags\0','class_2\0tags\0');
58	253.65 ms	SELECT COUNT() 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() FROM object_1 WHERE reference = ? and (calculated = 1) AND object_1.o_type IN ('object', 'folder') SELECT COUNT(*) FROM object_1 WHERE reference = 'Interest Car Class' and (calculated = 1) AND object_1.o_type IN ('object','folder');
59	252.44 ms	SELECT object_1.o_id as o_id, object_1.o_type as 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 as 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 as o_type FROM object_1 WHERE reference = 'Interest Car Class' and (calculated = 1) AND object_1.o_type IN ('object','folder');
60	0.43 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_962" 3 => "object_962"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_962','object_962');
61	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "object_962\x00tags\x00" 3 => "class_1\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_962\0tags\0','class_1\0tags\0');
62	41.52 ms	SELECT COUNT() FROM object_2 WHERE (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder') Parameters: [`"doctorautochain" 962`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_2 WHERE (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object', 'folder') SELECT COUNT(*) FROM object_2 WHERE (reference = 'doctorautochain') AND (group__id = 962) AND object_2.o_type IN ('object','folder');
63	42.10 ms	SELECT object_2.o_id as o_id, object_2.o_type as o_type FROM object_2 WHERE (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder') Parameters: [`"doctorautochain" 962`] View formatted query View runnable query Explain query SELECT object_2.o_id as o_id, object_2.o_type as 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 as o_type FROM object_2 WHERE (reference = 'doctorautochain') AND (group__id = 962) AND object_2.o_type IN ('object','folder');
64	0.41 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_4940" 3 => "object_4940"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_4940','object_4940');
65	0.29 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "object_4940\x00tags\x00" 3 => "class_2\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4940\0tags\0','class_2\0tags\0');
66	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_1177" 3 => "object_1177"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1177','object_1177');
67	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533072 2 => "object_1177\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1177\0tags\0');
68	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_1176" 3 => "object_1176"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1176','object_1176');
69	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533072 2 => "object_1176\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1176\0tags\0');
70	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_1146" 3 => "object_1146"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1146','object_1146');
71	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533072 2 => "object_1146\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1146\0tags\0');
72	0.23 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_744" 3 => "object_744"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_744','object_744');
73	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533072 2 => "object_744\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_744\0tags\0');
74	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_1" 3 => "object_1"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1','object_1');
75	0.21 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533072 2 => "object_1\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1\0tags\0');
76	0.49 ms	SELECT * FROM website_settings WHERE name = ? AND (siteId IS NULL OR siteId = '' OR siteId = ?) AND (language IS NULL OR language = '' OR language = ?) ORDER BY siteId,language DESC Parameters: [`"defaultTaxClass" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = '' OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY siteId, language DESC SELECT * FROM website_settings WHERE name = 'defaultTaxClass' AND (siteId IS NULL OR siteId = '' OR siteId = NULL) AND (language IS NULL OR language = '' OR language = NULL) ORDER BY siteId,language DESC;
77	0.24 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 2;
78	0.24 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';
79	0.25 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;
80	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00system_resource_columns_ecommerceframework_pricing_rule" 3 => "system_resource_columns_ecommerceframework_pricing_rule"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_resource_columns_ecommerceframework_pricing_rule','system_resource_columns_ecommerceframework_pricing_rule');
81	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?) Parameters: [`1 => 1727533072 2 => "system\x00tags\x00" 3 => "resource\x00tags\x00" 4 => "system_resource_columns_ecommerceframework_pricing_rule\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0','resource\0tags\0','system_resource_columns_ecommerceframework_pricing_rule\0tags\0');
82	0.19 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';
83	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_559" 3 => "object_559"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_559','object_559');
84	0.16 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`559`] 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 = 559;
85	0.16 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';
86	0.17 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_556" 3 => "object_556"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_556','object_556');
87	0.14 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`556`] 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 = 556;
88	0.14 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';
89	0.17 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_75" 3 => "object_75"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_75','object_75');
90	0.14 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`75`] 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 = 75;
91	0.16 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_74" 3 => "object_74"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_74','object_74');
92	0.13 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`74`] 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 = 74;
93	0.20 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';
94	0.15 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';
95	0.14 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';
96	0.17 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_399" 3 => "object_399"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_399','object_399');
97	0.14 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`399`] 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 = 399;
98	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00object_873" 3 => "object_873"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_873','object_873');
99	0.13 ms	SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ? Parameters: [`873`] 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 = 873;
100	0.56 ms	SELECT object_localized_AP_mn.o_id as o_id, object_localized_AP_mn.o_type as o_type FROM object_localized_AP_mn WHERE (compatibleTo LIKE "%,2073,%" AND object_localized_AP_mn.o_type IN ('object','folder')) AND object_localized_AP_mn.o_published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_AP_mn.o_id as o_id, object_localized_AP_mn.o_type as o_type FROM object_localized_AP_mn WHERE ( compatibleTo LIKE "%,2073,%" AND object_localized_AP_mn.o_type IN ('object', 'folder') ) AND object_localized_AP_mn.o_published = 1 SELECT object_localized_AP_mn.o_id as o_id, object_localized_AP_mn.o_type as o_type FROM object_localized_AP_mn WHERE (compatibleTo LIKE "%,2073,%" AND object_localized_AP_mn.o_type IN ('object','folder')) AND object_localized_AP_mn.o_published = 1;
101	0.28 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00document_214" 3 => "document_214"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_214','document_214');
102	0.17 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533072 2 => "document_214\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_214\0tags\0');
103	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00nav_36dacad3db2e1ee9017a9066dc206fe3" 3 => "nav_36dacad3db2e1ee9017a9066dc206fe3"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_36dacad3db2e1ee9017a9066dc206fe3','nav_36dacad3db2e1ee9017a9066dc206fe3');
104	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?,?) Parameters: [`1 => 1727533072 2 => "output\x00tags\x00" 3 => "navigation\x00tags\x00" 4 => "document_212\x00tags\x00" 5 => "nav_36dacad3db2e1ee9017a9066dc206fe3\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0','navigation\0tags\0','document_212\0tags\0','nav_36dacad3db2e1ee9017a9066dc206fe3\0tags\0');
105	0.23 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
106	0.23 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00translation_data_671eb4310d9da89c0e84fb2d89b61992" 3 => "translation_data_671eb4310d9da89c0e84fb2d89b61992"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_671eb4310d9da89c0e84fb2d89b61992','translation_data_671eb4310d9da89c0e84fb2d89b61992');
107	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?,?) Parameters: [`1 => 1727533072 2 => "translator\x00tags\x00" 3 => "translator_website\x00tags\x00" 4 => "translate\x00tags\x00" 5 => "translation_data_671eb4310d9da89c0e84fb2d89b61992\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translator\0tags\0','translator_website\0tags\0','translate\0tags\0','translation_data_671eb4310d9da89c0e84fb2d89b61992\0tags\0');
108	0.19 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;
109	0.28 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;
110	0.27 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`"136" "136"`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = '136' UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = '136';
111	0.23 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`"214" "214"`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = '214' UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = '214';
112	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';
113	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00document_3" 3 => "document_3"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_3','document_3');
114	0.17 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "document_3\x00tags\x00" 3 => "document_1\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_3\0tags\0','document_1\0tags\0');
115	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00document_136" 3 => "document_136"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_136','document_136');
116	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533072 2 => "document_136\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_136\0tags\0');
117	0.17 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "mn" "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` = 'mn';
118	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00nav_866e1fdb318380dd4b31f7374d3f23ef" 3 => "nav_866e1fdb318380dd4b31f7374d3f23ef"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_866e1fdb318380dd4b31f7374d3f23ef','nav_866e1fdb318380dd4b31f7374d3f23ef');
119	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?,?) Parameters: [`1 => 1727533072 2 => "output\x00tags\x00" 3 => "navigation\x00tags\x00" 4 => "document_212\x00tags\x00" 5 => "nav_866e1fdb318380dd4b31f7374d3f23ef\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0','navigation\0tags\0','document_212\0tags\0','nav_866e1fdb318380dd4b31f7374d3f23ef\0tags\0');
120	0.21 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '' AND scope = 'pimcore_image_thumbnails';
121	0.17 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = '' AND scope = 'pimcore_image_thumbnails';
122	0.19 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "product_detail_small" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'product_detail_small' AND scope = 'pimcore_image_thumbnails';
123	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00imagick_format_avif" 3 => "imagick_format_avif"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_avif','imagick_format_avif');
124	0.17 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533072 2 => "imagick_format_avif\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_avif\0tags\0');
125	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00imagick_format_webp" 3 => "imagick_format_webp"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_webp','imagick_format_webp');
126	0.16 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533072 2 => "imagick_format_webp\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_webp\0tags\0');
127	0.27 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00document_12" 3 => "document_12"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_12','document_12');
128	0.16 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727533072 2 => "document_12\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_12\0tags\0');
129	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00document_target_groups_12" 3 => "document_target_groups_12"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_target_groups_12','document_target_groups_12');
130	0.22 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 12;
131	0.21 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727533072 2 => "\x00tags\x00document_properties_12" 3 => "document_properties_12"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_12','document_properties_12');
132	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?) Parameters: [`1 => 1727533072 2 => "document_properties\x00tags\x00" 3 => "document_12\x00tags\x00" 4 => "document_properties_12\x00tags\x00"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1727533072 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0','document_12\0tags\0','document_properties_12\0tags\0');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

http://202.131.233.39/shop/Products/CAR-ACCESSORIES/Interior-Accessories/LITTLE-TREE-LITTLE-TREE-ctk-52431-24-nertegc-VENT-CLIP-paarny-Black-ice~p2073

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache