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.000706
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.000238
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` = '4493')
LIMIT 1
Run Time: 0.000471
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.002998
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_4493' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.064510
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 (535432, 343805, 206052, 432555, 108816, 108812, 244549, 244547, 244545, 432127, 431951, 431928, 431871, 244459, 553025, 529441, 527684, 553022, 553008, 562782, 431655, 560910, 507916, 244139, 527660, 244008, 328427, 389180, 353140, 429272, 429249, 429237, 232556, 429199, 232542, 328425, 243967, 539335, 429164, 429159, 429118, 232536, 429106, 535417, 232526, 232525, 537449, 243877, 528003, 528001, 535332, 535775, 535329, 535326, 199948, 527546, 243814, 521958, 389166, 428626, 428560, 243780, 243711, 243650, 199865, 519873, 328421, 470854, 205891, 501811, 518436, 516968, 479687, 516950, 507099, 402732, 463555, 514332, 514211, 232083, 362412, 362408, 614587, 427629, 132759, 199747, 511428, 243474, 243446, 243442, 243411, 468316, 501976, 354453, 426195, 426010, 497933, 242896, 231169, 470847, 321008, 467101, 490449, 389147, 425497, 242698, 242693, 472599, 490072, 472591, 472585, 425494, 425487, 489492, 624589, 320942, 230788, 488807, 488525, 488654, 488651, 624584, 420691, 472571, 230783, 425237, 472564, 486605, 485095, 485091, 425169, 425160, 205764, 230660, 132701, 425151, 369055, 449856, 230646, 484237, 242511, 460928, 242494, 242491, 242489, 242481, 132674, 325192, 323920, 483238, 323919, 425087, 472545, 482095, 230552, 132651, 424999, 242292, 477884, 242230, 472540, 320878, 373579, 107856, 474245, 198857, 473770, 448602, 242146, 205719, 242109, 472366, 465772, 198814, 470824, 242075, 242051, 198702, 320813, 198700, 424452, 230078, 216997, 466134, 198676, 355831, 241918, 468141, 230024, 230022, 198646, 241887, 241842, 424327, 424274, 424247, 456123, 465855, 424159, 205643, 463049, 450822, 450818, 241651, 424038, 424036, 241612, 424033, 461671, 424014, 461479, 461472, 378790, 461021, 461240, 229794, 107636, 241570, 458055, 241475, 241454, 206392, 241430, 398056, 132308, 398052, 198272, 324287, 456852, 216617, 456796, 216614, 198262, 229700, 456510, 241374, 320661, 456098, 456006, 450769, 455145, 453347, 325815, 328368, 455729, 455604, 423847, 229608, 453334, 423838, 423834, 454976, 229574, 107601, 454543, 107598, 107590, 420529, 241302, 449924, 453325, 107555, 452719, 206388, 229540, 241274, 404920, 450765, 450763, 452211, 452160, 452246, 132267, 452150, 265492, 229493, 216444, 451815, 451706, 241192, 451508, 318311, 241174, 451550, 450737, 450735, 450732, 380168, 198098, 450180, 450728, 449356, 451004, 450999, 229442, 450670, 450539, 448102, 448098, 450033, 450116, 448095, 450107, 449905, 216399, 241117, 449902, 449852, 198062, 229389, 398049, 198053, 449500, 341734, 449173, 216351, 449260, 423104, 449280, 449278, 229367, 449233, 229365, 132257, 449231, 371253, 381571, 416370, 449028, 449022, 322356, 410920, 448956, 448905, 448949, 410918, 448903, 448854, 448941, 448881, 411644, 448935, 419151, 359922, 359918, 241070, 448090, 448842, 383641, 241047, 241044, 448080, 448078, 448074, 448070, 448068, 229348, 216320, 448741, 423774, 241036, 448522, 241032, 241027, 241025, 423772, 328357, 448306, 308789, 448389, 345775, 448261, 448259, 448256, 448062, 448053, 324815, 241005, 448041, 229317, 404917, 423125, 229311, 229309, 447952, 421156, 421154, 447882, 421152, 229303, 409801, 423732, 423764, 423746, 423741, 447873, 447870, 229296, 240995, 198019, 386814, 381564, 423726, 328355, 423714, 328348, 229283, 240966, 229231, 229220, 421647, 240959, 423420, 381560, 421822, 240951, 240948, 422745, 423091, 423116, 107377, 421103, 132249, 198002, 421099, 107375, 421096, 423062, 324270, 198000, 388087, 229190, 421644, 421642, 413265, 422773, 322350, 324813, 421089, 422755, 421084, 422741, 320540, 320535, 421079, 421072, 132242, 422558, 322347, 422122, 422189, 422187, 422181, 132213, 422030, 422149, 421815, 415493, 216232, 216230, 420074, 420072, 132201, 324811, 420220, 132194, 421811, 420070, 421338, 421626, 421589, 381557, 322901, 229089, 197954, 324269, 406332, 346390, 419717, 406325, 420197, 240858, 420496, 420053, 420034, 240854, 240802, 197931, 229060, 132186, 240772, 377243, 229036, 417451, 240747, 416584, 107309, 188709, 132179, 418762, 107305, 107302, 229033, 132170, 356364, 240713, 417130, 417122, 614456, 417072, 240683, 240679, 416163, 205516, 416031, 240602, 240577, 375211, 375208, 132128, 240552, 414469, 240542, 414312, 413249, 413700, 132112, 413697, 228862, 411262, 228850, 228848, 228840, 215961, 228836, 240507, 240502, 413218, 240500, 240496, 328335, 413130, 412893, 411223, 411218, 228801, 215938, 412805, 107227, 412663, 107213, 389933, 412661, 412803, 412647, 412671, 412635, 412633, 412628, 206377, 411204, 389916, 197759, 240466, 389912, 197757, 215919, 206368, 206351, 206341, 206338, 206332, 320474, 215905, 206304, 320471, 320467, 320464, 228753, 132089, 240431, 362302, 362298, 362292, 132081, 320461, 320455, 228741, 228734, 197733, 362285, 228732, 410648, 410643, 410579, 240412, 410573, 410564, 240409, 240401, 240396, 228707, 395536, 362263, 240356, 395533, 197708, 362255, 197701, 240347, 320450, 320446, 228657, 107137, 228655, 107133, 409299, 240292, 215760, 409079, 240271, 240266, 215751, 399918, 381527, 240254, 381521, 381518, 399902, 399899, 324256, 228505, 399894, 328320, 381515, 408718, 328315, 408713, 240209, 240157, 408206, 240149, 215714, 402082, 240147, 399411, 408086, 215709, 315684, 315682, 228469, 407989, 240135, 240130, 205502, 240127, 405698, 228436, 405691, 197593, 407706, 407702, 407699, 107105, 107096, 407418, 228403, 228401, 228399, 228395, 215673, 406031, 407409, 228384, 401919, 323883, 240058, 323881, 401916, 107090, 405590, 228356, 362251, 197567, 401898, 228351, 406900, 362249, 197560, 401882, 362246, 197557, 107074, 399238, 240009, 215660, 239995, 401843, 401841, 401839, 239989, 228321, 239986, 368696, 228313, 406736, 398811, 406538, 228300, 402631, 239971, 406536, 406529, 406534, 400038, 329290, 406114, 405531, 239954, 406145, 406003, 171772, 405672, 400034, 171768, 405529, 405527, 239948, 405524, 405997, 405995, 228255, 107015, 405992, 215626, 405987, 107013, 405518, 405981, 107008, 404422, 405393, 405516, 405582, 405141, 404557, 405573, 171758, 405571, 171755, 405387, 402006, 320436, 405032, 23396, 215603, 405030, 405371, 403084, 405483, 405368, 404418, 399220, 362243, 132066, 228235, 171750, 367069, 403639, 239938, 174254, 335698, 403666, 368786, 366768, 402222, 403562, 403633, 378706, 398048, 333491, 171736, 197387, 239857, 403067, 403061, 403087, 110113, 197380, 367042, 309979, 401583, 402073, 239847, 215500, 106896, 378689, 378687, 402937, 106894, 378684, 402934, 378682, 239842, 402903, 402900, 106887, 239834, 239634, 400836, 228116, 239631, 399149, 228110, 389527, 228108, 228105, 389680, 400442, 132026, 368783, 387166, 400440, 400494, 369022, 228095, 215364, 324693, 387161, 391860, 132006, 362132, 228091, 369018, 400257, 362128, 132000, 400245, 400243, 400235, 391352, 399863, 215327, 399625, 391855, 399861, 399623, 400203, 345562, 205439, 397050, 106841, 399972, 399134, 399639, 228070, 228067, 205421, 228064, 205416, 205413, 398628, 398626, 383035, 310539, 228057, 129007, 399525, 239585, 239582, 228037, 98022, 239571, 239565, 399129, 399123, 228034, 399115, 367025, 398950, 391351, 391349, 106804, 239551, 399099, 239542, 106799, 205405, 106792, 394713, 322254, 239535, 228014, 197266, 398905, 398903, 228011, 398894, 239525, 379813, 228006, 330044, 227995, 323840, 227993, 205401, 227990, 227988, 131975, 227986, 318282, 227984, 131965, 215274, 398738, 391607, 390447, 368778, 227970, 239498, 398435, 398231, 227952, 389672, 197229, 197225, 397770, 239471, 397767, 398173, 397765, 328301, 215252, 227939, 398170, 239456, 239451, 106771, 398018, 398016, 239447, 397677, 227929, 215245, 358492, 397673, 397836, 227927, 106766, 207364, 397741, 369015, 397667, 397719, 197214, 397664, 227922, 369013, 389669, 397653, 106759, 397651, 397553, 254061, 397647, 397641, 254059, 227916, 360798, 171676, 367017, 106744, 239438, 239432, 389662, 397040, 616947, 197184, 387824, 397475, 397033, 397031, 396893, 395514, 396601, 396885, 227879, 392495, 396909, 227876, 396881, 239422, 205389, 239420, 227874, 239418, 227869, 396799, 227867, 227866, 386742, 227861, 378768, 205336, 197120, 324231, 325762, 227793, 131944, 227789, 227787, 395635, 215160, 395689, 239364, 227784, 197103, 395666, 616862, 616858, 394339, 395458, 395456, 197085, 364704, 131935, 239357, 395438, 395436, 395434, 395431, 364693, 239345, 395427, 239342, 239336, 227776, 378765, 254055, 394857, 394855, 394764, 131925, 394853, 239317, 393744, 392527, 239315, 239313, 254042, 239310, 392525, 239307, 314409, 394772, 393974, 393972, 357846, 197064, 325167, 239302, 393740, 394688, 394562, 227740, 131922, 239277, 393168, 394353, 239273, 197047, 392823, 616820, 394349, 394191, 394046, 394305, 394298, 394184, 392452, 131899, 616817, 227722, 393332, 197034, 387809, 392448, 393328, 392439, 393984, 392436, 389909, 389905, 393716, 366762, 366760, 386734, 393610, 215075, 393190, 239244, 372600, 239230, 344783, 329060, 616792, 392813, 106608, 215052, 227693, 392749, 392809, 227683, 392800, 392717, 392742, 392711, 315659, 227673, 392657, 392708, 197016, 227671, 315657, 392673, 360793, 239195, 239193, 383813, 392384, 371527, 616774, 392568, 197009, 349364, 383806, 392376, 616767, 391844, 387619, 227663, 383803, 616762, 215032, 392353, 215029, 387617, 390366, 383793, 616755, 616753, 391659, 344772, 239166, 347659, 239151, 239147, 227653, 391828, 239144, 357843, 391824, 392047, 227649, 390358, 215010, 616730, 616722, 390015, 390353, 196977, 390348, 391634, 616713, 131886, 390345, 391590, 391603, 390009, 390104, 391585, 391528, 239108, 391599, 308764, 387534, 387532, 389653, 391518, 391567, 325373, 131882, 391516, 387529, 391412, 371498, 391408, 371494, 391364, 387610, 390717, 227634, 174230, 391327, 239045, 214986, 389897, 227632, 391276, 391297, 239031, 616688, 239029, 390714, 227614, 616674, 390903, 390755, 227595, 390753, 337143, 390330, 387791, 387787, 378545, 371485, 387978, 214959, 389746, 239021, 390317, 390313, 390264, 196960, 239019, 387976, 616642, 389999, 386701, 390200, 616640, 390185, 389996, 239010, 389124, 239007, 106570, 238992, 214952, 389888, 308755, 389992, 390193, 214949, 616630, 616628, 389880, 389978, 389976, 389577, 616626, 238958, 389872, 616622, 238954, 238952, 616620, 196945, 238946, 616618, 196943, 238942, 389569, 388650, 238929, 389562, 196935, 375195, 238901, 238898, 238896, 389120, 227568, 227560, 389115, 389107, 388634, 388632, 387573, 337141, 387571, 386973, 387456, 387318, 386965, 386963, 386398, 227525, 227523, 238832, 294232, 227515, 372891, 238819, 375191, 354423, 376569, 375185, 214808, 227488, 386417, 227460, 386306, 238814, 214789, 386442, 238811, 238809, 214779, 386413, 386411, 238807, 348330, 386363, 386407, 386390, 386152, 358344, 238782, 386150, 371478, 386250, 238779, 386369, 386343, 238777, 386376, 386148, 371475, 386291, 196894, 227438, 106472, 386286, 358113, 385619, 386144, 238746, 386141, 348300, 227413, 385658, 227411, 386139, 386132, 238715, 357202, 385589, 385568, 227407, 385472, 385098, 227394, 196887, 368996, 156246, 376838, 382209, 238653, 382206, 382204, 106423, 196884, 376079, 331062, 106397, 294216, 294213, 227348, 238612, 196859, 384544, 384439, 238607, 294207, 238605, 384437, 383683, 106381, 383217, 383576, 214565, 368990, 325164, 366945, 238553, 382200, 372476, 366942, 325162, 354414, 227256, 382146, 227250, 214484, 382000, 366330, 366328, 381490, 330848, 376062, 196817, 376059, 325491, 381667, 381320, 196799, 373306, 378741, 377949, 378669, 379547, 379557, 379691, 378667, 23357, 23355, 379543, 23353, 379538, 325748, 196774, 334536, 214442, 214433, 379021, 214429, 379019, 379054, 322229, 214427, 379017, 379050, 214425, 214417))
Run Time: 0.108529
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1445 | |
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 | | | | | 1445 | |
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 (22408, 22020, 21752, 20202, 20049, 19696, 19432, 19121))
Run Time: 0.001988
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 8 | 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 (535432, 343805, 206052, 432555, 108816, 108812, 244549, 244547, 244545, 432127, 431951, 431928, 431871, 244459, 553025, 529441, 527684, 553022, 553008, 562782, 431655, 560910, 507916, 244139, 527660, 244008, 328427, 389180, 353140, 429272, 429249, 429237, 232556, 429199, 232542, 328425, 243967, 539335, 429164, 429159, 429118, 232536, 429106, 535417, 232526, 232525, 537449, 243877, 528003, 528001, 535332, 535775, 535329, 535326, 199948, 527546, 243814, 521958, 389166, 428626, 428560, 243780, 243711, 243650, 199865, 519873, 328421, 470854, 205891, 501811, 518436, 516968, 479687, 516950, 507099, 402732, 463555, 514332, 514211, 232083, 362412, 362408, 614587, 427629, 132759, 199747, 511428, 243474, 243446, 243442, 243411, 468316, 501976, 354453, 426195, 426010, 497933, 242896, 231169, 470847, 321008, 467101, 490449, 389147, 425497, 242698, 242693, 472599, 490072, 472591, 472585, 425494, 425487, 489492, 624589, 320942, 230788, 488807, 488525, 488654, 488651, 624584, 420691, 472571, 230783, 425237, 472564, 486605, 485095, 485091, 425169, 425160, 205764, 230660, 132701, 425151, 369055, 449856, 230646, 484237, 242511, 460928, 242494, 242491, 242489, 242481, 132674, 325192, 323920, 483238, 323919, 425087, 472545, 482095, 230552, 132651, 424999, 242292, 477884, 242230, 472540, 320878, 373579, 107856, 474245, 198857, 473770, 448602, 242146, 205719, 242109, 472366, 465772, 198814, 470824, 242075, 242051, 198702, 320813, 198700, 424452, 230078, 216997, 466134, 198676, 355831, 241918, 468141, 230024, 230022, 198646, 241887, 241842, 424327, 424274, 424247, 456123, 465855, 424159, 205643, 463049, 450822, 450818, 241651, 424038, 424036, 241612, 424033, 461671, 424014, 461479, 461472, 378790, 461021, 461240, 229794, 107636, 241570, 458055, 241475, 241454, 206392, 241430, 398056, 132308, 398052, 198272, 324287, 456852, 216617, 456796, 216614, 198262, 229700, 456510, 241374, 320661, 456098, 456006, 450769, 455145, 453347, 325815, 328368, 455729, 455604, 423847, 229608, 453334, 423838, 423834, 454976, 229574, 107601, 454543, 107598, 107590, 420529, 241302, 449924, 453325, 107555, 452719, 206388, 229540, 241274, 404920, 450765, 450763, 452211, 452160, 452246, 132267, 452150, 265492, 229493, 216444, 451815, 451706, 241192, 451508, 318311, 241174, 451550, 450737, 450735, 450732, 380168, 198098, 450180, 450728, 449356, 451004, 450999, 229442, 450670, 450539, 448102, 448098, 450033, 450116, 448095, 450107, 449905, 216399, 241117, 449902, 449852, 198062, 229389, 398049, 198053, 449500, 341734, 449173, 216351, 449260, 423104, 449280, 449278, 229367, 449233, 229365, 132257, 449231, 371253, 381571, 416370, 449028, 449022, 322356, 410920, 448956, 448905, 448949, 410918, 448903, 448854, 448941, 448881, 411644, 448935, 419151, 359922, 359918, 241070, 448090, 448842, 383641, 241047, 241044, 448080, 448078, 448074, 448070, 448068, 229348, 216320, 448741, 423774, 241036, 448522, 241032, 241027, 241025, 423772, 328357, 448306, 308789, 448389, 345775, 448261, 448259, 448256, 448062, 448053, 324815, 241005, 448041, 229317, 404917, 423125, 229311, 229309, 447952, 421156, 421154, 447882, 421152, 229303, 409801, 423732, 423764, 423746, 423741, 447873, 447870, 229296, 240995, 198019, 386814, 381564, 423726, 328355, 423714, 328348, 229283, 240966, 229231, 229220, 421647, 240959, 423420, 381560, 421822, 240951, 240948, 422745, 423091, 423116, 107377, 421103, 132249, 198002, 421099, 107375, 421096, 423062, 324270, 198000, 388087, 229190, 421644, 421642, 413265, 422773, 322350, 324813, 421089, 422755, 421084, 422741, 320540, 320535, 421079, 421072, 132242, 422558, 322347, 422122, 422189, 422187, 422181, 132213, 422030, 422149, 421815, 415493, 216232, 216230, 420074, 420072, 132201, 324811, 420220, 132194, 421811, 420070, 421338, 421626, 421589, 381557, 322901, 229089, 197954, 324269, 406332, 346390, 419717, 406325, 420197, 240858, 420496, 420053, 420034, 240854, 240802, 197931, 229060, 132186, 240772, 377243, 229036, 417451, 240747, 416584, 107309, 188709, 132179, 418762, 107305, 107302, 229033, 132170, 356364, 240713, 417130, 417122, 614456, 417072, 240683, 240679, 416163, 205516, 416031, 240602, 240577, 375211, 375208, 132128, 240552, 414469, 240542, 414312, 413249, 413700, 132112, 413697, 228862, 411262, 228850, 228848, 228840, 215961, 228836, 240507, 240502, 413218, 240500, 240496, 328335, 413130, 412893, 411223, 411218, 228801, 215938, 412805, 107227, 412663, 107213, 389933, 412661, 412803, 412647, 412671, 412635, 412633, 412628, 206377, 411204, 389916, 197759, 240466, 389912, 197757, 215919, 206368, 206351, 206341, 206338, 206332, 320474, 215905, 206304, 320471, 320467, 320464, 228753, 132089, 240431, 362302, 362298, 362292, 132081, 320461, 320455, 228741, 228734, 197733, 362285, 228732, 410648, 410643, 410579, 240412, 410573, 410564, 240409, 240401, 240396, 228707, 395536, 362263, 240356, 395533, 197708, 362255, 197701, 240347, 320450, 320446, 228657, 107137, 228655, 107133, 409299, 240292, 215760, 409079, 240271, 240266, 215751, 399918, 381527, 240254, 381521, 381518, 399902, 399899, 324256, 228505, 399894, 328320, 381515, 408718, 328315, 408713, 240209, 240157, 408206, 240149, 215714, 402082, 240147, 399411, 408086, 215709, 315684, 315682, 228469, 407989, 240135, 240130, 205502, 240127, 405698, 228436, 405691, 197593, 407706, 407702, 407699, 107105, 107096, 407418, 228403, 228401, 228399, 228395, 215673, 406031, 407409, 228384, 401919, 323883, 240058, 323881, 401916, 107090, 405590, 228356, 362251, 197567, 401898, 228351, 406900, 362249, 197560, 401882, 362246, 197557, 107074, 399238, 240009, 215660, 239995, 401843, 401841, 401839, 239989, 228321, 239986, 368696, 228313, 406736, 398811, 406538, 228300, 402631, 239971, 406536, 406529, 406534, 400038, 329290, 406114, 405531, 239954, 406145, 406003, 171772, 405672, 400034, 171768, 405529, 405527, 239948, 405524, 405997, 405995, 228255, 107015, 405992, 215626, 405987, 107013, 405518, 405981, 107008, 404422, 405393, 405516, 405582, 405141, 404557, 405573, 171758, 405571, 171755, 405387, 402006, 320436, 405032, 23396, 215603, 405030, 405371, 403084, 405483, 405368, 404418, 399220, 362243, 132066, 228235, 171750, 367069, 403639, 239938, 174254, 335698, 403666, 368786, 366768, 402222, 403562, 403633, 378706, 398048, 333491, 171736, 197387, 239857, 403067, 403061, 403087, 110113, 197380, 367042, 309979, 401583, 402073, 239847, 215500, 106896, 378689, 378687, 402937, 106894, 378684, 402934, 378682, 239842, 402903, 402900, 106887, 239834, 239634, 400836, 228116, 239631, 399149, 228110, 389527, 228108, 228105, 389680, 400442, 132026, 368783, 387166, 400440, 400494, 369022, 228095, 215364, 324693, 387161, 391860, 132006, 362132, 228091, 369018, 400257, 362128, 132000, 400245, 400243, 400235, 391352, 399863, 215327, 399625, 391855, 399861, 399623, 400203, 345562, 205439, 397050, 106841, 399972, 399134, 399639, 228070, 228067, 205421, 228064, 205416, 205413, 398628, 398626, 383035, 310539, 228057, 129007, 399525, 239585, 239582, 228037, 98022, 239571, 239565, 399129, 399123, 228034, 399115, 367025, 398950, 391351, 391349, 106804, 239551, 399099, 239542, 106799, 205405, 106792, 394713, 322254, 239535, 228014, 197266, 398905, 398903, 228011, 398894, 239525, 379813, 228006, 330044, 227995, 323840, 227993, 205401, 227990, 227988, 131975, 227986, 318282, 227984, 131965, 215274, 398738, 391607, 390447, 368778, 227970, 239498, 398435, 398231, 227952, 389672, 197229, 197225, 397770, 239471, 397767, 398173, 397765, 328301, 215252, 227939, 398170, 239456, 239451, 106771, 398018, 398016, 239447, 397677, 227929, 215245, 358492, 397673, 397836, 227927, 106766, 207364, 397741, 369015, 397667, 397719, 197214, 397664, 227922, 369013, 389669, 397653, 106759, 397651, 397553, 254061, 397647, 397641, 254059, 227916, 360798, 171676, 367017, 106744, 239438, 239432, 389662, 397040, 616947, 197184, 387824, 397475, 397033, 397031, 396893, 395514, 396601, 396885, 227879, 392495, 396909, 227876, 396881, 239422, 205389, 239420, 227874, 239418, 227869, 396799, 227867, 227866, 386742, 227861, 378768, 205336, 197120, 324231, 325762, 227793, 131944, 227789, 227787, 395635, 215160, 395689, 239364, 227784, 197103, 395666, 616862, 616858, 394339, 395458, 395456, 197085, 364704, 131935, 239357, 395438, 395436, 395434, 395431, 364693, 239345, 395427, 239342, 239336, 227776, 378765, 254055, 394857, 394855, 394764, 131925, 394853, 239317, 393744, 392527, 239315, 239313, 254042, 239310, 392525, 239307, 314409, 394772, 393974, 393972, 357846, 197064, 325167, 239302, 393740, 394688, 394562, 227740, 131922, 239277, 393168, 394353, 239273, 197047, 392823, 616820, 394349, 394191, 394046, 394305, 394298, 394184, 392452, 131899, 616817, 227722, 393332, 197034, 387809, 392448, 393328, 392439, 393984, 392436, 389909, 389905, 393716, 366762, 366760, 386734, 393610, 215075, 393190, 239244, 372600, 239230, 344783, 329060, 616792, 392813, 106608, 215052, 227693, 392749, 392809, 227683, 392800, 392717, 392742, 392711, 315659, 227673, 392657, 392708, 197016, 227671, 315657, 392673, 360793, 239195, 239193, 383813, 392384, 371527, 616774, 392568, 197009, 349364, 383806, 392376, 616767, 391844, 387619, 227663, 383803, 616762, 215032, 392353, 215029, 387617, 390366, 383793, 616755, 616753, 391659, 344772, 239166, 347659, 239151, 239147, 227653, 391828, 239144, 357843, 391824, 392047, 227649, 390358, 215010, 616730, 616722, 390015, 390353, 196977, 390348, 391634, 616713, 131886, 390345, 391590, 391603, 390009, 390104, 391585, 391528, 239108, 391599, 308764, 387534, 387532, 389653, 391518, 391567, 325373, 131882, 391516, 387529, 391412, 371498, 391408, 371494, 391364, 387610, 390717, 227634, 174230, 391327, 239045, 214986, 389897, 227632, 391276, 391297, 239031, 616688, 239029, 390714, 227614, 616674, 390903, 390755, 227595, 390753, 337143, 390330, 387791, 387787, 378545, 371485, 387978, 214959, 389746, 239021, 390317, 390313, 390264, 196960, 239019, 387976, 616642, 389999, 386701, 390200, 616640, 390185, 389996, 239010, 389124, 239007, 106570, 238992, 214952, 389888, 308755, 389992, 390193, 214949, 616630, 616628, 389880, 389978, 389976, 389577, 616626, 238958, 389872, 616622, 238954, 238952, 616620, 196945, 238946, 616618, 196943, 238942, 389569, 388650, 238929, 389562, 196935, 375195, 238901, 238898, 238896, 389120, 227568, 227560, 389115, 389107, 388634, 388632, 387573, 337141, 387571, 386973, 387456, 387318, 386965, 386963, 386398, 227525, 227523, 238832, 294232, 227515, 372891, 238819, 375191, 354423, 376569, 375185, 214808, 227488, 386417, 227460, 386306, 238814, 214789, 386442, 238811, 238809, 214779, 386413, 386411, 238807, 348330, 386363, 386407, 386390, 386152, 358344, 238782, 386150, 371478, 386250, 238779, 386369, 386343, 238777, 386376, 386148, 371475, 386291, 196894, 227438, 106472, 386286, 358113, 385619, 386144, 238746, 386141, 348300, 227413, 385658, 227411, 386139, 386132, 238715, 357202, 385589, 385568, 227407, 385472, 385098, 227394, 196887, 368996, 156246, 376838, 382209, 238653, 382206, 382204, 106423, 196884, 376079, 331062, 106397, 294216, 294213, 227348, 238612, 196859, 384544, 384439, 238607, 294207, 238605, 384437, 383683, 106381, 383217, 383576, 214565, 368990, 325164, 366945, 238553, 382200, 372476, 366942, 325162, 354414, 227256, 382146, 227250, 214484, 382000, 366330, 366328, 381490, 330848, 376062, 196817, 376059, 325491, 381667, 381320, 196799, 373306, 378741, 377949, 378669, 379547, 379557, 379691, 378667, 23357, 23355, 379543, 23353, 379538, 325748, 196774, 334536, 214442, 214433, 379021, 214429, 379019, 379054, 322229, 214427, 379017, 379050, 214425, 214417))
Run Time: 0.030878
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1445 | |
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 | | | | | 1445 | |
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 (22408, 22020, 21752, 20202, 20049, 19696, 19432, 19121))
Run Time: 0.001123
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 8 | 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, �I�
Run Time: 0.000191
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.000325
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 215
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 158
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (120))
Run Time: 0.000540
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 158
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1717201385
Run Time: 0.000288
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 22 | 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` >= 1717201385)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.001011
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 22 | 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