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.000829
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.000228
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` = '9178')
LIMIT 1
Run Time: 0.000448
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.003264
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_9178' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.169967
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 (646196, 646169, 646108, 645920, 645914, 645842, 645794, 645782, 645723, 645470, 645327, 645242, 645234, 644981, 644953, 644952, 644950, 644949, 644910, 644876, 644873, 644869, 644853, 644827, 644779, 644677, 644676, 644671, 644641, 644628, 644626, 644623, 644552, 644539, 644538, 644513, 644512, 644461, 644460, 644385, 644132, 644116, 643980, 643882, 643836, 643812, 643801, 643795, 643770, 643758, 643754, 643719, 643669, 643653, 643652, 643610, 643609, 643559, 643536, 643507, 643468, 643466, 643404, 643401, 643243, 643129, 643127, 643058, 643023, 643022, 643012, 642962, 642945, 642931, 642904, 642795, 642787, 642675, 642672, 642663, 642662, 642618, 642490, 642489, 642444, 642304, 642300, 642229, 642228, 642196, 642105, 642099, 642098, 642029, 642018, 641983, 641928, 641814, 641790, 641768, 641763, 641676, 641658, 641654, 641628, 641627, 641623, 641619, 641616, 641615, 641612, 641363, 641362, 641279, 641204, 641137, 641136, 641044, 641015, 641009, 641001, 640991, 640980, 640978, 640976, 640969, 640967, 640965, 640964, 640959, 640958, 640952, 640942, 640937, 640933, 640923, 640898, 640884, 640880, 640878, 640876, 640875, 640874, 640872, 640867, 640856, 640845, 640843, 640841, 640825, 640807, 640261, 640804, 640757, 640686, 640683, 640661, 580764, 633948, 580762, 640500, 640620, 624246, 580756, 640495, 201206, 635408, 447665, 447663, 447649, 447614, 640487, 640293, 640433, 638499, 633659, 447555, 447552, 640327, 640205, 640232, 640125, 640102, 640052, 637598, 639513, 447511, 536597, 639482, 639688, 536590, 639967, 639478, 539592, 447461, 639473, 639960, 609687, 639951, 601758, 639460, 639770, 639457, 447380, 639670, 638142, 639780, 639453, 639638, 639590, 597259, 491353, 447323, 639493, 639389, 639387, 639385, 534894, 637432, 447281, 447276, 639318, 639333, 639256, 639316, 639272, 639266, 639264, 639262, 630898, 447208, 447178, 639155, 639193, 639148, 639133, 635151, 534876, 635143, 635140, 635127, 635124, 638964, 638913, 638911, 638906, 447118, 638920, 638738, 638765, 638728, 638819, 638757, 638723, 638774, 638688, 638680, 447089, 638671, 638609, 638614, 638600, 534863, 493683, 638595, 604422, 638540, 638377, 638482, 638480, 637682, 638475, 630275, 638472, 638470, 638466, 447079, 447059, 638414, 447055, 447050, 596409, 638402, 638436, 447046, 638399, 572552, 447039, 623336, 447015, 638363, 638357, 638341, 447003, 447001, 446996, 580692, 638307, 638314, 638291, 638190, 633728, 638188, 638269, 638245, 638131, 638234, 638182, 638009, 596394, 446940, 637958, 637945, 637940, 637973, 637938, 637955, 630270, 612886, 612882, 612878, 637590, 637885, 612876, 637588, 623334, 612875, 446913, 637848, 446910, 637785, 637774, 637745, 637758, 612871, 446895, 612352, 612868, 637644, 637647, 637640, 446857, 637544, 637458, 637429, 612859, 637349, 637384, 637382, 637373, 446802, 626146, 623331, 637254, 637113, 637245, 637239, 633472, 637212, 446758, 637132, 636721, 629977, 636717, 637082, 636587, 636980, 446721, 636909, 636941, 596344, 636922, 636919, 636898, 636855, 636905, 636853, 636851, 636850, 623543, 623541, 636836, 596336, 623328, 636810, 596334, 453170, 309832, 309828, 624243, 596330, 596326, 596324, 596322, 596320, 636715, 597258, 636741, 636733, 635102, 636700, 636706, 636059, 636689, 453167, 636557, 623326, 636666, 636664, 636661, 446694, 446683, 589712, 633816, 636657, 636635, 446681, 636612, 446674, 636584, 636581, 636572, 636570, 446670, 608518, 636534, 636485, 636480, 636459, 636456, 636478, 636493, 636474, 636472, 636414, 446643, 630249, 636412, 446633, 636345, 630325, 606239, 446629, 636343, 636341, 636282, 446626, 636320, 446621, 571348, 446599, 571346, 571343, 606395, 571340, 636196, 636230, 636188, 596260, 636184, 446525, 636134, 634957, 636111, 446492, 571200, 596256, 571198, 571338, 603021, 603018, 599359, 603014, 635951, 189138, 636039, 636041, 636037, 453813, 636012, 636005, 453811, 635916, 571187, 635780, 635912, 596252, 571184, 596245, 571181, 635891, 571178, 635889, 635818, 609072, 635869, 627740, 628793, 635863, 596240, 635814, 635810, 635845, 635807, 628788, 623322, 635361, 635616, 635624, 632253, 635657, 635730, 635746, 453164, 635581, 247192, 635356, 629962, 635259, 110769, 605430, 635354, 635352, 635309, 635306, 446394, 608508, 635247, 446378, 635081, 446363, 623315, 635208, 446361, 623313, 635050, 634996, 463019, 634962, 446357, 634974, 634971, 610302, 610300, 634893, 634871, 610297, 634869, 634867, 634815, 634865, 634809, 634779, 634877, 634818, 189240, 446340, 634788, 446331, 634671, 634750, 634743, 386100, 634740, 596181, 634720, 634661, 634659, 634657, 634648, 634595, 634588, 634592, 634548, 634558, 634551, 446298, 601163, 634482, 634527, 634491, 634480, 634391, 634487, 381165, 634458, 446296, 634432, 634434, 634416, 630204, 629949, 634301, 634358, 634327, 634347, 634313, 596177, 634295, 601156, 634258, 634262, 453161, 453159, 634096, 634183, 552104, 634162, 634093, 634150, 627601, 610290, 610288, 634120, 634118, 634066, 634064, 634054, 634045, 602479, 602477, 634043, 634038, 592736, 633572, 633990, 605253, 633836, 633834, 633799, 632769, 605237, 601148, 633832, 446231, 633781, 633778, 623310, 633663, 446211, 633655, 633613, 599528, 599526, 446198, 633565, 536414, 633470, 633468, 633479, 632946, 536412, 633029, 446167, 633215, 633213, 446164, 584037, 596124, 633328, 633430, 410152, 633457, 633287, 633349, 633196, 633190, 633185, 633257, 633278, 633182, 633149, 633179, 373558, 410150, 589709, 396216, 633160, 396214, 396212, 633072, 396210, 534551, 633070, 633015, 632245, 201169, 608350, 632970, 632964, 632988, 632904, 632857, 632889, 632887, 446023, 446017, 518983, 445994, 632789, 632763, 632729, 629910, 632726, 632226, 609963, 609958, 632701, 632694, 632692, 631599, 534508, 632651, 627254, 632633, 632627, 632625, 632623, 632612, 632608, 632596, 632385, 632591, 632502, 632499, 632528, 632380, 632349, 632411, 632446, 632343, 625897, 625894, 453806, 247120, 632238, 609957, 632236, 632192, 632270, 632182, 189122, 189120, 386526, 609118, 373136, 410147, 625891, 632142, 410145, 629397, 632034, 632000, 630987, 630984, 631993, 631873, 596093, 457267, 631785, 631828, 631818, 627925, 631713, 631762, 586610, 630950, 445750, 445745, 631205, 631638, 445737, 445727, 631319, 631313, 631307, 631266, 627907, 631096, 609952, 607476, 631048, 631024, 410142, 631009, 612591, 612586, 630905, 601124, 379340, 630902, 589693, 589686, 589684, 630887, 607442, 572782, 630828, 630826, 630820, 613659, 607434, 630319, 381153, 630575, 453791, 630517, 381150, 630497, 247086, 630495, 381148, 630493, 445512, 381146, 630489, 629879, 381144, 596071, 596065, 630304, 630302, 629708, 629862, 110752, 445467, 629716, 629737, 629782, 629704, 629702, 534391, 185364, 629646, 551783, 551780, 551777, 612581, 612575, 612573, 612571, 420418, 445383, 612569, 612567, 629188, 629189, 445352, 629541, 629416, 629551, 580513, 580512, 629517, 614891, 629384, 629371, 623294, 629365, 629356, 629344, 629024, 629324, 612307, 629292, 534361, 624144, 201132, 629260, 605826, 605824, 585601, 585599, 629183, 445299, 629083, 247017, 629080, 534331, 462505, 189089, 580481, 629050, 601110, 623292, 386092, 628979, 628962, 628948, 628930, 571333, 596028, 628835, 628826, 605229, 606391, 628813, 628754, 626584, 628726, 628712, 628718, 628692, 628675, 628519, 628501, 607019, 445257, 628464, 628456, 628452, 628430, 628385, 628418, 607394, 628377, 445243, 623286, 445238, 445235, 628366, 246996, 246994, 628363, 628361, 628359, 445213, 445208, 445206, 445203, 445200, 445196, 453782, 601094, 445194, 628333, 628328, 605682, 628324, 605680, 605676, 628294, 453774, 412581, 453772, 628221, 445180, 578484, 578482, 628278, 628273, 628271, 628245, 445165, 627524, 627521, 578476, 628209, 623281, 628166, 628162, 623279, 623277, 623275, 628127, 623273, 628144, 628102, 628093, 626081, 596005, 628046, 628042, 624241, 628008, 627941, 627851, 627994, 189083, 627903, 627897, 627889, 627936, 625317, 627823, 627815, 627812, 627834, 595996, 589315, 627808, 627801, 627827, 589313, 595985, 627794, 201086, 627480, 627778, 627533, 627768, 627471, 627469, 627711, 627697, 627236, 627233, 627685, 627648, 627683, 627680, 605669, 609313, 445091, 445088, 627654, 599341, 627639, 627615, 445042, 599338, 599335, 627611, 627609, 627586, 627604, 627530, 627430, 466842, 615543, 445027, 626216, 627402, 615541, 627422, 445021, 615537, 604418, 627383, 595979, 616301, 627361, 627359, 627354, 627341, 571331, 627226, 627119, 414274, 627205, 444981, 624213, 627191, 627083, 444952, 627016, 627020, 444945, 444943, 444938, 626984, 626950, 626934, 626932, 626927, 626923, 626873, 444932, 626871, 626897, 607938, 444929, 626869, 626862, 444923, 603410, 626809, 626803, 444909, 626736, 626723, 611101, 611099, 611097, 611095, 611093, 626598, 611091, 572544, 626579, 189073, 35137, 626493, 35135, 35131, 626474, 626478, 626481, 626449, 626446, 626444, 626428, 589296, 626426, 607927, 606383, 626379, 444842, 626359, 615791, 626341, 444810, 613414, 607389, 444794, 626332, 607385, 444790, 626334, 626329, 444788, 626327, 589670, 626324, 625928, 444768, 571329, 595952, 571327, 595949, 626304, 626302, 626280, 626265, 626263, 626278, 625633, 406512, 406510, 626203, 571325, 571323, 571321, 616090, 391988, 626187, 626180, 626172, 444727, 571319, 571317, 22838, 626086, 571315, 626094, 444723, 444721, 626076, 626072, 571312, 626044, 625983, 625946, 611437, 444690, 625944, 534243, 625887, 625831, 625881, 625787, 444657, 625829, 625411, 444655, 625853, 625825, 625837, 625629, 625742, 625627, 444595, 625755, 444544, 444541, 444530, 625591, 625588, 625705, 625585, 372050, 625663, 625670, 625659, 625652, 625647, 625644, 625614, 189057, 611423, 444474, 625528, 625539, 625525, 625506, 625515, 625512, 625335, 625475, 625471, 625469, 625466, 625431, 625420, 625324, 610253, 610243, 625270, 625345, 625237, 625224, 625234, 444335, 444332, 595933, 482294, 625175, 625135, 623980, 610238, 625150, 610236, 444275, 615088, 616297, 624378, 444217, 615915, 444170, 444159, 624281, 614260, 623266, 605655, 624208, 624205, 624202, 624197, 615782, 580351, 607372, 624002, 623975, 623972, 623884, 623908, 534017, 623930, 623923, 623900, 444056, 601074, 616144, 324421, 623878, 608545, 623867, 623874, 623872, 601069, 444014, 595281, 623804, 595279, 623830, 623818, 623822, 595916, 595911, 443982, 443979, 443977, 624096, 623792, 443929, 443923, 623774, 443901, 35129, 443898, 35127, 623263, 623258, 623443, 623256, 615911, 623684, 623681, 623248, 623670, 443844, 443820, 603011, 594323, 443786, 607601, 607599, 623584, 623581, 623523, 623509, 623506, 443760, 601060, 443742, 624082, 623393, 624079, 443737, 624073, 443735, 443733, 623364, 443729, 443726, 616320, 624067, 616317, 623245, 616254, 616251, 616291, 624060, 616282, 608440, 616151, 616227, 616223, 616219, 616197, 549766, 616189, 616050, 616167, 180980, 616122, 616099, 616048, 616020, 616046, 616044, 616042, 616040, 616038, 616032, 616029, 616027, 201037, 616016, 616005, 583193, 615932, 615927, 615924, 615938, 580335, 595877, 615922, 615876, 443498, 609375, 607595, 615709, 615776, 615765, 443431, 580325, 607873, 592161, 356084, 615616, 349940, 615478, 615471, 615466, 615523, 615521, 443267, 615413, 615410, 615507, 615403, 615400, 615367, 615352, 615350, 613749, 614923, 614993, 443102, 443099, 443091, 607017, 608543, 607015, 608541, 443054, 443052, 614865, 614862, 604736, 623227, 608539, 614874, 614823, 442973, 457963, 614782, 607010, 607002, 623224, 613911, 613820, 613817, 442790, 442780, 442778, 614056, 613712, 623221, 442706, 613897, 614002, 608435, 613709, 613707, 613705, 613863, 609372, 613305, 613847, 610202, 610200, 613763, 613788, 613724, 613721, 608937, 613604, 613600, 612704, 608930, 613502, 613231, 613494, 613487, 607503, 604708, 609226, 608432, 608425, 442544, 605324, 607500, 605321, 606353, 605319, 609847, 613329, 580258, 580254, 613302, 613300, 613313, 580244, 613297, 597256, 613200, 612994, 613191, 442455, 442451, 533560, 442450, 613170, 613095, 442437, 605315, 600084, 609822, 613045, 607365, 442392, 442361, 442354, 607362, 442353, 442342, 623210, 612978, 188959, 442333, 612955, 612973, 442323, 612971, 612949, 533517, 612817, 442303, 612815, 612929, 442288, 612564, 612562, 612560, 612912, 442200, 612908, 612906, 593711, 614964, 606225, 612902, 609810, 612811, 609808, 606838, 609806, 612780, 612819, 612794, 612791, 612777, 612750, 442166, 442161, 612775, 442159, 606338, 442153, 612762, 610712, 595826, 612727, 610710, 609368, 603128, 609365, 612534, 609363, 609361, 612531, 632780, 632778, 609359, 632776, 612671, 612669, 612637, 608919, 612613, 608914, 612610, 611385, 598566, 442084, 604276, 606336, 612558, 612556, 612554, 612552, 612550, 601001, 612267, 442053, 611364, 611361, 612537, 608910, 610708, 608908, 612508, 610706, 610704, 606325, 610702, 612426, 604199, 442012, 612424, 612491, 612422, 612420, 612418, 612416, 595818, 595811, 612400, 441987, 608902, 612383, 605387, 595800, 612208, 612288, 612074, 493224, 612072, 493222, 612112, 441939, 612065, 612045, 612037, 414261, 493197, 414258, 441900, 612019, 612012, 611978, 611981, 392232, 608203, 611926, 606996, 611910, 611867, 595793, 611865, 611839, 611834, 611800, 611831, 611787, 611675, 590083, 207578, 207575, 611597, 207573, 207571, 604668, 611549, 608761, 611581, 608759, 611594, 608747, 605366, 611543, 611552, 611537, 611528, 611514, 611512, 611496, 200988, 623206, 623204, 623202, 605307, 611309, 493195, 140331, 605293, 611072, 610698, 610696, 610694, 611224, 611153, 400765, 610693, 441648, 441638, 623200, 611125, 611050, 611066, 611063, 441632, 611116, 608345, 623198, 610936, 610691, 608197, 441594, 595770, 441578, 441574, 610959, 610926, 441567, 610892, 157336, 597982, 441543, 441521, 472709, 623192, 610793, 623189, 623187, 623184, 597371, 246728, 597369, 610783, 597367, 610780, 610851, 610778, 610771, 578250, 610769, 623176, 604001, 610657, 610655, 610519, 610653, 610517, 611764, 610588, 610639, 610636, 610593, 610632, 610575, 610627, 610558, 610556, 610620, 610568, 610532, 610430, 610427, 610424, 623169, 623167, 610422, 610497, 623165, 623163, 623159, 608085, 611750, 611745, 611740, 611737, 610451, 611729, 611721, 610383, 610374, 381137, 381135, 599849, 608562, 602851, 599842, 608559, 602848, 381131, 599840, 611712, 602845, 381129, 600989, 298159, 381127, 609773, 455498, 610175, 610163, 455491, 466835, 396205, 610139, 610131, 610129, 610127, 396203, 610095, 610093, 610001, 396199, 610073, 414237, 610081, 396197, 533132, 610069, 609999, 608229, 609754, 609751, 609748, 533125, 533124, 303000, 610055, 441341, 381124, 610051, 381122, 302997, 381120, 533119, 381118, 610048, 441335, 508031, 508029, 609992, 597243, 609664, 623153, 609745, 441319, 623150, 609741, 441316, 609736, 609662, 396190, 597241, 597238, 609659, 609681, 396187, 609696, 396185, 596599, 396183, 609678, 609094, 609694, 609657, 396173, 609655, 414235, 609464, 609549, 609492, 609488, 312225, 609457, 609454, 597115, 481385, 609245, 609307, 609406, 609330, 623145, 609243, 623143, 609213, 609211, 601965, 609285, 608410, 609240, 605358, 609238, 609236, 608893, 607581, 386082, 609234, 609188, 598030, 608407, 609208, 623141, 609232, 607577, 607575, 623136, 133332, 578101, 133330, 623134, 578099, 623131, 609141, 400762, 609139, 609137, 580225, 476642, 609012, 595704, 609017, 609010, 609029, 595701, 609007, 609004, 608965, 608834, 608978, 441236, 608789, 594559, 600982, 608715, 608707, 608392, 608385, 608383, 608528, 608525, 608523, 608367, 608363, 608277, 608275, 600806, 623121, 35119, 35117, 608300, 441174, 441172, 608227, 441168, 608133, 608121, 608119, 608145, 608223, 608041, 608032, 133320, 607726, 133316, 607966, 607643, 623118, 607639, 607637, 607635, 607790, 607630, 453734, 395384, 412562, 607698, 607674, 623116, 607647, 623114, 607613, 607588, 607566, 607564, 623110, 35115, 607529, 607524, 607522, 35113, 441089, 607341, 589668, 441078, 441075, 441073, 607323, 607271, 607330, 377212, 607302, 623107, 607238, 623104, 600979, 606995, 441050, 441041, 607071, 607210, 606011, 606010, 607182, 441013, 606993, 606988, 606951, 607102, 476639, 605096, 35107, 582888, 607079, 440999, 606985, 606982, 607041, 440997, 606979, 601392, 603005, 604175, 604173, 606976, 606971, 604170, 603003, 440986, 603000, 606943, 606875, 606925, 440981, 440979, 606873, 606920, 440975, 606915, 35104, 35102, 35099, 606886, 606884, 606881, 381112, 605065, 606864, 606789, 606827, 554415, 606825, 606001, 606785, 606317, 606315, 440952, 606049, 606047, 606045, 606796, 440944, 606609, 595640, 595638, 606607, 606605, 606748, 623098, 623096, 407984, 623094, 575226, 623092, 407981, 440940, 606670, 606667, 604359, 554407, 605347, 605344, 606701, 606699, 606710, 605342, 606663, 606594, 606683, 474213, 606592, 606649, 606640, 604944, 606637, 414225, 606589, 414220, 606503, 606544, 606235, 606488, 606482, 606195, 606469, 606410, 606455, 606453, 440862, 595614, 606232, 606229, 606223, 606221, 606186, 331386, 331384, 606198, 606169, 602035, 606145, 606107, 606099, 605810, 606097, 606095, 606118, 606090, 606111, 595598, 606115, 597225, 606036, 605993, 602997, 602715, 440831, 246692, 602995, 605909, 440810, 440799, 605840, 605838, 623087, 605847, 605804, 412558, 605606, 605604, 605798, 605593, 605794, 605781, 605707, 600478, 605747, 600464, 440765, 440760, 605697, 440741, 600450, 440735, 388371, 605551, 200921, 602540, 602514, 605501, 605488, 605332, 605471, 605469, 623084, 601749, 605174, 605217, 605128, 604404, 349615, 604343, 535442, 605074, 605071, 605063, 597405, 595589, 595586, 595583, 605004, 597399, 604663, 604269, 508164, 440626, 600967, 440604, 580215, 604937, 314796, 604728, 604909, 623082, 394074, 440588, 604704, 440586, 604897, 440583, 604804, 604800, 604791, 532821, 356068, 349233, 623080, 440540, 604742, 440530, 604699, 604697, 604167, 604651, 414205, 604647, 604638, 595578, 595572, 604499, 604486, 604457, 604437, 604317, 604151, 354515, 604147, 604143, 604141, 604215, 604136, 604258, 604133, 604130, 604120, 600949, 604112, 604098, 604076, 604074, 604024, 589666, 623074, 603370, 603898, 603368, 400758, 603886, 400756, 440421, 440417, 589664, 589660, 463015, 600928, 440360, 600415, 602840, 602660, 440344, 602658, 600674, 602351, 599981, 602348, 602346, 602472, 602467, 602287, 602336, 602323, 602317, 602202, 407978, 602064, 440301, 595101, 575843, 392959, 600338, 600335, 601424, 440266, 601419, 600115, 600111, 601389, 601792, 601743, 601741, 600324, 600321, 600316, 601415, 601607, 601604, 600846, 601601, 601465, 600309, 600306, 600304, 600297, 601495, 601387, 601385, 601384, 601381, 601372, 601370, 595556, 595549, 601357, 601353, 595545, 596800, 595542, 595540, 601297, 600855, 600826, 600783, 600809, 597654, 440189, 600654, 600605, 600560, 599208, 600515, 600525, 600485, 600271, 598560, 600265, 600107, 598882, 600014, 623062, 595187, 599972, 593117, 591780, 598724, 598721, 599881, 599879, 599883, 599877, 599762, 598999, 599708, 599634, 599631, 598318, 599681, 440012, 599241, 599627, 599612, 599586, 598976, 595173, 439973, 599437, 599278, 331372, 599413, 599411, 599402, 599229, 599224, 599263, 599217, 599213, 599197, 599194, 599192, 568991, 599151, 595166, 599148, 593562, 439926, 439922, 593559, 599116, 593739, 599098, 381102, 595527, 599062, 598701, 439895, 598916, 598869, 598581, 598782, 598771, 598746, 598744, 597647, 589485, 598632, 598691, 623052, 439849, 386076, 596781, 598549, 58700, 598528, 598515, 548401, 439829, 439817, 386069, 598397, 598378, 598375, 439788, 595514, 598308, 593182, 598296, 623029, 474800, 597910, 598137, 595507, 439727, 598124, 594722, 594720, 439723, 594712, 597668, 597950, 597944, 439699, 597877, 597874, 439695, 439693, 597820, 439682, 623025, 597789, 597774, 597728, 596886, 597767, 597755, 597725, 439663, 597740, 597736, 597716, 623019, 109227, 597666, 109222, 597664, 109220, 597674, 597671, 597662, 597658, 594818, 597592, 597298, 595055, 597600, 591113, 597578, 597566, 597536, 597529, 439589, 439583, 439581, 439577, 439557, 597494, 439546, 597476, 623006, 623004, 597345, 622995, 597381, 580150, 597340, 381088, 597334, 381075, 381073, 381071, 595501, 622992, 622990, 597220, 532535, 597218, 622988, 439537, 597215, 324416, 597213, 597211, 597208, 597198, 597289, 597295, 597073, 570423, 597043, 597041, 597284, 622985, 597274, 622983, 386052, 386050, 386048, 597192, 594777, 597190, 596877, 597167, 597169, 597146, 597143, 596950, 595496, 595495, 597127, 381058, 363087, 597059, 439522, 597054, 439520, 597046, 439509, 597001, 597009, 414178, 414176, 622973, 439490, 596995, 596970, 596962, 595492, 596944, 595489, 596941, 596940, 596934, 622968, 554287, 596896, 420390, 420388, 596862, 596867, 622964, 622962, 622959, 622957, 596796, 596793, 596783, 596718, 581333, 420967, 595134, 596619, 596611, 439385, 439382, 596601, 596499, 596482, 581328, 596473, 596478, 595487, 595482, 595396, 594692, 594628, 594625, 595322, 595312, 594528, 595269, 202366, 581276, 595264, 595132, 622952, 595222, 595257, 595220, 622945, 595214, 622941, 595123, 439299, 557011, 595082, 133280, 595109, 133278, 622937, 133267, 594955, 594951, 594948, 439282, 594907, 594903, 594703, 622928, 594844, 594833, 622926, 594864, 594830, 594828, 594806, 594708, 594729, 622921, 594701, 622919, 585301, 622917, 594544, 594553, 585299, 594497, 594328, 594309, 594262, 594259, 200862, 439185, 594212, 439171, 594207, 594204, 594201, 593480, 594185, 594197, 594183, 594181, 594175, 439169, 594162, 439167, 594159, 585291, 593792, 594116, 593783, 593956, 378178, 378176, 593819, 593846, 593732, 593570, 14204, 439047, 580122, 592422, 593386, 593300, 593298, 593273, 593261, 591757, 399398, 133252, 593055, 592971, 622841, 592937, 622837, 592679, 378164, 592565, 592534, 592530, 592471, 592412, 592461, 591826, 592349, 592347, 570646, 589959, 589957, 591821, 589953, 592335, 438949, 592257, 592238, 592262, 592260, 592255, 592178, 592253, 592244, 592235, 592159, 592199, 592157, 592154, 592152, 592150, 592148, 438932, 497511, 589949, 591934, 591864, 591859, 591928, 591855, 592035, 591989, 591941, 591939, 591923, 438881, 591664, 591661, 591842, 591840, 582088, 591837, 582085, 591798, 591790, 438864, 591738, 591740, 591736, 591648, 591644, 591694, 221951, 622826, 589334, 221945, 221941, 591610, 221931, 591555, 591553, 591542, 591551, 591571, 591546, 438860, 586624, 591063, 586622, 591540, 469987, 546805, 546803, 546801, 438840, 438836, 221919, 589936, 589931, 221917, 381046, 381041, 590424, 590421, 139602, 438828, 200841, 221913, 438793, 188901, 438762, 591286, 381037, 438756, 591284, 587549, 381032, 591282, 381030, 381027, 590855, 590853, 591202, 200839, 591200, 591198, 367712, 367710, 591257, 591252, 532138, 591250, 590417, 591247, 590415, 540668, 590413, 591178, 590233, 438720, 591152, 591105, 622812, 381023, 546793, 591102, 622808, 546788, 591141, 438677, 591098, 591013, 438671, 591059, 591056, 591073, 591070, 554545, 546784, 546782, 438618, 438616, 438592, 438590, 548355, 438587, 548319, 465450, 590446, 590444, 590438, 588922, 590374, 438452, 367696, 133241, 481816, 622769, 531993, 531991, 438408, 438401, 584845, 622731, 508448, 590173, 588614, 437887, 437840, 437825, 590026, 589859, 589943, 589633, 588548, 588546, 367692, 485987, 485981, 485978, 570382, 437743, 589206, 437734, 437729, 589615, 589594, 589592, 589613, 589590, 589379, 571073, 589609, 485976, 589583, 437693, 414168, 469056, 531818, 579626, 589407, 589402, 589400, 437275, 399374, 589273, 588707, 437255, 485974, 588702, 570375, 485971, 588696, 589059, 570359, 622626, 622610, 588612, 588610, 588608, 269093, 588524, 539542, 588536, 437172, 588482, 585735, 437093, 474207, 570272, 579544, 437029, 584353, 436995, 587576, 587047, 587552, 453703, 587406, 586010, 587043, 587529, 587403, 587526, 392219, 414166, 414165, 331361, 414160, 414158, 574412, 574410, 380999, 436851, 587327, 372020, 221733, 622566, 246094, 587262, 310055, 511661, 511658, 511656, 310051, 586951, 414156, 188887, 587140, 622535, 586946, 586945, 622532, 436652, 221704, 453699, 586619, 586617, 586614, 436523, 579507, 586501, 436521, 586497, 436515, 579505, 622504, 586349, 586347, 174359, 174356, 133222, 133219, 436395, 586077, 586075, 586073, 622464, 579433, 579424, 586066, 586063, 579421, 586060, 585712, 585748, 585732, 585730, 585710, 585727, 585725, 372011, 585402, 453686, 434944, 578263, 399350, 546776, 341135, 434775, 434754, 434751, 349577, 434734, 434731, 349575, 622181, 434610, 577370, 577364, 622142, 434433, 577299, 577297, 622136, 371961, 234604, 570245, 371959, 574409, 576250, 493615, 622110, 622108, 622104, 234587, 245454, 622102, 576259, 622089, 463009, 245407, 200455, 576170, 546061, 546059, 221137, 575830, 574986, 576092, 245301, 245298, 575916, 371944, 453675, 371942, 572623, 245258, 245256, 552287, 622061, 622059, 622057, 573963, 573880, 575709, 434053, 573960, 573958, 575706, 573955, 573953, 526408, 573950, 526406, 573948, 526399, 622035, 622033, 622030, 622024, 574116, 575338, 575336, 574509, 341491, 341489, 341485, 536503, 621998, 621993, 573808, 573946, 433909, 245181, 573944, 575065, 433895, 221037, 234390, 575048, 575046, 621986, 574773, 575023, 575018, 574769, 573943, 234328, 574897, 574983, 245169, 245167, 245165, 245161, 574856, 245155, 574501, 245151, 221027, 574498, 110616, 621962, 573941, 245130, 574766, 245128, 574764, 574762, 574494, 574406, 245122, 245119, 245117, 574760, 621959, 574737, 574735, 574753, 245105, 536065, 245103, 234287, 245101, 234285, 234283, 245098, 574751, 245095, 621956, 621954, 457219, 457217, 574745, 457212, 621952, 574732, 621950, 574730, 574727, 574650, 234277, 206122, 471296, 221018, 371921, 573877, 471288, 570831, 526393, 220998, 574490, 574486, 574483, 574403, 574203, 574201, 573113, 371918, 573110, 574397, 574394, 574392, 574390, 220993, 574388, 574517, 398382, 433720, 574193, 397444, 433712, 573939, 397441, 573936, 573927, 573924, 573922, 573919, 414127, 573917, 573915, 453665, 414124, 572460, 574142, 572039, 234160, 200385, 200383, 206118, 414115, 234156, 574318, 245057, 621931, 621929, 414109, 245049, 573912, 573909, 433657, 573906, 574161, 621926, 574112, 574110, 621924, 621922, 621920, 574154, 234093, 621916, 234069, 573787, 433609, 573785, 526359, 526351, 571302, 574004, 573269, 621912, 573904, 573265, 573902, 573263, 573258, 573900, 573898, 433570, 433567, 433564, 433561, 234040, 234037, 573896, 222433, 222429, 222427, 573893, 14201, 463005, 573891, 573889, 573968, 545408, 545406, 573887, 573885, 526348, 412379, 380947, 573424, 530343, 573873, 573871, 542788, 234022, 573828, 571300, 573766, 573747, 542786, 572068, 371914, 220967, 220964, 604014, 604012, 371911, 604010, 572062, 604007, 604005, 245035, 371907, 621910, 245028, 572780, 572777, 553077, 573432, 573430, 573414, 511617, 621902, 573380, 433495, 433492, 471966, 572016, 572014, 572807, 234000, 244993, 433488, 302016, 386000, 332240, 433482, 530246, 621891, 233969, 572669, 571028, 571026, 433398, 244901, 621884, 621874, 559105, 433383, 433381, 433379, 621869, 572572, 621862, 621859, 185697, 572206, 220924, 453656, 572451, 469960, 572003, 572449, 469958, 110594, 110590, 526340, 571757, 571961, 571951, 571944, 571942, 573601, 571936, 571906, 233891, 571904, 571898, 572192, 571894, 571892, 571890, 572139, 572189, 572187, 572182, 573579, 571886, 571884, 571871, 572115, 571869, 571866, 571861, 571857, 571855, 233881, 571853, 433163, 571851, 621812, 571849, 571840, 571834, 571831, 571829, 571826, 556856, 571820, 572049, 349553, 453652, 570043, 433098, 621800, 621796, 553040, 621794, 621792, 433072, 621787, 621785, 571390, 453650, 571293, 526297, 526288, 621730, 621722, 570330, 570328, 474198, 392186, 621703, 570809, 621673, 36118, 36116, 36114, 309644, 570037, 570035, 570901, 432842, 432836, 371897, 206090, 432782, 621604, 621600, 621598, 621596, 621594, 432778, 621592, 570641, 621590, 526284, 233765, 570604, 570600, 110562, 110557, 432745, 621574, 479037, 621571, 523201, 414106, 432731, 432728, 621562, 621560, 432720, 570494, 621556, 220752, 570428, 570420, 570426, 23509, 250901, 570312, 220719, 570307, 570254, 570291, 570252, 570289, 108843, 220682, 220680, 220678, 432655, 570221, 526255, 414105, 569906, 569904, 432636, 133121, 397362, 133115, 397360, 570022, 569988, 569986, 365367, 365365, 365363, 365356, 365354, 365351, 365346, 365342, 25394, 526217, 432328, 526215, 567293, 567291, 567287, 564829, 526176, 220433, 564822, 564821, 526162, 526160, 526151, 529574, 567279, 567271, 567302, 529552, 547793, 566099, 414085, 380840, 397621, 220120, 374342, 374340, 220116, 220115))
Run Time: 0.168518
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3541 | |
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 | | | | | 3541 | |
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 (35451, 35113, 35112, 35107, 35101, 35095, 35092, 35085, 35070, 35067, 35047, 34956, 34975, 34818, 34816, 34782, 34757, 34688, 34658, 34599, 34503, 34430, 34188, 34048, 33958, 33786, 33738, 33234, 33229, 33130, 33097, 33095, 32821, 32618, 32527, 32468, 32441, 32424, 32370, 32174, 31907, 31879, 31636, 31607, 31469, 31056, 30963, 30864, 30859, 30841, 30659, 30624, 30117, 30090, 30089, 30052, 29901, 29898, 29875))
Run Time: 0.004197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 59 | 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 (646196, 646169, 646108, 645920, 645914, 645842, 645794, 645782, 645723, 645470, 645327, 645242, 645234, 644981, 644953, 644952, 644950, 644949, 644910, 644876, 644873, 644869, 644853, 644827, 644779, 644677, 644676, 644671, 644641, 644628, 644626, 644623, 644552, 644539, 644538, 644513, 644512, 644461, 644460, 644385, 644132, 644116, 643980, 643882, 643836, 643812, 643801, 643795, 643770, 643758, 643754, 643719, 643669, 643653, 643652, 643610, 643609, 643559, 643536, 643507, 643468, 643466, 643404, 643401, 643243, 643129, 643127, 643058, 643023, 643022, 643012, 642962, 642945, 642931, 642904, 642795, 642787, 642675, 642672, 642663, 642662, 642618, 642490, 642489, 642444, 642304, 642300, 642229, 642228, 642196, 642105, 642099, 642098, 642029, 642018, 641983, 641928, 641814, 641790, 641768, 641763, 641676, 641658, 641654, 641628, 641627, 641623, 641619, 641616, 641615, 641612, 641363, 641362, 641279, 641204, 641137, 641136, 641044, 641015, 641009, 641001, 640991, 640980, 640978, 640976, 640969, 640967, 640965, 640964, 640959, 640958, 640952, 640942, 640937, 640933, 640923, 640898, 640884, 640880, 640878, 640876, 640875, 640874, 640872, 640867, 640856, 640845, 640843, 640841, 640825, 640807, 640261, 640804, 640757, 640686, 640683, 640661, 580764, 633948, 580762, 640500, 640620, 624246, 580756, 640495, 201206, 635408, 447665, 447663, 447649, 447614, 640487, 640293, 640433, 638499, 633659, 447555, 447552, 640327, 640205, 640232, 640125, 640102, 640052, 637598, 639513, 447511, 536597, 639482, 639688, 536590, 639967, 639478, 539592, 447461, 639473, 639960, 609687, 639951, 601758, 639460, 639770, 639457, 447380, 639670, 638142, 639780, 639453, 639638, 639590, 597259, 491353, 447323, 639493, 639389, 639387, 639385, 534894, 637432, 447281, 447276, 639318, 639333, 639256, 639316, 639272, 639266, 639264, 639262, 630898, 447208, 447178, 639155, 639193, 639148, 639133, 635151, 534876, 635143, 635140, 635127, 635124, 638964, 638913, 638911, 638906, 447118, 638920, 638738, 638765, 638728, 638819, 638757, 638723, 638774, 638688, 638680, 447089, 638671, 638609, 638614, 638600, 534863, 493683, 638595, 604422, 638540, 638377, 638482, 638480, 637682, 638475, 630275, 638472, 638470, 638466, 447079, 447059, 638414, 447055, 447050, 596409, 638402, 638436, 447046, 638399, 572552, 447039, 623336, 447015, 638363, 638357, 638341, 447003, 447001, 446996, 580692, 638307, 638314, 638291, 638190, 633728, 638188, 638269, 638245, 638131, 638234, 638182, 638009, 596394, 446940, 637958, 637945, 637940, 637973, 637938, 637955, 630270, 612886, 612882, 612878, 637590, 637885, 612876, 637588, 623334, 612875, 446913, 637848, 446910, 637785, 637774, 637745, 637758, 612871, 446895, 612352, 612868, 637644, 637647, 637640, 446857, 637544, 637458, 637429, 612859, 637349, 637384, 637382, 637373, 446802, 626146, 623331, 637254, 637113, 637245, 637239, 633472, 637212, 446758, 637132, 636721, 629977, 636717, 637082, 636587, 636980, 446721, 636909, 636941, 596344, 636922, 636919, 636898, 636855, 636905, 636853, 636851, 636850, 623543, 623541, 636836, 596336, 623328, 636810, 596334, 453170, 309832, 309828, 624243, 596330, 596326, 596324, 596322, 596320, 636715, 597258, 636741, 636733, 635102, 636700, 636706, 636059, 636689, 453167, 636557, 623326, 636666, 636664, 636661, 446694, 446683, 589712, 633816, 636657, 636635, 446681, 636612, 446674, 636584, 636581, 636572, 636570, 446670, 608518, 636534, 636485, 636480, 636459, 636456, 636478, 636493, 636474, 636472, 636414, 446643, 630249, 636412, 446633, 636345, 630325, 606239, 446629, 636343, 636341, 636282, 446626, 636320, 446621, 571348, 446599, 571346, 571343, 606395, 571340, 636196, 636230, 636188, 596260, 636184, 446525, 636134, 634957, 636111, 446492, 571200, 596256, 571198, 571338, 603021, 603018, 599359, 603014, 635951, 189138, 636039, 636041, 636037, 453813, 636012, 636005, 453811, 635916, 571187, 635780, 635912, 596252, 571184, 596245, 571181, 635891, 571178, 635889, 635818, 609072, 635869, 627740, 628793, 635863, 596240, 635814, 635810, 635845, 635807, 628788, 623322, 635361, 635616, 635624, 632253, 635657, 635730, 635746, 453164, 635581, 247192, 635356, 629962, 635259, 110769, 605430, 635354, 635352, 635309, 635306, 446394, 608508, 635247, 446378, 635081, 446363, 623315, 635208, 446361, 623313, 635050, 634996, 463019, 634962, 446357, 634974, 634971, 610302, 610300, 634893, 634871, 610297, 634869, 634867, 634815, 634865, 634809, 634779, 634877, 634818, 189240, 446340, 634788, 446331, 634671, 634750, 634743, 386100, 634740, 596181, 634720, 634661, 634659, 634657, 634648, 634595, 634588, 634592, 634548, 634558, 634551, 446298, 601163, 634482, 634527, 634491, 634480, 634391, 634487, 381165, 634458, 446296, 634432, 634434, 634416, 630204, 629949, 634301, 634358, 634327, 634347, 634313, 596177, 634295, 601156, 634258, 634262, 453161, 453159, 634096, 634183, 552104, 634162, 634093, 634150, 627601, 610290, 610288, 634120, 634118, 634066, 634064, 634054, 634045, 602479, 602477, 634043, 634038, 592736, 633572, 633990, 605253, 633836, 633834, 633799, 632769, 605237, 601148, 633832, 446231, 633781, 633778, 623310, 633663, 446211, 633655, 633613, 599528, 599526, 446198, 633565, 536414, 633470, 633468, 633479, 632946, 536412, 633029, 446167, 633215, 633213, 446164, 584037, 596124, 633328, 633430, 410152, 633457, 633287, 633349, 633196, 633190, 633185, 633257, 633278, 633182, 633149, 633179, 373558, 410150, 589709, 396216, 633160, 396214, 396212, 633072, 396210, 534551, 633070, 633015, 632245, 201169, 608350, 632970, 632964, 632988, 632904, 632857, 632889, 632887, 446023, 446017, 518983, 445994, 632789, 632763, 632729, 629910, 632726, 632226, 609963, 609958, 632701, 632694, 632692, 631599, 534508, 632651, 627254, 632633, 632627, 632625, 632623, 632612, 632608, 632596, 632385, 632591, 632502, 632499, 632528, 632380, 632349, 632411, 632446, 632343, 625897, 625894, 453806, 247120, 632238, 609957, 632236, 632192, 632270, 632182, 189122, 189120, 386526, 609118, 373136, 410147, 625891, 632142, 410145, 629397, 632034, 632000, 630987, 630984, 631993, 631873, 596093, 457267, 631785, 631828, 631818, 627925, 631713, 631762, 586610, 630950, 445750, 445745, 631205, 631638, 445737, 445727, 631319, 631313, 631307, 631266, 627907, 631096, 609952, 607476, 631048, 631024, 410142, 631009, 612591, 612586, 630905, 601124, 379340, 630902, 589693, 589686, 589684, 630887, 607442, 572782, 630828, 630826, 630820, 613659, 607434, 630319, 381153, 630575, 453791, 630517, 381150, 630497, 247086, 630495, 381148, 630493, 445512, 381146, 630489, 629879, 381144, 596071, 596065, 630304, 630302, 629708, 629862, 110752, 445467, 629716, 629737, 629782, 629704, 629702, 534391, 185364, 629646, 551783, 551780, 551777, 612581, 612575, 612573, 612571, 420418, 445383, 612569, 612567, 629188, 629189, 445352, 629541, 629416, 629551, 580513, 580512, 629517, 614891, 629384, 629371, 623294, 629365, 629356, 629344, 629024, 629324, 612307, 629292, 534361, 624144, 201132, 629260, 605826, 605824, 585601, 585599, 629183, 445299, 629083, 247017, 629080, 534331, 462505, 189089, 580481, 629050, 601110, 623292, 386092, 628979, 628962, 628948, 628930, 571333, 596028, 628835, 628826, 605229, 606391, 628813, 628754, 626584, 628726, 628712, 628718, 628692, 628675, 628519, 628501, 607019, 445257, 628464, 628456, 628452, 628430, 628385, 628418, 607394, 628377, 445243, 623286, 445238, 445235, 628366, 246996, 246994, 628363, 628361, 628359, 445213, 445208, 445206, 445203, 445200, 445196, 453782, 601094, 445194, 628333, 628328, 605682, 628324, 605680, 605676, 628294, 453774, 412581, 453772, 628221, 445180, 578484, 578482, 628278, 628273, 628271, 628245, 445165, 627524, 627521, 578476, 628209, 623281, 628166, 628162, 623279, 623277, 623275, 628127, 623273, 628144, 628102, 628093, 626081, 596005, 628046, 628042, 624241, 628008, 627941, 627851, 627994, 189083, 627903, 627897, 627889, 627936, 625317, 627823, 627815, 627812, 627834, 595996, 589315, 627808, 627801, 627827, 589313, 595985, 627794, 201086, 627480, 627778, 627533, 627768, 627471, 627469, 627711, 627697, 627236, 627233, 627685, 627648, 627683, 627680, 605669, 609313, 445091, 445088, 627654, 599341, 627639, 627615, 445042, 599338, 599335, 627611, 627609, 627586, 627604, 627530, 627430, 466842, 615543, 445027, 626216, 627402, 615541, 627422, 445021, 615537, 604418, 627383, 595979, 616301, 627361, 627359, 627354, 627341, 571331, 627226, 627119, 414274, 627205, 444981, 624213, 627191, 627083, 444952, 627016, 627020, 444945, 444943, 444938, 626984, 626950, 626934, 626932, 626927, 626923, 626873, 444932, 626871, 626897, 607938, 444929, 626869, 626862, 444923, 603410, 626809, 626803, 444909, 626736, 626723, 611101, 611099, 611097, 611095, 611093, 626598, 611091, 572544, 626579, 189073, 35137, 626493, 35135, 35131, 626474, 626478, 626481, 626449, 626446, 626444, 626428, 589296, 626426, 607927, 606383, 626379, 444842, 626359, 615791, 626341, 444810, 613414, 607389, 444794, 626332, 607385, 444790, 626334, 626329, 444788, 626327, 589670, 626324, 625928, 444768, 571329, 595952, 571327, 595949, 626304, 626302, 626280, 626265, 626263, 626278, 625633, 406512, 406510, 626203, 571325, 571323, 571321, 616090, 391988, 626187, 626180, 626172, 444727, 571319, 571317, 22838, 626086, 571315, 626094, 444723, 444721, 626076, 626072, 571312, 626044, 625983, 625946, 611437, 444690, 625944, 534243, 625887, 625831, 625881, 625787, 444657, 625829, 625411, 444655, 625853, 625825, 625837, 625629, 625742, 625627, 444595, 625755, 444544, 444541, 444530, 625591, 625588, 625705, 625585, 372050, 625663, 625670, 625659, 625652, 625647, 625644, 625614, 189057, 611423, 444474, 625528, 625539, 625525, 625506, 625515, 625512, 625335, 625475, 625471, 625469, 625466, 625431, 625420, 625324, 610253, 610243, 625270, 625345, 625237, 625224, 625234, 444335, 444332, 595933, 482294, 625175, 625135, 623980, 610238, 625150, 610236, 444275, 615088, 616297, 624378, 444217, 615915, 444170, 444159, 624281, 614260, 623266, 605655, 624208, 624205, 624202, 624197, 615782, 580351, 607372, 624002, 623975, 623972, 623884, 623908, 534017, 623930, 623923, 623900, 444056, 601074, 616144, 324421, 623878, 608545, 623867, 623874, 623872, 601069, 444014, 595281, 623804, 595279, 623830, 623818, 623822, 595916, 595911, 443982, 443979, 443977, 624096, 623792, 443929, 443923, 623774, 443901, 35129, 443898, 35127, 623263, 623258, 623443, 623256, 615911, 623684, 623681, 623248, 623670, 443844, 443820, 603011, 594323, 443786, 607601, 607599, 623584, 623581, 623523, 623509, 623506, 443760, 601060, 443742, 624082, 623393, 624079, 443737, 624073, 443735, 443733, 623364, 443729, 443726, 616320, 624067, 616317, 623245, 616254, 616251, 616291, 624060, 616282, 608440, 616151, 616227, 616223, 616219, 616197, 549766, 616189, 616050, 616167, 180980, 616122, 616099, 616048, 616020, 616046, 616044, 616042, 616040, 616038, 616032, 616029, 616027, 201037, 616016, 616005, 583193, 615932, 615927, 615924, 615938, 580335, 595877, 615922, 615876, 443498, 609375, 607595, 615709, 615776, 615765, 443431, 580325, 607873, 592161, 356084, 615616, 349940, 615478, 615471, 615466, 615523, 615521, 443267, 615413, 615410, 615507, 615403, 615400, 615367, 615352, 615350, 613749, 614923, 614993, 443102, 443099, 443091, 607017, 608543, 607015, 608541, 443054, 443052, 614865, 614862, 604736, 623227, 608539, 614874, 614823, 442973, 457963, 614782, 607010, 607002, 623224, 613911, 613820, 613817, 442790, 442780, 442778, 614056, 613712, 623221, 442706, 613897, 614002, 608435, 613709, 613707, 613705, 613863, 609372, 613305, 613847, 610202, 610200, 613763, 613788, 613724, 613721, 608937, 613604, 613600, 612704, 608930, 613502, 613231, 613494, 613487, 607503, 604708, 609226, 608432, 608425, 442544, 605324, 607500, 605321, 606353, 605319, 609847, 613329, 580258, 580254, 613302, 613300, 613313, 580244, 613297, 597256, 613200, 612994, 613191, 442455, 442451, 533560, 442450, 613170, 613095, 442437, 605315, 600084, 609822, 613045, 607365, 442392, 442361, 442354, 607362, 442353, 442342, 623210, 612978, 188959, 442333, 612955, 612973, 442323, 612971, 612949, 533517, 612817, 442303, 612815, 612929, 442288, 612564, 612562, 612560, 612912, 442200, 612908, 612906, 593711, 614964, 606225, 612902, 609810, 612811, 609808, 606838, 609806, 612780, 612819, 612794, 612791, 612777, 612750, 442166, 442161, 612775, 442159, 606338, 442153, 612762, 610712, 595826, 612727, 610710, 609368, 603128, 609365, 612534, 609363, 609361, 612531, 632780, 632778, 609359, 632776, 612671, 612669, 612637, 608919, 612613, 608914, 612610, 611385, 598566, 442084, 604276, 606336, 612558, 612556, 612554, 612552, 612550, 601001, 612267, 442053, 611364, 611361, 612537, 608910, 610708, 608908, 612508, 610706, 610704, 606325, 610702, 612426, 604199, 442012, 612424, 612491, 612422, 612420, 612418, 612416, 595818, 595811, 612400, 441987, 608902, 612383, 605387, 595800, 612208, 612288, 612074, 493224, 612072, 493222, 612112, 441939, 612065, 612045, 612037, 414261, 493197, 414258, 441900, 612019, 612012, 611978, 611981, 392232, 608203, 611926, 606996, 611910, 611867, 595793, 611865, 611839, 611834, 611800, 611831, 611787, 611675, 590083, 207578, 207575, 611597, 207573, 207571, 604668, 611549, 608761, 611581, 608759, 611594, 608747, 605366, 611543, 611552, 611537, 611528, 611514, 611512, 611496, 200988, 623206, 623204, 623202, 605307, 611309, 493195, 140331, 605293, 611072, 610698, 610696, 610694, 611224, 611153, 400765, 610693, 441648, 441638, 623200, 611125, 611050, 611066, 611063, 441632, 611116, 608345, 623198, 610936, 610691, 608197, 441594, 595770, 441578, 441574, 610959, 610926, 441567, 610892, 157336, 597982, 441543, 441521, 472709, 623192, 610793, 623189, 623187, 623184, 597371, 246728, 597369, 610783, 597367, 610780, 610851, 610778, 610771, 578250, 610769, 623176, 604001, 610657, 610655, 610519, 610653, 610517, 611764, 610588, 610639, 610636, 610593, 610632, 610575, 610627, 610558, 610556, 610620, 610568, 610532, 610430, 610427, 610424, 623169, 623167, 610422, 610497, 623165, 623163, 623159, 608085, 611750, 611745, 611740, 611737, 610451, 611729, 611721, 610383, 610374, 381137, 381135, 599849, 608562, 602851, 599842, 608559, 602848, 381131, 599840, 611712, 602845, 381129, 600989, 298159, 381127, 609773, 455498, 610175, 610163, 455491, 466835, 396205, 610139, 610131, 610129, 610127, 396203, 610095, 610093, 610001, 396199, 610073, 414237, 610081, 396197, 533132, 610069, 609999, 608229, 609754, 609751, 609748, 533125, 533124, 303000, 610055, 441341, 381124, 610051, 381122, 302997, 381120, 533119, 381118, 610048, 441335, 508031, 508029, 609992, 597243, 609664, 623153, 609745, 441319, 623150, 609741, 441316, 609736, 609662, 396190, 597241, 597238, 609659, 609681, 396187, 609696, 396185, 596599, 396183, 609678, 609094, 609694, 609657, 396173, 609655, 414235, 609464, 609549, 609492, 609488, 312225, 609457, 609454, 597115, 481385, 609245, 609307, 609406, 609330, 623145, 609243, 623143, 609213, 609211, 601965, 609285, 608410, 609240, 605358, 609238, 609236, 608893, 607581, 386082, 609234, 609188, 598030, 608407, 609208, 623141, 609232, 607577, 607575, 623136, 133332, 578101, 133330, 623134, 578099, 623131, 609141, 400762, 609139, 609137, 580225, 476642, 609012, 595704, 609017, 609010, 609029, 595701, 609007, 609004, 608965, 608834, 608978, 441236, 608789, 594559, 600982, 608715, 608707, 608392, 608385, 608383, 608528, 608525, 608523, 608367, 608363, 608277, 608275, 600806, 623121, 35119, 35117, 608300, 441174, 441172, 608227, 441168, 608133, 608121, 608119, 608145, 608223, 608041, 608032, 133320, 607726, 133316, 607966, 607643, 623118, 607639, 607637, 607635, 607790, 607630, 453734, 395384, 412562, 607698, 607674, 623116, 607647, 623114, 607613, 607588, 607566, 607564, 623110, 35115, 607529, 607524, 607522, 35113, 441089, 607341, 589668, 441078, 441075, 441073, 607323, 607271, 607330, 377212, 607302, 623107, 607238, 623104, 600979, 606995, 441050, 441041, 607071, 607210, 606011, 606010, 607182, 441013, 606993, 606988, 606951, 607102, 476639, 605096, 35107, 582888, 607079, 440999, 606985, 606982, 607041, 440997, 606979, 601392, 603005, 604175, 604173, 606976, 606971, 604170, 603003, 440986, 603000, 606943, 606875, 606925, 440981, 440979, 606873, 606920, 440975, 606915, 35104, 35102, 35099, 606886, 606884, 606881, 381112, 605065, 606864, 606789, 606827, 554415, 606825, 606001, 606785, 606317, 606315, 440952, 606049, 606047, 606045, 606796, 440944, 606609, 595640, 595638, 606607, 606605, 606748, 623098, 623096, 407984, 623094, 575226, 623092, 407981, 440940, 606670, 606667, 604359, 554407, 605347, 605344, 606701, 606699, 606710, 605342, 606663, 606594, 606683, 474213, 606592, 606649, 606640, 604944, 606637, 414225, 606589, 414220, 606503, 606544, 606235, 606488, 606482, 606195, 606469, 606410, 606455, 606453, 440862, 595614, 606232, 606229, 606223, 606221, 606186, 331386, 331384, 606198, 606169, 602035, 606145, 606107, 606099, 605810, 606097, 606095, 606118, 606090, 606111, 595598, 606115, 597225, 606036, 605993, 602997, 602715, 440831, 246692, 602995, 605909, 440810, 440799, 605840, 605838, 623087, 605847, 605804, 412558, 605606, 605604, 605798, 605593, 605794, 605781, 605707, 600478, 605747, 600464, 440765, 440760, 605697, 440741, 600450, 440735, 388371, 605551, 200921, 602540, 602514, 605501, 605488, 605332, 605471, 605469, 623084, 601749, 605174, 605217, 605128, 604404, 349615, 604343, 535442, 605074, 605071, 605063, 597405, 595589, 595586, 595583, 605004, 597399, 604663, 604269, 508164, 440626, 600967, 440604, 580215, 604937, 314796, 604728, 604909, 623082, 394074, 440588, 604704, 440586, 604897, 440583, 604804, 604800, 604791, 532821, 356068, 349233, 623080, 440540, 604742, 440530, 604699, 604697, 604167, 604651, 414205, 604647, 604638, 595578, 595572, 604499, 604486, 604457, 604437, 604317, 604151, 354515, 604147, 604143, 604141, 604215, 604136, 604258, 604133, 604130, 604120, 600949, 604112, 604098, 604076, 604074, 604024, 589666, 623074, 603370, 603898, 603368, 400758, 603886, 400756, 440421, 440417, 589664, 589660, 463015, 600928, 440360, 600415, 602840, 602660, 440344, 602658, 600674, 602351, 599981, 602348, 602346, 602472, 602467, 602287, 602336, 602323, 602317, 602202, 407978, 602064, 440301, 595101, 575843, 392959, 600338, 600335, 601424, 440266, 601419, 600115, 600111, 601389, 601792, 601743, 601741, 600324, 600321, 600316, 601415, 601607, 601604, 600846, 601601, 601465, 600309, 600306, 600304, 600297, 601495, 601387, 601385, 601384, 601381, 601372, 601370, 595556, 595549, 601357, 601353, 595545, 596800, 595542, 595540, 601297, 600855, 600826, 600783, 600809, 597654, 440189, 600654, 600605, 600560, 599208, 600515, 600525, 600485, 600271, 598560, 600265, 600107, 598882, 600014, 623062, 595187, 599972, 593117, 591780, 598724, 598721, 599881, 599879, 599883, 599877, 599762, 598999, 599708, 599634, 599631, 598318, 599681, 440012, 599241, 599627, 599612, 599586, 598976, 595173, 439973, 599437, 599278, 331372, 599413, 599411, 599402, 599229, 599224, 599263, 599217, 599213, 599197, 599194, 599192, 568991, 599151, 595166, 599148, 593562, 439926, 439922, 593559, 599116, 593739, 599098, 381102, 595527, 599062, 598701, 439895, 598916, 598869, 598581, 598782, 598771, 598746, 598744, 597647, 589485, 598632, 598691, 623052, 439849, 386076, 596781, 598549, 58700, 598528, 598515, 548401, 439829, 439817, 386069, 598397, 598378, 598375, 439788, 595514, 598308, 593182, 598296, 623029, 474800, 597910, 598137, 595507, 439727, 598124, 594722, 594720, 439723, 594712, 597668, 597950, 597944, 439699, 597877, 597874, 439695, 439693, 597820, 439682, 623025, 597789, 597774, 597728, 596886, 597767, 597755, 597725, 439663, 597740, 597736, 597716, 623019, 109227, 597666, 109222, 597664, 109220, 597674, 597671, 597662, 597658, 594818, 597592, 597298, 595055, 597600, 591113, 597578, 597566, 597536, 597529, 439589, 439583, 439581, 439577, 439557, 597494, 439546, 597476, 623006, 623004, 597345, 622995, 597381, 580150, 597340, 381088, 597334, 381075, 381073, 381071, 595501, 622992, 622990, 597220, 532535, 597218, 622988, 439537, 597215, 324416, 597213, 597211, 597208, 597198, 597289, 597295, 597073, 570423, 597043, 597041, 597284, 622985, 597274, 622983, 386052, 386050, 386048, 597192, 594777, 597190, 596877, 597167, 597169, 597146, 597143, 596950, 595496, 595495, 597127, 381058, 363087, 597059, 439522, 597054, 439520, 597046, 439509, 597001, 597009, 414178, 414176, 622973, 439490, 596995, 596970, 596962, 595492, 596944, 595489, 596941, 596940, 596934, 622968, 554287, 596896, 420390, 420388, 596862, 596867, 622964, 622962, 622959, 622957, 596796, 596793, 596783, 596718, 581333, 420967, 595134, 596619, 596611, 439385, 439382, 596601, 596499, 596482, 581328, 596473, 596478, 595487, 595482, 595396, 594692, 594628, 594625, 595322, 595312, 594528, 595269, 202366, 581276, 595264, 595132, 622952, 595222, 595257, 595220, 622945, 595214, 622941, 595123, 439299, 557011, 595082, 133280, 595109, 133278, 622937, 133267, 594955, 594951, 594948, 439282, 594907, 594903, 594703, 622928, 594844, 594833, 622926, 594864, 594830, 594828, 594806, 594708, 594729, 622921, 594701, 622919, 585301, 622917, 594544, 594553, 585299, 594497, 594328, 594309, 594262, 594259, 200862, 439185, 594212, 439171, 594207, 594204, 594201, 593480, 594185, 594197, 594183, 594181, 594175, 439169, 594162, 439167, 594159, 585291, 593792, 594116, 593783, 593956, 378178, 378176, 593819, 593846, 593732, 593570, 14204, 439047, 580122, 592422, 593386, 593300, 593298, 593273, 593261, 591757, 399398, 133252, 593055, 592971, 622841, 592937, 622837, 592679, 378164, 592565, 592534, 592530, 592471, 592412, 592461, 591826, 592349, 592347, 570646, 589959, 589957, 591821, 589953, 592335, 438949, 592257, 592238, 592262, 592260, 592255, 592178, 592253, 592244, 592235, 592159, 592199, 592157, 592154, 592152, 592150, 592148, 438932, 497511, 589949, 591934, 591864, 591859, 591928, 591855, 592035, 591989, 591941, 591939, 591923, 438881, 591664, 591661, 591842, 591840, 582088, 591837, 582085, 591798, 591790, 438864, 591738, 591740, 591736, 591648, 591644, 591694, 221951, 622826, 589334, 221945, 221941, 591610, 221931, 591555, 591553, 591542, 591551, 591571, 591546, 438860, 586624, 591063, 586622, 591540, 469987, 546805, 546803, 546801, 438840, 438836, 221919, 589936, 589931, 221917, 381046, 381041, 590424, 590421, 139602, 438828, 200841, 221913, 438793, 188901, 438762, 591286, 381037, 438756, 591284, 587549, 381032, 591282, 381030, 381027, 590855, 590853, 591202, 200839, 591200, 591198, 367712, 367710, 591257, 591252, 532138, 591250, 590417, 591247, 590415, 540668, 590413, 591178, 590233, 438720, 591152, 591105, 622812, 381023, 546793, 591102, 622808, 546788, 591141, 438677, 591098, 591013, 438671, 591059, 591056, 591073, 591070, 554545, 546784, 546782, 438618, 438616, 438592, 438590, 548355, 438587, 548319, 465450, 590446, 590444, 590438, 588922, 590374, 438452, 367696, 133241, 481816, 622769, 531993, 531991, 438408, 438401, 584845, 622731, 508448, 590173, 588614, 437887, 437840, 437825, 590026, 589859, 589943, 589633, 588548, 588546, 367692, 485987, 485981, 485978, 570382, 437743, 589206, 437734, 437729, 589615, 589594, 589592, 589613, 589590, 589379, 571073, 589609, 485976, 589583, 437693, 414168, 469056, 531818, 579626, 589407, 589402, 589400, 437275, 399374, 589273, 588707, 437255, 485974, 588702, 570375, 485971, 588696, 589059, 570359, 622626, 622610, 588612, 588610, 588608, 269093, 588524, 539542, 588536, 437172, 588482, 585735, 437093, 474207, 570272, 579544, 437029, 584353, 436995, 587576, 587047, 587552, 453703, 587406, 586010, 587043, 587529, 587403, 587526, 392219, 414166, 414165, 331361, 414160, 414158, 574412, 574410, 380999, 436851, 587327, 372020, 221733, 622566, 246094, 587262, 310055, 511661, 511658, 511656, 310051, 586951, 414156, 188887, 587140, 622535, 586946, 586945, 622532, 436652, 221704, 453699, 586619, 586617, 586614, 436523, 579507, 586501, 436521, 586497, 436515, 579505, 622504, 586349, 586347, 174359, 174356, 133222, 133219, 436395, 586077, 586075, 586073, 622464, 579433, 579424, 586066, 586063, 579421, 586060, 585712, 585748, 585732, 585730, 585710, 585727, 585725, 372011, 585402, 453686, 434944, 578263, 399350, 546776, 341135, 434775, 434754, 434751, 349577, 434734, 434731, 349575, 622181, 434610, 577370, 577364, 622142, 434433, 577299, 577297, 622136, 371961, 234604, 570245, 371959, 574409, 576250, 493615, 622110, 622108, 622104, 234587, 245454, 622102, 576259, 622089, 463009, 245407, 200455, 576170, 546061, 546059, 221137, 575830, 574986, 576092, 245301, 245298, 575916, 371944, 453675, 371942, 572623, 245258, 245256, 552287, 622061, 622059, 622057, 573963, 573880, 575709, 434053, 573960, 573958, 575706, 573955, 573953, 526408, 573950, 526406, 573948, 526399, 622035, 622033, 622030, 622024, 574116, 575338, 575336, 574509, 341491, 341489, 341485, 536503, 621998, 621993, 573808, 573946, 433909, 245181, 573944, 575065, 433895, 221037, 234390, 575048, 575046, 621986, 574773, 575023, 575018, 574769, 573943, 234328, 574897, 574983, 245169, 245167, 245165, 245161, 574856, 245155, 574501, 245151, 221027, 574498, 110616, 621962, 573941, 245130, 574766, 245128, 574764, 574762, 574494, 574406, 245122, 245119, 245117, 574760, 621959, 574737, 574735, 574753, 245105, 536065, 245103, 234287, 245101, 234285, 234283, 245098, 574751, 245095, 621956, 621954, 457219, 457217, 574745, 457212, 621952, 574732, 621950, 574730, 574727, 574650, 234277, 206122, 471296, 221018, 371921, 573877, 471288, 570831, 526393, 220998, 574490, 574486, 574483, 574403, 574203, 574201, 573113, 371918, 573110, 574397, 574394, 574392, 574390, 220993, 574388, 574517, 398382, 433720, 574193, 397444, 433712, 573939, 397441, 573936, 573927, 573924, 573922, 573919, 414127, 573917, 573915, 453665, 414124, 572460, 574142, 572039, 234160, 200385, 200383, 206118, 414115, 234156, 574318, 245057, 621931, 621929, 414109, 245049, 573912, 573909, 433657, 573906, 574161, 621926, 574112, 574110, 621924, 621922, 621920, 574154, 234093, 621916, 234069, 573787, 433609, 573785, 526359, 526351, 571302, 574004, 573269, 621912, 573904, 573265, 573902, 573263, 573258, 573900, 573898, 433570, 433567, 433564, 433561, 234040, 234037, 573896, 222433, 222429, 222427, 573893, 14201, 463005, 573891, 573889, 573968, 545408, 545406, 573887, 573885, 526348, 412379, 380947, 573424, 530343, 573873, 573871, 542788, 234022, 573828, 571300, 573766, 573747, 542786, 572068, 371914, 220967, 220964, 604014, 604012, 371911, 604010, 572062, 604007, 604005, 245035, 371907, 621910, 245028, 572780, 572777, 553077, 573432, 573430, 573414, 511617, 621902, 573380, 433495, 433492, 471966, 572016, 572014, 572807, 234000, 244993, 433488, 302016, 386000, 332240, 433482, 530246, 621891, 233969, 572669, 571028, 571026, 433398, 244901, 621884, 621874, 559105, 433383, 433381, 433379, 621869, 572572, 621862, 621859, 185697, 572206, 220924, 453656, 572451, 469960, 572003, 572449, 469958, 110594, 110590, 526340, 571757, 571961, 571951, 571944, 571942, 573601, 571936, 571906, 233891, 571904, 571898, 572192, 571894, 571892, 571890, 572139, 572189, 572187, 572182, 573579, 571886, 571884, 571871, 572115, 571869, 571866, 571861, 571857, 571855, 233881, 571853, 433163, 571851, 621812, 571849, 571840, 571834, 571831, 571829, 571826, 556856, 571820, 572049, 349553, 453652, 570043, 433098, 621800, 621796, 553040, 621794, 621792, 433072, 621787, 621785, 571390, 453650, 571293, 526297, 526288, 621730, 621722, 570330, 570328, 474198, 392186, 621703, 570809, 621673, 36118, 36116, 36114, 309644, 570037, 570035, 570901, 432842, 432836, 371897, 206090, 432782, 621604, 621600, 621598, 621596, 621594, 432778, 621592, 570641, 621590, 526284, 233765, 570604, 570600, 110562, 110557, 432745, 621574, 479037, 621571, 523201, 414106, 432731, 432728, 621562, 621560, 432720, 570494, 621556, 220752, 570428, 570420, 570426, 23509, 250901, 570312, 220719, 570307, 570254, 570291, 570252, 570289, 108843, 220682, 220680, 220678, 432655, 570221, 526255, 414105, 569906, 569904, 432636, 133121, 397362, 133115, 397360, 570022, 569988, 569986, 365367, 365365, 365363, 365356, 365354, 365351, 365346, 365342, 25394, 526217, 432328, 526215, 567293, 567291, 567287, 564829, 526176, 220433, 564822, 564821, 526162, 526160, 526151, 529574, 567279, 567271, 567302, 529552, 547793, 566099, 414085, 380840, 397621, 220120, 374342, 374340, 220116, 220115))
Run Time: 0.069220
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3541 | |
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 | | | | | 3541 | |
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 (35451, 35113, 35112, 35107, 35101, 35095, 35092, 35085, 35070, 35067, 35047, 34956, 34975, 34818, 34816, 34782, 34757, 34688, 34658, 34599, 34503, 34430, 34188, 34048, 33958, 33786, 33738, 33234, 33229, 33130, 33097, 33095, 32821, 32618, 32527, 32468, 32441, 32424, 32370, 32174, 31907, 31879, 31636, 31607, 31469, 31056, 30963, 30864, 30859, 30841, 30659, 30624, 30117, 30090, 30089, 30052, 29901, 29898, 29875))
Run Time: 0.002083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 59 | 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.000198
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=9178, 1716234532, , 0, ��[
Run Time: 0.000134
- 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.000359
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.000578
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: 1716234232
Run Time: 0.000415
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 44 | 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` >= 1716234232)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000636
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 44 | 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