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.000558
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.000147
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` = '20516')
LIMIT 1
Run Time: 0.000546
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.002176
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_20516' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.153503
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | search_index | fulltext | title_metadata | title_metadata | 0 | | 1 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 162
- XF\Db\AbstractAdapter->fetchAllNum() in src/XF/Search/Source/MySqlFt.php at line 286
- XF\Search\Source\MySqlFt->search() in src/XF/Search/Search.php at line 185
- XF\Search\Search->XF\Search\{closure}() in src/XF/Search/Search.php at line 214
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 180
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (35588, 35583, 35575, 35550, 35513, 35506, 35502, 35489, 35484, 35476, 35464, 35437, 35436, 35434, 35427, 35384, 35355, 35317, 35289, 35288, 35247, 35239, 35235, 35220, 35199, 35163, 35110, 35105, 35097, 35088, 35079, 35071, 35055, 35044, 35005, 34997, 34967, 34940, 34935, 34931, 34904, 34891, 34854, 34845, 34836, 34803, 34790, 34763, 34752, 34745, 34724, 34713, 34709, 34695, 34692, 34673, 34619, 34609, 34607, 34573, 34572, 34560, 34636, 34532, 34514, 34504, 34501, 34499, 34480, 34469, 34448, 34434, 34427, 34393, 34369, 34341, 34329, 34326, 34298, 34297, 34287, 34279, 34214, 34199, 34153, 34137))
Run Time: 0.009880
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 86 | 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 (646461, 646449, 646444, 646442, 646423, 646418, 646395, 646391, 646389, 646383, 646381, 646377, 646355, 646337, 646335, 646322, 646321, 646314, 646310, 646304, 646301, 646296, 646294, 646283, 646277, 646269, 646263, 646261, 646260, 646250, 646248, 646244, 646242, 646241, 646234, 646229, 646223, 646220, 646215, 646208, 646194, 646184, 646180, 646174, 646162, 646159, 646154, 646152, 646146, 646143, 646137, 646134, 646125, 646123, 646114, 646087, 646070, 646063, 646057, 646056, 646030, 646006, 646004, 645998, 645994, 645993, 645992, 645990, 645985, 645983, 645974, 645967, 645964, 645961, 645958, 645955, 645944, 645940, 645922, 645921, 645911, 645899, 645897, 645878, 645871, 645829, 645821, 645817, 645803, 645801, 645795, 645776, 645773, 645771, 645764, 645758, 645756, 645754, 645749, 645745, 645738, 645732, 645728, 645724, 645709, 645703, 645697, 645695, 645686, 645684, 645676, 645671, 645669, 645660, 645653, 645652, 645651, 645650, 645625, 645620, 645616, 645607, 645603, 645594, 645582, 645576, 645561, 645557, 645531, 645530, 645525, 645516, 645512, 645503, 645492, 645479, 645467, 645463, 645454, 645453, 645438, 645430, 645427, 645424, 645416, 645403, 645400, 645392, 645386, 645375, 645373, 645371, 645368, 645366, 645358, 645354, 645335, 645332, 645318, 645311, 645305, 645296, 645293, 645284, 645282, 645278, 645272, 645271, 645269, 645268, 645265, 645262, 645258, 645257, 645253, 645251, 645216, 645203, 645202, 645198, 645196, 645182, 645176, 645173, 645172, 645167, 645160, 645159, 645150, 645147, 645142, 645141, 645140, 645137, 645134, 645132, 645129, 645123, 645122, 645118, 645103, 645100, 645087, 645074, 645072, 645066, 645062, 645059, 645053, 645050, 645048, 645032, 645030, 645028, 645027, 645023, 645021, 645018, 645013, 645009, 645007, 644999, 644994, 644980, 644977, 644974, 644963, 644958, 644956, 644954, 644939, 644936, 644933, 644926, 644911, 644903, 644899, 644897, 644886, 644877, 644865, 644863, 644850, 644843, 644840, 644836, 644828, 644824, 644821, 644815, 644811, 644796, 644788, 644787, 644769, 644767, 644765, 644764, 644762, 644737, 644728, 644719, 644700, 644693, 644692, 644689, 644674, 644668, 644661, 644658, 644653, 644650, 644643, 644638, 644637, 644627, 644612, 644604, 644601, 644597, 644595, 644594, 644589, 644582, 644576, 644574, 644570, 644569, 644562, 644560, 644559, 644556, 644546, 644536, 644533, 644526, 644502, 644500, 644477, 644470, 644463, 644457, 644450, 644442, 644430, 644426, 644412, 644410, 644409, 644408, 644406, 644387, 644384, 644364, 644359, 644357, 644353, 644352, 644308, 644281, 644222, 644220, 644189, 644176, 644172, 644167, 644158, 644157, 644155, 644148, 644140, 644129, 644128, 644122, 644114, 644112, 644110, 644107, 644101, 644084, 644080, 644079, 644070, 644068, 644066, 644064, 644054, 644052, 644049, 644044, 644034, 644032, 644031, 644020, 644009, 644007, 644004, 644002, 643998, 643997, 643995, 643988, 643979, 643978, 643969, 643968, 643960, 643955, 643933, 643922, 643915, 643908, 643886, 643875, 643866, 643856, 643852, 643850, 643846, 643842, 643838, 643835, 643823, 643820, 643807, 643806, 643804, 643788, 643787, 643779, 643775, 643772, 643764, 643762, 643757, 643752, 643744, 643743, 643730, 643726, 643721, 643718, 643716, 643713, 643706, 643703, 643679, 643678, 643677, 643674, 643659, 643657, 643654, 643650, 643649, 643645, 643641, 643639, 643635, 643625, 643611, 643601, 643599, 643597, 643596, 643587, 643582, 643581, 643569, 643564, 643554, 643551, 643535, 643526, 643517, 643516, 643512, 643511, 643503, 643494, 643485, 643484, 643479, 643467, 643464, 643463, 643450, 643446, 643438, 643432, 643428, 643423, 643420, 643418, 643414, 643411, 643409, 643394, 643390, 643387, 643385, 643383, 643377, 643369, 643358, 643333, 643324, 643321, 643317, 643312, 643307, 643301, 643300, 643295, 643290, 643289, 643276, 643273, 643265, 643262, 643260, 643258, 643256, 643248, 643237, 643236, 643225, 643206, 643202, 643198, 643188, 643182, 643177, 643173, 643171, 643165, 643159, 643158, 643151, 643150, 643146, 643128, 643115, 643109, 643104, 643101, 643075, 643067, 643062, 643043, 643039, 643036, 643035, 643028, 643021, 643020, 643018, 643008, 643004, 642989, 642982, 642968, 642964, 642961, 642958, 642953, 642942, 642935, 642933, 642923, 642921, 642917, 642898, 642896, 642894, 642886, 642880, 642857, 642816, 642806, 642802, 642797, 642785, 642782, 642775, 642774, 642766, 642762, 642759, 642735, 642726, 642725, 642717, 642708, 642707, 642694, 642692, 642691, 642676, 642674, 642671, 642651, 642649, 642646, 642639, 642633, 642627, 642625, 642596, 642593, 642545, 642540, 642531, 642525, 642512, 642502, 642497, 642440, 642436, 642431, 642422, 642403, 642401, 642399, 642396, 642394, 642389, 642381, 642378, 642372, 642368, 642364, 642356, 642351, 642349, 642345, 642344, 642342, 642336, 642334, 642331, 642325, 642320, 642316, 642309, 642291, 642289, 642284, 642281, 642279, 642274, 642268, 642267, 642262, 642258, 642249, 642222, 642220, 642212, 642208, 642205, 642199, 642197, 642193, 642187, 642183, 642180, 642159, 642149, 642147, 642143, 642140, 642136, 642131, 642119, 642111, 642109, 642106, 642102, 642097, 642090, 642088, 642086, 642082, 642065, 642052, 642046, 642033, 642030, 642028, 642010, 641965, 641956, 641929, 641924, 641922, 641918, 641912, 641876, 641875, 641868, 641851, 641830, 641827, 641824, 641817, 641809, 641801, 641799, 641798, 641783, 641782, 641781, 641770, 641761, 641756, 641753, 641750, 641744, 641743, 641741, 641740, 641725, 641714, 641712, 641700, 641688, 641683, 641678, 641675, 641674, 641669, 641662, 641651, 641640, 641624, 641614, 641602, 641598, 641593, 641590, 641580, 641578, 641567, 641563, 641561, 641559, 641556, 641555, 641549, 641548, 641546, 641544, 641531, 641525, 641524, 641519, 641503, 641483, 641463, 641458, 641431, 641417, 641415, 641412, 641408, 641389, 641376, 641370, 641369, 641364, 641361, 641357, 641356, 641341, 641331, 641321, 641314, 641307, 641303, 641300, 641281, 641280, 641270, 641267, 641265, 641264, 641261, 641247, 641246, 641244, 641240, 641236, 641234, 641181, 641168, 641164, 641160, 641158, 641152, 641151, 641126, 641119, 641084, 641078, 641065, 641034, 641028, 641026, 641025, 641019, 641017, 641014, 641008, 641006, 640994, 640990, 640988, 640986, 640984, 640982, 640981, 640975, 640966, 640961, 640950, 640945, 640944, 640936, 640935, 640930, 640929, 640926, 640924, 640922, 640901, 640892, 640885, 640881, 640879, 640877, 640873, 640866, 640863, 640861, 640859, 640858, 640855, 640850, 640849, 640848, 640837, 640827, 640822, 640820, 640817, 639743, 639741, 247291, 640806, 607498, 580772, 580770, 640797, 640772, 640800, 640787, 612713, 447745, 640592, 640766, 640743, 640769, 640759, 640747, 640692, 640730, 447739, 640727, 640725, 447734, 640723, 447728, 447726, 639304, 447722, 447719, 640684, 640681, 640678, 640705, 640669, 447716, 604374, 640259, 640605, 447712, 640665, 640658, 640656, 640654, 640649, 640645, 633976, 633973, 580768, 633971, 633969, 633965, 640450, 633957, 640635, 640631, 640629, 640626, 640603, 633952, 593135, 633950, 640581, 640574, 640598, 640393, 447696, 447694, 604371, 580753, 580751, 607031, 607029, 639012, 640563, 640567, 580747, 447692, 580744, 580742, 596417, 447686, 447681, 447679, 604368, 447677, 640498, 539612, 447674, 201205, 417935, 447673, 417933, 417931, 447671, 417929, 639737, 447667, 639735, 417925, 639732, 447664, 639730, 447661, 583995, 109279, 109277, 109273, 109267, 109265, 109261, 639727, 640300, 639725, 640552, 447657, 447655, 447653, 630008, 447643, 447641, 447639, 447637, 635400, 635398, 635396, 447634, 447632, 447630, 635394, 447628, 447626, 447624, 447622, 447616, 639716, 447613, 640536, 640523, 604367, 247289, 639713, 630294, 639993, 635390, 639990, 639988, 639985, 640129, 635388, 640126, 640466, 640514, 640462, 639710, 639626, 639624, 639622, 638792, 640296, 640482, 640480, 640476, 447594, 640460, 638790, 447586, 447581, 447579, 623568, 640291, 623564, 640448, 640289, 636284, 640423, 640443, 640421, 640418, 640438, 639702, 640401, 607494, 604204, 639928, 640391, 539607, 447565, 601276, 606403, 630293, 637205, 539600, 539598, 640177, 640174, 638891, 601268, 447558, 447556, 640317, 640253, 640251, 640249, 447549, 447546, 544905, 640346, 640340, 640322, 640334, 640283, 640203, 640243, 638788, 640192, 189148, 640190, 637076, 639696, 637057, 637052, 640172, 596413, 640119, 633341, 633338, 633336, 640115, 640113, 640111, 640108, 640105, 640101, 640099, 447533, 447530, 640084, 309846, 309844, 640080, 632219, 640138, 640151, 640062, 630004, 630291, 638785, 638782, 640057, 640055, 639534, 637600, 639512, 604365, 580736, 637596, 637593, 447501, 247286, 634180, 634175, 447490, 639965, 640033, 539585, 447457, 539578, 640003, 640024, 640022, 539576, 639954, 539574, 639295, 640017, 639291, 639468, 447434, 447415, 639922, 639958, 447404, 639948, 639952, 639944, 639880, 447385, 639889, 639678, 639675, 447383, 639884, 628237, 639768, 639874, 639765, 639782, 638143, 639452, 639658, 580733, 447376, 639449, 639447, 639445, 639443, 639667, 247283, 447370, 639664, 639747, 639653, 639651, 639649, 639647, 447361, 580730, 639660, 247279, 580728, 639587, 639636, 639584, 639576, 639441, 639572, 639438, 639568, 627543, 639566, 639595, 639562, 447354, 639582, 491358, 491356, 447352, 639579, 639430, 447335, 639547, 447328, 447325, 630289, 639417, 639525, 447311, 630002, 447308, 447303, 447301, 630000, 372063, 639407, 636683, 639403, 420426, 636072, 639279, 639383, 639381, 534891, 639374, 447287, 639371, 639369, 447279, 447277, 639334, 639254, 639330, 639252, 639250, 639322, 639314, 639246, 639312, 639309, 639243, 601704, 630286, 447274, 639084, 639081, 447269, 639079, 447268, 639076, 447264, 639067, 601702, 639260, 600047, 639063, 639060, 639058, 635674, 447252, 639237, 447246, 639234, 639231, 639228, 605124, 639052, 447239, 447237, 463750, 447228, 447222, 630285, 447216, 634141, 638969, 639043, 639206, 639039, 629997, 630284, 638967, 548409, 447204, 623645, 447194, 447192, 631217, 639137, 639153, 639171, 639169, 639141, 639139, 639128, 626148, 447156, 634940, 580722, 447152, 635142, 639005, 610337, 635132, 635128, 638965, 635121, 638912, 635119, 599047, 630283, 603527, 201200, 638995, 638910, 447129, 447125, 447124, 447121, 638889, 638989, 638987, 638982, 638884, 638973, 578054, 638703, 574781, 578052, 578050, 578047, 578045, 578043, 578038, 638942, 447109, 638924, 638881, 638904, 447099, 638929, 638898, 638921, 638926, 638876, 638697, 638868, 638866, 638695, 638737, 637980, 637978, 638726, 256737, 630281, 637977, 638825, 630279, 638814, 638804, 638812, 638776, 638759, 638731, 638559, 631925, 638748, 631923, 638745, 638557, 638555, 638677, 638675, 447091, 638662, 638669, 638660, 638658, 638656, 638021, 638632, 638630, 638622, 638620, 638617, 629993, 601243, 638613, 638611, 638604, 638608, 493688, 493686, 638601, 629992, 638571, 638575, 638568, 606808, 638426, 638423, 638493, 638546, 638542, 638539, 610336, 638485, 580715, 638537, 638483, 630276, 580713, 610335, 580709, 610333, 580703, 634171, 580693, 453825, 638477, 638473, 638471, 638469, 638467, 638506, 638522, 630274, 638520, 638465, 637681, 638504, 638321, 638463, 638502, 638461, 447078, 447076, 447058, 623556, 447052, 638459, 638452, 638450, 638457, 596408, 637679, 638319, 636682, 638374, 638318, 638372, 572557, 572554, 638401, 447044, 638394, 572548, 447041, 638274, 56471, 447032, 56469, 56466, 447022, 638227, 638225, 447018, 638299, 447016, 630273, 601238, 630272, 601237, 638352, 447012, 638328, 638350, 447004, 447002, 447000, 446997, 446995, 446993, 638317, 638313, 638293, 638306, 580689, 580687, 638303, 638290, 580680, 638176, 638192, 638283, 638187, 638280, 638262, 638260, 633726, 638258, 638256, 446984, 612894, 612891, 633939, 633933, 633930, 638239, 633925, 633921, 633919, 633915, 633910, 638219, 633908, 638215, 638211, 638208, 638173, 638132, 638235, 638232, 638164, 638162, 638171, 446980, 638223, 638203, 630271, 446971, 446969, 446967, 446965, 446963, 446961, 446958, 638185, 638196, 638179, 638167, 638160, 637986, 638103, 638158, 638101, 638099, 638097, 605828, 349628, 637912, 247269, 247267, 638061, 638093, 638059, 638156, 637909, 632260, 636893, 638056, 596405, 596403, 629092, 638018, 637504, 638014, 637502, 638041, 638039, 638037, 638035, 637627, 637998, 637498, 637952, 637960, 637984, 637972, 637982, 637933, 632258, 637925, 636561, 633475, 637877, 446933, 637875, 637869, 637920, 629982, 630269, 636681, 446921, 636698, 637492, 637864, 612887, 637860, 612883, 612879, 637898, 637893, 637854, 637891, 636696, 637589, 565478, 637490, 612874, 615744, 637487, 637485, 637587, 637585, 637849, 446904, 637783, 446901, 637845, 637481, 637477, 637475, 637473, 637471, 637779, 565474, 565471, 637756, 565468, 565466, 632097, 637750, 637753, 500385, 612357, 601229, 637734, 637732, 612872, 637742, 632135, 637730, 637728, 612351, 637624, 612869, 612867, 446890, 637717, 446887, 637677, 446885, 637715, 637666, 637663, 637712, 608521, 637708, 630268, 637611, 637609, 637607, 637658, 637649, 580673, 637641, 637638, 637635, 637603, 637537, 446876, 606025, 637567, 637565, 637561, 446855, 446853, 446850, 446847, 446842, 637469, 637466, 446836, 601223, 637464, 637536, 637534, 446832, 446830, 637532, 637462, 446828, 596391, 637529, 637542, 637524, 637454, 446825, 596388, 601221, 629979, 630267, 610332, 610330, 612866, 612864, 610328, 637428, 612862, 612860, 612857, 637424, 612854, 637379, 637377, 446814, 637375, 637387, 446812, 610326, 637385, 637383, 637348, 637372, 637343, 446808, 636991, 637370, 637381, 637338, 637354, 637352, 637329, 637327, 601219, 636153, 636151, 247264, 629978, 446792, 446790, 601218, 637315, 446788, 637323, 637312, 636149, 636147, 637319, 636145, 637273, 634411, 601217, 636143, 446784, 446779, 634167, 630266, 637303, 637301, 637270, 637268, 637299, 446771, 637289, 637287, 634378, 637285, 637263, 637278, 637257, 446767, 637112, 637247, 637252, 630265, 637250, 637243, 580661, 580659, 607493, 583816, 637233, 607491, 637155, 601214, 453820, 580653, 637223, 637221, 181012, 637230, 414290, 637210, 637171, 637169, 637195, 637148, 637146, 596378, 596376, 637101, 334016, 596367, 334012, 630263, 637074, 623549, 637123, 637120, 637118, 636719, 596364, 637006, 637004, 630262, 580649, 580646, 637069, 637067, 596360, 637104, 446744, 637049, 446742, 446739, 637043, 637085, 247255, 636913, 637029, 637027, 636735, 637002, 637018, 596356, 596354, 637000, 636996, 636994, 636588, 636586, 636241, 479701, 630261, 446733, 596349, 453819, 446730, 446729, 446727, 596347, 446723, 636983, 601211, 610325, 636977, 636973, 636933, 610323, 636931, 446719, 601209, 636927, 636910, 636924, 633380, 636921, 636902, 636782, 636917, 633376, 636730, 636779, 633373, 636845, 633821, 636852, 636776, 636861, 636849, 601208, 610322, 636842, 636822, 636831, 596340, 596337, 527978, 636825, 583801, 309843, 607945, 309841, 636819, 636817, 453172, 636814, 309838, 309836, 309833, 309831, 309830, 453169, 596332, 596329, 636807, 610321, 596327, 630260, 601207, 596323, 636803, 636800, 636798, 636796, 596317, 636794, 628648, 636787, 636750, 636765, 636771, 636769, 636763, 636761, 47081, 636748, 614034, 614032, 635112, 614030, 635110, 614028, 635106, 636726, 635104, 628594, 628592, 636693, 628589, 601206, 635101, 628587, 635099, 632800, 635096, 446708, 634325, 309826, 309823, 309821, 309819, 309815, 636705, 636649, 309811, 632792, 636465, 636691, 636688, 247248, 636462, 247245, 610320, 596305, 636559, 636555, 636627, 596302, 596300, 446702, 596298, 601205, 636678, 636617, 636675, 634371, 636671, 634010, 634008, 634006, 634004, 633994, 596293, 446680, 580645, 453817, 446678, 630257, 580644, 636614, 446677, 580642, 580640, 580638, 446675, 324071, 446673, 636103, 636608, 636605, 324069, 636553, 636551, 636260, 636549, 630256, 607490, 636597, 607487, 630254, 601200, 636129, 636582, 636579, 636592, 636569, 596290, 636566, 636563, 446671, 636546, 636540, 608520, 636538, 636536, 580634, 580632, 580630, 580628, 636530, 580626, 608516, 630253, 580623, 580621, 601199, 634585, 629971, 630252, 601198, 636484, 626749, 636509, 636507, 636505, 636503, 636518, 446667, 636481, 446664, 628403, 636457, 446659, 636495, 446655, 636476, 446652, 636443, 596286, 635669, 630251, 635665, 446648, 636426, 446645, 630247, 446639, 636434, 636436, 446634, 636431, 636422, 636428, 630244, 636407, 596282, 596280, 636420, 636405, 636416, 636376, 636396, 606246, 606244, 606242, 636392, 606240, 636374, 606238, 636367, 636372, 636357, 636347, 636234, 636336, 636279, 636328, 446627, 636331, 636326, 446622, 446618, 636317, 446615, 636315, 636308, 610315, 636311, 446613, 636275, 596271, 596269, 596267, 636270, 446602, 630243, 636296, 636294, 636292, 636290, 636288, 636300, 636268, 446598, 446595, 636212, 634341, 606401, 636264, 629969, 606396, 457270, 446583, 446581, 636256, 446576, 636254, 446574, 446566, 446564, 446562, 446560, 446555, 636229, 446549, 636238, 636194, 636192, 446543, 636190, 636223, 446531, 601197, 635997, 630238, 636219, 636217, 446529, 596261, 596259, 636139, 630237, 446522, 247235, 247232, 636159, 636157, 636165, 636176, 636136, 636135, 629968, 630236, 636125, 636123, 610313, 610311, 635962, 635956, 446503, 630235, 636109, 634956, 636097, 636107, 636105, 634954, 446494, 446489, 635993, 635613, 446481, 635611, 247225, 446475, 629967, 446473, 247220, 247211, 635907, 610310, 635887, 636084, 601194, 630234, 603015, 181010, 247202, 635949, 635946, 636021, 635943, 635941, 635939, 635383, 636008, 635934, 635977, 635382, 635928, 635377, 635917, 635881, 635913, 635904, 632957, 635900, 601186, 634323, 446465, 609073, 446456, 446454, 446452, 635850, 628792, 601185, 635815, 635835, 635832, 635840, 635838, 601184, 446443, 628787, 446440, 601183, 635797, 631216, 601181, 635793, 628785, 459892, 630121, 635791, 630119, 635765, 635682, 635762, 635757, 632254, 635754, 627727, 635743, 635740, 635738, 635735, 453163, 610309, 628351, 628349, 596237, 596235, 610307, 635727, 635725, 630230, 601180, 634410, 626958, 634408, 626956, 635560, 635716, 635713, 630229, 596228, 635708, 593757, 635702, 604935, 446431, 635700, 635698, 596226, 635696, 630222, 635678, 632215, 596224, 632212, 635605, 635628, 635602, 635313, 446418, 446416, 247194, 635582, 635579, 601179, 632251, 610305, 601178, 635577, 635572, 604884, 604882, 604880, 608514, 630221, 596223, 614898, 596217, 602460, 635556, 596210, 602458, 602455, 635492, 635552, 635548, 635488, 635454, 635452, 635539, 610303, 635478, 635522, 635520, 635517, 635467, 613970, 635512, 635031, 635475, 635462, 635027, 596807, 601174, 635450, 635447, 635434, 629961, 635257, 635421, 635346, 635428, 635344, 544900, 609388, 634136, 635334, 634132, 635326, 635369, 635311, 612378, 629959, 634130, 635277, 635288, 635275, 635245, 632249, 601172, 629956, 630220, 596203, 635286, 635284, 635264, 635281, 635279, 635195, 635190, 594641, 635256, 446392, 604362, 446388, 635188, 539740, 608502, 601171, 446380, 446376, 635019, 635017, 635015, 635083, 634243, 634241, 612375, 596196, 612374, 596194, 612372, 446366, 612370, 557063, 596192, 446362, 446360, 635011, 635008, 596190, 635173, 201182, 635171, 635075, 635165, 634238, 634891, 635163, 635044, 635067, 635052, 600046, 601170, 635041, 634889, 634406, 630218, 363573, 363572, 634911, 363570, 634950, 634948, 634975, 634990, 634973, 634960, 634978, 634969, 634930, 634907, 634902, 634900, 634898, 446348, 446346, 610301, 610299, 634836, 634835, 634796, 634852, 634850, 610298, 610296, 634828, 634826, 634609, 634883, 634881, 634605, 634814, 634847, 634845, 634811, 634876, 634873, 601168, 634777, 630217, 607485, 596186, 634680, 629013, 629009, 634774, 634761, 247183, 247176, 247172, 247169, 634744, 634696, 634694, 634708, 634706, 634722, 634719, 446310, 634660, 634665, 634650, 634655, 630216, 634626, 634618, 630215, 629951, 634210, 634613, 634600, 634566, 634565, 634562, 610295, 201181, 610294, 601164, 610292, 634583, 634581, 628999, 634569, 446302, 634397, 628997, 634536, 634533, 634531, 629950, 634528, 634520, 601162, 634394, 247168, 634390, 634477, 634474, 634472, 634421, 630210, 634385, 634384, 634419, 633858, 630206, 634428, 630205, 634361, 630203, 634329, 634351, 634357, 629947, 629945, 633856, 633854, 633848, 634299, 512061, 634311, 634308, 634306, 634304, 446282, 630202, 446276, 601158, 630201, 601154, 629940, 633638, 446272, 630200, 534617, 596173, 630198, 596170, 201180, 446262, 201177, 634233, 634227, 634224, 634221, 634218, 634040, 634089, 634086, 634121, 610289, 634084, 634119, 613159, 634114, 634112, 446248, 446246, 601151, 630196, 634074, 634073, 610287, 632571, 446239, 634069, 446237, 634063, 446235, 634059, 602491, 602487, 602482, 634049, 628261, 634105, 601149, 628259, 630193, 632562, 634046, 602478, 634044, 634099, 632558, 633585, 633580, 633576, 592741, 592738, 592735, 629938, 634036, 634034, 634032, 634030, 634027, 623642, 601688, 633988, 633986, 633806, 634019, 633980, 605255, 633844, 633901, 633897, 605247, 633895, 633840, 446234, 446232, 446229, 630190, 628258, 630187, 630185, 605233, 596165, 633683, 446227, 629936, 633785, 633825, 633783, 633796, 633794, 633792, 633790, 596162, 596159, 633676, 633758, 633775, 633773, 633770, 633756, 633768, 633753, 201173, 633670, 633706, 628640, 633666, 593669, 599533, 446218, 633615, 599530, 610286, 599525, 599523, 633064, 629931, 601142, 599518, 633647, 633883, 633645, 633878, 596153, 593658, 601141, 633875, 601685, 596149, 596146, 607480, 446200, 601137, 446199, 446197, 596142, 633624, 596140, 633610, 446191, 633569, 633567, 446188, 633562, 446185, 446182, 611451, 633554, 633552, 633536, 611449, 633113, 633547, 633526, 633524, 633481, 446180, 633493, 633498, 632047, 633108, 632925, 446172, 633870, 632921, 633491, 630184, 632917, 633867, 633864, 596137, 596134, 608499, 633467, 633454, 633465, 601682, 633450, 633225, 633223, 596129, 633220, 629920, 633216, 629917, 633214, 633212, 623637, 630182, 633327, 610285, 633390, 633209, 633205, 633202, 633263, 628439, 633397, 633261, 610283, 633383, 596119, 596117, 596115, 596113, 632882, 596110, 633320, 633176, 633317, 633091, 633314, 633186, 633307, 629916, 623633, 629914, 633268, 608495, 608492, 608491, 596106, 633251, 633130, 633244, 633241, 446147, 633235, 633181, 633079, 446144, 633173, 446143, 446141, 630180, 630833, 633162, 632248, 633158, 446138, 446136, 633156, 446127, 446125, 446121, 633152, 633146, 633144, 633025, 446118, 631983, 633023, 631980, 631978, 633014, 629911, 633038, 633061, 633034, 633057, 201170, 633054, 446110, 446109, 633050, 633048, 632990, 632741, 201168, 633018, 633044, 633042, 633003, 446106, 446104, 632999, 446101, 608349, 632977, 632879, 632971, 632941, 608483, 631910, 632967, 608475, 446098, 446095, 446093, 446091, 446089, 446087, 446084, 446082, 632985, 632983, 446073, 446071, 446068, 632961, 446060, 446058, 627619, 247157, 446056, 446054, 632910, 247155, 632873, 446050, 446047, 446043, 446040, 627707, 189130, 632869, 632867, 632863, 632861, 632859, 632854, 632850, 612709, 628235, 445996, 445993, 632790, 630179, 632714, 632063, 247143, 247141, 247137, 247135, 445990, 445987, 632671, 629909, 632665, 632173, 632663, 445977, 632718, 630176, 445972, 632710, 632547, 609961, 629908, 631625, 629906, 629904, 445967, 631598, 631595, 631592, 632647, 632634, 630175, 594637, 632617, 632614, 632630, 632628, 632626, 632624, 632621, 632619, 627251, 632611, 629903, 445961, 632603, 627245, 627243, 627241, 445956, 445952, 632242, 631568, 631564, 632592, 631561, 632524, 632549, 632530, 632535, 632239, 632522, 632541, 632496, 632494, 630174, 632443, 630172, 632489, 630170, 445950, 535605, 247127, 632441, 632476, 445944, 629901, 629899, 445943, 445941, 445939, 632436, 632431, 632424, 247125, 632465, 632419, 632417, 632366, 630169, 605146, 629896, 632412, 632409, 632406, 632403, 632399, 632397))
Run Time: 0.127268
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2959 | |
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 | | | | | 2959 | |
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 (35588, 35583, 35575, 35550, 35513, 35506, 35502, 35489, 35484, 35476, 35464, 35437, 35436, 35434, 35427, 35384, 35355, 35317, 35289, 35288, 35247, 35239, 35235, 35220, 35199, 35163, 35110, 35105, 35097, 35088, 35079, 35071, 35055, 35044, 35005, 34997, 34967, 34940, 34935, 34931, 34904, 34891, 34854, 34845, 34836, 34803, 34790, 34763, 34752, 34745, 34724, 34713, 34709, 34695, 34692, 34673, 34619, 34609, 34607, 34573, 34572, 34560, 34636, 34532, 34514, 34504, 34501, 34499, 34480, 34469, 34448, 34434, 34427, 34393, 34369, 34341, 34329, 34326, 34298, 34297, 34287, 34279, 34214, 34199, 34153, 34137))
Run Time: 0.002805
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 86 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (646461, 646449, 646444, 646442, 646423, 646418, 646395, 646391, 646389, 646383, 646381, 646377, 646355, 646337, 646335, 646322, 646321, 646314, 646310, 646304, 646301, 646296, 646294, 646283, 646277, 646269, 646263, 646261, 646260, 646250, 646248, 646244, 646242, 646241, 646234, 646229, 646223, 646220, 646215, 646208, 646194, 646184, 646180, 646174, 646162, 646159, 646154, 646152, 646146, 646143, 646137, 646134, 646125, 646123, 646114, 646087, 646070, 646063, 646057, 646056, 646030, 646006, 646004, 645998, 645994, 645993, 645992, 645990, 645985, 645983, 645974, 645967, 645964, 645961, 645958, 645955, 645944, 645940, 645922, 645921, 645911, 645899, 645897, 645878, 645871, 645829, 645821, 645817, 645803, 645801, 645795, 645776, 645773, 645771, 645764, 645758, 645756, 645754, 645749, 645745, 645738, 645732, 645728, 645724, 645709, 645703, 645697, 645695, 645686, 645684, 645676, 645671, 645669, 645660, 645653, 645652, 645651, 645650, 645625, 645620, 645616, 645607, 645603, 645594, 645582, 645576, 645561, 645557, 645531, 645530, 645525, 645516, 645512, 645503, 645492, 645479, 645467, 645463, 645454, 645453, 645438, 645430, 645427, 645424, 645416, 645403, 645400, 645392, 645386, 645375, 645373, 645371, 645368, 645366, 645358, 645354, 645335, 645332, 645318, 645311, 645305, 645296, 645293, 645284, 645282, 645278, 645272, 645271, 645269, 645268, 645265, 645262, 645258, 645257, 645253, 645251, 645216, 645203, 645202, 645198, 645196, 645182, 645176, 645173, 645172, 645167, 645160, 645159, 645150, 645147, 645142, 645141, 645140, 645137, 645134, 645132, 645129, 645123, 645122, 645118, 645103, 645100, 645087, 645074, 645072, 645066, 645062, 645059, 645053, 645050, 645048, 645032, 645030, 645028, 645027, 645023, 645021, 645018, 645013, 645009, 645007, 644999, 644994, 644980, 644977, 644974, 644963, 644958, 644956, 644954, 644939, 644936, 644933, 644926, 644911, 644903, 644899, 644897, 644886, 644877, 644865, 644863, 644850, 644843, 644840, 644836, 644828, 644824, 644821, 644815, 644811, 644796, 644788, 644787, 644769, 644767, 644765, 644764, 644762, 644737, 644728, 644719, 644700, 644693, 644692, 644689, 644674, 644668, 644661, 644658, 644653, 644650, 644643, 644638, 644637, 644627, 644612, 644604, 644601, 644597, 644595, 644594, 644589, 644582, 644576, 644574, 644570, 644569, 644562, 644560, 644559, 644556, 644546, 644536, 644533, 644526, 644502, 644500, 644477, 644470, 644463, 644457, 644450, 644442, 644430, 644426, 644412, 644410, 644409, 644408, 644406, 644387, 644384, 644364, 644359, 644357, 644353, 644352, 644308, 644281, 644222, 644220, 644189, 644176, 644172, 644167, 644158, 644157, 644155, 644148, 644140, 644129, 644128, 644122, 644114, 644112, 644110, 644107, 644101, 644084, 644080, 644079, 644070, 644068, 644066, 644064, 644054, 644052, 644049, 644044, 644034, 644032, 644031, 644020, 644009, 644007, 644004, 644002, 643998, 643997, 643995, 643988, 643979, 643978, 643969, 643968, 643960, 643955, 643933, 643922, 643915, 643908, 643886, 643875, 643866, 643856, 643852, 643850, 643846, 643842, 643838, 643835, 643823, 643820, 643807, 643806, 643804, 643788, 643787, 643779, 643775, 643772, 643764, 643762, 643757, 643752, 643744, 643743, 643730, 643726, 643721, 643718, 643716, 643713, 643706, 643703, 643679, 643678, 643677, 643674, 643659, 643657, 643654, 643650, 643649, 643645, 643641, 643639, 643635, 643625, 643611, 643601, 643599, 643597, 643596, 643587, 643582, 643581, 643569, 643564, 643554, 643551, 643535, 643526, 643517, 643516, 643512, 643511, 643503, 643494, 643485, 643484, 643479, 643467, 643464, 643463, 643450, 643446, 643438, 643432, 643428, 643423, 643420, 643418, 643414, 643411, 643409, 643394, 643390, 643387, 643385, 643383, 643377, 643369, 643358, 643333, 643324, 643321, 643317, 643312, 643307, 643301, 643300, 643295, 643290, 643289, 643276, 643273, 643265, 643262, 643260, 643258, 643256, 643248, 643237, 643236, 643225, 643206, 643202, 643198, 643188, 643182, 643177, 643173, 643171, 643165, 643159, 643158, 643151, 643150, 643146, 643128, 643115, 643109, 643104, 643101, 643075, 643067, 643062, 643043, 643039, 643036, 643035, 643028, 643021, 643020, 643018, 643008, 643004, 642989, 642982, 642968, 642964, 642961, 642958, 642953, 642942, 642935, 642933, 642923, 642921, 642917, 642898, 642896, 642894, 642886, 642880, 642857, 642816, 642806, 642802, 642797, 642785, 642782, 642775, 642774, 642766, 642762, 642759, 642735, 642726, 642725, 642717, 642708, 642707, 642694, 642692, 642691, 642676, 642674, 642671, 642651, 642649, 642646, 642639, 642633, 642627, 642625, 642596, 642593, 642545, 642540, 642531, 642525, 642512, 642502, 642497, 642440, 642436, 642431, 642422, 642403, 642401, 642399, 642396, 642394, 642389, 642381, 642378, 642372, 642368, 642364, 642356, 642351, 642349, 642345, 642344, 642342, 642336, 642334, 642331, 642325, 642320, 642316, 642309, 642291, 642289, 642284, 642281, 642279, 642274, 642268, 642267, 642262, 642258, 642249, 642222, 642220, 642212, 642208, 642205, 642199, 642197, 642193, 642187, 642183, 642180, 642159, 642149, 642147, 642143, 642140, 642136, 642131, 642119, 642111, 642109, 642106, 642102, 642097, 642090, 642088, 642086, 642082, 642065, 642052, 642046, 642033, 642030, 642028, 642010, 641965, 641956, 641929, 641924, 641922, 641918, 641912, 641876, 641875, 641868, 641851, 641830, 641827, 641824, 641817, 641809, 641801, 641799, 641798, 641783, 641782, 641781, 641770, 641761, 641756, 641753, 641750, 641744, 641743, 641741, 641740, 641725, 641714, 641712, 641700, 641688, 641683, 641678, 641675, 641674, 641669, 641662, 641651, 641640, 641624, 641614, 641602, 641598, 641593, 641590, 641580, 641578, 641567, 641563, 641561, 641559, 641556, 641555, 641549, 641548, 641546, 641544, 641531, 641525, 641524, 641519, 641503, 641483, 641463, 641458, 641431, 641417, 641415, 641412, 641408, 641389, 641376, 641370, 641369, 641364, 641361, 641357, 641356, 641341, 641331, 641321, 641314, 641307, 641303, 641300, 641281, 641280, 641270, 641267, 641265, 641264, 641261, 641247, 641246, 641244, 641240, 641236, 641234, 641181, 641168, 641164, 641160, 641158, 641152, 641151, 641126, 641119, 641084, 641078, 641065, 641034, 641028, 641026, 641025, 641019, 641017, 641014, 641008, 641006, 640994, 640990, 640988, 640986, 640984, 640982, 640981, 640975, 640966, 640961, 640950, 640945, 640944, 640936, 640935, 640930, 640929, 640926, 640924, 640922, 640901, 640892, 640885, 640881, 640879, 640877, 640873, 640866, 640863, 640861, 640859, 640858, 640855, 640850, 640849, 640848, 640837, 640827, 640822, 640820, 640817, 639743, 639741, 247291, 640806, 607498, 580772, 580770, 640797, 640772, 640800, 640787, 612713, 447745, 640592, 640766, 640743, 640769, 640759, 640747, 640692, 640730, 447739, 640727, 640725, 447734, 640723, 447728, 447726, 639304, 447722, 447719, 640684, 640681, 640678, 640705, 640669, 447716, 604374, 640259, 640605, 447712, 640665, 640658, 640656, 640654, 640649, 640645, 633976, 633973, 580768, 633971, 633969, 633965, 640450, 633957, 640635, 640631, 640629, 640626, 640603, 633952, 593135, 633950, 640581, 640574, 640598, 640393, 447696, 447694, 604371, 580753, 580751, 607031, 607029, 639012, 640563, 640567, 580747, 447692, 580744, 580742, 596417, 447686, 447681, 447679, 604368, 447677, 640498, 539612, 447674, 201205, 417935, 447673, 417933, 417931, 447671, 417929, 639737, 447667, 639735, 417925, 639732, 447664, 639730, 447661, 583995, 109279, 109277, 109273, 109267, 109265, 109261, 639727, 640300, 639725, 640552, 447657, 447655, 447653, 630008, 447643, 447641, 447639, 447637, 635400, 635398, 635396, 447634, 447632, 447630, 635394, 447628, 447626, 447624, 447622, 447616, 639716, 447613, 640536, 640523, 604367, 247289, 639713, 630294, 639993, 635390, 639990, 639988, 639985, 640129, 635388, 640126, 640466, 640514, 640462, 639710, 639626, 639624, 639622, 638792, 640296, 640482, 640480, 640476, 447594, 640460, 638790, 447586, 447581, 447579, 623568, 640291, 623564, 640448, 640289, 636284, 640423, 640443, 640421, 640418, 640438, 639702, 640401, 607494, 604204, 639928, 640391, 539607, 447565, 601276, 606403, 630293, 637205, 539600, 539598, 640177, 640174, 638891, 601268, 447558, 447556, 640317, 640253, 640251, 640249, 447549, 447546, 544905, 640346, 640340, 640322, 640334, 640283, 640203, 640243, 638788, 640192, 189148, 640190, 637076, 639696, 637057, 637052, 640172, 596413, 640119, 633341, 633338, 633336, 640115, 640113, 640111, 640108, 640105, 640101, 640099, 447533, 447530, 640084, 309846, 309844, 640080, 632219, 640138, 640151, 640062, 630004, 630291, 638785, 638782, 640057, 640055, 639534, 637600, 639512, 604365, 580736, 637596, 637593, 447501, 247286, 634180, 634175, 447490, 639965, 640033, 539585, 447457, 539578, 640003, 640024, 640022, 539576, 639954, 539574, 639295, 640017, 639291, 639468, 447434, 447415, 639922, 639958, 447404, 639948, 639952, 639944, 639880, 447385, 639889, 639678, 639675, 447383, 639884, 628237, 639768, 639874, 639765, 639782, 638143, 639452, 639658, 580733, 447376, 639449, 639447, 639445, 639443, 639667, 247283, 447370, 639664, 639747, 639653, 639651, 639649, 639647, 447361, 580730, 639660, 247279, 580728, 639587, 639636, 639584, 639576, 639441, 639572, 639438, 639568, 627543, 639566, 639595, 639562, 447354, 639582, 491358, 491356, 447352, 639579, 639430, 447335, 639547, 447328, 447325, 630289, 639417, 639525, 447311, 630002, 447308, 447303, 447301, 630000, 372063, 639407, 636683, 639403, 420426, 636072, 639279, 639383, 639381, 534891, 639374, 447287, 639371, 639369, 447279, 447277, 639334, 639254, 639330, 639252, 639250, 639322, 639314, 639246, 639312, 639309, 639243, 601704, 630286, 447274, 639084, 639081, 447269, 639079, 447268, 639076, 447264, 639067, 601702, 639260, 600047, 639063, 639060, 639058, 635674, 447252, 639237, 447246, 639234, 639231, 639228, 605124, 639052, 447239, 447237, 463750, 447228, 447222, 630285, 447216, 634141, 638969, 639043, 639206, 639039, 629997, 630284, 638967, 548409, 447204, 623645, 447194, 447192, 631217, 639137, 639153, 639171, 639169, 639141, 639139, 639128, 626148, 447156, 634940, 580722, 447152, 635142, 639005, 610337, 635132, 635128, 638965, 635121, 638912, 635119, 599047, 630283, 603527, 201200, 638995, 638910, 447129, 447125, 447124, 447121, 638889, 638989, 638987, 638982, 638884, 638973, 578054, 638703, 574781, 578052, 578050, 578047, 578045, 578043, 578038, 638942, 447109, 638924, 638881, 638904, 447099, 638929, 638898, 638921, 638926, 638876, 638697, 638868, 638866, 638695, 638737, 637980, 637978, 638726, 256737, 630281, 637977, 638825, 630279, 638814, 638804, 638812, 638776, 638759, 638731, 638559, 631925, 638748, 631923, 638745, 638557, 638555, 638677, 638675, 447091, 638662, 638669, 638660, 638658, 638656, 638021, 638632, 638630, 638622, 638620, 638617, 629993, 601243, 638613, 638611, 638604, 638608, 493688, 493686, 638601, 629992, 638571, 638575, 638568, 606808, 638426, 638423, 638493, 638546, 638542, 638539, 610336, 638485, 580715, 638537, 638483, 630276, 580713, 610335, 580709, 610333, 580703, 634171, 580693, 453825, 638477, 638473, 638471, 638469, 638467, 638506, 638522, 630274, 638520, 638465, 637681, 638504, 638321, 638463, 638502, 638461, 447078, 447076, 447058, 623556, 447052, 638459, 638452, 638450, 638457, 596408, 637679, 638319, 636682, 638374, 638318, 638372, 572557, 572554, 638401, 447044, 638394, 572548, 447041, 638274, 56471, 447032, 56469, 56466, 447022, 638227, 638225, 447018, 638299, 447016, 630273, 601238, 630272, 601237, 638352, 447012, 638328, 638350, 447004, 447002, 447000, 446997, 446995, 446993, 638317, 638313, 638293, 638306, 580689, 580687, 638303, 638290, 580680, 638176, 638192, 638283, 638187, 638280, 638262, 638260, 633726, 638258, 638256, 446984, 612894, 612891, 633939, 633933, 633930, 638239, 633925, 633921, 633919, 633915, 633910, 638219, 633908, 638215, 638211, 638208, 638173, 638132, 638235, 638232, 638164, 638162, 638171, 446980, 638223, 638203, 630271, 446971, 446969, 446967, 446965, 446963, 446961, 446958, 638185, 638196, 638179, 638167, 638160, 637986, 638103, 638158, 638101, 638099, 638097, 605828, 349628, 637912, 247269, 247267, 638061, 638093, 638059, 638156, 637909, 632260, 636893, 638056, 596405, 596403, 629092, 638018, 637504, 638014, 637502, 638041, 638039, 638037, 638035, 637627, 637998, 637498, 637952, 637960, 637984, 637972, 637982, 637933, 632258, 637925, 636561, 633475, 637877, 446933, 637875, 637869, 637920, 629982, 630269, 636681, 446921, 636698, 637492, 637864, 612887, 637860, 612883, 612879, 637898, 637893, 637854, 637891, 636696, 637589, 565478, 637490, 612874, 615744, 637487, 637485, 637587, 637585, 637849, 446904, 637783, 446901, 637845, 637481, 637477, 637475, 637473, 637471, 637779, 565474, 565471, 637756, 565468, 565466, 632097, 637750, 637753, 500385, 612357, 601229, 637734, 637732, 612872, 637742, 632135, 637730, 637728, 612351, 637624, 612869, 612867, 446890, 637717, 446887, 637677, 446885, 637715, 637666, 637663, 637712, 608521, 637708, 630268, 637611, 637609, 637607, 637658, 637649, 580673, 637641, 637638, 637635, 637603, 637537, 446876, 606025, 637567, 637565, 637561, 446855, 446853, 446850, 446847, 446842, 637469, 637466, 446836, 601223, 637464, 637536, 637534, 446832, 446830, 637532, 637462, 446828, 596391, 637529, 637542, 637524, 637454, 446825, 596388, 601221, 629979, 630267, 610332, 610330, 612866, 612864, 610328, 637428, 612862, 612860, 612857, 637424, 612854, 637379, 637377, 446814, 637375, 637387, 446812, 610326, 637385, 637383, 637348, 637372, 637343, 446808, 636991, 637370, 637381, 637338, 637354, 637352, 637329, 637327, 601219, 636153, 636151, 247264, 629978, 446792, 446790, 601218, 637315, 446788, 637323, 637312, 636149, 636147, 637319, 636145, 637273, 634411, 601217, 636143, 446784, 446779, 634167, 630266, 637303, 637301, 637270, 637268, 637299, 446771, 637289, 637287, 634378, 637285, 637263, 637278, 637257, 446767, 637112, 637247, 637252, 630265, 637250, 637243, 580661, 580659, 607493, 583816, 637233, 607491, 637155, 601214, 453820, 580653, 637223, 637221, 181012, 637230, 414290, 637210, 637171, 637169, 637195, 637148, 637146, 596378, 596376, 637101, 334016, 596367, 334012, 630263, 637074, 623549, 637123, 637120, 637118, 636719, 596364, 637006, 637004, 630262, 580649, 580646, 637069, 637067, 596360, 637104, 446744, 637049, 446742, 446739, 637043, 637085, 247255, 636913, 637029, 637027, 636735, 637002, 637018, 596356, 596354, 637000, 636996, 636994, 636588, 636586, 636241, 479701, 630261, 446733, 596349, 453819, 446730, 446729, 446727, 596347, 446723, 636983, 601211, 610325, 636977, 636973, 636933, 610323, 636931, 446719, 601209, 636927, 636910, 636924, 633380, 636921, 636902, 636782, 636917, 633376, 636730, 636779, 633373, 636845, 633821, 636852, 636776, 636861, 636849, 601208, 610322, 636842, 636822, 636831, 596340, 596337, 527978, 636825, 583801, 309843, 607945, 309841, 636819, 636817, 453172, 636814, 309838, 309836, 309833, 309831, 309830, 453169, 596332, 596329, 636807, 610321, 596327, 630260, 601207, 596323, 636803, 636800, 636798, 636796, 596317, 636794, 628648, 636787, 636750, 636765, 636771, 636769, 636763, 636761, 47081, 636748, 614034, 614032, 635112, 614030, 635110, 614028, 635106, 636726, 635104, 628594, 628592, 636693, 628589, 601206, 635101, 628587, 635099, 632800, 635096, 446708, 634325, 309826, 309823, 309821, 309819, 309815, 636705, 636649, 309811, 632792, 636465, 636691, 636688, 247248, 636462, 247245, 610320, 596305, 636559, 636555, 636627, 596302, 596300, 446702, 596298, 601205, 636678, 636617, 636675, 634371, 636671, 634010, 634008, 634006, 634004, 633994, 596293, 446680, 580645, 453817, 446678, 630257, 580644, 636614, 446677, 580642, 580640, 580638, 446675, 324071, 446673, 636103, 636608, 636605, 324069, 636553, 636551, 636260, 636549, 630256, 607490, 636597, 607487, 630254, 601200, 636129, 636582, 636579, 636592, 636569, 596290, 636566, 636563, 446671, 636546, 636540, 608520, 636538, 636536, 580634, 580632, 580630, 580628, 636530, 580626, 608516, 630253, 580623, 580621, 601199, 634585, 629971, 630252, 601198, 636484, 626749, 636509, 636507, 636505, 636503, 636518, 446667, 636481, 446664, 628403, 636457, 446659, 636495, 446655, 636476, 446652, 636443, 596286, 635669, 630251, 635665, 446648, 636426, 446645, 630247, 446639, 636434, 636436, 446634, 636431, 636422, 636428, 630244, 636407, 596282, 596280, 636420, 636405, 636416, 636376, 636396, 606246, 606244, 606242, 636392, 606240, 636374, 606238, 636367, 636372, 636357, 636347, 636234, 636336, 636279, 636328, 446627, 636331, 636326, 446622, 446618, 636317, 446615, 636315, 636308, 610315, 636311, 446613, 636275, 596271, 596269, 596267, 636270, 446602, 630243, 636296, 636294, 636292, 636290, 636288, 636300, 636268, 446598, 446595, 636212, 634341, 606401, 636264, 629969, 606396, 457270, 446583, 446581, 636256, 446576, 636254, 446574, 446566, 446564, 446562, 446560, 446555, 636229, 446549, 636238, 636194, 636192, 446543, 636190, 636223, 446531, 601197, 635997, 630238, 636219, 636217, 446529, 596261, 596259, 636139, 630237, 446522, 247235, 247232, 636159, 636157, 636165, 636176, 636136, 636135, 629968, 630236, 636125, 636123, 610313, 610311, 635962, 635956, 446503, 630235, 636109, 634956, 636097, 636107, 636105, 634954, 446494, 446489, 635993, 635613, 446481, 635611, 247225, 446475, 629967, 446473, 247220, 247211, 635907, 610310, 635887, 636084, 601194, 630234, 603015, 181010, 247202, 635949, 635946, 636021, 635943, 635941, 635939, 635383, 636008, 635934, 635977, 635382, 635928, 635377, 635917, 635881, 635913, 635904, 632957, 635900, 601186, 634323, 446465, 609073, 446456, 446454, 446452, 635850, 628792, 601185, 635815, 635835, 635832, 635840, 635838, 601184, 446443, 628787, 446440, 601183, 635797, 631216, 601181, 635793, 628785, 459892, 630121, 635791, 630119, 635765, 635682, 635762, 635757, 632254, 635754, 627727, 635743, 635740, 635738, 635735, 453163, 610309, 628351, 628349, 596237, 596235, 610307, 635727, 635725, 630230, 601180, 634410, 626958, 634408, 626956, 635560, 635716, 635713, 630229, 596228, 635708, 593757, 635702, 604935, 446431, 635700, 635698, 596226, 635696, 630222, 635678, 632215, 596224, 632212, 635605, 635628, 635602, 635313, 446418, 446416, 247194, 635582, 635579, 601179, 632251, 610305, 601178, 635577, 635572, 604884, 604882, 604880, 608514, 630221, 596223, 614898, 596217, 602460, 635556, 596210, 602458, 602455, 635492, 635552, 635548, 635488, 635454, 635452, 635539, 610303, 635478, 635522, 635520, 635517, 635467, 613970, 635512, 635031, 635475, 635462, 635027, 596807, 601174, 635450, 635447, 635434, 629961, 635257, 635421, 635346, 635428, 635344, 544900, 609388, 634136, 635334, 634132, 635326, 635369, 635311, 612378, 629959, 634130, 635277, 635288, 635275, 635245, 632249, 601172, 629956, 630220, 596203, 635286, 635284, 635264, 635281, 635279, 635195, 635190, 594641, 635256, 446392, 604362, 446388, 635188, 539740, 608502, 601171, 446380, 446376, 635019, 635017, 635015, 635083, 634243, 634241, 612375, 596196, 612374, 596194, 612372, 446366, 612370, 557063, 596192, 446362, 446360, 635011, 635008, 596190, 635173, 201182, 635171, 635075, 635165, 634238, 634891, 635163, 635044, 635067, 635052, 600046, 601170, 635041, 634889, 634406, 630218, 363573, 363572, 634911, 363570, 634950, 634948, 634975, 634990, 634973, 634960, 634978, 634969, 634930, 634907, 634902, 634900, 634898, 446348, 446346, 610301, 610299, 634836, 634835, 634796, 634852, 634850, 610298, 610296, 634828, 634826, 634609, 634883, 634881, 634605, 634814, 634847, 634845, 634811, 634876, 634873, 601168, 634777, 630217, 607485, 596186, 634680, 629013, 629009, 634774, 634761, 247183, 247176, 247172, 247169, 634744, 634696, 634694, 634708, 634706, 634722, 634719, 446310, 634660, 634665, 634650, 634655, 630216, 634626, 634618, 630215, 629951, 634210, 634613, 634600, 634566, 634565, 634562, 610295, 201181, 610294, 601164, 610292, 634583, 634581, 628999, 634569, 446302, 634397, 628997, 634536, 634533, 634531, 629950, 634528, 634520, 601162, 634394, 247168, 634390, 634477, 634474, 634472, 634421, 630210, 634385, 634384, 634419, 633858, 630206, 634428, 630205, 634361, 630203, 634329, 634351, 634357, 629947, 629945, 633856, 633854, 633848, 634299, 512061, 634311, 634308, 634306, 634304, 446282, 630202, 446276, 601158, 630201, 601154, 629940, 633638, 446272, 630200, 534617, 596173, 630198, 596170, 201180, 446262, 201177, 634233, 634227, 634224, 634221, 634218, 634040, 634089, 634086, 634121, 610289, 634084, 634119, 613159, 634114, 634112, 446248, 446246, 601151, 630196, 634074, 634073, 610287, 632571, 446239, 634069, 446237, 634063, 446235, 634059, 602491, 602487, 602482, 634049, 628261, 634105, 601149, 628259, 630193, 632562, 634046, 602478, 634044, 634099, 632558, 633585, 633580, 633576, 592741, 592738, 592735, 629938, 634036, 634034, 634032, 634030, 634027, 623642, 601688, 633988, 633986, 633806, 634019, 633980, 605255, 633844, 633901, 633897, 605247, 633895, 633840, 446234, 446232, 446229, 630190, 628258, 630187, 630185, 605233, 596165, 633683, 446227, 629936, 633785, 633825, 633783, 633796, 633794, 633792, 633790, 596162, 596159, 633676, 633758, 633775, 633773, 633770, 633756, 633768, 633753, 201173, 633670, 633706, 628640, 633666, 593669, 599533, 446218, 633615, 599530, 610286, 599525, 599523, 633064, 629931, 601142, 599518, 633647, 633883, 633645, 633878, 596153, 593658, 601141, 633875, 601685, 596149, 596146, 607480, 446200, 601137, 446199, 446197, 596142, 633624, 596140, 633610, 446191, 633569, 633567, 446188, 633562, 446185, 446182, 611451, 633554, 633552, 633536, 611449, 633113, 633547, 633526, 633524, 633481, 446180, 633493, 633498, 632047, 633108, 632925, 446172, 633870, 632921, 633491, 630184, 632917, 633867, 633864, 596137, 596134, 608499, 633467, 633454, 633465, 601682, 633450, 633225, 633223, 596129, 633220, 629920, 633216, 629917, 633214, 633212, 623637, 630182, 633327, 610285, 633390, 633209, 633205, 633202, 633263, 628439, 633397, 633261, 610283, 633383, 596119, 596117, 596115, 596113, 632882, 596110, 633320, 633176, 633317, 633091, 633314, 633186, 633307, 629916, 623633, 629914, 633268, 608495, 608492, 608491, 596106, 633251, 633130, 633244, 633241, 446147, 633235, 633181, 633079, 446144, 633173, 446143, 446141, 630180, 630833, 633162, 632248, 633158, 446138, 446136, 633156, 446127, 446125, 446121, 633152, 633146, 633144, 633025, 446118, 631983, 633023, 631980, 631978, 633014, 629911, 633038, 633061, 633034, 633057, 201170, 633054, 446110, 446109, 633050, 633048, 632990, 632741, 201168, 633018, 633044, 633042, 633003, 446106, 446104, 632999, 446101, 608349, 632977, 632879, 632971, 632941, 608483, 631910, 632967, 608475, 446098, 446095, 446093, 446091, 446089, 446087, 446084, 446082, 632985, 632983, 446073, 446071, 446068, 632961, 446060, 446058, 627619, 247157, 446056, 446054, 632910, 247155, 632873, 446050, 446047, 446043, 446040, 627707, 189130, 632869, 632867, 632863, 632861, 632859, 632854, 632850, 612709, 628235, 445996, 445993, 632790, 630179, 632714, 632063, 247143, 247141, 247137, 247135, 445990, 445987, 632671, 629909, 632665, 632173, 632663, 445977, 632718, 630176, 445972, 632710, 632547, 609961, 629908, 631625, 629906, 629904, 445967, 631598, 631595, 631592, 632647, 632634, 630175, 594637, 632617, 632614, 632630, 632628, 632626, 632624, 632621, 632619, 627251, 632611, 629903, 445961, 632603, 627245, 627243, 627241, 445956, 445952, 632242, 631568, 631564, 632592, 631561, 632524, 632549, 632530, 632535, 632239, 632522, 632541, 632496, 632494, 630174, 632443, 630172, 632489, 630170, 445950, 535605, 247127, 632441, 632476, 445944, 629901, 629899, 445943, 445941, 445939, 632436, 632431, 632424, 247125, 632465, 632419, 632417, 632366, 630169, 605146, 629896, 632412, 632409, 632406, 632403, 632399, 632397))
Run Time: 0.053911
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2959 | |
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 | | | | | 2959 | |
DERIVED | | | | | | | | No tables used |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, �I�
Run Time: 0.000165
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: �I�, XF\Pub\Controller\Member, RecentContent, valid, user_id=20516, 1717262263, , 0, �I�
Run Time: 0.000944
- 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.000446
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 158
- 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.000641
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 158
- 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: 1717261963
Run Time: 0.000275
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 34 | 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` >= 1717261963)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000511
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 34 | 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