GET http://app.gordijnen.amsdard.dev/about/skylight_roller_blinds/roto/600PVC

Query Metrics

4 Database Queries
3 Different statements
5.20 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.47 ms
SELECT sub.id, sub.parent, sub.controller FROM pages sub INNER JOIN pages parent ON (sub.parent = parent.id) INNER JOIN stringtable str_sub ON (sub.identifier_str = str_sub.code) INNER JOIN stringtable_values sv_sub ON (str_sub.id = sv_sub.string_id) INNER JOIN stringtable str_parent ON (parent.identifier_str = str_parent.code) INNER JOIN stringtable_values sv_parent ON (str_parent.id = sv_parent.string_id) WHERE ISNULL(parent.parent) AND sv_parent.value = ? AND sv_parent.language_code = ? AND sv_sub.value = ? AND sv_sub.language_code = ? ORDER BY id LIMIT 1
Parameters:
[
  "about"
  "eng"
  "skylight_roller_blinds"
  "eng"
]
2 1.03 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM shop_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "sanity.projectId"
]
3 0.88 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM shop_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "sanity.dataset"
]
4 0.82 ms
SELECT t0.id AS id_1, t0.query AS query_2, t0.params AS params_3, t0.response AS response_4, t0.expires AS expires_5 FROM sanity_cache t0 WHERE t0.query = ? AND t0.params = ? LIMIT 1
Parameters:
[
  "ec365a1892b52246f97f745bd272c239e0ce103b3c47626e89e903690eb4fd93"
  "7e1eb1d6a65f77a1d7bfe14a83cc067711846d36e38abaa9954030bfb49a09af"
]

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.

Entities Mapping

Class Mapping errors
ShopBundle\Entity\ShopSetting No errors.
ShopBundle\Entity\SanityCache No errors.