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.00090694427490234
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00027799606323242
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.0021781921386719
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.0027248859405518
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.0020270347595215
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.0021951198577881
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.0020239353179932
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.0019450187683105
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00022292137145996
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.00097990036010742
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021719932556152
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.0016720294952393
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00027680397033691
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.002112865447998
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.0017900466918945
16	SELECT title FROM default_testimonial WHERE testimonial_id='12'	0.00017285346984863
17	SELECT intro FROM default_testimonial WHERE testimonial_id='12'	0.00021600723266602
18	SELECT slug FROM default_testimonial WHERE testimonial_id='12'	0.00014591217041016
19	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/te12-fantastic-indochina.html'	0.0025198459625244
20	SELECT image FROM default_meta WHERE meta_id='37'	0.00020623207092285
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.00089788436889648
22	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019502639770508
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.00080490112304688
24	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017786026000977
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.0017600059509277
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.0016889572143555
27	SELECT slug FROM default_country WHERE country_id='1'	0.00018501281738281
28	SELECT slug FROM default_country WHERE country_id='64'	0.00019502639770508
29	SELECT slug FROM default_country WHERE country_id='3'	0.00020599365234375
30	SELECT slug FROM default_country WHERE country_id='7'	0.00021481513977051
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.00095200538635254
32	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019598007202148
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.001878023147583
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.0018439292907715
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.0017960071563721
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.0018570423126221
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.0018229484558105
38	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00024700164794922
39	SELECT slug FROM default_country WHERE country_id='1'	0.00014805793762207
40	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.0001530647277832
41	SELECT slug FROM default_country WHERE country_id='1'	0.00016593933105469
42	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.0001838207244873
43	SELECT slug FROM default_country WHERE country_id='1'	0.0001990795135498
44	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00020909309387207
45	SELECT slug FROM default_country WHERE country_id='1'	0.00022101402282715
46	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.0002439022064209
47	SELECT slug FROM default_country WHERE country_id='1'	0.00019407272338867
48	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00018095970153809
49	SELECT slug FROM default_country WHERE country_id='1'	0.00018501281738281
50	SELECT image_menu FROM default_country WHERE country_id='1'	0.00020098686218262
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.0018570423126221
52	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00016093254089355
53	SELECT slug FROM default_country WHERE country_id='64'	0.00018000602722168
54	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00025391578674316
55	SELECT slug FROM default_country WHERE country_id='64'	0.00016188621520996
56	SELECT image_menu FROM default_country WHERE country_id='64'	0.00017189979553223
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.002626895904541
58	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00029587745666504
59	SELECT slug FROM default_country WHERE country_id='3'	0.00019001960754395
60	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00019311904907227
61	SELECT slug FROM default_country WHERE country_id='3'	0.00030994415283203
62	SELECT image_menu FROM default_country WHERE country_id='3'	0.00029110908508301
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.0030279159545898
64	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00027298927307129
65	SELECT slug FROM default_country WHERE country_id='7'	0.00018596649169922
66	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00017690658569336
67	SELECT slug FROM default_country WHERE country_id='7'	0.00019121170043945
68	SELECT image_menu FROM default_country WHERE country_id='7'	0.00019311904907227
69	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00019311904907227
70	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00021100044250488
71	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00024199485778809
72	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00014495849609375
73	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00015497207641602
74	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00016593933105469
75	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00019001960754395
76	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00019383430480957
77	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00021100044250488
78	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00021600723266602
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.00014710426330566
81	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00015807151794434
82	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00016307830810547
83	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00017690658569336
84	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00019288063049316
85	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00020098686218262
86	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00019502639770508
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.001446008682251
88	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026798248291016
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.0029499530792236
90	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00021910667419434
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.0030279159545898
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.0030770301818848
93	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00022292137145996
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.0028901100158691
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.0028097629547119
96	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00022983551025391
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.0028262138366699
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.0028061866760254
99	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00023794174194336
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.0027339458465576
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.0025441646575928
102	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00011587142944336
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.0016980171203613
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.0016701221466064
105	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00015091896057129
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.0016210079193115
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.0017449855804443
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.00079607963562012
109	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017786026000977
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.0016992092132568
111	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00016999244689941
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.0016789436340332
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.0016560554504395
114	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00013899803161621
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.0017290115356445
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.00081801414489746
118	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017094612121582
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.0017008781433105
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.000823974609375
121	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018191337585449
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.0016860961914062
123	SELECT title FROM default_testimonial WHERE testimonial_id='12'	0.00024199485778809
124	SELECT rates FROM default_testimonial WHERE testimonial_id='12'	0.00019502639770508
125	SELECT name FROM default_testimonial WHERE testimonial_id='12'	0.0005028247833252
126	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00030994415283203
127	SELECT title FROM _country WHERE country_id='103'	0.00022196769714355
128	SELECT intro FROM default_testimonial WHERE testimonial_id='12'	0.00022792816162109
129	SELECT title FROM default_testimonial WHERE testimonial_id='8'	0.00014305114746094
130	SELECT slug FROM default_testimonial WHERE testimonial_id='8'	0.00014901161193848
131	SELECT image FROM default_testimonial WHERE testimonial_id='8'	0.00015687942504883
132	SELECT intro FROM default_testimonial WHERE testimonial_id='8'	0.00021100044250488
133	SELECT name FROM default_testimonial WHERE testimonial_id='8'	0.00032591819763184
134	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00022411346435547
135	SELECT title FROM _country WHERE country_id='175'	0.00022101402282715
136	SELECT rates FROM default_testimonial WHERE testimonial_id='8'	0.0002140998840332
137	SELECT title FROM default_testimonial WHERE testimonial_id='6'	0.00021100044250488
138	SELECT slug FROM default_testimonial WHERE testimonial_id='6'	0.00072002410888672
139	SELECT image FROM default_testimonial WHERE testimonial_id='6'	0.00027203559875488
140	SELECT intro FROM default_testimonial WHERE testimonial_id='6'	0.00023508071899414
141	SELECT name FROM default_testimonial WHERE testimonial_id='6'	0.00014305114746094
142	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00013399124145508
143	SELECT title FROM _country WHERE country_id='228'	0.00025296211242676
144	SELECT rates FROM default_testimonial WHERE testimonial_id='6'	0.00015687942504883
145	SELECT title FROM default_testimonial WHERE testimonial_id='5'	0.00016593933105469
146	SELECT slug FROM default_testimonial WHERE testimonial_id='5'	0.00015687942504883
147	SELECT image FROM default_testimonial WHERE testimonial_id='5'	0.00016617774963379
148	SELECT intro FROM default_testimonial WHERE testimonial_id='5'	0.00028610229492188
149	SELECT name FROM default_testimonial WHERE testimonial_id='5'	0.00023484230041504
150	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.0012600421905518
151	SELECT title FROM _country WHERE country_id='14'	0.00015592575073242
152	SELECT rates FROM default_testimonial WHERE testimonial_id='5'	0.00017189979553223
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.0030958652496338
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.00090813636779785
155	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017690658569336
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.00084090232849121
157	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001680850982666
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.00079488754272461
159	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001680850982666
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.0001671314239502
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.00080084800720215
163	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00016593933105469
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.0008399486541748
165	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017094612121582

Fantastic Indochina

See more

Vietnam Holiday 15 Days

The Best Of Vietnam

Exotic Vietnam & Cambodia

Global Support

Refund Guarantee

Best Price & Quality

Customer Experience

Information

Travel Styles

Other

Follow Us

Payment Channel