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.000547
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.000220
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` = '6435')
LIMIT 1
Run Time: 0.000397
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.002166
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_6435' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.047654
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 (551034, 430157, 430128, 539453, 539451, 244091, 485711, 528868, 108687, 528826, 429468, 200046, 429395, 108640, 367477, 243990, 369124, 174298, 485640, 174285, 384233, 429173, 429170, 539424, 539403, 539400, 539399, 429113, 243950, 453551, 453548, 353139, 528692, 538910, 528685, 232514, 429045, 429043, 199975, 429005, 429002, 243892, 243890, 243887, 243886, 232441, 232427, 471031, 471026, 535779, 535777, 535264, 535252, 232412, 232410, 232406, 232402, 232397, 369108, 232363, 232361, 428773, 199934, 369105, 199923, 428756, 428747, 428722, 321155, 321152, 428706, 428691, 199918, 232310, 232308, 199911, 485536, 485534, 428545, 428543, 523227, 199898, 384227, 384225, 428477, 428466, 522258, 384223, 428454, 384221, 384219, 384216, 243704, 384215, 384213, 384211, 384210, 384208, 428379, 243670, 243667, 243665, 428316, 428307, 428297, 199871, 521336, 428268, 428266, 428264, 303325, 428260, 428257, 428249, 520985, 428232, 428228, 428226, 381608, 243645, 428207, 353136, 232265, 354471, 199864, 469019, 428155, 501640, 108555, 108553, 199857, 349155, 519894, 519891, 199855, 519855, 519842, 519627, 219045, 519625, 519623, 199852, 519617, 428060, 199850, 428041, 428039, 428037, 428033, 232250, 199846, 344562, 504388, 428004, 428002, 504384, 386882, 504382, 232240, 427980, 427977, 427958, 469016, 419775, 108532, 518804, 232232, 232230, 232228, 514500, 199824, 199822, 469853, 199820, 199814, 427878, 515713, 199808, 232197, 517237, 427855, 199805, 108524, 108521, 511792, 232190, 108509, 108481, 232168, 427810, 427807, 427802, 199796, 427800, 427798, 427796, 427793, 199795, 485444, 427785, 108440, 205877, 322940, 205869, 243585, 243583, 232144, 232142, 232140, 243576, 243574, 232136, 381606, 232124, 515708, 232122, 243570, 453499, 218849, 243554, 485429, 514459, 514454, 243547, 199782, 514443, 514414, 514412, 354468, 218830, 218817, 218814, 330301, 427707, 330300, 427705, 427702, 511790, 199775, 513086, 349143, 330298, 427689, 469012, 232072, 495085, 495083, 453497, 232056, 243529, 512080, 309305, 199766, 129090, 427642, 199763, 511785, 511783, 427614, 369092, 469007, 427589, 511755, 511726, 199751, 427558, 427554, 427550, 427546, 427530, 427525, 369088, 427506, 243486, 199740, 427499, 469003, 199736, 427486, 353129, 427483, 199732, 427480, 427478, 427476, 232033, 199724, 427469, 427466, 427463, 427461, 485386, 485384, 199719, 232009, 453490, 243460, 199713, 243458, 362379, 362377, 427420, 243453, 427418, 199712, 463548, 504808, 323572, 485375, 427410, 199711, 504806, 504797, 199708, 469001, 427394, 427391, 427388, 199703, 199701, 485374, 329354, 427344, 427341, 427334, 243437, 353127, 325846, 353126, 353124, 614584, 231988, 199690, 231986, 243429, 199686, 199677, 510091, 199672, 453484, 504380, 510071, 323561, 427273, 510061, 427267, 510059, 485360, 199671, 510057, 427253, 427221, 427209, 323558, 108377, 485358, 381602, 344549, 199654, 427188, 344547, 427174, 427171, 427168, 199646, 416072, 243389, 353120, 243388, 493478, 493476, 231930, 108350, 199632, 108341, 108336, 108333, 199631, 199624, 508857, 243384, 427110, 427108, 199620, 427093, 427089, 199616, 360814, 411920, 463524, 463522, 231893, 463520, 309267, 504379, 309258, 309256, 427065, 508269, 309246, 427057, 199605, 353117, 427049, 427047, 427044, 427042, 427040, 427038, 427036, 485344, 427023, 108311, 108309, 338970, 338965, 376225, 199600, 376222, 376220, 376218, 507950, 205841, 218507, 199595, 330273, 309229, 309226, 309224, 218503, 309197, 243352, 376214, 376212, 376210, 309192, 309189, 243328, 386879, 426943, 199591, 199589, 507190, 507188, 507184, 231877, 243320, 243315, 506785, 330271, 506780, 218490, 299344, 218487, 231871, 504374, 231868, 506892, 506860, 506650, 504794, 199569, 504792, 199567, 504789, 504373, 108289, 218473, 309188, 309186, 309184, 329349, 309178, 309175, 309172, 309169, 309167, 506290, 506282, 506277, 506274, 309162, 309160, 231843, 309146, 199559, 243291, 309059, 309056, 309054, 309051, 309048, 309045, 309043, 199555, 243279, 402721, 505616, 199551, 199541, 218446, 421870, 231830, 231828, 231826, 243271, 243256, 243253, 243241, 243233, 453477, 243225, 243219, 243217, 243214, 243211, 243209, 243207, 505398, 354457, 199535, 317154, 243201, 199533, 504370, 504368, 504366, 485319, 485317, 325843, 504363, 485314, 199528, 504918, 199527, 504770, 426763, 401021, 401019, 468987, 426747, 231774, 401006, 426740, 354455, 401002, 231747, 199523, 231739, 231736, 368229, 199520, 231728, 485301, 199519, 199516, 426667, 231705, 504126, 199510, 426663, 504115, 504111, 504108, 400109, 243160, 243158, 455412, 231681, 199501, 243135, 231637, 205825, 426646, 231630, 231628, 231625, 231623, 199496, 243127, 504057, 426634, 243114, 218340, 353114, 324326, 426615, 426595, 199494, 367305, 503666, 503659, 243052, 243049, 205824, 218309, 426576, 468984, 349133, 199481, 231550, 503478, 503437, 503431, 329345, 421202, 199479, 502160, 231532, 218288, 108256, 325841, 468979, 468977, 325840, 199476, 426545, 108253, 322928, 108251, 502900, 502896, 502893, 502889, 502887, 353113, 426524, 426522, 426518, 426516, 502769, 502767, 502765, 426513, 502760, 502758, 624739, 321058, 205822, 321055, 218280, 199473, 463478, 463475, 453472, 463472, 453470, 499568, 325839, 268991, 268989, 268987, 268984, 268981, 268977, 268975, 453466, 463470, 199470, 463467, 426445, 426443, 199465, 426441, 231485, 231482, 231480, 325838, 231477, 231474, 353111, 353110, 426438, 389160, 243017, 231458, 231456, 453463, 333661, 426414, 426403, 426401, 463464, 426395, 426393, 426391, 426389, 426386, 426384, 323545, 243005, 417792, 426365, 426349, 108240, 426323, 624719, 199456, 426289, 426287, 199454, 493434, 207541, 426278, 426253, 207533, 501280, 386875, 199452, 218209, 218202, 199450, 199449, 308994, 308992, 308989, 308987, 199446, 499320, 500870, 274648, 500859, 500857, 199439, 500490, 499318, 349130, 349129, 498940, 231399, 231396, 231394, 231389, 199435, 199433, 218173, 500447, 500445, 199432, 349128, 231385, 231383, 453460, 349127, 199428, 624712, 624709, 463458, 463455, 231367, 231365, 426206, 323537, 426204, 426202, 231358, 199424, 426199, 426197, 108219, 108216, 108215, 108209, 369077, 231342, 231339, 231336, 231334, 231331, 368944, 231328, 199420, 108204, 108202, 108200, 108198, 108196, 108194, 108192, 199418, 322923, 242956, 108190, 108186, 499537, 108184, 199417, 499534, 108182, 499051, 108172, 218133, 499049, 499047, 426176, 199416, 497714, 324324, 426174, 426172, 426170, 426168, 426166, 426164, 426162, 426160, 330245, 218131, 231311, 231309, 231305, 218127, 624697, 498933, 426153, 624694, 426148, 349126, 199413, 499072, 386873, 199411, 498924, 426130, 426120, 624689, 199409, 242944, 490108, 499045, 322922, 453458, 231298, 231296, 468972, 468970, 468967, 468965, 468963, 468960, 468957, 426071, 624686, 199405, 426059, 468951, 231287, 468949, 468947, 468944, 231283, 231281, 231278, 231276, 231274, 388155, 373913, 498918, 497950, 199403, 624684, 426056, 468942, 468940, 468937, 468932, 426040, 426034, 426022, 330237, 199401, 498725, 495531, 426019, 426017, 218076, 498460, 498450, 498448, 199396, 325836, 205808, 205805, 199395, 624680, 490323, 242932, 242928, 231259, 231248, 231246, 242926, 231243, 231241, 231236, 231225, 231221, 231218, 231216, 497404, 324323, 426006, 218058, 426002, 425998, 425991, 624676, 425988, 425986, 199392, 425980, 425976, 425971, 425964, 425962, 425958, 425955, 425953, 497897, 497401, 497893, 425951, 324321, 218053, 349124, 231178, 231176, 485254, 497398, 497396, 497394, 199389, 242915, 242909, 624665, 497483, 242904, 199386, 218043, 108124, 367274, 386870, 497382, 425934, 624663, 108116, 199384, 108110, 108107, 108098, 108090, 199383, 108086, 624661, 321018, 624657, 368185, 368182, 455396, 485246, 496437, 496435, 386868, 495423, 496433, 496431, 242885, 199378, 218020, 425925, 468930, 353109, 624647, 108079, 624644, 624642, 624640, 624638, 496101, 496095, 496093, 624636, 199376, 425899, 425895, 322921, 425874, 495612, 218003, 425869, 493919, 493917, 493913, 493908, 493906, 492344, 199374, 455352, 455350, 231168, 455346, 455337, 425860, 455334, 495603, 231164, 217991, 493424, 376205, 199373, 199372, 495417, 231159, 495415, 495413, 495507, 495411, 495409, 322920, 495407, 495405, 495403, 495401, 199369, 231153, 231150, 231148, 231146, 231144, 231142, 495441, 624632, 495384, 495378, 495361, 495076, 495074, 199364, 411837, 376204, 386866, 495340, 479212, 455324, 217983, 242879, 199361, 494873, 624628, 495097, 321011, 321009, 416064, 217966, 199359, 425832, 494840, 493411, 494832, 231129, 199355, 417776, 417774, 199353, 425823, 417771, 425819, 425816, 231122, 494781, 425812, 494609, 494607, 324989, 494605, 265532, 417760, 199347, 367266, 483498, 494494, 425803, 425801, 353108, 493405, 493403, 493401, 493399, 493397, 217951, 493395, 493393, 493391, 425795, 322919, 425789, 217947, 425787, 425785, 493387, 493381, 425777, 425775, 199336, 353107, 494351, 493372, 231108, 199335, 353105, 493361, 493357, 322918, 425746, 199334, 414811, 425742, 425737, 494286, 494284, 324315, 485235, 614565, 199332, 421753, 485232, 199330, 411833, 399714, 199328, 425721, 493894, 199326, 425717, 493984, 231089, 489016, 399271, 324314, 493876, 231086, 217922, 242848, 242846, 231075, 199321, 217916, 425710, 483486, 199312, 349122, 493762, 217912, 303304, 303296, 199307, 425702, 492999, 624618, 425697, 323531, 493289, 242818, 492959, 231061, 231059, 231057, 328402, 231053, 199305, 199303, 231051, 318342, 231048, 493272, 231046, 231044, 242814, 231042, 318340, 318337, 231038, 231036, 231034, 231032, 231030, 231028, 493161, 493159, 425689, 199300, 217903, 217896, 231020, 231018, 231016, 231014, 231012, 231009, 242808, 231006, 231004, 231002, 492992, 199297, 199295, 242805, 492946, 492939, 492669, 425675, 330218, 492989, 242800, 376198, 492775, 230991, 242794, 386865, 322460, 492606, 492604, 488612, 199294, 386863, 425659, 425657, 393809, 453450, 492463, 254141, 254120, 254118, 199289, 398830, 199288, 217867, 404667, 199282, 492449, 404664, 199280, 425647, 491778, 353104, 425636, 325833, 199277, 230985, 199274, 242787, 425634, 425632, 425629, 469391, 491777, 469389, 491775, 362773, 492197, 230981, 491773, 492195, 492193, 485215, 485213, 411802, 411800, 242782, 411798, 199273, 242774, 491346, 491211, 491208, 323528, 199270, 492096, 492070, 492093, 492067, 491771, 491770, 230975, 491768, 491765, 491762, 491759, 491758, 129067, 491756, 242764, 491754, 491751, 491748, 491746, 491744, 491742, 491740, 491738, 491736, 491734, 468926, 217836, 491733, 491417, 491729, 491727, 199264, 491724, 491716, 491714, 491712, 230961, 491709, 491708, 491705, 491703, 491701, 491699, 376189, 491696, 199263, 376184, 624611, 491689, 230959, 491693, 230957, 230955, 230953, 425610, 230939, 425604, 491206, 353095, 199261, 491202, 491199, 491196, 491194, 491192, 491190, 491188, 324969, 491185, 376160, 199259, 491489, 491487, 376157, 199258, 478273, 478270, 478268, 230902, 230899, 230897, 425575, 486960, 476784, 476782, 425573, 230888, 368169, 199252, 353094, 490927, 230876, 230874, 425547, 325831, 199248, 491268, 425535, 425532, 425525, 199245, 349119, 489012, 199237, 489820, 452725, 489011, 467104, 467102, 490781, 230861, 476775, 490393, 476773, 490388, 476771, 476768, 476766, 476764, 476762, 476760, 476758, 476756, 476755, 476753, 476752, 349118, 349117, 58660, 230849, 242711, 472611, 199232, 472609, 472606, 472603, 230834, 230832, 490123, 490121, 490118, 489684, 374332, 217788, 349116, 336272, 472595, 472593, 425493, 425491, 466817, 425488, 425486, 489745, 217761, 485179, 230814, 230812, 349115, 489597, 199223, 322628, 230803, 199222, 324308, 199218, 489357, 489478, 349114, 242662, 242660, 489347, 487127, 230794, 489226, 489293, 425475, 489224, 489291, 489222, 206432, 489286, 206430, 206428, 489283, 206425, 425443, 476257, 489005, 206409, 206407, 199215, 488908, 206406, 206403, 320937, 322917, 349112, 425424, 324306, 108066, 488341, 624585, 488497, 488495, 308895, 108047, 58653, 217730, 217724, 217721, 217719, 217717, 217715, 425401, 217710, 478377, 425393, 205794, 199195, 425382, 425365, 205788, 205787, 425362, 425360, 425358, 425356, 425353, 425352, 199192, 108041, 199189, 199187, 217651, 486688, 486632, 486630, 242610, 242606, 486624, 487122, 420661, 486642, 487614, 217637, 485154, 485152, 485149, 217634, 485142, 199175, 468917, 230772, 230762, 230760, 230758, 230753, 487116, 320934, 487113, 199156, 230748, 230746, 487108, 487107, 330210, 349106, 242558, 230709, 230707, 230705, 486949, 330208, 486939, 58643, 349105, 425222, 58638, 58636, 58634, 58632, 58630, 205778, 359989, 58627, 199145, 58625, 217601, 217597, 217595, 217593, 205769, 205767, 320922, 320918, 320915, 425171, 107997, 242528, 369062, 485070, 320914, 320909, 485015, 230663, 354446, 349103, 483332, 483330, 483323, 483319, 483316, 482480, 483311, 483309, 483307, 483304, 483300, 425140, 483296, 483293, 483290, 483289, 199121, 483282, 483278, 624568, 483276, 483274, 217569, 483271, 230624, 199114, 242512, 199110, 199106, 483265, 483263, 483261, 483259, 483255, 483251, 478375, 484067, 483874, 483249, 483245, 483241, 454091, 387070, 387068, 387061, 387059, 387057, 387052, 217550, 483013, 349102, 217547, 217545, 217543, 217540))
Run Time: 0.058096
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1640 | |
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 | | | | | 1640 | |
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 (24833))
Run Time: 0.001512
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_post_FirstPost_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | 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/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 (551034, 430157, 430128, 539453, 539451, 244091, 485711, 528868, 108687, 528826, 429468, 200046, 429395, 108640, 367477, 243990, 369124, 174298, 485640, 174285, 384233, 429173, 429170, 539424, 539403, 539400, 539399, 429113, 243950, 453551, 453548, 353139, 528692, 538910, 528685, 232514, 429045, 429043, 199975, 429005, 429002, 243892, 243890, 243887, 243886, 232441, 232427, 471031, 471026, 535779, 535777, 535264, 535252, 232412, 232410, 232406, 232402, 232397, 369108, 232363, 232361, 428773, 199934, 369105, 199923, 428756, 428747, 428722, 321155, 321152, 428706, 428691, 199918, 232310, 232308, 199911, 485536, 485534, 428545, 428543, 523227, 199898, 384227, 384225, 428477, 428466, 522258, 384223, 428454, 384221, 384219, 384216, 243704, 384215, 384213, 384211, 384210, 384208, 428379, 243670, 243667, 243665, 428316, 428307, 428297, 199871, 521336, 428268, 428266, 428264, 303325, 428260, 428257, 428249, 520985, 428232, 428228, 428226, 381608, 243645, 428207, 353136, 232265, 354471, 199864, 469019, 428155, 501640, 108555, 108553, 199857, 349155, 519894, 519891, 199855, 519855, 519842, 519627, 219045, 519625, 519623, 199852, 519617, 428060, 199850, 428041, 428039, 428037, 428033, 232250, 199846, 344562, 504388, 428004, 428002, 504384, 386882, 504382, 232240, 427980, 427977, 427958, 469016, 419775, 108532, 518804, 232232, 232230, 232228, 514500, 199824, 199822, 469853, 199820, 199814, 427878, 515713, 199808, 232197, 517237, 427855, 199805, 108524, 108521, 511792, 232190, 108509, 108481, 232168, 427810, 427807, 427802, 199796, 427800, 427798, 427796, 427793, 199795, 485444, 427785, 108440, 205877, 322940, 205869, 243585, 243583, 232144, 232142, 232140, 243576, 243574, 232136, 381606, 232124, 515708, 232122, 243570, 453499, 218849, 243554, 485429, 514459, 514454, 243547, 199782, 514443, 514414, 514412, 354468, 218830, 218817, 218814, 330301, 427707, 330300, 427705, 427702, 511790, 199775, 513086, 349143, 330298, 427689, 469012, 232072, 495085, 495083, 453497, 232056, 243529, 512080, 309305, 199766, 129090, 427642, 199763, 511785, 511783, 427614, 369092, 469007, 427589, 511755, 511726, 199751, 427558, 427554, 427550, 427546, 427530, 427525, 369088, 427506, 243486, 199740, 427499, 469003, 199736, 427486, 353129, 427483, 199732, 427480, 427478, 427476, 232033, 199724, 427469, 427466, 427463, 427461, 485386, 485384, 199719, 232009, 453490, 243460, 199713, 243458, 362379, 362377, 427420, 243453, 427418, 199712, 463548, 504808, 323572, 485375, 427410, 199711, 504806, 504797, 199708, 469001, 427394, 427391, 427388, 199703, 199701, 485374, 329354, 427344, 427341, 427334, 243437, 353127, 325846, 353126, 353124, 614584, 231988, 199690, 231986, 243429, 199686, 199677, 510091, 199672, 453484, 504380, 510071, 323561, 427273, 510061, 427267, 510059, 485360, 199671, 510057, 427253, 427221, 427209, 323558, 108377, 485358, 381602, 344549, 199654, 427188, 344547, 427174, 427171, 427168, 199646, 416072, 243389, 353120, 243388, 493478, 493476, 231930, 108350, 199632, 108341, 108336, 108333, 199631, 199624, 508857, 243384, 427110, 427108, 199620, 427093, 427089, 199616, 360814, 411920, 463524, 463522, 231893, 463520, 309267, 504379, 309258, 309256, 427065, 508269, 309246, 427057, 199605, 353117, 427049, 427047, 427044, 427042, 427040, 427038, 427036, 485344, 427023, 108311, 108309, 338970, 338965, 376225, 199600, 376222, 376220, 376218, 507950, 205841, 218507, 199595, 330273, 309229, 309226, 309224, 218503, 309197, 243352, 376214, 376212, 376210, 309192, 309189, 243328, 386879, 426943, 199591, 199589, 507190, 507188, 507184, 231877, 243320, 243315, 506785, 330271, 506780, 218490, 299344, 218487, 231871, 504374, 231868, 506892, 506860, 506650, 504794, 199569, 504792, 199567, 504789, 504373, 108289, 218473, 309188, 309186, 309184, 329349, 309178, 309175, 309172, 309169, 309167, 506290, 506282, 506277, 506274, 309162, 309160, 231843, 309146, 199559, 243291, 309059, 309056, 309054, 309051, 309048, 309045, 309043, 199555, 243279, 402721, 505616, 199551, 199541, 218446, 421870, 231830, 231828, 231826, 243271, 243256, 243253, 243241, 243233, 453477, 243225, 243219, 243217, 243214, 243211, 243209, 243207, 505398, 354457, 199535, 317154, 243201, 199533, 504370, 504368, 504366, 485319, 485317, 325843, 504363, 485314, 199528, 504918, 199527, 504770, 426763, 401021, 401019, 468987, 426747, 231774, 401006, 426740, 354455, 401002, 231747, 199523, 231739, 231736, 368229, 199520, 231728, 485301, 199519, 199516, 426667, 231705, 504126, 199510, 426663, 504115, 504111, 504108, 400109, 243160, 243158, 455412, 231681, 199501, 243135, 231637, 205825, 426646, 231630, 231628, 231625, 231623, 199496, 243127, 504057, 426634, 243114, 218340, 353114, 324326, 426615, 426595, 199494, 367305, 503666, 503659, 243052, 243049, 205824, 218309, 426576, 468984, 349133, 199481, 231550, 503478, 503437, 503431, 329345, 421202, 199479, 502160, 231532, 218288, 108256, 325841, 468979, 468977, 325840, 199476, 426545, 108253, 322928, 108251, 502900, 502896, 502893, 502889, 502887, 353113, 426524, 426522, 426518, 426516, 502769, 502767, 502765, 426513, 502760, 502758, 624739, 321058, 205822, 321055, 218280, 199473, 463478, 463475, 453472, 463472, 453470, 499568, 325839, 268991, 268989, 268987, 268984, 268981, 268977, 268975, 453466, 463470, 199470, 463467, 426445, 426443, 199465, 426441, 231485, 231482, 231480, 325838, 231477, 231474, 353111, 353110, 426438, 389160, 243017, 231458, 231456, 453463, 333661, 426414, 426403, 426401, 463464, 426395, 426393, 426391, 426389, 426386, 426384, 323545, 243005, 417792, 426365, 426349, 108240, 426323, 624719, 199456, 426289, 426287, 199454, 493434, 207541, 426278, 426253, 207533, 501280, 386875, 199452, 218209, 218202, 199450, 199449, 308994, 308992, 308989, 308987, 199446, 499320, 500870, 274648, 500859, 500857, 199439, 500490, 499318, 349130, 349129, 498940, 231399, 231396, 231394, 231389, 199435, 199433, 218173, 500447, 500445, 199432, 349128, 231385, 231383, 453460, 349127, 199428, 624712, 624709, 463458, 463455, 231367, 231365, 426206, 323537, 426204, 426202, 231358, 199424, 426199, 426197, 108219, 108216, 108215, 108209, 369077, 231342, 231339, 231336, 231334, 231331, 368944, 231328, 199420, 108204, 108202, 108200, 108198, 108196, 108194, 108192, 199418, 322923, 242956, 108190, 108186, 499537, 108184, 199417, 499534, 108182, 499051, 108172, 218133, 499049, 499047, 426176, 199416, 497714, 324324, 426174, 426172, 426170, 426168, 426166, 426164, 426162, 426160, 330245, 218131, 231311, 231309, 231305, 218127, 624697, 498933, 426153, 624694, 426148, 349126, 199413, 499072, 386873, 199411, 498924, 426130, 426120, 624689, 199409, 242944, 490108, 499045, 322922, 453458, 231298, 231296, 468972, 468970, 468967, 468965, 468963, 468960, 468957, 426071, 624686, 199405, 426059, 468951, 231287, 468949, 468947, 468944, 231283, 231281, 231278, 231276, 231274, 388155, 373913, 498918, 497950, 199403, 624684, 426056, 468942, 468940, 468937, 468932, 426040, 426034, 426022, 330237, 199401, 498725, 495531, 426019, 426017, 218076, 498460, 498450, 498448, 199396, 325836, 205808, 205805, 199395, 624680, 490323, 242932, 242928, 231259, 231248, 231246, 242926, 231243, 231241, 231236, 231225, 231221, 231218, 231216, 497404, 324323, 426006, 218058, 426002, 425998, 425991, 624676, 425988, 425986, 199392, 425980, 425976, 425971, 425964, 425962, 425958, 425955, 425953, 497897, 497401, 497893, 425951, 324321, 218053, 349124, 231178, 231176, 485254, 497398, 497396, 497394, 199389, 242915, 242909, 624665, 497483, 242904, 199386, 218043, 108124, 367274, 386870, 497382, 425934, 624663, 108116, 199384, 108110, 108107, 108098, 108090, 199383, 108086, 624661, 321018, 624657, 368185, 368182, 455396, 485246, 496437, 496435, 386868, 495423, 496433, 496431, 242885, 199378, 218020, 425925, 468930, 353109, 624647, 108079, 624644, 624642, 624640, 624638, 496101, 496095, 496093, 624636, 199376, 425899, 425895, 322921, 425874, 495612, 218003, 425869, 493919, 493917, 493913, 493908, 493906, 492344, 199374, 455352, 455350, 231168, 455346, 455337, 425860, 455334, 495603, 231164, 217991, 493424, 376205, 199373, 199372, 495417, 231159, 495415, 495413, 495507, 495411, 495409, 322920, 495407, 495405, 495403, 495401, 199369, 231153, 231150, 231148, 231146, 231144, 231142, 495441, 624632, 495384, 495378, 495361, 495076, 495074, 199364, 411837, 376204, 386866, 495340, 479212, 455324, 217983, 242879, 199361, 494873, 624628, 495097, 321011, 321009, 416064, 217966, 199359, 425832, 494840, 493411, 494832, 231129, 199355, 417776, 417774, 199353, 425823, 417771, 425819, 425816, 231122, 494781, 425812, 494609, 494607, 324989, 494605, 265532, 417760, 199347, 367266, 483498, 494494, 425803, 425801, 353108, 493405, 493403, 493401, 493399, 493397, 217951, 493395, 493393, 493391, 425795, 322919, 425789, 217947, 425787, 425785, 493387, 493381, 425777, 425775, 199336, 353107, 494351, 493372, 231108, 199335, 353105, 493361, 493357, 322918, 425746, 199334, 414811, 425742, 425737, 494286, 494284, 324315, 485235, 614565, 199332, 421753, 485232, 199330, 411833, 399714, 199328, 425721, 493894, 199326, 425717, 493984, 231089, 489016, 399271, 324314, 493876, 231086, 217922, 242848, 242846, 231075, 199321, 217916, 425710, 483486, 199312, 349122, 493762, 217912, 303304, 303296, 199307, 425702, 492999, 624618, 425697, 323531, 493289, 242818, 492959, 231061, 231059, 231057, 328402, 231053, 199305, 199303, 231051, 318342, 231048, 493272, 231046, 231044, 242814, 231042, 318340, 318337, 231038, 231036, 231034, 231032, 231030, 231028, 493161, 493159, 425689, 199300, 217903, 217896, 231020, 231018, 231016, 231014, 231012, 231009, 242808, 231006, 231004, 231002, 492992, 199297, 199295, 242805, 492946, 492939, 492669, 425675, 330218, 492989, 242800, 376198, 492775, 230991, 242794, 386865, 322460, 492606, 492604, 488612, 199294, 386863, 425659, 425657, 393809, 453450, 492463, 254141, 254120, 254118, 199289, 398830, 199288, 217867, 404667, 199282, 492449, 404664, 199280, 425647, 491778, 353104, 425636, 325833, 199277, 230985, 199274, 242787, 425634, 425632, 425629, 469391, 491777, 469389, 491775, 362773, 492197, 230981, 491773, 492195, 492193, 485215, 485213, 411802, 411800, 242782, 411798, 199273, 242774, 491346, 491211, 491208, 323528, 199270, 492096, 492070, 492093, 492067, 491771, 491770, 230975, 491768, 491765, 491762, 491759, 491758, 129067, 491756, 242764, 491754, 491751, 491748, 491746, 491744, 491742, 491740, 491738, 491736, 491734, 468926, 217836, 491733, 491417, 491729, 491727, 199264, 491724, 491716, 491714, 491712, 230961, 491709, 491708, 491705, 491703, 491701, 491699, 376189, 491696, 199263, 376184, 624611, 491689, 230959, 491693, 230957, 230955, 230953, 425610, 230939, 425604, 491206, 353095, 199261, 491202, 491199, 491196, 491194, 491192, 491190, 491188, 324969, 491185, 376160, 199259, 491489, 491487, 376157, 199258, 478273, 478270, 478268, 230902, 230899, 230897, 425575, 486960, 476784, 476782, 425573, 230888, 368169, 199252, 353094, 490927, 230876, 230874, 425547, 325831, 199248, 491268, 425535, 425532, 425525, 199245, 349119, 489012, 199237, 489820, 452725, 489011, 467104, 467102, 490781, 230861, 476775, 490393, 476773, 490388, 476771, 476768, 476766, 476764, 476762, 476760, 476758, 476756, 476755, 476753, 476752, 349118, 349117, 58660, 230849, 242711, 472611, 199232, 472609, 472606, 472603, 230834, 230832, 490123, 490121, 490118, 489684, 374332, 217788, 349116, 336272, 472595, 472593, 425493, 425491, 466817, 425488, 425486, 489745, 217761, 485179, 230814, 230812, 349115, 489597, 199223, 322628, 230803, 199222, 324308, 199218, 489357, 489478, 349114, 242662, 242660, 489347, 487127, 230794, 489226, 489293, 425475, 489224, 489291, 489222, 206432, 489286, 206430, 206428, 489283, 206425, 425443, 476257, 489005, 206409, 206407, 199215, 488908, 206406, 206403, 320937, 322917, 349112, 425424, 324306, 108066, 488341, 624585, 488497, 488495, 308895, 108047, 58653, 217730, 217724, 217721, 217719, 217717, 217715, 425401, 217710, 478377, 425393, 205794, 199195, 425382, 425365, 205788, 205787, 425362, 425360, 425358, 425356, 425353, 425352, 199192, 108041, 199189, 199187, 217651, 486688, 486632, 486630, 242610, 242606, 486624, 487122, 420661, 486642, 487614, 217637, 485154, 485152, 485149, 217634, 485142, 199175, 468917, 230772, 230762, 230760, 230758, 230753, 487116, 320934, 487113, 199156, 230748, 230746, 487108, 487107, 330210, 349106, 242558, 230709, 230707, 230705, 486949, 330208, 486939, 58643, 349105, 425222, 58638, 58636, 58634, 58632, 58630, 205778, 359989, 58627, 199145, 58625, 217601, 217597, 217595, 217593, 205769, 205767, 320922, 320918, 320915, 425171, 107997, 242528, 369062, 485070, 320914, 320909, 485015, 230663, 354446, 349103, 483332, 483330, 483323, 483319, 483316, 482480, 483311, 483309, 483307, 483304, 483300, 425140, 483296, 483293, 483290, 483289, 199121, 483282, 483278, 624568, 483276, 483274, 217569, 483271, 230624, 199114, 242512, 199110, 199106, 483265, 483263, 483261, 483259, 483255, 483251, 478375, 484067, 483874, 483249, 483245, 483241, 454091, 387070, 387068, 387061, 387059, 387057, 387052, 217550, 483013, 349102, 217547, 217545, 217543, 217540))
Run Time: 0.041643
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1640 | |
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 | | | | | 1640 | |
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 (24833))
Run Time: 0.000841
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_post_FirstPost_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | 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/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.000194
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.000425
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.000617
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1716173912
Run Time: 0.000299
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 15 | 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` >= 1716173912)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000504
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 15 | 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