Correction of the error

Budget: 1000 UAH Deadline: 1 day

Good day. The problem described by technical support is related to a slow SQL query that accesses the field product_property_value_id. Due to the excessive duration of this query, the site "hangs" or completely stops responding.

What I will do:
I will analyze the log /var/www/ressormarket/tmp/queryslow.manual.2025.03.08.log.
I will determine the cause of the slow execution (lack of index, incorrect JOIN condition, large selection, etc.).
I will optimize the query: through indexing, rewriting SQL, or caching.
I will check for similar queries in the code.
I will provide a brief report on diagnostics and fixes.
Deadline:
From 2 to 4 hours (depending on the structure of the tables and access to the code and database).

Budget: 1000 UAH Deadline: 1 day

Good day!
Feel free to contact me, I will fix it right now.
------------------------------------

Budget: 1100 UAH Deadline: 1 day

Good afternoon. I have extensive experience working with SQL. If you are interested, please write to clarify the details.

Budget: 1000 UAH Deadline: 1 day

Good day!
It is necessary to familiarize yourself with the log, the code, and the database. Perhaps there are simply not enough indexes, or maybe the code is flawed. I will help without any problems. Experience in programming - 14 years

Budget: 1000 UAH Deadline: 1 day

Hello! Your site is on OpenCart, I can solve the problem and fix everything.

Budget: 4000 UAH Deadline: 1 day

Good day!

I have reviewed your task and am ready to help fix the issue with the slow SQL query.

I have experience in query optimization, working with databases, and log analysis. I can:
• analyze the log queryslow.manual.2025.03.08.log,
• optimize the SELECT query for product_property_value_id,
• check the indexing of the table and suggest improvements,
• test and verify the functionality of the site after the fix.

I am ready to discuss the details and get started.

Best regards,
Ruslan Expand

Budget: 1000 UAH Deadline: 2 days

Good afternoon, Ivan
Write to me in private messages, I'll see what you have there
Sincerely, Alexander

Budget: 1000 UAH Deadline: 1 day

Hello. I will figure it out... I have fixed something similar....................................................................

Budget: 1000 UAH Deadline: 1 day

And how do you suggest to replace it, with what? I will take a look, I will replace it.
------------ ---------------- ----------------

Budget: 1200 UAH Deadline: 1 day

Good day. Feel free to reach out. I will fix it. I have fixed similar problems many times.