SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531975 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531975 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710721,412010,989552,212417,449576,641988,3652,742994,489693,867155,809560,676060,741304,724366,668603,145527,230725,813509,678576,559678,431326,749541,72751,3926,356567,635106,358618,625869,889754,257835,449827,132399,423045,1033353,424600,718976,847127,590382,497037,612603,382176,546057,924415,271830,339714,696224,916872,586743,394947,198497,841333,183200,68831,417463,747012,971041,317231,559326,789002,585209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]