Query Metrics
14
Database Queries
8
Different statements
4.56 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.84 ms (18.37%) |
1 |
SELECT t0.id AS id_1, t0.quote AS quote_2, t0.name AS name_3, t0.call_yourself AS call_yourself_4, t0.image AS image_5, t0.is_visible AS is_visible_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.region_id AS region_id_9, t0.community_center_id AS community_center_id_10 FROM testimonial t0 WHERE t0.region_id IS NULL AND t0.community_center_id IS NULL AND t0.is_visible = ?
Parameters:
[
1
]
|
|
0.67 ms (14.62%) |
2 |
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 = ?
Parameters:
[
1
]
|
|
0.66 ms (14.45%) |
4 |
SELECT t0.id AS id_1, t0.content AS content_2, t0.active AS active_3 FROM banner t0
Parameters:
[] |
|
0.60 ms (13.04%) |
1 |
SELECT t0.id AS id_1, t0.region_idf AS region_idf_2, t0.region_ge AS region_ge_3, t0.region_ara AS region_ara_4, t0.region_paca AS region_paca_5, t0.kpi_talent AS kpi_talent_6, t0.kpi_collaborator AS kpi_collaborator_7, t0.kpi_young_accompany AS kpi_young_accompany_8, t0.kpi_educative_innovation_child AS kpi_educative_innovation_child_9, t0.kpi_educative_innovation_school AS kpi_educative_innovation_school_10, t0.kpi_third_places_spaces AS kpi_third_places_spaces_11, t0.kpi_third_places_visitor AS kpi_third_places_visitor_12, t0.kpi_third_places_event AS kpi_third_places_event_13, t0.kpi_third_places_employement AS kpi_third_places_employement_14, t0.partner AS partner_15, t0.kpi_join_us_women_rate AS kpi_join_us_women_rate_16, t0.kpi_join_us_age_average AS kpi_join_us_age_average_17, t0.region_reu AS region_reu_18 FROM kpi t0
Parameters:
[] |
|
0.55 ms (12.12%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.cta_link AS cta_link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.image AS image_10, t0.published AS published_11, t0.cta_name AS cta_name_12, t0.body_secondly AS body_secondly_13, t0.catch_phrase AS catch_phrase_14, t0.subtitle AS subtitle_15, t0.author_id AS author_id_16, t0.category_id AS category_id_17 FROM article t0 WHERE t0.published = ? ORDER BY t0.created_at DESC LIMIT 4
Parameters:
[
1
]
|
|
0.44 ms (9.64%) |
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.header AS header_22, t0.header_mobile AS header_mobile_23, t0.band AS band_24, t0.link_registration AS link_registration_25, t0.link_opinion AS link_opinion_26, t0.team_img AS team_img_27, t0.image_vignette AS image_vignette_28, t0.quotation_id AS quotation_id_29 FROM nursery t0
Parameters:
[] |
|
0.42 ms (9.23%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.cta_name AS cta_name_4, t0.cta_link AS cta_link_5, t0.image AS image_6, t0.image_mobile AS image_mobile_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.visible AS visible_10, t0.ranking AS ranking_11 FROM home_screen t0 WHERE t0.visible = ? ORDER BY t0.ranking ASC
Parameters:
[
1
]
|
|
0.39 ms (8.52%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
195
]
|
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\Kpi | No errors. |
| App\Entity\Banner | No errors. |
| App\Entity\HomeScreen | No errors. |
| App\Entity\Testimonial | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\CommunityCenter | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\Author | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Tags | No 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\CommunityCenterActivity | No errors. |
| App\Entity\CommunityCenterImage | No errors. |