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', 'paymentProvider', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Run Time: 0.002742
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 39 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 139
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/App.php at line 2036
- XF\App->preLoadData() in src/XF/App.php at line 2024
- XF\App->setup() in src/XF/Pub/App.php at line 94
- XF\Pub\App->setup() in src/XF.php at line 497
- XF::setupApp() in src/XF.php at line 520
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000181
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1218
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 244
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 22
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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` = '22953')
LIMIT 1
Run Time: 0.000549
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1397
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Member.php at line 1238
- XF\Pub\Controller\Member->assertViewableUser() in src/XF/Pub/Controller/Member.php at line 671
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
Run Time: 0.002083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | | | | | 108 | |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_forum.node_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,xpf_board.xf_node_Node_1.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Search/Data/Post.php at line 259
- XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 239
- XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 212
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_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_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (3582964, 3365981, 3342084, 3340477, 3336732, 3312720, 3300433, 3295404, 3295391, 3285639, 3269261, 3268924, 3267842, 3262315, 3260351, 3259178, 3259146, 3258868, 3256968, 3256831, 3256681, 3256637, 3256418, 3256221, 3256107, 3255551, 3255517, 3255085, 3255083, 3255082, 3255081, 3255069, 3255060, 3255042, 3255029, 3255026, 3255021, 3254981, 3254842, 3254837, 3254753, 3254665, 3254663, 3254647, 3254624, 3254617, 3254465, 3254364, 3254096, 3253988, 3248201, 3247984, 3238596, 3236760, 3236336, 3233205, 3230753, 3230728, 3225179, 3223346, 3222815, 3222754, 3220725, 3220091, 3219631, 3218210, 3218209, 3217955, 3216838, 3216283, 3214057, 3213725, 3211066, 3210410, 3210228, 3207399, 3206504, 3206454, 3206282, 3206243, 3206095, 3205947, 3204949, 3204897, 3204867, 3204229, 3204055, 3203906, 3200222, 3200096, 3200094, 3198586, 3198502, 3195540, 3195083, 3191358, 3191219, 3191217, 3191206, 3190819, 3190764, 3190075, 3188656, 3187189, 3187012, 3186993, 3184686, 3184543, 3184346, 3183933, 3183876, 3183874, 3183414, 3183413, 3183411, 3183409, 3183403, 3182118, 3181731, 3181583, 3180348, 3180347, 3178763, 3178727, 3177257, 3177175, 3177059, 3176902, 3176725, 3176683, 3176426, 3176081, 3175761, 3174097, 3173495, 3173488, 3172784, 3172708, 3172698, 3170846, 3170269, 3170187, 3169315, 3167936, 3167927, 3167663, 3167175, 3167170, 3167165, 3167127, 3167121, 3166487, 3165270, 3165209, 3165205, 3165199, 3165197, 3164405, 3161662, 3161423, 3161414, 3161291, 3160022, 3159419, 3159192, 3157511, 3156693, 3156655, 3156652, 3156650, 3155714, 3155104, 3152034, 3152026, 3151722, 3151025, 3150485, 3147462, 3147451, 3147450, 3147449, 3147389, 3147384, 3144448, 3142794, 3142793, 3142718, 3142687, 3142684, 3142672, 3142054, 3141994))
Run Time: 0.008110
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 192 | Using where |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_post.thread_id | 1 | |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_thread_Thread_1.node_id | 1 | Using where |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_post.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,xpf_board.xf_node_Node_3.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_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_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_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 (999864, 971075, 960640, 957753, 958314, 954707, 949025, 944171))
Run Time: 0.000957
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 8 | 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_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_thread.user_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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_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_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (3582964, 3365981, 3342084, 3340477, 3336732, 3312720, 3300433, 3295404, 3295391, 3285639, 3269261, 3268924, 3267842, 3262315, 3260351, 3259178, 3259146, 3258868, 3256968, 3256831, 3256681, 3256637, 3256418, 3256221, 3256107, 3255551, 3255517, 3255085, 3255083, 3255082, 3255081, 3255069, 3255060, 3255042, 3255029, 3255026, 3255021, 3254981, 3254842, 3254837, 3254753, 3254665, 3254663, 3254647, 3254624, 3254617, 3254465, 3254364, 3254096, 3253988, 3248201, 3247984, 3238596, 3236760, 3236336, 3233205, 3230753, 3230728, 3225179, 3223346, 3222815, 3222754, 3220725, 3220091, 3219631, 3218210, 3218209, 3217955, 3216838, 3216283, 3214057, 3213725, 3211066, 3210410, 3210228, 3207399, 3206504, 3206454, 3206282, 3206243, 3206095, 3205947, 3204949, 3204897, 3204867, 3204229, 3204055, 3203906, 3200222, 3200096, 3200094, 3198586, 3198502, 3195540, 3195083, 3191358, 3191219, 3191217, 3191206, 3190819, 3190764, 3190075, 3188656, 3187189, 3187012, 3186993, 3184686, 3184543, 3184346, 3183933, 3183876, 3183874, 3183414, 3183413, 3183411, 3183409, 3183403, 3182118, 3181731, 3181583, 3180348, 3180347, 3178763, 3178727, 3177257, 3177175, 3177059, 3176902, 3176725, 3176683, 3176426, 3176081, 3175761, 3174097, 3173495, 3173488, 3172784, 3172708, 3172698, 3170846, 3170269, 3170187, 3169315, 3167936, 3167927, 3167663, 3167175, 3167170, 3167165, 3167127, 3167121, 3166487, 3165270, 3165209, 3165205, 3165199, 3165197, 3164405, 3161662, 3161423, 3161414, 3161291, 3160022, 3159419, 3159192, 3157511, 3156693, 3156655, 3156652, 3156650, 3155714, 3155104, 3152034, 3152026, 3151722, 3151025, 3150485, 3147462, 3147451, 3147450, 3147449, 3147389, 3147384, 3144448, 3142794, 3142793, 3142718, 3142687, 3142684, 3142672, 3142054, 3141994))
Run Time: 0.004580
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 192 | Using where |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_post.thread_id | 1 | |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_thread_Thread_1.node_id | 1 | Using where |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_post.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,xpf_board.xf_node_Node_3.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_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_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_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 (999864, 971075, 960640, 957753, 958314, 954707, 949025, 944171))
Run Time: 0.000764
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 8 | 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_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | xpf_board.xf_thread.user_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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0,
Run Time: 0.000155
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 134
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: , XF\Pub\Controller\Member, RecentContent, valid, user_id=22953, 1675725412, , 0,
Run Time: 0.000175
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 227
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000139
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 252
- PF2020\User->pfSuspended() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 291
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000200
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 262
- PF2020\User->pfSuspensionEndDate() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 291
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000135
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 102
- PF2020\User->pfWarnings() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 438
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 92
- PF2020\User->pfWeek() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_picks_top_alert.php at line 9
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000152
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 112
- PF2020\User->pfYear() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_picks_top_alert.php at line 9
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000276
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 192
- PF2020\User->pfPicks() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_picks_top_alert.php at line 9
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000139
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 222
- PF2020\User->pfSnooze() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_picks_top_alert.php at line 9
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000165
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 232
- PF2020\User->pfSnoozeTime() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_picks_top_alert.php at line 9
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000146
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 212
- PF2020\User->pfAlerts() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s34/public/pf_2020_picks_top_alert.php at line 9
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/pf_2020_header_new.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000163
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 122
- PF2020\User->pfHeader() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- 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 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000146
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 132
- PF2020\User->pfTwitter() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- 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 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000155
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 142
- PF2020\User->pfNewsFeed() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- 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 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000146
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 152
- PF2020\User->pfSidebar() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- 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 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 162
- PF2020\User->pfSocial() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- 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 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 172
- PF2020\User->pfNotifications() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- 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 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 202
- PF2020\User->pfLinks() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- 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 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000146
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 242
- PF2020\User->pfLinkLastViewed() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- 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 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 439
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.links,
xf_user_preferences.alert,
xf_user_preferences.snooze,
xf_user_preferences.snooze_time,
xf_user_preferences.link_last_viewed,
xf_user_preferences.blocked_from_users,
xf_user_preferences.suspended,
xf_user_preferences.suspension_end_date,
xf_user_pref_default.featured_posts,
xf_user_pref_default.featured_users,
xf_user_preferences.warnings
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.000221
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/User.php at line 61
- PF2020\XFpref->__construct() in src/addons/PF2020/User.php at line 182
- PF2020\User->pfPinned() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 119
- XF\Mvc\Entity\Entity->__get() in src/addons/PF2020/Files/chatter.php at line 99
- PF2020\Files\chatter::getChatter() in src/XF/Template/Templater.php at line 1696
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s34/public/pf_2020_sidebar.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 675
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- 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.000138
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/addons/PF2020/Files/chatter.php at line 208
- PF2020\Files\chatter::getChatter() in src/XF/Template/Templater.php at line 1696
- XF\Template\Templater->callback() in internal_data/code_cache/templates/l1/s34/public/pf_2020_sidebar.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1681
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s34/public/PAGE_CONTAINER.php at line 675
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2281
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20