SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489841 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489841 [ RunTime:0.002319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650139,702939,402482,530853,118598,769767,736827,265712,210282,193297,281691,1031365,23013,55672,904411,917901,317632,1045014,454830,144892,750168,633560,615026,257648,662944,844379,1000554,585278,246557,254033,78329,73421,799955,659389,348618,605394,704762,114821,680835,422453,261752,580566,186438,408968,655183,790857,758436,381754,55977,932162,237348,655345,184760,278800,148269,778556,472652,239319,208152,1034244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]