SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41883 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41883 [ RunTime:0.004155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546525,84194,612300,818225,287632,939775,21806,944037,413083,574083,539081,155421,3429,791110,279066,361013,281204,865397,940090,478449,862493,142750,767950,229980,356840,1038390,838709,12627,941073,594202,471640,914321,1025396,627747,948602,690452,827503,356864,608737,452950,551428,72199,405814,246688,80383,647663,906228,760338,922223,580210,694863,958835,1027470,902733,1045600,769770,269277,268568,419214,44850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]