SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.006262s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 123543 LIMIT 1 [ RunTime:0.001112s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 123543 [ RunTime:0.005434s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.001737s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '123543' AND `j`.`switch` = '1' [ RunTime:0.012197s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001345s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('楼','舍') AND `switch` = 1 [ RunTime:0.002891s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.001098s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '楼舍' AND `switch` = 1 LIMIT 1 [ RunTime:0.002435s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('房屋','建筑物','住宅','房子','院落','宅邸','筑室','楼房','居所','屋舍','空地') AND `switch` = 1 [ RunTime:0.005575s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (156622,13467,210599,186992,159871,61892,188689,152195,25006,64614,260670,166904,39857,190681,200915,174406,186726,180942,35850,136303,246277,63107,217248,144532,59125,219137,47079,5860,76327,72151,222176,129906,139509,114724,153658,220110,199314,146578,121208,121038) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.033045s ]