SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495010 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495010 [ RunTime:0.002721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137962,65189,344046,841569,911381,864836,597083,348124,761895,137729,945034,442781,171970,282786,602614,590120,985165,446008,122887,163994,903095,446468,995737,468579,467212,314372,656879,430984,732738,471881,236198,676584,732363,572311,531644,73377,267736,297480,825875,282429,443357,960429,1020086,650541,638311,792171,42096,668839,264368,965042,803239,158421,98820,116724,615476,484824,409365,544622,350691,679997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]