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.000942
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.000272
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` = '1259')
LIMIT 1
Run Time: 0.000574
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.003086
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_1259' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.086314
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 (510513, 548755, 548753, 160261, 36980, 36979, 8098, 8097, 449716, 449298, 455758, 382339, 455185, 342220, 260597, 83232, 419907, 419906, 422596, 260589, 419829, 403706, 422207, 415298, 419822, 418211, 415289, 416514, 417151, 412988, 412871, 415287, 414886, 416512, 83229, 413177, 407469, 407467, 314257, 334053, 83227, 415090, 407465, 415095, 408067, 415097, 403695, 414882, 321307, 414516, 321305, 412983, 273370, 413175, 412869, 403693, 413579, 413173, 408065, 407462, 412867, 412864, 413386, 403690, 268168, 413165, 407396, 352976, 410874, 412859, 373990, 412856, 410871, 392970, 410625, 411463, 392968, 348009, 384687, 410869, 401622, 411136, 407459, 407457, 409622, 408062, 410502, 410635, 405111, 83222, 113185, 410485, 410206, 410494, 343226, 407455, 382882, 370566, 408060, 260582, 36948, 406623, 407391, 407453, 407389, 409616, 407451, 406621, 36945, 409614, 407449, 409627, 409545, 407387, 409547, 407385, 370560, 409322, 260580, 409234, 407299, 409320, 407297, 260577, 409317, 405108, 374668, 370557, 408058, 409231, 373591, 300711, 8090, 361600, 300709, 404891, 36939, 406620, 374237, 36936, 407203, 407445, 314253, 408056, 408102, 374235, 407950, 314251, 407442, 408054, 404889, 166024, 407962, 407948, 113183, 113182, 406618, 407670, 382404, 402116, 406616, 407382, 382402, 407591, 392966, 370051, 314249, 391937, 374233, 406180, 403135, 407440, 404522, 407075, 406174, 406827, 406615, 406589, 406172, 3080, 406217, 378580, 406178, 391594, 314244, 373585, 374231, 403672, 374229, 378578, 406215, 314242, 304601, 361598, 406163, 406176, 83219, 391932, 334051, 3077, 406095, 400359, 402110, 403949, 8088, 403947, 402109, 396858, 343734, 403322, 400357, 396855, 343730, 403945, 404037, 403116, 403943, 403890, 396853, 381950, 20195, 403888, 160245, 8085, 403684, 403427, 343727, 396850, 160242, 374727, 8080, 343725, 403423, 400399, 403674, 403653, 403133, 352973, 402853, 387601, 403316, 314238, 402849, 80581, 403314, 401614, 403051, 403050, 401612, 273361, 36931, 403048, 401658, 402989, 402887, 400348, 402987, 401655, 401986, 352969, 403004, 377585, 402885, 402444, 401609, 401640, 402442, 273359, 402105, 402104, 400346, 402834, 400343, 396846, 383396, 401421, 401637, 401453, 401418, 389725, 373583, 312037, 399457, 382329, 386646, 389498, 398352, 398350, 389302, 203062, 389300, 383393, 396843, 396866, 396865, 387471, 396840, 387469, 387467, 394254, 394893, 394018, 387377, 394016, 394538, 394488, 394486, 394535, 394251, 393143, 392964, 385457, 391592, 391405, 391415, 391403, 382397, 382395, 389492, 382393, 390296, 389489, 390254, 382390, 345711, 345709, 387478, 382898, 385172, 113176, 387589, 370709, 382327, 386270, 386165, 83215, 83214, 382896, 378574, 83211, 370785, 385099, 384683, 385170, 384677, 370704, 384933, 384667, 370780, 383883, 369921, 371037, 369919, 271426, 383881, 382387, 379326, 384421, 370778, 271423, 382382, 384380, 369916, 370776, 383874, 382907, 382831, 369913, 271421, 285930, 373981, 382376, 382596, 379156, 382367, 383390, 302350, 382593, 382835, 113167, 370702, 189759, 382903, 382243, 382887, 370772, 382580, 370770, 302345, 382761, 382475, 302343, 382473, 382240, 382322, 382298, 379508, 382233, 353245, 381945, 378750, 381941, 374665, 378748, 381934, 381932, 377675, 381424, 375419, 377673, 377052, 379826, 377050, 377048, 379599, 379597, 379749, 379589, 377806, 379606, 379179, 379166, 334047, 189757, 304039, 260569, 378605, 370548, 377380, 378709, 377363, 376660, 260567, 377778, 377665, 377669, 377360, 260565, 377318, 377286, 362882, 370546, 376658, 375689, 370543, 377078, 376656, 332097, 351732, 314235, 332094, 376653, 285927, 102048, 332090, 332088, 376634, 370365, 353529, 376620, 376487, 376437, 370044, 374362, 368866, 370042, 374712, 374302, 375476, 375404, 374710, 375474, 337241, 253696, 374297, 375402, 369795, 375375, 373979, 375391, 374707, 290140, 374360, 369997, 297014, 373976, 373975, 353976, 374000, 287701, 368854, 373380, 189754, 361584, 297011, 370537, 337238, 266681, 373004, 370859, 370321, 314232, 304593, 370187, 370486, 369987, 334043, 370318, 370179, 366737, 258696, 351729, 321302, 370280, 258694, 370176, 369787, 369981, 365919, 258689, 344071, 369427, 368846, 258685, 290130, 366735, 363199, 366732, 364576, 271407, 273352, 363193, 361719, 366566, 273349, 366730, 364573, 271401, 366563, 364620, 363581, 364569, 273347, 351649, 117655, 366371, 273338, 364998, 365915, 365913, 365908, 365624, 353427, 314228, 273336, 364617, 364566, 364563, 340348, 355354, 355353, 355351, 355349, 355347, 359537, 363222, 355342, 355341, 355339, 355335, 355334, 359535, 363220, 359533, 355331, 342216, 363189, 363218, 357603, 357602, 304590, 249969, 342210, 304588, 203055, 249965, 302328, 360906, 296407, 361130, 339900, 249963, 360904, 360903, 361717, 302325, 302324, 361875, 360365, 340346, 360885, 360876, 360875, 339840, 357924, 203051, 339836, 358926, 358925, 349257, 359255, 359531, 359249, 359240, 339834, 340438, 356545, 358680, 339831, 357726, 357560, 300696, 350748, 340748, 358435, 339829, 339827, 334041, 340746, 358076, 357558, 356172, 160228, 357724, 357553, 357619, 339823, 271398, 357551, 357617, 117643, 340421, 334039, 355329, 355328, 357476, 117641, 297008, 332887, 334905, 351436, 357145, 356154, 353655, 297004, 297003, 353987, 350965, 339170, 36919, 353478, 350696, 353185, 346991, 350963, 350983, 353273, 353475, 353314, 350980, 353181, 353258, 353247, 353235, 253680, 253675, 351080, 347196, 351141, 350630, 340418, 351659, 350627, 340416, 351138, 351079, 351720, 351744, 351823, 346956, 350625, 346988, 351654, 351414, 351134, 351736, 351572, 351652, 351411, 351673, 351076, 351132, 350960, 351570, 350690, 351566, 347194, 351563, 350957, 160216, 300311, 351126, 350687, 160213, 351120, 351118, 351091, 350623, 350619, 350616, 349911, 203040, 349908, 349968, 349905, 349900, 349899, 349895, 347112, 346954, 348506, 349244, 349756, 346951, 346950, 348504, 348518, 348707, 346949, 349242, 347131, 340401, 348704, 346946, 346945, 346943, 348688, 348639, 346940, 349240, 349237, 346938, 346937, 344361, 348635, 348378, 344358, 345340, 346709, 347184, 345530, 346923, 346922, 345941, 343718, 344356, 344355, 347129, 346707, 347125, 347124, 347110, 312888, 312887, 347665, 347664, 345939, 346920, 347182, 346703, 347118, 347375, 335051, 347190, 347192, 345818, 347204, 344352, 346429, 346961, 345926, 345815, 345528, 346982, 346975, 346462, 346494, 346426, 346424, 345917, 318955, 203038, 253671, 346492, 314927, 345810, 346714, 346460, 345526, 346651, 346490, 344348, 345908, 314925, 345808, 253662, 338498, 338893, 36916, 345806, 253658, 344849, 345898, 331100, 345523, 344339, 334037, 345707, 345804, 345823, 334035, 314923, 345161, 345338, 344933, 344636, 344843, 307314, 253656, 344309, 335353, 344797, 334901, 344629, 344301, 253649, 344291, 334897, 344184, 344179, 334033, 340342, 334894, 302939, 302937, 253644, 342208, 302935, 343576, 341225, 343259, 314921, 342894, 338462, 36907, 342890, 338454, 339375, 302931, 342305, 302930, 342150, 342206, 339888, 340695, 342148, 342204, 253637, 341814, 319866, 341989, 341812, 341811, 310447, 339886, 271394, 329096, 314167, 340711, 340692, 341341, 340743, 337723, 271392, 341241, 341266, 72979, 304033, 253634, 340385, 340382, 339882, 339855, 339161, 334935, 340110, 328162, 340136, 339337, 339853, 339819, 342230, 339335, 339860, 339851, 339816, 342227, 339333, 339847, 339870, 339366, 339365, 334737, 339401, 339153, 77179, 296399, 329094, 338625, 329093, 302431, 338621, 321697, 302429, 334931, 334353, 337720, 334345, 337718, 337714, 334929, 330597, 302427, 334343, 328159, 334340, 334951, 336723, 334338, 336795, 337236, 336412, 302425, 335819, 331964, 334948, 327963, 335362, 335245, 335256, 335263, 172203, 335273, 331958, 329156, 331954, 331953, 334909, 334943, 334333, 334030, 334029, 334021, 314165, 334331, 331085, 306343, 332746, 332924, 313568, 332979, 321815, 329078, 327961, 329154, 326603, 319598, 302929, 313563, 318945, 328047, 332975, 269870, 331950, 327735, 330592, 332883, 331945, 328703, 321246, 328745, 331889, 329427, 328569, 331968, 320158, 327733, 305388, 329081, 328743, 331065, 327946, 327958, 329421, 330580, 329075, 329152, 327349, 329028, 304861, 328503, 321372, 328699, 327316, 328695, 313560, 208075, 271711, 326038, 327595, 327593, 328045, 328497, 318942, 327590, 320156, 327811, 320214, 327731, 327612, 326035, 320210, 327310, 307816, 327587, 327308, 327307, 327549, 307813, 327086, 307808, 327536, 327299, 121907, 307797, 320205, 318697, 327081, 326601, 319896, 326599, 121905, 318782, 319422, 307793, 318693, 302926, 318690, 319894, 318780, 302924, 319417, 318777, 326441, 326424, 319444, 313727, 312107, 319414, 318683, 302921, 296390, 306554, 160207, 314067, 316221, 297717, 303524, 319892, 318657, 318679, 319412, 319411, 318486, 319591, 321330, 320178, 325246, 319890, 323659, 321810, 321381, 160205, 302919, 321732, 321378, 322965, 262982, 296388, 319332, 319330, 321726, 304028, 318766, 318589, 297513, 297512, 319328, 318764, 301425, 287551, 304026, 208072, 208070, 321711, 321728, 321700, 321695, 319860, 321297, 290720, 288659, 319978, 321636, 314917, 321244, 318584, 263777, 262378, 284475, 284474, 269940, 288655, 290718, 208064, 290124, 28588, 16600, 302317, 304023, 304022, 311189, 319858, 319324, 318580, 304019, 304018, 317497, 290122, 295979, 208061, 126005, 302314, 301423, 319856, 319855, 319940, 16599, 317017, 318573, 319974, 319967, 28586, 319298, 319763, 319321, 310853, 310852, 318568, 318566, 318564, 319843, 319838, 319851, 318989, 318560, 261781, 28582, 301421, 126002, 317494, 288654, 304014, 316871, 208059, 169109, 160733, 297507, 290120, 287547, 296094, 316773, 296379, 313784, 313783, 304000, 316791, 160731, 311880, 312596, 316024, 316771, 313780, 313779, 316093, 316142, 314914, 315573, 315844, 270565, 316011, 316010, 208055, 313910, 315240, 315239, 315498, 270563, 315233, 311431, 297505, 314912, 314217, 306335, 311802, 305350, 314163, 314215, 314910, 304583, 311186, 313908, 312885, 270550, 270546, 313704, 313703, 311177, 270544, 305434, 305433, 299273, 311170, 270541, 270540, 310759, 302290, 312593, 290715, 302287, 290711, 299063, 266888, 302423, 270536, 311879, 310744, 312169, 312168, 311261, 311878, 270529, 304890, 311168, 299164, 311167, 283005, 283004, 270526, 270525, 306332, 306331, 311126, 306865, 307780, 189743, 310407, 301404, 303838, 270521, 270516, 287451, 304851, 303833, 302460, 303830, 303535, 305257, 305544, 305543, 305372, 305382, 303940, 290706, 305376, 305375, 305366, 270507, 270506, 305216, 305215, 303937, 290031, 290030, 297784, 302456, 301396, 305288, 304885, 303933, 303932, 304836, 304835, 304574, 301380, 302454, 303928, 290025, 297503, 284992, 284991, 287385, 303740, 297501, 302452, 302451, 302411, 284988, 284987, 302955, 302954, 303737, 303923, 303922, 92883, 301368, 302102, 297498, 302446, 302405, 302136, 302134, 302133, 284985, 285693, 302129, 288481, 302092, 302436, 302402, 297069, 290056, 296998, 301365, 300664, 301558, 297496, 297495, 299270, 299182, 299181, 299180, 299559, 299162, 264652, 264651, 301363, 301565, 301653, 301555, 300662, 300661, 297493, 299177, 299581, 299159, 299157, 299557, 299556, 264645, 264644, 300530, 301648, 298243, 301763, 258681, 287439, 299043, 301646, 301562, 300655, 300654, 299040, 301130, 301593, 301552, 301359, 301560, 299038, 301518, 160724, 300650, 300302, 301083, 300648, 301126, 160722, 301075, 300300, 301124, 300639, 300638, 160719, 299247, 299246, 296370, 300673, 300670, 300669, 299243, 293821, 284378, 300503, 300589, 299416, 296365, 299231, 299268, 300535, 298900, 298899, 295508, 290022, 295506, 297541, 297540, 86519, 290020, 290019, 293819, 284372, 290017, 296996, 296995, 296994, 298931, 299258, 86512, 290013, 290012, 28577, 28576, 295610, 297536, 264640, 298842, 264637, 264636, 298895, 298894, 298893, 298864, 298190, 298184, 294885, 297533, 298862, 298837, 298844, 264634, 166020, 264632, 257858, 257857, 257856, 297239, 298268, 298360, 295431, 291652, 287494, 265122, 295522, 282993, 296230, 264762, 264761, 295719, 295718, 295428, 287491, 287490, 265120, 295502, 296227, 282988, 295977, 291650, 264570, 295421, 264757, 287487, 295166, 287412, 295570, 285886, 295448, 296454, 291005, 296225, 288587, 282986, 282985, 296447, 295804, 295789, 255299, 295975, 287406, 287506, 295452, 296089, 282719, 295121, 295164, 295545, 295499, 295544, 295543, 287198, 295533, 295530, 295495, 288137, 160189, 287196, 287195, 295441, 295528, 295715, 290116, 294546, 295113, 295412, 295444, 291641, 160186, 295162, 295493, 287192, 295438, 295526, 288135, 295111, 295110, 279492, 160184, 160183, 284369, 295608, 295518, 153925, 290276, 290114, 290113, 264745, 293815, 282632, 294544, 293842, 290207, 289857, 284517, 291548, 283017, 290108, 290107, 290274, 294542, 293835, 288646, 293812, 290102, 291539, 290265, 290264, 290100, 291246, 264366, 291537, 287739, 290098, 290258, 290256, 293751, 293729, 290095, 264364, 264363, 264740, 264739, 290093, 264361, 291531, 290090, 291238, 290088, 264737, 290203, 291529, 284514, 28570, 291235, 287480, 289855, 287736, 291527, 291230, 290086, 201395, 287478, 282630, 287731, 264735, 201393, 264356, 28568, 287381, 153921, 289850, 290199, 287476, 264732, 287728, 201390, 201389, 201387, 287805, 165, 289292, 289849, 28566, 289288, 285056, 36881, 287541, 287432, 287374, 287429, 287354, 264730, 264729, 287713, 270712, 163, 287801, 285052, 285051, 36879, 286588, 283015, 284646, 287538, 287362, 260551, 287427, 287426, 264334, 282678, 287349, 287348, 264727, 270710, 282674, 270708, 282672, 282628, 284470, 282713, 282710, 284467, 282655, 282654, 284744, 283138, 284465, 261886, 282697, 201384, 284595, 282624, 284506, 250615, 282690, 283137, 279977, 266756, 267610, 277532, 267608, 267607, 269784, 267605, 269782, 270934, 267601, 207885, 269777, 269776, 269764, 270998, 269759, 258678, 270725, 270932, 271084, 270811, 269748, 270947, 270945, 270697, 135651, 270695, 270956, 270968, 270941, 269744, 269741, 270608, 268310, 269737, 269731, 270605, 270602, 267596, 269898, 269865, 269896, 269729, 269863, 250960, 264629, 264628, 264626, 269893, 269892, 269953, 269726, 269725, 267559, 269921, 269942, 264624, 269861, 263933, 263929, 268307, 268306, 268140, 183200, 183198, 263563, 263775, 267165, 266509, 203816, 263554, 266674, 263790, 267058, 266672, 266507, 266505, 266670, 208050, 142965, 257535, 249504, 257527, 265094, 265573, 257525, 263234, 257853, 264722, 263927, 265230, 264796, 263924, 264715, 264172, 202715, 263232, 264314, 264313, 264309, 258671, 263780, 263230, 265064, 264672, 261562, 258666, 264303, 264280, 264279, 257752, 262467, 262212, 250604, 255501, 262210, 262209, 262493, 262407, 262465, 262464, 262463, 258662, 261427, 262376, 262287, 263755, 262486, 262392, 262415, 36871, 262190, 255485, 36867, 250954, 261425, 259970, 258658, 250590, 259522, 259521, 258127, 36860, 259732, 259724, 258122, 258119, 258117, 258242, 250580, 258112, 258111, 257925, 257936, 257593, 254371, 254363, 250368, 250342, 250338, 222323, 222322, 250515, 222069, 251059, 143641, 248709, 250425, 250421, 248793, 248706, 248705, 248703, 248105, 160685, 143639, 207880, 207443, 202438, 188562, 207428, 207724, 160660, 191529, 191450, 191471, 191078, 184664, 188555, 173952, 173951, 186085, 172755, 173928, 173478, 173477, 173801, 172738, 172864, 171049, 162211, 170044, 127690, 170039, 169964, 169842, 167752, 169836, 162201, 162187, 169016, 169031, 168705, 168691, 167590, 167954, 165492, 166571, 167112, 167281, 167273, 167353, 166727, 165489, 164743, 166561, 166723, 152188, 160619, 166557, 166556, 152186, 166005, 160617, 160616, 166554, 165719, 166400, 166335, 152183, 166003, 166002, 165943, 164721, 160610, 166000, 165939, 165993, 165482, 164700, 165477, 165475, 160586, 157776, 156780, 157552, 157551, 156468, 156467, 156466, 157489, 96138, 96137, 121539, 121538, 156461, 126992, 156442, 156437, 126988, 156434, 134725, 134724, 156433, 126986, 155732, 156387, 3027, 126984, 134721, 154892, 134719, 134717, 150784, 150782, 150780, 151770, 151766, 150778, 143627, 127673, 150408, 145575, 145707, 144402, 138989, 139852, 138533, 133891, 128336, 128331, 82613, 139839, 139838, 133889, 133888, 133887, 140257, 138937, 133882, 133881, 140021, 140020, 138831, 127661, 139827, 139821, 82608, 140014, 138825, 133879, 137469, 128324, 82606, 82605, 127658, 138522, 138521, 138709, 82602, 138514, 138707, 82599, 138511, 138648, 82596, 127648, 138502, 137466, 137465, 138645, 122217, 121577, 127646, 137074, 138500, 128322, 127639, 137067, 128319, 138493, 138492, 127635, 126917, 138306, 82594, 138112, 126911, 138283, 138277, 137724, 136337, 133805, 126906, 133877, 133876, 133871, 133870, 126899, 133796, 133793, 95817, 129840, 135520, 135917, 82588, 135566, 135953, 136155, 133778, 130032, 133867, 123960, 126881, 85524, 85523, 130029, 130028, 134709, 129656, 133633, 133864, 133763, 133848, 133631, 133845, 127476, 133692, 133834, 133629, 133628, 116304, 127474, 127472, 125674, 127470, 127468, 125586, 125584, 127197, 125581, 125580, 127194, 127193, 127183, 125575, 126639, 125666, 125189, 125188, 124353, 124162, 124150, 122730, 116874, 116873, 116871, 115515, 114373, 113360, 117071, 117055, 116797, 114369, 117084, 117051, 116794, 114362, 116533, 116531, 114360, 112089, 112088, 116163, 116530, 101925, 112086, 116332, 116161, 116528, 114356, 113355, 116286, 116109, 115511, 72118, 101845, 101844, 112864, 112445, 112589, 112587, 112663, 112066, 101748, 96949, 99621, 93452, 99603, 98317, 98316, 96936, 96934, 96933, 99084, 98996, 98223, 84671, 84668, 84350, 86002, 84774, 84348, 84347, 84345, 84344, 84751, 84771, 84769, 84653, 84652, 58723, 58712, 58707, 59029, 51491, 51626, 51592, 48915, 48914, 41358, 41472, 35421, 32282, 40021))
Run Time: 0.108023
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2211 | |
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 | | | | | 2211 | |
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 (25370, 20701, 20495, 20141, 20032, 19781, 19620, 19532, 19416, 19372, 19220, 19023, 18954, 18894, 18893, 18822, 18365, 18352, 18169, 17788, 17646, 17465, 17444, 17440, 17424, 16809, 16671, 16643, 16639, 16583, 16482, 16443, 16167, 15961, 15960, 15235, 14226, 13673, 11285, 11206, 8190))
Run Time: 0.002535
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 41 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 180
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (510513, 548755, 548753, 160261, 36980, 36979, 8098, 8097, 449716, 449298, 455758, 382339, 455185, 342220, 260597, 83232, 419907, 419906, 422596, 260589, 419829, 403706, 422207, 415298, 419822, 418211, 415289, 416514, 417151, 412988, 412871, 415287, 414886, 416512, 83229, 413177, 407469, 407467, 314257, 334053, 83227, 415090, 407465, 415095, 408067, 415097, 403695, 414882, 321307, 414516, 321305, 412983, 273370, 413175, 412869, 403693, 413579, 413173, 408065, 407462, 412867, 412864, 413386, 403690, 268168, 413165, 407396, 352976, 410874, 412859, 373990, 412856, 410871, 392970, 410625, 411463, 392968, 348009, 384687, 410869, 401622, 411136, 407459, 407457, 409622, 408062, 410502, 410635, 405111, 83222, 113185, 410485, 410206, 410494, 343226, 407455, 382882, 370566, 408060, 260582, 36948, 406623, 407391, 407453, 407389, 409616, 407451, 406621, 36945, 409614, 407449, 409627, 409545, 407387, 409547, 407385, 370560, 409322, 260580, 409234, 407299, 409320, 407297, 260577, 409317, 405108, 374668, 370557, 408058, 409231, 373591, 300711, 8090, 361600, 300709, 404891, 36939, 406620, 374237, 36936, 407203, 407445, 314253, 408056, 408102, 374235, 407950, 314251, 407442, 408054, 404889, 166024, 407962, 407948, 113183, 113182, 406618, 407670, 382404, 402116, 406616, 407382, 382402, 407591, 392966, 370051, 314249, 391937, 374233, 406180, 403135, 407440, 404522, 407075, 406174, 406827, 406615, 406589, 406172, 3080, 406217, 378580, 406178, 391594, 314244, 373585, 374231, 403672, 374229, 378578, 406215, 314242, 304601, 361598, 406163, 406176, 83219, 391932, 334051, 3077, 406095, 400359, 402110, 403949, 8088, 403947, 402109, 396858, 343734, 403322, 400357, 396855, 343730, 403945, 404037, 403116, 403943, 403890, 396853, 381950, 20195, 403888, 160245, 8085, 403684, 403427, 343727, 396850, 160242, 374727, 8080, 343725, 403423, 400399, 403674, 403653, 403133, 352973, 402853, 387601, 403316, 314238, 402849, 80581, 403314, 401614, 403051, 403050, 401612, 273361, 36931, 403048, 401658, 402989, 402887, 400348, 402987, 401655, 401986, 352969, 403004, 377585, 402885, 402444, 401609, 401640, 402442, 273359, 402105, 402104, 400346, 402834, 400343, 396846, 383396, 401421, 401637, 401453, 401418, 389725, 373583, 312037, 399457, 382329, 386646, 389498, 398352, 398350, 389302, 203062, 389300, 383393, 396843, 396866, 396865, 387471, 396840, 387469, 387467, 394254, 394893, 394018, 387377, 394016, 394538, 394488, 394486, 394535, 394251, 393143, 392964, 385457, 391592, 391405, 391415, 391403, 382397, 382395, 389492, 382393, 390296, 389489, 390254, 382390, 345711, 345709, 387478, 382898, 385172, 113176, 387589, 370709, 382327, 386270, 386165, 83215, 83214, 382896, 378574, 83211, 370785, 385099, 384683, 385170, 384677, 370704, 384933, 384667, 370780, 383883, 369921, 371037, 369919, 271426, 383881, 382387, 379326, 384421, 370778, 271423, 382382, 384380, 369916, 370776, 383874, 382907, 382831, 369913, 271421, 285930, 373981, 382376, 382596, 379156, 382367, 383390, 302350, 382593, 382835, 113167, 370702, 189759, 382903, 382243, 382887, 370772, 382580, 370770, 302345, 382761, 382475, 302343, 382473, 382240, 382322, 382298, 379508, 382233, 353245, 381945, 378750, 381941, 374665, 378748, 381934, 381932, 377675, 381424, 375419, 377673, 377052, 379826, 377050, 377048, 379599, 379597, 379749, 379589, 377806, 379606, 379179, 379166, 334047, 189757, 304039, 260569, 378605, 370548, 377380, 378709, 377363, 376660, 260567, 377778, 377665, 377669, 377360, 260565, 377318, 377286, 362882, 370546, 376658, 375689, 370543, 377078, 376656, 332097, 351732, 314235, 332094, 376653, 285927, 102048, 332090, 332088, 376634, 370365, 353529, 376620, 376487, 376437, 370044, 374362, 368866, 370042, 374712, 374302, 375476, 375404, 374710, 375474, 337241, 253696, 374297, 375402, 369795, 375375, 373979, 375391, 374707, 290140, 374360, 369997, 297014, 373976, 373975, 353976, 374000, 287701, 368854, 373380, 189754, 361584, 297011, 370537, 337238, 266681, 373004, 370859, 370321, 314232, 304593, 370187, 370486, 369987, 334043, 370318, 370179, 366737, 258696, 351729, 321302, 370280, 258694, 370176, 369787, 369981, 365919, 258689, 344071, 369427, 368846, 258685, 290130, 366735, 363199, 366732, 364576, 271407, 273352, 363193, 361719, 366566, 273349, 366730, 364573, 271401, 366563, 364620, 363581, 364569, 273347, 351649, 117655, 366371, 273338, 364998, 365915, 365913, 365908, 365624, 353427, 314228, 273336, 364617, 364566, 364563, 340348, 355354, 355353, 355351, 355349, 355347, 359537, 363222, 355342, 355341, 355339, 355335, 355334, 359535, 363220, 359533, 355331, 342216, 363189, 363218, 357603, 357602, 304590, 249969, 342210, 304588, 203055, 249965, 302328, 360906, 296407, 361130, 339900, 249963, 360904, 360903, 361717, 302325, 302324, 361875, 360365, 340346, 360885, 360876, 360875, 339840, 357924, 203051, 339836, 358926, 358925, 349257, 359255, 359531, 359249, 359240, 339834, 340438, 356545, 358680, 339831, 357726, 357560, 300696, 350748, 340748, 358435, 339829, 339827, 334041, 340746, 358076, 357558, 356172, 160228, 357724, 357553, 357619, 339823, 271398, 357551, 357617, 117643, 340421, 334039, 355329, 355328, 357476, 117641, 297008, 332887, 334905, 351436, 357145, 356154, 353655, 297004, 297003, 353987, 350965, 339170, 36919, 353478, 350696, 353185, 346991, 350963, 350983, 353273, 353475, 353314, 350980, 353181, 353258, 353247, 353235, 253680, 253675, 351080, 347196, 351141, 350630, 340418, 351659, 350627, 340416, 351138, 351079, 351720, 351744, 351823, 346956, 350625, 346988, 351654, 351414, 351134, 351736, 351572, 351652, 351411, 351673, 351076, 351132, 350960, 351570, 350690, 351566, 347194, 351563, 350957, 160216, 300311, 351126, 350687, 160213, 351120, 351118, 351091, 350623, 350619, 350616, 349911, 203040, 349908, 349968, 349905, 349900, 349899, 349895, 347112, 346954, 348506, 349244, 349756, 346951, 346950, 348504, 348518, 348707, 346949, 349242, 347131, 340401, 348704, 346946, 346945, 346943, 348688, 348639, 346940, 349240, 349237, 346938, 346937, 344361, 348635, 348378, 344358, 345340, 346709, 347184, 345530, 346923, 346922, 345941, 343718, 344356, 344355, 347129, 346707, 347125, 347124, 347110, 312888, 312887, 347665, 347664, 345939, 346920, 347182, 346703, 347118, 347375, 335051, 347190, 347192, 345818, 347204, 344352, 346429, 346961, 345926, 345815, 345528, 346982, 346975, 346462, 346494, 346426, 346424, 345917, 318955, 203038, 253671, 346492, 314927, 345810, 346714, 346460, 345526, 346651, 346490, 344348, 345908, 314925, 345808, 253662, 338498, 338893, 36916, 345806, 253658, 344849, 345898, 331100, 345523, 344339, 334037, 345707, 345804, 345823, 334035, 314923, 345161, 345338, 344933, 344636, 344843, 307314, 253656, 344309, 335353, 344797, 334901, 344629, 344301, 253649, 344291, 334897, 344184, 344179, 334033, 340342, 334894, 302939, 302937, 253644, 342208, 302935, 343576, 341225, 343259, 314921, 342894, 338462, 36907, 342890, 338454, 339375, 302931, 342305, 302930, 342150, 342206, 339888, 340695, 342148, 342204, 253637, 341814, 319866, 341989, 341812, 341811, 310447, 339886, 271394, 329096, 314167, 340711, 340692, 341341, 340743, 337723, 271392, 341241, 341266, 72979, 304033, 253634, 340385, 340382, 339882, 339855, 339161, 334935, 340110, 328162, 340136, 339337, 339853, 339819, 342230, 339335, 339860, 339851, 339816, 342227, 339333, 339847, 339870, 339366, 339365, 334737, 339401, 339153, 77179, 296399, 329094, 338625, 329093, 302431, 338621, 321697, 302429, 334931, 334353, 337720, 334345, 337718, 337714, 334929, 330597, 302427, 334343, 328159, 334340, 334951, 336723, 334338, 336795, 337236, 336412, 302425, 335819, 331964, 334948, 327963, 335362, 335245, 335256, 335263, 172203, 335273, 331958, 329156, 331954, 331953, 334909, 334943, 334333, 334030, 334029, 334021, 314165, 334331, 331085, 306343, 332746, 332924, 313568, 332979, 321815, 329078, 327961, 329154, 326603, 319598, 302929, 313563, 318945, 328047, 332975, 269870, 331950, 327735, 330592, 332883, 331945, 328703, 321246, 328745, 331889, 329427, 328569, 331968, 320158, 327733, 305388, 329081, 328743, 331065, 327946, 327958, 329421, 330580, 329075, 329152, 327349, 329028, 304861, 328503, 321372, 328699, 327316, 328695, 313560, 208075, 271711, 326038, 327595, 327593, 328045, 328497, 318942, 327590, 320156, 327811, 320214, 327731, 327612, 326035, 320210, 327310, 307816, 327587, 327308, 327307, 327549, 307813, 327086, 307808, 327536, 327299, 121907, 307797, 320205, 318697, 327081, 326601, 319896, 326599, 121905, 318782, 319422, 307793, 318693, 302926, 318690, 319894, 318780, 302924, 319417, 318777, 326441, 326424, 319444, 313727, 312107, 319414, 318683, 302921, 296390, 306554, 160207, 314067, 316221, 297717, 303524, 319892, 318657, 318679, 319412, 319411, 318486, 319591, 321330, 320178, 325246, 319890, 323659, 321810, 321381, 160205, 302919, 321732, 321378, 322965, 262982, 296388, 319332, 319330, 321726, 304028, 318766, 318589, 297513, 297512, 319328, 318764, 301425, 287551, 304026, 208072, 208070, 321711, 321728, 321700, 321695, 319860, 321297, 290720, 288659, 319978, 321636, 314917, 321244, 318584, 263777, 262378, 284475, 284474, 269940, 288655, 290718, 208064, 290124, 28588, 16600, 302317, 304023, 304022, 311189, 319858, 319324, 318580, 304019, 304018, 317497, 290122, 295979, 208061, 126005, 302314, 301423, 319856, 319855, 319940, 16599, 317017, 318573, 319974, 319967, 28586, 319298, 319763, 319321, 310853, 310852, 318568, 318566, 318564, 319843, 319838, 319851, 318989, 318560, 261781, 28582, 301421, 126002, 317494, 288654, 304014, 316871, 208059, 169109, 160733, 297507, 290120, 287547, 296094, 316773, 296379, 313784, 313783, 304000, 316791, 160731, 311880, 312596, 316024, 316771, 313780, 313779, 316093, 316142, 314914, 315573, 315844, 270565, 316011, 316010, 208055, 313910, 315240, 315239, 315498, 270563, 315233, 311431, 297505, 314912, 314217, 306335, 311802, 305350, 314163, 314215, 314910, 304583, 311186, 313908, 312885, 270550, 270546, 313704, 313703, 311177, 270544, 305434, 305433, 299273, 311170, 270541, 270540, 310759, 302290, 312593, 290715, 302287, 290711, 299063, 266888, 302423, 270536, 311879, 310744, 312169, 312168, 311261, 311878, 270529, 304890, 311168, 299164, 311167, 283005, 283004, 270526, 270525, 306332, 306331, 311126, 306865, 307780, 189743, 310407, 301404, 303838, 270521, 270516, 287451, 304851, 303833, 302460, 303830, 303535, 305257, 305544, 305543, 305372, 305382, 303940, 290706, 305376, 305375, 305366, 270507, 270506, 305216, 305215, 303937, 290031, 290030, 297784, 302456, 301396, 305288, 304885, 303933, 303932, 304836, 304835, 304574, 301380, 302454, 303928, 290025, 297503, 284992, 284991, 287385, 303740, 297501, 302452, 302451, 302411, 284988, 284987, 302955, 302954, 303737, 303923, 303922, 92883, 301368, 302102, 297498, 302446, 302405, 302136, 302134, 302133, 284985, 285693, 302129, 288481, 302092, 302436, 302402, 297069, 290056, 296998, 301365, 300664, 301558, 297496, 297495, 299270, 299182, 299181, 299180, 299559, 299162, 264652, 264651, 301363, 301565, 301653, 301555, 300662, 300661, 297493, 299177, 299581, 299159, 299157, 299557, 299556, 264645, 264644, 300530, 301648, 298243, 301763, 258681, 287439, 299043, 301646, 301562, 300655, 300654, 299040, 301130, 301593, 301552, 301359, 301560, 299038, 301518, 160724, 300650, 300302, 301083, 300648, 301126, 160722, 301075, 300300, 301124, 300639, 300638, 160719, 299247, 299246, 296370, 300673, 300670, 300669, 299243, 293821, 284378, 300503, 300589, 299416, 296365, 299231, 299268, 300535, 298900, 298899, 295508, 290022, 295506, 297541, 297540, 86519, 290020, 290019, 293819, 284372, 290017, 296996, 296995, 296994, 298931, 299258, 86512, 290013, 290012, 28577, 28576, 295610, 297536, 264640, 298842, 264637, 264636, 298895, 298894, 298893, 298864, 298190, 298184, 294885, 297533, 298862, 298837, 298844, 264634, 166020, 264632, 257858, 257857, 257856, 297239, 298268, 298360, 295431, 291652, 287494, 265122, 295522, 282993, 296230, 264762, 264761, 295719, 295718, 295428, 287491, 287490, 265120, 295502, 296227, 282988, 295977, 291650, 264570, 295421, 264757, 287487, 295166, 287412, 295570, 285886, 295448, 296454, 291005, 296225, 288587, 282986, 282985, 296447, 295804, 295789, 255299, 295975, 287406, 287506, 295452, 296089, 282719, 295121, 295164, 295545, 295499, 295544, 295543, 287198, 295533, 295530, 295495, 288137, 160189, 287196, 287195, 295441, 295528, 295715, 290116, 294546, 295113, 295412, 295444, 291641, 160186, 295162, 295493, 287192, 295438, 295526, 288135, 295111, 295110, 279492, 160184, 160183, 284369, 295608, 295518, 153925, 290276, 290114, 290113, 264745, 293815, 282632, 294544, 293842, 290207, 289857, 284517, 291548, 283017, 290108, 290107, 290274, 294542, 293835, 288646, 293812, 290102, 291539, 290265, 290264, 290100, 291246, 264366, 291537, 287739, 290098, 290258, 290256, 293751, 293729, 290095, 264364, 264363, 264740, 264739, 290093, 264361, 291531, 290090, 291238, 290088, 264737, 290203, 291529, 284514, 28570, 291235, 287480, 289855, 287736, 291527, 291230, 290086, 201395, 287478, 282630, 287731, 264735, 201393, 264356, 28568, 287381, 153921, 289850, 290199, 287476, 264732, 287728, 201390, 201389, 201387, 287805, 165, 289292, 289849, 28566, 289288, 285056, 36881, 287541, 287432, 287374, 287429, 287354, 264730, 264729, 287713, 270712, 163, 287801, 285052, 285051, 36879, 286588, 283015, 284646, 287538, 287362, 260551, 287427, 287426, 264334, 282678, 287349, 287348, 264727, 270710, 282674, 270708, 282672, 282628, 284470, 282713, 282710, 284467, 282655, 282654, 284744, 283138, 284465, 261886, 282697, 201384, 284595, 282624, 284506, 250615, 282690, 283137, 279977, 266756, 267610, 277532, 267608, 267607, 269784, 267605, 269782, 270934, 267601, 207885, 269777, 269776, 269764, 270998, 269759, 258678, 270725, 270932, 271084, 270811, 269748, 270947, 270945, 270697, 135651, 270695, 270956, 270968, 270941, 269744, 269741, 270608, 268310, 269737, 269731, 270605, 270602, 267596, 269898, 269865, 269896, 269729, 269863, 250960, 264629, 264628, 264626, 269893, 269892, 269953, 269726, 269725, 267559, 269921, 269942, 264624, 269861, 263933, 263929, 268307, 268306, 268140, 183200, 183198, 263563, 263775, 267165, 266509, 203816, 263554, 266674, 263790, 267058, 266672, 266507, 266505, 266670, 208050, 142965, 257535, 249504, 257527, 265094, 265573, 257525, 263234, 257853, 264722, 263927, 265230, 264796, 263924, 264715, 264172, 202715, 263232, 264314, 264313, 264309, 258671, 263780, 263230, 265064, 264672, 261562, 258666, 264303, 264280, 264279, 257752, 262467, 262212, 250604, 255501, 262210, 262209, 262493, 262407, 262465, 262464, 262463, 258662, 261427, 262376, 262287, 263755, 262486, 262392, 262415, 36871, 262190, 255485, 36867, 250954, 261425, 259970, 258658, 250590, 259522, 259521, 258127, 36860, 259732, 259724, 258122, 258119, 258117, 258242, 250580, 258112, 258111, 257925, 257936, 257593, 254371, 254363, 250368, 250342, 250338, 222323, 222322, 250515, 222069, 251059, 143641, 248709, 250425, 250421, 248793, 248706, 248705, 248703, 248105, 160685, 143639, 207880, 207443, 202438, 188562, 207428, 207724, 160660, 191529, 191450, 191471, 191078, 184664, 188555, 173952, 173951, 186085, 172755, 173928, 173478, 173477, 173801, 172738, 172864, 171049, 162211, 170044, 127690, 170039, 169964, 169842, 167752, 169836, 162201, 162187, 169016, 169031, 168705, 168691, 167590, 167954, 165492, 166571, 167112, 167281, 167273, 167353, 166727, 165489, 164743, 166561, 166723, 152188, 160619, 166557, 166556, 152186, 166005, 160617, 160616, 166554, 165719, 166400, 166335, 152183, 166003, 166002, 165943, 164721, 160610, 166000, 165939, 165993, 165482, 164700, 165477, 165475, 160586, 157776, 156780, 157552, 157551, 156468, 156467, 156466, 157489, 96138, 96137, 121539, 121538, 156461, 126992, 156442, 156437, 126988, 156434, 134725, 134724, 156433, 126986, 155732, 156387, 3027, 126984, 134721, 154892, 134719, 134717, 150784, 150782, 150780, 151770, 151766, 150778, 143627, 127673, 150408, 145575, 145707, 144402, 138989, 139852, 138533, 133891, 128336, 128331, 82613, 139839, 139838, 133889, 133888, 133887, 140257, 138937, 133882, 133881, 140021, 140020, 138831, 127661, 139827, 139821, 82608, 140014, 138825, 133879, 137469, 128324, 82606, 82605, 127658, 138522, 138521, 138709, 82602, 138514, 138707, 82599, 138511, 138648, 82596, 127648, 138502, 137466, 137465, 138645, 122217, 121577, 127646, 137074, 138500, 128322, 127639, 137067, 128319, 138493, 138492, 127635, 126917, 138306, 82594, 138112, 126911, 138283, 138277, 137724, 136337, 133805, 126906, 133877, 133876, 133871, 133870, 126899, 133796, 133793, 95817, 129840, 135520, 135917, 82588, 135566, 135953, 136155, 133778, 130032, 133867, 123960, 126881, 85524, 85523, 130029, 130028, 134709, 129656, 133633, 133864, 133763, 133848, 133631, 133845, 127476, 133692, 133834, 133629, 133628, 116304, 127474, 127472, 125674, 127470, 127468, 125586, 125584, 127197, 125581, 125580, 127194, 127193, 127183, 125575, 126639, 125666, 125189, 125188, 124353, 124162, 124150, 122730, 116874, 116873, 116871, 115515, 114373, 113360, 117071, 117055, 116797, 114369, 117084, 117051, 116794, 114362, 116533, 116531, 114360, 112089, 112088, 116163, 116530, 101925, 112086, 116332, 116161, 116528, 114356, 113355, 116286, 116109, 115511, 72118, 101845, 101844, 112864, 112445, 112589, 112587, 112663, 112066, 101748, 96949, 99621, 93452, 99603, 98317, 98316, 96936, 96934, 96933, 99084, 98996, 98223, 84671, 84668, 84350, 86002, 84774, 84348, 84347, 84345, 84344, 84751, 84771, 84769, 84653, 84652, 58723, 58712, 58707, 59029, 51491, 51626, 51592, 48915, 48914, 41358, 41472, 35421, 32282, 40021))
Run Time: 0.045882
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2211 | |
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 | | | | | 2211 | |
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 (25370, 20701, 20495, 20141, 20032, 19781, 19620, 19532, 19416, 19372, 19220, 19023, 18954, 18894, 18893, 18822, 18365, 18352, 18169, 17788, 17646, 17465, 17444, 17440, 17424, 16809, 16671, 16643, 16639, 16583, 16482, 16443, 16167, 15961, 15960, 15235, 14226, 13673, 11285, 11206, 8190))
Run Time: 0.002158
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 41 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, �s
Run Time: 0.000198
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.000541
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.000521
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: 1716191456
Run Time: 0.000318
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 11 | 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` >= 1716191456)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000653
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 11 | 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