THE SOUTH

Chat with us

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour'	0.000946044921875
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00045299530029297
3	SELECT region_id,title,slug,country_id FROM default_region WHERE lang_id='' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no asc	0.0028719902038574
4	SELECT distinct country_id FROM default_region where region_id=54 LIMIT 0,1	0.0002739429473877
5	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='54' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0029308795928955
6	SELECT distinct country_id FROM default_region where region_id=2 LIMIT 0,1	0.00028109550476074
7	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='2' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0028917789459229
8	SELECT distinct country_id FROM default_region where region_id=4 LIMIT 0,1	0.0002601146697998
9	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='4' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0029511451721191
10	SELECT distinct country_id FROM default_region where region_id=3 LIMIT 0,1	0.00028896331787109
11	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='3' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0027351379394531
12	SELECT distinct country_id FROM default_region where region_id=1 LIMIT 0,1	0.00029301643371582
13	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='1' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0028259754180908
14	SELECT country_id,title,slug FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.0025961399078369
15	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.0035288333892822
16	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) AND city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0 ) order by order_no ASC	0.0029728412628174
17	SELECT tourcat_id,title,slug 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.0024590492248535
18	SELECT service_id,title,slug FROM default_service WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0027790069580078
19	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cat' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00092387199401855
20	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00028800964355469
21	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.0025041103363037
22	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.0026650428771973
23	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00028705596923828
24	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.00093603134155273
25	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026082992553711
26	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.00086593627929688
27	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026893615722656
28	SELECT tourcat_id,slug,title,intro FROM default_tour_category WHERE tourcat_id='403'	0.00039291381835938
29	SELECT tourcat_id FROM default_tour_category WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id='403'	0.0025889873504639
30	SELECT tour_id FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='403' or list_cat_id like '%\|403\|%')	0.0029230117797852
31	SELECT slug FROM default_tour_category WHERE tourcat_id='403'	0.00023007392883301
32	SELECT tour_id,departure_point_id,slug,title,image,duration_type,duration_custom,number_day,number_night FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='403' or list_cat_id like '%\|403\|%') order by order_no ASC LIMIT 0,15	0.0028669834136963
33	SELECT country_id FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0025191307067871
34	SELECT tourcat_id,title FROM default_tour_category WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0024449825286865
35	SELECT max(number_day) as max,min(number_day) as min FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='403' or list_cat_id like '%\|403\|%')	0.0025589466094971
36	SELECT max(min_price) as max,min(min_price) as min FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='403' or list_cat_id like '%\|403\|%')	0.0025780200958252
37	SELECT category_country_id,content FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and cat_id='403' and country_id = '' limit 0,1	0.0026860237121582
38	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/tours/the-south-c403'	0.0024409294128418
39	SELECT distinct image FROM default_tour_category where tourcat_id=403 LIMIT 0,1	0.00028705596923828
40	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.0009770393371582
41	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00030088424682617
42	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.0027530193328857
43	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/tours/the-south-c403' or config_link='/tours/the-south-c403') limit 1	0.0026159286499023
44	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.0011749267578125
45	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00031113624572754
46	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.00084400177001953
47	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025701522827148
48	SELECT title FROM default_tour_category WHERE tourcat_id='410'	0.00029087066650391
49	SELECT slug FROM default_tour_category WHERE tourcat_id='410'	0.00024294853210449
50	SELECT title FROM default_tour_category WHERE tourcat_id='403'	0.00024580955505371
51	SELECT slug FROM default_tour_category WHERE tourcat_id='403'	0.00018692016601562
52	SELECT title FROM default_tour_category WHERE tourcat_id='6'	0.00023794174194336
53	SELECT slug FROM default_tour_category WHERE tourcat_id='6'	0.00018095970153809
54	SELECT title FROM default_tour_category WHERE tourcat_id='8'	0.00033116340637207
55	SELECT slug FROM default_tour_category WHERE tourcat_id='8'	0.00019001960754395
56	SELECT title FROM default_tour_category WHERE tourcat_id='412'	0.00025606155395508
57	SELECT slug FROM default_tour_category WHERE tourcat_id='412'	0.00023293495178223
58	SELECT distinct country_id FROM default_city where city_id=392 LIMIT 0,1	0.00031185150146484
59	SELECT slug FROM default_country WHERE country_id='1'	0.00025701522827148
60	SELECT slug FROM default_city WHERE city_id='392'	0.0002448558807373
61	SELECT distinct country_id FROM default_city where city_id=426 LIMIT 0,1	0.00026321411132812
62	SELECT slug FROM default_country WHERE country_id='1'	0.00027990341186523
63	SELECT slug FROM default_city WHERE city_id='426'	0.00022697448730469
64	SELECT distinct country_id FROM default_city where city_id=415 LIMIT 0,1	0.00026488304138184
65	SELECT slug FROM default_country WHERE country_id='1'	0.00027203559875488
66	SELECT slug FROM default_city WHERE city_id='415'	0.00023984909057617
67	SELECT distinct country_id FROM default_city where city_id=383 LIMIT 0,1	0.00024604797363281
68	SELECT slug FROM default_country WHERE country_id='1'	0.00027298927307129
69	SELECT slug FROM default_city WHERE city_id='383'	0.00021910667419434
70	SELECT distinct country_id FROM default_city where city_id=399 LIMIT 0,1	0.00024199485778809
71	SELECT slug FROM default_country WHERE country_id='1'	0.0002291202545166
72	SELECT slug FROM default_city WHERE city_id='399'	0.00031900405883789
73	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.00098991394042969
74	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00027084350585938
75	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.00087618827819824
76	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025296211242676
77	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.00088691711425781
78	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025200843811035
79	SELECT * FROM default_service WHERE service_id='5'	0.00040698051452637
80	SELECT slug FROM default_service WHERE service_id='5'	0.00026106834411621
81	SELECT * FROM default_service WHERE service_id='19'	0.0002739429473877
82	SELECT slug FROM default_service WHERE service_id='19'	0.00028610229492188
83	SELECT * FROM default_service WHERE service_id='16'	0.00030612945556641
84	SELECT slug FROM default_service WHERE service_id='16'	0.00027585029602051
85	SELECT * FROM default_service WHERE service_id='2'	0.00030803680419922
86	SELECT slug FROM default_service WHERE service_id='2'	0.00025796890258789
87	SELECT * FROM default_service WHERE service_id='6'	0.00025582313537598
88	SELECT slug FROM default_service WHERE service_id='6'	0.00020194053649902
89	SELECT title FROM default_country WHERE country_id=''	0.00037312507629395
90	SELECT citystore_id,city_id FROM default_citystore WHERE lang_id='' and is_trash=0 and type='DEPARTUREPOINT' and city_id IN (SELECT city_id FROM default_city WHERE is_trash=0 and is_online=1) order by order_no ASC	0.0035400390625
91	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and city_id IN(392,400,383,399,426,650,379,415)	0.0025660991668701
92	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00030708312988281
93	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.0010089874267578
94	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026988983154297
95	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '572' and type='tour'	0.0029840469360352
96	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.0010368824005127
97	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0003349781036377
98	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '571' and type='tour'	0.0029499530792236
99	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.00099086761474609
100	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00032305717468262
101	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '570' and type='tour'	0.0024919509887695
102	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.0010881423950195
103	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00031304359436035
104	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '569' and type='tour'	0.0027658939361572
105	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.0014431476593018
106	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00028085708618164
107	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '563' and type='tour'	0.0027849674224854
108	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.0014758110046387
109	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00027799606323242
110	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '562' and type='tour'	0.0025429725646973
111	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.0010888576507568
112	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00056099891662598
113	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '561' and type='tour'	0.0025861263275146
114	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.0011720657348633
115	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00028085708618164
116	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '560' and type='tour'	0.0026018619537354
117	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.00096988677978516
118	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00029993057250977
119	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.0008089542388916
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025010108947754
121	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.00087380409240723
122	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00040888786315918

HO CHI MINH - CU CHI - MEKONG 3D2N

HO CHI MINH – CU CHI - MEKONG 4D3N

HO CHI MINH – CU CHI - MEKONG 5D4N

THE CENTRAL AND SOUTH VIET NAM 6D5N

Cu Chi Tunnels - Half Day

Saigon Night Tour by motorbike

Ho Chi Minh City - Half Day

HO CHI MINH MUI NE NHA TRANG 7D6N

About Us

OUR PACKAGE

BI’S HOUSE VIET NAM TRAVEL

Follow Us

Payment Channel