Page Time: 0.0872s

Memory: 5.0158 MB (Peak: 5.1933 MB)

Queries (14, time: 0.0289s, 33.1%)

  1. SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000608
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 36
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1271
    6. XF\Entity\User->hasPermission() in src/addons/OzzModz/DebugDevelopment/Listener.php at line 15
    7. OzzModz\DebugDevelopment\Listener::appSetup() in src/XF/Extension.php at line 86
    8. XF\Extension->fire() in src/XF/App.php at line 3368
    9. XF\App->fire() in src/XF/Repository/UserRepository.php at line 38
    10. XF\Repository\UserRepository->getVisitor() in src/XF/App.php at line 2332
    11. XF\App->getVisitorFromSession() in src/XF/Pub/App.php at line 200
    12. XF\Pub\App->start() in src/XF/App.php at line 2822
    13. XF\App->run() in src/XF.php at line 806
    14. XF::runApp() in index.php at line 23
  2. SELECT `xf_xa_pkm_sport`.*
FROM `xf_xa_pkm_sport`


ORDER BY `xf_xa_pkm_sport`.`display_order` ASC, `xf_xa_pkm_sport`.`title` ASC
    Run Time: 0.000102
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_pkm_sportALL    1Using filesort

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1445
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/Pickem/ControllerPlugin/PoolList.php at line 19
    4. XenAddons\Pickem\ControllerPlugin\PoolList->getPoolListData() in src/addons/XenAddons/Pickem/Pub/Controller/Pickem.php at line 35
    5. XenAddons\Pickem\Pub\Controller\Pickem->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
    6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
    7. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
    8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
    9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    10. XF\App->run() in src/XF.php at line 806
    11. XF::runApp() in index.php at line 23
  3. SELECT `xf_xa_pkm_season`.*, `xf_xa_pkm_sport_Sport_1`.*
FROM `xf_xa_pkm_season`
LEFT JOIN `xf_xa_pkm_sport` AS `xf_xa_pkm_sport_Sport_1` ON (`xf_xa_pkm_sport_Sport_1`.`sport_id` = `xf_xa_pkm_season`.`sport_id`)

ORDER BY `xf_xa_pkm_season`.`title` DESC
    Run Time: 0.000059
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_pkm_seasonALL    1Using filesort
    SIMPLExf_xa_pkm_sport_Sport_1eq_refPRIMARYPRIMARY4nzwarriorscom.xf_xa_pkm_season.sport_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1445
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/Pickem/ControllerPlugin/PoolList.php at line 24
    4. XenAddons\Pickem\ControllerPlugin\PoolList->getPoolListData() in src/addons/XenAddons/Pickem/Pub/Controller/Pickem.php at line 35
    5. XenAddons\Pickem\Pub\Controller\Pickem->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
    6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
    7. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
    8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
    9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    10. XF\App->run() in src/XF.php at line 806
    11. XF::runApp() in index.php at line 23
  4. SELECT COUNT(*)
FROM `xf_xa_pkm_pool`
INNER JOIN `xf_xa_pkm_season` AS `xf_xa_pkm_season_Season_1` ON (`xf_xa_pkm_season_Season_1`.`season_id` = `xf_xa_pkm_pool`.`season_id`)
INNER JOIN `xf_xa_pkm_sport` AS `xf_xa_pkm_sport_Sport_2` ON (`xf_xa_pkm_sport_Sport_2`.`sport_id` = `xf_xa_pkm_season_Season_1`.`sport_id`)
WHERE ((`xf_xa_pkm_pool`.`pool_status` IN ('open', 'closed', 'final'))) AND (`xf_xa_pkm_pool`.`pool_type` = 'survivor') AND (`xf_xa_pkm_pool`.`pool_status` = 'open')
    Run Time: 0.000714
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_pkm_season_Season_1indexPRIMARY,sport_idsport_id4 1Using index
    SIMPLExf_xa_pkm_sport_Sport_2eq_refPRIMARYPRIMARY4nzwarriorscom.xf_xa_pkm_season_Season_1.sport_id1Using index
    SIMPLExf_xa_pkm_poolref|filterseason_id,pool_type,pool_statusseason_id|pool_status4|1nzwarriorscom.xf_xa_pkm_season_Season_1.season_id1 (40%)Using where; Using rowid filter

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1407
    4. XF\Mvc\Entity\Finder->total() in src/addons/XenAddons/Pickem/ControllerPlugin/PoolList.php at line 59
    5. XenAddons\Pickem\ControllerPlugin\PoolList->getPoolListData() in src/addons/XenAddons/Pickem/Pub/Controller/Pickem.php at line 35
    6. XenAddons\Pickem\Pub\Controller\Pickem->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    11. XF\App->run() in src/XF.php at line 806
    12. XF::runApp() in index.php at line 23
  5. SELECT `xf_xa_pkm_pool`.*, `xf_xa_pkm_season_Season_1`.*, `xf_xa_pkm_sport_Sport_2`.*, `xf_user_Commissioner_3`.*, `xf_user_Winner1_4`.*, `xf_user_Winner2_5`.*, `xf_user_Winner3_6`.*
