SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101971 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101971 [ RunTime:0.002697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788823,303944,727488,788337,392054,171771,867889,288320,704136,404866,291490,40140,26219,956652,143245,308667,257747,1036912,889427,340106,274689,888960,490780,307864,690591,458526,427527,388931,230891,623401,905308,1047325,843020,1045762,599261,892878,567447,480651,972730,989440,713348,924306,462315,991191,916104,94130,511178,144185,538521,31541,822254,595506,413432,958046,11219,272551,300788,231123,542461,428802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]