SELECT id,comment_count,sortorder,`like`,`status`,uid,mark,init_time,noessence, classify, s_status, expire_at FROM {{live}} WHERE id=297533 SHOW FULL COLUMNS FROM `pre_live` SHOW CREATE TABLE `pre_live` SELECT * FROM `pre_live` `t` WHERE `t`.`id`='297533' LIMIT 1 SHOW FULL COLUMNS FROM `pre_column` SHOW CREATE TABLE `pre_column` SELECT * FROM `pre_column` `t` WHERE `t`.`id`='100073' LIMIT 1 SELECT title, showname FROM {{column}} WHERE id = 100073 SELECT * FROM {{attachments}} WHERE classify='live' AND logid=297533 ORDER BY FIELD(id, 5587298,5587299,5587300,5587301,5587302,5587303,5587304,5587305,5587306) 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 (297533) 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 = 297533 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 (297533) AND ir.isbelong = 1 AND i.`status` = 1 ORDER BY i.id DESC SELECT uid,mid FROM {{medal_relation}} WHERE uid IN(1563013) 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`='100073' LIMIT 1 SELECT * FROM `pre_live` `t` WHERE `t`.`id`='297533' 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 <= 1722048598 AND l.endtime > 1722048598 AND lc.cid IN (100017,100073) ORDER BY l.`order`, l.starttime DESC SELECT * FROM `pre_live` `t` WHERE `t`.`id`='297533' 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 <= 1722048598 AND l.endtime > 1722048598 AND lc.cid IN (100017,100073) ORDER BY l.`order`, l.starttime DESC SELECT nid FROM {{inode_live_hot}} WHERE logid = 297533 AND isbelong = 1 AND hotstart = 1 AND state = 1 SELECT nid FROM {{inode_live_hot}} WHERE logid = 297533 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`='100017' LIMIT 1 SELECT count(*) as `count` FROM {{live_zan}} WHERE lid=297533 ORDER BY dateline DESC SELECT uid FROM {{live_zan}} WHERE lid=297533 ORDER BY dateline DESC LIMIT :offset,:limit SELECT `related` FROM {{live}} WHERE id=297533 SELECT * FROM {{live}} WHERE id IN (297537,297541,297532,297536,297542,297527,297530,297539,297528,297538,297540,297534,297529,297531,296451,297446,143099,296009,297219,296693,298177,297555,296062,297069,296743,296066,296482,297550,299257,142246) 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 (142246,143099,296009,296062,296066,296451,296482,296693,296743,297069,297219,297446,297527,297528,297529,297530,297531,297532,297534,297536,297537,297538,297539,297540,297541,297542,297550,297555,298177,299257) AND tla.isoriginal = 1 AND tr.status=1 ORDER BY FIELD (tla.logid, 142246,143099,296009,296062,296066,296451,296482,296693,296743,297069,297219,297446,297527,297528,297529,297530,297531,297532,297534,297536,297537,297538,297539,297540,297541,297542,297550,297555,298177,299257) 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 (142246,143099,296009,296062,296066,296451,296482,296693,296743,297069,297219,297446,297527,297528,297529,297530,297531,297532,297534,297536,297537,297538,297539,297540,297541,297542,297550,297555,298177,299257) AND ir.isbelong = 1 AND i.`status` = 1 ORDER BY i.id DESC SELECT logid, nid, `origin` FROM {{inode_position}} WHERE nid IN (314027,313695,313676,310441,307133,305071,305068,304861,298755,180809,180204,179144,178725,177340,173373,101882,101800,101796,101790,101036,100446,100127,100126,100043,100037,100036,100035,100007) SELECT ci.cid, ci.aid FROM {{city_index_associated}} ci LEFT JOIN {{column}} c ON ci.cid = c.id WHERE c.theorder >= 2 AND ci.aid IN (314027,313695,313676,310441,307133,305071,305068,304861,298755,180809,180204,179144,178725,177340,173373,101882,101800,101796,101790,101036,100446,100127,100126,100043,100037,100036,100035,100007) AND ci.`status` = 1 AND ci.type = 'wenda' SELECT id,`theorder` FROM {{column}} WHERE `title` = '东京' OR `showname` = '东京' SELECT `name`, link FROM {{hotellink}} WHERE aid = 100073 AND `status` = 1 AND `type` = 'hotel' AND `order` = 1 SELECT id,`theorder` FROM {{column}} WHERE `title` = '日本' OR `showname` = '日本' SELECT `name`, link FROM {{hotellink}} WHERE aid = 100017 AND `status` = 1 AND `type` = 'hotel' AND `order` = 1 SELECT `name`, link FROM {{hotellink}} WHERE aid = 100000 AND `status` = 1 AND `type` = 'hotel' AND `order` = 1 SELECT id,title FROM {{column}} WHERE id IN (100073) SELECT * FROM {{live_hotel}} WHERE logid IN (142246,143099,296009,296062,296066,296451,296482,296693,296743,297069,297219,297446,297527,297528,297529,297530,297531,297532,297534,297536,297537,297538,297539,297540,297541,297542,297550,297555,298177,299257) AND `status` = 1 ORDER BY `order` SELECT id, `name` FROM {{live_hotel_type}} SELECT * FROM {{attachments}} WHERE logid IN(142246,143099,296009,296062,296066,296451,296482,296693,296743,297069,297219,297446,297527,297528,297529,297530,297531,297532,297534,297536,297537,297538,297539,297540,297541,297542,297550,297555,298177,299257) AND classify='live' ORDER BY id ASC SELECT * FROM `pre_live_video` `t` WHERE logid IN (142246,143099,296009,296062,296066,296451,296482,296693,296743,297069,297219,297446,297527,297528,297529,297530,297531,297532,297534,297536,297537,297538,297539,297540,297541,297542,297550,297555,298177,299257) 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 uid,mid FROM {{medal_relation}} WHERE uid IN(1562476,1563228,2164100,1563005,2164222,2168179,2168248,2010921,2168799,2170390,2171545,2172218,2172147,2173171,1647552,2171973,2173176,2173179,2173183,2173184,2173186,2173187,2173191,2168255,2173196,2173230,2173236,2176986,2184708) ORDER BY id DESC SELECT * FROM `pre_live` `t` WHERE `t`.`id`='297533' 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 <= 1722048598 AND l.endtime > 1722048598 AND lc.cid IN (100073,100017) ORDER BY l.`order`, l.starttime DESC