Symfony Profiler

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 = ?

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 = 42;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  tutor_no_show_incident t0_
  LEFT JOIN lesson l1_ ON t0_.lesson_id = l1_.id
  LEFT JOIN teacher t2_ ON t0_.teacher_id = t2_.id
  LEFT JOIN child c3_ ON t0_.child_id = c3_.id
WHERE
  t0_.days_since_first_lesson <= 30
  OR t0_.days_since_first_lesson IS NULL
ORDER BY
  t0_.recorded_at DESC

SELECT COUNT(t0_.id) AS sclr_0 FROM tutor_no_show_incident t0_ LEFT JOIN lesson l1_ ON t0_.lesson_id = l1_.id LEFT JOIN teacher t2_ ON t0_.teacher_id = t2_.id LEFT JOIN child c3_ ON t0_.child_id = c3_.id WHERE t0_.days_since_first_lesson <= 30 OR t0_.days_since_first_lesson IS NULL ORDER BY t0_.recorded_at DESC;

SELECT
  t0_.id AS id_0,
  t0_.teacher_name AS teacher_name_1,
  t0_.teacher_individual_number AS teacher_individual_number_2,
  t0_.child_name AS child_name_3,
  t0_.lesson_start_time AS lesson_start_time_4,
  t0_.recorded_at AS recorded_at_5,
  t0_.days_since_first_lesson AS days_since_first_lesson_6,
  l1_.id AS id_7,
  l1_.type AS type_8,
  l1_.class AS class_9,
  l1_.start_time AS start_time_10,
  l1_.end_time AS end_time_11,
  l1_.duration AS duration_12,
  l1_.comment AS comment_13,
  l1_.status AS status_14,
  l1_.admin_comment AS admin_comment_15,
  l1_.status_teacher AS status_teacher_16,
  l1_.status_child AS status_child_17,
  l1_.learncube_uuid AS learncube_uuid_18,
  l1_.attended_at_teacher AS attended_at_teacher_19,
  l1_.attended_at_child AS attended_at_child_20,
  l1_.child_is_late AS child_is_late_21,
  l1_.child_missed AS child_missed_22,
  l1_.teacher_missed AS teacher_missed_23,
  l1_.learncube_end_at AS learncube_end_at_24,
  l1_.learncube_duration AS learncube_duration_25,
  l1_.free_reason AS free_reason_26,
  l1_.learncube_child_duration AS learncube_child_duration_27,
  l1_.learncube_teacher_duration AS learncube_teacher_duration_28,
  l1_.moved_at AS moved_at_29,
  l1_.was_missed_by AS was_missed_by_30,
  l1_.date_add AS date_add_31,
  l1_.child_miss_reason AS child_miss_reason_32,
  l1_.child_missed_at AS child_missed_at_33,
  l1_.technical_difficulty_comment AS technical_difficulty_comment_34,
  l1_.learncube_review AS learncube_review_35,
  l1_.learncube_rating AS learncube_rating_36,
  l1_.google_calendar_id_teacher AS google_calendar_id_teacher_37,
  l1_.google_calendar_id_child AS google_calendar_id_child_38,
  l1_.google_calendar_id_guardian AS google_calendar_id_guardian_39,
  l1_.public_token AS public_token_40,
  l1_.moved_by AS moved_by_41,
  l1_.paid AS paid_42,
  l1_.original_start_time AS original_start_time_43,
  l1_.original_end_time AS original_end_time_44,
  l1_.child_dismissed_review AS child_dismissed_review_45,
  t2_.id AS id_46,
  t2_.email AS email_47,
  t2_.roles AS roles_48,
  t2_.password AS password_49,
  t2_.fullname AS fullname_50,
  t2_.phone_number AS phone_number_51,
  t2_.university AS university_52,
  t2_.work_start AS work_start_53,
  t2_.work_end AS work_end_54,
  t2_.max_load AS max_load_55,
  t2_.available AS available_56,
  t2_.status AS status_57,
  t2_.individual_number AS individual_number_58,
  t2_.profile_image_path AS profile_image_path_59,
  t2_.date_add AS date_add_60,
  t2_.classes AS classes_61,
  t2_.payment_status AS payment_status_62,
  t2_.account_number AS account_number_63,
  t2_.comment AS comment_64,
  t2_.short_name AS short_name_65,
  t2_.summer AS summer_66,
  t2_.show_survey AS show_survey_67,
  t2_.short_description AS short_description_68,
  t2_.discord_name AS discord_name_69,
  t2_.block_next_day_lessons_reminders AS block_next_day_lessons_reminders_70,
  t2_.block_today_lessons_reminders AS block_today_lessons_reminders_71,
  t2_.worked_hours AS worked_hours_72,
  t2_.worked_hours_march AS worked_hours_march_73,
  t2_.level_name AS level_name_74,
  t2_.lessons_missed AS lessons_missed_75,
  t2_.warning_date AS warning_date_76,
  t2_.flag_ru AS flag_ru_77,
  t2_.flag_pl AS flag_pl_78,
  t2_.flag_eng AS flag_eng_79,
  t2_.flag_ib AS flag_ib_80,
  t2_.flag_dyslexia AS flag_dyslexia_81,
  t2_.flag_sensitive AS flag_sensitive_82,
  t2_.flag_trial AS flag_trial_83,
  t2_.extra_load AS extra_load_84,
  t2_.admin_comment AS admin_comment_85,
  t2_.education_stage AS education_stage_86,
  t2_.lc_from AS lc_from_87,
  t2_.contract_terminate_reason AS contract_terminate_reason_88,
  t2_.contract_terminate_fee AS contract_terminate_fee_89,
  t2_.contract_terminate_fee_paid AS contract_terminate_fee_paid_90,
  t2_.unicko_function AS unicko_function_91,
  t2_.birthday AS birthday_92,
  t2_.individual_work_file_path AS individual_work_file_path_93,
  t2_.country AS country_94,
  t2_.summer_time AS summer_time_95,
  t2_.study_field AS study_field_96,
  t2_.congratulated_birthday AS congratulated_birthday_97,
  t2_.google_refresh_token AS google_refresh_token_98,
  t2_.google_access_token AS google_access_token_99,
  t2_.threema_password AS threema_password_100,
  t2_.threema_id AS threema_id_101,
  t2_.threema_status AS threema_status_102,
  t2_.threema_group AS threema_group_103,
  t2_.training_started AS training_started_104,
  t2_.training_ended AS training_ended_105,
  t2_.referral_code AS referral_code_106,
  t2_.school AS school_107,
  t2_.ielts AS ielts_108,
  t2_.personal_identification_number AS personal_identification_number_109,
  t2_.flag_web AS flag_web_110,
  t2_.flag_strict AS flag_strict_111,
  t2_.gender AS gender_112,
  t2_.flag_experience_at_school AS flag_experience_at_school_113,
  t2_.flag_priority_assignment AS flag_priority_assignment_114,
  t2_.new_contract_marksign_url AS new_contract_marksign_url_115,
  t2_.new_cotract_signed AS new_cotract_signed_116,
  t2_.new_contract_marksign_document_id AS new_contract_marksign_document_id_117,
  t2_.new_contract_signed_url AS new_contract_signed_url_118,
  t2_.new_contract_type AS new_contract_type_119,
  t2_.summer_at AS summer_at_120,
  t2_.flag_only_ib AS flag_only_ib_121,
  t2_.flag_auto_accept_assignment AS flag_auto_accept_assignment_122,
  t2_.gap_between_assignments AS gap_between_assignments_123,
  t2_.flag_auto_accept_assignment_teacher AS flag_auto_accept_assignment_teacher_124,
  t2_.gap_between_assignments_teacher AS gap_between_assignments_teacher_125,
  t2_.gap_between_assignments_submitted_at AS gap_between_assignments_submitted_at_126,
  t2_.chat_stream_token AS chat_stream_token_127,
  t2_.max_load_changed_at AS max_load_changed_at_128,
  t2_.mobile_app_last_used_at AS mobile_app_last_used_at_129,
  c3_.id AS id_130,
  c3_.fullname AS fullname_131,
  c3_.class AS class_132,
  c3_.birth_date AS birth_date_133,
  c3_.lessons_end AS lessons_end_134,
  c3_.email AS email_135,
  c3_.roles AS roles_136,
  c3_.password AS password_137,
  c3_.profile_image_path AS profile_image_path_138,
  c3_.phone_number AS phone_number_139,
  c3_.lastname AS lastname_140,
  c3_.fitting_times AS fitting_times_141,
  c3_.fitting_times_priority AS fitting_times_priority_142,
  c3_.username AS username_143,
  c3_.next_day_email_lessons_reminders_guardian AS next_day_email_lessons_reminders_guardian_144,
  c3_.next_day_email_lessons_reminders_child AS next_day_email_lessons_reminders_child_145,
  c3_.today_smslessons_reminders_guardian AS today_smslessons_reminders_guardian_146,
  c3_.today_smslessons_reminders_child AS today_smslessons_reminders_child_147,
  c3_.password_sent_at AS password_sent_at_148,
  c3_.show_email_modal AS show_email_modal_149,
  c3_.login_token AS login_token_150,
  c3_.google_refresh_token AS google_refresh_token_151,
  c3_.google_access_token AS google_access_token_152,
  c3_.flag_ru AS flag_ru_153,
  c3_.flag_pl AS flag_pl_154,
  c3_.flag_eng AS flag_eng_155,
  c3_.flag_ib AS flag_ib_156,
  c3_.flag_dyslexia AS flag_dyslexia_157,
  c3_.flag_sensitive AS flag_sensitive_158,
  c3_.school AS school_159,
  c3_.flag_strict AS flag_strict_160,
  c3_.gender AS gender_161,
  c3_.flag_experience_at_school AS flag_experience_at_school_162,
  c3_.flag_ielts AS flag_ielts_163,
  c3_.vbe_over90 AS vbe_over90_164,
  c3_.experience_over12_month AS experience_over12_month_165,
  c3_.tutor_comment AS tutor_comment_166,
  c3_.chat_stream_token AS chat_stream_token_167,
  c3_.mobile_app_last_used_at AS mobile_app_last_used_at_168,
  t0_.lesson_id AS lesson_id_169,
  t0_.teacher_id AS teacher_id_170,
  t0_.child_id AS child_id_171,
  l1_.discipline_id AS discipline_id_172,
  l1_.teacher_id AS teacher_id_173,
  c3_.guardian_id AS guardian_id_174
