SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985048 LIMIT 1 [ RunTime:0.003963s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985048 [ RunTime:0.001363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465309,782570,216570,1039446,419981,195137,512576,550571,18240,117972,550994,65295,763685,793502,265947,429715,506522,553660,1045600,268490,522780,57104,639260,211041,256782,428373,763940,476852,23102,615561,458779,714352,284058,162375,386057,309923,372938,90571,396944,781256,673427,571548,358919,350891,252056,356182,872329,804665,209614,874341,945596,310441,940833,4918,142003,927041,214625,250276,10693,640269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]