| 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.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`.`defaults` = '1'
AND `mc`.`status` = 1
LIMIT 1
|
| 0.0005 |
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`.`location_id` = '233'
AND `l`.`status` = 1
LIMIT 1
|
| 0.0005 |
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` = '1'
AND `c`.`status` = 1
LIMIT 1
|
| 0.0169 |
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` = '1'
AND `l`.`status` = 1
|
| 0.0011 |
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` = '1'
AND `p`.`status` = 1
AND `c`.`status` = 1
AND `ci`.`status` = 1
|
| 0.0166 |
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` = '1'
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 `mc`.`main_category_id`, `mc`.`main_category_name`, `mc`.`main_category_image`, `mc`.`slug_url`
FROM (`vendor_services` as vs)
JOIN `main_category` as mc ON `mc`.`main_category_id` = `vs`.`services_id`
WHERE `vs`.`vendor_id` = '26'
LIMIT 5
|
| 0.0010 |
SELECT *
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '26'
AND `r`.`vbd_id` = '3'
AND `r`.`status` = 1
ORDER BY `r`.`rating_id` DESC
LIMIT 2
|
| 0.0004 |
SELECT AVG(r.rate) as average_rate
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '26'
AND `r`.`status` = 1
ORDER BY `r`.`rating_id` DESC
|
| 0.0004 |
SELECT count(r.rating_id) as totalCountRate
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '26'
AND `r`.`status` = 1
ORDER BY `r`.`rating_id` DESC
|
| 0.0004 |
SELECT `mc`.`main_category_id`, `mc`.`main_category_name`, `mc`.`main_category_image`, `mc`.`slug_url`
FROM (`vendor_services` as vs)
JOIN `main_category` as mc ON `mc`.`main_category_id` = `vs`.`services_id`
WHERE `vs`.`vendor_id` = '27'
LIMIT 5
|
| 0.0010 |
SELECT *
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '27'
AND `r`.`vbd_id` = '4'
AND `r`.`status` = 1
ORDER BY `r`.`rating_id` DESC
LIMIT 2
|
| 0.0004 |
SELECT AVG(r.rate) as average_rate
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '27'
AND `r`.`status` = 1
ORDER BY `r`.`rating_id` DESC
|
| 0.0004 |
SELECT count(r.rating_id) as totalCountRate
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '27'
AND `r`.`status` = 1
ORDER BY `r`.`rating_id` DESC
|
| 0.0004 |
SELECT `mc`.`main_category_id`, `mc`.`main_category_name`, `mc`.`main_category_image`, `mc`.`slug_url`
FROM (`vendor_services` as vs)
JOIN `main_category` as mc ON `mc`.`main_category_id` = `vs`.`services_id`
WHERE `vs`.`vendor_id` = '21'
LIMIT 5
|
| 0.0010 |
SELECT *
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '21'
AND `r`.`vbd_id` = '1'
AND `r`.`status` = 1
ORDER BY `r`.`rating_id` DESC
LIMIT 2
|
| 0.0004 |
SELECT AVG(r.rate) as average_rate
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '21'
AND `r`.`status` = 1
ORDER BY `r`.`rating_id` DESC
|
| 0.0004 |
SELECT count(r.rating_id) as totalCountRate
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '21'
AND `r`.`status` = 1
ORDER BY `r`.`rating_id` DESC
|
| 0.0016 |
SELECT `title`, `slug_url`, `is_popular`, `location_name`
FROM (`location`)
WHERE ( city_id = 1 )
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_location_id` = '233'
AND `vb`.`br_city_id` = '1'
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_location_id` = '233'
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 `location_id` = '233'
AND `main_category_id` = '7'
AND `state_id` = '0'
AND `city_id` = '0'
AND `status` = 1
|
| 0.0003 |
SELECT `faq_id`, `question`, `answer`
FROM (`faq`)
WHERE `location_id` = '233'
AND `main_category_id` = '7'
AND `state_id` = '0'
AND `city_id` = '0'
AND `status` = 1
|
| 0.0009 |
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_location_id` = '233'
AND `r`.`status` = 1
GROUP BY `r`.`rating_id`
ORDER BY `r`.`added_on` DESC
LIMIT 9
|
| 0.0017 |
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.0008 |
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.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.0006 |
SELECT `title`, `slug_url`, `is_popular`
FROM (`city`)
WHERE `is_popular` = '1'
AND `status` = 1
ORDER BY RAND()
|
| 0.0024 |
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.0017 |
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
|
