Mysql Laravel expert Need -- 7

Making a little website with my Laravel. Clicking on the home page makes the CPU very high. I need a Laravel Mysql Expert.

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 load.

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))

Habilidades: PHP, Laravel, MySQL, HTML

Ver más: making websites work firefox, companys canada need partner call center work campaigns, need help making newspaper article, making php5 work php3, making clone work club penguin, need help making bands myspace page, need typist books typing work pakistan, need little work, making oscommerce work better paypal, making site work ie6, need help making shipping description, making marriage work, need program atmega32 ds1307 work alarm clock 16x2, urgently need can data entry work, making iweb work internet explorer, linux expert need work, need a css expert now for a little customization in a web page, Laravel Expert need urgent, laravel expert needed right away to work on my site . only experts

Información del empleador:
( 0 comentarios ) PIROJPUR, Bangladesh

Nº del proyecto: #28256438

12 freelancers están ofertando un promedio de $70 por este trabajo

(324 comentarios)

I am very interested in your website [login to view URL] initiate the chat so that we can discuss on your website once and move forward to start the work on [login to view URL] free to chat for references and to discuss the requirement Más

$40 USD en 7 días
(4 comentarios)

Hello , I have 7 years of experience in web development inclduing o laravel o html o javascript o sql o web design etc... when read your project description , It sounds interesting to me I do have skills & experience Más

$140 USD en 7 días
(4 comentarios)

Dear sir/mem, Hope you and your family doing well, I’m Hiral a senior full-stack developer. I just read your project requirement and I'm happy to work in this please give me this opportunity I will never disappoint yo Más

$50 USD en 1 día
(2 comentarios)

Greetings! I have 7+ professional experience in laravel. We have completed more than 100+ projects in laravel. My SKills: Laravel, CakePHP, Yii, React, Vue, Codeigniter. I'm fully familiar with laravel old version to t Más

$140 USD en 2 días
(3 comentarios)

Hello, I can make your query faster. I am Web developer with 5+ years of experience in PHP, Angular, Codeigniter, Laravel, Zend, Mysql, HTML, CSS, Javascript, JQuery, Third party API, Curl. Let's Have chat for further Más

$30 USD en 1 día
(2 comentarios)

Hello, I've seen your project on Msql Laravel several times, I thought you would have find an expert, i can help you solve this issue. With me, you will get and expert in your disposal. Thanks

$30 USD en 1 día
(0 comentarios)

Dear Sir, Had you created index on tables? how much data is present in table? what all values status column contains? Regards, Sachin

$35 USD en 2 días
(0 comentarios)

I've been working with PHP based applications that deals with raw MySQL queries over two years. I've also worked in few Laravel applications. I can optimize the queries above to achieve the maximum possible performance Más

$40 USD en 2 días
(0 comentarios)

Hi I can check that for you - Having experience in Laravel(Backend) and Nuxt(Frontend), Vuetify Here are the site for reference [login to view URL] - Having experience in wordpress Site used only html, css, Más

$30 USD en 1 día
(0 comentarios)

ready to start now

$140 USD en 7 días
(1 comentario)

hi there i am read your description already i done multiple projects in laravel looks same as yourproject type i have 2+ year experience in laravel. i have strong concepts in laravel function & sql server if you want Más

$111 USD en 3 días
(0 comentarios)