Query Metrics
11
Database Queries
8
Different statements
50.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
39.83 ms (79.08%) |
2 |
"COMMIT"
Parameters:
[] |
|
2.51 ms (4.98%) |
1 |
INSERT INTO sanity_cache (query, params, response, expires) VALUES (?, ?, ?, ?)
Parameters:
[ "ec365a1892b52246f97f745bd272c239e0ce103b3c47626e89e903690eb4fd93" "d2bfe71c9c4dcf88b6f0330b7dd2ce9a34f4289ebdc513da5cf42f9b7c48970b" "a:0:{}" "2026-03-04 02:27:45" ] |
|
2.35 ms (4.66%) |
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" "d2bfe71c9c4dcf88b6f0330b7dd2ce9a34f4289ebdc513da5cf42f9b7c48970b" ] |
|
1.97 ms (3.91%) |
1 |
SELECT pages.id, pages.parent, pages.controller FROM pages INNER JOIN stringtable str ON (pages.identifier_str = str.code) INNER JOIN stringtable_values sv ON (str.id = sv.string_id) WHERE ISNULL(pages.parent) AND sv.value = ? AND sv.language_code = ? ORDER BY id LIMIT 1
Parameters:
[ "how_to_install" "eng" ] |
|
1.12 ms (2.22%) |
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"
]
|
|
1.10 ms (2.19%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.87 ms (1.73%) |
1 |
DELETE FROM sanity_cache WHERE id = ?
Parameters:
[
9249
]
|
|
0.62 ms (1.23%) |
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"
]
|
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. |