SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200905 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200905 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785608,787180,80466,396422,32877,271722,1041305,266179,1004442,174283,412911,961192,468194,195499,359520,607777,208317,649478,891285,365408,643870,545396,996660,421341,791807,71098,899110,1013870,299077,230156,241856,132886,762518,1017287,965442,261128,146882,713431,420632,267946,26807,726237,612204,676997,123609,351817,781313,74764,368940,375515,61993,887863,273651,369727,226916,841482,196398,789225,462487,377689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]