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.000551
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.000159
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.000128
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.000181
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.000114
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.000140
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.000186
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.000072
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.000083
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.000307
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.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/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.000676
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` = 3) 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` >= 1715141248)
ORDER BY `xf_audfeeds_thread_feed_entry`.`post_date` DESC
LIMIT 25
Run Time: 0.000553
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_audfeeds_thread_feed_entry | ref|filter | 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 | thread_feed_id_post_date_node_id|sticky_unstick_on | 4|5 | const | 131 (0%) | Using where; Using rowid filter |
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` = 3) 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.000722
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 | 131 | 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 (67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67, 67))
Run Time: 0.000259
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | range | PRIMARY | PRIMARY | 4 | | 1 | 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 (9578, 9570, 9556, 9423, 9330, 9320, 9282, 9265, 9254, 9249, 9201, 9197, 9182, 9111, 9041, 9013, 9010, 9006, 8980, 8969, 8958, 8876, 8848, 8827, 8768))
Run Time: 0.000875
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 (9578, 9570, 9559, 9423, 9334, 9408, 9341, 9309, 9409, 9410, 9215, 9306, 9303, 9411, 9412, 9018, 9011, 9006, 8981, 8992, 8958, 8898, 8917, 8828, 8779))
Run Time: 0.000852
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 `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
INNER JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE ((`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9578) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9570) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9556) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9423) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9330) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9320) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9282) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9265) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9254) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9249) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9201) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9197) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9182) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9111) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9041) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9013) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9010) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 9006) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 8980) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 8969) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 8958) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 8876) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 8848) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 8827) OR (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` = 8768))
Run Time: 0.000446
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | range | content_type_id_date,data_id | content_type_id_date | 31 | | 25 | Using index condition |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_attachment.data_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 572
- Audentio\Feeds\Feed\AbstractHandler->wrapItems() in src/addons/Audentio/Feeds/Feed/ThreadFeed.php at line 218
- 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` = 3) 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.000547
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <derived2> | ALL | | | | | 131 | |
DERIVED | xf_audfeeds_thread_feed_entry | ref | thread_feed_id_post_date_node_id | thread_feed_id_post_date_node_id | 4 | const | 131 | 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.000367
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.000211
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.000612
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, �{x
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: �{x, Audentio\Feeds\Pub\Controller\Feed, Index, valid, feed_id=11, 1715141248, , 0, �{x
Run Time: 0.000050
- 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 ('adst_tours')
Run Time: 0.000111
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 103
- 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 | 33455 |
bytes_received | 1696714 |
packets_sent | 298 |
packets_received | 4143 |
protocol_overhead_in | 16572 |
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 | 315439 |
bytes_received_change_user_packet | 1378929 |
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 | 3483 |
packets_received_change_user | 453 |
result_set_queries | 48 |
non_result_set_queries | 3 |
no_index_used | 10 |
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 | 405 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 405 |
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 | 6688 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 3968 |
proto_binary_fetched_int24 | 962 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 10063 |
proto_binary_fetched_decimal | 74 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 1046 |
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 | 4478 |
proto_binary_fetched_blob | 2882 |
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 | 1364541 |