Query Metrics
5
Database Queries
5
Different statements
1.56 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.44 ms (28.08%) |
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.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[ "centre-social-les-olives-la-marie" 1 ] |
|
0.43 ms (27.72%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.quotation AS quotation_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.created_at AS created_at_11, t9.updated_at AS updated_at_12, t9.name AS name_13, t9.address AS address_14, t9.mail AS mail_15, t9.slug AS slug_16, t9.meta_title AS meta_title_17, t9.meta_desc AS meta_desc_18, t9.title AS title_19, t9.welcome_text AS welcome_text_20, t9.educative_project AS educative_project_21, t9.price AS price_22, t9.team_text AS team_text_23, t9.team_list AS team_list_24, t9.contact_phone AS contact_phone_25, t9.welcome_hours AS welcome_hours_26, t9.closure_hours AS closure_hours_27, t9.city AS city_28, t9.zip_code AS zip_code_29, t9.type AS type_30, t9.header AS header_31, t9.header_mobile AS header_mobile_32, t9.band AS band_33, t9.link_registration AS link_registration_34, t9.link_opinion AS link_opinion_35, t9.team_img AS team_img_36, t9.image_vignette AS image_vignette_37, t9.quotation_id AS quotation_id_38, t39.id AS id_40, t39.name AS name_41, t39.slug AS slug_42, t39.address AS address_43, t39.picto AS picto_44, t39.created_at AS created_at_45, t39.updated_at AS updated_at_46, t39.content_first AS content_first_47, t39.content_second AS content_second_48, t39.image_name AS image_name_49, t39.image_size AS image_size_50, t39.kpi1 AS kpi1_51, t39.kpi2 AS kpi2_52, t39.kpi3 AS kpi3_53, t39.banner_image_mobile AS banner_image_mobile_54, t39.banner_image_desktop AS banner_image_desktop_55, t39.kpi_text1 AS kpi_text1_56, t39.kpi_text2 AS kpi_text2_57, t39.kpi_text3 AS kpi_text3_58, t39.active AS active_59, t39.phone AS phone_60, t39.email AS email_61, t39.brochure AS brochure_62, t39.cost AS cost_63, t39.video_url AS video_url_64, t39.opening_hours AS opening_hours_65, t39.acm_title AS acm_title_66, t39.acm_description AS acm_description_67, t39.latitude AS latitude_68, t39.longitude AS longitude_69, t39.video_thumbnail AS video_thumbnail_70, t39.content_image1 AS content_image1_71, t39.content_image2 AS content_image2_72, t39.quotation_id AS quotation_id_73 FROM quotation t0 LEFT JOIN nursery t9 ON t9.quotation_id = t0.id LEFT JOIN community_center t39 ON t39.quotation_id = t0.id WHERE t0.id = ?
Parameters:
[
3
]
|
|
0.25 ms (15.80%) |
1 |
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
]
|
|
0.24 ms (15.60%) |
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.community_center_id = ?
Parameters:
[
4
]
|
|
0.20 ms (12.80%) |
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.community_center_id AS community_center_id_6 FROM community_center_image t0 WHERE t0.community_center_id = ?
Parameters:
[
4
]
|
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 |
|
| App\Entity\Testimonial | No errors. |
| App\Entity\CommunityCenterActivity | No errors. |
| App\Entity\CommunityCenterImage | No errors. |
| App\Entity\Nursery | No errors. |
| App\Entity\Region | No errors. |