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.000520
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.000211
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` = '2912')
LIMIT 1
Run Time: 0.000433
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.001597
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_2912' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.123096
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 (600048, 447283, 630960, 629628, 615647, 440436, 523626, 603854, 571052, 578229, 575981, 572687, 37774, 548282, 567898, 381833, 220427, 565696, 412332, 502974, 547982, 554534, 562073, 233345, 559785, 333822, 333820, 557140, 233074, 554642, 554639, 303384, 548212, 430275, 543323, 543385, 333772, 325858, 479696, 543472, 543470, 542805, 542796, 543303, 537631, 463581, 539786, 539784, 346913, 539889, 539782, 412079, 541102, 46882, 232582, 539811, 539816, 108614, 539008, 539023, 509070, 457748, 538375, 538593, 538591, 108602, 132885, 309339, 523123, 309337, 252862, 309335, 509811, 309333, 219429, 405017, 523121, 536836, 499589, 513718, 108599, 450372, 461736, 517129, 450363, 535726, 521956, 485563, 524292, 310006, 463578, 408656, 388261, 412003, 519247, 232267, 402741, 108476, 108471, 411988, 365225, 404393, 460853, 513802, 508469, 278054, 514775, 514864, 514724, 232085, 243542, 514446, 347963, 388842, 348866, 511958, 513726, 514005, 368905, 309311, 427692, 232081, 58686, 509543, 483660, 506929, 489979, 504679, 349402, 492335, 231117, 494038, 493378, 333638, 490888, 493292, 362726, 318338, 492145, 491946, 58655, 58647, 401319, 482742, 242277, 242256, 368123, 477953, 230370, 217375, 230238, 242132, 469296, 265511, 465024, 180933, 265509, 465048, 464975, 464914, 60382, 461770, 461768, 461767, 333593, 333591, 461765, 464462, 464370, 198533, 198529, 198526, 464365, 463880, 463874, 464453, 460245, 460923, 460962, 461224, 459654, 461644, 132440, 457930, 241458, 388735, 229616, 229597, 216566, 454418, 453328, 455076, 312476, 336207, 333575, 452583, 449549, 449546, 318308, 449544, 420844, 417700, 418020, 413508, 413305, 228809, 411432, 228785, 412791, 312284, 107174, 410602, 206312, 367078, 410560, 353311, 353307, 240360, 228686, 215780, 228603, 228591, 228488, 407610, 407912, 408109, 407967, 408075, 323885, 407908, 407874, 333503, 407856, 407833, 306376, 333501, 215692, 407923, 407831, 407847, 407324, 228438, 368063, 407322, 268914, 240112, 407589, 407435, 406600, 357414, 406598, 368059, 357411, 390745, 390742, 407433, 357409, 357407, 357396, 407315, 352008, 324407, 260804, 333498, 404657, 197547, 330062, 197545, 240005, 404771, 239982, 405675, 239979, 405396, 405452, 404616, 405362, 405361, 333493, 188150, 268907, 404931, 404517, 268905, 254081, 403994, 403843, 403102, 403872, 403863, 239891, 215526, 403775, 403577, 388039, 110131, 106891, 402870, 383557, 402558, 197358, 383546, 402371, 400963, 402238, 617029, 400955, 401960, 402230, 402058, 401958, 371180, 401957, 401967, 401301, 401470, 132028, 132013, 106851, 391857, 399679, 171701, 400227, 333463, 399537, 215316, 106832, 313849, 387551, 399573, 399053, 399079, 399010, 399005, 398296, 398787, 398869, 318283, 396627, 131973, 379803, 239509, 355635, 131961, 215271, 308777, 313846, 171670, 396607, 395875, 215190, 385402, 395956, 371170, 395767, 333456, 227775, 239312, 333451, 394645, 131914, 393259, 393417, 239257, 227712, 215094, 393597, 389085, 389966, 239231, 393126, 227689, 227685, 320364, 392520, 389442, 391845, 392515, 392564, 389779, 389964, 308775, 239189, 392295, 239181, 255247, 391667, 382097, 391966, 389772, 390728, 390108, 391690, 383780, 391775, 391398, 390927, 388696, 385509, 227622, 387709, 278040, 227606, 389958, 390705, 390282, 374327, 374325, 308760, 238991, 366987, 106532, 389754, 389467, 389429, 387158, 388649, 389543, 308750, 268896, 227577, 389367, 308734, 385380, 387586, 387219, 387092, 308707, 386202, 214797, 348356, 348349, 238781, 238776, 386215, 382758, 385621, 227421, 386187, 348308, 348304, 238729, 348293, 214754, 385615, 384785, 385545, 385543, 384956, 214721, 385211, 385193, 227382, 348261, 227369, 94279, 374323, 214655, 384653, 238584, 383359, 278021, 383351, 616463, 383131, 382945, 382752, 382361, 377425, 333435, 348260, 366932, 347618, 381712, 214461, 333428, 378538, 371152, 381460, 381438, 381334, 238469, 333422, 381329, 19792, 19791, 381326, 381427, 381249, 377773, 348255, 381318, 377952, 381176, 379406, 381173, 378670, 77385, 379495, 254855, 379413, 271353, 379319, 308652, 378642, 379056, 318271, 379095, 356896, 379091, 377108, 271349, 378994, 358335, 358329, 378810, 318267, 378713, 378657, 378484, 377973, 377796, 377819, 354331, 131856, 378007, 305676, 305674, 377541, 333414, 333412, 377633, 376482, 238350, 131838, 377790, 131835, 106314, 131832, 377758, 368611, 361316, 377763, 57781, 294201, 377149, 348253, 377639, 377419, 376940, 376992, 238328, 355501, 377088, 377440, 106283, 376989, 376924, 376547, 377139, 376682, 375731, 373082, 377085, 377090, 365712, 374638, 376894, 376856, 238293, 376965, 376884, 308650, 376637, 299842, 376474, 376619, 376588, 376587, 376578, 376470, 375120, 373967, 376543, 374826, 375944, 226971, 348671, 333410, 318881, 327043, 308643, 306794, 375863, 375899, 278016, 375469, 214248, 369326, 308631, 308629, 214221, 374859, 214219, 373707, 375112, 375017, 374984, 373686, 374522, 373224, 238121, 374932, 374806, 374763, 214128, 374617, 374607, 141873, 374381, 374380, 374371, 372212, 374305, 371248, 374167, 373346, 370207, 372669, 372721, 372195, 372652, 372713, 368978, 372639, 372637, 372189, 372615, 372613, 330013, 371065, 372342, 372103, 372098, 371276, 371273, 366726, 371270, 368646, 369663, 371062, 371357, 370996, 302988, 362612, 106074, 370994, 371110, 371108, 370959, 371102, 368644, 361664, 366881, 371048, 371058, 362603, 370390, 371056, 370983, 348659, 348251, 310329, 226794, 370388, 226792, 348247, 180895, 106047, 366313, 368880, 366872, 366311, 359808, 362837, 347833, 347827, 226740, 226736, 326930, 213705, 369512, 370009, 369957, 180884, 140305, 367769, 369476, 326897, 226600, 368805, 369364, 252642, 368972, 366182, 369283, 368600, 368935, 291446, 368946, 368484, 310323, 237976, 368479, 368597, 213674, 367928, 368475, 368929, 368740, 368738, 316694, 366093, 368926, 368718, 316692, 368667, 213663, 368873, 363966, 368590, 252639, 213655, 366867, 334082, 363960, 368812, 368790, 368583, 368703, 368551, 368548, 367965, 368443, 364080, 368337, 368429, 357807, 368323, 368321, 367992, 106031, 226573, 213620, 213618, 367954, 343277, 363527, 213599, 366786, 365874, 366432, 366468, 366671, 364770, 364764, 366486, 365602, 366480, 366478, 272045, 332352, 105993, 365438, 105986, 365434, 365429, 365572, 365571, 308580, 226493, 365781, 365643, 364732, 364419, 44906, 213547, 365523, 364635, 303210, 237801, 303202, 362504, 364950, 357389, 357386, 110067, 131809, 357382, 361027, 131807, 357380, 364941, 332338, 303197, 364887, 357373, 364932, 364056, 357368, 364054, 357366, 364930, 357364, 303195, 364881, 237788, 213500, 364050, 357360, 357353, 357350, 213491, 364660, 213489, 213488, 360173, 364658, 364655, 364631, 357952, 364723, 364712, 364040, 364707, 357950, 364036, 364629, 44897, 308563, 364502, 364425, 364345, 364423, 364340, 318877, 237755, 303171, 237751, 303168, 213463, 303165, 308554, 353396, 364334, 353393, 363297, 363400, 364285, 44885, 105907, 131803, 343275, 364063, 237726, 363498, 348246, 333363, 333361, 333359, 363317, 196385, 128987, 356389, 237706, 363278, 361651, 308536, 357348, 23342, 362939, 363264, 226331, 362907, 363276, 213322, 213319, 362959, 357345, 265439, 361159, 321674, 361433, 180773, 341383, 180769, 180767, 341381, 180765, 362825, 362640, 358596, 207525, 361151, 360662, 360418, 361753, 8482, 237627, 237615, 361502, 361424, 360645, 360643, 346609, 361360, 331263, 237572, 226232, 361356, 348243, 360641, 344243, 226205, 344239, 360851, 361172, 348842, 360827, 360821, 360817, 333355, 356767, 335782, 346803, 360315, 359372, 318264, 226128, 360313, 360282, 360556, 347810, 350317, 333345, 226116, 306271, 226113, 360551, 333341, 226108, 359332, 358937, 359202, 359330, 360324, 353552, 333335, 359367, 360389, 360407, 360374, 306269, 333332, 359737, 359421, 360160, 347799, 44876, 360158, 359416, 347797, 360154, 359321, 350310, 56797, 359277, 359645, 359714, 360178, 327153, 303085, 359571, 359128, 359636, 308527, 308525, 359631, 226030, 303081, 189752, 359552, 359361, 213185, 359545, 237469, 213170, 359013, 359155, 44858, 358993, 17708, 357802, 358657, 213076, 279820, 358533, 352440, 352801, 358605, 358506, 355539, 358305, 357576, 358303, 357032, 358020, 357343, 357825, 357338, 252536, 357335, 354204, 352797, 252532, 357333, 357331, 357329, 225866, 357327, 357324, 357318, 355473, 319232, 357258, 237318, 180734, 329905, 357489, 357526, 357487, 357485, 357473, 357504, 355463, 357288, 356970, 237304, 357483, 357481, 357479, 357317, 352791, 212993, 357285, 348229, 357315, 357313, 357312, 357306, 355524, 355458, 333301, 333299, 357249, 333295, 355455, 352785, 356852, 156909, 357183, 355442, 337398, 356741, 356929, 348220, 131746, 212941, 212937, 352659, 131739, 355094, 306038, 352657, 354836, 309902, 309900, 356529, 348217, 237254, 356326, 342246, 355092, 131733, 131726, 356469, 333286, 356399, 330787, 333283, 356398, 356212, 212825, 355427, 346199, 356194, 355422, 180676, 191761, 354184, 350060, 348201, 12606, 355298, 325727, 225596, 348199, 348193, 355322, 345056, 355320, 355317, 180669, 225586, 354613, 355303, 351979, 180664, 348837, 212804, 354070, 355162, 212791, 353546, 355079, 253494, 346778, 353303, 355077, 353543, 354697, 353541, 354695, 353301, 353539, 353916, 354685, 354682, 354680, 333276, 354777, 258506, 348821, 35092, 105604, 333272, 348182, 237151, 354228, 354257, 354010, 207491, 353748, 333266, 267253, 180597, 353825, 315638, 353959, 237145, 180591, 353901, 333263, 105551, 105549, 333259, 353713, 353897, 353711, 353957, 353818, 353773, 294171, 294169, 353677, 294167, 36918, 353522, 346771, 346769, 353490, 353471, 350904, 352889, 353288, 225492, 353455, 353453, 351530, 347627, 353450, 308478, 347625, 308476, 352852, 353284, 353408, 353406, 353282, 351528, 353387, 352429, 353232, 350728, 352634, 105499, 352985, 352831, 352824, 352980, 352940, 352938, 352845, 352865, 352861, 352842, 105481, 352820, 352482, 105473, 352746, 105469, 352744, 105468, 105463, 180491, 352472, 352603, 352606, 352462, 352051, 349325, 225389, 237033, 351755, 338594, 237031, 351514, 338777, 351416, 350386, 212626, 346752, 212623, 338772, 225352, 351604, 351459, 351662, 212607, 299827, 351615, 351454, 351588, 351582, 351578, 351442, 334288, 351551, 351576, 351111, 351507, 351109, 351151, 351395, 212597, 338581, 350119, 351333, 351389, 351382, 351323, 303050, 350185, 344167, 344164, 350040, 348772, 349862, 112992, 351286, 351279, 59827, 212593, 225288, 225286, 341294, 348769, 350819, 321670, 277438, 333249, 350033, 350943, 350940, 333242, 333240, 333238, 333237, 333235, 131706, 350936, 333233, 333230, 131701, 131699, 350116, 277425, 350927, 131695, 131693, 277415, 350114, 350855, 350921, 350840, 225252, 327145, 131688, 350705, 350207, 350421, 350402, 225229, 350400, 225223, 350360, 350356, 306006, 350354, 350290, 350196, 349284, 347575, 212541, 350102, 59823, 299677, 335237, 331235, 348380, 348157, 347560, 347558, 299640, 349353, 348155, 348148, 299638, 299636, 313658, 347552, 346730, 348141, 348709, 348538, 277405, 344237, 212495, 348128, 348125, 348123, 236931, 348102, 348100, 277399, 345085, 277397, 131637, 156234, 308470, 277393, 252399, 277391, 348023, 348025, 346558, 58371, 343406, 347471, 277388, 334721, 277385, 277382, 252391, 347226, 347026, 131628, 347221, 344003, 140295, 131611, 140293, 131590, 345981, 316902, 347134, 343997, 308463, 308461, 308459, 346745, 273844, 344201, 252384, 346742, 346740, 344196, 321640, 225059, 268471, 268469, 268467, 308456, 346627, 346619, 346542, 212432, 346616, 346538, 212404, 346611, 212402, 346438, 346606, 346604, 346413, 345488, 346406, 212389, 346067, 345877, 346031, 345425, 268494, 345475, 345872, 23338, 345867, 330780, 345726, 252371, 345458, 344970, 344967, 319344, 345433, 345444, 345440, 345393, 105405, 236833, 212330, 345299, 105374, 212323, 344911, 310210, 212319, 345009, 345283, 310208, 345264, 345198, 345143, 344957, 344955, 224977, 342679, 344753, 344788, 236814, 212292, 342652, 343050, 337454, 224919, 343549, 343503, 343170, 343186, 224887, 308453, 340500, 98781, 296701, 98779, 343036, 194050, 331882, 342634, 342632, 310167, 310164, 310162, 338754, 337947, 339561, 212217, 212212, 224868, 339473, 212206, 212204, 342550, 212189, 342527, 212187, 342520, 342511, 342501, 342499, 342486, 236734, 340484, 236730, 342378, 212158, 236686, 342033, 340372, 342031, 236676, 341791, 341958, 341609, 341895, 339530, 341934, 339555, 339513, 341879, 341867, 236670, 236667, 341856, 236664, 224793, 337858, 333172, 224790, 236661, 308442, 252325, 252322, 236653, 236646, 341430, 341631, 341473, 105331, 615276, 212123, 341464, 341627, 341445, 212094, 212091, 341424, 23308, 341280, 303802, 341422, 252320, 341435, 341434, 341397, 341412, 341411, 341432, 341420, 341405, 341394, 341392, 341356, 341352, 23300, 212075, 340547, 340001, 339999, 341273, 341324, 341271, 340288, 341041, 341268, 331150, 341039, 297936, 341256, 180441, 341264, 224718, 265422, 341171, 212060, 236595, 340990, 340994, 224686, 340922, 340971, 340811, 273816, 340721, 252300, 294008, 308423, 236558, 340285, 340203, 212032, 224652, 340597, 340599, 294150, 294145, 339964, 340505, 340450, 340275, 339111, 224631, 105298, 105288, 339981, 339919, 323711, 339993, 339911, 211961, 105267, 105264, 336137, 339649, 339645, 180430, 338426, 338335, 211905, 180425, 180422, 211881, 236404, 224512, 338052, 337874, 252171, 224510, 335640, 180404, 180387, 337292, 305659, 337217, 236331, 224483, 161694, 337107, 333137, 161690, 337210, 224476, 337257, 337208, 337255, 337251, 105235, 337087, 318432, 336908, 336900, 336357, 336893, 336676, 252161, 336671, 335930, 335803, 252158, 333132, 335801, 336087, 252145, 131557, 252143, 335086, 335296, 137936, 335061, 105175, 8474, 105171, 236092, 315614, 236090, 315612, 315609, 334749, 332994, 131518, 211498, 268113, 334765, 334841, 211495, 334263, 300816, 334240, 128903, 334718, 334670, 333125, 292105, 334237, 334302, 334271, 334061, 332663, 334252, 265339, 211469, 334208, 332661, 334220, 334218, 334207, 334214, 334212, 334203, 334175, 332968, 333074, 324487, 105124, 331746, 300811, 236054, 236052, 314133, 334127, 314131, 333119, 314129, 332631, 331156, 105116, 333062, 332880, 332527, 332868, 277317, 236024, 327283, 332250, 332248, 312470, 252117, 131487, 332162, 29991, 282741, 327888, 194110, 331913, 181410, 331871, 306264, 331032, 330558, 329436, 235940, 252099, 319489, 285420, 329031, 137932, 328618, 328673, 137926, 224071, 159272, 326840, 328200, 252091, 252088, 328135, 328001, 327998, 327723, 205105, 327054, 326623, 258851, 327017, 327400, 326766, 327393, 327115, 305633, 305631, 131471, 252072, 131466, 327012, 327113, 252068, 305623, 224026, 264079, 264075, 266088, 326551, 326589, 194515, 326587, 311643, 194513, 326549, 326547, 252064, 326541, 323691, 318420, 223996, 318417, 288596, 319185, 288594, 320250, 325442, 211118, 306901, 323686, 325570, 277298, 318253, 235871, 318251, 318248, 325282, 318242, 260915, 252061, 318240, 260913, 211110, 252057, 325280, 264069, 325920, 180291, 128868, 325913, 320102, 325910, 325598, 223938, 325582, 325232, 325230, 325227, 211100, 324468, 324465, 323674, 180263, 180255, 180252, 180246, 323671, 321854, 314558, 211068, 321604, 260906, 202618, 321779, 307555, 202605, 211058, 321761, 321774, 299815, 260904, 202602, 223859, 321597, 319006, 252043, 252041, 321456, 321281, 211018, 321454, 321405, 321348, 319000, 320093, 320222, 321248, 318648, 311998, 320086, 320081, 313301, 189610, 319603, 318406, 201458, 318404, 201456, 299801, 319509, 319580, 319427, 319374, 319425, 210983, 319302, 319300, 235765, 311238, 319179, 319204, 317075, 318994, 318992, 223770, 223768, 318498, 235754, 235197, 277969, 223756, 318811, 318803, 318742, 317474, 318400, 311991, 318794, 318787, 318735, 318785, 311988, 210913, 318165, 223740, 317061, 318462, 260877, 318210, 318458, 235742, 318492, 318456, 307553, 307551, 180148, 180146, 318148, 318395, 318394, 318205, 318203, 316316, 318201, 318389, 318198, 316314, 318387, 318195, 318135, 317592, 316310, 131460, 314544, 316958, 317387, 317385, 317564, 318084, 180139, 317562, 180137, 317559, 235736, 317557, 23276, 317552, 312698, 312696, 317548, 317546, 312694, 317544, 23272, 317043, 316938, 316934, 252013, 317376, 317375, 18753, 300729, 317467, 141137, 316852, 316851, 252005, 316303, 316301, 180093, 316839, 252000, 251997, 251996, 251993, 251990, 173245, 180091, 307466, 316061, 312741, 312739, 180085, 266077, 316704, 316745, 316743, 210857, 316111, 41204, 316284, 251984, 316278, 223699, 210847, 311723, 235695, 210834, 315968, 316027, 251980, 316004, 251974, 308368, 308366, 223654, 315558, 260866, 315547, 180059, 180056, 260864, 223652, 210783, 315478, 315359, 315313, 315309, 315304, 251958, 251954, 251950, 251948, 104972, 104966, 104962, 315173, 104957, 210767, 104955, 104951, 315171, 104948, 180038, 180037, 314876, 314368, 251942, 265330, 312528, 104940, 104934, 104929, 314499, 314098, 266058, 251940, 210752, 314096, 307720, 313464, 266053, 313413, 314363, 313410, 314356, 235640, 251926, 251918, 313439, 251915, 313436, 314090, 210738, 314159, 313988, 313985, 223591, 314024, 251904, 251900, 195804, 235593, 313812, 312526, 312524, 312521, 300794, 251887, 251884, 251882, 311713, 235583, 277279, 277274, 313403, 313401, 311705, 313376, 313399, 210675, 257175, 313616, 308357, 195792, 304680, 257157, 313584, 313336, 313394, 312569, 313372, 312781, 313367, 304674, 251867, 313388, 313356, 312850, 313299, 188663, 310360, 313095, 308338, 312378, 313092, 312376, 195786, 294137, 310605, 179973, 312819, 260856, 223535, 223533, 294134, 311369, 311367, 294131, 294128, 312857, 311363, 312817, 312719, 312717, 312814, 312843, 312800, 312775, 210638, 312772, 210634, 210632, 312839, 104861, 312811, 312836, 312809, 312807, 312770, 311455, 312791, 312768, 311978, 312259, 312766, 311976, 312761, 312759, 312680, 251853, 312550, 179965, 251851, 223513, 223509, 312674, 312394, 210610, 223505, 311947, 308139, 179963, 223484, 312242, 104842, 311919, 205055, 210595, 305594, 312235, 305591, 311900, 311669, 312116, 305584, 251839, 251838, 311844, 311772, 210557, 235547, 179952, 311447, 311445, 311421, 311343, 311385, 311373, 311340, 311314, 311328, 311304, 311302, 311300, 235544, 307442, 310674, 310672, 235539, 307404, 311215, 307844, 310462, 311115, 311206, 131424, 311106, 131421, 311087, 310459, 308333, 300785, 310657, 310628, 310653, 251829, 310624, 210522, 104819, 310351, 310350, 308328, 308321, 307233, 308318, 310473, 307230, 223414, 223412, 223407, 104804, 310125, 87663, 264011, 272957, 272956, 272954, 308302, 310123, 272952, 310094, 310092, 264005, 283291, 260852, 306649, 302983, 306637, 307652, 307680, 307678, 307834, 307482, 307676, 307220, 307829, 307827, 305483, 307664, 210509, 305479, 307650, 307363, 307345, 307336, 305451, 305817, 307272, 307115, 307008, 307001, 306999, 251794, 264001, 179927, 223349, 235509, 306710, 306708, 251789, 223333, 179923, 223314, 306169, 306199, 306196, 306143, 123452, 251780, 251778, 179918, 305857, 210480, 305851, 305846, 305731, 279036, 305725, 299542, 299538, 210457, 223271, 305529, 305391, 303678, 251758, 263483, 179885, 179884, 251754, 251753, 195744, 195742, 305271, 160796, 305266, 223233, 305073, 305048, 305046, 304963, 304929, 305004, 251731, 251726, 301804, 301799, 251723, 179882, 301614, 304532, 210403, 251719, 179879, 251717, 263991, 304512, 304471, 131417, 304076, 299784, 299782, 301613, 251710, 251706, 303031, 210368, 251703, 251701, 251698, 301925, 179861, 302631, 179860, 294624, 302887, 302582, 302577, 294618, 302575, 291429, 160790, 302565, 302479, 210326, 296216, 302247, 179838, 301054, 301641, 301639, 104788, 300984, 104786, 104783, 299749, 251666, 251663, 301599, 301597, 251654, 104777, 251651, 251646, 301144, 301253, 251632, 235426, 301034, 251628, 210244, 296195, 299730, 251623, 251621, 251617, 299863, 298411, 263988, 251613, 263986, 251610, 251606, 296249, 299460, 299456, 299454, 299448, 299867, 299612, 251600, 251582, 295956, 195720, 104751, 298877, 296007, 179803, 298401, 297645, 251580, 251578, 210189, 104733, 223149, 251576, 298393, 223139, 223137, 298391, 297638, 297636, 297634, 297632, 297627, 179794, 297622, 298282, 297615, 179774, 179771, 179769, 179767, 251564, 179765, 297613, 179763, 298194, 210129, 297746, 251560, 297143, 131391, 131389, 131387, 251558, 296679, 210063, 294613, 235416, 251554, 294990, 294988, 131359, 179732, 295935, 295929, 295747, 195696, 251552, 293918, 271244, 179728, 295265, 251536, 277150, 295261, 295259, 295256, 251527, 251525, 251520, 251516, 291952, 131351, 294782, 251511, 251507, 251504, 251500, 294720, 294717, 294975, 294274, 294973, 141103, 294712, 294777, 294704, 287676, 294698, 294682, 294679, 294677, 294672, 294675, 104716, 294579, 16973, 204996, 294502, 294419, 293896, 179709, 294107, 294105, 292870, 179701, 294074, 293859, 294069, 294068, 294062, 293852, 293846, 179696, 287673, 195678, 293769, 291422, 131305, 179693, 291402, 291496, 291265, 291263, 256312, 131289, 290366, 104573, 290332, 104571, 278887, 251479, 290299, 289265, 289262, 251477, 251473, 288855, 122623, 251470, 179638, 287960, 287958, 287955, 179623, 285774, 251460, 179619, 287794, 287775, 251459, 131274, 131272, 287517, 179588, 223093, 287321, 287515, 266847, 287315, 189592, 251458, 179526, 195658, 161451, 278874, 251455, 179516, 284598, 284569, 271061, 277579, 179373, 43809, 179362, 277113, 179359, 273246, 263473, 276450, 179358, 223083, 179334, 251445, 277038, 179327, 271048, 271044, 271042, 275741, 276570, 263969, 276415, 276412, 276411, 156859, 274813, 179313, 273231, 273222, 195652, 272939, 266816, 104434, 104387, 179205, 104370, 260786, 179187, 270971, 179186, 268606, 179177, 179176, 179171, 179169, 270778, 104299, 266261, 270645, 209542, 207486, 269464, 174140, 223020, 174138, 174136, 179042, 179022, 260782, 270019, 251423, 270275, 251422, 260780, 270204, 270202, 270200, 270198, 270132, 178910, 178908, 269653, 178900, 178898, 122611, 251420, 269825, 269823, 269622, 269462, 269460, 269150, 269455, 269480, 143013, 269453, 269146, 178833, 269402, 269271, 269269, 269138, 178823, 178797, 178795, 178793, 268803, 268801, 222962, 178789, 209405, 178755, 184536, 178723, 268362, 268444, 268430, 268442, 178712, 178710, 178702, 268345, 267836, 266304, 178683, 178680, 178678, 264960, 266299, 178670, 261955, 261950, 264954, 178612, 268232, 268229, 178611, 268225, 178609, 267772, 209375, 267100, 178606, 267770, 178603, 254435, 268094, 267970, 182949, 182947, 182945, 268079, 266542, 268077, 209369, 267764, 267019, 267760, 178601, 267755, 178598, 266295, 267094, 178593, 178592, 178590, 178589, 178587, 267092, 267653, 266291, 267968, 209365, 267649, 267089, 267977, 267958, 267956, 266911, 266909, 267001, 178524, 131216, 263877, 266859, 263305, 178479, 266768, 266646, 266716, 266710, 265610, 109572, 109570, 266533, 109568, 178458, 209343, 260775, 266577, 209340, 266631, 131188, 209337, 251418, 260772, 256291, 178277, 256290, 256289, 256287, 168857, 261369, 258274, 178087, 178085, 265141, 178079, 35701, 131170, 178073, 178071, 178069, 131162, 178067, 178065, 261859, 140978, 265082, 178058, 265079, 261854, 178043, 186788, 257414, 186760, 257401, 257399, 178008, 257395, 257391, 177992, 177990, 177988, 260411, 260409, 177978, 257550, 186746, 177965, 177958, 177956, 177954, 264896, 177951, 264994, 104219, 258258, 177897, 195621, 264591, 177893, 264587, 177836, 262160, 177835, 177834, 177829, 262156, 177826, 177822, 264180, 263727, 177783, 263866, 263750, 263203, 182932, 260753, 186698, 262939, 177652, 177649, 262555, 186687, 177629, 177627, 131128, 262618, 177625, 262516, 262034, 262514, 262902, 131123, 262510, 262609, 262608, 177617, 262505, 251353, 257723, 177608, 177605, 262271, 177603, 262121, 177602, 257722, 209247, 257719, 262364, 177599, 222929, 222927, 177597, 262358, 222921, 186678, 131121, 255715, 255714, 202569, 254430, 82172, 82170, 255710, 209223, 261924, 261798, 255707, 251330, 82166, 262087, 318888, 131100, 251326, 131098, 131096, 261920, 131093, 255701, 175693, 257717, 262055, 261584, 255698, 222914, 256286, 256283, 177492, 255686, 261706, 177489, 254420, 255683, 255681, 177469, 254416, 251315, 254414, 251313, 251311, 260733, 251309, 260692, 182919, 256267, 177453, 177452, 177442, 177437, 261406, 257714, 177433, 131070, 131067, 177432, 260315, 177428, 140959, 140954, 257710, 261578, 186636, 177421, 186634, 186630, 177418, 260292, 260288, 260286, 177417, 140946, 131059, 177416, 140943, 258419, 250706, 261490, 257708, 131057, 177407, 186627, 186625, 104177, 261478, 186624, 177402, 186622, 222904, 257705, 104173, 209196, 260685, 259638, 209194, 177383, 257692, 177379, 177374, 222893, 177369, 177368, 257689, 251293, 186609, 131041, 131039, 177350, 177349, 177347, 177328, 257684, 177317, 257682, 260725, 209173, 222147, 186584, 260717, 177308, 260985, 260715, 195584, 177306, 177304, 131035, 177303, 235340, 261118, 122587, 261017, 104130, 131023, 104128, 131021, 261015, 131019, 177300, 104126, 131014, 104080, 177284, 131008, 186563, 131005, 235288, 186561, 259626, 177195, 260015, 177193, 260012, 260010, 195576, 186540, 259892, 206990, 206988, 259624, 259941, 206982, 204517, 209128, 249394, 204515, 259982, 258813, 259864, 259938, 258799, 259925, 259919, 259402, 255362, 204505, 258910, 104065, 186516, 128856, 186505, 259673, 259747, 258014, 258012, 259614, 259744, 259742, 258010, 259737, 204495, 204493, 186501, 259610, 259572, 186499, 14526, 259606, 259183, 259604, 259181, 259431, 258944, 259570, 259270, 186492, 259266, 259598, 177100, 259567, 195574, 259397, 177097, 177094, 251270, 177092, 259395, 259393, 195570, 186488, 195567, 104033, 259476, 259168, 195535, 222888, 259324, 259237, 259251, 259233, 186437, 186434, 258940, 258961, 176984, 258933, 258982, 258980, 258848, 258896, 258894, 209106, 258958, 258846, 209094, 222866, 209092, 175690, 257364, 258583, 258581, 257678, 251264, 258575, 186411, 256746, 186409, 251262, 258526, 258562, 258442, 143523, 203638, 258606, 195525, 195523, 256146, 143521, 258485, 256143, 258437, 258602, 258433, 258521, 195514, 204646, 255651, 176929, 257055, 176927, 195505, 209079, 258379, 253097, 257045, 176903, 258193, 257336, 256845, 257331, 176889, 130968, 176884, 257325, 257320, 130967, 130964, 258178, 140938, 258176, 257846, 257844, 130961, 248659, 130959, 248657, 203947, 176878, 176875, 195490, 203945, 248655, 176872, 195488, 195485, 195481, 248652, 203943, 248648, 248646, 248644, 257830, 195477, 257905, 258132, 258032, 258188, 249622, 195469, 257813, 257810, 257808, 257794, 257791, 222854, 222848, 222845, 222842, 222838, 257304, 257669, 222836, 257300, 195466, 257666, 195465, 195463, 255987, 195461, 222829, 257037, 195457, 255984, 195455, 195452, 257657, 249618, 257034, 195450, 195448, 257655, 195446, 176807, 176805, 257278, 176803, 257032, 257649, 257644, 257639, 255605, 222799, 186400, 122565, 251237, 122563, 251235, 257026, 186398, 249803, 204949, 204947, 186395, 204945, 257021, 257272, 255593, 204943, 257270, 204941, 249800, 257268, 257512, 257546, 256433, 257481, 255585, 256616, 256613, 195444, 209005, 256611, 256981, 186388, 186386, 256246, 186384, 256908, 254263, 130949, 208969, 256323, 256076, 256424, 255917, 256333, 130943, 256420, 256255, 176748, 256036, 130921, 250910, 256004, 255147, 255145, 208961, 255994, 255992, 130915, 249046, 255967, 255965, 222774, 255899, 222772, 255193, 130897, 222755, 130895, 255554, 130893, 130891, 130888, 130886, 130882, 255545, 222752, 130877, 255779, 104016, 255433, 255431, 130853, 130850, 254890, 195423, 254965, 195419, 195417, 195415, 254882, 206651, 130818, 130816, 253342, 253165, 192114, 253030, 253005, 253004, 249643, 195396, 176505, 206614, 206610, 176403, 176402, 206608, 176399, 130757, 130748, 204554, 150492, 128806, 208621, 128801))
Run Time: 0.216813
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3447 | |
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 | | | | | 3447 | |
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 (33997, 30210, 29401, 27501, 22976, 20503, 33159, 18064, 17835, 16940, 16915, 16914, 15817, 15806, 15786, 15697, 15393, 15169, 14949, 14846, 13750, 13694, 13219, 13113, 13112, 12999))
Run Time: 0.001929
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 26 | 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 (600048, 447283, 630960, 629628, 615647, 440436, 523626, 603854, 571052, 578229, 575981, 572687, 37774, 548282, 567898, 381833, 220427, 565696, 412332, 502974, 547982, 554534, 562073, 233345, 559785, 333822, 333820, 557140, 233074, 554642, 554639, 303384, 548212, 430275, 543323, 543385, 333772, 325858, 479696, 543472, 543470, 542805, 542796, 543303, 537631, 463581, 539786, 539784, 346913, 539889, 539782, 412079, 541102, 46882, 232582, 539811, 539816, 108614, 539008, 539023, 509070, 457748, 538375, 538593, 538591, 108602, 132885, 309339, 523123, 309337, 252862, 309335, 509811, 309333, 219429, 405017, 523121, 536836, 499589, 513718, 108599, 450372, 461736, 517129, 450363, 535726, 521956, 485563, 524292, 310006, 463578, 408656, 388261, 412003, 519247, 232267, 402741, 108476, 108471, 411988, 365225, 404393, 460853, 513802, 508469, 278054, 514775, 514864, 514724, 232085, 243542, 514446, 347963, 388842, 348866, 511958, 513726, 514005, 368905, 309311, 427692, 232081, 58686, 509543, 483660, 506929, 489979, 504679, 349402, 492335, 231117, 494038, 493378, 333638, 490888, 493292, 362726, 318338, 492145, 491946, 58655, 58647, 401319, 482742, 242277, 242256, 368123, 477953, 230370, 217375, 230238, 242132, 469296, 265511, 465024, 180933, 265509, 465048, 464975, 464914, 60382, 461770, 461768, 461767, 333593, 333591, 461765, 464462, 464370, 198533, 198529, 198526, 464365, 463880, 463874, 464453, 460245, 460923, 460962, 461224, 459654, 461644, 132440, 457930, 241458, 388735, 229616, 229597, 216566, 454418, 453328, 455076, 312476, 336207, 333575, 452583, 449549, 449546, 318308, 449544, 420844, 417700, 418020, 413508, 413305, 228809, 411432, 228785, 412791, 312284, 107174, 410602, 206312, 367078, 410560, 353311, 353307, 240360, 228686, 215780, 228603, 228591, 228488, 407610, 407912, 408109, 407967, 408075, 323885, 407908, 407874, 333503, 407856, 407833, 306376, 333501, 215692, 407923, 407831, 407847, 407324, 228438, 368063, 407322, 268914, 240112, 407589, 407435, 406600, 357414, 406598, 368059, 357411, 390745, 390742, 407433, 357409, 357407, 357396, 407315, 352008, 324407, 260804, 333498, 404657, 197547, 330062, 197545, 240005, 404771, 239982, 405675, 239979, 405396, 405452, 404616, 405362, 405361, 333493, 188150, 268907, 404931, 404517, 268905, 254081, 403994, 403843, 403102, 403872, 403863, 239891, 215526, 403775, 403577, 388039, 110131, 106891, 402870, 383557, 402558, 197358, 383546, 402371, 400963, 402238, 617029, 400955, 401960, 402230, 402058, 401958, 371180, 401957, 401967, 401301, 401470, 132028, 132013, 106851, 391857, 399679, 171701, 400227, 333463, 399537, 215316, 106832, 313849, 387551, 399573, 399053, 399079, 399010, 399005, 398296, 398787, 398869, 318283, 396627, 131973, 379803, 239509, 355635, 131961, 215271, 308777, 313846, 171670, 396607, 395875, 215190, 385402, 395956, 371170, 395767, 333456, 227775, 239312, 333451, 394645, 131914, 393259, 393417, 239257, 227712, 215094, 393597, 389085, 389966, 239231, 393126, 227689, 227685, 320364, 392520, 389442, 391845, 392515, 392564, 389779, 389964, 308775, 239189, 392295, 239181, 255247, 391667, 382097, 391966, 389772, 390728, 390108, 391690, 383780, 391775, 391398, 390927, 388696, 385509, 227622, 387709, 278040, 227606, 389958, 390705, 390282, 374327, 374325, 308760, 238991, 366987, 106532, 389754, 389467, 389429, 387158, 388649, 389543, 308750, 268896, 227577, 389367, 308734, 385380, 387586, 387219, 387092, 308707, 386202, 214797, 348356, 348349, 238781, 238776, 386215, 382758, 385621, 227421, 386187, 348308, 348304, 238729, 348293, 214754, 385615, 384785, 385545, 385543, 384956, 214721, 385211, 385193, 227382, 348261, 227369, 94279, 374323, 214655, 384653, 238584, 383359, 278021, 383351, 616463, 383131, 382945, 382752, 382361, 377425, 333435, 348260, 366932, 347618, 381712, 214461, 333428, 378538, 371152, 381460, 381438, 381334, 238469, 333422, 381329, 19792, 19791, 381326, 381427, 381249, 377773, 348255, 381318, 377952, 381176, 379406, 381173, 378670, 77385, 379495, 254855, 379413, 271353, 379319, 308652, 378642, 379056, 318271, 379095, 356896, 379091, 377108, 271349, 378994, 358335, 358329, 378810, 318267, 378713, 378657, 378484, 377973, 377796, 377819, 354331, 131856, 378007, 305676, 305674, 377541, 333414, 333412, 377633, 376482, 238350, 131838, 377790, 131835, 106314, 131832, 377758, 368611, 361316, 377763, 57781, 294201, 377149, 348253, 377639, 377419, 376940, 376992, 238328, 355501, 377088, 377440, 106283, 376989, 376924, 376547, 377139, 376682, 375731, 373082, 377085, 377090, 365712, 374638, 376894, 376856, 238293, 376965, 376884, 308650, 376637, 299842, 376474, 376619, 376588, 376587, 376578, 376470, 375120, 373967, 376543, 374826, 375944, 226971, 348671, 333410, 318881, 327043, 308643, 306794, 375863, 375899, 278016, 375469, 214248, 369326, 308631, 308629, 214221, 374859, 214219, 373707, 375112, 375017, 374984, 373686, 374522, 373224, 238121, 374932, 374806, 374763, 214128, 374617, 374607, 141873, 374381, 374380, 374371, 372212, 374305, 371248, 374167, 373346, 370207, 372669, 372721, 372195, 372652, 372713, 368978, 372639, 372637, 372189, 372615, 372613, 330013, 371065, 372342, 372103, 372098, 371276, 371273, 366726, 371270, 368646, 369663, 371062, 371357, 370996, 302988, 362612, 106074, 370994, 371110, 371108, 370959, 371102, 368644, 361664, 366881, 371048, 371058, 362603, 370390, 371056, 370983, 348659, 348251, 310329, 226794, 370388, 226792, 348247, 180895, 106047, 366313, 368880, 366872, 366311, 359808, 362837, 347833, 347827, 226740, 226736, 326930, 213705, 369512, 370009, 369957, 180884, 140305, 367769, 369476, 326897, 226600, 368805, 369364, 252642, 368972, 366182, 369283, 368600, 368935, 291446, 368946, 368484, 310323, 237976, 368479, 368597, 213674, 367928, 368475, 368929, 368740, 368738, 316694, 366093, 368926, 368718, 316692, 368667, 213663, 368873, 363966, 368590, 252639, 213655, 366867, 334082, 363960, 368812, 368790, 368583, 368703, 368551, 368548, 367965, 368443, 364080, 368337, 368429, 357807, 368323, 368321, 367992, 106031, 226573, 213620, 213618, 367954, 343277, 363527, 213599, 366786, 365874, 366432, 366468, 366671, 364770, 364764, 366486, 365602, 366480, 366478, 272045, 332352, 105993, 365438, 105986, 365434, 365429, 365572, 365571, 308580, 226493, 365781, 365643, 364732, 364419, 44906, 213547, 365523, 364635, 303210, 237801, 303202, 362504, 364950, 357389, 357386, 110067, 131809, 357382, 361027, 131807, 357380, 364941, 332338, 303197, 364887, 357373, 364932, 364056, 357368, 364054, 357366, 364930, 357364, 303195, 364881, 237788, 213500, 364050, 357360, 357353, 357350, 213491, 364660, 213489, 213488, 360173, 364658, 364655, 364631, 357952, 364723, 364712, 364040, 364707, 357950, 364036, 364629, 44897, 308563, 364502, 364425, 364345, 364423, 364340, 318877, 237755, 303171, 237751, 303168, 213463, 303165, 308554, 353396, 364334, 353393, 363297, 363400, 364285, 44885, 105907, 131803, 343275, 364063, 237726, 363498, 348246, 333363, 333361, 333359, 363317, 196385, 128987, 356389, 237706, 363278, 361651, 308536, 357348, 23342, 362939, 363264, 226331, 362907, 363276, 213322, 213319, 362959, 357345, 265439, 361159, 321674, 361433, 180773, 341383, 180769, 180767, 341381, 180765, 362825, 362640, 358596, 207525, 361151, 360662, 360418, 361753, 8482, 237627, 237615, 361502, 361424, 360645, 360643, 346609, 361360, 331263, 237572, 226232, 361356, 348243, 360641, 344243, 226205, 344239, 360851, 361172, 348842, 360827, 360821, 360817, 333355, 356767, 335782, 346803, 360315, 359372, 318264, 226128, 360313, 360282, 360556, 347810, 350317, 333345, 226116, 306271, 226113, 360551, 333341, 226108, 359332, 358937, 359202, 359330, 360324, 353552, 333335, 359367, 360389, 360407, 360374, 306269, 333332, 359737, 359421, 360160, 347799, 44876, 360158, 359416, 347797, 360154, 359321, 350310, 56797, 359277, 359645, 359714, 360178, 327153, 303085, 359571, 359128, 359636, 308527, 308525, 359631, 226030, 303081, 189752, 359552, 359361, 213185, 359545, 237469, 213170, 359013, 359155, 44858, 358993, 17708, 357802, 358657, 213076, 279820, 358533, 352440, 352801, 358605, 358506, 355539, 358305, 357576, 358303, 357032, 358020, 357343, 357825, 357338, 252536, 357335, 354204, 352797, 252532, 357333, 357331, 357329, 225866, 357327, 357324, 357318, 355473, 319232, 357258, 237318, 180734, 329905, 357489, 357526, 357487, 357485, 357473, 357504, 355463, 357288, 356970, 237304, 357483, 357481, 357479, 357317, 352791, 212993, 357285, 348229, 357315, 357313, 357312, 357306, 355524, 355458, 333301, 333299, 357249, 333295, 355455, 352785, 356852, 156909, 357183, 355442, 337398, 356741, 356929, 348220, 131746, 212941, 212937, 352659, 131739, 355094, 306038, 352657, 354836, 309902, 309900, 356529, 348217, 237254, 356326, 342246, 355092, 131733, 131726, 356469, 333286, 356399, 330787, 333283, 356398, 356212, 212825, 355427, 346199, 356194, 355422, 180676, 191761, 354184, 350060, 348201, 12606, 355298, 325727, 225596, 348199, 348193, 355322, 345056, 355320, 355317, 180669, 225586, 354613, 355303, 351979, 180664, 348837, 212804, 354070, 355162, 212791, 353546, 355079, 253494, 346778, 353303, 355077, 353543, 354697, 353541, 354695, 353301, 353539, 353916, 354685, 354682, 354680, 333276, 354777, 258506, 348821, 35092, 105604, 333272, 348182, 237151, 354228, 354257, 354010, 207491, 353748, 333266, 267253, 180597, 353825, 315638, 353959, 237145, 180591, 353901, 333263, 105551, 105549, 333259, 353713, 353897, 353711, 353957, 353818, 353773, 294171, 294169, 353677, 294167, 36918, 353522, 346771, 346769, 353490, 353471, 350904, 352889, 353288, 225492, 353455, 353453, 351530, 347627, 353450, 308478, 347625, 308476, 352852, 353284, 353408, 353406, 353282, 351528, 353387, 352429, 353232, 350728, 352634, 105499, 352985, 352831, 352824, 352980, 352940, 352938, 352845, 352865, 352861, 352842, 105481, 352820, 352482, 105473, 352746, 105469, 352744, 105468, 105463, 180491, 352472, 352603, 352606, 352462, 352051, 349325, 225389, 237033, 351755, 338594, 237031, 351514, 338777, 351416, 350386, 212626, 346752, 212623, 338772, 225352, 351604, 351459, 351662, 212607, 299827, 351615, 351454, 351588, 351582, 351578, 351442, 334288, 351551, 351576, 351111, 351507, 351109, 351151, 351395, 212597, 338581, 350119, 351333, 351389, 351382, 351323, 303050, 350185, 344167, 344164, 350040, 348772, 349862, 112992, 351286, 351279, 59827, 212593, 225288, 225286, 341294, 348769, 350819, 321670, 277438, 333249, 350033, 350943, 350940, 333242, 333240, 333238, 333237, 333235, 131706, 350936, 333233, 333230, 131701, 131699, 350116, 277425, 350927, 131695, 131693, 277415, 350114, 350855, 350921, 350840, 225252, 327145, 131688, 350705, 350207, 350421, 350402, 225229, 350400, 225223, 350360, 350356, 306006, 350354, 350290, 350196, 349284, 347575, 212541, 350102, 59823, 299677, 335237, 331235, 348380, 348157, 347560, 347558, 299640, 349353, 348155, 348148, 299638, 299636, 313658, 347552, 346730, 348141, 348709, 348538, 277405, 344237, 212495, 348128, 348125, 348123, 236931, 348102, 348100, 277399, 345085, 277397, 131637, 156234, 308470, 277393, 252399, 277391, 348023, 348025, 346558, 58371, 343406, 347471, 277388, 334721, 277385, 277382, 252391, 347226, 347026, 131628, 347221, 344003, 140295, 131611, 140293, 131590, 345981, 316902, 347134, 343997, 308463, 308461, 308459, 346745, 273844, 344201, 252384, 346742, 346740, 344196, 321640, 225059, 268471, 268469, 268467, 308456, 346627, 346619, 346542, 212432, 346616, 346538, 212404, 346611, 212402, 346438, 346606, 346604, 346413, 345488, 346406, 212389, 346067, 345877, 346031, 345425, 268494, 345475, 345872, 23338, 345867, 330780, 345726, 252371, 345458, 344970, 344967, 319344, 345433, 345444, 345440, 345393, 105405, 236833, 212330, 345299, 105374, 212323, 344911, 310210, 212319, 345009, 345283, 310208, 345264, 345198, 345143, 344957, 344955, 224977, 342679, 344753, 344788, 236814, 212292, 342652, 343050, 337454, 224919, 343549, 343503, 343170, 343186, 224887, 308453, 340500, 98781, 296701, 98779, 343036, 194050, 331882, 342634, 342632, 310167, 310164, 310162, 338754, 337947, 339561, 212217, 212212, 224868, 339473, 212206, 212204, 342550, 212189, 342527, 212187, 342520, 342511, 342501, 342499, 342486, 236734, 340484, 236730, 342378, 212158, 236686, 342033, 340372, 342031, 236676, 341791, 341958, 341609, 341895, 339530, 341934, 339555, 339513, 341879, 341867, 236670, 236667, 341856, 236664, 224793, 337858, 333172, 224790, 236661, 308442, 252325, 252322, 236653, 236646, 341430, 341631, 341473, 105331, 615276, 212123, 341464, 341627, 341445, 212094, 212091, 341424, 23308, 341280, 303802, 341422, 252320, 341435, 341434, 341397, 341412, 341411, 341432, 341420, 341405, 341394, 341392, 341356, 341352, 23300, 212075, 340547, 340001, 339999, 341273, 341324, 341271, 340288, 341041, 341268, 331150, 341039, 297936, 341256, 180441, 341264, 224718, 265422, 341171, 212060, 236595, 340990, 340994, 224686, 340922, 340971, 340811, 273816, 340721, 252300, 294008, 308423, 236558, 340285, 340203, 212032, 224652, 340597, 340599, 294150, 294145, 339964, 340505, 340450, 340275, 339111, 224631, 105298, 105288, 339981, 339919, 323711, 339993, 339911, 211961, 105267, 105264, 336137, 339649, 339645, 180430, 338426, 338335, 211905, 180425, 180422, 211881, 236404, 224512, 338052, 337874, 252171, 224510, 335640, 180404, 180387, 337292, 305659, 337217, 236331, 224483, 161694, 337107, 333137, 161690, 337210, 224476, 337257, 337208, 337255, 337251, 105235, 337087, 318432, 336908, 336900, 336357, 336893, 336676, 252161, 336671, 335930, 335803, 252158, 333132, 335801, 336087, 252145, 131557, 252143, 335086, 335296, 137936, 335061, 105175, 8474, 105171, 236092, 315614, 236090, 315612, 315609, 334749, 332994, 131518, 211498, 268113, 334765, 334841, 211495, 334263, 300816, 334240, 128903, 334718, 334670, 333125, 292105, 334237, 334302, 334271, 334061, 332663, 334252, 265339, 211469, 334208, 332661, 334220, 334218, 334207, 334214, 334212, 334203, 334175, 332968, 333074, 324487, 105124, 331746, 300811, 236054, 236052, 314133, 334127, 314131, 333119, 314129, 332631, 331156, 105116, 333062, 332880, 332527, 332868, 277317, 236024, 327283, 332250, 332248, 312470, 252117, 131487, 332162, 29991, 282741, 327888, 194110, 331913, 181410, 331871, 306264, 331032, 330558, 329436, 235940, 252099, 319489, 285420, 329031, 137932, 328618, 328673, 137926, 224071, 159272, 326840, 328200, 252091, 252088, 328135, 328001, 327998, 327723, 205105, 327054, 326623, 258851, 327017, 327400, 326766, 327393, 327115, 305633, 305631, 131471, 252072, 131466, 327012, 327113, 252068, 305623, 224026, 264079, 264075, 266088, 326551, 326589, 194515, 326587, 311643, 194513, 326549, 326547, 252064, 326541, 323691, 318420, 223996, 318417, 288596, 319185, 288594, 320250, 325442, 211118, 306901, 323686, 325570, 277298, 318253, 235871, 318251, 318248, 325282, 318242, 260915, 252061, 318240, 260913, 211110, 252057, 325280, 264069, 325920, 180291, 128868, 325913, 320102, 325910, 325598, 223938, 325582, 325232, 325230, 325227, 211100, 324468, 324465, 323674, 180263, 180255, 180252, 180246, 323671, 321854, 314558, 211068, 321604, 260906, 202618, 321779, 307555, 202605, 211058, 321761, 321774, 299815, 260904, 202602, 223859, 321597, 319006, 252043, 252041, 321456, 321281, 211018, 321454, 321405, 321348, 319000, 320093, 320222, 321248, 318648, 311998, 320086, 320081, 313301, 189610, 319603, 318406, 201458, 318404, 201456, 299801, 319509, 319580, 319427, 319374, 319425, 210983, 319302, 319300, 235765, 311238, 319179, 319204, 317075, 318994, 318992, 223770, 223768, 318498, 235754, 235197, 277969, 223756, 318811, 318803, 318742, 317474, 318400, 311991, 318794, 318787, 318735, 318785, 311988, 210913, 318165, 223740, 317061, 318462, 260877, 318210, 318458, 235742, 318492, 318456, 307553, 307551, 180148, 180146, 318148, 318395, 318394, 318205, 318203, 316316, 318201, 318389, 318198, 316314, 318387, 318195, 318135, 317592, 316310, 131460, 314544, 316958, 317387, 317385, 317564, 318084, 180139, 317562, 180137, 317559, 235736, 317557, 23276, 317552, 312698, 312696, 317548, 317546, 312694, 317544, 23272, 317043, 316938, 316934, 252013, 317376, 317375, 18753, 300729, 317467, 141137, 316852, 316851, 252005, 316303, 316301, 180093, 316839, 252000, 251997, 251996, 251993, 251990, 173245, 180091, 307466, 316061, 312741, 312739, 180085, 266077, 316704, 316745, 316743, 210857, 316111, 41204, 316284, 251984, 316278, 223699, 210847, 311723, 235695, 210834, 315968, 316027, 251980, 316004, 251974, 308368, 308366, 223654, 315558, 260866, 315547, 180059, 180056, 260864, 223652, 210783, 315478, 315359, 315313, 315309, 315304, 251958, 251954, 251950, 251948, 104972, 104966, 104962, 315173, 104957, 210767, 104955, 104951, 315171, 104948, 180038, 180037, 314876, 314368, 251942, 265330, 312528, 104940, 104934, 104929, 314499, 314098, 266058, 251940, 210752, 314096, 307720, 313464, 266053, 313413, 314363, 313410, 314356, 235640, 251926, 251918, 313439, 251915, 313436, 314090, 210738, 314159, 313988, 313985, 223591, 314024, 251904, 251900, 195804, 235593, 313812, 312526, 312524, 312521, 300794, 251887, 251884, 251882, 311713, 235583, 277279, 277274, 313403, 313401, 311705, 313376, 313399, 210675, 257175, 313616, 308357, 195792, 304680, 257157, 313584, 313336, 313394, 312569, 313372, 312781, 313367, 304674, 251867, 313388, 313356, 312850, 313299, 188663, 310360, 313095, 308338, 312378, 313092, 312376, 195786, 294137, 310605, 179973, 312819, 260856, 223535, 223533, 294134, 311369, 311367, 294131, 294128, 312857, 311363, 312817, 312719, 312717, 312814, 312843, 312800, 312775, 210638, 312772, 210634, 210632, 312839, 104861, 312811, 312836, 312809, 312807, 312770, 311455, 312791, 312768, 311978, 312259, 312766, 311976, 312761, 312759, 312680, 251853, 312550, 179965, 251851, 223513, 223509, 312674, 312394, 210610, 223505, 311947, 308139, 179963, 223484, 312242, 104842, 311919, 205055, 210595, 305594, 312235, 305591, 311900, 311669, 312116, 305584, 251839, 251838, 311844, 311772, 210557, 235547, 179952, 311447, 311445, 311421, 311343, 311385, 311373, 311340, 311314, 311328, 311304, 311302, 311300, 235544, 307442, 310674, 310672, 235539, 307404, 311215, 307844, 310462, 311115, 311206, 131424, 311106, 131421, 311087, 310459, 308333, 300785, 310657, 310628, 310653, 251829, 310624, 210522, 104819, 310351, 310350, 308328, 308321, 307233, 308318, 310473, 307230, 223414, 223412, 223407, 104804, 310125, 87663, 264011, 272957, 272956, 272954, 308302, 310123, 272952, 310094, 310092, 264005, 283291, 260852, 306649, 302983, 306637, 307652, 307680, 307678, 307834, 307482, 307676, 307220, 307829, 307827, 305483, 307664, 210509, 305479, 307650, 307363, 307345, 307336, 305451, 305817, 307272, 307115, 307008, 307001, 306999, 251794, 264001, 179927, 223349, 235509, 306710, 306708, 251789, 223333, 179923, 223314, 306169, 306199, 306196, 306143, 123452, 251780, 251778, 179918, 305857, 210480, 305851, 305846, 305731, 279036, 305725, 299542, 299538, 210457, 223271, 305529, 305391, 303678, 251758, 263483, 179885, 179884, 251754, 251753, 195744, 195742, 305271, 160796, 305266, 223233, 305073, 305048, 305046, 304963, 304929, 305004, 251731, 251726, 301804, 301799, 251723, 179882, 301614, 304532, 210403, 251719, 179879, 251717, 263991, 304512, 304471, 131417, 304076, 299784, 299782, 301613, 251710, 251706, 303031, 210368, 251703, 251701, 251698, 301925, 179861, 302631, 179860, 294624, 302887, 302582, 302577, 294618, 302575, 291429, 160790, 302565, 302479, 210326, 296216, 302247, 179838, 301054, 301641, 301639, 104788, 300984, 104786, 104783, 299749, 251666, 251663, 301599, 301597, 251654, 104777, 251651, 251646, 301144, 301253, 251632, 235426, 301034, 251628, 210244, 296195, 299730, 251623, 251621, 251617, 299863, 298411, 263988, 251613, 263986, 251610, 251606, 296249, 299460, 299456, 299454, 299448, 299867, 299612, 251600, 251582, 295956, 195720, 104751, 298877, 296007, 179803, 298401, 297645, 251580, 251578, 210189, 104733, 223149, 251576, 298393, 223139, 223137, 298391, 297638, 297636, 297634, 297632, 297627, 179794, 297622, 298282, 297615, 179774, 179771, 179769, 179767, 251564, 179765, 297613, 179763, 298194, 210129, 297746, 251560, 297143, 131391, 131389, 131387, 251558, 296679, 210063, 294613, 235416, 251554, 294990, 294988, 131359, 179732, 295935, 295929, 295747, 195696, 251552, 293918, 271244, 179728, 295265, 251536, 277150, 295261, 295259, 295256, 251527, 251525, 251520, 251516, 291952, 131351, 294782, 251511, 251507, 251504, 251500, 294720, 294717, 294975, 294274, 294973, 141103, 294712, 294777, 294704, 287676, 294698, 294682, 294679, 294677, 294672, 294675, 104716, 294579, 16973, 204996, 294502, 294419, 293896, 179709, 294107, 294105, 292870, 179701, 294074, 293859, 294069, 294068, 294062, 293852, 293846, 179696, 287673, 195678, 293769, 291422, 131305, 179693, 291402, 291496, 291265, 291263, 256312, 131289, 290366, 104573, 290332, 104571, 278887, 251479, 290299, 289265, 289262, 251477, 251473, 288855, 122623, 251470, 179638, 287960, 287958, 287955, 179623, 285774, 251460, 179619, 287794, 287775, 251459, 131274, 131272, 287517, 179588, 223093, 287321, 287515, 266847, 287315, 189592, 251458, 179526, 195658, 161451, 278874, 251455, 179516, 284598, 284569, 271061, 277579, 179373, 43809, 179362, 277113, 179359, 273246, 263473, 276450, 179358, 223083, 179334, 251445, 277038, 179327, 271048, 271044, 271042, 275741, 276570, 263969, 276415, 276412, 276411, 156859, 274813, 179313, 273231, 273222, 195652, 272939, 266816, 104434, 104387, 179205, 104370, 260786, 179187, 270971, 179186, 268606, 179177, 179176, 179171, 179169, 270778, 104299, 266261, 270645, 209542, 207486, 269464, 174140, 223020, 174138, 174136, 179042, 179022, 260782, 270019, 251423, 270275, 251422, 260780, 270204, 270202, 270200, 270198, 270132, 178910, 178908, 269653, 178900, 178898, 122611, 251420, 269825, 269823, 269622, 269462, 269460, 269150, 269455, 269480, 143013, 269453, 269146, 178833, 269402, 269271, 269269, 269138, 178823, 178797, 178795, 178793, 268803, 268801, 222962, 178789, 209405, 178755, 184536, 178723, 268362, 268444, 268430, 268442, 178712, 178710, 178702, 268345, 267836, 266304, 178683, 178680, 178678, 264960, 266299, 178670, 261955, 261950, 264954, 178612, 268232, 268229, 178611, 268225, 178609, 267772, 209375, 267100, 178606, 267770, 178603, 254435, 268094, 267970, 182949, 182947, 182945, 268079, 266542, 268077, 209369, 267764, 267019, 267760, 178601, 267755, 178598, 266295, 267094, 178593, 178592, 178590, 178589, 178587, 267092, 267653, 266291, 267968, 209365, 267649, 267089, 267977, 267958, 267956, 266911, 266909, 267001, 178524, 131216, 263877, 266859, 263305, 178479, 266768, 266646, 266716, 266710, 265610, 109572, 109570, 266533, 109568, 178458, 209343, 260775, 266577, 209340, 266631, 131188, 209337, 251418, 260772, 256291, 178277, 256290, 256289, 256287, 168857, 261369, 258274, 178087, 178085, 265141, 178079, 35701, 131170, 178073, 178071, 178069, 131162, 178067, 178065, 261859, 140978, 265082, 178058, 265079, 261854, 178043, 186788, 257414, 186760, 257401, 257399, 178008, 257395, 257391, 177992, 177990, 177988, 260411, 260409, 177978, 257550, 186746, 177965, 177958, 177956, 177954, 264896, 177951, 264994, 104219, 258258, 177897, 195621, 264591, 177893, 264587, 177836, 262160, 177835, 177834, 177829, 262156, 177826, 177822, 264180, 263727, 177783, 263866, 263750, 263203, 182932, 260753, 186698, 262939, 177652, 177649, 262555, 186687, 177629, 177627, 131128, 262618, 177625, 262516, 262034, 262514, 262902, 131123, 262510, 262609, 262608, 177617, 262505, 251353, 257723, 177608, 177605, 262271, 177603, 262121, 177602, 257722, 209247, 257719, 262364, 177599, 222929, 222927, 177597, 262358, 222921, 186678, 131121, 255715, 255714, 202569, 254430, 82172, 82170, 255710, 209223, 261924, 261798, 255707, 251330, 82166, 262087, 318888, 131100, 251326, 131098, 131096, 261920, 131093, 255701, 175693, 257717, 262055, 261584, 255698, 222914, 256286, 256283, 177492, 255686, 261706, 177489, 254420, 255683, 255681, 177469, 254416, 251315, 254414, 251313, 251311, 260733, 251309, 260692, 182919, 256267, 177453, 177452, 177442, 177437, 261406, 257714, 177433, 131070, 131067, 177432, 260315, 177428, 140959, 140954, 257710, 261578, 186636, 177421, 186634, 186630, 177418, 260292, 260288, 260286, 177417, 140946, 131059, 177416, 140943, 258419, 250706, 261490, 257708, 131057, 177407, 186627, 186625, 104177, 261478, 186624, 177402, 186622, 222904, 257705, 104173, 209196, 260685, 259638, 209194, 177383, 257692, 177379, 177374, 222893, 177369, 177368, 257689, 251293, 186609, 131041, 131039, 177350, 177349, 177347, 177328, 257684, 177317, 257682, 260725, 209173, 222147, 186584, 260717, 177308, 260985, 260715, 195584, 177306, 177304, 131035, 177303, 235340, 261118, 122587, 261017, 104130, 131023, 104128, 131021, 261015, 131019, 177300, 104126, 131014, 104080, 177284, 131008, 186563, 131005, 235288, 186561, 259626, 177195, 260015, 177193, 260012, 260010, 195576, 186540, 259892, 206990, 206988, 259624, 259941, 206982, 204517, 209128, 249394, 204515, 259982, 258813, 259864, 259938, 258799, 259925, 259919, 259402, 255362, 204505, 258910, 104065, 186516, 128856, 186505, 259673, 259747, 258014, 258012, 259614, 259744, 259742, 258010, 259737, 204495, 204493, 186501, 259610, 259572, 186499, 14526, 259606, 259183, 259604, 259181, 259431, 258944, 259570, 259270, 186492, 259266, 259598, 177100, 259567, 195574, 259397, 177097, 177094, 251270, 177092, 259395, 259393, 195570, 186488, 195567, 104033, 259476, 259168, 195535, 222888, 259324, 259237, 259251, 259233, 186437, 186434, 258940, 258961, 176984, 258933, 258982, 258980, 258848, 258896, 258894, 209106, 258958, 258846, 209094, 222866, 209092, 175690, 257364, 258583, 258581, 257678, 251264, 258575, 186411, 256746, 186409, 251262, 258526, 258562, 258442, 143523, 203638, 258606, 195525, 195523, 256146, 143521, 258485, 256143, 258437, 258602, 258433, 258521, 195514, 204646, 255651, 176929, 257055, 176927, 195505, 209079, 258379, 253097, 257045, 176903, 258193, 257336, 256845, 257331, 176889, 130968, 176884, 257325, 257320, 130967, 130964, 258178, 140938, 258176, 257846, 257844, 130961, 248659, 130959, 248657, 203947, 176878, 176875, 195490, 203945, 248655, 176872, 195488, 195485, 195481, 248652, 203943, 248648, 248646, 248644, 257830, 195477, 257905, 258132, 258032, 258188, 249622, 195469, 257813, 257810, 257808, 257794, 257791, 222854, 222848, 222845, 222842, 222838, 257304, 257669, 222836, 257300, 195466, 257666, 195465, 195463, 255987, 195461, 222829, 257037, 195457, 255984, 195455, 195452, 257657, 249618, 257034, 195450, 195448, 257655, 195446, 176807, 176805, 257278, 176803, 257032, 257649, 257644, 257639, 255605, 222799, 186400, 122565, 251237, 122563, 251235, 257026, 186398, 249803, 204949, 204947, 186395, 204945, 257021, 257272, 255593, 204943, 257270, 204941, 249800, 257268, 257512, 257546, 256433, 257481, 255585, 256616, 256613, 195444, 209005, 256611, 256981, 186388, 186386, 256246, 186384, 256908, 254263, 130949, 208969, 256323, 256076, 256424, 255917, 256333, 130943, 256420, 256255, 176748, 256036, 130921, 250910, 256004, 255147, 255145, 208961, 255994, 255992, 130915, 249046, 255967, 255965, 222774, 255899, 222772, 255193, 130897, 222755, 130895, 255554, 130893, 130891, 130888, 130886, 130882, 255545, 222752, 130877, 255779, 104016, 255433, 255431, 130853, 130850, 254890, 195423, 254965, 195419, 195417, 195415, 254882, 206651, 130818, 130816, 253342, 253165, 192114, 253030, 253005, 253004, 249643, 195396, 176505, 206614, 206610, 176403, 176402, 206608, 176399, 130757, 130748, 204554, 150492, 128806, 208621, 128801))
Run Time: 0.073529
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3447 | |
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 | | | | | 3447 | |
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 (33997, 30210, 29401, 27501, 22976, 20503, 33159, 18064, 17835, 16940, 16915, 16914, 15817, 15806, 15786, 15697, 15393, 15169, 14949, 14846, 13750, 13694, 13219, 13113, 13112, 12999))
Run Time: 0.001498
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 26 | 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, ���
Run Time: 0.000179
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
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.000358
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.000606
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: 1716156954
Run Time: 0.000290
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 31 | 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` >= 1716156954)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000723
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 31 | 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