SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516410 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516410 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172478,974218,1024078,976276,323479,990892,625533,270740,715457,422309,31199,1011709,796336,783846,741176,978487,654624,665896,692080,899353,596716,326727,621742,329339,424154,998498,189307,478553,896374,318913,592361,597109,924802,919360,524378,482464,711238,603013,463739,901012,291083,217659,698405,818027,147774,644010,274522,385509,1032627,101425,341120,41890,320649,373066,772761,974015,112755,813850,175214,841681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]