Symfony Profiler

Query Metrics

321 Database Queries

28 Different statements

56.02 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Time▼	Count	Info
13.10 ms (23.38%)	72	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: [`1756233822 "site_domain_44688b243734f3a007e0791598fa72d7"`] 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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_44688b243734f3a007e0791598fa72d7');
12.82 ms (22.89%)	83	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`3104`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 3104;
11.32 ms (20.20%)	83	SELECT customSettings FROM assets WHERE id = ? Parameters: [`3104`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 3104;
1.92 ms (3.44%)	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: [`1756233822 "object_320\x01tags\x01" "class_1\x01tags\x01" "asset_5679\x01tags\x01" "asset_5680\x01tags\x01" "asset_4655\x01tags\x01" "asset_4654\x01tags\x01" "asset_4656\x01tags\x01" "asset_4658\x01tags\x01" "asset_4662\x01tags\x01" "asset_4657\x01tags\x01" "asset_4659\x01tags\x01" "asset_4663\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_320tags', 'class_1tags', 'asset_5679tags', 'asset_5680tags', 'asset_4655tags', 'asset_4654tags', 'asset_4656tags', 'asset_4658tags', 'asset_4662tags', 'asset_4657tags', 'asset_4659tags', 'asset_4663tags');
1.60 ms (2.86%)	9	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';
1.60 ms (2.86%)	7	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: [`1756233822 "object_326\x01tags\x01" "class_1\x01tags\x01" "asset_5481\x01tags\x01" "asset_5464\x01tags\x01" "asset_5465\x01tags\x01" "asset_5001\x01tags\x01" "asset_5003\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_326tags', 'class_1tags', 'asset_5481tags', 'asset_5464tags', 'asset_5465tags', 'asset_5001tags', 'asset_5003tags');
1.53 ms (2.73%)	9	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';
1.28 ms (2.29%)	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: [`1756233822 "object_319\x01tags\x01" "class_1\x01tags\x01" "asset_5477\x01tags\x01" "asset_4906\x01tags\x01" "asset_4907\x01tags\x01" "asset_4910\x01tags\x01" "asset_4911\x01tags\x01" "asset_4908\x01tags\x01" "asset_4903\x01tags\x01" "asset_4914\x01tags\x01" "asset_4913\x01tags\x01" "asset_4912\x01tags\x01" "asset_4904\x01tags\x01" "asset_4905\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_319tags', 'class_1tags', 'asset_5477tags', 'asset_4906tags', 'asset_4907tags', 'asset_4910tags', 'asset_4911tags', 'asset_4908tags', 'asset_4903tags', 'asset_4914tags', 'asset_4913tags', 'asset_4912tags', 'asset_4904tags', 'asset_4905tags');
1.27 ms (2.27%)	6	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: [`1756233822 "object_327\x01tags\x01" "class_1\x01tags\x01" "asset_5482\x01tags\x01" "asset_5483\x01tags\x01" "asset_4551\x01tags\x01" "asset_4559\x01tags\x01" "asset_4558\x01tags\x01" "asset_4561\x01tags\x01" "asset_4557\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_327tags', 'class_1tags', 'asset_5482tags', 'asset_5483tags', 'asset_4551tags', 'asset_4559tags', 'asset_4558tags', 'asset_4561tags', 'asset_4557tags');
1.11 ms (1.98%)	6	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: [`1756233822 "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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
1.06 ms (1.88%)	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: [`1756233822 "object_422\x01tags\x01" "class_1\x01tags\x01" "asset_5709\x01tags\x01" "asset_5599\x01tags\x01" "asset_5598\x01tags\x01" "asset_5600\x01tags\x01" "asset_5308\x01tags\x01" "asset_5307\x01tags\x01" "asset_5302\x01tags\x01" "asset_5304\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_422tags', 'class_1tags', 'asset_5709tags', 'asset_5599tags', 'asset_5598tags', 'asset_5600tags', 'asset_5308tags', 'asset_5307tags', 'asset_5302tags', 'asset_5304tags');
0.94 ms (1.69%)	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: [`1756233822 "object_331\x01tags\x01" "class_1\x01tags\x01" "asset_5683\x01tags\x01" "asset_4898\x01tags\x01" "asset_4895\x01tags\x01" "asset_4891\x01tags\x01" "asset_4890\x01tags\x01" "asset_5469\x01tags\x01" "asset_4892\x01tags\x01" "asset_4894\x01tags\x01" "asset_4900\x01tags\x01" "asset_4897\x01tags\x01" "asset_4896\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_331tags', 'class_1tags', 'asset_5683tags', 'asset_4898tags', 'asset_4895tags', 'asset_4891tags', 'asset_4890tags', 'asset_5469tags', 'asset_4892tags', 'asset_4894tags', 'asset_4900tags', 'asset_4897tags', 'asset_4896tags');
0.78 ms (1.40%)	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: [`1756233822 "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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
0.77 ms (1.38%)	2	SELECT object_localized_2_en.id as id, object_localized_2_en.type as `type` FROM object_localized_2_en WHERE ( object_localized_2_en.type IN ('object','variant','folder')) AND object_localized_2_en.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_2_en.id as id, object_localized_2_en.type as `type` FROM object_localized_2_en WHERE ( object_localized_2_en.type IN ('object', 'variant', 'folder') ) AND object_localized_2_en.published = 1 SELECT object_localized_2_en.id as id, object_localized_2_en.type as `type` FROM object_localized_2_en WHERE ( object_localized_2_en.type IN ('object','variant','folder')) AND object_localized_2_en.published = 1;
0.71 ms (1.27%)	1	SELECT object_localized_1_en.id as id, object_localized_1_en.type as `type` FROM object_localized_1_en WHERE (categoria LIKE ? AND object_localized_1_en.type IN ('object','variant','folder')) AND object_localized_1_en.published = 1 Parameters: [`"%ANELLO%"`] View formatted query View runnable query Explain query SELECT object_localized_1_en.id as id, object_localized_1_en.type as `type` FROM object_localized_1_en WHERE ( categoria LIKE ? AND object_localized_1_en.type IN ('object', 'variant', 'folder') ) AND object_localized_1_en.published = 1 SELECT object_localized_1_en.id as id, object_localized_1_en.type as `type` FROM object_localized_1_en WHERE (categoria LIKE '%ANELLO%' AND object_localized_1_en.type IN ('object','variant','folder')) AND object_localized_1_en.published = 1;
0.68 ms (1.21%)	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: [`1756233822 "object_342\x01tags\x01" "class_1\x01tags\x01" "asset_5677\x01tags\x01" "asset_4820\x01tags\x01" "asset_4822\x01tags\x01" "asset_4819\x01tags\x01" "asset_4816\x01tags\x01" "asset_4818\x01tags\x01" "asset_4824\x01tags\x01" "asset_4821\x01tags\x01" "asset_4823\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_342tags', 'class_1tags', 'asset_5677tags', 'asset_4820tags', 'asset_4822tags', 'asset_4819tags', 'asset_4816tags', 'asset_4818tags', 'asset_4824tags', 'asset_4821tags', 'asset_4823tags');
0.49 ms (0.88%)	3	SELECT name FROM classes WHERE id = ? Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '1';
0.43 ms (0.77%)	1	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: [`"/it/categories" "path" "auto_create" "/it/categories?category=anello" "path_query" "http://www.manzonigioielli.com/it/categories?category=anello" "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 = '/it/categories' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/it/categories?category=anello' AND `type` = 'path_query') OR (source = 'http://www.manzonigioielli.com/it/categories?category=anello' 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;
0.41 ms (0.73%)	1	SELECT object_localized_3_en.id as id, object_localized_3_en.type as `type` FROM object_localized_3_en WHERE (`name` = 'anello' AND object_localized_3_en.type IN ('variant','object')) AND object_localized_3_en.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_3_en.id as id, object_localized_3_en.type as `type` FROM object_localized_3_en WHERE ( `name` = 'anello' AND object_localized_3_en.type IN ('variant', 'object') ) AND object_localized_3_en.published = 1 LIMIT 1 SELECT object_localized_3_en.id as id, object_localized_3_en.type as `type` FROM object_localized_3_en WHERE (`name` = 'anello' AND object_localized_3_en.type IN ('variant','object')) AND object_localized_3_en.published = 1 LIMIT 1;
0.37 ms (0.66%)	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: [`1756233822 "object_222\x01tags\x01" "class_2\x01tags\x01" "asset_3449\x01tags\x01" "asset_5760\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_222tags', 'class_2tags', 'asset_3449tags', 'asset_5760tags');
0.27 ms (0.48%)	1	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/it/" "categories"`] 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 '/it/' AND `key` = BINARY 'categories';
0.25 ms (0.45%)	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: [`1756233822 "object_435\x01tags\x01" "class_1\x01tags\x01" "asset_5716\x01tags\x01" "asset_5526\x01tags\x01" "asset_5525\x01tags\x01" "asset_5527\x01tags\x01" "asset_4190\x01tags\x01" "asset_4186\x01tags\x01" "asset_4183\x01tags\x01" "asset_4196\x01tags\x01" "asset_4197\x01tags\x01" "asset_4199\x01tags\x01" "asset_4200\x01tags\x01" "asset_4184\x01tags\x01" "asset_4185\x01tags\x01" "asset_4187\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_435tags', 'class_1tags', 'asset_5716tags', 'asset_5526tags', 'asset_5525tags', 'asset_5527tags', 'asset_4190tags', 'asset_4186tags', 'asset_4183tags', 'asset_4196tags', 'asset_4197tags', 'asset_4199tags', 'asset_4200tags', 'asset_4184tags', 'asset_4185tags', 'asset_4187tags');
0.24 ms (0.43%)	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: [`1756233822 "object_330\x01tags\x01" "class_1\x01tags\x01" "asset_5648\x01tags\x01" "asset_5644\x01tags\x01" "asset_5645\x01tags\x01" "asset_5646\x01tags\x01" "asset_5647\x01tags\x01" "asset_4728\x01tags\x01" "asset_4730\x01tags\x01" "asset_4725\x01tags\x01" "asset_4726\x01tags\x01" "asset_4733\x01tags\x01" "asset_4723\x01tags\x01" "asset_4727\x01tags\x01" "asset_4722\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_330tags', 'class_1tags', 'asset_5648tags', 'asset_5644tags', 'asset_5645tags', 'asset_5646tags', 'asset_5647tags', 'asset_4728tags', 'asset_4730tags', 'asset_4725tags', 'asset_4726tags', 'asset_4733tags', 'asset_4723tags', 'asset_4727tags', 'asset_4722tags');
0.23 ms (0.41%)	1	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;
0.22 ms (0.40%)	1	SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) 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( CONCAT(`path`, `key`) ) FROM documents WHERE documents.id = sites.rootId ) DESC SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC ;
0.21 ms (0.37%)	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: [`1756233822 "object_421\x01tags\x01" "class_1\x01tags\x01" "asset_5710\x01tags\x01" "asset_5605\x01tags\x01" "asset_5607\x01tags\x01" "asset_5606\x01tags\x01" "asset_5287\x01tags\x01" "asset_5289\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_421tags', 'class_1tags', 'asset_5710tags', 'asset_5605tags', 'asset_5607tags', 'asset_5606tags', 'asset_5287tags', 'asset_5289tags');
0.20 ms (0.36%)	1	SELECT * FROM object_url_slugs WHERE slug = '/it/categories' 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 = '/it/categories' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/it/categories' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
0.18 ms (0.33%)	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: [`1756233822 "object_232\x01tags\x01" "class_2\x01tags\x01" "asset_5744\x01tags\x01" "asset_3450\x01tags\x01" "asset_5772\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 > 1756233822 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_232tags', 'class_2tags', 'asset_5744tags', 'asset_3450tags', 'asset_5772tags');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
pimcore	doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

pimcore entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET http://www.manzonigioielli.com/it/categories?category=anello

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

pimcore entity manager

Entities Mapping