SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Run Time: 0.000461
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 44 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 139
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/App.php at line 1899
- XF\App->preLoadData() in src/XF/App.php at line 1887
- XF\App->setup() in src/XF/Pub/App.php at line 93
- 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.000150
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1178
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 244
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 22
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 125
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_bs_lfs_tab`.*, `xf_addon_AddOn_1`.*, `xf_bs_lfs_tab_group_Group_2`.*, `xf_addon_AddOn_3`.*
FROM `xf_bs_lfs_tab`
LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bs_lfs_tab`.`addon_id`)
LEFT JOIN `xf_bs_lfs_tab_group` AS `xf_bs_lfs_tab_group_Group_2` ON (`xf_bs_lfs_tab_group_Group_2`.`group_id` = `xf_bs_lfs_tab`.`group_id`)
LEFT JOIN `xf_addon` AS `xf_addon_AddOn_3` ON (`xf_addon_AddOn_3`.`addon_id` = `xf_bs_lfs_tab_group_Group_2`.`addon_id`)
WHERE (`xf_bs_lfs_tab`.`tab_id` = 'new_threads')
LIMIT 1
Run Time: 0.000245
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_bs_lfs_tab | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SIMPLE | xf_addon_AddOn_1 | const | PRIMARY | PRIMARY | 52 | const | 1 | |
SIMPLE | xf_bs_lfs_tab_group_Group_2 | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SIMPLE | xf_addon_AddOn_3 | const | PRIMARY | PRIMARY | 52 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Controller.php at line 475
- XF\Mvc\Controller->assertRecordExistsByUnique() in src/XF/Mvc/Controller.php at line 458
- XF\Mvc\Controller->assertRecordExists() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 53
- BS\LiveForumStatistics\Pub\Controller\Statistics->assertTabViewable() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 13
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('lfsTabDefinitions')
Run Time: 0.000102
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 139
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 44
- BS\LiveForumStatistics\Entity\Tab->canView() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 55
- BS\LiveForumStatistics\Pub\Controller\Statistics->assertTabViewable() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 13
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `xf_thread`
WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`node_id` NOT IN ('169', '112', '122', '123', '124', '125', '127', '128', '129', '130', '131', '132', '133', '134', '135', '136', '137', '138', '139', '140', '141', '142', '143', '144', '145', '146', '147', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '159', '160', '161', '162', '163', '164', '165', '166', '167', '170', '171', '173', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189', '190', '191', '193', '194', '195', '196', '197', '198', '199', '200', '201', '205', '206', '211', '212', '213', '214', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '114', '115', '168', '60', '61', '62', '48', '63', '64', '65', '66', '67', '68', '69', '70', '71', '116', '117', '118', '119', '120', '121', '72', '19'))
Run Time: 0.006673
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score | node_id_sticky_state_last_post | 4 | | 13101 | Using where; Using index |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
- XF\Mvc\Entity\Finder->total() in src/addons/BS/LiveForumStatistics/Tab/Concerns/TabPagination.php at line 15
- BS\LiveForumStatistics\Tab\Threads->renderPagination() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 79
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_bs_schedule_Schedule_1`.*, `xf_user_User_2`.*, `xf_user_LastPoster_3`.*, `xf_post_FirstPost_4`.*, `xf_bookmark_item_Bookmarks_5`.*, `xf_post_LastPost_6`.*
FROM `xf_thread`
LEFT JOIN `xf_bs_schedule` AS `xf_bs_schedule_Schedule_1` ON (`xf_bs_schedule_Schedule_1`.`content_type` = 'thread' AND `xf_bs_schedule_Schedule_1`.`content_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_3` ON (`xf_user_LastPoster_3`.`user_id` = `xf_thread`.`last_post_user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_bookmark_item` AS `xf_bookmark_item_Bookmarks_5` ON (`xf_bookmark_item_Bookmarks_5`.`content_type` = 'post' AND `xf_bookmark_item_Bookmarks_5`.`content_id` = `xf_post_FirstPost_4`.`post_id` AND `xf_bookmark_item_Bookmarks_5`.`user_id` = '0')
LEFT JOIN `xf_post` AS `xf_post_LastPost_6` ON (`xf_post_LastPost_6`.`post_id` = `xf_thread`.`last_post_id`)
WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`node_id` NOT IN ('169', '112', '122', '123', '124', '125', '127', '128', '129', '130', '131', '132', '133', '134', '135', '136', '137', '138', '139', '140', '141', '142', '143', '144', '145', '146', '147', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '159', '160', '161', '162', '163', '164', '165', '166', '167', '170', '171', '173', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189', '190', '191', '193', '194', '195', '196', '197', '198', '199', '200', '201', '205', '206', '211', '212', '213', '214', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '114', '115', '168', '60', '61', '62', '48', '63', '64', '65', '66', '67', '68', '69', '70', '71', '116', '117', '118', '119', '120', '121', '72', '19'))
ORDER BY `xf_thread`.`bs_lfs_is_sticked` DESC, `xf_thread`.`bs_lfs_sticked_order` ASC, `xf_thread`.`post_date` DESC
LIMIT 10
Run Time: 0.027203
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ALL | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score | | | | 16087 | Using where; Using filesort |
SIMPLE | xf_bs_schedule_Schedule_1 | eq_ref | content_type_content_id | content_type_content_id | 31 | const,forum_casino.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_user_User_2 | eq_ref | PRIMARY | PRIMARY | 4 | forum_casino.xf_thread.user_id | 1 | |
SIMPLE | xf_user_LastPoster_3 | eq_ref | PRIMARY | PRIMARY | 4 | forum_casino.xf_thread.last_post_user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | forum_casino.xf_thread.first_post_id | 1 | |
SIMPLE | xf_bookmark_item_Bookmarks_5 | eq_ref | user_id_content_type_content_id,content_type_content_id | user_id_content_type_content_id | 35 | const,const,forum_casino.xf_post_FirstPost_4.post_id | 1 | Using where |
SIMPLE | xf_post_LastPost_6 | eq_ref | PRIMARY | PRIMARY | 4 | forum_casino.xf_thread.last_post_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 81
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- 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`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
WHERE (`xf_forum`.`node_id` = 277)
LIMIT 1
Run Time: 0.000314
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 396
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 188
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 112
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 277
Run Time: 0.000129
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 83
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1188
- XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
- XF\Entity\AbstractNode->canView() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- 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`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
WHERE (`xf_forum`.`node_id` = 16)
LIMIT 1
Run Time: 0.000212
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 396
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 188
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 112
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 16
Run Time: 0.000112
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 83
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1188
- XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
- XF\Entity\AbstractNode->canView() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- 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`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
WHERE (`xf_forum`.`node_id` = 91)
LIMIT 1
Run Time: 0.000203
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 396
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 188
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 112
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 91
Run Time: 0.000119
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 83
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1188
- XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
- XF\Entity\AbstractNode->canView() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- 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`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
WHERE (`xf_forum`.`node_id` = 54)
LIMIT 1
Run Time: 0.000196
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 396
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 188
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 112
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 54
Run Time: 0.000115
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 83
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1188
- XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
- XF\Entity\AbstractNode->canView() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- 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`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
WHERE (`xf_forum`.`node_id` = 78)
LIMIT 1
Run Time: 0.000210
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 396
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 188
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 112
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 78
Run Time: 0.000111
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 83
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1188
- XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
- XF\Entity\AbstractNode->canView() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- 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`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
WHERE (`xf_forum`.`node_id` = 77)
LIMIT 1
Run Time: 0.000190
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 396
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 188
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 112
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 77
Run Time: 0.000104
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 83
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1188
- XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
- XF\Entity\AbstractNode->canView() in src/XF/Entity/Thread.php at line 75
- XF\Entity\Thread->canView() in src/addons/BS/ScheduledPosting/XF/Entity/Thread.php at line 16
- BS\ScheduledPosting\XF\Entity\Thread->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 322
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 191
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 323
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 82
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_bs_lfs_sticked_link`.*
FROM `xf_bs_lfs_sticked_link`
WHERE (`xf_bs_lfs_sticked_link`.`is_active` = 1)
ORDER BY `xf_bs_lfs_sticked_link`.`sticked_order` ASC
Run Time: 0.000197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_bs_lfs_sticked_link | ref | is_active | is_active | 1 | const | 3 | Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/addons/BS/LiveForumStatistics/Tab/Threads.php at line 87
- BS\LiveForumStatistics\Tab\Threads->render() in src/addons/BS/LiveForumStatistics/Entity/Tab.php at line 69
- BS\LiveForumStatistics\Entity\Tab->render() in src/addons/BS/LiveForumStatistics/Pub/Controller/Statistics.php at line 15
- BS\LiveForumStatistics\Pub\Controller\Statistics->actionTab() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- 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, , , BS\LiveForumStatistics\Pub\Controller\Statistics, Tab, valid, , 1714818799,
Run Time: 0.000115
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 289
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
bytes_sent | 17184 |
bytes_received | 494882 |
packets_sent | 238 |
packets_received | 1616 |
protocol_overhead_in | 6464 |
protocol_overhead_out | 952 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 648 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 223 |
bytes_received_prepare_response_packet | 99122 |
bytes_received_change_user_packet | 393986 |
packets_sent_command | 118 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 72 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 41 |
packets_received_prepare_response | 1323 |
packets_received_change_user | 139 |
result_set_queries | 38 |
non_result_set_queries | 3 |
no_index_used | 4 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 38 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 38 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 101 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 101 |
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 | 101 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
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 | 255 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 243 |
proto_binary_fetched_int24 | 132 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 979 |
proto_binary_fetched_decimal | 69 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 34 |
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 | 671 |
proto_binary_fetched_blob | 250 |
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 | 39 |
com_stmt_execute | 39 |
com_stmt_send_long_data | 0 |
com_stmt_close | 38 |
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 | 391896 |