Answer the question
In order to leave comments, you need to log in
Why query in PhpMyAdmin is faster than through php?
Hello! I have a simple piece of php code. This is a normal Mysqli query.
This line of code (without connections and other things) is executed in 5ms. At the same time, when copying the same query to phpmyadmin, the query runs in 0.2ms even with the SQL_NO_CHACHE parameter.
Tell me where to dig, because apart from this line there is nothing else.
mysqli::query("запрос");
Answer the question
In order to leave comments, you need to log in
Enable slow query log with long_query_time = 0 - as far as I remember, this will save all queries with execution time on the database server.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question