1 | SHOW FULL COLUMNS FROM `likesutf` | | 8 | 8 | 25 |
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 | 3 |
5 | SHOW FULL COLUMNS FROM `reports` | | 6 | 6 | 2 |
6 | SELECT COUNT(*) AS `count` FROM `likesutf` AS `Like` WHERE `Like`.`created` BETWEEN '2015-11-6 00:00:00' and '2015-11-6 23:59:59' AND `Like`.`status` = 1 | | 1 | 1 | 1102 |
7 | SELECT Like.id, Like.content FROM `likesutf` AS `Like` WHERE `Like`.`created` BETWEEN '2015-11-6 00:00:00' and '2015-11-6 23:59:59' AND `Like`.`status` = 1 ORDER BY `Like`.`rejting` DESC LIMIT 10 | | 0 | 0 | 1492 |