[ SQL ] SELECT count(1) as total_num
FROM `ye_article` as a
LEFT JOIN ye_category c ON a.category_id = c.id
LEFT JOIN ye_picture p ON a.cover = p.id
WHERE a.`status` = 1 AND a.display = 1 AND MATCH (a.`title`) AGAINST ('述职' IN NATURAL LANGUAGE MODE) [ RunTime:0.009079s ]
[ SQL ] SELECT a.id,a.category_id,a.title,a.`desc`,a.keyword,c.title as category_title,a.update_time ,a.view,p.path as cover,a.cover_path
FROM `ye_article` as a
LEFT JOIN ye_category c ON a.category_id = c.id
LEFT JOIN ye_picture p ON a.cover = p.id
WHERE a.`status` = 1 AND a.display = 1 AND MATCH (a.`title`) AGAINST ('述职' IN NATURAL LANGUAGE MODE) limit 180,15 [ RunTime:0.002697s ]
