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.000361
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 49 | 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 172
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 102
- XF\DataRegistry->get() in src/XF/App.php at line 2287
- XF\App->preLoadData() in src/XF/App.php at line 2272
- XF\App->setup() in src/XF/Pub/App.php at line 116
- XF\Pub\App->setup() in src/XF.php at line 787
- XF::setupApp() in src/XF.php at line 810
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000090
| 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 1268
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 269
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 40
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 140
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 361
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '42246')
LIMIT 1
Run Time: 0.000955
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_4 | const | PRIMARY | PRIMARY | 35 | const,const,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 1435
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 157
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/ThreadController.php at line 1711
- XF\Pub\Controller\ThreadController->assertViewableThread() in src/XF/Pub/Controller/ThreadController.php at line 60
- XF\Pub\Controller\ThreadController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_permission_combination_PermissionCombination_5`.*, `xf_session_activity_Activity_6`.*
FROM `xf_post`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_5` ON (`xf_permission_combination_PermissionCombination_5`.`permission_combination_id` = `xf_user_User_1`.`permission_combination_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_6` ON (`xf_session_activity_Activity_6`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_6`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
WHERE (`xf_post`.`thread_id` = 42246) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASCRun Time: 0.002697
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_post | ref | thread_id_post_date,thread_id_position,thread_id_score_date | thread_id_post_date | 4 | const | 10 | Using where; Using filesort |
| SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | fpsfo083.xf_post.user_id | 1 | |
| SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | fpsfo083.xf_user_User_1.user_id | 1 | Using where |
| SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | fpsfo083.xf_user_User_1.user_id | 1 | Using where |
| SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | fpsfo083.xf_user_User_1.user_id | 1 | Using where |
| SIMPLE | xf_permission_combination_PermissionCombination_5 | eq_ref | PRIMARY | PRIMARY | 4 | fpsfo083.xf_user_User_1.permission_combination_id | 1 | Using where |
| SIMPLE | xf_session_activity_Activity_6 | eq_ref | PRIMARY | PRIMARY | 22 | fpsfo083.xf_user_User_1.user_id,func | 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 1463
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/ThreadController.php at line 108
- XF\Pub\Controller\ThreadController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT `xf_unfurl_result`.*
FROM `xf_unfurl_result`
WHERE (`xf_unfurl_result`.`result_id` IN (175))
Run Time: 0.000591
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_unfurl_result | 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/Mvc/Entity/Finder.php at line 1463
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/UnfurlRepository.php at line 95
- XF\Repository\UnfurlRepository->addUnfurlsToContent() in src/XF/ControllerPlugin/ThreadPlugin.php at line 64
- XF\ControllerPlugin\ThreadPlugin->fetchExtraContentForPostsFullView() in src/XF/Pub/Controller/ThreadController.php at line 157
- XF\Pub\Controller\ThreadController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
BEGIN
Run Time: 0.000100
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 383
- XF\Db\AbstractAdapter->beginTransaction() in src/XF/Mvc/Entity/Entity.php at line 1299
- XF\Mvc\Entity\Entity->save() in src/XF/Repository/UnfurlRepository.php at line 138
- XF\Repository\UnfurlRepository->recrawlUnfurlsIfNecessary() in src/XF/Repository/UnfurlRepository.php at line 105
- XF\Repository\UnfurlRepository->addUnfurlsToContent() in src/XF/ControllerPlugin/ThreadPlugin.php at line 64
- XF\ControllerPlugin\ThreadPlugin->fetchExtraContentForPostsFullView() in src/XF/Pub/Controller/ThreadController.php at line 157
- XF\Pub\Controller\ThreadController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
UPDATE `xf_unfurl_result` SET `pending` = ? WHERE `result_id` = 175
Params: 1
Run Time: 0.000233
- 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 324
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1583
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1306
- XF\Mvc\Entity\Entity->save() in src/XF/Repository/UnfurlRepository.php at line 138
- XF\Repository\UnfurlRepository->recrawlUnfurlsIfNecessary() in src/XF/Repository/UnfurlRepository.php at line 105
- XF\Repository\UnfurlRepository->addUnfurlsToContent() in src/XF/ControllerPlugin/ThreadPlugin.php at line 64
- XF\ControllerPlugin\ThreadPlugin->fetchExtraContentForPostsFullView() in src/XF/Pub/Controller/ThreadController.php at line 157
- XF\Pub\Controller\ThreadController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
COMMIT
Run Time: 0.000117
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 405
- XF\Db\AbstractAdapter->commit() in src/XF/Mvc/Entity/Entity.php at line 1350
- XF\Mvc\Entity\Entity->save() in src/XF/Repository/UnfurlRepository.php at line 138
- XF\Repository\UnfurlRepository->recrawlUnfurlsIfNecessary() in src/XF/Repository/UnfurlRepository.php at line 105
- XF\Repository\UnfurlRepository->addUnfurlsToContent() in src/XF/ControllerPlugin/ThreadPlugin.php at line 64
- XF\ControllerPlugin\ThreadPlugin->fetchExtraContentForPostsFullView() in src/XF/Pub/Controller/ThreadController.php at line 157
- XF\Pub\Controller\ThreadController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
-- XFDB=noForceAllWrite
INSERT INTO xf_thread_view
(thread_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 42246
Run Time: 0.000211
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/ThreadRepository.php at line 193
- XF\Repository\ThreadRepository->logThreadView() in src/XF/Pub/Controller/ThreadController.php at line 185
- XF\Pub\Controller\ThreadController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, a �
Run Time: 0.000175
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivityRepository.php at line 148
- XF\Repository\SessionActivityRepository->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 110
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 67
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 388
- 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 265
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: a �, XF\Pub\Controller\ThreadController, Index, valid, thread_id=42246, 1771285739, , 0, a �
Run Time: 0.000232
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivityRepository.php at line 241
- XF\Repository\SessionActivityRepository->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 110
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 67
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 388
- 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 265
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('routesApi')Run Time: 0.000109
| 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 172
- 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 2176
- XF\App->XF\{closure}() in src/XF/Container.php at line 38
- XF\Container->offsetGet() in src/XF/App.php at line 623
- XF\App->XF\{closure}() in src/XF/Container.php at line 38
- XF\Container->offsetGet() in src/XF/App.php at line 2973
- XF\App->router() in src/XF/Entity/EmbedResolverTrait.php at line 67
- XF\Entity\Thread->getOembedEndpointUrl() in src/XF/Template/Templater.php at line 1297
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 661
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT `xf_session_activity`.*
FROM `xf_session_activity`
WHERE (`xf_session_activity`.`user_id` = 28098) AND (`xf_session_activity`.`unique_key` = '28098')
LIMIT 1
Run Time: 0.000172
| 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 1435
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 157
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 402
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 425
- 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/XF/Entity/User.php at line 340
- XF\Entity\User->getLastActivity() 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/XF/Entity/User.php at line 551
- XF\Entity\User->canViewOnlineStatus() in src/XF/Entity/User.php at line 271
- XF\Entity\User->isOnline() in src/XF/Template/Templater.php at line 1297
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s1/public/message_macros.php at line 29
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 148
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 193
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 828
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT rating FROM xf_prosport_season_rating WHERE user_id = ?
Params: 28098
Run Time: 0.000068
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_prosport_season_rating | 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/addons/Prosport/Predictions/Listener/TemplaterListener.php at line 47
- Prosport\Predictions\Listener\TemplaterListener::Prosport\Predictions\Listener\{closure}() in src/XF/Template/Templater.php at line 1234
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/message_macros.php at line 55
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 148
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 193
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 828
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT rating FROM xf_prosport_season_rating WHERE user_id = ?
Params: 8162
Run Time: 0.000076
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_prosport_season_rating | 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/addons/Prosport/Predictions/Listener/TemplaterListener.php at line 47
- Prosport\Predictions\Listener\TemplaterListener::Prosport\Predictions\Listener\{closure}() in src/XF/Template/Templater.php at line 1234
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/message_macros.php at line 55
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 148
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 193
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 828
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('permanent_link')Params: 2
Run Time: 0.000686
| 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 400
- 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()
- htmlspecialchars() in src/XF/BbCode/Renderer/Html.php at line 970
- XF\BbCode\Renderer\Html->renderTagHeading() in src/XF/BbCode/Renderer/Html.php at line 357
- XF\BbCode\Renderer\Html->renderTag() in src/XF/BbCode/Traverser.php at line 63
- XF\BbCode\Traverser->renderSubTree() in src/XF/BbCode/Traverser.php at line 39
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 22
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 237
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2683
- XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1234
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 465
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 61
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 95
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 124
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 138
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 150
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 193
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 828
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT rating FROM xf_prosport_season_rating WHERE user_id = ?
Params: 84458
Run Time: 0.000084
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_prosport_season_rating | 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/addons/Prosport/Predictions/Listener/TemplaterListener.php at line 47
- Prosport\Predictions\Listener\TemplaterListener::Prosport\Predictions\Listener\{closure}() in src/XF/Template/Templater.php at line 1234
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/message_macros.php at line 55
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 148
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 193
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 828
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT rating FROM xf_prosport_season_rating WHERE user_id = ?
Params: 5257
Run Time: 0.000077
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_prosport_season_rating | 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/addons/Prosport/Predictions/Listener/TemplaterListener.php at line 47
- Prosport\Predictions\Listener\TemplaterListener::Prosport\Predictions\Listener\{closure}() in src/XF/Template/Templater.php at line 1234
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/message_macros.php at line 55
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 148
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 193
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 828
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT rating FROM xf_prosport_season_rating WHERE user_id = ?
Params: 20545
Run Time: 0.000072
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_prosport_season_rating | 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/addons/Prosport/Predictions/Listener/TemplaterListener.php at line 47
- Prosport\Predictions\Listener\TemplaterListener::Prosport\Predictions\Listener\{closure}() in src/XF/Template/Templater.php at line 1234
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/message_macros.php at line 55
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 148
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 193
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 828
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT rating FROM xf_prosport_season_rating WHERE user_id = ?
Params: 63
Run Time: 0.000102
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_prosport_season_rating | 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/addons/Prosport/Predictions/Listener/TemplaterListener.php at line 47
- Prosport\Predictions\Listener\TemplaterListener::Prosport\Predictions\Listener\{closure}() in src/XF/Template/Templater.php at line 1234
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/message_macros.php at line 55
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 148
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 193
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 828
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT rating FROM xf_prosport_season_rating WHERE user_id = ?
Params: 18768
Run Time: 0.000074
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_prosport_season_rating | 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/addons/Prosport/Predictions/Listener/TemplaterListener.php at line 47
- Prosport\Predictions\Listener\TemplaterListener::Prosport\Predictions\Listener\{closure}() in src/XF/Template/Templater.php at line 1234
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/message_macros.php at line 55
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 148
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 193
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 828
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT rating FROM xf_prosport_season_rating WHERE user_id = ?
Params: 11242
Run Time: 0.000076
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_prosport_season_rating | 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/addons/Prosport/Predictions/Listener/TemplaterListener.php at line 47
- Prosport\Predictions\Listener\TemplaterListener::Prosport\Predictions\Listener\{closure}() in src/XF/Template/Templater.php at line 1234
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/message_macros.php at line 55
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 148
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 193
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 828
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
SELECT rating FROM xf_prosport_season_rating WHERE user_id = ?
Params: 15811
Run Time: 0.000078
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_prosport_season_rating | 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/addons/Prosport/Predictions/Listener/TemplaterListener.php at line 47
- Prosport\Predictions\Listener\TemplaterListener::Prosport\Predictions\Listener\{closure}() in src/XF/Template/Templater.php at line 1234
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/message_macros.php at line 55
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 148
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1103
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1038
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 193
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 930
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 828
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1815
- 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 2824
- XF\App->run() in src/XF.php at line 814
- XF::runApp() in index.php at line 23
| bytes_sent | 11876 |
| bytes_received | 280466 |
| packets_sent | 242 |
| packets_received | 1251 |
| protocol_overhead_in | 5004 |
| protocol_overhead_out | 968 |
| bytes_received_ok_packet | 0 |
| bytes_received_eof_packet | 0 |
| bytes_received_rset_header_packet | 891 |
| bytes_received_rset_field_meta_packet | 0 |
| bytes_received_rset_row_packet | 339 |
| bytes_received_prepare_response_packet | 59123 |
| bytes_received_change_user_packet | 219188 |
| packets_sent_command | 120 |
| packets_received_ok | 0 |
| packets_received_eof | 0 |
| packets_received_rset_header | 99 |
| packets_received_rset_field_meta | 0 |
| packets_received_rset_row | 43 |
| packets_received_prepare_response | 939 |
| packets_received_change_user | 129 |
| result_set_queries | 36 |
| non_result_set_queries | 7 |
| no_index_used | 1 |
| bad_index_used | 0 |
| slow_queries | 0 |
| buffered_sets | 0 |
| unbuffered_sets | 0 |
| ps_buffered_sets | 36 |
| ps_unbuffered_sets | 0 |
| flushed_normal_sets | 0 |
| flushed_ps_sets | 0 |
| ps_prepared_never_executed | 0 |
| ps_prepared_once_executed | 38 |
| rows_fetched_from_server_normal | 0 |
| rows_fetched_from_server_ps | 93 |
| rows_buffered_from_client_normal | 0 |
| rows_buffered_from_client_ps | 93 |
| 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 | 35 |
| 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 | 122 |
| proto_binary_fetched_tinyint | 0 |
| proto_binary_fetched_short | 210 |
| proto_binary_fetched_int24 | 77 |
| proto_binary_fetched_int | 0 |
| proto_binary_fetched_bigint | 475 |
| proto_binary_fetched_decimal | 28 |
| 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 | 523 |
| proto_binary_fetched_blob | 220 |
| 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 | 4 |
| 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 | 39 |
| com_stmt_execute | 39 |
| com_stmt_send_long_data | 0 |
| com_stmt_close | 38 |
| 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 | 217468 |