Search

app/webroot/index.php (line 93) 
0.798
(default) 49 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `scoops`991
2DESCRIBE `accounts`19191
3DESCRIBE `trip_destinations`15150
4DESCRIBE `trips`12120
5DESCRIBE `featured_trips`550
6DESCRIBE `trip_members`660
7DESCRIBE `trip_followers`440
8DESCRIBE `trip_invites`990
9DESCRIBE `trip_join_requests`550
10DESCRIBE `user_locations`990
11DESCRIBE `friends`770
12DESCRIBE `friend_invites`990
13DESCRIBE `wish_lists`10100
14DESCRIBE `friend_groups`440
15DESCRIBE `friend_group_links`440
16DESCRIBE `blogs`770
17DESCRIBE `comments`770
18DESCRIBE `ratings`770
19DESCRIBE `friend_tags`770
20DESCRIBE `photo_albums`552
21DESCRIBE `photos`770
22DESCRIBE `videos`990
23DESCRIBE `messages`880
24SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'e72e664cd5eada79310a4c2acbf2c224'110
25SELECT `Trip`.`id` FROM `trips` AS `Trip` WHERE `Trip`.`privacy_level` = 'public' 53530
26SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 101 GROUP BY `Account`.`id` LIMIT 1110
27SELECT `Trip`.`id` FROM `trips` AS `Trip` WHERE `Trip`.`account_id` = 101 AND `Trip`.`privacy_level` = 'public' 330
28SELECT COUNT(*) AS `count` FROM `trips` AS `Trip` LEFT JOIN `accounts` AS `Account` ON (`Trip`.`account_id` = `Account`.`id`) LEFT JOIN `featured_trips` AS `FeaturedTrip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE `Trip`.`id` IN (85, 101, 103) AND `Trip`.`account_id` = 101 110
29SELECT COUNT(*) AS `count` FROM `blogs` AS `Blog` LEFT JOIN `scoops` AS `Scoop` ON (`Blog`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`trip_id` IN (85, 101, 103) AND `Scoop`.`account_id` = 101 110
30SELECT COUNT(*) AS `count` FROM `photo_albums` AS `PhotoAlbum` LEFT JOIN `scoops` AS `Scoop` ON (`PhotoAlbum`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`trip_id` IN (85, 101, 103) AND `Scoop`.`account_id` = 101 110
31SELECT COUNT(*) AS `count` FROM `videos` AS `Video` LEFT JOIN `scoops` AS `Scoop` ON (`Scoop`.`foreign_id` = `Video`.`id` AND `Scoop`.`class` = 'Video') WHERE `Scoop`.`trip_id` IN (85, 101, 103) AND `Scoop`.`account_id` = 101 110
32SELECT COUNT(*) AS `count` FROM `photo_albums` AS `PhotoAlbum` LEFT JOIN `scoops` AS `Scoop` ON (`PhotoAlbum`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`trip_id` IN (85, 101, 103) 110
33SELECT `PhotoAlbum`.`id`, `PhotoAlbum`.`scoop_id`, `PhotoAlbum`.`title`, `PhotoAlbum`.`description`, `PhotoAlbum`.`cover_photo_id`, `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `photo_albums` AS `PhotoAlbum` LEFT JOIN `scoops` AS `Scoop` ON (`PhotoAlbum`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`trip_id` IN (85, 101, 103) LIMIT 8330
34SELECT `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `scoops` AS `Scoop` WHERE `Scoop`.`id` = 235 110
35SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 101 AND `Account`.`status` <> 0 110
36SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 85 110
37SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`id` = 451 110
38SELECT `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `scoops` AS `Scoop` WHERE `Scoop`.`id` = 236 110
39SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 101 AND `Account`.`status` <> 0 110
40SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 85 110
41SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`id` = 455 110
42SELECT `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `scoops` AS `Scoop` WHERE `Scoop`.`id` = 234 110
43SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified` FROM `accounts` AS `Account` WHERE `Account`.`id` = 101 AND `Account`.`status` <> 0 110
44SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` = 101 110
45SELECT `TripDestination`.`id`, `TripDestination`.`trip_id`, `TripDestination`.`start_date`, `TripDestination`.`end_date`, `TripDestination`.`name`, `TripDestination`.`country`, `TripDestination`.`country_code`, `TripDestination`.`geoname_id`, `TripDestination`.`longitude`, `TripDestination`.`latitude`, `TripDestination`.`parent_id`, `TripDestination`.`lft`, `TripDestination`.`rgt`, `TripDestination`.`created`, `TripDestination`.`nickname` FROM `trip_destinations` AS `TripDestination` WHERE `TripDestination`.`id` = 560 110
46SELECT `Photo`.`id`, `Photo`.`photo_album_id`, `Photo`.`scoop_id`, `Photo`.`title`, `Photo`.`filename`, `Photo`.`views`, `Photo`.`rating` FROM `photos` AS `Photo` WHERE `Photo`.`photo_album_id` IN (94, 95, 93) 56560
47SELECT COUNT(*) AS `count` FROM `messages` AS `Message` LEFT JOIN `accounts` AS `Author` ON (`Message`.`author_id` = `Author`.`id` AND `Author`.`status` <> 0) LEFT JOIN `accounts` AS `Recipient` ON (`Message`.`recipient_id` = `Recipient`.`id`) WHERE `Message`.`recipient_id` IS NULL AND `Message`.`viewed` = 0 110
48SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'e72e664cd5eada79310a4c2acbf2c224'110
49UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1337521533;s:4:\"rand\";i:293028519;s:7:\"timeout\";i:10;}Message|a:0:{}Auth|a:1:{s:7:\"Account\";N;}', `expires` = 1337521534 WHERE `id` = 'e72e664cd5eada79310a4c2acbf2c224'10