かぼちゃの新着レシピ

(新着順・3user以上)

新着レシピ人気順一覧

2/2ページ（全26件）

1 | 2

39
users

かぼちゃのレシピ

www.nzkabocha.com

かぼちゃレシピ recipe 食野菜カボチャ料理

2005年02月28日

1 | 2

2/2ページ（全26件）

7 queries took 2200 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	751
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	1236
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, 25	1	1	120
7	SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE ((`title` LIKE '%かぼちゃ%') OR (`tag` LIKE '%かぼちゃ%') OR (`tag_orig` LIKE '%かぼちゃ%')) AND `users` >= 3	1	1	91

7 queries took 2200 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

751

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

1236

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, 25

120

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