At the moment i get 32 queries on a page which is well allot :) Is
there a way to optimize them?
I have: $this->set('articles', $this->paginate('Article'));
And it doe queries:
1 SELECT COUNT(*) AS count FROM `cms_articles` AS `Article` WHERE 1 =
1 1 1 0
2 SELECT `Article`.`id`, `Article`.`title`, `Article`.`slug`,
`Article`.`article`, `Article`.`menu_id`, `Article`.`created`,
`Article`.`modified` FROM `cms_articles` AS `Article` WHERE 1 = 1
LIMIT 15, 15 15 15 0
3 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 17 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
4 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 18 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
5 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 19 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
6 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 20 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
7 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 21 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
8 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 22 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
9 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 23 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
10 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 24 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
11 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 25 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
12 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 26 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
13 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 27 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
14 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 28 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
15 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 29 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
16 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 30 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
17 SELECT `Tag`.`id`, `Tag`.`tag` FROM `cms_tags` AS `Tag` JOIN
`cms_articles_tags` ON (`cms_articles_tags`.`article_id` = 31 AND
`cms_articles_tags`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 0 0 0
18 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 17 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
19 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 18 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
20 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 19 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
21 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 20 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
22 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 21 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
23 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 22 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
24 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 23 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
25 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 24 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
26 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 25 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
27 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 26 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
28 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 27 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
29 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 28 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
30 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 29 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
31 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 30 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
0 0 0
32 SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`
FROM `cms_categories` AS `Category` JOIN `cms_articles_categories` ON
(`cms_articles_categories`.`article_id` = 31 AND
`cms_articles_categories`.`category_id` = `Category`.`id`) WHERE 1 = 1
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
