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.0011649131774902
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00038003921508789
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.0021600723266602
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.0026168823242188
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.0020620822906494
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.0021660327911377
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.0021109580993652
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.0019829273223877
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00023603439331055
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.00093317031860352
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022792816162109
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.00084900856018066
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018692016601562
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='lan-ha-bay-travel-tips' limit 0,1	0.0019431114196777
15	SELECT * FROM default_tag WHERE tag_id='299'	0.00020885467529297
16	SELECT title FROM default_tag WHERE tag_id='299'	0.00021076202392578
17	SELECT * FROM default_tag WHERE tag_id='299'	0.00023317337036133
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.0042819976806641
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.0024528503417969
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.00089192390441895
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022101402282715
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.00092697143554688
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002129077911377
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.0018520355224609
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.0028259754180908
26	SELECT slug FROM default_country WHERE country_id='1'	0.00027704238891602
27	SELECT slug FROM default_country WHERE country_id='64'	0.00022411346435547
28	SELECT slug FROM default_country WHERE country_id='3'	0.00024914741516113
29	SELECT slug FROM default_country WHERE country_id='7'	0.00019693374633789
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.001035213470459
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024700164794922
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.0022621154785156
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.0020020008087158
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.0019497871398926
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.0020871162414551
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.0020589828491211
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00022101402282715
38	SELECT slug FROM default_country WHERE country_id='1'	0.00026297569274902
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00020003318786621
40	SELECT slug FROM default_country WHERE country_id='1'	0.00024294853210449
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00017881393432617
42	SELECT slug FROM default_country WHERE country_id='1'	0.00022006034851074
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00025415420532227
44	SELECT slug FROM default_country WHERE country_id='1'	0.00018882751464844
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.0002281665802002
46	SELECT slug FROM default_country WHERE country_id='1'	0.00026702880859375
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00021982192993164
48	SELECT slug FROM default_country WHERE country_id='1'	0.00024819374084473
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00019001960754395
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.0020308494567871
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00019001960754395
52	SELECT slug FROM default_country WHERE country_id='64'	0.00023913383483887
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00017595291137695
54	SELECT slug FROM default_country WHERE country_id='64'	0.00021886825561523
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00025820732116699
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.0019600391387939
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00020503997802734
58	SELECT slug FROM default_country WHERE country_id='3'	0.00025296211242676
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00019097328186035
60	SELECT slug FROM default_country WHERE country_id='3'	0.0002281665802002
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00026297569274902
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.001957893371582
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00021100044250488
64	SELECT slug FROM default_country WHERE country_id='7'	0.00025701522827148
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00020098686218262
66	SELECT slug FROM default_country WHERE country_id='7'	0.00024008750915527
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00018310546875
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00023317337036133
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00016880035400391
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00020813941955566
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00024509429931641
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.0001828670501709
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00021815299987793
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.0002741813659668
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00016689300537109
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00016522407531738
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.0001981258392334
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00024008750915527
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00014686584472656
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00019001960754395
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00022602081298828
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00026702880859375
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00019502639770508
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00023603439331055
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00026607513427734
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.00095486640930176
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023388862609863
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.0020198822021484
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00026321411132812
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.0019409656524658
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.001816987991333
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00025606155395508
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.0019180774688721
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.0019547939300537
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00020003318786621
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.0019679069519043
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.0018908977508545
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.0002129077911377
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.0019299983978271
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.0019609928131104
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00021219253540039
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.0019540786743164
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.001884937286377
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00023412704467773
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.0019700527191162
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.0018959045410156
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.0010809898376465
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020599365234375
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.0019760131835938
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00023007392883301
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.0020039081573486
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.0019512176513672
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00019192695617676
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.002561092376709
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.0018730163574219
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.0010249614715576
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025010108947754
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.0019400119781494
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.00094223022460938
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00027704238891602
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.0019598007202148
122	SELECT title FROM default_tag WHERE tag_id='299'	0.00029802322387695
123	SELECT title FROM default_blog WHERE blog_id='359'	0.00027203559875488
124	SELECT slug FROM default_blog WHERE blog_id='359'	0.0002140998840332
125	SELECT author FROM default_blog WHERE blog_id='359'	0.00018191337585449
126	SELECT author FROM default_blog WHERE blog_id='359'	0.00022387504577637
127	SELECT image FROM default_blog WHERE blog_id='359'	0.00027298927307129
128	SELECT image FROM default_blog WHERE blog_id='359'	0.00020694732666016
129	SELECT intro FROM default_blog WHERE blog_id='359'	0.00022983551025391
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.0019760131835938
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.0022759437561035
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.0024712085723877
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.002169132232666
134	SELECT slug FROM default_country WHERE country_id='1'	0.00037097930908203
135	SELECT slug FROM default_country WHERE country_id='64'	0.00015807151794434
136	SELECT slug FROM default_country WHERE country_id='3'	0.00013899803161621
137	SELECT slug FROM default_country WHERE country_id='7'	0.00011992454528809
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.001025915145874
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002140998840332
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.0018420219421387
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00017619132995605
142	SELECT title FROM _country WHERE country_id='193'	0.00017595291137695
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00018000602722168
144	SELECT title FROM _country WHERE country_id='103'	0.00015592575073242
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00015687942504883
146	SELECT title FROM _country WHERE country_id='229'	0.00013184547424316
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00013279914855957
148	SELECT title FROM _country WHERE country_id='14'	0.00020694732666016
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00020694732666016
150	SELECT title FROM _country WHERE country_id='175'	0.00018000602722168
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00018000602722168
152	SELECT title FROM _country WHERE country_id='228'	0.00015521049499512
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00015497207641602
154	SELECT title FROM _country WHERE country_id='42'	0.00018095970153809
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.0002131462097168
156	SELECT title FROM _country WHERE country_id='134'	0.00025701522827148
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00022983551025391
158	SELECT title FROM _country WHERE country_id='77'	0.00027799606323242
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.00081086158752441
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018811225891113
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.00087308883666992
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018501281738281
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.00084400177001953
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922
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.0008089542388916
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018310546875
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.00080013275146484
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922
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.00090384483337402
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018191337585449

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