Query Metrics
15
Database Queries
12
Different statements
4.63 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.56 ms |
SELECT e0_.id AS id_0, e0_.created_at AS created_at_1, e0_.updated_at AS updated_at_2, e0_.title AS title_3, e0_.slug AS slug_4, e0_.audience AS audience_5, e0_.description AS description_6, e0_.tags AS tags_7, e0_.header_image AS header_image_8, e0_.header_description AS header_description_9, e0_.visible AS visible_10, e0_.position AS position_11, e0_.intro_title AS intro_title_12, e0_.intro_p1 AS intro_p1_13, e0_.intro_p2 AS intro_p2_14, e0_.intro_image1 AS intro_image1_15, e0_.intro_image2 AS intro_image2_16, e0_.slider_title AS slider_title_17, e0_.slider_description AS slider_description_18, e0_.slider_main_image AS slider_main_image_19, e0_.slider_brochure_link AS slider_brochure_link_20, e0_.benefits_title AS benefits_title_21, e0_.benefits_subtitle AS benefits_subtitle_22, e0_.video_url AS video_url_23, e0_.video_thumbnail AS video_thumbnail_24, e0_.enterprise_title AS enterprise_title_25, e0_.enterprise_subtitle AS enterprise_subtitle_26, e0_.enterprise_description AS enterprise_description_27, e0_.enterprise_image1 AS enterprise_image1_28, e0_.enterprise_image2 AS enterprise_image2_29, e0_.enterprise_use_cases_title AS enterprise_use_cases_title_30, e0_.enterprise_cta_text AS enterprise_cta_text_31, e0_.enterprise_cta_link AS enterprise_cta_link_32, e0_.public_title AS public_title_33, e0_.public_subtitle AS public_subtitle_34, e0_.public_description AS public_description_35, e0_.public_image1 AS public_image1_36, e0_.public_image2 AS public_image2_37, e0_.public_use_cases_title AS public_use_cases_title_38, e0_.public_cta_text AS public_cta_text_39, e0_.public_cta_link AS public_cta_link_40, e0_.form_title AS form_title_41, e0_.form_subtitle AS form_subtitle_42, e0_.logos_title AS logos_title_43, e0_.faq_title AS faq_title_44, e0_.bottom_cta_title AS bottom_cta_title_45, e0_.bottom_cta_subtitle AS bottom_cta_subtitle_46, e0_.bottom_cta_text AS bottom_cta_text_47, e0_.bottom_cta_link AS bottom_cta_link_48, e0_.faq_category_id AS faq_category_id_49 FROM event_offer e0_ WHERE e0_.slug = ? AND e0_.visible = 1
Parameters:
[
"la-gaming-room-mobile"
]
|
| 2 | 0.47 ms |
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
]
|
| 3 | 0.36 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.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
]
|
| 4 | 0.32 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
]
|
| 5 | 0.24 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.ranking AS ranking_5, t0.visible AS visible_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.event_offer_id AS event_offer_id_9 FROM event_offer_slider_chapter t0 WHERE t0.event_offer_id = ? ORDER BY t0.ranking ASC
Parameters:
[
1
]
|
| 6 | 0.22 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4, t0.ranking AS ranking_5, t0.visible AS visible_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.chapter_id AS chapter_id_9 FROM event_offer_slider_chapter_item t0 WHERE t0.chapter_id = ? ORDER BY t0.ranking ASC
Parameters:
[
1
]
|
| 7 | 0.21 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4, t0.ranking AS ranking_5, t0.visible AS visible_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.chapter_id AS chapter_id_9 FROM event_offer_slider_chapter_item t0 WHERE t0.chapter_id = ? ORDER BY t0.ranking ASC
Parameters:
[
2
]
|
| 8 | 0.21 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4, t0.ranking AS ranking_5, t0.visible AS visible_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.chapter_id AS chapter_id_9 FROM event_offer_slider_chapter_item t0 WHERE t0.chapter_id = ? ORDER BY t0.ranking ASC
Parameters:
[
3
]
|
| 9 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4, t0.ranking AS ranking_5, t0.visible AS visible_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.chapter_id AS chapter_id_9 FROM event_offer_slider_chapter_item t0 WHERE t0.chapter_id = ? ORDER BY t0.ranking ASC
Parameters:
[
4
]
|
| 10 | 0.24 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4, t0.ranking AS ranking_5, t0.visible AS visible_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.event_offer_id AS event_offer_id_9 FROM event_offer_benefit t0 WHERE t0.event_offer_id = ? ORDER BY t0.ranking ASC
Parameters:
[
1
]
|
| 11 | 0.23 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.ranking AS ranking_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.event_offer_id AS event_offer_id_8 FROM event_offer_enterprise_use_case t0 WHERE t0.event_offer_id = ? ORDER BY t0.ranking ASC
Parameters:
[
1
]
|
| 12 | 0.21 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.ranking AS ranking_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.event_offer_id AS event_offer_id_8 FROM event_offer_public_use_case t0 WHERE t0.event_offer_id = ? ORDER BY t0.ranking ASC
Parameters:
[
1
]
|
| 13 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.ranking AS ranking_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.event_offer_id AS event_offer_id_8 FROM event_offer_showcase_logo t0 WHERE t0.event_offer_id = ? ORDER BY t0.ranking ASC
Parameters:
[
1
]
|
| 14 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.visible_on_faq_page AS visible_on_faq_page_4 FROM faq_category t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 15 | 0.69 ms |
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.position AS position_4, t0.faq_category_id AS faq_category_id_5 FROM faq t0 WHERE t0.faq_category_id = ? ORDER BY t0.position ASC
Parameters:
[
8
]
|
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.