$data5 = Db::query('SELECT r.*,likesCount.likesNum,share_itCount.share_itNum,postsCount.postsNum FROM replys r
LEFT JOIN (
SELECT r.id,COUNT(l.`id`) AS likesNum FROM replys r
LEFT JOIN likes l ON l.telephone_1=r.telephone_it
WHERE r.forumid=?
GROUP BY r.`id`
) likesCount ON likesCount.id=r.id

LEFT JOIN (
SELECT r.id,COUNT(s.`id`) AS share_itNum FROM replys r
LEFT JOIN share_it s ON s.telephone_1=r.telephone_it
WHERE r.forumid=?
GROUP BY r.`id`
) share_itCount ON share_itCount.id=r.id

LEFT JOIN (
SELECT r.id,COUNT(p.`id`) AS postsNum FROM replys r
LEFT JOIN posts p ON p.source=r.telephone_it
WHERE r.forumid=?
GROUP BY r.`id`
) postsCount ON postsCount.id=r.id ORDER BY createtime DESC
',[1,1,1])->paginate(5);


$this->assign('replys', $data5);
$pag = $data5->render();
$this->assign('pag', $pag);