SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.002311s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 117908 LIMIT 1 [ RunTime:0.000541s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 117908 [ RunTime:0.001839s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.001012s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '117908' AND `j`.`switch` = '1' [ RunTime:0.019368s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.002579s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('山','墅') AND `switch` = 1 [ RunTime:0.003134s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.001200s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '山墅' AND `switch` = 1 LIMIT 1 [ RunTime:0.001001s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('山庄','山居','山宅','山庭','山园','城市公寓','城市住宅') AND `switch` = 1 [ RunTime:0.000840s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (22338,211181,110085,134784,166935,217795,156542,46255,205183,123085,24421,5958,225093,36878,104742,113991,64898,234816,5601,147285,152568,57115,180836,239402,57917,23563,109160,8369,136388,29727,175388,198875,6837,112390,138797,258725,28475,161787,189149,32528) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001257s ]