Tag Filter - (Shell)

Jul 28, 2010
08:07

Shhhh! Keep quiet cakephp console

Its been a while since I've had a chance and/or motivation to write any notes down, in the words of Willie Wonka "So much time, so little to do....ahhhh, strike that, reverse it..."

At any rate this note is in relation to the cakePHP console and keeping it quiet. Sometimes you need the verbose / debug information and other times it makes it impossible to work in the same shell window...

Filed under: Cakephp Tags: Shell

(default) 9 queries took 56 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `posts`	17	17	12
2	DESCRIBE `comments`	11	11	1
3	DESCRIBE `tags`	2	2	7
4	DESCRIBE `categories`	2	2	8
5	DESCRIBE `posts_tags`	2	2	1
6	DESCRIBE `categories_posts`	2	2	11
7	SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('Shell') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC	1	1	13
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	1
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	2

(default) 9 queries took 56 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 = ('Shell') 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 - (Shell)

Shhhh! Keep quiet cakephp console

Categories

Tags

Site Sections

Blog Categories

Latest

Popular