Symfony Profiler

Query Metrics

69 Database Queries

14 Different statements

11.07 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT * FROM object_url_slugs WHERE slug = '/en/home' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT * FROM documents_editables WHERE documentId = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `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 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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 d WHERE parentId = ?  AND published = 1 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 id FROM documents d WHERE parentId = ?  AND published = 1 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 id FROM documents d WHERE parentId = ?  AND published = 1 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 id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1

#▲	Time	Info
1	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: [`1780276929 "site_domain_445f530be40f505ee05a6cf8a6de62e3"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_445f530be40f505ee05a6cf8a6de62e3');
2	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1780276929 "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 > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	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: [`1780276929 "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 > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('maintenance_mode');
4	0.24 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/" "home"`] 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 'home';
5	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: [`1780276929 "document_10"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_10');
6	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: [`1780276929 "document_10\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 > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_10tags');
7	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: [`1780276929 "sites_path_mapping"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('sites_path_mapping');
8	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: [`1780276929 "\x00tags\x00sites_path_mapping"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0sites_path_mapping');
9	0.19 ms	SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites ORDER BY ( SELECT LENGTH( CONCAT(`path`, `key`) ) FROM documents WHERE documents.id = sites.rootId ) DESC SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC ;
10	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "document_properties_10"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_10');
11	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: [`1780276929 "document_properties\x01tags\x01" "document_10\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 > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_10tags');
12	0.16 ms	SELECT * FROM object_url_slugs WHERE slug = '/en/home' 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/home' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/en/home' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
13	0.27 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 10;
14	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: [`1780276929 "object_1116"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1116');
15	0.15 ms	SELECT `id`, `name` FROM classes WHERE id = ? Parameters: [`"7"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE id = ? SELECT `id`, `name` FROM classes WHERE id = '7' ;
16	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: [`1780276929 "object_1116\x01tags\x01" "class_7\x01tags\x01" "asset_21\x01tags\x01" "asset_20\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 > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1116tags', 'class_7tags', 'asset_21tags', 'asset_20tags');
17	0.16 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';
18	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "document_8"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_8');
19	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: [`1780276929 "document_8\x01tags\x01" "document_10\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 > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_8tags', 'document_10tags');
20	0.23 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`8`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 8 AND published = 1 LIMIT 1;
21	0.22 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`8`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 8) AND published = 1 ORDER BY `index` ASC ;
22	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: [`1780276929 "document_16"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_16');
23	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "document_16\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 > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_16tags');
24	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "document_17"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_17');
25	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "document_17\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 > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_17tags');
26	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "document_18"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_18');
27	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: [`1780276929 "document_18\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 > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_18tags');
28	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`10`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 10 AND published = 1 LIMIT 1;
29	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "document_properties_16"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_16');
30	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`16`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 16 AND published = 1 LIMIT 1;
31	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "document_properties_17"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_17');
32	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`17`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 17 AND published = 1 LIMIT 1;
33	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "document_properties_18"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_18');
34	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`18`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 18 AND published = 1 LIMIT 1;
35	0.15 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/da/" "home"`] 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 '/da/' AND `key` = BINARY 'home';
36	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "document_11"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_11');
37	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "document_11\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 > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_11tags');
38	0.15 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 21;
39	0.17 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 21;
40	0.15 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"_auto_ee1e138f29e8495e41cd238858ca0fe2" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '_auto_ee1e138f29e8495e41cd238858ca0fe2' AND scope = 'pimcore_image_thumbnails';
41	0.14 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_21__be2ccc80f50407d592c1172b6732880a"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_21__be2ccc80f50407d592c1172b6732880a';
42	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "imagick_format_avif"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_avif');
43	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1780276929 "imagick_format_webp"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780276929 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_webp');
44	0.14 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"_auto_ee1e138f29e8495e41cd238858ca0fe2" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '_auto_ee1e138f29e8495e41cd238858ca0fe2' AND scope = 'pimcore_image_thumbnails';
45	0.14 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_21__55f4ab86db1b47ed8ec2ad44316f42b5"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_21__55f4ab86db1b47ed8ec2ad44316f42b5';
46	0.14 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"_auto_ee1e138f29e8495e41cd238858ca0fe2" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '_auto_ee1e138f29e8495e41cd238858ca0fe2' AND scope = 'pimcore_image_thumbnails';
47	0.17 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_21__f0c10a8955b40c094a5753da2c0bc6b9"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_21__f0c10a8955b40c094a5753da2c0bc6b9';
48	0.14 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"_auto_ee1e138f29e8495e41cd238858ca0fe2" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '_auto_ee1e138f29e8495e41cd238858ca0fe2' AND scope = 'pimcore_image_thumbnails';
49	0.17 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_21__55f4ab86db1b47ed8ec2ad44316f42b5"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_21__55f4ab86db1b47ed8ec2ad44316f42b5';
50	0.14 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"_auto_ee1e138f29e8495e41cd238858ca0fe2" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '_auto_ee1e138f29e8495e41cd238858ca0fe2' AND scope = 'pimcore_image_thumbnails';
51	0.14 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_21__be2ccc80f50407d592c1172b6732880a"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_21__be2ccc80f50407d592c1172b6732880a';
52	0.14 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`20`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 20;
53	0.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`20`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 20;
54	0.14 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"_auto_52fc615142f7afde15c2f9bd1f462a12" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '_auto_52fc615142f7afde15c2f9bd1f462a12' AND scope = 'pimcore_image_thumbnails';
55	0.14 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_20__58f0a4c6aa7ebc412c980ebaab5bb77f"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_20__58f0a4c6aa7ebc412c980ebaab5bb77f';
56	0.14 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"_auto_52fc615142f7afde15c2f9bd1f462a12" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '_auto_52fc615142f7afde15c2f9bd1f462a12' AND scope = 'pimcore_image_thumbnails';
57	0.13 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_20__d220260b004a64f9f7b22a4b98d419aa"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_20__d220260b004a64f9f7b22a4b98d419aa';
58	0.14 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"_auto_52fc615142f7afde15c2f9bd1f462a12" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '_auto_52fc615142f7afde15c2f9bd1f462a12' AND scope = 'pimcore_image_thumbnails';
59	0.13 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_20__893a6b40ca27484e7d6187abca103d14"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_20__893a6b40ca27484e7d6187abca103d14';
60	0.14 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"_auto_52fc615142f7afde15c2f9bd1f462a12" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '_auto_52fc615142f7afde15c2f9bd1f462a12' AND scope = 'pimcore_image_thumbnails';
61	0.13 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_20__d220260b004a64f9f7b22a4b98d419aa"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_20__d220260b004a64f9f7b22a4b98d419aa';
62	0.14 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"_auto_52fc615142f7afde15c2f9bd1f462a12" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '_auto_52fc615142f7afde15c2f9bd1f462a12' AND scope = 'pimcore_image_thumbnails';
63	0.13 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_20__58f0a4c6aa7ebc412c980ebaab5bb77f"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_20__58f0a4c6aa7ebc412c980ebaab5bb77f';
64	0.17 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`8`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 8 AND published = 1 LIMIT 1;
65	0.18 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`8`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 8) AND published = 1 ORDER BY `index` ASC ;
66	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`10`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 10 AND published = 1 LIMIT 1;
67	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`16`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 16 AND published = 1 LIMIT 1;
68	0.18 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`17`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 17 AND published = 1 LIMIT 1;
69	0.16 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`18`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 18 AND published = 1 LIMIT 1;

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://51.12.243.121/en/home

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping