豚料理の新着レシピ

(新着順・3user以上)

新着レシピ人気順一覧

1/1ページ（全2件）

18
users

大根の豚バラ巻 by komakiさん [クックパッド] 簡単おいしいみんなのレシピが40万品

cookpad.com

豚肉豚バラ大根クックパッド eat 食レシピ後で作る豚料理そのうち作るだいこん

2008年11月13日

7
users

お豆腐の肉巻き by ぽぷらまま [クックパッド] 簡単おいしいみんなのレシピが40万品

cookpad.com

豆腐豚肉 recipe レシピ豚料理そのうち作る

2008年10月14日

1/1ページ（全2件）

8 queries took 3460 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	2138
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 '%豚料理%') OR (`tag` LIKE '%豚料理%') OR (`tag_orig` LIKE '%豚料理%')) AND `users` >= 3 ORDER BY `Recipe`.`eid` DESC LIMIT 25	2	2	73
5	SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE ((`title` LIKE '%豚料理%') OR (`tag` LIKE '%豚料理%') OR (`tag_orig` LIKE '%豚料理%')) AND `users` >= 3	1	1	118
6	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	1032
7	INSERT INTO `log` (`date`,`tag`,`count`,`modified`,`created`) VALUES ('2009-01-09','豚料理',1,'2009-01-09 21:39:21','2009-01-09 21:39:21')	1		99
8	SELECT LAST_INSERT_ID() AS insertID	1	1	0

8 queries took 3460 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

2138

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

118

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

1032

INSERT INTO `log` (`date`,`tag`,`count`,`modified`,`created`) VALUES ('2009-01-09','豚料理',1,'2009-01-09 21:39:21','2009-01-09 21:39:21')

SELECT LAST_INSERT_ID() AS insertID