SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001151s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 191247 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 191247 [ RunTime:0.003802s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.000865s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '191247' AND `j`.`switch` = '1' [ RunTime:0.005743s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001308s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('虚','舍') AND `switch` = 1 [ RunTime:0.000500s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.000859s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '虚舍' AND `switch` = 1 LIMIT 1 [ RunTime:0.001752s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('空屋','空房','空置房','空房子','空房间','实舍','有主','有人居住') AND `switch` = 1 [ RunTime:0.001542s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` > 191247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000857s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (20704,221104,227276,225432,10793,193018,258806,113662,178719,107404,258274,50272,61469,164758,164592,202904,85457,49557,92955,163646,19684,56105,234561,215515,124265,210632,160522,245937,239105,41727,225320,95162,163805,146989,179324,158657,117604,52579,6639,2659) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.007587s ]