SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255870 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255870 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185407,841956,422865,552973,556165,778522,903827,119066,1016891,237498,38296,253000,163984,649683,335689,366696,870046,828836,456267,198063,469311,973616,365972,340281,205502,58207,771761,324275,251470,148158,1030798,514565,867653,174806,610639,17387,987868,369844,860090,41878,63580,49575,196417,140502,325705,160344,880681,528802,104895,99106,452031,485262,756734,119037,139332,269302,481175,231396,143368,861854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]