1 | SHOW FULL COLUMNS FROM `likesutf` | | 8 | 8 | 178 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | | 1 | 1 | 728 |
3 | SHOW FULL COLUMNS FROM `types` | | 4 | 4 | 181 |
4 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci'; | | 1 | 1 | 285 |
5 | SHOW FULL COLUMNS FROM `reports` | | 6 | 6 | 219 |
6 | SELECT COUNT(*) AS `count` FROM `likesutf` AS `Like` WHERE `Like`.`created` BETWEEN '2015-08-10 00:00:00' and '2015-08-10 23:59:59' AND `Like`.`status` = 1 | | 1 | 1 | 1792 |
7 | SELECT Like.id, Like.content FROM `likesutf` AS `Like` WHERE `Like`.`created` BETWEEN '2015-08-10 00:00:00' and '2015-08-10 23:59:59' AND `Like`.`status` = 1 ORDER BY `Like`.`rejting` DESC LIMIT 10 | | 0 | 0 | 2086 |