SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416941 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416941 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200304,714206,254296,210670,1388,786046,998531,393445,347395,470863,1034612,109610,178422,199572,852999,150229,711896,1046249,568684,302685,831289,647800,713095,409493,945275,915040,958667,245832,215998,388676,468281,995928,711771,329829,249681,554425,357494,968867,843753,559895,556440,133587,485598,930155,83011,1044251,678130,265282,997756,28679,880229,562421,904705,661387,138758,667044,998492,616801,275736,112039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000391s ]