Symfony Profiler

Query Metrics

193 Database Queries

23 Different statements

82.34 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
30.34 ms (36.84%)	81	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: [`1765465215 "site_domain_d44f4b16e58aa1d38a146484576d426e"`] 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 > 1765465215 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_d44f4b16e58aa1d38a146484576d426e');
10.00 ms (12.14%)	22	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: [`1765465215 "object_844\x01tags\x01" "class_menode\x01tags\x01" "document_25\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 > 1765465215 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_844tags', 'class_menodetags', 'document_25tags');
6.29 ms (7.64%)	18	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: [`1765465215 "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 > 1765465215 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
5.28 ms (6.41%)	11	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';
4.86 ms (5.90%)	12	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`15 15`] 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 = 15 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 15;
3.37 ms (4.09%)	5	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"MENU_HEADER_NAVBAR_DESKTOP" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'MENU_HEADER_NAVBAR_DESKTOP' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2.89 ms (3.51%)	2	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1;
2.84 ms (3.45%)	6	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" ""`] 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 '';
2.69 ms (3.27%)	4	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`1 1 1`] 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(1, 1) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 1;
1.89 ms (2.29%)	2	SELECT object_social.id as id, object_social.type as `type` FROM object_social WHERE ( object_social.type IN ('object','variant','folder')) AND object_social.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_social.id as id, object_social.type as `type` FROM object_social WHERE ( object_social.type IN ('object', 'variant', 'folder') ) AND object_social.published = 1 SELECT object_social.id as id, object_social.type as `type` FROM object_social WHERE ( object_social.type IN ('object','variant','folder')) AND object_social.published = 1;
1.78 ms (2.16%)	4	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 1;
1.69 ms (2.05%)	4	SELECT * FROM object_relations_menu WHERE src_id = ? Parameters: [`172`] View formatted query View runnable query Explain query SELECT * FROM object_relations_menu WHERE src_id = ? SELECT * FROM object_relations_menu WHERE src_id = 172;
1.64 ms (2.00%)	5	SELECT * FROM website_settings WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 9;
1.61 ms (1.96%)	5	SELECT name FROM classes WHERE id = ? Parameters: [`"menu"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'menu';
1.46 ms (1.77%)	4	SELECT * FROM object_relations_menode WHERE src_id = ? Parameters: [`173`] View formatted query View runnable query Explain query SELECT * FROM object_relations_menode WHERE src_id = ? SELECT * FROM object_relations_menode WHERE src_id = 173;
0.60 ms (0.73%)	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: [`1765465215 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\x01tags\x01" "asset_11\x01tags\x01" "asset_1196\x01tags\x01" "object_127\x01tags\x01" "object_136\x01tags\x01" "object_172\x01tags\x01" "object_139\x01tags\x01" "asset_48\x01tags\x01" "document_24\x01tags\x01" "document_25\x01tags\x01" "document_19\x01tags\x01" "document_26\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 > 1765465215 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_configtags', 'systemtags', 'configtags', 'outputtags', 'asset_11tags', 'asset_1196tags', 'object_127tags', 'object_136tags', 'object_172tags', 'object_139tags', 'asset_48tags', 'document_24tags', 'document_25tags', 'document_19tags', 'document_26tags');
0.54 ms (0.66%)	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.51 ms (0.62%)	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.50 ms (0.61%)	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: [`1765465215 "document_21\x01tags\x01" "asset_2098\x01tags\x01" "asset_2102\x01tags\x01" "asset_2091\x01tags\x01" "asset_2093\x01tags\x01" "asset_2094\x01tags\x01" "asset_2095\x01tags\x01" "asset_2111\x01tags\x01" "asset_2113\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 > 1765465215 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_21tags', 'asset_2098tags', 'asset_2102tags', 'asset_2091tags', 'asset_2093tags', 'asset_2094tags', 'asset_2095tags', 'asset_2111tags', 'asset_2113tags');
0.44 ms (0.53%)	1	SELECT * FROM object_url_slugs WHERE slug = '/' 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 = '/' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
0.42 ms (0.51%)	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: [`1765465215 "document_1\x01tags\x01" "asset_23\x01tags\x01" "asset_24\x01tags\x01" "asset_26\x01tags\x01" "asset_27\x01tags\x01" "asset_38\x01tags\x01" "asset_40\x01tags\x01" "asset_42\x01tags\x01" "asset_43\x01tags\x01" "asset_44\x01tags\x01" "asset_25\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 > 1765465215 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags', 'asset_23tags', 'asset_24tags', 'asset_26tags', 'asset_27tags', 'asset_38tags', 'asset_40tags', 'asset_42tags', 'asset_43tags', 'asset_44tags', 'asset_25tags');
0.40 ms (0.48%)	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: [`1765465215 "document_14\x01tags\x01" "document_1\x01tags\x01" "asset_23\x01tags\x01" "asset_24\x01tags\x01" "asset_26\x01tags\x01" "asset_27\x01tags\x01" "asset_38\x01tags\x01" "asset_40\x01tags\x01" "asset_42\x01tags\x01" "asset_43\x01tags\x01" "asset_44\x01tags\x01" "asset_25\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 > 1765465215 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_14tags', 'document_1tags', 'asset_23tags', 'asset_24tags', 'asset_26tags', 'asset_27tags', 'asset_38tags', 'asset_40tags', 'asset_42tags', 'asset_43tags', 'asset_44tags', 'asset_25tags');
0.31 ms (0.38%)	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://staging-arrex.aleaweb.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping