SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001314s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 20343 LIMIT 1 [ RunTime:0.000927s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 20343 [ RunTime:0.002599s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.000986s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '20343' AND `j`.`switch` = '1' [ RunTime:0.003744s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001359s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('地','室') AND `switch` = 1 [ RunTime:0.001101s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.000910s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '地室' AND `switch` = 1 LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('地下室','地下宅','地底室','地底层','地底房间','地窖','地面','地面层','楼上','上层') AND `switch` = 1 [ RunTime:0.002302s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (230245,133624,221957,131786,209341,398,18956,133187,197204,247103,65690,185582,27713,208503,66469,122309,133393,41674,223647,234590,141741,106017,118208,205117,76955,16918,97884,15663,197965,74691,109792,171192,249618,56285,95304,179063,152612,43862,128786,152082) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.027143s ]