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.000704
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.000250
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` = '4583')
LIMIT 1
Run Time: 0.000722
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.003253
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_4583' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.122139
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 (499596, 108608, 499594, 108606, 429104, 219443, 499592, 473571, 108603, 108597, 428972, 243884, 108594, 428961, 108591, 428957, 362463, 219368, 362461, 232456, 428933, 428929, 232423, 219351, 219349, 219347, 219345, 232421, 428888, 473564, 243875, 243874, 219342, 428878, 528360, 243854, 528358, 428814, 243845, 428812, 388273, 428810, 219321, 528357, 243828, 243824, 232380, 528354, 219304, 528349, 243821, 232378, 528347, 528345, 232370, 528343, 528341, 528337, 528333, 528330, 528328, 428771, 528318, 528313, 528311, 528309, 428763, 528305, 243807, 232345, 219225, 219215, 473561, 428686, 428681, 404714, 404702, 219210, 219207, 219202, 219200, 473559, 232324, 428657, 428655, 428649, 219192, 404685, 362430, 243796, 428581, 493532, 232302, 493530, 232295, 232292, 232290, 493528, 473553, 428503, 493513, 428497, 428470, 243718, 428467, 243716, 243714, 243712, 388257, 428464, 108579, 388253, 388251, 428434, 388249, 243710, 243708, 243706, 388245, 243703, 243698, 219123, 243684, 243681, 243678, 514525, 428407, 428399, 428397, 428395, 428354, 428352, 219110, 232278, 428339, 219105, 388233, 428336, 428334, 388231, 428304, 219095, 428300, 428295, 428287, 428282, 243652, 428267, 519781, 428262, 519779, 519777, 428256, 428254, 428252, 219087, 519770, 388227, 519762, 519760, 219083, 519755, 428225, 428219, 404673, 519753, 428186, 428184, 428182, 428179, 428177, 232262, 428175, 219072, 108569, 108560, 428165, 428154, 514516, 428126, 428124, 108552, 388222, 108542, 519752, 519746, 519744, 243637, 243633, 243631, 219034, 243629, 232252, 428014, 428012, 428008, 243619, 219027, 428003, 232246, 388219, 388217, 427993, 427983, 427981, 427966, 232238, 427964, 427949, 427946, 108535, 427942, 514509, 218966, 232226, 232218, 218955, 243610, 218953, 218951, 388214, 388212, 388209, 388202, 388197, 388191, 388188, 427858, 108508, 108506, 232188, 108503, 232186, 108501, 243604, 108484, 514477, 108482, 232164, 108467, 108464, 108459, 108454, 108450, 218884, 108447, 108445, 108424, 108422, 232155, 108420, 108418, 232153, 108415, 218878, 232143, 232141, 243577, 232138, 243573, 218852, 243571, 514474, 514472, 232108, 243561, 243557, 232101, 514465, 514463, 514460, 427718, 232094, 243546, 362421, 232092, 362419, 232089, 427712, 362416, 218816, 218813, 218807, 218797, 218792, 218790, 218775, 362410, 309312, 232082, 218750, 218747, 218743, 218730, 494813, 218724, 218720, 427681, 232061, 427677, 473539, 427664, 309309, 473533, 427662, 427660, 309307, 243524, 473531, 243522, 427644, 232045, 427634, 427631, 427620, 243512, 388185, 388182, 388180, 427605, 388178, 473527, 473524, 427575, 473521, 427573, 218650, 243505, 427570, 473517, 218639, 108388, 108386, 218630, 427545, 218627, 108384, 243490, 243485, 427503, 243483, 427491, 243480, 243478, 218613, 218609, 218606, 392923, 427467, 427465, 232031, 427455, 392921, 232029, 232025, 362389, 232017, 427444, 427442, 232003, 362386, 427432, 243459, 427430, 427427, 362382, 243457, 427424, 362376, 427412, 427407, 243447, 243443, 427382, 427349, 427339, 427336, 427332, 427329, 427323, 231998, 231994, 493505, 493502, 231990, 493500, 231987, 231980, 493497, 427296, 218597, 309296, 427252, 427250, 427224, 427222, 243423, 427218, 243421, 243418, 108374, 231965, 243409, 231963, 427167, 231957, 427165, 427161, 218586, 427157, 218584, 231955, 427147, 243396, 427143, 231948, 108371, 427127, 108365, 427125, 108363, 108361, 493469, 108359, 493467, 218579, 108342, 108337, 218571, 507321, 231919, 218564, 231917, 427111, 427109, 427103, 427101, 427097, 108318, 231909, 427083, 231902, 427081, 309287, 243369, 218521, 427009, 218489, 231876, 231873, 231870, 243309, 108302, 231860, 108291, 108288, 108285, 309187, 309185, 426911, 309183, 426909, 231846, 309176, 231844, 426901, 309154, 309141, 309139, 426898, 426896, 218466, 505885, 243280, 218438, 426835, 243269, 501294, 243247, 243245, 243242, 243239, 243237, 243235, 243231, 231820, 243230, 231814, 426778, 243221, 426776, 231811, 243215, 426772, 243208, 231808, 243205, 493464, 218411, 426766, 426761, 426759, 426757, 231779, 499587, 426753, 231746, 426734, 426730, 494805, 494803, 426727, 426725, 218389, 218385, 426691, 218383, 426689, 218378, 243181, 243180, 243171, 218371, 243169, 218367, 218365, 218356, 494800, 231695, 243162, 231693, 231691, 243159, 243157, 426658, 243156, 218348, 218345, 218341, 426629, 218335, 243091, 243085, 243078, 243072, 426593, 243068, 243065, 231568, 231566, 218332, 218329, 218327, 218325, 218313, 243053, 243051, 243048, 218301, 231562, 388176, 426569, 243042, 243039, 243037, 388173, 388171, 388169, 426567, 426565, 231531, 108269, 218290, 426563, 108267, 426561, 108264, 231529, 426557, 426542, 426535, 426533, 426531, 426511, 426504, 426498, 426495, 426490, 231523, 426484, 426480, 388165, 426477, 231520, 426472, 426470, 426466, 426463, 108243, 231516, 499563, 426460, 218267, 426458, 426456, 426454, 426451, 231514, 426449, 426444, 231500, 231497, 231495, 231493, 231490, 243022, 243020, 426435, 426433, 231455, 426430, 243012, 426416, 218255, 426410, 426407, 218252, 243009, 231433, 243003, 426375, 426372, 426350, 493444, 218247, 108239, 426281, 493433, 426254, 500915, 243001, 231427, 309000, 308998, 500894, 308996, 500892, 308991, 218194, 231412, 218188, 274651, 218184, 218181, 231398, 426223, 231386, 426220, 218172, 218164, 242970, 218162, 231366, 231364, 242967, 231360, 231357, 218153, 426198, 108221, 242964, 108210, 218148, 242962, 242960, 108207, 108203, 108201, 108199, 108197, 108195, 108193, 108191, 231314, 426175, 426173, 426171, 426169, 426167, 426165, 426163, 426161, 231312, 231310, 231308, 231303, 426158, 242949, 426156, 426151, 388157, 426089, 308977, 308974, 426086, 308972, 308960, 308958, 231297, 231295, 426073, 231286, 426058, 393820, 218096, 426055, 426026, 231273, 426024, 218087, 426021, 108165, 393814, 231271, 218073, 231265, 426015, 218069, 218067, 231262, 231260, 231257, 231251, 231249, 231247, 425999, 425997, 425995, 425993, 425990, 425987, 425984, 425979, 425974, 425970, 425966, 425956, 108161, 242922, 231179, 108159, 242920, 108157, 242914, 242912, 242906, 218049, 108155, 108150, 218046, 108148, 425947, 425945, 108122, 218039, 108120, 218034, 108109, 108104, 108102, 108099, 108096, 108085, 218025, 108081, 425909, 108078, 218008, 218004, 425871, 217980, 493421, 425834, 231132, 231130, 493409, 217958, 425811, 217954, 493406, 493404, 493402, 493400, 493398, 493396, 217950, 493394, 493388, 493382, 493380, 493362, 425759, 493353, 231101, 217934, 217927, 217925, 425728, 425720, 425718, 425715, 108075, 242863, 231090, 217923, 231084, 242853, 217920, 231082, 231074, 231060, 231058, 231056, 493350, 217908, 231041, 231039, 231037, 231035, 231033, 231031, 231029, 231027, 231025, 217902, 217900, 231017, 217894, 231008, 242811, 242809, 242807, 230999, 217892, 242799, 242797, 393810, 217879, 217877, 242790, 217868, 404669, 404666, 404663, 425648, 230976, 242762, 491419, 230965, 242760, 230954, 242750, 230942, 230921, 230916, 230911, 242744, 230909, 217811, 230903, 230900, 230898, 217809, 425579, 230896, 230895, 425574, 230882, 425560, 425555, 230878, 476778, 425551, 425527, 425524, 425521, 217802, 242724, 242722, 230867, 425508, 476774, 230858, 476772, 476770, 476767, 476765, 476763, 476761, 230854, 476759, 476757, 230852, 489816, 425502, 230846, 242707, 242703, 489811, 242700, 230842, 242697, 230840, 242690, 242688, 230824, 489806, 242680, 217789, 425496, 420727, 217772, 425489, 242672, 420724, 405539, 420719, 420717, 242654, 425458, 425449, 242652, 420707, 420699, 242638, 108068, 108064, 420696, 420692, 420690, 108058, 217736, 308902, 308900, 108056, 217734, 308897, 217731, 308885, 308870, 308868, 308864, 308862, 308860, 308857, 425408, 425406, 217725, 217723, 217720, 217718, 217714, 217712, 425399, 217709, 425396, 217684, 420687, 420679, 420676, 242630, 425390, 217665, 425373, 425368, 217662, 425366, 425359, 425341, 425339, 242627, 425325, 217654, 423283, 425278, 242600, 242597, 242594, 425274, 242592, 242591, 230770, 242588, 242573, 242571, 423274, 230712, 425236, 108013, 425232, 425223, 425195, 217612, 242535, 217610, 420653, 420649, 242531, 420647, 230694, 230692, 425188, 217603, 217590, 425184, 425173, 425166, 388151, 425162, 230664, 230656, 217578, 230652, 425150, 420638, 425139, 107991, 230642, 107987, 217570, 473511, 217564, 230592, 242471, 217549, 242460, 420629, 217544, 107979, 107977, 107975, 217541, 217538, 425094, 217533, 425090, 217497, 242419, 242417, 242415, 217490, 230574, 217486, 230570, 230567, 217482, 242404, 230562, 217480, 242390, 242388, 242385, 242382, 242379, 242377, 242373, 242369, 230548, 217471, 480411, 230514, 473505, 217454, 473502, 473496, 242298, 230406, 476699, 217416, 242295, 230400, 476687, 242285, 242280, 242274, 242272, 476681, 477766, 477787, 230385, 230382, 217390, 476673, 476671, 242259, 388146, 217372, 107953, 473492, 107945, 476658, 107943, 107935, 107931, 242251, 230348, 230346, 107915, 458791, 242243, 107913, 242235, 230332, 230327, 230325, 217363, 242232, 107911, 217357, 458781, 458778, 230310, 458775, 107906, 107895, 107882, 107879, 107863, 242215, 217327, 230285, 230280, 217318, 242210, 230275, 242207, 230268, 242204, 242201, 217301, 242178, 242173, 217267, 242171, 217260, 242167, 217242, 242153, 230148, 107858, 217233, 230146, 107855, 107852, 242140, 230140, 420620, 420618, 217137, 230127, 217113, 217101, 230110, 242069, 242067, 242065, 230101, 217070, 217062, 217060, 217055, 217053, 217051, 217049, 217046, 217040, 217034, 230086, 242039, 242036, 230083, 242011, 230081, 217014, 217012, 242003, 217010, 241986, 241984, 241981, 241977, 241969, 241944, 241940, 241936, 241932, 241923, 107837, 468474, 107832, 241920, 468470, 468461, 460925, 454882, 216984, 216980, 107821, 216961, 216959, 230072, 216954, 230053, 216945, 230043, 230041, 230038, 230036, 230030, 230027, 241904, 216940, 241897, 230015, 107817, 241885, 420606, 216937, 107815, 230008, 107812, 241881, 241879, 241865, 241862, 107810, 107808, 467844, 230001, 241853, 229993, 241850, 420603, 420601, 241800, 241798, 216901, 241774, 241772, 241761, 216892, 229942, 229940, 241753, 388135, 229936, 241747, 216877, 216873, 388132, 420568, 388130, 420566, 216853, 216851, 216848, 216837, 241733, 229901, 216833, 241731, 420563, 229898, 388126, 420559, 216828, 241722, 216826, 216821, 107772, 107770, 107757, 107755, 107753, 229893, 107750, 241698, 241696, 107742, 216806, 241692, 241688, 241687, 107719, 229877, 229875, 229873, 229871, 229868, 229866, 229864, 241673, 241670, 241665, 241662, 107691, 107688, 229862, 107683, 229853, 216786, 241628, 216759, 216753, 229821, 229819, 241611, 229816, 241609, 423261, 241603, 216720, 107657, 241595, 107653, 216713, 107650, 241593, 107648, 241591, 229800, 107643, 241589, 423258, 229790, 229788, 423256, 423250, 229772, 229768, 241547, 229747, 241542, 241539, 241537, 241530, 229745, 423244, 216675, 216665, 229724, 241497, 241486, 241484, 241479, 241474, 241468, 241455, 216628, 241441, 241393, 216590, 229652, 229649, 229647, 241355, 216577, 229634, 241350, 229590, 392329, 241334, 241332, 229568, 241315, 216535, 216527, 229563, 107576, 107574, 229559, 241310, 229556, 107571, 420527, 241299, 241296, 420523, 216516, 420521, 216513, 216510, 241292, 216505, 107554, 241287, 107548, 241285, 229545, 388120, 216499, 216490, 388115, 216484, 447903, 107532, 420517, 241276, 229542, 241272, 229534, 241255, 229522, 241248, 241246, 216454, 229505, 229502, 229490, 107505, 216434, 229479, 107497, 241208, 241206, 229477, 241204, 241194, 241187, 216432, 423238, 216425, 216417, 449188, 241148, 423233, 229429, 229426, 229424, 216410, 388108, 388104, 229407, 388102, 216397, 388092, 216394, 216389, 241110, 216381, 241105, 216374, 241103, 107472, 241077, 241075, 241073, 107457, 216328, 241009, 241007, 229338, 229328, 229326, 229324, 229322, 229320, 229318, 229315, 229313, 216302, 229294, 107446, 107444, 107441, 107439, 107437, 216287, 107435, 229227, 229225, 229223, 107408, 107406, 107399, 107394, 240958, 392327, 216273, 240952, 240949, 388088, 107390, 216266, 240916, 240914, 274639, 229163, 229159, 240903, 229150, 388085, 388082, 216252, 388078, 229127, 229117, 274635, 274633, 216226, 229113, 229111, 229109, 393797, 229102, 240868, 240866, 229100, 216220, 229092, 393793, 229088, 393790, 420513, 216217, 420509, 420507, 420505, 406331, 420502, 388075, 420500, 388073, 240861, 420494, 229086, 107363, 240826, 240823, 240820, 240818, 240816, 216202, 229073, 229071, 216198, 240808, 107360, 107358, 107356, 240803, 393780, 107354, 240801, 229066, 107352, 240792, 216190, 375711, 107348, 240776, 107345, 240774, 107329, 240738, 107326, 107323, 107321, 216164, 216160, 107295, 229029, 229025, 216130, 229018, 229011, 216115, 229009, 229007, 216110, 229000, 216108, 228998, 228997, 388070, 228962, 240696, 240694, 240687, 240684, 240657, 228939, 228937, 240654, 240652, 228935, 240637, 228931, 228929, 228927, 240615, 240612, 240610, 216070, 228921, 240603, 240597, 107274, 216052, 240590, 107269, 107265, 240574, 240566, 216044, 240563, 240560, 240558, 240554, 228872, 228868, 405309, 405307, 405305, 240550, 240546, 216008, 240535, 388066, 216005, 216003, 240526, 240523, 215984, 215981, 107250, 107249, 107236, 215969, 228855, 228853, 215967, 240511, 228846, 228844, 228842, 215964, 228839, 215955, 228833, 240508, 240506, 215952, 228825, 228813, 240489, 228810, 240486, 107232, 215935, 107200, 412656, 412653, 412650, 240467, 228778, 393924, 393922, 393920, 215915, 240459, 215902, 228745, 215884, 240428, 228738, 228733, 228728, 240424, 240416, 240414, 240411, 228720, 215877, 240407, 215872, 240403, 240399, 228715, 240397, 215869, 240394, 215867, 107168, 107166, 240380, 215864, 215862, 228695, 215856, 228689, 240361, 228685, 240354, 215849, 392056, 215838, 215836, 228668, 228662, 240348, 215834, 228658, 215824, 215821, 215817, 274623, 215808, 406311, 228617, 228616, 215803, 406309, 228614, 215796, 406307, 406304, 406291, 240304, 406282, 215774, 393766, 388051, 228599, 228590, 240272, 215755, 215752, 228567, 228552, 228545, 228518, 240246, 228516, 228514, 240245, 215745, 215743, 240242, 215741, 240200, 240196, 215732, 240182, 240179, 215729, 228453, 228447, 228445, 228421, 240117, 240110, 107119, 107098, 240103, 215682, 240099, 215679, 228390, 240092, 215671, 392915, 240084, 240079, 240076, 240072, 406256, 228353, 240033, 228350, 107088, 107084, 215662, 240020, 107079, 107076, 107071, 215654, 228338, 215650, 228336, 240006, 107067, 215645, 228334, 228324, 239990, 215641, 392054, 228322, 228320, 107065, 228316, 228310, 228307, 228305, 215638, 228298, 397782, 228296, 239974, 215635, 228288, 392052, 239959, 405191, 228284, 228282, 239951, 405526, 228276, 107020, 228271, 107018, 228267, 228258, 215630, 107016, 405517, 405501, 405499, 405495, 405489, 215620, 215579, 215571, 392911, 239929, 239925, 392908, 388046, 392906, 388044, 239916, 215557, 388042, 239910, 215535, 381748, 239886, 239878, 383568, 228201, 388038, 383566, 383563, 383561, 228199, 228197, 239877, 215520, 228194, 239870, 215518, 228192, 228188, 388033, 239862, 215513, 106918, 106907, 396020, 381742, 215501, 383560, 381740, 381738, 383558, 106895, 215498, 106888, 383556, 215495, 228179, 228176, 228165, 215491, 215489, 388029, 388027, 215487, 215484, 215475, 215469, 388023, 383541, 106865, 388015, 239817, 239813, 215463, 239790, 239786, 239783, 228155, 215456, 228153, 239779, 239771, 239767, 239765, 215452, 388012, 239762, 239759, 239757, 239755, 228148, 215450, 239753, 239747, 239742, 239738, 239734, 239732, 215446, 239727, 239706, 215439, 228134, 239703, 215436, 228128, 215434, 239683, 228126, 239679, 228124, 228122, 228120, 228117, 228115, 239632, 215402, 396019, 228109, 215392, 396017, 228103, 239625, 228099, 239623, 215375, 228096, 106846, 106842, 215353, 215350, 215348, 215344, 215338, 215328, 228090, 215325, 228088, 239618, 239616, 239612, 239610, 239607, 215321, 106840, 228079, 215315, 383823, 392889, 392887, 396014, 383821, 239598, 228069, 228063, 393746, 228055, 228051, 397709, 228048, 228046, 397707, 228044, 239587, 215294, 239584, 239583, 239577, 228039, 228036, 239570, 239566, 397693, 215290, 106814, 106812, 106807, 239550, 396011, 395792, 396009, 239548, 239538, 228020, 228004, 239511, 227982, 239504, 383819, 227968, 227966, 215268, 383817, 106780, 239474, 227946, 227944, 396006, 396004, 239465, 227942, 397668, 395999, 395997, 215240, 395992, 227920, 397655, 227914, 227912, 227910, 215235, 227907, 215233, 239442, 106752, 106745, 239437, 227894, 227893, 215230, 239433, 227888, 227886, 395988, 106737, 388011, 106735, 239428, 215222, 396784, 106731, 215220, 396781, 227872, 227871, 395984, 396778, 215214, 395982, 395980, 227859, 227855, 239417, 227851, 396770, 227849, 395978, 227846, 227843, 239415, 215196, 106717, 215192, 239413, 106715, 106707, 106704, 227831, 239400, 106699, 215184, 239394, 239391, 227825, 227823, 227821, 227819, 227816, 239388, 227810, 106694, 239385, 227804, 239378, 106689, 239376, 239373, 106683, 106682, 215164, 227798, 395692, 227792, 106667, 239362, 106661, 395469, 106659, 227780, 395442, 239353, 395440, 215141, 239338, 239306, 227772, 227764, 239301, 215132, 215127, 239299, 239297, 239295, 227741, 227739, 227734, 227731, 215113, 239281, 239278, 239276, 227729, 239272, 227727, 239269, 239267, 227725, 227720, 227717, 227715, 239249, 215079, 215077, 239238, 227702, 239233, 227700, 227696, 215050, 227687, 391605, 239209, 239207, 239188, 215036, 239186, 383794, 383792, 239183, 239180, 239167, 239159, 239156, 239146, 239136, 215014, 215012, 383783, 239125, 239123, 215007, 239118, 308773, 239101, 383781, 239099, 239094, 383779, 308770, 239093, 214996, 308762, 239052, 389587, 388008, 239046, 388006, 214985, 239032, 214978, 239027, 387998, 387993, 387992, 214974, 214970, 214968, 387989, 387987, 387985, 387981, 214960, 387979, 387977, 239017, 239012, 387973, 387970, 214957, 238993, 238981, 238978, 238973, 238969, 238963, 238960, 238953, 238950, 238948, 238945, 238943, 387965, 383778, 238919, 383776, 238908, 387963, 383773, 238900, 214930, 383772, 383770, 214920, 383767, 214917, 383762, 214911, 383760, 238889, 387959, 383752, 387957, 214906, 214904, 387950, 387948, 383749, 387938, 383742, 214881, 385654, 383740, 214878, 238849, 383737, 214862, 238841, 385652, 214857, 238836, 214855, 385649, 385647, 214849, 294242, 214841, 383735, 238830, 294240, 383733, 383731, 383728, 383725, 214837, 214810, 385642, 385639, 348362, 348360, 238816, 385637, 383722, 214804, 214792, 385629, 348353, 348346, 348339, 383719, 385627, 385625, 383717, 385620, 383712, 385618, 384567, 383706, 383701, 383698, 384561, 384552, 361328, 214679, 214660, 214659, 384548, 382962, 214648, 214646, 214644, 214642, 214640, 214633, 294219, 294217, 294215, 294214, 294212, 214622, 214621, 214620, 294210, 214614, 214613, 214612, 214609, 294208, 382959, 382957, 294206, 214603, 382955, 382954, 382952, 382950))
Run Time: 0.149853
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2343 | |
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 | | | | | 2343 | |
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 (27257, 26761, 19558))
Run Time: 0.001006
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 3 | 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 (499596, 108608, 499594, 108606, 429104, 219443, 499592, 473571, 108603, 108597, 428972, 243884, 108594, 428961, 108591, 428957, 362463, 219368, 362461, 232456, 428933, 428929, 232423, 219351, 219349, 219347, 219345, 232421, 428888, 473564, 243875, 243874, 219342, 428878, 528360, 243854, 528358, 428814, 243845, 428812, 388273, 428810, 219321, 528357, 243828, 243824, 232380, 528354, 219304, 528349, 243821, 232378, 528347, 528345, 232370, 528343, 528341, 528337, 528333, 528330, 528328, 428771, 528318, 528313, 528311, 528309, 428763, 528305, 243807, 232345, 219225, 219215, 473561, 428686, 428681, 404714, 404702, 219210, 219207, 219202, 219200, 473559, 232324, 428657, 428655, 428649, 219192, 404685, 362430, 243796, 428581, 493532, 232302, 493530, 232295, 232292, 232290, 493528, 473553, 428503, 493513, 428497, 428470, 243718, 428467, 243716, 243714, 243712, 388257, 428464, 108579, 388253, 388251, 428434, 388249, 243710, 243708, 243706, 388245, 243703, 243698, 219123, 243684, 243681, 243678, 514525, 428407, 428399, 428397, 428395, 428354, 428352, 219110, 232278, 428339, 219105, 388233, 428336, 428334, 388231, 428304, 219095, 428300, 428295, 428287, 428282, 243652, 428267, 519781, 428262, 519779, 519777, 428256, 428254, 428252, 219087, 519770, 388227, 519762, 519760, 219083, 519755, 428225, 428219, 404673, 519753, 428186, 428184, 428182, 428179, 428177, 232262, 428175, 219072, 108569, 108560, 428165, 428154, 514516, 428126, 428124, 108552, 388222, 108542, 519752, 519746, 519744, 243637, 243633, 243631, 219034, 243629, 232252, 428014, 428012, 428008, 243619, 219027, 428003, 232246, 388219, 388217, 427993, 427983, 427981, 427966, 232238, 427964, 427949, 427946, 108535, 427942, 514509, 218966, 232226, 232218, 218955, 243610, 218953, 218951, 388214, 388212, 388209, 388202, 388197, 388191, 388188, 427858, 108508, 108506, 232188, 108503, 232186, 108501, 243604, 108484, 514477, 108482, 232164, 108467, 108464, 108459, 108454, 108450, 218884, 108447, 108445, 108424, 108422, 232155, 108420, 108418, 232153, 108415, 218878, 232143, 232141, 243577, 232138, 243573, 218852, 243571, 514474, 514472, 232108, 243561, 243557, 232101, 514465, 514463, 514460, 427718, 232094, 243546, 362421, 232092, 362419, 232089, 427712, 362416, 218816, 218813, 218807, 218797, 218792, 218790, 218775, 362410, 309312, 232082, 218750, 218747, 218743, 218730, 494813, 218724, 218720, 427681, 232061, 427677, 473539, 427664, 309309, 473533, 427662, 427660, 309307, 243524, 473531, 243522, 427644, 232045, 427634, 427631, 427620, 243512, 388185, 388182, 388180, 427605, 388178, 473527, 473524, 427575, 473521, 427573, 218650, 243505, 427570, 473517, 218639, 108388, 108386, 218630, 427545, 218627, 108384, 243490, 243485, 427503, 243483, 427491, 243480, 243478, 218613, 218609, 218606, 392923, 427467, 427465, 232031, 427455, 392921, 232029, 232025, 362389, 232017, 427444, 427442, 232003, 362386, 427432, 243459, 427430, 427427, 362382, 243457, 427424, 362376, 427412, 427407, 243447, 243443, 427382, 427349, 427339, 427336, 427332, 427329, 427323, 231998, 231994, 493505, 493502, 231990, 493500, 231987, 231980, 493497, 427296, 218597, 309296, 427252, 427250, 427224, 427222, 243423, 427218, 243421, 243418, 108374, 231965, 243409, 231963, 427167, 231957, 427165, 427161, 218586, 427157, 218584, 231955, 427147, 243396, 427143, 231948, 108371, 427127, 108365, 427125, 108363, 108361, 493469, 108359, 493467, 218579, 108342, 108337, 218571, 507321, 231919, 218564, 231917, 427111, 427109, 427103, 427101, 427097, 108318, 231909, 427083, 231902, 427081, 309287, 243369, 218521, 427009, 218489, 231876, 231873, 231870, 243309, 108302, 231860, 108291, 108288, 108285, 309187, 309185, 426911, 309183, 426909, 231846, 309176, 231844, 426901, 309154, 309141, 309139, 426898, 426896, 218466, 505885, 243280, 218438, 426835, 243269, 501294, 243247, 243245, 243242, 243239, 243237, 243235, 243231, 231820, 243230, 231814, 426778, 243221, 426776, 231811, 243215, 426772, 243208, 231808, 243205, 493464, 218411, 426766, 426761, 426759, 426757, 231779, 499587, 426753, 231746, 426734, 426730, 494805, 494803, 426727, 426725, 218389, 218385, 426691, 218383, 426689, 218378, 243181, 243180, 243171, 218371, 243169, 218367, 218365, 218356, 494800, 231695, 243162, 231693, 231691, 243159, 243157, 426658, 243156, 218348, 218345, 218341, 426629, 218335, 243091, 243085, 243078, 243072, 426593, 243068, 243065, 231568, 231566, 218332, 218329, 218327, 218325, 218313, 243053, 243051, 243048, 218301, 231562, 388176, 426569, 243042, 243039, 243037, 388173, 388171, 388169, 426567, 426565, 231531, 108269, 218290, 426563, 108267, 426561, 108264, 231529, 426557, 426542, 426535, 426533, 426531, 426511, 426504, 426498, 426495, 426490, 231523, 426484, 426480, 388165, 426477, 231520, 426472, 426470, 426466, 426463, 108243, 231516, 499563, 426460, 218267, 426458, 426456, 426454, 426451, 231514, 426449, 426444, 231500, 231497, 231495, 231493, 231490, 243022, 243020, 426435, 426433, 231455, 426430, 243012, 426416, 218255, 426410, 426407, 218252, 243009, 231433, 243003, 426375, 426372, 426350, 493444, 218247, 108239, 426281, 493433, 426254, 500915, 243001, 231427, 309000, 308998, 500894, 308996, 500892, 308991, 218194, 231412, 218188, 274651, 218184, 218181, 231398, 426223, 231386, 426220, 218172, 218164, 242970, 218162, 231366, 231364, 242967, 231360, 231357, 218153, 426198, 108221, 242964, 108210, 218148, 242962, 242960, 108207, 108203, 108201, 108199, 108197, 108195, 108193, 108191, 231314, 426175, 426173, 426171, 426169, 426167, 426165, 426163, 426161, 231312, 231310, 231308, 231303, 426158, 242949, 426156, 426151, 388157, 426089, 308977, 308974, 426086, 308972, 308960, 308958, 231297, 231295, 426073, 231286, 426058, 393820, 218096, 426055, 426026, 231273, 426024, 218087, 426021, 108165, 393814, 231271, 218073, 231265, 426015, 218069, 218067, 231262, 231260, 231257, 231251, 231249, 231247, 425999, 425997, 425995, 425993, 425990, 425987, 425984, 425979, 425974, 425970, 425966, 425956, 108161, 242922, 231179, 108159, 242920, 108157, 242914, 242912, 242906, 218049, 108155, 108150, 218046, 108148, 425947, 425945, 108122, 218039, 108120, 218034, 108109, 108104, 108102, 108099, 108096, 108085, 218025, 108081, 425909, 108078, 218008, 218004, 425871, 217980, 493421, 425834, 231132, 231130, 493409, 217958, 425811, 217954, 493406, 493404, 493402, 493400, 493398, 493396, 217950, 493394, 493388, 493382, 493380, 493362, 425759, 493353, 231101, 217934, 217927, 217925, 425728, 425720, 425718, 425715, 108075, 242863, 231090, 217923, 231084, 242853, 217920, 231082, 231074, 231060, 231058, 231056, 493350, 217908, 231041, 231039, 231037, 231035, 231033, 231031, 231029, 231027, 231025, 217902, 217900, 231017, 217894, 231008, 242811, 242809, 242807, 230999, 217892, 242799, 242797, 393810, 217879, 217877, 242790, 217868, 404669, 404666, 404663, 425648, 230976, 242762, 491419, 230965, 242760, 230954, 242750, 230942, 230921, 230916, 230911, 242744, 230909, 217811, 230903, 230900, 230898, 217809, 425579, 230896, 230895, 425574, 230882, 425560, 425555, 230878, 476778, 425551, 425527, 425524, 425521, 217802, 242724, 242722, 230867, 425508, 476774, 230858, 476772, 476770, 476767, 476765, 476763, 476761, 230854, 476759, 476757, 230852, 489816, 425502, 230846, 242707, 242703, 489811, 242700, 230842, 242697, 230840, 242690, 242688, 230824, 489806, 242680, 217789, 425496, 420727, 217772, 425489, 242672, 420724, 405539, 420719, 420717, 242654, 425458, 425449, 242652, 420707, 420699, 242638, 108068, 108064, 420696, 420692, 420690, 108058, 217736, 308902, 308900, 108056, 217734, 308897, 217731, 308885, 308870, 308868, 308864, 308862, 308860, 308857, 425408, 425406, 217725, 217723, 217720, 217718, 217714, 217712, 425399, 217709, 425396, 217684, 420687, 420679, 420676, 242630, 425390, 217665, 425373, 425368, 217662, 425366, 425359, 425341, 425339, 242627, 425325, 217654, 423283, 425278, 242600, 242597, 242594, 425274, 242592, 242591, 230770, 242588, 242573, 242571, 423274, 230712, 425236, 108013, 425232, 425223, 425195, 217612, 242535, 217610, 420653, 420649, 242531, 420647, 230694, 230692, 425188, 217603, 217590, 425184, 425173, 425166, 388151, 425162, 230664, 230656, 217578, 230652, 425150, 420638, 425139, 107991, 230642, 107987, 217570, 473511, 217564, 230592, 242471, 217549, 242460, 420629, 217544, 107979, 107977, 107975, 217541, 217538, 425094, 217533, 425090, 217497, 242419, 242417, 242415, 217490, 230574, 217486, 230570, 230567, 217482, 242404, 230562, 217480, 242390, 242388, 242385, 242382, 242379, 242377, 242373, 242369, 230548, 217471, 480411, 230514, 473505, 217454, 473502, 473496, 242298, 230406, 476699, 217416, 242295, 230400, 476687, 242285, 242280, 242274, 242272, 476681, 477766, 477787, 230385, 230382, 217390, 476673, 476671, 242259, 388146, 217372, 107953, 473492, 107945, 476658, 107943, 107935, 107931, 242251, 230348, 230346, 107915, 458791, 242243, 107913, 242235, 230332, 230327, 230325, 217363, 242232, 107911, 217357, 458781, 458778, 230310, 458775, 107906, 107895, 107882, 107879, 107863, 242215, 217327, 230285, 230280, 217318, 242210, 230275, 242207, 230268, 242204, 242201, 217301, 242178, 242173, 217267, 242171, 217260, 242167, 217242, 242153, 230148, 107858, 217233, 230146, 107855, 107852, 242140, 230140, 420620, 420618, 217137, 230127, 217113, 217101, 230110, 242069, 242067, 242065, 230101, 217070, 217062, 217060, 217055, 217053, 217051, 217049, 217046, 217040, 217034, 230086, 242039, 242036, 230083, 242011, 230081, 217014, 217012, 242003, 217010, 241986, 241984, 241981, 241977, 241969, 241944, 241940, 241936, 241932, 241923, 107837, 468474, 107832, 241920, 468470, 468461, 460925, 454882, 216984, 216980, 107821, 216961, 216959, 230072, 216954, 230053, 216945, 230043, 230041, 230038, 230036, 230030, 230027, 241904, 216940, 241897, 230015, 107817, 241885, 420606, 216937, 107815, 230008, 107812, 241881, 241879, 241865, 241862, 107810, 107808, 467844, 230001, 241853, 229993, 241850, 420603, 420601, 241800, 241798, 216901, 241774, 241772, 241761, 216892, 229942, 229940, 241753, 388135, 229936, 241747, 216877, 216873, 388132, 420568, 388130, 420566, 216853, 216851, 216848, 216837, 241733, 229901, 216833, 241731, 420563, 229898, 388126, 420559, 216828, 241722, 216826, 216821, 107772, 107770, 107757, 107755, 107753, 229893, 107750, 241698, 241696, 107742, 216806, 241692, 241688, 241687, 107719, 229877, 229875, 229873, 229871, 229868, 229866, 229864, 241673, 241670, 241665, 241662, 107691, 107688, 229862, 107683, 229853, 216786, 241628, 216759, 216753, 229821, 229819, 241611, 229816, 241609, 423261, 241603, 216720, 107657, 241595, 107653, 216713, 107650, 241593, 107648, 241591, 229800, 107643, 241589, 423258, 229790, 229788, 423256, 423250, 229772, 229768, 241547, 229747, 241542, 241539, 241537, 241530, 229745, 423244, 216675, 216665, 229724, 241497, 241486, 241484, 241479, 241474, 241468, 241455, 216628, 241441, 241393, 216590, 229652, 229649, 229647, 241355, 216577, 229634, 241350, 229590, 392329, 241334, 241332, 229568, 241315, 216535, 216527, 229563, 107576, 107574, 229559, 241310, 229556, 107571, 420527, 241299, 241296, 420523, 216516, 420521, 216513, 216510, 241292, 216505, 107554, 241287, 107548, 241285, 229545, 388120, 216499, 216490, 388115, 216484, 447903, 107532, 420517, 241276, 229542, 241272, 229534, 241255, 229522, 241248, 241246, 216454, 229505, 229502, 229490, 107505, 216434, 229479, 107497, 241208, 241206, 229477, 241204, 241194, 241187, 216432, 423238, 216425, 216417, 449188, 241148, 423233, 229429, 229426, 229424, 216410, 388108, 388104, 229407, 388102, 216397, 388092, 216394, 216389, 241110, 216381, 241105, 216374, 241103, 107472, 241077, 241075, 241073, 107457, 216328, 241009, 241007, 229338, 229328, 229326, 229324, 229322, 229320, 229318, 229315, 229313, 216302, 229294, 107446, 107444, 107441, 107439, 107437, 216287, 107435, 229227, 229225, 229223, 107408, 107406, 107399, 107394, 240958, 392327, 216273, 240952, 240949, 388088, 107390, 216266, 240916, 240914, 274639, 229163, 229159, 240903, 229150, 388085, 388082, 216252, 388078, 229127, 229117, 274635, 274633, 216226, 229113, 229111, 229109, 393797, 229102, 240868, 240866, 229100, 216220, 229092, 393793, 229088, 393790, 420513, 216217, 420509, 420507, 420505, 406331, 420502, 388075, 420500, 388073, 240861, 420494, 229086, 107363, 240826, 240823, 240820, 240818, 240816, 216202, 229073, 229071, 216198, 240808, 107360, 107358, 107356, 240803, 393780, 107354, 240801, 229066, 107352, 240792, 216190, 375711, 107348, 240776, 107345, 240774, 107329, 240738, 107326, 107323, 107321, 216164, 216160, 107295, 229029, 229025, 216130, 229018, 229011, 216115, 229009, 229007, 216110, 229000, 216108, 228998, 228997, 388070, 228962, 240696, 240694, 240687, 240684, 240657, 228939, 228937, 240654, 240652, 228935, 240637, 228931, 228929, 228927, 240615, 240612, 240610, 216070, 228921, 240603, 240597, 107274, 216052, 240590, 107269, 107265, 240574, 240566, 216044, 240563, 240560, 240558, 240554, 228872, 228868, 405309, 405307, 405305, 240550, 240546, 216008, 240535, 388066, 216005, 216003, 240526, 240523, 215984, 215981, 107250, 107249, 107236, 215969, 228855, 228853, 215967, 240511, 228846, 228844, 228842, 215964, 228839, 215955, 228833, 240508, 240506, 215952, 228825, 228813, 240489, 228810, 240486, 107232, 215935, 107200, 412656, 412653, 412650, 240467, 228778, 393924, 393922, 393920, 215915, 240459, 215902, 228745, 215884, 240428, 228738, 228733, 228728, 240424, 240416, 240414, 240411, 228720, 215877, 240407, 215872, 240403, 240399, 228715, 240397, 215869, 240394, 215867, 107168, 107166, 240380, 215864, 215862, 228695, 215856, 228689, 240361, 228685, 240354, 215849, 392056, 215838, 215836, 228668, 228662, 240348, 215834, 228658, 215824, 215821, 215817, 274623, 215808, 406311, 228617, 228616, 215803, 406309, 228614, 215796, 406307, 406304, 406291, 240304, 406282, 215774, 393766, 388051, 228599, 228590, 240272, 215755, 215752, 228567, 228552, 228545, 228518, 240246, 228516, 228514, 240245, 215745, 215743, 240242, 215741, 240200, 240196, 215732, 240182, 240179, 215729, 228453, 228447, 228445, 228421, 240117, 240110, 107119, 107098, 240103, 215682, 240099, 215679, 228390, 240092, 215671, 392915, 240084, 240079, 240076, 240072, 406256, 228353, 240033, 228350, 107088, 107084, 215662, 240020, 107079, 107076, 107071, 215654, 228338, 215650, 228336, 240006, 107067, 215645, 228334, 228324, 239990, 215641, 392054, 228322, 228320, 107065, 228316, 228310, 228307, 228305, 215638, 228298, 397782, 228296, 239974, 215635, 228288, 392052, 239959, 405191, 228284, 228282, 239951, 405526, 228276, 107020, 228271, 107018, 228267, 228258, 215630, 107016, 405517, 405501, 405499, 405495, 405489, 215620, 215579, 215571, 392911, 239929, 239925, 392908, 388046, 392906, 388044, 239916, 215557, 388042, 239910, 215535, 381748, 239886, 239878, 383568, 228201, 388038, 383566, 383563, 383561, 228199, 228197, 239877, 215520, 228194, 239870, 215518, 228192, 228188, 388033, 239862, 215513, 106918, 106907, 396020, 381742, 215501, 383560, 381740, 381738, 383558, 106895, 215498, 106888, 383556, 215495, 228179, 228176, 228165, 215491, 215489, 388029, 388027, 215487, 215484, 215475, 215469, 388023, 383541, 106865, 388015, 239817, 239813, 215463, 239790, 239786, 239783, 228155, 215456, 228153, 239779, 239771, 239767, 239765, 215452, 388012, 239762, 239759, 239757, 239755, 228148, 215450, 239753, 239747, 239742, 239738, 239734, 239732, 215446, 239727, 239706, 215439, 228134, 239703, 215436, 228128, 215434, 239683, 228126, 239679, 228124, 228122, 228120, 228117, 228115, 239632, 215402, 396019, 228109, 215392, 396017, 228103, 239625, 228099, 239623, 215375, 228096, 106846, 106842, 215353, 215350, 215348, 215344, 215338, 215328, 228090, 215325, 228088, 239618, 239616, 239612, 239610, 239607, 215321, 106840, 228079, 215315, 383823, 392889, 392887, 396014, 383821, 239598, 228069, 228063, 393746, 228055, 228051, 397709, 228048, 228046, 397707, 228044, 239587, 215294, 239584, 239583, 239577, 228039, 228036, 239570, 239566, 397693, 215290, 106814, 106812, 106807, 239550, 396011, 395792, 396009, 239548, 239538, 228020, 228004, 239511, 227982, 239504, 383819, 227968, 227966, 215268, 383817, 106780, 239474, 227946, 227944, 396006, 396004, 239465, 227942, 397668, 395999, 395997, 215240, 395992, 227920, 397655, 227914, 227912, 227910, 215235, 227907, 215233, 239442, 106752, 106745, 239437, 227894, 227893, 215230, 239433, 227888, 227886, 395988, 106737, 388011, 106735, 239428, 215222, 396784, 106731, 215220, 396781, 227872, 227871, 395984, 396778, 215214, 395982, 395980, 227859, 227855, 239417, 227851, 396770, 227849, 395978, 227846, 227843, 239415, 215196, 106717, 215192, 239413, 106715, 106707, 106704, 227831, 239400, 106699, 215184, 239394, 239391, 227825, 227823, 227821, 227819, 227816, 239388, 227810, 106694, 239385, 227804, 239378, 106689, 239376, 239373, 106683, 106682, 215164, 227798, 395692, 227792, 106667, 239362, 106661, 395469, 106659, 227780, 395442, 239353, 395440, 215141, 239338, 239306, 227772, 227764, 239301, 215132, 215127, 239299, 239297, 239295, 227741, 227739, 227734, 227731, 215113, 239281, 239278, 239276, 227729, 239272, 227727, 239269, 239267, 227725, 227720, 227717, 227715, 239249, 215079, 215077, 239238, 227702, 239233, 227700, 227696, 215050, 227687, 391605, 239209, 239207, 239188, 215036, 239186, 383794, 383792, 239183, 239180, 239167, 239159, 239156, 239146, 239136, 215014, 215012, 383783, 239125, 239123, 215007, 239118, 308773, 239101, 383781, 239099, 239094, 383779, 308770, 239093, 214996, 308762, 239052, 389587, 388008, 239046, 388006, 214985, 239032, 214978, 239027, 387998, 387993, 387992, 214974, 214970, 214968, 387989, 387987, 387985, 387981, 214960, 387979, 387977, 239017, 239012, 387973, 387970, 214957, 238993, 238981, 238978, 238973, 238969, 238963, 238960, 238953, 238950, 238948, 238945, 238943, 387965, 383778, 238919, 383776, 238908, 387963, 383773, 238900, 214930, 383772, 383770, 214920, 383767, 214917, 383762, 214911, 383760, 238889, 387959, 383752, 387957, 214906, 214904, 387950, 387948, 383749, 387938, 383742, 214881, 385654, 383740, 214878, 238849, 383737, 214862, 238841, 385652, 214857, 238836, 214855, 385649, 385647, 214849, 294242, 214841, 383735, 238830, 294240, 383733, 383731, 383728, 383725, 214837, 214810, 385642, 385639, 348362, 348360, 238816, 385637, 383722, 214804, 214792, 385629, 348353, 348346, 348339, 383719, 385627, 385625, 383717, 385620, 383712, 385618, 384567, 383706, 383701, 383698, 384561, 384552, 361328, 214679, 214660, 214659, 384548, 382962, 214648, 214646, 214644, 214642, 214640, 214633, 294219, 294217, 294215, 294214, 294212, 214622, 214621, 214620, 294210, 214614, 214613, 214612, 214609, 294208, 382959, 382957, 294206, 214603, 382955, 382954, 382952, 382950))
Run Time: 0.059766
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2343 | |
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 | | | | | 2343 | |
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 (27257, 26761, 19558))
Run Time: 0.001118
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 3 | 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, 4(
Run Time: 0.000360
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000449
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.000609
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: 1717125880
Run Time: 0.000386
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 31 | 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` >= 1717125880)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000699
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 31 | 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