Query Metrics
6
Database Queries
4
Different statements
10.51 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.04 ms |
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:
[ "skylight_blinds" "eng" ] |
| 2 | 1.31 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"
]
|
| 3 | 0.77 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.77 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.33 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.content_str AS content_str_3, t0.payoff_str AS payoff_str_4, t0.link_to_product_id AS link_to_product_id_5, t0.featured_id AS featured_id_6 FROM banners t0 WHERE t0.featured_id = ?
Parameters:
[
"1"
]
|
| 6 | 1.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.dropdown_str AS dropdown_str_3, t0.has_product_dropdown AS has_product_dropdown_4 FROM featureds 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\ShopSetting | No errors. |
| ShopBundle\Entity\Banner | No errors. |
| ShopBundle\Entity\Product | No errors. |
| ShopBundle\Entity\Featured | No errors. |