SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201682 LIMIT 1 [ RunTime:0.000571s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201682 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550955,103412,76980,346293,488826,22023,275689,214279,786826,444190,1043976,997869,505857,356814,843044,677435,337969,355510,514939,991782,519964,377047,925584,202853,473666,22264,890513,712970,659981,906053,567970,79204,304887,987662,395212,99904,439541,56237,201997,935391,908406,559359,424769,606129,614435,717297,43940,833780,891801,860260,619081,688888,121790,822952,430944,215017,252705,782943,560734,437614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000781s ]