Symfony Profiler

Query Metrics

144 Database Queries

33 Different statements

93.73 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
30.34 ms (32.37%)	61	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: [`1744963082 "site_domain_81e468a3853b6926200e604bbebbba28"`] 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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_81e468a3853b6926200e604bbebbba28');
16.11 ms (17.19%)	1	SELECT object_localized_1_fr.id as id, object_localized_1_fr.type as `type` FROM object_localized_1_fr WHERE ( object_localized_1_fr.type IN ('object','variant','folder')) AND object_localized_1_fr.published = 1 LIMIT 16 OFFSET 32 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_1_fr.id as id, object_localized_1_fr.type as `type` FROM object_localized_1_fr WHERE ( object_localized_1_fr.type IN ('object', 'variant', 'folder') ) AND object_localized_1_fr.published = 1 LIMIT 16 OFFSET 32 SELECT object_localized_1_fr.id as id, object_localized_1_fr.type as `type` FROM object_localized_1_fr WHERE ( object_localized_1_fr.type IN ('object','variant','folder')) AND object_localized_1_fr.published = 1 LIMIT 16 OFFSET 32;
13.98 ms (14.91%)	5	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`47`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 47;
13.22 ms (14.10%)	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: [`1744963082 "system\x01tags\x01" "redirect\x01tags\x01" "route\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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
3.17 ms (3.38%)	1	SELECT object_localized_1_fr.id as id, object_localized_1_fr.type as `type` FROM object_localized_1_fr WHERE ( object_localized_1_fr.type IN ('object','variant','folder')) AND object_localized_1_fr.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_1_fr.id as id, object_localized_1_fr.type as `type` FROM object_localized_1_fr WHERE ( object_localized_1_fr.type IN ('object', 'variant', 'folder') ) AND object_localized_1_fr.published = 1 SELECT object_localized_1_fr.id as id, object_localized_1_fr.type as `type` FROM object_localized_1_fr WHERE ( object_localized_1_fr.type IN ('object','variant','folder')) AND object_localized_1_fr.published = 1;
1.84 ms (1.96%)	9	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: [`1744963082 "object_120\x01tags\x01" "class_1\x01tags\x01" "asset_120\x01tags\x01" "asset_121\x01tags\x01" "asset_123\x01tags\x01" "asset_125\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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_120tags', 'class_1tags', 'asset_120tags', 'asset_121tags', 'asset_123tags', 'asset_125tags');
1.48 ms (1.58%)	2	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6;
1.36 ms (1.45%)	6	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: [`1744963082 "object_113\x01tags\x01" "class_1\x01tags\x01" "asset_308\x01tags\x01" "asset_239\x01tags\x01" "asset_238\x01tags\x01" "asset_240\x01tags\x01" "asset_251\x01tags\x01" "asset_252\x01tags\x01" "asset_253\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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_113tags', 'class_1tags', 'asset_308tags', 'asset_239tags', 'asset_238tags', 'asset_240tags', 'asset_251tags', 'asset_252tags', 'asset_253tags');
1.22 ms (1.30%)	3	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/fr/e-shop" "path" "auto_create" "/fr/e-shop?page=3" "path_query" "https://colombe.apik-pp.be/fr/e-shop?page=3" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/fr/e-shop' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/fr/e-shop?page=3' AND `type` = 'path_query') OR (source = 'https://colombe.apik-pp.be/fr/e-shop?page=3' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
1.08 ms (1.16%)	2	SELECT COUNT() FROM object_localized_1_fr WHERE ( object_localized_1_fr.type IN ('object','variant','folder')) AND object_localized_1_fr.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM object_localized_1_fr WHERE ( object_localized_1_fr.type IN ('object', 'variant', 'folder') ) AND object_localized_1_fr.published = 1 SELECT COUNT(*) FROM object_localized_1_fr WHERE ( object_localized_1_fr.type IN ('object','variant','folder')) AND object_localized_1_fr.published = 1;
1.03 ms (1.10%)	5	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/fr/" "e-shop"`] 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 '/fr/' AND `key` = BINARY 'e-shop';
1.00 ms (1.06%)	1	SELECT object_localized_20_fr.id as id, object_localized_20_fr.type as `type` FROM object_localized_20_fr WHERE ( object_localized_20_fr.type IN ('object','variant','folder')) AND object_localized_20_fr.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_20_fr.id as id, object_localized_20_fr.type as `type` FROM object_localized_20_fr WHERE ( object_localized_20_fr.type IN ('object', 'variant', 'folder') ) AND object_localized_20_fr.published = 1 SELECT object_localized_20_fr.id as id, object_localized_20_fr.type as `type` FROM object_localized_20_fr WHERE ( object_localized_20_fr.type IN ('object','variant','folder')) AND object_localized_20_fr.published = 1;
0.94 ms (1.00%)	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: [`1744963082 "object_118\x01tags\x01" "class_1\x01tags\x01" "asset_268\x01tags\x01" "asset_269\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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_118tags', 'class_1tags', 'asset_268tags', 'asset_269tags');
0.80 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: [`1744963083 "output\x01tags\x01" "navigation\x01tags\x01" "document_4\x01tags\x01" "document_6\x01tags\x01" "document_7\x01tags\x01" "document_8\x01tags\x01" "document_9\x01tags\x01" "document_10\x01tags\x01" "document_11\x01tags\x01" "document_14\x01tags\x01" "document_29\x01tags\x01" "document_32\x01tags\x01" "document_3\x01tags\x01" "document_33\x01tags\x01" "document_34\x01tags\x01" "document_35\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 > 1744963083 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_4tags', 'document_6tags', 'document_7tags', 'document_8tags', 'document_9tags', 'document_10tags', 'document_11tags', 'document_14tags', 'document_29tags', 'document_32tags', 'document_3tags', 'document_33tags', 'document_34tags', 'document_35tags');
0.79 ms (0.85%)	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: [`1744963082 "object_117\x01tags\x01" "class_1\x01tags\x01" "asset_258\x01tags\x01" "asset_260\x01tags\x01" "asset_257\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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_117tags', 'class_1tags', 'asset_258tags', 'asset_260tags', 'asset_257tags');
0.64 ms (0.68%)	3	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: [`1744963082 "object_130\x01tags\x01" "class_1\x01tags\x01" "asset_148\x01tags\x01" "asset_152\x01tags\x01" "asset_150\x01tags\x01" "asset_157\x01tags\x01" "asset_155\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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_130tags', 'class_1tags', 'asset_148tags', 'asset_152tags', 'asset_150tags', 'asset_157tags', 'asset_155tags');
0.59 ms (0.63%)	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: [`1744963082 "object_10\x01tags\x01" "class_1\x01tags\x01" "asset_255\x01tags\x01" "asset_243\x01tags\x01" "asset_254\x01tags\x01" "asset_247\x01tags\x01" "asset_244\x01tags\x01" "asset_245\x01tags\x01" "asset_241\x01tags\x01" "asset_249\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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_10tags', 'class_1tags', 'asset_255tags', 'asset_243tags', 'asset_254tags', 'asset_247tags', 'asset_244tags', 'asset_245tags', 'asset_241tags', 'asset_249tags');
0.59 ms (0.63%)	3	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: [`1744963082 "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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
0.47 ms (0.50%)	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: [`1744963082 "object_124\x01tags\x01" "class_1\x01tags\x01" "asset_127\x01tags\x01" "asset_129\x01tags\x01" "asset_126\x01tags\x01" "asset_166\x01tags\x01" "asset_128\x01tags\x01" "asset_130\x01tags\x01" "asset_133\x01tags\x01" "asset_292\x01tags\x01" "asset_295\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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_124tags', 'class_1tags', 'asset_127tags', 'asset_129tags', 'asset_126tags', 'asset_166tags', 'asset_128tags', 'asset_130tags', 'asset_133tags', 'asset_292tags', 'asset_295tags');
0.46 ms (0.50%)	2	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 6;
0.33 ms (0.36%)	2	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`6 6 6`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(6, 6) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 6;
0.33 ms (0.35%)	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: [`1744963083 "document_2\x01tags\x01" "document_1\x01tags\x01" "asset_79\x01tags\x01" "asset_65\x01tags\x01" "asset_67\x01tags\x01" "asset_66\x01tags\x01" "asset_64\x01tags\x01" "asset_34\x01tags\x01" "asset_676\x01tags\x01" "asset_312\x01tags\x01" "asset_268\x01tags\x01" "asset_630\x01tags\x01" "asset_91\x01tags\x01" "asset_80\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 > 1744963083 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_2tags', 'document_1tags', 'asset_79tags', 'asset_65tags', 'asset_67tags', 'asset_66tags', 'asset_64tags', 'asset_34tags', 'asset_676tags', 'asset_312tags', 'asset_268tags', 'asset_630tags', 'asset_91tags', 'asset_80tags');
0.30 ms (0.32%)	5	SELECT * FROM object_relations_1 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object' Parameters: [`51 "category"`] View formatted query View runnable query Explain query SELECT * FROM object_relations_1 WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object' SELECT * FROM object_relations_1 WHERE dest_id = 51 AND fieldname = 'category' AND ownertype = 'object';
0.28 ms (0.30%)	4	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
0.28 ms (0.30%)	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: [`1744963082 "object_228\x01tags\x01" "class_1\x01tags\x01" "asset_341\x01tags\x01" "asset_358\x01tags\x01" "asset_351\x01tags\x01" "asset_356\x01tags\x01" "asset_355\x01tags\x01" "asset_348\x01tags\x01" "asset_342\x01tags\x01" "asset_346\x01tags\x01" "asset_353\x01tags\x01" "asset_344\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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_228tags', 'class_1tags', 'asset_341tags', 'asset_358tags', 'asset_351tags', 'asset_356tags', 'asset_355tags', 'asset_348tags', 'asset_342tags', 'asset_346tags', 'asset_353tags', 'asset_344tags');
0.27 ms (0.29%)	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: [`1744963083 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\x01tags\x01" "asset_47\x01tags\x01" "asset_63\x01tags\x01" "document_67\x01tags\x01" "document_68\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 > 1744963083 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_configtags', 'systemtags', 'configtags', 'outputtags', 'asset_47tags', 'asset_63tags', 'document_67tags', 'document_68tags');
0.26 ms (0.28%)	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: [`1744963082 "object_153\x01tags\x01" "class_1\x01tags\x01" "asset_272\x01tags\x01" "asset_505\x01tags\x01" "asset_217\x01tags\x01" "asset_216\x01tags\x01" "asset_221\x01tags\x01" "asset_215\x01tags\x01" "asset_220\x01tags\x01" "asset_219\x01tags\x01" "asset_277\x01tags\x01" "asset_271\x01tags\x01" "asset_273\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 > 1744963082 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_153tags', 'class_1tags', 'asset_272tags', 'asset_505tags', 'asset_217tags', 'asset_216tags', 'asset_221tags', 'asset_215tags', 'asset_220tags', 'asset_219tags', 'asset_277tags', 'asset_271tags', 'asset_273tags');
0.14 ms (0.14%)	2	SELECT name FROM classes WHERE id = ? Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '1';
0.11 ms (0.12%)	1	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
0.11 ms (0.11%)	2	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`48 48`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 48 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 48;
0.06 ms (0.07%)	1	SELECT id FROM classes WHERE name = ? Parameters: [`"Product"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Product';
0.06 ms (0.07%)	1	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 ;
0.06 ms (0.07%)	1	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';

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.

Symfony Profiler

GET https://colombe.apik-pp.be/_fragment?_path=_locale%3Dfr%26_format%3Dhtml%26_controller%3DApp%255CController%255CDefaultController%253A%253AtemplateAction

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping