SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001057s ]
SELECT `id`,`zc`,`zcpy`,`zcpywu`,`zczy`,`zcszm`,`cx`,`zcjs`,`wljs`,`views`,`switch`,`updatetime`,`createtime` FROM `tool_zc` WHERE `switch` = 1 AND `id` = 195897 LIMIT 1 [ RunTime:0.001319s ]
UPDATE `tool_zc` SET `views` = `views` + 1 WHERE `id` = 195897 [ RunTime:0.002094s ]
SHOW FULL COLUMNS FROM `tool_zc_zj` [ RunTime:0.000869s ]
SELECT `j`.`jz` FROM `tool_zc_zj` `c` INNER JOIN `tool_jzdq` `j` ON `c`.`zid`=`j`.`id` WHERE `c`.`cid` = '195897' AND `j`.`switch` = '1' [ RunTime:0.002343s ]
SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001210s ]
SELECT `id`,`zi` FROM `tool_hanzi` WHERE `zi` IN ('余','货') AND `switch` = 1 [ RunTime:0.001182s ]
SHOW FULL COLUMNS FROM `tool_jfc` [ RunTime:0.000919s ]
SELECT `jyc`,`fyc` FROM `tool_jfc` WHERE `ci` = '余货' AND `switch` = 1 LIMIT 1 [ RunTime:0.001221s ]
SELECT `id`,`ci` FROM `tool_jfc` WHERE `ci` IN ('存货','剩余物品','尾货','尾款','余额','缺货','售罄','空缺') AND `switch` = 1 [ RunTime:0.000562s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (159360,43237,33436,27276,64528,212924,149359,64733,120666,100252,152671,144581,99283,81789,21053,72160,98126,34422,105721,177656,232968,226714,254769,161553,247765,202761,64901,260373,40455,184145,256940,211154,124966,132996,161651,90166,71610,75681,13644,78525) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.003711s ]