SHOW FULL COLUMNS FROM `ly_article_category` [ RunTime:0.000710s ]
SELECT * FROM `ly_article_category` WHERE `id` = 28 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000360s ]
SHOW FULL COLUMNS FROM `ly_article` [ RunTime:0.000546s ]
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` <= 1733304624 AND `cat`.`path` LIKE '%-28-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000671s ]
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` <= 1733304624 AND `cat`.`path` LIKE '%-28-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`hits` DESC LIMIT 0,10 [ RunTime:0.000719s ]
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` <= 1733304624 AND `arc`.`recommended` = 1 AND `cat`.`path` LIKE '%-28-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000447s ]
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` <= 1733304624 AND `arc`.`recommended` = 1 AND `cat`.`path` LIKE '%-28-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`update_time` DESC LIMIT 0,8 [ RunTime:0.000520s ]
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` <= 1733304624 AND `cat`.`path` LIKE '%-28-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000469s ]
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` <= 1733304624 AND `cat`.`path` LIKE '%-28-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`favorites` DESC LIMIT 0,10 [ RunTime:0.000757s ]
