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.002199
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.000200
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 36
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 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 261
- 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_tag`.*
FROM `xf_tag`
WHERE (`xf_tag`.`tag_url` = 'officiating')
LIMIT 1
Run Time: 0.000341
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | const | tag_url | tag_url | 302 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/Tag.php at line 115
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- 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_tag_result_cache`.*
FROM `xf_tag_result_cache`
WHERE (`xf_tag_result_cache`.`tag_id` = 648 AND `xf_tag_result_cache`.`user_id` = 0)
LIMIT 1
Run Time: 0.000226
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag_result_cache | const | tag_id_user_id | tag_id_user_id | 8 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Repository/Tag.php at line 695
- XF\Repository\Tag->getTagResultCache() in src/XF/Pub/Controller/Tag.php at line 131
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- 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 content_type, content_id
FROM xf_tag_content
WHERE tag_id = ?
AND visible = 1
ORDER BY content_date DESC
LIMIT 200
Params: 648
Run Time: 0.002607
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag_content | ref | tag_id_content_date | tag_id_content_date | 4 | const | 84 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Tag.php at line 667
- XF\Repository\Tag->getTagSearchResults() in src/XF/Pub/Controller/Tag.php at line 135
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- 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_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (1154213, 1154002, 1153525, 1153422, 1153398, 1153393, 1153337, 1153210, 1146951, 1146765, 1146596, 1146588, 1146504, 1146411, 1146408, 1146229, 1146153, 1146150, 1145860, 1145843, 1145812, 1145713, 1142890, 1142701, 1142625, 1142524, 1142516, 1142451, 1142432, 1142411, 1142387, 1142386, 1142361, 1142339, 1142196, 1142188, 1142166, 1142152, 1141902, 1141859, 1141854, 1141834, 1141818, 1141625, 1141543, 1141509, 1141440, 1141435, 1141429, 1141425, 1141421, 1141323, 1141280, 1141223, 1141185, 1141002, 1140934, 1140859, 1140855, 1140854, 1140467, 1139742, 1139416, 1139186, 1139175, 1137000, 1136087, 1134756, 1134470, 1134394, 1134389, 1134361, 1134098, 1133949, 1133926, 1133917, 1133912, 1133627, 1133442, 1133131, 1132326, 1131263, 1131126, 1127659, 1115919))
Run Time: 0.007887
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 85 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,xpf_board.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2673
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- 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
BEGIN
Run Time: 0.002047
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 381
- XF\Db\AbstractAdapter->beginTransaction() in src/XF/Mvc/Entity/Entity.php at line 1235
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- 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
UPDATE `xf_tag_result_cache` SET `expiry_date` = ? WHERE `result_cache_id` = 38311
Params: 1611153980
Run Time: 0.000310
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 326
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1515
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- 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
COMMIT
Run Time: 0.000402
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 403
- XF\Db\AbstractAdapter->commit() in src/XF/Mvc/Entity/Entity.php at line 1286
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- 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\Tag, Tag, valid, tag_url=officiating, 1611150380,
Run Time: 0.000316
- 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 261
- 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(*) 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.000323
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 63
- PF2020\User->pfWeek() 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 8
- 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.000181
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 73
- PF2020\User->pfYear() 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 8
- 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.000233
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 8
- 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.000161
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 8
- 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.000213
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 8
- 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.000224
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 8
- 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.000185
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 11
- 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.000167
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 11
- 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.000212
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 11
- 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 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 11
- 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.000178
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 11
- 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.000247
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 11
- 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.000208
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 11
- 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.000176
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.000195
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 | 26607 |
bytes_received | 681736 |
packets_sent | 272 |
packets_received | 1533 |
protocol_overhead_in | 6132 |
protocol_overhead_out | 1088 |
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 | 317 |
bytes_received_prepare_response_packet | 74695 |
bytes_received_change_user_packet | 604822 |
packets_sent_command | 135 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 99 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 48 |
packets_received_prepare_response | 1046 |
packets_received_change_user | 294 |
result_set_queries | 42 |
non_result_set_queries | 6 |
no_index_used | 0 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 42 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 43 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 252 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 252 |
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 | 252 |
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 | 824 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 1616 |
proto_binary_fetched_int24 | 680 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 6341 |
proto_binary_fetched_decimal | 53 |
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 | 2797 |
proto_binary_fetched_blob | 1523 |
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 | 44 |
com_stmt_execute | 44 |
com_stmt_send_long_data | 0 |
com_stmt_close | 43 |
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 | 596625 |