About us| Booking Conditions| Testimonials| FAQs| Contact| Follow us

Cruise Search

Create your perfect your ideas

Leading Halong Bay Cruises

Leading Mekong River Cruises

Traveler's Blogs

28 Oct 2017

Halong Bay, an unforgettable memory

I am missing about Halong Bay, one of most beautiful places I worked. Hopefully, after my writing, I can contribute my small...

09 Jul 2016

Five friendly street food ladies in Ho Chi Minh City

One of the joys of having a homebase is getting known by the local vendors. Whenever I return to Saigon after some time...

07 Jul 2016

South Korean low-cost airline now flies to Da Nang

South Korean low-cost carrier T’way Air has launched a new direct service from Seoul to Da Nang .

Cruise

Cruise

Leading Travel specializes in booking best Vietnam Cruises, Halong Bay Cruises, Mekong River Cruises, Bai Tu Long Bay Cruises, Cat Ba Island Cruises, Lan Ha Bay Cruises, Nha Trang Bay Cruises and Phu Quoc Island Cruises. Plan a trip to Vietnam and embark on one of the best cruises below to explore new destinations.

Doris Cruise

Launched in June 2022, the Doris Cruise is a five-star luxury cruise that visits Halong Bay and Lan Ha Bay. Tourists will have the opportunity to...

2 Days/1 Night, 3 Days/2 Nights

From USD: $159

View detail

Ambassador Cruise I

Ambassador Cruise I

Ambassador Cruise I (formerly known as the President Cruise) features 46 trendy and stylish cabins and a capacity for 120 passengers, this...

2 Days/1 Night, 3 Days/2 Nights

From USD: $194

View detail

Le Theatre Cruise

Le Theatre Cruise

Le Theatre Cruises features 21 neo-classical, ocean-view ensuite cabins. Le Opera restaurant of the cruise offers a classy, unique dining...

2 Days/1 Night, 3 Days/2 Nights

From USD: $169

View detail

Rosy Cruise

One of the most opulent 5-star cruises accessible to see Halong Bay and Lan Ha Bay, emblems of the natural splendor of Vietnam, is the Rosy...

2 Days/1 Night, 3 Days/2 Nights

From USD: $144

View detail

Aspira Cruise

Aspira Cruise has 22 exquisite cabins with the best amenities for an opulent and comfortable cruise experience. Every cabin has a private balcony...

2 Days/1 Night, 3 Days/2 Nights

From USD: $149

View detail

Genesis Regal Cruise

Genesis Regal Cruise

The 2019-built Genesis Regal Cruise combines the ancient quintessence of the Vietnamese Royal dynasty with French Neoclassicism (Indochina). The...

2 Days/1 Night, 3 Days/2 Nights

From USD: $173

View detail

1 2 3 4 5

Booking with confidence

1

Best Value

Customer's satisfaction is the biggest goal and inspiration in our career. We always try our best to deliver as much pleasure as possible to every tourist...

2

Best Price Guarantee

At Viet Leading Travel™, We are confident to ensure the best and cannot-be-better price for you. Please take a look at our Best Price Guarantee policy

3

Best Local Support

We are local people, We are always here to support you 24/7 - ready to listen and arrange everything as your desire. Surely, you will feel satisfactory!

4

Certificate of Excellence 2015

We are proud to be 2015 winner and awarded the Certificate of Excellence 2015 by Tripadvisor

Join to get special offers & great promotions

Enter your email to quickly get Great Promotion Code, Special offers, Hot deals, and Huge discounts. Don't miss out!

“Great service from start to finish”

“Great service from start to finish”

" With initial contact to help touring remote aspects in Northern Vietnam, Viet Leading Travel is the most professional, skilled and personable. The driver has been very experienced together..."

Susan , Australia

“Viet Leading Travel is the very best!”

“Viet Leading Travel is the very best!”

" Viet Leading Travel is the most effective travel company we now have ever used within a lifetime of holiday. From the start we knew people were in skilled hands. The staff caused us regularly to..."

BobAbroad , Austria

“Fun In Vietnam, WOW!”

“Fun In Vietnam, WOW!”

" The guides were the highlight in the trip, and this is saying something! This trip has been so well thought and perfectly adjusted to accommodate our holiday together with group. It was some sort..."

David , Armenia

Our company

Why travel with us

Terms & Conditions

DESTINATIONS

Travel styles

Luxury & Honeymoon

Halong & Mekong Cruises

Leading Halong Bay Cruises

Leading Mekong River Cruises

Add: 3 Hamlet, Van Phuc Commune, Thanh Tri District, Ha Noi City, Vietnam

Tel: or WhatsApp/Hotline (+84) 985036337

Email: sales@vietleadingtravel.com

Copyright © 2006 - 2024. All Rights Reserved to Viet Leading Travel™ - Authentic & Unique Experience in Vietnam! Tour Operation Lisence No: 0106181248

Travel website design by VIETISO

