When using your theme XStore Woocommerce is creating a long string of blocks of text flying by that turns out to be from database queries.
A lot of these queries have large output and are related to the wp_posts table, so I searched through the output and found that a single page load of the main page performs 564 queries against the wp_posts table. There’s too many to paste in here.
A lot of the queries seem identical to each other, making it seem something is doing selects with large output and then narrowing it down after, but it definitely accounts for the very long pause when loading the page.
The last php file called before a huge chunk of queries that look like “SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 4620 AND wp_posts.post_type = ‘product’ AND ((wp_posts.post_status <> ‘trash’ AND
wp_posts.post_status <> ‘auto-draft’)) ORDER BY wp_posts.post_date DESC “, 234”