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: 3.21.35.68
Profiled on: Sat, 26 Apr 2025 09:44:58 +0000
Token: 6d8439

Query Metrics

101 Database Queries

17 Different statements

25.19 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
14.47 ms (57.46%)	55	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: [`1745660698 "\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 > 1745660698 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagssite_domain_884a34599b732f30e3bf2a242b0c4d7b', 'site_domain_884a34599b732f30e3bf2a242b0c4d7b');
2.28 ms (9.07%)	10	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`162`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 162;
1.49 ms (5.90%)	8	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: [`1745660698 "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 > 1745660698 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags', 'site_domain_884a34599b732f30e3bf2a242b0c4d7btags');
1.18 ms (4.69%)	4	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;
0.86 ms (3.40%)	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: [`1745660698 "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 > 1745660698 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translatortags', 'translator_websitetags', 'translatetags', 'translation_data_0ae734d8b811c294d89efb3311a9fc4dtags');
0.68 ms (2.70%)	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: [`1745660698 "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 > 1745660698 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.64 ms (2.55%)	2	SELECT object_localized_people_ar.id as id, object_localized_people_ar.type as `type` FROM object_localized_people_ar WHERE ( object_localized_people_ar.type IN ('object','variant','folder')) AND object_localized_people_ar.published = 1 LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_people_ar.id as id, object_localized_people_ar.type as `type` FROM object_localized_people_ar WHERE ( object_localized_people_ar.type IN ('object', 'variant', 'folder') ) AND object_localized_people_ar.published = 1 LIMIT 10 SELECT object_localized_people_ar.id as id, object_localized_people_ar.type as `type` FROM object_localized_people_ar WHERE ( object_localized_people_ar.type IN ('object','variant','folder')) AND object_localized_people_ar.published = 1 LIMIT 10;
0.62 ms (2.46%)	3	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.52 ms (2.08%)	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: [`1745660698 "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 > 1745660698 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_6tags', 'asset_293tags', 'asset_273tags', 'asset_272tags', 'asset_162tags');
0.37 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: [`1745660698 "document_39\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 > 1745660698 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_39tags');
0.37 ms (1.48%)	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.36 ms (1.41%)	1	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "ar"`] 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 'ar';
0.35 ms (1.40%)	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: [`1745660698 "document_1\x01tags\x01" "asset_293\x01tags\x01" "asset_273\x01tags\x01" "asset_249\x01tags\x01" "asset_225\x01tags\x01" "asset_486\x01tags\x01" "asset_458\x01tags\x01" "asset_163\x01tags\x01" "asset_487\x01tags\x01" "asset_457\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 > 1745660698 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags', 'asset_293tags', 'asset_273tags', 'asset_249tags', 'asset_225tags', 'asset_486tags', 'asset_458tags', 'asset_163tags', 'asset_487tags', 'asset_457tags');
0.30 ms (1.21%)	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: [1745660698 "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 > 1745660698 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.28 ms (1.13%)	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: [`1745660698 "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 > 1745660698 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.21 ms (0.85%)	1	SELECT * FROM object_url_slugs WHERE slug = '/ar' 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' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/ar' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
0.18 ms (0.73%)	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;;

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.