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.000793
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.000264
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` = '1317')
LIMIT 1
Run Time: 0.000672
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.002048
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_1317' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.131979
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 (643950, 643945, 643837, 643833, 643830, 643814, 643805, 643802, 643799, 643493, 643437, 643419, 643403, 643402, 643370, 643359, 643338, 643323, 643281, 643280, 643253, 643194, 643157, 643156, 643139, 642997, 642992, 642974, 642969, 642946, 642922, 642901, 642873, 642841, 642840, 642837, 642836, 642826, 642804, 642794, 642748, 642747, 642746, 642721, 642673, 642615, 642614, 642611, 642609, 642603, 642533, 642532, 642513, 642508, 642504, 642492, 642491, 642468, 642467, 642457, 642455, 642453, 642450, 642296, 642293, 642269, 642250, 642248, 642240, 642238, 642219, 642164, 642163, 642145, 642144, 642127, 642126, 642124, 642120, 642118, 642115, 642066, 642062, 642051, 642040, 642038, 642037, 642017, 642016, 642015, 642002, 642001, 641999, 641990, 641989, 641982, 641981, 641963, 641962, 641951, 641941, 641938, 641936, 641932, 641880, 641879, 641878, 641877, 641856, 641855, 641853, 641840, 641793, 641792, 641777, 641776, 641754, 641742, 641739, 641735, 641734, 641732, 641699, 641680, 641656, 641631, 641620, 641611, 641610, 641609, 641579, 641535, 641486, 641452, 641438, 641436, 641434, 641423, 641403, 641397, 641394, 641358, 641287, 641285, 641263, 641239, 641238, 641208, 641207, 641198, 641195, 641192, 641190, 641189, 641187, 641186, 641175, 641174, 641173, 641134, 641132, 641115, 641107, 641104, 641096, 641092, 641056, 641053, 641048, 641042, 641010, 640846, 640844, 640830, 639744, 638311, 639631, 635412, 607497, 640795, 640596, 640793, 640791, 447747, 610527, 447744, 447742, 640764, 640763, 640783, 534948, 640752, 640751, 639307, 607496, 640689, 640713, 636246, 640687, 640711, 639305, 640729, 639302, 630363, 640610, 447717, 630360, 640675, 640671, 640706, 640704, 640606, 640667, 640650, 640453, 640451, 633977, 633975, 633964, 633962, 633960, 633958, 633955, 640615, 635410, 635405, 447660, 639728, 635403, 640553, 640534, 640549, 640532, 635401, 640545, 640543, 623579, 640538, 640526, 639773, 623577, 639712, 534932, 635392, 640521, 640519, 623575, 633696, 623573, 640517, 303494, 633694, 640488, 639630, 639628, 639625, 639623, 639621, 640486, 639619, 640481, 640479, 640477, 640473, 640471, 640469, 623571, 630007, 639617, 639615, 623569, 623566, 539611, 623562, 623560, 623558, 640441, 447571, 639345, 637208, 639612, 601278, 637206, 637204, 627576, 627571, 627569, 640257, 420451, 640255, 627555, 420447, 447544, 627553, 420445, 420443, 640212, 640206, 635386, 640204, 640280, 640227, 640273, 632845, 640242, 632843, 640235, 637078, 640200, 632840, 640197, 640194, 638918, 637055, 637902, 639771, 640143, 640141, 447516, 640139, 453831, 640134, 640060, 453829, 597995, 639106, 580740, 247288, 639508, 637595, 447505, 639506, 639690, 536596, 639484, 447499, 639503, 447497, 639501, 638148, 447487, 447484, 447482, 539594, 447480, 447465, 539588, 447463, 447454, 639204, 303492, 609688, 303490, 447452, 639298, 640018, 639296, 609686, 447451, 639899, 639294, 640015, 624362, 639290, 601261, 534909, 639681, 447396, 601259, 447393, 627552, 447382, 597989, 597987, 597985, 638591, 638589, 638587, 639879, 447379, 639883, 639288, 534904, 639285, 639876, 639769, 639767, 639751, 420441, 447373, 447369, 447367, 447365, 639749, 639652, 639650, 420439, 639648, 639646, 639669, 447363, 420437, 639661, 539573, 639642, 534901, 628808, 639633, 627548, 627546, 539568, 627544, 447355, 491357, 639580, 491355, 639344, 447349, 447347, 639342, 447345, 447343, 447340, 447338, 639366, 628077, 639364, 447330, 534899, 639362, 639498, 633402, 639527, 639401, 636080, 636078, 637203, 636076, 639399, 447313, 420435, 639397, 639395, 420432, 420430, 639393, 636069, 639391, 639388, 639386, 639384, 389282, 447295, 639382, 639379, 636067, 637443, 637441, 636065, 639360, 639358, 639120, 637440, 612969, 637437, 637435, 636061, 639356, 612967, 638583, 637433, 639354, 639352, 637431, 639350, 639348, 372060, 639338, 639244, 634508, 638860, 639223, 548416, 639221, 548413, 548411, 638579, 631996, 601254, 639159, 447205, 639200, 639195, 639152, 447175, 447173, 447171, 639150, 447169, 626150, 634935, 638532, 447134, 447117, 414300, 628656, 552893, 638855, 583942, 638853, 414296, 447101, 414294, 638847, 638841, 638729, 638700, 638833, 414292, 638838, 637415, 637412, 552891, 638724, 552887, 638720, 638717, 534866, 636621, 638650, 638022, 638648, 638638, 629994, 447087, 638577, 447085, 447083, 638498, 606810, 493681, 534856, 398429, 601242, 623554, 638439, 572553, 623552, 638356, 638354, 638287, 634381, 534833, 446989, 612898, 612896, 633720, 633718, 635622, 583890, 446977, 638129, 638127, 638125, 638123, 446975, 638121, 638085, 446954, 610171, 638095, 629681, 631001, 636895, 638080, 636891, 638078, 636889, 638051, 534818, 446945, 638020, 446943, 606030, 638008, 638003, 638030, 606028, 638027, 613258, 637720, 637953, 637947, 629984, 637991, 420424, 637882, 637942, 637929, 631000, 635036, 637927, 580676, 631995, 534804, 565486, 565484, 615748, 601234, 612881, 565481, 637889, 446916, 615746, 615743, 615741, 565467, 565464, 612359, 632137, 637729, 446896, 446893, 637395, 637519, 534795, 637616, 637706, 637691, 637689, 615737, 158104, 615735, 615732, 606027, 446871, 616276, 606024, 446868, 637569, 446862, 446860, 446858, 637560, 628168, 635619, 601226, 398427, 637459, 637510, 637448, 637394, 610331, 629307, 637393, 610329, 628654, 392239, 610327, 628652, 637409, 637405, 612852, 612850, 612848, 4736, 637401, 637399, 632194, 637227, 637391, 570301, 637362, 4734, 637341, 637334, 446798, 446795, 637316, 637313, 637320, 637309, 634168, 446785, 398426, 446781, 637293, 637291, 637288, 446768, 630999, 446764, 534768, 580663, 637157, 201194, 637232, 637225, 637217, 637215, 637199, 637150, 446760, 607955, 446756, 637143, 446754, 520512, 623550, 623548, 596358, 623546, 534753, 479703, 636989, 596346, 636886, 636884, 636882, 636880, 623544, 607947, 636784, 636652, 453818, 636615, 636613, 626747, 626745, 636482, 636479, 635667, 636449, 636439, 636413, 636411, 613165, 636424, 605912, 636421, 636400, 630245, 636417, 635998, 636395, 636403, 630326, 636398, 446630, 630324, 634470, 636323, 636321, 636319, 446616, 610316, 636314, 636309, 596274, 630026, 636306, 446611, 612379, 636088, 636291, 201187, 446600, 636214, 636289, 636210, 636208, 634342, 606398, 636206, 636204, 539566, 636202, 453816, 446577, 636200, 446569, 635750, 446557, 446553, 534713, 636162, 636160, 247227, 636166, 636158, 636156, 446511, 446506, 636091, 635614, 601790, 596258, 601788, 635990, 247209, 247207, 629966, 580620, 635973, 580617, 534698, 635985, 635937, 635971, 635932, 635930, 635883, 635378, 635967, 635925, 630998, 398425, 629431, 635898, 632950, 635864, 446450, 635843, 635683, 607216, 635625, 635681, 635756, 635679, 635362, 635618, 535650, 635752, 635728, 446438, 635229, 628075, 635227, 635092, 635726, 632268, 635224, 633265, 635719, 630226, 630223, 635498, 534679, 635496, 446423, 201185, 605938, 605936, 635359, 414288, 635357, 635355, 614899, 614897, 632948, 635494, 623729, 635490, 635483, 446411, 635479, 613974, 613972, 635468, 613969, 632265, 635465, 635477, 635460, 635474, 635472, 635439, 623728, 623726, 635349, 623724, 635435, 635374, 635353, 635320, 635064, 635085, 634242, 446371, 634240, 446368, 628444, 628442, 635007, 633689, 635069, 635062, 389279, 634931, 446350, 634778, 118438, 634808, 629954, 446344, 446341, 602833, 590141, 623723, 602831, 634716, 634714, 634711, 634705, 634702, 633698, 634668, 633435, 297052, 297050, 601165, 446306, 630853, 534631, 630851, 630850, 634504, 632578, 631041, 632209, 446230, 446228, 633687, 534604, 633685, 633680, 601146, 633674, 633604, 633668, 593667, 633662, 593663, 601143, 596147, 633608, 592969, 446181, 633513, 633356, 633354, 629923, 446169, 633028, 596125, 630410, 596122, 610284, 633351, 596109, 633319, 633286, 633177, 633305, 633280, 633254, 596107, 633252, 628483, 446155, 596105, 633237, 601135, 446145, 446142, 632393, 609966, 609964, 630096, 446128, 446126, 446124, 446119, 446116, 534549, 601134, 628632, 633069, 631913, 596100, 596098, 446111, 629598, 629596, 631039, 7725, 608485, 632979, 631014, 446102, 632838, 608481, 608479, 632969, 632966, 632935, 632836, 608474, 632834, 631907, 632963, 632901, 632913, 632898, 446030, 446008, 446006, 446005, 446003, 632831, 632826, 632813, 632811, 632808, 602720, 632716, 534521, 445992, 632669, 630803, 632703, 609959, 629907, 629905, 583620, 583618, 583616, 583614, 632659, 629451, 629449, 632657, 201166, 201164, 445965, 445951, 632585, 632377, 632374, 632372, 632369, 632416, 632401, 632296, 632149, 445930, 632120, 632117, 625890, 631037, 597119, 630991, 632072, 632037, 630989, 445897, 630873, 630871, 630869, 630985, 630867, 631998, 631876, 631896, 445852, 445822, 631276, 630982, 630980, 445817, 630978, 453804, 453801, 631860, 630975, 631858, 631855, 631852, 631799, 631821, 631778, 631815, 631764, 631809, 631794, 445801, 631757, 445798, 625397, 110760, 630800, 110759, 110757, 445780, 628629, 628627, 631397, 628624, 453794, 631667, 631658, 631656, 628622, 445732, 445730, 445724, 445721, 445718, 631324, 631322, 395595, 445707, 627102, 631315, 631312, 445700, 631309, 631031, 445677, 445665, 445661, 631267, 626476, 445659, 445656, 631028, 631263, 631261, 445653, 580553, 580550, 580547, 580543, 67912, 580538, 580536, 630669, 67910, 602830, 67908, 630884, 630515, 602829, 534459, 629430, 629335, 629428, 631095, 627166, 631074, 631072, 445647, 631026, 445628, 445622, 631022, 445620, 631020, 445609, 630883, 445605, 445600, 630974, 445598, 630972, 607471, 630408, 630893, 627160, 627157, 627154, 445593, 630970, 627152, 420423, 627145, 630890, 627143, 627139, 627137, 627135, 420421, 607462, 630934, 609943, 613256, 609939, 445587, 630865, 445585, 630798, 630882, 534446, 630841, 445556, 630829, 630612, 630827, 630610, 614931, 580825, 629302, 11710, 445521, 601787, 630576, 597713, 629680, 629678, 569051, 630422, 630418, 628074, 630416, 627217, 628071, 628070, 628067, 534417, 630322, 534411, 629427, 630103, 629677, 420416, 420414, 629594, 623812, 629245, 629514, 629446, 629510, 629444, 629508, 629456, 624398, 599347, 624395, 596038, 623828, 629426, 536389, 629405, 624158, 629243, 629240, 629238, 624156, 629299, 629349, 629297, 629281, 376738, 629235, 376736, 629233, 629231, 629255, 629229, 398419, 629227, 629218, 23527, 629215, 23525, 445164, 601786, 445162, 398414, 445159, 445156, 445154, 628176, 453771, 534308, 628156, 627678, 627258, 445148, 627676, 445146, 627673, 627782, 627671, 626080, 628062, 627855, 445142, 445140, 628044, 627852, 534307, 628016, 613566, 628014, 628003, 628012, 628010, 628001, 627950, 609919, 627947, 627990, 596003, 534305, 609917, 627631, 627805, 445132, 595992, 595988, 534303, 445115, 627093, 601785, 627751, 627749, 627747, 627745, 627743, 601900, 627714, 627666, 627686, 627682, 627630, 534301, 445060, 627628, 627626, 599339, 445058, 625164, 599334, 445037, 625163, 534299, 583445, 445032, 627584, 625161, 627538, 625159, 625157, 627447, 613565, 627445, 586338, 445026, 626217, 627403, 627400, 627398, 626215, 627396, 445018, 604419, 615539, 627394, 624293, 445012, 624291, 627392, 627352, 627366, 607215, 627350, 627347, 627213, 627338, 445000, 627333, 627278, 493678, 627052, 627274, 610170, 627318, 444996, 627264, 627212, 574638, 574634, 414275, 613564, 444979, 414273, 580448, 444967, 583424, 627079, 627077, 627075, 627067, 627045, 627032, 627030, 444953, 444951, 627008, 627017, 627012, 602825, 626965, 444946, 627006, 626989, 444940, 626960, 626859, 161176, 626855, 609914, 601784, 625840, 607943, 444934, 444931, 607940, 607936, 607934, 444926, 603409, 444911, 626785, 626776, 626733, 444883, 595962, 626631, 626684, 626619, 626617, 444881, 626574, 623998, 613563, 623996, 444876, 609911, 615793, 626503, 626475, 626464, 609905, 608690, 626431, 608688, 608686, 607929, 589293, 626037, 607392, 607925, 444850, 626380, 444847, 534273, 444844, 534271, 444835, 444830, 444804, 444801, 444799, 607388, 444796, 626316, 201066, 626033, 626259, 626031, 595945, 626268, 626252, 626250, 626248, 626230, 444740, 534255, 607920, 626143, 444730, 246970, 444724, 625716, 444688, 444678, 625838, 625824, 444627, 609116, 625708, 580413, 595940, 595937, 444414, 444410, 625274, 616299, 444398, 534184, 534181, 444380, 623938, 625293, 625228, 625203, 580388, 444339, 444333, 444330, 625251, 625201, 624353, 444271, 624415, 606285, 624361, 624351, 624349, 444264, 624377, 616296, 444246, 444244, 624364, 624343, 444233, 624341, 624359, 624347, 624345, 613025, 201053, 444179, 444177, 444174, 609897, 616293, 614294, 534098, 624305, 624303, 534096, 624289, 602718, 161174, 534087, 534077, 608465, 444163, 608676, 608674, 161172, 246930, 444160, 534073, 444158, 161170, 444156, 444134, 161167, 444125, 246927, 534060, 412575, 444116, 444114, 615781, 444068, 444061, 595922, 595919, 443997, 443989, 443932, 443921, 443897, 623741, 443878, 595889, 443868, 443831, 7724, 443818, 443771, 443769, 612965, 623525, 414271, 623510, 623508, 533934, 443754, 443750, 443747, 615729, 602355, 616336, 601783, 609885, 601781, 616274, 606969, 443695, 443693, 533898, 609881, 443691, 443664, 443659, 443624, 615822, 616015, 533863, 443576, 443568, 613022, 607214, 613016, 533846, 246912, 613562, 615841, 613581, 246888, 615646, 609869, 609867, 601779, 443362, 602353, 615605, 443339, 443314, 443224, 611123, 614929, 614927, 443143, 614917, 614914, 614912, 607851, 613561, 613559, 614909, 612839, 612963, 612961, 612959, 614889, 580319, 613927, 613925, 613923, 442993, 614828, 580317, 457965, 442987, 442967, 614809, 580314, 613921, 580309, 580308, 442825, 442822, 442818, 613914, 613910, 533719, 442782, 613812, 442777, 442743, 442737, 613780, 613909, 442696, 595861, 613963, 613907, 613558, 442682, 610869, 613725, 442671, 442668, 613683, 412571, 613681, 595850, 442648, 595847, 389268, 595843, 442611, 613591, 609851, 442601, 246813, 613557, 613002, 612997, 442598, 613553, 613547, 613545, 613542, 613408, 613483, 613398, 613395, 601778, 607501, 601776, 533637, 633427, 609846, 613299, 442503, 420411, 609838, 609834, 612294, 442480, 613229, 612759, 613215, 613176, 442472, 613227, 442470, 613187, 613196, 612993, 442454, 613155, 613085, 613172, 442447, 613153, 613063, 613142, 580239, 442444, 604877, 442440, 613068, 612991, 389264, 389262, 613005, 414268, 414266, 442407, 609823, 595827, 607364, 610814, 607361, 442348, 609820, 442346, 533526, 601011, 442335, 246792, 594541, 603134, 612977, 612957, 612953, 612952, 246789, 612479, 609817, 612939, 612475, 612473, 612933, 612461, 442280, 442275, 442271, 442262, 611272, 442220, 442219, 442214, 442207, 442205, 442198, 592135, 612606, 612604, 442191, 442187, 609815, 611470, 609812, 442180, 442178, 442175, 442171, 389259, 442168, 612702, 612823, 612724, 612820, 453755, 533488, 453753, 612763, 609800, 442148, 583061, 603129, 632782, 612742, 612740, 612738, 533473, 442118, 612736, 612627, 610523, 595824, 612624, 533470, 612663, 612630, 442095, 442091, 442089, 533458, 608672, 595823, 442085, 612076, 442076, 442074, 595821, 533451, 608909, 442047, 442040, 611933, 594539, 612054, 606282, 442001, 612441, 612485, 595820, 612483, 612439, 612454, 600998, 612052, 533433, 612432, 441993, 612430, 595817, 595814, 595812, 595809, 441990, 595806, 595804, 612050, 441964, 544203, 592362, 441962, 612366, 595801, 595799, 612164, 612293, 612159, 612291, 612157, 611217, 612075, 612073, 612071, 612136, 612134, 612132, 441945, 612127, 612068, 441942, 533398, 612047, 611620, 612066, 441932, 611618, 612040, 612063, 612061, 612058, 441926, 441923, 441919, 611999, 595797, 611992, 595794, 441894, 611893, 441885, 611891, 611889, 611927, 611925, 421776, 441835, 611837, 441822, 441817, 533343, 441811, 533338, 441801, 611656, 611555, 611624, 611615, 611608, 207579, 611604, 207570, 207568, 441792, 572532, 441781, 603047, 611214, 611211, 611208, 611569, 611546, 612701, 611544, 611563, 533314, 611541, 441745, 611539, 611200, 611198, 611195, 441734, 611311, 611459, 207567, 611482, 610854, 611479, 441724, 441708, 441681, 441679, 533288, 611085, 611081, 140330, 611079, 611240, 441655, 610955, 611194, 412563, 609791, 595774, 595772, 595761, 610952, 610950, 595758, 441530, 610883, 610864, 609782, 441490, 610857, 200977, 200975, 441488, 595745, 595742, 595739, 449871, 449869, 610719, 470878, 441412, 595721, 599322, 610370, 599319, 611718, 610190, 611708, 610188, 610184, 610169, 609192, 441356, 610156, 441347, 610044, 610053, 302998, 610042, 302996, 314436, 533066, 441254, 398412, 608828, 608620, 608658, 608813, 608246, 608767, 608671, 608669, 600981, 533042, 572531, 533040, 608618, 608616, 533037, 608684, 608644, 608642, 200965, 608613, 592967, 608611, 608640, 608648, 600980, 608609, 441232, 441149, 607968, 133319, 607801, 607636, 607213, 607346, 200956, 607632, 607708, 607750, 606319, 607337, 607335, 607589, 615528, 441118, 607539, 607537, 607508, 441091, 606276, 607326, 607305, 592211, 188930, 603458, 606017, 441046, 441038, 607225, 606015, 606013, 607139, 606975, 606865, 597418, 595657, 597416, 597414, 606833, 606858, 440970, 606823, 440968, 440966, 606007, 605934, 606819, 606004, 440958, 595644, 606002, 606816, 440955, 440953, 508166, 440942, 440936, 440934, 606733, 440932, 440926, 606731, 606729, 606678, 606685, 440924, 440921, 440918, 606588, 606632, 606578, 440903, 606576, 349617, 440889, 606550, 414212, 595628, 606461, 606458, 606450, 606447, 606420, 606418, 606413, 606273, 606288, 440856, 440853, 440851, 594995, 602717, 597231, 606142, 599126, 606135, 606132, 606121, 349616, 597223, 605961, 605955, 605952, 602716, 605982, 602714, 600045, 605445, 200928, 440826, 605910, 605964, 605883, 133309, 600041, 605880, 605926, 605923, 133306, 605854, 440800, 598091, 605313, 605846, 440781, 605786, 605710, 605530, 605782, 605704, 605748, 440768, 605746, 440766, 440763, 602823, 440751, 605719, 605715, 419512, 605701, 539563, 604070, 208383, 200924, 440742, 600458, 600455, 605568, 600449, 440740, 440737, 440730, 605509, 605554, 440727, 440721, 440718, 440711, 200918, 605491, 602822, 440695, 605221, 605216, 440693, 440689, 407979, 532849, 7723, 605115, 440684, 440679, 440677, 440665, 597410, 605049, 597407, 605061, 604041, 605047, 605058, 599316, 600968, 597403, 440657, 440653, 602821, 604401, 602713, 440647, 597401, 605013, 590169, 604267, 605040, 440636, 394080, 200914, 508165, 604336, 440625, 508162, 605007, 604454, 604967, 604452, 440612, 440611, 322578, 440610, 440609, 440607, 604450, 440605, 602711, 600439, 604964, 602709, 604962, 440602, 440600, 440597, 604926, 604891, 592963, 109233, 414206, 604811, 440571, 604776, 440531, 604449, 440523, 604635, 604448, 440479, 440477, 440466, 604284, 604282, 7722, 604193, 440461, 604190, 597195, 604094, 532784, 440449, 604092, 603029, 440447, 440445, 604025, 393263, 602708, 440439, 603388, 539559, 603850, 603440, 603383, 603381, 603045, 398411, 603501, 603150, 601773, 603063, 332855, 603351, 603321, 603317, 440411, 603313, 398409, 398407, 440409, 602920, 603290, 603287, 599307, 600937, 532736, 440394, 603053, 593627, 440368, 601772, 602977, 599084, 599080, 602936, 600682, 414203, 602841, 602839, 414201, 599075, 414199, 602894, 602812, 414197, 602807, 602820, 602838, 602836, 602880, 602818, 602805, 599304, 602707, 602705, 602779, 602777, 440342, 602703, 440340, 600665, 602701, 325899, 602646, 601771, 602343, 601769, 602382, 414192, 414190, 602306, 602200, 601597, 602189, 602160, 440321, 407976, 602123, 420405, 601767, 602023, 601578, 584126, 599300, 600353, 601938, 601922, 440265, 440262, 601862, 601860, 601765, 600328, 381108, 600901, 601639, 601714, 601746, 601764, 601641, 601635, 601470, 601468, 601608, 601606, 601466, 601560, 601603, 601464, 440255, 601484, 440253, 596804, 601481, 600896, 601461, 440248, 440244, 440242, 440240, 601496, 601410, 601488, 601458, 600892, 601431, 601362, 508161, 440230, 440221, 600004, 508160, 440216, 601383, 508158, 508156, 599911, 600889, 440212, 601358, 601355, 601344, 77209, 77207, 600830, 207566, 601310, 601288, 600841, 207563, 600875, 600883, 600869, 508155, 599296, 600858, 600768, 600825, 600821, 440192, 600595, 599906, 600661, 600681, 420403, 600657, 600593, 420400, 600589, 600587, 600585, 600614, 600583, 600579, 600611, 508152, 599555, 499823, 508150, 600606, 600604, 440176, 440173, 508148, 598388, 600550, 598386, 599646, 600486, 599977, 600537, 600529, 440168, 440165, 599292, 598556, 600053, 600198, 600196, 599875, 600003, 600002, 599873, 440108, 599990, 594177, 592682, 324381, 200894, 440086, 599290, 599288, 599553, 200891, 568995, 568993, 440070, 532602, 599548, 439990, 439984, 599276, 414188, 414186, 597977, 398406, 569050, 599152, 568990, 599149, 599138, 439932, 599142, 439921, 439919, 569048, 569046, 532589, 599106, 599066, 598929, 598926, 598899, 598939, 598924, 598922, 200882, 597194, 598917, 593737, 598842, 580165, 598870, 598875, 598839, 598837, 598835, 598852, 598554, 598827, 58702, 580163, 591777, 591775, 584665, 598812, 598810, 598804, 598176, 573984, 439854, 598175, 598516, 598512, 598433, 598430, 23523, 439809, 598382, 598377, 587478, 439799, 439797, 539556, 598174, 598148, 554297, 573983, 573981, 474799, 598220, 598173, 598171, 554744, 598169, 598181, 598167, 598165, 598179, 598163, 598161, 598159, 598118, 598157, 133296, 133294, 598147, 598146, 598153, 598143, 598134, 598122, 596887, 482152, 482150, 439703, 482146, 482140, 482138, 482136, 482134, 597815, 597808, 572526, 593958, 572520, 597710, 439678, 596885, 596883, 596881, 596879, 597393, 597709, 597391, 594195, 594193, 594191, 439605, 439575, 439568, 439566, 597193, 207561, 207559, 133292, 597432, 597389, 597430, 597483, 597428, 439547, 597342, 207557, 597384, 439544, 595315, 439541, 349230, 597219, 589049, 439528, 414185, 597191, 596878, 532528, 596876, 594532, 414179, 414175, 596893, 420397, 596875, 596873, 439425, 439417, 439408, 594353, 594349, 439402, 590061, 596640, 596638, 596636, 133276, 595072, 594928, 594186, 439285, 14205, 14203, 593038, 133257, 593034, 133253, 439044, 592805, 133248, 580112, 592930, 580110, 592928, 592925, 580106, 439031, 439023, 439021, 592360, 592018, 438900, 592016, 592013, 438898, 591919, 438888, 591915, 438878, 591118, 591627, 200850, 589331, 554273, 546804, 546802, 546800, 438844, 438842, 200843, 438832, 200840, 438806, 591347, 438796, 591346, 591344, 133246, 99312, 133244, 532170, 586215, 438746, 591299, 420381, 591297, 591295, 200837, 200835, 438698, 546796, 546794, 546791, 546790, 546787, 200833, 438579, 438532, 438491, 438488, 590372, 549904, 549902, 586328, 586326, 586324, 200822, 200821, 569920, 569918, 569916, 569914, 584554, 387868, 590166, 569912, 589462, 420372, 570300, 589606, 420365, 420363, 590177, 563249, 420361, 398402, 398400, 392790, 588618, 588616, 563247, 563245, 420359, 14202, 589839, 587460, 587458, 589605, 472247, 589327, 570878, 570877, 392785, 586205, 589046, 587542, 588897, 587564, 587681, 588642, 586680, 586677, 569910, 586094, 384258, 585639, 436320, 435501, 435469, 578332, 570866, 578568, 569353, 578284, 578515, 56601, 578282, 514707, 514701, 235070, 570861, 569982, 578280, 570852, 207556, 570299, 578278, 578276, 578274, 509169, 509168, 578205, 570851, 420265, 569316, 571680, 570828, 570823, 569207, 571420, 569045, 432917, 571239, 200307, 398465, 571098, 562760, 570925, 164628, 432864, 420262, 164616, 570816, 569288, 569285, 450965, 569187, 432429, 164597, 432409, 558773, 392770, 564356, 567348, 567345, 567343, 564831, 558883, 432255, 564823, 564819, 565431, 565525, 567274, 564914, 432238, 133112, 306576, 82890, 566878, 58690, 77201, 355914, 77199, 514973, 368397, 514971, 77197, 565931, 537711, 537710, 432194, 453150, 367546, 77195, 321233, 412329, 412321, 412319, 412317, 303489, 432070, 133103, 303487, 561147, 564805, 381826, 564903, 564902, 564900, 564922, 564859, 303485, 537702, 564099, 563679, 392853, 538942, 563242, 563239, 413329, 413327, 560474, 551051, 560471, 518721, 23498, 560611, 537693, 559330, 333819, 538935, 558383, 557574, 384238, 556554, 557138, 547397, 555269, 556195, 547450, 555934, 547394, 547393, 552872, 552870, 554649, 303417, 303411, 303404, 303400, 303375, 539316, 303369, 303366, 398155, 550754, 539312, 547431, 539307, 539306, 547383, 552025, 547381, 551985, 491064, 333800, 398151, 132995, 549803, 288167, 537188, 545402, 550638, 550985, 551019, 550614, 549899, 537186, 537183, 537179, 529008, 550046, 430457, 549210, 538929, 538927, 546026, 547544, 547372, 547371, 542070, 398138, 546122, 398126, 544214, 544212, 544990, 543479, 528876, 488551, 544408, 543791, 132933, 207550, 544207, 518838, 528856, 544258, 381621, 321182, 544220, 516780, 542128, 544045, 543779, 537662, 542348, 541130, 412097, 412092, 492552, 539897, 539894, 194627, 541127, 110440, 429137, 539762, 511590, 462609, 511588, 539759, 429114, 539749, 539638, 321173, 381616, 482921, 537226, 384232, 538922, 132887, 538919, 466831, 537619, 514534, 355899, 514532, 428918, 333751, 501543, 536603, 536601, 535765, 321164, 511586, 492115, 535302, 199939, 504963, 199935, 199931, 528039, 528022, 518742, 528018, 303342, 514890, 321153, 412035, 112042, 511583, 520509, 492111, 412028, 318361, 378912, 303317, 462606, 508144, 508139, 509808, 411917, 508198, 508129, 112032, 504087, 504085, 333674, 503097, 502150, 207542, 207539, 306416, 306414, 318357, 458215, 368188, 366408, 493173, 366406, 493170, 366404, 366401, 303310, 378905, 318353, 318347, 318344, 487477, 466820, 488529, 488726, 487487, 470045, 485123, 484331, 480649, 483299, 483267, 483237, 318336, 199054, 481979, 480646, 480475, 479247, 479241, 474850, 473009, 475402, 477719, 198961, 368101, 475411, 303293, 198865, 384194, 473271, 472724, 419742, 198834, 421241, 470779, 470773, 470008, 469290, 470005, 469283, 318326, 339586, 318325, 198608, 421239, 198581, 198580, 465870, 325819, 465596, 465589, 465585, 465575, 424146, 462545, 462536, 368350, 198444, 424007, 424004, 459191, 458998, 411665, 456984, 333577, 198167, 452736, 406582, 406579, 406577, 451208, 451196, 448810, 448800, 320615, 449803, 384183, 378979, 384181, 318306, 318304, 318301, 414688, 411343, 343441, 369407, 411020, 197717, 333528, 333523, 333521, 333518, 407323, 355733, 407825, 368062, 407320, 406599, 406595, 368057, 406592, 393020, 407423, 338791, 407313, 393451, 406236, 404122, 404120, 393018, 197521, 405370, 405358, 405088, 404118, 404140, 404137, 404272, 404005, 333488, 403909, 403995, 197429, 197413, 197405, 197403, 403021, 197390, 397801, 403106, 392722, 403044, 130230, 197375, 197367, 384178, 330048, 228184, 400793, 384176, 400789, 239702, 400217, 400782, 396016, 197319, 197318, 197317, 400773, 399688, 131995, 397047, 400140, 399025, 274575, 399857, 384167, 386458, 399536, 393009, 313847, 398045, 197298, 398036, 333459, 399577, 377687, 398314, 197281, 396834, 384165, 384163, 197262, 398899, 393447, 393007, 393005, 393001, 397736, 197236, 320390, 398437, 320382, 394512, 384159, 384156, 395727, 197176, 197168, 384152, 384150, 395808, 197125, 395796, 392642, 197080, 318273, 394874, 393975, 393971, 394508, 394505, 303272, 393987, 393945, 393420, 393415, 393940, 393965, 393695, 393408, 393403, 393401, 318272, 384141, 384138, 384136, 378969, 384134, 392794, 392684, 392680, 378967, 303266, 375765, 375763, 391691, 386353, 359099, 303258, 303245, 303242, 196841, 377437, 382529, 303238, 351779, 351777, 303235, 382198, 368048, 303233, 254859, 279086, 320277, 98839, 303231, 303229, 320275, 303227, 303225, 254857, 368046, 320273, 382084, 381317, 98804, 374987, 374985, 350012, 358325, 377600, 347876, 377795, 377598, 374966, 375105, 333409, 374959, 374952, 347859, 347857, 347855, 347853, 368026, 370476, 238026, 333386, 370151, 369602, 367766, 367762, 303220, 303218, 303216, 369361, 367760, 368480, 368478, 368012, 368010, 303187, 303185, 303160, 303158, 303156, 303147, 207526, 361713, 361711, 361709, 361702, 303143, 361697, 347821, 344249, 344246, 335789, 344244, 344241, 196359, 196357, 303140, 303138, 303136, 303134, 348843, 351349, 303132, 348841, 351347, 213276, 131778, 303130, 196352, 347817, 357091, 303126, 303120, 360198, 303118, 303115, 303113, 303110, 303108, 303105, 350010, 303075, 344928, 310276, 310274, 338775, 338771, 338765, 338759, 338757, 310173, 295962, 295960, 295958, 328870, 303040, 343264, 339569, 339566, 340122, 340121, 340119, 340116, 340114, 337391, 338751, 71464, 58592, 47119, 46352, 21914))
Run Time: 0.160586
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3510 | |
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 | | | | | 3510 | |
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 (35296, 35236, 35223, 35216, 35179, 35157, 35129, 35089, 35063, 35053, 35046, 34953, 34963, 34996, 33605, 34960, 34957, 34941, 34938, 34933, 34885, 34883, 34865, 34858, 34829, 34821, 34778, 34777, 34766, 34720, 34730, 34747, 34714, 34723, 34719, 34699, 34664, 34591, 34579, 34577, 34373, 34489, 34481, 34418, 33933, 34457, 34443, 34415, 34394, 34358, 34282, 34249, 34236, 34206, 34198, 34067, 34191, 34185, 34119, 34094, 34075, 34069, 34015, 34013, 34000, 33998, 33566, 33986, 33972, 33981, 33978, 33952, 33943, 33930, 33920, 33917, 33911, 33830, 33823, 33820, 33807, 33663, 33657, 33599, 33624, 33618, 32344, 33612, 33611, 33595, 33604, 33589, 33572, 33552, 33553, 33547, 33514, 33460, 33397, 33358, 33241, 32990, 33031, 33011, 32992, 32934, 32988, 32503, 32969, 32930, 32894, 32891, 32887, 32886, 32883, 32881, 32872, 32862, 32861, 32851, 32827, 32825, 32808, 32803, 32802, 32776, 32726, 32614, 32594, 32487, 32501, 32495, 32493, 32349, 32360, 32401, 32399, 32343, 32331, 32333, 32329, 32196, 32013, 32012, 32118, 32119, 32120, 32121, 32122, 32000, 31908, 31903, 31834, 31828, 31817, 31814, 31775, 31760, 31669, 31642, 31641, 31623, 31567, 31564, 31520, 31468, 31429, 31121, 31041, 31040, 30856, 30406, 29156, 27910, 20071, 19915, 19825, 17089, 16831, 4222))
Run Time: 0.009253
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 180 | 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 (643950, 643945, 643837, 643833, 643830, 643814, 643805, 643802, 643799, 643493, 643437, 643419, 643403, 643402, 643370, 643359, 643338, 643323, 643281, 643280, 643253, 643194, 643157, 643156, 643139, 642997, 642992, 642974, 642969, 642946, 642922, 642901, 642873, 642841, 642840, 642837, 642836, 642826, 642804, 642794, 642748, 642747, 642746, 642721, 642673, 642615, 642614, 642611, 642609, 642603, 642533, 642532, 642513, 642508, 642504, 642492, 642491, 642468, 642467, 642457, 642455, 642453, 642450, 642296, 642293, 642269, 642250, 642248, 642240, 642238, 642219, 642164, 642163, 642145, 642144, 642127, 642126, 642124, 642120, 642118, 642115, 642066, 642062, 642051, 642040, 642038, 642037, 642017, 642016, 642015, 642002, 642001, 641999, 641990, 641989, 641982, 641981, 641963, 641962, 641951, 641941, 641938, 641936, 641932, 641880, 641879, 641878, 641877, 641856, 641855, 641853, 641840, 641793, 641792, 641777, 641776, 641754, 641742, 641739, 641735, 641734, 641732, 641699, 641680, 641656, 641631, 641620, 641611, 641610, 641609, 641579, 641535, 641486, 641452, 641438, 641436, 641434, 641423, 641403, 641397, 641394, 641358, 641287, 641285, 641263, 641239, 641238, 641208, 641207, 641198, 641195, 641192, 641190, 641189, 641187, 641186, 641175, 641174, 641173, 641134, 641132, 641115, 641107, 641104, 641096, 641092, 641056, 641053, 641048, 641042, 641010, 640846, 640844, 640830, 639744, 638311, 639631, 635412, 607497, 640795, 640596, 640793, 640791, 447747, 610527, 447744, 447742, 640764, 640763, 640783, 534948, 640752, 640751, 639307, 607496, 640689, 640713, 636246, 640687, 640711, 639305, 640729, 639302, 630363, 640610, 447717, 630360, 640675, 640671, 640706, 640704, 640606, 640667, 640650, 640453, 640451, 633977, 633975, 633964, 633962, 633960, 633958, 633955, 640615, 635410, 635405, 447660, 639728, 635403, 640553, 640534, 640549, 640532, 635401, 640545, 640543, 623579, 640538, 640526, 639773, 623577, 639712, 534932, 635392, 640521, 640519, 623575, 633696, 623573, 640517, 303494, 633694, 640488, 639630, 639628, 639625, 639623, 639621, 640486, 639619, 640481, 640479, 640477, 640473, 640471, 640469, 623571, 630007, 639617, 639615, 623569, 623566, 539611, 623562, 623560, 623558, 640441, 447571, 639345, 637208, 639612, 601278, 637206, 637204, 627576, 627571, 627569, 640257, 420451, 640255, 627555, 420447, 447544, 627553, 420445, 420443, 640212, 640206, 635386, 640204, 640280, 640227, 640273, 632845, 640242, 632843, 640235, 637078, 640200, 632840, 640197, 640194, 638918, 637055, 637902, 639771, 640143, 640141, 447516, 640139, 453831, 640134, 640060, 453829, 597995, 639106, 580740, 247288, 639508, 637595, 447505, 639506, 639690, 536596, 639484, 447499, 639503, 447497, 639501, 638148, 447487, 447484, 447482, 539594, 447480, 447465, 539588, 447463, 447454, 639204, 303492, 609688, 303490, 447452, 639298, 640018, 639296, 609686, 447451, 639899, 639294, 640015, 624362, 639290, 601261, 534909, 639681, 447396, 601259, 447393, 627552, 447382, 597989, 597987, 597985, 638591, 638589, 638587, 639879, 447379, 639883, 639288, 534904, 639285, 639876, 639769, 639767, 639751, 420441, 447373, 447369, 447367, 447365, 639749, 639652, 639650, 420439, 639648, 639646, 639669, 447363, 420437, 639661, 539573, 639642, 534901, 628808, 639633, 627548, 627546, 539568, 627544, 447355, 491357, 639580, 491355, 639344, 447349, 447347, 639342, 447345, 447343, 447340, 447338, 639366, 628077, 639364, 447330, 534899, 639362, 639498, 633402, 639527, 639401, 636080, 636078, 637203, 636076, 639399, 447313, 420435, 639397, 639395, 420432, 420430, 639393, 636069, 639391, 639388, 639386, 639384, 389282, 447295, 639382, 639379, 636067, 637443, 637441, 636065, 639360, 639358, 639120, 637440, 612969, 637437, 637435, 636061, 639356, 612967, 638583, 637433, 639354, 639352, 637431, 639350, 639348, 372060, 639338, 639244, 634508, 638860, 639223, 548416, 639221, 548413, 548411, 638579, 631996, 601254, 639159, 447205, 639200, 639195, 639152, 447175, 447173, 447171, 639150, 447169, 626150, 634935, 638532, 447134, 447117, 414300, 628656, 552893, 638855, 583942, 638853, 414296, 447101, 414294, 638847, 638841, 638729, 638700, 638833, 414292, 638838, 637415, 637412, 552891, 638724, 552887, 638720, 638717, 534866, 636621, 638650, 638022, 638648, 638638, 629994, 447087, 638577, 447085, 447083, 638498, 606810, 493681, 534856, 398429, 601242, 623554, 638439, 572553, 623552, 638356, 638354, 638287, 634381, 534833, 446989, 612898, 612896, 633720, 633718, 635622, 583890, 446977, 638129, 638127, 638125, 638123, 446975, 638121, 638085, 446954, 610171, 638095, 629681, 631001, 636895, 638080, 636891, 638078, 636889, 638051, 534818, 446945, 638020, 446943, 606030, 638008, 638003, 638030, 606028, 638027, 613258, 637720, 637953, 637947, 629984, 637991, 420424, 637882, 637942, 637929, 631000, 635036, 637927, 580676, 631995, 534804, 565486, 565484, 615748, 601234, 612881, 565481, 637889, 446916, 615746, 615743, 615741, 565467, 565464, 612359, 632137, 637729, 446896, 446893, 637395, 637519, 534795, 637616, 637706, 637691, 637689, 615737, 158104, 615735, 615732, 606027, 446871, 616276, 606024, 446868, 637569, 446862, 446860, 446858, 637560, 628168, 635619, 601226, 398427, 637459, 637510, 637448, 637394, 610331, 629307, 637393, 610329, 628654, 392239, 610327, 628652, 637409, 637405, 612852, 612850, 612848, 4736, 637401, 637399, 632194, 637227, 637391, 570301, 637362, 4734, 637341, 637334, 446798, 446795, 637316, 637313, 637320, 637309, 634168, 446785, 398426, 446781, 637293, 637291, 637288, 446768, 630999, 446764, 534768, 580663, 637157, 201194, 637232, 637225, 637217, 637215, 637199, 637150, 446760, 607955, 446756, 637143, 446754, 520512, 623550, 623548, 596358, 623546, 534753, 479703, 636989, 596346, 636886, 636884, 636882, 636880, 623544, 607947, 636784, 636652, 453818, 636615, 636613, 626747, 626745, 636482, 636479, 635667, 636449, 636439, 636413, 636411, 613165, 636424, 605912, 636421, 636400, 630245, 636417, 635998, 636395, 636403, 630326, 636398, 446630, 630324, 634470, 636323, 636321, 636319, 446616, 610316, 636314, 636309, 596274, 630026, 636306, 446611, 612379, 636088, 636291, 201187, 446600, 636214, 636289, 636210, 636208, 634342, 606398, 636206, 636204, 539566, 636202, 453816, 446577, 636200, 446569, 635750, 446557, 446553, 534713, 636162, 636160, 247227, 636166, 636158, 636156, 446511, 446506, 636091, 635614, 601790, 596258, 601788, 635990, 247209, 247207, 629966, 580620, 635973, 580617, 534698, 635985, 635937, 635971, 635932, 635930, 635883, 635378, 635967, 635925, 630998, 398425, 629431, 635898, 632950, 635864, 446450, 635843, 635683, 607216, 635625, 635681, 635756, 635679, 635362, 635618, 535650, 635752, 635728, 446438, 635229, 628075, 635227, 635092, 635726, 632268, 635224, 633265, 635719, 630226, 630223, 635498, 534679, 635496, 446423, 201185, 605938, 605936, 635359, 414288, 635357, 635355, 614899, 614897, 632948, 635494, 623729, 635490, 635483, 446411, 635479, 613974, 613972, 635468, 613969, 632265, 635465, 635477, 635460, 635474, 635472, 635439, 623728, 623726, 635349, 623724, 635435, 635374, 635353, 635320, 635064, 635085, 634242, 446371, 634240, 446368, 628444, 628442, 635007, 633689, 635069, 635062, 389279, 634931, 446350, 634778, 118438, 634808, 629954, 446344, 446341, 602833, 590141, 623723, 602831, 634716, 634714, 634711, 634705, 634702, 633698, 634668, 633435, 297052, 297050, 601165, 446306, 630853, 534631, 630851, 630850, 634504, 632578, 631041, 632209, 446230, 446228, 633687, 534604, 633685, 633680, 601146, 633674, 633604, 633668, 593667, 633662, 593663, 601143, 596147, 633608, 592969, 446181, 633513, 633356, 633354, 629923, 446169, 633028, 596125, 630410, 596122, 610284, 633351, 596109, 633319, 633286, 633177, 633305, 633280, 633254, 596107, 633252, 628483, 446155, 596105, 633237, 601135, 446145, 446142, 632393, 609966, 609964, 630096, 446128, 446126, 446124, 446119, 446116, 534549, 601134, 628632, 633069, 631913, 596100, 596098, 446111, 629598, 629596, 631039, 7725, 608485, 632979, 631014, 446102, 632838, 608481, 608479, 632969, 632966, 632935, 632836, 608474, 632834, 631907, 632963, 632901, 632913, 632898, 446030, 446008, 446006, 446005, 446003, 632831, 632826, 632813, 632811, 632808, 602720, 632716, 534521, 445992, 632669, 630803, 632703, 609959, 629907, 629905, 583620, 583618, 583616, 583614, 632659, 629451, 629449, 632657, 201166, 201164, 445965, 445951, 632585, 632377, 632374, 632372, 632369, 632416, 632401, 632296, 632149, 445930, 632120, 632117, 625890, 631037, 597119, 630991, 632072, 632037, 630989, 445897, 630873, 630871, 630869, 630985, 630867, 631998, 631876, 631896, 445852, 445822, 631276, 630982, 630980, 445817, 630978, 453804, 453801, 631860, 630975, 631858, 631855, 631852, 631799, 631821, 631778, 631815, 631764, 631809, 631794, 445801, 631757, 445798, 625397, 110760, 630800, 110759, 110757, 445780, 628629, 628627, 631397, 628624, 453794, 631667, 631658, 631656, 628622, 445732, 445730, 445724, 445721, 445718, 631324, 631322, 395595, 445707, 627102, 631315, 631312, 445700, 631309, 631031, 445677, 445665, 445661, 631267, 626476, 445659, 445656, 631028, 631263, 631261, 445653, 580553, 580550, 580547, 580543, 67912, 580538, 580536, 630669, 67910, 602830, 67908, 630884, 630515, 602829, 534459, 629430, 629335, 629428, 631095, 627166, 631074, 631072, 445647, 631026, 445628, 445622, 631022, 445620, 631020, 445609, 630883, 445605, 445600, 630974, 445598, 630972, 607471, 630408, 630893, 627160, 627157, 627154, 445593, 630970, 627152, 420423, 627145, 630890, 627143, 627139, 627137, 627135, 420421, 607462, 630934, 609943, 613256, 609939, 445587, 630865, 445585, 630798, 630882, 534446, 630841, 445556, 630829, 630612, 630827, 630610, 614931, 580825, 629302, 11710, 445521, 601787, 630576, 597713, 629680, 629678, 569051, 630422, 630418, 628074, 630416, 627217, 628071, 628070, 628067, 534417, 630322, 534411, 629427, 630103, 629677, 420416, 420414, 629594, 623812, 629245, 629514, 629446, 629510, 629444, 629508, 629456, 624398, 599347, 624395, 596038, 623828, 629426, 536389, 629405, 624158, 629243, 629240, 629238, 624156, 629299, 629349, 629297, 629281, 376738, 629235, 376736, 629233, 629231, 629255, 629229, 398419, 629227, 629218, 23527, 629215, 23525, 445164, 601786, 445162, 398414, 445159, 445156, 445154, 628176, 453771, 534308, 628156, 627678, 627258, 445148, 627676, 445146, 627673, 627782, 627671, 626080, 628062, 627855, 445142, 445140, 628044, 627852, 534307, 628016, 613566, 628014, 628003, 628012, 628010, 628001, 627950, 609919, 627947, 627990, 596003, 534305, 609917, 627631, 627805, 445132, 595992, 595988, 534303, 445115, 627093, 601785, 627751, 627749, 627747, 627745, 627743, 601900, 627714, 627666, 627686, 627682, 627630, 534301, 445060, 627628, 627626, 599339, 445058, 625164, 599334, 445037, 625163, 534299, 583445, 445032, 627584, 625161, 627538, 625159, 625157, 627447, 613565, 627445, 586338, 445026, 626217, 627403, 627400, 627398, 626215, 627396, 445018, 604419, 615539, 627394, 624293, 445012, 624291, 627392, 627352, 627366, 607215, 627350, 627347, 627213, 627338, 445000, 627333, 627278, 493678, 627052, 627274, 610170, 627318, 444996, 627264, 627212, 574638, 574634, 414275, 613564, 444979, 414273, 580448, 444967, 583424, 627079, 627077, 627075, 627067, 627045, 627032, 627030, 444953, 444951, 627008, 627017, 627012, 602825, 626965, 444946, 627006, 626989, 444940, 626960, 626859, 161176, 626855, 609914, 601784, 625840, 607943, 444934, 444931, 607940, 607936, 607934, 444926, 603409, 444911, 626785, 626776, 626733, 444883, 595962, 626631, 626684, 626619, 626617, 444881, 626574, 623998, 613563, 623996, 444876, 609911, 615793, 626503, 626475, 626464, 609905, 608690, 626431, 608688, 608686, 607929, 589293, 626037, 607392, 607925, 444850, 626380, 444847, 534273, 444844, 534271, 444835, 444830, 444804, 444801, 444799, 607388, 444796, 626316, 201066, 626033, 626259, 626031, 595945, 626268, 626252, 626250, 626248, 626230, 444740, 534255, 607920, 626143, 444730, 246970, 444724, 625716, 444688, 444678, 625838, 625824, 444627, 609116, 625708, 580413, 595940, 595937, 444414, 444410, 625274, 616299, 444398, 534184, 534181, 444380, 623938, 625293, 625228, 625203, 580388, 444339, 444333, 444330, 625251, 625201, 624353, 444271, 624415, 606285, 624361, 624351, 624349, 444264, 624377, 616296, 444246, 444244, 624364, 624343, 444233, 624341, 624359, 624347, 624345, 613025, 201053, 444179, 444177, 444174, 609897, 616293, 614294, 534098, 624305, 624303, 534096, 624289, 602718, 161174, 534087, 534077, 608465, 444163, 608676, 608674, 161172, 246930, 444160, 534073, 444158, 161170, 444156, 444134, 161167, 444125, 246927, 534060, 412575, 444116, 444114, 615781, 444068, 444061, 595922, 595919, 443997, 443989, 443932, 443921, 443897, 623741, 443878, 595889, 443868, 443831, 7724, 443818, 443771, 443769, 612965, 623525, 414271, 623510, 623508, 533934, 443754, 443750, 443747, 615729, 602355, 616336, 601783, 609885, 601781, 616274, 606969, 443695, 443693, 533898, 609881, 443691, 443664, 443659, 443624, 615822, 616015, 533863, 443576, 443568, 613022, 607214, 613016, 533846, 246912, 613562, 615841, 613581, 246888, 615646, 609869, 609867, 601779, 443362, 602353, 615605, 443339, 443314, 443224, 611123, 614929, 614927, 443143, 614917, 614914, 614912, 607851, 613561, 613559, 614909, 612839, 612963, 612961, 612959, 614889, 580319, 613927, 613925, 613923, 442993, 614828, 580317, 457965, 442987, 442967, 614809, 580314, 613921, 580309, 580308, 442825, 442822, 442818, 613914, 613910, 533719, 442782, 613812, 442777, 442743, 442737, 613780, 613909, 442696, 595861, 613963, 613907, 613558, 442682, 610869, 613725, 442671, 442668, 613683, 412571, 613681, 595850, 442648, 595847, 389268, 595843, 442611, 613591, 609851, 442601, 246813, 613557, 613002, 612997, 442598, 613553, 613547, 613545, 613542, 613408, 613483, 613398, 613395, 601778, 607501, 601776, 533637, 633427, 609846, 613299, 442503, 420411, 609838, 609834, 612294, 442480, 613229, 612759, 613215, 613176, 442472, 613227, 442470, 613187, 613196, 612993, 442454, 613155, 613085, 613172, 442447, 613153, 613063, 613142, 580239, 442444, 604877, 442440, 613068, 612991, 389264, 389262, 613005, 414268, 414266, 442407, 609823, 595827, 607364, 610814, 607361, 442348, 609820, 442346, 533526, 601011, 442335, 246792, 594541, 603134, 612977, 612957, 612953, 612952, 246789, 612479, 609817, 612939, 612475, 612473, 612933, 612461, 442280, 442275, 442271, 442262, 611272, 442220, 442219, 442214, 442207, 442205, 442198, 592135, 612606, 612604, 442191, 442187, 609815, 611470, 609812, 442180, 442178, 442175, 442171, 389259, 442168, 612702, 612823, 612724, 612820, 453755, 533488, 453753, 612763, 609800, 442148, 583061, 603129, 632782, 612742, 612740, 612738, 533473, 442118, 612736, 612627, 610523, 595824, 612624, 533470, 612663, 612630, 442095, 442091, 442089, 533458, 608672, 595823, 442085, 612076, 442076, 442074, 595821, 533451, 608909, 442047, 442040, 611933, 594539, 612054, 606282, 442001, 612441, 612485, 595820, 612483, 612439, 612454, 600998, 612052, 533433, 612432, 441993, 612430, 595817, 595814, 595812, 595809, 441990, 595806, 595804, 612050, 441964, 544203, 592362, 441962, 612366, 595801, 595799, 612164, 612293, 612159, 612291, 612157, 611217, 612075, 612073, 612071, 612136, 612134, 612132, 441945, 612127, 612068, 441942, 533398, 612047, 611620, 612066, 441932, 611618, 612040, 612063, 612061, 612058, 441926, 441923, 441919, 611999, 595797, 611992, 595794, 441894, 611893, 441885, 611891, 611889, 611927, 611925, 421776, 441835, 611837, 441822, 441817, 533343, 441811, 533338, 441801, 611656, 611555, 611624, 611615, 611608, 207579, 611604, 207570, 207568, 441792, 572532, 441781, 603047, 611214, 611211, 611208, 611569, 611546, 612701, 611544, 611563, 533314, 611541, 441745, 611539, 611200, 611198, 611195, 441734, 611311, 611459, 207567, 611482, 610854, 611479, 441724, 441708, 441681, 441679, 533288, 611085, 611081, 140330, 611079, 611240, 441655, 610955, 611194, 412563, 609791, 595774, 595772, 595761, 610952, 610950, 595758, 441530, 610883, 610864, 609782, 441490, 610857, 200977, 200975, 441488, 595745, 595742, 595739, 449871, 449869, 610719, 470878, 441412, 595721, 599322, 610370, 599319, 611718, 610190, 611708, 610188, 610184, 610169, 609192, 441356, 610156, 441347, 610044, 610053, 302998, 610042, 302996, 314436, 533066, 441254, 398412, 608828, 608620, 608658, 608813, 608246, 608767, 608671, 608669, 600981, 533042, 572531, 533040, 608618, 608616, 533037, 608684, 608644, 608642, 200965, 608613, 592967, 608611, 608640, 608648, 600980, 608609, 441232, 441149, 607968, 133319, 607801, 607636, 607213, 607346, 200956, 607632, 607708, 607750, 606319, 607337, 607335, 607589, 615528, 441118, 607539, 607537, 607508, 441091, 606276, 607326, 607305, 592211, 188930, 603458, 606017, 441046, 441038, 607225, 606015, 606013, 607139, 606975, 606865, 597418, 595657, 597416, 597414, 606833, 606858, 440970, 606823, 440968, 440966, 606007, 605934, 606819, 606004, 440958, 595644, 606002, 606816, 440955, 440953, 508166, 440942, 440936, 440934, 606733, 440932, 440926, 606731, 606729, 606678, 606685, 440924, 440921, 440918, 606588, 606632, 606578, 440903, 606576, 349617, 440889, 606550, 414212, 595628, 606461, 606458, 606450, 606447, 606420, 606418, 606413, 606273, 606288, 440856, 440853, 440851, 594995, 602717, 597231, 606142, 599126, 606135, 606132, 606121, 349616, 597223, 605961, 605955, 605952, 602716, 605982, 602714, 600045, 605445, 200928, 440826, 605910, 605964, 605883, 133309, 600041, 605880, 605926, 605923, 133306, 605854, 440800, 598091, 605313, 605846, 440781, 605786, 605710, 605530, 605782, 605704, 605748, 440768, 605746, 440766, 440763, 602823, 440751, 605719, 605715, 419512, 605701, 539563, 604070, 208383, 200924, 440742, 600458, 600455, 605568, 600449, 440740, 440737, 440730, 605509, 605554, 440727, 440721, 440718, 440711, 200918, 605491, 602822, 440695, 605221, 605216, 440693, 440689, 407979, 532849, 7723, 605115, 440684, 440679, 440677, 440665, 597410, 605049, 597407, 605061, 604041, 605047, 605058, 599316, 600968, 597403, 440657, 440653, 602821, 604401, 602713, 440647, 597401, 605013, 590169, 604267, 605040, 440636, 394080, 200914, 508165, 604336, 440625, 508162, 605007, 604454, 604967, 604452, 440612, 440611, 322578, 440610, 440609, 440607, 604450, 440605, 602711, 600439, 604964, 602709, 604962, 440602, 440600, 440597, 604926, 604891, 592963, 109233, 414206, 604811, 440571, 604776, 440531, 604449, 440523, 604635, 604448, 440479, 440477, 440466, 604284, 604282, 7722, 604193, 440461, 604190, 597195, 604094, 532784, 440449, 604092, 603029, 440447, 440445, 604025, 393263, 602708, 440439, 603388, 539559, 603850, 603440, 603383, 603381, 603045, 398411, 603501, 603150, 601773, 603063, 332855, 603351, 603321, 603317, 440411, 603313, 398409, 398407, 440409, 602920, 603290, 603287, 599307, 600937, 532736, 440394, 603053, 593627, 440368, 601772, 602977, 599084, 599080, 602936, 600682, 414203, 602841, 602839, 414201, 599075, 414199, 602894, 602812, 414197, 602807, 602820, 602838, 602836, 602880, 602818, 602805, 599304, 602707, 602705, 602779, 602777, 440342, 602703, 440340, 600665, 602701, 325899, 602646, 601771, 602343, 601769, 602382, 414192, 414190, 602306, 602200, 601597, 602189, 602160, 440321, 407976, 602123, 420405, 601767, 602023, 601578, 584126, 599300, 600353, 601938, 601922, 440265, 440262, 601862, 601860, 601765, 600328, 381108, 600901, 601639, 601714, 601746, 601764, 601641, 601635, 601470, 601468, 601608, 601606, 601466, 601560, 601603, 601464, 440255, 601484, 440253, 596804, 601481, 600896, 601461, 440248, 440244, 440242, 440240, 601496, 601410, 601488, 601458, 600892, 601431, 601362, 508161, 440230, 440221, 600004, 508160, 440216, 601383, 508158, 508156, 599911, 600889, 440212, 601358, 601355, 601344, 77209, 77207, 600830, 207566, 601310, 601288, 600841, 207563, 600875, 600883, 600869, 508155, 599296, 600858, 600768, 600825, 600821, 440192, 600595, 599906, 600661, 600681, 420403, 600657, 600593, 420400, 600589, 600587, 600585, 600614, 600583, 600579, 600611, 508152, 599555, 499823, 508150, 600606, 600604, 440176, 440173, 508148, 598388, 600550, 598386, 599646, 600486, 599977, 600537, 600529, 440168, 440165, 599292, 598556, 600053, 600198, 600196, 599875, 600003, 600002, 599873, 440108, 599990, 594177, 592682, 324381, 200894, 440086, 599290, 599288, 599553, 200891, 568995, 568993, 440070, 532602, 599548, 439990, 439984, 599276, 414188, 414186, 597977, 398406, 569050, 599152, 568990, 599149, 599138, 439932, 599142, 439921, 439919, 569048, 569046, 532589, 599106, 599066, 598929, 598926, 598899, 598939, 598924, 598922, 200882, 597194, 598917, 593737, 598842, 580165, 598870, 598875, 598839, 598837, 598835, 598852, 598554, 598827, 58702, 580163, 591777, 591775, 584665, 598812, 598810, 598804, 598176, 573984, 439854, 598175, 598516, 598512, 598433, 598430, 23523, 439809, 598382, 598377, 587478, 439799, 439797, 539556, 598174, 598148, 554297, 573983, 573981, 474799, 598220, 598173, 598171, 554744, 598169, 598181, 598167, 598165, 598179, 598163, 598161, 598159, 598118, 598157, 133296, 133294, 598147, 598146, 598153, 598143, 598134, 598122, 596887, 482152, 482150, 439703, 482146, 482140, 482138, 482136, 482134, 597815, 597808, 572526, 593958, 572520, 597710, 439678, 596885, 596883, 596881, 596879, 597393, 597709, 597391, 594195, 594193, 594191, 439605, 439575, 439568, 439566, 597193, 207561, 207559, 133292, 597432, 597389, 597430, 597483, 597428, 439547, 597342, 207557, 597384, 439544, 595315, 439541, 349230, 597219, 589049, 439528, 414185, 597191, 596878, 532528, 596876, 594532, 414179, 414175, 596893, 420397, 596875, 596873, 439425, 439417, 439408, 594353, 594349, 439402, 590061, 596640, 596638, 596636, 133276, 595072, 594928, 594186, 439285, 14205, 14203, 593038, 133257, 593034, 133253, 439044, 592805, 133248, 580112, 592930, 580110, 592928, 592925, 580106, 439031, 439023, 439021, 592360, 592018, 438900, 592016, 592013, 438898, 591919, 438888, 591915, 438878, 591118, 591627, 200850, 589331, 554273, 546804, 546802, 546800, 438844, 438842, 200843, 438832, 200840, 438806, 591347, 438796, 591346, 591344, 133246, 99312, 133244, 532170, 586215, 438746, 591299, 420381, 591297, 591295, 200837, 200835, 438698, 546796, 546794, 546791, 546790, 546787, 200833, 438579, 438532, 438491, 438488, 590372, 549904, 549902, 586328, 586326, 586324, 200822, 200821, 569920, 569918, 569916, 569914, 584554, 387868, 590166, 569912, 589462, 420372, 570300, 589606, 420365, 420363, 590177, 563249, 420361, 398402, 398400, 392790, 588618, 588616, 563247, 563245, 420359, 14202, 589839, 587460, 587458, 589605, 472247, 589327, 570878, 570877, 392785, 586205, 589046, 587542, 588897, 587564, 587681, 588642, 586680, 586677, 569910, 586094, 384258, 585639, 436320, 435501, 435469, 578332, 570866, 578568, 569353, 578284, 578515, 56601, 578282, 514707, 514701, 235070, 570861, 569982, 578280, 570852, 207556, 570299, 578278, 578276, 578274, 509169, 509168, 578205, 570851, 420265, 569316, 571680, 570828, 570823, 569207, 571420, 569045, 432917, 571239, 200307, 398465, 571098, 562760, 570925, 164628, 432864, 420262, 164616, 570816, 569288, 569285, 450965, 569187, 432429, 164597, 432409, 558773, 392770, 564356, 567348, 567345, 567343, 564831, 558883, 432255, 564823, 564819, 565431, 565525, 567274, 564914, 432238, 133112, 306576, 82890, 566878, 58690, 77201, 355914, 77199, 514973, 368397, 514971, 77197, 565931, 537711, 537710, 432194, 453150, 367546, 77195, 321233, 412329, 412321, 412319, 412317, 303489, 432070, 133103, 303487, 561147, 564805, 381826, 564903, 564902, 564900, 564922, 564859, 303485, 537702, 564099, 563679, 392853, 538942, 563242, 563239, 413329, 413327, 560474, 551051, 560471, 518721, 23498, 560611, 537693, 559330, 333819, 538935, 558383, 557574, 384238, 556554, 557138, 547397, 555269, 556195, 547450, 555934, 547394, 547393, 552872, 552870, 554649, 303417, 303411, 303404, 303400, 303375, 539316, 303369, 303366, 398155, 550754, 539312, 547431, 539307, 539306, 547383, 552025, 547381, 551985, 491064, 333800, 398151, 132995, 549803, 288167, 537188, 545402, 550638, 550985, 551019, 550614, 549899, 537186, 537183, 537179, 529008, 550046, 430457, 549210, 538929, 538927, 546026, 547544, 547372, 547371, 542070, 398138, 546122, 398126, 544214, 544212, 544990, 543479, 528876, 488551, 544408, 543791, 132933, 207550, 544207, 518838, 528856, 544258, 381621, 321182, 544220, 516780, 542128, 544045, 543779, 537662, 542348, 541130, 412097, 412092, 492552, 539897, 539894, 194627, 541127, 110440, 429137, 539762, 511590, 462609, 511588, 539759, 429114, 539749, 539638, 321173, 381616, 482921, 537226, 384232, 538922, 132887, 538919, 466831, 537619, 514534, 355899, 514532, 428918, 333751, 501543, 536603, 536601, 535765, 321164, 511586, 492115, 535302, 199939, 504963, 199935, 199931, 528039, 528022, 518742, 528018, 303342, 514890, 321153, 412035, 112042, 511583, 520509, 492111, 412028, 318361, 378912, 303317, 462606, 508144, 508139, 509808, 411917, 508198, 508129, 112032, 504087, 504085, 333674, 503097, 502150, 207542, 207539, 306416, 306414, 318357, 458215, 368188, 366408, 493173, 366406, 493170, 366404, 366401, 303310, 378905, 318353, 318347, 318344, 487477, 466820, 488529, 488726, 487487, 470045, 485123, 484331, 480649, 483299, 483267, 483237, 318336, 199054, 481979, 480646, 480475, 479247, 479241, 474850, 473009, 475402, 477719, 198961, 368101, 475411, 303293, 198865, 384194, 473271, 472724, 419742, 198834, 421241, 470779, 470773, 470008, 469290, 470005, 469283, 318326, 339586, 318325, 198608, 421239, 198581, 198580, 465870, 325819, 465596, 465589, 465585, 465575, 424146, 462545, 462536, 368350, 198444, 424007, 424004, 459191, 458998, 411665, 456984, 333577, 198167, 452736, 406582, 406579, 406577, 451208, 451196, 448810, 448800, 320615, 449803, 384183, 378979, 384181, 318306, 318304, 318301, 414688, 411343, 343441, 369407, 411020, 197717, 333528, 333523, 333521, 333518, 407323, 355733, 407825, 368062, 407320, 406599, 406595, 368057, 406592, 393020, 407423, 338791, 407313, 393451, 406236, 404122, 404120, 393018, 197521, 405370, 405358, 405088, 404118, 404140, 404137, 404272, 404005, 333488, 403909, 403995, 197429, 197413, 197405, 197403, 403021, 197390, 397801, 403106, 392722, 403044, 130230, 197375, 197367, 384178, 330048, 228184, 400793, 384176, 400789, 239702, 400217, 400782, 396016, 197319, 197318, 197317, 400773, 399688, 131995, 397047, 400140, 399025, 274575, 399857, 384167, 386458, 399536, 393009, 313847, 398045, 197298, 398036, 333459, 399577, 377687, 398314, 197281, 396834, 384165, 384163, 197262, 398899, 393447, 393007, 393005, 393001, 397736, 197236, 320390, 398437, 320382, 394512, 384159, 384156, 395727, 197176, 197168, 384152, 384150, 395808, 197125, 395796, 392642, 197080, 318273, 394874, 393975, 393971, 394508, 394505, 303272, 393987, 393945, 393420, 393415, 393940, 393965, 393695, 393408, 393403, 393401, 318272, 384141, 384138, 384136, 378969, 384134, 392794, 392684, 392680, 378967, 303266, 375765, 375763, 391691, 386353, 359099, 303258, 303245, 303242, 196841, 377437, 382529, 303238, 351779, 351777, 303235, 382198, 368048, 303233, 254859, 279086, 320277, 98839, 303231, 303229, 320275, 303227, 303225, 254857, 368046, 320273, 382084, 381317, 98804, 374987, 374985, 350012, 358325, 377600, 347876, 377795, 377598, 374966, 375105, 333409, 374959, 374952, 347859, 347857, 347855, 347853, 368026, 370476, 238026, 333386, 370151, 369602, 367766, 367762, 303220, 303218, 303216, 369361, 367760, 368480, 368478, 368012, 368010, 303187, 303185, 303160, 303158, 303156, 303147, 207526, 361713, 361711, 361709, 361702, 303143, 361697, 347821, 344249, 344246, 335789, 344244, 344241, 196359, 196357, 303140, 303138, 303136, 303134, 348843, 351349, 303132, 348841, 351347, 213276, 131778, 303130, 196352, 347817, 357091, 303126, 303120, 360198, 303118, 303115, 303113, 303110, 303108, 303105, 350010, 303075, 344928, 310276, 310274, 338775, 338771, 338765, 338759, 338757, 310173, 295962, 295960, 295958, 328870, 303040, 343264, 339569, 339566, 340122, 340121, 340119, 340116, 340114, 337391, 338751, 71464, 58592, 47119, 46352, 21914))
Run Time: 0.066598
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3510 | |
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 | | | | | 3510 | |
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 (35296, 35236, 35223, 35216, 35179, 35157, 35129, 35089, 35063, 35053, 35046, 34953, 34963, 34996, 33605, 34960, 34957, 34941, 34938, 34933, 34885, 34883, 34865, 34858, 34829, 34821, 34778, 34777, 34766, 34720, 34730, 34747, 34714, 34723, 34719, 34699, 34664, 34591, 34579, 34577, 34373, 34489, 34481, 34418, 33933, 34457, 34443, 34415, 34394, 34358, 34282, 34249, 34236, 34206, 34198, 34067, 34191, 34185, 34119, 34094, 34075, 34069, 34015, 34013, 34000, 33998, 33566, 33986, 33972, 33981, 33978, 33952, 33943, 33930, 33920, 33917, 33911, 33830, 33823, 33820, 33807, 33663, 33657, 33599, 33624, 33618, 32344, 33612, 33611, 33595, 33604, 33589, 33572, 33552, 33553, 33547, 33514, 33460, 33397, 33358, 33241, 32990, 33031, 33011, 32992, 32934, 32988, 32503, 32969, 32930, 32894, 32891, 32887, 32886, 32883, 32881, 32872, 32862, 32861, 32851, 32827, 32825, 32808, 32803, 32802, 32776, 32726, 32614, 32594, 32487, 32501, 32495, 32493, 32349, 32360, 32401, 32399, 32343, 32331, 32333, 32329, 32196, 32013, 32012, 32118, 32119, 32120, 32121, 32122, 32000, 31908, 31903, 31834, 31828, 31817, 31814, 31775, 31760, 31669, 31642, 31641, 31623, 31567, 31564, 31520, 31468, 31429, 31121, 31041, 31040, 30856, 30406, 29156, 27910, 20071, 19915, 19825, 17089, 16831, 4222))
Run Time: 0.007423
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 180 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, �.:
Run Time: 0.000211
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: �.:, XF\Pub\Controller\Member, RecentContent, valid, user_id=1317, 1716195414, , 0, �.:
Run Time: 0.000128
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000360
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.000577
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: 1716195114
Run Time: 0.000482
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 26 | 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` >= 1716195114)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000511
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 26 | 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