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.000560
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.000188
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` = '1053')
LIMIT 1
Run Time: 0.000401
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.002200
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_1053' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.045169
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 (215599, 379761, 238524, 382492, 382490, 382487, 377428, 382485, 106349, 382453, 382358, 106347, 238512, 382356, 238510, 227263, 227261, 227259, 227258, 377423, 377421, 381705, 381703, 106338, 361326, 106337, 361323, 361322, 381183, 379485, 361318, 361315, 377579, 377417, 374224, 106297, 106294, 106293, 106289, 377415, 373680, 325742, 324203, 373677, 373673, 373671, 373669, 373664, 373660, 362083, 362016, 362015, 106045, 368881, 361306, 361300, 369368, 361298, 368879, 368878, 361296, 361288, 365978, 361284, 363452, 363342, 361283, 361276, 361267, 361264, 361262, 361250, 363339, 363336, 361249, 363440, 363333, 363284, 265441, 265440, 363330, 363282, 361244, 363321, 363312, 361242, 363280, 363267, 363266, 363262, 361161, 361156, 361155, 361154, 361234, 361152, 361228, 361226, 361904, 361926, 361223, 105865, 361901, 105862, 105860, 105851, 105849, 105844, 105840, 105837, 105835, 359753, 361737, 361735, 361219, 361218, 357290, 361377, 361216, 361214, 361212, 361210, 361207, 361205, 361204, 360379, 361202, 361191, 361190, 361188, 361185, 361181, 361179, 361177, 361173, 361170, 357657, 357646, 357644, 357642, 357641, 356433, 354201, 357151, 356380, 354829, 225665, 212837, 354827, 355383, 212824, 225654, 225651, 354824, 354822, 212819, 354820, 343636, 343635, 180681, 180680, 343634, 354188, 212815, 354816, 354186, 225643, 225641, 212812, 225639, 266854, 225637, 225633, 225631, 225629, 225628, 355309, 225623, 225620, 225618, 348838, 348834, 353300, 348833, 348832, 352916, 348830, 348829, 348828, 348826, 348824, 348823, 348814, 348812, 348809, 353578, 348802, 348800, 348798, 352913, 348795, 348794, 105577, 105573, 354064, 353941, 354062, 354320, 348792, 352909, 105572, 352905, 353939, 354047, 352902, 354012, 350536, 353826, 353808, 351951, 348790, 348788, 345849, 105532, 348786, 348784, 345846, 352894, 353633, 59836, 105529, 294175, 353567, 353619, 353618, 353616, 353614, 353612, 353610, 353608, 353606, 353601, 353599, 353563, 353558, 105516, 343236, 105514, 294165, 353523, 352891, 353437, 352887, 352884, 352882, 352874, 352994, 352868, 350275, 352607, 351840, 331241, 351838, 351682, 261204, 324159, 351833, 351831, 351928, 351926, 351821, 324156, 351516, 351820, 351828, 351826, 351818, 351817, 331238, 345843, 338591, 344471, 332838, 324155, 350272, 350126, 351367, 277436, 277431, 277428, 350639, 327147, 350493, 345839, 350813, 350243, 350420, 350238, 350412, 324151, 350230, 350140, 349659, 225184, 348905, 345998, 345993, 345991, 345989, 345987, 345985, 345984, 345983, 345982, 345980, 345979, 345978, 345976, 345975, 345974, 345971, 155124, 346605, 345837, 337915, 345968, 345967, 345964, 345963, 344979, 345831, 344990, 344989, 273842, 329553, 343632, 343879, 343878, 343629, 343627, 344275, 343626, 343616, 343512, 343508, 343611, 343876, 196102, 196101, 322789, 322788, 322787, 343874, 343607, 343539, 343870, 343601, 343536, 343599, 343534, 343595, 343592, 343584, 343505, 343359, 343504, 343501, 343454, 343452, 343206, 98790, 315496, 343174, 343204, 342573, 340661, 340468, 338889, 337905, 313653, 313650, 277344, 313645, 330566, 330564, 329448, 331662, 29996, 335060, 332554, 327281, 327270, 332120, 332117, 277306, 327885, 327261, 328462, 331048, 328020, 105080, 288800, 224110, 224108, 328675, 328669, 328132, 325646, 211149, 327727, 327725, 307638, 307637, 327252, 327249, 327246, 224030, 326874, 224028, 223986, 223955, 223922, 223917, 321342, 321339, 317549, 312050, 317024, 316809, 307550, 317091, 288795, 316975, 194510, 316885, 307544, 210882, 316882, 316806, 307541, 193389, 307539, 316717, 316304, 316295, 315502, 277288, 277283, 223596, 313972, 223587, 311224, 223572, 313626, 313665, 277670, 313339, 308354, 313325, 308343, 312140, 308341, 312047, 311979, 307535, 312254, 307533, 312045, 307528, 312198, 312087, 311790, 312043, 311942, 312042, 311967, 311963, 311961, 223451, 311605, 223444, 307517, 258501, 307514, 307512, 307510, 303587, 258499, 310676, 311599, 307508, 307506, 311596, 311588, 311316, 311312, 279048, 310673, 279044, 307701, 307495, 310671, 310669, 310667, 310665, 307493, 310663, 307636, 307488, 308315, 308314, 307362, 307622, 305476, 307275, 305468, 305466, 306816, 305820, 306813, 305156, 307015, 614316, 307005, 614314, 307003, 302981, 614312, 614309, 283280, 306723, 283277, 305815, 614307, 614306, 305813, 614304, 306810, 306808, 306806, 305810, 305843, 305808, 305838, 305835, 305833, 305831, 305806, 305805, 305827, 305825, 305803, 305823, 305801, 253268, 303967, 303962, 303960, 303959, 303569, 301655, 303567, 303663, 303648, 299519, 297658, 299292, 289309, 297650, 297648, 297646, 297644, 297642, 297206, 297473, 298690, 297204, 297202, 297200, 297198, 297195, 297595, 297193, 297192, 297190, 297188, 297186, 297185, 297183, 183041, 296419, 294612, 295994, 295991, 183037, 294558, 183033, 183031, 294725, 295084, 295480, 295078, 295477, 295074, 295462, 295066, 295061, 295059, 295058, 295050, 295043, 294721, 295041, 295037, 295033, 294935, 294719, 294718, 294715, 294924, 294097, 294713, 294709, 294706, 294705, 294703, 294696, 294694, 294552, 294551, 294565, 292177, 292166, 292165, 292136, 292135, 292132, 292131, 292124, 287988, 287987, 287984, 104667, 288259, 291670, 288256, 288255, 291667, 291665, 288237, 291663, 288234, 288231, 104655, 290388, 290387, 104651, 288228, 104637, 104634, 288226, 290385, 288221, 288220, 290383, 290380, 288215, 104632, 290377, 290374, 290372, 290370, 290984, 290978, 290360, 104596, 290357, 290346, 289243, 289240, 288860, 223116, 23265, 223112, 223109, 288213, 288211, 283753, 288209, 223105, 183026, 223100, 183023, 288591, 288590, 104552, 285916, 285913, 285911, 77371, 278970, 283271, 256307, 284197, 77369, 261060, 284169, 283752, 280007, 261052, 278961, 279149, 279147, 279145, 279140, 277966, 277965, 277960, 277959, 277955, 278850, 277946, 278848, 277659, 261041, 279002, 277942, 277655, 278980, 193356, 278952, 277653, 277649, 193354, 193353, 277646, 277644, 277643, 277932, 278842, 277254, 277930, 277252, 261032, 278119, 193351, 277924, 277240, 193345, 278112, 277238, 277921, 277236, 277232, 277229, 277222, 277216, 277914, 277210, 277912, 277201, 193340, 277909, 277894, 277529, 277640, 277197, 193337, 277890, 278158, 278103, 277191, 277190, 278100, 277638, 277621, 277507, 255735, 277614, 255734, 277609, 273257, 277606, 277604, 277187, 277496, 255727, 277185, 277183, 255725, 277181, 277180, 273796, 277175, 273795, 273254, 273249, 273247, 273792, 273240, 273764, 273755, 273754, 273749, 273748, 273747, 273745, 273742, 273740, 273738, 263966, 263963, 270980, 276396, 273736, 273735, 273731, 273728, 273709, 273708, 273704, 273703, 273699, 273696, 273694, 273680, 274818, 273678, 273676, 273674, 273670, 274122, 274120, 273668, 179315, 274816, 274783, 274781, 274779, 274815, 274777, 179309, 274117, 179306, 179305, 273653, 273651, 273650, 273646, 273641, 273639, 273637, 274114, 274112, 273634, 274065, 274110, 272950, 273630, 273629, 273628, 273626, 273624, 273622, 273618, 273610, 273608, 273606, 273602, 273581, 273578, 273577, 273576, 274082, 273550, 272948, 273233, 273230, 273228, 273221, 273212, 273207, 273205, 266825, 266821, 270071, 266818, 266809, 266806, 209595, 271934, 267826, 266805, 271605, 271602, 266801, 266798, 266795, 266791, 270888, 271233, 206511, 270868, 206509, 271228, 271226, 270866, 271224, 271222, 271220, 271219, 271217, 270859, 270857, 270840, 270839, 270838, 270431, 270414, 266788, 270337, 270334, 270333, 191688, 191686, 262068, 269257, 257138, 270330, 270410, 257136, 270406, 267031, 270397, 257131, 257129, 257125, 256496, 207404, 257123, 257121, 270029, 263955, 270026, 270023, 270157, 270155, 188343, 270012, 270010, 270008, 268574, 268572, 175388, 267749, 266985, 266217, 265027, 265025, 265021, 265019, 265017, 207393, 265014, 265012, 265009, 265008, 265002, 264932, 258250, 263735, 264588, 262151, 262138, 194044, 262931, 264147, 262927, 263725, 247565, 262925, 262922, 209283, 209281, 262918, 209278, 262946, 263205, 263201, 263200, 262945, 261802, 256735, 204415, 182511, 206784, 182506, 194258, 182502, 194254, 194253, 203717, 194247, 182500, 201660, 202650, 140862, 194098, 202345, 192774, 140855, 195382, 182495, 182486, 194095, 194093, 194092, 193587, 192744, 103750, 192249, 192248, 192247, 615144, 192028, 191567, 191845, 166688, 191167, 190991, 191130, 191058, 158994, 191056, 191053, 190832, 190828, 190824, 190821, 190820, 190812, 190809, 190807, 190806, 190576, 190391, 189823, 189383, 189377, 189866, 189675, 189302, 189428, 189361, 189374, 189372, 189370, 188245, 188410, 188381, 188201, 172596, 187725, 187714, 187712, 186837, 186871, 186816, 186854, 186853, 186810, 186108, 185601, 185599, 185898, 185888, 185886, 185837, 185583, 185183, 185177, 183572, 181943, 182823, 182822, 181938, 168054, 168052, 168051, 182723, 170994, 182455, 181460, 182452, 182418, 182666, 182450, 182411, 182444, 182443, 182441, 182439, 182437, 182435, 182432, 182431, 182428, 182403, 181457, 182399, 103665, 182187, 103659, 103657, 103654, 103650, 181935, 181931, 181930, 181927, 181922, 181920, 181918, 181916, 181914, 181912, 181911, 181909, 181905, 181904, 181901, 175802, 175785, 181881, 175784, 181879, 181696, 155352, 181099, 175561, 175544, 175348, 175345, 175344, 175531, 175450, 175438, 175341, 173664, 175365, 175340, 173865, 173864, 175094, 175337, 175355, 175334, 140695, 175087, 165170, 173979, 173978, 165160, 174459, 174458, 165147, 173903, 173720, 173646, 172829, 173644, 173329, 141905, 173299, 141904, 168352, 171891, 168226, 171889, 171885, 170972, 170970, 170952, 170555, 128793, 170550, 170135, 170093, 168342, 168338, 169779, 168336, 130598, 169776, 169772, 168334, 168332, 162272, 162267, 168330, 169215, 168327, 168639, 168634, 169200, 169194, 169192, 169183, 168220, 168628, 168626, 168625, 168620, 168265, 167473, 167789, 167783, 166065, 166063, 166578, 166230, 166227, 164014, 163467, 163461, 163460, 164256, 163454, 163873, 154802, 161905, 163180, 161933, 160356, 159164, 158162, 155313, 156671, 155823, 155305, 155297, 155296, 155291, 153039, 153524, 153869, 152392, 153348, 153347, 152382, 150155, 148172, 147628, 147284, 146875, 146873, 145444, 88026, 88017, 138389, 142345, 141893, 143383, 129273, 126194, 124649, 124646, 124645, 124632, 122266, 124090, 124088, 123723, 124081, 118763, 123721, 123523, 118761, 118760, 118890, 116514, 113835, 103434, 103432, 103431, 103427, 113861, 113829, 111924, 111366, 102451, 100658, 99142, 99139, 99134, 96251, 97116, 93442, 95593, 89632, 89621, 89231, 89230, 92860, 89541, 89225, 89223, 89220, 86453, 87687, 87680, 86452, 86450, 85800, 85799, 85972, 85760, 84879, 85361, 84997, 84275, 83778, 83617, 83418, 83789, 83738, 83736, 83734, 83631, 83317, 83629, 83361, 77455, 83047, 83359, 83313, 83357, 83355, 83321, 83312, 83311, 82359, 83044, 82423, 81715, 81159, 81158, 81157, 81979, 82353, 82351, 81713, 81976, 80380, 80379, 81924, 82115, 82097, 82096, 81922, 81711, 81708, 80621, 80618, 79319, 79355, 79352, 78765, 78085, 78296, 78295, 76580, 76578, 75701, 74959, 74957, 74955, 74953, 73177, 72034, 71238, 71031, 70961, 71027, 70843, 70840, 60568, 66547, 65449, 65447, 65444, 65442, 66638, 65417, 65850, 65407, 65790, 65405, 65397, 65396, 65389, 64903, 65141, 32583, 62792, 32581, 62790, 59055, 64734, 32565, 59691, 59689, 63894, 63893, 59688, 63645, 63642, 63640, 63189, 63330, 55111, 55105, 55100, 63016, 62836, 55098, 62824, 62820, 59675, 59674, 62305, 59669, 61949, 61378, 61222, 61318, 61366, 61248, 61011, 59664, 32520, 59662, 32508, 60289, 32506, 60103, 32496, 58216, 58214, 58099, 57875, 57586, 57581, 56670, 57049, 56585, 56666, 56663, 56660, 56415, 55393, 51734, 55333, 55469, 55329, 54632, 54673, 53941, 53424, 53422, 53421, 49312, 49306, 49302, 49299, 53667, 53612, 53171, 53343, 53341, 52875, 53427, 53037, 52643, 47987, 52574, 51639, 52160, 51987, 51725, 51147, 51322, 51320, 48940, 50678, 50439, 50438, 47978, 49597, 49594, 49590, 49506, 39461, 49290, 49100, 48886, 49098, 48617, 48614, 47937, 47847, 47839, 47837, 47179, 47177, 47175, 47174, 47140, 47488, 37525, 47172, 47170, 47168, 47165, 47161, 47156, 47115, 32445, 32443, 46343, 37523, 38572, 43704, 32438, 32436, 38569, 45192, 46760, 46154, 46151, 46149, 46137, 46871, 46337, 46331, 46330, 46329, 46718, 46716, 46715, 46133, 46714, 46713, 46131, 46591, 40381, 40379, 45067, 45065, 46587, 45064, 46293, 45283, 46322, 46279, 46386, 46316, 46313, 46130, 46311, 46290, 46125, 46121, 46118, 45061, 45564, 45956, 45129, 45026, 44825, 41175, 43960, 43363, 41172, 41168, 41417, 42375, 41415, 41413, 41411, 41405, 41166, 41165, 41163, 40372, 40288, 40286, 40347, 39933, 39716, 39712, 39454, 39246, 39234, 38907, 38904, 38895, 37168, 38232, 37509, 37507, 37503, 37500, 37498, 37941, 36539, 36537, 36536, 37662, 37701, 37660, 37667, 36640, 37446, 37494, 37029, 37248, 37162, 37200, 37150, 37100, 36529, 36527, 36524, 36520, 36518, 36516, 36161, 36152, 36122, 34760, 34759, 35659, 21898, 35467, 35451, 35049, 33916, 33914, 34606, 34544, 33909, 32389, 32381, 32379, 32377, 32374, 32372, 32369, 33477, 33492, 32362, 32053, 32051, 32050, 32358, 32357, 32355, 33061, 32354, 32351, 32048, 30559, 30214, 30764, 30212, 26273, 30209))
Run Time: 0.065547
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1678 | |
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 | | | | | 1678 | |
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 (19184, 19181, 19091, 18923, 18715, 18157, 18149, 18146, 18106, 18105, 18063, 17857, 17851, 17811, 17775, 17768, 17619, 17604, 17589, 17546, 17412, 17202, 17146, 17067, 17050, 17045, 17042, 17019, 16657, 16359, 16226, 16221, 16162, 16159, 16134, 15970, 15764, 15751, 15687, 15497, 15322, 15276, 15259, 14777, 14648, 14646, 14634, 14633, 14567, 14542, 14509, 14436, 14333, 14292, 14202, 14160, 14128, 14068, 14031, 13959, 13894, 13878, 13864, 13600, 13552, 13210, 12557, 12233, 12204, 12111, 12090, 12009, 11949, 11936, 11833, 11710, 11691, 11661, 11603, 11513, 11390, 11278, 11270, 11237, 11197, 10764, 10541, 10476, 8718, 7682, 7424, 7244, 7240, 7184, 7144, 7075, 5711, 5657, 5517, 5136, 4811, 4782, 4511, 4489, 4469, 4347, 4303, 4242, 4218, 4207, 4182, 4121, 3843, 3816, 3517, 3340, 3294, 3033))
Run Time: 0.005325
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 118 | 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 (215599, 379761, 238524, 382492, 382490, 382487, 377428, 382485, 106349, 382453, 382358, 106347, 238512, 382356, 238510, 227263, 227261, 227259, 227258, 377423, 377421, 381705, 381703, 106338, 361326, 106337, 361323, 361322, 381183, 379485, 361318, 361315, 377579, 377417, 374224, 106297, 106294, 106293, 106289, 377415, 373680, 325742, 324203, 373677, 373673, 373671, 373669, 373664, 373660, 362083, 362016, 362015, 106045, 368881, 361306, 361300, 369368, 361298, 368879, 368878, 361296, 361288, 365978, 361284, 363452, 363342, 361283, 361276, 361267, 361264, 361262, 361250, 363339, 363336, 361249, 363440, 363333, 363284, 265441, 265440, 363330, 363282, 361244, 363321, 363312, 361242, 363280, 363267, 363266, 363262, 361161, 361156, 361155, 361154, 361234, 361152, 361228, 361226, 361904, 361926, 361223, 105865, 361901, 105862, 105860, 105851, 105849, 105844, 105840, 105837, 105835, 359753, 361737, 361735, 361219, 361218, 357290, 361377, 361216, 361214, 361212, 361210, 361207, 361205, 361204, 360379, 361202, 361191, 361190, 361188, 361185, 361181, 361179, 361177, 361173, 361170, 357657, 357646, 357644, 357642, 357641, 356433, 354201, 357151, 356380, 354829, 225665, 212837, 354827, 355383, 212824, 225654, 225651, 354824, 354822, 212819, 354820, 343636, 343635, 180681, 180680, 343634, 354188, 212815, 354816, 354186, 225643, 225641, 212812, 225639, 266854, 225637, 225633, 225631, 225629, 225628, 355309, 225623, 225620, 225618, 348838, 348834, 353300, 348833, 348832, 352916, 348830, 348829, 348828, 348826, 348824, 348823, 348814, 348812, 348809, 353578, 348802, 348800, 348798, 352913, 348795, 348794, 105577, 105573, 354064, 353941, 354062, 354320, 348792, 352909, 105572, 352905, 353939, 354047, 352902, 354012, 350536, 353826, 353808, 351951, 348790, 348788, 345849, 105532, 348786, 348784, 345846, 352894, 353633, 59836, 105529, 294175, 353567, 353619, 353618, 353616, 353614, 353612, 353610, 353608, 353606, 353601, 353599, 353563, 353558, 105516, 343236, 105514, 294165, 353523, 352891, 353437, 352887, 352884, 352882, 352874, 352994, 352868, 350275, 352607, 351840, 331241, 351838, 351682, 261204, 324159, 351833, 351831, 351928, 351926, 351821, 324156, 351516, 351820, 351828, 351826, 351818, 351817, 331238, 345843, 338591, 344471, 332838, 324155, 350272, 350126, 351367, 277436, 277431, 277428, 350639, 327147, 350493, 345839, 350813, 350243, 350420, 350238, 350412, 324151, 350230, 350140, 349659, 225184, 348905, 345998, 345993, 345991, 345989, 345987, 345985, 345984, 345983, 345982, 345980, 345979, 345978, 345976, 345975, 345974, 345971, 155124, 346605, 345837, 337915, 345968, 345967, 345964, 345963, 344979, 345831, 344990, 344989, 273842, 329553, 343632, 343879, 343878, 343629, 343627, 344275, 343626, 343616, 343512, 343508, 343611, 343876, 196102, 196101, 322789, 322788, 322787, 343874, 343607, 343539, 343870, 343601, 343536, 343599, 343534, 343595, 343592, 343584, 343505, 343359, 343504, 343501, 343454, 343452, 343206, 98790, 315496, 343174, 343204, 342573, 340661, 340468, 338889, 337905, 313653, 313650, 277344, 313645, 330566, 330564, 329448, 331662, 29996, 335060, 332554, 327281, 327270, 332120, 332117, 277306, 327885, 327261, 328462, 331048, 328020, 105080, 288800, 224110, 224108, 328675, 328669, 328132, 325646, 211149, 327727, 327725, 307638, 307637, 327252, 327249, 327246, 224030, 326874, 224028, 223986, 223955, 223922, 223917, 321342, 321339, 317549, 312050, 317024, 316809, 307550, 317091, 288795, 316975, 194510, 316885, 307544, 210882, 316882, 316806, 307541, 193389, 307539, 316717, 316304, 316295, 315502, 277288, 277283, 223596, 313972, 223587, 311224, 223572, 313626, 313665, 277670, 313339, 308354, 313325, 308343, 312140, 308341, 312047, 311979, 307535, 312254, 307533, 312045, 307528, 312198, 312087, 311790, 312043, 311942, 312042, 311967, 311963, 311961, 223451, 311605, 223444, 307517, 258501, 307514, 307512, 307510, 303587, 258499, 310676, 311599, 307508, 307506, 311596, 311588, 311316, 311312, 279048, 310673, 279044, 307701, 307495, 310671, 310669, 310667, 310665, 307493, 310663, 307636, 307488, 308315, 308314, 307362, 307622, 305476, 307275, 305468, 305466, 306816, 305820, 306813, 305156, 307015, 614316, 307005, 614314, 307003, 302981, 614312, 614309, 283280, 306723, 283277, 305815, 614307, 614306, 305813, 614304, 306810, 306808, 306806, 305810, 305843, 305808, 305838, 305835, 305833, 305831, 305806, 305805, 305827, 305825, 305803, 305823, 305801, 253268, 303967, 303962, 303960, 303959, 303569, 301655, 303567, 303663, 303648, 299519, 297658, 299292, 289309, 297650, 297648, 297646, 297644, 297642, 297206, 297473, 298690, 297204, 297202, 297200, 297198, 297195, 297595, 297193, 297192, 297190, 297188, 297186, 297185, 297183, 183041, 296419, 294612, 295994, 295991, 183037, 294558, 183033, 183031, 294725, 295084, 295480, 295078, 295477, 295074, 295462, 295066, 295061, 295059, 295058, 295050, 295043, 294721, 295041, 295037, 295033, 294935, 294719, 294718, 294715, 294924, 294097, 294713, 294709, 294706, 294705, 294703, 294696, 294694, 294552, 294551, 294565, 292177, 292166, 292165, 292136, 292135, 292132, 292131, 292124, 287988, 287987, 287984, 104667, 288259, 291670, 288256, 288255, 291667, 291665, 288237, 291663, 288234, 288231, 104655, 290388, 290387, 104651, 288228, 104637, 104634, 288226, 290385, 288221, 288220, 290383, 290380, 288215, 104632, 290377, 290374, 290372, 290370, 290984, 290978, 290360, 104596, 290357, 290346, 289243, 289240, 288860, 223116, 23265, 223112, 223109, 288213, 288211, 283753, 288209, 223105, 183026, 223100, 183023, 288591, 288590, 104552, 285916, 285913, 285911, 77371, 278970, 283271, 256307, 284197, 77369, 261060, 284169, 283752, 280007, 261052, 278961, 279149, 279147, 279145, 279140, 277966, 277965, 277960, 277959, 277955, 278850, 277946, 278848, 277659, 261041, 279002, 277942, 277655, 278980, 193356, 278952, 277653, 277649, 193354, 193353, 277646, 277644, 277643, 277932, 278842, 277254, 277930, 277252, 261032, 278119, 193351, 277924, 277240, 193345, 278112, 277238, 277921, 277236, 277232, 277229, 277222, 277216, 277914, 277210, 277912, 277201, 193340, 277909, 277894, 277529, 277640, 277197, 193337, 277890, 278158, 278103, 277191, 277190, 278100, 277638, 277621, 277507, 255735, 277614, 255734, 277609, 273257, 277606, 277604, 277187, 277496, 255727, 277185, 277183, 255725, 277181, 277180, 273796, 277175, 273795, 273254, 273249, 273247, 273792, 273240, 273764, 273755, 273754, 273749, 273748, 273747, 273745, 273742, 273740, 273738, 263966, 263963, 270980, 276396, 273736, 273735, 273731, 273728, 273709, 273708, 273704, 273703, 273699, 273696, 273694, 273680, 274818, 273678, 273676, 273674, 273670, 274122, 274120, 273668, 179315, 274816, 274783, 274781, 274779, 274815, 274777, 179309, 274117, 179306, 179305, 273653, 273651, 273650, 273646, 273641, 273639, 273637, 274114, 274112, 273634, 274065, 274110, 272950, 273630, 273629, 273628, 273626, 273624, 273622, 273618, 273610, 273608, 273606, 273602, 273581, 273578, 273577, 273576, 274082, 273550, 272948, 273233, 273230, 273228, 273221, 273212, 273207, 273205, 266825, 266821, 270071, 266818, 266809, 266806, 209595, 271934, 267826, 266805, 271605, 271602, 266801, 266798, 266795, 266791, 270888, 271233, 206511, 270868, 206509, 271228, 271226, 270866, 271224, 271222, 271220, 271219, 271217, 270859, 270857, 270840, 270839, 270838, 270431, 270414, 266788, 270337, 270334, 270333, 191688, 191686, 262068, 269257, 257138, 270330, 270410, 257136, 270406, 267031, 270397, 257131, 257129, 257125, 256496, 207404, 257123, 257121, 270029, 263955, 270026, 270023, 270157, 270155, 188343, 270012, 270010, 270008, 268574, 268572, 175388, 267749, 266985, 266217, 265027, 265025, 265021, 265019, 265017, 207393, 265014, 265012, 265009, 265008, 265002, 264932, 258250, 263735, 264588, 262151, 262138, 194044, 262931, 264147, 262927, 263725, 247565, 262925, 262922, 209283, 209281, 262918, 209278, 262946, 263205, 263201, 263200, 262945, 261802, 256735, 204415, 182511, 206784, 182506, 194258, 182502, 194254, 194253, 203717, 194247, 182500, 201660, 202650, 140862, 194098, 202345, 192774, 140855, 195382, 182495, 182486, 194095, 194093, 194092, 193587, 192744, 103750, 192249, 192248, 192247, 615144, 192028, 191567, 191845, 166688, 191167, 190991, 191130, 191058, 158994, 191056, 191053, 190832, 190828, 190824, 190821, 190820, 190812, 190809, 190807, 190806, 190576, 190391, 189823, 189383, 189377, 189866, 189675, 189302, 189428, 189361, 189374, 189372, 189370, 188245, 188410, 188381, 188201, 172596, 187725, 187714, 187712, 186837, 186871, 186816, 186854, 186853, 186810, 186108, 185601, 185599, 185898, 185888, 185886, 185837, 185583, 185183, 185177, 183572, 181943, 182823, 182822, 181938, 168054, 168052, 168051, 182723, 170994, 182455, 181460, 182452, 182418, 182666, 182450, 182411, 182444, 182443, 182441, 182439, 182437, 182435, 182432, 182431, 182428, 182403, 181457, 182399, 103665, 182187, 103659, 103657, 103654, 103650, 181935, 181931, 181930, 181927, 181922, 181920, 181918, 181916, 181914, 181912, 181911, 181909, 181905, 181904, 181901, 175802, 175785, 181881, 175784, 181879, 181696, 155352, 181099, 175561, 175544, 175348, 175345, 175344, 175531, 175450, 175438, 175341, 173664, 175365, 175340, 173865, 173864, 175094, 175337, 175355, 175334, 140695, 175087, 165170, 173979, 173978, 165160, 174459, 174458, 165147, 173903, 173720, 173646, 172829, 173644, 173329, 141905, 173299, 141904, 168352, 171891, 168226, 171889, 171885, 170972, 170970, 170952, 170555, 128793, 170550, 170135, 170093, 168342, 168338, 169779, 168336, 130598, 169776, 169772, 168334, 168332, 162272, 162267, 168330, 169215, 168327, 168639, 168634, 169200, 169194, 169192, 169183, 168220, 168628, 168626, 168625, 168620, 168265, 167473, 167789, 167783, 166065, 166063, 166578, 166230, 166227, 164014, 163467, 163461, 163460, 164256, 163454, 163873, 154802, 161905, 163180, 161933, 160356, 159164, 158162, 155313, 156671, 155823, 155305, 155297, 155296, 155291, 153039, 153524, 153869, 152392, 153348, 153347, 152382, 150155, 148172, 147628, 147284, 146875, 146873, 145444, 88026, 88017, 138389, 142345, 141893, 143383, 129273, 126194, 124649, 124646, 124645, 124632, 122266, 124090, 124088, 123723, 124081, 118763, 123721, 123523, 118761, 118760, 118890, 116514, 113835, 103434, 103432, 103431, 103427, 113861, 113829, 111924, 111366, 102451, 100658, 99142, 99139, 99134, 96251, 97116, 93442, 95593, 89632, 89621, 89231, 89230, 92860, 89541, 89225, 89223, 89220, 86453, 87687, 87680, 86452, 86450, 85800, 85799, 85972, 85760, 84879, 85361, 84997, 84275, 83778, 83617, 83418, 83789, 83738, 83736, 83734, 83631, 83317, 83629, 83361, 77455, 83047, 83359, 83313, 83357, 83355, 83321, 83312, 83311, 82359, 83044, 82423, 81715, 81159, 81158, 81157, 81979, 82353, 82351, 81713, 81976, 80380, 80379, 81924, 82115, 82097, 82096, 81922, 81711, 81708, 80621, 80618, 79319, 79355, 79352, 78765, 78085, 78296, 78295, 76580, 76578, 75701, 74959, 74957, 74955, 74953, 73177, 72034, 71238, 71031, 70961, 71027, 70843, 70840, 60568, 66547, 65449, 65447, 65444, 65442, 66638, 65417, 65850, 65407, 65790, 65405, 65397, 65396, 65389, 64903, 65141, 32583, 62792, 32581, 62790, 59055, 64734, 32565, 59691, 59689, 63894, 63893, 59688, 63645, 63642, 63640, 63189, 63330, 55111, 55105, 55100, 63016, 62836, 55098, 62824, 62820, 59675, 59674, 62305, 59669, 61949, 61378, 61222, 61318, 61366, 61248, 61011, 59664, 32520, 59662, 32508, 60289, 32506, 60103, 32496, 58216, 58214, 58099, 57875, 57586, 57581, 56670, 57049, 56585, 56666, 56663, 56660, 56415, 55393, 51734, 55333, 55469, 55329, 54632, 54673, 53941, 53424, 53422, 53421, 49312, 49306, 49302, 49299, 53667, 53612, 53171, 53343, 53341, 52875, 53427, 53037, 52643, 47987, 52574, 51639, 52160, 51987, 51725, 51147, 51322, 51320, 48940, 50678, 50439, 50438, 47978, 49597, 49594, 49590, 49506, 39461, 49290, 49100, 48886, 49098, 48617, 48614, 47937, 47847, 47839, 47837, 47179, 47177, 47175, 47174, 47140, 47488, 37525, 47172, 47170, 47168, 47165, 47161, 47156, 47115, 32445, 32443, 46343, 37523, 38572, 43704, 32438, 32436, 38569, 45192, 46760, 46154, 46151, 46149, 46137, 46871, 46337, 46331, 46330, 46329, 46718, 46716, 46715, 46133, 46714, 46713, 46131, 46591, 40381, 40379, 45067, 45065, 46587, 45064, 46293, 45283, 46322, 46279, 46386, 46316, 46313, 46130, 46311, 46290, 46125, 46121, 46118, 45061, 45564, 45956, 45129, 45026, 44825, 41175, 43960, 43363, 41172, 41168, 41417, 42375, 41415, 41413, 41411, 41405, 41166, 41165, 41163, 40372, 40288, 40286, 40347, 39933, 39716, 39712, 39454, 39246, 39234, 38907, 38904, 38895, 37168, 38232, 37509, 37507, 37503, 37500, 37498, 37941, 36539, 36537, 36536, 37662, 37701, 37660, 37667, 36640, 37446, 37494, 37029, 37248, 37162, 37200, 37150, 37100, 36529, 36527, 36524, 36520, 36518, 36516, 36161, 36152, 36122, 34760, 34759, 35659, 21898, 35467, 35451, 35049, 33916, 33914, 34606, 34544, 33909, 32389, 32381, 32379, 32377, 32374, 32372, 32369, 33477, 33492, 32362, 32053, 32051, 32050, 32358, 32357, 32355, 33061, 32354, 32351, 32048, 30559, 30214, 30764, 30212, 26273, 30209))
Run Time: 0.031174
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1678 | |
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 | | | | | 1678 | |
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 (19184, 19181, 19091, 18923, 18715, 18157, 18149, 18146, 18106, 18105, 18063, 17857, 17851, 17811, 17775, 17768, 17619, 17604, 17589, 17546, 17412, 17202, 17146, 17067, 17050, 17045, 17042, 17019, 16657, 16359, 16226, 16221, 16162, 16159, 16134, 15970, 15764, 15751, 15687, 15497, 15322, 15276, 15259, 14777, 14648, 14646, 14634, 14633, 14567, 14542, 14509, 14436, 14333, 14292, 14202, 14160, 14128, 14068, 14031, 13959, 13894, 13878, 13864, 13600, 13552, 13210, 12557, 12233, 12204, 12111, 12090, 12009, 11949, 11936, 11833, 11710, 11691, 11661, 11603, 11513, 11390, 11278, 11270, 11237, 11197, 10764, 10541, 10476, 8718, 7682, 7424, 7244, 7240, 7184, 7144, 7075, 5711, 5657, 5517, 5136, 4811, 4782, 4511, 4489, 4469, 4347, 4303, 4242, 4218, 4207, 4182, 4121, 3843, 3816, 3517, 3340, 3294, 3033))
Run Time: 0.003583
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 118 | 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, �T!
Run Time: 0.000243
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.000483
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.000488
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: 1716163732
Run Time: 0.000256
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 34 | 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` >= 1716163732)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000444
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 34 | 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