0.0007 |
SELECT `c`.`city_name`, `c`.`city_id`, `c`.`slug_url`, `c`.`meta_title`, `c`.`meta_keyword`, `c`.`meta_description`, `c`.`other_seo_tags`, `c`.`top_h1`, `c`.`top_h2`, `c`.`top_content`, `c`.`bottom_h1`, `c`.`bottom_h2`, `c`.`bottom_content1`, `c`.`bottom_content2`, `c`.`bottom_content3`, `c`.`bottom_content4`, `c`.`bottom_content5`, `c`.`middle_h2` FROM (`city` AS c) JOIN `state` AS s ON `s`.`state_id`=`c`.`state_id` WHERE `city_id` = '4' AND `c`.`status` = 1 LIMIT 1
|
0.0006 |
SELECT `mc`.`main_category_id`, `mc`.`main_category_name`, `mc`.`main_category_image`, `mc`.`slug_url`, `mc`.`meta_title`, `mc`.`meta_keyword`, `mc`.`other_seo_tags`, `mc`.`meta_description`, `mc`.`top_h1`, `mc`.`top_h2`, `mc`.`top_content`, `mc`.`bottom_h1`, `mc`.`bottom_h2`, `mc`.`bottom_content1`, `mc`.`bottom_content2`, `mc`.`bottom_content3`, `mc`.`bottom_content4`, `mc`.`bottom_content5`, `mc`.`category_image`, `mc`.`middle_h2` FROM (`main_category` AS mc) WHERE `mc`.`status` = 1
|
0.0005 |
SELECT `mc`.`main_category_id`, `mc`.`main_category_name`, `mc`.`main_category_image`, `mc`.`slug_url`, `mc`.`meta_title`, `mc`.`meta_keyword`, `mc`.`other_seo_tags`, `mc`.`meta_description`, `mc`.`top_h1`, `mc`.`top_h2`, `mc`.`top_content`, `mc`.`bottom_h1`, `mc`.`bottom_h2`, `mc`.`bottom_content1`, `mc`.`bottom_content2`, `mc`.`bottom_content3`, `mc`.`bottom_content4`, `mc`.`bottom_content5`, `mc`.`category_image`, `mc`.`middle_h2` FROM (`main_category` AS mc) WHERE `mc`.`defaults` = '1' AND `mc`.`status` = 1 LIMIT 1
|
0.0008 |
SELECT `l`.`location_name`, `l`.`location_id`, `l`.`slug_url`, `c`.`city_name`, `l`.`meta_title`, `l`.`meta_keyword`, `l`.`meta_description`, `l`.`other_seo_tags`, `l`.`city_id`, `l`.`top_h1`, `l`.`top_h2`, `l`.`top_content`, `l`.`bottom_h1`, `l`.`bottom_h2`, `l`.`bottom_content1`, `l`.`bottom_content2`, `l`.`bottom_content3`, `l`.`bottom_content4`, `l`.`bottom_content5`, `l`.`middle_h2` FROM (`location` AS l) JOIN `city` as c ON `c`.`city_id` = `l`.`city_id` WHERE `l`.`city_id` = '4' AND `l`.`status` = 1
|
0.0006 |
SELECT `p`.*, `c`.`city_name` as from_city_name, `ci`.`city_name` as to_city_name FROM (`price` AS p) JOIN `city` AS c ON `c`.`city_id`=`p`.`from_city` JOIN `city` AS ci ON `ci`.`city_id`=`p`.`to_city` WHERE `p`.`from_city` = '4' AND `p`.`status` = 1 AND `c`.`status` = 1 AND `ci`.`status` = 1
|
0.0015 |
SELECT DISTINCT(v.vendor_id), `v`.`company_name`, `v`.`send_mail`, `v`.`send_sms`, `v`.`is_number_display`, `v`.`slug_url`, `c`.`country_name`, `s`.`state_name`, `ci`.`city_name`, `l`.`location_name`, `vb`.`br_about_us` as about_us, `v`.`banner_img`, `v`.`logo_image`, `v`.`membership_type`, `v`.`available_transport`, `vb`.`br_mobile`, `v`.`membership_type`, `vb`.`br_company_address`, `vb`.`br_name`, `vb`.`vbd_id`, `vb`.`br_email`, `vb`.`br_google_map`, (select rr.added_on from rating as rr where rr.vendor_id =v.vendor_id order by rr.added_on DESC limit 1 ) as ratingAdded_on FROM (`vendor` AS v) JOIN `vendor_branch_dtls` as vb ON `vb`.`vendor_id` = `v`.`vendor_id` JOIN `country` as c ON `c`.`country_id` = `vb`.`br_country_id` JOIN `state` as s ON `s`.`state_id` = `vb`.`br_state_id` JOIN `city` as ci ON `ci`.`city_id` = `vb`.`br_city_id` JOIN `location` as l ON `l`.`location_id` = `vb`.`br_location_id` JOIN `vendor_services` as vs ON `vs`.`vendor_id` = `v`.`vendor_id` JOIN `main_category` as mc ON `mc`.`main_category_id`= `vs`.`services_id` WHERE `vb`.`br_city_id` = '4' AND `v`.`membership_type` = 2 AND `v`.`status` = 1 AND `c`.`status` = 1 AND `s`.`status` = 1 AND `ci`.`status` = 1 AND `l`.`status` = 1 GROUP BY `v`.`vendor_id` ORDER BY `v`.`membership_type` DESC, RAND(), `ratingAdded_on` DESC
|
0.0005 |
SELECT `title`, `slug_url`, `is_popular`, `location_name` FROM (`location`) WHERE ( city_id = 4 ) AND `is_popular` = '1' AND `status` = 1 ORDER BY RAND()
|
0.0014 |
SELECT DISTINCT(v.vendor_id), `v`.`company_name`, `v`.`send_mail`, `v`.`send_sms`, `v`.`is_number_display`, `v`.`slug_url`, `c`.`country_name`, `s`.`state_name`, `ci`.`city_name`, `l`.`location_name`, `vb`.`br_about_us` as about_us, `v`.`banner_img`, `v`.`logo_image`, `v`.`membership_type`, `v`.`available_transport`, `vb`.`br_mobile`, `v`.`membership_type`, `vb`.`br_company_address`, `vb`.`br_name`, `vb`.`vbd_id`, `vb`.`br_email`, `vb`.`br_google_map`, (select rr.added_on from rating as rr where rr.vendor_id =v.vendor_id order by rr.added_on DESC limit 1 ) as ratingAdded_on FROM (`vendor` AS v) JOIN `vendor_branch_dtls` as vb ON `vb`.`vendor_id` = `v`.`vendor_id` JOIN `country` as c ON `c`.`country_id` = `vb`.`br_country_id` JOIN `state` as s ON `s`.`state_id` = `vb`.`br_state_id` JOIN `city` as ci ON `ci`.`city_id` = `vb`.`br_city_id` JOIN `location` as l ON `l`.`location_id` = `vb`.`br_location_id` JOIN `vendor_services` as vs ON `vs`.`vendor_id` = `v`.`vendor_id` JOIN `main_category` as mc ON `mc`.`main_category_id`= `vs`.`services_id` WHERE `vb`.`br_city_id` = '4' AND `v`.`status` = 1 AND `c`.`status` = 1 AND `s`.`status` = 1 AND `ci`.`status` = 1 AND `l`.`status` = 1 GROUP BY `v`.`vendor_id` ORDER BY `v`.`membership_type` DESC, `ratingAdded_on` DESC LIMIT 9
|
0.0006 |
SELECT DISTINCT(vb.br_state_id), (select count(r1.rating_id) from rating as r1 where r1.status=1 and r1.vendor_id = v.vendor_id ) as totalCountRate, (select AVG(r2.rate) from rating as r2 where r2.status=1 and r2.vendor_id = v.vendor_id ) as average_rate FROM (`vendor` AS v) JOIN `vendor_branch_dtls` as vb ON `vb`.`vendor_id` = `v`.`vendor_id` JOIN `country` as c ON `c`.`country_id` = `vb`.`br_country_id` JOIN `state` as s ON `s`.`state_id` = `vb`.`br_state_id` JOIN `city` as ci ON `ci`.`city_id` = `vb`.`br_city_id` JOIN `location` as l ON `l`.`location_id` = `vb`.`br_location_id` JOIN `vendor_services` as vs ON `vs`.`vendor_id` = `v`.`vendor_id` JOIN `main_category` as mc ON `mc`.`main_category_id`= `vs`.`services_id` WHERE `vb`.`br_city_id` = '4' AND `v`.`status` = 1 AND `c`.`status` = 1 AND `s`.`status` = 1 AND `ci`.`status` = 1 AND `l`.`status` = 1
|
0.0004 |
SELECT `moving_tips_id`, `question`, `answer` FROM (`moving_tips`) WHERE `city_id` = '4' AND `main_category_id` = '7' AND `state_id` = '0' AND `location_id` = '0' AND `status` = 1
|
0.0003 |
SELECT `faq_id`, `question`, `answer` FROM (`faq`) WHERE `city_id` = '4' AND `main_category_id` = '7' AND `state_id` = '0' AND `location_id` = '0' AND `status` = 1
|
0.0008 |
SELECT `r`.`rating_id`, `r`.`rate`, `r`.`name`, `r`.`remarks`, `r`.`added_on`, `v`.`company_name` FROM (`rating` as r) JOIN `vendor` as v ON `v`.`vendor_id` = `r`.`vendor_id` JOIN `vendor_branch_dtls` as vb ON `vb`.`vendor_id` = `v`.`vendor_id` JOIN `country` as c ON `c`.`country_id` = `vb`.`br_country_id` JOIN `state` as s ON `s`.`state_id` = `vb`.`br_state_id` JOIN `city` as ci ON `ci`.`city_id` = `vb`.`br_city_id` JOIN `location` as l ON `l`.`location_id` = `vb`.`br_location_id` JOIN `vendor_services` as vs ON `vs`.`vendor_id` = `v`.`vendor_id` WHERE `r`.`vbd_id` = 0 AND `vb`.`br_city_id` = '4' AND `r`.`status` = 1 GROUP BY `r`.`rating_id` ORDER BY `r`.`added_on` DESC LIMIT 9
|
0.0015 |
SELECT `c`.`city_name`, `c`.`city_id`, `c`.`slug_url`, `c`.`meta_title`, `c`.`meta_keyword`, `c`.`meta_description`, `c`.`other_seo_tags`, `c`.`top_h1`, `c`.`top_h2`, `c`.`top_content`, `c`.`bottom_h1`, `c`.`bottom_h2`, `c`.`bottom_content1`, `c`.`bottom_content2`, `c`.`bottom_content3`, `c`.`bottom_content4`, `c`.`bottom_content5`, `c`.`middle_h2` FROM (`city` AS c) JOIN `state` AS s ON `s`.`state_id`=`c`.`state_id` WHERE `c`.`status` = 1
|
0.0007 |
SELECT `s`.`state_name`, `s`.`state_id`, `s`.`slug_url`, `s`.`meta_title`, `s`.`meta_keyword`, `s`.`meta_description`, `s`.`other_seo_tags`, `s`.`top_h1`, `s`.`top_h2`, `s`.`top_content`, `s`.`bottom_h1`, `s`.`bottom_h2`, `s`.`bottom_content1`, `s`.`bottom_content2`, `s`.`bottom_content3`, `s`.`bottom_content4`, `s`.`bottom_content5`, `s`.`middle_h2` FROM (`state` AS s) WHERE `s`.`status` = 1
|
0.0005 |
SELECT `mc`.`main_category_id`, `mc`.`main_category_name`, `mc`.`main_category_image`, `mc`.`slug_url`, `mc`.`meta_title`, `mc`.`meta_keyword`, `mc`.`other_seo_tags`, `mc`.`meta_description`, `mc`.`top_h1`, `mc`.`top_h2`, `mc`.`top_content`, `mc`.`bottom_h1`, `mc`.`bottom_h2`, `mc`.`bottom_content1`, `mc`.`bottom_content2`, `mc`.`bottom_content3`, `mc`.`bottom_content4`, `mc`.`bottom_content5`, `mc`.`category_image`, `mc`.`middle_h2` FROM (`main_category` AS mc) WHERE `mc`.`status` = 1
|
0.0005 |
SELECT `title`, `slug_url`, `is_popular` FROM (`city`) WHERE `is_popular` = '1' AND `status` = 1 ORDER BY RAND()
|
0.0019 |
SELECT `l`.`location_name`, `l`.`from_to_city_id`, `l`.`slug_url`, `l`.`title`, `c`.`city_name`, `l`.`meta_title`, `l`.`meta_keyword`, `l`.`meta_description`, `l`.`other_seo_tags`, `l`.`city_id`, `l`.`top_h1`, `l`.`top_h2`, `l`.`top_content`, `l`.`bottom_h1`, `l`.`bottom_h2`, `l`.`bottom_content1`, `l`.`bottom_content2`, `l`.`bottom_content3`, `l`.`bottom_content4`, `l`.`bottom_content5`, `l`.`middle_h2` FROM (`from_to_city` AS l) JOIN `city` as c ON `c`.`city_id` = `l`.`city_id` WHERE `l`.`is_popular` = 1 AND `l`.`status` = 1
|
0.0004 |
SELECT `mc`.`main_category_id`, `mc`.`main_category_name`, `mc`.`main_category_image`, `mc`.`slug_url` FROM (`main_category` AS mc) WHERE `mc`.`status` = 1
|
0.0004 |
SELECT `mc`.`main_category_id`, `mc`.`main_category_name`, `mc`.`main_category_image`, `mc`.`slug_url`, `mc`.`meta_title`, `mc`.`meta_keyword`, `mc`.`other_seo_tags`, `mc`.`meta_description`, `mc`.`top_h1`, `mc`.`top_h2`, `mc`.`top_content`, `mc`.`bottom_h1`, `mc`.`bottom_h2`, `mc`.`bottom_content1`, `mc`.`bottom_content2`, `mc`.`bottom_content3`, `mc`.`bottom_content4`, `mc`.`bottom_content5`, `mc`.`category_image`, `mc`.`middle_h2` FROM (`main_category` AS mc) WHERE `mc`.`status` = 1
|
0.0013 |
SELECT `c`.`city_name`, `c`.`city_id`, `c`.`slug_url`, `c`.`meta_title`, `c`.`meta_keyword`, `c`.`meta_description`, `c`.`other_seo_tags`, `c`.`top_h1`, `c`.`top_h2`, `c`.`top_content`, `c`.`bottom_h1`, `c`.`bottom_h2`, `c`.`bottom_content1`, `c`.`bottom_content2`, `c`.`bottom_content3`, `c`.`bottom_content4`, `c`.`bottom_content5`, `c`.`middle_h2` FROM (`city` AS c) JOIN `state` AS s ON `s`.`state_id`=`c`.`state_id` WHERE `c`.`status` = 1
|