SHOW FULL COLUMNS FROM `pre_column`
SHOW CREATE TABLE `pre_column`
SELECT * FROM `pre_column` `t` WHERE `t`.`id`='100039' LIMIT 1
【华欣】 华欣攻略 - 华欣游记 - 此刻、约伴、问答 - 十六番
泰国华欣SELECT * FROM `pre_column` `t` WHERE `t`.`id`='100039' LIMIT 1
SELECT colid,classify FROM {{column_relation}} WHERE tocolid = 100421 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,100421,100039) ORDER BY FIELD(id, 0,100001,100003,100421,100039)