| 1 | SELECT `Advertiser`.`id`, `Advertiser`.`title`, `Advertiser`.`description`, `Advertiser`.`link`, `Advertiser`.`button_title`, `Advertiser`.`logo`, `Advertiser`.`logo_blob`, `Advertiser`.`status`, `Advertiser`.`created`, `Advertiser`.`modified` FROM `1337iot`.`advertisers` AS `Advertiser` WHERE `status` = 1 ORDER BY rand() ASC LIMIT 1 | | 0 | 0 | 1 |
| 2 | SELECT `Configuration`.`id`, `Configuration`.`heading`, `Configuration`.`default_header`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `1337iot`.`configurations` AS `Configuration` WHERE 1 = 1 | | 28 | 28 | 0 |
| 3 | SELECT `Cmspages`.`name`, `Cmspages`.`seourl` FROM `1337iot`.`cmspages` AS `Cmspages` WHERE `Cmspages`.`showinfooter` = '1' AND `Cmspages`.`status` = '1' ORDER BY `Cmspages`.`name` ASC | | 5 | 5 | 0 |
| 4 | SELECT `Course`.*, `Userdetail`.`user_id`, `Userdetail`.`first_name`, `Userdetail`.`last_name`, (select count(*) from user_learning_courses CourseLearning where `CourseLearning`.`course_id` = `Course`.`id`) AS `Course__students`, (select avg(`CourseReview`.`rating`) from course_reviews CourseReview where `CourseReview`.`course_id` = `Course`.`id`) AS `Course__avgrating`, `Course`.`id` FROM `1337iot`.`courses` AS `Course` LEFT JOIN `1337iot`.`users` AS `User` ON (`Course`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`languages` AS `Language` ON (`Course`.`language_id` = `Language`.`id`) LEFT JOIN `1337iot`.`instruction_levels` AS `InstructionLevel` ON (`Course`.`instruction_level_id` = `InstructionLevel`.`id`) LEFT JOIN `1337iot`.`userdetails` AS `Userdetail` ON (`Course`.`user_id` = `Userdetail`.`user_id`) WHERE `Course`.`visibility` = 'Public' AND `Course`.`status` = '1' AND `Course`.`publishstatus` = 'Publish' ORDER BY `Course`.`modified` desc LIMIT 10 | | 10 | 10 | 0 |
| 5 | SELECT COUNT(*) AS `count` FROM `1337iot`.`courses` AS `Course` LEFT JOIN `1337iot`.`users` AS `User` ON (`Course`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`languages` AS `Language` ON (`Course`.`language_id` = `Language`.`id`) LEFT JOIN `1337iot`.`instruction_levels` AS `InstructionLevel` ON (`Course`.`instruction_level_id` = `InstructionLevel`.`id`) WHERE `Course`.`visibility` = 'Public' AND `Course`.`status` = '1' AND `Course`.`publishstatus` = 'Publish' | | 1 | 1 | 0 |
| 6 | SELECT `Category`.`id`, `Category`.`title` FROM `1337iot`.`categories` AS `Category` WHERE `Category`.`status`=1 ORDER BY `Category`.`sort` ASC, `Category`.`title` ASC | | 34 | 34 | 0 |
| 7 | SELECT `Language`.`id`, `Language`.`title` FROM `1337iot`.`languages` AS `Language` WHERE `Language`.`status`=1 ORDER BY `Language`.`title` asc | | 41 | 41 | 0 |
