| 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-10' ORDER BY `Log`.`count` DESC LIMIT 30 | | 30 | 30 | 656 |
| 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 | 1810 |
| 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 `tag` LIKE '%[豚肉%' AND `users` >= 3 ORDER BY `Recipe`.`eid` DESC LIMIT 25 | | 25 | 25 | 10 |
| 7 | SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `tag` LIKE '%[豚肉%' AND `users` >= 3 | | 1 | 1 | 226 |