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.000642
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.000266
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` = '6890')
LIMIT 1
Run Time: 0.000509
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.002660
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_6890' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.160843
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 (601332, 559079, 276352, 282602, 498658, 282600, 569039, 569034, 568970, 478129, 569078, 478125, 282591, 452119, 282588, 452117, 282586, 313237, 568736, 276345, 568933, 568734, 568840, 568730, 568728, 568838, 568821, 550721, 568802, 568637, 549143, 478095, 568710, 568359, 568726, 568723, 276335, 478088, 568708, 568745, 568780, 568777, 568703, 568714, 568700, 568693, 282557, 568691, 568685, 568672, 568603, 568632, 284153, 284151, 282548, 282545, 568140, 568525, 559212, 568138, 568136, 566962, 568430, 568435, 568131, 568127, 282536, 568122, 568120, 282535, 568384, 568364, 568362, 568356, 282532, 568335, 568272, 568236, 507075, 568222, 568039, 568037, 568035, 282530, 282526, 568117, 568112, 550352, 282517, 568110, 568077, 568088, 567950, 567190, 282507, 568018, 567770, 282502, 565610, 282492, 567255, 567844, 567804, 282485, 567838, 507072, 567756, 567253, 567745, 567733, 490732, 567642, 563966, 394971, 563964, 465247, 507069, 565608, 286558, 567243, 565604, 562475, 567482, 483859, 483857, 567235, 567413, 567445, 567410, 567406, 567404, 567439, 289657, 282471, 567434, 567442, 282466, 567367, 567378, 282464, 567201, 567398, 567229, 567376, 566196, 566194, 282461, 282458, 566188, 282457, 567268, 282456, 567223, 282454, 567183, 282451, 282449, 567159, 282444, 567155, 282443, 566186, 566939, 566926, 286538, 548550, 566890, 566816, 282435, 566819, 566759, 282431, 517607, 566813, 282428, 282426, 566757, 282425, 282424, 566753, 282418, 566686, 566600, 566171, 565329, 566168, 565599, 540559, 282416, 566445, 566333, 566161, 566156, 540554, 566311, 566017, 566116, 566237, 565582, 565511, 565420, 565580, 282404, 477705, 452976, 566134, 477703, 565577, 550040, 566013, 565967, 564897, 565689, 565803, 565683, 565322, 282391, 565303, 565570, 565677, 565318, 565412, 565316, 565410, 395278, 565314, 538190, 565301, 565312, 505165, 563458, 565275, 565255, 477692, 564688, 483835, 551160, 565034, 565032, 565021, 564996, 564985, 564790, 564680, 564575, 564573, 564786, 564676, 547885, 282369, 564610, 564613, 499146, 564257, 507557, 557866, 564338, 557864, 515132, 282363, 563954, 452962, 515129, 564246, 564207, 564272, 564205, 319119, 564224, 564228, 564125, 564123, 564132, 564137, 564077, 564066, 564013, 483825, 538186, 538184, 538182, 550475, 282352, 360147, 563632, 563450, 550473, 506814, 550470, 282348, 465244, 282345, 550469, 282342, 477676, 282340, 477671, 477668, 477665, 282333, 477659, 282329, 562899, 562917, 559375, 560849, 562904, 562891, 562884, 562882, 487323, 311044, 311041, 489644, 562273, 282315, 562682, 562676, 562534, 562636, 562545, 562471, 477642, 477638, 562384, 550467, 550465, 562339, 562264, 550458, 284142, 561166, 489630, 483817, 489629, 491253, 562179, 282301, 562294, 282298, 489617, 562146, 562118, 538173, 561642, 282288, 561609, 559071, 477619, 561601, 561530, 561538, 561534, 561414, 549136, 561242, 284138, 560032, 561155, 560897, 561192, 507067, 483808, 561087, 483806, 561017, 278760, 278758, 507064, 561063, 561038, 561059, 560921, 515123, 561026, 559067, 515116, 560954, 282271, 545391, 545389, 560888, 282261, 560880, 452951, 560858, 282257, 560815, 560839, 292828, 560821, 282254, 282250, 560771, 560770, 560804, 560818, 560809, 560767, 560802, 555159, 282248, 560798, 559850, 559847, 560360, 497280, 560498, 284131, 560357, 560354, 284128, 560293, 560291, 550319, 284127, 507061, 556936, 560283, 282230, 560240, 286514, 559506, 550316, 282221, 559502, 282219, 550314, 560216, 560157, 560163, 560154, 560149, 559603, 560068, 559991, 559601, 292819, 559958, 282180, 545449, 559946, 559978, 559965, 546377, 287174, 559931, 559820, 282169, 559818, 559828, 559887, 559815, 559796, 282154, 490707, 486262, 282150, 282148, 559646, 558558, 559654, 545381, 559473, 545379, 559611, 559472, 559470, 559545, 556289, 559543, 558098, 559396, 282142, 284123, 395262, 559457, 559392, 559342, 559261, 547072, 547068, 330996, 282137, 559084, 284117, 546374, 284114, 311031, 557394, 557782, 284111, 559027, 311029, 311028, 559007, 555909, 556449, 541003, 555907, 558391, 556903, 558943, 555900, 282133, 558895, 556887, 286509, 558172, 558839, 282127, 558837, 558289, 286507, 282125, 558287, 558614, 558547, 556871, 558568, 558118, 504742, 558356, 282120, 558167, 558142, 558154, 558096, 558151, 523759, 282116, 558087, 557846, 557845, 515618, 558035, 557875, 557843, 477609, 477604, 557795, 557774, 545362, 557738, 557415, 557737, 557470, 292817, 316606, 287094, 557189, 546459, 557152, 556987, 556985, 555857, 544444, 556983, 556182, 556180, 477599, 537044, 557042, 557102, 557097, 557033, 545356, 556432, 486249, 287090, 287088, 507518, 556373, 556724, 556681, 556678, 282108, 486242, 486239, 515072, 555561, 486237, 555833, 556618, 507515, 556525, 556393, 556389, 556523, 556514, 556508, 556387, 507513, 556234, 556385, 556378, 545345, 552108, 282102, 282100, 556257, 556229, 556224, 556172, 550307, 556114, 507622, 556103, 282099, 550301, 550297, 282095, 492405, 284108, 282093, 555654, 282086, 282084, 555555, 555335, 523750, 555388, 555322, 555320, 555318, 523742, 555187, 504731, 523740, 483803, 523738, 550697, 498633, 504729, 282080, 278755, 546455, 546449, 278748, 555182, 554826, 462866, 554779, 554774, 552900, 550880, 552807, 462834, 462833, 552620, 337072, 523736, 523734, 286484, 523732, 452944, 552458, 552575, 286482, 552542, 552485, 282072, 282068, 523729, 552480, 523724, 552476, 552352, 282067, 552244, 552243, 552134, 301510, 552085, 546354, 282054, 507620, 507617, 550035, 301545, 551856, 551875, 543416, 551738, 551786, 543410, 507615, 551637, 452925, 551580, 551578, 282051, 284102, 282047, 284100, 512478, 550690, 512476, 551432, 551340, 550358, 551014, 551230, 551012, 551200, 550935, 507611, 550933, 550437, 282043, 551059, 282041, 550432, 492382, 551009, 551056, 284096, 545021, 545019, 452919, 550424, 550863, 550831, 550828, 476082, 477595, 550420, 550926, 550418, 477588, 550416, 550410, 282036, 546343, 469629, 550406, 282031, 469627, 469626, 549778, 469625, 483802, 282023, 550396, 483798, 550577, 550391, 550574, 550277, 550387, 550521, 282016, 550519, 550517, 282014, 550378, 284091, 550373, 550371, 284089, 550369, 550144, 550365, 507605, 507603, 521762, 550362, 507601, 282006, 550134, 550112, 546335, 546328, 282002, 312659, 282000, 547884, 546323, 313234, 546317, 546315, 550011, 281992, 549907, 536876, 287084, 287079, 545016, 549888, 506251, 546307, 483796, 546437, 546302, 521261, 483794, 546299, 549814, 549817, 365972, 483792, 483786, 549105, 546296, 483783, 549097, 549773, 549771, 281984, 547244, 281979, 548901, 477585, 548735, 548730, 546290, 545774, 548667, 507055, 547237, 548483, 507053, 546288, 546285, 474219, 487317, 546279, 490683, 544528, 546270, 508519, 546246, 546242, 293720, 486597, 486595, 281972, 508979, 545701, 546239, 547883, 546600, 486232, 547092, 546236, 543716, 545302, 547849, 541167, 545556, 545699, 546003, 546727, 537405, 281968, 502060, 545314, 487764, 284084, 281966, 452912, 452911, 281964, 536847, 541108, 507052, 484729, 540939, 540591, 281831, 540581, 540547, 505116, 540575, 540542, 540509, 539297, 538732, 415022, 536661, 538785, 494156, 540033, 281825, 536659, 538133, 540231, 507049, 537016, 281823, 538502, 537806, 535500, 281798, 535193, 537503, 537411, 537444, 537437, 537392, 537390, 284069, 537365, 281770, 490632, 505934, 313056, 281766, 505931, 536889, 476013, 537086, 281763, 507044, 476006, 537084, 537090, 507042, 281754, 484555, 475996, 536976, 284068, 484549, 536899, 536884, 536719, 505110, 536713, 526858, 536710, 536702, 527168, 535462, 535494, 478880, 507040, 535483, 535141, 523720, 527227, 521250, 497154, 496133, 496131, 536547, 414994, 527126, 535098, 281748, 287024, 523353, 528067, 527065, 281735, 507033, 477537, 523717, 281730, 507031, 505101, 534962, 477531, 281726, 281499, 281495, 281492, 521860, 313225, 281488, 526493, 523704, 281483, 523820, 281477, 523853, 523696, 523791, 523816, 523833, 523663, 284044, 523660, 477512, 520163, 281446, 281443, 523779, 477501, 486221, 475906, 343702, 475903, 523458, 523456, 495912, 523410, 520144, 495910, 523405, 281427, 523145, 523155, 523042, 520141, 523346, 507010, 276266, 281407, 523284, 495900, 477497, 505026, 518351, 522493, 521833, 521904, 522859, 522831, 506215, 522829, 505022, 500652, 522815, 522563, 522149, 522576, 522520, 284029, 377484, 377482, 522725, 281361, 522743, 276250, 377480, 522533, 522140, 281359, 522560, 477484, 522445, 522439, 486208, 522057, 521702, 478056, 521240, 521813, 522113, 522055, 281315, 477480, 521227, 521761, 313213, 521919, 522046, 478053, 506210, 520563, 521758, 518174, 478051, 521800, 521915, 284023, 281296, 497086, 521756, 521754, 521768, 521751, 478044, 521747, 521742, 478042, 521716, 508974, 478040, 521573, 521722, 521569, 521557, 497076, 521197, 521474, 521318, 520480, 311561, 519430, 281273, 473160, 520478, 519593, 520939, 520309, 520362, 519335, 516492, 520580, 520245, 516437, 516435, 487280, 487277, 520113, 520227, 520107, 519832, 467605, 283993, 283991, 520104, 519694, 519822, 497007, 475847, 519646, 281244, 281242, 519564, 519633, 519562, 519520, 281230, 519152, 281228, 519419, 287009, 281225, 519417, 519435, 519324, 497001, 519304, 516640, 281222, 519150, 374144, 287007, 519121, 519118, 519040, 517968, 519022, 483781, 517966, 518986, 475815, 353324, 507986, 518563, 475812, 518925, 518922, 518777, 518558, 416341, 504992, 500626, 477420, 518544, 518532, 518527, 518541, 518510, 289630, 289625, 518369, 416334, 487263, 472224, 518283, 518347, 506189, 518345, 518288, 517983, 518275, 516359, 518236, 506187, 518223, 516634, 481867, 517579, 281171, 451981, 483779, 517789, 517647, 507007, 516355, 517029, 506987, 506985, 329017, 516990, 516621, 281134, 286996, 516162, 516619, 512340, 516345, 516336, 516334, 516329, 514289, 281129, 516658, 284722, 516710, 516617, 502025, 516142, 516766, 284720, 281116, 286987, 281113, 512695, 514274, 516140, 281106, 499757, 286983, 516169, 516291, 328173, 483777, 486202, 514380, 498591, 513754, 514267, 334115, 513574, 514061, 513572, 334107, 499748, 513570, 481864, 513815, 513014, 513011, 513065, 511676, 513009, 513074, 513029, 512998, 512685, 281068, 497450, 512996, 476507, 512682, 476505, 512678, 512470, 512676, 281064, 281062, 512461, 506984, 512268, 486197, 506181, 512273, 506982, 500199, 510687, 276189, 506375, 483770, 511112, 511158, 506178, 510485, 510859, 501002, 510805, 509421, 477382, 498808, 507594, 483760, 504981, 507591, 509400, 477371, 504978, 498803, 503181, 506169, 503179, 503175, 286957, 508775, 508614, 508894, 508773, 508314, 505671, 508609, 508892, 508900, 477363, 477362, 507580, 508592, 496856, 508771, 286955, 483752, 281045, 506759, 487231, 477350, 498784, 496843, 507712, 507715, 286951, 507571, 506978, 498553, 507647, 506976, 506974, 507567, 477345, 506971, 506807, 477337, 286949, 477335, 505781, 506539, 487214, 487212, 506969, 487210, 501501, 506537, 506966, 506805, 506535, 506757, 506533, 281042, 409907, 506515, 475642, 505906, 492255, 487204, 506353, 506155, 505898, 501496, 492253, 506504, 506442, 281037, 506033, 486179, 506029, 505896, 501380, 505387, 505767, 505788, 505857, 496820, 505633, 505623, 505383, 505578, 505372, 505407, 504881, 505366, 504874, 504871, 504912, 472846, 504538, 499840, 503932, 503987, 281029, 503588, 475576, 475573, 495742, 495737, 475567, 286946, 286943, 502921, 313029, 286940, 495731, 501997, 502094, 501991, 286420, 410362, 501867, 481098, 410360, 501222, 326192, 501220, 326186, 496129, 499832, 495169, 496127, 499829, 500962, 490584, 481068, 499998, 498530, 498527, 474367, 452856, 500016, 499955, 498523, 344888, 498520, 497552, 499712, 497550, 499227, 498219, 452854, 496493, 498203, 496125, 496611, 498027, 498073, 498023, 497886, 496747, 497469, 496605, 495001, 496218, 494620, 496216, 496280, 487173, 496189, 496124, 496117, 496115))
Run Time: 0.104958
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1464 | |
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 | | | | | 1464 | |
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 (29646, 29644, 28426, 28189, 27362, 26913, 26521, 25906, 25883, 25397, 25148))
Run Time: 0.001728
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 11 | 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 (601332, 559079, 276352, 282602, 498658, 282600, 569039, 569034, 568970, 478129, 569078, 478125, 282591, 452119, 282588, 452117, 282586, 313237, 568736, 276345, 568933, 568734, 568840, 568730, 568728, 568838, 568821, 550721, 568802, 568637, 549143, 478095, 568710, 568359, 568726, 568723, 276335, 478088, 568708, 568745, 568780, 568777, 568703, 568714, 568700, 568693, 282557, 568691, 568685, 568672, 568603, 568632, 284153, 284151, 282548, 282545, 568140, 568525, 559212, 568138, 568136, 566962, 568430, 568435, 568131, 568127, 282536, 568122, 568120, 282535, 568384, 568364, 568362, 568356, 282532, 568335, 568272, 568236, 507075, 568222, 568039, 568037, 568035, 282530, 282526, 568117, 568112, 550352, 282517, 568110, 568077, 568088, 567950, 567190, 282507, 568018, 567770, 282502, 565610, 282492, 567255, 567844, 567804, 282485, 567838, 507072, 567756, 567253, 567745, 567733, 490732, 567642, 563966, 394971, 563964, 465247, 507069, 565608, 286558, 567243, 565604, 562475, 567482, 483859, 483857, 567235, 567413, 567445, 567410, 567406, 567404, 567439, 289657, 282471, 567434, 567442, 282466, 567367, 567378, 282464, 567201, 567398, 567229, 567376, 566196, 566194, 282461, 282458, 566188, 282457, 567268, 282456, 567223, 282454, 567183, 282451, 282449, 567159, 282444, 567155, 282443, 566186, 566939, 566926, 286538, 548550, 566890, 566816, 282435, 566819, 566759, 282431, 517607, 566813, 282428, 282426, 566757, 282425, 282424, 566753, 282418, 566686, 566600, 566171, 565329, 566168, 565599, 540559, 282416, 566445, 566333, 566161, 566156, 540554, 566311, 566017, 566116, 566237, 565582, 565511, 565420, 565580, 282404, 477705, 452976, 566134, 477703, 565577, 550040, 566013, 565967, 564897, 565689, 565803, 565683, 565322, 282391, 565303, 565570, 565677, 565318, 565412, 565316, 565410, 395278, 565314, 538190, 565301, 565312, 505165, 563458, 565275, 565255, 477692, 564688, 483835, 551160, 565034, 565032, 565021, 564996, 564985, 564790, 564680, 564575, 564573, 564786, 564676, 547885, 282369, 564610, 564613, 499146, 564257, 507557, 557866, 564338, 557864, 515132, 282363, 563954, 452962, 515129, 564246, 564207, 564272, 564205, 319119, 564224, 564228, 564125, 564123, 564132, 564137, 564077, 564066, 564013, 483825, 538186, 538184, 538182, 550475, 282352, 360147, 563632, 563450, 550473, 506814, 550470, 282348, 465244, 282345, 550469, 282342, 477676, 282340, 477671, 477668, 477665, 282333, 477659, 282329, 562899, 562917, 559375, 560849, 562904, 562891, 562884, 562882, 487323, 311044, 311041, 489644, 562273, 282315, 562682, 562676, 562534, 562636, 562545, 562471, 477642, 477638, 562384, 550467, 550465, 562339, 562264, 550458, 284142, 561166, 489630, 483817, 489629, 491253, 562179, 282301, 562294, 282298, 489617, 562146, 562118, 538173, 561642, 282288, 561609, 559071, 477619, 561601, 561530, 561538, 561534, 561414, 549136, 561242, 284138, 560032, 561155, 560897, 561192, 507067, 483808, 561087, 483806, 561017, 278760, 278758, 507064, 561063, 561038, 561059, 560921, 515123, 561026, 559067, 515116, 560954, 282271, 545391, 545389, 560888, 282261, 560880, 452951, 560858, 282257, 560815, 560839, 292828, 560821, 282254, 282250, 560771, 560770, 560804, 560818, 560809, 560767, 560802, 555159, 282248, 560798, 559850, 559847, 560360, 497280, 560498, 284131, 560357, 560354, 284128, 560293, 560291, 550319, 284127, 507061, 556936, 560283, 282230, 560240, 286514, 559506, 550316, 282221, 559502, 282219, 550314, 560216, 560157, 560163, 560154, 560149, 559603, 560068, 559991, 559601, 292819, 559958, 282180, 545449, 559946, 559978, 559965, 546377, 287174, 559931, 559820, 282169, 559818, 559828, 559887, 559815, 559796, 282154, 490707, 486262, 282150, 282148, 559646, 558558, 559654, 545381, 559473, 545379, 559611, 559472, 559470, 559545, 556289, 559543, 558098, 559396, 282142, 284123, 395262, 559457, 559392, 559342, 559261, 547072, 547068, 330996, 282137, 559084, 284117, 546374, 284114, 311031, 557394, 557782, 284111, 559027, 311029, 311028, 559007, 555909, 556449, 541003, 555907, 558391, 556903, 558943, 555900, 282133, 558895, 556887, 286509, 558172, 558839, 282127, 558837, 558289, 286507, 282125, 558287, 558614, 558547, 556871, 558568, 558118, 504742, 558356, 282120, 558167, 558142, 558154, 558096, 558151, 523759, 282116, 558087, 557846, 557845, 515618, 558035, 557875, 557843, 477609, 477604, 557795, 557774, 545362, 557738, 557415, 557737, 557470, 292817, 316606, 287094, 557189, 546459, 557152, 556987, 556985, 555857, 544444, 556983, 556182, 556180, 477599, 537044, 557042, 557102, 557097, 557033, 545356, 556432, 486249, 287090, 287088, 507518, 556373, 556724, 556681, 556678, 282108, 486242, 486239, 515072, 555561, 486237, 555833, 556618, 507515, 556525, 556393, 556389, 556523, 556514, 556508, 556387, 507513, 556234, 556385, 556378, 545345, 552108, 282102, 282100, 556257, 556229, 556224, 556172, 550307, 556114, 507622, 556103, 282099, 550301, 550297, 282095, 492405, 284108, 282093, 555654, 282086, 282084, 555555, 555335, 523750, 555388, 555322, 555320, 555318, 523742, 555187, 504731, 523740, 483803, 523738, 550697, 498633, 504729, 282080, 278755, 546455, 546449, 278748, 555182, 554826, 462866, 554779, 554774, 552900, 550880, 552807, 462834, 462833, 552620, 337072, 523736, 523734, 286484, 523732, 452944, 552458, 552575, 286482, 552542, 552485, 282072, 282068, 523729, 552480, 523724, 552476, 552352, 282067, 552244, 552243, 552134, 301510, 552085, 546354, 282054, 507620, 507617, 550035, 301545, 551856, 551875, 543416, 551738, 551786, 543410, 507615, 551637, 452925, 551580, 551578, 282051, 284102, 282047, 284100, 512478, 550690, 512476, 551432, 551340, 550358, 551014, 551230, 551012, 551200, 550935, 507611, 550933, 550437, 282043, 551059, 282041, 550432, 492382, 551009, 551056, 284096, 545021, 545019, 452919, 550424, 550863, 550831, 550828, 476082, 477595, 550420, 550926, 550418, 477588, 550416, 550410, 282036, 546343, 469629, 550406, 282031, 469627, 469626, 549778, 469625, 483802, 282023, 550396, 483798, 550577, 550391, 550574, 550277, 550387, 550521, 282016, 550519, 550517, 282014, 550378, 284091, 550373, 550371, 284089, 550369, 550144, 550365, 507605, 507603, 521762, 550362, 507601, 282006, 550134, 550112, 546335, 546328, 282002, 312659, 282000, 547884, 546323, 313234, 546317, 546315, 550011, 281992, 549907, 536876, 287084, 287079, 545016, 549888, 506251, 546307, 483796, 546437, 546302, 521261, 483794, 546299, 549814, 549817, 365972, 483792, 483786, 549105, 546296, 483783, 549097, 549773, 549771, 281984, 547244, 281979, 548901, 477585, 548735, 548730, 546290, 545774, 548667, 507055, 547237, 548483, 507053, 546288, 546285, 474219, 487317, 546279, 490683, 544528, 546270, 508519, 546246, 546242, 293720, 486597, 486595, 281972, 508979, 545701, 546239, 547883, 546600, 486232, 547092, 546236, 543716, 545302, 547849, 541167, 545556, 545699, 546003, 546727, 537405, 281968, 502060, 545314, 487764, 284084, 281966, 452912, 452911, 281964, 536847, 541108, 507052, 484729, 540939, 540591, 281831, 540581, 540547, 505116, 540575, 540542, 540509, 539297, 538732, 415022, 536661, 538785, 494156, 540033, 281825, 536659, 538133, 540231, 507049, 537016, 281823, 538502, 537806, 535500, 281798, 535193, 537503, 537411, 537444, 537437, 537392, 537390, 284069, 537365, 281770, 490632, 505934, 313056, 281766, 505931, 536889, 476013, 537086, 281763, 507044, 476006, 537084, 537090, 507042, 281754, 484555, 475996, 536976, 284068, 484549, 536899, 536884, 536719, 505110, 536713, 526858, 536710, 536702, 527168, 535462, 535494, 478880, 507040, 535483, 535141, 523720, 527227, 521250, 497154, 496133, 496131, 536547, 414994, 527126, 535098, 281748, 287024, 523353, 528067, 527065, 281735, 507033, 477537, 523717, 281730, 507031, 505101, 534962, 477531, 281726, 281499, 281495, 281492, 521860, 313225, 281488, 526493, 523704, 281483, 523820, 281477, 523853, 523696, 523791, 523816, 523833, 523663, 284044, 523660, 477512, 520163, 281446, 281443, 523779, 477501, 486221, 475906, 343702, 475903, 523458, 523456, 495912, 523410, 520144, 495910, 523405, 281427, 523145, 523155, 523042, 520141, 523346, 507010, 276266, 281407, 523284, 495900, 477497, 505026, 518351, 522493, 521833, 521904, 522859, 522831, 506215, 522829, 505022, 500652, 522815, 522563, 522149, 522576, 522520, 284029, 377484, 377482, 522725, 281361, 522743, 276250, 377480, 522533, 522140, 281359, 522560, 477484, 522445, 522439, 486208, 522057, 521702, 478056, 521240, 521813, 522113, 522055, 281315, 477480, 521227, 521761, 313213, 521919, 522046, 478053, 506210, 520563, 521758, 518174, 478051, 521800, 521915, 284023, 281296, 497086, 521756, 521754, 521768, 521751, 478044, 521747, 521742, 478042, 521716, 508974, 478040, 521573, 521722, 521569, 521557, 497076, 521197, 521474, 521318, 520480, 311561, 519430, 281273, 473160, 520478, 519593, 520939, 520309, 520362, 519335, 516492, 520580, 520245, 516437, 516435, 487280, 487277, 520113, 520227, 520107, 519832, 467605, 283993, 283991, 520104, 519694, 519822, 497007, 475847, 519646, 281244, 281242, 519564, 519633, 519562, 519520, 281230, 519152, 281228, 519419, 287009, 281225, 519417, 519435, 519324, 497001, 519304, 516640, 281222, 519150, 374144, 287007, 519121, 519118, 519040, 517968, 519022, 483781, 517966, 518986, 475815, 353324, 507986, 518563, 475812, 518925, 518922, 518777, 518558, 416341, 504992, 500626, 477420, 518544, 518532, 518527, 518541, 518510, 289630, 289625, 518369, 416334, 487263, 472224, 518283, 518347, 506189, 518345, 518288, 517983, 518275, 516359, 518236, 506187, 518223, 516634, 481867, 517579, 281171, 451981, 483779, 517789, 517647, 507007, 516355, 517029, 506987, 506985, 329017, 516990, 516621, 281134, 286996, 516162, 516619, 512340, 516345, 516336, 516334, 516329, 514289, 281129, 516658, 284722, 516710, 516617, 502025, 516142, 516766, 284720, 281116, 286987, 281113, 512695, 514274, 516140, 281106, 499757, 286983, 516169, 516291, 328173, 483777, 486202, 514380, 498591, 513754, 514267, 334115, 513574, 514061, 513572, 334107, 499748, 513570, 481864, 513815, 513014, 513011, 513065, 511676, 513009, 513074, 513029, 512998, 512685, 281068, 497450, 512996, 476507, 512682, 476505, 512678, 512470, 512676, 281064, 281062, 512461, 506984, 512268, 486197, 506181, 512273, 506982, 500199, 510687, 276189, 506375, 483770, 511112, 511158, 506178, 510485, 510859, 501002, 510805, 509421, 477382, 498808, 507594, 483760, 504981, 507591, 509400, 477371, 504978, 498803, 503181, 506169, 503179, 503175, 286957, 508775, 508614, 508894, 508773, 508314, 505671, 508609, 508892, 508900, 477363, 477362, 507580, 508592, 496856, 508771, 286955, 483752, 281045, 506759, 487231, 477350, 498784, 496843, 507712, 507715, 286951, 507571, 506978, 498553, 507647, 506976, 506974, 507567, 477345, 506971, 506807, 477337, 286949, 477335, 505781, 506539, 487214, 487212, 506969, 487210, 501501, 506537, 506966, 506805, 506535, 506757, 506533, 281042, 409907, 506515, 475642, 505906, 492255, 487204, 506353, 506155, 505898, 501496, 492253, 506504, 506442, 281037, 506033, 486179, 506029, 505896, 501380, 505387, 505767, 505788, 505857, 496820, 505633, 505623, 505383, 505578, 505372, 505407, 504881, 505366, 504874, 504871, 504912, 472846, 504538, 499840, 503932, 503987, 281029, 503588, 475576, 475573, 495742, 495737, 475567, 286946, 286943, 502921, 313029, 286940, 495731, 501997, 502094, 501991, 286420, 410362, 501867, 481098, 410360, 501222, 326192, 501220, 326186, 496129, 499832, 495169, 496127, 499829, 500962, 490584, 481068, 499998, 498530, 498527, 474367, 452856, 500016, 499955, 498523, 344888, 498520, 497552, 499712, 497550, 499227, 498219, 452854, 496493, 498203, 496125, 496611, 498027, 498073, 498023, 497886, 496747, 497469, 496605, 495001, 496218, 494620, 496216, 496280, 487173, 496189, 496124, 496117, 496115))
Run Time: 0.030668
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1464 | |
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 | | | | | 1464 | |
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 (29646, 29644, 28426, 28189, 27362, 26913, 26521, 25906, 25883, 25397, 25148))
Run Time: 0.000940
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 11 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, �į
Run Time: 0.000171
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.000321
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 158
- 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 158
- 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: 1717134033
Run Time: 0.000341
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 17 | 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` >= 1717134033)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000599
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 17 | 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