春が来たの新着レシピ

(新着順・3user以上)

新着レシピ人気順一覧

1/1ページ（全1件）

57
users

粥を作ろうぜ! - ノッフ！

d.hatena.ne.jp

お粥春が来たコトリさん簡単料理愛きっと愛 food recipe cooking

2008年03月15日

1/1ページ（全1件）

10 queries took 6452 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	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	1572
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	3006
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	1	1	163
7	SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE ((`title` LIKE '%春が来た%') OR (`tag` LIKE '%春が来た%') OR (`tag_orig` LIKE '%春が来た%')) AND `users` >= 3	1	1	145
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	1523
9	INSERT INTO `log` (`date`,`tag`,`count`,`modified`,`created`) VALUES ('2009-01-09','春が来た',1,'2009-01-09 20:55:53','2009-01-09 20:55:53')	1		25
10	SELECT LAST_INSERT_ID() AS insertID	1	1	16

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

1572

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

3006

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

163

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

145

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

1523

INSERT INTO `log` (`date`,`tag`,`count`,`modified`,`created`) VALUES ('2009-01-09','春が来た',1,'2009-01-09 20:55:53','2009-01-09 20:55:53')

SELECT LAST_INSERT_ID() AS insertID