GET http://app.gordijnen.amsdard.dev/about/skylight_roller_blinds/dakstra/F6A

Query Metrics

6 Database Queries
4 Different statements
20.30 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 7.34 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.83 ms
SELECT t0.id AS id_1, t0.name_str AS name_str_2, t0.code AS code_3, t0.iso AS iso_4, t0.promote AS promote_5, t0.vat_percentage AS vat_percentage_6 FROM user_countries t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
3 3.29 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"
]
4 1.96 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"
]
5 4.95 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"
]
6 0.93 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:
[
  "vadain.token"
]

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