1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour'	0.0009310245513916
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00029993057250977
3	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' 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.0033199787139893
4	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.0023331642150879
5	SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1	0.00023889541625977
6	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.0027728080749512
7	SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1	0.00023484230041504
8	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.0025670528411865
9	SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1	0.0002288818359375
10	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.0025870800018311
11	SELECT city_id,title,slug FROM default_city 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.0028300285339355
12	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.0023081302642822
13	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.0021789073944092
14	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.0021998882293701
15	SELECT distinct short FROM default_property where property_id=950 LIMIT 0,1	0.00025486946105957
16	SELECT city_id,title,banner,intro,content FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and slug='phan-thiet' LIMIT 0,1	0.0026319026947021
17	SELECT guidecat_idintro,title,image FROM default_guidecat WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc	0.0022180080413818
18	SELECT guide_id,slug,title,publish_date FROM default_guide WHERE lang_id='vn' and is_trash=0 and is_online=1 and cat_id='' and country_id='4' and city_id='675' order by order_no asc	0.0043549537658691
19	SELECT region_id,title FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' order by order_no asc	0.002251148223877
20	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.0021591186523438
21	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='4' and city_id='675')	0.0023748874664307
22	SELECT tour_id,title,slug,image 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='4' and city_id='675') order by order_no asc LIMIT 0,15	0.0023250579833984
23	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 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='675')	0.0023019313812256
24	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 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='675')	0.0022430419921875
25	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.0023910999298096
26	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-trong-nuoc/du-lich-phan-thiet' or config_link='/du-lich-trong-nuoc/du-lich-phan-thiet') limit 1	0.0033481121063232
27	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='63' order by order_no ASC	0.002457857131958
28	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='62' order by order_no ASC	0.0020751953125
29	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='29' order by order_no ASC	0.002065896987915
30	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='10' order by order_no ASC	0.0029058456420898
31	SELECT title,slug FROM default_tour_category WHERE tourcat_id='473'	0.00033807754516602
32	SELECT slug FROM default_tour_category WHERE tourcat_id='473'	0.00022602081298828
33	SELECT slug FROM default_country WHERE country_id='10'	0.00033879280090332
34	SELECT title,slug FROM default_tour_category WHERE tourcat_id='468'	0.00023102760314941
35	SELECT slug FROM default_country WHERE country_id='10'	0.00022101402282715
36	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='vn' and parent_id='9' and is_trash=0 and is_online=1 order by order_no ASC	0.002997875213623
37	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='vn' and parent_id='10' and is_trash=0 and is_online=1 order by order_no ASC	0.0029969215393066
38	SELECT title FROM default_country WHERE country_id='4'	0.00031304359436035
39	SELECT title FROM default_country WHERE country_id='4'	0.00030612945556641
40	SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1	0.00036001205444336
41	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='4' and region_id='5' and city_id<>'675' order by order_no ASC	0.0041840076446533
42	SELECT title FROM default_region WHERE region_id='5'	0.00028800964355469
43	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='4' and city_id='804')	0.00058078765869141
44	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='4' and city_id='895')	0.00046110153198242
45	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='4' and city_id='761')	0.00047779083251953
46	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='4' and city_id='699')	0.00045394897460938
47	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='4' and city_id='760')	0.00046801567077637
48	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='4' and city_id='698')	0.00044012069702148
49	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='4' and city_id='684')	0.00047707557678223
50	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='4' and city_id='759')	0.0004279613494873
51	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='4' and city_id='685')	0.00078511238098145
52	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='4' and city_id='683')	0.00074386596679688
53	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='4' and city_id='682')	0.0003809928894043
54	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='4' and city_id='758')	0.00038313865661621
55	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='4' and city_id='673')	0.00034403800964355
56	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='4' and city_id='666')	0.00036191940307617
57	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='4' and city_id='700')	0.00034379959106445
58	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='4' and city_id='656')	0.00034284591674805
59	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='4' and city_id='652')	0.00036191940307617
60	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='4' and city_id='1')	0.00034403800964355
61	SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1	0.00024223327636719
62	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='4' and region_id='6' and city_id<>'675' order by order_no ASC	0.0026581287384033
63	SELECT title FROM default_region WHERE region_id='6'	0.00020289421081543
64	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='4' and city_id='905')	0.00037193298339844
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='4' and city_id='904')	0.00034904479980469
66	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='4' and city_id='805')	0.00035500526428223
67	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='4' and city_id='802')	0.00036907196044922
68	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='4' and city_id='697')	0.00034213066101074
69	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='4' and city_id='670')	0.00036501884460449
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='4' and city_id='690')	0.00034499168395996
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='4' and city_id='660')	0.00034785270690918
72	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='4' and city_id='659')	0.00039315223693848
73	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='4' and city_id='654')	0.00034904479980469
74	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='4' and city_id='678')	0.00035619735717773
75	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='4' and city_id='653')	0.00037598609924316
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='4' and city_id='686')	0.00034403800964355
77	SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1	0.00023102760314941
78	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='4' and region_id='7' and city_id<>'675' order by order_no ASC	0.0026512145996094
79	SELECT title FROM default_region WHERE region_id='7'	0.00019311904907227
80	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='4' and city_id='903')	0.00037002563476562
81	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='4' and city_id='803')	0.00034499168395996
82	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='4' and city_id='801')	0.00035881996154785
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='4' and city_id='764')	0.00034499168395996
84	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='4' and city_id='765')	0.00035405158996582
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='4' and city_id='763')	0.0003659725189209
86	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='4' and city_id='762')	0.00034403800964355
87	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='4' and city_id='677')	0.00035595893859863
88	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='4' and city_id='663')	0.00036215782165527
89	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='4' and city_id='661')	0.00034189224243164
90	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='4' and city_id='658')	0.00035881996154785
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='4' and city_id='657')	0.00034379959106445
92	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='4' and city_id='651')	0.00034189224243164

Phan Thiết

a-z tourism destinations in Việt Nam

Miền Bắc

Miền Trung

Miền Nam

Về chúng tôi

Kiểu du lịch

Khác

Theo dõi

Kênh thanh toán