SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.000822
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 36 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/App.php at line 1753
- XF\App->preLoadData() in src/XF/App.php at line 1741
- XF\App->setup() in src/XF/Pub/App.php at line 89
- XF\Pub\App->setup() in src/XF.php at line 363
- XF::setupApp() in src/XF.php at line 386
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000075
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- 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 926
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 241
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 123
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 320
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `ewr_carta_pages`.*
FROM `ewr_carta_pages`
WHERE (`ewr_carta_pages`.`page_slug` = 'robert-ferguson')
LIMIT 1
Run Time: 0.000110
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ewr_carta_pages | const | page_slug | page_slug | 302 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/EWR/Carta/Pub/Controller/Page.php at line 381
- EWR\Carta\Pub\Controller\Page->assertPageExists() in src/addons/EWR/Carta/Pub/Controller/Page.php at line 19
- EWR\Carta\Pub\Controller\Page->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT 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` = 'ewr_carta_page') AND (`xf_attachment`.`content_id` = 33)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | hearth_xenlive.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/EWR/Carta/Pub/Controller/Page.php at line 45
- EWR\Carta\Pub\Controller\Page->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `ewr_carta_pages`.*
FROM `ewr_carta_pages`
WHERE (`ewr_carta_pages`.`page_index` > 0)
ORDER BY `ewr_carta_pages`.`page_index` ASC
Run Time: 0.000131
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ewr_carta_pages | range | page_index | page_index | 4 | | 12 | Using index condition |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/EWR/Carta/Pub/Controller/Page.php at line 59
- EWR\Carta\Pub\Controller\Page->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
UPDATE `ewr_carta_pages` SET `page_views` = ? WHERE `page_id` = 33
Params: 2400
Run Time: 0.000120
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 326
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1288
- XF\Mvc\Entity\Entity->fastUpdate() in src/addons/EWR/Carta/Pub/Controller/Page.php at line 62
- EWR\Carta\Pub\Controller\Page->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , EWR\Carta\Pub\Controller\Page, Index, valid, page_slug=robert-ferguson, 1575876928,
Run Time: 0.000042
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 81
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 284
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 343
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`))
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC
Run Time: 0.000429
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status_display_order | 77 | const | 23 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | hearth_xenlive.xf_siropu_ads_manager_ad.package_id | 1 | |
SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 441
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 306
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 297
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 38
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2648
- XF\App->fire() in src/XF/App.php at line 1916
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1794
- XF\App->preRender() in src/XF/Pub/App.php at line 432
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 355
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `ewr_carta_pages`.*
FROM `ewr_carta_pages`
WHERE (`ewr_carta_pages`.`page_family` = 20)
ORDER BY `ewr_carta_pages`.`page_left` ASC
Run Time: 0.000443
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ewr_carta_pages | ALL | | | | | 253 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/EWR/Carta/Entity/Page.php at line 192
- EWR\Carta\Entity\Page->getFamilytree() in src/XF/Mvc/Entity/Entity.php at line 148
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s15/public/EWRcarta_page_view.php at line 50
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- 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 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `ewr_carta_cache`.*
FROM `ewr_carta_cache`
WHERE (`ewr_carta_cache`.`page_id` = 33)
LIMIT 1
Run Time: 0.000118
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ewr_carta_cache | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/EWR/Carta/Entity/Page.php at line 132
- EWR\Carta\Entity\Page->getParsed() in src/XF/Mvc/Entity/Entity.php at line 148
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s15/public/EWRcarta_page_macros.php at line 39
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s15/public/EWRcarta_page_view.php at line 162
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- 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 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_th_xlink_platform_link`.*
FROM `xf_th_xlink_platform_link`
WHERE (`xf_th_xlink_platform_link`.`platform_id` IN (4))
Run Time: 0.000123
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_th_xlink_platform_link | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/addons/ThemeHouse/XLink/Navigation/RemoteNavigation.php at line 122
- ThemeHouse\XLink\Navigation\RemoteNavigation::loadPlatformLinks() in src/addons/ThemeHouse/XLink/Navigation/RemoteNavigation.php at line 79
- ThemeHouse\XLink\Navigation\RemoteNavigation::displayPlatformExtended() in internal_data/code_cache/navigation_cache.php at line 112
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6648
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 557
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 510
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (45))
Run Time: 0.000158
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 193
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 115
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 662
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6648
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 557
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 510
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
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 (45))
Run Time: 0.000141
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 129
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 227
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 115
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 662
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6648
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 557
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 510
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_mg_category`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_mg_category`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'xfmg_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_mg_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
ORDER BY `xf_mg_category`.`lft` ASC
Run Time: 0.000188
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_category | ALL | | | | | 10 | Using filesort |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,hearth_xenlive.xf_mg_category.category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/AbstractCategoryTree.php at line 67
- XF\Repository\AbstractCategoryTree->getViewableCategories() in src/addons/XFMG/Widget/MediaSlider.php at line 58
- XFMG\Widget\MediaSlider->render() in internal_data/code_cache/widgets/_24_media.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
- XF\Template\Templater->widgetPosition() in src/addons/ThemeHouse/UIX/Util/UIX.php at line 70
- ThemeHouse\UIX\Util\UIX->getFooterWidgets() in src/addons/ThemeHouse/UIX/Listener/AppPubRenderPage.php at line 31
- ThemeHouse\UIX\Listener\AppPubRenderPage::appPubRenderPage()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2648
- XF\App->fire() in src/XF/Pub/App.php at line 542
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.*
FROM `xf_mg_media_item`
LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`)
LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`)
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`)
WHERE (`xf_mg_media_item`.`category_id` IN (2, 12, 3, 4, 5, 6, 7, 8, 9, 11)) AND (`xf_mg_media_item`.`media_state` = 'visible')
ORDER BY `xf_mg_media_item`.`media_date` DESC, `xf_mg_media_item`.`media_id` DESC
LIMIT 120
Run Time: 0.002227
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | index | category_id_media_date | media_date | 4 | | 204 | Using where |
SIMPLE | xf_mg_album_Album_1 | eq_ref | PRIMARY | PRIMARY | 4 | hearth_xenlive.xf_mg_media_item.album_id | 1 | |
SIMPLE | xf_mg_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | hearth_xenlive.xf_mg_media_item.category_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | hearth_xenlive.xf_mg_media_item.user_id | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,hearth_xenlive.xf_mg_media_item.media_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | hearth_xenlive.xf_attachment_Attachment_4.data_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFMG/Widget/MediaSlider.php at line 96
- XFMG\Widget\MediaSlider->render() in internal_data/code_cache/widgets/_24_media.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6672
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
- XF\Template\Templater->widgetPosition() in src/addons/ThemeHouse/UIX/Util/UIX.php at line 70
- ThemeHouse\UIX\Util\UIX->getFooterWidgets() in src/addons/ThemeHouse/UIX/Listener/AppPubRenderPage.php at line 31
- ThemeHouse\UIX\Listener\AppPubRenderPage::appPubRenderPage()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2648
- XF\App->fire() in src/XF/Pub/App.php at line 542
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('xfmg_latest_media')
Params: 1
Run Time: 0.000105
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 351
- XF\Language->loadPhrases() in src/XF/Language.php at line 249
- XF\Language->getPhraseText() in src/XF/Language.php at line 167
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Phrase.php at line 59
- XF\Phrase->__toString()
- strval() in src/XF.php at line 927
- XF::escapeString() in src/XF/Template/Templater.php at line 1009
- XF\Template\Templater->escape() in internal_data/code_cache/templates/l1/s15/public/xfmg_widget_media_slider.php at line 31
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1634
- XF\Template\Templater->widgetPosition() in src/addons/ThemeHouse/UIX/Util/UIX.php at line 70
- ThemeHouse\UIX\Util\UIX->getFooterWidgets() in src/addons/ThemeHouse/UIX/Listener/AppPubRenderPage.php at line 31
- ThemeHouse\UIX\Listener\AppPubRenderPage::appPubRenderPage()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2648
- XF\App->fire() in src/XF/Pub/App.php at line 542
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_addon`.*, `xf_th_installupgrade_product_THIAUProduct_1`.*
FROM `xf_addon`
LEFT JOIN `xf_th_installupgrade_product` AS `xf_th_installupgrade_product_THIAUProduct_1` ON (`xf_th_installupgrade_product_THIAUProduct_1`.`product_type` = 'addOn' AND `xf_th_installupgrade_product_THIAUProduct_1`.`content_id` = `xf_addon`.`addon_id`)
WHERE (`xf_addon`.`addon_id` = 'Tapatalk')
LIMIT 1
Run Time: 0.000138
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 52 | const | 1 | |
SIMPLE | xf_th_installupgrade_product_THIAUProduct_1 | ALL | | | | | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/Tapatalk/Listener/Hook.php at line 22
- Tapatalk\Listener\Hook::templateHook()
- call_user_func_array() in src/XF/Extension.php at line 35
- XF\Extension->fire() in src/XF/App.php at line 2648
- XF\App->fire() in src/XF/Template/Templater.php at line 1297
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 544
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
bytes_sent | 13951 |
bytes_received | 1148301 |
packets_sent | 196 |
packets_received | 1625 |
protocol_overhead_in | 6500 |
protocol_overhead_out | 784 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 594 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 235 |
bytes_received_prepare_response_packet | 88808 |
bytes_received_change_user_packet | 1057898 |
packets_sent_command | 97 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 66 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 34 |
packets_received_prepare_response | 1116 |
packets_received_change_user | 375 |
result_set_queries | 30 |
non_result_set_queries | 4 |
no_index_used | 3 |
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 | 31 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 345 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 345 |
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 | 345 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estndup_count | 0 |
mem_strdup_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 | 5224 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 1154 |
proto_binary_fetched_int24 | 740 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 9047 |
proto_binary_fetched_decimal | 54 |
proto_binary_fetched_float | 83 |
proto_binary_fetched_double | 240 |
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 | 3430 |
proto_binary_fetched_blob | 2183 |
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 | 1046766 |