Blog listing by category Destination

Useful Things To Know Before Traveling To Vietnam

17 July, 2023 Hong Nhung

As Vietnam’s tourism numbers continue to shoot skywards, the debate over whether to hit the popular hotspots or veer down the path less traveled is hotly contested. Read more

Where To Stay In Halong Bay? Here Is Your Answer!

17 July, 2023 Hong Nhung

Resting during a trip is extremely vital. You won’t be able to enjoy any trip without getting fully charged with energies for a new day ahead. After a day of outside activities, you need a comfy place to take a good rest! But for your... Read more

Son Doong - World’s Largest Cave

17 July, 2023 Hong Nhung

The Phong Nha-Ke Bang National Park in Vietnam contains the oldest karst system in Asia, between 400-450 million years old. Hang Son Doong (Son Doong Cave) itself is relatively young, with the analysis of sediment dating it to be only 3 million... Read more

Explore Vietnamese Culture

18 July, 2023 Hong Nhung

After being pampered and tasting the best of Vietnamese cuisine, make sure that you make time to enjoy some of the traditional cultural experiences of the country. Read more

Diverse And Beautiful Landscapes

18 July, 2023 Hong Nhung

Vietnam is a country that is famous for its spectacular long coastline and there are some amazing spots to relax, as well as explore. Read more

Enjoy The Best Of Vietnamese Local Food

18 July, 2023 Hong Nhung

