Query Metrics
469
Database Queries
13
Different statements
125.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
31.04 ms (24.74%) |
89 |
SELECT t0.id AS id_2, t0.is_learner AS is_learner_3, t0.is_active AS is_active_4, t0.birth_name AS birth_name_5, t0.birth_at AS birth_at_6, t0.birth_postal_code AS birth_postal_code_7, t0.birth_city AS birth_city_8, t0.birth_country AS birth_country_9, t0.nationality AS nationality_10, t0.rqth AS rqth_11, t0.rqth_details AS rqth_details_12, t0.last_work_qualification_details AS last_work_qualification_details_13, t0.last_work_qualification AS last_work_qualification_14, t0.last_work_status AS last_work_status_15, t0.scholar_level AS scholar_level_16, t0.scholar_diploma AS scholar_diploma_17, t0.scholar_diploma_other AS scholar_diploma_other_18, t0.created_from_import AS created_from_import_19, t0.user_id AS user_id_20, t0.channel_id AS channel_id_21, t0.type, t1.expire_at AS expire_at_22, t1.start_at AS start_at_23, t1.admin_channel_user_type AS admin_channel_user_type_24, t1.displayed_menu AS displayed_menu_25, t1.status AS status_26, t1.activity_status AS activity_status_27, t1.channel_user_role_id AS channel_user_role_id_28, t1.activity_feed_id AS activity_feed_id_29 FROM channel_user_data t0 LEFT JOIN channel_user_data_admin t1 ON t0.id = t1.id WHERE t0.id = ?
Parameters:
[
"9bb229f8-0185-11ef-8e56-0242ac170005"
]
|
|
26.97 ms (21.50%) |
100 |
SELECT c0_.perms AS perms_0, c0_.expire_at AS expire_at_1, c0_.start_at AS start_at_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.id AS id_5, c0_.created_by_id AS created_by_id_6, c0_.updated_by_id AS updated_by_id_7, c0_.channel_user_data_id AS channel_user_data_id_8, c0_.resource_id AS resource_id_9 FROM channel_user_cursus_permissions c0_ WHERE c0_.resource_id = ? AND c0_.channel_user_data_id = ?
Parameters:
[ 27 "10c43b9b-f6cf-428a-bcec-97a21f63ead0" ] |
|
20.79 ms (16.57%) |
95 |
SELECT c0_.perms AS perms_0, c0_.expire_at AS expire_at_1, c0_.start_at AS start_at_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.id AS id_5, c0_.created_by_id AS created_by_id_6, c0_.updated_by_id AS updated_by_id_7, c0_.channel_user_data_id AS channel_user_data_id_8, c0_.resource_id AS resource_id_9 FROM channel_user_session_permissions c0_ WHERE c0_.resource_id = ? AND c0_.channel_user_data_id = ?
Parameters:
[ 48605 "10c43b9b-f6cf-428a-bcec-97a21f63ead0" ] |
|
16.56 ms (13.20%) |
55 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.place_id AS place_id_5, t0.channel_id AS channel_id_6, t7.id AS id_8, t7.start_at AS start_at_9, t7.end_at AS end_at_10, t7.description AS description_11, t7.has_signatures_deactivated AS has_signatures_deactivated_12, t7.has_canal_visible AS has_canal_visible_13, t7.duration_in_center AS duration_in_center_14, t7.duration_in_company AS duration_in_company_15, t7.duration_in_visio AS duration_in_visio_16, t7.duration_in_elearning AS duration_in_elearning_17, t7.duration_in_exam AS duration_in_exam_18, t7.is_notification_enabled AS is_notification_enabled_19, t7.created_from_import AS created_from_import_20, t7.training_id AS training_id_21, t7.group_id AS group_id_22 FROM channel_groups t0 LEFT JOIN channel_sessions t7 ON t7.group_id = t0.id WHERE t0.id = ?
Parameters:
[
"1ed30565-eb1f-603e-85e9-139f37131666"
]
|
|
14.05 ms (11.20%) |
55 |
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.description AS description_4, t0.has_signatures_deactivated AS has_signatures_deactivated_5, t0.has_canal_visible AS has_canal_visible_6, t0.duration_in_center AS duration_in_center_7, t0.duration_in_company AS duration_in_company_8, t0.duration_in_visio AS duration_in_visio_9, t0.duration_in_elearning AS duration_in_elearning_10, t0.duration_in_exam AS duration_in_exam_11, t0.is_notification_enabled AS is_notification_enabled_12, t0.created_from_import AS created_from_import_13, t0.training_id AS training_id_14, t0.group_id AS group_id_15 FROM channel_sessions t0 WHERE t0.id = ?
Parameters:
[
48605
]
|
|
8.39 ms (6.69%) |
48 |
SELECT c0_.perms AS perms_0, c0_.expire_at AS expire_at_1, c0_.start_at AS start_at_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.id AS id_5, c0_.created_by_id AS created_by_id_6, c0_.updated_by_id AS updated_by_id_7, c0_.channel_user_data_id AS channel_user_data_id_8, c0_.resource_id AS resource_id_9 FROM channel_user_training_permissions c0_ WHERE c0_.resource_id = ? AND c0_.channel_user_data_id = ?
Parameters:
[ "f80bcb0f-6022-11e9-a435-0242c0a8d002" "10c43b9b-f6cf-428a-bcec-97a21f63ead0" ] |
|
3.55 ms (2.83%) |
21 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.is_active AS is_active_6, t0.diploma_description AS diploma_description_7, t0.owner_channel_id AS owner_channel_id_8 FROM channel_trainings t0 WHERE t0.id = ?
Parameters:
[
"f80bcb0f-6022-11e9-a435-0242c0a8d002"
]
|
|
2.66 ms (2.12%) |
1 |
SELECT c0_.id AS id_0, c0_.start_at AS start_at_1, c0_.end_at AS end_at_2, c0_.month_duration AS month_duration_3, c0_.physical_duration AS physical_duration_4, c0_.distance_sync_duration AS distance_sync_duration_5, c0_.distance_async_duration AS distance_async_duration_6, c0_.exam_duration AS exam_duration_7, c0_.internship_duration AS internship_duration_8, c0_.cursus_modality AS cursus_modality_9, c0_.cursus_course AS cursus_course_10, c0_.founding_status AS founding_status_11, c0_.internship_status AS internship_status_12, c0_.stopped_status AS stopped_status_13, c0_.stopped_details AS stopped_details_14, c0_.stopped_at AS stopped_at_15, c0_.stopped_infos AS stopped_infos_16, c0_.suspended_at AS suspended_at_17, c0_.suspended_for AS suspended_for_18, c0_.exam_session AS exam_session_19, c0_.exam_ceres AS exam_ceres_20, c0_.exam_status AS exam_status_21, c0_.exam_ccp AS exam_ccp_22, c0_.created_from_import AS created_from_import_23, c0_.created_at AS created_at_24, c0_.updated_at AS updated_at_25, c0_.type AS type_26, c0_.channel_user_data_id AS channel_user_data_id_27, c0_.training_id AS training_id_28, c0_.cursus_progression_id AS cursus_progression_id_29, c0_.organization_id AS organization_id_30, c0_.exam_place_id AS exam_place_id_31, c0_.place_id AS place_id_32, c0_.activity_feed_id AS activity_feed_id_33, c1_.session_id AS session_id_34 FROM channel_user_data_cursus c0_ LEFT JOIN channel_user_data_cursus_session c1_ ON c0_.id = c1_.id LEFT JOIN channel_user_data_cursus_training c2_ ON c0_.id = c2_.id INNER JOIN channel_user_data c3_ ON c0_.channel_user_data_id = c3_.id LEFT JOIN channel_user_data_admin c4_ ON c3_.id = c4_.id WHERE c3_.channel_id = ? AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "e231122f-1f18-11e9-8180-00163e87308f" 11517 11519 11520 11524 11536 11555 11558 11565 11573 11574 11575 11576 11580 11584 11586 11587 11633 11639 11650 11651 11652 11654 11655 11656 11657 11689 11694 11695 11697 11698 11700 11703 11705 11707 11709 11742 273 275 297 582 266 583 303 117 278 284 584 585 285 287 593 289 542 267 594 596 291 597 599 292 601 604 293 605 295 262 268 606 586 182 236 191 192 167 219 7259 7308 168 51 239 839 2021 7929 7930 230 193 237 183 464 758 571 759 181 212 130 258 169 27 184 170 ] |
|
0.34 ms (0.27%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.password_token AS password_token_6, t0.password_token_at AS password_token_at_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone_number AS phone_number_10, t0.description AS description_11, t0.role_description AS role_description_12, t0.avatar AS avatar_13, t0.avatar_path AS avatar_path_14, t0.gender AS gender_15, t0.birth_at AS birth_at_16, t0.is_verified AS is_verified_17, t0.signing_limit_date AS signing_limit_date_18, t0.last_connected_at AS last_connected_at_19, t0.shown_alert AS shown_alert_20, t0.created_from_import AS created_from_import_21, t0.address_street AS address_street_22, t0.address_post_code AS address_post_code_23, t0.address_city AS address_city_24, t0.address_country AS address_country_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t28.id AS id_29, t28.created_at AS created_at_30, t28.user_id AS user_id_31, t28.channel_id AS channel_id_32, t28.created_by_id AS created_by_id_33, t0.contact_id AS contact_id_34, t0.created_by_id AS created_by_id_35, t36.id AS id_37, t36.email AS email_38, t36.roles AS roles_39, t36.password AS password_40, t36.enabled AS enabled_41, t36.password_token AS password_token_42, t36.password_token_at AS password_token_at_43, t36.first_name AS first_name_44, t36.last_name AS last_name_45, t36.phone_number AS phone_number_46, t36.description AS description_47, t36.role_description AS role_description_48, t36.avatar AS avatar_49, t36.avatar_path AS avatar_path_50, t36.gender AS gender_51, t36.birth_at AS birth_at_52, t36.is_verified AS is_verified_53, t36.signing_limit_date AS signing_limit_date_54, t36.last_connected_at AS last_connected_at_55, t36.shown_alert AS shown_alert_56, t36.created_from_import AS created_from_import_57, t36.address_street AS address_street_58, t36.address_post_code AS address_post_code_59, t36.address_city AS address_city_60, t36.address_country AS address_country_61, t36.created_at AS created_at_62, t36.updated_at AS updated_at_63, t36.contact_id AS contact_id_64, t36.created_by_id AS created_by_id_65, t36.updated_by_id AS updated_by_id_66, t0.updated_by_id AS updated_by_id_67, t68.id AS id_69, t68.email AS email_70, t68.roles AS roles_71, t68.password AS password_72, t68.enabled AS enabled_73, t68.password_token AS password_token_74, t68.password_token_at AS password_token_at_75, t68.first_name AS first_name_76, t68.last_name AS last_name_77, t68.phone_number AS phone_number_78, t68.description AS description_79, t68.role_description AS role_description_80, t68.avatar AS avatar_81, t68.avatar_path AS avatar_path_82, t68.gender AS gender_83, t68.birth_at AS birth_at_84, t68.is_verified AS is_verified_85, t68.signing_limit_date AS signing_limit_date_86, t68.last_connected_at AS last_connected_at_87, t68.shown_alert AS shown_alert_88, t68.created_from_import AS created_from_import_89, t68.address_street AS address_street_90, t68.address_post_code AS address_post_code_91, t68.address_city AS address_city_92, t68.address_country AS address_country_93, t68.created_at AS created_at_94, t68.updated_at AS updated_at_95, t68.contact_id AS contact_id_96, t68.created_by_id AS created_by_id_97, t68.updated_by_id AS updated_by_id_98 FROM account_users t0 LEFT JOIN channel_user_from_channels t28 ON t28.user_id = t0.id LEFT JOIN account_users t36 ON t0.created_by_id = t36.id LEFT JOIN account_users t68 ON t0.updated_by_id = t68.id WHERE t0.id = ?
Parameters:
[
"020562ea-5430-4db5-87c7-429c6918d20b"
]
|
|
0.32 ms (0.25%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.password_token AS password_token_6, t0.password_token_at AS password_token_at_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone_number AS phone_number_10, t0.description AS description_11, t0.role_description AS role_description_12, t0.avatar AS avatar_13, t0.avatar_path AS avatar_path_14, t0.gender AS gender_15, t0.birth_at AS birth_at_16, t0.is_verified AS is_verified_17, t0.signing_limit_date AS signing_limit_date_18, t0.last_connected_at AS last_connected_at_19, t0.shown_alert AS shown_alert_20, t0.created_from_import AS created_from_import_21, t0.address_street AS address_street_22, t0.address_post_code AS address_post_code_23, t0.address_city AS address_city_24, t0.address_country AS address_country_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t28.id AS id_29, t28.created_at AS created_at_30, t28.user_id AS user_id_31, t28.channel_id AS channel_id_32, t28.created_by_id AS created_by_id_33, t0.contact_id AS contact_id_34, t0.created_by_id AS created_by_id_35, t36.id AS id_37, t36.email AS email_38, t36.roles AS roles_39, t36.password AS password_40, t36.enabled AS enabled_41, t36.password_token AS password_token_42, t36.password_token_at AS password_token_at_43, t36.first_name AS first_name_44, t36.last_name AS last_name_45, t36.phone_number AS phone_number_46, t36.description AS description_47, t36.role_description AS role_description_48, t36.avatar AS avatar_49, t36.avatar_path AS avatar_path_50, t36.gender AS gender_51, t36.birth_at AS birth_at_52, t36.is_verified AS is_verified_53, t36.signing_limit_date AS signing_limit_date_54, t36.last_connected_at AS last_connected_at_55, t36.shown_alert AS shown_alert_56, t36.created_from_import AS created_from_import_57, t36.address_street AS address_street_58, t36.address_post_code AS address_post_code_59, t36.address_city AS address_city_60, t36.address_country AS address_country_61, t36.created_at AS created_at_62, t36.updated_at AS updated_at_63, t36.contact_id AS contact_id_64, t36.created_by_id AS created_by_id_65, t36.updated_by_id AS updated_by_id_66, t0.updated_by_id AS updated_by_id_67, t68.id AS id_69, t68.email AS email_70, t68.roles AS roles_71, t68.password AS password_72, t68.enabled AS enabled_73, t68.password_token AS password_token_74, t68.password_token_at AS password_token_at_75, t68.first_name AS first_name_76, t68.last_name AS last_name_77, t68.phone_number AS phone_number_78, t68.description AS description_79, t68.role_description AS role_description_80, t68.avatar AS avatar_81, t68.avatar_path AS avatar_path_82, t68.gender AS gender_83, t68.birth_at AS birth_at_84, t68.is_verified AS is_verified_85, t68.signing_limit_date AS signing_limit_date_86, t68.last_connected_at AS last_connected_at_87, t68.shown_alert AS shown_alert_88, t68.created_from_import AS created_from_import_89, t68.address_street AS address_street_90, t68.address_post_code AS address_post_code_91, t68.address_city AS address_city_92, t68.address_country AS address_country_93, t68.created_at AS created_at_94, t68.updated_at AS updated_at_95, t68.contact_id AS contact_id_96, t68.created_by_id AS created_by_id_97, t68.updated_by_id AS updated_by_id_98 FROM account_users t0 LEFT JOIN channel_user_from_channels t28 ON t28.user_id = t0.id LEFT JOIN account_users t36 ON t0.created_by_id = t36.id LEFT JOIN account_users t68 ON t0.updated_by_id = t68.id WHERE t0.id IN (?)
Parameters:
[
"bf18b698-519e-11ea-914c-0242ac150002"
]
|
|
0.30 ms (0.24%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.website AS website_4, t0.phone_number AS phone_number_5, t0.approved AS approved_6, t0.can_share_content AS can_share_content_7, t0.image_path AS image_path_8, t0.payment_alert AS payment_alert_9, t0.sepa_mandate AS sepa_mandate_10, t0.tva AS tva_11, t0.payment_status AS payment_status_12, t0.status AS status_13, t0.enabled_indexing AS enabled_indexing_14, t0.enabled_chat_bot AS enabled_chat_bot_15, t0.tua_proposal AS tua_proposal_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.owner_id AS owner_id_19, t20.id AS id_21, t20.domain AS domain_22, t20.channel_id AS channel_id_23, t0.channel_google_drive_folder_id AS channel_google_drive_folder_id_24, t0.configuration_id AS configuration_id_25, t0.created_by_id AS created_by_id_26, t27.id AS id_28, t27.email AS email_29, t27.roles AS roles_30, t27.password AS password_31, t27.enabled AS enabled_32, t27.password_token AS password_token_33, t27.password_token_at AS password_token_at_34, t27.first_name AS first_name_35, t27.last_name AS last_name_36, t27.phone_number AS phone_number_37, t27.description AS description_38, t27.role_description AS role_description_39, t27.avatar AS avatar_40, t27.avatar_path AS avatar_path_41, t27.gender AS gender_42, t27.birth_at AS birth_at_43, t27.is_verified AS is_verified_44, t27.signing_limit_date AS signing_limit_date_45, t27.last_connected_at AS last_connected_at_46, t27.shown_alert AS shown_alert_47, t27.created_from_import AS created_from_import_48, t27.address_street AS address_street_49, t27.address_post_code AS address_post_code_50, t27.address_city AS address_city_51, t27.address_country AS address_country_52, t27.created_at AS created_at_53, t27.updated_at AS updated_at_54, t27.contact_id AS contact_id_55, t27.created_by_id AS created_by_id_56, t27.updated_by_id AS updated_by_id_57, t0.updated_by_id AS updated_by_id_58, t59.id AS id_60, t59.email AS email_61, t59.roles AS roles_62, t59.password AS password_63, t59.enabled AS enabled_64, t59.password_token AS password_token_65, t59.password_token_at AS password_token_at_66, t59.first_name AS first_name_67, t59.last_name AS last_name_68, t59.phone_number AS phone_number_69, t59.description AS description_70, t59.role_description AS role_description_71, t59.avatar AS avatar_72, t59.avatar_path AS avatar_path_73, t59.gender AS gender_74, t59.birth_at AS birth_at_75, t59.is_verified AS is_verified_76, t59.signing_limit_date AS signing_limit_date_77, t59.last_connected_at AS last_connected_at_78, t59.shown_alert AS shown_alert_79, t59.created_from_import AS created_from_import_80, t59.address_street AS address_street_81, t59.address_post_code AS address_post_code_82, t59.address_city AS address_city_83, t59.address_country AS address_country_84, t59.created_at AS created_at_85, t59.updated_at AS updated_at_86, t59.contact_id AS contact_id_87, t59.created_by_id AS created_by_id_88, t59.updated_by_id AS updated_by_id_89 FROM channel_channels t0 LEFT JOIN channel_white_label t20 ON t20.channel_id = t0.id LEFT JOIN account_users t27 ON t0.created_by_id = t27.id LEFT JOIN account_users t59 ON t0.updated_by_id = t59.id WHERE t0.id = ?
Parameters:
[
"e231122f-1f18-11e9-8180-00163e87308f"
]
|
|
0.25 ms (0.20%) |
1 |
SELECT t0.id AS id_2, t0.is_learner AS is_learner_3, t0.is_active AS is_active_4, t0.birth_name AS birth_name_5, t0.birth_at AS birth_at_6, t0.birth_postal_code AS birth_postal_code_7, t0.birth_city AS birth_city_8, t0.birth_country AS birth_country_9, t0.nationality AS nationality_10, t0.rqth AS rqth_11, t0.rqth_details AS rqth_details_12, t0.last_work_qualification_details AS last_work_qualification_details_13, t0.last_work_qualification AS last_work_qualification_14, t0.last_work_status AS last_work_status_15, t0.scholar_level AS scholar_level_16, t0.scholar_diploma AS scholar_diploma_17, t0.scholar_diploma_other AS scholar_diploma_other_18, t0.created_from_import AS created_from_import_19, t0.user_id AS user_id_20, t0.channel_id AS channel_id_21, t0.type, t1.expire_at AS expire_at_22, t1.start_at AS start_at_23, t1.admin_channel_user_type AS admin_channel_user_type_24, t1.displayed_menu AS displayed_menu_25, t1.status AS status_26, t1.activity_status AS activity_status_27, t1.channel_user_role_id AS channel_user_role_id_28, t1.activity_feed_id AS activity_feed_id_29 FROM channel_user_data t0 LEFT JOIN channel_user_data_admin t1 ON t0.id = t1.id WHERE t0.user_id = ?
Parameters:
[
"020562ea-5430-4db5-87c7-429c6918d20b"
]
|
|
0.24 ms (0.19%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.channel_id AS channel_id_4, t0.created_by_id AS created_by_id_5, t6.id AS id_7, t6.email AS email_8, t6.roles AS roles_9, t6.password AS password_10, t6.enabled AS enabled_11, t6.password_token AS password_token_12, t6.password_token_at AS password_token_at_13, t6.first_name AS first_name_14, t6.last_name AS last_name_15, t6.phone_number AS phone_number_16, t6.description AS description_17, t6.role_description AS role_description_18, t6.avatar AS avatar_19, t6.avatar_path AS avatar_path_20, t6.gender AS gender_21, t6.birth_at AS birth_at_22, t6.is_verified AS is_verified_23, t6.signing_limit_date AS signing_limit_date_24, t6.last_connected_at AS last_connected_at_25, t6.shown_alert AS shown_alert_26, t6.created_from_import AS created_from_import_27, t6.address_street AS address_street_28, t6.address_post_code AS address_post_code_29, t6.address_city AS address_city_30, t6.address_country AS address_country_31, t6.created_at AS created_at_32, t6.updated_at AS updated_at_33, t6.contact_id AS contact_id_34, t6.created_by_id AS created_by_id_35, t6.updated_by_id AS updated_by_id_36 FROM channel_user_from_channels t0 LEFT JOIN account_users t6 ON t0.created_by_id = t6.id WHERE t0.user_id = ?
Parameters:
[
"1efd70bc-0195-661a-9f5b-5bd4f8d72253"
]
|
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.