Array
(
    [0] => Array
        (
            [Message] => Array
                (
                    [id] => 7
                    [user_id] => 1
                    [node_id] => 4
                    [reciever_id] => 18
                    [created] => 2011-12-07 12:00:00
                    [modified] => 2011-12-07 12:00:00
                )

            [Node] => Array
                (
                    [id] => 4
                    [message] => yeah. are you back in town ? i think we should meet up man. its been ages ....
                    [author_id] => 18
                    [read] => 0
                    [created] => 2011-12-07 12:00:00
                    [modified] => 2011-12-07 12:00:00
                )

            [Reciever] => Array
                (
                    [id] => 18
                    [first_name] => Ashish
                    [last_name] => Ramesh
                    [email] => ashishmaverick@gmail.com
                    [password] => 168f092c899d59b46d38519dcb07bdd6f8f64298
                    [username] => ashish.ramesh
                    [birthday] => 1986-10-25
                    [gender] => male
                    [city_id] => 1949
                    [status] => 
                    [created] => 2011-11-30 00:53:12
                    [modified] => 2011-11-30 00:53:12
                    [Oauth] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 18
                                    [user_id] => 18
                                    [provider] => facebook
                                    [provider_uid] => 548958419
                                    [details] => 
                                    [created] => 2011-11-30 00:53:12
                                    [modified] => 2011-11-30 00:53:12
                                )

                        )

                )

        )

    [1] => Array
        (
            [Message] => Array
                (
                    [id] => 4
                    [user_id] => 1
                    [node_id] => 2
                    [reciever_id] => 15
                    [created] => 2011-12-07 11:00:00
                    [modified] => 2011-12-07 11:00:00
                )

            [Node] => Array
                (
                    [id] => 2
                    [message] => Sure. wanna go to Mangalore Pearl to eat Neer Dosa..
                    [author_id] => 15
                    [read] => 0
                    [created] => 2011-12-07 11:00:00
                    [modified] => 2011-12-07 11:00:00
                )

            [Reciever] => Array
                (
                    [id] => 15
                    [first_name] => Mayur
                    [last_name] => Polepalli
                    [email] => dbmayur@gmail.com
                    [password] => f87cb1e878c1ad1746195c700b310e1de6e93156
                    [username] => dbmayur
                    [birthday] => 1978-11-21
                    [gender] => male
                    [city_id] => 1949
                    [status] => 
                    [created] => 2011-11-30 00:17:22
                    [modified] => 2011-11-30 00:17:22
                    [Oauth] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 15
                                    [user_id] => 15
                                    [provider] => facebook
                                    [provider_uid] => 535131489
                                    [details] => 
                                    [created] => 2011-11-30 00:17:22
                                    [modified] => 2011-11-30 00:17:22
                                )

                        )

                )

        )

)
app/controllers/users_controller.php (line 237)
Array
(
    [0] => Array
        (
            [reciever_id] => 18
            [name] => Ashish Ramesh
            [display_photo] => http://graph.facebook.com/548958419/picture?type=normal
            [message] => yeah. are you back in town ? i think we should meet up man. its been ages ....
            [read] => 0
            [timestamp] => 2011-12-07 12:00:00
        )

    [1] => Array
        (
            [reciever_id] => 15
            [name] => Mayur Polepalli
            [display_photo] => http://graph.facebook.com/535131489/picture?type=normal
            [message] => Sure. wanna go to Mangalore Pearl to eat Neer Dosa..
            [read] => 0
            [timestamp] => 2011-12-07 11:00:00
        )

)

CakePHP: the rapid development php framework: Users
(default) 22 queries took 19 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `users`12122
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `cities`882
4SHOW FULL COLUMNS FROM `countries`551
5SHOW FULL COLUMNS FROM `regions`441
6SHOW FULL COLUMNS FROM `profiles`771
7SHOW FULL COLUMNS FROM `relationships`221
8SHOW FULL COLUMNS FROM `search_filters`661
9SHOW FULL COLUMNS FROM `blocks`441
10SHOW FULL COLUMNS FROM `favorites`441
11SHOW FULL COLUMNS FROM `messages`661
12SHOW FULL COLUMNS FROM `nodes`661
13SHOW FULL COLUMNS FROM `oauths`771
14SHOW FULL COLUMNS FROM `photos`662
15SHOW FULL COLUMNS FROM `visitors`442
16SELECT `Message`.`id`, `Message`.`user_id`, `Message`.`node_id`, `Message`.`reciever_id`, `Message`.`created`, `Message`.`modified`, `Node`.`id`, `Node`.`message`, `Node`.`author_id`, `Node`.`read`, `Node`.`created`, `Node`.`modified`, `Reciever`.`id`, `Reciever`.`first_name`, `Reciever`.`last_name`, `Reciever`.`email`, `Reciever`.`password`, `Reciever`.`username`, `Reciever`.`birthday`, `Reciever`.`gender`, `Reciever`.`city_id`, `Reciever`.`status`, `Reciever`.`created`, `Reciever`.`modified` FROM `messages` AS `Message` LEFT JOIN `nodes` AS `Node` ON (`Message`.`node_id` = `Node`.`id`) LEFT JOIN `users` AS `Reciever` ON (`Message`.`reciever_id` = `Reciever`.`id`) WHERE `Message`.`id` IN (SELECT id FROM (SELECT * FROM `messages` AS `Message` WHERE `Message`.`user_id` = 1 ORDER BY `created` DESC ) AS Message GROUP BY Message.reciever_id) ORDER BY `Message`.`created` DESC 221
17SELECT `Node`.`id`, `Node`.`message`, `Node`.`author_id`, `Node`.`read`, `Node`.`created`, `Node`.`modified` FROM `nodes` AS `Node` WHERE `Node`.`id` = 4 110
18SELECT `Node`.`id`, `Node`.`message`, `Node`.`author_id`, `Node`.`read`, `Node`.`created`, `Node`.`modified` FROM `nodes` AS `Node` WHERE `Node`.`id` = 2 110
19SELECT `Reciever`.`id`, `Reciever`.`first_name`, `Reciever`.`last_name`, `Reciever`.`email`, `Reciever`.`password`, `Reciever`.`username`, `Reciever`.`birthday`, `Reciever`.`gender`, `Reciever`.`city_id`, `Reciever`.`status`, `Reciever`.`created`, `Reciever`.`modified` FROM `users` AS `Reciever` WHERE `Reciever`.`id` = 18 110
20SELECT `Oauth`.`id`, `Oauth`.`user_id`, `Oauth`.`provider`, `Oauth`.`provider_uid`, `Oauth`.`details`, `Oauth`.`created`, `Oauth`.`modified` FROM `oauths` AS `Oauth` WHERE `Oauth`.`user_id` = (18) 110
21SELECT `Reciever`.`id`, `Reciever`.`first_name`, `Reciever`.`last_name`, `Reciever`.`email`, `Reciever`.`password`, `Reciever`.`username`, `Reciever`.`birthday`, `Reciever`.`gender`, `Reciever`.`city_id`, `Reciever`.`status`, `Reciever`.`created`, `Reciever`.`modified` FROM `users` AS `Reciever` WHERE `Reciever`.`id` = 15 110
22SELECT `Oauth`.`id`, `Oauth`.`user_id`, `Oauth`.`provider`, `Oauth`.`provider_uid`, `Oauth`.`details`, `Oauth`.`created`, `Oauth`.`modified` FROM `oauths` AS `Oauth` WHERE `Oauth`.`user_id` = (15) 110
(default) 22 queries took 19 ms
NrQueryErrorAffectedNum. rowsTook (ms)