SELECT id,comment_count,sortorder,`like`,`status`,uid,mark,init_time,noessence, classify, s_status, expire_at FROM {{live}} WHERE id=376107 SHOW FULL COLUMNS FROM `pre_live` SHOW CREATE TABLE `pre_live` SELECT * FROM `pre_live` `t` WHERE `t`.`id`='376107' LIMIT 1 SHOW FULL COLUMNS FROM `pre_column` SHOW CREATE TABLE `pre_column` SELECT * FROM `pre_column` `t` WHERE `t`.`id`='100825' LIMIT 1 SELECT title, showname FROM {{column}} WHERE id = 100825 SHOW FULL COLUMNS FROM `pre_live_video` SHOW CREATE TABLE `pre_live_video` SELECT * FROM `pre_live_video` `t` WHERE logid IN (376107) 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 = 376107 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 (376107) AND ir.isbelong = 1 AND i.`status` = 1 ORDER BY i.id DESC SELECT uid,mid FROM {{medal_relation}} WHERE uid IN(2772459) 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`='376107' 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 <= 1721961339 AND l.endtime > 1721961339 AND lc.cid IN (100819,100825) ORDER BY l.`order`, l.starttime DESC SELECT * FROM `pre_live` `t` WHERE `t`.`id`='376107' 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 <= 1721961339 AND l.endtime > 1721961339 AND lc.cid IN (100819,100825) ORDER BY l.`order`, l.starttime DESC SELECT nid FROM {{inode_live_hot}} WHERE logid = 376107 AND isbelong = 1 AND hotstart = 1 AND state = 1 SELECT nid FROM {{inode_live_hot}} WHERE logid = 376107 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=376107 ORDER BY dateline DESC SELECT uid FROM {{live_zan}} WHERE lid=376107 ORDER BY dateline DESC LIMIT :offset,:limit SELECT `related` FROM {{live}} WHERE id=376107 SELECT * FROM {{live}} WHERE id IN (194579,194582,376111,194580,376118,376116,194585,376109,194577,194581,194584,194583,376108,194586,193394,374429,189463,190636,454555,189453,373935,274445,305269,189511,373461,377637,191292,433451,273990,190606) 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 (189453,189463,189511,190606,190636,191292,193394,194577,194579,194580,194581,194582,194583,194584,194585,194586,273990,274445,305269,373461,373935,374429,376108,376109,376111,376116,376118,377637,433451,454555) AND tla.isoriginal = 1 AND tr.status=1 ORDER BY FIELD (tla.logid, 189453,189463,189511,190606,190636,191292,193394,194577,194579,194580,194581,194582,194583,194584,194585,194586,273990,274445,305269,373461,373935,374429,376108,376109,376111,376116,376118,377637,433451,454555) 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 (189453,189463,189511,190606,190636,191292,193394,194577,194579,194580,194581,194582,194583,194584,194585,194586,273990,274445,305269,373461,373935,374429,376108,376109,376111,376116,376118,377637,433451,454555) AND ir.isbelong = 1 AND i.`status` = 1 ORDER BY i.id DESC SELECT id,title FROM {{column}} WHERE id IN (100825) SELECT * FROM {{live_hotel}} WHERE logid IN (189453,189463,189511,190606,190636,191292,193394,194577,194579,194580,194581,194582,194583,194584,194585,194586,273990,274445,305269,373461,373935,374429,376108,376109,376111,376116,376118,377637,433451,454555) AND `status` = 1 ORDER BY `order` SELECT id, `name` FROM {{live_hotel_type}} SELECT * FROM {{attachments}} WHERE logid IN(189453,189463,189511,190606,190636,191292,193394,194577,194579,194580,194581,194582,194583,194584,194585,194586,273990,274445,305269,373935,376111,376116,433451) AND classify='live' ORDER BY id ASC SELECT * FROM `pre_live_video` `t` WHERE logid IN (189453,189463,189511,190606,190636,191292,193394,194577,194579,194580,194581,194582,194583,194584,194585,194586,273990,274445,305269,373461,373935,374429,376108,376109,376111,376116,376118,377637,433451,454555) 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(1647301,1647310,1647352,1624099,1596371,1649267,1651890,1652818,1652819,1652820,1652821,1652822,1652823,1652824,1652825,1633993,1903610,1606412,2434944,2698820,1648211,2766813,2772462,1227117,2772463,2772467,1227116,2764805,3110056,3187221) ORDER BY id DESC SELECT * FROM `pre_live` `t` WHERE `t`.`id`='376107' 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 <= 1721961340 AND l.endtime > 1721961340 AND lc.cid IN (100825,100819) ORDER BY l.`order`, l.starttime DESC