Method for getting blogs:

public static IEnumerable<IPublishedContent> GetPagedBlogsLatestFirst(IPublishedContent rootNode, int numberOfItemsPerPage, int pageNo)
        {
            IEnumerable<IPublishedContent> Blogs = rootNode
                                                   .Descendants("blogItem")
                                                   .Where(x => x.IsVisible())
                                                   .OrderByDescending(x => x.HasProperty("publishDateOverride")
                                                                           && x.HasValue("publishDateOverride")
                                                                           ? x.GetPropertyValue<DateTime>("publishDateOverride")
                                                                           : x.CreateDate)
                                                   .Skip((pageNo - 1) * numberOfItemsPerPage)
                                                   .Take(numberOfItemsPerPage);

            return Blogs;
        }

Blog is variable declared for foreach loop.

foreach (var Blog in Blogs)  {
    string FeaturedImg = Blog.GetPropertyValue<IPublishedContent>("blogFeaturedImage").Url;}

I was also expecting this to come from cache as well. Using Miniprofiler package shows it is hitting the db to get the media information and it runs 4 sql queries shown below each time it needs to retrieve the media url. A total of 84 sql queries are executed.

I can see the page loads a lot faster once i remove the line of code to get media url.

First query:

    DECLARE @0 nvarchar(40) = N'9d1c3e10-b0d7-48ee-be71-a4b5cff034cb',
        @1 nvarchar(40) = N'b796f64c-1f99-4ffb-b886-4bf4bc011a9c',
        @2 nvarchar(40) = N'92849b1e-3904-4713-9356-f646f87c25f4';

SELECT id FROM umbracoNode WHERE uniqueId=@0 AND (nodeObjectType=@1 OR nodeObjectType=@2)

Second query:

DECLARE @0 nvarchar(40) = N'b796f64c-1f99-4ffb-b886-4bf4bc011a9c',
        @1 int = 113677;

SELECT TOP 1 *
FROM [cmsContentVersion]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND (umbracoNode.id = @1)
ORDER BY ([cmsContentVersion].[VersionDate]) DESC

Third query:

    DECLARE @0 nvarchar(40) = N'b796f64c-1f99-4ffb-b886-4bf4bc011a9c',
        @1 int = 113677;

SELECT a.id, a.value, a.sortorder, a.alias, a.datatypeNodeId
FROM cmsDataTypePreValues a
WHERE EXISTS(
    SELECT DISTINCT b.id as preValIdInner
    FROM cmsDataTypePreValues b
        INNER JOIN cmsPropertyType
        ON b.datatypeNodeId = cmsPropertyType.dataTypeId
    INNER JOIN 
            (SELECT cmsContent.contentType FROM [cmsContentVersion]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND (umbracoNode.id = @1)
) as docData
    ON cmsPropertyType.contentTypeId = docData.contentType
    WHERE a.id = b.id)   

Fourth query:

DECLARE @0 nvarchar(40) = N'b796f64c-1f99-4ffb-b886-4bf4bc011a9c',
        @1 int = 113677;

SELECT cmsPropertyData.*
FROM cmsPropertyData
INNER JOIN cmsPropertyType
ON cmsPropertyData.propertytypeid = cmsPropertyType.id
INNER JOIN 
        (SELECT cmsContent.nodeId, cmsContentVersion.VersionId FROM [cmsContentVersion]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND (umbracoNode.id = @1)
) as docData
ON cmsPropertyData.versionId = docData.VersionId AND cmsPropertyData.contentNodeId = docData.nodeId
ORDER BY contentNodeId, versionId, propertytypeid