資料(いつか読む)の新着レシピ

(新着順・3user以上)

新着レシピ人気順一覧

1/1ページ（全2件）

225
users

【2ch】ニュー速クオリティ:よく貧乏生活の話題で「パン屋で食パンの耳を貰ってきた」って聞くけど

news4vip.livedoor.biz

節約生活食物レシピ (生活) 料理 (まとめ) (tips) (hack) !gtd 資料(いつか読む) あとで読む

2008年10月06日

30
users

【2ch】ニュー速クオリティ:家で焼く焼肉ってまずいよね

news4vip.livedoor.biz

食 life レシピ 2ch 料理 !gtd 資料(いつか読む)

2008年09月22日

1/1ページ（全2件）

10 queries took 5513 ms
Nr	Query	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	1
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	2124
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	2290
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	2	2	51
7	SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE ((`title` LIKE '%資料(いつか読む)%') OR (`tag` LIKE '%資料(いつか読む)%') OR (`tag_orig` LIKE '%資料(いつか読む)%')) AND `users` >= 3	1	1	167
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	0	0	878
9	INSERT INTO `log` (`date`,`tag`,`count`,`modified`,`created`) VALUES ('2009-01-09','資料(いつか読む)',1,'2009-01-09 21:41:01','2009-01-09 21:41:01')	1		0
10	SELECT LAST_INSERT_ID() AS insertID	1	1	0

10 queries took 5513 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

2124

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

2290

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

167

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

878

INSERT INTO `log` (`date`,`tag`,`count`,`modified`,`created`) VALUES ('2009-01-09','資料(いつか読む)',1,'2009-01-09 21:41:01','2009-01-09 21:41:01')

SELECT LAST_INSERT_ID() AS insertID