SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029679 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029679 [ RunTime:0.003286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723801,247038,910349,562117,391262,50345,406644,57431,459926,10772,6926,739130,706171,1005808,999596,180297,895501,777274,958596,539818,556622,363222,852024,850359,169897,255769,654061,11891,689007,998305,546507,83350,643964,929540,856070,873277,1018271,149311,963051,864321,257442,881320,412982,1010155,119684,219051,344902,660409,271081,320295,590194,859981,607065,10472,517591,211684,34904,451526,1031239,87298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001305s ]