SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576623 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576623 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266436,695784,710555,983664,107104,585283,986747,979981,207354,100476,1002978,798386,714127,348747,770390,79732,897783,892188,1030675,901294,153569,348092,187978,304565,602282,419936,300492,721659,355089,289646,580090,426755,653462,803907,615140,687172,216072,877696,831966,720279,95044,397890,708034,845888,711486,513135,624312,178751,624997,818584,364049,758015,551632,414343,298683,876213,624400,768432,563812,682701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002297s ]