Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `MenuLinksUser`.`id`, `MenuLinksUser`.`user_id` FROM `osedu`.`menu_links_users` AS `MenuLinksUser` WHERE 1 = 1 ORDER BY `MenuLinksUser`.`id` ASC | 0 | 0 | 0 | |
SELECT `Country`.`id`, `Country`.`name`, `Country`.`page_slug`, `Country`.`page_url`, `Country`.`canonical_url`, `Country`.`official_name`, `Country`.`form_of_govt`, `Country`.`capital`, `Country`.`population`, `Country`.`official_language`, `Country`.`currency_id`, `Country`.`area`, `Country`.`major_river`, `Country`.`gdp`, `Country`.`overview`, `Country`.`whystudy`, `Country`.`education_system`, `Country`.`other_information`, `Country`.`course_details`, `Country`.`banner_image`, `Country`.`cover_image`, `Country`.`flag_image`, `Country`.`alpha_2_code`, `Country`.`alpha_3_code`, `Country`.`calling_code`, `Country`.`display_order`, `Country`.`display_on_home`, `Country`.`active`, `Country`.`created`, `Country`.`modified`, (CONCAT(`Country`.`name`, " (+", `Country`.`calling_code`,")")) AS `Country__country_with_calling_code` FROM `osedu`.`countries` AS `Country` WHERE `Country`.`active` = '1' ORDER BY `Country`.`display_order` ASC | 5 | 5 | 1 | maybe slow |
SELECT `Country`.`id`, `Country`.`name` FROM `osedu`.`countries` AS `Country` WHERE `Country`.`active` = '1' ORDER BY `Country`.`display_order` ASC | 5 | 5 | 0 | |
SELECT `Subject`.`id`, `Subject`.`title` FROM `osedu`.`subjects` AS `Subject` WHERE `Subject`.`active` = '1' | 3 | 3 | 0 | |
SELECT `CorporateOffice`.`id`, `CorporateOffice`.`address`, `CorporateOffice`.`whatsapp`, `CorporateOffice`.`mobile_1`, `CorporateOffice`.`mobile_2`, `CorporateOffice`.`email1`, `CorporateOffice`.`email2`, `CorporateOffice`.`office_timing`, `CorporateOffice`.`weekend_timing`, `CorporateOffice`.`map_address`, `CorporateOffice`.`created`, `CorporateOffice`.`modified` FROM `osedu`.`corporate_offices` AS `CorporateOffice` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `University`.`id`, `University`.`name` FROM `osedu`.`universities` AS `University` WHERE `University`.`active` = '1' | 4 | 4 | 0 | |
SELECT `University`.`id`, `University`.`country_id`, `University`.`institution_type_id`, `University`.`name`, `University`.`page_slug`, `University`.`page_url`, `University`.`canonical_url`, `University`.`video_link`, `University`.`logo`, `University`.`cover_image`, `University`.`location`, `University`.`estiblished`, `University`.`highlight`, `University`.`about`, `University`.`top_faculty`, `University`.`department_school`, `University`.`website`, `University`.`no_of_student`, `University`.`estimate_cost_of_living`, `University`.`national_ranking`, `University`.`active`, `University`.`created`, `University`.`modified`, `Country`.`id`, `Country`.`currency_id`, `InstitutionType`.`title` FROM `osedu`.`universities` AS `University` LEFT JOIN `osedu`.`countries` AS `Country` ON (`University`.`country_id` = `Country`.`id`) LEFT JOIN `osedu`.`institution_types` AS `InstitutionType` ON (`University`.`institution_type_id` = `InstitutionType`.`id`) WHERE `University`.`active` IN (1) | 4 | 4 | 4 | |
SELECT `Currency`.`iso_code` FROM `osedu`.`currencies` AS `Currency` WHERE `Currency`.`id` = 49 | 1 | 1 | 2 | maybe slow |
SELECT `Currency`.`iso_code` FROM `osedu`.`currencies` AS `Currency` WHERE `Currency`.`id` = 49 | 1 | 1 | 0 | |
SELECT `Currency`.`iso_code` FROM `osedu`.`currencies` AS `Currency` WHERE `Currency`.`id` = 49 | 1 | 1 | 0 | |
SELECT `Currency`.`iso_code` FROM `osedu`.`currencies` AS `Currency` WHERE `Currency`.`id` = 8 | 1 | 1 | 0 | |
SELECT `Course`.`id`, `Course`.`english_language_requirement_id`, `Course`.`country_id`, `Course`.`university_id`, `Course`.`course_type_id`, `Course`.`course_lavel_id`, `Course`.`specialisation_id`, `Course`.`name`, `Course`.`banner_image`, `Course`.`image_file`, `Course`.`description`, `Course`.`short_descrption`, `Course`.`display_home_page`, `Course`.`overview`, `Course`.`job_oportunity`, `Course`.`adminssion_requirment`, `Course`.`active`, `Course`.`duration`, `Course`.`intake`, `Course`.`processing_time`, `Course`.`total_tuition_fee`, `Course`.`annual_cost_living`, `Course`.`application_fee`, `Course`.`page_slug`, `Course`.`canonical_url`, `Course`.`page_url`, `Course`.`display_order_in_university`, `Course`.`created`, `Course`.`modified` FROM `osedu`.`courses` AS `Course` WHERE `Course`.`university_id` = (1) LIMIT 2 | 2 | 2 | 3 | maybe slow |
SELECT `Intake`.`id`, `Intake`.`month`, `Intake`.`active`, `Intake`.`created`, `Intake`.`modified`, `CoursesIntake`.`id`, `CoursesIntake`.`course_id`, `CoursesIntake`.`intake_id` FROM `osedu`.`intakes` AS `Intake` JOIN `osedu`.`courses_intakes` AS `CoursesIntake` ON (`CoursesIntake`.`course_id` IN (2, 4) AND `CoursesIntake`.`intake_id` = `Intake`.`id`) | 2 | 2 | 2 | |
SELECT `Course`.`id`, `Course`.`english_language_requirement_id`, `Course`.`country_id`, `Course`.`university_id`, `Course`.`course_type_id`, `Course`.`course_lavel_id`, `Course`.`specialisation_id`, `Course`.`name`, `Course`.`banner_image`, `Course`.`image_file`, `Course`.`description`, `Course`.`short_descrption`, `Course`.`display_home_page`, `Course`.`overview`, `Course`.`job_oportunity`, `Course`.`adminssion_requirment`, `Course`.`active`, `Course`.`duration`, `Course`.`intake`, `Course`.`processing_time`, `Course`.`total_tuition_fee`, `Course`.`annual_cost_living`, `Course`.`application_fee`, `Course`.`page_slug`, `Course`.`canonical_url`, `Course`.`page_url`, `Course`.`display_order_in_university`, `Course`.`created`, `Course`.`modified` FROM `osedu`.`courses` AS `Course` WHERE `Course`.`university_id` = (2) LIMIT 2 | 2 | 2 | 0 | |
SELECT `Intake`.`id`, `Intake`.`month`, `Intake`.`active`, `Intake`.`created`, `Intake`.`modified`, `CoursesIntake`.`id`, `CoursesIntake`.`course_id`, `CoursesIntake`.`intake_id` FROM `osedu`.`intakes` AS `Intake` JOIN `osedu`.`courses_intakes` AS `CoursesIntake` ON (`CoursesIntake`.`course_id` IN (1, 3) AND `CoursesIntake`.`intake_id` = `Intake`.`id`) | 3 | 3 | 0 | |
SELECT `Course`.`id`, `Course`.`english_language_requirement_id`, `Course`.`country_id`, `Course`.`university_id`, `Course`.`course_type_id`, `Course`.`course_lavel_id`, `Course`.`specialisation_id`, `Course`.`name`, `Course`.`banner_image`, `Course`.`image_file`, `Course`.`description`, `Course`.`short_descrption`, `Course`.`display_home_page`, `Course`.`overview`, `Course`.`job_oportunity`, `Course`.`adminssion_requirment`, `Course`.`active`, `Course`.`duration`, `Course`.`intake`, `Course`.`processing_time`, `Course`.`total_tuition_fee`, `Course`.`annual_cost_living`, `Course`.`application_fee`, `Course`.`page_slug`, `Course`.`canonical_url`, `Course`.`page_url`, `Course`.`display_order_in_university`, `Course`.`created`, `Course`.`modified` FROM `osedu`.`courses` AS `Course` WHERE `Course`.`university_id` = (3) LIMIT 2 | 2 | 2 | 0 | |
SELECT `Intake`.`id`, `Intake`.`month`, `Intake`.`active`, `Intake`.`created`, `Intake`.`modified`, `CoursesIntake`.`id`, `CoursesIntake`.`course_id`, `CoursesIntake`.`intake_id` FROM `osedu`.`intakes` AS `Intake` JOIN `osedu`.`courses_intakes` AS `CoursesIntake` ON (`CoursesIntake`.`course_id` IN (7, 8) AND `CoursesIntake`.`intake_id` = `Intake`.`id`) | 2 | 2 | 0 | |
SELECT `Course`.`id`, `Course`.`english_language_requirement_id`, `Course`.`country_id`, `Course`.`university_id`, `Course`.`course_type_id`, `Course`.`course_lavel_id`, `Course`.`specialisation_id`, `Course`.`name`, `Course`.`banner_image`, `Course`.`image_file`, `Course`.`description`, `Course`.`short_descrption`, `Course`.`display_home_page`, `Course`.`overview`, `Course`.`job_oportunity`, `Course`.`adminssion_requirment`, `Course`.`active`, `Course`.`duration`, `Course`.`intake`, `Course`.`processing_time`, `Course`.`total_tuition_fee`, `Course`.`annual_cost_living`, `Course`.`application_fee`, `Course`.`page_slug`, `Course`.`canonical_url`, `Course`.`page_url`, `Course`.`display_order_in_university`, `Course`.`created`, `Course`.`modified` FROM `osedu`.`courses` AS `Course` WHERE `Course`.`university_id` = (4) LIMIT 2 | 2 | 2 | 0 | |
SELECT `Intake`.`id`, `Intake`.`month`, `Intake`.`active`, `Intake`.`created`, `Intake`.`modified`, `CoursesIntake`.`id`, `CoursesIntake`.`course_id`, `CoursesIntake`.`intake_id` FROM `osedu`.`intakes` AS `Intake` JOIN `osedu`.`courses_intakes` AS `CoursesIntake` ON (`CoursesIntake`.`course_id` IN (10, 11) AND `CoursesIntake`.`intake_id` = `Intake`.`id`) | 3 | 3 | 0 | |
SELECT `University`.`id`, `University`.`country_id`, `University`.`institution_type_id`, `University`.`name`, `University`.`page_slug`, `University`.`page_url`, `University`.`canonical_url`, `University`.`video_link`, `University`.`logo`, `University`.`cover_image`, `University`.`location`, `University`.`estiblished`, `University`.`highlight`, `University`.`about`, `University`.`top_faculty`, `University`.`department_school`, `University`.`website`, `University`.`no_of_student`, `University`.`estimate_cost_of_living`, `University`.`national_ranking`, `University`.`active`, `University`.`created`, `University`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`page_slug`, `Country`.`page_url`, `Country`.`canonical_url`, `Country`.`official_name`, `Country`.`form_of_govt`, `Country`.`capital`, `Country`.`population`, `Country`.`official_language`, `Country`.`currency_id`, `Country`.`area`, `Country`.`major_river`, `Country`.`gdp`, `Country`.`overview`, `Country`.`whystudy`, `Country`.`education_system`, `Country`.`other_information`, `Country`.`course_details`, `Country`.`banner_image`, `Country`.`cover_image`, `Country`.`flag_image`, `Country`.`alpha_2_code`, `Country`.`alpha_3_code`, `Country`.`calling_code`, `Country`.`display_order`, `Country`.`display_on_home`, `Country`.`active`, `Country`.`created`, `Country`.`modified`, (CONCAT(`Country`.`name`, " (+", `Country`.`calling_code`,")")) AS `Country__country_with_calling_code`, `InstitutionType`.`id`, `InstitutionType`.`title`, `InstitutionType`.`active`, `InstitutionType`.`created`, `InstitutionType`.`modified` FROM `osedu`.`universities` AS `University` LEFT JOIN `osedu`.`countries` AS `Country` ON (`University`.`country_id` = `Country`.`id`) LEFT JOIN `osedu`.`institution_types` AS `InstitutionType` ON (`University`.`institution_type_id` = `InstitutionType`.`id`) WHERE `University`.`active` IN (1) LIMIT 20 | 4 | 4 | 1 | maybe slow |
SELECT `UniversitySocailAccount`.`id`, `UniversitySocailAccount`.`university_id`, `UniversitySocailAccount`.`title`, `UniversitySocailAccount`.`social_link`, `UniversitySocailAccount`.`social_logo`, `UniversitySocailAccount`.`active`, `UniversitySocailAccount`.`created`, `UniversitySocailAccount`.`modified` FROM `osedu`.`university_socail_accounts` AS `UniversitySocailAccount` WHERE `UniversitySocailAccount`.`university_id` IN (1, 2, 3, 4) | 4 | 4 | 2 | maybe slow |
SELECT `Course`.`id`, `Course`.`english_language_requirement_id`, `Course`.`country_id`, `Course`.`university_id`, `Course`.`course_type_id`, `Course`.`course_lavel_id`, `Course`.`specialisation_id`, `Course`.`name`, `Course`.`banner_image`, `Course`.`image_file`, `Course`.`description`, `Course`.`short_descrption`, `Course`.`display_home_page`, `Course`.`overview`, `Course`.`job_oportunity`, `Course`.`adminssion_requirment`, `Course`.`active`, `Course`.`duration`, `Course`.`intake`, `Course`.`processing_time`, `Course`.`total_tuition_fee`, `Course`.`annual_cost_living`, `Course`.`application_fee`, `Course`.`page_slug`, `Course`.`canonical_url`, `Course`.`page_url`, `Course`.`display_order_in_university`, `Course`.`created`, `Course`.`modified` FROM `osedu`.`courses` AS `Course` WHERE `Course`.`university_id` IN (1, 2, 3, 4) | 11 | 11 | 0 | |
SELECT `University`.`id`, `University`.`country_id`, `University`.`institution_type_id`, `University`.`name`, `University`.`page_slug`, `University`.`page_url`, `University`.`canonical_url`, `University`.`video_link`, `University`.`logo`, `University`.`cover_image`, `University`.`location`, `University`.`estiblished`, `University`.`highlight`, `University`.`about`, `University`.`top_faculty`, `University`.`department_school`, `University`.`website`, `University`.`no_of_student`, `University`.`estimate_cost_of_living`, `University`.`national_ranking`, `University`.`active`, `University`.`created`, `University`.`modified`, `Country`.`id`, `Country`.`currency_id`, `InstitutionType`.`title` FROM `osedu`.`universities` AS `University` LEFT JOIN `osedu`.`countries` AS `Country` ON (`University`.`country_id` = `Country`.`id`) LEFT JOIN `osedu`.`institution_types` AS `InstitutionType` ON (`University`.`institution_type_id` = `InstitutionType`.`id`) WHERE `University`.`active` IN (1) LIMIT 20 | 4 | 4 | 0 | |
SELECT `Currency`.`iso_code` FROM `osedu`.`currencies` AS `Currency` WHERE `Currency`.`id` = 49 | 1 | 1 | 0 | |
SELECT `Currency`.`iso_code` FROM `osedu`.`currencies` AS `Currency` WHERE `Currency`.`id` = 49 | 1 | 1 | 0 | |
SELECT `Currency`.`iso_code` FROM `osedu`.`currencies` AS `Currency` WHERE `Currency`.`id` = 49 | 1 | 1 | 0 | |
SELECT `Currency`.`iso_code` FROM `osedu`.`currencies` AS `Currency` WHERE `Currency`.`id` = 8 | 1 | 1 | 0 | |
SELECT `Course`.`id`, `Course`.`english_language_requirement_id`, `Course`.`country_id`, `Course`.`university_id`, `Course`.`course_type_id`, `Course`.`course_lavel_id`, `Course`.`specialisation_id`, `Course`.`name`, `Course`.`banner_image`, `Course`.`image_file`, `Course`.`description`, `Course`.`short_descrption`, `Course`.`display_home_page`, `Course`.`overview`, `Course`.`job_oportunity`, `Course`.`adminssion_requirment`, `Course`.`active`, `Course`.`duration`, `Course`.`intake`, `Course`.`processing_time`, `Course`.`total_tuition_fee`, `Course`.`annual_cost_living`, `Course`.`application_fee`, `Course`.`page_slug`, `Course`.`canonical_url`, `Course`.`page_url`, `Course`.`display_order_in_university`, `Course`.`created`, `Course`.`modified` FROM `osedu`.`courses` AS `Course` WHERE `Course`.`university_id` = (1) LIMIT 2 | 2 | 2 | 0 | |
SELECT `Intake`.`id`, `Intake`.`month`, `Intake`.`active`, `Intake`.`created`, `Intake`.`modified`, `CoursesIntake`.`id`, `CoursesIntake`.`course_id`, `CoursesIntake`.`intake_id` FROM `osedu`.`intakes` AS `Intake` JOIN `osedu`.`courses_intakes` AS `CoursesIntake` ON (`CoursesIntake`.`course_id` IN (2, 4) AND `CoursesIntake`.`intake_id` = `Intake`.`id`) | 2 | 2 | 0 | |
SELECT `Course`.`id`, `Course`.`english_language_requirement_id`, `Course`.`country_id`, `Course`.`university_id`, `Course`.`course_type_id`, `Course`.`course_lavel_id`, `Course`.`specialisation_id`, `Course`.`name`, `Course`.`banner_image`, `Course`.`image_file`, `Course`.`description`, `Course`.`short_descrption`, `Course`.`display_home_page`, `Course`.`overview`, `Course`.`job_oportunity`, `Course`.`adminssion_requirment`, `Course`.`active`, `Course`.`duration`, `Course`.`intake`, `Course`.`processing_time`, `Course`.`total_tuition_fee`, `Course`.`annual_cost_living`, `Course`.`application_fee`, `Course`.`page_slug`, `Course`.`canonical_url`, `Course`.`page_url`, `Course`.`display_order_in_university`, `Course`.`created`, `Course`.`modified` FROM `osedu`.`courses` AS `Course` WHERE `Course`.`university_id` = (2) LIMIT 2 | 2 | 2 | 0 | |
SELECT `Intake`.`id`, `Intake`.`month`, `Intake`.`active`, `Intake`.`created`, `Intake`.`modified`, `CoursesIntake`.`id`, `CoursesIntake`.`course_id`, `CoursesIntake`.`intake_id` FROM `osedu`.`intakes` AS `Intake` JOIN `osedu`.`courses_intakes` AS `CoursesIntake` ON (`CoursesIntake`.`course_id` IN (1, 3) AND `CoursesIntake`.`intake_id` = `Intake`.`id`) | 3 | 3 | 0 | |
SELECT `Course`.`id`, `Course`.`english_language_requirement_id`, `Course`.`country_id`, `Course`.`university_id`, `Course`.`course_type_id`, `Course`.`course_lavel_id`, `Course`.`specialisation_id`, `Course`.`name`, `Course`.`banner_image`, `Course`.`image_file`, `Course`.`description`, `Course`.`short_descrption`, `Course`.`display_home_page`, `Course`.`overview`, `Course`.`job_oportunity`, `Course`.`adminssion_requirment`, `Course`.`active`, `Course`.`duration`, `Course`.`intake`, `Course`.`processing_time`, `Course`.`total_tuition_fee`, `Course`.`annual_cost_living`, `Course`.`application_fee`, `Course`.`page_slug`, `Course`.`canonical_url`, `Course`.`page_url`, `Course`.`display_order_in_university`, `Course`.`created`, `Course`.`modified` FROM `osedu`.`courses` AS `Course` WHERE `Course`.`university_id` = (3) LIMIT 2 | 2 | 2 | 0 | |
SELECT `Intake`.`id`, `Intake`.`month`, `Intake`.`active`, `Intake`.`created`, `Intake`.`modified`, `CoursesIntake`.`id`, `CoursesIntake`.`course_id`, `CoursesIntake`.`intake_id` FROM `osedu`.`intakes` AS `Intake` JOIN `osedu`.`courses_intakes` AS `CoursesIntake` ON (`CoursesIntake`.`course_id` IN (7, 8) AND `CoursesIntake`.`intake_id` = `Intake`.`id`) | 2 | 2 | 0 | |
SELECT `Course`.`id`, `Course`.`english_language_requirement_id`, `Course`.`country_id`, `Course`.`university_id`, `Course`.`course_type_id`, `Course`.`course_lavel_id`, `Course`.`specialisation_id`, `Course`.`name`, `Course`.`banner_image`, `Course`.`image_file`, `Course`.`description`, `Course`.`short_descrption`, `Course`.`display_home_page`, `Course`.`overview`, `Course`.`job_oportunity`, `Course`.`adminssion_requirment`, `Course`.`active`, `Course`.`duration`, `Course`.`intake`, `Course`.`processing_time`, `Course`.`total_tuition_fee`, `Course`.`annual_cost_living`, `Course`.`application_fee`, `Course`.`page_slug`, `Course`.`canonical_url`, `Course`.`page_url`, `Course`.`display_order_in_university`, `Course`.`created`, `Course`.`modified` FROM `osedu`.`courses` AS `Course` WHERE `Course`.`university_id` = (4) LIMIT 2 | 2 | 2 | 0 | |
SELECT `Intake`.`id`, `Intake`.`month`, `Intake`.`active`, `Intake`.`created`, `Intake`.`modified`, `CoursesIntake`.`id`, `CoursesIntake`.`course_id`, `CoursesIntake`.`intake_id` FROM `osedu`.`intakes` AS `Intake` JOIN `osedu`.`courses_intakes` AS `CoursesIntake` ON (`CoursesIntake`.`course_id` IN (10, 11) AND `CoursesIntake`.`intake_id` = `Intake`.`id`) | 3 | 3 | 0 | |
SELECT COUNT(*) AS `count` FROM `osedu`.`universities` AS `University` LEFT JOIN `osedu`.`countries` AS `Country` ON (`University`.`country_id` = `Country`.`id`) LEFT JOIN `osedu`.`institution_types` AS `InstitutionType` ON (`University`.`institution_type_id` = `InstitutionType`.`id`) WHERE `University`.`active` IN (1) | 1 | 1 | 0 | |
SELECT `Course`.`id`, `Course`.`english_language_requirement_id`, `Course`.`country_id`, `Course`.`university_id`, `Course`.`course_type_id`, `Course`.`course_lavel_id`, `Course`.`specialisation_id`, `Course`.`name`, `Course`.`banner_image`, `Course`.`image_file`, `Course`.`description`, `Course`.`short_descrption`, `Course`.`display_home_page`, `Course`.`overview`, `Course`.`job_oportunity`, `Course`.`adminssion_requirment`, `Course`.`active`, `Course`.`duration`, `Course`.`intake`, `Course`.`processing_time`, `Course`.`total_tuition_fee`, `Course`.`annual_cost_living`, `Course`.`application_fee`, `Course`.`page_slug`, `Course`.`canonical_url`, `Course`.`page_url`, `Course`.`display_order_in_university`, `Course`.`created`, `Course`.`modified` FROM `osedu`.`courses` AS `Course` WHERE `Course`.`active` = '1' AND `Course`.`university_id` IS NOT NULL AND `Course`.`id` NOT IN (2,4,1,3,7,8,10,11) | 3 | 3 | 0 | |
SELECT `Intake`.`id`, `Intake`.`month`, `Intake`.`active`, `Intake`.`created`, `Intake`.`modified`, `CoursesIntake`.`id`, `CoursesIntake`.`course_id`, `CoursesIntake`.`intake_id` FROM `osedu`.`intakes` AS `Intake` JOIN `osedu`.`courses_intakes` AS `CoursesIntake` ON (`CoursesIntake`.`course_id` IN (5, 6, 9) AND `CoursesIntake`.`intake_id` = `Intake`.`id`) | 4 | 4 | 0 | |
SELECT `InstitutionType`.`id`, `InstitutionType`.`title`, `InstitutionType`.`active`, `InstitutionType`.`created`, `InstitutionType`.`modified` FROM `osedu`.`institution_types` AS `InstitutionType` WHERE `InstitutionType`.`active` = '1' ORDER BY `InstitutionType`.`id` ASC | 3 | 3 | 0 | |
SELECT `CourseLavel`.`id`, `CourseLavel`.`title`, `CourseLavel`.`active`, `CourseLavel`.`created`, `CourseLavel`.`modified` FROM `osedu`.`course_lavels` AS `CourseLavel` WHERE `CourseLavel`.`active` = '1' ORDER BY `CourseLavel`.`title` ASC | 9 | 9 | 2 | maybe slow |
SELECT `Specialisation`.`id`, `Specialisation`.`title`, `Specialisation`.`active`, `Specialisation`.`created`, `Specialisation`.`modified` FROM `osedu`.`specialisations` AS `Specialisation` WHERE `Specialisation`.`active` = '1' ORDER BY `Specialisation`.`id` ASC | 9 | 9 | 1 | maybe slow |
SELECT `Country`.`id`, `Country`.`name` FROM `osedu`.`countries` AS `Country` WHERE `Country`.`active` = '1' ORDER BY `Country`.`display_order` ASC | 5 | 5 | 0 | |