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: 3.147.48.123
Profiled on: Sat, 19 Apr 2025 13:52:24 +0000
Token: e548ff

Query Metrics

96 Database Queries

19 Different statements

24.37 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
9.82 ms (40.29%)	41	SELECT item_id, 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: [`1745070744 "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 > 1745070744 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_9ae7fad3bb9377f37ba1d2d6ff944589');
1.88 ms (7.70%)	9	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.71 ms (7.04%)	9	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_51__39e4ce95d4163dad45256605a6af497e"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_51__39e4ce95d4163dad45256605a6af497e';
1.66 ms (6.81%)	8	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;
1.32 ms (5.42%)	4	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/teahouse/" "gu-ge-guang-gao-xiao-guo-chai-zhe-xie-luo-di-ye-you-hua-yao-dian-ni-zuo-dui-liao-ma_copy~n82"`] 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 '/teahouse/' AND `key` = BINARY 'gu-ge-guang-gao-xiao-guo-chai-zhe-xie-luo-di-ye-you-hua-yao-dian-ni-zuo-dui-liao-ma_copy~n82';
1.28 ms (5.26%)	4	SELECT item_id, 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: [`1745070744 "object_83\x01tags\x01" "class_5\x01tags\x01" "asset_49\x01tags\x01" "asset_51\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 > 1745070744 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_83tags', 'class_5tags', 'asset_49tags', 'asset_51tags');
1.25 ms (5.14%)	4	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`51`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 51;
1.12 ms (4.61%)	4	SELECT item_id, 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: [`1745070744 "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 > 1745070744 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags', 'site_domain_9ae7fad3bb9377f37ba1d2d6ff944589tags');
0.78 ms (3.18%)	1	SELECT object_5.id AS id, object_5.type AS `type` FROM object_5 WHERE (id NOT IN (?) AND object_5.type IN ('object','variant','folder')) AND object_5.published = 1 ORDER BY `releaseDate` DESC LIMIT 3 Parameters: [`"82"`] View formatted query View runnable query Explain query SELECT object_5.id AS id, object_5.type AS `type` FROM object_5 WHERE ( id NOT IN (?) AND object_5.type IN ('object', 'variant', 'folder') ) AND object_5.published = 1 ORDER BY `releaseDate` DESC LIMIT 3 SELECT object_5.id AS id, object_5.type AS `type` FROM object_5 WHERE (id NOT IN ('82') AND object_5.type IN ('object','variant','folder')) AND object_5.published = 1 ORDER BY `releaseDate` DESC LIMIT 3;
0.56 ms (2.30%)	1	SELECT COUNT() FROM object_5 WHERE (id NOT IN (?) AND object_5.type IN ('object','variant','folder')) AND object_5.published = 1 Parameters: [`"82"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_5 WHERE ( id NOT IN (?) AND object_5.type IN ('object', 'variant', 'folder') ) AND object_5.published = 1 SELECT COUNT(*) FROM object_5 WHERE (id NOT IN ('82') AND object_5.type IN ('object','variant','folder')) AND object_5.published = 1;
0.55 ms (2.24%)	2	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 22;
0.51 ms (2.09%)	2	SELECT item_id, 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: [`1745070744 "document_7\x01tags\x01" "asset_89\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 > 1745070744 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_7tags', 'asset_89tags');
0.39 ms (1.60%)	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: [1745070744 "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 > 1745070744 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.31 ms (1.25%)	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: [`1745070744 "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 > 1745070744 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');
0.29 ms (1.21%)	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.25 ms (1.02%)	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: [`1745070744 "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 > 1745070744 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.24 ms (0.98%)	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: [`1745070744 "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 > 1745070744 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.23 ms (0.96%)	1	SELECT name FROM classes WHERE id = ? Parameters: [`"5"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '5';
0.23 ms (0.94%)	1	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/teahouse/gu-ge-guang-gao-xiao-guo-chai-zhe-xie-luo-di-ye-you-hua-yao-dian-ni-zuo-dui-liao-ma_copy~n82"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/teahouse/gu-ge-guang-gao-xiao-guo-chai-zhe-xie-luo-di-ye-you-hua-yao-dian-ni-zuo-dui-liao-ma_copy~n82';

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.