High CPU usage in admin page

Hi

This query

SELECT count(*)
FROM wp.._posts wpp
INNER JOIN wp.._postmeta wppm
WHERE wpp.ID = wppm.post_id
AND wpp.post_status = ‘publish’
AND wppm.meta_key = ‘_fl_builder_data’
AND ( wppm.meta_value LIKE ‘%uabb-advanced-menu%’
OR wppm.meta_value LIKE ‘%flip-box%’
OR wppm.meta_value LIKE ‘%info-list%’
OR wppm.meta_value LIKE ‘%info-table%’
OR wppm.meta_value LIKE ‘%ribbon%’
OR wppm.meta_value LIKE ‘%slide-box%’
OR wppm.meta_value LIKE ‘%uabb-button%’
OR wppm.meta_value LIKE ‘%spacer-gap%’
OR wppm.meta_value LIKE ‘%image-separator%’
OR wppm.meta_value LIKE ‘%uabb-separator%’
OR wppm.meta_value LIKE ‘%image-icon%’
OR wppm.meta_value LIKE ‘%uabb-heading%’)
LIMIT 5

Invoqued from BB_Ultimate_Addon_Helper::show_rating_notice()
Plugin: ultimate-addons-for-beaver-builder-lite

is taking 17 secs to be executed in admin page.

This has caused my site uses 4 times the max CPU time allowed by my hoster.

When I use the admin page for anything, every clic takes more than 15 secs to respond and it’s causing high CPU load in servers.

• This topic was modified 4 years, 7 months ago by cmelero.
• This topic was modified 4 years, 7 months ago by cmelero.