SHOW FULL COLUMNS FROM `tdy_portal_article_title` [ RunTime:0.004623s ]
SELECT * FROM `tdy_portal_article_title` WHERE ( `id` = 30 ) AND `tdy_portal_article_title`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004289s ]
SHOW FULL COLUMNS FROM `tdy_portal_article_content` [ RunTime:0.004956s ]
SELECT * FROM `tdy_portal_article_content` WHERE ( ( `aid` = 30 ) ) AND `tdy_portal_article_content`.`delete_time` = '0' [ RunTime:0.009303s ]
SHOW FULL COLUMNS FROM `tdy_portal_article_attachment` [ RunTime:0.005764s ]
SELECT * FROM `tdy_portal_article_attachment` WHERE ( `aid` = 30 ) [ RunTime:0.004594s ]
UPDATE `tdy_portal_article_title` SET `views` = `views` + 1 WHERE ( ( `id` = 30 ) ) AND `tdy_portal_article_title`.`delete_time` IS NULL [ RunTime:0.004331s ]
SHOW FULL COLUMNS FROM `tdy_portal_article_title` [ RunTime:0.004549s ]
SELECT `title`,`id`,`catid`,`publish_time` FROM `tdy_portal_article_title` WHERE ( ( ( `catid` = 9 OR `catid_ext1` = 9 OR `catid_ext2` = 9 OR `catid_ext3` = 9 OR `catid_ext4` = 9 OR `catid_ext5` = 9 ) ) AND ( `publish_time` > '2024-08-14 11:15:05' ) ) AND `tdy_portal_article_title`.`delete_time` IS NULL ORDER BY `publish_time` ASC LIMIT 1 [ RunTime:0.004317s ]
SHOW FULL COLUMNS FROM `tdy_portal_article_title` [ RunTime:0.004482s ]
SELECT `title`,`id`,`catid`,`publish_time` FROM `tdy_portal_article_title` WHERE ( ( ( `catid` = 9 OR `catid_ext1` = 9 OR `catid_ext2` = 9 OR `catid_ext3` = 9 OR `catid_ext4` = 9 OR `catid_ext5` = 9 ) ) AND ( `publish_time` < '2024-08-14 11:15:05' ) ) AND `tdy_portal_article_title`.`delete_time` IS NULL ORDER BY `publish_time` DESC LIMIT 1 [ RunTime:0.004351s ]
SELECT `title`,`id`,`catid` FROM `tdy_portal_article_title` WHERE ( `catid` = 9 ) AND `tdy_portal_article_title`.`delete_time` IS NULL LIMIT 0,1000 [ RunTime:0.004376s ]
