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.000985
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.000244
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` = '4286')
LIMIT 1
Run Time: 0.000507
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.002284
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_4286' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.207589
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 (35456, 35064, 35045, 35011, 34945, 34442, 34398, 34061, 33708, 33654, 33238, 33005, 32935, 32798, 32739, 32701, 32661, 32593, 32072, 32018, 32017, 32015, 32014, 32011, 32010, 31833, 31798, 31371, 30915, 30220, 30102, 30068, 30063, 30038, 29973, 29267, 22444, 22389, 19269, 19195, 18847))
Run Time: 0.007713
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 41 | 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 (641501, 641391, 641388, 641383, 641379, 641316, 641315, 641171, 641143, 641142, 641141, 641140, 641118, 641117, 641106, 641103, 641089, 641088, 641087, 641062, 641061, 641032, 641031, 640956, 640931, 640927, 640896, 640818, 635413, 640788, 640591, 640748, 640782, 640742, 639300, 640718, 640607, 640707, 630361, 640659, 640639, 447706, 447704, 447701, 640617, 640578, 417941, 640599, 640572, 580749, 447693, 639722, 640551, 639720, 640530, 639718, 639774, 640537, 639715, 640524, 447607, 640516, 447603, 640464, 447599, 639978, 640494, 639709, 640475, 640470, 447593, 639976, 639616, 639707, 640456, 447573, 639705, 623559, 636285, 447570, 639703, 640436, 640240, 640428, 639346, 639972, 640406, 640390, 639611, 447566, 639700, 640387, 447562, 640176, 447559, 627580, 638893, 544904, 447541, 640217, 640282, 640247, 640274, 640278, 640276, 640265, 640268, 640263, 640236, 640201, 637077, 639906, 640198, 632841, 640231, 640219, 447522, 639902, 640082, 447518, 640145, 453830, 640133, 638369, 447478, 640029, 447470, 639963, 640006, 640010, 639945, 597992, 639894, 639462, 639887, 639892, 639458, 639764, 639779, 639756, 447359, 639592, 639599, 637418, 627540, 581358, 420981, 447324, 639539, 639422, 634413, 639531, 639400, 639524, 639496, 639405, 639409, 639398, 636074, 420427, 639392, 639281, 639390, 639380, 447293, 636066, 639359, 637439, 639376, 447290, 636062, 638585, 612968, 639276, 639370, 607608, 634516, 599367, 601703, 634514, 634512, 599364, 639235, 447250, 631931, 634510, 630896, 463749, 447235, 447226, 594646, 639219, 638580, 639217, 639212, 639209, 638578, 639166, 639161, 639188, 639201, 639198, 639157, 639183, 639191, 639173, 447166, 626151, 639125, 639179, 639129, 637193, 634938, 637191, 639009, 635144, 639001, 639006, 347178, 635138, 639003, 636738, 635130, 447145, 447143, 580718, 635123, 638999, 447140, 599046, 189145, 201203, 447136, 638997, 447126, 638888, 638975, 638972, 583948, 638960, 447119, 578059, 638704, 638907, 578037, 638798, 638946, 638859, 638934, 638882, 638944, 552894, 447111, 638940, 638931, 638552, 14957, 606809, 493680, 638526, 638342, 633945, 633942, 637926, 637494, 635649, 635629, 635584, 635627, 635600, 635596, 635574, 605937, 635588, 635360, 635358, 635568, 627259, 635457, 110765, 635417, 635419, 635341, 635328, 635321, 635318, 635304, 609387, 594639, 635255, 635250, 635233, 635084, 635184, 635217, 628446, 635176, 635181, 634691, 635074, 635047, 635071, 635045, 635055, 634976, 634967, 446358, 376850, 634959, 634920, 634946, 634929, 634607, 634783, 629007, 623719, 623717, 450635, 634700, 634751, 634674, 634689, 634634, 634632, 597503, 597499, 628441, 634544, 634502, 633301, 633298, 634266, 634312, 634280, 632731, 634254, 634152, 634186, 313766, 633991, 633780, 633740, 446223, 633787, 633671, 633065, 593656, 633504, 633549, 633521, 633519, 633516, 398423, 633449, 633447, 633445, 633443, 633440, 633391, 633358, 633281, 633276, 628435, 633274, 633255, 633267, 633248, 633247, 632068, 633174, 571336, 633155, 633128, 626840, 633010, 632176, 632833, 632125, 632711, 626285, 632699, 609962, 632680, 632654, 632677, 632673, 632652, 632583, 632315, 631294, 632382, 632542, 632526, 632461, 632492, 632458, 631950, 631967, 457265, 596091, 596089, 631945, 631897, 631959, 628992, 631938, 631278, 631275, 631273, 631270, 625395, 631755, 580580, 631503, 631683, 631732, 631681, 631679, 631677, 631494, 631729, 630801, 631699, 628625, 445714, 631331, 445705, 631321, 631337, 605417, 631328, 631030, 631102, 631106, 627169, 629429, 631073, 631071, 627147, 630393, 609940, 630922, 629223, 630861, 629587, 630815, 613662, 630806, 630812, 630782, 630788, 607423, 630785, 630031, 629729, 629747, 629760, 629779, 629705, 628612, 629068, 629066, 629029, 628854, 628921, 626918, 628580, 628431, 609925, 609922, 627629, 627345, 445003, 626981, 626768, 626384, 444769, 626194, 625424, 534209, 583334, 534208, 625236, 623502, 624391, 605657, 444110, 607374, 444080, 623499, 623916, 623497, 623495, 421788, 623808, 623771, 624100, 623493, 443890, 616153, 623479, 616335, 616311, 613023, 616021, 615936, 443519, 4716, 614850, 608665, 442934, 613825, 613523, 613520, 613690, 613478, 613504, 609836, 613222, 613216, 613236, 613006, 392235, 613197, 613184, 613174, 601014, 612954, 605438, 609813, 611471, 499608, 633421, 609804, 612773, 442158, 606340, 609802, 612456, 612720, 612668, 612634, 612644, 612619, 612642, 612632, 608839, 612602, 611233, 612529, 442041, 609495, 612245, 612482, 592364, 605394, 612438, 612406, 441988, 612395, 612145, 612143, 441946, 611904, 611776, 611772, 611864, 441841, 611862, 441839, 441836, 611845, 611833, 611805, 611556, 611651, 611669, 611657, 600996, 611571, 611505, 611458, 611478, 493192, 493190, 611231, 611226, 611152, 610956, 611035, 611006, 610933, 608198, 441601, 602184, 441599, 608196, 608664, 602182, 610930, 609785, 609783, 597349, 610725, 610652, 610721, 611761, 610585, 610630, 610582, 611758, 441440, 533200, 441425, 441419, 610462, 610359, 608278, 381132, 611699, 610181, 610179, 610173, 441370, 441367, 609771, 441365, 455496, 455489, 610153, 610123, 610126, 303004, 609098, 610089, 610074, 610056, 609977, 609747, 416422, 396171, 609465, 609597, 609595, 609462, 609552, 609395, 609418, 609393, 526636, 592888, 609416, 609391, 609401, 609398, 609332, 593646, 606806, 608999, 609038, 608962, 608958, 608855, 608851, 608847, 608844, 607783, 608792, 608803, 608654, 608768, 595685, 595683, 608605, 608603, 608650, 608641, 608637, 608635, 608632, 603933, 608571, 608378, 607711, 608361, 608333, 441226, 608330, 441184, 592128, 592126, 592119, 608302, 608292, 608298, 608294, 608282, 608253, 608251, 608248, 608255, 607828, 441179, 441176, 441171, 441166, 441163, 441138, 607751, 615529, 607687, 607668, 441113, 607519, 623112, 607530, 607517, 607538, 607534, 607526, 607514, 607512, 441103, 441100, 441098, 607505, 605350, 441096, 441092, 441088, 441086, 607339, 441083, 441081, 606278, 607334, 377215, 441076, 441071, 607324, 441069, 607310, 441064, 607270, 512008, 441060, 377213, 607268, 607301, 607261, 607259, 607284, 607257, 607228, 499501, 441025, 607191, 607189, 441023, 528498, 441017, 441015, 441009, 503978, 503976, 441008, 606964, 606961, 607170, 607168, 607166, 607164, 607116, 532924, 441007, 607162, 606958, 607202, 607200, 607160, 607138, 607132, 607061, 607124, 606923, 606907, 606870, 440973, 605348, 605345, 605343, 605341, 600977, 606101, 606088, 606085, 606082, 440825, 208381, 600459, 605570, 200923, 602543, 602530, 602520, 599509, 599507, 602513, 605493, 599505, 605333, 605330, 605181, 602992, 440700, 602990, 605311, 605177, 605269, 604919, 605173, 440697, 440694, 605169, 440692, 597112, 599503, 605186, 605214, 599501, 605161, 602642, 440685, 532850, 440640, 440628, 440624, 605021, 440619, 603921, 440508, 604443, 604206, 400760, 600432, 603880, 440434, 603316, 603314, 398408, 602923, 603301, 593805, 589665, 603293, 440410, 603296, 463016, 603179, 463014, 603168, 536365, 603187, 603176, 603174, 603172, 603164, 440400, 603149, 600936, 603124, 603146, 603111, 603108, 603117, 603103, 440395, 486319, 603061, 603059, 603054, 599306, 440374, 602987, 440372, 603036, 603043, 603034, 603040, 600931, 600927, 593626, 603023, 602984, 602982, 602961, 602959, 602966, 602979, 559112, 602964, 602957, 602941, 602945, 602935, 600427, 600425, 600411, 600407, 602895, 595200, 602909, 595198, 602892, 595195, 602813, 414198, 602870, 602876, 602811, 602868, 414196, 602819, 602837, 602881, 602866, 602817, 602863, 602835, 602806, 602804, 602802, 602636, 602232, 602226, 602706, 600520, 602223, 602725, 440343, 602776, 600404, 601932, 602704, 600677, 602766, 600401, 600668, 602723, 592689, 599487, 602699, 602688, 599485, 599483, 599481, 602675, 602573, 602629, 602350, 602645, 602627, 602622, 602349, 602620, 602347, 602345, 602615, 440335, 599302, 602603, 602584, 602582, 602588, 440331, 602578, 589382, 602557, 440328, 600909, 602563, 602435, 602553, 601997, 602497, 602495, 602493, 602464, 488701, 488697, 414194, 488695, 602403, 602395, 602387, 580202, 414191, 575805, 554376, 601994, 602279, 602332, 602310, 602300, 602298, 602268, 593226, 602163, 600399, 602318, 414189, 602316, 602314, 602177, 602175, 600394, 602203, 599025, 602193, 597467, 602191, 600389, 602146, 554556, 602125, 440320, 601897, 601893, 584130, 601889, 601884, 602057, 602022, 440311, 440309, 601978, 601575, 589233, 601643, 600380, 599480, 599478, 453731, 601960, 600376, 599477, 601952, 601947, 592960, 600374, 592685, 601927, 600372, 600370, 601925, 575855, 575853, 600366, 584127, 575851, 600342, 601916, 600339, 440273, 601914, 600336, 440272, 601871, 440268, 601911, 601619, 601617, 440264, 516761, 440261, 584125, 601546, 601557, 601559, 600310, 601551, 601543, 532673, 601462, 440252, 601460, 601454, 600507, 593207, 600501, 598894, 601363, 601435, 600498, 601354, 601351, 601336, 601320, 298154, 598891, 440210, 600832, 600294, 598888, 596801, 596799, 598886, 600287, 601299, 601307, 600285, 601291, 601296, 207564, 592116, 600871, 600866, 600838, 600828, 440204, 600819, 599294, 600691, 575840, 600718, 600688, 600716, 440191, 599469, 600662, 599907, 600660, 600655, 600645, 600658, 600680, 600653, 440186, 600641, 600639, 600650, 600581, 600629, 600609, 508153, 440185, 440183, 508151, 600603, 440174, 440172, 599651, 600149, 600105, 599465, 600103, 600100, 440150, 600095, 599463, 600077, 600071, 599460, 440143, 597396, 532621, 600039, 600016, 440107, 600013, 598329, 595184, 595181, 599703, 598325, 599701, 598320, 440065, 440061, 440054, 440052, 440050, 599542, 439994, 599145, 597925, 598897, 598871, 324043, 587488, 598765, 598761, 587485, 598752, 598750, 439884, 598646, 439882, 439878, 439876, 439874, 439871, 439869, 439867, 439864, 589488, 597648, 589486, 439859, 598634, 598719, 598631, 598717, 598629, 598714, 598627, 598710, 453729, 597800, 598708, 598706, 597793, 598704, 598699, 598695, 598693, 598642, 598640, 598625, 598666, 598663, 598661, 598658, 598653, 598637, 598610, 598623, 598607, 598613, 439853, 439848, 598576, 439840, 598551, 598500, 598495, 392230, 598543, 598427, 598539, 517454, 554339, 595163, 595161, 439837, 439836, 439835, 598514, 554336, 592113, 592111, 593458, 592109, 593456, 592107, 598425, 588950, 593453, 598479, 598475, 593447, 598423, 593445, 593443, 554332, 596922, 548403, 439828, 587483, 587482, 587480, 598447, 598384, 598358, 439795, 439793, 598309, 598306, 439772, 598304, 439769, 439767, 532558, 593181, 532556, 596520, 439765, 596518, 592608, 598207, 592606, 554304, 598186, 554299, 598257, 598254, 598252, 573982, 598072, 598250, 439733, 598219, 598172, 598183, 598170, 598168, 598166, 598180, 598164, 598162, 598160, 133297, 598178, 133295, 277875, 598117, 598150, 598156, 597899, 594536, 598115, 598123, 598120, 598114, 598106, 598067, 598064, 598082, 598062, 439725, 598099, 594719, 598079, 598060, 594716, 594714, 439724, 483647, 483645, 598037, 598057, 598055, 439721, 598035, 439719, 439717, 597834, 439715, 483643, 594711, 439713, 439711, 439709, 597832, 439706, 439704, 598022, 597461, 598019, 482147, 597830, 598017, 598015, 598013, 597939, 598011, 597937, 598008, 597816, 482145, 597935, 439702, 482143, 597505, 597997, 597967, 482141, 482139, 482137, 382701, 597964, 597960, 597957, 597828, 597954, 594886, 597951, 597948, 594884, 597826, 597942, 572530, 597933, 592807, 597931, 597878, 597929, 597822, 482135, 439697, 597872, 439694, 597866, 439689, 439687, 597814, 597812, 597857, 597810, 597819, 593603, 439684, 572529, 439680, 572527, 593960, 597803, 593601, 593599, 593957, 593597, 439679, 597785, 572522, 597781, 597779, 597776, 597790, 597788, 597730, 597727, 398197, 596884, 597769, 596882, 597763, 597760, 596880, 582390, 439677, 439675, 597703, 597753, 597748, 597746, 439673, 597700, 597750, 439671, 439669, 439666, 597744, 439664, 554294, 439662, 597694, 439660, 597723, 386062, 439659, 597717, 597692, 597689, 597604, 109221, 532544, 532543, 597619, 597617, 597615, 597593, 439656, 597459, 597611, 597457, 595068, 597454, 597452, 597449, 597447, 595064, 595062, 597445, 597443, 597441, 597439, 595059, 595054, 597590, 597588, 439645, 597598, 591111, 439643, 439641, 597435, 595052, 439638, 597561, 623015, 439617, 597585, 623013, 623010, 439611, 597574, 597572, 595158, 597556, 597553, 594194, 597567, 594190, 439607, 439603, 597540, 532542, 597537, 597531, 439597, 595151, 439595, 439593, 439591, 439586, 595146, 595143, 439558, 207562, 595141, 439554, 439552, 207560, 439550, 597431, 597488, 439548, 597486, 597482, 597480, 386061, 597477, 386059, 133288, 133286, 623000, 622998, 597346, 597343, 207558, 597385, 597375, 580153, 580151, 200865, 597336, 585305, 594689, 597331, 381083, 597333, 381078, 381076, 381068, 439545, 381064, 381062, 597296, 597329, 597318, 439543, 597316, 439540, 597314, 439538, 596859, 596857, 596855, 596852, 596850, 439536, 596491, 439535, 414184, 597271, 386055, 386053, 386051, 386049, 386047, 597183, 597180, 597145, 414177, 596849, 596654, 532504, 420977, 592675, 592673, 592671, 592668, 592665, 592663, 592660, 582368, 592657, 594367, 582366, 420974, 581347, 581344, 581342, 596634, 581340, 594699, 420968, 420966, 439399, 439397, 439395, 439391, 439389, 596605, 596612, 595136, 593109, 596507, 593735, 596505, 596480, 596472, 439365, 596470, 596477, 596475, 596468, 439360, 595468, 595466, 596451, 596449, 439355, 595413, 596431, 595411, 596424, 596422, 595407, 593726, 593724, 595454, 595437, 595405, 595435, 595418, 595441, 595402, 595431, 595400, 595429, 595397, 595335, 595395, 439353, 595391, 439337, 594623, 595328, 595325, 595323, 595090, 622944, 439311, 595036, 595034, 366812, 595087, 595085, 595117, 595115, 595083, 439295, 439291, 577247, 389068, 595112, 594247, 594760, 594443, 594441, 133272, 595032, 594439, 593436, 595040, 592096, 595028, 594434, 594432, 594430, 594428, 574698, 574696, 594816, 453725, 593932, 593930, 590702, 590698, 590690, 591074, 590138, 591053, 590297, 590291, 590289, 554252, 589922, 589920, 589918, 481377, 589914, 571711, 571709, 571702, 571699, 571697, 571696, 571693, 590674, 347349, 572825, 573365, 573226, 577350, 576089, 575958, 577347, 575288, 108928, 108919, 575955, 575953, 575950, 575947, 575944, 575943, 576111, 573333, 414130, 576105, 575937, 576060, 573221, 573219, 576058, 576054, 576052, 576048, 573209, 573207, 575931, 575929, 575927, 575925, 575921, 575905, 575901, 573190, 573188, 575286, 575893, 575891, 575889, 575887, 575885, 575882, 575879, 575875, 575866, 575862, 575861, 575284, 573464, 575813, 575858, 404097, 575798, 575282, 575795, 573187, 573185, 575280, 575793, 575756, 575824, 575791, 573179, 575764, 575746, 404095, 433767, 433765, 573144, 574379, 573142, 572045, 573140, 573138, 526388, 530456, 530446, 526380, 574355, 398387, 572041, 574491, 574484, 574482, 574480, 574373, 574211, 574208, 378150, 574205, 574400, 574424, 574477, 574470, 574468, 574460, 433725, 574418, 574414, 574384, 574194, 574368, 567076, 398383, 398380, 574362, 573103, 573101, 574190, 573099, 573096, 574188, 567074, 234183, 574341, 234178, 574139, 574236, 414119, 433688, 573091, 234174, 574234, 574339, 234170, 574137, 574328, 574324, 572036, 573086, 234158, 574321, 574319, 414113, 471979, 414111, 530430, 234155, 573083, 574134, 381196, 574317, 572033, 574312, 469968, 574231, 573073, 469966, 573071, 386008, 530426, 234148, 574227, 234146, 485893, 574259, 530422, 573069, 234141, 573066, 234138, 245051, 530418, 234135, 234133, 574068, 530416, 574177, 234113, 573064, 573048, 234105, 574084, 574060, 530411, 574081, 485891, 485889, 574078, 574159, 574126, 574075, 234097, 574124, 234095, 234087, 574151, 574149, 574120, 234085, 572685, 573033, 573031, 574054, 574105, 574103, 574097, 573856, 572773, 526378, 574029, 433627, 574027, 234082, 234079, 234077, 574048, 234074, 485885, 544288, 526375, 433625, 574025, 526371, 433618, 523601, 573026, 332243, 538299, 433616, 433599, 526356, 433597, 526353, 310031, 433592, 530389, 574017, 563985, 485882, 574015, 556768, 420267, 573013, 572612, 572995, 572993, 547991, 572991, 489749, 489747, 569317, 573989, 567395, 547989, 573987, 567393, 569118, 572989, 572987, 573777, 565530, 565528, 573834, 551390, 573456, 542789, 573384, 573382, 549997, 573453, 549995, 542787, 573774, 549992, 573771, 133166, 133164, 523596, 133162, 133156, 133152, 572985, 572983, 572973, 565403, 572969, 573519, 569116, 553084, 523593, 572967, 572948, 573406, 553081, 573517, 565400, 569114, 413811, 573515, 573339, 573512, 569112, 413809, 413807, 570964, 481770, 481768, 573337, 573322, 553078, 572947, 553076, 548287, 553074, 481765, 560668, 572944, 572940, 573405, 481762, 560666, 572935, 573402, 573400, 573394, 573392, 481759, 560661, 560659, 572933, 572510, 560657, 572508, 573331, 569781, 560655, 572928, 569779, 560753, 560652, 572926, 560650, 573328, 560646, 403203, 560644, 573326, 572924, 403201, 560642, 420264, 571030, 571437, 570913, 398491, 403199, 572610, 569776, 569772, 571029, 420263, 571025, 398488, 569770, 569669, 403197, 569667, 403193, 403190, 569768, 403183, 571663, 569665, 403179, 572604, 569662, 569660, 571435, 559104, 397420, 397418, 572102, 571433, 570991, 570266, 571502, 398485, 571593, 398481, 556861, 556857, 571547, 571783, 548269, 556854, 571728, 571591, 571751, 397379, 548267, 553058, 553056, 398472, 571493, 571491, 571489, 571485, 571483, 571477, 566800, 484798, 571469, 527760, 571467, 566798, 484796, 570563, 570560, 484792, 560947, 484788, 484784, 484780, 484777, 570264, 569860, 570554, 571545, 302014, 571542, 571597, 571464, 484773, 569812, 571619, 571617, 571449, 571447, 571442, 571440, 571360, 514981, 481359, 481356, 569636, 569809, 569808, 560749, 570439, 569632, 569621, 466968, 569617, 563767, 569254, 569615, 466966, 466964, 564360, 569396, 569607, 564462, 564331, 564329, 563848, 460215, 420148, 459651, 460209, 455842, 454061, 416852, 455839, 455836, 455834, 455832, 416847, 455830, 416844, 416842, 421996, 455174, 421994, 456416, 447752, 384530, 455829, 455149, 383497, 453950, 455143, 455826, 455824, 455822, 455820, 455673, 450221, 454055, 454053, 454051, 454049, 452071, 455138, 452069, 454047, 421989, 450220, 455067, 420144, 455062, 455060, 420142, 455058, 455056, 420140, 455054, 421983, 455051, 450218, 384647, 382210, 382630, 382205, 285450, 383528, 382626, 384658, 384549, 384643, 384064, 381193, 383458, 383456, 383454, 382620, 381191, 382618, 377685, 238594, 383452, 238591, 383450, 383448, 375677, 362998, 238587, 381189, 375670, 382616, 382547, 375668, 383446, 238573, 383444, 383442, 357059, 362996, 375661, 383440, 382614, 383522, 375659, 384061, 383437, 374493, 372478, 375165, 366943, 383357, 382199, 365136, 358342, 379525, 383513, 375654, 375620, 375652, 383403, 382865, 375650, 383124, 383505, 383109, 383434, 383107, 383104, 383100, 207146, 383098, 616464, 381186, 382055, 616448, 382053, 382051, 382049, 382047, 382544, 382542, 382044, 382540, 382040, 382038, 616437, 616434, 382063, 379074, 379071, 382538, 379069, 382034, 382612, 373908, 379067, 362749, 382532, 378900, 381857, 379280, 376022, 361813, 378896, 378894, 378727, 365620, 361811, 379267, 379265, 379263, 379572, 376018, 361809, 361807, 376556, 376012, 376010, 381855, 381853, 161723, 336446, 381900, 381851, 379621, 161721, 379208, 381492, 376552, 378725, 382021, 382019, 379183, 382017, 161717, 381475, 305689, 378541, 289764, 379338, 378892, 361801, 361800, 376550, 375748, 375744, 381864, 375742, 375740, 375738, 375736, 379064, 214457, 365863, 376483, 379062, 375004, 377751, 375002, 375888, 330834, 365861, 214355, 375000, 375883, 214353, 373608, 373606, 358112, 377387, 376479, 376463, 376460, 376454, 369528, 373721, 366133, 369719, 369717, 369714, 361791, 362485, 365010, 364375, 213571, 311645))
Run Time: 0.165712
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2441 | |
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 | | | | | 2441 | |
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 (35456, 35064, 35045, 35011, 34945, 34442, 34398, 34061, 33708, 33654, 33238, 33005, 32935, 32798, 32739, 32701, 32661, 32593, 32072, 32018, 32017, 32015, 32014, 32011, 32010, 31833, 31798, 31371, 30915, 30220, 30102, 30068, 30063, 30038, 29973, 29267, 22444, 22389, 19269, 19195, 18847))
Run Time: 0.011369
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 41 | 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 (641501, 641391, 641388, 641383, 641379, 641316, 641315, 641171, 641143, 641142, 641141, 641140, 641118, 641117, 641106, 641103, 641089, 641088, 641087, 641062, 641061, 641032, 641031, 640956, 640931, 640927, 640896, 640818, 635413, 640788, 640591, 640748, 640782, 640742, 639300, 640718, 640607, 640707, 630361, 640659, 640639, 447706, 447704, 447701, 640617, 640578, 417941, 640599, 640572, 580749, 447693, 639722, 640551, 639720, 640530, 639718, 639774, 640537, 639715, 640524, 447607, 640516, 447603, 640464, 447599, 639978, 640494, 639709, 640475, 640470, 447593, 639976, 639616, 639707, 640456, 447573, 639705, 623559, 636285, 447570, 639703, 640436, 640240, 640428, 639346, 639972, 640406, 640390, 639611, 447566, 639700, 640387, 447562, 640176, 447559, 627580, 638893, 544904, 447541, 640217, 640282, 640247, 640274, 640278, 640276, 640265, 640268, 640263, 640236, 640201, 637077, 639906, 640198, 632841, 640231, 640219, 447522, 639902, 640082, 447518, 640145, 453830, 640133, 638369, 447478, 640029, 447470, 639963, 640006, 640010, 639945, 597992, 639894, 639462, 639887, 639892, 639458, 639764, 639779, 639756, 447359, 639592, 639599, 637418, 627540, 581358, 420981, 447324, 639539, 639422, 634413, 639531, 639400, 639524, 639496, 639405, 639409, 639398, 636074, 420427, 639392, 639281, 639390, 639380, 447293, 636066, 639359, 637439, 639376, 447290, 636062, 638585, 612968, 639276, 639370, 607608, 634516, 599367, 601703, 634514, 634512, 599364, 639235, 447250, 631931, 634510, 630896, 463749, 447235, 447226, 594646, 639219, 638580, 639217, 639212, 639209, 638578, 639166, 639161, 639188, 639201, 639198, 639157, 639183, 639191, 639173, 447166, 626151, 639125, 639179, 639129, 637193, 634938, 637191, 639009, 635144, 639001, 639006, 347178, 635138, 639003, 636738, 635130, 447145, 447143, 580718, 635123, 638999, 447140, 599046, 189145, 201203, 447136, 638997, 447126, 638888, 638975, 638972, 583948, 638960, 447119, 578059, 638704, 638907, 578037, 638798, 638946, 638859, 638934, 638882, 638944, 552894, 447111, 638940, 638931, 638552, 14957, 606809, 493680, 638526, 638342, 633945, 633942, 637926, 637494, 635649, 635629, 635584, 635627, 635600, 635596, 635574, 605937, 635588, 635360, 635358, 635568, 627259, 635457, 110765, 635417, 635419, 635341, 635328, 635321, 635318, 635304, 609387, 594639, 635255, 635250, 635233, 635084, 635184, 635217, 628446, 635176, 635181, 634691, 635074, 635047, 635071, 635045, 635055, 634976, 634967, 446358, 376850, 634959, 634920, 634946, 634929, 634607, 634783, 629007, 623719, 623717, 450635, 634700, 634751, 634674, 634689, 634634, 634632, 597503, 597499, 628441, 634544, 634502, 633301, 633298, 634266, 634312, 634280, 632731, 634254, 634152, 634186, 313766, 633991, 633780, 633740, 446223, 633787, 633671, 633065, 593656, 633504, 633549, 633521, 633519, 633516, 398423, 633449, 633447, 633445, 633443, 633440, 633391, 633358, 633281, 633276, 628435, 633274, 633255, 633267, 633248, 633247, 632068, 633174, 571336, 633155, 633128, 626840, 633010, 632176, 632833, 632125, 632711, 626285, 632699, 609962, 632680, 632654, 632677, 632673, 632652, 632583, 632315, 631294, 632382, 632542, 632526, 632461, 632492, 632458, 631950, 631967, 457265, 596091, 596089, 631945, 631897, 631959, 628992, 631938, 631278, 631275, 631273, 631270, 625395, 631755, 580580, 631503, 631683, 631732, 631681, 631679, 631677, 631494, 631729, 630801, 631699, 628625, 445714, 631331, 445705, 631321, 631337, 605417, 631328, 631030, 631102, 631106, 627169, 629429, 631073, 631071, 627147, 630393, 609940, 630922, 629223, 630861, 629587, 630815, 613662, 630806, 630812, 630782, 630788, 607423, 630785, 630031, 629729, 629747, 629760, 629779, 629705, 628612, 629068, 629066, 629029, 628854, 628921, 626918, 628580, 628431, 609925, 609922, 627629, 627345, 445003, 626981, 626768, 626384, 444769, 626194, 625424, 534209, 583334, 534208, 625236, 623502, 624391, 605657, 444110, 607374, 444080, 623499, 623916, 623497, 623495, 421788, 623808, 623771, 624100, 623493, 443890, 616153, 623479, 616335, 616311, 613023, 616021, 615936, 443519, 4716, 614850, 608665, 442934, 613825, 613523, 613520, 613690, 613478, 613504, 609836, 613222, 613216, 613236, 613006, 392235, 613197, 613184, 613174, 601014, 612954, 605438, 609813, 611471, 499608, 633421, 609804, 612773, 442158, 606340, 609802, 612456, 612720, 612668, 612634, 612644, 612619, 612642, 612632, 608839, 612602, 611233, 612529, 442041, 609495, 612245, 612482, 592364, 605394, 612438, 612406, 441988, 612395, 612145, 612143, 441946, 611904, 611776, 611772, 611864, 441841, 611862, 441839, 441836, 611845, 611833, 611805, 611556, 611651, 611669, 611657, 600996, 611571, 611505, 611458, 611478, 493192, 493190, 611231, 611226, 611152, 610956, 611035, 611006, 610933, 608198, 441601, 602184, 441599, 608196, 608664, 602182, 610930, 609785, 609783, 597349, 610725, 610652, 610721, 611761, 610585, 610630, 610582, 611758, 441440, 533200, 441425, 441419, 610462, 610359, 608278, 381132, 611699, 610181, 610179, 610173, 441370, 441367, 609771, 441365, 455496, 455489, 610153, 610123, 610126, 303004, 609098, 610089, 610074, 610056, 609977, 609747, 416422, 396171, 609465, 609597, 609595, 609462, 609552, 609395, 609418, 609393, 526636, 592888, 609416, 609391, 609401, 609398, 609332, 593646, 606806, 608999, 609038, 608962, 608958, 608855, 608851, 608847, 608844, 607783, 608792, 608803, 608654, 608768, 595685, 595683, 608605, 608603, 608650, 608641, 608637, 608635, 608632, 603933, 608571, 608378, 607711, 608361, 608333, 441226, 608330, 441184, 592128, 592126, 592119, 608302, 608292, 608298, 608294, 608282, 608253, 608251, 608248, 608255, 607828, 441179, 441176, 441171, 441166, 441163, 441138, 607751, 615529, 607687, 607668, 441113, 607519, 623112, 607530, 607517, 607538, 607534, 607526, 607514, 607512, 441103, 441100, 441098, 607505, 605350, 441096, 441092, 441088, 441086, 607339, 441083, 441081, 606278, 607334, 377215, 441076, 441071, 607324, 441069, 607310, 441064, 607270, 512008, 441060, 377213, 607268, 607301, 607261, 607259, 607284, 607257, 607228, 499501, 441025, 607191, 607189, 441023, 528498, 441017, 441015, 441009, 503978, 503976, 441008, 606964, 606961, 607170, 607168, 607166, 607164, 607116, 532924, 441007, 607162, 606958, 607202, 607200, 607160, 607138, 607132, 607061, 607124, 606923, 606907, 606870, 440973, 605348, 605345, 605343, 605341, 600977, 606101, 606088, 606085, 606082, 440825, 208381, 600459, 605570, 200923, 602543, 602530, 602520, 599509, 599507, 602513, 605493, 599505, 605333, 605330, 605181, 602992, 440700, 602990, 605311, 605177, 605269, 604919, 605173, 440697, 440694, 605169, 440692, 597112, 599503, 605186, 605214, 599501, 605161, 602642, 440685, 532850, 440640, 440628, 440624, 605021, 440619, 603921, 440508, 604443, 604206, 400760, 600432, 603880, 440434, 603316, 603314, 398408, 602923, 603301, 593805, 589665, 603293, 440410, 603296, 463016, 603179, 463014, 603168, 536365, 603187, 603176, 603174, 603172, 603164, 440400, 603149, 600936, 603124, 603146, 603111, 603108, 603117, 603103, 440395, 486319, 603061, 603059, 603054, 599306, 440374, 602987, 440372, 603036, 603043, 603034, 603040, 600931, 600927, 593626, 603023, 602984, 602982, 602961, 602959, 602966, 602979, 559112, 602964, 602957, 602941, 602945, 602935, 600427, 600425, 600411, 600407, 602895, 595200, 602909, 595198, 602892, 595195, 602813, 414198, 602870, 602876, 602811, 602868, 414196, 602819, 602837, 602881, 602866, 602817, 602863, 602835, 602806, 602804, 602802, 602636, 602232, 602226, 602706, 600520, 602223, 602725, 440343, 602776, 600404, 601932, 602704, 600677, 602766, 600401, 600668, 602723, 592689, 599487, 602699, 602688, 599485, 599483, 599481, 602675, 602573, 602629, 602350, 602645, 602627, 602622, 602349, 602620, 602347, 602345, 602615, 440335, 599302, 602603, 602584, 602582, 602588, 440331, 602578, 589382, 602557, 440328, 600909, 602563, 602435, 602553, 601997, 602497, 602495, 602493, 602464, 488701, 488697, 414194, 488695, 602403, 602395, 602387, 580202, 414191, 575805, 554376, 601994, 602279, 602332, 602310, 602300, 602298, 602268, 593226, 602163, 600399, 602318, 414189, 602316, 602314, 602177, 602175, 600394, 602203, 599025, 602193, 597467, 602191, 600389, 602146, 554556, 602125, 440320, 601897, 601893, 584130, 601889, 601884, 602057, 602022, 440311, 440309, 601978, 601575, 589233, 601643, 600380, 599480, 599478, 453731, 601960, 600376, 599477, 601952, 601947, 592960, 600374, 592685, 601927, 600372, 600370, 601925, 575855, 575853, 600366, 584127, 575851, 600342, 601916, 600339, 440273, 601914, 600336, 440272, 601871, 440268, 601911, 601619, 601617, 440264, 516761, 440261, 584125, 601546, 601557, 601559, 600310, 601551, 601543, 532673, 601462, 440252, 601460, 601454, 600507, 593207, 600501, 598894, 601363, 601435, 600498, 601354, 601351, 601336, 601320, 298154, 598891, 440210, 600832, 600294, 598888, 596801, 596799, 598886, 600287, 601299, 601307, 600285, 601291, 601296, 207564, 592116, 600871, 600866, 600838, 600828, 440204, 600819, 599294, 600691, 575840, 600718, 600688, 600716, 440191, 599469, 600662, 599907, 600660, 600655, 600645, 600658, 600680, 600653, 440186, 600641, 600639, 600650, 600581, 600629, 600609, 508153, 440185, 440183, 508151, 600603, 440174, 440172, 599651, 600149, 600105, 599465, 600103, 600100, 440150, 600095, 599463, 600077, 600071, 599460, 440143, 597396, 532621, 600039, 600016, 440107, 600013, 598329, 595184, 595181, 599703, 598325, 599701, 598320, 440065, 440061, 440054, 440052, 440050, 599542, 439994, 599145, 597925, 598897, 598871, 324043, 587488, 598765, 598761, 587485, 598752, 598750, 439884, 598646, 439882, 439878, 439876, 439874, 439871, 439869, 439867, 439864, 589488, 597648, 589486, 439859, 598634, 598719, 598631, 598717, 598629, 598714, 598627, 598710, 453729, 597800, 598708, 598706, 597793, 598704, 598699, 598695, 598693, 598642, 598640, 598625, 598666, 598663, 598661, 598658, 598653, 598637, 598610, 598623, 598607, 598613, 439853, 439848, 598576, 439840, 598551, 598500, 598495, 392230, 598543, 598427, 598539, 517454, 554339, 595163, 595161, 439837, 439836, 439835, 598514, 554336, 592113, 592111, 593458, 592109, 593456, 592107, 598425, 588950, 593453, 598479, 598475, 593447, 598423, 593445, 593443, 554332, 596922, 548403, 439828, 587483, 587482, 587480, 598447, 598384, 598358, 439795, 439793, 598309, 598306, 439772, 598304, 439769, 439767, 532558, 593181, 532556, 596520, 439765, 596518, 592608, 598207, 592606, 554304, 598186, 554299, 598257, 598254, 598252, 573982, 598072, 598250, 439733, 598219, 598172, 598183, 598170, 598168, 598166, 598180, 598164, 598162, 598160, 133297, 598178, 133295, 277875, 598117, 598150, 598156, 597899, 594536, 598115, 598123, 598120, 598114, 598106, 598067, 598064, 598082, 598062, 439725, 598099, 594719, 598079, 598060, 594716, 594714, 439724, 483647, 483645, 598037, 598057, 598055, 439721, 598035, 439719, 439717, 597834, 439715, 483643, 594711, 439713, 439711, 439709, 597832, 439706, 439704, 598022, 597461, 598019, 482147, 597830, 598017, 598015, 598013, 597939, 598011, 597937, 598008, 597816, 482145, 597935, 439702, 482143, 597505, 597997, 597967, 482141, 482139, 482137, 382701, 597964, 597960, 597957, 597828, 597954, 594886, 597951, 597948, 594884, 597826, 597942, 572530, 597933, 592807, 597931, 597878, 597929, 597822, 482135, 439697, 597872, 439694, 597866, 439689, 439687, 597814, 597812, 597857, 597810, 597819, 593603, 439684, 572529, 439680, 572527, 593960, 597803, 593601, 593599, 593957, 593597, 439679, 597785, 572522, 597781, 597779, 597776, 597790, 597788, 597730, 597727, 398197, 596884, 597769, 596882, 597763, 597760, 596880, 582390, 439677, 439675, 597703, 597753, 597748, 597746, 439673, 597700, 597750, 439671, 439669, 439666, 597744, 439664, 554294, 439662, 597694, 439660, 597723, 386062, 439659, 597717, 597692, 597689, 597604, 109221, 532544, 532543, 597619, 597617, 597615, 597593, 439656, 597459, 597611, 597457, 595068, 597454, 597452, 597449, 597447, 595064, 595062, 597445, 597443, 597441, 597439, 595059, 595054, 597590, 597588, 439645, 597598, 591111, 439643, 439641, 597435, 595052, 439638, 597561, 623015, 439617, 597585, 623013, 623010, 439611, 597574, 597572, 595158, 597556, 597553, 594194, 597567, 594190, 439607, 439603, 597540, 532542, 597537, 597531, 439597, 595151, 439595, 439593, 439591, 439586, 595146, 595143, 439558, 207562, 595141, 439554, 439552, 207560, 439550, 597431, 597488, 439548, 597486, 597482, 597480, 386061, 597477, 386059, 133288, 133286, 623000, 622998, 597346, 597343, 207558, 597385, 597375, 580153, 580151, 200865, 597336, 585305, 594689, 597331, 381083, 597333, 381078, 381076, 381068, 439545, 381064, 381062, 597296, 597329, 597318, 439543, 597316, 439540, 597314, 439538, 596859, 596857, 596855, 596852, 596850, 439536, 596491, 439535, 414184, 597271, 386055, 386053, 386051, 386049, 386047, 597183, 597180, 597145, 414177, 596849, 596654, 532504, 420977, 592675, 592673, 592671, 592668, 592665, 592663, 592660, 582368, 592657, 594367, 582366, 420974, 581347, 581344, 581342, 596634, 581340, 594699, 420968, 420966, 439399, 439397, 439395, 439391, 439389, 596605, 596612, 595136, 593109, 596507, 593735, 596505, 596480, 596472, 439365, 596470, 596477, 596475, 596468, 439360, 595468, 595466, 596451, 596449, 439355, 595413, 596431, 595411, 596424, 596422, 595407, 593726, 593724, 595454, 595437, 595405, 595435, 595418, 595441, 595402, 595431, 595400, 595429, 595397, 595335, 595395, 439353, 595391, 439337, 594623, 595328, 595325, 595323, 595090, 622944, 439311, 595036, 595034, 366812, 595087, 595085, 595117, 595115, 595083, 439295, 439291, 577247, 389068, 595112, 594247, 594760, 594443, 594441, 133272, 595032, 594439, 593436, 595040, 592096, 595028, 594434, 594432, 594430, 594428, 574698, 574696, 594816, 453725, 593932, 593930, 590702, 590698, 590690, 591074, 590138, 591053, 590297, 590291, 590289, 554252, 589922, 589920, 589918, 481377, 589914, 571711, 571709, 571702, 571699, 571697, 571696, 571693, 590674, 347349, 572825, 573365, 573226, 577350, 576089, 575958, 577347, 575288, 108928, 108919, 575955, 575953, 575950, 575947, 575944, 575943, 576111, 573333, 414130, 576105, 575937, 576060, 573221, 573219, 576058, 576054, 576052, 576048, 573209, 573207, 575931, 575929, 575927, 575925, 575921, 575905, 575901, 573190, 573188, 575286, 575893, 575891, 575889, 575887, 575885, 575882, 575879, 575875, 575866, 575862, 575861, 575284, 573464, 575813, 575858, 404097, 575798, 575282, 575795, 573187, 573185, 575280, 575793, 575756, 575824, 575791, 573179, 575764, 575746, 404095, 433767, 433765, 573144, 574379, 573142, 572045, 573140, 573138, 526388, 530456, 530446, 526380, 574355, 398387, 572041, 574491, 574484, 574482, 574480, 574373, 574211, 574208, 378150, 574205, 574400, 574424, 574477, 574470, 574468, 574460, 433725, 574418, 574414, 574384, 574194, 574368, 567076, 398383, 398380, 574362, 573103, 573101, 574190, 573099, 573096, 574188, 567074, 234183, 574341, 234178, 574139, 574236, 414119, 433688, 573091, 234174, 574234, 574339, 234170, 574137, 574328, 574324, 572036, 573086, 234158, 574321, 574319, 414113, 471979, 414111, 530430, 234155, 573083, 574134, 381196, 574317, 572033, 574312, 469968, 574231, 573073, 469966, 573071, 386008, 530426, 234148, 574227, 234146, 485893, 574259, 530422, 573069, 234141, 573066, 234138, 245051, 530418, 234135, 234133, 574068, 530416, 574177, 234113, 573064, 573048, 234105, 574084, 574060, 530411, 574081, 485891, 485889, 574078, 574159, 574126, 574075, 234097, 574124, 234095, 234087, 574151, 574149, 574120, 234085, 572685, 573033, 573031, 574054, 574105, 574103, 574097, 573856, 572773, 526378, 574029, 433627, 574027, 234082, 234079, 234077, 574048, 234074, 485885, 544288, 526375, 433625, 574025, 526371, 433618, 523601, 573026, 332243, 538299, 433616, 433599, 526356, 433597, 526353, 310031, 433592, 530389, 574017, 563985, 485882, 574015, 556768, 420267, 573013, 572612, 572995, 572993, 547991, 572991, 489749, 489747, 569317, 573989, 567395, 547989, 573987, 567393, 569118, 572989, 572987, 573777, 565530, 565528, 573834, 551390, 573456, 542789, 573384, 573382, 549997, 573453, 549995, 542787, 573774, 549992, 573771, 133166, 133164, 523596, 133162, 133156, 133152, 572985, 572983, 572973, 565403, 572969, 573519, 569116, 553084, 523593, 572967, 572948, 573406, 553081, 573517, 565400, 569114, 413811, 573515, 573339, 573512, 569112, 413809, 413807, 570964, 481770, 481768, 573337, 573322, 553078, 572947, 553076, 548287, 553074, 481765, 560668, 572944, 572940, 573405, 481762, 560666, 572935, 573402, 573400, 573394, 573392, 481759, 560661, 560659, 572933, 572510, 560657, 572508, 573331, 569781, 560655, 572928, 569779, 560753, 560652, 572926, 560650, 573328, 560646, 403203, 560644, 573326, 572924, 403201, 560642, 420264, 571030, 571437, 570913, 398491, 403199, 572610, 569776, 569772, 571029, 420263, 571025, 398488, 569770, 569669, 403197, 569667, 403193, 403190, 569768, 403183, 571663, 569665, 403179, 572604, 569662, 569660, 571435, 559104, 397420, 397418, 572102, 571433, 570991, 570266, 571502, 398485, 571593, 398481, 556861, 556857, 571547, 571783, 548269, 556854, 571728, 571591, 571751, 397379, 548267, 553058, 553056, 398472, 571493, 571491, 571489, 571485, 571483, 571477, 566800, 484798, 571469, 527760, 571467, 566798, 484796, 570563, 570560, 484792, 560947, 484788, 484784, 484780, 484777, 570264, 569860, 570554, 571545, 302014, 571542, 571597, 571464, 484773, 569812, 571619, 571617, 571449, 571447, 571442, 571440, 571360, 514981, 481359, 481356, 569636, 569809, 569808, 560749, 570439, 569632, 569621, 466968, 569617, 563767, 569254, 569615, 466966, 466964, 564360, 569396, 569607, 564462, 564331, 564329, 563848, 460215, 420148, 459651, 460209, 455842, 454061, 416852, 455839, 455836, 455834, 455832, 416847, 455830, 416844, 416842, 421996, 455174, 421994, 456416, 447752, 384530, 455829, 455149, 383497, 453950, 455143, 455826, 455824, 455822, 455820, 455673, 450221, 454055, 454053, 454051, 454049, 452071, 455138, 452069, 454047, 421989, 450220, 455067, 420144, 455062, 455060, 420142, 455058, 455056, 420140, 455054, 421983, 455051, 450218, 384647, 382210, 382630, 382205, 285450, 383528, 382626, 384658, 384549, 384643, 384064, 381193, 383458, 383456, 383454, 382620, 381191, 382618, 377685, 238594, 383452, 238591, 383450, 383448, 375677, 362998, 238587, 381189, 375670, 382616, 382547, 375668, 383446, 238573, 383444, 383442, 357059, 362996, 375661, 383440, 382614, 383522, 375659, 384061, 383437, 374493, 372478, 375165, 366943, 383357, 382199, 365136, 358342, 379525, 383513, 375654, 375620, 375652, 383403, 382865, 375650, 383124, 383505, 383109, 383434, 383107, 383104, 383100, 207146, 383098, 616464, 381186, 382055, 616448, 382053, 382051, 382049, 382047, 382544, 382542, 382044, 382540, 382040, 382038, 616437, 616434, 382063, 379074, 379071, 382538, 379069, 382034, 382612, 373908, 379067, 362749, 382532, 378900, 381857, 379280, 376022, 361813, 378896, 378894, 378727, 365620, 361811, 379267, 379265, 379263, 379572, 376018, 361809, 361807, 376556, 376012, 376010, 381855, 381853, 161723, 336446, 381900, 381851, 379621, 161721, 379208, 381492, 376552, 378725, 382021, 382019, 379183, 382017, 161717, 381475, 305689, 378541, 289764, 379338, 378892, 361801, 361800, 376550, 375748, 375744, 381864, 375742, 375740, 375738, 375736, 379064, 214457, 365863, 376483, 379062, 375004, 377751, 375002, 375888, 330834, 365861, 214355, 375000, 375883, 214353, 373608, 373606, 358112, 377387, 376479, 376463, 376460, 376454, 369528, 373721, 366133, 369719, 369717, 369714, 361791, 362485, 365010, 364375, 213571, 311645))
Run Time: 0.049269
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2441 | |
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 | | | | | 2441 | |
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, �&
Run Time: 0.000294
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=4286, 1716237715, , 0, �&
Run Time: 0.000198
- 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.000355
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.000523
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: 1716237415
Run Time: 0.000288
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 18 | 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` >= 1716237415)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000515
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 18 | 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