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.000817
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.000268
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` = '4167')
LIMIT 1
Run Time: 0.000489
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.001901
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_4167' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.239675
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 (643447, 642494, 447561, 638541, 637771, 638413, 638286, 637913, 637911, 637908, 637906, 500388, 637766, 637760, 500384, 500382, 637707, 637695, 446793, 637271, 636141, 580664, 446766, 446751, 446749, 247259, 446747, 247257, 637031, 636955, 636982, 636979, 636951, 636949, 446593, 446589, 247224, 247208, 247206, 635914, 635562, 604203, 635558, 446434, 634398, 634396, 634392, 634387, 634359, 634283, 446290, 634298, 446283, 446280, 634279, 634278, 634273, 446271, 446240, 634061, 633715, 633711, 593665, 633664, 446214, 593659, 593654, 632048, 632046, 536406, 446162, 446160, 633318, 633270, 633183, 608494, 608489, 633080, 633234, 632766, 632995, 632247, 632993, 608478, 632981, 446052, 632896, 632760, 632762, 632747, 445986, 631632, 625683, 632698, 445970, 632683, 632675, 632610, 445957, 632588, 445955, 632498, 632544, 632529, 632463, 632459, 632517, 632452, 445949, 632449, 632486, 629897, 632413, 632318, 445938, 632122, 632178, 580585, 580583, 632074, 599855, 632002, 632029, 631952, 445876, 631949, 631948, 631946, 631968, 631936, 631934, 631866, 631863, 453803, 631528, 631515, 631508, 580579, 580576, 631502, 631727, 631709, 631702, 445792, 445782, 631467, 631450, 631447, 631690, 631688, 580569, 631333, 445752, 445751, 631330, 627103, 631335, 631311, 445695, 631304, 445684, 596082, 445671, 627920, 605411, 631265, 631194, 392477, 631227, 580542, 392474, 631099, 331425, 331411, 247093, 445640, 606764, 445619, 631006, 630946, 630956, 460477, 247090, 630939, 630389, 630919, 445579, 607440, 630858, 630862, 445564, 630811, 613656, 630809, 607432, 630693, 630687, 445545, 630643, 629885, 445542, 630659, 445539, 630314, 445536, 630605, 445531, 630598, 445529, 445519, 605404, 458304, 596073, 630554, 630510, 445513, 630447, 630332, 630445, 630386, 624172, 630415, 630384, 630377, 630373, 630348, 630369, 630350, 630337, 445507, 596063, 445468, 630151, 445466, 593474, 445464, 630141, 630139, 247077, 630055, 629840, 630037, 630014, 629825, 247062, 629756, 629777, 629698, 629692, 629687, 445430, 613446, 629668, 608971, 629497, 445395, 445388, 629495, 613438, 613435, 629611, 613433, 445370, 629553, 580518, 629522, 629485, 629473, 629469, 453784, 629379, 629400, 629377, 629345, 629319, 624148, 445317, 629247, 536380, 629203, 629182, 629199, 629170, 629178, 247023, 580490, 629036, 628344, 629076, 462507, 247015, 629032, 629045, 625843, 628980, 386089, 628956, 628968, 628950, 616330, 628853, 628907, 628874, 445293, 628581, 606392, 445291, 628567, 628858, 609384, 628546, 609382, 628777, 628801, 628807, 628756, 628752, 628716, 628708, 628700, 628661, 628530, 628527, 628525, 628511, 609378, 445260, 628492, 628487, 628472, 628468, 628386, 628384, 628232, 627527, 628409, 628399, 628396, 606389, 606387, 247001, 246999, 628365, 246997, 445228, 628340, 445226, 445223, 628370, 601327, 628368, 601326, 445209, 445207, 598849, 445201, 628337, 628230, 628335, 628228, 445185, 628296, 628290, 628223, 628220, 628216, 445169, 628213, 628208, 445161, 445152, 628179, 627510, 628173, 628148, 628137, 628113, 628141, 628111, 628121, 628119, 628115, 628104, 628094, 628090, 628084, 628080, 445138, 627977, 627973, 627958, 627496, 627956, 627945, 627964, 627899, 627896, 356094, 627894, 627933, 627494, 627822, 356089, 627930, 627818, 445131, 627810, 627826, 627843, 574739, 627797, 627792, 627311, 627491, 627787, 627486, 627484, 627479, 627777, 627476, 627535, 627774, 627780, 627473, 627772, 627762, 627770, 627716, 627719, 627723, 627592, 627645, 605670, 627435, 445015, 609065, 604416, 614755, 627348, 627058, 627324, 626998, 627309, 444995, 444990, 627208, 580446, 627064, 627172, 627171, 627084, 444961, 444959, 627025, 444957, 595972, 626962, 626948, 626852, 626881, 608211, 444901, 444893, 626774, 626735, 564958, 626682, 626653, 614857, 626575, 626506, 626567, 626465, 626462, 626418, 626453, 626448, 625171, 626408, 444854, 626392, 626371, 534272, 444839, 626361, 444831, 626357, 444822, 444820, 391995, 626342, 444814, 444808, 109256, 607391, 444797, 607387, 444792, 444789, 444781, 444772, 444764, 626315, 444761, 444759, 444754, 444752, 610264, 626207, 626206, 547946, 626189, 626186, 391985, 626181, 391982, 626177, 626175, 626125, 626167, 626165, 626170, 626163, 626118, 626109, 626116, 22840, 444725, 22837, 626087, 626049, 626078, 626073, 626016, 626027, 626012, 626025, 626009, 625948, 444717, 625973, 625910, 444715, 625991, 444697, 625964, 444680, 625903, 625901, 625899, 444674, 625868, 625830, 625879, 625856, 625864, 625871, 444651, 444645, 625849, 625847, 625826, 444629, 625823, 625806, 625784, 625782, 625778, 625596, 444609, 444599, 572542, 625749, 572540, 625729, 625738, 572535, 444543, 444528, 580428, 444515, 453759, 444513, 625696, 625674, 444497, 444493, 625618, 625648, 625653, 625612, 625544, 444459, 625534, 444447, 625505, 625513, 444436, 625334, 625332, 625479, 580400, 625474, 444434, 444431, 602052, 625453, 625460, 625329, 607379, 625447, 595939, 625435, 625404, 595936, 444406, 625378, 625368, 625358, 625355, 444390, 444382, 557028, 625323, 610246, 444379, 625280, 625283, 625288, 444368, 625278, 444362, 610242, 625263, 625257, 444355, 444351, 625227, 482295, 444336, 625225, 625244, 625250, 625242, 625222, 625205, 580378, 580370, 625184, 610239, 625136, 625176, 624185, 625148, 625153, 607231, 623978, 444286, 444276, 625105, 625113, 625092, 624401, 624389, 624369, 624380, 624374, 444206, 444201, 444190, 605663, 444175, 624334, 608467, 624300, 608464, 534071, 534069, 608454, 608450, 624268, 624276, 624264, 444132, 444131, 605654, 624201, 624196, 624107, 624029, 623969, 623967, 623965, 624023, 599329, 624004, 623959, 616325, 614258, 623902, 444054, 623895, 444033, 444024, 444015, 444012, 444007, 623823, 623819, 595926, 444005, 601068, 595915, 595906, 624097, 615001, 614999, 623793, 443966, 443963, 443961, 443947, 606376, 443915, 607908, 443911, 443908, 595900, 623768, 443903, 616159, 623744, 616080, 623697, 623680, 443863, 443856, 615716, 615969, 615967, 615965, 623653, 615963, 623651, 623660, 615960, 443791, 623463, 615955, 614255, 615948, 615946, 580824, 623515, 443764, 443759, 443744, 623390, 608445, 623394, 608442, 624075, 623382, 623379, 604200, 623377, 443732, 616323, 443727, 616321, 616316, 623340, 616350, 616346, 616310, 616342, 616308, 616289, 613537, 443721, 443714, 616222, 616238, 613090, 443688, 336719, 443669, 616192, 614251, 616171, 180982, 443655, 614246, 616077, 614243, 616100, 615905, 443639, 614240, 616072, 616070, 616068, 443621, 614238, 443613, 614236, 614233, 443609, 616062, 614229, 614227, 615821, 616055, 611395, 611393, 611392, 613534, 614225, 443607, 616013, 614217, 616003, 615981, 615891, 615921, 615886, 615884, 614213, 614207, 614205, 614203, 614198, 595876, 614196, 614194, 614192, 614188, 614185, 443554, 246910, 443508, 201033, 607888, 609374, 615847, 614176, 607313, 389721, 615598, 615835, 615775, 615799, 443463, 533829, 595870, 443459, 615750, 615679, 615676, 443418, 615722, 612278, 615672, 614175, 614173, 614171, 614168, 615662, 614165, 614161, 614159, 246881, 614157, 443389, 615624, 349963, 615607, 443347, 614153, 615591, 349956, 615584, 614150, 614148, 614146, 614144, 615582, 614142, 615578, 614140, 478947, 614130, 614128, 614126, 614124, 612844, 614121, 614119, 614117, 614115, 443330, 443318, 443305, 443296, 443285, 443271, 288, 4718, 613613, 613612, 443268, 443261, 443259, 443257, 615515, 506485, 506483, 4712, 4710, 610224, 614853, 34271, 615510, 615497, 615492, 613532, 615483, 613530, 443218, 615362, 443215, 615356, 615353, 614981, 615095, 605642, 615035, 615030, 443149, 443146, 443133, 605631, 615021, 443123, 614989, 607850, 614978, 614937, 443069, 443067, 443061, 443059, 443042, 610213, 610210, 614902, 443023, 443020, 580320, 443018, 443014, 442986, 614877, 614841, 614835, 442969, 457961, 606371, 614791, 442958, 442952, 442947, 442944, 614771, 614768, 593652, 593650, 614745, 613525, 442878, 442837, 442834, 614288, 608943, 613805, 614267, 614103, 614264, 614100, 180969, 614093, 614091, 614088, 614086, 614083, 614077, 614073, 614065, 614044, 442758, 442755, 442730, 442724, 442713, 442707, 607842, 614001, 613896, 613887, 613884, 613881, 613991, 613957, 613961, 613861, 612497, 612495, 613516, 613696, 613514, 442692, 246825, 613802, 613739, 613800, 613797, 613795, 613791, 613759, 613762, 612628, 613729, 610606, 610604, 608936, 554444, 554442, 442658, 580286, 554437, 554435, 612108, 610197, 595852, 613673, 412566, 595848, 442625, 613510, 442620, 613508, 595845, 613506, 613499, 601018, 613552, 593751, 442581, 613406, 604707, 613388, 442551, 442548, 442546, 608423, 608420, 608415, 442536, 613378, 442528, 613363, 606352, 580249, 612838, 612836, 592144, 613311, 613293, 442493, 613217, 442478, 613238, 442458, 613192, 442453, 246802, 613104, 613102, 613073, 613121, 613055, 609112, 612990, 442422, 612980, 602027, 602025, 613042, 613035, 613033, 613030, 442345, 442343, 612948, 580234, 612945, 442310, 612480, 442308, 442306, 533514, 612476, 612472, 612464, 612463, 442270, 442263, 442224, 442222, 442221, 612682, 442183, 612809, 612801, 612752, 392470, 612795, 612825, 612718, 612749, 612769, 612721, 632787, 609370, 612626, 612622, 612631, 612658, 608920, 608917, 598574, 608915, 612611, 612609, 608913, 611386, 442072, 608171, 611381, 612274, 612543, 612536, 612512, 442043, 612510, 442038, 609356, 609521, 609517, 609514, 604197, 612501, 604195, 442005, 612486, 442000, 609728, 608586, 595819, 612429, 609353, 609350, 605391, 612234, 441980, 608901, 441977, 612223, 200994, 605384, 612216, 612214, 612107, 612151, 612147, 612104, 612097, 612094, 612091, 612083, 612062, 612081, 612059, 612031, 611995, 612016, 611989, 610103, 441888, 441883, 606999, 606997, 611912, 610912, 441852, 611847, 611827, 611824, 611795, 611820, 611768, 611665, 611663, 441803, 611673, 611632, 611611, 611629, 611626, 207580, 611606, 441789, 611583, 611570, 611207, 611532, 605371, 593269, 611558, 611524, 441710, 611313, 611305, 441689, 441687, 441677, 611239, 611221, 441650, 611165, 611062, 611058, 611054, 611109, 611107, 609345, 611016, 611011, 611005, 608628, 583017, 602183, 610975, 608192, 608190, 602180, 608187, 608184, 610992, 610974, 610986, 595765, 610984, 610981, 610979, 610963, 222464, 610948, 610921, 441542, 472710, 610844, 610841, 610837, 441499, 441494, 595753, 610739, 610880, 533226, 610781, 578257, 610852, 453747, 597362, 597359, 597347, 610775, 578253, 578251, 610823, 610819, 603999, 610738, 610736, 441476, 441471, 578245, 533213, 533210, 449868, 610716, 441466, 441461, 603525, 441458, 610595, 610572, 441433, 610507, 441406, 610505, 610428, 610502, 610491, 610483, 609105, 610395, 610392, 610384, 610381, 610373, 595719, 610367, 599844, 602852, 608560, 608550, 611703, 610185, 611701, 441373, 610161, 441366, 441363, 110741, 609644, 110739, 610157, 609768, 610155, 609641, 610148, 606250, 610138, 610134, 200969, 609635, 609632, 609099, 610067, 441344, 373130, 610054, 533121, 533118, 441338, 609630, 610029, 133350, 610040, 609623, 610017, 571133, 441331, 441329, 571131, 571129, 609970, 609983, 610007, 571126, 609980, 441325, 609975, 609972, 441322, 533109, 609733, 609216, 609711, 609546, 609544, 609542, 609540, 609538, 609705, 609703, 609698, 609692, 609676, 609673, 609536, 596597, 609649, 533100, 596593, 596591, 609605, 609482, 609614, 609602, 609599, 609568, 609565, 609563, 609561, 609559, 609592, 609557, 596588, 609551, 609461, 609532, 51333, 51328, 609459, 609480, 609455, 609446, 533086, 609442, 609439, 609433, 609410, 609342, 609340, 609336, 609404, 526635, 441300, 133346, 441298, 441290, 608317, 533076, 608313, 609289, 605359, 609278, 609276, 609283, 595708, 607582, 609259, 608408, 609257, 608405, 608403, 608401, 608399, 609057, 609055, 607580, 608892, 608890, 609154, 593643, 609046, 609044, 133344, 609041, 133342, 133340, 133338, 609145, 133335, 133329, 608881, 590070, 608865, 533049, 608862, 608877, 609127, 607356, 590068, 590065, 593919, 609033, 593917, 609030, 609027, 595702, 609003, 608963, 608662, 608969, 608951, 608875, 608967, 608949, 608659, 608975, 584745, 608830, 608871, 608852, 608849, 608845, 608819, 608802, 608655, 608790, 608783, 595691, 595687, 607066, 608780, 608774, 607349, 608772, 608596, 608777, 623125, 417913, 608763, 608726, 608700, 607962, 608668, 608583, 608653, 608683, 604361, 608593, 533034, 608580, 603940, 603937, 603935, 608389, 608573, 608569, 608532, 608372, 608530, 331395, 608365, 607298, 605818, 607296, 453740, 607831, 441227, 608353, 441222, 441219, 441216, 441211, 608326, 441208, 602010, 608323, 441202, 441196, 600803, 608310, 592123, 200958, 607829, 536375, 608238, 608233, 608134, 608131, 608129, 608126, 608123, 608120, 608116, 608217, 608181, 608175, 608158, 608114, 608155, 590064, 605815, 608139, 607740, 608099, 608097, 608095, 607734, 608050, 607822, 607730, 441156, 456308, 607980, 608027, 441150, 608024, 608022, 133322, 607803, 606053, 441146, 554423, 607776, 607978, 607765, 133318, 607975, 607973, 607965, 607774, 607763, 607795, 607792, 607787, 441137, 607778, 607758, 607754, 605734, 607704, 607714, 412560, 554421, 607662, 607648, 607650, 607626, 607622, 605356, 607572, 607544, 615525, 607562, 607558, 607150, 605351, 607506, 441102, 607340, 607325, 512009, 499502, 592208, 607245, 603462, 606760, 607194, 441021, 597421, 441019, 607108, 607157, 471347, 607103, 607148, 200944, 200942, 200940, 471339, 607048, 607042, 604177, 606978, 604172, 606926, 440984, 440983, 606934, 606918, 595668, 606897, 595665, 606879, 606868, 597417, 595656, 606861, 440967, 606830, 595645, 440954, 606316, 602739, 440951, 440949, 440947, 606813, 600709, 606793, 606780, 440945, 600706, 600705, 600700, 600698, 606750, 606741, 623091, 469426, 440935, 440933, 554410, 440929, 554408, 606669, 606696, 606681, 606684, 440925, 440923, 606657, 606656, 606652, 606642, 440915, 440910, 606628, 414214, 440905, 440900, 440896, 606568, 440890, 606565, 440887, 606571, 606562, 440884, 606527, 606506, 606313, 606502, 606546, 606310, 606307, 606551, 606543, 606540, 606237, 414208, 606489, 595627, 606194, 440877, 606306, 606304, 606299, 606433, 554404, 606448, 606444, 532888, 606428, 606417, 440858, 606272, 606289, 606295, 606293, 606261, 554400, 554398, 595621, 595619, 595617, 595615, 554396, 606259, 606257, 606266, 606233, 606192, 606254, 606230, 440855, 440848, 606227, 606190, 595606, 595603, 595601, 606188, 606222, 606185, 331390, 331388, 331381, 331380, 331377, 200934, 580220, 606181, 605814, 602037, 605812, 133311, 606131, 606120, 606117, 200932, 606110, 200930, 606083, 597230, 597227, 606070, 606075, 606068, 605996, 606035, 605956, 605954, 605999, 246699, 605991, 440832, 605981, 595595, 246695, 246693, 246690, 605446, 600044, 246686, 605974, 605970, 605911, 605339, 605948, 605966, 440820, 605885, 133308, 605878, 440814, 605619, 133305, 133303, 605903, 605915, 605863, 605906, 605898, 605861, 605896, 440803, 605853, 605730, 440801, 605615, 605613, 440797, 440787, 440783, 605848, 605834, 605806, 605801, 605603, 605601, 605599, 605596, 605796, 605789, 605534, 605532, 605778, 605587, 440772, 605769, 582809, 440756, 440754, 605741, 605712, 440749, 605700, 440747, 115394, 600973, 605573, 600456, 532860, 600452, 440739, 605567, 605558, 605556, 605553, 440726, 605528, 605550, 605523, 440716, 440714, 602549, 200922, 200920, 602528, 602516, 605515, 605448, 605496, 605436, 440705, 440703, 605476, 440701, 605337, 605335, 605479, 605331, 605468, 605329, 605327, 559403, 559401, 582786, 605220, 605215, 605163, 605184, 603185, 599500, 603183, 602640, 602638, 605158, 604412, 604915, 604410, 605137, 605126, 605109, 605104, 604051, 605093, 604048, 605086, 535445, 605017, 605051, 602252, 440666, 597411, 597408, 605073, 605070, 597406, 605062, 605060, 440663, 440661, 593640, 440658, 440655, 604902, 595581, 600443, 603906, 440643, 587599, 590167, 605011, 109243, 109239, 605009, 603995, 605038, 604993, 440631, 605020, 604910, 604984, 440608, 604965, 604970, 604938, 604963, 394072, 604702, 604896, 604890, 604805, 604803, 604856, 604659, 440562, 604792, 604785, 440554, 440552, 604777, 604768, 603928, 603926, 603923, 440524, 440521, 604655, 440519, 604393, 604389, 604385, 604645, 595576, 595574, 595571, 604157, 604497, 604493, 604481, 440496, 440494, 440492, 440490, 440488, 440486, 604458, 592468, 592466, 440474, 604382, 604316, 440472, 604399, 604153, 604279, 604272, 604194, 604260, 604192, 604121, 604207, 604189, 604186, 440456, 604065, 603920, 604111, 595570, 604101, 604103, 532783, 604099, 440448, 604087, 604085, 603992, 601855, 603990, 440443, 604031, 604068, 604079, 604077, 604063, 604061, 604027, 604057, 604022, 603987, 603953, 603951, 590063, 603918, 602243, 602241, 603913, 599491, 603911, 603373, 603496, 623076, 599489, 623073, 603369, 603494, 602238, 603897, 603233, 603888, 603885, 603407, 603882, 603492, 603338, 603336, 440438, 603848, 603386, 603439, 603382, 603415, 603432, 603377, 532758, 603366, 603333, 603331, 603350, 440425, 440418, 603310, 603307, 603305, 603327, 603181, 440412, 603315, 398410, 602151, 603220, 603190, 603169, 603166, 603155, 603153, 603114, 603106, 532740, 603072, 603104, 603100, 603098, 440393, 440382, 593803, 603057, 600930, 593625, 602951, 602958, 440362, 602937, 600428, 440356, 600412, 602933, 602915, 602906, 602808, 602882, 602792, 602787, 602668, 602235, 602225, 602767, 600675, 602764, 602730, 602727, 602682, 602677, 600917, 440338, 599303, 602616, 440334, 602605, 602580, 602597, 602586, 602593, 600911, 601999, 600908, 602440, 440325, 601996, 602498, 602494, 602415, 602406, 602404, 602393, 602389, 575807, 602262, 602372, 602216, 602214, 601993, 602212, 602280, 602297, 602271, 593225, 602258, 602256, 602162, 600393, 602210, 601598, 602147, 602196, 602187, 602171, 602169, 592810, 602157, 602122, 601888, 246669, 602065, 601984, 601982, 601576, 601973, 601961, 580201, 595103, 601946, 601950, 544201, 544199, 575849, 600364, 600360, 600358, 601939, 600350, 440297, 440295, 440290, 440286, 601503, 440274, 601425, 601423, 532687, 601421, 601908, 314770, 580192, 580187, 580185, 601879, 601877, 601874, 582453, 601861, 600333, 601859, 532679, 600331, 600903, 582450, 601390, 601795, 601744, 601793, 601762, 601742, 601739, 601730, 600323, 532678, 532677, 601712, 601417, 600314, 506481, 601413, 506479, 601614, 554756, 521084, 440258, 600844, 601547, 554752, 601545, 601554, 599474, 599472, 601552, 601550, 601542, 600299, 601482, 599298, 440251, 440249, 440246, 601480, 601500, 440243, 601498, 440241, 601497, 601493, 601491, 601489, 601408, 601486, 601405, 601342, 601474, 601479, 600506, 601403, 601401, 601457, 600504, 601450, 440235, 601443, 593206, 601439, 601437, 601433, 601399, 440229, 440227, 595562, 601397, 440225, 440222, 440220, 601395, 595560, 601374, 600891, 595555, 601347, 601350, 601338, 440211, 595538, 601301, 601306, 600840, 600873, 600868, 600822, 600785, 600816, 600810, 600780, 600778, 600762, 600597, 600689, 600685, 600694, 600687, 600715, 600637, 600634, 600630, 600608, 600566, 600556, 600552, 599650, 600542, 596558, 600282, 596552, 600531, 600524, 600273, 600494, 600492, 598561, 440160, 600263, 600148, 591788, 600069, 600074, 594636, 599874, 600018, 597395, 600029, 600024, 600021, 597640, 597638, 597636, 597633, 595188, 593121, 591787, 532611, 599965, 599963, 591785, 591783, 591781, 591779, 393239, 599113, 598725, 598722, 599930, 599904, 599894, 599869, 599867, 599617, 598846, 599802, 599712, 440076, 440072, 599766, 599758, 566802, 599638, 599704, 599718, 354513, 599673, 599665, 599662, 599628, 599242, 599656, 599565, 599545, 599543, 599563, 599445, 596442, 596440, 580173, 349602, 597627, 599438, 597625, 517459, 599442, 439974, 599281, 599279, 598523, 331374, 392952, 599418, 439951, 439949, 439947, 599412, 599407, 599388, 599400, 469416, 599385, 589289, 599383, 596727, 599269, 589659, 596724, 599267, 589655, 599175, 599228, 589653, 599172, 589651, 599226, 599264, 599169, 599262, 589646, 599212, 595529, 599204, 599201, 599185, 599180, 599167, 568989, 595169, 595165, 599158, 599137, 599140, 439931, 599134, 599086, 597651, 596614, 598920, 595382, 598918, 200884, 598843, 598601, 598874, 598868, 598841, 598838, 598836, 598834, 591778, 592426, 598853, 598855, 591776, 580159, 584668, 584666, 584663, 598809, 598799, 598807, 598796, 592544, 592540, 598793, 598788, 584071, 598508, 517456, 598772, 598671, 598759, 591774, 598740, 439862, 598644, 595524, 439860, 598716, 598713, 597796, 598707, 598684, 598681, 598692, 598641, 532573, 598639, 598676, 532571, 598654, 598408, 598665, 598649, 439852, 623050, 598405, 598402, 439846, 598605, 598369, 591768, 591766, 200875, 591764, 591762, 598552, 591760, 598548, 598542, 517452, 598521, 598533, 598518, 598517, 517448, 598513, 598481, 439818, 439801, 598217, 598128, 598121, 594724, 594721, 598103, 594717, 598078, 594715, 598023, 598004, 598003, 594887, 592808, 597875, 593604, 597807, 593600, 593598, 597786, 572523, 597784, 597768, 596496, 597715, 597665, 597673, 597660, 439654, 439650, 200867, 597607, 439639, 246666, 597530, 439599, 597533, 439592, 133289, 133285, 597387, 585307, 597339, 595320, 595316, 597322, 596854, 597201, 596492, 597294, 439527, 373429, 597264, 597285, 597282, 386057, 414183, 414181, 597261, 597197, 597069, 597067, 597182, 597178, 597166, 597133, 597131, 597063, 597129, 597107, 109216, 595493, 596914, 532516, 594357, 439439, 596791, 491107, 596740, 596771, 594352, 596722, 568415, 596657, 614729, 614727, 596717, 614725, 625065, 568413, 596652, 596464, 532502, 596506, 596467, 596426, 595483, 595425, 595422, 593796, 595384, 595306, 585522, 595274, 585520, 595303, 595297, 595284, 439332, 595250, 595248, 595046, 595044, 595242, 595240, 206224, 588783, 473638, 588781, 473635, 595256, 595224, 595213, 595210, 595203, 439302, 439300, 577248, 595076, 595042, 595071, 595027, 592095, 133269, 133265, 595020, 595016, 594990, 594983, 594973, 594967, 594965, 594930, 594858, 594754, 536343, 594871, 594147, 594839, 594145, 594794, 594750, 594748, 594773, 594744, 439272, 594740, 594732, 594667, 594664, 594595, 594584, 594582, 594574, 580147, 585296, 591017, 589638, 594494, 594364, 594340, 570899, 594415, 594405, 580128, 594372, 594318, 594168, 594344, 594315, 594313, 594303, 570888, 594295, 594284, 594280, 439192, 594269, 593971, 594253, 594224, 463747, 594174, 463745, 439164, 594142, 594134, 592882, 594127, 594118, 593786, 593969, 593784, 593967, 593773, 593950, 593938, 593770, 593924, 593913, 593911, 110725, 439132, 593837, 593832, 500380, 593812, 500378, 500376, 593810, 500374, 500371, 570884, 500369, 570882, 570880, 593808, 500367, 593594, 439094, 593744, 439073, 439069, 439065, 593619, 593615, 439062, 593729, 593610, 593583, 592879, 593420, 593568, 593545, 593553, 593514, 585519, 593321, 580115, 575314, 614717, 593397, 593306, 593304, 493857, 593301, 593299, 593318, 593317, 593295, 593265, 593263, 591756, 593250, 593201, 420962, 593170, 593147, 593071, 593145, 593102, 593068, 593089, 593087, 593141, 593085, 593139, 593083, 593061, 572877, 592947, 592943, 592993, 593044, 593026, 593016, 590868, 592972, 585515, 592919, 592841, 592829, 592797, 592637, 592775, 592747, 378174, 592626, 592555, 592549, 591753, 590060, 592474, 532311, 592463, 592460, 591829, 591825, 582166, 592409, 592407, 592450, 592009, 592351, 592346, 592296, 592294, 591824, 589958, 589956, 589951, 591563, 592291, 592289, 591562, 592286, 532295, 592258, 592280, 592241, 592274, 591818, 592267, 592180, 592265, 592237, 591715, 591713, 592173, 592200, 592196, 592163, 592146, 592070, 591950, 614703, 614701, 591749, 592006, 591947, 590004, 591935, 591931, 592048, 420386, 420384, 591861, 591857, 591926, 591748, 591222, 592001, 592029, 591997, 592025, 591991, 591988, 591986, 591946, 591746, 471334, 221953, 591944, 591666, 438884, 591924, 591914, 438879, 591912, 591814, 582087, 591692, 591744, 591832, 591690, 532272, 591650, 581666, 591688, 591670, 591678, 591067, 221938, 625059, 393932, 590866, 591577, 591560, 493332, 221923, 591437, 589933, 517414, 517404, 517394, 591156, 546797, 591124, 554255, 590864, 590861, 294253, 590285, 614698, 314720, 438604, 438602, 110710, 590777, 590398, 160314, 160312, 200826, 221892, 590769, 590736, 590393, 590666, 590647, 590576, 590534, 590734, 590732, 590484, 590671, 585514, 614695, 438509, 590427, 554235, 590381, 57997, 590356, 453713, 590354, 590352, 590348, 579998, 438279, 420377, 438202, 420375, 590231, 579809, 420364, 590163, 614682, 437899, 437892, 590045, 590133, 590131, 109150, 590124, 109148, 590092, 590057, 221831, 437863, 590055, 590053, 420360, 590030, 531872, 590025, 590020, 590016, 590013, 133228, 531829, 589612, 589378, 589584, 589582, 589577, 506438, 420357, 420355, 420353, 589548, 589541, 589537, 26405, 586246, 476805, 589179, 589153, 586203, 559224, 342282, 588692, 588688, 614671, 614667, 588769, 588656, 588758, 588654, 588731, 588726, 588756, 588754, 588723, 588640, 587622, 309787, 588525, 322574, 588469, 347347, 347342, 587606, 437028, 587594, 587588, 587585, 587052, 585513, 587050, 587301, 585511, 587165, 587153, 587150, 587148, 587142, 587139, 587137, 585412, 436686, 436684, 587041, 587032, 584654, 586696, 586234, 586543, 586648, 436524, 586504, 586502, 436518, 586495, 288187, 586525, 288183, 288177, 436453, 436445, 586343, 174364, 586227, 174346, 586200, 174344, 586196, 586192, 586224, 436399, 586188, 586186, 586183, 586181, 586178, 586175, 585789, 586173, 586170, 586220, 586218, 586166, 585787, 585784, 585778, 585776, 436354, 586159, 586153, 585895, 586147, 586145, 586143, 586138, 586135, 586099, 586097, 586095, 579434, 579432, 585891, 585886, 579419, 586061, 586052, 586059, 586050, 579414, 585411, 585409, 246060, 585407, 586022, 585404, 586020, 246057, 585768, 585774, 585866, 585823, 585871, 585800, 585797, 585603, 585772, 548020, 584828, 536154, 585751, 585747, 585745, 585729, 585743, 585723, 585737, 585719, 133210, 548017, 548013, 548010, 436327, 548008, 548006, 436324, 531365, 548004, 548001, 547999, 578387, 585580, 585547, 585545, 585537, 585533, 585509, 585507, 585505, 585502, 584817, 584815, 579377, 484810, 484808, 585403, 363303, 585387, 585337, 585333, 585316, 585271, 585270, 585266, 585282, 484800, 420346, 585165, 420340, 585156, 584954, 23522, 465397, 578238, 584648, 584645, 584643, 584640, 584503, 584501, 577645, 584210, 537734, 584249, 420334, 420332, 500352, 584193, 420330, 420328, 622372, 622370, 584188, 622368, 584184, 584181, 584179, 576180, 366253, 366251, 584156, 500342, 584154, 584152, 500338, 584150, 500336, 500332, 500329, 500324, 500318, 500313, 584106, 500303, 500299, 500297, 581589, 500295, 500293, 500290, 500289, 584068, 500286, 581587, 500284, 500282, 500274, 581391, 581071, 517386, 578729, 555285, 555283, 420327, 419043, 419039, 420325, 578216, 578209, 575389, 578126, 576882, 420319, 349415, 576880, 420317, 420315, 420312, 577965, 562584, 530953, 577952, 577950, 420310, 577946, 577895, 420307, 420290, 434664, 577485, 577440, 567215, 577326, 522672, 577306, 577253, 514643, 221212, 389630, 575383, 420287, 420285, 420283, 415115, 536699, 536695, 366244, 536692, 366242, 415112, 481371, 366240, 548274, 568321, 568318, 568314, 420681, 420668, 448091, 420250, 415415, 419263, 418585, 389795, 389793, 417314, 378094, 132154, 378092, 366238, 415463, 240698, 389783, 393706, 411490, 393923, 410499, 410496, 393918, 410491, 362271, 362265, 362260, 409726, 215762, 240273, 107101, 407491, 407487, 228388, 240048, 107087, 107085, 407187, 406564, 228346, 406796, 228311, 228308, 228302, 228297, 406559, 228295, 228293, 228291, 406533, 228281, 239957, 406005, 405670, 405659, 215629, 405990, 405979, 405975, 10551, 228247, 228239, 404618, 188171, 405640, 404956, 188158, 366234, 188133, 188131, 228222, 228220, 402226, 174237, 402212, 228208, 404047, 403549, 404045, 404044, 106978, 106956, 106952, 106949, 320422, 302068, 132041, 366230, 399655, 397700, 399095, 399024, 399019, 398890, 398594, 323845, 323841, 205402, 392462, 318284, 131976, 308780, 397848, 106773, 397656, 397041, 397123, 397028, 392618, 106684, 131943, 106674, 197093, 131937, 395439, 395437, 106647, 388406, 388400, 106644, 131934, 106623, 113250, 395357, 395308, 113246, 239326, 394873, 394766, 113239, 394846, 215134, 394749, 394837, 394692, 388399, 394684, 23386, 23382, 394614, 394406, 391767, 394397, 394395, 394393, 394364, 394193, 394360, 394347, 131904, 302053, 131897, 131893, 394160, 131891, 394158, 394127, 394114, 393892, 113230, 392433, 113227, 393714, 393327, 393127, 392584, 392389, 389776, 391843, 391684, 389654, 389439, 389514, 390710, 390388, 390372, 106581, 390277, 239014, 389635, 389998, 239002, 389989, 278031, 106550, 278029, 106547, 389755, 389763, 389751, 389561, 368765, 389380, 388675, 388673, 389378, 389371, 387949, 359119, 387544, 387627, 383913, 383910, 387569, 383908, 383900, 387542, 387474, 161772, 387391, 359103, 308709, 308703, 364137, 385218, 385216, 379885, 303260, 382960, 384344, 383363, 383932, 383930, 383895, 383924, 383891, 378087, 383354, 336200, 383347, 336198, 378084, 382949, 382947, 161729, 381728, 23362, 377558, 381437, 381335, 381435, 381331, 381319, 378056, 377605, 377150, 366903, 374463, 375570, 375127, 373470, 366227, 373935, 373694, 371284, 373933, 373931, 373456, 366224, 372493, 373298, 372490, 372487, 371281, 371269, 356357, 370236, 368595, 368593, 368564, 308589, 308587, 366465, 366449, 366266, 330792, 366220, 330788, 366260, 366217, 366213, 365432, 365890, 36032, 226403, 226400, 226398, 23345, 363213, 362990, 363209, 363126, 359776, 359774, 359772, 226311, 362936, 226306, 361712, 359767, 361710, 361708, 207519, 361706, 268878, 361921, 361704, 361700, 237599, 237597, 358649, 358422, 361189, 361009, 361017, 360946, 360638, 358416, 360317, 359555, 359326, 359730, 350308, 359553, 252560, 358380, 252554, 354847, 357947, 357945, 357706, 357940, 213029, 357936, 213026, 213023, 357862, 207495, 357023, 213014, 356973, 213011, 213009, 213007))
Run Time: 0.209984
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3706 | |
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 | | | | | 3706 | |
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 (34754, 34347, 34095, 34084, 34041, 33916, 33847, 33833, 33815, 33797, 33763, 33636, 33583, 33511, 33230, 33226, 33216, 33193, 33169, 33155, 33141, 33124, 33087, 33050, 33010, 33004, 33001, 32986, 32965, 32913, 32863, 32856, 32819, 32759, 32702, 32686, 32683, 32677, 32676, 32662, 32659, 33368, 33367, 32630, 32628, 32619, 32617, 32595, 32589, 32584, 32559, 32554, 32556, 32546, 32530, 32508, 32507, 32481, 32465, 32431, 32388, 32387, 32384, 32383, 32365, 32340, 32335, 32315, 32313, 32311, 32307, 32273, 32245, 32210, 32205, 32168, 32164, 32161, 32157, 32154, 32151, 32152, 32148, 32150, 32147, 32149, 32143, 32137, 32134, 32133, 32131, 32141, 32128, 32127, 32126, 32125, 32087, 32086, 32085, 32084, 32083, 32073, 32071, 32070, 32059, 32049, 32048, 32040, 32029, 31941, 31932, 31922, 31900, 31891, 31875, 32056, 31862, 31850, 31821, 31812, 31807, 31781, 31724, 31714, 31713, 31712, 31682, 31681, 31644, 31609, 31603, 31569, 31536, 31987, 31523, 31511, 31411, 31396, 31878, 31388, 31368, 31945, 31350, 31315, 31944, 31291, 31958, 31288, 31260, 31235, 31234, 31232, 31227, 31962, 31213, 31193, 31943, 31169, 31961, 31157, 31155, 31957, 31140, 31956, 33666, 31116, 31115, 31093, 31089, 31960, 31062, 31060, 31059, 31955, 31044, 31033, 31023, 31021, 31013, 31000, 30994, 30878, 30692, 30690, 30627, 30598, 30590, 30589, 30535, 30503, 30457, 30375, 29657, 21674, 19656, 19623, 19540, 19503, 19263, 19235, 18725, 18716, 18617, 18338, 18324, 18300, 18140, 18088, 17884))
Run Time: 0.013484
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 209 | 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 (643447, 642494, 447561, 638541, 637771, 638413, 638286, 637913, 637911, 637908, 637906, 500388, 637766, 637760, 500384, 500382, 637707, 637695, 446793, 637271, 636141, 580664, 446766, 446751, 446749, 247259, 446747, 247257, 637031, 636955, 636982, 636979, 636951, 636949, 446593, 446589, 247224, 247208, 247206, 635914, 635562, 604203, 635558, 446434, 634398, 634396, 634392, 634387, 634359, 634283, 446290, 634298, 446283, 446280, 634279, 634278, 634273, 446271, 446240, 634061, 633715, 633711, 593665, 633664, 446214, 593659, 593654, 632048, 632046, 536406, 446162, 446160, 633318, 633270, 633183, 608494, 608489, 633080, 633234, 632766, 632995, 632247, 632993, 608478, 632981, 446052, 632896, 632760, 632762, 632747, 445986, 631632, 625683, 632698, 445970, 632683, 632675, 632610, 445957, 632588, 445955, 632498, 632544, 632529, 632463, 632459, 632517, 632452, 445949, 632449, 632486, 629897, 632413, 632318, 445938, 632122, 632178, 580585, 580583, 632074, 599855, 632002, 632029, 631952, 445876, 631949, 631948, 631946, 631968, 631936, 631934, 631866, 631863, 453803, 631528, 631515, 631508, 580579, 580576, 631502, 631727, 631709, 631702, 445792, 445782, 631467, 631450, 631447, 631690, 631688, 580569, 631333, 445752, 445751, 631330, 627103, 631335, 631311, 445695, 631304, 445684, 596082, 445671, 627920, 605411, 631265, 631194, 392477, 631227, 580542, 392474, 631099, 331425, 331411, 247093, 445640, 606764, 445619, 631006, 630946, 630956, 460477, 247090, 630939, 630389, 630919, 445579, 607440, 630858, 630862, 445564, 630811, 613656, 630809, 607432, 630693, 630687, 445545, 630643, 629885, 445542, 630659, 445539, 630314, 445536, 630605, 445531, 630598, 445529, 445519, 605404, 458304, 596073, 630554, 630510, 445513, 630447, 630332, 630445, 630386, 624172, 630415, 630384, 630377, 630373, 630348, 630369, 630350, 630337, 445507, 596063, 445468, 630151, 445466, 593474, 445464, 630141, 630139, 247077, 630055, 629840, 630037, 630014, 629825, 247062, 629756, 629777, 629698, 629692, 629687, 445430, 613446, 629668, 608971, 629497, 445395, 445388, 629495, 613438, 613435, 629611, 613433, 445370, 629553, 580518, 629522, 629485, 629473, 629469, 453784, 629379, 629400, 629377, 629345, 629319, 624148, 445317, 629247, 536380, 629203, 629182, 629199, 629170, 629178, 247023, 580490, 629036, 628344, 629076, 462507, 247015, 629032, 629045, 625843, 628980, 386089, 628956, 628968, 628950, 616330, 628853, 628907, 628874, 445293, 628581, 606392, 445291, 628567, 628858, 609384, 628546, 609382, 628777, 628801, 628807, 628756, 628752, 628716, 628708, 628700, 628661, 628530, 628527, 628525, 628511, 609378, 445260, 628492, 628487, 628472, 628468, 628386, 628384, 628232, 627527, 628409, 628399, 628396, 606389, 606387, 247001, 246999, 628365, 246997, 445228, 628340, 445226, 445223, 628370, 601327, 628368, 601326, 445209, 445207, 598849, 445201, 628337, 628230, 628335, 628228, 445185, 628296, 628290, 628223, 628220, 628216, 445169, 628213, 628208, 445161, 445152, 628179, 627510, 628173, 628148, 628137, 628113, 628141, 628111, 628121, 628119, 628115, 628104, 628094, 628090, 628084, 628080, 445138, 627977, 627973, 627958, 627496, 627956, 627945, 627964, 627899, 627896, 356094, 627894, 627933, 627494, 627822, 356089, 627930, 627818, 445131, 627810, 627826, 627843, 574739, 627797, 627792, 627311, 627491, 627787, 627486, 627484, 627479, 627777, 627476, 627535, 627774, 627780, 627473, 627772, 627762, 627770, 627716, 627719, 627723, 627592, 627645, 605670, 627435, 445015, 609065, 604416, 614755, 627348, 627058, 627324, 626998, 627309, 444995, 444990, 627208, 580446, 627064, 627172, 627171, 627084, 444961, 444959, 627025, 444957, 595972, 626962, 626948, 626852, 626881, 608211, 444901, 444893, 626774, 626735, 564958, 626682, 626653, 614857, 626575, 626506, 626567, 626465, 626462, 626418, 626453, 626448, 625171, 626408, 444854, 626392, 626371, 534272, 444839, 626361, 444831, 626357, 444822, 444820, 391995, 626342, 444814, 444808, 109256, 607391, 444797, 607387, 444792, 444789, 444781, 444772, 444764, 626315, 444761, 444759, 444754, 444752, 610264, 626207, 626206, 547946, 626189, 626186, 391985, 626181, 391982, 626177, 626175, 626125, 626167, 626165, 626170, 626163, 626118, 626109, 626116, 22840, 444725, 22837, 626087, 626049, 626078, 626073, 626016, 626027, 626012, 626025, 626009, 625948, 444717, 625973, 625910, 444715, 625991, 444697, 625964, 444680, 625903, 625901, 625899, 444674, 625868, 625830, 625879, 625856, 625864, 625871, 444651, 444645, 625849, 625847, 625826, 444629, 625823, 625806, 625784, 625782, 625778, 625596, 444609, 444599, 572542, 625749, 572540, 625729, 625738, 572535, 444543, 444528, 580428, 444515, 453759, 444513, 625696, 625674, 444497, 444493, 625618, 625648, 625653, 625612, 625544, 444459, 625534, 444447, 625505, 625513, 444436, 625334, 625332, 625479, 580400, 625474, 444434, 444431, 602052, 625453, 625460, 625329, 607379, 625447, 595939, 625435, 625404, 595936, 444406, 625378, 625368, 625358, 625355, 444390, 444382, 557028, 625323, 610246, 444379, 625280, 625283, 625288, 444368, 625278, 444362, 610242, 625263, 625257, 444355, 444351, 625227, 482295, 444336, 625225, 625244, 625250, 625242, 625222, 625205, 580378, 580370, 625184, 610239, 625136, 625176, 624185, 625148, 625153, 607231, 623978, 444286, 444276, 625105, 625113, 625092, 624401, 624389, 624369, 624380, 624374, 444206, 444201, 444190, 605663, 444175, 624334, 608467, 624300, 608464, 534071, 534069, 608454, 608450, 624268, 624276, 624264, 444132, 444131, 605654, 624201, 624196, 624107, 624029, 623969, 623967, 623965, 624023, 599329, 624004, 623959, 616325, 614258, 623902, 444054, 623895, 444033, 444024, 444015, 444012, 444007, 623823, 623819, 595926, 444005, 601068, 595915, 595906, 624097, 615001, 614999, 623793, 443966, 443963, 443961, 443947, 606376, 443915, 607908, 443911, 443908, 595900, 623768, 443903, 616159, 623744, 616080, 623697, 623680, 443863, 443856, 615716, 615969, 615967, 615965, 623653, 615963, 623651, 623660, 615960, 443791, 623463, 615955, 614255, 615948, 615946, 580824, 623515, 443764, 443759, 443744, 623390, 608445, 623394, 608442, 624075, 623382, 623379, 604200, 623377, 443732, 616323, 443727, 616321, 616316, 623340, 616350, 616346, 616310, 616342, 616308, 616289, 613537, 443721, 443714, 616222, 616238, 613090, 443688, 336719, 443669, 616192, 614251, 616171, 180982, 443655, 614246, 616077, 614243, 616100, 615905, 443639, 614240, 616072, 616070, 616068, 443621, 614238, 443613, 614236, 614233, 443609, 616062, 614229, 614227, 615821, 616055, 611395, 611393, 611392, 613534, 614225, 443607, 616013, 614217, 616003, 615981, 615891, 615921, 615886, 615884, 614213, 614207, 614205, 614203, 614198, 595876, 614196, 614194, 614192, 614188, 614185, 443554, 246910, 443508, 201033, 607888, 609374, 615847, 614176, 607313, 389721, 615598, 615835, 615775, 615799, 443463, 533829, 595870, 443459, 615750, 615679, 615676, 443418, 615722, 612278, 615672, 614175, 614173, 614171, 614168, 615662, 614165, 614161, 614159, 246881, 614157, 443389, 615624, 349963, 615607, 443347, 614153, 615591, 349956, 615584, 614150, 614148, 614146, 614144, 615582, 614142, 615578, 614140, 478947, 614130, 614128, 614126, 614124, 612844, 614121, 614119, 614117, 614115, 443330, 443318, 443305, 443296, 443285, 443271, 288, 4718, 613613, 613612, 443268, 443261, 443259, 443257, 615515, 506485, 506483, 4712, 4710, 610224, 614853, 34271, 615510, 615497, 615492, 613532, 615483, 613530, 443218, 615362, 443215, 615356, 615353, 614981, 615095, 605642, 615035, 615030, 443149, 443146, 443133, 605631, 615021, 443123, 614989, 607850, 614978, 614937, 443069, 443067, 443061, 443059, 443042, 610213, 610210, 614902, 443023, 443020, 580320, 443018, 443014, 442986, 614877, 614841, 614835, 442969, 457961, 606371, 614791, 442958, 442952, 442947, 442944, 614771, 614768, 593652, 593650, 614745, 613525, 442878, 442837, 442834, 614288, 608943, 613805, 614267, 614103, 614264, 614100, 180969, 614093, 614091, 614088, 614086, 614083, 614077, 614073, 614065, 614044, 442758, 442755, 442730, 442724, 442713, 442707, 607842, 614001, 613896, 613887, 613884, 613881, 613991, 613957, 613961, 613861, 612497, 612495, 613516, 613696, 613514, 442692, 246825, 613802, 613739, 613800, 613797, 613795, 613791, 613759, 613762, 612628, 613729, 610606, 610604, 608936, 554444, 554442, 442658, 580286, 554437, 554435, 612108, 610197, 595852, 613673, 412566, 595848, 442625, 613510, 442620, 613508, 595845, 613506, 613499, 601018, 613552, 593751, 442581, 613406, 604707, 613388, 442551, 442548, 442546, 608423, 608420, 608415, 442536, 613378, 442528, 613363, 606352, 580249, 612838, 612836, 592144, 613311, 613293, 442493, 613217, 442478, 613238, 442458, 613192, 442453, 246802, 613104, 613102, 613073, 613121, 613055, 609112, 612990, 442422, 612980, 602027, 602025, 613042, 613035, 613033, 613030, 442345, 442343, 612948, 580234, 612945, 442310, 612480, 442308, 442306, 533514, 612476, 612472, 612464, 612463, 442270, 442263, 442224, 442222, 442221, 612682, 442183, 612809, 612801, 612752, 392470, 612795, 612825, 612718, 612749, 612769, 612721, 632787, 609370, 612626, 612622, 612631, 612658, 608920, 608917, 598574, 608915, 612611, 612609, 608913, 611386, 442072, 608171, 611381, 612274, 612543, 612536, 612512, 442043, 612510, 442038, 609356, 609521, 609517, 609514, 604197, 612501, 604195, 442005, 612486, 442000, 609728, 608586, 595819, 612429, 609353, 609350, 605391, 612234, 441980, 608901, 441977, 612223, 200994, 605384, 612216, 612214, 612107, 612151, 612147, 612104, 612097, 612094, 612091, 612083, 612062, 612081, 612059, 612031, 611995, 612016, 611989, 610103, 441888, 441883, 606999, 606997, 611912, 610912, 441852, 611847, 611827, 611824, 611795, 611820, 611768, 611665, 611663, 441803, 611673, 611632, 611611, 611629, 611626, 207580, 611606, 441789, 611583, 611570, 611207, 611532, 605371, 593269, 611558, 611524, 441710, 611313, 611305, 441689, 441687, 441677, 611239, 611221, 441650, 611165, 611062, 611058, 611054, 611109, 611107, 609345, 611016, 611011, 611005, 608628, 583017, 602183, 610975, 608192, 608190, 602180, 608187, 608184, 610992, 610974, 610986, 595765, 610984, 610981, 610979, 610963, 222464, 610948, 610921, 441542, 472710, 610844, 610841, 610837, 441499, 441494, 595753, 610739, 610880, 533226, 610781, 578257, 610852, 453747, 597362, 597359, 597347, 610775, 578253, 578251, 610823, 610819, 603999, 610738, 610736, 441476, 441471, 578245, 533213, 533210, 449868, 610716, 441466, 441461, 603525, 441458, 610595, 610572, 441433, 610507, 441406, 610505, 610428, 610502, 610491, 610483, 609105, 610395, 610392, 610384, 610381, 610373, 595719, 610367, 599844, 602852, 608560, 608550, 611703, 610185, 611701, 441373, 610161, 441366, 441363, 110741, 609644, 110739, 610157, 609768, 610155, 609641, 610148, 606250, 610138, 610134, 200969, 609635, 609632, 609099, 610067, 441344, 373130, 610054, 533121, 533118, 441338, 609630, 610029, 133350, 610040, 609623, 610017, 571133, 441331, 441329, 571131, 571129, 609970, 609983, 610007, 571126, 609980, 441325, 609975, 609972, 441322, 533109, 609733, 609216, 609711, 609546, 609544, 609542, 609540, 609538, 609705, 609703, 609698, 609692, 609676, 609673, 609536, 596597, 609649, 533100, 596593, 596591, 609605, 609482, 609614, 609602, 609599, 609568, 609565, 609563, 609561, 609559, 609592, 609557, 596588, 609551, 609461, 609532, 51333, 51328, 609459, 609480, 609455, 609446, 533086, 609442, 609439, 609433, 609410, 609342, 609340, 609336, 609404, 526635, 441300, 133346, 441298, 441290, 608317, 533076, 608313, 609289, 605359, 609278, 609276, 609283, 595708, 607582, 609259, 608408, 609257, 608405, 608403, 608401, 608399, 609057, 609055, 607580, 608892, 608890, 609154, 593643, 609046, 609044, 133344, 609041, 133342, 133340, 133338, 609145, 133335, 133329, 608881, 590070, 608865, 533049, 608862, 608877, 609127, 607356, 590068, 590065, 593919, 609033, 593917, 609030, 609027, 595702, 609003, 608963, 608662, 608969, 608951, 608875, 608967, 608949, 608659, 608975, 584745, 608830, 608871, 608852, 608849, 608845, 608819, 608802, 608655, 608790, 608783, 595691, 595687, 607066, 608780, 608774, 607349, 608772, 608596, 608777, 623125, 417913, 608763, 608726, 608700, 607962, 608668, 608583, 608653, 608683, 604361, 608593, 533034, 608580, 603940, 603937, 603935, 608389, 608573, 608569, 608532, 608372, 608530, 331395, 608365, 607298, 605818, 607296, 453740, 607831, 441227, 608353, 441222, 441219, 441216, 441211, 608326, 441208, 602010, 608323, 441202, 441196, 600803, 608310, 592123, 200958, 607829, 536375, 608238, 608233, 608134, 608131, 608129, 608126, 608123, 608120, 608116, 608217, 608181, 608175, 608158, 608114, 608155, 590064, 605815, 608139, 607740, 608099, 608097, 608095, 607734, 608050, 607822, 607730, 441156, 456308, 607980, 608027, 441150, 608024, 608022, 133322, 607803, 606053, 441146, 554423, 607776, 607978, 607765, 133318, 607975, 607973, 607965, 607774, 607763, 607795, 607792, 607787, 441137, 607778, 607758, 607754, 605734, 607704, 607714, 412560, 554421, 607662, 607648, 607650, 607626, 607622, 605356, 607572, 607544, 615525, 607562, 607558, 607150, 605351, 607506, 441102, 607340, 607325, 512009, 499502, 592208, 607245, 603462, 606760, 607194, 441021, 597421, 441019, 607108, 607157, 471347, 607103, 607148, 200944, 200942, 200940, 471339, 607048, 607042, 604177, 606978, 604172, 606926, 440984, 440983, 606934, 606918, 595668, 606897, 595665, 606879, 606868, 597417, 595656, 606861, 440967, 606830, 595645, 440954, 606316, 602739, 440951, 440949, 440947, 606813, 600709, 606793, 606780, 440945, 600706, 600705, 600700, 600698, 606750, 606741, 623091, 469426, 440935, 440933, 554410, 440929, 554408, 606669, 606696, 606681, 606684, 440925, 440923, 606657, 606656, 606652, 606642, 440915, 440910, 606628, 414214, 440905, 440900, 440896, 606568, 440890, 606565, 440887, 606571, 606562, 440884, 606527, 606506, 606313, 606502, 606546, 606310, 606307, 606551, 606543, 606540, 606237, 414208, 606489, 595627, 606194, 440877, 606306, 606304, 606299, 606433, 554404, 606448, 606444, 532888, 606428, 606417, 440858, 606272, 606289, 606295, 606293, 606261, 554400, 554398, 595621, 595619, 595617, 595615, 554396, 606259, 606257, 606266, 606233, 606192, 606254, 606230, 440855, 440848, 606227, 606190, 595606, 595603, 595601, 606188, 606222, 606185, 331390, 331388, 331381, 331380, 331377, 200934, 580220, 606181, 605814, 602037, 605812, 133311, 606131, 606120, 606117, 200932, 606110, 200930, 606083, 597230, 597227, 606070, 606075, 606068, 605996, 606035, 605956, 605954, 605999, 246699, 605991, 440832, 605981, 595595, 246695, 246693, 246690, 605446, 600044, 246686, 605974, 605970, 605911, 605339, 605948, 605966, 440820, 605885, 133308, 605878, 440814, 605619, 133305, 133303, 605903, 605915, 605863, 605906, 605898, 605861, 605896, 440803, 605853, 605730, 440801, 605615, 605613, 440797, 440787, 440783, 605848, 605834, 605806, 605801, 605603, 605601, 605599, 605596, 605796, 605789, 605534, 605532, 605778, 605587, 440772, 605769, 582809, 440756, 440754, 605741, 605712, 440749, 605700, 440747, 115394, 600973, 605573, 600456, 532860, 600452, 440739, 605567, 605558, 605556, 605553, 440726, 605528, 605550, 605523, 440716, 440714, 602549, 200922, 200920, 602528, 602516, 605515, 605448, 605496, 605436, 440705, 440703, 605476, 440701, 605337, 605335, 605479, 605331, 605468, 605329, 605327, 559403, 559401, 582786, 605220, 605215, 605163, 605184, 603185, 599500, 603183, 602640, 602638, 605158, 604412, 604915, 604410, 605137, 605126, 605109, 605104, 604051, 605093, 604048, 605086, 535445, 605017, 605051, 602252, 440666, 597411, 597408, 605073, 605070, 597406, 605062, 605060, 440663, 440661, 593640, 440658, 440655, 604902, 595581, 600443, 603906, 440643, 587599, 590167, 605011, 109243, 109239, 605009, 603995, 605038, 604993, 440631, 605020, 604910, 604984, 440608, 604965, 604970, 604938, 604963, 394072, 604702, 604896, 604890, 604805, 604803, 604856, 604659, 440562, 604792, 604785, 440554, 440552, 604777, 604768, 603928, 603926, 603923, 440524, 440521, 604655, 440519, 604393, 604389, 604385, 604645, 595576, 595574, 595571, 604157, 604497, 604493, 604481, 440496, 440494, 440492, 440490, 440488, 440486, 604458, 592468, 592466, 440474, 604382, 604316, 440472, 604399, 604153, 604279, 604272, 604194, 604260, 604192, 604121, 604207, 604189, 604186, 440456, 604065, 603920, 604111, 595570, 604101, 604103, 532783, 604099, 440448, 604087, 604085, 603992, 601855, 603990, 440443, 604031, 604068, 604079, 604077, 604063, 604061, 604027, 604057, 604022, 603987, 603953, 603951, 590063, 603918, 602243, 602241, 603913, 599491, 603911, 603373, 603496, 623076, 599489, 623073, 603369, 603494, 602238, 603897, 603233, 603888, 603885, 603407, 603882, 603492, 603338, 603336, 440438, 603848, 603386, 603439, 603382, 603415, 603432, 603377, 532758, 603366, 603333, 603331, 603350, 440425, 440418, 603310, 603307, 603305, 603327, 603181, 440412, 603315, 398410, 602151, 603220, 603190, 603169, 603166, 603155, 603153, 603114, 603106, 532740, 603072, 603104, 603100, 603098, 440393, 440382, 593803, 603057, 600930, 593625, 602951, 602958, 440362, 602937, 600428, 440356, 600412, 602933, 602915, 602906, 602808, 602882, 602792, 602787, 602668, 602235, 602225, 602767, 600675, 602764, 602730, 602727, 602682, 602677, 600917, 440338, 599303, 602616, 440334, 602605, 602580, 602597, 602586, 602593, 600911, 601999, 600908, 602440, 440325, 601996, 602498, 602494, 602415, 602406, 602404, 602393, 602389, 575807, 602262, 602372, 602216, 602214, 601993, 602212, 602280, 602297, 602271, 593225, 602258, 602256, 602162, 600393, 602210, 601598, 602147, 602196, 602187, 602171, 602169, 592810, 602157, 602122, 601888, 246669, 602065, 601984, 601982, 601576, 601973, 601961, 580201, 595103, 601946, 601950, 544201, 544199, 575849, 600364, 600360, 600358, 601939, 600350, 440297, 440295, 440290, 440286, 601503, 440274, 601425, 601423, 532687, 601421, 601908, 314770, 580192, 580187, 580185, 601879, 601877, 601874, 582453, 601861, 600333, 601859, 532679, 600331, 600903, 582450, 601390, 601795, 601744, 601793, 601762, 601742, 601739, 601730, 600323, 532678, 532677, 601712, 601417, 600314, 506481, 601413, 506479, 601614, 554756, 521084, 440258, 600844, 601547, 554752, 601545, 601554, 599474, 599472, 601552, 601550, 601542, 600299, 601482, 599298, 440251, 440249, 440246, 601480, 601500, 440243, 601498, 440241, 601497, 601493, 601491, 601489, 601408, 601486, 601405, 601342, 601474, 601479, 600506, 601403, 601401, 601457, 600504, 601450, 440235, 601443, 593206, 601439, 601437, 601433, 601399, 440229, 440227, 595562, 601397, 440225, 440222, 440220, 601395, 595560, 601374, 600891, 595555, 601347, 601350, 601338, 440211, 595538, 601301, 601306, 600840, 600873, 600868, 600822, 600785, 600816, 600810, 600780, 600778, 600762, 600597, 600689, 600685, 600694, 600687, 600715, 600637, 600634, 600630, 600608, 600566, 600556, 600552, 599650, 600542, 596558, 600282, 596552, 600531, 600524, 600273, 600494, 600492, 598561, 440160, 600263, 600148, 591788, 600069, 600074, 594636, 599874, 600018, 597395, 600029, 600024, 600021, 597640, 597638, 597636, 597633, 595188, 593121, 591787, 532611, 599965, 599963, 591785, 591783, 591781, 591779, 393239, 599113, 598725, 598722, 599930, 599904, 599894, 599869, 599867, 599617, 598846, 599802, 599712, 440076, 440072, 599766, 599758, 566802, 599638, 599704, 599718, 354513, 599673, 599665, 599662, 599628, 599242, 599656, 599565, 599545, 599543, 599563, 599445, 596442, 596440, 580173, 349602, 597627, 599438, 597625, 517459, 599442, 439974, 599281, 599279, 598523, 331374, 392952, 599418, 439951, 439949, 439947, 599412, 599407, 599388, 599400, 469416, 599385, 589289, 599383, 596727, 599269, 589659, 596724, 599267, 589655, 599175, 599228, 589653, 599172, 589651, 599226, 599264, 599169, 599262, 589646, 599212, 595529, 599204, 599201, 599185, 599180, 599167, 568989, 595169, 595165, 599158, 599137, 599140, 439931, 599134, 599086, 597651, 596614, 598920, 595382, 598918, 200884, 598843, 598601, 598874, 598868, 598841, 598838, 598836, 598834, 591778, 592426, 598853, 598855, 591776, 580159, 584668, 584666, 584663, 598809, 598799, 598807, 598796, 592544, 592540, 598793, 598788, 584071, 598508, 517456, 598772, 598671, 598759, 591774, 598740, 439862, 598644, 595524, 439860, 598716, 598713, 597796, 598707, 598684, 598681, 598692, 598641, 532573, 598639, 598676, 532571, 598654, 598408, 598665, 598649, 439852, 623050, 598405, 598402, 439846, 598605, 598369, 591768, 591766, 200875, 591764, 591762, 598552, 591760, 598548, 598542, 517452, 598521, 598533, 598518, 598517, 517448, 598513, 598481, 439818, 439801, 598217, 598128, 598121, 594724, 594721, 598103, 594717, 598078, 594715, 598023, 598004, 598003, 594887, 592808, 597875, 593604, 597807, 593600, 593598, 597786, 572523, 597784, 597768, 596496, 597715, 597665, 597673, 597660, 439654, 439650, 200867, 597607, 439639, 246666, 597530, 439599, 597533, 439592, 133289, 133285, 597387, 585307, 597339, 595320, 595316, 597322, 596854, 597201, 596492, 597294, 439527, 373429, 597264, 597285, 597282, 386057, 414183, 414181, 597261, 597197, 597069, 597067, 597182, 597178, 597166, 597133, 597131, 597063, 597129, 597107, 109216, 595493, 596914, 532516, 594357, 439439, 596791, 491107, 596740, 596771, 594352, 596722, 568415, 596657, 614729, 614727, 596717, 614725, 625065, 568413, 596652, 596464, 532502, 596506, 596467, 596426, 595483, 595425, 595422, 593796, 595384, 595306, 585522, 595274, 585520, 595303, 595297, 595284, 439332, 595250, 595248, 595046, 595044, 595242, 595240, 206224, 588783, 473638, 588781, 473635, 595256, 595224, 595213, 595210, 595203, 439302, 439300, 577248, 595076, 595042, 595071, 595027, 592095, 133269, 133265, 595020, 595016, 594990, 594983, 594973, 594967, 594965, 594930, 594858, 594754, 536343, 594871, 594147, 594839, 594145, 594794, 594750, 594748, 594773, 594744, 439272, 594740, 594732, 594667, 594664, 594595, 594584, 594582, 594574, 580147, 585296, 591017, 589638, 594494, 594364, 594340, 570899, 594415, 594405, 580128, 594372, 594318, 594168, 594344, 594315, 594313, 594303, 570888, 594295, 594284, 594280, 439192, 594269, 593971, 594253, 594224, 463747, 594174, 463745, 439164, 594142, 594134, 592882, 594127, 594118, 593786, 593969, 593784, 593967, 593773, 593950, 593938, 593770, 593924, 593913, 593911, 110725, 439132, 593837, 593832, 500380, 593812, 500378, 500376, 593810, 500374, 500371, 570884, 500369, 570882, 570880, 593808, 500367, 593594, 439094, 593744, 439073, 439069, 439065, 593619, 593615, 439062, 593729, 593610, 593583, 592879, 593420, 593568, 593545, 593553, 593514, 585519, 593321, 580115, 575314, 614717, 593397, 593306, 593304, 493857, 593301, 593299, 593318, 593317, 593295, 593265, 593263, 591756, 593250, 593201, 420962, 593170, 593147, 593071, 593145, 593102, 593068, 593089, 593087, 593141, 593085, 593139, 593083, 593061, 572877, 592947, 592943, 592993, 593044, 593026, 593016, 590868, 592972, 585515, 592919, 592841, 592829, 592797, 592637, 592775, 592747, 378174, 592626, 592555, 592549, 591753, 590060, 592474, 532311, 592463, 592460, 591829, 591825, 582166, 592409, 592407, 592450, 592009, 592351, 592346, 592296, 592294, 591824, 589958, 589956, 589951, 591563, 592291, 592289, 591562, 592286, 532295, 592258, 592280, 592241, 592274, 591818, 592267, 592180, 592265, 592237, 591715, 591713, 592173, 592200, 592196, 592163, 592146, 592070, 591950, 614703, 614701, 591749, 592006, 591947, 590004, 591935, 591931, 592048, 420386, 420384, 591861, 591857, 591926, 591748, 591222, 592001, 592029, 591997, 592025, 591991, 591988, 591986, 591946, 591746, 471334, 221953, 591944, 591666, 438884, 591924, 591914, 438879, 591912, 591814, 582087, 591692, 591744, 591832, 591690, 532272, 591650, 581666, 591688, 591670, 591678, 591067, 221938, 625059, 393932, 590866, 591577, 591560, 493332, 221923, 591437, 589933, 517414, 517404, 517394, 591156, 546797, 591124, 554255, 590864, 590861, 294253, 590285, 614698, 314720, 438604, 438602, 110710, 590777, 590398, 160314, 160312, 200826, 221892, 590769, 590736, 590393, 590666, 590647, 590576, 590534, 590734, 590732, 590484, 590671, 585514, 614695, 438509, 590427, 554235, 590381, 57997, 590356, 453713, 590354, 590352, 590348, 579998, 438279, 420377, 438202, 420375, 590231, 579809, 420364, 590163, 614682, 437899, 437892, 590045, 590133, 590131, 109150, 590124, 109148, 590092, 590057, 221831, 437863, 590055, 590053, 420360, 590030, 531872, 590025, 590020, 590016, 590013, 133228, 531829, 589612, 589378, 589584, 589582, 589577, 506438, 420357, 420355, 420353, 589548, 589541, 589537, 26405, 586246, 476805, 589179, 589153, 586203, 559224, 342282, 588692, 588688, 614671, 614667, 588769, 588656, 588758, 588654, 588731, 588726, 588756, 588754, 588723, 588640, 587622, 309787, 588525, 322574, 588469, 347347, 347342, 587606, 437028, 587594, 587588, 587585, 587052, 585513, 587050, 587301, 585511, 587165, 587153, 587150, 587148, 587142, 587139, 587137, 585412, 436686, 436684, 587041, 587032, 584654, 586696, 586234, 586543, 586648, 436524, 586504, 586502, 436518, 586495, 288187, 586525, 288183, 288177, 436453, 436445, 586343, 174364, 586227, 174346, 586200, 174344, 586196, 586192, 586224, 436399, 586188, 586186, 586183, 586181, 586178, 586175, 585789, 586173, 586170, 586220, 586218, 586166, 585787, 585784, 585778, 585776, 436354, 586159, 586153, 585895, 586147, 586145, 586143, 586138, 586135, 586099, 586097, 586095, 579434, 579432, 585891, 585886, 579419, 586061, 586052, 586059, 586050, 579414, 585411, 585409, 246060, 585407, 586022, 585404, 586020, 246057, 585768, 585774, 585866, 585823, 585871, 585800, 585797, 585603, 585772, 548020, 584828, 536154, 585751, 585747, 585745, 585729, 585743, 585723, 585737, 585719, 133210, 548017, 548013, 548010, 436327, 548008, 548006, 436324, 531365, 548004, 548001, 547999, 578387, 585580, 585547, 585545, 585537, 585533, 585509, 585507, 585505, 585502, 584817, 584815, 579377, 484810, 484808, 585403, 363303, 585387, 585337, 585333, 585316, 585271, 585270, 585266, 585282, 484800, 420346, 585165, 420340, 585156, 584954, 23522, 465397, 578238, 584648, 584645, 584643, 584640, 584503, 584501, 577645, 584210, 537734, 584249, 420334, 420332, 500352, 584193, 420330, 420328, 622372, 622370, 584188, 622368, 584184, 584181, 584179, 576180, 366253, 366251, 584156, 500342, 584154, 584152, 500338, 584150, 500336, 500332, 500329, 500324, 500318, 500313, 584106, 500303, 500299, 500297, 581589, 500295, 500293, 500290, 500289, 584068, 500286, 581587, 500284, 500282, 500274, 581391, 581071, 517386, 578729, 555285, 555283, 420327, 419043, 419039, 420325, 578216, 578209, 575389, 578126, 576882, 420319, 349415, 576880, 420317, 420315, 420312, 577965, 562584, 530953, 577952, 577950, 420310, 577946, 577895, 420307, 420290, 434664, 577485, 577440, 567215, 577326, 522672, 577306, 577253, 514643, 221212, 389630, 575383, 420287, 420285, 420283, 415115, 536699, 536695, 366244, 536692, 366242, 415112, 481371, 366240, 548274, 568321, 568318, 568314, 420681, 420668, 448091, 420250, 415415, 419263, 418585, 389795, 389793, 417314, 378094, 132154, 378092, 366238, 415463, 240698, 389783, 393706, 411490, 393923, 410499, 410496, 393918, 410491, 362271, 362265, 362260, 409726, 215762, 240273, 107101, 407491, 407487, 228388, 240048, 107087, 107085, 407187, 406564, 228346, 406796, 228311, 228308, 228302, 228297, 406559, 228295, 228293, 228291, 406533, 228281, 239957, 406005, 405670, 405659, 215629, 405990, 405979, 405975, 10551, 228247, 228239, 404618, 188171, 405640, 404956, 188158, 366234, 188133, 188131, 228222, 228220, 402226, 174237, 402212, 228208, 404047, 403549, 404045, 404044, 106978, 106956, 106952, 106949, 320422, 302068, 132041, 366230, 399655, 397700, 399095, 399024, 399019, 398890, 398594, 323845, 323841, 205402, 392462, 318284, 131976, 308780, 397848, 106773, 397656, 397041, 397123, 397028, 392618, 106684, 131943, 106674, 197093, 131937, 395439, 395437, 106647, 388406, 388400, 106644, 131934, 106623, 113250, 395357, 395308, 113246, 239326, 394873, 394766, 113239, 394846, 215134, 394749, 394837, 394692, 388399, 394684, 23386, 23382, 394614, 394406, 391767, 394397, 394395, 394393, 394364, 394193, 394360, 394347, 131904, 302053, 131897, 131893, 394160, 131891, 394158, 394127, 394114, 393892, 113230, 392433, 113227, 393714, 393327, 393127, 392584, 392389, 389776, 391843, 391684, 389654, 389439, 389514, 390710, 390388, 390372, 106581, 390277, 239014, 389635, 389998, 239002, 389989, 278031, 106550, 278029, 106547, 389755, 389763, 389751, 389561, 368765, 389380, 388675, 388673, 389378, 389371, 387949, 359119, 387544, 387627, 383913, 383910, 387569, 383908, 383900, 387542, 387474, 161772, 387391, 359103, 308709, 308703, 364137, 385218, 385216, 379885, 303260, 382960, 384344, 383363, 383932, 383930, 383895, 383924, 383891, 378087, 383354, 336200, 383347, 336198, 378084, 382949, 382947, 161729, 381728, 23362, 377558, 381437, 381335, 381435, 381331, 381319, 378056, 377605, 377150, 366903, 374463, 375570, 375127, 373470, 366227, 373935, 373694, 371284, 373933, 373931, 373456, 366224, 372493, 373298, 372490, 372487, 371281, 371269, 356357, 370236, 368595, 368593, 368564, 308589, 308587, 366465, 366449, 366266, 330792, 366220, 330788, 366260, 366217, 366213, 365432, 365890, 36032, 226403, 226400, 226398, 23345, 363213, 362990, 363209, 363126, 359776, 359774, 359772, 226311, 362936, 226306, 361712, 359767, 361710, 361708, 207519, 361706, 268878, 361921, 361704, 361700, 237599, 237597, 358649, 358422, 361189, 361009, 361017, 360946, 360638, 358416, 360317, 359555, 359326, 359730, 350308, 359553, 252560, 358380, 252554, 354847, 357947, 357945, 357706, 357940, 213029, 357936, 213026, 213023, 357862, 207495, 357023, 213014, 356973, 213011, 213009, 213007))
Run Time: 0.074822
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3706 | |
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 | | | | | 3706 | |
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 (34754, 34347, 34095, 34084, 34041, 33916, 33847, 33833, 33815, 33797, 33763, 33636, 33583, 33511, 33230, 33226, 33216, 33193, 33169, 33155, 33141, 33124, 33087, 33050, 33010, 33004, 33001, 32986, 32965, 32913, 32863, 32856, 32819, 32759, 32702, 32686, 32683, 32677, 32676, 32662, 32659, 33368, 33367, 32630, 32628, 32619, 32617, 32595, 32589, 32584, 32559, 32554, 32556, 32546, 32530, 32508, 32507, 32481, 32465, 32431, 32388, 32387, 32384, 32383, 32365, 32340, 32335, 32315, 32313, 32311, 32307, 32273, 32245, 32210, 32205, 32168, 32164, 32161, 32157, 32154, 32151, 32152, 32148, 32150, 32147, 32149, 32143, 32137, 32134, 32133, 32131, 32141, 32128, 32127, 32126, 32125, 32087, 32086, 32085, 32084, 32083, 32073, 32071, 32070, 32059, 32049, 32048, 32040, 32029, 31941, 31932, 31922, 31900, 31891, 31875, 32056, 31862, 31850, 31821, 31812, 31807, 31781, 31724, 31714, 31713, 31712, 31682, 31681, 31644, 31609, 31603, 31569, 31536, 31987, 31523, 31511, 31411, 31396, 31878, 31388, 31368, 31945, 31350, 31315, 31944, 31291, 31958, 31288, 31260, 31235, 31234, 31232, 31227, 31962, 31213, 31193, 31943, 31169, 31961, 31157, 31155, 31957, 31140, 31956, 33666, 31116, 31115, 31093, 31089, 31960, 31062, 31060, 31059, 31955, 31044, 31033, 31023, 31021, 31013, 31000, 30994, 30878, 30692, 30690, 30627, 30598, 30590, 30589, 30535, 30503, 30457, 30375, 29657, 21674, 19656, 19623, 19540, 19503, 19263, 19235, 18725, 18716, 18617, 18338, 18324, 18300, 18140, 18088, 17884))
Run Time: 0.008665
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 209 | 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, �1
Run Time: 0.000303
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.000361
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.000559
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: 1716221659
Run Time: 0.000336
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 22 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
- XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Repository/SessionActivity.php at line 62
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*, `xf_user_User_1`.*
FROM `xf_session_activity`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1716221659)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000676
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 22 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | my_webapp.xf_session_activity.user_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivity.php at line 43
- XF\Repository\SessionActivity->getOnlineUsersList() in src/XF/Repository/SessionActivity.php at line 63
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20