GET https://qa.synergiefamily.com/petite-enfance/nos-creches/micro-creche-babyscovery-daudet

Query Metrics

7 Database Queries
7 Different statements
2.12 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.43 ms
(20.38%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.address AS address_5, t0.mail AS mail_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_desc AS meta_desc_9, t0.title AS title_10, t0.welcome_text AS welcome_text_11, t0.educative_project AS educative_project_12, t0.price AS price_13, t0.team_text AS team_text_14, t0.team_list AS team_list_15, t0.contact_phone AS contact_phone_16, t0.welcome_hours AS welcome_hours_17, t0.closure_hours AS closure_hours_18, t0.city AS city_19, t0.zip_code AS zip_code_20, t0.type AS type_21, t0.visible AS visible_22, t0.header AS header_23, t0.header_mobile AS header_mobile_24, t0.band AS band_25, t0.link_registration AS link_registration_26, t0.link_opinion AS link_opinion_27, t0.team_img AS team_img_28, t0.image_vignette AS image_vignette_29, t0.latitude AS latitude_30, t0.longitude AS longitude_31, t0.quotation_id AS quotation_id_32 FROM nursery t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "micro-creche-babyscovery-daudet"
]
0.31 ms
(14.82%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.picto AS picto_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.content_first AS content_first_8, t0.content_second AS content_second_9, t0.image_name AS image_name_10, t0.image_size AS image_size_11, t0.kpi1 AS kpi1_12, t0.kpi2 AS kpi2_13, t0.kpi3 AS kpi3_14, t0.banner_image_mobile AS banner_image_mobile_15, t0.banner_image_desktop AS banner_image_desktop_16, t0.kpi_text1 AS kpi_text1_17, t0.kpi_text2 AS kpi_text2_18, t0.kpi_text3 AS kpi_text3_19, t0.active AS active_20, t0.phone AS phone_21, t0.email AS email_22, t0.brochure AS brochure_23, t0.cost AS cost_24, t0.video_url AS video_url_25, t0.opening_hours AS opening_hours_26, t0.acm_title AS acm_title_27, t0.acm_description AS acm_description_28, t0.latitude AS latitude_29, t0.longitude AS longitude_30, t0.video_thumbnail AS video_thumbnail_31, t0.content_image1 AS content_image1_32, t0.content_image2 AS content_image2_33, t0.quotation_id AS quotation_id_34 FROM community_center t0 WHERE t0.active = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
0.31 ms
(14.63%)
1
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.address AS address_4, n0_.mail AS mail_5, n0_.slug AS slug_6, n0_.meta_title AS meta_title_7, n0_.meta_desc AS meta_desc_8, n0_.title AS title_9, n0_.welcome_text AS welcome_text_10, n0_.educative_project AS educative_project_11, n0_.price AS price_12, n0_.team_text AS team_text_13, n0_.team_list AS team_list_14, n0_.contact_phone AS contact_phone_15, n0_.welcome_hours AS welcome_hours_16, n0_.closure_hours AS closure_hours_17, n0_.city AS city_18, n0_.zip_code AS zip_code_19, n0_.type AS type_20, n0_.visible AS visible_21, n0_.header AS header_22, n0_.header_mobile AS header_mobile_23, n0_.band AS band_24, n0_.link_registration AS link_registration_25, n0_.link_opinion AS link_opinion_26, n0_.team_img AS team_img_27, n0_.image_vignette AS image_vignette_28, n0_.latitude AS latitude_29, n0_.longitude AS longitude_30, n0_.quotation_id AS quotation_id_31 FROM nursery n0_ WHERE n0_.slug <> ?
Parameters:
[
  "micro-creche-babyscovery-daudet"
]
0.30 ms
(14.30%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.description AS description_5, t0.content_description AS content_description_6, t0.header_image AS header_image_7, t0.map_image AS map_image_8, t0.map_image_mobile AS map_image_mobile_9, t0.content_title AS content_title_10, t0.content_accroche AS content_accroche_11, t0.content_image1 AS content_image1_12, t0.content_image2 AS content_image2_13, t0.kpi1 AS kpi1_14, t0.kpi_text1 AS kpi_text1_15, t0.kpi2 AS kpi2_16, t0.kpi_text2 AS kpi_text2_17, t0.kpi3 AS kpi3_18, t0.kpi_text3 AS kpi_text3_19, t0.phone AS phone_20, t0.opening_hours AS opening_hours_21, t0.latitude AS latitude_22, t0.longitude AS longitude_23, t0.active AS active_24, t0.updated_at AS updated_at_25 FROM region t0 WHERE t0.active = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
0.30 ms
(14.20%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.address AS address_5, t0.mail AS mail_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_desc AS meta_desc_9, t0.title AS title_10, t0.welcome_text AS welcome_text_11, t0.educative_project AS educative_project_12, t0.price AS price_13, t0.team_text AS team_text_14, t0.team_list AS team_list_15, t0.contact_phone AS contact_phone_16, t0.welcome_hours AS welcome_hours_17, t0.closure_hours AS closure_hours_18, t0.city AS city_19, t0.zip_code AS zip_code_20, t0.type AS type_21, t0.visible AS visible_22, t0.header AS header_23, t0.header_mobile AS header_mobile_24, t0.band AS band_25, t0.link_registration AS link_registration_26, t0.link_opinion AS link_opinion_27, t0.team_img AS team_img_28, t0.image_vignette AS image_vignette_29, t0.latitude AS latitude_30, t0.longitude AS longitude_31, t0.quotation_id AS quotation_id_32 FROM nursery t0 WHERE t0.visible = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
0.26 ms
(12.23%)
1
SELECT t0.id AS id_1, t0.description AS description_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.nursery_id AS nursery_id_6 FROM listing_nursery t0 WHERE t0.nursery_id = ?
Parameters:
[
  2
]
0.20 ms
(9.43%)
1
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.nursery_id AS nursery_id_6 FROM nursery_image t0 WHERE t0.nursery_id = ?
Parameters:
[
  2
]

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\Nursery No errors.
App\Entity\Quotation
  • The field App\Entity\Quotation#communityCenter is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CommunityCenter#quotation does not contain the required 'inversedBy="communityCenter"' attribute.
App\Entity\NurseryImage No errors.
App\Entity\ListingNursery No errors.
App\Entity\LeadNursery No errors.
App\Entity\Region No errors.
App\Entity\Program No errors.
App\Entity\Testimonial No errors.
App\Entity\RegionParcours No errors.
App\Entity\RegionProjetPhare No errors.
App\Entity\RegionVille No errors.
App\Entity\RegionFeature No errors.
App\Entity\RegionImage No errors.
App\Entity\CommunityCenter No errors.
App\Entity\CommunityCenterActivity No errors.
App\Entity\CommunityCenterImage No errors.