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.000697
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.000200
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 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` = '3430')
LIMIT 1
Run Time: 0.000492
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.002915
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_3430' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.045528
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_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 (574720, 562236, 485816, 561295, 562199, 244396, 252875, 233253, 244336, 233078, 244252, 233013, 554803, 232991, 551459, 232979, 232922, 219927, 552425, 108770, 552423, 552420, 551458, 551456, 551453, 551451, 551449, 551447, 551445, 551597, 265542, 551652, 525757, 551646, 232862, 347307, 232859, 551444, 551440, 548257, 219668, 219666, 229506, 229484, 229481, 451689, 229473, 448549, 418622, 448711, 448706, 449543, 229428, 448542, 198073, 229391, 449527, 423795, 449172, 110176, 449034, 241087, 241083, 241081, 448538, 229357, 241066, 423783, 229355, 241048, 241046, 110171, 110169, 448238, 229334, 229293, 229291, 229276, 423675, 229271, 229230, 229228, 229217, 229206, 229204, 240944, 240926, 229175, 229173, 240910, 422573, 422570, 422568, 422564, 229119, 229115, 240888, 229096, 420514, 420504, 420479, 420477, 420463, 420460, 240848, 420454, 375233, 240807, 107355, 107353, 107349, 229053, 419347, 419345, 614464, 614461, 614459, 614457, 418606, 418602, 240729, 418657, 418597, 418594, 418588, 240720, 216142, 229019, 417221, 417427, 374504, 240516, 367088, 413271, 240477, 614452, 412717, 228768, 228765, 228760, 205503, 228725, 322324, 228706, 228699, 228682, 409730, 215799, 215797, 228597, 228576, 228562, 614447, 614445, 614443, 405686, 405680, 397162, 401920, 240070, 401918, 406272, 406263, 240039, 401907, 404333, 107094, 401904, 401902, 401899, 401892, 401889, 401875, 110141, 401870, 401866, 401858, 401855, 401853, 401852, 401845, 401842, 401840, 228328, 107055, 188173, 322311, 405532, 228287, 110135, 405660, 310548, 322288, 391750, 227406, 385194, 252739, 252737, 196866, 227335, 238574, 238565, 238559, 238554, 294203, 238540, 377996, 238535, 382192, 382190, 382182, 382176, 238521, 238473, 322234, 238466, 322231, 238438, 238425, 227173, 227171, 252709, 354237, 346289, 346287, 238360, 238356, 294202, 294199, 214361, 294195, 227056, 376822, 196702, 227053, 359509, 196610, 332782, 374434, 372446, 372442, 291458, 226917, 196601, 238099, 331296, 359494, 359492, 362088, 362086, 362084, 359488, 106136, 362051, 213978, 213975, 213973, 213971, 213969, 238072, 238067, 254850, 344500, 360756, 326938, 359809, 332780, 372428, 226842, 226837, 360740, 196557, 252665, 252661, 371063, 322210, 360731, 252657, 226755, 360729, 196497, 359477, 226737, 226694, 226687, 226685, 370337, 226677, 213769, 226674, 213762, 252652, 363808, 180888, 329975, 252647, 265471, 265464, 265459, 237999, 252644, 213681, 294035, 368804, 237986, 226598, 359459, 237984, 226593, 368957, 368799, 342256, 329969, 308592, 332772, 252638, 196458, 359453, 237957, 252637, 368440, 322196, 213638, 252635, 252634, 252633, 332763, 322194, 213598, 366509, 366625, 226556, 252630, 226551, 226549, 237928, 366207, 237909, 356990, 309930, 359451, 252627, 366514, 237900, 322192, 366456, 322189, 252626, 365824, 213578, 237873, 252624, 365894, 237869, 366155, 252622, 322185, 128998, 237847, 226506, 237845, 237842, 237839, 363802, 365086, 322184, 226496, 252621, 237827, 237820, 360722, 360718, 226484, 308571, 237807, 360708, 237802, 360704, 364962, 364960, 359449, 252617, 213521, 359446, 357532, 196412, 359444, 237789, 252616, 346840, 350574, 237779, 252614, 252612, 237777, 252610, 110064, 237775, 237773, 237769, 308566, 346836, 252607, 252605, 237765, 364454, 237763, 252604, 226419, 105923, 252603, 332754, 110063, 110061, 252600, 128996, 329954, 363974, 363972, 213408, 363970, 252598, 196404, 213401, 213396, 329950, 329948, 213393, 226389, 226387, 329946, 363787, 329945, 363785, 363783, 322174, 196400, 363427, 213367, 363422, 226369, 363503, 347465, 237733, 353879, 363501, 352963, 363443, 322171, 110053, 252597, 110051, 252595, 110045, 237717, 322170, 363326, 322168, 361986, 180792, 237711, 363320, 266125, 361021, 226313, 344494, 359778, 362575, 362983, 180788, 237699, 362969, 362967, 237694, 357055, 357044, 110042, 110040, 352960, 357040, 226279, 359766, 361902, 226275, 252591, 362548, 362546, 268877, 268875, 252590, 196378, 237656, 110033, 361080, 360653, 252589, 110030, 110028, 226258, 361075, 252586, 110025, 105834, 196372, 226255, 105831, 105828, 237618, 357289, 347464, 252585, 360648, 131789, 226216, 237545, 237543, 237532, 213258, 213254, 614421, 614419, 226145, 614417, 213242, 226137, 196348, 226110, 237499, 237497, 359055, 226097, 213234, 359748, 359745, 322165, 213227, 213225, 226089, 226081, 226078, 189187, 359741, 359736, 359726, 359721, 213205, 213203, 359717, 359713, 359711, 226066, 359708, 226064, 359705, 359702, 359699, 359133, 359696, 359131, 359694, 226044, 226040, 308524, 226037, 359606, 226035, 226033, 226029, 226027, 225993, 213176, 213169, 237451, 237448, 358184, 252567, 237444, 336019, 322162, 252566, 322160, 359051, 322156, 322154, 322153, 252563, 252556, 252555, 322150, 237429, 298039, 252552, 225949, 252551, 298037, 336003, 358537, 252546, 225918, 252545, 110003, 213061, 237364, 358096, 358094, 252542, 358141, 237361, 358089, 225899, 358160, 358086, 358084, 358156, 237347, 213047, 237345, 175424, 175422, 175421, 213013, 357687, 357766, 225880, 237332, 105666, 357698, 343350, 357681, 225873, 357679, 357677, 357675, 225864, 225859, 196284, 225857, 225855, 237320, 225838, 225834, 109986, 237295, 237293, 237289, 212984, 212982, 225815, 225813, 225811, 357253, 357016, 322144, 322142, 356958, 356955, 356953, 105660, 237284, 322140, 237280, 356841, 225807, 252530, 356538, 252528, 252526, 356535, 356938, 225780, 225757, 352665, 252519, 252517, 356554, 131742, 342251, 322138, 298017, 266117, 196266, 196264, 252515, 252512, 225742, 196258, 342249, 196246, 252511, 196243, 342243, 252509, 212847, 212843, 252508, 252502, 350077, 237206, 350075, 212814, 237204, 350073, 237201, 346195, 347474, 346187, 348196, 180668, 347463, 335999, 180660, 355297, 180657, 353549, 212803, 196221, 128946, 212790, 322135, 353302, 196217, 180651, 265431, 354315, 352906, 265428, 265426, 354227, 225534, 322127, 237148, 322122, 322120, 352900, 322118, 322116, 354023, 354015, 350539, 354013, 252497, 196208, 322114, 350528, 353696, 353689, 353295, 59837, 252487, 353634, 225512, 252485, 329900, 225505, 322110, 225503, 353293, 252484, 353291, 329896, 252483, 353287, 196204, 212721, 252482, 266102, 237124, 353451, 353433, 308480, 252479, 252477, 342328, 353279, 252475, 347458, 225477, 109978, 109972, 109970, 329895, 347454, 180509, 252472, 180506, 180498, 105478, 105476, 180496, 352611, 335993, 350518, 180480, 180478, 237087, 237085, 322107, 237083, 180469, 180466, 237081, 237079, 237074, 335987, 225444, 351939, 322105, 237072, 322102, 237069, 322099, 322097, 322095, 351521, 351683, 351681, 225407, 351519, 268818, 351760, 351517, 268811, 252469, 351749, 343435, 225366, 225363, 225361, 252467, 225356, 225354, 252465, 252463, 252462, 252459, 351558, 105450, 225340, 252457, 252455, 105439, 252453, 105437, 225317, 225311, 252452, 351334, 196172, 252451, 252448, 314614, 225280, 351177, 351173, 350498, 180453, 225272, 105419, 252447, 252446, 252444, 212583, 252443, 340069, 340067, 156236, 348485, 252441, 350709, 131690, 350798, 350706, 350703, 252439, 225246, 225239, 225232, 252437, 225221, 225219, 322083, 252432, 141211, 322080, 322076, 212549, 212539, 196159, 322069, 349852, 349924, 349915, 349655, 349777, 349276, 349274, 225201, 236986, 109964, 225194, 262879, 329199, 131676, 109960, 349648, 346179, 349426, 212519, 322066, 322062, 322061, 322058, 347449, 348915, 344161, 252426, 252425, 252424, 212506, 322054, 348624, 252422, 322051, 348530, 343428, 252419, 252416, 212496, 225153, 252415, 329894, 252414, 252413, 252412, 252410, 252409, 342240, 252408, 277403, 252407, 343416, 277401, 348110, 236937, 236935, 236933, 252404, 252403, 131635, 236927, 252400, 131631, 252394, 212473, 347446, 225107, 225102, 347410, 225100, 236863, 332831, 236860, 322042, 252381, 322039, 252378, 322035, 196127, 340845, 212391, 346134, 346132, 265423, 225038, 225036, 225031, 345881, 346059, 345879, 345854, 225025, 225023, 225020, 225018, 225016, 330779, 252376, 314990, 212364, 196113, 310514, 252372, 345456, 345454, 225009, 345449, 345403, 345447, 345442, 345437, 252368, 252369, 345399, 343923, 105413, 343130, 343125, 105410, 252365, 252363, 105398, 105395, 236829, 322030, 224997, 252362, 252361, 345281, 345277, 236827, 236823, 236821, 236819, 345260, 345258, 345255, 345253, 345242, 252360, 343920, 344703, 252358, 224986, 224984, 224982, 252353, 344444, 344442, 344687, 212314, 224973, 343119, 343118, 224970, 344278, 343111, 343107, 343105, 344757, 344675, 343102, 343093, 224965, 332826, 323762, 343090, 343622, 323759, 224954, 224952, 343085, 322023, 212280, 343079, 224944, 109925, 224941, 224939, 224936, 224927, 224925, 343615, 343613, 343077, 343075, 343385, 343073, 224908, 322022, 343381, 343955, 343378, 343949, 236798, 343071, 252351, 196095, 343487, 343362, 252349, 322020, 252348, 236778, 196088, 252344, 196084, 341623, 252343, 340953, 343168, 224898, 252342, 343044, 252340, 327976, 252338, 252337, 224893, 105356, 342920, 224886, 343064, 98782, 105354, 343062, 252335, 105352, 343031, 340492, 342978, 105350, 340377, 342974, 224879, 224876, 342970, 236765, 109920, 322019, 236760, 109918, 196072, 341984, 196070, 252334, 341917, 342402, 109912, 109910, 313979, 224872, 252333, 252329, 322016, 109909, 109905, 252328, 109903, 109901, 212190, 342523, 262877, 262875, 342423, 212175, 236695, 322013, 196061, 236682, 236674, 224787, 105340, 297960, 308451, 224785, 297958, 224783, 341562, 105333, 236651, 341478, 236649, 224767, 224765, 341427, 341469, 340369, 341559, 252321, 224762, 224759, 224754, 329883, 322005, 341359, 322003, 279076, 321999, 323731, 321997, 252319, 252317, 212078, 236609, 340803, 236607, 236605, 252316, 252315, 340396, 252314, 252313, 196054, 252312, 340869, 196050, 224697, 329878, 340254, 212056, 339925, 340859, 252305, 297930, 297928, 340242, 293991, 340238, 105312, 252297, 340388, 340232, 196042, 252294, 340146, 224641, 293975, 252289, 224607, 293961, 212013, 236536, 211998, 105275, 252287, 236503, 336149, 329874, 211973, 252284, 252279, 252275, 252274, 252272, 252268, 252266, 321994, 252260, 252258, 252256, 252254, 252252, 329868, 308416, 196030, 211943, 236468, 252249, 314601, 338937, 293949, 338935, 252248, 224580, 252247, 224577, 252245, 224575, 277378, 109859, 277374, 252238, 109850, 224563, 252234, 252232, 252230, 252228, 252226, 332823, 224558, 335951, 252221, 339066, 338920, 338884, 236437, 338882, 252217, 329867, 252216, 211918, 252211, 196017, 325347, 338574, 338652, 329866, 338644, 252200, 252199, 329864, 252195, 236413, 337855, 236411, 252194, 277365, 321993, 337562, 205182, 252192, 252190, 338339, 224532, 211816, 211810, 614414, 614412, 236380, 329862, 211775, 614410, 105251, 337525, 614407, 131562, 614405, 321992, 252169, 55211, 252167, 317982, 236356, 614402, 180410, 180407, 55193, 55190, 55188, 224500, 55124, 335937, 252166, 224496, 211734, 335708, 211724, 305660, 236336, 305657, 57118, 336750, 105225, 57115, 336748, 329856, 329854, 336737, 285436, 334980, 109830, 236311, 297909, 252162, 285432, 297907, 335931, 285430, 109798, 297905, 329853, 285427, 252153, 252150, 131560, 195975, 236190, 236110, 195971, 236104, 334276, 131516, 195966, 321988, 331541, 252128, 329824, 329822, 329820, 224328, 297855, 252127, 211446, 297853, 329818, 297851, 252126, 236031, 324110, 614401, 321986, 252120, 236005, 332616, 159279, 224233, 321985, 195940, 329809, 235990, 131504, 329808, 131502, 131485, 329806, 329802, 327891, 327889, 331841, 252114, 331826, 331821, 331531, 331898, 331819, 181394, 181391, 331804, 331798, 331788, 328480, 331784, 331781, 328478, 329801, 330923, 328468, 264104, 264102, 331641, 195926, 331633, 329543, 614394, 329536, 329529, 224177, 331130, 105074, 211260, 105071, 329525, 211255, 224172, 330914, 329148, 331034, 211251, 330910, 331046, 614392, 224145, 224139, 331009, 224137, 224132, 324104, 224127, 224123, 330908, 330906, 105060, 324102, 330667, 330903, 330901, 252107, 252106, 252104, 252103, 252102, 328796, 329145, 252101, 329143, 329140, 285422, 317793, 211206, 211202, 329040, 211200, 252098, 224098, 329030, 252097, 252096, 297820, 321983, 317787, 195917, 327768, 327765, 224092, 328659, 328210, 328654, 195912, 328672, 224072, 224070, 235924, 314570, 159271, 326788, 252094, 328270, 328452, 224056, 328115, 279061, 224043, 328075, 328073, 328000, 224041, 224039, 252087, 252085, 252084, 327580, 307574, 252080, 307572, 322736, 327572, 322734, 109789, 327721, 264091, 327678, 307565, 109784, 264088, 322732, 252079, 307562, 252078, 109779, 327526, 327520, 252077, 252076, 310134, 252075, 326767, 131482, 131480, 319518, 235893, 252071, 131464, 614389, 321978, 235884, 307560, 326988, 614387, 195883, 195881, 318508, 614380, 326636, 326574, 326554, 326633, 326631, 323689, 319487, 235873, 614379, 614377, 614374, 223920, 195873, 252055, 318505, 195850, 319210, 319899, 319585, 201460, 235785, 235782, 318500, 223812, 223810, 319201, 252023, 299335, 317397, 317395, 195840, 317390, 318207, 318147, 223732, 131456, 223730, 223726, 317577, 316942, 205066, 614366, 614363, 614361, 614358, 317098, 307549, 316752, 141142, 307547, 316919, 316750, 307536, 141136, 252008, 141133, 141131, 252004, 316728, 614348, 315966, 109735, 308367, 308365, 109731, 210776, 307192, 614340, 210773, 314467, 314465, 266061, 314453, 251932, 314445, 314443, 266051, 251924, 251922, 251916, 251914, 314154, 251912, 251911, 235621, 314151, 251905, 131450, 131448, 131446, 131444, 131442, 195820, 131440, 257190, 313950, 313946, 195810, 313684, 257185, 223577, 180012, 180007, 104922, 104912, 179999, 300793, 210719, 179994, 195797, 179989, 210696, 313670, 210690, 313501, 257174, 223555, 313664, 257172, 313661, 223548, 313494, 614339, 257161, 313492, 257159, 313478, 614337, 313486, 313481, 313328, 312858, 235567, 251850, 251848, 251847, 312503, 195782, 265328, 195780, 309862, 311915, 210591, 195777, 312367, 311913, 311910, 309859, 223460, 104839, 104836, 223455, 312230, 294126, 279053, 179960, 312199, 312196, 311857, 311896, 305581, 311894, 195773, 251841, 235560, 311964, 311932, 235557, 210575, 223448, 311930, 311927, 311891, 311925, 311923, 265320, 311921, 311888, 223446, 311847, 311884, 210569, 195772, 210567, 210565, 311349, 311761, 210560, 311586, 311675, 104833, 179954, 195771, 104831, 614332, 131422, 306668, 308331, 300782, 104828, 104824, 614331, 104817, 614329, 614327, 310098, 308122, 307625, 307382, 614325, 614323, 614321, 306610, 307186, 195765, 614319, 109708, 174191, 306573, 179938, 305445, 307164, 307162, 614317, 614315, 614313, 614310, 306598, 109706, 306596, 109704, 174187, 300774, 210447, 304547, 304900, 304752, 304541, 301807, 304539, 304537, 304088, 301796, 304535, 304111, 303786, 210405, 210400, 304109, 301690, 304190, 304105, 304100, 304098, 304096, 210377, 210375, 297116, 210372))
Run Time: 0.080240
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1832 | |
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 | | | | | 1832 | |
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 (30155, 28362, 18301, 18001, 32871, 17490, 16214, 16017, 15788, 15647, 15577, 15489, 15172, 15160, 15154))
Run Time: 0.001505
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 15 | 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 (574720, 562236, 485816, 561295, 562199, 244396, 252875, 233253, 244336, 233078, 244252, 233013, 554803, 232991, 551459, 232979, 232922, 219927, 552425, 108770, 552423, 552420, 551458, 551456, 551453, 551451, 551449, 551447, 551445, 551597, 265542, 551652, 525757, 551646, 232862, 347307, 232859, 551444, 551440, 548257, 219668, 219666, 229506, 229484, 229481, 451689, 229473, 448549, 418622, 448711, 448706, 449543, 229428, 448542, 198073, 229391, 449527, 423795, 449172, 110176, 449034, 241087, 241083, 241081, 448538, 229357, 241066, 423783, 229355, 241048, 241046, 110171, 110169, 448238, 229334, 229293, 229291, 229276, 423675, 229271, 229230, 229228, 229217, 229206, 229204, 240944, 240926, 229175, 229173, 240910, 422573, 422570, 422568, 422564, 229119, 229115, 240888, 229096, 420514, 420504, 420479, 420477, 420463, 420460, 240848, 420454, 375233, 240807, 107355, 107353, 107349, 229053, 419347, 419345, 614464, 614461, 614459, 614457, 418606, 418602, 240729, 418657, 418597, 418594, 418588, 240720, 216142, 229019, 417221, 417427, 374504, 240516, 367088, 413271, 240477, 614452, 412717, 228768, 228765, 228760, 205503, 228725, 322324, 228706, 228699, 228682, 409730, 215799, 215797, 228597, 228576, 228562, 614447, 614445, 614443, 405686, 405680, 397162, 401920, 240070, 401918, 406272, 406263, 240039, 401907, 404333, 107094, 401904, 401902, 401899, 401892, 401889, 401875, 110141, 401870, 401866, 401858, 401855, 401853, 401852, 401845, 401842, 401840, 228328, 107055, 188173, 322311, 405532, 228287, 110135, 405660, 310548, 322288, 391750, 227406, 385194, 252739, 252737, 196866, 227335, 238574, 238565, 238559, 238554, 294203, 238540, 377996, 238535, 382192, 382190, 382182, 382176, 238521, 238473, 322234, 238466, 322231, 238438, 238425, 227173, 227171, 252709, 354237, 346289, 346287, 238360, 238356, 294202, 294199, 214361, 294195, 227056, 376822, 196702, 227053, 359509, 196610, 332782, 374434, 372446, 372442, 291458, 226917, 196601, 238099, 331296, 359494, 359492, 362088, 362086, 362084, 359488, 106136, 362051, 213978, 213975, 213973, 213971, 213969, 238072, 238067, 254850, 344500, 360756, 326938, 359809, 332780, 372428, 226842, 226837, 360740, 196557, 252665, 252661, 371063, 322210, 360731, 252657, 226755, 360729, 196497, 359477, 226737, 226694, 226687, 226685, 370337, 226677, 213769, 226674, 213762, 252652, 363808, 180888, 329975, 252647, 265471, 265464, 265459, 237999, 252644, 213681, 294035, 368804, 237986, 226598, 359459, 237984, 226593, 368957, 368799, 342256, 329969, 308592, 332772, 252638, 196458, 359453, 237957, 252637, 368440, 322196, 213638, 252635, 252634, 252633, 332763, 322194, 213598, 366509, 366625, 226556, 252630, 226551, 226549, 237928, 366207, 237909, 356990, 309930, 359451, 252627, 366514, 237900, 322192, 366456, 322189, 252626, 365824, 213578, 237873, 252624, 365894, 237869, 366155, 252622, 322185, 128998, 237847, 226506, 237845, 237842, 237839, 363802, 365086, 322184, 226496, 252621, 237827, 237820, 360722, 360718, 226484, 308571, 237807, 360708, 237802, 360704, 364962, 364960, 359449, 252617, 213521, 359446, 357532, 196412, 359444, 237789, 252616, 346840, 350574, 237779, 252614, 252612, 237777, 252610, 110064, 237775, 237773, 237769, 308566, 346836, 252607, 252605, 237765, 364454, 237763, 252604, 226419, 105923, 252603, 332754, 110063, 110061, 252600, 128996, 329954, 363974, 363972, 213408, 363970, 252598, 196404, 213401, 213396, 329950, 329948, 213393, 226389, 226387, 329946, 363787, 329945, 363785, 363783, 322174, 196400, 363427, 213367, 363422, 226369, 363503, 347465, 237733, 353879, 363501, 352963, 363443, 322171, 110053, 252597, 110051, 252595, 110045, 237717, 322170, 363326, 322168, 361986, 180792, 237711, 363320, 266125, 361021, 226313, 344494, 359778, 362575, 362983, 180788, 237699, 362969, 362967, 237694, 357055, 357044, 110042, 110040, 352960, 357040, 226279, 359766, 361902, 226275, 252591, 362548, 362546, 268877, 268875, 252590, 196378, 237656, 110033, 361080, 360653, 252589, 110030, 110028, 226258, 361075, 252586, 110025, 105834, 196372, 226255, 105831, 105828, 237618, 357289, 347464, 252585, 360648, 131789, 226216, 237545, 237543, 237532, 213258, 213254, 614421, 614419, 226145, 614417, 213242, 226137, 196348, 226110, 237499, 237497, 359055, 226097, 213234, 359748, 359745, 322165, 213227, 213225, 226089, 226081, 226078, 189187, 359741, 359736, 359726, 359721, 213205, 213203, 359717, 359713, 359711, 226066, 359708, 226064, 359705, 359702, 359699, 359133, 359696, 359131, 359694, 226044, 226040, 308524, 226037, 359606, 226035, 226033, 226029, 226027, 225993, 213176, 213169, 237451, 237448, 358184, 252567, 237444, 336019, 322162, 252566, 322160, 359051, 322156, 322154, 322153, 252563, 252556, 252555, 322150, 237429, 298039, 252552, 225949, 252551, 298037, 336003, 358537, 252546, 225918, 252545, 110003, 213061, 237364, 358096, 358094, 252542, 358141, 237361, 358089, 225899, 358160, 358086, 358084, 358156, 237347, 213047, 237345, 175424, 175422, 175421, 213013, 357687, 357766, 225880, 237332, 105666, 357698, 343350, 357681, 225873, 357679, 357677, 357675, 225864, 225859, 196284, 225857, 225855, 237320, 225838, 225834, 109986, 237295, 237293, 237289, 212984, 212982, 225815, 225813, 225811, 357253, 357016, 322144, 322142, 356958, 356955, 356953, 105660, 237284, 322140, 237280, 356841, 225807, 252530, 356538, 252528, 252526, 356535, 356938, 225780, 225757, 352665, 252519, 252517, 356554, 131742, 342251, 322138, 298017, 266117, 196266, 196264, 252515, 252512, 225742, 196258, 342249, 196246, 252511, 196243, 342243, 252509, 212847, 212843, 252508, 252502, 350077, 237206, 350075, 212814, 237204, 350073, 237201, 346195, 347474, 346187, 348196, 180668, 347463, 335999, 180660, 355297, 180657, 353549, 212803, 196221, 128946, 212790, 322135, 353302, 196217, 180651, 265431, 354315, 352906, 265428, 265426, 354227, 225534, 322127, 237148, 322122, 322120, 352900, 322118, 322116, 354023, 354015, 350539, 354013, 252497, 196208, 322114, 350528, 353696, 353689, 353295, 59837, 252487, 353634, 225512, 252485, 329900, 225505, 322110, 225503, 353293, 252484, 353291, 329896, 252483, 353287, 196204, 212721, 252482, 266102, 237124, 353451, 353433, 308480, 252479, 252477, 342328, 353279, 252475, 347458, 225477, 109978, 109972, 109970, 329895, 347454, 180509, 252472, 180506, 180498, 105478, 105476, 180496, 352611, 335993, 350518, 180480, 180478, 237087, 237085, 322107, 237083, 180469, 180466, 237081, 237079, 237074, 335987, 225444, 351939, 322105, 237072, 322102, 237069, 322099, 322097, 322095, 351521, 351683, 351681, 225407, 351519, 268818, 351760, 351517, 268811, 252469, 351749, 343435, 225366, 225363, 225361, 252467, 225356, 225354, 252465, 252463, 252462, 252459, 351558, 105450, 225340, 252457, 252455, 105439, 252453, 105437, 225317, 225311, 252452, 351334, 196172, 252451, 252448, 314614, 225280, 351177, 351173, 350498, 180453, 225272, 105419, 252447, 252446, 252444, 212583, 252443, 340069, 340067, 156236, 348485, 252441, 350709, 131690, 350798, 350706, 350703, 252439, 225246, 225239, 225232, 252437, 225221, 225219, 322083, 252432, 141211, 322080, 322076, 212549, 212539, 196159, 322069, 349852, 349924, 349915, 349655, 349777, 349276, 349274, 225201, 236986, 109964, 225194, 262879, 329199, 131676, 109960, 349648, 346179, 349426, 212519, 322066, 322062, 322061, 322058, 347449, 348915, 344161, 252426, 252425, 252424, 212506, 322054, 348624, 252422, 322051, 348530, 343428, 252419, 252416, 212496, 225153, 252415, 329894, 252414, 252413, 252412, 252410, 252409, 342240, 252408, 277403, 252407, 343416, 277401, 348110, 236937, 236935, 236933, 252404, 252403, 131635, 236927, 252400, 131631, 252394, 212473, 347446, 225107, 225102, 347410, 225100, 236863, 332831, 236860, 322042, 252381, 322039, 252378, 322035, 196127, 340845, 212391, 346134, 346132, 265423, 225038, 225036, 225031, 345881, 346059, 345879, 345854, 225025, 225023, 225020, 225018, 225016, 330779, 252376, 314990, 212364, 196113, 310514, 252372, 345456, 345454, 225009, 345449, 345403, 345447, 345442, 345437, 252368, 252369, 345399, 343923, 105413, 343130, 343125, 105410, 252365, 252363, 105398, 105395, 236829, 322030, 224997, 252362, 252361, 345281, 345277, 236827, 236823, 236821, 236819, 345260, 345258, 345255, 345253, 345242, 252360, 343920, 344703, 252358, 224986, 224984, 224982, 252353, 344444, 344442, 344687, 212314, 224973, 343119, 343118, 224970, 344278, 343111, 343107, 343105, 344757, 344675, 343102, 343093, 224965, 332826, 323762, 343090, 343622, 323759, 224954, 224952, 343085, 322023, 212280, 343079, 224944, 109925, 224941, 224939, 224936, 224927, 224925, 343615, 343613, 343077, 343075, 343385, 343073, 224908, 322022, 343381, 343955, 343378, 343949, 236798, 343071, 252351, 196095, 343487, 343362, 252349, 322020, 252348, 236778, 196088, 252344, 196084, 341623, 252343, 340953, 343168, 224898, 252342, 343044, 252340, 327976, 252338, 252337, 224893, 105356, 342920, 224886, 343064, 98782, 105354, 343062, 252335, 105352, 343031, 340492, 342978, 105350, 340377, 342974, 224879, 224876, 342970, 236765, 109920, 322019, 236760, 109918, 196072, 341984, 196070, 252334, 341917, 342402, 109912, 109910, 313979, 224872, 252333, 252329, 322016, 109909, 109905, 252328, 109903, 109901, 212190, 342523, 262877, 262875, 342423, 212175, 236695, 322013, 196061, 236682, 236674, 224787, 105340, 297960, 308451, 224785, 297958, 224783, 341562, 105333, 236651, 341478, 236649, 224767, 224765, 341427, 341469, 340369, 341559, 252321, 224762, 224759, 224754, 329883, 322005, 341359, 322003, 279076, 321999, 323731, 321997, 252319, 252317, 212078, 236609, 340803, 236607, 236605, 252316, 252315, 340396, 252314, 252313, 196054, 252312, 340869, 196050, 224697, 329878, 340254, 212056, 339925, 340859, 252305, 297930, 297928, 340242, 293991, 340238, 105312, 252297, 340388, 340232, 196042, 252294, 340146, 224641, 293975, 252289, 224607, 293961, 212013, 236536, 211998, 105275, 252287, 236503, 336149, 329874, 211973, 252284, 252279, 252275, 252274, 252272, 252268, 252266, 321994, 252260, 252258, 252256, 252254, 252252, 329868, 308416, 196030, 211943, 236468, 252249, 314601, 338937, 293949, 338935, 252248, 224580, 252247, 224577, 252245, 224575, 277378, 109859, 277374, 252238, 109850, 224563, 252234, 252232, 252230, 252228, 252226, 332823, 224558, 335951, 252221, 339066, 338920, 338884, 236437, 338882, 252217, 329867, 252216, 211918, 252211, 196017, 325347, 338574, 338652, 329866, 338644, 252200, 252199, 329864, 252195, 236413, 337855, 236411, 252194, 277365, 321993, 337562, 205182, 252192, 252190, 338339, 224532, 211816, 211810, 614414, 614412, 236380, 329862, 211775, 614410, 105251, 337525, 614407, 131562, 614405, 321992, 252169, 55211, 252167, 317982, 236356, 614402, 180410, 180407, 55193, 55190, 55188, 224500, 55124, 335937, 252166, 224496, 211734, 335708, 211724, 305660, 236336, 305657, 57118, 336750, 105225, 57115, 336748, 329856, 329854, 336737, 285436, 334980, 109830, 236311, 297909, 252162, 285432, 297907, 335931, 285430, 109798, 297905, 329853, 285427, 252153, 252150, 131560, 195975, 236190, 236110, 195971, 236104, 334276, 131516, 195966, 321988, 331541, 252128, 329824, 329822, 329820, 224328, 297855, 252127, 211446, 297853, 329818, 297851, 252126, 236031, 324110, 614401, 321986, 252120, 236005, 332616, 159279, 224233, 321985, 195940, 329809, 235990, 131504, 329808, 131502, 131485, 329806, 329802, 327891, 327889, 331841, 252114, 331826, 331821, 331531, 331898, 331819, 181394, 181391, 331804, 331798, 331788, 328480, 331784, 331781, 328478, 329801, 330923, 328468, 264104, 264102, 331641, 195926, 331633, 329543, 614394, 329536, 329529, 224177, 331130, 105074, 211260, 105071, 329525, 211255, 224172, 330914, 329148, 331034, 211251, 330910, 331046, 614392, 224145, 224139, 331009, 224137, 224132, 324104, 224127, 224123, 330908, 330906, 105060, 324102, 330667, 330903, 330901, 252107, 252106, 252104, 252103, 252102, 328796, 329145, 252101, 329143, 329140, 285422, 317793, 211206, 211202, 329040, 211200, 252098, 224098, 329030, 252097, 252096, 297820, 321983, 317787, 195917, 327768, 327765, 224092, 328659, 328210, 328654, 195912, 328672, 224072, 224070, 235924, 314570, 159271, 326788, 252094, 328270, 328452, 224056, 328115, 279061, 224043, 328075, 328073, 328000, 224041, 224039, 252087, 252085, 252084, 327580, 307574, 252080, 307572, 322736, 327572, 322734, 109789, 327721, 264091, 327678, 307565, 109784, 264088, 322732, 252079, 307562, 252078, 109779, 327526, 327520, 252077, 252076, 310134, 252075, 326767, 131482, 131480, 319518, 235893, 252071, 131464, 614389, 321978, 235884, 307560, 326988, 614387, 195883, 195881, 318508, 614380, 326636, 326574, 326554, 326633, 326631, 323689, 319487, 235873, 614379, 614377, 614374, 223920, 195873, 252055, 318505, 195850, 319210, 319899, 319585, 201460, 235785, 235782, 318500, 223812, 223810, 319201, 252023, 299335, 317397, 317395, 195840, 317390, 318207, 318147, 223732, 131456, 223730, 223726, 317577, 316942, 205066, 614366, 614363, 614361, 614358, 317098, 307549, 316752, 141142, 307547, 316919, 316750, 307536, 141136, 252008, 141133, 141131, 252004, 316728, 614348, 315966, 109735, 308367, 308365, 109731, 210776, 307192, 614340, 210773, 314467, 314465, 266061, 314453, 251932, 314445, 314443, 266051, 251924, 251922, 251916, 251914, 314154, 251912, 251911, 235621, 314151, 251905, 131450, 131448, 131446, 131444, 131442, 195820, 131440, 257190, 313950, 313946, 195810, 313684, 257185, 223577, 180012, 180007, 104922, 104912, 179999, 300793, 210719, 179994, 195797, 179989, 210696, 313670, 210690, 313501, 257174, 223555, 313664, 257172, 313661, 223548, 313494, 614339, 257161, 313492, 257159, 313478, 614337, 313486, 313481, 313328, 312858, 235567, 251850, 251848, 251847, 312503, 195782, 265328, 195780, 309862, 311915, 210591, 195777, 312367, 311913, 311910, 309859, 223460, 104839, 104836, 223455, 312230, 294126, 279053, 179960, 312199, 312196, 311857, 311896, 305581, 311894, 195773, 251841, 235560, 311964, 311932, 235557, 210575, 223448, 311930, 311927, 311891, 311925, 311923, 265320, 311921, 311888, 223446, 311847, 311884, 210569, 195772, 210567, 210565, 311349, 311761, 210560, 311586, 311675, 104833, 179954, 195771, 104831, 614332, 131422, 306668, 308331, 300782, 104828, 104824, 614331, 104817, 614329, 614327, 310098, 308122, 307625, 307382, 614325, 614323, 614321, 306610, 307186, 195765, 614319, 109708, 174191, 306573, 179938, 305445, 307164, 307162, 614317, 614315, 614313, 614310, 306598, 109706, 306596, 109704, 174187, 300774, 210447, 304547, 304900, 304752, 304541, 301807, 304539, 304537, 304088, 301796, 304535, 304111, 303786, 210405, 210400, 304109, 301690, 304190, 304105, 304100, 304098, 304096, 210377, 210375, 297116, 210372))
Run Time: 0.035707
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1832 | |
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 | | | | | 1832 | |
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 `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 (30155, 28362, 18301, 18001, 32871, 17490, 16214, 16017, 15788, 15647, 15577, 15489, 15172, 15160, 15154))
Run Time: 0.001057
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 15 | 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 view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, u�q
Run Time: 0.000223
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: u�q, XF\Pub\Controller\Member, RecentContent, valid, user_id=3430, 1716169480, , 0, u�q
Run Time: 0.000190
- 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.000366
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.000846
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: 1716169180
Run Time: 0.000383
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 13 | 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` >= 1716169180)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000655
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 13 | 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