SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501844 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501844 [ RunTime:0.002275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267613,424713,790278,258146,663328,956199,777294,372338,1013032,125318,933972,126245,431523,121477,686066,127109,124622,605515,831251,34331,117523,652265,365030,227941,411154,731054,764837,627437,348408,655623,854521,411607,449992,1043489,405887,630187,692156,169767,159657,413139,58052,742747,778934,679695,961488,350350,141266,297283,632673,516997,192666,749209,225701,976990,671934,507842,47737,546086,964731,107558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]