SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198301 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198301 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822974,208738,577131,721019,221741,664160,803726,96733,419770,271386,674127,464816,91686,825155,271795,666002,34090,589016,669438,659873,960788,839431,763875,89440,68802,142690,556799,120207,618529,153892,933940,182921,16910,1045243,52021,394807,907490,561459,1038832,340498,254905,794983,88921,434700,117011,289161,552681,974487,92608,829462,988049,380337,422315,16649,20584,1040702,902060,8693,730017,647705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]