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.000800
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.000261
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` = '5787')
LIMIT 1
Run Time: 0.000458
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.002365
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_5787' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.116909
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 (641254, 637506, 638011, 637111, 637116, 601331, 607118, 445236, 601329, 366060, 538713, 550949, 16660, 16658, 23024, 588985, 462263, 93459, 587546, 587230, 539956, 3103, 503828, 343757, 270288, 85318, 270286, 503818, 8113, 503814, 390311, 528535, 528533, 282603, 569225, 567815, 567651, 567813, 517092, 559186, 567702, 567552, 282481, 567721, 282480, 567696, 567692, 298672, 567660, 298670, 326339, 567641, 567637, 298668, 490726, 567581, 559180, 361774, 567548, 282479, 567542, 559175, 559172, 559167, 567508, 308078, 395282, 567476, 567474, 567506, 567459, 567447, 567446, 298663, 488059, 567380, 567204, 377350, 565962, 567366, 567148, 564645, 337353, 343752, 160271, 527141, 520934, 337351, 527139, 527994, 567259, 567093, 520932, 160269, 304618, 567138, 567091, 567137, 567135, 559155, 567132, 567130, 253821, 291895, 567089, 329786, 481305, 564640, 557871, 481303, 566746, 566745, 291893, 329779, 329775, 566934, 565957, 566179, 566917, 282438, 566583, 566951, 566851, 566944, 282434, 282433, 293563, 282429, 566804, 282427, 566581, 282419, 566579, 566577, 566403, 564774, 564772, 566399, 564770, 564635, 566437, 566389, 566381, 566380, 566379, 566356, 284148, 316274, 298658, 566058, 566055, 565948, 566249, 546382, 565593, 510952, 565590, 560131, 561638, 565583, 483849, 565579, 510948, 565575, 566131, 550038, 565812, 412344, 565942, 483846, 282393, 483844, 546666, 23016, 503802, 565636, 546115, 565567, 565505, 565634, 564403, 563871, 494313, 546110, 565409, 546108, 550762, 565267, 476129, 565265, 476126, 565263, 564892, 476124, 565262, 564767, 565261, 565259, 564765, 565258, 565272, 565173, 565269, 341166, 565167, 565125, 564763, 565256, 564882, 565015, 564880, 564970, 564979, 564758, 564874, 540894, 564670, 564788, 564677, 564783, 564756, 522034, 564422, 564439, 564181, 564420, 564390, 564388, 564384, 564255, 555249, 564376, 564374, 564372, 564178, 282365, 564176, 557862, 476106, 564292, 282364, 563275, 282362, 452963, 316630, 527993, 564174, 557854, 564233, 319118, 561449, 564069, 563627, 307153, 520822, 560445, 561447, 564141, 561442, 563625, 558223, 483830, 564026, 564031, 564029, 563822, 563970, 555316, 563968, 513605, 489677, 462872, 483829, 497314, 513604, 513601, 497304, 282355, 497301, 563868, 563866, 563774, 538183, 282353, 512614, 563009, 563236, 556999, 284144, 563615, 563233, 501734, 563449, 563223, 563167, 540879, 563318, 563152, 563271, 562542, 563295, 294375, 294373, 563150, 563270, 294371, 489671, 562992, 562969, 562918, 562963, 282330, 562954, 562937, 561222, 489656, 490714, 489654, 562618, 559373, 562881, 502401, 562879, 292842, 540853, 559371, 459545, 562318, 282325, 506257, 540846, 282323, 540842, 513600, 540839, 282322, 556030, 562762, 540837, 282320, 556188, 562539, 562698, 562660, 562736, 489646, 282317, 562655, 489643, 562693, 282314, 560037, 371314, 562645, 509383, 513599, 546380, 489894, 562635, 505156, 562422, 562586, 546664, 522030, 555292, 487777, 298652, 562527, 561221, 546378, 282312, 308062, 522027, 562435, 522025, 36998, 562341, 351037, 544183, 562361, 550463, 562263, 550455, 562258, 517884, 489626, 282302, 489624, 491246, 308061, 282300, 308059, 489623, 489620, 282299, 556460, 326329, 544180, 396750, 489615, 549243, 510765, 513598, 562145, 562134, 282294, 562047, 326327, 561648, 562132, 326325, 561219, 561646, 561890, 561820, 561979, 561991, 561975, 561988, 528195, 522020, 561878, 561831, 561817, 522017, 561827, 561824, 556942, 498649, 522014, 561815, 561806, 522012, 300538, 559628, 282286, 513596, 561775, 289652, 503795, 559368, 561801, 561594, 275414, 538166, 561592, 282284, 561598, 561587, 538151, 561428, 561083, 561412, 561043, 560986, 561280, 510946, 559605, 538311, 561072, 549241, 561129, 559852, 513595, 561067, 561039, 507065, 561109, 560093, 561064, 282279, 549239, 497290, 560285, 560993, 560982, 282278, 308056, 282277, 512612, 512610, 282269, 293538, 546478, 547528, 555165, 292826, 500821, 544486, 560797, 560492, 560490, 275405, 398344, 560459, 560452, 560487, 275402, 544480, 560315, 544478, 291890, 560290, 521290, 559276, 544475, 275400, 282225, 282214, 282203, 282201, 559807, 282199, 282195, 560003, 544462, 559977, 560010, 559975, 546376, 282174, 282172, 559886, 559827, 282168, 274489, 284124, 325419, 308051, 275396, 556997, 559803, 282162, 512609, 559693, 282156, 557298, 282153, 545384, 282151, 556995, 559486, 556993, 547082, 559475, 520195, 541012, 478889, 559363, 282146, 559356, 282141, 557401, 377489, 559343, 558246, 513594, 546475, 559119, 282135, 293531, 540825, 546471, 23013, 314010, 548149, 558978, 275652, 558195, 557397, 314008, 558974, 557741, 557790, 556186, 275643, 546372, 558970, 556448, 546370, 558177, 556183, 507537, 556901, 558904, 558389, 555903, 558081, 282132, 556888, 556884, 558622, 540823, 282130, 282128, 558620, 546462, 282126, 556882, 556879, 558603, 558609, 500811, 293521, 558565, 509518, 546652, 282123, 556991, 557100, 557109, 556444, 558398, 558078, 558165, 558141, 544460, 308048, 544458, 544551, 431360, 558108, 557156, 557811, 544456, 557107, 282114, 557044, 517090, 544454, 515619, 282113, 556717, 556990, 557797, 557777, 556715, 486241, 545352, 543688, 344901, 555240, 556595, 556583, 556620, 556611, 540995, 544548, 556604, 556600, 540993, 556564, 556533, 337075, 540989, 556474, 540818, 556410, 545349, 548445, 391488, 556370, 545347, 556363, 555826, 556351, 540985, 540982, 517080, 556294, 555823, 556254, 555788, 556169, 544432, 556027, 555816, 555590, 556104, 555778, 556086, 282096, 555813, 544430, 545340, 555671, 555776, 555974, 409334, 492406, 282094, 282092, 555809, 555665, 555766, 555741, 555761, 555759, 555914, 555805, 555757, 555754, 555751, 555724, 555734, 555340, 544543, 555238, 282090, 555659, 282088, 555651, 540814, 555442, 282085, 555440, 522505, 462871, 555438, 540733, 555556, 555436, 545332, 451989, 545329, 545327, 545325, 555333, 555529, 487767, 540812, 540810, 555227, 555464, 545322, 523753, 555481, 555431, 555462, 462868, 555427, 555460, 555326, 555421, 555315, 555419, 504735, 490701, 555392, 490699, 319566, 492397, 555390, 555131, 491328, 490697, 490695, 555321, 555313, 490691, 555289, 523744, 552307, 555189, 315129, 282081, 523741, 504733, 315128, 282079, 278753, 315125, 555185, 555215, 544426, 546368, 315124, 300243, 546453, 492391, 555184, 504725, 555123, 512812, 282078, 342021, 550883, 554819, 497247, 497245, 528528, 459495, 545718, 552628, 497847, 546366, 160738, 160736, 552838, 550882, 462846, 552625, 522010, 550881, 522008, 550879, 552647, 370115, 552471, 552832, 552830, 552797, 451988, 550878, 550064, 552618, 552468, 299961, 552643, 552616, 552640, 552636, 552463, 540798, 552622, 337071, 552614, 480967, 552454, 552452, 552574, 546364, 452942, 544540, 282073, 552446, 498679, 551704, 291877, 546441, 552350, 282066, 552344, 282064, 513192, 552242, 550875, 549234, 552234, 282062, 282060, 552090, 459492, 550874, 293517, 552149, 552144, 552141, 517079, 552139, 552083, 344900, 546361, 282055, 551983, 551982, 551993, 551991, 543720, 522005, 546358, 543718, 510763, 545717, 546353, 551187, 473167, 551972, 282053, 551970, 551185, 517074, 473163, 301546, 551183, 122094, 473162, 507751, 551181, 507749, 551544, 517072, 551739, 551179, 452932, 550873, 550450, 473161, 551543, 551542, 551698, 551713, 551708, 548292, 544423, 551695, 551541, 551585, 551632, 551672, 452927, 551581, 551538, 551536, 507747, 282050, 551506, 551490, 551487, 480575, 512479, 451986, 551354, 551351, 551222, 549230, 538310, 546651, 551364, 551361, 551214, 551343, 150239, 550505, 551208, 551206, 512472, 291870, 291868, 545026, 551286, 203066, 550834, 551285, 291866, 492389, 481275, 150237, 39179, 492386, 481270, 551199, 497243, 550936, 551272, 551177, 481268, 546352, 551229, 551197, 550870, 39172, 356912, 551063, 550441, 550439, 510762, 507499, 282044, 550735, 512608, 282042, 550434, 550431, 492380, 551055, 551008, 502312, 502310, 550426, 550865, 452920, 39167, 356910, 452918, 282040, 452916, 487322, 452914, 546349, 550862, 550827, 546345, 550825, 476083, 550923, 550920, 492378, 477592, 501131, 276987, 550731, 550733, 492376, 550413, 550729, 550818, 550728, 550727, 546342, 39156, 550756, 550402, 550725, 282029, 549779, 550397, 282021, 550573, 550571, 510760, 430491, 430487, 39150, 513593, 550569, 510758, 550525, 282018, 308042, 521286, 550502, 9615, 521133, 550524, 282015, 550520, 550381, 282012, 550567, 39148, 282009, 315117, 550142, 484677, 550368, 550366, 548762, 484674, 282008, 540607, 550148, 546338, 282005, 550133, 413652, 545777, 546336, 276983, 276981, 276979, 546332, 276975, 546329, 407281, 540795, 546325, 282001, 540793, 521279, 521276, 281998, 546321, 281996, 546319, 410379, 546314, 549221, 410377, 550021, 549219, 281993, 516669, 550010, 381982, 513199, 546311, 505952, 540789, 509359, 281989, 506254, 549216, 316268, 513592, 549213, 536875, 540787, 549211, 549894, 287080, 545015, 549209, 506250, 546309, 549855, 549205, 279347, 509357, 549200, 521262, 513026, 546301, 548745, 549816, 549813, 549809, 370287, 536871, 275730, 520807, 275637, 483790, 281987, 549193, 548457, 549263, 549191, 301506, 549188, 549186, 476078, 496055, 549183, 326306, 547242, 467205, 509978, 547239, 545776, 547525, 509355, 548733, 548670, 546293, 421273, 507054, 548464, 407370, 546284, 412200, 546281, 412198, 546278, 281976, 506249, 540784, 15131, 546275, 540782, 548438, 501004, 546271, 508010, 517711, 546267, 546265, 546263, 546261, 546257, 546254, 540779, 293721, 546244, 540777, 281975, 548290, 308039, 293718, 511516, 548142, 540775, 15128, 547862, 547858, 492365, 546238, 281969, 547030, 384511, 547887, 384510, 486233, 547843, 511514, 384507, 498279, 546235, 384506, 500660, 546230, 547672, 540771, 281955, 547522, 547519, 547517, 547514, 547512, 547459, 518592, 287075, 547457, 547455, 546227, 513591, 509509, 271511, 502301, 518589, 547283, 518584, 547281, 502299, 476071, 528193, 275728, 515059, 545767, 515057, 547233, 547203, 502297, 278835, 520805, 547091, 547026, 520803, 546508, 537404, 537402, 547017, 520799, 546502, 547013, 508414, 546134, 508412, 508411, 546897, 546895, 546919, 546649, 476065, 546224, 545292, 546904, 546888, 546647, 546493, 542002, 546492, 546491, 546222, 523957, 546002, 546220, 502518, 545745, 502516, 546218, 546530, 546534, 502514, 546213, 546211, 540766, 452908, 476061, 476059, 293513, 546000, 545996, 452904, 189788, 506248, 353360, 452897, 452895, 344899, 344897, 546132, 502053, 546105, 283211, 546009, 516668, 546130, 281926, 546102, 545858, 528524, 274480, 8106, 275634, 8104, 195, 406072, 545856, 469622, 499141, 545854, 523104, 545849, 499139, 545846, 502043, 545803, 545800, 281922, 545798, 502040, 545716, 545811, 545787, 276299, 545771, 545750, 545708, 509503, 545687, 545638, 545650, 545648, 454395, 545636, 545685, 545706, 540966, 497215, 545659, 545656, 545646, 545654, 545633, 545631, 544938, 545541, 545493, 517182, 545430, 509678, 509676, 509497, 509674, 540959, 545432, 545435, 545426, 541995, 545424, 545412, 537386, 545010, 523098, 545318, 545288, 545312, 13453, 545308, 517709, 545283, 545298, 540761, 528189, 284082, 284080, 545196, 496337, 545174, 497210, 293508, 545240, 275387, 496037, 544962, 544926, 544959, 544955, 510757, 544841, 395338, 487713, 454344, 544784, 541879, 308031, 544828, 544826, 544821, 512200, 513589, 497190, 517706, 275633, 517704, 544782, 513586, 281912, 528184, 544778, 543670, 281907, 281900, 541579, 544314, 541796, 281897, 541792, 512607, 544332, 407369, 407367, 407365, 275631, 370114, 279342, 407279, 501388, 507460, 544566, 535206, 501384, 544564, 544532, 544525, 407363, 508516, 407361, 281891, 285397, 477564, 544512, 540758, 275727, 523955, 13450, 527991, 508008, 271893, 477559, 281889, 474218, 281887, 281885, 544400, 544405, 408460, 521256, 308030, 281883, 293506, 503774, 293504, 537080, 281877, 516666, 484658, 484657, 538307, 502513, 542371, 544295, 513023, 516542, 408459, 484655, 542057, 516540, 497638, 408457, 537077, 514312, 535199, 542973, 543750, 284075, 542927, 160266, 473591, 429673, 499132, 540320, 542972, 160264, 284333, 518322, 497590, 281865, 540942, 543341, 542919, 542912, 542365, 541612, 542343, 542361, 281864, 281860, 281845, 540315, 281843, 497163, 497584, 461322, 499346, 539171, 540078, 281824, 520876, 540214, 517060, 484638, 281820, 415016, 415008, 281819, 539825, 507430, 415004, 538306, 15123, 15121, 539349, 505341, 509473, 281816, 476048, 536649, 536647, 539220, 275379, 539196, 539176, 498869, 492364, 539139, 476045, 518521, 539126, 537821, 537819, 537817, 537910, 537814, 539045, 538999, 539054, 517869, 281806, 539028, 538997, 538995, 538506, 281799, 339356, 484603, 538872, 484601, 482211, 538879, 538719, 538717, 538503, 506235, 538671, 535501, 538667, 538669, 317652, 512195, 537398, 538578, 537750, 538498, 293500, 329760, 538341, 537596, 281794, 335215, 538267, 536644, 538129, 537889, 537527, 537739, 537887, 538066, 319733, 276275, 319731, 537388, 537364, 505935, 537343, 298639, 476021, 476018, 85129, 523952, 536975, 536903, 15119, 536901, 475986, 348093, 534968, 536708, 478882, 535495, 475980, 536629, 515051, 472244, 496295, 536627, 536623, 535487, 279578, 535751, 462454, 281747, 475976, 519075, 519072, 475974, 528183, 535658, 519070, 535461, 535088, 488569, 528027, 535545, 535082, 535080, 535543, 281736, 288581, 516887, 535459, 535457, 516885, 521312, 535469, 281733, 535466, 535060, 535058, 535056, 535053, 535049, 535045, 523718, 535041, 501119, 535266, 517824, 281729, 535242, 462452, 535028, 507428, 275367, 308008, 462450, 535180, 535170, 535015, 535168, 535166, 535164, 528555, 535144, 535004, 281722, 535000, 523949, 534998, 328780, 496007, 523503, 496004, 281719, 523501, 496002, 496000, 281717, 535117, 475963, 281715, 534965, 517820, 499117, 517816, 500656, 535107, 534958, 528502, 534990, 150234, 513278, 505077, 505075, 281688, 528479, 528506, 281683, 528477, 281680, 308004, 281678, 507422, 507420, 290655, 527211, 527209, 528463, 528453, 281658, 281656, 528451, 481235, 528381, 523478, 523476, 281654, 523474, 298629, 528389, 523472, 298627, 528378, 298625, 495988, 486882, 486879, 495986, 486877, 495984, 290653, 500511, 475960, 516660, 495982, 528136, 500506, 528180, 281645, 512601, 528176, 528199, 407360, 475956, 281638, 528079, 475952, 528077, 475949, 528075, 381402, 462449, 495974, 381400, 8101, 281622, 281615, 527990, 527987, 281609, 527981, 527467, 517175, 298623, 272989, 281592, 527303, 477523, 527295, 527289, 495958, 506225, 508006, 523266, 509316, 527175, 510494, 527133, 510488, 527145, 281571, 281563, 495940, 287017, 281560, 526658, 527044, 526656, 527009, 475934, 281549, 281547, 526953, 281544, 308001, 526968, 520190, 526964, 497136, 289844, 526959, 526961, 526957, 475931, 284053, 281540, 281538, 526916, 512600, 516382, 526865, 526868, 526842, 304373, 523924, 475924, 526826, 526824, 304371, 281534, 526822, 289842, 516370, 475921, 523918, 281524, 523915, 353332, 512598, 275872, 523943, 304368, 506220, 526652, 477521, 523913, 360497, 516525, 520178, 503058, 486875, 523941, 526576, 298609, 486872, 281510, 467785, 523416, 298607, 281506, 281501, 337067, 464729, 295863, 521857, 472267, 509451, 295861, 472265, 281487, 472262, 509449, 523908, 523933, 523095, 523823, 523929, 281486, 293460, 522808, 523092, 281474, 523084, 523081, 513583, 523447, 523870, 307261, 281466, 523879, 523890, 523838, 523877, 281462, 523866, 281460, 523852, 523263, 517050, 523076, 472260, 523074, 520484, 316208, 316786, 523810, 523788, 523786, 523443, 523668, 523688, 523287, 477510, 477508, 281444, 281442, 523261, 523681, 523138, 494153, 523453, 523451, 523449, 523427, 475897, 281434, 276964, 281429, 523256, 281424, 281422, 523065, 342966, 465702, 488796, 490213, 281417, 281415, 523375, 281412, 523357, 272986, 523283, 495893, 276959, 523253, 31856, 523134, 523275, 428513, 523250, 491552, 428512, 281393, 276957, 513582, 477488, 522950, 477486, 281390, 523131, 281385, 519123, 523057, 495880, 495876, 475891, 495873, 523158, 475889, 475887, 495870, 523142, 281381, 506216, 475884, 475882, 523128, 495864, 281379, 523039, 522982, 475880, 522885, 475877, 475875, 475873, 475870, 522857, 475868, 506214, 522847, 281369, 521589, 286123, 513020, 520715, 511138, 462589, 507373, 522465, 522549, 522526, 281345, 522133, 522417, 522368, 522131, 475864, 281334, 281319, 281317, 486910, 508876, 522125, 281316, 522123, 286121, 281304, 522048, 281302, 521811, 290884, 506208, 520584, 521439, 520929, 521429, 281281, 307986, 521445, 520482, 307982, 281280, 281278, 281276, 281274, 521425, 497068, 516497, 307980, 497062, 521399, 521364, 521314, 521360, 521350, 519292, 521182, 521327, 521114, 519677, 519675, 281270, 281269, 519673, 521107, 281267, 521104, 276231, 407351, 281265, 307979, 519288, 521036, 498602, 520668, 520665, 497042, 517192, 520937, 520942, 407346, 520656, 520653, 337066, 467776, 281262, 506207, 497031, 520643, 520637, 519670, 520632, 519665, 497025, 281261, 513455, 520794, 516467, 520623, 520852, 276952, 520791, 520786, 520784, 510756, 520766, 516461, 505001, 504999, 506205, 520558, 516455, 477440, 477438, 516452, 520761, 497020, 477426, 519659, 506202, 520754, 520589, 519286, 520752, 520555, 520722, 510943, 520586, 520732, 520553, 520578, 152954, 75534, 520720, 284011, 520575, 284009, 520572, 520538, 482204, 316551, 284007, 520477, 284005, 520475, 275359, 284000, 520468, 275357, 520466, 519655, 520436, 520464, 520471, 506199, 520131, 520402, 510941, 519811, 284957, 520425, 506197, 513448, 520317, 520359, 513446, 408185, 520278, 281258, 520297, 516448, 520276, 520292, 520123, 516446, 520121, 520283, 513444, 520261, 489261, 281257, 520259, 281253, 281251, 281249, 281247, 520244, 520257, 519592, 520234, 408182, 311553, 407344, 344417, 519284, 516438, 487278, 520112, 520226, 344415, 519808, 286113, 316263, 291852, 283996, 283995, 283994, 307978, 518654, 518650, 519277, 283992, 518644, 281246, 519828, 518642, 519328, 519806, 519826, 283988, 305314, 305312, 487272, 497008, 286110, 353329, 506019, 497006, 519804, 475852, 513435, 519692, 519715, 519713, 519320, 519801, 475849, 283986, 283984, 418745, 518631, 283982, 506017, 462587, 519645, 325977, 475844, 519639, 506196, 519635, 475842, 511070, 409908, 519708, 311551, 286108, 518965, 289639, 486720, 519632, 276947, 518626, 326271, 506195, 286106, 281236, 281232, 344891, 475838, 513432, 475836, 519557, 519518, 475834, 518619, 519511, 475832, 513198, 513430, 512597, 285211, 519151, 519456, 475828, 519325, 286104, 288375, 326269, 497000, 516115, 519311, 499024, 512720, 496997, 496991, 496988, 519309, 518266, 519368, 517165, 496986, 519307, 286102, 518572, 459305, 519303, 507993, 416772, 519299, 518609, 416770, 519294, 518310, 519258, 503258, 517043, 507992, 519219, 508384, 517041, 508382, 427995, 519158, 316547, 519147, 519155, 519139, 510940, 519137, 281216, 335211, 281213, 281211, 335208, 281209, 516433, 427988, 281207, 281204, 519042, 519120, 519116, 475820, 281199, 516113, 481226, 509976, 481224, 475818, 278716, 517963, 518783, 518963, 475813, 516422, 518566, 353326, 509972, 481221, 518780, 516111, 509967, 481217, 475811, 475808, 518561, 504994, 516110, 512415, 518607, 517808, 518341, 518604, 281191, 518152, 456194, 509965, 509574, 518601, 508376, 307977, 289633, 512443, 508373, 518546, 509962, 517802, 516108, 475806, 518599, 509960, 518614, 518513, 518664, 518387, 508370, 518508, 518523, 518385, 518383, 516636, 508357, 516106, 344889, 517505, 289626, 518379, 281183, 281181, 274191, 289623, 475803, 506190, 281179, 518372, 518368, 518271, 517703, 518339, 518195, 416332, 328178, 517795, 422364, 518334, 518331, 518328, 518293, 517793, 370110, 517190, 482203, 512700, 518281, 518189, 281174, 517499, 518268, 451984, 518187, 422362, 481214, 517786, 422359, 481212, 518150, 518239, 518235, 281168, 517923, 517981, 518227, 518225, 518148, 327987, 281158, 517763, 517750, 475798, 517713, 517291, 517570, 281156, 517640, 281154, 416766, 281152, 281150, 515588, 517288, 515586, 517023, 517590, 516104, 281141, 516101, 451979, 506184, 516623, 516989, 481207, 516873, 484314, 484308, 467601, 516155, 475748, 399817, 516096, 516150, 427791, 513378, 516842, 516094, 482687, 481200, 516186, 516092, 500785, 307974, 516330, 500783, 500622, 516144, 482684, 516659, 482680, 516804, 353318, 516656, 502023, 481198, 496933, 515583, 291847, 516652, 516089, 512698, 281120, 516293, 516087, 516707, 516644, 516085, 516600, 516602, 281109, 285205, 399815, 483778, 512373, 376297, 281107, 513208, 281104, 276203, 515664, 516289, 515579, 291843, 285203, 276201, 516082, 515577, 515015, 281097, 506183, 281095, 516079, 516077, 515659, 513367, 515575, 318122, 307970, 515785, 290595, 515572, 281084, 290592, 328172, 506131, 513361, 515553, 515765, 285201, 514816, 619529, 515643, 515634, 514813, 290589, 515539, 515532, 514811, 514755, 396733, 513580, 475739, 515044, 515010, 515004, 510755, 512694, 515001, 515000, 515027, 513356, 496928, 479377, 475725, 276195, 514821, 514807, 466999, 475722, 514762, 514311, 514760, 490605, 289836, 495835, 514723, 483775, 396730, 495833, 514726, 513758, 499753, 512838, 514394, 512836, 514051, 351811, 513753, 514310, 514376, 514373, 500616, 500614, 513132, 481186, 500611, 514282, 514276, 513130, 514261, 510601, 513167, 514244, 514240, 514199, 513677, 281080, 513165, 513352, 514178, 513275, 514176, 477399, 514169, 511687, 513207, 514122, 513272, 486862, 513197, 513162, 514090, 334113, 334111, 513159, 513579, 466996, 513206, 513577, 513576, 489706, 514053, 511685, 513671, 514022, 334109, 514020, 513018, 512179, 513854, 513747, 376713, 514011, 513953, 466994, 512177, 499743, 334106, 499741, 511828, 319565, 513666, 513156, 486856, 513661, 513660, 513812, 513655, 513649, 506129, 513822, 513820, 513818, 513637, 484849, 513635, 189785, 492361, 513634, 512692, 513569, 513632, 316540, 513567, 513565, 513263, 513564, 513196, 513562, 509447, 513630, 513035, 510754, 512690, 316536, 513620, 513680, 511787, 508541, 316529, 467599, 513195, 507640, 316256, 512441, 513126, 513561, 513344, 370096, 467597, 513260, 376710, 376708, 513342, 285199, 307969, 467595, 513299, 469010, 370094, 344414, 513255, 344412, 344410, 495084, 512634, 513212, 469009, 512630, 513149, 513122, 481863, 472310, 513017, 274462, 513120, 513015, 513116, 281070, 486851, 513114, 513110, 512437, 512471, 512407, 513108, 512654, 513073, 512405, 356514, 476509, 384494, 513008, 510753, 409329, 512652, 513006, 513004, 384492, 356511, 512650, 513056, 486848, 384489, 512689, 513030, 512435, 512648, 513001, 512686, 513040, 281069, 467592, 486846, 486841, 281066, 512997, 512995, 486838, 512545, 476506, 476504, 497448, 381484, 512677, 512646, 290650, 427653, 290648, 475719, 462639, 512674, 512431, 512830, 512399, 427646, 475717, 304350, 512670, 512710, 512430, 512715, 486834, 512596, 381482, 512643, 512616, 512362, 512503, 323575, 512542, 304345, 512567, 506564, 512357, 512540, 512428, 366421, 512538, 512355, 512425, 304340, 509956, 304335, 477394, 512498, 481170, 466993, 512466, 512396, 466991, 481166, 481161, 512462, 481159, 512488, 466990, 512352, 512458, 466988, 512393, 496904, 507978, 506180, 512447, 351804, 511130, 512445, 512422, 512336, 506123, 506121, 512391, 491326, 483773, 344553, 512386, 512420, 496901, 281061, 496899, 512333, 512161, 512384, 512418, 512224, 512219, 512267, 512271, 509954, 512217, 498585, 338982, 512232, 512227, 509950, 281060, 384488, 486826, 466987, 511922, 299952, 511975, 512213, 427615, 299950, 511774, 466985, 511920, 512175, 496888, 496887, 281059, 511916, 512149, 512165, 299946, 512170, 511512, 486823, 400487, 506179, 503039, 486821, 491325, 512094, 510939, 512092, 512104, 512089, 512106, 275616, 510995, 511769, 511122, 511121, 511887, 491324, 271507, 510593, 509756, 511753, 511810, 511819, 473518, 491322, 511816, 511721, 281057, 506117, 418788, 511701, 496872, 511704, 511221, 484717, 418786, 500203, 302549, 501105, 510808, 325405, 510583, 511379, 427542, 283975, 427540, 283973, 283972, 500201, 501102, 427538, 283970, 283969, 283967, 510989, 427526, 484712, 372838, 276190, 427521, 336647, 511511, 511113, 511508, 510806, 427509, 378876, 476533, 484710, 510486, 427507, 427504, 509673, 427501, 511503, 511500, 427497, 511495, 511218, 511214, 511255, 275355, 483768, 408454, 276188, 416016, 475703, 511493, 486820, 511466, 511372, 421511, 336644, 511464, 299940, 475699, 476531, 421507, 511439, 511399, 481157, 299938, 299936, 486359, 511396, 511300, 511393, 510153, 511385, 511383, 511366, 500412, 511378, 511252, 281055, 510937, 511250, 511247, 511233, 511245, 406785, 364327, 511350, 511270, 274460, 511293, 398718, 511265, 511290, 511263, 486905, 510934, 398716, 511105, 502018, 511237, 316255, 511102, 486900, 511230, 334105, 510457, 406783, 511148, 510986, 511092, 511144, 511090, 511155, 511142, 511083, 510984, 511080, 291838, 511075, 291836, 509671, 502522, 509669, 511064, 502014, 510955, 510979, 510993, 510977, 510803, 510932, 510484, 391481, 486891, 510577, 281054, 510870, 510868, 510864, 316252, 411971, 316250, 374126, 486889, 510862, 510752, 502005, 510905, 411968, 466984, 374124, 510855, 510639, 188811, 510796, 414991, 391477, 510638, 509948, 510785, 364325, 411957, 278820, 364322, 508970, 510720, 508968, 317357, 510751, 509754, 292783, 510718, 509752, 509750, 499735, 510714, 509748, 499733, 411954, 399813, 317354, 505281, 483764, 510709, 510636, 510635, 508191, 374121, 489254, 291832, 508326, 483761, 509013, 510634, 510632, 508188, 510630, 316248, 510553, 509054, 505278, 510692, 411389, 321925, 278713, 342847, 342845, 316245, 285198, 508963, 188808, 508961, 510551, 290645, 487369, 364318, 505275, 458588, 510549, 510540, 510557, 510537, 290643, 278815, 510102, 508325, 510147, 273394, 278813, 509052, 502271, 509668, 283958, 506172, 427346, 427340, 509785, 338977, 427333, 338975, 508324, 509445, 510480, 510475, 276939, 427321, 475685, 473823, 276929, 475684, 498816, 509666, 509780, 276177, 509664, 362360, 362358, 508874, 498813, 362355, 508872, 500403, 498811, 508322, 503941, 376705, 502843, 510129, 498807, 507657, 510095, 281051, 510037, 477374, 510035, 504980, 509925, 508315, 509902, 509663, 508649, 399810, 509661, 366420, 509747, 509659, 495813, 338974, 509656, 509741, 509703, 509654, 508644, 509652, 509650, 509690, 500604, 504973, 509406, 504969, 366418, 500594, 451977, 509397, 475222, 509051, 290876, 483753, 290870, 509049, 290869, 506170, 506165, 292767, 495778, 509023, 495775, 495772, 495770, 283181, 508912, 509004, 495768, 495763, 508891, 508767, 281046, 277474, 277097, 508310, 508620, 508476, 508575, 508472, 277094, 277091, 508293, 498783, 498780, 475657, 507977, 336568, 475655, 475650, 508076, 507969, 291831, 337061, 507968, 507963, 506159, 291828, 507761, 334104, 291826, 507696, 507655, 291822, 507652, 491912, 285394, 507308, 334103, 334101, 281043, 506532, 506525, 506521, 506113, 506440, 506343, 505529, 506136, 505627, 506106, 506111, 506098, 506096, 506067, 505640, 506004, 505453, 505795, 505452, 505859, 505580, 496819, 496801, 454732, 496798, 505725, 496796, 505579, 496793, 505448, 504426, 504424, 505444, 505418, 505440, 504885, 504884, 505438, 285390, 285387, 505367, 505298, 472838, 475599, 504846, 504615, 504574, 504520, 504517, 504422, 334099, 504420, 334097, 504414, 281033, 498770, 285385, 503922, 475582, 490287, 475578, 290867, 290865, 501554, 501552, 501550, 285189, 501548, 501333, 481073, 284323, 285375, 285373, 285372, 290568, 500688, 290566, 290559, 500686, 290863, 500678, 500043, 285371, 285369, 292456, 292455, 292453, 292451, 292449, 292447, 292445, 292443, 286087, 495160, 286074, 284314, 290855, 286072, 286070, 286068, 286067, 286065, 276865, 465706, 276860, 464441, 276858, 276856, 292209, 460709, 276845, 276843, 290637, 285983, 285981, 280816, 457820, 280811, 276829, 276827))
Run Time: 0.144360
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3442 | |
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 | | | | | 3442 | |
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 (30774, 29522, 29486, 29313, 29275, 29246, 29241, 29164, 29062, 28733, 28641, 28614, 28595, 28587, 28533, 28530, 28475, 28455, 28412, 28322, 28312, 28311, 28250, 28214, 28212, 28201, 28170, 28165, 28142, 28134, 28114, 28112, 28111, 28069, 28035, 27985, 27980, 27953, 27952, 27949, 27812, 27781, 27550, 27530, 27518, 27508, 27500, 27479, 27419, 27359, 27331, 27323, 27322, 27311, 27300, 27298, 27277, 27232, 27226, 27143, 27081, 27056, 27041, 27005, 26839, 26834, 26819, 26805, 26771, 26706, 26423, 26389, 26373, 26360, 26356, 26344, 26326, 26313, 26309, 26237, 26216, 26195, 26178, 26161, 26160, 26142, 26132, 26117, 26059, 26045, 26025, 26013, 25839, 25838, 25722, 25505, 22566))
Run Time: 0.017953
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 97 | 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 (641254, 637506, 638011, 637111, 637116, 601331, 607118, 445236, 601329, 366060, 538713, 550949, 16660, 16658, 23024, 588985, 462263, 93459, 587546, 587230, 539956, 3103, 503828, 343757, 270288, 85318, 270286, 503818, 8113, 503814, 390311, 528535, 528533, 282603, 569225, 567815, 567651, 567813, 517092, 559186, 567702, 567552, 282481, 567721, 282480, 567696, 567692, 298672, 567660, 298670, 326339, 567641, 567637, 298668, 490726, 567581, 559180, 361774, 567548, 282479, 567542, 559175, 559172, 559167, 567508, 308078, 395282, 567476, 567474, 567506, 567459, 567447, 567446, 298663, 488059, 567380, 567204, 377350, 565962, 567366, 567148, 564645, 337353, 343752, 160271, 527141, 520934, 337351, 527139, 527994, 567259, 567093, 520932, 160269, 304618, 567138, 567091, 567137, 567135, 559155, 567132, 567130, 253821, 291895, 567089, 329786, 481305, 564640, 557871, 481303, 566746, 566745, 291893, 329779, 329775, 566934, 565957, 566179, 566917, 282438, 566583, 566951, 566851, 566944, 282434, 282433, 293563, 282429, 566804, 282427, 566581, 282419, 566579, 566577, 566403, 564774, 564772, 566399, 564770, 564635, 566437, 566389, 566381, 566380, 566379, 566356, 284148, 316274, 298658, 566058, 566055, 565948, 566249, 546382, 565593, 510952, 565590, 560131, 561638, 565583, 483849, 565579, 510948, 565575, 566131, 550038, 565812, 412344, 565942, 483846, 282393, 483844, 546666, 23016, 503802, 565636, 546115, 565567, 565505, 565634, 564403, 563871, 494313, 546110, 565409, 546108, 550762, 565267, 476129, 565265, 476126, 565263, 564892, 476124, 565262, 564767, 565261, 565259, 564765, 565258, 565272, 565173, 565269, 341166, 565167, 565125, 564763, 565256, 564882, 565015, 564880, 564970, 564979, 564758, 564874, 540894, 564670, 564788, 564677, 564783, 564756, 522034, 564422, 564439, 564181, 564420, 564390, 564388, 564384, 564255, 555249, 564376, 564374, 564372, 564178, 282365, 564176, 557862, 476106, 564292, 282364, 563275, 282362, 452963, 316630, 527993, 564174, 557854, 564233, 319118, 561449, 564069, 563627, 307153, 520822, 560445, 561447, 564141, 561442, 563625, 558223, 483830, 564026, 564031, 564029, 563822, 563970, 555316, 563968, 513605, 489677, 462872, 483829, 497314, 513604, 513601, 497304, 282355, 497301, 563868, 563866, 563774, 538183, 282353, 512614, 563009, 563236, 556999, 284144, 563615, 563233, 501734, 563449, 563223, 563167, 540879, 563318, 563152, 563271, 562542, 563295, 294375, 294373, 563150, 563270, 294371, 489671, 562992, 562969, 562918, 562963, 282330, 562954, 562937, 561222, 489656, 490714, 489654, 562618, 559373, 562881, 502401, 562879, 292842, 540853, 559371, 459545, 562318, 282325, 506257, 540846, 282323, 540842, 513600, 540839, 282322, 556030, 562762, 540837, 282320, 556188, 562539, 562698, 562660, 562736, 489646, 282317, 562655, 489643, 562693, 282314, 560037, 371314, 562645, 509383, 513599, 546380, 489894, 562635, 505156, 562422, 562586, 546664, 522030, 555292, 487777, 298652, 562527, 561221, 546378, 282312, 308062, 522027, 562435, 522025, 36998, 562341, 351037, 544183, 562361, 550463, 562263, 550455, 562258, 517884, 489626, 282302, 489624, 491246, 308061, 282300, 308059, 489623, 489620, 282299, 556460, 326329, 544180, 396750, 489615, 549243, 510765, 513598, 562145, 562134, 282294, 562047, 326327, 561648, 562132, 326325, 561219, 561646, 561890, 561820, 561979, 561991, 561975, 561988, 528195, 522020, 561878, 561831, 561817, 522017, 561827, 561824, 556942, 498649, 522014, 561815, 561806, 522012, 300538, 559628, 282286, 513596, 561775, 289652, 503795, 559368, 561801, 561594, 275414, 538166, 561592, 282284, 561598, 561587, 538151, 561428, 561083, 561412, 561043, 560986, 561280, 510946, 559605, 538311, 561072, 549241, 561129, 559852, 513595, 561067, 561039, 507065, 561109, 560093, 561064, 282279, 549239, 497290, 560285, 560993, 560982, 282278, 308056, 282277, 512612, 512610, 282269, 293538, 546478, 547528, 555165, 292826, 500821, 544486, 560797, 560492, 560490, 275405, 398344, 560459, 560452, 560487, 275402, 544480, 560315, 544478, 291890, 560290, 521290, 559276, 544475, 275400, 282225, 282214, 282203, 282201, 559807, 282199, 282195, 560003, 544462, 559977, 560010, 559975, 546376, 282174, 282172, 559886, 559827, 282168, 274489, 284124, 325419, 308051, 275396, 556997, 559803, 282162, 512609, 559693, 282156, 557298, 282153, 545384, 282151, 556995, 559486, 556993, 547082, 559475, 520195, 541012, 478889, 559363, 282146, 559356, 282141, 557401, 377489, 559343, 558246, 513594, 546475, 559119, 282135, 293531, 540825, 546471, 23013, 314010, 548149, 558978, 275652, 558195, 557397, 314008, 558974, 557741, 557790, 556186, 275643, 546372, 558970, 556448, 546370, 558177, 556183, 507537, 556901, 558904, 558389, 555903, 558081, 282132, 556888, 556884, 558622, 540823, 282130, 282128, 558620, 546462, 282126, 556882, 556879, 558603, 558609, 500811, 293521, 558565, 509518, 546652, 282123, 556991, 557100, 557109, 556444, 558398, 558078, 558165, 558141, 544460, 308048, 544458, 544551, 431360, 558108, 557156, 557811, 544456, 557107, 282114, 557044, 517090, 544454, 515619, 282113, 556717, 556990, 557797, 557777, 556715, 486241, 545352, 543688, 344901, 555240, 556595, 556583, 556620, 556611, 540995, 544548, 556604, 556600, 540993, 556564, 556533, 337075, 540989, 556474, 540818, 556410, 545349, 548445, 391488, 556370, 545347, 556363, 555826, 556351, 540985, 540982, 517080, 556294, 555823, 556254, 555788, 556169, 544432, 556027, 555816, 555590, 556104, 555778, 556086, 282096, 555813, 544430, 545340, 555671, 555776, 555974, 409334, 492406, 282094, 282092, 555809, 555665, 555766, 555741, 555761, 555759, 555914, 555805, 555757, 555754, 555751, 555724, 555734, 555340, 544543, 555238, 282090, 555659, 282088, 555651, 540814, 555442, 282085, 555440, 522505, 462871, 555438, 540733, 555556, 555436, 545332, 451989, 545329, 545327, 545325, 555333, 555529, 487767, 540812, 540810, 555227, 555464, 545322, 523753, 555481, 555431, 555462, 462868, 555427, 555460, 555326, 555421, 555315, 555419, 504735, 490701, 555392, 490699, 319566, 492397, 555390, 555131, 491328, 490697, 490695, 555321, 555313, 490691, 555289, 523744, 552307, 555189, 315129, 282081, 523741, 504733, 315128, 282079, 278753, 315125, 555185, 555215, 544426, 546368, 315124, 300243, 546453, 492391, 555184, 504725, 555123, 512812, 282078, 342021, 550883, 554819, 497247, 497245, 528528, 459495, 545718, 552628, 497847, 546366, 160738, 160736, 552838, 550882, 462846, 552625, 522010, 550881, 522008, 550879, 552647, 370115, 552471, 552832, 552830, 552797, 451988, 550878, 550064, 552618, 552468, 299961, 552643, 552616, 552640, 552636, 552463, 540798, 552622, 337071, 552614, 480967, 552454, 552452, 552574, 546364, 452942, 544540, 282073, 552446, 498679, 551704, 291877, 546441, 552350, 282066, 552344, 282064, 513192, 552242, 550875, 549234, 552234, 282062, 282060, 552090, 459492, 550874, 293517, 552149, 552144, 552141, 517079, 552139, 552083, 344900, 546361, 282055, 551983, 551982, 551993, 551991, 543720, 522005, 546358, 543718, 510763, 545717, 546353, 551187, 473167, 551972, 282053, 551970, 551185, 517074, 473163, 301546, 551183, 122094, 473162, 507751, 551181, 507749, 551544, 517072, 551739, 551179, 452932, 550873, 550450, 473161, 551543, 551542, 551698, 551713, 551708, 548292, 544423, 551695, 551541, 551585, 551632, 551672, 452927, 551581, 551538, 551536, 507747, 282050, 551506, 551490, 551487, 480575, 512479, 451986, 551354, 551351, 551222, 549230, 538310, 546651, 551364, 551361, 551214, 551343, 150239, 550505, 551208, 551206, 512472, 291870, 291868, 545026, 551286, 203066, 550834, 551285, 291866, 492389, 481275, 150237, 39179, 492386, 481270, 551199, 497243, 550936, 551272, 551177, 481268, 546352, 551229, 551197, 550870, 39172, 356912, 551063, 550441, 550439, 510762, 507499, 282044, 550735, 512608, 282042, 550434, 550431, 492380, 551055, 551008, 502312, 502310, 550426, 550865, 452920, 39167, 356910, 452918, 282040, 452916, 487322, 452914, 546349, 550862, 550827, 546345, 550825, 476083, 550923, 550920, 492378, 477592, 501131, 276987, 550731, 550733, 492376, 550413, 550729, 550818, 550728, 550727, 546342, 39156, 550756, 550402, 550725, 282029, 549779, 550397, 282021, 550573, 550571, 510760, 430491, 430487, 39150, 513593, 550569, 510758, 550525, 282018, 308042, 521286, 550502, 9615, 521133, 550524, 282015, 550520, 550381, 282012, 550567, 39148, 282009, 315117, 550142, 484677, 550368, 550366, 548762, 484674, 282008, 540607, 550148, 546338, 282005, 550133, 413652, 545777, 546336, 276983, 276981, 276979, 546332, 276975, 546329, 407281, 540795, 546325, 282001, 540793, 521279, 521276, 281998, 546321, 281996, 546319, 410379, 546314, 549221, 410377, 550021, 549219, 281993, 516669, 550010, 381982, 513199, 546311, 505952, 540789, 509359, 281989, 506254, 549216, 316268, 513592, 549213, 536875, 540787, 549211, 549894, 287080, 545015, 549209, 506250, 546309, 549855, 549205, 279347, 509357, 549200, 521262, 513026, 546301, 548745, 549816, 549813, 549809, 370287, 536871, 275730, 520807, 275637, 483790, 281987, 549193, 548457, 549263, 549191, 301506, 549188, 549186, 476078, 496055, 549183, 326306, 547242, 467205, 509978, 547239, 545776, 547525, 509355, 548733, 548670, 546293, 421273, 507054, 548464, 407370, 546284, 412200, 546281, 412198, 546278, 281976, 506249, 540784, 15131, 546275, 540782, 548438, 501004, 546271, 508010, 517711, 546267, 546265, 546263, 546261, 546257, 546254, 540779, 293721, 546244, 540777, 281975, 548290, 308039, 293718, 511516, 548142, 540775, 15128, 547862, 547858, 492365, 546238, 281969, 547030, 384511, 547887, 384510, 486233, 547843, 511514, 384507, 498279, 546235, 384506, 500660, 546230, 547672, 540771, 281955, 547522, 547519, 547517, 547514, 547512, 547459, 518592, 287075, 547457, 547455, 546227, 513591, 509509, 271511, 502301, 518589, 547283, 518584, 547281, 502299, 476071, 528193, 275728, 515059, 545767, 515057, 547233, 547203, 502297, 278835, 520805, 547091, 547026, 520803, 546508, 537404, 537402, 547017, 520799, 546502, 547013, 508414, 546134, 508412, 508411, 546897, 546895, 546919, 546649, 476065, 546224, 545292, 546904, 546888, 546647, 546493, 542002, 546492, 546491, 546222, 523957, 546002, 546220, 502518, 545745, 502516, 546218, 546530, 546534, 502514, 546213, 546211, 540766, 452908, 476061, 476059, 293513, 546000, 545996, 452904, 189788, 506248, 353360, 452897, 452895, 344899, 344897, 546132, 502053, 546105, 283211, 546009, 516668, 546130, 281926, 546102, 545858, 528524, 274480, 8106, 275634, 8104, 195, 406072, 545856, 469622, 499141, 545854, 523104, 545849, 499139, 545846, 502043, 545803, 545800, 281922, 545798, 502040, 545716, 545811, 545787, 276299, 545771, 545750, 545708, 509503, 545687, 545638, 545650, 545648, 454395, 545636, 545685, 545706, 540966, 497215, 545659, 545656, 545646, 545654, 545633, 545631, 544938, 545541, 545493, 517182, 545430, 509678, 509676, 509497, 509674, 540959, 545432, 545435, 545426, 541995, 545424, 545412, 537386, 545010, 523098, 545318, 545288, 545312, 13453, 545308, 517709, 545283, 545298, 540761, 528189, 284082, 284080, 545196, 496337, 545174, 497210, 293508, 545240, 275387, 496037, 544962, 544926, 544959, 544955, 510757, 544841, 395338, 487713, 454344, 544784, 541879, 308031, 544828, 544826, 544821, 512200, 513589, 497190, 517706, 275633, 517704, 544782, 513586, 281912, 528184, 544778, 543670, 281907, 281900, 541579, 544314, 541796, 281897, 541792, 512607, 544332, 407369, 407367, 407365, 275631, 370114, 279342, 407279, 501388, 507460, 544566, 535206, 501384, 544564, 544532, 544525, 407363, 508516, 407361, 281891, 285397, 477564, 544512, 540758, 275727, 523955, 13450, 527991, 508008, 271893, 477559, 281889, 474218, 281887, 281885, 544400, 544405, 408460, 521256, 308030, 281883, 293506, 503774, 293504, 537080, 281877, 516666, 484658, 484657, 538307, 502513, 542371, 544295, 513023, 516542, 408459, 484655, 542057, 516540, 497638, 408457, 537077, 514312, 535199, 542973, 543750, 284075, 542927, 160266, 473591, 429673, 499132, 540320, 542972, 160264, 284333, 518322, 497590, 281865, 540942, 543341, 542919, 542912, 542365, 541612, 542343, 542361, 281864, 281860, 281845, 540315, 281843, 497163, 497584, 461322, 499346, 539171, 540078, 281824, 520876, 540214, 517060, 484638, 281820, 415016, 415008, 281819, 539825, 507430, 415004, 538306, 15123, 15121, 539349, 505341, 509473, 281816, 476048, 536649, 536647, 539220, 275379, 539196, 539176, 498869, 492364, 539139, 476045, 518521, 539126, 537821, 537819, 537817, 537910, 537814, 539045, 538999, 539054, 517869, 281806, 539028, 538997, 538995, 538506, 281799, 339356, 484603, 538872, 484601, 482211, 538879, 538719, 538717, 538503, 506235, 538671, 535501, 538667, 538669, 317652, 512195, 537398, 538578, 537750, 538498, 293500, 329760, 538341, 537596, 281794, 335215, 538267, 536644, 538129, 537889, 537527, 537739, 537887, 538066, 319733, 276275, 319731, 537388, 537364, 505935, 537343, 298639, 476021, 476018, 85129, 523952, 536975, 536903, 15119, 536901, 475986, 348093, 534968, 536708, 478882, 535495, 475980, 536629, 515051, 472244, 496295, 536627, 536623, 535487, 279578, 535751, 462454, 281747, 475976, 519075, 519072, 475974, 528183, 535658, 519070, 535461, 535088, 488569, 528027, 535545, 535082, 535080, 535543, 281736, 288581, 516887, 535459, 535457, 516885, 521312, 535469, 281733, 535466, 535060, 535058, 535056, 535053, 535049, 535045, 523718, 535041, 501119, 535266, 517824, 281729, 535242, 462452, 535028, 507428, 275367, 308008, 462450, 535180, 535170, 535015, 535168, 535166, 535164, 528555, 535144, 535004, 281722, 535000, 523949, 534998, 328780, 496007, 523503, 496004, 281719, 523501, 496002, 496000, 281717, 535117, 475963, 281715, 534965, 517820, 499117, 517816, 500656, 535107, 534958, 528502, 534990, 150234, 513278, 505077, 505075, 281688, 528479, 528506, 281683, 528477, 281680, 308004, 281678, 507422, 507420, 290655, 527211, 527209, 528463, 528453, 281658, 281656, 528451, 481235, 528381, 523478, 523476, 281654, 523474, 298629, 528389, 523472, 298627, 528378, 298625, 495988, 486882, 486879, 495986, 486877, 495984, 290653, 500511, 475960, 516660, 495982, 528136, 500506, 528180, 281645, 512601, 528176, 528199, 407360, 475956, 281638, 528079, 475952, 528077, 475949, 528075, 381402, 462449, 495974, 381400, 8101, 281622, 281615, 527990, 527987, 281609, 527981, 527467, 517175, 298623, 272989, 281592, 527303, 477523, 527295, 527289, 495958, 506225, 508006, 523266, 509316, 527175, 510494, 527133, 510488, 527145, 281571, 281563, 495940, 287017, 281560, 526658, 527044, 526656, 527009, 475934, 281549, 281547, 526953, 281544, 308001, 526968, 520190, 526964, 497136, 289844, 526959, 526961, 526957, 475931, 284053, 281540, 281538, 526916, 512600, 516382, 526865, 526868, 526842, 304373, 523924, 475924, 526826, 526824, 304371, 281534, 526822, 289842, 516370, 475921, 523918, 281524, 523915, 353332, 512598, 275872, 523943, 304368, 506220, 526652, 477521, 523913, 360497, 516525, 520178, 503058, 486875, 523941, 526576, 298609, 486872, 281510, 467785, 523416, 298607, 281506, 281501, 337067, 464729, 295863, 521857, 472267, 509451, 295861, 472265, 281487, 472262, 509449, 523908, 523933, 523095, 523823, 523929, 281486, 293460, 522808, 523092, 281474, 523084, 523081, 513583, 523447, 523870, 307261, 281466, 523879, 523890, 523838, 523877, 281462, 523866, 281460, 523852, 523263, 517050, 523076, 472260, 523074, 520484, 316208, 316786, 523810, 523788, 523786, 523443, 523668, 523688, 523287, 477510, 477508, 281444, 281442, 523261, 523681, 523138, 494153, 523453, 523451, 523449, 523427, 475897, 281434, 276964, 281429, 523256, 281424, 281422, 523065, 342966, 465702, 488796, 490213, 281417, 281415, 523375, 281412, 523357, 272986, 523283, 495893, 276959, 523253, 31856, 523134, 523275, 428513, 523250, 491552, 428512, 281393, 276957, 513582, 477488, 522950, 477486, 281390, 523131, 281385, 519123, 523057, 495880, 495876, 475891, 495873, 523158, 475889, 475887, 495870, 523142, 281381, 506216, 475884, 475882, 523128, 495864, 281379, 523039, 522982, 475880, 522885, 475877, 475875, 475873, 475870, 522857, 475868, 506214, 522847, 281369, 521589, 286123, 513020, 520715, 511138, 462589, 507373, 522465, 522549, 522526, 281345, 522133, 522417, 522368, 522131, 475864, 281334, 281319, 281317, 486910, 508876, 522125, 281316, 522123, 286121, 281304, 522048, 281302, 521811, 290884, 506208, 520584, 521439, 520929, 521429, 281281, 307986, 521445, 520482, 307982, 281280, 281278, 281276, 281274, 521425, 497068, 516497, 307980, 497062, 521399, 521364, 521314, 521360, 521350, 519292, 521182, 521327, 521114, 519677, 519675, 281270, 281269, 519673, 521107, 281267, 521104, 276231, 407351, 281265, 307979, 519288, 521036, 498602, 520668, 520665, 497042, 517192, 520937, 520942, 407346, 520656, 520653, 337066, 467776, 281262, 506207, 497031, 520643, 520637, 519670, 520632, 519665, 497025, 281261, 513455, 520794, 516467, 520623, 520852, 276952, 520791, 520786, 520784, 510756, 520766, 516461, 505001, 504999, 506205, 520558, 516455, 477440, 477438, 516452, 520761, 497020, 477426, 519659, 506202, 520754, 520589, 519286, 520752, 520555, 520722, 510943, 520586, 520732, 520553, 520578, 152954, 75534, 520720, 284011, 520575, 284009, 520572, 520538, 482204, 316551, 284007, 520477, 284005, 520475, 275359, 284000, 520468, 275357, 520466, 519655, 520436, 520464, 520471, 506199, 520131, 520402, 510941, 519811, 284957, 520425, 506197, 513448, 520317, 520359, 513446, 408185, 520278, 281258, 520297, 516448, 520276, 520292, 520123, 516446, 520121, 520283, 513444, 520261, 489261, 281257, 520259, 281253, 281251, 281249, 281247, 520244, 520257, 519592, 520234, 408182, 311553, 407344, 344417, 519284, 516438, 487278, 520112, 520226, 344415, 519808, 286113, 316263, 291852, 283996, 283995, 283994, 307978, 518654, 518650, 519277, 283992, 518644, 281246, 519828, 518642, 519328, 519806, 519826, 283988, 305314, 305312, 487272, 497008, 286110, 353329, 506019, 497006, 519804, 475852, 513435, 519692, 519715, 519713, 519320, 519801, 475849, 283986, 283984, 418745, 518631, 283982, 506017, 462587, 519645, 325977, 475844, 519639, 506196, 519635, 475842, 511070, 409908, 519708, 311551, 286108, 518965, 289639, 486720, 519632, 276947, 518626, 326271, 506195, 286106, 281236, 281232, 344891, 475838, 513432, 475836, 519557, 519518, 475834, 518619, 519511, 475832, 513198, 513430, 512597, 285211, 519151, 519456, 475828, 519325, 286104, 288375, 326269, 497000, 516115, 519311, 499024, 512720, 496997, 496991, 496988, 519309, 518266, 519368, 517165, 496986, 519307, 286102, 518572, 459305, 519303, 507993, 416772, 519299, 518609, 416770, 519294, 518310, 519258, 503258, 517043, 507992, 519219, 508384, 517041, 508382, 427995, 519158, 316547, 519147, 519155, 519139, 510940, 519137, 281216, 335211, 281213, 281211, 335208, 281209, 516433, 427988, 281207, 281204, 519042, 519120, 519116, 475820, 281199, 516113, 481226, 509976, 481224, 475818, 278716, 517963, 518783, 518963, 475813, 516422, 518566, 353326, 509972, 481221, 518780, 516111, 509967, 481217, 475811, 475808, 518561, 504994, 516110, 512415, 518607, 517808, 518341, 518604, 281191, 518152, 456194, 509965, 509574, 518601, 508376, 307977, 289633, 512443, 508373, 518546, 509962, 517802, 516108, 475806, 518599, 509960, 518614, 518513, 518664, 518387, 508370, 518508, 518523, 518385, 518383, 516636, 508357, 516106, 344889, 517505, 289626, 518379, 281183, 281181, 274191, 289623, 475803, 506190, 281179, 518372, 518368, 518271, 517703, 518339, 518195, 416332, 328178, 517795, 422364, 518334, 518331, 518328, 518293, 517793, 370110, 517190, 482203, 512700, 518281, 518189, 281174, 517499, 518268, 451984, 518187, 422362, 481214, 517786, 422359, 481212, 518150, 518239, 518235, 281168, 517923, 517981, 518227, 518225, 518148, 327987, 281158, 517763, 517750, 475798, 517713, 517291, 517570, 281156, 517640, 281154, 416766, 281152, 281150, 515588, 517288, 515586, 517023, 517590, 516104, 281141, 516101, 451979, 506184, 516623, 516989, 481207, 516873, 484314, 484308, 467601, 516155, 475748, 399817, 516096, 516150, 427791, 513378, 516842, 516094, 482687, 481200, 516186, 516092, 500785, 307974, 516330, 500783, 500622, 516144, 482684, 516659, 482680, 516804, 353318, 516656, 502023, 481198, 496933, 515583, 291847, 516652, 516089, 512698, 281120, 516293, 516087, 516707, 516644, 516085, 516600, 516602, 281109, 285205, 399815, 483778, 512373, 376297, 281107, 513208, 281104, 276203, 515664, 516289, 515579, 291843, 285203, 276201, 516082, 515577, 515015, 281097, 506183, 281095, 516079, 516077, 515659, 513367, 515575, 318122, 307970, 515785, 290595, 515572, 281084, 290592, 328172, 506131, 513361, 515553, 515765, 285201, 514816, 619529, 515643, 515634, 514813, 290589, 515539, 515532, 514811, 514755, 396733, 513580, 475739, 515044, 515010, 515004, 510755, 512694, 515001, 515000, 515027, 513356, 496928, 479377, 475725, 276195, 514821, 514807, 466999, 475722, 514762, 514311, 514760, 490605, 289836, 495835, 514723, 483775, 396730, 495833, 514726, 513758, 499753, 512838, 514394, 512836, 514051, 351811, 513753, 514310, 514376, 514373, 500616, 500614, 513132, 481186, 500611, 514282, 514276, 513130, 514261, 510601, 513167, 514244, 514240, 514199, 513677, 281080, 513165, 513352, 514178, 513275, 514176, 477399, 514169, 511687, 513207, 514122, 513272, 486862, 513197, 513162, 514090, 334113, 334111, 513159, 513579, 466996, 513206, 513577, 513576, 489706, 514053, 511685, 513671, 514022, 334109, 514020, 513018, 512179, 513854, 513747, 376713, 514011, 513953, 466994, 512177, 499743, 334106, 499741, 511828, 319565, 513666, 513156, 486856, 513661, 513660, 513812, 513655, 513649, 506129, 513822, 513820, 513818, 513637, 484849, 513635, 189785, 492361, 513634, 512692, 513569, 513632, 316540, 513567, 513565, 513263, 513564, 513196, 513562, 509447, 513630, 513035, 510754, 512690, 316536, 513620, 513680, 511787, 508541, 316529, 467599, 513195, 507640, 316256, 512441, 513126, 513561, 513344, 370096, 467597, 513260, 376710, 376708, 513342, 285199, 307969, 467595, 513299, 469010, 370094, 344414, 513255, 344412, 344410, 495084, 512634, 513212, 469009, 512630, 513149, 513122, 481863, 472310, 513017, 274462, 513120, 513015, 513116, 281070, 486851, 513114, 513110, 512437, 512471, 512407, 513108, 512654, 513073, 512405, 356514, 476509, 384494, 513008, 510753, 409329, 512652, 513006, 513004, 384492, 356511, 512650, 513056, 486848, 384489, 512689, 513030, 512435, 512648, 513001, 512686, 513040, 281069, 467592, 486846, 486841, 281066, 512997, 512995, 486838, 512545, 476506, 476504, 497448, 381484, 512677, 512646, 290650, 427653, 290648, 475719, 462639, 512674, 512431, 512830, 512399, 427646, 475717, 304350, 512670, 512710, 512430, 512715, 486834, 512596, 381482, 512643, 512616, 512362, 512503, 323575, 512542, 304345, 512567, 506564, 512357, 512540, 512428, 366421, 512538, 512355, 512425, 304340, 509956, 304335, 477394, 512498, 481170, 466993, 512466, 512396, 466991, 481166, 481161, 512462, 481159, 512488, 466990, 512352, 512458, 466988, 512393, 496904, 507978, 506180, 512447, 351804, 511130, 512445, 512422, 512336, 506123, 506121, 512391, 491326, 483773, 344553, 512386, 512420, 496901, 281061, 496899, 512333, 512161, 512384, 512418, 512224, 512219, 512267, 512271, 509954, 512217, 498585, 338982, 512232, 512227, 509950, 281060, 384488, 486826, 466987, 511922, 299952, 511975, 512213, 427615, 299950, 511774, 466985, 511920, 512175, 496888, 496887, 281059, 511916, 512149, 512165, 299946, 512170, 511512, 486823, 400487, 506179, 503039, 486821, 491325, 512094, 510939, 512092, 512104, 512089, 512106, 275616, 510995, 511769, 511122, 511121, 511887, 491324, 271507, 510593, 509756, 511753, 511810, 511819, 473518, 491322, 511816, 511721, 281057, 506117, 418788, 511701, 496872, 511704, 511221, 484717, 418786, 500203, 302549, 501105, 510808, 325405, 510583, 511379, 427542, 283975, 427540, 283973, 283972, 500201, 501102, 427538, 283970, 283969, 283967, 510989, 427526, 484712, 372838, 276190, 427521, 336647, 511511, 511113, 511508, 510806, 427509, 378876, 476533, 484710, 510486, 427507, 427504, 509673, 427501, 511503, 511500, 427497, 511495, 511218, 511214, 511255, 275355, 483768, 408454, 276188, 416016, 475703, 511493, 486820, 511466, 511372, 421511, 336644, 511464, 299940, 475699, 476531, 421507, 511439, 511399, 481157, 299938, 299936, 486359, 511396, 511300, 511393, 510153, 511385, 511383, 511366, 500412, 511378, 511252, 281055, 510937, 511250, 511247, 511233, 511245, 406785, 364327, 511350, 511270, 274460, 511293, 398718, 511265, 511290, 511263, 486905, 510934, 398716, 511105, 502018, 511237, 316255, 511102, 486900, 511230, 334105, 510457, 406783, 511148, 510986, 511092, 511144, 511090, 511155, 511142, 511083, 510984, 511080, 291838, 511075, 291836, 509671, 502522, 509669, 511064, 502014, 510955, 510979, 510993, 510977, 510803, 510932, 510484, 391481, 486891, 510577, 281054, 510870, 510868, 510864, 316252, 411971, 316250, 374126, 486889, 510862, 510752, 502005, 510905, 411968, 466984, 374124, 510855, 510639, 188811, 510796, 414991, 391477, 510638, 509948, 510785, 364325, 411957, 278820, 364322, 508970, 510720, 508968, 317357, 510751, 509754, 292783, 510718, 509752, 509750, 499735, 510714, 509748, 499733, 411954, 399813, 317354, 505281, 483764, 510709, 510636, 510635, 508191, 374121, 489254, 291832, 508326, 483761, 509013, 510634, 510632, 508188, 510630, 316248, 510553, 509054, 505278, 510692, 411389, 321925, 278713, 342847, 342845, 316245, 285198, 508963, 188808, 508961, 510551, 290645, 487369, 364318, 505275, 458588, 510549, 510540, 510557, 510537, 290643, 278815, 510102, 508325, 510147, 273394, 278813, 509052, 502271, 509668, 283958, 506172, 427346, 427340, 509785, 338977, 427333, 338975, 508324, 509445, 510480, 510475, 276939, 427321, 475685, 473823, 276929, 475684, 498816, 509666, 509780, 276177, 509664, 362360, 362358, 508874, 498813, 362355, 508872, 500403, 498811, 508322, 503941, 376705, 502843, 510129, 498807, 507657, 510095, 281051, 510037, 477374, 510035, 504980, 509925, 508315, 509902, 509663, 508649, 399810, 509661, 366420, 509747, 509659, 495813, 338974, 509656, 509741, 509703, 509654, 508644, 509652, 509650, 509690, 500604, 504973, 509406, 504969, 366418, 500594, 451977, 509397, 475222, 509051, 290876, 483753, 290870, 509049, 290869, 506170, 506165, 292767, 495778, 509023, 495775, 495772, 495770, 283181, 508912, 509004, 495768, 495763, 508891, 508767, 281046, 277474, 277097, 508310, 508620, 508476, 508575, 508472, 277094, 277091, 508293, 498783, 498780, 475657, 507977, 336568, 475655, 475650, 508076, 507969, 291831, 337061, 507968, 507963, 506159, 291828, 507761, 334104, 291826, 507696, 507655, 291822, 507652, 491912, 285394, 507308, 334103, 334101, 281043, 506532, 506525, 506521, 506113, 506440, 506343, 505529, 506136, 505627, 506106, 506111, 506098, 506096, 506067, 505640, 506004, 505453, 505795, 505452, 505859, 505580, 496819, 496801, 454732, 496798, 505725, 496796, 505579, 496793, 505448, 504426, 504424, 505444, 505418, 505440, 504885, 504884, 505438, 285390, 285387, 505367, 505298, 472838, 475599, 504846, 504615, 504574, 504520, 504517, 504422, 334099, 504420, 334097, 504414, 281033, 498770, 285385, 503922, 475582, 490287, 475578, 290867, 290865, 501554, 501552, 501550, 285189, 501548, 501333, 481073, 284323, 285375, 285373, 285372, 290568, 500688, 290566, 290559, 500686, 290863, 500678, 500043, 285371, 285369, 292456, 292455, 292453, 292451, 292449, 292447, 292445, 292443, 286087, 495160, 286074, 284314, 290855, 286072, 286070, 286068, 286067, 286065, 276865, 465706, 276860, 464441, 276858, 276856, 292209, 460709, 276845, 276843, 290637, 285983, 285981, 280816, 457820, 280811, 276829, 276827))
Run Time: 0.074656
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3442 | |
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 | | | | | 3442 | |
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 (30774, 29522, 29486, 29313, 29275, 29246, 29241, 29164, 29062, 28733, 28641, 28614, 28595, 28587, 28533, 28530, 28475, 28455, 28412, 28322, 28312, 28311, 28250, 28214, 28212, 28201, 28170, 28165, 28142, 28134, 28114, 28112, 28111, 28069, 28035, 27985, 27980, 27953, 27952, 27949, 27812, 27781, 27550, 27530, 27518, 27508, 27500, 27479, 27419, 27359, 27331, 27323, 27322, 27311, 27300, 27298, 27277, 27232, 27226, 27143, 27081, 27056, 27041, 27005, 26839, 26834, 26819, 26805, 26771, 26706, 26423, 26389, 26373, 26360, 26356, 26344, 26326, 26313, 26309, 26237, 26216, 26195, 26178, 26161, 26160, 26142, 26132, 26117, 26059, 26045, 26025, 26013, 25839, 25838, 25722, 25505, 22566))
Run Time: 0.004521
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 97 | 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.000368
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.000440
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.000653
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: 1716144655
Run Time: 0.000492
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` >= 1716144655)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000539
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