Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|
SHOW FULL COLUMNS FROM `articles` | | 11 | 11 | 11 | |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 13 | maybe slow |
SHOW FULL COLUMNS FROM `configuration` | | 3 | 3 | 15 | maybe slow |
SHOW FULL COLUMNS FROM `user_groups` | | 3 | 3 | 12 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 11 | maybe slow |
SHOW FULL COLUMNS FROM `users` | | 15 | 15 | 11 | maybe slow |
SHOW FULL COLUMNS FROM `companies` | | 6 | 6 | 11 | maybe slow |
SHOW FULL COLUMNS FROM `login_tokens` | | 7 | 7 | 11 | maybe slow |
SHOW FULL COLUMNS FROM `user_group_permissions` | | 6 | 6 | 11 | maybe slow |
SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value` FROM `configuration` AS `Configuration` WHERE 1 = 1 | | 14 | 14 | 11 | maybe slow |
SELECT `Article`.`id`, `Article`.`publication`, `Article`.`date`, `Article`.`headline`, `Article`.`description`, `Article`.`year`, `Article`.`sort_date`, `Article`.`file_name`, `Article`.`directory`, `Article`.`created`, `Article`.`modified` FROM `articles` AS `Article` WHERE 1 = 1 ORDER BY `Article`.`sort_date` DESC | | 168 | 168 | 22 | maybe slow |
SELECT DISTINCT `Article`.`year` FROM `articles` AS `Article` WHERE 1 = 1 ORDER BY `year` DESC | | 26 | 26 | 11 | maybe slow |