plugins – My CPU usage in A2 Hosting Shared Plan (Turbo Boost) is high due to mysql query!
Can anyone please let me know that what this query means as it increases my CPU usage to 99 in A2 Hosting Shared Turbo Boost plan. I am using Photo Contest WordPress plugin from CodeCanyon by Gallery Plugins. I’m using Lite Speed cache plugin too.
SELECT wpcbv_posts.* FROM wpcbv_posts INNER JOIN wpcbv_postmeta ON ( wpcbv_posts.ID = wpcbv_postmeta.post_id ) INNER JOIN wpcbv_postmeta AS mt1 ON ( wpcbv_posts.ID = mt1.post_id ) INNER JOIN wpcbv_postmeta AS mt2 ON ( wpcbv_posts.ID = mt2.post_id ) WHERE 1=1 AND ( wpcbv_postmeta.meta_key = ‘contest-photo-points’ AND ( ( mt1.meta_key = ‘contest-active’ AND mt1.meta_value=”1″ ) AND ( mt2.meta_key = ‘photo-related-to-contest’ AND mt2.meta_value=”35″ ) ) ) AND wpcbv_posts.post_type=”attachment” AND ((wpcbv_posts.post_status <> ‘trash’ AND wpcbv_posts.post_status <> ‘auto-draft’)) GROUP BY wpcbv_posts.ID ORDER BY wpcbv_postmeta.meta_value+0 DESC
Thanks in Advance.
Leave an answer