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.000734
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.000226
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` = '2076')
LIMIT 1
Run Time: 0.000409
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.001751
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_2076' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.050803
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 (586603, 586602, 586598, 585268, 584387, 541697, 541696, 541694, 541692, 271975, 570846, 577612, 376416, 376415, 576171, 413819, 571150, 571148, 417886, 417883, 417879, 517362, 571307, 571301, 480344, 569500, 570824, 389236, 571299, 398480, 571841, 398478, 398475, 571297, 571668, 571666, 206112, 206110, 571292, 380922, 380915, 571145, 571143, 380909, 380905, 569937, 417967, 569925, 371888, 547143, 547140, 547138, 547136, 547134, 371859, 546984, 564038, 483386, 412315, 133087, 431694, 412299, 244399, 244398, 412296, 561507, 549833, 431672, 431671, 559039, 536678, 536482, 380683, 429978, 380680, 545912, 380661, 380653, 545669, 380636, 380626, 380618, 413790, 429723, 536561, 537879, 514043, 243966, 243906, 451726, 526767, 414861, 485546, 414857, 414853, 362429, 362426, 380525, 367423, 108584, 243773, 243742, 243740, 243737, 243732, 243728, 243726, 518040, 518038, 380516, 522792, 243694, 243691, 243607, 380500, 619651, 500136, 205844, 243377, 500130, 413761, 501654, 413759, 380370, 500127, 242965, 242958, 492831, 349516, 242793, 486965, 349512, 242732, 485120, 108003, 108001, 485117, 474271, 230657, 484204, 230653, 618523, 389144, 484191, 484232, 199115, 470841, 484155, 242500, 371686, 242497, 448630, 483877, 483873, 483221, 483210, 482715, 482710, 482580, 242446, 242443, 242439, 242411, 242410, 242227, 475128, 205745, 475127, 205740, 205720, 241919, 241654, 241652, 241578, 241555, 241506, 241489, 457914, 241487, 241437, 241389, 241384, 241351, 229627, 241345, 229576, 454957, 241321, 454357, 454352, 453091, 453869, 453941, 453082, 453937, 453930, 453925, 453865, 411500, 411498, 411497, 453077, 453062, 330124, 359938, 371603, 359936, 241260, 359934, 452636, 452629, 452496, 452625, 452323, 414007, 132270, 198137, 452178, 452173, 452169, 317000, 403923, 403920, 403917, 216430, 448550, 417709, 412975, 330113, 450996, 448548, 205531, 205530, 404568, 404567, 449631, 449272, 449269, 449267, 449264, 449257, 107464, 107460, 359908, 448655, 107449, 241003, 205524, 107414, 415444, 415435, 421632, 422258, 421059, 420904, 420898, 420894, 421056, 420999, 421039, 421034, 420994, 419953, 419951, 419943, 415413, 415405, 415402, 415391, 419881, 415371, 419685, 310553, 107339, 419291, 418889, 418963, 418960, 418886, 418881, 419053, 418878, 240728, 418523, 418521, 417696, 414321, 414319, 418154, 417687, 417683, 417682, 417623, 417414, 416834, 240706, 414648, 240703, 404563, 197859, 330088, 132153, 375216, 389126, 416571, 416606, 416153, 416088, 216055, 415633, 240576, 415545, 107266, 107261, 415503, 415351, 415348, 132132, 413726, 132125, 414610, 414607, 414605, 414601, 414316, 240548, 414314, 413708, 413424, 197777, 413448, 413422, 380012, 413357, 380008, 413420, 380006, 413279, 413276, 411247, 411229, 411227, 107230, 413015, 411213, 412646, 412640, 411208, 411205, 206364, 206361, 411201, 206358, 411199, 405295, 409743, 409735, 405286, 362308, 362303, 362297, 362295, 362290, 405267, 405265, 240350, 405244, 371580, 371578, 405233, 405232, 405225, 405224, 405218, 405211, 405207, 240302, 409357, 409353, 408867, 409138, 240290, 240265, 240262, 240255, 240201, 240195, 240185, 408541, 240154, 240148, 402083, 407846, 400060, 205501, 407492, 240087, 240067, 240065, 240062, 240060, 240046, 407196, 407193, 406127, 406123, 406120, 406118, 240001, 240000, 397783, 400039, 239968, 239955, 406146, 107037, 171769, 171767, 404425, 197520, 405188, 405186, 405183, 405178, 405172, 405167, 405160, 405157, 405155, 405149, 405146, 400029, 404559, 404874, 404985, 404446, 404870, 404865, 404555, 239935, 404553, 404511, 404332, 367066, 404329, 404415, 402219, 403079, 239884, 403289, 403663, 403329, 403590, 403582, 403251, 403580, 403572, 403570, 403569, 403248, 300839, 402183, 239868, 239859, 132054, 239846, 205490, 402365, 239837, 402342, 402340, 367038, 402334, 402173, 402064, 239809, 239807, 402142, 239802, 239799, 402050, 239793, 401568, 239772, 396351, 205465, 401671, 239751, 362208, 401566, 362196, 362189, 239707, 239705, 362187, 239701, 239697, 400508, 239684, 239673, 205455, 239666, 239657, 239655, 239645, 401066, 400838, 401244, 400832, 399744, 132018, 362131, 399631, 398235, 397048, 205434, 399853, 399850, 399962, 399960, 399848, 399840, 398637, 398633, 239594, 399734, 239593, 398630, 398627, 322269, 398621, 397703, 337148, 337145, 399499, 397143, 399454, 239554, 399428, 239545, 396339, 239541, 396336, 394714, 205403, 396332, 239468, 239434, 197194, 396316, 396783, 396811, 205387, 396772, 396771, 205370, 205369, 396297, 396292, 215187, 197148, 239393, 197139, 197137, 239389, 395707, 197127, 395697, 395694, 239387, 395838, 392884, 395680, 395678, 395478, 239361, 215148, 395435, 395432, 395430, 239346, 239333, 395358, 239330, 239329, 239328, 239325, 393478, 23385, 328252, 328248, 131920, 394426, 394355, 393471, 394194, 394189, 394159, 378298, 394156, 393622, 394154, 239259, 394036, 239250, 393466, 197036, 392446, 378291, 393460, 366995, 393457, 393620, 239241, 392668, 392666, 392274, 392396, 392270, 392650, 392264, 239200, 392261, 392256, 392300, 391645, 392050, 391643, 391640, 239126, 391631, 239115, 391382, 390331, 389123, 389116, 389113, 349461, 388556, 346529, 387517, 366984, 366982, 387229, 358346, 387254, 387224, 386897, 386577, 386523, 386493, 386478, 386475, 386489, 378284, 238793, 366979, 386115, 227430, 386111, 227424, 227419, 227416, 227415, 385179, 385237, 384538, 238668, 384752, 376084, 384748, 384878, 384876, 384537, 384036, 349455, 384341, 330032, 330030, 371472, 383438, 384029, 238558, 383654, 384027, 384020, 383436, 366948, 227319, 227314, 383509, 366944, 383507, 383504, 383108, 366940, 383499, 383492, 383105, 382057, 383011, 383346, 383341, 382688, 383133, 382685, 371471, 383008, 383000, 383088, 382679, 382677, 382676, 382672, 382463, 382005, 381641, 366927, 381234, 379841, 379776, 379828, 379774, 379772, 379640, 366921, 379030, 378842, 378839, 378720, 378529, 377064, 238359, 376355, 376695, 376352, 376350, 376346, 376342, 376688, 376685, 377303, 376680, 376679, 376339, 376918, 376336, 376335, 376333, 376915, 376913, 374635, 376983, 375729, 376330, 376329, 376673, 376819, 376671, 376966, 376327, 375946, 375848, 376540, 196650, 376316, 376028, 375449, 375842, 375447, 345549, 374999, 374997, 374990, 374904, 374800, 374196, 363843, 214043, 214036, 372630, 214024, 106104, 366223, 372589, 371424, 330012, 330007, 367867, 330005, 371420, 371415, 371408, 329993, 371396, 362614, 362610, 362608, 362606, 362596, 362594, 364105, 329984, 329982, 369875, 362590, 369302, 369873, 369867, 369865, 369299, 237996, 237993, 237990, 237988, 369295, 329972, 369292, 369290, 329970, 258509, 314402, 368413, 368409, 366084, 366080, 367810, 180821, 180819, 180817, 180816, 180815, 180814, 367804, 365508, 365504, 331280, 365095, 365502, 331278, 105962, 365499, 237808, 237806, 365077, 365491, 329959, 363142, 226286, 285843, 361510, 213292, 361507, 361504, 361501, 309913, 361192, 226250, 226238, 361186, 226215, 361183, 226210, 105804, 105802, 131785, 131783, 361144, 105800, 226192, 360217, 131781, 360215, 105794, 131779, 360850, 360847, 360212, 360210, 360261, 360259, 359740, 360228, 360207, 360222, 360219, 360204, 358259, 358255, 358253, 358251, 358972, 358234, 358967, 358232, 358230, 359150, 358227, 358223, 358480, 358473, 358213, 358471, 358468, 358768, 358465, 358554, 358611, 358539, 358454, 358449, 358446, 357428, 358441, 358103, 357705, 357427, 357426, 356190, 131764, 131762, 131759, 156896, 356187, 356186, 356185, 353374, 354625, 354235, 354233, 225572, 225566, 354232, 354230, 354219, 354043, 105537, 352838, 352836, 315989, 352827, 352822, 349335, 351685, 351908, 225406, 225404, 225397, 351758, 351906, 346527, 351905, 346526, 351060, 351342, 131723, 131719, 350495, 350374, 131716, 131710, 350491, 131705, 131702, 156237, 131697, 205274, 349923, 347675, 348582, 349736, 349717, 348571, 348568, 348557, 131663, 225159, 225156, 205260, 205257, 131617, 346524, 346523, 205252, 345537, 345536, 345262, 344710, 345202, 345200, 344705, 345182, 344694, 344691, 344686, 338956, 338954, 338952, 224963, 224955, 343973, 343971, 344024, 343865, 343529, 343668, 343666, 343664, 343521, 343461, 314986, 342578, 342586, 343006, 343252, 341624, 117631, 343046, 340677, 340666, 329891, 329889, 342562, 342582, 337665, 341827, 341571, 105337, 341563, 341429, 340865, 340862, 294014, 294002, 329876, 340211, 340205, 340199, 336786, 340193, 336780, 340180, 333086, 338841, 338839, 329871, 339866, 339680, 339614, 339662, 339656, 339611, 338932, 339395, 336765, 338038, 205220, 338922, 339070, 338647, 205208, 338032, 329863, 205190, 337375, 224525, 337754, 337976, 329861, 55201, 205171, 336954, 336760, 337430, 336757, 337114, 337357, 337103, 336755, 336753, 337097, 337096, 336751, 336904, 336902, 336897, 336744, 336740, 336730, 336054, 336403, 128911, 336052, 333034, 205147, 331667, 331663, 195994, 329852, 195991, 330628, 332287, 335497, 335715, 335575, 335567, 335492, 335437, 335558, 131526, 131524, 334968, 334884, 329826, 334266, 334725, 334262, 334260, 334700, 331473, 333084, 333079, 333075, 332739, 105118, 332734, 332796, 292084, 329815, 295903, 329813, 128883, 326888, 327104, 328214, 181427, 181425, 181424, 331196, 331182, 331021, 105056, 328890, 328873, 303592, 327669, 327793, 205110, 327418, 327527, 325578, 327473, 327460, 327459, 131478, 205096, 205094, 326978, 264085, 264083, 326457, 264074, 326453, 264071, 224021, 224020, 224011, 224006, 315372, 205085, 211107, 325581, 314385, 180205, 211030, 304708, 304706, 304700, 304694, 205075, 205072, 105024, 180183, 320122, 180180, 180178, 105003, 104981, 195848, 303916, 303913, 319198, 318633, 317457, 318442, 205069, 317028, 317450, 317448, 316080, 317026, 316078, 317430, 317427, 317421, 205063, 312049, 317403, 317402, 316075, 316925, 316727, 180058, 315518, 313451, 313450, 314983, 315363, 314978, 314976, 314973, 314964, 314895, 180049, 180048, 314957, 193462, 180035, 131438, 313773, 304668, 304666, 313459, 313294, 313292, 312732, 312729, 312399, 312127, 312124, 312462, 312455, 312097, 311866, 311764, 311452, 311450, 223427, 301184, 301182, 223425, 223423, 310357, 310356, 310354, 306667, 310348, 310345, 306662, 306660, 308131, 307402, 308288, 306654, 306650, 306647, 306634, 306622, 306619, 258498, 306609, 306602, 307181, 307025, 307023, 307020, 307018, 306597, 306593, 306363, 304163, 304155, 305283, 304947, 304657, 304653, 304645, 304641, 304638, 301706, 303964, 302594, 210380, 302592, 303660, 303654, 302965, 210303, 179840, 160782, 160780, 160778, 160776, 301574, 267896, 301672, 301670, 267893, 267888, 301663, 301165, 301164, 301456, 301453, 301261, 301258, 301450, 301245, 267880, 301048, 298711, 298709, 300978, 301040, 301037, 300975, 300970, 300944, 300942, 298807, 300517, 300515, 300513, 205038, 299148, 299211, 299140, 297653, 104740, 298308, 297472, 297467, 298306, 298260, 298304, 297557, 295323, 291965, 291962, 295315, 279648, 295309, 295307, 295304, 295291, 295289, 295267, 295264, 295241, 295234, 295211, 295064, 295054, 195688, 295052, 295180, 295178, 295170, 295168, 295026, 294913, 294756, 294590, 294659, 294657, 294577, 293899, 131331, 291614, 131321, 131318, 131317, 204994, 104688, 104686, 131308, 291197, 292505, 292494, 292868, 292491, 292483, 292173, 292158, 291682, 292153, 292128, 291680, 292126, 291677, 291675, 291573, 291042, 290926, 291034, 291028, 289952, 290924, 289949, 289942, 289934, 289929, 290318, 289226, 290311, 290304, 290159, 289927, 290043, 289700, 289214, 289204, 289195, 289193, 289180, 288866, 288615, 288606, 288602, 131277, 282966, 284193, 285769, 285761, 285746, 285038, 285035, 285406, 284618, 284973, 284616, 284614, 284632, 270483, 104486, 284191, 284343, 284189, 284183, 283748, 283743, 283741, 284167, 282901, 283229, 282892, 282890, 283227, 282887, 282879, 279364, 279124, 277524, 277135, 277522, 277550, 277505, 274821, 274817, 271165, 272077, 259706, 259701, 271289, 271286, 271284, 155454, 155452, 207485, 268213, 179128, 270336, 179124, 179117, 179115, 268597, 178866, 257110, 206508, 269130, 269116, 178736, 268326, 268270, 268267, 268265, 268263, 154968, 267662, 267651, 267647, 264687, 267723, 267721, 267719, 266980, 266684, 51287, 178418, 178386, 178358, 178342, 266381, 178317, 178310, 178302, 178285, 178038, 257418, 265007, 265000, 177945, 264894, 264885, 177936, 177934, 263719, 177733, 261980, 318858, 177725, 204962, 177695, 177690, 177688, 262941, 177636, 177633, 261978, 318856, 262507, 262367, 262362, 262265, 82192, 82187, 261719, 261716, 261713, 177519, 177498, 261705, 259659, 261459, 261438, 177392, 261358, 177389, 260212, 260661, 177294, 177285, 177253, 177244, 260431, 258394, 260097, 177205, 177199, 177191, 258815, 177162, 259860, 177160, 177143, 258791, 259853, 177137, 177106, 259276, 259269, 177089, 259264, 259262, 177076, 104049, 177044, 177040, 177038, 258967, 177036, 258007, 258003, 258432, 258429, 258547, 258483, 258516, 258425, 258140, 176920, 257585, 257466, 257315, 257973, 204621, 257799, 184612, 184610, 257008, 256987, 155247, 256889, 255883, 256803, 256569, 130948, 247795, 255358, 130910, 130903, 130899, 255434, 130869, 204907, 130855, 130845, 130838, 176708, 130828, 255074, 255071, 255069, 130825, 254978, 254975, 254811, 254807, 254410, 176663, 176627, 176612, 250853, 250851, 249769, 250842, 250839, 248601, 117514, 248749, 250457, 249553, 249542, 249754, 249537, 249633, 249533, 249528, 249520, 249516, 208367, 207794, 207791, 207776, 207748, 103802, 103793, 192646, 207187, 207183, 207176, 206811, 182525, 182523, 206805, 204166, 181622, 204897, 191283, 176303, 204011, 202413, 176291, 176289, 203220, 203251, 203124, 202826, 202399, 202093, 202083, 202081, 202077, 176285, 190672, 193159, 193155, 194610, 195286, 193144, 155447, 155445, 186876, 175944, 175934, 185836, 175924, 174552, 185093, 162283, 185108, 185106, 184913, 175878, 182224, 175872, 184816, 137700, 175850, 175667, 182222, 182817, 182685, 181290, 181286, 181283, 175820, 181278, 175805, 175786, 181878, 181270, 181579, 181268, 181567, 181672, 181385, 175745, 175738, 175187, 173665, 175322, 175162, 137650, 175237, 175151, 174100, 174516, 173743, 174505, 174501, 174089, 174057, 174419, 174774, 155421, 174055, 174074, 174071, 173976, 173853, 173826, 173014, 173597, 171922, 130650, 130648, 130646, 172978, 130629, 172393, 172440, 171471, 171489, 171486, 155417, 155415, 170977, 171467, 171483, 130611, 171111, 171161, 170966, 170592, 170331, 170321, 164587, 164586, 164573, 156820, 164570, 164566, 168759, 168757, 167485, 167483, 167480, 168136, 164556, 167404, 167518, 167397, 167328, 167325, 154958, 162396, 155965, 159192, 155960, 159078, 159819, 158210, 156667, 156087, 156085, 156356, 154948, 154544, 153222, 152592, 152581, 152575, 152568, 82161, 146701, 146919, 147053, 146172, 146168, 143759, 145152, 144911, 143744, 144838, 125055, 142199, 137239, 141886, 139722, 139720, 138442, 140385, 140380, 140060, 139702, 140052, 140050, 140048, 140041, 140030, 122911, 122905, 139685, 139682, 138658, 139408, 139406, 139310, 138647, 138448, 122879, 137757, 130476, 135449, 135441, 134916, 134599, 128506, 134043, 128486, 130385, 130381, 130379, 130374, 130068, 129105, 127601, 126294, 126287, 126285, 125041, 125039, 125237, 125338, 117159, 118538, 123861, 123856, 123172, 123476, 123082, 122813, 80062, 121398, 119032, 116116, 97481, 97478, 111610, 112168, 111605, 111765, 111703, 111701, 111595, 109323, 110849, 109540, 103088, 102691, 102689, 102751, 101658, 99068, 99062, 98730, 98335, 93551, 89250, 88840, 88392, 87994, 88044, 87517, 87143, 87133, 87130, 87118, 85867, 86141, 85864, 85861, 85844, 80040))
Run Time: 0.099970
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1935 | |
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 | | | | | 1935 | |
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 (30658, 30319, 30108, 29955, 29962, 28798, 25422, 24932, 24207, 23678, 21462, 20625, 20590, 20378, 19806, 19756, 19748, 19325, 18843, 18008, 17861, 17836, 17773, 17761, 17692, 17551, 17220, 17053, 16888, 16794, 16059, 15679, 15656, 15296, 15182, 14578, 14543, 14515, 14437, 14238, 14074, 13740, 13684, 12900, 12553, 11540, 11383, 10393, 10013, 8978, 7875))
Run Time: 0.007224
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 51 | 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 (586603, 586602, 586598, 585268, 584387, 541697, 541696, 541694, 541692, 271975, 570846, 577612, 376416, 376415, 576171, 413819, 571150, 571148, 417886, 417883, 417879, 517362, 571307, 571301, 480344, 569500, 570824, 389236, 571299, 398480, 571841, 398478, 398475, 571297, 571668, 571666, 206112, 206110, 571292, 380922, 380915, 571145, 571143, 380909, 380905, 569937, 417967, 569925, 371888, 547143, 547140, 547138, 547136, 547134, 371859, 546984, 564038, 483386, 412315, 133087, 431694, 412299, 244399, 244398, 412296, 561507, 549833, 431672, 431671, 559039, 536678, 536482, 380683, 429978, 380680, 545912, 380661, 380653, 545669, 380636, 380626, 380618, 413790, 429723, 536561, 537879, 514043, 243966, 243906, 451726, 526767, 414861, 485546, 414857, 414853, 362429, 362426, 380525, 367423, 108584, 243773, 243742, 243740, 243737, 243732, 243728, 243726, 518040, 518038, 380516, 522792, 243694, 243691, 243607, 380500, 619651, 500136, 205844, 243377, 500130, 413761, 501654, 413759, 380370, 500127, 242965, 242958, 492831, 349516, 242793, 486965, 349512, 242732, 485120, 108003, 108001, 485117, 474271, 230657, 484204, 230653, 618523, 389144, 484191, 484232, 199115, 470841, 484155, 242500, 371686, 242497, 448630, 483877, 483873, 483221, 483210, 482715, 482710, 482580, 242446, 242443, 242439, 242411, 242410, 242227, 475128, 205745, 475127, 205740, 205720, 241919, 241654, 241652, 241578, 241555, 241506, 241489, 457914, 241487, 241437, 241389, 241384, 241351, 229627, 241345, 229576, 454957, 241321, 454357, 454352, 453091, 453869, 453941, 453082, 453937, 453930, 453925, 453865, 411500, 411498, 411497, 453077, 453062, 330124, 359938, 371603, 359936, 241260, 359934, 452636, 452629, 452496, 452625, 452323, 414007, 132270, 198137, 452178, 452173, 452169, 317000, 403923, 403920, 403917, 216430, 448550, 417709, 412975, 330113, 450996, 448548, 205531, 205530, 404568, 404567, 449631, 449272, 449269, 449267, 449264, 449257, 107464, 107460, 359908, 448655, 107449, 241003, 205524, 107414, 415444, 415435, 421632, 422258, 421059, 420904, 420898, 420894, 421056, 420999, 421039, 421034, 420994, 419953, 419951, 419943, 415413, 415405, 415402, 415391, 419881, 415371, 419685, 310553, 107339, 419291, 418889, 418963, 418960, 418886, 418881, 419053, 418878, 240728, 418523, 418521, 417696, 414321, 414319, 418154, 417687, 417683, 417682, 417623, 417414, 416834, 240706, 414648, 240703, 404563, 197859, 330088, 132153, 375216, 389126, 416571, 416606, 416153, 416088, 216055, 415633, 240576, 415545, 107266, 107261, 415503, 415351, 415348, 132132, 413726, 132125, 414610, 414607, 414605, 414601, 414316, 240548, 414314, 413708, 413424, 197777, 413448, 413422, 380012, 413357, 380008, 413420, 380006, 413279, 413276, 411247, 411229, 411227, 107230, 413015, 411213, 412646, 412640, 411208, 411205, 206364, 206361, 411201, 206358, 411199, 405295, 409743, 409735, 405286, 362308, 362303, 362297, 362295, 362290, 405267, 405265, 240350, 405244, 371580, 371578, 405233, 405232, 405225, 405224, 405218, 405211, 405207, 240302, 409357, 409353, 408867, 409138, 240290, 240265, 240262, 240255, 240201, 240195, 240185, 408541, 240154, 240148, 402083, 407846, 400060, 205501, 407492, 240087, 240067, 240065, 240062, 240060, 240046, 407196, 407193, 406127, 406123, 406120, 406118, 240001, 240000, 397783, 400039, 239968, 239955, 406146, 107037, 171769, 171767, 404425, 197520, 405188, 405186, 405183, 405178, 405172, 405167, 405160, 405157, 405155, 405149, 405146, 400029, 404559, 404874, 404985, 404446, 404870, 404865, 404555, 239935, 404553, 404511, 404332, 367066, 404329, 404415, 402219, 403079, 239884, 403289, 403663, 403329, 403590, 403582, 403251, 403580, 403572, 403570, 403569, 403248, 300839, 402183, 239868, 239859, 132054, 239846, 205490, 402365, 239837, 402342, 402340, 367038, 402334, 402173, 402064, 239809, 239807, 402142, 239802, 239799, 402050, 239793, 401568, 239772, 396351, 205465, 401671, 239751, 362208, 401566, 362196, 362189, 239707, 239705, 362187, 239701, 239697, 400508, 239684, 239673, 205455, 239666, 239657, 239655, 239645, 401066, 400838, 401244, 400832, 399744, 132018, 362131, 399631, 398235, 397048, 205434, 399853, 399850, 399962, 399960, 399848, 399840, 398637, 398633, 239594, 399734, 239593, 398630, 398627, 322269, 398621, 397703, 337148, 337145, 399499, 397143, 399454, 239554, 399428, 239545, 396339, 239541, 396336, 394714, 205403, 396332, 239468, 239434, 197194, 396316, 396783, 396811, 205387, 396772, 396771, 205370, 205369, 396297, 396292, 215187, 197148, 239393, 197139, 197137, 239389, 395707, 197127, 395697, 395694, 239387, 395838, 392884, 395680, 395678, 395478, 239361, 215148, 395435, 395432, 395430, 239346, 239333, 395358, 239330, 239329, 239328, 239325, 393478, 23385, 328252, 328248, 131920, 394426, 394355, 393471, 394194, 394189, 394159, 378298, 394156, 393622, 394154, 239259, 394036, 239250, 393466, 197036, 392446, 378291, 393460, 366995, 393457, 393620, 239241, 392668, 392666, 392274, 392396, 392270, 392650, 392264, 239200, 392261, 392256, 392300, 391645, 392050, 391643, 391640, 239126, 391631, 239115, 391382, 390331, 389123, 389116, 389113, 349461, 388556, 346529, 387517, 366984, 366982, 387229, 358346, 387254, 387224, 386897, 386577, 386523, 386493, 386478, 386475, 386489, 378284, 238793, 366979, 386115, 227430, 386111, 227424, 227419, 227416, 227415, 385179, 385237, 384538, 238668, 384752, 376084, 384748, 384878, 384876, 384537, 384036, 349455, 384341, 330032, 330030, 371472, 383438, 384029, 238558, 383654, 384027, 384020, 383436, 366948, 227319, 227314, 383509, 366944, 383507, 383504, 383108, 366940, 383499, 383492, 383105, 382057, 383011, 383346, 383341, 382688, 383133, 382685, 371471, 383008, 383000, 383088, 382679, 382677, 382676, 382672, 382463, 382005, 381641, 366927, 381234, 379841, 379776, 379828, 379774, 379772, 379640, 366921, 379030, 378842, 378839, 378720, 378529, 377064, 238359, 376355, 376695, 376352, 376350, 376346, 376342, 376688, 376685, 377303, 376680, 376679, 376339, 376918, 376336, 376335, 376333, 376915, 376913, 374635, 376983, 375729, 376330, 376329, 376673, 376819, 376671, 376966, 376327, 375946, 375848, 376540, 196650, 376316, 376028, 375449, 375842, 375447, 345549, 374999, 374997, 374990, 374904, 374800, 374196, 363843, 214043, 214036, 372630, 214024, 106104, 366223, 372589, 371424, 330012, 330007, 367867, 330005, 371420, 371415, 371408, 329993, 371396, 362614, 362610, 362608, 362606, 362596, 362594, 364105, 329984, 329982, 369875, 362590, 369302, 369873, 369867, 369865, 369299, 237996, 237993, 237990, 237988, 369295, 329972, 369292, 369290, 329970, 258509, 314402, 368413, 368409, 366084, 366080, 367810, 180821, 180819, 180817, 180816, 180815, 180814, 367804, 365508, 365504, 331280, 365095, 365502, 331278, 105962, 365499, 237808, 237806, 365077, 365491, 329959, 363142, 226286, 285843, 361510, 213292, 361507, 361504, 361501, 309913, 361192, 226250, 226238, 361186, 226215, 361183, 226210, 105804, 105802, 131785, 131783, 361144, 105800, 226192, 360217, 131781, 360215, 105794, 131779, 360850, 360847, 360212, 360210, 360261, 360259, 359740, 360228, 360207, 360222, 360219, 360204, 358259, 358255, 358253, 358251, 358972, 358234, 358967, 358232, 358230, 359150, 358227, 358223, 358480, 358473, 358213, 358471, 358468, 358768, 358465, 358554, 358611, 358539, 358454, 358449, 358446, 357428, 358441, 358103, 357705, 357427, 357426, 356190, 131764, 131762, 131759, 156896, 356187, 356186, 356185, 353374, 354625, 354235, 354233, 225572, 225566, 354232, 354230, 354219, 354043, 105537, 352838, 352836, 315989, 352827, 352822, 349335, 351685, 351908, 225406, 225404, 225397, 351758, 351906, 346527, 351905, 346526, 351060, 351342, 131723, 131719, 350495, 350374, 131716, 131710, 350491, 131705, 131702, 156237, 131697, 205274, 349923, 347675, 348582, 349736, 349717, 348571, 348568, 348557, 131663, 225159, 225156, 205260, 205257, 131617, 346524, 346523, 205252, 345537, 345536, 345262, 344710, 345202, 345200, 344705, 345182, 344694, 344691, 344686, 338956, 338954, 338952, 224963, 224955, 343973, 343971, 344024, 343865, 343529, 343668, 343666, 343664, 343521, 343461, 314986, 342578, 342586, 343006, 343252, 341624, 117631, 343046, 340677, 340666, 329891, 329889, 342562, 342582, 337665, 341827, 341571, 105337, 341563, 341429, 340865, 340862, 294014, 294002, 329876, 340211, 340205, 340199, 336786, 340193, 336780, 340180, 333086, 338841, 338839, 329871, 339866, 339680, 339614, 339662, 339656, 339611, 338932, 339395, 336765, 338038, 205220, 338922, 339070, 338647, 205208, 338032, 329863, 205190, 337375, 224525, 337754, 337976, 329861, 55201, 205171, 336954, 336760, 337430, 336757, 337114, 337357, 337103, 336755, 336753, 337097, 337096, 336751, 336904, 336902, 336897, 336744, 336740, 336730, 336054, 336403, 128911, 336052, 333034, 205147, 331667, 331663, 195994, 329852, 195991, 330628, 332287, 335497, 335715, 335575, 335567, 335492, 335437, 335558, 131526, 131524, 334968, 334884, 329826, 334266, 334725, 334262, 334260, 334700, 331473, 333084, 333079, 333075, 332739, 105118, 332734, 332796, 292084, 329815, 295903, 329813, 128883, 326888, 327104, 328214, 181427, 181425, 181424, 331196, 331182, 331021, 105056, 328890, 328873, 303592, 327669, 327793, 205110, 327418, 327527, 325578, 327473, 327460, 327459, 131478, 205096, 205094, 326978, 264085, 264083, 326457, 264074, 326453, 264071, 224021, 224020, 224011, 224006, 315372, 205085, 211107, 325581, 314385, 180205, 211030, 304708, 304706, 304700, 304694, 205075, 205072, 105024, 180183, 320122, 180180, 180178, 105003, 104981, 195848, 303916, 303913, 319198, 318633, 317457, 318442, 205069, 317028, 317450, 317448, 316080, 317026, 316078, 317430, 317427, 317421, 205063, 312049, 317403, 317402, 316075, 316925, 316727, 180058, 315518, 313451, 313450, 314983, 315363, 314978, 314976, 314973, 314964, 314895, 180049, 180048, 314957, 193462, 180035, 131438, 313773, 304668, 304666, 313459, 313294, 313292, 312732, 312729, 312399, 312127, 312124, 312462, 312455, 312097, 311866, 311764, 311452, 311450, 223427, 301184, 301182, 223425, 223423, 310357, 310356, 310354, 306667, 310348, 310345, 306662, 306660, 308131, 307402, 308288, 306654, 306650, 306647, 306634, 306622, 306619, 258498, 306609, 306602, 307181, 307025, 307023, 307020, 307018, 306597, 306593, 306363, 304163, 304155, 305283, 304947, 304657, 304653, 304645, 304641, 304638, 301706, 303964, 302594, 210380, 302592, 303660, 303654, 302965, 210303, 179840, 160782, 160780, 160778, 160776, 301574, 267896, 301672, 301670, 267893, 267888, 301663, 301165, 301164, 301456, 301453, 301261, 301258, 301450, 301245, 267880, 301048, 298711, 298709, 300978, 301040, 301037, 300975, 300970, 300944, 300942, 298807, 300517, 300515, 300513, 205038, 299148, 299211, 299140, 297653, 104740, 298308, 297472, 297467, 298306, 298260, 298304, 297557, 295323, 291965, 291962, 295315, 279648, 295309, 295307, 295304, 295291, 295289, 295267, 295264, 295241, 295234, 295211, 295064, 295054, 195688, 295052, 295180, 295178, 295170, 295168, 295026, 294913, 294756, 294590, 294659, 294657, 294577, 293899, 131331, 291614, 131321, 131318, 131317, 204994, 104688, 104686, 131308, 291197, 292505, 292494, 292868, 292491, 292483, 292173, 292158, 291682, 292153, 292128, 291680, 292126, 291677, 291675, 291573, 291042, 290926, 291034, 291028, 289952, 290924, 289949, 289942, 289934, 289929, 290318, 289226, 290311, 290304, 290159, 289927, 290043, 289700, 289214, 289204, 289195, 289193, 289180, 288866, 288615, 288606, 288602, 131277, 282966, 284193, 285769, 285761, 285746, 285038, 285035, 285406, 284618, 284973, 284616, 284614, 284632, 270483, 104486, 284191, 284343, 284189, 284183, 283748, 283743, 283741, 284167, 282901, 283229, 282892, 282890, 283227, 282887, 282879, 279364, 279124, 277524, 277135, 277522, 277550, 277505, 274821, 274817, 271165, 272077, 259706, 259701, 271289, 271286, 271284, 155454, 155452, 207485, 268213, 179128, 270336, 179124, 179117, 179115, 268597, 178866, 257110, 206508, 269130, 269116, 178736, 268326, 268270, 268267, 268265, 268263, 154968, 267662, 267651, 267647, 264687, 267723, 267721, 267719, 266980, 266684, 51287, 178418, 178386, 178358, 178342, 266381, 178317, 178310, 178302, 178285, 178038, 257418, 265007, 265000, 177945, 264894, 264885, 177936, 177934, 263719, 177733, 261980, 318858, 177725, 204962, 177695, 177690, 177688, 262941, 177636, 177633, 261978, 318856, 262507, 262367, 262362, 262265, 82192, 82187, 261719, 261716, 261713, 177519, 177498, 261705, 259659, 261459, 261438, 177392, 261358, 177389, 260212, 260661, 177294, 177285, 177253, 177244, 260431, 258394, 260097, 177205, 177199, 177191, 258815, 177162, 259860, 177160, 177143, 258791, 259853, 177137, 177106, 259276, 259269, 177089, 259264, 259262, 177076, 104049, 177044, 177040, 177038, 258967, 177036, 258007, 258003, 258432, 258429, 258547, 258483, 258516, 258425, 258140, 176920, 257585, 257466, 257315, 257973, 204621, 257799, 184612, 184610, 257008, 256987, 155247, 256889, 255883, 256803, 256569, 130948, 247795, 255358, 130910, 130903, 130899, 255434, 130869, 204907, 130855, 130845, 130838, 176708, 130828, 255074, 255071, 255069, 130825, 254978, 254975, 254811, 254807, 254410, 176663, 176627, 176612, 250853, 250851, 249769, 250842, 250839, 248601, 117514, 248749, 250457, 249553, 249542, 249754, 249537, 249633, 249533, 249528, 249520, 249516, 208367, 207794, 207791, 207776, 207748, 103802, 103793, 192646, 207187, 207183, 207176, 206811, 182525, 182523, 206805, 204166, 181622, 204897, 191283, 176303, 204011, 202413, 176291, 176289, 203220, 203251, 203124, 202826, 202399, 202093, 202083, 202081, 202077, 176285, 190672, 193159, 193155, 194610, 195286, 193144, 155447, 155445, 186876, 175944, 175934, 185836, 175924, 174552, 185093, 162283, 185108, 185106, 184913, 175878, 182224, 175872, 184816, 137700, 175850, 175667, 182222, 182817, 182685, 181290, 181286, 181283, 175820, 181278, 175805, 175786, 181878, 181270, 181579, 181268, 181567, 181672, 181385, 175745, 175738, 175187, 173665, 175322, 175162, 137650, 175237, 175151, 174100, 174516, 173743, 174505, 174501, 174089, 174057, 174419, 174774, 155421, 174055, 174074, 174071, 173976, 173853, 173826, 173014, 173597, 171922, 130650, 130648, 130646, 172978, 130629, 172393, 172440, 171471, 171489, 171486, 155417, 155415, 170977, 171467, 171483, 130611, 171111, 171161, 170966, 170592, 170331, 170321, 164587, 164586, 164573, 156820, 164570, 164566, 168759, 168757, 167485, 167483, 167480, 168136, 164556, 167404, 167518, 167397, 167328, 167325, 154958, 162396, 155965, 159192, 155960, 159078, 159819, 158210, 156667, 156087, 156085, 156356, 154948, 154544, 153222, 152592, 152581, 152575, 152568, 82161, 146701, 146919, 147053, 146172, 146168, 143759, 145152, 144911, 143744, 144838, 125055, 142199, 137239, 141886, 139722, 139720, 138442, 140385, 140380, 140060, 139702, 140052, 140050, 140048, 140041, 140030, 122911, 122905, 139685, 139682, 138658, 139408, 139406, 139310, 138647, 138448, 122879, 137757, 130476, 135449, 135441, 134916, 134599, 128506, 134043, 128486, 130385, 130381, 130379, 130374, 130068, 129105, 127601, 126294, 126287, 126285, 125041, 125039, 125237, 125338, 117159, 118538, 123861, 123856, 123172, 123476, 123082, 122813, 80062, 121398, 119032, 116116, 97481, 97478, 111610, 112168, 111605, 111765, 111703, 111701, 111595, 109323, 110849, 109540, 103088, 102691, 102689, 102751, 101658, 99068, 99062, 98730, 98335, 93551, 89250, 88840, 88392, 87994, 88044, 87517, 87143, 87133, 87130, 87118, 85867, 86141, 85864, 85861, 85844, 80040))
Run Time: 0.048288
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1935 | |
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 | | | | | 1935 | |
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 (30658, 30319, 30108, 29955, 29962, 28798, 25422, 24932, 24207, 23678, 21462, 20625, 20590, 20378, 19806, 19756, 19748, 19325, 18843, 18008, 17861, 17836, 17773, 17761, 17692, 17551, 17220, 17053, 16888, 16794, 16059, 15679, 15656, 15296, 15182, 14578, 14543, 14515, 14437, 14238, 14074, 13740, 13684, 12900, 12553, 11540, 11383, 10393, 10013, 8978, 7875))
Run Time: 0.002397
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 51 | 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.000218
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.000311
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.000553
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: 1716191393
Run Time: 0.000332
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 13 | 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` >= 1716191393)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000553
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 13 | 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