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.000576
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.000241
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` = '6623')
LIMIT 1
Run Time: 0.000400
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.002206
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_6623' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.080686
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_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 (34860, 33265, 33263, 32611, 32459, 32004, 31904, 31846, 31742, 31725, 31716, 31556, 31527, 31459, 25357, 24962, 24961, 24884))
Run Time: 0.002251
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 18 | 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 (453822, 637769, 629875, 625141, 444603, 453758, 611418, 444486, 444480, 444475, 444471, 625524, 625336, 625478, 625476, 625372, 444396, 444393, 625326, 625321, 602050, 580365, 580358, 201058, 444320, 625129, 625125, 329405, 534139, 443711, 615036, 613750, 615029, 611296, 611291, 611289, 611288, 611286, 611283, 533513, 611282, 611280, 611277, 442075, 611373, 609519, 354527, 200993, 611931, 611501, 533296, 611241, 610903, 441643, 441641, 441619, 441596, 441593, 441591, 441584, 441568, 441556, 441554, 441550, 533209, 441468, 533163, 533154, 325901, 602738, 440779, 356073, 189234, 189228, 599495, 603385, 600938, 602655, 602772, 602770, 601727, 601725, 601723, 601720, 601380, 601345, 600813, 554351, 600551, 596551, 623066, 554346, 440134, 440130, 440117, 440112, 440110, 440102, 440100, 600031, 440097, 440095, 600026, 599969, 440088, 599942, 599940, 393240, 597848, 599902, 200890, 599866, 599821, 599813, 599810, 440083, 599805, 440079, 599782, 599760, 598345, 598343, 469421, 554344, 566801, 598338, 200889, 590051, 599702, 598322, 189218, 598316, 189215, 354512, 440063, 599672, 580180, 599544, 330538, 599540, 580178, 580176, 596441, 580172, 349610, 349608, 599452, 349606, 349601, 597628, 200886, 392942, 392937, 439955, 599409, 599147, 439899, 594156, 598789, 453728, 598503, 598499, 598497, 598494, 598544, 598488, 517453, 517451, 598486, 517447, 554335, 396527, 439824, 439822, 329387, 396524, 439800, 598361, 598280, 598278, 439754, 554296, 598253, 439749, 439746, 439744, 597916, 439742, 597914, 439738, 592424, 597904, 597900, 597897, 597892, 598133, 597890, 598131, 200871, 597959, 597958, 597955, 597952, 439676, 439674, 439672, 439670, 439667, 597741, 554291, 597721, 596436, 596433, 200866, 439646, 439644, 439637, 439634, 439619, 594192, 594189, 325898, 597534, 623008, 133290, 133287, 623005, 623003, 623001, 133282, 622999, 622997, 597386, 597383, 585306, 594688, 585304, 381086, 381084, 381081, 597212, 597209, 597206, 597200, 596490, 386058, 597151, 622980, 622978, 597149, 597147, 597163, 597159, 597157, 597144, 439525, 595286, 597090, 597088, 597030, 439518, 439515, 597051, 439513, 439511, 439508, 439503, 597025, 597033, 596845, 597006, 622974, 439484, 439478, 439474, 439472, 439466, 596976, 596969, 596916, 622970, 554283, 439438, 439432, 469063, 622965, 596820, 596816, 596779, 596777, 596839, 596830, 491114, 596775, 439407, 596772, 594347, 596627, 595373, 595371, 595370, 596462, 439373, 596460, 596458, 596504, 439367, 439363, 439359, 596448, 594632, 594624, 595339, 439310, 560794, 593166, 593157, 246656, 593041, 593006, 593001, 592948, 593032, 592639, 532333, 592623, 439014, 439007, 439005, 439003, 438953, 592438, 330520, 592431, 592288, 438946, 592281, 592205, 591718, 200853, 592153, 592151, 592167, 591893, 591797, 532271, 591643, 554274, 591549, 591065, 438790, 591255, 591243, 590708, 591057, 591055, 411447, 438659, 438657, 438650, 438641, 438631, 438623, 536308, 536302, 590825, 590822, 590820, 536290, 200825, 590767, 246642, 381017, 246636, 622787, 622780, 590623, 438523, 590549, 590546, 554237, 590509, 590497, 590490, 590479, 590473, 590464, 590459, 590457, 590455, 246606, 544894, 590448, 438515, 438511, 438507, 554233, 549905, 586327, 586325, 438437, 590367, 580072, 580070, 580066, 580064, 580061, 580057, 580054, 580046, 584881, 580041, 586321, 584869, 536284, 200816, 536275, 536273, 536271, 536269, 554228, 584858, 584855, 438394, 438392, 438389, 246547, 438387, 372036, 372034, 536263, 372032, 372028, 438381, 438379, 579973, 579971, 189214, 189210, 189208, 189206, 189204, 438313, 438307, 438305, 438300, 438295, 579961, 579958, 109168, 438276, 438261, 438240, 438233, 579928, 622748, 579923, 579920, 579918, 579915, 246529, 438183, 438176, 578192, 438172, 438170, 438166, 438165, 438163, 438160, 438151, 438146, 622738, 622736, 438128, 579869, 579864, 438126, 579858, 438124, 438117, 438114, 438109, 590265, 622734, 590251, 554225, 438051, 200810, 200808, 579830, 420371, 590033, 579808, 437955, 579799, 579795, 246507, 579793, 579766, 579755, 579753, 579750, 590112, 246488, 590107, 437933, 437929, 590102, 398403, 437927, 398401, 392222, 437924, 531905, 531903, 581663, 246463, 581661, 246459, 246456, 246453, 590048, 590046, 437898, 246436, 590098, 590096, 590090, 579711, 590088, 246419, 590056, 590054, 246394, 590032, 246388, 246384, 246382, 579688, 579686, 579683, 579680, 246331, 622667, 589835, 589831, 589827, 437779, 589823, 589815, 589813, 589811, 437774, 588559, 588550, 587459, 579669, 437751, 589602, 414172, 579655, 414169, 485990, 221818, 527830, 579653, 367690, 367688, 367686, 437744, 589595, 589585, 367682, 367680, 200792, 589581, 381012, 437716, 437714, 589579, 437709, 437707, 437704, 589576, 437688, 414167, 437673, 221815, 420356, 437669, 437666, 437648, 420354, 200789, 437621, 589568, 437619, 589565, 469054, 346997, 437606, 437602, 437585, 246273, 406507, 406504, 531801, 536236, 589202, 589525, 587655, 589523, 589521, 589513, 437507, 589511, 437503, 437497, 437495, 437491, 437484, 437482, 437480, 437478, 437475, 437473, 437431, 437429, 437419, 437414, 437406, 437400, 437396, 437393, 354509, 437387, 437384, 587653, 437381, 246256, 437375, 587650, 587648, 589406, 437343, 587646, 437337, 200784, 589194, 589185, 470905, 589175, 589172, 589169, 589167, 589165, 589163, 399375, 437270, 437269, 330509, 399370, 589151, 589148, 553104, 437261, 589146, 589144, 622634, 589141, 589138, 589132, 553102, 589127, 589121, 589109, 589103, 554217, 589061, 589057, 588446, 588443, 588437, 588435, 588433, 570369, 570361, 588430, 588428, 570355, 579599, 587283, 588426, 588397, 588394, 588392, 588389, 588387, 588383, 588381, 588378, 588373, 588365, 588362, 588356, 588350, 588347, 588340, 588338, 588333, 588331, 588329, 588322, 588319, 246221, 554206, 588286, 588275, 588273, 588270, 531682, 588266, 588261, 588258, 588253, 588249, 588247, 588243, 588241, 588234, 588739, 588230, 588762, 588737, 588733, 200773, 588721, 588752, 588223, 588750, 588718, 557945, 309798, 557931, 557926, 557911, 557907, 557905, 557903, 588202, 588189, 588179, 588177, 349227, 588173, 588171, 588166, 588164, 588136, 396522, 588123, 588113, 588110, 588107, 588102, 588096, 579562, 588086, 437186, 588066, 588064, 588060, 588535, 588058, 588039, 588038, 588035, 588532, 588033, 588031, 588029, 588530, 588026, 588019, 588017, 588013, 588498, 588494, 588492, 588490, 588009, 588006, 588004, 588002, 381002, 392781, 587993, 587991, 587989, 587986, 587981, 587979, 587976, 437129, 588468, 587974, 587965, 587962, 587959, 587956, 587952, 499402, 330507, 587900, 587893, 587891, 200766, 587888, 587884, 587881, 587867, 587863, 587859, 587856, 437090, 587837, 587835, 437087, 587820, 437086, 587810, 587794, 587784, 587774, 587771, 437081, 587769, 246196, 246194, 437049, 474204, 536196, 536192, 554176, 554171, 246105, 554164, 414162, 554145, 554143, 554137, 436746, 622548, 200745, 420352, 420350, 420348, 554130, 554127, 587152, 554125, 587147, 554123, 554121, 587143, 587133, 554119, 586933, 586929, 554113, 554111, 554109, 554105, 174368, 189197, 189195, 380994, 380992, 436248, 436246, 221608, 392213, 392211, 392209, 221606, 585151, 309770, 309767, 309754, 389243, 389241, 584924, 584922, 584920, 435915, 435908, 554056, 554047, 554045, 554039, 245777, 206168, 245513, 572628, 572011, 572008, 571963, 432888, 553637, 553624, 553603, 553598, 570308, 553566, 220709, 542781, 220704, 621521, 621514, 621512, 621509, 355935, 570058, 547160, 200286, 553548, 553546, 553538, 553516, 553505, 553503, 432542, 432538, 432535, 432533, 553489, 569062, 233612, 569060, 233610, 517335, 517332, 517328, 517325, 517323, 621306, 535949, 561972, 565457, 432353, 432351, 535932, 621292, 621289, 621284, 621281, 621274, 621272, 567349, 233570, 567346, 385985, 432279, 385982, 432275, 432253, 567316, 567308, 233555, 233553, 233549, 469050, 497336, 564016, 485821, 563743, 563561, 535893, 621028, 453620, 560420, 560418, 560415, 560413, 560411, 553343, 553336, 557705, 557702, 557697, 557687, 557684, 557655, 560401, 560399, 560397, 392840, 553331, 385955, 553322, 535882, 559783, 620923, 620918, 233219, 453610, 200222, 233212, 431527, 233202, 233195, 553319, 553317, 553313, 553311, 553308, 553306, 553302, 431425, 244317, 431411, 557892, 553294, 557889, 557651, 233131, 557649, 557644, 557640, 557637, 557632, 557629, 557622, 557618, 557604, 557885, 553291, 557589, 557587, 553287, 557491, 557489, 557485, 553281, 553279, 553270, 553263, 553261, 553258, 553256, 553240, 553238, 553236, 553230, 556823, 556820, 233052, 556814, 556811, 556808, 553219, 233048, 556802, 556800, 553208, 553206, 431149, 431143, 431139, 553203, 555098, 553199, 553192, 553188, 553185, 553182, 553180, 553175, 392136, 550538, 431077, 431069, 431064, 553161, 431060, 431058, 555089, 431024, 200205, 133038, 553155, 553153, 553150, 555046, 553139, 553131, 499351, 555032, 380784, 380781, 133019, 133016, 133010, 132998, 549486, 380742, 549484, 549481, 549476, 380739, 430505, 430502, 380735, 549446, 549443, 549435, 549433, 549431, 380727, 549427, 549417, 549413, 549388, 549386, 549376, 549361, 549359, 549357, 549305, 549303, 549293, 430288, 429939, 232675, 244050, 244047, 132936, 620323, 544164, 620315, 620313, 620310, 620308, 620303, 620298, 620296, 200073, 620294, 389198, 525374, 620289, 244035, 620286, 525369, 244032, 620283, 620281, 429689, 543942, 371818, 543895, 371816, 491034, 525344, 244026, 543807, 536819, 429647, 537673, 244019, 525322, 525310, 525307, 525299, 525287, 429579, 429562, 542646, 542644, 542642, 537934, 389183, 525232, 542262, 309365, 309363, 232620, 429471, 542430, 542447, 542315, 542313, 542310, 522327, 522324, 522322, 542119, 200043, 369126, 539444, 232605, 389181, 541607, 539985, 232586, 232583, 174289, 539674, 539671, 539667, 539392, 232527, 232523, 537906, 309338, 309336, 309334, 522296, 522287, 132876, 132872, 537866, 537864, 132870, 232498, 429016, 537902, 527581, 537567, 537556, 535409, 535407, 535383, 535367, 536726, 232455, 232453, 232445, 536675, 428901, 471030, 536540, 536538, 536536, 199956, 536453, 528005, 536476, 536449, 535336, 428822, 535263, 428819, 535261, 232391, 232389, 232385, 110435, 110433, 380547, 110431, 309332, 309326, 309323, 365272, 365269, 469881, 428764, 471954, 499345, 471952, 471949, 471947, 369103, 499342, 499337, 369097, 496571, 527247, 232334, 517472, 527239, 219258, 219251, 396154, 396484, 219231, 451733, 219222, 219218, 219213, 380539, 232317, 526607, 380530, 520460, 199907, 199905, 390539, 199902, 428530, 522926, 522924, 523222, 523635, 356269, 523633, 523628, 469868, 219176, 496556, 414835, 414833, 523219, 523217, 471945, 523215, 523213, 619906, 522914, 619903, 619900, 522912, 619895, 619891, 619887, 619884, 522904, 219139, 523013, 471941, 471937, 522900, 522898, 522766, 522762, 522261, 522257, 522253, 428462, 384220, 384218, 522248, 522235, 522227, 522220, 522214, 522212, 522210, 522200, 522198, 453513, 428409, 514526, 522168, 428348, 521023, 428308, 521346, 521340, 521332, 521297, 521295, 521293, 521065, 521009, 428250, 520997, 428240, 428238, 520986, 110428, 381612, 381610, 520742, 520595, 520739, 520591, 428172, 619775, 428151, 485503, 380506, 519784, 428053, 428050, 428032, 428026, 428024, 481579, 481576, 481574, 385902, 501667, 518455, 218992, 518452, 218981, 518450, 518446, 514491, 218964, 232221, 232217, 380498, 619649, 218933, 427860, 514482, 380493, 380491, 380489, 380486, 427834, 427819, 517010, 380481, 380479, 517008, 380475, 456064, 380473, 243591, 380468, 427805, 516897, 619616, 619613, 619611, 516891, 380464, 380461, 619586, 619584, 380455, 619581, 380453, 218886, 619578, 619575, 380451, 380449, 380447, 619571, 108444, 619569, 108442, 516791, 619566, 619563, 619559, 232154, 619557, 516682, 456062, 456060, 456058, 514160, 514153, 330308, 516678, 516676, 516673, 404388, 232146, 515739, 427764, 232129, 232127, 371750, 515721, 515206, 515204, 515202, 515200, 515194, 199787, 414022, 619538, 515253, 515243, 515241, 515189, 515186, 515184, 515179, 515156, 218796, 218773, 513696, 218758, 511947, 511945, 511943, 218749, 506430, 494712, 494710, 218709, 506424, 494707, 427647, 511749, 511747, 511745, 511741, 511725, 427541, 199746, 508843, 511524, 110401, 110399, 508839, 511481, 494697, 511479, 494695, 494693, 416406, 416404, 511326, 416402, 511323, 416401, 416398, 416396, 619424, 619421, 619417, 509545, 427448, 411975, 619394, 427436, 362383, 411963, 427426, 427422, 188810, 362378, 510667, 510616, 510614, 510612, 619363, 427362, 427360, 619360, 427343, 427331, 325848, 427327, 427325, 427313, 493507, 509838, 509833, 509831, 509827, 509823, 509821, 199694, 199692, 619353, 619348, 427286, 619339, 427280, 427277, 362348, 509245, 218596, 510054, 510050, 427247, 199663, 427210, 231967, 402962, 509760, 188801, 243413, 509526, 243402, 231959, 231956, 427144, 199640, 427140, 509160, 509093, 509090, 509147, 509145, 509086, 509222, 509142, 509140, 509075, 509073, 427120, 427118, 427116, 306424, 306422, 619244, 619241, 506556, 506550, 619238, 508220, 508218, 506548, 508669, 469822, 427079, 385880, 427077, 506546, 385878, 507876, 508277, 385875, 619232, 508271, 507872, 385872, 507868, 508216, 507862, 309266, 380418, 309253, 309249, 309244, 309242, 309239, 309237, 508267, 469811, 508264, 469807, 309994, 309992, 309990, 507852, 507846, 507842, 507840, 507837, 507835, 376223, 427008, 427005, 427003, 218510, 508052, 507903, 507817, 619166, 619164, 507813, 507809, 507801, 619155, 243350, 243348, 243346, 243342, 243340, 243336, 218498, 376211, 507663, 507661, 309193, 507207, 507205, 426934, 507203, 507199, 507192, 426931, 506542, 507189, 507186, 507185, 507181, 507179, 243326, 507316, 380411, 506662, 506659, 506942, 506939, 506779, 360810, 506934, 506910, 496476, 380408, 199573, 496474, 380407, 380405, 506379, 231847, 231845, 619095, 426903, 309151, 309149, 505985, 505982, 505976, 243283, 504714, 426890, 505968, 380403, 385862, 413781, 317186, 413779, 317184, 317182, 385860, 309037, 309035, 398093, 619091, 619089, 619087, 421898, 421892, 619085, 619082, 426872, 426869, 490342, 490340, 490338, 490336, 490334, 426860, 490332, 426856, 413777, 218443, 413774, 218440, 413769, 490330, 619076, 243272, 619074, 243268, 243262, 413767, 426793, 317164, 426790, 243246, 426787, 243238, 505350, 243236, 243234, 243232, 231822, 619072, 231819, 231816, 317159, 619071, 619069, 390529, 468989, 504653, 317152, 504650, 619064, 317149, 504648, 505264, 317143, 505262, 317140, 317137, 231795, 218422, 619053, 317129, 317120, 504710, 498333, 325845, 619050, 417818, 504362, 619048, 390527, 489116, 619039, 505255, 619037, 619035, 504707, 453476, 619026, 504646, 619021, 504644, 243188, 504705, 504642, 619014, 504640, 504959, 504699, 504638, 199532, 504636, 504695, 321074, 504693, 321069, 619011, 619009, 504634, 494402, 494400, 504903, 231785, 231781, 401022, 353212, 426744, 231770, 231768, 231761, 504682, 504663, 401001, 231753, 231751, 231749, 426738, 504661, 504231, 426732, 426729, 199526, 504149, 426718, 231743, 426713, 199524, 231741, 426707, 231737, 426701, 426699, 218401, 426696, 218396, 504147, 218391, 218380, 504226, 218377, 218375, 218370, 504584, 231731, 504582, 218361, 619006, 426681, 426678, 619004, 619002, 504222, 619000, 504220, 618998, 618992, 618990, 499471, 499469, 231660, 231654, 380395, 231648, 231645, 231627, 380389, 231617, 243105, 426617, 380381, 380379, 426611, 426610, 426607, 501981, 426588, 426583, 426581, 207548, 207545, 231559, 231553, 108276, 503291, 413764, 503289, 503286, 413762, 503284, 499181, 502165, 108274, 502159, 231534, 426566, 426562, 426559, 426553, 426551, 426548, 426546, 491276, 426494, 618970, 618968, 426492, 218276, 426486, 218273, 499334, 499332, 499330, 499328, 499326, 499324, 502483, 421200, 421198, 501961, 417811, 417807, 417805, 401104, 417803, 502371, 401102, 401100, 502368, 401096, 401094, 485264, 401091, 453465, 401088, 502131, 502128, 501972, 501969, 401083, 401081, 426431, 231454, 501849, 231446, 231442, 501846, 501754, 501752, 426426, 501749, 501746, 501744, 494672, 499321, 468976, 501742, 426353, 110370, 110368, 426346, 110366, 426344, 426340, 426338, 426336, 110363, 110361, 110359, 426333, 110357, 426330, 426328, 426326, 110355, 426324, 218246, 218244, 110351, 501576, 501574, 218241, 499000, 501571, 426299, 426291, 498998, 387833, 498996, 110348, 207544, 388162, 207540, 207538, 207534, 207531, 387829, 337020, 501287, 337018, 380373, 499862, 337011, 337007, 499858, 231430, 499856, 499852, 499850, 499848, 380369, 231420, 308990, 231414, 308984, 308982, 231406, 349387, 499319, 500491, 499317, 231400, 500463, 380367, 231395, 500460, 231393, 500455, 500452, 231390, 499316, 426126, 499313, 495547, 499311, 495544, 378111, 499300, 110337, 110335, 378109, 474305, 330240, 499203, 110333, 499200, 498388, 498386, 231293, 110327, 218111, 426065, 110325, 426062, 110322, 110319, 231289, 492287, 218101, 491011, 491009, 199402, 393818, 498383, 218088, 495535, 218083, 218080, 218077, 495528, 394058, 394056, 268945, 495523, 495261, 496664, 495259, 495516, 498116, 493177, 497343, 474041, 496653, 496651, 485251, 474036, 493175, 496443, 455395, 493171, 455391, 455389, 496440, 496434, 496429, 455385, 494659, 495421, 378911, 455383, 496427, 496420, 496418, 496416, 455380, 378909, 455376, 455372, 288819, 217995, 495510, 495508, 495554, 288818, 288815, 495394, 288813, 495392, 288811, 288809, 288806, 495386, 495383, 495377, 495373, 378907, 494876, 368941, 466826, 368939, 466824, 466822, 493188, 493185, 493183, 493181, 380348, 306405, 306403, 380344, 306401, 380342, 254154, 492721, 492718, 492286, 254152, 254150, 474022, 254148, 474020, 254146, 254139, 254137, 254132, 254130, 254128, 254122, 254112, 254110, 254108, 254105, 254101, 254097, 492425, 306398, 306396, 306394, 306392, 306390, 254095, 306388, 492283, 492418, 306386, 492281, 306384, 491999, 407974, 407972, 491273, 491269, 389148, 394053, 458672, 380330, 458668, 380328, 349113, 380326, 380323, 380321, 217745, 217742))
Run Time: 0.105071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2227 | |
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 | | | | | 2227 | |
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 (34860, 33265, 33263, 32611, 32459, 32004, 31904, 31846, 31742, 31725, 31716, 31556, 31527, 31459, 25357, 24962, 24961, 24884))
Run Time: 0.001316
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 18 | 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 `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 (453822, 637769, 629875, 625141, 444603, 453758, 611418, 444486, 444480, 444475, 444471, 625524, 625336, 625478, 625476, 625372, 444396, 444393, 625326, 625321, 602050, 580365, 580358, 201058, 444320, 625129, 625125, 329405, 534139, 443711, 615036, 613750, 615029, 611296, 611291, 611289, 611288, 611286, 611283, 533513, 611282, 611280, 611277, 442075, 611373, 609519, 354527, 200993, 611931, 611501, 533296, 611241, 610903, 441643, 441641, 441619, 441596, 441593, 441591, 441584, 441568, 441556, 441554, 441550, 533209, 441468, 533163, 533154, 325901, 602738, 440779, 356073, 189234, 189228, 599495, 603385, 600938, 602655, 602772, 602770, 601727, 601725, 601723, 601720, 601380, 601345, 600813, 554351, 600551, 596551, 623066, 554346, 440134, 440130, 440117, 440112, 440110, 440102, 440100, 600031, 440097, 440095, 600026, 599969, 440088, 599942, 599940, 393240, 597848, 599902, 200890, 599866, 599821, 599813, 599810, 440083, 599805, 440079, 599782, 599760, 598345, 598343, 469421, 554344, 566801, 598338, 200889, 590051, 599702, 598322, 189218, 598316, 189215, 354512, 440063, 599672, 580180, 599544, 330538, 599540, 580178, 580176, 596441, 580172, 349610, 349608, 599452, 349606, 349601, 597628, 200886, 392942, 392937, 439955, 599409, 599147, 439899, 594156, 598789, 453728, 598503, 598499, 598497, 598494, 598544, 598488, 517453, 517451, 598486, 517447, 554335, 396527, 439824, 439822, 329387, 396524, 439800, 598361, 598280, 598278, 439754, 554296, 598253, 439749, 439746, 439744, 597916, 439742, 597914, 439738, 592424, 597904, 597900, 597897, 597892, 598133, 597890, 598131, 200871, 597959, 597958, 597955, 597952, 439676, 439674, 439672, 439670, 439667, 597741, 554291, 597721, 596436, 596433, 200866, 439646, 439644, 439637, 439634, 439619, 594192, 594189, 325898, 597534, 623008, 133290, 133287, 623005, 623003, 623001, 133282, 622999, 622997, 597386, 597383, 585306, 594688, 585304, 381086, 381084, 381081, 597212, 597209, 597206, 597200, 596490, 386058, 597151, 622980, 622978, 597149, 597147, 597163, 597159, 597157, 597144, 439525, 595286, 597090, 597088, 597030, 439518, 439515, 597051, 439513, 439511, 439508, 439503, 597025, 597033, 596845, 597006, 622974, 439484, 439478, 439474, 439472, 439466, 596976, 596969, 596916, 622970, 554283, 439438, 439432, 469063, 622965, 596820, 596816, 596779, 596777, 596839, 596830, 491114, 596775, 439407, 596772, 594347, 596627, 595373, 595371, 595370, 596462, 439373, 596460, 596458, 596504, 439367, 439363, 439359, 596448, 594632, 594624, 595339, 439310, 560794, 593166, 593157, 246656, 593041, 593006, 593001, 592948, 593032, 592639, 532333, 592623, 439014, 439007, 439005, 439003, 438953, 592438, 330520, 592431, 592288, 438946, 592281, 592205, 591718, 200853, 592153, 592151, 592167, 591893, 591797, 532271, 591643, 554274, 591549, 591065, 438790, 591255, 591243, 590708, 591057, 591055, 411447, 438659, 438657, 438650, 438641, 438631, 438623, 536308, 536302, 590825, 590822, 590820, 536290, 200825, 590767, 246642, 381017, 246636, 622787, 622780, 590623, 438523, 590549, 590546, 554237, 590509, 590497, 590490, 590479, 590473, 590464, 590459, 590457, 590455, 246606, 544894, 590448, 438515, 438511, 438507, 554233, 549905, 586327, 586325, 438437, 590367, 580072, 580070, 580066, 580064, 580061, 580057, 580054, 580046, 584881, 580041, 586321, 584869, 536284, 200816, 536275, 536273, 536271, 536269, 554228, 584858, 584855, 438394, 438392, 438389, 246547, 438387, 372036, 372034, 536263, 372032, 372028, 438381, 438379, 579973, 579971, 189214, 189210, 189208, 189206, 189204, 438313, 438307, 438305, 438300, 438295, 579961, 579958, 109168, 438276, 438261, 438240, 438233, 579928, 622748, 579923, 579920, 579918, 579915, 246529, 438183, 438176, 578192, 438172, 438170, 438166, 438165, 438163, 438160, 438151, 438146, 622738, 622736, 438128, 579869, 579864, 438126, 579858, 438124, 438117, 438114, 438109, 590265, 622734, 590251, 554225, 438051, 200810, 200808, 579830, 420371, 590033, 579808, 437955, 579799, 579795, 246507, 579793, 579766, 579755, 579753, 579750, 590112, 246488, 590107, 437933, 437929, 590102, 398403, 437927, 398401, 392222, 437924, 531905, 531903, 581663, 246463, 581661, 246459, 246456, 246453, 590048, 590046, 437898, 246436, 590098, 590096, 590090, 579711, 590088, 246419, 590056, 590054, 246394, 590032, 246388, 246384, 246382, 579688, 579686, 579683, 579680, 246331, 622667, 589835, 589831, 589827, 437779, 589823, 589815, 589813, 589811, 437774, 588559, 588550, 587459, 579669, 437751, 589602, 414172, 579655, 414169, 485990, 221818, 527830, 579653, 367690, 367688, 367686, 437744, 589595, 589585, 367682, 367680, 200792, 589581, 381012, 437716, 437714, 589579, 437709, 437707, 437704, 589576, 437688, 414167, 437673, 221815, 420356, 437669, 437666, 437648, 420354, 200789, 437621, 589568, 437619, 589565, 469054, 346997, 437606, 437602, 437585, 246273, 406507, 406504, 531801, 536236, 589202, 589525, 587655, 589523, 589521, 589513, 437507, 589511, 437503, 437497, 437495, 437491, 437484, 437482, 437480, 437478, 437475, 437473, 437431, 437429, 437419, 437414, 437406, 437400, 437396, 437393, 354509, 437387, 437384, 587653, 437381, 246256, 437375, 587650, 587648, 589406, 437343, 587646, 437337, 200784, 589194, 589185, 470905, 589175, 589172, 589169, 589167, 589165, 589163, 399375, 437270, 437269, 330509, 399370, 589151, 589148, 553104, 437261, 589146, 589144, 622634, 589141, 589138, 589132, 553102, 589127, 589121, 589109, 589103, 554217, 589061, 589057, 588446, 588443, 588437, 588435, 588433, 570369, 570361, 588430, 588428, 570355, 579599, 587283, 588426, 588397, 588394, 588392, 588389, 588387, 588383, 588381, 588378, 588373, 588365, 588362, 588356, 588350, 588347, 588340, 588338, 588333, 588331, 588329, 588322, 588319, 246221, 554206, 588286, 588275, 588273, 588270, 531682, 588266, 588261, 588258, 588253, 588249, 588247, 588243, 588241, 588234, 588739, 588230, 588762, 588737, 588733, 200773, 588721, 588752, 588223, 588750, 588718, 557945, 309798, 557931, 557926, 557911, 557907, 557905, 557903, 588202, 588189, 588179, 588177, 349227, 588173, 588171, 588166, 588164, 588136, 396522, 588123, 588113, 588110, 588107, 588102, 588096, 579562, 588086, 437186, 588066, 588064, 588060, 588535, 588058, 588039, 588038, 588035, 588532, 588033, 588031, 588029, 588530, 588026, 588019, 588017, 588013, 588498, 588494, 588492, 588490, 588009, 588006, 588004, 588002, 381002, 392781, 587993, 587991, 587989, 587986, 587981, 587979, 587976, 437129, 588468, 587974, 587965, 587962, 587959, 587956, 587952, 499402, 330507, 587900, 587893, 587891, 200766, 587888, 587884, 587881, 587867, 587863, 587859, 587856, 437090, 587837, 587835, 437087, 587820, 437086, 587810, 587794, 587784, 587774, 587771, 437081, 587769, 246196, 246194, 437049, 474204, 536196, 536192, 554176, 554171, 246105, 554164, 414162, 554145, 554143, 554137, 436746, 622548, 200745, 420352, 420350, 420348, 554130, 554127, 587152, 554125, 587147, 554123, 554121, 587143, 587133, 554119, 586933, 586929, 554113, 554111, 554109, 554105, 174368, 189197, 189195, 380994, 380992, 436248, 436246, 221608, 392213, 392211, 392209, 221606, 585151, 309770, 309767, 309754, 389243, 389241, 584924, 584922, 584920, 435915, 435908, 554056, 554047, 554045, 554039, 245777, 206168, 245513, 572628, 572011, 572008, 571963, 432888, 553637, 553624, 553603, 553598, 570308, 553566, 220709, 542781, 220704, 621521, 621514, 621512, 621509, 355935, 570058, 547160, 200286, 553548, 553546, 553538, 553516, 553505, 553503, 432542, 432538, 432535, 432533, 553489, 569062, 233612, 569060, 233610, 517335, 517332, 517328, 517325, 517323, 621306, 535949, 561972, 565457, 432353, 432351, 535932, 621292, 621289, 621284, 621281, 621274, 621272, 567349, 233570, 567346, 385985, 432279, 385982, 432275, 432253, 567316, 567308, 233555, 233553, 233549, 469050, 497336, 564016, 485821, 563743, 563561, 535893, 621028, 453620, 560420, 560418, 560415, 560413, 560411, 553343, 553336, 557705, 557702, 557697, 557687, 557684, 557655, 560401, 560399, 560397, 392840, 553331, 385955, 553322, 535882, 559783, 620923, 620918, 233219, 453610, 200222, 233212, 431527, 233202, 233195, 553319, 553317, 553313, 553311, 553308, 553306, 553302, 431425, 244317, 431411, 557892, 553294, 557889, 557651, 233131, 557649, 557644, 557640, 557637, 557632, 557629, 557622, 557618, 557604, 557885, 553291, 557589, 557587, 553287, 557491, 557489, 557485, 553281, 553279, 553270, 553263, 553261, 553258, 553256, 553240, 553238, 553236, 553230, 556823, 556820, 233052, 556814, 556811, 556808, 553219, 233048, 556802, 556800, 553208, 553206, 431149, 431143, 431139, 553203, 555098, 553199, 553192, 553188, 553185, 553182, 553180, 553175, 392136, 550538, 431077, 431069, 431064, 553161, 431060, 431058, 555089, 431024, 200205, 133038, 553155, 553153, 553150, 555046, 553139, 553131, 499351, 555032, 380784, 380781, 133019, 133016, 133010, 132998, 549486, 380742, 549484, 549481, 549476, 380739, 430505, 430502, 380735, 549446, 549443, 549435, 549433, 549431, 380727, 549427, 549417, 549413, 549388, 549386, 549376, 549361, 549359, 549357, 549305, 549303, 549293, 430288, 429939, 232675, 244050, 244047, 132936, 620323, 544164, 620315, 620313, 620310, 620308, 620303, 620298, 620296, 200073, 620294, 389198, 525374, 620289, 244035, 620286, 525369, 244032, 620283, 620281, 429689, 543942, 371818, 543895, 371816, 491034, 525344, 244026, 543807, 536819, 429647, 537673, 244019, 525322, 525310, 525307, 525299, 525287, 429579, 429562, 542646, 542644, 542642, 537934, 389183, 525232, 542262, 309365, 309363, 232620, 429471, 542430, 542447, 542315, 542313, 542310, 522327, 522324, 522322, 542119, 200043, 369126, 539444, 232605, 389181, 541607, 539985, 232586, 232583, 174289, 539674, 539671, 539667, 539392, 232527, 232523, 537906, 309338, 309336, 309334, 522296, 522287, 132876, 132872, 537866, 537864, 132870, 232498, 429016, 537902, 527581, 537567, 537556, 535409, 535407, 535383, 535367, 536726, 232455, 232453, 232445, 536675, 428901, 471030, 536540, 536538, 536536, 199956, 536453, 528005, 536476, 536449, 535336, 428822, 535263, 428819, 535261, 232391, 232389, 232385, 110435, 110433, 380547, 110431, 309332, 309326, 309323, 365272, 365269, 469881, 428764, 471954, 499345, 471952, 471949, 471947, 369103, 499342, 499337, 369097, 496571, 527247, 232334, 517472, 527239, 219258, 219251, 396154, 396484, 219231, 451733, 219222, 219218, 219213, 380539, 232317, 526607, 380530, 520460, 199907, 199905, 390539, 199902, 428530, 522926, 522924, 523222, 523635, 356269, 523633, 523628, 469868, 219176, 496556, 414835, 414833, 523219, 523217, 471945, 523215, 523213, 619906, 522914, 619903, 619900, 522912, 619895, 619891, 619887, 619884, 522904, 219139, 523013, 471941, 471937, 522900, 522898, 522766, 522762, 522261, 522257, 522253, 428462, 384220, 384218, 522248, 522235, 522227, 522220, 522214, 522212, 522210, 522200, 522198, 453513, 428409, 514526, 522168, 428348, 521023, 428308, 521346, 521340, 521332, 521297, 521295, 521293, 521065, 521009, 428250, 520997, 428240, 428238, 520986, 110428, 381612, 381610, 520742, 520595, 520739, 520591, 428172, 619775, 428151, 485503, 380506, 519784, 428053, 428050, 428032, 428026, 428024, 481579, 481576, 481574, 385902, 501667, 518455, 218992, 518452, 218981, 518450, 518446, 514491, 218964, 232221, 232217, 380498, 619649, 218933, 427860, 514482, 380493, 380491, 380489, 380486, 427834, 427819, 517010, 380481, 380479, 517008, 380475, 456064, 380473, 243591, 380468, 427805, 516897, 619616, 619613, 619611, 516891, 380464, 380461, 619586, 619584, 380455, 619581, 380453, 218886, 619578, 619575, 380451, 380449, 380447, 619571, 108444, 619569, 108442, 516791, 619566, 619563, 619559, 232154, 619557, 516682, 456062, 456060, 456058, 514160, 514153, 330308, 516678, 516676, 516673, 404388, 232146, 515739, 427764, 232129, 232127, 371750, 515721, 515206, 515204, 515202, 515200, 515194, 199787, 414022, 619538, 515253, 515243, 515241, 515189, 515186, 515184, 515179, 515156, 218796, 218773, 513696, 218758, 511947, 511945, 511943, 218749, 506430, 494712, 494710, 218709, 506424, 494707, 427647, 511749, 511747, 511745, 511741, 511725, 427541, 199746, 508843, 511524, 110401, 110399, 508839, 511481, 494697, 511479, 494695, 494693, 416406, 416404, 511326, 416402, 511323, 416401, 416398, 416396, 619424, 619421, 619417, 509545, 427448, 411975, 619394, 427436, 362383, 411963, 427426, 427422, 188810, 362378, 510667, 510616, 510614, 510612, 619363, 427362, 427360, 619360, 427343, 427331, 325848, 427327, 427325, 427313, 493507, 509838, 509833, 509831, 509827, 509823, 509821, 199694, 199692, 619353, 619348, 427286, 619339, 427280, 427277, 362348, 509245, 218596, 510054, 510050, 427247, 199663, 427210, 231967, 402962, 509760, 188801, 243413, 509526, 243402, 231959, 231956, 427144, 199640, 427140, 509160, 509093, 509090, 509147, 509145, 509086, 509222, 509142, 509140, 509075, 509073, 427120, 427118, 427116, 306424, 306422, 619244, 619241, 506556, 506550, 619238, 508220, 508218, 506548, 508669, 469822, 427079, 385880, 427077, 506546, 385878, 507876, 508277, 385875, 619232, 508271, 507872, 385872, 507868, 508216, 507862, 309266, 380418, 309253, 309249, 309244, 309242, 309239, 309237, 508267, 469811, 508264, 469807, 309994, 309992, 309990, 507852, 507846, 507842, 507840, 507837, 507835, 376223, 427008, 427005, 427003, 218510, 508052, 507903, 507817, 619166, 619164, 507813, 507809, 507801, 619155, 243350, 243348, 243346, 243342, 243340, 243336, 218498, 376211, 507663, 507661, 309193, 507207, 507205, 426934, 507203, 507199, 507192, 426931, 506542, 507189, 507186, 507185, 507181, 507179, 243326, 507316, 380411, 506662, 506659, 506942, 506939, 506779, 360810, 506934, 506910, 496476, 380408, 199573, 496474, 380407, 380405, 506379, 231847, 231845, 619095, 426903, 309151, 309149, 505985, 505982, 505976, 243283, 504714, 426890, 505968, 380403, 385862, 413781, 317186, 413779, 317184, 317182, 385860, 309037, 309035, 398093, 619091, 619089, 619087, 421898, 421892, 619085, 619082, 426872, 426869, 490342, 490340, 490338, 490336, 490334, 426860, 490332, 426856, 413777, 218443, 413774, 218440, 413769, 490330, 619076, 243272, 619074, 243268, 243262, 413767, 426793, 317164, 426790, 243246, 426787, 243238, 505350, 243236, 243234, 243232, 231822, 619072, 231819, 231816, 317159, 619071, 619069, 390529, 468989, 504653, 317152, 504650, 619064, 317149, 504648, 505264, 317143, 505262, 317140, 317137, 231795, 218422, 619053, 317129, 317120, 504710, 498333, 325845, 619050, 417818, 504362, 619048, 390527, 489116, 619039, 505255, 619037, 619035, 504707, 453476, 619026, 504646, 619021, 504644, 243188, 504705, 504642, 619014, 504640, 504959, 504699, 504638, 199532, 504636, 504695, 321074, 504693, 321069, 619011, 619009, 504634, 494402, 494400, 504903, 231785, 231781, 401022, 353212, 426744, 231770, 231768, 231761, 504682, 504663, 401001, 231753, 231751, 231749, 426738, 504661, 504231, 426732, 426729, 199526, 504149, 426718, 231743, 426713, 199524, 231741, 426707, 231737, 426701, 426699, 218401, 426696, 218396, 504147, 218391, 218380, 504226, 218377, 218375, 218370, 504584, 231731, 504582, 218361, 619006, 426681, 426678, 619004, 619002, 504222, 619000, 504220, 618998, 618992, 618990, 499471, 499469, 231660, 231654, 380395, 231648, 231645, 231627, 380389, 231617, 243105, 426617, 380381, 380379, 426611, 426610, 426607, 501981, 426588, 426583, 426581, 207548, 207545, 231559, 231553, 108276, 503291, 413764, 503289, 503286, 413762, 503284, 499181, 502165, 108274, 502159, 231534, 426566, 426562, 426559, 426553, 426551, 426548, 426546, 491276, 426494, 618970, 618968, 426492, 218276, 426486, 218273, 499334, 499332, 499330, 499328, 499326, 499324, 502483, 421200, 421198, 501961, 417811, 417807, 417805, 401104, 417803, 502371, 401102, 401100, 502368, 401096, 401094, 485264, 401091, 453465, 401088, 502131, 502128, 501972, 501969, 401083, 401081, 426431, 231454, 501849, 231446, 231442, 501846, 501754, 501752, 426426, 501749, 501746, 501744, 494672, 499321, 468976, 501742, 426353, 110370, 110368, 426346, 110366, 426344, 426340, 426338, 426336, 110363, 110361, 110359, 426333, 110357, 426330, 426328, 426326, 110355, 426324, 218246, 218244, 110351, 501576, 501574, 218241, 499000, 501571, 426299, 426291, 498998, 387833, 498996, 110348, 207544, 388162, 207540, 207538, 207534, 207531, 387829, 337020, 501287, 337018, 380373, 499862, 337011, 337007, 499858, 231430, 499856, 499852, 499850, 499848, 380369, 231420, 308990, 231414, 308984, 308982, 231406, 349387, 499319, 500491, 499317, 231400, 500463, 380367, 231395, 500460, 231393, 500455, 500452, 231390, 499316, 426126, 499313, 495547, 499311, 495544, 378111, 499300, 110337, 110335, 378109, 474305, 330240, 499203, 110333, 499200, 498388, 498386, 231293, 110327, 218111, 426065, 110325, 426062, 110322, 110319, 231289, 492287, 218101, 491011, 491009, 199402, 393818, 498383, 218088, 495535, 218083, 218080, 218077, 495528, 394058, 394056, 268945, 495523, 495261, 496664, 495259, 495516, 498116, 493177, 497343, 474041, 496653, 496651, 485251, 474036, 493175, 496443, 455395, 493171, 455391, 455389, 496440, 496434, 496429, 455385, 494659, 495421, 378911, 455383, 496427, 496420, 496418, 496416, 455380, 378909, 455376, 455372, 288819, 217995, 495510, 495508, 495554, 288818, 288815, 495394, 288813, 495392, 288811, 288809, 288806, 495386, 495383, 495377, 495373, 378907, 494876, 368941, 466826, 368939, 466824, 466822, 493188, 493185, 493183, 493181, 380348, 306405, 306403, 380344, 306401, 380342, 254154, 492721, 492718, 492286, 254152, 254150, 474022, 254148, 474020, 254146, 254139, 254137, 254132, 254130, 254128, 254122, 254112, 254110, 254108, 254105, 254101, 254097, 492425, 306398, 306396, 306394, 306392, 306390, 254095, 306388, 492283, 492418, 306386, 492281, 306384, 491999, 407974, 407972, 491273, 491269, 389148, 394053, 458672, 380330, 458668, 380328, 349113, 380326, 380323, 380321, 217745, 217742))
Run Time: 0.042031
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2227 | |
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 | | | | | 2227 | |
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 view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, �B
Run Time: 0.000247
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: �B, XF\Pub\Controller\Member, RecentContent, valid, user_id=6623, 1716207108, , 0, �B
Run Time: 0.000213
- 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.000373
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.000487
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: 1716206808
Run Time: 0.000266
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 14 | 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/s19/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` >= 1716206808)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000478
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 14 | 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/s19/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