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.000613
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.000185
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` = '2646')
LIMIT 1
Run Time: 0.000604
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.002475
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_2646' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.044158
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | search_index | fulltext | title_metadata | title_metadata | 0 | | 1 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 162
- XF\Db\AbstractAdapter->fetchAllNum() in src/XF/Search/Source/MySqlFt.php at line 286
- XF\Search\Source\MySqlFt->search() in src/XF/Search/Search.php at line 185
- XF\Search\Search->XF\Search\{closure}() in src/XF/Search/Search.php at line 214
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 180
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (593642, 440603, 590277, 590275, 234881, 234304, 234055, 234053, 234051, 234047, 222426, 234020, 234018, 573447, 573438, 573433, 222423, 222421, 222419, 549705, 222418, 570665, 432884, 549664, 549662, 570664, 570663, 419817, 551937, 571035, 569811, 133136, 220802, 569958, 570653, 309588, 497504, 233753, 541928, 570435, 569449, 569734, 569441, 138400, 567516, 565077, 567513, 381831, 567121, 554893, 567013, 417868, 564843, 564932, 558725, 564364, 488435, 488433, 563931, 563673, 563671, 563669, 244455, 244451, 555220, 560438, 515783, 549613, 549610, 549604, 558965, 558954, 558951, 558371, 549550, 405792, 405787, 557835, 556502, 554829, 552769, 133023, 620647, 620644, 620641, 552114, 620627, 551822, 620622, 620619, 551819, 620617, 620608, 551303, 550857, 550855, 550854, 550851, 550849, 550847, 550844, 550840, 550793, 549933, 549930, 549520, 548519, 132955, 548216, 430260, 430257, 430252, 430248, 547534, 546743, 430139, 491054, 541756, 541753, 541750, 430015, 430007, 430000, 546731, 540175, 429938, 200099, 542093, 544982, 544980, 327238, 321188, 429837, 368283, 543615, 544734, 544732, 368276, 543612, 544730, 544727, 540142, 540135, 543595, 368267, 368266, 539241, 539239, 539237, 200004, 538823, 243935, 232516, 232508, 538475, 232506, 132878, 537574, 453543, 537604, 258063, 428925, 428923, 428917, 528437, 527324, 526566, 199926, 528041, 528033, 321149, 321146, 333729, 321143, 428068, 428067, 428064, 428063, 428061, 428056, 514888, 333713, 510029, 512111, 505197, 518469, 518468, 518810, 470988, 419769, 132780, 517128, 488389, 517275, 517273, 492621, 517125, 232119, 232097, 232095, 514455, 514779, 514798, 243548, 243544, 514794, 514792, 513618, 513887, 513096, 513874, 513871, 513869, 513790, 513614, 513612, 513610, 232073, 108391, 499418, 499416, 513234, 243484, 243482, 243430, 243425, 510115, 243419, 453122, 488018, 508125, 507116, 507114, 507113, 199578, 367326, 243261, 505354, 505179, 505346, 317117, 505174, 505172, 243191, 243189, 504775, 504550, 464634, 464632, 349403, 464630, 503536, 342799, 342795, 132753, 503352, 618978, 426544, 502478, 502468, 502764, 331627, 502455, 502453, 502451, 502449, 502447, 502445, 502443, 502441, 331616, 331614, 231512, 400106, 231510, 331610, 132746, 132745, 268967, 268964, 268962, 268959, 488168, 372526, 488166, 453118, 368942, 242955, 242873, 491797, 492069, 242771, 242768, 242761, 490392, 490380, 490379, 490369, 490170, 489603, 230807, 230805, 489522, 489317, 489305, 489195, 486657, 425124, 483074, 483072, 199088, 258054, 474903, 474901, 482289, 425073, 425071, 425069, 425067, 419748, 425059, 242427, 480689, 481983, 480757, 480756, 480643, 480751, 480550, 480548, 242344, 460804, 479404, 477791, 242310, 464302, 459782, 198486, 463784, 132442, 461423, 463155, 462975, 241649, 368364, 241623, 241619, 461599, 461585, 132399, 461757, 461661, 461560, 461755, 461752, 461749, 461747, 461743, 461742, 461741, 461740, 461739, 461519, 461508, 461506, 107666, 461417, 459592, 461414, 320692, 460305, 458297, 460302, 453109, 460333, 460320, 460318, 460315, 453105, 453102, 229733, 459583, 336231, 336229, 132345, 458773, 458906, 458903, 458515, 458887, 458899, 458885, 458355, 198323, 458346, 56441, 458497, 458495, 458492, 458152, 458148, 458335, 458331, 458146, 458285, 458283, 458281, 458279, 458134, 457957, 458160, 458111, 458130, 457069, 457543, 457229, 198286, 198284, 457060, 198278, 456992, 456989, 456985, 456982, 397066, 456830, 456729, 394275, 394273, 456725, 456362, 455732, 455997, 241366, 455876, 241364, 132285, 110207, 453344, 229650, 229646, 229640, 229638, 229623, 229621, 448553, 455009, 420537, 229619, 229613, 229609, 229606, 455238, 417284, 455547, 455233, 388728, 454417, 454412, 452182, 418932, 453089, 454079, 453086, 198179, 418928, 418925, 418922, 333578, 418916, 453064, 452688, 107509, 216462, 617627, 422292, 359927, 342773, 452048, 617579, 451813, 229472, 451451, 318310, 451487, 451411, 451409, 617548, 451403, 451393, 451391, 449602, 449600, 450456, 450454, 617540, 617538, 203386, 110191, 367099, 107478, 412976, 451269, 203382, 333571, 229447, 449351, 449349, 449345, 449329, 449326, 449061, 449324, 449321, 449317, 449315, 449059, 423106, 423103, 448978, 449032, 448947, 448946, 448944, 448942, 389941, 359923, 359921, 359919, 448932, 448930, 448926, 448924, 448922, 448919, 448841, 448828, 448826, 448759, 354737, 354735, 354733, 448523, 448448, 448446, 448305, 423576, 423566, 447790, 423561, 423553, 423546, 423543, 381444, 229278, 423098, 423434, 216267, 423086, 421818, 423084, 240942, 423082, 240940, 423077, 423226, 423168, 423166, 240938, 423075, 240933, 423073, 107387, 240931, 423375, 422522, 229166, 229162, 229160, 229158, 229154, 229152, 422290, 422288, 422283, 132234, 132233, 132230, 132227, 422281, 229118, 132214, 132206, 420068, 421255, 421692, 400206, 406568, 421253, 421251, 411071, 414721, 414706, 415620, 415617, 415615, 415612, 411042, 413989, 414447, 413509, 393860, 405356, 404109, 403989, 403728, 403726, 403724, 394218, 401388, 398733, 400215, 398731, 399404, 398863, 396639, 396636, 396634, 396623, 396621, 396955, 396935, 396612, 396610, 395621, 395608, 395574, 394877, 394875, 394871, 394869, 394895, 394866, 394740, 394209, 394454, 393990, 392602, 366803, 227675, 392600, 392683, 392706, 392678, 391841, 391837, 391827, 391822, 391688, 391819, 391675, 389647, 389520, 390781, 320357, 390779, 389644, 390293, 389517, 390291, 389642, 320352, 390288, 390286, 390285, 389515, 389512, 390284, 389508, 388691, 388689, 387205, 387266, 386597, 390160, 389464, 238890, 388659, 388592, 388590, 388656, 384324, 387432, 389081, 387430, 388582, 387264, 368693, 386558, 106500, 386909, 386907, 386905, 386556, 386553, 386594, 386551, 227472, 227470, 227468, 227458, 227455, 227435, 385236, 385235, 383252, 383251, 382987, 383245, 383257, 383241, 383289, 383239, 318517, 383062, 383058, 383126, 227293, 308680, 383051, 378447, 383044, 378444, 378442, 378439, 378436, 378426, 378418, 378415, 382607, 382605, 382603, 378410, 378408, 378406, 378404, 227275, 308672, 227270, 370502, 382359, 379731, 378398, 238513, 382353, 371289, 371287, 378395, 379585, 379278, 378391, 379276, 378389, 379274, 378386, 378384, 382091, 379261, 378380, 378378, 381654, 381651, 381648, 261701, 261697, 378371, 378368, 379581, 378360, 378358, 381474, 379257, 381472, 323170, 308664, 381471, 214473, 214472, 238488, 368692, 378350, 378347, 238484, 378646, 379150, 377397, 379147, 381881, 227224, 238477, 336444, 378339, 379139, 378334, 378331, 381316, 379250, 381311, 379247, 379245, 379637, 379636, 379634, 375836, 379710, 379708, 379706, 379697, 379695, 379693, 379703, 378330, 379558, 379629, 379556, 379627, 379626, 379690, 379576, 342753, 379223, 379213, 378640, 378638, 378636, 378634, 378632, 378630, 379112, 378050, 378627, 379109, 227186, 379082, 379037, 378624, 227182, 378322, 346293, 378313, 377011, 342748, 378485, 378311, 378483, 378554, 378481, 378551, 378527, 368691, 377529, 377527, 377526, 377513, 106298, 355507, 355505, 106288, 355503, 374928, 355499, 375826, 368688, 374867, 377289, 377034, 106282, 377274, 377271, 306047, 377266, 306045, 306041, 376893, 376885, 376883, 373722, 375104, 375803, 375818, 375816, 375788, 375786, 375784, 214212, 308623, 375092, 375090, 375087, 308620, 375139, 308617, 308614, 308612, 375085, 375364, 375361, 375360, 375358, 375356, 375347, 375343, 375341, 375337, 375320, 375318, 375317, 375314, 375009, 374915, 261148, 374912, 374567, 374564, 374620, 374396, 368685, 374574, 374559, 373720, 374369, 372210, 374182, 372993, 372992, 261145, 372733, 226923, 374164, 366887, 373857, 261142, 374177, 261140, 374173, 374171, 373957, 373955, 373622, 226919, 214103, 373816, 373953, 214101, 370500, 372988, 373465, 261137, 373897, 373463, 373951, 373950, 373717, 373731, 131813, 373449, 373447, 373441, 373139, 373079, 372555, 372552, 372370, 372798, 372748, 372650, 372541, 348662, 213906, 366126, 372279, 213904, 333389, 366123, 371279, 371277, 370885, 370230, 213801, 106042, 361663, 370074, 370001, 369934, 369774, 369767, 368934, 368931, 368677, 368927, 368675, 368562, 368559, 368557, 368555, 368552, 368549, 368546, 368543, 368541, 368539, 368538, 368534, 368533, 368529, 368525, 368521, 366092, 362526, 357806, 366802, 366798, 106021, 366795, 366793, 366791, 366788, 366808, 366784, 366782, 366090, 366587, 365383, 332350, 365108, 342728, 365376, 105991, 366193, 366191, 366189, 355287, 355285, 365690, 105974, 365374, 365389, 364551, 340893, 328831, 357949, 213477, 364410, 213462, 303164, 105929, 105927, 308552, 213459, 364284, 105918, 363927, 105912, 105909, 363948, 363481, 363889, 363887, 363883, 363880, 363876, 363874, 363871, 363870, 363868, 363867, 363399, 363185, 363496, 363183, 363181, 363179, 363395, 358730, 362672, 358728, 363176, 362887, 363171, 363167, 363158, 356518, 352959, 360417, 360559, 360409, 358886, 358883, 357796, 356971, 357020, 357643, 355467, 357494, 357490, 357484, 357482, 357480, 355192, 355189, 354362, 261693, 354360, 354358, 352948, 353225, 353223, 353222, 352633, 352626, 352944, 352754, 352941, 352939, 352922, 349341, 352006, 352481, 352816, 352815, 306026, 352741, 306024, 352559, 306022, 306020, 352467, 306018, 352032, 352031, 352557, 352553, 352551, 352460, 352026, 352025, 352458, 352023, 306015, 350676, 352449, 338601, 350881, 212660, 350879, 268837, 350875, 306012, 352020, 352019, 338596, 352004, 212649, 352069, 352068, 351998, 351996, 303059, 346764, 349322, 306009, 346762, 352016, 342688, 351397, 339259, 351388, 351386, 348653, 350178, 349311, 349307, 331564, 225204, 348651, 335234, 331555, 331553, 348877, 345322, 348874, 348872, 348887, 348870, 342684, 345081, 299630, 348033, 343799, 319433, 347483, 131597, 333198, 347038, 319431, 346632, 345887, 345079, 345311, 345076, 345074, 345107, 340378, 327975, 296700, 342612, 342526, 332998, 340371, 341620, 341903, 341854, 341852, 341850, 341849, 341845, 341843, 341841, 341840, 341839, 341838, 341635, 341632, 339996, 341290, 341288, 340118, 340115, 340045, 334595, 339249, 339242, 339239, 339238, 339235, 339233, 339216, 339214, 339097, 339058, 338995, 339056, 338993, 338506, 331005, 338228, 318179, 338680, 338421, 338414, 338503, 338411, 336437, 337568, 337280, 328819, 336906, 336892, 336662, 336392, 336434, 336432, 336431, 336428, 336425, 334447, 336423, 336418, 336415, 335846, 335843, 334870, 334868, 335839, 334434, 334402, 328808, 335233, 335356, 335230, 335228, 328793, 328457, 328454, 304476, 326829, 326825, 311786, 311782, 321791, 321789, 321788, 321783, 321776, 321773, 321771, 321770, 305889, 316993, 316900, 316897, 316895, 318223, 321584, 318220, 318218, 318216, 321574, 313644, 313642, 318214, 321455, 299674, 297180, 297176, 296961, 295736, 294300, 294298, 291951, 294292, 254628, 210023, 294285, 294276, 294271, 294267, 294264, 294505, 287300, 284535, 268340, 268338, 285669, 285667, 285665, 285662, 126146, 279378, 131254, 282907, 273614, 271038, 269676, 271256, 266271, 266259, 266257, 269809, 223017, 223014, 131222, 268599, 268592, 268590, 223000, 268588, 268582, 222995, 269993, 269990, 269984, 268299, 266558, 77357, 266633, 266243, 266239, 266238, 266195, 266193, 266191, 264500, 263606, 204428, 204674, 204671, 204669, 204663, 204660, 204406, 204401, 204463, 174632, 203516, 203514, 203513, 203511, 203151, 195158, 195140, 195137, 173813, 168475, 171222, 171920, 171554, 171219, 171208, 171204, 171194, 171193, 171191, 170330, 170328, 170325, 170319, 170317, 170171, 169314, 169310, 169308, 166279, 166069, 164144, 162142, 164142, 164140, 164139, 164137, 164135, 164132, 164130, 164128, 164126, 164116, 164109, 164107, 164105, 164103, 164101, 164094, 164093, 164090, 164085, 164083, 164081, 164080, 164077))
Run Time: 0.058899
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1449 | |
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 | | | | | 1449 | |
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 (30897, 29924, 29524, 29271, 28808, 28706, 28321, 28171, 27650, 27562, 27532, 27233, 26843, 26442, 26357, 26343, 25965, 25887, 24723, 24647, 24606, 24265, 24018, 22927, 22846, 22640, 22604, 22600, 22524, 22471, 22434, 22308, 22279, 22098, 21980, 21278, 20647, 20129, 20031, 19830, 19650, 19599, 19384, 19241, 19194, 19178, 19068, 19030, 18985, 18984, 18825, 18793, 18738, 18718, 18640, 18620, 18604, 18554, 18439, 18438, 18428, 18420, 18370, 18322, 18232, 18189, 18162, 18154, 18081, 17843, 17611, 17601, 17593, 17576, 17562, 17510, 17400, 17381, 16947, 16936, 16766, 16755, 16745, 16572, 16529, 16208, 16005, 15978, 14312, 13650, 13646, 12516, 12501, 12441, 12300, 12298, 11361, 11311, 11248, 11058, 10953))
Run Time: 0.008069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 101 | 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 (593642, 440603, 590277, 590275, 234881, 234304, 234055, 234053, 234051, 234047, 222426, 234020, 234018, 573447, 573438, 573433, 222423, 222421, 222419, 549705, 222418, 570665, 432884, 549664, 549662, 570664, 570663, 419817, 551937, 571035, 569811, 133136, 220802, 569958, 570653, 309588, 497504, 233753, 541928, 570435, 569449, 569734, 569441, 138400, 567516, 565077, 567513, 381831, 567121, 554893, 567013, 417868, 564843, 564932, 558725, 564364, 488435, 488433, 563931, 563673, 563671, 563669, 244455, 244451, 555220, 560438, 515783, 549613, 549610, 549604, 558965, 558954, 558951, 558371, 549550, 405792, 405787, 557835, 556502, 554829, 552769, 133023, 620647, 620644, 620641, 552114, 620627, 551822, 620622, 620619, 551819, 620617, 620608, 551303, 550857, 550855, 550854, 550851, 550849, 550847, 550844, 550840, 550793, 549933, 549930, 549520, 548519, 132955, 548216, 430260, 430257, 430252, 430248, 547534, 546743, 430139, 491054, 541756, 541753, 541750, 430015, 430007, 430000, 546731, 540175, 429938, 200099, 542093, 544982, 544980, 327238, 321188, 429837, 368283, 543615, 544734, 544732, 368276, 543612, 544730, 544727, 540142, 540135, 543595, 368267, 368266, 539241, 539239, 539237, 200004, 538823, 243935, 232516, 232508, 538475, 232506, 132878, 537574, 453543, 537604, 258063, 428925, 428923, 428917, 528437, 527324, 526566, 199926, 528041, 528033, 321149, 321146, 333729, 321143, 428068, 428067, 428064, 428063, 428061, 428056, 514888, 333713, 510029, 512111, 505197, 518469, 518468, 518810, 470988, 419769, 132780, 517128, 488389, 517275, 517273, 492621, 517125, 232119, 232097, 232095, 514455, 514779, 514798, 243548, 243544, 514794, 514792, 513618, 513887, 513096, 513874, 513871, 513869, 513790, 513614, 513612, 513610, 232073, 108391, 499418, 499416, 513234, 243484, 243482, 243430, 243425, 510115, 243419, 453122, 488018, 508125, 507116, 507114, 507113, 199578, 367326, 243261, 505354, 505179, 505346, 317117, 505174, 505172, 243191, 243189, 504775, 504550, 464634, 464632, 349403, 464630, 503536, 342799, 342795, 132753, 503352, 618978, 426544, 502478, 502468, 502764, 331627, 502455, 502453, 502451, 502449, 502447, 502445, 502443, 502441, 331616, 331614, 231512, 400106, 231510, 331610, 132746, 132745, 268967, 268964, 268962, 268959, 488168, 372526, 488166, 453118, 368942, 242955, 242873, 491797, 492069, 242771, 242768, 242761, 490392, 490380, 490379, 490369, 490170, 489603, 230807, 230805, 489522, 489317, 489305, 489195, 486657, 425124, 483074, 483072, 199088, 258054, 474903, 474901, 482289, 425073, 425071, 425069, 425067, 419748, 425059, 242427, 480689, 481983, 480757, 480756, 480643, 480751, 480550, 480548, 242344, 460804, 479404, 477791, 242310, 464302, 459782, 198486, 463784, 132442, 461423, 463155, 462975, 241649, 368364, 241623, 241619, 461599, 461585, 132399, 461757, 461661, 461560, 461755, 461752, 461749, 461747, 461743, 461742, 461741, 461740, 461739, 461519, 461508, 461506, 107666, 461417, 459592, 461414, 320692, 460305, 458297, 460302, 453109, 460333, 460320, 460318, 460315, 453105, 453102, 229733, 459583, 336231, 336229, 132345, 458773, 458906, 458903, 458515, 458887, 458899, 458885, 458355, 198323, 458346, 56441, 458497, 458495, 458492, 458152, 458148, 458335, 458331, 458146, 458285, 458283, 458281, 458279, 458134, 457957, 458160, 458111, 458130, 457069, 457543, 457229, 198286, 198284, 457060, 198278, 456992, 456989, 456985, 456982, 397066, 456830, 456729, 394275, 394273, 456725, 456362, 455732, 455997, 241366, 455876, 241364, 132285, 110207, 453344, 229650, 229646, 229640, 229638, 229623, 229621, 448553, 455009, 420537, 229619, 229613, 229609, 229606, 455238, 417284, 455547, 455233, 388728, 454417, 454412, 452182, 418932, 453089, 454079, 453086, 198179, 418928, 418925, 418922, 333578, 418916, 453064, 452688, 107509, 216462, 617627, 422292, 359927, 342773, 452048, 617579, 451813, 229472, 451451, 318310, 451487, 451411, 451409, 617548, 451403, 451393, 451391, 449602, 449600, 450456, 450454, 617540, 617538, 203386, 110191, 367099, 107478, 412976, 451269, 203382, 333571, 229447, 449351, 449349, 449345, 449329, 449326, 449061, 449324, 449321, 449317, 449315, 449059, 423106, 423103, 448978, 449032, 448947, 448946, 448944, 448942, 389941, 359923, 359921, 359919, 448932, 448930, 448926, 448924, 448922, 448919, 448841, 448828, 448826, 448759, 354737, 354735, 354733, 448523, 448448, 448446, 448305, 423576, 423566, 447790, 423561, 423553, 423546, 423543, 381444, 229278, 423098, 423434, 216267, 423086, 421818, 423084, 240942, 423082, 240940, 423077, 423226, 423168, 423166, 240938, 423075, 240933, 423073, 107387, 240931, 423375, 422522, 229166, 229162, 229160, 229158, 229154, 229152, 422290, 422288, 422283, 132234, 132233, 132230, 132227, 422281, 229118, 132214, 132206, 420068, 421255, 421692, 400206, 406568, 421253, 421251, 411071, 414721, 414706, 415620, 415617, 415615, 415612, 411042, 413989, 414447, 413509, 393860, 405356, 404109, 403989, 403728, 403726, 403724, 394218, 401388, 398733, 400215, 398731, 399404, 398863, 396639, 396636, 396634, 396623, 396621, 396955, 396935, 396612, 396610, 395621, 395608, 395574, 394877, 394875, 394871, 394869, 394895, 394866, 394740, 394209, 394454, 393990, 392602, 366803, 227675, 392600, 392683, 392706, 392678, 391841, 391837, 391827, 391822, 391688, 391819, 391675, 389647, 389520, 390781, 320357, 390779, 389644, 390293, 389517, 390291, 389642, 320352, 390288, 390286, 390285, 389515, 389512, 390284, 389508, 388691, 388689, 387205, 387266, 386597, 390160, 389464, 238890, 388659, 388592, 388590, 388656, 384324, 387432, 389081, 387430, 388582, 387264, 368693, 386558, 106500, 386909, 386907, 386905, 386556, 386553, 386594, 386551, 227472, 227470, 227468, 227458, 227455, 227435, 385236, 385235, 383252, 383251, 382987, 383245, 383257, 383241, 383289, 383239, 318517, 383062, 383058, 383126, 227293, 308680, 383051, 378447, 383044, 378444, 378442, 378439, 378436, 378426, 378418, 378415, 382607, 382605, 382603, 378410, 378408, 378406, 378404, 227275, 308672, 227270, 370502, 382359, 379731, 378398, 238513, 382353, 371289, 371287, 378395, 379585, 379278, 378391, 379276, 378389, 379274, 378386, 378384, 382091, 379261, 378380, 378378, 381654, 381651, 381648, 261701, 261697, 378371, 378368, 379581, 378360, 378358, 381474, 379257, 381472, 323170, 308664, 381471, 214473, 214472, 238488, 368692, 378350, 378347, 238484, 378646, 379150, 377397, 379147, 381881, 227224, 238477, 336444, 378339, 379139, 378334, 378331, 381316, 379250, 381311, 379247, 379245, 379637, 379636, 379634, 375836, 379710, 379708, 379706, 379697, 379695, 379693, 379703, 378330, 379558, 379629, 379556, 379627, 379626, 379690, 379576, 342753, 379223, 379213, 378640, 378638, 378636, 378634, 378632, 378630, 379112, 378050, 378627, 379109, 227186, 379082, 379037, 378624, 227182, 378322, 346293, 378313, 377011, 342748, 378485, 378311, 378483, 378554, 378481, 378551, 378527, 368691, 377529, 377527, 377526, 377513, 106298, 355507, 355505, 106288, 355503, 374928, 355499, 375826, 368688, 374867, 377289, 377034, 106282, 377274, 377271, 306047, 377266, 306045, 306041, 376893, 376885, 376883, 373722, 375104, 375803, 375818, 375816, 375788, 375786, 375784, 214212, 308623, 375092, 375090, 375087, 308620, 375139, 308617, 308614, 308612, 375085, 375364, 375361, 375360, 375358, 375356, 375347, 375343, 375341, 375337, 375320, 375318, 375317, 375314, 375009, 374915, 261148, 374912, 374567, 374564, 374620, 374396, 368685, 374574, 374559, 373720, 374369, 372210, 374182, 372993, 372992, 261145, 372733, 226923, 374164, 366887, 373857, 261142, 374177, 261140, 374173, 374171, 373957, 373955, 373622, 226919, 214103, 373816, 373953, 214101, 370500, 372988, 373465, 261137, 373897, 373463, 373951, 373950, 373717, 373731, 131813, 373449, 373447, 373441, 373139, 373079, 372555, 372552, 372370, 372798, 372748, 372650, 372541, 348662, 213906, 366126, 372279, 213904, 333389, 366123, 371279, 371277, 370885, 370230, 213801, 106042, 361663, 370074, 370001, 369934, 369774, 369767, 368934, 368931, 368677, 368927, 368675, 368562, 368559, 368557, 368555, 368552, 368549, 368546, 368543, 368541, 368539, 368538, 368534, 368533, 368529, 368525, 368521, 366092, 362526, 357806, 366802, 366798, 106021, 366795, 366793, 366791, 366788, 366808, 366784, 366782, 366090, 366587, 365383, 332350, 365108, 342728, 365376, 105991, 366193, 366191, 366189, 355287, 355285, 365690, 105974, 365374, 365389, 364551, 340893, 328831, 357949, 213477, 364410, 213462, 303164, 105929, 105927, 308552, 213459, 364284, 105918, 363927, 105912, 105909, 363948, 363481, 363889, 363887, 363883, 363880, 363876, 363874, 363871, 363870, 363868, 363867, 363399, 363185, 363496, 363183, 363181, 363179, 363395, 358730, 362672, 358728, 363176, 362887, 363171, 363167, 363158, 356518, 352959, 360417, 360559, 360409, 358886, 358883, 357796, 356971, 357020, 357643, 355467, 357494, 357490, 357484, 357482, 357480, 355192, 355189, 354362, 261693, 354360, 354358, 352948, 353225, 353223, 353222, 352633, 352626, 352944, 352754, 352941, 352939, 352922, 349341, 352006, 352481, 352816, 352815, 306026, 352741, 306024, 352559, 306022, 306020, 352467, 306018, 352032, 352031, 352557, 352553, 352551, 352460, 352026, 352025, 352458, 352023, 306015, 350676, 352449, 338601, 350881, 212660, 350879, 268837, 350875, 306012, 352020, 352019, 338596, 352004, 212649, 352069, 352068, 351998, 351996, 303059, 346764, 349322, 306009, 346762, 352016, 342688, 351397, 339259, 351388, 351386, 348653, 350178, 349311, 349307, 331564, 225204, 348651, 335234, 331555, 331553, 348877, 345322, 348874, 348872, 348887, 348870, 342684, 345081, 299630, 348033, 343799, 319433, 347483, 131597, 333198, 347038, 319431, 346632, 345887, 345079, 345311, 345076, 345074, 345107, 340378, 327975, 296700, 342612, 342526, 332998, 340371, 341620, 341903, 341854, 341852, 341850, 341849, 341845, 341843, 341841, 341840, 341839, 341838, 341635, 341632, 339996, 341290, 341288, 340118, 340115, 340045, 334595, 339249, 339242, 339239, 339238, 339235, 339233, 339216, 339214, 339097, 339058, 338995, 339056, 338993, 338506, 331005, 338228, 318179, 338680, 338421, 338414, 338503, 338411, 336437, 337568, 337280, 328819, 336906, 336892, 336662, 336392, 336434, 336432, 336431, 336428, 336425, 334447, 336423, 336418, 336415, 335846, 335843, 334870, 334868, 335839, 334434, 334402, 328808, 335233, 335356, 335230, 335228, 328793, 328457, 328454, 304476, 326829, 326825, 311786, 311782, 321791, 321789, 321788, 321783, 321776, 321773, 321771, 321770, 305889, 316993, 316900, 316897, 316895, 318223, 321584, 318220, 318218, 318216, 321574, 313644, 313642, 318214, 321455, 299674, 297180, 297176, 296961, 295736, 294300, 294298, 291951, 294292, 254628, 210023, 294285, 294276, 294271, 294267, 294264, 294505, 287300, 284535, 268340, 268338, 285669, 285667, 285665, 285662, 126146, 279378, 131254, 282907, 273614, 271038, 269676, 271256, 266271, 266259, 266257, 269809, 223017, 223014, 131222, 268599, 268592, 268590, 223000, 268588, 268582, 222995, 269993, 269990, 269984, 268299, 266558, 77357, 266633, 266243, 266239, 266238, 266195, 266193, 266191, 264500, 263606, 204428, 204674, 204671, 204669, 204663, 204660, 204406, 204401, 204463, 174632, 203516, 203514, 203513, 203511, 203151, 195158, 195140, 195137, 173813, 168475, 171222, 171920, 171554, 171219, 171208, 171204, 171194, 171193, 171191, 170330, 170328, 170325, 170319, 170317, 170171, 169314, 169310, 169308, 166279, 166069, 164144, 162142, 164142, 164140, 164139, 164137, 164135, 164132, 164130, 164128, 164126, 164116, 164109, 164107, 164105, 164103, 164101, 164094, 164093, 164090, 164085, 164083, 164081, 164080, 164077))
Run Time: 0.028855
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1449 | |
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 | | | | | 1449 | |
DERIVED | | | | | | | | No tables used |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (30897, 29924, 29524, 29271, 28808, 28706, 28321, 28171, 27650, 27562, 27532, 27233, 26843, 26442, 26357, 26343, 25965, 25887, 24723, 24647, 24606, 24265, 24018, 22927, 22846, 22640, 22604, 22600, 22524, 22471, 22434, 22308, 22279, 22098, 21980, 21278, 20647, 20129, 20031, 19830, 19650, 19599, 19384, 19241, 19194, 19178, 19068, 19030, 18985, 18984, 18825, 18793, 18738, 18718, 18640, 18620, 18604, 18554, 18439, 18438, 18428, 18420, 18370, 18322, 18232, 18189, 18162, 18154, 18081, 17843, 17611, 17601, 17593, 17576, 17562, 17510, 17400, 17381, 16947, 16936, 16766, 16755, 16745, 16572, 16529, 16208, 16005, 15978, 14312, 13650, 13646, 12516, 12501, 12441, 12300, 12298, 11361, 11311, 11248, 11058, 10953))
Run Time: 0.003668
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 101 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, v2�
Run Time: 0.000644
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000400
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.000551
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