Hồ Nam

tour du lịch Trung Quốc

NAM NINH - TRƯƠNG GIA GIỚI - PHƯỢNG HOÀNG CỔ TRẤN

Bán chạy nhất

5 ngày 4 đêm

NAM NINH - TRƯƠNG GIA GIỚI - PHƯỢNG HOÀNG CỔ TRẤN

Chỉ từ

7,490,000đ

a-z tourism destinations in Trung Quốc

Miền Nam

Nam Ninh (1)

Hong Kong (2)

Miền Bắc

Hàng Châu

Tô Châu

Thượng Hải

Bắc Kinh

Quảng Châu

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour'	0.0020220279693604
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00070381164550781
3	SELECT region_id,title,slug,country_id FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no asc	0.0033340454101562
4	SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1	0.0002448558807373
5	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='14' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0022039413452148
6	SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1	0.00014686584472656
7	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='5' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0019900798797607
8	SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1	0.00014710426330566
9	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='6' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0019919872283936
10	SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1	0.00017094612121582
11	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='7' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.001816987991333
12	SELECT continent_id,title,slug FROM default_continent WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc	0.0014920234680176
13	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='3' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0013298988342285
14	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='4' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0013070106506348
15	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='5' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0011789798736572
16	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='6' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0011920928955078
17	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='7' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0010800361633301
18	SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=477 order by order_no asc	0.00098991394042969
19	SELECT servicecat_id,title,slug,intro,image FROM default_servicecat WHERE lang_id='vn' and is_trash=0 and is_online=1 and servicecat_id IN (7,8,9,10)	0.0011157989501953
20	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='cruise' and act_page='cat' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00050806999206543
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00013399124145508
22	SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0010678768157959
23	SELECT tour_property_id FROM default_tour_property WHERE lang_id='vn' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3	0.0011799335479736
24	SELECT distinct short FROM default_property where property_id=950 LIMIT 0,1	0.00016403198242188
25	SELECT feature_package_id 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.00054597854614258
26	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00012993812561035
27	SELECT feature_package_id 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.00049400329589844
28	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00010991096496582
29	SELECT country_id,title,banner,intro,content FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and slug='trung-quoc' LIMIT 0,1	0.0011539459228516
30	SELECT city_id,title,banner,intro,content FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and slug='ho-nam' LIMIT 0,1	0.0013060569763184
31	SELECT guidecat_id,title,intro FROM default_guidecat WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc	0.0010929107666016
32	SELECT guide_id,title,slug,publish_date,intro FROM default_guide WHERE lang_id='vn' and is_trash=0 and is_online=1 and cat_id='17' and country_id='29' and city_id='959' order by order_no asc	0.0016698837280273
33	SELECT region_id FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='29' order by order_no asc	0.0010340213775635
34	SELECT tourcat_id,title FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc	0.001054048538208
35	SELECT tour_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='29' and city_id='959')	0.0011248588562012
36	SELECT tour_id,departure_point_id,slug,title,image,duration_type,duration_custom,number_day,number_night,list_tag_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='29' and city_id='959') order by order_no asc LIMIT 0,15	0.0013198852539062
37	SELECT max(number_day) as max,min(number_day) as min FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1	0.0010950565338135
38	SELECT max(min_price) as max,min(min_price) as min FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1	0.001072883605957
39	SELECT title FROM default_city WHERE city_id='959'	0.00011682510375977
40	SELECT title FROM default_country WHERE country_id='29'	0.00014114379882812
41	SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0010640621185303
42	SELECT feature_package_id 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.00043010711669922
43	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00011014938354492
44	SELECT page_id,title,slug FROM default_page WHERE lang_id='vn' and is_trash=0 and is_online=1 and page_id <>'2' order by order_no asc	0.0010759830474854
45	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='vn' and (config_link='/du-lich-nuoc-ngoai/du-lich-trung-quoc/ho-nam' or config_link='/du-lich-nuoc-ngoai/du-lich-trung-quoc/ho-nam') limit 1	0.0012640953063965
46	SELECT feature_package_id 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.0005340576171875
47	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001220703125
48	SELECT feature_package_id 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.00043296813964844
49	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.1075897216797E-5
50	SELECT feature_package_id 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.00036787986755371
51	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	8.6069107055664E-5
52	SELECT feature_package_id 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.00036501884460449
53	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00010085105895996
54	SELECT slug FROM default_servicecat WHERE servicecat_id='10'	8.1062316894531E-5
55	SELECT title FROM default_servicecat WHERE servicecat_id='10'	5.8889389038086E-5
56	SELECT title FROM default_servicecat WHERE servicecat_id='10'	3.0040740966797E-5
57	SELECT citystore_id,city_id FROM default_citystore WHERE lang_id='vn' and is_trash=0 and type='DEPARTUREPOINT' and country_id='29' and city_id IN (SELECT city_id FROM default_city WHERE is_trash=0 and is_online=1) order by order_no ASC	0.0011100769042969
58	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and city_id IN(806,808)	0.0010881423950195
59	SELECT feature_package_id 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.00045514106750488
60	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.9897384643555E-5
61	SELECT reviews_id FROM default_reviews WHERE lang_id='vn' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '579' and type='tour'	0.00095486640930176
62	SELECT tour_store_id FROM default_tour_store WHERE lang_id='vn' and tour_id='579' and _type='DEPARTURE' limit 0,1	0.0011329650878906
63	SELECT title FROM default_tag WHERE tag_id='126'	0.00016117095947266
64	SELECT distinct country_id FROM default_region where region_id=53 LIMIT 0,1	9.7036361694336E-5
65	SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='29' and region_id='53' and city_id<>'959' order by order_no ASC	0.0012187957763672
66	SELECT title FROM default_country WHERE country_id='29'	0.00013089179992676
67	SELECT distinct country_id FROM default_region where region_id=53 LIMIT 0,1	8.8214874267578E-5
68	SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='29' and region_id='53' and city_id<>'959' order by order_no ASC	0.0013167858123779
69	SELECT title FROM default_region WHERE region_id='53'	0.00011897087097168
70	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='29' and city_id='960')	0.00027012825012207
71	SELECT distinct country_id FROM default_city where city_id=960 LIMIT 0,1	9.2029571533203E-5
72	SELECT slug FROM default_city WHERE city_id='960'	7.6055526733398E-5
73	SELECT slug FROM default_country WHERE country_id='29'	5.1021575927734E-5
74	SELECT title FROM default_city WHERE city_id='960'	1.5974044799805E-5
75	SELECT title FROM default_city WHERE city_id='960'	8.0108642578125E-5
76	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='29' and city_id='956')	0.00022792816162109
77	SELECT distinct country_id FROM default_city where city_id=956 LIMIT 0,1	8.7976455688477E-5
78	SELECT slug FROM default_city WHERE city_id='956'	9.1075897216797E-5
79	SELECT slug FROM default_country WHERE country_id='29'	7.2956085205078E-5
80	SELECT title FROM default_city WHERE city_id='956'	3.8862228393555E-5
81	SELECT title FROM default_city WHERE city_id='956'	0.00014090538024902
82	SELECT distinct country_id FROM default_region where region_id=27 LIMIT 0,1	8.1062316894531E-5
83	SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='29' and region_id='27' and city_id<>'959' order by order_no ASC	0.001230001449585
84	SELECT title FROM default_region WHERE region_id='27'	0.00012397766113281
85	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='29' and city_id='964')	0.0002288818359375
86	SELECT distinct country_id FROM default_city where city_id=964 LIMIT 0,1	8.702278137207E-5
87	SELECT slug FROM default_city WHERE city_id='964'	3.6954879760742E-5
88	SELECT slug FROM default_country WHERE country_id='29'	0.00013208389282227
89	SELECT title FROM default_city WHERE city_id='964'	0.00010919570922852
90	SELECT title FROM default_city WHERE city_id='964'	7.4863433837891E-5
91	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='29' and city_id='963')	0.00024294853210449
92	SELECT distinct country_id FROM default_city where city_id=963 LIMIT 0,1	8.9883804321289E-5
93	SELECT slug FROM default_city WHERE city_id='963'	0.00010776519775391
94	SELECT slug FROM default_country WHERE country_id='29'	8.4877014160156E-5
95	SELECT title FROM default_city WHERE city_id='963'	6.0081481933594E-5
96	SELECT title FROM default_city WHERE city_id='963'	2.3841857910156E-5
97	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='29' and city_id='962')	0.00023913383483887
98	SELECT distinct country_id FROM default_city where city_id=962 LIMIT 0,1	9.6797943115234E-5
99	SELECT slug FROM default_city WHERE city_id='962'	4.0769577026367E-5
100	SELECT slug FROM default_country WHERE country_id='29'	0.00011086463928223
101	SELECT title FROM default_city WHERE city_id='962'	7.5101852416992E-5
102	SELECT title FROM default_city WHERE city_id='962'	3.4093856811523E-5
103	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='29' and city_id='961')	0.00021100044250488
104	SELECT distinct country_id FROM default_city where city_id=961 LIMIT 0,1	7.7962875366211E-5
105	SELECT slug FROM default_city WHERE city_id='961'	9.7990036010742E-5
106	SELECT slug FROM default_country WHERE country_id='29'	6.1988830566406E-5
107	SELECT title FROM default_city WHERE city_id='961'	2.288818359375E-5
108	SELECT title FROM default_city WHERE city_id='961'	7.9870223999023E-5
109	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='29' and city_id='897')	0.00022292137145996
110	SELECT distinct country_id FROM default_city where city_id=897 LIMIT 0,1	8.392333984375E-5
111	SELECT slug FROM default_city WHERE city_id='897'	7.2002410888672E-5
112	SELECT slug FROM default_country WHERE country_id='29'	3.4809112548828E-5
113	SELECT title FROM default_city WHERE city_id='897'	9.4890594482422E-5
114	SELECT title FROM default_city WHERE city_id='897'	6.2942504882812E-5
115	SELECT feature_package_id 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.00039911270141602
116	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	8.082389831543E-5
117	SELECT feature_package_id 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.00047016143798828
118	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.2983245849609E-5
119	SELECT feature_package_id 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.00042200088500977
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	8.9883804321289E-5
121	SELECT feature_package_id 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.00045013427734375
122	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.0122222900391E-5
123	SELECT feature_package_id 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.00040984153747559
124	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	8.702278137207E-5
125	SELECT feature_package_id 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.0004429817199707
126	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	8.082389831543E-5

Hồ Nam

tour du lịch Trung Quốc

NAM NINH - TRƯƠNG GIA GIỚI - PHƯỢNG HOÀNG CỔ TRẤN

a-z tourism destinations in Trung Quốc

Miền Nam

Nam Ninh (1)

Hong Kong (2)

Miền Bắc

Hàng Châu

Tô Châu

Thượng Hải

Bắc Kinh

Quảng Châu

CÔNG TY TNHH OCEAN GOLD

Về chúng tôi

Kiểu du lịch

Khác

Theo dõi

Kênh thanh toán