Query Metrics

14 Database Queries
8 Different statements
4.56 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.60 ms
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:
[]
2 0.30 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.active AS active_3 FROM banner t0
Parameters:
[]
3 0.42 ms
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
]
4 0.84 ms
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
]
5 0.55 ms
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
]
6 0.44 ms
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:
[]
7 0.45 ms
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
]
8 0.22 ms
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
]
9 0.13 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.active AS active_3 FROM banner t0
Parameters:
[]
10 0.12 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.active AS active_3 FROM banner t0
Parameters:
[]
11 0.11 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.active AS active_3 FROM banner t0
Parameters:
[]
12 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
  195
]
13 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
  194
]
14 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
  193
]

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
  • 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\CommunityCenterActivity No errors.
App\Entity\CommunityCenterImage No errors.