SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54450 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54450 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595537,66291,384728,905098,760057,623255,673650,60936,544118,953864,516982,605606,972587,783846,387723,911315,191575,352358,856075,346177,371160,228866,777116,12493,285225,527689,578685,461762,165888,865717,43501,101079,304078,922436,162324,577033,514149,540184,543245,327550,857422,350863,62551,719324,249046,286194,316853,123679,467720,612227,875891,155160,584629,296949,174678,548312,252616,418138,583715,546896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]