Query Metrics
11
Database Queries
5
Different statements
24.65 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.90 ms |
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.slug = ? LIMIT 1
Parameters:
[
"audition-mutualiste"
]
|
| 2 | 1.64 ms |
SELECT t0.id AS id_1, t0.state AS state_2, t0.name AS name_3, t0.address AS address_4, t0.address_detail AS address_detail_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.phone_number AS phone_number_8, t0.fax AS fax_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.deleted_at AS deleted_at_12, t0.acquisition_enabled AS acquisition_enabled_13, t0.reach AS reach_14, t0.priority AS priority_15, t0.logo_path AS logo_path_16, t0.siret_number AS siret_number_17, t0.updated_at AS updated_at_18, t0.email_notification AS email_notification_19, t0.is_email_notification AS is_email_notification_20, t0.slug AS slug_21, t0.teaser AS teaser_22, t0.handicap_access AS handicap_access_23, t0.qualification_enabled AS qualification_enabled_24, t0.hearing_brand_id AS hearing_brand_id_25, t0.administrator_id AS administrator_id_26, t0.estimated_reach_id AS estimated_reach_id_27, t0.store_page_id AS store_page_id_28, t0.payment_method_id AS payment_method_id_29, t30.id AS id_31, t30.place_id AS place_id_32, t30.rating AS rating_33, t30.user_rating_count AS user_rating_count_34, t30.last_fetched_at AS last_fetched_at_35, t30.no_place_id_detected_at AS no_place_id_detected_at_36, t30.open_hours_weekday_descriptions AS open_hours_weekday_descriptions_37, t30.nearby_transit AS nearby_transit_38, t30.place_id_last_refresh_at AS place_id_last_refresh_at_39, t30.store_id AS store_id_40 FROM store t0 LEFT JOIN store_place_data t30 ON t30.store_id = t0.id WHERE t0.hearing_brand_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
12
]
|
| 3 | 3.58 ms |
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:
[] |
| 4 | 3.85 ms |
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
]
|
| 5 | 3.27 ms |
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:
[] |
| 6 | 2.45 ms |
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:
[] |
| 7 | 3.88 ms |
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
]
|
| 8 | 1.25 ms |
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:
[] |
| 9 | 0.25 ms |
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:
[] |
| 10 | 0.33 ms |
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
]
|
| 11 | 0.26 ms |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ThirdPartyEntity | No errors. |
| App\Entity\Prospect | No errors. |
| App\Entity\Store | No errors. |
| App\Entity\ProspectOnStoreStatus | No errors. |
| App\Entity\DeviceSale | No errors. |
| App\Entity\CityPost | No errors. |
| App\Entity\HearingBrand | No errors. |
| App\Entity\HearingMaker | No errors. |
| App\Entity\Administrator | No errors. |
| App\Entity\Freelancer | No errors. |
| App\Entity\FreelancerAssistant | No errors. |
| App\Entity\Stat\Event | No errors. |
| App\Entity\ProspectOnStore | No errors. |
| App\Entity\Stat\Report | No errors. |
| App\Entity\AcquisitionMode | No errors. |
| App\Entity\ProspectDropped | No errors. |
| App\Entity\Partner | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Sponsorship | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\EstimatedReach | No errors. |
| App\Entity\StorePage | No errors. |
| Wits\PaymentBundle\Entity\PaymentMethod | No errors. |
| App\Entity\StorePlaceData | No errors. |
| App\Entity\HearingAid | No errors. |