SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314001 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314001 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005899,301585,502742,304703,70835,674197,212999,997206,511785,152419,596510,717985,348021,849323,1010352,478186,82981,410051,451067,859002,1041446,464307,541066,629991,804012,30983,864008,609218,805813,776645,967387,1013171,966470,558398,197721,81065,892637,99512,183716,976017,916535,1041554,915419,295541,476602,175661,805919,405538,870243,480402,66624,997459,485720,408782,73540,62690,291210,806428,104335,212841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]