SHOW FULL COLUMNS FROM `pre_column`
SHOW CREATE TABLE `pre_column`
SELECT * FROM `pre_column` `t` WHERE `t`.`id`='100054' LIMIT 1
【象岛】 象岛攻略 - 象岛游记 - 此刻、约伴、问答 - 十六番
泰国象岛SELECT * FROM `pre_column` `t` WHERE `t`.`id`='100054' LIMIT 1
SELECT colid,classify FROM {{column_relation}} WHERE tocolid = 100423 AND classify IN ('belongx','belongs','belongd') order BY colid DESC
SELECT colid,classify FROM {{column_relation}} WHERE tocolid = 100003 AND classify IN ('belongx','belongs','belongd') order BY colid DESC
SELECT colid,classify FROM {{column_relation}} WHERE tocolid = 100001 AND classify IN ('belongx','belongs','belongd') order BY colid DESC
SELECT id,title FROM {{column}} WHERE id IN (0,100001,100003,100423,100054) ORDER BY FIELD(id, 0,100001,100003,100423,100054)