Query Metrics
189
Database Queries
11
Different statements
319.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
120.06 ms (37.55%) |
1 |
SELECT count(g0_.id) AS sclr_0 FROM guardian g0_ WHERE g0_.is_deleted = 0 ORDER BY g0_.date_add DESC
Parameters:
[] |
|
102.19 ms (31.96%) |
26 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.fullname AS fullname_5, t0.phone_number AS phone_number_6, t0.university AS university_7, t0.work_start AS work_start_8, t0.work_end AS work_end_9, t0.max_load AS max_load_10, t0.available AS available_11, t0.status AS status_12, t0.individual_number AS individual_number_13, t0.profile_image_path AS profile_image_path_14, t0.date_add AS date_add_15, t0.classes AS classes_16, t0.payment_status AS payment_status_17, t0.account_number AS account_number_18, t0.comment AS comment_19, t0.short_name AS short_name_20, t0.summer AS summer_21, t0.show_survey AS show_survey_22, t0.short_description AS short_description_23, t0.discord_name AS discord_name_24, t0.block_next_day_lessons_reminders AS block_next_day_lessons_reminders_25, t0.block_today_lessons_reminders AS block_today_lessons_reminders_26, t0.worked_hours AS worked_hours_27, t0.worked_hours_march AS worked_hours_march_28, t0.level_name AS level_name_29, t0.lessons_missed AS lessons_missed_30, t0.warning_date AS warning_date_31, t0.flag_ru AS flag_ru_32, t0.flag_pl AS flag_pl_33, t0.flag_eng AS flag_eng_34, t0.flag_ib AS flag_ib_35, t0.flag_dyslexia AS flag_dyslexia_36, t0.flag_sensitive AS flag_sensitive_37, t0.flag_trial AS flag_trial_38, t0.extra_load AS extra_load_39, t0.admin_comment AS admin_comment_40, t0.education_stage AS education_stage_41, t0.lc_from AS lc_from_42, t0.contract_terminate_reason AS contract_terminate_reason_43, t0.contract_terminate_fee AS contract_terminate_fee_44, t0.contract_terminate_fee_paid AS contract_terminate_fee_paid_45, t0.unicko_function AS unicko_function_46, t0.birthday AS birthday_47, t0.individual_work_file_path AS individual_work_file_path_48, t0.country AS country_49, t0.summer_time AS summer_time_50, t0.study_field AS study_field_51, t0.congratulated_birthday AS congratulated_birthday_52, t0.google_refresh_token AS google_refresh_token_53, t0.google_access_token AS google_access_token_54, t0.threema_password AS threema_password_55, t0.threema_id AS threema_id_56, t0.threema_status AS threema_status_57, t0.threema_group AS threema_group_58, t0.threema_invite_last_sent_at AS threema_invite_last_sent_at_59, t0.training_started AS training_started_60, t0.training_ended AS training_ended_61, t0.referral_code AS referral_code_62, t0.school AS school_63, t0.ielts AS ielts_64, t0.personal_identification_number AS personal_identification_number_65, t0.flag_web AS flag_web_66, t0.flag_strict AS flag_strict_67, t0.gender AS gender_68, t0.flag_experience_at_school AS flag_experience_at_school_69, t0.flag_priority_assignment AS flag_priority_assignment_70, t0.new_contract_marksign_url AS new_contract_marksign_url_71, t0.new_cotract_signed AS new_cotract_signed_72, t0.new_contract_marksign_document_id AS new_contract_marksign_document_id_73, t0.new_contract_signed_url AS new_contract_signed_url_74, t0.new_contract_type AS new_contract_type_75, t0.summer_at AS summer_at_76, t0.flag_only_ib AS flag_only_ib_77, t0.flag_auto_accept_assignment AS flag_auto_accept_assignment_78, t0.gap_between_assignments AS gap_between_assignments_79, t0.flag_auto_accept_assignment_teacher AS flag_auto_accept_assignment_teacher_80, t0.gap_between_assignments_teacher AS gap_between_assignments_teacher_81, t0.gap_between_assignments_submitted_at AS gap_between_assignments_submitted_at_82, t0.chat_stream_token AS chat_stream_token_83, t0.max_load_changed_at AS max_load_changed_at_84, t0.mobile_app_last_used_at AS mobile_app_last_used_at_85, t86.id AS id_87, t86.name AS name_88, t86.lastname AS lastname_89, t86.email AS email_90, t86.phone AS phone_91, t86.education AS education_92, t86.university AS university_93, t86.study_field AS study_field_94, t86.referral AS referral_95, t86.about AS about_96, t86.flag_ib AS flag_ib_97, t86.university_other AS university_other_98, t86.referral_other AS referral_other_99, t86.additional_languages AS additional_languages_100, t86.status AS status_101, t86.created_at AS created_at_102, t86.edited_at AS edited_at_103, t86.admin_comment AS admin_comment_104, t86.cancel_token AS cancel_token_105, t86.tutor_cancel_reason AS tutor_cancel_reason_106, t86.not_interested_at AS not_interested_at_107, t86.cancel_by AS cancel_by_108, t86.previous_status AS previous_status_109, t86.calendly_metting_url AS calendly_metting_url_110, t86.calendly_uuid AS calendly_uuid_111, t86.date_interview AS date_interview_112, t86.date_acceptable AS date_acceptable_113, t86.participated AS participated_114, t86.max_load AS max_load_115, t86.documents_token AS documents_token_116, t86.sign AS sign_117, t86.contract_token AS contract_token_118, t86.contract_generated_at AS contract_generated_at_119, t86.marksign_url AS marksign_url_120, t86.marksign_document_id AS marksign_document_id_121, t86.signed_contract_url AS signed_contract_url_122, t86.contract_signed_at AS contract_signed_at_123, t86.profile_submitted AS profile_submitted_124, t86.profile_accepted AS profile_accepted_125, t86.test_percent AS test_percent_126, t86.documents_submitted AS documents_submitted_127, t86.consent AS consent_128, t86.referral_bonus_used AS referral_bonus_used_129, t86.ielts AS ielts_130, t86.not_done_tests AS not_done_tests_131, t86.done_tests AS done_tests_132, t86.google_session_id AS google_session_id_133, t86.google_client_id AS google_client_id_134, t86.ad AS ad_135, t86.referer AS referer_136, t86.referer_category AS referer_category_137, t86.utm_source AS utm_source_138, t86.utm_medium AS utm_medium_139, t86.utm_campaign AS utm_campaign_140, t86.landing_page AS landing_page_141, t86.flag_ru AS flag_ru_142, t86.flag_pl AS flag_pl_143, t86.flag_eng AS flag_eng_144, t86.flag_dyslexia AS flag_dyslexia_145, t86.flag_sensitive AS flag_sensitive_146, t86.flag_strict AS flag_strict_147, t86.gender AS gender_148, t86.flag_experience_at_school AS flag_experience_at_school_149, t86.last_edited_by_id AS last_edited_by_id_150, t86.hr_person_id AS hr_person_id_151, t86.teacher_id AS teacher_id_152, t86.teacher_contract_id AS teacher_contract_id_153, t154.id AS id_155, t154.flag_ru AS flag_ru_156, t154.flag_pl AS flag_pl_157, t154.flag_eng AS flag_eng_158, t154.flag_ib AS flag_ib_159, t154.flag_dyslexia AS flag_dyslexia_160, t154.flag_sensitive AS flag_sensitive_161, t154.ielts AS ielts_162, t154.flag_strict AS flag_strict_163, t154.gender AS gender_164, t154.flag_experience_at_school AS flag_experience_at_school_165, t154.flag_economy AS flag_economy_166, t154.teacher_id AS teacher_id_167, t168.id AS id_169, t168.checked AS checked_170, t168.document_path AS document_path_171, t168.uploaded_at AS uploaded_at_172, t168.updated_at AS updated_at_173, t168.comment AS comment_174, t168.notification_level AS notification_level_175, t168.notified_at AS notified_at_176, t168.teacher_id AS teacher_id_177 FROM teacher t0 LEFT JOIN teacher_register t86 ON t86.teacher_id = t0.id LEFT JOIN teacher_preference t154 ON t154.teacher_id = t0.id LEFT JOIN teacher_qrcode t168 ON t168.teacher_id = t0.id WHERE t0.id = ?
Parameters:
[
2074
]
|
|
15.66 ms (4.90%) |
26 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.comment AS comment_3, t0.fitting_times AS fitting_times_4, t0.fitting_times_priority AS fitting_times_priority_5, t0.email_duration AS email_duration_6, t0.single_email_duration AS single_email_duration_7, t0.start_time AS start_time_8, t0.end_time AS end_time_9, t0.created_at AS created_at_10, t0.status AS status_11, t0.assigned_at AS assigned_at_12, t0.decline_reason AS decline_reason_13, t0.teacher_change AS teacher_change_14, t0.terminate_reason AS terminate_reason_15, t0.teacher_assign_remind_count AS teacher_assign_remind_count_16, t0.accepted_at AS accepted_at_17, t0.todo_at AS todo_at_18, t0.admin_comment AS admin_comment_19, t0.assigned_from AS assigned_from_20, t0.marked_ending_by_teacher AS marked_ending_by_teacher_21, t0.marked_ending_by_teacher_date AS marked_ending_by_teacher_date_22, t0.edited_by_teacher_at AS edited_by_teacher_at_23, t0.tutor_terminate_comment AS tutor_terminate_comment_24, t0.action AS action_25, t0.sub_action AS sub_action_26, t0.action_at AS action_at_27, t0.keep_previous_tutor AS keep_previous_tutor_28, t0.assigned_automaticly AS assigned_automaticly_29, t0.flag_manual_assignment AS flag_manual_assignment_30, t0.discipline_id AS discipline_id_31, t0.teacher_id AS teacher_id_32, t0.child_id AS child_id_33, t0.admin_user_id AS admin_user_id_34 FROM child_preference t0 WHERE t0.child_id = ?
Parameters:
[
17265
]
|
|
15.14 ms (4.74%) |
25 |
SELECT t0.id AS id_1, t0.fullname AS fullname_2, t0.class AS class_3, t0.birth_date AS birth_date_4, t0.lessons_end AS lessons_end_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.profile_image_path AS profile_image_path_9, t0.phone_number AS phone_number_10, t0.lastname AS lastname_11, t0.fitting_times AS fitting_times_12, t0.fitting_times_priority AS fitting_times_priority_13, t0.username AS username_14, t0.next_day_email_lessons_reminders_guardian AS next_day_email_lessons_reminders_guardian_15, t0.next_day_email_lessons_reminders_child AS next_day_email_lessons_reminders_child_16, t0.today_smslessons_reminders_guardian AS today_smslessons_reminders_guardian_17, t0.today_smslessons_reminders_child AS today_smslessons_reminders_child_18, t0.password_sent_at AS password_sent_at_19, t0.show_email_modal AS show_email_modal_20, t0.login_token AS login_token_21, t0.google_refresh_token AS google_refresh_token_22, t0.google_access_token AS google_access_token_23, t0.flag_ru AS flag_ru_24, t0.flag_pl AS flag_pl_25, t0.flag_eng AS flag_eng_26, t0.flag_ib AS flag_ib_27, t0.flag_dyslexia AS flag_dyslexia_28, t0.flag_sensitive AS flag_sensitive_29, t0.school AS school_30, t0.flag_strict AS flag_strict_31, t0.gender AS gender_32, t0.flag_experience_at_school AS flag_experience_at_school_33, t0.flag_ielts AS flag_ielts_34, t0.vbe_over90 AS vbe_over90_35, t0.experience_over12_month AS experience_over12_month_36, t0.tutor_comment AS tutor_comment_37, t0.chat_stream_token AS chat_stream_token_38, t0.mobile_app_last_used_at AS mobile_app_last_used_at_39, t0.guardian_id AS guardian_id_40 FROM child t0 WHERE t0.guardian_id = ?
Parameters:
[
15763
]
|
|
14.90 ms (4.66%) |
25 |
SELECT t0.id AS id_1, t0.is_guardian AS is_guardian_2, t0.email AS email_3, t0.name AS name_4, t0.lastname AS lastname_5, t0.phone AS phone_6, t0.guardian_name AS guardian_name_7, t0.guardian_lastname AS guardian_lastname_8, t0.guardian_phone AS guardian_phone_9, t0.guardian_email AS guardian_email_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.ignored_email_count AS ignored_email_count_13, t0.sign AS sign_14, t0.contract_token AS contract_token_15, t0.cancel_token AS cancel_token_16, t0.contract_generated_at AS contract_generated_at_17, t0.marksign_url AS marksign_url_18, t0.marksign_document_id AS marksign_document_id_19, t0.contract_email_count AS contract_email_count_20, t0.signed_contract_url AS signed_contract_url_21, t0.price_change AS price_change_22, t0.current_guardian_found_by AS current_guardian_found_by_23, t0.sales_assigned_at AS sales_assigned_at_24, t0.contract_sent_at AS contract_sent_at_25, t0.contract_signed_at AS contract_signed_at_26, t0.comment AS comment_27, t0.recall_at AS recall_at_28, t0.lost_at AS lost_at_29, t0.ignored_at AS ignored_at_30, t0.is_deleted AS is_deleted_31, t0.flag_trial AS flag_trial_32, t0.guardian_price_discount AS guardian_price_discount_33, t0.referral_code AS referral_code_34, t0.referral_bonus_used AS referral_bonus_used_35, t0.google_session_id AS google_session_id_36, t0.google_client_id AS google_client_id_37, t0.ad AS ad_38, t0.referer AS referer_39, t0.referer_category AS referer_category_40, t0.utm_source AS utm_source_41, t0.utm_medium AS utm_medium_42, t0.utm_campaign AS utm_campaign_43, t0.landing_page AS landing_page_44, t0.flag_manual_assignment AS flag_manual_assignment_45, t0.flag_early_payment AS flag_early_payment_46, t0.early_payment_day AS early_payment_day_47, t0.early_payment_token AS early_payment_token_48, t0.early_payment_token_valid_to AS early_payment_token_valid_to_49, t0.early_payment_sent_at AS early_payment_sent_at_50, t0.data AS data_51, t0.sales_person_id AS sales_person_id_52, t0.guardian_id AS guardian_id_53, t0.guardian_contract_id AS guardian_contract_id_54 FROM guardian_register t0 WHERE t0.guardian_id = ?
Parameters:
[
15763
]
|
|
13.66 ms (4.27%) |
25 |
SELECT t0.id AS id_1, t0.date_for AS date_for_2, t0.hours AS hours_3, t0.amount AS amount_4, t0.payment_id AS payment_id_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7, t0.status AS status_8, t0.expected_amount AS expected_amount_9, t0.kevin_status AS kevin_status_10, t0.notification_status AS notification_status_11, t0.correction_amount AS correction_amount_12, t0.paid_at AS paid_at_13, t0.montonio_status AS montonio_status_14, t0.guardian_id AS guardian_id_15 FROM payment t0 WHERE t0.guardian_id = ? ORDER BY t0.date_for DESC LIMIT 1
Parameters:
[
15763
]
|
|
13.35 ms (4.17%) |
28 |
SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.weekday AS weekday_4, t0.created_at AS created_at_5, t0.child_preference_id AS child_preference_id_6 FROM child_preference_time t0 WHERE t0.child_preference_id = ?
Parameters:
[
51917
]
|
|
11.95 ms (3.74%) |
25 |
SELECT t0.id AS id_1, t0.lesson1_date AS lesson1_date_2, t0.lesson3_date AS lesson3_date_3, t0.lesson1_response AS lesson1_response_4, t0.lesson3_response AS lesson3_response_5, t0.lesson1_response_date AS lesson1_response_date_6, t0.lesson3_response_date AS lesson3_response_date_7, t0.comment AS comment_8, t0.lesson_reminder_date AS lesson_reminder_date_9, t0.lesson1_reminders_quantity AS lesson1_reminders_quantity_10, t0.lesson3_reminders_quantity AS lesson3_reminders_quantity_11, t0.guardian_id AS guardian_id_12, t0.lesson1_admin_responsed_id AS lesson1_admin_responsed_id_13, t0.lesson3_admin_responsed_id AS lesson3_admin_responsed_id_14 FROM guardian_smsresponse t0 WHERE t0.guardian_id = ?
Parameters:
[
15763
]
|
|
9.46 ms (2.96%) |
1 |
SELECT g0_.id AS id_0, g0_.fullname AS fullname_1, g0_.email AS email_2, g0_.roles AS roles_3, g0_.password AS password_4, g0_.phone_number AS phone_number_5, g0_.comment AS comment_6, g0_.details AS details_7, g0_.balance_status AS balance_status_8, g0_.profile_image_path AS profile_image_path_9, g0_.date_add AS date_add_10, g0_.status AS status_11, g0_.source AS source_12, g0_.company AS company_13, g0_.company_code AS company_code_14, g0_.vat_number AS vat_number_15, g0_.invoice_purpose AS invoice_purpose_16, g0_.email_reminders AS email_reminders_17, g0_.sms_reminders AS sms_reminders_18, g0_.is_free AS is_free_19, g0_.is_deleted AS is_deleted_20, g0_.show_survey AS show_survey_21, g0_.summer AS summer_22, g0_.summer_additional AS summer_additional_23, g0_.block_next_day_lessons_reminders AS block_next_day_lessons_reminders_24, g0_.block_today_lessons_reminders AS block_today_lessons_reminders_25, g0_.lastname AS lastname_26, g0_.invoice_company_info AS invoice_company_info_27, g0_.invoice_real_lesson_amount AS invoice_real_lesson_amount_28, g0_.credentials_sent AS credentials_sent_29, g0_.child_email_modal AS child_email_modal_30, g0_.autumn2024back AS autumn2024back_31, g0_.autumn2024back_date AS autumn2024back_date_32, g0_.not_comming_back2024 AS not_comming_back2024_33, g0_.not_comming_back2024_date AS not_comming_back2024_date_34, g0_.september_price_increase_applied_at AS september_price_increase_applied_at_35, g0_.september_price_increase_amount AS september_price_increase_amount_36, g0_.progress AS progress_37, g0_.progress_date AS progress_date_38, g0_.hour_price AS hour_price_39, g0_.contract_pricing_from AS contract_pricing_from_40, g0_.price_never_changes AS price_never_changes_41, g0_.google_refresh_token AS google_refresh_token_42, g0_.google_access_token AS google_access_token_43, g0_.referral_code AS referral_code_44, g0_.external_survey AS external_survey_45, g0_.feedback AS feedback_46, g0_.summer_at AS summer_at_47, g0_.summer_class AS summer_class_48, g0_.flag_early_payment AS flag_early_payment_49, g0_.early_payment_day AS early_payment_day_50, g0_.early_payment_from AS early_payment_from_51, g0_.balance AS balance_52, g0_.chat_stream_token AS chat_stream_token_53, g0_.new_price_email_sent AS new_price_email_sent_54, g0_.new_email_opened AS new_email_opened_55, g0_.new_email_submitted AS new_email_submitted_56, g0_.mobile_app_last_used_at AS mobile_app_last_used_at_57, g0_.marksign_name AS marksign_name_58, g0_.marksign_surname AS marksign_surname_59, g0_.summer_by_admin_id AS summer_by_admin_id_60, g0_.guardian_contract_id AS guardian_contract_id_61, g0_.autumn2024back_by_admin_id AS autumn2024back_by_admin_id_62, g0_.not_comming_back2024_by_admin_id AS not_comming_back2024_by_admin_id_63, g0_.progress_by_admin_id AS progress_by_admin_id_64 FROM guardian g0_ WHERE g0_.is_deleted = 0 ORDER BY g0_.date_add DESC LIMIT 25
Parameters:
[] |
|
1.82 ms (0.57%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.vbe_date AS vbe_date_4 FROM discipline t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
1.56 ms (0.49%) |
3 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.fullname AS fullname_5, t0.profile_image_path AS profile_image_path_6, t0.phone AS phone_7, t0.chat_stream_token AS chat_stream_token_8, t0.mobile_app_last_used_at AS mobile_app_last_used_at_9, t0.department AS department_10, t0.active AS active_11 FROM `admin` t0 WHERE t0.id = ?
Parameters:
[
34
]
|
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.