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.000603
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.000276
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` = '493')
LIMIT 1
Run Time: 0.000723
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.001703
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_493' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.053952
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 (383640, 3085, 113173, 343722, 16630, 341224, 183965, 304863, 310621, 302928, 319913, 321371, 319979, 183963, 183962, 183961, 321331, 311440, 321274, 183959, 318563, 315000, 183956, 183952, 311429, 310816, 183950, 183945, 270284, 311070, 290710, 308202, 312132, 310740, 310614, 286581, 311256, 312106, 160200, 302917, 183942, 18300, 298936, 304172, 3071, 305318, 305506, 306680, 307283, 277164, 297428, 183938, 301764, 301209, 3065, 298274, 296363, 296362, 299239, 287605, 294384, 293738, 299436, 299230, 298838, 296445, 297712, 264990, 289681, 290066, 282871, 282629, 183931, 285858, 273103, 284468, 285703, 285702, 285714, 270916, 268153, 273100, 284846, 271572, 282869, 282622, 183901, 270966, 83472, 270187, 270321, 268759, 265048, 269376, 257759, 259552, 264911, 160161, 264621, 269608, 260971, 263930, 207969, 160158, 269539, 269380, 260968, 266883, 264923, 264830, 265061, 264547, 264670, 260536, 201728, 264164, 261608, 261878, 125997, 260035, 264711, 264795, 264612, 259967, 261423, 260957, 258657, 259102, 258126, 258747, 258121, 256901, 255411, 254678, 254702, 257599, 36857, 256952, 257523, 257615, 256959, 257518, 257200, 256795, 222503, 249288, 255414, 204596, 250337, 254660, 254959, 254657, 247692, 207606, 193435, 189963, 117448, 193183, 169714, 190614, 193179, 192813, 190737, 192579, 127699, 192527, 191350, 192808, 192521, 192652, 190100, 190798, 191097, 191003, 189715, 190141, 191920, 186104, 192377, 165380, 189711, 188284, 183775, 188181, 188358, 188278, 186899, 187653, 186096, 187842, 187693, 183774, 183770, 183769, 182140, 187144, 160123, 187170, 183765, 182262, 186035, 183763, 183762, 181326, 185979, 185477, 184939, 182116, 185466, 144036, 166184, 149453, 184654, 184227, 8044, 185474, 185067, 184034, 182396, 170253, 185065, 185026, 185397, 96176, 181665, 183395, 182586, 182072, 183506, 183318, 182658, 182302, 183391, 160119, 182386, 182338, 181978, 182127, 182023, 170361, 170854, 170853, 175083, 160101, 181716, 173873, 175514, 3052, 181053, 164453, 170848, 170847, 175512, 172626, 175526, 175525, 157912, 3050, 172112, 3045, 139303, 168465, 173375, 173057, 171437, 174740, 174825, 169810, 174993, 172466, 170614, 174046, 169808, 174043, 172218, 172624, 83175, 162745, 160097, 172110, 173909, 163256, 172777, 162963, 170741, 171243, 161426, 172994, 172753, 170235, 173040, 173032, 172183, 169848, 165783, 170152, 59185, 169021, 169165, 169550, 169639, 112821, 170546, 170508, 169009, 165318, 165757, 170811, 170204, 142541, 170267, 157904, 59180, 167139, 170262, 162961, 168459, 167162, 167882, 167127, 168751, 166806, 142538, 161112, 16521, 152151, 152624, 159336, 159652, 159368, 159367, 155494, 157783, 159365, 159649, 154052, 154051, 153796, 96141, 142234, 154830, 158148, 155819, 159294, 159027, 153592, 157361, 157877, 157873, 159292, 155158, 155731, 3026, 117357, 117356, 151596, 143628, 150261, 151601, 96970, 150772, 150595, 144684, 141321, 150534, 125990, 144124, 139583, 147033, 36783, 150113, 151038, 141801, 138958, 141616, 126237, 126918, 138150, 139631, 137467, 123358, 135027, 118452, 138083, 139578, 135095, 133799, 133797, 136132, 137439, 133868, 134313, 136116, 134752, 134849, 137449, 137261, 134976, 129988, 134583, 137320, 122678, 129323, 135877, 136987, 137339, 137180, 133794, 117286, 124240, 123054, 117284, 124173, 123665, 124380, 124121, 122788, 124119, 117790, 123626, 124350, 87036, 116526, 116189, 121637, 122631, 121059, 116381, 116971, 112403, 115715, 119027, 87034, 121510, 118445, 118251, 117841, 117954, 118787, 113898, 114352, 114771, 113561, 96607, 114551, 111485, 114658, 97343, 112597, 112213, 100747, 101303, 111738, 111875, 110963, 111905, 111548, 111009, 83152, 111516, 110954, 96703, 102039, 111141, 103141, 102259, 103140, 97241, 101943, 102731, 100786, 100785, 73731, 77097, 99889, 100725, 100907, 100884, 100780, 96700, 96699, 100075, 100790, 99568, 99865, 99435, 99856, 99731, 100590, 96042, 84396, 99566, 99853, 100689, 96041, 97729, 28558, 16483, 94073, 98746, 99012, 67795, 100520, 98742, 73716, 99007, 67790, 99949, 95126, 87032, 98280, 79840, 94004, 99945, 93535, 97194, 97798, 97627, 93576, 79812, 93873, 86359, 94772, 91619, 89034, 79289, 94230, 93312, 95536, 95566, 94067, 16479, 94065, 28551, 94130, 86872, 7983, 95577, 95375, 95473, 96189, 95717, 95764, 94642, 93572, 87029, 83983, 93317, 18152, 93554, 92642, 93363, 76515, 92961, 88179, 93470, 93231, 89029, 88311, 18150, 83428, 85126, 89120, 76357, 86867, 92857, 93171, 92729, 92932, 93075, 89340, 87287, 84840, 86446, 87232, 87672, 81413, 86392, 87078, 87282, 86979, 84838, 79269, 86274, 85441, 79770, 86039, 87372, 87345, 85117, 85587, 87171, 87023, 87022, 86841, 86611, 86689, 86740, 76826, 77839, 84894, 77833, 84775, 84806, 71348, 77830, 84101, 83459, 84047, 84017, 83890, 83957, 83724, 82710, 82556, 83718, 83882, 83873, 83425, 80728, 81863, 78246, 80760, 83867, 82922, 81660, 79591, 77551, 79704, 79666, 77889, 79481, 79382, 79259, 79521, 78228, 78648, 79251, 69361, 79173, 78629, 77255, 18135, 76309, 77527, 77739, 77666, 77598, 35361, 77082, 77502, 77116, 77493, 76909, 76888, 77429, 71253, 76077, 77267, 77089, 76075, 74763, 77249, 77114, 76570, 76720, 77106, 76064, 74748, 76996, 76994, 76993, 76991, 76118, 73986, 76375, 76384, 75487, 76044, 76197, 74734, 76457, 76500, 74184, 70101, 75678, 75318, 75481, 75673, 75355, 75574, 75627, 74903, 75521, 73602, 75351, 75501, 74731, 74803, 75617, 75572, 75117, 75622, 71543, 74923, 75114, 75096, 75086, 59117, 75230, 18107, 75314, 18105, 74915, 74726, 74386, 74204, 72620, 73917, 73934, 74302, 73561, 74467, 69495, 69314, 72190, 71958, 73155, 70601, 73990, 73644, 64235, 73887, 72088, 72607, 72606, 71212, 73220, 73510, 73134, 73149, 67168, 73572, 70889, 73835, 73092, 73210, 73262, 71955, 73628, 73691, 70599, 73088, 69436, 73541, 73671, 73594, 73683, 24016, 70906, 66331, 71735, 66139, 71946, 72403, 72260, 72952, 70576, 68891, 68794, 70542, 67064, 67953, 67247, 70186, 70523, 63715, 70539, 69424, 64297, 68883, 68882, 66573, 69074, 67677, 59108, 69224, 69222, 67674, 69374, 67570, 67198, 67897, 67061, 68974, 68849, 69032, 68206, 65372, 63996, 65371, 65871, 65869, 60808, 65369, 65698, 65197, 65655, 50839, 65151, 60802, 65780, 64291, 50835, 65193, 54156, 59091, 56915, 64170, 64117, 62684, 64068, 63264, 64034, 59468, 64115, 45837, 64159, 56913, 64032, 64147, 63684, 25757, 61942, 45833, 18048, 63677, 63241, 63731, 63238, 23889, 54104, 63560, 49065, 60248, 63611, 63551, 63416, 63516, 63233, 23886, 59731, 57001, 62728, 62206, 49976, 61796, 62204, 60762, 60752, 23876, 54150, 58906, 61005, 23873, 23872, 23871, 58904, 60013, 60626, 58533, 51430, 59366, 58753, 60997, 59986, 59263, 58892, 59560, 60233, 58024, 58851, 57636, 58204, 58479, 58291, 58526, 58522, 58521, 56611, 57384, 57168, 56073, 48313, 49460, 56717, 56196, 57381, 44425, 54047, 54949, 52800, 53326, 52343, 50790, 52686, 47652, 48730, 48490, 47452, 48392, 47041, 46263, 46382, 43512, 44731, 47099, 9590, 46543, 46450, 46890, 46512, 46184, 46553, 46609, 45551, 46003, 45914, 45178, 44678, 44380, 44577, 36294, 43688, 43604, 44509, 43504, 45615, 41069, 42980, 42320, 42929, 45421, 43906, 41118, 39830, 42643, 45639, 45427, 43469, 43194, 43272, 43075, 43112, 43068, 40087, 42391, 42734, 42816, 41729, 42922, 42767, 42950, 33637, 42400, 41879, 33635, 42706, 42480, 42555, 42652, 40850, 41817, 42366, 42337, 42241, 37974, 33895, 40341, 41652, 41746, 41814, 41615, 41426, 35222, 41666, 41718, 41377, 41839, 41111, 35217, 41641, 41422, 38056, 35210, 41225, 41057, 41400, 37576, 40938, 40620, 40834, 40751, 17287, 38029, 40779, 40895, 37424, 40617, 40809, 40913, 40490, 40487, 40608, 37965, 40571, 39516, 36339, 40517, 36338, 40454, 40481, 37571, 40564, 40473, 39208, 40426, 40308, 33529, 40394, 40168, 40198, 36494, 40252, 20834, 40250, 39985, 39982, 33526, 35506, 28483, 39790, 40029, 36583, 38976, 35606, 40002, 39125, 39968, 35321, 39491, 39114, 39883, 39867, 38724, 39820, 39513, 36573, 39768, 39551, 39107, 39488, 38224, 39549, 39510, 39101, 39484, 39388, 39448, 39291, 38794, 37263, 39096, 39041, 38917, 35203, 38392, 38013, 37858, 33864, 38390, 38452, 38444, 38386, 38554, 38523, 38441, 38515, 38024, 38413, 38301, 38183, 38338, 37953, 38434, 38383, 38131, 38018, 38047, 37720, 37694, 37834, 37839, 17283, 37718, 37649, 37845, 37919, 37683, 34017, 37490, 37637, 37371, 8657, 37413, 33851, 37303, 37395, 36264, 36622, 36620, 37107, 36400, 36588, 33196, 37128, 29733, 36258, 36593, 36615, 36636, 34013, 37232, 35734, 35895, 23724, 35771, 34829, 34602, 35792, 21528, 35742, 35037, 22356, 35156, 34823, 35396, 35625, 35595, 35394, 35404, 33715, 22354, 27854, 34099, 35198, 3142, 35487, 34792, 33842, 34821, 35483, 34185, 34254, 35153, 35195, 32807, 25571, 35151, 32804, 32802, 35192, 35240, 35147, 32202, 34693, 34719, 28468, 31252, 32200, 35033, 34812, 34451, 34450, 34222, 34386, 33838, 32800, 34322, 21709, 34202, 33032, 34067, 34081, 34327, 34066, 33830, 27673, 33996, 34176, 33684, 33683, 33681, 33271, 33656, 30554, 31754, 32814, 32923, 32891, 17273, 32889, 32192, 31837, 32781, 31872, 31631, 32187, 31870, 30552, 31867, 28888, 17264, 13373, 32029, 32103, 31895, 31626, 22881, 16185, 31979, 31829, 31863, 28877, 29939, 31401, 31678, 31668, 31399, 31393, 31655, 29935, 31622, 31660, 21699, 29929, 31187, 20328, 31250, 31185, 30816, 29048, 29905, 27412, 31448, 30809, 31182, 31312, 31380, 29901, 31306, 21696, 31248, 27410, 31226, 3005, 16180, 31178, 3003, 29891, 31223, 30996, 30985, 20324, 20321, 31160, 31051, 30970, 26124, 31046, 30840, 29039, 30962, 30804, 30838, 29029, 30469, 29023, 30467, 29688, 25931, 25901, 30384, 29686, 3000, 30096, 2998, 25113, 29949, 29801, 30248, 1118, 30246, 1116, 30279, 609, 30268, 22765, 30093, 22181, 29945, 29957, 29877, 29012, 29720, 29809, 28864, 29586, 28997, 22759, 15950, 25878, 15948, 2990, 29482, 29236, 22755, 28700, 29169, 29228, 28698, 29216, 29139, 28695, 27407, 21680, 20578, 28964, 28979, 28858, 23065, 27492, 28845, 26079, 27925, 25716, 27968, 16477, 20576, 3338, 27914, 27923, 27944, 28666, 28612, 27857, 25556, 27594, 27666, 27592, 26370, 27662, 16469, 23222, 24712, 27306, 16466, 27303, 16464, 26296, 26291, 27063, 25723, 27202, 27166, 26098, 26287, 23061, 26067, 26284, 26684, 26612, 22747, 26057, 25976, 25478, 25712, 20808, 6841, 25631, 25843, 25925, 20311, 7528, 25847, 25639, 25576, 25545, 25419, 23055, 25400, 24680, 22125, 22034, 22057, 24679, 24260, 24965, 22744, 24253, 24582, 24580, 17042, 24968, 24955, 24644, 24953, 3125, 24599, 24349, 24928, 24643, 22737, 24595, 24888, 24593, 24341, 18341, 24826, 23245, 24590, 22732, 24655, 23567, 20907, 24391, 22926, 24722, 24339, 22430, 24689, 9772, 24577, 2961, 18335, 9768, 24661, 24684, 23609, 16904, 24336, 24535, 21504, 24248, 24266, 22221, 21351, 23617, 24302, 21349, 22995, 23209, 22217, 22669, 22715, 22661, 22104, 22211, 22327, 22175, 22049, 22061, 21468, 21780, 13366, 22005, 22025, 21763, 21793, 21800, 21777, 21774, 21466, 21658, 21741, 18674, 6838, 20010, 21463, 9549, 9546, 20708, 19013, 21460, 20565, 21431, 20702, 21332, 21341, 20851, 21386, 21428, 20585, 21254, 20797, 20792, 19993, 21011, 21169, 21008, 21166, 20437, 21003, 17955, 19991, 20563, 20433, 20693, 20217, 20712, 17952, 20450, 20787, 19942, 20896, 19984, 19982, 19976, 19831, 18659, 17381, 19925, 19974, 19744, 19920, 17379, 19741, 19939, 19739, 17941, 19917, 19867, 19827, 19821, 19738, 19735, 9540, 18720, 19660, 19556, 18820, 6573, 19693, 19512, 16223, 18718, 19497, 19461, 19494, 18418, 18833, 18841, 17904, 14552, 17061, 19260, 17224, 17217, 18749, 18809, 16376, 18640, 17824, 6835, 18688, 19026, 19007, 19237, 17929, 17928, 19150, 16221, 14550, 19114, 18715, 19195, 6833, 13357, 17919, 16089, 16929, 16347, 16459, 16921, 15984, 16219, 16176, 9529, 15839, 16087, 15772, 9518, 13339, 9514, 13317, 13332, 9507, 13331, 9506, 13410, 13341, 13315, 12452, 12450, 12446))
Run Time: 0.089712
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1615 | |
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 | | | | | 1615 | |
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 (17875, 17024, 16264, 15962, 15924, 15589, 15512, 15505, 14882, 14688, 14486, 14269, 14268, 13833, 13824, 13629, 13488, 13423, 13352, 13269, 13213, 13094, 13085, 13084, 12610, 12182, 12145, 11906, 11841, 11626, 11475, 11474, 11364, 11224, 10714, 10709, 10597, 9806, 9728, 9665, 9073, 9072, 8946, 8836, 8443, 8384, 8262, 8013, 7841, 7584, 7527, 7526, 7336, 7290, 7224, 6994, 6981, 6962, 6829, 6820, 6787, 6770, 6642, 6641, 6496, 6205, 6106, 5613, 5485, 5301, 5189, 5054, 5053, 4880, 4747, 4431, 4253, 4236, 4234, 3735, 3693, 3687, 3539, 3511, 3276, 3235, 3072, 2948, 2841, 2816, 2815, 2596, 2511, 2334, 2287, 2138, 2052, 1949, 1940, 1926, 1923, 1895, 1889, 1615, 1393))
Run Time: 0.005172
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 105 | 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 (383640, 3085, 113173, 343722, 16630, 341224, 183965, 304863, 310621, 302928, 319913, 321371, 319979, 183963, 183962, 183961, 321331, 311440, 321274, 183959, 318563, 315000, 183956, 183952, 311429, 310816, 183950, 183945, 270284, 311070, 290710, 308202, 312132, 310740, 310614, 286581, 311256, 312106, 160200, 302917, 183942, 18300, 298936, 304172, 3071, 305318, 305506, 306680, 307283, 277164, 297428, 183938, 301764, 301209, 3065, 298274, 296363, 296362, 299239, 287605, 294384, 293738, 299436, 299230, 298838, 296445, 297712, 264990, 289681, 290066, 282871, 282629, 183931, 285858, 273103, 284468, 285703, 285702, 285714, 270916, 268153, 273100, 284846, 271572, 282869, 282622, 183901, 270966, 83472, 270187, 270321, 268759, 265048, 269376, 257759, 259552, 264911, 160161, 264621, 269608, 260971, 263930, 207969, 160158, 269539, 269380, 260968, 266883, 264923, 264830, 265061, 264547, 264670, 260536, 201728, 264164, 261608, 261878, 125997, 260035, 264711, 264795, 264612, 259967, 261423, 260957, 258657, 259102, 258126, 258747, 258121, 256901, 255411, 254678, 254702, 257599, 36857, 256952, 257523, 257615, 256959, 257518, 257200, 256795, 222503, 249288, 255414, 204596, 250337, 254660, 254959, 254657, 247692, 207606, 193435, 189963, 117448, 193183, 169714, 190614, 193179, 192813, 190737, 192579, 127699, 192527, 191350, 192808, 192521, 192652, 190100, 190798, 191097, 191003, 189715, 190141, 191920, 186104, 192377, 165380, 189711, 188284, 183775, 188181, 188358, 188278, 186899, 187653, 186096, 187842, 187693, 183774, 183770, 183769, 182140, 187144, 160123, 187170, 183765, 182262, 186035, 183763, 183762, 181326, 185979, 185477, 184939, 182116, 185466, 144036, 166184, 149453, 184654, 184227, 8044, 185474, 185067, 184034, 182396, 170253, 185065, 185026, 185397, 96176, 181665, 183395, 182586, 182072, 183506, 183318, 182658, 182302, 183391, 160119, 182386, 182338, 181978, 182127, 182023, 170361, 170854, 170853, 175083, 160101, 181716, 173873, 175514, 3052, 181053, 164453, 170848, 170847, 175512, 172626, 175526, 175525, 157912, 3050, 172112, 3045, 139303, 168465, 173375, 173057, 171437, 174740, 174825, 169810, 174993, 172466, 170614, 174046, 169808, 174043, 172218, 172624, 83175, 162745, 160097, 172110, 173909, 163256, 172777, 162963, 170741, 171243, 161426, 172994, 172753, 170235, 173040, 173032, 172183, 169848, 165783, 170152, 59185, 169021, 169165, 169550, 169639, 112821, 170546, 170508, 169009, 165318, 165757, 170811, 170204, 142541, 170267, 157904, 59180, 167139, 170262, 162961, 168459, 167162, 167882, 167127, 168751, 166806, 142538, 161112, 16521, 152151, 152624, 159336, 159652, 159368, 159367, 155494, 157783, 159365, 159649, 154052, 154051, 153796, 96141, 142234, 154830, 158148, 155819, 159294, 159027, 153592, 157361, 157877, 157873, 159292, 155158, 155731, 3026, 117357, 117356, 151596, 143628, 150261, 151601, 96970, 150772, 150595, 144684, 141321, 150534, 125990, 144124, 139583, 147033, 36783, 150113, 151038, 141801, 138958, 141616, 126237, 126918, 138150, 139631, 137467, 123358, 135027, 118452, 138083, 139578, 135095, 133799, 133797, 136132, 137439, 133868, 134313, 136116, 134752, 134849, 137449, 137261, 134976, 129988, 134583, 137320, 122678, 129323, 135877, 136987, 137339, 137180, 133794, 117286, 124240, 123054, 117284, 124173, 123665, 124380, 124121, 122788, 124119, 117790, 123626, 124350, 87036, 116526, 116189, 121637, 122631, 121059, 116381, 116971, 112403, 115715, 119027, 87034, 121510, 118445, 118251, 117841, 117954, 118787, 113898, 114352, 114771, 113561, 96607, 114551, 111485, 114658, 97343, 112597, 112213, 100747, 101303, 111738, 111875, 110963, 111905, 111548, 111009, 83152, 111516, 110954, 96703, 102039, 111141, 103141, 102259, 103140, 97241, 101943, 102731, 100786, 100785, 73731, 77097, 99889, 100725, 100907, 100884, 100780, 96700, 96699, 100075, 100790, 99568, 99865, 99435, 99856, 99731, 100590, 96042, 84396, 99566, 99853, 100689, 96041, 97729, 28558, 16483, 94073, 98746, 99012, 67795, 100520, 98742, 73716, 99007, 67790, 99949, 95126, 87032, 98280, 79840, 94004, 99945, 93535, 97194, 97798, 97627, 93576, 79812, 93873, 86359, 94772, 91619, 89034, 79289, 94230, 93312, 95536, 95566, 94067, 16479, 94065, 28551, 94130, 86872, 7983, 95577, 95375, 95473, 96189, 95717, 95764, 94642, 93572, 87029, 83983, 93317, 18152, 93554, 92642, 93363, 76515, 92961, 88179, 93470, 93231, 89029, 88311, 18150, 83428, 85126, 89120, 76357, 86867, 92857, 93171, 92729, 92932, 93075, 89340, 87287, 84840, 86446, 87232, 87672, 81413, 86392, 87078, 87282, 86979, 84838, 79269, 86274, 85441, 79770, 86039, 87372, 87345, 85117, 85587, 87171, 87023, 87022, 86841, 86611, 86689, 86740, 76826, 77839, 84894, 77833, 84775, 84806, 71348, 77830, 84101, 83459, 84047, 84017, 83890, 83957, 83724, 82710, 82556, 83718, 83882, 83873, 83425, 80728, 81863, 78246, 80760, 83867, 82922, 81660, 79591, 77551, 79704, 79666, 77889, 79481, 79382, 79259, 79521, 78228, 78648, 79251, 69361, 79173, 78629, 77255, 18135, 76309, 77527, 77739, 77666, 77598, 35361, 77082, 77502, 77116, 77493, 76909, 76888, 77429, 71253, 76077, 77267, 77089, 76075, 74763, 77249, 77114, 76570, 76720, 77106, 76064, 74748, 76996, 76994, 76993, 76991, 76118, 73986, 76375, 76384, 75487, 76044, 76197, 74734, 76457, 76500, 74184, 70101, 75678, 75318, 75481, 75673, 75355, 75574, 75627, 74903, 75521, 73602, 75351, 75501, 74731, 74803, 75617, 75572, 75117, 75622, 71543, 74923, 75114, 75096, 75086, 59117, 75230, 18107, 75314, 18105, 74915, 74726, 74386, 74204, 72620, 73917, 73934, 74302, 73561, 74467, 69495, 69314, 72190, 71958, 73155, 70601, 73990, 73644, 64235, 73887, 72088, 72607, 72606, 71212, 73220, 73510, 73134, 73149, 67168, 73572, 70889, 73835, 73092, 73210, 73262, 71955, 73628, 73691, 70599, 73088, 69436, 73541, 73671, 73594, 73683, 24016, 70906, 66331, 71735, 66139, 71946, 72403, 72260, 72952, 70576, 68891, 68794, 70542, 67064, 67953, 67247, 70186, 70523, 63715, 70539, 69424, 64297, 68883, 68882, 66573, 69074, 67677, 59108, 69224, 69222, 67674, 69374, 67570, 67198, 67897, 67061, 68974, 68849, 69032, 68206, 65372, 63996, 65371, 65871, 65869, 60808, 65369, 65698, 65197, 65655, 50839, 65151, 60802, 65780, 64291, 50835, 65193, 54156, 59091, 56915, 64170, 64117, 62684, 64068, 63264, 64034, 59468, 64115, 45837, 64159, 56913, 64032, 64147, 63684, 25757, 61942, 45833, 18048, 63677, 63241, 63731, 63238, 23889, 54104, 63560, 49065, 60248, 63611, 63551, 63416, 63516, 63233, 23886, 59731, 57001, 62728, 62206, 49976, 61796, 62204, 60762, 60752, 23876, 54150, 58906, 61005, 23873, 23872, 23871, 58904, 60013, 60626, 58533, 51430, 59366, 58753, 60997, 59986, 59263, 58892, 59560, 60233, 58024, 58851, 57636, 58204, 58479, 58291, 58526, 58522, 58521, 56611, 57384, 57168, 56073, 48313, 49460, 56717, 56196, 57381, 44425, 54047, 54949, 52800, 53326, 52343, 50790, 52686, 47652, 48730, 48490, 47452, 48392, 47041, 46263, 46382, 43512, 44731, 47099, 9590, 46543, 46450, 46890, 46512, 46184, 46553, 46609, 45551, 46003, 45914, 45178, 44678, 44380, 44577, 36294, 43688, 43604, 44509, 43504, 45615, 41069, 42980, 42320, 42929, 45421, 43906, 41118, 39830, 42643, 45639, 45427, 43469, 43194, 43272, 43075, 43112, 43068, 40087, 42391, 42734, 42816, 41729, 42922, 42767, 42950, 33637, 42400, 41879, 33635, 42706, 42480, 42555, 42652, 40850, 41817, 42366, 42337, 42241, 37974, 33895, 40341, 41652, 41746, 41814, 41615, 41426, 35222, 41666, 41718, 41377, 41839, 41111, 35217, 41641, 41422, 38056, 35210, 41225, 41057, 41400, 37576, 40938, 40620, 40834, 40751, 17287, 38029, 40779, 40895, 37424, 40617, 40809, 40913, 40490, 40487, 40608, 37965, 40571, 39516, 36339, 40517, 36338, 40454, 40481, 37571, 40564, 40473, 39208, 40426, 40308, 33529, 40394, 40168, 40198, 36494, 40252, 20834, 40250, 39985, 39982, 33526, 35506, 28483, 39790, 40029, 36583, 38976, 35606, 40002, 39125, 39968, 35321, 39491, 39114, 39883, 39867, 38724, 39820, 39513, 36573, 39768, 39551, 39107, 39488, 38224, 39549, 39510, 39101, 39484, 39388, 39448, 39291, 38794, 37263, 39096, 39041, 38917, 35203, 38392, 38013, 37858, 33864, 38390, 38452, 38444, 38386, 38554, 38523, 38441, 38515, 38024, 38413, 38301, 38183, 38338, 37953, 38434, 38383, 38131, 38018, 38047, 37720, 37694, 37834, 37839, 17283, 37718, 37649, 37845, 37919, 37683, 34017, 37490, 37637, 37371, 8657, 37413, 33851, 37303, 37395, 36264, 36622, 36620, 37107, 36400, 36588, 33196, 37128, 29733, 36258, 36593, 36615, 36636, 34013, 37232, 35734, 35895, 23724, 35771, 34829, 34602, 35792, 21528, 35742, 35037, 22356, 35156, 34823, 35396, 35625, 35595, 35394, 35404, 33715, 22354, 27854, 34099, 35198, 3142, 35487, 34792, 33842, 34821, 35483, 34185, 34254, 35153, 35195, 32807, 25571, 35151, 32804, 32802, 35192, 35240, 35147, 32202, 34693, 34719, 28468, 31252, 32200, 35033, 34812, 34451, 34450, 34222, 34386, 33838, 32800, 34322, 21709, 34202, 33032, 34067, 34081, 34327, 34066, 33830, 27673, 33996, 34176, 33684, 33683, 33681, 33271, 33656, 30554, 31754, 32814, 32923, 32891, 17273, 32889, 32192, 31837, 32781, 31872, 31631, 32187, 31870, 30552, 31867, 28888, 17264, 13373, 32029, 32103, 31895, 31626, 22881, 16185, 31979, 31829, 31863, 28877, 29939, 31401, 31678, 31668, 31399, 31393, 31655, 29935, 31622, 31660, 21699, 29929, 31187, 20328, 31250, 31185, 30816, 29048, 29905, 27412, 31448, 30809, 31182, 31312, 31380, 29901, 31306, 21696, 31248, 27410, 31226, 3005, 16180, 31178, 3003, 29891, 31223, 30996, 30985, 20324, 20321, 31160, 31051, 30970, 26124, 31046, 30840, 29039, 30962, 30804, 30838, 29029, 30469, 29023, 30467, 29688, 25931, 25901, 30384, 29686, 3000, 30096, 2998, 25113, 29949, 29801, 30248, 1118, 30246, 1116, 30279, 609, 30268, 22765, 30093, 22181, 29945, 29957, 29877, 29012, 29720, 29809, 28864, 29586, 28997, 22759, 15950, 25878, 15948, 2990, 29482, 29236, 22755, 28700, 29169, 29228, 28698, 29216, 29139, 28695, 27407, 21680, 20578, 28964, 28979, 28858, 23065, 27492, 28845, 26079, 27925, 25716, 27968, 16477, 20576, 3338, 27914, 27923, 27944, 28666, 28612, 27857, 25556, 27594, 27666, 27592, 26370, 27662, 16469, 23222, 24712, 27306, 16466, 27303, 16464, 26296, 26291, 27063, 25723, 27202, 27166, 26098, 26287, 23061, 26067, 26284, 26684, 26612, 22747, 26057, 25976, 25478, 25712, 20808, 6841, 25631, 25843, 25925, 20311, 7528, 25847, 25639, 25576, 25545, 25419, 23055, 25400, 24680, 22125, 22034, 22057, 24679, 24260, 24965, 22744, 24253, 24582, 24580, 17042, 24968, 24955, 24644, 24953, 3125, 24599, 24349, 24928, 24643, 22737, 24595, 24888, 24593, 24341, 18341, 24826, 23245, 24590, 22732, 24655, 23567, 20907, 24391, 22926, 24722, 24339, 22430, 24689, 9772, 24577, 2961, 18335, 9768, 24661, 24684, 23609, 16904, 24336, 24535, 21504, 24248, 24266, 22221, 21351, 23617, 24302, 21349, 22995, 23209, 22217, 22669, 22715, 22661, 22104, 22211, 22327, 22175, 22049, 22061, 21468, 21780, 13366, 22005, 22025, 21763, 21793, 21800, 21777, 21774, 21466, 21658, 21741, 18674, 6838, 20010, 21463, 9549, 9546, 20708, 19013, 21460, 20565, 21431, 20702, 21332, 21341, 20851, 21386, 21428, 20585, 21254, 20797, 20792, 19993, 21011, 21169, 21008, 21166, 20437, 21003, 17955, 19991, 20563, 20433, 20693, 20217, 20712, 17952, 20450, 20787, 19942, 20896, 19984, 19982, 19976, 19831, 18659, 17381, 19925, 19974, 19744, 19920, 17379, 19741, 19939, 19739, 17941, 19917, 19867, 19827, 19821, 19738, 19735, 9540, 18720, 19660, 19556, 18820, 6573, 19693, 19512, 16223, 18718, 19497, 19461, 19494, 18418, 18833, 18841, 17904, 14552, 17061, 19260, 17224, 17217, 18749, 18809, 16376, 18640, 17824, 6835, 18688, 19026, 19007, 19237, 17929, 17928, 19150, 16221, 14550, 19114, 18715, 19195, 6833, 13357, 17919, 16089, 16929, 16347, 16459, 16921, 15984, 16219, 16176, 9529, 15839, 16087, 15772, 9518, 13339, 9514, 13317, 13332, 9507, 13331, 9506, 13410, 13341, 13315, 12452, 12450, 12446))
Run Time: 0.034214
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1615 | |
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 | | | | | 1615 | |
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 (17875, 17024, 16264, 15962, 15924, 15589, 15512, 15505, 14882, 14688, 14486, 14269, 14268, 13833, 13824, 13629, 13488, 13423, 13352, 13269, 13213, 13094, 13085, 13084, 12610, 12182, 12145, 11906, 11841, 11626, 11475, 11474, 11364, 11224, 10714, 10709, 10597, 9806, 9728, 9665, 9073, 9072, 8946, 8836, 8443, 8384, 8262, 8013, 7841, 7584, 7527, 7526, 7336, 7290, 7224, 6994, 6981, 6962, 6829, 6820, 6787, 6770, 6642, 6641, 6496, 6205, 6106, 5613, 5485, 5301, 5189, 5054, 5053, 4880, 4747, 4431, 4253, 4236, 4234, 3735, 3693, 3687, 3539, 3511, 3276, 3235, 3072, 2948, 2841, 2816, 2815, 2596, 2511, 2334, 2287, 2138, 2052, 1949, 1940, 1926, 1923, 1895, 1889, 1615, 1393))
Run Time: 0.003323
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 105 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, �ڂ
Run Time: 0.000255
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
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: �ڂ, XF\Pub\Controller\Member, RecentContent, valid, user_id=493, 1716188032, , 0, �ڂ
Run Time: 0.000155
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- 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.000649
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.000879
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: 1716187732
Run Time: 0.000321
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 24 | 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` >= 1716187732)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000543
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 24 | 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