I finally found the problem to share with you, my website woocommerce has about 2000 products, each product detail contains 20 images, and in the upload time WP-Optimize plugin does not have effective compression of images, I replaced the image compression plugin and will reduce the image size of the 60%, the list of the speed of the query there is a significant increase!

I don’t know why the size of the image affects the SQL query, but for those of you who have the same problem, you can try using this approach