SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.003494s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 189767 LIMIT 1 [ RunTime:0.000812s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 189767 [ RunTime:0.004206s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.003793s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '189767' AND `j`.`switch` = '1' [ RunTime:0.007955s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001410s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('厦','房') AND `switch` = 1 [ RunTime:0.003270s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.004127s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '厦房' AND `switch` = 1 LIMIT 1 [ RunTime:0.002847s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('住宅','房屋','宅第','住宅楼','房产','居所','荒地','空地','野地','农田') AND `switch` = 1 [ RunTime:0.014361s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (69040,210389,160632,164468,10671,47385,191823,64734,229744,55392,34252,209909,204048,97564,53216,50735,228863,51642,156317,142924,211986,15042,27305,151467,133286,120640,108682,228496,55854,78483,49489,214261,95148,19266,166320,239246,229761,260824,221179,145296) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.009167s ]