Symfony Profiler

Query Metrics

105 Database Queries

47 Different statements

77.56 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 * FROM tmp_store 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 settings_store WHERE id = ? AND scope = ?
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 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 documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_page.*, tree_locks.locked FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT * FROM object_url_slugs WHERE slug = '/en/product/s114sq' AND siteId = 0 ORDER BY siteId DESC 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 `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = ?
SELECT * FROM object_brick_store_varianti_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_variantiFrassino_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_fustoGrezzo_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_fustoGrezzoFrassino_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_pannelliGommeTappezzeria_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_materialeImballo_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_componentiLegno_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_componentiLegnoFrassino_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_componentiPaglia_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_tipiDiVerniciatura_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_tipiDiVerniciaturaFrassino_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_tappezzeriaStoffa_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_tappezzeriaPelle_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_imballoSedieFinite_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_consumi_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_fasceDiSconto_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_localized_fasceDiSconto_prod WHERE ooo_id = ? AND language IN ('en','de','fr') AND `fieldname` = ?
SELECT * FROM object_brick_store_altro_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_localized_altro_prod WHERE ooo_id = ? AND language IN ('en','de','fr') AND `fieldname` = ?
SELECT * FROM object_brick_store_altroFrassino_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE 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 properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_rivcat WHERE oo_id = ? FOR UPDATE
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_localized_data_rivcat WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_rivcat WHERE src_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 `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_rivcat WHERE oo_id = ? FOR UPDATE
SELECT * FROM object_localized_data_rivcat WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_rivcat WHERE src_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 `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_rivcat WHERE oo_id = ? FOR UPDATE
SELECT * FROM object_localized_data_rivcat WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_rivcat WHERE src_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 `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_fintip WHERE oo_id = ? FOR UPDATE
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_localized_data_fintip WHERE ooo_id = ? AND language IN ('en','de','fr')
SELECT * FROM object_relations_fintip WHERE src_id = ?
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 documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, documents_snippet.*, tree_locks.locked FROM documents
            LEFT JOIN documents_snippet ON documents.id = documents_snippet.id
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.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 documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,50,3) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
SELECT * FROM documents_editables WHERE documentId = ?

