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.000736
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.000216
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` = '1103')
LIMIT 1
Run Time: 0.000511
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.002150
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_1103' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.073864
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 (455775, 502837, 503367, 502832, 497916, 492790, 462499, 386655, 386650, 466463, 470570, 466461, 466455, 174747, 462493, 459007, 458941, 307822, 307820, 452421, 117678, 449292, 382427, 382425, 260600, 422595, 407473, 415292, 412992, 415288, 412989, 412987, 370567, 412985, 361602, 407468, 407466, 413580, 407461, 386647, 413336, 409956, 409953, 407452, 407450, 409238, 260578, 407562, 407446, 407443, 406611, 402114, 402112, 381949, 400356, 273358, 402510, 402250, 402099, 372827, 397789, 394017, 394013, 390306, 391417, 391416, 390301, 389494, 389490, 389487, 389485, 389482, 388385, 387190, 387083, 386640, 370787, 384948, 370703, 382386, 384419, 384082, 382380, 383873, 382377, 382920, 382779, 302342, 382246, 381944, 143253, 381842, 381624, 379602, 381422, 381226, 359601, 377804, 370550, 378567, 378560, 377653, 96849, 377829, 377647, 377224, 370768, 370545, 377281, 377279, 377264, 297016, 374740, 96848, 117666, 377076, 365870, 375484, 332087, 376621, 374711, 375482, 375472, 371389, 375393, 374709, 375390, 373978, 371385, 374731, 96847, 117661, 374294, 369996, 297013, 373939, 361587, 337240, 370763, 368852, 372999, 372896, 372424, 96846, 117657, 370915, 371235, 370864, 370862, 370746, 370860, 370744, 370855, 370854, 370185, 370183, 369985, 370180, 370175, 369979, 369976, 369430, 369429, 368848, 279680, 365918, 365910, 364602, 364588, 364565, 364597, 117652, 117650, 355346, 355344, 355338, 355332, 96844, 362945, 357599, 361582, 203057, 249967, 143252, 296404, 117644, 360902, 360892, 361121, 96842, 361115, 359596, 203050, 359592, 359651, 349254, 359407, 96840, 359243, 339832, 358497, 334040, 339825, 260557, 205285, 357113, 340429, 356167, 356165, 356163, 356160, 357725, 357547, 117642, 357544, 357475, 96838, 357110, 357107, 357195, 356150, 357100, 297006, 357094, 356147, 96836, 96835, 356541, 356540, 96834, 353968, 353965, 117635, 297001, 354272, 352542, 354270, 203044, 352729, 352727, 203042, 354128, 353483, 354122, 302319, 339169, 288511, 353480, 353477, 353183, 352724, 96833, 253681, 352060, 353168, 352059, 117633, 299082, 351139, 351538, 351137, 351135, 351674, 351651, 351535, 350977, 350975, 350688, 346953, 335054, 348632, 348445, 312886, 347522, 344942, 344940, 347120, 347529, 345918, 346487, 346498, 345906, 314924, 345905, 203037, 345904, 345900, 345899, 345176, 345174, 345168, 345165, 344938, 345158, 344935, 345155, 342359, 342351, 342347, 344327, 342343, 344295, 343893, 302941, 340314, 343890, 302938, 302936, 343575, 343201, 117629, 96831, 338458, 337271, 302934, 117625, 342077, 342063, 339887, 341809, 341347, 304031, 340699, 340697, 339349, 339339, 339883, 339881, 339818, 342229, 339817, 342228, 339331, 339368, 339156, 339315, 339310, 339402, 339304, 329090, 334352, 334349, 337710, 117623, 96822, 335044, 335040, 334940, 96814, 96812, 96811, 334736, 334031, 117619, 117617, 334117, 306341, 334020, 333094, 269873, 330594, 117614, 332634, 253625, 330893, 331083, 328685, 328948, 327812, 328032, 307804, 327370, 296392, 327291, 320207, 318701, 318699, 203028, 326955, 307790, 307788, 326596, 326381, 326043, 96806, 325627, 321972, 325471, 325243, 311103, 318590, 296385, 321380, 264928, 321315, 208065, 287549, 320129, 319971, 304020, 301424, 310855, 319642, 318561, 96802, 96800, 319157, 318558, 301422, 318557, 318950, 183957, 96799, 296383, 318672, 312134, 317532, 316870, 302312, 316868, 296380, 35369, 296378, 316788, 299012, 270574, 270570, 302310, 117613, 314206, 302307, 300569, 315167, 270557, 314202, 314200, 314440, 264926, 302306, 313889, 313705, 313901, 302299, 302297, 313699, 313726, 183951, 310826, 167, 313540, 313467, 310780, 310771, 290712, 310750, 302279, 311098, 310722, 302275, 310714, 310711, 310707, 306876, 310690, 296377, 311134, 311128, 299500, 297346, 306872, 307784, 306862, 306860, 306858, 301405, 310404, 267374, 267370, 267367, 306843, 302268, 307768, 305010, 183943, 267344, 307303, 307301, 267330, 267324, 304854, 306714, 305430, 303837, 306691, 303835, 305111, 306307, 302459, 270513, 305491, 305343, 305096, 304830, 305089, 305043, 169864, 202311, 301388, 301384, 300584, 303750, 287448, 117599, 303521, 203026, 302444, 296997, 302400, 302435, 302398, 302395, 264650, 302264, 301557, 264648, 302083, 299158, 301651, 287442, 301003, 299580, 300579, 299027, 300490, 297330, 282995, 299697, 299554, 117596, 296989, 298897, 299017, 117593, 298988, 298888, 298202, 297783, 297699, 291648, 287410, 203023, 296298, 296296, 296135, 284983, 160179, 295104, 294541, 264991, 294394, 291540, 293826, 291638, 288728, 288498, 288496, 288494, 117581, 290197, 290071, 183933, 287471, 287947, 287469, 288095, 284159, 287351, 277777, 279978, 282813, 271661, 279602, 183914, 250612, 277735, 278336, 277694, 117575, 273078, 273071, 271542, 96792, 96790, 270724, 269724, 269718, 269705, 269714, 117570, 183858, 183856, 96789, 268378, 268376, 267936, 267932, 268368, 268394, 267442, 267994, 267991, 267728, 143249, 259948, 266476, 266408, 266406, 254672, 142967, 266419, 266412, 194429, 194425, 117569, 142960, 265257, 265255, 264922, 222256, 183849, 264428, 264423, 203014, 264820, 264802, 117567, 183838, 262236, 264228, 183832, 143245, 263796, 253581, 253577, 96785, 117564, 263247, 117562, 262167, 250597, 261643, 96783, 117559, 260947, 171426, 259881, 142947, 257211, 183818, 258743, 258323, 258318, 257924, 257604, 165411, 143235, 256812, 165408, 142943, 142939, 250351, 142935, 165405, 96781, 254745, 254315, 253551, 254504, 253542, 253538, 253535, 254333, 253513, 96775, 250210, 250187, 250159, 250545, 249238, 248985, 117500, 248523, 117497, 194412, 247888, 192801, 247635, 192799, 208029, 192797, 142912, 143221, 143218, 201490, 247324, 222633, 208492, 194398, 222517, 222511, 221962, 208449, 208136, 142859, 204818, 207093, 206576, 117471, 165400, 171322, 201512, 202947, 201920, 120772, 165392, 173395, 173393, 201776, 173391, 201742, 120741, 195376, 117468, 117464, 195371, 195056, 194025, 120632, 194816, 142840, 194964, 142837, 194805, 194355, 194803, 193863, 120598, 120593, 120589, 193848, 117450, 193266, 187122, 175397, 143173, 143171, 192714, 142810, 192568, 191995, 165378, 191985, 191983, 191981, 190730, 190724, 190080, 117441, 96752, 174670, 185952, 187231, 186894, 183736, 185519, 185513, 185393, 183515, 165365, 96749, 182066, 182559, 182807, 165362, 175605, 165360, 172875, 174797, 172873, 96746, 165349, 173546, 173389, 141529, 142796, 142792, 142789, 172867, 172673, 172662, 165762, 172281, 172088, 172193, 169005, 169001, 170536, 168995, 170068, 169924, 142787, 169060, 142785, 164414, 162997, 161587, 148675, 159582, 141652, 156786, 156707, 154062, 153901, 152788, 151411, 151171, 135082, 135079, 135074, 145624, 143120, 143119, 96729, 143105, 143104, 117316, 143094, 142629, 129855, 141316, 141314, 142623, 142621, 141809, 141611, 138009, 138353, 138351, 137464, 137462, 135273, 137459, 136431, 136429, 138462, 115735, 138347, 138125, 127404, 137525, 129841, 136245, 135072, 135064, 126107, 135047, 134833, 117276, 96727, 96725, 117268, 130297, 130265, 129427, 130164, 130162, 129834, 129812, 128065, 127401, 127399, 129359, 127589, 128417, 127584, 127583, 127581, 127578, 127576, 127574, 127572, 127569, 127568, 127564, 127907, 127547, 127541, 128057, 128051, 127537, 128117, 128027, 127377, 127789, 117260, 117258, 127519, 127251, 127249, 123384, 59163, 117247, 126076, 126064, 117244, 124538, 117238, 119354, 124983, 124980, 59160, 59156, 124708, 123335, 59154, 124184, 117230, 85271, 120379, 85269, 96724, 124453, 85267, 96722, 117225, 117221, 123914, 123892, 123330, 123327, 119219, 59149, 122763, 117212, 122792, 85696, 119180, 122210, 102824, 122204, 121362, 121202, 92396, 119126, 92394, 96063, 120353, 120964, 120962, 116945, 116943, 118123, 117945, 96710, 113749, 113013, 115690, 115688, 116484, 91537, 116282, 115896, 92318, 115853, 115839, 115832, 115829, 115655, 113900, 24220, 114767, 114448, 114445, 113492, 72112, 24216, 24213, 113893, 111995, 112675, 112303, 102267, 80424, 80422, 111455, 102061, 80420, 91320, 24157, 99492, 99336, 99224, 99218, 24151, 96694, 97949, 24146, 24144, 24139, 98926, 96687, 80414, 98506, 96684, 95953, 97769, 95933, 97320, 93205, 91280, 95228, 96986, 96676, 96668, 96664, 24128, 96631, 24124, 24122, 96260, 95929, 90531, 90528, 95716, 95562, 95534, 95046, 94578, 91157, 91155, 94300, 93028, 91027, 93013, 76511, 91018, 91016, 90052, 90029, 90902, 90899, 91783, 89991, 89957, 90874, 89747, 90870, 90860, 89740, 89917, 88659, 89731, 89391, 89644, 88988, 89273, 24104, 89187, 89168, 89191, 88787, 88711, 88817, 88582, 88374, 86355, 88249, 87742, 88366, 88364, 88361, 82499, 88163, 88060, 87081, 87696, 87794, 87792, 78486, 87268, 85199, 86798, 86182, 86352, 86326, 85175, 85168, 73864, 85795, 73861, 82726, 85413, 85152, 84336, 84249, 83948, 84105, 83945, 83646, 80412, 82692, 83553, 83404, 83004, 82677, 82674, 82663, 82657, 82468, 82910, 82465, 82803, 82457, 24072, 24061, 81781, 82409, 81883, 81878, 81874, 81869, 81957, 82112, 81948, 82119, 81861, 82110, 81942, 81935, 81617, 81610, 80612, 80290, 80875, 81058, 80872, 80870, 80409, 80589, 59129, 80405, 78160, 78158, 80309, 79595, 79914, 79588, 79586, 78992, 78472, 58781, 78469, 78137, 78464, 78462, 78128, 78459, 78456, 78452, 78449, 78447, 78444, 78441, 78439, 78427, 78383, 24053, 78330, 78378, 24051, 24048, 77973, 77865, 76409, 76407, 24044, 77659, 77504, 77399, 77173, 68861, 76690, 76805, 76803, 76504, 76737, 76682, 76679, 76551, 76586, 76600, 75758, 76499, 76292, 76245, 75823, 76172, 76127, 75849, 75756, 75777, 75741, 75717, 58773, 75621, 75619, 75480, 75478, 24030, 75474, 74563, 75064, 74927, 24026, 24024, 74546, 74341, 74145, 74136, 72347, 74124, 73906, 73844, 73849, 73522, 73324, 72968, 71949, 73103, 73099, 73069, 66141, 72600, 72954, 70560, 70555, 70552, 72861, 72816, 72640, 60822, 24010, 72073, 66211, 72169, 72202, 24007, 24005, 71678, 71509, 71211, 71294, 71290, 71338, 71209, 71097, 70948, 67576, 70791, 70442, 70689, 61635, 70424, 70367, 70280, 70295, 70079, 70074, 64300, 70046, 23994, 69755, 69571, 68889, 23986, 69414, 69465, 68886, 69391, 67671, 69195, 23973, 69068, 69055, 69051, 59105, 59100, 68200, 58769, 64969, 68872, 68814, 68879, 68806, 68194, 68107, 68192, 65306, 67865, 68471, 68461, 66437, 68176, 68100, 23954, 64089, 23952, 68022, 61633, 68016, 67827, 67703, 67831, 67297, 23938, 67422, 67197, 67237, 67193, 66397, 23936, 59097, 64223, 67104, 66384, 66192, 66457, 61802, 63274, 63272, 63270, 62737, 58761, 66327, 35355, 66189, 66185, 66181, 66199, 66113, 66083, 66066, 64564, 60805, 60803, 23925, 65362, 60800, 60798, 65727, 65693, 64424, 23922, 65351, 60796, 65073, 64423, 65346, 65271, 65062, 65329, 65326, 65269, 63824, 65266, 65035, 65032, 23919, 65053, 64975, 23916, 23914, 23912, 60791, 60787, 60784, 64760, 64283, 64638, 64550, 64537, 64489, 64471, 64190, 64254, 64375, 64186, 64249, 45838, 64247, 64179, 23895, 63842, 45831, 63840, 63662, 63656, 63652, 63308, 18041, 63612, 63593, 63609, 63295, 62807, 63288, 63284, 63280, 59736, 60776, 62279, 23882, 63066, 62708, 61800, 60774, 62205, 60770, 60768, 60766, 23878, 62227, 60745, 62146, 60739, 60736, 61791, 61787, 61782, 61747, 61624, 61572, 23866, 23865, 58901, 60611, 60416, 60412, 60409, 58893, 60325, 58750, 60164, 60049, 60007, 58739, 23855, 59420, 59418, 59416, 59528, 59405, 59403, 59204, 59395, 59323, 59383, 58234, 57154, 50938, 59071, 23845, 59027, 59016, 51426, 58999, 51424, 51423, 58880, 58734, 58816, 58856, 58859, 46782, 58531, 58733, 58731, 58729, 58793, 57299, 51418, 58480, 54506, 58519, 58478, 58505, 58475, 58473, 58454, 8708, 23832, 23830, 50623, 51416, 52923, 52921, 51413, 51411, 52920, 51409, 54757, 51465, 57297, 57295, 58022, 58020, 58018, 57980, 57948, 57933, 57931, 57929, 56723, 23825, 57810, 23823, 57808, 25744, 57806, 57785, 57769, 57291, 57764, 23820, 23818, 57286, 56937, 23813, 49968, 53084, 56934, 17328, 23809, 8702, 56958, 8698, 23807, 49961, 8695, 23805, 44427, 23803, 57280, 55558, 56955, 23801, 56867, 55972, 53213, 56064, 43860, 43602, 43882, 38200, 23774, 43542, 41144, 42948, 43027, 42764, 42761, 38992, 38991, 41627, 35324, 41661, 41600, 38978, 41139, 41310, 41300, 8661, 41085, 41121, 28500, 8659, 40937, 40846, 40841, 35600, 23727, 38251, 37743, 37741, 37791, 37739, 37559, 37488, 33850, 33847, 17280, 36254, 36210, 35841, 35838, 33346, 33344, 35719, 35715, 23719, 23709, 34714, 23698, 23644, 34541, 33834, 34394, 34392, 34470, 25115, 33516, 33513, 33991, 33699, 33686, 31710))
Run Time: 0.082774
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1626 | |
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 | | | | | 1626 | |
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 (21189, 20409, 20248, 19919, 19695, 19683, 19299, 19110, 18860, 18804, 18517, 18424, 18303, 17671, 17539, 16978, 16808, 16445, 15556, 15423, 15360, 15316, 15199, 15180, 14764, 14512, 14406, 14148, 13660, 13021, 12548, 12292, 11494, 9532, 9199, 9007, 8763, 8637, 8034, 8004, 7062, 6727, 6549, 6246, 5446, 5306, 5278, 3953, 3349))
Run Time: 0.004576
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 49 | 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 (455775, 502837, 503367, 502832, 497916, 492790, 462499, 386655, 386650, 466463, 470570, 466461, 466455, 174747, 462493, 459007, 458941, 307822, 307820, 452421, 117678, 449292, 382427, 382425, 260600, 422595, 407473, 415292, 412992, 415288, 412989, 412987, 370567, 412985, 361602, 407468, 407466, 413580, 407461, 386647, 413336, 409956, 409953, 407452, 407450, 409238, 260578, 407562, 407446, 407443, 406611, 402114, 402112, 381949, 400356, 273358, 402510, 402250, 402099, 372827, 397789, 394017, 394013, 390306, 391417, 391416, 390301, 389494, 389490, 389487, 389485, 389482, 388385, 387190, 387083, 386640, 370787, 384948, 370703, 382386, 384419, 384082, 382380, 383873, 382377, 382920, 382779, 302342, 382246, 381944, 143253, 381842, 381624, 379602, 381422, 381226, 359601, 377804, 370550, 378567, 378560, 377653, 96849, 377829, 377647, 377224, 370768, 370545, 377281, 377279, 377264, 297016, 374740, 96848, 117666, 377076, 365870, 375484, 332087, 376621, 374711, 375482, 375472, 371389, 375393, 374709, 375390, 373978, 371385, 374731, 96847, 117661, 374294, 369996, 297013, 373939, 361587, 337240, 370763, 368852, 372999, 372896, 372424, 96846, 117657, 370915, 371235, 370864, 370862, 370746, 370860, 370744, 370855, 370854, 370185, 370183, 369985, 370180, 370175, 369979, 369976, 369430, 369429, 368848, 279680, 365918, 365910, 364602, 364588, 364565, 364597, 117652, 117650, 355346, 355344, 355338, 355332, 96844, 362945, 357599, 361582, 203057, 249967, 143252, 296404, 117644, 360902, 360892, 361121, 96842, 361115, 359596, 203050, 359592, 359651, 349254, 359407, 96840, 359243, 339832, 358497, 334040, 339825, 260557, 205285, 357113, 340429, 356167, 356165, 356163, 356160, 357725, 357547, 117642, 357544, 357475, 96838, 357110, 357107, 357195, 356150, 357100, 297006, 357094, 356147, 96836, 96835, 356541, 356540, 96834, 353968, 353965, 117635, 297001, 354272, 352542, 354270, 203044, 352729, 352727, 203042, 354128, 353483, 354122, 302319, 339169, 288511, 353480, 353477, 353183, 352724, 96833, 253681, 352060, 353168, 352059, 117633, 299082, 351139, 351538, 351137, 351135, 351674, 351651, 351535, 350977, 350975, 350688, 346953, 335054, 348632, 348445, 312886, 347522, 344942, 344940, 347120, 347529, 345918, 346487, 346498, 345906, 314924, 345905, 203037, 345904, 345900, 345899, 345176, 345174, 345168, 345165, 344938, 345158, 344935, 345155, 342359, 342351, 342347, 344327, 342343, 344295, 343893, 302941, 340314, 343890, 302938, 302936, 343575, 343201, 117629, 96831, 338458, 337271, 302934, 117625, 342077, 342063, 339887, 341809, 341347, 304031, 340699, 340697, 339349, 339339, 339883, 339881, 339818, 342229, 339817, 342228, 339331, 339368, 339156, 339315, 339310, 339402, 339304, 329090, 334352, 334349, 337710, 117623, 96822, 335044, 335040, 334940, 96814, 96812, 96811, 334736, 334031, 117619, 117617, 334117, 306341, 334020, 333094, 269873, 330594, 117614, 332634, 253625, 330893, 331083, 328685, 328948, 327812, 328032, 307804, 327370, 296392, 327291, 320207, 318701, 318699, 203028, 326955, 307790, 307788, 326596, 326381, 326043, 96806, 325627, 321972, 325471, 325243, 311103, 318590, 296385, 321380, 264928, 321315, 208065, 287549, 320129, 319971, 304020, 301424, 310855, 319642, 318561, 96802, 96800, 319157, 318558, 301422, 318557, 318950, 183957, 96799, 296383, 318672, 312134, 317532, 316870, 302312, 316868, 296380, 35369, 296378, 316788, 299012, 270574, 270570, 302310, 117613, 314206, 302307, 300569, 315167, 270557, 314202, 314200, 314440, 264926, 302306, 313889, 313705, 313901, 302299, 302297, 313699, 313726, 183951, 310826, 167, 313540, 313467, 310780, 310771, 290712, 310750, 302279, 311098, 310722, 302275, 310714, 310711, 310707, 306876, 310690, 296377, 311134, 311128, 299500, 297346, 306872, 307784, 306862, 306860, 306858, 301405, 310404, 267374, 267370, 267367, 306843, 302268, 307768, 305010, 183943, 267344, 307303, 307301, 267330, 267324, 304854, 306714, 305430, 303837, 306691, 303835, 305111, 306307, 302459, 270513, 305491, 305343, 305096, 304830, 305089, 305043, 169864, 202311, 301388, 301384, 300584, 303750, 287448, 117599, 303521, 203026, 302444, 296997, 302400, 302435, 302398, 302395, 264650, 302264, 301557, 264648, 302083, 299158, 301651, 287442, 301003, 299580, 300579, 299027, 300490, 297330, 282995, 299697, 299554, 117596, 296989, 298897, 299017, 117593, 298988, 298888, 298202, 297783, 297699, 291648, 287410, 203023, 296298, 296296, 296135, 284983, 160179, 295104, 294541, 264991, 294394, 291540, 293826, 291638, 288728, 288498, 288496, 288494, 117581, 290197, 290071, 183933, 287471, 287947, 287469, 288095, 284159, 287351, 277777, 279978, 282813, 271661, 279602, 183914, 250612, 277735, 278336, 277694, 117575, 273078, 273071, 271542, 96792, 96790, 270724, 269724, 269718, 269705, 269714, 117570, 183858, 183856, 96789, 268378, 268376, 267936, 267932, 268368, 268394, 267442, 267994, 267991, 267728, 143249, 259948, 266476, 266408, 266406, 254672, 142967, 266419, 266412, 194429, 194425, 117569, 142960, 265257, 265255, 264922, 222256, 183849, 264428, 264423, 203014, 264820, 264802, 117567, 183838, 262236, 264228, 183832, 143245, 263796, 253581, 253577, 96785, 117564, 263247, 117562, 262167, 250597, 261643, 96783, 117559, 260947, 171426, 259881, 142947, 257211, 183818, 258743, 258323, 258318, 257924, 257604, 165411, 143235, 256812, 165408, 142943, 142939, 250351, 142935, 165405, 96781, 254745, 254315, 253551, 254504, 253542, 253538, 253535, 254333, 253513, 96775, 250210, 250187, 250159, 250545, 249238, 248985, 117500, 248523, 117497, 194412, 247888, 192801, 247635, 192799, 208029, 192797, 142912, 143221, 143218, 201490, 247324, 222633, 208492, 194398, 222517, 222511, 221962, 208449, 208136, 142859, 204818, 207093, 206576, 117471, 165400, 171322, 201512, 202947, 201920, 120772, 165392, 173395, 173393, 201776, 173391, 201742, 120741, 195376, 117468, 117464, 195371, 195056, 194025, 120632, 194816, 142840, 194964, 142837, 194805, 194355, 194803, 193863, 120598, 120593, 120589, 193848, 117450, 193266, 187122, 175397, 143173, 143171, 192714, 142810, 192568, 191995, 165378, 191985, 191983, 191981, 190730, 190724, 190080, 117441, 96752, 174670, 185952, 187231, 186894, 183736, 185519, 185513, 185393, 183515, 165365, 96749, 182066, 182559, 182807, 165362, 175605, 165360, 172875, 174797, 172873, 96746, 165349, 173546, 173389, 141529, 142796, 142792, 142789, 172867, 172673, 172662, 165762, 172281, 172088, 172193, 169005, 169001, 170536, 168995, 170068, 169924, 142787, 169060, 142785, 164414, 162997, 161587, 148675, 159582, 141652, 156786, 156707, 154062, 153901, 152788, 151411, 151171, 135082, 135079, 135074, 145624, 143120, 143119, 96729, 143105, 143104, 117316, 143094, 142629, 129855, 141316, 141314, 142623, 142621, 141809, 141611, 138009, 138353, 138351, 137464, 137462, 135273, 137459, 136431, 136429, 138462, 115735, 138347, 138125, 127404, 137525, 129841, 136245, 135072, 135064, 126107, 135047, 134833, 117276, 96727, 96725, 117268, 130297, 130265, 129427, 130164, 130162, 129834, 129812, 128065, 127401, 127399, 129359, 127589, 128417, 127584, 127583, 127581, 127578, 127576, 127574, 127572, 127569, 127568, 127564, 127907, 127547, 127541, 128057, 128051, 127537, 128117, 128027, 127377, 127789, 117260, 117258, 127519, 127251, 127249, 123384, 59163, 117247, 126076, 126064, 117244, 124538, 117238, 119354, 124983, 124980, 59160, 59156, 124708, 123335, 59154, 124184, 117230, 85271, 120379, 85269, 96724, 124453, 85267, 96722, 117225, 117221, 123914, 123892, 123330, 123327, 119219, 59149, 122763, 117212, 122792, 85696, 119180, 122210, 102824, 122204, 121362, 121202, 92396, 119126, 92394, 96063, 120353, 120964, 120962, 116945, 116943, 118123, 117945, 96710, 113749, 113013, 115690, 115688, 116484, 91537, 116282, 115896, 92318, 115853, 115839, 115832, 115829, 115655, 113900, 24220, 114767, 114448, 114445, 113492, 72112, 24216, 24213, 113893, 111995, 112675, 112303, 102267, 80424, 80422, 111455, 102061, 80420, 91320, 24157, 99492, 99336, 99224, 99218, 24151, 96694, 97949, 24146, 24144, 24139, 98926, 96687, 80414, 98506, 96684, 95953, 97769, 95933, 97320, 93205, 91280, 95228, 96986, 96676, 96668, 96664, 24128, 96631, 24124, 24122, 96260, 95929, 90531, 90528, 95716, 95562, 95534, 95046, 94578, 91157, 91155, 94300, 93028, 91027, 93013, 76511, 91018, 91016, 90052, 90029, 90902, 90899, 91783, 89991, 89957, 90874, 89747, 90870, 90860, 89740, 89917, 88659, 89731, 89391, 89644, 88988, 89273, 24104, 89187, 89168, 89191, 88787, 88711, 88817, 88582, 88374, 86355, 88249, 87742, 88366, 88364, 88361, 82499, 88163, 88060, 87081, 87696, 87794, 87792, 78486, 87268, 85199, 86798, 86182, 86352, 86326, 85175, 85168, 73864, 85795, 73861, 82726, 85413, 85152, 84336, 84249, 83948, 84105, 83945, 83646, 80412, 82692, 83553, 83404, 83004, 82677, 82674, 82663, 82657, 82468, 82910, 82465, 82803, 82457, 24072, 24061, 81781, 82409, 81883, 81878, 81874, 81869, 81957, 82112, 81948, 82119, 81861, 82110, 81942, 81935, 81617, 81610, 80612, 80290, 80875, 81058, 80872, 80870, 80409, 80589, 59129, 80405, 78160, 78158, 80309, 79595, 79914, 79588, 79586, 78992, 78472, 58781, 78469, 78137, 78464, 78462, 78128, 78459, 78456, 78452, 78449, 78447, 78444, 78441, 78439, 78427, 78383, 24053, 78330, 78378, 24051, 24048, 77973, 77865, 76409, 76407, 24044, 77659, 77504, 77399, 77173, 68861, 76690, 76805, 76803, 76504, 76737, 76682, 76679, 76551, 76586, 76600, 75758, 76499, 76292, 76245, 75823, 76172, 76127, 75849, 75756, 75777, 75741, 75717, 58773, 75621, 75619, 75480, 75478, 24030, 75474, 74563, 75064, 74927, 24026, 24024, 74546, 74341, 74145, 74136, 72347, 74124, 73906, 73844, 73849, 73522, 73324, 72968, 71949, 73103, 73099, 73069, 66141, 72600, 72954, 70560, 70555, 70552, 72861, 72816, 72640, 60822, 24010, 72073, 66211, 72169, 72202, 24007, 24005, 71678, 71509, 71211, 71294, 71290, 71338, 71209, 71097, 70948, 67576, 70791, 70442, 70689, 61635, 70424, 70367, 70280, 70295, 70079, 70074, 64300, 70046, 23994, 69755, 69571, 68889, 23986, 69414, 69465, 68886, 69391, 67671, 69195, 23973, 69068, 69055, 69051, 59105, 59100, 68200, 58769, 64969, 68872, 68814, 68879, 68806, 68194, 68107, 68192, 65306, 67865, 68471, 68461, 66437, 68176, 68100, 23954, 64089, 23952, 68022, 61633, 68016, 67827, 67703, 67831, 67297, 23938, 67422, 67197, 67237, 67193, 66397, 23936, 59097, 64223, 67104, 66384, 66192, 66457, 61802, 63274, 63272, 63270, 62737, 58761, 66327, 35355, 66189, 66185, 66181, 66199, 66113, 66083, 66066, 64564, 60805, 60803, 23925, 65362, 60800, 60798, 65727, 65693, 64424, 23922, 65351, 60796, 65073, 64423, 65346, 65271, 65062, 65329, 65326, 65269, 63824, 65266, 65035, 65032, 23919, 65053, 64975, 23916, 23914, 23912, 60791, 60787, 60784, 64760, 64283, 64638, 64550, 64537, 64489, 64471, 64190, 64254, 64375, 64186, 64249, 45838, 64247, 64179, 23895, 63842, 45831, 63840, 63662, 63656, 63652, 63308, 18041, 63612, 63593, 63609, 63295, 62807, 63288, 63284, 63280, 59736, 60776, 62279, 23882, 63066, 62708, 61800, 60774, 62205, 60770, 60768, 60766, 23878, 62227, 60745, 62146, 60739, 60736, 61791, 61787, 61782, 61747, 61624, 61572, 23866, 23865, 58901, 60611, 60416, 60412, 60409, 58893, 60325, 58750, 60164, 60049, 60007, 58739, 23855, 59420, 59418, 59416, 59528, 59405, 59403, 59204, 59395, 59323, 59383, 58234, 57154, 50938, 59071, 23845, 59027, 59016, 51426, 58999, 51424, 51423, 58880, 58734, 58816, 58856, 58859, 46782, 58531, 58733, 58731, 58729, 58793, 57299, 51418, 58480, 54506, 58519, 58478, 58505, 58475, 58473, 58454, 8708, 23832, 23830, 50623, 51416, 52923, 52921, 51413, 51411, 52920, 51409, 54757, 51465, 57297, 57295, 58022, 58020, 58018, 57980, 57948, 57933, 57931, 57929, 56723, 23825, 57810, 23823, 57808, 25744, 57806, 57785, 57769, 57291, 57764, 23820, 23818, 57286, 56937, 23813, 49968, 53084, 56934, 17328, 23809, 8702, 56958, 8698, 23807, 49961, 8695, 23805, 44427, 23803, 57280, 55558, 56955, 23801, 56867, 55972, 53213, 56064, 43860, 43602, 43882, 38200, 23774, 43542, 41144, 42948, 43027, 42764, 42761, 38992, 38991, 41627, 35324, 41661, 41600, 38978, 41139, 41310, 41300, 8661, 41085, 41121, 28500, 8659, 40937, 40846, 40841, 35600, 23727, 38251, 37743, 37741, 37791, 37739, 37559, 37488, 33850, 33847, 17280, 36254, 36210, 35841, 35838, 33346, 33344, 35719, 35715, 23719, 23709, 34714, 23698, 23644, 34541, 33834, 34394, 34392, 34470, 25115, 33516, 33513, 33991, 33699, 33686, 31710))
Run Time: 0.031719
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1626 | |
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 | | | | | 1626 | |
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 (21189, 20409, 20248, 19919, 19695, 19683, 19299, 19110, 18860, 18804, 18517, 18424, 18303, 17671, 17539, 16978, 16808, 16445, 15556, 15423, 15360, 15316, 15199, 15180, 14764, 14512, 14406, 14148, 13660, 13021, 12548, 12292, 11494, 9532, 9199, 9007, 8763, 8637, 8034, 8004, 7062, 6727, 6549, 6246, 5446, 5306, 5278, 3953, 3349))
Run Time: 0.001903
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 49 | 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.000180
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.000301
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.000517
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: 1716171863
Run Time: 0.000288
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 33 | 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` >= 1716171863)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000606
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 33 | 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