| 1 |
SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='guide' |
0.0011918544769287 |
| 2 |
SELECT * FROM default_setting WHERE setting_id='1' |
0.00031805038452148 |
| 3 |
SELECT country_id,title,slug,intro,image FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC |
0.021970987319946 |
| 4 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 AND country_id IN (SELECT country_id FROM default_hotel WHERE is_trash=0 and is_online=1) order by order_no asc |
0.031967163085938 |
| 5 |
SELECT tourcat_id,title,slug,image FROM default_tour_category WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.037851095199585 |
| 6 |
SELECT tour_id,list_cat_id FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and is_multi_country=1 |
0.1196391582489 |
| 7 |
SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.0021779537200928 |
| 8 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3 |
0.0044429302215576 |
| 9 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORAGETYPE' order by order_no ASC limit 0,1 |
0.0017330646514893 |
| 10 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORHEIGHTTYPE' order by order_no ASC limit 0,1 |
0.0095138549804688 |
| 11 |
SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1 |
0.0032050609588623 |
| 12 |
SELECT * FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0075500011444092 |
| 13 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.003364086151123 |
| 14 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='tour_departure_point' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.0069940090179443 |
| 15 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00088596343994141 |
| 16 |
SELECT * FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and guide_id='29' and slug='wander-around-lao-quarter' |
0.050877809524536 |
| 17 |
SELECT guide_id,title,slug,country_id,city_id,cat_id FROM default_guide WHERE guide_id='29' |
0.0022499561309814 |
| 18 |
SELECT title,slug FROM default_country WHERE country_id='64' |
0.0056648254394531 |
| 19 |
SELECT guidecat_id,title,slug FROM default_guidecat WHERE guidecat_id='12' |
0.10329794883728 |
| 20 |
SELECT guidecat_id FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1 |
0.0086319446563721 |
| 21 |
SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='12' or list_cat_id like '%|12|%') and country_id='64' and city_id='392' and guide_id<>'29' order by rand() LIMIT 0,10 |
0.010857105255127 |
| 22 |
SELECT title FROM default_guide WHERE guide_id='29' |
0.0030570030212402 |
| 23 |
SELECT intro FROM default_guide WHERE guide_id='29' |
0.002694845199585 |
| 24 |
SELECT slug FROM default_guide WHERE guide_id='29' |
0.0015189647674561 |
| 25 |
SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/g29-wander-around-lao-quarter.html' |
0.0080330371856689 |
| 26 |
SELECT distinct image FROM default_guide where guide_id=29 LIMIT 0,1 |
0.0035650730133057 |
| 27 |
SELECT page_id,title,slug FROM default_page WHERE lang_id='' and is_trash=0 and is_online=1 and page_id <>'1' order by order_no asc |
0.034081935882568 |
| 28 |
SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/g29-wander-around-lao-quarter.html' or config_link='/g29-wander-around-lao-quarter.html') limit 1 |
0.0022618770599365 |
| 29 |
SELECT * FROM default_featurepackage WHERE mod_page='setting' and act_page='cart' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.0011959075927734 |
| 30 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020599365234375 |
| 31 |
SELECT * FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00082206726074219 |
| 32 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017380714416504 |
| 33 |
SELECT slug FROM default_country WHERE country_id='67' |
0.00020003318786621 |
| 34 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.015346050262451 |
| 35 |
SELECT slug FROM default_country WHERE country_id='67' |
0.00083494186401367 |
| 36 |
SELECT slug FROM default_country WHERE country_id='1' |
0.006274938583374 |
| 37 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.006242036819458 |
| 38 |
SELECT slug FROM default_country WHERE country_id='1' |
0.0024380683898926 |
| 39 |
SELECT slug FROM default_country WHERE country_id='3' |
0.0039379596710205 |
| 40 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0039510726928711 |
| 41 |
SELECT slug FROM default_country WHERE country_id='3' |
0.0025651454925537 |
| 42 |
SELECT slug FROM default_country WHERE country_id='7' |
0.0053129196166992 |
| 43 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.001140832901001 |
| 44 |
SELECT slug FROM default_country WHERE country_id='7' |
0.0027399063110352 |
| 45 |
SELECT slug FROM default_country WHERE country_id='64' |
0.0037410259246826 |
| 46 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0041141510009766 |
| 47 |
SELECT slug FROM default_country WHERE country_id='64' |
0.0021240711212158 |
| 48 |
SELECT slug FROM default_country WHERE country_id='65' |
0.005817174911499 |
| 49 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.011919021606445 |
| 50 |
SELECT slug FROM default_country WHERE country_id='65' |
0.0011091232299805 |
| 51 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='30' or list_cat_id like '%|30|%') |
0.0062580108642578 |
| 52 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='20' or list_cat_id like '%|20|%') |
0.012288093566895 |
| 53 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='19' or list_cat_id like '%|19|%') |
0.0037448406219482 |
| 54 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='18' or list_cat_id like '%|18|%') |
0.002781867980957 |
| 55 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='17' or list_cat_id like '%|17|%') |
0.0055999755859375 |
| 56 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='16' or list_cat_id like '%|16|%') |
0.0040051937103271 |
| 57 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='21' or list_cat_id like '%|21|%') |
0.0031640529632568 |
| 58 |
SELECT slug FROM default_guidecat WHERE guidecat_id='12' |
0.00049996376037598 |
| 59 |
SELECT title FROM default_guide WHERE guide_id='29' |
0.0030388832092285 |
| 60 |
SELECT distinct publish_date FROM default_guide where guide_id=29 LIMIT 0,1 |
0.0036859512329102 |
| 61 |
SELECT * FROM default_guide WHERE guide_id='29' |
0.0042510032653809 |
| 62 |
SELECT content FROM default_guide WHERE guide_id='29' |
0.0021770000457764 |
| 63 |
SELECT guidecat_id, title,slug FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc |
0.01186203956604 |
| 64 |
SELECT guide_id,slug,title FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and num_view > 0 and guide_id <> '29' order by num_view desc limit 0,5 |
0.011932849884033 |
| 65 |
SELECT slug FROM default_guidecat WHERE guidecat_id='15' |
0.00060105323791504 |
| 66 |
SELECT slug FROM default_guidecat WHERE guidecat_id='13' |
0.0028269290924072 |
| 67 |
SELECT slug FROM default_guidecat WHERE guidecat_id='9' |
0.0038971900939941 |
| 68 |
SELECT slug FROM default_guidecat WHERE guidecat_id='2' |
0.0040531158447266 |
| 69 |
SELECT slug FROM default_guidecat WHERE guidecat_id='12' |
0.0025639533996582 |
| 70 |
SELECT * FROM default_featurepackage WHERE mod_page='subscription' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0066590309143066 |
| 71 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0039620399475098 |
| 72 |
SELECT * FROM default_featurepackage WHERE mod_page='page' and act_page='about' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0079529285430908 |
| 73 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0085330009460449 |
| 74 |
SELECT * FROM default_featurepackage WHERE mod_page='testimonial' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0065109729766846 |
| 75 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00075292587280273 |
| 76 |
SELECT * FROM default_featurepackage WHERE mod_page='faqs' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.005687952041626 |
| 77 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0022289752960205 |
| 78 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0038249492645264 |
| 79 |
SELECT * FROM default_featurepackage WHERE mod_page='blog' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0069570541381836 |
| 80 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00091099739074707 |
