SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 928081 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 928081 [ RunTime:0.003983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109871,414914,338524,59126,51064,661643,197168,745103,1025484,397175,401074,317870,958283,246599,491300,1033372,1014191,352015,1048193,561716,195750,574595,81841,695572,344060,737999,58582,753740,992688,352023,966853,303562,363632,314887,716249,284742,942991,289355,608396,964738,578889,83836,545694,817303,503314,534337,133896,212592,755895,469043,1007447,58543,757419,789092,710315,936815,765456,943399,205765,750337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 928081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 928081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]