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.003778
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`.`page_name` = 'terms') AND (`xf_help_page`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_help_page`.`addon_id` = ''))
LIMIT 1
Run Time: 0.000326
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_help_page | const | page_name | page_name | 202 | const | 1 | |
SIMPLE | xf_addon_AddOn_1 | const | PRIMARY | PRIMARY | 52 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1417
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/HelpController.php at line 45
- XF\Pub\Controller\HelpController->handleHelpPage() in src/XF/Pub/Controller/HelpController.php at line 25
- 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 `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.000305
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 72
- XF\Pub\Controller\HelpController->addWrapperParams() in src/XF/Pub/Controller/HelpController.php at line 65
- XF\Pub\Controller\HelpController->handleHelpPage() in src/XF/Pub/Controller/HelpController.php at line 25
- 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.000153
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
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.000173
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.000121
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 title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('ozzmodz_adult_potentially_inappropriate_content')
Params: 1
Run Time: 0.000145
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 144
- XF\Template\Templater->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/templates/l1/s276/public/metadata_macros.php:138}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s276/public/metadata_macros.php at line 41
- XF\Template\Templater->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/templates/l1/s276/public/metadata_macros.php:15}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s276/public/help_page.php at line 10
- XF\Template\Templater->{closure:/var/www/vhosts/cities-mods.com/httpdocs/internal_data/code_cache/templates/l1/s276/public/help_page.php:4}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
- 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.000355
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.000209
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.000123
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 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.000173
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.000121
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 `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.000256
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.000291
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.000151
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.000213
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 | 10980 |
bytes_received | 1961260 |
packets_sent | 196 |
packets_received | 1058 |
protocol_overhead_in | 4232 |
protocol_overhead_out | 784 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 666 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 182 |
bytes_received_prepare_response_packet | 40108 |
bytes_received_change_user_packet | 1919528 |
packets_sent_command | 97 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 74 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 34 |
packets_received_prepare_response | 644 |
packets_received_change_user | 272 |
result_set_queries | 32 |
non_result_set_queries | 2 |
no_index_used | 4 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 32 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 31 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 240 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 240 |
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 | 31 |
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 | 103 |
proto_binary_fetched_int24 | 31 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 206 |
proto_binary_fetched_decimal | 23 |
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 | 490 |
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 | 32 |
com_stmt_execute | 32 |
com_stmt_send_long_data | 0 |
com_stmt_close | 31 |
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 | 1916908 |