SELECT cs_status, uid,tid,imgurl,attachment,`from`,ctime,lasttime,lastuid,subject,`status`,draft,essence,view,zan,old,count_reply,views_android,views_ios,views_web,fave,ordertime,comment,third_party_type,third_party_nameid,mark,score1 as score,textlength, dynamicyear, defaultscore FROM {{article_subject}} WHERE tid = 789588
SELECT * FROM {{article_post}} WHERE tid = 789588
SHOW FULL COLUMNS FROM `pre_link_card`
SHOW CREATE TABLE `pre_link_card`
SELECT * FROM `pre_link_card` `t` WHERE (`status` = 1) AND (url IN (:ycp0, :ycp1, :ycp2, :ycp3, :ycp4, :ycp5, :ycp6, :ycp7, :ycp8, :ycp9, :ycp10, :ycp11, :ycp12))
SELECT DISTINCT oid,noessence FROM {{article_destination_relation}} WHERE tid = 789588
SELECT id,title,theorder FROM {{column}} WHERE id in (100838,100754,100744,100723,100720)
SELECT DISTINCT a.tagid,a.name FROM {{article_tag}} a,{{article_tag_relation}} b WHERE b.tid = 789588 AND a.tagid = b.tagid
SELECT destination,expire, islisttop FROM {{article_top}} WHERE tid = 789588 AND expire > 1722049459 ORDER BY ctime DESC
SELECT count(*) FROM {{follows}} WHERE uid=1 AND `status` = 1
SELECT count(*) FROM {{follows}} WHERE fuid=1 AND `status` = 1
SELECT * FROM {{article_operation}} WHERE tid = 789588 ORDER BY ctime DESC
SHOW FULL COLUMNS FROM `pre_user_avatar`
SHOW CREATE TABLE `pre_user_avatar`
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT uid,mid FROM {{medal_relation}} WHERE uid IN(1) ORDER BY id DESC
SELECT * FROM {{article_attachments}} WHERE logid=789588 AND status=1
SELECT DISTINCT oid FROM {{article_destination_relation}} WHERE tid = 789588
SELECT l.id, lc.cid FROM {{ad_launch}} l RIGHT JOIN {{ad_launch_cid}} lc ON l.id = lc.launch_id WHERE (l.classify = 'articleinfoimage' OR l.classify = 'articleandliveinfoimage') AND l.starttime <= 1722049459 AND l.endtime > 1722049459 AND lc.cid IN (100720,100723,100744,100754,100838) ORDER BY l.`order`, l.starttime DESC
SELECT related FROM {{article_related}} WHERE tid = 789588
SELECT DISTINCT oid FROM {{article_destination_relation}} WHERE tid = 789588
SELECT l.id, lc.cid FROM {{ad_launch}} l RIGHT JOIN {{ad_launch_cid}} lc ON l.id = lc.launch_id WHERE l.classify = 'articlerelated' AND l.starttime <= 1722049459 AND l.endtime > 1722049459 AND lc.cid IN (100720,100723,100744,100754,100838) ORDER BY l.`order`, l.starttime DESC
SELECT lc.id as tagid, lc.name as tagname, lc.synopsis as tag_dcp, '' as tag_img FROM {{city_index_associated}} cia INNER JOIN {{inode}} lc ON cia.aid=lc.id WHERE cia.cid = 100720 AND cia.`type`='wenda' AND cia.`status` = 1
评论 2