SHOW FULL COLUMNS FROM `ly_article_category` [ RunTime:0.000569s ]
SELECT * FROM `ly_article_category` WHERE `id` = 29 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `ly_article` [ RunTime:0.000521s ]
SELECT COUNT(*) AS think_count FROM `ly_article` `arc` LEFT JOIN `ly_article_category` `cat` ON `cat`.`id`=`arc`.`category_id` WHERE `arc`.`status` = 1 AND `arc`.`published_time` <= 1735274554 AND `cat`.`path` LIKE '%-29-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000425s ]
SELECT `arc`.`id`,`arc`.`category_id`,cat.name as category_name,`arc`.`title`,`arc`.`thumbnail`,`arc`.`source`,`arc`.`excerpt`,`arc`.`keywords`,`arc`.`published_time`,`arc`.`update_time`,`arc`.`create_time`,`arc`.`sort`,`arc`.`status`,`arc`.`comment_status`,`arc`.`is_top`,`arc`.`recommended`,`arc`.`hits`,`arc`.`likes`,`arc`.`favorites`,`arc`.`comment_count` FROM `ly_article` `arc` LEFT JOIN `ly_article_category` `cat` ON `cat`.`id`=`arc`.`category_id` WHERE `arc`.`status` = 1 AND `arc`.`published_time` <= 1735274554 AND `cat`.`path` LIKE '%-29-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`hits` DESC LIMIT 0,10 [ RunTime:0.000576s ]
SELECT COUNT(*) AS think_count FROM `ly_article` `arc` LEFT JOIN `ly_article_category` `cat` ON `cat`.`id`=`arc`.`category_id` WHERE `arc`.`status` = 1 AND `arc`.`published_time` <= 1735274554 AND `arc`.`recommended` = 1 AND `cat`.`path` LIKE '%-29-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000341s ]
SELECT `arc`.`id`,`arc`.`category_id`,cat.name as category_name,`arc`.`title`,`arc`.`thumbnail`,`arc`.`source`,`arc`.`excerpt`,`arc`.`keywords`,`arc`.`published_time`,`arc`.`update_time`,`arc`.`create_time`,`arc`.`sort`,`arc`.`status`,`arc`.`comment_status`,`arc`.`is_top`,`arc`.`recommended`,`arc`.`hits`,`arc`.`likes`,`arc`.`favorites`,`arc`.`comment_count` FROM `ly_article` `arc` LEFT JOIN `ly_article_category` `cat` ON `cat`.`id`=`arc`.`category_id` WHERE `arc`.`status` = 1 AND `arc`.`published_time` <= 1735274554 AND `arc`.`recommended` = 1 AND `cat`.`path` LIKE '%-29-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`update_time` DESC LIMIT 0,8 [ RunTime:0.000380s ]
SELECT COUNT(*) AS think_count FROM `ly_article` `arc` LEFT JOIN `ly_article_category` `cat` ON `cat`.`id`=`arc`.`category_id` WHERE `arc`.`status` = 1 AND `arc`.`published_time` <= 1735274554 AND `cat`.`path` LIKE '%-29-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000324s ]
SELECT `arc`.`id`,`arc`.`category_id`,cat.name as category_name,`arc`.`title`,`arc`.`thumbnail`,`arc`.`source`,`arc`.`excerpt`,`arc`.`keywords`,`arc`.`published_time`,`arc`.`update_time`,`arc`.`create_time`,`arc`.`sort`,`arc`.`status`,`arc`.`comment_status`,`arc`.`is_top`,`arc`.`recommended`,`arc`.`hits`,`arc`.`likes`,`arc`.`favorites`,`arc`.`comment_count` FROM `ly_article` `arc` LEFT JOIN `ly_article_category` `cat` ON `cat`.`id`=`arc`.`category_id` WHERE `arc`.`status` = 1 AND `arc`.`published_time` <= 1735274554 AND `cat`.`path` LIKE '%-29-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`favorites` DESC LIMIT 0,10 [ RunTime:0.000475s ]