SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477846 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477846 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344501,664505,202723,609752,599997,650063,182411,913957,272548,643499,632590,989219,262758,656301,342036,1014640,793553,213868,59141,503326,799644,250277,924926,53873,1026174,674389,341491,756157,256867,1017166,996362,1031641,579870,236093,444135,746944,874990,743418,149069,285840,456761,292551,287435,783843,1024532,1023124,469712,624929,653324,280700,749199,991468,287149,671256,972104,455048,524988,138070,70559,359931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]