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.000564
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.000205
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` = '2830')
LIMIT 1
Run Time: 0.000575
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.001717
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_2830' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.064542
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 (584461, 584448, 622393, 584266, 622383, 584252, 573592, 573587, 573580, 573575, 391233, 432743, 188852, 188850, 188848, 188845, 549806, 188841, 188838, 133031, 429943, 519128, 388855, 509116, 199604, 506319, 489997, 489995, 188798, 188794, 188789, 231783, 188786, 487425, 487423, 188785, 231636, 243113, 243110, 426601, 188782, 485281, 485276, 426227, 231397, 485262, 231392, 188778, 242968, 188774, 188772, 242902, 482120, 425707, 485230, 242806, 217862, 217860, 492329, 425568, 482079, 368138, 460799, 11934, 132637, 453424, 230396, 230394, 230392, 198990, 242266, 477926, 424820, 424795, 472109, 424708, 242187, 474547, 376140, 406402, 242149, 474352, 107851, 320858, 473362, 424618, 424616, 359954, 217189, 472977, 132579, 132575, 242126, 242124, 132570, 242116, 424580, 132567, 132564, 132562, 132560, 132553, 217143, 405925, 472043, 472039, 472031, 198815, 471626, 217131, 188764, 188762, 188760, 471512, 188757, 471510, 471508, 471506, 188756, 471504, 471502, 466147, 471500, 471389, 424514, 217028, 424483, 188755, 188753, 188751, 188749, 242030, 424460, 468849, 198671, 454880, 424401, 457721, 216920, 241827, 241819, 467045, 466938, 466943, 466924, 466201, 241776, 180950, 424240, 424238, 465868, 465370, 406348, 188748, 241725, 188745, 188743, 188741, 464322, 464310, 464683, 464305, 424143, 464291, 464289, 107727, 107716, 107713, 464282, 463395, 463392, 463896, 320724, 424117, 424115, 463757, 424094, 241671, 241669, 320705, 320701, 463170, 463168, 462978, 462968, 462311, 462299, 461682, 461675, 107676, 241610, 107665, 216735, 461460, 461411, 423986, 132398, 460645, 460558, 132389, 423928, 347921, 458527, 458525, 241536, 241534, 132385, 460261, 459772, 459770, 459263, 336218, 457596, 457172, 457170, 368073, 457560, 457554, 457160, 457119, 457117, 456541, 455556, 347899, 347896, 454144, 132303, 347893, 456363, 132289, 456011, 320664, 456007, 455985, 455828, 455982, 455980, 455966, 455721, 455718, 455553, 241342, 229600, 188739, 229571, 454870, 454972, 454970, 318317, 454864, 454862, 454859, 188736, 420530, 420528, 454256, 347887, 453871, 216509, 451469, 452139, 451703, 451696, 451667, 188734, 188733, 320617, 188731, 107494, 188728, 241172, 241168, 241166, 107486, 451368, 451365, 449708, 451221, 451363, 188719, 188717, 451334, 451238, 451236, 241158, 451231, 241150, 416247, 216420, 216418, 450042, 450552, 450669, 198084, 450068, 393032, 449903, 449896, 449894, 216395, 449892, 333569, 333564, 333562, 448540, 449350, 411650, 449490, 449164, 449016, 418913, 367096, 448976, 448863, 354741, 354739, 229265, 423099, 107427, 320581, 409772, 421300, 423415, 333553, 320567, 422318, 422314, 422475, 422633, 422630, 421295, 422069, 422464, 421293, 422407, 418689, 422286, 422246, 418768, 422177, 421285, 132212, 132210, 132207, 132203, 229114, 422048, 216227, 421322, 216224, 420069, 420065, 406569, 197947, 419727, 420508, 420506, 419715, 240828, 375230, 375219, 419918, 419457, 419445, 240765, 419255, 341731, 107324, 411593, 132181, 411591, 411586, 240730, 216154, 418589, 107298, 411581, 416794, 416979, 417457, 417538, 417536, 417533, 417455, 404069, 410022, 320490, 410018, 410014, 240673, 416749, 416743, 240623, 132144, 132104, 413573, 413571, 413568, 353046, 410662, 410660, 240470, 215897, 362316, 240429, 215882, 410645, 240422, 240415, 240413, 400154, 228663, 408329, 405213, 240319, 188707, 188702, 188698, 240203, 408678, 408320, 228485, 228481, 406894, 406708, 407864, 240102, 407420, 406884, 407338, 240049, 240044, 228376, 240012, 406882, 405585, 405184, 405180, 405175, 405173, 405168, 405166, 405158, 405151, 405577, 215622, 405138, 405575, 405572, 405569, 405134, 405132, 405120, 405115, 215590, 174234, 239920, 392316, 215531, 132062, 402383, 402381, 228162, 239823, 399190, 399188, 402323, 399178, 239805, 402141, 401760, 401692, 228140, 188119, 239695, 239629, 131927, 357848, 393741, 238882, 294228, 294223, 106491, 386624, 386620, 214800, 227442, 227440, 385579, 214705, 385183, 385238, 214698, 214694, 346344, 214671, 214665, 214663, 346341, 357061, 346339, 384699, 346333, 227358, 375164, 318518, 346316, 346312, 106346, 106343, 106341, 180919, 196788, 196786, 376052, 379779, 196768, 238427, 238419, 238417, 106324, 98805, 227112, 227105, 227103, 227100, 227097, 376984, 376820, 363560, 363558, 363556, 363554, 238255, 238253, 238251, 363552, 227016, 363549, 336880, 226990, 376033, 196661, 238214, 238212, 376030, 376576, 131818, 226974, 346234, 346232, 346230, 374774, 226938, 226908, 226906, 226904, 226903, 226900, 226898, 226896, 226894, 226874, 365115, 362037, 362029, 226739, 336875, 188691, 180887, 188689, 180854, 180634, 225543, 351095, 256177, 343951, 256174, 256172, 55198, 336874, 336872, 180316, 180314, 180312, 180310, 235875, 325610, 224000, 325608, 223991, 223973, 223971, 223942, 325600, 325597, 223935, 223930, 223928, 223926, 223924, 295334, 180285, 188667, 180152, 318504, 223817, 318502, 195843, 223734, 314543, 180122, 180120, 180117, 316922, 316920, 316917, 316911, 210859, 223706, 180067, 223697, 235697, 235694, 315828, 315812, 314537, 315367, 315365, 315361, 315357, 307193, 235662, 314511, 235627, 235586, 308360, 210666, 179981, 210656, 210654, 223545, 251865, 251859, 104873, 104869, 308347, 188665, 188662, 312457, 210592, 223478, 210587, 223473, 312096, 188659, 179956, 312085, 235558, 210573, 223447, 311850, 311885, 210570, 188658, 223442, 310494, 210547, 305334, 104815, 179949, 308294, 307380, 306244, 307178, 179928, 306709, 306720, 306707, 306589, 306586, 306583, 306581, 223340, 306096, 235505, 305332, 223307, 305330, 179906, 179904, 179902, 179900, 305328, 235480, 235477, 305326, 305323, 223227, 297657, 179807, 131404, 297779, 179791, 296075, 296073, 297776, 297774, 297772, 298254, 210161, 266010, 210148, 296271, 179764, 265980, 210140, 210135, 210133, 210130, 265978, 210128, 297754, 297584, 265970, 297578, 271474, 297563, 179752, 271466, 297675, 297555, 297553, 297187, 297216, 210109, 297174, 297443, 297439, 271462, 179749, 179747, 179745, 210104, 265962, 297045, 179734, 296261, 210092, 296256, 210079, 296470, 296688, 223135, 296169, 296026, 235423, 115381, 296018, 115378, 235417, 296043, 296041, 210058, 131375, 279652, 296003, 131373, 296039, 235414, 295949, 131366, 295947, 183039, 295945, 295003, 296036, 131361, 295942, 295940, 295936, 295934, 179731, 295927, 210042, 295886, 293928, 295329, 295327, 295325, 279649, 295318, 279647, 191713, 295311, 279645, 279643, 295303, 295301, 295298, 295296, 295294, 191710, 295292, 295290, 295288, 295287, 295286, 223132, 223130, 295278, 295276, 295274, 295272, 295270, 277151, 251530, 277149, 295263, 295257, 295255, 295251, 295085, 210033, 295239, 295236, 295231, 295229, 295227, 295223, 295222, 295220, 294602, 294600, 295217, 295216, 295213, 292026, 295070, 293913, 109688, 109686, 295204, 295198, 295196, 295055, 295183, 294722, 295181, 295179, 295175, 261195, 295171, 261189, 210028, 210026, 295042, 131353, 295036, 179723, 179721, 223122, 295091, 179720, 179718, 294747, 292873, 294902, 141104, 294739, 291424, 294588, 104720, 294516, 205002, 205000, 210003, 209999, 288689, 292871, 294116, 294114, 294112, 288687, 293878, 293876, 291627, 292070, 293874, 293868, 131346, 293866, 131343, 131340, 131337, 131335, 293862, 291621, 179697, 131330, 291606, 104696, 131312, 291602, 291600, 291598, 104693, 291595, 291589, 291587, 292066, 291585, 291421, 292178, 131304, 131302, 131300, 292162, 292160, 292157, 292155, 292154, 291186, 292145, 290975, 290967, 209984, 292041, 292037, 291937, 131295, 104668, 209976, 104643, 268657, 268654, 209960, 104630, 291011, 179673, 209953, 290415, 290352, 290676, 179662, 179659, 188649, 285801, 104580, 104578, 104576, 104574, 290322, 104572, 104570, 179658, 104568, 104566, 290312, 188648, 290042, 289922, 209941, 188643, 188641, 289703, 268638, 268636, 268634, 265922, 265920, 289899, 289895, 289890, 289887, 289882, 289879, 289875, 289695, 289871, 289862, 289860, 263091, 263086, 288743, 223115, 179655, 179653, 223108, 223099, 251466, 179644, 262815, 179636, 104551, 209909, 209907, 131279, 209897, 104520, 209895, 104517, 287591, 287589, 287893, 104512, 104509, 209892, 209887, 209884, 209881, 209879, 287631, 287582, 279969, 279967, 287578, 179592, 179590, 279960, 131276, 287573, 131271, 209853, 287570, 209851, 287568, 179587, 287565, 287563, 279956, 279954, 179586, 179584, 179581, 209846, 279950, 195663, 179579, 179577, 179575, 179568, 179560, 179555, 183018, 284821, 179551, 179549, 287276, 179547, 285766, 284809, 179545, 209838, 284805, 179541, 179539, 209821, 179536, 285754, 209818, 179533, 179528, 131265, 209780, 104491, 283745, 278943, 283107, 283087, 209760, 278941, 283067, 283037, 283033, 283031, 283025, 282862, 209741, 209739, 209737, 209733, 209729, 278934, 209707, 279985, 279902, 279983, 279900, 279897, 179463, 179443, 278922, 278920, 188636, 278918, 279093, 279014, 279011, 278900, 209670, 278898, 209666, 209664, 279001, 278999, 179415, 179411, 179408, 179405, 179404, 179399, 179388, 223089, 223087, 209636, 273256, 179372, 188633, 223081, 179338, 188630, 179336, 188628, 188620, 156873, 79346, 188618, 104475, 104472, 188616, 273744, 273741, 273737, 188614, 188612, 156852, 275734, 156849, 179321, 179318, 179316, 179314, 223076, 273556, 179301, 179298, 274244, 273588, 273552, 271179, 273211, 143536, 143534, 141061, 141059, 195649, 272052, 272997, 179274, 179272, 141051, 271163, 271157, 179261, 179260, 141046, 209605, 209603, 209600, 272017, 191701, 272004, 272071, 272000, 272066, 104457, 104455, 104453, 104451, 271932, 104449, 104446, 104444, 104435, 104433, 104431, 209577, 271600, 104429, 104426, 104424, 104410, 104407, 104405, 265872, 141027, 104402, 104396, 271596, 265865, 265863, 223064, 223062, 179232, 271290, 271288, 265840, 265837, 223055, 141022, 265814, 265813, 265812, 265811, 265810, 141018, 206512, 223042, 223040, 223037, 209564, 179206, 156660, 179204, 262760, 179197, 179195, 179193, 271151, 271149, 271111, 104380, 271146, 271097, 104351, 271095, 104349, 104346, 271091, 179189, 179188, 179103, 262067, 262064, 262062, 223021, 179096, 179093, 179091, 223018, 179089, 179087, 131226, 223012, 131221, 223010, 270399, 270351, 174124, 270358, 223008, 223006, 270346, 270344, 268596, 268594, 179075, 179074, 179072, 179070, 179068, 179065, 179062, 257127, 179060, 179058, 179055, 179049, 179047, 179045, 223002, 179037, 179032, 179030, 179028, 179027, 179025, 268586, 203653, 179017, 179015, 179011, 209535, 179000, 178997, 178995, 178992, 256495, 178991, 203647, 178977, 270082, 270080, 265785, 104282, 222994, 222992, 222989, 104280, 270195, 43807, 178961, 178959, 178954, 178952, 178951, 178945, 178932, 265778, 178930, 178906, 186797, 209516, 209514, 209508, 178901, 178899, 178890, 222984, 262723, 265760, 262721, 178880, 265756, 178878, 262719, 269640, 269644, 178874, 178867, 178865, 178863, 143026, 143024, 178859, 143016, 265745, 209482, 143014, 209479, 269503, 269499, 143010, 178807, 178805, 178801, 178778, 115373, 268578, 262712, 268353, 178776, 269117, 178771, 268571, 268569, 269113, 269110, 268566, 269105, 268558, 268549, 178747, 222950, 268461, 222947, 209386, 222944, 235385, 178738, 222942, 222940, 222938, 178724, 268272, 268269, 268348, 178699, 268360, 178697, 268346, 178690, 268343, 178676, 178672, 178657, 178655, 178653, 268236, 191683, 178614, 267023, 268234, 268019, 267021, 209371, 178602, 267016, 267014, 209363, 209361, 267962, 178577, 266997, 266995, 235375, 235373, 265680, 265676, 265673, 265671, 265670, 178510, 178508, 178506, 178504, 178502, 265657, 265655, 131202, 265653, 235371, 178501, 266902, 267112, 267110, 266900, 235353, 266897, 235350, 178495, 178491, 178488, 178486, 178482, 265644, 266729, 266705, 266699, 265626, 265624, 265623, 266689, 259682, 178477, 263266, 178462, 109574, 265613, 109569, 266532, 178459, 256295, 178450, 266553, 178446, 178444, 178442, 178440, 266551, 178437, 178435, 178433, 178431, 178429, 178427, 178425, 178423, 254033, 266518, 178417, 178414, 178411, 266489, 254031, 178407, 265587, 178391, 178389, 178385, 178382, 178379, 254833, 178377, 178375, 266448, 178352, 178350, 266445, 178348, 266390, 178340, 178338, 178336, 51286, 266387, 178331, 178329, 178327, 178324, 178322, 178319, 178316, 178314, 178312, 178309, 254013, 178307, 178305, 178303, 265308, 265306, 265304, 178301, 178295, 178293, 178291, 178289, 178287, 263185, 178284, 263183, 263181, 178282, 209326, 178248, 178242, 178239, 263951, 266282, 178224, 178222, 266324, 266320, 266237, 254009, 209311, 178196, 178192, 178190, 178188, 178186, 265599, 265596, 265582, 265594, 178184, 178173, 178166, 265285, 265279, 265277, 143531, 143529, 265275, 178159, 178156, 178154, 178152, 178149, 178146, 178141, 178138, 178136, 178133, 178131, 178129, 178127, 253980, 178126, 253977, 178124, 178122, 168858, 178120, 104247, 263176, 263174, 253973, 253968, 104244, 178117, 209309, 178110, 178108, 253961, 178106, 178088, 251391, 264889, 177944, 264835, 177927, 177925, 177923, 177921, 177917, 177915, 177913, 177910, 177908, 177905, 177903, 177901, 260398, 260396, 260393, 260391, 260389, 260387, 260384, 177860, 177856, 177853, 177791, 177788, 263728, 177786, 262094, 318895, 177777, 263943, 177774, 263167, 177772, 177766, 177764, 177762, 177760, 177758, 177757, 177754, 262920, 177751, 177749, 261825, 177747, 177744, 177742, 261823, 177740, 263156, 263718, 263152, 263716, 263714, 263712, 263710, 263706, 263150, 186730, 263704, 263148, 263700, 263697, 186727, 177723, 186726, 177709, 177707, 186724, 177705, 177703, 209273, 186721, 186719, 186717, 177697, 186715, 177689, 186711, 177687, 186708, 177685, 186706, 177682, 263497, 263494, 262589, 263130, 262585, 177676, 177674, 202114, 202112, 262583, 104195, 177672, 104193, 262581, 263125, 104191, 104189, 104186, 195615, 195612, 177664, 177662, 177659, 262915, 177657, 262913, 262911, 262908, 263040, 177655, 262540, 186684, 262538, 262890, 177644, 177642, 177638, 262903, 131124, 262887, 262511, 262509, 177619, 260374, 262601, 260371, 262597, 262595, 260368, 262506, 177612, 257726, 177609, 177606, 262272, 177604, 262270, 177590, 177570, 82186, 82184, 177568, 177566, 177564, 177559, 177555, 186676, 222920, 186674, 177553, 255723, 186672, 195596, 131106, 255706, 131104, 131102, 255704, 177539, 255700, 257716, 177534, 261718, 209218, 255694, 177518, 177517, 177515, 177513, 261736, 177509, 222913, 177503, 255690, 260360, 177486, 177483, 177480, 186664, 177476, 186661, 251321, 186652, 186650, 251318, 177468, 260340, 140966, 140964, 261407, 177435, 131071, 131069, 260331, 131066, 131064, 260329, 186637, 260327, 104181, 131062, 222151, 260686, 260684, 261442, 177399, 177397, 260682, 177393, 177391, 260625, 260679, 177388, 104170, 104168, 104166, 104165, 261392, 261390, 131051, 131048, 259154, 259152, 186613, 257694, 259150, 177386, 177384, 177382, 177375, 177373, 177371, 222895, 186610, 177366, 104159, 104157, 177345, 177343, 177338, 177336, 177334, 255108, 177331, 104155, 260229, 177329, 104152, 260227, 104150, 177327, 104148, 177321, 104144, 260222, 177319, 260220, 260211, 260208, 260206, 186600, 186597, 186595, 261168, 261166, 195589, 195588, 195586, 235346, 177305, 131036, 255106, 177302, 131034, 131030, 260844, 235344, 235342, 104136, 104134, 131026, 131024, 177299, 177297, 235329, 260181, 193207, 260178, 193204, 235314, 235312, 260172, 235309, 260670, 260610, 260663, 235305, 235301, 104124, 104118, 104116, 104114, 104112, 104110, 177295, 104107, 104104, 235299, 104100, 104098, 235297, 177293, 235295, 104095, 235293, 104091, 186567, 177290, 186564, 131006, 258409, 258407, 258405, 251286, 260158, 260156, 131004, 251284, 177283, 251282, 258402, 260153, 235286, 235284, 260151, 258826, 177276, 177274, 260149, 251279, 177272, 186556, 260146, 177270, 177265, 260140, 177248, 177246, 260116, 260112, 260095, 209135, 259986, 260007, 195577, 186541, 258823, 259984, 177189, 258821, 258819, 186538, 177187, 177185, 258817, 177172, 177170, 258807, 177167, 258805, 258803, 177165, 258801, 177163, 177149, 177145, 258794, 258792, 186528, 177141, 104075, 259755, 259752, 259715, 186513, 259750, 177135, 259734, 186502, 177122, 177119, 186498, 177117, 177115, 177114, 186494, 259273, 259271, 177085, 177083, 259024, 177042, 259490, 104047, 259488, 259087, 104045, 104043, 104041, 259486, 104039, 259483, 104036, 259481, 259479, 177039, 259021, 259477, 257106, 177037, 259425, 259085, 257102, 186464, 177035, 195550, 186456, 195548, 259080, 195546, 195544, 186453, 259423, 195542, 186451, 259445, 259443, 257098, 259257, 186448, 259077, 258005, 259075, 259421, 177025, 259074, 130990, 176987, 176985, 258624, 176982, 259063, 176950, 253362, 253360, 253357, 248670, 222887, 222885, 222883, 222879, 222877, 258876, 258872, 258870, 222875, 222868, 258609, 258607, 195526, 256142, 258604, 256139, 195521, 258558, 256137, 256134, 222864, 195518, 258548, 257069, 195511, 257057, 257341, 257054, 195509, 222862, 256016, 222859, 222857, 257052, 204635, 257050, 256013, 257490, 257048, 258365, 258292, 258357, 258355, 258248, 130975, 130972, 257464, 257849, 257046, 257044, 257461, 257847, 130969, 204632, 257843, 130962, 130960, 257459, 176881, 204626, 130958, 257975, 248650, 204624, 186407, 209026, 257456, 222853, 256057, 256055, 256117, 176742, 130940, 256109, 130938, 256100, 130936, 256098, 130934, 256037, 130932, 256008, 256093, 130928, 222791, 130925, 255516, 222776, 255101, 130905, 222763, 255098, 130900, 255095, 255531, 255092, 255527, 130875, 255514, 255524, 130872, 255089, 208957, 130868, 130866, 130863, 130849, 255265, 176689, 251166, 249126, 254765, 103996, 254763, 103992, 186277, 103989, 254759, 254757, 103976, 235275, 249038, 130823, 222751, 222749, 186251, 222747, 186249, 222744, 250898, 253323, 186239, 250896, 250894, 253320, 250892, 250890, 208928, 250887, 253316, 208926, 250885, 253314, 208924, 250883, 250881, 250880, 250878, 250877, 250875, 250873, 250869, 253299, 249037, 250865, 208892, 208881, 249032, 208879, 249030, 208877, 186218, 249028, 250864, 130813, 250860, 250858, 186202, 208442, 186200, 250848, 250843, 250841, 250837, 250833, 250831, 250824, 248552, 250822, 188611, 250820, 250818, 188609, 188608, 250816, 188606, 250814, 248801, 248549, 248537, 150493, 222134, 190245, 187641, 190242, 190240, 190238, 190236, 187633, 190232, 187623, 187620, 190477, 190434, 190224, 190221, 190430, 190213, 190211, 190209, 190206, 190204, 190202, 190201, 190198, 190183, 187574, 190181, 190178, 190175, 190169, 190166, 187572, 187570, 187567, 187563, 187562, 187559, 187556, 187552, 187550, 187548, 187546, 187545, 187543))
Run Time: 0.109514
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2299 | |
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 | | | | | 2299 | |
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 (20758, 19341, 18924, 18887, 16596, 14807, 14768, 14731, 14240, 14042, 13881, 13838, 13685, 13591, 13533, 13288, 13256, 13243, 13239, 13120, 13066, 12946, 12022, 12006))
Run Time: 0.002459
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 24 | 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 (584461, 584448, 622393, 584266, 622383, 584252, 573592, 573587, 573580, 573575, 391233, 432743, 188852, 188850, 188848, 188845, 549806, 188841, 188838, 133031, 429943, 519128, 388855, 509116, 199604, 506319, 489997, 489995, 188798, 188794, 188789, 231783, 188786, 487425, 487423, 188785, 231636, 243113, 243110, 426601, 188782, 485281, 485276, 426227, 231397, 485262, 231392, 188778, 242968, 188774, 188772, 242902, 482120, 425707, 485230, 242806, 217862, 217860, 492329, 425568, 482079, 368138, 460799, 11934, 132637, 453424, 230396, 230394, 230392, 198990, 242266, 477926, 424820, 424795, 472109, 424708, 242187, 474547, 376140, 406402, 242149, 474352, 107851, 320858, 473362, 424618, 424616, 359954, 217189, 472977, 132579, 132575, 242126, 242124, 132570, 242116, 424580, 132567, 132564, 132562, 132560, 132553, 217143, 405925, 472043, 472039, 472031, 198815, 471626, 217131, 188764, 188762, 188760, 471512, 188757, 471510, 471508, 471506, 188756, 471504, 471502, 466147, 471500, 471389, 424514, 217028, 424483, 188755, 188753, 188751, 188749, 242030, 424460, 468849, 198671, 454880, 424401, 457721, 216920, 241827, 241819, 467045, 466938, 466943, 466924, 466201, 241776, 180950, 424240, 424238, 465868, 465370, 406348, 188748, 241725, 188745, 188743, 188741, 464322, 464310, 464683, 464305, 424143, 464291, 464289, 107727, 107716, 107713, 464282, 463395, 463392, 463896, 320724, 424117, 424115, 463757, 424094, 241671, 241669, 320705, 320701, 463170, 463168, 462978, 462968, 462311, 462299, 461682, 461675, 107676, 241610, 107665, 216735, 461460, 461411, 423986, 132398, 460645, 460558, 132389, 423928, 347921, 458527, 458525, 241536, 241534, 132385, 460261, 459772, 459770, 459263, 336218, 457596, 457172, 457170, 368073, 457560, 457554, 457160, 457119, 457117, 456541, 455556, 347899, 347896, 454144, 132303, 347893, 456363, 132289, 456011, 320664, 456007, 455985, 455828, 455982, 455980, 455966, 455721, 455718, 455553, 241342, 229600, 188739, 229571, 454870, 454972, 454970, 318317, 454864, 454862, 454859, 188736, 420530, 420528, 454256, 347887, 453871, 216509, 451469, 452139, 451703, 451696, 451667, 188734, 188733, 320617, 188731, 107494, 188728, 241172, 241168, 241166, 107486, 451368, 451365, 449708, 451221, 451363, 188719, 188717, 451334, 451238, 451236, 241158, 451231, 241150, 416247, 216420, 216418, 450042, 450552, 450669, 198084, 450068, 393032, 449903, 449896, 449894, 216395, 449892, 333569, 333564, 333562, 448540, 449350, 411650, 449490, 449164, 449016, 418913, 367096, 448976, 448863, 354741, 354739, 229265, 423099, 107427, 320581, 409772, 421300, 423415, 333553, 320567, 422318, 422314, 422475, 422633, 422630, 421295, 422069, 422464, 421293, 422407, 418689, 422286, 422246, 418768, 422177, 421285, 132212, 132210, 132207, 132203, 229114, 422048, 216227, 421322, 216224, 420069, 420065, 406569, 197947, 419727, 420508, 420506, 419715, 240828, 375230, 375219, 419918, 419457, 419445, 240765, 419255, 341731, 107324, 411593, 132181, 411591, 411586, 240730, 216154, 418589, 107298, 411581, 416794, 416979, 417457, 417538, 417536, 417533, 417455, 404069, 410022, 320490, 410018, 410014, 240673, 416749, 416743, 240623, 132144, 132104, 413573, 413571, 413568, 353046, 410662, 410660, 240470, 215897, 362316, 240429, 215882, 410645, 240422, 240415, 240413, 400154, 228663, 408329, 405213, 240319, 188707, 188702, 188698, 240203, 408678, 408320, 228485, 228481, 406894, 406708, 407864, 240102, 407420, 406884, 407338, 240049, 240044, 228376, 240012, 406882, 405585, 405184, 405180, 405175, 405173, 405168, 405166, 405158, 405151, 405577, 215622, 405138, 405575, 405572, 405569, 405134, 405132, 405120, 405115, 215590, 174234, 239920, 392316, 215531, 132062, 402383, 402381, 228162, 239823, 399190, 399188, 402323, 399178, 239805, 402141, 401760, 401692, 228140, 188119, 239695, 239629, 131927, 357848, 393741, 238882, 294228, 294223, 106491, 386624, 386620, 214800, 227442, 227440, 385579, 214705, 385183, 385238, 214698, 214694, 346344, 214671, 214665, 214663, 346341, 357061, 346339, 384699, 346333, 227358, 375164, 318518, 346316, 346312, 106346, 106343, 106341, 180919, 196788, 196786, 376052, 379779, 196768, 238427, 238419, 238417, 106324, 98805, 227112, 227105, 227103, 227100, 227097, 376984, 376820, 363560, 363558, 363556, 363554, 238255, 238253, 238251, 363552, 227016, 363549, 336880, 226990, 376033, 196661, 238214, 238212, 376030, 376576, 131818, 226974, 346234, 346232, 346230, 374774, 226938, 226908, 226906, 226904, 226903, 226900, 226898, 226896, 226894, 226874, 365115, 362037, 362029, 226739, 336875, 188691, 180887, 188689, 180854, 180634, 225543, 351095, 256177, 343951, 256174, 256172, 55198, 336874, 336872, 180316, 180314, 180312, 180310, 235875, 325610, 224000, 325608, 223991, 223973, 223971, 223942, 325600, 325597, 223935, 223930, 223928, 223926, 223924, 295334, 180285, 188667, 180152, 318504, 223817, 318502, 195843, 223734, 314543, 180122, 180120, 180117, 316922, 316920, 316917, 316911, 210859, 223706, 180067, 223697, 235697, 235694, 315828, 315812, 314537, 315367, 315365, 315361, 315357, 307193, 235662, 314511, 235627, 235586, 308360, 210666, 179981, 210656, 210654, 223545, 251865, 251859, 104873, 104869, 308347, 188665, 188662, 312457, 210592, 223478, 210587, 223473, 312096, 188659, 179956, 312085, 235558, 210573, 223447, 311850, 311885, 210570, 188658, 223442, 310494, 210547, 305334, 104815, 179949, 308294, 307380, 306244, 307178, 179928, 306709, 306720, 306707, 306589, 306586, 306583, 306581, 223340, 306096, 235505, 305332, 223307, 305330, 179906, 179904, 179902, 179900, 305328, 235480, 235477, 305326, 305323, 223227, 297657, 179807, 131404, 297779, 179791, 296075, 296073, 297776, 297774, 297772, 298254, 210161, 266010, 210148, 296271, 179764, 265980, 210140, 210135, 210133, 210130, 265978, 210128, 297754, 297584, 265970, 297578, 271474, 297563, 179752, 271466, 297675, 297555, 297553, 297187, 297216, 210109, 297174, 297443, 297439, 271462, 179749, 179747, 179745, 210104, 265962, 297045, 179734, 296261, 210092, 296256, 210079, 296470, 296688, 223135, 296169, 296026, 235423, 115381, 296018, 115378, 235417, 296043, 296041, 210058, 131375, 279652, 296003, 131373, 296039, 235414, 295949, 131366, 295947, 183039, 295945, 295003, 296036, 131361, 295942, 295940, 295936, 295934, 179731, 295927, 210042, 295886, 293928, 295329, 295327, 295325, 279649, 295318, 279647, 191713, 295311, 279645, 279643, 295303, 295301, 295298, 295296, 295294, 191710, 295292, 295290, 295288, 295287, 295286, 223132, 223130, 295278, 295276, 295274, 295272, 295270, 277151, 251530, 277149, 295263, 295257, 295255, 295251, 295085, 210033, 295239, 295236, 295231, 295229, 295227, 295223, 295222, 295220, 294602, 294600, 295217, 295216, 295213, 292026, 295070, 293913, 109688, 109686, 295204, 295198, 295196, 295055, 295183, 294722, 295181, 295179, 295175, 261195, 295171, 261189, 210028, 210026, 295042, 131353, 295036, 179723, 179721, 223122, 295091, 179720, 179718, 294747, 292873, 294902, 141104, 294739, 291424, 294588, 104720, 294516, 205002, 205000, 210003, 209999, 288689, 292871, 294116, 294114, 294112, 288687, 293878, 293876, 291627, 292070, 293874, 293868, 131346, 293866, 131343, 131340, 131337, 131335, 293862, 291621, 179697, 131330, 291606, 104696, 131312, 291602, 291600, 291598, 104693, 291595, 291589, 291587, 292066, 291585, 291421, 292178, 131304, 131302, 131300, 292162, 292160, 292157, 292155, 292154, 291186, 292145, 290975, 290967, 209984, 292041, 292037, 291937, 131295, 104668, 209976, 104643, 268657, 268654, 209960, 104630, 291011, 179673, 209953, 290415, 290352, 290676, 179662, 179659, 188649, 285801, 104580, 104578, 104576, 104574, 290322, 104572, 104570, 179658, 104568, 104566, 290312, 188648, 290042, 289922, 209941, 188643, 188641, 289703, 268638, 268636, 268634, 265922, 265920, 289899, 289895, 289890, 289887, 289882, 289879, 289875, 289695, 289871, 289862, 289860, 263091, 263086, 288743, 223115, 179655, 179653, 223108, 223099, 251466, 179644, 262815, 179636, 104551, 209909, 209907, 131279, 209897, 104520, 209895, 104517, 287591, 287589, 287893, 104512, 104509, 209892, 209887, 209884, 209881, 209879, 287631, 287582, 279969, 279967, 287578, 179592, 179590, 279960, 131276, 287573, 131271, 209853, 287570, 209851, 287568, 179587, 287565, 287563, 279956, 279954, 179586, 179584, 179581, 209846, 279950, 195663, 179579, 179577, 179575, 179568, 179560, 179555, 183018, 284821, 179551, 179549, 287276, 179547, 285766, 284809, 179545, 209838, 284805, 179541, 179539, 209821, 179536, 285754, 209818, 179533, 179528, 131265, 209780, 104491, 283745, 278943, 283107, 283087, 209760, 278941, 283067, 283037, 283033, 283031, 283025, 282862, 209741, 209739, 209737, 209733, 209729, 278934, 209707, 279985, 279902, 279983, 279900, 279897, 179463, 179443, 278922, 278920, 188636, 278918, 279093, 279014, 279011, 278900, 209670, 278898, 209666, 209664, 279001, 278999, 179415, 179411, 179408, 179405, 179404, 179399, 179388, 223089, 223087, 209636, 273256, 179372, 188633, 223081, 179338, 188630, 179336, 188628, 188620, 156873, 79346, 188618, 104475, 104472, 188616, 273744, 273741, 273737, 188614, 188612, 156852, 275734, 156849, 179321, 179318, 179316, 179314, 223076, 273556, 179301, 179298, 274244, 273588, 273552, 271179, 273211, 143536, 143534, 141061, 141059, 195649, 272052, 272997, 179274, 179272, 141051, 271163, 271157, 179261, 179260, 141046, 209605, 209603, 209600, 272017, 191701, 272004, 272071, 272000, 272066, 104457, 104455, 104453, 104451, 271932, 104449, 104446, 104444, 104435, 104433, 104431, 209577, 271600, 104429, 104426, 104424, 104410, 104407, 104405, 265872, 141027, 104402, 104396, 271596, 265865, 265863, 223064, 223062, 179232, 271290, 271288, 265840, 265837, 223055, 141022, 265814, 265813, 265812, 265811, 265810, 141018, 206512, 223042, 223040, 223037, 209564, 179206, 156660, 179204, 262760, 179197, 179195, 179193, 271151, 271149, 271111, 104380, 271146, 271097, 104351, 271095, 104349, 104346, 271091, 179189, 179188, 179103, 262067, 262064, 262062, 223021, 179096, 179093, 179091, 223018, 179089, 179087, 131226, 223012, 131221, 223010, 270399, 270351, 174124, 270358, 223008, 223006, 270346, 270344, 268596, 268594, 179075, 179074, 179072, 179070, 179068, 179065, 179062, 257127, 179060, 179058, 179055, 179049, 179047, 179045, 223002, 179037, 179032, 179030, 179028, 179027, 179025, 268586, 203653, 179017, 179015, 179011, 209535, 179000, 178997, 178995, 178992, 256495, 178991, 203647, 178977, 270082, 270080, 265785, 104282, 222994, 222992, 222989, 104280, 270195, 43807, 178961, 178959, 178954, 178952, 178951, 178945, 178932, 265778, 178930, 178906, 186797, 209516, 209514, 209508, 178901, 178899, 178890, 222984, 262723, 265760, 262721, 178880, 265756, 178878, 262719, 269640, 269644, 178874, 178867, 178865, 178863, 143026, 143024, 178859, 143016, 265745, 209482, 143014, 209479, 269503, 269499, 143010, 178807, 178805, 178801, 178778, 115373, 268578, 262712, 268353, 178776, 269117, 178771, 268571, 268569, 269113, 269110, 268566, 269105, 268558, 268549, 178747, 222950, 268461, 222947, 209386, 222944, 235385, 178738, 222942, 222940, 222938, 178724, 268272, 268269, 268348, 178699, 268360, 178697, 268346, 178690, 268343, 178676, 178672, 178657, 178655, 178653, 268236, 191683, 178614, 267023, 268234, 268019, 267021, 209371, 178602, 267016, 267014, 209363, 209361, 267962, 178577, 266997, 266995, 235375, 235373, 265680, 265676, 265673, 265671, 265670, 178510, 178508, 178506, 178504, 178502, 265657, 265655, 131202, 265653, 235371, 178501, 266902, 267112, 267110, 266900, 235353, 266897, 235350, 178495, 178491, 178488, 178486, 178482, 265644, 266729, 266705, 266699, 265626, 265624, 265623, 266689, 259682, 178477, 263266, 178462, 109574, 265613, 109569, 266532, 178459, 256295, 178450, 266553, 178446, 178444, 178442, 178440, 266551, 178437, 178435, 178433, 178431, 178429, 178427, 178425, 178423, 254033, 266518, 178417, 178414, 178411, 266489, 254031, 178407, 265587, 178391, 178389, 178385, 178382, 178379, 254833, 178377, 178375, 266448, 178352, 178350, 266445, 178348, 266390, 178340, 178338, 178336, 51286, 266387, 178331, 178329, 178327, 178324, 178322, 178319, 178316, 178314, 178312, 178309, 254013, 178307, 178305, 178303, 265308, 265306, 265304, 178301, 178295, 178293, 178291, 178289, 178287, 263185, 178284, 263183, 263181, 178282, 209326, 178248, 178242, 178239, 263951, 266282, 178224, 178222, 266324, 266320, 266237, 254009, 209311, 178196, 178192, 178190, 178188, 178186, 265599, 265596, 265582, 265594, 178184, 178173, 178166, 265285, 265279, 265277, 143531, 143529, 265275, 178159, 178156, 178154, 178152, 178149, 178146, 178141, 178138, 178136, 178133, 178131, 178129, 178127, 253980, 178126, 253977, 178124, 178122, 168858, 178120, 104247, 263176, 263174, 253973, 253968, 104244, 178117, 209309, 178110, 178108, 253961, 178106, 178088, 251391, 264889, 177944, 264835, 177927, 177925, 177923, 177921, 177917, 177915, 177913, 177910, 177908, 177905, 177903, 177901, 260398, 260396, 260393, 260391, 260389, 260387, 260384, 177860, 177856, 177853, 177791, 177788, 263728, 177786, 262094, 318895, 177777, 263943, 177774, 263167, 177772, 177766, 177764, 177762, 177760, 177758, 177757, 177754, 262920, 177751, 177749, 261825, 177747, 177744, 177742, 261823, 177740, 263156, 263718, 263152, 263716, 263714, 263712, 263710, 263706, 263150, 186730, 263704, 263148, 263700, 263697, 186727, 177723, 186726, 177709, 177707, 186724, 177705, 177703, 209273, 186721, 186719, 186717, 177697, 186715, 177689, 186711, 177687, 186708, 177685, 186706, 177682, 263497, 263494, 262589, 263130, 262585, 177676, 177674, 202114, 202112, 262583, 104195, 177672, 104193, 262581, 263125, 104191, 104189, 104186, 195615, 195612, 177664, 177662, 177659, 262915, 177657, 262913, 262911, 262908, 263040, 177655, 262540, 186684, 262538, 262890, 177644, 177642, 177638, 262903, 131124, 262887, 262511, 262509, 177619, 260374, 262601, 260371, 262597, 262595, 260368, 262506, 177612, 257726, 177609, 177606, 262272, 177604, 262270, 177590, 177570, 82186, 82184, 177568, 177566, 177564, 177559, 177555, 186676, 222920, 186674, 177553, 255723, 186672, 195596, 131106, 255706, 131104, 131102, 255704, 177539, 255700, 257716, 177534, 261718, 209218, 255694, 177518, 177517, 177515, 177513, 261736, 177509, 222913, 177503, 255690, 260360, 177486, 177483, 177480, 186664, 177476, 186661, 251321, 186652, 186650, 251318, 177468, 260340, 140966, 140964, 261407, 177435, 131071, 131069, 260331, 131066, 131064, 260329, 186637, 260327, 104181, 131062, 222151, 260686, 260684, 261442, 177399, 177397, 260682, 177393, 177391, 260625, 260679, 177388, 104170, 104168, 104166, 104165, 261392, 261390, 131051, 131048, 259154, 259152, 186613, 257694, 259150, 177386, 177384, 177382, 177375, 177373, 177371, 222895, 186610, 177366, 104159, 104157, 177345, 177343, 177338, 177336, 177334, 255108, 177331, 104155, 260229, 177329, 104152, 260227, 104150, 177327, 104148, 177321, 104144, 260222, 177319, 260220, 260211, 260208, 260206, 186600, 186597, 186595, 261168, 261166, 195589, 195588, 195586, 235346, 177305, 131036, 255106, 177302, 131034, 131030, 260844, 235344, 235342, 104136, 104134, 131026, 131024, 177299, 177297, 235329, 260181, 193207, 260178, 193204, 235314, 235312, 260172, 235309, 260670, 260610, 260663, 235305, 235301, 104124, 104118, 104116, 104114, 104112, 104110, 177295, 104107, 104104, 235299, 104100, 104098, 235297, 177293, 235295, 104095, 235293, 104091, 186567, 177290, 186564, 131006, 258409, 258407, 258405, 251286, 260158, 260156, 131004, 251284, 177283, 251282, 258402, 260153, 235286, 235284, 260151, 258826, 177276, 177274, 260149, 251279, 177272, 186556, 260146, 177270, 177265, 260140, 177248, 177246, 260116, 260112, 260095, 209135, 259986, 260007, 195577, 186541, 258823, 259984, 177189, 258821, 258819, 186538, 177187, 177185, 258817, 177172, 177170, 258807, 177167, 258805, 258803, 177165, 258801, 177163, 177149, 177145, 258794, 258792, 186528, 177141, 104075, 259755, 259752, 259715, 186513, 259750, 177135, 259734, 186502, 177122, 177119, 186498, 177117, 177115, 177114, 186494, 259273, 259271, 177085, 177083, 259024, 177042, 259490, 104047, 259488, 259087, 104045, 104043, 104041, 259486, 104039, 259483, 104036, 259481, 259479, 177039, 259021, 259477, 257106, 177037, 259425, 259085, 257102, 186464, 177035, 195550, 186456, 195548, 259080, 195546, 195544, 186453, 259423, 195542, 186451, 259445, 259443, 257098, 259257, 186448, 259077, 258005, 259075, 259421, 177025, 259074, 130990, 176987, 176985, 258624, 176982, 259063, 176950, 253362, 253360, 253357, 248670, 222887, 222885, 222883, 222879, 222877, 258876, 258872, 258870, 222875, 222868, 258609, 258607, 195526, 256142, 258604, 256139, 195521, 258558, 256137, 256134, 222864, 195518, 258548, 257069, 195511, 257057, 257341, 257054, 195509, 222862, 256016, 222859, 222857, 257052, 204635, 257050, 256013, 257490, 257048, 258365, 258292, 258357, 258355, 258248, 130975, 130972, 257464, 257849, 257046, 257044, 257461, 257847, 130969, 204632, 257843, 130962, 130960, 257459, 176881, 204626, 130958, 257975, 248650, 204624, 186407, 209026, 257456, 222853, 256057, 256055, 256117, 176742, 130940, 256109, 130938, 256100, 130936, 256098, 130934, 256037, 130932, 256008, 256093, 130928, 222791, 130925, 255516, 222776, 255101, 130905, 222763, 255098, 130900, 255095, 255531, 255092, 255527, 130875, 255514, 255524, 130872, 255089, 208957, 130868, 130866, 130863, 130849, 255265, 176689, 251166, 249126, 254765, 103996, 254763, 103992, 186277, 103989, 254759, 254757, 103976, 235275, 249038, 130823, 222751, 222749, 186251, 222747, 186249, 222744, 250898, 253323, 186239, 250896, 250894, 253320, 250892, 250890, 208928, 250887, 253316, 208926, 250885, 253314, 208924, 250883, 250881, 250880, 250878, 250877, 250875, 250873, 250869, 253299, 249037, 250865, 208892, 208881, 249032, 208879, 249030, 208877, 186218, 249028, 250864, 130813, 250860, 250858, 186202, 208442, 186200, 250848, 250843, 250841, 250837, 250833, 250831, 250824, 248552, 250822, 188611, 250820, 250818, 188609, 188608, 250816, 188606, 250814, 248801, 248549, 248537, 150493, 222134, 190245, 187641, 190242, 190240, 190238, 190236, 187633, 190232, 187623, 187620, 190477, 190434, 190224, 190221, 190430, 190213, 190211, 190209, 190206, 190204, 190202, 190201, 190198, 190183, 187574, 190181, 190178, 190175, 190169, 190166, 187572, 187570, 187567, 187563, 187562, 187559, 187556, 187552, 187550, 187548, 187546, 187545, 187543))
Run Time: 0.040037
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2299 | |
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 | | | | | 2299 | |
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 (20758, 19341, 18924, 18887, 16596, 14807, 14768, 14731, 14240, 14042, 13881, 13838, 13685, 13591, 13533, 13288, 13256, 13243, 13239, 13120, 13066, 12946, 12022, 12006))
Run Time: 0.001361
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 24 | 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, �3�
Run Time: 0.000250
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.000328
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.000415
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: 1716178069
Run Time: 0.000250
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 10 | 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` >= 1716178069)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000460
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 10 | 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