Sorry for late response. Here are the queries.

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts 
WHERE 1=1 
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_author = 11061
AND wp_posts.post_status = 'private')
AND wp_posts.id NOT IN (SELECT post_id
FROM wp_wpfront_ure_post_type_permissions
WHERE role IN ('subscriber','fund_news_members','fund_seminar_members','seminar_basic','seminar_advanced','seminar_deals','seminar_practices','retirement_financial_members')
AND enable_permissions = 1
AND has_read = 0
GROUP BY post_id
HAVING COUNT(*) = 8) 
ORDER BY wp_posts.post_date DESC
LIMIT 0, 15

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts 
INNER JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1 
AND ( wp_term_relationships.term_taxonomy_id IN (865) )
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_author = 11061
AND wp_posts.post_status = 'private')
AND wp_posts.id NOT IN (SELECT post_id
FROM wp_wpfront_ure_post_type_permissions
WHERE role IN ('subscriber','fund_news_members','fund_seminar_members','seminar_basic','seminar_advanced','seminar_deals','seminar_practices','retirement_financial_members')
AND enable_permissions = 1
AND has_read = 0
GROUP BY post_id
HAVING COUNT(*) = 8) 
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 4

Dear Syam,

Thanks for your help. I’ve removed two plugins that might cause issues, wordfence & w3-total-cache, and this is the the first part of the screenshot captured after user login. It takes 75 seconds to login, that’s too long.

I expanded the table column of the Caller, so that should give us the information of where it got stuck.

https://gyazo.com/518294a9863bc897372bb3874f4a714f