FROM `xf_xa_pkm_pool`
INNER JOIN `xf_xa_pkm_season` AS `xf_xa_pkm_season_Season_1` ON (`xf_xa_pkm_season_Season_1`.`season_id` = `xf_xa_pkm_pool`.`season_id`)
INNER JOIN `xf_xa_pkm_sport` AS `xf_xa_pkm_sport_Sport_2` ON (`xf_xa_pkm_sport_Sport_2`.`sport_id` = `xf_xa_pkm_season_Season_1`.`sport_id`)
LEFT JOIN `xf_user` AS `xf_user_Commissioner_3` ON (`xf_user_Commissioner_3`.`user_id` = `xf_xa_pkm_pool`.`pool_commissioner_user_id`)
LEFT JOIN `xf_user` AS `xf_user_Winner1_4` ON (`xf_user_Winner1_4`.`user_id` = `xf_xa_pkm_pool`.`winner1_id`)
LEFT JOIN `xf_user` AS `xf_user_Winner2_5` ON (`xf_user_Winner2_5`.`user_id` = `xf_xa_pkm_pool`.`winner2_id`)
LEFT JOIN `xf_user` AS `xf_user_Winner3_6` ON (`xf_user_Winner3_6`.`user_id` = `xf_xa_pkm_pool`.`winner3_id`)
WHERE ((`xf_xa_pkm_pool`.`pool_status` IN ('open', 'closed', 'final'))) AND (`xf_xa_pkm_pool`.`pool_type` = 'survivor') AND (`xf_xa_pkm_pool`.`pool_status` = 'open')
ORDER BY `xf_xa_pkm_pool`.`pool_id` DESC
LIMIT 20
    Run Time: 0.003562
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_pkm_season_Season_1ALLPRIMARY,sport_id   1Using temporary; Using filesort
    SIMPLExf_xa_pkm_sport_Sport_2eq_refPRIMARYPRIMARY4nzwarriorscom.xf_xa_pkm_season_Season_1.sport_id1 
    SIMPLExf_xa_pkm_poolref|filterseason_id,pool_type,pool_statusseason_id|pool_status4|1nzwarriorscom.xf_xa_pkm_season_Season_1.season_id1 (40%)Using where; Using rowid filter
    SIMPLExf_user_Commissioner_3eq_refPRIMARYPRIMARY4nzwarriorscom.xf_xa_pkm_pool.pool_commissioner_user_id1 
    SIMPLExf_user_Winner1_4eq_refPRIMARYPRIMARY4nzwarriorscom.xf_xa_pkm_pool.winner1_id1 
    SIMPLExf_user_Winner2_5eq_refPRIMARYPRIMARY4nzwarriorscom.xf_xa_pkm_pool.winner2_id1 
    SIMPLExf_user_Winner3_6eq_refPRIMARYPRIMARY4nzwarriorscom.xf_xa_pkm_pool.winner3_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1445
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/Pickem/ControllerPlugin/PoolList.php at line 66
    4. XenAddons\Pickem\ControllerPlugin\PoolList->getPoolListData() in src/addons/XenAddons/Pickem/Pub/Controller/Pickem.php at line 35
    5. XenAddons\Pickem\Pub\Controller\Pickem->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
    6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
    7. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
    8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
    9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    10. XF\App->run() in src/XF.php at line 806
    11. XF::runApp() in index.php at line 23
  6. SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
    Params: 0, DF�A
    Run Time: 0.000166
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activityconstPRIMARYPRIMARY22const,const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/addons/DigitalPoint/Cloudflare/XF/Repository/SessionActivity.php at line 32
    4. DigitalPoint\Cloudflare\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 99
    5. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 62
    6. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 372
    7. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    12. XF\App->run() in src/XF.php at line 806
    13. XF::runApp() in index.php at line 23
  7. -- 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: DF�A, XenAddons\Pickem\Pub\Controller\PickemController, Index, valid, , 1751365280, anthropic, {"country_iso":"US","city":"Dallas","region":"Texas","longitude":"-96.80667","latitude":"32.78306"}, 0, DF�A
    Run Time: 0.000202

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/addons/DigitalPoint/Cloudflare/XF/Repository/SessionActivity.php at line 152
    3. DigitalPoint\Cloudflare\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 99
    4. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 62
    5. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 372
    6. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    11. XF\App->run() in src/XF.php at line 806
    12. XF::runApp() in index.php at line 23
  8. 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.000401
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_siropu_ads_manager_adALLtype,status,status_display_order   13Using where; Using filesort
    SIMPLExf_siropu_ads_manager_package_Package_1eq_refPRIMARYPRIMARY4nzwarriorscom.xf_siropu_ads_manager_ad.package_id1 
    SIMPLExf_template_MasterTemplate_2eq_reftype_title_style_idtype_title_style_id128const,func,const1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1445
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManagerLite/Template/Ad.php at line 522
    4. Siropu\AdsManagerLite\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManagerLite/Template/Ad.php at line 399
    5. Siropu\AdsManagerLite\Template\Ad->setAds() in src/addons/Siropu/AdsManagerLite/Template/Ad.php at line 390
    6. Siropu\AdsManagerLite\Template\Ad->__construct() in src/addons/Siropu/AdsManagerLite/Listener.php at line 71
    7. Siropu\AdsManagerLite\Listener::templaterGlobalData() in src/XF/Extension.php at line 86
    8. XF\Extension->fire() in src/XF/App.php at line 3368
    9. XF\App->fire() in src/XF/App.php at line 2500
    10. XF\App->getGlobalTemplateData() in src/XF/App.php at line 2359
    11. XF\App->preRender() in src/XF/Pub/App.php at line 505
    12. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 407
    13. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
    14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    15. XF\App->run() in src/XF.php at line 806
    16. XF::runApp() in index.php at line 23
  9. SELECT `xf_xa_pkm_pool`.*, `xf_xa_pkm_season_Season_1`.*, `xf_xa_pkm_sport_Sport_2`.*, `xf_user_Commissioner_3`.*
FROM `xf_xa_pkm_pool`
LEFT JOIN `xf_xa_pkm_season` AS `xf_xa_pkm_season_Season_1` ON (`xf_xa_pkm_season_Season_1`.`season_id` = `xf_xa_pkm_pool`.`season_id`)
LEFT JOIN `xf_xa_pkm_sport` AS `xf_xa_pkm_sport_Sport_2` ON (`xf_xa_pkm_sport_Sport_2`.`sport_id` = `xf_xa_pkm_season_Season_1`.`sport_id`)
LEFT JOIN `xf_user` AS `xf_user_Commissioner_3` ON (`xf_user_Commissioner_3`.`user_id` = `xf_xa_pkm_pool`.`pool_commissioner_user_id`)
WHERE (`xf_xa_pkm_pool`.`pool_id` = 3)

LIMIT 1
    Run Time: 0.000832
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_pkm_poolconstPRIMARYPRIMARY4const1 
    SIMPLExf_xa_pkm_season_Season_1constPRIMARYPRIMARY4const1 
    SIMPLExf_xa_pkm_sport_Sport_2constPRIMARYPRIMARY4const1 
    SIMPLExf_user_Commissioner_3constPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1417
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 157
    4. XF\Mvc\Entity\Manager->find() in src/addons/XenAddons/Pickem/Widget/Standings.php at line 45
    5. XenAddons\Pickem\Widget\Standings->render() in internal_data/code_cache/widgets/_56_PickemStandings.php at line 5
    6. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8177
    7. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
    8. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2144
    9. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s2/public/xa_pkm_index.php at line 115
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    18. XF\App->run() in src/XF.php at line 806
    19. XF::runApp() in index.php at line 23
  10. SELECT `xf_xa_pkm_week`.*, `xf_xa_pkm_season_Season_1`.*
FROM `xf_xa_pkm_week`
LEFT JOIN `xf_xa_pkm_season` AS `xf_xa_pkm_season_Season_1` ON (`xf_xa_pkm_season_Season_1`.`season_id` = `xf_xa_pkm_week`.`season_id`)
WHERE (`xf_xa_pkm_week`.`season_id` = 2)
ORDER BY `xf_xa_pkm_week`.`start_date` ASC
    Run Time: 0.000119
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_pkm_weekALLseason_id   58Using where; Using filesort
    SIMPLExf_xa_pkm_season_Season_1constPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1445
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/Pickem/Widget/Standings.php at line 56
    4. XenAddons\Pickem\Widget\Standings->render() in internal_data/code_cache/widgets/_56_PickemStandings.php at line 5
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8177
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2144
    8. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s2/public/xa_pkm_index.php at line 115
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    17. XF\App->run() in src/XF.php at line 806
    18. XF::runApp() in index.php at line 23
  11. SELECT `xf_xa_pkm_player`.*, `xf_user_User_1`.*, `xf_xa_pkm_pool_Pool_2`.*
