SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419209 LIMIT 1 [ RunTime:0.000667s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419209 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007055,197509,26482,11319,694199,945556,772374,81274,1027195,50611,1005541,134273,966777,668736,194400,297221,764501,304662,236132,745287,839416,424531,603724,530009,1046393,448416,574960,912639,978464,381362,667610,87852,163335,465101,916610,5843,676556,247050,1030325,770537,201313,259324,172095,596198,261493,166298,717323,537039,703585,714872,837361,276308,691387,141826,1017392,824907,215442,811974,194830,290228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]