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 `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`.`page_slug` = 'study-in-australia' ORDER BY TRIM(`Country`.`name`) ASC LIMIT 1 | 1 | 1 | 1 | |
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`, `Currency`.`id`, `Currency`.`name`, `Currency`.`iso_code`, `Currency`.`iso_code_num`, `Currency`.`sign`, `Currency`.`blank`, `Currency`.`format`, `Currency`.`decimals`, `Currency`.`conversion_rate`, `Currency`.`display_on_frontend`, `Currency`.`active`, `Currency`.`created`, `Currency`.`modified`, (CONCAT(`Currency`.`iso_code`, " - ", `Currency`.`name`)) AS `Currency__title` FROM `osedu`.`countries` AS `Country` LEFT JOIN `osedu`.`currencies` AS `Currency` ON (`Country`.`currency_id` = `Currency`.`id`) WHERE `Country`.`id` = 13 AND `Country`.`active` = '1' ORDER BY TRIM(`Country`.`name`) ASC LIMIT 1 | 0 | 0 | 1 | maybe slow |
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' AND `Country`.`id` != 13 ORDER BY `Country`.`display_order` ASC | 5 | 5 | 1 | maybe slow |