SHOW FULL COLUMNS FROM `ly_article_category` [ RunTime:0.000643s ]
SELECT * FROM `ly_article_category` WHERE `id` = 40 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000479s ]
SHOW FULL COLUMNS FROM `ly_article` [ RunTime:0.000541s ]
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` <= 1735256710 AND `cat`.`path` LIKE '%-40-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000516s ]
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` <= 1735256710 AND `cat`.`path` LIKE '%-40-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`hits` DESC LIMIT 0,10 [ RunTime:0.000765s ]
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` <= 1735256710 AND `arc`.`recommended` = 1 AND `cat`.`path` LIKE '%-40-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000412s ]
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` <= 1735256710 AND `arc`.`recommended` = 1 AND `cat`.`path` LIKE '%-40-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`update_time` DESC LIMIT 0,8 [ RunTime:0.000439s ]
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` <= 1735256710 AND `cat`.`path` LIKE '%-40-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000473s ]
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` <= 1735256710 AND `cat`.`path` LIKE '%-40-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`favorites` DESC LIMIT 0,10 [ RunTime:0.000548s ]
