1 | SELECT `Post`.`id`, `Post`.`name`, `Post`.`slug`, `Post`.`content`, `Post`.`source`, `Post`.`url`, `Post`.`created`, `Post`.`modified`, `Post`.`status`, `Post`.`media_id`, `Post`.`category_id`, `Thumb`.`id`, `Thumb`.`model`, `Thumb`.`foreign_key`, `Thumb`.`name`, `Thumb`.`attachment`, `Thumb`.`dir`, `Thumb`.`type`, `Thumb`.`size`, `Thumb`.`active` FROM `drives`.`posts` AS `Post` LEFT JOIN `drives`.`medias` AS `Thumb` ON (`Post`.`media_id` = `Thumb`.`id`) WHERE `Post`.`status` = 1 AND `category_id` = 2 ORDER BY `Post`.`created` DESC | | 0 | 0 | 0 |
2 | SELECT `Post`.`id`, `Post`.`name`, `Post`.`slug`, `Post`.`content`, `Post`.`source`, `Post`.`url`, `Post`.`created`, `Post`.`modified`, `Post`.`status`, `Post`.`media_id`, `Post`.`category_id`, `Thumb`.`id`, `Thumb`.`model`, `Thumb`.`foreign_key`, `Thumb`.`name`, `Thumb`.`attachment`, `Thumb`.`dir`, `Thumb`.`type`, `Thumb`.`size`, `Thumb`.`active` FROM `drives`.`posts` AS `Post` LEFT JOIN `drives`.`medias` AS `Thumb` ON (`Post`.`media_id` = `Thumb`.`id`) WHERE `Post`.`status` = 1 AND `category_id` = 1 ORDER BY `Post`.`created` DESC LIMIT 6 | | 0 | 0 | 1 |
3 | SELECT COUNT(*) AS `count` FROM `drives`.`posts` AS `Post` LEFT JOIN `drives`.`medias` AS `Thumb` ON (`Post`.`media_id` = `Thumb`.`id`) WHERE `Post`.`status` = 1 AND `category_id` = 1 | | 1 | 1 | 0 |