SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.006330s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 47846 LIMIT 1 [ RunTime:0.002549s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 47846 [ RunTime:0.014181s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.007957s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '47846' AND `j`.`switch` = '1' [ RunTime:0.021929s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.003894s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('边','房') AND `switch` = 1 [ RunTime:0.014224s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.006939s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '边房' AND `switch` = 1 LIMIT 1 [ RunTime:0.006477s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('旁房','侧房','邻房','隔壁房间','主房','中央房','正房','中房') AND `switch` = 1 [ RunTime:0.002451s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (127432,108502,253776,191242,100180,248651,130791,41388,24219,31295,176408,127736,245755,63995,193289,173665,171960,157940,177565,35388,245907,206254,228256,49798,214672,69409,130930,250772,252889,150277,254611,22392,222548,13137,73273,161311,73625,7040,93412,141294) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.007341s ]