SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538190 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538190 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951270,75071,579832,945123,304689,851101,841571,805121,186270,146523,464839,380663,487827,1043285,73093,368109,812398,691490,420696,75465,889895,33720,417381,147683,37037,609033,1040574,345374,767154,624978,809778,74635,593825,67396,432850,954318,963720,236396,502990,658122,324013,469741,541154,903553,545719,162135,864677,241991,567939,677241,227406,623762,888532,300133,644683,943685,110025,436022,1020276,62525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006980s ]