SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.002341s ]
SELECT `id`,`ci`,`fyc`,`cj` FROM `tool_jfc` WHERE `id` = 92017 AND `switch` = 1 LIMIT 1 [ RunTime:0.003322s ]
UPDATE `tool_jfc` SET `pv` = `pv` + 1 WHERE `id` = 92017 [ RunTime:0.006189s ]
SELECT `id`,`ci`,`cj` FROM `tool_jfc` WHERE `ci` IN ('进货','收货','入库') [ RunTime:0.005357s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001457s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('出','货') AND `switch` = 1 [ RunTime:0.001639s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `id` IN (185630,19749,28647,116136,37804,124461,52192,45,139064,94589,161480,38389,186577,91615,39078,100521,144881,61232,46511,70552,53523,105116,175886,76930,49877,94993,7854,121257,102003,48973,70137,72545,111725,59965,70096,90473,157739,114784,79409,174269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024223s ]