Universitat de Lleida

0
Following
0
Follower
Follow
(default) 5 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 1001
2SELECT `Configuration`.`id`, `Configuration`.`heading`, `Configuration`.`default_header`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `1337iot`.`configurations` AS `Configuration` WHERE 1 = 128280
3SELECT `Cmspages`.`name`, `Cmspages`.`seourl` FROM `1337iot`.`cmspages` AS `Cmspages` WHERE `Cmspages`.`showinfooter` = '1' AND `Cmspages`.`status` = '1' ORDER BY `Cmspages`.`name` ASC550
4SELECT `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` = 84111
5SELECT (select count(*) from followers where user_id=84) AS `Follower__Followers`, (select count(*) from followers where follower_id=84) 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 1110