SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502117 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502117 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483420,971553,559960,217134,990428,623261,9987,389915,321640,99590,927889,279897,898347,342937,1027409,812437,686031,46412,503729,325258,997212,750391,604972,109983,708751,702731,566820,62622,56588,184123,835733,502901,402247,308486,765538,734455,931699,738545,752918,1003687,936995,488854,329589,22418,257609,248500,102896,906453,555937,162429,94628,149680,755443,882456,283831,605896,734631,195220,388439,1001553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]