[ DB ] CONNECT:[ UseTime:0.001328s ] mysql:host=42.194.150.217;port=3306;dbname=zbxh;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.001895s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_post` `p` LEFT JOIN `cmf_portal_category_post` `pcp` ON `pcp`.`post_id`=`p`.`id` WHERE `p`.`recommended` = 1 AND `p`.`post_status` = 1 GROUP BY `p`.`id` ) `_group_count_` [ RunTime:0.263363s ]
[ SQL ] SELECT * FROM `cmf_portal_post` `p` LEFT JOIN `cmf_portal_category_post` `pcp` ON `pcp`.`post_id`=`p`.`id` WHERE `p`.`recommended` = 1 AND `p`.`post_status` = 1 GROUP BY `p`.`id` ORDER BY `p`.`is_top` DESC,`pcp`.`list_order` DESC,`p`.`published_time` DESC LIMIT 0,10 [ RunTime:4.976032s ]