SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001713s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419333 LIMIT 1 [ RunTime:0.001824s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419333 [ RunTime:0.003562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380935,138118,195438,134586,869094,107308,76526,528850,251401,294423,942268,373598,735932,101909,160217,275888,149085,821953,81614,890441,295853,509323,377022,171328,388560,95515,57517,424509,543412,427129,218096,269476,875275,126368,37245,513493,697884,721635,441321,602533,694834,550764,145688,845403,832114,272862,790975,758249,719391,934961,943211,750659,873752,450556,704551,477520,722439,359298,918839,14732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419333 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419333 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]