FROM `xf_xa_pkm_player`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_xa_pkm_player`.`user_id`)
LEFT JOIN `xf_xa_pkm_pool` AS `xf_xa_pkm_pool_Pool_2` ON (`xf_xa_pkm_pool_Pool_2`.`pool_id` = `xf_xa_pkm_player`.`pool_id`)
WHERE (`xf_xa_pkm_player`.`pool_id` = 3)
ORDER BY `xf_user_User_1`.`username` ASC
    Run Time: 0.001905
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_pkm_playerALLPRIMARY,pool_id   187Using where; Using temporary; Using filesort
    SIMPLExf_xa_pkm_pool_Pool_2constPRIMARYPRIMARY4const1 
    SIMPLExf_user_User_1eq_refPRIMARYPRIMARY4nzwarriorscom.xf_xa_pkm_player.user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1445
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/Pickem/Widget/Standings.php at line 74
    4. XenAddons\Pickem\Widget\Standings->render() in internal_data/code_cache/widgets/_56_PickemStandings.php at line 5
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8177
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2144
    8. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s2/public/xa_pkm_index.php at line 115
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    17. XF\App->run() in src/XF.php at line 806
    18. XF::runApp() in index.php at line 23
  12. SELECT COUNT(game.game_id) AS correct_picks, sum(game_data.points) AS points,
	pick.user_id,
	user.user_id, user.username
FROM xf_xa_pkm_game AS game
	LEFT JOIN xf_xa_pkm_game_pool_data AS game_data
		ON (game.game_id = game_data.game_id AND game_data.pool_id = ?)
	LEFT JOIN xf_xa_pkm_pick AS pick
		ON (pick.game_id = game.game_id AND pick.pool_id = ?)
	LEFT JOIN xf_user AS user
		ON (user.user_id = pick.user_id)
WHERE game.game_winner = pick.team_id
	AND game.week_id <= ?
	AND game.season_id = ?
	AND pick.team_id <> 0
GROUP BY pick.user_id
ORDER BY points DESC, correct_picks DESC, user.username, pick.user_id ASC

LIMIT 10
    Params: 3, 3, 56, 2
    Run Time: 0.019954
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEpickALL    16940Using where; Using temporary; Using filesort
    SIMPLEgameeq_ref|filterPRIMARY,week_id,week_id_season_id,season_idseason_id|week_id8|4const,nzwarriorscom.pick.game_id1 (88%)Using where; Using rowid filter
    SIMPLEgame_dataeq_refPRIMARYPRIMARY8nzwarriorscom.pick.game_id,const1 
    SIMPLEusereq_refPRIMARYPRIMARY4nzwarriorscom.pick.user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 167
    3. XF\Db\AbstractAdapter->fetchAllKeyed() in src/addons/XenAddons/Pickem/Repository/Standings.php at line 130
    4. XenAddons\Pickem\Repository\Standings->findStandingsForPoolForStandignsWidget() in src/addons/XenAddons/Pickem/Widget/Standings.php at line 81
    5. XenAddons\Pickem\Widget\Standings->render() in internal_data/code_cache/widgets/_56_PickemStandings.php at line 5
    6. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8177
    7. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
    8. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2144
    9. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s2/public/xa_pkm_index.php at line 115
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    18. XF\App->run() in src/XF.php at line 806
    19. XF::runApp() in index.php at line 23
  13. SELECT COUNT(*)
FROM xf_xa_pkm_game
WHERE season_id = ?
	AND week_id <= ?
    Params: 2, 56
    Run Time: 0.000114
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_xa_pkm_gamerangeweek_id,week_id_season_id,season_idweek_id_season_id8 346Using where; Using index

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/addons/XenAddons/Pickem/Repository/Standings.php at line 13
    4. XenAddons\Pickem\Repository\Standings->getGamesCountOverall() in src/addons/XenAddons/Pickem/Widget/Standings.php at line 84
    5. XenAddons\Pickem\Widget\Standings->render() in internal_data/code_cache/widgets/_56_PickemStandings.php at line 5
    6. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8177
    7. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
    8. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2144
    9. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s2/public/xa_pkm_index.php at line 115
    10. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
    11. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    12. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    13. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
    14. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
    15. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
    16. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    18. XF\App->run() in src/XF.php at line 806
    19. XF::runApp() in index.php at line 23
  14. SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
	AND title IN ('xa_pkm_standings_through_week_x')
    Params: 1
    Run Time: 0.000137
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY106const,const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
    3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 395
    4. XF\Language->loadPhrases() in src/XF/Language.php at line 287
    5. XF\Language->getPhraseText() in src/XF/Language.php at line 144
    6. XF\Language->renderPhrase() in src/XF/Phrase.php at line 89
    7. XF\Phrase->render() in src/XF/Phrase.php at line 99
    8. XF\Phrase->__toString() in src/XF.php at line 1556
    9. XF::escapeString() in src/XF/Template/Templater.php at line 1292
    10. XF\Template\Templater->escape() in internal_data/code_cache/templates/l1/s2/public/xa_pkm_widget_standings.php at line 13
    11. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
    12. XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
    13. XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
    14. XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 2144
    15. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s2/public/xa_pkm_index.php at line 115
    16. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
    17. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    18. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    19. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
    20. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
    21. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
    22. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
    23. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
    24. XF\App->run() in src/XF.php at line 806
    25. XF::runApp() in index.php at line 23

Included Files (431, XenForo Classes: 109)

  1. index.php
  2. src/XF.php
  3. src/vendor/autoload.php
  4. src/vendor/composer/autoload_real.php
  5. src/vendor/composer/ClassLoader.php
  6. src/vendor/composer/autoload_static.php
  7. src/vendor/laminas/laminas-zendframework-bridge/src/autoload.php
  8. src/vendor/laminas/laminas-zendframework-bridge/src/Autoloader.php
  9. src/vendor/laminas/laminas-zendframework-bridge/src/RewriteRules.php
  10. src/vendor/symfony/deprecation-contracts/function.php
  11. src/vendor/symfony/polyfill-php80/bootstrap.php
  12. src/vendor/ralouphie/getallheaders/src/getallheaders.php
  13. src/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
  14. src/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
  15. src/vendor/guzzlehttp/guzzle/src/functions_include.php
  16. src/vendor/guzzlehttp/guzzle/src/functions.php
  17. src/vendor/symfony/polyfill-intl-idn/bootstrap.php
  18. src/vendor/mtdowling/jmespath.php/src/JmesPath.php
  19. src/vendor/symfony/polyfill-intl-grapheme/bootstrap.php
  20. src/vendor/symfony/polyfill-php73/bootstrap.php
  21. src/vendor/aws/aws-sdk-php/src/functions.php
  22. src/vendor/symfony/string/Resources/functions.php
  23. src/vendor/symfony/var-dumper/Resources/functions/dump.php
  24. src/utf8.php
  25. src/XF/Http/Request.php
  26. src/XF/InputFilterer.php
  27. src/XF/Util/Str.php
  28. src/XF/Pub/App.php
  29. src/XF/App.php
  30. src/XF/Container.php
  31. src/config.php
  32. src/XF/DataRegistry.php
  33. src/XF/Db/Mysqli/Adapter.php
  34. src/XF/Db/AbstractAdapter.php
  35. src/XF/CacheFactory.php
  36. src/vendor/symfony/cache/Adapter/MemcachedAdapter.php
  37. src/vendor/symfony/cache/Adapter/AbstractAdapter.php
  38. src/vendor/symfony/cache/Traits/AbstractAdapterTrait.php
  39. src/vendor/psr/log/Psr/Log/LoggerAwareTrait.php
  40. src/vendor/symfony/cache/Traits/ContractsTrait.php
  41. src/vendor/symfony/cache-contracts/CacheTrait.php
  42. src/vendor/psr/cache/src/InvalidArgumentException.php
  43. src/vendor/psr/cache/src/CacheException.php
  44. src/vendor/symfony/cache/Adapter/AdapterInterface.php
  45. src/vendor/symfony/cache/CacheItem.php
  46. src/vendor/symfony/cache-contracts/ItemInterface.php
  47. src/vendor/psr/cache/src/CacheItemInterface.php
  48. src/vendor/psr/cache/src/CacheItemPoolInterface.php
  49. src/vendor/symfony/cache-contracts/CacheInterface.php
  50. src/vendor/psr/log/Psr/Log/LoggerAwareInterface.php
  51. src/vendor/symfony/cache/ResettableInterface.php
  52. src/vendor/symfony/service-contracts/ResetInterface.php
  53. src/vendor/symfony/cache/Marshaller/DefaultMarshaller.php
  54. src/vendor/symfony/cache/Marshaller/MarshallerInterface.php
  55. src/XF/Extension.php
  56. src/XF/AddOn/Manager.php
  57. src/addons/SV/StandardLib/XF/AddOn/Manager.php
  58. src/XF/ComposerAutoload.php
  59. src/addons/BS/ChatGPTFramework/vendor/composer/autoload_namespaces.php
  60. src/addons/BS/ChatGPTFramework/vendor/composer/autoload_psr4.php
  61. src/addons/BS/ChatGPTFramework/vendor/composer/autoload_classmap.php
  62. src/addons/DCom/LiveContent/vendor/composer/autoload_namespaces.php
  63. src/addons/DCom/LiveContent/vendor/composer/autoload_psr4.php
  64. src/addons/DCom/LiveContent/vendor/composer/autoload_classmap.php
  65. src/addons/DCom/LiveContent/vendor/composer/autoload_files.php
  66. src/addons/DCom/LiveContent/vendor/paragonie/sodium_compat/autoload.php
  67. src/addons/DCom/LiveContent/vendor/paragonie/sodium_compat/autoload-php7.php
  68. src/addons/DCom/LiveContent/vendor/paragonie/sodium_compat/src/Compat.php
  69. src/addons/DCom/LiveContent/vendor/paragonie/sodium_compat/lib/namespaced.php
  70. src/addons/DCom/LiveContent/vendor/paragonie/sodium_compat/lib/sodium_compat.php
  71. src/addons/DCom/LiveContent/vendor/paragonie/sodium_compat/lib/constants.php
  72. src/addons/DCom/LiveContent/vendor/paragonie/sodium_compat/lib/php84compat_const.php
  73. src/addons/DCom/LiveContent/vendor/paragonie/sodium_compat/lib/php84compat.php
  74. src/addons/DCom/LiveContent/vendor/paragonie/sodium_compat/lib/stream-xchacha20.php
  75. src/addons/DCom/LiveContent/vendor/paragonie/sodium_compat/lib/ristretto255.php
  76. src/addons/SECURIDEA/ChatGPTRssEnhancer/vendor/composer/autoload_namespaces.php
  77. src/addons/SECURIDEA/ChatGPTRssEnhancer/vendor/composer/autoload_psr4.php
  78. src/addons/SECURIDEA/ChatGPTRssEnhancer/vendor/composer/autoload_classmap.php
  79. src/addons/SECURIDEA/ChatGPTRssEnhancer/vendor/composer/autoload_files.php
  80. src/addons/SECURIDEA/ChatGPTRssEnhancer/dummy.php
  81. src/addons/SV/StandardLib/fake_composer/autoload_namespaces.php
  82. src/addons/SV/StandardLib/fake_composer/autoload_psr4.php
  83. src/addons/SV/StandardLib/fake_composer/autoload_classmap.php
  84. src/addons/Wutime/AdBlockTracker/vendor/composer/autoload_namespaces.php
  85. src/addons/Wutime/AdBlockTracker/vendor/composer/autoload_psr4.php
  86. src/addons/Wutime/AdBlockTracker/vendor/composer/autoload_classmap.php
  87. src/addons/BS/AIBots/Listener.php
  88. src/addons/BS/AIBots/Repository/Bot.php
  89. src/XF/Mvc/Entity/Repository.php
  90. src/addons/BS/AIBots/Repository/Reminder.php
  91. src/addons/BS/ChatGPTFramework/Listener.php
  92. src/addons/BS/ChatGPTFramework/Consts.php
  93. src/addons/BS/ChatGPTFramework/Enums/JsonSchema/Type.php
  94. src/addons/DCom/LiveContent/Listener.php
  95. src/addons/DigitalPoint/Cloudflare/Listener/AppSetup.php
  96. src/XF/Options.php
  97. src/addons/OzzModz/ScheduledContent/Listener.php
  98. src/addons/Siropu/AdsManagerLite/Listener.php
  99. src/addons/Siropu/AdsManagerLite/Vendor/MobileDetect/autoload.php
  100. src/addons/Siropu/AdsManagerLite/Vendor/MobileDetect/composer/autoload_real.php
  101. src/addons/Siropu/AdsManagerLite/Vendor/MobileDetect/composer/platform_check.php
  102. src/addons/Siropu/AdsManagerLite/Vendor/MobileDetect/composer/autoload_static.php
  103. src/XF/Session/Session.php
  104. src/vendor-patch/Doctrine/Common/Cache/CacheProvider.php
  105. src/XF/Session/CacheStorage.php
  106. src/XF/Session/StorageInterface.php
  107. src/addons/SV/StandardLib/XF/InputFilterer.php
  108. src/XF/Util/Ip.php
  109. src/XF/Util/Random.php
  110. src/addons/Siropu/KeywordLinking/Listener.php
  111. src/addons/Siropu/KeywordLinking/Vendor/MobileDetect/autoload.php
  112. src/addons/Siropu/KeywordLinking/Vendor/MobileDetect/composer/autoload_real.php
  113. src/addons/Siropu/KeywordLinking/Vendor/MobileDetect/composer/platform_check.php
  114. src/addons/Siropu/KeywordLinking/Vendor/MobileDetect/composer/autoload_static.php
  115. src/addons/XFMG/Listener.php
  116. src/addons/XenAddons/Showcase/Listener.php
  117. src/XF/Http/Response.php
  118. src/XF/Mvc/Entity/Manager.php
  119. src/XF/Mvc/Entity/ValueFormatter.php
  120. src/XF/Repository/UserRepository.php
  121. src/addons/Andrew/ModeratorPanel/XF/Repository/User.php
  122. src/XF/Entity/User.php
  123. src/XF/Mvc/Entity/Entity.php
  124. src/XF/Entity/LinkableInterface.php
  125. src/addons/DCom/LiveContent/XF/Entity/User.php
  126. src/addons/OzzModz/ScheduledContent/XF/Entity/User.php
  127. src/addons/Siropu/KeywordLinking/XF/Entity/User.php
  128. src/addons/Siropu/KeywordLinking/Entity/KeywordTrait.php
  129. src/addons/SV/AlertImprovements/XF/Entity/User.php
  130. src/addons/ThemeHouse/AvatarGallery/XF/Entity/User.php
  131. src/addons/Wutime/AdBlockTracker/XF/Entity/User.php
  132. src/addons/Wutime/PostHighlight/XF/Entity/User.php
  133. src/addons/XenAddons/Pickem/XF/Entity/User.php
  134. src/addons/XenAddons/PRS/XF/Entity/User.php
  135. src/addons/XenAddons/Showcase/XF/Entity/User.php
  136. src/addons/XFMG/XF/Entity/User.php
  137. src/addons/SV/Threadmarks/XF/Entity/User.php
  138. src/addons/SV/AttachmentImprovements/XF/Entity/User.php
  139. src/addons/SV/SearchImprovements/XF/Entity/User.php
  140. src/addons/Andrew/ModeratorPanel/XF/Entity/User.php
  141. src/addons/SV/ElasticSearchEssentials/XF/Entity/User.php
  142. src/XF/Mvc/Entity/Structure.php
  143. src/addons/SV/StandardLib/Helper.php
  144. src/XF/Repository/UserAlertRepository.php
  145. src/addons/SV/AlertImprovements/XF/Repository/UserAlertPatch.php
  146. src/addons/SV/AlertImprovements/XF/Repository/UserAlert.php
  147. src/addons/DCom/LiveContent/XF/Repository/UserAlert.php
  148. src/addons/SV/AlertImprovements/XF/Repository/UserAlertAutoReadPatch.php
  149. src/XF/Entity/UserAuth.php
  150. src/XF/Entity/UserOption.php
  151. src/addons/SV/AlertImprovements/XF/Entity/UserOptionPatch1.php
  152. src/addons/SV/AlertImprovements/XF/Entity/UserOption.php
  153. src/addons/Wutime/AdBlockTracker/XF/Entity/UserOption.php
  154. src/addons/SV/AlertImprovements/XF/Entity/UserOptionPatch2.php
  155. src/addons/SV/SearchImprovements/XF/Entity/UserOption.php
  156. src/addons/SV/ElasticSearchEssentials/XF/Entity/UserOption.php
  157. src/addons/SV/AlertImprovements/Enum/PopUpReadBehavior.php
  158. src/XF/Entity/UserProfile.php
  159. src/XF/Entity/UserPrivacy.php
  160. src/addons/OzzModz/DebugDevelopment/Listener.php
  161. src/XF/Util/Php.php
  162. src/XF/PermissionCache.php
  163. src/XF/PermissionSet.php
  164. src/XF/Db/Mysqli/Statement.php
  165. src/XF/Db/AbstractStatement.php
  166. src/XF/Util/File.php
  167. src/XF/Language.php
  168. src/addons/SV/ElasticSearchEssentials/Globals.php
  169. src/addons/DigitalPoint/Cloudflare/Listener/AppPubStartEnd.php
  170. src/addons/DigitalPoint/PWA/Listener/AppPubStartEnd.php
  171. src/XF/Mvc/Dispatcher.php
  172. src/XF/Mvc/Router.php
  173. src/addons/SV/StandardLib/XF/Mvc/Router.php
  174. src/addons/SV/StandardLib/Repository/LinkBuilder.php
  175. src/addons/SV/SearchImprovements/Listener/LinkBuilder.php
  176. src/XF/Mvc/RouteMatch.php
  177. src/XF/Util/Arr.php
  178. src/XF/Mvc/ParameterBag.php
  179. src/addons/XenAddons/Pickem/Pub/Controller/Pickem.php
  180. src/addons/XenAddons/Pickem/Pub/Controller/AbstractController.php
  181. src/XF/Pub/Controller/AbstractController.php
  182. src/XF/Mvc/Controller.php
  183. src/XF/Pub/Controller/EmbedResolverTrait.php
  184. src/addons/XenAddons/Pickem/ControllerPlugin/PoolList.php
  185. src/XF/ControllerPlugin/AbstractPlugin.php
  186. src/addons/XenAddons/Pickem/Repository/Pool.php
  187. src/addons/XenAddons/Pickem/Entity/Pool.php
  188. src/addons/XenAddons/Pickem/Entity/CommentableTrait.php
  189. src/XF/Entity/EmbedResolverTrait.php
  190. src/XF/Entity/ViewableInterface.php
  191. src/addons/XenAddons/Pickem/Finder/Pool.php
  192. src/XF/Mvc/Entity/Finder.php
  193. src/addons/XenAddons/Pickem/Entity/Season.php
  194. src/addons/XenAddons/Pickem/Entity/Sport.php
  195. src/addons/XenAddons/Pickem/Repository/Sport.php
  196. src/addons/XenAddons/Pickem/Finder/Sport.php
  197. src/XF/Mvc/Entity/ArrayCollection.php
  198. src/XF/Mvc/Entity/AbstractCollection.php
  199. src/addons/XenAddons/Pickem/Repository/Season.php
  200. src/addons/XenAddons/Pickem/Finder/Season.php
  201. src/XF/Mvc/Reply/View.php
  202. src/XF/Mvc/Reply/AbstractReply.php
  203. src/XF/Repository/SessionActivityRepository.php
  204. src/addons/DigitalPoint/Cloudflare/XF/Repository/SessionActivity.php
  205. src/XF/Data/Robot.php
  206. src/XF/Style.php
  207. src/XF/Repository/StyleRepository.php
  208. src/XF/Template/Templater.php
  209. src/addons/SV/StandardLib/XF/Template/TemplaterXF21Patch.php
  210. src/addons/BS/AIBots/XF/Template/Templater.php
  211. src/addons/DCom/LiveContent/XF/Template/Templater.php
  212. src/addons/DigitalPoint/Cloudflare/XF/Template/Templater.php
  213. src/addons/SV/StandardLib/XF/Template/Templater.php
  214. src/XF/SubContainer/BbCode.php
  215. src/XF/SubContainer/AbstractSubContainer.php
  216. src/XF/SubContainer/Widget.php
  217. src/addons/ThemeHouse/AvatarGallery/Listener/TemplaterSetup.php
  218. src/addons/ThemeHouse/AvatarGallery/Template/TemplaterSetup.php
  219. src/addons/XFMG/Template/TemplaterSetup.php
  220. src/addons/XenAddons/PRS/Listener.php
  221. src/addons/XenAddons/PRS/Template/TemplaterSetup.php
  222. src/addons/XenAddons/Pickem/Listener.php
  223. src/addons/XenAddons/Pickem/Template/TemplaterSetup.php
  224. src/addons/XenAddons/Showcase/Template/TemplaterSetup.php
  225. src/addons/SV/StandardLib/TemplaterHelper.php
  226. src/addons/SV/Threadmarks/SV/StandardLib/TemplaterHelper.php
  227. src/addons/SV/SearchImprovements/SV/StandardLib/TemplaterHelper.php
  228. src/addons/SV/StandardLib/TemplaterAccess.php
  229. src/addons/SV/Threadmarks/Repository/ThreadmarkIndex.php
  230. src/XF/IconRenderer.php
  231. src/XF/Repository/IconRepository.php
  232. src/XF/Search/Search.php
  233. src/XF/ResultSetInterface.php
  234. src/addons/SV/SearchImprovements/XF/Search/SearchPatch.php
  235. src/addons/XFES/XF/Search/Search.php
  236. src/addons/SV/SearchImprovements/XF/Search/Search.php
  237. src/addons/SV/ElasticSearchEssentials/XF/Search/Search.php
  238. src/addons/XFES/Listener.php
  239. src/addons/XFES/Elasticsearch/Api.php
  240. src/addons/SV/SearchImprovements/XFES/Elasticsearch/Api.php
  241. src/addons/DCom/LiveContent/vendor/guzzlehttp/psr7/src/Uri.php
  242. src/addons/SECURIDEA/ChatGPTRssEnhancer/vendor/psr/http-message/src/UriInterface.php
  243. src/XF/SubContainer/Http.php
  244. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/Client.php
  245. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/ClientTrait.php
  246. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/ClientInterface.php
  247. src/addons/DCom/LiveContent/vendor/psr/http-client/src/ClientInterface.php
  248. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/HandlerStack.php
  249. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/Utils.php
  250. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php
  251. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/Handler/CurlMultiHandler.php
  252. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php
  253. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/Handler/CurlFactoryInterface.php
  254. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/Handler/CurlHandler.php
  255. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/Handler/StreamHandler.php
  256. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/Middleware.php
  257. src/addons/DCom/LiveContent/vendor/guzzlehttp/psr7/src/Utils.php
  258. src/addons/DCom/LiveContent/vendor/guzzlehttp/guzzle/src/RedirectMiddleware.php
  259. src/addons/XFES/Search/Source/Elasticsearch.php
  260. src/XF/Search/Source/AbstractSource.php
  261. src/addons/SV/SearchImprovements/XFES/Search/Source/Elasticsearch.php
  262. src/addons/SV/SearchImprovements/Search/MetadataSearchEnhancements.php
  263. src/addons/SV/SearchImprovements/Search/ExecuteSearchWrapper.php
  264. src/addons/SV/ElasticSearchEssentials/XFES/Search/Source/Elasticsearch.php
  265. src/addons/SV/SearchImprovements/Globals.php
  266. src/addons/SV/SearchImprovements/Repository/SpecializedSearchIndex.php
  267. src/XF/CookieConsent.php
  268. src/XF/Captcha/Turnstile.php
  269. src/XF/Captcha/AbstractCaptcha.php
  270. src/XF/Repository/PaymentRepository.php
  271. src/XF/Payment/PayPalRest.php
  272. src/XF/Payment/AbstractProvider.php
  273. src/XF/SimpleCache.php
  274. src/addons/DCom/LiveContent/Service/SocketHelper.php
  275. src/XF/Service/AbstractService.php
  276. src/addons/Siropu/AdsManagerLite/Template/Ad.php
  277. src/addons/Siropu/AdsManagerLite/Util/Arr.php
  278. src/addons/Siropu/AdsManagerLite/Repository/Ad.php
  279. src/addons/Siropu/AdsManagerLite/Entity/Ad.php
  280. src/addons/Siropu/AdsManagerLite/Entity/AbstractEntity.php
  281. src/addons/Siropu/AdsManagerLite/Finder/Ad.php
  282. src/addons/Siropu/AdsManagerLite/Entity/Package.php
  283. src/XF/Entity/Template.php
  284. src/XF/Criteria/UserCriteria.php
  285. src/XF/Criteria/AbstractCriteria.php
  286. src/XF/Criteria/PageCriteria.php
  287. src/addons/Siropu/AdsManagerLite/XF/Criteria/Page.php
  288. src/addons/Siropu/AdsManagerLite/Criteria/Position.php
  289. src/addons/Siropu/KeywordLinking/Vendor/MobileDetect/mobiledetect/mobiledetectlib/src/MobileDetect.php
  290. src/addons/Siropu/KeywordLinking/Vendor/MobileDetect/mobiledetect/mobiledetectlib/src/Cache/Cache.php
  291. src/addons/Siropu/KeywordLinking/Vendor/MobileDetect/psr/simple-cache/src/CacheInterface.php
  292. src/addons/Siropu/KeywordLinking/Vendor/MobileDetect/mobiledetect/mobiledetectlib/src/Cache/CacheItem.php
  293. src/addons/Siropu/KeywordLinking/Keyword.php
  294. src/addons/SV/BrowserDetection/Listener.php
  295. src/addons/SV/BrowserDetection/MobileDetectCache.php
  296. src/XF/Mvc/Renderer/Html.php
  297. src/XF/Mvc/Renderer/AbstractRenderer.php
  298. src/XF/Mvc/View.php
  299. src/XF/Template/Template.php
  300. internal_data/code_cache/templates/l1/s2/public/xa_pkm_index.php
  301. src/XF/PreEscaped.php
  302. internal_data/code_cache/templates/l1/s2/public/metadata_macros.php
  303. src/XF/Template/MacroState.php
  304. internal_data/code_cache/templates/l1/s2/public/xa_pkm_index_macros.php
  305. internal_data/code_cache/templates/l1/s2/public/xa_pkm_pool_list_macros.php
  306. src/XF/Str/Formatter.php
  307. internal_data/code_cache/widgets/_56_PickemStandings.php
  308. src/XF/Widget/WidgetConfig.php
  309. src/addons/XenAddons/Pickem/Widget/Standings.php
  310. src/XF/Widget/AbstractWidget.php
  311. src/addons/XenAddons/Pickem/Repository/Week.php
  312. src/addons/XenAddons/Pickem/Entity/Week.php
  313. src/addons/XenAddons/Pickem/Finder/Week.php
  314. src/addons/XenAddons/Pickem/Repository/Player.php
  315. src/addons/XenAddons/Pickem/Entity/Player.php
  316. src/addons/XenAddons/Pickem/Finder/Player.php
  317. src/addons/XenAddons/Pickem/Repository/Standings.php
  318. src/XF/Phrase.php
  319. internal_data/code_cache/phrase_groups/l1/widget.php
  320. internal_data/code_cache/phrase_groups/l1/widget_def.php
  321. src/XF/Widget/WidgetRenderer.php
  322. internal_data/code_cache/templates/l1/s2/public/xa_pkm_widget_standings.php
  323. src/addons/Wutime/PostHighlight/Listener.php
  324. internal_data/code_cache/navigation_cache.php
  325. src/XF/Pub/Route/Search.php
  326. src/XF/NoticeList.php
  327. src/XF/Util/Url.php
  328. src/addons/Kirby/StyleVariationDefault/Listener.php
  329. internal_data/code_cache/templates/l1/s2/public/PAGE_CONTAINER.php
  330. src/addons/SV/ElasticSearchEssentials/Repository/AutoComplete.php
  331. src/addons/SV/ElasticSearchEssentials/Repository/MobileDetect.php
  332. src/XF/Repository/SearchRepository.php
  333. src/addons/SV/ElasticSearchEssentials/XF/Repository/SearchPatch.php
  334. src/addons/SV/StandardLib/Repository/Helper.php
  335. internal_data/code_cache/svShim/ffb2737fed1d744207253d3803dba084.php
  336. src/addons/SV/ElasticSearchEssentials/XF/Repository/XF22/SearchPatch.php
  337. src/addons/SV/ElasticSearchEssentials/Repository/SearchTrait.php
  338. src/addons/SV/SearchImprovements/XF/Repository/Search.php
  339. src/addons/SV/SearchImprovements/XF/Repository/SearchPatch.php
  340. internal_data/code_cache/svShim/d236705261fe2fa7cf8431c34179ee35.php
  341. src/addons/SV/SearchImprovements/XF/Repository/XF22/SearchPatch.php
  342. src/addons/SV/ElasticSearchEssentials/XF/Repository/Search.php
  343. src/XF/Search/Data/Conversation.php
  344. src/XF/Search/Data/AbstractData.php
  345. src/XF/Search/Data/AutoCompletableTrait.php
  346. src/XF/Search/Data/AutoCompletableInterface.php
  347. src/addons/SV/ConversationImprovements/XF/Search/Data/Conversation.php
  348. src/addons/SV/SearchImprovements/Search/DiscussionTrait.php
  349. src/addons/SV/Threadmarks/XF/Search/Data/Conversation.php
  350. src/addons/SV/Threadmarks/Search/ThreadmarkSearcherTraitv2.php
  351. src/XF/Search/Data/ConversationMessage.php
  352. src/addons/SV/ConversationImprovements/XF/Search/Data/ConversationMessage.php
  353. src/addons/SV/Threadmarks/XF/Search/Data/ConversationMessage.php
  354. src/addons/SV/Threadmarks/Search/IThreadmarkSearcher.php
  355. src/XF/Search/Data/Page.php
  356. src/addons/XenAddons/Pickem/Search/Data/Comment.php
  357. src/XF/Search/Data/Post.php
  358. src/addons/SV/SearchImprovements/XF/Search/Data/Post.php
  359. src/addons/SV/Threadmarks/XF/Search/Data/Post.php
  360. src/addons/SV/Threadmarks/Search/ThreadmarkSearcherTrait.php
  361. src/addons/SV/ElasticSearchEssentials/XF/Search/Data/Post.php
  362. src/addons/SV/ElasticSearchEssentials/Search/Data/DataSourceMetadataUpdater.php
  363. src/addons/SV/ElasticSearchEssentials/Search/Data/ContentRatingTrait.php
  364. src/addons/SV/ElasticSearchEssentials/Search/Data/IGroupable.php
  365. src/XF/Search/Data/ProfilePost.php
  366. src/addons/SV/ElasticSearchEssentials/XF/Search/Data/ProfilePost.php
  367. src/XF/Search/Data/ProfilePostComment.php
  368. src/addons/SV/ElasticSearchEssentials/XF/Search/Data/ProfilePostComment.php
  369. src/addons/XenAddons/PRS/Search/Data/Game.php
  370. src/addons/XenAddons/PRS/Search/Data/Player.php
  371. src/addons/XenAddons/PRS/Search/Data/Stadium.php
  372. src/addons/XenAddons/PRS/Search/Data/Team.php
  373. src/addons/XenAddons/Showcase/Search/Data/Comment.php
  374. src/addons/XenAddons/Showcase/Search/Data/Item.php
  375. src/addons/XenAddons/Showcase/Search/Data/Page.php
  376. src/addons/XenAddons/Showcase/Search/Data/Rating.php
  377. src/addons/XenAddons/Showcase/Search/Data/RatingReply.php
  378. src/addons/XenAddons/Showcase/Search/Data/Series.php
  379. src/addons/XenAddons/Showcase/Search/Data/ItemUpdate.php
  380. src/addons/XenAddons/Showcase/Search/Data/ItemUpdateReply.php
  381. src/XF/Search/Data/Thread.php
  382. src/addons/SV/SearchImprovements/XF/Search/Data/Thread.php
  383. src/addons/SV/Threadmarks/XF/Search/Data/Thread.php
  384. src/addons/SV/ElasticSearchEssentials/XF/Search/Data/Thread.php
  385. src/addons/SV/ElasticSearchEssentials/Search/Data/ContentRestrictionTrait.php
  386. src/addons/SV/ElasticSearchEssentials/Search/Data/ContentViewsTrait.php
  387. src/addons/SV/ElasticSearchEssentials/Search/Data/ContentRepliesTrait.php
  388. src/addons/SV/ElasticSearchEssentials/Search/IResultAutoComplete.php
  389. src/addons/SV/ElasticSearchEssentials/Search/Data/ILastUpdate.php
  390. src/addons/SV/ElasticSearchEssentials/Search/Data/IContentRestriction.php
  391. src/addons/SV/ElasticSearchEssentials/Search/Data/IAutoCompleteInputFilter.php
  392. src/addons/XFMG/Search/Data/Album.php
  393. src/addons/XFMG/Search/Data/Comment.php
  394. src/addons/XFMG/Search/Data/Media.php
  395. src/addons/SV/BrowserDetection/MobileDetect.php
  396. src/XF/Util/Color.php
  397. internal_data/code_cache/templates/l1/s2/public/xb_custom_fonts.php
  398. internal_data/code_cache/templates/l1/s2/public/ba_google_analytics.php
  399. internal_data/code_cache/templates/l1/s2/public/helper_js_global.php
  400. internal_data/code_cache/templates/l1/s2/public/siropu_ads_manager_ad_js.php
  401. internal_data/code_cache/templates/l1/s2/public/siropu_ads_manager_ad_macros.php
  402. internal_data/code_cache/templates/l1/s2/public/helper_js_analytics.php
  403. internal_data/code_cache/templates/l1/s2/public/xb_head.php
  404. internal_data/code_cache/templates/l1/s2/public/andrew_moderatorpanel_macros.php
  405. internal_data/code_cache/templates/l1/s2/public/style_variation_macros.php
  406. internal_data/code_cache/phrase_groups/l1/nav.php
  407. internal_data/code_cache/templates/l1/s2/public/svESE_search_form_macros.php
  408. internal_data/code_cache/phrase_groups/l1/button.php
  409. internal_data/code_cache/templates/l1/s2/public/xb_subnav_right.php
  410. internal_data/code_cache/templates/l1/s2/public/xb_canvas_panel_top.php
  411. internal_data/code_cache/templates/l1/s2/public/xb_canvas_panel_bottom.php
  412. internal_data/code_cache/templates/l1/s2/public/notice_macros.php
  413. src/addons/Siropu/AdsManagerLite/Service/Stats/Tracker.php
  414. internal_data/code_cache/templates/l1/s2/public/_ads.php
  415. internal_data/code_cache/templates/l1/s2/public/browser_warning_macros.php
  416. internal_data/code_cache/templates/l1/s2/public/xb_welcome.php
  417. internal_data/code_cache/templates/l1/s2/public/xb_sidebar_login.php
  418. internal_data/code_cache/templates/l1/s2/public/xb_footer_links.php
  419. internal_data/code_cache/templates/l1/s2/public/debug_macros.php
  420. internal_data/code_cache/templates/l1/s2/public/xb_body_helper.php
  421. internal_data/code_cache/templates/l1/s2/public/xb_body.php
  422. internal_data/code_cache/templates/l1/s2/public/dcom_lc_macros.php
  423. src/addons/Wutime/AdBlockTracker/Helper/AdBlockTrackerExtended.php
  424. src/addons/Wutime/AdBlockTracker/Src/AdBlockTracker.php
  425. src/addons/Wutime/AdBlockTracker/vendor/jaybizzle/crawler-detect/src/CrawlerDetect.php
  426. src/addons/Wutime/AdBlockTracker/vendor/jaybizzle/crawler-detect/src/Fixtures/Crawlers.php
  427. src/addons/Wutime/AdBlockTracker/vendor/jaybizzle/crawler-detect/src/Fixtures/AbstractProvider.php
  428. src/addons/Wutime/AdBlockTracker/vendor/jaybizzle/crawler-detect/src/Fixtures/Exclusions.php
  429. src/addons/Wutime/AdBlockTracker/vendor/jaybizzle/crawler-detect/src/Fixtures/Headers.php
  430. src/addons/DigitalPoint/Cloudflare/Listener/AppPubComplete.php
  431. src/XF/Debugger.php

DB Connection Stats

bytes_sent13134
bytes_received240199
packets_sent166
packets_received1916
protocol_overhead_in7664
protocol_overhead_out664
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet567
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet206
bytes_received_prepare_response_packet138756
bytes_received_change_user_packet100004
packets_sent_command82
packets_received_ok0
packets_received_eof0
packets_received_rset_header63
packets_received_rset_field_meta0
packets_received_rset_row29
packets_received_prepare_response1636
packets_received_change_user159
result_set_queries26
non_result_set_queries3
no_index_used8
bad_index_used0
slow_queries0
buffered_sets0
unbuffered_sets0
ps_buffered_sets26
ps_unbuffered_sets0
flushed_normal_sets0
flushed_ps_sets0
ps_prepared_never_executed0
ps_prepared_once_executed26
rows_fetched_from_server_normal0
rows_fetched_from_server_ps133
rows_buffered_from_client_normal0
rows_buffered_from_client_ps133
rows_fetched_from_client_normal_buffered0
rows_fetched_from_client_normal_unbuffered0
rows_fetched_from_client_ps_buffered0
rows_fetched_from_client_ps_unbuffered0
rows_fetched_from_client_ps_cursor0
rows_affected_normal0
rows_affected_ps0
rows_skipped_normal0
rows_skipped_ps0
copy_on_write_saved0
copy_on_write_performed0
command_buffer_too_small0
connect_success1
connect_failure0
connection_reused0
reconnect0
pconnect_success1
active_connections1
active_persistent_connections1
explicit_close0
implicit_close0
disconnect_close0
in_middle_of_command_close0
explicit_free_result0
implicit_free_result25
explicit_stmt_close0
implicit_stmt_close0
mem_emalloc_count0
mem_emalloc_amount0
mem_ecalloc_count0
mem_ecalloc_amount0
mem_erealloc_count0
mem_erealloc_amount0
mem_efree_count0
mem_efree_amount0
mem_malloc_count0
mem_malloc_amount0
mem_calloc_count0
mem_calloc_amount0
mem_realloc_count0
mem_realloc_amount0
mem_free_count0
mem_free_amount0
mem_estrndup_count0
mem_strndup_count0
mem_estrdup_count0
mem_strdup_count0
mem_edupl_count0
mem_dupl_count0
proto_text_fetched_null0
proto_text_fetched_bit0
proto_text_fetched_tinyint0
proto_text_fetched_short0
proto_text_fetched_int240
proto_text_fetched_int0
proto_text_fetched_bigint0
proto_text_fetched_decimal0
proto_text_fetched_float0
proto_text_fetched_double0
proto_text_fetched_date0
proto_text_fetched_year0
proto_text_fetched_time0
proto_text_fetched_datetime0
proto_text_fetched_timestamp0
proto_text_fetched_string0
proto_text_fetched_blob0
proto_text_fetched_enum0
proto_text_fetched_set0
proto_text_fetched_geometry0
proto_text_fetched_other0
proto_binary_fetched_null0
proto_binary_fetched_bit517
proto_binary_fetched_tinyint0
proto_binary_fetched_short614
proto_binary_fetched_int24215
proto_binary_fetched_int0
proto_binary_fetched_bigint3424
proto_binary_fetched_decimal88
proto_binary_fetched_float151
proto_binary_fetched_double0
proto_binary_fetched_date0
proto_binary_fetched_year0
proto_binary_fetched_time0
proto_binary_fetched_datetime0
proto_binary_fetched_timestamp0
proto_binary_fetched_string0
proto_binary_fetched_json1470
proto_binary_fetched_blob346
proto_binary_fetched_enum0
proto_binary_fetched_set0
proto_binary_fetched_geometry0
proto_binary_fetched_other0
init_command_executed_count0
init_command_failed_count0
com_quit0
com_init_db0
com_query2
com_field_list0
com_create_db0
com_drop_db0
com_refresh0
com_shutdown0
com_statistics0
com_process_info0
com_connect0
com_process_kill0
com_debug0
com_ping0
com_time0
com_delayed_insert0
com_change_user0
com_binlog_dump0
com_table_dump0
com_connect_out0
com_register_slave0
com_stmt_prepare27
com_stmt_execute27
com_stmt_send_long_data0
com_stmt_close26
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps96214