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

Query Metrics

11 Database Queries
8 Different statements
71.78 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
47.09 ms
(65.60%)
2
"COMMIT"
Parameters:
[]
6.29 ms
(8.76%)
2
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"
]
5.97 ms
(8.31%)
1
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"
]
4.59 ms
(6.39%)
1
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"
]
4.10 ms
(5.71%)
2
"START TRANSACTION"
Parameters:
[]
1.76 ms
(2.46%)
1
DELETE FROM sanity_cache WHERE id = ?
Parameters:
[
  8833
]
1.26 ms
(1.75%)
1
INSERT INTO sanity_cache (query, params, response, expires) VALUES (?, ?, ?, ?)
Parameters:
[
  "ec365a1892b52246f97f745bd272c239e0ce103b3c47626e89e903690eb4fd93"
  "7e1eb1d6a65f77a1d7bfe14a83cc067711846d36e38abaa9954030bfb49a09af"
  "a:0:{}"
  "2026-01-03 04:43:10"
]
0.73 ms
(1.02%)
1
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