Hotels in Vietnam | Auasia Travel

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='hotel'	0.0012280941009521
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00030803680419922
3	SELECT country_id,title,slug,intro,image,image_menu FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.0025300979614258
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.0034539699554443
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.0022881031036377
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.002410888671875
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.0022871494293213
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.0024139881134033
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00025510787963867
10	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.00097393989562988
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022697448730469
12	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.00098705291748047
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023794174194336
14	SELECT * FROM default_featurepackage WHERE mod_page='guide' and act_page='cat' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00098204612731934
15	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021195411682129
16	SELECT country_id,slug,title,intro,content,intro_hotel,image_hotel FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 and slug='vietnam' LIMIT 0,1	0.002418041229248
17	SELECT intro_hotel FROM default_country WHERE country_id='1'	0.0002748966217041
18	SELECT slug FROM default_country WHERE country_id='1'	0.00020503997802734
19	SELECT * FROM default_featurepackage WHERE mod_page='region' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00099301338195801
20	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023698806762695
21	SELECT region_id,title FROM default_region WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' order by order_no ASC	0.0024158954620361
22	SELECT city_id,title FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id=0 and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1) order by order_no ASC	0.0030910968780518
23	SELECT hotel_id FROM default_hotel WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1'	0.0027151107788086
24	SELECT hotel_id,star_id,slug,title,address,address_map,intro,image FROM default_hotel WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' order by order_no ASC LIMIT 9,9	0.0028998851776123
25	SELECT * FROM default_featurepackage WHERE mod_page='blog' and act_page='blog_destination' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.0010340213775635
26	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024700164794922
27	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'a%' or slug like 'A%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0029919147491455
28	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'b%' or slug like 'B%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.002964973449707
29	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'c%' or slug like 'C%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0030050277709961
30	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'd%' or slug like 'D%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.002964973449707
31	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'e%' or slug like 'E%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0029308795928955
32	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'f%' or slug like 'F%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.003040075302124
33	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'g%' or slug like 'G%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0029089450836182
34	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'h%' or slug like 'H%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0029540061950684
35	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'i%' or slug like 'I%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0029549598693848
36	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'j%' or slug like 'J%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0029349327087402
37	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'k%' or slug like 'K%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0068531036376953
38	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'l%' or slug like 'L%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.002938985824585
39	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'm%' or slug like 'M%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0028998851776123
40	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'n%' or slug like 'N%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.002838134765625
41	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'o%' or slug like 'O%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0027780532836914
42	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'p%' or slug like 'P%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0027940273284912
43	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'q%' or slug like 'Q%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0028018951416016
44	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'r%' or slug like 'R%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0028541088104248
45	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 's%' or slug like 'S%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0026979446411133
46	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 't%' or slug like 'T%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0028510093688965
47	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'u%' or slug like 'U%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.002741813659668
48	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'v%' or slug like 'V%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0027120113372803
49	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'w%' or slug like 'W%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0027940273284912
50	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'x%' or slug like 'X%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0027949810028076
51	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'y%' or slug like 'Y%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0027430057525635
52	SELECT city_id FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id<>'' and (slug like 'z%' or slug like 'Z%') and city_id IN (SELECT city_id FROM default_hotel WHERE is_trash=0 and is_online=1)	0.0027761459350586
53	SELECT * FROM default_featurepackage WHERE mod_page='hotel' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00090408325195312
54	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020718574523926
55	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.0008690357208252
56	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025510787963867
57	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.0021560192108154
58	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/hotels/vietnam&page=2' or config_link='/hotels/vietnam&page=2') limit 1	0.003154993057251
59	SELECT slug FROM default_country WHERE country_id='1'	0.00018501281738281
60	SELECT slug FROM default_country WHERE country_id='64'	0.0001828670501709
61	SELECT slug FROM default_country WHERE country_id='3'	0.00017714500427246
62	SELECT slug FROM default_country WHERE country_id='7'	0.0001671314239502
63	SELECT * FROM default_featurepackage WHERE mod_page='tour_exhautive' and act_page='category_country' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0008690357208252
64	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019192695617676
65	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' order by order_no ASC	0.0022099018096924
66	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='64' order by order_no ASC	0.0021820068359375
67	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='3' order by order_no ASC	0.0021748542785645
68	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='7' order by order_no ASC	0.0021510124206543
69	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' order by order_no ASC	0.0021369457244873
70	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00014400482177734
71	SELECT slug FROM default_country WHERE country_id='1'	0.0001370906829834
72	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00022506713867188
73	SELECT slug FROM default_country WHERE country_id='1'	0.00021219253540039
74	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00019693374633789
75	SELECT slug FROM default_country WHERE country_id='1'	0.00018405914306641
76	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.0001680850982666
77	SELECT slug FROM default_country WHERE country_id='1'	0.00018882751464844
78	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00017380714416504
79	SELECT slug FROM default_country WHERE country_id='1'	0.00017499923706055
80	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00016307830810547
81	SELECT slug FROM default_country WHERE country_id='1'	0.00015115737915039
82	SELECT image_menu FROM default_country WHERE country_id='1'	0.00014090538024902
83	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='64' order by order_no ASC	0.0021810531616211
84	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00018405914306641
85	SELECT slug FROM default_country WHERE country_id='64'	0.00017809867858887
86	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00016903877258301
87	SELECT slug FROM default_country WHERE country_id='64'	0.00015997886657715
88	SELECT image_menu FROM default_country WHERE country_id='64'	0.00014996528625488
89	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='3' order by order_no ASC	0.002180814743042
90	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00018501281738281
91	SELECT slug FROM default_country WHERE country_id='3'	0.00017809867858887
92	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00016307830810547
93	SELECT slug FROM default_country WHERE country_id='3'	0.00015091896057129
94	SELECT image_menu FROM default_country WHERE country_id='3'	0.00014185905456543
95	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='7' order by order_no ASC	0.0021610260009766
96	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00016498565673828
97	SELECT slug FROM default_country WHERE country_id='7'	0.00015401840209961
98	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00015592575073242
99	SELECT slug FROM default_country WHERE country_id='7'	0.00014686584472656
100	SELECT image_menu FROM default_country WHERE country_id='7'	0.00013303756713867
101	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00013613700866699
102	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00022101402282715
103	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00020790100097656
104	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00018906593322754
105	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00017404556274414
106	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00015497207641602
107	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00014209747314453
108	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00012493133544922
109	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00021100044250488
110	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00022506713867188
111	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00021600723266602
112	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00019693374633789
113	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.0001838207244873
114	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00016498565673828
115	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00015115737915039
116	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00013208389282227
117	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00021696090698242
118	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00025200843811035
119	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00086021423339844
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001990795135498
121	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='51' and is_trash=0 and is_online=1 order by order_no ASC	0.0021450519561768
122	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.0001380443572998
123	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='49' and is_trash=0 and is_online=1 order by order_no ASC	0.0022060871124268
124	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='49' and is_trash=0 and is_online=1 order by order_no ASC	0.0021378993988037
125	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00022602081298828
126	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='6' and is_trash=0 and is_online=1 order by order_no ASC	0.0021891593933105
127	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='6' and is_trash=0 and is_online=1 order by order_no ASC	0.0021350383758545
128	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00022006034851074
129	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='50' and is_trash=0 and is_online=1 order by order_no ASC	0.0021820068359375
130	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='50' and is_trash=0 and is_online=1 order by order_no ASC	0.0021140575408936
131	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00020098686218262
132	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='7' and is_trash=0 and is_online=1 order by order_no ASC	0.0021519660949707
133	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='7' and is_trash=0 and is_online=1 order by order_no ASC	0.002100944519043
134	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00019097328186035
135	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='4' and is_trash=0 and is_online=1 order by order_no ASC	0.0022358894348145
136	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='4' and is_trash=0 and is_online=1 order by order_no ASC	0.0022139549255371
137	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00022697448730469
138	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='2' and is_trash=0 and is_online=1 order by order_no ASC	0.0021810531616211
139	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='2' and is_trash=0 and is_online=1 order by order_no ASC	0.0021438598632812
140	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00083708763122559
141	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019598007202148
142	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='57' and is_trash=0 and is_online=1 order by order_no ASC	0.0021600723266602
143	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00014781951904297
144	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='58' and is_trash=0 and is_online=1 order by order_no ASC	0.0020751953125
145	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='58' and is_trash=0 and is_online=1 order by order_no ASC	0.0021791458129883
146	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00016999244689941
147	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='59' and is_trash=0 and is_online=1 order by order_no ASC	0.0021109580993652
148	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='59' and is_trash=0 and is_online=1 order by order_no ASC	0.0023188591003418
149	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00090885162353516
150	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018906593322754
151	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='60' and is_trash=0 and is_online=1 order by order_no ASC	0.0021910667419434
152	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00086498260498047
153	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020313262939453
154	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='54' and is_trash=0 and is_online=1 order by order_no ASC	0.0021820068359375
155	SELECT * FROM default_featurepackage WHERE mod_page='hotel' and act_page='price_range' and type='default' and type_page='' order by order_no ASC limit 0,1	0.000946044921875
156	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019311904907227
157	SELECT country_id FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 and slug='vietnam' LIMIT 0,1	0.0022358894348145
158	SELECT property_id,title FROM default_property WHERE lang_id='' and is_trash=0 and type='TypeHotel' order by order_no asc	0.0024130344390869
159	SELECT country_id FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 and slug='vietnam' LIMIT 0,1	0.0021591186523438
160	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.00086212158203125
161	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019192695617676
162	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '516' and type='hotel'	0.0050780773162842
163	SELECT price_avg FROM default_hotel WHERE hotel_id='516'	0.00022101402282715
164	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00018811225891113
165	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.00089812278747559
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019097328186035
167	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '515' and type='hotel'	0.0049750804901123
168	SELECT price_avg FROM default_hotel WHERE hotel_id='515'	0.00015020370483398
169	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00018906593322754
170	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.00082898139953613
171	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018882751464844
172	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '514' and type='hotel'	0.0050890445709229
173	SELECT price_avg FROM default_hotel WHERE hotel_id='514'	0.00023388862609863
174	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00018811225891113
175	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.00093197822570801
176	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020909309387207
177	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '513' and type='hotel'	0.0051019191741943
178	SELECT price_avg FROM default_hotel WHERE hotel_id='513'	0.00017189979553223
179	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00019097328186035
180	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.00094389915466309
181	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019097328186035
182	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '512' and type='hotel'	0.0050370693206787
183	SELECT price_avg FROM default_hotel WHERE hotel_id='512'	0.00020194053649902
184	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00018596649169922
185	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.0009160041809082
186	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019598007202148
187	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '511' and type='hotel'	0.0050590038299561
188	SELECT price_avg FROM default_hotel WHERE hotel_id='511'	0.00020980834960938
189	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00019097328186035
190	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.00095605850219727
191	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020408630371094
192	SELECT testimonial_id,title,slug,image,reg_date,rates,name,intro FROM default_testimonial WHERE lang_id='' and is_trash=0 and is_online = 1 and image<>'' order by order_no ASC limit 0,9	0.0023550987243652
193	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00020003318786621
194	SELECT title FROM _country WHERE country_id='193'	0.00020503997802734
195	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00022196769714355
196	SELECT title FROM _country WHERE country_id='103'	0.00020885467529297
197	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00022196769714355
198	SELECT title FROM _country WHERE country_id='229'	0.00020909309387207
199	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00021910667419434
200	SELECT title FROM _country WHERE country_id='14'	0.00020599365234375
201	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00021696090698242
202	SELECT title FROM _country WHERE country_id='175'	0.00020194053649902
203	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.0002138614654541
204	SELECT title FROM _country WHERE country_id='228'	0.00019979476928711
205	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00021100044250488
206	SELECT title FROM _country WHERE country_id='42'	0.0002140998840332
207	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00012898445129395
208	SELECT title FROM _country WHERE country_id='134'	0.00021696090698242
209	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00012898445129395
210	SELECT title FROM _country WHERE country_id='77'	0.00021600723266602
211	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.00089693069458008
212	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019001960754395
213	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.00087809562683105
214	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018501281738281
215	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.00086712837219238
216	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018501281738281
217	SELECT * 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.00088191032409668
218	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021791458129883
219	SELECT * 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.0009009838104248
220	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018787384033203
221	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.00087189674377441
222	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922