Symfony Profiler

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

Response: 200 OK
IP: 18.226.181.89
Profiled on: Mon, 19 May 2025 12:10:47 +0000
Token: c245d8

Query Metrics

67 Database Queries

17 Different statements

16.80 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
6.85 ms (40.79%)	28	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: [`1747656647 "\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 > 1747656647 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagssite_domain_884a34599b732f30e3bf2a242b0c4d7b', 'site_domain_884a34599b732f30e3bf2a242b0c4d7b');
2.37 ms (14.13%)	9	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.10 ms (6.53%)	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: [`1747656647 "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 > 1747656647 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags', 'site_domain_884a34599b732f30e3bf2a242b0c4d7btags');
1.03 ms (6.16%)	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;
1.02 ms (6.08%)	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: [`1747656647 "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 > 1747656647 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translatortags', 'translator_websitetags', 'translatetags', 'translation_data_0ae734d8b811c294d89efb3311a9fc4dtags');
0.67 ms (4.01%)	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: [`1747656647 "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 > 1747656647 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.66 ms (3.96%)	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.59 ms (3.49%)	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;
0.57 ms (3.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: [`1747656647 "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 > 1747656647 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.46 ms (2.73%)	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: [`1747656647 "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 > 1747656647 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.31 ms (1.83%)	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: [`1747656647 "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 > 1747656647 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_6tags', 'asset_293tags', 'asset_273tags', 'asset_272tags', 'asset_162tags');
0.27 ms (1.63%)	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.23 ms (1.36%)	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: [1747656647 "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 > 1747656647 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.22 ms (1.33%)	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.19 ms (1.15%)	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.14 ms (0.83%)	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.10 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: [`1747656647 "asset_272\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 > 1747656647 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_272tags');

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.