SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 611438 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 611438 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011833,704425,421204,392099,428233,164728,171618,272659,267523,647630,859392,623994,542033,452391,644014,346393,68239,31829,682827,53326,804125,1001055,240867,520578,87202,753391,560275,982297,851566,942449,177380,495567,49112,720798,260911,747702,180965,680935,1038291,556933,464928,412528,591253,93147,611177,355781,145614,685185,678215,766497,658260,198498,428882,899973,975053,302042,482673,359680,41787,593659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 611438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 611438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]