Jecheon

tour du lịch Hàn Quốc

a-z tourism destinations in Hàn Quốc

Gyeonggi

Gimpo

Guri

Goyang

Suwon

Hoseo

Chungju

Cheongju

Chungcheong

Seoul

Gangnam-Gu

Jung-Gu

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour'	0.0010039806365967
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00043988227844238
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.0018661022186279
4	SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1	0.00014996528625488
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.0019388198852539
6	SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1	0.00020289421081543
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.0020229816436768
8	SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1	0.00014305114746094
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.0017998218536377
10	SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1	0.00014090538024902
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.0017590522766113
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.0013270378112793
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.0014851093292236
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.0015490055084229
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.001288890838623
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.0012681484222412
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.0013489723205566
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.0011630058288574
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.0014438629150391
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.0006098747253418
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001988410949707
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.0014269351959229
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.0014190673828125
24	SELECT distinct short FROM default_property where property_id=950 LIMIT 0,1	0.00019216537475586
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.00053191184997559
26	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021719932556152
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.00054192543029785
28	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00014686584472656
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='han-quoc' LIMIT 0,1	0.0016090869903564
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='jecheon' LIMIT 0,1	0.0017850399017334
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.0013959407806396
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='22' and city_id='791' order by order_no asc	0.0017609596252441
33	SELECT region_id FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='22' order by order_no asc	0.0012881755828857
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.0014951229095459
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='22' and city_id='791')	0.0017299652099609
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='22' and city_id='791') order by order_no asc LIMIT 0,15	0.0016021728515625
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.001270055770874
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.0011940002441406
39	SELECT title FROM default_city WHERE city_id='791'	7.9154968261719E-5
40	SELECT title FROM default_country WHERE country_id='22'	0.00012683868408203
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.0013580322265625
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.00052189826965332
43	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001378059387207
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.0013329982757568
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-han-quoc/jecheon' or config_link='/du-lich-nuoc-ngoai/du-lich-han-quoc/jecheon') limit 1	0.0014040470123291
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.00045323371887207
47	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00013113021850586
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.00046420097351074
49	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00010800361633301
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.00046801567077637
51	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001070499420166
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.0004270076751709
53	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017595291137695
54	SELECT slug FROM default_servicecat WHERE servicecat_id='10'	0.00013279914855957
55	SELECT title FROM default_servicecat WHERE servicecat_id='10'	0.00012493133544922
56	SELECT title FROM default_servicecat WHERE servicecat_id='10'	0.00011110305786133
57	SELECT citystore_id,city_id FROM default_citystore WHERE lang_id='vn' and is_trash=0 and type='DEPARTUREPOINT' and country_id='22' and city_id IN (SELECT city_id FROM default_city WHERE is_trash=0 and is_online=1) order by order_no ASC	0.0014889240264893
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(899)	0.0011200904846191
59	SELECT distinct country_id FROM default_region where region_id=11 LIMIT 0,1	0.00011897087097168
60	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='22' and region_id='11' and city_id<>'791' order by order_no ASC	0.0014660358428955
61	SELECT title FROM default_country WHERE country_id='22'	9.4890594482422E-5
62	SELECT distinct country_id FROM default_region where region_id=11 LIMIT 0,1	0.00010204315185547
63	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='22' and region_id='11' and city_id<>'791' order by order_no ASC	0.0013368129730225
64	SELECT title FROM default_region WHERE region_id='11'	0.00014209747314453
65	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='22' and city_id='795')	0.00027799606323242
66	SELECT distinct country_id FROM default_city where city_id=795 LIMIT 0,1	0.00010395050048828
67	SELECT slug FROM default_city WHERE city_id='795'	5.5074691772461E-5
68	SELECT slug FROM default_country WHERE country_id='22'	3.1948089599609E-5
69	SELECT title FROM default_city WHERE city_id='795'	0.00010395050048828
70	SELECT title FROM default_city WHERE city_id='795'	7.2002410888672E-5
71	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='22' and city_id='794')	0.00023317337036133
72	SELECT distinct country_id FROM default_city where city_id=794 LIMIT 0,1	9.0837478637695E-5
73	SELECT slug FROM default_city WHERE city_id='794'	8.4161758422852E-5
74	SELECT slug FROM default_country WHERE country_id='22'	5.6028366088867E-5
75	SELECT title FROM default_city WHERE city_id='794'	2.598762512207E-5
76	SELECT title FROM default_city WHERE city_id='794'	9.7036361694336E-5
77	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='22' and city_id='793')	0.00026798248291016
78	SELECT distinct country_id FROM default_city where city_id=793 LIMIT 0,1	0.00010395050048828
79	SELECT slug FROM default_city WHERE city_id='793'	7.1048736572266E-5
80	SELECT slug FROM default_country WHERE country_id='22'	5.793571472168E-5
81	SELECT title FROM default_city WHERE city_id='793'	3.6001205444336E-5
82	SELECT title FROM default_city WHERE city_id='793'	0.00010800361633301
83	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='22' and city_id='792')	0.00024795532226562
84	SELECT distinct country_id FROM default_city where city_id=792 LIMIT 0,1	9.9897384643555E-5
85	SELECT slug FROM default_city WHERE city_id='792'	5.5074691772461E-5
86	SELECT slug FROM default_country WHERE country_id='22'	4.1961669921875E-5
87	SELECT title FROM default_city WHERE city_id='792'	0.00011897087097168
88	SELECT title FROM default_city WHERE city_id='792'	9.2029571533203E-5
89	SELECT distinct country_id FROM default_region where region_id=10 LIMIT 0,1	9.4890594482422E-5
90	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='22' and region_id='10' and city_id<>'791' order by order_no ASC	0.0012569427490234
91	SELECT distinct country_id FROM default_region where region_id=9 LIMIT 0,1	0.00010395050048828
92	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='22' and region_id='9' and city_id<>'791' order by order_no ASC	0.001215934753418
93	SELECT title FROM default_region WHERE region_id='9'	0.00012707710266113
94	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='22' and city_id='790')	0.00024008750915527
95	SELECT distinct country_id FROM default_city where city_id=790 LIMIT 0,1	9.608268737793E-5
96	SELECT slug FROM default_city WHERE city_id='790'	6.4849853515625E-5
97	SELECT slug FROM default_country WHERE country_id='22'	4.7922134399414E-5
98	SELECT title FROM default_city WHERE city_id='790'	2.2172927856445E-5
99	SELECT title FROM default_city WHERE city_id='790'	0.00010800361633301
100	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='22' and city_id='789')	0.0002598762512207
101	SELECT distinct country_id FROM default_city where city_id=789 LIMIT 0,1	9.2983245849609E-5
102	SELECT slug FROM default_city WHERE city_id='789'	5.4836273193359E-5
103	SELECT slug FROM default_country WHERE country_id='22'	3.504753112793E-5
104	SELECT title FROM default_city WHERE city_id='789'	0.0001060962677002
105	SELECT title FROM default_city WHERE city_id='789'	7.6055526733398E-5
106	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='22' and city_id='788')	0.00022292137145996
107	SELECT distinct country_id FROM default_city where city_id=788 LIMIT 0,1	8.7976455688477E-5
108	SELECT slug FROM default_city WHERE city_id='788'	7.1048736572266E-5
109	SELECT slug FROM default_country WHERE country_id='22'	4.3869018554688E-5
110	SELECT title FROM default_city WHERE city_id='788'	0.00011396408081055
111	SELECT title FROM default_city WHERE city_id='788'	7.8916549682617E-5
112	SELECT distinct country_id FROM default_region where region_id=8 LIMIT 0,1	7.2002410888672E-5
113	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='22' and region_id='8' and city_id<>'791' order by order_no ASC	0.0012269020080566
114	SELECT title FROM default_region WHERE region_id='8'	0.00012493133544922
115	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='22' and city_id='899')	0.00030112266540527
116	SELECT distinct country_id FROM default_city where city_id=899 LIMIT 0,1	0.00012612342834473
117	SELECT slug FROM default_city WHERE city_id='899'	6.2942504882812E-5
118	SELECT slug FROM default_country WHERE country_id='22'	7.7009201049805E-5
119	SELECT title FROM default_city WHERE city_id='899'	6.6041946411133E-5
120	SELECT title FROM default_city WHERE city_id='899'	4.6014785766602E-5
121	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='22' and city_id='898')	0.00028610229492188
122	SELECT distinct country_id FROM default_city where city_id=898 LIMIT 0,1	0.00012087821960449
123	SELECT slug FROM default_city WHERE city_id='898'	6.8902969360352E-5
124	SELECT slug FROM default_country WHERE country_id='22'	5.9127807617188E-5
125	SELECT title FROM default_city WHERE city_id='898'	5.5074691772461E-5
126	SELECT title FROM default_city WHERE city_id='898'	3.4093856811523E-5
127	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.00046801567077637
128	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00011801719665527
129	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.0015919208526611
130	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00015115737915039
131	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.00049996376037598
132	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00013184547424316
133	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.00046300888061523
134	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001220703125
135	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.0006260871887207
136	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00015592575073242
137	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.00059914588928223
138	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00014019012451172

Jecheon

tour du lịch Hàn Quốc

a-z tourism destinations in Hàn Quốc

Gyeonggi

Gimpo

Guri

Goyang

Suwon

Hoseo

Chungju

Cheongju

Chungcheong

Seoul

Gangnam-Gu

Jung-Gu

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