Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

153 Database Queries

36 Different statements

1248.08 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 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 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 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 * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '4812'
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 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_en.o_id as o_id, object_localized_AP_en.o_type as o_type FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,4812,%" AND  object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.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 * 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,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations 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 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 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 * 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.61 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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_a1cb33e0ffd14c1d49594bf03aed9a60','site_domain_a1cb33e0ffd14c1d49594bf03aed9a60');
2	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 => 1727627044 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 > 1727627044 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.83 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" => "/de/shop/Products/CAR-ACCESSORIES/Interior-Accessories/AUTOBACS-OGC-OGC8609-Nemelt-gogcoo-degeetej~p4812" "sourcePathQuery" => "/de/shop/Products/CAR-ACCESSORIES/Interior-Accessories/AUTOBACS-OGC-OGC8609-Nemelt-gogcoo-degeetej~p4812" "sourceEntireUri" => "http://202.131.233.39/de/shop/Products/CAR-ACCESSORIES/Interior-Accessories/AUTOBACS-OGC-OGC8609-Nemelt-gogcoo-degeetej~p4812" "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 = '/de/shop/Products/CAR-ACCESSORIES/Interior-Accessories/AUTOBACS-OGC-OGC8609-Nemelt-gogcoo-degeetej~p4812' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/shop/Products/CAR-ACCESSORIES/Interior-Accessories/AUTOBACS-OGC-OGC8609-Nemelt-gogcoo-degeetej~p4812' AND `type` = 'path_query') OR (source = 'http://202.131.233.39/de/shop/Products/CAR-ACCESSORIES/Interior-Accessories/AUTOBACS-OGC-OGC8609-Nemelt-gogcoo-degeetej~p4812' 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.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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect','system_route_redirect');
5	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 => 1727627044 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 > 1727627044 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.33 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.40 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "AUTOBACS-OGC-OGC8609-Nemelt-gogcoo-degeetej~p4812" "path" => "/de/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 = '/de/shop/Products/CAR-ACCESSORIES/Interior-Accessories/' AND `key` = 'AUTOBACS-OGC-OGC8609-Nemelt-gogcoo-degeetej~p4812';
8	0.35 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/shop/Products/CAR-ACCESSORIES/Interior-Accessories/AUTOBACS-OGC-OGC8609-Nemelt-gogcoo-degeetej~p4812"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/de/shop/Products/CAR-ACCESSORIES/Interior-Accessories/AUTOBACS-OGC-OGC8609-Nemelt-gogcoo-degeetej~p4812';
9	0.29 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "Interior-Accessories" "path" => "/de/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 = '/de/shop/Products/CAR-ACCESSORIES/' AND `key` = 'Interior-Accessories';
10	0.33 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/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 = '/de/shop/Products/CAR-ACCESSORIES/Interior-Accessories';
11	0.29 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "CAR-ACCESSORIES" "path" => "/de/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 = '/de/shop/Products/' AND `key` = 'CAR-ACCESSORIES';
12	0.29 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/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 = '/de/shop/Products/CAR-ACCESSORIES';
13	0.27 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "Products" "path" => "/de/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 = '/de/shop/' AND `key` = 'Products';
14	0.31 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/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 = '/de/shop/Products';
15	0.28 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "shop" "path" => "/de/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = :path AND `key` = :key SELECT id FROM documents WHERE path = '/de/' AND `key` = 'shop';
16	0.28 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/shop"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/de/shop';
17	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';
18	0.99 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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_136','document_136');
19	0.33 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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_136\0tags\0');
20	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 => 1727627044 2 => "\x00tags\x00document_properties_136" 3 => "document_properties_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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_136','document_properties_136');
21	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 => 1727627044 2 => "document_properties\x00tags\x00" 3 => "document_136\x00tags\x00" 4 => "document_properties_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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0','document_136\0tags\0','document_properties_136\0tags\0');
22	0.64 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.37 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.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 => 1727627044 2 => "\x00tags\x00document_target_groups_136" 3 => "document_target_groups_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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_target_groups_136','document_target_groups_136');
25	0.46 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`136`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 136;
26	0.40 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 => 1727627044 2 => "\x00tags\x00object_3440" 3 => "object_3440"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3440','object_3440');
27	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 => 1727627044 2 => "object_3440\x00tags\x00" 3 => "class_CAR\x00tags\x00" 4 => "asset_5093\x00tags\x00" 5 => "asset_5092\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3440\0tags\0','class_CAR\0tags\0','asset_5093\0tags\0','asset_5092\0tags\0');
28	0.23 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';
29	1.38 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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0quantityvalue_units_table','quantityvalue_units_table');
30	0.38 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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('quantityvalue_units_table\0tags\0');
31	0.76 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 => 1727627044 2 => "\x00tags\x00object_4151" 3 => "object_4151"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_4151','object_4151');
32	1.03 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 => 1727627044 2 => "object_4151\x00tags\x00" 3 => "class_CAR\x00tags\x00" 4 => "asset_6740\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4151\0tags\0','class_CAR\0tags\0','asset_6740\0tags\0');
33	0.52 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 => 1727627044 2 => "\x00tags\x00object_2481" 3 => "object_2481"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2481','object_2481');
34	0.47 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 => 1727627044 2 => "object_2481\x00tags\x00" 3 => "class_CAR\x00tags\x00" 4 => "asset_5149\x00tags\x00" 5 => "asset_5150\x00tags\x00" 6 => "asset_5148\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2481\0tags\0','class_CAR\0tags\0','asset_5149\0tags\0','asset_5150\0tags\0','asset_5148\0tags\0');
35	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 => 1727627044 2 => "\x00tags\x00object_3436" 3 => "object_3436"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3436','object_3436');
36	0.40 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 => 1727627044 2 => "object_3436\x00tags\x00" 3 => "class_CAR\x00tags\x00" 4 => "asset_5078\x00tags\x00" 5 => "asset_5080\x00tags\x00" 6 => "asset_5081\x00tags\x00" 7 => "asset_5079\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3436\0tags\0','class_CAR\0tags\0','asset_5078\0tags\0','asset_5080\0tags\0','asset_5081\0tags\0','asset_5079\0tags\0');
37	0.58 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 => 1727627044 2 => "\x00tags\x00object_3434" 3 => "object_3434"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3434','object_3434');
38	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 => 1727627044 2 => "object_3434\x00tags\x00" 3 => "class_CAR\x00tags\x00" 4 => "asset_5072\x00tags\x00" 5 => "asset_5070\x00tags\x00" 6 => "asset_5073\x00tags\x00" 7 => "asset_5071\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3434\0tags\0','class_CAR\0tags\0','asset_5072\0tags\0','asset_5070\0tags\0','asset_5073\0tags\0','asset_5071\0tags\0');
39	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 => 1727627044 2 => "\x00tags\x00object_2480" 3 => "object_2480"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2480','object_2480');
40	0.40 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 => 1727627044 2 => "object_2480\x00tags\x00" 3 => "class_CAR\x00tags\x00" 4 => "asset_5144\x00tags\x00" 5 => "asset_5147\x00tags\x00" 6 => "asset_5146\x00tags\x00" 7 => "asset_5145\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2480\0tags\0','class_CAR\0tags\0','asset_5144\0tags\0','asset_5147\0tags\0','asset_5146\0tags\0','asset_5145\0tags\0');
41	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 => 1727627044 2 => "\x00tags\x00object_3958" 3 => "object_3958"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3958','object_3958');
42	0.87 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 => 1727627044 2 => "object_3958\x00tags\x00" 3 => "class_CAR\x00tags\x00" 4 => "asset_5096\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3958\0tags\0','class_CAR\0tags\0','asset_5096\0tags\0');
43	0.31 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 => 1727627044 2 => "\x00tags\x00document_166" 3 => "document_166"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_166','document_166');
44	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 => 1727627044 2 => "document_166\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_166\0tags\0');
45	0.26 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 => 1727627044 2 => "\x00tags\x00document_167" 3 => "document_167"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_167','document_167');
46	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 => 1727627044 2 => "document_167\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_167\0tags\0');
47	0.23 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;
48	0.19 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;
49	0.18 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;
50	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 => 1727627044 2 => "\x00tags\x00object_4812" 3 => "object_4812"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_4812','object_4812');
51	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 => 1727627044 2 => "object_4812\x00tags\x00" 3 => "class_CAR\x00tags\x00" 4 => "asset_7905\x00tags\x00" 5 => "asset_7904\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4812\0tags\0','class_CAR\0tags\0','asset_7905\0tags\0','asset_7904\0tags\0');
52	0.87 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '4812' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '4812' SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '4812';
53	0.33 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 => 1727627044 2 => "\x00tags\x00object_6115" 3 => "object_6115"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6115','object_6115');
54	0.26 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 => 1727627044 2 => "object_6115\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6115\0tags\0','class_MA\0tags\0');
55	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 => 1727627044 2 => "\x00tags\x00object_1152" 3 => "object_1152"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1152','object_1152');
56	0.26 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 => 1727627044 2 => "object_1152\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1152\0tags\0','class_CA\0tags\0');
57	0.23 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';
58	0.31 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 => 1727627044 2 => "\x00tags\x00object_6109" 3 => "object_6109"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6109','object_6109');
59	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 => 1727627044 2 => "object_6109\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6109\0tags\0','class_CA\0tags\0');
60	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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1135','object_1135');
61	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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1135\0tags\0','class_CA\0tags\0');
62	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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1128','object_1128');
63	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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1128\0tags\0','class_CA\0tags\0');
64	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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_564','object_564');
65	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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_564\0tags\0','class_CA\0tags\0');
66	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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_389','object_389');
67	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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_389\0tags\0');
68	258.61 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');
69	255.45 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');
70	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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_960','object_960');
71	0.26 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 => 1727627044 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_960\0tags\0','class_1\0tags\0');
72	42.45 ms	SELECT COUNT() FROM object_2 WHERE (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder') Parameters: [`"AUTOBACS" 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 = 'AUTOBACS') AND (group__id = 960) AND object_2.o_type IN ('object','folder');
73	42.28 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: [`"AUTOBACS" 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 = 'AUTOBACS') AND (group__id = 960) AND object_2.o_type IN ('object','folder');
74	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 => 1727627044 2 => "\x00tags\x00object_6225" 3 => "object_6225"`] 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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6225','object_6225');
75	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 => 1727627044 2 => "object_6225\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 > 1727627044 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6225\0tags\0','class_2\0tags\0');
76	258.51 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');
77	260.62 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');
78	0.49 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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_962','object_962');
79	0.30 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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_962\0tags\0','class_1\0tags\0');
80	44.47 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');
81	41.57 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');
82	0.40 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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_4940','object_4940');
83	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4940\0tags\0','class_2\0tags\0');
84	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 => 1727627045 2 => "\x00tags\x00object_1770" 3 => "object_1770"`] 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1770','object_1770');
85	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 => 1727627045 2 => "object_1770\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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1770\0tags\0');
86	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 => 1727627045 2 => "\x00tags\x00object_1768" 3 => "object_1768"`] 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1768','object_1768');
87	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 => 1727627045 2 => "object_1768\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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1768\0tags\0');
88	0.25 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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1146','object_1146');
89	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1146\0tags\0');
90	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_744','object_744');
91	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_744\0tags\0');
92	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1','object_1');
93	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1\0tags\0');
94	0.45 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;
95	0.22 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 2;
96	0.17 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';
97	0.26 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;
98	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 => 1727627045 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 > 1727627045 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');
99	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 => 1727627045 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 > 1727627045 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');
100	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';
101	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_559','object_559');
102	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;
103	0.15 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';
104	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_556','object_556');
105	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;
106	0.15 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';
107	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_75','object_75');
108	0.17 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;
109	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_74','object_74');
110	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;
111	0.22 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';
112	0.17 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';
113	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';
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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_399','object_399');
115	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;
116	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_873','object_873');
117	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;
118	0.64 ms	SELECT object_localized_AP_en.o_id as o_id, object_localized_AP_en.o_type as o_type FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,4812,%" 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 as o_type FROM object_localized_AP_en WHERE ( compatibleTo LIKE "%,4812,%" 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 as o_type FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,4812,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1;
119	0.26 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 => 1727627045 2 => "\x00tags\x00nav_f007147ab67d2ccfb0605d9d3edf58c8" 3 => "nav_f007147ab67d2ccfb0605d9d3edf58c8"`] 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_f007147ab67d2ccfb0605d9d3edf58c8','nav_f007147ab67d2ccfb0605d9d3edf58c8');
120	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 => 1727627045 2 => "output\x00tags\x00" 3 => "navigation\x00tags\x00" 4 => "document_234\x00tags\x00" 5 => "document_236\x00tags\x00" 6 => "document_240\x00tags\x00" 7 => "document_242\x00tags\x00" 8 => "nav_f007147ab67d2ccfb0605d9d3edf58c8\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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0','navigation\0tags\0','document_234\0tags\0','document_236\0tags\0','document_240\0tags\0','document_242\0tags\0','nav_f007147ab67d2ccfb0605d9d3edf58c8\0tags\0');
121	0.20 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;;
122	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 => 1727627045 2 => "\x00tags\x00translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea" 3 => "translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea"`] 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea','translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea');
123	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 => 1727627045 2 => "translator\x00tags\x00" 3 => "translator_website\x00tags\x00" 4 => "translate\x00tags\x00" 5 => "translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea\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 > 1727627045 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_01e5f00fbf5874160f42c8fe5f4fa4ea\0tags\0');
124	0.19 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`136`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 136;
125	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" 136 136`] 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', 136) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 136;
126	0.22 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';
127	0.21 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';
128	0.22 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`"1" "1"`] 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 = '1' UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = '1';
129	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1','document_1');
130	0.14 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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0');
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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1','document_properties_1');
132	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 => 1727627045 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 > 1727627045 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');
133	0.21 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';
134	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_3','document_3');
135	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_3\0tags\0','document_1\0tags\0');
136	0.20 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';
137	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_214','document_214');
138	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_214\0tags\0');
139	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 => 1727627045 2 => "\x00tags\x00nav_f3e9f14d1fa72fd1bf8879d5371f86ba" 3 => "nav_f3e9f14d1fa72fd1bf8879d5371f86ba"`] 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_f3e9f14d1fa72fd1bf8879d5371f86ba','nav_f3e9f14d1fa72fd1bf8879d5371f86ba');
140	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 => 1727627045 2 => "output\x00tags\x00" 3 => "navigation\x00tags\x00" 4 => "document_234\x00tags\x00" 5 => "document_236\x00tags\x00" 6 => "document_240\x00tags\x00" 7 => "document_242\x00tags\x00" 8 => "nav_f3e9f14d1fa72fd1bf8879d5371f86ba\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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0','navigation\0tags\0','document_234\0tags\0','document_236\0tags\0','document_240\0tags\0','document_242\0tags\0','nav_f3e9f14d1fa72fd1bf8879d5371f86ba\0tags\0');
141	0.25 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';
142	0.19 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';
143	0.20 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';
144	0.25 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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_avif','imagick_format_avif');
145	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_avif\0tags\0');
146	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_webp','imagick_format_webp');
147	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 => 1727627045 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_webp\0tags\0');
148	0.31 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 => 1727627045 2 => "\x00tags\x00document_170" 3 => "document_170"`] 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_170','document_170');
149	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 => 1727627045 2 => "document_170\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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_170\0tags\0');
150	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 => 1727627045 2 => "\x00tags\x00document_target_groups_170" 3 => "document_target_groups_170"`] 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_target_groups_170','document_target_groups_170');
151	0.34 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`170`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 170;
152	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 => 1727627045 2 => "\x00tags\x00document_properties_170" 3 => "document_properties_170"`] 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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_170','document_properties_170');
153	0.26 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 => 1727627045 2 => "document_properties\x00tags\x00" 3 => "document_170\x00tags\x00" 4 => "document_properties_170\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 > 1727627045 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0','document_170\0tags\0','document_properties_170\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/_fragment?_path=_locale%3Den%26_format%3Dhtml%26_controller%3DApp%255CController%255CDefaultController%253A%253AdefaultAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache