1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour'	0.0013761520385742
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00048494338989258
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.0016970634460449
4	SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1	0.00017189979553223
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.0018229484558105
6	SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1	0.00014805793762207
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.0018398761749268
8	SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1	0.00015997886657715
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.0017621517181396
10	SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1	0.00014805793762207
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.0015590190887451
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.0015461444854736
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.0014381408691406
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.0015048980712891
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.0014350414276123
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.0013360977172852
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.0015459060668945
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.0013399124145508
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.0014259815216064
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.00073981285095215
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021004676818848
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.0015709400177002
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.0014650821685791
24	SELECT distinct short FROM default_property where property_id=950 LIMIT 0,1	0.00016880035400391
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.00051999092102051
26	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017118453979492
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.0005488395690918
28	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00013995170593262
29	SELECT tourcat_id,slug,title,intro FROM default_tour_category WHERE tourcat_id='477'	0.00017499923706055
30	SELECT tourcat_id FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id='477'	0.0013060569763184
31	SELECT tour_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and (cat_id='477' or list_cat_id like '%\|477\|%' or cat_id IN (SELECT tourcat_id FROM default_tour_category WHERE parent_id = '477'))	0.0014450550079346
32	SELECT slug FROM default_tour_category WHERE tourcat_id='477'	0.00011086463928223
33	SELECT tour_id,departure_point_id,slug,title,image,duration_type,duration_custom,number_day,number_night FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and (cat_id='477' or list_cat_id like '%\|477\|%' or cat_id IN (SELECT tourcat_id FROM default_tour_category WHERE parent_id = '477')) order by order_no ASC LIMIT 0,15	0.0016829967498779
34	SELECT country_id FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc	0.0012938976287842
35	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.0011551380157471
36	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 (cat_id='477' or list_cat_id like '%\|477\|%' or cat_id IN (SELECT tourcat_id FROM default_tour_category WHERE parent_id = '477'))	0.001554012298584
37	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 (cat_id='477' or list_cat_id like '%\|477\|%' or cat_id IN (SELECT tourcat_id FROM default_tour_category WHERE parent_id = '477'))	0.0014040470123291
38	SELECT category_country_id,content FROM default_category_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and cat_id='477' and country_id = '' limit 0,1	0.0012080669403076
39	SELECT meta_id,image FROM default_meta WHERE lang_id='vn' and config_link='/loai-hinh-du-lich/tour-ghep-c477'	0.0015740394592285
40	SELECT distinct image FROM default_tour_category where tourcat_id=477 LIMIT 0,1	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.0015099048614502
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.00067710876464844
43	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00014400482177734
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.0012500286102295
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='/loai-hinh-du-lich/tour-ghep-c477' or config_link='/loai-hinh-du-lich/tour-ghep-c477') limit 1	0.0012478828430176
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.00012397766113281
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.0005190372467041
49	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00010013580322266
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.00036811828613281
51	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001060962677002
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.00043201446533203
53	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.608268737793E-5
54	SELECT slug FROM default_servicecat WHERE servicecat_id='10'	0.00010085105895996
55	SELECT title FROM default_servicecat WHERE servicecat_id='10'	8.8930130004883E-5
56	SELECT title FROM default_servicecat WHERE servicecat_id='10'	6.6995620727539E-5
57	SELECT title FROM default_country WHERE country_id=''	0.00011491775512695
58	SELECT citystore_id,city_id FROM default_citystore WHERE lang_id='vn' and is_trash=0 and type='DEPARTUREPOINT' and city_id IN (SELECT city_id FROM default_city WHERE is_trash=0 and is_online=1) order by order_no ASC	0.001384973526001
59	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and city_id IN(651,653,672,806,700,808,1,899)	0.0011749267578125
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='917')	0.00030708312988281
61	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='915')	0.0003049373626709
62	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='914')	0.00029683113098145
63	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.00028514862060547
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='699')	0.00029778480529785
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='760')	0.00028419494628906
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='685')	0.00023794174194336
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='683')	0.00022602081298828
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='682')	0.00023221969604492
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='758')	0.00022292137145996
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='700')	0.00024104118347168
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='920')	0.00024104118347168
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='919')	0.00022721290588379
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='906')	0.00021791458129883
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='802')	0.00021600723266602
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='659')	0.00022101402282715
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='653')	0.00020813941955566
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='4' and city_id='910')	0.00032711029052734
78	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='908')	0.0002748966217041
79	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='907')	0.00026607513427734
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='801')	0.00028204917907715
81	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.00049710273742676
82	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00011301040649414
83	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.00045919418334961
84	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.2983245849609E-5
85	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.00045299530029297
86	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00011205673217773
87	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.00043296813964844
88	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.9897384643555E-5
89	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.00049710273742676
90	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00010299682617188
91	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.00047492980957031
92	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00013899803161621

Tour ghép

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