Extrem langsames Forum nach Serverwechsel - bis zu 135 Sekunden für die Startseite

  • Hi,
    am Samstag sind wir bei 1und1 von unserem alten zu einem neuen Managedserver mit doppelt so großem Speicher gewechselt. Seit gestern macht das Forum schwere Probleme. Laut 1und1 sind seit Samstag über 67.000 Slow Querys aufgelaufen. Teilweise braucht man laut Benchmark zwischen 0.2 - 45 Sekunden um die gleiche Seite im Forum aufzurufen. Laut Debugg ist es immer die Datenbank, welche die Zeitprobleme verursacht. In den Debuggauswertungen ist aber bei der gleichen Seite immer eine andere Tabelle daran Schuld, welche extreme Zeit bei der Abfrage benötigt. So kann man also das Problem nicht eingrenzen. 1und1 sagt, der Server wäre nicht dran Schuld, obwohl es bis Freitag noch lief.

    Eine Datenbankoptimierung welche man im Adminbereich von 1und1 machen kann bricht immer ab. Die Datenbank hat eine Größe von 1,1GB.
    Jetzt gleich dazu 2 Fragen: kann kann man die Tabelle Tabelle: wcf1_moderation_queue_to_user leeren? Diese hat 569577 Einträge mit 54MB?
    Das gleiche bei wcf1_tracked_visit mit 566821 Einträgen? Evt. Funktioniert danach die Optimierung?

    Innerhalb von ein paar Minuten braucht die Seite bei drei Aufrufen von 0,2 - 135 Sekunden für die Startseite.
    Zum Beispiel wurden gerade folgende Werte beim Aufruf der Startseite als Admin erzeugt. Da ist die ganze Werbung und der Teaser deaktiviert:


    Execution time: 135.8562s (0,15% PHP, 99,85% SQL) | SQL queries: 20 | Memory-Usage: 12,39 MB
    (SQL Query) SELECT * FROM wcf1_session WHERE sessionID = ?
    Execution time: 0.2694s

    (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 = ?
    Execution time: 0.0002s

    (SQL Query) SELECT * FROM wcf1_session_virtual WHERE sessionID = ? AND ipAddress = ? AND userAgent = ?
    Execution time: 5.4374s

    (SQL Query) SELECT * FROM wcf1_user_storage WHERE userID IN (?)
    Execution time: 0.0002s

    (SQL Query) SELECT slideshow.* FROM wcf1_slideshow slideshow ORDER BY orderID
    Execution time: 0.0001s

    (SQL Query) SELECT user_option_value.userOption17 AS canViewOnlineStatus, session.userID FROM wcf1_session session LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = session.userID) WHERE session.lastActivityTime > ? AND session.spiderID IS NULL
    Execution time: 104.5436s

    (SQL Query) SELECT user_avatar.*, user_option_value.*, user_group.userOnlineMarking, user_table.*, session.* FROM wcf1_session session LEFT JOIN wcf1_user user_table ON (user_table.userID = session.userID) LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_group user_group ON (user_group.groupID = user_table.userOnlineGroupID) WHERE session.lastActivityTime > ? AND session.userID IS NOT NULL ORDER BY user_table.username
    Execution time: 0.033s

    (SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL ORDER BY thread.lastPostTime DESC LIMIT 8
    Execution time: 2.1012s

    (SQL Query) SELECT tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,user_avatar.*, user_table.email, user_table.disableAvatar, user_table.enableGravatar, user_table.gravatarFileExtension,lastposter_avatar.avatarID AS lastPosterAvatarID, lastposter_avatar.avatarName AS lastPosterAvatarName, lastposter_avatar.avatarExtension AS lastPosterAvatarExtension, lastposter_avatar.width AS lastPosterAvatarWidth, lastposter_avatar.height AS lastPosterAvatarHeight, lastposter_avatar.fileHash AS lastPosterAvatarFileHash,lastposter.email AS lastPosterEmail, lastposter.disableAvatar AS lastPosterDisableAvatar, lastposter.enableGravatar AS lastPosterEnableGravatar, lastposter.gravatarFileExtension AS lastPosterGravatarFileExtension,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID, thread.* FROM wbb1_thread thread LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 80 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 2) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 2) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 109 AND user_object_watch.userID = 2 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_user user_table ON (user_table.userID = thread.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user lastposter ON (lastposter.userID = thread.lastPosterID) LEFT JOIN wcf1_user_avatar lastposter_avatar ON (lastposter_avatar.avatarID = lastposter.avatarID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 81 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 108 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) WHERE thread.threadID IN (?,?,?,?,?,?,?,?) ORDER BY thread.lastPostTime DESC
    Execution time: 0.8366s

    (SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL ORDER BY time DESC LIMIT 8
    Execution time: 7.6322s

    (SQL Query) SELECT tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,user_avatar.*, user_table.email, user_table.disableAvatar, user_table.enableGravatar, user_table.gravatarFileExtension,lastposter_avatar.avatarID AS lastPosterAvatarID, lastposter_avatar.avatarName AS lastPosterAvatarName, lastposter_avatar.avatarExtension AS lastPosterAvatarExtension, lastposter_avatar.width AS lastPosterAvatarWidth, lastposter_avatar.height AS lastPosterAvatarHeight, lastposter_avatar.fileHash AS lastPosterAvatarFileHash,lastposter.email AS lastPosterEmail, lastposter.disableAvatar AS lastPosterDisableAvatar, lastposter.enableGravatar AS lastPosterEnableGravatar, lastposter.gravatarFileExtension AS lastPosterGravatarFileExtension,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID, thread.* FROM wbb1_thread thread LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 80 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 2) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 2) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 109 AND user_object_watch.userID = 2 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_user user_table ON (user_table.userID = thread.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user lastposter ON (lastposter.userID = thread.lastPosterID) LEFT JOIN wcf1_user_avatar lastposter_avatar ON (lastposter_avatar.avatarID = lastposter.avatarID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 81 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 108 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) WHERE thread.threadID IN (?,?,?,?,?,?,?,?) ORDER BY time DESC
    Execution time: 2.3985s

    (SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC, thread.time DESC LIMIT 5
    Execution time: 1.9251s

    (SQL Query) SELECT ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)),tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,user_avatar.*, user_table.email, user_table.disableAvatar, user_table.enableGravatar, user_table.gravatarFileExtension,lastposter_avatar.avatarID AS lastPosterAvatarID, lastposter_avatar.avatarName AS lastPosterAvatarName, lastposter_avatar.avatarExtension AS lastPosterAvatarExtension, lastposter_avatar.width AS lastPosterAvatarWidth, lastposter_avatar.height AS lastPosterAvatarHeight, lastposter_avatar.fileHash AS lastPosterAvatarFileHash,lastposter.email AS lastPosterEmail, lastposter.disableAvatar AS lastPosterDisableAvatar, lastposter.enableGravatar AS lastPosterEnableGravatar, lastposter.gravatarFileExtension AS lastPosterGravatarFileExtension,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID, thread.* FROM wbb1_thread thread LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 80 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 2) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 2) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 109 AND user_object_watch.userID = 2 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_user user_table ON (user_table.userID = thread.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user lastposter ON (lastposter.userID = thread.lastPosterID) LEFT JOIN wcf1_user_avatar lastposter_avatar ON (lastposter_avatar.avatarID = lastposter.avatarID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 81 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 108 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC, thread.time DESC
    Execution time: 7.4955s

    (SQL Query) SELECT * FROM wcf1_dashboard_custom_box WHERE boxID = ?
    Execution time: 0.0001s

    (SQL Query) SELECT COUNT(*) as messageCount FROM wcf1_cchat_message AS message INNER JOIN wcf1_cchat_message_to_user message_user ON message.messageID = message_user.messageID AND message_user.userID = ? AND message_user.seen = ? WHERE message.userID NOT IN (?)
    Execution time: 0.1503s

    (SQL Query) SELECT message.*, message_user.received FROM wcf1_cchat_message AS message INNER JOIN wcf1_cchat_message_to_user message_user ON message.messageID = message_user.messageID AND message_user.userID = ? AND message_user.seen = ? WHERE message.userID NOT IN (?)
    Execution time: 0.2785s

    (SQL Query) SELECT COUNT(*) AS count FROM wcf1_user_group_leader WHERE leaderID = ?
    Execution time: 1.053s

    (SQL Query) SELECT COUNT(*) AS count, thread.boardID FROM wbb1_thread thread LEFT JOIN wcf1_tracked_visit tracked_thread_visit ON (tracked_thread_visit.objectTypeID = 80 AND tracked_thread_visit.objectID = thread.threadID AND tracked_thread_visit.userID = 2) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 2) WHERE thread.lastPostTime > ? AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND (thread.lastPostTime > tracked_thread_visit.visitTime OR tracked_thread_visit.visitTime IS NULL) AND (thread.lastPostTime > tracked_board_visit.visitTime OR tracked_board_visit.visitTime IS NULL) GROUP BY thread.boardID
    Execution time: 0.0861s

    (SQL Query) SELECT thread.threadID, thread.languageID, thread.boardID, thread.topic, thread.lastPostTime, thread.lastPosterID, thread.lastPoster, thread.hasLabels, user_avatar.*, user_table.userID, user_table.email, user_table.disableAvatar, user_table.enableGravatar, user_table.gravatarFileExtension FROM wbb1_thread thread LEFT JOIN wcf1_user user_table ON (user_table.userID = thread.lastPosterID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) WHERE thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY thread.lastPostTime DESC, thread.lastPostID DESC
    Execution time: 1.4116s

    (SQL Query) SELECT languageItem, languageItemValue, languageCustomItemValue, languageUseCustomValue, languageCategoryID FROM wcf1_language_item WHERE languageID = ? AND languageCategoryID IN (?)
    Execution time: 0s


    Danach dies:


    Execution time: 15.921s (1,25% PHP, 98,75% SQL) | SQL queries: 24 | Memory-Usage: 12,39 MB

    (SQL Query) SELECT * FROM wcf1_session WHERE sessionID = ?
    Execution time: 1.1196s

    (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 = ?
    Execution time: 0.0002s

    (SQL Query) SELECT * FROM wcf1_session_virtual WHERE sessionID = ? AND ipAddress = ? AND userAgent = ?
    Execution time: 0.0194s

    (SQL Query) SELECT * FROM wcf1_user_storage WHERE userID IN (?)
    Execution time: 2.3292s

    (SQL Query) SELECT slideshow.* FROM wcf1_slideshow slideshow ORDER BY orderID
    Execution time: 0.0001s

    (SQL Query) SELECT user_option_value.userOption17 AS canViewOnlineStatus, session.userID FROM wcf1_session session LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = session.userID) WHERE session.lastActivityTime > ? AND session.spiderID IS NULL
    Execution time: 5.1754s

    (SQL Query) SELECT user_avatar.*, user_option_value.*, user_group.userOnlineMarking, user_table.*, session.* FROM wcf1_session session LEFT JOIN wcf1_user user_table ON (user_table.userID = session.userID) LEFT JOIN wcf1_user_option_value user_option_value ON (user_option_value.userID = user_table.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user_group user_group ON (user_group.groupID = user_table.userOnlineGroupID) WHERE session.lastActivityTime > ? AND session.userID IS NOT NULL ORDER BY user_table.username
    Execution time: 0.0198s

    (SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL ORDER BY thread.lastPostTime DESC LIMIT 8
    Execution time: 0.0002s

    (SQL Query) SELECT tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,user_avatar.*, user_table.email, user_table.disableAvatar, user_table.enableGravatar, user_table.gravatarFileExtension,lastposter_avatar.avatarID AS lastPosterAvatarID, lastposter_avatar.avatarName AS lastPosterAvatarName, lastposter_avatar.avatarExtension AS lastPosterAvatarExtension, lastposter_avatar.width AS lastPosterAvatarWidth, lastposter_avatar.height AS lastPosterAvatarHeight, lastposter_avatar.fileHash AS lastPosterAvatarFileHash,lastposter.email AS lastPosterEmail, lastposter.disableAvatar AS lastPosterDisableAvatar, lastposter.enableGravatar AS lastPosterEnableGravatar, lastposter.gravatarFileExtension AS lastPosterGravatarFileExtension,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID, thread.* FROM wbb1_thread thread LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 80 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 2) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 2) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 109 AND user_object_watch.userID = 2 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_user user_table ON (user_table.userID = thread.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user lastposter ON (lastposter.userID = thread.lastPosterID) LEFT JOIN wcf1_user_avatar lastposter_avatar ON (lastposter_avatar.avatarID = lastposter.avatarID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 81 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 108 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) WHERE thread.threadID IN (?,?,?,?,?,?,?,?) ORDER BY thread.lastPostTime DESC
    Execution time: 0.0257s

    (SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL ORDER BY time DESC LIMIT 8
    Execution time: 6.1637s

    (SQL Query) SELECT tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,user_avatar.*, user_table.email, user_table.disableAvatar, user_table.enableGravatar, user_table.gravatarFileExtension,lastposter_avatar.avatarID AS lastPosterAvatarID, lastposter_avatar.avatarName AS lastPosterAvatarName, lastposter_avatar.avatarExtension AS lastPosterAvatarExtension, lastposter_avatar.width AS lastPosterAvatarWidth, lastposter_avatar.height AS lastPosterAvatarHeight, lastposter_avatar.fileHash AS lastPosterAvatarFileHash,lastposter.email AS lastPosterEmail, lastposter.disableAvatar AS lastPosterDisableAvatar, lastposter.enableGravatar AS lastPosterEnableGravatar, lastposter.gravatarFileExtension AS lastPosterGravatarFileExtension,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID, thread.* FROM wbb1_thread thread LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 80 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 2) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 2) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 109 AND user_object_watch.userID = 2 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_user user_table ON (user_table.userID = thread.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user lastposter ON (lastposter.userID = thread.lastPosterID) LEFT JOIN wcf1_user_avatar lastposter_avatar ON (lastposter_avatar.avatarID = lastposter.avatarID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 81 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 108 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) WHERE thread.threadID IN (?,?,?,?,?,?,?,?) ORDER BY time DESC
    Execution time: 0.0037s

    (SQL Query) SELECT thread.threadID AS objectID FROM wbb1_thread thread WHERE thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC, thread.time DESC LIMIT 5
    Execution time: 0.2796s

    (SQL Query) SELECT ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)),tracked_visit.visitTime,tracked_board_visit.visitTime AS boardVisitTime,user_object_watch.watchID, user_object_watch.notification,user_avatar.*, user_table.email, user_table.disableAvatar, user_table.enableGravatar, user_table.gravatarFileExtension,lastposter_avatar.avatarID AS lastPosterAvatarID, lastposter_avatar.avatarName AS lastPosterAvatarName, lastposter_avatar.avatarExtension AS lastPosterAvatarExtension, lastposter_avatar.width AS lastPosterAvatarWidth, lastposter_avatar.height AS lastPosterAvatarHeight, lastposter_avatar.fileHash AS lastPosterAvatarFileHash,lastposter.email AS lastPosterEmail, lastposter.disableAvatar AS lastPosterDisableAvatar, lastposter.enableGravatar AS lastPosterEnableGravatar, lastposter.gravatarFileExtension AS lastPosterGravatarFileExtension,like_object.likes, like_object.dislikes,moderation_queue.queueID AS reportQueueID, thread.* FROM wbb1_thread thread LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 80 AND tracked_visit.objectID = thread.threadID AND tracked_visit.userID = 2) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 2) LEFT JOIN wcf1_user_object_watch user_object_watch ON (user_object_watch.objectTypeID = 109 AND user_object_watch.userID = 2 AND user_object_watch.objectID = thread.threadID) LEFT JOIN wcf1_user user_table ON (user_table.userID = thread.userID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) LEFT JOIN wcf1_user lastposter ON (lastposter.userID = thread.lastPosterID) LEFT JOIN wcf1_user_avatar lastposter_avatar ON (lastposter_avatar.avatarID = lastposter.avatarID) LEFT JOIN wcf1_like_object like_object ON (like_object.objectTypeID = 81 AND like_object.objectID = thread.firstPostID) LEFT JOIN wcf1_moderation_queue moderation_queue ON (moderation_queue.objectTypeID = 108 AND moderation_queue.objectID = thread.firstPostID AND moderation_queue.status <> 2 AND moderation_queue.status <> 3 AND moderation_queue.status <> 4) WHERE thread.threadID IN (?,?,?,?,?) ORDER BY ((((thread.replies + .1) * 50 + thread.views) * 1000000000000) / POWER(UNIX_TIMESTAMP() - thread.time, 1.5)) DESC, thread.time DESC
    Execution time: 0.1048s

    (SQL Query) SELECT * FROM wcf1_dashboard_custom_box WHERE boxID = ?
    Execution time: 0.0002s

    (SQL Query) SELECT languageID FROM wcf1_user_to_language WHERE userID = ?
    Execution time: 0.1366s

    (SQL Query) SELECT COUNT(*) as messageCount FROM wcf1_cchat_message AS message INNER JOIN wcf1_cchat_message_to_user message_user ON message.messageID = message_user.messageID AND message_user.userID = ? AND message_user.seen = ? WHERE message.userID NOT IN (?)
    Execution time: 0.0128s

    (SQL Query) SELECT message.*, message_user.received FROM wcf1_cchat_message AS message INNER JOIN wcf1_cchat_message_to_user message_user ON message.messageID = message_user.messageID AND message_user.userID = ? AND message_user.seen = ? WHERE message.userID NOT IN (?)
    Execution time: 0.1975s

    (SQL Query) SELECT COUNT(*) AS count FROM wcf1_user_group_leader WHERE leaderID = ?
    Execution time: 0.1052s

    (SQL Query) SELECT COUNT(*) AS count FROM wcf1_user_notification WHERE userID = ? AND confirmTime = ?
    Execution time: 0.0002s

    (SQL Query) SELECT COUNT(*) AS count FROM wbb1_thread thread LEFT JOIN wcf1_tracked_visit tracked_thread_visit ON (tracked_thread_visit.objectTypeID = 80 AND tracked_thread_visit.objectID = thread.threadID AND tracked_thread_visit.userID = 2) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 2) WHERE thread.lastPostTime > ? AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND (thread.lastPostTime > tracked_thread_visit.visitTime OR tracked_thread_visit.visitTime IS NULL) AND (thread.lastPostTime > tracked_board_visit.visitTime OR tracked_board_visit.visitTime IS NULL)
    Execution time: 0.0147s

    (SQL Query) SELECT COUNT(*) AS count FROM wcf1_user_object_watch user_object_watch LEFT JOIN wbb1_thread thread ON (thread.threadID = user_object_watch.objectID) LEFT JOIN wcf1_tracked_visit tracked_thread_visit ON (tracked_thread_visit.objectTypeID = 80 AND tracked_thread_visit.objectID = thread.threadID AND tracked_thread_visit.userID = 2) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 2) WHERE user_object_watch.objectTypeID = ? AND user_object_watch.userID = ? AND thread.lastPostTime > ? AND thread.boardID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND (thread.lastPostTime > tracked_thread_visit.visitTime OR tracked_thread_visit.visitTime IS NULL) AND (thread.lastPostTime > tracked_board_visit.visitTime OR tracked_board_visit.visitTime IS NULL)
    Execution time: 0.0014s

    (SQL Query) SELECT COUNT(*) AS count, thread.boardID FROM wbb1_thread thread LEFT JOIN wcf1_tracked_visit tracked_thread_visit ON (tracked_thread_visit.objectTypeID = 80 AND tracked_thread_visit.objectID = thread.threadID AND tracked_thread_visit.userID = 2) LEFT JOIN wcf1_tracked_visit tracked_board_visit ON (tracked_board_visit.objectTypeID = 79 AND tracked_board_visit.objectID = thread.boardID AND tracked_board_visit.userID = 2) WHERE thread.lastPostTime > ? AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL AND (thread.lastPostTime > tracked_thread_visit.visitTime OR tracked_thread_visit.visitTime IS NULL) AND (thread.lastPostTime > tracked_board_visit.visitTime OR tracked_board_visit.visitTime IS NULL) GROUP BY thread.boardID
    Execution time: 0.0112s

    (SQL Query) SELECT thread.threadID, thread.languageID, thread.boardID, thread.topic, thread.lastPostTime, thread.lastPosterID, thread.lastPoster, thread.hasLabels, user_avatar.*, user_table.userID, user_table.email, user_table.disableAvatar, user_table.enableGravatar, user_table.gravatarFileExtension FROM wbb1_thread thread LEFT JOIN wcf1_user user_table ON (user_table.userID = thread.lastPosterID) LEFT JOIN wcf1_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID) WHERE thread.threadID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY thread.lastPostTime DESC, thread.lastPostID DESC
    Execution time: 0.0006s

    (SQL Query) SELECT languageItem, languageItemValue, languageCustomItemValue, languageUseCustomValue, languageCategoryID FROM wcf1_language_item WHERE languageID = ? AND languageCategoryID IN (?)

    Beim dritten Aufruf gabs die Werte: Execution time: 0.1338s (63,75% PHP, 36,25% SQL) | SQL queries: 21 | Memory-Usage: 12,28 MB

    Insgesamt haben wir folgende Pakete installiert. Vielleicht ist ja eines der Pakete dafür bekannt Probleme zu machen?
     120 EasyLink Cr@@gle 2.0.12 pl 6 Vor 15 Stunden
     118 Moderative/administrative Funktionen in Benutzerprofilen norse/fighter456 1.0.1 Vor 21 Stunden
     117 Erweiterte Einstellmöglichkeiten für Benutzer und Administratoren norse 1.0.0 Vor 21 Stunden
     50 RecentActivity2MultiSelectOptionType nmichel 1.0.0 pl 5 Vor 21 Stunden
     16 Dashboard 'Eigene Boxen' nmichel 1.0.1 RC 1 Vor 22 Stunden
     35 VieCode Lexicon VieCode 5.2.2 Vor 22 Stunden
     113 ResizeImage The_Waiters 1.0.3 pl 1 Samstag, 17:24
     112 Teaser Slideshow Darkwood-Studios 1.0.3 pl 1 Freitag, 10:04
     110 Erweiterte Datenschutzerklärung - Google AdSense Sascha "SoftCreatR" Greuel 1.0.0 Donnerstag, 20:08
     111 Erweiterte Datenschutzerklärung - Google Analytics Sascha "SoftCreatR" Greuel 1.0.0 Donnerstag, 20:08
     109 Erweiterte Datenschutzerklärung Sascha "SoftCreatR" Greuel 1.0.0 Donnerstag, 20:08
     106 Tapatalk Tapatalk Inc 1.3.8 Donnerstag, 13:02
     105 Externe Links: Weiterleitung Sonnenspeer / Sascha Greuel 1.0.2 pl 1 Donnerstag, 12:44
     104 EasyMedia - Videos Cr@@gle 1.0.14 pl 2 Donnerstag, 01:29
     103 EasyMedia - Bilder Cr@@gle 1.0.14 pl 2 Donnerstag, 01:28
     102 EasyMedia - Datenimport Cr@@gle 1.0.3 Donnerstag, 01:27
     101 EasyMedia - Basispaket Cr@@gle 1.0.14 pl 2 Donnerstag, 01:26
     100 WoltLab Filebase WoltLab GmbH 2.1.3 Mittwoch, 20:52
     99 WoltLab Blog WoltLab GmbH 2.1.5 Mittwoch, 20:50
     98 Nutzungsbestimmungen (Regeln) Sascha "SoftCreatR" Greuel 1.0.4 pl 11 Mittwoch, 12:03
     97 Mitgliederlisten-Tabelle - Burning Board KittMedia Productions 1.0.2 Mittwoch, 11:53
     96 Mitgliederlisten-Tabelle KittMedia Productions 1.0.3 Mittwoch, 11:52
     95 Kontaktformular DevLabor UG (haftungsbeschränkt) 1.1.1 Mittwoch, 11:48
     94 cChat nodePush Christopher Walz 1.0.0 Mittwoch, 11:30
     93 cChat Pro Christopher Walz 1.0.6 Mittwoch, 11:29
     92 nodePush Tim Düsterhus 1.1.0 Mittwoch, 11:28
     91 Dompdf Brian Sweeney 0.7.0 13. August 2016
     90 Font Awesome Icon Util Maasdt 1.1.0 13. August 2016
     36 VieCode Marketplace VieCode 1.0.7 13. August 2016
     75 Benutzer Bewertung Cyperghost 2.0.2 pl 2 29. Juli 2016
     83 MediaProvider Collection The_Waiters 1.0.8 22. Juli 2016
     76 Skalierung von Dateianhängen DevLabor UG (haftungsbeschränkt) 1.1.7 14. Juli 2016
     61 UZ Benutzer-Karte Udo Zaydowicz 1.0.5 7. Juli 2016
     1 WoltLab Community Framework WoltLab GmbH 2.1.11 pl 1 1. Juli 2016
     87 Push Tim Düsterhus 1.1.1 17. Juni 2016
     86 jCounter Maximilian Mader 1.0.1 17. Juni 2016
     85 VieCode Lexicon - WoltLab Burning Board Worker VieCode 1.0.0 16. Juni 2016
     80 MediaProvider PIP iFy.re 1.0.2 16. Juni 2016
     81 Medienanbieter: Google Play (via SoftCreatR Media) Sascha "SoftCreatR" Greuel 1.1.0 16. Juni 2016
     82 Medienanbieter: Twitter (via SoftCreatR Media) Sascha "SoftCreatR" Greuel 1.0.0 16. Juni 2016
     79 MediaElement.js Integration Sascha "SoftCreatR" Greuel 1.2.0 16. Juni 2016
     6 Impressum WoltLab GmbH 2.1.1 3. Juni 2016
     5 Moderierte Benutzergruppen WoltLab GmbH 2.1.4 3. Juni 2016
     2 User Conversation System WoltLab GmbH 2.1.6 3. Juni 2016
     3 User Infraction System WoltLab GmbH 2.1.2 3. Juni 2016
     4 WoltLab Burning Board WoltLab GmbH 4.1.11 3. Juni 2016
     11 WoltLab Calendar WoltLab GmbH 2.1.3 3. Juni 2016
     74 Mobile Einstellungen KittMedia Productions 1.2.0 18. April 2016
     73 Mobiler Stilwechsler KittMedia Productions 1.1.0 18. April 2016
     8 Sprachpaket Stile cls-design.com 1.0.11 25. März 2015
     58 Metro cls-design.com 2.1.0 25. März 2015
     30 WBB 'Letzte Beiträge' nmichel 1.0.0 RC 3 27. November 2014
     53 BoardListPage: InfoBox nmichel 1.0.0 Beta 4 27. November 2014
     44 Benutzerprofilfeld Xing René Fritzsche (renegate98) 1.0.0 6. Oktober 2014
     43 Benutzerprofilfeld YouTube René Fritzsche (renegate98) 1.0.0 6. Oktober 2014
     45 Message Sidebar Icon - Konversation René Fritzsche (renegate98) 1.0.0 6. Oktober 2014
     46 Message Sidebar Icon - Mail René Fritzsche (renegate98) 1.0.0 6. Oktober 2014
     40 Erweiterung Benutzerprofilfeld ICQ Icon René Fritzsche (renegate98) 1.0.0 6. Oktober 2014
     41 Erweiterung Benutzerprofilfeld Skype Icon René Fritzsche (renegate98) 1.0.0 6. Oktober 2014
     42 Icons für Kontakt-Profilfelder in der Message Sidebar René Fritzsche (renegate98) (special support by nmichel) 1.0.1 pl 1 6. Oktober 2014
     9 Cookie-Library cls-design.com 1.0.0 16. September 2014

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!