familyの新着レシピ

(新着順・3user以上)

新着レシピ人気順一覧

1/1ページ（全2件）

16
users

有名なシェフのレシピが検索できるサイト「Cookstr」 : ライフハッカー［日本版］, 仕事も生活も上手くこなすライフハック情報満載のブログ・メディア

www.lifehacker.jp

なす食レシピ生活グルメ lifehack クックパッド cookpad family search

2008年11月20日

5
users

Ｓ嬢はてな - オーブン壊れてぐっちゃぐちゃ

d.hatena.ne.jp

幼稚園レシピ育児 love family food recipe

2007年09月19日

1/1ページ（全2件）

8 queries took 7149 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE 1 = 1	1	1	0
2	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
3	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	3387
4	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 '%family%') OR (`tag` LIKE '%family%') OR (`tag_orig` LIKE '%family%')) AND `users` >= 3 ORDER BY `Recipe`.`eid` DESC LIMIT 25	2	2	249
5	SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE ((`title` LIKE '%family%') OR (`tag` LIKE '%family%') OR (`tag_orig` LIKE '%family%')) AND `users` >= 3	1	1	484
6	SELECT `Log`.`id`, `Log`.`date`, `Log`.`tag`, `Log`.`count`, `Log`.`created`, `Log`.`modified` FROM `log` AS `Log` WHERE `tag` = 'family' AND `date` = '2009-01-09' LIMIT 1	1	1	3029
7	SELECT COUNT(*) AS `count` FROM `log` AS `Log` WHERE `Log`.`id` = 184978	1	1	0
8	UPDATE `log` AS `Log` SET `Log`.`id` = 184978, `Log`.`date` = '2009-01-09', `Log`.`tag` = 'family', `Log`.`count` = 2, `Log`.`created` = '2009-01-09 07:18:47', `Log`.`modified` = '2009-01-09 13:26:51' WHERE `Log`.`id` IN (184978)	1		0

8 queries took 7149 ms

Query

Error

Affected

Num. rows

Took (ms)

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

3387

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

249

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

484

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

3029

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

UPDATE `log` AS `Log` SET `Log`.`id` = 184978, `Log`.`date` = '2009-01-09', `Log`.`tag` = 'family', `Log`.`count` = 2, `Log`.`created` = '2009-01-09 07:18:47', `Log`.`modified` = '2009-01-09 13:26:51' WHERE `Log`.`id` IN (184978)