SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485040 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485040 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779240,760560,1015379,237163,977883,960028,302161,517844,618598,481768,825199,800022,386597,930734,592548,468264,820882,171170,242300,115020,747599,140150,439132,424690,383555,986688,453853,983640,820242,591260,484957,460045,1002327,572804,780074,28796,734204,529898,833745,434501,901589,769780,861792,193464,60782,99005,192461,368827,626387,620987,557244,89979,962385,767521,676847,187863,421089,82374,890157,649578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]