Query | Affected | Num. rows | Took (ms) | Actions |
---|
SHOW TABLES FROM `classera_g2` | 1306 | 1306 | 8 | |
SHOW FULL COLUMNS FROM `classera_g2`.`roles` | 12 | 12 | 3 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME = ? [ utf8_bin ] | 1 | 1 | 3 | maybe slow |
SELECT `Role`.`id`, `Role`.`prefix` FROM `classera_g2`.`roles` AS `Role` WHERE 1 = 1 | 37 | 37 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`permissions` | 16 | 16 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`default_all_school_settings` | 6 | 6 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`school_groups` | 41 | 41 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`countries` | 11 | 11 | 2 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME = ? [ utf8_unicode_ci ] | 1 | 1 | 3 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME = ? [ utf8_general_ci ] | 1 | 1 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`users` | 108 | 108 | 2 | |
SHOW FULL COLUMNS FROM `classera_g2`.`schools` | 138 | 138 | 4 | |
SELECT `School`.`country_id` FROM `classera_g2`.`schools` AS `School` WHERE `School`.`id` IS NULL LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `DefaultAllSchoolSetting`.`id`, `DefaultAllSchoolSetting`.`key_setting`, `DefaultAllSchoolSetting`.`value_setting`, `DefaultAllSchoolSetting`.`active`, `DefaultAllSchoolSetting`.`created`, `DefaultAllSchoolSetting`.`modified` FROM `classera_g2`.`default_all_school_settings` AS `DefaultAllSchoolSetting` WHERE `DefaultAllSchoolSetting`.`key_setting` = 'default_sms_provider' LIMIT 1 | 1 | 1 | 38 | maybe slow |
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 `id` IS NULL LIMIT 1 | 0 | 0 | 3 | maybe slow |
SELECT `Country`.`ID`, `Country`.`Name_English`, `Country`.`Name_Arabic`, `Country`.`Name_French`, `Country`.`Code`, `Country`.`Code2`, `Country`.`Continent`, `Country`.`Region`, `Country`.`Phone_Code`, `Country`.`Mobile_Length`, `Country`.`sms_provider` FROM `classera_g2`.`countries` AS `Country` WHERE `id` = '0' LIMIT 1 | 0 | 0 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`schools_users` | 7 | 7 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`teachers` | 7 | 7 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`content_reviewers` | 7 | 7 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`voices_preferences` | 5 | 5 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`badges_users` | 6 | 6 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`badges` | 8 | 8 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`fg_teachers_office_accounts` | 6 | 6 | 4 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`onlines3` | 7 | 7 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`developers_settings` | 10 | 10 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`success_partners` | 31 | 31 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`admission_exams_creators` | 5 | 5 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`accreditation_factors` | 7 | 7 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`tickets_senders` | 20 | 20 | 752 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`tickets_recipients` | 5 | 5 | 5 | |
SHOW FULL COLUMNS FROM `classera_g2`.`reset_codes` | 4 | 4 | 2 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME = ? [ latin1_swedish_ci ] | 1 | 1 | 3 | maybe slow |