SHOW FULL COLUMNS FROM `ysp_comment_data` [ RunTime:0.004368s ]
SHOW FULL COLUMNS FROM `ysp_content` [ RunTime:0.000550s ]
SELECT * FROM `ysp_content` `a` LEFT JOIN `ysp_news` `b` ON `a`.`id`=`b`.`id` WHERE `a`.`id` = 6037 [ RunTime:0.001904s ]
SHOW FULL COLUMNS FROM `ysp_category_content` [ RunTime:0.000412s ]
SELECT `catid` FROM `ysp_category_content` WHERE `id` = 6037 LIMIT 1 [ RunTime:0.000208s ]
SELECT `a`.`title`,`a`.`img_list`,`a`.`url` FROM `ysp_content` `a` RIGHT JOIN `ysp_category_content` `b` ON `a`.`id`=`b`.`id` WHERE `b`.`catid` = '2' AND `a`.`id` <> 6037 AND `a`.`status` = 99 ORDER BY `b`.`listorder` DESC,`a`.`id` DESC LIMIT 12 [ RunTime:0.137190s ]
SELECT `b`.`title`,`b`.`img_list`,`b`.`url` FROM `ysp_category_content` `a` INNER JOIN `ysp_content` `b` ON `a`.`id`=`b`.`id` WHERE `a`.`catid` IN ('2','3') AND `b`.`status` = 99 AND `b`.`releasetime` BETWEEN 1750521600 AND 1750607999 ORDER BY `b`.`click` DESC,`a`.`listorder` DESC LIMIT 0,6 [ RunTime:0.280009s ]
UPDATE `ysp_content` SET `click` = `click` + 1 WHERE `id` = 6037 [ RunTime:0.004014s ]
