Blog listing by tag How Get Hanoi To Lan Ha Bay

Top 04 Best Ways To Travel From Hanoi To Lan Ha Bay

14 March, 2024 Sunny Nguyen Duong

Nestled amidst the emerald green waters of the Gulf of Tonkin, Lan Ha Bay is a mesmerising spectacle of nature's artistry with its towering limestone karsts rising majestically from the cerulean embrace... Read more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog'	0.0010049343109131
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00029897689819336
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.002223014831543
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.0026390552520752
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.0021331310272217
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.0022380352020264
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.0020809173583984
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.0019710063934326
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00022792816162109
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.00089383125305176
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021982192993164
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.00083684921264648
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020408630371094
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='how-get-hanoi-to-lan-ha-bay' limit 0,1	0.0020191669464111
15	SELECT * FROM default_tag WHERE tag_id='305'	0.00024700164794922
16	SELECT title FROM default_tag WHERE tag_id='305'	0.00014495849609375
17	SELECT * FROM default_tag WHERE tag_id='305'	0.00016212463378906
18	SELECT * FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (list_tag_id like '%\|305\|%')	0.0044450759887695
19	SELECT blog_id,cat_id,reg_date,publish_date FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (list_tag_id like '%\|305\|%') order by order_no ASC LIMIT 0,6	0.0025260448455811
20	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.00093698501586914
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002129077911377
22	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.00087404251098633
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020313262939453
24	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.0020239353179932
25	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/tag/how-get-hanoi-to-lan-ha-bay' or config_link='/blog/tag/how-get-hanoi-to-lan-ha-bay') limit 1	0.0028350353240967
26	SELECT slug FROM default_country WHERE country_id='1'	0.00024700164794922
27	SELECT slug FROM default_country WHERE country_id='64'	0.00015997886657715
28	SELECT slug FROM default_country WHERE country_id='3'	0.00016999244689941
29	SELECT slug FROM default_country WHERE country_id='7'	0.00018000602722168
30	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.00084495544433594
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020217895507812
32	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.0020101070404053
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='64' order by order_no ASC	0.0020010471343994
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='3' order by order_no ASC	0.0020167827606201
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='7' order by order_no ASC	0.0020730495452881
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='1' order by order_no ASC	0.0020020008087158
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00022506713867188
38	SELECT slug FROM default_country WHERE country_id='1'	0.00023889541625977
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00014901161193848
40	SELECT slug FROM default_country WHERE country_id='1'	0.00016093254089355
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00016903877258301
42	SELECT slug FROM default_country WHERE country_id='1'	0.00017786026000977
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00018501281738281
44	SELECT slug FROM default_country WHERE country_id='1'	0.00019502639770508
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00020503997802734
46	SELECT slug FROM default_country WHERE country_id='1'	0.0002129077911377
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00024199485778809
48	SELECT slug FROM default_country WHERE country_id='1'	0.0001530647277832
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00016593933105469
50	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.0019688606262207
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00019717216491699
52	SELECT slug FROM default_country WHERE country_id='64'	0.00021219253540039
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00022506713867188
54	SELECT slug FROM default_country WHERE country_id='64'	0.00023913383483887
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.0001521110534668
56	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.0020110607147217
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00023007392883301
58	SELECT slug FROM default_country WHERE country_id='3'	0.00014400482177734
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00014996528625488
60	SELECT slug FROM default_country WHERE country_id='3'	0.00017094612121582
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00018692016601562
62	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.0020318031311035
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.0001518726348877
64	SELECT slug FROM default_country WHERE country_id='7'	0.00016212463378906
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00016999244689941
66	SELECT slug FROM default_country WHERE country_id='7'	0.00018095970153809
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00018906593322754
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00021195411682129
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00021505355834961
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00022196769714355
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00022411346435547
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00023102760314941
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00023508071899414
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00018501281738281
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00019717216491699
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00020313262939453
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.0002291202545166
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00022602081298828
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00022602081298828
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00023388862609863
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00023484230041504
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00014305114746094
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00014495849609375
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.0001528263092041
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.0001530647277832
86	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.0008699893951416
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020098686218262
88	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.0020120143890381
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00021815299987793
90	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.0019979476928711
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.0019340515136719
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00024700164794922
93	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.0019071102142334
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.0019609928131104
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00016593933105469
96	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.0019900798797607
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.0019428730010986
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00015401840209961
99	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.0019509792327881
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.0019099712371826
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00021696090698242
102	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.0020089149475098
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.0019831657409668
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00019192695617676
105	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.0019819736480713
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.0020110607147217
107	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
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021696090698242
109	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.0019779205322266
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00018000602722168
111	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.0019500255584717
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.0019609928131104
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00016999244689941
114	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.0019879341125488
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.0019769668579102
116	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.00085902214050293
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020599365234375
118	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.0019791126251221
119	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.00085902214050293
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020599365234375
121	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.0019748210906982
122	SELECT title FROM default_tag WHERE tag_id='305'	0.00022292137145996
123	SELECT title FROM default_blog WHERE blog_id='362'	0.0001521110534668
124	SELECT slug FROM default_blog WHERE blog_id='362'	0.00015807151794434
125	SELECT author FROM default_blog WHERE blog_id='362'	0.00018501281738281
126	SELECT author FROM default_blog WHERE blog_id='362'	0.00018787384033203
127	SELECT image FROM default_blog WHERE blog_id='362'	0.00019192695617676
128	SELECT image FROM default_blog WHERE blog_id='362'	0.00020122528076172
129	SELECT intro FROM default_blog WHERE blog_id='362'	0.0002131462097168
130	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.0019450187683105
131	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.0022599697113037
132	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_blog WHERE is_trash=0 and is_online=1) order by order_no asc	0.0023820400238037
133	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.0022258758544922
134	SELECT slug FROM default_country WHERE country_id='1'	0.00018692016601562
135	SELECT slug FROM default_country WHERE country_id='64'	0.00019598007202148
136	SELECT slug FROM default_country WHERE country_id='3'	0.00020694732666016
137	SELECT slug FROM default_country WHERE country_id='7'	0.00021696090698242
138	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.0008080005645752
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020217895507812
140	SELECT testimonial_id,title,slug,image,reg_date,rates,name,intro FROM default_testimonial WHERE lang_id='' and is_trash=0 and is_online = 1 and image<>'' order by order_no ASC limit 0,9	0.0021278858184814
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00022101402282715
142	SELECT title FROM _country WHERE country_id='193'	0.00024104118347168
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00017499923706055
144	SELECT title FROM _country WHERE country_id='103'	0.00017809867858887
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00022292137145996
146	SELECT title FROM _country WHERE country_id='229'	0.0002589225769043
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00019407272338867
148	SELECT title FROM _country WHERE country_id='14'	0.00020003318786621
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00023293495178223
150	SELECT title FROM _country WHERE country_id='175'	0.00023698806762695
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00016903877258301
152	SELECT title FROM _country WHERE country_id='228'	0.00017595291137695
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00020480155944824
154	SELECT title FROM _country WHERE country_id='42'	0.00021004676818848
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00013995170593262
156	SELECT title FROM _country WHERE country_id='134'	0.00014686584472656
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00017809867858887
158	SELECT title FROM _country WHERE country_id='77'	0.00020694732666016
159	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.00082206726074219
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001990795135498
161	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.00080490112304688
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001990795135498
163	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.00084996223449707
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020098686218262
165	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.00082302093505859
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001978874206543
167	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.00083708763122559
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019717216491699
169	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.00081706047058105
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021505355834961

Blog listing by tag How Get Hanoi To Lan Ha Bay

Top 04 Best Ways To Travel From Hanoi To Lan Ha Bay

WHAT DO CUSTOMERS SAY ABOUT US?

Dream Trip In Vietnam

Fantastic Indochina

Vietnam Heritage Trail

Exotic Vietnam & Cambodia

Vietnam Holiday 15 Days

The Best Of Vietnam

Vietnam Family Vacation

Vietnam In Capture

The Essence Of Vietnam

Information

Travel Styles

Other

Follow Us

Payment Channel