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.000582
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.000208
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` = '4048')
LIMIT 1
Run Time: 0.000382
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.002346
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_4048' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.074104
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 (560307, 568917, 557116, 568702, 282556, 568692, 568007, 557114, 568325, 293567, 291897, 294882, 294880, 543500, 567777, 567245, 286559, 286552, 289656, 289654, 566320, 566559, 564773, 564771, 282415, 566344, 566452, 566335, 566318, 566315, 565246, 543497, 566064, 290903, 565325, 565324, 287107, 565242, 565491, 543495, 543493, 277025, 277022, 563947, 295867, 294367, 562659, 562533, 562643, 561229, 528030, 293546, 277005, 277002, 275416, 562256, 489616, 277000, 561876, 561606, 561600, 417385, 365976, 560973, 293542, 561046, 560969, 454780, 560892, 560840, 560072, 560763, 560070, 560066, 557813, 289651, 490159, 559466, 378884, 559352, 559263, 559262, 330997, 559257, 559051, 558207, 517975, 558201, 558199, 544552, 275649, 275647, 275645, 558990, 558987, 541001, 558982, 558181, 558980, 555895, 555884, 286506, 293525, 558548, 557769, 498182, 498180, 289646, 556430, 415674, 556428, 556424, 556726, 556733, 316210, 556418, 555919, 550308, 555787, 555817, 555812, 550293, 555736, 544544, 555433, 491329, 282082, 319567, 365974, 555129, 555230, 492392, 462863, 462861, 286492, 552626, 462856, 552648, 544541, 493050, 286483, 540321, 552003, 293518, 547500, 541802, 321513, 548462, 286473, 286471, 486599, 486596, 492370, 547037, 547035, 508977, 545559, 286464, 545558, 546232, 545557, 546229, 547520, 540768, 281952, 281950, 281947, 547495, 540054, 540052, 281943, 281940, 546510, 535562, 486594, 547090, 546506, 486593, 486587, 546495, 545290, 291862, 546487, 546485, 546484, 352595, 352593, 293515, 276972, 276970, 545304, 541882, 541880, 513588, 544498, 541797, 541786, 544537, 285398, 275385, 543291, 543289, 408461, 513025, 544328, 331509, 352407, 541877, 541875, 541871, 541869, 541866, 542369, 284337, 542055, 540699, 541860, 335217, 315458, 284725, 304422, 304419, 304412, 535558, 538987, 294877, 287050, 540313, 287047, 287042, 537268, 537264, 286143, 540302, 538982, 538980, 454777, 484630, 538973, 538971, 539056, 281810, 539036, 287030, 538968, 538966, 538963, 484581, 538347, 535556, 538656, 517851, 537534, 538345, 538577, 293498, 517848, 289642, 276281, 537234, 293496, 538302, 538342, 410367, 281791, 538065, 486575, 281789, 538063, 281787, 537749, 319735, 537799, 506572, 506570, 506568, 537796, 535554, 486573, 486571, 537358, 486569, 537297, 518314, 286138, 537295, 536909, 537119, 486563, 537117, 278736, 476004, 536906, 278734, 475997, 486561, 475992, 275628, 326280, 536715, 518798, 535551, 279579, 535750, 535748, 521248, 536549, 512768, 527127, 475972, 279577, 293481, 528029, 535476, 535076, 535074, 535470, 535071, 535269, 506764, 528557, 486560, 286136, 523505, 486558, 495995, 523495, 486556, 523493, 523491, 329021, 281707, 486554, 422398, 281690, 422394, 528384, 287889, 481242, 281674, 528474, 290657, 528471, 481237, 293479, 281660, 528382, 523485, 286134, 523481, 527373, 527371, 287885, 281652, 486551, 281642, 516193, 417381, 495977, 304393, 281613, 304391, 495969, 527167, 527101, 344893, 291175, 304382, 290889, 290887, 304380, 527268, 527224, 527099, 527155, 454775, 527173, 527151, 527119, 527143, 293470, 527110, 526661, 527013, 526659, 523927, 526655, 523348, 281550, 291172, 281545, 281543, 289845, 353336, 304376, 304374, 495919, 455705, 463960, 304365, 275870, 502029, 502026, 287014, 287012, 490218, 360496, 360494, 360493, 286461, 360490, 523935, 295862, 475914, 475912, 475910, 284042, 475908, 486222, 475901, 275868, 486218, 486216, 475899, 276962, 281406, 281401, 281398, 276960, 272988, 279332, 279330, 281395, 286451, 281392, 286447, 281388, 286445, 521840, 276265, 290602, 522932, 276257, 522482, 276255, 521590, 522823, 522480, 272984, 377486, 313044, 498144, 293456, 521786, 290885, 518181, 518178, 518175, 518166, 508973, 520927, 520926, 521538, 521475, 521536, 521356, 520701, 521175, 520967, 518968, 276954, 520854, 520550, 520347, 520128, 520126, 520344, 518517, 492694, 475840, 311550, 518966, 518964, 475830, 475827, 288374, 519411, 416768, 519217, 481225, 510707, 518987, 510705, 475816, 481223, 515653, 518305, 289634, 510702, 289631, 353322, 329016, 290596, 289840, 289837, 483776, 418126, 418123, 275623, 275622, 511228, 418120, 290651, 511283, 511223, 484719, 290646, 290644, 286977, 276936, 276934, 276930, 286973, 286970, 509937, 281052, 509040, 509033, 290873, 290871, 286964, 483754, 508082, 286442, 454771, 508955, 506558, 508863, 284326, 454767, 486718, 475656, 486715, 507976, 336566, 507971, 508075, 274189, 294874, 454764, 294871, 505517, 505775, 505751, 505626, 454755, 454749, 454747, 274716, 454745, 505748, 506031, 505961, 454740, 472464, 274714, 505743, 505741, 454733, 454729, 289617, 505588, 505624, 505379, 505523, 421358, 421356, 285389, 475603, 503031, 504915, 504872, 504491, 505299, 472843, 472839, 504487, 504869, 504485, 503933, 500177, 342201, 454722, 504480, 454719, 334098, 286436, 286434, 334096, 293689, 500174, 293687, 499834, 286431, 503853, 285384, 503589, 502116, 293411, 502233, 502232, 490854, 290574, 275606, 286424, 285379, 500170, 500167, 410359, 499831, 495480, 290561, 500156, 500154, 315453, 315451, 499828, 498194, 285370, 457388, 457385, 290862, 275602, 286099, 493035, 275597, 498721, 498949, 286097, 286094, 499283, 499280, 342842, 292454, 499103, 463296, 463293, 321512, 292448, 292446, 487443, 498974, 498972, 321510, 493248, 493246, 498123, 497636, 454715, 489559, 338278, 284715, 457884, 496524, 496514, 494147, 494145, 465099, 289135, 284316, 493138, 463292, 352398, 494137, 495018, 495014, 495140, 494588, 286920, 494581, 494579, 494576, 494574, 301471, 291923, 301468, 276173, 494383, 290857, 492865, 335201, 472449, 286399, 286071, 417054, 286069, 286066, 293371, 494097, 463288, 494049, 493939, 311003, 492590, 494017, 360347, 493836, 493834, 493832, 408925, 275863, 310997, 493780, 493774, 478870, 310994, 478868, 490798, 478860, 490796, 478857, 493030, 490258, 486727, 492180, 492651, 492649, 491896, 492647, 492643, 492641, 288579, 492639, 352589, 492357, 492354, 489382, 284312, 284310, 492168, 300214, 492058, 484969, 408916, 484960, 484957, 286915, 484953, 484947, 489273, 489271, 489269, 286389, 286387, 488794, 488834, 488960, 488830, 449849, 366553, 488288, 449846, 449844, 483746, 449842, 488108, 449839, 449836, 478632, 305983, 484741, 480743, 484527, 484525, 484519, 484516, 410407, 484697, 484734, 286374, 484513, 293278, 467580, 484510, 484692, 274167, 484428, 478614, 483167, 274042, 293273, 484413, 484409, 381394, 484295, 273535, 290549, 482905, 482903, 483164, 482901, 294868, 483577, 483545, 473155, 329722, 480731, 483099, 483532, 479912, 479908, 313019, 483159, 483156, 483154, 420750, 342196, 342174, 392030, 274037, 482556, 482614, 274035, 274030, 482453, 274028, 482316, 480516, 274023, 286361, 294863, 481474, 482313, 301897, 274017, 482021, 482017, 481401, 288059, 480961, 480724, 480639, 480370, 480169, 480368, 480366, 480298, 296842, 286349, 479867, 286867, 479720, 286862, 410403, 291158, 291156, 384468, 474598, 473302, 384466, 293196, 472665, 473151, 384464, 286342, 472941, 472939, 472933, 472920, 472917, 473059, 290833, 472888, 286836, 286833, 286830, 294857, 294855, 294852, 472350, 461445, 472417, 294848, 459455, 315437, 471774, 470440, 283896, 470207, 469603, 291774, 469550, 469597, 417044, 469595, 315419, 469650, 469644, 275296, 422925, 422922, 468810, 291154, 422910, 394968, 457871, 467617, 272979, 467614, 468607, 385092, 315940, 293153, 305957, 293149, 305951, 392018, 392015, 467892, 395101, 467888, 305949, 295142, 468084, 467883, 286796, 462168, 467553, 467556, 275858, 467549, 279572, 279570, 454672, 279568, 389349, 462335, 326020, 462280, 463355, 463279, 463253, 293118, 276857, 462944, 455204, 459522, 336827, 462467, 462276, 459519, 462333, 293115, 300435, 462331, 336823, 336820, 293110, 461973, 462271, 336818, 461383, 459515, 461151, 374048, 300428, 461149, 374046, 300424, 461144, 280840, 461377, 461434, 461139, 284294, 276853, 285990, 285988, 461371, 457865, 337651, 302768, 458801, 460634, 335184, 335182, 293107, 455699, 460191, 346080, 284286, 284284, 276564, 457861, 296484, 284280, 460277, 300420, 284276, 458954, 450532, 459993, 284273, 459353, 300418, 276840, 458951, 300412, 346075, 458415, 456316, 275854, 459024, 458799, 457521, 322672, 275850, 458411, 422018, 294845, 290638, 279563, 294841, 290802, 352261, 458187, 457500, 285984, 458037, 458034, 457378, 457514, 457511, 457493, 451074, 457240, 457375, 286323, 454942, 322670, 456826, 289821, 280802, 456692, 456690, 275833, 456685, 360456, 335177, 394945, 451625, 418102, 286296, 454645, 449388, 290635, 454193, 454073, 454071, 287860, 290794, 290792, 290790, 453256, 384610, 451968, 452537, 451046, 319693, 451040, 452526, 276822, 290526, 290524, 285979, 274702, 451038, 280751, 452381, 451034, 274700, 291143, 289818, 286785, 291141, 276819, 451617, 276817, 287159, 451590, 422796, 451660, 451581, 290786, 290784, 377475, 451608, 422790, 290781, 276073, 286775, 451016, 286773, 325997, 305938, 286285, 449830, 286282, 286280, 449828, 377469, 451011, 312993, 275530, 365936, 365934, 325993, 449824, 290773, 449820, 290771, 350450, 449372, 290767, 377457, 286768, 335173, 413865, 284269, 284267, 290520, 290511, 284264, 290509, 447961, 413857, 292429, 413855, 293068, 292426, 423468, 422429, 274697, 319560, 274695, 341533, 291490, 420089, 291137, 421346, 421344, 315409, 315406, 290506, 336552, 276810, 290495, 391551, 276808, 341529, 291135, 275818, 457857, 418318, 321505, 396254, 419141, 418832, 419139, 418830, 407026, 407024, 291132, 457853, 396252, 339441, 396246, 290761, 383149, 290757, 291129, 418090, 276794, 418088, 288355, 291125, 290631, 417030, 319550, 291123, 417486, 408421, 290755, 291120, 417337, 417364, 417333, 417473, 416963, 276791, 416995, 319542, 416959, 291114, 417018, 414923, 416486, 294838, 290747, 414903, 415900, 415765, 415516, 391440, 284261, 413008, 351241, 375535, 344734, 280701, 375532, 413091, 300372, 412762, 345292, 300366, 411368, 411365, 411361, 410803, 411357, 410799, 411006, 410783, 410130, 396234, 335163, 280688, 396232, 343229, 410119, 335155, 410116, 410114, 343227, 410111, 391435, 410525, 410108, 410331, 280679, 410327, 410325, 410179, 351235, 343224, 343220, 280676, 286735, 290493, 409474, 407811, 406663, 408643, 408911, 408356, 408470, 407808, 408097, 290465, 407016, 314322, 404216, 381354, 397545, 384460, 291112, 400166, 275137, 288913, 397531, 397525, 294833, 292374, 399467, 291105, 291102, 398665, 284253, 284251, 291099, 283845, 285340, 397519, 285338, 285336, 342946, 342944, 396227, 315395, 396744, 396225, 396740, 395329, 294831, 395565, 294829, 294827, 294825, 292372, 395562, 292370, 394680, 394928, 394979, 304782, 304780, 394678, 394924, 315392, 304777, 292366, 307936, 315390, 291093, 274746, 342940, 391997, 391537, 457779, 391420, 384453, 457775, 457770, 314867, 388518, 388516, 388511, 385087, 385084, 274686, 385082, 385711, 276734, 372320, 352146, 275807, 280606, 379449, 385080, 352141, 384792, 291088, 384450, 384601, 384499, 384448, 384446, 291081, 384262, 291077, 382793, 314864, 291917, 322658, 322656, 322654, 352131, 352129, 379612, 315380, 381963, 381289, 276716, 284688, 377343, 378943, 378939, 276710, 276708, 276704, 319532, 276700, 292361, 305058, 292356, 347045, 290217, 292354, 292351, 375525, 314861, 274158, 291071, 375521, 291069, 292344, 291066, 291064, 292337, 292333, 373640, 292328, 314844, 292323, 292321, 292317, 292312, 314842, 344394, 305767, 341517, 275788, 368572, 286696, 305754, 338538, 338536, 321497, 321495, 335146, 364612, 358686, 276691, 273293, 273292, 276681, 360990, 360988, 358823, 358820, 292948, 339437, 274682, 352687, 316346, 358817, 358815, 311519, 276660, 276658, 311516, 311514, 279557, 279555, 357871, 289343, 311507, 314831, 357457, 315279, 341514, 314829, 314827, 337600, 314823, 337598, 337596, 327983, 341511, 276654, 341508, 292276, 284238, 284236, 284234, 284231, 351404, 352106, 352686, 288887, 279553, 352684, 292940, 292938, 292936, 352105, 279550, 352101, 352097, 279548, 352094, 276652, 276650, 351784, 276647, 351402, 276644, 349800, 292933, 292931, 272608))
Run Time: 0.089356
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1492 | |
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 | | | | | 1492 | |
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 (29707, 29427, 29097, 28478, 27330, 27261, 27188, 26694, 26009, 25569, 24575, 24301, 23987, 23183, 22477, 22060, 20875, 20821, 20743, 20229, 20179, 20021, 19924, 19370, 19305, 18709, 17940, 17784, 17781, 17586, 17511))
Run Time: 0.004692
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 31 | 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 (560307, 568917, 557116, 568702, 282556, 568692, 568007, 557114, 568325, 293567, 291897, 294882, 294880, 543500, 567777, 567245, 286559, 286552, 289656, 289654, 566320, 566559, 564773, 564771, 282415, 566344, 566452, 566335, 566318, 566315, 565246, 543497, 566064, 290903, 565325, 565324, 287107, 565242, 565491, 543495, 543493, 277025, 277022, 563947, 295867, 294367, 562659, 562533, 562643, 561229, 528030, 293546, 277005, 277002, 275416, 562256, 489616, 277000, 561876, 561606, 561600, 417385, 365976, 560973, 293542, 561046, 560969, 454780, 560892, 560840, 560072, 560763, 560070, 560066, 557813, 289651, 490159, 559466, 378884, 559352, 559263, 559262, 330997, 559257, 559051, 558207, 517975, 558201, 558199, 544552, 275649, 275647, 275645, 558990, 558987, 541001, 558982, 558181, 558980, 555895, 555884, 286506, 293525, 558548, 557769, 498182, 498180, 289646, 556430, 415674, 556428, 556424, 556726, 556733, 316210, 556418, 555919, 550308, 555787, 555817, 555812, 550293, 555736, 544544, 555433, 491329, 282082, 319567, 365974, 555129, 555230, 492392, 462863, 462861, 286492, 552626, 462856, 552648, 544541, 493050, 286483, 540321, 552003, 293518, 547500, 541802, 321513, 548462, 286473, 286471, 486599, 486596, 492370, 547037, 547035, 508977, 545559, 286464, 545558, 546232, 545557, 546229, 547520, 540768, 281952, 281950, 281947, 547495, 540054, 540052, 281943, 281940, 546510, 535562, 486594, 547090, 546506, 486593, 486587, 546495, 545290, 291862, 546487, 546485, 546484, 352595, 352593, 293515, 276972, 276970, 545304, 541882, 541880, 513588, 544498, 541797, 541786, 544537, 285398, 275385, 543291, 543289, 408461, 513025, 544328, 331509, 352407, 541877, 541875, 541871, 541869, 541866, 542369, 284337, 542055, 540699, 541860, 335217, 315458, 284725, 304422, 304419, 304412, 535558, 538987, 294877, 287050, 540313, 287047, 287042, 537268, 537264, 286143, 540302, 538982, 538980, 454777, 484630, 538973, 538971, 539056, 281810, 539036, 287030, 538968, 538966, 538963, 484581, 538347, 535556, 538656, 517851, 537534, 538345, 538577, 293498, 517848, 289642, 276281, 537234, 293496, 538302, 538342, 410367, 281791, 538065, 486575, 281789, 538063, 281787, 537749, 319735, 537799, 506572, 506570, 506568, 537796, 535554, 486573, 486571, 537358, 486569, 537297, 518314, 286138, 537295, 536909, 537119, 486563, 537117, 278736, 476004, 536906, 278734, 475997, 486561, 475992, 275628, 326280, 536715, 518798, 535551, 279579, 535750, 535748, 521248, 536549, 512768, 527127, 475972, 279577, 293481, 528029, 535476, 535076, 535074, 535470, 535071, 535269, 506764, 528557, 486560, 286136, 523505, 486558, 495995, 523495, 486556, 523493, 523491, 329021, 281707, 486554, 422398, 281690, 422394, 528384, 287889, 481242, 281674, 528474, 290657, 528471, 481237, 293479, 281660, 528382, 523485, 286134, 523481, 527373, 527371, 287885, 281652, 486551, 281642, 516193, 417381, 495977, 304393, 281613, 304391, 495969, 527167, 527101, 344893, 291175, 304382, 290889, 290887, 304380, 527268, 527224, 527099, 527155, 454775, 527173, 527151, 527119, 527143, 293470, 527110, 526661, 527013, 526659, 523927, 526655, 523348, 281550, 291172, 281545, 281543, 289845, 353336, 304376, 304374, 495919, 455705, 463960, 304365, 275870, 502029, 502026, 287014, 287012, 490218, 360496, 360494, 360493, 286461, 360490, 523935, 295862, 475914, 475912, 475910, 284042, 475908, 486222, 475901, 275868, 486218, 486216, 475899, 276962, 281406, 281401, 281398, 276960, 272988, 279332, 279330, 281395, 286451, 281392, 286447, 281388, 286445, 521840, 276265, 290602, 522932, 276257, 522482, 276255, 521590, 522823, 522480, 272984, 377486, 313044, 498144, 293456, 521786, 290885, 518181, 518178, 518175, 518166, 508973, 520927, 520926, 521538, 521475, 521536, 521356, 520701, 521175, 520967, 518968, 276954, 520854, 520550, 520347, 520128, 520126, 520344, 518517, 492694, 475840, 311550, 518966, 518964, 475830, 475827, 288374, 519411, 416768, 519217, 481225, 510707, 518987, 510705, 475816, 481223, 515653, 518305, 289634, 510702, 289631, 353322, 329016, 290596, 289840, 289837, 483776, 418126, 418123, 275623, 275622, 511228, 418120, 290651, 511283, 511223, 484719, 290646, 290644, 286977, 276936, 276934, 276930, 286973, 286970, 509937, 281052, 509040, 509033, 290873, 290871, 286964, 483754, 508082, 286442, 454771, 508955, 506558, 508863, 284326, 454767, 486718, 475656, 486715, 507976, 336566, 507971, 508075, 274189, 294874, 454764, 294871, 505517, 505775, 505751, 505626, 454755, 454749, 454747, 274716, 454745, 505748, 506031, 505961, 454740, 472464, 274714, 505743, 505741, 454733, 454729, 289617, 505588, 505624, 505379, 505523, 421358, 421356, 285389, 475603, 503031, 504915, 504872, 504491, 505299, 472843, 472839, 504487, 504869, 504485, 503933, 500177, 342201, 454722, 504480, 454719, 334098, 286436, 286434, 334096, 293689, 500174, 293687, 499834, 286431, 503853, 285384, 503589, 502116, 293411, 502233, 502232, 490854, 290574, 275606, 286424, 285379, 500170, 500167, 410359, 499831, 495480, 290561, 500156, 500154, 315453, 315451, 499828, 498194, 285370, 457388, 457385, 290862, 275602, 286099, 493035, 275597, 498721, 498949, 286097, 286094, 499283, 499280, 342842, 292454, 499103, 463296, 463293, 321512, 292448, 292446, 487443, 498974, 498972, 321510, 493248, 493246, 498123, 497636, 454715, 489559, 338278, 284715, 457884, 496524, 496514, 494147, 494145, 465099, 289135, 284316, 493138, 463292, 352398, 494137, 495018, 495014, 495140, 494588, 286920, 494581, 494579, 494576, 494574, 301471, 291923, 301468, 276173, 494383, 290857, 492865, 335201, 472449, 286399, 286071, 417054, 286069, 286066, 293371, 494097, 463288, 494049, 493939, 311003, 492590, 494017, 360347, 493836, 493834, 493832, 408925, 275863, 310997, 493780, 493774, 478870, 310994, 478868, 490798, 478860, 490796, 478857, 493030, 490258, 486727, 492180, 492651, 492649, 491896, 492647, 492643, 492641, 288579, 492639, 352589, 492357, 492354, 489382, 284312, 284310, 492168, 300214, 492058, 484969, 408916, 484960, 484957, 286915, 484953, 484947, 489273, 489271, 489269, 286389, 286387, 488794, 488834, 488960, 488830, 449849, 366553, 488288, 449846, 449844, 483746, 449842, 488108, 449839, 449836, 478632, 305983, 484741, 480743, 484527, 484525, 484519, 484516, 410407, 484697, 484734, 286374, 484513, 293278, 467580, 484510, 484692, 274167, 484428, 478614, 483167, 274042, 293273, 484413, 484409, 381394, 484295, 273535, 290549, 482905, 482903, 483164, 482901, 294868, 483577, 483545, 473155, 329722, 480731, 483099, 483532, 479912, 479908, 313019, 483159, 483156, 483154, 420750, 342196, 342174, 392030, 274037, 482556, 482614, 274035, 274030, 482453, 274028, 482316, 480516, 274023, 286361, 294863, 481474, 482313, 301897, 274017, 482021, 482017, 481401, 288059, 480961, 480724, 480639, 480370, 480169, 480368, 480366, 480298, 296842, 286349, 479867, 286867, 479720, 286862, 410403, 291158, 291156, 384468, 474598, 473302, 384466, 293196, 472665, 473151, 384464, 286342, 472941, 472939, 472933, 472920, 472917, 473059, 290833, 472888, 286836, 286833, 286830, 294857, 294855, 294852, 472350, 461445, 472417, 294848, 459455, 315437, 471774, 470440, 283896, 470207, 469603, 291774, 469550, 469597, 417044, 469595, 315419, 469650, 469644, 275296, 422925, 422922, 468810, 291154, 422910, 394968, 457871, 467617, 272979, 467614, 468607, 385092, 315940, 293153, 305957, 293149, 305951, 392018, 392015, 467892, 395101, 467888, 305949, 295142, 468084, 467883, 286796, 462168, 467553, 467556, 275858, 467549, 279572, 279570, 454672, 279568, 389349, 462335, 326020, 462280, 463355, 463279, 463253, 293118, 276857, 462944, 455204, 459522, 336827, 462467, 462276, 459519, 462333, 293115, 300435, 462331, 336823, 336820, 293110, 461973, 462271, 336818, 461383, 459515, 461151, 374048, 300428, 461149, 374046, 300424, 461144, 280840, 461377, 461434, 461139, 284294, 276853, 285990, 285988, 461371, 457865, 337651, 302768, 458801, 460634, 335184, 335182, 293107, 455699, 460191, 346080, 284286, 284284, 276564, 457861, 296484, 284280, 460277, 300420, 284276, 458954, 450532, 459993, 284273, 459353, 300418, 276840, 458951, 300412, 346075, 458415, 456316, 275854, 459024, 458799, 457521, 322672, 275850, 458411, 422018, 294845, 290638, 279563, 294841, 290802, 352261, 458187, 457500, 285984, 458037, 458034, 457378, 457514, 457511, 457493, 451074, 457240, 457375, 286323, 454942, 322670, 456826, 289821, 280802, 456692, 456690, 275833, 456685, 360456, 335177, 394945, 451625, 418102, 286296, 454645, 449388, 290635, 454193, 454073, 454071, 287860, 290794, 290792, 290790, 453256, 384610, 451968, 452537, 451046, 319693, 451040, 452526, 276822, 290526, 290524, 285979, 274702, 451038, 280751, 452381, 451034, 274700, 291143, 289818, 286785, 291141, 276819, 451617, 276817, 287159, 451590, 422796, 451660, 451581, 290786, 290784, 377475, 451608, 422790, 290781, 276073, 286775, 451016, 286773, 325997, 305938, 286285, 449830, 286282, 286280, 449828, 377469, 451011, 312993, 275530, 365936, 365934, 325993, 449824, 290773, 449820, 290771, 350450, 449372, 290767, 377457, 286768, 335173, 413865, 284269, 284267, 290520, 290511, 284264, 290509, 447961, 413857, 292429, 413855, 293068, 292426, 423468, 422429, 274697, 319560, 274695, 341533, 291490, 420089, 291137, 421346, 421344, 315409, 315406, 290506, 336552, 276810, 290495, 391551, 276808, 341529, 291135, 275818, 457857, 418318, 321505, 396254, 419141, 418832, 419139, 418830, 407026, 407024, 291132, 457853, 396252, 339441, 396246, 290761, 383149, 290757, 291129, 418090, 276794, 418088, 288355, 291125, 290631, 417030, 319550, 291123, 417486, 408421, 290755, 291120, 417337, 417364, 417333, 417473, 416963, 276791, 416995, 319542, 416959, 291114, 417018, 414923, 416486, 294838, 290747, 414903, 415900, 415765, 415516, 391440, 284261, 413008, 351241, 375535, 344734, 280701, 375532, 413091, 300372, 412762, 345292, 300366, 411368, 411365, 411361, 410803, 411357, 410799, 411006, 410783, 410130, 396234, 335163, 280688, 396232, 343229, 410119, 335155, 410116, 410114, 343227, 410111, 391435, 410525, 410108, 410331, 280679, 410327, 410325, 410179, 351235, 343224, 343220, 280676, 286735, 290493, 409474, 407811, 406663, 408643, 408911, 408356, 408470, 407808, 408097, 290465, 407016, 314322, 404216, 381354, 397545, 384460, 291112, 400166, 275137, 288913, 397531, 397525, 294833, 292374, 399467, 291105, 291102, 398665, 284253, 284251, 291099, 283845, 285340, 397519, 285338, 285336, 342946, 342944, 396227, 315395, 396744, 396225, 396740, 395329, 294831, 395565, 294829, 294827, 294825, 292372, 395562, 292370, 394680, 394928, 394979, 304782, 304780, 394678, 394924, 315392, 304777, 292366, 307936, 315390, 291093, 274746, 342940, 391997, 391537, 457779, 391420, 384453, 457775, 457770, 314867, 388518, 388516, 388511, 385087, 385084, 274686, 385082, 385711, 276734, 372320, 352146, 275807, 280606, 379449, 385080, 352141, 384792, 291088, 384450, 384601, 384499, 384448, 384446, 291081, 384262, 291077, 382793, 314864, 291917, 322658, 322656, 322654, 352131, 352129, 379612, 315380, 381963, 381289, 276716, 284688, 377343, 378943, 378939, 276710, 276708, 276704, 319532, 276700, 292361, 305058, 292356, 347045, 290217, 292354, 292351, 375525, 314861, 274158, 291071, 375521, 291069, 292344, 291066, 291064, 292337, 292333, 373640, 292328, 314844, 292323, 292321, 292317, 292312, 314842, 344394, 305767, 341517, 275788, 368572, 286696, 305754, 338538, 338536, 321497, 321495, 335146, 364612, 358686, 276691, 273293, 273292, 276681, 360990, 360988, 358823, 358820, 292948, 339437, 274682, 352687, 316346, 358817, 358815, 311519, 276660, 276658, 311516, 311514, 279557, 279555, 357871, 289343, 311507, 314831, 357457, 315279, 341514, 314829, 314827, 337600, 314823, 337598, 337596, 327983, 341511, 276654, 341508, 292276, 284238, 284236, 284234, 284231, 351404, 352106, 352686, 288887, 279553, 352684, 292940, 292938, 292936, 352105, 279550, 352101, 352097, 279548, 352094, 276652, 276650, 351784, 276647, 351402, 276644, 349800, 292933, 292931, 272608))
Run Time: 0.031566
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1492 | |
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 | | | | | 1492 | |
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 (29707, 29427, 29097, 28478, 27330, 27261, 27188, 26694, 26009, 25569, 24575, 24301, 23987, 23183, 22477, 22060, 20875, 20821, 20743, 20229, 20179, 20021, 19924, 19370, 19305, 18709, 17940, 17784, 17781, 17586, 17511))
Run Time: 0.001673
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 31 | 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.000241
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.000321
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.000568
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: 1716144489
Run Time: 0.000396
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 28 | 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` >= 1716144489)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000601
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 28 | 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