里芋の新着レシピ

(新着順・3user以上)

新着レシピ人気順一覧

1/1ページ（全3件）

5
users

おばあちゃんの里芋の煮物

cookpad.com

里芋煮物じゃがいも cookpad レシピ

2008年10月20日

11
users

里芋の煮ころがし

cookpad.com

里芋 cookpad レシピ料理 100人クックパッド野菜類副菜 100↑つくれぽ

2008年09月28日

3
users

里芋の磯部焼

cookpad.com

里芋レシピクックパッド

2008年09月10日

1/1ページ（全3件）

10 queries took 1067 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `recipes`	11	11	36
2	DESCRIBE `log`	6	6	11
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-09' 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 ((`title` LIKE '%里芋%') OR (`tag` LIKE '%里芋%') OR (`tag_orig` LIKE '%里芋%')) AND `users` >= 3 ORDER BY `Recipe`.`eid` DESC LIMIT 25	3	3	11
7	SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE ((`title` LIKE '%里芋%') OR (`tag` LIKE '%里芋%') OR (`tag_orig` LIKE '%里芋%')) AND `users` >= 3	1	1	84
8	SELECT `Log`.`id`, `Log`.`date`, `Log`.`tag`, `Log`.`count`, `Log`.`created`, `Log`.`modified` FROM `log` AS `Log` WHERE `tag` = '里芋' AND `date` = '2009-01-09' LIMIT 1	1	1	925
9	SELECT COUNT(*) AS `count` FROM `log` AS `Log` WHERE `Log`.`id` = 185125	1	1	0
10	UPDATE `log` AS `Log` SET `Log`.`id` = 185125, `Log`.`date` = '2009-01-09', `Log`.`tag` = '里芋', `Log`.`count` = 2, `Log`.`created` = '2009-01-09 09:45:49', `Log`.`modified` = '2009-01-09 21:14:53' WHERE `Log`.`id` IN (185125)	1		0

10 queries took 1067 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `recipes`

DESCRIBE `log`

SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE 1 = 1

SELECT `Log`.`id`, `Log`.`date`, `Log`.`tag`, `Log`.`count`, `Log`.`created`, `Log`.`modified` FROM `log` AS `Log` WHERE `date` = '2009-01-09' ORDER BY `Log`.`count` DESC LIMIT 30

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

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 ((`title` LIKE '%里芋%') OR (`tag` LIKE '%里芋%') OR (`tag_orig` LIKE '%里芋%')) AND `users` >= 3 ORDER BY `Recipe`.`eid` DESC LIMIT 25

SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE ((`title` LIKE '%里芋%') OR (`tag` LIKE '%里芋%') OR (`tag_orig` LIKE '%里芋%')) AND `users` >= 3

SELECT `Log`.`id`, `Log`.`date`, `Log`.`tag`, `Log`.`count`, `Log`.`created`, `Log`.`modified` FROM `log` AS `Log` WHERE `tag` = '里芋' AND `date` = '2009-01-09' LIMIT 1

925

SELECT COUNT(*) AS `count` FROM `log` AS `Log` WHERE `Log`.`id` = 185125

UPDATE `log` AS `Log` SET `Log`.`id` = 185125, `Log`.`date` = '2009-01-09', `Log`.`tag` = '里芋', `Log`.`count` = 2, `Log`.`created` = '2009-01-09 09:45:49', `Log`.`modified` = '2009-01-09 21:14:53' WHERE `Log`.`id` IN (185125)