Containable bug?

I'm getting a lot of extra queries when doing certain contains.
Cakeversion: 1.2.0.7962

I've got three Models

Member
Item
Itemrating

Itemrating belongsTo Item
Item BelongsTo Member

I'm trying to do a find on Itemrating and contain Item and Member

Here is the code to do the find:
$this->Itemrating->contain(array('Item'=>array('fields'=>array
('id','slug','member_id'),'Member'=>array('fields'=>array
('id','username','slug','gender_id','birth')))));
$data = $this->Itemrating->find('all',array('conditions'=>array
('date'=>date('Y-m-d'),'Item.type_id'=>1, 'Itemrating.votes
>'=>0),'order'=>array('Itemrating.rating'=>'DESC'),'limit'=>20));

It should be possible for cake to get all this info in one query. But
instead I get 1 query that gets the data from itemratings and member,
then for each result from that query, two additional queries are
generated, one to get the member data, and one to get the item data.
Is this a bug? Or am I doing something wrong?

Here are the queries being built:

Nr Query Error Affected Num. rows Took (ms)
1 SELECT `Itemrating`.`id`, `Itemrating`.`item_id`,
`Itemrating`.`date`, `Itemrating`.`votes`, `Itemrating`.`rating`,
`Item`.`id`, `Item`.`slug`, `Item`.`member_id` FROM `itemratings` AS
`Itemrating` LEFT JOIN `items` AS `Item` ON (`Itemrating`.`item_id` =
`Item`.`id`) WHERE `date` = '2009-02-24' AND `Item`.`type_id` = 1 AND
`Itemrating`.`votes` > 0 ORDER BY `Itemrating`.`rating` DESC LIMIT 20
3 3 10
2 SELECT `Item`.`id`, `Item`.`slug`, `Item`.`member_id` FROM `items`
AS `Item` WHERE `Item`.`id` = 3 1 1 0
3 SELECT `Member`.`id`, `Member`.`username`, `Member`.`slug`,
`Member`.`gender_id`, `Member`.`birth` FROM `members` AS `Member`
WHERE `Member`.`id` = 2 1 1 0
4 SELECT `Item`.`id`, `Item`.`slug`, `Item`.`member_id` FROM `items`
AS `Item` WHERE `Item`.`id` = 253 1 1 0
5 SELECT `Member`.`id`, `Member`.`username`, `Member`.`slug`,
`Member`.`gender_id`, `Member`.`birth` FROM `members` AS `Member`
WHERE `Member`.`id` = 2 1 1 0
6 SELECT `Item`.`id`, `Item`.`slug`, `Item`.`member_id` FROM `items`
AS `Item` WHERE `Item`.`id` = 1 1 1 0
7 SELECT `Member`.`id`, `Member`.`username`, `Member`.`slug`,
`Member`.`gender_id`, `Member`.`birth` FROM `members` AS `Member`
WHERE `Member`.`id` = 2 1 1 0

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---