Query Metrics

171 Database Queries
16 Different statements
497.19 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
225.61 ms
(45.38%)
49
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:
[
  1790721829
  "object_1419\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_230\x01tags\x01"
]
173.36 ms
(34.87%)
80
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:
[
  1790721829
  "site_domain_7a3f6476f82647e329c686245e107ee1"
]
69.60 ms
(14.00%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  79
]
7.44 ms
(1.50%)
10
SELECT object_localized_3_sv_SE.id as id, object_localized_3_sv_SE.type as `type` FROM object_localized_3_sv_SE WHERE (path = ? AND  object_localized_3_sv_SE.type IN ('object','variant','folder')) AND object_localized_3_sv_SE.published = 1 ORDER BY `title`
Parameters:
[
  "/Data Objects/BusinessDomain/"
]
5.16 ms
(1.04%)
10
SELECT object_localized_16_sv_SE.id as id, object_localized_16_sv_SE.type as `type` FROM object_localized_16_sv_SE WHERE (path = ? AND Status = ? AND  object_localized_16_sv_SE.type IN ('object','variant','folder')) AND object_localized_16_sv_SE.published = 1 ORDER BY `id` ASC
Parameters:
[
  "/Data Objects/ProductCategory/"
  "Active"
]
3.55 ms
(0.71%)
5
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
  "3"
]
3.07 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:
[
  1790721829
  "object_1360\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_194\x01tags\x01"
  "document_28\x01tags\x01"
  "asset_188\x01tags\x01"
]
2.98 ms
(0.60%)
1
SELECT object_localized_3_sv_SE.id as id, object_localized_3_sv_SE.type as `type` FROM object_localized_3_sv_SE WHERE (path = ? AND visibleHome = 1 AND  object_localized_3_sv_SE.type IN ('object','variant','folder')) AND object_localized_3_sv_SE.published = 1 ORDER BY `creationDate` DESC   LIMIT 4
Parameters:
[
  "/Data Objects/BusinessDomain/"
]
1.76 ms
(0.35%)
1
SELECT object_localized_3_sv_SE.id as id, object_localized_3_sv_SE.type as `type` FROM object_localized_3_sv_SE WHERE (path REGEXP ? AND visibleHome = 1 AND  object_localized_3_sv_SE.type IN ('object','variant','folder')) AND object_localized_3_sv_SE.published = 1 ORDER BY `creationDate` DESC   LIMIT 3
Parameters:
[
  "^/Data Objects/BusinessDomain/[^/]+/$"
]
1.65 ms
(0.33%)
1
SELECT object_localized_9_sv_SE.id as id, object_localized_9_sv_SE.type as `type` FROM object_localized_9_sv_SE WHERE (path LIKE ? AND  object_localized_9_sv_SE.type IN ('object','variant','folder')) AND object_localized_9_sv_SE.published = 1 ORDER BY `creationDate` DESC   LIMIT 2
Parameters:
[
  "/CMS Content/CaseStudies/%"
]
0.84 ms
(0.17%)
1
SELECT object_localized_17_sv_SE.id as id, object_localized_17_sv_SE.type as `type` FROM object_localized_17_sv_SE WHERE (path LIKE ? AND  object_localized_17_sv_SE.type IN ('object','variant','folder')) AND object_localized_17_sv_SE.published = 1 ORDER BY `creationDate` DESC   LIMIT 3
Parameters:
[
  "/CMS Content/News/%"
]
0.66 ms
(0.13%)
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:
[
  1790721829
  "system\x01tags\x01"
  "site\x01tags\x01"
]
0.60 ms
(0.12%)
3
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.42 ms
(0.08%)
2
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/se/"
  "home"
]
0.31 ms
(0.06%)
1
SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
0.19 ms
(0.04%)
1
SELECT * FROM object_url_slugs WHERE slug = '/se/home' 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

Entities Mapping

No loaded entities.