Categories
(default) 36 queries took 306 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 1110
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 1011169
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 1111
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) 000
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 10043
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'110
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 11180
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' AND `Tour`.`tourstyle` = 'Trekking'49495
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, 59, 60, 63, 66, 67, 69, 70, 71, 73, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 114, 115, 116, 117, 118, 119, 120, 121, 122, 124, 130, 133, 134, 144, 145, 150, 151) 29290
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, 59, 60, 63, 66, 67, 69, 70, 71, 73, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 114, 115, 116, 117, 118, 119, 120, 121, 122, 124, 130, 133, 134, 144, 145, 150, 151) 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, 59, 60, 63, 66, 67, 69, 70, 71, 73, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 114, 115, 116, 117, 118, 119, 120, 121, 122, 124, 130, 133, 134, 144, 145, 150, 151) 000
33SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`lattitude`, `Tour`.`longitude` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`status` = 'active'84840
34SELECT `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, 66, 67, 68, 69, 70, 71, 72, 73, 74, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 102, 103, 104, 105, 106, 107, 109, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 130, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152) 45450
35SELECT `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, 66, 67, 68, 69, 70, 71, 72, 73, 74, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 102, 103, 104, 105, 106, 107, 109, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 130, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152) 220
36SELECT `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, 66, 67, 68, 69, 70, 71, 72, 73, 74, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 102, 103, 104, 105, 106, 107, 109, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 130, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152) 000