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.000905
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.000195
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` = '2150')
LIMIT 1
Run Time: 0.000529
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.002099
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_2150' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.136659
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 (613013, 613012, 609777, 609774, 595707, 595705, 608271, 602002, 601998, 599154, 598911, 598909, 439865, 589489, 589487, 589484, 598643, 598638, 598677, 598545, 598490, 517450, 517446, 439827, 598116, 597837, 598034, 597833, 598005, 597823, 439691, 439270, 333974, 333971, 587236, 587093, 585979, 585972, 436471, 436465, 585909, 436462, 369259, 436460, 571055, 402792, 579387, 246035, 579385, 585267, 584385, 330497, 584944, 584943, 570690, 235139, 235137, 578738, 412491, 235135, 235132, 531056, 412485, 575480, 389237, 530623, 530619, 434019, 463721, 322560, 517381, 517379, 463710, 575399, 417885, 417880, 549722, 234360, 234330, 234311, 574714, 574712, 574710, 574708, 574354, 433649, 517365, 572702, 572700, 517361, 433574, 573644, 570681, 572691, 569668, 573625, 572503, 569663, 573623, 549689, 549684, 572441, 573622, 573594, 573590, 244750, 573576, 573573, 570673, 433092, 412358, 570671, 530051, 336335, 571120, 432990, 559514, 559513, 570669, 549665, 381838, 570262, 570261, 432790, 570650, 569625, 570257, 535981, 535979, 432669, 220695, 570233, 547162, 220687, 535975, 570230, 471253, 369185, 570228, 535967, 432660, 432657, 471235, 432651, 432642, 390697, 567610, 570087, 567605, 432526, 567603, 244591, 565198, 560259, 558701, 511486, 558699, 244342, 269061, 306440, 559029, 306438, 558697, 558694, 547915, 547913, 558689, 558687, 553305, 558272, 421999, 558433, 244281, 558005, 412271, 535867, 412267, 614622, 180962, 412265, 558324, 558322, 556314, 555716, 401046, 453600, 554832, 16302, 412245, 430940, 555112, 430828, 430824, 552658, 471226, 552539, 389226, 552055, 552526, 430819, 552050, 552045, 544232, 544228, 232887, 232885, 552018, 552246, 544226, 539268, 303349, 552271, 552263, 358898, 552016, 219867, 309450, 551245, 551371, 550746, 393305, 388885, 550267, 548249, 546864, 503674, 430042, 546862, 546596, 546860, 546858, 546856, 430040, 430036, 546837, 546818, 546816, 430004, 546404, 232735, 411350, 546399, 505226, 505224, 429974, 505215, 544736, 544735, 544733, 368277, 544731, 544728, 544725, 544624, 543604, 543602, 309388, 468546, 540131, 544371, 481626, 543589, 429719, 69689, 393831, 543993, 322512, 543586, 511023, 543583, 23491, 219570, 333774, 543519, 429613, 429596, 537664, 333770, 429572, 528448, 528447, 538822, 219438, 429094, 538755, 333758, 537477, 401327, 537610, 321170, 537550, 537548, 201597, 537418, 624807, 321166, 384372, 537198, 536943, 537197, 537135, 373525, 149485, 428951, 401040, 520396, 528431, 528429, 524237, 528063, 480473, 528122, 369106, 528144, 369102, 243801, 369100, 518743, 428752, 428750, 503576, 232343, 503574, 354350, 503572, 354346, 354342, 479530, 354340, 428740, 354338, 354335, 428732, 428725, 321161, 232338, 321159, 526947, 511419, 511416, 511414, 219271, 511411, 527406, 219269, 511407, 526996, 527318, 516910, 219221, 451731, 360012, 451729, 488183, 428674, 428661, 412027, 414852, 526594, 414850, 404684, 526592, 526590, 404682, 520506, 414848, 526585, 428642, 526583, 414846, 524001, 471182, 526491, 428619, 524083, 524080, 428615, 428608, 243797, 318360, 523849, 526488, 523847, 428591, 428562, 524011, 624787, 474076, 499277, 523863, 523829, 523784, 499275, 522769, 232306, 523511, 321142, 523317, 333728, 243787, 516907, 523308, 243779, 243770, 243767, 243765, 474069, 243755, 522582, 428415, 522580, 522578, 522401, 321133, 521532, 489800, 389164, 522074, 510780, 510777, 510775, 520847, 428392, 428387, 489797, 77964, 412005, 219104, 428337, 521528, 521525, 521521, 521661, 521516, 521344, 521512, 521502, 521510, 520883, 520893, 520842, 243648, 520838, 243646, 420924, 389705, 514315, 513889, 505191, 513886, 513880, 513868, 218774, 513091, 427698, 513720, 243535, 512973, 512968, 471141, 512921, 512918, 331323, 427635, 427625, 367368, 367366, 509114, 509112, 512290, 509110, 509108, 494703, 512042, 427568, 218644, 393055, 322484, 218629, 243496, 322481, 510772, 243481, 494691, 511175, 494688, 411972, 510770, 510768, 411960, 411958, 509880, 323573, 393045, 510467, 510465, 393040, 393037, 455432, 510463, 509863, 509848, 509844, 509842, 323567, 508686, 508682, 508680, 508678, 508674, 427087, 427066, 309236, 427019, 508095, 427016, 427014, 309198, 471133, 317150, 317144, 417817, 505177, 243198, 504702, 504700, 347949, 504546, 504544, 368227, 368225, 347938, 368222, 504284, 504282, 504116, 504112, 504107, 243129, 243121, 503953, 231589, 503532, 243036, 503093, 503091, 405729, 503083, 426510, 502748, 453468, 268985, 501632, 417799, 243025, 231504, 231502, 499164, 389159, 417797, 501803, 426307, 501627, 426303, 426298, 330255, 453119, 389155, 330252, 417789, 389154, 369079, 389149, 496156, 333647, 408342, 494834, 483469, 321005, 320983, 411776, 411771, 483461, 417747, 472577, 242658, 242656, 472575, 484770, 484768, 242634, 486666, 465670, 369056, 369054, 420639, 420637, 484475, 482829, 420635, 482827, 320908, 320905, 320903, 320899, 411764, 425118, 425116, 411762, 483346, 483344, 471097, 471095, 472546, 480394, 480890, 480392, 480886, 480880, 480877, 330194, 480875, 480873, 242336, 480388, 480351, 478381, 472538, 476363, 472536, 424696, 129057, 242208, 424670, 448601, 469180, 469093, 468706, 424436, 107830, 107826, 467681, 241831, 467091, 411688, 424313, 331318, 466310, 465859, 465857, 323492, 229944, 180945, 180942, 180939, 180937, 424029, 424022, 461674, 424020, 459721, 459245, 459217, 459239, 459232, 459161, 132344, 347901, 241413, 241408, 336214, 336211, 229648, 229628, 229578, 198196, 387130, 241301, 241298, 453312, 107525, 107515, 107513, 107508, 452318, 241231, 241229, 198123, 107499, 418038, 451707, 450548, 414788, 107483, 451339, 451432, 451327, 451325, 241162, 229462, 320611, 320604, 320602, 229422, 241125, 333561, 449204, 449185, 449495, 448699, 449487, 216371, 290996, 449469, 216367, 417269, 216365, 449341, 449162, 107471, 354742, 354740, 448532, 448328, 448651, 411640, 448644, 315701, 241033, 411633, 359907, 241030, 359904, 241020, 448170, 448319, 448164, 448442, 448129, 448026, 107442, 229245, 229242, 229240, 322352, 320580, 240953, 423516, 322904, 229201, 423094, 423456, 423370, 423439, 229199, 423437, 423382, 423372, 423147, 229193, 416686, 422650, 320548, 422074, 320545, 320543, 421077, 421070, 421068, 422466, 422462, 416684, 420224, 422416, 132218, 422095, 132196, 240879, 420059, 240875, 420218, 420478, 420476, 240849, 420030, 349287, 420022, 240791, 240787, 419845, 419684, 240782, 240744, 419213, 419210, 419208, 411596, 419204, 240735, 381769, 381767, 418655, 418593, 418648, 411585, 410978, 333539, 417611, 417630, 240708, 333534, 415347, 320486, 406808, 406806, 408592, 409302, 408590, 410598, 410417, 409290, 409282, 409135, 330065, 240162, 171782, 171779, 408074, 407607, 171776, 239785, 401938, 393347, 228157, 401773, 401771, 401769, 401757, 391866, 239774, 391862, 129016, 401736, 401731, 401727, 401724, 362236, 401721, 401718, 362222, 401683, 362220, 401677, 239752, 239744, 239724, 397711, 392538, 392536, 350947, 239644, 239642, 239640, 215409, 239638, 396977, 400829, 331303, 400822, 400867, 400216, 396972, 132042, 132039, 132037, 396970, 132020, 396967, 400499, 228094, 228092, 369021, 387163, 396964, 400249, 399964, 383036, 383033, 397706, 239573, 239555, 391347, 396642, 308782, 396640, 239521, 398546, 239496, 239454, 239452, 239449, 227933, 397678, 315675, 396000, 395998, 616958, 395996, 395994, 369016, 395788, 369014, 389668, 227919, 397649, 397635, 397646, 391344, 397644, 171671, 106742, 308776, 395785, 397576, 396763, 395782, 396761, 397573, 391339, 396759, 395780, 278042, 390443, 369006, 394344, 369004, 395774, 394342, 390441, 394340, 389313, 395417, 239340, 252756, 254053, 394753, 394751, 394675, 394672, 23387, 394669, 394372, 227733, 394335, 394333, 197056, 394503, 227730, 390789, 394497, 393375, 392821, 320368, 394330, 394232, 394226, 394224, 394122, 394222, 394119, 393626, 388708, 239240, 389816, 392402, 392716, 391389, 392601, 392687, 391357, 391326, 239030, 375196, 238976, 390071, 389809, 389807, 389803, 387663, 387661, 389753, 387658, 389757, 238927, 238925, 387656, 238922, 389750, 389728, 389552, 238912, 389465, 389121, 384327, 389310, 389111, 388499, 387246, 387428, 109327, 383906, 359114, 335129, 387138, 294229, 294225, 375188, 106486, 320316, 278024, 386359, 384362, 238773, 375176, 386177, 385583, 385576, 238708, 385564, 385561, 214746, 238704, 238702, 385322, 384914, 384912, 384910, 252742, 156248, 384907, 381500, 385260, 385255, 385252, 385188, 385248, 385245, 384557, 238678, 345508, 345506, 320310, 384323, 382211, 320308, 214693, 383024, 227385, 214691, 227343, 303256, 303252, 384309, 227339, 384319, 384307, 106375, 214590, 303249, 346326, 180926, 330027, 368991, 238566, 377986, 366966, 303247, 369634, 320279, 238560, 274556, 383250, 383378, 303244, 196854, 382729, 384023, 384021, 378650, 382723, 227323, 359093, 294205, 368989, 214561, 214558, 214556, 359084, 359078, 378648, 196843, 227309, 227306, 383338, 383335, 371228, 374490, 378457, 378455, 382981, 238531, 378446, 383042, 378441, 274544, 383021, 336196, 378425, 227281, 382360, 382004, 378396, 379586, 378934, 378394, 180924, 238509, 379583, 65523, 65518, 336192, 378932, 378930, 322236, 378388, 214498, 378364, 379151, 214475, 379146, 379144, 238483, 238447, 379493, 227193, 379490, 379401, 378923, 378641, 372080, 196772, 322230, 98823, 378837, 358336, 238408, 377623, 377621, 358332, 238404, 227172, 378317, 346292, 252701, 377506, 252697, 378663, 377923, 238386, 378310, 238341, 196713, 376310, 364996, 377043, 372524, 261250, 238290, 362839, 238288, 342265, 376305, 238282, 376303, 375812, 308649, 375810, 376792, 376503, 359821, 347871, 238223, 238219, 376498, 347869, 376494, 376641, 330020, 376594, 376592, 376473, 373969, 376471, 196659, 376467, 376461, 214295, 346285, 346279, 346277, 376301, 372595, 374425, 373798, 374280, 238102, 373792, 373784, 368982, 374185, 373751, 373898, 373892, 373889, 373886, 373945, 373644, 65505, 359495, 65502, 65500, 65497, 65495, 360759, 65493, 330810, 65491, 330808, 359489, 362087, 373432, 373357, 371326, 373355, 238095, 371122, 373353, 238093, 373335, 373331, 373329, 373316, 373312, 372727, 372724, 373029, 226892, 308605, 226888, 226886, 363908, 327202, 106110, 214033, 372593, 372911, 372410, 214028, 238077, 214025, 238075, 372406, 372906, 333398, 372750, 370464, 372591, 368980, 238070, 362045, 372717, 372651, 238064, 372587, 372648, 372645, 196583, 368979, 252673, 372642, 372192, 372521, 308599, 372519, 372585, 372583, 372551, 372517, 372515, 372512, 368976, 372179, 371428, 372403, 372486, 372543, 333395, 372427, 196573, 371426, 226846, 372412, 226833, 370720, 364810, 366116, 372273, 226818, 226816, 372159, 372153, 226809, 329995, 372151, 226807, 344172, 213868, 238054, 366722, 371355, 238050, 213860, 371292, 348658, 356887, 278132, 348248, 265479, 322851, 370654, 362597, 106058, 226779, 106055, 370384, 370978, 370976, 362593, 226770, 363827, 226767, 196530, 226765, 252659, 369953, 363816, 370891, 106048, 106046, 196524, 196521, 213838, 213831, 363810, 356884, 369951, 213809, 361299, 370652, 361297, 370877, 252655, 369943, 369941, 359482, 356356, 356354, 356352, 106044, 370677, 359480, 370675, 370673, 370668, 370341, 238036, 370338, 364087, 226672, 226659, 333383, 226635, 333379, 188690, 365035, 326901, 180880, 369680, 369757, 369700, 369698, 213696, 359470, 213694, 369750, 369677, 369670, 369745, 369582, 369674, 369658, 369668, 369524, 366305, 238002, 369522, 369580, 252645, 369578, 367865, 238000, 368633, 368631, 369464, 368629, 298125, 367767, 298122, 213689, 180870, 23347, 369506, 196459, 369518, 369516, 180867, 369514, 329973, 369502, 213683, 237994, 237991, 369434, 237989, 294034, 368968, 237982, 368966, 368959, 237972, 226589, 368823, 368820, 368818, 368813, 367907, 367968, 367962, 237951, 368425, 237949, 366497, 237931, 237890, 366267, 261226, 226524, 261224, 366378, 261222, 364306, 366072, 309919, 366202, 363956, 226522, 106002, 365377, 261993, 364304, 366262, 65471, 331284, 366344, 105999, 237886, 237884, 366255, 237877, 237875, 365885, 365480, 324607, 365721, 237855, 237852, 365089, 226510, 237828, 237818, 180806, 226465, 364755, 261214, 306280, 362683, 328828, 364751, 363944, 364042, 361521, 364463, 237766, 364007, 364349, 364432, 364445, 363940, 363987, 364441, 237759, 226426, 226424, 213470, 359786, 226422, 363983, 226411, 363899, 180795, 358053, 105903, 358043, 363939, 237744, 237727, 332332, 237724, 226353, 213353, 213351, 360686, 213349, 363380, 360591, 363407, 363331, 213340, 363378, 363415, 213338, 363405, 110049, 363412, 110047, 213335, 358323, 363402, 341105, 360681, 226336, 226334, 361435, 128990, 323134, 308537, 363226, 363113, 237698, 363110, 363108, 237696, 361431, 226284, 226280, 226277, 361429, 237663, 105852, 361830, 361829, 105843, 360581, 361342, 237648, 361339, 237645, 237631, 361683, 180752, 252583, 361544, 226244, 331264, 331258, 331256, 361146, 331253, 360525, 360570, 358946, 323130, 226189, 226187, 237551, 360301, 361015, 355552, 360298, 360237, 323125, 323123, 323121, 360199, 226173, 323119, 323117, 360943, 237544, 128971, 348242, 348239, 237541, 348237, 128967, 324580, 324576, 237538, 360635, 252575, 252572, 294193, 358941, 213245, 360523, 360521, 196338, 360325, 358798, 237492, 360232, 358795, 359616, 359685, 360244, 359644, 359613, 359641, 308530, 359638, 359611, 358808, 308528, 359624, 308523, 359621, 359575, 237479, 189185, 237474, 226002, 348940, 196325, 298045, 341077, 105742, 105740, 105736, 105733, 359338, 348938, 358396, 358394, 237450, 358392, 359267, 358675, 359022, 237443, 358791, 358788, 358785, 213152, 213149, 225967, 213142, 359049, 359046, 225965, 359044, 308518, 358961, 358984, 358982, 213134, 358379, 358913, 358644, 298043, 298041, 213099, 237417, 358746, 237415, 358698, 358580, 358694, 237413, 213089, 358690, 358578, 358688, 237411, 358639, 358566, 213086, 225946, 213084, 225944, 213082, 225942, 213080, 225939, 225937, 225933, 252549, 237404, 225930, 213073, 237400, 285834, 355542, 298035, 358636, 358279, 285831, 358624, 358634, 358548, 298033, 356235, 298031, 237391, 237387, 358105, 358443, 357841, 358438, 322148, 213062, 237365, 357330, 357328, 357661, 357695, 356871, 225863, 357323, 329939, 357648, 351953, 357321, 357611, 357609, 355474, 329937, 357449, 225858, 329935, 357638, 357447, 237322, 329932, 329928, 329926, 329923, 329919, 329916, 329914, 131777, 357607, 329212, 324554, 225856, 180738, 319234, 357445, 329910, 329908, 237317, 329906, 357442, 196275, 225854, 237315, 225851, 225848, 319231, 357439, 319229, 319227, 355232, 225839, 329904, 237308, 357513, 357511, 357509, 357437, 355465, 237301, 212992, 212989, 237296, 237294, 237291, 357435, 35095, 237288, 212985, 131773, 131771, 322143, 322141, 344019, 357248, 357246, 156912, 237283, 156907, 356949, 357219, 225806, 357181, 357176, 348223, 237272, 225747, 353855, 225723, 353852, 308495, 353849, 252510, 237248, 353846, 237240, 353844, 128954, 225697, 356316, 212840, 225664, 212838, 356312, 353760, 356310, 356211, 225661, 237219, 225659, 252503, 237216, 237202, 346193, 332852, 346191, 237199, 225607, 291557, 225605, 350058, 225603, 291555, 212807, 346186, 225601, 180672, 237193, 225533, 237126, 225494, 225275, 297999, 345186, 322072, 324534, 349751, 324532, 349749, 324530, 196148, 225185, 349700, 131674, 349642, 349638, 349636, 349425, 346177, 349634, 322067, 349423, 346175, 322063, 196143, 196141, 347645, 299634, 344162, 322056, 348142, 196139, 348680, 348678, 348516, 348515, 212512, 310236, 348478, 347239, 348620, 236957, 348710, 310232, 348058, 348054, 348604, 323079, 236953, 323078, 348472, 348510, 344010, 348508, 321269, 236941, 131642, 225148, 348051, 225146, 345758, 212484, 212482, 131640, 345755, 236939, 343802, 225144, 225141, 348046, 225139, 348043, 225137, 348391, 343417, 347995, 348111, 236936, 308474, 348106, 236932, 348104, 348098, 236929, 347641, 225131, 348038, 348036, 348041, 212475, 348032, 348030, 252401, 252398, 345751, 345749, 236924, 236921, 236919, 236917, 225129, 128931, 128929, 347067, 212472, 346165, 347712, 347706, 347704, 347702, 347438, 236895, 347233, 347231, 322050, 128927, 236891, 324525, 347428, 225099, 225097, 347480, 256183, 236888, 236883, 225087, 347064, 131610, 131607, 131602, 131600, 131598, 131593, 347086, 131589, 236879, 345988, 345986, 225079, 212459, 212457, 225077, 225075, 316903, 345972, 347076, 347074, 347058, 347054, 346161, 225072, 225069, 225067, 19223, 347016, 346156, 347014, 346154, 212446, 347009, 346152, 347003, 236865, 297982, 297980, 322040, 252379, 322038, 346637, 346694, 345741, 322036, 346598, 212431, 346594, 236854, 346148, 346591, 346588, 212411, 346583, 322032, 318023, 109938, 333189, 333184, 333182, 333179, 333177, 346480, 346476, 346473, 128924, 212394, 346470, 344610, 196118, 344608, 345969, 340843, 346140, 236851, 346135, 212390, 346133, 346122, 205249, 212387, 225035, 225032, 225030, 236844, 345966, 345961, 345955, 212374, 236842, 345870, 212368, 236838, 225019, 341239, 212357, 212353, 212351, 345826, 212348, 212345, 345731, 345729, 345763, 345534, 345460, 343926, 345430, 343924, 345397, 225004, 331229, 345391, 225000, 105401, 236834, 236831, 105373, 212322, 345252, 345248, 345243, 310206, 345237, 212317, 345221, 345203, 345193, 345183, 344963, 344150, 344700, 344961, 344959, 344693, 224976, 236816, 252354, 344918, 344455, 224975, 344828, 343124, 343122, 344690, 212315, 344144, 344835, 344766, 338955, 344282, 344763, 344440, 322029, 23317, 343108, 344758, 343104, 343101, 343100, 343095, 343082, 224931, 224929, 343076, 343074, 343072, 343070, 343068, 342585, 343141, 296702, 236767, 256168, 342411, 342563, 342560, 224865, 342456, 212205, 236750, 339471, 342451, 236747, 342557, 341956, 236745, 342448, 342444, 342439, 236741, 342436, 342434, 340088, 224832, 262899, 341953, 341976, 342024, 212147, 236677, 341900, 297966, 341611, 341605, 328972, 262896, 336511, 341786, 224786, 224781, 224772, 212133, 322007, 340940, 128918, 224737, 212087, 324515, 212084, 236622, 297939, 236591, 340978, 340975, 340251, 340249, 340907, 340898, 128916, 340733, 297929, 340641, 252288, 336129, 334594, 334708, 334591, 338829, 338822, 332819, 338682, 338504, 211887, 211872, 265374, 236386, 338198, 265370, 614413, 338194, 338191, 236384, 224515, 331209, 331205, 614409, 252170, 335808, 236368, 337750, 337968, 337966, 236366, 337964, 337962, 614404, 337960, 337813, 337685, 105245, 337416, 332815, 252165, 252163, 312585, 211735, 224488, 224486, 205165, 336929, 336923, 205162, 224484, 211715, 336479, 211712, 337117, 236342, 337115, 337112, 236337, 337106, 337098, 337092, 337155, 336055, 236321, 236275, 334442, 336048, 336037, 336045, 336043, 336034, 335466, 336029, 195985, 334436, 335863, 264117, 264115, 335858, 335719, 335856, 224468, 335421, 57108, 236255, 236250, 334198, 334196, 211638, 236235, 335751, 236211, 236201, 236198, 236193, 180374, 315185, 224439, 335381, 334705, 224437, 180361, 180359, 335373, 105168, 327799, 334080, 224372, 236113, 323041, 325660, 236111, 334586, 236109, 321989, 224362, 332556, 236101, 236094, 236091, 211500, 334840, 334838, 297874, 297869, 334703, 334701, 332668, 128906, 128904, 224350, 224345, 224341, 333005, 332666, 236078, 236074, 224333, 236072, 334377, 334371, 297864, 334362, 297859, 297857, 332664, 224324, 334194, 236056, 297854, 211445, 297852, 332659, 297850, 324485, 323033, 195953, 128895, 614400, 332797, 614398, 614396, 332752, 328080, 332750, 301729, 325317, 332656, 332654, 295908, 224258, 332496, 332488, 332642, 326434, 332566, 329812, 332111, 332201, 332199, 332119, 332115, 331864, 328222, 331796, 252111, 252109, 331181, 303603, 303596, 288798, 288796, 331026, 331024, 331008, 324103, 330670, 330904, 330668, 330902, 330665, 330660, 297845, 329485, 329483, 297843, 329163, 330627, 329480, 330625, 329467, 329463, 329461, 211219, 296968))
Run Time: 0.167174
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2457 | |
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 | | | | | 2457 | |
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 (31677, 31616, 31561, 31559, 30579, 30181, 30174, 30144, 29906, 29889, 28356, 27913, 27408, 27211, 26886, 26386, 26279, 26143, 26111, 26077, 25608, 25096, 25082, 24216, 24182, 23192, 22062, 21669, 20074, 20038, 19858, 19310, 19179, 18842, 18627, 18464, 18444, 18220, 18195, 18061, 18031, 17966, 17414, 17332, 17211, 17159, 17132, 16951, 16563, 16560, 16478, 16457, 16416, 16408, 16358, 16297))
Run Time: 0.005410
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 56 | 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 (613013, 613012, 609777, 609774, 595707, 595705, 608271, 602002, 601998, 599154, 598911, 598909, 439865, 589489, 589487, 589484, 598643, 598638, 598677, 598545, 598490, 517450, 517446, 439827, 598116, 597837, 598034, 597833, 598005, 597823, 439691, 439270, 333974, 333971, 587236, 587093, 585979, 585972, 436471, 436465, 585909, 436462, 369259, 436460, 571055, 402792, 579387, 246035, 579385, 585267, 584385, 330497, 584944, 584943, 570690, 235139, 235137, 578738, 412491, 235135, 235132, 531056, 412485, 575480, 389237, 530623, 530619, 434019, 463721, 322560, 517381, 517379, 463710, 575399, 417885, 417880, 549722, 234360, 234330, 234311, 574714, 574712, 574710, 574708, 574354, 433649, 517365, 572702, 572700, 517361, 433574, 573644, 570681, 572691, 569668, 573625, 572503, 569663, 573623, 549689, 549684, 572441, 573622, 573594, 573590, 244750, 573576, 573573, 570673, 433092, 412358, 570671, 530051, 336335, 571120, 432990, 559514, 559513, 570669, 549665, 381838, 570262, 570261, 432790, 570650, 569625, 570257, 535981, 535979, 432669, 220695, 570233, 547162, 220687, 535975, 570230, 471253, 369185, 570228, 535967, 432660, 432657, 471235, 432651, 432642, 390697, 567610, 570087, 567605, 432526, 567603, 244591, 565198, 560259, 558701, 511486, 558699, 244342, 269061, 306440, 559029, 306438, 558697, 558694, 547915, 547913, 558689, 558687, 553305, 558272, 421999, 558433, 244281, 558005, 412271, 535867, 412267, 614622, 180962, 412265, 558324, 558322, 556314, 555716, 401046, 453600, 554832, 16302, 412245, 430940, 555112, 430828, 430824, 552658, 471226, 552539, 389226, 552055, 552526, 430819, 552050, 552045, 544232, 544228, 232887, 232885, 552018, 552246, 544226, 539268, 303349, 552271, 552263, 358898, 552016, 219867, 309450, 551245, 551371, 550746, 393305, 388885, 550267, 548249, 546864, 503674, 430042, 546862, 546596, 546860, 546858, 546856, 430040, 430036, 546837, 546818, 546816, 430004, 546404, 232735, 411350, 546399, 505226, 505224, 429974, 505215, 544736, 544735, 544733, 368277, 544731, 544728, 544725, 544624, 543604, 543602, 309388, 468546, 540131, 544371, 481626, 543589, 429719, 69689, 393831, 543993, 322512, 543586, 511023, 543583, 23491, 219570, 333774, 543519, 429613, 429596, 537664, 333770, 429572, 528448, 528447, 538822, 219438, 429094, 538755, 333758, 537477, 401327, 537610, 321170, 537550, 537548, 201597, 537418, 624807, 321166, 384372, 537198, 536943, 537197, 537135, 373525, 149485, 428951, 401040, 520396, 528431, 528429, 524237, 528063, 480473, 528122, 369106, 528144, 369102, 243801, 369100, 518743, 428752, 428750, 503576, 232343, 503574, 354350, 503572, 354346, 354342, 479530, 354340, 428740, 354338, 354335, 428732, 428725, 321161, 232338, 321159, 526947, 511419, 511416, 511414, 219271, 511411, 527406, 219269, 511407, 526996, 527318, 516910, 219221, 451731, 360012, 451729, 488183, 428674, 428661, 412027, 414852, 526594, 414850, 404684, 526592, 526590, 404682, 520506, 414848, 526585, 428642, 526583, 414846, 524001, 471182, 526491, 428619, 524083, 524080, 428615, 428608, 243797, 318360, 523849, 526488, 523847, 428591, 428562, 524011, 624787, 474076, 499277, 523863, 523829, 523784, 499275, 522769, 232306, 523511, 321142, 523317, 333728, 243787, 516907, 523308, 243779, 243770, 243767, 243765, 474069, 243755, 522582, 428415, 522580, 522578, 522401, 321133, 521532, 489800, 389164, 522074, 510780, 510777, 510775, 520847, 428392, 428387, 489797, 77964, 412005, 219104, 428337, 521528, 521525, 521521, 521661, 521516, 521344, 521512, 521502, 521510, 520883, 520893, 520842, 243648, 520838, 243646, 420924, 389705, 514315, 513889, 505191, 513886, 513880, 513868, 218774, 513091, 427698, 513720, 243535, 512973, 512968, 471141, 512921, 512918, 331323, 427635, 427625, 367368, 367366, 509114, 509112, 512290, 509110, 509108, 494703, 512042, 427568, 218644, 393055, 322484, 218629, 243496, 322481, 510772, 243481, 494691, 511175, 494688, 411972, 510770, 510768, 411960, 411958, 509880, 323573, 393045, 510467, 510465, 393040, 393037, 455432, 510463, 509863, 509848, 509844, 509842, 323567, 508686, 508682, 508680, 508678, 508674, 427087, 427066, 309236, 427019, 508095, 427016, 427014, 309198, 471133, 317150, 317144, 417817, 505177, 243198, 504702, 504700, 347949, 504546, 504544, 368227, 368225, 347938, 368222, 504284, 504282, 504116, 504112, 504107, 243129, 243121, 503953, 231589, 503532, 243036, 503093, 503091, 405729, 503083, 426510, 502748, 453468, 268985, 501632, 417799, 243025, 231504, 231502, 499164, 389159, 417797, 501803, 426307, 501627, 426303, 426298, 330255, 453119, 389155, 330252, 417789, 389154, 369079, 389149, 496156, 333647, 408342, 494834, 483469, 321005, 320983, 411776, 411771, 483461, 417747, 472577, 242658, 242656, 472575, 484770, 484768, 242634, 486666, 465670, 369056, 369054, 420639, 420637, 484475, 482829, 420635, 482827, 320908, 320905, 320903, 320899, 411764, 425118, 425116, 411762, 483346, 483344, 471097, 471095, 472546, 480394, 480890, 480392, 480886, 480880, 480877, 330194, 480875, 480873, 242336, 480388, 480351, 478381, 472538, 476363, 472536, 424696, 129057, 242208, 424670, 448601, 469180, 469093, 468706, 424436, 107830, 107826, 467681, 241831, 467091, 411688, 424313, 331318, 466310, 465859, 465857, 323492, 229944, 180945, 180942, 180939, 180937, 424029, 424022, 461674, 424020, 459721, 459245, 459217, 459239, 459232, 459161, 132344, 347901, 241413, 241408, 336214, 336211, 229648, 229628, 229578, 198196, 387130, 241301, 241298, 453312, 107525, 107515, 107513, 107508, 452318, 241231, 241229, 198123, 107499, 418038, 451707, 450548, 414788, 107483, 451339, 451432, 451327, 451325, 241162, 229462, 320611, 320604, 320602, 229422, 241125, 333561, 449204, 449185, 449495, 448699, 449487, 216371, 290996, 449469, 216367, 417269, 216365, 449341, 449162, 107471, 354742, 354740, 448532, 448328, 448651, 411640, 448644, 315701, 241033, 411633, 359907, 241030, 359904, 241020, 448170, 448319, 448164, 448442, 448129, 448026, 107442, 229245, 229242, 229240, 322352, 320580, 240953, 423516, 322904, 229201, 423094, 423456, 423370, 423439, 229199, 423437, 423382, 423372, 423147, 229193, 416686, 422650, 320548, 422074, 320545, 320543, 421077, 421070, 421068, 422466, 422462, 416684, 420224, 422416, 132218, 422095, 132196, 240879, 420059, 240875, 420218, 420478, 420476, 240849, 420030, 349287, 420022, 240791, 240787, 419845, 419684, 240782, 240744, 419213, 419210, 419208, 411596, 419204, 240735, 381769, 381767, 418655, 418593, 418648, 411585, 410978, 333539, 417611, 417630, 240708, 333534, 415347, 320486, 406808, 406806, 408592, 409302, 408590, 410598, 410417, 409290, 409282, 409135, 330065, 240162, 171782, 171779, 408074, 407607, 171776, 239785, 401938, 393347, 228157, 401773, 401771, 401769, 401757, 391866, 239774, 391862, 129016, 401736, 401731, 401727, 401724, 362236, 401721, 401718, 362222, 401683, 362220, 401677, 239752, 239744, 239724, 397711, 392538, 392536, 350947, 239644, 239642, 239640, 215409, 239638, 396977, 400829, 331303, 400822, 400867, 400216, 396972, 132042, 132039, 132037, 396970, 132020, 396967, 400499, 228094, 228092, 369021, 387163, 396964, 400249, 399964, 383036, 383033, 397706, 239573, 239555, 391347, 396642, 308782, 396640, 239521, 398546, 239496, 239454, 239452, 239449, 227933, 397678, 315675, 396000, 395998, 616958, 395996, 395994, 369016, 395788, 369014, 389668, 227919, 397649, 397635, 397646, 391344, 397644, 171671, 106742, 308776, 395785, 397576, 396763, 395782, 396761, 397573, 391339, 396759, 395780, 278042, 390443, 369006, 394344, 369004, 395774, 394342, 390441, 394340, 389313, 395417, 239340, 252756, 254053, 394753, 394751, 394675, 394672, 23387, 394669, 394372, 227733, 394335, 394333, 197056, 394503, 227730, 390789, 394497, 393375, 392821, 320368, 394330, 394232, 394226, 394224, 394122, 394222, 394119, 393626, 388708, 239240, 389816, 392402, 392716, 391389, 392601, 392687, 391357, 391326, 239030, 375196, 238976, 390071, 389809, 389807, 389803, 387663, 387661, 389753, 387658, 389757, 238927, 238925, 387656, 238922, 389750, 389728, 389552, 238912, 389465, 389121, 384327, 389310, 389111, 388499, 387246, 387428, 109327, 383906, 359114, 335129, 387138, 294229, 294225, 375188, 106486, 320316, 278024, 386359, 384362, 238773, 375176, 386177, 385583, 385576, 238708, 385564, 385561, 214746, 238704, 238702, 385322, 384914, 384912, 384910, 252742, 156248, 384907, 381500, 385260, 385255, 385252, 385188, 385248, 385245, 384557, 238678, 345508, 345506, 320310, 384323, 382211, 320308, 214693, 383024, 227385, 214691, 227343, 303256, 303252, 384309, 227339, 384319, 384307, 106375, 214590, 303249, 346326, 180926, 330027, 368991, 238566, 377986, 366966, 303247, 369634, 320279, 238560, 274556, 383250, 383378, 303244, 196854, 382729, 384023, 384021, 378650, 382723, 227323, 359093, 294205, 368989, 214561, 214558, 214556, 359084, 359078, 378648, 196843, 227309, 227306, 383338, 383335, 371228, 374490, 378457, 378455, 382981, 238531, 378446, 383042, 378441, 274544, 383021, 336196, 378425, 227281, 382360, 382004, 378396, 379586, 378934, 378394, 180924, 238509, 379583, 65523, 65518, 336192, 378932, 378930, 322236, 378388, 214498, 378364, 379151, 214475, 379146, 379144, 238483, 238447, 379493, 227193, 379490, 379401, 378923, 378641, 372080, 196772, 322230, 98823, 378837, 358336, 238408, 377623, 377621, 358332, 238404, 227172, 378317, 346292, 252701, 377506, 252697, 378663, 377923, 238386, 378310, 238341, 196713, 376310, 364996, 377043, 372524, 261250, 238290, 362839, 238288, 342265, 376305, 238282, 376303, 375812, 308649, 375810, 376792, 376503, 359821, 347871, 238223, 238219, 376498, 347869, 376494, 376641, 330020, 376594, 376592, 376473, 373969, 376471, 196659, 376467, 376461, 214295, 346285, 346279, 346277, 376301, 372595, 374425, 373798, 374280, 238102, 373792, 373784, 368982, 374185, 373751, 373898, 373892, 373889, 373886, 373945, 373644, 65505, 359495, 65502, 65500, 65497, 65495, 360759, 65493, 330810, 65491, 330808, 359489, 362087, 373432, 373357, 371326, 373355, 238095, 371122, 373353, 238093, 373335, 373331, 373329, 373316, 373312, 372727, 372724, 373029, 226892, 308605, 226888, 226886, 363908, 327202, 106110, 214033, 372593, 372911, 372410, 214028, 238077, 214025, 238075, 372406, 372906, 333398, 372750, 370464, 372591, 368980, 238070, 362045, 372717, 372651, 238064, 372587, 372648, 372645, 196583, 368979, 252673, 372642, 372192, 372521, 308599, 372519, 372585, 372583, 372551, 372517, 372515, 372512, 368976, 372179, 371428, 372403, 372486, 372543, 333395, 372427, 196573, 371426, 226846, 372412, 226833, 370720, 364810, 366116, 372273, 226818, 226816, 372159, 372153, 226809, 329995, 372151, 226807, 344172, 213868, 238054, 366722, 371355, 238050, 213860, 371292, 348658, 356887, 278132, 348248, 265479, 322851, 370654, 362597, 106058, 226779, 106055, 370384, 370978, 370976, 362593, 226770, 363827, 226767, 196530, 226765, 252659, 369953, 363816, 370891, 106048, 106046, 196524, 196521, 213838, 213831, 363810, 356884, 369951, 213809, 361299, 370652, 361297, 370877, 252655, 369943, 369941, 359482, 356356, 356354, 356352, 106044, 370677, 359480, 370675, 370673, 370668, 370341, 238036, 370338, 364087, 226672, 226659, 333383, 226635, 333379, 188690, 365035, 326901, 180880, 369680, 369757, 369700, 369698, 213696, 359470, 213694, 369750, 369677, 369670, 369745, 369582, 369674, 369658, 369668, 369524, 366305, 238002, 369522, 369580, 252645, 369578, 367865, 238000, 368633, 368631, 369464, 368629, 298125, 367767, 298122, 213689, 180870, 23347, 369506, 196459, 369518, 369516, 180867, 369514, 329973, 369502, 213683, 237994, 237991, 369434, 237989, 294034, 368968, 237982, 368966, 368959, 237972, 226589, 368823, 368820, 368818, 368813, 367907, 367968, 367962, 237951, 368425, 237949, 366497, 237931, 237890, 366267, 261226, 226524, 261224, 366378, 261222, 364306, 366072, 309919, 366202, 363956, 226522, 106002, 365377, 261993, 364304, 366262, 65471, 331284, 366344, 105999, 237886, 237884, 366255, 237877, 237875, 365885, 365480, 324607, 365721, 237855, 237852, 365089, 226510, 237828, 237818, 180806, 226465, 364755, 261214, 306280, 362683, 328828, 364751, 363944, 364042, 361521, 364463, 237766, 364007, 364349, 364432, 364445, 363940, 363987, 364441, 237759, 226426, 226424, 213470, 359786, 226422, 363983, 226411, 363899, 180795, 358053, 105903, 358043, 363939, 237744, 237727, 332332, 237724, 226353, 213353, 213351, 360686, 213349, 363380, 360591, 363407, 363331, 213340, 363378, 363415, 213338, 363405, 110049, 363412, 110047, 213335, 358323, 363402, 341105, 360681, 226336, 226334, 361435, 128990, 323134, 308537, 363226, 363113, 237698, 363110, 363108, 237696, 361431, 226284, 226280, 226277, 361429, 237663, 105852, 361830, 361829, 105843, 360581, 361342, 237648, 361339, 237645, 237631, 361683, 180752, 252583, 361544, 226244, 331264, 331258, 331256, 361146, 331253, 360525, 360570, 358946, 323130, 226189, 226187, 237551, 360301, 361015, 355552, 360298, 360237, 323125, 323123, 323121, 360199, 226173, 323119, 323117, 360943, 237544, 128971, 348242, 348239, 237541, 348237, 128967, 324580, 324576, 237538, 360635, 252575, 252572, 294193, 358941, 213245, 360523, 360521, 196338, 360325, 358798, 237492, 360232, 358795, 359616, 359685, 360244, 359644, 359613, 359641, 308530, 359638, 359611, 358808, 308528, 359624, 308523, 359621, 359575, 237479, 189185, 237474, 226002, 348940, 196325, 298045, 341077, 105742, 105740, 105736, 105733, 359338, 348938, 358396, 358394, 237450, 358392, 359267, 358675, 359022, 237443, 358791, 358788, 358785, 213152, 213149, 225967, 213142, 359049, 359046, 225965, 359044, 308518, 358961, 358984, 358982, 213134, 358379, 358913, 358644, 298043, 298041, 213099, 237417, 358746, 237415, 358698, 358580, 358694, 237413, 213089, 358690, 358578, 358688, 237411, 358639, 358566, 213086, 225946, 213084, 225944, 213082, 225942, 213080, 225939, 225937, 225933, 252549, 237404, 225930, 213073, 237400, 285834, 355542, 298035, 358636, 358279, 285831, 358624, 358634, 358548, 298033, 356235, 298031, 237391, 237387, 358105, 358443, 357841, 358438, 322148, 213062, 237365, 357330, 357328, 357661, 357695, 356871, 225863, 357323, 329939, 357648, 351953, 357321, 357611, 357609, 355474, 329937, 357449, 225858, 329935, 357638, 357447, 237322, 329932, 329928, 329926, 329923, 329919, 329916, 329914, 131777, 357607, 329212, 324554, 225856, 180738, 319234, 357445, 329910, 329908, 237317, 329906, 357442, 196275, 225854, 237315, 225851, 225848, 319231, 357439, 319229, 319227, 355232, 225839, 329904, 237308, 357513, 357511, 357509, 357437, 355465, 237301, 212992, 212989, 237296, 237294, 237291, 357435, 35095, 237288, 212985, 131773, 131771, 322143, 322141, 344019, 357248, 357246, 156912, 237283, 156907, 356949, 357219, 225806, 357181, 357176, 348223, 237272, 225747, 353855, 225723, 353852, 308495, 353849, 252510, 237248, 353846, 237240, 353844, 128954, 225697, 356316, 212840, 225664, 212838, 356312, 353760, 356310, 356211, 225661, 237219, 225659, 252503, 237216, 237202, 346193, 332852, 346191, 237199, 225607, 291557, 225605, 350058, 225603, 291555, 212807, 346186, 225601, 180672, 237193, 225533, 237126, 225494, 225275, 297999, 345186, 322072, 324534, 349751, 324532, 349749, 324530, 196148, 225185, 349700, 131674, 349642, 349638, 349636, 349425, 346177, 349634, 322067, 349423, 346175, 322063, 196143, 196141, 347645, 299634, 344162, 322056, 348142, 196139, 348680, 348678, 348516, 348515, 212512, 310236, 348478, 347239, 348620, 236957, 348710, 310232, 348058, 348054, 348604, 323079, 236953, 323078, 348472, 348510, 344010, 348508, 321269, 236941, 131642, 225148, 348051, 225146, 345758, 212484, 212482, 131640, 345755, 236939, 343802, 225144, 225141, 348046, 225139, 348043, 225137, 348391, 343417, 347995, 348111, 236936, 308474, 348106, 236932, 348104, 348098, 236929, 347641, 225131, 348038, 348036, 348041, 212475, 348032, 348030, 252401, 252398, 345751, 345749, 236924, 236921, 236919, 236917, 225129, 128931, 128929, 347067, 212472, 346165, 347712, 347706, 347704, 347702, 347438, 236895, 347233, 347231, 322050, 128927, 236891, 324525, 347428, 225099, 225097, 347480, 256183, 236888, 236883, 225087, 347064, 131610, 131607, 131602, 131600, 131598, 131593, 347086, 131589, 236879, 345988, 345986, 225079, 212459, 212457, 225077, 225075, 316903, 345972, 347076, 347074, 347058, 347054, 346161, 225072, 225069, 225067, 19223, 347016, 346156, 347014, 346154, 212446, 347009, 346152, 347003, 236865, 297982, 297980, 322040, 252379, 322038, 346637, 346694, 345741, 322036, 346598, 212431, 346594, 236854, 346148, 346591, 346588, 212411, 346583, 322032, 318023, 109938, 333189, 333184, 333182, 333179, 333177, 346480, 346476, 346473, 128924, 212394, 346470, 344610, 196118, 344608, 345969, 340843, 346140, 236851, 346135, 212390, 346133, 346122, 205249, 212387, 225035, 225032, 225030, 236844, 345966, 345961, 345955, 212374, 236842, 345870, 212368, 236838, 225019, 341239, 212357, 212353, 212351, 345826, 212348, 212345, 345731, 345729, 345763, 345534, 345460, 343926, 345430, 343924, 345397, 225004, 331229, 345391, 225000, 105401, 236834, 236831, 105373, 212322, 345252, 345248, 345243, 310206, 345237, 212317, 345221, 345203, 345193, 345183, 344963, 344150, 344700, 344961, 344959, 344693, 224976, 236816, 252354, 344918, 344455, 224975, 344828, 343124, 343122, 344690, 212315, 344144, 344835, 344766, 338955, 344282, 344763, 344440, 322029, 23317, 343108, 344758, 343104, 343101, 343100, 343095, 343082, 224931, 224929, 343076, 343074, 343072, 343070, 343068, 342585, 343141, 296702, 236767, 256168, 342411, 342563, 342560, 224865, 342456, 212205, 236750, 339471, 342451, 236747, 342557, 341956, 236745, 342448, 342444, 342439, 236741, 342436, 342434, 340088, 224832, 262899, 341953, 341976, 342024, 212147, 236677, 341900, 297966, 341611, 341605, 328972, 262896, 336511, 341786, 224786, 224781, 224772, 212133, 322007, 340940, 128918, 224737, 212087, 324515, 212084, 236622, 297939, 236591, 340978, 340975, 340251, 340249, 340907, 340898, 128916, 340733, 297929, 340641, 252288, 336129, 334594, 334708, 334591, 338829, 338822, 332819, 338682, 338504, 211887, 211872, 265374, 236386, 338198, 265370, 614413, 338194, 338191, 236384, 224515, 331209, 331205, 614409, 252170, 335808, 236368, 337750, 337968, 337966, 236366, 337964, 337962, 614404, 337960, 337813, 337685, 105245, 337416, 332815, 252165, 252163, 312585, 211735, 224488, 224486, 205165, 336929, 336923, 205162, 224484, 211715, 336479, 211712, 337117, 236342, 337115, 337112, 236337, 337106, 337098, 337092, 337155, 336055, 236321, 236275, 334442, 336048, 336037, 336045, 336043, 336034, 335466, 336029, 195985, 334436, 335863, 264117, 264115, 335858, 335719, 335856, 224468, 335421, 57108, 236255, 236250, 334198, 334196, 211638, 236235, 335751, 236211, 236201, 236198, 236193, 180374, 315185, 224439, 335381, 334705, 224437, 180361, 180359, 335373, 105168, 327799, 334080, 224372, 236113, 323041, 325660, 236111, 334586, 236109, 321989, 224362, 332556, 236101, 236094, 236091, 211500, 334840, 334838, 297874, 297869, 334703, 334701, 332668, 128906, 128904, 224350, 224345, 224341, 333005, 332666, 236078, 236074, 224333, 236072, 334377, 334371, 297864, 334362, 297859, 297857, 332664, 224324, 334194, 236056, 297854, 211445, 297852, 332659, 297850, 324485, 323033, 195953, 128895, 614400, 332797, 614398, 614396, 332752, 328080, 332750, 301729, 325317, 332656, 332654, 295908, 224258, 332496, 332488, 332642, 326434, 332566, 329812, 332111, 332201, 332199, 332119, 332115, 331864, 328222, 331796, 252111, 252109, 331181, 303603, 303596, 288798, 288796, 331026, 331024, 331008, 324103, 330670, 330904, 330668, 330902, 330665, 330660, 297845, 329485, 329483, 297843, 329163, 330627, 329480, 330625, 329467, 329463, 329461, 211219, 296968))
Run Time: 0.049698
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2457 | |
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 | | | | | 2457 | |
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 (31677, 31616, 31561, 31559, 30579, 30181, 30174, 30144, 29906, 29889, 28356, 27913, 27408, 27211, 26886, 26386, 26279, 26143, 26111, 26077, 25608, 25096, 25082, 24216, 24182, 23192, 22062, 21669, 20074, 20038, 19858, 19310, 19179, 18842, 18627, 18464, 18444, 18220, 18195, 18061, 18031, 17966, 17414, 17332, 17211, 17159, 17132, 16951, 16563, 16560, 16478, 16457, 16416, 16408, 16358, 16297))
Run Time: 0.002584
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 56 | 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, ��s
Run Time: 0.000238
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.000301
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.000621
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: 1717147346
Run Time: 0.000402
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 20 | 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` >= 1717147346)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000741
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 20 | 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