SELECT parent_id, content_type, COUNT(*) AS total
FROM `xf_xc_ua_node_session_activity`
WHERE `view_date` >= 1714001177
AND `content_type` in ('node', 'thread')
GROUP BY parent_id
Run Time: 0.000347
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 | | 4 | 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.000123
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_tap_content_data_TAPContentData_2`.*, `xf_seo_thread_meta_Meta_3`.*, `xf_user_User_4`.*, `xf_altt_thread_thumbnail_ThreadThumbnail_5`.*, `xf_attachment_Attachment_6`.*, `xf_attachment_data_Data_7`.*, `xf_ozzmodz_tct_thread_chapter_Chapter_8`.*, `xf_thread_Thread_9`.*, `xf_thread_ParentThread_10`.*, `xf_forum_Forum_11`.*, `xf_forum_ChaptersForum_12`.*, `xf_node_Node_13`.*, `xf_ozzmodz_tct_thread_chapter_ParentChapter_14`.*, `xf_thread_ParentThread_15`.*, `xf_forum_Forum_16`.*, `xf_forum_ChaptersForum_17`.*, `xf_node_Node_18`.*, `xf_snog_forms_forms_Form_19`.*, `xf_style_StyleStats_20`.*, `xf_style_DefaultStyleStats_21`.*, `xf_forum_Forum_22`.*, `xf_node_Node_23`.*, `xf_permission_cache_content_Permissions_24`.*
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_tap_content_data` AS `xf_tap_content_data_TAPContentData_2` ON (`xf_tap_content_data_TAPContentData_2`.`content_type` = 'thread' AND `xf_tap_content_data_TAPContentData_2`.`content_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_seo_thread_meta` AS `xf_seo_thread_meta_Meta_3` ON (`xf_seo_thread_meta_Meta_3`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_altt_thread_thumbnail` AS `xf_altt_thread_thumbnail_ThreadThumbnail_5` ON (`xf_altt_thread_thumbnail_ThreadThumbnail_5`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_6` ON (`xf_attachment_Attachment_6`.`attachment_id` = `xf_altt_thread_thumbnail_ThreadThumbnail_5`.`attachment_id`)
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_7` ON (`xf_attachment_data_Data_7`.`data_id` = `xf_attachment_Attachment_6`.`data_id`)
LEFT JOIN `xf_ozzmodz_tct_thread_chapter` AS `xf_ozzmodz_tct_thread_chapter_Chapter_8` ON (`xf_ozzmodz_tct_thread_chapter_Chapter_8`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_thread` AS `xf_thread_Thread_9` ON (`xf_thread_Thread_9`.`thread_id` = `xf_ozzmodz_tct_thread_chapter_Chapter_8`.`thread_id`)
LEFT JOIN `xf_thread` AS `xf_thread_ParentThread_10` ON (`xf_thread_ParentThread_10`.`thread_id` = `xf_ozzmodz_tct_thread_chapter_Chapter_8`.`parent_thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_11` ON (`xf_forum_Forum_11`.`node_id` = `xf_thread_ParentThread_10`.`node_id`)
LEFT JOIN `xf_forum` AS `xf_forum_ChaptersForum_12` ON (`xf_forum_ChaptersForum_12`.`node_id` = `xf_forum_Forum_11`.`ozzmodz_tct_node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_13` ON (`xf_node_Node_13`.`node_id` = `xf_forum_Forum_11`.`node_id`)
LEFT JOIN `xf_ozzmodz_tct_thread_chapter` AS `xf_ozzmodz_tct_thread_chapter_ParentChapter_14` ON (`xf_ozzmodz_tct_thread_chapter_ParentChapter_14`.`parent_thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_thread` AS `xf_thread_ParentThread_15` ON (`xf_thread_ParentThread_15`.`thread_id` = `xf_ozzmodz_tct_thread_chapter_ParentChapter_14`.`parent_thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_16` ON (`xf_forum_Forum_16`.`node_id` = `xf_thread_ParentThread_15`.`node_id`)
LEFT JOIN `xf_forum` AS `xf_forum_ChaptersForum_17` ON (`xf_forum_ChaptersForum_17`.`node_id` = `xf_forum_Forum_16`.`ozzmodz_tct_node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_18` ON (`xf_node_Node_18`.`node_id` = `xf_forum_Forum_16`.`node_id`)
LEFT JOIN `xf_snog_forms_forms` AS `xf_snog_forms_forms_Form_19` ON (`xf_snog_forms_forms_Form_19`.`oldthread` > '0' AND `xf_snog_forms_forms_Form_19`.`oldthread` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_style` AS `xf_style_StyleStats_20` ON (`xf_style_StyleStats_20`.`style_id` = `xf_user_User_4`.`style_id`)
LEFT JOIN `xf_style` AS `xf_style_DefaultStyleStats_21` ON (`xf_style_DefaultStyleStats_21`.`style_id` = '1')
LEFT JOIN `xf_forum` AS `xf_forum_Forum_22` ON (`xf_forum_Forum_22`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_23` ON (`xf_node_Node_23`.`node_id` = `xf_forum_Forum_22`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_24` ON (`xf_permission_cache_content_Permissions_24`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_24`.`content_id` = `xf_node_Node_23`.`node_id` AND `xf_permission_cache_content_Permissions_24`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '5539')
LIMIT 1
Run Time: 0.004277
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_tap_content_data_TAPContentData_2 | ALL | | | | | 6 | Using where |
SIMPLE | xf_seo_thread_meta_Meta_3 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_altt_thread_thumbnail_ThreadThumbnail_5 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_Attachment_6 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_altt_thread_thumbnail_ThreadThumbnail_5.attachment_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_7 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_attachment_Attachment_6.data_id | 1 | Using where |
SIMPLE | xf_ozzmodz_tct_thread_chapter_Chapter_8 | eq_ref | thread_id,thread_id_parent_thread_id | thread_id | 4 | const | 1 | |
SIMPLE | xf_thread_Thread_9 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_ozzmodz_tct_thread_chapter_Chapter_8.thread_id | 1 | Using where |
SIMPLE | xf_thread_ParentThread_10 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_ozzmodz_tct_thread_chapter_Chapter_8.parent_thread_id | 1 | Using where |
SIMPLE | xf_forum_Forum_11 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread_ParentThread_10.node_id | 1 | Using where |
SIMPLE | xf_forum_ChaptersForum_12 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_11.ozzmodz_tct_node_id | 1 | Using where |
SIMPLE | xf_node_Node_13 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_11.node_id | 1 | Using where |
SIMPLE | xf_ozzmodz_tct_thread_chapter_ParentChapter_14 | ref | parent_thread_id | parent_thread_id | 4 | const | 1 | |
SIMPLE | xf_thread_ParentThread_15 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_ozzmodz_tct_thread_chapter_ParentChapter_14.parent_thread_id | 1 | Using where |
SIMPLE | xf_forum_Forum_16 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_thread_ParentThread_15.node_id | 1 | Using where |
SIMPLE | xf_forum_ChaptersForum_17 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_16.ozzmodz_tct_node_id | 1 | Using where |
SIMPLE | xf_node_Node_18 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_16.node_id | 1 | Using where |
SIMPLE | xf_snog_forms_forms_Form_19 | ref | oldthread | oldthread | 4 | const | 1 | Using where |
SIMPLE | xf_style_StyleStats_20 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_user_User_4.style_id | 1 | Using where |
SIMPLE | xf_style_DefaultStyleStats_21 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_22 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_23 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_forum_Forum_22.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_24 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,edewan_db.xf_node_Node_23.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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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` = 14)
LIMIT 1
Run Time: 0.001101
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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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` = 5539)
LIMIT 1
Run Time: 0.001151
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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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`.*, `xf_tap_post_TAPAnonymousPost_11`.*
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`)
LEFT JOIN `xf_tap_post` AS `xf_tap_post_TAPAnonymousPost_11` ON (`xf_tap_post_TAPAnonymousPost_11`.`post_id` = `xf_post`.`post_id`)
WHERE (`xf_post`.`thread_id` = 5539) 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.006513
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 | 3 | 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 | |
SIMPLE | xf_tap_post_TAPAnonymousPost_11 | eq_ref | PRIMARY | PRIMARY | 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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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` = 20325)
LIMIT 1
Run Time: 0.000302
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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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` = 20348)
LIMIT 1
Run Time: 0.000196
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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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` = 28580)
LIMIT 1
Run Time: 0.000172
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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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 (20325))
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.001319
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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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` = 5539)
ORDER BY `xf_uw_comment`.`comment_date` DESC
LIMIT 1
Run Time: 0.002074
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_uw_comment | ALL | | | | | 3205 | 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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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: 5539, 0, 1714002077
Run Time: 0.004051
- 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/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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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.000384
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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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.000273
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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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: 5539
Run Time: 0.000099
- 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/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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 `ewr_porta_articles`.*
FROM `ewr_porta_articles`
WHERE (`ewr_porta_articles`.`thread_id` = 5539)
LIMIT 1
Run Time: 0.000415
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/EWR/Porta/Entity/Thread.php at line 12
- EWR\Porta\Entity\Thread->isPortaArticle() in src/addons/EWR/Porta/ThreadType/Article.php at line 28
- EWR\Porta\ThreadType\Article->getThreadViewTemplateOverrides() in src/XF/Pub/Controller/Thread.php at line 172
- XF\Pub\Controller\Thread->actionIndex() in src/addons/XV/Pub/Controller/Thread.php at line 11
- XV\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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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, 14)) 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.001446
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_af_as_user_award | range | award_id,user_id,status,is_featured,award_id_status | user_id | 4 | | 3 | Using index condition; Using where; Using filesort |
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 |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | edewan_db.xf_af_as_user_award.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/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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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` = '5539')
ORDER BY `xf_andy_calendar`.`calendar_date` ASC
Run Time: 0.000264
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/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\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/AnonymousPosting/XF/Pub/Controller/Thread.php at line 15
- Truonglv\AnonymousPosting\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/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 (20348, 28580)) AND (`xf_uw_comment`.`status` IN (1))
ORDER BY `xf_uw_comment`.`comment_date` ASC
Run Time: 0.002970
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_uw_comment | ALL | | | | | 3205 | 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/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_tap_content_data_TAPContentData_2`.*, `xf_seo_thread_meta_Meta_3`.*
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_tap_content_data` AS `xf_tap_content_data_TAPContentData_2` ON (`xf_tap_content_data_TAPContentData_2`.`content_type` = 'thread' AND `xf_tap_content_data_TAPContentData_2`.`content_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_seo_thread_meta` AS `xf_seo_thread_meta_Meta_3` ON (`xf_seo_thread_meta_Meta_3`.`thread_id` = `xf_thread`.`thread_id`)
WHERE (`xf_thread`.`thread_id` = '5539')
LIMIT 1
Run Time: 0.000543
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_tap_content_data_TAPContentData_2 | ALL | | | | | 6 | Using where |
SIMPLE | xf_seo_thread_meta_Meta_3 | eq_ref | 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 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` = 14)
LIMIT 1
Run Time: 0.000258
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=5539, 1714002077, claudebot
Run Time: 0.000181
- 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 `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.000275
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.001320
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 | 8 | 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.001343
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 | 8 | 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.000492
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.000509
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.000111
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.000389
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_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.000960
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 1216
- 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 1635
- 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.001121
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/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 1359
- 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 1635
- 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.000445
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 1398
- 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 1635
- 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` = 5539)
LIMIT 1
Run Time: 0.000684
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 49
- 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 715
- 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 1559
- 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 1635
- 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', 'zodiac_taurus')
Params: 2
Run Time: 0.000412
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()
- strval() in src/XF/Template/Templater.php at line 4773
- XF\Template\Templater->filterHtmlspecialchars() in src/XF/Template/Templater.php at line 4731
- XF\Template\Templater->filterForAttr() in src/addons/X0815/ZodiacSigns/Signs/AbstractSigns.php at line 57
- X0815\ZodiacSigns\Signs\AbstractSigns->getSignHtmlCode() in src/addons/X0815/ZodiacSigns/XF/Entity/UserProfile.php at line 20
- X0815\ZodiacSigns\XF\Entity\UserProfile->getAge() 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/XF/Template/Templater.php at line 4337
- XF\Template\Templater->fnUserBlurb() in src/addons/X0815/ZodiacSigns/XF/Template/Templater.php at line 11
- X0815\ZodiacSigns\XF\Template\Templater->fnUserBlurb()
- 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_article_macros.php at line 326
- 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_article_macros.php at line 185
- 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 834
- 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 1583
- 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 1635
- 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 ('af_as_user_award_tooltip')
Params: 2
Run Time: 0.000296
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 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 232
- 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 1701
- 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 1635
- 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.000373
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.000213
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.000067
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.000944
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` < 1714002077) AND (`xfa_xcountdown`.`end_date` > 1714002077) AND (`xfa_xcountdown`.`location` LIKE '%header%')
ORDER BY `xfa_xcountdown`.`end_date` ASC
Run Time: 0.000841
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 `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` = 2)
LIMIT 1
Run Time: 0.001219
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/XF/Mvc/Entity/Manager.php at line 357
- 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 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l2/s1/public/bm_ehdaa_index.php at line 34
- 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 2407
- 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 cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 259
Run Time: 0.000285
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 255
- XF\Entity\User->isLinkTrusted() in src/XF/BbCode/Renderer/Html.php at line 241
- XF\BbCode\Renderer\Html->setupRenderOptions() in src/XF/BbCode/Traverser.php at line 34
- 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/bm_ehdaa_index.php at line 49
- 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 2407
- 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.000394
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 2722
- 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.000193
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 2722
- 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.000170
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 2722
- 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 | 46882 |
bytes_received | 1599741 |
packets_sent | 526 |
packets_received | 8140 |
protocol_overhead_in | 32560 |
protocol_overhead_out | 2104 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1683 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 485 |
bytes_received_prepare_response_packet | 653181 |
bytes_received_change_user_packet | 942476 |
packets_sent_command | 262 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 187 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 89 |
packets_received_prepare_response | 7417 |
packets_received_change_user | 358 |
result_set_queries | 84 |
non_result_set_queries | 5 |
no_index_used | 16 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 84 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 86 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 274 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 274 |
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 | 274 |
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 | 1276 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 1538 |
proto_binary_fetched_int24 | 192 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 3227 |
proto_binary_fetched_decimal | 134 |
proto_binary_fetched_float | 130 |
proto_binary_fetched_double | 45 |
proto_binary_fetched_date | 217 |
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 | 1988 |
proto_binary_fetched_blob | 1090 |
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 | 87 |
com_stmt_execute | 87 |
com_stmt_send_long_data | 0 |
com_stmt_close | 86 |
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 | 935901 |