SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029020 LIMIT 1 [ RunTime:0.001145s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029020 [ RunTime:0.002455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328295,663099,936176,809244,574412,757347,716737,527808,194475,979071,1001864,616640,445896,510958,83830,618100,908018,998188,575452,653283,210021,5818,1040094,1048184,152541,863670,308686,623377,792301,892756,345559,54830,413197,393474,856843,80109,291700,250123,358348,232370,824808,187122,478808,399145,395861,664443,775621,839100,619449,762064,516887,905382,677615,975406,613811,1005283,770365,374896,224014,907010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032779s ]