1

SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour'

0.0011188983917236

2

SELECT * FROM default_setting WHERE setting_id='1'

0.00049400329589844

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.0036730766296387

4

SELECT distinct country_id FROM default_region where region_id=54 LIMIT 0,1

0.0003659725189209

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.003849983215332

6

SELECT distinct country_id FROM default_region where region_id=2 LIMIT 0,1

0.0003669261932373

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.017644166946411

8

SELECT distinct country_id FROM default_region where region_id=4 LIMIT 0,1

0.018760919570923

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.0045311450958252

10

SELECT distinct country_id FROM default_region where region_id=3 LIMIT 0,1

0.00037598609924316

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.0040650367736816

12

SELECT distinct country_id FROM default_region where region_id=1 LIMIT 0,1

0.00036787986755371

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.0039510726928711

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.0034229755401611

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.004662036895752

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.0046958923339844

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.0039989948272705

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.0040290355682373

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.0037000179290771

20

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00049805641174316

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.0034759044647217

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.0039200782775879

23

SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1

0.00035905838012695

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.0011069774627686

25

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00035190582275391

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.00086092948913574

27

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00025701522827148

28

SELECT country_id,title,banner,intro,content FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 and slug='vietnam' LIMIT 0,1

0.0035789012908936

29

SELECT city_id,title,banner,intro,content FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and slug='hoian' LIMIT 0,1

0.0036401748657227

30

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.0033071041107178

31

SELECT tour_id FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='1' and city_id='415') and (number_day=1 or duration_type=1)

0.0035989284515381

32

SELECT distinct country_id FROM default_city where city_id=415 LIMIT 0,1

0.00034999847412109

33

SELECT slug FROM default_country WHERE country_id='1'

0.00027298927307129

34

SELECT slug FROM default_city WHERE city_id='415'

0.00027608871459961

35

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 tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='1' and city_id='415') and (number_day=1 or duration_type=1) order by order_no asc LIMIT 0,15

0.013236045837402

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 tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='1' and city_id='415') and (number_day=1 or duration_type=1)

0.0033609867095947

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 tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='1' and city_id='415') and (number_day=1 or duration_type=1)

0.012022018432617

38

SELECT title FROM default_city WHERE city_id='415'

0.0013818740844727

39

SELECT title FROM default_country WHERE country_id='1'

0.0010759830474854

40

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.0015249252319336

41

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00040984153747559

42

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.0060060024261475

43

SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/destinations/vietnam/hoian' or config_link='/destinations/vietnam/hoian') limit 1

0.004270076751709

44

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.0012259483337402

45

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00032496452331543

46

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.0032389163970947

47

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00029706954956055

48

SELECT title FROM default_tour_category WHERE tourcat_id='410'

0.00033903121948242

49

SELECT slug FROM default_tour_category WHERE tourcat_id='410'

0.00024294853210449

50

SELECT title FROM default_tour_category WHERE tourcat_id='403'

0.00027704238891602

51

SELECT slug FROM default_tour_category WHERE tourcat_id='403'

0.00028419494628906

52

SELECT title FROM default_tour_category WHERE tourcat_id='6'

0.00031781196594238

53

SELECT slug FROM default_tour_category WHERE tourcat_id='6'

0.00032305717468262

54

SELECT title FROM default_tour_category WHERE tourcat_id='8'

0.00023603439331055

55

SELECT slug FROM default_tour_category WHERE tourcat_id='8'

0.00028491020202637

56

SELECT title FROM default_tour_category WHERE tourcat_id='412'

0.00028800964355469

57

SELECT slug FROM default_tour_category WHERE tourcat_id='412'

0.00026988983154297

58

SELECT distinct country_id FROM default_city where city_id=392 LIMIT 0,1

0.00036978721618652

59

SELECT slug FROM default_country WHERE country_id='1'

0.00029993057250977

60

SELECT slug FROM default_city WHERE city_id='392'

0.0003199577331543

61

SELECT distinct country_id FROM default_city where city_id=426 LIMIT 0,1

