SELECT id,comment_count,sortorder,`like`,`status`,uid,mark,init_time,noessence, classify, s_status, expire_at FROM {{live}} WHERE id=328980
SHOW FULL COLUMNS FROM `pre_live`
SHOW CREATE TABLE `pre_live`
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='328980' LIMIT 1
SHOW FULL COLUMNS FROM `pre_column`
SHOW CREATE TABLE `pre_column`
SELECT * FROM `pre_column` `t` WHERE `t`.`id`='101290' LIMIT 1
SELECT title, showname FROM {{column}} WHERE id = 101290
SELECT * FROM {{attachments}} WHERE classify='live' AND logid=328980 ORDER BY FIELD(id, 6093260,6093261,6093262,6093263,6093264,6093265,6093266,6093267,6093268,6093269,6093270)
SHOW FULL COLUMNS FROM `pre_attachments`
SHOW CREATE TABLE `pre_attachments`
SHOW FULL COLUMNS FROM `pre_live_video`
SHOW CREATE TABLE `pre_live_video`
SELECT * FROM `pre_live_video` `t` WHERE logid IN (328980) AND `status` = 1
SELECT tr.id, tr.name, tla.isbelong, tr.hotel_id FROM {{inode}} tr LEFT JOIN {{inode_live_hot}} tla ON tr.id = tla.nid WHERE tla.logid = 328980 AND tla.isoriginal = 1 AND tla.hotstart = 1 AND tla.state = 1 AND tr.`status` = 1
SELECT ir.id as rid, i.id, i.`name`, ir.logid, ir.isbelong, ir.isoriginal, ir.hotstart, i.is_hot, i.is_universal FROM {{inode}} i LEFT JOIN {{inode_live}} ir ON i.id = ir.nid WHERE ir.logid IN (328980) AND ir.isbelong = 1 AND i.`status` = 1 ORDER BY i.id DESC
SELECT uid,mid FROM {{medal_relation}} WHERE uid IN(2566207) ORDER BY id 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 * FROM `pre_column` `t` WHERE `t`.`id`='100819' LIMIT 1
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='328980' LIMIT 1
SELECT * FROM `pre_column` `t` WHERE `t`.`id`='101290' LIMIT 1
SELECT colid,classify FROM {{column_relation}} WHERE tocolid = 100825 AND classify IN ('belongx','belongs','belongd') order BY colid DESC
SELECT colid,classify FROM {{column_relation}} WHERE tocolid = 100819 AND classify IN ('belongx','belongs','belongd') order BY colid DESC
SELECT colid,classify FROM {{column_relation}} WHERE tocolid = 100002 AND classify IN ('belongx','belongs','belongd') order BY colid DESC
SELECT id,title FROM {{column}} WHERE id IN (0,100002,100819,100825,101290) ORDER BY FIELD(id, 0,100002,100819,100825,101290)
SELECT l.id, lc.cid, l.endtime FROM {{ad_launch}} l RIGHT JOIN {{ad_launch_cid}} lc ON l.id = lc.launch_id WHERE (l.classify = 'liveinfoimage' OR l.classify = 'articleandliveinfoimage') AND l.starttime <= 1722082671 AND l.endtime > 1722082671 AND lc.cid IN (100819,100825,101290) ORDER BY l.`order`, l.starttime DESC
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='328980' LIMIT 1
SELECT l.id, lc.cid, l.endtime FROM {{ad_launch}} l RIGHT JOIN {{ad_launch_cid}} lc ON l.id = lc.launch_id WHERE l.classify = 'liveInfoTop' AND l.starttime <= 1722082671 AND l.endtime > 1722082671 AND lc.cid IN (100819,100825,101290) ORDER BY l.`order`, l.starttime DESC
SELECT nid FROM {{inode_live_hot}} WHERE logid = 328980 AND isbelong = 1 AND hotstart = 1 AND state = 1
SELECT nid FROM {{inode_live_hot}} WHERE logid = 328980 AND hotstart = 2 AND state = 1
SHOW FULL COLUMNS FROM `pre_live_zan`
SHOW CREATE TABLE `pre_live_zan`
SELECT COUNT(*) FROM `pre_live_zan` `t` WHERE lid=:lid
SELECT * FROM `pre_column` `t` WHERE `t`.`id`='100819' LIMIT 1
SELECT count(*) as `count` FROM {{live_zan}} WHERE lid=328980 ORDER BY dateline DESC
SELECT uid FROM {{live_zan}} WHERE lid=328980 ORDER BY dateline DESC LIMIT :offset,:limit
SELECT `related` FROM {{live}} WHERE id=328980
SELECT * FROM {{live}} WHERE id IN (328989,328988,328984,328960,328983,328968,328966,328977,328978,328954,328976,328962,328981,328963,328965,328974,328971,328970,328955,328986,328958,328969,328957,328979,328975,328987,328961,328967,328973,328972)
SELECT tla.logid as lid,tr.`name`,tr.`id`,tr.`status` FROM {{inode_live}} tla INNER JOIN {{inode}} tr WHERE tla.nid=tr.id AND tla.logid IN (328954,328955,328957,328958,328960,328961,328962,328963,328965,328966,328967,328968,328969,328970,328971,328972,328973,328974,328975,328976,328977,328978,328979,328981,328983,328984,328986,328987,328988,328989) AND tla.isoriginal = 1 AND tr.status=1 ORDER BY FIELD (tla.logid, 328954,328955,328957,328958,328960,328961,328962,328963,328965,328966,328967,328968,328969,328970,328971,328972,328973,328974,328975,328976,328977,328978,328979,328981,328983,328984,328986,328987,328988,328989)
SELECT ir.id as rid, i.id, i.`name`, ir.logid, ir.isbelong, ir.isoriginal, ir.hotstart, i.is_hot, i.is_universal FROM {{inode}} i LEFT JOIN {{inode_live}} ir ON i.id = ir.nid WHERE ir.logid IN (328954,328955,328957,328958,328960,328961,328962,328963,328965,328966,328967,328968,328969,328970,328971,328972,328973,328974,328975,328976,328977,328978,328979,328981,328983,328984,328986,328987,328988,328989) AND ir.isbelong = 1 AND i.`status` = 1 ORDER BY i.id DESC
SELECT id,title FROM {{column}} WHERE id IN (101290)
SELECT * FROM {{live_hotel}} WHERE logid IN (328954,328955,328957,328958,328960,328961,328962,328963,328965,328966,328967,328968,328969,328970,328971,328972,328973,328974,328975,328976,328977,328978,328979,328981,328983,328984,328986,328987,328988,328989) AND `status` = 1 ORDER BY `order`
SELECT id, `name` FROM {{live_hotel_type}}
SELECT * FROM {{attachments}} WHERE logid IN(328954,328955,328957,328958,328960,328961,328962,328963,328965,328966,328967,328968,328969,328970,328971,328972,328973,328974,328975,328976,328977,328978,328979,328981,328983,328984,328986,328987,328988,328989) AND classify='live' ORDER BY id ASC
SELECT * FROM `pre_live_video` `t` WHERE logid IN (328954,328955,328957,328958,328960,328961,328962,328963,328965,328966,328967,328968,328969,328970,328971,328972,328973,328974,328975,328976,328977,328978,328979,328981,328983,328984,328986,328987,328988,328989) AND `status` = 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1
SELECT uid,mid FROM {{medal_relation}} WHERE uid IN(2566144,2566169,2566170,2566174,2566175,2566178,2566181,1649846,2566185,2566187,2566188,2566189,1227678,2566193,2566194,2566197,2566198,1709694,2566199,2566201,2521445,2566204,1762135,2566209,2566212,2566214,1596269,2566227,2566228,2566232) ORDER BY id DESC
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='328980' LIMIT 1
SELECT l.id, lc.cid FROM {{ad_launch}} l RIGHT JOIN {{ad_launch_cid}} lc ON l.id = lc.launch_id WHERE l.classify = 'liverelated' AND l.starttime <= 1722082671 AND l.endtime > 1722082671 AND lc.cid IN (101290,100819) ORDER BY l.`order`, l.starttime DESC
周末想避开人群，那一... - Leon_5807的「此刻」 - 十六番
