1 |
SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour_new' |
0.0062758922576904 |
2 |
SELECT COUNT(*) AS totalitem FROM default_module WHERE site='FRONTPAGE' and name='tour' |
0.003911018371582 |
3 |
SELECT * FROM default_setting WHERE setting_id='1' |
0.0010051727294922 |
4 |
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.011957883834839 |
5 |
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.01195502281189 |
6 |
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.0075869560241699 |
7 |
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.018838882446289 |
8 |
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.015432119369507 |
9 |
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.014323949813843 |
10 |
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.0072019100189209 |
11 |
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.016036987304688 |
12 |
SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1 |
0.0012128353118896 |
13 |
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.0049080848693848 |
14 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0076920986175537 |
15 |
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.006382942199707 |
16 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0059230327606201 |
17 |
SELECT tour_id FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and tour_id='585' and slug='halong-bay-and-sapa-package-trip-7-days-6-nights' |
0.011353969573975 |
18 |
SELECT * FROM default_tour WHERE tour_id='585' |
0.023998022079468 |
19 |
SELECT * FROM default_featurepackage WHERE mod_page='promotionpro' and act_page='default' and type='default' and type_page='tour' order by order_no ASC limit 0,1 |
0.0078599452972412 |
20 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0017631053924561 |
21 |
SELECT promotion_id FROM default_promotion WHERE lang_id='' and promotion_id IN() order by promotion_id desc |
0.011243104934692 |
22 |
SELECT * FROM default_featurepackage WHERE mod_page='promotionpro' and act_page='default' and type='default' and type_page='tour' order by order_no ASC limit 0,1 |
0.0061478614807129 |
23 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0012140274047852 |
24 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='tour_gallery' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.0061931610107422 |
25 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0018041133880615 |
26 |
SELECT tour_image_id,image,title FROM default_tour_image WHERE lang_id='' and is_trash=0 and table_id='585' and image<>'' order by order_no ASC |
0.059278011322021 |
27 |
SELECT * FROM default_featurepackage WHERE mod_page='property' and act_page='activities' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0069670677185059 |
28 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0009150505065918 |
29 |
SELECT fieldvalue,fieldname FROM default_tour_customfield WHERE lang_id='' and tour_id='585' and fieldtype='CUSTOM' order by order_no ASC |
0.014388084411621 |
30 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and type='NATIONALITY' order by order_no asc |
0.0092880725860596 |
31 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and type='VISITORTYPE' order by order_no asc |
0.011460781097412 |
32 |
SELECT distinct number_to FROM default_tour_option where tour_option_id=102 LIMIT 0,1 |
0.016132116317749 |
33 |
SELECT max(number_to) as max FROM default_tour_option WHERE lang_id='' and tour_option_id IN (192) |
0.011143922805786 |
34 |
SELECT max(number_to) as max FROM default_tour_option WHERE lang_id='' and tour_option_id IN (192) |
0.020334959030151 |
35 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='store' and type='default' and type_page='REVQQVJUVVJFLVZpZXRJU08=' order by order_no ASC limit 0,1 |
0.0064058303833008 |
36 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0023729801177979 |
37 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='itinerary' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.0073270797729492 |
38 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0013611316680908 |
39 |
SELECT tour_itinerary_id,image,content,tour_itinerary_id,transport,is_show_image,day,day2,tour_id,title,meals FROM default_tour_itinerary WHERE lang_id='' and is_trash=0 and tour_id='585' and title_contingency='' order by order_no asc limit 0,7 |
0.042572975158691 |
40 |
SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/t585-halong-bay-and-sapa-package-trip-7-days-6-nights.html' |
0.010053873062134 |
41 |
SELECT distinct tour_option FROM default_tour where tour_id=585 LIMIT 0,1 |
0.0039331912994385 |
42 |
SELECT distinct adult_group_size FROM default_tour where tour_id=585 LIMIT 0,1 |
0.0020320415496826 |
43 |
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.011446952819824 |
44 |
SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/t585-halong-bay-and-sapa-package-trip-7-days-6-nights.html' or config_link='/t585-halong-bay-and-sapa-package-trip-7-days-6-nights.html') limit 1 |
0.015244007110596 |
45 |
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.0063610076904297 |
46 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0032658576965332 |
47 |
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.0079538822174072 |
48 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0011417865753174 |
49 |
SELECT slug FROM default_country WHERE country_id='67' |
0.0061821937561035 |
50 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0045409202575684 |
51 |
SELECT slug FROM default_country WHERE country_id='67' |
0.0049889087677002 |
52 |
SELECT slug FROM default_country WHERE country_id='1' |
0.00030207633972168 |
53 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0065450668334961 |
54 |
SELECT slug FROM default_country WHERE country_id='1' |
0.0039389133453369 |
55 |
SELECT slug FROM default_country WHERE country_id='3' |
0.0026009082794189 |
56 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0053300857543945 |
57 |
SELECT slug FROM default_country WHERE country_id='3' |
0.0010290145874023 |
58 |
SELECT slug FROM default_country WHERE country_id='7' |
0.0037109851837158 |
59 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0027501583099365 |
60 |
SELECT slug FROM default_country WHERE country_id='7' |
0.0042381286621094 |
61 |
SELECT slug FROM default_country WHERE country_id='64' |
0.0019440650939941 |
62 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0059330463409424 |
63 |
SELECT slug FROM default_country WHERE country_id='64' |
0.0039479732513428 |
64 |
SELECT slug FROM default_country WHERE country_id='65' |
0.0012321472167969 |
65 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0014619827270508 |
66 |
SELECT slug FROM default_country WHERE country_id='65' |
0.005145788192749 |
67 |
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.0010950565338135 |
68 |
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.0063121318817139 |
69 |
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.0044400691986084 |
70 |
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.0016179084777832 |
71 |
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.006289005279541 |
72 |
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.003972053527832 |
73 |
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.002479076385498 |
74 |
SELECT title FROM default_tour WHERE tour_id='585' |
0.0091469287872314 |
75 |
SELECT title,slug FROM default_tour_category WHERE tourcat_id='20' |
0.0039491653442383 |
76 |
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.0070040225982666 |
77 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0048799514770508 |
78 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '585' and type='tour' |
0.026777029037476 |
79 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.0036580562591553 |
80 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.0013809204101562 |
81 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98) |
0.009307861328125 |
82 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.0030949115753174 |
83 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99,100) |
0.0097870826721191 |
84 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.0061118602752686 |
85 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99) |
0.0089190006256104 |
86 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.0060110092163086 |
87 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99) |
0.012042999267578 |
88 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.0017390251159668 |
89 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99,100) |
0.013839960098267 |
90 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.006134033203125 |
91 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98) |
0.012841939926147 |
92 |
SELECT image FROM default_tour WHERE tour_id='585' |
0.0041170120239258 |
93 |
SELECT title FROM default_tour WHERE tour_id='585' |
0.0031380653381348 |
94 |
SELECT image FROM default_tour WHERE tour_id='585' |
0.0029559135437012 |
95 |
SELECT title FROM default_tour WHERE tour_id='585' |
0.0057508945465088 |
96 |
SELECT image FROM default_tour_image WHERE tour_image_id='3321' |
0.0016059875488281 |
97 |
SELECT title FROM default_tour_image WHERE tour_image_id='3321' |
0.006187915802002 |
98 |
SELECT image FROM default_tour_image WHERE tour_image_id='3321' |
0.0041429996490479 |
99 |
SELECT title FROM default_tour_image WHERE tour_image_id='3321' |
0.0023419857025146 |
100 |
SELECT image FROM default_tour_image WHERE tour_image_id='3322' |
0.0055539608001709 |
101 |
SELECT title FROM default_tour_image WHERE tour_image_id='3322' |
0.0010509490966797 |
102 |
SELECT image FROM default_tour_image WHERE tour_image_id='3322' |
0.0064718723297119 |
103 |
SELECT title FROM default_tour_image WHERE tour_image_id='3322' |
0.0043408870697021 |
104 |
SELECT image FROM default_tour_image WHERE tour_image_id='3323' |
0.0031380653381348 |
105 |
SELECT title FROM default_tour_image WHERE tour_image_id='3323' |
0.0047221183776855 |
106 |
SELECT image FROM default_tour_image WHERE tour_image_id='3323' |
0.0017609596252441 |
107 |
SELECT title FROM default_tour_image WHERE tour_image_id='3323' |
0.0061359405517578 |
108 |
SELECT image FROM default_tour_image WHERE tour_image_id='3324' |
0.00029516220092773 |
109 |
SELECT title FROM default_tour_image WHERE tour_image_id='3324' |
0.0036449432373047 |
110 |
SELECT image FROM default_tour_image WHERE tour_image_id='3324' |
0.0079288482666016 |
111 |
SELECT title FROM default_tour_image WHERE tour_image_id='3324' |
0.0028560161590576 |
112 |
SELECT image FROM default_tour_image WHERE tour_image_id='3325' |
0.0050201416015625 |
113 |
SELECT title FROM default_tour_image WHERE tour_image_id='3325' |
0.0014779567718506 |
114 |
SELECT image FROM default_tour_image WHERE tour_image_id='3325' |
0.0062541961669922 |
115 |
SELECT title FROM default_tour_image WHERE tour_image_id='3325' |
0.0042159557342529 |
116 |
SELECT image FROM default_tour_image WHERE tour_image_id='3326' |
0.0020179748535156 |
117 |
SELECT title FROM default_tour_image WHERE tour_image_id='3326' |
0.0059378147125244 |
118 |
SELECT image FROM default_tour_image WHERE tour_image_id='3326' |
0.00040721893310547 |
119 |
SELECT title FROM default_tour_image WHERE tour_image_id='3326' |
0.0035340785980225 |
120 |
SELECT image FROM default_tour_image WHERE tour_image_id='3327' |
0.0029678344726562 |
121 |
SELECT title FROM default_tour_image WHERE tour_image_id='3327' |
0.0049099922180176 |
122 |
SELECT image FROM default_tour_image WHERE tour_image_id='3327' |
0.001417875289917 |
123 |
SELECT title FROM default_tour_image WHERE tour_image_id='3327' |
0.0061440467834473 |
124 |
SELECT image FROM default_tour_image WHERE tour_image_id='3328' |
0.0044140815734863 |
125 |
SELECT title FROM default_tour_image WHERE tour_image_id='3328' |
0.0018861293792725 |
126 |
SELECT image FROM default_tour_image WHERE tour_image_id='3328' |
0.0061359405517578 |
127 |
SELECT title FROM default_tour_image WHERE tour_image_id='3328' |
0.00033116340637207 |
128 |
SELECT image FROM default_tour_image WHERE tour_image_id='3329' |
0.0035030841827393 |
129 |
SELECT title FROM default_tour_image WHERE tour_image_id='3329' |
0.0028750896453857 |
130 |
SELECT image FROM default_tour_image WHERE tour_image_id='3329' |
0.0051162242889404 |
131 |
SELECT title FROM default_tour_image WHERE tour_image_id='3329' |
0.0011382102966309 |
132 |
SELECT image FROM default_tour_image WHERE tour_image_id='3331' |
0.0066559314727783 |
133 |
SELECT title FROM default_tour_image WHERE tour_image_id='3331' |
0.0041091442108154 |
134 |
SELECT image FROM default_tour_image WHERE tour_image_id='3331' |
0.0022869110107422 |
135 |
SELECT title FROM default_tour_image WHERE tour_image_id='3331' |
0.0057358741760254 |
136 |
SELECT image FROM default_tour_image WHERE tour_image_id='3334' |
0.00052189826965332 |
137 |
SELECT title FROM default_tour_image WHERE tour_image_id='3334' |
0.0034420490264893 |
138 |
SELECT image FROM default_tour_image WHERE tour_image_id='3334' |
0.0033180713653564 |
139 |
SELECT title FROM default_tour_image WHERE tour_image_id='3334' |
0.004626989364624 |
140 |
SELECT image FROM default_tour_image WHERE tour_image_id='3335' |
0.0019388198852539 |
141 |
SELECT title FROM default_tour_image WHERE tour_image_id='3335' |
0.0059549808502197 |
142 |
SELECT image FROM default_tour_image WHERE tour_image_id='3335' |
0.00060105323791504 |
143 |
SELECT title FROM default_tour_image WHERE tour_image_id='3335' |
0.0031378269195557 |
144 |
SELECT image FROM default_tour_image WHERE tour_image_id='3336' |
0.028114080429077 |
145 |
SELECT title FROM default_tour_image WHERE tour_image_id='3336' |
0.00084018707275391 |
146 |
SELECT image FROM default_tour_image WHERE tour_image_id='3336' |
0.00012707710266113 |
147 |
SELECT title FROM default_tour_image WHERE tour_image_id='3336' |
0.0001988410949707 |
148 |
SELECT image FROM default_tour_image WHERE tour_image_id='3337' |
0.00017714500427246 |
149 |
SELECT title FROM default_tour_image WHERE tour_image_id='3337' |
0.00014901161193848 |
150 |
SELECT image FROM default_tour_image WHERE tour_image_id='3337' |
0.00011706352233887 |
151 |
SELECT title FROM default_tour_image WHERE tour_image_id='3337' |
0.00018787384033203 |
152 |
SELECT image FROM default_tour_image WHERE tour_image_id='3338' |
0.00016021728515625 |
153 |
SELECT title FROM default_tour_image WHERE tour_image_id='3338' |
0.00013208389282227 |
154 |
SELECT image FROM default_tour_image WHERE tour_image_id='3338' |
0.00020098686218262 |
155 |
SELECT title FROM default_tour_image WHERE tour_image_id='3338' |
0.00017094612121582 |
156 |
SELECT image FROM default_tour_image WHERE tour_image_id='3339' |
0.00015115737915039 |
157 |
SELECT title FROM default_tour_image WHERE tour_image_id='3339' |
0.00012612342834473 |
158 |
SELECT image FROM default_tour_image WHERE tour_image_id='3339' |
0.00020790100097656 |
159 |
SELECT title FROM default_tour_image WHERE tour_image_id='3339' |
0.00017786026000977 |
160 |
SELECT image FROM default_tour_image WHERE tour_image_id='3341' |
0.00015091896057129 |
161 |
SELECT title FROM default_tour_image WHERE tour_image_id='3341' |
0.00013113021850586 |
162 |
SELECT image FROM default_tour_image WHERE tour_image_id='3341' |
0.00020289421081543 |
163 |
SELECT title FROM default_tour_image WHERE tour_image_id='3341' |
0.00018692016601562 |
164 |
SELECT image FROM default_tour_image WHERE tour_image_id='3342' |
0.0075809955596924 |
165 |
SELECT title FROM default_tour_image WHERE tour_image_id='3342' |
0.00023412704467773 |
166 |
SELECT image FROM default_tour_image WHERE tour_image_id='3342' |
0.0001378059387207 |
167 |
SELECT title FROM default_tour_image WHERE tour_image_id='3342' |
0.00010800361633301 |
168 |
SELECT * FROM default_featurepackage WHERE mod_page='reviews' and act_page='default' and type='default' and type_page='tour' order by order_no ASC limit 0,1 |
0.0010449886322021 |
169 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0001838207244873 |
170 |
SELECT tour_destination_id,placetogo_id,city_id FROM default_tour_destination WHERE is_trash=0 and tour_id='585' and city_id IN (SELECT city_id from default_city WHERE is_trash=0 and is_online=1) order by order_no asc |
0.11187386512756 |
171 |
SELECT title,slug,country_id FROM default_city WHERE city_id='392' |
0.0036091804504395 |
172 |
SELECT title,slug,country_id FROM default_city WHERE city_id='417' |
0.00036096572875977 |
173 |
SELECT title,slug,country_id FROM default_city WHERE city_id='650' |
0.0001378059387207 |
174 |
SELECT title,slug,country_id FROM default_city WHERE city_id='392' |
0.00022411346435547 |
175 |
SELECT * FROM default_tour_destination WHERE is_trash=0 and tour_id='585' order by order_no desc Limit 0,1 |
0.0010359287261963 |
176 |
SELECT title FROM default_city WHERE city_id='392' |
0.00021696090698242 |
177 |
SELECT title,slug,country_id FROM default_city WHERE city_id='392' |
0.00021004676818848 |
178 |
SELECT duration_type,duration_custom,number_day,number_night FROM default_tour WHERE tour_id='585' |
0.00021600723266602 |
179 |
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.00078105926513672 |
180 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017499923706055 |
181 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='destination' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.00087094306945801 |
182 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00016593933105469 |
183 |
SELECT transport_id,image,title FROM default_transport WHERE lang_id='' and is_trash=0 and is_online=1 and transport_id in (18) order by order_no ASC |
0.0035650730133057 |
184 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00035786628723145 |
185 |
SELECT * FROM default_featurepackage WHERE mod_page='property' and act_page='transport' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00089597702026367 |
186 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017690658569336 |
187 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00024199485778809 |
188 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='hotel' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.00077700614929199 |
189 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0001671314239502 |
190 |
SELECT transport_id,image,title FROM default_transport WHERE lang_id='' and is_trash=0 and is_online=1 and transport_id in (18) order by order_no ASC |
0.0019159317016602 |
191 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00023102760314941 |
192 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98) |
0.0021111965179443 |
193 |
SELECT * FROM default_featurepackage WHERE mod_page='property' and act_page='transport' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00082993507385254 |
194 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00018310546875 |
195 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00020194053649902 |
196 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98) |
0.0050699710845947 |
197 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='hotel' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.00092005729675293 |
198 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00027704238891602 |
199 |
SELECT transport_id,image,title FROM default_transport WHERE lang_id='' and is_trash=0 and is_online=1 and transport_id in (22,26,19) order by order_no ASC |
0.007843017578125 |
200 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00036311149597168 |
201 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99,100) |
0.0020720958709717 |
202 |
SELECT * FROM default_featurepackage WHERE mod_page='property' and act_page='transport' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00092601776123047 |
203 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0002291202545166 |
204 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00024700164794922 |
205 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99,100) |
0.0054459571838379 |
206 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='hotel' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.0018520355224609 |
207 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00018596649169922 |
208 |
SELECT transport_id,image,title FROM default_transport WHERE lang_id='' and is_trash=0 and is_online=1 and transport_id in (22,27,19) order by order_no ASC |
0.0025529861450195 |
209 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00021195411682129 |
210 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99) |
0.018702030181885 |
211 |
SELECT * FROM default_featurepackage WHERE mod_page='property' and act_page='transport' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0027079582214355 |
212 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0011968612670898 |
213 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.0017349720001221 |
214 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99) |
0.0037341117858887 |
215 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='hotel' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.0018692016601562 |
216 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00033307075500488 |
217 |
SELECT transport_id,image,title FROM default_transport WHERE lang_id='' and is_trash=0 and is_online=1 and transport_id in (78,18) order by order_no ASC |
0.0065121650695801 |
218 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.0016741752624512 |
219 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99) |
0.0070869922637939 |
220 |
SELECT * FROM default_featurepackage WHERE mod_page='property' and act_page='transport' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0024850368499756 |
221 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00020503997802734 |
222 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00020098686218262 |
223 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99) |
0.0018870830535889 |
224 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='hotel' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.0010850429534912 |
225 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017499923706055 |
226 |
SELECT transport_id,image,title FROM default_transport WHERE lang_id='' and is_trash=0 and is_online=1 and transport_id in (78) order by order_no ASC |
0.0019950866699219 |
227 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00022101402282715 |
228 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99,100) |
0.0089881420135498 |
229 |
SELECT * FROM default_featurepackage WHERE mod_page='property' and act_page='transport' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00095105171203613 |
230 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00018310546875 |
231 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00023102760314941 |
232 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98,99,100) |
0.0019559860229492 |
233 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='hotel' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.00081586837768555 |
234 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017619132995605 |
235 |
SELECT transport_id,image,title FROM default_transport WHERE lang_id='' and is_trash=0 and is_online=1 and transport_id in (19) order by order_no ASC |
0.0017697811126709 |
236 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00020313262939453 |
237 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98) |
0.001986026763916 |
238 |
SELECT * FROM default_featurepackage WHERE mod_page='property' and act_page='transport' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00090312957763672 |
239 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017809867858887 |
240 |
SELECT number_day,duration_type,dra_hours,dra_min FROM default_tour WHERE tour_id='585' |
0.00016498565673828 |
241 |
SELECT title FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and tour_property_id in (98) |
0.0068590641021729 |
242 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='hotel' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.0010750293731689 |
243 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00019693374633789 |
244 |
SELECT file_programme FROM default_tour WHERE tour_id='585' |
0.0002439022064209 |
245 |
SELECT * FROM default_featurepackage WHERE mod_page='reviews' and act_page='default' and type='default' and type_page='tour' order by order_no ASC limit 0,1 |
0.00099396705627441 |
246 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00018501281738281 |
247 |
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.0011160373687744 |
248 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0001978874206543 |
249 |
SELECT reviews_id,profile_id, review_date,table_id,rates,content,fullname FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and table_id = '585' and type='tour' and profile_id = 0 order by order_no DESC |
0.0034830570220947 |
250 |
SELECT country_id FROM _country WHERE is_trash=0 and country_id<>'9' order by order_no asc |
0.025047063827515 |
251 |
SELECT title FROM _country WHERE country_id='247' |
0.00033092498779297 |
252 |
SELECT title FROM _country WHERE country_id='2' |
0.00020217895507812 |
253 |
SELECT title FROM _country WHERE country_id='3' |
0.00018215179443359 |
254 |
SELECT title FROM _country WHERE country_id='4' |
0.00014591217041016 |
255 |
SELECT title FROM _country WHERE country_id='5' |
0.00010991096496582 |
256 |
SELECT title FROM _country WHERE country_id='6' |
0.00017213821411133 |
257 |
SELECT title FROM _country WHERE country_id='7' |
0.00014615058898926 |
258 |
SELECT title FROM _country WHERE country_id='8' |
0.00011396408081055 |
259 |
SELECT title FROM _country WHERE country_id='10' |
0.00017595291137695 |
260 |
SELECT title FROM _country WHERE country_id='11' |
0.00013899803161621 |
261 |
SELECT title FROM _country WHERE country_id='12' |
0.00020289421081543 |
262 |
SELECT title FROM _country WHERE country_id='13' |
0.00016403198242188 |
263 |
SELECT title FROM _country WHERE country_id='14' |
0.00012588500976562 |
264 |
SELECT title FROM _country WHERE country_id='15' |
0.00018811225891113 |
265 |
SELECT title FROM _country WHERE country_id='16' |
0.00015401840209961 |
266 |
SELECT title FROM _country WHERE country_id='17' |
0.00011992454528809 |
267 |
SELECT title FROM _country WHERE country_id='18' |
0.00018405914306641 |
268 |
SELECT title FROM _country WHERE country_id='19' |
0.00014710426330566 |
269 |
SELECT title FROM _country WHERE country_id='20' |
0.00010991096496582 |
270 |
SELECT title FROM _country WHERE country_id='21' |
0.00017213821411133 |
271 |
SELECT title FROM _country WHERE country_id='22' |
0.00013399124145508 |
272 |
SELECT title FROM _country WHERE country_id='23' |
0.00019478797912598 |
273 |
SELECT title FROM _country WHERE country_id='24' |
0.00015711784362793 |
274 |
SELECT title FROM _country WHERE country_id='25' |
0.00011801719665527 |
275 |
SELECT title FROM _country WHERE country_id='26' |
0.00018787384033203 |
276 |
SELECT title FROM _country WHERE country_id='27' |
0.00015091896057129 |
277 |
SELECT title FROM _country WHERE country_id='28' |
0.00013113021850586 |
278 |
SELECT title FROM _country WHERE country_id='29' |
0.00019288063049316 |
279 |
SELECT title FROM _country WHERE country_id='31' |
0.00015497207641602 |
280 |
SELECT title FROM _country WHERE country_id='32' |
0.00011801719665527 |
281 |
SELECT title FROM _country WHERE country_id='33' |
0.00018191337585449 |
282 |
SELECT title FROM _country WHERE country_id='34' |
0.00014495849609375 |
283 |
SELECT title FROM _country WHERE country_id='35' |
0.00010895729064941 |
284 |
SELECT title FROM _country WHERE country_id='36' |
0.00017213821411133 |
285 |
SELECT title FROM _country WHERE country_id='40' |
0.00013494491577148 |
286 |
SELECT title FROM _country WHERE country_id='41' |
0.00022315979003906 |
287 |
SELECT title FROM _country WHERE country_id='42' |
0.00019311904907227 |
288 |
SELECT title FROM _country WHERE country_id='43' |
0.00015616416931152 |
289 |
SELECT title FROM _country WHERE country_id='44' |
0.00011897087097168 |
290 |
SELECT title FROM _country WHERE country_id='45' |
0.0001828670501709 |
291 |
SELECT title FROM _country WHERE country_id='46' |
0.00014519691467285 |
292 |
SELECT title FROM _country WHERE country_id='47' |
0.00010895729064941 |
293 |
SELECT title FROM _country WHERE country_id='48' |
0.00018095970153809 |
294 |
SELECT title FROM _country WHERE country_id='49' |
0.00014591217041016 |
295 |
SELECT title FROM _country WHERE country_id='50' |
0.00010919570922852 |
296 |
SELECT title FROM _country WHERE country_id='51' |
0.00019693374633789 |
297 |
SELECT title FROM _country WHERE country_id='52' |
0.00016188621520996 |
298 |
SELECT title FROM _country WHERE country_id='53' |
0.00012588500976562 |
299 |
SELECT title FROM _country WHERE country_id='54' |
0.00019097328186035 |
300 |
SELECT title FROM _country WHERE country_id='55' |
0.00015497207641602 |
301 |
SELECT title FROM _country WHERE country_id='56' |
0.00013589859008789 |
302 |
SELECT title FROM _country WHERE country_id='57' |
0.00020003318786621 |
303 |
SELECT title FROM _country WHERE country_id='58' |
0.00016403198242188 |
304 |
SELECT title FROM _country WHERE country_id='59' |
0.00012898445129395 |
305 |
SELECT title FROM _country WHERE country_id='60' |
0.00019407272338867 |
306 |
SELECT title FROM _country WHERE country_id='61' |
0.00015902519226074 |
307 |
SELECT title FROM _country WHERE country_id='62' |
0.00012493133544922 |
308 |
SELECT title FROM _country WHERE country_id='63' |
0.00018906593322754 |
309 |
SELECT title FROM _country WHERE country_id='64' |
0.00017595291137695 |
310 |
SELECT title FROM _country WHERE country_id='65' |
0.00014114379882812 |
311 |
SELECT title FROM _country WHERE country_id='66' |
0.00021696090698242 |
312 |
SELECT title FROM _country WHERE country_id='67' |
0.00018215179443359 |
313 |
SELECT title FROM _country WHERE country_id='68' |
0.00014495849609375 |
314 |
SELECT title FROM _country WHERE country_id='69' |
0.00010895729064941 |
315 |
SELECT title FROM _country WHERE country_id='70' |
0.00017285346984863 |
316 |
SELECT title FROM _country WHERE country_id='71' |
0.00013899803161621 |
317 |
SELECT title FROM _country WHERE country_id='72' |
0.00021600723266602 |
318 |
SELECT title FROM _country WHERE country_id='73' |
0.00018191337585449 |
319 |
SELECT title FROM _country WHERE country_id='74' |
0.00014901161193848 |
320 |
SELECT title FROM _country WHERE country_id='75' |
0.00011301040649414 |
321 |
SELECT title FROM _country WHERE country_id='76' |
0.00017690658569336 |
322 |
SELECT title FROM _country WHERE country_id='77' |
0.00014185905456543 |
323 |
SELECT title FROM _country WHERE country_id='78' |
0.0001068115234375 |
324 |
SELECT title FROM _country WHERE country_id='79' |
0.00017309188842773 |
325 |
SELECT title FROM _country WHERE country_id='80' |
0.0001518726348877 |
326 |
SELECT title FROM _country WHERE country_id='81' |
0.00011801719665527 |
327 |
SELECT title FROM _country WHERE country_id='82' |
0.00018405914306641 |
328 |
SELECT title FROM _country WHERE country_id='83' |
0.00014805793762207 |
329 |
SELECT title FROM _country WHERE country_id='84' |
0.00011301040649414 |
330 |
SELECT title FROM _country WHERE country_id='85' |
0.00017714500427246 |
331 |
SELECT title FROM _country WHERE country_id='86' |
0.00014209747314453 |
332 |
SELECT title FROM _country WHERE country_id='87' |
0.00020790100097656 |
333 |
SELECT title FROM _country WHERE country_id='88' |
0.00017213821411133 |
334 |
SELECT title FROM _country WHERE country_id='89' |
0.00013613700866699 |
335 |
SELECT title FROM _country WHERE country_id='90' |
0.00020885467529297 |
336 |
SELECT title FROM _country WHERE country_id='92' |
0.00017380714416504 |
337 |
SELECT title FROM _country WHERE country_id='93' |
0.00013899803161621 |
338 |
SELECT title FROM _country WHERE country_id='94' |
0.00020408630371094 |
339 |
SELECT title FROM _country WHERE country_id='95' |
0.0001678466796875 |
340 |
SELECT title FROM _country WHERE country_id='96' |
0.00013184547424316 |
341 |
SELECT title FROM _country WHERE country_id='97' |
0.00019693374633789 |
342 |
SELECT title FROM _country WHERE country_id='98' |
0.00016093254089355 |
343 |
SELECT title FROM _country WHERE country_id='99' |
0.00012493133544922 |
344 |
SELECT title FROM _country WHERE country_id='100' |
0.00019001960754395 |
345 |
SELECT title FROM _country WHERE country_id='101' |
0.00015401840209961 |
346 |
SELECT title FROM _country WHERE country_id='102' |
0.0046510696411133 |
347 |
SELECT title FROM _country WHERE country_id='103' |
0.00032615661621094 |
348 |
SELECT title FROM _country WHERE country_id='105' |
0.00019121170043945 |
349 |
SELECT title FROM _country WHERE country_id='106' |
0.00016498565673828 |
350 |
SELECT title FROM _country WHERE country_id='107' |
0.00012898445129395 |
351 |
SELECT title FROM _country WHERE country_id='108' |
0.00020980834960938 |
352 |
SELECT title FROM _country WHERE country_id='109' |
0.00021219253540039 |
353 |
SELECT title FROM _country WHERE country_id='110' |
0.00019502639770508 |
354 |
SELECT title FROM _country WHERE country_id='111' |
0.00016307830810547 |
355 |
SELECT title FROM _country WHERE country_id='112' |
0.00012612342834473 |
356 |
SELECT title FROM _country WHERE country_id='113' |
0.00019288063049316 |
357 |
SELECT title FROM _country WHERE country_id='114' |
0.00016212463378906 |
358 |
SELECT title FROM _country WHERE country_id='115' |
0.00014305114746094 |
359 |
SELECT title FROM _country WHERE country_id='116' |
0.00011205673217773 |
360 |
SELECT title FROM _country WHERE country_id='117' |
0.00018787384033203 |
361 |
SELECT title FROM _country WHERE country_id='118' |
0.00017118453979492 |
362 |
SELECT title FROM _country WHERE country_id='119' |
0.00013613700866699 |
363 |
SELECT title FROM _country WHERE country_id='120' |
0.0002138614654541 |
364 |
SELECT title FROM _country WHERE country_id='121' |
0.00018191337585449 |
365 |
SELECT title FROM _country WHERE country_id='122' |
0.00014519691467285 |
366 |
SELECT title FROM _country WHERE country_id='123' |
0.00012016296386719 |
367 |
SELECT title FROM _country WHERE country_id='124' |
0.00018596649169922 |
368 |
SELECT title FROM _country WHERE country_id='125' |
0.0001828670501709 |
369 |
SELECT title FROM _country WHERE country_id='126' |
0.00015997886657715 |
370 |
SELECT title FROM _country WHERE country_id='127' |
0.00012516975402832 |
371 |
SELECT title FROM _country WHERE country_id='129' |
0.00019192695617676 |
372 |
SELECT title FROM _country WHERE country_id='130' |
0.00024700164794922 |
373 |
SELECT title FROM _country WHERE country_id='131' |
0.00011205673217773 |
374 |
SELECT title FROM _country WHERE country_id='132' |
0.00018405914306641 |
375 |
SELECT title FROM _country WHERE country_id='133' |
0.00015091896057129 |
376 |
SELECT title FROM _country WHERE country_id='134' |
0.00011610984802246 |
377 |
SELECT title FROM _country WHERE country_id='135' |
0.00018119812011719 |
378 |
SELECT title FROM _country WHERE country_id='136' |
0.00014615058898926 |
379 |
SELECT title FROM _country WHERE country_id='137' |
0.00011014938354492 |
380 |
SELECT title FROM _country WHERE country_id='138' |
0.0001838207244873 |
381 |
SELECT title FROM _country WHERE country_id='139' |
0.00015020370483398 |
382 |
SELECT title FROM _country WHERE country_id='140' |
0.00011515617370605 |
383 |
SELECT title FROM _country WHERE country_id='141' |
0.00019097328186035 |
384 |
SELECT title FROM _country WHERE country_id='142' |
0.00015783309936523 |
385 |
SELECT title FROM _country WHERE country_id='143' |
0.00012302398681641 |
386 |
SELECT title FROM _country WHERE country_id='144' |
0.00018596649169922 |
387 |
SELECT title FROM _country WHERE country_id='145' |
0.00014996528625488 |
388 |
SELECT title FROM _country WHERE country_id='146' |
0.00011491775512695 |
389 |
SELECT title FROM _country WHERE country_id='147' |
0.00018095970153809 |
390 |
SELECT title FROM _country WHERE country_id='148' |
0.00014591217041016 |
391 |
SELECT title FROM _country WHERE country_id='149' |
0.00013184547424316 |
392 |
SELECT title FROM _country WHERE country_id='150' |
0.0002131462097168 |
393 |
SELECT title FROM _country WHERE country_id='151' |
0.00018095970153809 |
394 |
SELECT title FROM _country WHERE country_id='152' |
0.00014495849609375 |
395 |
SELECT title FROM _country WHERE country_id='153' |
0.00010991096496582 |
396 |
SELECT title FROM _country WHERE country_id='154' |
0.00017404556274414 |
397 |
SELECT title FROM _country WHERE country_id='155' |
0.0001380443572998 |
398 |
SELECT title FROM _country WHERE country_id='156' |
0.00020623207092285 |
399 |
SELECT title FROM _country WHERE country_id='157' |
0.00016999244689941 |
400 |
SELECT title FROM _country WHERE country_id='158' |
0.00013303756713867 |
401 |
SELECT title FROM _country WHERE country_id='159' |
0.00020694732666016 |
402 |
SELECT title FROM _country WHERE country_id='160' |
0.00017189979553223 |
403 |
SELECT title FROM _country WHERE country_id='161' |
0.00013518333435059 |
404 |
SELECT title FROM _country WHERE country_id='162' |
0.0001978874206543 |
405 |
SELECT title FROM _country WHERE country_id='163' |
0.00016093254089355 |
406 |
SELECT title FROM _country WHERE country_id='164' |
0.00012397766113281 |
407 |
SELECT title FROM _country WHERE country_id='165' |
0.00020503997802734 |
408 |
SELECT title FROM _country WHERE country_id='166' |
0.00020384788513184 |
409 |
SELECT title FROM _country WHERE country_id='167' |
0.00016903877258301 |
410 |
SELECT title FROM _country WHERE country_id='168' |
0.0049448013305664 |
411 |
SELECT title FROM _country WHERE country_id='169' |
0.00029206275939941 |
412 |
SELECT title FROM _country WHERE country_id='170' |
0.00015807151794434 |
413 |
SELECT title FROM _country WHERE country_id='171' |
0.00014805793762207 |
414 |
SELECT title FROM _country WHERE country_id='172' |
0.00012803077697754 |
415 |
SELECT title FROM _country WHERE country_id='173' |
0.00019288063049316 |
416 |
SELECT title FROM _country WHERE country_id='174' |
0.00015711784362793 |
417 |
SELECT title FROM _country WHERE country_id='175' |
0.00012016296386719 |
418 |
SELECT title FROM _country WHERE country_id='176' |
0.0001838207244873 |
419 |
SELECT title FROM _country WHERE country_id='177' |
0.00014996528625488 |
420 |
SELECT title FROM _country WHERE country_id='178' |
0.00011515617370605 |
421 |
SELECT title FROM _country WHERE country_id='179' |
0.00020694732666016 |
422 |
SELECT title FROM _country WHERE country_id='180' |
0.00017595291137695 |
423 |
SELECT title FROM _country WHERE country_id='181' |
0.00016498565673828 |
424 |
SELECT title FROM _country WHERE country_id='182' |
0.00013208389282227 |
425 |
SELECT title FROM _country WHERE country_id='184' |
0.00019693374633789 |
426 |
SELECT title FROM _country WHERE country_id='185' |
0.00016188621520996 |
427 |
SELECT title FROM _country WHERE country_id='186' |
0.00012779235839844 |
428 |
SELECT title FROM _country WHERE country_id='187' |
0.00019407272338867 |
429 |
SELECT title FROM _country WHERE country_id='188' |
0.00015997886657715 |
430 |
SELECT title FROM _country WHERE country_id='189' |
0.00012397766113281 |
431 |
SELECT title FROM _country WHERE country_id='190' |
0.0001981258392334 |
432 |
SELECT title FROM _country WHERE country_id='191' |
0.00020408630371094 |
433 |
SELECT title FROM _country WHERE country_id='192' |
0.00016999244689941 |
434 |
SELECT title FROM _country WHERE country_id='193' |
0.00013494491577148 |
435 |
SELECT title FROM _country WHERE country_id='194' |
0.00020194053649902 |
436 |
SELECT title FROM _country WHERE country_id='195' |
0.00017809867858887 |
437 |
SELECT title FROM _country WHERE country_id='196' |
0.00014495849609375 |
438 |
SELECT title FROM _country WHERE country_id='197' |
0.00010991096496582 |
439 |
SELECT title FROM _country WHERE country_id='198' |
0.00017499923706055 |
440 |
SELECT title FROM _country WHERE country_id='199' |
0.00014209747314453 |
441 |
SELECT title FROM _country WHERE country_id='200' |
0.00010895729064941 |
442 |
SELECT title FROM _country WHERE country_id='201' |
0.00017404556274414 |
443 |
SELECT title FROM _country WHERE country_id='202' |
0.00013899803161621 |
444 |
SELECT title FROM _country WHERE country_id='203' |
0.00020384788513184 |
445 |
SELECT title FROM _country WHERE country_id='204' |
0.0001680850982666 |
446 |
SELECT title FROM _country WHERE country_id='205' |
0.00013399124145508 |
447 |
SELECT title FROM _country WHERE country_id='206' |
0.00020194053649902 |
448 |
SELECT title FROM _country WHERE country_id='207' |
0.0001678466796875 |
449 |
SELECT title FROM _country WHERE country_id='208' |
0.00013303756713867 |
450 |
SELECT title FROM _country WHERE country_id='210' |
0.00019693374633789 |
451 |
SELECT title FROM _country WHERE country_id='211' |
0.00016188621520996 |
452 |
SELECT title FROM _country WHERE country_id='212' |
0.00014185905456543 |
453 |
SELECT title FROM _country WHERE country_id='213' |
0.00010919570922852 |
454 |
SELECT title FROM _country WHERE country_id='214' |
0.00018191337585449 |
455 |
SELECT title FROM _country WHERE country_id='215' |
0.00014805793762207 |
456 |
SELECT title FROM _country WHERE country_id='216' |
0.00012993812561035 |
457 |
SELECT title FROM _country WHERE country_id='217' |
0.00019693374633789 |
458 |
SELECT title FROM _country WHERE country_id='218' |
0.00016188621520996 |
459 |
SELECT title FROM _country WHERE country_id='219' |
0.00012898445129395 |
460 |
SELECT title FROM _country WHERE country_id='220' |
0.00019311904907227 |
461 |
SELECT title FROM _country WHERE country_id='221' |
0.00015807151794434 |
462 |
SELECT title FROM _country WHERE country_id='222' |
0.0001220703125 |
463 |
SELECT title FROM _country WHERE country_id='223' |
0.00018620491027832 |
464 |
SELECT title FROM _country WHERE country_id='224' |
0.00015115737915039 |
465 |
SELECT title FROM _country WHERE country_id='225' |
0.00011610984802246 |
466 |
SELECT title FROM _country WHERE country_id='226' |
0.00018191337585449 |
467 |
SELECT title FROM _country WHERE country_id='227' |
0.00014615058898926 |
468 |
SELECT title FROM _country WHERE country_id='228' |
0.00011205673217773 |
469 |
SELECT title FROM _country WHERE country_id='229' |
0.00017595291137695 |
470 |
SELECT title FROM _country WHERE country_id='230' |
0.00014591217041016 |
471 |
SELECT title FROM _country WHERE country_id='231' |
0.00012016296386719 |
472 |
SELECT title FROM _country WHERE country_id='232' |
0.00019502639770508 |
473 |
SELECT title FROM _country WHERE country_id='233' |
0.00016188621520996 |
474 |
SELECT title FROM _country WHERE country_id='234' |
0.00012588500976562 |
475 |
SELECT title FROM _country WHERE country_id='235' |
0.00019097328186035 |
476 |
SELECT title FROM _country WHERE country_id='236' |
0.00015497207641602 |
477 |
SELECT title FROM _country WHERE country_id='237' |
0.00011992454528809 |
478 |
SELECT title FROM _country WHERE country_id='238' |
0.00018405914306641 |
479 |
SELECT title FROM _country WHERE country_id='239' |
0.00014805793762207 |
480 |
SELECT title FROM _country WHERE country_id='240' |
0.00012898445129395 |
481 |
SELECT title FROM _country WHERE country_id='242' |
0.00019311904907227 |
482 |
SELECT title FROM _country WHERE country_id='245' |
0.00015711784362793 |
483 |
SELECT title FROM _country WHERE country_id='246' |
0.00012111663818359 |
484 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '585' and type='tour' |
0.0021629333496094 |
485 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '585' and rates='5' and type='tour' |
0.0019280910491943 |
486 |
SELECT reviews_id FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online = 1 and profile_id=0 and table_id='585' and type='tour' and rates >= 5 |
0.0018229484558105 |
487 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '585' and type='tour' |
0.0052170753479004 |
488 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '585' and rates='4' and type='tour' |
0.0020709037780762 |
489 |
SELECT reviews_id FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online = 1 and profile_id=0 and table_id='585' and type='tour' and rates >= 4 and rates < 5 |
0.00187087059021 |
490 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '585' and type='tour' |
0.011667013168335 |
491 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '585' and rates='3' and type='tour' |
0.0041069984436035 |
492 |
SELECT reviews_id FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online = 1 and profile_id=0 and table_id='585' and type='tour' and rates >= 3 and rates < 4 |
0.0018191337585449 |
493 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '585' and type='tour' |
0.0019230842590332 |
494 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '585' and rates='2' and type='tour' |
0.0020689964294434 |
495 |
SELECT reviews_id FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online = 1 and profile_id=0 and table_id='585' and type='tour' and rates >= 2 and rates < 3 |
0.0036098957061768 |
496 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '585' and type='tour' |
0.0032269954681396 |
497 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '585' and rates='1' and type='tour' |
0.003201961517334 |
498 |
SELECT reviews_id FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online = 1 and profile_id=0 and table_id='585' and type='tour' and rates >= 1 and rates < 2 |
0.0029740333557129 |
499 |
SELECT price_text FROM default_promotion WHERE promotion_id='' |
0.00025296211242676 |
500 |
SELECT check_mem_set FROM default_promotion WHERE promotion_id='' |
0.0004270076751709 |
501 |
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.0017108917236328 |
502 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00056982040405273 |
503 |
SELECT faq_id,title,slug FROM default_faq WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc limit 0,4 |
0.0044369697570801 |
504 |
SELECT why_id,title,image,intro FROM default_why WHERE lang_id='' and is_trash=0 and is_online=1 and type='TOUR' order by order_no ASC |
0.0061061382293701 |
505 |
SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='tour_related' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.0010519027709961 |
506 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00018596649169922 |
507 |
SELECT distinct cat_id FROM default_tour where tour_id=585 LIMIT 0,1 |
0.0001988410949707 |
508 |
SELECT tour_2_id FROM default_tour_extension WHERE lang_id='' and is_trash=0 and tour_1_id='585' and tour_2_id IN (SELECT tour_id FROM default_tour WHERE is_trash=0 and is_online=1) order by order_no asc |
0.02649712562561 |
509 |
SELECT tour_id,slug,title,image,duration_type,duration_custom,number_day,number_night FROM default_tour WHERE tour_id='583' |
0.00048708915710449 |
510 |
SELECT tour_id,slug,title,image,duration_type,duration_custom,number_day,number_night FROM default_tour WHERE tour_id='582' |
0.00031304359436035 |
511 |
SELECT tour_id,slug,title,image,duration_type,duration_custom,number_day,number_night FROM default_tour WHERE tour_id='584' |
0.0003209114074707 |
512 |
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.0025501251220703 |
513 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00019192695617676 |
514 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '583' and type='tour' |
0.0022091865539551 |
515 |
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.0019969940185547 |
516 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00017809867858887 |
517 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '582' and type='tour' |
0.0024700164794922 |
518 |
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.0012109279632568 |
519 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00018405914306641 |
520 |
SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '584' and type='tour' |
0.0045349597930908 |
521 |
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.0011739730834961 |
522 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00019192695617676 |
523 |
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.006458044052124 |
524 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0062620639801025 |
525 |
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.0066049098968506 |
526 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0056500434875488 |
527 |
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.007357120513916 |
528 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.004863977432251 |
529 |
SELECT slug FROM default_blogcat WHERE blogcat_id='21' |
0.0013008117675781 |
530 |
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.010580062866211 |
531 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0018768310546875 |