10 queries took 2560 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `recipes`11113
2DESCRIBE `log`663
3SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE 1 = 1 112
4SELECT `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 3030304
5SELECT `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 3030301
6SELECT `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 '%玄米%')) ORDER BY `Recipe`.`eid` DESC LIMIT 2544261
7SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE ((`title` LIKE '%玄米%') OR (`tag` LIKE '%玄米%') OR (`tag_orig` LIKE '%玄米%')) 11444
8SELECT `Log`.`id`, `Log`.`date`, `Log`.`tag`, `Log`.`count`, `Log`.`created`, `Log`.`modified` FROM `log` AS `Log` WHERE `tag` = '玄米' AND `date` = '2009-01-09' LIMIT 1111836
9SELECT COUNT(*) AS `count` FROM `log` AS `Log` WHERE `Log`.`id` = 185130 116
10UPDATE `log` AS `Log` SET `Log`.`id` = 185130, `Log`.`date` = '2009-01-09', `Log`.`tag` = '玄米', `Log`.`count` = 2, `Log`.`created` = '2009-01-09 09:47:55', `Log`.`modified` = '2009-01-09 21:18:21' WHERE `Log`.`id` IN (185130) 10