SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438341 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438341 [ RunTime:0.003284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225486,928033,352148,826728,995187,531072,460343,921080,775478,422114,449045,99176,849224,54796,154239,851199,795842,140389,317436,803205,401178,802524,39700,916886,726016,167550,250320,682412,277278,787958,198655,976807,477981,104364,12205,422738,296140,883223,123800,178963,555607,845199,340975,221174,663391,965104,312444,320577,638682,889118,10544,234394,674005,807797,698723,551561,544858,85916,472483,535468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]