Hmmm it seems once I moved my custom pagination method, it worked... but now im getting 55+ queries. They all look like this, anyway to shorten it? Its double querying the User/Member data.
2 SELECT COUNT(*) AS `count` FROM `friends` AS `Friend` LEFT JOIN `users` AS `User` ON (`Friend`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `Member` ON (`Friend`.`friend_id` = `Member`.`id`) WHERE `Friend`.`status` = 'approved' AND ((`Friend`.`user_id` = 2) OR (`Friend`.`friend_id` = 2)) 1 1 1 3 SELECT `Friend`.`id`, `Friend`.`user_id`, `Friend`.`friend_id`, `Friend`.`status`, `Friend`.`requestTime`, `User`.`id`, `User`.`username`, `User`.`handle`, `User`.`quote`, `User`.`country_id`, `User`.`signupDate`, `Member`.`id`, `Member`.`username`, `Member`.`handle`, `Member`.`quote`, `Member`.`country_id`, `Member`.`signupDate` FROM `friends` AS `Friend` LEFT JOIN `users` AS `User` ON (`Friend`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `Member` ON (`Friend`.`friend_id` = `Member`.`id`) WHERE `Friend`.`status` = 'approved' AND ((`Friend`.`user_id` = 2) OR (`Friend`.`friend_id` = 2)) ORDER BY `Friend`.`requestTime` ASC LIMIT 10 10 10 2 4 SELECT `User`.`id`, `User`.`username`, `User`.`handle`, `User`.`quote`, `User`.`country_id`, `User`.`signupDate` FROM `users` AS `User` WHERE `User`.`id` = 2 1 1 1 5 SELECT `Country`.`id`, `Country`.`name`, `Country`.`iso`, `Country`.`locale_id` FROM `countries` AS `Country` WHERE `Country`.`id` = 1 1 1 1 ..... 42 SELECT `Member`.`id`, `Member`.`username`, `Member`.`handle`, `Member`.`quote`, `Member`.`country_id`, `Member`.`signupDate` FROM `users` AS `Member` WHERE `Member`.`id` = 24 1 1 1 43 SELECT `Country`.`id`, `Country`.`name`, `Country`.`iso`, `Country`.`locale_id` FROM `countries` AS `Country` WHERE `Country`.`id` = 1 1 1 1 --~--~---------~--~----~------------~-------~--~----~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---