Blog listing by tag Lan Ha Bay Review

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.0009300708770752
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00024819374084473
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.0022799968719482
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.0026540756225586
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.0020558834075928
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.0021259784698486
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.0020568370819092
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00024080276489258
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.0009300708770752
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024509429931641
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.00091218948364258
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002129077911377
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='lan-ha-bay-review' limit 0,1	0.0021049976348877
15	SELECT * FROM default_tag WHERE tag_id='301'	0.00023984909057617
16	SELECT title FROM default_tag WHERE tag_id='301'	0.00024509429931641
17	SELECT * FROM default_tag WHERE tag_id='301'	0.00017189979553223
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 '%\|301\|%')	0.0042788982391357
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 '%\|301\|%') order by order_no ASC LIMIT 0,6	0.0025029182434082
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.00094103813171387
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022315979003906
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.00085592269897461
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021100044250488
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.0021078586578369
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-review' or config_link='/blog/tag/lan-ha-bay-review') limit 1	0.0031259059906006
26	SELECT slug FROM default_country WHERE country_id='1'	0.00021886825561523
27	SELECT slug FROM default_country WHERE country_id='64'	0.0002439022064209
28	SELECT slug FROM default_country WHERE country_id='3'	0.00016999244689941
29	SELECT slug FROM default_country WHERE country_id='7'	0.0001978874206543
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.00095701217651367
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021910667419434
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.0020978450775146
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.0020949840545654
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.0020129680633545
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.0020358562469482
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.0019588470458984
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00020003318786621
38	SELECT slug FROM default_country WHERE country_id='1'	0.00023007392883301
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00014996528625488
40	SELECT slug FROM default_country WHERE country_id='1'	0.00016903877258301
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00018191337585449
42	SELECT slug FROM default_country WHERE country_id='1'	0.00020098686218262
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00021696090698242
44	SELECT slug FROM default_country WHERE country_id='1'	0.00023293495178223
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00014996528625488
46	SELECT slug FROM default_country WHERE country_id='1'	0.0001678466796875
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00018692016601562
48	SELECT slug FROM default_country WHERE country_id='1'	0.00020003318786621
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00022506713867188
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.0034739971160889
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.0001988410949707
52	SELECT slug FROM default_country WHERE country_id='64'	0.0002288818359375
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00024700164794922
54	SELECT slug FROM default_country WHERE country_id='64'	0.00017595291137695
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00021100044250488
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.0020310878753662
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00015711784362793
58	SELECT slug FROM default_country WHERE country_id='3'	0.00017213821411133
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00017905235290527
60	SELECT slug FROM default_country WHERE country_id='3'	0.00019598007202148
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00020909309387207
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.0023000240325928
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00020313262939453
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.00014305114746094
66	SELECT slug FROM default_country WHERE country_id='7'	0.00058102607727051
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00016903877258301
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00020599365234375
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00018906593322754
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00017595291137695
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.00015401840209961
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00013208389282227
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00021600723266602
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00019502639770508
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00018501281738281
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00016689300537109
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00015902519226074
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00014591217041016
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00016212463378906
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00014400482177734
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00012898445129395
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00025701522827148
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00014400482177734
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00012302398681641
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.0010061264038086
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019717216491699
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.0020790100097656
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00016403198242188
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.0018301010131836
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.0019290447235107
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.0002131462097168
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.0018649101257324
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.0018320083618164
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00021505355834961
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.0018930435180664
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.001863956451416
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00014615058898926
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.0019631385803223
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.0018990039825439
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00018501281738281
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.0027279853820801
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.0019550323486328
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.0001370906829834
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.0028691291809082
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.0018298625946045
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.00079798698425293
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018906593322754
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.0019941329956055
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00017595291137695
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.0018858909606934
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.0019130706787109
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00020098686218262
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.0018560886383057
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.0018620491027832
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.00081110000610352
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001828670501709
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.0020148754119873
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.00085806846618652
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017905235290527
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.0017910003662109
122	SELECT title FROM default_tag WHERE tag_id='301'	0.00014305114746094
123	SELECT title FROM default_blog WHERE blog_id='359'	0.00015783309936523
124	SELECT slug FROM default_blog WHERE blog_id='359'	0.0001368522644043
125	SELECT author FROM default_blog WHERE blog_id='359'	0.00014114379882812
126	SELECT author FROM default_blog WHERE blog_id='359'	0.00026297569274902
127	SELECT image FROM default_blog WHERE blog_id='359'	0.00014591217041016
128	SELECT image FROM default_blog WHERE blog_id='359'	0.00012898445129395
129	SELECT intro FROM default_blog WHERE blog_id='359'	0.00021505355834961
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.0019140243530273
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.0022399425506592
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.0024840831756592
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.0021219253540039
134	SELECT slug FROM default_country WHERE country_id='1'	0.00020909309387207
135	SELECT slug FROM default_country WHERE country_id='64'	0.00020194053649902
136	SELECT slug FROM default_country WHERE country_id='3'	0.00018906593322754
137	SELECT slug FROM default_country WHERE country_id='7'	0.00017285346984863
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.0010089874267578
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922
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.0020580291748047
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00022292137145996
142	SELECT title FROM _country WHERE country_id='193'	0.00083518028259277
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00015807151794434
144	SELECT title FROM _country WHERE country_id='103'	0.00014209747314453
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.0001521110534668
146	SELECT title FROM _country WHERE country_id='229'	0.00013303756713867
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00013995170593262
148	SELECT title FROM _country WHERE country_id='14'	0.00022292137145996
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00013017654418945
150	SELECT title FROM _country WHERE country_id='175'	0.00021004676818848
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00021696090698242
152	SELECT title FROM _country WHERE country_id='228'	0.00019693374633789
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00020408630371094
154	SELECT title FROM _country WHERE country_id='42'	0.00018501281738281
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00019311904907227
156	SELECT title FROM _country WHERE country_id='134'	0.00017499923706055
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.0001828670501709
158	SELECT title FROM _country WHERE country_id='77'	0.00017595291137695
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.00095891952514648
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019001960754395
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.00081205368041992
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017905235290527
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.00077390670776367
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017786026000977
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.00083494186401367
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017905235290527
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.00081396102905273
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019478797912598
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.00087499618530273
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017905235290527

Blog listing by tag Lan Ha Bay Review

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