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.000640
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.000341
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` = '9738')
LIMIT 1
Run Time: 0.000465
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.002005
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_9738' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.068464
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 (643667, 643664, 637664, 637669, 474329, 637662, 637713, 446880, 637710, 636467, 637470, 534739, 634001, 633998, 446685, 446682, 630189, 596167, 630186, 633887, 633601, 446208, 446206, 596150, 596148, 611452, 633557, 632920, 446171, 596136, 629922, 536405, 629919, 596126, 629859, 629854, 629616, 445385, 445380, 389276, 629395, 629386, 629391, 629380, 536387, 536385, 201140, 534367, 536383, 445285, 445283, 628864, 628606, 445181, 595970, 444921, 626765, 603411, 444837, 534269, 626351, 444696, 611433, 444482, 611416, 444478, 625480, 443293, 615477, 443289, 615464, 443265, 615486, 389272, 533776, 615451, 615376, 615083, 615079, 615052, 615049, 615109, 443089, 613932, 443074, 614867, 442978, 614816, 614811, 614807, 614805, 533746, 614789, 442963, 442955, 592702, 442928, 442922, 442911, 533737, 442847, 442830, 442824, 613889, 613883, 613878, 595858, 533685, 613736, 610608, 613755, 613731, 442676, 442669, 246822, 580285, 533671, 442656, 613679, 442646, 442643, 554433, 442633, 389269, 442627, 595842, 595840, 442604, 572904, 614741, 533645, 442571, 442568, 613401, 613397, 442561, 613394, 442538, 608413, 613354, 608924, 442514, 442511, 533611, 533584, 613280, 613278, 613272, 613077, 442417, 533533, 612985, 611279, 611278, 612917, 499610, 533494, 389256, 612731, 612778, 609801, 533483, 609798, 442149, 442140, 442124, 612674, 442116, 612679, 612667, 533463, 612659, 442096, 442058, 606335, 611380, 442028, 442026, 612087, 533394, 533387, 611994, 611902, 611797, 611607, 533332, 246737, 441775, 441768, 533326, 441763, 533322, 605375, 611534, 605373, 611526, 441735, 533309, 611481, 611320, 533295, 441695, 611315, 441683, 533290, 611120, 611303, 533283, 554430, 533277, 610908, 610905, 441646, 533269, 533265, 611163, 611046, 110749, 611044, 441628, 611042, 533260, 611031, 533257, 611004, 441617, 608194, 441597, 533242, 441586, 610552, 441579, 222472, 222467, 610550, 533236, 441561, 441558, 610945, 441549, 597980, 441538, 610541, 441532, 470917, 441500, 610789, 610865, 610861, 595746, 441487, 600991, 595731, 610729, 610591, 597250, 200973, 200971, 533205, 610594, 610583, 610513, 441423, 610567, 610510, 610563, 610486, 611730, 610379, 441380, 602856, 533158, 599845, 597245, 602853, 610004, 609764, 533141, 610122, 609639, 441350, 609636, 441332, 571132, 610010, 609994, 609742, 609691, 576524, 576520, 576518, 533099, 365013, 609652, 609615, 609444, 609412, 609338, 609328, 608316, 605361, 608314, 609286, 578104, 441277, 609156, 608888, 609150, 533068, 608886, 533061, 441269, 608737, 441265, 608734, 608731, 441256, 623128, 607355, 533048, 606521, 441246, 606519, 441243, 608860, 608728, 595693, 607243, 603479, 603475, 532938, 603471, 603466, 603455, 623102, 532933, 441031, 441029, 607176, 607174, 441004, 554419, 607112, 440989, 532917, 532915, 440976, 606912, 440974, 440752, 605720, 603375, 532757, 603345, 440415, 602154, 602152, 602149, 603217, 603223, 603214, 599308, 495592, 601368, 536363, 603147, 372048, 536361, 603110, 603087, 532735, 603084, 440388, 440386, 593634, 600934, 440365, 602954, 602942, 602946, 599082, 440350, 601851, 600138, 600099, 599995, 440138, 440124, 440116, 440105, 440099, 595534, 440096, 600028, 600025, 440094, 600008, 532615, 599999, 599993, 440091, 597632, 593132, 593130, 593116, 599967, 599947, 599927, 599923, 200893, 532601, 200887, 580170, 439980, 595531, 599190, 599188, 599183, 599163, 599160, 599179, 568992, 439935, 439933, 439914, 439900, 599096, 536358, 596538, 439786, 532561, 598354, 439783, 532557, 532555, 593180, 597135, 439517, 439505, 597035, 597034, 532521, 439502, 439489, 439468, 439460, 554288, 596960, 596915, 596946, 596912, 596943, 596928, 439453, 596897, 596889, 439442, 554285, 532514, 596837, 439419, 532510, 596770, 439404, 596739, 596768, 596721, 614723, 532503, 614720, 420970, 439376, 596461, 596459, 439371, 595358, 596455, 596500, 596446, 596430, 595486, 595406, 595340, 439351, 594630, 532491, 439324, 473636, 595231, 595259, 592102, 595212, 595204, 595089, 366811, 439298, 439289, 532487, 595111, 594442, 133274, 595030, 622936, 594483, 594969, 594949, 594140, 439284, 594919, 536346, 594850, 622930, 594872, 622927, 594774, 594801, 594797, 536340, 532473, 594747, 594814, 594677, 594669, 532467, 594666, 594661, 594593, 622914, 594604, 594585, 594564, 527974, 622912, 527972, 527965, 532459, 527959, 591026, 591022, 591019, 594505, 594502, 622905, 589643, 622903, 589641, 593976, 622898, 439231, 592509, 594475, 314750, 532447, 314740, 592505, 592502, 532445, 594402, 592498, 592494, 622895, 594250, 532443, 622892, 532440, 594319, 594312, 594308, 570886, 594283, 532438, 439199, 594268, 246660, 532430, 594179, 594165, 594138, 594131, 592885, 594128, 532424, 593788, 439149, 593778, 593775, 622887, 110728, 439142, 439125, 593850, 593764, 439087, 593745, 439058, 591883, 593591, 591879, 439054, 593587, 593675, 592877, 592875, 593544, 532414, 369272, 593533, 590725, 592791, 593510, 575318, 575316, 593465, 532408, 593369, 593302, 593310, 593292, 330530, 330524, 593194, 593172, 593167, 532392, 593164, 246659, 589801, 590718, 590715, 200859, 593064, 532373, 622844, 593036, 593007, 589800, 593033, 133254, 592998, 592801, 593017, 590873, 439042, 532363, 439040, 592989, 439038, 592977, 592872, 532358, 200856, 592858, 622839, 592851, 592920, 592848, 592905, 532351, 470914, 592646, 470912, 592642, 592839, 592828, 532343, 592780, 592778, 592684, 592755, 592627, 532328, 438992, 592485, 532323, 592597, 592076, 592482, 438965, 592582, 592554, 536328, 536326, 592410, 592434, 532306, 592430, 592406, 592357, 438950, 438943, 532292, 536322, 536320, 532290, 438937, 438935, 592176, 246652, 591948, 438924, 532287, 592038, 532283, 592015, 532280, 591852, 438897, 591945, 438890, 591940, 591808, 591839, 589793, 438871, 591799, 591836, 591794, 591834, 591792, 622830, 532274, 591654, 527951, 536319, 591628, 622824, 527935, 527926, 527922, 527908, 527900, 532256, 527885, 527873, 591575, 527863, 527856, 532239, 591572, 527850, 527842, 200845, 438849, 532225, 554269, 532214, 532201, 580093, 580091, 532190, 517426, 438764, 438757, 438755, 381034, 591326, 369269, 438742, 438740, 438738, 591291, 532147, 532128, 517406, 349596, 590700, 438684, 554262, 591125, 591117, 438663, 438653, 438642, 438627, 438622, 532090, 554254, 536300, 417910, 414174, 590880, 438611, 481376, 554251, 589911, 532069, 536288, 438540, 622786, 622784, 590526, 589903, 589887, 589871, 438439, 438431, 580068, 580048, 580045, 531998, 580019, 580016, 536280, 536261, 438376, 536258, 438370, 438328, 438325, 590310, 438235, 438231, 579926, 579924, 579910, 622744, 579905, 438143, 531941, 438138, 438104, 438101, 438099, 438038, 438035, 438030, 438001, 437997, 437995, 437991, 531931, 590161, 590175, 246462, 246444, 590097, 590094, 579703, 579698, 589834, 589829, 531845, 588558, 587315, 588556, 527831, 579667, 437747, 110700, 367685, 531827, 579641, 536240, 589524, 536232, 536229, 589510, 589507, 531788, 437470, 437467, 437413, 354510, 246252, 589435, 246246, 246244, 579611, 246242, 531770, 536219, 589415, 589413, 417900, 589281, 417898, 417896, 531762, 531760, 589174, 470898, 470894, 589359, 330510, 573704, 573702, 437259, 588701, 588699, 200774, 554219, 588902, 588450, 570362, 570360, 569361, 314435, 588943, 588941, 588900, 473622, 588420, 588418, 531714, 406461, 406459, 406457, 588406, 588398, 531707, 588396, 588393, 588390, 588384, 588363, 588359, 588355, 588351, 588343, 588337, 588332, 531702, 588316, 356052, 356050, 588306, 588305, 356048, 531697, 588294, 579589, 588870, 622621, 588867, 554207, 554204, 554199, 588850, 554187, 554183, 554181, 588256, 588252, 588664, 588662, 622615, 421215, 531674, 325892, 588220, 588199, 588197, 588193, 309791, 309788, 309784, 588176, 588174, 588167, 588165, 588157, 588154, 588148, 588114, 588111, 588109, 588607, 437196, 397018, 397016, 417895, 588062, 536211, 588045, 536208, 587978, 536205, 531633, 536203, 200768, 587953, 587923, 587880, 246204, 531617, 587787, 587785, 333977, 587782, 587766, 587762, 587758, 587748, 587745, 587740, 587736, 587692, 531606, 531593, 587619, 347338, 587617, 587614, 437030, 437007, 587583, 587571, 587579, 587555, 531566, 586015, 586011, 586009, 536185, 246133, 246131, 246127, 397014, 397011, 531549, 189200, 587425, 246116, 531540, 587377, 531535, 587367, 414163, 554163, 200751, 574411, 587325, 436774, 622564, 531513, 436720, 622546, 436718, 587245, 436707, 587235, 554129, 554126, 587149, 554124, 587109, 554122, 587105, 554120, 587025, 587020, 587009, 586965, 586958, 554118, 586851, 586849, 586944, 586814, 586809, 456142, 554094, 554091, 456140, 586761, 586759, 586704, 554071, 554069, 436540, 436537, 436532, 531421, 622517, 579491, 579487, 586568, 586566, 586564, 531409, 436467, 436424, 586345, 174354, 356035, 586257, 622499, 586250, 585794, 586172, 585785, 622478, 622475, 622470, 586161, 622465, 622461, 586069, 586028, 585757, 585755, 133209, 585637, 622455, 622452, 246038, 436271, 585491, 436265, 246033, 531354, 531352, 585460, 585457, 330498, 585370, 531331, 536146, 585365, 579317, 579314, 536139, 436053, 585105, 585103, 585082, 436014, 585079, 531293, 435989, 372005, 584972, 584968, 584965, 554053, 554046, 554041, 554038, 554036, 554032, 310047, 584641, 584639, 330494, 330489, 584393, 366137, 622402, 584418, 435782, 435780, 435776, 412542, 412539, 412534, 412531, 531209, 622377, 581465, 435516, 412527, 584085, 584081, 584057, 584045, 584041, 531188, 435446, 435443, 581768, 581742, 581736, 412511, 412509, 412506, 581704, 531158, 200637, 356017, 581541, 581712, 581537, 435254, 579128, 579118, 622343, 369240, 369235, 124271, 531138, 124267, 581113, 577812, 577808, 622315, 575645, 578862, 622298, 581046, 578778, 580798, 580793, 580790, 531066, 349589, 578746, 578739, 245747, 245737, 245734, 392204, 355993, 531037, 245726, 235119, 245722, 355987, 245711, 578670, 578637, 578626, 530995, 555284, 578095, 577974, 577959, 577796, 577183, 576936, 234714, 234628, 576932, 576928, 481370, 481368, 536094, 234615, 234609, 576624, 622118, 576622, 481364, 481361, 245479, 576531, 576529, 622106, 576527, 576497, 221169, 576491, 576495, 530744, 576487, 576478, 234538, 412404, 576358, 568183, 574450, 576212, 414134, 200454, 530702, 573279, 573277, 355962, 245396, 245381, 530689, 530685, 576098, 245323, 245320, 576051, 245282, 245280, 622076, 572624, 530668, 575811, 573463, 536086, 536084, 575743, 386033, 386031, 575809, 386029, 575779, 434119, 530658, 574248, 386027, 434099, 572222, 434080, 369213, 369211, 622046, 369209, 575533, 575601, 575554, 575531, 377201, 575528, 575510, 575507, 575503, 575465, 575460, 622031, 622026, 622019, 386022, 330467, 463706, 530600, 575369, 575334, 371933, 622014, 553934, 553928, 553924, 574510, 622012, 553922, 574506, 622008, 575251, 622006, 575229, 221053, 355958, 386016, 575175, 386014, 575155, 575153, 621989, 575082, 234317, 23516, 574879, 536069, 368403, 110615, 110613, 574800, 574809, 245127, 377193, 245124, 574798, 574796, 433852, 574794, 433850, 433842, 433834, 433829, 433826, 433824, 530480, 433818, 574758, 574788, 574786, 574754, 536064, 536062, 369197, 574749, 574544, 574733, 574729, 574724, 433777, 433775, 554934, 371923, 200395, 553894, 621946, 570832, 530459, 574538, 621944, 574213, 574489, 574210, 536059, 234228, 234209, 574395, 574474, 574462, 536056, 414128, 574467, 574189, 414126, 414120, 414116, 381198, 414114, 572031, 386006, 530424, 574226, 553875, 574257, 574173, 433666, 574171, 573911, 412382, 433661, 200381, 573907, 574067, 200379, 574079, 574077, 621918, 574044, 572698, 536045, 574036, 573899, 573897, 572696, 573894, 572694, 573824, 463004, 573458, 573541, 553790, 573831, 133168, 573455, 133165, 604018, 573782, 573779, 549989, 573745, 355954, 573739, 355952, 604015, 604003, 573371, 530306, 573446, 481769, 371909, 573440, 412375, 621908, 572778, 573435, 572776, 621906, 573431, 536036, 621904, 549706, 573368, 378146, 549702, 355950, 536030, 621889, 572215, 549695, 549693, 549691, 549686, 570986, 571501, 572198, 570975, 572391, 571970, 572389, 572384, 572255, 380935, 469405, 380933, 572194, 572190, 572118, 621818, 571868, 571865, 571863, 571859, 621815, 549681, 389235, 549679, 621810, 572082, 133149, 571833, 571830, 380932, 571827, 349555, 380930, 349551, 349548, 349546, 571776, 621805, 355947, 621803, 330448, 571724, 571720, 571665, 621783, 621781, 621778, 220897, 621772, 474193, 474191, 570539, 355941, 355926, 349211))
Run Time: 0.083378
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1537 | |
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 | | | | | 1537 | |
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 (34743, 34263, 33290, 33069, 33026, 32996, 32906, 32901, 32064, 31780, 31776, 31772, 31675, 31406, 31278, 31224, 31145, 31123, 31055, 31034, 31959, 30952, 30887, 30492, 30250, 30249, 30186, 30132, 30079, 30072, 30043, 30014, 29939))
Run Time: 0.002475
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 33 | 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 (643667, 643664, 637664, 637669, 474329, 637662, 637713, 446880, 637710, 636467, 637470, 534739, 634001, 633998, 446685, 446682, 630189, 596167, 630186, 633887, 633601, 446208, 446206, 596150, 596148, 611452, 633557, 632920, 446171, 596136, 629922, 536405, 629919, 596126, 629859, 629854, 629616, 445385, 445380, 389276, 629395, 629386, 629391, 629380, 536387, 536385, 201140, 534367, 536383, 445285, 445283, 628864, 628606, 445181, 595970, 444921, 626765, 603411, 444837, 534269, 626351, 444696, 611433, 444482, 611416, 444478, 625480, 443293, 615477, 443289, 615464, 443265, 615486, 389272, 533776, 615451, 615376, 615083, 615079, 615052, 615049, 615109, 443089, 613932, 443074, 614867, 442978, 614816, 614811, 614807, 614805, 533746, 614789, 442963, 442955, 592702, 442928, 442922, 442911, 533737, 442847, 442830, 442824, 613889, 613883, 613878, 595858, 533685, 613736, 610608, 613755, 613731, 442676, 442669, 246822, 580285, 533671, 442656, 613679, 442646, 442643, 554433, 442633, 389269, 442627, 595842, 595840, 442604, 572904, 614741, 533645, 442571, 442568, 613401, 613397, 442561, 613394, 442538, 608413, 613354, 608924, 442514, 442511, 533611, 533584, 613280, 613278, 613272, 613077, 442417, 533533, 612985, 611279, 611278, 612917, 499610, 533494, 389256, 612731, 612778, 609801, 533483, 609798, 442149, 442140, 442124, 612674, 442116, 612679, 612667, 533463, 612659, 442096, 442058, 606335, 611380, 442028, 442026, 612087, 533394, 533387, 611994, 611902, 611797, 611607, 533332, 246737, 441775, 441768, 533326, 441763, 533322, 605375, 611534, 605373, 611526, 441735, 533309, 611481, 611320, 533295, 441695, 611315, 441683, 533290, 611120, 611303, 533283, 554430, 533277, 610908, 610905, 441646, 533269, 533265, 611163, 611046, 110749, 611044, 441628, 611042, 533260, 611031, 533257, 611004, 441617, 608194, 441597, 533242, 441586, 610552, 441579, 222472, 222467, 610550, 533236, 441561, 441558, 610945, 441549, 597980, 441538, 610541, 441532, 470917, 441500, 610789, 610865, 610861, 595746, 441487, 600991, 595731, 610729, 610591, 597250, 200973, 200971, 533205, 610594, 610583, 610513, 441423, 610567, 610510, 610563, 610486, 611730, 610379, 441380, 602856, 533158, 599845, 597245, 602853, 610004, 609764, 533141, 610122, 609639, 441350, 609636, 441332, 571132, 610010, 609994, 609742, 609691, 576524, 576520, 576518, 533099, 365013, 609652, 609615, 609444, 609412, 609338, 609328, 608316, 605361, 608314, 609286, 578104, 441277, 609156, 608888, 609150, 533068, 608886, 533061, 441269, 608737, 441265, 608734, 608731, 441256, 623128, 607355, 533048, 606521, 441246, 606519, 441243, 608860, 608728, 595693, 607243, 603479, 603475, 532938, 603471, 603466, 603455, 623102, 532933, 441031, 441029, 607176, 607174, 441004, 554419, 607112, 440989, 532917, 532915, 440976, 606912, 440974, 440752, 605720, 603375, 532757, 603345, 440415, 602154, 602152, 602149, 603217, 603223, 603214, 599308, 495592, 601368, 536363, 603147, 372048, 536361, 603110, 603087, 532735, 603084, 440388, 440386, 593634, 600934, 440365, 602954, 602942, 602946, 599082, 440350, 601851, 600138, 600099, 599995, 440138, 440124, 440116, 440105, 440099, 595534, 440096, 600028, 600025, 440094, 600008, 532615, 599999, 599993, 440091, 597632, 593132, 593130, 593116, 599967, 599947, 599927, 599923, 200893, 532601, 200887, 580170, 439980, 595531, 599190, 599188, 599183, 599163, 599160, 599179, 568992, 439935, 439933, 439914, 439900, 599096, 536358, 596538, 439786, 532561, 598354, 439783, 532557, 532555, 593180, 597135, 439517, 439505, 597035, 597034, 532521, 439502, 439489, 439468, 439460, 554288, 596960, 596915, 596946, 596912, 596943, 596928, 439453, 596897, 596889, 439442, 554285, 532514, 596837, 439419, 532510, 596770, 439404, 596739, 596768, 596721, 614723, 532503, 614720, 420970, 439376, 596461, 596459, 439371, 595358, 596455, 596500, 596446, 596430, 595486, 595406, 595340, 439351, 594630, 532491, 439324, 473636, 595231, 595259, 592102, 595212, 595204, 595089, 366811, 439298, 439289, 532487, 595111, 594442, 133274, 595030, 622936, 594483, 594969, 594949, 594140, 439284, 594919, 536346, 594850, 622930, 594872, 622927, 594774, 594801, 594797, 536340, 532473, 594747, 594814, 594677, 594669, 532467, 594666, 594661, 594593, 622914, 594604, 594585, 594564, 527974, 622912, 527972, 527965, 532459, 527959, 591026, 591022, 591019, 594505, 594502, 622905, 589643, 622903, 589641, 593976, 622898, 439231, 592509, 594475, 314750, 532447, 314740, 592505, 592502, 532445, 594402, 592498, 592494, 622895, 594250, 532443, 622892, 532440, 594319, 594312, 594308, 570886, 594283, 532438, 439199, 594268, 246660, 532430, 594179, 594165, 594138, 594131, 592885, 594128, 532424, 593788, 439149, 593778, 593775, 622887, 110728, 439142, 439125, 593850, 593764, 439087, 593745, 439058, 591883, 593591, 591879, 439054, 593587, 593675, 592877, 592875, 593544, 532414, 369272, 593533, 590725, 592791, 593510, 575318, 575316, 593465, 532408, 593369, 593302, 593310, 593292, 330530, 330524, 593194, 593172, 593167, 532392, 593164, 246659, 589801, 590718, 590715, 200859, 593064, 532373, 622844, 593036, 593007, 589800, 593033, 133254, 592998, 592801, 593017, 590873, 439042, 532363, 439040, 592989, 439038, 592977, 592872, 532358, 200856, 592858, 622839, 592851, 592920, 592848, 592905, 532351, 470914, 592646, 470912, 592642, 592839, 592828, 532343, 592780, 592778, 592684, 592755, 592627, 532328, 438992, 592485, 532323, 592597, 592076, 592482, 438965, 592582, 592554, 536328, 536326, 592410, 592434, 532306, 592430, 592406, 592357, 438950, 438943, 532292, 536322, 536320, 532290, 438937, 438935, 592176, 246652, 591948, 438924, 532287, 592038, 532283, 592015, 532280, 591852, 438897, 591945, 438890, 591940, 591808, 591839, 589793, 438871, 591799, 591836, 591794, 591834, 591792, 622830, 532274, 591654, 527951, 536319, 591628, 622824, 527935, 527926, 527922, 527908, 527900, 532256, 527885, 527873, 591575, 527863, 527856, 532239, 591572, 527850, 527842, 200845, 438849, 532225, 554269, 532214, 532201, 580093, 580091, 532190, 517426, 438764, 438757, 438755, 381034, 591326, 369269, 438742, 438740, 438738, 591291, 532147, 532128, 517406, 349596, 590700, 438684, 554262, 591125, 591117, 438663, 438653, 438642, 438627, 438622, 532090, 554254, 536300, 417910, 414174, 590880, 438611, 481376, 554251, 589911, 532069, 536288, 438540, 622786, 622784, 590526, 589903, 589887, 589871, 438439, 438431, 580068, 580048, 580045, 531998, 580019, 580016, 536280, 536261, 438376, 536258, 438370, 438328, 438325, 590310, 438235, 438231, 579926, 579924, 579910, 622744, 579905, 438143, 531941, 438138, 438104, 438101, 438099, 438038, 438035, 438030, 438001, 437997, 437995, 437991, 531931, 590161, 590175, 246462, 246444, 590097, 590094, 579703, 579698, 589834, 589829, 531845, 588558, 587315, 588556, 527831, 579667, 437747, 110700, 367685, 531827, 579641, 536240, 589524, 536232, 536229, 589510, 589507, 531788, 437470, 437467, 437413, 354510, 246252, 589435, 246246, 246244, 579611, 246242, 531770, 536219, 589415, 589413, 417900, 589281, 417898, 417896, 531762, 531760, 589174, 470898, 470894, 589359, 330510, 573704, 573702, 437259, 588701, 588699, 200774, 554219, 588902, 588450, 570362, 570360, 569361, 314435, 588943, 588941, 588900, 473622, 588420, 588418, 531714, 406461, 406459, 406457, 588406, 588398, 531707, 588396, 588393, 588390, 588384, 588363, 588359, 588355, 588351, 588343, 588337, 588332, 531702, 588316, 356052, 356050, 588306, 588305, 356048, 531697, 588294, 579589, 588870, 622621, 588867, 554207, 554204, 554199, 588850, 554187, 554183, 554181, 588256, 588252, 588664, 588662, 622615, 421215, 531674, 325892, 588220, 588199, 588197, 588193, 309791, 309788, 309784, 588176, 588174, 588167, 588165, 588157, 588154, 588148, 588114, 588111, 588109, 588607, 437196, 397018, 397016, 417895, 588062, 536211, 588045, 536208, 587978, 536205, 531633, 536203, 200768, 587953, 587923, 587880, 246204, 531617, 587787, 587785, 333977, 587782, 587766, 587762, 587758, 587748, 587745, 587740, 587736, 587692, 531606, 531593, 587619, 347338, 587617, 587614, 437030, 437007, 587583, 587571, 587579, 587555, 531566, 586015, 586011, 586009, 536185, 246133, 246131, 246127, 397014, 397011, 531549, 189200, 587425, 246116, 531540, 587377, 531535, 587367, 414163, 554163, 200751, 574411, 587325, 436774, 622564, 531513, 436720, 622546, 436718, 587245, 436707, 587235, 554129, 554126, 587149, 554124, 587109, 554122, 587105, 554120, 587025, 587020, 587009, 586965, 586958, 554118, 586851, 586849, 586944, 586814, 586809, 456142, 554094, 554091, 456140, 586761, 586759, 586704, 554071, 554069, 436540, 436537, 436532, 531421, 622517, 579491, 579487, 586568, 586566, 586564, 531409, 436467, 436424, 586345, 174354, 356035, 586257, 622499, 586250, 585794, 586172, 585785, 622478, 622475, 622470, 586161, 622465, 622461, 586069, 586028, 585757, 585755, 133209, 585637, 622455, 622452, 246038, 436271, 585491, 436265, 246033, 531354, 531352, 585460, 585457, 330498, 585370, 531331, 536146, 585365, 579317, 579314, 536139, 436053, 585105, 585103, 585082, 436014, 585079, 531293, 435989, 372005, 584972, 584968, 584965, 554053, 554046, 554041, 554038, 554036, 554032, 310047, 584641, 584639, 330494, 330489, 584393, 366137, 622402, 584418, 435782, 435780, 435776, 412542, 412539, 412534, 412531, 531209, 622377, 581465, 435516, 412527, 584085, 584081, 584057, 584045, 584041, 531188, 435446, 435443, 581768, 581742, 581736, 412511, 412509, 412506, 581704, 531158, 200637, 356017, 581541, 581712, 581537, 435254, 579128, 579118, 622343, 369240, 369235, 124271, 531138, 124267, 581113, 577812, 577808, 622315, 575645, 578862, 622298, 581046, 578778, 580798, 580793, 580790, 531066, 349589, 578746, 578739, 245747, 245737, 245734, 392204, 355993, 531037, 245726, 235119, 245722, 355987, 245711, 578670, 578637, 578626, 530995, 555284, 578095, 577974, 577959, 577796, 577183, 576936, 234714, 234628, 576932, 576928, 481370, 481368, 536094, 234615, 234609, 576624, 622118, 576622, 481364, 481361, 245479, 576531, 576529, 622106, 576527, 576497, 221169, 576491, 576495, 530744, 576487, 576478, 234538, 412404, 576358, 568183, 574450, 576212, 414134, 200454, 530702, 573279, 573277, 355962, 245396, 245381, 530689, 530685, 576098, 245323, 245320, 576051, 245282, 245280, 622076, 572624, 530668, 575811, 573463, 536086, 536084, 575743, 386033, 386031, 575809, 386029, 575779, 434119, 530658, 574248, 386027, 434099, 572222, 434080, 369213, 369211, 622046, 369209, 575533, 575601, 575554, 575531, 377201, 575528, 575510, 575507, 575503, 575465, 575460, 622031, 622026, 622019, 386022, 330467, 463706, 530600, 575369, 575334, 371933, 622014, 553934, 553928, 553924, 574510, 622012, 553922, 574506, 622008, 575251, 622006, 575229, 221053, 355958, 386016, 575175, 386014, 575155, 575153, 621989, 575082, 234317, 23516, 574879, 536069, 368403, 110615, 110613, 574800, 574809, 245127, 377193, 245124, 574798, 574796, 433852, 574794, 433850, 433842, 433834, 433829, 433826, 433824, 530480, 433818, 574758, 574788, 574786, 574754, 536064, 536062, 369197, 574749, 574544, 574733, 574729, 574724, 433777, 433775, 554934, 371923, 200395, 553894, 621946, 570832, 530459, 574538, 621944, 574213, 574489, 574210, 536059, 234228, 234209, 574395, 574474, 574462, 536056, 414128, 574467, 574189, 414126, 414120, 414116, 381198, 414114, 572031, 386006, 530424, 574226, 553875, 574257, 574173, 433666, 574171, 573911, 412382, 433661, 200381, 573907, 574067, 200379, 574079, 574077, 621918, 574044, 572698, 536045, 574036, 573899, 573897, 572696, 573894, 572694, 573824, 463004, 573458, 573541, 553790, 573831, 133168, 573455, 133165, 604018, 573782, 573779, 549989, 573745, 355954, 573739, 355952, 604015, 604003, 573371, 530306, 573446, 481769, 371909, 573440, 412375, 621908, 572778, 573435, 572776, 621906, 573431, 536036, 621904, 549706, 573368, 378146, 549702, 355950, 536030, 621889, 572215, 549695, 549693, 549691, 549686, 570986, 571501, 572198, 570975, 572391, 571970, 572389, 572384, 572255, 380935, 469405, 380933, 572194, 572190, 572118, 621818, 571868, 571865, 571863, 571859, 621815, 549681, 389235, 549679, 621810, 572082, 133149, 571833, 571830, 380932, 571827, 349555, 380930, 349551, 349548, 349546, 571776, 621805, 355947, 621803, 330448, 571724, 571720, 571665, 621783, 621781, 621778, 220897, 621772, 474193, 474191, 570539, 355941, 355926, 349211))
Run Time: 0.031133
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1537 | |
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 | | | | | 1537 | |
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 (34743, 34263, 33290, 33069, 33026, 32996, 32906, 32901, 32064, 31780, 31776, 31772, 31675, 31406, 31278, 31224, 31145, 31123, 31055, 31034, 31959, 30952, 30887, 30492, 30250, 30249, 30186, 30132, 30079, 30072, 30043, 30014, 29939))
Run Time: 0.001389
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 33 | 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, �U�
Run Time: 0.000156
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.000385
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.000444
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: 1716192736
Run Time: 0.000330
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 30 | 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` >= 1716192736)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000578
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 30 | 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