FROM
  tutor_no_show_incident t0_
  LEFT JOIN lesson l1_ ON t0_.lesson_id = l1_.id
  LEFT JOIN teacher t2_ ON t0_.teacher_id = t2_.id
  LEFT JOIN child c3_ ON t0_.child_id = c3_.id
WHERE
  t0_.days_since_first_lesson <= 30
  OR t0_.days_since_first_lesson IS NULL
ORDER BY
  t0_.recorded_at DESC
LIMIT
  20

SELECT t0_.id AS id_0, t0_.teacher_name AS teacher_name_1, t0_.teacher_individual_number AS teacher_individual_number_2, t0_.child_name AS child_name_3, t0_.lesson_start_time AS lesson_start_time_4, t0_.recorded_at AS recorded_at_5, t0_.days_since_first_lesson AS days_since_first_lesson_6, l1_.id AS id_7, l1_.type AS type_8, l1_.class AS class_9, l1_.start_time AS start_time_10, l1_.end_time AS end_time_11, l1_.duration AS duration_12, l1_.comment AS comment_13, l1_.status AS status_14, l1_.admin_comment AS admin_comment_15, l1_.status_teacher AS status_teacher_16, l1_.status_child AS status_child_17, l1_.learncube_uuid AS learncube_uuid_18, l1_.attended_at_teacher AS attended_at_teacher_19, l1_.attended_at_child AS attended_at_child_20, l1_.child_is_late AS child_is_late_21, l1_.child_missed AS child_missed_22, l1_.teacher_missed AS teacher_missed_23, l1_.learncube_end_at AS learncube_end_at_24, l1_.learncube_duration AS learncube_duration_25, l1_.free_reason AS free_reason_26, l1_.learncube_child_duration AS learncube_child_duration_27, l1_.learncube_teacher_duration AS learncube_teacher_duration_28, l1_.moved_at AS moved_at_29, l1_.was_missed_by AS was_missed_by_30, l1_.date_add AS date_add_31, l1_.child_miss_reason AS child_miss_reason_32, l1_.child_missed_at AS child_missed_at_33, l1_.technical_difficulty_comment AS technical_difficulty_comment_34, l1_.learncube_review AS learncube_review_35, l1_.learncube_rating AS learncube_rating_36, l1_.google_calendar_id_teacher AS google_calendar_id_teacher_37, l1_.google_calendar_id_child AS google_calendar_id_child_38, l1_.google_calendar_id_guardian AS google_calendar_id_guardian_39, l1_.public_token AS public_token_40, l1_.moved_by AS moved_by_41, l1_.paid AS paid_42, l1_.original_start_time AS original_start_time_43, l1_.original_end_time AS original_end_time_44, l1_.child_dismissed_review AS child_dismissed_review_45, t2_.id AS id_46, t2_.email AS email_47, t2_.roles AS roles_48, t2_.password AS password_49, t2_.fullname AS fullname_50, t2_.phone_number AS phone_number_51, t2_.university AS university_52, t2_.work_start AS work_start_53, t2_.work_end AS work_end_54, t2_.max_load AS max_load_55, t2_.available AS available_56, t2_.status AS status_57, t2_.individual_number AS individual_number_58, t2_.profile_image_path AS profile_image_path_59, t2_.date_add AS date_add_60, t2_.classes AS classes_61, t2_.payment_status AS payment_status_62, t2_.account_number AS account_number_63, t2_.comment AS comment_64, t2_.short_name AS short_name_65, t2_.summer AS summer_66, t2_.show_survey AS show_survey_67, t2_.short_description AS short_description_68, t2_.discord_name AS discord_name_69, t2_.block_next_day_lessons_reminders AS block_next_day_lessons_reminders_70, t2_.block_today_lessons_reminders AS block_today_lessons_reminders_71, t2_.worked_hours AS worked_hours_72, t2_.worked_hours_march AS worked_hours_march_73, t2_.level_name AS level_name_74, t2_.lessons_missed AS lessons_missed_75, t2_.warning_date AS warning_date_76, t2_.flag_ru AS flag_ru_77, t2_.flag_pl AS flag_pl_78, t2_.flag_eng AS flag_eng_79, t2_.flag_ib AS flag_ib_80, t2_.flag_dyslexia AS flag_dyslexia_81, t2_.flag_sensitive AS flag_sensitive_82, t2_.flag_trial AS flag_trial_83, t2_.extra_load AS extra_load_84, t2_.admin_comment AS admin_comment_85, t2_.education_stage AS education_stage_86, t2_.lc_from AS lc_from_87, t2_.contract_terminate_reason AS contract_terminate_reason_88, t2_.contract_terminate_fee AS contract_terminate_fee_89, t2_.contract_terminate_fee_paid AS contract_terminate_fee_paid_90, t2_.unicko_function AS unicko_function_91, t2_.birthday AS birthday_92, t2_.individual_work_file_path AS individual_work_file_path_93, t2_.country AS country_94, t2_.summer_time AS summer_time_95, t2_.study_field AS study_field_96, t2_.congratulated_birthday AS congratulated_birthday_97, t2_.google_refresh_token AS google_refresh_token_98, t2_.google_access_token AS google_access_token_99, t2_.threema_password AS threema_password_100, t2_.threema_id AS threema_id_101, t2_.threema_status AS threema_status_102, t2_.threema_group AS threema_group_103, t2_.training_started AS training_started_104, t2_.training_ended AS training_ended_105, t2_.referral_code AS referral_code_106, t2_.school AS school_107, t2_.ielts AS ielts_108, t2_.personal_identification_number AS personal_identification_number_109, t2_.flag_web AS flag_web_110, t2_.flag_strict AS flag_strict_111, t2_.gender AS gender_112, t2_.flag_experience_at_school AS flag_experience_at_school_113, t2_.flag_priority_assignment AS flag_priority_assignment_114, t2_.new_contract_marksign_url AS new_contract_marksign_url_115, t2_.new_cotract_signed AS new_cotract_signed_116, t2_.new_contract_marksign_document_id AS new_contract_marksign_document_id_117, t2_.new_contract_signed_url AS new_contract_signed_url_118, t2_.new_contract_type AS new_contract_type_119, t2_.summer_at AS summer_at_120, t2_.flag_only_ib AS flag_only_ib_121, t2_.flag_auto_accept_assignment AS flag_auto_accept_assignment_122, t2_.gap_between_assignments AS gap_between_assignments_123, t2_.flag_auto_accept_assignment_teacher AS flag_auto_accept_assignment_teacher_124, t2_.gap_between_assignments_teacher AS gap_between_assignments_teacher_125, t2_.gap_between_assignments_submitted_at AS gap_between_assignments_submitted_at_126, t2_.chat_stream_token AS chat_stream_token_127, t2_.max_load_changed_at AS max_load_changed_at_128, t2_.mobile_app_last_used_at AS mobile_app_last_used_at_129, c3_.id AS id_130, c3_.fullname AS fullname_131, c3_.class AS class_132, c3_.birth_date AS birth_date_133, c3_.lessons_end AS lessons_end_134, c3_.email AS email_135, c3_.roles AS roles_136, c3_.password AS password_137, c3_.profile_image_path AS profile_image_path_138, c3_.phone_number AS phone_number_139, c3_.lastname AS lastname_140, c3_.fitting_times AS fitting_times_141, c3_.fitting_times_priority AS fitting_times_priority_142, c3_.username AS username_143, c3_.next_day_email_lessons_reminders_guardian AS next_day_email_lessons_reminders_guardian_144, c3_.next_day_email_lessons_reminders_child AS next_day_email_lessons_reminders_child_145, c3_.today_smslessons_reminders_guardian AS today_smslessons_reminders_guardian_146, c3_.today_smslessons_reminders_child AS today_smslessons_reminders_child_147, c3_.password_sent_at AS password_sent_at_148, c3_.show_email_modal AS show_email_modal_149, c3_.login_token AS login_token_150, c3_.google_refresh_token AS google_refresh_token_151, c3_.google_access_token AS google_access_token_152, c3_.flag_ru AS flag_ru_153, c3_.flag_pl AS flag_pl_154, c3_.flag_eng AS flag_eng_155, c3_.flag_ib AS flag_ib_156, c3_.flag_dyslexia AS flag_dyslexia_157, c3_.flag_sensitive AS flag_sensitive_158, c3_.school AS school_159, c3_.flag_strict AS flag_strict_160, c3_.gender AS gender_161, c3_.flag_experience_at_school AS flag_experience_at_school_162, c3_.flag_ielts AS flag_ielts_163, c3_.vbe_over90 AS vbe_over90_164, c3_.experience_over12_month AS experience_over12_month_165, c3_.tutor_comment AS tutor_comment_166, c3_.chat_stream_token AS chat_stream_token_167, c3_.mobile_app_last_used_at AS mobile_app_last_used_at_168, t0_.lesson_id AS lesson_id_169, t0_.teacher_id AS teacher_id_170, t0_.child_id AS child_id_171, l1_.discipline_id AS discipline_id_172, l1_.teacher_id AS teacher_id_173, c3_.guardian_id AS guardian_id_174 FROM tutor_no_show_incident t0_ LEFT JOIN lesson l1_ ON t0_.lesson_id = l1_.id LEFT JOIN teacher t2_ ON t0_.teacher_id = t2_.id LEFT JOIN child c3_ ON t0_.child_id = c3_.id WHERE t0_.days_since_first_lesson <= 30 OR t0_.days_since_first_lesson IS NULL ORDER BY t0_.recorded_at DESC LIMIT 20;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  tutor_no_show_incident t0_
WHERE
  t0_.days_since_first_lesson <= 30
  OR t0_.days_since_first_lesson IS NULL

