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.000721
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.000223
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` = '411')
LIMIT 1
Run Time: 0.000421
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.002123
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_411' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.065424
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 (348067, 467002, 382590, 382589, 382585, 382584, 382833, 382581, 382554, 378602, 314230, 370692, 356919, 357550, 357147, 352053, 352052, 342072, 55997, 348762, 343717, 343715, 341278, 339875, 206702, 328983, 333089, 332277, 271383, 327591, 328061, 326438, 318692, 321944, 319440, 315529, 306564, 317480, 316145, 315007, 314275, 313709, 313534, 313276, 311266, 301278, 310737, 311684, 311682, 311954, 310718, 311688, 311796, 311428, 310689, 311426, 189746, 297401, 299494, 308201, 310379, 310377, 310588, 310438, 310374, 121895, 307742, 310371, 308187, 310369, 307739, 307736, 307733, 307731, 306686, 33963, 306909, 307587, 307584, 306087, 301399, 270505, 304812, 303817, 302442, 301762, 301275, 301273, 300866, 297260, 297707, 293736, 297704, 297371, 295716, 295808, 297393, 297403, 293757, 291231, 282675, 284212, 273167, 273159, 277700, 278139, 269753, 268686, 270797, 270668, 83474, 270603, 269958, 269632, 266231, 266224, 265253, 258094, 257631, 256822, 256816, 256377, 256376, 256372, 253379, 255316, 248099, 255421, 255311, 249513, 254522, 254331, 250176, 250548, 203010, 249511, 250535, 249879, 248958, 222658, 249003, 248945, 247847, 248297, 248292, 248407, 247834, 248087, 247893, 247915, 247904, 247913, 247811, 204200, 206287, 222601, 247483, 142904, 247367, 247302, 222304, 222328, 235201, 222223, 222501, 222302, 222541, 222299, 222296, 208326, 142897, 171345, 143208, 206923, 206909, 206842, 202424, 206832, 202422, 204336, 203860, 203954, 203930, 203739, 203442, 203421, 203290, 201866, 202903, 203270, 203238, 167086, 201862, 201859, 201857, 202228, 202452, 202421, 201913, 195241, 194378, 136972, 136970, 195197, 195177, 172816, 194550, 194548, 192330, 193829, 194287, 194285, 194282, 194137, 194185, 194183, 193919, 193856, 193855, 193917, 193808, 193905, 194007, 193902, 193624, 192874, 192132, 191341, 191335, 190259, 187310, 187375, 187289, 172815, 185432, 172813, 185475, 172811, 183292, 183285, 183670, 183165, 183283, 183278, 183666, 183275, 183161, 183273, 183152, 183354, 175495, 181806, 183548, 183270, 183148, 182335, 181989, 182568, 181803, 183263, 183260, 181982, 182013, 181795, 174956, 83180, 174812, 174986, 173936, 172808, 173934, 174689, 174753, 174739, 172806, 173373, 173520, 173494, 173583, 173534, 164437, 160627, 173501, 157963, 170239, 173497, 157907, 173073, 172553, 171383, 173060, 172486, 172764, 172725, 172148, 172143, 171381, 172108, 172129, 172125, 172123, 172116, 170711, 171379, 165327, 171377, 171841, 165326, 171258, 171838, 171375, 171373, 171133, 163305, 171415, 169847, 171371, 171265, 170932, 171150, 170649, 170580, 171071, 169536, 171068, 170808, 170871, 164771, 170572, 165728, 165272, 166881, 123675, 163100, 167561, 164726, 150902, 161504, 149419, 153634, 153669, 151589, 153073, 144413, 153632, 153340, 149165, 149120, 149101, 150898, 151578, 149064, 147216, 149682, 148965, 150889, 148628, 150397, 150380, 148796, 148623, 148794, 148790, 148620, 149665, 148619, 148616, 148613, 148595, 148611, 148590, 148458, 148357, 148005, 129778, 144758, 112110, 144814, 145027, 145068, 144803, 144800, 144823, 138023, 138020, 141387, 141924, 141381, 129777, 129774, 141378, 138972, 138947, 141294, 138945, 138941, 140488, 138086, 139833, 138906, 129772, 138555, 140004, 138815, 129770, 138789, 138785, 138459, 138773, 18217, 127508, 18196, 138304, 18183, 129768, 138456, 129765, 129763, 138189, 137391, 138279, 137368, 137357, 137354, 129761, 137347, 137337, 137251, 129760, 137200, 135532, 95408, 95405, 95403, 95753, 95747, 95705, 95635, 95631, 95170, 95627, 95168, 94635, 95166, 81674, 95616, 95564, 81302, 94949, 94946, 95205, 94944, 94942, 94940, 89579, 94938, 81300, 95075, 94722, 81298, 94100, 94712, 94702, 94593, 94094, 90358, 94914, 94824, 90355, 94696, 94091, 94762, 94820, 94694, 94692, 94816, 94690, 94760, 93811, 94757, 93981, 93979, 93804, 94755, 93783, 94446, 94445, 93781, 93778, 94681, 79284, 94678, 93977, 94575, 94439, 93975, 90320, 94357, 94353, 94351, 94349, 36732, 81289, 81287, 81285, 81272, 81270, 94391, 92732, 94345, 81269, 81266, 89864, 94234, 81264, 85688, 94188, 94139, 94077, 94137, 93942, 87066, 94027, 93715, 93937, 87062, 93935, 93756, 93971, 93968, 93656, 93506, 93029, 81259, 81256, 93593, 81254, 93501, 93493, 81246, 93272, 78371, 93433, 93269, 93049, 93012, 92819, 92885, 89215, 92593, 92536, 92531, 92524, 92522, 91671, 92504, 86864, 88217, 91667, 91758, 91665, 92480, 89704, 91662, 90912, 90000, 91756, 88744, 91658, 7971, 89310, 89309, 89487, 75009, 86509, 89413, 89203, 89411, 89409, 89407, 89307, 89114, 86153, 88603, 88599, 88597, 84498, 88038, 88482, 88479, 84495, 88510, 88505, 86982, 87790, 87843, 85908, 87234, 87788, 87404, 87219, 87111, 87214, 87074, 86950, 86389, 86945, 86942, 86838, 86705, 86730, 86726, 86677, 86675, 86178, 86133, 86348, 81359, 85174, 85894, 85751, 85747, 84390, 73856, 85709, 85410, 85466, 85459, 84722, 85163, 85160, 84923, 83266, 85340, 85149, 84714, 85131, 84827, 84954, 84939, 84921, 84823, 84818, 84698, 84628, 84457, 84692, 84591, 84757, 84814, 84812, 84656, 84782, 84753, 84451, 84442, 84440, 84744, 84438, 84685, 81811, 84435, 84431, 84574, 84429, 82259, 84422, 84416, 84412, 84158, 83117, 84290, 83898, 83115, 84331, 84266, 83896, 84254, 84268, 84213, 84113, 83652, 84013, 83352, 84010, 82714, 83783, 7952, 7950, 82709, 83347, 83104, 80950, 80946, 80944, 82697, 82696, 83573, 83570, 83568, 82691, 83548, 76460, 83003, 82793, 82680, 82679, 82672, 82791, 76961, 82667, 82664, 82935, 82934, 82932, 83400, 83411, 83398, 82790, 82852, 82788, 82751, 72299, 83364, 82749, 76167, 78243, 83378, 82930, 82379, 83086, 83083, 82920, 82915, 82913, 82849, 60441, 81790, 81966, 82643, 81150, 81148, 82080, 80455, 82399, 82365, 81662, 81956, 81772, 81805, 81632, 81623, 81619, 81219, 81608, 81595, 81593, 78362, 81497, 80751, 81197, 81193, 81192, 81119, 81352, 72742, 81187, 81116, 81141, 81113, 81138, 81107, 80722, 80895, 69856, 80383, 80328, 79708, 80199, 77324, 79660, 79697, 78650, 79250, 79246, 78631, 79206, 78619, 78832, 79111, 79109, 78611, 78608, 78829, 78828, 78602, 77711, 78742, 78592, 78672, 78711, 78399, 78394, 77785, 76435, 76183, 76433, 75601, 75655, 76289, 76246, 70116, 76218, 76216, 76214, 76264, 70113, 74645, 76248, 74643, 76116, 75864, 75938, 75646, 74641, 74639, 70111, 75954, 76180, 75903, 76209, 76138, 68424, 76099, 68422, 75804, 76097, 75899, 75788, 70106, 75848, 75895, 75872, 75765, 75356, 70102, 70099, 70097, 74477, 74810, 73956, 74474, 74592, 74683, 74535, 73897, 73920, 73247, 73245, 73867, 73422, 73520, 73420, 73239, 72798, 72336, 71745, 71890, 69426, 70719, 66951, 68689, 70463, 70458, 69985, 69610, 70057, 70017, 70055, 70047, 69982, 69283, 69548, 70015, 69344, 69340, 69893, 69334, 69602, 66037, 66034, 69330, 23990, 64652, 69422, 69560, 23987, 69565, 69529, 69275, 68622, 68619, 69134, 68600, 69081, 69054, 69079, 69049, 66032, 67974, 61873, 68141, 68968, 68139, 68966, 68612, 68137, 68683, 68598, 68610, 68596, 68134, 68677, 68607, 18063, 68515, 68525, 68326, 68508, 67664, 67662, 23961, 67660, 66425, 68339, 68215, 23958, 68127, 68172, 68170, 61712, 68123, 68121, 68119, 68098, 67859, 66404, 66401, 67845, 67843, 67840, 66698, 66902, 64799, 66270, 66889, 67360, 67283, 67238, 67227, 67215, 67188, 67173, 67171, 62383, 67088, 66127, 62380, 66392, 66852, 67068, 66765, 62362, 66387, 66757, 66383, 66568, 50229, 66244, 62745, 66484, 60263, 65156, 66053, 66234, 66172, 66166, 66108, 66050, 63835, 66046, 65999, 65996, 65966, 65928, 65984, 65964, 63474, 65196, 65636, 65359, 65357, 64858, 65323, 65074, 65385, 65343, 65341, 65034, 64021, 61077, 61136, 65030, 57023, 64976, 63816, 63814, 63812, 63809, 63807, 63090, 64637, 64605, 64545, 64531, 63802, 64251, 63793, 63055, 63791, 63789, 63051, 63766, 62672, 63763, 18045, 59568, 62936, 63622, 63620, 63301, 63299, 59563, 62925, 63317, 61822, 62805, 63449, 63447, 62523, 63315, 62905, 63210, 62902, 62900, 62516, 59735, 62893, 62891, 62889, 59732, 62654, 62872, 62652, 62868, 62646, 62862, 62846, 62812, 62706, 62573, 62570, 62561, 57460, 62421, 62416, 62329, 62225, 62082, 62044, 62074, 62049, 61926, 50628, 59991, 59988, 59271, 60252, 59871, 60270, 60064, 60062, 56756, 59868, 59797, 59577, 59251, 59558, 59575, 59555, 59552, 59007, 59337, 58882, 57328, 58857, 57843, 57958, 56744, 56632, 56604, 56143, 56383, 54747, 55969, 56264, 55826, 56339, 56249, 56232, 55681, 23797, 55822, 56114, 56109, 55872, 44296, 56026, 55886, 56005, 56003, 56012, 56000, 55813, 55883, 55864, 54914, 55811, 55860, 54910, 55755, 55809, 42353, 55582, 55796, 55743, 55794, 55787, 55767, 55674, 55672, 55725, 55731, 54906, 55634, 55645, 55573, 55543, 47269, 44415, 44413, 55319, 55293, 55291, 54619, 54832, 54776, 54391, 54712, 51499, 54175, 52200, 54613, 50197, 50195, 54610, 54388, 54550, 54529, 54526, 50794, 54400, 54398, 52432, 50192, 54251, 54241, 54182, 54171, 53820, 53818, 53994, 53807, 53910, 53805, 53801, 52141, 53799, 53451, 53780, 53777, 48251, 48249, 53641, 53639, 53605, 48247, 53447, 53376, 53439, 53435, 53373, 53246, 51664, 53240, 52288, 52280, 52275, 52272, 52264, 52260, 52256, 52253, 52960, 52807, 52245, 52243, 52344, 52682, 52389, 52567, 50617, 52731, 50186, 52515, 52512, 52692, 52510, 52508, 52506, 50181, 52503, 51939, 51937, 51935, 52424, 50177, 52383, 50171, 52227, 52577, 52563, 52562, 50169, 50162, 52414, 52524, 52408, 50158, 47915, 50153, 50150, 50146, 50141, 50139, 52376, 50135, 52374, 52365, 52361, 50614, 50129, 51910, 51926, 52173, 51905, 52007, 51903, 51900, 52093, 52002, 50114, 51991, 50601, 50111, 50597, 51893, 47801, 48502, 45365, 48499, 51755, 50105, 50103, 51771, 51786, 50589, 47792, 47790, 50571, 51570, 47780, 51479, 51392, 47540, 51253, 50568, 51361, 50565, 49874, 49955, 49953, 51008, 50923, 49951, 51095, 51037, 50561, 50919, 50334, 50559, 50557, 50911, 50909, 51116, 51099, 50954, 50555, 51090, 34896, 50763, 49782, 50546, 50543, 49777, 50898, 49623, 50895, 49773, 50892, 50873, 50869, 50540, 49949, 49947, 50538, 50533, 50727, 50721, 49617, 50670, 49944, 49854, 50036, 50529, 50033, 50522, 50031, 50490, 49847, 49843, 50097, 48815, 49829, 49828, 49827, 49755, 50024, 49823, 50022, 50020, 49159, 50001, 49821, 49818, 49816, 49997, 49690, 49743, 49741, 49812, 49811, 49687, 49807, 49981, 49923, 49224, 49804, 49797, 49682, 49679, 49677, 49676, 49674, 49672, 49575, 49668, 49665, 49737, 49735, 49732, 49570, 49730, 49662, 49568, 49656, 49562, 49560, 49521, 49558, 49556, 49554, 49551, 49721, 49719, 49717, 49651, 49549, 48681, 49532, 49530, 49526, 49523, 49377, 48679, 49375, 48677, 49514, 47533, 49412, 49408, 49405, 49368, 49365, 49324, 34891, 49283, 49322, 49320, 49318, 34886, 49016, 48994, 48725, 48863, 48825, 48842, 48810, 48518, 48674, 45678, 48548, 48546, 48544, 48785, 48642, 48706, 48568, 48532, 48579, 48485, 48452, 48419, 48244, 48407, 48389, 48242, 48271, 48240, 48269, 36359, 47744, 42350, 48239, 47735, 47350, 39901, 48237, 48220, 47903, 47728, 47726, 48216, 47724, 48214, 47418, 48211, 48203, 47895, 38485, 48201, 47480, 45763, 45761, 47704, 47917, 47702, 45759, 45757, 47600, 47413, 47411, 9600, 47450, 45753, 45752, 47530, 45748, 47528, 45746, 45744, 47398, 47462, 47390, 47386, 47428, 45356, 45339, 47374, 47372, 45336, 45334, 47334, 46865, 46863, 46986, 46860, 47013, 46858, 47006, 46434, 45332, 38001, 46247, 37999, 46020, 46536, 46376, 46373, 46357, 45546, 46167, 37275, 43033, 46180, 42567, 45456, 45454, 45452, 45544, 45542, 46114, 46085, 46112, 45450, 46073, 45447, 46070, 45888, 45886, 45443, 46038, 38328, 45997, 46035, 39840, 39836, 39833, 45539, 45890, 45883, 45536, 45641, 41561, 45591, 45647, 45587, 45330, 45602, 45371, 44943, 45533, 45329, 45530, 45527, 41067, 40189, 45525, 39827, 45436, 39826, 45324, 45434, 45493, 44561, 45491, 45167, 45164, 45489, 43463, 44575, 45320, 45430, 42284, 43081, 37823, 45276, 45370, 33398, 43078, 45273, 45268, 45162, 45160, 40188, 45158, 40187, 40185, 40183, 43894, 45175, 45152, 45150, 45147, 40181, 43858, 43449, 40178, 45092, 45091, 45088, 45087, 43855, 42804, 43416, 43999, 43414, 44937, 43411, 44543, 43409, 43997, 44768, 44714, 44746, 44675, 44630, 44696, 44628, 43404, 43946, 43399, 43569, 44625, 43944, 44622, 44621, 43011, 43942, 44615, 44619, 44555, 43940, 44558, 43938, 42231, 44439, 43006, 43004, 44374, 42997, 44326, 43671, 42926, 43196, 44219, 44226, 42483, 23772, 44060, 44053, 42608, 44050, 42606, 44043, 42604, 44009, 44024, 43931, 43929, 43477, 42772, 42770, 43567, 43474, 42602, 42600, 43324, 43564, 43922, 43974, 42598, 43446, 43918, 43444, 43320, 43559, 43556, 43317, 43315, 43913, 43642, 43640, 43637, 43890, 40175, 43443, 40173, 43311, 43440, 43396, 43873, 43394, 43438, 43845, 43684, 42594, 43309, 42592, 43693, 40171, 43841, 43850, 43387, 43304, 43839, 43301, 43383, 43296, 43549, 43381, 43634, 43292, 43690, 43632, 43290, 43282, 43279, 43276, 43530, 43274, 43435, 43467, 43433, 43270, 43193, 43267, 43431, 43265, 43262, 43259, 42957, 43257, 43255, 42954, 43378, 43374, 42739, 43340, 43339, 43336, 42737, 42069, 43212, 41274, 43191, 43223, 43240, 43121, 43249, 42869, 43237, 43178, 43117, 37908, 43188, 43204, 43202, 43200, 43168, 43186, 43166, 37906, 43069, 43115, 43164, 42614, 42612, 42563, 42575, 35287, 41854, 41974, 42173, 39615, 39265, 39008, 41552, 40759, 41548, 41544, 41254, 40152, 41539, 41501, 41494, 40884, 41464, 40882, 40880, 41250, 40878, 40876, 40874, 40872, 40871, 40801, 41316, 41314, 40170, 41342, 37820, 33394, 41307, 40901, 41184, 41289, 41240, 41179, 41092, 39143, 39141, 39139, 39137, 39347, 40070, 39980, 39134, 40112, 28489, 39131, 39129, 28486, 39126, 39345, 40025, 39121, 35262, 39119, 28480, 39117, 35605, 39343, 39815, 39339, 40009, 39973, 39998, 39115, 39113, 39786, 39922, 39587, 28476, 39110, 39581, 28473, 39336, 39784, 39782, 39813, 28470, 39853, 39887, 39885, 36579, 39860, 39811, 39850, 39846, 39844, 39842, 39817, 36575, 39332, 39705, 39701, 39699, 39106, 39104, 36570, 39779, 39777, 39775, 39773, 39697, 39694, 39692, 39575, 39679, 39573, 39329, 39326, 39564, 39102, 33889, 38223, 39486, 37867, 39396, 39447, 39437, 39394, 39305, 39301, 39392, 39312, 39400, 39310, 39390, 39384, 39381, 38711, 37895, 38709, 38773, 38706, 38704, 38792, 36428, 36426, 38702, 39067, 39098, 39049, 3153, 38918, 37864, 39047, 37862, 38841, 39044, 38529, 39040, 39062, 39060, 38787, 38785, 39058, 37747, 38700, 39038, 39056, 38916, 36418, 36411, 36409, 38943, 33777, 33774, 33771, 38920, 3151, 38463, 38913, 38819, 38836, 38460, 38864, 38854, 38458, 38810, 38833, 38808, 38372, 37860, 38828, 38805, 38778, 38695, 38694, 38772, 38770, 38692, 38769, 38600, 38598, 38596, 38690, 38687, 38418, 38673, 33874, 38416, 38667, 38643, 38665, 38395, 38641, 33871, 38454, 38587, 38633, 33869, 38326, 38447, 37857, 38508, 37854, 38404, 38445, 38387, 37850, 38369, 38556, 38525, 38518, 38514, 38512, 38415, 38411, 33522, 33588, 38406, 38380, 38323, 38321, 33584, 38317, 38315, 33581, 31721, 38276, 3147, 38274, 38271, 38313, 24504, 23730, 37891, 38312, 38310, 20873, 37888, 24499, 38299, 20870, 20868, 38306, 38304, 38262, 37882, 24494, 38240, 38216, 38178, 24491, 35876, 38176, 24488, 24486, 37880, 24484, 24481, 35873, 24477, 29741, 24471, 24468, 38158, 38162, 38140, 25274, 38106, 38063, 29738, 38103, 38156, 38100, 38125, 38098, 38095, 38128, 37729, 38088, 38086, 38084, 38069, 38035, 37956, 37988, 31783, 37809, 37871, 35739, 37831, 37803, 37800, 37796, 37405, 37727, 37732, 37379, 37724, 37377, 31170, 37403, 37688, 37594, 37375, 37346, 37344, 37388, 37295, 37342, 37369, 37338, 37336, 37367, 33849, 37364, 36266, 37333, 36328, 35818, 36506, 36399, 35706, 31760, 36598, 36591, 36566, 36478, 36544, 36477, 35657, 17278, 36142, 36465, 36249, 36244, 36241, 36211, 36238, 35735, 36185, 35733, 35889, 33806, 35842, 35839, 35017, 35836, 33726, 35014, 35833, 35725, 35815, 24741, 17996, 35318, 21524, 35791, 35164, 35461, 34793, 35035, 3144, 35502, 3138, 35445, 34791, 35400, 35387, 29434, 35238, 25573, 25570, 35301, 35276, 35234, 35232, 35229, 34694, 25463, 32201, 35144, 35067, 35065, 27180, 34978, 34561, 34846, 34692, 34844, 34690, 34775, 34773, 34689, 34789, 34781, 34687, 30854, 33214, 34685, 34683, 34595, 34679, 34699, 34677, 34697, 34673, 34558, 34535, 27451, 34214, 33565, 33341, 34207, 33797, 31934, 34051, 33721, 33744, 27717, 33558, 33956, 33791, 33952, 33897, 33789, 33787, 33504, 33077, 32869, 32160, 28618, 31909, 31905, 32032, 31801, 31800, 30540, 25691, 31825, 25689, 20857, 30537, 28875, 31670, 26308, 3127, 31683, 31667, 31394, 29937, 11786, 29927, 31496, 29925, 29922, 29920, 29918, 30923, 30921, 31318, 30918, 29909, 30916, 29907, 29046, 29894, 31224, 30913, 31150, 31061, 31162, 31056, 30911, 30966, 30964, 30788, 30993, 30959, 30908, 30515, 30799, 30739, 23573, 3995, 30567, 30565, 30532, 30530, 30528, 15266, 30513, 30510, 3993, 30526, 30507, 30523, 30506, 30408, 29661, 29660, 29656, 29652, 30461, 29650, 29649, 29646, 30459, 30368, 30393, 24524, 20816, 29642, 30377, 30361, 29639, 7920, 29638, 29634, 15259, 28401, 29798, 22179, 30084, 30005, 30132, 28384, 30003, 30001, 30041, 30039, 30037, 29999, 29174, 29795, 29793, 7915, 7912, 7910, 29810, 28371, 28368, 28366, 28361, 29360, 29806, 29594, 29358, 29592, 29787, 29771, 29623, 29620, 29617, 29614, 29714, 28342, 29631, 25110, 29606, 29604, 29356, 28950, 15951, 29419, 28948, 28945, 28309, 29387, 28306, 22756, 22754, 29376, 29373, 27332, 27494, 28293, 29289, 27350, 29351, 29337, 28291, 27329, 28942, 28285, 28268, 29184, 29181, 28258, 28253, 28247, 28240, 28224, 28941, 27058, 28219, 28217, 29133, 25107, 20579, 28206, 28200, 28197, 27759, 28939, 28815, 28813, 28185, 28978, 28806, 28804, 28963, 28802, 28800, 28961, 28798, 28180, 27490, 28954, 28952, 28174, 28163, 28159, 28795, 27488, 27916, 28144, 28824, 28665, 27485, 28123, 28109, 27964, 27756, 28083, 28660, 27940, 27912, 27909, 27145, 24739, 27661, 27783, 27776, 24737, 24735, 27657, 27774, 24733, 27742, 27652, 24846, 21514, 24731, 27217, 27338, 27480, 24729, 27335, 24727, 27000, 27295, 9962, 9981))
Run Time: 0.103470
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2479 | |
PRIMARY | xf_post | eq_ref | PRIMARY | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
PRIMARY | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_post.thread_id | 1 | |
PRIMARY | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread_Thread_1.node_id | 1 | Using where |
PRIMARY | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_2.node_id | 1 | Using where |
PRIMARY | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_post.user_id | 1 | |
PRIMARY | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_3.node_id | 1 | Using where |
MATERIALIZED | <derived3> | ALL | | | | | 2479 | |
DERIVED | | | | | | | | No tables used |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 180
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (19245, 19192, 18541, 17560, 17014, 15622, 15369, 14243, 13925, 13829, 13631, 13156, 13080, 13018, 12893, 12861, 12708, 12565, 12388, 12305, 12245, 11870, 11715, 11694, 11673, 11506, 11460, 11402, 11372, 11329, 11324, 10454, 10187, 9689, 7947, 7935, 7924, 7917, 7907, 7855, 7833, 7823, 7750, 7635, 7534, 7367, 7294, 7266, 7265, 7263, 7254, 7247, 7210, 7115, 7017, 6720, 6683, 6561, 6486, 6155, 6097, 6041, 6025, 6018, 6016, 6014, 6013, 5973, 5972, 5903, 5889, 5868, 5865, 5842, 5787, 5760, 5673, 5660, 5592, 5431, 5378, 5367, 5317, 5299, 5218, 5106, 5036, 5025, 5023, 4926, 4865, 4852, 4780, 4738, 4578, 4527, 4520, 4516, 4515, 4509, 4490, 4380, 4354, 4199, 4149, 4148, 4053, 4047, 4045, 4035, 4019, 4009, 3894, 3858, 3854, 3832, 3822, 3745, 3740, 3707, 3698, 3675, 3673, 3644, 3639, 3622, 3619, 3593, 3586, 3584, 3578, 3562, 3552, 3528, 3520, 3475, 3401, 3378, 3375, 3320, 3278, 3247, 3238, 3237, 3224, 3168, 2942, 2916, 2875, 2874, 2863, 2827, 2822, 2790, 2765, 2723, 2701, 2673, 2660, 2652, 2630, 2618, 2617))
Run Time: 0.006442
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 163 | 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 (348067, 467002, 382590, 382589, 382585, 382584, 382833, 382581, 382554, 378602, 314230, 370692, 356919, 357550, 357147, 352053, 352052, 342072, 55997, 348762, 343717, 343715, 341278, 339875, 206702, 328983, 333089, 332277, 271383, 327591, 328061, 326438, 318692, 321944, 319440, 315529, 306564, 317480, 316145, 315007, 314275, 313709, 313534, 313276, 311266, 301278, 310737, 311684, 311682, 311954, 310718, 311688, 311796, 311428, 310689, 311426, 189746, 297401, 299494, 308201, 310379, 310377, 310588, 310438, 310374, 121895, 307742, 310371, 308187, 310369, 307739, 307736, 307733, 307731, 306686, 33963, 306909, 307587, 307584, 306087, 301399, 270505, 304812, 303817, 302442, 301762, 301275, 301273, 300866, 297260, 297707, 293736, 297704, 297371, 295716, 295808, 297393, 297403, 293757, 291231, 282675, 284212, 273167, 273159, 277700, 278139, 269753, 268686, 270797, 270668, 83474, 270603, 269958, 269632, 266231, 266224, 265253, 258094, 257631, 256822, 256816, 256377, 256376, 256372, 253379, 255316, 248099, 255421, 255311, 249513, 254522, 254331, 250176, 250548, 203010, 249511, 250535, 249879, 248958, 222658, 249003, 248945, 247847, 248297, 248292, 248407, 247834, 248087, 247893, 247915, 247904, 247913, 247811, 204200, 206287, 222601, 247483, 142904, 247367, 247302, 222304, 222328, 235201, 222223, 222501, 222302, 222541, 222299, 222296, 208326, 142897, 171345, 143208, 206923, 206909, 206842, 202424, 206832, 202422, 204336, 203860, 203954, 203930, 203739, 203442, 203421, 203290, 201866, 202903, 203270, 203238, 167086, 201862, 201859, 201857, 202228, 202452, 202421, 201913, 195241, 194378, 136972, 136970, 195197, 195177, 172816, 194550, 194548, 192330, 193829, 194287, 194285, 194282, 194137, 194185, 194183, 193919, 193856, 193855, 193917, 193808, 193905, 194007, 193902, 193624, 192874, 192132, 191341, 191335, 190259, 187310, 187375, 187289, 172815, 185432, 172813, 185475, 172811, 183292, 183285, 183670, 183165, 183283, 183278, 183666, 183275, 183161, 183273, 183152, 183354, 175495, 181806, 183548, 183270, 183148, 182335, 181989, 182568, 181803, 183263, 183260, 181982, 182013, 181795, 174956, 83180, 174812, 174986, 173936, 172808, 173934, 174689, 174753, 174739, 172806, 173373, 173520, 173494, 173583, 173534, 164437, 160627, 173501, 157963, 170239, 173497, 157907, 173073, 172553, 171383, 173060, 172486, 172764, 172725, 172148, 172143, 171381, 172108, 172129, 172125, 172123, 172116, 170711, 171379, 165327, 171377, 171841, 165326, 171258, 171838, 171375, 171373, 171133, 163305, 171415, 169847, 171371, 171265, 170932, 171150, 170649, 170580, 171071, 169536, 171068, 170808, 170871, 164771, 170572, 165728, 165272, 166881, 123675, 163100, 167561, 164726, 150902, 161504, 149419, 153634, 153669, 151589, 153073, 144413, 153632, 153340, 149165, 149120, 149101, 150898, 151578, 149064, 147216, 149682, 148965, 150889, 148628, 150397, 150380, 148796, 148623, 148794, 148790, 148620, 149665, 148619, 148616, 148613, 148595, 148611, 148590, 148458, 148357, 148005, 129778, 144758, 112110, 144814, 145027, 145068, 144803, 144800, 144823, 138023, 138020, 141387, 141924, 141381, 129777, 129774, 141378, 138972, 138947, 141294, 138945, 138941, 140488, 138086, 139833, 138906, 129772, 138555, 140004, 138815, 129770, 138789, 138785, 138459, 138773, 18217, 127508, 18196, 138304, 18183, 129768, 138456, 129765, 129763, 138189, 137391, 138279, 137368, 137357, 137354, 129761, 137347, 137337, 137251, 129760, 137200, 135532, 95408, 95405, 95403, 95753, 95747, 95705, 95635, 95631, 95170, 95627, 95168, 94635, 95166, 81674, 95616, 95564, 81302, 94949, 94946, 95205, 94944, 94942, 94940, 89579, 94938, 81300, 95075, 94722, 81298, 94100, 94712, 94702, 94593, 94094, 90358, 94914, 94824, 90355, 94696, 94091, 94762, 94820, 94694, 94692, 94816, 94690, 94760, 93811, 94757, 93981, 93979, 93804, 94755, 93783, 94446, 94445, 93781, 93778, 94681, 79284, 94678, 93977, 94575, 94439, 93975, 90320, 94357, 94353, 94351, 94349, 36732, 81289, 81287, 81285, 81272, 81270, 94391, 92732, 94345, 81269, 81266, 89864, 94234, 81264, 85688, 94188, 94139, 94077, 94137, 93942, 87066, 94027, 93715, 93937, 87062, 93935, 93756, 93971, 93968, 93656, 93506, 93029, 81259, 81256, 93593, 81254, 93501, 93493, 81246, 93272, 78371, 93433, 93269, 93049, 93012, 92819, 92885, 89215, 92593, 92536, 92531, 92524, 92522, 91671, 92504, 86864, 88217, 91667, 91758, 91665, 92480, 89704, 91662, 90912, 90000, 91756, 88744, 91658, 7971, 89310, 89309, 89487, 75009, 86509, 89413, 89203, 89411, 89409, 89407, 89307, 89114, 86153, 88603, 88599, 88597, 84498, 88038, 88482, 88479, 84495, 88510, 88505, 86982, 87790, 87843, 85908, 87234, 87788, 87404, 87219, 87111, 87214, 87074, 86950, 86389, 86945, 86942, 86838, 86705, 86730, 86726, 86677, 86675, 86178, 86133, 86348, 81359, 85174, 85894, 85751, 85747, 84390, 73856, 85709, 85410, 85466, 85459, 84722, 85163, 85160, 84923, 83266, 85340, 85149, 84714, 85131, 84827, 84954, 84939, 84921, 84823, 84818, 84698, 84628, 84457, 84692, 84591, 84757, 84814, 84812, 84656, 84782, 84753, 84451, 84442, 84440, 84744, 84438, 84685, 81811, 84435, 84431, 84574, 84429, 82259, 84422, 84416, 84412, 84158, 83117, 84290, 83898, 83115, 84331, 84266, 83896, 84254, 84268, 84213, 84113, 83652, 84013, 83352, 84010, 82714, 83783, 7952, 7950, 82709, 83347, 83104, 80950, 80946, 80944, 82697, 82696, 83573, 83570, 83568, 82691, 83548, 76460, 83003, 82793, 82680, 82679, 82672, 82791, 76961, 82667, 82664, 82935, 82934, 82932, 83400, 83411, 83398, 82790, 82852, 82788, 82751, 72299, 83364, 82749, 76167, 78243, 83378, 82930, 82379, 83086, 83083, 82920, 82915, 82913, 82849, 60441, 81790, 81966, 82643, 81150, 81148, 82080, 80455, 82399, 82365, 81662, 81956, 81772, 81805, 81632, 81623, 81619, 81219, 81608, 81595, 81593, 78362, 81497, 80751, 81197, 81193, 81192, 81119, 81352, 72742, 81187, 81116, 81141, 81113, 81138, 81107, 80722, 80895, 69856, 80383, 80328, 79708, 80199, 77324, 79660, 79697, 78650, 79250, 79246, 78631, 79206, 78619, 78832, 79111, 79109, 78611, 78608, 78829, 78828, 78602, 77711, 78742, 78592, 78672, 78711, 78399, 78394, 77785, 76435, 76183, 76433, 75601, 75655, 76289, 76246, 70116, 76218, 76216, 76214, 76264, 70113, 74645, 76248, 74643, 76116, 75864, 75938, 75646, 74641, 74639, 70111, 75954, 76180, 75903, 76209, 76138, 68424, 76099, 68422, 75804, 76097, 75899, 75788, 70106, 75848, 75895, 75872, 75765, 75356, 70102, 70099, 70097, 74477, 74810, 73956, 74474, 74592, 74683, 74535, 73897, 73920, 73247, 73245, 73867, 73422, 73520, 73420, 73239, 72798, 72336, 71745, 71890, 69426, 70719, 66951, 68689, 70463, 70458, 69985, 69610, 70057, 70017, 70055, 70047, 69982, 69283, 69548, 70015, 69344, 69340, 69893, 69334, 69602, 66037, 66034, 69330, 23990, 64652, 69422, 69560, 23987, 69565, 69529, 69275, 68622, 68619, 69134, 68600, 69081, 69054, 69079, 69049, 66032, 67974, 61873, 68141, 68968, 68139, 68966, 68612, 68137, 68683, 68598, 68610, 68596, 68134, 68677, 68607, 18063, 68515, 68525, 68326, 68508, 67664, 67662, 23961, 67660, 66425, 68339, 68215, 23958, 68127, 68172, 68170, 61712, 68123, 68121, 68119, 68098, 67859, 66404, 66401, 67845, 67843, 67840, 66698, 66902, 64799, 66270, 66889, 67360, 67283, 67238, 67227, 67215, 67188, 67173, 67171, 62383, 67088, 66127, 62380, 66392, 66852, 67068, 66765, 62362, 66387, 66757, 66383, 66568, 50229, 66244, 62745, 66484, 60263, 65156, 66053, 66234, 66172, 66166, 66108, 66050, 63835, 66046, 65999, 65996, 65966, 65928, 65984, 65964, 63474, 65196, 65636, 65359, 65357, 64858, 65323, 65074, 65385, 65343, 65341, 65034, 64021, 61077, 61136, 65030, 57023, 64976, 63816, 63814, 63812, 63809, 63807, 63090, 64637, 64605, 64545, 64531, 63802, 64251, 63793, 63055, 63791, 63789, 63051, 63766, 62672, 63763, 18045, 59568, 62936, 63622, 63620, 63301, 63299, 59563, 62925, 63317, 61822, 62805, 63449, 63447, 62523, 63315, 62905, 63210, 62902, 62900, 62516, 59735, 62893, 62891, 62889, 59732, 62654, 62872, 62652, 62868, 62646, 62862, 62846, 62812, 62706, 62573, 62570, 62561, 57460, 62421, 62416, 62329, 62225, 62082, 62044, 62074, 62049, 61926, 50628, 59991, 59988, 59271, 60252, 59871, 60270, 60064, 60062, 56756, 59868, 59797, 59577, 59251, 59558, 59575, 59555, 59552, 59007, 59337, 58882, 57328, 58857, 57843, 57958, 56744, 56632, 56604, 56143, 56383, 54747, 55969, 56264, 55826, 56339, 56249, 56232, 55681, 23797, 55822, 56114, 56109, 55872, 44296, 56026, 55886, 56005, 56003, 56012, 56000, 55813, 55883, 55864, 54914, 55811, 55860, 54910, 55755, 55809, 42353, 55582, 55796, 55743, 55794, 55787, 55767, 55674, 55672, 55725, 55731, 54906, 55634, 55645, 55573, 55543, 47269, 44415, 44413, 55319, 55293, 55291, 54619, 54832, 54776, 54391, 54712, 51499, 54175, 52200, 54613, 50197, 50195, 54610, 54388, 54550, 54529, 54526, 50794, 54400, 54398, 52432, 50192, 54251, 54241, 54182, 54171, 53820, 53818, 53994, 53807, 53910, 53805, 53801, 52141, 53799, 53451, 53780, 53777, 48251, 48249, 53641, 53639, 53605, 48247, 53447, 53376, 53439, 53435, 53373, 53246, 51664, 53240, 52288, 52280, 52275, 52272, 52264, 52260, 52256, 52253, 52960, 52807, 52245, 52243, 52344, 52682, 52389, 52567, 50617, 52731, 50186, 52515, 52512, 52692, 52510, 52508, 52506, 50181, 52503, 51939, 51937, 51935, 52424, 50177, 52383, 50171, 52227, 52577, 52563, 52562, 50169, 50162, 52414, 52524, 52408, 50158, 47915, 50153, 50150, 50146, 50141, 50139, 52376, 50135, 52374, 52365, 52361, 50614, 50129, 51910, 51926, 52173, 51905, 52007, 51903, 51900, 52093, 52002, 50114, 51991, 50601, 50111, 50597, 51893, 47801, 48502, 45365, 48499, 51755, 50105, 50103, 51771, 51786, 50589, 47792, 47790, 50571, 51570, 47780, 51479, 51392, 47540, 51253, 50568, 51361, 50565, 49874, 49955, 49953, 51008, 50923, 49951, 51095, 51037, 50561, 50919, 50334, 50559, 50557, 50911, 50909, 51116, 51099, 50954, 50555, 51090, 34896, 50763, 49782, 50546, 50543, 49777, 50898, 49623, 50895, 49773, 50892, 50873, 50869, 50540, 49949, 49947, 50538, 50533, 50727, 50721, 49617, 50670, 49944, 49854, 50036, 50529, 50033, 50522, 50031, 50490, 49847, 49843, 50097, 48815, 49829, 49828, 49827, 49755, 50024, 49823, 50022, 50020, 49159, 50001, 49821, 49818, 49816, 49997, 49690, 49743, 49741, 49812, 49811, 49687, 49807, 49981, 49923, 49224, 49804, 49797, 49682, 49679, 49677, 49676, 49674, 49672, 49575, 49668, 49665, 49737, 49735, 49732, 49570, 49730, 49662, 49568, 49656, 49562, 49560, 49521, 49558, 49556, 49554, 49551, 49721, 49719, 49717, 49651, 49549, 48681, 49532, 49530, 49526, 49523, 49377, 48679, 49375, 48677, 49514, 47533, 49412, 49408, 49405, 49368, 49365, 49324, 34891, 49283, 49322, 49320, 49318, 34886, 49016, 48994, 48725, 48863, 48825, 48842, 48810, 48518, 48674, 45678, 48548, 48546, 48544, 48785, 48642, 48706, 48568, 48532, 48579, 48485, 48452, 48419, 48244, 48407, 48389, 48242, 48271, 48240, 48269, 36359, 47744, 42350, 48239, 47735, 47350, 39901, 48237, 48220, 47903, 47728, 47726, 48216, 47724, 48214, 47418, 48211, 48203, 47895, 38485, 48201, 47480, 45763, 45761, 47704, 47917, 47702, 45759, 45757, 47600, 47413, 47411, 9600, 47450, 45753, 45752, 47530, 45748, 47528, 45746, 45744, 47398, 47462, 47390, 47386, 47428, 45356, 45339, 47374, 47372, 45336, 45334, 47334, 46865, 46863, 46986, 46860, 47013, 46858, 47006, 46434, 45332, 38001, 46247, 37999, 46020, 46536, 46376, 46373, 46357, 45546, 46167, 37275, 43033, 46180, 42567, 45456, 45454, 45452, 45544, 45542, 46114, 46085, 46112, 45450, 46073, 45447, 46070, 45888, 45886, 45443, 46038, 38328, 45997, 46035, 39840, 39836, 39833, 45539, 45890, 45883, 45536, 45641, 41561, 45591, 45647, 45587, 45330, 45602, 45371, 44943, 45533, 45329, 45530, 45527, 41067, 40189, 45525, 39827, 45436, 39826, 45324, 45434, 45493, 44561, 45491, 45167, 45164, 45489, 43463, 44575, 45320, 45430, 42284, 43081, 37823, 45276, 45370, 33398, 43078, 45273, 45268, 45162, 45160, 40188, 45158, 40187, 40185, 40183, 43894, 45175, 45152, 45150, 45147, 40181, 43858, 43449, 40178, 45092, 45091, 45088, 45087, 43855, 42804, 43416, 43999, 43414, 44937, 43411, 44543, 43409, 43997, 44768, 44714, 44746, 44675, 44630, 44696, 44628, 43404, 43946, 43399, 43569, 44625, 43944, 44622, 44621, 43011, 43942, 44615, 44619, 44555, 43940, 44558, 43938, 42231, 44439, 43006, 43004, 44374, 42997, 44326, 43671, 42926, 43196, 44219, 44226, 42483, 23772, 44060, 44053, 42608, 44050, 42606, 44043, 42604, 44009, 44024, 43931, 43929, 43477, 42772, 42770, 43567, 43474, 42602, 42600, 43324, 43564, 43922, 43974, 42598, 43446, 43918, 43444, 43320, 43559, 43556, 43317, 43315, 43913, 43642, 43640, 43637, 43890, 40175, 43443, 40173, 43311, 43440, 43396, 43873, 43394, 43438, 43845, 43684, 42594, 43309, 42592, 43693, 40171, 43841, 43850, 43387, 43304, 43839, 43301, 43383, 43296, 43549, 43381, 43634, 43292, 43690, 43632, 43290, 43282, 43279, 43276, 43530, 43274, 43435, 43467, 43433, 43270, 43193, 43267, 43431, 43265, 43262, 43259, 42957, 43257, 43255, 42954, 43378, 43374, 42739, 43340, 43339, 43336, 42737, 42069, 43212, 41274, 43191, 43223, 43240, 43121, 43249, 42869, 43237, 43178, 43117, 37908, 43188, 43204, 43202, 43200, 43168, 43186, 43166, 37906, 43069, 43115, 43164, 42614, 42612, 42563, 42575, 35287, 41854, 41974, 42173, 39615, 39265, 39008, 41552, 40759, 41548, 41544, 41254, 40152, 41539, 41501, 41494, 40884, 41464, 40882, 40880, 41250, 40878, 40876, 40874, 40872, 40871, 40801, 41316, 41314, 40170, 41342, 37820, 33394, 41307, 40901, 41184, 41289, 41240, 41179, 41092, 39143, 39141, 39139, 39137, 39347, 40070, 39980, 39134, 40112, 28489, 39131, 39129, 28486, 39126, 39345, 40025, 39121, 35262, 39119, 28480, 39117, 35605, 39343, 39815, 39339, 40009, 39973, 39998, 39115, 39113, 39786, 39922, 39587, 28476, 39110, 39581, 28473, 39336, 39784, 39782, 39813, 28470, 39853, 39887, 39885, 36579, 39860, 39811, 39850, 39846, 39844, 39842, 39817, 36575, 39332, 39705, 39701, 39699, 39106, 39104, 36570, 39779, 39777, 39775, 39773, 39697, 39694, 39692, 39575, 39679, 39573, 39329, 39326, 39564, 39102, 33889, 38223, 39486, 37867, 39396, 39447, 39437, 39394, 39305, 39301, 39392, 39312, 39400, 39310, 39390, 39384, 39381, 38711, 37895, 38709, 38773, 38706, 38704, 38792, 36428, 36426, 38702, 39067, 39098, 39049, 3153, 38918, 37864, 39047, 37862, 38841, 39044, 38529, 39040, 39062, 39060, 38787, 38785, 39058, 37747, 38700, 39038, 39056, 38916, 36418, 36411, 36409, 38943, 33777, 33774, 33771, 38920, 3151, 38463, 38913, 38819, 38836, 38460, 38864, 38854, 38458, 38810, 38833, 38808, 38372, 37860, 38828, 38805, 38778, 38695, 38694, 38772, 38770, 38692, 38769, 38600, 38598, 38596, 38690, 38687, 38418, 38673, 33874, 38416, 38667, 38643, 38665, 38395, 38641, 33871, 38454, 38587, 38633, 33869, 38326, 38447, 37857, 38508, 37854, 38404, 38445, 38387, 37850, 38369, 38556, 38525, 38518, 38514, 38512, 38415, 38411, 33522, 33588, 38406, 38380, 38323, 38321, 33584, 38317, 38315, 33581, 31721, 38276, 3147, 38274, 38271, 38313, 24504, 23730, 37891, 38312, 38310, 20873, 37888, 24499, 38299, 20870, 20868, 38306, 38304, 38262, 37882, 24494, 38240, 38216, 38178, 24491, 35876, 38176, 24488, 24486, 37880, 24484, 24481, 35873, 24477, 29741, 24471, 24468, 38158, 38162, 38140, 25274, 38106, 38063, 29738, 38103, 38156, 38100, 38125, 38098, 38095, 38128, 37729, 38088, 38086, 38084, 38069, 38035, 37956, 37988, 31783, 37809, 37871, 35739, 37831, 37803, 37800, 37796, 37405, 37727, 37732, 37379, 37724, 37377, 31170, 37403, 37688, 37594, 37375, 37346, 37344, 37388, 37295, 37342, 37369, 37338, 37336, 37367, 33849, 37364, 36266, 37333, 36328, 35818, 36506, 36399, 35706, 31760, 36598, 36591, 36566, 36478, 36544, 36477, 35657, 17278, 36142, 36465, 36249, 36244, 36241, 36211, 36238, 35735, 36185, 35733, 35889, 33806, 35842, 35839, 35017, 35836, 33726, 35014, 35833, 35725, 35815, 24741, 17996, 35318, 21524, 35791, 35164, 35461, 34793, 35035, 3144, 35502, 3138, 35445, 34791, 35400, 35387, 29434, 35238, 25573, 25570, 35301, 35276, 35234, 35232, 35229, 34694, 25463, 32201, 35144, 35067, 35065, 27180, 34978, 34561, 34846, 34692, 34844, 34690, 34775, 34773, 34689, 34789, 34781, 34687, 30854, 33214, 34685, 34683, 34595, 34679, 34699, 34677, 34697, 34673, 34558, 34535, 27451, 34214, 33565, 33341, 34207, 33797, 31934, 34051, 33721, 33744, 27717, 33558, 33956, 33791, 33952, 33897, 33789, 33787, 33504, 33077, 32869, 32160, 28618, 31909, 31905, 32032, 31801, 31800, 30540, 25691, 31825, 25689, 20857, 30537, 28875, 31670, 26308, 3127, 31683, 31667, 31394, 29937, 11786, 29927, 31496, 29925, 29922, 29920, 29918, 30923, 30921, 31318, 30918, 29909, 30916, 29907, 29046, 29894, 31224, 30913, 31150, 31061, 31162, 31056, 30911, 30966, 30964, 30788, 30993, 30959, 30908, 30515, 30799, 30739, 23573, 3995, 30567, 30565, 30532, 30530, 30528, 15266, 30513, 30510, 3993, 30526, 30507, 30523, 30506, 30408, 29661, 29660, 29656, 29652, 30461, 29650, 29649, 29646, 30459, 30368, 30393, 24524, 20816, 29642, 30377, 30361, 29639, 7920, 29638, 29634, 15259, 28401, 29798, 22179, 30084, 30005, 30132, 28384, 30003, 30001, 30041, 30039, 30037, 29999, 29174, 29795, 29793, 7915, 7912, 7910, 29810, 28371, 28368, 28366, 28361, 29360, 29806, 29594, 29358, 29592, 29787, 29771, 29623, 29620, 29617, 29614, 29714, 28342, 29631, 25110, 29606, 29604, 29356, 28950, 15951, 29419, 28948, 28945, 28309, 29387, 28306, 22756, 22754, 29376, 29373, 27332, 27494, 28293, 29289, 27350, 29351, 29337, 28291, 27329, 28942, 28285, 28268, 29184, 29181, 28258, 28253, 28247, 28240, 28224, 28941, 27058, 28219, 28217, 29133, 25107, 20579, 28206, 28200, 28197, 27759, 28939, 28815, 28813, 28185, 28978, 28806, 28804, 28963, 28802, 28800, 28961, 28798, 28180, 27490, 28954, 28952, 28174, 28163, 28159, 28795, 27488, 27916, 28144, 28824, 28665, 27485, 28123, 28109, 27964, 27756, 28083, 28660, 27940, 27912, 27909, 27145, 24739, 27661, 27783, 27776, 24737, 24735, 27657, 27774, 24733, 27742, 27652, 24846, 21514, 24731, 27217, 27338, 27480, 24729, 27335, 24727, 27000, 27295, 9962, 9981))
Run Time: 0.048557
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2479 | |
PRIMARY | xf_post | eq_ref | PRIMARY | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
PRIMARY | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_post.thread_id | 1 | |
PRIMARY | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread_Thread_1.node_id | 1 | Using where |
PRIMARY | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_2.node_id | 1 | Using where |
PRIMARY | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_post.user_id | 1 | |
PRIMARY | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_3.node_id | 1 | Using where |
MATERIALIZED | <derived3> | ALL | | | | | 2479 | |
DERIVED | | | | | | | | No tables used |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (19245, 19192, 18541, 17560, 17014, 15622, 15369, 14243, 13925, 13829, 13631, 13156, 13080, 13018, 12893, 12861, 12708, 12565, 12388, 12305, 12245, 11870, 11715, 11694, 11673, 11506, 11460, 11402, 11372, 11329, 11324, 10454, 10187, 9689, 7947, 7935, 7924, 7917, 7907, 7855, 7833, 7823, 7750, 7635, 7534, 7367, 7294, 7266, 7265, 7263, 7254, 7247, 7210, 7115, 7017, 6720, 6683, 6561, 6486, 6155, 6097, 6041, 6025, 6018, 6016, 6014, 6013, 5973, 5972, 5903, 5889, 5868, 5865, 5842, 5787, 5760, 5673, 5660, 5592, 5431, 5378, 5367, 5317, 5299, 5218, 5106, 5036, 5025, 5023, 4926, 4865, 4852, 4780, 4738, 4578, 4527, 4520, 4516, 4515, 4509, 4490, 4380, 4354, 4199, 4149, 4148, 4053, 4047, 4045, 4035, 4019, 4009, 3894, 3858, 3854, 3832, 3822, 3745, 3740, 3707, 3698, 3675, 3673, 3644, 3639, 3622, 3619, 3593, 3586, 3584, 3578, 3562, 3552, 3528, 3520, 3475, 3401, 3378, 3375, 3320, 3278, 3247, 3238, 3237, 3224, 3168, 2942, 2916, 2875, 2874, 2863, 2827, 2822, 2790, 2765, 2723, 2701, 2673, 2660, 2652, 2630, 2618, 2617))
Run Time: 0.005673
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 163 | 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.000280
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.000503
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.000793
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: 1716174348
Run Time: 0.000404
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 10 | 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` >= 1716174348)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000513
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 10 | 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