SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001076s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 42423 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 42423 [ RunTime:0.002185s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.000947s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '42423' AND `j`.`switch` = '1' [ RunTime:0.002310s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001071s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('街','道','树') AND `switch` = 1 [ RunTime:0.001891s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.000978s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '街道树' AND `switch` = 1 LIMIT 1 [ RunTime:0.001131s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('街心花园','市区绿化','城市绿化','都市绿化','城市景观','城市美化','城市建筑','城市道路') AND `switch` = 1 [ RunTime:0.001867s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (15376,199522,145182,139968,159891,74044,210037,68072,37342,18235,190178,143014,190173,228021,1878,104025,75651,80086,168145,229653,13257,23567,241822,161398,252280,139054,47861,63971,149284,184108,18938,107875,238173,169558,116320,889,229399,73681,121387,99884) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.011687s ]