SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427510 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427510 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464463,263718,207866,993732,991745,17041,1017804,1025703,573437,549910,33114,13658,838413,969990,124060,161250,534930,1021779,1026229,359092,554799,182753,479193,1044694,550222,218015,929480,747886,811674,693711,834960,909049,450922,467868,275689,1013821,253320,190271,31646,134662,95663,902146,17960,468382,1011941,424382,836186,487719,227071,717598,873242,780454,43900,396446,438984,750158,976810,180629,476363,919756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000796s ]