Zblog page opens slowly | Troubleshooting method for long TTFB loading time

Check one of the customers today website The problem of too long loading time on the home page is solved, and then share the next process and tools to help users who encounter the same problem.

First of all, the customer's website data is about 5w+, and it takes more than 5 seconds to open the home page each time. As shown in the figure below, the TTFB time is 5.94 seconds.

First, check whether it is a server problem. If another website with the same program and data under the same server is opened, it does not have this problem. Eliminate the server problem.

Let's look at the problem again. Only the home page load time is slow, and the opening time of other pages is normal. The home page of this station is a cms layout, which calls quite a number of data modules, so the preliminary judgment is to read the SQL database.

---

Troubleshooting of upper tools, Zblog Application Center Search for "debug" and install the plug-in as shown in the following figure:

After the plug-in is installed and enabled, open the home page, click the green bug at the bottom left corner, and the following interface will appear:

Here is all the sql data information that needs to be queried when opening the current page. There is a query response time on the right side of each information. If you look at which data query time is too long, you can roughly know what the problem is.

---

PS: If you don't understand this information, our suggestion is to give your subject author a screenshot of the SQL data information that has been loaded for too long to check. Developers with specific information can easily and accurately locate the problem.