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.000602
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.000197
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` = '2191')
LIMIT 1
Run Time: 0.000424
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.002196
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_2191' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.051035
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 (211900, 335423, 224467, 236262, 224463, 335420, 57106, 236256, 335418, 57103, 236240, 224457, 335410, 265351, 335408, 236232, 335406, 180384, 180382, 105217, 57096, 236227, 180379, 57094, 236223, 236220, 335494, 236215, 335404, 317947, 317944, 325682, 236212, 335490, 180376, 325677, 325674, 335390, 236189, 329847, 329845, 325671, 180369, 335384, 325670, 329187, 105192, 105188, 322609, 334848, 105185, 317937, 317935, 325665, 105170, 317932, 329829, 332231, 334886, 334878, 334770, 325658, 332803, 332801, 332799, 195952, 328079, 331743, 332749, 329176, 195950, 262869, 329174, 328541, 329172, 317864, 329170, 322603, 325476, 109795, 317862, 332364, 317859, 317857, 310504, 109793, 329167, 329807, 317854, 329805, 325314, 317851, 317839, 328482, 317815, 317772, 322739, 317770, 317768, 109782, 109780, 327386, 325953, 311644, 180318, 319519, 326854, 325342, 322594, 224017, 224014, 224012, 319512, 224010, 109776, 321835, 317031, 109773, 180214, 266083, 109768, 180204, 105022, 109760, 23278, 180182, 109754, 262810, 179280, 262756, 262726, 178915, 178902, 267819, 268130, 235363, 266493, 131199, 235356, 178497, 235354, 178496, 178494, 178485, 178483, 265643, 261182, 265638, 266289, 140988, 109581, 178478, 178240, 265280, 265276, 178157, 178134, 143526, 109564, 109563, 178119, 104243, 109559, 104241, 109556, 262675, 178109, 178103, 262669, 209304, 253947, 178052, 177929, 264834, 177928, 177926, 177920, 177918, 177900, 177892, 177891, 109541, 263213, 264677, 177886, 177876, 177874, 260395, 260392, 260388, 260386, 177871, 177869, 177851, 177846, 177844, 177841, 177840, 264531, 264528, 264525, 177838, 264523, 264517, 264515, 104196, 264488, 177819, 177816, 264483, 263173, 194046, 264391, 177808, 177804, 264386, 177800, 177797, 177792, 177789, 177779, 177778, 262645, 263135, 177677, 263132, 263128, 263124, 209262, 262571, 177658, 262637, 186689, 262632, 177653, 195608, 262556, 177650, 263115, 177631, 261731, 195602, 131130, 262906, 262620, 262617, 177575, 195598, 195597, 82180, 261932, 177549, 177546, 82178, 177544, 177542, 255719, 177540, 195595, 195594, 209231, 82174, 209229, 209225, 261722, 255709, 255705, 261720, 209219, 177531, 255695, 209212, 177529, 222919, 209210, 255689, 222911, 177495, 260339, 222907, 251306, 177463, 177460, 260334, 177451, 177447, 177444, 177436, 177431, 209204, 250708, 261469, 260289, 260283, 177398, 186618, 222900, 260266, 177396, 177381, 186607, 260249, 260673, 177356, 260161, 104121, 104103, 104093, 104087, 104084, 177292, 260159, 235289, 131009, 104082, 177288, 177277, 258401, 235283, 177250, 260127, 177247, 209148, 209145, 177243, 259905, 209143, 258398, 258396, 258392, 177240, 260031, 258390, 259866, 251272, 195583, 177221, 195582, 177219, 260430, 260428, 260426, 177217, 177213, 260424, 260024, 260099, 177209, 260422, 177206, 260094, 177204, 259990, 177202, 259586, 177201, 260063, 209137, 259988, 195580, 177197, 186539, 177188, 177180, 177173, 177168, 259786, 259929, 177159, 259923, 177158, 259920, 259918, 258798, 177156, 259900, 177154, 177147, 259132, 259855, 186531, 186529, 177142, 128863, 186525, 128861, 186523, 104069, 186521, 128859, 186517, 177140, 177133, 177126, 177124, 177120, 177118, 177112, 186491, 177104, 177095, 177093, 195571, 186485, 186483, 177088, 186478, 177078, 177077, 259260, 186475, 193016, 177075, 177072, 258969, 193013, 177070, 177069, 177067, 186471, 186466, 258153, 259461, 186461, 258151, 259448, 258383, 177032, 186459, 257100, 177030, 186452, 186450, 186449, 258964, 259444, 259441, 195540, 177026, 209124, 176971, 176957, 176951, 256747, 258573, 128843, 257342, 258556, 195519, 257329, 258181, 257322, 258179, 204629, 195493, 176873, 195489, 176870, 195486, 195482, 257839, 257837, 195479, 257835, 248647, 257833, 204620, 258133, 251255, 176867, 251253, 251251, 176861, 257828, 257972, 176858, 176857, 176855, 176853, 257824, 176851, 176842, 176840, 176838, 176836, 176828, 128837, 257886, 176826, 257883, 176822, 195473, 257879, 195453, 195451, 195447, 184603, 184601, 251236, 251234, 251229, 255596, 249805, 249802, 249798, 176792, 249796, 256442, 257010, 176783, 257257, 204937, 176782, 249794, 176780, 176778, 176773, 250835, 176561, 248598, 248591, 250486, 248750, 248748, 250484, 128830, 250387, 249820, 249757, 176515, 176511, 249792, 249540, 249665, 128828, 249765, 249108, 128819, 248720, 176391, 176388, 207387, 204068, 247320, 222351, 190838, 207337, 222189, 194650, 207138, 222037, 194648, 204066, 207136, 191428, 222560, 206266, 204604, 176309, 176298, 176283, 192952, 192859, 191418, 193127, 193124, 193122, 191413, 192501, 192851, 192968, 103772, 192942, 192966, 192963, 192677, 192846, 192933, 192409, 192671, 192843, 192841, 192773, 192771, 192767, 176274, 192442, 137707, 137705, 176273, 192642, 176271, 103764, 176269, 176265, 192556, 176264, 103754, 192457, 192364, 176262, 176258, 143515, 103742, 192425, 176255, 176209, 190870, 190868, 191162, 190866, 190863, 191455, 191265, 191262, 191156, 191257, 191291, 191229, 176201, 191252, 191226, 191142, 191250, 191222, 176197, 176192, 191175, 176187, 176184, 176182, 176180, 176175, 190534, 176170, 191049, 176168, 190532, 190530, 158983, 176164, 190528, 176161, 176160, 158977, 158974, 190524, 190985, 158969, 190779, 158963, 190831, 190775, 190519, 187642, 190517, 190859, 187639, 176158, 190773, 190241, 190515, 190770, 190822, 176156, 187635, 190768, 190513, 190510, 190507, 190505, 190501, 190765, 190497, 190492, 190488, 176142, 176140, 190762, 176137, 176135, 186924, 176133, 190760, 176131, 186920, 190483, 190481, 176127, 176123, 176120, 190225, 187622, 176117, 176115, 187024, 103735, 176069, 176067, 176065, 176063, 176061, 176059, 186999, 176055, 190406, 186995, 186991, 103722, 186987, 186985, 186983, 186980, 186978, 186976, 103716, 103710, 103708, 103702, 103700, 190475, 190472, 190468, 190565, 190463, 190461, 190558, 151121, 151119, 151117, 151114, 187614, 187612, 187601, 187599, 187437, 151110, 187589, 176052, 190456, 190424, 187582, 151106, 190422, 190284, 151104, 151102, 190453, 184286, 176050, 190447, 190445, 190443, 176048, 190395, 190431, 190429, 176046, 143508, 176037, 190253, 176035, 190177, 190174, 187783, 176033, 187780, 190167, 190165, 176031, 187778, 182481, 176030, 187776, 185128, 190160, 185126, 186156, 182476, 182474, 187764, 176018, 187760, 176016, 176014, 186972, 176011, 190134, 190129, 185875, 189468, 176009, 187566, 176007, 187560, 176004, 176000, 190058, 175998, 190056, 190054, 187555, 190039, 190036, 187553, 190034, 187551, 186918, 187547, 190049, 187544, 190025, 189462, 182469, 182467, 189273, 175994, 189176, 182461, 189174, 188596, 182459, 103683, 189271, 175988, 186152, 186151, 189267, 189625, 189308, 175986, 166586, 189265, 188547, 188393, 189430, 189345, 189353, 189298, 189324, 189254, 188542, 189343, 189294, 185927, 188540, 186147, 189341, 186145, 188537, 189334, 189284, 188535, 188263, 189250, 189248, 189321, 175976, 175974, 188257, 189246, 187539, 189244, 188511, 189164, 188507, 187537, 188504, 187535, 188501, 188491, 188326, 186140, 187532, 188529, 188489, 188253, 166369, 186137, 166366, 186135, 188485, 185924, 187890, 187936, 181844, 157264, 187455, 187880, 186834, 185609, 186133, 186825, 100028, 187058, 186963, 187033, 186132, 186870, 186916, 186860, 186913, 186910, 186128, 100026, 186126, 184838, 184836, 100024, 175932, 185844, 185655, 185829, 175922, 185789, 175920, 174567, 185619, 175918, 155430, 175682, 175915, 175912, 175679, 185258, 185256, 185164, 185373, 103679, 185252, 185172, 162286, 175895, 185169, 103675, 185157, 103673, 175892, 184824, 103670, 185110, 185090, 185107, 184822, 185105, 162281, 175890, 175888, 175886, 175882, 175880, 175876, 184802, 184798, 183635, 184584, 184717, 184727, 168079, 183245, 168077, 137701, 168075, 168074, 181838, 181835, 168072, 175864, 175862, 168070, 182859, 175859, 168067, 168064, 168061, 183243, 181830, 175855, 182837, 182732, 181946, 181473, 143394, 182350, 182820, 168060, 182695, 163629, 175836, 137698, 168058, 137696, 168056, 168050, 168048, 182442, 168046, 168044, 182400, 103664, 175827, 103662, 137692, 137687, 175265, 137685, 163573, 181534, 182182, 182208, 182207, 182180, 137681, 181588, 175807, 181892, 137678, 181889, 175803, 175793, 175791, 181883, 175788, 175783, 181119, 137674, 181570, 175778, 175776, 181568, 181654, 175773, 181252, 175769, 175768, 181450, 175764, 122504, 181652, 181650, 181375, 181560, 163564, 181364, 137672, 163561, 181049, 155350, 137670, 175761, 175757, 175752, 137667, 137665, 167854, 175743, 174116, 137662, 175739, 171934, 137657, 175735, 175731, 181090, 173754, 181065, 175724, 181063, 137655, 175722, 175720, 175557, 181076, 156843, 181036, 156838, 175553, 181034, 175713, 175549, 181018, 175547, 173751, 175710, 175705, 175540, 175181, 175177, 174110, 175535, 174107, 175170, 175432, 174104, 137649, 158005, 174414, 173782, 173780, 172835, 100015, 172831, 173420, 173121, 173119, 169889, 168043, 171177, 171490, 171174, 168230, 168227, 171469, 171919, 171504, 171468, 171210, 171464, 167318, 171168, 171166, 170790, 171163, 170969, 170788, 171162, 170786, 170967, 170784, 171205, 171100, 171095, 170904, 170767, 170867, 170593, 170758, 170755, 170750, 169317, 159638, 170179, 170132, 168841, 170119, 170115, 168042, 168041, 168037, 164581, 169408, 168027, 167347, 169312, 169196, 168221, 168730, 159636, 169029, 165989, 112850, 168021, 168019, 168128, 168126, 168102, 168122, 168017, 168086, 167792, 167719, 167887, 167413, 167782, 167411, 167779, 167408, 165981, 159825, 167626, 167519, 167468, 167425, 166825, 167423, 167529, 167516, 167337, 166044, 143507, 167324, 167322, 143505, 166041, 167061, 167041, 166036, 165827, 164274, 165126, 165680, 164791, 163455, 164098, 154375, 163360, 163346, 163114, 163109, 163057, 162626, 162381, 162551, 161980, 162624, 162394, 162132, 161975, 162040, 160894, 156371, 160369, 161162, 160762, 155978, 159745, 160860, 152452, 160856, 152448, 154358, 158870, 158712, 158076, 158065, 155897, 122336, 158011, 157149, 157684, 156810, 157059, 156669, 157048, 156804, 143501, 156665, 156934, 112849, 155382, 155379, 155375, 155371, 155368, 154630, 153980, 154576, 154616, 154572, 154570, 153056, 143499, 153978, 154414, 153043, 151790, 152488, 153864, 140588, 140586, 153523, 153521, 153516, 143497, 153615, 143492, 152997, 130516, 152995, 143488, 152524, 140085, 152832, 152484, 152482, 140804, 140802, 152479, 151518, 130512, 151969, 150203, 151652, 150547, 103616, 148082, 137646, 151198, 137641, 137639, 149980, 150507, 147710, 43776, 145175, 143003, 147648, 147156, 146702, 142995, 142993, 146688, 147050, 146866, 145167, 146401, 146935, 145164, 143481, 143479, 145365, 88025, 143476, 145158, 143473, 145008, 143763, 88022, 143761, 145360, 145212, 145407, 144580, 145404, 144578, 130492, 125057, 143467, 143462, 125932, 125926, 112847, 103585, 144065, 103578, 141488, 103576, 143921, 144063, 143998, 103561, 142354, 143914, 103559, 143995, 143900, 143778, 143725, 140083, 141484, 133616, 143720, 140583, 143058, 143707, 133614, 143776, 143718, 143662, 99997, 140581, 140579, 140577, 143431, 143281, 143380, 140575, 140572, 142196, 143421, 143065, 143274, 142976, 142594, 141739, 141781, 141736, 141847, 141845, 133652, 142154, 142128, 140080, 137236, 137233, 141682, 141881, 141936, 141970, 127226, 141877, 141735, 122920, 141732, 141730, 140185, 139723, 141717, 141820, 141774, 141509, 140074, 138436, 140353, 124770, 138434, 140183, 140593, 140720, 129853, 136372, 140386, 140568, 140382, 139969, 140378, 140338, 140316, 139549, 140311, 139958, 140069, 137786, 138682, 139547, 139953, 136317, 140178, 139545, 140212, 139951, 138678, 139942, 140156, 140051, 139698, 140153, 140149, 139939, 140151, 140046, 139696, 140043, 139760, 140040, 122917, 139540, 122915, 139758, 140038, 139692, 122910, 139421, 122908, 122904, 122901, 122899, 122898, 139677, 139886, 139675, 139872, 139672, 139860, 139730, 139778, 139668, 139662, 122897, 138430, 138250, 139412, 118770, 139517, 122895, 122892, 118768, 136315, 122888, 122886, 139361, 122883, 136313, 116353, 122881, 122880, 138408, 128202, 138064, 138340, 122878, 137634, 135636, 137755, 137228, 137098, 137221, 137219, 136111, 135802, 121797, 135412, 135409, 135403, 135400, 135256, 135738, 135445, 135604, 43770, 134121, 126261, 135287, 126259, 125048, 134118, 135155, 135240, 135150, 135168, 135237, 135176, 128196, 80237, 134889, 134881, 134063, 134598, 134594, 134568, 134593, 133482, 133480, 133477, 134021, 128253, 134163, 134014, 130123, 133722, 133542, 133538, 123848, 129973, 129969, 129730, 128473, 128113, 128396, 125083, 128471, 129788, 116789, 128781, 81522, 98872, 129782, 127150, 129348, 124249, 127144, 128766, 125245, 125242, 124255, 122837, 124100, 118533, 123846, 123483, 118523, 118516, 123477, 121690, 123263, 123251, 123190, 122996, 122877, 122874, 122873, 122871, 122869, 122868, 122867, 117144, 120267, 120873, 117140, 120869, 118673, 120126, 120264, 120867, 120120, 118665, 118968, 118750, 118980, 115746, 118485, 118428, 118162, 118408, 86099, 118456, 118404, 118273, 112846, 114059, 113847, 113199, 113196, 94212, 94210, 112020, 94205, 111768, 111932, 111929, 98774, 111608, 112167, 110913, 103383, 112165, 111604, 111601, 111922, 111920, 111846, 94203, 86820, 111696, 111678, 111589, 109534, 103094, 103092, 109523, 110847, 110881, 110845, 109518, 110843, 103090, 109514, 109321, 102702, 103333, 103086, 103171, 103080, 102312, 102700, 101466, 102979, 101460, 102400, 102688, 96389, 102749, 102684, 102385, 102383, 99121, 102217, 102294, 102026, 99985, 99118, 99116, 99113, 99980, 84973, 99975, 70856, 43766, 88012, 82153, 99111, 99109))
Run Time: 0.096993
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1692 | |
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 | | | | | 1692 | |
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 (16386, 13498, 12167, 12004, 11796, 11624, 11381, 11174, 11162, 11120, 10856, 9886, 9768, 9718, 9453, 8966, 8531, 8481, 8404, 8230, 8192))
Run Time: 0.001421
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 21 | 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 (211900, 335423, 224467, 236262, 224463, 335420, 57106, 236256, 335418, 57103, 236240, 224457, 335410, 265351, 335408, 236232, 335406, 180384, 180382, 105217, 57096, 236227, 180379, 57094, 236223, 236220, 335494, 236215, 335404, 317947, 317944, 325682, 236212, 335490, 180376, 325677, 325674, 335390, 236189, 329847, 329845, 325671, 180369, 335384, 325670, 329187, 105192, 105188, 322609, 334848, 105185, 317937, 317935, 325665, 105170, 317932, 329829, 332231, 334886, 334878, 334770, 325658, 332803, 332801, 332799, 195952, 328079, 331743, 332749, 329176, 195950, 262869, 329174, 328541, 329172, 317864, 329170, 322603, 325476, 109795, 317862, 332364, 317859, 317857, 310504, 109793, 329167, 329807, 317854, 329805, 325314, 317851, 317839, 328482, 317815, 317772, 322739, 317770, 317768, 109782, 109780, 327386, 325953, 311644, 180318, 319519, 326854, 325342, 322594, 224017, 224014, 224012, 319512, 224010, 109776, 321835, 317031, 109773, 180214, 266083, 109768, 180204, 105022, 109760, 23278, 180182, 109754, 262810, 179280, 262756, 262726, 178915, 178902, 267819, 268130, 235363, 266493, 131199, 235356, 178497, 235354, 178496, 178494, 178485, 178483, 265643, 261182, 265638, 266289, 140988, 109581, 178478, 178240, 265280, 265276, 178157, 178134, 143526, 109564, 109563, 178119, 104243, 109559, 104241, 109556, 262675, 178109, 178103, 262669, 209304, 253947, 178052, 177929, 264834, 177928, 177926, 177920, 177918, 177900, 177892, 177891, 109541, 263213, 264677, 177886, 177876, 177874, 260395, 260392, 260388, 260386, 177871, 177869, 177851, 177846, 177844, 177841, 177840, 264531, 264528, 264525, 177838, 264523, 264517, 264515, 104196, 264488, 177819, 177816, 264483, 263173, 194046, 264391, 177808, 177804, 264386, 177800, 177797, 177792, 177789, 177779, 177778, 262645, 263135, 177677, 263132, 263128, 263124, 209262, 262571, 177658, 262637, 186689, 262632, 177653, 195608, 262556, 177650, 263115, 177631, 261731, 195602, 131130, 262906, 262620, 262617, 177575, 195598, 195597, 82180, 261932, 177549, 177546, 82178, 177544, 177542, 255719, 177540, 195595, 195594, 209231, 82174, 209229, 209225, 261722, 255709, 255705, 261720, 209219, 177531, 255695, 209212, 177529, 222919, 209210, 255689, 222911, 177495, 260339, 222907, 251306, 177463, 177460, 260334, 177451, 177447, 177444, 177436, 177431, 209204, 250708, 261469, 260289, 260283, 177398, 186618, 222900, 260266, 177396, 177381, 186607, 260249, 260673, 177356, 260161, 104121, 104103, 104093, 104087, 104084, 177292, 260159, 235289, 131009, 104082, 177288, 177277, 258401, 235283, 177250, 260127, 177247, 209148, 209145, 177243, 259905, 209143, 258398, 258396, 258392, 177240, 260031, 258390, 259866, 251272, 195583, 177221, 195582, 177219, 260430, 260428, 260426, 177217, 177213, 260424, 260024, 260099, 177209, 260422, 177206, 260094, 177204, 259990, 177202, 259586, 177201, 260063, 209137, 259988, 195580, 177197, 186539, 177188, 177180, 177173, 177168, 259786, 259929, 177159, 259923, 177158, 259920, 259918, 258798, 177156, 259900, 177154, 177147, 259132, 259855, 186531, 186529, 177142, 128863, 186525, 128861, 186523, 104069, 186521, 128859, 186517, 177140, 177133, 177126, 177124, 177120, 177118, 177112, 186491, 177104, 177095, 177093, 195571, 186485, 186483, 177088, 186478, 177078, 177077, 259260, 186475, 193016, 177075, 177072, 258969, 193013, 177070, 177069, 177067, 186471, 186466, 258153, 259461, 186461, 258151, 259448, 258383, 177032, 186459, 257100, 177030, 186452, 186450, 186449, 258964, 259444, 259441, 195540, 177026, 209124, 176971, 176957, 176951, 256747, 258573, 128843, 257342, 258556, 195519, 257329, 258181, 257322, 258179, 204629, 195493, 176873, 195489, 176870, 195486, 195482, 257839, 257837, 195479, 257835, 248647, 257833, 204620, 258133, 251255, 176867, 251253, 251251, 176861, 257828, 257972, 176858, 176857, 176855, 176853, 257824, 176851, 176842, 176840, 176838, 176836, 176828, 128837, 257886, 176826, 257883, 176822, 195473, 257879, 195453, 195451, 195447, 184603, 184601, 251236, 251234, 251229, 255596, 249805, 249802, 249798, 176792, 249796, 256442, 257010, 176783, 257257, 204937, 176782, 249794, 176780, 176778, 176773, 250835, 176561, 248598, 248591, 250486, 248750, 248748, 250484, 128830, 250387, 249820, 249757, 176515, 176511, 249792, 249540, 249665, 128828, 249765, 249108, 128819, 248720, 176391, 176388, 207387, 204068, 247320, 222351, 190838, 207337, 222189, 194650, 207138, 222037, 194648, 204066, 207136, 191428, 222560, 206266, 204604, 176309, 176298, 176283, 192952, 192859, 191418, 193127, 193124, 193122, 191413, 192501, 192851, 192968, 103772, 192942, 192966, 192963, 192677, 192846, 192933, 192409, 192671, 192843, 192841, 192773, 192771, 192767, 176274, 192442, 137707, 137705, 176273, 192642, 176271, 103764, 176269, 176265, 192556, 176264, 103754, 192457, 192364, 176262, 176258, 143515, 103742, 192425, 176255, 176209, 190870, 190868, 191162, 190866, 190863, 191455, 191265, 191262, 191156, 191257, 191291, 191229, 176201, 191252, 191226, 191142, 191250, 191222, 176197, 176192, 191175, 176187, 176184, 176182, 176180, 176175, 190534, 176170, 191049, 176168, 190532, 190530, 158983, 176164, 190528, 176161, 176160, 158977, 158974, 190524, 190985, 158969, 190779, 158963, 190831, 190775, 190519, 187642, 190517, 190859, 187639, 176158, 190773, 190241, 190515, 190770, 190822, 176156, 187635, 190768, 190513, 190510, 190507, 190505, 190501, 190765, 190497, 190492, 190488, 176142, 176140, 190762, 176137, 176135, 186924, 176133, 190760, 176131, 186920, 190483, 190481, 176127, 176123, 176120, 190225, 187622, 176117, 176115, 187024, 103735, 176069, 176067, 176065, 176063, 176061, 176059, 186999, 176055, 190406, 186995, 186991, 103722, 186987, 186985, 186983, 186980, 186978, 186976, 103716, 103710, 103708, 103702, 103700, 190475, 190472, 190468, 190565, 190463, 190461, 190558, 151121, 151119, 151117, 151114, 187614, 187612, 187601, 187599, 187437, 151110, 187589, 176052, 190456, 190424, 187582, 151106, 190422, 190284, 151104, 151102, 190453, 184286, 176050, 190447, 190445, 190443, 176048, 190395, 190431, 190429, 176046, 143508, 176037, 190253, 176035, 190177, 190174, 187783, 176033, 187780, 190167, 190165, 176031, 187778, 182481, 176030, 187776, 185128, 190160, 185126, 186156, 182476, 182474, 187764, 176018, 187760, 176016, 176014, 186972, 176011, 190134, 190129, 185875, 189468, 176009, 187566, 176007, 187560, 176004, 176000, 190058, 175998, 190056, 190054, 187555, 190039, 190036, 187553, 190034, 187551, 186918, 187547, 190049, 187544, 190025, 189462, 182469, 182467, 189273, 175994, 189176, 182461, 189174, 188596, 182459, 103683, 189271, 175988, 186152, 186151, 189267, 189625, 189308, 175986, 166586, 189265, 188547, 188393, 189430, 189345, 189353, 189298, 189324, 189254, 188542, 189343, 189294, 185927, 188540, 186147, 189341, 186145, 188537, 189334, 189284, 188535, 188263, 189250, 189248, 189321, 175976, 175974, 188257, 189246, 187539, 189244, 188511, 189164, 188507, 187537, 188504, 187535, 188501, 188491, 188326, 186140, 187532, 188529, 188489, 188253, 166369, 186137, 166366, 186135, 188485, 185924, 187890, 187936, 181844, 157264, 187455, 187880, 186834, 185609, 186133, 186825, 100028, 187058, 186963, 187033, 186132, 186870, 186916, 186860, 186913, 186910, 186128, 100026, 186126, 184838, 184836, 100024, 175932, 185844, 185655, 185829, 175922, 185789, 175920, 174567, 185619, 175918, 155430, 175682, 175915, 175912, 175679, 185258, 185256, 185164, 185373, 103679, 185252, 185172, 162286, 175895, 185169, 103675, 185157, 103673, 175892, 184824, 103670, 185110, 185090, 185107, 184822, 185105, 162281, 175890, 175888, 175886, 175882, 175880, 175876, 184802, 184798, 183635, 184584, 184717, 184727, 168079, 183245, 168077, 137701, 168075, 168074, 181838, 181835, 168072, 175864, 175862, 168070, 182859, 175859, 168067, 168064, 168061, 183243, 181830, 175855, 182837, 182732, 181946, 181473, 143394, 182350, 182820, 168060, 182695, 163629, 175836, 137698, 168058, 137696, 168056, 168050, 168048, 182442, 168046, 168044, 182400, 103664, 175827, 103662, 137692, 137687, 175265, 137685, 163573, 181534, 182182, 182208, 182207, 182180, 137681, 181588, 175807, 181892, 137678, 181889, 175803, 175793, 175791, 181883, 175788, 175783, 181119, 137674, 181570, 175778, 175776, 181568, 181654, 175773, 181252, 175769, 175768, 181450, 175764, 122504, 181652, 181650, 181375, 181560, 163564, 181364, 137672, 163561, 181049, 155350, 137670, 175761, 175757, 175752, 137667, 137665, 167854, 175743, 174116, 137662, 175739, 171934, 137657, 175735, 175731, 181090, 173754, 181065, 175724, 181063, 137655, 175722, 175720, 175557, 181076, 156843, 181036, 156838, 175553, 181034, 175713, 175549, 181018, 175547, 173751, 175710, 175705, 175540, 175181, 175177, 174110, 175535, 174107, 175170, 175432, 174104, 137649, 158005, 174414, 173782, 173780, 172835, 100015, 172831, 173420, 173121, 173119, 169889, 168043, 171177, 171490, 171174, 168230, 168227, 171469, 171919, 171504, 171468, 171210, 171464, 167318, 171168, 171166, 170790, 171163, 170969, 170788, 171162, 170786, 170967, 170784, 171205, 171100, 171095, 170904, 170767, 170867, 170593, 170758, 170755, 170750, 169317, 159638, 170179, 170132, 168841, 170119, 170115, 168042, 168041, 168037, 164581, 169408, 168027, 167347, 169312, 169196, 168221, 168730, 159636, 169029, 165989, 112850, 168021, 168019, 168128, 168126, 168102, 168122, 168017, 168086, 167792, 167719, 167887, 167413, 167782, 167411, 167779, 167408, 165981, 159825, 167626, 167519, 167468, 167425, 166825, 167423, 167529, 167516, 167337, 166044, 143507, 167324, 167322, 143505, 166041, 167061, 167041, 166036, 165827, 164274, 165126, 165680, 164791, 163455, 164098, 154375, 163360, 163346, 163114, 163109, 163057, 162626, 162381, 162551, 161980, 162624, 162394, 162132, 161975, 162040, 160894, 156371, 160369, 161162, 160762, 155978, 159745, 160860, 152452, 160856, 152448, 154358, 158870, 158712, 158076, 158065, 155897, 122336, 158011, 157149, 157684, 156810, 157059, 156669, 157048, 156804, 143501, 156665, 156934, 112849, 155382, 155379, 155375, 155371, 155368, 154630, 153980, 154576, 154616, 154572, 154570, 153056, 143499, 153978, 154414, 153043, 151790, 152488, 153864, 140588, 140586, 153523, 153521, 153516, 143497, 153615, 143492, 152997, 130516, 152995, 143488, 152524, 140085, 152832, 152484, 152482, 140804, 140802, 152479, 151518, 130512, 151969, 150203, 151652, 150547, 103616, 148082, 137646, 151198, 137641, 137639, 149980, 150507, 147710, 43776, 145175, 143003, 147648, 147156, 146702, 142995, 142993, 146688, 147050, 146866, 145167, 146401, 146935, 145164, 143481, 143479, 145365, 88025, 143476, 145158, 143473, 145008, 143763, 88022, 143761, 145360, 145212, 145407, 144580, 145404, 144578, 130492, 125057, 143467, 143462, 125932, 125926, 112847, 103585, 144065, 103578, 141488, 103576, 143921, 144063, 143998, 103561, 142354, 143914, 103559, 143995, 143900, 143778, 143725, 140083, 141484, 133616, 143720, 140583, 143058, 143707, 133614, 143776, 143718, 143662, 99997, 140581, 140579, 140577, 143431, 143281, 143380, 140575, 140572, 142196, 143421, 143065, 143274, 142976, 142594, 141739, 141781, 141736, 141847, 141845, 133652, 142154, 142128, 140080, 137236, 137233, 141682, 141881, 141936, 141970, 127226, 141877, 141735, 122920, 141732, 141730, 140185, 139723, 141717, 141820, 141774, 141509, 140074, 138436, 140353, 124770, 138434, 140183, 140593, 140720, 129853, 136372, 140386, 140568, 140382, 139969, 140378, 140338, 140316, 139549, 140311, 139958, 140069, 137786, 138682, 139547, 139953, 136317, 140178, 139545, 140212, 139951, 138678, 139942, 140156, 140051, 139698, 140153, 140149, 139939, 140151, 140046, 139696, 140043, 139760, 140040, 122917, 139540, 122915, 139758, 140038, 139692, 122910, 139421, 122908, 122904, 122901, 122899, 122898, 139677, 139886, 139675, 139872, 139672, 139860, 139730, 139778, 139668, 139662, 122897, 138430, 138250, 139412, 118770, 139517, 122895, 122892, 118768, 136315, 122888, 122886, 139361, 122883, 136313, 116353, 122881, 122880, 138408, 128202, 138064, 138340, 122878, 137634, 135636, 137755, 137228, 137098, 137221, 137219, 136111, 135802, 121797, 135412, 135409, 135403, 135400, 135256, 135738, 135445, 135604, 43770, 134121, 126261, 135287, 126259, 125048, 134118, 135155, 135240, 135150, 135168, 135237, 135176, 128196, 80237, 134889, 134881, 134063, 134598, 134594, 134568, 134593, 133482, 133480, 133477, 134021, 128253, 134163, 134014, 130123, 133722, 133542, 133538, 123848, 129973, 129969, 129730, 128473, 128113, 128396, 125083, 128471, 129788, 116789, 128781, 81522, 98872, 129782, 127150, 129348, 124249, 127144, 128766, 125245, 125242, 124255, 122837, 124100, 118533, 123846, 123483, 118523, 118516, 123477, 121690, 123263, 123251, 123190, 122996, 122877, 122874, 122873, 122871, 122869, 122868, 122867, 117144, 120267, 120873, 117140, 120869, 118673, 120126, 120264, 120867, 120120, 118665, 118968, 118750, 118980, 115746, 118485, 118428, 118162, 118408, 86099, 118456, 118404, 118273, 112846, 114059, 113847, 113199, 113196, 94212, 94210, 112020, 94205, 111768, 111932, 111929, 98774, 111608, 112167, 110913, 103383, 112165, 111604, 111601, 111922, 111920, 111846, 94203, 86820, 111696, 111678, 111589, 109534, 103094, 103092, 109523, 110847, 110881, 110845, 109518, 110843, 103090, 109514, 109321, 102702, 103333, 103086, 103171, 103080, 102312, 102700, 101466, 102979, 101460, 102400, 102688, 96389, 102749, 102684, 102385, 102383, 99121, 102217, 102294, 102026, 99985, 99118, 99116, 99113, 99980, 84973, 99975, 70856, 43766, 88012, 82153, 99111, 99109))
Run Time: 0.034822
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1692 | |
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 | | | | | 1692 | |
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 (16386, 13498, 12167, 12004, 11796, 11624, 11381, 11174, 11162, 11120, 10856, 9886, 9768, 9718, 9453, 8966, 8531, 8481, 8404, 8230, 8192))
Run Time: 0.001219
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 21 | 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, ��R
Run Time: 0.000178
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.000357
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.000511
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: 1717246398
Run Time: 0.000287
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 13 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
- XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Repository/SessionActivity.php at line 62
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*, `xf_user_User_1`.*
FROM `xf_session_activity`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1717246398)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000583
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 13 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | my_webapp.xf_session_activity.user_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivity.php at line 43
- XF\Repository\SessionActivity->getOnlineUsersList() in src/XF/Repository/SessionActivity.php at line 63
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20