Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

106 Database Queries

18 Different statements

21.10 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 = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :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 * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT * FROM targeting_rules WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 o_id FROM objects WHERE o_path = :path AND `o_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 o_id FROM objects WHERE o_path = :path AND `o_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 o_id FROM objects WHERE o_path = :path AND `o_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 o_id FROM objects WHERE o_path = :path AND `o_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 o_id FROM objects WHERE o_path = :path AND `o_key` = :key
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM 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 * 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 FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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_collection_NewsCars_NE WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsLinks_NE WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsText_NE WHERE o_id = ? AND fieldname = ? ORDER BY `index` 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 item_id, CASE 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 (?)

#▲	Time	Info
1	0.60 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: [`1732192159 [ "\x00tags\x00site_domain_00a16d5a207aa593f14b18201ed796fd" "site_domain_00a16d5a207aa593f14b18201ed796fd" ]`] 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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_00a16d5a207aa593f14b18201ed796fd', 'site_domain_00a16d5a207aa593f14b18201ed796fd');
2	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: [`1732192159 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_00a16d5a207aa593f14b18201ed796fd\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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_domain_00a16d5a207aa593f14b18201ed796fd\0tags\0');
3	0.35 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/en/News/Videos~n1209" "sourcePathQuery" => "/en/News/Videos~n1209" "sourceEntireUri" => "https://pimcore-demo.profildoors.de/en/News/Videos~n1209" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/en/News/Videos~n1209' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/en/News/Videos~n1209' AND `type` = 'path_query') OR (source = 'https://pimcore-demo.profildoors.de/en/News/Videos~n1209' 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.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: [`1732192159 [ "\x00tags\x00system_route_redirect" "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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
5	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: [`1732192159 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "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 > 1732192159 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.11 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.20 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Videos~n1209" "path" => "/en/News/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/en/News/' AND `key` = BINARY 'Videos~n1209';
8	0.17 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/en/News/Videos~n1209"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/en/News/Videos~n1209';
9	0.16 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "News" "path" => "/en/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/en/' AND `key` = BINARY 'News';
10	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: [`1732192159 [ "\x00tags\x00document_65" "document_65" ]`] 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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_65', 'document_65');
11	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: [`1732192159 [ "document_65\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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_65\0tags\0');
12	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: [`1732192159 [ "\x00tags\x00document_properties_65" "document_properties_65" ]`] 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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_65', 'document_properties_65');
13	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: [`1732192159 [ "document_properties\x00tags\x00" "document_65\x00tags\x00" "document_properties_65\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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_65\0tags\0', 'document_properties_65\0tags\0');
14	0.11 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;
15	0.08 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;
16	0.12 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 1;
17	0.06 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 2;
18	0.06 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 3;
19	0.06 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 4;
20	0.06 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 6;
21	0.07 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 7;
22	0.06 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 8;
23	0.03 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 9;
24	0.03 ms	SELECT * FROM targeting_rules WHERE id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM targeting_rules WHERE id = ? SELECT * FROM targeting_rules WHERE id = 10;
25	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: [`1732192159 [ "\x00tags\x00url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1', 'url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1');
26	0.08 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: [`1732192159 [ "\x00tags\x00url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1', 'url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1');
27	0.08 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: [`1732192159 [ "\x00tags\x00url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1" "url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1', 'url_1%20and%20timeonsite_2%2F%2Ftimeonsite_2%7Curl_1');
28	0.07 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "Sports-Cars-Fan" "path" => "/Customer Management/segments/calculated/Interest-Target-Groups/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key SELECT o_id FROM objects WHERE o_path = '/Customer Management/segments/calculated/Interest-Target-Groups/' AND `o_key` = 'Sports-Cars-Fan';
29	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: [`1732192159 [ "\x00tags\x00object_875" "object_875" ]`] 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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_875', 'object_875');
30	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: [`1732192159 [ "object_875\x00tags\x00" "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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_875\0tags\0', 'class_2\0tags\0');
31	0.07 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key SELECT o_id FROM objects WHERE o_path = '/Customer Management/segments/calculated/VisitingCount/' AND `o_key` = 'at least once';
32	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: [`1732192159 [ "\x00tags\x00object_860" "object_860" ]`] 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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_860', 'object_860');
33	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: [`1732192159 [ "object_860\x00tags\x00" "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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_860\0tags\0', 'class_2\0tags\0');
34	0.05 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key SELECT o_id FROM objects WHERE o_path = '/Customer Management/segments/calculated/VisitingCount/' AND `o_key` = 'at least once';
35	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: [`1732192159 [ "\x00tags\x00cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1', 'cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1');
36	0.10 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key SELECT o_id FROM objects WHERE o_path = '/Customer Management/segments/calculated/VisitingCount/' AND `o_key` = 'at least once';
37	0.10 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: [`1732192159 [ "\x00tags\x00cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1', 'cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1');
38	0.04 ms	SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key Parameters: [`"key" => "at least once" "path" => "/Customer Management/segments/calculated/VisitingCount/"`] View formatted query View runnable query Explain query SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key SELECT o_id FROM objects WHERE o_path = '/Customer Management/segments/calculated/VisitingCount/' AND `o_key` = 'at least once';
39	0.04 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: [`1732192159 [ "\x00tags\x00cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" "cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1', 'cmf_has_segment_1%20and%20cmf_customer_is_loggedin_2%2F%2Fcmf_customer_is_loggedin_2%7Ccmf_has_segment_1');
40	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: [`1732192159 [ "\x00tags\x00document_target_groups_65" "document_target_groups_65" ]`] 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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_target_groups_65', 'document_target_groups_65');
41	1.62 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`65`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 65;
42	0.49 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1732192159 [ "\x00tags\x00object_1209" "object_1209" ]`] 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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1209', 'object_1209');
43	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: [`1732192159 [ "object_1209\x00tags\x00" "class_NE\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 > 1732192159 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1209\0tags\0', 'class_NE\0tags\0');
44	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"NE"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'NE';
45	0.37 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1732192160 [ "\x00tags\x00document_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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_3', 'document_3');
46	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: [`1732192160 [ "document_3\x00tags\x00" "document_1\x00tags\x00" "asset_337\x00tags\x00" "asset_3\x00tags\x00" "asset_319\x00tags\x00" "asset_361\x00tags\x00" "asset_320\x00tags\x00" "asset_318\x00tags\x00" "asset_321\x00tags\x00" "asset_224\x00tags\x00" "asset_35\x00tags\x00" "asset_211\x00tags\x00" "asset_90\x00tags\x00" "asset_58\x00tags\x00" "asset_180\x00tags\x00" "asset_124\x00tags\x00" "asset_164\x00tags\x00" "asset_81\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_3\0tags\0', 'document_1\0tags\0', 'asset_337\0tags\0', 'asset_3\0tags\0', 'asset_319\0tags\0', 'asset_361\0tags\0', 'asset_320\0tags\0', 'asset_318\0tags\0', 'asset_321\0tags\0', 'asset_224\0tags\0', 'asset_35\0tags\0', 'asset_211\0tags\0', 'asset_90\0tags\0', 'asset_58\0tags\0', 'asset_180\0tags\0', 'asset_124\0tags\0', 'asset_164\0tags\0', 'asset_81\0tags\0');
47	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: [`1732192160 [ "\x00tags\x00nav_33f722f5a981de05404856ca38cd1340" "nav_33f722f5a981de05404856ca38cd1340" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_33f722f5a981de05404856ca38cd1340', 'nav_33f722f5a981de05404856ca38cd1340');
48	0.34 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: [1732192160 [ "output\x00tags\x00" "navigation\x00tags\x00" "document_74\x00tags\x00" "document_97\x00tags\x00" "document_45\x00tags\x00" "document_99\x00tags\x00" "document_100\x00tags\x00" "document_101\x00tags\x00" "document_102\x00tags\x00" "document_103\x00tags\x00" "document_104\x00tags\x00" "document_123\x00tags\x00" "document_46\x00tags\x00" "document_65\x00tags\x00" "document_200\x00tags\x00" "document_54\x00tags\x00" "document_55\x00tags\x00" "document_56\x00tags\x00" "document_57\x00tags\x00" "document_53\x00tags\x00" "document_48\x00tags\x00" "document_52\x00tags\x00" "document_112\x00tags\x00" "document_49\x00tags\x00" "document_113\x00tags\x00" "document_39\x00tags\x00" "document_121\x00tags\x00" "document_50\x00tags\x00" "document_38\x00tags\x00" "document_51\x00tags\x00" "document_118\x00tags\x00" "document_199\x00tags\x00" "document_58\x00tags\x00" "document_95\x00tags\x00" "document_110\x00tags\x00" "document_193\x00tags\x00" "document_194\x00tags\x00" "document_195\x00tags\x00" "document_94\x00tags\x00" "document_88\x00tags\x00" "document_197\x00tags\x00" "document_47\x00tags\x00" "document_198\x00tags\x00" "nav_33f722f5a981de05404856ca38cd1340\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0', 'navigation\0tags\0', 'document_74\0tags\0', 'document_97\0tags\0', 'document_45\0tags\0', 'document_99\0tags\0', 'document_100\0tags\0', 'document_101\0tags\0', 'document_102\0tags\0', 'document_103\0tags\0', 'document_104\0tags\0', 'document_123\0tags\0', 'document_46\0tags\0', 'document_65\0tags\0', 'document_200\0tags\0', 'document_54\0tags\0', 'document_55\0tags\0', 'document_56\0tags\0', 'document_57\0tags\0', 'document_53\0tags\0', 'document_48\0tags\0', 'document_52\0tags\0', 'document_112\0tags\0', 'document_49\0tags\0', 'document_113\0tags\0', 'document_39\0tags\0', 'document_121\0tags\0', 'document_50\0tags\0', 'document_38\0tags\0', 'document_51\0tags\0', 'document_118\0tags\0', 'document_199\0tags\0', 'document_58\0tags\0', 'document_95\0tags\0', 'document_110\0tags\0', 'document_193\0tags\0', 'document_194\0tags\0', 'document_195\0tags\0', 'document_94\0tags\0', 'document_88\0tags\0', 'document_197\0tags\0', 'document_47\0tags\0', 'document_198\0tags\0', 'nav_33f722f5a981de05404856ca38cd1340\0tags\0');
49	0.08 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;;
50	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: [`1732192160 [ "\x00tags\x00translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea" "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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea', 'translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea');
51	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: [`1732192160 [ "translator\x00tags\x00" "translator_website\x00tags\x00" "translate\x00tags\x00" "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 > 1732192160 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');
52	0.19 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`65`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 65;
53	0.23 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`65 65 65`] 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(65, 65) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 65;
54	0.15 ms	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`142 142`] 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 = 142 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 142;
55	0.07 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "en" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'en';
56	0.04 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "de" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'de';
57	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: [`1732192160 [ "\x00tags\x00document_136" "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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_136', 'document_136');
58	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: [`1732192160 [ "document_136\x00tags\x00" "asset_337\x00tags\x00" "asset_3\x00tags\x00" "asset_319\x00tags\x00" "asset_361\x00tags\x00" "asset_320\x00tags\x00" "asset_318\x00tags\x00" "asset_321\x00tags\x00" "asset_224\x00tags\x00" "asset_35\x00tags\x00" "asset_211\x00tags\x00" "asset_90\x00tags\x00" "asset_58\x00tags\x00" "asset_180\x00tags\x00" "asset_124\x00tags\x00" "asset_164\x00tags\x00" "asset_81\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_136\0tags\0', 'asset_337\0tags\0', 'asset_3\0tags\0', 'asset_319\0tags\0', 'asset_361\0tags\0', 'asset_320\0tags\0', 'asset_318\0tags\0', 'asset_321\0tags\0', 'asset_224\0tags\0', 'asset_35\0tags\0', 'asset_211\0tags\0', 'asset_90\0tags\0', 'asset_58\0tags\0', 'asset_180\0tags\0', 'asset_124\0tags\0', 'asset_164\0tags\0', 'asset_81\0tags\0');
59	0.52 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1732192160 [ "\x00tags\x00document_142" "document_142" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_142', 'document_142');
60	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: [`1732192160 [ "document_142\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_142\0tags\0');
61	0.10 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "fr" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'fr';
62	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/fr"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/fr';
63	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: [`1732192160 [ "\x00tags\x00nav_d74f487a3074b19f20c1eac992827746" "nav_d74f487a3074b19f20c1eac992827746" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_d74f487a3074b19f20c1eac992827746', 'nav_d74f487a3074b19f20c1eac992827746');
64	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: [1732192160 [ "output\x00tags\x00" "navigation\x00tags\x00" "document_74\x00tags\x00" "document_97\x00tags\x00" "document_45\x00tags\x00" "document_99\x00tags\x00" "document_100\x00tags\x00" "document_101\x00tags\x00" "document_102\x00tags\x00" "document_103\x00tags\x00" "document_104\x00tags\x00" "document_123\x00tags\x00" "document_46\x00tags\x00" "document_65\x00tags\x00" "document_200\x00tags\x00" "document_54\x00tags\x00" "document_55\x00tags\x00" "document_56\x00tags\x00" "document_57\x00tags\x00" "document_53\x00tags\x00" "document_48\x00tags\x00" "document_52\x00tags\x00" "document_112\x00tags\x00" "document_49\x00tags\x00" "document_113\x00tags\x00" "document_39\x00tags\x00" "document_121\x00tags\x00" "document_50\x00tags\x00" "document_38\x00tags\x00" "document_51\x00tags\x00" "document_118\x00tags\x00" "document_199\x00tags\x00" "document_58\x00tags\x00" "document_95\x00tags\x00" "document_110\x00tags\x00" "document_193\x00tags\x00" "document_194\x00tags\x00" "document_195\x00tags\x00" "document_94\x00tags\x00" "document_88\x00tags\x00" "document_197\x00tags\x00" "document_47\x00tags\x00" "document_198\x00tags\x00" "nav_d74f487a3074b19f20c1eac992827746\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0', 'navigation\0tags\0', 'document_74\0tags\0', 'document_97\0tags\0', 'document_45\0tags\0', 'document_99\0tags\0', 'document_100\0tags\0', 'document_101\0tags\0', 'document_102\0tags\0', 'document_103\0tags\0', 'document_104\0tags\0', 'document_123\0tags\0', 'document_46\0tags\0', 'document_65\0tags\0', 'document_200\0tags\0', 'document_54\0tags\0', 'document_55\0tags\0', 'document_56\0tags\0', 'document_57\0tags\0', 'document_53\0tags\0', 'document_48\0tags\0', 'document_52\0tags\0', 'document_112\0tags\0', 'document_49\0tags\0', 'document_113\0tags\0', 'document_39\0tags\0', 'document_121\0tags\0', 'document_50\0tags\0', 'document_38\0tags\0', 'document_51\0tags\0', 'document_118\0tags\0', 'document_199\0tags\0', 'document_58\0tags\0', 'document_95\0tags\0', 'document_110\0tags\0', 'document_193\0tags\0', 'document_194\0tags\0', 'document_195\0tags\0', 'document_94\0tags\0', 'document_88\0tags\0', 'document_197\0tags\0', 'document_47\0tags\0', 'document_198\0tags\0', 'nav_d74f487a3074b19f20c1eac992827746\0tags\0');
65	0.87 ms	SELECT * FROM object_collection_NewsCars_NE WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1209 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsCars_NE WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsCars_NE WHERE o_id = 1209 AND fieldname = 'content' ORDER BY `index` ASC;
66	1.01 ms	SELECT * FROM object_collection_NewsLinks_NE WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1209 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsLinks_NE WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsLinks_NE WHERE o_id = 1209 AND fieldname = 'content' ORDER BY `index` ASC;
67	0.47 ms	SELECT * FROM object_collection_NewsText_NE WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`1209 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsText_NE WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsText_NE WHERE o_id = 1209 AND fieldname = 'content' ORDER BY `index` ASC;
68	0.12 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: [`1732192160 [ "\x00tags\x00document_12" "document_12" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_12', 'document_12');
69	0.11 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: [`1732192160 [ "document_12\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_12\0tags\0');
70	0.11 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: [`1732192160 [ "\x00tags\x00document_target_groups_12" "document_target_groups_12" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_target_groups_12', 'document_target_groups_12');
71	0.04 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 12;
72	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: [`1732192160 [ "\x00tags\x00document_properties_12" "document_properties_12" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_12', 'document_properties_12');
73	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: [`1732192160 [ "document_properties\x00tags\x00" "document_12\x00tags\x00" "document_properties_12\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_12\0tags\0', 'document_properties_12\0tags\0');
74	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1732192160 [ "\x00tags\x00document_74" "document_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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_74', 'document_74');
75	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: [`1732192160 [ "document_74\x00tags\x00" "asset_340\x00tags\x00" "asset_362\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_74\0tags\0', 'asset_340\0tags\0', 'asset_362\0tags\0');
76	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: [`1732192160 [ "\x00tags\x00document_97" "document_97" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_97', 'document_97');
77	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: [`1732192160 [ "\x00tags\x00document_99" "document_99" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_99', 'document_99');
78	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: [`1732192160 [ "document_99\x00tags\x00" "asset_362\x00tags\x00" "asset_339\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_99\0tags\0', 'asset_362\0tags\0', 'asset_339\0tags\0');
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: [`1732192160 [ "\x00tags\x00document_100" "document_100" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_100', 'document_100');
80	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: [`1732192160 [ "document_100\x00tags\x00" "asset_341\x00tags\x00" "asset_360\x00tags\x00" "document_57\x00tags\x00" "document_54\x00tags\x00" "document_55\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_100\0tags\0', 'asset_341\0tags\0', 'asset_360\0tags\0', 'document_57\0tags\0', 'document_54\0tags\0', 'document_55\0tags\0');
81	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: [`1732192160 [ "\x00tags\x00document_101" "document_101" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_101', 'document_101');
82	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: [`1732192160 [ "document_101\x00tags\x00" "asset_319\x00tags\x00" "asset_321\x00tags\x00" "asset_341\x00tags\x00" "asset_14\x00tags\x00" "asset_46\x00tags\x00" "asset_57\x00tags\x00" "asset_13\x00tags\x00" "asset_81\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_101\0tags\0', 'asset_319\0tags\0', 'asset_321\0tags\0', 'asset_341\0tags\0', 'asset_14\0tags\0', 'asset_46\0tags\0', 'asset_57\0tags\0', 'asset_13\0tags\0', 'asset_81\0tags\0');
83	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: [`1732192160 [ "\x00tags\x00document_102" "document_102" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_102', 'document_102');
84	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: [`1732192160 [ "document_102\x00tags\x00" "asset_336\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_102\0tags\0', 'asset_336\0tags\0');
85	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: [`1732192160 [ "\x00tags\x00document_103" "document_103" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_103', 'document_103');
86	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: [`1732192160 [ "document_103\x00tags\x00" "asset_25\x00tags\x00" "asset_340\x00tags\x00" "asset_341\x00tags\x00" "asset_35\x00tags\x00" "asset_123\x00tags\x00" "asset_114\x00tags\x00" "asset_186\x00tags\x00" "asset_127\x00tags\x00" "asset_277\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_103\0tags\0', 'asset_25\0tags\0', 'asset_340\0tags\0', 'asset_341\0tags\0', 'asset_35\0tags\0', 'asset_123\0tags\0', 'asset_114\0tags\0', 'asset_186\0tags\0', 'asset_127\0tags\0', 'asset_277\0tags\0');
87	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: [`1732192160 [ "\x00tags\x00document_104" "document_104" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_104', 'document_104');
88	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: [`1732192160 [ "\x00tags\x00document_48" "document_48" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_48', 'document_48');
89	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: [`1732192160 [ "document_48\x00tags\x00" "asset_62\x00tags\x00" "asset_63\x00tags\x00" "asset_321\x00tags\x00" "asset_319\x00tags\x00" "asset_362\x00tags\x00" "asset_340\x00tags\x00" "asset_317\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_48\0tags\0', 'asset_62\0tags\0', 'asset_63\0tags\0', 'asset_321\0tags\0', 'asset_319\0tags\0', 'asset_362\0tags\0', 'asset_340\0tags\0', 'asset_317\0tags\0');
90	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: [`1732192160 [ "\x00tags\x00document_52" "document_52" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_52', 'document_52');
91	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: [`1732192160 [ "\x00tags\x00document_112" "document_112" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_112', 'document_112');
92	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: [`1732192160 [ "document_112\x00tags\x00" "asset_336\x00tags\x00" "asset_382\x00tags\x00" "asset_378\x00tags\x00" "asset_374\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_112\0tags\0', 'asset_336\0tags\0', 'asset_382\0tags\0', 'asset_378\0tags\0', 'asset_374\0tags\0');
93	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: [`1732192160 [ "\x00tags\x00document_49" "document_49" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_49', 'document_49');
94	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: [`1732192160 [ "document_49\x00tags\x00" "asset_252\x00tags\x00" "asset_250\x00tags\x00" "asset_249\x00tags\x00" "asset_251\x00tags\x00" "asset_115\x00tags\x00" "asset_117\x00tags\x00" "asset_114\x00tags\x00" "asset_35\x00tags\x00" "asset_36\x00tags\x00" "asset_41\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_49\0tags\0', 'asset_252\0tags\0', 'asset_250\0tags\0', 'asset_249\0tags\0', 'asset_251\0tags\0', 'asset_115\0tags\0', 'asset_117\0tags\0', 'asset_114\0tags\0', 'asset_35\0tags\0', 'asset_36\0tags\0', 'asset_41\0tags\0');
95	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: [`1732192160 [ "\x00tags\x00document_113" "document_113" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_113', 'document_113');
96	0.11 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: [`1732192160 [ "\x00tags\x00document_39" "document_39" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_39', 'document_39');
97	0.11 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: [`1732192160 [ "document_39\x00tags\x00" "asset_345\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_39\0tags\0', 'asset_345\0tags\0');
98	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: [`1732192160 [ "\x00tags\x00document_50" "document_50" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_50', 'document_50');
99	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: [`1732192160 [ "\x00tags\x00document_38" "document_38" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_38', 'document_38');
100	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: [`1732192160 [ "\x00tags\x00document_51" "document_51" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_51', 'document_51');
101	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: [`1732192160 [ "document_51\x00tags\x00" "asset_348\x00tags\x00" "asset_347\x00tags\x00" "asset_349\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_51\0tags\0', 'asset_348\0tags\0', 'asset_347\0tags\0', 'asset_349\0tags\0');
102	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: [`1732192160 [ "\x00tags\x00document_95" "document_95" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_95', 'document_95');
103	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: [`1732192160 [ "document_95\x00tags\x00" "object_75\x00tags\x00" "object_74\x00tags\x00" "object_399\x00tags\x00" "asset_384\x00tags\x00" "asset_385\x00tags\x00" "asset_386\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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_95\0tags\0', 'object_75\0tags\0', 'object_74\0tags\0', 'object_399\0tags\0', 'asset_384\0tags\0', 'asset_385\0tags\0', 'asset_386\0tags\0');
104	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: [`1732192160 [ "\x00tags\x00document_110" "document_110" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_110', 'document_110');
105	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: [`1732192160 [ "document_110\x00tags\x00" "document_104\x00tags\x00" "document_54\x00tags\x00" "document_55\x00tags\x00" "document_56\x00tags\x00" "document_57\x00tags\x00" "object_548\x00tags\x00" "object_561\x00tags\x00" "object_551\x00tags\x00" "object_550\x00tags\x00" "asset_390\x00tags\x00" "asset_391\x00tags\x00" "asset_392\x00tags\x00" "asset_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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_110\0tags\0', 'document_104\0tags\0', 'document_54\0tags\0', 'document_55\0tags\0', 'document_56\0tags\0', 'document_57\0tags\0', 'object_548\0tags\0', 'object_561\0tags\0', 'object_551\0tags\0', 'object_550\0tags\0', 'asset_390\0tags\0', 'asset_391\0tags\0', 'asset_392\0tags\0', 'asset_389\0tags\0');
106	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: [`1732192160 [ "\x00tags\x00document_88" "document_88" ]`] 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 > 1732192160 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_88', 'document_88');

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

https://pimcore-demo.profildoors.de/en/News/Videos~n1209

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache