SHOW FULL COLUMNS FROM `ly_article_category` [ RunTime:0.000522s ]
SELECT * FROM `ly_article_category` WHERE `id` = 30 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `ly_article` [ RunTime:0.000494s ]
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` <= 1735273411 AND `cat`.`path` LIKE '%-30-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000439s ]
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` <= 1735273411 AND `cat`.`path` LIKE '%-30-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`hits` DESC LIMIT 0,10 [ RunTime:0.000670s ]
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` <= 1735273411 AND `arc`.`recommended` = 1 AND `cat`.`path` LIKE '%-30-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000408s ]
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` <= 1735273411 AND `arc`.`recommended` = 1 AND `cat`.`path` LIKE '%-30-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`update_time` DESC LIMIT 0,8 [ RunTime:0.000383s ]
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` <= 1735273411 AND `cat`.`path` LIKE '%-30-%' AND `arc`.`delete_time` = 0 [ RunTime:0.000396s ]
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` <= 1735273411 AND `cat`.`path` LIKE '%-30-%' AND `arc`.`delete_time` = 0 ORDER BY `arc`.`favorites` DESC LIMIT 0,10 [ RunTime:0.000501s ]
