SELECT id,comment_count,sortorder,`like`,`status`,uid,mark,init_time,noessence, classify, s_status, expire_at FROM {{live}} WHERE id=483691
SHOW FULL COLUMNS FROM `pre_live`
SHOW CREATE TABLE `pre_live`
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='483691' LIMIT 1
SHOW FULL COLUMNS FROM `pre_column`
SHOW CREATE TABLE `pre_column`
SELECT * FROM `pre_column` `t` WHERE `t`.`id`='100802' LIMIT 1
SELECT title, showname FROM {{column}} WHERE id = 100802
SELECT * FROM {{attachments}} WHERE classify='live' AND logid=483691 ORDER BY FIELD(id, 8345475,8345476,8345477,8345478,8345479,8345480)
SHOW FULL COLUMNS FROM `pre_live_video`
SHOW CREATE TABLE `pre_live_video`
SELECT * FROM `pre_live_video` `t` WHERE logid IN (483691) 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 = 483691 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 (483691) AND ir.isbelong = 1 AND i.`status` = 1 ORDER BY i.id DESC
SELECT uid,mid FROM {{medal_relation}} WHERE uid IN(3335744) 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`='100799' LIMIT 1
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='483691' 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 = 'liveinfoimage' OR l.classify = 'articleandliveinfoimage') AND l.starttime <= 1722032837 AND l.endtime > 1722032837 AND lc.cid IN (100799,100802) ORDER BY l.`order`, l.starttime DESC
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='483691' 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 <= 1722032837 AND l.endtime > 1722032837 AND lc.cid IN (100799,100802) ORDER BY l.`order`, l.starttime DESC
SELECT nid FROM {{inode_live_hot}} WHERE logid = 483691 AND isbelong = 1 AND hotstart = 1 AND state = 1
SELECT nid FROM {{inode_live_hot}} WHERE logid = 483691 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`='100799' LIMIT 1
SELECT count(*) as `count` FROM {{live_zan}} WHERE lid=483691 ORDER BY dateline DESC
SELECT uid FROM {{live_zan}} WHERE lid=483691 ORDER BY dateline DESC LIMIT :offset,:limit
SELECT `related` FROM {{live}} WHERE id=483691
SELECT * FROM {{live}} WHERE id IN (483692,483681,483690,483685,483688,483684,483689,483686,483687,482204,481202,482130,481780,217604,483169,217648,217231,217670,217743,217704,217207,481396,482912,482440,481275,481707,482457,217588,481432,482047)
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 (217207,217231,217588,217604,217648,217670,217704,217743,481202,481275,481396,481432,481707,481780,482047,482130,482204,482440,482457,482912,483169,483681,483684,483685,483686,483687,483688,483689,483690,483692) AND tla.isoriginal = 1 AND tr.status=1 ORDER BY FIELD (tla.logid, 217207,217231,217588,217604,217648,217670,217704,217743,481202,481275,481396,481432,481707,481780,482047,482130,482204,482440,482457,482912,483169,483681,483684,483685,483686,483687,483688,483689,483690,483692)
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 (217207,217231,217588,217604,217648,217670,217704,217743,481202,481275,481396,481432,481707,481780,482047,482130,482204,482440,482457,482912,483169,483681,483684,483685,483686,483687,483688,483689,483690,483692) AND ir.isbelong = 1 AND i.`status` = 1 ORDER BY i.id DESC
SELECT id,title FROM {{column}} WHERE id IN (100802)
SELECT * FROM {{live_hotel}} WHERE logid IN (217207,217231,217588,217604,217648,217670,217704,217743,481202,481275,481396,481432,481707,481780,482047,482130,482204,482440,482457,482912,483169,483681,483684,483685,483686,483687,483688,483689,483690,483692) AND `status` = 1 ORDER BY `order`
SELECT id, `name` FROM {{live_hotel_type}}
SELECT * FROM {{attachments}} WHERE logid IN(217207,217231,217588,217604,217648,217670,217704,217743,481202,481275,483684,483686,483687,483688,483689,483690,483692) AND classify='live' ORDER BY id ASC
SELECT * FROM `pre_live_video` `t` WHERE logid IN (217207,217231,217588,217604,217648,217670,217704,217743,481202,481275,481396,481432,481707,481780,482047,482130,482204,482440,482457,482912,483169,483681,483684,483685,483686,483687,483688,483689,483690,483692) 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(1675458,1675485,1675844,1675854,1675884,1569468,1228943,1601484,3329343,3001604,3329971,3330071,3330510,3331904,3334325,3334229,2619712,3334911,3335103,1857183,3334693,3338760,3338761,3338762,3338763,3338764,3338766,3338767,3247401,3338768) ORDER BY id DESC
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='483691' 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 <= 1722032837 AND l.endtime > 1722032837 AND lc.cid IN (100802,100799) ORDER BY l.`order`, l.starttime DESC
一家很多人都在推荐的... - 迪迪猫_9380的「此刻」 - 十六番
