EsiWeb V2.1.0 (f6bc8d6)
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `cake_sessions` | 3 | 3 | 0 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 0 | |
| 3 | SHOW FULL COLUMNS FROM `users` | 16 | 16 | 1 | |
| 4 | SHOW FULL COLUMNS FROM `mandantors` | 4 | 4 | 0 | |
| 5 | SHOW FULL COLUMNS FROM `companies` | 5 | 5 | 0 | |
| 6 | SHOW FULL COLUMNS FROM `configurations` | 8 | 8 | 0 | |
| 7 | SHOW FULL COLUMNS FROM `costcenters` | 6 | 6 | 0 | |
| 8 | SHOW FULL COLUMNS FROM `items` | 24 | 24 | 0 | |
| 9 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin'; | 1 | 1 | 0 | |
| 10 | SHOW FULL COLUMNS FROM `reports` | 17 | 17 | 1 | |
| 11 | SHOW FULL COLUMNS FROM `fileuploads` | 13 | 13 | 1 | |
| 12 | SHOW FULL COLUMNS FROM `testplans` | 11 | 11 | 1 | |
| 13 | SHOW FULL COLUMNS FROM `codes` | 9 | 9 | 0 | |
| 14 | SHOW FULL COLUMNS FROM `costcenters_users` | 7 | 7 | 0 | |
| 15 | SHOW FULL COLUMNS FROM `logs` | 10 | 10 | 1 | |
| 16 | SHOW FULL COLUMNS FROM `groups` | 4 | 4 | 0 | |
| 17 | SELECT `Configuration`.`group`, `Configuration`.`name`, `Configuration`.`value` FROM `configurations` AS `Configuration` WHERE `Configuration`.`foreign_key` = 0 AND `Configuration`.`model` = 'Mandantor' | 12 | 12 | 0 | |
| 18 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cake_sessions` AS `Session` WHERE `id` = '38g8hgrbn0mubo7p092mus1jq7' LIMIT 1 | 1 | 1 | 0 | |
| 19 | SELECT `Configuration`.`group`, `Configuration`.`name`, `Configuration`.`value` FROM `configurations` AS `Configuration` WHERE `Configuration`.`foreign_key` IS NULL AND `Configuration`.`model` = 'Mandantor' | 0 | 0 | 0 | |
| 20 | SELECT `Configuration`.`group`, `Configuration`.`name`, `Configuration`.`value` FROM `configurations` AS `Configuration` WHERE `Configuration`.`foreign_key` IS NULL AND `Configuration`.`model` = 'Company' | 0 | 0 | 0 | |
| 21 | SELECT `User`.`id`, `User`.`group_id`, `User`.`company_id`, `User`.`mandantor_id`, `User`.`username`, `User`.`password`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`enabled`, `User`.`lastlogin`, `User`.`created`, `User`.`modified`, `User`.`mustchngpwd`, `User`.`privdisaccept`, `User`.`failedlogins`, `Mandantor`.`id`, `Mandantor`.`name`, `Mandantor`.`created`, `Mandantor`.`modified`, `Company`.`id`, `Company`.`mandantor_id`, `Company`.`name`, `Company`.`created`, `Company`.`modified`, `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified` FROM `users` AS `User` LEFT JOIN `mandantors` AS `Mandantor` ON (`User`.`mandantor_id` = `Mandantor`.`id`) LEFT JOIN `companies` AS `Company` ON (`User`.`company_id` = `Company`.`id`) LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`username` IS NULL LIMIT 1 | 0 | 0 | 0 |