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.000514
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.000131
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` = '5039')
LIMIT 1
Run Time: 0.000386
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.002150
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_5039' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.065514
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 (594804, 439240, 580142, 439233, 439226, 246654, 221578, 584907, 109017, 554031, 584533, 578369, 200667, 579044, 579004, 578975, 554018, 434976, 235074, 554011, 554008, 235057, 578297, 578286, 434954, 434952, 434950, 434948, 235051, 554000, 553998, 235043, 235041, 245688, 245686, 245684, 245681, 235036, 235034, 235029, 235025, 526433, 434873, 526426, 526424, 434868, 526419, 434865, 577867, 434815, 434811, 434805, 434800, 553995, 553992, 434711, 553988, 553986, 434687, 530857, 434301, 577069, 530751, 576413, 245305, 553937, 245240, 433919, 544745, 234420, 234417, 574615, 574613, 234405, 234402, 234398, 234395, 574608, 574598, 574593, 574591, 234393, 234389, 553908, 234369, 234365, 234356, 433888, 234326, 234320, 234307, 574857, 574588, 574584, 245170, 245146, 574577, 574575, 574570, 574568, 574565, 574555, 433865, 433853, 433851, 433841, 433838, 433836, 433830, 433827, 433821, 433817, 433812, 433810, 433799, 433797, 433795, 433790, 245108, 234288, 234286, 574545, 234284, 433781, 245089, 433773, 234279, 234276, 234274, 553895, 433762, 234262, 570834, 553892, 574542, 526392, 526389, 574539, 574536, 574534, 574531, 574529, 234247, 574527, 234244, 574524, 553888, 553886, 234239, 553883, 234222, 234219, 234214, 234208, 433713, 433711, 245070, 433708, 245067, 245065, 433705, 234162, 553879, 433680, 234150, 234147, 553877, 245047, 433658, 433654, 553873, 234071, 433614, 433611, 433608, 433605, 553864, 433602, 234062, 234059, 433594, 433586, 234057, 234049, 553844, 553842, 553839, 553836, 433579, 553834, 553829, 234041, 553769, 553760, 233952, 233950, 233943, 530168, 572578, 433376, 553752, 553750, 433372, 553748, 433370, 233937, 572484, 433353, 572481, 572478, 572470, 572464, 433332, 433326, 433321, 433318, 433313, 433307, 433304, 433294, 433284, 244771, 244769, 433270, 433249, 244762, 397408, 397406, 397403, 553746, 233920, 233901, 233897, 433215, 553743, 233895, 433212, 433203, 572147, 433191, 433189, 572144, 233892, 433180, 572161, 572159, 233889, 572141, 572138, 572183, 433173, 233885, 433165, 433157, 433155, 433153, 433151, 244728, 556863, 571846, 244726, 433146, 433096, 433094, 433090, 433086, 530090, 553741, 433077, 433075, 433073, 433053, 433027, 233850, 233847, 233839, 233837, 432953, 432950, 432939, 432936, 432934, 526321, 432919, 526296, 526290, 432903, 233809, 414401, 309701, 309696, 309690, 571226, 571224, 571220, 571213, 432882, 164638, 244667, 233787, 553697, 553690, 432863, 432860, 553686, 432858, 553675, 309648, 432845, 432841, 432824, 432821, 432817, 233771, 432760, 233757, 233751, 570489, 432741, 432725, 432718, 553575, 432716, 432714, 432712, 432710, 432707, 570466, 570477, 233745, 233699, 570118, 553556, 523572, 523570, 432611, 553554, 233664, 355928, 432556, 432553, 432548, 164605, 108818, 535957, 432544, 553502, 553496, 432515, 553494, 553490, 553488, 553486, 553484, 244568, 220565, 220558, 432466, 220549, 432461, 432459, 432457, 432454, 567887, 567884, 569262, 432447, 569233, 496695, 496693, 496684, 496681, 569006, 432417, 244552, 244550, 432413, 432407, 432405, 526247, 526245, 526242, 526237, 526235, 432389, 526232, 553464, 526227, 526225, 526222, 526220, 568421, 567295, 567292, 567290, 432324, 233568, 526211, 526209, 526203, 220487, 526200, 547139, 547135, 432318, 536496, 252882, 432303, 526196, 526191, 526188, 432296, 432294, 554915, 554912, 567334, 554902, 432282, 220463, 526186, 526183, 526180, 432278, 432264, 220461, 526177, 526175, 526173, 526169, 233565, 233563, 233561, 432254, 432251, 432247, 526166, 526163, 526159, 220429, 526157, 526152, 526150, 567285, 567283, 567275, 567272, 567270, 432243, 526148, 567305, 419467, 432241, 432239, 567303, 567299, 244526, 244524, 233552, 233548, 233546, 469051, 233543, 567173, 233540, 432235, 432231, 432226, 553463, 432219, 432217, 432213, 526147, 526144, 553459, 526142, 526138, 432212, 432200, 553451, 526123, 200252, 432139, 526119, 526117, 526113, 526101, 526097, 526094, 526092, 526090, 565517, 526086, 553448, 432083, 432071, 432068, 432066, 432063, 432061, 432031, 526071, 432029, 553445, 526065, 564695, 526063, 526055, 526051, 553434, 553432, 432009, 553430, 432006, 432004, 526043, 564718, 564716, 526039, 432000, 431996, 431992, 526034, 483424, 431981, 562867, 563587, 562864, 562862, 431974, 563584, 563582, 431968, 562860, 233506, 233504, 564534, 405843, 233502, 553426, 233495, 233493, 233490, 233475, 233473, 233471, 233466, 233464, 233460, 233456, 233454, 233451, 233449, 552731, 233439, 233437, 233432, 431958, 431956, 431953, 556632, 233425, 233420, 431946, 562786, 563977, 405837, 309543, 309541, 405831, 405827, 405825, 559446, 453631, 431939, 405818, 431916, 431914, 392844, 431900, 431897, 553422, 392543, 431879, 309537, 431876, 244466, 244463, 220246, 535910, 244458, 553420, 431843, 431750, 431748, 431745, 431743, 431723, 553411, 553406, 553404, 553402, 553400, 332599, 431720, 431718, 431715, 431713, 431710, 431708, 553397, 562770, 562767, 553381, 553379, 233388, 553373, 285552, 553369, 553361, 553359, 431704, 553353, 529408, 469047, 431698, 529403, 309477, 244433, 431696, 562446, 562229, 244429, 244426, 220222, 244410, 220212, 244406, 244404, 220204, 220199, 220197, 233365, 553351, 233363, 553349, 233361, 431692, 553347, 431688, 561949, 561948, 561946, 561940, 561938, 561916, 526003, 233349, 233340, 491087, 491085, 491082, 233330, 233316, 553345, 233312, 233295, 431682, 529356, 525979, 553344, 560940, 560936, 314665, 553342, 553340, 431664, 431662, 431658, 431656, 174320, 174318, 557711, 553337, 233271, 431651, 431649, 233265, 220117, 557708, 431640, 557700, 529320, 431637, 557698, 529317, 557695, 557693, 557690, 554523, 557686, 557680, 553333, 557673, 431623, 431602, 431598, 560367, 553330, 553327, 557652, 553325, 553323, 233230, 233227, 108797, 233225, 233222, 244362, 244358, 233208, 550126, 431530, 431528, 306513, 306511, 306509, 431520, 431509, 233203, 233201, 431503, 233199, 431500, 306504, 431496, 306499, 306497, 306495, 306491, 233196, 306488, 306481, 306479, 244349, 233188, 306476, 306474, 306472, 306470, 553316, 525915, 525910, 553312, 306466, 553310, 306464, 306458, 306454, 306450, 306448, 233180, 306445, 306442, 306439, 306437, 233172, 553307, 431466, 233168, 233165, 233161, 233155, 431464, 244334, 431462, 553002, 553000, 552729, 244330, 431459, 431456, 431454, 431450, 431448, 431445, 431443, 244328, 558258, 553301, 529265, 431427, 431423, 431421, 558251, 431413, 244315, 244312, 244310, 244308, 431409, 431406, 431404, 558008, 558379, 244299, 558372, 558539, 431387, 558431, 244266, 244263, 244261, 558368, 244258, 529252, 108793, 431372, 557626, 557616, 557613, 557607, 557601, 557599, 557596, 557594, 556219, 529236, 108780, 431343, 557590, 431339, 431336, 431333, 431330, 431327, 431325, 557586, 431322, 431309, 431306, 431300, 431293, 557573, 557571, 557528, 557526, 557512, 557508, 431286, 557504, 557499, 431284, 557497, 252868, 553289, 553284, 557495, 557484, 200216, 553282, 553280, 553278, 553273, 233075, 233073, 431260, 553271, 431253, 553268, 233066, 553266, 553264, 557071, 553259, 557068, 220011, 553257, 553255, 553251, 553247, 553244, 553241, 553239, 535861, 553237, 553235, 557065, 553233, 553231, 553227, 553225, 553223, 525871, 330408, 431231, 200213, 330406, 553221, 233051, 233036, 431198, 431195, 431192, 431190, 431186, 431183, 553215, 200209, 553213, 431180, 431167, 431164, 431162, 553209, 553207, 553204, 431144, 553201, 556060, 553196, 553194, 555939, 553187, 553183, 244248, 553179, 553177, 553173, 553168, 553166, 553164, 431100, 431098, 244239, 244230, 431061, 553160, 431059, 431057, 431055, 431048, 431012, 200206, 553157, 553154, 553152, 553149, 452730, 553145, 553137, 430990, 430985, 555043, 555311, 555309, 430976, 547761, 430973, 525823, 430966, 430961, 430917, 525784, 555110, 200202, 554797, 200199, 200197, 554791, 430912, 552726, 430909, 552724, 552723, 552719, 552713, 552711, 430887, 430878, 232949, 430867, 554467, 430859, 554462, 552707, 430845, 430842, 552705, 552703, 552697, 552694, 552690, 552679, 552676, 552674, 552667, 552662, 232908, 232906, 430781, 232893, 232891, 232889, 539324, 430706, 430704, 430696, 430648, 430645, 430643, 232865, 232863, 232861, 430625, 232855, 200183, 244179, 430612, 430609, 244177, 244171, 244167, 430600, 430597, 430587, 548603, 430519, 550106, 430475, 550104, 430472, 232796, 232794, 548251, 549266, 549262, 549252, 430360, 430330, 548087, 548033, 511456, 232757, 547708, 547702, 545839, 547367, 430156, 108713, 430098, 525661, 430078, 528946, 547105, 200132, 449615, 525646, 430029, 430027, 430025, 546070, 545935, 232727, 232723, 232713, 200111, 429856, 429841, 525433, 544591, 544587, 429819, 232683, 200086, 525419, 249734, 544383, 525400, 525398, 429778, 525396, 542273, 232637, 429759, 429756, 536569, 429717, 429708, 429667, 429660, 429648, 232624, 543657, 429639, 429635, 429633, 429628, 429610, 429608, 429595, 429585, 429539, 429522, 429518, 429512, 429474, 542553, 502170, 232614, 497821, 542117, 542113, 108677, 108675, 108672, 345788, 345783, 108657, 488540, 108650, 108648, 108646, 108644, 525134, 541532, 429332, 429329, 429326, 525118, 525113, 540643, 243987, 243982, 243980, 524735, 524725, 396485, 516701, 537593, 537562, 537551, 524689, 428978, 243891, 524668, 537419, 482917, 482915, 524658, 524656, 524654, 524647, 524641, 524638, 524631, 524627, 524624, 524622, 536761, 199967, 536940, 232468, 524618, 524615, 524612, 219374, 232458, 524602, 524597, 524593, 524585, 457738, 457735, 428947, 524573, 524572, 524570, 428942, 428940, 524568, 524564, 524561, 249723, 428928, 249721, 249719, 428916, 428912, 428910, 428908, 536894, 428906, 494954, 428902, 428896, 428894, 428886, 457732, 428884, 428880, 524559, 243876, 524555, 243871, 243869, 428861, 243867, 243865, 243863, 428853, 243860, 428846, 243858, 243856, 524550, 428843, 535345, 524547, 524545, 524543, 536526, 536543, 524528, 367440, 535630, 535624, 535620, 535617, 535615, 428827, 524519, 428823, 524508, 428815, 535250, 519398, 524488, 428805, 243843, 535291, 485579, 519395, 535288, 485577, 535286, 524479, 524476, 428792, 428790, 524473, 428788, 524471, 524459, 524448, 524445, 524440, 524431, 524429, 524426, 524412, 524404, 524401, 524399, 524397, 524394, 524379, 351640, 341760, 351637, 524374, 524367, 524361, 351634, 524359, 199946, 199944, 199942, 516686, 524347, 528585, 528394, 524331, 524326, 528392, 524324, 232366, 528263, 528257, 528249, 528247, 428770, 528245, 528242, 528240, 524313, 524310, 524307, 524304, 524293, 524263, 524261, 524259, 232351, 524252, 524250, 524242, 524238, 524236, 524234, 524229, 524209, 428738, 524203, 524200, 527316, 527314, 527021, 527018, 473558, 232321, 232314, 232312, 524185, 524178, 524166, 362436, 524164, 526589, 524162, 389386, 524160, 524154, 524151, 524147, 524139, 428641, 428638, 524135, 524133, 428633, 524131, 524129, 199914, 524126, 362434, 524002, 428629, 524122, 524120, 524118, 524115, 524113, 524106, 524103, 524099, 526529, 524096, 524093, 523995, 524087, 524078, 524073, 428610, 428607, 523991, 428599, 14947, 524057, 524050, 496560, 526524, 524048, 428593, 428582, 523845, 524032, 524025, 243794, 523985, 428575, 524022, 428571, 524020, 523983, 523981, 428568, 523979, 523975, 428563, 523970, 523968, 523175, 523964, 428561, 523961, 428548, 199908, 199906, 523774, 199904, 428542, 428538, 523231, 428534, 523551, 523772, 523546, 523543, 523796, 523541, 523228, 523539, 522928, 523536, 523534, 523531, 243782, 523631, 328735, 232300, 523522, 428528, 232297, 243776, 232294, 428526, 232291, 243774, 243772, 344571, 243760, 428523, 428519, 428483, 522100, 397289, 428455, 498108, 498104, 522705, 428443, 428441, 522703, 522700, 428413, 243702, 243700, 243695, 516594, 243688, 243682, 243679, 344566, 522167, 428406, 428400, 328726, 428398, 428368, 428364, 428356, 428347, 428343, 521938, 521339, 428277, 428272, 521067, 521061, 353137, 521059, 520999, 520995, 428209, 428204, 519198, 520521, 428188, 419790, 428174, 419787, 419785, 501689, 355894, 428161, 355888, 428158, 428153, 428150, 428148, 428145, 501639, 501634, 508045, 508043, 485500, 508041, 232256, 219060, 519923, 519919, 519905, 519902, 519889, 519878, 519875, 428103, 428100, 519872, 428097, 219051, 428077, 482702, 482697, 519628, 519626, 519624, 519621, 519619, 519615, 519613, 519611, 519551, 519549, 519609, 519547, 519607, 515627, 428052, 519540, 519605, 519603, 428045, 519600, 519598, 519596, 428042, 232253, 232247, 199830, 427943, 427940, 232233, 232227, 232224, 232214, 518246, 427882, 518208, 518205, 518203, 517941, 232203, 232201, 218917, 232193, 427850, 108522, 427843, 427839, 427837, 232191, 427835, 427833, 108516, 427830, 427827, 427825, 427823, 108512, 199801, 199799, 232189, 108505, 232187, 108502, 517012, 108500, 108498, 232176, 108495, 108493, 509736, 108490, 232173, 108488, 232171, 517007, 427816, 427752, 218867, 427750, 427744, 427742, 427740, 427734, 427729, 427727, 232120, 515256, 515252, 515250, 232117, 515245, 514475, 232110, 515238, 514473, 514469, 232106, 232103, 232098, 232096, 514464, 514462, 232090, 232080, 232078, 232075, 232070, 513481, 512826, 512823, 512327, 232068, 512821, 218697, 427658, 512860, 427637, 427621, 427619, 427610, 427607, 427576, 427563, 243498, 427529, 485394, 485385, 427451, 427446, 243461, 218603, 455427, 243434, 199693, 510440, 231983, 231977, 427288, 427285, 427207, 243410, 243404, 509239, 509146, 509144, 231916, 508860, 508858, 507907, 243270, 243204, 231803, 231801, 243200, 243196, 243193, 504772, 231787, 504760, 401018, 401014, 401011, 401009, 401004, 231745, 405755, 243166, 231712, 231709, 231703, 231701, 243163, 231697, 243152, 231686, 231679, 231676, 231671, 231659, 231653, 231650, 231641, 426647, 231631, 231609, 402711, 402709, 402706, 426187, 330247, 495628, 231165, 231160, 231158, 231152, 425845, 495397, 455320, 455318, 455315, 231133, 231127, 397597, 376203, 425794, 425773, 242878, 425743, 425739, 494281, 493982, 493261, 492958, 492956, 493062, 492954, 492952, 492948, 492944, 242798, 492507, 492502, 485202, 230946, 230940, 230930, 376159, 230904, 425577, 491459, 491457, 230893, 230891, 425572, 425566, 425561, 425559, 425556, 230881, 425552, 425550, 491003, 425548, 491146, 425538, 425533, 425531, 491173, 491171, 491168, 199247, 491164, 489831, 489826, 249716, 488810, 488524, 199144, 483697, 486432, 367224, 485092, 399256, 482348, 484902, 485099, 230683, 425161, 230679, 482346, 425157, 132704, 367218, 484993, 484984, 230659, 425152, 230648, 199127, 482344, 425149, 404187, 404185, 471686, 468913, 425133, 484198, 483693, 199118, 483691, 205763, 484196, 484194, 372764, 484192, 372760, 484378, 484376, 230634, 230632, 484189, 484187, 425125, 483686, 483684, 199111, 483682, 483680, 483675, 199105, 483672, 199101, 242506, 484077, 484075, 242501, 242498, 199099, 484010, 425114, 199097, 230594, 483944, 242495, 242492, 483139, 483136, 483929, 483926, 483924, 483922, 483917, 483914, 482986, 483133, 483131, 483909, 230590, 199094, 483128, 483626, 483624, 483357, 483620, 483635, 483355, 483633, 132680, 483126, 483617, 483615, 425110, 425104, 425101, 483349, 483347, 217557, 483345, 18897, 483342, 454092, 618458, 618454, 618452, 242467, 18893, 199083, 425099, 483124, 483121, 217552, 483119, 483117, 483115, 483111, 483109, 242463, 483106, 483033, 483030, 483028, 480809, 483022, 483020, 199078, 199076, 199073, 425095, 482966, 482963, 482961, 482959, 199066, 618446, 161851, 618440, 161847, 161845, 330202, 618436, 482707, 230587, 468908, 230585, 618432, 482655, 425086, 425082, 217529, 217521, 482577, 482257, 482538, 242442, 482255, 402700, 482013, 230550, 230476, 217434, 479274, 199016, 230463, 230459, 230457, 217430, 230454, 479798, 230448, 230436, 230434, 230432, 479708, 476748, 230430, 476743, 242308, 242306, 242304, 242302, 479740, 476741, 479738, 230423, 230415, 479418, 479261, 479259, 479257, 11930, 11923, 11919, 11915, 473943, 11907, 11905, 11899, 11896, 478944, 230399, 424798, 230324, 230317, 230315, 230313, 198963, 198954, 198939, 198937, 476478, 476474, 424764, 424757, 424754, 198933, 198931, 424751, 198929, 198927, 198925, 424747, 476448, 476446, 476393, 476388, 110290, 110288, 198923, 424729, 424724, 473480, 424720, 198917, 424705, 424703, 476182, 424701, 476172, 476170, 198912, 476167, 476164, 424694, 424692, 198908, 424690, 424687, 424683, 476162, 476160, 475446, 198905, 424669, 242200, 242198, 198903, 198894, 424640, 473801, 265526, 473457, 198845, 265521, 265518, 265515, 268933, 472822, 198843, 618131, 424605, 473081, 198839, 471013, 471482, 471367, 397205, 198765, 470605, 198750, 198742, 470360, 470038, 453285, 470036, 230091, 470033, 470031, 470029, 470026, 470022, 470020, 470017, 470014, 217037, 469533, 469530, 469486, 469485, 468375, 468373, 468371, 468369, 468363, 468361, 198662, 424412, 216957, 198656, 449959, 449957, 449955, 449953, 216948, 449951, 449949, 449946, 449943, 449941, 618029, 618025, 618022, 230025, 230021, 468115, 468113, 618017, 468111, 468108, 424396, 198653, 241896, 468060, 467996, 241872, 241869, 241867, 467986, 467977, 467973, 241860, 467969, 424387, 467966, 467958, 467955, 467953, 467947, 229965, 464174, 464172, 467697, 467439, 467431, 467424, 424328, 467042, 466649, 464134, 466082, 466077, 464127, 353081, 241748, 241746, 424222, 465135, 465133, 465899, 198583, 198582, 465131, 465781, 465779, 461270, 465129, 465126, 465123, 465121, 424201, 465119, 465117, 465115, 424198, 424196, 461257, 465111, 421738, 198558, 464658, 465066, 229925, 465062, 465059, 229918, 465057, 465055, 465053, 229915, 465051, 465361, 464112, 460609, 460607, 460605, 464109, 465276, 464107, 464105, 464101, 460602, 465273, 465105, 424162, 424160, 424158, 424156, 229894, 464088, 464086, 464073, 464071, 464057, 198524, 464053, 464051, 464049, 464045, 464043, 464038, 464034, 464519, 464026, 464024, 464018, 464016, 464013, 198519, 639826, 424140, 424135, 424133, 424130, 464006, 464002, 463999, 198504, 424125, 367125, 229891, 261304, 229888, 229885, 229882, 463811, 463806, 463801, 463799, 463796, 463829, 229876, 463826, 463824, 463783, 198485, 463821, 424113, 424109, 424108, 424104, 424099, 198482, 424097, 424095, 424093, 424091, 241667, 424089, 461689, 229863, 229859, 229857, 229855, 241659, 402698, 402692, 402686, 402679, 402676, 402670, 198472, 424085, 198470, 424083, 463153, 462929, 462927, 462918, 462914, 462912, 454328, 368373, 198454, 617978, 368369, 241648, 368367, 461936, 265508, 198449, 367119, 462194, 462048, 424044, 424042, 229838, 462173, 462043, 229835, 229829, 462016, 229826, 229823, 461672, 461670, 198436, 461662, 229813, 344528, 344526, 344523, 311461, 229799, 198431, 424005, 198419, 198414, 424002, 423997, 423995, 198412, 198410, 461016, 460766, 460821, 460834, 198401, 460764, 460763, 198400, 265503, 265502, 423982, 423980, 423975, 423973, 132396, 423952, 423945, 460379, 423942, 198394, 198391, 198389, 198388, 198386, 198382, 423937, 198374, 198373, 198370, 376132, 460208, 460353, 454319, 198367, 198361, 459189, 459187, 459184, 459182, 459180, 454316, 458827, 458868, 458688, 456861, 457947, 457944, 457917, 458287, 458438, 458237, 458235, 261286, 457907, 457903, 449655, 457809, 457649, 449645, 457714, 457597, 457590, 457585, 457578, 457568, 454307, 454299, 454297, 453083, 448914, 448912, 448909, 449807, 451993, 417713, 451453, 420869, 416809, 409940, 449637, 449634, 449447, 290997, 449444, 290995, 449227, 449259, 420863, 420860, 420858, 448715, 448488, 448428, 448424, 447970, 447852, 279392, 423017, 422776, 422529, 422526, 422115, 422112, 422212, 422192, 422190, 419179, 419178, 418556, 410853, 617319, 397165, 365041, 400647, 417064, 410848, 416211, 416623, 415559, 409927, 409923, 413499, 386798, 414424, 413494, 413475, 413473, 413471, 413466, 413111, 413109, 413107, 413105, 413103, 409922, 409920, 410840, 409919, 409917, 409915, 409027, 409913, 409013, 409011, 409010, 409008, 409006, 409004, 409002, 408264, 408263, 408262, 408261, 408259, 408254, 408253, 408252, 408250, 408248, 405937, 404183, 404180, 404178, 404176, 215549))
Run Time: 0.083763
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2479 | |
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 | | | | | 2479 | |
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 (28479, 27050, 25398, 24194, 23896, 23209, 22676, 21111, 20958, 20826, 20550))
Run Time: 0.001656
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 11 | 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 (594804, 439240, 580142, 439233, 439226, 246654, 221578, 584907, 109017, 554031, 584533, 578369, 200667, 579044, 579004, 578975, 554018, 434976, 235074, 554011, 554008, 235057, 578297, 578286, 434954, 434952, 434950, 434948, 235051, 554000, 553998, 235043, 235041, 245688, 245686, 245684, 245681, 235036, 235034, 235029, 235025, 526433, 434873, 526426, 526424, 434868, 526419, 434865, 577867, 434815, 434811, 434805, 434800, 553995, 553992, 434711, 553988, 553986, 434687, 530857, 434301, 577069, 530751, 576413, 245305, 553937, 245240, 433919, 544745, 234420, 234417, 574615, 574613, 234405, 234402, 234398, 234395, 574608, 574598, 574593, 574591, 234393, 234389, 553908, 234369, 234365, 234356, 433888, 234326, 234320, 234307, 574857, 574588, 574584, 245170, 245146, 574577, 574575, 574570, 574568, 574565, 574555, 433865, 433853, 433851, 433841, 433838, 433836, 433830, 433827, 433821, 433817, 433812, 433810, 433799, 433797, 433795, 433790, 245108, 234288, 234286, 574545, 234284, 433781, 245089, 433773, 234279, 234276, 234274, 553895, 433762, 234262, 570834, 553892, 574542, 526392, 526389, 574539, 574536, 574534, 574531, 574529, 234247, 574527, 234244, 574524, 553888, 553886, 234239, 553883, 234222, 234219, 234214, 234208, 433713, 433711, 245070, 433708, 245067, 245065, 433705, 234162, 553879, 433680, 234150, 234147, 553877, 245047, 433658, 433654, 553873, 234071, 433614, 433611, 433608, 433605, 553864, 433602, 234062, 234059, 433594, 433586, 234057, 234049, 553844, 553842, 553839, 553836, 433579, 553834, 553829, 234041, 553769, 553760, 233952, 233950, 233943, 530168, 572578, 433376, 553752, 553750, 433372, 553748, 433370, 233937, 572484, 433353, 572481, 572478, 572470, 572464, 433332, 433326, 433321, 433318, 433313, 433307, 433304, 433294, 433284, 244771, 244769, 433270, 433249, 244762, 397408, 397406, 397403, 553746, 233920, 233901, 233897, 433215, 553743, 233895, 433212, 433203, 572147, 433191, 433189, 572144, 233892, 433180, 572161, 572159, 233889, 572141, 572138, 572183, 433173, 233885, 433165, 433157, 433155, 433153, 433151, 244728, 556863, 571846, 244726, 433146, 433096, 433094, 433090, 433086, 530090, 553741, 433077, 433075, 433073, 433053, 433027, 233850, 233847, 233839, 233837, 432953, 432950, 432939, 432936, 432934, 526321, 432919, 526296, 526290, 432903, 233809, 414401, 309701, 309696, 309690, 571226, 571224, 571220, 571213, 432882, 164638, 244667, 233787, 553697, 553690, 432863, 432860, 553686, 432858, 553675, 309648, 432845, 432841, 432824, 432821, 432817, 233771, 432760, 233757, 233751, 570489, 432741, 432725, 432718, 553575, 432716, 432714, 432712, 432710, 432707, 570466, 570477, 233745, 233699, 570118, 553556, 523572, 523570, 432611, 553554, 233664, 355928, 432556, 432553, 432548, 164605, 108818, 535957, 432544, 553502, 553496, 432515, 553494, 553490, 553488, 553486, 553484, 244568, 220565, 220558, 432466, 220549, 432461, 432459, 432457, 432454, 567887, 567884, 569262, 432447, 569233, 496695, 496693, 496684, 496681, 569006, 432417, 244552, 244550, 432413, 432407, 432405, 526247, 526245, 526242, 526237, 526235, 432389, 526232, 553464, 526227, 526225, 526222, 526220, 568421, 567295, 567292, 567290, 432324, 233568, 526211, 526209, 526203, 220487, 526200, 547139, 547135, 432318, 536496, 252882, 432303, 526196, 526191, 526188, 432296, 432294, 554915, 554912, 567334, 554902, 432282, 220463, 526186, 526183, 526180, 432278, 432264, 220461, 526177, 526175, 526173, 526169, 233565, 233563, 233561, 432254, 432251, 432247, 526166, 526163, 526159, 220429, 526157, 526152, 526150, 567285, 567283, 567275, 567272, 567270, 432243, 526148, 567305, 419467, 432241, 432239, 567303, 567299, 244526, 244524, 233552, 233548, 233546, 469051, 233543, 567173, 233540, 432235, 432231, 432226, 553463, 432219, 432217, 432213, 526147, 526144, 553459, 526142, 526138, 432212, 432200, 553451, 526123, 200252, 432139, 526119, 526117, 526113, 526101, 526097, 526094, 526092, 526090, 565517, 526086, 553448, 432083, 432071, 432068, 432066, 432063, 432061, 432031, 526071, 432029, 553445, 526065, 564695, 526063, 526055, 526051, 553434, 553432, 432009, 553430, 432006, 432004, 526043, 564718, 564716, 526039, 432000, 431996, 431992, 526034, 483424, 431981, 562867, 563587, 562864, 562862, 431974, 563584, 563582, 431968, 562860, 233506, 233504, 564534, 405843, 233502, 553426, 233495, 233493, 233490, 233475, 233473, 233471, 233466, 233464, 233460, 233456, 233454, 233451, 233449, 552731, 233439, 233437, 233432, 431958, 431956, 431953, 556632, 233425, 233420, 431946, 562786, 563977, 405837, 309543, 309541, 405831, 405827, 405825, 559446, 453631, 431939, 405818, 431916, 431914, 392844, 431900, 431897, 553422, 392543, 431879, 309537, 431876, 244466, 244463, 220246, 535910, 244458, 553420, 431843, 431750, 431748, 431745, 431743, 431723, 553411, 553406, 553404, 553402, 553400, 332599, 431720, 431718, 431715, 431713, 431710, 431708, 553397, 562770, 562767, 553381, 553379, 233388, 553373, 285552, 553369, 553361, 553359, 431704, 553353, 529408, 469047, 431698, 529403, 309477, 244433, 431696, 562446, 562229, 244429, 244426, 220222, 244410, 220212, 244406, 244404, 220204, 220199, 220197, 233365, 553351, 233363, 553349, 233361, 431692, 553347, 431688, 561949, 561948, 561946, 561940, 561938, 561916, 526003, 233349, 233340, 491087, 491085, 491082, 233330, 233316, 553345, 233312, 233295, 431682, 529356, 525979, 553344, 560940, 560936, 314665, 553342, 553340, 431664, 431662, 431658, 431656, 174320, 174318, 557711, 553337, 233271, 431651, 431649, 233265, 220117, 557708, 431640, 557700, 529320, 431637, 557698, 529317, 557695, 557693, 557690, 554523, 557686, 557680, 553333, 557673, 431623, 431602, 431598, 560367, 553330, 553327, 557652, 553325, 553323, 233230, 233227, 108797, 233225, 233222, 244362, 244358, 233208, 550126, 431530, 431528, 306513, 306511, 306509, 431520, 431509, 233203, 233201, 431503, 233199, 431500, 306504, 431496, 306499, 306497, 306495, 306491, 233196, 306488, 306481, 306479, 244349, 233188, 306476, 306474, 306472, 306470, 553316, 525915, 525910, 553312, 306466, 553310, 306464, 306458, 306454, 306450, 306448, 233180, 306445, 306442, 306439, 306437, 233172, 553307, 431466, 233168, 233165, 233161, 233155, 431464, 244334, 431462, 553002, 553000, 552729, 244330, 431459, 431456, 431454, 431450, 431448, 431445, 431443, 244328, 558258, 553301, 529265, 431427, 431423, 431421, 558251, 431413, 244315, 244312, 244310, 244308, 431409, 431406, 431404, 558008, 558379, 244299, 558372, 558539, 431387, 558431, 244266, 244263, 244261, 558368, 244258, 529252, 108793, 431372, 557626, 557616, 557613, 557607, 557601, 557599, 557596, 557594, 556219, 529236, 108780, 431343, 557590, 431339, 431336, 431333, 431330, 431327, 431325, 557586, 431322, 431309, 431306, 431300, 431293, 557573, 557571, 557528, 557526, 557512, 557508, 431286, 557504, 557499, 431284, 557497, 252868, 553289, 553284, 557495, 557484, 200216, 553282, 553280, 553278, 553273, 233075, 233073, 431260, 553271, 431253, 553268, 233066, 553266, 553264, 557071, 553259, 557068, 220011, 553257, 553255, 553251, 553247, 553244, 553241, 553239, 535861, 553237, 553235, 557065, 553233, 553231, 553227, 553225, 553223, 525871, 330408, 431231, 200213, 330406, 553221, 233051, 233036, 431198, 431195, 431192, 431190, 431186, 431183, 553215, 200209, 553213, 431180, 431167, 431164, 431162, 553209, 553207, 553204, 431144, 553201, 556060, 553196, 553194, 555939, 553187, 553183, 244248, 553179, 553177, 553173, 553168, 553166, 553164, 431100, 431098, 244239, 244230, 431061, 553160, 431059, 431057, 431055, 431048, 431012, 200206, 553157, 553154, 553152, 553149, 452730, 553145, 553137, 430990, 430985, 555043, 555311, 555309, 430976, 547761, 430973, 525823, 430966, 430961, 430917, 525784, 555110, 200202, 554797, 200199, 200197, 554791, 430912, 552726, 430909, 552724, 552723, 552719, 552713, 552711, 430887, 430878, 232949, 430867, 554467, 430859, 554462, 552707, 430845, 430842, 552705, 552703, 552697, 552694, 552690, 552679, 552676, 552674, 552667, 552662, 232908, 232906, 430781, 232893, 232891, 232889, 539324, 430706, 430704, 430696, 430648, 430645, 430643, 232865, 232863, 232861, 430625, 232855, 200183, 244179, 430612, 430609, 244177, 244171, 244167, 430600, 430597, 430587, 548603, 430519, 550106, 430475, 550104, 430472, 232796, 232794, 548251, 549266, 549262, 549252, 430360, 430330, 548087, 548033, 511456, 232757, 547708, 547702, 545839, 547367, 430156, 108713, 430098, 525661, 430078, 528946, 547105, 200132, 449615, 525646, 430029, 430027, 430025, 546070, 545935, 232727, 232723, 232713, 200111, 429856, 429841, 525433, 544591, 544587, 429819, 232683, 200086, 525419, 249734, 544383, 525400, 525398, 429778, 525396, 542273, 232637, 429759, 429756, 536569, 429717, 429708, 429667, 429660, 429648, 232624, 543657, 429639, 429635, 429633, 429628, 429610, 429608, 429595, 429585, 429539, 429522, 429518, 429512, 429474, 542553, 502170, 232614, 497821, 542117, 542113, 108677, 108675, 108672, 345788, 345783, 108657, 488540, 108650, 108648, 108646, 108644, 525134, 541532, 429332, 429329, 429326, 525118, 525113, 540643, 243987, 243982, 243980, 524735, 524725, 396485, 516701, 537593, 537562, 537551, 524689, 428978, 243891, 524668, 537419, 482917, 482915, 524658, 524656, 524654, 524647, 524641, 524638, 524631, 524627, 524624, 524622, 536761, 199967, 536940, 232468, 524618, 524615, 524612, 219374, 232458, 524602, 524597, 524593, 524585, 457738, 457735, 428947, 524573, 524572, 524570, 428942, 428940, 524568, 524564, 524561, 249723, 428928, 249721, 249719, 428916, 428912, 428910, 428908, 536894, 428906, 494954, 428902, 428896, 428894, 428886, 457732, 428884, 428880, 524559, 243876, 524555, 243871, 243869, 428861, 243867, 243865, 243863, 428853, 243860, 428846, 243858, 243856, 524550, 428843, 535345, 524547, 524545, 524543, 536526, 536543, 524528, 367440, 535630, 535624, 535620, 535617, 535615, 428827, 524519, 428823, 524508, 428815, 535250, 519398, 524488, 428805, 243843, 535291, 485579, 519395, 535288, 485577, 535286, 524479, 524476, 428792, 428790, 524473, 428788, 524471, 524459, 524448, 524445, 524440, 524431, 524429, 524426, 524412, 524404, 524401, 524399, 524397, 524394, 524379, 351640, 341760, 351637, 524374, 524367, 524361, 351634, 524359, 199946, 199944, 199942, 516686, 524347, 528585, 528394, 524331, 524326, 528392, 524324, 232366, 528263, 528257, 528249, 528247, 428770, 528245, 528242, 528240, 524313, 524310, 524307, 524304, 524293, 524263, 524261, 524259, 232351, 524252, 524250, 524242, 524238, 524236, 524234, 524229, 524209, 428738, 524203, 524200, 527316, 527314, 527021, 527018, 473558, 232321, 232314, 232312, 524185, 524178, 524166, 362436, 524164, 526589, 524162, 389386, 524160, 524154, 524151, 524147, 524139, 428641, 428638, 524135, 524133, 428633, 524131, 524129, 199914, 524126, 362434, 524002, 428629, 524122, 524120, 524118, 524115, 524113, 524106, 524103, 524099, 526529, 524096, 524093, 523995, 524087, 524078, 524073, 428610, 428607, 523991, 428599, 14947, 524057, 524050, 496560, 526524, 524048, 428593, 428582, 523845, 524032, 524025, 243794, 523985, 428575, 524022, 428571, 524020, 523983, 523981, 428568, 523979, 523975, 428563, 523970, 523968, 523175, 523964, 428561, 523961, 428548, 199908, 199906, 523774, 199904, 428542, 428538, 523231, 428534, 523551, 523772, 523546, 523543, 523796, 523541, 523228, 523539, 522928, 523536, 523534, 523531, 243782, 523631, 328735, 232300, 523522, 428528, 232297, 243776, 232294, 428526, 232291, 243774, 243772, 344571, 243760, 428523, 428519, 428483, 522100, 397289, 428455, 498108, 498104, 522705, 428443, 428441, 522703, 522700, 428413, 243702, 243700, 243695, 516594, 243688, 243682, 243679, 344566, 522167, 428406, 428400, 328726, 428398, 428368, 428364, 428356, 428347, 428343, 521938, 521339, 428277, 428272, 521067, 521061, 353137, 521059, 520999, 520995, 428209, 428204, 519198, 520521, 428188, 419790, 428174, 419787, 419785, 501689, 355894, 428161, 355888, 428158, 428153, 428150, 428148, 428145, 501639, 501634, 508045, 508043, 485500, 508041, 232256, 219060, 519923, 519919, 519905, 519902, 519889, 519878, 519875, 428103, 428100, 519872, 428097, 219051, 428077, 482702, 482697, 519628, 519626, 519624, 519621, 519619, 519615, 519613, 519611, 519551, 519549, 519609, 519547, 519607, 515627, 428052, 519540, 519605, 519603, 428045, 519600, 519598, 519596, 428042, 232253, 232247, 199830, 427943, 427940, 232233, 232227, 232224, 232214, 518246, 427882, 518208, 518205, 518203, 517941, 232203, 232201, 218917, 232193, 427850, 108522, 427843, 427839, 427837, 232191, 427835, 427833, 108516, 427830, 427827, 427825, 427823, 108512, 199801, 199799, 232189, 108505, 232187, 108502, 517012, 108500, 108498, 232176, 108495, 108493, 509736, 108490, 232173, 108488, 232171, 517007, 427816, 427752, 218867, 427750, 427744, 427742, 427740, 427734, 427729, 427727, 232120, 515256, 515252, 515250, 232117, 515245, 514475, 232110, 515238, 514473, 514469, 232106, 232103, 232098, 232096, 514464, 514462, 232090, 232080, 232078, 232075, 232070, 513481, 512826, 512823, 512327, 232068, 512821, 218697, 427658, 512860, 427637, 427621, 427619, 427610, 427607, 427576, 427563, 243498, 427529, 485394, 485385, 427451, 427446, 243461, 218603, 455427, 243434, 199693, 510440, 231983, 231977, 427288, 427285, 427207, 243410, 243404, 509239, 509146, 509144, 231916, 508860, 508858, 507907, 243270, 243204, 231803, 231801, 243200, 243196, 243193, 504772, 231787, 504760, 401018, 401014, 401011, 401009, 401004, 231745, 405755, 243166, 231712, 231709, 231703, 231701, 243163, 231697, 243152, 231686, 231679, 231676, 231671, 231659, 231653, 231650, 231641, 426647, 231631, 231609, 402711, 402709, 402706, 426187, 330247, 495628, 231165, 231160, 231158, 231152, 425845, 495397, 455320, 455318, 455315, 231133, 231127, 397597, 376203, 425794, 425773, 242878, 425743, 425739, 494281, 493982, 493261, 492958, 492956, 493062, 492954, 492952, 492948, 492944, 242798, 492507, 492502, 485202, 230946, 230940, 230930, 376159, 230904, 425577, 491459, 491457, 230893, 230891, 425572, 425566, 425561, 425559, 425556, 230881, 425552, 425550, 491003, 425548, 491146, 425538, 425533, 425531, 491173, 491171, 491168, 199247, 491164, 489831, 489826, 249716, 488810, 488524, 199144, 483697, 486432, 367224, 485092, 399256, 482348, 484902, 485099, 230683, 425161, 230679, 482346, 425157, 132704, 367218, 484993, 484984, 230659, 425152, 230648, 199127, 482344, 425149, 404187, 404185, 471686, 468913, 425133, 484198, 483693, 199118, 483691, 205763, 484196, 484194, 372764, 484192, 372760, 484378, 484376, 230634, 230632, 484189, 484187, 425125, 483686, 483684, 199111, 483682, 483680, 483675, 199105, 483672, 199101, 242506, 484077, 484075, 242501, 242498, 199099, 484010, 425114, 199097, 230594, 483944, 242495, 242492, 483139, 483136, 483929, 483926, 483924, 483922, 483917, 483914, 482986, 483133, 483131, 483909, 230590, 199094, 483128, 483626, 483624, 483357, 483620, 483635, 483355, 483633, 132680, 483126, 483617, 483615, 425110, 425104, 425101, 483349, 483347, 217557, 483345, 18897, 483342, 454092, 618458, 618454, 618452, 242467, 18893, 199083, 425099, 483124, 483121, 217552, 483119, 483117, 483115, 483111, 483109, 242463, 483106, 483033, 483030, 483028, 480809, 483022, 483020, 199078, 199076, 199073, 425095, 482966, 482963, 482961, 482959, 199066, 618446, 161851, 618440, 161847, 161845, 330202, 618436, 482707, 230587, 468908, 230585, 618432, 482655, 425086, 425082, 217529, 217521, 482577, 482257, 482538, 242442, 482255, 402700, 482013, 230550, 230476, 217434, 479274, 199016, 230463, 230459, 230457, 217430, 230454, 479798, 230448, 230436, 230434, 230432, 479708, 476748, 230430, 476743, 242308, 242306, 242304, 242302, 479740, 476741, 479738, 230423, 230415, 479418, 479261, 479259, 479257, 11930, 11923, 11919, 11915, 473943, 11907, 11905, 11899, 11896, 478944, 230399, 424798, 230324, 230317, 230315, 230313, 198963, 198954, 198939, 198937, 476478, 476474, 424764, 424757, 424754, 198933, 198931, 424751, 198929, 198927, 198925, 424747, 476448, 476446, 476393, 476388, 110290, 110288, 198923, 424729, 424724, 473480, 424720, 198917, 424705, 424703, 476182, 424701, 476172, 476170, 198912, 476167, 476164, 424694, 424692, 198908, 424690, 424687, 424683, 476162, 476160, 475446, 198905, 424669, 242200, 242198, 198903, 198894, 424640, 473801, 265526, 473457, 198845, 265521, 265518, 265515, 268933, 472822, 198843, 618131, 424605, 473081, 198839, 471013, 471482, 471367, 397205, 198765, 470605, 198750, 198742, 470360, 470038, 453285, 470036, 230091, 470033, 470031, 470029, 470026, 470022, 470020, 470017, 470014, 217037, 469533, 469530, 469486, 469485, 468375, 468373, 468371, 468369, 468363, 468361, 198662, 424412, 216957, 198656, 449959, 449957, 449955, 449953, 216948, 449951, 449949, 449946, 449943, 449941, 618029, 618025, 618022, 230025, 230021, 468115, 468113, 618017, 468111, 468108, 424396, 198653, 241896, 468060, 467996, 241872, 241869, 241867, 467986, 467977, 467973, 241860, 467969, 424387, 467966, 467958, 467955, 467953, 467947, 229965, 464174, 464172, 467697, 467439, 467431, 467424, 424328, 467042, 466649, 464134, 466082, 466077, 464127, 353081, 241748, 241746, 424222, 465135, 465133, 465899, 198583, 198582, 465131, 465781, 465779, 461270, 465129, 465126, 465123, 465121, 424201, 465119, 465117, 465115, 424198, 424196, 461257, 465111, 421738, 198558, 464658, 465066, 229925, 465062, 465059, 229918, 465057, 465055, 465053, 229915, 465051, 465361, 464112, 460609, 460607, 460605, 464109, 465276, 464107, 464105, 464101, 460602, 465273, 465105, 424162, 424160, 424158, 424156, 229894, 464088, 464086, 464073, 464071, 464057, 198524, 464053, 464051, 464049, 464045, 464043, 464038, 464034, 464519, 464026, 464024, 464018, 464016, 464013, 198519, 639826, 424140, 424135, 424133, 424130, 464006, 464002, 463999, 198504, 424125, 367125, 229891, 261304, 229888, 229885, 229882, 463811, 463806, 463801, 463799, 463796, 463829, 229876, 463826, 463824, 463783, 198485, 463821, 424113, 424109, 424108, 424104, 424099, 198482, 424097, 424095, 424093, 424091, 241667, 424089, 461689, 229863, 229859, 229857, 229855, 241659, 402698, 402692, 402686, 402679, 402676, 402670, 198472, 424085, 198470, 424083, 463153, 462929, 462927, 462918, 462914, 462912, 454328, 368373, 198454, 617978, 368369, 241648, 368367, 461936, 265508, 198449, 367119, 462194, 462048, 424044, 424042, 229838, 462173, 462043, 229835, 229829, 462016, 229826, 229823, 461672, 461670, 198436, 461662, 229813, 344528, 344526, 344523, 311461, 229799, 198431, 424005, 198419, 198414, 424002, 423997, 423995, 198412, 198410, 461016, 460766, 460821, 460834, 198401, 460764, 460763, 198400, 265503, 265502, 423982, 423980, 423975, 423973, 132396, 423952, 423945, 460379, 423942, 198394, 198391, 198389, 198388, 198386, 198382, 423937, 198374, 198373, 198370, 376132, 460208, 460353, 454319, 198367, 198361, 459189, 459187, 459184, 459182, 459180, 454316, 458827, 458868, 458688, 456861, 457947, 457944, 457917, 458287, 458438, 458237, 458235, 261286, 457907, 457903, 449655, 457809, 457649, 449645, 457714, 457597, 457590, 457585, 457578, 457568, 454307, 454299, 454297, 453083, 448914, 448912, 448909, 449807, 451993, 417713, 451453, 420869, 416809, 409940, 449637, 449634, 449447, 290997, 449444, 290995, 449227, 449259, 420863, 420860, 420858, 448715, 448488, 448428, 448424, 447970, 447852, 279392, 423017, 422776, 422529, 422526, 422115, 422112, 422212, 422192, 422190, 419179, 419178, 418556, 410853, 617319, 397165, 365041, 400647, 417064, 410848, 416211, 416623, 415559, 409927, 409923, 413499, 386798, 414424, 413494, 413475, 413473, 413471, 413466, 413111, 413109, 413107, 413105, 413103, 409922, 409920, 410840, 409919, 409917, 409915, 409027, 409913, 409013, 409011, 409010, 409008, 409006, 409004, 409002, 408264, 408263, 408262, 408261, 408259, 408254, 408253, 408252, 408250, 408248, 405937, 404183, 404180, 404178, 404176, 215549))
Run Time: 0.045864
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2479 | |
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 | | | | | 2479 | |
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 (28479, 27050, 25398, 24194, 23896, 23209, 22676, 21111, 20958, 20826, 20550))
Run Time: 0.001024
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 11 | 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, �*T
Run Time: 0.000238
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: �*T, XF\Pub\Controller\Member, RecentContent, valid, user_id=5039, 1716198668, , 0, �*T
Run Time: 0.000132
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000330
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.000527
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: 1716198368
Run Time: 0.000277
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 42 | 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` >= 1716198368)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000427
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 42 | 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