SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20167 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20167 [ RunTime:0.002053s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671133,330411,63453,843250,548247,556710,174455,940373,596182,719044,141669,390682,527225,695524,956920,601610,235691,894887,275063,801714,394455,213896,558492,165647,642819,976562,263023,1040968,147355,116156,566533,583095,175770,55955,847159,1005149,410635,735160,875043,948978,873210,221082,438649,122142,947002,770583,870270,527396,613024,160109,514575,439243,581146,241373,397333,422774,433910,750277,707298,716594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20167 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20167 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]