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', 'paymentProvider', '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.000586
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 39 | 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 136
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/App.php at line 2040
- XF\App->preLoadData() in src/XF/App.php at line 2028
- XF\App->setup() in src/XF/Pub/App.php at line 94
- XF\Pub\App->setup() in src/XF.php at line 497
- XF::setupApp() in src/XF.php at line 520
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('nfDiscordConfigured')
Run Time: 0.000133
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 136
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 228
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1931
- XF\App->XF\{closure}() in src/XF/Container.php at line 31
- XF\Container->offsetGet() in src/XF/Container.php at line 90
- XF\Container->__get() in src/addons/NF/Discord/XF/Entity/User.php at line 171
- NF\Discord\XF\Entity\User::getStructure() in src/addons/SV/WarningAcknowledgement/XF/Entity/User.php at line 65
- SV\WarningAcknowledgement\XF\Entity\User::getStructure() in src/addons/NF/GiftUpgrades/XF/Entity/User.php at line 127
- NF\GiftUpgrades\XF\Entity\User::getStructure() in src/addons/SV/SignupAbuseBlocking/XF/Entity/User.php at line 369
- SV\SignupAbuseBlocking\XF\Entity\User::getStructure() in src/addons/SV/SearchImprovements/XF/Entity/User.php at line 56
- SV\SearchImprovements\XF\Entity\User::getStructure() in src/addons/SV/ReportImprovements/XF/Entity/User.php at line 223
- SV\ReportImprovements\XF\Entity\User::getStructure() in src/XF/Mvc/Entity/Manager.php at line 72
- XF\Mvc\Entity\Manager->getEntityStructure() in src/XF/Repository/User.php at line 86
- XF\Repository\User->getGuestUser() in src/XF/Repository/User.php at line 32
- XF\Repository\User->getVisitor() in src/XF/App.php at line 2054
- XF\App->getVisitorFromSession() in src/XF/Pub/App.php at line 159
- XF\Pub\App->start() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000129
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/addons/ThemeHouse/Monetize/XF/PermissionSet.php at line 27
- ThemeHouse\Monetize\XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1219
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 307
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
- 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 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_audfeeds_feed`.*
FROM `xf_audfeeds_feed`
WHERE (`xf_audfeeds_feed`.`feed_type` <> 'trending') AND (`xf_audfeeds_feed`.`active` = 1)
ORDER BY `xf_audfeeds_feed`.`display_order` ASC
Run Time: 0.000166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_audfeeds_feed | ALL | active | | | | 12 | Using where; 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 1428
- XF\Mvc\Entity\Finder->fetch() in src/addons/Audentio/Feeds/Repository/Feed.php at line 207
- Audentio\Feeds\Repository\Feed->getFeedsForList() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 197
- Audentio\Feeds\Pub\Controller\Feed->getDefaultFeed() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 60
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
Params: 1, node
Run Time: 0.000149
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 33 | 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/PermissionCache.php at line 107
- XF\PermissionCache->cacheAllContentPerms() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 83
- Audentio\Feeds\Feed\ThreadFeed->canView() in src/addons/Audentio/Feeds/Entity/Feed.php at line 274
- Audentio\Feeds\Entity\Feed->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 328
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 325
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/Audentio/Feeds/Repository/Feed.php at line 208
- Audentio\Feeds\Repository\Feed->getFeedsForList() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 197
- Audentio\Feeds\Pub\Controller\Feed->getDefaultFeed() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 60
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
Params: 1, audfeed_thread_feed
Run Time: 0.000079
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 4 | 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/PermissionCache.php at line 107
- XF\PermissionCache->cacheAllContentPerms() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 84
- Audentio\Feeds\Feed\ThreadFeed->canView() in src/addons/Audentio/Feeds/Entity/Feed.php at line 274
- Audentio\Feeds\Entity\Feed->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 328
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 325
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/Audentio/Feeds/Repository/Feed.php at line 208
- Audentio\Feeds\Repository\Feed->getFeedsForList() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 197
- Audentio\Feeds\Pub\Controller\Feed->getDefaultFeed() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 60
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_audfeeds_thread_feed`.*, `xf_audfeeds_thread_feed_watch_Watch_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_audfeeds_thread_feed`
LEFT JOIN `xf_audfeeds_thread_feed_watch` AS `xf_audfeeds_thread_feed_watch_Watch_1` ON (`xf_audfeeds_thread_feed_watch_Watch_1`.`thread_feed_id` = `xf_audfeeds_thread_feed`.`thread_feed_id` AND `xf_audfeeds_thread_feed_watch_Watch_1`.`user_id` = '0')
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'audfeed_thread_feed' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_audfeeds_thread_feed`.`thread_feed_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
Run Time: 0.000156
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_audfeeds_thread_feed | ALL | | | | | 4 | |
SIMPLE | xf_audfeeds_thread_feed_watch_Watch_1 | eq_ref | PRIMARY | PRIMARY | 8 | const,davidderin_XenForo.xf_audfeeds_thread_feed.thread_feed_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,davidderin_XenForo.xf_audfeeds_thread_feed.thread_feed_id | 1 | Using where |
- 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 1428
- XF\Mvc\Entity\Finder->fetch() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 99
- Audentio\Feeds\Feed\ThreadFeed->getThreadFeed() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 85
- Audentio\Feeds\Feed\ThreadFeed->canView() in src/addons/Audentio/Feeds/Entity/Feed.php at line 274
- Audentio\Feeds\Entity\Feed->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 328
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 325
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/addons/Audentio/Feeds/Repository/Feed.php at line 208
- Audentio\Feeds\Repository\Feed->getFeedsForList() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 197
- Audentio\Feeds\Pub\Controller\Feed->getDefaultFeed() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 60
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT node_id FROM xf_node
Run Time: 0.000061
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | index | | parent_node_id | 4 | | 33 | 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 172
- XF\Db\AbstractAdapter->fetchAllColumn() in src/addons/Audentio/Feeds/Finder/ThreadFeedEntry.php at line 85
- Audentio\Feeds\Finder\ThreadFeedEntry->loadNodePermissions() in src/addons/Audentio/Feeds/Finder/ThreadFeedEntry.php at line 172
- Audentio\Feeds\Finder\ThreadFeedEntry->forFeed() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 169
- Audentio\Feeds\Feed\ThreadFeed->getFeedItems() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 132
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread_prefix`.*
FROM `xf_thread_prefix`
WHERE (0)
Run Time: 0.000044
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE |
- 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 1428
- XF\Mvc\Entity\Finder->fetch() in src/addons/Audentio/Feeds/Feed/AbstractHandler.php at line 428
- Audentio\Feeds\Feed\AbstractHandler->loadExtraViewParams() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 47
- Audentio\Feeds\Feed\ThreadFeed->loadExtraViewParams() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 321
- Audentio\Feeds\Feed\ThreadFeed->applyFilters() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 174
- Audentio\Feeds\Feed\ThreadFeed->getFeedItems() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 132
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_th_monetize_sponsor_Sponsor_1`.*
FROM `xf_node`
LEFT JOIN `xf_th_monetize_sponsor` AS `xf_th_monetize_sponsor_Sponsor_1` ON (`xf_th_monetize_sponsor_Sponsor_1`.`th_sponsor_id` = `xf_node`.`th_sponsor_id`)
WHERE (`xf_node`.`display_in_list` = 1)
ORDER BY `xf_node`.`lft` ASC
Run Time: 0.000258
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 33 | Using where; Using filesort |
SIMPLE | xf_th_monetize_sponsor_Sponsor_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_node.th_sponsor_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/addons/Audentio/Feeds/Feed/AbstractHandler.php at line 438
- Audentio\Feeds\Feed\AbstractHandler->loadExtraViewParams() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 47
- Audentio\Feeds\Feed\ThreadFeed->loadExtraViewParams() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 321
- Audentio\Feeds\Feed\ThreadFeed->applyFilters() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 174
- Audentio\Feeds\Feed\ThreadFeed->getFeedItems() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 132
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_category`.*, `xf_node_Node_1`.*, `xf_th_monetize_sponsor_Sponsor_2`.*
FROM `xf_category`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`)
LEFT JOIN `xf_th_monetize_sponsor` AS `xf_th_monetize_sponsor_Sponsor_2` ON (`xf_th_monetize_sponsor_Sponsor_2`.`th_sponsor_id` = `xf_node_Node_1`.`th_sponsor_id`)
WHERE (`xf_category`.`node_id` IN (3, 66, 35, 150, 151))
Run Time: 0.000144
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | | 5 | Using where; Using index |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_category.node_id | 1 | |
SIMPLE | xf_th_monetize_sponsor_Sponsor_2 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_node_Node_1.th_sponsor_id | 1 | Using where |
- 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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/addons/Audentio/Feeds/Feed/AbstractHandler.php at line 439
- Audentio\Feeds\Feed\AbstractHandler->loadExtraViewParams() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 47
- Audentio\Feeds\Feed\ThreadFeed->loadExtraViewParams() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 321
- Audentio\Feeds\Feed\ThreadFeed->applyFilters() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 174
- Audentio\Feeds\Feed\ThreadFeed->getFeedItems() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 132
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*, `xf_th_monetize_sponsor_Sponsor_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_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
LEFT JOIN `xf_th_monetize_sponsor` AS `xf_th_monetize_sponsor_Sponsor_4` ON (`xf_th_monetize_sponsor_Sponsor_4`.`th_sponsor_id` = `xf_node_Node_1`.`th_sponsor_id`)
WHERE (`xf_forum`.`node_id` IN (4, 5, 6, 67, 77, 70, 144, 149, 142, 148, 145, 146, 147, 43, 44, 49, 50, 51, 52, 53, 55, 54, 56, 57, 58, 60, 59, 61))
Run Time: 0.000586
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 28 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_forum.last_thread_id | 1 | |
SIMPLE | xf_th_monetize_sponsor_Sponsor_4 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_node_Node_1.th_sponsor_id | 1 | Using where |
- 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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/addons/Audentio/Feeds/Feed/AbstractHandler.php at line 439
- Audentio\Feeds\Feed\AbstractHandler->loadExtraViewParams() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 47
- Audentio\Feeds\Feed\ThreadFeed->loadExtraViewParams() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 321
- Audentio\Feeds\Feed\ThreadFeed->applyFilters() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 174
- Audentio\Feeds\Feed\ThreadFeed->getFeedItems() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 132
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_audfeeds_thread_feed_entry`.*, `xf_thread_Thread_1`.*, `xf_poll_Poll_2`.*, `xf_audfeeds_thread_feed_Feed_3`.*, `xf_user_User_4`.*, `xf_user_LastPoster_5`.*
FROM `xf_audfeeds_thread_feed_entry`
INNER JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_audfeeds_thread_feed_entry`.`thread_id`)
LEFT JOIN `xf_poll` AS `xf_poll_Poll_2` FORCE INDEX(`content_type_content_id`) ON (`xf_poll_Poll_2`.`content_type` = 'thread' AND `xf_poll_Poll_2`.`content_id` = `xf_thread_Thread_1`.`thread_id`)
LEFT JOIN `xf_audfeeds_thread_feed` AS `xf_audfeeds_thread_feed_Feed_3` ON (`xf_audfeeds_thread_feed_Feed_3`.`thread_feed_id` = `xf_audfeeds_thread_feed_entry`.`thread_feed_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` FORCE INDEX(`PRIMARY`) ON (`xf_user_User_4`.`user_id` = `xf_thread_Thread_1`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` FORCE INDEX(`PRIMARY`) ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread_Thread_1`.`last_post_user_id`)
WHERE (`xf_audfeeds_thread_feed_entry`.`thread_feed_id` = 2) AND (`xf_audfeeds_thread_feed_entry`.`feed_entry_state` = 'visible') AND (`xf_audfeeds_thread_feed_entry`.`discussion_state` = 'visible') AND (`xf_audfeeds_thread_feed_entry`.`node_id` NOT IN (142)) AND (`xf_audfeeds_thread_feed_entry`.`sticky` = 1) AND (`xf_audfeeds_thread_feed_entry`.`unstick_on` >= 1715588859)
ORDER BY `xf_audfeeds_thread_feed_entry`.`post_date` DESC
LIMIT 25
Run Time: 0.000443
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_audfeeds_thread_feed_entry | range | thread_feed_id,thread_id,thread_feed_id_last_post_date_node_id,thread_feed_id_post_date_node_id,thread_feed_id_vote_score_node_id,thread_feed_id_first_post_reaction_score_node_id,thread_feed_id_promotion_date_node_id,sticky_unstick_on | sticky_unstick_on | 5 | | 1 | Using index condition; Using where; Using filesort |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_audfeeds_thread_feed_entry.thread_id | 1 | |
SIMPLE | xf_poll_Poll_2 | eq_ref | content_type_content_id | content_type_content_id | 31 | const,davidderin_XenForo.xf_audfeeds_thread_feed_entry.thread_id | 1 | Using where |
SIMPLE | xf_audfeeds_thread_feed_Feed_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_thread_Thread_1.user_id | 1 | |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_thread_Thread_1.last_post_user_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/addons/Audentio/Feeds/Finder/ThreadFeedEntry.php at line 527
- Audentio\Feeds\Finder\ThreadFeedEntry->fetchThreads() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 181
- Audentio\Feeds\Feed\ThreadFeed->getFeedItems() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 132
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_audfeeds_thread_feed_entry`.*, `xf_thread_Thread_1`.*, `xf_poll_Poll_2`.*, `xf_audfeeds_thread_feed_Feed_3`.*, `xf_user_User_4`.*, `xf_user_LastPoster_5`.*
FROM `xf_audfeeds_thread_feed_entry` FORCE INDEX (`thread_feed_id_post_date_node_id`)
INNER JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_audfeeds_thread_feed_entry`.`thread_id`)
LEFT JOIN `xf_poll` AS `xf_poll_Poll_2` FORCE INDEX(`content_type_content_id`) ON (`xf_poll_Poll_2`.`content_type` = 'thread' AND `xf_poll_Poll_2`.`content_id` = `xf_thread_Thread_1`.`thread_id`)
LEFT JOIN `xf_audfeeds_thread_feed` AS `xf_audfeeds_thread_feed_Feed_3` ON (`xf_audfeeds_thread_feed_Feed_3`.`thread_feed_id` = `xf_audfeeds_thread_feed_entry`.`thread_feed_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` FORCE INDEX(`PRIMARY`) ON (`xf_user_User_4`.`user_id` = `xf_thread_Thread_1`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` FORCE INDEX(`PRIMARY`) ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread_Thread_1`.`last_post_user_id`)
WHERE (`xf_audfeeds_thread_feed_entry`.`thread_feed_id` = 2) AND (`xf_audfeeds_thread_feed_entry`.`feed_entry_state` = 'visible') AND (`xf_audfeeds_thread_feed_entry`.`discussion_state` = 'visible') AND (`xf_audfeeds_thread_feed_entry`.`node_id` NOT IN (142)) AND (`xf_audfeeds_thread_feed_entry`.`sticky` = 0)
ORDER BY `xf_audfeeds_thread_feed_entry`.`post_date` DESC
LIMIT 25
Run Time: 0.000598
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_audfeeds_thread_feed_entry | ref | thread_feed_id_post_date_node_id | thread_feed_id_post_date_node_id | 4 | const | 3066 | Using where |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_audfeeds_thread_feed_entry.thread_id | 1 | |
SIMPLE | xf_poll_Poll_2 | eq_ref | content_type_content_id | content_type_content_id | 31 | const,davidderin_XenForo.xf_audfeeds_thread_feed_entry.thread_id | 1 | Using where |
SIMPLE | xf_audfeeds_thread_feed_Feed_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_thread_Thread_1.user_id | 1 | |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_thread_Thread_1.last_post_user_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/addons/Audentio/Feeds/Finder/ThreadFeedEntry.php at line 527
- Audentio\Feeds\Finder\ThreadFeedEntry->fetchThreads() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 197
- Audentio\Feeds\Feed\ThreadFeed->getFeedItems() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 132
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*
FROM `xf_forum`
INNER JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
WHERE (`xf_forum`.`node_id` IN (58, 49, 57, 58, 44, 49, 44, 59, 53, 44, 44, 58, 44, 67, 5, 49, 49, 51, 148, 67, 49, 44, 59, 58, 58))
Run Time: 0.000236
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 28 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_forum.node_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 271
- Audentio\Feeds\Feed\ThreadFeed->loadExtraRelations() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 199
- Audentio\Feeds\Feed\ThreadFeed->getFeedItems() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 132
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_permission_combination_PermissionCombination_5`.*, `xf_session_activity_Activity_6`.*, `xf_user_ThttAnonUser_7`.*
FROM `xf_post` FORCE INDEX (`PRIMARY`)
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_5` ON (`xf_permission_combination_PermissionCombination_5`.`permission_combination_id` = `xf_user_User_1`.`permission_combination_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_6` ON (`xf_session_activity_Activity_6`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_6`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
LEFT JOIN `xf_user` AS `xf_user_ThttAnonUser_7` ON (`xf_user_ThttAnonUser_7`.`user_id` = `xf_post`.`thtt_anon_user_id`)
WHERE (`xf_post`.`post_id` IN (9734, 9733, 9732, 9722, 9721, 9719, 9715, 9714, 9713, 9712, 9711, 9709, 9707, 9706, 9703, 9700, 9698, 9696, 9695, 9694, 9690, 9688, 9686, 9682, 9681))
Run Time: 0.000913
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 25 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_5 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_user_User_1.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_6 | eq_ref | PRIMARY | PRIMARY | 22 | davidderin_XenForo.xf_user_User_1.user_id,func | 1 | Using where |
SIMPLE | xf_user_ThttAnonUser_7 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_post.thtt_anon_user_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 277
- Audentio\Feeds\Feed\ThreadFeed->loadExtraRelations() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 199
- Audentio\Feeds\Feed\ThreadFeed->getFeedItems() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 132
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_permission_combination_PermissionCombination_5`.*, `xf_session_activity_Activity_6`.*, `xf_user_ThttAnonUser_7`.*
FROM `xf_post` FORCE INDEX (`PRIMARY`)
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_5` ON (`xf_permission_combination_PermissionCombination_5`.`permission_combination_id` = `xf_user_User_1`.`permission_combination_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_6` ON (`xf_session_activity_Activity_6`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_6`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
LEFT JOIN `xf_user` AS `xf_user_ThttAnonUser_7` ON (`xf_user_ThttAnonUser_7`.`user_id` = `xf_post`.`thtt_anon_user_id`)
WHERE (`xf_post`.`post_id` IN (9734, 9740, 9732, 9722, 9739, 9737, 9738, 9718, 9717, 9712, 9741, 9709, 9736, 9706, 9703, 9701, 9735, 9696, 9695, 9710, 9692, 9723, 9720, 9682, 9681))
Run Time: 0.000817
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 25 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_5 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_user_User_1.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_6 | eq_ref | PRIMARY | PRIMARY | 22 | davidderin_XenForo.xf_user_User_1.user_id,func | 1 | Using where |
SIMPLE | xf_user_ThttAnonUser_7 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_post.thtt_anon_user_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 282
- Audentio\Feeds\Feed\ThreadFeed->loadExtraRelations() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 199
- Audentio\Feeds\Feed\ThreadFeed->getFeedItems() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 132
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT COUNT(*) FROM (SELECT 1
FROM `xf_audfeeds_thread_feed_entry` FORCE INDEX (`thread_feed_id_post_date_node_id`)
INNER JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_audfeeds_thread_feed_entry`.`thread_id`)
WHERE (`xf_audfeeds_thread_feed_entry`.`thread_feed_id` = 2) AND (`xf_audfeeds_thread_feed_entry`.`feed_entry_state` = 'visible') AND (`xf_audfeeds_thread_feed_entry`.`discussion_state` = 'visible') AND (`xf_audfeeds_thread_feed_entry`.`node_id` NOT IN (142)) AND (`xf_audfeeds_thread_feed_entry`.`sticky` = 0)
LIMIT 25001) _
Run Time: 0.006465
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <derived2> | ALL | | | | | 3066 | |
DERIVED | xf_audfeeds_thread_feed_entry | ref | thread_feed_id_post_date_node_id | thread_feed_id_post_date_node_id | 4 | const | 3066 | Using index condition; Using where |
DERIVED | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_audfeeds_thread_feed_entry.thread_id | 1 | 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/addons/Audentio/Feeds/Finder/CachingTotalTrait.php at line 23
- Audentio\Feeds\Finder\ThreadFeedEntry->totalWithLimit() in src/addons/Audentio/Feeds/Finder/CachingTotalTrait.php at line 65
- Audentio\Feeds\Finder\ThreadFeedEntry->cachingTotal() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 228
- Audentio\Feeds\Feed\ThreadFeed->getFeedItems() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 132
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_th_monetize_sponsor_Sponsor_1`.*
FROM `xf_node`
LEFT JOIN `xf_th_monetize_sponsor` AS `xf_th_monetize_sponsor_Sponsor_1` ON (`xf_th_monetize_sponsor_Sponsor_1`.`th_sponsor_id` = `xf_node`.`th_sponsor_id`)
WHERE (`xf_node`.`display_in_list` = 1)
ORDER BY `xf_node`.`lft` ASC
Run Time: 0.000259
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 33 | Using where; Using filesort |
SIMPLE | xf_th_monetize_sponsor_Sponsor_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_node.th_sponsor_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Node.php at line 19
- XF\Repository\Node->getNodeList() in src/addons/NF/GiftUpgrades/XF/Repository/Node.php at line 29
- NF\GiftUpgrades\XF\Repository\Node->getNodeList() in src/addons/Audentio/Feeds/Repository/Feed.php at line 174
- Audentio\Feeds\Repository\Feed->threadTypeInUse() in src/addons/Audentio/Feeds/Repository/Feed.php at line 123
- Audentio\Feeds\Repository\Feed->getFeedActions() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 140
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_category`.*, `xf_node_Node_1`.*, `xf_th_monetize_sponsor_Sponsor_2`.*
FROM `xf_category`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`)
LEFT JOIN `xf_th_monetize_sponsor` AS `xf_th_monetize_sponsor_Sponsor_2` ON (`xf_th_monetize_sponsor_Sponsor_2`.`th_sponsor_id` = `xf_node_Node_1`.`th_sponsor_id`)
WHERE (`xf_category`.`node_id` IN (3, 66, 35, 150, 151))
Run Time: 0.000187
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | | 5 | Using where; Using index |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_category.node_id | 1 | |
SIMPLE | xf_th_monetize_sponsor_Sponsor_2 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_node_Node_1.th_sponsor_id | 1 | Using where |
- 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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 20
- XF\Repository\Node->getNodeList() in src/addons/NF/GiftUpgrades/XF/Repository/Node.php at line 29
- NF\GiftUpgrades\XF\Repository\Node->getNodeList() in src/addons/Audentio/Feeds/Repository/Feed.php at line 174
- Audentio\Feeds\Repository\Feed->threadTypeInUse() in src/addons/Audentio/Feeds/Repository/Feed.php at line 123
- Audentio\Feeds\Repository\Feed->getFeedActions() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 140
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*, `xf_th_monetize_sponsor_Sponsor_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_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
LEFT JOIN `xf_th_monetize_sponsor` AS `xf_th_monetize_sponsor_Sponsor_4` ON (`xf_th_monetize_sponsor_Sponsor_4`.`th_sponsor_id` = `xf_node_Node_1`.`th_sponsor_id`)
WHERE (`xf_forum`.`node_id` IN (4, 5, 6, 67, 77, 70, 144, 149, 142, 148, 145, 146, 147, 43, 44, 49, 50, 51, 52, 53, 55, 54, 56, 57, 58, 60, 59, 61))
Run Time: 0.000583
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 28 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_forum.last_thread_id | 1 | |
SIMPLE | xf_th_monetize_sponsor_Sponsor_4 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_node_Node_1.th_sponsor_id | 1 | Using where |
- 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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 20
- XF\Repository\Node->getNodeList() in src/addons/NF/GiftUpgrades/XF/Repository/Node.php at line 29
- NF\GiftUpgrades\XF\Repository\Node->getNodeList() in src/addons/Audentio/Feeds/Repository/Feed.php at line 174
- Audentio\Feeds\Repository\Feed->threadTypeInUse() in src/addons/Audentio/Feeds/Repository/Feed.php at line 123
- Audentio\Feeds\Repository\Feed->getFeedActions() in src/addons/Audentio/Feeds/Pub/Controller/Feed.php at line 140
- Audentio\Feeds\Pub\Controller\Feed->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, 6?
Run Time: 0.000089
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | 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/Repository/SessionActivity.php at line 130
- 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 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- 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 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT IGNORE INTO xf_session_activity (
ip,
controller_name,
controller_action,
view_state,
params,
view_date,
robot_key,
user_id,
unique_key
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: 6?, Audentio\Feeds\Pub\Controller\Feed, Index, valid, url_portion=threads, 1715588859, , 0, 6?
Run Time: 0.000039
- 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 218
- 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 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- 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 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('ozzmodz_vb_badge')
Run Time: 0.000106
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 136
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 228
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1931
- XF\App->XF\{closure}() in src/XF/Container.php at line 31
- XF\Container->offsetGet() in src/XF/App.php at line 3461
- XF\App->container() in src/addons/OzzModz/VerificationBadges/XF/Entity/User.php at line 31
- OzzModz\VerificationBadges\XF\Entity\User->getOzzModzVerificationBadges() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s4/public/ozzmodz_vb_badge_username_badges.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/OzzModz/VerificationBadges/XF/Template/Templater.php at line 25
- OzzModz\VerificationBadges\XF\Template\Templater->fnUsernameLink() in src/XF/Template/Templater.php at line 1132
- XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s4/public/thread_list_macros.php at line 583
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l1/s4/public/thread_list_macros.php at line 639
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s4/public/news_feed_item_thread_audfeeds_condensed_insert.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/XF/NewsFeed/AbstractHandler.php at line 104
- XF\NewsFeed\AbstractHandler->render() in src/XF/Entity/NewsFeed.php at line 79
- XF\Entity\NewsFeed->render() in src/addons/Audentio/Feeds/XF/Entity/NewsFeed.php at line 24
- Audentio\Feeds\XF\Entity\NewsFeed->render() in src/XF/Template/Templater.php at line 1195
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s4/public/audfeeds_feed_macros.php at line 130
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s4/public/audfeeds_feed_view.php at line 429
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s4/public/audfeeds_feed_view.php at line 600
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s4/public/audfeeds_feed_view.php at line 799
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1646
- 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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('adst_tours')
Run Time: 0.000124
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 136
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 228
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1931
- XF\App->XF\{closure}() in src/XF/Container.php at line 31
- XF\Container->offsetGet() in src/XF/App.php at line 3461
- XF\App->container() in src/addons/Audentio/SiteTour/Template/TemplaterSetup.php at line 63
- Audentio\SiteTour\Template\TemplaterSetup->getTourData() in src/addons/Audentio/SiteTour/Template/TemplaterSetup.php at line 39
- Audentio\SiteTour\Template\TemplaterSetup->fnADSTTourData() in src/XF/Template/Templater.php at line 1132
- XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s4/public/adst_js_init.php at line 12
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1684
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s4/public/helper_js_global.php at line 121
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s4/public/PAGE_CONTAINER.php at line 3644
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
bytes_sent | 28946 |
bytes_received | 1791886 |
packets_sent | 298 |
packets_received | 4223 |
protocol_overhead_in | 16892 |
protocol_overhead_out | 1192 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 945 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 273 |
bytes_received_prepare_response_packet | 325873 |
bytes_received_change_user_packet | 1463667 |
packets_sent_command | 148 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 105 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 51 |
packets_received_prepare_response | 3559 |
packets_received_change_user | 457 |
result_set_queries | 48 |
non_result_set_queries | 3 |
no_index_used | 11 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 48 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 48 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 409 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 409 |
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 | 0 |
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 | 47 |
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 | 7335 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 4296 |
proto_binary_fetched_int24 | 992 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 10525 |
proto_binary_fetched_decimal | 68 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 1093 |
proto_binary_fetched_date | 0 |
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 | 4567 |
proto_binary_fetched_blob | 2973 |
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 | 49 |
com_stmt_execute | 49 |
com_stmt_send_long_data | 0 |
com_stmt_close | 48 |
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 | 1448726 |