Query Metrics
18
Database Queries
15
Different statements
2.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.49 ms (16.30%) |
3 |
SELECT s0_.role AS role_0, s0_.last_role AS last_role_1, s0_.visibility_in_student_dialogues AS visibility_in_student_dialogues_2, s0_.comment AS comment_3, s0_.last_course_finished_at AS last_course_finished_at_4, s0_.last_active_at AS last_active_at_5, s0_.student_status AS student_status_6, s0_.student_status_changed_at AS student_status_changed_at_7, s0_.webhook_session_end_send AS webhook_session_end_send_8, s0_.use_school_custom_employee_role AS use_school_custom_employee_role_9, s0_.school_custom_employee_role_actions AS school_custom_employee_role_actions_10, s0_.contact_biography AS contact_biography_11, s0_.contact_phone AS contact_phone_12, s0_.contact_vk AS contact_vk_13, s0_.contact_tg AS contact_tg_14, s0_.student_profile_name AS student_profile_name_15, s0_.employee_all_course_access AS employee_all_course_access_16, s0_.sort_student_name AS sort_student_name_17, s0_.id AS id_18, s0_.create_at AS create_at_19, s0_.update_at AS update_at_20, s0_.school_id AS school_id_21, s0_.user_id AS user_id_22, s0_.employee_role_id AS employee_role_id_23, s0_.student_profile_avatar_id AS student_profile_avatar_id_24 FROM school_user s0_ WHERE s0_.school_id = ? AND s0_.user_id = ? AND s0_.role = ? LIMIT 1
Parameters:
[ 50 5907 "ROLE_SCHOOL_OWNER" ] |
|
0.45 ms (15.20%) |
2 |
SELECT t0.email AS email_1, t0.login AS login_2, t0.display_password AS display_password_3, t0.roles AS roles_4, t0.password AS password_5, t0.active AS active_6, t0.last_login AS last_login_7, t0.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_8, t0.name AS name_9, t0.phone AS phone_10, t0.phone_webinar AS phone_webinar_11, t0.city AS city_12, t0.sex AS sex_13, t0.timezone AS timezone_14, t0.about_self AS about_self_15, t0.last_active_at AS last_active_at_16, t0.change_password_token AS change_password_token_17, t0.user_change_password AS user_change_password_18, t0.last_change_email_date AS last_change_email_date_19, t0.unsubscription_email_notify_token AS unsubscription_email_notify_token_20, t0.union_auth_key AS union_auth_key_21, t0.related_services AS related_services_22, t0.id AS id_23, t0.create_at AS create_at_24, t0.update_at AS update_at_25, t0.uuid AS uuid_26, t0.avatar_id AS avatar_id_27, t28.name AS name_29, t28.type AS type_30, t28.mime AS mime_31, t28.bucket AS bucket_32, t28.path AS path_33, t28.dir AS dir_34, t28.size AS size_35, t28.chunked AS chunked_36, t28.chunked_metadata AS chunked_metadata_37, t28.chunked_token AS chunked_token_38, t28.entity_owner_name AS entity_owner_name_39, t28.entity_owner_id AS entity_owner_id_40, t28.kinescope_id AS kinescope_id_41, t28.kinescope_short_id AS kinescope_short_id_42, t28.audio_time AS audio_time_43, t28.audio_average_frequency AS audio_average_frequency_44, t28.multipart_upload_id AS multipart_upload_id_45, t28.restore_information AS restore_information_46, t28.deleted AS deleted_47, t28.deleted_at AS deleted_at_48, t28.path_deleted AS path_deleted_49, t28.id AS id_50, t28.create_at AS create_at_51, t28.update_at AS update_at_52, t28.uuid AS uuid_53, t28.school_id AS school_id_54, t28.lesson_module_file_id AS lesson_module_file_id_55, t28.homework_answer_audio_id AS homework_answer_audio_id_56, t28.question_fail_comment_file_id AS question_fail_comment_file_id_57, t28.question_success_comment_file_id AS question_success_comment_file_id_58, t28.answer_digit_comment_file_id AS answer_digit_comment_file_id_59, t28.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_60, t28.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_61, t28.answer_select_comment_file_id AS answer_select_comment_file_id_62, t28.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_63, t28.answer_comment_file_id AS answer_comment_file_id_64 FROM users t0 LEFT JOIN file t28 ON t0.avatar_id = t28.id WHERE t0.uuid = ? LIMIT 1
Parameters:
[
"d00efc1d-8022-4d38-ac0e-0713420d962e"
]
|
|
0.30 ms (9.99%) |
1 |
SELECT t0_.from_url AS from_url_0, t0_.to_url AS to_url_1, t0_.comment AS comment_2, t0_.use_type AS use_type_3, t0_.id AS id_4, t0_.create_at AS create_at_5, t0_.update_at AS update_at_6, t0_.sort AS sort_7 FROM tilda_page_redirect t0_ WHERE t0_.from_url = ? AND t0_.use_type IN (?, ?) LIMIT 1
Parameters:
[ "/students/courses" "school" "all" ] |
|
0.24 ms (8.09%) |
1 |
SELECT t0.role AS role_1, t0.last_role AS last_role_2, t0.visibility_in_student_dialogues AS visibility_in_student_dialogues_3, t0.comment AS comment_4, t0.last_course_finished_at AS last_course_finished_at_5, t0.last_active_at AS last_active_at_6, t0.student_status AS student_status_7, t0.student_status_changed_at AS student_status_changed_at_8, t0.webhook_session_end_send AS webhook_session_end_send_9, t0.use_school_custom_employee_role AS use_school_custom_employee_role_10, t0.school_custom_employee_role_actions AS school_custom_employee_role_actions_11, t0.contact_biography AS contact_biography_12, t0.contact_phone AS contact_phone_13, t0.contact_vk AS contact_vk_14, t0.contact_tg AS contact_tg_15, t0.student_profile_name AS student_profile_name_16, t0.employee_all_course_access AS employee_all_course_access_17, t0.sort_student_name AS sort_student_name_18, t0.id AS id_19, t0.create_at AS create_at_20, t0.update_at AS update_at_21, t0.school_id AS school_id_22, t23.name AS name_24, t23.default_slug AS default_slug_25, t23.slug AS slug_26, t23.domain AS domain_27, t23.description AS description_28, t23.primary_color AS primary_color_29, t23.balance AS balance_30, t23.amo_company_id AS amo_company_id_31, t23.amo_register_deal_id AS amo_register_deal_id_32, t23.roistat AS roistat_33, t23.tagline AS tagline_34, t23.kinescope_project_id AS kinescope_project_id_35, t23.generate_invite_user_id AS generate_invite_user_id_36, t23.kinescope_player_id AS kinescope_player_id_37, t23.allow_self_register AS allow_self_register_38, t23.confirm_registration_code AS confirm_registration_code_39, t23.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_40, t23.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_41, t23.confirm_registration_finished AS confirm_registration_finished_42, t23.confirm_registration_skipped AS confirm_registration_skipped_43, t23.active AS active_44, t23.storage_size AS storage_size_45, t23.last_storage_size_calculation AS last_storage_size_calculation_46, t23.clear_storage_files AS clear_storage_files_47, t23.cover_dimming AS cover_dimming_48, t23.cover_mobile_dimming AS cover_mobile_dimming_49, t23.mobile_cover_type AS mobile_cover_type_50, t23.disable_clear_storage AS disable_clear_storage_51, t23.id AS id_52, t23.create_at AS create_at_53, t23.update_at AS update_at_54, t23.sort AS sort_55, t23.uuid AS uuid_56, t23.owner_id AS owner_id_57, t23.logo_id AS logo_id_58, t23.favicon_id AS favicon_id_59, t23.avatar_id AS avatar_id_60, t23.cover_id AS cover_id_61, t23.mobile_cover_id AS mobile_cover_id_62, t23.cover_change_id AS cover_change_id_63, t23.plan_id AS plan_id_64, t23.subscription_id AS subscription_id_65, t23.schoolChannel AS schoolChannel_66, t23.schoolGroup AS schoolGroup_67, t23.discount_id AS discount_id_68, t0.user_id AS user_id_69, t70.email AS email_71, t70.login AS login_72, t70.display_password AS display_password_73, t70.roles AS roles_74, t70.password AS password_75, t70.active AS active_76, t70.last_login AS last_login_77, t70.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_78, t70.name AS name_79, t70.phone AS phone_80, t70.phone_webinar AS phone_webinar_81, t70.city AS city_82, t70.sex AS sex_83, t70.timezone AS timezone_84, t70.about_self AS about_self_85, t70.last_active_at AS last_active_at_86, t70.change_password_token AS change_password_token_87, t70.user_change_password AS user_change_password_88, t70.last_change_email_date AS last_change_email_date_89, t70.unsubscription_email_notify_token AS unsubscription_email_notify_token_90, t70.union_auth_key AS union_auth_key_91, t70.related_services AS related_services_92, t70.id AS id_93, t70.create_at AS create_at_94, t70.update_at AS update_at_95, t70.uuid AS uuid_96, t70.avatar_id AS avatar_id_97, t0.employee_role_id AS employee_role_id_98, t0.student_profile_avatar_id AS student_profile_avatar_id_99, t100.name AS name_101, t100.type AS type_102, t100.mime AS mime_103, t100.bucket AS bucket_104, t100.path AS path_105, t100.dir AS dir_106, t100.size AS size_107, t100.chunked AS chunked_108, t100.chunked_metadata AS chunked_metadata_109, t100.chunked_token AS chunked_token_110, t100.entity_owner_name AS entity_owner_name_111, t100.entity_owner_id AS entity_owner_id_112, t100.kinescope_id AS kinescope_id_113, t100.kinescope_short_id AS kinescope_short_id_114, t100.audio_time AS audio_time_115, t100.audio_average_frequency AS audio_average_frequency_116, t100.multipart_upload_id AS multipart_upload_id_117, t100.restore_information AS restore_information_118, t100.deleted AS deleted_119, t100.deleted_at AS deleted_at_120, t100.path_deleted AS path_deleted_121, t100.id AS id_122, t100.create_at AS create_at_123, t100.update_at AS update_at_124, t100.uuid AS uuid_125, t100.school_id AS school_id_126, t100.lesson_module_file_id AS lesson_module_file_id_127, t100.homework_answer_audio_id AS homework_answer_audio_id_128, t100.question_fail_comment_file_id AS question_fail_comment_file_id_129, t100.question_success_comment_file_id AS question_success_comment_file_id_130, t100.answer_digit_comment_file_id AS answer_digit_comment_file_id_131, t100.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_132, t100.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_133, t100.answer_select_comment_file_id AS answer_select_comment_file_id_134, t100.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_135, t100.answer_comment_file_id AS answer_comment_file_id_136 FROM school_user t0 LEFT JOIN schools t23 ON t0.school_id = t23.id LEFT JOIN users t70 ON t0.user_id = t70.id LEFT JOIN file t100 ON t0.student_profile_avatar_id = t100.id WHERE t0.school_id = ? AND t0.user_id = ?
Parameters:
[ 50 5907 ] |
|
0.23 ms (7.78%) |
1 |
SELECT t0.role AS role_1, t0.last_role AS last_role_2, t0.visibility_in_student_dialogues AS visibility_in_student_dialogues_3, t0.comment AS comment_4, t0.last_course_finished_at AS last_course_finished_at_5, t0.last_active_at AS last_active_at_6, t0.student_status AS student_status_7, t0.student_status_changed_at AS student_status_changed_at_8, t0.webhook_session_end_send AS webhook_session_end_send_9, t0.use_school_custom_employee_role AS use_school_custom_employee_role_10, t0.school_custom_employee_role_actions AS school_custom_employee_role_actions_11, t0.contact_biography AS contact_biography_12, t0.contact_phone AS contact_phone_13, t0.contact_vk AS contact_vk_14, t0.contact_tg AS contact_tg_15, t0.student_profile_name AS student_profile_name_16, t0.employee_all_course_access AS employee_all_course_access_17, t0.sort_student_name AS sort_student_name_18, t0.id AS id_19, t0.create_at AS create_at_20, t0.update_at AS update_at_21, t0.school_id AS school_id_22, t23.name AS name_24, t23.default_slug AS default_slug_25, t23.slug AS slug_26, t23.domain AS domain_27, t23.description AS description_28, t23.primary_color AS primary_color_29, t23.balance AS balance_30, t23.amo_company_id AS amo_company_id_31, t23.amo_register_deal_id AS amo_register_deal_id_32, t23.roistat AS roistat_33, t23.tagline AS tagline_34, t23.kinescope_project_id AS kinescope_project_id_35, t23.generate_invite_user_id AS generate_invite_user_id_36, t23.kinescope_player_id AS kinescope_player_id_37, t23.allow_self_register AS allow_self_register_38, t23.confirm_registration_code AS confirm_registration_code_39, t23.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_40, t23.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_41, t23.confirm_registration_finished AS confirm_registration_finished_42, t23.confirm_registration_skipped AS confirm_registration_skipped_43, t23.active AS active_44, t23.storage_size AS storage_size_45, t23.last_storage_size_calculation AS last_storage_size_calculation_46, t23.clear_storage_files AS clear_storage_files_47, t23.cover_dimming AS cover_dimming_48, t23.cover_mobile_dimming AS cover_mobile_dimming_49, t23.mobile_cover_type AS mobile_cover_type_50, t23.disable_clear_storage AS disable_clear_storage_51, t23.id AS id_52, t23.create_at AS create_at_53, t23.update_at AS update_at_54, t23.sort AS sort_55, t23.uuid AS uuid_56, t23.owner_id AS owner_id_57, t23.logo_id AS logo_id_58, t23.favicon_id AS favicon_id_59, t23.avatar_id AS avatar_id_60, t23.cover_id AS cover_id_61, t23.mobile_cover_id AS mobile_cover_id_62, t23.cover_change_id AS cover_change_id_63, t23.plan_id AS plan_id_64, t23.subscription_id AS subscription_id_65, t23.schoolChannel AS schoolChannel_66, t23.schoolGroup AS schoolGroup_67, t23.discount_id AS discount_id_68, t0.user_id AS user_id_69, t70.email AS email_71, t70.login AS login_72, t70.display_password AS display_password_73, t70.roles AS roles_74, t70.password AS password_75, t70.active AS active_76, t70.last_login AS last_login_77, t70.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_78, t70.name AS name_79, t70.phone AS phone_80, t70.phone_webinar AS phone_webinar_81, t70.city AS city_82, t70.sex AS sex_83, t70.timezone AS timezone_84, t70.about_self AS about_self_85, t70.last_active_at AS last_active_at_86, t70.change_password_token AS change_password_token_87, t70.user_change_password AS user_change_password_88, t70.last_change_email_date AS last_change_email_date_89, t70.unsubscription_email_notify_token AS unsubscription_email_notify_token_90, t70.union_auth_key AS union_auth_key_91, t70.related_services AS related_services_92, t70.id AS id_93, t70.create_at AS create_at_94, t70.update_at AS update_at_95, t70.uuid AS uuid_96, t70.avatar_id AS avatar_id_97, t0.employee_role_id AS employee_role_id_98, t0.student_profile_avatar_id AS student_profile_avatar_id_99, t100.name AS name_101, t100.type AS type_102, t100.mime AS mime_103, t100.bucket AS bucket_104, t100.path AS path_105, t100.dir AS dir_106, t100.size AS size_107, t100.chunked AS chunked_108, t100.chunked_metadata AS chunked_metadata_109, t100.chunked_token AS chunked_token_110, t100.entity_owner_name AS entity_owner_name_111, t100.entity_owner_id AS entity_owner_id_112, t100.kinescope_id AS kinescope_id_113, t100.kinescope_short_id AS kinescope_short_id_114, t100.audio_time AS audio_time_115, t100.audio_average_frequency AS audio_average_frequency_116, t100.multipart_upload_id AS multipart_upload_id_117, t100.restore_information AS restore_information_118, t100.deleted AS deleted_119, t100.deleted_at AS deleted_at_120, t100.path_deleted AS path_deleted_121, t100.id AS id_122, t100.create_at AS create_at_123, t100.update_at AS update_at_124, t100.uuid AS uuid_125, t100.school_id AS school_id_126, t100.lesson_module_file_id AS lesson_module_file_id_127, t100.homework_answer_audio_id AS homework_answer_audio_id_128, t100.question_fail_comment_file_id AS question_fail_comment_file_id_129, t100.question_success_comment_file_id AS question_success_comment_file_id_130, t100.answer_digit_comment_file_id AS answer_digit_comment_file_id_131, t100.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_132, t100.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_133, t100.answer_select_comment_file_id AS answer_select_comment_file_id_134, t100.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_135, t100.answer_comment_file_id AS answer_comment_file_id_136 FROM school_user t0 LEFT JOIN schools t23 ON t0.school_id = t23.id LEFT JOIN users t70 ON t0.user_id = t70.id LEFT JOIN file t100 ON t0.student_profile_avatar_id = t100.id WHERE t0.employee_role_id = ?
Parameters:
[
197
]
|
|
0.22 ms (7.32%) |
1 |
SELECT s0_.name AS name_0, s0_.default_slug AS default_slug_1, s0_.slug AS slug_2, s0_.domain AS domain_3, s0_.description AS description_4, s0_.primary_color AS primary_color_5, s0_.balance AS balance_6, s0_.amo_company_id AS amo_company_id_7, s0_.amo_register_deal_id AS amo_register_deal_id_8, s0_.roistat AS roistat_9, s0_.tagline AS tagline_10, s0_.kinescope_project_id AS kinescope_project_id_11, s0_.generate_invite_user_id AS generate_invite_user_id_12, s0_.kinescope_player_id AS kinescope_player_id_13, s0_.allow_self_register AS allow_self_register_14, s0_.confirm_registration_code AS confirm_registration_code_15, s0_.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_16, s0_.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_17, s0_.confirm_registration_finished AS confirm_registration_finished_18, s0_.confirm_registration_skipped AS confirm_registration_skipped_19, s0_.active AS active_20, s0_.storage_size AS storage_size_21, s0_.last_storage_size_calculation AS last_storage_size_calculation_22, s0_.clear_storage_files AS clear_storage_files_23, s0_.cover_dimming AS cover_dimming_24, s0_.cover_mobile_dimming AS cover_mobile_dimming_25, s0_.mobile_cover_type AS mobile_cover_type_26, s0_.disable_clear_storage AS disable_clear_storage_27, s0_.id AS id_28, s0_.create_at AS create_at_29, s0_.update_at AS update_at_30, s0_.sort AS sort_31, s0_.uuid AS uuid_32, s0_.owner_id AS owner_id_33, s0_.logo_id AS logo_id_34, s0_.favicon_id AS favicon_id_35, s0_.avatar_id AS avatar_id_36, s0_.cover_id AS cover_id_37, s0_.mobile_cover_id AS mobile_cover_id_38, s0_.cover_change_id AS cover_change_id_39, s0_.plan_id AS plan_id_40, s0_.subscription_id AS subscription_id_41, s0_.schoolChannel AS schoolChannel_42, s0_.schoolGroup AS schoolGroup_43, s0_.discount_id AS discount_id_44 FROM schools s0_ WHERE s0_.slug = ? OR s0_.default_slug = ? LIMIT 1
Parameters:
[ "963174" "963174" ] |
|
0.19 ms (6.48%) |
1 |
SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.type AS type_6, t0.features_limit AS features_limit_7, t0.delete_at AS delete_at_8, t0.removed AS removed_9, t0.display_plan_page AS display_plan_page_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.sort AS sort_14 FROM subscription_plan_feature t0 INNER JOIN plan_plan_feature ON t0.id = plan_plan_feature.plan_feature_id WHERE plan_plan_feature.plan_id = ? ORDER BY t0.sort ASC
Parameters:
[
1
]
|
|
0.16 ms (5.38%) |
1 |
SELECT t0.completed_tutorials AS completed_tutorials_1, t0.id AS id_2, t0.create_at AS create_at_3, t0.update_at AS update_at_4, t0.user_id AS user_id_5, t6.email AS email_7, t6.login AS login_8, t6.display_password AS display_password_9, t6.roles AS roles_10, t6.password AS password_11, t6.active AS active_12, t6.last_login AS last_login_13, t6.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_14, t6.name AS name_15, t6.phone AS phone_16, t6.phone_webinar AS phone_webinar_17, t6.city AS city_18, t6.sex AS sex_19, t6.timezone AS timezone_20, t6.about_self AS about_self_21, t6.last_active_at AS last_active_at_22, t6.change_password_token AS change_password_token_23, t6.user_change_password AS user_change_password_24, t6.last_change_email_date AS last_change_email_date_25, t6.unsubscription_email_notify_token AS unsubscription_email_notify_token_26, t6.union_auth_key AS union_auth_key_27, t6.related_services AS related_services_28, t6.id AS id_29, t6.create_at AS create_at_30, t6.update_at AS update_at_31, t6.uuid AS uuid_32, t6.avatar_id AS avatar_id_33 FROM onboarding t0 LEFT JOIN users t6 ON t0.user_id = t6.id WHERE t0.user_id = ? LIMIT 1
Parameters:
[
5907
]
|
|
0.15 ms (4.95%) |
1 |
SELECT t0.name AS name_1, t0.type AS type_2, t0.mime AS mime_3, t0.bucket AS bucket_4, t0.path AS path_5, t0.dir AS dir_6, t0.size AS size_7, t0.chunked AS chunked_8, t0.chunked_metadata AS chunked_metadata_9, t0.chunked_token AS chunked_token_10, t0.entity_owner_name AS entity_owner_name_11, t0.entity_owner_id AS entity_owner_id_12, t0.kinescope_id AS kinescope_id_13, t0.kinescope_short_id AS kinescope_short_id_14, t0.audio_time AS audio_time_15, t0.audio_average_frequency AS audio_average_frequency_16, t0.multipart_upload_id AS multipart_upload_id_17, t0.restore_information AS restore_information_18, t0.deleted AS deleted_19, t0.deleted_at AS deleted_at_20, t0.path_deleted AS path_deleted_21, t0.id AS id_22, t0.create_at AS create_at_23, t0.update_at AS update_at_24, t0.uuid AS uuid_25, t0.school_id AS school_id_26, t0.lesson_module_file_id AS lesson_module_file_id_27, t0.homework_answer_audio_id AS homework_answer_audio_id_28, t0.question_fail_comment_file_id AS question_fail_comment_file_id_29, t0.question_success_comment_file_id AS question_success_comment_file_id_30, t0.answer_digit_comment_file_id AS answer_digit_comment_file_id_31, t0.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_32, t0.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_33, t0.answer_select_comment_file_id AS answer_select_comment_file_id_34, t0.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_35, t0.answer_comment_file_id AS answer_comment_file_id_36 FROM file t0 WHERE t0.id IN (?, ?)
Parameters:
[ 24 25 ] |
|
0.14 ms (4.75%) |
1 |
SELECT t0.status AS status_1, t0.reason AS reason_2, t0.ambassador_fio AS ambassador_fio_3, t0.ambassador_birthday AS ambassador_birthday_4, t0.ambassador_phone AS ambassador_phone_5, t0.ambassador_city AS ambassador_city_6, t0.inn AS inn_7, t0.kpp AS kpp_8, t0.name AS name_9, t0.bik AS bik_10, t0.bank_name AS bank_name_11, t0.korschet AS korschet_12, t0.rasschet AS rasschet_13, t0.contact_address AS contact_address_14, t0.contact_phone AS contact_phone_15, t0.contact_email AS contact_email_16, t0.self_employed AS self_employed_17, t0.dont_use_dogovor AS dont_use_dogovor_18, t0.use_default_docs AS use_default_docs_19, t0.ogrn AS ogrn_20, t0.type AS type_21, t0.id AS id_22, t0.create_at AS create_at_23, t0.update_at AS update_at_24, t0.school_id AS school_id_25, t0.politika_id AS politika_id_26, t0.dogovor_id AS dogovor_id_27, t0.personal_consent_id AS personal_consent_id_28 FROM school_requisites t0 WHERE t0.school_id = ? AND t0.status = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[ 50 "approved" ] |
|
0.13 ms (4.51%) |
1 |
SELECT t0.chat_schoolwide_channel AS chat_schoolwide_channel_1, t0.chat_schoolwide_group AS chat_schoolwide_group_2, t0.chat_flow_autocreate_channel AS chat_flow_autocreate_channel_3, t0.chat_flow_autocreate_group AS chat_flow_autocreate_group_4, t0.white_label_hide_logo AS white_label_hide_logo_5, t0.hide_app_links_from_email AS hide_app_links_from_email_6, t0.request_missing_user_data AS request_missing_user_data_7, t0.smtp_enabled AS smtp_enabled_8, t0.smtp_host AS smtp_host_9, t0.smtp_port AS smtp_port_10, t0.smtp_username AS smtp_username_11, t0.smtp_password AS smtp_password_12, t0.smtp_from AS smtp_from_13, t0.close_from_search_engines AS close_from_search_engines_14, t0.close_from_search_engine_custom_domain AS close_from_search_engine_custom_domain_15, t0.custom_css AS custom_css_16, t0.language AS language_17, t0.id AS id_18, t0.create_at AS create_at_19, t0.update_at AS update_at_20, t0.school_id AS school_id_21 FROM school_settings t0 WHERE t0.school_id = ?
Parameters:
[
50
]
|
|
0.08 ms (2.51%) |
1 |
SELECT t0.chat_schoolwide_channel AS chat_schoolwide_channel_1, t0.chat_schoolwide_group AS chat_schoolwide_group_2, t0.chat_flow_autocreate_channel AS chat_flow_autocreate_channel_3, t0.chat_flow_autocreate_group AS chat_flow_autocreate_group_4, t0.white_label_hide_logo AS white_label_hide_logo_5, t0.hide_app_links_from_email AS hide_app_links_from_email_6, t0.request_missing_user_data AS request_missing_user_data_7, t0.smtp_enabled AS smtp_enabled_8, t0.smtp_host AS smtp_host_9, t0.smtp_port AS smtp_port_10, t0.smtp_username AS smtp_username_11, t0.smtp_password AS smtp_password_12, t0.smtp_from AS smtp_from_13, t0.close_from_search_engines AS close_from_search_engines_14, t0.close_from_search_engine_custom_domain AS close_from_search_engine_custom_domain_15, t0.custom_css AS custom_css_16, t0.language AS language_17, t0.id AS id_18, t0.create_at AS create_at_19, t0.update_at AS update_at_20, t0.school_id AS school_id_21 FROM school_settings t0 WHERE t0.school_id = ? LIMIT 1
Parameters:
[
50
]
|
|
0.07 ms (2.47%) |
1 |
SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.price AS price_6, t0.old_price AS old_price_7, t0.price1month AS price1month_8, t0.price3month AS price3month_9, t0.price6month AS price6month_10, t0.price12month AS price12month_11, t0.delete_at AS delete_at_12, t0.removed AS removed_13, t0.period AS period_14, t0.free AS free_15, t0.id AS id_16, t0.create_at AS create_at_17, t0.update_at AS update_at_18, t0.sort AS sort_19 FROM subscription_plan t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.07 ms (2.24%) |
1 |
SELECT t0.start_at AS start_at_1, t0.end_at AS end_at_2, t0.trial_activated AS trial_activated_3, t0.trial_end_at AS trial_end_at_4, t0.recurrent_payment AS recurrent_payment_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.school_id AS school_id_9 FROM subscription_plan_subscription t0 WHERE t0.id = ?
Parameters:
[
39
]
|
|
0.06 ms (2.04%) |
1 |
SELECT t0.name AS name_1, t0.is_owner AS is_owner_2, t0.role AS role_3, t0.icon AS icon_4, t0.actions AS actions_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.active AS active_10, t0.sort AS sort_11, t0.school_id AS school_id_12 FROM school_employee_role t0 WHERE t0.id = ?
Parameters:
[
197
]
|
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.