SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001912s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 194063 LIMIT 1 [ RunTime:0.001716s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 194063 [ RunTime:0.004442s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.001039s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '194063' AND `j`.`switch` = '1' [ RunTime:0.003515s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001566s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('衣','廪') AND `switch` = 1 [ RunTime:0.002324s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.001225s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '衣廪' AND `switch` = 1 LIMIT 1 [ RunTime:0.001179s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('库房','仓库','仓廪','需求','购买','采购') AND `switch` = 1 [ RunTime:0.005548s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (91277,25235,174282,119731,70239,158731,90454,77169,258791,62688,75061,35834,29144,225469,230658,62710,243206,70107,157674,144663,126463,89994,103302,147812,64517,77453,27682,248539,40865,248147,216818,233931,93195,182788,192701,47777,120025,42821,95801,72125) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.005574s ]