Query Metrics

149 Database Queries
24 Different statements
56.58 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
39.26 ms
(69.39%)
52
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:
[
  1773179459
  "site_domain_fba8023b3cc40aadafb9200ed0208925"
]
3.43 ms
(6.05%)
26
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:
[
  1773179459
  "system\x01tags\x01"
  "site\x01tags\x01"
]
2.00 ms
(3.53%)
4
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  521
]
1.79 ms
(3.16%)
14
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
1.50 ms
(2.66%)
13
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
1.41 ms
(2.49%)
9
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  519
  519
]
0.95 ms
(1.68%)
2
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/terme-sauna/family-world/montequarium/abitanti del mare"
  "path"
  "auto_create"
  "/it/terme-sauna/family-world/montequarium/abitanti del mare"
  "path_query"
  "https://alpentherme.dev-as6.conecto.rocks/it/terme-sauna/family-world/montequarium/abitanti del mare"
  "entire_uri"
]
0.92 ms
(1.62%)
5
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/it/terme-sauna/family-world/montequarium/"
  "abitanti del mare"
]
0.70 ms
(1.24%)
3
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  496
  521
  521
]
0.56 ms
(0.99%)
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:
[
  1773179459
  "output\x01tags\x01"
  "navigation\x01tags\x01"
  "document_362\x01tags\x01"
  "document_302\x01tags\x01"
  "document_306\x01tags\x01"
  "document_352\x01tags\x01"
  "document_303\x01tags\x01"
  "document_354\x01tags\x01"
  "document_355\x01tags\x01"
  "document_353\x01tags\x01"
  "document_304\x01tags\x01"
  "document_298\x01tags\x01"
  "document_440\x01tags\x01"
  "document_521\x01tags\x01"
  "document_520\x01tags\x01"
  "document_295\x01tags\x01"
  "document_294\x01tags\x01"
  "document_305\x01tags\x01"
  "document_307\x01tags\x01"
  "document_479\x01tags\x01"
  "document_297\x01tags\x01"
  "document_301\x01tags\x01"
  "document_299\x01tags\x01"
  "document_300\x01tags\x01"
  "document_270\x01tags\x01"
  "document_363\x01tags\x01"
  "document_320\x01tags\x01"
  "document_323\x01tags\x01"
  "document_367\x01tags\x01"
  "document_318\x01tags\x01"
  "document_350\x01tags\x01"
  "document_348\x01tags\x01"
  "document_347\x01tags\x01"
  "document_345\x01tags\x01"
  "document_346\x01tags\x01"
  "document_349\x01tags\x01"
  "document_391\x01tags\x01"
  "document_393\x01tags\x01"
  "document_427\x01tags\x01"
  "document_512\x01tags\x01"
  "document_516\x01tags\x01"
  "document_539\x01tags\x01"
  "document_322\x01tags\x01"
  "document_316\x01tags\x01"
  "document_344\x01tags\x01"
  "document_478\x01tags\x01"
  "document_314\x01tags\x01"
  "document_343\x01tags\x01"
  "document_313\x01tags\x01"
  "document_321\x01tags\x01"
  "document_317\x01tags\x01"
  "document_319\x01tags\x01"
  "document_267\x01tags\x01"
  "document_364\x01tags\x01"
  "document_330\x01tags\x01"
  "document_327\x01tags\x01"
  "document_329\x01tags\x01"
  "document_401\x01tags\x01"
  "document_265\x01tags\x01"
  "document_310\x01tags\x01"
  "document_359\x01tags\x01"
  "document_360\x01tags\x01"
  "document_312\x01tags\x01"
  "document_356\x01tags\x01"
  "document_357\x01tags\x01"
  "document_434\x01tags\x01"
  "document_465\x01tags\x01"
  "document_472\x01tags\x01"
  "document_550\x01tags\x01"
  "document_311\x01tags\x01"
  "document_309\x01tags\x01"
  "document_269\x01tags\x01"
  "document_284\x01tags\x01"
  "document_324\x01tags\x01"
  "document_484\x01tags\x01"
  "document_491\x01tags\x01"
  "document_454\x01tags\x01"
  "document_283\x01tags\x01"
  "document_339\x01tags\x01"
  "document_340\x01tags\x01"
  "document_341\x01tags\x01"
  "document_287\x01tags\x01"
  "document_278\x01tags\x01"
  "document_280\x01tags\x01"
  "document_281\x01tags\x01"
  "document_351\x01tags\x01"
  "document_273\x01tags\x01"
  "document_277\x01tags\x01"
  "document_282\x01tags\x01"
  "document_279\x01tags\x01"
  "document_276\x01tags\x01"
  "document_286\x01tags\x01"
  "document_268\x01tags\x01"
  "document_262\x01tags\x01"
  "document_290\x01tags\x01"
  "document_263\x01tags\x01"
  "document_261\x01tags\x01"
]
0.54 ms
(0.95%)
3
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  521
]
0.48 ms
(0.84%)
1
SELECT object_1.id as id, object_1.type as `type` FROM object_1 WHERE ( object_1.type IN ('object','variant','folder')) AND object_1.published = 1
Parameters:
[]
0.38 ms
(0.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:
[
  1773179459
  "document_151\x01tags\x01"
  "document_161\x01tags\x01"
  "document_156\x01tags\x01"
  "document_203\x01tags\x01"
  "document_188\x01tags\x01"
  "document_158\x01tags\x01"
  "document_209\x01tags\x01"
  "document_213\x01tags\x01"
  "document_205\x01tags\x01"
  "document_202\x01tags\x01"
  "document_204\x01tags\x01"
  "document_237\x01tags\x01"
  "document_240\x01tags\x01"
  "document_207\x01tags\x01"
  "document_248\x01tags\x01"
  "asset_1149\x01tags\x01"
]
0.35 ms
(0.62%)
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:
[
  1773179459
  "document_496\x01tags\x01"
  "asset_2842\x01tags\x01"
  "asset_2833\x01tags\x01"
  "asset_2840\x01tags\x01"
  "asset_2844\x01tags\x01"
  "asset_2832\x01tags\x01"
  "asset_2987\x01tags\x01"
  "asset_2834\x01tags\x01"
  "asset_3247\x01tags\x01"
  "asset_3248\x01tags\x01"
  "asset_3249\x01tags\x01"
  "asset_2836\x01tags\x01"
  "asset_2843\x01tags\x01"
  "asset_2839\x01tags\x01"
  "asset_2838\x01tags\x01"
  "asset_2837\x01tags\x01"
  "asset_2835\x01tags\x01"
  "asset_2841\x01tags\x01"
  "asset_2854\x01tags\x01"
]
0.35 ms
(0.61%)
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:
[
  1773179459
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
0.30 ms
(0.53%)
1
SELECT object_2.id as id, object_2.type as `type` FROM object_2 WHERE ( object_2.type IN ('object','variant','folder')) AND object_2.published = 1
Parameters:
[]
0.28 ms
(0.50%)
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:
[
  1773179459
  "document_521\x01tags\x01"
  "asset_3247\x01tags\x01"
  "asset_3248\x01tags\x01"
  "asset_3249\x01tags\x01"
]
0.28 ms
(0.49%)
2
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.25 ms
(0.45%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  2854
]
0.24 ms
(0.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:
[
  1773179459
  "document_2\x01tags\x01"
  "document_3\x01tags\x01"
  "document_5\x01tags\x01"
  "document_89\x01tags\x01"
  "document_55\x01tags\x01"
  "document_4\x01tags\x01"
  "asset_1166\x01tags\x01"
  "document_115\x01tags\x01"
  "document_70\x01tags\x01"
  "document_93\x01tags\x01"
  "document_73\x01tags\x01"
  "document_129\x01tags\x01"
  "document_130\x01tags\x01"
  "document_71\x01tags\x01"
  "asset_891\x01tags\x01"
  "asset_1080\x01tags\x01"
  "asset_942\x01tags\x01"
  "asset_1149\x01tags\x01"
]
0.18 ms
(0.31%)
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:
[
  1773179459
  "website_config\x01tags\x01"
  "system\x01tags\x01"
  "config\x01tags\x01"
  "output\x01tags\x01"
  "document_44\x01tags\x01"
  "document_22\x01tags\x01"
  "document_43\x01tags\x01"
  "document_11\x01tags\x01"
  "document_51\x01tags\x01"
  "document_46\x01tags\x01"
  "document_50\x01tags\x01"
  "document_53\x01tags\x01"
]
0.16 ms
(0.29%)
1
SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
0.14 ms
(0.25%)
1
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  2854
]
0.14 ms
(0.25%)
1
SELECT * FROM object_url_slugs WHERE slug = '/it/terme-sauna/family-world/montequarium/abitanti del mare' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects