Loading...10%
Tours for you
If this is right trip for you?

For any queries please send email on info@trekasur.com and we will trek back to you with all details within 48 hours!

400

Pokhara Royal Trek 10 Day

Prokharan Royal Trek-10days-test

Known as the "Royal Trek" because this route was traversed by Prince Charles of England and luminaries like Mick Jagger.... read more

₹33915
Book Now
2013-10-05 15:05:24
33915
4
400

Nepal Tour 12days

Extragavant adventure

In Pokhara, the delightful scenic lakeside town with the spectacular backdrop of Machhapuchhre rising behind it all crea... read more

₹85999
Book Now
2013-10-20 18:22:58
85999
4
400

Cho Oyu Expedition 45 Days

Turquoise God

The sixth highest peak of the world (8201m/26906ft) Cho Oyu stands for' Turquoise God’ which means the turquoise color... read more

₹1169000
Book Now
2014-01-29 09:16:14
1169000
4
400

Everest Base Camp Luxury Trek 15days

World's tallest mountain

(3 Night Kathmandu 11 Night Tea House) Everest Base Camp Trek, which starts from Lukla, is delightful and is full of u... read more

₹80498
Book Now
2014-03-16 11:39:00
80498
4
400

Goecha La Trek 16days

Unforgettable trail

Goechala is situated in the state of Sikkim which is a perfect destination for adventure lovers. Trekking in Sikkim is e... read more

₹25000
Book Now
2014-03-17 06:53:50
25000
4
400

Everest View Trek 8days

360 deg view of world's tallest mountain peaks

360 deg view of world's tallest mountain peaks Everest View Trek package provides a short opportunity to hike in Evere... read more

₹57908
Book Now
2014-06-04 11:01:30
57908
4
<<1 2 3 4 5 6 7 8 9
(default) 33 queries took 4514 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `User`.`record_id`, `User`.`id`, `User`.`username`, `User`.`profile_picture`, `User`.`slug`, `User`.`password`, `User`.`password_token`, `User`.`email`, `User`.`country_code`, `User`.`phone`, `User`.`email_verified`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`tos`, `User`.`active`, `User`.`last_login`, `User`.`last_action`, `User`.`is_admin`, `User`.`role`, `User`.`created`, `User`.`modified` FROM `trekasur_db1`.`users` AS `User` WHERE `User`.`role` = 'admin' LIMIT 111566
2SELECT `UserDetail`.`id`, `UserDetail`.`user_id`, `UserDetail`.`position`, `UserDetail`.`field`, `UserDetail`.`value`, `UserDetail`.`input`, `UserDetail`.`data_type`, `UserDetail`.`label`, `UserDetail`.`created`, `UserDetail`.`modified` FROM `trekasur_db1`.`user_details` AS `UserDetail` WHERE `UserDetail`.`user_id` = ('51b4296d-03c8-4e3b-8b43-3416ae2593b8') 94941
3SELECT `UserDetail`.`field`, `UserDetail`.`value` FROM `trekasur_db1`.`user_details` AS `UserDetail` WHERE `UserDetail`.`user_id` = '51b4296d-03c8-4e3b-8b43-3416ae2593b8' AND `UserDetail`.`field` LIKE 'User.%'94941
4SELECT `TourStyle`.`id`, `TourStyle`.`stylename` FROM `trekasur_db1`.`tour_styles` AS `TourStyle` WHERE 1 = 111110
5SELECT `TourType`.`id`, `TourType`.`typename` FROM `trekasur_db1`.`tour_types` AS `TourType` WHERE 1 = 1440
6SELECT `TourCountry`.`id`, `TourCountry`.`countryname` FROM `trekasur_db1`.`tour_countries` AS `TourCountry` WHERE 1 = 1440
7SELECT `TourActivity`.`id`, `TourActivity`.`activityname` FROM `trekasur_db1`.`tour_activities` AS `TourActivity` WHERE 1 = 112120
8SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`name`, `Review`.`email`, `Review`.`mobile`, `Review`.`city`, `Review`.`country`, `Review`.`subject`, `Review`.`message`, `Review`.`scrapped_message`, `Review`.`type`, `Review`.`is_testimonial`, `Review`.`priority`, `Review`.`status`, `Review`.`created`, `Review`.`modified` FROM `trekasur_db1`.`reviews` AS `Review` WHERE ((`Review`.`is_testimonial` = 1) AND (`Review`.`status` = 1)) ORDER BY `Review`.`priority` asc LIMIT 10111
9SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Trekking' AND `Tour`.`status` = 'active' LIMIT 111974
10SELECT `TourSchedule`.`id`, `TourSchedule`.`tour_id`, `TourSchedule`.`start_date`, `TourSchedule`.`end_date`, `TourSchedule`.`status`, `TourSchedule`.`created`, `TourSchedule`.`modified` FROM `trekasur_db1`.`tour_schedules` AS `TourSchedule` WHERE `TourSchedule`.`tour_id` = (5) 001
11SELECT `UserActivity`.`id`, `UserActivity`.`tour_id`, `UserActivity`.`activity_value`, `UserActivity`.`user_id`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `trekasur_db1`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`tour_id` = (5) 220
12SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`is_spam`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `trekasur_db1`.`comments` AS `Comment` WHERE `Comment`.`foreign_key` = (5) 000
13SELECT COUNT(*) AS `count` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Trekking' AND `Tour`.`status` = 'active'112
14SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Expeditions' AND `Tour`.`status` = 'active' LIMIT 1111
15SELECT `TourSchedule`.`id`, `TourSchedule`.`tour_id`, `TourSchedule`.`start_date`, `TourSchedule`.`end_date`, `TourSchedule`.`status`, `TourSchedule`.`created`, `TourSchedule`.`modified` FROM `trekasur_db1`.`tour_schedules` AS `TourSchedule` WHERE `TourSchedule`.`tour_id` = (57) 000
16SELECT `UserActivity`.`id`, `UserActivity`.`tour_id`, `UserActivity`.`activity_value`, `UserActivity`.`user_id`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `trekasur_db1`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`tour_id` = (57) 000
17SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`is_spam`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `trekasur_db1`.`comments` AS `Comment` WHERE `Comment`.`foreign_key` = (57) 000
18SELECT COUNT(*) AS `count` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Expeditions' AND `Tour`.`status` = 'active'110
19SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Climbing' AND `Tour`.`status` = 'active' LIMIT 1001988
20SELECT COUNT(*) AS `count` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Climbing' AND `Tour`.`status` = 'active'110
21SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Trips' AND `Tour`.`status` = 'active' LIMIT 1002
22SELECT COUNT(*) AS `count` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Trips' AND `Tour`.`status` = 'active'111
23SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Adventure for Women' AND `Tour`.`status` = 'active' LIMIT 1111
24SELECT `TourSchedule`.`id`, `TourSchedule`.`tour_id`, `TourSchedule`.`start_date`, `TourSchedule`.`end_date`, `TourSchedule`.`status`, `TourSchedule`.`created`, `TourSchedule`.`modified` FROM `trekasur_db1`.`tour_schedules` AS `TourSchedule` WHERE `TourSchedule`.`tour_id` = (74) 770
25SELECT `UserActivity`.`id`, `UserActivity`.`tour_id`, `UserActivity`.`activity_value`, `UserActivity`.`user_id`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `trekasur_db1`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`tour_id` = (74) 000
26SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`is_spam`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `trekasur_db1`.`comments` AS `Comment` WHERE `Comment`.`foreign_key` = (74) 000
27SELECT COUNT(*) AS `count` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Adventure for Women' AND `Tour`.`status` = 'active'110
28SELECT `Seo`.`meta` FROM `trekasur_db1`.`seos` AS `Seo` WHERE `Seo`.`id` = 'trekasur' LIMIT 111974
29SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`status` = 'active' LIMIT 6661
30SELECT `TourSchedule`.`id`, `TourSchedule`.`tour_id`, `TourSchedule`.`start_date`, `TourSchedule`.`end_date`, `TourSchedule`.`status`, `TourSchedule`.`created`, `TourSchedule`.`modified` FROM `trekasur_db1`.`tour_schedules` AS `TourSchedule` WHERE `TourSchedule`.`tour_id` IN (5, 46, 57, 59, 60, 63) 990
31SELECT `UserActivity`.`id`, `UserActivity`.`tour_id`, `UserActivity`.`activity_value`, `UserActivity`.`user_id`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `trekasur_db1`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`tour_id` IN (5, 46, 57, 59, 60, 63) 220
32SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`is_spam`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `trekasur_db1`.`comments` AS `Comment` WHERE `Comment`.`foreign_key` IN (5, 46, 57, 59, 60, 63) 000
33SELECT COUNT(*) AS `count` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`status` = 'active'110