| 0.0003 |
SELECT `code`, `language`
FROM `site_language`
WHERE `status` = 1
|
| 0.0009 |
SELECT c.id , country_name, c.country_code, IFNULL(ct.name , c.country_name) as display_name , IF( ct.article_varified , IFNULL(ct.text , c.text) , c.text ) as text FROM countries as c LEFT JOIN countries_translations as ct on c.id = ct.country_id and ct.lang_id = 'en' WHERE c.alias = 'guyana'
|
| 0.0004 |
SELECT city_id FROM location_city WHERE country_id = '90'
|
| 0.0004 |
SELECT c.id,c.alias,c.country_id,c.city_name,cont.country_code,c.city_name as translate
FROM cities as c LEFT JOIN countries as cont on cont.id = c.country_id WHERE c.id IN(1600,7822,7823)
|
| 0.0004 |
SELECT meta_keyword,meta_description,meta_title FROM countries WHERE id = '90'
|
| 0.0005 |
select * from pages where alias='guyana-tours-guide'
|
| 0.0004 |
select currency, currency_rate from jobs_currencies
|
| 0.1869 |
SELECT r.id as rid,r.overall,u.facebook_profile_image,gp.tour_guide_id,gp.user_id as rguide_id,u.alias,u.fbid,gp.profile_image,gp.profile_image_thumb,u.first_name,u.last_name,u.id,r.des as review ,u.user_group_id as group_id from users as u join guide_review_table as r on r.guide_id = u.id join guide_profile as gp on gp.user_id = u.id where r.overall = 100 and r.mark_updated = 1 and r.status = 1 and r.rejected=0 and u.user_group_id IN (3,5) and u.active = 1 and u.visible = 1 and u.disabled = 0 and (u.varified=0 or u.fb_login=1) and (gp.city_id IN(90) or gp.other_city_id1 IN(90) or gp.other_city_id2 IN(90) or gp.other_city_id3 IN(90) or gp.other_city_id4 IN(90) or gp.other_city_id5 IN(90) or gp.other_city_id6 IN(90) or gp.other_city_id7 IN(90) or gp.other_city_id8 IN(90) or gp.other_city_id9 IN(90) or gp.other_city_id10 IN(90) or gp.other_city_id11 IN(90) or gp.other_city_id12 IN(90) or gp.other_city_id13 IN(90) or gp.other_city_id14 IN(90) or gp.other_city_id15 IN(90) or gp.other_city_id16 IN(90) or gp.other_city_id17 IN(90) or gp.other_city_id18 IN(90) or gp.other_city_id19 IN(90) or gp.other_city_id20 IN(90) ) GROUP BY u.id ORDER BY r.featured desc,r.id desc limit 0, 3
|
| 0.2092 |
SELECT r.id as rid,r.overall,u.facebook_profile_image,gp.tour_guide_id,gp.user_id as rguide_id,u.alias,u.fbid,gp.profile_image,gp.profile_image_thumb,u.first_name,u.last_name,u.id,r.des as review ,u.user_group_id as group_id from users as u join guide_review_table as r on r.guide_id = u.id join guide_profile as gp on gp.user_id = u.id where r.overall = 100 and r.mark_updated = 1 and r.status = 1 and r.rejected=0 and u.user_group_id IN (3,5) and u.active = 1 and u.visible = 1 and u.disabled = 0 and (u.varified=0 or u.fb_login=1) and (gp.city_id IN(90) or gp.other_city_id1 IN(90) or gp.other_city_id2 IN(90) or gp.other_city_id3 IN(90) or gp.other_city_id4 IN(90) or gp.other_city_id5 IN(90) or gp.other_city_id6 IN(90) or gp.other_city_id7 IN(90) or gp.other_city_id8 IN(90) or gp.other_city_id9 IN(90) or gp.other_city_id10 IN(90) or gp.other_city_id11 IN(90) or gp.other_city_id12 IN(90) or gp.other_city_id13 IN(90) or gp.other_city_id14 IN(90) or gp.other_city_id15 IN(90) or gp.other_city_id16 IN(90) or gp.other_city_id17 IN(90) or gp.other_city_id18 IN(90) or gp.other_city_id19 IN(90) or gp.other_city_id20 IN(90) ) GROUP BY u.id ORDER BY r.featured desc,r.id desc
|
| 0.0010 |
select img.image_url,img.cloudinary_id,agc.url,agc.cloudinary_id as agc_cloudinary,img.thumbnail_url,img.image_name,img.user_name,img.user_link,
l.name as lname,l.url as lurl from user_gallery AS img join users as u on img.user_id=u.id
left join image_lic_table as l on l.id = img.lic_id join admin_gal_crop as agc on agc.img_id = img.id where u.active = 1
and img.is_country_new = 1 and img.country_id IN(90) and (agc.tag_type='is_country_new') ORDER BY RAND() limit 1
|
| 0.0006 |
SELECT *
FROM `tour_types`
|
| 0.0004 |
SELECT *
FROM `langauges`
|
| 0.0006 |
SELECT *
FROM `tour_types`
|
| 0.0003 |
SELECT *
FROM `langauges`
|
| 0.0008 |
SELECT *
FROM `tour_types`
|
| 0.0007 |
select img.image_url,img.cloudinary_id,agc.url,agc.cloudinary_id as agc_cloudinary,img.thumbnail_url,img.image_name,img.user_name,img.user_link,
l.name as lname,l.url as lurl from user_gallery AS img join users as u on img.user_id=u.id
left join image_lic_table as l on l.id = img.lic_id join admin_gal_crop as agc on agc.img_id = img.id where u.active = 1
and img.is_city_new = 1 and img.city_id IN(90) and (agc.tag_type='is_city_new') ORDER BY RAND() limit 1
|
| 0.0007 |
select img.image_url,img.cloudinary_id,agc.url,agc.cloudinary_id as agc_cloudinary,img.thumbnail_url,img.image_name,img.user_name,img.user_link,
l.name as lname,l.url as lurl from user_gallery AS img join users as u on img.user_id=u.id
left join image_lic_table as l on l.id = img.lic_id join admin_gal_crop as agc on agc.img_id = img.id
left join image_location_id as il on il.image_id = img.id where u.active = 1 and
((il.city_id = 90))
and img.is_background_new = 1 and agc.tag_type='is_background_new' ORDER BY RAND() limit 1
|
| 0.0007 |
select img.image_url,img.cloudinary_id,agc.url,agc.cloudinary_id as agc_cloudinary,img.thumbnail_url,img.image_name,img.user_name,img.user_link,
l.name as lname,l.url as lurl from user_gallery AS img join users as u on img.user_id=u.id
left join image_lic_table as l on l.id = img.lic_id join admin_gal_crop as agc on agc.img_id = img.id
where u.active = 1 and img.is_background_new = 1 and agc.tag_type='is_background_new' ORDER BY RAND() limit 1
|
| 0.0094 |
SELECT `t`.*, `c`.`id`
FROM `tkt_products` as `t`
LEFT JOIN `cities` as `c` ON `c`.`id` = `t`.`live_city`
WHERE `c`.`country_id` = '90'
AND `t`.`experiance_type` = 'activity'
AND (`t`.`experiance_sub_type` = 1 OR `t`.`experiance_sub_type` = 3)
AND `t`.`status` = '1'
GROUP BY `t`.`pro_id`
LIMIT 1000
|
| 0.0097 |
SELECT `t`.*, `c`.`id`
FROM `tkt_products` as `t`
LEFT JOIN `cities` as `c` ON `c`.`id` = `t`.`live_city`
WHERE `c`.`country_id` = '90'
AND `t`.`experiance_type` = 'activity'
AND (`t`.`experiance_sub_type` = 1 OR `t`.`experiance_sub_type` = 3)
AND `t`.`status` = '1'
GROUP BY `t`.`pro_id`
LIMIT 40
|
| 0.0889 |
SELECT t.*,gp.tour_guide_id,u.user_group_id FROM tours as t join users as u on u.id = t.guide_id left join guide_profile as gp on gp.user_id=u.id where t.is_active=1 and u.active = 1 and u.visible = 1 and u.disabled = 0 and u.varified = 0 and t.instant_booked_tour='1' and FIND_IN_SET('90',t.covered_countries) order by t.review_count desc limit 500
|
| 0.0074 |
SELECT `t`.*, `c`.`id`
FROM `tkt_products` as `t`
LEFT JOIN `cities` as `c` ON `c`.`id` = `t`.`live_city`
WHERE `c`.`country_id` = '90'
AND `experiance_type` = 'offlineactivity'
AND `t`.`status` = '1'
GROUP BY `t`.`pro_id`
|
| 0.0826 |
SELECT `bet`.*, `tm`.`bokun_guide_title`, `tm`.`is_active`, `tm`.`tour_types`, `tm`.`label_name`, `tm`.`selected_price`, `tm`.`selected_price_type`, `c`.`city`, `c`.`location_type`
FROM `bokun_edit_tours` AS `bet`
JOIN `bokun_tours_manage` AS `tm` ON `tm`.`bokun_id` = `bet`.`b_id`
JOIN `bokun_city_tours` AS `c` ON `c`.`b_id` = `bet`.`b_id`
JOIN `bokun_edit_gallery` AS `gl` ON `gl`.`b_id` = `bet`.`b_id`
JOIN `cities` as `cc` ON `cc`.`id` = `c`.`city`
WHERE `cc`.`country_id` = '90'
AND `tm`.`is_active` = 1
AND `gl`.`tour_images` = '1'
AND `c`.`location_type` = 'c'
GROUP BY `bet`.`b_id`
|
| 0.0734 |
SELECT t.*,gp.tour_guide_id,u.user_group_id FROM tours as t join users as u on u.id = t.guide_id left join guide_profile as gp on gp.user_id=u.id where t.is_active=1 and u.active = 1 and u.visible = 1 and u.disabled = 0 and u.varified = 0 and t.instant_booked_tour='0' and FIND_IN_SET('90',t.covered_countries) order by CASE WHEN u.user_group_id=1 then 0 else 1 end, t.featured desc limit 0 , 1000
|
| 0.0008 |
SELECT `cities_id`
FROM `top_cities_country`
WHERE `c_id` = '90'
|
| 0.1500 |
SELECT t.*,gp.tour_guide_id,u.user_group_id FROM tours as t join users as u on u.id = t.guide_id left join guide_profile as gp on gp.user_id=u.id where t.is_active=1 and u.active = 1 and u.visible = 1 and u.disabled = 0 and u.varified = 0 and t.instant_booked_tour='0' and covered_cities REGEXP CONCAT('(^|,)(', REPLACE('1600, 7581, 7822, 7823', ',', '|'), ')(,|$)') order by CASE WHEN u.user_group_id=1 then 0 else 1 end, t.featured desc limit 0 , 1000
|
| 0.3272 |
select DISTINCT (g.id),g.user_id as guide_id ,g.tour_guide_id,g.about_me,u.alias,u.first_name ,u.facebook_profile_image,u.last_name,u.fbid,g.power,g.persentile,g.profile_bar,g.profile_image_thumb,g.profile_image,g.profile_angle,g.profile_crop,g.is_cloudinery from guide_profile AS g join users as u on g.user_id = u.id where u.active = 1 and u.visible = 1 and u.disabled = 0 and user_group_id=3 and (g.city_id IN(1600,7822,7823) or g.other_city_id1 IN(1600,7822,7823) or g.other_city_id2 IN(1600,7822,7823) or g.other_city_id3 IN(1600,7822,7823) or g.other_city_id4 IN(1600,7822,7823) or g.other_city_id5 IN(1600,7822,7823) or g.other_city_id6 IN(1600,7822,7823) or g.other_city_id7 IN(1600,7822,7823) or g.other_city_id8 IN(1600,7822,7823) or g.other_city_id9 IN(1600,7822,7823) or g.other_city_id10 IN(1600,7822,7823) or g.other_city_id11 IN(1600,7822,7823) or g.other_city_id12 IN(1600,7822,7823) or g.other_city_id13 IN(1600,7822,7823) or g.other_city_id14 IN(1600,7822,7823) or g.other_city_id15 IN(1600,7822,7823) or g.other_city_id16 IN(1600,7822,7823) or g.other_city_id17 IN(1600,7822,7823) or g.other_city_id18 IN(1600,7822,7823) or g.other_city_id19 IN(1600,7822,7823) or g.other_city_id20 IN(1600,7822,7823)) ORDER BY CASE WHEN (persentile >=40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1 and gr.deleted=0 limit 0,1))
THEN (persentile) END DESC,CASE WHEN (persentile >=40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1 and gr.deleted=0 limit 0,1))
THEN (power) END DESC,CASE WHEN (persentile <40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1
and gr.deleted=0 limit 0,1)) THEN (persentile) END asc, CASE WHEN persentile >=40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id != g.user_id
limit 0,1) THEN profile_bar END DESC limit 0, 1000
|
| 0.0844 |
select DISTINCT (g.id),g.user_id as guide_id ,g.tour_guide_id,u.alias,u.first_name ,u.facebook_profile_image,u.last_name,u.fbid,g.power,g.about_me,g.persentile,g.profile_bar,g.profile_image_thumb,g.profile_image,g.profile_angle,g.profile_crop,g.is_cloudinery from guide_profile AS g join users as u on g.user_id = u.id where u.active = 1 and u.visible = 1 and u.disabled = 0 and user_group_id=5 and (g.city_id IN(1600,7822,7823) or g.other_city_id1 IN(1600,7822,7823) or g.other_city_id2 IN(1600,7822,7823) or g.other_city_id3 IN(1600,7822,7823) or g.other_city_id4 IN(1600,7822,7823) or g.other_city_id5 IN(1600,7822,7823) or g.other_city_id6 IN(1600,7822,7823) or g.other_city_id7 IN(1600,7822,7823) or g.other_city_id8 IN(1600,7822,7823) or g.other_city_id9 IN(1600,7822,7823) or g.other_city_id10 IN(1600,7822,7823) or g.other_city_id11 IN(1600,7822,7823) or g.other_city_id12 IN(1600,7822,7823) or g.other_city_id13 IN(1600,7822,7823) or g.other_city_id14 IN(1600,7822,7823) or g.other_city_id15 IN(1600,7822,7823) or g.other_city_id16 IN(1600,7822,7823) or g.other_city_id17 IN(1600,7822,7823) or g.other_city_id18 IN(1600,7822,7823) or g.other_city_id19 IN(1600,7822,7823) or g.other_city_id20 IN(1600,7822,7823) ) ORDER BY CASE WHEN (persentile >=40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1 and gr.deleted=0 limit 0,1))
THEN (persentile) END DESC,CASE WHEN (persentile >=40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1 and gr.deleted=0 limit 0,1))
THEN (power) END DESC,CASE WHEN (persentile <40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1
and gr.deleted=0 limit 0,1)) THEN (persentile) END asc, CASE WHEN (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id != g.user_id
limit 0,1) THEN profile_bar END DESC limit 0, 1000
|
| 0.0057 |
select DISTINCT(a.id) as aid,a.random_image, a.article_image_thumb , IFNULL(at.alias ,a.alias) as alias , a.random_image , IFNULL(at.article_name , a.article_name) as article_name , IFNULL(at.article_short_content , a.article_short_content) as article_short_content,a.is_cloudinery,a.angle,a.crop_option from articles AS a left join article_translation as at on a.id = at.article_id and at.lang_id = 'en' join users as u on a.author_id = u.id join article_location_id al on a.id = al.article_id where u.active = 1 and u.visible = 1 and u.disabled = 0 and (al.city_id IN(90) or (al.city_id=0 and al.country_id = 90)) and a.is_active=1 ORDER BY a.id desc limit 0, 1000
|
| 0.0049 |
SELECT `c`.`city_name`, `c`.`id`, `s`.`c_id`, `c`.`alias` as `cityurl`, `cn`.`alias` as `cnurl`
FROM `cities` as `c`
INNER JOIN `top_cities_country` as `s` ON `s`.`cities_id` = `c`.`id`
LEFT JOIN `countries` as `cn` ON `s`.`c_id` = `cn`.`id`
WHERE `s`.`c_id` = '90'
ORDER BY `s`.`positions` ASC
|
| 0.0006 |
SELECT meta_keyword,meta_description,meta_title FROM cities WHERE id = '1600'
|
| 0.0048 |
select img.image_url,img.cloudinary_id,agc.url,agc.cloudinary_id as agc_cloudinary,img.thumbnail_url,img.image_name,img.user_name,img.user_link,
l.name as lname,l.url as lurl from user_gallery AS img join users as u on img.user_id=u.id
left join image_lic_table as l on l.id = img.lic_id join admin_gal_crop as agc on agc.img_id = img.id where u.active = 1
and img.is_city_new = 1 and img.city_id IN(1600) and (agc.tag_type='is_city_new') ORDER BY RAND() limit 1
|
| 0.0028 |
SELECT meta_keyword,meta_description,meta_title FROM cities WHERE id = '7581'
|
| 0.0006 |
select img.image_url,img.cloudinary_id,agc.url,agc.cloudinary_id as agc_cloudinary,img.thumbnail_url,img.image_name,img.user_name,img.user_link,
l.name as lname,l.url as lurl from user_gallery AS img join users as u on img.user_id=u.id
left join image_lic_table as l on l.id = img.lic_id join admin_gal_crop as agc on agc.img_id = img.id where u.active = 1
and img.is_city_new = 1 and img.city_id IN(7581) and (agc.tag_type='is_city_new') ORDER BY RAND() limit 1
|
| 0.0043 |
select img.image_url,img.cloudinary_id,agc.url,agc.cloudinary_id as agc_cloudinary,img.thumbnail_url,img.image_name,img.user_name,img.user_link,
l.name as lname,l.url as lurl from user_gallery AS img join users as u on img.user_id=u.id
left join image_lic_table as l on l.id = img.lic_id join admin_gal_crop as agc on agc.img_id = img.id
left join image_location_id as il on il.image_id = img.id where u.active = 1 and
((il.city_id = 7581))
and img.is_background_new = 1 and agc.tag_type='is_background_new' ORDER BY RAND() limit 1
|
| 0.0011 |
select img.image_url,img.cloudinary_id,agc.url,agc.cloudinary_id as agc_cloudinary,img.thumbnail_url,img.image_name,img.user_name,img.user_link,
l.name as lname,l.url as lurl from user_gallery AS img join users as u on img.user_id=u.id
left join image_lic_table as l on l.id = img.lic_id join admin_gal_crop as agc on agc.img_id = img.id
where u.active = 1 and img.is_background_new = 1 and agc.tag_type='is_background_new' ORDER BY RAND() limit 1
|
| 0.0004 |
SELECT meta_keyword,meta_description,meta_title FROM cities WHERE id = '7822'
|
| 0.0007 |
select img.image_url,img.cloudinary_id,agc.url,agc.cloudinary_id as agc_cloudinary,img.thumbnail_url,img.image_name,img.user_name,img.user_link,
l.name as lname,l.url as lurl from user_gallery AS img join users as u on img.user_id=u.id
left join image_lic_table as l on l.id = img.lic_id join admin_gal_crop as agc on agc.img_id = img.id where u.active = 1
and img.is_city_new = 1 and img.city_id IN(7822) and (agc.tag_type='is_city_new') ORDER BY RAND() limit 1
|
| 0.0035 |
SELECT meta_keyword,meta_description,meta_title FROM cities WHERE id = '7823'
|
| 0.0047 |
select img.image_url,img.cloudinary_id,agc.url,agc.cloudinary_id as agc_cloudinary,img.thumbnail_url,img.image_name,img.user_name,img.user_link,
l.name as lname,l.url as lurl from user_gallery AS img join users as u on img.user_id=u.id
left join image_lic_table as l on l.id = img.lic_id join admin_gal_crop as agc on agc.img_id = img.id where u.active = 1
and img.is_city_new = 1 and img.city_id IN(7823) and (agc.tag_type='is_city_new') ORDER BY RAND() limit 1
|
| 0.0671 |
SELECT t.*,gp.tour_guide_id,u.user_group_id FROM tours as t join users as u on u.id = t.guide_id left join guide_profile as gp on gp.user_id=u.id where t.is_active=1 and u.active = 1 and u.visible = 1 and u.disabled = 0 and u.varified = 0 and t.instant_booked_tour='0' and FIND_IN_SET('90',t.covered_countries) order by CASE WHEN u.user_group_id=1 then 0 else 1 end, t.featured desc limit 0 , 40
|
| 0.2832 |
select DISTINCT (g.id),g.user_id as guide_id ,g.tour_guide_id,g.about_me,u.alias,u.first_name ,u.facebook_profile_image,u.last_name,u.fbid,g.power,g.persentile,g.profile_bar,g.profile_image_thumb,g.profile_image,g.profile_angle,g.profile_crop,g.is_cloudinery from guide_profile AS g join users as u on g.user_id = u.id where u.active = 1 and u.visible = 1 and u.disabled = 0 and user_group_id=3 and (g.city_id IN(1600,7822,7823) or g.other_city_id1 IN(1600,7822,7823) or g.other_city_id2 IN(1600,7822,7823) or g.other_city_id3 IN(1600,7822,7823) or g.other_city_id4 IN(1600,7822,7823) or g.other_city_id5 IN(1600,7822,7823) or g.other_city_id6 IN(1600,7822,7823) or g.other_city_id7 IN(1600,7822,7823) or g.other_city_id8 IN(1600,7822,7823) or g.other_city_id9 IN(1600,7822,7823) or g.other_city_id10 IN(1600,7822,7823) or g.other_city_id11 IN(1600,7822,7823) or g.other_city_id12 IN(1600,7822,7823) or g.other_city_id13 IN(1600,7822,7823) or g.other_city_id14 IN(1600,7822,7823) or g.other_city_id15 IN(1600,7822,7823) or g.other_city_id16 IN(1600,7822,7823) or g.other_city_id17 IN(1600,7822,7823) or g.other_city_id18 IN(1600,7822,7823) or g.other_city_id19 IN(1600,7822,7823) or g.other_city_id20 IN(1600,7822,7823)) ORDER BY CASE WHEN (persentile >=40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1 and gr.deleted=0 limit 0,1))
THEN (persentile) END DESC,CASE WHEN (persentile >=40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1 and gr.deleted=0 limit 0,1))
THEN (power) END DESC,CASE WHEN (persentile <40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1
and gr.deleted=0 limit 0,1)) THEN (persentile) END asc, CASE WHEN persentile >=40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id != g.user_id
limit 0,1) THEN profile_bar END DESC limit 0, 40
|
| 0.0406 |
SELECT *
FROM `super_guide_status`
WHERE `guide_id` = '35629'
AND `slot_date` = '2020-01-03'
|
| 0.0006 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '35629'
|
| 0.0003 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '35629'
|
| 0.0062 |
SELECT COUNT(*) AS `numrows`
FROM `guide_review_table`
WHERE `guide_id` = '35629'
AND `status` = 1
AND `deleted` = 0
|
| 0.0408 |
SELECT *
FROM `super_guide_status`
WHERE `guide_id` = '23727'
AND `slot_date` = '2020-01-03'
|
| 0.0007 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '23727'
|
| 0.0022 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '23727'
|
| 0.0011 |
SELECT COUNT(*) AS `numrows`
FROM `guide_review_table`
WHERE `guide_id` = '23727'
AND `status` = 1
AND `deleted` = 0
|
| 0.0404 |
SELECT *
FROM `super_guide_status`
WHERE `guide_id` = '10859'
AND `slot_date` = '2020-01-03'
|
| 0.0007 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '10859'
|
| 0.0003 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '10859'
|
| 0.0006 |
SELECT COUNT(*) AS `numrows`
FROM `guide_review_table`
WHERE `guide_id` = '10859'
AND `status` = 1
AND `deleted` = 0
|
| 0.0409 |
SELECT *
FROM `super_guide_status`
WHERE `guide_id` = '16223'
AND `slot_date` = '2020-01-03'
|
| 0.0008 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '16223'
|
| 0.0003 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '16223'
|
| 0.0009 |
SELECT COUNT(*) AS `numrows`
FROM `guide_review_table`
WHERE `guide_id` = '16223'
AND `status` = 1
AND `deleted` = 0
|
| 0.0413 |
SELECT *
FROM `super_guide_status`
WHERE `guide_id` = '24026'
AND `slot_date` = '2020-01-03'
|
| 0.0008 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '24026'
|
| 0.0004 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '24026'
|
| 0.0005 |
SELECT COUNT(*) AS `numrows`
FROM `guide_review_table`
WHERE `guide_id` = '24026'
AND `status` = 1
AND `deleted` = 0
|
| 0.0407 |
SELECT *
FROM `super_guide_status`
WHERE `guide_id` = '43292'
AND `slot_date` = '2020-01-03'
|
| 0.0007 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '43292'
|
| 0.0003 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '43292'
|
| 0.0005 |
SELECT COUNT(*) AS `numrows`
FROM `guide_review_table`
WHERE `guide_id` = '43292'
AND `status` = 1
AND `deleted` = 0
|
| 0.0864 |
select DISTINCT (g.id),g.user_id as guide_id ,g.tour_guide_id,u.alias,u.first_name ,u.facebook_profile_image,u.last_name,u.fbid,g.power,g.about_me,g.persentile,g.profile_bar,g.profile_image_thumb,g.profile_image,g.profile_angle,g.profile_crop,g.is_cloudinery from guide_profile AS g join users as u on g.user_id = u.id where u.active = 1 and u.visible = 1 and u.disabled = 0 and user_group_id=5 and (g.city_id IN(1600,7822,7823) or g.other_city_id1 IN(1600,7822,7823) or g.other_city_id2 IN(1600,7822,7823) or g.other_city_id3 IN(1600,7822,7823) or g.other_city_id4 IN(1600,7822,7823) or g.other_city_id5 IN(1600,7822,7823) or g.other_city_id6 IN(1600,7822,7823) or g.other_city_id7 IN(1600,7822,7823) or g.other_city_id8 IN(1600,7822,7823) or g.other_city_id9 IN(1600,7822,7823) or g.other_city_id10 IN(1600,7822,7823) or g.other_city_id11 IN(1600,7822,7823) or g.other_city_id12 IN(1600,7822,7823) or g.other_city_id13 IN(1600,7822,7823) or g.other_city_id14 IN(1600,7822,7823) or g.other_city_id15 IN(1600,7822,7823) or g.other_city_id16 IN(1600,7822,7823) or g.other_city_id17 IN(1600,7822,7823) or g.other_city_id18 IN(1600,7822,7823) or g.other_city_id19 IN(1600,7822,7823) or g.other_city_id20 IN(1600,7822,7823) ) ORDER BY CASE WHEN (persentile >=40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1 and gr.deleted=0 limit 0,1))
THEN (persentile) END DESC,CASE WHEN (persentile >=40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1 and gr.deleted=0 limit 0,1))
THEN (power) END DESC,CASE WHEN (persentile <40 and (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id = g.user_id and gr.status=1
and gr.deleted=0 limit 0,1)) THEN (persentile) END asc, CASE WHEN (SELECT gr.id from guide_review_table as gr WHERE gr.guide_id != g.user_id
limit 0,1) THEN profile_bar END DESC limit 0, 20
|
| 0.0003 |
SELECT *
FROM `super_guide_status`
WHERE `guide_id` = '28662'
AND `slot_date` = '2020-01-03'
|
| 0.0006 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '28662'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `guide_review_table`
WHERE `guide_id` = '28662'
AND `status` = 1
AND `deleted` = 0
|
| 0.0406 |
SELECT *
FROM `super_guide_status`
WHERE `guide_id` = '40554'
AND `slot_date` = '2020-01-03'
|
| 0.0008 |
SELECT `gp`.`profile_image_thumb`, `gp`.`profile_image`, `u`.`facebook_profile_image` as `facebook_profile_image`, `gp`.`profile_angle`, `gp`.`profile_crop`, `gp`.`cloud_pimage`, `gp`.`cloud_fimage`, `gp`.`is_cloudinery`, `u`.`first_name`, `u`.`last_name`, `u`.`email`, `u`.`user_group_id`, `u`.`fbid`, `c`.`city_name`, `c`.`state_id`, `c`.`country_id`
FROM `users` AS `u`
LEFT JOIN `guide_profile` AS `gp` ON `gp`.`user_id` = `u`.`id`
LEFT JOIN `cities` AS `c` ON `c`.`id` = `gp`.`city_id`
WHERE `u`.`id` = '40554'
|
| 0.0004 |
SELECT COUNT(*) AS `numrows`
FROM `guide_review_table`
WHERE `guide_id` = '40554'
AND `status` = 1
AND `deleted` = 0
|
| 0.0017 |
select DISTINCT(a.id) as aid,a.random_image, a.article_image_thumb , IFNULL(at.alias ,a.alias) as alias , a.random_image , IFNULL(at.article_name , a.article_name) as article_name , IFNULL(at.article_short_content , a.article_short_content) as article_short_content,a.is_cloudinery,a.angle,a.crop_option from articles AS a left join article_translation as at on a.id = at.article_id and at.lang_id = 'en' join users as u on a.author_id = u.id join article_location_id al on a.id = al.article_id where u.active = 1 and u.visible = 1 and u.disabled = 0 and (al.city_id IN(90) or (al.city_id=0 and al.country_id = 90)) and a.is_active=1 ORDER BY a.id desc limit 0, 12
|
| 0.0003 |
select alias from pages where id='26'
|
