1 | SHOW FULL COLUMNS FROM `likesutf` | | 8 | 8 | 3 |
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 | 2 |
6 | SELECT COUNT(*) AS `count` FROM `likesutf` AS `Like` WHERE `Like`.`status` = 1 AND `Like`.`rejting` > 10 | | 1 | 1 | 703 |
7 | SELECT Like.id, Like.content FROM `likesutf` AS `Like` WHERE `Like`.`status` = 1 AND `Like`.`rejting` > 10 ORDER BY `Like`.`modified` DESC LIMIT 90310, 10 | | 10 | 10 | 678 |
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 (193658, 268358, 268059, 197842, 381590, 238749, 983055, 982688, 201896, 315066) AND `Report`.`like_id` = `Type`.`id`) | | 0 | 0 | 6 |
9 | SHOW FULL COLUMNS FROM `ads` | | 7 | 7 | 1 |
10 | SELECT `Ad`.`id`, `Ad`.`content`, `Ad`.`img`, `Ad`.`status`, `Ad`.`rejting`, `Ad`.`istice`, `Ad`.`created` FROM `ads` AS `Ad` WHERE 1 = 1 | | 1 | 1 | 50 |