Query Metrics

23 Database Queries
7 Different statements
4.94 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.37 ms
(27.68%)
6
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/de/"
  "ringhotel_schorfheide_tagungszentrum_der_wirtschaft_joachimsthal-4499467"
]
1.33 ms
(26.99%)
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:
[
  1765002330
  "site_domain_00c38a82043f1716d949775bc63df8fb"
]
0.93 ms
(18.81%)
5
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/de/ringhotel_schorfheide_tagungszentrum_der_wirtschaft_joachimsthal-4499467"
]
0.72 ms
(14.50%)
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:
[
  1765002330
  "system\x01tags\x01"
  "site\x01tags\x01"
]
0.20 ms
(4.13%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.20 ms
(4.03%)
1
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
0.19 ms
(3.87%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/ringhotel_schorfheide_tagungszentrum_der_wirtschaft_joachimsthal-4499467' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No mapped entities.