おかずの新着レシピ
(新着順・3user以上)
2/6ページ(全140件)
2008年01月28日
2/6ページ(全140件)
Warning (2): fopen() [function.fopen]: Unable to access /virtual/akisame/public_html/rcp.pha11.info/app/tmp/cache/persistent/cake_core_object_map [CORE/cake/libs/file.php, line 144]
Warning (2): fopen(/virtual/akisame/public_html/rcp.pha11.info/app/tmp/cache/persistent/cake_core_object_map) [function.fopen]: failed to open stream: No such file or directory [CORE/cake/libs/file.php, line 144]
(新着順・3user以上)
2/6ページ(全140件)
2/6ページ(全140件)
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE 1 = 1 | 1 | 1 | 12 | |
| 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 | 0 | |
| 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, 25 | 25 | 25 | 123 | |
| 5 | SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE ((`title` LIKE '%おかず%') OR (`tag` LIKE '%おかず%') OR (`tag_orig` LIKE '%おかず%')) AND `users` >= 3 | 1 | 1 | 0 | |
| 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 | 1 | 1 | 999 | |
| 7 | SELECT COUNT(*) AS `count` FROM `log` AS `Log` WHERE `Log`.`id` = 185489 | 1 | 1 | 45 | |
| 8 | UPDATE `log` AS `Log` SET `Log`.`id` = 185489, `Log`.`date` = '2009-01-09', `Log`.`tag` = 'おかず', `Log`.`count` = 7, `Log`.`created` = '2009-01-09 15:06:29', `Log`.`modified` = '2009-01-09 15:56:20' WHERE `Log`.`id` IN (185489) | 1 | 658 |