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.000761
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.000206
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` = '5097')
LIMIT 1
Run Time: 0.000385
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.002154
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_5097' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.087377
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 (569224, 569247, 315149, 559077, 315148, 315146, 315143, 407056, 478117, 560308, 478105, 478097, 568957, 560306, 565159, 407054, 568915, 568862, 568878, 568797, 478075, 478069, 282572, 568704, 282570, 478063, 568697, 568564, 314325, 568631, 560304, 568380, 565157, 568378, 560303, 289664, 560301, 568376, 565154, 568374, 542048, 542044, 568480, 559208, 565150, 559207, 565143, 564428, 568129, 568400, 565140, 568189, 542035, 568370, 542033, 506837, 542027, 459546, 565138, 568259, 542013, 568237, 568255, 565136, 568042, 568250, 542009, 565133, 565130, 540912, 561869, 567971, 568185, 568034, 567477, 567955, 284964, 289662, 561253, 567450, 508524, 567578, 559201, 540250, 559156, 329790, 290905, 335224, 559148, 566626, 481291, 566343, 565598, 566052, 566278, 275425, 277029, 565591, 566047, 565584, 565578, 500728, 566032, 566041, 566139, 423050, 517134, 565792, 565306, 290901, 481288, 477700, 498655, 483842, 565323, 565571, 482311, 565305, 507564, 565302, 561982, 500665, 477697, 565415, 546113, 507562, 563471, 565618, 565127, 564288, 565561, 423047, 565535, 282384, 308068, 564984, 564873, 509387, 522035, 407371, 564620, 277021, 564075, 564398, 482309, 564182, 516554, 564396, 560044, 562835, 560298, 560296, 564392, 564415, 564413, 560039, 564379, 509384, 564377, 507558, 476110, 564073, 293561, 277015, 563958, 452964, 507555, 564071, 564311, 476108, 550347, 563280, 564034, 307154, 563860, 474435, 299967, 516567, 563445, 326332, 489675, 316620, 370116, 92552, 516564, 560854, 316616, 563220, 563378, 360511, 550472, 540876, 477685, 540866, 477683, 563324, 540864, 360508, 563374, 563086, 563301, 563372, 300262, 354251, 299965, 563299, 477681, 477679, 563126, 540861, 563319, 562322, 294376, 563080, 353369, 563210, 459503, 459501, 294374, 489670, 477677, 353366, 290898, 294370, 293555, 563207, 563119, 293553, 294368, 563269, 477667, 563267, 563264, 563195, 563263, 563110, 562988, 563262, 563144, 562514, 489667, 489663, 276332, 489658, 562938, 562622, 276329, 293551, 562619, 489653, 293549, 540847, 540844, 398727, 540840, 489638, 562653, 489637, 489635, 277007, 562649, 489632, 562552, 505159, 562548, 522032, 540246, 562610, 562423, 540244, 542006, 562419, 522028, 562366, 282310, 522023, 556944, 559074, 522019, 561847, 559291, 561247, 481849, 417386, 561215, 481844, 538313, 417384, 557161, 560539, 293541, 454781, 561052, 561054, 561049, 561033, 560895, 512613, 560968, 560312, 561030, 452958, 512611, 282273, 454779, 537827, 282266, 509376, 560906, 500823, 560891, 520819, 560902, 560829, 555172, 520816, 560826, 546477, 285623, 547527, 490162, 560831, 504745, 559555, 282259, 555164, 282252, 282249, 555162, 275410, 275408, 560531, 509373, 560764, 317369, 556938, 560528, 515113, 500818, 560462, 293536, 419338, 560310, 343711, 369854, 560385, 556451, 275406, 282244, 559063, 540239, 522892, 515101, 559652, 558319, 559650, 515093, 560016, 558317, 282187, 560012, 559980, 557814, 316611, 274488, 275399, 282167, 559824, 275392, 481283, 392041, 276323, 275389, 275655, 274486, 481281, 559467, 326320, 472633, 282145, 559464, 559339, 494308, 311034, 559091, 559089, 311032, 275654, 293530, 293528, 520930, 275650, 492408, 557791, 558977, 559003, 559010, 546373, 476102, 558901, 308049, 546371, 275641, 476099, 558122, 558942, 556902, 558896, 546464, 555904, 558413, 555901, 558161, 545253, 293523, 500814, 509368, 558350, 558545, 558343, 558564, 509366, 558543, 557108, 353363, 291885, 381991, 557151, 517087, 498184, 307151, 557106, 507521, 556434, 556581, 556579, 556842, 556867, 556950, 507519, 556422, 282105, 494302, 556412, 555791, 493051, 552617, 337074, 523730, 544539, 457041, 286479, 474432, 552349, 291875, 550876, 276993, 552002, 459491, 465162, 276991, 301507, 452940, 452938, 546360, 550738, 452936, 550736, 516552, 516549, 516547, 546355, 473170, 473169, 473165, 551968, 541807, 551876, 541804, 551854, 551701, 411190, 507501, 459489, 551640, 276313, 313080, 492908, 551437, 551224, 550448, 551345, 550871, 291871, 291869, 291867, 546350, 550421, 487321, 550734, 546346, 550830, 507495, 459487, 512807, 407051, 286476, 395244, 395243, 276985, 550073, 540796, 546333, 276977, 546330, 546326, 313070, 410382, 304430, 546322, 410380, 546316, 506255, 507492, 506252, 281988, 507490, 313066, 308041, 507486, 275638, 546298, 546295, 483784, 507484, 548470, 326308, 509983, 507482, 508982, 546289, 547523, 274484, 547264, 518588, 275729, 547040, 276306, 276302, 486589, 546504, 546420, 545091, 547015, 546501, 291863, 541240, 486585, 546223, 546726, 365970, 546217, 546481, 452909, 497221, 540764, 476057, 452906, 293514, 487755, 545984, 279346, 344898, 274482, 275635, 452889, 502059, 545982, 546126, 546084, 545978, 523109, 545975, 496354, 546014, 546074, 395231, 311576, 545751, 545881, 315111, 545883, 545848, 487730, 311573, 315109, 315106, 311570, 545697, 545794, 545812, 496350, 311568, 540601, 545742, 454390, 541895, 496348, 541589, 541889, 545553, 541887, 541885, 545542, 541883, 523100, 506247, 545429, 541996, 545414, 545134, 496043, 407040, 528192, 517710, 293510, 329773, 545197, 545313, 545319, 528187, 544964, 544839, 544779, 275632, 507473, 528185, 507471, 541795, 507469, 541576, 507465, 407366, 541788, 353356, 407364, 477573, 407362, 285399, 508515, 477570, 507455, 477567, 540759, 544417, 544394, 544348, 508512, 544298, 544352, 544391, 353353, 544344, 544350, 543573, 281880, 541876, 541870, 541989, 408458, 544249, 544246, 308028, 326300, 541868, 541987, 543313, 541864, 541562, 492903, 544082, 296873, 492900, 544059, 543511, 502512, 543715, 284338, 543748, 492897, 329771, 281871, 512794, 284335, 541863, 541984, 543390, 541980, 542357, 508507, 543388, 543325, 353345, 542888, 353340, 412942, 412938, 477545, 542877, 542866, 542870, 416353, 542510, 542344, 542355, 477542, 542340, 520407, 542192, 284328, 542190, 274057, 287064, 541972, 541784, 537291, 287061, 316585, 541862, 541234, 498879, 541781, 541647, 335222, 508500, 541645, 541230, 541411, 281855, 541407, 541649, 541405, 541403, 540237, 541617, 315457, 541551, 484062, 481264, 421520, 463303, 541487, 541610, 541401, 484060, 315455, 316580, 316578, 376298, 316576, 470115, 406669, 406668, 537281, 304417, 541208, 281849, 304415, 304413, 535559, 535557, 528109, 528107, 509337, 304411, 528105, 528103, 486584, 528097, 537401, 304409, 541187, 538988, 541173, 275383, 291858, 308020, 538985, 536856, 541179, 316573, 304406, 541170, 316570, 541092, 536853, 541090, 477538, 536849, 500658, 540694, 476053, 507450, 540311, 541051, 507447, 540722, 507444, 507442, 281835, 283208, 540688, 283206, 281829, 540741, 540679, 539916, 498873, 540715, 539913, 514405, 296872, 540309, 540356, 508496, 540612, 540331, 281826, 507438, 516562, 370113, 507436, 540538, 540563, 537262, 540304, 497582, 540346, 540216, 540298, 508493, 540530, 540534, 540227, 540328, 540326, 540225, 497580, 537258, 287038, 287036, 540232, 503200, 540212, 540230, 540220, 540209, 539842, 540057, 540060, 539838, 311026, 539935, 415021, 415014, 454776, 527137, 516537, 278744, 507434, 415012, 276297, 275380, 276295, 507432, 539789, 276293, 539775, 509477, 486583, 276291, 503198, 486581, 509475, 505340, 276289, 509472, 509470, 276287, 539040, 539164, 516406, 291856, 516404, 539162, 539296, 295711, 509464, 538744, 509460, 509457, 539294, 539160, 539183, 503196, 539158, 407183, 308017, 503191, 538676, 539155, 539179, 539219, 539148, 539050, 457245, 539130, 539146, 476046, 539175, 539047, 355039, 539038, 281813, 539144, 539128, 539057, 539034, 537239, 506240, 537815, 537811, 538777, 506238, 539032, 526682, 539030, 538834, 455707, 537237, 281808, 538510, 538741, 538991, 526680, 484610, 481261, 537540, 526677, 537538, 538739, 538731, 308012, 508489, 538729, 508485, 538875, 538727, 484602, 538737, 538871, 329768, 484598, 538725, 329766, 538765, 538723, 538663, 484596, 512197, 484590, 512194, 535555, 329764, 484572, 538501, 329762, 276284, 512192, 538497, 482209, 537840, 276280, 538304, 538301, 281797, 486579, 496327, 410374, 410372, 499129, 486578, 410369, 276279, 512190, 537529, 276277, 499126, 281790, 293488, 537798, 496324, 370112, 298642, 537838, 481258, 537788, 527136, 481256, 496317, 501513, 490642, 536639, 308010, 537101, 486568, 472269, 481252, 407181, 537376, 281781, 536632, 537396, 484561, 281776, 536983, 536913, 537356, 326286, 276274, 293484, 537231, 537362, 535553, 281734, 378878, 535051, 355380, 477533, 535243, 535030, 283712, 535026, 517823, 283710, 182664, 346675, 278833, 506768, 308007, 535019, 313050, 527389, 535186, 506762, 513283, 527265, 275365, 535013, 313048, 535011, 535139, 486559, 500516, 523499, 499119, 523489, 486553, 281698, 290658, 276968, 516664, 281689, 290656, 281670, 528383, 528459, 481240, 528139, 281668, 528161, 290654, 287887, 516662, 513136, 290652, 287883, 512606, 528157, 528155, 527261, 475957, 281644, 528132, 528200, 528093, 528177, 512602, 528090, 528175, 528087, 528084, 517053, 281630, 417383, 286131, 527349, 281612, 527484, 507407, 286128, 417380, 304388, 527438, 281607, 304386, 491555, 527347, 276966, 417378, 527166, 509319, 527345, 491553, 515615, 527298, 515613, 292809, 527292, 308002, 527267, 527258, 527125, 527135, 527122, 527132, 510489, 527171, 527148, 527118, 527087, 343704, 454774, 516386, 291173, 291171, 295864, 509311, 523002, 526854, 516383, 526650, 516377, 526647, 526831, 370111, 523923, 481228, 526643, 298614, 516531, 281518, 486874, 298611, 523467, 281512, 281498, 523709, 523707, 292804, 523938, 472268, 472266, 509450, 472264, 472261, 523907, 523096, 523700, 523088, 520489, 281472, 523086, 281469, 307999, 523147, 523043, 281467, 523698, 281463, 516524, 281457, 523079, 520168, 475911, 472259, 523517, 523070, 521850, 523659, 523260, 523255, 517047, 512744, 522977, 512741, 521827, 276259, 522569, 276256, 298604, 298602, 522818, 276253, 291854, 522749, 522557, 408192, 522711, 509285, 522449, 522523, 522464, 511133, 521477, 281342, 522418, 522126, 486722, 512730, 512729, 477478, 522051, 478055, 482305, 522089, 521235, 313215, 518182, 407356, 281310, 521941, 518180, 521760, 521218, 407354, 518176, 313207, 521799, 521912, 281294, 518171, 521780, 519214, 518793, 521206, 518789, 521757, 521202, 418746, 313041, 519837, 407353, 521200, 508976, 313038, 517618, 521305, 512186, 518787, 520928, 516506, 521376, 519228, 486869, 448789, 405333, 521374, 508003, 516496, 518785, 521112, 520974, 519212, 325978, 467606, 516485, 276234, 520971, 407350, 516483, 276227, 292794, 518970, 475859, 516481, 475855, 276225, 516475, 292789, 518967, 289640, 518519, 517046, 335212, 285213, 486721, 508001, 510944, 284959, 416339, 518551, 517961, 422370, 518515, 304357, 422368, 516637, 518529, 516635, 518302, 517958, 422365, 518382, 416337, 289628, 475804, 422363, 517792, 328176, 517494, 274473, 517577, 422361, 395202, 517188, 518128, 517040, 517593, 311024, 293454, 274471, 276216, 271850, 518125, 274468, 517777, 321311, 517929, 517492, 293452, 503750, 517925, 271848, 346674, 499445, 278822, 290598, 517700, 353320, 370105, 517610, 517573, 283698, 475795, 477414, 291848, 516626, 517488, 517037, 293450, 498849, 517035, 480276, 517486, 360481, 281145, 517462, 475792, 517286, 451980, 480274, 422358, 293448, 360476, 281143, 515023, 515021, 276944, 516188, 475786, 517185, 516930, 517033, 515019, 515018, 516880, 276942, 516868, 482202, 276940, 516348, 276210, 307975, 516338, 482685, 482681, 502024, 370103, 291846, 502020, 516770, 482677, 516610, 516560, 370101, 516576, 516646, 399816, 516615, 516709, 281117, 515603, 516063, 514831, 516132, 514829, 370099, 515788, 318123, 281086, 290590, 513547, 515548, 515598, 515540, 512413, 515593, 515221, 515011, 277839, 515006, 276199, 512411, 514033, 515219, 276197, 514763, 512409, 514391, 512184, 514372, 512182, 514023, 418124, 512178, 513853, 500419, 481180, 500417, 481177, 506128, 513741, 513811, 513544, 513261, 513629, 513621, 513215, 513540, 370095, 376709, 513258, 513254, 513213, 344413, 513252, 376707, 512662, 511682, 275625, 511680, 511678, 274463, 274461, 281072, 513112, 513118, 513016, 356512, 505691, 418122, 512687, 513000, 512403, 513039, 505688, 512492, 476508, 512433, 486837, 512401, 512638, 512714, 512429, 512490, 475715, 512354, 512424, 351807, 511929, 293443, 512439, 307968, 281063, 293440, 275620, 293439, 511123, 475713, 511971, 475710, 511906, 275612, 275610, 491323, 511886, 511671, 511668, 482199, 506118, 484718, 484715, 408456, 484713, 511509, 475707, 511257, 511496, 299941, 510938, 481156, 511253, 511248, 511246, 481153, 511351, 511297, 502019, 511243, 481151, 122087, 510936, 486907, 486904, 509697, 486901, 511150, 511061, 502017, 511069, 511060, 510985, 511066, 511085, 291834, 511056, 510914, 510982, 502015, 486895, 510980, 510930, 486890, 502009, 510918, 502004, 510866, 276184, 289620, 510858, 364324, 276182, 489259, 510721, 510574, 313034, 291833, 475696, 302545, 508967, 489257, 302542, 302539, 510552, 500193, 500187, 302536, 364319, 510550, 510538, 481145, 283957, 509417, 276938, 510471, 364316, 508997, 276928, 356509, 509667, 509781, 477386, 509665, 286971, 510139, 477384, 505323, 509992, 447943, 477379, 508868, 292778, 477375, 509267, 292775, 293428, 510006, 509904, 508990, 509931, 475682, 286966, 508985, 509744, 292771, 509264, 509657, 509027, 509129, 509250, 509444, 509589, 508866, 508743, 352403, 277096, 508479, 508305, 508302, 477358, 278710, 506544, 454768, 474431, 508229, 475659, 454766, 486719, 337347, 486716, 336565, 289155, 508104, 475654, 500777, 504887, 503173, 507975, 465160, 507964, 498570, 291830, 508058, 274190, 505917, 465158, 465156, 288370, 507763, 507356, 291825, 454763, 507637, 507649, 507351, 506977, 506972, 507348, 475646, 477343, 475644, 507346, 505660, 505783, 506541, 507229, 506526, 506524, 506701, 505904, 506801, 506755, 506751, 284719, 506626, 506697, 505900, 506358, 284717, 274055, 503220, 486728, 486714, 506520, 505652, 505631, 486191, 505628, 150232, 506110, 454757, 486188, 506002, 454746, 505960, 505773, 454738, 475629, 502106, 505792, 505451, 477308, 505771, 505591, 454735, 505744, 505322, 454730, 505318, 504577, 334100, 505300, 281034, 454727, 505316, 505326, 504860, 504535, 284839, 486712, 284837, 503365, 484282, 343748, 503320, 503227, 343746, 274053, 274051, 503336, 495735, 503310, 281017, 281015, 274050, 271814, 503225, 499293, 281012, 274047, 482193, 503266, 499291, 281010, 503218, 503248, 503167, 503003, 289148, 503164, 312834, 500541, 503157, 503130, 503214, 289142, 290582, 467588, 326227, 501379, 490859, 294361, 502831, 481138, 500714, 501487, 501858, 501996, 501992, 501990, 481116, 502064, 286422, 464797, 286419, 286413, 481112, 481110, 500172, 286411, 481108, 501890, 501592, 501856, 501645, 326190, 290570, 285195, 410358, 501582, 501614, 501606, 422992, 339797, 410355, 285191, 500031, 339793, 410353, 500947, 422989, 501352, 339791, 326185, 500711, 481076, 357466, 501460, 357463, 422985, 501299, 500166, 499016, 36983, 501243, 501240, 291821, 501209, 501033, 501218, 291819, 405321, 486815, 363494, 500959, 500553, 501012, 500976, 291817, 500707, 500832, 487079, 290567, 500701, 487077, 472208, 290565, 500732, 500158, 495481, 286407, 294355, 500044, 472206, 472204, 276925, 500407, 500393, 498693, 500225, 500041, 464793, 498691, 497965, 495705, 495703, 283177, 500209, 499231, 500060, 500121, 294352, 294350, 487186, 500014, 474365, 487184, 294348, 454717, 497554, 499867, 474361, 490850, 499721, 290861, 487179, 497551, 313191, 276921, 493958, 499676, 284321, 276919, 284318, 497548, 493956, 481060, 499439, 497543, 493954, 493952, 499286, 275598, 499515, 329736, 495167, 498081, 481058, 499435, 498767, 498765, 292452, 498976, 463295, 292450, 498763, 498942, 498760, 498742, 286089, 275592, 321511, 286086, 497464, 498240, 321509, 275589, 286082, 497880, 486808, 497861, 497860, 486806, 475496, 497634, 338280, 497471, 284716, 496600, 496721, 491909, 491907, 491905, 374110, 497327, 496714, 496522, 293386, 293384, 496519, 293382, 496709, 496517, 496626, 454712, 360357, 481045, 495471, 496506, 496503, 496509, 496500, 496486, 493047, 496488, 496211, 496199, 496122, 289136, 289134, 496119, 495692, 482191, 495671, 289132, 307965, 289604, 289602, 495502, 491901, 276914, 276912, 495023, 457882, 276910, 486549, 486546, 495142, 492979, 286923, 465091, 474997, 486544, 302532, 286919, 294344, 420759, 289598, 494543, 493951, 301467, 486541, 279328, 399732, 279326, 311020, 491682, 494252, 494250, 493948, 456711, 494298, 276169, 456708, 494316, 494331, 494248, 490809, 276160, 335205, 335199, 311013, 289595, 493842, 493946, 311011, 289591, 335198, 493943, 490802, 360355, 493940, 311001, 493937, 307964, 493777, 289587, 490799, 289581, 307963, 493708, 310992, 289577, 493234, 310984, 490259, 310979, 486725, 492184, 492652, 490257, 493230, 310968, 286397, 492863, 492858, 492855, 492842, 492966, 352591, 491650, 293362, 289566, 275582, 492673, 492579, 487150, 299922, 289563, 481042, 274456, 299919, 492355, 492348, 492155, 492217, 302843, 293358, 492265, 492169, 492153, 300215, 491932, 491928, 491606, 491675, 463120, 491595, 289558, 480747, 466899, 491672, 408920, 491604, 491586, 335196, 286913, 487439, 283923, 491374, 491307, 294342, 486774, 462447, 491305, 490524, 351377, 489252, 462440, 491241, 351375, 490939, 490937, 392037, 490934, 490932, 286050, 490429, 274184, 289125, 285361, 286048, 490875, 280981, 490827, 490496, 490837, 490554, 489555, 490822, 490750, 490794, 490791, 490522, 490493, 395188, 490518, 283920, 487169, 490514, 489249, 487167, 490487, 490298, 490271, 490199, 489887, 275579, 289114, 490013, 490026, 275577, 293333, 275575, 489613, 296852, 289112, 275570, 482185, 486072, 458050, 296850, 310956, 489611, 289831, 285178, 489549, 296848, 489481, 289109, 489170, 289105, 299916, 293327, 310949, 296846, 488477, 310947, 489168, 488860, 452844, 488858, 452842, 488856, 293321, 488853, 487691, 280973, 488315, 289103, 487350, 487348, 487432, 487390, 375546, 286891, 482303, 286889, 487548, 378867, 486537, 375541, 352341, 286887, 291815, 378866, 291813, 378865, 400282, 484761, 484944, 293308, 486887, 291808, 340778, 486747, 482370, 291806, 486486, 486885, 486482, 486428, 291804, 395181, 486426, 274045, 454711, 454708, 291802, 486423, 486390, 486382, 290551, 294337, 408172, 486324, 291800, 486021, 467586, 406871, 293297, 484170, 293295, 293293, 484531, 484753, 360971, 406867, 293290, 291798, 279303, 480745, 484867, 484747, 274445, 279301, 403403, 291796, 291794, 484523, 484517, 467581, 292436, 484357, 484511, 484263, 484359, 484366, 484462, 280962, 274163, 315097, 279292, 484018, 291163, 315093, 483580, 483542, 483574, 483570, 483538, 319726, 483537, 384846, 483995, 483568, 484013, 329719, 483736, 483712, 280956, 395161, 483450, 329717, 480733, 329713, 274441, 329711, 483562, 483531, 360969, 483560, 290546, 290849, 479970, 275346, 276891, 483509, 276889, 290544, 483431, 479910, 483226, 483199, 483160, 483197, 286880, 483183, 483192, 457874, 483157, 360965, 307146, 483153, 483148, 483173, 483086, 342195, 307144, 483097, 483084, 313017, 483102, 342193, 483080, 342189, 420749, 366546, 342181, 276153, 316512, 482889, 301900, 392031, 482775, 482859, 482766, 481013, 278697, 482547, 482454, 481330, 480036, 392029, 316508, 341162, 480033, 481006, 275340, 482361, 278688, 301898, 482350, 479622, 275338, 294860, 301895, 274021, 482183, 481004, 482219, 480964, 274019, 481002, 278671, 481952, 480997, 481480, 329705, 280946, 480995, 481923, 480727, 480726, 480716, 352335, 469553, 400339, 480514, 475484, 352333, 480714, 480459, 480712, 352328, 352323, 350457, 384834, 480638, 283902, 352321, 384832, 381387, 480369, 276149, 278663, 276145, 480360, 286875, 278661, 315354, 315301, 289085, 480332, 480286, 480072, 289080, 315084, 480155, 480145, 315082, 480069, 480066, 459486, 286352, 289077, 479732, 296844, 296841, 454704, 289073, 480025, 479730, 352315, 289068, 274756, 289550, 381382, 479935, 479865, 479727, 365950, 479900, 479983, 479407, 479314, 478232, 286861, 452828, 286859, 395151, 479129, 470110, 478030, 477909, 278640, 478210, 326168, 477903, 286850, 459466, 477742, 337620, 459463, 302803, 472361, 286843, 275565, 292734, 278635, 477118, 276143, 477068, 329701, 338273, 477035, 477083, 476982, 477032, 477027, 294475, 476976, 473309, 475228, 300198, 476592, 476925, 459462, 476526, 476556, 476494, 283634, 275556, 476523, 476520, 476518, 283632, 476516, 384427, 280929, 467569, 292725, 275550, 420747, 275547, 467566, 316645, 276141, 418384, 475479, 276134, 356710, 307142, 310929, 291159, 450256, 475420, 337338, 337334, 276130, 461190, 276128, 326160, 474417, 283622, 293203, 279242, 451895, 474603, 474601, 454577, 276125, 342839, 291381, 454575, 342834, 342832, 467563, 326158, 467561, 474410, 473797, 295706, 335195, 474429, 456698, 474405, 335193, 361771, 474355, 288571, 395144, 473792, 465193, 459537, 465191, 335191, 291791, 400483, 288567, 465189, 459535, 473790, 294334, 462635, 459530, 400481, 291789, 294331, 470221, 473303, 291784, 326156, 355373, 473300, 395142, 420746, 283613, 286341, 473262, 459485, 472938, 472664, 451862, 305963, 472930, 421468, 472923, 473143, 293186, 283607, 472916, 283605, 275544, 473071, 473062, 473141, 355371, 280919, 469674, 473022, 473029, 473117, 290832, 472906, 472892, 472836, 473114, 469669, 473111, 472889, 473109, 473107, 472887, 473104, 286840, 472829, 286835, 469667, 286832, 421465, 473100, 472631, 286829, 472735, 472627, 286824, 472624, 354981, 275301, 416330, 355364, 294850, 418118, 472657, 384988, 384986, 291782, 472405, 472620, 316489, 355361, 384983, 472408, 472393, 418115, 316486, 458044, 355358, 384975, 352298, 275300, 316484, 275298, 472258, 326155, 334092, 326153, 472195, 462628, 470444, 471694, 470437, 469611, 469661, 470209, 468613, 471645, 471748, 315426, 316479, 471765, 416324, 416321, 471433, 468746, 471690, 470884, 276116, 418113, 470985, 470728, 276113, 470982, 470725, 470765, 315422, 286807, 276110, 418110, 291776, 470930, 418104, 291773, 466784, 466340, 462165, 466753, 275267, 293626, 306964, 300443, 466273, 452803, 300441, 304792, 276104, 454669, 465709, 465979, 465975, 451627, 465653, 280861, 291150, 307139, 341161, 280857, 280856, 459482, 354953, 360963, 291148, 465650, 465645, 280853, 459428, 463256, 454657, 360961, 413914, 420743, 459421, 275537, 360959, 360957, 278811, 459480, 465268, 465265, 464953, 395068, 465176, 465146, 278808, 293621, 465166, 465263, 463344, 465336, 465350, 276097, 370090, 278623, 461175, 276092, 336621, 299912, 370088, 464918, 464967, 463208, 299910, 278620, 464851, 464277, 291379, 464717, 394958, 461784, 464448, 463929, 464275, 464210, 461782, 464443, 464676, 458570, 462937, 276089, 458567, 463281, 289056, 463337, 463149, 463112, 463254, 278618, 459528, 462622, 455209, 319363, 411187, 463091, 278616, 459526, 463098, 461401, 463096, 278614, 462947, 463088, 462482, 462785, 454573, 459524, 462620, 365947, 455206, 462945, 352275, 291761, 462439, 411185, 462488, 462342, 454570, 391465, 300434, 335190, 462338, 279223, 415670, 461389, 458611, 461160, 461398, 461309, 411182, 280842, 461307, 461394, 458608, 459516, 283879, 415666, 454654, 461622, 461779, 461155, 459391, 329674, 285992, 461429, 459386, 459380, 461131, 365939, 279219, 329670, 461058, 459478, 280834, 460631, 460638, 411169, 453903, 293100, 460543, 460595, 460627, 460648, 460702, 315352, 296658, 460145, 420739, 296653, 460485, 337645, 411166, 290538, 284288, 290813, 460495, 460526, 290536, 290809, 410814, 302761, 284279, 459513, 460089, 460182, 460001, 411157, 296482, 337643, 453261, 290534, 284277, 460178, 459997, 459474, 459362, 283875, 459805, 460018, 460126, 460076, 326146, 313186, 459251, 459042, 410812, 459302, 410809, 304785, 459258, 459034, 313184, 459176, 459057, 459225, 459032, 459019, 417371, 459053, 290807, 458968, 419113, 417369, 290805, 419111, 280822, 352270, 329668, 416317, 458808, 458815, 419109, 458188, 280819, 300407, 458560, 352266, 275848, 458557, 352262, 290801, 300403, 329664, 458326, 419107, 276084, 458043, 457819, 458040, 458009, 276081, 458003, 329658, 276079, 458001, 457824, 280813, 280812, 315074, 310895, 310894, 276077, 457530, 457708, 452789, 300397, 310888, 457036, 300391, 456942, 452782, 456966, 456931, 294317, 419104, 296836, 310886, 294315, 456217, 456592, 406213, 456215, 419102, 310885, 456693, 456320, 419100, 391460, 456590, 335181, 456689, 450687, 454935, 455640, 456388, 456212, 451848, 335176, 310883, 456586, 456453, 454652, 404228, 395035, 360438, 454566, 415656, 453028, 452114, 454557, 455539, 452778, 454552, 454549, 454281, 328767, 452776, 414950, 349833, 305903, 454387, 315299, 449384, 283595, 280774, 449381, 454278, 416315, 278609, 376292, 452547, 451621, 453257, 295859, 285618, 419135, 419084, 417037, 417033, 330969, 418315, 407227, 418827, 418096, 382524, 457852, 291131, 417505, 407222, 418089, 418144, 416999, 417498, 302736, 291127, 417028, 417483, 291118, 319546, 417615, 330965, 416997, 417474, 417363, 290752, 410478, 291116, 415981, 319541, 416961, 276788, 290630, 417295, 416994, 330962, 414926, 417021, 280712, 415979, 319535, 289547, 290628, 416958, 417058, 298523, 277071, 290626, 290624, 417012, 416992, 290622, 414924, 412754, 413515, 416990, 302529, 289541, 400335, 414919, 416775, 400473, 412748, 412746, 414917, 352244, 352238, 414911, 410472, 410470, 416482, 416480, 286758, 410468, 286756, 415647, 298521, 410466, 298519, 290749, 410464, 414905, 352228, 415904, 352227, 410462, 290745, 415643, 410460, 415641, 415596, 286753, 286751, 285124, 410458, 286746, 410454, 414893, 410452, 408402, 413004, 412800, 285118, 276055, 276053, 276051, 411377, 412997, 344733, 375534, 276049, 276774, 412995, 276772, 276046, 412764, 275197, 344731, 276042, 276770, 275815, 412880, 344729, 388465, 276040, 300370, 276767, 300368, 278593, 412681, 411369, 276765, 274400, 410805, 280700, 276762, 289464, 352223, 276757, 410905, 410801, 447861, 411148, 447858, 411146, 410795, 411005, 410791, 411003, 410789, 275192, 410786, 408707, 410784, 410782, 410129, 410127, 335166, 289459, 276750, 289457, 411001, 276748, 410449, 289452, 276746, 410447, 289031, 289449, 410901, 280693, 275188, 284954, 289447, 280690, 410894, 335162, 280687, 276033, 289443, 335160, 276031, 335158, 280685, 410123, 410121, 335156, 410112, 391436, 410609, 316425, 289030, 410445, 343228, 410333, 410443, 410182, 410106, 316417, 410441, 289028, 410524, 410100, 276744, 411354, 410187, 343223, 410210, 410178, 276742, 410094, 289023, 286742, 286740, 289020, 286738, 389855, 276740, 275184, 321568, 409481, 289018, 321567, 321565, 286734, 293596, 350443, 293594, 289412, 286731, 286730, 278552, 289409, 286726, 278550, 289010, 289407, 409472, 350439, 289403, 409467, 278547, 289401, 342953, 289397, 289396, 289008, 289391, 289006, 290487, 290484, 408695, 408693, 304508, 408910, 406661, 286719, 290481, 284951, 289003, 284948, 284945, 289001, 284943, 278801, 290470, 408469, 408235, 408164, 286712, 296625, 289354, 407524, 407521, 289350, 278796, 407375, 407756, 403215, 401529, 276024, 401525, 407754, 407373, 407342, 294471, 401523, 290467, 336544, 294469, 296623, 294466, 407082, 407219, 290464, 406210, 407017, 407215, 288987, 401510, 407080, 406207, 406205, 288983, 316397, 401508, 293592, 406201, 391548, 276022, 360193, 307947, 288979, 293590, 406200, 326134, 288976, 276020, 284940, 307137, 406195, 307134, 406192, 284938, 381361, 381360, 288973))
Run Time: 0.150912
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3386 | |
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 | | | | | 3386 | |
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 (29668, 29366, 29175, 29174, 28939, 28738, 28467, 28361, 28155, 27616, 27502, 27454, 27449, 27447, 27446, 27444, 27442, 27438, 27251, 27245, 26937, 26644, 26173, 25653, 25638, 25428, 25001, 24613, 24386, 24385, 24384, 24375, 24218, 24144, 24120, 24023, 23507, 22924, 22696, 22695, 22567, 21481, 21419, 21377, 21038, 21021, 21060, 20761, 20706, 20688))
Run Time: 0.003919
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 50 | 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 (569224, 569247, 315149, 559077, 315148, 315146, 315143, 407056, 478117, 560308, 478105, 478097, 568957, 560306, 565159, 407054, 568915, 568862, 568878, 568797, 478075, 478069, 282572, 568704, 282570, 478063, 568697, 568564, 314325, 568631, 560304, 568380, 565157, 568378, 560303, 289664, 560301, 568376, 565154, 568374, 542048, 542044, 568480, 559208, 565150, 559207, 565143, 564428, 568129, 568400, 565140, 568189, 542035, 568370, 542033, 506837, 542027, 459546, 565138, 568259, 542013, 568237, 568255, 565136, 568042, 568250, 542009, 565133, 565130, 540912, 561869, 567971, 568185, 568034, 567477, 567955, 284964, 289662, 561253, 567450, 508524, 567578, 559201, 540250, 559156, 329790, 290905, 335224, 559148, 566626, 481291, 566343, 565598, 566052, 566278, 275425, 277029, 565591, 566047, 565584, 565578, 500728, 566032, 566041, 566139, 423050, 517134, 565792, 565306, 290901, 481288, 477700, 498655, 483842, 565323, 565571, 482311, 565305, 507564, 565302, 561982, 500665, 477697, 565415, 546113, 507562, 563471, 565618, 565127, 564288, 565561, 423047, 565535, 282384, 308068, 564984, 564873, 509387, 522035, 407371, 564620, 277021, 564075, 564398, 482309, 564182, 516554, 564396, 560044, 562835, 560298, 560296, 564392, 564415, 564413, 560039, 564379, 509384, 564377, 507558, 476110, 564073, 293561, 277015, 563958, 452964, 507555, 564071, 564311, 476108, 550347, 563280, 564034, 307154, 563860, 474435, 299967, 516567, 563445, 326332, 489675, 316620, 370116, 92552, 516564, 560854, 316616, 563220, 563378, 360511, 550472, 540876, 477685, 540866, 477683, 563324, 540864, 360508, 563374, 563086, 563301, 563372, 300262, 354251, 299965, 563299, 477681, 477679, 563126, 540861, 563319, 562322, 294376, 563080, 353369, 563210, 459503, 459501, 294374, 489670, 477677, 353366, 290898, 294370, 293555, 563207, 563119, 293553, 294368, 563269, 477667, 563267, 563264, 563195, 563263, 563110, 562988, 563262, 563144, 562514, 489667, 489663, 276332, 489658, 562938, 562622, 276329, 293551, 562619, 489653, 293549, 540847, 540844, 398727, 540840, 489638, 562653, 489637, 489635, 277007, 562649, 489632, 562552, 505159, 562548, 522032, 540246, 562610, 562423, 540244, 542006, 562419, 522028, 562366, 282310, 522023, 556944, 559074, 522019, 561847, 559291, 561247, 481849, 417386, 561215, 481844, 538313, 417384, 557161, 560539, 293541, 454781, 561052, 561054, 561049, 561033, 560895, 512613, 560968, 560312, 561030, 452958, 512611, 282273, 454779, 537827, 282266, 509376, 560906, 500823, 560891, 520819, 560902, 560829, 555172, 520816, 560826, 546477, 285623, 547527, 490162, 560831, 504745, 559555, 282259, 555164, 282252, 282249, 555162, 275410, 275408, 560531, 509373, 560764, 317369, 556938, 560528, 515113, 500818, 560462, 293536, 419338, 560310, 343711, 369854, 560385, 556451, 275406, 282244, 559063, 540239, 522892, 515101, 559652, 558319, 559650, 515093, 560016, 558317, 282187, 560012, 559980, 557814, 316611, 274488, 275399, 282167, 559824, 275392, 481283, 392041, 276323, 275389, 275655, 274486, 481281, 559467, 326320, 472633, 282145, 559464, 559339, 494308, 311034, 559091, 559089, 311032, 275654, 293530, 293528, 520930, 275650, 492408, 557791, 558977, 559003, 559010, 546373, 476102, 558901, 308049, 546371, 275641, 476099, 558122, 558942, 556902, 558896, 546464, 555904, 558413, 555901, 558161, 545253, 293523, 500814, 509368, 558350, 558545, 558343, 558564, 509366, 558543, 557108, 353363, 291885, 381991, 557151, 517087, 498184, 307151, 557106, 507521, 556434, 556581, 556579, 556842, 556867, 556950, 507519, 556422, 282105, 494302, 556412, 555791, 493051, 552617, 337074, 523730, 544539, 457041, 286479, 474432, 552349, 291875, 550876, 276993, 552002, 459491, 465162, 276991, 301507, 452940, 452938, 546360, 550738, 452936, 550736, 516552, 516549, 516547, 546355, 473170, 473169, 473165, 551968, 541807, 551876, 541804, 551854, 551701, 411190, 507501, 459489, 551640, 276313, 313080, 492908, 551437, 551224, 550448, 551345, 550871, 291871, 291869, 291867, 546350, 550421, 487321, 550734, 546346, 550830, 507495, 459487, 512807, 407051, 286476, 395244, 395243, 276985, 550073, 540796, 546333, 276977, 546330, 546326, 313070, 410382, 304430, 546322, 410380, 546316, 506255, 507492, 506252, 281988, 507490, 313066, 308041, 507486, 275638, 546298, 546295, 483784, 507484, 548470, 326308, 509983, 507482, 508982, 546289, 547523, 274484, 547264, 518588, 275729, 547040, 276306, 276302, 486589, 546504, 546420, 545091, 547015, 546501, 291863, 541240, 486585, 546223, 546726, 365970, 546217, 546481, 452909, 497221, 540764, 476057, 452906, 293514, 487755, 545984, 279346, 344898, 274482, 275635, 452889, 502059, 545982, 546126, 546084, 545978, 523109, 545975, 496354, 546014, 546074, 395231, 311576, 545751, 545881, 315111, 545883, 545848, 487730, 311573, 315109, 315106, 311570, 545697, 545794, 545812, 496350, 311568, 540601, 545742, 454390, 541895, 496348, 541589, 541889, 545553, 541887, 541885, 545542, 541883, 523100, 506247, 545429, 541996, 545414, 545134, 496043, 407040, 528192, 517710, 293510, 329773, 545197, 545313, 545319, 528187, 544964, 544839, 544779, 275632, 507473, 528185, 507471, 541795, 507469, 541576, 507465, 407366, 541788, 353356, 407364, 477573, 407362, 285399, 508515, 477570, 507455, 477567, 540759, 544417, 544394, 544348, 508512, 544298, 544352, 544391, 353353, 544344, 544350, 543573, 281880, 541876, 541870, 541989, 408458, 544249, 544246, 308028, 326300, 541868, 541987, 543313, 541864, 541562, 492903, 544082, 296873, 492900, 544059, 543511, 502512, 543715, 284338, 543748, 492897, 329771, 281871, 512794, 284335, 541863, 541984, 543390, 541980, 542357, 508507, 543388, 543325, 353345, 542888, 353340, 412942, 412938, 477545, 542877, 542866, 542870, 416353, 542510, 542344, 542355, 477542, 542340, 520407, 542192, 284328, 542190, 274057, 287064, 541972, 541784, 537291, 287061, 316585, 541862, 541234, 498879, 541781, 541647, 335222, 508500, 541645, 541230, 541411, 281855, 541407, 541649, 541405, 541403, 540237, 541617, 315457, 541551, 484062, 481264, 421520, 463303, 541487, 541610, 541401, 484060, 315455, 316580, 316578, 376298, 316576, 470115, 406669, 406668, 537281, 304417, 541208, 281849, 304415, 304413, 535559, 535557, 528109, 528107, 509337, 304411, 528105, 528103, 486584, 528097, 537401, 304409, 541187, 538988, 541173, 275383, 291858, 308020, 538985, 536856, 541179, 316573, 304406, 541170, 316570, 541092, 536853, 541090, 477538, 536849, 500658, 540694, 476053, 507450, 540311, 541051, 507447, 540722, 507444, 507442, 281835, 283208, 540688, 283206, 281829, 540741, 540679, 539916, 498873, 540715, 539913, 514405, 296872, 540309, 540356, 508496, 540612, 540331, 281826, 507438, 516562, 370113, 507436, 540538, 540563, 537262, 540304, 497582, 540346, 540216, 540298, 508493, 540530, 540534, 540227, 540328, 540326, 540225, 497580, 537258, 287038, 287036, 540232, 503200, 540212, 540230, 540220, 540209, 539842, 540057, 540060, 539838, 311026, 539935, 415021, 415014, 454776, 527137, 516537, 278744, 507434, 415012, 276297, 275380, 276295, 507432, 539789, 276293, 539775, 509477, 486583, 276291, 503198, 486581, 509475, 505340, 276289, 509472, 509470, 276287, 539040, 539164, 516406, 291856, 516404, 539162, 539296, 295711, 509464, 538744, 509460, 509457, 539294, 539160, 539183, 503196, 539158, 407183, 308017, 503191, 538676, 539155, 539179, 539219, 539148, 539050, 457245, 539130, 539146, 476046, 539175, 539047, 355039, 539038, 281813, 539144, 539128, 539057, 539034, 537239, 506240, 537815, 537811, 538777, 506238, 539032, 526682, 539030, 538834, 455707, 537237, 281808, 538510, 538741, 538991, 526680, 484610, 481261, 537540, 526677, 537538, 538739, 538731, 308012, 508489, 538729, 508485, 538875, 538727, 484602, 538737, 538871, 329768, 484598, 538725, 329766, 538765, 538723, 538663, 484596, 512197, 484590, 512194, 535555, 329764, 484572, 538501, 329762, 276284, 512192, 538497, 482209, 537840, 276280, 538304, 538301, 281797, 486579, 496327, 410374, 410372, 499129, 486578, 410369, 276279, 512190, 537529, 276277, 499126, 281790, 293488, 537798, 496324, 370112, 298642, 537838, 481258, 537788, 527136, 481256, 496317, 501513, 490642, 536639, 308010, 537101, 486568, 472269, 481252, 407181, 537376, 281781, 536632, 537396, 484561, 281776, 536983, 536913, 537356, 326286, 276274, 293484, 537231, 537362, 535553, 281734, 378878, 535051, 355380, 477533, 535243, 535030, 283712, 535026, 517823, 283710, 182664, 346675, 278833, 506768, 308007, 535019, 313050, 527389, 535186, 506762, 513283, 527265, 275365, 535013, 313048, 535011, 535139, 486559, 500516, 523499, 499119, 523489, 486553, 281698, 290658, 276968, 516664, 281689, 290656, 281670, 528383, 528459, 481240, 528139, 281668, 528161, 290654, 287887, 516662, 513136, 290652, 287883, 512606, 528157, 528155, 527261, 475957, 281644, 528132, 528200, 528093, 528177, 512602, 528090, 528175, 528087, 528084, 517053, 281630, 417383, 286131, 527349, 281612, 527484, 507407, 286128, 417380, 304388, 527438, 281607, 304386, 491555, 527347, 276966, 417378, 527166, 509319, 527345, 491553, 515615, 527298, 515613, 292809, 527292, 308002, 527267, 527258, 527125, 527135, 527122, 527132, 510489, 527171, 527148, 527118, 527087, 343704, 454774, 516386, 291173, 291171, 295864, 509311, 523002, 526854, 516383, 526650, 516377, 526647, 526831, 370111, 523923, 481228, 526643, 298614, 516531, 281518, 486874, 298611, 523467, 281512, 281498, 523709, 523707, 292804, 523938, 472268, 472266, 509450, 472264, 472261, 523907, 523096, 523700, 523088, 520489, 281472, 523086, 281469, 307999, 523147, 523043, 281467, 523698, 281463, 516524, 281457, 523079, 520168, 475911, 472259, 523517, 523070, 521850, 523659, 523260, 523255, 517047, 512744, 522977, 512741, 521827, 276259, 522569, 276256, 298604, 298602, 522818, 276253, 291854, 522749, 522557, 408192, 522711, 509285, 522449, 522523, 522464, 511133, 521477, 281342, 522418, 522126, 486722, 512730, 512729, 477478, 522051, 478055, 482305, 522089, 521235, 313215, 518182, 407356, 281310, 521941, 518180, 521760, 521218, 407354, 518176, 313207, 521799, 521912, 281294, 518171, 521780, 519214, 518793, 521206, 518789, 521757, 521202, 418746, 313041, 519837, 407353, 521200, 508976, 313038, 517618, 521305, 512186, 518787, 520928, 516506, 521376, 519228, 486869, 448789, 405333, 521374, 508003, 516496, 518785, 521112, 520974, 519212, 325978, 467606, 516485, 276234, 520971, 407350, 516483, 276227, 292794, 518970, 475859, 516481, 475855, 276225, 516475, 292789, 518967, 289640, 518519, 517046, 335212, 285213, 486721, 508001, 510944, 284959, 416339, 518551, 517961, 422370, 518515, 304357, 422368, 516637, 518529, 516635, 518302, 517958, 422365, 518382, 416337, 289628, 475804, 422363, 517792, 328176, 517494, 274473, 517577, 422361, 395202, 517188, 518128, 517040, 517593, 311024, 293454, 274471, 276216, 271850, 518125, 274468, 517777, 321311, 517929, 517492, 293452, 503750, 517925, 271848, 346674, 499445, 278822, 290598, 517700, 353320, 370105, 517610, 517573, 283698, 475795, 477414, 291848, 516626, 517488, 517037, 293450, 498849, 517035, 480276, 517486, 360481, 281145, 517462, 475792, 517286, 451980, 480274, 422358, 293448, 360476, 281143, 515023, 515021, 276944, 516188, 475786, 517185, 516930, 517033, 515019, 515018, 516880, 276942, 516868, 482202, 276940, 516348, 276210, 307975, 516338, 482685, 482681, 502024, 370103, 291846, 502020, 516770, 482677, 516610, 516560, 370101, 516576, 516646, 399816, 516615, 516709, 281117, 515603, 516063, 514831, 516132, 514829, 370099, 515788, 318123, 281086, 290590, 513547, 515548, 515598, 515540, 512413, 515593, 515221, 515011, 277839, 515006, 276199, 512411, 514033, 515219, 276197, 514763, 512409, 514391, 512184, 514372, 512182, 514023, 418124, 512178, 513853, 500419, 481180, 500417, 481177, 506128, 513741, 513811, 513544, 513261, 513629, 513621, 513215, 513540, 370095, 376709, 513258, 513254, 513213, 344413, 513252, 376707, 512662, 511682, 275625, 511680, 511678, 274463, 274461, 281072, 513112, 513118, 513016, 356512, 505691, 418122, 512687, 513000, 512403, 513039, 505688, 512492, 476508, 512433, 486837, 512401, 512638, 512714, 512429, 512490, 475715, 512354, 512424, 351807, 511929, 293443, 512439, 307968, 281063, 293440, 275620, 293439, 511123, 475713, 511971, 475710, 511906, 275612, 275610, 491323, 511886, 511671, 511668, 482199, 506118, 484718, 484715, 408456, 484713, 511509, 475707, 511257, 511496, 299941, 510938, 481156, 511253, 511248, 511246, 481153, 511351, 511297, 502019, 511243, 481151, 122087, 510936, 486907, 486904, 509697, 486901, 511150, 511061, 502017, 511069, 511060, 510985, 511066, 511085, 291834, 511056, 510914, 510982, 502015, 486895, 510980, 510930, 486890, 502009, 510918, 502004, 510866, 276184, 289620, 510858, 364324, 276182, 489259, 510721, 510574, 313034, 291833, 475696, 302545, 508967, 489257, 302542, 302539, 510552, 500193, 500187, 302536, 364319, 510550, 510538, 481145, 283957, 509417, 276938, 510471, 364316, 508997, 276928, 356509, 509667, 509781, 477386, 509665, 286971, 510139, 477384, 505323, 509992, 447943, 477379, 508868, 292778, 477375, 509267, 292775, 293428, 510006, 509904, 508990, 509931, 475682, 286966, 508985, 509744, 292771, 509264, 509657, 509027, 509129, 509250, 509444, 509589, 508866, 508743, 352403, 277096, 508479, 508305, 508302, 477358, 278710, 506544, 454768, 474431, 508229, 475659, 454766, 486719, 337347, 486716, 336565, 289155, 508104, 475654, 500777, 504887, 503173, 507975, 465160, 507964, 498570, 291830, 508058, 274190, 505917, 465158, 465156, 288370, 507763, 507356, 291825, 454763, 507637, 507649, 507351, 506977, 506972, 507348, 475646, 477343, 475644, 507346, 505660, 505783, 506541, 507229, 506526, 506524, 506701, 505904, 506801, 506755, 506751, 284719, 506626, 506697, 505900, 506358, 284717, 274055, 503220, 486728, 486714, 506520, 505652, 505631, 486191, 505628, 150232, 506110, 454757, 486188, 506002, 454746, 505960, 505773, 454738, 475629, 502106, 505792, 505451, 477308, 505771, 505591, 454735, 505744, 505322, 454730, 505318, 504577, 334100, 505300, 281034, 454727, 505316, 505326, 504860, 504535, 284839, 486712, 284837, 503365, 484282, 343748, 503320, 503227, 343746, 274053, 274051, 503336, 495735, 503310, 281017, 281015, 274050, 271814, 503225, 499293, 281012, 274047, 482193, 503266, 499291, 281010, 503218, 503248, 503167, 503003, 289148, 503164, 312834, 500541, 503157, 503130, 503214, 289142, 290582, 467588, 326227, 501379, 490859, 294361, 502831, 481138, 500714, 501487, 501858, 501996, 501992, 501990, 481116, 502064, 286422, 464797, 286419, 286413, 481112, 481110, 500172, 286411, 481108, 501890, 501592, 501856, 501645, 326190, 290570, 285195, 410358, 501582, 501614, 501606, 422992, 339797, 410355, 285191, 500031, 339793, 410353, 500947, 422989, 501352, 339791, 326185, 500711, 481076, 357466, 501460, 357463, 422985, 501299, 500166, 499016, 36983, 501243, 501240, 291821, 501209, 501033, 501218, 291819, 405321, 486815, 363494, 500959, 500553, 501012, 500976, 291817, 500707, 500832, 487079, 290567, 500701, 487077, 472208, 290565, 500732, 500158, 495481, 286407, 294355, 500044, 472206, 472204, 276925, 500407, 500393, 498693, 500225, 500041, 464793, 498691, 497965, 495705, 495703, 283177, 500209, 499231, 500060, 500121, 294352, 294350, 487186, 500014, 474365, 487184, 294348, 454717, 497554, 499867, 474361, 490850, 499721, 290861, 487179, 497551, 313191, 276921, 493958, 499676, 284321, 276919, 284318, 497548, 493956, 481060, 499439, 497543, 493954, 493952, 499286, 275598, 499515, 329736, 495167, 498081, 481058, 499435, 498767, 498765, 292452, 498976, 463295, 292450, 498763, 498942, 498760, 498742, 286089, 275592, 321511, 286086, 497464, 498240, 321509, 275589, 286082, 497880, 486808, 497861, 497860, 486806, 475496, 497634, 338280, 497471, 284716, 496600, 496721, 491909, 491907, 491905, 374110, 497327, 496714, 496522, 293386, 293384, 496519, 293382, 496709, 496517, 496626, 454712, 360357, 481045, 495471, 496506, 496503, 496509, 496500, 496486, 493047, 496488, 496211, 496199, 496122, 289136, 289134, 496119, 495692, 482191, 495671, 289132, 307965, 289604, 289602, 495502, 491901, 276914, 276912, 495023, 457882, 276910, 486549, 486546, 495142, 492979, 286923, 465091, 474997, 486544, 302532, 286919, 294344, 420759, 289598, 494543, 493951, 301467, 486541, 279328, 399732, 279326, 311020, 491682, 494252, 494250, 493948, 456711, 494298, 276169, 456708, 494316, 494331, 494248, 490809, 276160, 335205, 335199, 311013, 289595, 493842, 493946, 311011, 289591, 335198, 493943, 490802, 360355, 493940, 311001, 493937, 307964, 493777, 289587, 490799, 289581, 307963, 493708, 310992, 289577, 493234, 310984, 490259, 310979, 486725, 492184, 492652, 490257, 493230, 310968, 286397, 492863, 492858, 492855, 492842, 492966, 352591, 491650, 293362, 289566, 275582, 492673, 492579, 487150, 299922, 289563, 481042, 274456, 299919, 492355, 492348, 492155, 492217, 302843, 293358, 492265, 492169, 492153, 300215, 491932, 491928, 491606, 491675, 463120, 491595, 289558, 480747, 466899, 491672, 408920, 491604, 491586, 335196, 286913, 487439, 283923, 491374, 491307, 294342, 486774, 462447, 491305, 490524, 351377, 489252, 462440, 491241, 351375, 490939, 490937, 392037, 490934, 490932, 286050, 490429, 274184, 289125, 285361, 286048, 490875, 280981, 490827, 490496, 490837, 490554, 489555, 490822, 490750, 490794, 490791, 490522, 490493, 395188, 490518, 283920, 487169, 490514, 489249, 487167, 490487, 490298, 490271, 490199, 489887, 275579, 289114, 490013, 490026, 275577, 293333, 275575, 489613, 296852, 289112, 275570, 482185, 486072, 458050, 296850, 310956, 489611, 289831, 285178, 489549, 296848, 489481, 289109, 489170, 289105, 299916, 293327, 310949, 296846, 488477, 310947, 489168, 488860, 452844, 488858, 452842, 488856, 293321, 488853, 487691, 280973, 488315, 289103, 487350, 487348, 487432, 487390, 375546, 286891, 482303, 286889, 487548, 378867, 486537, 375541, 352341, 286887, 291815, 378866, 291813, 378865, 400282, 484761, 484944, 293308, 486887, 291808, 340778, 486747, 482370, 291806, 486486, 486885, 486482, 486428, 291804, 395181, 486426, 274045, 454711, 454708, 291802, 486423, 486390, 486382, 290551, 294337, 408172, 486324, 291800, 486021, 467586, 406871, 293297, 484170, 293295, 293293, 484531, 484753, 360971, 406867, 293290, 291798, 279303, 480745, 484867, 484747, 274445, 279301, 403403, 291796, 291794, 484523, 484517, 467581, 292436, 484357, 484511, 484263, 484359, 484366, 484462, 280962, 274163, 315097, 279292, 484018, 291163, 315093, 483580, 483542, 483574, 483570, 483538, 319726, 483537, 384846, 483995, 483568, 484013, 329719, 483736, 483712, 280956, 395161, 483450, 329717, 480733, 329713, 274441, 329711, 483562, 483531, 360969, 483560, 290546, 290849, 479970, 275346, 276891, 483509, 276889, 290544, 483431, 479910, 483226, 483199, 483160, 483197, 286880, 483183, 483192, 457874, 483157, 360965, 307146, 483153, 483148, 483173, 483086, 342195, 307144, 483097, 483084, 313017, 483102, 342193, 483080, 342189, 420749, 366546, 342181, 276153, 316512, 482889, 301900, 392031, 482775, 482859, 482766, 481013, 278697, 482547, 482454, 481330, 480036, 392029, 316508, 341162, 480033, 481006, 275340, 482361, 278688, 301898, 482350, 479622, 275338, 294860, 301895, 274021, 482183, 481004, 482219, 480964, 274019, 481002, 278671, 481952, 480997, 481480, 329705, 280946, 480995, 481923, 480727, 480726, 480716, 352335, 469553, 400339, 480514, 475484, 352333, 480714, 480459, 480712, 352328, 352323, 350457, 384834, 480638, 283902, 352321, 384832, 381387, 480369, 276149, 278663, 276145, 480360, 286875, 278661, 315354, 315301, 289085, 480332, 480286, 480072, 289080, 315084, 480155, 480145, 315082, 480069, 480066, 459486, 286352, 289077, 479732, 296844, 296841, 454704, 289073, 480025, 479730, 352315, 289068, 274756, 289550, 381382, 479935, 479865, 479727, 365950, 479900, 479983, 479407, 479314, 478232, 286861, 452828, 286859, 395151, 479129, 470110, 478030, 477909, 278640, 478210, 326168, 477903, 286850, 459466, 477742, 337620, 459463, 302803, 472361, 286843, 275565, 292734, 278635, 477118, 276143, 477068, 329701, 338273, 477035, 477083, 476982, 477032, 477027, 294475, 476976, 473309, 475228, 300198, 476592, 476925, 459462, 476526, 476556, 476494, 283634, 275556, 476523, 476520, 476518, 283632, 476516, 384427, 280929, 467569, 292725, 275550, 420747, 275547, 467566, 316645, 276141, 418384, 475479, 276134, 356710, 307142, 310929, 291159, 450256, 475420, 337338, 337334, 276130, 461190, 276128, 326160, 474417, 283622, 293203, 279242, 451895, 474603, 474601, 454577, 276125, 342839, 291381, 454575, 342834, 342832, 467563, 326158, 467561, 474410, 473797, 295706, 335195, 474429, 456698, 474405, 335193, 361771, 474355, 288571, 395144, 473792, 465193, 459537, 465191, 335191, 291791, 400483, 288567, 465189, 459535, 473790, 294334, 462635, 459530, 400481, 291789, 294331, 470221, 473303, 291784, 326156, 355373, 473300, 395142, 420746, 283613, 286341, 473262, 459485, 472938, 472664, 451862, 305963, 472930, 421468, 472923, 473143, 293186, 283607, 472916, 283605, 275544, 473071, 473062, 473141, 355371, 280919, 469674, 473022, 473029, 473117, 290832, 472906, 472892, 472836, 473114, 469669, 473111, 472889, 473109, 473107, 472887, 473104, 286840, 472829, 286835, 469667, 286832, 421465, 473100, 472631, 286829, 472735, 472627, 286824, 472624, 354981, 275301, 416330, 355364, 294850, 418118, 472657, 384988, 384986, 291782, 472405, 472620, 316489, 355361, 384983, 472408, 472393, 418115, 316486, 458044, 355358, 384975, 352298, 275300, 316484, 275298, 472258, 326155, 334092, 326153, 472195, 462628, 470444, 471694, 470437, 469611, 469661, 470209, 468613, 471645, 471748, 315426, 316479, 471765, 416324, 416321, 471433, 468746, 471690, 470884, 276116, 418113, 470985, 470728, 276113, 470982, 470725, 470765, 315422, 286807, 276110, 418110, 291776, 470930, 418104, 291773, 466784, 466340, 462165, 466753, 275267, 293626, 306964, 300443, 466273, 452803, 300441, 304792, 276104, 454669, 465709, 465979, 465975, 451627, 465653, 280861, 291150, 307139, 341161, 280857, 280856, 459482, 354953, 360963, 291148, 465650, 465645, 280853, 459428, 463256, 454657, 360961, 413914, 420743, 459421, 275537, 360959, 360957, 278811, 459480, 465268, 465265, 464953, 395068, 465176, 465146, 278808, 293621, 465166, 465263, 463344, 465336, 465350, 276097, 370090, 278623, 461175, 276092, 336621, 299912, 370088, 464918, 464967, 463208, 299910, 278620, 464851, 464277, 291379, 464717, 394958, 461784, 464448, 463929, 464275, 464210, 461782, 464443, 464676, 458570, 462937, 276089, 458567, 463281, 289056, 463337, 463149, 463112, 463254, 278618, 459528, 462622, 455209, 319363, 411187, 463091, 278616, 459526, 463098, 461401, 463096, 278614, 462947, 463088, 462482, 462785, 454573, 459524, 462620, 365947, 455206, 462945, 352275, 291761, 462439, 411185, 462488, 462342, 454570, 391465, 300434, 335190, 462338, 279223, 415670, 461389, 458611, 461160, 461398, 461309, 411182, 280842, 461307, 461394, 458608, 459516, 283879, 415666, 454654, 461622, 461779, 461155, 459391, 329674, 285992, 461429, 459386, 459380, 461131, 365939, 279219, 329670, 461058, 459478, 280834, 460631, 460638, 411169, 453903, 293100, 460543, 460595, 460627, 460648, 460702, 315352, 296658, 460145, 420739, 296653, 460485, 337645, 411166, 290538, 284288, 290813, 460495, 460526, 290536, 290809, 410814, 302761, 284279, 459513, 460089, 460182, 460001, 411157, 296482, 337643, 453261, 290534, 284277, 460178, 459997, 459474, 459362, 283875, 459805, 460018, 460126, 460076, 326146, 313186, 459251, 459042, 410812, 459302, 410809, 304785, 459258, 459034, 313184, 459176, 459057, 459225, 459032, 459019, 417371, 459053, 290807, 458968, 419113, 417369, 290805, 419111, 280822, 352270, 329668, 416317, 458808, 458815, 419109, 458188, 280819, 300407, 458560, 352266, 275848, 458557, 352262, 290801, 300403, 329664, 458326, 419107, 276084, 458043, 457819, 458040, 458009, 276081, 458003, 329658, 276079, 458001, 457824, 280813, 280812, 315074, 310895, 310894, 276077, 457530, 457708, 452789, 300397, 310888, 457036, 300391, 456942, 452782, 456966, 456931, 294317, 419104, 296836, 310886, 294315, 456217, 456592, 406213, 456215, 419102, 310885, 456693, 456320, 419100, 391460, 456590, 335181, 456689, 450687, 454935, 455640, 456388, 456212, 451848, 335176, 310883, 456586, 456453, 454652, 404228, 395035, 360438, 454566, 415656, 453028, 452114, 454557, 455539, 452778, 454552, 454549, 454281, 328767, 452776, 414950, 349833, 305903, 454387, 315299, 449384, 283595, 280774, 449381, 454278, 416315, 278609, 376292, 452547, 451621, 453257, 295859, 285618, 419135, 419084, 417037, 417033, 330969, 418315, 407227, 418827, 418096, 382524, 457852, 291131, 417505, 407222, 418089, 418144, 416999, 417498, 302736, 291127, 417028, 417483, 291118, 319546, 417615, 330965, 416997, 417474, 417363, 290752, 410478, 291116, 415981, 319541, 416961, 276788, 290630, 417295, 416994, 330962, 414926, 417021, 280712, 415979, 319535, 289547, 290628, 416958, 417058, 298523, 277071, 290626, 290624, 417012, 416992, 290622, 414924, 412754, 413515, 416990, 302529, 289541, 400335, 414919, 416775, 400473, 412748, 412746, 414917, 352244, 352238, 414911, 410472, 410470, 416482, 416480, 286758, 410468, 286756, 415647, 298521, 410466, 298519, 290749, 410464, 414905, 352228, 415904, 352227, 410462, 290745, 415643, 410460, 415641, 415596, 286753, 286751, 285124, 410458, 286746, 410454, 414893, 410452, 408402, 413004, 412800, 285118, 276055, 276053, 276051, 411377, 412997, 344733, 375534, 276049, 276774, 412995, 276772, 276046, 412764, 275197, 344731, 276042, 276770, 275815, 412880, 344729, 388465, 276040, 300370, 276767, 300368, 278593, 412681, 411369, 276765, 274400, 410805, 280700, 276762, 289464, 352223, 276757, 410905, 410801, 447861, 411148, 447858, 411146, 410795, 411005, 410791, 411003, 410789, 275192, 410786, 408707, 410784, 410782, 410129, 410127, 335166, 289459, 276750, 289457, 411001, 276748, 410449, 289452, 276746, 410447, 289031, 289449, 410901, 280693, 275188, 284954, 289447, 280690, 410894, 335162, 280687, 276033, 289443, 335160, 276031, 335158, 280685, 410123, 410121, 335156, 410112, 391436, 410609, 316425, 289030, 410445, 343228, 410333, 410443, 410182, 410106, 316417, 410441, 289028, 410524, 410100, 276744, 411354, 410187, 343223, 410210, 410178, 276742, 410094, 289023, 286742, 286740, 289020, 286738, 389855, 276740, 275184, 321568, 409481, 289018, 321567, 321565, 286734, 293596, 350443, 293594, 289412, 286731, 286730, 278552, 289409, 286726, 278550, 289010, 289407, 409472, 350439, 289403, 409467, 278547, 289401, 342953, 289397, 289396, 289008, 289391, 289006, 290487, 290484, 408695, 408693, 304508, 408910, 406661, 286719, 290481, 284951, 289003, 284948, 284945, 289001, 284943, 278801, 290470, 408469, 408235, 408164, 286712, 296625, 289354, 407524, 407521, 289350, 278796, 407375, 407756, 403215, 401529, 276024, 401525, 407754, 407373, 407342, 294471, 401523, 290467, 336544, 294469, 296623, 294466, 407082, 407219, 290464, 406210, 407017, 407215, 288987, 401510, 407080, 406207, 406205, 288983, 316397, 401508, 293592, 406201, 391548, 276022, 360193, 307947, 288979, 293590, 406200, 326134, 288976, 276020, 284940, 307137, 406195, 307134, 406192, 284938, 381361, 381360, 288973))
Run Time: 0.068597
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3386 | |
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 | | | | | 3386 | |
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 (29668, 29366, 29175, 29174, 28939, 28738, 28467, 28361, 28155, 27616, 27502, 27454, 27449, 27447, 27446, 27444, 27442, 27438, 27251, 27245, 26937, 26644, 26173, 25653, 25638, 25428, 25001, 24613, 24386, 24385, 24384, 24375, 24218, 24144, 24120, 24023, 23507, 22924, 22696, 22695, 22567, 21481, 21419, 21377, 21038, 21021, 21060, 20761, 20706, 20688))
Run Time: 0.001966
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 50 | 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, uf
Run Time: 0.000207
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.000411
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 215
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (120))
Run Time: 0.000512
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1716171187
Run Time: 0.000657
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 19 | 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` >= 1716171187)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000461
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 19 | 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