Profile » Kris

You must be logged in to manage your wish list.
 

Kris

in Geraldine, New Zealand

  
 

male

24

New Zealand

2

  
Add Kris Johnstone as a Friend Send Kris Johnstone a Message
Kris's Trips

Kris in Europe 2007

7th Mar 2007 - 22nd Dec 2007
Kris in Europe 2007See All Trips
  This trip currently has no scoops.  
Blogs by Kris
  Kris hasn't written any blogs yet.  
Photographs by Kris
  Kris hasn't uploaded any photos yet.  
Videos by Kris
  Kris hasn't uploaded any videos yet.  
app/webroot/index.php (line 93) 
0.8762
(default) 62 queries took 8 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `accounts`19191
2DESCRIBE `trip_destinations`15150
3DESCRIBE `trips`12120
4DESCRIBE `featured_trips`550
5DESCRIBE `scoops`990
6DESCRIBE `blogs`770
7DESCRIBE `comments`770
8DESCRIBE `ratings`770
9DESCRIBE `friend_tags`770
10DESCRIBE `photo_albums`550
11DESCRIBE `photos`770
12DESCRIBE `videos`990
13DESCRIBE `trip_members`660
14DESCRIBE `trip_followers`440
15DESCRIBE `trip_invites`990
16DESCRIBE `trip_join_requests`550
17DESCRIBE `user_locations`990
18DESCRIBE `friends`770
19DESCRIBE `friend_invites`990
20DESCRIBE `wish_lists`10100
21DESCRIBE `friend_groups`440
22DESCRIBE `friend_group_links`440
23DESCRIBE `messages`880
24SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '80d95d32d9de55050ccc1655fbcca0de'110
25SELECT `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`, `TripLocation`.`id`, `TripLocation`.`trip_id`, `TripLocation`.`start_date`, `TripLocation`.`end_date`, `TripLocation`.`name`, `TripLocation`.`country`, `TripLocation`.`country_code`, `TripLocation`.`geoname_id`, `TripLocation`.`longitude`, `TripLocation`.`latitude`, `UserLocation`.`id`, `UserLocation`.`account_id`, `UserLocation`.`name`, `UserLocation`.`country`, `UserLocation`.`country_code`, `UserLocation`.`geoname_id`, `UserLocation`.`longitude`, `UserLocation`.`latitude`, `UserLocation`.`created` FROM `accounts` AS `Account` LEFT JOIN `trip_destinations` AS `TripLocation` ON (`TripLocation`.`start_date` <= NOW() AND `TripLocation`.`end_date` >= NOW() AND `TripLocation`.`trip_id` IN (SELECT `TM`.`trip_id` FROM trip_members AS TM WHERE `TM`.`account_id` = `Account`.`id`)) LEFT JOIN `user_locations` AS `UserLocation` ON (`UserLocation`.`account_id` = `Account`.`id`) WHERE `Account`.`id` = 120 GROUP BY `Account`.`id` LIMIT 1111
26SELECT `Friend`.`id`, `Friend`.`account_id`, `Friend`.`friend_id`, `Friend`.`approved`, `Friend`.`id_hash`, `Friend`.`created`, `Friend`.`modified`, `Friend1`.`id`, `Friend1`.`forename`, `Friend1`.`surname`, `Friend1`.`nickname`, `Friend1`.`email`, `Friend1`.`password`, `Friend1`.`dob`, `Friend1`.`gender`, `Friend1`.`privacy_level`, `Friend1`.`nationality`, `Friend1`.`photo_filename`, `Friend1`.`fb_uid`, `Friend1`.`use_fb`, `Friend1`.`email_hash`, `Friend1`.`permission_group_id`, `Friend1`.`status`, `Friend1`.`disabled`, `Friend1`.`created`, `Friend1`.`modified`, `Friend2`.`id`, `Friend2`.`forename`, `Friend2`.`surname`, `Friend2`.`nickname`, `Friend2`.`email`, `Friend2`.`password`, `Friend2`.`dob`, `Friend2`.`gender`, `Friend2`.`privacy_level`, `Friend2`.`nationality`, `Friend2`.`photo_filename`, `Friend2`.`fb_uid`, `Friend2`.`use_fb`, `Friend2`.`email_hash`, `Friend2`.`permission_group_id`, `Friend2`.`status`, `Friend2`.`disabled`, `Friend2`.`created`, `Friend2`.`modified` FROM `friends` AS `Friend` LEFT JOIN `accounts` AS `Friend1` ON (`Friend`.`account_id` = `Friend1`.`id`) LEFT JOIN `accounts` AS `Friend2` ON (`Friend`.`friend_id` = `Friend2`.`id`) WHERE ((((`Friend`.`account_id` IS NULL) AND (`Friend`.`friend_id` = 120))) OR (((`Friend`.`account_id` = 120) AND (`Friend`.`friend_id` IS NULL)))) AND `Friend`.`approved` = 1 LIMIT 1000
27SELECT `Friend`.`id`, `Friend`.`account_id`, `Friend`.`friend_id`, `Friend`.`approved`, `Friend`.`id_hash`, `Friend`.`created`, `Friend`.`modified`, `Friend1`.`id`, `Friend1`.`forename`, `Friend1`.`surname`, `Friend1`.`nickname`, `Friend1`.`email`, `Friend1`.`password`, `Friend1`.`dob`, `Friend1`.`gender`, `Friend1`.`privacy_level`, `Friend1`.`nationality`, `Friend1`.`photo_filename`, `Friend1`.`fb_uid`, `Friend1`.`use_fb`, `Friend1`.`email_hash`, `Friend1`.`permission_group_id`, `Friend1`.`status`, `Friend1`.`disabled`, `Friend1`.`created`, `Friend1`.`modified`, `Friend2`.`id`, `Friend2`.`forename`, `Friend2`.`surname`, `Friend2`.`nickname`, `Friend2`.`email`, `Friend2`.`password`, `Friend2`.`dob`, `Friend2`.`gender`, `Friend2`.`privacy_level`, `Friend2`.`nationality`, `Friend2`.`photo_filename`, `Friend2`.`fb_uid`, `Friend2`.`use_fb`, `Friend2`.`email_hash`, `Friend2`.`permission_group_id`, `Friend2`.`status`, `Friend2`.`disabled`, `Friend2`.`created`, `Friend2`.`modified` FROM `friends` AS `Friend` LEFT JOIN `accounts` AS `Friend1` ON (`Friend`.`account_id` = `Friend1`.`id`) LEFT JOIN `accounts` AS `Friend2` ON (`Friend`.`friend_id` = `Friend2`.`id`) WHERE ((((`Friend`.`account_id` IS NULL) AND (`Friend`.`friend_id` = 120))) OR (((`Friend`.`account_id` = 120) AND (`Friend`.`friend_id` IS NULL)))) AND `Friend`.`approved` = 0 LIMIT 1000
28 SELECT `Account`.`id` FROM `accounts` AS `Account` LEFT JOIN `friends` AS `Friend` ON (`Account`.`id` = `Friend`.`account_id` OR `Account`.`id` = `Friend`.`friend_id`) WHERE ((`Friend`.`account_id` = 120 OR `Friend`.`friend_id` = 120) AND (`Account`.`id` <> 120) AND (`Friend`.`approved` = 1));220
29SELECT `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`, `TripLocation`.`id`, `TripLocation`.`trip_id`, `TripLocation`.`start_date`, `TripLocation`.`end_date`, `TripLocation`.`name`, `TripLocation`.`country`, `TripLocation`.`country_code`, `TripLocation`.`geoname_id`, `TripLocation`.`longitude`, `TripLocation`.`latitude`, `UserLocation`.`id`, `UserLocation`.`account_id`, `UserLocation`.`name`, `UserLocation`.`country`, `UserLocation`.`country_code`, `UserLocation`.`geoname_id`, `UserLocation`.`longitude`, `UserLocation`.`latitude`, `UserLocation`.`created` FROM `accounts` AS `Account` LEFT JOIN `trip_destinations` AS `TripLocation` ON (`TripLocation`.`start_date` <= NOW() AND `TripLocation`.`end_date` >= NOW() AND `TripLocation`.`trip_id` IN (SELECT `TM`.`trip_id` FROM trip_members AS TM WHERE `TM`.`account_id` = `Account`.`id`)) LEFT JOIN `user_locations` AS `UserLocation` ON (`UserLocation`.`account_id` = `Account`.`id`) WHERE `Account`.`id` IN (6, 41) GROUP BY `Account`.`id` ORDER BY rand() ASC 221
30SELECT `FriendA`.`id`, `FriendA`.`account_id`, `FriendA`.`friend_id`, `FriendA`.`approved`, `FriendA`.`id_hash`, `FriendA`.`created`, `FriendA`.`modified` FROM `friends` AS `FriendA` WHERE `FriendA`.`approved` = 1 AND `FriendA`.`account_id` IN (41, 6) 990
31SELECT `FriendB`.`id`, `FriendB`.`account_id`, `FriendB`.`friend_id`, `FriendB`.`approved`, `FriendB`.`id_hash`, `FriendB`.`created`, `FriendB`.`modified` FROM `friends` AS `FriendB` WHERE `FriendB`.`approved` = 1 AND `FriendB`.`friend_id` IN (41, 6) 13130
32SELECT `FriendInvite`.`id`, `FriendInvite`.`account_id`, `FriendInvite`.`friend_id`, `FriendInvite`.`email`, `FriendInvite`.`approved`, `FriendInvite`.`id_hash`, `FriendInvite`.`fb_user_id_hash`, `FriendInvite`.`created`, `FriendInvite`.`modified` FROM `friend_invites` AS `FriendInvite` WHERE `FriendInvite`.`account_id` IN (41, 6) 770
33SELECT `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`.`account_id` IN (41, 6) 65650
34SELECT `WishList`.`id`, `WishList`.`account_id`, `WishList`.`name`, `WishList`.`country`, `WishList`.`country_code`, `WishList`.`geoname_id`, `WishList`.`longitude`, `WishList`.`latitude`, `WishList`.`description`, `WishList`.`created` FROM `wish_lists` AS `WishList` WHERE `WishList`.`account_id` IN (41, 6) 10100
35SELECT `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`.`account_id` IN (41, 6) 12120
36SELECT `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` IN (41, 6) 14140
37SELECT `FriendGroup`.`id`, `FriendGroup`.`name`, `FriendGroup`.`account_id`, `FriendGroup`.`created` FROM `friend_groups` AS `FriendGroup` WHERE `FriendGroup`.`account_id` IN (41, 6) 220
38SELECT `FriendGroupLink`.`id`, `FriendGroupLink`.`account_id`, `FriendGroupLink`.`friend_group_id`, `FriendGroupLink`.`created` FROM `friend_group_links` AS `FriendGroupLink` WHERE `FriendGroupLink`.`account_id` IN (41, 6) 000
39SELECT `WishList`.`id`, `WishList`.`account_id`, `WishList`.`name`, `WishList`.`country`, `WishList`.`country_code`, `WishList`.`geoname_id`, `WishList`.`longitude`, `WishList`.`latitude`, `WishList`.`description`, `WishList`.`created` FROM `wish_lists` AS `WishList` WHERE `WishList`.`account_id` = 120 000
40SELECT `TripMember`.`id`, `TripMember`.`trip_id` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = 120 AND `TripMember`.`status` = 0 110
41SELECT `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` = (97) AND ((`Trip`.`start_date` <= NOW()) AND (`Trip`.`end_date` >= NOW())) ORDER BY `Trip`.`created` DESC LIMIT 1000
42SELECT `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` = (97) ORDER BY `Trip`.`start_date` DESC LIMIT 1110
43SELECT `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`.`trip_id` = (97) ORDER BY `TripDestination`.`lft` ASC 220
44SELECT `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`.`trip_destination_id` IN (521, 522) 000
45SELECT `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`.`trip_id` = (97) ORDER BY `Scoop`.`created` DESC 000
46SELECT `Trip`.`id`, `Trip`.`title` FROM `trips` AS `Trip` WHERE `Trip`.`id` = (97) ORDER BY `Trip`.`start_date` DESC 110
47SELECT `TripMember`.`id`, `TripMember`.`trip_id` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = 120 AND `TripMember`.`status` = 0 110
48SELECT `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`, `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`, `FeaturedTrip`.`id`, `FeaturedTrip`.`account_id`, `FeaturedTrip`.`trip_id`, `FeaturedTrip`.`created`, `FeaturedTrip`.`modified` 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` = (97) ORDER BY `Trip`.`start_date` DESC 110
49SELECT `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`.`trip_id` = (97) ORDER BY `TripDestination`.`lft` ASC 220
50SELECT `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`.`trip_id` = (97) ORDER BY `Scoop`.`created` DESC 000
51SELECT `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`status` = 0 AND `TripMember`.`trip_id` = (97) 110
52SELECT `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `trip_followers` AS `TripFollower` WHERE `TripFollower`.`trip_id` = (97) 000
53SELECT `TripInvite`.`id`, `TripInvite`.`account_id`, `TripInvite`.`trip_id`, `TripInvite`.`recipient_id`, `TripInvite`.`email`, `TripInvite`.`approved`, `TripInvite`.`id_hash`, `TripInvite`.`fb_user_id_hash`, `TripInvite`.`created` FROM `trip_invites` AS `TripInvite` WHERE `TripInvite`.`trip_id` = (97) 000
54SELECT `TripJoinRequest`.`id`, `TripJoinRequest`.`account_id`, `TripJoinRequest`.`trip_id`, `TripJoinRequest`.`approved`, `TripJoinRequest`.`created` FROM `trip_join_requests` AS `TripJoinRequest` WHERE `TripJoinRequest`.`trip_id` = (97) 000
55SELECT `TripMembers`.`id`, `TripMembers`.`forename`, `TripMembers`.`surname`, `TripMembers`.`nickname`, `TripMembers`.`email`, `TripMembers`.`password`, `TripMembers`.`dob`, `TripMembers`.`gender`, `TripMembers`.`privacy_level`, `TripMembers`.`nationality`, `TripMembers`.`photo_filename`, `TripMembers`.`fb_uid`, `TripMembers`.`use_fb`, `TripMembers`.`email_hash`, `TripMembers`.`permission_group_id`, `TripMembers`.`status`, `TripMembers`.`disabled`, `TripMembers`.`created`, `TripMembers`.`modified`, `TripMember`.`id`, `TripMember`.`trip_id`, `TripMember`.`account_id`, `TripMember`.`status`, `TripMember`.`created`, `TripMember`.`modified` FROM `accounts` AS `TripMembers` JOIN `trip_members` AS `TripMember` ON (`TripMember`.`trip_id` = 97 AND `TripMember`.`account_id` = `TripMembers`.`id`) WHERE 1 = 1 110
56SELECT `TripFollowers`.`id`, `TripFollowers`.`forename`, `TripFollowers`.`surname`, `TripFollowers`.`nickname`, `TripFollowers`.`email`, `TripFollowers`.`password`, `TripFollowers`.`dob`, `TripFollowers`.`gender`, `TripFollowers`.`privacy_level`, `TripFollowers`.`nationality`, `TripFollowers`.`photo_filename`, `TripFollowers`.`fb_uid`, `TripFollowers`.`use_fb`, `TripFollowers`.`email_hash`, `TripFollowers`.`permission_group_id`, `TripFollowers`.`status`, `TripFollowers`.`disabled`, `TripFollowers`.`created`, `TripFollowers`.`modified`, `TripFollower`.`id`, `TripFollower`.`trip_id`, `TripFollower`.`account_id`, `TripFollower`.`created` FROM `accounts` AS `TripFollowers` JOIN `trip_followers` AS `TripFollower` ON (`TripFollower`.`trip_id` = 97 AND `TripFollower`.`account_id` = `TripFollowers`.`id`) WHERE 1 = 1 000
57SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating`, `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 `blogs` AS `Blog` LEFT JOIN `scoops` AS `Scoop` ON (`Blog`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`class` = 'Blog' AND `Scoop`.`account_id` = 120 ORDER BY rand() ASC LIMIT 4001
58SELECT `Photo`.`id`, `Photo`.`photo_album_id`, `Photo`.`scoop_id`, `Photo`.`title`, `Photo`.`filename`, `Photo`.`views`, `Photo`.`rating`, `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 `photos` AS `Photo` LEFT JOIN `scoops` AS `Scoop` ON (`Photo`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`class` = 'PhotoAlbum' AND `Scoop`.`account_id` = 120 ORDER BY rand() ASC LIMIT 4000
59SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating`, `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 `videos` AS `Video` LEFT JOIN `scoops` AS `Scoop` ON (`Scoop`.`foreign_id` = `Video`.`id` AND `Scoop`.`class` = 'Video') WHERE `Scoop`.`class` = 'Video' AND `Scoop`.`account_id` = 120 ORDER BY rand() ASC LIMIT 4000
60SELECT 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
61SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '80d95d32d9de55050ccc1655fbcca0de'110
62UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1328759071;s:4:\"rand\";i:1272878031;s:7:\"timeout\";i:10;}Message|a:0:{}', `expires` = 1328759071 WHERE `id` = '80d95d32d9de55050ccc1655fbcca0de'14