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.001259
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.000297
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` = '1907')
LIMIT 1
Run Time: 0.000836
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.002642
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_1907' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.063070
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 (444407, 444402, 591649, 589554, 589551, 579405, 531105, 625019, 530974, 245679, 245644, 576794, 526412, 577385, 468737, 468735, 468734, 530928, 577693, 577761, 468732, 576771, 576766, 434736, 369233, 530886, 314682, 314680, 530796, 530792, 314673, 434118, 434116, 574658, 575590, 530586, 575347, 572609, 37769, 572605, 569670, 569666, 572216, 572214, 571533, 569891, 314669, 569658, 570210, 365340, 564868, 565189, 565445, 564863, 564475, 330419, 564449, 563674, 549649, 624961, 535892, 549580, 549560, 549557, 555357, 555314, 529123, 529091, 551504, 528909, 321199, 321197, 545219, 545217, 325859, 543628, 545207, 545204, 200106, 351670, 232694, 232688, 544935, 408799, 544931, 110470, 544968, 110467, 200095, 318885, 544923, 543616, 543607, 543594, 543588, 526998, 528151, 535791, 537229, 528688, 243934, 243926, 528653, 624801, 528617, 365265, 428761, 463579, 365263, 325073, 322941, 521531, 325066, 521003, 514408, 323577, 512079, 512076, 199762, 512074, 512071, 489241, 323553, 493799, 491454, 324971, 421752, 324901, 408774, 409502, 355769, 324805, 359902, 408759, 409501, 408758, 414546, 414543, 323430, 408755, 324800, 197857, 318052, 411574, 400933, 414541, 416174, 414663, 414535, 322893, 318046, 329301, 324791, 323424, 324789, 414661, 414659, 414657, 414589, 197790, 324787, 414528, 324786, 216028, 409500, 414526, 414524, 408751, 240540, 240533, 408749, 240529, 413696, 413694, 240527, 412838, 412836, 380010, 197767, 412835, 413127, 412827, 412822, 412819, 412815, 324785, 408745, 409123, 197755, 228773, 379995, 379993, 324783, 379991, 375206, 110145, 110142, 410997, 375204, 410989, 324782, 324781, 197738, 410776, 324777, 408741, 324775, 379978, 240387, 396397, 324774, 324771, 409496, 409494, 405221, 409603, 409213, 409488, 324764, 409599, 240314, 409202, 393760, 408731, 408729, 408661, 330068, 408725, 408723, 408720, 408716, 408714, 408711, 324757, 408659, 408658, 324756, 240151, 197620, 197615, 408028, 215707, 228465, 240129, 407860, 322623, 324253, 322885, 240106, 357401, 324750, 324749, 323396, 324748, 325779, 324744, 322883, 324739, 402225, 402041, 324720, 323373, 349010, 379953, 329280, 324713, 323372, 323370, 228187, 110110, 239855, 239852, 239850, 323366, 323362, 383591, 323361, 400964, 239819, 401777, 401772, 401770, 401768, 401715, 324700, 228131, 325497, 239693, 239680, 323347, 329277, 400008, 324694, 325385, 239620, 324691, 322875, 323319, 325768, 359861, 359858, 359855, 359853, 318276, 314617, 395524, 392621, 397094, 397057, 393853, 396128, 396827, 379935, 227818, 171659, 322871, 379925, 379924, 379922, 379920, 379918, 379916, 379914, 379912, 379910, 379908, 393978, 379906, 379904, 323229, 324681, 393682, 325377, 323210, 393949, 393966, 393947, 366767, 366765, 366763, 393715, 366761, 324667, 324663, 392593, 325753, 391290, 323199, 323194, 391281, 322869, 375187, 354421, 348315, 385521, 285451, 238696, 354416, 238662, 303254, 349454, 238586, 324655, 324653, 349450, 382691, 324649, 238539, 378456, 333446, 378451, 378405, 360386, 378383, 365129, 378348, 370424, 379687, 379678, 379755, 196782, 379616, 379198, 309954, 378306, 324206, 376825, 322858, 373286, 369484, 106029, 324621, 324618, 188112, 324617, 180823, 324615, 180820, 349446, 180818, 363806, 366753, 366770, 366751, 366750, 366611, 366599, 324610, 322190, 324185, 322840, 363995, 363993, 65460, 324609, 237851, 363803, 237834, 363801, 365088, 365809, 365806, 322182, 365800, 261220, 364420, 363796, 365547, 349444, 365007, 365005, 365002, 363794, 365001, 347609, 363791, 363788, 329233, 324181, 303203, 303200, 324180, 110070, 364796, 359792, 357384, 364793, 364867, 322837, 322835, 364839, 324603, 324601, 364779, 364777, 364748, 362993, 180796, 226405, 329951, 329947, 352808, 363778, 363776, 363774, 363145, 213377, 213375, 213371, 196401, 196390, 361247, 363499, 360690, 363416, 324591, 363163, 344495, 237697, 362885, 362484, 237668, 350329, 180748, 237598, 237596, 361542, 361540, 361535, 361355, 226203, 360852, 323131, 360640, 237557, 324178, 322166, 360201, 360848, 360844, 360915, 360842, 324578, 324575, 350321, 350319, 614416, 359210, 350318, 324573, 226132, 303094, 350315, 359677, 359675, 360240, 359715, 359712, 360196, 359663, 359703, 359612, 226045, 359625, 303078, 344487, 350309, 324175, 324563, 196327, 189184, 359437, 359435, 226004, 359431, 359401, 359426, 213171, 322820, 354712, 344485, 357734, 357336, 357334, 357325, 357322, 357505, 356864, 212975, 298024, 355522, 357190, 354708, 324171, 354705, 354703, 354701, 356801, 354699, 295914, 356230, 354081, 298013, 329209, 322808, 180712, 180710, 180708, 309910, 180706, 212890, 309908, 324169, 180696, 324167, 180687, 356475, 356129, 196240, 237225, 354385, 323107, 356178, 354380, 350074, 350071, 348198, 346779, 196219, 212785, 354688, 212783, 212781, 212777, 212772, 354673, 354799, 354781, 354656, 354654, 324165, 354293, 354051, 324548, 323093, 322803, 310526, 303068, 261208, 180557, 352872, 310262, 350301, 306010, 348929, 324539, 205283, 212601, 298004, 350299, 350297, 351094, 324152, 314609, 350296, 350294, 306004, 310255, 350292, 350288, 349999, 349997, 323084, 212556, 349995, 306003, 322078, 349994, 349991, 344468, 329201, 322795, 277413, 349986, 349984, 350026, 349982, 349980, 349978, 349976, 348919, 262881, 324527, 262878, 297985, 346532, 346435, 205247, 225041, 345957, 344464, 345834, 310213, 343127, 345254, 297977, 345007, 344997, 344994, 344986, 344983, 344454, 343121, 343087, 322785, 324517, 334188, 342643, 343060, 342624, 323752, 323751, 109904, 109902, 342295, 212174, 332996, 342288, 224829, 224827, 224825, 224823, 212152, 322782, 341647, 341644, 341642, 297953, 341196, 297951, 297949, 297947, 341373, 341051, 341370, 341368, 297942, 341049, 341046, 128919, 323062, 341358, 341414, 325481, 340934, 224720, 236602, 341173, 212062, 340259, 340257, 324129, 340248, 332825, 340864, 340861, 340216, 294015, 261202, 105320, 297927, 339495, 105307, 340163, 297922, 340040, 297920, 324504, 339908, 322779, 318000, 236494, 236491, 236487, 339806, 323057, 322778, 339540, 339481, 338934, 324501, 338921, 317997, 211877, 338325, 338137, 338134, 338130, 337825, 338126, 337980, 338124, 315627, 315623, 323051, 323049, 323047, 323045, 322770, 324119, 322768, 332807, 297914, 297910, 305652, 322764, 265356, 236183, 211609, 334395, 335232, 331544, 335073, 328806, 297893, 131548, 324491, 335065, 322610, 325664, 324489, 322757, 297886, 329825, 297875, 332992, 297872, 297868, 297866, 297863, 324111, 329181, 325477, 300804, 329179, 317889, 301732, 252122, 332685, 332866, 614399, 317882, 324483, 317880, 317877, 323028, 328275, 332192, 322750, 317844, 322747, 330611, 315593, 324482, 211295, 331936, 324107, 321864, 264109, 264096, 264094, 323021, 264092, 235962, 325311, 329540, 314581, 105081, 328021, 614393, 324105, 329526, 224152, 331039, 614391, 211244, 224109, 211236, 322601, 211233, 224106, 105058, 211218, 297839, 297836, 329114, 297831, 329051, 329141, 297821, 211181, 328016, 328925, 297816, 327764, 195906, 278126, 137928, 235917, 322742, 328540, 328101, 328008, 305640, 328002, 328072, 327999, 195902, 326672, 258855, 322738, 326665, 314390, 314569, 322735, 324479, 322733, 307563, 326628, 326626, 314389, 327560, 322731, 202637, 327409, 326870, 326559, 205087, 326617, 324475, 323010, 614385, 614383, 310129, 202627, 325950, 264081, 264077, 202624, 323004, 202621, 264073, 318426, 614382, 326637, 318423, 326553, 326543, 318421, 326449, 318418, 324089, 320252, 223966, 320249, 325472, 326354, 614375, 323000, 223960, 325628, 211104, 325912, 304729, 322718, 325298, 321969, 324088, 322998, 314567, 305616, 180289, 305614, 320245, 324470, 324084, 322713, 321923, 324075, 322978, 322694, 320243, 322976, 264065, 322692, 321963, 304722, 321920, 314564, 321617, 314562, 314560, 314554, 202617, 223893, 314552, 314551, 307559, 294948, 294943, 314383, 319797, 319005, 262868, 319003, 320236, 320233, 320220, 109757, 180167, 180164, 318644, 317072, 614368, 310105, 223746, 235745, 235743, 318193, 317585, 317563, 317561, 317569, 317556, 317567, 317581, 614364, 614362, 252011, 614357, 316754, 316926, 193403, 252009, 316908, 316884, 180111, 210876, 252007, 251989, 614355, 614353, 251987, 614350, 316730, 251986, 210854, 235710, 307462, 316699, 316660, 316285, 251983, 316283, 258503, 210850, 614349, 235692, 27881, 235690, 195836, 210842, 316099, 251981, 27878, 223679, 315586, 251978, 315584, 223672, 315582, 277292, 279056, 315857, 315852, 210794, 251971, 223660, 315825, 315580, 251969, 180015, 314358, 305877, 251925, 235636, 313965, 313963, 195817, 313957, 251901, 180010, 104916, 264031, 251893, 264023, 304683, 210699, 251891, 195796, 210697, 251877, 195793, 279889, 313488, 251874, 313482, 313477, 308345, 312561, 210643, 251854, 235573, 210623, 251849, 302007, 312555, 312504, 307522, 311899, 251842, 312054, 310497, 311842, 307519, 210562, 307502, 311390, 179953, 210542, 311295, 307441, 251832, 279042, 210540, 251831, 307843, 210534, 310358, 307841, 311089, 310355, 310353, 310346, 310342, 251826, 310482, 264019, 264017, 264015, 308134, 251819, 235530, 307635, 308163, 308161, 310122, 308126, 308124, 307629, 307832, 210518, 307666, 62124, 210508, 307478, 307476, 251816, 307406, 305477, 223392, 251810, 307340, 306255, 195764, 195762, 251805, 307211, 251792, 251786, 301777, 223334, 251782, 223330, 301775, 306108, 223326, 301773, 223324, 109701, 301771, 210499, 223322, 306214, 223316, 223313, 306105, 306000, 305996, 123450, 123446, 271586, 288794, 305859, 251776, 210481, 305826, 210478, 299673, 210476, 304166, 305824, 251774, 305418, 251773, 305410, 299550, 305408, 210469, 305406, 174188, 299544, 174184, 210461, 174180, 251768, 195750, 251766, 251764, 251761, 195748, 235484, 305437, 210450, 195126, 223249, 195117, 299530, 251757, 300776, 301716, 251750, 304988, 305047, 223228, 210446, 302614, 251748, 305005, 304928, 251742, 304659, 262850, 304751, 251739, 304655, 301710, 304651, 304648, 251735, 210423, 304635, 304628, 301707, 301812, 301703, 301806, 210416, 251729, 303785, 301698, 301693, 251715, 210396, 301691, 62122, 303779, 304104, 267906, 304102, 303039, 267904, 251714, 210387, 304072, 304099, 303037, 304043, 251712, 62119, 302600, 223213, 302596, 299665, 299658, 303772, 223203, 303770, 223200, 299656, 251711, 262846, 299767, 210378, 210376, 289275, 299654, 289273, 210374, 251709, 261114, 302968, 195734, 303689, 251708, 251697, 302368, 302494, 302492, 294626, 302490, 302574, 302363, 302561, 302488, 302486, 302557, 302482, 302477, 302554, 302474, 302471, 251694, 210324, 301687, 302469, 210317, 302467, 301838, 179855, 302354, 251687, 302217, 302187, 290694, 290692, 290690, 302107, 210291, 302023, 290688, 251682, 262842, 301829, 301964, 302020, 301982, 301819, 261096, 261092, 301790, 267898, 261085, 301783, 261081, 301781, 267894, 299470, 261077, 261075, 301767, 267891, 301660, 261072, 251668, 104780, 299752, 299748, 36025, 301163, 301318, 299743, 251650, 301268, 301149, 301312, 251647, 301266, 301147, 301309, 21976, 301247, 301141, 301233, 267879, 267876, 300891, 267873, 210251, 267870, 299464, 300888, 251638, 301094, 291208, 251633, 299733, 299731, 300622, 300881, 269209, 287595, 297388, 300896, 251627, 300900, 300876, 300607, 251599, 299644, 299167, 210215, 21972, 294774, 258494, 258492, 294444, 297640, 282911, 294442, 294437, 297134, 297568, 297129, 297127, 297115, 297041, 297113, 297111, 296892, 297108, 296472, 296471, 296690, 296882, 296687, 296680, 210062, 205006, 205004, 115391, 295769, 291340, 296246, 235425, 235421, 291338, 291337, 291334, 262832, 293935, 293931, 295330, 293929, 295888, 125094, 125089, 125084, 293917, 109681, 109679, 294593, 266609, 294564, 294414, 292015, 291185, 292013, 291999, 291997, 291995, 291993, 291992, 291989, 291984, 291978, 291516, 251494, 104660, 251491, 251486, 131290, 251484, 289709, 287231, 291255, 289706, 285804, 289686, 285797, 287224, 257118, 193365, 193004, 128790, 156821, 32735, 32716, 32715, 32713, 32711, 76780, 76772, 76770, 76768, 76762, 76760, 32699, 32694, 75214, 63350, 68782, 68957))
Run Time: 0.071091
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1493 | |
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 | | | | | 1493 | |
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 (30851, 30294, 30244, 30168, 29323, 27241, 26430, 26255, 21202, 21091, 20921, 20866, 20089, 19827, 19734, 19407, 19261, 18368, 18267, 18241, 18185, 18107, 18046, 17847, 17769, 17720, 17519, 17447, 17147, 16835, 16278, 16185, 16166, 16108, 16061, 16031, 16026, 15500, 15428, 15394, 15355, 15268, 15234, 15225, 15213, 15205, 15198, 15150, 15091, 15083, 15025, 14993, 14906, 14750, 14703, 14694, 14627, 14626, 14612, 32145, 14559, 14534, 14520, 14464, 13980, 7905, 6746, 6590))
Run Time: 0.003759
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 68 | 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 (444407, 444402, 591649, 589554, 589551, 579405, 531105, 625019, 530974, 245679, 245644, 576794, 526412, 577385, 468737, 468735, 468734, 530928, 577693, 577761, 468732, 576771, 576766, 434736, 369233, 530886, 314682, 314680, 530796, 530792, 314673, 434118, 434116, 574658, 575590, 530586, 575347, 572609, 37769, 572605, 569670, 569666, 572216, 572214, 571533, 569891, 314669, 569658, 570210, 365340, 564868, 565189, 565445, 564863, 564475, 330419, 564449, 563674, 549649, 624961, 535892, 549580, 549560, 549557, 555357, 555314, 529123, 529091, 551504, 528909, 321199, 321197, 545219, 545217, 325859, 543628, 545207, 545204, 200106, 351670, 232694, 232688, 544935, 408799, 544931, 110470, 544968, 110467, 200095, 318885, 544923, 543616, 543607, 543594, 543588, 526998, 528151, 535791, 537229, 528688, 243934, 243926, 528653, 624801, 528617, 365265, 428761, 463579, 365263, 325073, 322941, 521531, 325066, 521003, 514408, 323577, 512079, 512076, 199762, 512074, 512071, 489241, 323553, 493799, 491454, 324971, 421752, 324901, 408774, 409502, 355769, 324805, 359902, 408759, 409501, 408758, 414546, 414543, 323430, 408755, 324800, 197857, 318052, 411574, 400933, 414541, 416174, 414663, 414535, 322893, 318046, 329301, 324791, 323424, 324789, 414661, 414659, 414657, 414589, 197790, 324787, 414528, 324786, 216028, 409500, 414526, 414524, 408751, 240540, 240533, 408749, 240529, 413696, 413694, 240527, 412838, 412836, 380010, 197767, 412835, 413127, 412827, 412822, 412819, 412815, 324785, 408745, 409123, 197755, 228773, 379995, 379993, 324783, 379991, 375206, 110145, 110142, 410997, 375204, 410989, 324782, 324781, 197738, 410776, 324777, 408741, 324775, 379978, 240387, 396397, 324774, 324771, 409496, 409494, 405221, 409603, 409213, 409488, 324764, 409599, 240314, 409202, 393760, 408731, 408729, 408661, 330068, 408725, 408723, 408720, 408716, 408714, 408711, 324757, 408659, 408658, 324756, 240151, 197620, 197615, 408028, 215707, 228465, 240129, 407860, 322623, 324253, 322885, 240106, 357401, 324750, 324749, 323396, 324748, 325779, 324744, 322883, 324739, 402225, 402041, 324720, 323373, 349010, 379953, 329280, 324713, 323372, 323370, 228187, 110110, 239855, 239852, 239850, 323366, 323362, 383591, 323361, 400964, 239819, 401777, 401772, 401770, 401768, 401715, 324700, 228131, 325497, 239693, 239680, 323347, 329277, 400008, 324694, 325385, 239620, 324691, 322875, 323319, 325768, 359861, 359858, 359855, 359853, 318276, 314617, 395524, 392621, 397094, 397057, 393853, 396128, 396827, 379935, 227818, 171659, 322871, 379925, 379924, 379922, 379920, 379918, 379916, 379914, 379912, 379910, 379908, 393978, 379906, 379904, 323229, 324681, 393682, 325377, 323210, 393949, 393966, 393947, 366767, 366765, 366763, 393715, 366761, 324667, 324663, 392593, 325753, 391290, 323199, 323194, 391281, 322869, 375187, 354421, 348315, 385521, 285451, 238696, 354416, 238662, 303254, 349454, 238586, 324655, 324653, 349450, 382691, 324649, 238539, 378456, 333446, 378451, 378405, 360386, 378383, 365129, 378348, 370424, 379687, 379678, 379755, 196782, 379616, 379198, 309954, 378306, 324206, 376825, 322858, 373286, 369484, 106029, 324621, 324618, 188112, 324617, 180823, 324615, 180820, 349446, 180818, 363806, 366753, 366770, 366751, 366750, 366611, 366599, 324610, 322190, 324185, 322840, 363995, 363993, 65460, 324609, 237851, 363803, 237834, 363801, 365088, 365809, 365806, 322182, 365800, 261220, 364420, 363796, 365547, 349444, 365007, 365005, 365002, 363794, 365001, 347609, 363791, 363788, 329233, 324181, 303203, 303200, 324180, 110070, 364796, 359792, 357384, 364793, 364867, 322837, 322835, 364839, 324603, 324601, 364779, 364777, 364748, 362993, 180796, 226405, 329951, 329947, 352808, 363778, 363776, 363774, 363145, 213377, 213375, 213371, 196401, 196390, 361247, 363499, 360690, 363416, 324591, 363163, 344495, 237697, 362885, 362484, 237668, 350329, 180748, 237598, 237596, 361542, 361540, 361535, 361355, 226203, 360852, 323131, 360640, 237557, 324178, 322166, 360201, 360848, 360844, 360915, 360842, 324578, 324575, 350321, 350319, 614416, 359210, 350318, 324573, 226132, 303094, 350315, 359677, 359675, 360240, 359715, 359712, 360196, 359663, 359703, 359612, 226045, 359625, 303078, 344487, 350309, 324175, 324563, 196327, 189184, 359437, 359435, 226004, 359431, 359401, 359426, 213171, 322820, 354712, 344485, 357734, 357336, 357334, 357325, 357322, 357505, 356864, 212975, 298024, 355522, 357190, 354708, 324171, 354705, 354703, 354701, 356801, 354699, 295914, 356230, 354081, 298013, 329209, 322808, 180712, 180710, 180708, 309910, 180706, 212890, 309908, 324169, 180696, 324167, 180687, 356475, 356129, 196240, 237225, 354385, 323107, 356178, 354380, 350074, 350071, 348198, 346779, 196219, 212785, 354688, 212783, 212781, 212777, 212772, 354673, 354799, 354781, 354656, 354654, 324165, 354293, 354051, 324548, 323093, 322803, 310526, 303068, 261208, 180557, 352872, 310262, 350301, 306010, 348929, 324539, 205283, 212601, 298004, 350299, 350297, 351094, 324152, 314609, 350296, 350294, 306004, 310255, 350292, 350288, 349999, 349997, 323084, 212556, 349995, 306003, 322078, 349994, 349991, 344468, 329201, 322795, 277413, 349986, 349984, 350026, 349982, 349980, 349978, 349976, 348919, 262881, 324527, 262878, 297985, 346532, 346435, 205247, 225041, 345957, 344464, 345834, 310213, 343127, 345254, 297977, 345007, 344997, 344994, 344986, 344983, 344454, 343121, 343087, 322785, 324517, 334188, 342643, 343060, 342624, 323752, 323751, 109904, 109902, 342295, 212174, 332996, 342288, 224829, 224827, 224825, 224823, 212152, 322782, 341647, 341644, 341642, 297953, 341196, 297951, 297949, 297947, 341373, 341051, 341370, 341368, 297942, 341049, 341046, 128919, 323062, 341358, 341414, 325481, 340934, 224720, 236602, 341173, 212062, 340259, 340257, 324129, 340248, 332825, 340864, 340861, 340216, 294015, 261202, 105320, 297927, 339495, 105307, 340163, 297922, 340040, 297920, 324504, 339908, 322779, 318000, 236494, 236491, 236487, 339806, 323057, 322778, 339540, 339481, 338934, 324501, 338921, 317997, 211877, 338325, 338137, 338134, 338130, 337825, 338126, 337980, 338124, 315627, 315623, 323051, 323049, 323047, 323045, 322770, 324119, 322768, 332807, 297914, 297910, 305652, 322764, 265356, 236183, 211609, 334395, 335232, 331544, 335073, 328806, 297893, 131548, 324491, 335065, 322610, 325664, 324489, 322757, 297886, 329825, 297875, 332992, 297872, 297868, 297866, 297863, 324111, 329181, 325477, 300804, 329179, 317889, 301732, 252122, 332685, 332866, 614399, 317882, 324483, 317880, 317877, 323028, 328275, 332192, 322750, 317844, 322747, 330611, 315593, 324482, 211295, 331936, 324107, 321864, 264109, 264096, 264094, 323021, 264092, 235962, 325311, 329540, 314581, 105081, 328021, 614393, 324105, 329526, 224152, 331039, 614391, 211244, 224109, 211236, 322601, 211233, 224106, 105058, 211218, 297839, 297836, 329114, 297831, 329051, 329141, 297821, 211181, 328016, 328925, 297816, 327764, 195906, 278126, 137928, 235917, 322742, 328540, 328101, 328008, 305640, 328002, 328072, 327999, 195902, 326672, 258855, 322738, 326665, 314390, 314569, 322735, 324479, 322733, 307563, 326628, 326626, 314389, 327560, 322731, 202637, 327409, 326870, 326559, 205087, 326617, 324475, 323010, 614385, 614383, 310129, 202627, 325950, 264081, 264077, 202624, 323004, 202621, 264073, 318426, 614382, 326637, 318423, 326553, 326543, 318421, 326449, 318418, 324089, 320252, 223966, 320249, 325472, 326354, 614375, 323000, 223960, 325628, 211104, 325912, 304729, 322718, 325298, 321969, 324088, 322998, 314567, 305616, 180289, 305614, 320245, 324470, 324084, 322713, 321923, 324075, 322978, 322694, 320243, 322976, 264065, 322692, 321963, 304722, 321920, 314564, 321617, 314562, 314560, 314554, 202617, 223893, 314552, 314551, 307559, 294948, 294943, 314383, 319797, 319005, 262868, 319003, 320236, 320233, 320220, 109757, 180167, 180164, 318644, 317072, 614368, 310105, 223746, 235745, 235743, 318193, 317585, 317563, 317561, 317569, 317556, 317567, 317581, 614364, 614362, 252011, 614357, 316754, 316926, 193403, 252009, 316908, 316884, 180111, 210876, 252007, 251989, 614355, 614353, 251987, 614350, 316730, 251986, 210854, 235710, 307462, 316699, 316660, 316285, 251983, 316283, 258503, 210850, 614349, 235692, 27881, 235690, 195836, 210842, 316099, 251981, 27878, 223679, 315586, 251978, 315584, 223672, 315582, 277292, 279056, 315857, 315852, 210794, 251971, 223660, 315825, 315580, 251969, 180015, 314358, 305877, 251925, 235636, 313965, 313963, 195817, 313957, 251901, 180010, 104916, 264031, 251893, 264023, 304683, 210699, 251891, 195796, 210697, 251877, 195793, 279889, 313488, 251874, 313482, 313477, 308345, 312561, 210643, 251854, 235573, 210623, 251849, 302007, 312555, 312504, 307522, 311899, 251842, 312054, 310497, 311842, 307519, 210562, 307502, 311390, 179953, 210542, 311295, 307441, 251832, 279042, 210540, 251831, 307843, 210534, 310358, 307841, 311089, 310355, 310353, 310346, 310342, 251826, 310482, 264019, 264017, 264015, 308134, 251819, 235530, 307635, 308163, 308161, 310122, 308126, 308124, 307629, 307832, 210518, 307666, 62124, 210508, 307478, 307476, 251816, 307406, 305477, 223392, 251810, 307340, 306255, 195764, 195762, 251805, 307211, 251792, 251786, 301777, 223334, 251782, 223330, 301775, 306108, 223326, 301773, 223324, 109701, 301771, 210499, 223322, 306214, 223316, 223313, 306105, 306000, 305996, 123450, 123446, 271586, 288794, 305859, 251776, 210481, 305826, 210478, 299673, 210476, 304166, 305824, 251774, 305418, 251773, 305410, 299550, 305408, 210469, 305406, 174188, 299544, 174184, 210461, 174180, 251768, 195750, 251766, 251764, 251761, 195748, 235484, 305437, 210450, 195126, 223249, 195117, 299530, 251757, 300776, 301716, 251750, 304988, 305047, 223228, 210446, 302614, 251748, 305005, 304928, 251742, 304659, 262850, 304751, 251739, 304655, 301710, 304651, 304648, 251735, 210423, 304635, 304628, 301707, 301812, 301703, 301806, 210416, 251729, 303785, 301698, 301693, 251715, 210396, 301691, 62122, 303779, 304104, 267906, 304102, 303039, 267904, 251714, 210387, 304072, 304099, 303037, 304043, 251712, 62119, 302600, 223213, 302596, 299665, 299658, 303772, 223203, 303770, 223200, 299656, 251711, 262846, 299767, 210378, 210376, 289275, 299654, 289273, 210374, 251709, 261114, 302968, 195734, 303689, 251708, 251697, 302368, 302494, 302492, 294626, 302490, 302574, 302363, 302561, 302488, 302486, 302557, 302482, 302477, 302554, 302474, 302471, 251694, 210324, 301687, 302469, 210317, 302467, 301838, 179855, 302354, 251687, 302217, 302187, 290694, 290692, 290690, 302107, 210291, 302023, 290688, 251682, 262842, 301829, 301964, 302020, 301982, 301819, 261096, 261092, 301790, 267898, 261085, 301783, 261081, 301781, 267894, 299470, 261077, 261075, 301767, 267891, 301660, 261072, 251668, 104780, 299752, 299748, 36025, 301163, 301318, 299743, 251650, 301268, 301149, 301312, 251647, 301266, 301147, 301309, 21976, 301247, 301141, 301233, 267879, 267876, 300891, 267873, 210251, 267870, 299464, 300888, 251638, 301094, 291208, 251633, 299733, 299731, 300622, 300881, 269209, 287595, 297388, 300896, 251627, 300900, 300876, 300607, 251599, 299644, 299167, 210215, 21972, 294774, 258494, 258492, 294444, 297640, 282911, 294442, 294437, 297134, 297568, 297129, 297127, 297115, 297041, 297113, 297111, 296892, 297108, 296472, 296471, 296690, 296882, 296687, 296680, 210062, 205006, 205004, 115391, 295769, 291340, 296246, 235425, 235421, 291338, 291337, 291334, 262832, 293935, 293931, 295330, 293929, 295888, 125094, 125089, 125084, 293917, 109681, 109679, 294593, 266609, 294564, 294414, 292015, 291185, 292013, 291999, 291997, 291995, 291993, 291992, 291989, 291984, 291978, 291516, 251494, 104660, 251491, 251486, 131290, 251484, 289709, 287231, 291255, 289706, 285804, 289686, 285797, 287224, 257118, 193365, 193004, 128790, 156821, 32735, 32716, 32715, 32713, 32711, 76780, 76772, 76770, 76768, 76762, 76760, 32699, 32694, 75214, 63350, 68782, 68957))
Run Time: 0.034181
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1493 | |
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 | | | | | 1493 | |
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 (30851, 30294, 30244, 30168, 29323, 27241, 26430, 26255, 21202, 21091, 20921, 20866, 20089, 19827, 19734, 19407, 19261, 18368, 18267, 18241, 18185, 18107, 18046, 17847, 17769, 17720, 17519, 17447, 17147, 16835, 16278, 16185, 16166, 16108, 16061, 16031, 16026, 15500, 15428, 15394, 15355, 15268, 15234, 15225, 15213, 15205, 15198, 15150, 15091, 15083, 15025, 14993, 14906, 14750, 14703, 14694, 14627, 14626, 14612, 32145, 14559, 14534, 14520, 14464, 13980, 7905, 6746, 6590))
Run Time: 0.002645
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 68 | 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, N
Run Time: 0.000312
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.000441
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.000718
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: 1716151035
Run Time: 0.000302
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 9 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
- XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Repository/SessionActivity.php at line 62
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*, `xf_user_User_1`.*
FROM `xf_session_activity`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1716151035)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000916
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 9 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | my_webapp.xf_session_activity.user_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivity.php at line 43
- XF\Repository\SessionActivity->getOnlineUsersList() in src/XF/Repository/SessionActivity.php at line 63
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20