1	SELECT * FROM default_configuration WHERE 1=1	0.0013790130615234
2	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='cruise'	0.00025081634521484
3	SELECT * FROM default_setting WHERE setting_id='1'	0.00032281875610352
4	SELECT * FROM default_configuration WHERE 1=1	0.0013270378112793
5	SELECT * FROM default_configuration WHERE 1=1	0.0013260841369629
6	SELECT * FROM default_configuration WHERE 1=1	0.0010960102081299
7	SELECT country_id FROM default_country WHERE is_trash=0 and is_online=1 order by order_no asc	0.00032496452331543
8	SELECT country_id FROM default_country WHERE country_id='1'	0.00022101402282715
9	SELECT title FROM default_country WHERE country_id='1'	0.00021195411682129
10	SELECT slug FROM default_country WHERE country_id='1'	0.00020289421081543
11	SELECT slug FROM default_country WHERE country_id='1'	0.00019001960754395
12	SELECT intro_tour,intro_hotel,intro_guide,intro FROM default_country WHERE country_id='1'	0.00020718574523926
13	SELECT image FROM default_country WHERE country_id='1'	0.00014591217041016
14	SELECT imagehome FROM default_country WHERE country_id='1'	0.00013303756713867
15	SELECT country_id FROM default_country WHERE country_id='2'	0.00010299682617188
16	SELECT title FROM default_country WHERE country_id='2'	0.00017690658569336
17	SELECT slug FROM default_country WHERE country_id='2'	0.00015091896057129
18	SELECT slug FROM default_country WHERE country_id='2'	0.00014114379882812
19	SELECT intro_tour,intro_hotel,intro_guide,intro FROM default_country WHERE country_id='2'	0.00022602081298828
20	SELECT image FROM default_country WHERE country_id='2'	0.00020194053649902
21	SELECT imagehome FROM default_country WHERE country_id='2'	0.00017881393432617
22	SELECT country_id FROM default_country WHERE country_id='3'	0.00013613700866699
23	SELECT title FROM default_country WHERE country_id='3'	0.00020909309387207
24	SELECT slug FROM default_country WHERE country_id='3'	0.00022792816162109
25	SELECT slug FROM default_country WHERE country_id='3'	0.00020289421081543
26	SELECT intro_tour,intro_hotel,intro_guide,intro FROM default_country WHERE country_id='3'	0.00018715858459473
27	SELECT image FROM default_country WHERE country_id='3'	0.00016403198242188
28	SELECT imagehome FROM default_country WHERE country_id='3'	0.00014710426330566
29	SELECT tourcat_id FROM default_tour_category WHERE is_trash=0 and is_online=1 and _type<>'HANDICRAFT' and _type<>'GOLFTOUR' and parent_id=0 order by order_no desc	0.00024008750915527
30	SELECT tourcat_id FROM default_tour_category WHERE is_trash=0 and is_online=1 and _type='GOLFTOUR' and parent_id=0 order by order_no asc limit 0,1	0.00021815299987793
31	SELECT city_id FROM default_city WHERE is_trash=0 and country_id='1' and city_id IN (SELECT city_id FROM default_citystore WHERE country_id='1' and type='TOP') order by order_no ASC	0.00059294700622559
32	SELECT cruise_cat_id FROM default_cruise_cat WHERE is_trash=0 and parent_id=0 order by order_no DESC	0.00020790100097656
33	SELECT tourcat_id FROM default_tour_category WHERE is_trash=0 and is_online=1 and parent_id=1 and _type='HANDICRAFT' order by order_no desc	0.00024700164794922
34	SELECT cruise_store_id,cruise_id FROM default_cruise_store WHERE is_trash=0 and _type='TOP' and cruise_id IN (SELECT cruise_id FROM default_cruise WHERE is_trash=0 and is_online=1) order by order_no desc	0.00053191184997559
35	SELECT cruise_id FROM default_cruise WHERE is_trash=0 and is_online=1 order by order_no desc limit 6,6	0.00055813789367676
36	SELECT COUNT(*) AS totalitem FROM default_cruise WHERE is_trash=0 and is_online=1	0.0003960132598877
37	SELECT config_value_title,config_value_intro,config_value_keyword FROM default_meta WHERE config_link='/cruises&page=2' or config_link='/cruises&page=2' limit 1	0.00082302093505859
38	SELECT title FROM default_tour_category WHERE tourcat_id='333'	0.0002589225769043
39	SELECT slug FROM default_tour_category WHERE tourcat_id='333'	0.00013899803161621
40	SELECT title FROM default_tour_category WHERE tourcat_id='2'	0.00012707710266113
41	SELECT slug FROM default_tour_category WHERE tourcat_id='2'	0.00019502639770508
42	SELECT title FROM default_tour_category WHERE tourcat_id='314'	0.00016593933105469
43	SELECT slug FROM default_tour_category WHERE tourcat_id='314'	0.00014901161193848
44	SELECT title FROM default_tour_category WHERE tourcat_id='312'	0.00012016296386719
45	SELECT slug FROM default_tour_category WHERE tourcat_id='312'	0.00019192695617676
46	SELECT title FROM default_tour_category WHERE tourcat_id='279'	0.00016283988952637
47	SELECT slug FROM default_tour_category WHERE tourcat_id='279'	0.00013113021850586
48	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00012707710266113
49	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00021004676818848
50	SELECT cruise_cat_id FROM default_cruise_cat WHERE is_trash=0 and parent_id='2' order by order_no DESC	0.00022292137145996
51	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='4'	0.0001990795135498
52	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00016617774963379
53	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='5'	0.00014615058898926
54	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='5'	0.00013399124145508
55	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='3'	0.00020503997802734
56	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='3'	0.00017404556274414
57	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00014400482177734
58	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00011110305786133
59	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00018095970153809
60	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00016117095947266
61	SELECT cruise_cat_id FROM default_cruise_cat WHERE is_trash=0 and parent_id='7' order by order_no DESC	0.00017213821411133
62	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='11'	0.00014901161193848
63	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='11'	0.00011491775512695
64	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='10'	0.00018501281738281
65	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='10'	0.0001521110534668
66	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='9'	0.00013613700866699
67	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='9'	0.00020289421081543
68	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='8'	0.00017213821411133
69	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='8'	0.0001380443572998
70	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0036859512329102
71	SELECT city_id FROM default_city WHERE is_trash=0 and is_online=1 and country_id='1' order by order_no DESC	0.00045609474182129
72	SELECT title FROM default_city WHERE city_id='598'	0.00016999244689941
73	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='598') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0035090446472168
74	SELECT title FROM default_city WHERE city_id='392'	0.00018310546875
75	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='392') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0042850971221924
76	SELECT * FROM default_city WHERE city_id='392'	0.00030016899108887
77	SELECT slug FROM default_country WHERE country_id='1'	0.0002129077911377
78	SELECT slug FROM default_city WHERE city_id='392'	0.00019192695617676
79	SELECT title FROM default_city WHERE city_id='399'	0.0001978874206543
80	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='399') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0039079189300537
81	SELECT * FROM default_city WHERE city_id='399'	0.00028514862060547
82	SELECT slug FROM default_country WHERE country_id='1'	0.00017404556274414
83	SELECT slug FROM default_city WHERE city_id='399'	0.00015497207641602
84	SELECT title FROM default_city WHERE city_id='383'	0.00014901161193848
85	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='383') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0035707950592041
86	SELECT * FROM default_city WHERE city_id='383'	0.00028705596923828
87	SELECT slug FROM default_country WHERE country_id='1'	0.00017619132995605
88	SELECT slug FROM default_city WHERE city_id='383'	0.00015497207641602
89	SELECT title FROM default_city WHERE city_id='406'	0.00014996528625488
90	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='406') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0035638809204102
91	SELECT * FROM default_city WHERE city_id='406'	0.0002601146697998
92	SELECT slug FROM default_country WHERE country_id='1'	0.00016498565673828
93	SELECT slug FROM default_city WHERE city_id='406'	0.00013399124145508
94	SELECT title FROM default_city WHERE city_id='400'	0.00022292137145996
95	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='400') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0035610198974609
96	SELECT * FROM default_city WHERE city_id='400'	0.00024199485778809
97	SELECT slug FROM default_country WHERE country_id='1'	0.00013208389282227
98	SELECT slug FROM default_city WHERE city_id='400'	0.00020503997802734
99	SELECT title FROM default_city WHERE city_id='401'	0.00018978118896484
100	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='401') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034279823303223
101	SELECT title FROM default_city WHERE city_id='415'	0.0002140998840332
102	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='415') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0036411285400391
103	SELECT * FROM default_city WHERE city_id='415'	0.00020790100097656
104	SELECT slug FROM default_country WHERE country_id='1'	0.00020289421081543
105	SELECT slug FROM default_city WHERE city_id='415'	0.00017499923706055
106	SELECT title FROM default_city WHERE city_id='417'	0.00016212463378906
107	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='417') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0050649642944336
108	SELECT * FROM default_city WHERE city_id='417'	0.00022697448730469
109	SELECT slug FROM default_country WHERE country_id='1'	0.00022196769714355
110	SELECT slug FROM default_city WHERE city_id='417'	0.00020003318786621
111	SELECT title FROM default_city WHERE city_id='426'	0.00018906593322754
112	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='426') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0036201477050781
113	SELECT * FROM default_city WHERE city_id='426'	0.00027012825012207
114	SELECT slug FROM default_country WHERE country_id='1'	0.00016021728515625
115	SELECT slug FROM default_city WHERE city_id='426'	0.00016617774963379
116	SELECT title FROM default_city WHERE city_id='379'	0.00014805793762207
117	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='379') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034539699554443
118	SELECT * FROM default_city WHERE city_id='379'	0.00026893615722656
119	SELECT slug FROM default_country WHERE country_id='1'	0.00015807151794434
120	SELECT slug FROM default_city WHERE city_id='379'	0.00013089179992676
121	SELECT title FROM default_city WHERE city_id='370'	0.00021195411682129
122	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='370') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034449100494385
123	SELECT * FROM default_city WHERE city_id='370'	0.00020599365234375
124	SELECT slug FROM default_country WHERE country_id='1'	0.00019502639770508
125	SELECT slug FROM default_city WHERE city_id='370'	0.00016689300537109
126	SELECT title FROM default_city WHERE city_id='404'	0.00015997886657715
127	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='404') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0035140514373779
128	SELECT title FROM default_city WHERE city_id='408'	0.00016498565673828
129	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='408') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033800601959229
130	SELECT title FROM default_city WHERE city_id='432'	0.00015497207641602
131	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='432') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033838748931885
132	SELECT title FROM default_city WHERE city_id='430'	0.00012993812561035
133	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='430') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.00343918800354
134	SELECT title FROM default_city WHERE city_id='431'	0.00015997886657715
135	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='431') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033879280090332
136	SELECT title FROM default_city WHERE city_id='424'	0.00013899803161621
137	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='424') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034050941467285
138	SELECT title FROM default_city WHERE city_id='423'	0.00013494491577148
139	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='423') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0035378932952881
140	SELECT title FROM default_city WHERE city_id='425'	0.00037503242492676
141	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='425') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0040888786315918
142	SELECT title FROM default_city WHERE city_id='427'	0.00017619132995605
143	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='427') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0038881301879883
144	SELECT title FROM default_city WHERE city_id='428'	0.00016903877258301
145	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='428') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0040688514709473
146	SELECT title FROM default_city WHERE city_id='429'	0.00019097328186035
147	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='429') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0035068988800049
148	SELECT title FROM default_city WHERE city_id='422'	0.00018787384033203
149	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='422') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034329891204834
150	SELECT title FROM default_city WHERE city_id='420'	0.00020909309387207
151	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='420') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033681392669678
152	SELECT title FROM default_city WHERE city_id='421'	0.00017976760864258
153	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='421') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033769607543945
154	SELECT title FROM default_city WHERE city_id='377'	0.00014400482177734
155	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='377') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033888816833496
156	SELECT * FROM default_city WHERE city_id='377'	0.00018715858459473
157	SELECT slug FROM default_country WHERE country_id='1'	0.00018501281738281
158	SELECT slug FROM default_city WHERE city_id='377'	0.00014996528625488
159	SELECT title FROM default_city WHERE city_id='416'	0.0001220703125
160	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='416') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034000873565674
161	SELECT title FROM default_city WHERE city_id='419'	0.00021004676818848
162	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='419') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033681392669678
163	SELECT title FROM default_city WHERE city_id='592'	0.00016403198242188
164	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='592') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033919811248779
165	SELECT title FROM default_city WHERE city_id='593'	0.00015711784362793
166	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='593') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033550262451172
167	SELECT title FROM default_city WHERE city_id='589'	0.00021100044250488
168	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='589') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033888816833496
169	SELECT title FROM default_city WHERE city_id='412'	0.00018596649169922
170	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='412') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.003413200378418
171	SELECT title FROM default_city WHERE city_id='413'	0.00018715858459473
172	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='413') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033628940582275
173	SELECT title FROM default_city WHERE city_id='389'	0.00014185905456543
174	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='389') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033769607543945
175	SELECT title FROM default_city WHERE city_id='411'	0.00020384788513184
176	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='411') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033700466156006
177	SELECT title FROM default_city WHERE city_id='409'	0.00015997886657715
178	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='409') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033829212188721
179	SELECT title FROM default_city WHERE city_id='405'	0.00014400482177734
180	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='405') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033669471740723
181	SELECT title FROM default_city WHERE city_id='407'	0.00021004676818848
182	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='407') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033731460571289
183	SELECT * FROM default_city WHERE city_id='407'	0.00022196769714355
184	SELECT slug FROM default_country WHERE country_id='1'	0.00020599365234375
185	SELECT slug FROM default_city WHERE city_id='407'	0.00018596649169922
186	SELECT title FROM default_city WHERE city_id='587'	0.00015807151794434
187	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='587') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034050941467285
188	SELECT title FROM default_city WHERE city_id='403'	0.00014901161193848
189	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='403') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034379959106445
190	SELECT title FROM default_city WHERE city_id='591'	0.00017285346984863
191	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='591') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033700466156006
192	SELECT title FROM default_city WHERE city_id='402'	0.00014305114746094
193	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='402') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033738613128662
194	SELECT title FROM default_city WHERE city_id='398'	0.00020408630371094
195	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='398') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033919811248779
196	SELECT title FROM default_city WHERE city_id='397'	0.0001828670501709
197	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='397') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033729076385498
198	SELECT title FROM default_city WHERE city_id='396'	0.00014805793762207
199	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='396') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0035049915313721
200	SELECT title FROM default_city WHERE city_id='395'	0.00014019012451172
201	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='395') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.003364086151123
202	SELECT title FROM default_city WHERE city_id='394'	0.00020217895507812
203	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='394') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033769607543945
204	SELECT title FROM default_city WHERE city_id='393'	0.00017786026000977
205	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='393') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0035080909729004
206	SELECT title FROM default_city WHERE city_id='391'	0.00018191337585449
207	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='391') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033938884735107
208	SELECT title FROM default_city WHERE city_id='390'	0.00016307830810547
209	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='390') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034022331237793
210	SELECT title FROM default_city WHERE city_id='388'	0.00015592575073242
211	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='388') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033771991729736
212	SELECT title FROM default_city WHERE city_id='386'	0.00013303756713867
213	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='386') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034849643707275
214	SELECT * FROM default_city WHERE city_id='386'	0.00026893615722656
215	SELECT slug FROM default_country WHERE country_id='1'	0.00016498565673828
216	SELECT slug FROM default_city WHERE city_id='386'	0.00014710426330566
217	SELECT title FROM default_city WHERE city_id='387'	0.00011897087097168
218	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='387') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034282207489014
219	SELECT title FROM default_city WHERE city_id='385'	0.0001370906829834
220	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='385') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033891201019287
221	SELECT title FROM default_city WHERE city_id='384'	0.0002131462097168
222	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='384') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033700466156006
223	SELECT title FROM default_city WHERE city_id='381'	0.00018692016601562
224	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='381') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033829212188721
225	SELECT title FROM default_city WHERE city_id='380'	0.00015616416931152
226	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='380') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.003385066986084
227	SELECT title FROM default_city WHERE city_id='369'	0.00014090538024902
228	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='369') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033719539642334
229	SELECT title FROM default_city WHERE city_id='378'	0.00020694732666016
230	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='378') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033819675445557
231	SELECT title FROM default_city WHERE city_id='376'	0.00017619132995605
232	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='376') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034239292144775
233	SELECT * FROM default_city WHERE city_id='376'	0.00025105476379395
234	SELECT slug FROM default_country WHERE country_id='1'	0.0001380443572998
235	SELECT slug FROM default_city WHERE city_id='376'	0.00020289421081543
236	SELECT title FROM default_city WHERE city_id='375'	0.00017499923706055
237	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='375') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034561157226562
238	SELECT title FROM default_city WHERE city_id='374'	0.00011801719665527
239	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='374') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.003385066986084
240	SELECT title FROM default_city WHERE city_id='373'	0.00019001960754395
241	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='373') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0033960342407227
242	SELECT title FROM default_city WHERE city_id='371'	0.00017189979553223
243	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='371') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.003371000289917
244	SELECT title FROM default_city WHERE city_id='372'	0.00012922286987305
245	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='372') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.003403902053833
246	SELECT title FROM default_city WHERE city_id='414'	0.00011897087097168
247	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='414') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034158229827881
248	SELECT title FROM default_city WHERE city_id='382'	0.00013399124145508
249	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='382') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0034558773040771
250	SELECT title FROM default_city WHERE city_id='594'	0.00019001960754395
251	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='594') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0036051273345947
252	SELECT * FROM default_city WHERE city_id='594'	0.00025701522827148
253	SELECT slug FROM default_country WHERE country_id='1'	0.00014185905456543
254	SELECT slug FROM default_city WHERE city_id='594'	0.00021505355834961
255	SELECT title FROM default_city WHERE city_id='410'	0.00019598007202148
256	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='1') and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE city_id='410') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0035130977630615
257	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='2') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.00043606758117676
258	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='3') and (cat_id = '3' or list_cat_id like '%\|3\|%')	0.0004580020904541
259	SELECT tourcat_id FROM default_tour_category WHERE is_trash=0 and parent_id='4' order by order_no ASC	0.0002448558807373
260	SELECT slug FROM default_tour_category WHERE tourcat_id='4'	0.00011897087097168
261	SELECT title FROM default_tour_category WHERE tourcat_id='4'	0.00018596649169922
262	SELECT title FROM default_tour_category WHERE tourcat_id='4'	0.00014901161193848
263	SELECT slug FROM default_tour_category WHERE tourcat_id='325'	0.00015401840209961
264	SELECT title FROM default_tour_category WHERE tourcat_id='325'	0.00011897087097168
265	SELECT image FROM default_tour_category WHERE tourcat_id='325'	0.00021100044250488
266	SELECT title FROM default_tour_category WHERE tourcat_id='325'	0.00018191337585449
267	SELECT slug FROM default_tour_category WHERE tourcat_id='325'	0.00014591217041016
268	SELECT title FROM default_tour_category WHERE tourcat_id='325'	0.00010991096496582
269	SELECT title FROM default_tour_category WHERE tourcat_id='325'	0.00017309188842773
270	SELECT intro FROM default_tour_category WHERE tourcat_id='325'	0.00013995170593262
271	SELECT slug FROM default_tour_category WHERE tourcat_id='325'	0.00011801719665527
272	SELECT slug FROM default_tour_category WHERE tourcat_id='322'	0.00019097328186035
273	SELECT title FROM default_tour_category WHERE tourcat_id='322'	0.00015401840209961
274	SELECT image FROM default_tour_category WHERE tourcat_id='322'	0.00011587142944336
275	SELECT title FROM default_tour_category WHERE tourcat_id='322'	0.00018191337585449
276	SELECT slug FROM default_tour_category WHERE tourcat_id='322'	0.00015902519226074
277	SELECT title FROM default_tour_category WHERE tourcat_id='322'	0.00012302398681641
278	SELECT title FROM default_tour_category WHERE tourcat_id='322'	0.00018501281738281
279	SELECT intro FROM default_tour_category WHERE tourcat_id='322'	0.00014996528625488
280	SELECT slug FROM default_tour_category WHERE tourcat_id='322'	0.00013494491577148
281	SELECT tourcat_id FROM default_tour_category WHERE is_trash=0 and parent_id='327' order by order_no ASC	0.00015592575073242
282	SELECT slug FROM default_tour_category WHERE tourcat_id='327'	0.00014185905456543
283	SELECT title FROM default_tour_category WHERE tourcat_id='327'	0.0001070499420166
284	SELECT title FROM default_tour_category WHERE tourcat_id='327'	0.00016903877258301
285	SELECT slug FROM default_tour_category WHERE tourcat_id='331'	0.00014090538024902
286	SELECT title FROM default_tour_category WHERE tourcat_id='331'	0.00010585784912109
287	SELECT image FROM default_tour_category WHERE tourcat_id='331'	0.00018405914306641
288	SELECT title FROM default_tour_category WHERE tourcat_id='331'	0.0001530647277832
289	SELECT slug FROM default_tour_category WHERE tourcat_id='331'	0.00011587142944336
290	SELECT title FROM default_tour_category WHERE tourcat_id='331'	0.00018000602722168
291	SELECT title FROM default_tour_category WHERE tourcat_id='331'	0.00014305114746094
292	SELECT intro FROM default_tour_category WHERE tourcat_id='331'	0.00010800361633301
293	SELECT slug FROM default_tour_category WHERE tourcat_id='331'	0.00025105476379395
294	SELECT tourcat_id FROM default_tour_category WHERE is_trash=0 and parent_id='9' order by order_no ASC	0.00016880035400391
295	SELECT slug FROM default_tour_category WHERE tourcat_id='9'	0.00013589859008789
296	SELECT title FROM default_tour_category WHERE tourcat_id='9'	0.0001990795135498
297	SELECT title FROM default_tour_category WHERE tourcat_id='9'	0.00016188621520996
298	SELECT slug FROM default_tour_category WHERE tourcat_id='328'	0.00013399124145508
299	SELECT title FROM default_tour_category WHERE tourcat_id='328'	0.00021004676818848
300	SELECT image FROM default_tour_category WHERE tourcat_id='328'	0.00017189979553223
301	SELECT title FROM default_tour_category WHERE tourcat_id='328'	0.0001380443572998
302	SELECT slug FROM default_tour_category WHERE tourcat_id='328'	0.00020098686218262
303	SELECT title FROM default_tour_category WHERE tourcat_id='328'	0.00017213821411133
304	SELECT title FROM default_tour_category WHERE tourcat_id='328'	0.00013399124145508
305	SELECT intro FROM default_tour_category WHERE tourcat_id='328'	0.00021219253540039
306	SELECT slug FROM default_tour_category WHERE tourcat_id='328'	0.00019001960754395
307	SELECT tourcat_id FROM default_tour_category WHERE is_trash=0 and parent_id='7' order by order_no ASC	0.00020813941955566
308	SELECT slug FROM default_tour_category WHERE tourcat_id='7'	0.00017499923706055
309	SELECT title FROM default_tour_category WHERE tourcat_id='7'	0.00013899803161621
310	SELECT title FROM default_tour_category WHERE tourcat_id='7'	0.0002131462097168
311	SELECT slug FROM default_tour_category WHERE tourcat_id='329'	0.00018501281738281
312	SELECT title FROM default_tour_category WHERE tourcat_id='329'	0.00016999244689941
313	SELECT image FROM default_tour_category WHERE tourcat_id='329'	0.00013494491577148
314	SELECT title FROM default_tour_category WHERE tourcat_id='329'	0.00020098686218262
315	SELECT slug FROM default_tour_category WHERE tourcat_id='329'	0.00016498565673828
316	SELECT title FROM default_tour_category WHERE tourcat_id='329'	0.00014305114746094
317	SELECT title FROM default_tour_category WHERE tourcat_id='329'	0.0001070499420166
318	SELECT intro FROM default_tour_category WHERE tourcat_id='329'	0.00017213821411133
319	SELECT slug FROM default_tour_category WHERE tourcat_id='329'	0.00014996528625488
320	SELECT tourcat_id FROM default_tour_category WHERE is_trash=0 and parent_id='6' order by order_no ASC	0.00017404556274414
321	SELECT slug FROM default_tour_category WHERE tourcat_id='6'	0.00014090538024902
322	SELECT title FROM default_tour_category WHERE tourcat_id='6'	0.00021910667419434
323	SELECT title FROM default_tour_category WHERE tourcat_id='6'	0.00018095970153809
324	SELECT slug FROM default_tour_category WHERE tourcat_id='330'	0.0001521110534668
325	SELECT title FROM default_tour_category WHERE tourcat_id='330'	0.00011491775512695
326	SELECT image FROM default_tour_category WHERE tourcat_id='330'	0.00017809867858887
327	SELECT title FROM default_tour_category WHERE tourcat_id='330'	0.00014400482177734
328	SELECT slug FROM default_tour_category WHERE tourcat_id='330'	0.00012993812561035
329	SELECT title FROM default_tour_category WHERE tourcat_id='330'	0.00019311904907227
330	SELECT title FROM default_tour_category WHERE tourcat_id='330'	0.00015497207641602
331	SELECT intro FROM default_tour_category WHERE tourcat_id='330'	0.00011897087097168
332	SELECT slug FROM default_tour_category WHERE tourcat_id='330'	0.00019598007202148
333	SELECT tourcat_id FROM default_tour_category WHERE is_trash=0 and parent_id='8' order by order_no ASC	0.00022721290588379
334	SELECT slug FROM default_tour_category WHERE tourcat_id='8'	0.00019502639770508
335	SELECT title FROM default_tour_category WHERE tourcat_id='8'	0.00015902519226074
336	SELECT title FROM default_tour_category WHERE tourcat_id='8'	0.00012111663818359
337	SELECT slug FROM default_tour_category WHERE tourcat_id='332'	0.00019192695617676
338	SELECT title FROM default_tour_category WHERE tourcat_id='332'	0.00015497207641602
339	SELECT image FROM default_tour_category WHERE tourcat_id='332'	0.00013113021850586
340	SELECT title FROM default_tour_category WHERE tourcat_id='332'	0.0001978874206543
341	SELECT slug FROM default_tour_category WHERE tourcat_id='332'	0.00016093254089355
342	SELECT title FROM default_tour_category WHERE tourcat_id='332'	0.00012516975402832
343	SELECT title FROM default_tour_category WHERE tourcat_id='332'	0.00018692016601562
344	SELECT intro FROM default_tour_category WHERE tourcat_id='332'	0.00015783309936523
345	SELECT slug FROM default_tour_category WHERE tourcat_id='332'	0.00014996528625488
346	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00014615058898926
347	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00019192695617676
348	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='5'	0.00015592575073242
349	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='3'	0.00011897087097168
350	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00019598007202148
351	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00015687942504883
352	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='11'	0.00019216537475586
353	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='10'	0.0001521110534668
354	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='9'	0.00011301040649414
355	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='8'	0.00019693374633789
356	SELECT * FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00018095970153809
357	SELECT * FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00016403198242188
358	SELECT * FROM default_cruise_cat WHERE cruise_cat_id='5'	0.00014781951904297
359	SELECT * FROM default_cruise_cat WHERE cruise_cat_id='3'	0.00014805793762207
360	SELECT * FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00013017654418945
361	SELECT * FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00021100044250488
362	SELECT * FROM default_cruise_cat WHERE cruise_cat_id='11'	0.00019288063049316
363	SELECT * FROM default_cruise_cat WHERE cruise_cat_id='10'	0.00017404556274414
364	SELECT * FROM default_cruise_cat WHERE cruise_cat_id='9'	0.00016903877258301
365	SELECT * FROM default_cruise_cat WHERE cruise_cat_id='8'	0.00014996528625488
366	SELECT * FROM default_cruise_property WHERE is_trash=0 and type='TypeBudget' order by order_no desc	0.0003509521484375
367	SELECT distinct title FROM default_cruise_property where cruise_property_id=21 LIMIT 0,1	0.00016617774963379
368	SELECT distinct title FROM default_cruise_property where cruise_property_id=22 LIMIT 0,1	0.0001680850982666
369	SELECT distinct title FROM default_cruise_property where cruise_property_id=23 LIMIT 0,1	0.00015592575073242
370	SELECT cruise_cat_id FROM default_cruise_cat WHERE is_trash=0 and parent_id=0 order by order_no DESC	0.00022697448730469
371	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00013899803161621
372	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00011992454528809
373	SELECT cruise_cat_id FROM default_cruise_cat WHERE is_trash=0 and parent_id='2' order by order_no DESC	0.00022506713867188
374	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='4'	0.0001978874206543
375	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00016093254089355
376	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='5'	0.0001368522644043
377	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='5'	0.00021195411682129
378	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='3'	0.00017905235290527
379	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='3'	0.00014185905456543
380	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00010585784912109
381	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.0001680850982666
382	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00013399124145508
383	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00020718574523926
384	SELECT cruise_cat_id FROM default_cruise_cat WHERE is_trash=0 and parent_id='7' order by order_no DESC	0.00020909309387207
385	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='11'	0.00018692016601562
386	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='11'	0.00014901161193848
387	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='10'	0.00011396408081055
388	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='10'	0.00017595291137695
389	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='9'	0.00015711784362793
390	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='9'	0.00011897087097168
391	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='8'	0.00018405914306641
392	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='8'	0.00014615058898926
393	SELECT blog_id,reg_date FROM default_blog WHERE is_trash=0 and is_online=1 order by order_no desc limit 0,3	0.00042819976806641
394	SELECT title FROM default_blog WHERE blog_id='51'	0.00018501281738281
395	SELECT * FROM default_blog WHERE blog_id='51'	0.00017619132995605
396	SELECT slug FROM default_blogcat WHERE blogcat_id='5'	0.00025105476379395
397	SELECT slug FROM default_blog WHERE blog_id='51'	0.0001218318939209
398	SELECT * FROM default_blog WHERE blog_id='51'	0.00025010108947754
399	SELECT title FROM default_blog WHERE blog_id='50'	0.00012898445129395
400	SELECT * FROM default_blog WHERE blog_id='50'	0.00023794174194336
401	SELECT slug FROM default_blogcat WHERE blogcat_id='6'	0.00021696090698242
402	SELECT slug FROM default_blog WHERE blog_id='50'	0.00017905235290527
403	SELECT * FROM default_blog WHERE blog_id='50'	0.00019502639770508
404	SELECT title FROM default_blog WHERE blog_id='49'	0.00017309188842773
405	SELECT * FROM default_blog WHERE blog_id='49'	0.00017499923706055
406	SELECT slug FROM default_blogcat WHERE blogcat_id='1'	0.0001530647277832
407	SELECT slug FROM default_blog WHERE blog_id='49'	0.00011396408081055
408	SELECT * FROM default_blog WHERE blog_id='49'	0.00022411346435547
409	SELECT title FROM default_cruise WHERE cruise_id='103'	0.00019621849060059
410	SELECT slug FROM default_cruise WHERE cruise_id='103'	0.00017619132995605
411	SELECT slug FROM default_cruise WHERE cruise_id='103'	0.00016212463378906
412	SELECT image FROM default_cruise WHERE cruise_id='103'	0.00014305114746094
413	SELECT * FROM default_cruise_video WHERE is_trash=0 and table_id =103	0.00025486946105957
414	SELECT intro FROM default_cruise WHERE cruise_id='103'	0.00013995170593262
415	SELECT cruise_itinerary_id FROM default_cruise_itinerary WHERE is_trash=0 and cruise_id = '103' order by order_no desc	0.00064682960510254
416	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='128'	0.00017189979553223
417	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='129'	0.00019693374633789
418	SELECT * FROM default_cruise WHERE cruise_id='103'	0.00027608871459961
419	SELECT * FROM default_cruise WHERE cruise_id='103'	0.00026392936706543
420	SELECT title FROM default_cruise WHERE cruise_id='102'	0.00017905235290527
421	SELECT slug FROM default_cruise WHERE cruise_id='102'	0.00014996528625488
422	SELECT slug FROM default_cruise WHERE cruise_id='102'	0.00012087821960449
423	SELECT image FROM default_cruise WHERE cruise_id='102'	0.00019192695617676
424	SELECT * FROM default_cruise_video WHERE is_trash=0 and table_id =102	0.00021195411682129
425	SELECT intro FROM default_cruise WHERE cruise_id='102'	0.00019001960754395
426	SELECT cruise_itinerary_id FROM default_cruise_itinerary WHERE is_trash=0 and cruise_id = '102' order by order_no desc	0.00040984153747559
427	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='126'	0.00023698806762695
428	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='127'	0.00029611587524414
429	SELECT * FROM default_cruise WHERE cruise_id='102'	0.00028896331787109
430	SELECT * FROM default_cruise WHERE cruise_id='102'	0.00028085708618164
431	SELECT title FROM default_cruise WHERE cruise_id='101'	0.00016903877258301
432	SELECT slug FROM default_cruise WHERE cruise_id='101'	0.00015401840209961
433	SELECT slug FROM default_cruise WHERE cruise_id='101'	0.00012493133544922
434	SELECT image FROM default_cruise WHERE cruise_id='101'	0.00019598007202148
435	SELECT * FROM default_cruise_video WHERE is_trash=0 and table_id =101	0.00019598007202148
436	SELECT intro FROM default_cruise WHERE cruise_id='101'	0.00017189979553223
437	SELECT cruise_itinerary_id FROM default_cruise_itinerary WHERE is_trash=0 and cruise_id = '101' order by order_no desc	0.0003969669342041
438	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='124'	0.00021600723266602
439	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='125'	0.00024223327636719
440	SELECT * FROM default_cruise WHERE cruise_id='101'	0.00022292137145996
441	SELECT * FROM default_cruise WHERE cruise_id='101'	0.00030994415283203
442	SELECT title FROM default_cruise WHERE cruise_id='100'	0.0001978874206543
443	SELECT slug FROM default_cruise WHERE cruise_id='100'	0.00016903877258301
444	SELECT slug FROM default_cruise WHERE cruise_id='100'	0.00013995170593262
445	SELECT image FROM default_cruise WHERE cruise_id='100'	0.00011277198791504
446	SELECT * FROM default_cruise_video WHERE is_trash=0 and table_id =100	0.00023603439331055
447	SELECT intro FROM default_cruise WHERE cruise_id='100'	0.00021195411682129
448	SELECT cruise_itinerary_id FROM default_cruise_itinerary WHERE is_trash=0 and cruise_id = '100' order by order_no desc	0.00042200088500977
449	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='122'	0.00024104118347168
450	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='123'	0.00018501281738281
451	SELECT * FROM default_cruise WHERE cruise_id='100'	0.00027585029602051
452	SELECT * FROM default_cruise WHERE cruise_id='100'	0.00028800964355469
453	SELECT title FROM default_cruise WHERE cruise_id='99'	0.00020408630371094
454	SELECT slug FROM default_cruise WHERE cruise_id='99'	0.00017595291137695
455	SELECT slug FROM default_cruise WHERE cruise_id='99'	0.00014591217041016
456	SELECT image FROM default_cruise WHERE cruise_id='99'	0.00011682510375977
457	SELECT * FROM default_cruise_video WHERE is_trash=0 and table_id =99	0.00021815299987793
458	SELECT intro FROM default_cruise WHERE cruise_id='99'	0.00019192695617676
459	SELECT cruise_itinerary_id FROM default_cruise_itinerary WHERE is_trash=0 and cruise_id = '99' order by order_no desc	0.00042104721069336
460	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='118'	0.00024294853210449
461	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='119'	0.00017499923706055
462	SELECT * FROM default_cruise WHERE cruise_id='99'	0.00025486946105957
463	SELECT * FROM default_cruise WHERE cruise_id='99'	0.00020503997802734
464	SELECT title FROM default_cruise WHERE cruise_id='98'	0.00019407272338867
465	SELECT slug FROM default_cruise WHERE cruise_id='98'	0.00016498565673828
466	SELECT slug FROM default_cruise WHERE cruise_id='98'	0.00013494491577148
467	SELECT image FROM default_cruise WHERE cruise_id='98'	0.00022101402282715
468	SELECT * FROM default_cruise_video WHERE is_trash=0 and table_id =98	0.00022792816162109
469	SELECT intro FROM default_cruise WHERE cruise_id='98'	0.00020384788513184
470	SELECT cruise_itinerary_id FROM default_cruise_itinerary WHERE is_trash=0 and cruise_id = '98' order by order_no desc	0.00041389465332031
471	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='120'	0.00024604797363281
472	SELECT * FROM default_cruise_itinerary WHERE cruise_itinerary_id='121'	0.00017499923706055
473	SELECT * FROM default_cruise WHERE cruise_id='98'	0.00025296211242676
474	SELECT * FROM default_cruise WHERE cruise_id='98'	0.00024890899658203
475	SELECT testimonial_id,reg_date FROM default_testimonial WHERE is_trash=0 and image<>'' order by reg_date desc limit 0,3	0.00030994415283203
476	SELECT title FROM default_testimonial WHERE testimonial_id='41'	0.00018501281738281
477	SELECT slug FROM default_testimonial WHERE testimonial_id='41'	0.00015115737915039
478	SELECT image FROM default_testimonial WHERE testimonial_id='41'	0.00011610984802246
479	SELECT intro FROM default_testimonial WHERE testimonial_id='41'	0.0001828670501709
480	SELECT name FROM default_testimonial WHERE testimonial_id='41'	0.00016021728515625
481	SELECT country_id FROM default_testimonial WHERE testimonial_id='41'	0.00016593933105469
482	SELECT title FROM _country WHERE country_id='14'	0.00021719932556152
483	SELECT title FROM default_testimonial WHERE testimonial_id='40'	0.00018596649169922
484	SELECT slug FROM default_testimonial WHERE testimonial_id='40'	0.00016498565673828
485	SELECT image FROM default_testimonial WHERE testimonial_id='40'	0.00012898445129395
486	SELECT intro FROM default_testimonial WHERE testimonial_id='40'	0.00019598007202148
487	SELECT name FROM default_testimonial WHERE testimonial_id='40'	0.00016999244689941
488	SELECT country_id FROM default_testimonial WHERE testimonial_id='40'	0.00013995170593262
489	SELECT title FROM _country WHERE country_id='15'	0.00020384788513184
490	SELECT title FROM default_testimonial WHERE testimonial_id='39'	0.00019097328186035
491	SELECT slug FROM default_testimonial WHERE testimonial_id='39'	0.00015497207641602
492	SELECT image FROM default_testimonial WHERE testimonial_id='39'	0.00011897087097168
493	SELECT intro FROM default_testimonial WHERE testimonial_id='39'	0.00018501281738281
494	SELECT name FROM default_testimonial WHERE testimonial_id='39'	0.00015687942504883
495	SELECT country_id FROM default_testimonial WHERE testimonial_id='39'	0.00011920928955078
496	SELECT title FROM _country WHERE country_id='12'	0.00020098686218262
497	SELECT title FROM default_tour_category WHERE tourcat_id='333'	0.00013113021850586
498	SELECT slug FROM default_tour_category WHERE tourcat_id='333'	0.00020289421081543
499	SELECT title FROM default_tour_category WHERE tourcat_id='2'	0.00016999244689941
500	SELECT slug FROM default_tour_category WHERE tourcat_id='2'	0.00013303756713867
501	SELECT title FROM default_tour_category WHERE tourcat_id='314'	0.00020790100097656
502	SELECT slug FROM default_tour_category WHERE tourcat_id='314'	0.00018692016601562
503	SELECT title FROM default_tour_category WHERE tourcat_id='312'	0.00015616416931152
504	SELECT slug FROM default_tour_category WHERE tourcat_id='312'	0.00012016296386719
505	SELECT title FROM default_tour_category WHERE tourcat_id='279'	0.00018787384033203
506	SELECT slug FROM default_tour_category WHERE tourcat_id='279'	0.0001518726348877
507	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00017714500427246
508	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00014114379882812
509	SELECT title FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00010800361633301
510	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00016999244689941