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.000648
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` = '4585')
LIMIT 1
Run Time: 0.000397
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.001923
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_4585' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.047781
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 (589807, 589632, 585673, 437776, 585671, 589380, 527820, 579652, 437681, 437678, 437676, 437604, 437601, 437600, 437598, 246274, 587703, 547935, 587701, 437163, 587306, 434809, 245383, 245379, 575940, 245377, 245366, 221140, 221138, 539511, 221136, 309714, 221133, 245351, 245349, 200451, 353152, 245312, 245309, 245307, 622080, 493596, 576034, 625000, 575881, 575870, 434125, 552289, 574246, 536690, 575734, 575732, 575729, 434081, 575708, 108869, 530648, 530645, 206139, 434055, 377202, 575529, 434030, 575537, 412387, 245241, 412385, 526402, 434022, 386025, 575398, 575395, 558033, 417887, 494760, 206134, 624998, 482838, 575332, 564944, 573847, 553085, 233987, 558030, 553073, 558020, 515504, 515501, 515499, 515490, 515487, 526315, 515485, 515483, 220880, 526300, 233822, 233819, 571295, 621737, 571290, 380925, 621735, 526289, 233808, 200305, 233805, 485868, 432896, 621725, 432894, 309686, 565084, 553736, 233799, 380908, 567622, 474200, 380904, 571095, 110573, 244649, 244645, 621707, 371905, 244641, 371903, 571093, 570796, 570593, 371901, 571085, 567613, 570999, 220833, 488089, 621704, 553700, 220829, 309683, 309668, 432862, 309639, 309632, 570777, 570775, 570772, 570769, 133135, 432811, 309606, 432804, 432797, 432795, 527747, 329369, 244609, 413804, 552414, 413802, 570288, 233736, 385998, 337048, 418797, 535988, 244602, 526264, 553560, 233723, 324016, 233662, 233651, 432574, 328433, 569822, 432571, 569817, 518909, 233639, 220576, 244584, 569478, 206039, 624977, 206027, 556633, 431948, 564090, 564088, 244489, 431581, 431512, 285550, 431510, 360032, 285548, 431505, 624927, 244314, 244313, 558514, 558265, 624921, 558538, 557891, 552998, 521045, 557881, 557968, 552929, 557879, 552923, 527674, 555548, 557055, 555545, 323612, 535858, 624915, 552398, 624914, 244241, 431095, 431091, 431090, 525860, 431044, 555541, 555623, 547757, 529136, 529135, 200201, 624904, 552283, 232976, 430873, 552913, 520100, 552904, 520076, 244216, 520073, 520068, 520057, 520054, 520045, 520016, 520014, 430837, 520010, 468322, 549952, 549950, 620671, 244210, 529105, 341336, 430811, 430809, 529103, 133012, 133007, 552395, 133003, 133001, 430793, 529100, 108772, 552532, 519979, 205992, 515469, 219907, 430779, 430777, 522339, 430775, 347310, 552251, 303385, 430744, 219898, 551448, 303361, 551446, 244200, 552273, 244198, 552260, 430728, 244192, 430725, 430723, 244190, 430719, 430716, 430715, 430710, 232874, 430708, 552210, 551845, 551041, 515468, 514945, 551966, 551335, 551987, 551964, 405779, 515460, 529072, 519110, 551960, 412227, 232866, 525752, 525744, 551520, 232857, 232853, 205987, 309433, 309426, 551404, 309422, 430622, 551382, 430616, 430607, 468320, 529057, 244172, 244164, 551401, 551397, 522633, 376252, 376246, 244152, 430518, 380737, 522624, 430508, 430506, 430503, 546341, 430499, 430494, 325410, 219818, 338862, 338857, 548189, 108761, 525707, 205980, 548255, 430270, 430239, 430236, 108712, 430151, 515448, 503669, 232739, 536486, 429956, 205966, 256224, 256220, 525600, 232731, 232729, 429935, 525594, 545828, 244105, 545826, 525582, 545779, 525576, 244103, 624876, 528907, 525565, 528905, 545660, 620449, 545509, 244096, 515373, 515347, 515343, 515340, 515331, 244065, 515323, 515319, 515317, 544606, 525449, 624861, 515291, 515288, 525434, 429825, 544588, 518846, 429800, 232676, 620371, 525425, 620366, 525411, 525404, 232638, 528845, 328428, 219587, 244031, 525367, 429640, 429599, 429590, 525290, 525288, 244014, 205937, 522326, 542142, 402765, 108671, 492558, 492554, 525153, 620164, 541604, 376236, 525108, 525106, 429310, 525057, 219495, 541197, 624820, 392927, 515282, 541117, 541115, 515277, 232590, 485643, 392122, 174277, 540323, 515259, 524921, 243965, 243940, 484453, 243929, 429087, 538812, 528687, 243912, 523182, 243907, 538638, 538632, 538625, 232513, 538619, 538612, 450375, 538603, 421578, 524814, 524812, 524802, 522294, 522292, 323985, 429056, 429054, 522286, 429052, 522284, 522282, 537905, 524791, 429050, 524780, 528681, 537859, 538041, 219408, 219406, 537901, 528674, 524731, 528672, 527587, 537899, 524727, 232490, 537583, 535414, 428998, 522271, 524716, 536948, 524710, 428984, 524148, 428632, 524132, 524112, 524110, 524094, 524075, 524041, 243795, 526499, 243793, 524024, 523986, 428572, 522768, 232305, 428540, 523553, 522883, 428533, 199896, 522897, 428486, 219132, 219130, 428480, 522881, 412011, 428473, 522262, 522260, 522255, 471171, 428450, 473548, 522699, 428438, 428436, 428433, 521043, 428430, 428428, 428426, 428424, 428422, 428420, 522695, 522407, 522585, 522425, 522250, 522240, 522233, 397287, 473546, 522396, 473543, 522229, 522222, 522219, 522217, 522215, 522204, 522202, 522196, 243680, 428394, 428388, 428386, 428382, 428380, 428372, 428366, 521634, 521650, 521519, 521517, 521514, 521345, 132839, 132834, 489794, 520991, 428210, 520770, 519933, 427967, 427962, 427896, 330310, 300842, 513848, 517541, 517622, 427829, 232184, 232182, 218900, 516798, 232179, 218894, 218892, 427813, 516207, 516825, 514880, 516811, 516859, 514877, 427789, 232159, 516657, 108395, 516047, 427775, 516045, 516655, 427772, 516242, 516653, 516732, 516651, 516647, 402736, 330307, 516240, 205868, 205863, 516266, 456751, 516315, 516313, 516263, 243582, 516311, 516306, 516261, 389703, 516253, 389701, 467641, 516202, 515193, 492133, 414020, 515706, 515778, 427737, 427732, 456130, 515251, 515716, 232118, 515246, 515244, 515190, 232114, 515237, 514471, 232107, 243555, 515178, 515167, 511791, 511846, 385897, 512868, 330299, 218779, 619497, 218736, 389698, 389694, 513607, 485424, 243531, 513236, 511340, 232054, 619477, 473535, 512850, 232048, 498268, 218682, 512845, 512703, 380434, 417837, 481545, 309300, 502913, 502909, 243514, 512292, 619464, 511773, 427609, 338980, 427603, 511998, 427595, 481538, 619453, 199759, 511938, 512021, 218655, 511936, 511933, 321129, 427585, 427581, 511744, 511735, 511729, 511717, 427561, 511691, 418787, 315512, 511322, 511368, 511365, 619419, 511334, 509544, 427460, 619403, 619401, 499897, 619399, 232011, 243466, 510903, 354464, 199709, 619368, 427380, 427364, 427320, 385055, 411944, 411941, 509854, 322479, 619351, 322477, 619349, 619338, 510424, 199673, 427279, 619336, 510088, 619333, 510079, 427276, 619325, 427271, 427269, 427262, 619310, 619308, 619306, 619304, 309294, 497497, 509907, 243422, 509759, 619289, 509720, 509734, 509712, 509707, 619285, 509191, 325403, 619280, 619278, 509579, 427184, 509525, 619259, 427160, 243401, 427152, 485354, 199637, 509080, 108340, 110382, 231918, 231912, 231910, 218536, 354460, 427063, 427061, 427010, 427007, 427004, 427002, 507816, 426994, 243303, 506286, 309142, 243286, 243281, 231840, 309121, 454023, 309102, 454018, 309082, 454016, 309079, 426882, 505880, 218451, 502553, 396456, 426741, 494810, 504751, 231767, 367313, 231733, 243178, 405754, 426664, 426655, 231644, 468312, 426641, 426620, 243101, 231573, 503878, 218330, 503443, 199483, 243044, 330261, 468985, 405740, 502980, 503094, 426556, 503088, 405719, 426500, 205820, 502489, 499323, 485286, 618959, 618952, 502358, 502126, 502081, 231452, 231447, 426418, 426396, 381595, 205818, 624734, 417793, 501794, 426377, 321047, 624721, 493443, 501308, 493440, 426304, 501610, 381593, 207535, 501290, 618888, 496455, 500863, 231402, 205812, 205810, 618878, 231375, 231369, 497899, 497896, 494173, 493969, 425696, 493273, 492828, 425654, 492130, 492125, 492120, 491994, 376187, 376170, 376169, 376165, 485204, 490079, 425601, 425598, 490076, 425596, 478265, 205795, 472616, 490944, 490069, 242568, 230716, 487359, 486309, 448634, 484390, 205752, 618158, 475294, 475136, 475266, 474809, 472301, 421389, 471613, 471610, 471582, 471579, 471460, 205709, 371636, 618046, 618036, 468500, 216983, 468449, 468416, 466505, 198655, 465795, 466080, 466317, 466076, 463761, 205663, 466063, 205660, 465786, 465784, 464534, 464528, 205653, 464411, 205651, 448592, 205647, 205631, 464650, 464648, 205620, 402687, 198467, 365177, 461296, 365171, 460674, 458071, 460715, 423946, 460578, 458064, 460712, 308811, 460205, 458262, 460163, 459671, 459779, 459663, 423909, 132368, 132361, 132359, 459186, 459183, 458851, 308804, 458351, 458116, 457261, 451140, 457311, 457227, 448570, 455665, 456959, 216599, 456525, 456523, 132299, 416380, 453230, 452315, 452163, 451789, 452023, 380175, 380173, 241216, 241214, 402652, 451681, 404570, 385826, 229450, 451107, 380166, 450470, 449772, 449720, 419155, 380158, 380150, 449528, 423796, 449526, 449633, 449632, 449499, 449176, 449169, 449270, 449165, 449266, 449263, 449330, 448968, 229384, 449249, 449244, 449241, 449239, 449194, 229368, 449236, 380147, 416371, 380144, 617487, 241058, 448774, 448772, 448756, 448750, 448748, 241041, 423780, 448081, 422663, 422660, 422657, 448510, 371598, 617483, 380140, 346398, 423771, 448437, 241008, 448279, 448277, 448242, 229331, 423766, 423748, 423738, 423602, 423600, 421823, 423597, 409767, 422719, 240924, 375245, 422628, 320544, 320527, 422609, 422065, 420907, 197957, 419677, 419675, 205521, 420248, 419877, 197933, 415394, 240793, 320506, 418975, 132182, 107308, 411590, 418640, 240724, 418579, 320502, 417694, 418240, 418304, 410852, 418300, 132165, 418001, 399248, 399245, 347746, 418070, 389792, 411577, 320498, 229008, 417406, 417352, 417350, 417298, 197863, 617305, 229003, 320494, 416363, 417209, 318054, 380036, 411572, 385812, 385810, 415811, 228903, 320489, 197823, 132127, 414752, 413251, 414313, 413704, 413699, 413628, 413625, 413572, 413570, 367090, 240514, 413225, 413223, 228821, 240484, 411443, 413129, 413125, 413122, 360807, 320453, 409711, 228656, 409719, 409581, 409716, 617160, 228651, 240317, 393909, 228644, 409258, 409563, 228641, 228638, 409513, 409251, 174262, 174259, 408492, 409399, 409296, 409149, 409147, 409143, 409056, 402642, 402640, 408838, 228572, 240250, 408858, 240247, 240237, 407111, 240223, 240216, 215739, 408626, 408553, 240183, 240177, 240172, 402632, 406147, 205494, 402613, 197428, 239883, 368785, 403306, 617058, 239866, 400977, 402179, 197393, 228182, 402912, 402608, 106889, 402905, 402899, 402601, 402599, 400015, 402595, 402585, 402581, 110107, 402471, 617044, 401813, 402461, 402455, 239832, 106876, 402368, 215468, 402170, 402167, 401796, 399878, 402163, 400618, 402121, 400950, 402134, 402057, 402039, 401968, 401719, 401696, 239720, 278045, 239637, 302067, 401185, 401208, 399746, 401269, 401178, 400898, 400882, 401173, 400941, 399745, 400694, 400692, 239627, 400527, 400441, 400542, 400538, 394726, 400523, 171710, 400432, 400273, 132010, 400255, 400253, 379943, 362127, 171703, 400236, 215332, 400244, 400238, 617008, 400233, 617006, 197310, 302065, 205443, 399954, 205438, 399971, 239619, 399952, 399839, 399950, 399654, 399648, 399636, 205420, 106823, 106821, 171690, 399565, 106819, 398981, 205406, 239557, 106811, 398234, 392468, 398853, 397480, 239519, 228001, 398782, 392464, 239516, 397779, 320398, 205399, 239490, 320396, 320395, 239488, 320393, 239482, 215260, 197238, 395364, 239478, 398436, 389674, 398230, 398228, 239473, 197230, 394511, 398224, 328298, 398222, 397686, 391063, 360796, 616941, 391694, 616935, 396904, 616932, 616929, 616926, 396274, 396272, 106697, 395698, 371532, 395691, 215155, 616855, 395359, 395354, 616844, 239324, 367007, 197071, 616842, 197069, 616840, 616837, 197066, 239318, 616834, 254036, 394712, 393476, 393742, 616833, 205329, 394708, 227759, 227757, 616831, 215125, 616828, 616826, 393474, 23380, 23377, 23375, 393472, 197053, 197050, 392458, 394468, 394401, 393469, 393467, 197045, 355118, 393895, 392444, 227703, 392438, 393888, 393463, 393458, 392418, 393601, 392416, 616805, 392414, 197024, 392412, 616801, 616798, 239236, 227701, 227699, 371530, 392403, 392397, 392390, 371526, 197002, 392383, 371524, 392379, 392377, 392370, 392368, 389777, 392354, 215026, 392305, 227656, 391666, 382098, 389773, 391658, 391965, 391636, 390020, 239131, 227644, 391525, 371507, 391521, 239074, 371504, 390415, 131883, 239048, 196970, 391397, 616681, 371487, 174218, 196966, 616650, 389640, 390389, 389636, 616641, 389634, 389585, 385502, 239003, 389765, 616619, 196942, 389761, 389565, 616616, 616613, 196933, 616604, 389729, 389553, 616594, 616592, 616588, 227570, 238899, 389395, 196925, 387582, 387578, 238879, 238877, 238874, 388667, 387955, 385051, 385494, 387927, 387888, 385490, 387947, 387923, 387916, 387921, 214874, 308728, 238856, 196915, 387883, 387568, 196910, 386970, 387233, 387327, 387184, 386954, 386629, 386928, 386892, 308711, 386887, 374652, 374648, 238822, 161757, 161755, 227466, 386446, 386444, 238810, 386414, 386412, 238808, 238803, 386410, 36067, 386313, 386378, 386375, 371476, 386290, 386287, 386285, 386283, 371474, 385531, 205324, 385488, 385176, 214748, 214733, 385467, 385483, 385480, 385478, 385465, 385476, 385463, 385423, 214728, 385420, 385418, 385414, 366976, 385039, 214587, 214585))
Run Time: 0.084623
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1597 | |
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 | | | | | 1597 | |
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 (30854, 30224, 29954, 28488, 28461, 28441, 28409, 27902, 27457, 26990, 26967, 26941, 26465, 25245, 23649, 22995, 22945, 21924, 21498, 21112, 20386, 20354, 20242, 20104, 19929, 19901, 19799, 19746, 19744, 19619, 19557, 19406, 19405, 19399, 19381, 19368))
Run Time: 0.004970
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 36 | 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 (589807, 589632, 585673, 437776, 585671, 589380, 527820, 579652, 437681, 437678, 437676, 437604, 437601, 437600, 437598, 246274, 587703, 547935, 587701, 437163, 587306, 434809, 245383, 245379, 575940, 245377, 245366, 221140, 221138, 539511, 221136, 309714, 221133, 245351, 245349, 200451, 353152, 245312, 245309, 245307, 622080, 493596, 576034, 625000, 575881, 575870, 434125, 552289, 574246, 536690, 575734, 575732, 575729, 434081, 575708, 108869, 530648, 530645, 206139, 434055, 377202, 575529, 434030, 575537, 412387, 245241, 412385, 526402, 434022, 386025, 575398, 575395, 558033, 417887, 494760, 206134, 624998, 482838, 575332, 564944, 573847, 553085, 233987, 558030, 553073, 558020, 515504, 515501, 515499, 515490, 515487, 526315, 515485, 515483, 220880, 526300, 233822, 233819, 571295, 621737, 571290, 380925, 621735, 526289, 233808, 200305, 233805, 485868, 432896, 621725, 432894, 309686, 565084, 553736, 233799, 380908, 567622, 474200, 380904, 571095, 110573, 244649, 244645, 621707, 371905, 244641, 371903, 571093, 570796, 570593, 371901, 571085, 567613, 570999, 220833, 488089, 621704, 553700, 220829, 309683, 309668, 432862, 309639, 309632, 570777, 570775, 570772, 570769, 133135, 432811, 309606, 432804, 432797, 432795, 527747, 329369, 244609, 413804, 552414, 413802, 570288, 233736, 385998, 337048, 418797, 535988, 244602, 526264, 553560, 233723, 324016, 233662, 233651, 432574, 328433, 569822, 432571, 569817, 518909, 233639, 220576, 244584, 569478, 206039, 624977, 206027, 556633, 431948, 564090, 564088, 244489, 431581, 431512, 285550, 431510, 360032, 285548, 431505, 624927, 244314, 244313, 558514, 558265, 624921, 558538, 557891, 552998, 521045, 557881, 557968, 552929, 557879, 552923, 527674, 555548, 557055, 555545, 323612, 535858, 624915, 552398, 624914, 244241, 431095, 431091, 431090, 525860, 431044, 555541, 555623, 547757, 529136, 529135, 200201, 624904, 552283, 232976, 430873, 552913, 520100, 552904, 520076, 244216, 520073, 520068, 520057, 520054, 520045, 520016, 520014, 430837, 520010, 468322, 549952, 549950, 620671, 244210, 529105, 341336, 430811, 430809, 529103, 133012, 133007, 552395, 133003, 133001, 430793, 529100, 108772, 552532, 519979, 205992, 515469, 219907, 430779, 430777, 522339, 430775, 347310, 552251, 303385, 430744, 219898, 551448, 303361, 551446, 244200, 552273, 244198, 552260, 430728, 244192, 430725, 430723, 244190, 430719, 430716, 430715, 430710, 232874, 430708, 552210, 551845, 551041, 515468, 514945, 551966, 551335, 551987, 551964, 405779, 515460, 529072, 519110, 551960, 412227, 232866, 525752, 525744, 551520, 232857, 232853, 205987, 309433, 309426, 551404, 309422, 430622, 551382, 430616, 430607, 468320, 529057, 244172, 244164, 551401, 551397, 522633, 376252, 376246, 244152, 430518, 380737, 522624, 430508, 430506, 430503, 546341, 430499, 430494, 325410, 219818, 338862, 338857, 548189, 108761, 525707, 205980, 548255, 430270, 430239, 430236, 108712, 430151, 515448, 503669, 232739, 536486, 429956, 205966, 256224, 256220, 525600, 232731, 232729, 429935, 525594, 545828, 244105, 545826, 525582, 545779, 525576, 244103, 624876, 528907, 525565, 528905, 545660, 620449, 545509, 244096, 515373, 515347, 515343, 515340, 515331, 244065, 515323, 515319, 515317, 544606, 525449, 624861, 515291, 515288, 525434, 429825, 544588, 518846, 429800, 232676, 620371, 525425, 620366, 525411, 525404, 232638, 528845, 328428, 219587, 244031, 525367, 429640, 429599, 429590, 525290, 525288, 244014, 205937, 522326, 542142, 402765, 108671, 492558, 492554, 525153, 620164, 541604, 376236, 525108, 525106, 429310, 525057, 219495, 541197, 624820, 392927, 515282, 541117, 541115, 515277, 232590, 485643, 392122, 174277, 540323, 515259, 524921, 243965, 243940, 484453, 243929, 429087, 538812, 528687, 243912, 523182, 243907, 538638, 538632, 538625, 232513, 538619, 538612, 450375, 538603, 421578, 524814, 524812, 524802, 522294, 522292, 323985, 429056, 429054, 522286, 429052, 522284, 522282, 537905, 524791, 429050, 524780, 528681, 537859, 538041, 219408, 219406, 537901, 528674, 524731, 528672, 527587, 537899, 524727, 232490, 537583, 535414, 428998, 522271, 524716, 536948, 524710, 428984, 524148, 428632, 524132, 524112, 524110, 524094, 524075, 524041, 243795, 526499, 243793, 524024, 523986, 428572, 522768, 232305, 428540, 523553, 522883, 428533, 199896, 522897, 428486, 219132, 219130, 428480, 522881, 412011, 428473, 522262, 522260, 522255, 471171, 428450, 473548, 522699, 428438, 428436, 428433, 521043, 428430, 428428, 428426, 428424, 428422, 428420, 522695, 522407, 522585, 522425, 522250, 522240, 522233, 397287, 473546, 522396, 473543, 522229, 522222, 522219, 522217, 522215, 522204, 522202, 522196, 243680, 428394, 428388, 428386, 428382, 428380, 428372, 428366, 521634, 521650, 521519, 521517, 521514, 521345, 132839, 132834, 489794, 520991, 428210, 520770, 519933, 427967, 427962, 427896, 330310, 300842, 513848, 517541, 517622, 427829, 232184, 232182, 218900, 516798, 232179, 218894, 218892, 427813, 516207, 516825, 514880, 516811, 516859, 514877, 427789, 232159, 516657, 108395, 516047, 427775, 516045, 516655, 427772, 516242, 516653, 516732, 516651, 516647, 402736, 330307, 516240, 205868, 205863, 516266, 456751, 516315, 516313, 516263, 243582, 516311, 516306, 516261, 389703, 516253, 389701, 467641, 516202, 515193, 492133, 414020, 515706, 515778, 427737, 427732, 456130, 515251, 515716, 232118, 515246, 515244, 515190, 232114, 515237, 514471, 232107, 243555, 515178, 515167, 511791, 511846, 385897, 512868, 330299, 218779, 619497, 218736, 389698, 389694, 513607, 485424, 243531, 513236, 511340, 232054, 619477, 473535, 512850, 232048, 498268, 218682, 512845, 512703, 380434, 417837, 481545, 309300, 502913, 502909, 243514, 512292, 619464, 511773, 427609, 338980, 427603, 511998, 427595, 481538, 619453, 199759, 511938, 512021, 218655, 511936, 511933, 321129, 427585, 427581, 511744, 511735, 511729, 511717, 427561, 511691, 418787, 315512, 511322, 511368, 511365, 619419, 511334, 509544, 427460, 619403, 619401, 499897, 619399, 232011, 243466, 510903, 354464, 199709, 619368, 427380, 427364, 427320, 385055, 411944, 411941, 509854, 322479, 619351, 322477, 619349, 619338, 510424, 199673, 427279, 619336, 510088, 619333, 510079, 427276, 619325, 427271, 427269, 427262, 619310, 619308, 619306, 619304, 309294, 497497, 509907, 243422, 509759, 619289, 509720, 509734, 509712, 509707, 619285, 509191, 325403, 619280, 619278, 509579, 427184, 509525, 619259, 427160, 243401, 427152, 485354, 199637, 509080, 108340, 110382, 231918, 231912, 231910, 218536, 354460, 427063, 427061, 427010, 427007, 427004, 427002, 507816, 426994, 243303, 506286, 309142, 243286, 243281, 231840, 309121, 454023, 309102, 454018, 309082, 454016, 309079, 426882, 505880, 218451, 502553, 396456, 426741, 494810, 504751, 231767, 367313, 231733, 243178, 405754, 426664, 426655, 231644, 468312, 426641, 426620, 243101, 231573, 503878, 218330, 503443, 199483, 243044, 330261, 468985, 405740, 502980, 503094, 426556, 503088, 405719, 426500, 205820, 502489, 499323, 485286, 618959, 618952, 502358, 502126, 502081, 231452, 231447, 426418, 426396, 381595, 205818, 624734, 417793, 501794, 426377, 321047, 624721, 493443, 501308, 493440, 426304, 501610, 381593, 207535, 501290, 618888, 496455, 500863, 231402, 205812, 205810, 618878, 231375, 231369, 497899, 497896, 494173, 493969, 425696, 493273, 492828, 425654, 492130, 492125, 492120, 491994, 376187, 376170, 376169, 376165, 485204, 490079, 425601, 425598, 490076, 425596, 478265, 205795, 472616, 490944, 490069, 242568, 230716, 487359, 486309, 448634, 484390, 205752, 618158, 475294, 475136, 475266, 474809, 472301, 421389, 471613, 471610, 471582, 471579, 471460, 205709, 371636, 618046, 618036, 468500, 216983, 468449, 468416, 466505, 198655, 465795, 466080, 466317, 466076, 463761, 205663, 466063, 205660, 465786, 465784, 464534, 464528, 205653, 464411, 205651, 448592, 205647, 205631, 464650, 464648, 205620, 402687, 198467, 365177, 461296, 365171, 460674, 458071, 460715, 423946, 460578, 458064, 460712, 308811, 460205, 458262, 460163, 459671, 459779, 459663, 423909, 132368, 132361, 132359, 459186, 459183, 458851, 308804, 458351, 458116, 457261, 451140, 457311, 457227, 448570, 455665, 456959, 216599, 456525, 456523, 132299, 416380, 453230, 452315, 452163, 451789, 452023, 380175, 380173, 241216, 241214, 402652, 451681, 404570, 385826, 229450, 451107, 380166, 450470, 449772, 449720, 419155, 380158, 380150, 449528, 423796, 449526, 449633, 449632, 449499, 449176, 449169, 449270, 449165, 449266, 449263, 449330, 448968, 229384, 449249, 449244, 449241, 449239, 449194, 229368, 449236, 380147, 416371, 380144, 617487, 241058, 448774, 448772, 448756, 448750, 448748, 241041, 423780, 448081, 422663, 422660, 422657, 448510, 371598, 617483, 380140, 346398, 423771, 448437, 241008, 448279, 448277, 448242, 229331, 423766, 423748, 423738, 423602, 423600, 421823, 423597, 409767, 422719, 240924, 375245, 422628, 320544, 320527, 422609, 422065, 420907, 197957, 419677, 419675, 205521, 420248, 419877, 197933, 415394, 240793, 320506, 418975, 132182, 107308, 411590, 418640, 240724, 418579, 320502, 417694, 418240, 418304, 410852, 418300, 132165, 418001, 399248, 399245, 347746, 418070, 389792, 411577, 320498, 229008, 417406, 417352, 417350, 417298, 197863, 617305, 229003, 320494, 416363, 417209, 318054, 380036, 411572, 385812, 385810, 415811, 228903, 320489, 197823, 132127, 414752, 413251, 414313, 413704, 413699, 413628, 413625, 413572, 413570, 367090, 240514, 413225, 413223, 228821, 240484, 411443, 413129, 413125, 413122, 360807, 320453, 409711, 228656, 409719, 409581, 409716, 617160, 228651, 240317, 393909, 228644, 409258, 409563, 228641, 228638, 409513, 409251, 174262, 174259, 408492, 409399, 409296, 409149, 409147, 409143, 409056, 402642, 402640, 408838, 228572, 240250, 408858, 240247, 240237, 407111, 240223, 240216, 215739, 408626, 408553, 240183, 240177, 240172, 402632, 406147, 205494, 402613, 197428, 239883, 368785, 403306, 617058, 239866, 400977, 402179, 197393, 228182, 402912, 402608, 106889, 402905, 402899, 402601, 402599, 400015, 402595, 402585, 402581, 110107, 402471, 617044, 401813, 402461, 402455, 239832, 106876, 402368, 215468, 402170, 402167, 401796, 399878, 402163, 400618, 402121, 400950, 402134, 402057, 402039, 401968, 401719, 401696, 239720, 278045, 239637, 302067, 401185, 401208, 399746, 401269, 401178, 400898, 400882, 401173, 400941, 399745, 400694, 400692, 239627, 400527, 400441, 400542, 400538, 394726, 400523, 171710, 400432, 400273, 132010, 400255, 400253, 379943, 362127, 171703, 400236, 215332, 400244, 400238, 617008, 400233, 617006, 197310, 302065, 205443, 399954, 205438, 399971, 239619, 399952, 399839, 399950, 399654, 399648, 399636, 205420, 106823, 106821, 171690, 399565, 106819, 398981, 205406, 239557, 106811, 398234, 392468, 398853, 397480, 239519, 228001, 398782, 392464, 239516, 397779, 320398, 205399, 239490, 320396, 320395, 239488, 320393, 239482, 215260, 197238, 395364, 239478, 398436, 389674, 398230, 398228, 239473, 197230, 394511, 398224, 328298, 398222, 397686, 391063, 360796, 616941, 391694, 616935, 396904, 616932, 616929, 616926, 396274, 396272, 106697, 395698, 371532, 395691, 215155, 616855, 395359, 395354, 616844, 239324, 367007, 197071, 616842, 197069, 616840, 616837, 197066, 239318, 616834, 254036, 394712, 393476, 393742, 616833, 205329, 394708, 227759, 227757, 616831, 215125, 616828, 616826, 393474, 23380, 23377, 23375, 393472, 197053, 197050, 392458, 394468, 394401, 393469, 393467, 197045, 355118, 393895, 392444, 227703, 392438, 393888, 393463, 393458, 392418, 393601, 392416, 616805, 392414, 197024, 392412, 616801, 616798, 239236, 227701, 227699, 371530, 392403, 392397, 392390, 371526, 197002, 392383, 371524, 392379, 392377, 392370, 392368, 389777, 392354, 215026, 392305, 227656, 391666, 382098, 389773, 391658, 391965, 391636, 390020, 239131, 227644, 391525, 371507, 391521, 239074, 371504, 390415, 131883, 239048, 196970, 391397, 616681, 371487, 174218, 196966, 616650, 389640, 390389, 389636, 616641, 389634, 389585, 385502, 239003, 389765, 616619, 196942, 389761, 389565, 616616, 616613, 196933, 616604, 389729, 389553, 616594, 616592, 616588, 227570, 238899, 389395, 196925, 387582, 387578, 238879, 238877, 238874, 388667, 387955, 385051, 385494, 387927, 387888, 385490, 387947, 387923, 387916, 387921, 214874, 308728, 238856, 196915, 387883, 387568, 196910, 386970, 387233, 387327, 387184, 386954, 386629, 386928, 386892, 308711, 386887, 374652, 374648, 238822, 161757, 161755, 227466, 386446, 386444, 238810, 386414, 386412, 238808, 238803, 386410, 36067, 386313, 386378, 386375, 371476, 386290, 386287, 386285, 386283, 371474, 385531, 205324, 385488, 385176, 214748, 214733, 385467, 385483, 385480, 385478, 385465, 385476, 385463, 385423, 214728, 385420, 385418, 385414, 366976, 385039, 214587, 214585))
Run Time: 0.034517
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1597 | |
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 | | | | | 1597 | |
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 (30854, 30224, 29954, 28488, 28461, 28441, 28409, 27902, 27457, 26990, 26967, 26941, 26465, 25245, 23649, 22995, 22945, 21924, 21498, 21112, 20386, 20354, 20242, 20104, 19929, 19901, 19799, 19746, 19744, 19619, 19557, 19406, 19405, 19399, 19381, 19368))
Run Time: 0.001727
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 36 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, ���
Run Time: 0.000183
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
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: ���, XF\Pub\Controller\Member, RecentContent, valid, user_id=4585, 1716204569, , 0, ���
Run Time: 0.000360
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- 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.000335
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 215
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (120))
Run Time: 0.000762
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1716204269
Run Time: 0.000389
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 23 | 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` >= 1716204269)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000653
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 23 | 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