Another reason to travel to Vietnam is to enjoy the local food and, while many areas have a lot of international cuisine, it is well worth seeking out some of the restaurants serving the fresh and spicy tastes of Vietnamese food. Read more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog'	0.00095796585083008
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00043010711669922
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.002885103225708
4	SELECT distinct country_id FROM default_region where region_id=54 LIMIT 0,1	0.00027203559875488
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.0029671192169189
6	SELECT distinct country_id FROM default_region where region_id=2 LIMIT 0,1	0.00024700164794922
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.0029749870300293
8	SELECT distinct country_id FROM default_region where region_id=4 LIMIT 0,1	0.0003349781036377
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.0029628276824951
10	SELECT distinct country_id FROM default_region where region_id=3 LIMIT 0,1	0.0002591609954834
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.0029220581054688
12	SELECT distinct country_id FROM default_region where region_id=1 LIMIT 0,1	0.00025081634521484
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.0028529167175293
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.0025320053100586
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.0035231113433838
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.0030381679534912
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.0025060176849365
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.0027260780334473
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.00089287757873535
20	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002748966217041
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.0026118755340576
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.0028069019317627
23	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.0002901554107666
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.00099301338195801
25	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002739429473877
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.00027203559875488
28	SELECT blogcat_id,title,slug,intro FROM default_blogcat WHERE lang_id='' and is_trash=0 and is_online=1 and slug='destination' LIMIT 0,1	0.0029609203338623
29	SELECT slug FROM default_blogcat WHERE blogcat_id='6'	0.00022983551025391
30	SELECT blog_id FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (cat_id='6' or list_cat_id like '%\|6\|%')	0.0026118755340576
31	SELECT blog_id,cat_id,reg_date,publish_date,title,slug,author,image,intro FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (cat_id='6' or list_cat_id like '%\|6\|%') order by order_no ASC LIMIT 0,6	0.0027148723602295
32	SELECT intro FROM default_blogcat WHERE blogcat_id='6'	0.00020003318786621
33	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.00094509124755859
34	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026392936706543
35	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.0009300708770752
36	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023889541625977
37	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.0026998519897461
38	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/blog/destination.html' or config_link='/blog/destination.html') limit 1	0.0025699138641357
39	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.00099802017211914
40	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002601146697998
41	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.00089716911315918
42	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023889541625977
43	SELECT title FROM default_tour_category WHERE tourcat_id='410'	0.00030803680419922
44	SELECT slug FROM default_tour_category WHERE tourcat_id='410'	0.00025582313537598
45	SELECT title FROM default_tour_category WHERE tourcat_id='403'	0.00019693374633789
46	SELECT slug FROM default_tour_category WHERE tourcat_id='403'	0.00024294853210449
47	SELECT title FROM default_tour_category WHERE tourcat_id='6'	0.00019693374633789
48	SELECT slug FROM default_tour_category WHERE tourcat_id='6'	0.0002288818359375
49	SELECT title FROM default_tour_category WHERE tourcat_id='8'	0.0001990795135498
50	SELECT slug FROM default_tour_category WHERE tourcat_id='8'	0.00025010108947754
51	SELECT title FROM default_tour_category WHERE tourcat_id='412'	0.00020503997802734
52	SELECT slug FROM default_tour_category WHERE tourcat_id='412'	0.00023698806762695
53	SELECT distinct country_id FROM default_city where city_id=392 LIMIT 0,1	0.00030088424682617
54	SELECT slug FROM default_country WHERE country_id='1'	0.0002129077911377
55	SELECT slug FROM default_city WHERE city_id='392'	0.00025486946105957
56	SELECT distinct country_id FROM default_city where city_id=426 LIMIT 0,1	0.00027012825012207
57	SELECT slug FROM default_country WHERE country_id='1'	0.00018811225891113
58	SELECT slug FROM default_city WHERE city_id='426'	0.00022602081298828
59	SELECT distinct country_id FROM default_city where city_id=415 LIMIT 0,1	0.00023508071899414
60	SELECT slug FROM default_country WHERE country_id='1'	0.00025796890258789
61	SELECT slug FROM default_city WHERE city_id='415'	0.00025582313537598
62	SELECT distinct country_id FROM default_city where city_id=383 LIMIT 0,1	0.00023484230041504
63	SELECT slug FROM default_country WHERE country_id='1'	0.00026893615722656
64	SELECT slug FROM default_city WHERE city_id='383'	0.00021791458129883
65	SELECT distinct country_id FROM default_city where city_id=399 LIMIT 0,1	0.00023388862609863
66	SELECT slug FROM default_country WHERE country_id='1'	0.00021600723266602
67	SELECT slug FROM default_city WHERE city_id='399'	0.00029301643371582
68	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.0009918212890625
69	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025510787963867
70	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.00083804130554199
71	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00050616264343262
72	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.00084900856018066
73	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026297569274902
74	SELECT * FROM default_service WHERE service_id='5'	0.00029301643371582
75	SELECT slug FROM default_service WHERE service_id='5'	0.00023484230041504
76	SELECT * FROM default_service WHERE service_id='19'	0.00023007392883301
77	SELECT slug FROM default_service WHERE service_id='19'	0.00029397010803223
78	SELECT * FROM default_service WHERE service_id='16'	0.00030899047851562
79	SELECT slug FROM default_service WHERE service_id='16'	0.00026297569274902
80	SELECT * FROM default_service WHERE service_id='2'	0.0002739429473877
81	SELECT slug FROM default_service WHERE service_id='2'	0.00021195411682129
82	SELECT * FROM default_service WHERE service_id='6'	0.00029706954956055
83	SELECT slug FROM default_service WHERE service_id='6'	0.00023198127746582
84	SELECT blogcat_id, title,slug FROM default_blogcat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0030918121337891
85	SELECT blog_id,slug,title FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and num_view > 0 order by num_view desc limit 0,5	0.0029330253601074
86	SELECT tag_id FROM default_tag WHERE lang_id='' and tag_id IN (SELECT tag_id FROM default_tag_module WHERE 1=1 and type='BLOG')	0.0026440620422363
87	SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='57'	0.00026607513427734
88	SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='58'	0.00024104118347168
89	SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='59'	0.00026106834411621
90	SELECT blog_extension_id,tour_id FROM default_blog_extension WHERE lang_id='' and blog_id = '' and table_name='tour' and tour_id IN (SELECT tour_id FROM default_tour WHERE is_trash=0 and is_online=1) order by order_no ASC	0.0027120113372803
91	SELECT hotel_id FROM default_blog_extension WHERE lang_id='' and blog_id = '' and table_name='hotel' and hotel_id IN (SELECT hotel_id FROM default_hotel WHERE is_trash=0 and is_online=1) order by order_no ASC	0.0028159618377686
92	SELECT * FROM default_featurepackage WHERE mod_page='blog' and act_page='category' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0010471343994141
93	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0003049373626709
94	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.0012171268463135
95	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026893615722656
96	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.00085806846618652
97	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024080276489258
98	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.00079798698425293
99	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024199485778809

Blog listing by category Destination

Useful Things To Know Before Traveling To Vietnam

Where To Stay In Halong Bay? Here Is Your Answer!

Son Doong - World’s Largest Cave

Explore Vietnamese Culture

Diverse And Beautiful Landscapes

Enjoy The Best Of Vietnamese Local Food

About Us

OUR PACKAGE

BI’S HOUSE VIET NAM TRAVEL

Follow Us

Payment Channel