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.000561
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.000199
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` = '4234')
LIMIT 1
Run Time: 0.000400
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.002120
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_4234' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.062582
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 (591632, 527948, 393931, 527907, 527894, 527892, 591444, 527890, 393928, 527887, 393926, 527852, 591441, 527845, 367718, 438855, 200847, 438772, 591318, 438750, 591315, 438744, 438729, 590035, 590235, 438712, 591149, 591153, 438707, 554268, 591145, 438703, 200834, 438695, 591133, 590706, 438693, 554265, 591106, 546795, 590703, 438690, 590693, 546792, 591129, 438680, 591100, 591122, 554263, 546789, 590691, 591095, 590302, 591093, 546786, 591091, 200832, 591083, 438674, 591058, 591078, 591076, 438667, 554547, 554260, 438662, 590680, 590676, 438646, 266953, 438639, 554257, 438621, 591009, 590774, 590772, 591005, 590290, 586083, 548370, 109191, 590881, 590862, 221895, 418856, 438612, 418853, 381021, 418851, 438600, 589927, 571714, 590824, 589919, 589915, 110709, 571710, 438596, 481375, 554250, 554243, 438594, 548365, 571705, 590836, 571703, 571701, 571694, 548360, 548358, 438591, 571689, 571687, 548356, 438589, 589913, 548351, 548349, 532073, 590400, 590770, 590768, 590396, 590766, 109177, 590391, 438542, 548335, 548329, 548325, 590389, 548317, 556839, 246612, 221888, 556833, 221885, 556831, 590636, 554238, 590572, 590456, 246608, 589907, 589902, 554740, 589900, 590431, 589879, 589876, 587249, 590332, 200824, 573501, 514987, 438505, 590382, 246586, 438501, 221883, 221881, 221879, 221877, 221875, 590377, 246582, 221873, 438487, 590371, 453716, 221870, 577618, 585134, 438483, 575582, 16659, 575580, 438475, 200823, 575578, 438465, 438463, 438461, 109171, 532011, 349591, 438454, 588948, 200819, 590260, 578197, 576515, 590258, 438174, 578195, 590216, 438100, 438096, 590252, 590208, 590249, 246526, 438090, 246524, 576512, 579846, 590201, 221851, 590247, 590214, 437994, 221845, 579822, 576508, 246512, 221843, 437987, 330513, 437962, 246510, 470965, 221841, 579792, 579789, 420362, 246501, 579765, 437948, 590113, 531914, 590109, 437939, 590105, 579746, 590050, 437935, 590047, 246440, 437897, 590099, 437893, 590086, 579709, 221834, 590043, 246428, 200801, 437847, 246412, 246395, 590031, 221828, 246369, 246362, 538710, 437833, 579685, 221826, 590015, 437817, 334297, 334295, 589945, 589941, 437783, 437777, 437775, 437755, 589353, 346999, 453711, 536251, 589350, 589443, 589441, 437456, 437453, 437372, 581269, 437369, 589343, 589424, 589340, 589337, 573706, 589328, 527781, 553099, 588842, 588840, 553094, 362860, 587668, 588834, 589019, 588939, 588831, 309800, 309796, 309790, 333976, 575223, 570702, 587059, 436944, 436934, 246154, 581191, 581183, 453701, 587475, 389043, 389030, 587423, 587420, 587416, 331365, 587324, 436859, 577935, 554139, 436856, 587321, 436845, 587333, 436835, 436831, 436827, 221735, 554135, 587318, 436811, 587328, 436799, 554132, 109121, 587225, 436761, 587300, 436738, 398164, 398162, 380997, 436736, 310078, 436732, 310076, 310074, 587266, 622553, 622551, 310063, 587261, 587217, 436729, 310059, 587215, 310054, 436726, 310050, 587246, 586561, 579525, 436714, 536178, 587213, 587203, 586768, 622540, 587174, 531486, 586766, 436690, 587101, 587097, 436685, 573532, 569840, 569838, 587038, 110683, 587036, 586764, 110681, 587079, 569835, 110679, 584657, 436653, 110677, 110675, 586754, 423342, 174392, 586789, 110668, 221701, 110665, 586752, 110660, 436611, 436608, 586747, 585057, 585054, 586576, 436575, 586695, 586420, 586417, 586415, 586647, 547924, 579502, 579499, 423334, 579492, 423332, 586484, 221684, 579489, 436502, 586574, 586571, 579471, 423330, 579466, 579464, 579460, 423327, 579446, 579444, 310049, 436461, 436459, 436451, 586358, 436449, 436439, 586356, 586353, 436437, 586351, 436434, 586435, 436430, 586348, 586346, 152413, 123468, 586265, 586400, 586229, 586342, 586398, 572072, 458126, 436397, 586261, 575262, 368910, 436364, 436360, 586154, 436344, 585610, 586047, 585608, 586044, 586042, 585855, 246054, 246052, 585847, 575259, 531368, 548019, 585664, 585659, 436237, 436223, 420344, 542856, 436095, 436093, 436091, 221601, 585125, 245975, 436029, 245973, 420337, 309762, 511641, 436019, 309760, 578459, 585093, 584382, 245969, 309756, 436010, 542848, 542846, 309753, 584379, 315790, 436000, 578154, 584375, 435984, 569356, 489022, 554726, 315788, 489019, 435977, 315785, 559219, 556505, 554719, 570405, 435962, 221579, 576406, 309733, 554059, 493637, 245965, 309731, 576403, 558072, 622429, 584925, 353949, 221566, 309722, 584911, 309720, 245963, 309718, 584908, 581575, 493629, 584899, 435928, 435883, 435881, 435847, 584754, 584369, 584595, 109013, 584589, 584716, 554027, 221537, 584582, 581719, 578151, 245950, 536137, 584737, 584735, 579296, 435830, 584692, 584689, 584730, 579294, 584636, 584687, 584728, 584649, 584633, 584725, 584552, 584681, 221531, 579292, 584646, 579290, 584535, 584644, 578233, 584642, 539525, 584569, 584567, 581020, 245947, 584565, 580919, 570697, 584563, 110652, 110650, 578610, 435802, 579274, 584531, 206178, 579272, 245943, 584499, 579270, 579268, 579266, 584398, 584513, 511634, 511631, 584511, 584437, 584497, 584435, 435794, 584427, 315782, 579248, 579242, 584366, 435788, 581942, 435784, 584360, 200673, 584023, 435773, 581808, 581139, 435758, 584318, 435754, 539522, 584310, 577646, 200671, 584304, 584021, 578382, 581129, 578380, 577644, 435751, 526472, 584299, 221507, 435727, 435718, 578222, 435716, 581745, 435710, 581806, 584277, 571259, 578425, 435701, 412541, 435693, 571253, 412538, 578421, 578377, 109005, 578417, 584250, 221500, 544721, 576500, 576181, 500333, 500314, 221486, 500307, 581590, 221482, 435531, 537730, 499401, 499398, 500281, 572639, 518912, 584112, 580912, 435520, 531196, 537724, 412528, 324362, 435494, 537721, 412525, 110649, 110647, 584015, 221454, 584027, 578454, 412522, 581679, 581562, 625023, 578367, 581730, 310046, 412520, 536129, 576175, 357632, 581670, 581556, 110639, 110637, 579051, 581402, 581057, 389006, 465032, 435198, 465029, 551138, 581399, 465027, 578908, 435159, 435157, 581079, 435148, 581074, 563836, 581105, 577924, 551136, 551134, 423320, 581055, 412503, 581053, 435127, 412500, 435121, 578148, 108985, 569547, 578589, 245704, 578553, 549751, 578524, 578144, 578512, 578443, 578582, 578141, 578596, 569544, 578510, 578508, 399362, 235068, 578437, 221354, 235061, 570858, 434972, 235059, 578434, 434967, 578307, 578432, 578304, 578176, 578429, 578138, 578299, 578296, 578412, 578287, 578112, 554712, 367636, 481785, 578269, 578128, 577846, 453685, 330477, 235049, 235033, 412456, 235027, 245663, 578122, 235024, 412453, 434940, 577844, 314708, 412448, 235021, 434930, 314706, 245628, 108977, 314699, 578109, 526418, 221311, 485932, 577870, 536115, 539521, 539519, 412440, 575969, 577860, 484922, 577840, 390701, 577631, 346875, 234906, 576946, 108968, 575967, 234885, 577543, 575965, 412437, 575963, 367620, 110624, 108960, 577477, 310040, 434584, 412423, 573366, 367613, 484919, 434560, 434552, 245544, 434549, 573360, 285563, 577376, 522682, 577341, 485921, 554709, 234827, 485916, 554705, 577089, 108930, 577086, 234775, 530774, 108927, 108924, 245511, 530761, 544709, 576649, 574408, 576597, 369225, 576396, 434203, 469972, 234513, 576136, 576131, 310034, 245394, 551692, 575941, 530696, 575831, 551684, 245347, 245338, 575999, 245333, 576100, 245330, 234484, 245328, 573216, 574692, 575919, 551575, 575914, 575867, 575551, 575543, 575540, 575548, 567082, 463738, 463734, 463732, 575419, 367599, 433999, 463718, 575401, 433997, 463698, 433983, 110620, 575350, 574280, 574270, 341487, 575277, 485905, 539506, 575269, 572689, 110617, 574855, 573081, 574260, 234108, 572770, 200372, 574022, 332244, 234067, 526372, 485884, 536046, 574038, 526364, 433612, 433596, 553086, 234044, 571304, 433580, 556765, 573270, 573020, 573903, 573266, 573264, 573901, 573018, 220980, 398493, 573262, 433575, 573260, 420266, 573016, 433571, 433565, 573006, 222432, 573996, 234031, 574002, 547990, 567394, 569455, 573988, 553801, 530358, 234027, 553799, 573969, 572126, 573815, 367592, 433545, 234025, 573874, 553772, 547986, 523597, 573813, 573776, 523594, 573761, 573759, 565402, 573507, 573442, 220957, 553080, 471974, 412373, 573397, 200340, 244954, 553062, 463661, 463648, 572675, 463646, 569111, 569778, 417875, 570826, 110595, 244755, 571938, 336339, 572163, 569894, 233880, 571844, 571842, 273883, 568591, 273880, 273872, 273870, 273868, 453653, 553050, 553044, 553042, 412356, 571630, 515519, 571522, 571462, 233829, 544696, 551951, 551949, 547818, 551946, 551941, 233811, 309705, 485866, 309698, 336330, 110586, 110584, 110581, 110579, 110577, 110570, 571046, 570156, 220839, 570767, 570067, 432810, 432792, 569889, 220795, 206087, 367572, 309601, 570623, 570644, 569749, 244610, 570630, 432768, 570627, 570620, 569947, 535741, 220786, 432766, 233766, 526281, 432762, 553037, 553035, 553669, 570606, 570603, 432747, 553665, 110564, 110561, 553661, 110558, 110555, 110553, 432744, 419861, 419859, 569648, 569646, 570467, 570458, 558818, 535997, 569887, 570186, 282642, 570122, 570085, 558804, 570083, 569884, 200287, 569881, 544692, 569934, 417971, 569743, 432590, 365329, 365326, 432580, 569855, 569415, 569540, 432569, 432566, 206054, 432561, 518907, 560731, 569104, 560726, 336306, 558780, 568209, 432431, 568578, 514622, 514618, 514616, 514609, 568320, 206036, 432356, 568155, 529629, 565458, 568166, 432354, 485829, 553033, 567976, 432277, 567114, 529589, 553027, 220440, 527733, 566786, 396520, 563526, 396518, 396516, 562247, 624972, 432203, 133063, 535876, 431491, 233198, 558016, 244321, 557219, 233140, 233136, 558489, 558478, 552977, 552965, 557216, 485793, 558052, 557963, 556716, 557954, 431292, 412260, 557757, 552921, 557142, 557746, 485785, 390676, 110521, 557460, 556327, 390673, 110519, 380831, 244253, 557199, 9795, 233072, 553269, 233067, 557136, 380821, 557134, 110513, 485779, 110510, 557090, 380815, 556963, 555544, 404734, 556713, 233029, 556711, 556404, 537433, 404730, 233027, 556397, 404725, 529174, 556248, 555722, 555712, 431049, 525827, 9793, 388287, 430956, 233000, 535848, 552384, 539270, 550785, 547751, 232989, 232980, 547748, 430872, 232974, 544679, 430866, 554468, 544677, 544675, 544673, 552569, 539485, 430836, 552681, 552566, 539477, 550902, 552337, 430782, 550900, 519968, 398156, 552163, 541663, 529080, 550045, 529000, 547220, 318077, 549280, 528998, 548222, 525677, 546233, 547461, 318069, 544951, 450933, 232738, 244110, 525598, 525584, 545735, 545782, 398121, 502176, 373544, 545725, 525555, 545670, 545474, 545569, 389204, 515335, 515318, 544658, 367487, 519107, 429807, 542087, 429802, 219649, 380595, 232644, 232641, 528860, 544100, 544116, 485692, 535820, 544038, 429771, 544035, 543833, 393835, 429745, 544113, 380587, 412113, 525382, 525365, 525363, 525361, 421663, 528839, 478279, 543814, 539448, 543804, 543768, 511053, 536789, 525327, 511005, 505213, 542422, 542380, 232613, 244005, 541957, 542075, 525180, 525152, 525149, 469032, 541951, 429363, 525140, 541836, 541833, 485679, 525128, 541654, 541714, 620165, 429327, 541597, 525120, 525107, 525100, 541458, 200038, 541453, 525092, 525088, 429309, 485661, 525079, 525070, 541200, 515284, 339358, 525046, 525037, 492627, 541194, 540202, 492624, 525033, 525031, 429280, 515281, 412083, 412081, 515278, 539783, 528775, 429274, 624817, 456254, 624815, 429256, 110447, 524986, 540706, 536437, 528697, 456073, 528216, 524296, 524271, 524257, 528209, 524239, 528145, 528042, 524208, 524204, 232340, 428745, 527517, 514898, 513733, 321163, 511413, 385909, 527072, 428701, 451737, 526728, 396483, 526935, 326467, 404693, 412033, 428668, 414863, 524000, 517315, 412012, 412009, 243649, 243647, 404671, 428205, 520745, 520741, 428087, 108548, 519863, 519852, 519848, 455447, 519788, 519505, 515762, 362848, 428071, 485496, 519582, 428049, 519580, 485494, 428043, 519501, 519496, 428021, 412002, 427963, 329582, 518733, 518418, 412000, 329563, 517919, 517914, 517912, 514420, 517909, 517534, 515257, 514221, 514066, 513997, 511833, 513791, 513293, 512914, 512581, 512704, 380431, 512523, 512254, 511554, 427628, 403351, 456050, 456048, 511550, 456046, 456044, 456041, 385895, 511782, 511780, 385892, 512309, 330296, 494702, 330293, 455434, 511776, 427492, 511471, 511373, 511162, 427457, 427454, 453483, 199656, 509189, 509527, 509390, 411938, 508436, 508258, 469815, 469813, 507789, 507828, 507947, 507815, 426990, 426988, 426982, 188799, 426976, 469800, 504378, 231863, 199579, 506883, 506316, 231849, 243294, 414820, 505881, 505831, 485324, 426877, 505785, 494683, 421888, 505617, 503115, 490344, 490339, 317158, 317156, 426769, 199537, 317135, 243197, 505303, 504706, 505253, 504704, 504923, 504696, 504905, 504689, 401005, 504836, 231760, 504595, 504548, 494808, 504631, 504683, 499580, 504344, 504131, 504319, 469397, 199506, 231675, 205828, 231639, 426638, 504067, 426633, 503918, 243118, 342798, 243115, 342786, 501983, 329347, 503494, 231565, 503410, 388175, 231548, 503356, 503371, 349399, 349395, 503347, 413763, 503345, 388170, 449113, 489114, 243035, 489111, 502982, 468980, 494679, 494677, 323549, 231518, 243023, 231478, 231473, 243018, 231467, 502065, 268955, 231457, 389157, 323546, 325012, 501310, 624729, 494907, 371209, 501402, 469785, 501399, 501392, 387828, 501283, 501323, 494887, 501319, 501317, 380372, 337015, 500250, 500889, 500872, 500866, 500864, 426233, 500489, 426231, 500855, 469781, 426229, 205815, 469779, 349385, 469777, 469775, 242983, 500453, 426222, 426218, 500241, 400098, 500438, 500236, 500433, 400096, 242972, 499090, 500003, 417782, 426191, 108205, 469773, 402707, 499665, 499637, 499657, 499060, 499217, 380359, 498316, 499004, 468954, 498311, 110326, 498706, 498689, 498462, 498452, 498254, 23475, 380351, 324320, 497720, 497399, 497619, 497393, 496638, 496249, 496395, 455378, 492526, 495609, 455354, 288814, 288810, 494794, 495192, 495031, 494638, 494989, 494831, 494636, 494790, 493359, 494341, 360008, 425584, 490945, 487951, 487945, 487938, 485132, 425219, 484162, 484160, 486306, 483354, 107957, 473922, 477915, 477834, 473904, 107865, 462711, 473886, 473884, 474814, 474839, 473846, 474500, 474492, 469270, 469268, 474257, 473836, 473805, 472788, 469264, 265524, 473672, 424620, 265517, 472874, 472534, 472721, 308845, 472786, 472784, 472790, 472682, 471492, 471641, 471639, 471490, 471008, 398081, 458725, 470993, 398079, 470819, 470657, 458712, 470648, 398074, 458708, 470067, 469538, 469323, 468197, 462686, 468182, 468286, 468054, 467060, 388137, 467344, 424326, 424322, 466214, 466603, 398070, 464883, 424245, 466078, 198612, 466074, 466072, 466355, 466299, 464877, 464872, 466064, 198594, 466104, 466102, 466061, 465942, 241744, 315716, 465128, 465125, 465122, 462655, 465593, 465113, 465581, 465577, 424185, 424174, 464991, 464988, 464984, 464969, 456113, 315713, 424155, 424153, 461960, 461957, 205630, 464653, 198535, 464651, 464649, 463138, 464363, 463990, 107730, 455094, 464202, 462435, 198502, 261301, 463871, 463862, 205611, 463317, 460976, 463315, 462543, 380231, 450828, 461947, 461912, 461909, 461906, 461994, 461964, 461826, 229814, 229811, 461710, 344527, 107673, 344525, 461534, 344521, 107646, 461030, 461026, 198415, 461049, 460918, 460954, 460681, 460679, 423950, 460354, 198368, 459836, 460203, 459919, 460106, 457995, 457991, 457988, 423913, 398372, 459661, 423910, 459642, 459658, 198352, 459147, 459141, 459093, 459118, 458860, 458659, 458344, 389944, 449612, 389942, 261288, 380223, 457647, 457545, 457299, 423881, 457016, 423867, 398055, 456652, 396150, 396148, 380213, 456401, 455692, 336965, 455996, 455854, 453348, 376107, 455134, 455598, 423845, 453199, 198226, 453197, 454056, 455167, 413741, 423837, 423835, 454052, 423832, 188738, 413415, 392328, 455139, 413412, 450219, 455047, 455045, 455043, 455041, 455039, 454954, 413739, 198190, 454202, 380201, 380199, 380196, 454103, 453870, 380194, 380191, 453031, 452621, 452612, 110197, 452610, 448415, 451711, 449105, 452372, 198139, 450754, 450749, 23407, 452132, 452260, 452210, 452095, 452245, 452130, 265495, 380179, 371027, 451701, 451687, 451676, 205536, 188732, 375257, 188730, 451345, 107488, 451352, 451317, 450734, 451309, 451306, 451300, 188714, 451287, 451276, 451008, 449355, 451002, 450701, 423683, 449554, 449497, 448698, 449492, 448696, 449489, 448694, 449226, 449179, 449328, 380145, 448995, 389940, 448672, 423785, 448668, 448665, 374330, 374328, 404918, 448368, 448287, 447791, 448110, 423715, 423120, 107383, 294535, 380097, 422779, 422777, 229161, 422683, 422695, 411610, 421375, 408042, 421372, 419379, 420192, 419654, 330093, 405314, 418992, 418526, 413734, 413732, 418190, 417998, 418186, 349371, 347738, 417402, 356360, 417990, 417988, 240712, 240710, 380040, 415787, 359890, 110155, 415699, 416607, 416616, 398942, 393297, 415142, 415782, 415138, 415129, 414397, 414587, 414385, 315690, 413274, 413212, 403347, 389928, 412639, 389920, 402102, 401821, 397151, 402350, 398579, 395787, 395775, 239314, 394842, 239239, 227694, 227686, 227652, 239091, 239082, 285470, 390263, 389125, 389887, 254865, 389843, 238990, 389881, 390189, 106546, 389383, 389877, 387780, 389870, 387777, 389868, 616615, 616595, 285467, 375757, 387896, 388679, 388644, 389524, 227575, 238904, 616565, 616561, 348373, 389319, 227565, 387002, 387956, 387952, 385048, 388482, 387120, 388424, 386996, 387755, 285462, 387572, 387747, 383748, 387745, 388421, 214885, 227552, 383746, 383741, 383112, 387591, 387117, 387565, 387490, 616524, 383738, 387115, 387521, 387556, 387518, 238845, 387487, 383462, 387319, 387317, 386971, 387347, 349457, 387355, 383734, 387351, 348368, 110090, 375624, 383730, 387335, 383727, 387235, 387103, 387227, 227509, 387101, 387113, 387097, 386560, 387094, 386958, 365476, 386952, 386950, 348367, 386626, 386920, 348365, 386942, 386911, 386694, 386638, 386636, 365468, 227491, 385641, 376568, 386604, 386614, 365465, 337139, 227482, 386601, 371480, 386583, 214799, 383721, 386542, 227480, 386538, 378283, 227459, 348322, 348319, 386370, 386293, 227441, 386357, 385734, 238766, 227436, 386159, 386310, 348314, 386288, 348412, 348312, 214726, 385317, 385315, 385440, 375921, 384516, 385331, 375919, 227393, 385327, 360787, 385325, 385312, 227390, 376837, 385181, 376835, 385178, 238651, 384712, 376080, 309970, 238633, 309968, 383445, 369914, 379869, 384069, 383656, 382913, 383927, 383925, 227322, 227315, 383361, 227313, 383650, 238547, 383345, 383336, 383331, 383256, 382191, 376829, 227288, 238520, 227279, 227274, 238517, 382454, 377426, 227265, 19798, 238514, 382451, 227262, 227260, 377424, 19795, 372468, 376071, 382164, 382092, 381866, 361798, 381899, 196814, 227218, 106344, 106340, 279826, 196802, 279822, 381245, 196796, 379844, 379842, 379743, 379474, 379196, 379392, 379189, 379335, 378053, 365067, 106329, 205315, 365058, 238406, 238401, 238399, 238396, 238393, 227160, 238388, 378250, 377893, 227142, 376808, 238331, 376803, 227000, 226989, 375906, 226967, 375904, 226962, 375900, 375898, 374922, 372222, 375714, 106165, 327063, 370962, 366725, 368508, 238052, 371319, 363829, 226759, 363817, 363812, 329987, 226724, 226722, 370256, 326910, 226667, 370253, 238014, 213754, 196466, 370239, 226660, 370194, 213733, 226636, 226630, 369885, 369880, 369977, 369878, 265475, 368833, 369974, 326903, 369896, 265470, 369778, 369764, 196460, 369508, 226603, 368937, 368828, 329968, 285444, 368678, 368874, 367989, 368826, 368821, 367987, 237961, 368502, 273355, 366086, 273353, 368008, 368004, 367840, 367836, 366633, 367874, 367828, 196433, 366698, 356876, 366622, 364621, 366507, 356874, 366596, 366580, 365482, 366573, 366479, 273343, 366446, 261241, 261238, 261235, 261233, 273341, 261228, 261225, 309920, 65468, 365446, 65465, 365745, 65456, 309917, 366099, 364276, 364274, 364374, 105963, 364271, 363800, 328904, 318033, 365054, 365413, 328900, 363795, 363792, 360711, 365033, 360706, 364363, 363790, 364963, 364958, 364357, 364956, 174200, 364254, 174197, 364195, 363980, 364191, 364179, 361519, 363727, 363773, 363627, 213348, 196389, 213339, 213336, 213334, 361432, 361789))
Run Time: 0.130153
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2475 | |
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 | | | | | 2475 | |
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 (30954, 30671, 30385, 30369, 30304, 29923, 28323, 27855, 26411, 26206, 25875, 25756, 24764, 24323, 24212, 23534, 22351, 21912, 21619, 19533, 32186, 18418, 18355, 18346))
Run Time: 0.001960
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 24 | 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 (591632, 527948, 393931, 527907, 527894, 527892, 591444, 527890, 393928, 527887, 393926, 527852, 591441, 527845, 367718, 438855, 200847, 438772, 591318, 438750, 591315, 438744, 438729, 590035, 590235, 438712, 591149, 591153, 438707, 554268, 591145, 438703, 200834, 438695, 591133, 590706, 438693, 554265, 591106, 546795, 590703, 438690, 590693, 546792, 591129, 438680, 591100, 591122, 554263, 546789, 590691, 591095, 590302, 591093, 546786, 591091, 200832, 591083, 438674, 591058, 591078, 591076, 438667, 554547, 554260, 438662, 590680, 590676, 438646, 266953, 438639, 554257, 438621, 591009, 590774, 590772, 591005, 590290, 586083, 548370, 109191, 590881, 590862, 221895, 418856, 438612, 418853, 381021, 418851, 438600, 589927, 571714, 590824, 589919, 589915, 110709, 571710, 438596, 481375, 554250, 554243, 438594, 548365, 571705, 590836, 571703, 571701, 571694, 548360, 548358, 438591, 571689, 571687, 548356, 438589, 589913, 548351, 548349, 532073, 590400, 590770, 590768, 590396, 590766, 109177, 590391, 438542, 548335, 548329, 548325, 590389, 548317, 556839, 246612, 221888, 556833, 221885, 556831, 590636, 554238, 590572, 590456, 246608, 589907, 589902, 554740, 589900, 590431, 589879, 589876, 587249, 590332, 200824, 573501, 514987, 438505, 590382, 246586, 438501, 221883, 221881, 221879, 221877, 221875, 590377, 246582, 221873, 438487, 590371, 453716, 221870, 577618, 585134, 438483, 575582, 16659, 575580, 438475, 200823, 575578, 438465, 438463, 438461, 109171, 532011, 349591, 438454, 588948, 200819, 590260, 578197, 576515, 590258, 438174, 578195, 590216, 438100, 438096, 590252, 590208, 590249, 246526, 438090, 246524, 576512, 579846, 590201, 221851, 590247, 590214, 437994, 221845, 579822, 576508, 246512, 221843, 437987, 330513, 437962, 246510, 470965, 221841, 579792, 579789, 420362, 246501, 579765, 437948, 590113, 531914, 590109, 437939, 590105, 579746, 590050, 437935, 590047, 246440, 437897, 590099, 437893, 590086, 579709, 221834, 590043, 246428, 200801, 437847, 246412, 246395, 590031, 221828, 246369, 246362, 538710, 437833, 579685, 221826, 590015, 437817, 334297, 334295, 589945, 589941, 437783, 437777, 437775, 437755, 589353, 346999, 453711, 536251, 589350, 589443, 589441, 437456, 437453, 437372, 581269, 437369, 589343, 589424, 589340, 589337, 573706, 589328, 527781, 553099, 588842, 588840, 553094, 362860, 587668, 588834, 589019, 588939, 588831, 309800, 309796, 309790, 333976, 575223, 570702, 587059, 436944, 436934, 246154, 581191, 581183, 453701, 587475, 389043, 389030, 587423, 587420, 587416, 331365, 587324, 436859, 577935, 554139, 436856, 587321, 436845, 587333, 436835, 436831, 436827, 221735, 554135, 587318, 436811, 587328, 436799, 554132, 109121, 587225, 436761, 587300, 436738, 398164, 398162, 380997, 436736, 310078, 436732, 310076, 310074, 587266, 622553, 622551, 310063, 587261, 587217, 436729, 310059, 587215, 310054, 436726, 310050, 587246, 586561, 579525, 436714, 536178, 587213, 587203, 586768, 622540, 587174, 531486, 586766, 436690, 587101, 587097, 436685, 573532, 569840, 569838, 587038, 110683, 587036, 586764, 110681, 587079, 569835, 110679, 584657, 436653, 110677, 110675, 586754, 423342, 174392, 586789, 110668, 221701, 110665, 586752, 110660, 436611, 436608, 586747, 585057, 585054, 586576, 436575, 586695, 586420, 586417, 586415, 586647, 547924, 579502, 579499, 423334, 579492, 423332, 586484, 221684, 579489, 436502, 586574, 586571, 579471, 423330, 579466, 579464, 579460, 423327, 579446, 579444, 310049, 436461, 436459, 436451, 586358, 436449, 436439, 586356, 586353, 436437, 586351, 436434, 586435, 436430, 586348, 586346, 152413, 123468, 586265, 586400, 586229, 586342, 586398, 572072, 458126, 436397, 586261, 575262, 368910, 436364, 436360, 586154, 436344, 585610, 586047, 585608, 586044, 586042, 585855, 246054, 246052, 585847, 575259, 531368, 548019, 585664, 585659, 436237, 436223, 420344, 542856, 436095, 436093, 436091, 221601, 585125, 245975, 436029, 245973, 420337, 309762, 511641, 436019, 309760, 578459, 585093, 584382, 245969, 309756, 436010, 542848, 542846, 309753, 584379, 315790, 436000, 578154, 584375, 435984, 569356, 489022, 554726, 315788, 489019, 435977, 315785, 559219, 556505, 554719, 570405, 435962, 221579, 576406, 309733, 554059, 493637, 245965, 309731, 576403, 558072, 622429, 584925, 353949, 221566, 309722, 584911, 309720, 245963, 309718, 584908, 581575, 493629, 584899, 435928, 435883, 435881, 435847, 584754, 584369, 584595, 109013, 584589, 584716, 554027, 221537, 584582, 581719, 578151, 245950, 536137, 584737, 584735, 579296, 435830, 584692, 584689, 584730, 579294, 584636, 584687, 584728, 584649, 584633, 584725, 584552, 584681, 221531, 579292, 584646, 579290, 584535, 584644, 578233, 584642, 539525, 584569, 584567, 581020, 245947, 584565, 580919, 570697, 584563, 110652, 110650, 578610, 435802, 579274, 584531, 206178, 579272, 245943, 584499, 579270, 579268, 579266, 584398, 584513, 511634, 511631, 584511, 584437, 584497, 584435, 435794, 584427, 315782, 579248, 579242, 584366, 435788, 581942, 435784, 584360, 200673, 584023, 435773, 581808, 581139, 435758, 584318, 435754, 539522, 584310, 577646, 200671, 584304, 584021, 578382, 581129, 578380, 577644, 435751, 526472, 584299, 221507, 435727, 435718, 578222, 435716, 581745, 435710, 581806, 584277, 571259, 578425, 435701, 412541, 435693, 571253, 412538, 578421, 578377, 109005, 578417, 584250, 221500, 544721, 576500, 576181, 500333, 500314, 221486, 500307, 581590, 221482, 435531, 537730, 499401, 499398, 500281, 572639, 518912, 584112, 580912, 435520, 531196, 537724, 412528, 324362, 435494, 537721, 412525, 110649, 110647, 584015, 221454, 584027, 578454, 412522, 581679, 581562, 625023, 578367, 581730, 310046, 412520, 536129, 576175, 357632, 581670, 581556, 110639, 110637, 579051, 581402, 581057, 389006, 465032, 435198, 465029, 551138, 581399, 465027, 578908, 435159, 435157, 581079, 435148, 581074, 563836, 581105, 577924, 551136, 551134, 423320, 581055, 412503, 581053, 435127, 412500, 435121, 578148, 108985, 569547, 578589, 245704, 578553, 549751, 578524, 578144, 578512, 578443, 578582, 578141, 578596, 569544, 578510, 578508, 399362, 235068, 578437, 221354, 235061, 570858, 434972, 235059, 578434, 434967, 578307, 578432, 578304, 578176, 578429, 578138, 578299, 578296, 578412, 578287, 578112, 554712, 367636, 481785, 578269, 578128, 577846, 453685, 330477, 235049, 235033, 412456, 235027, 245663, 578122, 235024, 412453, 434940, 577844, 314708, 412448, 235021, 434930, 314706, 245628, 108977, 314699, 578109, 526418, 221311, 485932, 577870, 536115, 539521, 539519, 412440, 575969, 577860, 484922, 577840, 390701, 577631, 346875, 234906, 576946, 108968, 575967, 234885, 577543, 575965, 412437, 575963, 367620, 110624, 108960, 577477, 310040, 434584, 412423, 573366, 367613, 484919, 434560, 434552, 245544, 434549, 573360, 285563, 577376, 522682, 577341, 485921, 554709, 234827, 485916, 554705, 577089, 108930, 577086, 234775, 530774, 108927, 108924, 245511, 530761, 544709, 576649, 574408, 576597, 369225, 576396, 434203, 469972, 234513, 576136, 576131, 310034, 245394, 551692, 575941, 530696, 575831, 551684, 245347, 245338, 575999, 245333, 576100, 245330, 234484, 245328, 573216, 574692, 575919, 551575, 575914, 575867, 575551, 575543, 575540, 575548, 567082, 463738, 463734, 463732, 575419, 367599, 433999, 463718, 575401, 433997, 463698, 433983, 110620, 575350, 574280, 574270, 341487, 575277, 485905, 539506, 575269, 572689, 110617, 574855, 573081, 574260, 234108, 572770, 200372, 574022, 332244, 234067, 526372, 485884, 536046, 574038, 526364, 433612, 433596, 553086, 234044, 571304, 433580, 556765, 573270, 573020, 573903, 573266, 573264, 573901, 573018, 220980, 398493, 573262, 433575, 573260, 420266, 573016, 433571, 433565, 573006, 222432, 573996, 234031, 574002, 547990, 567394, 569455, 573988, 553801, 530358, 234027, 553799, 573969, 572126, 573815, 367592, 433545, 234025, 573874, 553772, 547986, 523597, 573813, 573776, 523594, 573761, 573759, 565402, 573507, 573442, 220957, 553080, 471974, 412373, 573397, 200340, 244954, 553062, 463661, 463648, 572675, 463646, 569111, 569778, 417875, 570826, 110595, 244755, 571938, 336339, 572163, 569894, 233880, 571844, 571842, 273883, 568591, 273880, 273872, 273870, 273868, 453653, 553050, 553044, 553042, 412356, 571630, 515519, 571522, 571462, 233829, 544696, 551951, 551949, 547818, 551946, 551941, 233811, 309705, 485866, 309698, 336330, 110586, 110584, 110581, 110579, 110577, 110570, 571046, 570156, 220839, 570767, 570067, 432810, 432792, 569889, 220795, 206087, 367572, 309601, 570623, 570644, 569749, 244610, 570630, 432768, 570627, 570620, 569947, 535741, 220786, 432766, 233766, 526281, 432762, 553037, 553035, 553669, 570606, 570603, 432747, 553665, 110564, 110561, 553661, 110558, 110555, 110553, 432744, 419861, 419859, 569648, 569646, 570467, 570458, 558818, 535997, 569887, 570186, 282642, 570122, 570085, 558804, 570083, 569884, 200287, 569881, 544692, 569934, 417971, 569743, 432590, 365329, 365326, 432580, 569855, 569415, 569540, 432569, 432566, 206054, 432561, 518907, 560731, 569104, 560726, 336306, 558780, 568209, 432431, 568578, 514622, 514618, 514616, 514609, 568320, 206036, 432356, 568155, 529629, 565458, 568166, 432354, 485829, 553033, 567976, 432277, 567114, 529589, 553027, 220440, 527733, 566786, 396520, 563526, 396518, 396516, 562247, 624972, 432203, 133063, 535876, 431491, 233198, 558016, 244321, 557219, 233140, 233136, 558489, 558478, 552977, 552965, 557216, 485793, 558052, 557963, 556716, 557954, 431292, 412260, 557757, 552921, 557142, 557746, 485785, 390676, 110521, 557460, 556327, 390673, 110519, 380831, 244253, 557199, 9795, 233072, 553269, 233067, 557136, 380821, 557134, 110513, 485779, 110510, 557090, 380815, 556963, 555544, 404734, 556713, 233029, 556711, 556404, 537433, 404730, 233027, 556397, 404725, 529174, 556248, 555722, 555712, 431049, 525827, 9793, 388287, 430956, 233000, 535848, 552384, 539270, 550785, 547751, 232989, 232980, 547748, 430872, 232974, 544679, 430866, 554468, 544677, 544675, 544673, 552569, 539485, 430836, 552681, 552566, 539477, 550902, 552337, 430782, 550900, 519968, 398156, 552163, 541663, 529080, 550045, 529000, 547220, 318077, 549280, 528998, 548222, 525677, 546233, 547461, 318069, 544951, 450933, 232738, 244110, 525598, 525584, 545735, 545782, 398121, 502176, 373544, 545725, 525555, 545670, 545474, 545569, 389204, 515335, 515318, 544658, 367487, 519107, 429807, 542087, 429802, 219649, 380595, 232644, 232641, 528860, 544100, 544116, 485692, 535820, 544038, 429771, 544035, 543833, 393835, 429745, 544113, 380587, 412113, 525382, 525365, 525363, 525361, 421663, 528839, 478279, 543814, 539448, 543804, 543768, 511053, 536789, 525327, 511005, 505213, 542422, 542380, 232613, 244005, 541957, 542075, 525180, 525152, 525149, 469032, 541951, 429363, 525140, 541836, 541833, 485679, 525128, 541654, 541714, 620165, 429327, 541597, 525120, 525107, 525100, 541458, 200038, 541453, 525092, 525088, 429309, 485661, 525079, 525070, 541200, 515284, 339358, 525046, 525037, 492627, 541194, 540202, 492624, 525033, 525031, 429280, 515281, 412083, 412081, 515278, 539783, 528775, 429274, 624817, 456254, 624815, 429256, 110447, 524986, 540706, 536437, 528697, 456073, 528216, 524296, 524271, 524257, 528209, 524239, 528145, 528042, 524208, 524204, 232340, 428745, 527517, 514898, 513733, 321163, 511413, 385909, 527072, 428701, 451737, 526728, 396483, 526935, 326467, 404693, 412033, 428668, 414863, 524000, 517315, 412012, 412009, 243649, 243647, 404671, 428205, 520745, 520741, 428087, 108548, 519863, 519852, 519848, 455447, 519788, 519505, 515762, 362848, 428071, 485496, 519582, 428049, 519580, 485494, 428043, 519501, 519496, 428021, 412002, 427963, 329582, 518733, 518418, 412000, 329563, 517919, 517914, 517912, 514420, 517909, 517534, 515257, 514221, 514066, 513997, 511833, 513791, 513293, 512914, 512581, 512704, 380431, 512523, 512254, 511554, 427628, 403351, 456050, 456048, 511550, 456046, 456044, 456041, 385895, 511782, 511780, 385892, 512309, 330296, 494702, 330293, 455434, 511776, 427492, 511471, 511373, 511162, 427457, 427454, 453483, 199656, 509189, 509527, 509390, 411938, 508436, 508258, 469815, 469813, 507789, 507828, 507947, 507815, 426990, 426988, 426982, 188799, 426976, 469800, 504378, 231863, 199579, 506883, 506316, 231849, 243294, 414820, 505881, 505831, 485324, 426877, 505785, 494683, 421888, 505617, 503115, 490344, 490339, 317158, 317156, 426769, 199537, 317135, 243197, 505303, 504706, 505253, 504704, 504923, 504696, 504905, 504689, 401005, 504836, 231760, 504595, 504548, 494808, 504631, 504683, 499580, 504344, 504131, 504319, 469397, 199506, 231675, 205828, 231639, 426638, 504067, 426633, 503918, 243118, 342798, 243115, 342786, 501983, 329347, 503494, 231565, 503410, 388175, 231548, 503356, 503371, 349399, 349395, 503347, 413763, 503345, 388170, 449113, 489114, 243035, 489111, 502982, 468980, 494679, 494677, 323549, 231518, 243023, 231478, 231473, 243018, 231467, 502065, 268955, 231457, 389157, 323546, 325012, 501310, 624729, 494907, 371209, 501402, 469785, 501399, 501392, 387828, 501283, 501323, 494887, 501319, 501317, 380372, 337015, 500250, 500889, 500872, 500866, 500864, 426233, 500489, 426231, 500855, 469781, 426229, 205815, 469779, 349385, 469777, 469775, 242983, 500453, 426222, 426218, 500241, 400098, 500438, 500236, 500433, 400096, 242972, 499090, 500003, 417782, 426191, 108205, 469773, 402707, 499665, 499637, 499657, 499060, 499217, 380359, 498316, 499004, 468954, 498311, 110326, 498706, 498689, 498462, 498452, 498254, 23475, 380351, 324320, 497720, 497399, 497619, 497393, 496638, 496249, 496395, 455378, 492526, 495609, 455354, 288814, 288810, 494794, 495192, 495031, 494638, 494989, 494831, 494636, 494790, 493359, 494341, 360008, 425584, 490945, 487951, 487945, 487938, 485132, 425219, 484162, 484160, 486306, 483354, 107957, 473922, 477915, 477834, 473904, 107865, 462711, 473886, 473884, 474814, 474839, 473846, 474500, 474492, 469270, 469268, 474257, 473836, 473805, 472788, 469264, 265524, 473672, 424620, 265517, 472874, 472534, 472721, 308845, 472786, 472784, 472790, 472682, 471492, 471641, 471639, 471490, 471008, 398081, 458725, 470993, 398079, 470819, 470657, 458712, 470648, 398074, 458708, 470067, 469538, 469323, 468197, 462686, 468182, 468286, 468054, 467060, 388137, 467344, 424326, 424322, 466214, 466603, 398070, 464883, 424245, 466078, 198612, 466074, 466072, 466355, 466299, 464877, 464872, 466064, 198594, 466104, 466102, 466061, 465942, 241744, 315716, 465128, 465125, 465122, 462655, 465593, 465113, 465581, 465577, 424185, 424174, 464991, 464988, 464984, 464969, 456113, 315713, 424155, 424153, 461960, 461957, 205630, 464653, 198535, 464651, 464649, 463138, 464363, 463990, 107730, 455094, 464202, 462435, 198502, 261301, 463871, 463862, 205611, 463317, 460976, 463315, 462543, 380231, 450828, 461947, 461912, 461909, 461906, 461994, 461964, 461826, 229814, 229811, 461710, 344527, 107673, 344525, 461534, 344521, 107646, 461030, 461026, 198415, 461049, 460918, 460954, 460681, 460679, 423950, 460354, 198368, 459836, 460203, 459919, 460106, 457995, 457991, 457988, 423913, 398372, 459661, 423910, 459642, 459658, 198352, 459147, 459141, 459093, 459118, 458860, 458659, 458344, 389944, 449612, 389942, 261288, 380223, 457647, 457545, 457299, 423881, 457016, 423867, 398055, 456652, 396150, 396148, 380213, 456401, 455692, 336965, 455996, 455854, 453348, 376107, 455134, 455598, 423845, 453199, 198226, 453197, 454056, 455167, 413741, 423837, 423835, 454052, 423832, 188738, 413415, 392328, 455139, 413412, 450219, 455047, 455045, 455043, 455041, 455039, 454954, 413739, 198190, 454202, 380201, 380199, 380196, 454103, 453870, 380194, 380191, 453031, 452621, 452612, 110197, 452610, 448415, 451711, 449105, 452372, 198139, 450754, 450749, 23407, 452132, 452260, 452210, 452095, 452245, 452130, 265495, 380179, 371027, 451701, 451687, 451676, 205536, 188732, 375257, 188730, 451345, 107488, 451352, 451317, 450734, 451309, 451306, 451300, 188714, 451287, 451276, 451008, 449355, 451002, 450701, 423683, 449554, 449497, 448698, 449492, 448696, 449489, 448694, 449226, 449179, 449328, 380145, 448995, 389940, 448672, 423785, 448668, 448665, 374330, 374328, 404918, 448368, 448287, 447791, 448110, 423715, 423120, 107383, 294535, 380097, 422779, 422777, 229161, 422683, 422695, 411610, 421375, 408042, 421372, 419379, 420192, 419654, 330093, 405314, 418992, 418526, 413734, 413732, 418190, 417998, 418186, 349371, 347738, 417402, 356360, 417990, 417988, 240712, 240710, 380040, 415787, 359890, 110155, 415699, 416607, 416616, 398942, 393297, 415142, 415782, 415138, 415129, 414397, 414587, 414385, 315690, 413274, 413212, 403347, 389928, 412639, 389920, 402102, 401821, 397151, 402350, 398579, 395787, 395775, 239314, 394842, 239239, 227694, 227686, 227652, 239091, 239082, 285470, 390263, 389125, 389887, 254865, 389843, 238990, 389881, 390189, 106546, 389383, 389877, 387780, 389870, 387777, 389868, 616615, 616595, 285467, 375757, 387896, 388679, 388644, 389524, 227575, 238904, 616565, 616561, 348373, 389319, 227565, 387002, 387956, 387952, 385048, 388482, 387120, 388424, 386996, 387755, 285462, 387572, 387747, 383748, 387745, 388421, 214885, 227552, 383746, 383741, 383112, 387591, 387117, 387565, 387490, 616524, 383738, 387115, 387521, 387556, 387518, 238845, 387487, 383462, 387319, 387317, 386971, 387347, 349457, 387355, 383734, 387351, 348368, 110090, 375624, 383730, 387335, 383727, 387235, 387103, 387227, 227509, 387101, 387113, 387097, 386560, 387094, 386958, 365476, 386952, 386950, 348367, 386626, 386920, 348365, 386942, 386911, 386694, 386638, 386636, 365468, 227491, 385641, 376568, 386604, 386614, 365465, 337139, 227482, 386601, 371480, 386583, 214799, 383721, 386542, 227480, 386538, 378283, 227459, 348322, 348319, 386370, 386293, 227441, 386357, 385734, 238766, 227436, 386159, 386310, 348314, 386288, 348412, 348312, 214726, 385317, 385315, 385440, 375921, 384516, 385331, 375919, 227393, 385327, 360787, 385325, 385312, 227390, 376837, 385181, 376835, 385178, 238651, 384712, 376080, 309970, 238633, 309968, 383445, 369914, 379869, 384069, 383656, 382913, 383927, 383925, 227322, 227315, 383361, 227313, 383650, 238547, 383345, 383336, 383331, 383256, 382191, 376829, 227288, 238520, 227279, 227274, 238517, 382454, 377426, 227265, 19798, 238514, 382451, 227262, 227260, 377424, 19795, 372468, 376071, 382164, 382092, 381866, 361798, 381899, 196814, 227218, 106344, 106340, 279826, 196802, 279822, 381245, 196796, 379844, 379842, 379743, 379474, 379196, 379392, 379189, 379335, 378053, 365067, 106329, 205315, 365058, 238406, 238401, 238399, 238396, 238393, 227160, 238388, 378250, 377893, 227142, 376808, 238331, 376803, 227000, 226989, 375906, 226967, 375904, 226962, 375900, 375898, 374922, 372222, 375714, 106165, 327063, 370962, 366725, 368508, 238052, 371319, 363829, 226759, 363817, 363812, 329987, 226724, 226722, 370256, 326910, 226667, 370253, 238014, 213754, 196466, 370239, 226660, 370194, 213733, 226636, 226630, 369885, 369880, 369977, 369878, 265475, 368833, 369974, 326903, 369896, 265470, 369778, 369764, 196460, 369508, 226603, 368937, 368828, 329968, 285444, 368678, 368874, 367989, 368826, 368821, 367987, 237961, 368502, 273355, 366086, 273353, 368008, 368004, 367840, 367836, 366633, 367874, 367828, 196433, 366698, 356876, 366622, 364621, 366507, 356874, 366596, 366580, 365482, 366573, 366479, 273343, 366446, 261241, 261238, 261235, 261233, 273341, 261228, 261225, 309920, 65468, 365446, 65465, 365745, 65456, 309917, 366099, 364276, 364274, 364374, 105963, 364271, 363800, 328904, 318033, 365054, 365413, 328900, 363795, 363792, 360711, 365033, 360706, 364363, 363790, 364963, 364958, 364357, 364956, 174200, 364254, 174197, 364195, 363980, 364191, 364179, 361519, 363727, 363773, 363627, 213348, 196389, 213339, 213336, 213334, 361432, 361789))
Run Time: 0.046012
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2475 | |
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 | | | | | 2475 | |
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 (30954, 30671, 30385, 30369, 30304, 29923, 28323, 27855, 26411, 26206, 25875, 25756, 24764, 24323, 24212, 23534, 22351, 21912, 21619, 19533, 32186, 18418, 18355, 18346))
Run Time: 0.001391
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 24 | 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.000219
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.000381
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.000493
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: 1716174532
Run Time: 0.000336
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 35 | 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` >= 1716174532)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000665
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 35 | 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