SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'iconSprite', '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.001678
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 40 | 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 169
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 102
- XF\DataRegistry->get() in src/XF/App.php at line 2289
- XF\App->preLoadData() in src/XF/App.php at line 2274
- XF\App->setup() in src/XF/Pub/App.php at line 116
- XF\Pub\App->setup() in src/XF.php at line 779
- XF::setupApp() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT `xf_help_page`.*
FROM `xf_help_page`
LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_help_page`.`addon_id`)
WHERE (`xf_help_page`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_help_page`.`addon_id` = ''))
ORDER BY `xf_help_page`.`display_order` ASC
Run Time: 0.000249
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_help_page | ALL | | | | | 15 | Using where; Using filesort |
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | citiesmods_mods.xf_help_page.addon_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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/HelpController.php at line 93
- XF\Pub\Controller\HelpController->getActiveHelpPages() in src/XF/Pub/Controller/HelpController.php at line 29
- XF\Pub\Controller\HelpController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, �Iئ
Run Time: 0.000137
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/addons/DigitalPoint/Cloudflare/XF/Repository/SessionActivity.php at line 43
- DigitalPoint\Cloudflare\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 99
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 62
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 372
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?,
ip_geo = ?
WHERE user_id = ? AND unique_key = ?
Params: �Iئ, XF\Pub\Controller\HelpController, Index, valid, , 1752043384, anthropic, [], 0, �Iئ
Run Time: 0.000607
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/addons/DigitalPoint/Cloudflare/XF/Repository/SessionActivity.php at line 163
- DigitalPoint\Cloudflare\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 99
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 62
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 372
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT `xf_fc_user_devices`.*
FROM `xf_fc_user_devices`
WHERE (`xf_fc_user_devices`.`user_id` = 0) AND (`xf_fc_user_devices`.`browser_token` = 0)
LIMIT 1
Run Time: 0.000240
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_fc_user_devices | ref | user_id | user_id | 4 | const | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1417
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 65
- XF\Mvc\Entity\FinderCollection->offsetGet() in src/XF/Mvc/Entity/FinderCollection.php at line 115
- XF\Mvc\Entity\FinderCollection->offsetExists() in src/addons/nick97/recentlyuseddevices/XF/Entity/User.php at line 29
- nick97\recentlyuseddevices\XF\Entity\User->getCurrentVisitorLoggedDevice() in src/XF/Mvc/Entity/Entity.php at line 182
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 134
- XF\Mvc\Entity\Entity->__get() in src/addons/nick97/recentlyuseddevices/Listener.php at line 128
- nick97\recentlyuseddevices\Listener::controllerPostDispatch() in src/XF/Extension.php at line 54
- XF\Extension->fire() in src/XF/App.php at line 3368
- XF\App->fire() in src/XF/Mvc/Controller.php at line 374
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('mjstStatusStyles')
Run Time: 0.000110
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 169
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 102
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 271
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 2178
- XF\App->{closure:XF\App::fromRegistry():2176}() in src/XF/Container.php at line 33
- XF\Container->offsetGet() in src/addons/MJ/SupportTicket/Listener.php at line 73
- MJ\SupportTicket\Listener::templaterSetup() in src/XF/Extension.php at line 86
- XF\Extension->fire() in src/XF/App.php at line 3368
- XF\App->fire() in src/XF/App.php at line 2238
- XF\App->setupTemplaterObject() in src/XF/App.php at line 1590
- XF\App->{closure:XF\App::initialize():1588}() in src/XF/Container.php at line 33
- XF\Container->offsetGet() in src/XF/App.php at line 3805
- XF\App->templater() in src/XF/Pub/App.php at line 493
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 407
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT `xf_node`.*, `xf_snog_tv_forum_TVForum_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_node`
LEFT JOIN `xf_snog_tv_forum` AS `xf_snog_tv_forum_TVForum_1` ON (`xf_snog_tv_forum_TVForum_1`.`node_id` = `xf_node`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (242, 333))
Run Time: 0.000351
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | range | PRIMARY,node_id_stmlt_language_id | node_id_stmlt_language_id | 4 | | 2 | Using index condition |
SIMPLE | xf_snog_tv_forum_TVForum_1 | eq_ref | PRIMARY | PRIMARY | 4 | citiesmods_mods.xf_node.node_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,citiesmods_mods.xf_node.node_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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 222
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 140
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 65
- XF\Pub\App->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/navigation_cache.php:3}() in src/XF/Template/Templater.php at line 8150
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 634
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 585
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2573
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT `xf_page`.*, `xf_node_Node_1`.*
FROM `xf_page`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_page`.`node_id`)
WHERE (`xf_page`.`node_id` IN (242, 333))
Run Time: 0.000170
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_page | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY,node_id_stmlt_language_id | PRIMARY | 4 | citiesmods_mods.xf_page.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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/NodeRepository.php at line 150
- XF\Repository\NodeRepository->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 260
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 140
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 65
- XF\Pub\App->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/navigation_cache.php:3}() in src/XF/Template/Templater.php at line 8150
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 634
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 585
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2573
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000125
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 36
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1271
- XF\Entity\User->hasPermission() in src/addons/XFMG/XF/Entity/User.php at line 13
- XFMG\XF\Entity\User->canViewMedia() in src/XF/Template/Templater.php at line 1282
- XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 337
- XF\Pub\App->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/navigation_cache.php:3}() in src/XF/Template/Templater.php at line 8150
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 634
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 585
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2573
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT `xf_connected_account_provider`.*
FROM `xf_connected_account_provider`
ORDER BY `xf_connected_account_provider`.`display_order` ASC
Run Time: 0.000138
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_connected_account_provider | ALL | | | | | 31 | 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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/ConnectedAccountRepository.php at line 36
- XF\Repository\ConnectedAccountRepository->getUsableProviders() in src/addons/OzzModz/NoticeConnectedAccountDisplay/XF/NoticeList.php at line 31
- OzzModz\NoticeConnectedAccountDisplay\XF\NoticeList->addNotice() in src/XF/NoticeList.php at line 111
- XF\NoticeList->addConditionalNotice() in src/XF/Pub/App.php at line 668
- XF\Pub\App->getNoticeList() in src/XF/Pub/App.php at line 603
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2573
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT `xf_xfa_rmmpc_cart`.*
FROM `xf_xfa_rmmpc_cart`
WHERE (`xf_xfa_rmmpc_cart`.`user_id` = 0)
LIMIT 1
Run Time: 0.000118
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1417
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 404
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 419
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 211
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 134
- XF\Mvc\Entity\Entity->__get() in src/addons/XFA/RMMarketplaceCart/Listener.php at line 51
- XFA\RMMarketplaceCart\Listener::appPubRenderPage() in src/XF/Extension.php at line 86
- XF\Extension->fire() in src/XF/App.php at line 3368
- XF\App->fire() in src/XF/Pub/App.php at line 619
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2573
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('ozzmodz_adult_potentially_inappropriate_content')
Params: 1
Run Time: 0.000112
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 395
- XF\Language->loadPhrases() in src/XF/Language.php at line 287
- XF\Language->getPhraseText() in src/XF/Language.php at line 144
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 89
- XF\Phrase->render() in src/XF/Phrase.php at line 99
- XF\Phrase->__toString()
- preg_replace() in src/addons/OzzModz/AdultContent/XF/Str/Formatter.php at line 24
- OzzModz\AdultContent\XF\Str\Formatter->snippetString() in src/XF/Template/Templater.php at line 4434
- XF\Template\Templater->fnSnippet() in src/XF/Template/Templater.php at line 1219
- XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s276/public/metadata_macros.php at line 121
- XF\Template\Templater->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/templates/l1/s276/public/metadata_macros.php:114}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s276/public/PAGE_CONTAINER.php at line 2907
- XF\Template\Templater->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/templates/l1/s276/public/PAGE_CONTAINER.php:860}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 621
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2573
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
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.000203
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_audfeeds_feed | ALL | active | | | | 14 | 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 1445
- 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/Listener/Pub/TemplaterTemplatePreRender.php at line 26
- Audentio\Feeds\Listener\Pub\TemplaterTemplatePreRender::audfeedsTabBar() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 3368
- XF\App->fire() in src/XF/Template/Templater.php at line 1758
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1873
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s276/public/PAGE_CONTAINER.php at line 3492
- XF\Template\Templater->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/templates/l1/s276/public/PAGE_CONTAINER.php:860}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 621
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2573
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
Params: 1, node
Run Time: 0.000241
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 180 | 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 109
- 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 407
- XF\Mvc\Entity\AbstractCollection->{closure:XF\Mvc\Entity\AbstractCollection::filterViewable():404}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 248
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 404
- 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/Listener/Pub/TemplaterTemplatePreRender.php at line 26
- Audentio\Feeds\Listener\Pub\TemplaterTemplatePreRender::audfeedsTabBar() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 3368
- XF\App->fire() in src/XF/Template/Templater.php at line 1758
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1873
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s276/public/PAGE_CONTAINER.php at line 3492
- XF\Template\Templater->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/templates/l1/s276/public/PAGE_CONTAINER.php:860}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 621
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2573
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
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.000148
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 5 | 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 109
- 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 407
- XF\Mvc\Entity\AbstractCollection->{closure:XF\Mvc\Entity\AbstractCollection::filterViewable():404}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 248
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 404
- 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/Listener/Pub/TemplaterTemplatePreRender.php at line 26
- Audentio\Feeds\Listener\Pub\TemplaterTemplatePreRender::audfeedsTabBar() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 3368
- XF\App->fire() in src/XF/Template/Templater.php at line 1758
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1873
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s276/public/PAGE_CONTAINER.php at line 3492
- XF\Template\Templater->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/templates/l1/s276/public/PAGE_CONTAINER.php:860}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 621
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2573
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
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.000181
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_audfeeds_thread_feed | ALL | | | | | 5 | |
SIMPLE | xf_audfeeds_thread_feed_watch_Watch_1 | eq_ref | PRIMARY | PRIMARY | 8 | const,citiesmods_mods.xf_audfeeds_thread_feed.thread_feed_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,citiesmods_mods.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 1445
- 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 407
- XF\Mvc\Entity\AbstractCollection->{closure:XF\Mvc\Entity\AbstractCollection::filterViewable():404}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 248
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 404
- 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/Listener/Pub/TemplaterTemplatePreRender.php at line 26
- Audentio\Feeds\Listener\Pub\TemplaterTemplatePreRender::audfeedsTabBar() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 3368
- XF\App->fire() in src/XF/Template/Templater.php at line 1758
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1873
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s276/public/PAGE_CONTAINER.php at line 3492
- XF\Template\Templater->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/templates/l1/s276/public/PAGE_CONTAINER.php:860}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 621
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2573
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
bytes_sent | 10634 |
bytes_received | 1960194 |
packets_sent | 190 |
packets_received | 1022 |
protocol_overhead_in | 4088 |
protocol_overhead_out | 760 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 639 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 224 |
bytes_received_prepare_response_packet | 38364 |
bytes_received_change_user_packet | 1920217 |
packets_sent_command | 94 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 71 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 33 |
packets_received_prepare_response | 618 |
packets_received_change_user | 267 |
result_set_queries | 30 |
non_result_set_queries | 3 |
no_index_used | 4 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 30 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 30 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 237 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 237 |
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 | 29 |
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 | 104 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 101 |
proto_binary_fetched_int24 | 31 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 205 |
proto_binary_fetched_decimal | 21 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 0 |
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 | 467 |
proto_binary_fetched_blob | 221 |
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 | 31 |
com_stmt_execute | 31 |
com_stmt_send_long_data | 0 |
com_stmt_close | 30 |
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 | 1917649 |