0.00031805038452148

62

SELECT slug FROM default_country WHERE country_id='1'

0.00027585029602051

63

SELECT slug FROM default_city WHERE city_id='426'

0.00026106834411621

64

SELECT distinct country_id FROM default_city where city_id=415 LIMIT 0,1

0.0003349781036377

65

SELECT slug FROM default_country WHERE country_id='1'

0.00030684471130371

66

SELECT slug FROM default_city WHERE city_id='415'

0.00029993057250977

67

SELECT distinct country_id FROM default_city where city_id=383 LIMIT 0,1

0.00031685829162598

68

SELECT slug FROM default_country WHERE country_id='1'

0.00023198127746582

69

SELECT slug FROM default_city WHERE city_id='383'

0.00034809112548828

70

SELECT distinct country_id FROM default_city where city_id=399 LIMIT 0,1

0.00028395652770996

71

SELECT slug FROM default_country WHERE country_id='1'

0.00025486946105957

72

SELECT slug FROM default_city WHERE city_id='399'

0.00025415420532227

73

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.0016100406646729

74

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00026512145996094

75

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.00087785720825195

76

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00024509429931641

77

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.0026588439941406

78

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00027990341186523

79

SELECT * FROM default_service WHERE service_id='5'

0.00034904479980469

80

SELECT slug FROM default_service WHERE service_id='5'

0.00019717216491699

81

SELECT * FROM default_service WHERE service_id='19'

0.00029802322387695

82

SELECT slug FROM default_service WHERE service_id='19'

0.0002589225769043

83

SELECT * FROM default_service WHERE service_id='16'

0.00031399726867676

84

SELECT slug FROM default_service WHERE service_id='16'

0.00046610832214355

85

SELECT * FROM default_service WHERE service_id='2'

0.00027203559875488

86

SELECT slug FROM default_service WHERE service_id='2'

0.00023388862609863

87

SELECT * FROM default_service WHERE service_id='6'

0.00022101402282715

88

SELECT slug FROM default_service WHERE service_id='6'

0.00026106834411621

89

SELECT citystore_id,city_id FROM default_citystore WHERE lang_id='' and is_trash=0 and type='DEPARTUREPOINT' and country_id='1' and city_id IN (SELECT city_id FROM default_city WHERE is_trash=0 and is_online=1) order by order_no ASC

0.0030989646911621

90

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.0026381015777588

91

SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1

0.0010600090026855

92

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.0010221004486084

93

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00027990341186523

94

SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '544' and type='tour'

0.0026900768280029

95

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.00089001655578613

96

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.0003058910369873

97

SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '542' and type='tour'

0.0024840831756592

98

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.0011720657348633

99

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00027084350585938

100

SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '538' and type='tour'

0.0038251876831055

101

SELECT more_information FROM default_discount WHERE lang_id='' and is_trash=0 and is_online=1 and discount_id IN (4) and 1730826000 between booking_date_from and booking_date_to and 1730826000 between travel_date_from and travel_date_to order by travel_date_from ASC limit 0,1

0.0027949810028076

102

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.00088691711425781

103

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00029683113098145

104

SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '537' and type='tour'

0.0040109157562256

105

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.0009770393371582

106

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00027084350585938

107

SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '535' and type='tour'

0.0025010108947754

108

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.00093293190002441

109

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00026583671569824

110

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.00084805488586426

111

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.0018019676208496

112

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.001025915145874

113

SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1

0.00025105476379395

Hoian

Travel Tours Vietnam

My Son Holyland Premium Tour from Hoi An (Small Group maximum for 12pax)

Hoi An Food Walking Tour with Small-Group Option (Maximum for 14 pax)

From Hoi An: Cooking Class & Tra Que Vegetable Village by Bicycle

From Hoi An: Cam Thanh Coconut Village Basket Boat Tour in Small Group

Snorkeling in Cham Islands with Lunch

About Us

OUR PACKAGE

BI’S HOUSE VIET NAM TRAVEL

Follow Us

Payment Channel