SELECT parent_id, content_type, COUNT(*) AS total
FROM `xf_xc_ua_node_session_activity`
WHERE `view_date` >= 1711710264
AND `content_type` in ('node', 'thread')
GROUP BY parent_id
Run Time: 0.000305
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xc_ua_node_session_activity | range | view_date | view_date | 4 | | 3 | Using where; Using temporary; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 165
- XF\Db\AbstractAdapter->fetchAllKeyed() in src/addons/XenConcept/UserActivity/Repository/NodeSessionActivity.php at line 232
- XenConcept\UserActivity\Repository\NodeSessionActivity->countUserNodeSessionActivityForForumListViewers() in src/addons/XenConcept/UserActivity/Listener/Listener.php at line 49
- XenConcept\UserActivity\Listener\Listener::appSetup()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 1890
- XF\App->setup() in src/XF/Pub/App.php at line 91
- XF\Pub\App->setup() in src/XF.php at line 485
- XF::setupApp() in src/XF.php at line 508
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000131
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1176
- XF\Entity\User->hasPermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 273
- DBTech\Shop\XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 913
- XF\Entity\User->canStartConversation() in src/addons/EAEAddons/ConversationTools/XF/Entity/User.php at line 13
- EAEAddons\ConversationTools\XF\Entity\User->canStartConversation() in src/addons/EAEAddons/ConversationTools/Listener.php at line 189
- EAEAddons\ConversationTools\Listener::appPubStartEnd()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Pub/App.php at line 199
- XF\Pub\App->start() in src/XF/App.php at line 2340
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_snog_private_thread_PrivateThread_1`.*, `xf_seo_thread_meta_Meta_2`.*, `xf_user_User_3`.*, `xf_altt_thread_thumbnail_ThreadThumbnail_4`.*, `xf_attachment_Attachment_5`.*, `xf_attachment_data_Data_6`.*, `xf_ozzmodz_tct_thread_chapter_Chapter_7`.*, `xf_thread_Thread_8`.*, `xf_thread_ParentThread_9`.*, `xf_forum_Forum_10`.*, `xf_forum_ChaptersForum_11`.*, `xf_node_Node_12`.*, `xf_ozzmodz_tct_thread_chapter_ParentChapter_13`.*, `xf_thread_ParentThread_14`.*, `xf_forum_Forum_15`.*, `xf_forum_ChaptersForum_16`.*, `xf_node_Node_17`.*, `xf_snog_forms_forms_Form_18`.*, `xf_style_StyleStats_19`.*, `xf_style_DefaultStyleStats_20`.*, `xf_forum_Forum_21`.*, `xf_node_Node_22`.*, `xf_permission_cache_content_Permissions_23`.*
FROM `xf_thread`
LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_1` ON (`xf_snog_private_thread_PrivateThread_1`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_seo_thread_meta` AS `xf_seo_thread_meta_Meta_2` ON (`xf_seo_thread_meta_Meta_2`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_altt_thread_thumbnail` AS `xf_altt_thread_thumbnail_ThreadThumbnail_4` ON (`xf_altt_thread_thumbnail_ThreadThumbnail_4`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_5` ON (`xf_attachment_Attachment_5`.`attachment_id` = `xf_altt_thread_thumbnail_ThreadThumbnail_4`.`attachment_id`)
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_6` ON (`xf_attachment_data_Data_6`.`data_id` = `xf_attachment_Attachment_5`.`data_id`)
LEFT JOIN `xf_ozzmodz_tct_thread_chapter` AS `xf_ozzmodz_tct_thread_chapter_Chapter_7` ON (`xf_ozzmodz_tct_thread_chapter_Chapter_7`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_thread` AS `xf_thread_Thread_8` ON (`xf_thread_Thread_8`.`thread_id` = `xf_ozzmodz_tct_thread_chapter_Chapter_7`.`thread_id`)
LEFT JOIN `xf_thread` AS `xf_thread_ParentThread_9` ON (`xf_thread_ParentThread_9`.`thread_id` = `xf_ozzmodz_tct_thread_chapter_Chapter_7`.`parent_thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_10` ON (`xf_forum_Forum_10`.`node_id` = `xf_thread_ParentThread_9`.`node_id`)
LEFT JOIN `xf_forum` AS `xf_forum_ChaptersForum_11` ON (`xf_forum_ChaptersForum_11`.`node_id` = `xf_forum_Forum_10`.`ozzmodz_tct_node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_12` ON (`xf_node_Node_12`.`node_id` = `xf_forum_Forum_10`.`node_id`)
LEFT JOIN `xf_ozzmodz_tct_thread_chapter` AS `xf_ozzmodz_tct_thread_chapter_ParentChapter_13` ON (`xf_ozzmodz_tct_thread_chapter_ParentChapter_13`.`parent_thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_thread` AS `xf_thread_ParentThread_14` ON (`xf_thread_ParentThread_14`.`thread_id` = `xf_ozzmodz_tct_thread_chapter_ParentChapter_13`.`parent_thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_15` ON (`xf_forum_Forum_15`.`node_id` = `xf_thread_ParentThread_14`.`node_id`)
LEFT JOIN `xf_forum` AS `xf_forum_ChaptersForum_16` ON (`xf_forum_ChaptersForum_16`.`node_id` = `xf_forum_Forum_15`.`ozzmodz_tct_node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_17` ON (`xf_node_Node_17`.`node_id` = `xf_forum_Forum_15`.`node_id`)
LEFT JOIN `xf_snog_forms_forms` AS `xf_snog_forms_forms_Form_18` ON (`xf_snog_forms_forms_Form_18`.`oldthread` > '0' AND `xf_snog_forms_forms_Form_18`.`oldthread` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_style` AS `xf_style_StyleStats_19` ON (`xf_style_StyleStats_19`.`style_id` = `xf_user_User_3`.`style_id`)
LEFT JOIN `xf_style` AS `xf_style_DefaultStyleStats_20` ON (`xf_style_DefaultStyleStats_20`.`style_id` = '1')
LEFT JOIN `xf_forum` AS `xf_forum_Forum_21` ON (`xf_forum_Forum_21`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_22` ON (`xf_node_Node_22`.`node_id` = `xf_forum_Forum_21`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_23` ON (`xf_permission_cache_content_Permissions_23`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_23`.`content_id` = `xf_node_Node_22`.`node_id` AND `xf_permission_cache_content_Permissions_23`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '6414')
LIMIT 1
Run Time: 0.003710
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_private_thread_PrivateThread_1 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_seo_thread_meta_Meta_2 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_altt_thread_thumbnail_ThreadThumbnail_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_Attachment_5 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_attachment_data_Data_6 | const | PRIMARY | | | | 1 | |
SIMPLE | xf_ozzmodz_tct_thread_chapter_Chapter_7 | const | thread_id,thread_id_parent_thread_id | thread_id | 4 | const | 0 | Unique row not found |
SIMPLE | xf_thread_Thread_8 | const | PRIMARY | | | | 1 | |
SIMPLE | xf_thread_ParentThread_9 | const | PRIMARY | | | | 1 | |
SIMPLE | xf_forum_Forum_10 | const | PRIMARY | | | | 1 | |
SIMPLE | xf_forum_ChaptersForum_11 | const | PRIMARY | | | | 1 | |
SIMPLE | xf_node_Node_12 | const | PRIMARY | | | | 1 | |
SIMPLE | xf_ozzmodz_tct_thread_chapter_ParentChapter_13 | ref | parent_thread_id | parent_thread_id | 4 | const | 1 | |
SIMPLE | xf_thread_ParentThread_14 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_ozzmodz_tct_thread_chapter_ParentChapter_13.parent_thread_id | 1 | Using where |
SIMPLE | xf_forum_Forum_15 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread_ParentThread_14.node_id | 1 | Using where |
SIMPLE | xf_forum_ChaptersForum_16 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_15.ozzmodz_tct_node_id | 1 | Using where |
SIMPLE | xf_node_Node_17 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_15.node_id | 1 | Using where |
SIMPLE | xf_snog_forms_forms_Form_18 | ref | oldthread | oldthread | 4 | const | 1 | Using where |
SIMPLE | xf_style_StyleStats_19 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_style_DefaultStyleStats_20 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_21 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_22 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_21.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_23 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_node_Node_22.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Thread.php at line 1710
- XF\Pub\Controller\Thread->assertViewableThread() in src/addons/nanocode/ForumRules/XF/Pub/Controller/Thread.php at line 9
- nanocode\ForumRules\XF\Pub\Controller\Thread->assertViewableThread() in src/addons/Siropu/EasyUserBan/XF/Pub/Controller/Thread.php at line 46
- Siropu\EasyUserBan\XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 15
- XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_easy_user_ban_forum`.*, `xf_forum_Forum_1`.*, `xf_user_User_2`.*, `xf_user_BanUser_3`.*
FROM `xf_siropu_easy_user_ban_forum`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_siropu_easy_user_ban_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_siropu_easy_user_ban_forum`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_BanUser_3` ON (`xf_user_BanUser_3`.`user_id` = `xf_siropu_easy_user_ban_forum`.`ban_user_id`)
WHERE (`xf_siropu_easy_user_ban_forum`.`user_id` = 0) AND (`xf_siropu_easy_user_ban_forum`.`node_id` = 45)
LIMIT 1
Run Time: 0.000913
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
- XF\Mvc\Entity\FinderCollection->offsetGet() in src/XF/Mvc/Entity/FinderCollection.php at line 111
- XF\Mvc\Entity\FinderCollection->offsetExists() in src/addons/Siropu/EasyUserBan/XF/Entity/User.php at line 11
- Siropu\EasyUserBan\XF\Entity\User->isBannedInForum() in src/addons/Siropu/EasyUserBan/XF/Pub/Controller/Thread.php at line 52
- Siropu\EasyUserBan\XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 15
- XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_easy_user_ban_thread`.*, `xf_thread_Thread_1`.*, `xf_user_User_2`.*, `xf_user_BanUser_3`.*
FROM `xf_siropu_easy_user_ban_thread`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_siropu_easy_user_ban_thread`.`thread_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_siropu_easy_user_ban_thread`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_BanUser_3` ON (`xf_user_BanUser_3`.`user_id` = `xf_siropu_easy_user_ban_thread`.`ban_user_id`)
WHERE (`xf_siropu_easy_user_ban_thread`.`user_id` = 0) AND (`xf_siropu_easy_user_ban_thread`.`thread_id` = 6414)
LIMIT 1
Run Time: 0.001016
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
- XF\Mvc\Entity\FinderCollection->offsetGet() in src/XF/Mvc/Entity/FinderCollection.php at line 111
- XF\Mvc\Entity\FinderCollection->offsetExists() in src/addons/Siropu/EasyUserBan/XF/Entity/User.php at line 62
- Siropu\EasyUserBan\XF\Entity\User->isBannedInThread() in src/addons/Siropu/EasyUserBan/XF/Pub/Controller/Thread.php at line 52
- Siropu\EasyUserBan\XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 15
- XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_snog_osbrowser_OSBrowser_1`.*, `xf_allm_tag_cache_TagCache_2`.*, `xf_user_User_3`.*, `xf_user_option_Option_4`.*, `xf_user_profile_Profile_5`.*, `xf_user_privacy_Privacy_6`.*, `xf_permission_combination_PermissionCombination_7`.*, `xf_session_activity_Activity_8`.*, `xf_tl_schedule_content_TSC_Schedule_9`.*, `xf_snog_forms_promotions_Promotions_10`.*
FROM `xf_post`
LEFT JOIN `xf_snog_osbrowser` AS `xf_snog_osbrowser_OSBrowser_1` ON (`xf_snog_osbrowser_OSBrowser_1`.`post_id` = `xf_post`.`post_id`)
LEFT JOIN `xf_allm_tag_cache` AS `xf_allm_tag_cache_TagCache_2` ON (`xf_allm_tag_cache_TagCache_2`.`content_id` = `xf_post`.`post_id` AND `xf_allm_tag_cache_TagCache_2`.`content_type` = 'post')
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_4` ON (`xf_user_option_Option_4`.`user_id` = `xf_user_User_3`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_5` ON (`xf_user_profile_Profile_5`.`user_id` = `xf_user_User_3`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_6` ON (`xf_user_privacy_Privacy_6`.`user_id` = `xf_user_User_3`.`user_id`)
LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_7` ON (`xf_permission_combination_PermissionCombination_7`.`permission_combination_id` = `xf_user_User_3`.`permission_combination_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_8` ON (`xf_session_activity_Activity_8`.`user_id` = `xf_user_User_3`.`user_id` AND `xf_session_activity_Activity_8`.`unique_key` = CONCAT(`xf_user_User_3`.`user_id`, ''))
LEFT JOIN `xf_tl_schedule_content` AS `xf_tl_schedule_content_TSC_Schedule_9` ON (`xf_tl_schedule_content_TSC_Schedule_9`.`content_id` = `xf_post`.`post_id` AND `xf_tl_schedule_content_TSC_Schedule_9`.`content_type` = 'post')
LEFT JOIN `xf_snog_forms_promotions` AS `xf_snog_forms_promotions_Promotions_10` ON (`xf_snog_forms_promotions_Promotions_10`.`post_id` = `xf_post`.`post_id`)
WHERE (`xf_post`.`thread_id` = 6414) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`ozzmodz_sc_is_scheduled` = 0) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.003607
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | ref | thread_id_post_date,thread_id_position,thread_id_score_date | thread_id_post_date | 4 | const | 1 | Using where; Using temporary; Using filesort |
SIMPLE | xf_snog_osbrowser_OSBrowser_1 | ref | post_id | post_id | 4 | edewan_db.xf_post.post_id | 1 | |
SIMPLE | xf_allm_tag_cache_TagCache_2 | eq_ref | PRIMARY | PRIMARY | 31 | const,edewan_db.xf_post.post_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_4 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_3.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_5 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_3.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_6 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_3.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_7 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_3.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_8 | eq_ref | PRIMARY | PRIMARY | 22 | edewan_db.xf_user_User_3.user_id,func | 1 | Using where |
SIMPLE | xf_tl_schedule_content_TSC_Schedule_9 | ALL | content_id_content_type | | | | 1 | Using where; Using join buffer (flat, BNL join) |
SIMPLE | xf_snog_forms_promotions_Promotions_10 | eq_ref | post_id | post_id | 4 | edewan_db.xf_post.post_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/AddonsLab/LinkChecker/XF/Finder/Post.php at line 63
- AddonsLab\LinkChecker\XF\Finder\Post->fetch() in src/addons/SV/StickyAnyPost/XF/Finder/Post.php at line 120
- SV\StickyAnyPost\XF\Finder\Post->fetch() in src/XF/Pub/Controller/Thread.php at line 63
- XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_allm_tag_cache`.*
FROM `xf_allm_tag_cache`
WHERE (`xf_allm_tag_cache`.`content_type` = 'post') AND (`xf_allm_tag_cache`.`content_id` = 22031)
LIMIT 1
Run Time: 0.000191
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 508
- XF\Mvc\Entity\Entity->getExistingRelation() in src/addons/AddonsLab/LinkChecker/XF/Finder/Post.php at line 83
- AddonsLab\LinkChecker\XF\Finder\Post->fetch() in src/addons/SV/StickyAnyPost/XF/Finder/Post.php at line 120
- SV\StickyAnyPost\XF\Finder\Post->fetch() in src/XF/Pub/Controller/Thread.php at line 63
- XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*, `xf_mg_media_item_XfmgMirrorMedia_2`.*, `xf_mg_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
LEFT JOIN `xf_mg_media_item` AS `xf_mg_media_item_XfmgMirrorMedia_2` ON (`xf_mg_media_item_XfmgMirrorMedia_2`.`media_id` = `xf_attachment_data_Data_1`.`xfmg_mirror_media_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_3` ON (`xf_mg_category_Category_3`.`category_id` = `xf_mg_media_item_XfmgMirrorMedia_2`.`category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'xfmg_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_mg_category_Category_3`.`category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` IN (22031))
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000763
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_attachment.data_id | 1 | |
SIMPLE | xf_mg_media_item_XfmgMirrorMedia_2 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_attachment_data_Data_1.xfmg_mirror_media_id | 1 | Using where |
SIMPLE | xf_mg_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_mg_media_item_XfmgMirrorMedia_2.category_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_mg_category_Category_3.category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Attachment.php at line 238
- XF\Repository\Attachment->addAttachmentsToContent() in src/XF/ControllerPlugin/Thread.php at line 47
- XF\ControllerPlugin\Thread->fetchExtraContentForPostsFullView() in src/XF/Pub/Controller/Thread.php at line 108
- XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_uw_comment`.*
FROM `xf_uw_comment`
WHERE (`xf_uw_comment`.`thread_id` = 6414)
ORDER BY `xf_uw_comment`.`comment_date` DESC
LIMIT 1
Run Time: 0.001882
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_uw_comment | ALL | | | | | 3203 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/UW/FCS/Extend/Repository/Thread.php at line 13
- UW\FCS\Extend\Repository\Thread->markThreadReadByVisitor() in src/XF/Pub/Controller/Thread.php at line 134
- XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
INSERT INTO `xf_xc_ua_thread_read` (`thread_id`, `user_id`, `thread_read_date`) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE thread_read_date = VALUES(thread_read_date)
Params: 6414, 0, 1711711164
Run Time: 0.010685
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
- XF\Db\AbstractAdapter->insert() in src/addons/XenConcept/UserActivity/XF/Repository/Thread.php at line 120
- XenConcept\UserActivity\XF\Repository\Thread->markThreadReadByUser() in src/addons/XV/Repository/Thread.php at line 11
- XV\Repository\Thread->markThreadReadByUser() in src/addons/UW/FCS/Extend/Repository/Thread.php at line 21
- UW\FCS\Extend\Repository\Thread->markThreadReadByVisitor() in src/XF/Pub/Controller/Thread.php at line 134
- XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_dbtech_credits_event`.*
FROM `xf_dbtech_credits_event`
WHERE (`xf_dbtech_credits_event`.`event_trigger_id` = 'read')
Run Time: 0.000363
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_dbtech_credits_event | ALL | | | | | 39 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 174
- DBTech\Credits\EventTrigger\AbstractHandler->getEvents() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 204
- DBTech\Credits\EventTrigger\AbstractHandler->getApplicableEvents() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 503
- DBTech\Credits\EventTrigger\AbstractHandler->trigger() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 431
- DBTech\Credits\EventTrigger\AbstractHandler->apply() in src/addons/DBTech/Credits/XF/Repository/Thread.php at line 21
- DBTech\Credits\XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 139
- XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_dbtech_credits_event`.*
FROM `xf_dbtech_credits_event`
WHERE (`xf_dbtech_credits_event`.`event_trigger_id` = 'view')
Run Time: 0.000286
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_dbtech_credits_event | ALL | | | | | 39 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 174
- DBTech\Credits\EventTrigger\AbstractHandler->getEvents() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 204
- DBTech\Credits\EventTrigger\AbstractHandler->getApplicableEvents() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 503
- DBTech\Credits\EventTrigger\AbstractHandler->trigger() in src/addons/DBTech/Credits/EventTrigger/View.php at line 34
- DBTech\Credits\EventTrigger\View->trigger() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 431
- DBTech\Credits\EventTrigger\AbstractHandler->apply() in src/addons/DBTech/Credits/XF/Repository/Thread.php at line 37
- DBTech\Credits\XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 139
- XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
INSERT INTO xf_thread_view
(thread_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 6414
Run Time: 0.000085
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Thread.php at line 193
- XF\Repository\Thread->logThreadView() in src/addons/DBTech/Credits/XF/Repository/Thread.php at line 41
- DBTech\Credits\XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 139
- XF\Pub\Controller\Thread->actionIndex() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 13
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_af_as_user_award`.*, `xf_user_User_1`.*, `xf_af_as_award_Award_2`.*
FROM `xf_af_as_user_award`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_af_as_user_award`.`user_id`)
INNER JOIN `xf_af_as_award` AS `xf_af_as_award_Award_2` ON (`xf_af_as_award_Award_2`.`award_id` = `xf_af_as_user_award`.`award_id`)
WHERE (`xf_af_as_user_award`.`user_id` IN (11)) AND (`xf_af_as_user_award`.`status` = 'approved') AND (`xf_af_as_award_Award_2`.`can_feature` = 1) AND (`xf_af_as_user_award`.`is_featured` = 1)
ORDER BY `xf_af_as_user_award`.`display_order` ASC
Run Time: 0.001014
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_af_as_user_award | ref | award_id,user_id,status,is_featured,award_id_status | user_id | 4 | const | 2 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_af_as_award_Award_2 | eq_ref | PRIMARY,can_feature | PRIMARY | 4 | edewan_db.xf_af_as_user_award.award_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/AddonFlare/AwardSystem/Repository/UserAward.php at line 288
- AddonFlare\AwardSystem\Repository\UserAward->addUserAwardsToContent() in src/addons/AddonFlare/AwardSystem/XF/Pub/Controller/Thread.php at line 18
- AddonFlare\AwardSystem\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 16
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_andy_calendar`.*
FROM `xf_andy_calendar`
WHERE (`xf_andy_calendar`.`thread_id` = '6414')
ORDER BY `xf_andy_calendar`.`calendar_date` ASC
Run Time: 0.000197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_andy_calendar | ref | thread_id | thread_id | 4 | const | 1 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php at line 44
- Andy\Calendar\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php at line 12
- Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex() in src/addons/LiamW/MentionMiniAvatar/XF/Pub/Controller/Thread.php at line 14
- LiamW\MentionMiniAvatar\XF\Pub\Controller\Thread->actionIndex() in src/addons/MaZ/AMP/XF/Pub/Controller/Thread.php at line 28
- MaZ\AMP\XF\Pub\Controller\Thread->actionIndex() in src/addons/Nulumia/SeoTools/XF/Pub/Controller/Thread.php at line 12
- Nulumia\SeoTools\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Forms/XF/Pub/Controller/Thread.php at line 12
- Snog\Forms\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/PrivateThreads/XF/Pub/Controller/Thread.php at line 11
- Snog\PrivateThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/Schedule/XF/Pub/Controller/Thread.php at line 17
- Truonglv\Schedule\XF\Pub\Controller\Thread->actionIndex() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 87
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_uw_comment`.*, `xf_user_User_1`.*
FROM `xf_uw_comment`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_uw_comment`.`user_id`)
WHERE (`xf_uw_comment`.`post_id` IN (22031)) AND (`xf_uw_comment`.`status` IN (1))
ORDER BY `xf_uw_comment`.`comment_date` ASC
Run Time: 0.002271
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_uw_comment | ALL | | | | | 3203 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_uw_comment.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/UW/FCS/Extend/Pub/Controller/Thread.php at line 116
- UW\FCS\Extend\Pub\Controller\Thread->actionIndex() in src/addons/XenGenTr/ForumistatistikPlus/XF/Pub/Controller/Thread.php at line 13
- XenGenTr\ForumistatistikPlus\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 12
- XV\Pub\Controller\Thread->actionIndex() in src/addons/cv6/DiceRoller/XF/Pub/Controller/Thread.php at line 13
- cv6\DiceRoller\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 12
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_snog_private_thread_PrivateThread_1`.*, `xf_seo_thread_meta_Meta_2`.*
FROM `xf_thread`
LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_1` ON (`xf_snog_private_thread_PrivateThread_1`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_seo_thread_meta` AS `xf_seo_thread_meta_Meta_2` ON (`xf_seo_thread_meta_Meta_2`.`thread_id` = `xf_thread`.`thread_id`)
WHERE (`xf_thread`.`thread_id` = '6414')
LIMIT 1
Run Time: 0.000418
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_private_thread_PrivateThread_1 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_seo_thread_meta_Meta_2 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 27
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*
FROM `xf_node`
WHERE (`xf_node`.`node_id` = 45)
LIMIT 1
Run Time: 0.000237
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/Andy/ForumPassword/XF/Pub/Controller/Thread.php at line 36
- Andy\ForumPassword\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/StickyAnyPost/XF/Pub/Controller/Thread.php at line 17
- SV\StickyAnyPost\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XF\Pub\Controller\Thread, Index, valid, thread_id=6414, 1711711164,
Run Time: 0.000119
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/XenConcept/LoginAsUser/XF/Repository/SessionActivity.php at line 48
- XenConcept\LoginAsUser\XF\Repository\SessionActivity->updateSessionActivity() in src/addons/XenConcept/UserActivity/XF/Repository/SessionActivity.php at line 20
- XenConcept\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 42
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 287
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT node_id FROM xf_thread WHERE thread_id = ?
Params: 6414
Run Time: 0.000172
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/addons/XenConcept/UserActivity/Repository/NodeSessionActivity.php at line 139
- XenConcept\UserActivity\Repository\NodeSessionActivity->getNodeIdByThreadId() in src/addons/XenConcept/UserActivity/Repository/NodeSessionActivity.php at line 86
- XenConcept\UserActivity\Repository\NodeSessionActivity->updateNodeSessionActivity() in src/addons/XenConcept/UserActivity/XF/Repository/SessionActivity.php at line 24
- XenConcept\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 42
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 287
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT INTO xf_xc_ua_node_session_activity
(`user_id`, `unique_key`, `ip`, `content_type`, `parent_id`, `content_id`, `view_state`, `view_date`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
content_type = VALUES(content_type),
parent_id = VALUES(parent_id),
content_id = VALUES(content_id),
view_state = VALUES(view_state),
view_date = VALUES(view_date)
Params: 0, , , thread, 45, 6414, valid, 1711711164
Run Time: 0.000101
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/addons/XenConcept/UserActivity/Repository/NodeSessionActivity.php at line 133
- XenConcept\UserActivity\Repository\NodeSessionActivity->updateNodeSessionActivity() in src/addons/XenConcept/UserActivity/XF/Repository/SessionActivity.php at line 24
- XenConcept\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 42
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 287
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_fc_user_devices`.*
FROM `xf_fc_user_devices`
WHERE (`xf_fc_user_devices`.`user_id` = 0) AND (`xf_fc_user_devices`.`status` != '1') AND (`xf_fc_user_devices`.`browser_token` = 0)
LIMIT 1
Run Time: 0.000227
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_fc_user_devices | ref | user_id | user_id | 4 | const | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
- XF\Mvc\Entity\FinderCollection->offsetGet() in src/XF/Mvc/Entity/FinderCollection.php at line 111
- XF\Mvc\Entity\FinderCollection->offsetExists() in src/addons/nick97/recentlyuseddevices/XF/Entity/User.php at line 27
- nick97\recentlyuseddevices\XF\Entity\User->getCurrentVisitorLoggedDevice() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/addons/nick97/recentlyuseddevices/Listener.php at line 127
- nick97\recentlyuseddevices\Listener::controllerPostDispatch()
- call_user_func_array() in src/XF/Extension.php at line 35
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Mvc/Controller.php at line 289
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`))
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC
Run Time: 0.000743
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status_display_order | 102 | const | 10 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_siropu_ads_manager_ad.package_id | 1 | |
SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 530
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 365
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 356
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 36
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('keyword', 'affiliate')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY RAND() ASC
Run Time: 0.001134
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status | 102 | const | 10 | Using index condition; Using where; Using temporary; Using filesort |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_siropu_ads_manager_ad.package_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 635
- Siropu\AdsManager\Template\Ad->loadFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 369
- Siropu\AdsManager\Template\Ad->setFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 360
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 36
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_smilie`.*
FROM `xf_smilie`
WHERE (`xf_smilie`.`display_in_editor` = 1) AND (`xf_smilie`.`ozzmodz_sct_active` = 1)
ORDER BY `xf_smilie`.`display_order` ASC, `xf_smilie`.`display_order` ASC
Run Time: 0.000420
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_smilie | ALL | | | | | 91 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/UW/SmileysBar/Listener.php at line 51
- UW\SmileysBar\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_xentr_randomTips`.*
FROM `xf_xentr_randomTips`
ORDER BY `xf_xentr_randomTips`.`display_order` ASC
Run Time: 0.000108
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xentr_randomTips | ALL | | | | | 6 | Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/XENTR/RandomTips/RandomList.php at line 134
- XENTR\RandomTips\RandomList->getRandomList() in src/addons/XENTR/RandomTips/Listener.php at line 21
- XENTR\RandomTips\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_xentr_randomTips`.*
FROM `xf_xentr_randomTips`
ORDER BY `xf_xentr_randomTips`.`display_order` ASC
Run Time: 0.000101
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xentr_randomTips | ALL | | | | | 6 | Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/XENTR/RandomTips/RandomList.php at line 143
- XENTR\RandomTips\RandomList->getRandomList() in src/addons/XENTR/RandomTips/Listener.php at line 21
- XENTR\RandomTips\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_cv6_dice`.*
FROM `xf_cv6_dice`
WHERE (`xf_cv6_dice`.`active` = '1')
ORDER BY `xf_cv6_dice`.`display_order` ASC
Run Time: 0.000089
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cv6_dice | ALL | active | | | | 4 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/cv6/DiceRoller/Repository/Dice.php at line 50
- cv6\DiceRoller\Repository\Dice->getDiceForThreadView() in src/addons/cv6/DiceRoller/Listener.php at line 85
- cv6\DiceRoller\Listener::globalTemplateData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`attachment_id` IN ('17825'))
Run Time: 0.000421
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | const | PRIMARY,content_type_id_date | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_data_Data_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/Nulumia/XFOptimize/PriorityPreload.php at line 68
- Nulumia\XFOptimize\PriorityPreload::processContent() in src/addons/Nulumia/XFOptimize/XF/Pub/View/Thread/View.php at line 47
- Nulumia\XFOptimize\XF\Pub\View\Thread\View->renderHtml() in src/XF/Mvc/Renderer/AbstractRenderer.php at line 91
- XF\Mvc\Renderer\AbstractRenderer->renderViewObject() in src/XF/Mvc/Renderer/Html.php at line 45
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_thread_LastThreadPrivate_2`.*, `xf_snog_private_thread_PrivateThread_3`.*, `xf_snog_private_thread_HasPrivate_4`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThreadPrivate_2` ON (`xf_thread_LastThreadPrivate_2`.`node_id` = `xf_forum`.`node_id` AND `xf_thread_LastThreadPrivate_2`.`thread_id` = `xf_forum`.`last_thread_id`)
LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_PrivateThread_3` ON (`xf_snog_private_thread_PrivateThread_3`.`thread_id` = `xf_thread_LastThreadPrivate_2`.`thread_id`)
LEFT JOIN `xf_snog_private_thread` AS `xf_snog_private_thread_HasPrivate_4` ON (`xf_snog_private_thread_HasPrivate_4`.`node_id` = `xf_forum`.`node_id`)
WHERE (`xf_forum`.`node_id` = 0)
LIMIT 1
Run Time: 0.001519
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 364
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 394
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 186
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/addons/OzzModz/ThreadChapterThreads/XF/Entity/Thread.php at line 51
- OzzModz\ThreadChapterThreads\XF\Entity\Thread->getChapterForum()
- call_user_func_array() in src/XF/Template/Templater.php at line 1184
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 1245
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_dbtech_shop_item`.*, `xf_user_User_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_dbtech_shop_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_dbtech_shop_item`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_dbtech_shop_item`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'dbtech_shop_item' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_dbtech_shop_item`.`item_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
LEFT JOIN `xf_dbtech_shop_category` AS `xf_dbtech_shop_category_Category_3` ON (`xf_dbtech_shop_category_Category_3`.`category_id` = `xf_dbtech_shop_item`.`category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'dbtech_shop_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_dbtech_shop_category_Category_3`.`category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
Run Time: 0.001762
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_dbtech_shop_item | ALL | | | | | 20 | |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_dbtech_shop_item.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_dbtech_shop_item.item_id | 1 | Using where |
SIMPLE | xf_dbtech_shop_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_dbtech_shop_item.category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_dbtech_shop_category_Category_3.category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/DBTech/Shop/XF/Entity/User.php at line 228
- DBTech\Shop\XF\Entity\User->getDbtechShopPurchase() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/addons/DBTech/Shop/Repository/Purchase.php at line 296
- DBTech\Shop\Repository\Purchase->getViewablePurchasesForUser() in src/addons/DBTech/Shop/Repository/Purchase.php at line 331
- DBTech\Shop\Repository\Purchase->filterActivePurchasesForUser() in src/addons/DBTech/Shop/XF/Template/Templater.php at line 101
- DBTech\Shop\XF\Template\Templater->fnUsernameClasses() in src/addons/Nulumia/SeoTools/XF/Template/Templater.php at line 64
- Nulumia\SeoTools\XF\Template\Templater->templaterFnUsernameUnlink() in src/addons/Nulumia/SeoTools/XF/Template/Templater.php at line 21
- Nulumia\SeoTools\XF\Template\Templater->fnUsernameLink() in src/addons/OzzModz/ShowDiscouragedStatus/XF/Template/Templater.php at line 9
- OzzModz\ShowDiscouragedStatus\XF\Template\Templater->fnUsernameLink() in src/addons/Smoke/MarkScammer/XF/Template/Templater.php at line 11
- Smoke\MarkScammer\XF\Template\Templater->fnUsernameLink() in src/addons/XENTR/RichUsernamePlus/XF/Template/Templater.php at line 15
- XENTR\RichUsernamePlus\XF\Template\Templater->fnUsernameLink() in src/addons/XV/Template/Templater.php at line 59
- XV\Template\Templater->fnUsernameLink() in src/addons/BS/SpeedFix/XF/Template/Templater.php at line 14
- BS\SpeedFix\XF\Template\Templater->fnUsernameLink()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 1375
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('mh_strip_visited_thread')
Params: 2
Run Time: 0.000288
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 361
- XF\Language->loadPhrases() in src/XF/Language.php at line 259
- XF\Language->getPhraseText() in src/XF/Language.php at line 130
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Phrase.php at line 59
- XF\Phrase->__toString()
- preg_replace() in src/addons/MMO/Hide/Data/HideTags.php at line 47
- MMO\Hide\Data\HideTags->stripHideTags() in src/addons/MMO/Hide/XF/Str/Formatter.php at line 44
- MMO\Hide\XF\Str\Formatter->snippetString() in src/XF/Template/Templater.php at line 4129
- XF\Template\Templater->fnSnippet()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 1414
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_th_covers_cover`.*
FROM `xf_th_covers_cover`
WHERE (`xf_th_covers_cover`.`content_type` = 'thread') AND (`xf_th_covers_cover`.`content_id` = 6414)
LIMIT 1
Run Time: 0.000669
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_th_covers_cover | ref | content_type_id_cover_user_id | content_type_id_cover_user_id | 31 | const,const | 1 | Using index condition |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 364
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 413
- XF\Mvc\Entity\Entity->getRelationOrDefault() in src/addons/ThemeHouse/Covers/Listener/TemplaterSetup.php at line 80
- ThemeHouse\Covers\Listener\TemplaterSetup::fnGetCover()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/thcovers_cover_macros.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 43
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 980
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 916
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 733
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 980
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 916
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 1575
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('thcovers_no_edit_permissions', 'before_message', 'after_message', 'thread_status_block', 'svCustomFieldExtras_before_thread_prefix', 'af_as_user_award_tooltip')
Params: 2
Run Time: 0.000389
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 6 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 361
- XF\Language->loadPhrases() in src/XF/Language.php at line 259
- XF\Language->getPhraseText() in src/XF/Language.php at line 130
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Phrase.php at line 59
- XF\Phrase->__toString() in src/addons/AddonFlare/AwardSystem/Template/TemplaterSetup.php at line 40
- AddonFlare\AwardSystem\Template\TemplaterSetup->fnAwardImage()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/af_as_message_postbit.php at line 39
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/af_as_message_postbit.php at line 142
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1673
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l2/s1/public/message_macros.php at line 162
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 28
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 980
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 916
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 182
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 980
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 916
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 225
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 1717
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('xc_hide_links_from_guests_user_error_hide_attach_video')
Params: 2
Run Time: 0.000291
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 361
- XF\Language->loadPhrases() in src/XF/Language.php at line 259
- XF\Language->getPhraseText() in src/XF/Language.php at line 130
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Phrase.php at line 59
- XF\Phrase->__toString() in internal_data/code_cache/templates/l2/s1/public/xc_hide_links_medias_to_guests_bb_code_hide_error.php at line 11
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/addons/XenConcept/HideLinkFromGuests/XF/BbCode/Renderer/Html.php at line 52
- XenConcept\HideLinkFromGuests\XF\BbCode\Renderer\Html->renderTagAttach() in src/addons/XenSoluce/DisplayVisitorAttachments/XF/BbCode/Renderer/Html.php at line 53
- XenSoluce\DisplayVisitorAttachments\XF\BbCode\Renderer\Html->renderTagAttach() in src/addons/XV/BbCode/Renderer/Html.php at line 106
- XV\BbCode\Renderer\Html->renderTagAttach()
- call_user_func() in src/XF/BbCode/Renderer/Html.php at line 308
- XF\BbCode\Renderer\Html->renderTag() in src/addons/s9e/MediaSites/XF/BbCode/Renderer/Html.php at line 14
- s9e\MediaSites\XF\BbCode\Renderer\Html->renderTag() in src/XF/BbCode/Traverser.php at line 61
- XF\BbCode\Traverser->renderSubTree() in src/XF/BbCode/Renderer/Html.php at line 446
- XF\BbCode\Renderer\Html->renderTagAlign()
- call_user_func() in src/XF/BbCode/Renderer/Html.php at line 308
- XF\BbCode\Renderer\Html->renderTag() in src/addons/s9e/MediaSites/XF/BbCode/Renderer/Html.php at line 14
- s9e\MediaSites\XF\BbCode\Renderer\Html->renderTag() in src/XF/BbCode/Traverser.php at line 61
- XF\BbCode\Traverser->renderSubTree() in src/XF/BbCode/Traverser.php at line 37
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 20
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 220
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2362
- XF\Template\Templater->fnBbCode()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 683
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 64
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 980
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 916
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 104
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 980
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 916
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 158
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 980
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 916
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 172
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 980
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 916
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 184
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 980
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 916
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 225
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 1717
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_xp_fm`.*
FROM `xf_xp_fm`
ORDER BY `xf_xp_fm`.`display_order` ASC
Run Time: 0.000116
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xp_fm | ALL | | | | | 3 | Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/XP/FM/ButtonList.php at line 165
- XP\FM\ButtonList->getButtonList() in src/addons/XP/FM/Listener.php at line 42
- XP\FM\Listener::appPubRenderPage()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Pub/App.php at line 560
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_bm_ehdaa`.*
FROM `xf_bm_ehdaa`
ORDER BY `xf_bm_ehdaa`.`ehdaa_date` DESC
Run Time: 0.000083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_bm_ehdaa | ALL | | | | | 1 | Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/Boussaid/Ehdaa/XF/Repository/Ehdaat.php at line 19
- Boussaid\Ehdaa\XF\Repository\Ehdaat->findEhdaa() in src/addons/Boussaid/Ehdaa/PageContainer.php at line 11
- Boussaid\Ehdaa\PageContainer::extend()
- call_user_func_array() in src/XF/Extension.php at line 50
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Template/Templater.php at line 1603
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_bm_ehdaa`.*
FROM `xf_bm_ehdaa`
ORDER BY `xf_bm_ehdaa`.`ehdaa_date` DESC
Run Time: 0.000102
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_bm_ehdaa | ALL | | | | | 1 | Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/Boussaid/Ehdaa/PageContainer.php at line 13
- Boussaid\Ehdaa\PageContainer::extend()
- call_user_func_array() in src/XF/Extension.php at line 50
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Template/Templater.php at line 1603
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*, `xf_style_StyleStats_1`.*, `xf_style_DefaultStyleStats_2`.*, `xf_user_privacy_Privacy_3`.*
FROM `xf_user`
LEFT JOIN `xf_style` AS `xf_style_StyleStats_1` ON (`xf_style_StyleStats_1`.`style_id` = `xf_user`.`style_id`)
LEFT JOIN `xf_style` AS `xf_style_DefaultStyleStats_2` ON (`xf_style_DefaultStyleStats_2`.`style_id` = '1')
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_3` ON (`xf_user_privacy_Privacy_3`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` = 916)
LIMIT 1
Run Time: 0.000464
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_style_StyleStats_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_style_DefaultStyleStats_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/addons/BS/SpeedFix/FS/ExtendedHonorRoll/BestUserInXTime/Repository/BuserRepo.php at line 244
- BS\SpeedFix\FS\ExtendedHonorRoll\BestUserInXTime\Repository\BuserRepo->getActivePost() in src/addons/Shqawe/BestUserInXTime/Listener.php at line 73
- Shqawe\BestUserInXTime\Listener::getActiveThread()
- call_user_func_array() in src/XF/Extension.php at line 50
- XF\Extension->fire() in src/XF/App.php at line 2842
- XF\App->fire() in src/XF/Template/Templater.php at line 1603
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xfa_xcountdown`.*, `xfa_xcountdown_Parent_1`.*
FROM `xfa_xcountdown`
LEFT JOIN `xfa_xcountdown` AS `xfa_xcountdown_Parent_1` ON (`xfa_xcountdown_Parent_1`.`parent_id` = `xfa_xcountdown`.`parent_id`)
WHERE (`xfa_xcountdown`.`start_date` < 1711711164) AND (`xfa_xcountdown`.`end_date` > 1711711164) AND (`xfa_xcountdown`.`location` LIKE '%header%')
ORDER BY `xfa_xcountdown`.`end_date` ASC
Run Time: 0.000866
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xfa_xcountdown | ALL | | | | | 11 | Using where; Using temporary; Using filesort |
SIMPLE | xfa_xcountdown_Parent_1 | ALL | | | | | 11 | Using where; Using join buffer (flat, BNL join) |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFA/MultipleCountdowns/Template.php at line 18
- XFA\MultipleCountdowns\Template::getHeaderCountdown()
- call_user_func() in src/XF/Template/Templater.php at line 1688
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l2/s1/public/PAGE_CONTAINER.php at line 1218
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('thcovers_no_position_permissions', 'ozzmodz_wau_forum_statistics_users')
Params: 2
Run Time: 0.000348
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 2 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 361
- XF\Language->loadPhrases() in src/XF/Language.php at line 259
- XF\Language->getPhraseText() in src/XF/Language.php at line 130
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Template/Templater.php at line 3458
- XF\Template\Templater->fnPhraseDynamic() in src/addons/AL/ThreadFilter/XF/Template/Templater.php at line 53
- AL\ThreadFilter\XF\Template\Templater->fnPhraseDynamic()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 70
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1919
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/cxf_advanced_footer_widgets_links_above.php at line 12
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1673
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l2/s1/public/PAGE_CONTAINER.php at line 2694
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('ozzmodz_wau_forum_statistics_messages')
Params: 2
Run Time: 0.000087
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 361
- XF\Language->loadPhrases() in src/XF/Language.php at line 259
- XF\Language->getPhraseText() in src/XF/Language.php at line 130
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Template/Templater.php at line 3458
- XF\Template\Templater->fnPhraseDynamic() in src/addons/AL/ThreadFilter/XF/Template/Templater.php at line 53
- AL\ThreadFilter\XF\Template\Templater->fnPhraseDynamic()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 70
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1919
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/cxf_advanced_footer_widgets_links_above.php at line 12
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1673
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l2/s1/public/PAGE_CONTAINER.php at line 2694
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('ozzmodz_wau_forum_statistics_threads')
Params: 2
Run Time: 0.000082
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 361
- XF\Language->loadPhrases() in src/XF/Language.php at line 259
- XF\Language->getPhraseText() in src/XF/Language.php at line 130
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Template/Templater.php at line 3458
- XF\Template\Templater->fnPhraseDynamic() in src/addons/AL/ThreadFilter/XF/Template/Templater.php at line 53
- AL\ThreadFilter\XF\Template\Templater->fnPhraseDynamic()
- call_user_func_array() in src/XF/Template/Templater.php at line 1121
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 817
- XF\Template\Templater->callMacro() in src/addons/MaZ/AMP/XF/Template/Templater.php at line 152
- MaZ\AMP\XF\Template\TemplaterAbstract->callMacro() in internal_data/code_cache/templates/l2/s1/public/ozzmodz_wau_widget_about_us.php at line 70
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1919
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/cxf_advanced_footer_widgets_links_above.php at line 12
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1673
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l2/s1/public/PAGE_CONTAINER.php at line 2694
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1644
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AMP/Traits/Templater/XF22.php at line 52
- MaZ\AMP\XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
bytes_sent | 44248 |
bytes_received | 1278769 |
packets_sent | 496 |
packets_received | 7688 |
protocol_overhead_in | 30752 |
protocol_overhead_out | 1984 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1584 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 466 |
bytes_received_prepare_response_packet | 617281 |
bytes_received_change_user_packet | 657632 |
packets_sent_command | 247 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 176 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 84 |
packets_received_prepare_response | 7003 |
packets_received_change_user | 341 |
result_set_queries | 78 |
non_result_set_queries | 6 |
no_index_used | 14 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 78 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 81 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 263 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 263 |
rows_fetched_from_client_normal_buffered | 0 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 0 |
rows_skipped_normal | 0 |
rows_skipped_ps | 263 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 2 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 1162 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 1414 |
proto_binary_fetched_int24 | 173 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 3032 |
proto_binary_fetched_decimal | 122 |
proto_binary_fetched_float | 129 |
proto_binary_fetched_double | 43 |
proto_binary_fetched_date | 204 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 1849 |
proto_binary_fetched_blob | 1080 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 82 |
com_stmt_execute | 82 |
com_stmt_send_long_data | 0 |
com_stmt_close | 81 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 651383 |