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.000880
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.000212
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` = '1024')
LIMIT 1
Run Time: 0.000536
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.002228
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_1024' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.069175
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 (273107, 273064, 270993, 268764, 270492, 250003, 266434, 266431, 266430, 266747, 266745, 266743, 266721, 266617, 261496, 264716, 83187, 263552, 261511, 258751, 261507, 261504, 261502, 259775, 261644, 261593, 261590, 261426, 261421, 260952, 259965, 142951, 248987, 142949, 259089, 258946, 258460, 202675, 258722, 258458, 258717, 256401, 250339, 253507, 250503, 249937, 250414, 247366, 222656, 206573, 204769, 204834, 204813, 204035, 204130, 204095, 204093, 202821, 201377, 202905, 185819, 194134, 194013, 193845, 187120, 190728, 182161, 189800, 189850, 189812, 182155, 160129, 160127, 189512, 187838, 185807, 183998, 187328, 187646, 187307, 187306, 187304, 187303, 187378, 187301, 139305, 187282, 187298, 187296, 187295, 187224, 187293, 187221, 186897, 187103, 187191, 187095, 186023, 185524, 185700, 185512, 172812, 185392, 185084, 185024, 184761, 183978, 184779, 144486, 184325, 160645, 160642, 184335, 183974, 184230, 184009, 183566, 183715, 183971, 173944, 182300, 174859, 183549, 181991, 183381, 181217, 181215, 181213, 160099, 182126, 181975, 174839, 175134, 174659, 175485, 174829, 175591, 172786, 173519, 164439, 164436, 173517, 172554, 172485, 172766, 172559, 171968, 172177, 171206, 171271, 171352, 85556, 171238, 85554, 157279, 165730, 169136, 167972, 167971, 113928, 162337, 162336, 168692, 168659, 168568, 162334, 162330, 162329, 162327, 168454, 168165, 168451, 168486, 168449, 168525, 168151, 166428, 166424, 167953, 123680, 167589, 166787, 123678, 167017, 166644, 166546, 165883, 166026, 164685, 165034, 164039, 164653, 136384, 161050, 161048, 161045, 152160, 161009, 158524, 158522, 159716, 155496, 158510, 158508, 158507, 159533, 158497, 156496, 151261, 154262, 158194, 158191, 154260, 151133, 157996, 157754, 149359, 157586, 157651, 157550, 157653, 156376, 155675, 155156, 155096, 153332, 153276, 153185, 153184, 153240, 153274, 144411, 152921, 152781, 152610, 151890, 152062, 151148, 149901, 150550, 148883, 148877, 148873, 149894, 149891, 149889, 150107, 149886, 119934, 150105, 150098, 119931, 119929, 149971, 119927, 149849, 147461, 149801, 147958, 145942, 145940, 145930, 119849, 119847, 119845, 145902, 146641, 146729, 146737, 146735, 145863, 145495, 146450, 145493, 143846, 143843, 143841, 143839, 145412, 144999, 144995, 144885, 144879, 144224, 139581, 142423, 141635, 141992, 119724, 136581, 142114, 136578, 139012, 119721, 136560, 136554, 136552, 136550, 136548, 136545, 136543, 136540, 129776, 141807, 140545, 141805, 138978, 138976, 135813, 141620, 140370, 141276, 140450, 138855, 140442, 137963, 138479, 140250, 127663, 119663, 119646, 140119, 138282, 137554, 137361, 137550, 137546, 136074, 126898, 137713, 126896, 137562, 137501, 137499, 135111, 130031, 135063, 135058, 135056, 135086, 135050, 134968, 134990, 135026, 134689, 134687, 133844, 129490, 133840, 133686, 130052, 133362, 130345, 127611, 130010, 119537, 129680, 129712, 129748, 129338, 129336, 129594, 129333, 129329, 129328, 119495, 119493, 128569, 126817, 129241, 128557, 129111, 128445, 128056, 127489, 124366, 127085, 126790, 126776, 125501, 127083, 126942, 126864, 126861, 126922, 84383, 113149, 126934, 113147, 113145, 125660, 123297, 119395, 119387, 114523, 119385, 125398, 124476, 119351, 120387, 124550, 122936, 124033, 124031, 124179, 124345, 124343, 123922, 124136, 123610, 123271, 123742, 123685, 82337, 123557, 123555, 123538, 123533, 119261, 122931, 123370, 122968, 122951, 122729, 85698, 122925, 121516, 121514, 121512, 121638, 122211, 97298, 119130, 119124, 121130, 121051, 120982, 120086, 118854, 120287, 118809, 118215, 118121, 116602, 118210, 116600, 118194, 118108, 118192, 118191, 118185, 118184, 118182, 118180, 118241, 116599, 116597, 116594, 116590, 116588, 116587, 116739, 117079, 113733, 113723, 116766, 116399, 116619, 116650, 116648, 116585, 113709, 113706, 113704, 114713, 116173, 113696, 114711, 113694, 116293, 116290, 116180, 89132, 116167, 115814, 115621, 115810, 115893, 115806, 97081, 116120, 115799, 115927, 114428, 114426, 114545, 114423, 114412, 114393, 114392, 114409, 114388, 114407, 109490, 114386, 114383, 114380, 114378, 114376, 109481, 72119, 98592, 102913, 100404, 113970, 113612, 113610, 113608, 113395, 113337, 113140, 92275, 113333, 113301, 113138, 111952, 113208, 113115, 113103, 113081, 113044, 113027, 112906, 112904, 111647, 112886, 111203, 111200, 112712, 112857, 93726, 111506, 72102, 112435, 96305, 112417, 112383, 110822, 110820, 112414, 112442, 112188, 112336, 112334, 112183, 102478, 109425, 102476, 112016, 102474, 101439, 109503, 100923, 109422, 112133, 102467, 110907, 109420, 100919, 102463, 102459, 97737, 111873, 111858, 111407, 111784, 111405, 111756, 100344, 111445, 111403, 111342, 109396, 101202, 98982, 103310, 103308, 110810, 109365, 109495, 110857, 110854, 103340, 103345, 102897, 103255, 102895, 103336, 102893, 103251, 103230, 103050, 103116, 103099, 102792, 102515, 102513, 102928, 102783, 102781, 102780, 98622, 102777, 102528, 102445, 102181, 91625, 101631, 102359, 101628, 102316, 102114, 102055, 102112, 101976, 101973, 102168, 102000, 102018, 102016, 102085, 102014, 101958, 102012, 101954, 101115, 101949, 101566, 101564, 101562, 101558, 101556, 101725, 96050, 101687, 96048, 101803, 101788, 101758, 101721, 101531, 101700, 101697, 100385, 101673, 101101, 101097, 101095, 101484, 101483, 101507, 101092, 101088, 101505, 101514, 101476, 101083, 101502, 101474, 101512, 101394, 101392, 101072, 101351, 101315, 101246, 101026, 100936, 82565, 100529, 101224, 100527, 101020, 100816, 100814, 99874, 100812, 101222, 101014, 101001, 100998, 100995, 100993, 100990, 100988, 101183, 100985, 100925, 100860, 100802, 100777, 100857, 100699, 100593, 100079, 100795, 100774, 100572, 100367, 67786, 67782, 100160, 67771, 100048, 100047, 99656, 100043, 85487, 99910, 100040, 98319, 98318, 98312, 97966, 98565, 98550, 91336, 99564, 98548, 99391, 97713, 97712, 99399, 99362, 99397, 99358, 99355, 99351, 99339, 99093, 98949, 99333, 99331, 98166, 99279, 99269, 99266, 99260, 99251, 99236, 79834, 99205, 99193, 99185, 99179, 99164, 99161, 99157, 99091, 99153, 96023, 98400, 98995, 97100, 96876, 97811, 98358, 98354, 98348, 97293, 97877, 98237, 90788, 97875, 98286, 90786, 97873, 90758, 98043, 98041, 98039, 90750, 90743, 98139, 90741, 98094, 90738, 90736, 90733, 98063, 90706, 98061, 90704, 95941, 98036, 96207, 97065, 24133, 97057, 96283, 96282, 96277, 96983, 88958, 97007, 96981, 96650, 96647, 88954, 88953, 96313, 96300, 96310, 95781, 96187, 96184, 95779, 95931, 95928, 95777, 95922, 95775, 95761, 90518, 95759, 90516, 95757, 95754, 95773, 95911, 95908, 90456, 95533, 95146, 95111, 95206, 95161, 95250, 95096, 95048, 94325, 94323, 95037, 94118, 94115, 94109, 89316, 94596, 93822, 93820, 94594, 94095, 94592, 94092, 36733, 94218, 94064, 94026, 90237, 93757, 93709, 93954, 93752, 93907, 93905, 93504, 93082, 93662, 93526, 92966, 93497, 85222, 91106, 84672, 91104, 93524, 93569, 93482, 93467, 81242, 93432, 87293, 85220, 83975, 83973, 91089, 83971, 89890, 93361, 89124, 93380, 90170, 90168, 90161, 92960, 93359, 93365, 93262, 93235, 91074, 90155, 92849, 92928, 91062, 92926, 91058, 92922, 81239, 81237, 81235, 92916, 75051, 92910, 92904, 93064, 93160, 91051, 93156, 93061, 91047, 91044, 91042, 75042, 91036, 93059, 93152, 93055, 76356, 91034, 91032, 93119, 85218, 93045, 93122, 85215, 85213, 92712, 86700, 89888, 89769, 87027, 92485, 89767, 89765, 91757, 90946, 89763, 89761, 92482, 90934, 90012, 90914, 90006, 90908, 90905, 90903, 90901, 91754, 91752, 91750, 91748, 90897, 91785, 90895, 91775, 89992, 91746, 90889, 89836, 91742, 89988, 91739, 89833, 91685, 89984, 7970, 91683, 89820, 91680, 90885, 91674, 90883, 89969, 89963, 89961, 91651, 89958, 89954, 89399, 89397, 88664, 90866, 89926, 89922, 90857, 90855, 89913, 90853, 89732, 89797, 89882, 89685, 88656, 89179, 89388, 89515, 86508, 89204, 88649, 88646, 89170, 88644, 88720, 88945, 88788, 88942, 88713, 88631, 88786, 88621, 88707, 88615, 88695, 88602, 88600, 84499, 88598, 88228, 88150, 87949, 87897, 79271, 87915, 87944, 87730, 87887, 87728, 87235, 86394, 87787, 76343, 87362, 87216, 85191, 85190, 85188, 86696, 86839, 86908, 86737, 86735, 86655, 86033, 86421, 84666, 86344, 86218, 79931, 79929, 79927, 79925, 79923, 86213, 20176, 85098, 85666, 69010, 85659, 69008, 86161, 73706, 86144, 85656, 86159, 85648, 85715, 85462, 84981, 84845, 81813, 84889, 84655, 84651, 71344, 84219, 84110, 84109, 84227, 84225, 84216, 84107, 83641, 84221, 84210, 84119, 81834, 83584, 82381, 83074, 83072, 80925, 83070, 83014, 82374, 82954, 82541, 82900, 24071, 82449, 82748, 80921, 82232, 81934, 81775, 81865, 81503, 81218, 81565, 81538, 81427, 81189, 81186, 81342, 81105, 80913, 80910, 80743, 80716, 80698, 80707, 80696, 80341, 80211, 80200, 80307, 80301, 50846, 80074, 80072, 79491, 80148, 80146, 79965, 80144, 79488, 79594, 80071, 79959, 79659, 79652, 79690, 79687, 79685, 79550, 79617, 79589, 79240, 79587, 79584, 79575, 79478, 79508, 78946, 79453, 79436, 78943, 78941, 79348, 78939, 78937, 79243, 79237, 78636, 78966, 79107, 78830, 74991, 77607, 78958, 76087, 78735, 78726, 78733, 78502, 18127, 78492, 78404, 18120, 78027, 78402, 18117, 78407, 78382, 78106, 78008, 77743, 74767, 77685, 77517, 77677, 76665, 77569, 77514, 77419, 76596, 75993, 75971, 75839, 74459, 74195, 74301, 66196, 74033, 69637, 74068, 73967, 73928, 73847, 73832, 73263, 73542, 73091, 73796, 69633, 73670, 73361, 73668, 73453, 69624, 73515, 73254, 73387, 73333, 69623, 72873, 63173, 73100, 73070, 73062, 72956, 72950, 64387, 72339, 72480, 72575, 72549, 72476, 72467, 72472, 72277, 72460, 72390, 72408, 72418, 72406, 72316, 72365, 72319, 72080, 69621, 24011, 71443, 71814, 71441, 69619, 69524, 72283, 71647, 71086, 71689, 71084, 71537, 71528, 48323, 71801, 71644, 72166, 72200, 72164, 71764, 71634, 71965, 71929, 71874, 71872, 71870, 71868, 71866, 71863, 71861, 71858, 71848, 71780, 68575, 68572, 68571, 68567, 68563, 68561, 64314, 68559, 68556, 71573, 71672, 71627, 71570, 70220, 66617, 71567, 71510, 71563, 68210, 71525, 71560, 71559, 71523, 71521, 70027, 70215, 66604, 70025, 66602, 66600, 71485, 71077, 69036, 66598, 71483, 70022, 69102, 70213, 69100, 69034, 70211, 71423, 69488, 70020, 70886, 71420, 71378, 71287, 71383, 71381, 71361, 71340, 71359, 70978, 71125, 71122, 69618, 71008, 66584, 70955, 70196, 70904, 70194, 53113, 70792, 70441, 66580, 70438, 70714, 70433, 70644, 70642, 69974, 70640, 70697, 70638, 69827, 70695, 70636, 70631, 69822, 65952, 70629, 69818, 70648, 70621, 69617, 70408, 70478, 70404, 69613, 70475, 70473, 70398, 70395, 70470, 70454, 70418, 70372, 70387, 69086, 59613, 70304, 70301, 59611, 70251, 70164, 69486, 70160, 69612, 70278, 70237, 70071, 70235, 70233, 70154, 70230, 69925, 69697, 70121, 70119, 70093, 70091, 70067, 70087, 70064, 70062, 70058, 69609, 70056, 70054, 70052, 69935, 69911, 69608, 69606, 69333, 66039, 69798, 69604, 69603, 69722, 66035, 64655, 69794, 69720, 69543, 64650, 64647, 69717, 69448, 69837, 69835, 67687, 69703, 69701, 69569, 68346, 69533, 69469, 69409, 67573, 69325, 61814, 69223, 69073, 69071, 69393, 69399, 69379, 69220, 69367, 69365, 69321, 69276, 69304, 69205, 69183, 68843, 69179, 68841, 69176, 69172, 68973, 67389, 68839, 68971, 69169, 69160, 69127, 69058, 68904, 68685, 59607, 68900, 59101, 68597, 68823, 59604, 68818, 58771, 68881, 68895, 64967, 68680, 68813, 68878, 68678, 68804, 68802, 68674, 68671, 68668, 68666, 68663, 68731, 66451, 68191, 68661, 65308, 68630, 68628, 68587, 68524, 18062, 68486, 68444, 68483, 68373, 68478, 68322, 68456, 68440, 68352, 67987, 66682, 18059, 67985, 67060, 67968, 67992, 68011, 67718, 66406, 67296, 66400, 67830, 67733, 67620, 67618, 64809, 65678, 67612, 66480, 23939, 67522, 67445, 67517, 57224, 67339, 67336, 67332, 67435, 67461, 67326, 67459, 66474, 67457, 67323, 65673, 45866, 67216, 67220, 45857, 67208, 67157, 45850, 67155, 67089, 67135, 67058, 65668, 67176, 67056, 67054, 45846, 67042, 66468, 66466, 66379, 66716, 66463, 66691, 66649, 66007, 64586, 66106, 64574, 60841, 45840, 65643, 65301, 65786, 63477, 63476, 65585, 63986, 64289, 65582, 65358, 65072, 63984, 55931, 65068, 65210, 65205, 64016, 64448, 64972, 63970, 64443, 63967, 63089, 63965, 64439, 63262, 63915, 59584, 61941, 60269, 54574, 59537, 60645, 60643, 54736, 60508, 60328, 60454, 60532, 23862, 60326, 60323, 58252, 60210, 59434, 60056, 60040, 59329, 59996, 59978, 58713, 59933, 58041, 59531, 58736, 59408, 58239, 59321, 58314, 58068, 58312, 58013, 58057, 58009, 57909, 57445, 57443, 51226, 57663, 49966, 49964, 57548, 57565, 57423, 57166, 8697, 57412, 49962, 57164, 49959, 57383, 57410, 57470, 56195, 50987, 57304, 57334, 57279, 56812, 56886, 56860, 56772, 56751, 56746, 53460, 53457, 54202, 56741, 51941, 53835, 56265, 56319, 56318, 56130, 55604, 25344, 55602, 55030, 56175, 55028, 56117, 56115, 55025, 55871, 56009, 44293, 55759, 55918, 55916, 55914, 42881, 55965, 56014, 56023, 55859, 55756, 55844, 42879, 55784, 55765, 54517, 55647, 50816, 25342, 39668, 39666, 44274, 39662, 55009, 55007, 55614, 55005, 55003, 50807, 55001, 54999, 50802, 55590, 49644, 55577, 55549, 54996, 49642, 54993, 54990, 50799, 55547, 55541, 54704, 50797, 25340, 25337, 55286, 45508, 55455, 54381, 25336, 53211, 54377, 55307, 55305, 55288, 54961, 54941, 54568, 54939, 25334, 53834, 54893, 25332, 53832, 50881, 53724, 54682, 51497, 54554, 54540, 54525, 54274, 53049, 52720, 52718, 49993, 52716, 52714, 49991, 52712, 52710, 54403, 54193, 53830, 53070, 54021, 53063, 53058, 53562, 53762, 53829, 41156, 53138, 53048, 53096, 53046, 53131, 52796, 52794, 53001, 52792, 50649, 52997, 52706, 52529, 37124, 49166, 49162, 49989, 49609, 49385, 49384, 49276, 49373, 49289, 47592, 49317, 49143, 49262, 34884, 49125, 49119, 48573, 34873, 49007, 48571, 49082, 48597, 39647, 49026, 49074, 49067, 49041, 49017, 42939, 48909, 46532, 25320, 44583, 25316, 48831, 48709, 25310, 48755, 48715, 25306, 43610, 48536, 48459, 17308, 48457, 44777, 48450, 38491, 25300, 38483, 47340, 47417, 38479, 47447, 47605, 45598, 9598, 47409, 46943, 41902, 25299, 46999, 46902, 46984, 25295, 25293, 25291, 25289, 46436, 43988, 45776, 46653, 39591, 25286, 43983, 43981, 44262, 43979, 43977, 43975, 44760, 45018, 45013, 44401, 43624, 44184, 44063, 43964, 43902, 43159, 43683, 43525, 43663, 43066, 42832, 3020, 42828, 3017, 3014, 33348, 40744, 41900, 36444, 42167, 40848, 36441, 36439, 41779, 41448, 41897, 41895, 41894, 41446, 41892, 35176, 39278, 41767, 39276, 41470, 25283, 20840, 40268, 40304, 40263, 20830, 36584, 40066, 28482, 36582, 36577, 36574, 36571, 36431, 39065, 36423, 33886, 38941, 38952, 39021, 36416, 36410, 38944, 36408, 38937, 38815, 35707, 38843, 38589, 24512, 38008, 38097, 24455, 38092, 38082, 30622, 37816, 27355, 33762, 33761, 37692, 37432, 37557, 37549, 33757, 37087, 37539, 37415, 30619, 37427, 36638, 37326, 34436, 34939, 37197, 34329, 31167, 36145, 37112, 36327, 36499, 36614, 30098, 35521, 35724, 34954, 33840, 25468, 35416, 35382, 35458, 35069, 34855, 25462, 34809, 34801, 33035, 34350, 34391, 34471, 34429, 33376, 33972, 34318, 34416, 34336, 27449, 31874, 34068, 34380, 32871, 29726, 32884, 31430, 15271, 31281, 30549, 8652, 614, 25910, 25257, 25686, 18691, 31100, 31679, 31098, 13668, 22879, 22182, 25771, 23637, 30615, 30609, 26899, 3990, 11818, 17260, 26374, 28850, 3001, 13392, 1094, 25112, 2994, 15256, 8647, 22178))
Run Time: 0.092207
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2062 | |
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 | | | | | 2062 | |
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 (11158, 10790, 9647, 9354, 9242, 8725, 8688, 8616, 8500, 8437, 8326, 8273, 8213, 7735, 7030, 6922, 6384, 6362, 6158, 6156, 6121, 6073, 5963, 5123, 5108, 4923, 4853, 4775, 4774, 4739, 4472, 4470, 4445, 4418, 4399, 4073, 3943, 3897, 3889, 3888, 3886, 3529, 3471, 3346, 3301, 3285, 3212, 3208, 3071, 2980, 2960, 2885))
Run Time: 0.002998
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 52 | 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 (273107, 273064, 270993, 268764, 270492, 250003, 266434, 266431, 266430, 266747, 266745, 266743, 266721, 266617, 261496, 264716, 83187, 263552, 261511, 258751, 261507, 261504, 261502, 259775, 261644, 261593, 261590, 261426, 261421, 260952, 259965, 142951, 248987, 142949, 259089, 258946, 258460, 202675, 258722, 258458, 258717, 256401, 250339, 253507, 250503, 249937, 250414, 247366, 222656, 206573, 204769, 204834, 204813, 204035, 204130, 204095, 204093, 202821, 201377, 202905, 185819, 194134, 194013, 193845, 187120, 190728, 182161, 189800, 189850, 189812, 182155, 160129, 160127, 189512, 187838, 185807, 183998, 187328, 187646, 187307, 187306, 187304, 187303, 187378, 187301, 139305, 187282, 187298, 187296, 187295, 187224, 187293, 187221, 186897, 187103, 187191, 187095, 186023, 185524, 185700, 185512, 172812, 185392, 185084, 185024, 184761, 183978, 184779, 144486, 184325, 160645, 160642, 184335, 183974, 184230, 184009, 183566, 183715, 183971, 173944, 182300, 174859, 183549, 181991, 183381, 181217, 181215, 181213, 160099, 182126, 181975, 174839, 175134, 174659, 175485, 174829, 175591, 172786, 173519, 164439, 164436, 173517, 172554, 172485, 172766, 172559, 171968, 172177, 171206, 171271, 171352, 85556, 171238, 85554, 157279, 165730, 169136, 167972, 167971, 113928, 162337, 162336, 168692, 168659, 168568, 162334, 162330, 162329, 162327, 168454, 168165, 168451, 168486, 168449, 168525, 168151, 166428, 166424, 167953, 123680, 167589, 166787, 123678, 167017, 166644, 166546, 165883, 166026, 164685, 165034, 164039, 164653, 136384, 161050, 161048, 161045, 152160, 161009, 158524, 158522, 159716, 155496, 158510, 158508, 158507, 159533, 158497, 156496, 151261, 154262, 158194, 158191, 154260, 151133, 157996, 157754, 149359, 157586, 157651, 157550, 157653, 156376, 155675, 155156, 155096, 153332, 153276, 153185, 153184, 153240, 153274, 144411, 152921, 152781, 152610, 151890, 152062, 151148, 149901, 150550, 148883, 148877, 148873, 149894, 149891, 149889, 150107, 149886, 119934, 150105, 150098, 119931, 119929, 149971, 119927, 149849, 147461, 149801, 147958, 145942, 145940, 145930, 119849, 119847, 119845, 145902, 146641, 146729, 146737, 146735, 145863, 145495, 146450, 145493, 143846, 143843, 143841, 143839, 145412, 144999, 144995, 144885, 144879, 144224, 139581, 142423, 141635, 141992, 119724, 136581, 142114, 136578, 139012, 119721, 136560, 136554, 136552, 136550, 136548, 136545, 136543, 136540, 129776, 141807, 140545, 141805, 138978, 138976, 135813, 141620, 140370, 141276, 140450, 138855, 140442, 137963, 138479, 140250, 127663, 119663, 119646, 140119, 138282, 137554, 137361, 137550, 137546, 136074, 126898, 137713, 126896, 137562, 137501, 137499, 135111, 130031, 135063, 135058, 135056, 135086, 135050, 134968, 134990, 135026, 134689, 134687, 133844, 129490, 133840, 133686, 130052, 133362, 130345, 127611, 130010, 119537, 129680, 129712, 129748, 129338, 129336, 129594, 129333, 129329, 129328, 119495, 119493, 128569, 126817, 129241, 128557, 129111, 128445, 128056, 127489, 124366, 127085, 126790, 126776, 125501, 127083, 126942, 126864, 126861, 126922, 84383, 113149, 126934, 113147, 113145, 125660, 123297, 119395, 119387, 114523, 119385, 125398, 124476, 119351, 120387, 124550, 122936, 124033, 124031, 124179, 124345, 124343, 123922, 124136, 123610, 123271, 123742, 123685, 82337, 123557, 123555, 123538, 123533, 119261, 122931, 123370, 122968, 122951, 122729, 85698, 122925, 121516, 121514, 121512, 121638, 122211, 97298, 119130, 119124, 121130, 121051, 120982, 120086, 118854, 120287, 118809, 118215, 118121, 116602, 118210, 116600, 118194, 118108, 118192, 118191, 118185, 118184, 118182, 118180, 118241, 116599, 116597, 116594, 116590, 116588, 116587, 116739, 117079, 113733, 113723, 116766, 116399, 116619, 116650, 116648, 116585, 113709, 113706, 113704, 114713, 116173, 113696, 114711, 113694, 116293, 116290, 116180, 89132, 116167, 115814, 115621, 115810, 115893, 115806, 97081, 116120, 115799, 115927, 114428, 114426, 114545, 114423, 114412, 114393, 114392, 114409, 114388, 114407, 109490, 114386, 114383, 114380, 114378, 114376, 109481, 72119, 98592, 102913, 100404, 113970, 113612, 113610, 113608, 113395, 113337, 113140, 92275, 113333, 113301, 113138, 111952, 113208, 113115, 113103, 113081, 113044, 113027, 112906, 112904, 111647, 112886, 111203, 111200, 112712, 112857, 93726, 111506, 72102, 112435, 96305, 112417, 112383, 110822, 110820, 112414, 112442, 112188, 112336, 112334, 112183, 102478, 109425, 102476, 112016, 102474, 101439, 109503, 100923, 109422, 112133, 102467, 110907, 109420, 100919, 102463, 102459, 97737, 111873, 111858, 111407, 111784, 111405, 111756, 100344, 111445, 111403, 111342, 109396, 101202, 98982, 103310, 103308, 110810, 109365, 109495, 110857, 110854, 103340, 103345, 102897, 103255, 102895, 103336, 102893, 103251, 103230, 103050, 103116, 103099, 102792, 102515, 102513, 102928, 102783, 102781, 102780, 98622, 102777, 102528, 102445, 102181, 91625, 101631, 102359, 101628, 102316, 102114, 102055, 102112, 101976, 101973, 102168, 102000, 102018, 102016, 102085, 102014, 101958, 102012, 101954, 101115, 101949, 101566, 101564, 101562, 101558, 101556, 101725, 96050, 101687, 96048, 101803, 101788, 101758, 101721, 101531, 101700, 101697, 100385, 101673, 101101, 101097, 101095, 101484, 101483, 101507, 101092, 101088, 101505, 101514, 101476, 101083, 101502, 101474, 101512, 101394, 101392, 101072, 101351, 101315, 101246, 101026, 100936, 82565, 100529, 101224, 100527, 101020, 100816, 100814, 99874, 100812, 101222, 101014, 101001, 100998, 100995, 100993, 100990, 100988, 101183, 100985, 100925, 100860, 100802, 100777, 100857, 100699, 100593, 100079, 100795, 100774, 100572, 100367, 67786, 67782, 100160, 67771, 100048, 100047, 99656, 100043, 85487, 99910, 100040, 98319, 98318, 98312, 97966, 98565, 98550, 91336, 99564, 98548, 99391, 97713, 97712, 99399, 99362, 99397, 99358, 99355, 99351, 99339, 99093, 98949, 99333, 99331, 98166, 99279, 99269, 99266, 99260, 99251, 99236, 79834, 99205, 99193, 99185, 99179, 99164, 99161, 99157, 99091, 99153, 96023, 98400, 98995, 97100, 96876, 97811, 98358, 98354, 98348, 97293, 97877, 98237, 90788, 97875, 98286, 90786, 97873, 90758, 98043, 98041, 98039, 90750, 90743, 98139, 90741, 98094, 90738, 90736, 90733, 98063, 90706, 98061, 90704, 95941, 98036, 96207, 97065, 24133, 97057, 96283, 96282, 96277, 96983, 88958, 97007, 96981, 96650, 96647, 88954, 88953, 96313, 96300, 96310, 95781, 96187, 96184, 95779, 95931, 95928, 95777, 95922, 95775, 95761, 90518, 95759, 90516, 95757, 95754, 95773, 95911, 95908, 90456, 95533, 95146, 95111, 95206, 95161, 95250, 95096, 95048, 94325, 94323, 95037, 94118, 94115, 94109, 89316, 94596, 93822, 93820, 94594, 94095, 94592, 94092, 36733, 94218, 94064, 94026, 90237, 93757, 93709, 93954, 93752, 93907, 93905, 93504, 93082, 93662, 93526, 92966, 93497, 85222, 91106, 84672, 91104, 93524, 93569, 93482, 93467, 81242, 93432, 87293, 85220, 83975, 83973, 91089, 83971, 89890, 93361, 89124, 93380, 90170, 90168, 90161, 92960, 93359, 93365, 93262, 93235, 91074, 90155, 92849, 92928, 91062, 92926, 91058, 92922, 81239, 81237, 81235, 92916, 75051, 92910, 92904, 93064, 93160, 91051, 93156, 93061, 91047, 91044, 91042, 75042, 91036, 93059, 93152, 93055, 76356, 91034, 91032, 93119, 85218, 93045, 93122, 85215, 85213, 92712, 86700, 89888, 89769, 87027, 92485, 89767, 89765, 91757, 90946, 89763, 89761, 92482, 90934, 90012, 90914, 90006, 90908, 90905, 90903, 90901, 91754, 91752, 91750, 91748, 90897, 91785, 90895, 91775, 89992, 91746, 90889, 89836, 91742, 89988, 91739, 89833, 91685, 89984, 7970, 91683, 89820, 91680, 90885, 91674, 90883, 89969, 89963, 89961, 91651, 89958, 89954, 89399, 89397, 88664, 90866, 89926, 89922, 90857, 90855, 89913, 90853, 89732, 89797, 89882, 89685, 88656, 89179, 89388, 89515, 86508, 89204, 88649, 88646, 89170, 88644, 88720, 88945, 88788, 88942, 88713, 88631, 88786, 88621, 88707, 88615, 88695, 88602, 88600, 84499, 88598, 88228, 88150, 87949, 87897, 79271, 87915, 87944, 87730, 87887, 87728, 87235, 86394, 87787, 76343, 87362, 87216, 85191, 85190, 85188, 86696, 86839, 86908, 86737, 86735, 86655, 86033, 86421, 84666, 86344, 86218, 79931, 79929, 79927, 79925, 79923, 86213, 20176, 85098, 85666, 69010, 85659, 69008, 86161, 73706, 86144, 85656, 86159, 85648, 85715, 85462, 84981, 84845, 81813, 84889, 84655, 84651, 71344, 84219, 84110, 84109, 84227, 84225, 84216, 84107, 83641, 84221, 84210, 84119, 81834, 83584, 82381, 83074, 83072, 80925, 83070, 83014, 82374, 82954, 82541, 82900, 24071, 82449, 82748, 80921, 82232, 81934, 81775, 81865, 81503, 81218, 81565, 81538, 81427, 81189, 81186, 81342, 81105, 80913, 80910, 80743, 80716, 80698, 80707, 80696, 80341, 80211, 80200, 80307, 80301, 50846, 80074, 80072, 79491, 80148, 80146, 79965, 80144, 79488, 79594, 80071, 79959, 79659, 79652, 79690, 79687, 79685, 79550, 79617, 79589, 79240, 79587, 79584, 79575, 79478, 79508, 78946, 79453, 79436, 78943, 78941, 79348, 78939, 78937, 79243, 79237, 78636, 78966, 79107, 78830, 74991, 77607, 78958, 76087, 78735, 78726, 78733, 78502, 18127, 78492, 78404, 18120, 78027, 78402, 18117, 78407, 78382, 78106, 78008, 77743, 74767, 77685, 77517, 77677, 76665, 77569, 77514, 77419, 76596, 75993, 75971, 75839, 74459, 74195, 74301, 66196, 74033, 69637, 74068, 73967, 73928, 73847, 73832, 73263, 73542, 73091, 73796, 69633, 73670, 73361, 73668, 73453, 69624, 73515, 73254, 73387, 73333, 69623, 72873, 63173, 73100, 73070, 73062, 72956, 72950, 64387, 72339, 72480, 72575, 72549, 72476, 72467, 72472, 72277, 72460, 72390, 72408, 72418, 72406, 72316, 72365, 72319, 72080, 69621, 24011, 71443, 71814, 71441, 69619, 69524, 72283, 71647, 71086, 71689, 71084, 71537, 71528, 48323, 71801, 71644, 72166, 72200, 72164, 71764, 71634, 71965, 71929, 71874, 71872, 71870, 71868, 71866, 71863, 71861, 71858, 71848, 71780, 68575, 68572, 68571, 68567, 68563, 68561, 64314, 68559, 68556, 71573, 71672, 71627, 71570, 70220, 66617, 71567, 71510, 71563, 68210, 71525, 71560, 71559, 71523, 71521, 70027, 70215, 66604, 70025, 66602, 66600, 71485, 71077, 69036, 66598, 71483, 70022, 69102, 70213, 69100, 69034, 70211, 71423, 69488, 70020, 70886, 71420, 71378, 71287, 71383, 71381, 71361, 71340, 71359, 70978, 71125, 71122, 69618, 71008, 66584, 70955, 70196, 70904, 70194, 53113, 70792, 70441, 66580, 70438, 70714, 70433, 70644, 70642, 69974, 70640, 70697, 70638, 69827, 70695, 70636, 70631, 69822, 65952, 70629, 69818, 70648, 70621, 69617, 70408, 70478, 70404, 69613, 70475, 70473, 70398, 70395, 70470, 70454, 70418, 70372, 70387, 69086, 59613, 70304, 70301, 59611, 70251, 70164, 69486, 70160, 69612, 70278, 70237, 70071, 70235, 70233, 70154, 70230, 69925, 69697, 70121, 70119, 70093, 70091, 70067, 70087, 70064, 70062, 70058, 69609, 70056, 70054, 70052, 69935, 69911, 69608, 69606, 69333, 66039, 69798, 69604, 69603, 69722, 66035, 64655, 69794, 69720, 69543, 64650, 64647, 69717, 69448, 69837, 69835, 67687, 69703, 69701, 69569, 68346, 69533, 69469, 69409, 67573, 69325, 61814, 69223, 69073, 69071, 69393, 69399, 69379, 69220, 69367, 69365, 69321, 69276, 69304, 69205, 69183, 68843, 69179, 68841, 69176, 69172, 68973, 67389, 68839, 68971, 69169, 69160, 69127, 69058, 68904, 68685, 59607, 68900, 59101, 68597, 68823, 59604, 68818, 58771, 68881, 68895, 64967, 68680, 68813, 68878, 68678, 68804, 68802, 68674, 68671, 68668, 68666, 68663, 68731, 66451, 68191, 68661, 65308, 68630, 68628, 68587, 68524, 18062, 68486, 68444, 68483, 68373, 68478, 68322, 68456, 68440, 68352, 67987, 66682, 18059, 67985, 67060, 67968, 67992, 68011, 67718, 66406, 67296, 66400, 67830, 67733, 67620, 67618, 64809, 65678, 67612, 66480, 23939, 67522, 67445, 67517, 57224, 67339, 67336, 67332, 67435, 67461, 67326, 67459, 66474, 67457, 67323, 65673, 45866, 67216, 67220, 45857, 67208, 67157, 45850, 67155, 67089, 67135, 67058, 65668, 67176, 67056, 67054, 45846, 67042, 66468, 66466, 66379, 66716, 66463, 66691, 66649, 66007, 64586, 66106, 64574, 60841, 45840, 65643, 65301, 65786, 63477, 63476, 65585, 63986, 64289, 65582, 65358, 65072, 63984, 55931, 65068, 65210, 65205, 64016, 64448, 64972, 63970, 64443, 63967, 63089, 63965, 64439, 63262, 63915, 59584, 61941, 60269, 54574, 59537, 60645, 60643, 54736, 60508, 60328, 60454, 60532, 23862, 60326, 60323, 58252, 60210, 59434, 60056, 60040, 59329, 59996, 59978, 58713, 59933, 58041, 59531, 58736, 59408, 58239, 59321, 58314, 58068, 58312, 58013, 58057, 58009, 57909, 57445, 57443, 51226, 57663, 49966, 49964, 57548, 57565, 57423, 57166, 8697, 57412, 49962, 57164, 49959, 57383, 57410, 57470, 56195, 50987, 57304, 57334, 57279, 56812, 56886, 56860, 56772, 56751, 56746, 53460, 53457, 54202, 56741, 51941, 53835, 56265, 56319, 56318, 56130, 55604, 25344, 55602, 55030, 56175, 55028, 56117, 56115, 55025, 55871, 56009, 44293, 55759, 55918, 55916, 55914, 42881, 55965, 56014, 56023, 55859, 55756, 55844, 42879, 55784, 55765, 54517, 55647, 50816, 25342, 39668, 39666, 44274, 39662, 55009, 55007, 55614, 55005, 55003, 50807, 55001, 54999, 50802, 55590, 49644, 55577, 55549, 54996, 49642, 54993, 54990, 50799, 55547, 55541, 54704, 50797, 25340, 25337, 55286, 45508, 55455, 54381, 25336, 53211, 54377, 55307, 55305, 55288, 54961, 54941, 54568, 54939, 25334, 53834, 54893, 25332, 53832, 50881, 53724, 54682, 51497, 54554, 54540, 54525, 54274, 53049, 52720, 52718, 49993, 52716, 52714, 49991, 52712, 52710, 54403, 54193, 53830, 53070, 54021, 53063, 53058, 53562, 53762, 53829, 41156, 53138, 53048, 53096, 53046, 53131, 52796, 52794, 53001, 52792, 50649, 52997, 52706, 52529, 37124, 49166, 49162, 49989, 49609, 49385, 49384, 49276, 49373, 49289, 47592, 49317, 49143, 49262, 34884, 49125, 49119, 48573, 34873, 49007, 48571, 49082, 48597, 39647, 49026, 49074, 49067, 49041, 49017, 42939, 48909, 46532, 25320, 44583, 25316, 48831, 48709, 25310, 48755, 48715, 25306, 43610, 48536, 48459, 17308, 48457, 44777, 48450, 38491, 25300, 38483, 47340, 47417, 38479, 47447, 47605, 45598, 9598, 47409, 46943, 41902, 25299, 46999, 46902, 46984, 25295, 25293, 25291, 25289, 46436, 43988, 45776, 46653, 39591, 25286, 43983, 43981, 44262, 43979, 43977, 43975, 44760, 45018, 45013, 44401, 43624, 44184, 44063, 43964, 43902, 43159, 43683, 43525, 43663, 43066, 42832, 3020, 42828, 3017, 3014, 33348, 40744, 41900, 36444, 42167, 40848, 36441, 36439, 41779, 41448, 41897, 41895, 41894, 41446, 41892, 35176, 39278, 41767, 39276, 41470, 25283, 20840, 40268, 40304, 40263, 20830, 36584, 40066, 28482, 36582, 36577, 36574, 36571, 36431, 39065, 36423, 33886, 38941, 38952, 39021, 36416, 36410, 38944, 36408, 38937, 38815, 35707, 38843, 38589, 24512, 38008, 38097, 24455, 38092, 38082, 30622, 37816, 27355, 33762, 33761, 37692, 37432, 37557, 37549, 33757, 37087, 37539, 37415, 30619, 37427, 36638, 37326, 34436, 34939, 37197, 34329, 31167, 36145, 37112, 36327, 36499, 36614, 30098, 35521, 35724, 34954, 33840, 25468, 35416, 35382, 35458, 35069, 34855, 25462, 34809, 34801, 33035, 34350, 34391, 34471, 34429, 33376, 33972, 34318, 34416, 34336, 27449, 31874, 34068, 34380, 32871, 29726, 32884, 31430, 15271, 31281, 30549, 8652, 614, 25910, 25257, 25686, 18691, 31100, 31679, 31098, 13668, 22879, 22182, 25771, 23637, 30615, 30609, 26899, 3990, 11818, 17260, 26374, 28850, 3001, 13392, 1094, 25112, 2994, 15256, 8647, 22178))
Run Time: 0.040165
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2062 | |
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 | | | | | 2062 | |
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 (11158, 10790, 9647, 9354, 9242, 8725, 8688, 8616, 8500, 8437, 8326, 8273, 8213, 7735, 7030, 6922, 6384, 6362, 6158, 6156, 6121, 6073, 5963, 5123, 5108, 4923, 4853, 4775, 4774, 4739, 4472, 4470, 4445, 4418, 4399, 4073, 3943, 3897, 3889, 3888, 3886, 3529, 3471, 3346, 3301, 3285, 3212, 3208, 3071, 2980, 2960, 2885))
Run Time: 0.001851
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 52 | 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, �3�
Run Time: 0.000231
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000370
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.000502
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: 1716178083
Run Time: 0.000266
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 9 | 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` >= 1716178083)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000402
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 9 | 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