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.000501
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.000159
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` = '5615')
LIMIT 1
Run Time: 0.000451
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.001527
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_5615' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.041488
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 (569223, 569220, 315151, 315150, 287112, 282601, 308087, 568773, 568772, 568712, 282599, 282597, 282595, 569091, 287110, 300289, 567586, 567585, 546668, 568958, 315147, 284967, 564431, 407063, 407062, 407061, 567556, 351272, 351271, 407059, 407058, 311062, 286565, 300287, 315145, 315144, 569073, 569076, 478127, 478126, 478123, 478119, 478118, 568955, 537833, 478116, 478115, 478114, 478113, 478110, 478108, 478107, 478104, 478103, 478101, 478100, 478096, 276343, 564655, 568819, 568817, 568816, 568815, 568813, 568812, 568810, 568809, 568807, 568806, 568805, 568804, 568791, 282580, 282579, 282578, 568623, 282577, 568621, 568620, 568635, 568618, 568616, 282576, 568615, 282575, 568709, 568613, 478092, 478091, 478090, 478089, 568763, 568762, 568609, 478087, 478086, 568608, 478085, 478084, 568607, 478082, 478081, 478080, 478079, 478078, 478077, 478074, 478073, 478072, 478071, 568707, 478067, 478060, 478059, 282568, 282555, 568600, 568404, 377352, 282529, 282528, 282524, 282523, 282522, 282520, 568086, 568082, 568080, 568078, 568076, 568074, 568073, 568071, 568068, 568067, 568065, 568097, 568063, 568060, 282510, 282499, 282498, 567186, 567185, 282495, 308079, 282488, 282487, 282484, 308076, 308075, 567023, 566164, 566382, 566160, 566159, 566137, 565565, 557868, 565019, 319127, 547093, 507608, 282038, 282033, 282028, 282027, 282025, 281941, 317367, 317365, 406071, 317364, 545140, 469621, 407049, 351270, 308022, 308011, 281706, 281704, 313033, 505645, 503938, 503937, 503936, 503995, 313030, 503991, 503988, 326236, 281027, 281020, 283942, 281014, 286944, 503000, 502123, 283940, 502121, 490858, 502510, 502115, 319290, 481130, 501375, 283938, 501372, 501370, 501368, 501366, 502111, 283937, 501999, 319284, 286427, 290579, 290577, 286425, 501362, 290575, 501360, 319277, 501358, 500168, 300227, 501643, 286937, 501553, 286931, 296862, 501341, 501338, 501296, 492890, 501213, 501210, 492888, 492885, 492883, 492881, 492879, 492876, 491474, 491472, 499731, 499677, 498722, 498944, 496496, 498236, 497990, 497984, 497981, 497979, 497975, 385722, 496121, 278248, 495021, 495146, 495016, 302869, 495207, 495205, 486548, 286926, 494187, 495137, 495135, 495131, 494587, 490527, 486545, 494583, 492976, 465093, 492970, 286924, 490525, 410352, 495009, 335206, 302533, 492692, 302866, 494818, 302531, 286916, 275587, 494573, 301470, 494571, 494256, 492872, 492690, 492870, 410351, 486166, 279327, 279325, 493796, 494084, 494387, 410350, 410347, 494251, 276171, 410345, 493791, 493789, 486163, 493992, 493787, 456707, 276167, 456705, 456703, 492866, 492864, 311016, 311014, 494272, 276164, 494270, 494249, 276161, 494265, 486161, 494263, 494247, 494261, 490808, 335204, 492190, 494241, 490807, 492188, 335202, 286400, 279317, 279315, 335200, 494031, 279312, 494029, 490805, 311012, 311010, 493944, 302855, 493942, 311008, 492702, 494081, 286398, 494095, 494027, 494025, 311006, 351266, 374106, 311000, 360348, 493783, 487170, 493838, 493835, 493833, 474995, 493779, 478873, 351264, 493776, 478871, 410343, 310993, 410341, 310991, 370144, 310989, 410339, 310987, 302851, 490797, 322674, 302530, 310983, 310981, 310978, 300221, 492187, 310976, 310974, 492185, 310972, 492183, 335197, 492181, 492179, 352388, 492176, 490256, 492859, 492688, 492853, 283931, 492741, 493010, 492851, 492849, 492847, 492845, 491657, 492738, 491895, 492843, 484059, 315449, 492736, 315448, 492841, 492801, 283928, 283926, 492839, 492799, 492836, 492834, 491655, 492586, 491887, 374103, 360136, 360134, 492758, 280995, 491885, 280993, 280991, 360131, 374097, 491882, 492683, 492681, 492679, 492677, 492584, 345217, 302836, 491931, 491929, 491857, 491870, 491867, 307959, 484968, 491862, 484965, 484963, 484961, 491617, 484958, 313026, 313024, 280982, 280979, 280965, 395173, 484269, 484266, 315092, 315090, 483550, 473157, 480739, 280955, 288574, 315950, 483534, 290545, 274233, 483558, 483556, 274229, 360968, 468091, 360966, 274227, 483530, 483528, 319721, 483510, 319719, 479972, 479968, 479966, 483182, 307145, 313018, 483142, 483095, 342194, 342192, 342190, 483090, 342183, 467571, 356498, 276154, 342180, 276152, 482662, 461983, 342177, 482767, 280952, 342175, 274033, 482456, 283906, 310938, 316507, 310936, 310934, 461201, 482366, 286363, 481007, 300206, 407255, 316505, 480032, 482357, 482355, 482353, 286360, 286358, 316503, 479623, 479621, 481475, 481325, 301896, 473336, 300204, 482181, 479316, 478235, 480030, 481471, 481955, 481001, 482020, 472438, 279288, 305978, 279286, 279284, 461199, 279282, 279280, 472436, 305975, 305972, 351254, 351252, 351250, 351248, 279273, 480711, 480319, 480364, 480362, 276148, 276146, 460861, 480317, 480349, 291384, 480313, 480311, 480309, 480306, 291382, 480299, 407101, 456699, 480157, 480154, 395155, 276885, 276883, 477081, 473335, 479616, 479613, 479612, 479955, 413954, 479611, 314324, 392027, 286846, 477871, 302812, 302807, 477749, 477740, 280937, 302804, 280935, 302802, 477263, 472359, 477196, 477194, 477037, 476989, 414982, 476987, 476984, 477033, 410402, 476980, 476978, 476590, 451870, 280930, 476521, 476298, 476274, 316643, 316641, 475476, 276139, 276137, 454003, 377348, 301464, 316638, 280928, 475474, 475463, 475459, 286841, 276135, 276874, 280926, 276132, 475456, 310932, 475454, 475452, 310930, 310928, 337337, 472422, 472420, 451869, 280922, 451868, 275323, 459461, 468441, 468438, 475108, 459459, 474624, 337335, 475106, 468436, 474697, 468434, 475007, 310914, 454580, 395148, 475004, 475002, 474957, 474954, 474874, 395146, 451867, 276131, 474948, 279252, 276129, 474667, 474419, 474665, 474612, 279246, 326163, 279244, 454579, 326161, 451897, 461186, 395145, 455213, 276127, 461183, 451865, 474689, 279241, 346113, 474602, 454578, 454576, 313016, 451893, 474415, 474413, 474412, 454574, 313014, 346111, 467560, 346109, 365948, 474411, 451891, 473798, 451889, 451888, 321572, 472400, 473714, 295705, 474409, 330990, 473795, 474407, 335194, 361772, 293651, 330987, 465197, 451864, 293649, 465195, 395143, 352301, 335192, 294335, 294333, 293647, 305966, 465185, 473334, 280921, 467834, 458016, 330983, 346107, 473789, 473787, 462636, 473785, 468431, 468429, 473304, 473299, 470419, 420745, 471742, 472942, 473295, 473149, 473264, 451863, 459484, 472936, 472663, 451861, 356679, 472659, 473030, 472399, 305965, 280920, 473259, 472934, 473148, 473147, 472927, 473140, 286831, 286828, 413520, 280918, 472353, 280916, 280914, 472351, 472348, 291783, 280912, 291781, 291779, 291777, 313012, 472413, 395138, 472411, 472339, 466351, 315443, 315442, 315439, 280910, 352297, 456192, 360632, 451860, 280908, 412683, 459453, 352295, 315438, 315436, 315434, 334093, 462629, 471696, 315432, 471773, 471646, 470443, 416329, 392023, 456189, 416327, 470441, 395136, 471693, 468614, 470210, 469662, 470438, 280907, 470436, 315429, 471767, 315427, 316482, 471756, 416325, 471741, 471691, 471754, 416323, 416319, 315424, 470947, 471569, 276117, 280905, 286816, 276114, 280899, 462169, 276112, 317337, 280897, 286813, 469609, 286811, 395130, 470984, 315421, 471432, 470936, 471430, 418106, 470764, 470762, 470705, 470702, 470699, 280893, 470758, 470756, 280891, 280889, 459447, 469658, 469656, 417045, 467301, 469459, 459443, 469647, 395119, 315417, 467299, 467297, 417042, 376776, 280886, 470048, 376774, 376772, 280884, 467293, 469698, 422942, 469593, 307094, 469638, 469633, 469631, 469583, 469582, 469521, 376767, 469519, 385094, 469450, 469444, 469447, 452814, 463243, 351246, 307092, 422933, 280881, 291769, 467276, 280877, 280875, 395114, 422919, 422917, 422915, 294319, 280873, 422913, 469073, 422911, 422908, 280871, 395112, 291767, 334087, 291765, 286332, 300194, 468610, 467618, 467616, 468748, 468742, 462826, 413947, 467271, 412936, 467269, 412934, 351244, 395109, 467266, 467265, 468604, 391473, 468089, 396718, 468081, 305956, 305954, 305952, 412682, 468336, 460860, 395106, 392019, 392017, 392009, 459028, 468078, 395100, 280868, 395098, 395096, 395093, 468076, 395086, 451858, 395085, 313004, 296840, 395082, 280865, 454000, 395079, 395078, 467007, 307090, 410907, 306987, 300446, 306983, 306981, 466333, 306979, 306973, 300444, 400475, 326150, 466261, 306963, 466258, 304793, 300442, 291763, 346104, 398218, 395074, 346102, 280863, 280862, 354956, 465609, 392001, 391999, 462034, 346098, 420741, 413912, 465598, 279227, 464955, 413907, 465351, 465349, 465347, 465343, 465329, 465260, 394965, 394963, 394961, 463207, 385719, 385717, 464762, 394953, 463235, 293132, 395064, 464271, 463205, 458425, 456469, 464269, 464267, 293130, 291378, 461062, 461431, 460548, 461625, 461101, 462343, 464208, 462160, 463233, 326028, 464265, 403281, 451857, 462219, 463339, 460652, 463927, 464447, 464263, 464677, 464444, 461783, 291376, 462029, 462027, 395062, 463941, 313001, 455212, 275250, 458577, 275248, 463925, 463933, 395059, 307086, 459047, 315413, 346086, 463225, 283888, 463354, 319097, 459045, 463222, 315075, 463146, 463202, 463100, 461403, 463095, 461400, 280849, 391511, 455203, 451855, 462781, 398217, 292210, 365946, 342965, 461168, 459523, 336837, 365943, 462211, 336835, 461166, 336832, 365941, 462478, 336829, 374054, 300436, 300433, 395056, 461780, 335189, 300431, 458606, 461154, 461152, 300429, 461778, 461094, 414966, 461776, 461303, 459390, 461092, 461090, 461088, 300427, 461616, 461150, 461086, 461145, 300425, 300423, 461141, 313190, 395051, 315412, 459376, 280839, 374040, 461071, 461069, 461067, 461065, 335186, 404230, 280837, 459365, 337647, 460633, 321571, 460083, 395049, 397504, 335183, 460092, 407243, 352271, 278803, 460090, 460545, 451972, 411172, 460733, 315411, 451665, 453905, 407036, 405320, 376294, 280833, 453902, 452991, 460402, 460492, 395047, 460488, 458419, 460481, 411164, 310897, 458600, 458328, 459058, 459261, 460131, 460020, 460081, 279216, 279214, 279211, 460276, 460143, 300421, 395044, 460141, 458991, 300419, 458956, 274226, 459794, 459790, 293097, 459352, 452360, 458985, 458982, 458414, 458409, 330981, 330979, 330977, 458006, 458038, 458031, 280814, 280810, 280808, 456932, 457115, 457001, 451853, 452783, 452780, 456185, 456963, 451852, 456816, 456814, 451850, 456322, 456812, 456810, 451849, 451602, 456458, 451847, 451845, 280799, 456686, 280797, 419097, 456177, 414954, 280793, 280791, 280789, 280786, 456386, 456384, 419095, 419093, 449364, 456500, 319713, 319711, 456451, 422798, 280784, 423498, 310878, 328775, 456381, 456175, 328773, 416197, 328771, 451843, 456173, 416193, 456170, 456318, 455200, 455198, 335174, 456168, 423496, 286786, 456166, 454389, 452410, 407100, 360441, 454568, 455196, 455194, 407234, 280782, 280780, 280778, 280776, 296834, 319707, 407232, 423494, 453998, 286321, 296831, 451842, 451840, 451838, 394950, 454562, 451836, 330975, 394948, 452112, 454560, 360437, 455638, 449362, 394944, 449401, 394942, 453997, 423492, 455191, 449399, 452408, 286318, 292225, 451835, 286315, 406667, 406665, 423490, 286313, 286309, 286307, 286304, 422013, 420117, 454555, 286302, 454553, 453027, 409904, 452406, 454650, 423488, 454931, 279208, 454792, 286299, 454648, 454366, 454643, 454287, 454641, 454285, 404222, 404220, 454282, 449397, 449395, 449393, 454547, 449391, 300186, 286290, 449389, 420116, 449387, 420114, 280775, 304307, 354929, 354927, 354925, 354923, 315297, 454077, 376291, 305901, 300183, 315937, 319705, 454075, 356496, 356494, 454192, 356492, 454189, 454072, 356490, 454069, 451598, 349826, 418365, 328765, 376963, 404218, 295858, 353317, 289049, 453018, 453901, 451595, 409883, 349823, 349821, 296638, 409880, 452546, 453253, 395590, 395588, 452544, 312997, 452649, 403222, 354920, 286287, 368580, 452713, 351035, 300181, 351242, 280770, 407097, 452680, 295701, 295698, 280768, 452579, 452765, 407094, 452577, 452711, 452575, 452571, 452569, 452708, 407092, 290531, 452567, 452647, 452540, 452643, 396715, 279207, 280764, 280762, 452533, 368578, 451061, 290529, 452557, 452531, 280760, 452529, 452555, 451058, 451056, 451054, 451052, 451049, 451047, 319694, 451042, 280757, 290525, 368576, 407089, 403812, 280755, 290523, 452404, 452524, 391456, 368574, 414945, 406852, 452402, 280752, 452382, 280750, 452110, 363925, 449415, 379462, 291144, 419090, 366543, 416191, 420737, 326144, 330972, 340582, 448347, 291142, 422797, 303763, 377476, 283862, 449413, 341023, 338543, 338541, 312657, 339785, 376287, 280749, 319692, 280746, 451965, 345232, 418174, 319690, 395026, 394940, 312995, 338539, 418173, 396258, 451575, 451887, 451884, 451834, 451882, 451879, 451876, 451873))
Run Time: 0.065824
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1549 | |
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 | | | | | 1549 | |
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 (29794, 29793, 29792, 29791, 29790, 29333, 25698, 25092, 24987, 24921, 24193, 23972, 23615, 23497, 23469, 23404, 23400, 22996, 22968, 22930, 22793, 22792, 22493, 22311, 22272, 22267, 22266, 22259, 22183, 22179, 22169, 22137, 22136))
Run Time: 0.002401
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 33 | 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 (569223, 569220, 315151, 315150, 287112, 282601, 308087, 568773, 568772, 568712, 282599, 282597, 282595, 569091, 287110, 300289, 567586, 567585, 546668, 568958, 315147, 284967, 564431, 407063, 407062, 407061, 567556, 351272, 351271, 407059, 407058, 311062, 286565, 300287, 315145, 315144, 569073, 569076, 478127, 478126, 478123, 478119, 478118, 568955, 537833, 478116, 478115, 478114, 478113, 478110, 478108, 478107, 478104, 478103, 478101, 478100, 478096, 276343, 564655, 568819, 568817, 568816, 568815, 568813, 568812, 568810, 568809, 568807, 568806, 568805, 568804, 568791, 282580, 282579, 282578, 568623, 282577, 568621, 568620, 568635, 568618, 568616, 282576, 568615, 282575, 568709, 568613, 478092, 478091, 478090, 478089, 568763, 568762, 568609, 478087, 478086, 568608, 478085, 478084, 568607, 478082, 478081, 478080, 478079, 478078, 478077, 478074, 478073, 478072, 478071, 568707, 478067, 478060, 478059, 282568, 282555, 568600, 568404, 377352, 282529, 282528, 282524, 282523, 282522, 282520, 568086, 568082, 568080, 568078, 568076, 568074, 568073, 568071, 568068, 568067, 568065, 568097, 568063, 568060, 282510, 282499, 282498, 567186, 567185, 282495, 308079, 282488, 282487, 282484, 308076, 308075, 567023, 566164, 566382, 566160, 566159, 566137, 565565, 557868, 565019, 319127, 547093, 507608, 282038, 282033, 282028, 282027, 282025, 281941, 317367, 317365, 406071, 317364, 545140, 469621, 407049, 351270, 308022, 308011, 281706, 281704, 313033, 505645, 503938, 503937, 503936, 503995, 313030, 503991, 503988, 326236, 281027, 281020, 283942, 281014, 286944, 503000, 502123, 283940, 502121, 490858, 502510, 502115, 319290, 481130, 501375, 283938, 501372, 501370, 501368, 501366, 502111, 283937, 501999, 319284, 286427, 290579, 290577, 286425, 501362, 290575, 501360, 319277, 501358, 500168, 300227, 501643, 286937, 501553, 286931, 296862, 501341, 501338, 501296, 492890, 501213, 501210, 492888, 492885, 492883, 492881, 492879, 492876, 491474, 491472, 499731, 499677, 498722, 498944, 496496, 498236, 497990, 497984, 497981, 497979, 497975, 385722, 496121, 278248, 495021, 495146, 495016, 302869, 495207, 495205, 486548, 286926, 494187, 495137, 495135, 495131, 494587, 490527, 486545, 494583, 492976, 465093, 492970, 286924, 490525, 410352, 495009, 335206, 302533, 492692, 302866, 494818, 302531, 286916, 275587, 494573, 301470, 494571, 494256, 492872, 492690, 492870, 410351, 486166, 279327, 279325, 493796, 494084, 494387, 410350, 410347, 494251, 276171, 410345, 493791, 493789, 486163, 493992, 493787, 456707, 276167, 456705, 456703, 492866, 492864, 311016, 311014, 494272, 276164, 494270, 494249, 276161, 494265, 486161, 494263, 494247, 494261, 490808, 335204, 492190, 494241, 490807, 492188, 335202, 286400, 279317, 279315, 335200, 494031, 279312, 494029, 490805, 311012, 311010, 493944, 302855, 493942, 311008, 492702, 494081, 286398, 494095, 494027, 494025, 311006, 351266, 374106, 311000, 360348, 493783, 487170, 493838, 493835, 493833, 474995, 493779, 478873, 351264, 493776, 478871, 410343, 310993, 410341, 310991, 370144, 310989, 410339, 310987, 302851, 490797, 322674, 302530, 310983, 310981, 310978, 300221, 492187, 310976, 310974, 492185, 310972, 492183, 335197, 492181, 492179, 352388, 492176, 490256, 492859, 492688, 492853, 283931, 492741, 493010, 492851, 492849, 492847, 492845, 491657, 492738, 491895, 492843, 484059, 315449, 492736, 315448, 492841, 492801, 283928, 283926, 492839, 492799, 492836, 492834, 491655, 492586, 491887, 374103, 360136, 360134, 492758, 280995, 491885, 280993, 280991, 360131, 374097, 491882, 492683, 492681, 492679, 492677, 492584, 345217, 302836, 491931, 491929, 491857, 491870, 491867, 307959, 484968, 491862, 484965, 484963, 484961, 491617, 484958, 313026, 313024, 280982, 280979, 280965, 395173, 484269, 484266, 315092, 315090, 483550, 473157, 480739, 280955, 288574, 315950, 483534, 290545, 274233, 483558, 483556, 274229, 360968, 468091, 360966, 274227, 483530, 483528, 319721, 483510, 319719, 479972, 479968, 479966, 483182, 307145, 313018, 483142, 483095, 342194, 342192, 342190, 483090, 342183, 467571, 356498, 276154, 342180, 276152, 482662, 461983, 342177, 482767, 280952, 342175, 274033, 482456, 283906, 310938, 316507, 310936, 310934, 461201, 482366, 286363, 481007, 300206, 407255, 316505, 480032, 482357, 482355, 482353, 286360, 286358, 316503, 479623, 479621, 481475, 481325, 301896, 473336, 300204, 482181, 479316, 478235, 480030, 481471, 481955, 481001, 482020, 472438, 279288, 305978, 279286, 279284, 461199, 279282, 279280, 472436, 305975, 305972, 351254, 351252, 351250, 351248, 279273, 480711, 480319, 480364, 480362, 276148, 276146, 460861, 480317, 480349, 291384, 480313, 480311, 480309, 480306, 291382, 480299, 407101, 456699, 480157, 480154, 395155, 276885, 276883, 477081, 473335, 479616, 479613, 479612, 479955, 413954, 479611, 314324, 392027, 286846, 477871, 302812, 302807, 477749, 477740, 280937, 302804, 280935, 302802, 477263, 472359, 477196, 477194, 477037, 476989, 414982, 476987, 476984, 477033, 410402, 476980, 476978, 476590, 451870, 280930, 476521, 476298, 476274, 316643, 316641, 475476, 276139, 276137, 454003, 377348, 301464, 316638, 280928, 475474, 475463, 475459, 286841, 276135, 276874, 280926, 276132, 475456, 310932, 475454, 475452, 310930, 310928, 337337, 472422, 472420, 451869, 280922, 451868, 275323, 459461, 468441, 468438, 475108, 459459, 474624, 337335, 475106, 468436, 474697, 468434, 475007, 310914, 454580, 395148, 475004, 475002, 474957, 474954, 474874, 395146, 451867, 276131, 474948, 279252, 276129, 474667, 474419, 474665, 474612, 279246, 326163, 279244, 454579, 326161, 451897, 461186, 395145, 455213, 276127, 461183, 451865, 474689, 279241, 346113, 474602, 454578, 454576, 313016, 451893, 474415, 474413, 474412, 454574, 313014, 346111, 467560, 346109, 365948, 474411, 451891, 473798, 451889, 451888, 321572, 472400, 473714, 295705, 474409, 330990, 473795, 474407, 335194, 361772, 293651, 330987, 465197, 451864, 293649, 465195, 395143, 352301, 335192, 294335, 294333, 293647, 305966, 465185, 473334, 280921, 467834, 458016, 330983, 346107, 473789, 473787, 462636, 473785, 468431, 468429, 473304, 473299, 470419, 420745, 471742, 472942, 473295, 473149, 473264, 451863, 459484, 472936, 472663, 451861, 356679, 472659, 473030, 472399, 305965, 280920, 473259, 472934, 473148, 473147, 472927, 473140, 286831, 286828, 413520, 280918, 472353, 280916, 280914, 472351, 472348, 291783, 280912, 291781, 291779, 291777, 313012, 472413, 395138, 472411, 472339, 466351, 315443, 315442, 315439, 280910, 352297, 456192, 360632, 451860, 280908, 412683, 459453, 352295, 315438, 315436, 315434, 334093, 462629, 471696, 315432, 471773, 471646, 470443, 416329, 392023, 456189, 416327, 470441, 395136, 471693, 468614, 470210, 469662, 470438, 280907, 470436, 315429, 471767, 315427, 316482, 471756, 416325, 471741, 471691, 471754, 416323, 416319, 315424, 470947, 471569, 276117, 280905, 286816, 276114, 280899, 462169, 276112, 317337, 280897, 286813, 469609, 286811, 395130, 470984, 315421, 471432, 470936, 471430, 418106, 470764, 470762, 470705, 470702, 470699, 280893, 470758, 470756, 280891, 280889, 459447, 469658, 469656, 417045, 467301, 469459, 459443, 469647, 395119, 315417, 467299, 467297, 417042, 376776, 280886, 470048, 376774, 376772, 280884, 467293, 469698, 422942, 469593, 307094, 469638, 469633, 469631, 469583, 469582, 469521, 376767, 469519, 385094, 469450, 469444, 469447, 452814, 463243, 351246, 307092, 422933, 280881, 291769, 467276, 280877, 280875, 395114, 422919, 422917, 422915, 294319, 280873, 422913, 469073, 422911, 422908, 280871, 395112, 291767, 334087, 291765, 286332, 300194, 468610, 467618, 467616, 468748, 468742, 462826, 413947, 467271, 412936, 467269, 412934, 351244, 395109, 467266, 467265, 468604, 391473, 468089, 396718, 468081, 305956, 305954, 305952, 412682, 468336, 460860, 395106, 392019, 392017, 392009, 459028, 468078, 395100, 280868, 395098, 395096, 395093, 468076, 395086, 451858, 395085, 313004, 296840, 395082, 280865, 454000, 395079, 395078, 467007, 307090, 410907, 306987, 300446, 306983, 306981, 466333, 306979, 306973, 300444, 400475, 326150, 466261, 306963, 466258, 304793, 300442, 291763, 346104, 398218, 395074, 346102, 280863, 280862, 354956, 465609, 392001, 391999, 462034, 346098, 420741, 413912, 465598, 279227, 464955, 413907, 465351, 465349, 465347, 465343, 465329, 465260, 394965, 394963, 394961, 463207, 385719, 385717, 464762, 394953, 463235, 293132, 395064, 464271, 463205, 458425, 456469, 464269, 464267, 293130, 291378, 461062, 461431, 460548, 461625, 461101, 462343, 464208, 462160, 463233, 326028, 464265, 403281, 451857, 462219, 463339, 460652, 463927, 464447, 464263, 464677, 464444, 461783, 291376, 462029, 462027, 395062, 463941, 313001, 455212, 275250, 458577, 275248, 463925, 463933, 395059, 307086, 459047, 315413, 346086, 463225, 283888, 463354, 319097, 459045, 463222, 315075, 463146, 463202, 463100, 461403, 463095, 461400, 280849, 391511, 455203, 451855, 462781, 398217, 292210, 365946, 342965, 461168, 459523, 336837, 365943, 462211, 336835, 461166, 336832, 365941, 462478, 336829, 374054, 300436, 300433, 395056, 461780, 335189, 300431, 458606, 461154, 461152, 300429, 461778, 461094, 414966, 461776, 461303, 459390, 461092, 461090, 461088, 300427, 461616, 461150, 461086, 461145, 300425, 300423, 461141, 313190, 395051, 315412, 459376, 280839, 374040, 461071, 461069, 461067, 461065, 335186, 404230, 280837, 459365, 337647, 460633, 321571, 460083, 395049, 397504, 335183, 460092, 407243, 352271, 278803, 460090, 460545, 451972, 411172, 460733, 315411, 451665, 453905, 407036, 405320, 376294, 280833, 453902, 452991, 460402, 460492, 395047, 460488, 458419, 460481, 411164, 310897, 458600, 458328, 459058, 459261, 460131, 460020, 460081, 279216, 279214, 279211, 460276, 460143, 300421, 395044, 460141, 458991, 300419, 458956, 274226, 459794, 459790, 293097, 459352, 452360, 458985, 458982, 458414, 458409, 330981, 330979, 330977, 458006, 458038, 458031, 280814, 280810, 280808, 456932, 457115, 457001, 451853, 452783, 452780, 456185, 456963, 451852, 456816, 456814, 451850, 456322, 456812, 456810, 451849, 451602, 456458, 451847, 451845, 280799, 456686, 280797, 419097, 456177, 414954, 280793, 280791, 280789, 280786, 456386, 456384, 419095, 419093, 449364, 456500, 319713, 319711, 456451, 422798, 280784, 423498, 310878, 328775, 456381, 456175, 328773, 416197, 328771, 451843, 456173, 416193, 456170, 456318, 455200, 455198, 335174, 456168, 423496, 286786, 456166, 454389, 452410, 407100, 360441, 454568, 455196, 455194, 407234, 280782, 280780, 280778, 280776, 296834, 319707, 407232, 423494, 453998, 286321, 296831, 451842, 451840, 451838, 394950, 454562, 451836, 330975, 394948, 452112, 454560, 360437, 455638, 449362, 394944, 449401, 394942, 453997, 423492, 455191, 449399, 452408, 286318, 292225, 451835, 286315, 406667, 406665, 423490, 286313, 286309, 286307, 286304, 422013, 420117, 454555, 286302, 454553, 453027, 409904, 452406, 454650, 423488, 454931, 279208, 454792, 286299, 454648, 454366, 454643, 454287, 454641, 454285, 404222, 404220, 454282, 449397, 449395, 449393, 454547, 449391, 300186, 286290, 449389, 420116, 449387, 420114, 280775, 304307, 354929, 354927, 354925, 354923, 315297, 454077, 376291, 305901, 300183, 315937, 319705, 454075, 356496, 356494, 454192, 356492, 454189, 454072, 356490, 454069, 451598, 349826, 418365, 328765, 376963, 404218, 295858, 353317, 289049, 453018, 453901, 451595, 409883, 349823, 349821, 296638, 409880, 452546, 453253, 395590, 395588, 452544, 312997, 452649, 403222, 354920, 286287, 368580, 452713, 351035, 300181, 351242, 280770, 407097, 452680, 295701, 295698, 280768, 452579, 452765, 407094, 452577, 452711, 452575, 452571, 452569, 452708, 407092, 290531, 452567, 452647, 452540, 452643, 396715, 279207, 280764, 280762, 452533, 368578, 451061, 290529, 452557, 452531, 280760, 452529, 452555, 451058, 451056, 451054, 451052, 451049, 451047, 319694, 451042, 280757, 290525, 368576, 407089, 403812, 280755, 290523, 452404, 452524, 391456, 368574, 414945, 406852, 452402, 280752, 452382, 280750, 452110, 363925, 449415, 379462, 291144, 419090, 366543, 416191, 420737, 326144, 330972, 340582, 448347, 291142, 422797, 303763, 377476, 283862, 449413, 341023, 338543, 338541, 312657, 339785, 376287, 280749, 319692, 280746, 451965, 345232, 418174, 319690, 395026, 394940, 312995, 338539, 418173, 396258, 451575, 451887, 451884, 451834, 451882, 451879, 451876, 451873))
Run Time: 0.041126
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1549 | |
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 | | | | | 1549 | |
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 (29794, 29793, 29792, 29791, 29790, 29333, 25698, 25092, 24987, 24921, 24193, 23972, 23615, 23497, 23469, 23404, 23400, 22996, 22968, 22930, 22793, 22792, 22493, 22311, 22272, 22267, 22266, 22259, 22183, 22179, 22169, 22137, 22136))
Run Time: 0.001476
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 33 | 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, �I�
Run Time: 0.000173
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: �I�, XF\Pub\Controller\Member, RecentContent, valid, user_id=5615, 1717262561, , 0, �I�
Run Time: 0.000134
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000331
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.000472
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: 1717262261
Run Time: 0.000372
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 14 | 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` >= 1717262261)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000428
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 14 | 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