Redirect 301 redirect from GET @document_78 (afe801)

GET http://dev-pim.melbye.no/no/home

Query Metrics

173 Database Queries
16 Different statements
444.37 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
255.42 ms
(57.48%)
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:
[
  1790721829
  "site_domain_7a3f6476f82647e329c686245e107ee1"
]
158.06 ms
(35.57%)
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"
]
15.16 ms
(3.41%)
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"
]
6.69 ms
(1.50%)
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/"
]
2.10 ms
(0.47%)
4
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
1.21 ms
(0.27%)
5
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
  "3"
]
1.01 ms
(0.23%)
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.83 ms
(0.19%)
2
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  108
]
0.72 ms
(0.16%)
2
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/no/"
  "home"
]
0.68 ms
(0.15%)
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.62 ms
(0.14%)
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.59 ms
(0.13%)
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.52 ms
(0.12%)
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.32 ms
(0.07%)
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"
]
0.24 ms
(0.05%)
1
SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
0.22 ms
(0.05%)
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.