Symfony Profiler

GET https://basamhco.centric.ae/_fragment?_path=_locale%3Dar%26_format%3Dhtml%26_controller%3DApp%255CController%255CDefaultController%253A%253AfooterAction

Response: 200 OK
IP: 216.73.216.146
Profiled on: Wed, 10 Dec 2025 02:16:33 +0000
Token: a0db71

Query Metrics

177 Database Queries

16 Different statements

26.40 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
12.54 ms (47.52%)	91	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: [`1765332992 "\x01tags\x01site_domain_884a34599b732f30e3bf2a242b0c4d7b" "site_domain_884a34599b732f30e3bf2a242b0c4d7b"`] 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 > 1765332992 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagssite_domain_884a34599b732f30e3bf2a242b0c4d7b', 'site_domain_884a34599b732f30e3bf2a242b0c4d7b');
6.80 ms (25.76%)	58	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: [`1765332992 "system\x01tags\x01" "site\x01tags\x01" "site_domain_884a34599b732f30e3bf2a242b0c4d7b\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 > 1765332992 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags', 'site_domain_884a34599b732f30e3bf2a242b0c4d7btags');
1.07 ms (4.03%)	2	SELECT object_localized_companies_ar.id as id, object_localized_companies_ar.type as `type` FROM object_localized_companies_ar WHERE ( object_localized_companies_ar.type IN ('object','variant','folder')) AND object_localized_companies_ar.published = 1 ORDER BY `order` ASC Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_companies_ar.id as id, object_localized_companies_ar.type as `type` FROM object_localized_companies_ar WHERE ( object_localized_companies_ar.type IN ('object', 'variant', 'folder') ) AND object_localized_companies_ar.published = 1 ORDER BY `order` ASC SELECT object_localized_companies_ar.id as id, object_localized_companies_ar.type as `type` FROM object_localized_companies_ar WHERE ( object_localized_companies_ar.type IN ('object','variant','folder')) AND object_localized_companies_ar.published = 1 ORDER BY `order` ASC ;
0.98 ms (3.72%)	2	SELECT object_localized_products_ar.id as id, object_localized_products_ar.type as `type` FROM object_localized_products_ar WHERE ( object_localized_products_ar.type IN ('object','variant','folder')) AND object_localized_products_ar.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_products_ar.id as id, object_localized_products_ar.type as `type` FROM object_localized_products_ar WHERE ( object_localized_products_ar.type IN ('object', 'variant', 'folder') ) AND object_localized_products_ar.published = 1 SELECT object_localized_products_ar.id as id, object_localized_products_ar.type as `type` FROM object_localized_products_ar WHERE ( object_localized_products_ar.type IN ('object','variant','folder')) AND object_localized_products_ar.published = 1;
0.93 ms (3.53%)	6	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`299`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 299;
0.71 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: [1765332992 "output\x01tags\x01" "navigation\x01tags\x01" "document_8\x01tags\x01" "document_7\x01tags\x01" "document_30\x01tags\x01" "document_28\x01tags\x01" "document_33\x01tags\x01" "document_34\x01tags\x01" "document_19\x01tags\x01" "document_52\x01tags\x01" "document_44\x01tags\x01" "document_27\x01tags\x01" "document_21\x01tags\x01" "document_20\x01tags\x01" "document_38\x01tags\x01" "document_39\x01tags\x01" "document_40\x01tags\x01" "document_42\x01tags\x01" "document_47\x01tags\x01" "document_50\x01tags\x01" "document_54\x01tags\x01" "nav_702c8d533eb71e199f1cd272864af4b6\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 > 1765332992 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_8tags', 'document_7tags', 'document_30tags', 'document_28tags', 'document_33tags', 'document_34tags', 'document_19tags', 'document_52tags', 'document_44tags', 'document_27tags', 'document_21tags', 'document_20tags', 'document_38tags', 'document_39tags', 'document_40tags', 'document_42tags', 'document_47tags', 'document_50tags', 'document_54tags', 'nav_702c8d533eb71e199f1cd272864af4b6tags');
0.61 ms (2.32%)	3	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`28`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 28;
0.58 ms (2.20%)	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: [`1765332993 "object_4\x01tags\x01" "class_companies\x01tags\x01" "asset_461\x01tags\x01" "asset_296\x01tags\x01" "asset_507\x01tags\x01" "asset_144\x01tags\x01" "asset_460\x01tags\x01" "asset_462\x01tags\x01" "asset_399\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 > 1765332993 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4tags', 'class_companiestags', 'asset_461tags', 'asset_296tags', 'asset_507tags', 'asset_144tags', 'asset_460tags', 'asset_462tags', 'asset_399tags');
0.39 ms (1.48%)	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: [`1765332992 "document_6\x01tags\x01" "asset_293\x01tags\x01" "asset_273\x01tags\x01" "asset_272\x01tags\x01" "asset_162\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 > 1765332992 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_6tags', 'asset_293tags', 'asset_273tags', 'asset_272tags', 'asset_162tags');
0.39 ms (1.48%)	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: [`1765332993 "object_5\x01tags\x01" "class_companies\x01tags\x01" "asset_297\x01tags\x01" "asset_143\x01tags\x01" "asset_139\x01tags\x01" "asset_309\x01tags\x01" "asset_446\x01tags\x01" "asset_445\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 > 1765332993 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_5tags', 'class_companiestags', 'asset_297tags', 'asset_143tags', 'asset_139tags', 'asset_309tags', 'asset_446tags', 'asset_445tags');
0.29 ms (1.11%)	1	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/ar/" "our-company"`] 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 'our-company';
0.27 ms (1.03%)	2	SELECT name FROM classes WHERE id = ? Parameters: [`"companies"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'companies';
0.25 ms (0.94%)	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.24 ms (0.89%)	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.19 ms (0.71%)	1	SELECT * FROM object_url_slugs WHERE slug = '/ar/our-company' 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/our-company' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/ar/our-company' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
0.16 ms (0.59%)	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: [`1765332992 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01" "translation_data_0ae734d8b811c294d89efb3311a9fc4d\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 > 1765332992 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translatortags', 'translator_websitetags', 'translatetags', 'translation_data_0ae734d8b811c294d89efb3311a9fc4dtags');

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.