logo
  • Mail Us

    info@plphelp.com

  • Call Us

    +91 - 9729725964

  • GET QUOTE
Royal King Packers and Movers

Royal King Packers and Movers

No.14, 2nd Cross , Sgn Layout., Lalbagh Road,Bangalore

Back

About Us


Website - http://royalkingpackers.in
Year Of Established - 22
No. Of Employees - 58

Work Photos

Reviews and Rating

  • Rajà       Reviewed on 21 Jan 2019

5 months ago I had booked a pack and move service for the 26th of July from Bangalore to Hydarabad . Naresh , the contact person is very professional and assured that my goods would be handled with utmost care which the guys did. None of my belongings …More

  • Raju bhari biran       Reviewed on 20 Jan 2019

Affordable service, easy booking, quick and handy movers. The team was on time, worked really fast and efficiently, packed everything and loaded the truck carefully and with ease. I knew it was going to be a rough move but these guys were absolutely amazing. Their professionalism was evident from their skillful and light-footed steps. I would use their service again and would definitely recommend them.Royal King ???? packers and movers in Bangalore

  • dinesh sharma       Reviewed on 15 Jan 2019

Royal king packers and movers in Bangalore to Chennai Hyderabad mysure mangalore gurgoan Delhi amdhabad puna Delhi combitoore Kerala Cochin all over India door to door packers and movers

  • Murti       Reviewed on 14 Jan 2019

Did not even communicate properly. Was so rude and charging very inappropriately for lowest quality and told me that your budget is low you can find a low quality vendor where on a other hand he is giving least quality product packing. Very rude. Would request not to deal with this mover and packer

  • Sandeep       Reviewed on 13 Jan 2019

Did not even communicate properly. Was so rude and charging very inappropriately for lowest quality and told me that your budget is low you can find a low quality vendor where on a other hand he is giving least quality product packing. Very rude. Would request not to deal with this mover and packer

  • Dinesh       Reviewed on 09 Jan 2019

9 months ago Did not even communicate properly. Was so rude and charging very inappropriately for lowest quality and told me that your budget is low you can find a low quality vendor where on a other hand he is giving least quality product packing. Very rude. Would request not to deal with this mover and packer

  • Randhar       Reviewed on 09 Jan 2019

Did not even communicate properly. Was so rude and charging very inappropriately for lowest quality and told me that your budget is low you can find a low quality vendor where on a other hand he is giving least quality product packing. Very rude. Would request not to deal with this mover and packer

  • Rk reddy       Reviewed on 08 Jan 2019

I recently shifted my house hold stuff from Marathahalli to HSR layout through Packers and Movers Bangalore. All material reached safely on time and intact condition. I will be very happy to use service for my future requirement. Thank You.. Sanjay

  • Sk       Reviewed on 08 Jan 2019

2 months ago Excellent service.from Bangalore to Chennai. Very prompt in responding, reasonable pricing, on time, delivered what was promised. Completely satisfied

  • Subash rajveer       Reviewed on 08 Jan 2019

We had an excellent experience From Book My Trucks. We called a number of different movers knowing that it can be a headache to find a good movers company. These guys came out on top, they were the friendliest and most helpful. The rates were reasonable too. All of the items arrived in perfect condition and the driver/Labour's was very careful when unloading the truck. He was also very polite and professional. I would highly recommend using this company for your household moving needs! Very excellence

  • Rajesh       Reviewed on 05 Jan 2019

Movers and packers very good service Bangalore to Hyderabad packing loading and road and shifting and shifting very good only 2 day shifting storage space for

  • Sanjay       Reviewed on 04 Jan 2019

This packers and movers very good sirvs my house hold banglore to mumbai sipiting only 3 days very good seivesh only 4 parsan packing loding inloding and sating and sipiting . Mr .sanjay choddry contakt parsan

  • Azad       Reviewed on 14 Dec 2018

