Blog listing by tag Hoi An 4-Star Hotels

Top 10 Best 4-star Hotels In Hoi An

09 March, 2024 Sunny Nguyen Duong

Hoi An, one of Vietnam's top tourist destinations, is famous for its ancient architecture, poetic scenery and peaceful atmosphere... Read more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog'	0.00093507766723633
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00032496452331543
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.0032289028167725
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.0026779174804688
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.0025770664215088
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.0030491352081299
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.0021119117736816
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.001845121383667
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00021505355834961
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.00085806846618652
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020408630371094
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.00085306167602539
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020718574523926
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='hoi-an-4star-hotels' limit 0,1	0.0019598007202148
15	SELECT * FROM default_tag WHERE tag_id='512'	0.00020098686218262
16	SELECT title FROM default_tag WHERE tag_id='512'	0.00020790100097656
17	SELECT * FROM default_tag WHERE tag_id='512'	0.00022792816162109
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 '%\|512\|%')	0.0045599937438965
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 '%\|512\|%') order by order_no ASC LIMIT 0,6	0.0024278163909912
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.00088405609130859
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021576881408691
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.00087809562683105
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.0019669532775879
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/hoi-an-4star-hotels' or config_link='/blog/tag/hoi-an-4star-hotels') limit 1	0.0029208660125732
26	SELECT slug FROM default_country WHERE country_id='1'	0.00025391578674316
27	SELECT slug FROM default_country WHERE country_id='64'	0.00016999244689941
28	SELECT slug FROM default_country WHERE country_id='3'	0.00018596649169922
29	SELECT slug FROM default_country WHERE country_id='7'	0.0001988410949707
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.00090789794921875
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021100044250488
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.0019190311431885
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.0020170211791992
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.0019562244415283
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.0019199848175049
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.0019850730895996
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00026297569274902
38	SELECT slug FROM default_country WHERE country_id='1'	0.00017499923706055
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00018692016601562
40	SELECT slug FROM default_country WHERE country_id='1'	0.00020003318786621
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00020885467529297
42	SELECT slug FROM default_country WHERE country_id='1'	0.00021600723266602
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00023007392883301
44	SELECT slug FROM default_country WHERE country_id='1'	0.00025701522827148
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00016880035400391
46	SELECT slug FROM default_country WHERE country_id='1'	0.00018119812011719
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00019216537475586
48	SELECT slug FROM default_country WHERE country_id='1'	0.00020408630371094
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00021791458129883
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.0019800662994385
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00021100044250488
52	SELECT slug FROM default_country WHERE country_id='64'	0.0002281665802002
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.000244140625
54	SELECT slug FROM default_country WHERE country_id='64'	0.00017499923706055
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00020718574523926
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.0019571781158447
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.0001828670501709
58	SELECT slug FROM default_country WHERE country_id='3'	0.00017690658569336
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.0001828670501709
60	SELECT slug FROM default_country WHERE country_id='3'	0.00019717216491699
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.0002140998840332
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.0019791126251221
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00021505355834961
64	SELECT slug FROM default_country WHERE country_id='7'	0.00023198127746582
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.0002448558807373
66	SELECT slug FROM default_country WHERE country_id='7'	0.00016498565673828
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00017690658569336
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00020480155944824
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00021219253540039
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00022602081298828
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00023102760314941
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.0002439022064209
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00014996528625488
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00018095970153809
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00018405914306641
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00020003318786621
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00020599365234375
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00022292137145996
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00023818016052246
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00015902519226074
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00017094612121582
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00018811225891113
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.0001990795135498
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00021505355834961
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00023388862609863
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.00085091590881348
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021100044250488
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.0019128322601318
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00022292137145996
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.0019550323486328
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.0018610954284668
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00017499923706055
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.0019152164459229
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.0019388198852539
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00015401840209961
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.0019230842590332
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.0020561218261719
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00017809867858887
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.0019640922546387
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.0018789768218994
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00019693374633789
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.0019519329071045
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.0018630027770996
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00018000602722168
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.0019290447235107
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.0019450187683105
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.00086307525634766
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00028204917907715
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.0019080638885498
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00022196769714355
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.0019772052764893
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.0018770694732666
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00019502639770508
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.0019299983978271
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.0019350051879883
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.00082087516784668
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021004676818848
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.0019028186798096
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.00090503692626953
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021195411682129
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.0018999576568604
122	SELECT title FROM default_tag WHERE tag_id='512'	0.00018000602722168
123	SELECT title FROM default_blog WHERE blog_id='286'	0.00021719932556152
124	SELECT slug FROM default_blog WHERE blog_id='286'	0.00023412704467773
125	SELECT author FROM default_blog WHERE blog_id='286'	0.00017118453979492
126	SELECT author FROM default_blog WHERE blog_id='286'	0.00017499923706055
127	SELECT image FROM default_blog WHERE blog_id='286'	0.00020003318786621
128	SELECT image FROM default_blog WHERE blog_id='286'	0.00022006034851074
129	SELECT intro FROM default_blog WHERE blog_id='286'	0.00023698806762695
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.0031321048736572
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.003648042678833
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.0026500225067139
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.0020899772644043
134	SELECT slug FROM default_country WHERE country_id='1'	0.00021600723266602
135	SELECT slug FROM default_country WHERE country_id='64'	0.00024700164794922
136	SELECT slug FROM default_country WHERE country_id='3'	0.00017309188842773
137	SELECT slug FROM default_country WHERE country_id='7'	0.00019693374633789
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.00096487998962402
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020289421081543
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.0020201206207275
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00023007392883301
142	SELECT title FROM _country WHERE country_id='193'	0.00023388862609863
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00017309188842773
144	SELECT title FROM _country WHERE country_id='103'	0.00018596649169922
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00023007392883301
146	SELECT title FROM _country WHERE country_id='229'	0.00024199485778809
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00018095970153809
148	SELECT title FROM _country WHERE country_id='14'	0.00020599365234375
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00023889541625977
150	SELECT title FROM _country WHERE country_id='175'	0.00025486946105957
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00019192695617676
152	SELECT title FROM _country WHERE country_id='228'	0.00020384788513184
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.0002439022064209
154	SELECT title FROM _country WHERE country_id='42'	0.00015807151794434
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00020790100097656
156	SELECT title FROM _country WHERE country_id='134'	0.0002138614654541
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00016188621520996
158	SELECT title FROM _country WHERE country_id='77'	0.0001678466796875
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.00088405609130859
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021696090698242
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.00084114074707031
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021600723266602
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.00088000297546387
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020909309387207
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.00087213516235352
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020599365234375
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.00083279609680176
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020790100097656
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.00085210800170898
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021600723266602

Blog listing by tag Hoi An 4-Star Hotels

Top 10 Best 4-star Hotels In Hoi An

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