backend takes 10+ seconds

Thanks for the upload., I only see one query that’s particularly slow, it has to do with Yoast.

SELECT COUNT(P.ID)
   FROM wp_posts AS P 
   LEFT JOIN wp_yoast_indexable AS I
          ON P.ID = I.object_id AND I.link_count IS NOT NULL
         AND I.object_type = 'post'
   LEFT JOIN wp_yoast_seo_links AS L
          ON L.post_id = P.ID AND L.target_indexable_id IS NULL
        AND L.type = 'internal' AND L.target_post_id IS NOT NULL AND L.target_post_id != 0        
  WHERE ( I.object_id IS NULL OR L.post_id IS NOT NULL ) 
    AND P.post_status = 'publish'
    AND P.post_type IN 
        ('post', 'page', 'blocks', 'product', 'product-feed', 'featured_item')

But I do see something suspicious. You have the LightSpeed object cache enabled, and you also have lots of wp_options queries going. You should check that the object cache is actually functioning correctly. It might not be.

I hope this helps.

Thanks for suggestion. The object cache is running. But there is a failed setting with Store Transients when wp-admin cache is off. Correcting it, the wp-admin is faster now.

About Yoast, not sure if the reason is Store Transients also, but tried to monitor again, I didn’t see that request. Will monitor a few more times.

Thanks again.