mysql to many query take to long, site overload and become down, script xenforo need help
Budget: $30 – $250 USD
| 137260 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 658 | Creating sort index | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137391 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 645 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137413 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 643 | Creating sort index | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137460 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 639 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137501 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 636 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137715 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 617 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137743 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 615 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137744 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 615 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137829 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 609 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137867 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 605 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
any expert in mysql ?
| 137391 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 645 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137413 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 643 | Creating sort index | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137460 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 639 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137501 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 636 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137715 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 617 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137743 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 615 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137744 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 615 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137829 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 609 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
| 137867 | kikdirty_kikdirt | localhost | kikdirty_kikdirty | Execute | 605 | Sending data | SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permiss | 0.000 |
any expert in mysql ?