Top Attractions

Vietnam Airlines Launches New Routes To Singapore, Cambodia

01 January, 2024

National flag carrier Vietnam Airlines has officially announced that it will launch two new routes to Singapore and Cambodia as from November 1. Read more

Dong Xuan Market

18 March, 2017

There are so many interesting things and stunning places in Hanoi that you can enjoy the chance to take a visit to, one of the must – see places in Hanoi that you should not miss out that is Dong Xuan Market. It is really an ideal place... Read more

Walk Around Lao Lake

18 March, 2017

Hoan Kiem Lake is one of the most exciting and interesting attractions in Hanoi . Tourists visiting Hanoi always take the chance to visit Hoan Kiem Lake as it is a really ideal place to explore and experience the daily life of Hanoi people.... Read more

The Perfume Pagoda

18 March, 2017

The Perfume Pagoda (Chùa Hương) is a vast complex of Buddhist temples and shrines built into the limestone Huong Tich Mountains. Read more

Hoan Kiem Lake & Ngoc Son Temple

18 March, 2017

There are many beautiful sights in Hanoi but the most attractive sight may be Hoan Kiem Lake. Many people say that “Hoan Kiem Lake is the heart of Hanoi , the capital of Vietnam”. Read more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='guide'	0.0010659694671631
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00029802322387695
3	SELECT country_id,title,slug,intro,image FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.0027189254760742
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.0062201023101807
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.0063459873199463
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.006397008895874
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.0041589736938477
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.010184049606323
9	SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORAGETYPE' order by order_no ASC limit 0,1	0.0057799816131592
10	SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORHEIGHTTYPE' order by order_no ASC limit 0,1	0.012831926345825
11	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.001107931137085
12	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.0045161247253418
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0023379325866699
14	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.0042030811309814
15	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00078701972961426
16	SELECT * FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1 and slug='top-attractions' limit 0,1	0.010074138641357
17	SELECT title FROM default_guidecat WHERE guidecat_id='2'	0.0045368671417236
18	SELECT intro FROM default_guidecat WHERE guidecat_id='2'	0.006493091583252
19	SELECT slug FROM default_country WHERE country_id='2'	0.0087230205535889
20	SELECT title,slug,intro,banner FROM default_guidecat WHERE guidecat_id='2'	0.0028560161590576
21	SELECT * FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='2' or list_cat_id like '%\|2\|%')	0.0041508674621582
22	SELECT * FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='2' or list_cat_id like '%\|2\|%')	0.021508932113647
23	SELECT slug FROM default_guidecat WHERE guidecat_id='2'	0.003593921661377
24	SELECT * FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='2' or list_cat_id like '%\|2\|%') order by order_no asc LIMIT 0,6	0.014186143875122
25	SELECT * FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1	0.01158618927002
26	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'a%' or slug like 'A%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.013804912567139
27	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'b%' or slug like 'B%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.01542592048645
28	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'c%' or slug like 'C%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.0062458515167236
29	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'd%' or slug like 'D%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.033767938613892
30	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'e%' or slug like 'E%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.032512187957764
31	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'f%' or slug like 'F%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.0077450275421143
32	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'g%' or slug like 'G%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.023122072219849
33	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'h%' or slug like 'H%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.011912107467651
34	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'i%' or slug like 'I%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.01016092300415
35	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'j%' or slug like 'J%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.020124912261963
36	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'k%' or slug like 'K%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.017607927322388
37	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'l%' or slug like 'L%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.014190912246704
38	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'm%' or slug like 'M%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.021133899688721
39	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'n%' or slug like 'N%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.021934032440186
40	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'o%' or slug like 'O%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.012655973434448
41	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'p%' or slug like 'P%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.010540962219238
42	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'q%' or slug like 'Q%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.00850510597229
43	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'r%' or slug like 'R%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.012748003005981
44	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 's%' or slug like 'S%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.0078589916229248
45	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 't%' or slug like 'T%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.011960983276367
46	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'u%' or slug like 'U%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.0090939998626709
47	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'v%' or slug like 'V%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.0076689720153809
48	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'w%' or slug like 'W%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.0071861743927002
49	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'x%' or slug like 'X%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.011990070343018
50	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'y%' or slug like 'Y%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.019382953643799
51	SELECT * FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='' and (slug like 'z%' or slug like 'Z%') and city_id IN (SELECT city_id FROM default_guide where (cat_id='2' or list_cat_id like '%\|2\|%'))	0.010028123855591
52	SELECT intro FROM default_guidecat WHERE guidecat_id='2'	0.0067720413208008
53	SELECT slug FROM default_country WHERE country_id='2'	0.0064389705657959
54	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/travel-guide//.html'	0.012264013290405
55	SELECT distinct image FROM default_guidecat where guidecat_id=2 LIMIT 0,1	0.0026428699493408
56	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.018973827362061
57	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/travel-guide/top-attractions.html' or config_link='/travel-guide/top-attractions.html') limit 1	0.011988162994385
58	SELECT * FROM default_featurepackage WHERE mod_page='setting' and act_page='cart' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.0072610378265381
59	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0059108734130859
60	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.010899066925049
61	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0020599365234375
62	SELECT slug FROM default_country WHERE country_id='67'	0.0013890266418457
63	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.0055561065673828
64	SELECT slug FROM default_country WHERE country_id='67'	0.0010988712310791
65	SELECT slug FROM default_country WHERE country_id='1'	0.0059900283813477
66	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.0026428699493408
67	SELECT slug FROM default_country WHERE country_id='1'	0.0045011043548584
68	SELECT slug FROM default_country WHERE country_id='3'	0.0014019012451172
69	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.0033109188079834
70	SELECT slug FROM default_country WHERE country_id='3'	0.00064897537231445
71	SELECT slug FROM default_country WHERE country_id='7'	0.0011911392211914
72	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.0013670921325684
73	SELECT slug FROM default_country WHERE country_id='7'	0.005134105682373
74	SELECT slug FROM default_country WHERE country_id='64'	0.0013079643249512
75	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.0028071403503418
76	SELECT slug FROM default_country WHERE country_id='64'	0.0010511875152588
77	SELECT slug FROM default_country WHERE country_id='65'	0.0056750774383545
78	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.0030438899993896
79	SELECT slug FROM default_country WHERE country_id='65'	0.0059370994567871
80	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='30' or list_cat_id like '%\|30\|%')	0.0060310363769531
81	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='20' or list_cat_id like '%\|20\|%')	0.0023629665374756
82	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='19' or list_cat_id like '%\|19\|%')	0.004194974899292
83	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='18' or list_cat_id like '%\|18\|%')	0.0062291622161865
84	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='17' or list_cat_id like '%\|17\|%')	0.0049610137939453
85	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='16' or list_cat_id like '%\|16\|%')	0.0042150020599365
86	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and (cat_id='21' or list_cat_id like '%\|21\|%')	0.0038211345672607
87	SELECT image FROM default_guide WHERE guide_id='426'	0.0024380683898926
88	SELECT image FROM default_guide WHERE guide_id='19'	0.0054981708526611
89	SELECT image FROM default_guide WHERE guide_id='28'	0.0037930011749268
90	SELECT image FROM default_guide WHERE guide_id='17'	0.0036201477050781
91	SELECT image FROM default_guide WHERE guide_id='18'	0.0036461353302002
92	SELECT title FROM default_country WHERE country_id=''	0.0033199787139893
93	SELECT banner FROM default_guidecat WHERE guidecat_id='2'	0.0046420097351074
94	SELECT image FROM default_guide WHERE guide_id='426'	0.0050370693206787
95	SELECT image FROM default_guide WHERE guide_id='19'	0.00060892105102539
96	SELECT image FROM default_guide WHERE guide_id='28'	0.005789041519165
97	SELECT image FROM default_guide WHERE guide_id='17'	0.0037269592285156
98	SELECT image FROM default_guide WHERE guide_id='18'	0.0057418346405029
99	SELECT guidecat_id, title,slug FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0053958892822266
100	SELECT guide_id,slug,title FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and num_view > 0 order by num_view desc limit 0,5	0.002979040145874
101	SELECT slug FROM default_guidecat WHERE guidecat_id='15'	0.00033688545227051
102	SELECT slug FROM default_guidecat WHERE guidecat_id='13'	0.0020818710327148
103	SELECT slug FROM default_guidecat WHERE guidecat_id='9'	0.0037238597869873
104	SELECT slug FROM default_guidecat WHERE guidecat_id='2'	0.0026590824127197
105	SELECT slug FROM default_guidecat WHERE guidecat_id='12'	0.00095486640930176
106	SELECT * FROM default_featurepackage WHERE mod_page='subscription' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0043950080871582
107	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0020589828491211
108	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.0035860538482666
109	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0043299198150635
110	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.007951021194458
111	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0034329891204834
112	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.0028378963470459
113	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0056021213531494
114	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.0037980079650879
115	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.0040271282196045
116	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0039939880371094

Top Attractions

Vietnam Airlines Launches New Routes To Singapore, Cambodia

Dong Xuan Market

Walk Around Lao Lake

The Perfume Pagoda

Hoan Kiem Lake & Ngoc Son Temple

Sign up for notifications & offers

About us

Travel Styles

Other