GET https://qa.synergiefamily.com/centres-sociaux

Query Metrics

11 Database Queries
3 Different statements
2.59 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.41 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 = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
2 0.27 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.name AS name_3, t0.description AS description_4, t0.category AS category_5, t0.age_range AS age_range_6, t0.schedule AS schedule_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM community_center_activity t0 INNER JOIN community_center_community_center_activity ON t0.id = community_center_community_center_activity.community_center_activity_id WHERE community_center_community_center_activity.community_center_id = ?
Parameters:
[
  5
]
3 0.21 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.community_center_id = ?
Parameters:
[
  5
]
4 0.26 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.name AS name_3, t0.description AS description_4, t0.category AS category_5, t0.age_range AS age_range_6, t0.schedule AS schedule_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM community_center_activity t0 INNER JOIN community_center_community_center_activity ON t0.id = community_center_community_center_activity.community_center_activity_id WHERE community_center_community_center_activity.community_center_id = ?
Parameters:
[
  3
]
5 0.22 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.community_center_id = ?
Parameters:
[
  3
]
6 0.28 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.name AS name_3, t0.description AS description_4, t0.category AS category_5, t0.age_range AS age_range_6, t0.schedule AS schedule_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM community_center_activity t0 INNER JOIN community_center_community_center_activity ON t0.id = community_center_community_center_activity.community_center_activity_id WHERE community_center_community_center_activity.community_center_id = ?
Parameters:
[
  4
]
7 0.18 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.community_center_id = ?
Parameters:
[
  4
]
8 0.21 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.name AS name_3, t0.description AS description_4, t0.category AS category_5, t0.age_range AS age_range_6, t0.schedule AS schedule_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM community_center_activity t0 INNER JOIN community_center_community_center_activity ON t0.id = community_center_community_center_activity.community_center_activity_id WHERE community_center_community_center_activity.community_center_id = ?
Parameters:
[
  6
]
9 0.17 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.community_center_id = ?
Parameters:
[
  6
]
10 0.19 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.name AS name_3, t0.description AS description_4, t0.category AS category_5, t0.age_range AS age_range_6, t0.schedule AS schedule_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM community_center_activity t0 INNER JOIN community_center_community_center_activity ON t0.id = community_center_community_center_activity.community_center_activity_id WHERE community_center_community_center_activity.community_center_id = ?
Parameters:
[
  2
]
11 0.18 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.community_center_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\CommunityCenter 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\Testimonial No errors.
App\Entity\CommunityCenterActivity No errors.
App\Entity\CommunityCenterImage No errors.
App\Entity\Region No errors.