SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 830448 LIMIT 1 [ RunTime:0.000957s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 830448 [ RunTime:0.004012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455786,130419,661013,772378,986805,916498,562351,479433,662576,626941,502125,412271,445677,758327,691898,786738,653980,181593,28049,259106,914450,156613,471576,256126,526762,21192,867755,52457,417286,269573,559109,214246,179591,271733,762884,252165,182102,793111,386692,297512,954537,833101,4092,940167,10208,499100,589655,698900,953789,972891,219950,842506,527246,198990,585449,1035792,856500,754990,872012,678093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 830448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 830448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]