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.000553
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.000305
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` = '1738')
LIMIT 1
Run Time: 0.000570
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.002658
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_1738' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.061695
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_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 (16935, 13700, 13096, 12998, 12489, 12275, 11982, 11955, 11902, 11803, 11745, 11724, 11655, 11204, 11159, 11105, 10855, 10678, 10348, 9090, 9059, 9034, 8998, 8997, 8952, 8925, 8905, 8726, 8711, 8511, 8492, 8447, 8407, 8350, 8291, 8282, 8266, 8261, 8254, 7871, 7822, 7681, 7400, 7332, 7271, 7176, 6411, 5875, 5864))
Run Time: 0.004623
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 49 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 180
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (270567, 298890, 183936, 295785, 295783, 295781, 172023, 293810, 293830, 183934, 183932, 183929, 204300, 286574, 96794, 285852, 277775, 277774, 277772, 277771, 183922, 183921, 279671, 279670, 193767, 147400, 283010, 183918, 279601, 34635, 282614, 282834, 183915, 282608, 279427, 270824, 183912, 270822, 270820, 183909, 183908, 183906, 183903, 273072, 271571, 265114, 272868, 183902, 271617, 271555, 271554, 271553, 271549, 271546, 183900, 183899, 271568, 183898, 265051, 183890, 183888, 183885, 183883, 183881, 183879, 183874, 183872, 183869, 183868, 183866, 270910, 83476, 269908, 270494, 269864, 268308, 269710, 204295, 204293, 204291, 41693, 183864, 183862, 183860, 268051, 269379, 183859, 267495, 204289, 267147, 267490, 267488, 268046, 267466, 267461, 267460, 268676, 268304, 267941, 267454, 267453, 267930, 258343, 83469, 83468, 83466, 183855, 267444, 267435, 267433, 267423, 267422, 267417, 267411, 267410, 267921, 267919, 267917, 267916, 265046, 266410, 267727, 267396, 83460, 258757, 265043, 263776, 267393, 265110, 265109, 263562, 265264, 266515, 266513, 254671, 266353, 261654, 261652, 261650, 266349, 265101, 265097, 265092, 96179, 265559, 265259, 265256, 183853, 265218, 265183, 265039, 264921, 264316, 183852, 265057, 264307, 183850, 183848, 264305, 264304, 264713, 183847, 183845, 264864, 264829, 264816, 264291, 264286, 264284, 264800, 147399, 264235, 264222, 183833, 183830, 263632, 175217, 263676, 263674, 263673, 263582, 263667, 262374, 263580, 263579, 263576, 263575, 263329, 259836, 262201, 262457, 255491, 262454, 262452, 262444, 262442, 261627, 262440, 255483, 255481, 261630, 261629, 183827, 258750, 261623, 259968, 261587, 113980, 141362, 261422, 183826, 183824, 254723, 260456, 260455, 260454, 259825, 260450, 260447, 259820, 260440, 259817, 142953, 260048, 257623, 250582, 259769, 259099, 259098, 259096, 258726, 258600, 258328, 183820, 257231, 257778, 257777, 255869, 258319, 258080, 193764, 257736, 257613, 256868, 193760, 257610, 257609, 257516, 257222, 256862, 256963, 249500, 249498, 255863, 255479, 256555, 256553, 256641, 256405, 256400, 256398, 256396, 256395, 256392, 256390, 256383, 255467, 255462, 250362, 250360, 250358, 255459, 155245, 250354, 255891, 250352, 255866, 255454, 255419, 255451, 255285, 255450, 255444, 152332, 255413, 117537, 255389, 255260, 254634, 254632, 155242, 253556, 254955, 254953, 254951, 254653, 254651, 183805, 117529, 183803, 253548, 183799, 253536, 253533, 253528, 253524, 253522, 253519, 253517, 253832, 251008, 253511, 247878, 253508, 204288, 253503, 250331, 253337, 253333, 253219, 249461, 250288, 167032, 250284, 250283, 250230, 250229, 250221, 250201, 250198, 250196, 250194, 250191, 250185, 250179, 249460, 250157, 250154, 250982, 250973, 250971, 250969, 250089, 250085, 250072, 250069, 250055, 204283, 183796, 183789, 183786, 204281, 204277, 204275, 204265, 204257, 249062, 204241, 193757, 204228, 204227, 204226, 204220, 248337, 204210, 204208, 247713, 142918, 204199, 142916, 172016, 172009, 222520, 222519, 208463, 222309, 208169, 208306, 208159, 206932, 204137, 207375, 204327, 193753, 202973, 202971, 204785, 204781, 204778, 184955, 204776, 206575, 204768, 204575, 202949, 202946, 204371, 202944, 204197, 184950, 204346, 203905, 204333, 204191, 204188, 202937, 204183, 203771, 203769, 203889, 203876, 203742, 203443, 202932, 203426, 203524, 202931, 202929, 202922, 201855, 201853, 202041, 202914, 202884, 194389, 202337, 202333, 117470, 190015, 194384, 201783, 201781, 201370, 201772, 201368, 201364, 201358, 192624, 193736, 162802, 193721, 195179, 193716, 193701, 185248, 185247, 143196, 185243, 143194, 194908, 194813, 194810, 194809, 194877, 194875, 194873, 142833, 193934, 194802, 162801, 194612, 193868, 193691, 193865, 193809, 194082, 193654, 194006, 193672, 193668, 186071, 193217, 193182, 193172, 192881, 192877, 192144, 192737, 192733, 192732, 165385, 192725, 173958, 174759, 192142, 191997, 192135, 191979, 192124, 191041, 190723, 190337, 190353, 189506, 190071, 189799, 144154, 144148, 144146, 189155, 187918, 188176, 187875, 187254, 187870, 136958, 187855, 187101, 187690, 136955, 136953, 187844, 187688, 187686, 136949, 136947, 136945, 187222, 187371, 155224, 155222, 187252, 187243, 187277, 186007, 187275, 187274, 144530, 144527, 187205, 187202, 187200, 187198, 183768, 182617, 187092, 186954, 184145, 183753, 183751, 186106, 183749, 185533, 183744, 183743, 183739, 183443, 117432, 183734, 182117, 185523, 185202, 185200, 183731, 183729, 183727, 144516, 185196, 144511, 144509, 185191, 144507, 136940, 136936, 183176, 185013, 185029, 136932, 136929, 171992, 184356, 184355, 144494, 184345, 184343, 184342, 182103, 182101, 123416, 184158, 144481, 183437, 182096, 184155, 144471, 183722, 184019, 183716, 182077, 182075, 174891, 174888, 174883, 174880, 174876, 174875, 174873, 174869, 174864, 182069, 183678, 174862, 183675, 183468, 174856, 183375, 174854, 174852, 183424, 174850, 172943, 182566, 175516, 183302, 183105, 181703, 174843, 182364, 181741, 182021, 182019, 182017, 181737, 181550, 181723, 181719, 181709, 181711, 144457, 161918, 175082, 144444, 144436, 162798, 175233, 174653, 175075, 172494, 162796, 174816, 174813, 172887, 172885, 174808, 173791, 18247, 165346, 162744, 173924, 172789, 171990, 171988, 171987, 171978, 173297, 173789, 144424, 173465, 173543, 173531, 173526, 141538, 141536, 141527, 173294, 173065, 173278, 173096, 170818, 170815, 172860, 157366, 172734, 172652, 157954, 147822, 171146, 171960, 155212, 171142, 171140, 155210, 155208, 171452, 170813, 171121, 171272, 170579, 171037, 171022, 171066, 171016, 171015, 169634, 170719, 170717, 170929, 170927, 170305, 170228, 162794, 169765, 162788, 169749, 169582, 165729, 169592, 169574, 169571, 169255, 155200, 169240, 169129, 136921, 155196, 169019, 168896, 168890, 168717, 157936, 155191, 48348, 48345, 162779, 162778, 168526, 167508, 168523, 167502, 167123, 168152, 142780, 167980, 167978, 167962, 142777, 166538, 153918, 166151, 142775, 162532, 155891, 166535, 166530, 162776, 162775, 166528, 162770, 162768, 162766, 166840, 167021, 166527, 166525, 166899, 166522, 166520, 166515, 162523, 149441, 166513, 166512, 166511, 162520, 166707, 166504, 166503, 166615, 166129, 166497, 162764, 162763, 162761, 162759, 164304, 162513, 162512, 166324, 166385, 166322, 166382, 166380, 162502, 165770, 163344, 165533, 165530, 165529, 165453, 120975, 117393, 165451, 163340, 163827, 163809, 164398, 164396, 164392, 164390, 164387, 163902, 163934, 163899, 163684, 163793, 163295, 162940, 163293, 141669, 162945, 162472, 162109, 161087, 162470, 162467, 162465, 162463, 162937, 162992, 162460, 136914, 162458, 162457, 162439, 162757, 162754, 156717, 162159, 162435, 156716, 162433, 162716, 160984, 160983, 136908, 136907, 162076, 162073, 162071, 162070, 162068, 157842, 162066, 162061, 147397, 162147, 162098, 134501, 161503, 161356, 152633, 152631, 152629, 149425, 159662, 152626, 159567, 149422, 158151, 159535, 159043, 151068, 124789, 158663, 157872, 157357, 157352, 158033, 158039, 157923, 157659, 157921, 157766, 157760, 157757, 157808, 157805, 157799, 151060, 157796, 157793, 154501, 156470, 149355, 154594, 121543, 154593, 154592, 121541, 156459, 157110, 133935, 133931, 96124, 156789, 133926, 155504, 154587, 117354, 153655, 155656, 153961, 155502, 154061, 154342, 154081, 149207, 152618, 154079, 154311, 153342, 153855, 153852, 153730, 151058, 147818, 153707, 152614, 134495, 134492, 134489, 134482, 152917, 136876, 144410, 144405, 151763, 152647, 152785, 152802, 147396, 147394, 147797, 134, 147795, 147793, 150615, 152258, 136870, 152018, 152017, 149097, 149083, 149079, 136866, 149070, 136863, 151346, 136857, 151444, 136853, 150604, 136851, 149005, 149004, 150593, 151031, 150591, 151027, 148998, 150587, 148993, 150925, 148862, 148860, 148859, 148858, 136833, 148842, 148814, 148808, 149939, 148803, 149934, 136820, 148770, 148768, 148767, 148765, 148764, 148761, 147387, 149615, 148759, 136815, 136813, 136810, 136799, 147768, 136794, 147764, 136792, 136783, 136782, 136779, 121582, 147729, 147380, 136753, 147719, 136751, 147277, 147275, 147274, 147273, 136742, 136740, 136735, 147264, 146519, 147090, 136724, 147088, 136720, 146953, 146807, 145908, 145906, 145899, 145870, 146283, 136700, 146502, 145784, 145782, 136698, 146498, 146497, 146439, 146494, 146437, 145779, 146492, 145777, 146489, 136693, 146257, 146226, 145733, 145726, 136691, 144135, 136689, 136687, 145553, 112121, 145551, 136682, 145550, 140523, 145548, 112119, 145665, 145540, 141311, 136589, 141309, 139642, 139638, 141422, 141419, 141418, 141648, 140499, 140497, 141413, 141411, 141406, 142155, 139727, 139054, 134466, 136582, 136570, 136568, 136556, 137190, 136549, 136546, 141391, 136541, 139850, 139849, 141641, 141804, 140493, 140492, 140489, 140369, 140487, 140486, 140485, 138087, 140476, 141288, 137187, 137185, 141353, 141365, 140475, 141292, 140473, 140472, 140470, 140730, 140554, 140711, 140441, 140423, 140418, 140416, 140411, 140410, 139831, 139830, 136516, 136513, 136511, 136509, 136505, 140095, 138616, 138595, 136499, 139559, 138593, 124931, 136497, 136496, 136494, 136492, 136490, 136488, 136486, 135276, 135274, 136484, 136478, 136476, 136471, 136470, 136462, 136452, 136451, 136449, 136447, 136440, 136438, 136434, 136432, 136425, 138472, 136423, 136421, 136419, 137806, 117004, 126910, 137804, 133810, 138096, 137802, 137801, 136411, 136409, 137433, 136251, 129564, 135516, 120968, 129552, 130030, 135148, 134429, 134424, 134423, 134421, 125, 134409, 134408, 129944, 134387, 129936, 129935, 129933, 129932, 133769, 126472, 133445, 124041, 133438, 126451, 133568, 133436, 129482, 129481, 123651, 129886, 130161, 128075, 123646, 126724, 129877, 129696, 129361, 129211, 129148, 124902, 124900, 128560, 128558, 128555, 126411, 125761, 125759, 125758, 128035, 127379, 126402, 125736, 126946, 127455, 124884, 127494, 127449, 124882, 127373, 127261, 127369, 127368, 124873, 124871, 124869, 124868, 126789, 126787, 126785, 126782, 126781, 126779, 126937, 126860, 124840, 126696, 126341, 126337, 126336, 123381, 126334, 125327, 126096, 125496, 124829, 124827, 125661, 126074, 124818, 126069, 125524, 126065, 125651, 125649, 123814, 121570, 125646, 124808, 125531, 119405, 125560, 119403, 119401, 119394, 119392, 119390, 119388, 119384, 125468, 119381, 119376, 125294, 125292, 125291, 124805, 125289, 125288, 125286, 125268, 125267, 85304, 125265, 125252, 125158, 84377, 84376, 120144, 122800, 124358, 124797, 124721, 124718, 124715, 59161, 59157, 123851, 59155, 115921, 115919, 124545, 59153, 120813, 124180, 123632, 124010, 124003, 123996, 124198, 124196, 124191, 124189, 124177, 123618, 123615, 124137, 124103, 123548, 123611, 123897, 118265, 123791, 123590, 123783, 123581, 123788, 123577, 123786, 123781, 120966, 123495, 123371, 123489, 123493, 123364, 100316, 123285, 121524, 115264, 115262, 115261, 120233, 115258, 115256, 115254, 122967, 122959, 122957, 59147, 121386, 122790, 122237, 122755, 122717, 116862, 115246, 87093, 121508, 121068, 122111, 121828, 121503, 121502, 115238, 115229, 115227, 115225, 121499, 121547, 92397, 121201, 92395, 112766, 112764, 92392, 120944, 92390, 92388, 115205, 117856, 92386, 115195, 92382, 117732, 117854, 117726, 92380, 92377, 120858, 92375, 92373, 113965, 113958, 115141, 92369, 92367, 92366, 92364, 92362, 92359, 92357, 118702, 114328, 92346, 92342, 92340, 115006, 115004, 118113, 92338, 117951, 114998, 118103, 117832, 92336, 116473, 117902, 117901, 117066, 117899, 117785, 117064, 117043, 117012, 115986, 116974, 116988, 116841, 116568, 116986, 116984, 115698, 116635, 92334, 84362, 84361, 92332, 116633, 116632, 116628, 116799, 116666, 102285, 116664, 113952, 113951, 116662, 115660, 116625, 116402, 116622, 116620, 116400, 116398, 116617, 116616, 114920, 100143, 100141, 115294, 116488, 114603, 116407, 116417, 116414, 116413, 92331, 92329, 100135, 100133, 100131, 100130, 100128, 100126, 116201, 114902, 100124, 100122, 100120, 92327, 100118, 100116, 100115, 92325, 100099, 100097, 100095, 92323, 92317, 114307, 114857, 115858, 115767, 114300, 115848, 113570, 102612, 115558, 114757, 115283, 114657, 114770, 114749, 114768, 113425, 114424, 82332, 114653, 113530, 113527, 113526, 102605, 113522, 113510, 92313, 113506, 96606, 96605, 114443, 92311, 113941, 92310, 102599, 92305, 113813, 113313, 97786, 97780, 100089, 72106, 100087, 113891, 92303, 92299, 113805, 92292, 92286, 113598, 113434, 92283, 113596, 92280, 113485, 113387, 113482, 113595, 113377, 113467, 113371, 113427, 113398, 113364, 111480, 92276, 92274, 92269, 111509, 113096, 92267, 112620, 113030, 92259, 72103, 112855, 92255, 80173, 111644, 80163, 92251, 92250, 112600, 92238, 92235, 112474, 112539, 112431, 112467, 112152, 112429, 112451, 92231, 112415, 92229, 112265, 79309, 79304, 92224, 79302, 92222, 92221, 103330, 92217, 92211, 112292, 102128, 112178, 103328, 111791, 111743, 111754, 112136, 92209, 111068, 111753, 111841, 92207, 111836, 111807, 111804, 111782, 111795, 92203, 111632, 110986, 110955, 92202, 111658, 111630, 111675, 79299, 111531, 101300, 79297, 92200, 111453, 111142, 97244, 111441, 110953, 111140, 111139, 110944, 110942, 92198, 102584, 110939, 110938, 102582, 102580, 102579, 111064, 111062, 110980, 92196, 101201, 103320, 101293, 110795, 92195, 79295, 92193, 79293, 103055, 103044, 101290, 103042, 103040, 103038, 101287, 103036, 102264, 103180, 103034, 102946, 103032, 92190, 102547, 103007, 101192, 103028, 102994, 102354, 102541, 102718, 102187, 102538, 102337, 102536, 102057, 102331, 102525, 102524, 102520, 102519, 102487, 102081, 102485, 92183, 102317, 92174, 92172, 92170, 102071, 102087, 92168, 92167, 101691, 92164, 96049, 101688, 101686, 101685, 101723, 92162, 92159, 101284, 95240, 101282, 101390, 98712, 101352, 100712, 88752, 100382, 100380, 99027, 100702, 99025, 101219, 101217, 100307, 101215, 101007, 101003, 100999, 100997, 101211, 86369, 101184, 80154, 100869, 100805, 100300, 100695, 100522, 99018, 67800, 100298, 100644, 100693, 99016, 67798, 99971, 99585, 99969, 100679, 99010, 100638, 96040, 100430, 96039, 73726, 100497, 100413, 100274, 100272, 100268, 100069, 100264, 99417, 73718, 98886, 100261, 100255, 100253, 99415, 97107, 98884, 99944, 96029, 96027, 96025, 99922, 95513, 95511, 95507, 95505, 95503, 97094, 95501, 95499, 95497, 97045, 95495, 95493, 95491, 96297, 97011, 96279, 96918, 96274, 96271, 96868, 96884, 96469, 95416, 96464, 96460, 96458, 96640, 96233, 90597, 96670, 96455, 96635, 96452, 96440, 96240, 95889, 96238, 89033, 93870, 95751, 95743, 95104, 95741, 95400, 95393, 95555, 95202, 95059, 94327, 95055, 93832, 93825, 94699, 89312, 94458, 94454, 79283, 94440, 94438, 93719, 93078, 93283, 93280, 93278, 93275, 93273, 93268, 93131, 80254, 93121, 93019, 91896, 93014, 90079, 91877, 91875, 91873, 89712, 92578, 92526, 89709, 91846, 91840, 91834, 91832, 91788, 89846, 89838, 89831, 89896, 89651, 89938, 89935, 89798, 89701, 86556, 89308, 89269, 89306, 88684, 88802, 88501, 88592, 89193, 88039, 88820, 88682, 88708, 76857, 76851, 88151, 59636, 84351, 87172, 86981, 79270, 86273, 59634, 87409, 87157, 86267, 87226, 87153, 86246, 87213, 87350, 86685, 86230, 86223, 85727, 85722, 85436, 85960, 85097, 73708, 86001, 67758, 81022, 79919, 84988, 84826, 83643, 83640, 83455, 84080, 83638, 83097, 83095, 83445, 83443, 82796, 82794, 82378, 81906, 82943, 81900, 79751, 82373, 81670, 81898, 82370, 74874, 81535, 81788, 81017, 81229, 82408, 81225, 81007, 82237, 82234, 81042, 81868, 80999, 81661, 81108, 79725, 80810, 80298, 80632, 77765, 80626, 79976, 59121, 78489, 79917, 79974, 80388, 80197, 79970, 80192, 78949, 78947, 79683, 77763, 78651, 72718, 76818, 74762, 76230, 76226, 74190, 72269, 66332, 73325, 71702, 71480, 69979, 69963, 70512, 70651, 70138, 70147, 64822, 66507, 67325, 66857, 66505, 66851, 58762, 64599, 64597, 62734, 64207, 58754, 64204, 66328, 64593, 64584, 64576, 66187, 64573, 57915, 64567, 64565, 65589, 62280, 60338, 63244, 60794, 64288, 64071, 63219, 56897, 62189, 61708, 61133, 62180, 61703, 56402, 64009, 56971, 56969, 62942))
Run Time: 0.106483
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2034 | |
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 | | | | | 2034 | |
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 (16935, 13700, 13096, 12998, 12489, 12275, 11982, 11955, 11902, 11803, 11745, 11724, 11655, 11204, 11159, 11105, 10855, 10678, 10348, 9090, 9059, 9034, 8998, 8997, 8952, 8925, 8905, 8726, 8711, 8511, 8492, 8447, 8407, 8350, 8291, 8282, 8266, 8261, 8254, 7871, 7822, 7681, 7400, 7332, 7271, 7176, 6411, 5875, 5864))
Run Time: 0.002554
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 49 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `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 (270567, 298890, 183936, 295785, 295783, 295781, 172023, 293810, 293830, 183934, 183932, 183929, 204300, 286574, 96794, 285852, 277775, 277774, 277772, 277771, 183922, 183921, 279671, 279670, 193767, 147400, 283010, 183918, 279601, 34635, 282614, 282834, 183915, 282608, 279427, 270824, 183912, 270822, 270820, 183909, 183908, 183906, 183903, 273072, 271571, 265114, 272868, 183902, 271617, 271555, 271554, 271553, 271549, 271546, 183900, 183899, 271568, 183898, 265051, 183890, 183888, 183885, 183883, 183881, 183879, 183874, 183872, 183869, 183868, 183866, 270910, 83476, 269908, 270494, 269864, 268308, 269710, 204295, 204293, 204291, 41693, 183864, 183862, 183860, 268051, 269379, 183859, 267495, 204289, 267147, 267490, 267488, 268046, 267466, 267461, 267460, 268676, 268304, 267941, 267454, 267453, 267930, 258343, 83469, 83468, 83466, 183855, 267444, 267435, 267433, 267423, 267422, 267417, 267411, 267410, 267921, 267919, 267917, 267916, 265046, 266410, 267727, 267396, 83460, 258757, 265043, 263776, 267393, 265110, 265109, 263562, 265264, 266515, 266513, 254671, 266353, 261654, 261652, 261650, 266349, 265101, 265097, 265092, 96179, 265559, 265259, 265256, 183853, 265218, 265183, 265039, 264921, 264316, 183852, 265057, 264307, 183850, 183848, 264305, 264304, 264713, 183847, 183845, 264864, 264829, 264816, 264291, 264286, 264284, 264800, 147399, 264235, 264222, 183833, 183830, 263632, 175217, 263676, 263674, 263673, 263582, 263667, 262374, 263580, 263579, 263576, 263575, 263329, 259836, 262201, 262457, 255491, 262454, 262452, 262444, 262442, 261627, 262440, 255483, 255481, 261630, 261629, 183827, 258750, 261623, 259968, 261587, 113980, 141362, 261422, 183826, 183824, 254723, 260456, 260455, 260454, 259825, 260450, 260447, 259820, 260440, 259817, 142953, 260048, 257623, 250582, 259769, 259099, 259098, 259096, 258726, 258600, 258328, 183820, 257231, 257778, 257777, 255869, 258319, 258080, 193764, 257736, 257613, 256868, 193760, 257610, 257609, 257516, 257222, 256862, 256963, 249500, 249498, 255863, 255479, 256555, 256553, 256641, 256405, 256400, 256398, 256396, 256395, 256392, 256390, 256383, 255467, 255462, 250362, 250360, 250358, 255459, 155245, 250354, 255891, 250352, 255866, 255454, 255419, 255451, 255285, 255450, 255444, 152332, 255413, 117537, 255389, 255260, 254634, 254632, 155242, 253556, 254955, 254953, 254951, 254653, 254651, 183805, 117529, 183803, 253548, 183799, 253536, 253533, 253528, 253524, 253522, 253519, 253517, 253832, 251008, 253511, 247878, 253508, 204288, 253503, 250331, 253337, 253333, 253219, 249461, 250288, 167032, 250284, 250283, 250230, 250229, 250221, 250201, 250198, 250196, 250194, 250191, 250185, 250179, 249460, 250157, 250154, 250982, 250973, 250971, 250969, 250089, 250085, 250072, 250069, 250055, 204283, 183796, 183789, 183786, 204281, 204277, 204275, 204265, 204257, 249062, 204241, 193757, 204228, 204227, 204226, 204220, 248337, 204210, 204208, 247713, 142918, 204199, 142916, 172016, 172009, 222520, 222519, 208463, 222309, 208169, 208306, 208159, 206932, 204137, 207375, 204327, 193753, 202973, 202971, 204785, 204781, 204778, 184955, 204776, 206575, 204768, 204575, 202949, 202946, 204371, 202944, 204197, 184950, 204346, 203905, 204333, 204191, 204188, 202937, 204183, 203771, 203769, 203889, 203876, 203742, 203443, 202932, 203426, 203524, 202931, 202929, 202922, 201855, 201853, 202041, 202914, 202884, 194389, 202337, 202333, 117470, 190015, 194384, 201783, 201781, 201370, 201772, 201368, 201364, 201358, 192624, 193736, 162802, 193721, 195179, 193716, 193701, 185248, 185247, 143196, 185243, 143194, 194908, 194813, 194810, 194809, 194877, 194875, 194873, 142833, 193934, 194802, 162801, 194612, 193868, 193691, 193865, 193809, 194082, 193654, 194006, 193672, 193668, 186071, 193217, 193182, 193172, 192881, 192877, 192144, 192737, 192733, 192732, 165385, 192725, 173958, 174759, 192142, 191997, 192135, 191979, 192124, 191041, 190723, 190337, 190353, 189506, 190071, 189799, 144154, 144148, 144146, 189155, 187918, 188176, 187875, 187254, 187870, 136958, 187855, 187101, 187690, 136955, 136953, 187844, 187688, 187686, 136949, 136947, 136945, 187222, 187371, 155224, 155222, 187252, 187243, 187277, 186007, 187275, 187274, 144530, 144527, 187205, 187202, 187200, 187198, 183768, 182617, 187092, 186954, 184145, 183753, 183751, 186106, 183749, 185533, 183744, 183743, 183739, 183443, 117432, 183734, 182117, 185523, 185202, 185200, 183731, 183729, 183727, 144516, 185196, 144511, 144509, 185191, 144507, 136940, 136936, 183176, 185013, 185029, 136932, 136929, 171992, 184356, 184355, 144494, 184345, 184343, 184342, 182103, 182101, 123416, 184158, 144481, 183437, 182096, 184155, 144471, 183722, 184019, 183716, 182077, 182075, 174891, 174888, 174883, 174880, 174876, 174875, 174873, 174869, 174864, 182069, 183678, 174862, 183675, 183468, 174856, 183375, 174854, 174852, 183424, 174850, 172943, 182566, 175516, 183302, 183105, 181703, 174843, 182364, 181741, 182021, 182019, 182017, 181737, 181550, 181723, 181719, 181709, 181711, 144457, 161918, 175082, 144444, 144436, 162798, 175233, 174653, 175075, 172494, 162796, 174816, 174813, 172887, 172885, 174808, 173791, 18247, 165346, 162744, 173924, 172789, 171990, 171988, 171987, 171978, 173297, 173789, 144424, 173465, 173543, 173531, 173526, 141538, 141536, 141527, 173294, 173065, 173278, 173096, 170818, 170815, 172860, 157366, 172734, 172652, 157954, 147822, 171146, 171960, 155212, 171142, 171140, 155210, 155208, 171452, 170813, 171121, 171272, 170579, 171037, 171022, 171066, 171016, 171015, 169634, 170719, 170717, 170929, 170927, 170305, 170228, 162794, 169765, 162788, 169749, 169582, 165729, 169592, 169574, 169571, 169255, 155200, 169240, 169129, 136921, 155196, 169019, 168896, 168890, 168717, 157936, 155191, 48348, 48345, 162779, 162778, 168526, 167508, 168523, 167502, 167123, 168152, 142780, 167980, 167978, 167962, 142777, 166538, 153918, 166151, 142775, 162532, 155891, 166535, 166530, 162776, 162775, 166528, 162770, 162768, 162766, 166840, 167021, 166527, 166525, 166899, 166522, 166520, 166515, 162523, 149441, 166513, 166512, 166511, 162520, 166707, 166504, 166503, 166615, 166129, 166497, 162764, 162763, 162761, 162759, 164304, 162513, 162512, 166324, 166385, 166322, 166382, 166380, 162502, 165770, 163344, 165533, 165530, 165529, 165453, 120975, 117393, 165451, 163340, 163827, 163809, 164398, 164396, 164392, 164390, 164387, 163902, 163934, 163899, 163684, 163793, 163295, 162940, 163293, 141669, 162945, 162472, 162109, 161087, 162470, 162467, 162465, 162463, 162937, 162992, 162460, 136914, 162458, 162457, 162439, 162757, 162754, 156717, 162159, 162435, 156716, 162433, 162716, 160984, 160983, 136908, 136907, 162076, 162073, 162071, 162070, 162068, 157842, 162066, 162061, 147397, 162147, 162098, 134501, 161503, 161356, 152633, 152631, 152629, 149425, 159662, 152626, 159567, 149422, 158151, 159535, 159043, 151068, 124789, 158663, 157872, 157357, 157352, 158033, 158039, 157923, 157659, 157921, 157766, 157760, 157757, 157808, 157805, 157799, 151060, 157796, 157793, 154501, 156470, 149355, 154594, 121543, 154593, 154592, 121541, 156459, 157110, 133935, 133931, 96124, 156789, 133926, 155504, 154587, 117354, 153655, 155656, 153961, 155502, 154061, 154342, 154081, 149207, 152618, 154079, 154311, 153342, 153855, 153852, 153730, 151058, 147818, 153707, 152614, 134495, 134492, 134489, 134482, 152917, 136876, 144410, 144405, 151763, 152647, 152785, 152802, 147396, 147394, 147797, 134, 147795, 147793, 150615, 152258, 136870, 152018, 152017, 149097, 149083, 149079, 136866, 149070, 136863, 151346, 136857, 151444, 136853, 150604, 136851, 149005, 149004, 150593, 151031, 150591, 151027, 148998, 150587, 148993, 150925, 148862, 148860, 148859, 148858, 136833, 148842, 148814, 148808, 149939, 148803, 149934, 136820, 148770, 148768, 148767, 148765, 148764, 148761, 147387, 149615, 148759, 136815, 136813, 136810, 136799, 147768, 136794, 147764, 136792, 136783, 136782, 136779, 121582, 147729, 147380, 136753, 147719, 136751, 147277, 147275, 147274, 147273, 136742, 136740, 136735, 147264, 146519, 147090, 136724, 147088, 136720, 146953, 146807, 145908, 145906, 145899, 145870, 146283, 136700, 146502, 145784, 145782, 136698, 146498, 146497, 146439, 146494, 146437, 145779, 146492, 145777, 146489, 136693, 146257, 146226, 145733, 145726, 136691, 144135, 136689, 136687, 145553, 112121, 145551, 136682, 145550, 140523, 145548, 112119, 145665, 145540, 141311, 136589, 141309, 139642, 139638, 141422, 141419, 141418, 141648, 140499, 140497, 141413, 141411, 141406, 142155, 139727, 139054, 134466, 136582, 136570, 136568, 136556, 137190, 136549, 136546, 141391, 136541, 139850, 139849, 141641, 141804, 140493, 140492, 140489, 140369, 140487, 140486, 140485, 138087, 140476, 141288, 137187, 137185, 141353, 141365, 140475, 141292, 140473, 140472, 140470, 140730, 140554, 140711, 140441, 140423, 140418, 140416, 140411, 140410, 139831, 139830, 136516, 136513, 136511, 136509, 136505, 140095, 138616, 138595, 136499, 139559, 138593, 124931, 136497, 136496, 136494, 136492, 136490, 136488, 136486, 135276, 135274, 136484, 136478, 136476, 136471, 136470, 136462, 136452, 136451, 136449, 136447, 136440, 136438, 136434, 136432, 136425, 138472, 136423, 136421, 136419, 137806, 117004, 126910, 137804, 133810, 138096, 137802, 137801, 136411, 136409, 137433, 136251, 129564, 135516, 120968, 129552, 130030, 135148, 134429, 134424, 134423, 134421, 125, 134409, 134408, 129944, 134387, 129936, 129935, 129933, 129932, 133769, 126472, 133445, 124041, 133438, 126451, 133568, 133436, 129482, 129481, 123651, 129886, 130161, 128075, 123646, 126724, 129877, 129696, 129361, 129211, 129148, 124902, 124900, 128560, 128558, 128555, 126411, 125761, 125759, 125758, 128035, 127379, 126402, 125736, 126946, 127455, 124884, 127494, 127449, 124882, 127373, 127261, 127369, 127368, 124873, 124871, 124869, 124868, 126789, 126787, 126785, 126782, 126781, 126779, 126937, 126860, 124840, 126696, 126341, 126337, 126336, 123381, 126334, 125327, 126096, 125496, 124829, 124827, 125661, 126074, 124818, 126069, 125524, 126065, 125651, 125649, 123814, 121570, 125646, 124808, 125531, 119405, 125560, 119403, 119401, 119394, 119392, 119390, 119388, 119384, 125468, 119381, 119376, 125294, 125292, 125291, 124805, 125289, 125288, 125286, 125268, 125267, 85304, 125265, 125252, 125158, 84377, 84376, 120144, 122800, 124358, 124797, 124721, 124718, 124715, 59161, 59157, 123851, 59155, 115921, 115919, 124545, 59153, 120813, 124180, 123632, 124010, 124003, 123996, 124198, 124196, 124191, 124189, 124177, 123618, 123615, 124137, 124103, 123548, 123611, 123897, 118265, 123791, 123590, 123783, 123581, 123788, 123577, 123786, 123781, 120966, 123495, 123371, 123489, 123493, 123364, 100316, 123285, 121524, 115264, 115262, 115261, 120233, 115258, 115256, 115254, 122967, 122959, 122957, 59147, 121386, 122790, 122237, 122755, 122717, 116862, 115246, 87093, 121508, 121068, 122111, 121828, 121503, 121502, 115238, 115229, 115227, 115225, 121499, 121547, 92397, 121201, 92395, 112766, 112764, 92392, 120944, 92390, 92388, 115205, 117856, 92386, 115195, 92382, 117732, 117854, 117726, 92380, 92377, 120858, 92375, 92373, 113965, 113958, 115141, 92369, 92367, 92366, 92364, 92362, 92359, 92357, 118702, 114328, 92346, 92342, 92340, 115006, 115004, 118113, 92338, 117951, 114998, 118103, 117832, 92336, 116473, 117902, 117901, 117066, 117899, 117785, 117064, 117043, 117012, 115986, 116974, 116988, 116841, 116568, 116986, 116984, 115698, 116635, 92334, 84362, 84361, 92332, 116633, 116632, 116628, 116799, 116666, 102285, 116664, 113952, 113951, 116662, 115660, 116625, 116402, 116622, 116620, 116400, 116398, 116617, 116616, 114920, 100143, 100141, 115294, 116488, 114603, 116407, 116417, 116414, 116413, 92331, 92329, 100135, 100133, 100131, 100130, 100128, 100126, 116201, 114902, 100124, 100122, 100120, 92327, 100118, 100116, 100115, 92325, 100099, 100097, 100095, 92323, 92317, 114307, 114857, 115858, 115767, 114300, 115848, 113570, 102612, 115558, 114757, 115283, 114657, 114770, 114749, 114768, 113425, 114424, 82332, 114653, 113530, 113527, 113526, 102605, 113522, 113510, 92313, 113506, 96606, 96605, 114443, 92311, 113941, 92310, 102599, 92305, 113813, 113313, 97786, 97780, 100089, 72106, 100087, 113891, 92303, 92299, 113805, 92292, 92286, 113598, 113434, 92283, 113596, 92280, 113485, 113387, 113482, 113595, 113377, 113467, 113371, 113427, 113398, 113364, 111480, 92276, 92274, 92269, 111509, 113096, 92267, 112620, 113030, 92259, 72103, 112855, 92255, 80173, 111644, 80163, 92251, 92250, 112600, 92238, 92235, 112474, 112539, 112431, 112467, 112152, 112429, 112451, 92231, 112415, 92229, 112265, 79309, 79304, 92224, 79302, 92222, 92221, 103330, 92217, 92211, 112292, 102128, 112178, 103328, 111791, 111743, 111754, 112136, 92209, 111068, 111753, 111841, 92207, 111836, 111807, 111804, 111782, 111795, 92203, 111632, 110986, 110955, 92202, 111658, 111630, 111675, 79299, 111531, 101300, 79297, 92200, 111453, 111142, 97244, 111441, 110953, 111140, 111139, 110944, 110942, 92198, 102584, 110939, 110938, 102582, 102580, 102579, 111064, 111062, 110980, 92196, 101201, 103320, 101293, 110795, 92195, 79295, 92193, 79293, 103055, 103044, 101290, 103042, 103040, 103038, 101287, 103036, 102264, 103180, 103034, 102946, 103032, 92190, 102547, 103007, 101192, 103028, 102994, 102354, 102541, 102718, 102187, 102538, 102337, 102536, 102057, 102331, 102525, 102524, 102520, 102519, 102487, 102081, 102485, 92183, 102317, 92174, 92172, 92170, 102071, 102087, 92168, 92167, 101691, 92164, 96049, 101688, 101686, 101685, 101723, 92162, 92159, 101284, 95240, 101282, 101390, 98712, 101352, 100712, 88752, 100382, 100380, 99027, 100702, 99025, 101219, 101217, 100307, 101215, 101007, 101003, 100999, 100997, 101211, 86369, 101184, 80154, 100869, 100805, 100300, 100695, 100522, 99018, 67800, 100298, 100644, 100693, 99016, 67798, 99971, 99585, 99969, 100679, 99010, 100638, 96040, 100430, 96039, 73726, 100497, 100413, 100274, 100272, 100268, 100069, 100264, 99417, 73718, 98886, 100261, 100255, 100253, 99415, 97107, 98884, 99944, 96029, 96027, 96025, 99922, 95513, 95511, 95507, 95505, 95503, 97094, 95501, 95499, 95497, 97045, 95495, 95493, 95491, 96297, 97011, 96279, 96918, 96274, 96271, 96868, 96884, 96469, 95416, 96464, 96460, 96458, 96640, 96233, 90597, 96670, 96455, 96635, 96452, 96440, 96240, 95889, 96238, 89033, 93870, 95751, 95743, 95104, 95741, 95400, 95393, 95555, 95202, 95059, 94327, 95055, 93832, 93825, 94699, 89312, 94458, 94454, 79283, 94440, 94438, 93719, 93078, 93283, 93280, 93278, 93275, 93273, 93268, 93131, 80254, 93121, 93019, 91896, 93014, 90079, 91877, 91875, 91873, 89712, 92578, 92526, 89709, 91846, 91840, 91834, 91832, 91788, 89846, 89838, 89831, 89896, 89651, 89938, 89935, 89798, 89701, 86556, 89308, 89269, 89306, 88684, 88802, 88501, 88592, 89193, 88039, 88820, 88682, 88708, 76857, 76851, 88151, 59636, 84351, 87172, 86981, 79270, 86273, 59634, 87409, 87157, 86267, 87226, 87153, 86246, 87213, 87350, 86685, 86230, 86223, 85727, 85722, 85436, 85960, 85097, 73708, 86001, 67758, 81022, 79919, 84988, 84826, 83643, 83640, 83455, 84080, 83638, 83097, 83095, 83445, 83443, 82796, 82794, 82378, 81906, 82943, 81900, 79751, 82373, 81670, 81898, 82370, 74874, 81535, 81788, 81017, 81229, 82408, 81225, 81007, 82237, 82234, 81042, 81868, 80999, 81661, 81108, 79725, 80810, 80298, 80632, 77765, 80626, 79976, 59121, 78489, 79917, 79974, 80388, 80197, 79970, 80192, 78949, 78947, 79683, 77763, 78651, 72718, 76818, 74762, 76230, 76226, 74190, 72269, 66332, 73325, 71702, 71480, 69979, 69963, 70512, 70651, 70138, 70147, 64822, 66507, 67325, 66857, 66505, 66851, 58762, 64599, 64597, 62734, 64207, 58754, 64204, 66328, 64593, 64584, 64576, 66187, 64573, 57915, 64567, 64565, 65589, 62280, 60338, 63244, 60794, 64288, 64071, 63219, 56897, 62189, 61708, 61133, 62180, 61703, 56402, 64009, 56971, 56969, 62942))
Run Time: 0.035530
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2034 | |
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 | | | | | 2034 | |
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 view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, �ª
Run Time: 0.000333
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=1738, 1717180268, , 0, �ª
Run Time: 0.000217
- 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.000494
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 158
- 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.000508
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 158
- 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: 1717179968
Run Time: 0.000286
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 13 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
- XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Repository/SessionActivity.php at line 62
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*, `xf_user_User_1`.*
FROM `xf_session_activity`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1717179968)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000599
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 13 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | my_webapp.xf_session_activity.user_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivity.php at line 43
- XF\Repository\SessionActivity->getOnlineUsersList() in src/XF/Repository/SessionActivity.php at line 63
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20