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.001193
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.000496
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` = '1505')
LIMIT 1
Run Time: 0.000513
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.003346
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_1505' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.105613
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 (219748, 547423, 547343, 547376, 544282, 430160, 543642, 546608, 430020, 528936, 528932, 244114, 405762, 108705, 200074, 501315, 393833, 429666, 541906, 528789, 525001, 232592, 537620, 333748, 232387, 528598, 333744, 535102, 514068, 528594, 528291, 232379, 243822, 524117, 526508, 524085, 524081, 319190, 428573, 524015, 485538, 510746, 510740, 522387, 512562, 485520, 519943, 522385, 453516, 485517, 512560, 522586, 303340, 521087, 520744, 498270, 519741, 461718, 108531, 108527, 518676, 365229, 108423, 514791, 514444, 514441, 512553, 492615, 511962, 485368, 218591, 199641, 199635, 493480, 508096, 199622, 427072, 199606, 485347, 507821, 426992, 507805, 309201, 507776, 507773, 426968, 426966, 507256, 507668, 507666, 199587, 199577, 506874, 394822, 218482, 506745, 108287, 504081, 321101, 505995, 426715, 231742, 231740, 485303, 455411, 485293, 231593, 503909, 231591, 243104, 231585, 309016, 426432, 501714, 501705, 426268, 493426, 500906, 500904, 426246, 499526, 231307, 308945, 498385, 108166, 426070, 217676, 108042, 389602, 108036, 242625, 108034, 487876, 108030, 425279, 242462, 481882, 365219, 477800, 424904, 424888, 242282, 198973, 217355, 476956, 472187, 369733, 198899, 242186, 475050, 473382, 472136, 472030, 472118, 471457, 460794, 469356, 469493, 469185, 467609, 468252, 361096, 198674, 205691, 205689, 367144, 468587, 468585, 205685, 467363, 467358, 466084, 466452, 229938, 465963, 419033, 253780, 465874, 198578, 461002, 460997, 465428, 387717, 424177, 424168, 424166, 457617, 464896, 60383, 464457, 460990, 461688, 198476, 216781, 216779, 462880, 462231, 462181, 461677, 461712, 461673, 198383, 460086, 459672, 198359, 459832, 459830, 303279, 459151, 459148, 132343, 241503, 5188, 132341, 456772, 198345, 459072, 336220, 459119, 448581, 459064, 423893, 458734, 198315, 198313, 458240, 341112, 423890, 458156, 423888, 458309, 457711, 241440, 423863, 456654, 456775, 241388, 421992, 456442, 229635, 229607, 241343, 455275, 455267, 324852, 454629, 423833, 421988, 421986, 132276, 413411, 241323, 198217, 455127, 229575, 455066, 455121, 454422, 107579, 454425, 454124, 422153, 423815, 241282, 453320, 198171, 452235, 453063, 452231, 452735, 241239, 320633, 416257, 416255, 452075, 452022, 452039, 451779, 451773, 229486, 452003, 451425, 107503, 216445, 216436, 198118, 229476, 451466, 229474, 451463, 414785, 203388, 451401, 451398, 198102, 451395, 416808, 451388, 229455, 451232, 450659, 448806, 450649, 325809, 448803, 198095, 450235, 253768, 198069, 198067, 449788, 229385, 449539, 449074, 449529, 449517, 449588, 449513, 449493, 448684, 449058, 449055, 449047, 449042, 423787, 198040, 448076, 448073, 448742, 448738, 411638, 216317, 411636, 448316, 447980, 229307, 447915, 229254, 107428, 229237, 420856, 229203, 198007, 423186, 423416, 240947, 423464, 423184, 240941, 423170, 423377, 423153, 240929, 253760, 423223, 198005, 423148, 423143, 422726, 197986, 422504, 422706, 229148, 132231, 132228, 197968, 132220, 197966, 132217, 422179, 240891, 240889, 422086, 420066, 420903, 342771, 393788, 420039, 349373, 420014, 240805, 240794, 240788, 419682, 197914, 419667, 229054, 408227, 415363, 240754, 240752, 197907, 419230, 107330, 419276, 419226, 107327, 383488, 417445, 197902, 417547, 418968, 197900, 411597, 419206, 419159, 418989, 405313, 197894, 417222, 418612, 240732, 240707, 197862, 240704, 417206, 417142, 416178, 228933, 414380, 228861, 413187, 393775, 412824, 240473, 206333, 206330, 411278, 240456, 206328, 411275, 206326, 228764, 349029, 206311, 349027, 228755, 411109, 240446, 355747, 355744, 132087, 410654, 197742, 408743, 197729, 197726, 197721, 285490, 285488, 362281, 285485, 405263, 240368, 240364, 409862, 240351, 408740, 240332, 409963, 405216, 240328, 405214, 405212, 409851, 197691, 405204, 215814, 215812, 409515, 409553, 215807, 228634, 240308, 409510, 406314, 228625, 409393, 408736, 406312, 409508, 228621, 409379, 215791, 215789, 197679, 405199, 409370, 354433, 240298, 409250, 409300, 409200, 409192, 354145, 409190, 393763, 197662, 407997, 228593, 188704, 240274, 408730, 197657, 386778, 361093, 228588, 228584, 408728, 228577, 240263, 240257, 228574, 228519, 188699, 188697, 240240, 197648, 408722, 197642, 408719, 408717, 240190, 240188, 408554, 349018, 228483, 408207, 197619, 228470, 315681, 215704, 197610, 240141, 188225, 393751, 188223, 240137, 407988, 393749, 323405, 197600, 197597, 407863, 407837, 407325, 228426, 240120, 407771, 407768, 407698, 355730, 197588, 405688, 197572, 240056, 240052, 197568, 401896, 197565, 401894, 197563, 401890, 401886, 401883, 362247, 401879, 197559, 197556, 407198, 407189, 400048, 404781, 228332, 404768, 355722, 228318, 404765, 404763, 404760, 239984, 406677, 197536, 239966, 197534, 197530, 171770, 325388, 314416, 405665, 228272, 404620, 161816, 197525, 406020, 274617, 405993, 215625, 405515, 197516, 355715, 405182, 405176, 405170, 405164, 405645, 405161, 405390, 188167, 405382, 215614, 405566, 400025, 197505, 386769, 405551, 405485, 405133, 320432, 405068, 228238, 197503, 197500, 402979, 405122, 405367, 405454, 171752, 197488, 367074, 367070, 197486, 132068, 404980, 171741, 404884, 354427, 404804, 323380, 373208, 404606, 404604, 228212, 10539, 390454, 404552, 197463, 346352, 403158, 174235, 404164, 367061, 390452, 197460, 404108, 404116, 404066, 394526, 239911, 404057, 197451, 171719, 400817, 171717, 254079, 171715, 171712, 254071, 394809, 398988, 394807, 197442, 404002, 403997, 197439, 403842, 197437, 403870, 383486, 383483, 403865, 239892, 381751, 403719, 197426, 197424, 403602, 403660, 330051, 403328, 324717, 403576, 403655, 403540, 197421, 228200, 228195, 400017, 300840, 300838, 400414, 239867, 197411, 388035, 323371, 197406, 403073, 197404, 106913, 397806, 400968, 378690, 397804, 197391, 397802, 215512, 197389, 403065, 197386, 197383, 403062, 197381, 197379, 323368, 239854, 239851, 323365, 403030, 402868, 239838, 228173, 402823, 130222, 239836, 402458, 215480, 205478, 359867, 401789, 401787, 401785, 401783, 401780, 401756, 239778, 239776, 401752, 401748, 129018, 401745, 401740, 129015, 197344, 401730, 197342, 188696, 401947, 362233, 401717, 228149, 362231, 401710, 401707, 401702, 239760, 396352, 401698, 401693, 362229, 401691, 401686, 205464, 239739, 239736, 239729, 362215, 362213, 215443, 239718, 239714, 239712, 401542, 44929, 401468, 361036, 239704, 197330, 350948, 239698, 401441, 205457, 215426, 400917, 400509, 239671, 239661, 397482, 239659, 401371, 323346, 401384, 228123, 398734, 401367, 13790, 401358, 400013, 401065, 228121, 401282, 400150, 239636, 228118, 239633, 239597, 106828, 398620, 359234, 399480, 397705, 397695, 399094, 239546, 239544, 197276, 239534, 239532, 398871, 239528, 355652, 131983, 131981, 106788, 398860, 398592, 239522, 330043, 398280, 398779, 227994, 393002, 379809, 227980, 323297, 393438, 367024, 239501, 393433, 397748, 397746, 396624, 398573, 396622, 106779, 320403, 239485, 398516, 398276, 396791, 398512, 323289, 386748, 395928, 398274, 227961, 239480, 392504, 397744, 397113, 395778, 397037, 392501, 239427, 396913, 396606, 392617, 392614, 396604, 227878, 395870, 395868, 215211, 215202, 396754, 396766, 197172, 227844, 386486, 215199, 239414, 215197, 396593, 396562, 396291, 197158, 227842, 239408, 396555, 239403, 395923, 396277, 227835, 227833, 239397, 215186, 215183, 215181, 395705, 396082, 205360, 227820, 197132, 197129, 227817, 396080, 396109, 396030, 395703, 171660, 131951, 396074, 171654, 171652, 395892, 396071, 227806, 323259, 106691, 371174, 395803, 371172, 285484, 239374, 395858, 395851, 391301, 395399, 395837, 395879, 392885, 395712, 395639, 197110, 285480, 395750, 285478, 395734, 389312, 386738, 197078, 386736, 239327, 239321, 254052, 254049, 254044, 379911, 394743, 394741, 254039, 394804, 227761, 381733, 227758, 394683, 215128, 227756, 394663, 197054, 197052, 197049, 394300, 388437, 394474, 391766, 394350, 394483, 394455, 393734, 394157, 393423, 394104, 394155, 227721, 239263, 394151, 239261, 394135, 394225, 394117, 394109, 215096, 394107, 386481, 227713, 388435, 227710, 227708, 239255, 393337, 355601, 197043, 394023, 393335, 239251, 197040, 392449, 393333, 393997, 197032, 355111, 393937, 325378, 393948, 393964, 197029, 393885, 393730, 215085, 393728, 393717, 393678, 393689, 393669, 215078, 324669, 386733, 392429, 393273, 239247, 239245, 323204, 393269, 215061, 324664, 197026, 393407, 393321, 197022, 393402, 393222, 239237, 239234, 393154, 393152, 393150, 393148, 329061, 227698, 106606, 106604, 227691, 391392, 392689, 392610, 161787, 323202, 392608, 392606, 392605, 392400, 315665, 227681, 315663, 239203, 315651, 239201, 227668, 239196, 239194, 197006, 315648, 197003, 392560, 392548, 392488, 196999, 227660, 391927, 391653, 196992, 386729, 239158, 391642, 239154, 239150, 391639, 106600, 390729, 215015, 196989, 196984, 285473, 314407, 391958, 390013, 239129, 390011, 239127, 391947, 391763, 196976, 131884, 205327, 239104, 391624, 391622, 390876, 196974, 391734, 308769, 239090, 308767, 391570, 390099, 390006, 239085, 325374, 325371, 323195, 391283, 385512, 388007, 386726, 390850, 323193, 386724, 323190, 388003, 390841, 388001, 389961, 196967, 390834, 253727, 227620, 227618, 616677, 174217, 227613, 386722, 389522, 227599, 214973, 227597, 390292, 390812, 389516, 214965, 368770, 390708, 389957, 227589, 390405, 285469, 389744, 239018, 390281, 389742, 388690, 227583, 227579, 387971, 196959, 389995, 239009, 196955, 106568, 106562, 385505, 385503, 196951, 239001, 389584, 238998, 238996, 389811, 253723, 389582, 253721, 390082, 214954, 238994, 308761, 106558, 354424, 390191, 238979, 390165, 238977, 390068, 238968, 238962, 196950, 196941, 387693, 238928, 387690, 180931, 238926, 387688, 238924, 196934, 196932, 285466, 238909, 348973, 389503, 227572, 388640, 214931, 308746, 389122, 388604, 238892, 196923, 388601, 238884, 386234, 388635, 389077, 388633, 388631, 389075, 238875, 388627, 378757, 388572, 388570, 214897, 387459, 386997, 386989, 323184, 227557, 285458, 285456, 214888, 388419, 227551, 227548, 227546, 238857, 214879, 387882, 387872, 387679, 383909, 387567, 196913, 387592, 383905, 296706, 387523, 252754, 196908, 384520, 387540, 387509, 387451, 386969, 385651, 387449, 349458, 349456, 385645, 355592, 196906, 227520, 386932, 294239, 386715, 387323, 387259, 214832, 387228, 387181, 214830, 214828, 387179, 387217, 359105, 227510, 386563, 214826, 196902, 106507, 106503, 355587, 106501, 227506, 386623, 214807, 227484, 161752, 386603, 365462, 386555, 354420, 227477, 385634, 348343, 106482, 386428, 214786, 227451, 256349, 227449, 238805, 238802, 386362, 238798, 238792, 238786, 386254, 238778, 386368, 359219, 359217, 386327, 238770, 106476, 196892, 227437, 238756, 214773, 106474, 386325, 384958, 227433, 227431, 385538, 238744, 238742, 238736, 385533, 227422, 227418, 386188, 348292, 238723, 386155, 348288, 238721, 348279, 348275, 385663, 214753, 252744, 385613, 354419, 385609, 343243, 314406, 323181, 385729, 385593, 238711, 168316, 348265, 385572, 227408, 385470, 385527, 385122, 385468, 385464, 227405, 385462, 214731, 616493, 385433, 385431, 227404, 252743, 214727, 214723, 205323, 348970, 385428, 375638, 385316, 227399, 385425, 376563, 375920, 376561, 384926, 324221, 385330, 238701, 308700, 360786, 196889, 354415, 384915, 214718, 227391, 238693, 328717, 383845, 384906, 252741, 156247, 106468, 385261, 227389, 366335, 384740, 385182, 106457, 385239, 365153, 384554, 214695, 106435, 384951, 196885, 383529, 355585, 383524, 238642, 214676, 384881, 384695, 320300, 384711, 238638, 303261, 384767, 384708, 238632, 309969, 106398, 384662, 363521, 308697, 196869, 106394, 227357, 384591, 214630, 294218, 384587, 384586, 238624, 214628, 238622, 308691, 238618, 308688, 238616, 384584, 227350, 238604, 384313, 368994, 323179, 383306, 323177, 214604, 238599, 227346, 303253, 252735, 382546, 324656, 196858, 324651, 378464, 308683, 106382, 238578, 106378, 378654, 378462, 303246, 366953, 238557, 196855, 384079, 383833, 383831, 383518, 382726, 383516, 384008, 214563, 196851, 368988, 252734, 359085, 227317, 238552, 383648, 383573, 383571, 303239, 365135, 383471, 227308, 196840, 365132, 383247, 351778, 383411, 383198, 303236, 366939, 330861, 227300, 383262, 330858, 383350, 227294, 238549, 382822, 383343, 378755, 383339, 383337, 238544, 196838, 279087, 252733, 161739, 303230, 374488, 196837, 382847, 382845, 378754, 378458, 238537, 254858, 318522, 161735, 196835, 382717, 383046, 382972, 196834, 378433, 308676, 378431, 362748, 377432, 238519, 362745, 382484, 227266, 227264, 372469, 196829, 379277, 378390, 382221, 382217, 196826, 214499, 382094, 323174, 379210, 378381, 376554, 381653, 381649, 323172, 378366, 381646, 378361, 196821, 379373, 308667, 381214, 379368, 355583, 381470, 323169, 308663, 379364, 252730, 378200, 330842, 320270, 320268, 381468, 378745, 378743, 196818, 378346, 227245, 227241, 227234, 227231, 252728, 320261, 320258, 348965, 366934, 320255, 318516, 346307, 381690, 227223, 381688, 23361, 381685, 196797, 238454, 238452, 238449, 379651, 238443, 379632, 377946, 308656, 377944, 379709, 379705, 378328, 379624, 378325, 372566, 379201, 379398, 324647, 379390, 379192, 379024, 377884, 106334, 378635, 378631, 106331, 378628, 271346, 359526, 98835, 98833, 358338, 252721, 377936, 373094, 378846, 238420, 214418, 98831, 377895, 373088, 359524, 359521, 254478, 359518, 238409, 378808, 227170, 252710, 378315, 131863, 378805, 378737, 227152, 305685, 378223, 131861, 305683, 238389, 196755, 98818, 98812, 378308, 355579, 98808, 378043, 378041, 196742, 252695, 377876, 366918, 377874, 377990, 274534, 196724, 375952, 375834, 377304, 238351, 377794, 196721, 323164, 238346, 106313, 377786, 274530, 106311, 238340, 238315, 323159, 227041, 227039, 196698, 106273, 106270, 196693, 106267, 131820, 238240, 238236, 238234, 323156, 360782, 375947, 376577, 376538, 314403, 196642, 106249, 196637, 196634, 346281, 359510, 346276, 359816, 196632, 375902, 106234, 308641, 214242, 226961, 226959, 374467, 374465, 106232, 226957, 375135, 375370, 252684, 360766, 238134, 323148, 374807, 374446, 374444, 372458, 373206, 374424, 374384, 374421, 372452, 373202, 374419, 374514, 373795, 372213, 373200, 372209, 238103, 373064, 368036, 196602, 374191, 373822, 373820, 373048, 226916, 355576, 373490, 372697, 372695, 373387, 196594, 196592, 291453, 106130, 365118, 325368, 373195, 372686, 106122, 196586, 373027, 373193, 373023, 373188, 214071, 373186, 373106, 373178, 238082, 373102, 373099, 373017, 333406, 372771, 252674, 214018, 214016, 226872, 226870, 106100, 226868, 372901, 372863, 372861, 327162, 180900, 372676, 372196, 372668, 372719, 106096, 213960, 213956, 372663, 106091, 372492, 372182, 372488, 372507, 372505, 252670, 372501, 372484, 372544, 196574, 370722, 196566, 354411, 354408, 196564, 354404, 196561, 196559, 226836, 348663, 372177, 213934, 226830, 226823, 372175, 360743, 196556, 368454, 372167, 277988, 371411, 324634, 362035, 362033, 106077, 371044, 348660, 226797, 323144, 348250, 226795, 265478, 370655, 370387, 370934, 370942, 370345, 180897, 365403, 196532, 226764, 196520, 370884, 370796, 196504, 370794, 361304, 370025, 369952, 213815, 196500, 369950, 213812, 369948, 370021, 370792, 332853, 196494, 328911, 369548, 370493, 329254, 324630, 205297, 369709, 370408, 196492, 368641, 324628, 326927, 322849, 205295, 326915, 368638, 364103, 331291, 366869, 360727, 188692, 355575, 238025, 331289, 333385, 326912, 196484, 196462, 226625, 265476, 226612, 368831, 369601, 265474, 369592, 359472, 180878, 252646, 369589, 329974, 366304, 226605, 369587, 265462, 359467, 362011, 265458, 364805, 342740, 366300, 369557, 368632, 326898, 368630, 368806, 348949, 368827, 325735, 291447, 310327, 368951, 285445, 366196, 367761, 291445, 237977, 180864, 316695, 346842, 368554, 368528, 368524, 368434, 362535, 364803, 237947, 314399, 366631, 366629, 366894, 366603, 366601, 366595, 366589, 366585, 356987, 365483, 364000, 285441, 252628, 366577, 355573, 272044, 332351, 363957, 365825, 106007, 65467, 237883, 237881, 213581, 365103, 365098, 365096, 323138, 325367, 323137, 365812, 365807, 365804, 365802, 365842, 226491, 365799, 226488, 196429, 105966, 364733, 364731, 364728, 364726, 196426, 365425, 237815, 365568, 105960, 105956, 365688, 365686, 105949, 105947, 105945, 360719, 360716, 360714, 44907, 365589, 226478, 328895, 365074, 213539, 226472, 226470, 226468, 347603, 196420, 364364, 364965, 364916, 347600, 359795, 364355, 226458, 359447, 364759, 226455, 359564, 325365, 360699, 105944, 325363, 324602, 105937, 364780, 364837, 364413, 364717, 364711, 364665, 355566, 361524, 364461, 361576, 364005, 364458, 364342, 226421, 364408, 361556, 303167, 361278, 303163, 213440, 333373, 333371, 361271, 363782, 363884, 213387, 363721, 352806, 346825, 358735, 358733, 363653, 363650, 213366, 196399, 363642, 196395, 363444, 325358, 360693, 226351, 226345, 363474, 363497, 360675, 358321, 354397, 348245, 252594, 169442, 360673, 360668, 237718, 213333, 128995, 361023, 363318, 332331, 196387, 323135, 362910, 361654, 128989, 362957, 362955, 362953, 105898, 362986, 363129, 362984, 363127, 362949, 357049, 360585, 277449, 362662, 357046, 360583, 357043, 362658, 355558, 252592, 352961, 362656, 266124, 196380, 266122, 346812, 361964, 361958, 205293, 205291, 205289, 128976, 361950, 361818, 361903, 358722, 362500, 358718, 362573, 362545, 353874, 256202, 237675, 361924, 353872, 361922, 360657, 356182, 361909, 105867, 346805, 237652, 360941, 105859, 105857, 105853, 325730, 105846, 361347, 355283, 361344, 323132, 357771, 355556, 131795, 359758, 360651, 226259, 237632, 105836, 359754, 8483, 322620, 180753, 322827, 361698, 360939, 360936, 361336, 331269, 303141, 360932, 105832, 180749, 105827, 361506, 213291, 358165, 361196, 361073, 361071, 226188, 303129, 226186, 323129, 352928, 361063, 361134, 361019, 361007, 325355, 128969, 324581, 213273, 237542, 325351, 360209, 237539, 128966, 303104, 56798, 360579, 358662, 359560, 128962, 213241, 226129, 237506, 226100, 359617, 226092, 226090, 348945, 226077, 359678, 359728, 189186, 348942, 359673, 324569, 213216, 105767, 358196, 359434, 226006, 356250, 358192, 359403, 358716, 226003, 359425, 358254, 225998, 323114, 196323, 225992, 105749, 237463, 105747, 225980, 355546, 105704, 105698, 180742, 358674, 356240, 357744, 358129, 359168, 357740, 252564, 355543, 346883, 237442, 358231, 358966, 358229, 213160, 225972, 358224, 358704, 356142, 308520, 213153, 359008, 225969, 359004, 358962, 252561, 358221, 358212, 358776, 213137, 358769, 213131, 358766, 196320, 358763, 358508, 358203, 213117, 358758, 237434, 358756, 213114, 225954, 237432, 331251, 128956, 358697, 358576, 358573, 358558, 358555, 324556, 356978, 358547, 225927, 358534, 237370, 356976, 355537, 213043, 355534, 357938, 357969, 356763, 357835, 196292, 357693, 213019, 355531, 352789, 355517, 131758, 357007, 357004, 357153, 356947, 357000, 212929, 225754, 212926, 131741, 225749, 291443, 291441, 252513, 356330, 191797, 225746, 196263, 225743, 225728, 356532, 309909, 131731, 225722, 356136, 131729, 308492, 131727, 225719, 212881, 356478, 356127, 356119, 225696, 355073, 356117, 353839, 212852, 225670, 323106, 225666, 354384, 355385, 356106, 225658, 355513, 225653, 346789, 310312, 323103, 354696, 128944, 354693, 354812, 325725, 128942, 310308, 212784, 212782, 212780, 354373, 212776, 324549, 332850, 212773, 354783, 266851, 353581, 348807, 212767, 105596, 237159, 180629, 212762, 353446, 105579, 347460, 237156, 105576, 265430, 353443, 353297, 315201, 353439, 180595, 353823, 353889, 252494, 315642, 105561, 353821, 105559, 315640, 353719, 225484, 353421, 351678, 268805, 212644, 225392, 105448, 237019, 196181, 351555, 105446, 225332, 338589, 351542, 350720, 225324, 338585, 350770, 303058, 323086, 324536, 303053, 298005, 351393, 350051, 237013, 225300, 350046, 351327, 351293, 348925, 351290, 350186, 351325, 350846, 350762, 350184, 303049, 351322, 196170, 237009, 351318, 225293, 351179, 303043, 351176, 350035, 351171, 347418, 350502, 180454, 105420, 225274, 345840, 237003, 196163, 156240, 350702, 225215, 347452, 225211, 225209, 348918, 297989, 225208, 335675, 196153, 335673, 225205, 349839, 349656, 349778, 347671, 225197, 225193, 225182, 225180, 343337, 131669, 348572, 347563, 331558, 131667, 348569, 331554, 349359, 347647, 348916, 131662, 236967, 346728, 348514, 212510, 348056, 348053, 343427, 343425, 131645, 236946, 236944, 131643, 225151, 348455, 323077, 347140, 343419, 347138, 325349, 347640, 225112, 343413, 343411, 225108, 323075, 225104, 236905, 343407, 343403, 236903, 236885, 225094, 347024, 340847, 344838, 268497, 342415, 345720, 345718, 344285, 329555, 343617, 343493, 330770, 340294, 340394, 340714, 273813, 105322, 224660, 340209, 224658, 224654, 340246, 340472, 212036, 339552, 236565, 335970, 340284, 236557, 340239, 224651, 340595, 340064, 340470, 339289, 323059, 340282, 105315, 340236, 340529, 339229, 340466, 105305, 340042, 105303, 340139, 340056, 340008, 338507, 332820, 338505, 338689, 328664, 338575, 300826, 335946, 314585, 335773, 278130, 338502, 335771, 338409, 338490, 326537, 264126, 337539, 279062, 211818, 211811, 338222, 337983, 315631, 338192, 337530, 277364, 337981, 338189, 318513, 337527, 337849, 102418, 277361, 338128, 211798, 277358, 315629, 196003, 337704, 335943, 336439, 131563, 337178, 323046, 335940, 336435, 337380, 337907, 337752, 323044, 224507, 337444, 277352, 336577, 336576, 277350, 211699, 336053, 236309, 334471, 334468, 297901, 236292, 336035, 336033, 264114, 156219, 335067, 315622, 332587, 332581, 315620, 323038, 323036, 332315, 131505, 264112, 332167, 332312, 224220, 327272, 128880, 131496, 324108, 323029, 323026, 105094, 128878, 331732, 224200, 332254, 331730, 329549, 328484, 328466, 331646, 195927, 264099, 331724, 329545, 306261, 329530, 331128, 331126, 211262, 303599, 211253, 224170, 326461, 326459, 329524, 303595, 330912, 224147, 224122, 330562, 105061, 224120, 224113, 329520, 224101, 329049, 297830, 329047, 285421, 318510, 211183, 297827, 328638, 328635, 328888, 328884, 328843, 328881, 328922, 105053, 328878, 105050, 105048, 322597, 319800, 328866, 303590, 327973, 327059, 328629, 195915, 322596, 325308, 328655, 325345, 328624, 328622, 159276, 328652, 328649, 328619, 195911, 328617, 328646, 328613, 137930, 328644, 326802, 195908, 235929, 327797, 328667, 314576, 328610, 323015, 314571, 235927, 326800, 224063, 310139, 235909, 328146, 325137, 328271, 328460, 328143, 224059, 235907, 195905, 235905, 235903, 252093, 328141, 328102, 305421, 328077, 305639, 327874, 327259, 323013, 327579, 314386, 327055, 327462, 319516, 131468, 326999, 327094, 326621, 326561, 326584, 326581, 323009, 323008, 323006, 325344, 326452, 326578, 195885, 319511, 326590, 326552, 105046, 323002, 306897, 180295, 325939, 320104, 325604, 325936, 325630, 325340, 322999, 105041, 223951, 195875, 180236, 180234, 252054, 319464, 180220, 321445, 319460, 321753, 180215, 314557, 202615, 223889, 223887, 294957, 321441, 321439, 294954, 202600, 202598, 299813, 294952, 180212, 202589, 299809, 180209, 299805, 202586, 211056, 223880, 235836, 260901, 235834, 235832, 321629, 235830, 235828, 211049, 279797, 211045, 235826, 195867, 211039, 195864, 294945, 195862, 260899, 223861, 223857, 223855, 321364, 279783, 318222, 266084, 319796, 314381, 304716, 304714, 304712, 264043, 211027, 304705, 180194, 180192, 314380, 180190, 319792, 321410, 180187, 223853, 252046, 223851, 180185, 262867, 235809, 223847, 320235, 320230, 320094, 223830, 235789, 104995, 104986, 235787, 318408, 318407, 318405, 319207, 317078, 319178, 319138, 319194, 319136, 319132, 223803, 318631, 235753, 318980, 316966, 317475, 310104, 318399, 317473, 318162, 279059, 317052, 317050, 316320, 307419, 307527, 302006, 312460, 312060, 307417, 223328, 304545, 223202, 302497, 300906, 300904, 301581, 261111, 261108, 302390, 302495, 261106, 302386, 261104, 302261, 302259, 302257, 301995, 301924, 301920, 302370, 302892, 302890, 223185, 302367, 302895, 302483, 302480, 302360, 302473, 301965, 301976, 301826, 296213, 301822, 223181, 267881, 235429, 223178, 223176, 301201, 301198, 223172, 300889, 301193, 300763, 235427, 301096, 223170, 300887, 267233, 300758, 300936, 298964, 300614, 300755, 104760, 267229, 267227, 300875, 267223, 297808, 131416, 300473, 223166, 287789, 179822, 179819, 179815, 179813, 299113, 299111, 299868, 131411, 297799, 179808, 21975, 299106, 299317, 258495, 21973, 299104, 179804, 297792, 297588, 296965, 297577, 297214, 291343, 296009, 296244, 296173, 291339, 291964, 125091, 125090, 295262, 125087, 295233, 295080, 294605, 295228, 294598, 223125, 295077, 295210, 295075, 295208, 294771, 291956, 294596, 291953, 291278, 295200, 266610, 256317, 295049, 295182, 295039, 295031, 295027, 294931, 223120, 294929, 294269, 294262, 209998, 294255, 293892, 293886, 291332, 291325, 131347, 131339, 293864, 291321, 293855, 291619, 291615, 131329, 131324, 131322, 291317, 262826, 291314, 287671, 104699, 291613, 262824, 291610, 131319, 104697, 291605, 131315, 292068, 131313, 291603, 291599, 291311, 104692, 291596, 291593, 291590, 104690, 262822, 104675, 291188, 131298, 131294, 258488, 291947, 287245, 287242, 287239, 291306, 287237, 287234, 288876, 288875, 257153, 223103, 223096, 285795, 287651, 131287, 131283, 179640, 285791, 287913, 284548, 179629, 287907, 287648, 179627, 287644, 287904, 284542, 179621, 104513, 284538, 284536, 287392, 209798, 285245, 285414, 131258, 285036, 284634, 284175, 285409, 131253, 285242, 131246, 275753, 274508, 282909, 284530, 283105, 283103, 283101, 282902, 282729, 282897, 278122, 278967, 278965, 278312, 279022, 278907, 279152, 279020, 277657, 278173, 278114, 278111, 277641, 277513, 277627, 277625, 277880, 261029, 277622, 272998, 270427, 268601, 223034, 270413, 104318, 270776, 104316, 223031, 270252, 266267, 266265, 269804, 256497, 266400, 179056, 179054, 270276, 269802, 269369, 270035, 270030, 270014, 203649, 184542, 222959, 222957, 263279, 222955, 268674, 268696, 222953, 188336, 268690, 188334, 235404, 268669, 266397, 235393, 267628, 268301, 268491, 268664, 188332, 268448, 268489, 235380, 263299, 255240, 255233, 256548, 256545, 256543, 255350, 255228, 255196, 253113, 253109, 249598, 250386, 249354, 130799, 249572, 249570, 248432, 248457, 208731, 176412, 208698, 208696, 248125, 195091, 247726, 247706, 247700, 247695, 203180, 203175, 103831, 208232, 208373, 207735, 207991, 103781, 176319, 207377, 207178, 207350, 207228, 174638, 207342, 206802, 204692, 204690, 203364, 203359, 203357, 204614, 204478, 191895, 204472, 204468, 204403, 203632, 130695, 204377, 203629, 130693, 191661, 203993, 204363, 203625, 204313, 204309, 204014, 204109, 161264, 204106, 203145, 203317, 203138, 203133, 203130, 202200, 203128, 203125, 195275, 191883, 195233, 192864, 195222, 194217, 195090, 194208, 194273, 194271, 194200, 194192, 193551, 193133, 194263, 188369, 188086, 175965, 187719, 174592, 174590, 186833, 185239, 174582, 174581, 185990, 185841, 185797, 185899, 165234, 185839, 165231, 185590, 165228, 185850, 182897, 185835, 185848, 165226, 185587, 185846, 185833, 182894, 185630, 185652, 185625, 185621, 185574, 185569, 174566, 185578, 154763, 185560, 174554, 174551, 154760, 184519, 174546, 174527, 185217, 173765, 184893, 184799, 161229, 183588, 183222, 175852, 170991, 182678, 165188, 175831, 181238, 181365, 181361, 175733, 175730, 175726, 175097, 174519, 174511, 175017, 174507, 173736, 174500, 154754, 167676, 174482, 165157, 174463, 165144, 173968, 173337, 173320, 172975, 173317, 171622, 167581, 168476, 171598, 172537, 172388, 171591, 171588, 171584, 172379, 172362, 171519, 171580, 172261, 171578, 171515, 172053, 171221, 171575, 170958, 171201, 171198, 170945, 170887, 170777, 170898, 170424, 170416, 170414, 170412, 168678, 168675, 168547, 166940, 168426, 168469, 168269, 168262, 166289, 165590, 166241, 163753, 165582, 164092, 162695, 158936, 157680, 156989, 154746, 154991, 154931, 154744, 130547, 153041, 154383, 154406, 152846, 153965, 153479, 153936, 152837, 153411, 153467, 153464, 153409, 153216, 153462, 153213, 153211, 153423, 153020, 152588, 130523, 153017, 130517, 152380, 150584, 152569, 151750, 152374, 147242, 147239, 137750, 146982, 146977, 146872, 145244, 146389, 145241, 144929, 146118, 144927, 146111, 144921, 145214, 144913, 130489, 103567, 143915, 143898, 103558, 144040, 142351, 142349, 142344, 127741, 142335, 140279, 140358, 140273, 139943, 139537, 139735, 138431, 138428, 139404, 135143, 137745, 137739, 137101, 136230, 137099, 136226, 121791, 135804, 126109, 85525, 135342, 135727, 135607, 135435, 135548, 135389, 135430, 135387, 135482, 135428, 135309, 135294, 135338, 135239, 134932, 134675, 134907, 134066, 134905, 125913, 124307, 134903, 134883, 134806, 130465, 134633, 134525, 134566, 134513, 134510, 134016, 121767, 134103, 121758, 121756, 133964, 130454, 134099, 133987, 133983, 128497, 133960, 133941, 130444, 121738, 130436, 121717, 130423, 130362, 130416, 130360, 130334, 130356, 130325, 130311, 130208, 128786, 128780, 128667, 128634, 129272, 128624, 127837, 128649, 129109, 128646, 128105, 128137, 128245, 118627, 127812, 127860, 127809, 127711, 127708, 127706, 127289, 127307, 127338, 125839, 127112, 127081, 125965, 126277, 124654, 126256, 126232, 126029, 126173, 126027, 126162, 126024, 125603, 125597, 125594, 125591, 125371, 125431, 125387, 125229, 125365, 125361, 125224, 125037, 125359, 115363, 125335, 124990, 124629, 125205, 124316, 124411, 124405, 124337, 124331, 123868, 122263, 124063, 122260, 124059, 123174, 124050, 123713, 123159, 122814, 121281, 121673, 121667, 122119, 103534, 122147, 103527, 103523, 121617, 116047, 87207, 116045, 121651, 116043, 121613, 121464, 121040, 121243, 99989, 116030, 116518, 103451, 103448, 103443, 116020, 116143, 116139, 116013, 115939, 116010, 115936, 111984, 111424, 99074, 103363, 100677, 98865, 98770, 97977, 96370, 96214, 94875, 63401, 94226, 94182, 94224, 94019, 94043, 94017, 88004, 94015, 94039, 94035, 93645, 89628, 93626, 93623, 89622, 91569, 92446, 92437, 78803, 91558, 89262, 89570, 89260, 89432, 89086, 32740, 89070, 88892, 88843, 88837, 87537, 87999, 88409, 88533, 88407, 88340, 87724, 87959, 87690, 86790, 85834, 85827, 85993, 85773, 83502, 84329, 84070, 85825, 85771, 85763, 84068, 69672, 82108, 85004, 82442, 75167, 64921, 75706, 74544, 71229, 73779, 74286, 72033, 71112, 32663, 70678, 70844, 70671, 70841, 70827, 70823, 69667, 69663, 68312, 69143, 68295, 68286, 55354, 67875, 68283, 66256, 64909, 65800, 64907, 65852, 65841, 59311, 64711, 56779, 54201, 54675, 53622, 17318, 54196))
Run Time: 0.215471
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3794 | |
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 | | | | | 3794 | |
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 (26682, 26681, 23343, 21606, 21604, 20511, 19891, 19844, 19815, 19342, 19082, 19077, 18676, 18237, 18182, 16233, 16152, 15115, 15068, 15017, 14996, 14990, 14137, 13780, 13135, 12597, 12418, 12307, 12295, 12243, 12242, 11200, 11175, 10441, 9416, 9154, 8678, 6229, 6228, 6124, 5109))
Run Time: 0.002906
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 41 | 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 (219748, 547423, 547343, 547376, 544282, 430160, 543642, 546608, 430020, 528936, 528932, 244114, 405762, 108705, 200074, 501315, 393833, 429666, 541906, 528789, 525001, 232592, 537620, 333748, 232387, 528598, 333744, 535102, 514068, 528594, 528291, 232379, 243822, 524117, 526508, 524085, 524081, 319190, 428573, 524015, 485538, 510746, 510740, 522387, 512562, 485520, 519943, 522385, 453516, 485517, 512560, 522586, 303340, 521087, 520744, 498270, 519741, 461718, 108531, 108527, 518676, 365229, 108423, 514791, 514444, 514441, 512553, 492615, 511962, 485368, 218591, 199641, 199635, 493480, 508096, 199622, 427072, 199606, 485347, 507821, 426992, 507805, 309201, 507776, 507773, 426968, 426966, 507256, 507668, 507666, 199587, 199577, 506874, 394822, 218482, 506745, 108287, 504081, 321101, 505995, 426715, 231742, 231740, 485303, 455411, 485293, 231593, 503909, 231591, 243104, 231585, 309016, 426432, 501714, 501705, 426268, 493426, 500906, 500904, 426246, 499526, 231307, 308945, 498385, 108166, 426070, 217676, 108042, 389602, 108036, 242625, 108034, 487876, 108030, 425279, 242462, 481882, 365219, 477800, 424904, 424888, 242282, 198973, 217355, 476956, 472187, 369733, 198899, 242186, 475050, 473382, 472136, 472030, 472118, 471457, 460794, 469356, 469493, 469185, 467609, 468252, 361096, 198674, 205691, 205689, 367144, 468587, 468585, 205685, 467363, 467358, 466084, 466452, 229938, 465963, 419033, 253780, 465874, 198578, 461002, 460997, 465428, 387717, 424177, 424168, 424166, 457617, 464896, 60383, 464457, 460990, 461688, 198476, 216781, 216779, 462880, 462231, 462181, 461677, 461712, 461673, 198383, 460086, 459672, 198359, 459832, 459830, 303279, 459151, 459148, 132343, 241503, 5188, 132341, 456772, 198345, 459072, 336220, 459119, 448581, 459064, 423893, 458734, 198315, 198313, 458240, 341112, 423890, 458156, 423888, 458309, 457711, 241440, 423863, 456654, 456775, 241388, 421992, 456442, 229635, 229607, 241343, 455275, 455267, 324852, 454629, 423833, 421988, 421986, 132276, 413411, 241323, 198217, 455127, 229575, 455066, 455121, 454422, 107579, 454425, 454124, 422153, 423815, 241282, 453320, 198171, 452235, 453063, 452231, 452735, 241239, 320633, 416257, 416255, 452075, 452022, 452039, 451779, 451773, 229486, 452003, 451425, 107503, 216445, 216436, 198118, 229476, 451466, 229474, 451463, 414785, 203388, 451401, 451398, 198102, 451395, 416808, 451388, 229455, 451232, 450659, 448806, 450649, 325809, 448803, 198095, 450235, 253768, 198069, 198067, 449788, 229385, 449539, 449074, 449529, 449517, 449588, 449513, 449493, 448684, 449058, 449055, 449047, 449042, 423787, 198040, 448076, 448073, 448742, 448738, 411638, 216317, 411636, 448316, 447980, 229307, 447915, 229254, 107428, 229237, 420856, 229203, 198007, 423186, 423416, 240947, 423464, 423184, 240941, 423170, 423377, 423153, 240929, 253760, 423223, 198005, 423148, 423143, 422726, 197986, 422504, 422706, 229148, 132231, 132228, 197968, 132220, 197966, 132217, 422179, 240891, 240889, 422086, 420066, 420903, 342771, 393788, 420039, 349373, 420014, 240805, 240794, 240788, 419682, 197914, 419667, 229054, 408227, 415363, 240754, 240752, 197907, 419230, 107330, 419276, 419226, 107327, 383488, 417445, 197902, 417547, 418968, 197900, 411597, 419206, 419159, 418989, 405313, 197894, 417222, 418612, 240732, 240707, 197862, 240704, 417206, 417142, 416178, 228933, 414380, 228861, 413187, 393775, 412824, 240473, 206333, 206330, 411278, 240456, 206328, 411275, 206326, 228764, 349029, 206311, 349027, 228755, 411109, 240446, 355747, 355744, 132087, 410654, 197742, 408743, 197729, 197726, 197721, 285490, 285488, 362281, 285485, 405263, 240368, 240364, 409862, 240351, 408740, 240332, 409963, 405216, 240328, 405214, 405212, 409851, 197691, 405204, 215814, 215812, 409515, 409553, 215807, 228634, 240308, 409510, 406314, 228625, 409393, 408736, 406312, 409508, 228621, 409379, 215791, 215789, 197679, 405199, 409370, 354433, 240298, 409250, 409300, 409200, 409192, 354145, 409190, 393763, 197662, 407997, 228593, 188704, 240274, 408730, 197657, 386778, 361093, 228588, 228584, 408728, 228577, 240263, 240257, 228574, 228519, 188699, 188697, 240240, 197648, 408722, 197642, 408719, 408717, 240190, 240188, 408554, 349018, 228483, 408207, 197619, 228470, 315681, 215704, 197610, 240141, 188225, 393751, 188223, 240137, 407988, 393749, 323405, 197600, 197597, 407863, 407837, 407325, 228426, 240120, 407771, 407768, 407698, 355730, 197588, 405688, 197572, 240056, 240052, 197568, 401896, 197565, 401894, 197563, 401890, 401886, 401883, 362247, 401879, 197559, 197556, 407198, 407189, 400048, 404781, 228332, 404768, 355722, 228318, 404765, 404763, 404760, 239984, 406677, 197536, 239966, 197534, 197530, 171770, 325388, 314416, 405665, 228272, 404620, 161816, 197525, 406020, 274617, 405993, 215625, 405515, 197516, 355715, 405182, 405176, 405170, 405164, 405645, 405161, 405390, 188167, 405382, 215614, 405566, 400025, 197505, 386769, 405551, 405485, 405133, 320432, 405068, 228238, 197503, 197500, 402979, 405122, 405367, 405454, 171752, 197488, 367074, 367070, 197486, 132068, 404980, 171741, 404884, 354427, 404804, 323380, 373208, 404606, 404604, 228212, 10539, 390454, 404552, 197463, 346352, 403158, 174235, 404164, 367061, 390452, 197460, 404108, 404116, 404066, 394526, 239911, 404057, 197451, 171719, 400817, 171717, 254079, 171715, 171712, 254071, 394809, 398988, 394807, 197442, 404002, 403997, 197439, 403842, 197437, 403870, 383486, 383483, 403865, 239892, 381751, 403719, 197426, 197424, 403602, 403660, 330051, 403328, 324717, 403576, 403655, 403540, 197421, 228200, 228195, 400017, 300840, 300838, 400414, 239867, 197411, 388035, 323371, 197406, 403073, 197404, 106913, 397806, 400968, 378690, 397804, 197391, 397802, 215512, 197389, 403065, 197386, 197383, 403062, 197381, 197379, 323368, 239854, 239851, 323365, 403030, 402868, 239838, 228173, 402823, 130222, 239836, 402458, 215480, 205478, 359867, 401789, 401787, 401785, 401783, 401780, 401756, 239778, 239776, 401752, 401748, 129018, 401745, 401740, 129015, 197344, 401730, 197342, 188696, 401947, 362233, 401717, 228149, 362231, 401710, 401707, 401702, 239760, 396352, 401698, 401693, 362229, 401691, 401686, 205464, 239739, 239736, 239729, 362215, 362213, 215443, 239718, 239714, 239712, 401542, 44929, 401468, 361036, 239704, 197330, 350948, 239698, 401441, 205457, 215426, 400917, 400509, 239671, 239661, 397482, 239659, 401371, 323346, 401384, 228123, 398734, 401367, 13790, 401358, 400013, 401065, 228121, 401282, 400150, 239636, 228118, 239633, 239597, 106828, 398620, 359234, 399480, 397705, 397695, 399094, 239546, 239544, 197276, 239534, 239532, 398871, 239528, 355652, 131983, 131981, 106788, 398860, 398592, 239522, 330043, 398280, 398779, 227994, 393002, 379809, 227980, 323297, 393438, 367024, 239501, 393433, 397748, 397746, 396624, 398573, 396622, 106779, 320403, 239485, 398516, 398276, 396791, 398512, 323289, 386748, 395928, 398274, 227961, 239480, 392504, 397744, 397113, 395778, 397037, 392501, 239427, 396913, 396606, 392617, 392614, 396604, 227878, 395870, 395868, 215211, 215202, 396754, 396766, 197172, 227844, 386486, 215199, 239414, 215197, 396593, 396562, 396291, 197158, 227842, 239408, 396555, 239403, 395923, 396277, 227835, 227833, 239397, 215186, 215183, 215181, 395705, 396082, 205360, 227820, 197132, 197129, 227817, 396080, 396109, 396030, 395703, 171660, 131951, 396074, 171654, 171652, 395892, 396071, 227806, 323259, 106691, 371174, 395803, 371172, 285484, 239374, 395858, 395851, 391301, 395399, 395837, 395879, 392885, 395712, 395639, 197110, 285480, 395750, 285478, 395734, 389312, 386738, 197078, 386736, 239327, 239321, 254052, 254049, 254044, 379911, 394743, 394741, 254039, 394804, 227761, 381733, 227758, 394683, 215128, 227756, 394663, 197054, 197052, 197049, 394300, 388437, 394474, 391766, 394350, 394483, 394455, 393734, 394157, 393423, 394104, 394155, 227721, 239263, 394151, 239261, 394135, 394225, 394117, 394109, 215096, 394107, 386481, 227713, 388435, 227710, 227708, 239255, 393337, 355601, 197043, 394023, 393335, 239251, 197040, 392449, 393333, 393997, 197032, 355111, 393937, 325378, 393948, 393964, 197029, 393885, 393730, 215085, 393728, 393717, 393678, 393689, 393669, 215078, 324669, 386733, 392429, 393273, 239247, 239245, 323204, 393269, 215061, 324664, 197026, 393407, 393321, 197022, 393402, 393222, 239237, 239234, 393154, 393152, 393150, 393148, 329061, 227698, 106606, 106604, 227691, 391392, 392689, 392610, 161787, 323202, 392608, 392606, 392605, 392400, 315665, 227681, 315663, 239203, 315651, 239201, 227668, 239196, 239194, 197006, 315648, 197003, 392560, 392548, 392488, 196999, 227660, 391927, 391653, 196992, 386729, 239158, 391642, 239154, 239150, 391639, 106600, 390729, 215015, 196989, 196984, 285473, 314407, 391958, 390013, 239129, 390011, 239127, 391947, 391763, 196976, 131884, 205327, 239104, 391624, 391622, 390876, 196974, 391734, 308769, 239090, 308767, 391570, 390099, 390006, 239085, 325374, 325371, 323195, 391283, 385512, 388007, 386726, 390850, 323193, 386724, 323190, 388003, 390841, 388001, 389961, 196967, 390834, 253727, 227620, 227618, 616677, 174217, 227613, 386722, 389522, 227599, 214973, 227597, 390292, 390812, 389516, 214965, 368770, 390708, 389957, 227589, 390405, 285469, 389744, 239018, 390281, 389742, 388690, 227583, 227579, 387971, 196959, 389995, 239009, 196955, 106568, 106562, 385505, 385503, 196951, 239001, 389584, 238998, 238996, 389811, 253723, 389582, 253721, 390082, 214954, 238994, 308761, 106558, 354424, 390191, 238979, 390165, 238977, 390068, 238968, 238962, 196950, 196941, 387693, 238928, 387690, 180931, 238926, 387688, 238924, 196934, 196932, 285466, 238909, 348973, 389503, 227572, 388640, 214931, 308746, 389122, 388604, 238892, 196923, 388601, 238884, 386234, 388635, 389077, 388633, 388631, 389075, 238875, 388627, 378757, 388572, 388570, 214897, 387459, 386997, 386989, 323184, 227557, 285458, 285456, 214888, 388419, 227551, 227548, 227546, 238857, 214879, 387882, 387872, 387679, 383909, 387567, 196913, 387592, 383905, 296706, 387523, 252754, 196908, 384520, 387540, 387509, 387451, 386969, 385651, 387449, 349458, 349456, 385645, 355592, 196906, 227520, 386932, 294239, 386715, 387323, 387259, 214832, 387228, 387181, 214830, 214828, 387179, 387217, 359105, 227510, 386563, 214826, 196902, 106507, 106503, 355587, 106501, 227506, 386623, 214807, 227484, 161752, 386603, 365462, 386555, 354420, 227477, 385634, 348343, 106482, 386428, 214786, 227451, 256349, 227449, 238805, 238802, 386362, 238798, 238792, 238786, 386254, 238778, 386368, 359219, 359217, 386327, 238770, 106476, 196892, 227437, 238756, 214773, 106474, 386325, 384958, 227433, 227431, 385538, 238744, 238742, 238736, 385533, 227422, 227418, 386188, 348292, 238723, 386155, 348288, 238721, 348279, 348275, 385663, 214753, 252744, 385613, 354419, 385609, 343243, 314406, 323181, 385729, 385593, 238711, 168316, 348265, 385572, 227408, 385470, 385527, 385122, 385468, 385464, 227405, 385462, 214731, 616493, 385433, 385431, 227404, 252743, 214727, 214723, 205323, 348970, 385428, 375638, 385316, 227399, 385425, 376563, 375920, 376561, 384926, 324221, 385330, 238701, 308700, 360786, 196889, 354415, 384915, 214718, 227391, 238693, 328717, 383845, 384906, 252741, 156247, 106468, 385261, 227389, 366335, 384740, 385182, 106457, 385239, 365153, 384554, 214695, 106435, 384951, 196885, 383529, 355585, 383524, 238642, 214676, 384881, 384695, 320300, 384711, 238638, 303261, 384767, 384708, 238632, 309969, 106398, 384662, 363521, 308697, 196869, 106394, 227357, 384591, 214630, 294218, 384587, 384586, 238624, 214628, 238622, 308691, 238618, 308688, 238616, 384584, 227350, 238604, 384313, 368994, 323179, 383306, 323177, 214604, 238599, 227346, 303253, 252735, 382546, 324656, 196858, 324651, 378464, 308683, 106382, 238578, 106378, 378654, 378462, 303246, 366953, 238557, 196855, 384079, 383833, 383831, 383518, 382726, 383516, 384008, 214563, 196851, 368988, 252734, 359085, 227317, 238552, 383648, 383573, 383571, 303239, 365135, 383471, 227308, 196840, 365132, 383247, 351778, 383411, 383198, 303236, 366939, 330861, 227300, 383262, 330858, 383350, 227294, 238549, 382822, 383343, 378755, 383339, 383337, 238544, 196838, 279087, 252733, 161739, 303230, 374488, 196837, 382847, 382845, 378754, 378458, 238537, 254858, 318522, 161735, 196835, 382717, 383046, 382972, 196834, 378433, 308676, 378431, 362748, 377432, 238519, 362745, 382484, 227266, 227264, 372469, 196829, 379277, 378390, 382221, 382217, 196826, 214499, 382094, 323174, 379210, 378381, 376554, 381653, 381649, 323172, 378366, 381646, 378361, 196821, 379373, 308667, 381214, 379368, 355583, 381470, 323169, 308663, 379364, 252730, 378200, 330842, 320270, 320268, 381468, 378745, 378743, 196818, 378346, 227245, 227241, 227234, 227231, 252728, 320261, 320258, 348965, 366934, 320255, 318516, 346307, 381690, 227223, 381688, 23361, 381685, 196797, 238454, 238452, 238449, 379651, 238443, 379632, 377946, 308656, 377944, 379709, 379705, 378328, 379624, 378325, 372566, 379201, 379398, 324647, 379390, 379192, 379024, 377884, 106334, 378635, 378631, 106331, 378628, 271346, 359526, 98835, 98833, 358338, 252721, 377936, 373094, 378846, 238420, 214418, 98831, 377895, 373088, 359524, 359521, 254478, 359518, 238409, 378808, 227170, 252710, 378315, 131863, 378805, 378737, 227152, 305685, 378223, 131861, 305683, 238389, 196755, 98818, 98812, 378308, 355579, 98808, 378043, 378041, 196742, 252695, 377876, 366918, 377874, 377990, 274534, 196724, 375952, 375834, 377304, 238351, 377794, 196721, 323164, 238346, 106313, 377786, 274530, 106311, 238340, 238315, 323159, 227041, 227039, 196698, 106273, 106270, 196693, 106267, 131820, 238240, 238236, 238234, 323156, 360782, 375947, 376577, 376538, 314403, 196642, 106249, 196637, 196634, 346281, 359510, 346276, 359816, 196632, 375902, 106234, 308641, 214242, 226961, 226959, 374467, 374465, 106232, 226957, 375135, 375370, 252684, 360766, 238134, 323148, 374807, 374446, 374444, 372458, 373206, 374424, 374384, 374421, 372452, 373202, 374419, 374514, 373795, 372213, 373200, 372209, 238103, 373064, 368036, 196602, 374191, 373822, 373820, 373048, 226916, 355576, 373490, 372697, 372695, 373387, 196594, 196592, 291453, 106130, 365118, 325368, 373195, 372686, 106122, 196586, 373027, 373193, 373023, 373188, 214071, 373186, 373106, 373178, 238082, 373102, 373099, 373017, 333406, 372771, 252674, 214018, 214016, 226872, 226870, 106100, 226868, 372901, 372863, 372861, 327162, 180900, 372676, 372196, 372668, 372719, 106096, 213960, 213956, 372663, 106091, 372492, 372182, 372488, 372507, 372505, 252670, 372501, 372484, 372544, 196574, 370722, 196566, 354411, 354408, 196564, 354404, 196561, 196559, 226836, 348663, 372177, 213934, 226830, 226823, 372175, 360743, 196556, 368454, 372167, 277988, 371411, 324634, 362035, 362033, 106077, 371044, 348660, 226797, 323144, 348250, 226795, 265478, 370655, 370387, 370934, 370942, 370345, 180897, 365403, 196532, 226764, 196520, 370884, 370796, 196504, 370794, 361304, 370025, 369952, 213815, 196500, 369950, 213812, 369948, 370021, 370792, 332853, 196494, 328911, 369548, 370493, 329254, 324630, 205297, 369709, 370408, 196492, 368641, 324628, 326927, 322849, 205295, 326915, 368638, 364103, 331291, 366869, 360727, 188692, 355575, 238025, 331289, 333385, 326912, 196484, 196462, 226625, 265476, 226612, 368831, 369601, 265474, 369592, 359472, 180878, 252646, 369589, 329974, 366304, 226605, 369587, 265462, 359467, 362011, 265458, 364805, 342740, 366300, 369557, 368632, 326898, 368630, 368806, 348949, 368827, 325735, 291447, 310327, 368951, 285445, 366196, 367761, 291445, 237977, 180864, 316695, 346842, 368554, 368528, 368524, 368434, 362535, 364803, 237947, 314399, 366631, 366629, 366894, 366603, 366601, 366595, 366589, 366585, 356987, 365483, 364000, 285441, 252628, 366577, 355573, 272044, 332351, 363957, 365825, 106007, 65467, 237883, 237881, 213581, 365103, 365098, 365096, 323138, 325367, 323137, 365812, 365807, 365804, 365802, 365842, 226491, 365799, 226488, 196429, 105966, 364733, 364731, 364728, 364726, 196426, 365425, 237815, 365568, 105960, 105956, 365688, 365686, 105949, 105947, 105945, 360719, 360716, 360714, 44907, 365589, 226478, 328895, 365074, 213539, 226472, 226470, 226468, 347603, 196420, 364364, 364965, 364916, 347600, 359795, 364355, 226458, 359447, 364759, 226455, 359564, 325365, 360699, 105944, 325363, 324602, 105937, 364780, 364837, 364413, 364717, 364711, 364665, 355566, 361524, 364461, 361576, 364005, 364458, 364342, 226421, 364408, 361556, 303167, 361278, 303163, 213440, 333373, 333371, 361271, 363782, 363884, 213387, 363721, 352806, 346825, 358735, 358733, 363653, 363650, 213366, 196399, 363642, 196395, 363444, 325358, 360693, 226351, 226345, 363474, 363497, 360675, 358321, 354397, 348245, 252594, 169442, 360673, 360668, 237718, 213333, 128995, 361023, 363318, 332331, 196387, 323135, 362910, 361654, 128989, 362957, 362955, 362953, 105898, 362986, 363129, 362984, 363127, 362949, 357049, 360585, 277449, 362662, 357046, 360583, 357043, 362658, 355558, 252592, 352961, 362656, 266124, 196380, 266122, 346812, 361964, 361958, 205293, 205291, 205289, 128976, 361950, 361818, 361903, 358722, 362500, 358718, 362573, 362545, 353874, 256202, 237675, 361924, 353872, 361922, 360657, 356182, 361909, 105867, 346805, 237652, 360941, 105859, 105857, 105853, 325730, 105846, 361347, 355283, 361344, 323132, 357771, 355556, 131795, 359758, 360651, 226259, 237632, 105836, 359754, 8483, 322620, 180753, 322827, 361698, 360939, 360936, 361336, 331269, 303141, 360932, 105832, 180749, 105827, 361506, 213291, 358165, 361196, 361073, 361071, 226188, 303129, 226186, 323129, 352928, 361063, 361134, 361019, 361007, 325355, 128969, 324581, 213273, 237542, 325351, 360209, 237539, 128966, 303104, 56798, 360579, 358662, 359560, 128962, 213241, 226129, 237506, 226100, 359617, 226092, 226090, 348945, 226077, 359678, 359728, 189186, 348942, 359673, 324569, 213216, 105767, 358196, 359434, 226006, 356250, 358192, 359403, 358716, 226003, 359425, 358254, 225998, 323114, 196323, 225992, 105749, 237463, 105747, 225980, 355546, 105704, 105698, 180742, 358674, 356240, 357744, 358129, 359168, 357740, 252564, 355543, 346883, 237442, 358231, 358966, 358229, 213160, 225972, 358224, 358704, 356142, 308520, 213153, 359008, 225969, 359004, 358962, 252561, 358221, 358212, 358776, 213137, 358769, 213131, 358766, 196320, 358763, 358508, 358203, 213117, 358758, 237434, 358756, 213114, 225954, 237432, 331251, 128956, 358697, 358576, 358573, 358558, 358555, 324556, 356978, 358547, 225927, 358534, 237370, 356976, 355537, 213043, 355534, 357938, 357969, 356763, 357835, 196292, 357693, 213019, 355531, 352789, 355517, 131758, 357007, 357004, 357153, 356947, 357000, 212929, 225754, 212926, 131741, 225749, 291443, 291441, 252513, 356330, 191797, 225746, 196263, 225743, 225728, 356532, 309909, 131731, 225722, 356136, 131729, 308492, 131727, 225719, 212881, 356478, 356127, 356119, 225696, 355073, 356117, 353839, 212852, 225670, 323106, 225666, 354384, 355385, 356106, 225658, 355513, 225653, 346789, 310312, 323103, 354696, 128944, 354693, 354812, 325725, 128942, 310308, 212784, 212782, 212780, 354373, 212776, 324549, 332850, 212773, 354783, 266851, 353581, 348807, 212767, 105596, 237159, 180629, 212762, 353446, 105579, 347460, 237156, 105576, 265430, 353443, 353297, 315201, 353439, 180595, 353823, 353889, 252494, 315642, 105561, 353821, 105559, 315640, 353719, 225484, 353421, 351678, 268805, 212644, 225392, 105448, 237019, 196181, 351555, 105446, 225332, 338589, 351542, 350720, 225324, 338585, 350770, 303058, 323086, 324536, 303053, 298005, 351393, 350051, 237013, 225300, 350046, 351327, 351293, 348925, 351290, 350186, 351325, 350846, 350762, 350184, 303049, 351322, 196170, 237009, 351318, 225293, 351179, 303043, 351176, 350035, 351171, 347418, 350502, 180454, 105420, 225274, 345840, 237003, 196163, 156240, 350702, 225215, 347452, 225211, 225209, 348918, 297989, 225208, 335675, 196153, 335673, 225205, 349839, 349656, 349778, 347671, 225197, 225193, 225182, 225180, 343337, 131669, 348572, 347563, 331558, 131667, 348569, 331554, 349359, 347647, 348916, 131662, 236967, 346728, 348514, 212510, 348056, 348053, 343427, 343425, 131645, 236946, 236944, 131643, 225151, 348455, 323077, 347140, 343419, 347138, 325349, 347640, 225112, 343413, 343411, 225108, 323075, 225104, 236905, 343407, 343403, 236903, 236885, 225094, 347024, 340847, 344838, 268497, 342415, 345720, 345718, 344285, 329555, 343617, 343493, 330770, 340294, 340394, 340714, 273813, 105322, 224660, 340209, 224658, 224654, 340246, 340472, 212036, 339552, 236565, 335970, 340284, 236557, 340239, 224651, 340595, 340064, 340470, 339289, 323059, 340282, 105315, 340236, 340529, 339229, 340466, 105305, 340042, 105303, 340139, 340056, 340008, 338507, 332820, 338505, 338689, 328664, 338575, 300826, 335946, 314585, 335773, 278130, 338502, 335771, 338409, 338490, 326537, 264126, 337539, 279062, 211818, 211811, 338222, 337983, 315631, 338192, 337530, 277364, 337981, 338189, 318513, 337527, 337849, 102418, 277361, 338128, 211798, 277358, 315629, 196003, 337704, 335943, 336439, 131563, 337178, 323046, 335940, 336435, 337380, 337907, 337752, 323044, 224507, 337444, 277352, 336577, 336576, 277350, 211699, 336053, 236309, 334471, 334468, 297901, 236292, 336035, 336033, 264114, 156219, 335067, 315622, 332587, 332581, 315620, 323038, 323036, 332315, 131505, 264112, 332167, 332312, 224220, 327272, 128880, 131496, 324108, 323029, 323026, 105094, 128878, 331732, 224200, 332254, 331730, 329549, 328484, 328466, 331646, 195927, 264099, 331724, 329545, 306261, 329530, 331128, 331126, 211262, 303599, 211253, 224170, 326461, 326459, 329524, 303595, 330912, 224147, 224122, 330562, 105061, 224120, 224113, 329520, 224101, 329049, 297830, 329047, 285421, 318510, 211183, 297827, 328638, 328635, 328888, 328884, 328843, 328881, 328922, 105053, 328878, 105050, 105048, 322597, 319800, 328866, 303590, 327973, 327059, 328629, 195915, 322596, 325308, 328655, 325345, 328624, 328622, 159276, 328652, 328649, 328619, 195911, 328617, 328646, 328613, 137930, 328644, 326802, 195908, 235929, 327797, 328667, 314576, 328610, 323015, 314571, 235927, 326800, 224063, 310139, 235909, 328146, 325137, 328271, 328460, 328143, 224059, 235907, 195905, 235905, 235903, 252093, 328141, 328102, 305421, 328077, 305639, 327874, 327259, 323013, 327579, 314386, 327055, 327462, 319516, 131468, 326999, 327094, 326621, 326561, 326584, 326581, 323009, 323008, 323006, 325344, 326452, 326578, 195885, 319511, 326590, 326552, 105046, 323002, 306897, 180295, 325939, 320104, 325604, 325936, 325630, 325340, 322999, 105041, 223951, 195875, 180236, 180234, 252054, 319464, 180220, 321445, 319460, 321753, 180215, 314557, 202615, 223889, 223887, 294957, 321441, 321439, 294954, 202600, 202598, 299813, 294952, 180212, 202589, 299809, 180209, 299805, 202586, 211056, 223880, 235836, 260901, 235834, 235832, 321629, 235830, 235828, 211049, 279797, 211045, 235826, 195867, 211039, 195864, 294945, 195862, 260899, 223861, 223857, 223855, 321364, 279783, 318222, 266084, 319796, 314381, 304716, 304714, 304712, 264043, 211027, 304705, 180194, 180192, 314380, 180190, 319792, 321410, 180187, 223853, 252046, 223851, 180185, 262867, 235809, 223847, 320235, 320230, 320094, 223830, 235789, 104995, 104986, 235787, 318408, 318407, 318405, 319207, 317078, 319178, 319138, 319194, 319136, 319132, 223803, 318631, 235753, 318980, 316966, 317475, 310104, 318399, 317473, 318162, 279059, 317052, 317050, 316320, 307419, 307527, 302006, 312460, 312060, 307417, 223328, 304545, 223202, 302497, 300906, 300904, 301581, 261111, 261108, 302390, 302495, 261106, 302386, 261104, 302261, 302259, 302257, 301995, 301924, 301920, 302370, 302892, 302890, 223185, 302367, 302895, 302483, 302480, 302360, 302473, 301965, 301976, 301826, 296213, 301822, 223181, 267881, 235429, 223178, 223176, 301201, 301198, 223172, 300889, 301193, 300763, 235427, 301096, 223170, 300887, 267233, 300758, 300936, 298964, 300614, 300755, 104760, 267229, 267227, 300875, 267223, 297808, 131416, 300473, 223166, 287789, 179822, 179819, 179815, 179813, 299113, 299111, 299868, 131411, 297799, 179808, 21975, 299106, 299317, 258495, 21973, 299104, 179804, 297792, 297588, 296965, 297577, 297214, 291343, 296009, 296244, 296173, 291339, 291964, 125091, 125090, 295262, 125087, 295233, 295080, 294605, 295228, 294598, 223125, 295077, 295210, 295075, 295208, 294771, 291956, 294596, 291953, 291278, 295200, 266610, 256317, 295049, 295182, 295039, 295031, 295027, 294931, 223120, 294929, 294269, 294262, 209998, 294255, 293892, 293886, 291332, 291325, 131347, 131339, 293864, 291321, 293855, 291619, 291615, 131329, 131324, 131322, 291317, 262826, 291314, 287671, 104699, 291613, 262824, 291610, 131319, 104697, 291605, 131315, 292068, 131313, 291603, 291599, 291311, 104692, 291596, 291593, 291590, 104690, 262822, 104675, 291188, 131298, 131294, 258488, 291947, 287245, 287242, 287239, 291306, 287237, 287234, 288876, 288875, 257153, 223103, 223096, 285795, 287651, 131287, 131283, 179640, 285791, 287913, 284548, 179629, 287907, 287648, 179627, 287644, 287904, 284542, 179621, 104513, 284538, 284536, 287392, 209798, 285245, 285414, 131258, 285036, 284634, 284175, 285409, 131253, 285242, 131246, 275753, 274508, 282909, 284530, 283105, 283103, 283101, 282902, 282729, 282897, 278122, 278967, 278965, 278312, 279022, 278907, 279152, 279020, 277657, 278173, 278114, 278111, 277641, 277513, 277627, 277625, 277880, 261029, 277622, 272998, 270427, 268601, 223034, 270413, 104318, 270776, 104316, 223031, 270252, 266267, 266265, 269804, 256497, 266400, 179056, 179054, 270276, 269802, 269369, 270035, 270030, 270014, 203649, 184542, 222959, 222957, 263279, 222955, 268674, 268696, 222953, 188336, 268690, 188334, 235404, 268669, 266397, 235393, 267628, 268301, 268491, 268664, 188332, 268448, 268489, 235380, 263299, 255240, 255233, 256548, 256545, 256543, 255350, 255228, 255196, 253113, 253109, 249598, 250386, 249354, 130799, 249572, 249570, 248432, 248457, 208731, 176412, 208698, 208696, 248125, 195091, 247726, 247706, 247700, 247695, 203180, 203175, 103831, 208232, 208373, 207735, 207991, 103781, 176319, 207377, 207178, 207350, 207228, 174638, 207342, 206802, 204692, 204690, 203364, 203359, 203357, 204614, 204478, 191895, 204472, 204468, 204403, 203632, 130695, 204377, 203629, 130693, 191661, 203993, 204363, 203625, 204313, 204309, 204014, 204109, 161264, 204106, 203145, 203317, 203138, 203133, 203130, 202200, 203128, 203125, 195275, 191883, 195233, 192864, 195222, 194217, 195090, 194208, 194273, 194271, 194200, 194192, 193551, 193133, 194263, 188369, 188086, 175965, 187719, 174592, 174590, 186833, 185239, 174582, 174581, 185990, 185841, 185797, 185899, 165234, 185839, 165231, 185590, 165228, 185850, 182897, 185835, 185848, 165226, 185587, 185846, 185833, 182894, 185630, 185652, 185625, 185621, 185574, 185569, 174566, 185578, 154763, 185560, 174554, 174551, 154760, 184519, 174546, 174527, 185217, 173765, 184893, 184799, 161229, 183588, 183222, 175852, 170991, 182678, 165188, 175831, 181238, 181365, 181361, 175733, 175730, 175726, 175097, 174519, 174511, 175017, 174507, 173736, 174500, 154754, 167676, 174482, 165157, 174463, 165144, 173968, 173337, 173320, 172975, 173317, 171622, 167581, 168476, 171598, 172537, 172388, 171591, 171588, 171584, 172379, 172362, 171519, 171580, 172261, 171578, 171515, 172053, 171221, 171575, 170958, 171201, 171198, 170945, 170887, 170777, 170898, 170424, 170416, 170414, 170412, 168678, 168675, 168547, 166940, 168426, 168469, 168269, 168262, 166289, 165590, 166241, 163753, 165582, 164092, 162695, 158936, 157680, 156989, 154746, 154991, 154931, 154744, 130547, 153041, 154383, 154406, 152846, 153965, 153479, 153936, 152837, 153411, 153467, 153464, 153409, 153216, 153462, 153213, 153211, 153423, 153020, 152588, 130523, 153017, 130517, 152380, 150584, 152569, 151750, 152374, 147242, 147239, 137750, 146982, 146977, 146872, 145244, 146389, 145241, 144929, 146118, 144927, 146111, 144921, 145214, 144913, 130489, 103567, 143915, 143898, 103558, 144040, 142351, 142349, 142344, 127741, 142335, 140279, 140358, 140273, 139943, 139537, 139735, 138431, 138428, 139404, 135143, 137745, 137739, 137101, 136230, 137099, 136226, 121791, 135804, 126109, 85525, 135342, 135727, 135607, 135435, 135548, 135389, 135430, 135387, 135482, 135428, 135309, 135294, 135338, 135239, 134932, 134675, 134907, 134066, 134905, 125913, 124307, 134903, 134883, 134806, 130465, 134633, 134525, 134566, 134513, 134510, 134016, 121767, 134103, 121758, 121756, 133964, 130454, 134099, 133987, 133983, 128497, 133960, 133941, 130444, 121738, 130436, 121717, 130423, 130362, 130416, 130360, 130334, 130356, 130325, 130311, 130208, 128786, 128780, 128667, 128634, 129272, 128624, 127837, 128649, 129109, 128646, 128105, 128137, 128245, 118627, 127812, 127860, 127809, 127711, 127708, 127706, 127289, 127307, 127338, 125839, 127112, 127081, 125965, 126277, 124654, 126256, 126232, 126029, 126173, 126027, 126162, 126024, 125603, 125597, 125594, 125591, 125371, 125431, 125387, 125229, 125365, 125361, 125224, 125037, 125359, 115363, 125335, 124990, 124629, 125205, 124316, 124411, 124405, 124337, 124331, 123868, 122263, 124063, 122260, 124059, 123174, 124050, 123713, 123159, 122814, 121281, 121673, 121667, 122119, 103534, 122147, 103527, 103523, 121617, 116047, 87207, 116045, 121651, 116043, 121613, 121464, 121040, 121243, 99989, 116030, 116518, 103451, 103448, 103443, 116020, 116143, 116139, 116013, 115939, 116010, 115936, 111984, 111424, 99074, 103363, 100677, 98865, 98770, 97977, 96370, 96214, 94875, 63401, 94226, 94182, 94224, 94019, 94043, 94017, 88004, 94015, 94039, 94035, 93645, 89628, 93626, 93623, 89622, 91569, 92446, 92437, 78803, 91558, 89262, 89570, 89260, 89432, 89086, 32740, 89070, 88892, 88843, 88837, 87537, 87999, 88409, 88533, 88407, 88340, 87724, 87959, 87690, 86790, 85834, 85827, 85993, 85773, 83502, 84329, 84070, 85825, 85771, 85763, 84068, 69672, 82108, 85004, 82442, 75167, 64921, 75706, 74544, 71229, 73779, 74286, 72033, 71112, 32663, 70678, 70844, 70671, 70841, 70827, 70823, 69667, 69663, 68312, 69143, 68295, 68286, 55354, 67875, 68283, 66256, 64909, 65800, 64907, 65852, 65841, 59311, 64711, 56779, 54201, 54675, 53622, 17318, 54196))
Run Time: 0.070967
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3794 | |
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 | | | | | 3794 | |
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 (26682, 26681, 23343, 21606, 21604, 20511, 19891, 19844, 19815, 19342, 19082, 19077, 18676, 18237, 18182, 16233, 16152, 15115, 15068, 15017, 14996, 14990, 14137, 13780, 13135, 12597, 12418, 12307, 12295, 12243, 12242, 11200, 11175, 10441, 9416, 9154, 8678, 6229, 6228, 6124, 5109))
Run Time: 0.002022
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 41 | 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, l
Run Time: 0.000428
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.000586
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.000674
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