SHOW FULL COLUMNS FROM `tdy_portal_article_title` [ RunTime:0.004776s ]
SELECT * FROM `tdy_portal_article_title` WHERE ( `id` = 43 ) AND `tdy_portal_article_title`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004618s ]
SHOW FULL COLUMNS FROM `tdy_portal_article_content` [ RunTime:0.009335s ]
SELECT * FROM `tdy_portal_article_content` WHERE ( ( `aid` = 43 ) ) AND `tdy_portal_article_content`.`delete_time` = '0' [ RunTime:0.007686s ]
SHOW FULL COLUMNS FROM `tdy_portal_article_attachment` [ RunTime:0.006789s ]
SELECT * FROM `tdy_portal_article_attachment` WHERE ( `aid` = 43 ) [ RunTime:0.004936s ]
UPDATE `tdy_portal_article_title` SET `views` = `views` + 1 WHERE ( ( `id` = 43 ) ) AND `tdy_portal_article_title`.`delete_time` IS NULL [ RunTime:0.004637s ]
SHOW FULL COLUMNS FROM `tdy_portal_article_title` [ RunTime:0.004774s ]
SELECT `title`,`id`,`catid`,`publish_time` FROM `tdy_portal_article_title` WHERE ( ( ( `catid` = 29 OR `catid_ext1` = 29 OR `catid_ext2` = 29 OR `catid_ext3` = 29 OR `catid_ext4` = 29 OR `catid_ext5` = 29 ) ) AND ( `publish_time` > '2024-09-29 14:46:36' ) ) AND `tdy_portal_article_title`.`delete_time` IS NULL ORDER BY `publish_time` ASC LIMIT 1 [ RunTime:0.004717s ]
SHOW FULL COLUMNS FROM `tdy_portal_article_title` [ RunTime:0.004834s ]
SELECT `title`,`id`,`catid`,`publish_time` FROM `tdy_portal_article_title` WHERE ( ( ( `catid` = 29 OR `catid_ext1` = 29 OR `catid_ext2` = 29 OR `catid_ext3` = 29 OR `catid_ext4` = 29 OR `catid_ext5` = 29 ) ) AND ( `publish_time` < '2024-09-29 14:46:36' ) ) AND `tdy_portal_article_title`.`delete_time` IS NULL ORDER BY `publish_time` DESC LIMIT 1 [ RunTime:0.004791s ]
SELECT `title`,`id`,`catid` FROM `tdy_portal_article_title` WHERE ( `catid` = 29 ) AND `tdy_portal_article_title`.`delete_time` IS NULL LIMIT 0,1000 [ RunTime:0.004574s ]
