Symfony Profiler

GET https://fifty-five.cn/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CDefaultController%253A%253AdefaultAction

Response: 200 OK
IP: 18.188.249.86
Profiled on: Sat, 19 Apr 2025 04:51:11 +0000
Token: cab14f

Query Metrics

117 Database Queries

17 Different statements

23.89 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
10.27 ms (42.99%)	53	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1745038271 "site_domain_9ae7fad3bb9377f37ba1d2d6ff944589"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1745038271 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_9ae7fad3bb9377f37ba1d2d6ff944589');
3.70 ms (15.48%)	18	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`91`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 91;
2.40 ms (10.04%)	11	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1745038271 "system\x01tags\x01" "site\x01tags\x01" "site_domain_9ae7fad3bb9377f37ba1d2d6ff944589\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 > 1745038271 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags', 'site_domain_9ae7fad3bb9377f37ba1d2d6ff944589tags');
1.34 ms (5.59%)	8	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"_auto_40cd750bba9870f18aada2478b24840a" "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_40cd750bba9870f18aada2478b24840a' AND scope = 'pimcore_image_thumbnails';
1.16 ms (4.84%)	8	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_91__177885eab997b061e0cc91df6e729c5d"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_91__177885eab997b061e0cc91df6e729c5d';
0.93 ms (3.89%)	3	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "about"`] 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 'about';
0.87 ms (3.65%)	3	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 8;
0.70 ms (2.93%)	4	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: [`45`] 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 = 45;
0.60 ms (2.51%)	1	SELECT object_4.id AS id, object_4.type AS `type` FROM object_4 WHERE ( object_4.type IN ('object','variant','folder')) AND object_4.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_4.id AS id, object_4.type AS `type` FROM object_4 WHERE ( object_4.type IN ('object', 'variant', 'folder') ) AND object_4.published = 1 SELECT object_4.id AS id, object_4.type AS `type` FROM object_4 WHERE ( object_4.type IN ('object','variant','folder')) AND object_4.published = 1;
0.34 ms (1.44%)	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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [1745038271 "output\x01tags\x01" "navigation\x01tags\x01" "document_28\x01tags\x01" "document_31\x01tags\x01" "document_32\x01tags\x01" "document_33\x01tags\x01" "document_4\x01tags\x01" "document_5\x01tags\x01" "document_6\x01tags\x01" "document_43\x01tags\x01" "document_39\x01tags\x01" "document_40\x01tags\x01" "document_41\x01tags\x01" "document_34\x01tags\x01" "document_42\x01tags\x01" "document_7\x01tags\x01" "document_8\x01tags\x01" "document_9\x01tags\x01" "document_10\x01tags\x01" "document_18\x01tags\x01" "document_47\x01tags\x01" "document_48\x01tags\x01" "document_44\x01tags\x01" "nav_5c4b242e936ff98d9730282bb67058e8\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 > 1745038271 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_28tags', 'document_31tags', 'document_32tags', 'document_33tags', 'document_4tags', 'document_5tags', 'document_6tags', 'document_43tags', 'document_39tags', 'document_40tags', 'document_41tags', 'document_34tags', 'document_42tags', 'document_7tags', 'document_8tags', 'document_9tags', 'document_10tags', 'document_18tags', 'document_47tags', 'document_48tags', 'document_44tags', 'nav_5c4b242e936ff98d9730282bb67058e8tags');
0.32 ms (1.32%)	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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`1745038271 "document_8\x01tags\x01" "asset_91\x01tags\x01" "asset_103\x01tags\x01" "asset_104\x01tags\x01" "asset_110\x01tags\x01" "asset_109\x01tags\x01" "asset_111\x01tags\x01" "asset_114\x01tags\x01" "asset_113\x01tags\x01" "asset_115\x01tags\x01" "asset_112\x01tags\x01" "asset_108\x01tags\x01" "asset_107\x01tags\x01" "asset_106\x01tags\x01" "asset_105\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 > 1745038271 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_8tags', 'asset_91tags', 'asset_103tags', 'asset_104tags', 'asset_110tags', 'asset_109tags', 'asset_111tags', 'asset_114tags', 'asset_113tags', 'asset_115tags', 'asset_112tags', 'asset_108tags', 'asset_107tags', 'asset_106tags', 'asset_105tags');
0.27 ms (1.11%)	1	SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) 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(`path`) FROM documents WHERE documents.id = sites.rootId ) DESC SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC ;
0.21 ms (0.86%)	1	SELECT * FROM object_url_slugs WHERE slug = '/about' 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 = '/about' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/about' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
0.20 ms (0.85%)	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 (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`1745038271 "document_1\x01tags\x01" "asset_48\x01tags\x01" "asset_103\x01tags\x01" "asset_104\x01tags\x01" "asset_105\x01tags\x01" "asset_106\x01tags\x01" "asset_108\x01tags\x01" "asset_107\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 > 1745038271 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags', 'asset_48tags', 'asset_103tags', 'asset_104tags', 'asset_105tags', 'asset_106tags', 'asset_108tags', 'asset_107tags');
0.20 ms (0.85%)	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 (?, ?, ?, ?, ?, ?, ?) Parameters: [`1745038271 "document_38\x01tags\x01" "asset_118\x01tags\x01" "asset_120\x01tags\x01" "asset_121\x01tags\x01" "asset_122\x01tags\x01" "asset_117\x01tags\x01" "asset_119\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 > 1745038271 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_38tags', 'asset_118tags', 'asset_120tags', 'asset_121tags', 'asset_122tags', 'asset_117tags', 'asset_119tags');
0.20 ms (0.83%)	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 (?, ?) Parameters: [`1745038271 "document_22\x01tags\x01" "asset_88\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 > 1745038271 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_22tags', 'asset_88tags');
0.19 ms (0.80%)	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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`1745038271 "document_10\x01tags\x01" "asset_65\x01tags\x01" "asset_70\x01tags\x01" "asset_73\x01tags\x01" "asset_74\x01tags\x01" "asset_68\x01tags\x01" "asset_72\x01tags\x01" "asset_67\x01tags\x01" "asset_66\x01tags\x01" "asset_69\x01tags\x01" "asset_71\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 > 1745038271 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_10tags', 'asset_65tags', 'asset_70tags', 'asset_73tags', 'asset_74tags', 'asset_68tags', 'asset_72tags', 'asset_67tags', 'asset_66tags', 'asset_69tags', 'asset_71tags');

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.

Entities Mapping

No mapped entities.