Query Metrics

471 Database Queries
26 Different statements
1173.69 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
507.78 ms
(43.26%)
207
SELECT t0.id AS id_1, t0.is_field1 AS is_field1_2, t0.is_field1_required AS is_field1_required_3, t0.is_field2 AS is_field2_4, t0.is_field2_required AS is_field2_required_5, t0.is_field3 AS is_field3_6, t0.is_field3_required AS is_field3_required_7, t0.is_field4 AS is_field4_8, t0.is_field4_required AS is_field4_required_9, t0.is_field5 AS is_field5_10, t0.is_field5_required AS is_field5_required_11, t0.is_field6 AS is_field6_12, t0.is_field6_required AS is_field6_required_13, t0.is_field7 AS is_field7_14, t0.is_field7_required AS is_field7_required_15, t0.field_label AS field_label_16, t0.field2_label AS field2_label_17, t0.field3_label AS field3_label_18, t0.field4_label AS field4_label_19, t0.field5_label AS field5_label_20, t0.field6_label AS field6_label_21, t0.field7label AS field7label_22, t0.is_textarea AS is_textarea_23, t0.is_textarea_required AS is_textarea_required_24, t0.textarea_label AS textarea_label_25, t0.is_media AS is_media_26, t0.is_media_required AS is_media_required_27, t0.media_label AS media_label_28, t0.upload_limit AS upload_limit_29, t0.actived_identity_form AS actived_identity_form_30, t0.title AS title_31, t0.confirmation_message AS confirmation_message_32, t0.legend AS legend_33, t0.blog_post_id AS blog_post_id_34 FROM identity_form t0 WHERE t0.blog_post_id = ?
Parameters:
[
  235
]
503.47 ms
(42.90%)
207
SELECT t0.id AS id_1, t0.proposition_1_label AS proposition_1_label_2, t0.proposition_2_label AS proposition_2_label_3, t0.proposition_3_label AS proposition_3_label_4, t0.proposition_4_label AS proposition_4_label_5, t0.proposition_5_label AS proposition_5_label_6, t0.proposition_1_color AS proposition_1_color_7, t0.proposition_2_color AS proposition_2_color_8, t0.proposition_3_color AS proposition_3_color_9, t0.proposition_4_color AS proposition_4_color_10, t0.proposition_5_color AS proposition_5_color_11, t0.result_label AS result_label_12, t0.show_response_buttons AS show_response_buttons_13, t0.show_weighted_result AS show_weighted_result_14, t0.radar_chart_label AS radar_chart_label_15, t0.show_radar_chart AS show_radar_chart_16, t0.result_label2 AS result_label2_17, t0.show_result_label1 AS show_result_label1_18, t0.show_result_label2 AS show_result_label2_19, t0.result_color AS result_color_20, t0.response_retention_days AS response_retention_days_21, t0.section_legends AS section_legends_22, t0.section_legends2 AS section_legends2_23, t0.scoring_legends AS scoring_legends_24, t0.blog_post_id AS blog_post_id_25 FROM scoring_quiz t0 WHERE t0.blog_post_id = ?
Parameters:
[
  235
]
38.15 ms
(3.25%)
10
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_activated AS is_activated_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_featured AS is_featured_8, t0.is_featured_title AS is_featured_title_9, t0.is_public AS is_public_10, t0.position AS position_11, t0.qr_code AS qr_code_12, t0.notification_sent_at AS notification_sent_at_13, t0.is_notify AS is_notify_14, t0.is_scheduled AS is_scheduled_15, t0.activation_date AS activation_date_16, t0.desactivation_date AS desactivation_date_17, t0.has_all_criteria1 AS has_all_criteria1_18, t0.has_all_criteria2 AS has_all_criteria2_19, t0.has_all_criteria3 AS has_all_criteria3_20, t0.identity_field1 AS identity_field1_21, t0.identity_field2 AS identity_field2_22, t0.identity_field3 AS identity_field3_23, t0.identity_field4 AS identity_field4_24, t0.identity_field5 AS identity_field5_25, t0.identity_field6 AS identity_field6_26, t0.identity_field7 AS identity_field7_27, t0.identity_textarea AS identity_textarea_28, t0.identity_media AS identity_media_29, t0.blog_post_category_id AS blog_post_category_id_30, t0.seo_id AS seo_id_31, t0.image_preview_media_id AS image_preview_media_id_32, t0.featuring_image_media_id AS featuring_image_media_id_33, t0.media_id AS media_id_34, t0.preview_video_id AS preview_video_id_35, t0.notification_id AS notification_id_36, t0.preference_id AS preference_id_37, t0.author_id AS author_id_38, t39.id AS id_40, t39.proposition_1_label AS proposition_1_label_41, t39.proposition_2_label AS proposition_2_label_42, t39.proposition_3_label AS proposition_3_label_43, t39.proposition_4_label AS proposition_4_label_44, t39.proposition_5_label AS proposition_5_label_45, t39.proposition_1_color AS proposition_1_color_46, t39.proposition_2_color AS proposition_2_color_47, t39.proposition_3_color AS proposition_3_color_48, t39.proposition_4_color AS proposition_4_color_49, t39.proposition_5_color AS proposition_5_color_50, t39.result_label AS result_label_51, t39.show_response_buttons AS show_response_buttons_52, t39.show_weighted_result AS show_weighted_result_53, t39.radar_chart_label AS radar_chart_label_54, t39.show_radar_chart AS show_radar_chart_55, t39.result_label2 AS result_label2_56, t39.show_result_label1 AS show_result_label1_57, t39.show_result_label2 AS show_result_label2_58, t39.result_color AS result_color_59, t39.response_retention_days AS response_retention_days_60, t39.section_legends AS section_legends_61, t39.section_legends2 AS section_legends2_62, t39.scoring_legends AS scoring_legends_63, t39.blog_post_id AS blog_post_id_64, t65.id AS id_66, t65.is_field1 AS is_field1_67, t65.is_field1_required AS is_field1_required_68, t65.is_field2 AS is_field2_69, t65.is_field2_required AS is_field2_required_70, t65.is_field3 AS is_field3_71, t65.is_field3_required AS is_field3_required_72, t65.is_field4 AS is_field4_73, t65.is_field4_required AS is_field4_required_74, t65.is_field5 AS is_field5_75, t65.is_field5_required AS is_field5_required_76, t65.is_field6 AS is_field6_77, t65.is_field6_required AS is_field6_required_78, t65.is_field7 AS is_field7_79, t65.is_field7_required AS is_field7_required_80, t65.field_label AS field_label_81, t65.field2_label AS field2_label_82, t65.field3_label AS field3_label_83, t65.field4_label AS field4_label_84, t65.field5_label AS field5_label_85, t65.field6_label AS field6_label_86, t65.field7label AS field7label_87, t65.is_textarea AS is_textarea_88, t65.is_textarea_required AS is_textarea_required_89, t65.textarea_label AS textarea_label_90, t65.is_media AS is_media_91, t65.is_media_required AS is_media_required_92, t65.media_label AS media_label_93, t65.upload_limit AS upload_limit_94, t65.actived_identity_form AS actived_identity_form_95, t65.title AS title_96, t65.confirmation_message AS confirmation_message_97, t65.legend AS legend_98, t65.blog_post_id AS blog_post_id_99 FROM blog_post t0 LEFT JOIN scoring_quiz t39 ON t39.blog_post_id = t0.id LEFT JOIN identity_form t65 ON t65.blog_post_id = t0.id WHERE t0.blog_post_category_id = ?
Parameters:
[
  20
]
24.31 ms
(2.07%)
10
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_activated AS is_activated_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.qr_code AS qr_code_8, t0.is_public AS is_public_9, t0.has_all_criteria1 AS has_all_criteria1_10, t0.has_all_criteria2 AS has_all_criteria2_11, t0.has_all_criteria3 AS has_all_criteria3_12, t0.seo_id AS seo_id_13 FROM blog_post_category t0 WHERE t0.id = ?
Parameters:
[
  20
]
12.41 ms
(1.06%)
1
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.is_activated AS is_activated_4, b0_.created_at AS created_at_5, b0_.updated_at AS updated_at_6, b0_.is_featured AS is_featured_7, b0_.is_featured_title AS is_featured_title_8, b0_.is_public AS is_public_9, b0_.position AS position_10, b0_.qr_code AS qr_code_11, b0_.notification_sent_at AS notification_sent_at_12, b0_.is_notify AS is_notify_13, b0_.is_scheduled AS is_scheduled_14, b0_.activation_date AS activation_date_15, b0_.desactivation_date AS desactivation_date_16, b0_.has_all_criteria1 AS has_all_criteria1_17, b0_.has_all_criteria2 AS has_all_criteria2_18, b0_.has_all_criteria3 AS has_all_criteria3_19, b0_.identity_field1 AS identity_field1_20, b0_.identity_field2 AS identity_field2_21, b0_.identity_field3 AS identity_field3_22, b0_.identity_field4 AS identity_field4_23, b0_.identity_field5 AS identity_field5_24, b0_.identity_field6 AS identity_field6_25, b0_.identity_field7 AS identity_field7_26, b0_.identity_textarea AS identity_textarea_27, b0_.identity_media AS identity_media_28, b0_.blog_post_category_id AS blog_post_category_id_29, b0_.seo_id AS seo_id_30, b0_.image_preview_media_id AS image_preview_media_id_31, b0_.featuring_image_media_id AS featuring_image_media_id_32, b0_.media_id AS media_id_33, b0_.preview_video_id AS preview_video_id_34, b0_.notification_id AS notification_id_35, b0_.preference_id AS preference_id_36, b0_.author_id AS author_id_37 FROM blog_post b0_ ORDER BY b0_.position ASC
Parameters:
[]
9.87 ms
(0.84%)
4
SELECT t0.id AS id_1, t0.name AS name_2 FROM criteria1 t0 LIMIT 1
Parameters:
[]
8.88 ms
(0.76%)
4
SELECT t0.id AS id_1, t0.name AS name_2 FROM criteria2 t0 LIMIT 1
Parameters:
[]
8.81 ms
(0.75%)
4
SELECT t0.id AS id_1, t0.name AS name_2 FROM criteria3 t0 LIMIT 1
Parameters:
[]
8.02 ms
(0.68%)
3
SELECT t0.id AS id_1, t0.twitter AS twitter_2, t0.is_shared_twitter AS is_shared_twitter_3, t0.twitter_shared_link AS twitter_shared_link_4, t0.facebook AS facebook_5, t0.is_shared_facebook AS is_shared_facebook_6, t0.facebook_shared_link AS facebook_shared_link_7, t0.instagram AS instagram_8, t0.is_shared_instagram AS is_shared_instagram_9, t0.instagram_shared_link AS instagram_shared_link_10, t0.youtube AS youtube_11, t0.is_shared_youtube AS is_shared_youtube_12, t0.youtube_shared_link AS youtube_shared_link_13, t0.linkedin AS linkedin_14, t0.is_shared_linkedin AS is_shared_linkedin_15, t0.linkedin_shared_link AS linkedin_shared_link_16, t0.tiktok AS tiktok_17, t0.is_shared_tiktok AS is_shared_tiktok_18, t0.tiktok_shared_link AS tiktok_shared_link_19, t0.twitch AS twitch_20, t0.is_shared_twich AS is_shared_twich_21, t0.twitch_shared_link AS twitch_shared_link_22, t0.slogan AS slogan_23, t0.hashtag AS hashtag_24, t0.is_shared AS is_shared_25, t0.updated_at AS updated_at_26, t0.is_shared_email AS is_shared_email_27, t0.email_shared_link AS email_shared_link_28, t0.is_shared_sms AS is_shared_sms_29, t0.sms_shared_link AS sms_shared_link_30, t0.is_shared_whatsapp AS is_shared_whatsapp_31, t0.whatsapp_shared_link AS whatsapp_shared_link_32, t0.edit_shared_link AS edit_shared_link_33, t0.is_shared_messagerie AS is_shared_messagerie_34, t0.messagerie_sharing_label AS messagerie_sharing_label_35 FROM social_network t0 LIMIT 1
Parameters:
[]
4.55 ms
(0.39%)
2
SELECT t0.id AS id_1, t0.menu_background_color AS menu_background_color_2, t0.button_background_color AS button_background_color_3, t0.page_background_color AS page_background_color_4, t0.menu_foreground_color AS menu_foreground_color_5, t0.button_foreground_color AS button_foreground_color_6, t0.page_foreground_color AS page_foreground_color_7, t0.page_title_color AS page_title_color_8 FROM site_customization t0 LIMIT 1
Parameters:
[]
4.44 ms
(0.38%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.phone AS phone_4, t0.iframe_youtube AS iframe_youtube_5, t0.password AS password_6, t0.plain_password AS plain_password_7 FROM maintenance t0 LIMIT 1
Parameters:
[]
4.44 ms
(0.38%)
2
SELECT t0.id AS id_1, t0.terms_of_service AS terms_of_service_2 FROM mention_legal t0 LIMIT 1
Parameters:
[]
4.42 ms
(0.38%)
2
SELECT t0.id AS id_1, t0.message AS message_2, t0.is_activated AS is_activated_3 FROM contact_config t0 LIMIT 1
Parameters:
[]
3.44 ms
(0.29%)
1
"COMMIT"
Parameters:
[]
3.19 ms
(0.27%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_activated AS is_activated_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_featured AS is_featured_8, t0.is_featured_title AS is_featured_title_9, t0.is_public AS is_public_10, t0.position AS position_11, t0.qr_code AS qr_code_12, t0.notification_sent_at AS notification_sent_at_13, t0.is_notify AS is_notify_14, t0.is_scheduled AS is_scheduled_15, t0.activation_date AS activation_date_16, t0.desactivation_date AS desactivation_date_17, t0.has_all_criteria1 AS has_all_criteria1_18, t0.has_all_criteria2 AS has_all_criteria2_19, t0.has_all_criteria3 AS has_all_criteria3_20, t0.identity_field1 AS identity_field1_21, t0.identity_field2 AS identity_field2_22, t0.identity_field3 AS identity_field3_23, t0.identity_field4 AS identity_field4_24, t0.identity_field5 AS identity_field5_25, t0.identity_field6 AS identity_field6_26, t0.identity_field7 AS identity_field7_27, t0.identity_textarea AS identity_textarea_28, t0.identity_media AS identity_media_29, t0.blog_post_category_id AS blog_post_category_id_30, t0.seo_id AS seo_id_31, t0.image_preview_media_id AS image_preview_media_id_32, t0.featuring_image_media_id AS featuring_image_media_id_33, t0.media_id AS media_id_34, t0.preview_video_id AS preview_video_id_35, t0.notification_id AS notification_id_36, t0.preference_id AS preference_id_37, t0.author_id AS author_id_38, t39.id AS id_40, t39.proposition_1_label AS proposition_1_label_41, t39.proposition_2_label AS proposition_2_label_42, t39.proposition_3_label AS proposition_3_label_43, t39.proposition_4_label AS proposition_4_label_44, t39.proposition_5_label AS proposition_5_label_45, t39.proposition_1_color AS proposition_1_color_46, t39.proposition_2_color AS proposition_2_color_47, t39.proposition_3_color AS proposition_3_color_48, t39.proposition_4_color AS proposition_4_color_49, t39.proposition_5_color AS proposition_5_color_50, t39.result_label AS result_label_51, t39.show_response_buttons AS show_response_buttons_52, t39.show_weighted_result AS show_weighted_result_53, t39.radar_chart_label AS radar_chart_label_54, t39.show_radar_chart AS show_radar_chart_55, t39.result_label2 AS result_label2_56, t39.show_result_label1 AS show_result_label1_57, t39.show_result_label2 AS show_result_label2_58, t39.result_color AS result_color_59, t39.response_retention_days AS response_retention_days_60, t39.section_legends AS section_legends_61, t39.section_legends2 AS section_legends2_62, t39.scoring_legends AS scoring_legends_63, t39.blog_post_id AS blog_post_id_64, t65.id AS id_66, t65.is_field1 AS is_field1_67, t65.is_field1_required AS is_field1_required_68, t65.is_field2 AS is_field2_69, t65.is_field2_required AS is_field2_required_70, t65.is_field3 AS is_field3_71, t65.is_field3_required AS is_field3_required_72, t65.is_field4 AS is_field4_73, t65.is_field4_required AS is_field4_required_74, t65.is_field5 AS is_field5_75, t65.is_field5_required AS is_field5_required_76, t65.is_field6 AS is_field6_77, t65.is_field6_required AS is_field6_required_78, t65.is_field7 AS is_field7_79, t65.is_field7_required AS is_field7_required_80, t65.field_label AS field_label_81, t65.field2_label AS field2_label_82, t65.field3_label AS field3_label_83, t65.field4_label AS field4_label_84, t65.field5_label AS field5_label_85, t65.field6_label AS field6_label_86, t65.field7label AS field7label_87, t65.is_textarea AS is_textarea_88, t65.is_textarea_required AS is_textarea_required_89, t65.textarea_label AS textarea_label_90, t65.is_media AS is_media_91, t65.is_media_required AS is_media_required_92, t65.media_label AS media_label_93, t65.upload_limit AS upload_limit_94, t65.actived_identity_form AS actived_identity_form_95, t65.title AS title_96, t65.confirmation_message AS confirmation_message_97, t65.legend AS legend_98, t65.blog_post_id AS blog_post_id_99 FROM blog_post t0 LEFT JOIN scoring_quiz t39 ON t39.blog_post_id = t0.id LEFT JOIN identity_form t65 ON t65.blog_post_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  289
]
2.99 ms
(0.26%)
1
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.user_id AS user_id_3, t0.blog_post_id AS blog_post_id_4 FROM blog_post_history_update t0 WHERE t0.blog_post_id = ?
Parameters:
[
  289
]
2.85 ms
(0.24%)
1
UPDATE user SET firebase_token_generated_at = ? WHERE id = ?
Parameters:
[
  "2026-03-10 15:10:08"
  40
]
2.81 ms
(0.24%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.is_itm_connect AS is_itm_connect_6, t0.refresh_token AS refresh_token_7, t0.token_firebase AS token_firebase_8, t0.accept_cgu AS accept_cgu_9, t0.uuid AS uuid_10, t0.firebase_token_generated_at AS firebase_token_generated_at_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
  40
]
2.66 ms
(0.23%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM roles t0 INNER JOIN blog_post_roles ON t0.id = blog_post_roles.roles_id WHERE blog_post_roles.blog_post_id = ?
Parameters:
[
  289
]
2.61 ms
(0.22%)
1
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.maintenance_mode AS maintenance_mode_3, t0.contact_email AS contact_email_4, t0.admin_email AS admin_email_5, t0.postal_address AS postal_address_6, t0.phone_number AS phone_number_7, t0.logo AS logo_8, t0.favicon AS favicon_9, t0.loc_lat AS loc_lat_10, t0.loc_lon AS loc_lon_11, t0.site_name AS site_name_12, t0.is_account_profile AS is_account_profile_13, t0.is_search_form AS is_search_form_14, t0.is_hamburger_menu AS is_hamburger_menu_15, t0.enable_newsletter AS enable_newsletter_16, t0.copyright AS copyright_17, t0.edit_shared_link AS edit_shared_link_18, t0.actived_itm_connect AS actived_itm_connect_19, t0.actived_view_pdf AS actived_view_pdf_20, t0.actived_notification AS actived_notification_21, t0.actived_contribution AS actived_contribution_22, t0.contact_template_id AS contact_template_id_23, t0.contribution_template_id AS contribution_template_id_24, t0.blog_post_life_time_days AS blog_post_life_time_days_25, t0.blog_post_life_time AS blog_post_life_time_26, t0.is_public_front_office AS is_public_front_office_27, t0.is_tracking_forced AS is_tracking_forced_28, t0.meta_id AS meta_id_29 FROM site_config t0 LIMIT 1
Parameters:
[]
2.59 ms
(0.22%)
1
SELECT t0.id AS id_1, t0.is_captcha AS is_captcha_2, t0.is_field1 AS is_field1_3, t0.is_field1_required AS is_field1_required_4, t0.is_field2 AS is_field2_5, t0.is_field2_required AS is_field2_required_6, t0.is_field3 AS is_field3_7, t0.is_field3_required AS is_field3_required_8, t0.is_field4 AS is_field4_9, t0.is_field4_required AS is_field4_required_10, t0.is_field5 AS is_field5_11, t0.is_field5_required AS is_field5_required_12, t0.is_field6 AS is_field6_13, t0.is_field6_required AS is_field6_required_14, t0.is_field7 AS is_field7_15, t0.is_field7_required AS is_field7_required_16, t0.field_label AS field_label_17, t0.field2_label AS field2_label_18, t0.field3_label AS field3_label_19, t0.field4_label AS field4_label_20, t0.field5_label AS field5_label_21, t0.field6_label AS field6_label_22, t0.field7label AS field7label_23, t0.is_textarea AS is_textarea_24, t0.is_textarea_required AS is_textarea_required_25, t0.textarea_label AS textarea_label_26, t0.is_media AS is_media_27, t0.is_media_required AS is_media_required_28, t0.media_label AS media_label_29, t0.upload_limit AS upload_limit_30, t0.actived_contribution AS actived_contribution_31, t0.title AS title_32, t0.confirmation_message AS confirmation_message_33, t0.legend AS legend_34 FROM contributor_config t0 LIMIT 1
Parameters:
[]
2.25 ms
(0.19%)
1
"START TRANSACTION"
Parameters:
[]
2.23 ms
(0.19%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.updated_at AS updated_at_4 FROM terms_of_use t0 LIMIT 1
Parameters:
[]
2.22 ms
(0.19%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.message AS message_3 FROM page_not_found t0 LIMIT 1
Parameters:
[]
2.16 ms
(0.18%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3 FROM policy t0 LIMIT 1
Parameters:
[]
2.13 ms
(0.18%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3 FROM cookies_policy t0 LIMIT 1
Parameters:
[]

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.