Cool statusi za fejs - 25. Sep. 2016

NedPonUtoSreČetPetSub
123
45678910
11121314151617
18192021222324
252627282930
 
(default) 8 queries took 787 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `likesutf`881
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci';111
3SHOW FULL COLUMNS FROM `types`441
4SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci';111
5SHOW FULL COLUMNS FROM `reports`661
6SELECT COUNT(*) AS `count` FROM `likesutf` AS `Like` WHERE `Like`.`created` BETWEEN '2016-09-25 00:00:00' and '2016-09-25 23:59:59' AND `Like`.`status` = 1 11369
7SELECT Like.id, Like.content FROM `likesutf` AS `Like` WHERE `Like`.`created` BETWEEN '2016-09-25 00:00:00' and '2016-09-25 23:59:59' AND `Like`.`status` = 1 ORDER BY `Like`.`rejting` DESC LIMIT 1033403
8SELECT `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 (2332166, 2332164, 2332163) AND `Report`.`like_id` = `Type`.`id`) 0010