http://www.pdabuzz.com/tags/search/orange Latest pda and smartphone news from PDABuzz.com en-us Mon, 5 Jan 2009 14:42:36 GMT http://blogs.law.harvard.edu/tech/rss CakePHP admin@pdabuzz.com admin@pdabuzz.com

6 queries took 1 ms

Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `tags`		2	2	0
2	DESCRIBE `articles`		12	12	0
3	DESCRIBE `articles_tags`		2	2	1
4	SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` WHERE `Tag`.`tag` = 'orange' LIMIT 1		0	0	0
5	SELECT COUNT(*) AS `count` FROM `articles_tags` AS `ArticlesTag` LEFT JOIN `articles` AS `Article` ON (`ArticlesTag`.`article_id` = `Article`.`id`) LEFT JOIN `tags` AS `Tag` ON (`ArticlesTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`id`=9999		1	1	0
6	SELECT `ArticlesTag`.`article_id`, `ArticlesTag`.`tag_id`, `Article`.`id`, `Article`.`product_id`, `Article`.`title`, `Article`.`summary`, `Article`.`source`, `Article`.`url`, `Article`.`author`, `Article`.`rating`, `Article`.`rating_type`, `Article`.`status`, `Article`.`created`, `Article`.`modified`, `Tag`.`id`, `Tag`.`tag` FROM `articles_tags` AS `ArticlesTag` LEFT JOIN `articles` AS `Article` ON (`ArticlesTag`.`article_id` = `Article`.`id`) LEFT JOIN `tags` AS `Tag` ON (`ArticlesTag`.`tag_id` = `Tag`.`id`) WHERE `Tag`.`id`=9999 ORDER BY `created` DESC LIMIT 10		0	0	0