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.000741
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.000208
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` = '2179')
LIMIT 1
Run Time: 0.000472
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.002981
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_2179' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.126168
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 (565961, 565959, 565768, 312441, 512134, 511853, 512132, 492787, 488488, 489769, 377859, 487043, 487041, 487039, 487035, 487033, 486282, 486280, 258702, 480259, 480256, 472319, 472317, 470953, 468097, 468094, 467821, 465815, 377853, 462510, 377852, 455186, 455184, 413838, 273363, 408907, 369815, 401450, 117673, 386181, 117669, 388384, 385553, 367947, 384949, 384947, 384945, 384727, 384081, 384068, 382902, 302344, 381228, 381308, 379598, 379594, 379590, 377844, 379443, 377842, 377840, 377839, 370549, 378592, 378955, 378732, 377379, 378499, 377376, 378600, 378561, 377837, 377373, 377835, 377365, 377833, 377831, 377649, 16631, 377287, 377361, 377646, 377664, 377359, 377236, 377357, 377233, 376703, 117665, 302336, 373001, 370540, 375481, 375480, 374299, 375400, 371387, 369794, 375374, 375372, 371384, 117662, 374353, 369790, 287703, 373381, 372261, 372857, 302332, 372418, 372854, 372580, 370882, 366860, 117658, 371239, 372258, 370916, 371345, 371237, 370914, 371264, 370751, 365788, 370987, 371033, 365785, 370863, 370873, 314231, 370335, 370737, 370693, 370857, 370313, 370333, 258700, 370311, 370294, 370184, 334042, 370370, 369900, 258697, 370181, 366736, 370331, 16625, 370292, 370316, 370303, 370177, 258695, 370172, 370039, 369927, 258691, 369571, 369785, 369471, 369567, 258688, 354772, 367943, 258686, 367939, 301864, 368849, 301856, 368844, 364577, 273354, 363198, 367915, 366731, 364575, 363194, 367913, 366661, 366729, 364622, 364572, 365783, 367778, 366743, 366683, 364570, 365993, 365906, 365865, 365868, 365903, 203061, 296411, 353428, 364567, 296409, 364946, 364875, 362875, 273334, 364830, 273332, 364589, 364828, 364598, 117653, 364564, 364596, 340347, 364238, 117651, 273330, 96845, 117649, 355355, 16622, 355352, 355350, 363933, 363389, 355348, 117647, 355345, 363387, 355343, 363579, 355340, 363385, 273326, 355337, 355336, 359536, 117646, 342217, 359534, 355333, 363219, 342215, 342213, 304591, 363187, 362895, 203059, 357604, 362944, 362892, 362866, 342211, 302329, 360907, 302327, 360905, 117645, 203053, 302323, 361715, 361679, 361677, 360899, 361128, 360363, 359262, 361119, 360890, 360361, 96843, 359260, 360886, 360883, 359258, 360879, 360874, 80983, 360872, 360981, 355330, 359532, 357925, 80981, 360979, 360870, 356920, 360617, 339843, 357921, 359595, 339839, 357917, 357174, 339837, 358927, 359657, 359593, 339835, 359589, 359587, 359656, 359654, 359652, 359650, 358923, 359253, 359585, 359250, 359384, 357788, 359244, 359242, 354769, 356176, 356174, 357120, 354602, 160226, 350745, 357784, 356170, 357783, 350743, 357549, 350741, 357545, 357543, 353990, 350739, 356155, 357171, 356918, 117639, 355159, 16620, 356152, 356151, 357108, 353669, 357169, 357104, 356146, 356916, 353657, 354586, 8070, 355327, 8068, 8064, 355325, 350737, 350735, 353969, 117638, 355398, 355314, 355052, 117636, 353187, 353966, 355312, 354760, 354274, 354867, 354757, 354269, 354592, 354646, 354644, 354753, 354133, 203043, 8063, 8061, 253690, 352726, 354279, 354310, 353642, 253688, 350832, 271722, 353639, 8059, 8057, 353637, 302321, 353784, 36920, 350966, 353482, 339171, 353276, 350697, 353479, 353525, 353184, 352535, 353177, 305133, 346467, 253682, 353174, 352538, 352531, 352529, 117634, 350631, 351428, 271720, 351426, 340417, 351660, 350629, 351424, 351421, 340415, 352047, 352039, 352045, 351536, 351496, 351417, 351737, 351658, 350626, 351782, 340413, 338877, 351493, 351409, 350958, 351490, 351203, 348447, 350684, 340411, 340407, 350624, 350828, 350826, 350620, 340405, 350617, 350824, 350615, 350695, 350613, 350822, 350351, 350681, 350609, 350349, 349910, 349907, 349904, 349903, 349896, 349894, 349966, 346952, 346948, 349351, 340402, 346947, 348761, 271716, 341344, 348425, 348640, 349350, 346944, 349241, 348755, 346941, 346939, 348423, 346935, 346933, 348429, 346932, 346931, 348443, 346930, 346018, 348386, 348384, 348434, 346928, 345951, 346926, 345949, 345945, 345944, 346925, 267386, 346924, 345943, 345940, 346921, 347107, 347691, 347690, 347521, 347104, 347216, 345816, 338465, 347097, 342369, 338464, 346430, 345937, 345935, 346976, 346428, 346918, 345930, 345928, 347092, 345925, 346510, 345923, 345811, 346493, 253672, 346903, 346425, 345919, 345036, 346491, 346508, 346915, 345916, 345033, 345030, 345915, 345914, 346670, 345912, 346454, 346488, 346502, 312438, 345910, 253663, 345907, 345901, 345180, 345892, 345822, 345177, 345820, 345170, 345169, 345164, 342366, 345163, 345162, 345159, 344337, 345153, 299014, 345069, 342364, 345096, 345067, 345093, 342355, 344334, 344328, 344846, 344637, 344319, 342342, 344816, 338549, 344844, 328531, 344634, 344310, 253653, 253650, 344630, 328527, 344298, 328524, 344294, 328521, 343978, 343773, 343939, 302943, 299081, 340317, 343937, 343975, 343935, 342339, 342337, 312431, 342335, 253646, 343761, 312427, 343578, 343573, 312425, 342333, 117632, 343211, 342896, 117627, 312423, 342893, 338461, 338459, 339376, 339371, 338453, 253642, 338448, 342306, 302933, 338447, 342588, 338444, 342331, 338442, 338440, 342309, 342304, 341223, 341945, 338875, 253635, 341221, 341804, 341342, 329100, 341818, 341219, 339164, 340312, 340704, 340817, 338873, 340683, 113162, 340701, 340813, 340740, 340690, 339350, 340601, 340381, 340399, 340339, 340354, 340352, 340357, 339885, 340095, 339975, 339409, 339880, 339854, 339852, 339879, 339859, 339334, 339849, 339878, 339872, 339813, 342224, 339367, 339325, 339406, 338869, 338867, 339404, 339160, 334933, 339425, 339155, 339314, 339306, 339302, 339361, 339299, 339088, 339184, 339151, 339084, 338350, 339081, 97755, 338348, 338175, 338173, 338746, 338799, 338171, 338438, 338169, 338639, 68581, 307600, 307312, 338545, 300693, 306881, 300691, 334032, 300689, 300686, 96826, 329091, 329088, 329086, 335048, 338165, 337899, 328519, 338151, 329084, 328517, 334348, 328515, 334346, 337865, 328513, 335024, 328511, 335022, 337713, 334344, 328509, 334342, 335019, 334339, 335017, 337446, 337235, 337233, 335015, 337231, 336841, 336839, 336797, 334337, 328507, 336411, 332082, 335829, 335816, 335814, 332080, 332078, 332074, 334922, 334326, 96820, 335043, 335039, 334944, 335010, 334913, 96818, 334893, 334942, 335007, 96816, 334911, 334939, 334928, 334334, 96813, 334754, 334332, 306356, 334329, 306353, 306350, 332068, 306348, 333100, 306345, 332980, 306342, 328982, 332066, 333092, 117616, 332038, 332154, 332306, 327358, 327294, 327356, 321812, 327082, 327354, 327292, 327288, 321901, 16604, 326600, 127068, 36899, 36895, 326404, 326807, 318425, 326598, 319895, 318694, 319893, 318688, 312109, 321954, 318684, 321948, 318682, 326423, 321332, 319891, 326351, 326347, 326344, 324453, 301447, 319835, 180303, 262983, 321898, 301444, 321734, 316800, 301440, 301436, 321896, 325454, 318603, 301434, 301431, 321894, 318600, 318598, 325240, 318597, 311104, 321892, 301429, 319887, 318594, 322973, 301427, 323657, 318591, 322967, 321890, 321880, 304027, 321875, 321878, 321724, 318588, 318586, 319884, 320202, 321729, 321536, 321298, 318585, 321715, 314916, 321282, 321524, 321517, 321384, 83199, 321369, 18310, 321322, 320199, 320176, 321328, 321279, 320172, 320197, 284477, 208066, 262380, 321296, 304025, 319326, 320133, 318583, 319323, 318577, 320115, 304021, 302316, 319969, 318575, 16596, 310854, 317015, 318571, 319852, 319846, 319647, 319822, 287693, 319816, 319641, 28584, 319825, 287691, 319319, 319318, 319442, 318562, 319316, 96801, 319573, 318559, 319438, 319314, 319336, 319312, 319307, 310848, 319031, 319296, 310845, 318936, 319029, 287689, 319156, 316191, 319150, 317539, 319024, 319147, 319013, 318925, 318678, 312032, 318677, 318948, 183958, 318797, 318655, 318651, 318555, 318618, 318551, 318437, 183955, 318450, 299075, 312029, 312026, 290717, 304017, 312024, 304015, 312022, 317013, 317531, 317487, 299072, 317010, 317008, 36892, 304013, 304011, 304010, 304005, 299070, 304001, 296381, 316794, 313782, 311881, 316772, 316188, 316769, 270578, 270576, 270573, 270571, 311326, 316021, 313778, 316018, 316013, 314995, 314203, 314201, 314911, 314216, 311101, 313909, 314213, 314211, 313473, 306334, 314199, 270555, 314334, 314162, 313553, 314194, 306302, 310830, 314064, 314057, 270553, 312884, 270551, 271696, 313706, 313524, 312882, 313905, 302305, 313999, 313903, 311180, 313899, 313798, 313470, 313796, 270548, 313801, 270545, 302300, 311176, 302296, 302294, 18305, 271694, 300701, 204866, 313522, 300555, 310827, 313697, 313517, 310821, 300553, 310815, 300551, 310813, 296301, 300547, 313277, 310809, 313513, 311174, 313466, 18304, 183949, 311172, 302292, 299067, 299065, 312910, 310760, 306879, 270542, 310755, 312354, 290714, 310753, 302288, 307755, 312879, 312804, 312712, 183946, 301420, 270539, 270537, 302285, 299064, 301416, 312335, 307753, 302283, 312192, 312493, 312491, 302281, 312421, 312420, 312489, 312020, 312418, 312358, 312018, 312356, 312188, 311100, 270535, 312186, 311262, 310745, 311096, 311094, 301412, 270533, 312166, 312164, 312093, 270530, 270527, 312105, 312102, 312091, 302278, 311952, 310726, 302276, 311840, 310724, 310717, 311162, 310705, 311672, 311159, 306877, 310701, 306330, 311794, 310699, 311788, 310696, 311154, 311687, 311471, 311435, 311433, 311150, 310692, 310436, 311144, 160729, 310591, 311140, 311139, 311135, 302273, 311132, 311283, 311252, 311125, 299501, 306875, 301409, 299498, 310680, 311068, 299496, 310586, 299493, 310584, 310589, 301407, 306870, 307785, 306867, 310405, 310408, 307779, 267380, 306850, 308192, 307740, 306845, 267373, 307774, 303997, 307772, 306836, 302270, 267361, 306834, 308183, 307738, 308196, 307593, 303889, 307729, 306687, 307727, 267357, 306685, 305013, 303887, 301403, 307591, 303885, 307618, 267354, 267348, 303880, 301401, 307615, 307330, 305011, 307589, 307613, 299058, 307286, 299050, 303876, 306683, 307306, 303872, 306681, 307284, 307328, 34650, 307299, 307332, 299195, 267340, 307289, 270523, 307207, 267332, 267328, 267326, 34646, 300699, 267322, 303866, 267320, 307030, 306738, 307040, 305367, 267318, 307036, 306825, 307028, 307033, 306916, 306317, 267313, 304855, 267309, 303862, 306820, 267306, 304852, 303859, 34643, 306731, 306713, 34638, 270518, 305223, 306674, 306552, 18299, 305745, 306548, 18297, 306559, 305429, 306545, 305221, 306135, 305116, 305113, 306312, 117609, 306308, 303538, 305108, 117607, 305549, 304850, 117605, 305104, 305384, 305383, 303943, 305498, 305516, 305255, 304841, 202313, 270510, 305218, 290032, 305230, 305377, 305374, 305352, 305213, 305009, 305228, 303936, 305289, 302381, 304897, 302916, 202307, 302913, 304814, 202305, 304892, 302911, 202302, 301395, 303856, 290029, 304460, 202299, 301391, 303854, 303852, 202296, 290027, 304458, 304549, 303929, 303821, 287383, 303850, 302453, 303741, 284990, 303848, 202293, 303816, 303924, 303846, 202291, 303796, 303812, 303919, 302379, 303844, 302450, 92881, 302159, 303810, 303793, 92876, 302152, 303731, 302150, 302511, 303719, 287449, 303723, 303743, 299183, 297499, 303729, 302148, 3069, 302448, 287447, 202287, 302142, 302908, 303520, 302951, 302140, 302407, 302101, 302138, 303518, 302948, 302099, 302509, 301367, 302131, 302503, 284986, 302404, 302441, 297000, 302095, 302414, 302266, 302114, 301751, 302396, 299560, 301364, 300663, 302090, 264649, 302111, 301745, 299178, 301334, 299160, 301947, 301652, 299558, 301107, 301106, 299253, 301944, 285025, 301649, 300966, 301871, 300659, 301554, 301362, 287443, 299046, 287441, 301360, 301563, 301647, 300657, 301757, 288477, 300870, 301332, 160727, 301084, 300652, 301356, 300863, 301330, 160723, 300649, 301082, 301238, 301350, 301226, 301345, 301080, 301223, 300647, 301012, 301220, 300964, 301077, 301010, 300962, 300960, 300644, 299596, 301008, 192660, 301125, 297333, 300958, 297521, 301103, 301116, 300682, 160720, 300642, 300853, 300851, 290119, 300719, 299251, 300848, 300846, 300635, 300857, 300680, 300743, 300678, 299248, 300676, 300675, 300581, 300630, 300672, 300671, 184884, 192658, 300668, 300716, 300666, 300544, 296367, 300536, 299590, 299035, 299242, 300592, 300542, 299587, 300502, 299030, 299028, 284376, 300534, 298903, 300455, 299023, 284374, 300494, 298901, 300451, 290021, 300449, 299485, 299483, 299575, 300293, 86518, 299481, 299700, 299475, 299229, 299568, 299691, 299689, 299238, 299473, 299427, 299566, 297291, 86516, 299226, 299555, 299563, 86514, 160717, 299425, 290014, 288114, 160715, 296992, 264642, 290008, 264638, 299234, 299176, 299222, 296990, 299174, 299198, 299204, 290005, 299220, 299021, 299152, 299019, 299008, 298896, 117594, 289998, 298990, 289996, 298166, 297277, 289993, 298971, 298940, 289991, 289989, 298925, 298885, 298883, 298880, 298870, 296879, 298827, 298789, 298315, 298725, 160710, 264633, 298273, 298435, 263357, 297709, 298785, 298722, 297375, 298720, 298718, 298674, 298431, 298422, 298267, 298238, 298310, 298301, 297259, 297257, 117592, 296358, 297238, 287495, 267293, 267291, 298199, 297529, 297360, 297358, 298232, 298220, 298229, 288093, 298164, 298181, 287687, 298169, 298179, 298066, 295429, 297233, 297231, 287492, 297725, 296286, 297701, 297678, 296284, 297354, 295427, 297226, 297490, 297518, 297523, 297488, 59450, 297224, 297351, 297247, 288090, 295572, 297481, 297369, 296986, 297410, 295806, 288088, 297390, 297309, 288084, 297349, 297245, 297302, 297242, 295425, 296982, 295422, 295571, 287488, 297067, 297024, 297022, 288081, 117590, 297018, 296441, 296980, 264568, 296131, 264564, 296438, 264562, 264560, 296129, 264558, 295419, 296436, 296352, 296318, 296127, 295417, 295805, 295415, 287685, 287509, 117589, 287485, 287507, 293733, 295970, 296096, 287809, 288110, 287752, 295123, 295568, 295120, 287750, 295563, 295968, 295558, 288106, 295918, 295548, 295546, 295118, 287747, 284984, 295542, 295536, 287745, 295116, 253619, 288079, 287197, 295786, 291642, 295413, 287193, 288076, 153927, 295513, 293843, 290115, 294545, 277808, 295525, 295112, 253617, 277806, 117587, 294531, 290111, 293763, 295109, 288074, 295437, 295435, 287191, 290109, 295411, 151421, 287188, 295433, 287186, 295408, 295443, 295450, 287184, 287182, 295106, 287743, 277803, 295160, 295103, 294749, 293841, 295006, 287741, 294744, 271685, 294529, 294899, 294527, 253613, 293839, 293837, 294543, 282982, 294526, 294433, 288501, 291904, 288068, 121876, 289856, 291542, 294390, 293833, 293829, 264367, 291538, 287483, 293806, 264365, 290094, 293755, 253611, 277799, 291522, 18273, 287737, 287481, 291534, 264362, 292188, 291636, 264359, 264357, 288730, 288727, 264354, 287477, 290326, 201392, 290702, 290605, 290148, 290324, 290246, 289721, 282873, 288694, 288065, 287379, 287807, 287475, 287729, 290146, 264734, 290050, 290061, 104564, 277795, 290047, 288720, 289979, 289732, 289985, 289291, 289289, 277793, 28565, 289286, 289734, 289730, 289713, 289284, 288698, 289711, 287473, 117579, 204301, 271683, 285227, 287948, 264352, 288718, 288505, 288714, 289232, 264349, 288313, 288712, 204298, 96796, 264347, 288064, 288661, 288474, 288665, 277791, 287726, 288650, 287724, 288311, 288472, 288292, 264344, 253604, 287377, 287721, 288290, 288610, 288470, 288308, 264342, 288139, 288487, 288063, 284563, 28561, 288287, 287375, 288284, 273118, 287626, 287717, 288126, 287714, 288096, 104534, 287711, 104532, 287803, 287946, 164, 264339, 270713, 123433, 287800, 287708, 162, 287369, 278292, 287467, 287706, 160, 287402, 286589, 282823, 285883, 253601, 287555, 287364, 284871, 287614, 287463, 287539, 287398, 271676, 282820, 253596, 287461, 287352, 287497, 287210, 287179, 287458, 287425, 271674, 287419, 264333, 287422, 287456, 253593, 282677, 287356, 264331, 270265, 287347, 287395, 271672, 270628, 152335, 282673, 271670, 287345, 264329, 284472, 285867, 282669, 285728, 285658, 203018, 284754, 286584, 285725, 287176, 285721, 284981, 253587, 282662, 285718, 282660, 282657, 285945, 271667, 285923, 284469, 285715, 285878, 271665, 285921, 285890, 285875, 285853, 277785, 283765, 284852, 285861, 285687, 282705, 284748, 285648, 284850, 285018, 285223, 268788, 278290, 284868, 283763, 278288, 277705, 285235, 284746, 278286, 285012, 284862, 284483, 284860, 285010, 285014, 273101, 285058, 3059, 284848, 284765, 285022, 284980, 277773, 284844, 284762, 284977, 284842, 282627, 284742, 282625, 277765, 261885, 261883, 284463, 3055, 282695, 272893, 284460, 284594, 282623, 278283, 284500, 282914, 284440, 284479, 282650, 201381, 284438, 284365, 282817, 284421, 282868, 284362, 282815, 284209, 278281, 97751, 279675, 97749, 271919, 279981, 75739, 283761, 282866, 278278, 277762, 278276, 283131, 268746, 282812, 282810, 282688, 278148, 277756, 279692, 279526, 273168, 279524, 282613, 271660, 282610, 277754, 282648, 279973, 269616, 282605, 279600, 278272, 250614, 279439, 279688, 279131, 278269, 250610, 279685, 279437, 279597, 279429, 273166, 34633, 279594, 279592, 273164, 273162, 279519, 278267, 277748, 279516, 279435, 276515, 278140, 279128, 277744, 273160, 277742, 34629, 270705, 279126, 34626, 34623, 278264, 273099, 277736, 278261, 277695, 278251, 277692, 277722, 278138, 277684, 117576, 277538, 274771, 160707, 273564, 277536, 273562, 277534, 273546, 277162, 258352, 277099, 160705, 160703, 274764, 117574, 275667, 274723, 271651, 273418, 274653, 273416, 271648, 274079, 273413, 273176, 273174, 273558, 189730, 273151, 273095, 273541, 273199, 273093, 273187, 273147, 273196, 273156, 270774, 273085, 273083, 269785, 272888, 271646, 272869, 271644, 272864, 271642, 271638, 271636, 272862, 259592, 271634, 271632, 265186, 271630, 271628, 270772, 271626, 271624, 271557, 269783, 271622, 270742, 271543, 271616, 271007, 271592, 271589, 271522, 270740, 262102, 271213, 270736, 268774, 269778, 269774, 271210, 269771, 258349, 96793, 271272, 270965, 269769, 271304, 96791, 271208, 271267, 269766, 270732, 269760, 269758, 270626, 271202, 270701, 269755, 271085, 271188, 258675, 270802, 271089, 269751, 270810, 269749, 271002, 270698, 270944, 270963, 270989, 270771, 270324, 269746, 270942, 270696, 270961, 270800, 270218, 269742, 270216, 270770, 270624, 270690, 269740, 270687, 268772, 270685, 269734, 269732, 270593, 270716, 270681, 268767, 270671, 269909, 270676, 267154, 269907, 270322, 270669, 268763, 269905, 270597, 267151, 270590, 270622, 269903, 269901, 269711, 270588, 262975, 270585, 270491, 270291, 270049, 270212, 269926, 269894, 269728, 270183, 266569, 269548, 269794, 270093, 269585, 270107, 269708, 270145, 269634, 269792, 269959, 269383, 269722, 269719, 269716, 267149, 269701, 263931, 269627, 262217, 203821, 264324, 269286, 264321, 269282, 268002, 268001, 269172, 268477, 268742, 268738, 267285, 268735, 268750, 268733, 267943, 268390, 266173, 267939, 268387, 267934, 267933, 267926, 268033, 268385, 267914, 267144, 263773, 143248, 254666, 266170, 96181, 264906, 264811, 264860, 255511, 264708, 264301, 264792, 264297, 255509, 264807, 264827, 255507, 264414, 264295, 264663, 117568, 264282, 263920, 264787, 264446, 264480, 264771, 264765, 264444, 264657, 264478, 264700, 264276, 263916, 264272, 264162, 255505, 264270, 264546, 263914, 264268, 264606, 264409, 264442, 143246, 264476, 263911, 264263, 263908, 264260, 264544, 264257, 263905, 183836, 264407, 250605, 255503, 264474, 263897, 264246, 264237, 261557, 262211, 264232, 264373, 264401, 264229, 264370, 264227, 262234, 263893, 264170, 264221, 263890, 264158, 262227, 262225, 263621, 253582, 263766, 258244, 263764, 263797, 263619, 261632, 263762, 253576, 263617, 261553, 254380, 263577, 202713, 262208, 254664, 263546, 254378, 261549, 263336, 262206, 263242, 255497, 263237, 255495, 263215, 262959, 262949, 250603, 255493, 262198, 263006, 255490, 262955, 255488, 253571, 262077, 262194, 262405, 261544, 261542, 261541, 261538, 261530, 255486, 262488, 262395, 262431, 262191, 262469, 262411, 208104, 253569, 262372, 262098, 262185, 255484, 262180, 262176, 262172, 255482, 261522, 262170, 261520, 261516, 261513, 253177, 261509, 250601, 250600, 250950, 261601, 261645, 261596, 258661, 261506, 261503, 261501, 250591, 259969, 261499, 250588, 96784, 117555, 259962, 259957, 260527, 142958, 259954, 259813, 259811, 258125, 258123, 258120, 258118, 258741, 258115, 258721, 258719, 250579, 258113, 258598, 258595, 258109, 258105, 258321, 258103, 250576, 258100, 257927, 258098, 258092, 258091, 257922, 258084, 258069, 257783, 257852, 256870, 160695, 257614, 257744, 257612, 256798, 256935, 194928, 194927, 256866, 256931, 256863, 256923, 222626, 256921, 253561, 256860, 117544, 160690, 256794, 160689, 256899, 255480, 253559, 165409, 255477, 194926, 255473, 142944, 255468, 255407, 142942, 255465, 142936, 255460, 256083, 194925, 255428, 255458, 255400, 254662, 255814, 255455, 255810, 255808, 255442, 255007, 255452, 255438, 255416, 255005, 204597, 255397, 254661, 254658, 254656, 253557, 254654, 117530, 254648, 253550, 254630, 254338, 253182, 253544, 253539, 253537, 253525, 254325, 253833, 222073, 249945, 251009, 253830, 222070, 247877, 249942, 250999, 247872, 250572, 250571, 96770, 249940, 250994, 250802, 250734, 250800, 96768, 249936, 249267, 247869, 117510, 249492, 249263, 248700, 249293, 117504, 248698, 204246, 247863, 36841, 222621, 204239, 203206, 204232, 143229, 204218, 247853, 248696, 222613, 247848, 204212, 181818, 248076, 247923, 247819, 247464, 248069, 247973, 222681, 222597, 222594, 181814, 222590, 222676, 222528, 222587, 208475, 222064, 222079, 222059, 142883, 117489, 208285, 207930, 208148, 207048, 207067, 207045, 204736, 207374, 207061, 203918, 207013, 207059, 203417, 203196, 201865, 202277, 203194, 185820, 203243, 203192, 202764, 203241, 202879, 202273, 202759, 202757, 202771, 202872, 202268, 202869, 202753, 202192, 201957, 202032, 202224, 202011, 201726, 202466, 202342, 202738, 152227, 202007, 201720, 185817, 201373, 201955, 120795, 201838, 202027, 165394, 201712, 202003, 202059, 201965, 201827, 201771, 201697, 201820, 120734, 120732, 120722, 120716, 201474, 201500, 201467, 120709, 192628, 120706, 136980, 192625, 201350, 194733, 136977, 120696, 117465, 201251, 120690, 194924, 190853, 192332, 193841, 192616, 143203, 120670, 120069, 194824, 194923, 195052, 120638, 142841, 194817, 195005, 193839, 120630, 142838, 194937, 183528, 152212, 195003, 194921, 194814, 194900, 193837, 194954, 195040, 142836, 194811, 193835, 194898, 194711, 194562, 194800, 193833, 194704, 120616, 143185, 194002, 193827, 193471, 194000, 194304, 143183, 120613, 194147, 120605, 194143, 120599, 193861, 194139, 193821, 120594, 117459, 160667, 193859, 194176, 192903, 160665, 193877, 194135, 193818, 193507, 117452, 189961, 160650, 184752, 193501, 160647, 184746, 187124, 192201, 192902, 184742, 193416, 143175, 192913, 165389, 187119, 192898, 192893, 117447, 187117, 192655, 192834, 142812, 187113, 192651, 192014, 192012, 192638, 192721, 192010, 192717, 192632, 191026, 192537, 192209, 192594, 191023, 186012, 191586, 191016, 187109, 191445, 192048, 191037, 191971, 191021, 161634, 191011, 191031, 191113, 191009, 191029, 191043, 183339, 164361, 191109, 191076, 191099, 190845, 190417, 190843, 190414, 190930, 190097, 190325, 190537, 184071, 96754, 190378, 190412, 190375, 190309, 189158, 190348, 190298, 184152, 120586, 188179, 187877, 188271, 188059, 188175, 187874, 120559, 184149, 187105, 187954, 120557, 185959, 187695, 187407, 187863, 187404, 182647, 185956, 185805, 187283, 185953, 187402, 187400, 185951, 187341, 184125, 185539, 185073, 184940, 185087, 184123, 185522, 185071, 185506, 183190, 185056, 185054, 185052, 185051, 185388, 184052, 181999, 183512, 174898, 184030, 184113, 184204, 184110, 183330, 161630, 174894, 184004, 181809, 183326, 181807, 183551, 183653, 183673, 183169, 183352, 183323, 181992, 182585, 174853, 181804, 183212, 183348, 183321, 181988, 182567, 174847, 181802, 175493, 174844, 181800, 175491, 182382, 183207, 183109, 181786, 175577, 182128, 181747, 181745, 181796, 161927, 181743, 170360, 182009, 181974, 182125, 182149, 182143, 181732, 181728, 181793, 181720, 181712, 161922, 174838, 161920, 157911, 174830, 175569, 175486, 175566, 174828, 175484, 175482, 174818, 172757, 173848, 174766, 174804, 174802, 174974, 174798, 174763, 172874, 174795, 172809, 174690, 174729, 174754, 174681, 174650, 164451, 173712, 172794, 173481, 173839, 172910, 173474, 170747, 150228, 160637, 173470, 170744, 160630, 173536, 170243, 172998, 170241, 173091, 173089, 173460, 142803, 155216, 170742, 142799, 170234, 172751, 142793, 172747, 170821, 48351, 172744, 172741, 172671, 169566, 172736, 169564, 172798, 172818, 170032, 172851, 172644, 172804, 172729, 169562, 172642, 172517, 172306, 157959, 172512, 172400, 172351, 172283, 172323, 172212, 172180, 169558, 170740, 169556, 170738, 96743, 171242, 171302, 169167, 169552, 170483, 170479, 170724, 170705, 170722, 170698, 170473, 167149, 170463, 170458, 167145, 170451, 170058, 170016, 167708, 167705, 169972, 167699, 169608, 167693, 165269, 117425, 169261, 168307, 151046, 168750, 168304, 168301, 167010, 162331, 168299, 162328, 167007, 167126, 167506, 168515, 167981, 168150, 167259, 168207, 167312, 167979, 167118, 167991, 167989, 167116, 167977, 167307, 166767, 167635, 166762, 167111, 164757, 167108, 167270, 117414, 167106, 117410, 166843, 167100, 167256, 164749, 117406, 165892, 164739, 166622, 166558, 166645, 166617, 166496, 166418, 160615, 164731, 166612, 162737, 165889, 160612, 166089, 166549, 164728, 165260, 164723, 164716, 160606, 164713, 160601, 165968, 164709, 164705, 165963, 160599, 165882, 117405, 163673, 165955, 163670, 164833, 164679, 165704, 164831, 165041, 164826, 163917, 163775, 160594, 165004, 163666, 164836, 164654, 163813, 160587, 163662, 160566, 161596, 162089, 160560, 161914, 161577, 160551, 159986, 117376, 117374, 153382, 160530, 161042, 117373, 160499, 160827, 159962, 160496, 160467, 159957, 160465, 160463, 160456, 158531, 160452, 160424, 158520, 159672, 157780, 158514, 159549, 117365, 158504, 159296, 158502, 159041, 159025, 159037, 159019, 158498, 156532, 154285, 155816, 156530, 152622, 156981, 157571, 156472, 153370, 96139, 100154, 156465, 156462, 96136, 152110, 156460, 121537, 154205, 154590, 156454, 154202, 121533, 157001, 156441, 157004, 155733, 155861, 156392, 155601, 156389, 117358, 155859, 154166, 156386, 156384, 155673, 154152, 155855, 154140, 152108, 154110, 154102, 155099, 154100, 150886, 150882, 152776, 154096, 153322, 152094, 153356, 152716, 153353, 152706, 153268, 153243, 153319, 152689, 153264, 151257, 150942, 151146, 149570, 150530, 150259, 148030, 148126, 148462, 149495, 148501, 147683, 147451, 147623, 146930, 145647, 141953, 143659, 144374, 144761, 141951, 137197, 141306, 142069, 142473, 128335, 141615, 141608, 128332, 128329, 141301, 141367, 138154, 139623, 138151, 139645, 123095, 128323, 118364, 122682, 137388, 136063, 137182, 117287, 136030, 133792, 136024, 137179, 135959, 136322, 123964, 135952, 136154, 135927, 82583, 133785, 135868, 133683, 135613, 122671, 133777, 135268, 135092, 135090, 89142, 127479, 133672, 129659, 135088, 133670, 129657, 126105, 88140, 133681, 123949, 133679, 120, 133627, 133822, 133554, 133757, 130198, 130144, 127020, 121075, 127018, 130139, 127016, 129611, 79876, 123779, 130136, 118003, 123543, 123776, 129598, 129689, 128315, 123773, 121556, 121553, 125680, 123771, 123392, 125677, 117998, 125672, 116378, 116646, 112731, 112887, 112791, 97346, 112426, 112102, 112406, 82574, 112298, 112100, 112093, 111501, 100921, 24199, 111740, 112044, 111862, 111881, 109502, 111351, 111822, 111867, 111499, 96706, 97259, 111736, 111469, 111498, 101302, 111635, 111011, 111626, 111551, 111489, 111512, 111478, 111476, 111449, 82569, 111007, 111474, 111416, 97243, 111439, 111436, 96702, 102819, 24189, 101299, 83151, 109288, 101209, 101207, 111358, 111043, 109286, 111041, 103227, 102889, 103049, 102457, 101081, 85883, 88933, 82563, 73724, 99008, 93454, 99005, 88974, 98239, 97638, 97636, 97696, 97692))
Run Time: 0.167463
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3456 | |
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 | | | | | 3456 | |
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 (29536, 26263, 25734, 23072, 21480, 19230, 19119, 18958, 18952, 18918, 18745, 18726, 18650, 18588, 18576, 18537, 18524, 18502, 18449, 18307, 18247, 18233, 18228, 18207, 18171, 18125, 18116, 18058, 17999, 17965, 17892, 17868, 17855, 17815, 17759, 17749, 17739, 17709, 17675, 17669, 17649, 17614, 17602, 17512, 17493, 17470, 17466, 17427, 17396, 17370, 17365, 17337, 17244, 17243, 17213, 17199, 17198, 17158, 17137, 17097, 17049, 17034, 16994, 16976, 16946, 16941, 16870, 16841, 16774, 16761, 16735, 16717, 16694, 16690, 16687, 16650, 16551, 16541, 16508, 16505, 16440, 16139, 16136, 16129, 16107, 16094, 16075, 15948, 15943, 15921, 15920, 15826, 15816, 15784, 15658, 15653, 15637, 15613, 15612, 15542, 15495, 15462, 15461, 15438, 15429, 15413, 15395, 15345, 15344, 15335, 15283, 15280, 15279, 15239, 15195, 15149, 15147, 15087, 15086, 15082, 15072, 15018, 14981, 14968, 14953, 14943, 14935, 14907, 14899, 14893, 14866, 14859, 14843, 14840, 14835, 14832, 14813, 14779, 14770, 14765, 14720, 14712, 14699, 14684, 14674, 14656, 14637, 14624, 14623, 14601, 14568, 14488, 14473, 14451, 14413, 14354, 14329, 14328, 14320, 14319, 14300, 14285, 14279, 14276, 14262, 14253, 14251, 14208, 14178, 14145, 14142, 14141, 14130, 14119, 14096, 14035, 14021, 14020, 14004, 13989, 13987, 13978, 13958, 13950, 13926, 13921, 13920, 13917, 13914, 13901, 13893, 13892, 13871, 13859, 13852, 13851, 13843, 13837, 13776, 13610, 13590, 13589, 13556, 13555, 13541, 13540, 13521, 13492, 13474, 13466, 13272, 13266, 13262, 13205, 13168, 13160, 13068, 13042, 12984, 12931, 12877, 12851, 12830, 12763, 12742, 12688, 12575, 12442, 12430, 12420, 12401, 12342, 12333, 12325, 12284, 12283, 12282, 12256, 12163, 12162, 12141, 12054, 12053, 12052, 12051, 12020, 12017, 11920, 11903, 11892, 11743, 11717, 11658, 11618, 11567, 11563, 11562, 11555, 11551, 11471, 11413, 11222, 11198, 11077, 11044, 10978, 10843, 10797, 10784, 10648, 10643, 10596, 10432, 9816, 9688, 9630, 9550, 9533, 9335, 8444, 8389, 8240, 8101))
Run Time: 0.013418
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 283 | 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 (565961, 565959, 565768, 312441, 512134, 511853, 512132, 492787, 488488, 489769, 377859, 487043, 487041, 487039, 487035, 487033, 486282, 486280, 258702, 480259, 480256, 472319, 472317, 470953, 468097, 468094, 467821, 465815, 377853, 462510, 377852, 455186, 455184, 413838, 273363, 408907, 369815, 401450, 117673, 386181, 117669, 388384, 385553, 367947, 384949, 384947, 384945, 384727, 384081, 384068, 382902, 302344, 381228, 381308, 379598, 379594, 379590, 377844, 379443, 377842, 377840, 377839, 370549, 378592, 378955, 378732, 377379, 378499, 377376, 378600, 378561, 377837, 377373, 377835, 377365, 377833, 377831, 377649, 16631, 377287, 377361, 377646, 377664, 377359, 377236, 377357, 377233, 376703, 117665, 302336, 373001, 370540, 375481, 375480, 374299, 375400, 371387, 369794, 375374, 375372, 371384, 117662, 374353, 369790, 287703, 373381, 372261, 372857, 302332, 372418, 372854, 372580, 370882, 366860, 117658, 371239, 372258, 370916, 371345, 371237, 370914, 371264, 370751, 365788, 370987, 371033, 365785, 370863, 370873, 314231, 370335, 370737, 370693, 370857, 370313, 370333, 258700, 370311, 370294, 370184, 334042, 370370, 369900, 258697, 370181, 366736, 370331, 16625, 370292, 370316, 370303, 370177, 258695, 370172, 370039, 369927, 258691, 369571, 369785, 369471, 369567, 258688, 354772, 367943, 258686, 367939, 301864, 368849, 301856, 368844, 364577, 273354, 363198, 367915, 366731, 364575, 363194, 367913, 366661, 366729, 364622, 364572, 365783, 367778, 366743, 366683, 364570, 365993, 365906, 365865, 365868, 365903, 203061, 296411, 353428, 364567, 296409, 364946, 364875, 362875, 273334, 364830, 273332, 364589, 364828, 364598, 117653, 364564, 364596, 340347, 364238, 117651, 273330, 96845, 117649, 355355, 16622, 355352, 355350, 363933, 363389, 355348, 117647, 355345, 363387, 355343, 363579, 355340, 363385, 273326, 355337, 355336, 359536, 117646, 342217, 359534, 355333, 363219, 342215, 342213, 304591, 363187, 362895, 203059, 357604, 362944, 362892, 362866, 342211, 302329, 360907, 302327, 360905, 117645, 203053, 302323, 361715, 361679, 361677, 360899, 361128, 360363, 359262, 361119, 360890, 360361, 96843, 359260, 360886, 360883, 359258, 360879, 360874, 80983, 360872, 360981, 355330, 359532, 357925, 80981, 360979, 360870, 356920, 360617, 339843, 357921, 359595, 339839, 357917, 357174, 339837, 358927, 359657, 359593, 339835, 359589, 359587, 359656, 359654, 359652, 359650, 358923, 359253, 359585, 359250, 359384, 357788, 359244, 359242, 354769, 356176, 356174, 357120, 354602, 160226, 350745, 357784, 356170, 357783, 350743, 357549, 350741, 357545, 357543, 353990, 350739, 356155, 357171, 356918, 117639, 355159, 16620, 356152, 356151, 357108, 353669, 357169, 357104, 356146, 356916, 353657, 354586, 8070, 355327, 8068, 8064, 355325, 350737, 350735, 353969, 117638, 355398, 355314, 355052, 117636, 353187, 353966, 355312, 354760, 354274, 354867, 354757, 354269, 354592, 354646, 354644, 354753, 354133, 203043, 8063, 8061, 253690, 352726, 354279, 354310, 353642, 253688, 350832, 271722, 353639, 8059, 8057, 353637, 302321, 353784, 36920, 350966, 353482, 339171, 353276, 350697, 353479, 353525, 353184, 352535, 353177, 305133, 346467, 253682, 353174, 352538, 352531, 352529, 117634, 350631, 351428, 271720, 351426, 340417, 351660, 350629, 351424, 351421, 340415, 352047, 352039, 352045, 351536, 351496, 351417, 351737, 351658, 350626, 351782, 340413, 338877, 351493, 351409, 350958, 351490, 351203, 348447, 350684, 340411, 340407, 350624, 350828, 350826, 350620, 340405, 350617, 350824, 350615, 350695, 350613, 350822, 350351, 350681, 350609, 350349, 349910, 349907, 349904, 349903, 349896, 349894, 349966, 346952, 346948, 349351, 340402, 346947, 348761, 271716, 341344, 348425, 348640, 349350, 346944, 349241, 348755, 346941, 346939, 348423, 346935, 346933, 348429, 346932, 346931, 348443, 346930, 346018, 348386, 348384, 348434, 346928, 345951, 346926, 345949, 345945, 345944, 346925, 267386, 346924, 345943, 345940, 346921, 347107, 347691, 347690, 347521, 347104, 347216, 345816, 338465, 347097, 342369, 338464, 346430, 345937, 345935, 346976, 346428, 346918, 345930, 345928, 347092, 345925, 346510, 345923, 345811, 346493, 253672, 346903, 346425, 345919, 345036, 346491, 346508, 346915, 345916, 345033, 345030, 345915, 345914, 346670, 345912, 346454, 346488, 346502, 312438, 345910, 253663, 345907, 345901, 345180, 345892, 345822, 345177, 345820, 345170, 345169, 345164, 342366, 345163, 345162, 345159, 344337, 345153, 299014, 345069, 342364, 345096, 345067, 345093, 342355, 344334, 344328, 344846, 344637, 344319, 342342, 344816, 338549, 344844, 328531, 344634, 344310, 253653, 253650, 344630, 328527, 344298, 328524, 344294, 328521, 343978, 343773, 343939, 302943, 299081, 340317, 343937, 343975, 343935, 342339, 342337, 312431, 342335, 253646, 343761, 312427, 343578, 343573, 312425, 342333, 117632, 343211, 342896, 117627, 312423, 342893, 338461, 338459, 339376, 339371, 338453, 253642, 338448, 342306, 302933, 338447, 342588, 338444, 342331, 338442, 338440, 342309, 342304, 341223, 341945, 338875, 253635, 341221, 341804, 341342, 329100, 341818, 341219, 339164, 340312, 340704, 340817, 338873, 340683, 113162, 340701, 340813, 340740, 340690, 339350, 340601, 340381, 340399, 340339, 340354, 340352, 340357, 339885, 340095, 339975, 339409, 339880, 339854, 339852, 339879, 339859, 339334, 339849, 339878, 339872, 339813, 342224, 339367, 339325, 339406, 338869, 338867, 339404, 339160, 334933, 339425, 339155, 339314, 339306, 339302, 339361, 339299, 339088, 339184, 339151, 339084, 338350, 339081, 97755, 338348, 338175, 338173, 338746, 338799, 338171, 338438, 338169, 338639, 68581, 307600, 307312, 338545, 300693, 306881, 300691, 334032, 300689, 300686, 96826, 329091, 329088, 329086, 335048, 338165, 337899, 328519, 338151, 329084, 328517, 334348, 328515, 334346, 337865, 328513, 335024, 328511, 335022, 337713, 334344, 328509, 334342, 335019, 334339, 335017, 337446, 337235, 337233, 335015, 337231, 336841, 336839, 336797, 334337, 328507, 336411, 332082, 335829, 335816, 335814, 332080, 332078, 332074, 334922, 334326, 96820, 335043, 335039, 334944, 335010, 334913, 96818, 334893, 334942, 335007, 96816, 334911, 334939, 334928, 334334, 96813, 334754, 334332, 306356, 334329, 306353, 306350, 332068, 306348, 333100, 306345, 332980, 306342, 328982, 332066, 333092, 117616, 332038, 332154, 332306, 327358, 327294, 327356, 321812, 327082, 327354, 327292, 327288, 321901, 16604, 326600, 127068, 36899, 36895, 326404, 326807, 318425, 326598, 319895, 318694, 319893, 318688, 312109, 321954, 318684, 321948, 318682, 326423, 321332, 319891, 326351, 326347, 326344, 324453, 301447, 319835, 180303, 262983, 321898, 301444, 321734, 316800, 301440, 301436, 321896, 325454, 318603, 301434, 301431, 321894, 318600, 318598, 325240, 318597, 311104, 321892, 301429, 319887, 318594, 322973, 301427, 323657, 318591, 322967, 321890, 321880, 304027, 321875, 321878, 321724, 318588, 318586, 319884, 320202, 321729, 321536, 321298, 318585, 321715, 314916, 321282, 321524, 321517, 321384, 83199, 321369, 18310, 321322, 320199, 320176, 321328, 321279, 320172, 320197, 284477, 208066, 262380, 321296, 304025, 319326, 320133, 318583, 319323, 318577, 320115, 304021, 302316, 319969, 318575, 16596, 310854, 317015, 318571, 319852, 319846, 319647, 319822, 287693, 319816, 319641, 28584, 319825, 287691, 319319, 319318, 319442, 318562, 319316, 96801, 319573, 318559, 319438, 319314, 319336, 319312, 319307, 310848, 319031, 319296, 310845, 318936, 319029, 287689, 319156, 316191, 319150, 317539, 319024, 319147, 319013, 318925, 318678, 312032, 318677, 318948, 183958, 318797, 318655, 318651, 318555, 318618, 318551, 318437, 183955, 318450, 299075, 312029, 312026, 290717, 304017, 312024, 304015, 312022, 317013, 317531, 317487, 299072, 317010, 317008, 36892, 304013, 304011, 304010, 304005, 299070, 304001, 296381, 316794, 313782, 311881, 316772, 316188, 316769, 270578, 270576, 270573, 270571, 311326, 316021, 313778, 316018, 316013, 314995, 314203, 314201, 314911, 314216, 311101, 313909, 314213, 314211, 313473, 306334, 314199, 270555, 314334, 314162, 313553, 314194, 306302, 310830, 314064, 314057, 270553, 312884, 270551, 271696, 313706, 313524, 312882, 313905, 302305, 313999, 313903, 311180, 313899, 313798, 313470, 313796, 270548, 313801, 270545, 302300, 311176, 302296, 302294, 18305, 271694, 300701, 204866, 313522, 300555, 310827, 313697, 313517, 310821, 300553, 310815, 300551, 310813, 296301, 300547, 313277, 310809, 313513, 311174, 313466, 18304, 183949, 311172, 302292, 299067, 299065, 312910, 310760, 306879, 270542, 310755, 312354, 290714, 310753, 302288, 307755, 312879, 312804, 312712, 183946, 301420, 270539, 270537, 302285, 299064, 301416, 312335, 307753, 302283, 312192, 312493, 312491, 302281, 312421, 312420, 312489, 312020, 312418, 312358, 312018, 312356, 312188, 311100, 270535, 312186, 311262, 310745, 311096, 311094, 301412, 270533, 312166, 312164, 312093, 270530, 270527, 312105, 312102, 312091, 302278, 311952, 310726, 302276, 311840, 310724, 310717, 311162, 310705, 311672, 311159, 306877, 310701, 306330, 311794, 310699, 311788, 310696, 311154, 311687, 311471, 311435, 311433, 311150, 310692, 310436, 311144, 160729, 310591, 311140, 311139, 311135, 302273, 311132, 311283, 311252, 311125, 299501, 306875, 301409, 299498, 310680, 311068, 299496, 310586, 299493, 310584, 310589, 301407, 306870, 307785, 306867, 310405, 310408, 307779, 267380, 306850, 308192, 307740, 306845, 267373, 307774, 303997, 307772, 306836, 302270, 267361, 306834, 308183, 307738, 308196, 307593, 303889, 307729, 306687, 307727, 267357, 306685, 305013, 303887, 301403, 307591, 303885, 307618, 267354, 267348, 303880, 301401, 307615, 307330, 305011, 307589, 307613, 299058, 307286, 299050, 303876, 306683, 307306, 303872, 306681, 307284, 307328, 34650, 307299, 307332, 299195, 267340, 307289, 270523, 307207, 267332, 267328, 267326, 34646, 300699, 267322, 303866, 267320, 307030, 306738, 307040, 305367, 267318, 307036, 306825, 307028, 307033, 306916, 306317, 267313, 304855, 267309, 303862, 306820, 267306, 304852, 303859, 34643, 306731, 306713, 34638, 270518, 305223, 306674, 306552, 18299, 305745, 306548, 18297, 306559, 305429, 306545, 305221, 306135, 305116, 305113, 306312, 117609, 306308, 303538, 305108, 117607, 305549, 304850, 117605, 305104, 305384, 305383, 303943, 305498, 305516, 305255, 304841, 202313, 270510, 305218, 290032, 305230, 305377, 305374, 305352, 305213, 305009, 305228, 303936, 305289, 302381, 304897, 302916, 202307, 302913, 304814, 202305, 304892, 302911, 202302, 301395, 303856, 290029, 304460, 202299, 301391, 303854, 303852, 202296, 290027, 304458, 304549, 303929, 303821, 287383, 303850, 302453, 303741, 284990, 303848, 202293, 303816, 303924, 303846, 202291, 303796, 303812, 303919, 302379, 303844, 302450, 92881, 302159, 303810, 303793, 92876, 302152, 303731, 302150, 302511, 303719, 287449, 303723, 303743, 299183, 297499, 303729, 302148, 3069, 302448, 287447, 202287, 302142, 302908, 303520, 302951, 302140, 302407, 302101, 302138, 303518, 302948, 302099, 302509, 301367, 302131, 302503, 284986, 302404, 302441, 297000, 302095, 302414, 302266, 302114, 301751, 302396, 299560, 301364, 300663, 302090, 264649, 302111, 301745, 299178, 301334, 299160, 301947, 301652, 299558, 301107, 301106, 299253, 301944, 285025, 301649, 300966, 301871, 300659, 301554, 301362, 287443, 299046, 287441, 301360, 301563, 301647, 300657, 301757, 288477, 300870, 301332, 160727, 301084, 300652, 301356, 300863, 301330, 160723, 300649, 301082, 301238, 301350, 301226, 301345, 301080, 301223, 300647, 301012, 301220, 300964, 301077, 301010, 300962, 300960, 300644, 299596, 301008, 192660, 301125, 297333, 300958, 297521, 301103, 301116, 300682, 160720, 300642, 300853, 300851, 290119, 300719, 299251, 300848, 300846, 300635, 300857, 300680, 300743, 300678, 299248, 300676, 300675, 300581, 300630, 300672, 300671, 184884, 192658, 300668, 300716, 300666, 300544, 296367, 300536, 299590, 299035, 299242, 300592, 300542, 299587, 300502, 299030, 299028, 284376, 300534, 298903, 300455, 299023, 284374, 300494, 298901, 300451, 290021, 300449, 299485, 299483, 299575, 300293, 86518, 299481, 299700, 299475, 299229, 299568, 299691, 299689, 299238, 299473, 299427, 299566, 297291, 86516, 299226, 299555, 299563, 86514, 160717, 299425, 290014, 288114, 160715, 296992, 264642, 290008, 264638, 299234, 299176, 299222, 296990, 299174, 299198, 299204, 290005, 299220, 299021, 299152, 299019, 299008, 298896, 117594, 289998, 298990, 289996, 298166, 297277, 289993, 298971, 298940, 289991, 289989, 298925, 298885, 298883, 298880, 298870, 296879, 298827, 298789, 298315, 298725, 160710, 264633, 298273, 298435, 263357, 297709, 298785, 298722, 297375, 298720, 298718, 298674, 298431, 298422, 298267, 298238, 298310, 298301, 297259, 297257, 117592, 296358, 297238, 287495, 267293, 267291, 298199, 297529, 297360, 297358, 298232, 298220, 298229, 288093, 298164, 298181, 287687, 298169, 298179, 298066, 295429, 297233, 297231, 287492, 297725, 296286, 297701, 297678, 296284, 297354, 295427, 297226, 297490, 297518, 297523, 297488, 59450, 297224, 297351, 297247, 288090, 295572, 297481, 297369, 296986, 297410, 295806, 288088, 297390, 297309, 288084, 297349, 297245, 297302, 297242, 295425, 296982, 295422, 295571, 287488, 297067, 297024, 297022, 288081, 117590, 297018, 296441, 296980, 264568, 296131, 264564, 296438, 264562, 264560, 296129, 264558, 295419, 296436, 296352, 296318, 296127, 295417, 295805, 295415, 287685, 287509, 117589, 287485, 287507, 293733, 295970, 296096, 287809, 288110, 287752, 295123, 295568, 295120, 287750, 295563, 295968, 295558, 288106, 295918, 295548, 295546, 295118, 287747, 284984, 295542, 295536, 287745, 295116, 253619, 288079, 287197, 295786, 291642, 295413, 287193, 288076, 153927, 295513, 293843, 290115, 294545, 277808, 295525, 295112, 253617, 277806, 117587, 294531, 290111, 293763, 295109, 288074, 295437, 295435, 287191, 290109, 295411, 151421, 287188, 295433, 287186, 295408, 295443, 295450, 287184, 287182, 295106, 287743, 277803, 295160, 295103, 294749, 293841, 295006, 287741, 294744, 271685, 294529, 294899, 294527, 253613, 293839, 293837, 294543, 282982, 294526, 294433, 288501, 291904, 288068, 121876, 289856, 291542, 294390, 293833, 293829, 264367, 291538, 287483, 293806, 264365, 290094, 293755, 253611, 277799, 291522, 18273, 287737, 287481, 291534, 264362, 292188, 291636, 264359, 264357, 288730, 288727, 264354, 287477, 290326, 201392, 290702, 290605, 290148, 290324, 290246, 289721, 282873, 288694, 288065, 287379, 287807, 287475, 287729, 290146, 264734, 290050, 290061, 104564, 277795, 290047, 288720, 289979, 289732, 289985, 289291, 289289, 277793, 28565, 289286, 289734, 289730, 289713, 289284, 288698, 289711, 287473, 117579, 204301, 271683, 285227, 287948, 264352, 288718, 288505, 288714, 289232, 264349, 288313, 288712, 204298, 96796, 264347, 288064, 288661, 288474, 288665, 277791, 287726, 288650, 287724, 288311, 288472, 288292, 264344, 253604, 287377, 287721, 288290, 288610, 288470, 288308, 264342, 288139, 288487, 288063, 284563, 28561, 288287, 287375, 288284, 273118, 287626, 287717, 288126, 287714, 288096, 104534, 287711, 104532, 287803, 287946, 164, 264339, 270713, 123433, 287800, 287708, 162, 287369, 278292, 287467, 287706, 160, 287402, 286589, 282823, 285883, 253601, 287555, 287364, 284871, 287614, 287463, 287539, 287398, 271676, 282820, 253596, 287461, 287352, 287497, 287210, 287179, 287458, 287425, 271674, 287419, 264333, 287422, 287456, 253593, 282677, 287356, 264331, 270265, 287347, 287395, 271672, 270628, 152335, 282673, 271670, 287345, 264329, 284472, 285867, 282669, 285728, 285658, 203018, 284754, 286584, 285725, 287176, 285721, 284981, 253587, 282662, 285718, 282660, 282657, 285945, 271667, 285923, 284469, 285715, 285878, 271665, 285921, 285890, 285875, 285853, 277785, 283765, 284852, 285861, 285687, 282705, 284748, 285648, 284850, 285018, 285223, 268788, 278290, 284868, 283763, 278288, 277705, 285235, 284746, 278286, 285012, 284862, 284483, 284860, 285010, 285014, 273101, 285058, 3059, 284848, 284765, 285022, 284980, 277773, 284844, 284762, 284977, 284842, 282627, 284742, 282625, 277765, 261885, 261883, 284463, 3055, 282695, 272893, 284460, 284594, 282623, 278283, 284500, 282914, 284440, 284479, 282650, 201381, 284438, 284365, 282817, 284421, 282868, 284362, 282815, 284209, 278281, 97751, 279675, 97749, 271919, 279981, 75739, 283761, 282866, 278278, 277762, 278276, 283131, 268746, 282812, 282810, 282688, 278148, 277756, 279692, 279526, 273168, 279524, 282613, 271660, 282610, 277754, 282648, 279973, 269616, 282605, 279600, 278272, 250614, 279439, 279688, 279131, 278269, 250610, 279685, 279437, 279597, 279429, 273166, 34633, 279594, 279592, 273164, 273162, 279519, 278267, 277748, 279516, 279435, 276515, 278140, 279128, 277744, 273160, 277742, 34629, 270705, 279126, 34626, 34623, 278264, 273099, 277736, 278261, 277695, 278251, 277692, 277722, 278138, 277684, 117576, 277538, 274771, 160707, 273564, 277536, 273562, 277534, 273546, 277162, 258352, 277099, 160705, 160703, 274764, 117574, 275667, 274723, 271651, 273418, 274653, 273416, 271648, 274079, 273413, 273176, 273174, 273558, 189730, 273151, 273095, 273541, 273199, 273093, 273187, 273147, 273196, 273156, 270774, 273085, 273083, 269785, 272888, 271646, 272869, 271644, 272864, 271642, 271638, 271636, 272862, 259592, 271634, 271632, 265186, 271630, 271628, 270772, 271626, 271624, 271557, 269783, 271622, 270742, 271543, 271616, 271007, 271592, 271589, 271522, 270740, 262102, 271213, 270736, 268774, 269778, 269774, 271210, 269771, 258349, 96793, 271272, 270965, 269769, 271304, 96791, 271208, 271267, 269766, 270732, 269760, 269758, 270626, 271202, 270701, 269755, 271085, 271188, 258675, 270802, 271089, 269751, 270810, 269749, 271002, 270698, 270944, 270963, 270989, 270771, 270324, 269746, 270942, 270696, 270961, 270800, 270218, 269742, 270216, 270770, 270624, 270690, 269740, 270687, 268772, 270685, 269734, 269732, 270593, 270716, 270681, 268767, 270671, 269909, 270676, 267154, 269907, 270322, 270669, 268763, 269905, 270597, 267151, 270590, 270622, 269903, 269901, 269711, 270588, 262975, 270585, 270491, 270291, 270049, 270212, 269926, 269894, 269728, 270183, 266569, 269548, 269794, 270093, 269585, 270107, 269708, 270145, 269634, 269792, 269959, 269383, 269722, 269719, 269716, 267149, 269701, 263931, 269627, 262217, 203821, 264324, 269286, 264321, 269282, 268002, 268001, 269172, 268477, 268742, 268738, 267285, 268735, 268750, 268733, 267943, 268390, 266173, 267939, 268387, 267934, 267933, 267926, 268033, 268385, 267914, 267144, 263773, 143248, 254666, 266170, 96181, 264906, 264811, 264860, 255511, 264708, 264301, 264792, 264297, 255509, 264807, 264827, 255507, 264414, 264295, 264663, 117568, 264282, 263920, 264787, 264446, 264480, 264771, 264765, 264444, 264657, 264478, 264700, 264276, 263916, 264272, 264162, 255505, 264270, 264546, 263914, 264268, 264606, 264409, 264442, 143246, 264476, 263911, 264263, 263908, 264260, 264544, 264257, 263905, 183836, 264407, 250605, 255503, 264474, 263897, 264246, 264237, 261557, 262211, 264232, 264373, 264401, 264229, 264370, 264227, 262234, 263893, 264170, 264221, 263890, 264158, 262227, 262225, 263621, 253582, 263766, 258244, 263764, 263797, 263619, 261632, 263762, 253576, 263617, 261553, 254380, 263577, 202713, 262208, 254664, 263546, 254378, 261549, 263336, 262206, 263242, 255497, 263237, 255495, 263215, 262959, 262949, 250603, 255493, 262198, 263006, 255490, 262955, 255488, 253571, 262077, 262194, 262405, 261544, 261542, 261541, 261538, 261530, 255486, 262488, 262395, 262431, 262191, 262469, 262411, 208104, 253569, 262372, 262098, 262185, 255484, 262180, 262176, 262172, 255482, 261522, 262170, 261520, 261516, 261513, 253177, 261509, 250601, 250600, 250950, 261601, 261645, 261596, 258661, 261506, 261503, 261501, 250591, 259969, 261499, 250588, 96784, 117555, 259962, 259957, 260527, 142958, 259954, 259813, 259811, 258125, 258123, 258120, 258118, 258741, 258115, 258721, 258719, 250579, 258113, 258598, 258595, 258109, 258105, 258321, 258103, 250576, 258100, 257927, 258098, 258092, 258091, 257922, 258084, 258069, 257783, 257852, 256870, 160695, 257614, 257744, 257612, 256798, 256935, 194928, 194927, 256866, 256931, 256863, 256923, 222626, 256921, 253561, 256860, 117544, 160690, 256794, 160689, 256899, 255480, 253559, 165409, 255477, 194926, 255473, 142944, 255468, 255407, 142942, 255465, 142936, 255460, 256083, 194925, 255428, 255458, 255400, 254662, 255814, 255455, 255810, 255808, 255442, 255007, 255452, 255438, 255416, 255005, 204597, 255397, 254661, 254658, 254656, 253557, 254654, 117530, 254648, 253550, 254630, 254338, 253182, 253544, 253539, 253537, 253525, 254325, 253833, 222073, 249945, 251009, 253830, 222070, 247877, 249942, 250999, 247872, 250572, 250571, 96770, 249940, 250994, 250802, 250734, 250800, 96768, 249936, 249267, 247869, 117510, 249492, 249263, 248700, 249293, 117504, 248698, 204246, 247863, 36841, 222621, 204239, 203206, 204232, 143229, 204218, 247853, 248696, 222613, 247848, 204212, 181818, 248076, 247923, 247819, 247464, 248069, 247973, 222681, 222597, 222594, 181814, 222590, 222676, 222528, 222587, 208475, 222064, 222079, 222059, 142883, 117489, 208285, 207930, 208148, 207048, 207067, 207045, 204736, 207374, 207061, 203918, 207013, 207059, 203417, 203196, 201865, 202277, 203194, 185820, 203243, 203192, 202764, 203241, 202879, 202273, 202759, 202757, 202771, 202872, 202268, 202869, 202753, 202192, 201957, 202032, 202224, 202011, 201726, 202466, 202342, 202738, 152227, 202007, 201720, 185817, 201373, 201955, 120795, 201838, 202027, 165394, 201712, 202003, 202059, 201965, 201827, 201771, 201697, 201820, 120734, 120732, 120722, 120716, 201474, 201500, 201467, 120709, 192628, 120706, 136980, 192625, 201350, 194733, 136977, 120696, 117465, 201251, 120690, 194924, 190853, 192332, 193841, 192616, 143203, 120670, 120069, 194824, 194923, 195052, 120638, 142841, 194817, 195005, 193839, 120630, 142838, 194937, 183528, 152212, 195003, 194921, 194814, 194900, 193837, 194954, 195040, 142836, 194811, 193835, 194898, 194711, 194562, 194800, 193833, 194704, 120616, 143185, 194002, 193827, 193471, 194000, 194304, 143183, 120613, 194147, 120605, 194143, 120599, 193861, 194139, 193821, 120594, 117459, 160667, 193859, 194176, 192903, 160665, 193877, 194135, 193818, 193507, 117452, 189961, 160650, 184752, 193501, 160647, 184746, 187124, 192201, 192902, 184742, 193416, 143175, 192913, 165389, 187119, 192898, 192893, 117447, 187117, 192655, 192834, 142812, 187113, 192651, 192014, 192012, 192638, 192721, 192010, 192717, 192632, 191026, 192537, 192209, 192594, 191023, 186012, 191586, 191016, 187109, 191445, 192048, 191037, 191971, 191021, 161634, 191011, 191031, 191113, 191009, 191029, 191043, 183339, 164361, 191109, 191076, 191099, 190845, 190417, 190843, 190414, 190930, 190097, 190325, 190537, 184071, 96754, 190378, 190412, 190375, 190309, 189158, 190348, 190298, 184152, 120586, 188179, 187877, 188271, 188059, 188175, 187874, 120559, 184149, 187105, 187954, 120557, 185959, 187695, 187407, 187863, 187404, 182647, 185956, 185805, 187283, 185953, 187402, 187400, 185951, 187341, 184125, 185539, 185073, 184940, 185087, 184123, 185522, 185071, 185506, 183190, 185056, 185054, 185052, 185051, 185388, 184052, 181999, 183512, 174898, 184030, 184113, 184204, 184110, 183330, 161630, 174894, 184004, 181809, 183326, 181807, 183551, 183653, 183673, 183169, 183352, 183323, 181992, 182585, 174853, 181804, 183212, 183348, 183321, 181988, 182567, 174847, 181802, 175493, 174844, 181800, 175491, 182382, 183207, 183109, 181786, 175577, 182128, 181747, 181745, 181796, 161927, 181743, 170360, 182009, 181974, 182125, 182149, 182143, 181732, 181728, 181793, 181720, 181712, 161922, 174838, 161920, 157911, 174830, 175569, 175486, 175566, 174828, 175484, 175482, 174818, 172757, 173848, 174766, 174804, 174802, 174974, 174798, 174763, 172874, 174795, 172809, 174690, 174729, 174754, 174681, 174650, 164451, 173712, 172794, 173481, 173839, 172910, 173474, 170747, 150228, 160637, 173470, 170744, 160630, 173536, 170243, 172998, 170241, 173091, 173089, 173460, 142803, 155216, 170742, 142799, 170234, 172751, 142793, 172747, 170821, 48351, 172744, 172741, 172671, 169566, 172736, 169564, 172798, 172818, 170032, 172851, 172644, 172804, 172729, 169562, 172642, 172517, 172306, 157959, 172512, 172400, 172351, 172283, 172323, 172212, 172180, 169558, 170740, 169556, 170738, 96743, 171242, 171302, 169167, 169552, 170483, 170479, 170724, 170705, 170722, 170698, 170473, 167149, 170463, 170458, 167145, 170451, 170058, 170016, 167708, 167705, 169972, 167699, 169608, 167693, 165269, 117425, 169261, 168307, 151046, 168750, 168304, 168301, 167010, 162331, 168299, 162328, 167007, 167126, 167506, 168515, 167981, 168150, 167259, 168207, 167312, 167979, 167118, 167991, 167989, 167116, 167977, 167307, 166767, 167635, 166762, 167111, 164757, 167108, 167270, 117414, 167106, 117410, 166843, 167100, 167256, 164749, 117406, 165892, 164739, 166622, 166558, 166645, 166617, 166496, 166418, 160615, 164731, 166612, 162737, 165889, 160612, 166089, 166549, 164728, 165260, 164723, 164716, 160606, 164713, 160601, 165968, 164709, 164705, 165963, 160599, 165882, 117405, 163673, 165955, 163670, 164833, 164679, 165704, 164831, 165041, 164826, 163917, 163775, 160594, 165004, 163666, 164836, 164654, 163813, 160587, 163662, 160566, 161596, 162089, 160560, 161914, 161577, 160551, 159986, 117376, 117374, 153382, 160530, 161042, 117373, 160499, 160827, 159962, 160496, 160467, 159957, 160465, 160463, 160456, 158531, 160452, 160424, 158520, 159672, 157780, 158514, 159549, 117365, 158504, 159296, 158502, 159041, 159025, 159037, 159019, 158498, 156532, 154285, 155816, 156530, 152622, 156981, 157571, 156472, 153370, 96139, 100154, 156465, 156462, 96136, 152110, 156460, 121537, 154205, 154590, 156454, 154202, 121533, 157001, 156441, 157004, 155733, 155861, 156392, 155601, 156389, 117358, 155859, 154166, 156386, 156384, 155673, 154152, 155855, 154140, 152108, 154110, 154102, 155099, 154100, 150886, 150882, 152776, 154096, 153322, 152094, 153356, 152716, 153353, 152706, 153268, 153243, 153319, 152689, 153264, 151257, 150942, 151146, 149570, 150530, 150259, 148030, 148126, 148462, 149495, 148501, 147683, 147451, 147623, 146930, 145647, 141953, 143659, 144374, 144761, 141951, 137197, 141306, 142069, 142473, 128335, 141615, 141608, 128332, 128329, 141301, 141367, 138154, 139623, 138151, 139645, 123095, 128323, 118364, 122682, 137388, 136063, 137182, 117287, 136030, 133792, 136024, 137179, 135959, 136322, 123964, 135952, 136154, 135927, 82583, 133785, 135868, 133683, 135613, 122671, 133777, 135268, 135092, 135090, 89142, 127479, 133672, 129659, 135088, 133670, 129657, 126105, 88140, 133681, 123949, 133679, 120, 133627, 133822, 133554, 133757, 130198, 130144, 127020, 121075, 127018, 130139, 127016, 129611, 79876, 123779, 130136, 118003, 123543, 123776, 129598, 129689, 128315, 123773, 121556, 121553, 125680, 123771, 123392, 125677, 117998, 125672, 116378, 116646, 112731, 112887, 112791, 97346, 112426, 112102, 112406, 82574, 112298, 112100, 112093, 111501, 100921, 24199, 111740, 112044, 111862, 111881, 109502, 111351, 111822, 111867, 111499, 96706, 97259, 111736, 111469, 111498, 101302, 111635, 111011, 111626, 111551, 111489, 111512, 111478, 111476, 111449, 82569, 111007, 111474, 111416, 97243, 111439, 111436, 96702, 102819, 24189, 101299, 83151, 109288, 101209, 101207, 111358, 111043, 109286, 111041, 103227, 102889, 103049, 102457, 101081, 85883, 88933, 82563, 73724, 99008, 93454, 99005, 88974, 98239, 97638, 97636, 97696, 97692))
Run Time: 0.067415
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3456 | |
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 | | | | | 3456 | |
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 (29536, 26263, 25734, 23072, 21480, 19230, 19119, 18958, 18952, 18918, 18745, 18726, 18650, 18588, 18576, 18537, 18524, 18502, 18449, 18307, 18247, 18233, 18228, 18207, 18171, 18125, 18116, 18058, 17999, 17965, 17892, 17868, 17855, 17815, 17759, 17749, 17739, 17709, 17675, 17669, 17649, 17614, 17602, 17512, 17493, 17470, 17466, 17427, 17396, 17370, 17365, 17337, 17244, 17243, 17213, 17199, 17198, 17158, 17137, 17097, 17049, 17034, 16994, 16976, 16946, 16941, 16870, 16841, 16774, 16761, 16735, 16717, 16694, 16690, 16687, 16650, 16551, 16541, 16508, 16505, 16440, 16139, 16136, 16129, 16107, 16094, 16075, 15948, 15943, 15921, 15920, 15826, 15816, 15784, 15658, 15653, 15637, 15613, 15612, 15542, 15495, 15462, 15461, 15438, 15429, 15413, 15395, 15345, 15344, 15335, 15283, 15280, 15279, 15239, 15195, 15149, 15147, 15087, 15086, 15082, 15072, 15018, 14981, 14968, 14953, 14943, 14935, 14907, 14899, 14893, 14866, 14859, 14843, 14840, 14835, 14832, 14813, 14779, 14770, 14765, 14720, 14712, 14699, 14684, 14674, 14656, 14637, 14624, 14623, 14601, 14568, 14488, 14473, 14451, 14413, 14354, 14329, 14328, 14320, 14319, 14300, 14285, 14279, 14276, 14262, 14253, 14251, 14208, 14178, 14145, 14142, 14141, 14130, 14119, 14096, 14035, 14021, 14020, 14004, 13989, 13987, 13978, 13958, 13950, 13926, 13921, 13920, 13917, 13914, 13901, 13893, 13892, 13871, 13859, 13852, 13851, 13843, 13837, 13776, 13610, 13590, 13589, 13556, 13555, 13541, 13540, 13521, 13492, 13474, 13466, 13272, 13266, 13262, 13205, 13168, 13160, 13068, 13042, 12984, 12931, 12877, 12851, 12830, 12763, 12742, 12688, 12575, 12442, 12430, 12420, 12401, 12342, 12333, 12325, 12284, 12283, 12282, 12256, 12163, 12162, 12141, 12054, 12053, 12052, 12051, 12020, 12017, 11920, 11903, 11892, 11743, 11717, 11658, 11618, 11567, 11563, 11562, 11555, 11551, 11471, 11413, 11222, 11198, 11077, 11044, 10978, 10843, 10797, 10784, 10648, 10643, 10596, 10432, 9816, 9688, 9630, 9550, 9533, 9335, 8444, 8389, 8240, 8101))
Run Time: 0.007733
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 283 | 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, �V�
Run Time: 0.000325
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: �V�, XF\Pub\Controller\Member, RecentContent, valid, user_id=2179, 1716200863, , 0, �V�
Run Time: 0.000168
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000471
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.000545
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: 1716200563
Run Time: 0.000328
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` >= 1716200563)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000660
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