1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour'	0.0013577938079834
2	SELECT * FROM default_setting WHERE setting_id='1'	0.0006721019744873
3	SELECT region_id,title,slug,country_id FROM default_region WHERE lang_id='' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no asc	0.0040280818939209
4	SELECT distinct country_id FROM default_region where region_id=54 LIMIT 0,1	0.00032305717468262
5	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='54' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.004065990447998
6	SELECT distinct country_id FROM default_region where region_id=2 LIMIT 0,1	0.00032591819763184
7	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='2' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0038111209869385
8	SELECT distinct country_id FROM default_region where region_id=4 LIMIT 0,1	0.00034213066101074
9	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='4' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0036699771881104
10	SELECT distinct country_id FROM default_region where region_id=3 LIMIT 0,1	0.00033092498779297
11	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='3' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0037369728088379
12	SELECT distinct country_id FROM default_region where region_id=1 LIMIT 0,1	0.00034689903259277
13	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='1' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0037219524383545
14	SELECT country_id,title,slug FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.0035309791564941
15	SELECT country_id,title,slug FROM default_country WHERE lang_id='' 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.0048620700836182
16	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) AND city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0 ) order by order_no ASC	0.00400710105896
17	SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0035078525543213
18	SELECT service_id,title,slug FROM default_service WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0036580562591553
19	SELECT * 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.0012979507446289
20	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00055694580078125
21	SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0036070346832275
22	SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3	0.0029599666595459
23	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00047183036804199
24	SELECT * 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.00095200538635254
25	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026702880859375
26	SELECT * 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.00085210800170898
27	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024294853210449
28	SELECT tourcat_id,slug,title,intro FROM default_tour_category WHERE tourcat_id='415'	0.00033116340637207
29	SELECT tourcat_id FROM default_tour_category WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id='415'	0.0023758411407471
30	SELECT tour_id FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='415' or list_cat_id like '%\|415\|%')	0.0025260448455811
31	SELECT slug FROM default_tour_category WHERE tourcat_id='415'	0.00026988983154297
32	SELECT slug FROM default_tour_category WHERE tourcat_id='415'	0.00022292137145996
33	SELECT tour_id,departure_point_id,slug,title,image,duration_type,duration_custom,number_day,number_night FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='415' or list_cat_id like '%\|415\|%') order by order_no ASC LIMIT 0,15	0.0024371147155762
34	SELECT country_id FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0024328231811523
35	SELECT tourcat_id,title FROM default_tour_category WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0023889541625977
36	SELECT max(number_day) as max,min(number_day) as min FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='415' or list_cat_id like '%\|415\|%')	0.0024211406707764
37	SELECT max(min_price) as max,min(min_price) as min FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='415' or list_cat_id like '%\|415\|%')	0.0024049282073975
38	SELECT category_country_id,content FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and cat_id='415' and country_id = '' limit 0,1	0.0026199817657471
39	SELECT intro FROM default_tour_category WHERE tourcat_id='415'	0.00024509429931641
40	SELECT slug FROM default_tour_category WHERE tourcat_id='415'	0.00023698806762695
41	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/tours/-c415'	0.0024318695068359
42	SELECT distinct image FROM default_tour_category where tourcat_id=415 LIMIT 0,1	0.00024294853210449
43	SELECT * 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.0009148120880127
44	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00027990341186523
45	SELECT page_id,title,slug FROM default_page WHERE lang_id='' and is_trash=0 and is_online=1 and page_id <>'1' order by order_no asc	0.0025529861450195
46	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/tours/-c415' or config_link='/tours/-c415') limit 1	0.0023980140686035
47	SELECT * FROM default_featurepackage WHERE mod_page='setting' and act_page='cart' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.0011200904846191
48	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00033402442932129
49	SELECT * 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.0009307861328125
50	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025200843811035
51	SELECT title FROM default_tour_category WHERE tourcat_id='410'	0.00023698806762695
52	SELECT slug FROM default_tour_category WHERE tourcat_id='410'	0.00018000602722168
53	SELECT title FROM default_tour_category WHERE tourcat_id='403'	0.00025010108947754
54	SELECT slug FROM default_tour_category WHERE tourcat_id='403'	0.00019001960754395
55	SELECT title FROM default_tour_category WHERE tourcat_id='6'	0.00023102760314941
56	SELECT slug FROM default_tour_category WHERE tourcat_id='6'	0.00026702880859375
57	SELECT title FROM default_tour_category WHERE tourcat_id='8'	0.00026202201843262
58	SELECT slug FROM default_tour_category WHERE tourcat_id='8'	0.00020289421081543
59	SELECT title FROM default_tour_category WHERE tourcat_id='412'	0.00024700164794922
60	SELECT slug FROM default_tour_category WHERE tourcat_id='412'	0.00019693374633789
61	SELECT distinct country_id FROM default_city where city_id=392 LIMIT 0,1	0.00038003921508789
62	SELECT slug FROM default_country WHERE country_id='1'	0.00029301643371582
63	SELECT slug FROM default_city WHERE city_id='392'	0.00023698806762695
64	SELECT distinct country_id FROM default_city where city_id=426 LIMIT 0,1	0.00023794174194336
65	SELECT slug FROM default_country WHERE country_id='1'	0.00026321411132812
66	SELECT slug FROM default_city WHERE city_id='426'	0.00021004676818848
67	SELECT distinct country_id FROM default_city where city_id=415 LIMIT 0,1	0.00023603439331055
68	SELECT slug FROM default_country WHERE country_id='1'	0.00020503997802734
69	SELECT slug FROM default_city WHERE city_id='415'	0.00026202201843262
70	SELECT distinct country_id FROM default_city where city_id=383 LIMIT 0,1	0.00023794174194336
71	SELECT slug FROM default_country WHERE country_id='1'	0.0002598762512207
72	SELECT slug FROM default_city WHERE city_id='383'	0.00020813941955566
73	SELECT distinct country_id FROM default_city where city_id=399 LIMIT 0,1	0.00025296211242676
74	SELECT slug FROM default_country WHERE country_id='1'	0.00022101402282715
75	SELECT slug FROM default_city WHERE city_id='399'	0.00026202201843262
76	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.0010612010955811
77	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00027608871459961
78	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00082182884216309
79	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026178359985352
80	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00083112716674805
81	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025796890258789
82	SELECT * FROM default_service WHERE service_id='5'	0.00025510787963867
83	SELECT slug FROM default_service WHERE service_id='5'	0.00020599365234375
84	SELECT * FROM default_service WHERE service_id='19'	0.00032401084899902
85	SELECT slug FROM default_service WHERE service_id='19'	0.00027203559875488
86	SELECT * FROM default_service WHERE service_id='16'	0.00027608871459961
87	SELECT slug FROM default_service WHERE service_id='16'	0.00023412704467773
88	SELECT * FROM default_service WHERE service_id='2'	0.00023198127746582
89	SELECT slug FROM default_service WHERE service_id='2'	0.00026988983154297
90	SELECT * FROM default_service WHERE service_id='6'	0.00025200843811035
91	SELECT slug FROM default_service WHERE service_id='6'	0.00021004676818848
92	SELECT title FROM default_country WHERE country_id=''	0.00022697448730469
93	SELECT intro FROM default_tour_category WHERE tourcat_id='415'	0.00019717216491699
94	SELECT citystore_id,city_id FROM default_citystore WHERE lang_id='' 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.002838134765625
95	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and city_id IN(392,400,383,399,426,650,379,415)	0.0023849010467529
96	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00027298927307129
97	SELECT * 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.00090289115905762
98	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025200843811035
99	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '553' and type='tour'	0.0027689933776855
100	SELECT * 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.00089502334594727
101	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024795532226562
102	SELECT * 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.00084614753723145
103	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024199485778809
104	SELECT * 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.00084590911865234
105	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024008750915527

From Ha Noi: Discover the Charm of Sapa, Fansipan and Cat Cat Village by Bus in 2 Days

About Us

OUR PACKAGE

BI’S HOUSE VIET NAM TRAVEL

Follow Us

Payment Channel