Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SHOW FULL COLUMNS FROM `likesutf` | 8 | 8 | 94 | |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | 1 | 1 | 1 | |
3 | SHOW FULL COLUMNS FROM `types` | 4 | 4 | 82 | |
4 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci'; | 1 | 1 | 7 | |
5 | SHOW FULL COLUMNS FROM `reports` | 6 | 6 | 2 | |
6 | SELECT COUNT(*) AS `count` FROM `likesutf` AS `Like` WHERE `Like`.`created` BETWEEN '2016-5-01 00:00:00' and '2016-5-31 23:59:59' AND `Like`.`status` = 1 | 1 | 1 | 2596 | |
7 | SELECT Like.id, Like.content FROM `likesutf` AS `Like` WHERE `Like`.`created` BETWEEN '2016-5-01 00:00:00' and '2016-5-31 23:59:59' AND `Like`.`status` = 1 ORDER BY `Like`.`rejting` DESC LIMIT 10 | 10 | 10 | 2899 | |
8 | SELECT `Type`.`id`, `Type`.`name`, `Type`.`status`, `Type`.`created`, `Report`.`id`, `Report`.`type_id`, `Report`.`like_id`, `Report`.`mail_id`, `Report`.`status`, `Report`.`created` FROM `types` AS `Type` JOIN `reports` AS `Report` ON (`Report`.`type_id` IN (2323377, 2321388, 2321392, 2322386, 2322531, 2322721, 2321468, 2322805, 2321544, 2322284) AND `Report`.`like_id` = `Type`.`id`) | 0 | 0 | 92 |