Query Metrics
3
Database Queries
3
Different statements
2.52 ms
Query time
1
Invalid entities
4
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.86 ms |
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.host AS host_2, v0_.meta AS meta_3, v0_.email AS email_4, v0_.initials AS initials_5, v0_.country AS country_6, v0_.cdn_asset AS cdn_asset_7, v0_.active AS active_8, v0_.master AS master_9, v0_.prefix_translation AS prefix_translation_10, v0_.galaxite AS galaxite_11, v0_.location_id AS location_id_12, v0_.currency_id AS currency_id_13 FROM v4_website v0_ WHERE v0_.host = ?
Parameters:
[
"choco.villa-bali.com"
]
|
2 | 0.69 ms |
SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.enabled AS enabled_2, v0_.og_region AS og_region_3, v0_.label_header AS label_header_4, v0_.localized_label AS localized_label_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.currency_id AS currency_id_8, v0_.country_id AS country_id_9, v0_.root_locale_id AS root_locale_id_10 FROM front_country f1_ INNER JOIN v4_locale v0_ ON (v0_.country_id = f1_.id AND f1_.id = ?)
Parameters:
[
565
]
|
3 | 0.97 ms |
SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.enabled AS enabled_2, v0_.og_region AS og_region_3, v0_.label_header AS label_header_4, v0_.localized_label AS localized_label_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.currency_id AS currency_id_8, v0_.country_id AS country_id_9, v0_.root_locale_id AS root_locale_id_10 FROM v4_locale v0_ INNER JOIN v4_website_locale v2_ ON v0_.id = v2_.locale_id INNER JOIN v4_website v1_ ON v1_.id = v2_.website_id AND (v1_.id = '1') WHERE v0_.enabled = ?
Parameters:
[
1
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
4
Hits
0
Misses
0
Puts
Number of cache hits
Region | Hits |
---|---|
barely_updated | 2 |
query_cache_region | 2 |