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.000572
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.000144
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` = '2300')
LIMIT 1
Run Time: 0.000433
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.002309
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_2300' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.055093
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 (478124, 478120, 568852, 568737, 568735, 568928, 568849, 568847, 568732, 568844, 565612, 568729, 568727, 568634, 568725, 568633, 568629, 568139, 568137, 568133, 568130, 568128, 568126, 568124, 568121, 568119, 565137, 565135, 568115, 568111, 565609, 566449, 566635, 566440, 565498, 565600, 566438, 566446, 566434, 499148, 566432, 490722, 540556, 566339, 566331, 566054, 566280, 565596, 565586, 566043, 566040, 565576, 561860, 566132, 565574, 566109, 565692, 565572, 565564, 423048, 565562, 565559, 565616, 565556, 561857, 423042, 561853, 561851, 550761, 423039, 565299, 565176, 565277, 564888, 551171, 551168, 483837, 551162, 551159, 490719, 423037, 423035, 490231, 564340, 564268, 564226, 490717, 564139, 562684, 562678, 562530, 562642, 561545, 555291, 562286, 562284, 562175, 562161, 562172, 561647, 326326, 498651, 326324, 561645, 561997, 561643, 498646, 561641, 560542, 561535, 561550, 561540, 490712, 282282, 276996, 284136, 284132, 284130, 381993, 559608, 559120, 284121, 284119, 284116, 284112, 559001, 558902, 284110, 558898, 558841, 509369, 509367, 558046, 545369, 545366, 545364, 557739, 557734, 490227, 498639, 527183, 555825, 555822, 521145, 521143, 282097, 284107, 550708, 550705, 521142, 555338, 545331, 550702, 555336, 550700, 492402, 555432, 555425, 555423, 492400, 550698, 550694, 497848, 462851, 462849, 462847, 552795, 552624, 552623, 552621, 552607, 523735, 523733, 523731, 552580, 551642, 552591, 523728, 523726, 504436, 552433, 504434, 546442, 504432, 504430, 282063, 282061, 459493, 552004, 551741, 552000, 552137, 551997, 552133, 480226, 381989, 517077, 517075, 541806, 541803, 545029, 551737, 551736, 551733, 543409, 480223, 551507, 381985, 284098, 462226, 551347, 462224, 312660, 550514, 550357, 545027, 551072, 551013, 551070, 551069, 551067, 550930, 551065, 550928, 502061, 550430, 551007, 284095, 545020, 550427, 545018, 511360, 550684, 550682, 284093, 306993, 550578, 550576, 550572, 550570, 284092, 506605, 550384, 550568, 282017, 550372, 284088, 550364, 550140, 550361, 550138, 381983, 509356, 546435, 546433, 548672, 548737, 474220, 546430, 548543, 516888, 546428, 544527, 490682, 547850, 547521, 498630, 490679, 536864, 281953, 281951, 281948, 281946, 509353, 518590, 490675, 546422, 490672, 546424, 283213, 546017, 545814, 316594, 480222, 546101, 545137, 545012, 545135, 480220, 545008, 480218, 545000, 469612, 499137, 480217, 543741, 543799, 543668, 490667, 480208, 480206, 541236, 490657, 539137, 539136, 490649, 480200, 490636, 490634, 480197, 480194, 536720, 536716, 535096, 535659, 535092, 535089, 284065, 535070, 535185, 490505, 283198, 286125, 491556, 291176, 281553, 523347, 521855, 521851, 521848, 521844, 521830, 521822, 521814, 520976, 518578, 408183, 520253, 518576, 518640, 289638, 518574, 518570, 518568, 422372, 422369, 422367, 517588, 451978, 512628, 512627, 512620, 512446, 512163, 281047, 509743, 500591, 483755, 506602, 508060, 508864, 508106, 498571, 507363, 498561, 506082, 505464, 504533, 504857, 503030, 503028, 500561, 503024, 503022, 475594, 475591, 498550, 498759, 496289, 495220, 495690, 495156, 352399, 465097, 495213, 319730, 495209, 495211, 465094, 283934, 492873, 493242, 492871, 276168, 493707, 493012, 491653, 280996, 492415, 492350, 491648, 484057, 492635, 490498, 293672, 492165, 293667, 491631, 352377, 491629, 491627, 289553, 491549, 490557, 490548, 280986, 490555, 490494, 490492, 490490, 289119, 490517, 283918, 490406, 283915, 273024, 296854, 490513, 490299, 490488, 490483, 490400, 275573, 285182, 293329, 283913, 302826, 352346, 289110, 487804, 489172, 304321, 489439, 487160, 488264, 289107, 293325, 487649, 285161, 475121, 487599, 375545, 287872, 287870, 487067, 481454, 454986, 487152, 486527, 486365, 486518, 486516, 486711, 484934, 484931, 486267, 337344, 484705, 484703, 337342, 484874, 484055, 484053, 484261, 483162, 484014, 478586, 276893, 482772, 356725, 329724, 480740, 483565, 298568, 483193, 482858, 481017, 481015, 481011, 283170, 481009, 482451, 412692, 283907, 283905, 481833, 413958, 480989, 480192, 480190, 480513, 278665, 480292, 352332, 352326, 480188, 276147, 315300, 480284, 480185, 480183, 480143, 479759, 479319, 479896, 479614, 478217, 302811, 476296, 476294, 384430, 384428, 384426, 476293, 475475, 276140, 276138, 276136, 276133, 310922, 361773, 472832, 286822, 472623, 280917, 280915, 280909, 337660, 416318, 456422, 352293, 471568, 352290, 313006, 469610, 469608, 470704, 470701, 459449, 470698, 470709, 469601, 467832, 381981, 280882, 280880, 422932, 306991, 467689, 467687, 467012, 344403, 467010, 466876, 466871, 345699, 345696, 345693, 345690, 306971, 466327, 306957, 306954, 465269, 464939, 394964, 394960, 462787, 291377, 288561, 462028, 283890, 463102, 319362, 342962, 462208, 461099, 283882, 462206, 461439, 276086, 335187, 337648, 374037, 460750, 460598, 410815, 460628, 460596, 460706, 460731, 451969, 460498, 313188, 283870, 410813, 458565, 410810, 410807, 346074, 407034, 459022, 360463, 459017, 280823, 459015, 275851, 458949, 283868, 458821, 458816, 458809, 330982, 458035, 458030, 329661, 457466, 310893, 310891, 457461, 457458, 457525, 457508, 457503, 295702, 457238, 457037, 456964, 456952, 322668, 289820, 456691, 415664, 456214, 450689, 456457, 415661, 335180, 335178, 415658, 456420, 280794, 280792, 280787, 280785, 456385, 456501, 456452, 456383, 449365, 456210, 422799, 455543, 454565, 407233, 452113, 451839, 454563, 451837, 394949, 406666, 417340, 454286, 319702, 453024, 453022, 280772, 453013, 352254, 283864, 452100, 452674, 452668, 316865, 283584, 283581, 383178, 383174, 383160, 403275, 419975, 383158, 417617, 418328, 315935, 418571, 416190, 416188, 411371, 411359, 410195, 401435, 401433, 401430, 401426, 396713, 396711, 395567, 462810, 395559, 394681, 304779, 345616, 345614, 307937, 272834, 280626, 274745, 274743, 315933, 272826, 272807, 272800, 290460, 341526, 276010, 385028, 273302, 385022, 385017, 385002, 272766, 280619, 382800, 276732, 385352, 385000, 384997, 384414, 275705, 316368, 316366, 383138, 272758, 272756, 316364, 276004, 316359, 276000, 384602, 275997, 316356, 274356, 316354, 291083, 274354, 316352, 274349, 316350, 384445, 384261, 382518, 382516, 291075, 352135, 280595, 280591, 280589, 274344, 286235, 356646, 272750, 280584, 337326, 298460, 298454, 345593, 298449, 322657, 322655, 352124, 382075, 352121, 274341, 352119, 352117, 382303, 319093, 382069, 278482, 352115, 300165, 376750, 307930, 370810, 381477, 280571, 381349, 272745, 280566, 280565, 370036, 379535, 280557, 379533, 379531, 312976, 322652, 280554, 280551, 378941, 280547, 280545, 280544, 377335, 377332, 283408, 326114, 326112, 319083, 319081, 305780, 272737, 272732, 272730, 280529, 272729, 272727, 305778, 376954, 272725, 377323, 305062, 272721, 280526, 340767, 272716, 285331, 326109, 376273, 376271, 375523, 307928, 374872, 317282, 272704, 305773, 373170, 373167, 373165, 373163, 312964, 319071, 280508, 319069, 319065, 280506, 305770, 372845, 371309, 280505, 272698, 305768, 272693, 292235, 371301, 280495, 275787, 272691, 312961, 305766, 280491, 286701, 305763, 280489, 312958, 370134, 305761, 312955, 369833, 315928, 286228, 272685, 315926, 315914, 315912, 286226, 284685, 321496, 365926, 365924, 275498, 272682, 326103, 291754, 291752, 366526, 364854, 364851, 364847, 313160, 280469, 280463, 296603, 342826, 335144, 280459, 280457, 280455, 280454, 296600, 307920, 296591, 296589, 360996, 296581, 360993, 335141, 360986, 298354, 298352, 341515, 360345, 360342, 296579, 322645, 300141, 360095, 360093, 359161, 359159, 360089, 300136, 292611, 302698, 302695, 302693, 312938, 302691, 312936, 357908, 274287, 274285, 358814, 274283, 274281, 302689, 312935, 357905, 351031, 272651, 357895, 357891, 351028, 357884, 351026, 357877, 357874, 357872, 356488, 356486, 341513, 275704, 272643, 280445, 272639, 354876, 343681, 272632, 272630, 337320, 352571, 352093, 352564, 351797, 351791, 326097, 276645, 351011, 302686, 272611, 280432, 312928, 312926, 280430, 312924, 326094, 326092, 326091, 326089, 278240, 326086, 292934, 351009, 272609, 351007, 351004, 350994, 312922, 326082, 326079, 295695, 312656, 295691, 349679, 347501, 280425, 343845, 278237, 343842, 296565, 300599, 344623, 344620, 344617, 342876, 344371, 272573, 280419, 296815, 343818, 284676, 344094, 329630, 329628, 308281, 280403, 343814, 329621, 308273, 343654, 308271, 343652, 342868, 280394, 337316, 337314, 317264, 314487, 342810, 342856, 317261, 342808, 317258, 342164, 342162, 317254, 272552, 285089, 298447, 290213, 336524, 342160, 342157, 339752, 342154, 339750, 272540, 337312, 298444, 280383, 315902, 280381, 280380, 280376, 315899, 308252, 340613, 340606, 280372, 337310, 280370, 280368, 321395, 280364, 280362, 307911, 339943, 275989, 275987, 312653, 339433, 280357, 291741, 291739, 291737, 291735, 291733, 291730, 280332, 280327, 330953, 278233, 330951, 336685, 337303, 336681, 280320, 336812, 336887, 336810, 336805, 336803, 273288, 331110, 273284, 280316, 280313, 296785, 296781, 295675, 274962, 273055, 273053, 335898, 335896, 315036, 272489, 274956, 280310, 335260, 285598, 272478, 335031, 335139, 295827, 272473, 335027, 295823, 272471, 295666, 295661, 307898, 330949, 333054, 330947, 333052, 307896, 280304, 280300, 330942, 330937, 319167, 280291, 280289, 330935, 330931, 278781, 275962, 275960, 285086, 305797, 328170, 307892, 285084, 285082, 323655, 325972, 327745, 275957, 272447, 296555, 283801, 285079, 280274, 322635, 280272, 304245, 296545, 317216, 296541, 296539, 296537, 280261, 280256, 283797, 321390, 321474, 307887, 274932, 321289, 272427, 274930, 296527, 319659, 280236, 301543, 301541, 319657, 280234, 312650, 275954, 315541, 272417, 301537, 301535, 316236, 301531, 316234, 301529, 319052, 307885, 292594, 314822, 317633, 318095, 307884, 312648, 319046, 313122, 318827, 312645, 318824, 318713, 318118, 318116, 318114, 317614, 315273, 302669, 307876, 315270, 317612, 318130, 312644, 272401, 315892, 318100, 317638, 312640, 316863, 280213, 316821, 314285, 307872, 314283, 295369, 314820, 316861, 316847, 316859, 312638, 316845, 316834, 314818, 314816, 316818, 316815, 316781, 316637, 316227, 280209, 312636, 316202, 312635, 316200, 316198, 316196, 274013, 274011, 274009, 315259, 272382, 280206, 315327, 315888, 272378, 280203, 312634, 315006, 314336, 312632, 306537, 272368, 306532, 314343, 306530, 313938, 312631, 307865, 304236, 304234, 280200, 286655, 278772, 304764, 314340, 312630, 314338, 286653, 314331, 295650, 272365, 312628, 312627, 304229, 314136, 304227, 313110, 304224, 304222, 304219, 273530, 313108, 312625, 313258, 272362, 313254, 304215, 313106, 304203, 304201, 312074, 313246, 272357, 272353, 275689, 272351, 284906, 313243, 275685, 272349, 312620, 272347, 275680, 272342, 312896, 272338, 275677, 312890, 312615, 312612, 312610, 299393, 312606, 312603, 299391, 312600, 284903, 280194, 308226, 308223, 300036, 307858, 307856, 280182, 280174, 280172, 275944, 275942, 280170, 272333, 280168, 280165, 284826, 282950, 284901, 280163, 272328, 288450, 280161, 280159, 280156, 272324, 280153, 272321, 274802, 280152, 274799, 272319, 307849, 272317, 280149, 272315, 305916, 278371, 288446, 272313, 18302, 288443, 311876, 280146, 308112, 272311, 457844, 274004, 310868, 310863, 280144, 300032, 311289, 272305, 280133, 308106, 284895, 305899, 300027, 300025, 275940, 300023, 272301, 300021, 272296, 272294, 310610, 305897, 310390, 310386, 291059, 310384, 280130, 291056, 305896, 308216, 291054, 291050, 308213, 280128, 280126, 308095, 296757, 307749, 296754, 307747, 307055, 305310, 307265, 307259, 304449, 306945, 306936, 306934, 272288, 306928, 306923, 304062, 306921, 304552, 272280, 272278, 305913, 306203, 302665, 302663, 288882, 302661, 304501, 305023, 304499, 304441, 301876, 288425, 272249, 300576, 288419, 300574, 280117, 301526, 301524, 275722, 301463, 280110, 280108, 280105, 275936, 280103, 300573, 275933, 272247, 275930, 300572, 275928, 275925, 275923, 288413, 272243, 280101, 288411, 292231, 272239, 280099, 280097, 295634, 300320, 272236, 288407, 299848, 294644, 294642, 294640, 280091, 280088, 278361, 292258, 278359, 280084, 296509, 272232, 298726, 298347, 291022, 274908, 280083, 296735, 285592, 298724, 298721, 298430, 296467, 296501, 280079, 296726, 296334, 282942, 298339, 272225, 296497, 282940, 298336, 296464, 292243, 295819, 295817, 296314, 295632, 296121, 292575, 292573, 295815, 295628, 296116, 295626, 292561, 295585, 293716, 293713, 293711, 293708, 293706, 293704, 276640, 293702, 295360, 293699, 293697, 295358, 293694, 295356, 276637, 276634, 295391, 292240, 272216, 295353, 280076, 295348, 295387, 295344, 292527, 295151, 295145, 284229, 294893, 294637, 294498, 294635, 290438, 294633, 290698, 292229, 293782, 293779, 293577, 288052, 293575, 288050, 293573, 288047, 288320, 292519, 292207, 280071, 274906, 274902, 291913, 273985, 291910, 278355, 291907, 280070, 282932, 286620, 284411, 284667, 284409, 275675, 292194, 292203, 292217, 273983, 284406, 291047, 273977, 273976, 273973, 273971, 286609, 273968, 273965, 273963, 273961, 291000, 273958, 273955, 273949, 286602, 290728, 273947, 273941, 273938, 290619, 285076, 290617, 285074, 272210, 273935, 285290, 275714, 289338, 286168, 275711, 289332, 289803, 289797, 288841, 283795, 288736, 283793, 289328, 286166, 289323, 36556, 269564, 280067, 280063, 280062, 272206, 283790, 276618, 272202, 287840, 276615, 273932, 283154, 280046, 272194, 287260, 283785, 285963, 285959, 286594, 287164, 280040, 276607, 284884, 275913, 285626, 284880, 285261, 272189, 285063, 272186, 272180, 272177, 272175, 275910, 272170, 280021, 272167, 272165, 275907, 276504, 275902, 275900, 276501, 282929, 275898, 280017, 272158, 272156, 280015, 272154, 283150, 283779, 272150, 283146, 283145, 280012, 283773, 284388, 283770, 283768, 283141, 282924, 279711, 282919, 275890, 275887, 275885, 272141, 275883, 274738, 279700, 279872, 278230, 272134, 273016, 273926, 276494, 276557, 276492, 276490, 276485, 276376, 276373, 273921, 275759, 273919, 275436, 274675, 273912, 274828, 275434, 274826, 273158, 274129, 273997, 273908, 273902, 273136, 273134, 272126, 273013, 273130, 272119, 272115, 273011, 273128, 273031, 272971, 272106, 269470, 194889, 247375, 191970, 186100, 168216, 189629, 185814, 185806, 186017, 186031, 185936, 184877, 184032, 184945, 184333, 184722, 184873, 184785, 175487, 174834, 172627, 175483, 18254, 173081, 172552, 172991, 141526, 155213, 172727, 171908, 172618, 172616, 160093, 163250, 171453, 171353, 171266, 170799, 18243, 18238, 164249, 170298, 165304, 169367, 170190, 167748, 169832, 145296, 167744, 167742, 167740, 167737, 167735, 169570, 167973, 167969, 167732, 168901, 162188, 168962, 167377, 169115, 155195, 168173, 167883, 8027, 168939, 167879, 168689, 168295, 167976, 167877, 167305, 167726, 167724, 116133, 142773, 142771, 142769, 167632, 167365, 166759, 123403, 164744, 166904, 166901, 166619, 159698, 166614, 166142, 159695, 166333, 166327, 165484, 159685, 165258, 166132, 165959, 165954, 150419, 165873, 165702, 165457, 164997, 120499, 120497, 120490, 159407, 164646, 163703, 164241, 163695, 163686, 163676, 163292, 163277, 163274, 159394, 162958, 159392, 163232, 162729, 161539, 162718, 162649, 162406, 18225, 162100, 162097, 152170, 157476, 155685, 158494, 157360, 158041, 157354, 157350, 157663, 158029, 157658, 154508, 156785, 157802, 157348, 157650, 157461, 157519, 134726, 157458, 157112, 157071, 117359, 117355, 154307, 154305, 154303, 155724, 150887, 153778, 154297, 154293, 150878, 150875, 141330, 154290, 150417, 154288, 153995, 134716, 153537, 59165, 147994, 36793, 129984, 129981, 117240, 59158, 117236, 117231, 123921, 123208, 123969, 101, 122689, 121518, 122686, 121515, 121507, 121834, 121493, 121150, 93295, 117171, 114329, 118810, 111521, 118703, 111222, 118558))
Run Time: 0.055988
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1951 | |
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 | | | | | 1951 | |
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 (29767, 29766, 29765, 29746, 29745, 29744, 29729, 29714, 29699, 29634, 29455, 29442, 29390, 28476, 28473, 28395, 28357, 28310, 28224, 27048, 26919, 26287, 25998, 25141, 25281, 25282, 25283, 25284, 25285, 25286, 25287, 25288, 25289, 25290, 25291, 25292, 25293, 24908, 24734, 24683, 24611, 24482, 24350, 24257, 23887, 23470, 23467, 23459, 23457, 23456, 23455, 23450, 23329, 22140, 20455, 20454, 20308, 19512, 19366, 19251, 19250, 19172, 19145, 17961, 17935, 17090, 16591, 16313, 16199, 15802, 15757, 15725, 15713, 15676, 15626, 15562, 15536, 15371, 15163, 15039, 14975, 14871, 14858, 14852, 14749, 14691, 14661, 14660, 14628, 14585, 14571, 14234, 14196, 14082, 14081, 14569, 14570, 14572, 14016, 13976, 13857, 11612, 11438, 11410, 11252, 11150, 11147, 11084, 11034, 10934, 10912, 10837, 10701, 10666, 10538, 10495, 10484, 8947, 8861, 8824))
Run Time: 0.005591
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 120 | 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 (478124, 478120, 568852, 568737, 568735, 568928, 568849, 568847, 568732, 568844, 565612, 568729, 568727, 568634, 568725, 568633, 568629, 568139, 568137, 568133, 568130, 568128, 568126, 568124, 568121, 568119, 565137, 565135, 568115, 568111, 565609, 566449, 566635, 566440, 565498, 565600, 566438, 566446, 566434, 499148, 566432, 490722, 540556, 566339, 566331, 566054, 566280, 565596, 565586, 566043, 566040, 565576, 561860, 566132, 565574, 566109, 565692, 565572, 565564, 423048, 565562, 565559, 565616, 565556, 561857, 423042, 561853, 561851, 550761, 423039, 565299, 565176, 565277, 564888, 551171, 551168, 483837, 551162, 551159, 490719, 423037, 423035, 490231, 564340, 564268, 564226, 490717, 564139, 562684, 562678, 562530, 562642, 561545, 555291, 562286, 562284, 562175, 562161, 562172, 561647, 326326, 498651, 326324, 561645, 561997, 561643, 498646, 561641, 560542, 561535, 561550, 561540, 490712, 282282, 276996, 284136, 284132, 284130, 381993, 559608, 559120, 284121, 284119, 284116, 284112, 559001, 558902, 284110, 558898, 558841, 509369, 509367, 558046, 545369, 545366, 545364, 557739, 557734, 490227, 498639, 527183, 555825, 555822, 521145, 521143, 282097, 284107, 550708, 550705, 521142, 555338, 545331, 550702, 555336, 550700, 492402, 555432, 555425, 555423, 492400, 550698, 550694, 497848, 462851, 462849, 462847, 552795, 552624, 552623, 552621, 552607, 523735, 523733, 523731, 552580, 551642, 552591, 523728, 523726, 504436, 552433, 504434, 546442, 504432, 504430, 282063, 282061, 459493, 552004, 551741, 552000, 552137, 551997, 552133, 480226, 381989, 517077, 517075, 541806, 541803, 545029, 551737, 551736, 551733, 543409, 480223, 551507, 381985, 284098, 462226, 551347, 462224, 312660, 550514, 550357, 545027, 551072, 551013, 551070, 551069, 551067, 550930, 551065, 550928, 502061, 550430, 551007, 284095, 545020, 550427, 545018, 511360, 550684, 550682, 284093, 306993, 550578, 550576, 550572, 550570, 284092, 506605, 550384, 550568, 282017, 550372, 284088, 550364, 550140, 550361, 550138, 381983, 509356, 546435, 546433, 548672, 548737, 474220, 546430, 548543, 516888, 546428, 544527, 490682, 547850, 547521, 498630, 490679, 536864, 281953, 281951, 281948, 281946, 509353, 518590, 490675, 546422, 490672, 546424, 283213, 546017, 545814, 316594, 480222, 546101, 545137, 545012, 545135, 480220, 545008, 480218, 545000, 469612, 499137, 480217, 543741, 543799, 543668, 490667, 480208, 480206, 541236, 490657, 539137, 539136, 490649, 480200, 490636, 490634, 480197, 480194, 536720, 536716, 535096, 535659, 535092, 535089, 284065, 535070, 535185, 490505, 283198, 286125, 491556, 291176, 281553, 523347, 521855, 521851, 521848, 521844, 521830, 521822, 521814, 520976, 518578, 408183, 520253, 518576, 518640, 289638, 518574, 518570, 518568, 422372, 422369, 422367, 517588, 451978, 512628, 512627, 512620, 512446, 512163, 281047, 509743, 500591, 483755, 506602, 508060, 508864, 508106, 498571, 507363, 498561, 506082, 505464, 504533, 504857, 503030, 503028, 500561, 503024, 503022, 475594, 475591, 498550, 498759, 496289, 495220, 495690, 495156, 352399, 465097, 495213, 319730, 495209, 495211, 465094, 283934, 492873, 493242, 492871, 276168, 493707, 493012, 491653, 280996, 492415, 492350, 491648, 484057, 492635, 490498, 293672, 492165, 293667, 491631, 352377, 491629, 491627, 289553, 491549, 490557, 490548, 280986, 490555, 490494, 490492, 490490, 289119, 490517, 283918, 490406, 283915, 273024, 296854, 490513, 490299, 490488, 490483, 490400, 275573, 285182, 293329, 283913, 302826, 352346, 289110, 487804, 489172, 304321, 489439, 487160, 488264, 289107, 293325, 487649, 285161, 475121, 487599, 375545, 287872, 287870, 487067, 481454, 454986, 487152, 486527, 486365, 486518, 486516, 486711, 484934, 484931, 486267, 337344, 484705, 484703, 337342, 484874, 484055, 484053, 484261, 483162, 484014, 478586, 276893, 482772, 356725, 329724, 480740, 483565, 298568, 483193, 482858, 481017, 481015, 481011, 283170, 481009, 482451, 412692, 283907, 283905, 481833, 413958, 480989, 480192, 480190, 480513, 278665, 480292, 352332, 352326, 480188, 276147, 315300, 480284, 480185, 480183, 480143, 479759, 479319, 479896, 479614, 478217, 302811, 476296, 476294, 384430, 384428, 384426, 476293, 475475, 276140, 276138, 276136, 276133, 310922, 361773, 472832, 286822, 472623, 280917, 280915, 280909, 337660, 416318, 456422, 352293, 471568, 352290, 313006, 469610, 469608, 470704, 470701, 459449, 470698, 470709, 469601, 467832, 381981, 280882, 280880, 422932, 306991, 467689, 467687, 467012, 344403, 467010, 466876, 466871, 345699, 345696, 345693, 345690, 306971, 466327, 306957, 306954, 465269, 464939, 394964, 394960, 462787, 291377, 288561, 462028, 283890, 463102, 319362, 342962, 462208, 461099, 283882, 462206, 461439, 276086, 335187, 337648, 374037, 460750, 460598, 410815, 460628, 460596, 460706, 460731, 451969, 460498, 313188, 283870, 410813, 458565, 410810, 410807, 346074, 407034, 459022, 360463, 459017, 280823, 459015, 275851, 458949, 283868, 458821, 458816, 458809, 330982, 458035, 458030, 329661, 457466, 310893, 310891, 457461, 457458, 457525, 457508, 457503, 295702, 457238, 457037, 456964, 456952, 322668, 289820, 456691, 415664, 456214, 450689, 456457, 415661, 335180, 335178, 415658, 456420, 280794, 280792, 280787, 280785, 456385, 456501, 456452, 456383, 449365, 456210, 422799, 455543, 454565, 407233, 452113, 451839, 454563, 451837, 394949, 406666, 417340, 454286, 319702, 453024, 453022, 280772, 453013, 352254, 283864, 452100, 452674, 452668, 316865, 283584, 283581, 383178, 383174, 383160, 403275, 419975, 383158, 417617, 418328, 315935, 418571, 416190, 416188, 411371, 411359, 410195, 401435, 401433, 401430, 401426, 396713, 396711, 395567, 462810, 395559, 394681, 304779, 345616, 345614, 307937, 272834, 280626, 274745, 274743, 315933, 272826, 272807, 272800, 290460, 341526, 276010, 385028, 273302, 385022, 385017, 385002, 272766, 280619, 382800, 276732, 385352, 385000, 384997, 384414, 275705, 316368, 316366, 383138, 272758, 272756, 316364, 276004, 316359, 276000, 384602, 275997, 316356, 274356, 316354, 291083, 274354, 316352, 274349, 316350, 384445, 384261, 382518, 382516, 291075, 352135, 280595, 280591, 280589, 274344, 286235, 356646, 272750, 280584, 337326, 298460, 298454, 345593, 298449, 322657, 322655, 352124, 382075, 352121, 274341, 352119, 352117, 382303, 319093, 382069, 278482, 352115, 300165, 376750, 307930, 370810, 381477, 280571, 381349, 272745, 280566, 280565, 370036, 379535, 280557, 379533, 379531, 312976, 322652, 280554, 280551, 378941, 280547, 280545, 280544, 377335, 377332, 283408, 326114, 326112, 319083, 319081, 305780, 272737, 272732, 272730, 280529, 272729, 272727, 305778, 376954, 272725, 377323, 305062, 272721, 280526, 340767, 272716, 285331, 326109, 376273, 376271, 375523, 307928, 374872, 317282, 272704, 305773, 373170, 373167, 373165, 373163, 312964, 319071, 280508, 319069, 319065, 280506, 305770, 372845, 371309, 280505, 272698, 305768, 272693, 292235, 371301, 280495, 275787, 272691, 312961, 305766, 280491, 286701, 305763, 280489, 312958, 370134, 305761, 312955, 369833, 315928, 286228, 272685, 315926, 315914, 315912, 286226, 284685, 321496, 365926, 365924, 275498, 272682, 326103, 291754, 291752, 366526, 364854, 364851, 364847, 313160, 280469, 280463, 296603, 342826, 335144, 280459, 280457, 280455, 280454, 296600, 307920, 296591, 296589, 360996, 296581, 360993, 335141, 360986, 298354, 298352, 341515, 360345, 360342, 296579, 322645, 300141, 360095, 360093, 359161, 359159, 360089, 300136, 292611, 302698, 302695, 302693, 312938, 302691, 312936, 357908, 274287, 274285, 358814, 274283, 274281, 302689, 312935, 357905, 351031, 272651, 357895, 357891, 351028, 357884, 351026, 357877, 357874, 357872, 356488, 356486, 341513, 275704, 272643, 280445, 272639, 354876, 343681, 272632, 272630, 337320, 352571, 352093, 352564, 351797, 351791, 326097, 276645, 351011, 302686, 272611, 280432, 312928, 312926, 280430, 312924, 326094, 326092, 326091, 326089, 278240, 326086, 292934, 351009, 272609, 351007, 351004, 350994, 312922, 326082, 326079, 295695, 312656, 295691, 349679, 347501, 280425, 343845, 278237, 343842, 296565, 300599, 344623, 344620, 344617, 342876, 344371, 272573, 280419, 296815, 343818, 284676, 344094, 329630, 329628, 308281, 280403, 343814, 329621, 308273, 343654, 308271, 343652, 342868, 280394, 337316, 337314, 317264, 314487, 342810, 342856, 317261, 342808, 317258, 342164, 342162, 317254, 272552, 285089, 298447, 290213, 336524, 342160, 342157, 339752, 342154, 339750, 272540, 337312, 298444, 280383, 315902, 280381, 280380, 280376, 315899, 308252, 340613, 340606, 280372, 337310, 280370, 280368, 321395, 280364, 280362, 307911, 339943, 275989, 275987, 312653, 339433, 280357, 291741, 291739, 291737, 291735, 291733, 291730, 280332, 280327, 330953, 278233, 330951, 336685, 337303, 336681, 280320, 336812, 336887, 336810, 336805, 336803, 273288, 331110, 273284, 280316, 280313, 296785, 296781, 295675, 274962, 273055, 273053, 335898, 335896, 315036, 272489, 274956, 280310, 335260, 285598, 272478, 335031, 335139, 295827, 272473, 335027, 295823, 272471, 295666, 295661, 307898, 330949, 333054, 330947, 333052, 307896, 280304, 280300, 330942, 330937, 319167, 280291, 280289, 330935, 330931, 278781, 275962, 275960, 285086, 305797, 328170, 307892, 285084, 285082, 323655, 325972, 327745, 275957, 272447, 296555, 283801, 285079, 280274, 322635, 280272, 304245, 296545, 317216, 296541, 296539, 296537, 280261, 280256, 283797, 321390, 321474, 307887, 274932, 321289, 272427, 274930, 296527, 319659, 280236, 301543, 301541, 319657, 280234, 312650, 275954, 315541, 272417, 301537, 301535, 316236, 301531, 316234, 301529, 319052, 307885, 292594, 314822, 317633, 318095, 307884, 312648, 319046, 313122, 318827, 312645, 318824, 318713, 318118, 318116, 318114, 317614, 315273, 302669, 307876, 315270, 317612, 318130, 312644, 272401, 315892, 318100, 317638, 312640, 316863, 280213, 316821, 314285, 307872, 314283, 295369, 314820, 316861, 316847, 316859, 312638, 316845, 316834, 314818, 314816, 316818, 316815, 316781, 316637, 316227, 280209, 312636, 316202, 312635, 316200, 316198, 316196, 274013, 274011, 274009, 315259, 272382, 280206, 315327, 315888, 272378, 280203, 312634, 315006, 314336, 312632, 306537, 272368, 306532, 314343, 306530, 313938, 312631, 307865, 304236, 304234, 280200, 286655, 278772, 304764, 314340, 312630, 314338, 286653, 314331, 295650, 272365, 312628, 312627, 304229, 314136, 304227, 313110, 304224, 304222, 304219, 273530, 313108, 312625, 313258, 272362, 313254, 304215, 313106, 304203, 304201, 312074, 313246, 272357, 272353, 275689, 272351, 284906, 313243, 275685, 272349, 312620, 272347, 275680, 272342, 312896, 272338, 275677, 312890, 312615, 312612, 312610, 299393, 312606, 312603, 299391, 312600, 284903, 280194, 308226, 308223, 300036, 307858, 307856, 280182, 280174, 280172, 275944, 275942, 280170, 272333, 280168, 280165, 284826, 282950, 284901, 280163, 272328, 288450, 280161, 280159, 280156, 272324, 280153, 272321, 274802, 280152, 274799, 272319, 307849, 272317, 280149, 272315, 305916, 278371, 288446, 272313, 18302, 288443, 311876, 280146, 308112, 272311, 457844, 274004, 310868, 310863, 280144, 300032, 311289, 272305, 280133, 308106, 284895, 305899, 300027, 300025, 275940, 300023, 272301, 300021, 272296, 272294, 310610, 305897, 310390, 310386, 291059, 310384, 280130, 291056, 305896, 308216, 291054, 291050, 308213, 280128, 280126, 308095, 296757, 307749, 296754, 307747, 307055, 305310, 307265, 307259, 304449, 306945, 306936, 306934, 272288, 306928, 306923, 304062, 306921, 304552, 272280, 272278, 305913, 306203, 302665, 302663, 288882, 302661, 304501, 305023, 304499, 304441, 301876, 288425, 272249, 300576, 288419, 300574, 280117, 301526, 301524, 275722, 301463, 280110, 280108, 280105, 275936, 280103, 300573, 275933, 272247, 275930, 300572, 275928, 275925, 275923, 288413, 272243, 280101, 288411, 292231, 272239, 280099, 280097, 295634, 300320, 272236, 288407, 299848, 294644, 294642, 294640, 280091, 280088, 278361, 292258, 278359, 280084, 296509, 272232, 298726, 298347, 291022, 274908, 280083, 296735, 285592, 298724, 298721, 298430, 296467, 296501, 280079, 296726, 296334, 282942, 298339, 272225, 296497, 282940, 298336, 296464, 292243, 295819, 295817, 296314, 295632, 296121, 292575, 292573, 295815, 295628, 296116, 295626, 292561, 295585, 293716, 293713, 293711, 293708, 293706, 293704, 276640, 293702, 295360, 293699, 293697, 295358, 293694, 295356, 276637, 276634, 295391, 292240, 272216, 295353, 280076, 295348, 295387, 295344, 292527, 295151, 295145, 284229, 294893, 294637, 294498, 294635, 290438, 294633, 290698, 292229, 293782, 293779, 293577, 288052, 293575, 288050, 293573, 288047, 288320, 292519, 292207, 280071, 274906, 274902, 291913, 273985, 291910, 278355, 291907, 280070, 282932, 286620, 284411, 284667, 284409, 275675, 292194, 292203, 292217, 273983, 284406, 291047, 273977, 273976, 273973, 273971, 286609, 273968, 273965, 273963, 273961, 291000, 273958, 273955, 273949, 286602, 290728, 273947, 273941, 273938, 290619, 285076, 290617, 285074, 272210, 273935, 285290, 275714, 289338, 286168, 275711, 289332, 289803, 289797, 288841, 283795, 288736, 283793, 289328, 286166, 289323, 36556, 269564, 280067, 280063, 280062, 272206, 283790, 276618, 272202, 287840, 276615, 273932, 283154, 280046, 272194, 287260, 283785, 285963, 285959, 286594, 287164, 280040, 276607, 284884, 275913, 285626, 284880, 285261, 272189, 285063, 272186, 272180, 272177, 272175, 275910, 272170, 280021, 272167, 272165, 275907, 276504, 275902, 275900, 276501, 282929, 275898, 280017, 272158, 272156, 280015, 272154, 283150, 283779, 272150, 283146, 283145, 280012, 283773, 284388, 283770, 283768, 283141, 282924, 279711, 282919, 275890, 275887, 275885, 272141, 275883, 274738, 279700, 279872, 278230, 272134, 273016, 273926, 276494, 276557, 276492, 276490, 276485, 276376, 276373, 273921, 275759, 273919, 275436, 274675, 273912, 274828, 275434, 274826, 273158, 274129, 273997, 273908, 273902, 273136, 273134, 272126, 273013, 273130, 272119, 272115, 273011, 273128, 273031, 272971, 272106, 269470, 194889, 247375, 191970, 186100, 168216, 189629, 185814, 185806, 186017, 186031, 185936, 184877, 184032, 184945, 184333, 184722, 184873, 184785, 175487, 174834, 172627, 175483, 18254, 173081, 172552, 172991, 141526, 155213, 172727, 171908, 172618, 172616, 160093, 163250, 171453, 171353, 171266, 170799, 18243, 18238, 164249, 170298, 165304, 169367, 170190, 167748, 169832, 145296, 167744, 167742, 167740, 167737, 167735, 169570, 167973, 167969, 167732, 168901, 162188, 168962, 167377, 169115, 155195, 168173, 167883, 8027, 168939, 167879, 168689, 168295, 167976, 167877, 167305, 167726, 167724, 116133, 142773, 142771, 142769, 167632, 167365, 166759, 123403, 164744, 166904, 166901, 166619, 159698, 166614, 166142, 159695, 166333, 166327, 165484, 159685, 165258, 166132, 165959, 165954, 150419, 165873, 165702, 165457, 164997, 120499, 120497, 120490, 159407, 164646, 163703, 164241, 163695, 163686, 163676, 163292, 163277, 163274, 159394, 162958, 159392, 163232, 162729, 161539, 162718, 162649, 162406, 18225, 162100, 162097, 152170, 157476, 155685, 158494, 157360, 158041, 157354, 157350, 157663, 158029, 157658, 154508, 156785, 157802, 157348, 157650, 157461, 157519, 134726, 157458, 157112, 157071, 117359, 117355, 154307, 154305, 154303, 155724, 150887, 153778, 154297, 154293, 150878, 150875, 141330, 154290, 150417, 154288, 153995, 134716, 153537, 59165, 147994, 36793, 129984, 129981, 117240, 59158, 117236, 117231, 123921, 123208, 123969, 101, 122689, 121518, 122686, 121515, 121507, 121834, 121493, 121150, 93295, 117171, 114329, 118810, 111521, 118703, 111222, 118558))
Run Time: 0.037068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1951 | |
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 | | | | | 1951 | |
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 (29767, 29766, 29765, 29746, 29745, 29744, 29729, 29714, 29699, 29634, 29455, 29442, 29390, 28476, 28473, 28395, 28357, 28310, 28224, 27048, 26919, 26287, 25998, 25141, 25281, 25282, 25283, 25284, 25285, 25286, 25287, 25288, 25289, 25290, 25291, 25292, 25293, 24908, 24734, 24683, 24611, 24482, 24350, 24257, 23887, 23470, 23467, 23459, 23457, 23456, 23455, 23450, 23329, 22140, 20455, 20454, 20308, 19512, 19366, 19251, 19250, 19172, 19145, 17961, 17935, 17090, 16591, 16313, 16199, 15802, 15757, 15725, 15713, 15676, 15626, 15562, 15536, 15371, 15163, 15039, 14975, 14871, 14858, 14852, 14749, 14691, 14661, 14660, 14628, 14585, 14571, 14234, 14196, 14082, 14081, 14569, 14570, 14572, 14016, 13976, 13857, 11612, 11438, 11410, 11252, 11150, 11147, 11084, 11034, 10934, 10912, 10837, 10701, 10666, 10538, 10495, 10484, 8947, 8861, 8824))
Run Time: 0.003591
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 120 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, �^�
Run Time: 0.000190
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.000313
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.000469
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: 1717261275
Run Time: 0.000256
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 9 | 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` >= 1717261275)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000425
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 9 | 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