SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30319 LIMIT 1 [ RunTime:0.001672s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30319 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299999,130014,851129,11418,99042,604361,444219,515317,578962,475211,512200,324167,485167,933713,649370,442148,907694,169266,837334,69551,566845,636531,387711,622618,95100,898982,1013,603679,307470,947043,520808,612372,840306,515767,989901,840863,833474,691122,720453,682329,250589,41499,731907,556260,81788,32443,1048860,87473,598301,354948,778034,200919,894640,980726,516891,771682,56545,149548,1030410,383389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018240s ]