SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48151 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48151 [ RunTime:0.002667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543526,443462,612702,591419,1036133,253311,583906,218537,221896,168017,92521,801795,516886,358957,948177,25432,255853,770111,604397,329955,324429,629289,485676,858989,139142,1045090,953392,756736,173952,934112,341249,357153,818634,844329,698489,460036,97912,767096,190269,442217,302381,883770,331481,460437,453927,872687,545126,1018245,783050,152942,518001,335615,358985,994107,507401,656176,1048538,585558,644862,155401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]