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.000975
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.000276
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` = '2099')
LIMIT 1
Run Time: 0.000654
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.003139
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_2099' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.054122
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 (305080, 305340, 271583, 270481, 270479, 270477, 259414, 263114, 184613, 257817, 256808, 256804, 256629, 256592, 222210, 186327, 186324, 256622, 256587, 186316, 255231, 256542, 256565, 254988, 104004, 104002, 254870, 254973, 186286, 254868, 186191, 186189, 248259, 250500, 248257, 250497, 249827, 250493, 248248, 248243, 250485, 248588, 208370, 204680, 203363, 204546, 204677, 203360, 204540, 204611, 204537, 192421, 187724, 187511, 187677, 182240, 187483, 187673, 187671, 187498, 187669, 175958, 187481, 182239, 174597, 187496, 182237, 182234, 185380, 185370, 185102, 185098, 182232, 182230, 184256, 184715, 161225, 184713, 184578, 184252, 184309, 184292, 163027, 182858, 183242, 182854, 157259, 183622, 183232, 182834, 182832, 175851, 183221, 183254, 182713, 182830, 182791, 182223, 182825, 130687, 182782, 130684, 182780, 182221, 183087, 182216, 182711, 182212, 175474, 182778, 175844, 182354, 182775, 182771, 182351, 175472, 182818, 182694, 175470, 182764, 175837, 182690, 182729, 182804, 182423, 182683, 182348, 181464, 165200, 181288, 170995, 165197, 182758, 175281, 175834, 182454, 182534, 182673, 170988, 170984, 103663, 165184, 175270, 103660, 182190, 103649, 182176, 103646, 181281, 181532, 181977, 181936, 181928, 181925, 181605, 181919, 175048, 175815, 181388, 181908, 181275, 181903, 181523, 181899, 181601, 175812, 182174, 182172, 175045, 175259, 175301, 175299, 175810, 181896, 122508, 181519, 181516, 175297, 181514, 181594, 182167, 181512, 181591, 182145, 175295, 175316, 181509, 181697, 181507, 181266, 181578, 181262, 181575, 181260, 181683, 181254, 181675, 181383, 122505, 181668, 181247, 181244, 181373, 181493, 175460, 181370, 181491, 181337, 181335, 174120, 175564, 181227, 167851, 181204, 171649, 181202, 174112, 175188, 175099, 175240, 181096, 175358, 175253, 140705, 175326, 175310, 175663, 165179, 175292, 158003, 172988, 158821, 130659, 173779, 173303, 173288, 173286, 172972, 161997, 172959, 172847, 172421, 171632, 140682, 173005, 155347, 172712, 172956, 172704, 130625, 172699, 140672, 172695, 172688, 168478, 171589, 172367, 172404, 171516, 171573, 172166, 122464, 170438, 122461, 171513, 171220, 171569, 170795, 172050, 171175, 170956, 128794, 171088, 122418, 164928, 170771, 170873, 170941, 160292, 170501, 160289, 145187, 160388, 168848, 169886, 169778, 169344, 169386, 169774, 140665, 130595, 169771, 169382, 168222, 169191, 169181, 168597, 168798, 168934, 168777, 140648, 168822, 168775, 168770, 168283, 168808, 165986, 165983, 140640, 167484, 167545, 167211, 168280, 168615, 140638, 166301, 168551, 168389, 167431, 167899, 168274, 168432, 168272, 168590, 168612, 166298, 167846, 168384, 168585, 166296, 159830, 167897, 167208, 168430, 168470, 155987, 168270, 168609, 168583, 168680, 166469, 168140, 168548, 168380, 167844, 168219, 168686, 167835, 167672, 137883, 167832, 167893, 166294, 167203, 168127, 137881, 167830, 168125, 168137, 168101, 167930, 167421, 166045, 166680, 166042, 165600, 166281, 154957, 166677, 165924, 165579, 165577, 165922, 160971, 163751, 165979, 165919, 164283, 165821, 164277, 164273, 165807, 163748, 165805, 164010, 164006, 165803, 164004, 165686, 164000, 165683, 163998, 165681, 165679, 165555, 165423, 122375, 165122, 164994, 161446, 165677, 158946, 165675, 165571, 165102, 165100, 165111, 165068, 164544, 163469, 164268, 164979, 164491, 163368, 163149, 163113, 163129, 163069, 125149, 163004, 125147, 162690, 162883, 125142, 125140, 162828, 162387, 162036, 162384, 162034, 162032, 154477, 162589, 162579, 162550, 162548, 162616, 162614, 162566, 162546, 162544, 162563, 162397, 162560, 162369, 162557, 159912, 144788, 161653, 161978, 162048, 162045, 161973, 161221, 144781, 157252, 157249, 161526, 160893, 161966, 161405, 161403, 161511, 161492, 161219, 161519, 149483, 161127, 161216, 161399, 161125, 158258, 161474, 161396, 161306, 161368, 149479, 157245, 161160, 160286, 161197, 161195, 158608, 158922, 157239, 160883, 160901, 159222, 160378, 159526, 159215, 157231, 160861, 152451, 157229, 159448, 157223, 155963, 159808, 142395, 159190, 159077, 159466, 159063, 159701, 157623, 157206, 159509, 159101, 150446, 142391, 159521, 159484, 159463, 155903, 157201, 159432, 153310, 158729, 154953, 153308, 155796, 157199, 154951, 157689, 159618, 159318, 159647, 159160, 158335, 159158, 159060, 159075, 159155, 142383, 158467, 158331, 159087, 158464, 159152, 159085, 159150, 159147, 158178, 159304, 158877, 159057, 158855, 158805, 158849, 158844, 158802, 158839, 158579, 155790, 158794, 158325, 158722, 158788, 158378, 158720, 158621, 158314, 158701, 43781, 158458, 158553, 158551, 158170, 158406, 157191, 155717, 123014, 158014, 157735, 155896, 157159, 122335, 157155, 157144, 157732, 157139, 123010, 157136, 157132, 157723, 157721, 157065, 157130, 157606, 157715, 157604, 157381, 157126, 157379, 157121, 130566, 157119, 157437, 157589, 156309, 157042, 156212, 157268, 157115, 151695, 156045, 130560, 152437, 140827, 155025, 155373, 155141, 155039, 154777, 154940, 155001, 154937, 154993, 154933, 154775, 154796, 154903, 135474, 154628, 154773, 135471, 153482, 154618, 154575, 153528, 152865, 140819, 153054, 153049, 130546, 153044, 154387, 154385, 130544, 122329, 153975, 153224, 153973, 130542, 152848, 130538, 152838, 146147, 153621, 153220, 153472, 153429, 153217, 153413, 153466, 153426, 153406, 153214, 153402, 153212, 152503, 153196, 153194, 153084, 153024, 152587, 137868, 153133, 153131, 151758, 152973, 151547, 137862, 151754, 130518, 152010, 137858, 152008, 152007, 152006, 152005, 152004, 152003, 152959, 137853, 140089, 140087, 152534, 152527, 152834, 152819, 152817, 152814, 152810, 137752, 152425, 151398, 152423, 150440, 151971, 140794, 152247, 151967, 152245, 140792, 151964, 152241, 151712, 151516, 122311, 122309, 151512, 151508, 151506, 151961, 151391, 151616, 151668, 103636, 151213, 151959, 151487, 151948, 151662, 151707, 151946, 151705, 151941, 151370, 151862, 151366, 148332, 151858, 148330, 151723, 151660, 148241, 151614, 151211, 130507, 151703, 150525, 151207, 150202, 103622, 130392, 150575, 150841, 150466, 150271, 150427, 144958, 143734, 144908, 144953, 144942, 144945, 144905, 144903, 144575, 144940, 144569, 144563, 144559, 144556, 103602, 144547, 144385, 144543, 103600, 103592, 125935, 137592, 125924, 140617, 143889, 144059, 143887, 130487, 103574, 143902, 143919, 144001, 144047, 142356, 142570, 143317, 140394, 142478, 140578, 143315, 143262, 143051, 143292, 140288, 142332, 143356, 143404, 142563, 140611, 139457, 141858, 142340, 142325, 140285, 141738, 142210, 141849, 139991, 142208, 139440, 140282, 142138, 141686, 140079, 127729, 141916, 141837, 141913, 141825, 141709, 141515, 139431, 139787, 138440, 140356, 140270, 140599, 140746, 138438, 140722, 140352, 140596, 135790, 140348, 140345, 139962, 139551, 139960, 140336, 140220, 140237, 138683, 140234, 140218, 140231, 139548, 140165, 138681, 140068, 139713, 140180, 139957, 139546, 139707, 139705, 140177, 140157, 138677, 139543, 139949, 139703, 140065, 140174, 138674, 139940, 139697, 139936, 139693, 140039, 139759, 139754, 139752, 139690, 139419, 139933, 139538, 138257, 139891, 128390, 139927, 138255, 139536, 139783, 135468, 127358, 139861, 137578, 139369, 138386, 139413, 139353, 139688, 139750, 134897, 138670, 138249, 139531, 122891, 137247, 138656, 139529, 122889, 138454, 138653, 138381, 139347, 116352, 135784, 138698, 102415, 138418, 138066, 137985, 138057, 134088, 138055, 135776, 138053, 138044, 138040, 137748, 137848, 138038, 134075, 138036, 138033, 138030, 134071, 134801, 138027, 137762, 137971, 137980, 137846, 137744, 137843, 137741, 137633, 130479, 137630, 137490, 137732, 137574, 135771, 130477, 130471, 137537, 137541, 137531, 135462, 134891, 137097, 136223, 135460, 136294, 135458, 137307, 136283, 133610, 137034, 137089, 135839, 136109, 136275, 136266, 136264, 136215, 135121, 135831, 136239, 121779, 134796, 136107, 135828, 134794, 135851, 135344, 135678, 135744, 135805, 135826, 135843, 135669, 135498, 135496, 135503, 130468, 135609, 135443, 135214, 135484, 135434, 135557, 135319, 135253, 135431, 126262, 135292, 135384, 135419, 135249, 135379, 135243, 135170, 135228, 135204, 135164, 125919, 134930, 134928, 125910, 123004, 134774, 125908, 134527, 134178, 128679, 130463, 134592, 134157, 134523, 134567, 134054, 134521, 133484, 134539, 134516, 134231, 134512, 128262, 134025, 128260, 128258, 134225, 133479, 128256, 130460, 128254, 121772, 118641, 133946, 133973, 134102, 133529, 133723, 130456, 130125, 121760, 134009, 133995, 134100, 133524, 130449, 133990, 133961, 133476, 133986, 133942, 133518, 133958, 133971, 125905, 121743, 133969, 133940, 133511, 133736, 129195, 130257, 133474, 121714, 133403, 130254, 130431, 130083, 130364, 130428, 127727, 128784, 130186, 130113, 128477, 130111, 130091, 130004, 125895, 129355, 125891, 129965, 125887, 129351, 129732, 128472, 129349, 129783, 81523, 129728, 125081, 125879, 129719, 128670, 129717, 129725, 125875, 129642, 125866, 129274, 129230, 128659, 129271, 128656, 129269, 129117, 128759, 128168, 128166, 128136, 127831, 127995, 127823, 127866, 127221, 118623, 126691, 97139, 127219, 127858, 127810, 127856, 125210, 125860, 127716, 125045, 127241, 125844, 125832, 124659, 126280, 125042, 125963, 124652, 125040, 125961, 126187, 125959, 125555, 126163, 125816, 126177, 125599, 125955, 125208, 125806, 125802, 124641, 124639, 124992, 125340, 125434, 124634, 125337, 124628, 115362, 125223, 125204, 124625, 125201, 125100, 125163, 125063, 125098, 125027, 124615, 125024, 118491, 124606, 124602, 124995, 124987, 124599, 123881, 123259, 124963, 124596, 124957, 115755, 124438, 124322, 124955, 115644, 124319, 124436, 124562, 115753, 124591, 124499, 124504, 124395, 124422, 124495, 124420, 124259, 124484, 124489, 118993, 124304, 122840, 124067, 124256, 124410, 124333, 124328, 124310, 123879, 124096, 122268, 124094, 123256, 123872, 123870, 123254, 122265, 124064, 124062, 124054, 118526, 118524, 123708, 123706, 123696, 123687, 123000, 123248, 121691, 123220, 121339, 123243, 123214, 123196, 123194, 121337, 122254, 116053, 123058, 122992, 117152, 122989, 121345, 122985, 116050, 122981, 121327, 122829, 122974, 122973, 122819, 116455, 121688, 121294, 122807, 121685, 120280, 121683, 121284, 121602, 121280, 121600, 121278, 121676, 121273, 121598, 121669, 121427, 121662, 121267, 122244, 121619, 121658, 121260, 103537, 121474, 121596, 122145, 103532, 122117, 103530, 121616, 121252, 116046, 103522, 121647, 121614, 117149, 121406, 121594, 103515, 103513, 121461, 121459, 103509, 121242, 118687, 121235, 121231, 118681, 111255, 118679, 120277, 111251, 120275, 121004, 119045, 119040, 114037, 116042, 118984, 118894, 118888, 118650, 118740, 118724, 116037, 115748, 118486, 118161, 118277, 118320, 118268, 115743, 117803, 103500, 117879, 103497, 117110, 103462, 103459, 116348, 116438, 116436, 116345, 116342, 115758, 103447, 116211, 115953, 116022, 116017, 66842, 116015, 66840, 116142, 115942, 116011, 113073, 115940, 115938, 116009, 115934, 115629, 115355, 115627, 115625, 115346, 115343, 97479, 97477, 112984, 114028, 66834, 114048, 113879, 113876, 113874, 113871, 114197, 114617, 113869, 114024, 114016, 114213, 97475, 114010, 103440, 97473, 97471, 114005, 114060, 114003, 97469, 113834, 103436, 113997, 113830, 113824, 113821, 111771, 113201, 111240, 113442, 113124, 78812, 112954, 113192, 113221, 103412, 112980, 103406, 111985, 113053, 103398, 111769, 112502, 111937, 111935, 112500, 112497, 112495, 111767, 111998, 103396, 112493, 88774, 111777, 98776, 103393, 103389, 111775, 111925, 111981, 111780, 111774, 111694, 111761, 111677, 111425, 111300, 111363, 111421, 111298, 111296, 99075, 111290, 111286, 111282, 109535, 109530, 109526, 109511, 102308, 102246, 102397, 102394, 99051, 102454, 102298, 102296, 102382, 102216, 66829, 66826, 102023, 101364, 99049, 100661, 99753, 99541, 99750, 99748, 99521, 99515, 99129, 98909, 98906, 98904, 98902, 99065, 99315, 99126, 99037, 99035, 99070, 99056, 97689, 99043, 99042, 98758, 98769, 98748, 78809, 78807, 98721, 98333, 98342, 84970, 97685, 98007, 94055, 88009, 94053, 97982, 97980, 97976, 97465, 97463, 97852, 97229, 97850, 97677, 97389, 94051, 97459, 97386, 97211, 97382, 97380, 82883, 66802, 97163, 97131, 97114, 96911, 96597, 81519, 96220, 96212, 96216, 94049, 95586, 94894, 94023, 94042, 94040, 93407, 93613, 93425, 93396, 93394, 93392, 93389, 92998, 73032, 87337, 93208, 89327, 92544, 91723, 89540, 91573, 92467, 92442, 92440, 92435, 91711, 88857, 91646, 91557, 91551, 89724, 89618, 89899, 89722, 89610, 89870, 89264, 89531, 89571, 89261, 89259, 89417, 89525, 89467, 89465, 89462, 89427, 88555, 88905, 89408, 89003, 89222, 89277, 89247, 65900, 89093, 89091, 89088, 88923, 88898, 88760, 88836, 88758, 88673, 88444, 87466, 88441, 88398, 88422, 88321, 88390, 88045, 88315, 80494, 80491, 87628, 86040, 87736, 87464, 87565, 87852, 87910, 87615, 87873, 87799, 87651, 87703, 87149, 87583, 87684, 87463, 87461, 87458, 86961))
Run Time: 0.073518
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1623 | |
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 | | | | | 1623 | |
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 (15254, 14402, 14260, 13155, 13064, 12589, 12513, 12512, 12511, 12126, 11901, 11898, 11805, 11795, 11672, 11633, 11033, 10889, 10873, 10848, 10523, 10372, 10362, 10346, 10257, 9750, 9605, 9486, 9391, 9285, 9173, 9163, 9026, 8990, 8975, 8973, 8915, 8913, 8809, 8714, 8702, 8681, 8664, 8663, 8645, 8644, 8606, 8597, 8585, 8463, 8462, 8428, 8345, 8256, 8186, 8185, 8082, 8065, 8006, 7910, 7853, 7850, 7768, 7730, 7715, 7710, 7703, 7652, 7632, 7630, 7589, 7557))
Run Time: 0.004094
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 72 | 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 (305080, 305340, 271583, 270481, 270479, 270477, 259414, 263114, 184613, 257817, 256808, 256804, 256629, 256592, 222210, 186327, 186324, 256622, 256587, 186316, 255231, 256542, 256565, 254988, 104004, 104002, 254870, 254973, 186286, 254868, 186191, 186189, 248259, 250500, 248257, 250497, 249827, 250493, 248248, 248243, 250485, 248588, 208370, 204680, 203363, 204546, 204677, 203360, 204540, 204611, 204537, 192421, 187724, 187511, 187677, 182240, 187483, 187673, 187671, 187498, 187669, 175958, 187481, 182239, 174597, 187496, 182237, 182234, 185380, 185370, 185102, 185098, 182232, 182230, 184256, 184715, 161225, 184713, 184578, 184252, 184309, 184292, 163027, 182858, 183242, 182854, 157259, 183622, 183232, 182834, 182832, 175851, 183221, 183254, 182713, 182830, 182791, 182223, 182825, 130687, 182782, 130684, 182780, 182221, 183087, 182216, 182711, 182212, 175474, 182778, 175844, 182354, 182775, 182771, 182351, 175472, 182818, 182694, 175470, 182764, 175837, 182690, 182729, 182804, 182423, 182683, 182348, 181464, 165200, 181288, 170995, 165197, 182758, 175281, 175834, 182454, 182534, 182673, 170988, 170984, 103663, 165184, 175270, 103660, 182190, 103649, 182176, 103646, 181281, 181532, 181977, 181936, 181928, 181925, 181605, 181919, 175048, 175815, 181388, 181908, 181275, 181903, 181523, 181899, 181601, 175812, 182174, 182172, 175045, 175259, 175301, 175299, 175810, 181896, 122508, 181519, 181516, 175297, 181514, 181594, 182167, 181512, 181591, 182145, 175295, 175316, 181509, 181697, 181507, 181266, 181578, 181262, 181575, 181260, 181683, 181254, 181675, 181383, 122505, 181668, 181247, 181244, 181373, 181493, 175460, 181370, 181491, 181337, 181335, 174120, 175564, 181227, 167851, 181204, 171649, 181202, 174112, 175188, 175099, 175240, 181096, 175358, 175253, 140705, 175326, 175310, 175663, 165179, 175292, 158003, 172988, 158821, 130659, 173779, 173303, 173288, 173286, 172972, 161997, 172959, 172847, 172421, 171632, 140682, 173005, 155347, 172712, 172956, 172704, 130625, 172699, 140672, 172695, 172688, 168478, 171589, 172367, 172404, 171516, 171573, 172166, 122464, 170438, 122461, 171513, 171220, 171569, 170795, 172050, 171175, 170956, 128794, 171088, 122418, 164928, 170771, 170873, 170941, 160292, 170501, 160289, 145187, 160388, 168848, 169886, 169778, 169344, 169386, 169774, 140665, 130595, 169771, 169382, 168222, 169191, 169181, 168597, 168798, 168934, 168777, 140648, 168822, 168775, 168770, 168283, 168808, 165986, 165983, 140640, 167484, 167545, 167211, 168280, 168615, 140638, 166301, 168551, 168389, 167431, 167899, 168274, 168432, 168272, 168590, 168612, 166298, 167846, 168384, 168585, 166296, 159830, 167897, 167208, 168430, 168470, 155987, 168270, 168609, 168583, 168680, 166469, 168140, 168548, 168380, 167844, 168219, 168686, 167835, 167672, 137883, 167832, 167893, 166294, 167203, 168127, 137881, 167830, 168125, 168137, 168101, 167930, 167421, 166045, 166680, 166042, 165600, 166281, 154957, 166677, 165924, 165579, 165577, 165922, 160971, 163751, 165979, 165919, 164283, 165821, 164277, 164273, 165807, 163748, 165805, 164010, 164006, 165803, 164004, 165686, 164000, 165683, 163998, 165681, 165679, 165555, 165423, 122375, 165122, 164994, 161446, 165677, 158946, 165675, 165571, 165102, 165100, 165111, 165068, 164544, 163469, 164268, 164979, 164491, 163368, 163149, 163113, 163129, 163069, 125149, 163004, 125147, 162690, 162883, 125142, 125140, 162828, 162387, 162036, 162384, 162034, 162032, 154477, 162589, 162579, 162550, 162548, 162616, 162614, 162566, 162546, 162544, 162563, 162397, 162560, 162369, 162557, 159912, 144788, 161653, 161978, 162048, 162045, 161973, 161221, 144781, 157252, 157249, 161526, 160893, 161966, 161405, 161403, 161511, 161492, 161219, 161519, 149483, 161127, 161216, 161399, 161125, 158258, 161474, 161396, 161306, 161368, 149479, 157245, 161160, 160286, 161197, 161195, 158608, 158922, 157239, 160883, 160901, 159222, 160378, 159526, 159215, 157231, 160861, 152451, 157229, 159448, 157223, 155963, 159808, 142395, 159190, 159077, 159466, 159063, 159701, 157623, 157206, 159509, 159101, 150446, 142391, 159521, 159484, 159463, 155903, 157201, 159432, 153310, 158729, 154953, 153308, 155796, 157199, 154951, 157689, 159618, 159318, 159647, 159160, 158335, 159158, 159060, 159075, 159155, 142383, 158467, 158331, 159087, 158464, 159152, 159085, 159150, 159147, 158178, 159304, 158877, 159057, 158855, 158805, 158849, 158844, 158802, 158839, 158579, 155790, 158794, 158325, 158722, 158788, 158378, 158720, 158621, 158314, 158701, 43781, 158458, 158553, 158551, 158170, 158406, 157191, 155717, 123014, 158014, 157735, 155896, 157159, 122335, 157155, 157144, 157732, 157139, 123010, 157136, 157132, 157723, 157721, 157065, 157130, 157606, 157715, 157604, 157381, 157126, 157379, 157121, 130566, 157119, 157437, 157589, 156309, 157042, 156212, 157268, 157115, 151695, 156045, 130560, 152437, 140827, 155025, 155373, 155141, 155039, 154777, 154940, 155001, 154937, 154993, 154933, 154775, 154796, 154903, 135474, 154628, 154773, 135471, 153482, 154618, 154575, 153528, 152865, 140819, 153054, 153049, 130546, 153044, 154387, 154385, 130544, 122329, 153975, 153224, 153973, 130542, 152848, 130538, 152838, 146147, 153621, 153220, 153472, 153429, 153217, 153413, 153466, 153426, 153406, 153214, 153402, 153212, 152503, 153196, 153194, 153084, 153024, 152587, 137868, 153133, 153131, 151758, 152973, 151547, 137862, 151754, 130518, 152010, 137858, 152008, 152007, 152006, 152005, 152004, 152003, 152959, 137853, 140089, 140087, 152534, 152527, 152834, 152819, 152817, 152814, 152810, 137752, 152425, 151398, 152423, 150440, 151971, 140794, 152247, 151967, 152245, 140792, 151964, 152241, 151712, 151516, 122311, 122309, 151512, 151508, 151506, 151961, 151391, 151616, 151668, 103636, 151213, 151959, 151487, 151948, 151662, 151707, 151946, 151705, 151941, 151370, 151862, 151366, 148332, 151858, 148330, 151723, 151660, 148241, 151614, 151211, 130507, 151703, 150525, 151207, 150202, 103622, 130392, 150575, 150841, 150466, 150271, 150427, 144958, 143734, 144908, 144953, 144942, 144945, 144905, 144903, 144575, 144940, 144569, 144563, 144559, 144556, 103602, 144547, 144385, 144543, 103600, 103592, 125935, 137592, 125924, 140617, 143889, 144059, 143887, 130487, 103574, 143902, 143919, 144001, 144047, 142356, 142570, 143317, 140394, 142478, 140578, 143315, 143262, 143051, 143292, 140288, 142332, 143356, 143404, 142563, 140611, 139457, 141858, 142340, 142325, 140285, 141738, 142210, 141849, 139991, 142208, 139440, 140282, 142138, 141686, 140079, 127729, 141916, 141837, 141913, 141825, 141709, 141515, 139431, 139787, 138440, 140356, 140270, 140599, 140746, 138438, 140722, 140352, 140596, 135790, 140348, 140345, 139962, 139551, 139960, 140336, 140220, 140237, 138683, 140234, 140218, 140231, 139548, 140165, 138681, 140068, 139713, 140180, 139957, 139546, 139707, 139705, 140177, 140157, 138677, 139543, 139949, 139703, 140065, 140174, 138674, 139940, 139697, 139936, 139693, 140039, 139759, 139754, 139752, 139690, 139419, 139933, 139538, 138257, 139891, 128390, 139927, 138255, 139536, 139783, 135468, 127358, 139861, 137578, 139369, 138386, 139413, 139353, 139688, 139750, 134897, 138670, 138249, 139531, 122891, 137247, 138656, 139529, 122889, 138454, 138653, 138381, 139347, 116352, 135784, 138698, 102415, 138418, 138066, 137985, 138057, 134088, 138055, 135776, 138053, 138044, 138040, 137748, 137848, 138038, 134075, 138036, 138033, 138030, 134071, 134801, 138027, 137762, 137971, 137980, 137846, 137744, 137843, 137741, 137633, 130479, 137630, 137490, 137732, 137574, 135771, 130477, 130471, 137537, 137541, 137531, 135462, 134891, 137097, 136223, 135460, 136294, 135458, 137307, 136283, 133610, 137034, 137089, 135839, 136109, 136275, 136266, 136264, 136215, 135121, 135831, 136239, 121779, 134796, 136107, 135828, 134794, 135851, 135344, 135678, 135744, 135805, 135826, 135843, 135669, 135498, 135496, 135503, 130468, 135609, 135443, 135214, 135484, 135434, 135557, 135319, 135253, 135431, 126262, 135292, 135384, 135419, 135249, 135379, 135243, 135170, 135228, 135204, 135164, 125919, 134930, 134928, 125910, 123004, 134774, 125908, 134527, 134178, 128679, 130463, 134592, 134157, 134523, 134567, 134054, 134521, 133484, 134539, 134516, 134231, 134512, 128262, 134025, 128260, 128258, 134225, 133479, 128256, 130460, 128254, 121772, 118641, 133946, 133973, 134102, 133529, 133723, 130456, 130125, 121760, 134009, 133995, 134100, 133524, 130449, 133990, 133961, 133476, 133986, 133942, 133518, 133958, 133971, 125905, 121743, 133969, 133940, 133511, 133736, 129195, 130257, 133474, 121714, 133403, 130254, 130431, 130083, 130364, 130428, 127727, 128784, 130186, 130113, 128477, 130111, 130091, 130004, 125895, 129355, 125891, 129965, 125887, 129351, 129732, 128472, 129349, 129783, 81523, 129728, 125081, 125879, 129719, 128670, 129717, 129725, 125875, 129642, 125866, 129274, 129230, 128659, 129271, 128656, 129269, 129117, 128759, 128168, 128166, 128136, 127831, 127995, 127823, 127866, 127221, 118623, 126691, 97139, 127219, 127858, 127810, 127856, 125210, 125860, 127716, 125045, 127241, 125844, 125832, 124659, 126280, 125042, 125963, 124652, 125040, 125961, 126187, 125959, 125555, 126163, 125816, 126177, 125599, 125955, 125208, 125806, 125802, 124641, 124639, 124992, 125340, 125434, 124634, 125337, 124628, 115362, 125223, 125204, 124625, 125201, 125100, 125163, 125063, 125098, 125027, 124615, 125024, 118491, 124606, 124602, 124995, 124987, 124599, 123881, 123259, 124963, 124596, 124957, 115755, 124438, 124322, 124955, 115644, 124319, 124436, 124562, 115753, 124591, 124499, 124504, 124395, 124422, 124495, 124420, 124259, 124484, 124489, 118993, 124304, 122840, 124067, 124256, 124410, 124333, 124328, 124310, 123879, 124096, 122268, 124094, 123256, 123872, 123870, 123254, 122265, 124064, 124062, 124054, 118526, 118524, 123708, 123706, 123696, 123687, 123000, 123248, 121691, 123220, 121339, 123243, 123214, 123196, 123194, 121337, 122254, 116053, 123058, 122992, 117152, 122989, 121345, 122985, 116050, 122981, 121327, 122829, 122974, 122973, 122819, 116455, 121688, 121294, 122807, 121685, 120280, 121683, 121284, 121602, 121280, 121600, 121278, 121676, 121273, 121598, 121669, 121427, 121662, 121267, 122244, 121619, 121658, 121260, 103537, 121474, 121596, 122145, 103532, 122117, 103530, 121616, 121252, 116046, 103522, 121647, 121614, 117149, 121406, 121594, 103515, 103513, 121461, 121459, 103509, 121242, 118687, 121235, 121231, 118681, 111255, 118679, 120277, 111251, 120275, 121004, 119045, 119040, 114037, 116042, 118984, 118894, 118888, 118650, 118740, 118724, 116037, 115748, 118486, 118161, 118277, 118320, 118268, 115743, 117803, 103500, 117879, 103497, 117110, 103462, 103459, 116348, 116438, 116436, 116345, 116342, 115758, 103447, 116211, 115953, 116022, 116017, 66842, 116015, 66840, 116142, 115942, 116011, 113073, 115940, 115938, 116009, 115934, 115629, 115355, 115627, 115625, 115346, 115343, 97479, 97477, 112984, 114028, 66834, 114048, 113879, 113876, 113874, 113871, 114197, 114617, 113869, 114024, 114016, 114213, 97475, 114010, 103440, 97473, 97471, 114005, 114060, 114003, 97469, 113834, 103436, 113997, 113830, 113824, 113821, 111771, 113201, 111240, 113442, 113124, 78812, 112954, 113192, 113221, 103412, 112980, 103406, 111985, 113053, 103398, 111769, 112502, 111937, 111935, 112500, 112497, 112495, 111767, 111998, 103396, 112493, 88774, 111777, 98776, 103393, 103389, 111775, 111925, 111981, 111780, 111774, 111694, 111761, 111677, 111425, 111300, 111363, 111421, 111298, 111296, 99075, 111290, 111286, 111282, 109535, 109530, 109526, 109511, 102308, 102246, 102397, 102394, 99051, 102454, 102298, 102296, 102382, 102216, 66829, 66826, 102023, 101364, 99049, 100661, 99753, 99541, 99750, 99748, 99521, 99515, 99129, 98909, 98906, 98904, 98902, 99065, 99315, 99126, 99037, 99035, 99070, 99056, 97689, 99043, 99042, 98758, 98769, 98748, 78809, 78807, 98721, 98333, 98342, 84970, 97685, 98007, 94055, 88009, 94053, 97982, 97980, 97976, 97465, 97463, 97852, 97229, 97850, 97677, 97389, 94051, 97459, 97386, 97211, 97382, 97380, 82883, 66802, 97163, 97131, 97114, 96911, 96597, 81519, 96220, 96212, 96216, 94049, 95586, 94894, 94023, 94042, 94040, 93407, 93613, 93425, 93396, 93394, 93392, 93389, 92998, 73032, 87337, 93208, 89327, 92544, 91723, 89540, 91573, 92467, 92442, 92440, 92435, 91711, 88857, 91646, 91557, 91551, 89724, 89618, 89899, 89722, 89610, 89870, 89264, 89531, 89571, 89261, 89259, 89417, 89525, 89467, 89465, 89462, 89427, 88555, 88905, 89408, 89003, 89222, 89277, 89247, 65900, 89093, 89091, 89088, 88923, 88898, 88760, 88836, 88758, 88673, 88444, 87466, 88441, 88398, 88422, 88321, 88390, 88045, 88315, 80494, 80491, 87628, 86040, 87736, 87464, 87565, 87852, 87910, 87615, 87873, 87799, 87651, 87703, 87149, 87583, 87684, 87463, 87461, 87458, 86961))
Run Time: 0.042017
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1623 | |
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 | | | | | 1623 | |
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 (15254, 14402, 14260, 13155, 13064, 12589, 12513, 12512, 12511, 12126, 11901, 11898, 11805, 11795, 11672, 11633, 11033, 10889, 10873, 10848, 10523, 10372, 10362, 10346, 10257, 9750, 9605, 9486, 9391, 9285, 9173, 9163, 9026, 8990, 8975, 8973, 8915, 8913, 8809, 8714, 8702, 8681, 8664, 8663, 8645, 8644, 8606, 8597, 8585, 8463, 8462, 8428, 8345, 8256, 8186, 8185, 8082, 8065, 8006, 7910, 7853, 7850, 7768, 7730, 7715, 7710, 7703, 7652, 7632, 7630, 7589, 7557))
Run Time: 0.002417
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 72 | 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.000257
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.000411
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.000629
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: 1716173486
Run Time: 0.000496
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` >= 1716173486)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000790
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