| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `rewards` | 9 | 9 | 2 | |
| 2 | SELECT COUNT(*) AS `count` FROM `rewards` AS `Reward` WHERE `Reward`.`activated` = 1 AND `Reward`.`special` = 0 | 1 | 1 | 1 | |
| 3 | SELECT `Reward`.`id`, `Reward`.`name`, `Reward`.`description`, `Reward`.`image`, `Reward`.`value`, `Reward`.`activated`, `Reward`.`special`, `Reward`.`modified`, `Reward`.`created` FROM `rewards` AS `Reward` WHERE `Reward`.`activated` = 1 AND `Reward`.`special` = 0 ORDER BY `Reward`.`value` DESC, `Reward`.`id` ASC LIMIT 1 | 1 | 1 | 1 |