SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419798 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419798 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930729,253464,634985,504503,52593,78185,837497,986474,656796,511288,470018,665170,953056,280275,420395,37815,628819,914872,137405,152358,895788,120900,47615,9210,845799,149249,149905,841848,309810,369985,471172,471226,782472,343195,921383,225480,249065,618587,306694,126070,309129,624592,315578,181125,28419,1025823,753932,899613,37315,634057,869359,555139,11279,493216,927681,428239,620507,33331,956812,964104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]