SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458753 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458753 [ RunTime:0.002711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190430,987469,1018040,932990,542554,201014,544102,224146,545868,113511,425604,542548,115303,418168,950143,794931,276088,909678,343388,257910,856387,917924,444616,434855,308704,548285,902051,945450,138314,314863,212260,924444,817799,285385,977967,230365,278337,653931,999182,751563,713079,396960,973472,593996,145365,989069,908330,103701,555446,234744,36382,345363,667133,691403,916866,581365,336002,719538,741580,608850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]