Symfony Profiler

Query Metrics

66 Database Queries

9 Different statements

39.40 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path REGEXP ? AND  object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.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 `id`, `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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path REGEXP ? AND id != ? AND  object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `creationDate` DESC   LIMIT 3
SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = ? AND  object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title`
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = ? AND  object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title`
SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = ? AND  object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title`
SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = ? AND  object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title`
SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = ? AND  object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title`

#▲	Time	Info
1	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: [`1785495694 "site_domain_7a3f6476f82647e329c686245e107ee1"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_7a3f6476f82647e329c686245e107ee1');
2	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: [`1785495694 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	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: [`1785495694 "maintenance_mode"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('maintenance_mode');
4	0.22 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/fi/solutions/" "underground"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/fi/solutions/' AND `key` = BINARY 'underground';
5	0.20 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/fi/solutions/underground"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/fi/solutions/underground';
6	0.17 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/fi/" "solutions"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/fi/' AND `key` = BINARY 'solutions';
7	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/fi/solutions"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/fi/solutions';
8	0.18 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "fi"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'fi';
9	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: [`1785495694 "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 > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_136');
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: [`1785495694 "document_136\x01tags\x01" "document_137\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_136tags', 'document_137tags');
11	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: [`1785495694 "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 > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_136');
12	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: [`1785495694 "document_properties\x01tags\x01" "document_136\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_136tags');
13	0.55 ms	SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path REGEXP ? AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 Parameters: [`"^/Data Objects/BusinessDomain/[^/]+/$"`] View formatted query View runnable query Explain query SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE ( path REGEXP ? AND object_localized_3_fi_FI.type IN ('object', 'variant', 'folder') ) AND object_localized_3_fi_FI.published = 1 SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path REGEXP '^/Data Objects/BusinessDomain/[^/]+/$' AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1;
14	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: [`1785495694 "object_1017"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1017');
15	0.16 ms	SELECT `id`, `name` FROM classes WHERE id = ? Parameters: [`"3"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE id = ? SELECT `id`, `name` FROM classes WHERE id = '3' ;
16	1.99 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1785495694 "object_1017\x01tags\x01" "class_3\x01tags\x01" "asset_232\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1017tags', 'class_3tags', 'asset_232tags');
17	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: [`1785495694 "object_1026"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1026');
18	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: [`1785495694 "object_1026\x01tags\x01" "class_3\x01tags\x01" "asset_229\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1026tags', 'class_3tags', 'asset_229tags');
19	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: [`1785495694 "object_1028"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1028');
20	1.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: [`1785495694 "object_1028\x01tags\x01" "class_3\x01tags\x01" "asset_231\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1028tags', 'class_3tags', 'asset_231tags');
21	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: [`1785495694 "object_1415"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1415');
22	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: [`1785495694 "object_1415\x01tags\x01" "class_3\x01tags\x01" "asset_226\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1415tags', 'class_3tags', 'asset_226tags');
23	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: [`1785495694 "object_1416"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1416');
24	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: [`1785495694 "object_1416\x01tags\x01" "class_3\x01tags\x01" "asset_227\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1416tags', 'class_3tags', 'asset_227tags');
25	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: [`1785495694 "object_1417"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1417');
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: [`1785495694 "object_1417\x01tags\x01" "class_3\x01tags\x01" "asset_228\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1417tags', 'class_3tags', 'asset_228tags');
27	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: [`1785495694 "object_1418"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1418');
28	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: [`1785495694 "object_1418\x01tags\x01" "class_3\x01tags\x01" "asset_229\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1418tags', 'class_3tags', 'asset_229tags');
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: [`1785495694 "object_1420"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1420');
30	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: [`1785495694 "object_1420\x01tags\x01" "class_3\x01tags\x01" "asset_231\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1420tags', 'class_3tags', 'asset_231tags');
31	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: [`1785495694 "object_1421"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1421');
32	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: [`1785495694 "object_1421\x01tags\x01" "class_3\x01tags\x01" "asset_232\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1421tags', 'class_3tags', 'asset_232tags');
33	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: [`1785495694 "object_1422"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1422');
34	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: [`1785495694 "object_1422\x01tags\x01" "class_3\x01tags\x01" "asset_233\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1422tags', 'class_3tags', 'asset_233tags');
35	0.43 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1785495694 "object_1423"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1423');
36	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: [`1785495694 "object_1423\x01tags\x01" "class_3\x01tags\x01" "asset_234\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1423tags', 'class_3tags', 'asset_234tags');
37	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: [`1785495694 "object_1424"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1424');
38	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: [`1785495694 "object_1424\x01tags\x01" "class_3\x01tags\x01" "asset_235\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1424tags', 'class_3tags', 'asset_235tags');
39	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: [`1785495694 "object_1425"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1425');
40	0.40 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1785495694 "object_1425\x01tags\x01" "class_3\x01tags\x01" "asset_236\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1425tags', 'class_3tags', 'asset_236tags');
41	0.55 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1785495694 "object_1426"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1426');
42	0.32 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1785495694 "object_1426\x01tags\x01" "class_3\x01tags\x01" "asset_226\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1426tags', 'class_3tags', 'asset_226tags');
43	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: [`1785495694 "object_1427"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1427');
44	0.23 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1785495694 "object_1427\x01tags\x01" "class_3\x01tags\x01" "asset_227\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1427tags', 'class_3tags', 'asset_227tags');
45	0.26 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1785495694 "object_1428"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1428');
46	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1785495694 "object_1428\x01tags\x01" "class_3\x01tags\x01" "asset_228\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1428tags', 'class_3tags', 'asset_228tags');
47	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: [`1785495694 "object_1429"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1429');
48	18.71 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1785495694 "object_1429\x01tags\x01" "class_3\x01tags\x01" "asset_229\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1429tags', 'class_3tags', 'asset_229tags');
49	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: [`1785495694 "object_1430"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1430');
50	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: [`1785495694 "object_1430\x01tags\x01" "class_3\x01tags\x01" "asset_231\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1430tags', 'class_3tags', 'asset_231tags');
51	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: [`1785495694 "object_1431"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1431');
52	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: [`1785495694 "object_1431\x01tags\x01" "class_3\x01tags\x01" "asset_232\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1431tags', 'class_3tags', 'asset_232tags');
53	0.71 ms	SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path REGEXP ? AND id != ? AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `creationDate` DESC LIMIT 3 Parameters: [`"^/Data Objects/BusinessDomain/[^/]+/$" 1429`] View formatted query View runnable query Explain query SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE ( path REGEXP ? AND id != ? AND object_localized_3_fi_FI.type IN ('object', 'variant', 'folder') ) AND object_localized_3_fi_FI.published = 1 ORDER BY `creationDate` DESC LIMIT 3 SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path REGEXP '^/Data Objects/BusinessDomain/[^/]+/$' AND id != 1429 AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `creationDate` DESC LIMIT 3;
54	0.53 ms	SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = ? AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` Parameters: [`"/Data Objects/BusinessDomain/"`] View formatted query View runnable query Explain query SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE ( path = ? AND object_localized_3_fi_FI.type IN ('object', 'variant', 'folder') ) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = '/Data Objects/BusinessDomain/' AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` ;
55	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: [`1785495694 "object_1414"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1414');
56	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: [`1785495694 "object_1414\x01tags\x01" "class_3\x01tags\x01" "asset_225\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1414tags', 'class_3tags', 'asset_225tags');
57	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: [`1785495694 "object_1419"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1419');
58	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: [`1785495694 "object_1419\x01tags\x01" "class_3\x01tags\x01" "asset_230\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1419tags', 'class_3tags', 'asset_230tags');
59	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: [`1785495694 "object_1012"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1012');
60	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1785495694 "object_1012\x01tags\x01" "class_3\x01tags\x01" "asset_190\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1012tags', 'class_3tags', 'asset_190tags');
61	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1785495694 "object_1013"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1013');
62	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: [`1785495694 "object_1013\x01tags\x01" "class_3\x01tags\x01" "asset_190\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1785495694 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1013tags', 'class_3tags', 'asset_190tags');
63	0.52 ms	SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = ? AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` Parameters: [`"/Data Objects/BusinessDomain/Electro & Installation/"`] View formatted query View runnable query Explain query SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE ( path = ? AND object_localized_3_fi_FI.type IN ('object', 'variant', 'folder') ) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = '/Data Objects/BusinessDomain/Electro & Installation/' AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` ;
64	0.50 ms	SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = ? AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` Parameters: [`"/Data Objects/BusinessDomain/Infrastructure & Transport/"`] View formatted query View runnable query Explain query SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE ( path = ? AND object_localized_3_fi_FI.type IN ('object', 'variant', 'folder') ) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = '/Data Objects/BusinessDomain/Infrastructure & Transport/' AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` ;
65	0.54 ms	SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = ? AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` Parameters: [`"/Data Objects/BusinessDomain/Power & Grid/"`] View formatted query View runnable query Explain query SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE ( path = ? AND object_localized_3_fi_FI.type IN ('object', 'variant', 'folder') ) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = '/Data Objects/BusinessDomain/Power & Grid/' AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` ;
66	0.62 ms	SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = ? AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` Parameters: [`"/Data Objects/BusinessDomain/Telecom & Fiber/"`] View formatted query View runnable query Explain query SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE ( path = ? AND object_localized_3_fi_FI.type IN ('object', 'variant', 'folder') ) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` SELECT object_localized_3_fi_FI.id as id, object_localized_3_fi_FI.type as `type` FROM object_localized_3_fi_FI WHERE (path = '/Data Objects/BusinessDomain/Telecom & Fiber/' AND object_localized_3_fi_FI.type IN ('object','variant','folder')) AND object_localized_3_fi_FI.published = 1 ORDER BY `title` ;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET http://dev-pim.melbye.no/fi/solutions/underground

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping