SHOW FULL COLUMNS FROM `ly_article_category` [ RunTime:0.000582s ]
SELECT * FROM `ly_article_category` WHERE `id` = 2 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000342s ]
SHOW FULL COLUMNS FROM `ly_article` [ RunTime:0.000466s ]
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` <= 1735215905 AND `cat`.`path` LIKE '%-2-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000413s ]
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` <= 1735215905 AND `cat`.`path` LIKE '%-2-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`hits` DESC LIMIT 0,10 [ RunTime:0.000489s ]
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` <= 1735215905 AND `arc`.`recommended` = 1 AND `cat`.`path` LIKE '%-2-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000437s ]
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` <= 1735215905 AND `arc`.`recommended` = 1 AND `cat`.`path` LIKE '%-2-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`update_time` DESC LIMIT 0,8 [ RunTime:0.000427s ]
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` <= 1735215905 AND `cat`.`path` LIKE '%-2-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000436s ]
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` <= 1735215905 AND `cat`.`path` LIKE '%-2-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`favorites` DESC LIMIT 0,10 [ RunTime:0.000595s ]
