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.00099897384643555
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00027990341186523
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.0020768642425537
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.0024487972259521
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.0018711090087891
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.0020320415496826
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.0018570423126221
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.0018949508666992
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00020718574523926
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.00091886520385742
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020098686218262
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.00086784362792969
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019407272338867
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='how-get-hanoi-to-lan-ha-bay' limit 0,1	0.0019040107727051
15	SELECT * FROM default_tag WHERE tag_id='305'	0.00020885467529297
16	SELECT title FROM default_tag WHERE tag_id='305'	0.00018477439880371
17	SELECT * FROM default_tag WHERE tag_id='305'	0.00018310546875
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.0043611526489258
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.0026471614837646
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.00097513198852539
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024819374084473
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.000946044921875
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022101402282715
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.0019679069519043
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.0028181076049805
26	SELECT slug FROM default_country WHERE country_id='1'	0.00018787384033203
27	SELECT slug FROM default_country WHERE country_id='64'	0.00025296211242676
28	SELECT slug FROM default_country WHERE country_id='3'	0.00018191337585449
29	SELECT slug FROM default_country WHERE country_id='7'	0.00022101402282715
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.00098085403442383
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018811225891113
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.0019679069519043
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.0018420219421387
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.0018308162689209
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.0018148422241211
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.0018548965454102
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.0001990795135498
38	SELECT slug FROM default_country WHERE country_id='1'	0.00022387504577637
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.0002589225769043
40	SELECT slug FROM default_country WHERE country_id='1'	0.00015902519226074
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00015902519226074
42	SELECT slug FROM default_country WHERE country_id='1'	0.00020003318786621
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00021886825561523
44	SELECT slug FROM default_country WHERE country_id='1'	0.00021886825561523
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00023698806762695
46	SELECT slug FROM default_country WHERE country_id='1'	0.00025701522827148
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00016093254089355
48	SELECT slug FROM default_country WHERE country_id='1'	0.00017213821411133
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00017118453979492
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.0019180774688721
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00023818016052246
52	SELECT slug FROM default_country WHERE country_id='64'	0.00015497207641602
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00014805793762207
54	SELECT slug FROM default_country WHERE country_id='64'	0.00014019012451172
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00013899803161621
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.001816987991333
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00021696090698242
58	SELECT slug FROM default_country WHERE country_id='3'	0.00020790100097656
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00019288063049316
60	SELECT slug FROM default_country WHERE country_id='3'	0.00018119812011719
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00018000602722168
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.0018811225891113
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00022411346435547
64	SELECT slug FROM default_country WHERE country_id='7'	0.00024509429931641
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00013113021850586
66	SELECT slug FROM default_country WHERE country_id='7'	0.00024890899658203
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00017809867858887
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.0002140998840332
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.0014538764953613
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00018000602722168
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00016903877258301
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00014996528625488
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00012397766113281
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00020313262939453
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00017714500427246
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00016593933105469
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00014305114746094
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00012302398681641
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00019598007202148
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00018095970153809
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00015807151794434
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00014901161193848
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00012302398681641
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00020098686218262
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00017404556274414
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.00091886520385742
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018405914306641
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.0019171237945557
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.0001990795135498
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.0018069744110107
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.0017979145050049
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00017786026000977
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.0017750263214111
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.0017402172088623
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00021886825561523
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.001823902130127
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.0018160343170166
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00019693374633789
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.001816987991333
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.001788854598999
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00021600723266602
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.0018281936645508
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.0018229484558105
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00020289421081543
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.0017919540405273
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.001777172088623
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.00085806846618652
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018000602722168
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.0017640590667725
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00014185905456543
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.0017108917236328
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.0018298625946045
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00021100044250488
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.0018351078033447
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.001816987991333
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.00088906288146973
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017714500427246
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.0017650127410889
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.00083518028259277
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017714500427246
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.001723051071167
122	SELECT title FROM default_tag WHERE tag_id='305'	0.00020313262939453
123	SELECT title FROM default_blog WHERE blog_id='362'	0.00025200843811035
124	SELECT slug FROM default_blog WHERE blog_id='362'	0.00015807151794434
125	SELECT author FROM default_blog WHERE blog_id='362'	0.0001680850982666
126	SELECT author FROM default_blog WHERE blog_id='362'	0.00016403198242188
127	SELECT image FROM default_blog WHERE blog_id='362'	0.00018787384033203
128	SELECT image FROM default_blog WHERE blog_id='362'	0.0001988410949707
129	SELECT intro FROM default_blog WHERE blog_id='362'	0.00022482872009277
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.0017750263214111
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.0019950866699219
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.0021412372589111
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.0018110275268555
134	SELECT slug FROM default_country WHERE country_id='1'	0.00015497207641602
135	SELECT slug FROM default_country WHERE country_id='64'	0.00015687942504883
136	SELECT slug FROM default_country WHERE country_id='3'	0.00013899803161621
137	SELECT slug FROM default_country WHERE country_id='7'	0.00012803077697754
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.00085020065307617
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019001960754395
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.0018589496612549
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00015711784362793
142	SELECT title FROM _country WHERE country_id='193'	0.00015115737915039
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00016593933105469
144	SELECT title FROM _country WHERE country_id='103'	0.00014209747314453
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00014305114746094
146	SELECT title FROM _country WHERE country_id='229'	0.00011897087097168
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00012016296386719
148	SELECT title FROM _country WHERE country_id='14'	0.00020289421081543
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00020384788513184
150	SELECT title FROM _country WHERE country_id='175'	0.00017881393432617
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00017881393432617
152	SELECT title FROM _country WHERE country_id='228'	0.00015401840209961
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00015616416931152
154	SELECT title FROM _country WHERE country_id='42'	0.00013899803161621
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00013899803161621
156	SELECT title FROM _country WHERE country_id='134'	0.0002131462097168
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00013995170593262
158	SELECT title FROM _country WHERE country_id='77'	0.00021505355834961
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.00081706047058105
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017499923706055
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.00081801414489746
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017285346984863
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.00092887878417969
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017595291137695
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.00082802772521973
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017595291137695
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.00077605247497559
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001678466796875
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.00076913833618164
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017094612121582

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