SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Run Time: 0.002615
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 38 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/App.php at line 1862
- XF\App->preLoadData() in src/XF/App.php at line 1850
- XF\App->setup() in src/XF/Pub/App.php at line 91
- XF\Pub\App->setup() in src/XF.php at line 438
- XF::setupApp() in src/XF.php at line 461
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000239
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1162
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 242
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 123
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 349
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_profile_Profile_3`.*
FROM `xf_user`
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` = '15168')
LIMIT 1
Run Time: 0.000695
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_option_Option_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_profile_Profile_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Member.php at line 1209
- XF\Pub\Controller\Member->assertViewableUser() in src/XF/Pub/Controller/Member.php at line 330
- XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT `xf_user_follow`.*, `xf_user_FollowUser_1`.*, `xf_user_profile_Profile_2`.*, `xf_user_option_Option_3`.*
FROM `xf_user_follow`
INNER JOIN `xf_user` AS `xf_user_FollowUser_1` ON (`xf_user_FollowUser_1`.`user_id` = `xf_user_follow`.`follow_user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_FollowUser_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_FollowUser_1`.`user_id`)
WHERE (`xf_user_FollowUser_1`.`is_banned` = 0) AND (`xf_user_FollowUser_1`.`user_state` = 'valid') AND (`xf_user_follow`.`user_id` = 15168)
ORDER BY RAND() ASC
LIMIT 12
Run Time: 0.001229
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_follow | ref | PRIMARY,follow_user_id | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_user_follow.follow_user_id | 1 | |
SIMPLE | xf_user_FollowUser_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | xpf_board.xf_user_follow.follow_user_id | 1 | Using where |
SIMPLE | xf_user_option_Option_3 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_user_follow.follow_user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 342
- XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `xf_user_follow`
INNER JOIN `xf_user` AS `xf_user_FollowUser_1` ON (`xf_user_FollowUser_1`.`user_id` = `xf_user_follow`.`follow_user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_FollowUser_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_FollowUser_1`.`user_id`)
WHERE (`xf_user_FollowUser_1`.`is_banned` = 0) AND (`xf_user_FollowUser_1`.`user_state` = 'valid') AND (`xf_user_follow`.`user_id` = 15168)
Run Time: 0.000314
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_follow | ref | PRIMARY,follow_user_id | PRIMARY | 4 | const | 1 | Using index |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_user_follow.follow_user_id | 1 | Using index |
SIMPLE | xf_user_FollowUser_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | xpf_board.xf_user_follow.follow_user_id | 1 | Using where |
SIMPLE | xf_user_option_Option_3 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_user_follow.follow_user_id | 1 | Using index |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1334
- XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/Member.php at line 343
- XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT `xf_user_follow`.*, `xf_user_User_1`.*, `xf_user_profile_Profile_2`.*, `xf_user_option_Option_3`.*
FROM `xf_user_follow`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_follow`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_User_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_User_1`.`user_id`)
WHERE (`xf_user_User_1`.`is_banned` = 0) AND (`xf_user_User_1`.`user_state` = 'valid') AND (`xf_user_follow`.`follow_user_id` = 15168)
ORDER BY RAND() ASC
LIMIT 12
Run Time: 0.000968
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_follow | ref | PRIMARY,follow_user_id | follow_user_id | 4 | const | 1 | Using temporary; Using filesort |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_user_follow.user_id | 1 | |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | xpf_board.xf_user_follow.user_id | 1 | Using where |
SIMPLE | xf_user_option_Option_3 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_user_follow.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 349
- XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `xf_user_follow`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_follow`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_User_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_User_1`.`user_id`)
WHERE (`xf_user_User_1`.`is_banned` = 0) AND (`xf_user_User_1`.`user_state` = 'valid') AND (`xf_user_follow`.`follow_user_id` = 15168)
Run Time: 0.000231
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_follow | ref | PRIMARY,follow_user_id | follow_user_id | 4 | const | 1 | Using index |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_user_follow.user_id | 1 | Using index |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | xpf_board.xf_user_follow.user_id | 1 | Using where |
SIMPLE | xf_user_option_Option_3 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_user_follow.user_id | 1 | Using index |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1334
- XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/Member.php at line 350
- XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT `xf_user_trophy`.*, `xf_trophy_Trophy_1`.*
FROM `xf_user_trophy`
LEFT JOIN `xf_trophy` AS `xf_trophy_Trophy_1` ON (`xf_trophy_Trophy_1`.`trophy_id` = `xf_user_trophy`.`trophy_id`)
WHERE (`xf_user_trophy`.`user_id` = 15168)
ORDER BY `xf_user_trophy`.`award_date` DESC
Run Time: 0.000247
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_trophy | ref | user_id_award_date | user_id_award_date | 4 | const | 9 | Using where; Using index |
SIMPLE | xf_trophy_Trophy_1 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_user_trophy.trophy_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 358
- XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XF\Pub\Controller\Member, About, valid, user_id=15168, 1618753866,
Run Time: 0.000166
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 42
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 287
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 2
Run Time: 0.000246
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1162
- XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 942
- XF\Entity\User->canReceiveConversation() in src/XF/Entity/User.php at line 922
- XF\Entity\User->canStartConversationWith()
- call_user_func_array() in src/XF/Template/Templater.php at line 1166
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s34/public/member_about.php at line 118
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000190
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 83
- PF2020\User->pfHeader() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000230
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 93
- PF2020\User->pfTwitter() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000207
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 103
- PF2020\User->pfNewsFeed() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000252
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 113
- PF2020\User->pfSidebar() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000211
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 123
- PF2020\User->pfSocial() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000194
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 133
- PF2020\User->pfNotifications() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000210
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 153
- PF2020\User->pfPicks() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000169
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 163
- PF2020\User->pfAlerts() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000177
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 173
- PF2020\User->pfSnooze() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000177
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 183
- PF2020\User->pfSnoozeTime() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000179
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 193
- PF2020\User->pfLinkLastViewed() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 115
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 10
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as count, xf_user_pref_default.week, xf_user_pref_default.year, xf_user_preferences.user_id, xf_user_preferences.header, xf_user_preferences.twitter, xf_user_preferences.newsfeed, xf_user_preferences.sidebar, xf_user_preferences.social, xf_user_preferences.notifications, xf_user_preferences.pinned, xf_user_preferences.picks, xf_user_preferences.alert, xf_user_preferences.snooze, xf_user_preferences.snooze_time, xf_user_preferences.link_last_viewed FROM xf_user_preferences
LEFT JOIN xf_user_pref_default ON xf_user_preferences.oid = xf_user_pref_default.pid
WHERE user_id = ?
Params: 0
Run Time: 0.000242
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 32
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 143
- PF2020\User->pfPinned() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/addons/PF2020/Files/chatter.php at line 99
- PF2020\Files\chatter::getChatter()
- call_user_func() in src/XF/Template/Templater.php at line 1653
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s34/public/pf_2020_sidebar.php at line 23
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 640
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
SELECT count(*) as res FROM pf_pinned
WHERE pf_pinned.user_id = ?
Params: 0
Run Time: 0.000194
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | pf_pinned | ref | user_id | user_id | 4 | const | 1 | Using index |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/Files/chatter.php at line 208
- PF2020\Files\chatter::getChatter()
- call_user_func() in src/XF/Template/Templater.php at line 1653
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s34/public/pf_2020_sidebar.php at line 23
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1638
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 640
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1609
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2105
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 465
- XF::runApp() in index.php at line 20
bytes_sent | 26754 |
bytes_received | 350259 |
packets_sent | 274 |
packets_received | 1543 |
protocol_overhead_in | 6172 |
protocol_overhead_out | 1096 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 873 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 253 |
bytes_received_prepare_response_packet | 90831 |
bytes_received_change_user_packet | 257265 |
packets_sent_command | 136 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 97 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 47 |
packets_received_prepare_response | 1203 |
packets_received_change_user | 149 |
result_set_queries | 44 |
non_result_set_queries | 3 |
no_index_used | 0 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 44 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 44 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 105 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 105 |
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 | 105 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_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 | 282 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 54 |
proto_binary_fetched_int24 | 18 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 150 |
proto_binary_fetched_decimal | 79 |
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 | 313 |
proto_binary_fetched_blob | 78 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 45 |
com_stmt_execute | 45 |
com_stmt_send_long_data | 0 |
com_stmt_close | 44 |
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 | 255923 |