Symfony Profiler

GET https://sharbatly.centric.ae/ar/services

Response: 200 OK
IP: 216.73.216.162
Profiled on: Wed, 04 Feb 2026 02:33:50 +0000
Token: 043471

Query Metrics

119 Database Queries

19 Different statements

48.76 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
16.91 ms (34.69%)	50	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: [`1770172430 "site_domain_e611cb32729c051deacee8eb985067f5"`] 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 > 1770172430 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_e611cb32729c051deacee8eb985067f5');
6.96 ms (14.27%)	19	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`824`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 824;
6.03 ms (12.36%)	19	SELECT customSettings FROM assets WHERE id = ? Parameters: [`824`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 824;
5.00 ms (10.25%)	5	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 5;
2.07 ms (4.25%)	5	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: [`1770172430 "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 > 1770172430 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
1.35 ms (2.77%)	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: [`1770172430 "document_41\x01tags\x01" "asset_1051\x01tags\x01" "asset_919\x01tags\x01" "asset_923\x01tags\x01" "asset_925\x01tags\x01" "asset_929\x01tags\x01" "asset_930\x01tags\x01" "asset_922\x01tags\x01" "asset_1049\x01tags\x01" "asset_926\x01tags\x01" "asset_927\x01tags\x01" "asset_1044\x01tags\x01" "asset_819\x01tags\x01" "asset_823\x01tags\x01" "asset_821\x01tags\x01" "asset_822\x01tags\x01" "asset_820\x01tags\x01" "asset_818\x01tags\x01" "asset_969\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 > 1770172430 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_41tags', 'asset_1051tags', 'asset_919tags', 'asset_923tags', 'asset_925tags', 'asset_929tags', 'asset_930tags', 'asset_922tags', 'asset_1049tags', 'asset_926tags', 'asset_927tags', 'asset_1044tags', 'asset_819tags', 'asset_823tags', 'asset_821tags', 'asset_822tags', 'asset_820tags', 'asset_818tags', 'asset_969tags');
1.33 ms (2.73%)	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: [`"/ar/services" "path" "auto_create" "/ar/services" "path_query" "https://sharbatly.centric.ae/ar/services" "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 = '/ar/services' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/ar/services' AND `type` = 'path_query') OR (source = 'https://sharbatly.centric.ae/ar/services' 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.33 ms (2.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: [`1770172430 "document_72\x01tags\x01" "asset_895\x01tags\x01" "asset_896\x01tags\x01" "asset_1064\x01tags\x01" "asset_1074\x01tags\x01" "asset_1636\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 > 1770172430 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_72tags', 'asset_895tags', 'asset_896tags', 'asset_1064tags', 'asset_1074tags', 'asset_1636tags');
1.18 ms (2.42%)	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: [`1770172430 "document_77\x01tags\x01" "asset_824\x01tags\x01" "asset_1043\x01tags\x01" "asset_1046\x01tags\x01" "asset_819\x01tags\x01" "asset_823\x01tags\x01" "asset_821\x01tags\x01" "asset_822\x01tags\x01" "asset_820\x01tags\x01" "asset_818\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 > 1770172430 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_77tags', 'asset_824tags', 'asset_1043tags', 'asset_1046tags', 'asset_819tags', 'asset_823tags', 'asset_821tags', 'asset_822tags', 'asset_820tags', 'asset_818tags');
1.11 ms (2.29%)	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: [`1770172430 "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 > 1770172430 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
0.99 ms (2.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: [`1770172430 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\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 > 1770172430 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_configtags', 'systemtags', 'configtags', 'outputtags');
0.76 ms (1.56%)	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: [`1770172430 "document_6\x01tags\x01" "asset_2068\x01tags\x01" "asset_2069\x01tags\x01" "asset_2070\x01tags\x01" "asset_2071\x01tags\x01" "asset_2064\x01tags\x01" "asset_2063\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 > 1770172430 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_6tags', 'asset_2068tags', 'asset_2069tags', 'asset_2070tags', 'asset_2071tags', 'asset_2064tags', 'asset_2063tags');
0.72 ms (1.48%)	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.68 ms (1.40%)	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: [`1770172430 "output\x01tags\x01" "navigation\x01tags\x01" "document_7\x01tags\x01" "document_89\x01tags\x01" "document_71\x01tags\x01" "document_72\x01tags\x01" "document_78\x01tags\x01" "document_77\x01tags\x01" "document_75\x01tags\x01" "document_69\x01tags\x01" "document_76\x01tags\x01" "document_84\x01tags\x01" "document_86\x01tags\x01" "document_88\x01tags\x01" "document_91\x01tags\x01" "document_93\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 > 1770172430 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_7tags', 'document_89tags', 'document_71tags', 'document_72tags', 'document_78tags', 'document_77tags', 'document_75tags', 'document_69tags', 'document_76tags', 'document_84tags', 'document_86tags', 'document_88tags', 'document_91tags', 'document_93tags');
0.65 ms (1.34%)	3	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.64 ms (1.32%)	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.45 ms (0.92%)	1	SELECT * FROM object_url_slugs WHERE slug = '/ar/services' 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 = '/ar/services' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/ar/services' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
0.41 ms (0.84%)	1	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/ar/" "services"`] 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 '/ar/' AND `key` = BINARY 'services';
0.17 ms (0.35%)	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.