1

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

0.0025711059570312

2

SELECT * FROM default_setting WHERE setting_id='1'

0.0013041496276855

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

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

5

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

0.00061511993408203

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

7

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

0.00055289268493652

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

9

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

0.00058197975158691

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

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

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

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

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

15

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

0.0010719299316406

16

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

0.0059030055999756

17

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

0.045971155166626

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 1695769401 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='10' or list_cat_id like '%|10|%')) ORDER BY promotion_id DESC

0.0052840709686279

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='10' or list_cat_id like '%|10|%')) and _type='RECOMMED' ORDER BY order_no asc limit 0,6

0.032068967819214

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='10' or list_cat_id like '%|10|%') ORDER BY order_no asc

0.0096330642700195

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='10' or list_cat_id like '%|10|%') ORDER BY order_no asc limit 0,6

0.003399133682251

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

23

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

0.0029990673065186

24

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

0.00041294097900391

25

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

0.0059430599212646

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

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

0.0072669982910156

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

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

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

31

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

0.0004889965057373

32

SELECT slug FROM default_tour_category WHERE tourcat_id='473'

0.00037479400634766

33

SELECT slug FROM default_country WHERE country_id='10'

0.00044918060302734

34

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

0.0003662109375

35

SELECT slug FROM default_country WHERE country_id='10'

0.00036406517028809

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

37

SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'

0.00098514556884766

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

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

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

41

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

0.006091833114624

42

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

0.00059890747070312

Du thuyền Mekong

VietISO Company

Về chúng tôi

Kiểu du lịch

Khác

Theo dõi

Kênh thanh toán