SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269001 LIMIT 1 [ RunTime:0.001061s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269001 [ RunTime:0.002329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596264,97228,2149,192064,362270,534644,977992,342261,107577,449813,315669,461464,711480,264923,692242,89253,823142,566667,817911,287442,320724,21807,290276,505169,604286,811296,1035423,234835,748680,665629,864070,995094,406290,1034912,731531,440059,222303,637481,160905,591794,339010,219011,830313,175899,759467,31795,177834,1006823,676183,810206,1047869,72040,757598,793124,527954,157527,371389,765963,841111,654837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]