CompuWorks is a collaborative of computer training specialists with over 25 years’ experience teaching students how to get the most out of their technology tools. CompuWorks innovative elearning videos display trainers on screen all the time creating a learning experience that most closely mimics a traditional classroom.
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
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 `User`.`id`, `User`.`username`, `User`.`loginfrom`, `User`.`status`, `User`.`created`, `User`.`profiletype`, `Userdetail`.`first_name`, `Userdetail`.`user_id`, `Userdetail`.`last_name`, `Userdetail`.`paypalaccount`, `Userdetail`.`about`, `Userdetail`.`city`, `Userdetail`.`phone`, `Userdetail`.`image`, `State`.`name`, `Country`.`name`, `Userdetail`.`biography`, `Userdetail`.`privacy`, (Select count(*) from user_wishlist_courses as Wishlistcourse where `Wishlistcourse`.`user_id` = `Userdetail`.`user_id`) AS `Userdetail__wishlist`, (Select count(`Learningcourse`.`id`) from user_learning_courses as Learningcourse INNER JOIN bundles Bundle ON `Learningcourse`.`bundle_id` = `Bundle`.`id` where `Learningcourse`.`user_id` = `Userdetail`.`user_id` and `Learningcourse`.`completed` = 0 and `Bundle`.`status` = 1) AS `Userdetail__learning`, (Select count(`Learningcourse`.`id`) from user_learning_courses as Learningcourse INNER JOIN bundles Bundle ON `Learningcourse`.`bundle_id` = `Bundle`.`id` where `Learningcourse`.`user_id` = `Userdetail`.`user_id` and `Learningcourse`.`completed` = 1 and `Bundle`.`status` = 1) AS `Userdetail__completed`, (Select count(*) from courses as Course where `Course`.`user_id` = `Userdetail`.`user_id`) AS `Userdetail__countcourse` FROM `1337iot`.`userdetails` AS `Userdetail` LEFT JOIN `1337iot`.`users` AS `User` ON (`Userdetail`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`states` AS `State` ON (`Userdetail`.`state_id` = `State`.`id`) LEFT JOIN `1337iot`.`countries` AS `Country` ON (`Userdetail`.`country_id` = `Country`.`id`) WHERE `User`.`id` = 233 | 1 | 1 | 1 | |
5 | SELECT (select count(*) from followers where user_id=233) AS `Follower__Followers`, (select count(*) from followers where follower_id=233) AS `Follower__Following` FROM `1337iot`.`followers` AS `Follower` LEFT JOIN `1337iot`.`users` AS `User` ON (`Follower`.`user_id` = `User`.`id`) LEFT JOIN `1337iot`.`users` AS `Follow` ON (`Follower`.`follower_id` = `Follow`.`id`) WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 |