Query Metrics
11
Database Queries
8
Different statements
64.16 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.82 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" "IDENTIFIER_SHIPPING_INFO" "eng" ] |
| 2 | 1.30 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 | 1.83 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 | 0.80 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 | 1.32 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" "9f9d2db9792dde057c7716210e28e695f38d71e239e5b31d8469691bbfdbb6e1" ] |
| 6 | 0.65 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 5.41 ms |
DELETE FROM sanity_cache WHERE id = ?
Parameters:
[
8680
]
|
| 8 | 27.78 ms |
"COMMIT"
Parameters:
[] |
| 9 | 0.61 ms |
"START TRANSACTION"
Parameters:
[] |
| 10 | 1.37 ms |
INSERT INTO sanity_cache (query, params, response, expires) VALUES (?, ?, ?, ?)
Parameters:
[ "ec365a1892b52246f97f745bd272c239e0ce103b3c47626e89e903690eb4fd93" "9f9d2db9792dde057c7716210e28e695f38d71e239e5b31d8469691bbfdbb6e1" "a:0:{}" "2026-01-03 01:04:13" ] |
| 11 | 18.28 ms |
"COMMIT"
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| ShopBundle\Entity\UserCountry | No errors. |
| ShopBundle\Entity\Warehouse | No errors. |
| ShopBundle\Entity\ShopSetting | No errors. |
| ShopBundle\Entity\SanityCache | No errors. |