SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503150 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503150 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539053,197015,947717,417554,557504,767375,369892,38520,655514,180517,891679,277515,1047838,151208,933858,198444,1021717,35742,76192,613093,307529,334491,133824,1032848,489351,355741,51734,704138,103895,84353,919664,328109,37816,361129,584811,646134,307871,953377,394166,439674,6027,729379,618117,61651,57842,258867,641507,247037,1011362,898696,386861,169037,409853,923080,396613,900170,155730,951539,1006586,54468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]