Tag Filter - (Sitemap)

Sitemaps made easy with CakePHP 1.2

Sitemaps are an essential aspect of most websites whether its just for SEO or simply to assist with the user site navigation. CakePHP 1.2 makes sitemaps a breeze to create and what makes its even better is that CakePHP can generate portions of your sitemp automatically...

Filed under: Cakephp  Tags: Sitemap, Seo
(default) 9 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `posts`17170
2DESCRIBE `comments`11110
3DESCRIBE `tags`220
4DESCRIBE `categories`220
5DESCRIBE `posts_tags`220
6DESCRIBE `categories_posts`220
7SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('Sitemap') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC111
8SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category15151
9SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag49491