SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 67571 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 67571 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88553,4750,636439,92835,426235,16979,614742,64771,144468,807260,351396,1024991,1023290,286995,294039,381946,209820,100464,553190,223966,519214,398109,381442,867068,1009756,55207,336537,384465,918521,264640,822998,168632,267502,111481,175253,564696,458332,13475,339468,483482,904726,247129,340896,575728,605322,45863,317818,3251,1001407,389278,917172,652662,646357,558125,887364,699131,828593,906451,592938,861568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 67571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 67571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]