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.000663
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.000214
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` = '1596')
LIMIT 1
Run Time: 0.000457
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.001800
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_1596' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.056024
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 (160160, 269582, 257956, 257954, 260958, 113977, 207251, 254725, 261000, 260464, 260460, 260458, 259658, 260956, 258733, 258106, 258215, 258101, 257941, 258209, 258093, 258088, 258170, 258203, 258086, 258085, 257937, 258079, 258165, 258164, 258077, 258075, 258072, 258161, 258159, 257775, 256964, 256958, 191120, 256940, 256943, 256961, 249502, 255408, 250367, 142938, 250365, 250364, 250346, 250345, 250343, 255800, 255798, 250340, 255796, 255794, 255788, 250336, 171362, 251007, 252956, 250313, 250309, 250307, 253222, 250301, 253336, 253335, 253334, 253276, 253331, 250295, 250278, 250270, 250269, 250268, 250249, 250246, 250244, 250224, 251020, 251018, 251016, 251012, 250731, 250729, 250726, 250058, 250721, 250719, 247948, 248927, 248925, 248918, 248916, 248913, 248906, 248898, 248895, 248769, 248763, 248716, 247852, 248287, 248285, 248281, 247843, 247841, 142932, 247831, 248279, 247829, 248111, 247827, 248118, 248116, 142922, 247895, 204179, 247892, 247891, 247920, 247967, 247889, 247953, 247960, 247945, 247884, 247724, 247899, 247881, 247815, 247812, 222678, 172008, 142902, 142900, 247300, 222653, 222632, 222307, 222306, 222236, 222279, 208482, 222262, 222112, 222101, 222062, 222098, 222081, 222060, 222057, 208355, 208309, 208386, 208263, 208260, 172000, 208198, 208197, 163596, 163592, 208025, 207464, 208022, 208097, 208096, 207945, 207899, 207707, 207698, 207865, 207616, 207421, 207065, 207087, 207103, 194846, 207083, 201471, 207205, 142855, 193752, 206929, 194839, 204820, 206924, 202975, 207100, 207092, 206936, 206922, 193188, 207074, 207073, 206893, 204749, 202423, 206767, 181644, 190366, 127051, 127048, 204772, 203787, 194959, 194957, 204840, 204837, 16541, 202817, 16538, 203840, 186020, 201919, 204195, 204592, 203901, 203778, 203895, 203760, 204028, 203868, 203449, 203448, 203447, 203445, 203288, 203287, 203527, 203522, 203284, 203280, 203406, 203405, 202042, 202761, 202786, 202784, 167084, 202779, 201850, 202777, 202233, 184766, 202231, 202229, 202740, 201848, 202341, 202428, 129870, 201374, 190010, 201912, 201369, 201829, 201365, 201363, 194945, 201540, 201360, 201735, 191369, 201464, 201354, 195348, 201351, 201349, 195068, 193745, 195345, 195344, 195065, 193742, 193737, 193735, 193731, 193726, 193714, 193704, 185244, 194022, 194554, 194552, 194544, 194542, 193698, 190000, 193692, 193688, 194019, 193686, 193667, 193629, 184749, 184744, 191462, 190615, 184741, 127697, 192787, 192786, 193068, 184086, 165391, 184085, 127693, 192875, 192785, 192896, 192741, 192916, 192783, 192781, 185492, 142824, 142821, 192603, 192734, 142819, 191355, 192236, 192143, 192601, 192600, 192728, 165387, 192598, 142815, 192517, 165383, 192577, 192561, 192505, 192535, 192530, 191861, 190750, 190324, 190744, 190587, 190583, 190582, 190078, 190355, 184070, 189920, 190307, 190350, 188295, 182588, 190140, 189852, 172497, 188292, 190070, 189990, 189925, 184056, 189988, 188288, 189985, 189977, 188286, 189967, 189974, 189913, 189912, 189713, 189802, 189849, 167027, 189846, 144162, 144161, 144158, 144155, 144153, 144152, 144151, 189653, 155231, 189511, 187658, 188282, 188276, 188274, 188273, 187700, 187860, 187857, 187854, 182649, 187233, 182633, 187242, 144528, 187271, 187267, 187266, 187264, 187317, 187259, 187194, 187192, 187189, 182623, 182621, 187184, 187168, 182620, 182618, 187064, 182615, 186956, 186955, 182613, 187091, 187140, 185457, 186939, 187138, 144523, 182609, 182607, 182606, 182601, 185950, 185442, 185472, 184876, 149452, 184122, 149449, 185198, 144518, 185064, 185390, 185025, 184239, 185192, 144514, 185189, 185187, 185023, 144508, 144505, 144504, 144501, 144499, 185015, 185034, 120049, 136930, 184782, 171994, 120047, 184871, 184006, 183659, 184205, 144479, 144478, 182131, 183329, 184108, 182389, 184106, 144472, 144469, 182289, 144467, 161627, 182079, 161625, 161623, 182074, 182661, 174889, 160120, 174868, 183651, 144466, 144465, 144463, 183466, 182584, 182577, 182575, 182574, 172945, 175580, 182564, 182808, 183304, 182557, 183104, 181640, 182553, 182061, 182060, 182056, 182053, 181555, 182551, 173900, 172942, 181553, 182548, 181785, 172940, 181634, 181715, 175529, 144439, 173557, 173555, 172938, 181223, 181221, 181209, 175506, 181083, 174837, 174836, 174835, 181081, 174960, 144431, 175477, 144428, 162746, 174940, 174939, 174769, 174922, 173795, 165340, 173053, 157967, 171984, 173922, 173918, 173551, 173549, 171979, 171975, 173710, 173838, 173824, 173822, 173821, 173788, 144422, 144421, 172623, 173691, 173518, 164434, 173515, 157965, 170568, 157960, 173527, 141540, 171058, 141537, 173512, 141533, 173363, 173525, 141528, 173068, 173359, 173357, 142802, 173038, 172822, 172217, 172518, 172465, 147984, 172146, 172142, 171055, 157956, 172478, 171965, 172138, 166813, 165334, 172136, 172134, 172347, 172132, 171046, 171042, 171041, 172181, 172128, 172119, 171460, 172115, 169807, 169806, 169805, 144416, 161423, 162209, 162207, 3037, 169646, 162205, 172062, 171961, 171145, 171136, 171132, 171122, 171402, 170654, 170651, 171067, 170931, 96169, 170693, 169160, 170835, 170833, 170924, 170648, 170686, 170641, 170640, 170577, 170576, 59183, 167142, 59182, 167510, 170265, 168498, 169921, 170151, 169406, 162790, 136924, 136920, 136918, 168703, 168488, 96165, 168485, 167939, 167563, 167984, 167983, 167562, 167932, 167253, 164736, 166710, 166178, 165487, 164719, 166168, 166166, 164867, 166155, 164865, 165513, 164708, 165509, 165507, 164706, 164861, 164689, 165543, 164682, 120976, 165084, 164676, 164674, 165504, 163668, 165079, 165078, 164672, 164670, 164669, 164667, 164389, 164314, 164313, 163409, 163912, 161485, 161483, 161494, 161478, 159722, 159286, 158204, 157995, 158043, 157990, 157696, 93735, 156706, 156701, 154740, 154736, 154733, 151634, 154728, 154725, 154721, 154718, 154716, 155092, 155089, 154897, 154895, 154331, 154330, 154323, 154313, 152092, 152606, 147804, 147803, 152464, 152455, 150616, 150945, 152359, 152119, 151816, 151814, 151459, 151806, 151805, 149959, 151834, 151831, 151348, 151455, 151645, 116676, 147392, 147391, 151450, 150598, 147389, 150590, 150588, 150407, 150028, 150937, 149899, 143140, 150256, 150371, 149895, 150496, 150362, 150024, 149880, 149876, 149539, 149732, 149537, 149536, 149747, 149562, 149558, 149553, 149871, 149868, 149866, 149863, 149856, 149853, 149847, 149622, 149528, 149527, 149740, 149728, 149525, 149720, 149736, 148471, 148470, 148506, 149517, 149515, 149513, 149659, 149510, 149509, 149618, 149617, 148467, 149506, 149505, 148586, 148363, 149502, 147386, 148749, 149496, 148463, 148361, 148585, 148582, 148637, 148168, 148580, 148576, 148459, 148574, 148572, 148560, 147204, 148557, 148356, 148456, 148521, 148353, 148383, 148165, 137473, 148163, 148162, 148160, 148158, 148016, 148157, 148156, 148068, 148056, 148151, 127946, 148145, 148053, 148139, 147760, 148197, 127942, 148010, 147858, 146205, 147753, 147914, 147572, 147384, 147733, 147731, 147379, 147492, 146097, 147377, 147312, 147308, 147375, 147374, 147372, 147371, 147370, 147369, 146086, 146855, 146085, 147304, 146084, 147302, 147299, 147298, 146529, 146527, 146525, 146520, 146516, 146514, 146853, 146852, 146851, 146846, 146839, 146834, 146833, 146832, 146831, 146041, 146038, 146037, 146036, 146035, 146032, 146030, 146827, 146826, 146824, 146822, 146817, 146816, 146813, 146016, 146014, 146011, 146005, 145999, 145506, 145995, 145993, 145992, 145989, 145987, 145983, 145981, 145979, 145975, 145973, 145972, 145945, 145938, 146769, 146767, 146790, 145916, 145914, 144143, 146763, 146761, 141272, 141271, 145868, 145604, 146725, 146575, 146478, 145757, 145748, 144140, 145739, 145716, 145715, 145711, 145639, 145599, 145598, 145597, 145710, 145706, 145663, 145392, 145389, 145388, 145386, 145259, 145114, 144096, 144752, 144699, 144749, 144736, 139393, 144296, 143885, 144132, 144130, 144129, 141929, 142055, 143883, 142044, 143880, 143657, 142042, 142041, 142036, 142033, 144015, 143876, 143789, 143788, 143874, 142014, 143872, 143786, 142012, 142006, 143800, 142674, 142668, 143653, 142666, 142657, 143646, 142653, 142651, 143612, 139143, 143087, 142003, 142002, 142000, 141999, 142190, 142290, 142222, 142158, 134588, 134859, 142178, 142181, 142176, 134469, 141995, 141991, 141983, 142088, 141987, 141979, 141977, 141976, 141800, 141266, 141610, 141497, 140491, 140490, 140483, 140482, 134462, 140535, 140531, 140468, 140446, 140712, 140016, 137470, 82610, 140116, 139503, 140002, 140011, 140000, 139995, 139560, 139498, 139810, 114529, 124952, 139630, 124948, 139390, 139566, 139331, 139564, 124946, 139323, 124941, 124940, 124938, 124937, 124935, 124932, 124919, 82601, 138014, 82598, 138554, 82597, 82595, 138578, 137813, 135277, 138575, 138551, 138548, 138215, 138545, 137456, 135272, 138003, 138148, 138569, 138539, 138203, 138115, 138113, 138467, 138463, 138199, 138107, 138144, 138176, 138141, 138174, 138172, 138170, 138139, 138097, 138167, 138160, 138157, 120849, 124376, 135590, 124374, 16518, 120839, 16514, 16512, 134337, 137141, 137943, 16509, 16506, 137792, 16504, 16502, 137355, 137138, 119578, 134333, 134328, 134326, 134323, 134320, 134318, 137135, 135582, 136056, 136054, 134586, 120833, 134584, 137451, 136988, 137303, 16499, 136040, 137387, 137300, 136297, 137298, 137385, 16495, 136033, 137437, 126761, 137444, 137336, 133587, 123396, 133584, 133582, 130177, 137329, 136022, 137317, 136292, 136290, 136360, 136357, 137051, 136355, 136288, 126759, 126756, 136286, 126755, 137046, 136284, 137294, 137204, 137291, 137289, 124241, 137286, 137282, 136282, 136001, 136280, 135997, 126752, 137256, 134460, 137176, 137254, 134458, 130175, 137171, 137110, 126749, 137079, 134456, 137105, 136277, 130037, 126745, 135543, 133789, 126739, 135538, 135533, 126735, 135924, 136164, 135920, 136272, 135723, 135721, 126539, 126533, 135716, 135702, 135370, 135335, 135577, 129314, 135261, 135195, 135259, 129307, 134845, 126511, 126510, 126503, 126502, 126498, 127033, 134843, 127, 134578, 135039, 129658, 134446, 125795, 135043, 127031, 127029, 127028, 135036, 134438, 134987, 134278, 129751, 134961, 134959, 134952, 126976, 134436, 133462, 89138, 134834, 134299, 129514, 134831, 123952, 134276, 134420, 133380, 134417, 129647, 134574, 134403, 126488, 126487, 129938, 126480, 134208, 134386, 133572, 126476, 133570, 134204, 126474, 133451, 129922, 133743, 133442, 126463, 133739, 126461, 133644, 126457, 133577, 126454, 133440, 133498, 130352, 130350, 133423, 133420, 114, 133418, 133395, 130152, 120826, 129908, 130197, 130292, 125772, 129802, 129904, 124850, 126430, 129896, 130187, 129645, 123652, 130181, 126427, 130165, 130160, 129884, 98131, 80541, 130134, 130058, 129881, 129880, 126425, 130132, 129166, 129875, 129873, 129800, 80539, 129826, 129798, 129164, 126719, 129795, 129792, 129344, 124910, 129248, 121560, 129341, 129700, 129691, 129710, 129367, 129161, 129159, 129334, 129157, 129331, 111226, 124906, 121558, 129259, 129287, 126818, 129236, 128715, 129153, 129151, 129149, 128705, 129210, 129147, 129145, 129143, 129112, 128696, 8009, 129138, 124904, 126416, 124897, 128553, 125678, 126415, 128425, 128343, 128526, 128529, 124895, 127934, 124894, 128153, 127928, 128404, 119464, 127926, 127923, 127922, 127916, 125764, 125756, 127910, 126410, 127908, 125752, 127902, 111977, 127900, 127898, 127895, 127893, 125749, 128147, 126399, 127792, 93733, 127888, 125743, 127872, 125740, 127527, 125739, 127502, 124889, 127415, 127492, 86568, 127270, 122636, 123304, 124879, 127374, 123763, 127372, 124874, 127266, 126380, 126379, 125576, 126371, 126796, 127172, 127136, 126618, 126598, 124865, 126698, 126613, 126941, 126939, 126771, 126770, 126050, 126605, 126603, 126602, 125988, 126352, 126350, 125986, 126347, 126329, 126327, 126044, 126043, 124833, 126087, 125662, 125946, 126229, 125659, 125943, 125940, 125422, 125652, 123932, 125403, 124806, 125271, 125266, 124734, 84380, 124862, 124860, 124540, 120146, 124726, 124858, 124857, 124975, 124854, 124724, 84374, 111974, 124555, 85268, 124452, 124450, 84366, 123625, 123753, 123620, 123999, 123997, 123992, 124202, 124169, 124166, 123751, 123748, 123747, 123906, 123738, 123736, 123730, 123729, 123563, 123561, 122239, 122231, 103531, 103529, 103528, 118257, 103524, 121806, 121497, 121416, 121414, 111962, 116405, 85259, 97845, 85257, 115795, 115794, 115437, 115281, 113557, 114515, 98127, 113602, 113435, 113597, 113368, 113280, 111954, 113037, 112662, 93727, 93724, 112159, 112157, 85230, 112410, 111878, 111903, 111872, 92674, 111465, 103343, 102730, 98125, 102155, 102153, 102148, 101731, 100539, 100723, 101345, 99882, 100535, 100906, 99879, 100534, 100949, 100941, 100940, 100937, 82566, 99876, 101182, 99866, 99861, 99860, 99858, 91441, 100498, 100489, 100485, 100218, 100162, 67780, 67774, 98183, 99849, 67768, 99907, 99842, 99840, 91357, 99643, 99641, 99614, 99611, 99393, 98569, 99599, 99598, 99596, 99594, 98174, 98173, 99580, 98171, 99187, 99186, 96935, 98162, 97104, 98530, 84540, 84394, 98526, 90837, 90831, 98107, 98381, 90823, 90821, 90818, 98377, 98463, 90813, 98372, 98104, 90809, 92104, 98369, 98366, 90806, 92101, 92099, 90804, 97813, 98219, 98363, 92092, 92090, 97630, 98357, 98145, 98216, 90792, 94331, 98274, 98285, 90779, 90747, 90742, 98095, 98092, 90740, 90737, 90730, 90725, 90723, 83526, 90720, 90717, 95956, 90715, 90713, 90709, 98089, 98087, 90702, 98059, 98085, 98083, 98080, 97646, 98068, 90692, 97796, 92666, 92663, 92662, 93877, 95514, 95508, 90627, 90620, 97097, 97096, 97093, 97046, 97034, 96997, 96992, 96657, 96463, 96594, 96461, 96863, 96420, 96400, 96398, 96263, 95925, 90529, 95923, 95224, 95402, 95885, 95897, 90520, 95882, 95760, 95879, 95749, 95736, 95624, 95613, 95674, 95611, 95607, 95222, 95575, 95388, 95380, 95379, 94715, 94710, 94708, 94705, 94698, 94695, 89313, 81552, 94355, 94346, 94190, 94189, 94033, 93718, 94031, 93711, 93708, 93745, 93701, 93695, 89311, 92656, 93498, 89418, 89414, 89410, 88499, 88687, 88681, 88678, 88538, 88488, 88484, 88478, 88518, 87902, 87900, 88212, 88476, 88208, 88206, 88203, 88202, 87757, 87410, 85739, 81363, 85173, 84723, 85339, 84991, 84716, 77070, 84989, 85042, 85040, 84713, 84705, 84460, 84702, 84700, 84428, 84426, 84424, 84355, 84272, 76962, 83673, 83671, 82854, 83377, 76166, 78241, 83374, 83092, 81124, 79052, 78022, 77068, 76365, 77405, 76002, 76067, 77059, 77016, 77013, 75996, 77006, 77002, 75654, 76220, 75976, 76143, 75789, 75727, 75827, 68418, 68415, 75506, 75323, 74193, 71493, 74267, 59113, 74261, 72192, 73492, 74188, 73484, 73915, 74046, 73910, 73909, 73243, 73474, 73507, 73472, 73502, 73519, 72694, 73470, 73238, 73234, 73441, 59617, 63171, 73101, 72682, 72680, 71491, 72678, 67011, 71976, 71971, 71968, 71822, 71773, 69046, 68243, 71892, 68241, 70028, 70984, 71179, 71820, 68239, 60437, 71486, 71484, 71482, 71335, 71332, 71272, 71214, 70356, 70921, 70916, 70818, 65978, 70760, 70465, 70459, 70457, 70568, 70002, 70456, 69087, 69084, 70241, 70240, 69940, 67979, 70145, 69996, 69936, 69418, 69573, 67347, 69082, 69052, 69080, 69078, 69050, 67972, 61872, 68202, 66738, 66719, 66717, 66736, 66734, 62869, 62499, 62495, 62609, 57464, 62103, 62578, 62101, 62097, 62096, 62444, 62441, 57458, 57450, 57448, 62094, 62091, 62218, 62217, 62089, 62088, 62086, 61117, 62046, 62083, 62042, 56512, 54879, 25747, 58069, 56398, 58381, 58432, 58431, 58380, 58376, 58067, 52151, 58065, 56396, 58375, 58373))
Run Time: 0.076412
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1962 | |
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 | | | | | 1962 | |
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 (13636, 13229, 12840, 12839, 12792, 12508, 12035, 12031, 12016, 11876, 11875, 11801, 11742, 11614, 11527, 11461, 11422, 10830, 10778, 10486, 10090, 10054, 9912, 9894, 9821, 9820, 9559, 9521, 9490, 9404, 9395, 9382, 9336, 9289, 9202, 9104, 8901, 8562, 8393, 8328, 8215, 8212, 8137, 7908, 7888, 7696, 7691, 7620, 7321, 6774, 6687, 6519, 6454, 6335, 6300, 6285, 6238, 6191, 6077, 5918, 5917, 5599, 5579, 5574, 5285))
Run Time: 0.003154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 65 | 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 (160160, 269582, 257956, 257954, 260958, 113977, 207251, 254725, 261000, 260464, 260460, 260458, 259658, 260956, 258733, 258106, 258215, 258101, 257941, 258209, 258093, 258088, 258170, 258203, 258086, 258085, 257937, 258079, 258165, 258164, 258077, 258075, 258072, 258161, 258159, 257775, 256964, 256958, 191120, 256940, 256943, 256961, 249502, 255408, 250367, 142938, 250365, 250364, 250346, 250345, 250343, 255800, 255798, 250340, 255796, 255794, 255788, 250336, 171362, 251007, 252956, 250313, 250309, 250307, 253222, 250301, 253336, 253335, 253334, 253276, 253331, 250295, 250278, 250270, 250269, 250268, 250249, 250246, 250244, 250224, 251020, 251018, 251016, 251012, 250731, 250729, 250726, 250058, 250721, 250719, 247948, 248927, 248925, 248918, 248916, 248913, 248906, 248898, 248895, 248769, 248763, 248716, 247852, 248287, 248285, 248281, 247843, 247841, 142932, 247831, 248279, 247829, 248111, 247827, 248118, 248116, 142922, 247895, 204179, 247892, 247891, 247920, 247967, 247889, 247953, 247960, 247945, 247884, 247724, 247899, 247881, 247815, 247812, 222678, 172008, 142902, 142900, 247300, 222653, 222632, 222307, 222306, 222236, 222279, 208482, 222262, 222112, 222101, 222062, 222098, 222081, 222060, 222057, 208355, 208309, 208386, 208263, 208260, 172000, 208198, 208197, 163596, 163592, 208025, 207464, 208022, 208097, 208096, 207945, 207899, 207707, 207698, 207865, 207616, 207421, 207065, 207087, 207103, 194846, 207083, 201471, 207205, 142855, 193752, 206929, 194839, 204820, 206924, 202975, 207100, 207092, 206936, 206922, 193188, 207074, 207073, 206893, 204749, 202423, 206767, 181644, 190366, 127051, 127048, 204772, 203787, 194959, 194957, 204840, 204837, 16541, 202817, 16538, 203840, 186020, 201919, 204195, 204592, 203901, 203778, 203895, 203760, 204028, 203868, 203449, 203448, 203447, 203445, 203288, 203287, 203527, 203522, 203284, 203280, 203406, 203405, 202042, 202761, 202786, 202784, 167084, 202779, 201850, 202777, 202233, 184766, 202231, 202229, 202740, 201848, 202341, 202428, 129870, 201374, 190010, 201912, 201369, 201829, 201365, 201363, 194945, 201540, 201360, 201735, 191369, 201464, 201354, 195348, 201351, 201349, 195068, 193745, 195345, 195344, 195065, 193742, 193737, 193735, 193731, 193726, 193714, 193704, 185244, 194022, 194554, 194552, 194544, 194542, 193698, 190000, 193692, 193688, 194019, 193686, 193667, 193629, 184749, 184744, 191462, 190615, 184741, 127697, 192787, 192786, 193068, 184086, 165391, 184085, 127693, 192875, 192785, 192896, 192741, 192916, 192783, 192781, 185492, 142824, 142821, 192603, 192734, 142819, 191355, 192236, 192143, 192601, 192600, 192728, 165387, 192598, 142815, 192517, 165383, 192577, 192561, 192505, 192535, 192530, 191861, 190750, 190324, 190744, 190587, 190583, 190582, 190078, 190355, 184070, 189920, 190307, 190350, 188295, 182588, 190140, 189852, 172497, 188292, 190070, 189990, 189925, 184056, 189988, 188288, 189985, 189977, 188286, 189967, 189974, 189913, 189912, 189713, 189802, 189849, 167027, 189846, 144162, 144161, 144158, 144155, 144153, 144152, 144151, 189653, 155231, 189511, 187658, 188282, 188276, 188274, 188273, 187700, 187860, 187857, 187854, 182649, 187233, 182633, 187242, 144528, 187271, 187267, 187266, 187264, 187317, 187259, 187194, 187192, 187189, 182623, 182621, 187184, 187168, 182620, 182618, 187064, 182615, 186956, 186955, 182613, 187091, 187140, 185457, 186939, 187138, 144523, 182609, 182607, 182606, 182601, 185950, 185442, 185472, 184876, 149452, 184122, 149449, 185198, 144518, 185064, 185390, 185025, 184239, 185192, 144514, 185189, 185187, 185023, 144508, 144505, 144504, 144501, 144499, 185015, 185034, 120049, 136930, 184782, 171994, 120047, 184871, 184006, 183659, 184205, 144479, 144478, 182131, 183329, 184108, 182389, 184106, 144472, 144469, 182289, 144467, 161627, 182079, 161625, 161623, 182074, 182661, 174889, 160120, 174868, 183651, 144466, 144465, 144463, 183466, 182584, 182577, 182575, 182574, 172945, 175580, 182564, 182808, 183304, 182557, 183104, 181640, 182553, 182061, 182060, 182056, 182053, 181555, 182551, 173900, 172942, 181553, 182548, 181785, 172940, 181634, 181715, 175529, 144439, 173557, 173555, 172938, 181223, 181221, 181209, 175506, 181083, 174837, 174836, 174835, 181081, 174960, 144431, 175477, 144428, 162746, 174940, 174939, 174769, 174922, 173795, 165340, 173053, 157967, 171984, 173922, 173918, 173551, 173549, 171979, 171975, 173710, 173838, 173824, 173822, 173821, 173788, 144422, 144421, 172623, 173691, 173518, 164434, 173515, 157965, 170568, 157960, 173527, 141540, 171058, 141537, 173512, 141533, 173363, 173525, 141528, 173068, 173359, 173357, 142802, 173038, 172822, 172217, 172518, 172465, 147984, 172146, 172142, 171055, 157956, 172478, 171965, 172138, 166813, 165334, 172136, 172134, 172347, 172132, 171046, 171042, 171041, 172181, 172128, 172119, 171460, 172115, 169807, 169806, 169805, 144416, 161423, 162209, 162207, 3037, 169646, 162205, 172062, 171961, 171145, 171136, 171132, 171122, 171402, 170654, 170651, 171067, 170931, 96169, 170693, 169160, 170835, 170833, 170924, 170648, 170686, 170641, 170640, 170577, 170576, 59183, 167142, 59182, 167510, 170265, 168498, 169921, 170151, 169406, 162790, 136924, 136920, 136918, 168703, 168488, 96165, 168485, 167939, 167563, 167984, 167983, 167562, 167932, 167253, 164736, 166710, 166178, 165487, 164719, 166168, 166166, 164867, 166155, 164865, 165513, 164708, 165509, 165507, 164706, 164861, 164689, 165543, 164682, 120976, 165084, 164676, 164674, 165504, 163668, 165079, 165078, 164672, 164670, 164669, 164667, 164389, 164314, 164313, 163409, 163912, 161485, 161483, 161494, 161478, 159722, 159286, 158204, 157995, 158043, 157990, 157696, 93735, 156706, 156701, 154740, 154736, 154733, 151634, 154728, 154725, 154721, 154718, 154716, 155092, 155089, 154897, 154895, 154331, 154330, 154323, 154313, 152092, 152606, 147804, 147803, 152464, 152455, 150616, 150945, 152359, 152119, 151816, 151814, 151459, 151806, 151805, 149959, 151834, 151831, 151348, 151455, 151645, 116676, 147392, 147391, 151450, 150598, 147389, 150590, 150588, 150407, 150028, 150937, 149899, 143140, 150256, 150371, 149895, 150496, 150362, 150024, 149880, 149876, 149539, 149732, 149537, 149536, 149747, 149562, 149558, 149553, 149871, 149868, 149866, 149863, 149856, 149853, 149847, 149622, 149528, 149527, 149740, 149728, 149525, 149720, 149736, 148471, 148470, 148506, 149517, 149515, 149513, 149659, 149510, 149509, 149618, 149617, 148467, 149506, 149505, 148586, 148363, 149502, 147386, 148749, 149496, 148463, 148361, 148585, 148582, 148637, 148168, 148580, 148576, 148459, 148574, 148572, 148560, 147204, 148557, 148356, 148456, 148521, 148353, 148383, 148165, 137473, 148163, 148162, 148160, 148158, 148016, 148157, 148156, 148068, 148056, 148151, 127946, 148145, 148053, 148139, 147760, 148197, 127942, 148010, 147858, 146205, 147753, 147914, 147572, 147384, 147733, 147731, 147379, 147492, 146097, 147377, 147312, 147308, 147375, 147374, 147372, 147371, 147370, 147369, 146086, 146855, 146085, 147304, 146084, 147302, 147299, 147298, 146529, 146527, 146525, 146520, 146516, 146514, 146853, 146852, 146851, 146846, 146839, 146834, 146833, 146832, 146831, 146041, 146038, 146037, 146036, 146035, 146032, 146030, 146827, 146826, 146824, 146822, 146817, 146816, 146813, 146016, 146014, 146011, 146005, 145999, 145506, 145995, 145993, 145992, 145989, 145987, 145983, 145981, 145979, 145975, 145973, 145972, 145945, 145938, 146769, 146767, 146790, 145916, 145914, 144143, 146763, 146761, 141272, 141271, 145868, 145604, 146725, 146575, 146478, 145757, 145748, 144140, 145739, 145716, 145715, 145711, 145639, 145599, 145598, 145597, 145710, 145706, 145663, 145392, 145389, 145388, 145386, 145259, 145114, 144096, 144752, 144699, 144749, 144736, 139393, 144296, 143885, 144132, 144130, 144129, 141929, 142055, 143883, 142044, 143880, 143657, 142042, 142041, 142036, 142033, 144015, 143876, 143789, 143788, 143874, 142014, 143872, 143786, 142012, 142006, 143800, 142674, 142668, 143653, 142666, 142657, 143646, 142653, 142651, 143612, 139143, 143087, 142003, 142002, 142000, 141999, 142190, 142290, 142222, 142158, 134588, 134859, 142178, 142181, 142176, 134469, 141995, 141991, 141983, 142088, 141987, 141979, 141977, 141976, 141800, 141266, 141610, 141497, 140491, 140490, 140483, 140482, 134462, 140535, 140531, 140468, 140446, 140712, 140016, 137470, 82610, 140116, 139503, 140002, 140011, 140000, 139995, 139560, 139498, 139810, 114529, 124952, 139630, 124948, 139390, 139566, 139331, 139564, 124946, 139323, 124941, 124940, 124938, 124937, 124935, 124932, 124919, 82601, 138014, 82598, 138554, 82597, 82595, 138578, 137813, 135277, 138575, 138551, 138548, 138215, 138545, 137456, 135272, 138003, 138148, 138569, 138539, 138203, 138115, 138113, 138467, 138463, 138199, 138107, 138144, 138176, 138141, 138174, 138172, 138170, 138139, 138097, 138167, 138160, 138157, 120849, 124376, 135590, 124374, 16518, 120839, 16514, 16512, 134337, 137141, 137943, 16509, 16506, 137792, 16504, 16502, 137355, 137138, 119578, 134333, 134328, 134326, 134323, 134320, 134318, 137135, 135582, 136056, 136054, 134586, 120833, 134584, 137451, 136988, 137303, 16499, 136040, 137387, 137300, 136297, 137298, 137385, 16495, 136033, 137437, 126761, 137444, 137336, 133587, 123396, 133584, 133582, 130177, 137329, 136022, 137317, 136292, 136290, 136360, 136357, 137051, 136355, 136288, 126759, 126756, 136286, 126755, 137046, 136284, 137294, 137204, 137291, 137289, 124241, 137286, 137282, 136282, 136001, 136280, 135997, 126752, 137256, 134460, 137176, 137254, 134458, 130175, 137171, 137110, 126749, 137079, 134456, 137105, 136277, 130037, 126745, 135543, 133789, 126739, 135538, 135533, 126735, 135924, 136164, 135920, 136272, 135723, 135721, 126539, 126533, 135716, 135702, 135370, 135335, 135577, 129314, 135261, 135195, 135259, 129307, 134845, 126511, 126510, 126503, 126502, 126498, 127033, 134843, 127, 134578, 135039, 129658, 134446, 125795, 135043, 127031, 127029, 127028, 135036, 134438, 134987, 134278, 129751, 134961, 134959, 134952, 126976, 134436, 133462, 89138, 134834, 134299, 129514, 134831, 123952, 134276, 134420, 133380, 134417, 129647, 134574, 134403, 126488, 126487, 129938, 126480, 134208, 134386, 133572, 126476, 133570, 134204, 126474, 133451, 129922, 133743, 133442, 126463, 133739, 126461, 133644, 126457, 133577, 126454, 133440, 133498, 130352, 130350, 133423, 133420, 114, 133418, 133395, 130152, 120826, 129908, 130197, 130292, 125772, 129802, 129904, 124850, 126430, 129896, 130187, 129645, 123652, 130181, 126427, 130165, 130160, 129884, 98131, 80541, 130134, 130058, 129881, 129880, 126425, 130132, 129166, 129875, 129873, 129800, 80539, 129826, 129798, 129164, 126719, 129795, 129792, 129344, 124910, 129248, 121560, 129341, 129700, 129691, 129710, 129367, 129161, 129159, 129334, 129157, 129331, 111226, 124906, 121558, 129259, 129287, 126818, 129236, 128715, 129153, 129151, 129149, 128705, 129210, 129147, 129145, 129143, 129112, 128696, 8009, 129138, 124904, 126416, 124897, 128553, 125678, 126415, 128425, 128343, 128526, 128529, 124895, 127934, 124894, 128153, 127928, 128404, 119464, 127926, 127923, 127922, 127916, 125764, 125756, 127910, 126410, 127908, 125752, 127902, 111977, 127900, 127898, 127895, 127893, 125749, 128147, 126399, 127792, 93733, 127888, 125743, 127872, 125740, 127527, 125739, 127502, 124889, 127415, 127492, 86568, 127270, 122636, 123304, 124879, 127374, 123763, 127372, 124874, 127266, 126380, 126379, 125576, 126371, 126796, 127172, 127136, 126618, 126598, 124865, 126698, 126613, 126941, 126939, 126771, 126770, 126050, 126605, 126603, 126602, 125988, 126352, 126350, 125986, 126347, 126329, 126327, 126044, 126043, 124833, 126087, 125662, 125946, 126229, 125659, 125943, 125940, 125422, 125652, 123932, 125403, 124806, 125271, 125266, 124734, 84380, 124862, 124860, 124540, 120146, 124726, 124858, 124857, 124975, 124854, 124724, 84374, 111974, 124555, 85268, 124452, 124450, 84366, 123625, 123753, 123620, 123999, 123997, 123992, 124202, 124169, 124166, 123751, 123748, 123747, 123906, 123738, 123736, 123730, 123729, 123563, 123561, 122239, 122231, 103531, 103529, 103528, 118257, 103524, 121806, 121497, 121416, 121414, 111962, 116405, 85259, 97845, 85257, 115795, 115794, 115437, 115281, 113557, 114515, 98127, 113602, 113435, 113597, 113368, 113280, 111954, 113037, 112662, 93727, 93724, 112159, 112157, 85230, 112410, 111878, 111903, 111872, 92674, 111465, 103343, 102730, 98125, 102155, 102153, 102148, 101731, 100539, 100723, 101345, 99882, 100535, 100906, 99879, 100534, 100949, 100941, 100940, 100937, 82566, 99876, 101182, 99866, 99861, 99860, 99858, 91441, 100498, 100489, 100485, 100218, 100162, 67780, 67774, 98183, 99849, 67768, 99907, 99842, 99840, 91357, 99643, 99641, 99614, 99611, 99393, 98569, 99599, 99598, 99596, 99594, 98174, 98173, 99580, 98171, 99187, 99186, 96935, 98162, 97104, 98530, 84540, 84394, 98526, 90837, 90831, 98107, 98381, 90823, 90821, 90818, 98377, 98463, 90813, 98372, 98104, 90809, 92104, 98369, 98366, 90806, 92101, 92099, 90804, 97813, 98219, 98363, 92092, 92090, 97630, 98357, 98145, 98216, 90792, 94331, 98274, 98285, 90779, 90747, 90742, 98095, 98092, 90740, 90737, 90730, 90725, 90723, 83526, 90720, 90717, 95956, 90715, 90713, 90709, 98089, 98087, 90702, 98059, 98085, 98083, 98080, 97646, 98068, 90692, 97796, 92666, 92663, 92662, 93877, 95514, 95508, 90627, 90620, 97097, 97096, 97093, 97046, 97034, 96997, 96992, 96657, 96463, 96594, 96461, 96863, 96420, 96400, 96398, 96263, 95925, 90529, 95923, 95224, 95402, 95885, 95897, 90520, 95882, 95760, 95879, 95749, 95736, 95624, 95613, 95674, 95611, 95607, 95222, 95575, 95388, 95380, 95379, 94715, 94710, 94708, 94705, 94698, 94695, 89313, 81552, 94355, 94346, 94190, 94189, 94033, 93718, 94031, 93711, 93708, 93745, 93701, 93695, 89311, 92656, 93498, 89418, 89414, 89410, 88499, 88687, 88681, 88678, 88538, 88488, 88484, 88478, 88518, 87902, 87900, 88212, 88476, 88208, 88206, 88203, 88202, 87757, 87410, 85739, 81363, 85173, 84723, 85339, 84991, 84716, 77070, 84989, 85042, 85040, 84713, 84705, 84460, 84702, 84700, 84428, 84426, 84424, 84355, 84272, 76962, 83673, 83671, 82854, 83377, 76166, 78241, 83374, 83092, 81124, 79052, 78022, 77068, 76365, 77405, 76002, 76067, 77059, 77016, 77013, 75996, 77006, 77002, 75654, 76220, 75976, 76143, 75789, 75727, 75827, 68418, 68415, 75506, 75323, 74193, 71493, 74267, 59113, 74261, 72192, 73492, 74188, 73484, 73915, 74046, 73910, 73909, 73243, 73474, 73507, 73472, 73502, 73519, 72694, 73470, 73238, 73234, 73441, 59617, 63171, 73101, 72682, 72680, 71491, 72678, 67011, 71976, 71971, 71968, 71822, 71773, 69046, 68243, 71892, 68241, 70028, 70984, 71179, 71820, 68239, 60437, 71486, 71484, 71482, 71335, 71332, 71272, 71214, 70356, 70921, 70916, 70818, 65978, 70760, 70465, 70459, 70457, 70568, 70002, 70456, 69087, 69084, 70241, 70240, 69940, 67979, 70145, 69996, 69936, 69418, 69573, 67347, 69082, 69052, 69080, 69078, 69050, 67972, 61872, 68202, 66738, 66719, 66717, 66736, 66734, 62869, 62499, 62495, 62609, 57464, 62103, 62578, 62101, 62097, 62096, 62444, 62441, 57458, 57450, 57448, 62094, 62091, 62218, 62217, 62089, 62088, 62086, 61117, 62046, 62083, 62042, 56512, 54879, 25747, 58069, 56398, 58381, 58432, 58431, 58380, 58376, 58067, 52151, 58065, 56396, 58375, 58373))
Run Time: 0.035340
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1962 | |
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 | | | | | 1962 | |
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 (13636, 13229, 12840, 12839, 12792, 12508, 12035, 12031, 12016, 11876, 11875, 11801, 11742, 11614, 11527, 11461, 11422, 10830, 10778, 10486, 10090, 10054, 9912, 9894, 9821, 9820, 9559, 9521, 9490, 9404, 9395, 9382, 9336, 9289, 9202, 9104, 8901, 8562, 8393, 8328, 8215, 8212, 8137, 7908, 7888, 7696, 7691, 7620, 7321, 6774, 6687, 6519, 6454, 6335, 6300, 6285, 6238, 6191, 6077, 5918, 5917, 5599, 5579, 5574, 5285))
Run Time: 0.002164
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 65 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, ��
Run Time: 0.000202
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.000404
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.000464
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: 1716205950
Run Time: 0.000279
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 12 | 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` >= 1716205950)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000487
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 12 | 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