Blog listing by tag Lan Ha Bay Travel Tips

Comprehensive Travel Guide For Your Lan Ha Bay Visit

14 March, 2024 Sunny Nguyen Duong

Located in the south of Ha Long Bay and east of Cat Ba Island, Lan Ha Bay is becoming a popular tourist destination and the attraction of Lan Ha Bay is its wild beauty and unmatched quiet space... Read more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog'	0.00084900856018066
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00028300285339355
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.0018768310546875
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.0022690296173096
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.0018420219421387
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.0018260478973389
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.0017609596252441
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.001633882522583
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00019383430480957
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.00077605247497559
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019598007202148
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.00076699256896973
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00016903877258301
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='lan-ha-bay-travel-tips' limit 0,1	0.0016810894012451
15	SELECT * FROM default_tag WHERE tag_id='299'	0.00017213821411133
16	SELECT title FROM default_tag WHERE tag_id='299'	0.00013589859008789
17	SELECT * FROM default_tag WHERE tag_id='299'	0.00021195411682129
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 '%\|299\|%')	0.0038080215454102
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 '%\|299\|%') order by order_no ASC LIMIT 0,6	0.0022218227386475
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.0012221336364746
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001838207244873
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.00077080726623535
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00016999244689941
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.001655101776123
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/lan-ha-bay-travel-tips' or config_link='/blog/tag/lan-ha-bay-travel-tips') limit 1	0.0025811195373535
26	SELECT slug FROM default_country WHERE country_id='1'	0.00024008750915527
27	SELECT slug FROM default_country WHERE country_id='64'	0.00012016296386719
28	SELECT slug FROM default_country WHERE country_id='3'	0.00019502639770508
29	SELECT slug FROM default_country WHERE country_id='7'	0.00016689300537109
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.00078606605529785
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017094612121582
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.0016868114471436
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.0016560554504395
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.001655101776123
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.0016109943389893
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.0017387866973877
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00013518333435059
38	SELECT slug FROM default_country WHERE country_id='1'	0.00011801719665527
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00019097328186035
40	SELECT slug FROM default_country WHERE country_id='1'	0.00016403198242188
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.0001370906829834
42	SELECT slug FROM default_country WHERE country_id='1'	0.00021505355834961
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00018596649169922
44	SELECT slug FROM default_country WHERE country_id='1'	0.00015902519226074
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00012898445129395
46	SELECT slug FROM default_country WHERE country_id='1'	0.00020098686218262
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00016999244689941
48	SELECT slug FROM default_country WHERE country_id='1'	0.00014209747314453
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00011610984802246
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.0017409324645996
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00012421607971191
52	SELECT slug FROM default_country WHERE country_id='64'	0.00019693374633789
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00016689300537109
54	SELECT slug FROM default_country WHERE country_id='64'	0.0001378059387207
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00010776519775391
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.0016829967498779
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00016498565673828
58	SELECT slug FROM default_country WHERE country_id='3'	0.00013899803161621
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00010991096496582
60	SELECT slug FROM default_country WHERE country_id='3'	0.00020408630371094
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00018215179443359
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.0016510486602783
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.0001370906829834
64	SELECT slug FROM default_country WHERE country_id='7'	0.00011396408081055
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00018692016601562
66	SELECT slug FROM default_country WHERE country_id='7'	0.00016093254089355
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00013518333435059
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00012397766113281
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00019001960754395
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00015902519226074
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00012302398681641
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00019097328186035
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.0001528263092041
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00022482872009277
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00019001960754395
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00015902519226074
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00012302398681641
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00019502639770508
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00016379356384277
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00013208389282227
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00019502639770508
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00016188621520996
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00012493133544922
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00019192695617676
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00015401840209961
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.00073695182800293
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017118453979492
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.0017311573028564
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00020694732666016
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.0016729831695557
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.0017170906066895
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00020098686218262
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.0017380714416504
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.0017750263214111
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00015497207641602
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.0016849040985107
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.0017530918121338
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00014495849609375
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.0016920566558838
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.0017211437225342
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00019979476928711
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.0016741752624512
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.0016038417816162
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00017189979553223
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.0016500949859619
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.0016529560089111
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.00080204010009766
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019407272338867
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.0016930103302002
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00017094612121582
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.0016059875488281
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.0016911029815674
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00016188621520996
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.0016078948974609
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.0017008781433105
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.00078105926513672
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017309188842773
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.0015909671783447
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.00076889991760254
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00016999244689941
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.0015971660614014
122	SELECT title FROM default_tag WHERE tag_id='299'	0.00015497207641602
123	SELECT title FROM default_blog WHERE blog_id='359'	0.00021100044250488
124	SELECT slug FROM default_blog WHERE blog_id='359'	0.00018477439880371
125	SELECT author FROM default_blog WHERE blog_id='359'	0.00018215179443359
126	SELECT author FROM default_blog WHERE blog_id='359'	0.00014710426330566
127	SELECT image FROM default_blog WHERE blog_id='359'	0.00011491775512695
128	SELECT image FROM default_blog WHERE blog_id='359'	0.00018596649169922
129	SELECT intro FROM default_blog WHERE blog_id='359'	0.00016117095947266
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.0017249584197998
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.0020668506622314
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.0020840167999268
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.001917839050293
134	SELECT slug FROM default_country WHERE country_id='1'	0.00022792816162109
135	SELECT slug FROM default_country WHERE country_id='64'	0.00020813941955566
136	SELECT slug FROM default_country WHERE country_id='3'	0.00018501281738281
137	SELECT slug FROM default_country WHERE country_id='7'	0.00015997886657715
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.00075197219848633
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023007392883301
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.001788854598999
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00014495849609375
142	SELECT title FROM _country WHERE country_id='193'	0.0001380443572998
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.0001370906829834
144	SELECT title FROM _country WHERE country_id='103'	0.00020480155944824
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.0002138614654541
146	SELECT title FROM _country WHERE country_id='229'	0.00018501281738281
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00017905235290527
148	SELECT title FROM _country WHERE country_id='14'	0.00014805793762207
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00014090538024902
150	SELECT title FROM _country WHERE country_id='175'	0.00021100044250488
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00020408630371094
152	SELECT title FROM _country WHERE country_id='228'	0.00017213821411133
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00016593933105469
154	SELECT title FROM _country WHERE country_id='42'	0.00013399124145508
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00012683868408203
156	SELECT title FROM _country WHERE country_id='134'	0.00019502639770508
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00018692016601562
158	SELECT title FROM _country WHERE country_id='77'	0.00015497207641602
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.00078892707824707
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018310546875
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.00080394744873047
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018215179443359
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.00074100494384766
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018692016601562
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.00077295303344727
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018215179443359
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.00074887275695801
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018191337585449
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.00076603889465332
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018787384033203

Blog listing by tag Lan Ha Bay Travel Tips

Comprehensive Travel Guide For Your Lan Ha Bay Visit

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