ajax simple request slow

There are only a few records in the data table. The query should be very fast. Why does this request take so long? (The request is for the local server)

Checked the data query time, this is where time wasted

The database only has these 10 rows of data, and parentid is also indexed. Why is the query so slow?

It takes 0.001s to execute the query directly on phpmyadmin

Reply content:

There are only a few records in the data table. The query should be very fast. Why does this request take so long? (The request is for the local server)

Checked the data query time, this is where time wasted

The database only has these 10 rows of data, and parentid is also indexed. Why is the query so slow?

It takes 0.001s to execute the query directly on phpmyadmin

The url query string used by ajax, and there is nothing in the data. I guess this delay is because both the front end and the back end are waiting for the empty data package, so you can try using the get method directly, or you can use the get method in the data package. You can also create a FormData in it

The person above is right. I suggest you change it like this. Change the for loop in JavaScript to this:

<code class="javascript">for(var i=0;i<count;i++) {
    function() {
        //your code
    }
}</code>

You can try it.

The problem may not be in the code, try using 127.0.0.1 instead of localhost

Test a few more times to see if it is a coincidence?
It may be a problem with the back-end code. Can you comment out other irrelevant codes and try?

Is there a problem with the database and the connection access speed is too slow?

1. Modify POST request to GET request
2. select Modify to select fileds Specific fields, avoid using wildcards
3.desc Or explain your SQL and see if indexes are used