| 1 |
SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour' |
0.0050768852233887 |
| 2 |
SELECT * FROM default_setting WHERE setting_id='1' |
0.00062203407287598 |
| 3 |
SELECT region_id,title,slug,country_id FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no asc |
0.0015130043029785 |
| 4 |
SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1 |
0.00010013580322266 |
| 5 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='14' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0011601448059082 |
| 6 |
SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1 |
9.1791152954102E-5 |
| 7 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='5' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0009920597076416 |
| 8 |
SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1 |
8.7976455688477E-5 |
| 9 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='6' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0010089874267578 |
| 10 |
SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1 |
8.7976455688477E-5 |
| 11 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='7' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0010311603546143 |
| 12 |
SELECT continent_id,title,slug FROM default_continent WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc |
0.00089001655578613 |
| 13 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='3' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.00095200538635254 |
| 14 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='4' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.00096607208251953 |
| 15 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='5' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.00095200538635254 |
| 16 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='6' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.00082492828369141 |
| 17 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='7' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.00087809562683105 |
| 18 |
SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=477 order by order_no asc |
0.0007941722869873 |
| 19 |
SELECT servicecat_id,title,slug,intro,image FROM default_servicecat WHERE lang_id='vn' and is_trash=0 and is_online=1 and servicecat_id IN (7,8,9,10) |
0.0010631084442139 |
| 20 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='cruise' and act_page='cat' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00034904479980469 |
| 21 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
9.9897384643555E-5 |
| 22 |
SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.00086593627929688 |
| 23 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='vn' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3 |
0.0010330677032471 |
| 24 |
SELECT distinct short FROM default_property where property_id=950 LIMIT 0,1 |
0.00010299682617188 |
| 25 |
SELECT feature_package_id 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.00043582916259766 |
| 26 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
8.702278137207E-5 |
| 27 |
SELECT feature_package_id 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.0003211498260498 |
| 28 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
8.3208084106445E-5 |
| 29 |
SELECT city_id,title,banner,intro,content FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and slug='thanh-hoa' LIMIT 0,1 |
0.012237071990967 |
| 30 |
SELECT guidecat_idintro,title,image FROM default_guidecat WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc |
0.00347900390625 |
| 31 |
SELECT guide_id,slug,title,publish_date FROM default_guide WHERE lang_id='vn' and is_trash=0 and is_online=1 and cat_id='' and country_id='4' and city_id='802' order by order_no asc |
0.016218900680542 |
| 32 |
SELECT region_id,title FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' order by order_no asc |
0.0062451362609863 |
| 33 |
SELECT tourcat_id,title FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc |
0.00095701217651367 |
| 34 |
SELECT tour_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='802') |
0.0011370182037354 |
| 35 |
SELECT tour_id,departure_point_id,slug,title,image,duration_type,duration_custom,number_day,number_night,list_tag_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='802') order by order_no asc LIMIT 0,15 |
0.0016710758209229 |
| 36 |
SELECT max(number_day) as max,min(number_day) as min FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 |
0.0019330978393555 |
| 37 |
SELECT max(min_price) as max,min(min_price) as min FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 |
0.00099706649780273 |
| 38 |
SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.0011920928955078 |
| 39 |
SELECT feature_package_id 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.00051307678222656 |
| 40 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
9.0837478637695E-5 |
| 41 |
SELECT page_id,title,slug FROM default_page WHERE lang_id='vn' and is_trash=0 and is_online=1 and page_id <>'2' order by order_no asc |
0.0010061264038086 |
| 42 |
SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='vn' and (config_link='/du-lich-trong-nuoc/du-lich-thanh-hoa' or config_link='/du-lich-trong-nuoc/du-lich-thanh-hoa') limit 1 |
0.00086593627929688 |
| 43 |
SELECT feature_package_id 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.00057101249694824 |
| 44 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00010204315185547 |
| 45 |
SELECT feature_package_id 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.00046014785766602 |
| 46 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
9.3936920166016E-5 |
| 47 |
SELECT feature_package_id 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.00037288665771484 |
| 48 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00012111663818359 |
| 49 |
SELECT feature_package_id 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.00040006637573242 |
| 50 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
8.702278137207E-5 |
| 51 |
SELECT slug FROM default_servicecat WHERE servicecat_id='10' |
9.7990036010742E-5 |
| 52 |
SELECT title FROM default_servicecat WHERE servicecat_id='10' |
7.8201293945312E-5 |
| 53 |
SELECT title FROM default_servicecat WHERE servicecat_id='10' |
4.7922134399414E-5 |
| 54 |
SELECT title FROM default_country WHERE country_id='4' |
0.00011801719665527 |
| 55 |
SELECT title FROM default_country WHERE country_id='4' |
0.00014901161193848 |
| 56 |
SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1 |
0.00010013580322266 |
| 57 |
SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='14' and city_id<>'802' order by order_no ASC |
0.0010809898376465 |
| 58 |
SELECT title FROM default_region WHERE region_id='14' |
8.2969665527344E-5 |
| 59 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='966') |
0.00027799606323242 |
| 60 |
SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1 |
8.9883804321289E-5 |
| 61 |
SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='5' and city_id<>'802' order by order_no ASC |
0.0021579265594482 |
| 62 |
SELECT title FROM default_region WHERE region_id='5' |
6.6995620727539E-5 |
| 63 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='917') |
0.00030398368835449 |
| 64 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='915') |
0.00060796737670898 |
| 65 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='914') |
0.00021004676818848 |
| 66 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='913') |
0.0003509521484375 |
| 67 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='912') |
0.00020503997802734 |
| 68 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='804') |
0.0015811920166016 |
| 69 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='895') |
0.0008699893951416 |
| 70 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='761') |
0.00021195411682129 |
| 71 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='699') |
0.00022196769714355 |
| 72 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='760') |
0.0011210441589355 |
| 73 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='698') |
0.0062599182128906 |
| 74 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='684') |
0.0032899379730225 |
| 75 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='759') |
0.0034220218658447 |
| 76 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='685') |
0.00041103363037109 |
| 77 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='683') |
0.0017428398132324 |
| 78 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='682') |
0.00027608871459961 |
| 79 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='758') |
0.00021791458129883 |
| 80 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='673') |
0.00031685829162598 |
| 81 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='666') |
0.00078392028808594 |
| 82 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='700') |
0.00044417381286621 |
| 83 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='656') |
0.0003359317779541 |
| 84 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='652') |
0.00022006034851074 |
| 85 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='1') |
0.0002140998840332 |
| 86 |
SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1 |
9.7990036010742E-5 |
| 87 |
SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='6' and city_id<>'802' order by order_no ASC |
0.0013182163238525 |
| 88 |
SELECT title FROM default_region WHERE region_id='6' |
0.00017690658569336 |
| 89 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='920') |
0.00022292137145996 |
| 90 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='919') |
0.00020694732666016 |
| 91 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='906') |
0.0001990795135498 |
| 92 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='905') |
0.00017690658569336 |
| 93 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='904') |
0.00017809867858887 |
| 94 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='805') |
0.00017499923706055 |
| 95 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='697') |
0.00017309188842773 |
| 96 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='675') |
0.00022506713867188 |
| 97 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='670') |
0.0002129077911377 |
| 98 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='690') |
0.00020503997802734 |
| 99 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='660') |
0.00019502639770508 |
| 100 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='659') |
0.00018095970153809 |
| 101 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='654') |
0.00018501281738281 |
| 102 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='678') |
0.00017809867858887 |
| 103 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='653') |
0.00017690658569336 |
| 104 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='686') |
0.00017499923706055 |
| 105 |
SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1 |
8.2015991210938E-5 |
| 106 |
SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='7' and city_id<>'802' order by order_no ASC |
0.0010919570922852 |
| 107 |
SELECT title FROM default_region WHERE region_id='7' |
8.702278137207E-5 |
| 108 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='958') |
0.00019311904907227 |
| 109 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='911') |
0.00017595291137695 |
| 110 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='910') |
0.00018095970153809 |
| 111 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='909') |
0.00017809867858887 |
| 112 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='908') |
0.00020599365234375 |
| 113 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='907') |
0.00019311904907227 |
| 114 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='903') |
0.00018501281738281 |
| 115 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='803') |
0.00020098686218262 |
| 116 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='801') |
0.00018596649169922 |
| 117 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='764') |
0.00017499923706055 |
| 118 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='765') |
0.00017595291137695 |
| 119 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='763') |
0.00017404556274414 |
| 120 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='762') |
0.00017285346984863 |
| 121 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='677') |
0.00017094612121582 |
| 122 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='663') |
0.00023412704467773 |
| 123 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='661') |
0.00017499923706055 |
| 124 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='658') |
0.00018501281738281 |
| 125 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='657') |
0.00017499923706055 |
| 126 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='651') |
0.00018405914306641 |
| 127 |
SELECT feature_package_id 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.00038003921508789 |
| 128 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00012111663818359 |
| 129 |
SELECT feature_package_id 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.00042295455932617 |
| 130 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
7.3909759521484E-5 |
| 131 |
SELECT feature_package_id 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.00037407875061035 |
| 132 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
8.5115432739258E-5 |
| 133 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='download' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00038290023803711 |
| 134 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
8.8930130004883E-5 |
| 135 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='news' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00034594535827637 |
| 136 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
7.2956085205078E-5 |
| 137 |
SELECT feature_package_id 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.00036501884460449 |
| 138 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
6.6995620727539E-5 |
