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.15.7.20
Profiled on: Sat, 19 Apr 2025 13:44:26 +0000
Token: b79aa0

Query Metrics

83 Database Queries

19 Different statements

24.76 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
9.07 ms (36.63%)	32	SELECT item_id, 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: [`1745070265 "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 > 1745070265 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_9ae7fad3bb9377f37ba1d2d6ff944589');
2.21 ms (8.94%)	9	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_36__67a19af5ae225c260546d33a1857eb27"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_36__67a19af5ae225c260546d33a1857eb27';
1.84 ms (7.42%)	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.57 ms (6.36%)	4	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`36`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 36;
1.46 ms (5.92%)	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: [`1745070266 "object_82\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 > 1745070266 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_82tags', 'class_5tags', 'asset_49tags', 'asset_51tags');
1.24 ms (5.02%)	4	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/teahouse/" "ling-shou-shang-zai-ni-ming-hua-shu-zi-ying-xiao-shi-dai-de-qu-sheng-zhi-dao~n18"`] 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 'ling-shou-shang-zai-ni-ming-hua-shu-zi-ying-xiao-shi-dai-de-qu-sheng-zhi-dao~n18';
1.15 ms (4.65%)	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: [`1745070265 "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 > 1745070265 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags', 'site_domain_9ae7fad3bb9377f37ba1d2d6ff944589tags');
1.05 ms (4.25%)	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: [`"18"`] 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 ('18') AND object_5.type IN ('object','variant','folder')) AND object_5.published = 1 ORDER BY `releaseDate` DESC LIMIT 3;
0.80 ms (3.24%)	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.77 ms (3.10%)	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.66 ms (2.67%)	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: [`1745070265 "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 > 1745070265 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_7tags', 'asset_89tags');
0.60 ms (2.41%)	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: [1745070266 "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 > 1745070266 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.57 ms (2.31%)	1	SELECT COUNT() FROM object_5 WHERE (id NOT IN (?) AND object_5.type IN ('object','variant','folder')) AND object_5.published = 1 Parameters: [`"18"`] 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 ('18') AND object_5.type IN ('object','variant','folder')) AND object_5.published = 1;
0.36 ms (1.45%)	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.34 ms (1.38%)	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: [`1745070266 "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 > 1745070266 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.28 ms (1.13%)	1	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/teahouse/ling-shou-shang-zai-ni-ming-hua-shu-zi-ying-xiao-shi-dai-de-qu-sheng-zhi-dao~n18"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/teahouse/ling-shou-shang-zai-ni-ming-hua-shu-zi-ying-xiao-shi-dai-de-qu-sheng-zhi-dao~n18';
0.27 ms (1.10%)	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: [`1745070266 "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 > 1745070266 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.27 ms (1.08%)	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.93%)	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: [`1745070266 "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 > 1745070266 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');

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.