Query Metrics
7
Database Queries
7
Different statements
2.29 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.68 ms (29.57%) |
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:
[
"josette-jourdan"
]
|
|
0.31 ms (13.74%) |
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.30 ms (13.08%) |
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:
[
"josette-jourdan"
]
|
|
0.29 ms (12.68%) |
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.29 ms (12.52%) |
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.22 ms (9.49%) |
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:
[
1
]
|
|
0.20 ms (8.93%) |
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:
[
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 |
|---|---|
| App\Entity\Nursery | No errors. |
| App\Entity\Quotation |
|
| 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. |