Question about executed queries

Hello,
when I visit the front page of a site I see that WooCommerce is executing 60 queries and I have a few questions about it.

1. I see this query is marked as a slow query:

SELECT COUNT( * )
FROM wp_posts
WHERE post_type = 'shop_order'
AND post_status = 'wc-completed'

Does anybody know why this query is executed and is there a way to prevent this from happening?

2. I see 27 query which are executed two times. For example this one:

SELECT a.*, g.slug AS group
FROM brtfc_actionscheduler_actions a
LEFT JOIN brtfc_actionscheduler_groups g
ON a.group_id=g.group_id
WHERE a.action_id=632402

or this one:

SELECT post_id, meta_value
FROM brtfc_postmeta
WHERE meta_key = '_wp_attached_file'
AND meta_value = '2020/06/pk-110_buntesleben_7.jpg'

I have several of these and these seem to be connected to the products, which I highlight on the front page. But the queries for each product there is executed twice. Does anybody know why?

3. I also find several ActionScheduler actions – but I’ve set define( 'DISABLE_WP_CRON', true ); So everything that the ActionScheduler is doing should not be executed in the frontend, right? Why is this happening?

• This topic was modified 5 years ago by torbent.