SELECT COUNT(t0_.id) AS sclr_0 FROM tutor_no_show_incident t0_ WHERE t0_.days_since_first_lesson <= 30 OR t0_.days_since_first_lesson IS NULL;

SELECT
  COUNT(DISTINCT t0_.teacher_id) AS sclr_0
FROM
  tutor_no_show_incident t0_
WHERE
  t0_.days_since_first_lesson <= 30
  OR t0_.days_since_first_lesson IS NULL

SELECT COUNT(DISTINCT t0_.teacher_id) AS sclr_0 FROM tutor_no_show_incident t0_ WHERE t0_.days_since_first_lesson <= 30 OR t0_.days_since_first_lesson IS NULL;

SELECT
  t0_.teacher_id AS sclr_0,
  COUNT(t0_.id) AS sclr_1
FROM
  tutor_no_show_incident t0_
WHERE
  t0_.days_since_first_lesson <= 30
  OR t0_.days_since_first_lesson IS NULL
GROUP BY
  t0_.teacher_id

SELECT t0_.teacher_id AS sclr_0, COUNT(t0_.id) AS sclr_1 FROM tutor_no_show_incident t0_ WHERE t0_.days_since_first_lesson <= 30 OR t0_.days_since_first_lesson IS NULL GROUP BY t0_.teacher_id;

SELECT
  AVG(t0_.days_since_first_lesson) AS sclr_0
FROM
  tutor_no_show_incident t0_
WHERE
  t0_.days_since_first_lesson <= 30
  OR t0_.days_since_first_lesson IS NULL

SELECT AVG(t0_.days_since_first_lesson) AS sclr_0 FROM tutor_no_show_incident t0_ WHERE t0_.days_since_first_lesson <= 30 OR t0_.days_since_first_lesson IS NULL;