ja http://rcp.pha11.info/ pha 牛乳の新着レシピです http://cookpad.com/recipe/500600 2008-10-06 22:21:05 http://cookpad.com/recipe/186963 2008-09-07 18:20:07 http://cookpad.com/recipe/482977 2008-09-05 00:20:16 http://excite.co.jp/News/bit/E1215132306875.html 2008-07-20 01:05:08 http://cookpad.com/mykitchen/recipe/255862/ 2008-07-20 01:05:14 http://gigazine.net/index.php?/news/comments/20080521_nisshin_milk_curry_noodle/ 2008-07-19 17:16:28 http://d.hatena.ne.jp/komachimania/20080420/p1 2008-07-19 17:16:40 http://gigazine.net/index.php?/news/comments/20071113_nisshin_milk_seafood_noodle/ 2008-07-19 17:20:11 http://cookpad.com/mykitchen/recipe/292873/ 2008-07-20 01:07:44 http://cookpad.com/mykitchen/recipe/301149/ 2008-07-20 01:10:14 http://cookpad.com/patisseriemama/recipe/150457/ 2008-07-28 01:57:36 http://portal.nifty.com/2006/08/19/a/ 2008-07-19 17:24:05 http://allabout.co.jp/gourmet/cookingabc/closeup/CU20020827a/ 2008-07-19 17:17:53

7 queries took 12 ms

Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `recipes`		11	11	1
2	DESCRIBE `log`		6	6	1
3	SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE 1 = 1		1	1	0
4	SELECT `Log`.`id`, `Log`.`date`, `Log`.`tag`, `Log`.`count`, `Log`.`created`, `Log`.`modified` FROM `log` AS `Log` WHERE `date` = '2009-01-10' ORDER BY `Log`.`count` DESC LIMIT 30		30	30	0
5	SELECT `Log`.`id`, `Log`.`date`, `Log`.`tag`, `Log`.`count`, `Log`.`created`, `Log`.`modified` FROM `log` AS `Log` WHERE 1 = 1 ORDER BY `Log`.`modified` DESC LIMIT 30		30	30	0
6	SELECT `Recipe`.`id`, `Recipe`.`eid`, `Recipe`.`url`, `Recipe`.`title`, `Recipe`.`users`, `Recipe`.`tag`, `Recipe`.`tag_orig`, `Recipe`.`description`, `Recipe`.`date`, `Recipe`.`created`, `Recipe`.`modified` FROM `recipes` AS `Recipe` WHERE `tag` LIKE '%[牛乳%' AND `users` >= 3 ORDER BY `Recipe`.`eid` DESC LIMIT 25		13	13	5
7	SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `tag` LIKE '%[牛乳%' AND `users` >= 3		1	1	5