1

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

0.0010809898376465

2

SELECT * FROM default_setting WHERE setting_id='1'

0.00051712989807129

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

4

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

0.00032210350036621

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

6

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

0.00033402442932129

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

8

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

0.00031113624572754

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

10

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

0.00034499168395996

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

12

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

0.0003199577331543

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

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

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

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

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

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

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

20

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

0.00027704238891602

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

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

23

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

0.0002591609954834

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

25

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

0.00037193298339844

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

27

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

0.00023698806762695

28

SELECT blogcat_id,title,slug,intro FROM default_blogcat WHERE lang_id='' and is_trash=0 and is_online=1 and slug='shopping' LIMIT 0,1

0.0024158954620361

29

SELECT slug FROM default_blogcat WHERE blogcat_id='2'

0.00028204917907715

30

SELECT blog_id FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (cat_id='2' or list_cat_id like '%|2|%')

0.0024681091308594

31

SELECT blog_id,cat_id,reg_date,publish_date,title,slug,author,image,intro FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (cat_id='2' or list_cat_id like '%|2|%') order by order_no ASC LIMIT 0,6

0.0024199485778809

32

SELECT intro FROM default_blogcat WHERE blogcat_id='2'

0.00025582313537598

33

SELECT * 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.00081491470336914

34

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

0.00024580955505371

35

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

36

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

0.00024700164794922

37

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

38

SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/blog/shopping.html' or config_link='/blog/shopping.html') limit 1

0.0024878978729248

39

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

40

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

0.00025820732116699

41

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

42

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

0.00023007392883301

43

SELECT title FROM default_tour_category WHERE tourcat_id='410'

0.00031113624572754

44

SELECT slug FROM default_tour_category WHERE tourcat_id='410'

0.00023818016052246

45

SELECT title FROM default_tour_category WHERE tourcat_id='403'

0.0001678466796875

46

SELECT slug FROM default_tour_category WHERE tourcat_id='403'

0.00019097328186035

47

SELECT title FROM default_tour_category WHERE tourcat_id='6'

0.00023818016052246

48

SELECT slug FROM default_tour_category WHERE tourcat_id='6'

0.0001678466796875

49

SELECT title FROM default_tour_category WHERE tourcat_id='8'

0.00022482872009277

50

SELECT slug FROM default_tour_category WHERE tourcat_id='8'

0.00025606155395508

51

SELECT title FROM default_tour_category WHERE tourcat_id='412'

0.00020194053649902

52

SELECT slug FROM default_tour_category WHERE tourcat_id='412'

0.00022983551025391

53

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

0.00026297569274902

54

SELECT slug FROM default_country WHERE country_id='1'

0.00025701522827148

55

SELECT slug FROM default_city WHERE city_id='392'

0.00018811225891113

56

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

0.00022387504577637

57

SELECT slug FROM default_country WHERE country_id='1'

0.00026082992553711

58

SELECT slug FROM default_city WHERE city_id='426'

0.00021505355834961

59

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

0.00022387504577637

60

SELECT slug FROM default_country WHERE country_id='1'

0.00021600723266602

61

SELECT slug FROM default_city WHERE city_id='415'

0.00028610229492188

62

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

0.00024604797363281

63

SELECT slug FROM default_country WHERE country_id='1'

0.00018095970153809

64

SELECT slug FROM default_city WHERE city_id='383'

0.00020885467529297

65

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

0.00022315979003906

66

SELECT slug FROM default_country WHERE country_id='1'

0.00020503997802734

67

SELECT slug FROM default_city WHERE city_id='399'

0.00023293495178223

68

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

69

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

0.00026702880859375

70

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

71

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

0.00024080276489258

72

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

73

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

0.00022983551025391

74

SELECT * FROM default_service WHERE service_id='5'

0.0002601146697998

75

SELECT slug FROM default_service WHERE service_id='5'

0.00019097328186035

76

SELECT * FROM default_service WHERE service_id='19'

0.00027680397033691

77

SELECT slug FROM default_service WHERE service_id='19'

0.00021195411682129

78

SELECT * FROM default_service WHERE service_id='16'

0.00032305717468262

79

SELECT slug FROM default_service WHERE service_id='16'

0.00026607513427734

80

SELECT * FROM default_service WHERE service_id='2'

0.00026917457580566

81

SELECT slug FROM default_service WHERE service_id='2'

0.00019502639770508

82

SELECT * FROM default_service WHERE service_id='6'

0.00028777122497559

83

SELECT slug FROM default_service WHERE service_id='6'

0.0002138614654541

84

SELECT blogcat_id, title,slug FROM default_blogcat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc

0.0025808811187744

85

SELECT blog_id,slug,title FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and num_view > 0 order by num_view desc limit 0,5

0.002392053604126

86

SELECT tag_id FROM default_tag WHERE lang_id='' and tag_id IN (SELECT tag_id FROM default_tag_module WHERE 1=1 and type='BLOG')

0.0024909973144531

87

SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='57'

0.00026702880859375

88

SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='58'

0.00023698806762695

89

SELECT COUNT(*) AS totalitem FROM default_tag_module WHERE type='BLOG' and tag_id='59'

0.00023508071899414

90

SELECT blog_extension_id,tour_id FROM default_blog_extension WHERE lang_id='' and blog_id = '' and table_name='tour' and tour_id IN (SELECT tour_id FROM default_tour WHERE is_trash=0 and is_online=1) order by order_no ASC

0.002373218536377

91

SELECT hotel_id FROM default_blog_extension WHERE lang_id='' and blog_id = '' and table_name='hotel' and hotel_id IN (SELECT hotel_id FROM default_hotel WHERE is_trash=0 and is_online=1) order by order_no ASC

0.0025019645690918

92

SELECT * FROM default_featurepackage WHERE mod_page='blog' and act_page='category' and type='default' and type_page='' order by order_no ASC limit 0,1

0.00096988677978516

93

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

0.00027203559875488

94

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

95

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

0.00023603439331055

96

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

97

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

0.00023007392883301

98

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

99

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

0.00025010108947754

Blog listing by category Shopping

About Us

OUR PACKAGE

BI’S HOUSE VIET NAM TRAVEL

Follow Us

Payment Channel