1

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

0.0012409687042236

2

SELECT * FROM default_setting WHERE setting_id='1'

0.0006098747253418

3

SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' 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.0047929286956787

4

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

5

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

0.00037908554077148

6

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

7

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

0.0003509521484375

8

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

9

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

0.0003209114074707

10

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

11

SELECT city_id,title,slug FROM default_city 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.0039970874786377

12

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

13

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

14

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

15

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

0.00061893463134766

16

SELECT cruise_cat_id FROM default_cruise_cat WHERE lang_id='vn' and is_trash=0 and slug='du-thuyen-song-nuoc' order by cruise_cat_id limit 0,1

0.0038940906524658

17

SELECT cruise_id FROM default_cruise WHERE lang_id='vn' and is_trash=0 and is_online=1 and (cruise_cat_id='50' or list_cat_id like '%|50|%') order by order_no asc

0.0064799785614014

18

SELECT promotion_id,target_id,cruise_itinerary_id,price_text FROM default_promotion WHERE lang_id='vn' and is_online=1 and clsTable='Cruise' and 1686141279 between start_date and end_date and target_id IN (SELECT default_cruise.cruise_id FROM default_cruise WHERE is_trash = 0 and is_online = 1 and (cruise_cat_id='50' or list_cat_id like '%|50|%')) ORDER BY promotion_id DESC

0.0037341117858887

19

SELECT cruise_store_id,cruise_id FROM default_cruise_store WHERE lang_id='vn' and cruise_id in (SELECT default_cruise.cruise_id FROM default_cruise WHERE is_trash = 0 and is_online = 1 and (cruise_cat_id='50' or list_cat_id like '%|50|%')) and _type='RECOMMED' ORDER BY order_no asc limit 0,6

0.0034990310668945

20

SELECT cruise_id FROM default_cruise WHERE lang_id='vn' and cruise_id NOT IN (SELECT default_cruise_store.cruise_id FROM default_cruise_store WHERE is_trash = 0 and _type='RECOMMED') and is_trash=0 and is_online = 1 and (cruise_cat_id='50' or list_cat_id like '%|50|%') ORDER BY order_no asc

0.0048160552978516

21

SELECT cruise_id,title,slug FROM default_cruise WHERE lang_id='vn' and cruise_id NOT IN (SELECT default_cruise_store.cruise_id FROM default_cruise_store WHERE is_trash = 0 and _type='RECOMMED') and is_trash=0 and is_online = 1 and (cruise_cat_id='50' or list_cat_id like '%|50|%') ORDER BY order_no asc limit 0,6

0.0050067901611328

22

SELECT blog_id FROM default_blog WHERE lang_id='vn' and is_trash=0 and is_online=1 and blog_id IN (select blog_id FROM default_blog_destination WHERE city_id ='417') order by reg_date desc

0.0042850971221924

23

SELECT cruise_id FROM default_cruise WHERE lang_id='vn' and is_trash=0 and is_online=1 and (cruise_cat_id='50' or list_cat_id like '%|50|%')

0.0032598972320557

24

SELECT cruise_cat_id,title,image,image_banner,slug,intro FROM default_cruise_cat WHERE cruise_cat_id='50'

0.00041794776916504

25

SELECT meta_id,image FROM default_meta WHERE lang_id='vn' and config_link='/du-thuyen/du-thuyen-song-nuoc/'

0.0044281482696533

26

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

27

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='/du-thuyen/du-thuyen-song-nuoc/' or config_link='/du-thuyen/du-thuyen-song-nuoc/') limit 1

0.0041179656982422

28

SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='62' order by order_no ASC

0.0033140182495117

29

SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='29' order by order_no ASC

0.0027399063110352

30

SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='10' order by order_no ASC

0.0028519630432129

31

SELECT title,slug FROM default_tour_category WHERE tourcat_id='473'

0.00028395652770996

32

SELECT slug FROM default_tour_category WHERE tourcat_id='473'

0.00051403045654297

33

SELECT slug FROM default_country WHERE country_id='10'

0.00043606758117676

34

SELECT title,slug FROM default_tour_category WHERE tourcat_id='468'

0.00023412704467773

35

SELECT slug FROM default_country WHERE country_id='10'

0.00028610229492188

36

SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='vn' and parent_id='9' and is_trash=0 and is_online=1 order by order_no ASC

0.0030169486999512

37

SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'

0.00034594535827637

38

SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='vn' and parent_id='50' and is_trash=0 and is_online=1 order by order_no ASC

0.0027668476104736

39

SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='vn' and parent_id='50' and is_trash=0 and is_online=1 order by order_no ASC

0.0060639381408691

40

SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='vn' and parent_id='10' and is_trash=0 and is_online=1 order by order_no ASC

0.0061321258544922

41

SELECT reviews_id FROM default_reviews WHERE lang_id='vn' and is_trash=0 and is_online=1 and table_id='50' and type='cruise' order by rates desc limit 0,1

0.0039191246032715

42

SELECT COUNT(*) AS totalitem FROM default_reviews WHERE is_trash=0 and is_online=1 and profile_id >0 and table_id = '50' and type='cruise'

0.00040984153747559

Du thuyền sông nước

VietISO Company

Về chúng tôi

Kiểu du lịch

Khác

Theo dõi

Kênh thanh toán