德化资讯

客服热线

0595-23555246
  • SELECT l.`id`, l.`title`, l.`admin`, l.`subtitle`, l.`typeid`, l.`flag`, l.`weight`, l.`keywords`, l.`description`, l.`source`, l.`redirecturl`, l.`litpic`, l.`color`, l.`click`, l.`arcrank`, l.`pubdate`, l.`typeset`, l.`videotype`, l.`videourl`, (SELECT COUNT(`id`) FROM `hn_public_comment` WHERE `aid` = l.`id` AND `ischeck` = 1 AND `pid` = 0 AND `type` = 'article-detail') AS total, l.`waitpay`, l.`admin`, l.`mold`, l.`zan`, l.`writer`, l.`videotime`, l.`videotype`, l.`videourl` FROM `hn_articlelist_all` l INNER JOIN (SELECT lt.`id` FROM `hn_articlelist_all` lt WHERE lt.`del` = 0 AND lt.`cityid` = 2368 AND lt.`arcrank` = 1 AND lt.`waitpay` = 0 AND lt.`del` = 0 AND lt.`media_state` = 1 AND lt.`mold` = 0 AND lt.`flag_p` = 1 AND lt.`typeid` in (21) AND DATE_FORMAT(FROM_UNIXTIME(`pubdate`), '%Y-%m-%d') = curdate() ORDER BY lt.`click` DESC, lt.`weight` DESC, lt.`id` DESC LIMIT 0, 4) AS tmp ON tmp.`id` = l.`id`;0.563362 s/per