SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310045 LIMIT 1 [ RunTime:0.001605s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310045 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036223,477977,724344,585655,605479,278160,267152,277003,23818,771276,649003,973199,1040107,1041509,98586,594453,545185,946687,555837,661835,708714,689420,821725,601966,596343,471781,19011,250444,229012,398597,982316,239364,135141,326461,860790,445342,1039206,900640,282514,815744,565314,536708,173543,782195,539799,933298,958958,615135,142669,893761,989952,824259,91666,622307,830431,181967,596203,700751,341024,123688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002222s ]