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.001004
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 136
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/App.php at line 2040
- XF\App->preLoadData() in src/XF/App.php at line 2028
- 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.000213
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 1219
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 245
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
- 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 258
- 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 2487
- 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` = '1556')
LIMIT 1
Run Time: 0.000558
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 1395
- 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 258
- 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 2487
- 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.001861
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | | | | | 149 | |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum.node_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.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 1428
- 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 180
- 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 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT search_index.content_type, search_index.content_id
FROM xf_search_index AS search_index
WHERE MATCH(search_index.title, search_index.metadata) AGAINST ('-_md_node_27 -_md_node_28 -_md_node_29 -_md_node_49 -_md_node_50 -_md_node_92 -_md_node_94 -_md_node_104 -_md_node_160 -_md_hidden_1 +_md_user_1556' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.068210
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | search_index | fulltext | title_metadata | title_metadata | 0 | | 1 | Using where; Using filesort |
- 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 162
- XF\Db\AbstractAdapter->fetchAllNum() in src/XF/Search/Source/MySqlFt.php at line 286
- XF\Search\Source\MySqlFt->search() in src/XF/Search/Search.php at line 185
- XF\Search\Search->XF\Search\{closure}() in src/XF/Search/Search.php at line 214
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 180
- 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 258
- 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 2487
- 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 (26230, 26212, 25819, 25770, 25703, 25671, 25587, 25573, 25546, 25394, 25385, 25384, 25380, 25337, 25319, 25311, 25310, 25254, 25250, 25249, 25248, 25051, 24979, 24226, 23910, 23170, 23067, 22884, 22764, 22470, 22463, 22348, 22302, 22229, 22191, 22115, 22111, 22072, 22045, 21852, 21814, 21812, 21626, 20924, 19651, 19644, 19642, 19628, 19615, 19611, 19605, 19562, 19509, 19347, 19225, 19224, 19223, 19210, 19183, 19180, 19177, 19143, 19136, 19024, 18994, 18741, 18734, 18705, 18700, 18697, 18694, 18693, 18668, 18666, 18657, 18648, 18647, 18646, 18594, 18593, 18591, 18583, 18580, 18548, 18546, 18539, 18317, 18138, 18089, 18028, 17984, 17980, 17810, 17218, 17217, 17197, 17192, 17148, 16340, 15596, 14738, 14644, 14540, 14443, 14442, 14428, 14424, 14416, 14414, 14412, 14400, 14398, 14389, 14386, 14374, 14373, 14371, 14370, 14308, 14281, 14225, 14113, 13835, 13779, 13771, 13764, 13757, 13756, 13743, 13737, 13663, 13659, 13655, 13654, 13653, 13647, 13614, 13608, 13593, 13436, 12695, 12361, 12226, 12210, 11900, 10915, 9746, 8502, 8294, 8275, 8232, 8208, 8203, 7242, 6961, 6531, 6525, 6470, 6469, 6374))
Run Time: 0.012616
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 160 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.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 1428
- 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 2870
- 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 180
- 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 258
- 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 2487
- 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 (511499, 372837, 503963, 372836, 372835, 372834, 455767, 467198, 372833, 372832, 450511, 450509, 503738, 372831, 382350, 502386, 503368, 503635, 503959, 503428, 503957, 502347, 503372, 503337, 497925, 497921, 497919, 500047, 498692, 500224, 499902, 382884, 499504, 253810, 382446, 382348, 483598, 422307, 494411, 495568, 494557, 494524, 495638, 497735, 497850, 498667, 497853, 497914, 452469, 419483, 489913, 491407, 491780, 491984, 492743, 492751, 492764, 492784, 493016, 489502, 493819, 493823, 492209, 491564, 401633, 382444, 465914, 378507, 488192, 479607, 379162, 487793, 487787, 488293, 487102, 487025, 481902, 487941, 253808, 353253, 487050, 487044, 483596, 479604, 483594, 483592, 456282, 468103, 462137, 470081, 470225, 470887, 471727, 471983, 472728, 475226, 475340, 476584, 477990, 484031, 484456, 217604, 484687, 484732, 484991, 485007, 485054, 486337, 467543, 466970, 465995, 480913, 481869, 482638, 481995, 482763, 482887, 483047, 483189, 483730, 483223, 480279, 480092, 480023, 466881, 479601, 379160, 253807, 253806, 253805, 253803, 372829, 422809, 382346, 479380, 172934, 462352, 386660, 419480, 386658, 382442, 386654, 382345, 353251, 390235, 386651, 466464, 253802, 379158, 353249, 465749, 466457, 460531, 253798, 253797, 253796, 253795, 253794, 253793, 253792, 253791, 253790, 253789, 253788, 253787, 253786, 253785, 253784, 253783, 253782, 253781, 253779, 253778, 370573, 253777, 253776, 253775, 253774, 370572, 465817, 465562, 462349, 464590, 452465, 456678, 463027, 464356, 465409, 465560, 382437, 370571, 390218, 382343, 419477, 463037, 452463, 382435, 458463, 382433, 390216, 459286, 460394, 456929, 456806, 459284, 459562, 459897, 460259, 460536, 459282, 459121, 307823, 458461, 382341, 458185, 455119, 456997, 457233, 457787, 455117, 455115, 455113, 422806, 453223, 456877, 382338, 117679, 456147, 382336, 453037, 456145, 455941, 451497, 455752, 451495, 381959, 455178, 455130, 347212, 454434, 455109, 451182, 454219, 454221, 454252, 454264, 454384, 454483, 454012, 451960, 382430, 452459, 452740, 423512, 450981, 450978, 451493, 450976, 451491, 382334, 450974, 260602, 422804, 447934, 422689, 449285, 449712, 382424, 449283, 390214, 382332, 422594, 422685, 390212, 423509, 422591, 423507, 419476, 417522, 409457, 382422, 253759, 422802, 253757, 422304, 409452, 260590, 253755, 382420, 253753, 422580, 422302, 253750, 36958, 253748, 260587, 253746, 382418, 415322, 253744, 382416, 253742, 382414, 253735, 253734, 419909, 253733, 401624, 382412, 370054, 419474, 419472, 419470, 364624, 373597, 372828, 373595, 373592, 382880, 400361, 390228, 385456, 390307, 382879, 382399, 260573, 391929, 390304, 391563, 391926, 386644, 390298, 389495, 382396, 382394, 382392, 253725, 389483, 253722, 253719, 382389, 389480, 389838, 389478, 389364, 389836, 370049, 384387, 370047, 388386, 388383, 387507, 388380, 385523, 376661, 385452, 386585, 387477, 253717, 382897, 370710, 386257, 301866, 387196, 354139, 387194, 387192, 387189, 253716, 385446, 370788, 384764, 370705, 384762, 382324, 384760, 384671, 253714, 379327, 384669, 384381, 253713, 382384, 382381, 382893, 382378, 384071, 384049, 383625, 253711, 382373, 382595, 381891, 382890, 382371, 379155, 302351, 382369, 302349, 382888, 382834, 382480, 383182, 373980, 381946, 302347, 253709, 382765, 382478, 382366, 382476, 381626, 381889, 253707, 379322, 381433, 143254, 381425, 375781, 374664, 381885, 253701, 381895, 381423, 378616, 381421, 359602, 379600, 371351, 379300, 379321, 304040, 378568, 359598, 378566, 378612, 378595, 378956, 378593, 378733, 378610, 378608, 374363, 377666, 375395, 377364, 368868, 370367, 371390, 304037, 364579, 370281, 375485, 371380, 371349, 287702, 373483, 260561, 373481, 372924, 370765, 370868, 373479, 287700, 366279, 373477, 366277, 366275, 287698, 373407, 368855, 290134, 373405, 372879, 371347, 372425, 372897, 371266, 370329, 371378, 371265, 372858, 370758, 302333, 253695, 344638, 371263, 370912, 371233, 370752, 370865, 370750, 366273, 370533, 370747, 370745, 370739, 370858, 370856, 370691, 370314, 370309, 366663, 370307, 370188, 290131, 369784, 367942, 361132, 367937, 363196, 367914, 363191, 361718, 366565, 366269, 364833, 364878, 365911, 359410, 364599, 362894, 361129, 360900, 360898, 361127, 360896, 361125, 360894, 360887, 360978, 360393, 359659, 359655, 359653, 359649, 359409, 352616, 340442, 340434, 358063, 353921, 303545, 340426, 340424, 340422, 357170, 353989, 351435, 352613, 297007, 311198, 297005, 311196, 352536, 354280, 355158, 356901, 351432, 351430, 349246, 338876, 340412, 351781, 351495, 346955, 351657, 351415, 346942, 347359, 347163, 346936, 348387, 348523, 345031, 253669, 346570, 346501, 344346, 346497, 344344, 334902, 345020, 253664, 344342, 345891, 335049, 345821, 313810, 267384, 344633, 344312, 316876, 338611, 344627, 339411, 334899, 331894, 340343, 334896, 340318, 339889, 341639, 287697, 339354, 339351, 339340, 338871, 339330, 339327, 339323, 332307, 330588, 253624, 253622, 331967, 327558, 328568, 328263, 331938, 319166, 330581, 330579, 329417, 300707, 313732, 329137, 208085, 305503, 303938, 202303, 301386, 304174, 301370, 202295, 303926, 8052, 301569, 302950, 296999, 288115, 288480, 287437, 300871, 301549, 287435, 301076, 300861, 301072, 300629, 284377, 287753, 298905, 300528, 300521, 284373, 264643, 288112, 264639, 296991, 298225, 298222, 287493, 297421, 287686, 295430, 293737, 297703, 295809, 297609, 296988, 265121, 297412, 297492, 297524, 291392, 287489, 117591, 296443, 296985, 297408, 297037, 297034, 264759, 295423, 297032, 296983, 297023, 297026, 297020, 258234, 291647, 264566, 264563, 296130, 264561, 287623, 288483, 288485, 291390, 291972, 295447, 295925, 296124, 296453, 295338, 296128, 295791, 291004, 291700, 264559, 264557, 264755, 295418, 296126, 288475, 264753, 250962, 264751, 296294, 287486, 296138, 287510, 295416, 288662, 295520, 264749, 291645, 291643, 284648, 264747, 287484, 296134, 204302, 287684, 295609, 287508, 117588, 295802, 293731, 284564, 287751, 295122, 253620, 288104, 264744, 295410, 295007, 288133, 287190, 295108, 295407, 294900, 253614, 293831, 287482, 287735, 253608, 264733, 287472, 287470, 287468, 204299, 264350, 288715, 288713, 183928, 204297, 287727, 288652, 287725, 288473, 264345, 253606, 288649, 85311, 288291, 194437, 264343, 287723, 288471, 288309, 264341, 287433, 285946, 288288, 288286, 288285, 288304, 266484, 288301, 288299, 288297, 183927, 288099, 288295, 287431, 260555, 287719, 287628, 287627, 287718, 287430, 264731, 287625, 288097, 287715, 288127, 183925, 287712, 287504, 277790, 287804, 269619, 270714, 287682, 287802, 287681, 287709, 260552, 286590, 287799, 279135, 287679, 287466, 287464, 253602, 287659, 279605, 264337, 287611, 152336, 284562, 287501, 286587, 277789, 287328, 287428, 287499, 287537, 253598, 287498, 287462, 287180, 282818, 287178, 287460, 287208, 277787, 260550, 253594, 287457, 287423, 264332, 264728, 264726, 270711, 282676, 260547, 285863, 270709, 264330, 283134, 284644, 266726, 283762, 278289, 278287, 278284, 284866, 284864, 284874, 261887, 269618, 265117, 259845, 282816, 283132, 278279, 278277, 282811, 278275, 278273, 277759, 279976, 268745, 282807, 282647, 269614, 269612, 277753, 183913, 276516, 277751, 279666, 250613, 279687, 279132, 250611, 278270, 279130, 250609, 204296, 278268, 278266, 276514, 279434, 277745, 278337, 277701, 270706, 266365, 277699, 265115, 277731, 277689, 278199, 277681, 265053, 272876, 273087, 273559, 267602, 271355, 269388, 271314, 265050, 83477, 260546, 270950, 270702, 271274, 270734, 271212, 270952, 267153, 270493, 204294, 204292, 250958, 269609, 269723, 270044, 269891, 269967, 264625, 270047, 267546, 269713, 269703, 267951, 269583, 263932, 267533, 267530, 266480, 265570, 264536, 267515, 258760, 267148, 267512, 264620, 267948, 268008, 260544, 203822, 264554, 262218, 269543, 261563, 264326, 267510, 269381, 203820, 269378, 269375, 265112, 268744, 204290, 203818, 268005, 267946, 268003, 268000, 268480, 267489, 160154, 160152, 267479, 268478, 268743, 267474, 268741, 268739, 267471, 268736, 267286, 267469, 267462, 268732, 268730, 208052, 267944, 267458, 267452, 268380, 268374, 268303, 266174, 267984, 268371, 267940, 268389, 268034, 268397, 258345, 267938, 83471, 263320, 258341, 267283, 250608, 267927, 268386, 268483, 267925, 267923, 268384, 268031, 267999, 258339, 267449, 267441, 267437, 267434, 268291, 253841, 267432, 267430, 268288, 267426, 259842, 267424, 268209, 253839, 267421, 268028, 253837, 267997, 267412, 267995, 267990, 267409, 266677, 267407, 266960, 268026, 267988, 267405, 253835, 268024, 258336, 267920, 207968, 265111, 265047, 194431, 262377, 267986, 266171, 267726, 267281, 267391, 267279, 267270, 267274, 263023, 266510, 263561, 266764, 266762, 267142, 201732, 266760, 258333, 266566, 265234, 264724, 266512, 266503, 266347, 266357, 266361, 266409, 266168, 264987, 266407, 207966, 266423, 266404, 254673, 208051, 266437, 266420, 142968, 266359, 264986, 254669, 266176, 260543, 265108, 260541, 260539, 266160, 142966, 266416, 266413, 194430, 266354, 262495, 175220, 201730, 175007, 194428, 142964, 257536, 194424, 261653, 261651, 263770, 261648, 96182, 96180, 265106, 249505, 266352, 266350, 265103, 265100, 265098, 257534, 142962, 257532, 194422, 257530, 266227, 258231, 265229, 264174, 258226, 265254, 264721, 263926, 264719, 265042, 264618, 264312, 264310, 263781, 255803, 158689, 264674, 110791, 160700, 264919, 264171, 125999, 265068, 187238, 259841, 264779, 258668, 263583, 261615, 265056, 264308, 264616, 264552, 261612, 260537, 261610, 264550, 261561, 201729, 264613, 264548, 183846, 262213, 259972, 264611, 264609, 264429, 257753, 264425, 264422, 250956, 264862, 253585, 264302, 255512, 264710, 264419, 264417, 255510, 264826, 264704, 264665, 258665, 255508, 264805, 264662, 264294, 264660, 264819, 264292, 264803, 264290, 255506, 263921, 264288, 264777, 264774, 264786, 264163, 264413, 263919, 264604, 255504, 264545, 263912, 264265, 263906, 192605, 263904, 261428, 264473, 190369, 255502, 264239, 261558, 207881, 264402, 264161, 264154, 264376, 261556, 262235, 264225, 262494, 264168, 263891, 262289, 264151, 262232, 264159, 263886, 253583, 263799, 253579, 139294, 255500, 263571, 254663, 254377, 259839, 253574, 263014, 255498, 258650, 259831, 262491, 255496, 262406, 262950, 255494, 262459, 253572, 255492, 255489, 255487, 262223, 262195, 262489, 257560, 262430, 262487, 175214, 253570, 262484, 262428, 262221, 262482, 262421, 262477, 262416, 262373, 208105, 262471, 262175, 262173, 201727, 261646, 260535, 250948, 151420, 250596, 261003, 259106, 260452, 259963, 258224, 260533, 250587, 258599, 258324, 258107, 257928, 258068, 257788, 256819, 256956, 160693, 255478, 255475, 255463, 254360, 255456, 253173, 254655, 253532, 253529, 254327, 253521, 250173, 249922, 250147, 250796, 251063, 251037, 250513, 250791, 249876, 249002, 249285, 249291, 248699, 249283, 248993, 204221, 204201, 117495, 222168, 222166, 222628, 222015, 187384, 208352, 208343, 208101, 208035, 171330, 207436, 207461, 207890, 203789, 141542, 112825, 207459, 207457, 207897, 207895, 207455, 207047, 202988, 207453, 207876, 207431, 207720, 207618, 207607, 201923, 207004, 201514, 203786, 204734, 204838, 204835, 203784, 204810, 204790, 203782, 202941, 202940, 204092, 203275, 203267, 202918, 202762, 194026, 202270, 201722, 202008, 201717, 202122, 120796, 202004, 120790, 202000, 120787, 160684, 120784, 160682, 120782, 201995, 120780, 201993, 160680, 120776, 201989, 160678, 201987, 120770, 120767, 120760, 120757, 120750, 120713, 181331, 201256, 120687, 120685, 120683, 120681, 120672, 194024, 194369, 120669, 120066, 120665, 194174, 120663, 120656, 120654, 120648, 193962, 152214, 120635, 195000, 193959, 193957, 152210, 194021, 194950, 194362, 120628, 194700, 152196, 194691, 193830, 163780, 194546, 152191, 120625, 120623, 194543, 194188, 194539, 120619, 194018, 194144, 194181, 193923, 160666, 193813, 160664, 189965, 193911, 194017, 193799, 193851, 193795, 193896, 193786, 193783, 117457, 193631, 160657, 169721, 181357, 193510, 160653, 169719, 193230, 191463, 193508, 183522, 193614, 193104, 117449, 193487, 169713, 189962, 193418, 190328, 192193, 192191, 181328, 189955, 190306, 190301, 190087, 183337, 187661, 187659, 187657, 187654, 187650, 187648, 173843, 173468, 170567, 172852, 161425, 161422, 141521, 162199, 169677, 145290, 169358, 168977, 164703, 165877, 165947, 165771, 163343, 165478, 110789, 117381, 163341, 163339, 164346, 164335, 157582, 164285, 163338, 163805, 163901, 163787, 163335, 163332, 163329, 163327, 163325, 163323, 162293, 150643, 155563, 153335, 96962, 140112, 140109, 119921, 119920, 119878, 119874, 119872, 119866, 119864, 147272, 119835, 119828, 142287, 140102, 119629, 134535, 133747, 133771, 126970, 123655, 129436, 129822, 129790, 119499, 127925, 126859, 119348, 124355, 119302, 119291, 123602, 116255, 116251, 122761, 116249, 102827, 121188, 122232, 119171, 122229, 122222, 122167, 116224, 121379, 115219, 119147, 121454, 121452, 119145, 120965, 120321, 113763, 114469, 116852, 115983, 115980, 114673, 91539, 100140, 115654, 115760, 115470, 113666, 115667, 114808, 113558, 114436, 114752, 114769, 114750, 114747, 91510, 113543, 113514, 114112, 113509, 114344, 114236, 114420, 113792, 112684, 112389, 110835, 110833, 112432, 112430, 110831, 110829, 109461, 109452, 112427, 112101, 92226, 111089, 101835, 109444, 109441, 109438, 109436, 109434, 109432, 109430, 112262, 109428, 112259, 112257, 112092, 101440, 111792, 111079, 102471, 111075, 111073, 102468, 102465, 102462, 88754, 102460, 111787, 111838, 111909, 111820, 111818, 111894, 111811, 111797, 102038, 109417, 109392, 109390, 109388, 109386, 109368, 103136, 103165, 110868, 103324, 103158, 103319, 103222, 103293, 103291, 98979, 103289, 109335, 103287, 103285, 103214, 103210, 103283, 103208, 98432, 103274, 103197, 103194, 103268, 103192, 103265, 103262, 103187, 103258, 103134, 103252, 103132, 103130, 103127, 103125, 103248, 103122, 103119, 102962, 103047, 103043, 102950, 102948, 103181, 103178, 103151, 102937, 102935, 103149, 102933, 91498, 102874, 102871, 101145, 102866, 102854, 102851, 102849, 102845, 102841, 102840, 102836, 102802, 102830, 102799, 102788, 98627, 101771, 102797, 101769, 101143, 102648, 102172, 102323, 101136, 101129, 91492, 101119, 101577, 101359, 91484, 101110, 101093, 91480, 91477, 101086, 91475, 101082, 93116, 92148, 101078, 101076, 101070, 101151, 91471, 95719, 100895, 100893, 91469, 91467, 91465, 91463, 99478, 101067, 99895, 99893, 101065, 100889, 101063, 101239, 99891, 101057, 91458, 101055, 99884, 92146, 92144, 101053, 91455, 92142, 100878, 101051, 101047, 100831, 98117, 101040, 100828, 101036, 100709, 100821, 101033, 101030, 101025, 80158, 99472, 101022, 99470, 101019, 99468, 101017, 100815, 99466, 101015, 99464, 100875, 101004, 80156, 100872, 101002, 101000, 100870, 101213, 100996, 100989, 100987, 92139, 100983, 100979, 100975, 100305, 77096, 99572, 100594, 80153, 99570, 100076, 100301, 100792, 100592, 100771, 100696, 91448, 99434, 79865, 99854, 79863, 79861, 79855, 100587, 93104, 93102, 100513, 100583, 100505, 99717, 91444, 99715, 100074, 91440, 100580, 99713, 100578, 91438, 91436, 91435, 100576, 99534, 91432, 100574, 91429, 99711, 100571, 79850, 91426, 79848, 99707, 93094, 99429, 91424, 98890, 100414, 99427, 91422, 99830, 91418, 91416, 99828, 100287, 99826, 94341, 91414, 99824, 91399, 98971, 100257, 100252, 99960, 93602, 91397, 100188, 99811, 99942, 99904, 100065, 99937, 99902, 99807, 99934, 100175, 91393, 99805, 99930, 99803, 91387, 91385, 96944, 91383, 91381, 96942, 99916, 100058, 100056, 85493, 85491, 91378, 99793, 100157, 100051, 100049, 99848, 99659, 100046, 99657, 100044, 99791, 99647, 99846, 99789, 99655, 100042, 94002, 99787, 99844, 99644, 98577, 91375, 99778, 99776, 99773, 97899, 99769, 99006, 97896, 99766, 91352, 99639, 99636, 99610, 98573, 97964, 99593, 97961, 98964, 98568, 28556, 98962, 98566, 98563, 98560, 98555, 97958, 91338, 98552, 99552, 99549, 91332, 91330, 99563, 91328, 91326, 91324, 92115, 91312, 99508, 99506, 99504, 7995, 99502, 7992, 99494, 99106, 99304, 99381, 99376, 99374, 99410, 99100, 99371, 99406, 99366, 99364, 99363, 99361, 99359, 99357, 99354, 99349, 99347, 99346, 98427, 99343, 97598, 99289, 99287, 79839, 99263, 99258, 79835, 99245, 99232, 99216, 79832, 97593, 97590, 98880, 98541, 98539, 98537, 98447, 98445, 91305, 98522, 90847, 98392, 98509, 90842, 98507, 98389, 97578, 90836, 90829, 97569, 90827, 98382, 97567, 97564, 90825, 98380, 90820, 98375, 97557, 90816, 90814, 98373, 98371, 98462, 90812, 98105, 90810, 97554, 90808, 97815, 97551, 96877, 91298, 98416, 95857, 98353, 97934, 95988, 90801, 96685, 90799, 95984, 95982, 90789, 95978, 90787, 90783, 97871, 97931, 95854, 97665, 96920, 90780, 98048, 97922, 97920, 90770, 90767, 98046, 90765, 90763, 90761, 98099, 90745, 90732, 95960, 98135, 90726, 96683, 90703, 90699, 95944, 90697, 95942, 90695, 94982, 90690, 90688, 90686, 90683, 90681, 94979, 90678, 97996, 97943, 97658, 97657, 84533, 95667, 97909, 97866, 97861, 97700, 97652, 95935, 97650, 97648, 97545, 97609, 97543, 97621, 96203, 97540, 96200, 97614, 96356, 90662, 90660, 90658, 90654, 97321, 89050, 91294, 91291, 91289, 93253, 96586, 91281, 24134, 91279, 90628, 89039, 95226, 90619, 90614, 90607, 96565, 96555, 96553, 96544, 96996, 96917, 96537, 96535, 96525, 96595, 92941, 92940, 79818, 95845, 96645, 96628, 95324, 96501, 96499, 96490, 24123, 96427, 95482, 96323, 96424, 96321, 95664, 95662, 95660, 86367, 86365, 92042, 96232, 95645, 95643, 86363, 95891, 79815, 86361, 79813, 93313, 28552, 90524, 90511, 90504, 90496, 90480, 90478, 90476, 90474, 90471, 95640, 95313, 95630, 90454, 95310, 90450, 90448, 95471, 93867, 95619, 95617, 95676, 95614, 95563, 95612, 91267, 90446, 73712, 95610, 95671, 73710, 95543, 95157, 95605, 95531, 91262, 91206, 94527, 95368, 94623, 94523, 94522, 91198, 94519, 94514, 95282, 95208, 94512, 95280, 94621, 94509, 95278, 91192, 91190, 91188, 94506, 94934, 95143, 94617, 94501, 94492, 94766, 95057, 95039, 28549, 90365, 94116, 93848, 94604, 94112, 94110, 93843, 90363, 94847, 93841, 94845, 93836, 93835, 93831, 94842, 94717, 93828, 93827, 94839, 94930, 94599, 93824, 94927, 94835, 94833, 94701, 94924, 94595, 94096, 94590, 93819, 94911, 94453, 94804, 93790, 93998, 93996, 94686, 93994, 90324, 93784, 93776, 90322, 94444, 94672, 90315, 90313, 90311, 90285, 93311, 91153, 94409, 81274, 81271, 90278, 90268, 94145, 90232, 91127, 90225, 93753, 93929, 93926, 93743, 93688, 89127, 90197, 90156, 92847, 92929, 92841, 81238, 92625, 92623, 89788, 92954, 92621, 90998, 90996, 90048, 90044, 88218, 90951, 89999, 92403, 91749, 91747, 89976, 89919, 89565, 89512, 89510, 88648, 88804, 88645, 24105, 89199, 88642, 88724, 86317, 89118, 75002, 89157, 89194, 89152, 88626, 83306, 88624, 88619, 88864, 88709, 88862, 87951, 88706, 88616, 88614, 88610, 88544, 86584, 86311, 88608, 88589, 84507, 85919, 84505, 84503, 85917, 88540, 86151, 86306, 84501, 88236, 88291, 88536, 85915, 79275, 85912, 88234, 84853, 88272, 76346, 76844, 88119, 88268, 88116, 88263, 88114, 88371, 88260, 88112, 88257, 88253, 76840, 88109, 88205, 88162, 82496, 88231, 88201, 87488, 85584, 86255, 87393, 86243, 24097, 86921, 86671, 24094, 86666, 86660, 86803, 86732, 85186, 86560, 85182, 86574, 86222, 85180, 85786, 86198, 85784, 85783, 86170, 85903, 85346, 85896, 85893, 85891, 85743, 85384, 85625, 85421, 84639, 85404, 69921, 85416, 85400, 85376, 82636, 83653, 84114, 79762, 83129, 82928, 81862, 82988, 83298, 80758, 83124, 82974, 83052, 82971, 83050, 82463, 81860, 81945, 81643, 81807, 81574, 81562, 80803, 80438, 80586, 80445, 80443, 79718, 79713, 78150, 80315, 80311, 76709, 80207, 79661, 79624, 79239, 79585, 79184, 77891, 79574, 79530, 79507, 78990, 79238, 78984, 78868, 72092, 77860, 77821, 77306, 76882, 77515, 77510, 77503, 77497, 74755, 77286, 77244, 77218, 75997, 24036, 76785, 75982, 75980, 76527, 75978, 76404, 76188, 76399, 76184, 76373, 76429, 75600, 76290, 76396, 76244, 76389, 76281, 76362, 75644, 75973, 76031, 75773, 75726, 75746, 75743, 74985, 75721, 75486, 74185, 75352, 75393, 75518, 75580, 75516, 75561, 74619, 75266, 74793, 74791, 74562, 75223, 74719, 74819, 74816, 75174, 74933, 75058, 74701, 73957, 73948, 74175, 74173, 73946, 74171, 74497, 74353, 74276, 74391, 74085, 64362, 74075, 74382, 74328, 18078, 74326, 74073, 74255, 74202, 74044, 74071, 73265, 69317, 69498, 74006, 73810, 7942, 72881, 73879, 7939, 72878, 73657, 72404, 73798, 73669, 73667, 73619, 73350, 73617, 73527, 73615, 73348, 73524, 73346, 73392, 73386, 73131, 72977, 73120, 73203, 73117, 72872, 72373, 73115, 69151, 72870, 72599, 69149, 72863, 69350, 72372, 72591, 72815, 72583, 72578, 72344, 72550, 72401, 72367, 72399, 72389, 70596, 72181, 72328, 72383, 72086, 71930, 66595, 66593, 70594, 24003, 71407, 24001, 70588, 70586, 71175, 70577, 70804, 70793, 70435, 69823, 69696, 69801, 23992, 64656, 69782, 60238, 69579, 69780, 69449, 69597, 69230, 69227, 69294, 69281, 69320, 67673, 69206, 69204, 69303, 69202, 23977, 69291, 67837, 67711, 66694, 67436, 67430, 64754, 67252, 67249, 66362, 66464, 62363, 66360, 66359, 62358, 64211, 64290, 61584, 61886, 60472, 61231, 59522, 60595, 59445, 60212, 60871, 58900, 58898, 60664, 59860, 59347, 60661, 58025, 60235, 60234, 60285, 60009, 58203, 51855, 57615, 51228, 51225, 50219, 48474, 23816, 57711, 57635, 48473, 49972, 51222, 49970, 51219, 52557, 57283, 23812, 57677, 57221, 57220, 48472, 57218, 57215, 48470, 57170, 49967, 56935, 48319, 50214, 56612, 57628, 49965, 50211, 57623, 57551, 50209, 56072, 57607, 56198, 57167, 50207, 55560, 48317, 48315, 57549, 52554, 50205, 49398, 57392, 45797, 56879, 55556, 56068, 48312, 55553))
Run Time: 0.104939
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2800 | |
PRIMARY | xf_post | eq_ref | PRIMARY | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
PRIMARY | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_post.thread_id | 1 | |
PRIMARY | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread_Thread_1.node_id | 1 | Using where |
PRIMARY | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_2.node_id | 1 | Using where |
PRIMARY | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_post.user_id | 1 | |
PRIMARY | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_3.node_id | 1 | Using where |
MATERIALIZED | <derived3> | ALL | | | | | 2800 | |
DERIVED | | | | | | | | No tables used |
- 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 1428
- 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 2870
- 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 180
- 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 258
- 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 2487
- 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 (26230, 26212, 25819, 25770, 25703, 25671, 25587, 25573, 25546, 25394, 25385, 25384, 25380, 25337, 25319, 25311, 25310, 25254, 25250, 25249, 25248, 25051, 24979, 24226, 23910, 23170, 23067, 22884, 22764, 22470, 22463, 22348, 22302, 22229, 22191, 22115, 22111, 22072, 22045, 21852, 21814, 21812, 21626, 20924, 19651, 19644, 19642, 19628, 19615, 19611, 19605, 19562, 19509, 19347, 19225, 19224, 19223, 19210, 19183, 19180, 19177, 19143, 19136, 19024, 18994, 18741, 18734, 18705, 18700, 18697, 18694, 18693, 18668, 18666, 18657, 18648, 18647, 18646, 18594, 18593, 18591, 18583, 18580, 18548, 18546, 18539, 18317, 18138, 18089, 18028, 17984, 17980, 17810, 17218, 17217, 17197, 17192, 17148, 16340, 15596, 14738, 14644, 14540, 14443, 14442, 14428, 14424, 14416, 14414, 14412, 14400, 14398, 14389, 14386, 14374, 14373, 14371, 14370, 14308, 14281, 14225, 14113, 13835, 13779, 13771, 13764, 13757, 13756, 13743, 13737, 13663, 13659, 13655, 13654, 13653, 13647, 13614, 13608, 13593, 13436, 12695, 12361, 12226, 12210, 11900, 10915, 9746, 8502, 8294, 8275, 8232, 8208, 8203, 7242, 6961, 6531, 6525, 6470, 6469, 6374))
Run Time: 0.005074
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 160 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.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 1428
- 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 2870
- 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 258
- 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 2487
- 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 (511499, 372837, 503963, 372836, 372835, 372834, 455767, 467198, 372833, 372832, 450511, 450509, 503738, 372831, 382350, 502386, 503368, 503635, 503959, 503428, 503957, 502347, 503372, 503337, 497925, 497921, 497919, 500047, 498692, 500224, 499902, 382884, 499504, 253810, 382446, 382348, 483598, 422307, 494411, 495568, 494557, 494524, 495638, 497735, 497850, 498667, 497853, 497914, 452469, 419483, 489913, 491407, 491780, 491984, 492743, 492751, 492764, 492784, 493016, 489502, 493819, 493823, 492209, 491564, 401633, 382444, 465914, 378507, 488192, 479607, 379162, 487793, 487787, 488293, 487102, 487025, 481902, 487941, 253808, 353253, 487050, 487044, 483596, 479604, 483594, 483592, 456282, 468103, 462137, 470081, 470225, 470887, 471727, 471983, 472728, 475226, 475340, 476584, 477990, 484031, 484456, 217604, 484687, 484732, 484991, 485007, 485054, 486337, 467543, 466970, 465995, 480913, 481869, 482638, 481995, 482763, 482887, 483047, 483189, 483730, 483223, 480279, 480092, 480023, 466881, 479601, 379160, 253807, 253806, 253805, 253803, 372829, 422809, 382346, 479380, 172934, 462352, 386660, 419480, 386658, 382442, 386654, 382345, 353251, 390235, 386651, 466464, 253802, 379158, 353249, 465749, 466457, 460531, 253798, 253797, 253796, 253795, 253794, 253793, 253792, 253791, 253790, 253789, 253788, 253787, 253786, 253785, 253784, 253783, 253782, 253781, 253779, 253778, 370573, 253777, 253776, 253775, 253774, 370572, 465817, 465562, 462349, 464590, 452465, 456678, 463027, 464356, 465409, 465560, 382437, 370571, 390218, 382343, 419477, 463037, 452463, 382435, 458463, 382433, 390216, 459286, 460394, 456929, 456806, 459284, 459562, 459897, 460259, 460536, 459282, 459121, 307823, 458461, 382341, 458185, 455119, 456997, 457233, 457787, 455117, 455115, 455113, 422806, 453223, 456877, 382338, 117679, 456147, 382336, 453037, 456145, 455941, 451497, 455752, 451495, 381959, 455178, 455130, 347212, 454434, 455109, 451182, 454219, 454221, 454252, 454264, 454384, 454483, 454012, 451960, 382430, 452459, 452740, 423512, 450981, 450978, 451493, 450976, 451491, 382334, 450974, 260602, 422804, 447934, 422689, 449285, 449712, 382424, 449283, 390214, 382332, 422594, 422685, 390212, 423509, 422591, 423507, 419476, 417522, 409457, 382422, 253759, 422802, 253757, 422304, 409452, 260590, 253755, 382420, 253753, 422580, 422302, 253750, 36958, 253748, 260587, 253746, 382418, 415322, 253744, 382416, 253742, 382414, 253735, 253734, 419909, 253733, 401624, 382412, 370054, 419474, 419472, 419470, 364624, 373597, 372828, 373595, 373592, 382880, 400361, 390228, 385456, 390307, 382879, 382399, 260573, 391929, 390304, 391563, 391926, 386644, 390298, 389495, 382396, 382394, 382392, 253725, 389483, 253722, 253719, 382389, 389480, 389838, 389478, 389364, 389836, 370049, 384387, 370047, 388386, 388383, 387507, 388380, 385523, 376661, 385452, 386585, 387477, 253717, 382897, 370710, 386257, 301866, 387196, 354139, 387194, 387192, 387189, 253716, 385446, 370788, 384764, 370705, 384762, 382324, 384760, 384671, 253714, 379327, 384669, 384381, 253713, 382384, 382381, 382893, 382378, 384071, 384049, 383625, 253711, 382373, 382595, 381891, 382890, 382371, 379155, 302351, 382369, 302349, 382888, 382834, 382480, 383182, 373980, 381946, 302347, 253709, 382765, 382478, 382366, 382476, 381626, 381889, 253707, 379322, 381433, 143254, 381425, 375781, 374664, 381885, 253701, 381895, 381423, 378616, 381421, 359602, 379600, 371351, 379300, 379321, 304040, 378568, 359598, 378566, 378612, 378595, 378956, 378593, 378733, 378610, 378608, 374363, 377666, 375395, 377364, 368868, 370367, 371390, 304037, 364579, 370281, 375485, 371380, 371349, 287702, 373483, 260561, 373481, 372924, 370765, 370868, 373479, 287700, 366279, 373477, 366277, 366275, 287698, 373407, 368855, 290134, 373405, 372879, 371347, 372425, 372897, 371266, 370329, 371378, 371265, 372858, 370758, 302333, 253695, 344638, 371263, 370912, 371233, 370752, 370865, 370750, 366273, 370533, 370747, 370745, 370739, 370858, 370856, 370691, 370314, 370309, 366663, 370307, 370188, 290131, 369784, 367942, 361132, 367937, 363196, 367914, 363191, 361718, 366565, 366269, 364833, 364878, 365911, 359410, 364599, 362894, 361129, 360900, 360898, 361127, 360896, 361125, 360894, 360887, 360978, 360393, 359659, 359655, 359653, 359649, 359409, 352616, 340442, 340434, 358063, 353921, 303545, 340426, 340424, 340422, 357170, 353989, 351435, 352613, 297007, 311198, 297005, 311196, 352536, 354280, 355158, 356901, 351432, 351430, 349246, 338876, 340412, 351781, 351495, 346955, 351657, 351415, 346942, 347359, 347163, 346936, 348387, 348523, 345031, 253669, 346570, 346501, 344346, 346497, 344344, 334902, 345020, 253664, 344342, 345891, 335049, 345821, 313810, 267384, 344633, 344312, 316876, 338611, 344627, 339411, 334899, 331894, 340343, 334896, 340318, 339889, 341639, 287697, 339354, 339351, 339340, 338871, 339330, 339327, 339323, 332307, 330588, 253624, 253622, 331967, 327558, 328568, 328263, 331938, 319166, 330581, 330579, 329417, 300707, 313732, 329137, 208085, 305503, 303938, 202303, 301386, 304174, 301370, 202295, 303926, 8052, 301569, 302950, 296999, 288115, 288480, 287437, 300871, 301549, 287435, 301076, 300861, 301072, 300629, 284377, 287753, 298905, 300528, 300521, 284373, 264643, 288112, 264639, 296991, 298225, 298222, 287493, 297421, 287686, 295430, 293737, 297703, 295809, 297609, 296988, 265121, 297412, 297492, 297524, 291392, 287489, 117591, 296443, 296985, 297408, 297037, 297034, 264759, 295423, 297032, 296983, 297023, 297026, 297020, 258234, 291647, 264566, 264563, 296130, 264561, 287623, 288483, 288485, 291390, 291972, 295447, 295925, 296124, 296453, 295338, 296128, 295791, 291004, 291700, 264559, 264557, 264755, 295418, 296126, 288475, 264753, 250962, 264751, 296294, 287486, 296138, 287510, 295416, 288662, 295520, 264749, 291645, 291643, 284648, 264747, 287484, 296134, 204302, 287684, 295609, 287508, 117588, 295802, 293731, 284564, 287751, 295122, 253620, 288104, 264744, 295410, 295007, 288133, 287190, 295108, 295407, 294900, 253614, 293831, 287482, 287735, 253608, 264733, 287472, 287470, 287468, 204299, 264350, 288715, 288713, 183928, 204297, 287727, 288652, 287725, 288473, 264345, 253606, 288649, 85311, 288291, 194437, 264343, 287723, 288471, 288309, 264341, 287433, 285946, 288288, 288286, 288285, 288304, 266484, 288301, 288299, 288297, 183927, 288099, 288295, 287431, 260555, 287719, 287628, 287627, 287718, 287430, 264731, 287625, 288097, 287715, 288127, 183925, 287712, 287504, 277790, 287804, 269619, 270714, 287682, 287802, 287681, 287709, 260552, 286590, 287799, 279135, 287679, 287466, 287464, 253602, 287659, 279605, 264337, 287611, 152336, 284562, 287501, 286587, 277789, 287328, 287428, 287499, 287537, 253598, 287498, 287462, 287180, 282818, 287178, 287460, 287208, 277787, 260550, 253594, 287457, 287423, 264332, 264728, 264726, 270711, 282676, 260547, 285863, 270709, 264330, 283134, 284644, 266726, 283762, 278289, 278287, 278284, 284866, 284864, 284874, 261887, 269618, 265117, 259845, 282816, 283132, 278279, 278277, 282811, 278275, 278273, 277759, 279976, 268745, 282807, 282647, 269614, 269612, 277753, 183913, 276516, 277751, 279666, 250613, 279687, 279132, 250611, 278270, 279130, 250609, 204296, 278268, 278266, 276514, 279434, 277745, 278337, 277701, 270706, 266365, 277699, 265115, 277731, 277689, 278199, 277681, 265053, 272876, 273087, 273559, 267602, 271355, 269388, 271314, 265050, 83477, 260546, 270950, 270702, 271274, 270734, 271212, 270952, 267153, 270493, 204294, 204292, 250958, 269609, 269723, 270044, 269891, 269967, 264625, 270047, 267546, 269713, 269703, 267951, 269583, 263932, 267533, 267530, 266480, 265570, 264536, 267515, 258760, 267148, 267512, 264620, 267948, 268008, 260544, 203822, 264554, 262218, 269543, 261563, 264326, 267510, 269381, 203820, 269378, 269375, 265112, 268744, 204290, 203818, 268005, 267946, 268003, 268000, 268480, 267489, 160154, 160152, 267479, 268478, 268743, 267474, 268741, 268739, 267471, 268736, 267286, 267469, 267462, 268732, 268730, 208052, 267944, 267458, 267452, 268380, 268374, 268303, 266174, 267984, 268371, 267940, 268389, 268034, 268397, 258345, 267938, 83471, 263320, 258341, 267283, 250608, 267927, 268386, 268483, 267925, 267923, 268384, 268031, 267999, 258339, 267449, 267441, 267437, 267434, 268291, 253841, 267432, 267430, 268288, 267426, 259842, 267424, 268209, 253839, 267421, 268028, 253837, 267997, 267412, 267995, 267990, 267409, 266677, 267407, 266960, 268026, 267988, 267405, 253835, 268024, 258336, 267920, 207968, 265111, 265047, 194431, 262377, 267986, 266171, 267726, 267281, 267391, 267279, 267270, 267274, 263023, 266510, 263561, 266764, 266762, 267142, 201732, 266760, 258333, 266566, 265234, 264724, 266512, 266503, 266347, 266357, 266361, 266409, 266168, 264987, 266407, 207966, 266423, 266404, 254673, 208051, 266437, 266420, 142968, 266359, 264986, 254669, 266176, 260543, 265108, 260541, 260539, 266160, 142966, 266416, 266413, 194430, 266354, 262495, 175220, 201730, 175007, 194428, 142964, 257536, 194424, 261653, 261651, 263770, 261648, 96182, 96180, 265106, 249505, 266352, 266350, 265103, 265100, 265098, 257534, 142962, 257532, 194422, 257530, 266227, 258231, 265229, 264174, 258226, 265254, 264721, 263926, 264719, 265042, 264618, 264312, 264310, 263781, 255803, 158689, 264674, 110791, 160700, 264919, 264171, 125999, 265068, 187238, 259841, 264779, 258668, 263583, 261615, 265056, 264308, 264616, 264552, 261612, 260537, 261610, 264550, 261561, 201729, 264613, 264548, 183846, 262213, 259972, 264611, 264609, 264429, 257753, 264425, 264422, 250956, 264862, 253585, 264302, 255512, 264710, 264419, 264417, 255510, 264826, 264704, 264665, 258665, 255508, 264805, 264662, 264294, 264660, 264819, 264292, 264803, 264290, 255506, 263921, 264288, 264777, 264774, 264786, 264163, 264413, 263919, 264604, 255504, 264545, 263912, 264265, 263906, 192605, 263904, 261428, 264473, 190369, 255502, 264239, 261558, 207881, 264402, 264161, 264154, 264376, 261556, 262235, 264225, 262494, 264168, 263891, 262289, 264151, 262232, 264159, 263886, 253583, 263799, 253579, 139294, 255500, 263571, 254663, 254377, 259839, 253574, 263014, 255498, 258650, 259831, 262491, 255496, 262406, 262950, 255494, 262459, 253572, 255492, 255489, 255487, 262223, 262195, 262489, 257560, 262430, 262487, 175214, 253570, 262484, 262428, 262221, 262482, 262421, 262477, 262416, 262373, 208105, 262471, 262175, 262173, 201727, 261646, 260535, 250948, 151420, 250596, 261003, 259106, 260452, 259963, 258224, 260533, 250587, 258599, 258324, 258107, 257928, 258068, 257788, 256819, 256956, 160693, 255478, 255475, 255463, 254360, 255456, 253173, 254655, 253532, 253529, 254327, 253521, 250173, 249922, 250147, 250796, 251063, 251037, 250513, 250791, 249876, 249002, 249285, 249291, 248699, 249283, 248993, 204221, 204201, 117495, 222168, 222166, 222628, 222015, 187384, 208352, 208343, 208101, 208035, 171330, 207436, 207461, 207890, 203789, 141542, 112825, 207459, 207457, 207897, 207895, 207455, 207047, 202988, 207453, 207876, 207431, 207720, 207618, 207607, 201923, 207004, 201514, 203786, 204734, 204838, 204835, 203784, 204810, 204790, 203782, 202941, 202940, 204092, 203275, 203267, 202918, 202762, 194026, 202270, 201722, 202008, 201717, 202122, 120796, 202004, 120790, 202000, 120787, 160684, 120784, 160682, 120782, 201995, 120780, 201993, 160680, 120776, 201989, 160678, 201987, 120770, 120767, 120760, 120757, 120750, 120713, 181331, 201256, 120687, 120685, 120683, 120681, 120672, 194024, 194369, 120669, 120066, 120665, 194174, 120663, 120656, 120654, 120648, 193962, 152214, 120635, 195000, 193959, 193957, 152210, 194021, 194950, 194362, 120628, 194700, 152196, 194691, 193830, 163780, 194546, 152191, 120625, 120623, 194543, 194188, 194539, 120619, 194018, 194144, 194181, 193923, 160666, 193813, 160664, 189965, 193911, 194017, 193799, 193851, 193795, 193896, 193786, 193783, 117457, 193631, 160657, 169721, 181357, 193510, 160653, 169719, 193230, 191463, 193508, 183522, 193614, 193104, 117449, 193487, 169713, 189962, 193418, 190328, 192193, 192191, 181328, 189955, 190306, 190301, 190087, 183337, 187661, 187659, 187657, 187654, 187650, 187648, 173843, 173468, 170567, 172852, 161425, 161422, 141521, 162199, 169677, 145290, 169358, 168977, 164703, 165877, 165947, 165771, 163343, 165478, 110789, 117381, 163341, 163339, 164346, 164335, 157582, 164285, 163338, 163805, 163901, 163787, 163335, 163332, 163329, 163327, 163325, 163323, 162293, 150643, 155563, 153335, 96962, 140112, 140109, 119921, 119920, 119878, 119874, 119872, 119866, 119864, 147272, 119835, 119828, 142287, 140102, 119629, 134535, 133747, 133771, 126970, 123655, 129436, 129822, 129790, 119499, 127925, 126859, 119348, 124355, 119302, 119291, 123602, 116255, 116251, 122761, 116249, 102827, 121188, 122232, 119171, 122229, 122222, 122167, 116224, 121379, 115219, 119147, 121454, 121452, 119145, 120965, 120321, 113763, 114469, 116852, 115983, 115980, 114673, 91539, 100140, 115654, 115760, 115470, 113666, 115667, 114808, 113558, 114436, 114752, 114769, 114750, 114747, 91510, 113543, 113514, 114112, 113509, 114344, 114236, 114420, 113792, 112684, 112389, 110835, 110833, 112432, 112430, 110831, 110829, 109461, 109452, 112427, 112101, 92226, 111089, 101835, 109444, 109441, 109438, 109436, 109434, 109432, 109430, 112262, 109428, 112259, 112257, 112092, 101440, 111792, 111079, 102471, 111075, 111073, 102468, 102465, 102462, 88754, 102460, 111787, 111838, 111909, 111820, 111818, 111894, 111811, 111797, 102038, 109417, 109392, 109390, 109388, 109386, 109368, 103136, 103165, 110868, 103324, 103158, 103319, 103222, 103293, 103291, 98979, 103289, 109335, 103287, 103285, 103214, 103210, 103283, 103208, 98432, 103274, 103197, 103194, 103268, 103192, 103265, 103262, 103187, 103258, 103134, 103252, 103132, 103130, 103127, 103125, 103248, 103122, 103119, 102962, 103047, 103043, 102950, 102948, 103181, 103178, 103151, 102937, 102935, 103149, 102933, 91498, 102874, 102871, 101145, 102866, 102854, 102851, 102849, 102845, 102841, 102840, 102836, 102802, 102830, 102799, 102788, 98627, 101771, 102797, 101769, 101143, 102648, 102172, 102323, 101136, 101129, 91492, 101119, 101577, 101359, 91484, 101110, 101093, 91480, 91477, 101086, 91475, 101082, 93116, 92148, 101078, 101076, 101070, 101151, 91471, 95719, 100895, 100893, 91469, 91467, 91465, 91463, 99478, 101067, 99895, 99893, 101065, 100889, 101063, 101239, 99891, 101057, 91458, 101055, 99884, 92146, 92144, 101053, 91455, 92142, 100878, 101051, 101047, 100831, 98117, 101040, 100828, 101036, 100709, 100821, 101033, 101030, 101025, 80158, 99472, 101022, 99470, 101019, 99468, 101017, 100815, 99466, 101015, 99464, 100875, 101004, 80156, 100872, 101002, 101000, 100870, 101213, 100996, 100989, 100987, 92139, 100983, 100979, 100975, 100305, 77096, 99572, 100594, 80153, 99570, 100076, 100301, 100792, 100592, 100771, 100696, 91448, 99434, 79865, 99854, 79863, 79861, 79855, 100587, 93104, 93102, 100513, 100583, 100505, 99717, 91444, 99715, 100074, 91440, 100580, 99713, 100578, 91438, 91436, 91435, 100576, 99534, 91432, 100574, 91429, 99711, 100571, 79850, 91426, 79848, 99707, 93094, 99429, 91424, 98890, 100414, 99427, 91422, 99830, 91418, 91416, 99828, 100287, 99826, 94341, 91414, 99824, 91399, 98971, 100257, 100252, 99960, 93602, 91397, 100188, 99811, 99942, 99904, 100065, 99937, 99902, 99807, 99934, 100175, 91393, 99805, 99930, 99803, 91387, 91385, 96944, 91383, 91381, 96942, 99916, 100058, 100056, 85493, 85491, 91378, 99793, 100157, 100051, 100049, 99848, 99659, 100046, 99657, 100044, 99791, 99647, 99846, 99789, 99655, 100042, 94002, 99787, 99844, 99644, 98577, 91375, 99778, 99776, 99773, 97899, 99769, 99006, 97896, 99766, 91352, 99639, 99636, 99610, 98573, 97964, 99593, 97961, 98964, 98568, 28556, 98962, 98566, 98563, 98560, 98555, 97958, 91338, 98552, 99552, 99549, 91332, 91330, 99563, 91328, 91326, 91324, 92115, 91312, 99508, 99506, 99504, 7995, 99502, 7992, 99494, 99106, 99304, 99381, 99376, 99374, 99410, 99100, 99371, 99406, 99366, 99364, 99363, 99361, 99359, 99357, 99354, 99349, 99347, 99346, 98427, 99343, 97598, 99289, 99287, 79839, 99263, 99258, 79835, 99245, 99232, 99216, 79832, 97593, 97590, 98880, 98541, 98539, 98537, 98447, 98445, 91305, 98522, 90847, 98392, 98509, 90842, 98507, 98389, 97578, 90836, 90829, 97569, 90827, 98382, 97567, 97564, 90825, 98380, 90820, 98375, 97557, 90816, 90814, 98373, 98371, 98462, 90812, 98105, 90810, 97554, 90808, 97815, 97551, 96877, 91298, 98416, 95857, 98353, 97934, 95988, 90801, 96685, 90799, 95984, 95982, 90789, 95978, 90787, 90783, 97871, 97931, 95854, 97665, 96920, 90780, 98048, 97922, 97920, 90770, 90767, 98046, 90765, 90763, 90761, 98099, 90745, 90732, 95960, 98135, 90726, 96683, 90703, 90699, 95944, 90697, 95942, 90695, 94982, 90690, 90688, 90686, 90683, 90681, 94979, 90678, 97996, 97943, 97658, 97657, 84533, 95667, 97909, 97866, 97861, 97700, 97652, 95935, 97650, 97648, 97545, 97609, 97543, 97621, 96203, 97540, 96200, 97614, 96356, 90662, 90660, 90658, 90654, 97321, 89050, 91294, 91291, 91289, 93253, 96586, 91281, 24134, 91279, 90628, 89039, 95226, 90619, 90614, 90607, 96565, 96555, 96553, 96544, 96996, 96917, 96537, 96535, 96525, 96595, 92941, 92940, 79818, 95845, 96645, 96628, 95324, 96501, 96499, 96490, 24123, 96427, 95482, 96323, 96424, 96321, 95664, 95662, 95660, 86367, 86365, 92042, 96232, 95645, 95643, 86363, 95891, 79815, 86361, 79813, 93313, 28552, 90524, 90511, 90504, 90496, 90480, 90478, 90476, 90474, 90471, 95640, 95313, 95630, 90454, 95310, 90450, 90448, 95471, 93867, 95619, 95617, 95676, 95614, 95563, 95612, 91267, 90446, 73712, 95610, 95671, 73710, 95543, 95157, 95605, 95531, 91262, 91206, 94527, 95368, 94623, 94523, 94522, 91198, 94519, 94514, 95282, 95208, 94512, 95280, 94621, 94509, 95278, 91192, 91190, 91188, 94506, 94934, 95143, 94617, 94501, 94492, 94766, 95057, 95039, 28549, 90365, 94116, 93848, 94604, 94112, 94110, 93843, 90363, 94847, 93841, 94845, 93836, 93835, 93831, 94842, 94717, 93828, 93827, 94839, 94930, 94599, 93824, 94927, 94835, 94833, 94701, 94924, 94595, 94096, 94590, 93819, 94911, 94453, 94804, 93790, 93998, 93996, 94686, 93994, 90324, 93784, 93776, 90322, 94444, 94672, 90315, 90313, 90311, 90285, 93311, 91153, 94409, 81274, 81271, 90278, 90268, 94145, 90232, 91127, 90225, 93753, 93929, 93926, 93743, 93688, 89127, 90197, 90156, 92847, 92929, 92841, 81238, 92625, 92623, 89788, 92954, 92621, 90998, 90996, 90048, 90044, 88218, 90951, 89999, 92403, 91749, 91747, 89976, 89919, 89565, 89512, 89510, 88648, 88804, 88645, 24105, 89199, 88642, 88724, 86317, 89118, 75002, 89157, 89194, 89152, 88626, 83306, 88624, 88619, 88864, 88709, 88862, 87951, 88706, 88616, 88614, 88610, 88544, 86584, 86311, 88608, 88589, 84507, 85919, 84505, 84503, 85917, 88540, 86151, 86306, 84501, 88236, 88291, 88536, 85915, 79275, 85912, 88234, 84853, 88272, 76346, 76844, 88119, 88268, 88116, 88263, 88114, 88371, 88260, 88112, 88257, 88253, 76840, 88109, 88205, 88162, 82496, 88231, 88201, 87488, 85584, 86255, 87393, 86243, 24097, 86921, 86671, 24094, 86666, 86660, 86803, 86732, 85186, 86560, 85182, 86574, 86222, 85180, 85786, 86198, 85784, 85783, 86170, 85903, 85346, 85896, 85893, 85891, 85743, 85384, 85625, 85421, 84639, 85404, 69921, 85416, 85400, 85376, 82636, 83653, 84114, 79762, 83129, 82928, 81862, 82988, 83298, 80758, 83124, 82974, 83052, 82971, 83050, 82463, 81860, 81945, 81643, 81807, 81574, 81562, 80803, 80438, 80586, 80445, 80443, 79718, 79713, 78150, 80315, 80311, 76709, 80207, 79661, 79624, 79239, 79585, 79184, 77891, 79574, 79530, 79507, 78990, 79238, 78984, 78868, 72092, 77860, 77821, 77306, 76882, 77515, 77510, 77503, 77497, 74755, 77286, 77244, 77218, 75997, 24036, 76785, 75982, 75980, 76527, 75978, 76404, 76188, 76399, 76184, 76373, 76429, 75600, 76290, 76396, 76244, 76389, 76281, 76362, 75644, 75973, 76031, 75773, 75726, 75746, 75743, 74985, 75721, 75486, 74185, 75352, 75393, 75518, 75580, 75516, 75561, 74619, 75266, 74793, 74791, 74562, 75223, 74719, 74819, 74816, 75174, 74933, 75058, 74701, 73957, 73948, 74175, 74173, 73946, 74171, 74497, 74353, 74276, 74391, 74085, 64362, 74075, 74382, 74328, 18078, 74326, 74073, 74255, 74202, 74044, 74071, 73265, 69317, 69498, 74006, 73810, 7942, 72881, 73879, 7939, 72878, 73657, 72404, 73798, 73669, 73667, 73619, 73350, 73617, 73527, 73615, 73348, 73524, 73346, 73392, 73386, 73131, 72977, 73120, 73203, 73117, 72872, 72373, 73115, 69151, 72870, 72599, 69149, 72863, 69350, 72372, 72591, 72815, 72583, 72578, 72344, 72550, 72401, 72367, 72399, 72389, 70596, 72181, 72328, 72383, 72086, 71930, 66595, 66593, 70594, 24003, 71407, 24001, 70588, 70586, 71175, 70577, 70804, 70793, 70435, 69823, 69696, 69801, 23992, 64656, 69782, 60238, 69579, 69780, 69449, 69597, 69230, 69227, 69294, 69281, 69320, 67673, 69206, 69204, 69303, 69202, 23977, 69291, 67837, 67711, 66694, 67436, 67430, 64754, 67252, 67249, 66362, 66464, 62363, 66360, 66359, 62358, 64211, 64290, 61584, 61886, 60472, 61231, 59522, 60595, 59445, 60212, 60871, 58900, 58898, 60664, 59860, 59347, 60661, 58025, 60235, 60234, 60285, 60009, 58203, 51855, 57615, 51228, 51225, 50219, 48474, 23816, 57711, 57635, 48473, 49972, 51222, 49970, 51219, 52557, 57283, 23812, 57677, 57221, 57220, 48472, 57218, 57215, 48470, 57170, 49967, 56935, 48319, 50214, 56612, 57628, 49965, 50211, 57623, 57551, 50209, 56072, 57607, 56198, 57167, 50207, 55560, 48317, 48315, 57549, 52554, 50205, 49398, 57392, 45797, 56879, 55556, 56068, 48312, 55553))
Run Time: 0.050570
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2800 | |
PRIMARY | xf_post | eq_ref | PRIMARY | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
PRIMARY | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_post.thread_id | 1 | |
PRIMARY | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread_Thread_1.node_id | 1 | Using where |
PRIMARY | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_2.node_id | 1 | Using where |
PRIMARY | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_post.user_id | 1 | |
PRIMARY | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_3.node_id | 1 | Using where |
MATERIALIZED | <derived3> | ALL | | | | | 2800 | |
DERIVED | | | | | | | | No tables used |
- 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 1428
- 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 2870
- 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 258
- 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 2487
- 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.000230
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 130
- 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 45
- 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 258
- 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 2487
- 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=1556, 1716209752, , 0, �"
Run Time: 0.000125
- 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 218
- 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 45
- 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 258
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000389
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 215
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- 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 2487
- 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_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
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_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (120))
Run Time: 0.000577
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1716209452
Run Time: 0.000300
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 45 | 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 147
- XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
- XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Repository/SessionActivity.php at line 62
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*, `xf_user_User_1`.*
FROM `xf_session_activity`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1716209452)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000609
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 45 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | my_webapp.xf_session_activity.user_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivity.php at line 43
- XF\Repository\SessionActivity->getOnlineUsersList() in src/XF/Repository/SessionActivity.php at line 63
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20