Query Metrics
471
Database Queries
26
Different statements
1173.69 ms
Query time
0
Invalid entities
Grouped Statements
| 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.