1 | SHOW FULL COLUMNS FROM `likesutf` | | 8 | 8 | 2 |
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 | 2 |
4 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci'; | | 1 | 1 | 1 |
5 | SHOW FULL COLUMNS FROM `reports` | | 6 | 6 | 4 |
6 | SELECT COUNT(*) AS `count` FROM `likesutf` AS `Like` WHERE `Like`.`created` BETWEEN '2015-04-20 00:00:00' and '2015-04-20 23:59:59' AND `Like`.`status` = 1 | | 1 | 1 | 1968 |
7 | SELECT Like.id, Like.content FROM `likesutf` AS `Like` WHERE `Like`.`created` BETWEEN '2015-04-20 00:00:00' and '2015-04-20 23:59:59' AND `Like`.`status` = 1 ORDER BY `Like`.`rejting` DESC LIMIT 10 | | 0 | 0 | 2303 |