Mysql Laravel expert Need -- 6

SELECT * FROM posts WHERE status = 1 AND posts.worker_need> (SELECT COUNT (id) FROM prove WHERE job_id = [login to view URL] AND (status = 0 OR status = 1))

Here is the second condition that I am counting = (SELECT COUNT (id) FROM prove WHERE job_id = [login to view URL] AND (status = 0 OR status = 1)) With this query the whole server CPU becomes 100% just for this I wanted to know if there is any other way to do the count work where there will not be so much server [login to view URL] * FROM posts WHERE status=1 AND posts.worker_need > (SELECT COUNT(id) FROM prove WHERE job_id=[login to view URL] AND (status = 0 OR status = 1))

PHP Laravel MySQL HTML

Nº del proyecto: #28256417

Sobre el proyecto