Royal king packers and movers veiy good sirvs packing loding transport inloding inpacking and sating bng. To hubbli only one days sipting 19000 tho.only very good packers very good name royal king packersand movers

  • S       Reviewed on 12 Dec 2018

This packers and moves royal King packers and Movers my house sipping Bangalore to Pune very good serves only three days ma very much sipting only this packers used

Related Vendors

Popular Locations

dgrtyht Top
  URI STRING  
/royal-king-packers-and-movers-compare-rating-reviews-charges
  CLASS/METHOD  
user/search_detail
  MEMORY USAGE  
6,382,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0108
Controller Execution Time ( User / Search Detail )  0.5581
Total Execution Time  0.5690
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  DATABASE:  professionalmoversmws   QUERIES: 135   
0.0009   SELECT `v`.*, (select cc.city_name from city as cc where v.city_id=cc.city_id ) as bc_city_name(select cc.slug_url from city as cc where v.city_id=cc.city_id ) as bc_slug_url
FROM 
(`vendorAS v)
WHERE `v`.`vendor_id` = '24'
AND `v`.`status` = 1
ORDER BY 
`v`.`membership_typeDESCRAND() 
0.0016   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` = '24'
LIMIT 5 
0.0009   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0006   SELECT *
FROM (`location`)
WHERE `location_id` = '228'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0008   SELECT *
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '24'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
0.0005   SELECT AVG(r.rate) as average_rate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '24'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
0.0004   SELECT count(r.rating_id) as totalCountRate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '24'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
0.0004   SELECT *
FROM (`vendor_gallery`)
WHERE `vendor_id` = '24' 
0.0007   SELECT `v`.*, `l`.`location_pincode`
FROM (`vendor_branch_dtlsAS v)
JOIN `location` as ON `v`.`br_location_id` = `l`.`location_id`
WHERE `vendor_id` = '24' 
0.0005   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0005   SELECT *
FROM (`location`)
WHERE `location_id` = '228'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '2' 
0.0005   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0006   SELECT *
FROM (`location`)
WHERE `location_id` = '57'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0005   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '11' 
0.0005   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '8'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '12' 
0.0004   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0006   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0007   SELECT *
FROM (`location`)
WHERE `location_id` = '37'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '13' 
0.0005   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0008   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0005   SELECT *
FROM (`location`)
WHERE `location_id` = '25'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '16' 
0.0004   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0006   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0005   SELECT *
FROM (`location`)
WHERE `location_id` = '13'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '17' 
0.0004   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '2'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '18' 
0.0004   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '44'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '19' 
0.0004   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0005   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0006   SELECT *
FROM (`location`)
WHERE `location_id` = '25'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0005   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '28' 
0.0006   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0005   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0006   SELECT *
FROM (`location`)
WHERE `location_id` = '44'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0005   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '29' 
0.0006   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0023   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '212'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '30' 
0.0004   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '110'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0003   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '31' 
0.0004   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '27'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '32' 
0.0006   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '16'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '33' 
0.0004   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0008   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '13'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '34' 
0.0004   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '34'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0004   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '36' 
0.0005   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0007   SELECT *
FROM (`location`)
WHERE `location_id` = '165'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0005   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '37' 
0.0006   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0008   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '63'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0006   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '38' 
0.0007   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '152'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0003   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '39' 
0.0004   SELECT *
FROM (`city`)
WHERE `status` = 1
AND `state_id` = '1'
AND `city_id` = '1'
ORDER BY `city_nameasc 
0.0004   SELECT *
FROM (`state`)
WHERE `status` = 1
AND `country_id` = '1'
AND `state_id` = '1'
ORDER BY `state_nameasc 
0.0004   SELECT *
FROM (`location`)
WHERE `location_id` = '18'
AND `city_id` = '1'
AND `status` = 1
ORDER BY 
`location_nameasc 
0.0003   SELECT *
FROM (`vendor_branch_working`)
WHERE `vbd_id` = '66' 
0.3416   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 
(`vendorAS v)
JOIN `vendor_branch_dtls` as vb ON `vb`.`vendor_id` = `v`.`vendor_id`
JOIN `country` as ON `c`.`country_id` = `vb`.`br_country_id`
JOIN `state` as ON `s`.`state_id` = `vb`.`br_state_id`
JOIN `city` as ci ON `ci`.`city_id` = `vb`.`br_city_id`
JOIN `location` as 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`.`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_typeDESC, `ratingAdded_onDESC
LIMIT 9 
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.0014   SELECT *
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '26'
AND `r`.`vbd_id` = '3'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC
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_idDESC 
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_idDESC 
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_idDESC
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_idDESC 
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_idDESC 
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_idDESC
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_idDESC 
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_idDESC 
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` = '255'
LIMIT 5 
0.0010   SELECT *
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '255'
AND `r`.`vbd_id` = '185'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC
LIMIT 2 
0.0004   SELECT AVG(r.rate) as average_rate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '255'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
0.0004   SELECT count(r.rating_id) as totalCountRate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '255'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
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` = '396'
LIMIT 5 
0.0010   SELECT *
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '396'
AND `r`.`vbd_id` = '372'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC
LIMIT 2 
0.0004   SELECT AVG(r.rate) as average_rate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '396'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
0.0004   SELECT count(r.rating_id) as totalCountRate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '396'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
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` = '28'
LIMIT 5 
0.0010   SELECT *
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '28'
AND `r`.`vbd_id` = '7'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC
LIMIT 2 
0.0004   SELECT AVG(r.rate) as average_rate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '28'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
0.0004   SELECT count(r.rating_id) as totalCountRate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '28'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
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` = '180'
LIMIT 5 
0.0010   SELECT *
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '180'
AND `r`.`vbd_id` = '112'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC
LIMIT 2 
0.0735   SELECT AVG(r.rate) as average_rate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '180'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
0.0007   SELECT count(r.rating_id) as totalCountRate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '180'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
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` = '218'
LIMIT 5 
0.0012   SELECT *
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '218'
AND `r`.`vbd_id` = '150'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC
LIMIT 2 
0.0006   SELECT AVG(r.rate) as average_rate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '218'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
0.0005   SELECT count(r.rating_id) as totalCountRate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '218'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
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` = '36'
LIMIT 5 
0.0015   SELECT *
FROM (`rating` as r)
WHERE `r`.`vendor_id` = '36'
AND `r`.`vbd_id` = '46'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC
LIMIT 2 
0.0006   SELECT AVG(r.rate) as average_rate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '36'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
0.0006   SELECT count(r.rating_id) as totalCountRate
FROM 
(`rating` as r)
WHERE `r`.`vendor_id` = '36'
AND `r`.`status` = 1
ORDER BY 
`r`.`rating_idDESC 
0.0029   SELECT `title`, `slug_url`, `is_popular`, `location_name`
FROM (`location`)
WHERE ( city_id )
AND `
is_popular` = '1'
AND `status` = 1
ORDER BY RAND
() 
0.0010   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 (`stateAS s)
WHERE `s`.`status` = 
0.0007   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_categoryAS mc)
WHERE `mc`.`status` = 
0.0008   SELECT `title`, `slug_url`, `is_popular`
FROM (`city`)
WHERE `is_popular` = '1'
AND `status` = 1
ORDER BY RAND
() 
0.0038   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_cityAS l)
JOIN `city` as ON `c`.`city_id` = `l`.`city_id`
WHERE `l`.`is_popular` = 1
AND `l`.`status` = 
0.0006   SELECT `mc`.`main_category_id`, `mc`.`main_category_name`, `mc`.`main_category_image`, `mc`.`slug_url`
FROM (`main_categoryAS mc)
WHERE `mc`.`status` = 
0.0007   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_categoryAS mc)
WHERE `mc`.`status` = 
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 (`cityAS c)
JOIN `stateAS ON `s`.`state_id`=`c`.`state_id`
WHERE `c`.`status` =