SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254668 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254668 [ RunTime:0.003017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379373,438681,13404,584922,144052,216927,410370,776066,308420,743265,1034421,670351,677448,563994,151602,692206,842486,309306,822456,460943,88851,548040,128122,171474,329828,148562,87230,254752,846125,812691,593147,142618,620410,742278,197196,872721,344315,780725,752103,160401,158766,290085,177673,722644,135285,680957,140546,519206,384397,571838,861534,576906,373340,528365,511310,680248,709042,520631,353434,669530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003434s ]