Our Blog

Lan Ha Bay & Cat Ba Island

18 July, 2023 Hong Nhung

Lan Ha Bay Cat Ba: Review of Hai Phong's \"paradise pearl island\" Lan Ha Bay Cat Ba is loved by its wild and peaceful beauty, with many large and small islands with different shapes and beauties. Visiting Lan Ha Bay, visitors will experience... Read more

The Five H’s To Have In Your Vietnam Itinerary

19 July, 2023 Hong Nhung

Vietnam is easily one of the cheapest places in the world to travel in. For what little amount you pay, you get rewarded with a lot of things: stunning natural scenery, electric urban landscapes and, I cannot stress this enough, the... Read more

Vietnam Renews Visa Waiver Program For Europeans

19 July, 2023 Hong Nhung

The Vietnamese government has extended a visa exemption program for Germany, France, the UK, Italy and Spain for another year, local media reported Friday. Read more

1 2 3

Sign up for notifications & offers

Choosing to register means that you agree to our Privacy Policy.

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog'	0.00089311599731445
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00034499168395996
3	SELECT country_id,title,slug,intro,image FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.002601146697998
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.0028839111328125
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.002622127532959
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.0027511119842529
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.0027351379394531
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.0026769638061523
9	SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORAGETYPE' order by order_no ASC limit 0,1	0.0025968551635742
10	SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORHEIGHTTYPE' order by order_no ASC limit 0,1	0.0028259754180908
11	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00026702880859375
12	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.0010149478912354
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023484230041504
14	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.00094389915466309
15	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021696090698242
16	SELECT guidecat_id,slug,title FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.0036399364471436
17	SELECT blog_id FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1	0.0039610862731934
18	SELECT blog_id,cat_id,reg_date,publish_date,upd_date,author,list_tag_id,intro,title,slug,image FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 order by order_no ASC LIMIT 16,8	0.0030179023742676
19	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.0009770393371582
20	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024318695068359
21	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.0028648376464844
22	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/&page=3' or config_link='/blog/&page=3') limit 1	0.0026230812072754
23	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.0010411739349365
24	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024199485778809
25	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.00095891952514648
26	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024700164794922
27	SELECT slug FROM default_country WHERE country_id='67'	0.00020790100097656
28	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00027298927307129
29	SELECT slug FROM default_country WHERE country_id='67'	0.00022602081298828
30	SELECT slug FROM default_country WHERE country_id='1'	0.00019502639770508
31	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00024700164794922
32	SELECT slug FROM default_country WHERE country_id='1'	0.00018906593322754
33	SELECT slug FROM default_country WHERE country_id='3'	0.00025796890258789
34	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00020718574523926
35	SELECT slug FROM default_country WHERE country_id='3'	0.00025701522827148
36	SELECT slug FROM default_country WHERE country_id='7'	0.00022220611572266
37	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.0002751350402832
38	SELECT slug FROM default_country WHERE country_id='7'	0.00021982192993164
39	SELECT slug FROM default_country WHERE country_id='64'	0.00028800964355469
40	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00023293495178223
41	SELECT slug FROM default_country WHERE country_id='64'	0.00028586387634277
42	SELECT slug FROM default_country WHERE country_id='65'	0.00024890899658203
43	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00020098686218262
44	SELECT slug FROM default_country WHERE country_id='65'	0.00024890899658203
45	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='30' or list_cat_id like '%\|30\|%')	0.00041699409484863
46	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='20' or list_cat_id like '%\|20\|%')	0.00038719177246094
47	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='19' or list_cat_id like '%\|19\|%')	0.00040197372436523
48	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='18' or list_cat_id like '%\|18\|%')	0.00043082237243652
49	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='17' or list_cat_id like '%\|17\|%')	0.00042390823364258
50	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='16' or list_cat_id like '%\|16\|%')	0.00051403045654297
51	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='21' or list_cat_id like '%\|21\|%')	0.00036501884460449
52	SELECT title FROM default_region WHERE region_id=''	0.025139093399048
53	SELECT slug FROM default_blog WHERE blog_id='40'	0.00026917457580566
54	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/b40-lan-ha-bay-cat-ba-island.html'	0.0028109550476074
55	SELECT distinct image FROM default_blog where blog_id=40 LIMIT 0,1	0.00024700164794922
56	SELECT slug FROM default_blog WHERE blog_id='43'	0.0002741813659668
57	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/b43-the-five-hs-to-have-in-your-vietnam-itinerary.html'	0.0025289058685303
58	SELECT distinct image FROM default_blog where blog_id=43 LIMIT 0,1	0.00024914741516113
59	SELECT slug FROM default_blog WHERE blog_id='47'	0.00019383430480957
60	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/b47-vietnam-renews-visa-waiver-program-for-europeans.html'	0.0026001930236816
61	SELECT distinct image FROM default_blog where blog_id=47 LIMIT 0,1	0.00024509429931641
62	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.0026719570159912
63	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.0027439594268799
64	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.062607049942017
65	SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='57'	0.00033187866210938
66	SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='58'	0.00031614303588867
67	SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='59'	0.0003058910369873
68	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.023560047149658
69	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.0040011405944824
70	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.001399040222168
71	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0003199577331543
72	SELECT * FROM default_featurepackage WHERE mod_page='subscription' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0012869834899902
73	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022196769714355
74	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.0010509490966797
75	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025796890258789
76	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.00098204612731934
77	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026297569274902
78	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.00093913078308105
79	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002448558807373
80	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00024890899658203
81	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.00095295906066895
82	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024509429931641

Our Blog

Lan Ha Bay & Cat Ba Island

The Five H’s To Have In Your Vietnam Itinerary

Vietnam Renews Visa Waiver Program For Europeans

Sign up for notifications & offers

About us

Travel Styles

Other