Query Metrics

172 Database Queries
16 Different statements
38.90 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
15.56 ms
(40.00%)
81
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:
[
  1790719058
  "site_domain_7a3f6476f82647e329c686245e107ee1"
]
9.73 ms
(25.02%)
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:
[
  1790719058
  "object_1419\x01tags\x01"
  "class_3\x01tags\x01"
  "asset_230\x01tags\x01"
]
4.21 ms
(10.82%)
10
SELECT object_localized_3_nb_NO.id as id, object_localized_3_nb_NO.type as `type` FROM object_localized_3_nb_NO WHERE (path = ? AND  object_localized_3_nb_NO.type IN ('object','variant','folder')) AND object_localized_3_nb_NO.published = 1 ORDER BY `title`
Parameters:
[
  "/Data Objects/BusinessDomain/"
]
4.21 ms
(10.82%)
10
SELECT object_localized_16_nb_NO.id as id, object_localized_16_nb_NO.type as `type` FROM object_localized_16_nb_NO WHERE (path = ? AND Status = ? AND  object_localized_16_nb_NO.type IN ('object','variant','folder')) AND object_localized_16_nb_NO.published = 1 ORDER BY `id` ASC
Parameters:
[
  "/Data Objects/ProductCategory/"
  "Active"
]
0.81 ms
(2.07%)
5
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
  "3"
]
0.73 ms
(1.87%)
4
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.50 ms
(1.29%)
1
SELECT object_localized_3_nb_NO.id as id, object_localized_3_nb_NO.type as `type` FROM object_localized_3_nb_NO WHERE (path = ? AND visibleHome = 1 AND  object_localized_3_nb_NO.type IN ('object','variant','folder')) AND object_localized_3_nb_NO.published = 1 ORDER BY `creationDate` DESC   LIMIT 4
Parameters:
[
  "/Data Objects/BusinessDomain/"
]
0.44 ms
(1.13%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  108
]
0.43 ms
(1.11%)
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:
[
  1790719058
  "system\x01tags\x01"
  "site\x01tags\x01"
]
0.42 ms
(1.09%)
2
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/no/"
  "home"
]
0.40 ms
(1.03%)
1
SELECT object_localized_17_nb_NO.id as id, object_localized_17_nb_NO.type as `type` FROM object_localized_17_nb_NO WHERE (path LIKE ? AND  object_localized_17_nb_NO.type IN ('object','variant','folder')) AND object_localized_17_nb_NO.published = 1 ORDER BY `creationDate` DESC   LIMIT 3
Parameters:
[
  "/CMS Content/News/%"
]
0.40 ms
(1.02%)
1
SELECT object_localized_9_nb_NO.id as id, object_localized_9_nb_NO.type as `type` FROM object_localized_9_nb_NO WHERE (path LIKE ? AND  object_localized_9_nb_NO.type IN ('object','variant','folder')) AND object_localized_9_nb_NO.published = 1 ORDER BY `creationDate` DESC   LIMIT 2
Parameters:
[
  "/CMS Content/CaseStudies/%"
]
0.39 ms
(1.00%)
1
SELECT object_localized_3_nb_NO.id as id, object_localized_3_nb_NO.type as `type` FROM object_localized_3_nb_NO WHERE (path REGEXP ? AND visibleHome = 1 AND  object_localized_3_nb_NO.type IN ('object','variant','folder')) AND object_localized_3_nb_NO.published = 1 ORDER BY `creationDate` DESC   LIMIT 3
Parameters:
[
  "^/Data Objects/BusinessDomain/[^/]+/$"
]
0.26 ms
(0.67%)
1
SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
0.21 ms
(0.55%)
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:
[
  1790719058
  "object_1360\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_194\x01tags\x01"
  "document_28\x01tags\x01"
  "asset_188\x01tags\x01"
]
0.20 ms
(0.51%)
1
SELECT * FROM object_url_slugs WHERE slug = '/no/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.