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.0009610652923584
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00025486946105957
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.0021088123321533
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.0022759437561035
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.0018799304962158
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.0019848346710205
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.0018730163574219
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.0019299983978271
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.0019011497497559
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.0018620491027832
11	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00023579597473145
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.00091791152954102
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020289421081543
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.00080394744873047
15	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018501281738281
16	SELECT * FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1 and slug='top-attractions' limit 0,1	0.001878023147583
17	SELECT title FROM default_guidecat WHERE guidecat_id='2'	0.00018095970153809
18	SELECT intro FROM default_guidecat WHERE guidecat_id='2'	0.00016903877258301
19	SELECT slug FROM default_country WHERE country_id='2'	0.00016903877258301
20	SELECT title,slug,intro,banner FROM default_guidecat WHERE guidecat_id='2'	0.00019383430480957
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.0019958019256592
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.0019669532775879
23	SELECT slug FROM default_guidecat WHERE guidecat_id='2'	0.00018906593322754
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.0020630359649658
25	SELECT * FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1	0.0018489360809326
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.00211501121521
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.0021040439605713
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.0020880699157715
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.0020649433135986
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.0020339488983154
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.0020239353179932
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.002094030380249
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.0020949840545654
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.0020458698272705
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.0020248889923096
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.0020761489868164
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.0020778179168701
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.0020740032196045
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.0020718574523926
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.0020248889923096
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.0021171569824219
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.0020620822906494
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.0020430088043213
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.001986026763916
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.0020918846130371
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.0020430088043213
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.002039909362793
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.00199294090271
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.0021049976348877
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.0020349025726318
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.0020418167114258
52	SELECT intro FROM default_guidecat WHERE guidecat_id='2'	0.00014901161193848
53	SELECT slug FROM default_country WHERE country_id='2'	0.00015401840209961
54	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/travel-guide//.html'	0.001849889755249
55	SELECT distinct image FROM default_guidecat where guidecat_id=2 LIMIT 0,1	0.00019502639770508
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.0019140243530273
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.0018701553344727
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.0010430812835693
59	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022792816162109
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.00084996223449707
61	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018715858459473
62	SELECT slug FROM default_country WHERE country_id='67'	0.00018095970153809
63	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00018906593322754
64	SELECT slug FROM default_country WHERE country_id='67'	0.00017905235290527
65	SELECT slug FROM default_country WHERE country_id='1'	0.00019192695617676
66	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00018692016601562
67	SELECT slug FROM default_country WHERE country_id='1'	0.00017404556274414
68	SELECT slug FROM default_country WHERE country_id='3'	0.00018000602722168
69	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00017285346984863
70	SELECT slug FROM default_country WHERE country_id='3'	0.00016307830810547
71	SELECT slug FROM default_country WHERE country_id='7'	0.00017094612121582
72	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00016307830810547
73	SELECT slug FROM default_country WHERE country_id='7'	0.00015091896057129
74	SELECT slug FROM default_country WHERE country_id='64'	0.00015687942504883
75	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00015902519226074
76	SELECT slug FROM default_country WHERE country_id='64'	0.00014591217041016
77	SELECT slug FROM default_country WHERE country_id='65'	0.00015401840209961
78	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00014615058898926
79	SELECT slug FROM default_country WHERE country_id='65'	0.00013113021850586
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.00038790702819824
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.00032591819763184
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.00032997131347656
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.00034117698669434
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.0003349781036377
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.00038290023803711
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.0003361701965332
87	SELECT image FROM default_guide WHERE guide_id='426'	0.00015902519226074
88	SELECT image FROM default_guide WHERE guide_id='19'	0.00020599365234375
89	SELECT image FROM default_guide WHERE guide_id='28'	0.00023198127746582
90	SELECT image FROM default_guide WHERE guide_id='17'	0.00015616416931152
91	SELECT image FROM default_guide WHERE guide_id='18'	0.00017595291137695
92	SELECT title FROM default_country WHERE country_id=''	0.00018310546875
93	SELECT banner FROM default_guidecat WHERE guidecat_id='2'	0.00018692016601562
94	SELECT image FROM default_guide WHERE guide_id='426'	0.00014805793762207
95	SELECT image FROM default_guide WHERE guide_id='19'	0.00022292137145996
96	SELECT image FROM default_guide WHERE guide_id='28'	0.00015401840209961
97	SELECT image FROM default_guide WHERE guide_id='17'	0.00023078918457031
98	SELECT image FROM default_guide WHERE guide_id='18'	0.00020194053649902
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.0019721984863281
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.0018930435180664
101	SELECT slug FROM default_guidecat WHERE guidecat_id='15'	0.00020694732666016
102	SELECT slug FROM default_guidecat WHERE guidecat_id='13'	0.00020790100097656
103	SELECT slug FROM default_guidecat WHERE guidecat_id='9'	0.00023603439331055
104	SELECT slug FROM default_guidecat WHERE guidecat_id='2'	0.0001370906829834
105	SELECT slug FROM default_guidecat WHERE guidecat_id='12'	0.00013589859008789
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.00084495544433594
107	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020503997802734
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.00089788436889648
109	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019097328186035
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.00087094306945801
111	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018620491027832
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.0008549690246582
113	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018405914306641
114	SELECT slug FROM default_blogcat WHERE blogcat_id='21'	0.00020098686218262
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.00085592269897461
116	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019598007202148

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