SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985302 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985302 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431196,1012091,593944,102150,787496,563627,940274,418468,863220,933548,500583,1011313,686958,734500,897078,746665,133347,567198,512237,636799,321157,582699,380182,180464,338626,906040,700033,971544,1043026,93835,1029974,876894,54501,758046,1007861,137702,710495,730287,561667,65588,91092,830893,929944,741331,617057,742108,722662,766833,737403,659505,26613,530980,836273,316420,118940,1035852,3271,340928,618191,591339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]