Tag Filter - (Sitemap)

Apr 05, 2008
06:04

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 192 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `posts`	17	17	1
2	DESCRIBE `comments`	11	11	4
3	DESCRIBE `tags`	2	2	15
4	DESCRIBE `categories`	2	2	30
5	DESCRIBE `posts_tags`	2	2	29
6	DESCRIBE `categories_posts`	2	2	6
7	SELECT 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 DESC	1	1	42
8	SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category	15	15	53
9	SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag	49	49	12

(default) 9 queries took 192 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `posts`

DESCRIBE `comments`

DESCRIBE `tags`

DESCRIBE `categories`

DESCRIBE `posts_tags`

DESCRIBE `categories_posts`

SELECT 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 DESC

SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category

SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag

Tag Filter - (Sitemap)

Sitemaps made easy with CakePHP 1.2

Categories

Tags

Site Sections

Blog Categories

Latest

Popular