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.000672
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.000436
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` = '2009')
LIMIT 1
Run Time: 0.000462
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.001664
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_2009' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.053575
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 (250330, 250291, 250265, 250182, 117524, 117519, 251054, 250156, 251052, 251050, 251047, 250553, 251039, 250136, 250542, 250059, 203006, 250446, 250444, 250436, 250433, 249882, 249486, 249480, 248948, 248777, 248774, 202993, 202990, 117501, 248298, 248290, 204857, 248086, 247922, 143219, 222525, 208174, 222297, 171349, 171342, 208118, 163599, 208154, 208189, 202435, 208023, 207893, 207041, 207029, 207027, 203770, 203751, 203736, 202490, 203455, 202487, 203452, 202484, 203566, 202865, 203437, 203563, 203536, 203431, 203557, 203427, 203462, 203528, 202863, 203479, 203412, 203476, 203472, 203469, 203411, 203279, 203271, 203191, 203189, 202915, 202882, 195199, 194739, 202251, 202907, 202248, 202812, 202718, 202465, 202214, 201723, 163588, 202124, 202005, 201719, 202183, 152223, 143206, 202023, 201999, 201997, 143205, 201991, 201837, 96765, 201786, 96763, 201835, 201782, 201953, 201759, 201710, 190008, 201949, 201832, 191087, 201779, 201707, 194310, 201773, 201704, 201751, 201802, 201694, 194947, 201692, 201688, 194944, 201359, 201682, 201499, 194734, 117455, 193226, 187132, 187130, 187128, 187126, 193213, 192541, 193102, 193100, 127694, 193072, 193095, 127692, 142822, 192736, 142820, 192602, 192599, 142816, 192727, 192724, 142814, 192713, 192635, 192571, 192631, 192562, 192590, 192513, 192531, 192325, 192447, 192323, 192317, 192067, 192065, 192063, 192061, 192054, 186009, 191969, 191337, 191334, 190261, 190124, 187314, 189803, 189801, 117442, 189848, 117436, 169854, 169852, 188281, 188277, 188275, 188357, 188270, 187236, 187161, 187914, 187851, 187849, 187846, 182650, 187389, 187387, 187232, 187228, 187294, 187366, 182637, 187219, 182632, 187323, 187217, 182630, 187292, 187319, 149461, 185942, 185552, 182260, 186000, 182138, 184139, 184134, 184132, 184130, 185079, 185549, 185511, 185027, 185464, 149451, 185396, 120527, 183188, 183185, 183183, 185037, 185018, 184937, 184652, 184115, 149445, 184646, 182091, 174895, 174893, 184015, 174887, 174884, 174882, 174878, 174872, 174867, 183296, 183294, 183290, 183277, 174861, 183648, 181325, 183267, 183369, 182336, 183265, 182583, 183136, 183107, 183261, 183259, 181704, 183103, 182059, 183078, 183076, 173895, 170857, 181782, 181775, 181768, 173891, 181764, 173888, 181761, 173886, 173884, 173881, 173879, 181758, 173877, 170363, 181755, 181983, 182656, 182369, 83171, 174654, 174990, 174981, 172876, 174800, 174728, 164449, 173930, 173926, 164447, 164445, 164442, 164440, 164438, 157966, 170845, 141532, 173458, 142809, 173361, 142807, 173039, 172902, 172749, 169944, 142790, 154887, 172858, 172855, 172274, 172724, 172272, 154884, 172664, 172303, 157958, 172100, 172270, 172301, 172299, 172297, 172295, 172327, 172293, 172095, 172213, 167292, 172263, 172277, 169940, 169880, 172196, 165332, 154882, 154879, 169877, 172060, 171299, 163253, 141523, 171937, 169875, 171296, 171844, 171827, 155209, 171448, 171444, 171376, 171406, 159377, 159852, 85557, 85555, 165322, 169641, 171247, 171356, 171267, 165316, 165314, 165313, 169548, 170633, 170631, 171019, 170718, 171005, 171003, 171000, 170824, 170658, 170561, 170382, 169151, 170377, 170354, 170558, 170537, 170457, 59181, 170351, 168993, 169939, 170445, 169937, 169935, 170194, 168002, 165306, 170065, 170071, 170063, 170020, 167712, 167710, 169916, 127689, 169913, 127687, 169959, 169911, 169909, 170036, 169987, 169985, 85551, 169982, 169980, 169977, 169835, 169610, 169335, 169604, 169602, 169599, 169739, 169597, 169498, 169493, 165736, 165273, 169485, 165732, 169685, 169296, 169594, 169575, 157899, 169590, 169302, 169077, 169477, 169475, 169526, 169472, 169522, 169145, 169450, 169510, 166703, 168667, 169508, 166701, 169333, 169140, 169298, 168877, 166888, 168951, 142788, 167380, 169243, 167375, 169118, 157938, 168175, 142786, 169094, 169064, 169057, 168979, 143154, 168941, 168888, 168871, 167372, 168868, 168864, 168702, 162335, 168657, 162333, 155188, 59174, 155182, 155179, 155174, 168166, 168452, 166016, 161567, 165263, 167503, 154604, 166430, 166425, 166866, 167254, 167251, 157848, 142768, 162529, 162527, 154877, 167493, 154871, 167491, 154602, 166970, 142766, 166915, 166803, 166993, 166908, 166902, 166523, 166793, 162518, 162516, 162515, 166413, 166411, 166409, 162510, 162508, 162506, 143150, 143149, 142762, 166164, 162503, 165523, 142758, 162499, 165518, 166094, 142755, 162497, 166081, 165514, 142753, 165637, 165511, 162495, 148281, 165994, 164690, 165870, 165694, 165632, 163738, 165479, 117398, 163922, 117395, 165452, 164427, 127686, 164424, 127684, 163853, 162489, 164824, 163848, 164348, 164422, 164410, 163826, 163821, 120489, 163819, 163240, 163816, 163663, 164812, 162486, 164474, 95354, 162484, 59167, 164402, 163743, 164207, 164386, 164203, 164372, 164195, 164192, 164189, 164187, 164185, 164181, 164179, 163876, 163874, 163940, 163938, 112816, 163904, 163621, 163641, 161610, 96150, 162929, 159398, 162927, 162923, 163281, 163233, 162174, 163290, 162480, 162478, 127682, 162172, 162476, 155688, 162471, 162170, 162464, 162167, 162933, 162916, 162461, 162164, 162440, 162162, 162456, 162804, 162454, 162437, 162646, 162669, 162667, 161558, 154901, 162404, 162321, 160580, 162311, 161555, 162453, 162309, 162302, 162448, 162234, 162430, 162300, 161553, 142752, 161605, 152177, 162298, 162156, 162154, 162150, 162148, 162183, 161599, 162090, 162051, 161588, 161537, 161535, 161005, 161353, 159603, 161386, 159975, 161069, 161148, 161143, 161141, 161065, 157881, 154870, 154868, 161040, 154866, 160821, 161014, 161038, 160817, 160910, 160906, 142741, 160814, 160493, 160466, 160460, 148275, 160453, 160442, 157749, 157747, 155169, 148690, 159845, 159360, 159937, 159584, 159357, 149432, 159349, 159345, 159419, 117369, 156566, 159343, 159338, 158150, 152143, 159302, 157874, 154863, 154861, 154859, 158147, 158139, 158136, 158133, 156516, 158129, 158124, 158673, 158121, 158662, 158116, 156480, 158484, 158114, 158112, 158482, 154278, 154274, 154271, 154264, 154258, 154256, 154254, 154251, 154247, 154242, 154239, 158111, 154237, 158108, 158035, 154233, 157758, 154231, 157980, 157868, 157816, 157812, 151061, 157800, 157797, 157790, 149388, 149384, 156783, 154505, 154208, 141342, 157554, 149358, 154595, 141339, 157547, 116131, 157317, 157315, 157312, 154591, 156778, 156711, 154200, 96129, 154588, 133933, 133929, 156759, 155872, 154500, 154175, 156705, 154498, 154161, 154159, 156375, 154155, 156111, 154153, 154495, 156180, 156168, 155850, 154142, 156106, 154136, 154131, 154126, 154585, 155666, 155663, 154734, 155619, 155658, 149324, 155727, 149320, 155758, 155756, 155754, 155750, 155723, 154070, 151633, 149315, 154986, 150651, 141337, 155652, 154111, 149311, 141335, 154487, 154982, 154729, 154109, 155107, 155080, 155076, 154898, 155053, 154858, 154856, 154354, 149301, 154850, 154848, 154351, 149297, 154896, 154812, 141332, 154482, 154978, 154844, 154348, 154835, 154583, 149269, 150884, 154344, 154581, 154043, 149252, 154479, 150879, 154542, 149246, 149225, 150872, 149204, 149198, 154314, 95344, 154312, 153292, 149192, 154010, 149764, 154060, 154003, 147200, 148270, 153984, 153894, 152747, 151849, 153848, 153244, 152806, 153329, 153324, 153313, 151764, 153254, 153067, 152790, 118022, 152091, 152089, 152941, 152653, 152651, 152779, 152608, 96736, 149168, 151053, 150415, 149166, 149157, 149154, 152120, 150866, 152131, 149113, 152128, 17353, 152124, 127681, 141297, 127679, 152115, 152055, 152024, 127677, 127675, 149964, 149104, 151878, 151321, 151870, 151867, 151865, 149085, 149080, 149078, 149076, 151840, 149066, 151622, 149063, 151310, 119970, 151344, 119968, 149050, 150297, 151195, 150295, 149047, 149826, 151191, 149043, 151189, 151187, 151077, 125991, 150030, 150289, 142726, 150908, 150923, 148962, 150753, 150399, 119953, 150860, 150287, 150767, 150750, 150745, 150764, 149908, 150395, 150391, 150738, 150707, 150704, 150700, 148949, 150733, 150667, 149707, 150551, 150567, 149903, 149797, 148903, 148897, 148895, 148887, 148884, 148878, 149793, 148855, 142720, 148850, 148656, 150019, 148626, 149746, 149703, 150011, 149943, 149941, 149867, 149936, 149864, 149955, 149952, 149852, 143135, 149850, 149845, 149819, 148792, 148621, 148788, 149700, 148122, 148762, 149656, 148760, 148755, 148118, 148465, 133922, 148741, 148737, 133917, 148735, 133913, 148726, 133908, 133903, 148717, 133901, 148614, 148612, 148635, 148632, 148610, 129298, 142504, 148387, 147954, 145143, 129296, 147952, 147950, 147948, 147946, 147944, 147942, 148351, 148212, 147940, 148255, 147513, 148253, 148246, 136790, 143132, 148105, 148205, 148203, 148103, 127947, 148054, 148184, 148180, 148097, 119891, 148094, 148048, 147856, 133897, 147854, 147874, 133895, 147919, 148046, 148040, 146209, 148091, 146542, 147850, 147848, 147500, 147497, 147868, 147493, 147665, 147663, 147489, 147661, 120973, 135081, 147554, 147278, 147588, 147552, 146091, 147005, 147582, 135077, 147269, 147311, 142697, 146521, 147082, 146959, 146622, 146513, 147259, 146511, 147257, 146075, 146070, 147022, 146818, 145926, 146787, 119843, 145885, 146200, 145869, 146198, 141270, 145867, 119840, 146573, 146195, 117327, 146503, 145787, 145758, 145573, 145745, 119830, 146192, 146191, 146254, 145731, 145724, 146224, 112129, 145721, 112127, 146182, 143124, 117321, 112125, 143122, 112123, 144279, 145594, 145709, 145141, 145591, 144276, 112120, 145100, 140524, 145475, 145135, 145471, 145467, 145464, 145453, 144121, 145449, 119798, 145127, 145121, 145117, 145115, 144264, 144257, 144869, 144597, 144593, 144590, 134264, 144400, 144210, 144208, 144398, 134262, 143864, 143991, 144169, 144167, 143956, 140520, 144053, 140518, 140515, 140513, 140511, 140508, 140506, 140504, 143942, 143939, 143936, 143787, 143115, 142312, 142310, 142684, 142308, 142682, 142667, 143108, 117318, 141595, 141593, 141591, 141589, 143100, 143097, 142640, 127668, 127666, 141307, 142618, 142616, 141455, 141451, 139105, 127665, 142586, 142068, 139100, 141580, 139094, 142471, 141444, 141575, 141434, 97792, 138022, 141572, 134396, 141563, 141557, 141429, 139068, 139066, 139064, 141425, 141554, 141550, 142163, 142217, 142118, 141636, 141423, 142087, 142077, 141392, 141946, 141382, 141938, 128337, 129775, 117300, 140548, 140546, 141803, 138532, 96096, 140543, 138980, 96077, 141632, 138527, 141743, 141518, 141627, 138524, 141621, 133890, 140484, 140540, 141371, 139837, 141493, 141490, 141260, 141368, 141258, 138922, 138915, 141290, 140536, 140534, 141255, 140469, 138888, 138881, 138867, 138865, 140462, 140459, 140453, 140562, 136376, 140559, 136374, 140557, 140424, 140528, 140415, 140413, 140407, 140256, 140403, 133886, 140253, 140251, 127664, 133883, 127662, 140129, 140126, 138829, 133880, 127660, 137960, 138827, 138808, 137955, 138803, 139805, 138793, 138791, 139793, 126242, 138788, 138786, 138783, 138776, 127654, 139392, 126238, 134759, 139575, 138757, 138750, 138743, 139571, 138737, 119619, 134351, 134348, 139338, 134345, 138718, 138518, 82603, 127650, 138357, 138510, 138508, 138506, 138010, 138504, 138007, 138355, 138352, 138576, 138349, 138117, 136200, 136198, 136196, 127645, 136194, 137071, 127643, 137069, 127641, 137065, 127638, 137062, 127636, 137060, 137058, 137019, 138110, 18178, 138461, 117006, 138108, 137016, 133817, 133816, 137948, 133808, 137014, 136366, 133806, 133802, 124375, 120843, 137569, 124373, 137145, 133800, 133798, 124370, 115734, 137995, 127633, 137510, 137013, 137567, 134335, 137508, 137945, 137142, 136093, 137009, 133874, 137005, 137547, 137132, 137343, 136336, 136045, 122679, 129324, 137503, 137210, 136036, 136300, 137302, 136298, 137299, 137297, 137259, 136296, 137053, 136289, 136285, 137293, 137290, 137287, 137283, 136281, 137280, 137255, 137274, 137272, 137270, 137268, 137159, 137250, 135985, 135983, 137115, 137152, 137113, 137175, 137172, 137170, 136998, 136279, 136276, 135863, 133790, 136255, 135541, 135923, 135919, 136242, 95695, 135902, 135873, 129319, 135860, 135859, 129318, 135685, 122675, 135511, 122673, 129312, 129310, 135506, 133384, 129266, 117281, 126882, 71656, 123956, 134970, 135069, 129308, 135067, 126876, 129305, 135151, 129539, 129535, 129532, 126872, 126870, 134309, 134306, 135052, 129168, 135044, 135022, 115333, 129526, 129524, 129522, 134840, 134838, 134708, 134836, 134706, 133862, 134743, 134832, 129517, 133853, 129497, 134248, 96073, 133850, 129651, 117744, 134245, 134281, 133766, 133846, 133761, 133843, 129489, 123659, 124367, 133745, 129485, 133717, 133685, 133711, 128750, 129622, 128748, 129619, 130169, 133370, 133393, 117272, 96726, 129473, 129471, 133368, 130402, 129469, 133364, 129467, 129464, 129450, 129448, 128742, 130018, 129444, 129437, 129435, 129432, 129430, 130167, 129428, 123653, 130163, 121073, 129425, 123649, 129423, 127612, 129819, 129957, 129816, 129815, 119534, 128740, 128738, 129409, 129813, 129406, 129403, 129396, 129387, 129810, 129384, 128737, 129292, 128066, 129597, 129589, 128728, 128724, 128722, 127586, 127939, 123642, 127580, 127394, 127392, 123640, 127389, 128534, 127386, 127571, 122659, 122657, 119465, 128412, 127924, 127918, 128240, 127913, 127909, 127557, 127555, 127553, 127551, 128238, 127548, 125729, 128236, 110, 128224, 128221, 127538, 102291, 128041, 128039, 127384, 127533, 112946, 127500, 127422, 117263, 127459, 127607, 127522, 127520, 127454, 127451, 127448, 127414, 127409, 127366, 95692, 123388, 126955, 126867, 124847, 126857, 124845, 126842, 126855, 124841, 126837, 125500, 123378, 124832, 125497, 124830, 126085, 117249, 117248, 126080, 126078, 125982, 125980, 125975, 126068, 126066, 125973, 125523, 125520, 125479, 125477, 119410, 124757, 123937, 125939, 124753, 125472, 125534, 125517, 125532, 125528, 125514, 125467, 119375, 125282, 124733, 125254, 85303, 125250, 125247, 85300, 124984, 124982, 85287, 116659, 124706, 112945, 112943, 85282, 85279, 122941, 119345, 124529, 112940, 115922, 124185, 124511, 112937, 121528, 124182, 123633, 123630, 124178, 123623, 119335, 85701, 119330, 121565, 119324, 124207, 124200, 124195, 124190, 124188, 123923, 123614, 123913, 123910, 124135, 119294, 123604, 123599, 123596, 116656, 116653, 123593, 123592, 123580, 123785, 123576, 123574, 123570, 120929, 123564, 123498, 101171, 120925, 121146, 121830, 121089, 120923, 121145, 100315, 101169, 120082, 118908, 120133, 118906, 120131, 115148, 119024, 113968, 113964, 115144, 118900, 113961, 113959, 113957, 113955, 115140, 115915, 115913, 115911, 115129, 115909, 115907, 115905, 115069, 115904, 115031, 115029, 115023, 116953, 115021, 116950, 118348, 118346, 118344, 115016, 115012, 118342, 118340, 116936, 118051, 118049, 118047, 117944, 117943, 117939, 117937, 117935, 117932, 117929, 117927, 113776, 117924, 117922, 117897, 114979, 116927, 117193, 114977, 114975, 114973, 114476, 113756, 113754, 116795, 113752, 113748, 113746, 117023, 117021, 117000, 116637, 113017, 116634, 113014, 116769, 116630, 116845, 114929, 114927, 116624, 116651, 116618, 116649, 116613, 114921, 113010, 116609, 113946, 114917, 113703, 114914, 114912, 116395, 116529, 113699, 115695, 116481, 116411, 78376, 78374, 116389, 116406, 94784, 94782, 116327, 116324, 116321, 102642, 102640, 102638, 102636, 102634, 114670, 100136, 114668, 114665, 112642, 112641, 112639, 100093, 112635, 112629, 112627, 114867, 115868, 115504, 115866, 115863, 115502, 114859, 114309, 102629, 102627, 102625, 115657, 102623, 115845, 115843, 115928, 113674, 115841, 115669, 102621, 102619, 115649, 115665, 114700, 115647, 115663, 102616, 20180, 102614, 83541, 114698, 114834, 114832, 115604, 115600, 115557, 115414, 85252, 85250, 114830, 102610, 114817, 102607, 114772, 114659, 114760, 114812, 114351, 114810, 114758, 115290, 114807, 114805, 113653, 113651, 114783, 114755, 113646, 113552, 114753, 114745, 114742, 102606, 81324, 114433, 101165, 114416, 114414, 114410, 109491, 109483, 102604, 109477, 109474, 113644, 114201, 113641, 102602, 113638, 92308, 102600, 102598, 102596, 102592, 102590, 24214, 113894, 102588, 102586, 100090, 72111, 72107, 98205, 113892, 113785, 113782, 113620, 112876, 113481, 113477, 113474, 112872, 101890, 85242, 85240, 112925, 102205, 112919, 102203, 113039, 112900, 111648, 112897, 80182, 102279, 102277, 80177, 80171, 80169, 80166, 112247, 80164, 101707, 112283, 112281, 112279, 112686, 112683, 112672, 112681, 112676, 112669, 112243, 67820, 112593, 112570, 112565, 112563, 112478, 112561, 112559, 112393, 112557, 112268, 112434, 112555, 109462, 109459, 112481, 109454, 112462, 111085, 79305, 109443, 109440, 109437, 112293, 112097, 112253, 112251, 111081, 111741, 102470, 102461, 88753, 79301, 109419, 111839, 111789, 111786, 111739, 111819, 111817, 111751, 111665, 111663, 98992, 98989, 98987, 111734, 111731, 98985, 111724, 98983, 111719, 111716, 101414, 101410, 102196, 101408, 111111, 111108, 111105, 111100, 109415, 109410, 85225, 109407, 109405, 109402, 109400, 109398, 79296, 111318, 102583, 102581, 109389, 102578, 102577, 102575, 110999, 77412, 102573, 109384, 102571, 102570, 102568, 110997, 109382, 77411, 109380, 110877, 110873, 109377, 83877, 109375, 109369, 103325, 110865, 110818, 110816, 103241, 110812, 110808, 110859, 110806, 110855, 110803, 110801, 110799, 109364, 110796, 102975, 103298, 109360, 79290, 103296, 109357, 103220, 103218, 103215, 103211, 103209, 103206, 98433, 103203, 103201, 103199, 103270, 103196, 103191, 103189, 103135, 103131, 103126, 103121, 102972, 102969, 102952, 102949, 102945, 102943, 102941, 102939, 102936, 102934, 103117, 102932, 102566, 102564, 103114, 103112, 102562, 103109, 102560, 103107, 102260, 102733, 103104, 102558, 102555, 102551, 102549, 102877, 103002, 102875, 102873, 103000, 102996, 102927, 102869, 102867, 102925, 102906, 102923, 102921, 102864, 102904, 102919, 102862, 102859, 102857, 102852, 101778, 101775, 102850, 102847, 98632, 102803, 100311, 102833, 102801, 100309, 98630, 98625, 94870, 98621, 102546, 98617, 102191, 102190, 102188, 102544, 102542, 102373, 102539, 102537, 102501, 102534, 102532, 102499, 102530, 102526, 102522, 101649, 101647, 102496, 99482, 101643, 102482, 101640, 101638, 101635, 100198, 102177, 102174, 101138, 101763, 102360, 101632, 101630, 101625, 102171, 101597, 101594, 101812, 101579, 101808, 101570, 101568, 100787, 101385, 101382, 101522, 101107, 101105, 101091, 89068, 101089, 101380, 101285, 101378, 101154, 99308, 101405, 101153, 100783, 99477, 101342, 100459, 100836, 99462, 88751, 88749, 101009, 100806, 100992, 100867, 100984, 100981, 100980, 100977, 99457, 99020, 99455, 100778, 99451, 100768, 99447, 99444, 99442, 99440, 99438, 100180, 100178, 99965, 99943, 99940, 99938, 99933, 100174, 100171, 99929, 99927, 100169, 99924, 100167, 99920, 100165, 67788, 67777, 99901, 100032, 67775, 98969, 84547, 98965, 99307, 99589, 99553, 24158, 99384, 99404, 99297, 99402, 99295, 99290, 99340, 99288, 99338, 79838, 99337, 99092, 79836, 97597, 97586, 98938, 98934, 98932, 98927, 98612, 98738, 98610, 95686, 93290, 95682, 95680, 95678, 93931, 78363, 88726, 88721, 88298, 87693, 87342, 87112, 87110, 86205, 86202, 84551, 84522, 84026, 83843, 80729, 83414, 82989, 82986, 82984, 82976, 82975, 82973, 82968, 81797, 82924, 78701, 78700, 83000, 81795, 78696, 78692, 95, 78690, 78688, 93, 91, 89, 87, 81759, 81757, 81754, 81749, 81741, 81739, 81665, 81735, 81733, 85, 81731, 81729, 81728, 81726, 78683, 78681, 78679, 81544, 81542, 81541, 83, 81, 79, 77, 75))
Run Time: 0.086910
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2428 | |
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 | | | | | 2428 | |
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 (12925, 12625, 12458, 12407, 12344, 12158, 12077, 12001, 11573, 11382, 11282, 11250, 11207, 11117, 11116, 10911, 10894, 10871, 10839, 10560, 10518, 10503, 10414, 10370, 10312, 10215, 10205, 10173, 9792, 9779, 9625, 9612, 9523, 9455, 9248, 9107, 9091, 9058, 9053, 8801, 8782, 8728, 8672, 8636, 8635, 8522, 8521, 8493, 8409, 8383, 8348, 8335, 8278, 8277, 8265, 8200, 8182, 8162, 7455, 7339, 7134))
Run Time: 0.002959
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 61 | 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 (250330, 250291, 250265, 250182, 117524, 117519, 251054, 250156, 251052, 251050, 251047, 250553, 251039, 250136, 250542, 250059, 203006, 250446, 250444, 250436, 250433, 249882, 249486, 249480, 248948, 248777, 248774, 202993, 202990, 117501, 248298, 248290, 204857, 248086, 247922, 143219, 222525, 208174, 222297, 171349, 171342, 208118, 163599, 208154, 208189, 202435, 208023, 207893, 207041, 207029, 207027, 203770, 203751, 203736, 202490, 203455, 202487, 203452, 202484, 203566, 202865, 203437, 203563, 203536, 203431, 203557, 203427, 203462, 203528, 202863, 203479, 203412, 203476, 203472, 203469, 203411, 203279, 203271, 203191, 203189, 202915, 202882, 195199, 194739, 202251, 202907, 202248, 202812, 202718, 202465, 202214, 201723, 163588, 202124, 202005, 201719, 202183, 152223, 143206, 202023, 201999, 201997, 143205, 201991, 201837, 96765, 201786, 96763, 201835, 201782, 201953, 201759, 201710, 190008, 201949, 201832, 191087, 201779, 201707, 194310, 201773, 201704, 201751, 201802, 201694, 194947, 201692, 201688, 194944, 201359, 201682, 201499, 194734, 117455, 193226, 187132, 187130, 187128, 187126, 193213, 192541, 193102, 193100, 127694, 193072, 193095, 127692, 142822, 192736, 142820, 192602, 192599, 142816, 192727, 192724, 142814, 192713, 192635, 192571, 192631, 192562, 192590, 192513, 192531, 192325, 192447, 192323, 192317, 192067, 192065, 192063, 192061, 192054, 186009, 191969, 191337, 191334, 190261, 190124, 187314, 189803, 189801, 117442, 189848, 117436, 169854, 169852, 188281, 188277, 188275, 188357, 188270, 187236, 187161, 187914, 187851, 187849, 187846, 182650, 187389, 187387, 187232, 187228, 187294, 187366, 182637, 187219, 182632, 187323, 187217, 182630, 187292, 187319, 149461, 185942, 185552, 182260, 186000, 182138, 184139, 184134, 184132, 184130, 185079, 185549, 185511, 185027, 185464, 149451, 185396, 120527, 183188, 183185, 183183, 185037, 185018, 184937, 184652, 184115, 149445, 184646, 182091, 174895, 174893, 184015, 174887, 174884, 174882, 174878, 174872, 174867, 183296, 183294, 183290, 183277, 174861, 183648, 181325, 183267, 183369, 182336, 183265, 182583, 183136, 183107, 183261, 183259, 181704, 183103, 182059, 183078, 183076, 173895, 170857, 181782, 181775, 181768, 173891, 181764, 173888, 181761, 173886, 173884, 173881, 173879, 181758, 173877, 170363, 181755, 181983, 182656, 182369, 83171, 174654, 174990, 174981, 172876, 174800, 174728, 164449, 173930, 173926, 164447, 164445, 164442, 164440, 164438, 157966, 170845, 141532, 173458, 142809, 173361, 142807, 173039, 172902, 172749, 169944, 142790, 154887, 172858, 172855, 172274, 172724, 172272, 154884, 172664, 172303, 157958, 172100, 172270, 172301, 172299, 172297, 172295, 172327, 172293, 172095, 172213, 167292, 172263, 172277, 169940, 169880, 172196, 165332, 154882, 154879, 169877, 172060, 171299, 163253, 141523, 171937, 169875, 171296, 171844, 171827, 155209, 171448, 171444, 171376, 171406, 159377, 159852, 85557, 85555, 165322, 169641, 171247, 171356, 171267, 165316, 165314, 165313, 169548, 170633, 170631, 171019, 170718, 171005, 171003, 171000, 170824, 170658, 170561, 170382, 169151, 170377, 170354, 170558, 170537, 170457, 59181, 170351, 168993, 169939, 170445, 169937, 169935, 170194, 168002, 165306, 170065, 170071, 170063, 170020, 167712, 167710, 169916, 127689, 169913, 127687, 169959, 169911, 169909, 170036, 169987, 169985, 85551, 169982, 169980, 169977, 169835, 169610, 169335, 169604, 169602, 169599, 169739, 169597, 169498, 169493, 165736, 165273, 169485, 165732, 169685, 169296, 169594, 169575, 157899, 169590, 169302, 169077, 169477, 169475, 169526, 169472, 169522, 169145, 169450, 169510, 166703, 168667, 169508, 166701, 169333, 169140, 169298, 168877, 166888, 168951, 142788, 167380, 169243, 167375, 169118, 157938, 168175, 142786, 169094, 169064, 169057, 168979, 143154, 168941, 168888, 168871, 167372, 168868, 168864, 168702, 162335, 168657, 162333, 155188, 59174, 155182, 155179, 155174, 168166, 168452, 166016, 161567, 165263, 167503, 154604, 166430, 166425, 166866, 167254, 167251, 157848, 142768, 162529, 162527, 154877, 167493, 154871, 167491, 154602, 166970, 142766, 166915, 166803, 166993, 166908, 166902, 166523, 166793, 162518, 162516, 162515, 166413, 166411, 166409, 162510, 162508, 162506, 143150, 143149, 142762, 166164, 162503, 165523, 142758, 162499, 165518, 166094, 142755, 162497, 166081, 165514, 142753, 165637, 165511, 162495, 148281, 165994, 164690, 165870, 165694, 165632, 163738, 165479, 117398, 163922, 117395, 165452, 164427, 127686, 164424, 127684, 163853, 162489, 164824, 163848, 164348, 164422, 164410, 163826, 163821, 120489, 163819, 163240, 163816, 163663, 164812, 162486, 164474, 95354, 162484, 59167, 164402, 163743, 164207, 164386, 164203, 164372, 164195, 164192, 164189, 164187, 164185, 164181, 164179, 163876, 163874, 163940, 163938, 112816, 163904, 163621, 163641, 161610, 96150, 162929, 159398, 162927, 162923, 163281, 163233, 162174, 163290, 162480, 162478, 127682, 162172, 162476, 155688, 162471, 162170, 162464, 162167, 162933, 162916, 162461, 162164, 162440, 162162, 162456, 162804, 162454, 162437, 162646, 162669, 162667, 161558, 154901, 162404, 162321, 160580, 162311, 161555, 162453, 162309, 162302, 162448, 162234, 162430, 162300, 161553, 142752, 161605, 152177, 162298, 162156, 162154, 162150, 162148, 162183, 161599, 162090, 162051, 161588, 161537, 161535, 161005, 161353, 159603, 161386, 159975, 161069, 161148, 161143, 161141, 161065, 157881, 154870, 154868, 161040, 154866, 160821, 161014, 161038, 160817, 160910, 160906, 142741, 160814, 160493, 160466, 160460, 148275, 160453, 160442, 157749, 157747, 155169, 148690, 159845, 159360, 159937, 159584, 159357, 149432, 159349, 159345, 159419, 117369, 156566, 159343, 159338, 158150, 152143, 159302, 157874, 154863, 154861, 154859, 158147, 158139, 158136, 158133, 156516, 158129, 158124, 158673, 158121, 158662, 158116, 156480, 158484, 158114, 158112, 158482, 154278, 154274, 154271, 154264, 154258, 154256, 154254, 154251, 154247, 154242, 154239, 158111, 154237, 158108, 158035, 154233, 157758, 154231, 157980, 157868, 157816, 157812, 151061, 157800, 157797, 157790, 149388, 149384, 156783, 154505, 154208, 141342, 157554, 149358, 154595, 141339, 157547, 116131, 157317, 157315, 157312, 154591, 156778, 156711, 154200, 96129, 154588, 133933, 133929, 156759, 155872, 154500, 154175, 156705, 154498, 154161, 154159, 156375, 154155, 156111, 154153, 154495, 156180, 156168, 155850, 154142, 156106, 154136, 154131, 154126, 154585, 155666, 155663, 154734, 155619, 155658, 149324, 155727, 149320, 155758, 155756, 155754, 155750, 155723, 154070, 151633, 149315, 154986, 150651, 141337, 155652, 154111, 149311, 141335, 154487, 154982, 154729, 154109, 155107, 155080, 155076, 154898, 155053, 154858, 154856, 154354, 149301, 154850, 154848, 154351, 149297, 154896, 154812, 141332, 154482, 154978, 154844, 154348, 154835, 154583, 149269, 150884, 154344, 154581, 154043, 149252, 154479, 150879, 154542, 149246, 149225, 150872, 149204, 149198, 154314, 95344, 154312, 153292, 149192, 154010, 149764, 154060, 154003, 147200, 148270, 153984, 153894, 152747, 151849, 153848, 153244, 152806, 153329, 153324, 153313, 151764, 153254, 153067, 152790, 118022, 152091, 152089, 152941, 152653, 152651, 152779, 152608, 96736, 149168, 151053, 150415, 149166, 149157, 149154, 152120, 150866, 152131, 149113, 152128, 17353, 152124, 127681, 141297, 127679, 152115, 152055, 152024, 127677, 127675, 149964, 149104, 151878, 151321, 151870, 151867, 151865, 149085, 149080, 149078, 149076, 151840, 149066, 151622, 149063, 151310, 119970, 151344, 119968, 149050, 150297, 151195, 150295, 149047, 149826, 151191, 149043, 151189, 151187, 151077, 125991, 150030, 150289, 142726, 150908, 150923, 148962, 150753, 150399, 119953, 150860, 150287, 150767, 150750, 150745, 150764, 149908, 150395, 150391, 150738, 150707, 150704, 150700, 148949, 150733, 150667, 149707, 150551, 150567, 149903, 149797, 148903, 148897, 148895, 148887, 148884, 148878, 149793, 148855, 142720, 148850, 148656, 150019, 148626, 149746, 149703, 150011, 149943, 149941, 149867, 149936, 149864, 149955, 149952, 149852, 143135, 149850, 149845, 149819, 148792, 148621, 148788, 149700, 148122, 148762, 149656, 148760, 148755, 148118, 148465, 133922, 148741, 148737, 133917, 148735, 133913, 148726, 133908, 133903, 148717, 133901, 148614, 148612, 148635, 148632, 148610, 129298, 142504, 148387, 147954, 145143, 129296, 147952, 147950, 147948, 147946, 147944, 147942, 148351, 148212, 147940, 148255, 147513, 148253, 148246, 136790, 143132, 148105, 148205, 148203, 148103, 127947, 148054, 148184, 148180, 148097, 119891, 148094, 148048, 147856, 133897, 147854, 147874, 133895, 147919, 148046, 148040, 146209, 148091, 146542, 147850, 147848, 147500, 147497, 147868, 147493, 147665, 147663, 147489, 147661, 120973, 135081, 147554, 147278, 147588, 147552, 146091, 147005, 147582, 135077, 147269, 147311, 142697, 146521, 147082, 146959, 146622, 146513, 147259, 146511, 147257, 146075, 146070, 147022, 146818, 145926, 146787, 119843, 145885, 146200, 145869, 146198, 141270, 145867, 119840, 146573, 146195, 117327, 146503, 145787, 145758, 145573, 145745, 119830, 146192, 146191, 146254, 145731, 145724, 146224, 112129, 145721, 112127, 146182, 143124, 117321, 112125, 143122, 112123, 144279, 145594, 145709, 145141, 145591, 144276, 112120, 145100, 140524, 145475, 145135, 145471, 145467, 145464, 145453, 144121, 145449, 119798, 145127, 145121, 145117, 145115, 144264, 144257, 144869, 144597, 144593, 144590, 134264, 144400, 144210, 144208, 144398, 134262, 143864, 143991, 144169, 144167, 143956, 140520, 144053, 140518, 140515, 140513, 140511, 140508, 140506, 140504, 143942, 143939, 143936, 143787, 143115, 142312, 142310, 142684, 142308, 142682, 142667, 143108, 117318, 141595, 141593, 141591, 141589, 143100, 143097, 142640, 127668, 127666, 141307, 142618, 142616, 141455, 141451, 139105, 127665, 142586, 142068, 139100, 141580, 139094, 142471, 141444, 141575, 141434, 97792, 138022, 141572, 134396, 141563, 141557, 141429, 139068, 139066, 139064, 141425, 141554, 141550, 142163, 142217, 142118, 141636, 141423, 142087, 142077, 141392, 141946, 141382, 141938, 128337, 129775, 117300, 140548, 140546, 141803, 138532, 96096, 140543, 138980, 96077, 141632, 138527, 141743, 141518, 141627, 138524, 141621, 133890, 140484, 140540, 141371, 139837, 141493, 141490, 141260, 141368, 141258, 138922, 138915, 141290, 140536, 140534, 141255, 140469, 138888, 138881, 138867, 138865, 140462, 140459, 140453, 140562, 136376, 140559, 136374, 140557, 140424, 140528, 140415, 140413, 140407, 140256, 140403, 133886, 140253, 140251, 127664, 133883, 127662, 140129, 140126, 138829, 133880, 127660, 137960, 138827, 138808, 137955, 138803, 139805, 138793, 138791, 139793, 126242, 138788, 138786, 138783, 138776, 127654, 139392, 126238, 134759, 139575, 138757, 138750, 138743, 139571, 138737, 119619, 134351, 134348, 139338, 134345, 138718, 138518, 82603, 127650, 138357, 138510, 138508, 138506, 138010, 138504, 138007, 138355, 138352, 138576, 138349, 138117, 136200, 136198, 136196, 127645, 136194, 137071, 127643, 137069, 127641, 137065, 127638, 137062, 127636, 137060, 137058, 137019, 138110, 18178, 138461, 117006, 138108, 137016, 133817, 133816, 137948, 133808, 137014, 136366, 133806, 133802, 124375, 120843, 137569, 124373, 137145, 133800, 133798, 124370, 115734, 137995, 127633, 137510, 137013, 137567, 134335, 137508, 137945, 137142, 136093, 137009, 133874, 137005, 137547, 137132, 137343, 136336, 136045, 122679, 129324, 137503, 137210, 136036, 136300, 137302, 136298, 137299, 137297, 137259, 136296, 137053, 136289, 136285, 137293, 137290, 137287, 137283, 136281, 137280, 137255, 137274, 137272, 137270, 137268, 137159, 137250, 135985, 135983, 137115, 137152, 137113, 137175, 137172, 137170, 136998, 136279, 136276, 135863, 133790, 136255, 135541, 135923, 135919, 136242, 95695, 135902, 135873, 129319, 135860, 135859, 129318, 135685, 122675, 135511, 122673, 129312, 129310, 135506, 133384, 129266, 117281, 126882, 71656, 123956, 134970, 135069, 129308, 135067, 126876, 129305, 135151, 129539, 129535, 129532, 126872, 126870, 134309, 134306, 135052, 129168, 135044, 135022, 115333, 129526, 129524, 129522, 134840, 134838, 134708, 134836, 134706, 133862, 134743, 134832, 129517, 133853, 129497, 134248, 96073, 133850, 129651, 117744, 134245, 134281, 133766, 133846, 133761, 133843, 129489, 123659, 124367, 133745, 129485, 133717, 133685, 133711, 128750, 129622, 128748, 129619, 130169, 133370, 133393, 117272, 96726, 129473, 129471, 133368, 130402, 129469, 133364, 129467, 129464, 129450, 129448, 128742, 130018, 129444, 129437, 129435, 129432, 129430, 130167, 129428, 123653, 130163, 121073, 129425, 123649, 129423, 127612, 129819, 129957, 129816, 129815, 119534, 128740, 128738, 129409, 129813, 129406, 129403, 129396, 129387, 129810, 129384, 128737, 129292, 128066, 129597, 129589, 128728, 128724, 128722, 127586, 127939, 123642, 127580, 127394, 127392, 123640, 127389, 128534, 127386, 127571, 122659, 122657, 119465, 128412, 127924, 127918, 128240, 127913, 127909, 127557, 127555, 127553, 127551, 128238, 127548, 125729, 128236, 110, 128224, 128221, 127538, 102291, 128041, 128039, 127384, 127533, 112946, 127500, 127422, 117263, 127459, 127607, 127522, 127520, 127454, 127451, 127448, 127414, 127409, 127366, 95692, 123388, 126955, 126867, 124847, 126857, 124845, 126842, 126855, 124841, 126837, 125500, 123378, 124832, 125497, 124830, 126085, 117249, 117248, 126080, 126078, 125982, 125980, 125975, 126068, 126066, 125973, 125523, 125520, 125479, 125477, 119410, 124757, 123937, 125939, 124753, 125472, 125534, 125517, 125532, 125528, 125514, 125467, 119375, 125282, 124733, 125254, 85303, 125250, 125247, 85300, 124984, 124982, 85287, 116659, 124706, 112945, 112943, 85282, 85279, 122941, 119345, 124529, 112940, 115922, 124185, 124511, 112937, 121528, 124182, 123633, 123630, 124178, 123623, 119335, 85701, 119330, 121565, 119324, 124207, 124200, 124195, 124190, 124188, 123923, 123614, 123913, 123910, 124135, 119294, 123604, 123599, 123596, 116656, 116653, 123593, 123592, 123580, 123785, 123576, 123574, 123570, 120929, 123564, 123498, 101171, 120925, 121146, 121830, 121089, 120923, 121145, 100315, 101169, 120082, 118908, 120133, 118906, 120131, 115148, 119024, 113968, 113964, 115144, 118900, 113961, 113959, 113957, 113955, 115140, 115915, 115913, 115911, 115129, 115909, 115907, 115905, 115069, 115904, 115031, 115029, 115023, 116953, 115021, 116950, 118348, 118346, 118344, 115016, 115012, 118342, 118340, 116936, 118051, 118049, 118047, 117944, 117943, 117939, 117937, 117935, 117932, 117929, 117927, 113776, 117924, 117922, 117897, 114979, 116927, 117193, 114977, 114975, 114973, 114476, 113756, 113754, 116795, 113752, 113748, 113746, 117023, 117021, 117000, 116637, 113017, 116634, 113014, 116769, 116630, 116845, 114929, 114927, 116624, 116651, 116618, 116649, 116613, 114921, 113010, 116609, 113946, 114917, 113703, 114914, 114912, 116395, 116529, 113699, 115695, 116481, 116411, 78376, 78374, 116389, 116406, 94784, 94782, 116327, 116324, 116321, 102642, 102640, 102638, 102636, 102634, 114670, 100136, 114668, 114665, 112642, 112641, 112639, 100093, 112635, 112629, 112627, 114867, 115868, 115504, 115866, 115863, 115502, 114859, 114309, 102629, 102627, 102625, 115657, 102623, 115845, 115843, 115928, 113674, 115841, 115669, 102621, 102619, 115649, 115665, 114700, 115647, 115663, 102616, 20180, 102614, 83541, 114698, 114834, 114832, 115604, 115600, 115557, 115414, 85252, 85250, 114830, 102610, 114817, 102607, 114772, 114659, 114760, 114812, 114351, 114810, 114758, 115290, 114807, 114805, 113653, 113651, 114783, 114755, 113646, 113552, 114753, 114745, 114742, 102606, 81324, 114433, 101165, 114416, 114414, 114410, 109491, 109483, 102604, 109477, 109474, 113644, 114201, 113641, 102602, 113638, 92308, 102600, 102598, 102596, 102592, 102590, 24214, 113894, 102588, 102586, 100090, 72111, 72107, 98205, 113892, 113785, 113782, 113620, 112876, 113481, 113477, 113474, 112872, 101890, 85242, 85240, 112925, 102205, 112919, 102203, 113039, 112900, 111648, 112897, 80182, 102279, 102277, 80177, 80171, 80169, 80166, 112247, 80164, 101707, 112283, 112281, 112279, 112686, 112683, 112672, 112681, 112676, 112669, 112243, 67820, 112593, 112570, 112565, 112563, 112478, 112561, 112559, 112393, 112557, 112268, 112434, 112555, 109462, 109459, 112481, 109454, 112462, 111085, 79305, 109443, 109440, 109437, 112293, 112097, 112253, 112251, 111081, 111741, 102470, 102461, 88753, 79301, 109419, 111839, 111789, 111786, 111739, 111819, 111817, 111751, 111665, 111663, 98992, 98989, 98987, 111734, 111731, 98985, 111724, 98983, 111719, 111716, 101414, 101410, 102196, 101408, 111111, 111108, 111105, 111100, 109415, 109410, 85225, 109407, 109405, 109402, 109400, 109398, 79296, 111318, 102583, 102581, 109389, 102578, 102577, 102575, 110999, 77412, 102573, 109384, 102571, 102570, 102568, 110997, 109382, 77411, 109380, 110877, 110873, 109377, 83877, 109375, 109369, 103325, 110865, 110818, 110816, 103241, 110812, 110808, 110859, 110806, 110855, 110803, 110801, 110799, 109364, 110796, 102975, 103298, 109360, 79290, 103296, 109357, 103220, 103218, 103215, 103211, 103209, 103206, 98433, 103203, 103201, 103199, 103270, 103196, 103191, 103189, 103135, 103131, 103126, 103121, 102972, 102969, 102952, 102949, 102945, 102943, 102941, 102939, 102936, 102934, 103117, 102932, 102566, 102564, 103114, 103112, 102562, 103109, 102560, 103107, 102260, 102733, 103104, 102558, 102555, 102551, 102549, 102877, 103002, 102875, 102873, 103000, 102996, 102927, 102869, 102867, 102925, 102906, 102923, 102921, 102864, 102904, 102919, 102862, 102859, 102857, 102852, 101778, 101775, 102850, 102847, 98632, 102803, 100311, 102833, 102801, 100309, 98630, 98625, 94870, 98621, 102546, 98617, 102191, 102190, 102188, 102544, 102542, 102373, 102539, 102537, 102501, 102534, 102532, 102499, 102530, 102526, 102522, 101649, 101647, 102496, 99482, 101643, 102482, 101640, 101638, 101635, 100198, 102177, 102174, 101138, 101763, 102360, 101632, 101630, 101625, 102171, 101597, 101594, 101812, 101579, 101808, 101570, 101568, 100787, 101385, 101382, 101522, 101107, 101105, 101091, 89068, 101089, 101380, 101285, 101378, 101154, 99308, 101405, 101153, 100783, 99477, 101342, 100459, 100836, 99462, 88751, 88749, 101009, 100806, 100992, 100867, 100984, 100981, 100980, 100977, 99457, 99020, 99455, 100778, 99451, 100768, 99447, 99444, 99442, 99440, 99438, 100180, 100178, 99965, 99943, 99940, 99938, 99933, 100174, 100171, 99929, 99927, 100169, 99924, 100167, 99920, 100165, 67788, 67777, 99901, 100032, 67775, 98969, 84547, 98965, 99307, 99589, 99553, 24158, 99384, 99404, 99297, 99402, 99295, 99290, 99340, 99288, 99338, 79838, 99337, 99092, 79836, 97597, 97586, 98938, 98934, 98932, 98927, 98612, 98738, 98610, 95686, 93290, 95682, 95680, 95678, 93931, 78363, 88726, 88721, 88298, 87693, 87342, 87112, 87110, 86205, 86202, 84551, 84522, 84026, 83843, 80729, 83414, 82989, 82986, 82984, 82976, 82975, 82973, 82968, 81797, 82924, 78701, 78700, 83000, 81795, 78696, 78692, 95, 78690, 78688, 93, 91, 89, 87, 81759, 81757, 81754, 81749, 81741, 81739, 81665, 81735, 81733, 85, 81731, 81729, 81728, 81726, 78683, 78681, 78679, 81544, 81542, 81541, 83, 81, 79, 77, 75))
Run Time: 0.046929
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2428 | |
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 | | | | | 2428 | |
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 (12925, 12625, 12458, 12407, 12344, 12158, 12077, 12001, 11573, 11382, 11282, 11250, 11207, 11117, 11116, 10911, 10894, 10871, 10839, 10560, 10518, 10503, 10414, 10370, 10312, 10215, 10205, 10173, 9792, 9779, 9625, 9612, 9523, 9455, 9248, 9107, 9091, 9058, 9053, 8801, 8782, 8728, 8672, 8636, 8635, 8522, 8521, 8493, 8409, 8383, 8348, 8335, 8278, 8277, 8265, 8200, 8182, 8162, 7455, 7339, 7134))
Run Time: 0.003183
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 61 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, ��
Run Time: 0.000246
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.000451
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 215
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (120))
Run Time: 0.000649
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1716142185
Run Time: 0.000408
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 32 | 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` >= 1716142185)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000718
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 32 | 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