SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58302 LIMIT 1 [ RunTime:0.000863s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58302 [ RunTime:0.002793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821981,1022388,868704,77438,50270,744257,687548,936480,671629,944383,543888,636866,837031,513324,535071,52664,17602,23112,756124,962689,370523,469269,452902,255004,190090,394189,168133,1015479,1028710,794914,29152,705451,604472,172631,192583,411616,410839,1013085,792830,716740,550188,823556,824124,83518,45243,427646,648486,149614,371601,146464,708185,72936,116001,140251,760064,173771,181387,223565,186603,533226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]