Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

143 Database Queries

36 Different statements

707.26 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 = '6578'
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT name FROM classes WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT COUNT(*) FROM object_1 WHERE reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder')
SELECT object_1.o_id as o_id, object_1.o_type as o_type FROM object_1 WHERE reference = ? and (calculated = 1) AND  object_1.o_type IN ('object','folder')
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT COUNT(*) FROM object_2 WHERE (reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder')
SELECT object_2.o_id as o_id, object_2.o_type as o_type FROM object_2 WHERE (reference = ?)  AND (group__id = ?)  AND  object_2.o_type IN ('object','folder')
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 "%,6578,%" 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.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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_a1cb33e0ffd14c1d49594bf03aed9a60','site_domain_a1cb33e0ffd14c1d49594bf03aed9a60');
2	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 => 1727562086 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 > 1727562086 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.40 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/GARAGE-TLS-EQUI-STOR/Tools/SATA-SATA-SC96526-Elektron-cangalgaany-is-40-200nM~p6578" "sourcePathQuery" => "/de/shop/Products/GARAGE-TLS-EQUI-STOR/Tools/SATA-SATA-SC96526-Elektron-cangalgaany-is-40-200nM~p6578" "sourceEntireUri" => "http://202.131.233.39/de/shop/Products/GARAGE-TLS-EQUI-STOR/Tools/SATA-SATA-SC96526-Elektron-cangalgaany-is-40-200nM~p6578" "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/GARAGE-TLS-EQUI-STOR/Tools/SATA-SATA-SC96526-Elektron-cangalgaany-is-40-200nM~p6578' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/shop/Products/GARAGE-TLS-EQUI-STOR/Tools/SATA-SATA-SC96526-Elektron-cangalgaany-is-40-200nM~p6578' AND `type` = 'path_query') OR (source = 'http://202.131.233.39/de/shop/Products/GARAGE-TLS-EQUI-STOR/Tools/SATA-SATA-SC96526-Elektron-cangalgaany-is-40-200nM~p6578' 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.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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect','system_route_redirect');
5	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 => 1727562086 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 > 1727562086 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.19 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.25 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "SATA-SATA-SC96526-Elektron-cangalgaany-is-40-200nM~p6578" "path" => "/de/shop/Products/GARAGE-TLS-EQUI-STOR/Tools/"`] 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/GARAGE-TLS-EQUI-STOR/Tools/' AND `key` = 'SATA-SATA-SC96526-Elektron-cangalgaany-is-40-200nM~p6578';
8	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/shop/Products/GARAGE-TLS-EQUI-STOR/Tools/SATA-SATA-SC96526-Elektron-cangalgaany-is-40-200nM~p6578"`] 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/GARAGE-TLS-EQUI-STOR/Tools/SATA-SATA-SC96526-Elektron-cangalgaany-is-40-200nM~p6578';
9	0.17 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "Tools" "path" => "/de/shop/Products/GARAGE-TLS-EQUI-STOR/"`] 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/GARAGE-TLS-EQUI-STOR/' AND `key` = 'Tools';
10	0.15 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/shop/Products/GARAGE-TLS-EQUI-STOR/Tools"`] 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/GARAGE-TLS-EQUI-STOR/Tools';
11	0.14 ms	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "GARAGE-TLS-EQUI-STOR" "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` = 'GARAGE-TLS-EQUI-STOR';
12	0.16 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/de/shop/Products/GARAGE-TLS-EQUI-STOR"`] 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/GARAGE-TLS-EQUI-STOR';
13	0.13 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.15 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.15 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.14 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.16 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.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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_136','document_136');
19	0.16 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_136\0tags\0');
20	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_136','document_properties_136');
21	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?) Parameters: [`1 => 1727562086 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 > 1727562086 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.26 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.21 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.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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_target_groups_136','document_target_groups_136');
25	0.31 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.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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3440','object_3440');
27	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 => 1727562086 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 > 1727562086 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.17 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	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0quantityvalue_units_table','quantityvalue_units_table');
30	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('quantityvalue_units_table\0tags\0');
31	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_4151','object_4151');
32	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 => 1727562086 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 > 1727562086 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.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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2481','object_2481');
34	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 => 1727562086 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 > 1727562086 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.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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3436','object_3436');
36	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 => 1727562086 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 > 1727562086 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.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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3434','object_3434');
38	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 => 1727562086 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 > 1727562086 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.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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2480','object_2480');
40	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 => 1727562086 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 > 1727562086 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.28 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3958','object_3958');
42	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 => 1727562086 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 > 1727562086 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.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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_166','document_166');
44	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_166\0tags\0');
45	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_167','document_167');
46	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_167\0tags\0');
47	0.17 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.13 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.11 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.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 => 1727562086 2 => "\x00tags\x00object_6578" 3 => "object_6578"`] 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6578','object_6578');
51	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 => 1727562086 2 => "object_6578\x00tags\x00" 3 => "class_CAR\x00tags\x00" 4 => "asset_9897\x00tags\x00" 5 => "asset_9898\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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6578\0tags\0','class_CAR\0tags\0','asset_9897\0tags\0','asset_9898\0tags\0');
52	0.23 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '6578' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '6578' SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '6578';
53	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 => 1727562086 2 => "\x00tags\x00object_6400" 3 => "object_6400"`] 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6400','object_6400');
54	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 => 1727562086 2 => "object_6400\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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6400\0tags\0','class_MA\0tags\0');
55	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 => 1727562086 2 => "\x00tags\x00object_1368" 3 => "object_1368"`] 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1368','object_1368');
56	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 => 1727562086 2 => "object_1368\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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1368\0tags\0','class_CA\0tags\0');
57	0.15 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.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 => 1727562086 2 => "\x00tags\x00object_1363" 3 => "object_1363"`] 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1363','object_1363');
59	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 => 1727562086 2 => "object_1363\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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1363\0tags\0','class_CA\0tags\0');
60	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 => 1727562086 2 => "\x00tags\x00object_1362" 3 => "object_1362"`] 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1362','object_1362');
61	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 => 1727562086 2 => "object_1362\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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1362\0tags\0','class_CA\0tags\0');
62	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_564','object_564');
63	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_564\0tags\0','class_CA\0tags\0');
64	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_389','object_389');
65	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_389\0tags\0');
66	341.09 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');
67	316.94 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');
68	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_960','object_960');
69	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_960\0tags\0','class_1\0tags\0');
70	7.64 ms	SELECT COUNT() FROM object_2 WHERE (reference = ?) AND (group__id = ?) AND object_2.o_type IN ('object','folder') Parameters: [`"SATA" 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 = 'SATA') AND (group__id = 960) AND object_2.o_type IN ('object','folder');
71	7.46 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: [`"SATA" 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 = 'SATA') AND (group__id = 960) AND object_2.o_type IN ('object','folder');
72	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 => 1727562086 2 => "\x00tags\x00object_6708" 3 => "object_6708"`] 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6708','object_6708');
73	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 => 1727562086 2 => "object_6708\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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6708\0tags\0','class_2\0tags\0');
74	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 => 1727562086 2 => "\x00tags\x00object_6550" 3 => "object_6550"`] 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6550','object_6550');
75	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 => 1727562086 2 => "object_6550\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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6550\0tags\0');
76	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 => 1727562086 2 => "\x00tags\x00object_6453" 3 => "object_6453"`] 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6453','object_6453');
77	0.13 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 => 1727562086 2 => "object_6453\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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6453\0tags\0');
78	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1146','object_1146');
79	0.13 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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1146\0tags\0');
80	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_744','object_744');
81	0.13 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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_744\0tags\0');
82	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1','object_1');
83	0.13 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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1\0tags\0');
84	0.74 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;
85	0.33 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;
86	0.28 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';
87	0.44 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;
88	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 => 1727562086 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 > 1727562086 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');
89	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 => 1727562086 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 > 1727562086 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');
90	0.32 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';
91	0.39 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_559','object_559');
92	0.29 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;
93	0.30 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';
94	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_556','object_556');
95	0.26 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;
96	0.30 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';
97	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_75','object_75');
98	0.27 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;
99	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_74','object_74');
100	0.21 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;
101	0.29 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';
102	0.25 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';
103	0.25 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';
104	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_399','object_399');
105	0.24 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;
106	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_873','object_873');
107	0.22 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;
108	1.09 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 "%,6578,%" 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 "%,6578,%" 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 "%,6578,%" AND object_localized_AP_en.o_type IN ('object','folder')) AND object_localized_AP_en.o_published = 1;
109	0.57 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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_f007147ab67d2ccfb0605d9d3edf58c8','nav_f007147ab67d2ccfb0605d9d3edf58c8');
110	0.39 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?,?,?,?,?) Parameters: [`1 => 1727562086 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 > 1727562086 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');
111	0.42 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;;
112	0.45 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea','translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea');
113	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 => 1727562086 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 > 1727562086 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');
114	0.27 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;
115	0.41 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;
116	0.33 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';
117	0.31 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';
118	0.30 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';
119	0.28 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?) Parameters: [`1 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1','document_1');
120	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0');
121	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1','document_properties_1');
122	0.28 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?,?,?) Parameters: [`1 => 1727562086 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 > 1727562086 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');
123	0.26 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';
124	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_3','document_3');
125	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_3\0tags\0','document_1\0tags\0');
126	0.25 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';
127	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_214','document_214');
128	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_214\0tags\0');
129	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_f3e9f14d1fa72fd1bf8879d5371f86ba','nav_f3e9f14d1fa72fd1bf8879d5371f86ba');
130	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 => 1727562086 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 > 1727562086 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');
131	0.27 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';
132	0.22 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';
133	0.19 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "product_detail_small" "scope" => "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'product_detail_small' AND scope = 'pimcore_image_thumbnails';
134	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_avif','imagick_format_avif');
135	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_avif\0tags\0');
136	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_webp','imagick_format_webp');
137	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_webp\0tags\0');
138	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_170','document_170');
139	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_170\0tags\0');
140	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_target_groups_170','document_target_groups_170');
141	0.26 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;
142	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 => 1727562086 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 > 1727562086 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_170','document_properties_170');
143	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 => 1727562086 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 > 1727562086 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