SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406689 LIMIT 1 [ RunTime:0.000917s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406689 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593569,394200,101317,659165,754786,981075,431729,382153,816443,419052,282139,575832,66950,370268,636055,273172,131400,169748,964347,578563,364064,866167,653740,692587,700343,495635,933283,380878,560309,978972,93680,455403,187011,629162,145665,290068,197859,971802,263214,921981,423201,345747,1018101,923222,909301,841696,629294,149783,585035,757052,963637,290192,90224,639151,738886,404585,742176,1038815,52585,832082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]