Fantastic Indochina

Shaleena, India

We want to thanks personally and directly to Sunny, he was just prefect and excellent on his service especially his concern all small details as well as big one just "SHAPPO!!". We want to say that we have been traveling a lot around the world, but we never met any Travel agency like you, you take care of us all the time, always response and support us 24/7…

Shaleena, India (From 5 Fabruary to 18 Fabruary)

Auasia Travel – The perfect choice for the most discerning travelers.

Traveller's strong energy for funny journey

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='testimonial'	0.00076508522033691
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00030994415283203
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.0018892288208008
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.0022850036621094
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.0018308162689209
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.0019621849060059
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.0018558502197266
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.0017721652984619
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00020813941955566
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.00083589553833008
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019598007202148
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.00081419944763184
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018095970153809
14	SELECT * FROM default_testimonial WHERE lang_id='' and is_trash=0 and is_online=1 and testimonial_id='12' and slug='fantastic-indochina'	0.0017650127410889
15	SELECT testimonial_id FROM default_testimonial WHERE lang_id='' and is_trash=0 and is_online=1 and testimonial_id<>'12' order by rand() limit 0,3	0.0016989707946777
16	SELECT title FROM default_testimonial WHERE testimonial_id='12'	0.00019598007202148
17	SELECT intro FROM default_testimonial WHERE testimonial_id='12'	0.00021195411682129
18	SELECT slug FROM default_testimonial WHERE testimonial_id='12'	0.00019383430480957
19	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/te12-fantastic-indochina.html'	0.0025699138641357
20	SELECT image FROM default_meta WHERE meta_id='37'	0.00017595291137695
21	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.00081706047058105
22	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020599365234375
23	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.00084304809570312
24	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020813941955566
25	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.0017349720001221
26	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/te12-fantastic-indochina.html' or config_link='/te12-fantastic-indochina.html') limit 1	0.0017130374908447
27	SELECT slug FROM default_country WHERE country_id='1'	0.00020289421081543
28	SELECT slug FROM default_country WHERE country_id='64'	0.00021791458129883
29	SELECT slug FROM default_country WHERE country_id='3'	0.00022506713867188
30	SELECT slug FROM default_country WHERE country_id='7'	0.00023412704467773
31	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.00081491470336914
32	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020813941955566
33	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.0018219947814941
34	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.0018200874328613
35	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.0018248558044434
36	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.0018348693847656
37	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.0017788410186768
38	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00020313262939453
39	SELECT slug FROM default_country WHERE country_id='1'	0.00022602081298828
40	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00025010108947754
41	SELECT slug FROM default_country WHERE country_id='1'	0.00016999244689941
42	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00019311904907227
43	SELECT slug FROM default_country WHERE country_id='1'	0.00020813941955566
44	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00021910667419434
45	SELECT slug FROM default_country WHERE country_id='1'	0.0002288818359375
46	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00024604797363281
47	SELECT slug FROM default_country WHERE country_id='1'	0.00015401840209961
48	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00016093254089355
49	SELECT slug FROM default_country WHERE country_id='1'	0.00017499923706055
50	SELECT image_menu FROM default_country WHERE country_id='1'	0.00018191337585449
51	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.0018711090087891
52	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00020694732666016
53	SELECT slug FROM default_country WHERE country_id='64'	0.00022387504577637
54	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00023508071899414
55	SELECT slug FROM default_country WHERE country_id='64'	0.00024604797363281
56	SELECT image_menu FROM default_country WHERE country_id='64'	0.00016689300537109
57	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.0017800331115723
58	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.0001981258392334
59	SELECT slug FROM default_country WHERE country_id='3'	0.00021505355834961
60	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00022792816162109
61	SELECT slug FROM default_country WHERE country_id='3'	0.00023984909057617
62	SELECT image_menu FROM default_country WHERE country_id='3'	0.00014591217041016
63	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.0017480850219727
64	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.0001678466796875
65	SELECT slug FROM default_country WHERE country_id='7'	0.00018000602722168
66	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00021004676818848
67	SELECT slug FROM default_country WHERE country_id='7'	0.00023913383483887
68	SELECT image_menu FROM default_country WHERE country_id='7'	0.00014996528625488
69	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00018405914306641
70	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00018906593322754
71	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00020194053649902
72	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00020194053649902
73	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00020790100097656
74	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00020980834960938
75	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00021696090698242
76	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00021815299987793
77	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00022411346435547
78	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00023007392883301
79	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00024008750915527
80	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.0001380443572998
81	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.0013999938964844
82	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00020408630371094
83	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00021600723266602
84	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00021886825561523
85	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.0002288818359375
86	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00026679039001465
87	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.00083398818969727
88	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022006034851074
89	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.0019268989562988
90	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00024008750915527
91	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.0016942024230957
92	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.0018880367279053
93	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00020194053649902
94	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.0021460056304932
95	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.0017199516296387
96	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00022792816162109
97	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.0017921924591064
98	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.0017640590667725
99	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00017595291137695
100	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.0017509460449219
101	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.0019488334655762
102	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00013899803161621
103	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.0017268657684326
104	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.0018000602722168
105	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00020480155944824
106	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.0017640590667725
107	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.0016911029815674
108	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.00084185600280762
109	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019288063049316
110	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.0016419887542725
111	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00012493133544922
112	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.0017900466918945
113	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.0016899108886719
114	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00017094612121582
115	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.0018899440765381
116	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.0017030239105225
117	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.00086617469787598
118	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020694732666016
119	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.00177001953125
120	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.00083589553833008
121	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020694732666016
122	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.0017638206481934
123	SELECT title FROM default_testimonial WHERE testimonial_id='12'	0.00019693374633789
124	SELECT rates FROM default_testimonial WHERE testimonial_id='12'	0.00019598007202148
125	SELECT name FROM default_testimonial WHERE testimonial_id='12'	0.00019598007202148
126	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00014114379882812
127	SELECT title FROM _country WHERE country_id='103'	0.00025391578674316
128	SELECT intro FROM default_testimonial WHERE testimonial_id='12'	0.00014805793762207
129	SELECT title FROM default_testimonial WHERE testimonial_id='9'	0.00015997886657715
130	SELECT slug FROM default_testimonial WHERE testimonial_id='9'	0.00015687942504883
131	SELECT image FROM default_testimonial WHERE testimonial_id='9'	0.00015020370483398
132	SELECT intro FROM default_testimonial WHERE testimonial_id='9'	0.00014209747314453
133	SELECT name FROM default_testimonial WHERE testimonial_id='9'	0.00022792816162109
134	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.0002129077911377
135	SELECT title FROM _country WHERE country_id='42'	0.00019693374633789
136	SELECT rates FROM default_testimonial WHERE testimonial_id='9'	0.00017595291137695
137	SELECT title FROM default_testimonial WHERE testimonial_id='11'	0.00015783309936523
138	SELECT slug FROM default_testimonial WHERE testimonial_id='11'	0.00013613700866699
139	SELECT image FROM default_testimonial WHERE testimonial_id='11'	0.00023102760314941
140	SELECT intro FROM default_testimonial WHERE testimonial_id='11'	0.0002138614654541
141	SELECT name FROM default_testimonial WHERE testimonial_id='11'	0.00020480155944824
142	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00019407272338867
143	SELECT title FROM _country WHERE country_id='134'	0.00018000602722168
144	SELECT rates FROM default_testimonial WHERE testimonial_id='11'	0.00017213821411133
145	SELECT title FROM default_testimonial WHERE testimonial_id='10'	0.00015711784362793
146	SELECT slug FROM default_testimonial WHERE testimonial_id='10'	0.0001380443572998
147	SELECT image FROM default_testimonial WHERE testimonial_id='10'	0.00022101402282715
148	SELECT intro FROM default_testimonial WHERE testimonial_id='10'	0.00020503997802734
149	SELECT name FROM default_testimonial WHERE testimonial_id='10'	0.00019598007202148
150	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00017404556274414
151	SELECT title FROM _country WHERE country_id='229'	0.00015497207641602
152	SELECT rates FROM default_testimonial WHERE testimonial_id='10'	0.00014781951904297
153	SELECT why_id,title,image,intro FROM default_why WHERE lang_id='' and is_trash=0 and is_online=1 and type='HOME' order by order_no ASC	0.0019359588623047
154	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.00085282325744629
155	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019502639770508
156	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.0007941722869873
157	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020503997802734
158	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.00075507164001465
159	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021219253540039
160	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.00082707405090332
161	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022506713867188
162	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.00082111358642578
163	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018095970153809
164	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.00084614753723145
165	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018310546875

Fantastic Indochina

See more

Vietnam Family Vacation

Vietnam In Capture

Vietnam Heritage Trail

Global Support

Refund Guarantee

Best Price & Quality

Customer Experience

Information

Travel Styles

Other

Follow Us

Payment Channel