Tour nghỉ dưỡng

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour'	0.0020778179168701
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00043797492980957
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.0013689994812012
4	SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1	0.00013589859008789
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.0015850067138672
6	SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1	0.00012516975402832
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.001471996307373
8	SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1	0.00011396408081055
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.0013999938964844
10	SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1	0.00011420249938965
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.0014169216156006
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.0012171268463135
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.0014150142669678
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.0010800361633301
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.00097203254699707
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.00096416473388672
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.00092887878417969
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.00099396705627441
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.0016319751739502
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.0006721019744873
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023913383483887
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.0010950565338135
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.0011777877807617
24	SELECT distinct short FROM default_property where property_id=950 LIMIT 0,1	0.00017905235290527
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.00055313110351562
26	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00013303756713867
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.00040698051452637
28	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00011396408081055
29	SELECT tourcat_id,slug,title,intro FROM default_tour_category WHERE tourcat_id='481'	0.00017309188842773
30	SELECT tourcat_id FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id='481'	0.0010249614715576
31	SELECT tour_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and (cat_id='481' or list_cat_id like '%\|481\|%')	0.0012807846069336
32	SELECT slug FROM default_tour_category WHERE tourcat_id='481'	0.00019192695617676
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='481' or list_cat_id like '%\|481\|%') order by order_no ASC LIMIT 0,15	0.0013558864593506
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.00092196464538574
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.0010280609130859
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='481' or list_cat_id like '%\|481\|%')	0.0011019706726074
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='481' or list_cat_id like '%\|481\|%')	0.0010180473327637
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='481' and country_id = '' limit 0,1	0.0009770393371582
39	SELECT meta_id,image FROM default_meta WHERE lang_id='vn' and config_link='/loai-hinh-du-lich/tour-nghi-duong-c481'	0.0010900497436523
40	SELECT distinct image FROM default_tour_category where tourcat_id=481 LIMIT 0,1	0.00011301040649414
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.0009310245513916
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.0004420280456543
43	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00010108947753906
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.0010249614715576
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-nghi-duong-c481' or config_link='/loai-hinh-du-lich/tour-nghi-duong-c481') limit 1	0.0010280609130859
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.00049114227294922
47	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00011420249938965
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.00041103363037109
49	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.7036361694336E-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.00044703483581543
51	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.1075897216797E-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.0003359317779541
53	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	7.3909759521484E-5
54	SELECT slug FROM default_servicecat WHERE servicecat_id='10'	7.5817108154297E-5
55	SELECT title FROM default_servicecat WHERE servicecat_id='10'	4.9114227294922E-5
56	SELECT title FROM default_servicecat WHERE servicecat_id='10'	1.6212463378906E-5
57	SELECT title FROM default_country WHERE country_id=''	0.00015497207641602
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.0010809898376465
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.00087809562683105
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.00028300285339355
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.00022602081298828
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.00021505355834961
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.00026297569274902
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.00023412704467773
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.00023198127746582
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.00029397010803223
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.00027203559875488
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.00025606155395508
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.00025391578674316
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.00027990341186523
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.00021505355834961
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.00021886825561523
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.00020503997802734
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.00020408630371094
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.00019502639770508
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.00019192695617676
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.00020384788513184
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.00019502639770508
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.00019288063049316
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.00024509429931641
81	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.00052404403686523
82	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	8.7976455688477E-5
83	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 = '607' and type='tour'	0.00087308883666992
84	SELECT tour_store_id FROM default_tour_store WHERE lang_id='vn' and tour_id='607' and _type='DEPARTURE' limit 0,1	0.0008540153503418
85	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.00042605400085449
86	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001070499420166
87	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 = '590' and type='tour'	0.00079202651977539
88	SELECT tour_store_id FROM default_tour_store WHERE lang_id='vn' and tour_id='590' and _type='DEPARTURE' limit 0,1	0.00085592269897461
89	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.00061893463134766
90	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.7036361694336E-5
91	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 = '587' and type='tour'	0.00090789794921875
92	SELECT tour_store_id FROM default_tour_store WHERE lang_id='vn' and tour_id='587' and _type='DEPARTURE' limit 0,1	0.00084185600280762
93	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.00042819976806641
94	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	7.9870223999023E-5
95	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.0003960132598877
96	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	7.2002410888672E-5
97	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.00034785270690918
98	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	6.8902969360352E-5
99	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.00037217140197754
100	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	7.7962875366211E-5
101	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.0003359317779541
102	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	7.2002410888672E-5
103	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.00042605400085449
104	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	8.392333984375E-5

HÀ NỘI - SAPA - HÀ NỘI

HÀ NỘI - CÔ TÔ - HÀ NỘI

HÀ NỘI - NINH BÌNH - HÀ NỘI

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