https://mca.qa.wits-media.com/villes

Query Metrics

10 Database Queries
4 Different statements
24.79 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
11.45 ms
(46.19%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.zipcode AS zipcode_4, t0.wording AS wording_5, t0.banner_path AS banner_path_6, t0.updated_at AS updated_at_7 FROM city_post t0
Parameters:
[]
8.40 ms
(33.89%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.slug AS slug_4, t0.logo_path AS logo_path_5, t0.logo_variation_path AS logo_variation_path_6, t0.updated_at AS updated_at_7, t0.phone_number AS phone_number_8, t0.address AS address_9, t0.opening_hours AS opening_hours_10, t0.presentable AS presentable_11, t0.wording AS wording_12, t0.indexable AS indexable_13 FROM hearing_brand t0 WHERE t0.indexable = ?
Parameters:
[
  1
]
4.03 ms
(16.24%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.zipcode AS zipcode_3, c0_.wording AS wording_4, c0_.banner_path AS banner_path_5, c0_.updated_at AS updated_at_6 FROM city_post c0_ ORDER BY c0_.name ASC
Parameters:
[]
0.91 ms
(3.68%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo_path AS logo_path_4, t0.updated_at AS updated_at_5, t0.phone_number AS phone_number_6, t0.address AS address_7, t0.wording AS wording_8, t0.mediaoptin_campaign_id AS mediaoptin_campaign_id_9 FROM hearing_maker t0
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.