#▲	Time	Info
1	0.82 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1768782350 "site_domain_0baaae1edeed76d97c0b72cce9d44524"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_0baaae1edeed76d97c0b72cce9d44524');
2	0.65 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1768782350 "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 > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.51 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
4	0.47 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1768782350 "output_37e4c1fa392a371efaf7a81dd087e5f8_desktop"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_37e4c1fa392a371efaf7a81dd087e5f8_desktop');
5	0.38 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1768782350 "\x00tags\x00output_37e4c1fa392a371efaf7a81dd087e5f8_desktop"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_37e4c1fa392a371efaf7a81dd087e5f8_desktop');
6	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: [`1768782350 "output_37e4c1fa392a371efaf7a81dd087e5f8"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_37e4c1fa392a371efaf7a81dd087e5f8');
7	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: [`1768782350 "\x00tags\x00output_37e4c1fa392a371efaf7a81dd087e5f8"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_37e4c1fa392a371efaf7a81dd087e5f8');
8	0.65 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"reports" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
9	0.87 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/product/" "s114sq"`] 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 '/en/product/' AND `key` = BINARY 's114sq';
10	0.61 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/product/s114sq"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/product/s114sq';
11	0.51 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/product/" "s114sq"`] 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 '/en/product/' AND `key` = BINARY 's114sq';
12	0.39 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/product/s114sq"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/product/s114sq';
13	0.46 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/" "product"`] 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 '/en/' AND `key` = BINARY 'product';
14	0.37 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/product"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/product';
15	0.46 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "en"`] 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 'en';
16	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: [`1768782350 "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 > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_3');
17	0.33 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1768782350 "\x00tags\x00document_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 > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_3');
18	0.69 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 3;
19	0.66 ms	SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_page., tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 3;
20	0.46 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1768782350 "document_1"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
21	0.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: [`1768782350 "document_1\x01tags\x01" "asset_4112\x01tags\x01" "asset_4113\x01tags\x01" "asset_2511\x01tags\x01" "asset_11\x01tags\x01" "asset_12\x01tags\x01" "asset_13\x01tags\x01" "asset_2507\x01tags\x01" "asset_2510\x01tags\x01" "asset_2509\x01tags\x01" "asset_2508\x01tags\x01" "asset_4110\x01tags\x01" "asset_4109\x01tags\x01" "asset_4108\x01tags\x01" "asset_16\x01tags\x01" "asset_17\x01tags\x01" "asset_4111\x01tags\x01" "asset_3247\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 > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags', 'asset_4112tags', 'asset_4113tags', 'asset_2511tags', 'asset_11tags', 'asset_12tags', 'asset_13tags', 'asset_2507tags', 'asset_2510tags', 'asset_2509tags', 'asset_2508tags', 'asset_4110tags', 'asset_4109tags', 'asset_4108tags', 'asset_16tags', 'asset_17tags', 'asset_4111tags', 'asset_3247tags');
22	0.86 ms	SELECT * FROM object_url_slugs WHERE slug = '/en/product/s114sq' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/en/product/s114sq' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/en/product/s114sq' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
23	0.46 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1768782350 "object_5466"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_5466');
24	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: [`1768782350 "\x00tags\x00object_5466"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782350 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_5466');
25	0.70 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`5466`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 5466;
26	0.71 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`5466`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 5466;
27	1.14 ms	SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE Parameters: [`5466`] View formatted query View runnable query Explain query SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_prod WHERE oo_id = 5466 FOR UPDATE;
28	0.70 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"prod"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'prod';
29	1.32 ms	SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`5466`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_prod WHERE ooo_id = 5466 AND language IN ('en','de','fr');
30	0.58 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1768782351 "asset_3879"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_3879');
31	0.44 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1768782351 "\x00tags\x00asset_3879"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_3879');
32	0.90 ms	SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? Parameters: [`3879`] View formatted query View runnable query Explain query SELECT assets., tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ? SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 3879;
33	2.62 ms	SELECT * FROM object_brick_store_varianti_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "varianti"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_varianti_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_varianti_prod WHERE id = 5466 AND fieldname = 'varianti';
34	0.61 ms	SELECT * FROM object_brick_store_variantiFrassino_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "variantiFrassino"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_variantiFrassino_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_variantiFrassino_prod WHERE id = 5466 AND fieldname = 'variantiFrassino';
35	2.03 ms	SELECT * FROM object_brick_store_fustoGrezzo_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "fustoGrezzo"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_fustoGrezzo_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_fustoGrezzo_prod WHERE id = 5466 AND fieldname = 'fustoGrezzo';
36	0.68 ms	SELECT * FROM object_brick_store_fustoGrezzoFrassino_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "fustoGrezzoFrassino"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_fustoGrezzoFrassino_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_fustoGrezzoFrassino_prod WHERE id = 5466 AND fieldname = 'fustoGrezzoFrassino';
37	2.11 ms	SELECT * FROM object_brick_store_pannelliGommeTappezzeria_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "pannelliGommeTappezzeria"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_pannelliGommeTappezzeria_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_pannelliGommeTappezzeria_prod WHERE id = 5466 AND fieldname = 'pannelliGommeTappezzeria';
38	1.45 ms	SELECT * FROM object_brick_store_materialeImballo_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "materialeImballo"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_materialeImballo_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_materialeImballo_prod WHERE id = 5466 AND fieldname = 'materialeImballo';
39	0.70 ms	SELECT * FROM object_brick_store_componentiLegno_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "componentiLegno"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_componentiLegno_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_componentiLegno_prod WHERE id = 5466 AND fieldname = 'componentiLegno';
40	1.02 ms	SELECT * FROM object_brick_store_componentiLegnoFrassino_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "componentiLegnoFrassino"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_componentiLegnoFrassino_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_componentiLegnoFrassino_prod WHERE id = 5466 AND fieldname = 'componentiLegnoFrassino';
41	1.47 ms	SELECT * FROM object_brick_store_componentiPaglia_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "componentiPaglia"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_componentiPaglia_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_componentiPaglia_prod WHERE id = 5466 AND fieldname = 'componentiPaglia';
42	2.22 ms	SELECT * FROM object_brick_store_tipiDiVerniciatura_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "tipiDiVerniciatura"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_tipiDiVerniciatura_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_tipiDiVerniciatura_prod WHERE id = 5466 AND fieldname = 'tipiDiVerniciatura';
43	0.89 ms	SELECT * FROM object_brick_store_tipiDiVerniciaturaFrassino_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "tipiDiVerniciaturaFrassino"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_tipiDiVerniciaturaFrassino_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_tipiDiVerniciaturaFrassino_prod WHERE id = 5466 AND fieldname = 'tipiDiVerniciaturaFrassino';
44	2.19 ms	SELECT * FROM object_brick_store_tappezzeriaStoffa_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "tappezzeriaStoffa"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_tappezzeriaStoffa_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_tappezzeriaStoffa_prod WHERE id = 5466 AND fieldname = 'tappezzeriaStoffa';
45	2.02 ms	SELECT * FROM object_brick_store_tappezzeriaPelle_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "tappezzeriaPelle"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_tappezzeriaPelle_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_tappezzeriaPelle_prod WHERE id = 5466 AND fieldname = 'tappezzeriaPelle';
46	1.47 ms	SELECT * FROM object_brick_store_imballoSedieFinite_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "imballoSedieFinite"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_imballoSedieFinite_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_imballoSedieFinite_prod WHERE id = 5466 AND fieldname = 'imballoSedieFinite';
47	1.79 ms	SELECT * FROM object_brick_store_consumi_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "consumi"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_consumi_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_consumi_prod WHERE id = 5466 AND fieldname = 'consumi';
48	1.38 ms	SELECT * FROM object_brick_store_fasceDiSconto_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "fasceDiSconto"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_fasceDiSconto_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_fasceDiSconto_prod WHERE id = 5466 AND fieldname = 'fasceDiSconto';
49	3.80 ms	SELECT * FROM object_brick_localized_fasceDiSconto_prod WHERE ooo_id = ? AND language IN ('en','de','fr') AND `fieldname` = ? Parameters: [`5466 "fasceDiSconto"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_localized_fasceDiSconto_prod WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') AND `fieldname` = ? SELECT * FROM object_brick_localized_fasceDiSconto_prod WHERE ooo_id = 5466 AND language IN ('en','de','fr') AND `fieldname` = 'fasceDiSconto';
50	0.38 ms	SELECT * FROM object_brick_store_altro_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "altro"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_altro_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_altro_prod WHERE id = 5466 AND fieldname = 'altro';
51	1.96 ms	SELECT * FROM object_brick_localized_altro_prod WHERE ooo_id = ? AND language IN ('en','de','fr') AND `fieldname` = ? Parameters: [`5466 "altro"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_localized_altro_prod WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') AND `fieldname` = ? SELECT * FROM object_brick_localized_altro_prod WHERE ooo_id = 5466 AND language IN ('en','de','fr') AND `fieldname` = 'altro';
52	0.27 ms	SELECT * FROM object_brick_store_altroFrassino_prod WHERE id = ? AND fieldname = ? Parameters: [`5466 "altroFrassino"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_altroFrassino_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_altroFrassino_prod WHERE id = 5466 AND fieldname = 'altroFrassino';
53	0.77 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`5466`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 5466;
54	0.60 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/product/" "s114sq"`] 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 '/en/product/' AND `key` = BINARY 's114sq';
55	0.15 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/product/s114sq"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/product/s114sq';
56	0.17 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/" "product"`] 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 '/en/' AND `key` = BINARY 'product';
57	0.13 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en/product"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en/product';
58	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: [`1768782351 "document_properties_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 > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_3');
59	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: [`1768782351 "\x00tags\x00document_properties_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 > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_3');
60	2.41 ms	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = 3 ) AND ctype='document';
61	0.35 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1768782351 "object_964"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_964');
62	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: [`1768782351 "\x00tags\x00object_964"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_964');
63	0.56 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`964`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 964;
64	0.33 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`964`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 964;
65	2.10 ms	SELECT * FROM object_store_rivcat WHERE oo_id = ? FOR UPDATE Parameters: [`964`] View formatted query View runnable query Explain query SELECT * FROM object_store_rivcat WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_rivcat WHERE oo_id = 964 FOR UPDATE;
66	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"rivcat"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'rivcat';
67	2.09 ms	SELECT * FROM object_localized_data_rivcat WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`964`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_rivcat WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_rivcat WHERE ooo_id = 964 AND language IN ('en','de','fr');
68	1.83 ms	SELECT * FROM object_relations_rivcat WHERE src_id = ? Parameters: [`964`] View formatted query View runnable query Explain query SELECT * FROM object_relations_rivcat WHERE src_id = ? SELECT * FROM object_relations_rivcat WHERE src_id = 964;
69	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1768782351 "object_963"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_963');
70	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: [`1768782351 "\x00tags\x00object_963"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_963');
71	0.13 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`963`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 963;
72	0.20 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`963`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 963;
73	0.13 ms	SELECT * FROM object_store_rivcat WHERE oo_id = ? FOR UPDATE Parameters: [`963`] View formatted query View runnable query Explain query SELECT * FROM object_store_rivcat WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_rivcat WHERE oo_id = 963 FOR UPDATE;
74	0.19 ms	SELECT * FROM object_localized_data_rivcat WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`963`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_rivcat WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_rivcat WHERE ooo_id = 963 AND language IN ('en','de','fr');
75	0.15 ms	SELECT * FROM object_relations_rivcat WHERE src_id = ? Parameters: [`963`] View formatted query View runnable query Explain query SELECT * FROM object_relations_rivcat WHERE src_id = ? SELECT * FROM object_relations_rivcat WHERE src_id = 963;
76	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: [`1768782351 "object_965"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_965');
77	0.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1768782351 "\x00tags\x00object_965"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_965');
78	0.13 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`965`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 965;
79	0.18 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`965`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 965;
80	0.13 ms	SELECT * FROM object_store_rivcat WHERE oo_id = ? FOR UPDATE Parameters: [`965`] View formatted query View runnable query Explain query SELECT * FROM object_store_rivcat WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_rivcat WHERE oo_id = 965 FOR UPDATE;
81	0.18 ms	SELECT * FROM object_localized_data_rivcat WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`965`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_rivcat WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_rivcat WHERE ooo_id = 965 AND language IN ('en','de','fr');
82	0.15 ms	SELECT * FROM object_relations_rivcat WHERE src_id = ? Parameters: [`965`] View formatted query View runnable query Explain query SELECT * FROM object_relations_rivcat WHERE src_id = ? SELECT * FROM object_relations_rivcat WHERE src_id = 965;
83	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: [`1768782351 "object_959"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_959');
84	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: [`1768782351 "\x00tags\x00object_959"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_959');
85	0.12 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`959`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 959;
86	0.26 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`959`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 959;
87	1.57 ms	SELECT * FROM object_store_fintip WHERE oo_id = ? FOR UPDATE Parameters: [`959`] View formatted query View runnable query Explain query SELECT * FROM object_store_fintip WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_fintip WHERE oo_id = 959 FOR UPDATE;
88	0.20 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"fintip"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'fintip';
89	1.74 ms	SELECT * FROM object_localized_data_fintip WHERE ooo_id = ? AND language IN ('en','de','fr') Parameters: [`959`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_fintip WHERE ooo_id = ? AND language IN ('en', 'de', 'fr') SELECT * FROM object_localized_data_fintip WHERE ooo_id = 959 AND language IN ('en','de','fr');
90	2.18 ms	SELECT * FROM object_relations_fintip WHERE src_id = ? Parameters: [`959`] View formatted query View runnable query Explain query SELECT * FROM object_relations_fintip WHERE src_id = ? SELECT * FROM object_relations_fintip WHERE src_id = 959;
91	0.53 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/snippets/" "customhead"`] 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 '/en/snippets/' AND `key` = BINARY 'customhead';
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: [`1768782351 "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 > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_51');
93	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: [`1768782351 "\x00tags\x00document_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 > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_51');
94	0.18 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`51`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 51;
95	2.14 ms	SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`51`] View formatted query View runnable query Explain query SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents., documents_snippet., tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 51;
96	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: [`1768782351 "tag_inc__0588d15bb51592246cc9d9d4a11710a1"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tag_inc__0588d15bb51592246cc9d9d4a11710a1');
97	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: [`1768782351 "\x00tags\x00tag_inc__0588d15bb51592246cc9d9d4a11710a1"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0tag_inc__0588d15bb51592246cc9d9d4a11710a1');
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: [`1768782351 "document_properties_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 > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_51');
99	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: [`1768782351 "\x00tags\x00document_properties_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 > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_51');
100	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: [`1768782351 "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 > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_50');
101	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: [`1768782351 "\x00tags\x00document_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 > 1768782351 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_50');
102	0.17 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`50`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 50;
103	0.22 ms	SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? Parameters: [`50`] View formatted query View runnable query Explain query SELECT documents., tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ? SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = 50;
104	0.32 ms	SELECT * FROM properties WHERE ( (cid IN (1,50,3) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`51`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 50, 3) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,50,3) AND inheritable = 1) OR cid = 51 ) AND ctype='document';
105	2.02 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`51`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 51;

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.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.

Symfony Profiler

GET https://busetto.friedbrains.it/_fragment?_path=_locale%3Den%26_format%3Dhtml%26_controller%3DApp%255CController%255CDefaultController%253A%253AcustomheadAction

Configuration Settings

Theme

Page Width