Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `School`.`logo` FROM `classera_g2`.`schools` AS `School` WHERE `id` = '' LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `School`.`id` FROM `classera_g2`.`schools` AS `School` inner JOIN `classera_g2`.`registrations_timeslot` AS `RegistrationTimeslot` ON (`RegistrationTimeslot`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`registrations_semesters` AS `RegistrationSemester` ON (`RegistrationSemester`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`semesters` AS `Semester` ON (`Semester`.`id` = `RegistrationSemester`.`semester_id` AND `Semester`.`deleted` = 0) WHERE `School`.`school_group_id` = 6259 AND `School`.`deleted` = '0' AND `RegistrationTimeslot`.`type` = 2 AND `RegistrationTimeslot`.`from` <= '2025-03-17 10:19:12' AND `RegistrationTimeslot`.`to` >= '2025-03-17 10:19:12' GROUP BY `School`.`id` | 10 | 10 | 1 | maybe slow |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 49051 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000001 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000002 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000003 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000009 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000011 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000014 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000015 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000016 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000018 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id`, `School`.`parent_id`, `School`.`name`, `School`.`english_name`, `School`.`prefix`, `School`.`city`, `School`.`country_id`, `School`.`city_id`, `School`.`school_group_id`, `School`.`management`, `School`.`number`, `School`.`address`, `School`.`about_school`, `School`.`phone_number`, `School`.`fax_number`, `School`.`email`, `School`.`website`, `School`.`logo`, `School`.`lang`, `School`.`timezone`, `School`.`date_format`, `School`.`type`, `School`.`squigl_sync_history_id`, `School`.`registration_open`, `School`.`parents_registration_open`, `School`.`created`, `School`.`modified`, `School`.`pioneer_id`, `School`.`facebook_account`, `School`.`twitter_account`, `School`.`google_plus_account`, `School`.`instagram_account`, `School`.`linkedin_account`, `School`.`allow_users_open_publicprofile`, `School`.`allow_users_upload_eportfolios`, `School`.`allow_users_upload_posts`, `School`.`publicprofiles_privecy_level_id`, `School`.`allow_students_change_password`, `School`.`allow_teachers_change_password`, `School`.`allow_others_change_password`, `School`.`allow_students_change_login_name`, `School`.`allow_teachers_change_login_name`, `School`.`allow_others_change_login_name`, `School`.`allow_students_change_profile_pic`, `School`.`show_american_question_bank`, `School`.`allow_smart_mate_generation`, `School`.`allow_teacher_to_link_preparation_standards`, `School`.`deleted`, `School`.`id_hash`, `School`.`gpa_base`, `School`.`allow_students_change_phone_number`, `School`.`allow_parents_change_phone_number`, `School`.`sms_sender_name`, `School`.`allow_tsupv_approve_preparation`, `School`.`allow_discussion_board`, `School`.`allow_students_create_discussions`, `School`.`allow_students_create_topics_in_discussions`, `School`.`absences_notification_limit`, `School`.`lectures_absences_notification_limit`, `School`.`absences_notification_excused`, `School`.`lectures_absences_notification_excused`, `School`.`absences_notification`, `School`.`lectures_absences_notification`, `School`.`allow_tsupv_show_messages_between_teachers_and_students`, `School`.`send_to_school_group_staff`, `School`.`is_mawhiba_olympics_exam_school`, `School`.`mawhiba_portal_exam_id`, `School`.`allow_managers_add_announcements`, `School`.`approved_attachments_in_library_only`, `School`.`allow_reset_password_via_sms`, `School`.`allow_school_chat`, `School`.`gender`, `School`.`noor_id`, `School`.`hide_weekends_in_weekly_plan`, `School`.`allow_students_requests`, `School`.`school_pdf_zoom`, `School`.`absences_letter`, `School`.`absences_letter_excused`, `School`.`allow_graduated_students_login`, `School`.`allow_parent_access_to_smart_class`, `School`.`implementation_phase`, `School`.`max_number_of_replies_discussion_rooms`, `School`.`educational_office_id`, `School`.`take_evidences`, `School`.`is_premium`, `School`.`is_lite`, `School`.`students_section_messages`, `School`.`acf_check`, `School`.`enabled`, `School`.`allow_students_change_email`, `School`.`allow_students_change_face`, `School`.`allow_internally_tickets`, `School`.`unit_plan_allow`, `School`.`is_mawhiba_scan_exam_school`, `School`.`show_weekends_in_schedule`, `School`.`working_days`, `School`.`manager_approve_content_publish`, `School`.`starting_day`, `School`.`simultaneous_sessions_limit`, `School`.`graduates_club_allow`, `School`.`allow_hijri_date`, `School`.`registration_age_start`, `School`.`normal_english_curriculum`, `School`.`muqrarrat_english_curriculum`, `School`.`summer_period`, `School`.`is_muqararat_school`, `School`.`clever_id`, `School`.`translation_version`, `School`.`international`, `School`.`automatically_set_full_day_absences`, `School`.`show_late_bills_warning_message`, `School`.`hide_exam_due_date`, `School`.`require_attachments`, `School`.`attachments_description`, `School`.`allow_teacher_hide_exam`, `School`.`is_edumall_school`, `School`.`mawhiba_create_automatic_stages`, `School`.`longitude`, `School`.`latitude`, `School`.`allow_student_register_course`, `School`.`activation_manager_id`, `School`.`show_contact_information_credential`, `School`.`allow_payment`, `School`.`psp_config`, `School`.`share_content`, `School`.`distance_in_kilometers`, `School`.`allow_smart_mate_attachment_generation`, `School`.`SecondaryLanguageRestrictMessage`, `School`.`PrimaryLanguageRestrictMessage`, `School`.`face_id_file`, `School`.`iban`, `School`.`payment_method`, `School`.`registration_fees_amount`, `School`.`ending_day`, `School`.`mawhiba_integration`, `School`.`cpay_merchant_id`, `School`.`claim_visible`, `School`.`county_id`, `School`.`institute_group_id`, `School`.`attendance_hours`, `School`.`program_hours` FROM `classera_g2`.`schools` AS `School` WHERE `School`.`id` = 49051 LIMIT 1 | 1 | 1 | 1 | |
SELECT `SchoolsSetting`.`school_id`, `SchoolsSetting`.`settings` FROM `classera_g2`.`schools_settings` AS `SchoolsSetting` WHERE `school_id` IN (49051, 1000001, 1000002, 1000003, 1000009, 1000011, 1000014, 1000015, 1000016, 1000018) | 10 | 10 | 1 | maybe slow |
SELECT `School`.`id` FROM `classera_g2`.`schools` AS `School` inner JOIN `classera_g2`.`registrations_timeslot` AS `RegistrationTimeslot` ON (`RegistrationTimeslot`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`registrations_semesters` AS `RegistrationSemester` ON (`RegistrationSemester`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`semesters` AS `Semester` ON (`Semester`.`id` = `RegistrationSemester`.`semester_id` AND `Semester`.`deleted` = 0) WHERE `School`.`parent_id` = 6259 AND `School`.`school_group_id` = 1133 AND `School`.`deleted` = '0' AND `RegistrationTimeslot`.`type` = 2 AND `RegistrationTimeslot`.`from` <= '2025-03-17 10:19:12' AND `RegistrationTimeslot`.`to` >= '2025-03-17 10:19:12' GROUP BY `School`.`id` | 0 | 0 | 0 | |
SELECT `School`.`id`, `parent_id` AS `parent`, (COALESCE(NULLIF(`School`.`english_name`,"") , `School`.`name`)) AS `School__text` FROM `classera_g2`.`schools` AS `School` inner JOIN `classera_g2`.`registrations_timeslot` AS `RegistrationTimeslot` ON (`RegistrationTimeslot`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`registrations_semesters` AS `RegistrationSemester` ON (`RegistrationSemester`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`semesters` AS `Semester` ON (`Semester`.`id` = `RegistrationSemester`.`semester_id` AND `Semester`.`deleted` = 0) WHERE `School`.`school_group_id` = 6259 AND `School`.`deleted` = '0' AND `RegistrationTimeslot`.`type` = 2 AND `RegistrationTimeslot`.`from` <= '2025-03-17 10:19:12' AND `RegistrationTimeslot`.`to` >= '2025-03-17 10:19:12' GROUP BY `School`.`id` | 10 | 10 | 0 | |
SELECT `SchoolGroup`.`id`, `SchoolGroup`.`parent_id`, `SchoolGroup`.`title`, `SchoolGroup`.`logo`, `SchoolGroup`.`registration_link`, `SchoolGroup`.`registration_message`, `SchoolGroup`.`user_id`, `SchoolGroup`.`prefix`, `SchoolGroup`.`mawhiba_department_id`, `SchoolGroup`.`created`, `SchoolGroup`.`modified`, `SchoolGroup`.`deleted`, `SchoolGroup`.`send_only_from_template`, `SchoolGroup`.`template_controller_admin`, `SchoolGroup`.`clever_id`, `SchoolGroup`.`vcr_limit`, `SchoolGroup`.`allow_teacher_vcr_meeting`, `SchoolGroup`.`school_has_ad`, `SchoolGroup`.`isolated_group`, `SchoolGroup`.`activation_manager_id`, `SchoolGroup`.`number_of_license`, `SchoolGroup`.`sms_provider`, `SchoolGroup`.`enable_prefix`, `SchoolGroup`.`number_of_additional_license`, `SchoolGroup`.`number_of_free_license`, `SchoolGroup`.`iban`, `SchoolGroup`.`cpay_country`, `SchoolGroup`.`active_cpay`, `SchoolGroup`.`currency_id`, `SchoolGroup`.`language_id`, `SchoolGroup`.`payment_method`, `SchoolGroup`.`active_gift`, `SchoolGroup`.`school_group_financial_system`, `SchoolGroup`.`enable_email_verification_code`, `SchoolGroup`.`allow_partial_payment_erp`, `SchoolGroup`.`from_sales`, `SchoolGroup`.`package_price`, `SchoolGroup`.`package_currency`, `SchoolGroup`.`payment_plan`, `SchoolGroup`.`claim_visible`, `SchoolGroup`.`users_can_skip_email_phone_verification_code` FROM `classera_g2`.`school_groups` AS `SchoolGroup` WHERE `SchoolGroup`.`id` = 6259 LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`type` FROM `classera_g2`.`schools` AS `School` WHERE `id` = 49051 LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`type` FROM `classera_g2`.`schools` AS `School` WHERE `id` = '' LIMIT 1 | 0 | 0 | 0 | |
SELECT `School`.`id`, `parent_id` AS `parent`, `name` AS `text` FROM `classera_g2`.`schools` AS `School` WHERE `School`.`id` = 49049 AND `School`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id`, `parent_id` AS `parent`, `name` AS `text` FROM `classera_g2`.`schools` AS `School` WHERE `School`.`id` = 1000010 AND `School`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id`, `parent_id` AS `parent`, `name` AS `text` FROM `classera_g2`.`schools` AS `School` WHERE `School`.`id` = 1000020 AND `School`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id`, `parent_id` AS `parent`, `name` AS `text` FROM `classera_g2`.`schools` AS `School` WHERE `School`.`id` = 1000012 AND `School`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |