Clans laden sehr langsam oder garnicht

    • Not confirmed

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Kannst du mir vielleicht malö das Benchmark Log von einer Clanseite zukommen lassen?
      Gehe hierzu in dein ACP, aktiviere die Optionen Kongiguration > Module > Entwicklung > "Debug-Modus aktivieren" und "Benchmark aktivieren". Wenn du nun die Seite einmal aufrufst erscheint ganz unten in der Seite ein kleiner Text alla "Execution time: xs (x% PHP, x% SQL) | SQL queries: x | Memory-Usage: x MB. Den bräuchte ich, sowie den Log, wenn du auf den Link klickst.


      gruß

      Marcel
    • Vielen Dank für die Antwort, im Anhang findest du die gewünschten Informationen.



      Log:

      Source Code

      1. (SQL Query) SELECT * FROM wcf1_session WHERE sessionID = ?
      2. Execution time: 0.0004s
      3. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      4. #1 wcf\system\database\statement\PreparedStatement->execute() (line 65)
      5. #2 wcf\data\DatabaseObject->__construct() (line 380)
      6. #3 wcf\system\session\SessionHandler->getExistingSession() (line 172)
      7. #4 wcf\system\session\SessionHandler->load() (line 28)
      8. #5 wcf\system\session\ACPSessionFactory->load() (line 345)
      9. #6 wcf\system\WCF->initSession() (line 143)
      10. #7 wcf\system\WCF->__construct() (line 25)
      11. #8 /var/www/vhosts/tos-xbox.net/httpdocs/squads/global.php: require_once() (line 6)
      12. #9 /var/www/vhosts/tos-xbox.net/httpdocs/squads/index.php: require_once() (line 2)
      13. (SQL Query) SELECT user_option_value.*, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) WHERE user_table.userID = ?
      14. Execution time: 0.0005s
      15. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      16. #1 wcf\system\database\statement\PreparedStatement->execute() (line 77)
      17. #2 wcf\data\user\User->__construct() (line 386)
      18. #3 wcf\system\session\SessionHandler->getExistingSession() (line 172)
      19. #4 wcf\system\session\SessionHandler->load() (line 28)
      20. #5 wcf\system\session\ACPSessionFactory->load() (line 345)
      21. #6 wcf\system\WCF->initSession() (line 143)
      22. #7 wcf\system\WCF->__construct() (line 25)
      23. #8 /var/www/vhosts/tos-xbox.net/httpdocs/squads/global.php: require_once() (line 6)
      24. #9 /var/www/vhosts/tos-xbox.net/httpdocs/squads/index.php: require_once() (line 2)
      25. (SQL Query) SELECT * FROM wcf1_session_virtual WHERE sessionID = ? AND ipAddress = ? AND userAgent = ?
      26. Execution time: 0.0003s
      27. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      28. #1 wcf\system\database\statement\PreparedStatement->execute() (line 50)
      29. #2 wcf\data\session\virtual\SessionVirtual::getExistingSession() (line 387)
      30. #3 wcf\system\session\SessionHandler->getExistingSession() (line 172)
      31. #4 wcf\system\session\SessionHandler->load() (line 28)
      32. #5 wcf\system\session\ACPSessionFactory->load() (line 345)
      33. #6 wcf\system\WCF->initSession() (line 143)
      34. #7 wcf\system\WCF->__construct() (line 25)
      35. #8 /var/www/vhosts/tos-xbox.net/httpdocs/squads/global.php: require_once() (line 6)
      36. #9 /var/www/vhosts/tos-xbox.net/httpdocs/squads/index.php: require_once() (line 2)
      37. (SQL Query) SELECT * FROM wcf1_user_storage WHERE userID IN (?)
      38. Execution time: 0.0003s
      39. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      40. #1 wcf\system\database\statement\PreparedStatement->execute() (line 58)
      41. #2 wcf\system\user\storage\UserStorageHandler->loadStorage() (line 113)
      42. #3 wcf\system\user\storage\UserStorageHandler->getField() (line 158)
      43. #4 wcf\data\user\User->getGroupIDs() (line 603)
      44. #5 wcf\system\session\SessionHandler->loadGroupData() (line 566)
      45. #6 wcf\system\session\SessionHandler->getPermission() (line 93)
      46. #7 wcf\system\menu\TreeMenu->checkMenuItem() (line 88)
      47. #8 wcf\system\menu\page\PageMenu->checkMenuItem() (line 113)
      48. #9 wcf\system\menu\TreeMenu->checkMenuItems() (line 34)
      49. #10 wcf\system\menu\page\PageMenu->init() (line 27)
      50. #11 wcf\system\SingletonFactory->__construct() (line 56)
      51. #12 wcf\system\SingletonFactory::getInstance() (line 37)
      52. #13 clan\system\CLANCore->__run() (line 476)
      53. #14 wcf\system\WCF->initApplications() (line 148)
      54. #15 wcf\system\WCF->__construct() (line 25)
      55. #16 /var/www/vhosts/tos-xbox.net/httpdocs/squads/global.php: require_once() (line 6)
      56. #17 /var/www/vhosts/tos-xbox.net/httpdocs/squads/index.php: require_once() (line 2)
      57. (SQL Query) SELECT slideshow.* FROM wcf1_slideshow slideshow ORDER BY orderID
      58. Execution time: 0.0003s
      59. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      60. #1 wcf\system\database\statement\PreparedStatement->execute() (line 200)
      61. #2 wcf\data\DatabaseObjectList->readObjects() (line 28)
      62. #3 wcf\system\event\listener\SlideshowTopListener->execute() (line 141)
      63. #4 wcf\system\event\EventHandler->executeInheritedActions() (line 173)
      64. #5 wcf\system\event\EventHandler->fireAction() (line 108)
      65. #6 wcf\page\AbstractPage->readParameters() (line 102)
      66. #7 clan\page\AbstractClanPage->readParameters() (line 99)
      67. #8 wcf\page\AbstractPage->__run() (line 58)
      68. #9 wcf\system\request\Request->execute() (line 139)
      69. #10 wcf\system\request\RequestHandler->handle() (line 3)
      70. (SQL Query) SELECT clan.*, tracked_visit.visitTime FROM clan1_clan clan LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 566 AND tracked_visit.objectID = clan.clanID AND tracked_visit.userID = 15) WHERE clanID = ?
      71. Execution time: 0.0003s
      72. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      73. #1 wcf\system\database\statement\PreparedStatement->execute() (line 97)
      74. #2 clan\data\clan\Clan->__construct() (line 107)
      75. #3 clan\page\AbstractClanPage->readParameters() (line 99)
      76. #4 wcf\page\AbstractPage->__run() (line 58)
      77. #5 wcf\system\request\Request->execute() (line 139)
      78. #6 wcf\system\request\RequestHandler->handle() (line 3)
      79. (SQL Query) SELECT * FROM clan1_clan_visitor WHERE clanID = ? AND userID = ?
      80. Execution time: 0.0002s
      81. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      82. #1 wcf\system\database\statement\PreparedStatement->execute() (line 33)
      83. #2 clan\data\clan\visitor\ClanVisitor::getObject() (line 230)
      84. #3 clan\page\AbstractClanPage->show() (line 100)
      85. #4 wcf\page\AbstractPage->__run() (line 58)
      86. #5 wcf\system\request\Request->execute() (line 139)
      87. #6 wcf\system\request\RequestHandler->handle() (line 3)
      88. (SQL Query) UPDATE clan1_clan_visitor SET time = ? WHERE visitorID = ?
      89. Execution time: 0.0184s
      90. (SQL Query) SELECT like_object.*, CASE WHEN like_table.userID IS NOT NULL THEN like_table.likeValue ELSE 0 END AS liked FROM wcf1_like_object like_object LEFT JOIN wcf1_like like_table ON (like_table.objectTypeID = like_object.objectTypeID AND like_table.objectID = like_object.objectID AND like_table.userID = ?) WHERE like_object.objectTypeID = ? AND like_object.objectID IN (?)
      91. Execution time: 0.0003s
      92. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      93. #1 wcf\system\database\statement\PreparedStatement->execute() (line 142)
      94. #2 wcf\system\like\LikeHandler->loadLikeObjects() (line 130)
      95. #3 clan\page\AbstractClanPage->readData() (line 18)
      96. #4 clan\page\ClanPage->readData() (line 273)
      97. #5 wcf\page\AbstractPage->show() (line 245)
      98. #6 clan\page\AbstractClanPage->show() (line 100)
      99. #7 wcf\page\AbstractPage->__run() (line 58)
      100. #8 wcf\system\request\Request->execute() (line 139)
      101. #9 wcf\system\request\RequestHandler->handle() (line 3)
      102. (SQL Query) SELECT tag.*, tag_to_object.objectID FROM wcf1_tag_to_object tag_to_object LEFT JOIN wcf1_tag tag ON (tag.tagID = tag_to_object.tagID) WHERE tag_to_object.objectTypeID = ? AND tag_to_object.objectID IN (?)
      103. Execution time: 0.0003s
      104. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      105. #1 wcf\system\database\statement\PreparedStatement->execute() (line 175)
      106. #2 wcf\system\tagging\TagEngine->getObjectsTags() (line 140)
      107. #3 wcf\system\tagging\TagEngine->getObjectTags() (line 165)
      108. #4 clan\page\AbstractClanPage->readData() (line 18)
      109. #5 clan\page\ClanPage->readData() (line 273)
      110. #6 wcf\page\AbstractPage->show() (line 245)
      111. #7 clan\page\AbstractClanPage->show() (line 100)
      112. #8 wcf\page\AbstractPage->__run() (line 58)
      113. #9 wcf\system\request\Request->execute() (line 139)
      114. #10 wcf\system\request\RequestHandler->handle() (line 3)
      115. (SQL Query) SELECT user_table.username, user_table.email, user_table.disableAvatar, user_table.enableGravatar, user_table.gravatarFileExtension, user_avatar.*, clan_visitor.* FROM clan1_clan_visitor clan_visitor LEFT JOIN wcf1_user user_table ON (user_table.userID = clan_visitor.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) WHERE clan_visitor.clanID = ? ORDER BY clan_visitor.time DESC LIMIT 10
      116. Execution time: 0.0004s
      117. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      118. #1 wcf\system\database\statement\PreparedStatement->execute() (line 200)
      119. #2 wcf\data\DatabaseObjectList->readObjects() (line 192)
      120. #3 clan\page\AbstractClanPage->readData() (line 18)
      121. #4 clan\page\ClanPage->readData() (line 273)
      122. #5 wcf\page\AbstractPage->show() (line 245)
      123. #6 clan\page\AbstractClanPage->show() (line 100)
      124. #7 wcf\page\AbstractPage->__run() (line 58)
      125. #8 wcf\system\request\Request->execute() (line 139)
      126. #9 wcf\system\request\RequestHandler->handle() (line 3)
      127. (SQL Query) SELECT * FROM wcf1_message_embedded_object WHERE messageObjectTypeID = ? AND messageID IN (?)
      128. Execution time: 0.0003s
      129. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      130. #1 wcf\system\database\statement\PreparedStatement->execute() (line 124)
      131. #2 wcf\system\message\embedded\object\MessageEmbeddedObjectManager->loadObjects() (line 30)
      132. #3 clan\page\ClanPage->readData() (line 273)
      133. #4 wcf\page\AbstractPage->show() (line 245)
      134. #5 clan\page\AbstractClanPage->show() (line 100)
      135. #6 wcf\page\AbstractPage->__run() (line 58)
      136. #7 wcf\system\request\Request->execute() (line 139)
      137. #8 wcf\system\request\RequestHandler->handle() (line 3)
      138. (SQL Query) SELECT COUNT(*) AS count FROM clan1_clan_visitor clan_visitor WHERE clan_visitor.clanID = ?
      139. Execution time: 0.0002s
      140. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      141. #1 wcf\system\database\statement\PreparedStatement->execute() (line 152)
      142. #2 wcf\data\DatabaseObjectList->countObjects() (line 217)
      143. #3 clan\page\AbstractClanPage->assignVariables() (line 276)
      144. #4 wcf\page\AbstractPage->show() (line 245)
      145. #5 clan\page\AbstractClanPage->show() (line 100)
      146. #6 wcf\page\AbstractPage->__run() (line 58)
      147. #7 wcf\system\request\Request->execute() (line 139)
      148. #8 wcf\system\request\RequestHandler->handle() (line 3)
      149. (SQL Query) SELECT user_option_value.*, user_table.* FROM wcf1_user user_table LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) WHERE user_table.userID = ?
      150. Execution time: 0.0006s
      151. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      152. #1 wcf\system\database\statement\PreparedStatement->execute() (line 77)
      153. #2 wcf\data\user\User->__construct() (line 469)
      154. #3 clan\data\clan\Clan->getUserProfile() (line 592)
      155. #4 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/template/TemplateEngine.class.php: include() (line 323)
      156. #5 wcf\system\template\TemplateEngine->display() (line 305)
      157. #6 wcf\page\AbstractPage->show() (line 245)
      158. #7 clan\page\AbstractClanPage->show() (line 100)
      159. #8 wcf\page\AbstractPage->__run() (line 58)
      160. #9 wcf\system\request\Request->execute() (line 139)
      161. #10 wcf\system\request\RequestHandler->handle() (line 3)
      162. (SQL Query) SELECT COUNT(*) AS count FROM wcf1_user_group_leader WHERE leaderID = ?
      163. Execution time: 0.0003s
      164. #0 wcf\system\benchmark\Benchmark->start() (line 87)
      165. #1 wcf\system\database\statement\PreparedStatement->execute() (line 57)
      166. #2 wcf\data\user\group\ModeratedUserGroup::isGroupLeader() (line 21)
      167. #3 wcf\system\menu\user\ModeratedUserGroupsMenuItemProvider->isVisible() (line 33)
      168. #4 wcf\system\menu\user\UserMenu->checkMenuItem() (line 113)
      169. #5 wcf\system\menu\TreeMenu->checkMenuItems() (line 115)
      170. #6 wcf\system\menu\TreeMenu->checkMenuItems() (line 44)
      171. #7 wcf\system\menu\TreeMenu->init() (line 27)
      172. #8 wcf\system\SingletonFactory->__construct() (line 56)
      173. #9 wcf\system\SingletonFactory::getInstance()
      174. #10 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/WCF.class.php: call_user_func() (line 688)
      175. #11 wcf\system\WCF::__callStatic() (line 659)
      176. #12 wcf\system\WCF->__call() (line 789)
      177. #13 /var/www/vhosts/tos-xbox.net/httpdocs/wcf/lib/system/template/TemplateEngine.class.php: include() (line 323)
      178. #14 wcf\system\template\TemplateEngine->display() (line 305)
      179. #15 wcf\page\AbstractPage->show() (line 245)
      180. #16 clan\page\AbstractClanPage->show() (line 100)
      181. #17 wcf\page\AbstractPage->__run() (line 58)
      182. #18 wcf\system\request\Request->execute() (line 139)
      183. #19 wcf\system\request\RequestHandler->handle() (line 3)
      Display All

      Execution time:

      Source Code

      1. Execution time: 60.2124s (99,96% PHP, 0,04% SQL) | SQL queries: 15 | Memory-Usage: 7,01 MB

      Könnte es vielleicht auch an Ordner Berechtigungen liegen?


      MfG
      LatroX
    • Konnte das Problem lösen.
      Das Plugin verwendet bzw. verweist auf die Domain und die Domain konnte intern nicht von meinem Webserver nicht aufgelöst werden, wegen NAT und interner IP, etc.
      Konnte das ganze mit einem Eintrag in der hosts Datei am Server lösen.