Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `BusinessType`.`id`, `BusinessType`.`bussiness_type`, `BusinessType`.`icon_class`, `BusinessType`.`total_listing`, `BusinessType`.`status` FROM `181733-thaiistockholm`.`business_types` AS `BusinessType` WHERE 1 = 1 | 4 | 4 | 2 | maybe slow |
SELECT `UbmBanner`.`type_id` FROM `181733-thaiistockholm`.`ubm_banners` AS `UbmBanner` WHERE `type_id` = 2 AND `status` = 1 ORDER BY rand() ASC LIMIT 1 | 0 | 0 | 7 | maybe slow |
SELECT `UbmBanner`.`type_id` FROM `181733-thaiistockholm`.`ubm_banners` AS `UbmBanner` WHERE `status` = 1 AND `type_id` = 3 ORDER BY rand() ASC LIMIT 5 | 0 | 0 | 6 | maybe slow |
SELECT `Configuration`.`key`, `Configuration`.`value` FROM `181733-thaiistockholm`.`configurations` AS `Configuration` WHERE 1 = 1 | 7 | 7 | 2 | maybe slow |
SELECT `Registration`.*, `City`.`city_name` FROM `181733-thaiistockholm`.`registrations` AS `Registration` LEFT JOIN `181733-thaiistockholm`.`cities` AS `City` ON (`Registration`.`cityname`=`City`.`id`) WHERE `Registration`.`alias` = 'janista-spa' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Service`.`id`, `Service`.`user_id`, `Service`.`services`, `Service`.`price`, `Service`.`cdate` FROM `181733-thaiistockholm`.`services` AS `Service` WHERE `user_id` = 13 | 4 | 4 | 5 | maybe slow |
SELECT `Registration`.*, `City`.`city_name`, `BusinessType`.`bussiness_type` FROM `181733-thaiistockholm`.`registrations` AS `Registration` LEFT JOIN `181733-thaiistockholm`.`cities` AS `City` ON (`Registration`.`cityname`=`City`.`id`) INNER JOIN `181733-thaiistockholm`.`business_types` AS `BusinessType` ON (`BusinessType`.`id`=`Registration`.`businesstype`) WHERE `Registration`.`businesstype` = 1 AND `Registration`.`status` = 2 AND NOT (`Registration`.`id` = 13) ORDER BY `featured` DESC LIMIT 4 | 4 | 4 | 5 | maybe slow |
SELECT `Review`.*, `Registration`.* FROM `181733-thaiistockholm`.`reviews` AS `Review` LEFT JOIN `181733-thaiistockholm`.`registrations` AS `Registration` ON (`Registration`.`id`=`Review`.`reviewer_id`) WHERE `company_id` = 13 AND `Review`.`status` = 1 ORDER BY `Review`.`user_type` DESC | 0 | 0 | 5 | maybe slow |
SELECT SUM(`Review`.`stars`) as stars FROM `181733-thaiistockholm`.`reviews` AS `Review` WHERE `Review`.`company_id` = 13 AND `Review`.`status` = 1 | 1 | 1 | 4 | maybe slow |
SELECT `Service`.`id`, `Service`.`user_id`, `Service`.`services`, `Service`.`price`, `Service`.`cdate` FROM `181733-thaiistockholm`.`services` AS `Service` WHERE `user_id` = 1 | 2 | 2 | 5 | maybe slow |
SELECT `Service`.`id`, `Service`.`user_id`, `Service`.`services`, `Service`.`price`, `Service`.`cdate` FROM `181733-thaiistockholm`.`services` AS `Service` WHERE `user_id` = 3 | 5 | 5 | 5 | |
SELECT `Service`.`id`, `Service`.`user_id`, `Service`.`services`, `Service`.`price`, `Service`.`cdate` FROM `181733-thaiistockholm`.`services` AS `Service` WHERE `user_id` = 4 | 6 | 6 | 5 | maybe slow |
SELECT `Service`.`id`, `Service`.`user_id`, `Service`.`services`, `Service`.`price`, `Service`.`cdate` FROM `181733-thaiistockholm`.`services` AS `Service` WHERE `user_id` = 5 | 4 | 4 | 7 | maybe slow |
SELECT `Cms`.`title`, `Cms`.`alias` FROM `181733-thaiistockholm`.`cms` AS `Cms` WHERE `Cms`.`alias` = ('termsconditions') AND `status` = 1 LIMIT 1 | 1 | 1 | 1 | |