| 1 | SHOW FULL COLUMNS FROM `aros` | | 7 | 7 | 1 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 |
| 3 | SHOW FULL COLUMNS FROM `acos` | | 7 | 7 | 0 |
| 4 | SHOW FULL COLUMNS FROM `aros_acos` | | 7 | 7 | 0 |
| 5 | SHOW FULL COLUMNS FROM `komms` | | 10 | 10 | 1 |
| 6 | SHOW FULL COLUMNS FROM `points` | | 5 | 5 | 0 |
| 7 | SELECT COUNT(*) AS `count` FROM `komms` AS `Komm` WHERE 1 = 1 | | 1 | 1 | 0 |
| 8 | SELECT `Komm`.`id`, `Komm`.`nimi`, `Komm`.`aeg`, `Komm`.`email`, `Komm`.`orig_text`, `Komm`.`html_text`, `Komm`.`ip`, `Komm`.`uid`, `Komm`.`mdt`, `Komm`.`muid`, (coalesce((select sum(hinne) from points where komm_id = `Komm`.`id`), 0)) AS `Komm__hinne` FROM `komms` AS `Komm` WHERE 1 = 1 ORDER BY (coalesce((select sum(hinne) from points where komm_id = `Komm`.`id`), 0)) desc, `Komm`.`id` asc LIMIT 20, 20 | | 20 | 20 | 2 |
| 9 | SELECT `Point`.`id`, `Point`.`uid`, `Point`.`komm_id`, `Point`.`hinne`, `Point`.`idt` FROM `points` AS `Point` WHERE `Point`.`komm_id` IN (181654, 181655, 181657, 181659, 181665, 181670, 181671, 181686, 181688, 181692, 181695, 181701, 181704, 181705, 181706, 181709, 181723, 181724, 181725, 181640) | | 61 | 61 | 0 |
| 10 | SHOW FULL COLUMNS FROM `teksts` | | 3 | 3 | 1 |
| 11 | SELECT `Tekst`.`id`, `Tekst`.`controller`, `Tekst`.`tekst` FROM `teksts` AS `Tekst` WHERE `Tekst`.`controller` = 'komms' LIMIT 1 | | 1 | 1 | 0 |