SELECT id,comment_count,sortorder,`like`,`status`,uid,mark,init_time,noessence, classify, s_status, expire_at FROM {{live}} WHERE id=295858
SHOW FULL COLUMNS FROM `pre_live`
SHOW CREATE TABLE `pre_live`
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='295858' LIMIT 1
SHOW FULL COLUMNS FROM `pre_column`
SHOW CREATE TABLE `pre_column`
SELECT * FROM `pre_column` `t` WHERE `t`.`id`='101240' LIMIT 1
SELECT title, showname FROM {{column}} WHERE id = 101240
SELECT * FROM {{attachments}} WHERE classify='live' AND logid=295858 ORDER BY FIELD(id, 5558891,5558892,5558893,5558894,5558895,5558896,5558897,5558898)
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 (295858) 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 = 295858 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 (295858) AND ir.isbelong = 1 AND i.`status` = 1 ORDER BY i.id DESC
SELECT uid,mid FROM {{medal_relation}} WHERE uid IN(2160040) 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`='100849' LIMIT 1
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='295858' 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 <= 1721903086 AND l.endtime > 1721903086 AND lc.cid IN (100849,101240) ORDER BY l.`order`, l.starttime DESC
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='295858' 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 <= 1721903086 AND l.endtime > 1721903086 AND lc.cid IN (100849,101240) ORDER BY l.`order`, l.starttime DESC
SELECT nid FROM {{inode_live_hot}} WHERE logid = 295858 AND isbelong = 1 AND hotstart = 1 AND state = 1
SELECT nid FROM {{inode_live_hot}} WHERE logid = 295858 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`='100849' LIMIT 1
SELECT count(*) as `count` FROM {{live_zan}} WHERE lid=295858 ORDER BY dateline DESC
SELECT uid FROM {{live_zan}} WHERE lid=295858 ORDER BY dateline DESC LIMIT :offset,:limit
SELECT `related` FROM {{live}} WHERE id=295858
SELECT * FROM {{live}} WHERE id IN (295859,295860,295856,295857,441579,442493,442488,295156,294540,294349,295612,295149,295154,295183,442427,295186,294465,294544,294627,295598,295155,294291,294351,119482,295528,295638,295530,294286,294515,295602)
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 (119482,294286,294291,294349,294351,294465,294515,294540,294544,294627,295149,295154,295155,295156,295183,295186,295528,295530,295598,295602,295612,295638,295856,295857,295859,295860,441579,442427,442488,442493) AND tla.isoriginal = 1 AND tr.status=1 ORDER BY FIELD (tla.logid, 119482,294286,294291,294349,294351,294465,294515,294540,294544,294627,295149,295154,295155,295156,295183,295186,295528,295530,295598,295602,295612,295638,295856,295857,295859,295860,441579,442427,442488,442493)
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 (119482,294286,294291,294349,294351,294465,294515,294540,294544,294627,295149,295154,295155,295156,295183,295186,295528,295530,295598,295602,295612,295638,295856,295857,295859,295860,441579,442427,442488,442493) AND ir.isbelong = 1 AND i.`status` = 1 ORDER BY i.id DESC
SELECT logid, nid, `origin` FROM {{inode_position}} WHERE nid IN (175684,100791)
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 (175684,100791) AND ci.`status` = 1 AND ci.type = 'wenda'
SELECT id,title FROM {{column}} WHERE id IN (101240)
SELECT * FROM {{live_hotel}} WHERE logid IN (119482,294286,294291,294349,294351,294465,294515,294540,294544,294627,295149,295154,295155,295156,295183,295186,295528,295530,295598,295602,295612,295638,295856,295857,295859,295860,441579,442427,442488,442493) AND `status` = 1 ORDER BY `order`
SELECT id, `name` FROM {{live_hotel_type}}
SELECT * FROM {{attachments}} WHERE logid IN(119482,294286,294291,294349,294351,294465,294515,294540,294544,294627,295149,295154,295155,295156,295183,295186,295528,295530,295598,295602,295612,295638,295856,295857,295859,295860,441579,442427,442488,442493) AND classify='live' ORDER BY id ASC
SELECT * FROM `pre_live_video` `t` WHERE logid IN (119482,294286,294291,294349,294351,294465,294515,294540,294544,294627,295149,295154,295155,295156,295183,295186,295528,295530,295598,295602,295612,295638,295856,295857,295859,295860,441579,442427,442488,442493) 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(1330100,2143090,2143097,2145782,2145784,2146005,2146195,2146257,1915930,2146481,1685423,2151361,2151335,2151375,1562683,2151487,2157815,2145750,2158007,2158012,1671841,2158219,2160038,2160039,2160041,1746885,1875857,3155266,3155367,2615895) ORDER BY id DESC
SELECT * FROM `pre_live` `t` WHERE `t`.`id`='295858' 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 <= 1721903086 AND l.endtime > 1721903086 AND lc.cid IN (101240,100849) ORDER BY l.`order`, l.starttime DESC
博物馆不是很大~遗址... - 花瓶里的梦的「此刻」 - 十六番
