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.000587
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.000223
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` = '4682')
LIMIT 1
Run Time: 0.000390
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.001721
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_4682' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.110793
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 (469053, 529489, 396514, 396513, 330411, 200221, 396511, 469043, 529207, 529142, 402786, 548202, 430279, 430152, 200110, 528885, 322514, 323599, 389201, 232661, 469041, 396504, 528862, 396500, 396487, 429649, 330348, 469039, 200062, 402766, 453556, 469034, 469031, 323595, 200021, 369120, 429115, 200007, 528716, 535792, 330341, 199990, 429046, 199973, 428993, 243842, 402751, 199929, 528210, 383611, 413787, 469025, 421755, 219256, 396481, 396479, 199915, 469024, 523526, 428494, 108581, 330327, 367419, 428312, 469020, 243640, 108550, 461729, 396477, 469017, 199829, 427871, 199809, 325061, 396473, 330305, 469014, 325051, 427726, 199784, 507891, 232074, 469013, 323578, 427656, 396472, 199760, 469006, 199758, 511734, 386881, 199742, 218619, 323969, 469002, 199717, 199714, 427411, 323571, 325034, 381603, 510610, 325033, 199702, 396471, 330288, 413783, 406971, 199697, 360815, 325030, 427278, 362338, 427240, 427225, 469000, 323557, 199655, 369084, 199649, 199636, 406969, 199634, 299345, 108362, 427121, 218575, 108334, 508827, 468998, 231901, 330280, 218549, 367342, 406967, 349138, 199608, 386880, 349522, 323555, 468993, 199585, 386878, 506877, 218470, 385868, 199562, 505764, 468990, 505756, 497496, 199553, 413770, 402715, 413765, 199538, 468988, 504777, 396455, 426762, 243182, 243155, 624749, 426603, 199487, 426575, 416065, 386876, 108254, 349131, 199478, 502981, 426550, 468981, 468978, 426512, 502611, 330259, 199471, 243030, 323547, 199463, 367293, 406963, 453462, 468975, 396454, 468974, 501279, 416394, 218212, 242997, 406960, 468973, 383609, 499853, 323544, 199451, 199442, 386874, 242976, 242969, 199427, 199419, 380360, 199412, 199407, 426082, 330241, 330239, 426076, 426068, 468938, 199398, 218085, 330236, 199397, 468931, 380350, 218060, 199393, 425960, 497895, 199387, 386872, 497485, 199380, 325002, 425926, 199370, 324992, 217965, 468927, 425749, 324983, 425734, 199331, 330227, 330225, 624626, 324976, 396449, 199313, 199310, 323530, 425694, 199299, 199296, 375974, 330219, 492917, 380346, 386864, 492724, 492717, 323529, 376196, 386862, 254106, 199287, 199285, 217857, 230982, 483476, 492083, 492075, 425626, 492072, 199267, 468924, 199262, 411783, 199254, 425569, 491281, 242728, 425528, 349120, 469386, 199242, 490988, 425514, 199235, 230864, 490055, 217784, 217781, 489937, 468922, 324964, 199227, 242674, 217771, 323524, 485184, 485181, 425483, 330213, 468921, 396447, 199216, 425477, 396443, 217750, 242643, 199206, 199201, 199199, 425392, 425388, 425383, 468920, 386861, 324959, 347930, 199193, 108037, 199182, 217641, 369063, 199180, 468916, 199174, 468915, 199163, 199153, 349107, 242570, 472568, 199150, 470844, 108017, 199148, 487090, 324943, 242541, 421750, 324940, 468914, 199146, 242534, 217609, 132677, 199087, 483195, 483194, 199084, 483043, 199080, 396441, 199068, 468909, 323518, 482583, 468907, 386859, 468902, 199046, 480981, 132647, 400074, 242350, 468899, 480768, 424989, 424987, 468897, 199040, 230532, 421749, 355845, 199030, 468896, 323514, 199025, 230509, 468894, 424952, 424948, 205753, 468890, 199021, 424925, 480049, 217436, 468888, 480045, 480041, 199017, 480038, 424914, 11938, 11936, 466545, 199012, 468887, 217422, 198997, 107961, 242268, 468882, 386858, 198982, 477911, 198980, 107940, 107930, 198979, 330186, 477219, 198977, 468879, 230320, 477093, 198972, 324918, 323508, 324916, 198934, 476476, 198924, 476383, 198920, 198907, 468877, 217317, 230270, 468876, 468875, 198900, 198895, 242185, 198888, 217266, 386857, 198878, 468868, 468867, 230216, 198869, 230178, 198861, 242159, 242157, 468866, 323507, 198854, 217210, 386855, 424636, 324905, 198846, 242134, 323505, 242110, 198803, 328388, 424558, 468864, 471007, 198775, 471469, 471452, 198769, 424545, 198761, 468863, 322407, 323502, 468861, 198757, 468860, 198740, 470405, 470402, 468858, 424502, 349086, 230097, 230095, 198729, 468856, 453396, 198725, 424495, 330178, 468855, 198721, 386852, 198718, 198714, 468851, 468850, 198709, 242023, 217019, 242017, 252824, 416052, 468848, 198701, 198695, 328377, 323498, 198685, 198681, 467850, 198667, 198664, 468327, 468295, 216972, 216969, 241908, 198661, 386848, 198654, 424398, 241902, 198649, 453384, 450908, 323496, 467855, 330169, 198639, 386845, 467416, 421742, 421741, 198632, 198628, 198618, 466022, 241783, 216898, 466420, 198610, 396438, 466006, 198593, 198590, 453374, 424225, 198587, 421740, 198563, 198561, 323490, 241735, 387715, 198551, 241732, 198547, 465070, 241730, 424164, 198540, 198537, 396436, 464733, 198536, 421730, 323486, 386837, 198522, 323484, 107699, 198500, 198488, 216798, 324886, 323482, 402689, 216789, 462926, 198455, 400072, 323481, 386836, 453369, 424039, 461888, 198443, 229831, 198438, 461476, 461474, 22956, 216740, 198432, 216716, 216712, 198424, 461104, 460768, 386834, 198402, 408528, 396432, 396431, 216703, 198399, 460672, 198392, 453368, 460559, 330147, 198365, 324876, 198358, 198350, 198348, 323479, 459238, 459210, 459149, 198346, 323478, 459142, 423903, 216673, 423897, 107627, 198342, 409695, 458849, 330139, 386831, 330137, 198321, 323476, 325520, 198311, 198304, 456849, 198300, 216642, 330134, 457573, 457550, 457537, 396427, 198294, 198282, 241443, 198273, 386830, 198269, 198267, 110218, 456100, 386829, 323473, 386827, 355814, 216607, 198265, 323472, 456524, 330132, 198260, 453352, 229689, 198256, 349075, 324856, 198248, 198242, 376113, 198239, 386826, 241352, 198230, 229639, 198229, 229603, 455261, 324850, 198222, 455221, 198219, 241325, 216553, 454952, 330130, 198214, 386825, 198204, 324848, 198186, 198185, 617649, 402666, 198182, 323465, 454007, 198178, 361094, 406944, 453855, 198175, 198170, 198168, 323464, 198165, 216480, 241261, 198155, 229521, 452652, 409506, 198141, 386824, 198140, 386822, 198138, 229512, 452165, 198132, 386821, 198131, 229498, 198129, 216442, 402659, 349066, 402657, 198122, 451421, 451901, 324832, 402651, 323462, 371021, 198115, 241185, 386820, 198109, 198104, 396424, 451407, 229471, 229469, 423806, 198101, 107475, 323459, 324824, 198100, 198097, 400067, 450677, 324823, 323457, 198093, 229449, 386819, 198088, 450236, 241140, 198087, 241137, 241134, 216414, 448709, 323456, 198086, 198078, 423798, 198076, 198071, 198061, 198056, 198052, 449308, 198050, 449021, 423793, 198048, 252766, 323451, 198046, 448763, 448463, 448461, 423778, 198039, 448327, 198034, 416046, 411622, 448441, 386816, 448439, 198032, 448066, 448262, 198027, 448143, 448036, 423557, 198026, 423763, 198024, 423758, 423756, 216292, 386815, 198018, 411617, 411615, 411613, 330110, 198013, 198012, 349059, 409771, 198010, 423417, 323446, 330104, 423183, 423181, 198006, 198004, 421641, 386812, 421726, 197996, 229179, 229177, 197994, 386811, 323445, 330100, 330098, 197989, 422316, 422704, 323443, 367091, 197984, 361054, 330097, 421633, 197980, 229138, 229136, 422119, 229132, 216247, 396421, 197976, 197962, 240878, 421571, 197956, 421413, 420840, 197948, 342763, 396420, 386810, 197943, 420251, 420766, 419309, 197939, 420033, 420164, 107362, 323441, 420023, 197937, 240811, 197936, 323440, 197934, 216192, 386809, 419700, 197929, 197916, 229055, 197908, 229041, 386808, 419301, 197906, 240739, 197904, 197896, 323433, 197893, 240731, 418604, 197889, 396418, 216159, 378781, 418584, 197882, 240722, 418540, 197878, 349051, 386806, 197874, 197871, 418150, 378780, 197869, 323431, 386804, 197868, 216127, 323429, 417646, 229014, 197865, 396417, 197864, 411573, 197855, 416107, 240685, 228953, 416104, 197854, 416100, 411064, 240665, 240662, 240660, 240658, 197851, 323428, 416557, 197850, 240618, 393296, 411567, 216069, 197848, 393294, 416035, 228916, 205515, 386802, 197845, 353050, 205513, 197841, 415690, 240586, 415631, 197838, 349036, 415627, 415625, 386799, 396416, 240575, 132137, 415215, 228869, 197803, 197797, 228865, 361050, 324788, 323423, 414586, 414621, 197789, 197787, 240541, 216012, 414418, 414428, 386797, 414416, 414347, 197783, 355754, 378779, 402650, 197780, 355753, 215987, 396414, 396412, 396411, 197778, 386796, 197776, 330083, 197775, 381529, 413295, 240505, 197772, 413226, 386795, 197765, 413096, 413118, 107231, 228798, 386794, 197764, 215933, 411486, 107201, 107192, 228791, 228788, 107183, 228784, 197763, 386793, 411530, 323419, 411483, 197758, 197754, 240460, 367079, 240457, 405301, 215912, 405298, 405296, 396410, 197752, 411014, 240454, 240451, 396409, 240444, 411108, 110143, 402649, 197748, 411056, 330078, 409739, 405287, 215894, 353039, 197740, 405283, 386784, 405276, 197736, 197731, 393919, 240420, 330077, 386783, 396399, 355742, 405268, 197719, 402648, 197716, 323418, 240383, 330071, 405260, 240378, 396396, 324773, 323416, 240370, 197712, 362264, 362262, 323415, 228676, 405246, 197709, 353037, 396392, 386781, 323413, 324767, 197699, 240344, 197692, 409718, 409632, 353034, 409630, 386780, 402647, 197690, 408387, 323412, 408384, 408382, 197682, 197674, 197672, 323411, 240300, 409351, 386779, 215775, 197668, 396390, 215764, 409087, 197661, 228592, 396388, 402641, 386777, 228536, 330069, 330067, 402639, 197650, 408119, 408117, 407112, 408845, 240220, 240218, 228506, 197640, 396381, 197631, 396379, 323410, 197626, 330064, 197623, 215716, 323407, 386776, 228480, 197621, 197611, 354431, 228458, 354429, 197605, 402637, 323406, 197601, 228448, 228446, 333504, 323404, 228443, 228441, 407845, 228437, 197595, 386775, 378773, 107126, 240114, 407780, 400058, 323402, 107117, 400052, 107108, 353031, 402636, 197591, 386774, 197579, 402635, 407539, 197575, 392917, 402634, 323400, 197573, 396378, 396377, 349017, 197551, 323399, 197548, 228344, 386772, 330060, 406686, 197544, 323397, 353027, 400044, 197537, 228304, 355718, 396376, 323395, 402633, 402954, 107044, 197533, 402629, 396375, 330059, 228286, 402627, 323394, 197531, 405673, 228280, 197518, 355716, 402626, 386771, 396374, 197507, 215617, 405136, 323393, 197504, 330057, 197499, 330056, 188143, 188140, 400022, 324736, 353024, 400020, 197483, 405060, 197478, 228225, 323390, 197476, 386766, 402625, 323387, 228223, 404967, 404940, 396371, 197475, 354428, 386764, 323383, 386763, 402621, 215569, 197467, 353020, 402618, 355698, 367055, 396822, 402610, 402602, 197351, 239811, 402059, 396360, 239800, 197349, 396358, 197348, 239775, 401750, 396357, 197345, 401735, 197341, 239769, 239763, 396355, 323359, 197338, 386757, 323356, 197335, 401554, 386756, 197331, 396350, 362183, 362179, 323353, 400937, 228132, 386755, 197326, 362141, 362138, 239678, 400914, 386753, 197324, 323349, 396346, 401363, 401361, 401366, 401359, 239650, 323344, 401067, 197321, 401064, 400012, 401250, 401248, 400840, 401246, 197320, 401060, 401058, 323341, 197315, 197313, 239621, 323337, 400003, 106848, 106847, 197312, 400251, 106844, 215331, 400248, 386751, 197309, 399824, 323331, 197307, 323329, 391770, 239608, 323326, 215322, 197306, 400136, 228078, 398636, 197304, 399756, 197302, 399580, 333461, 399753, 197300, 106825, 106822, 106820, 355673, 323321, 197292, 324690, 399585, 197289, 197287, 399560, 197286, 396345, 197284, 398312, 325764, 197282, 215292, 399519, 398310, 396342, 323317, 398307, 197280, 228032, 228029, 323305, 239549, 197277, 396338, 197275, 398946, 323302, 386750, 396334, 197271, 197265, 398900, 197260, 398291, 398288, 323299, 398279, 197254, 397043, 359859, 227972, 367023, 197252, 323296, 227969, 398574, 197240, 323294, 323285, 106778, 106776, 197232, 398267, 396008, 197228, 197222, 106772, 398221, 397685, 323284, 106770, 398017, 397679, 397674, 396330, 397841, 323282, 397839, 197221, 106768, 396326, 397760, 197213, 197209, 227911, 227908, 215234, 197204, 323280, 106751, 386744, 397606, 323278, 197201, 239441, 397633, 397557, 227896, 106747, 397589, 396325, 323276, 396323, 397566, 323274, 396321, 386121, 323272, 227891, 197200, 397561, 197192, 197190, 397488, 323271, 397092, 396317, 397054, 171666, 197181, 106734, 397052, 106730, 106726, 106724, 396819, 106722, 215217, 396817, 396884, 396813, 396905, 239424, 197180, 396314, 386743, 323270, 197178, 391768, 323269, 394584, 396808, 215215, 215210, 396769, 197173, 106720, 197171, 396309, 205376, 396308, 386740, 197169, 396305, 106719, 106716, 367014, 197159, 239410, 106711, 396299, 396298, 197157, 323268, 197155, 396282, 396289, 197153, 396267, 197143, 323267, 197135, 395967, 395965, 323264, 323262, 323260, 197123, 239375, 197121, 395849, 323256, 323254, 197116, 197113, 197111, 227796, 367010, 323251, 364701, 364697, 323247, 325759, 378766, 323245, 239339, 323243, 323238, 197077, 390023, 395300, 395355, 323236, 378764, 197076, 239322, 378762, 386735, 367006, 197072, 197070, 197068, 323234, 197063, 323232, 227752, 239298, 323230, 197061, 394307, 197057, 394574, 323226, 197055, 197048, 393377, 323222, 394185, 391765, 197046, 323219, 348976, 197044, 394032, 394026, 197041, 367001, 197035, 323214, 323212, 355121, 393644, 387808, 393642, 355600, 197033, 393635, 393890, 393633, 366997, 323208, 393724, 197028, 322249, 323206, 393286, 393360, 393356, 393354, 197021, 393350, 393283, 393316, 366993, 392810, 392983, 315664, 315661, 392271, 392592, 392268, 392266, 392265, 215044, 392392, 392262, 392260, 392259, 197001, 383812, 196998, 392302, 392249, 392243, 196980, 196973, 323196, 106578, 330039, 214894))
Run Time: 0.113862
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1640 | |
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 | | | | | 1640 | |
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 (24888, 24636, 23288, 21923, 21579, 21356, 21075, 20281, 20108, 20080, 20042, 20023, 19855, 19808, 19793, 19768))
Run Time: 0.002930
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 16 | 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 (469053, 529489, 396514, 396513, 330411, 200221, 396511, 469043, 529207, 529142, 402786, 548202, 430279, 430152, 200110, 528885, 322514, 323599, 389201, 232661, 469041, 396504, 528862, 396500, 396487, 429649, 330348, 469039, 200062, 402766, 453556, 469034, 469031, 323595, 200021, 369120, 429115, 200007, 528716, 535792, 330341, 199990, 429046, 199973, 428993, 243842, 402751, 199929, 528210, 383611, 413787, 469025, 421755, 219256, 396481, 396479, 199915, 469024, 523526, 428494, 108581, 330327, 367419, 428312, 469020, 243640, 108550, 461729, 396477, 469017, 199829, 427871, 199809, 325061, 396473, 330305, 469014, 325051, 427726, 199784, 507891, 232074, 469013, 323578, 427656, 396472, 199760, 469006, 199758, 511734, 386881, 199742, 218619, 323969, 469002, 199717, 199714, 427411, 323571, 325034, 381603, 510610, 325033, 199702, 396471, 330288, 413783, 406971, 199697, 360815, 325030, 427278, 362338, 427240, 427225, 469000, 323557, 199655, 369084, 199649, 199636, 406969, 199634, 299345, 108362, 427121, 218575, 108334, 508827, 468998, 231901, 330280, 218549, 367342, 406967, 349138, 199608, 386880, 349522, 323555, 468993, 199585, 386878, 506877, 218470, 385868, 199562, 505764, 468990, 505756, 497496, 199553, 413770, 402715, 413765, 199538, 468988, 504777, 396455, 426762, 243182, 243155, 624749, 426603, 199487, 426575, 416065, 386876, 108254, 349131, 199478, 502981, 426550, 468981, 468978, 426512, 502611, 330259, 199471, 243030, 323547, 199463, 367293, 406963, 453462, 468975, 396454, 468974, 501279, 416394, 218212, 242997, 406960, 468973, 383609, 499853, 323544, 199451, 199442, 386874, 242976, 242969, 199427, 199419, 380360, 199412, 199407, 426082, 330241, 330239, 426076, 426068, 468938, 199398, 218085, 330236, 199397, 468931, 380350, 218060, 199393, 425960, 497895, 199387, 386872, 497485, 199380, 325002, 425926, 199370, 324992, 217965, 468927, 425749, 324983, 425734, 199331, 330227, 330225, 624626, 324976, 396449, 199313, 199310, 323530, 425694, 199299, 199296, 375974, 330219, 492917, 380346, 386864, 492724, 492717, 323529, 376196, 386862, 254106, 199287, 199285, 217857, 230982, 483476, 492083, 492075, 425626, 492072, 199267, 468924, 199262, 411783, 199254, 425569, 491281, 242728, 425528, 349120, 469386, 199242, 490988, 425514, 199235, 230864, 490055, 217784, 217781, 489937, 468922, 324964, 199227, 242674, 217771, 323524, 485184, 485181, 425483, 330213, 468921, 396447, 199216, 425477, 396443, 217750, 242643, 199206, 199201, 199199, 425392, 425388, 425383, 468920, 386861, 324959, 347930, 199193, 108037, 199182, 217641, 369063, 199180, 468916, 199174, 468915, 199163, 199153, 349107, 242570, 472568, 199150, 470844, 108017, 199148, 487090, 324943, 242541, 421750, 324940, 468914, 199146, 242534, 217609, 132677, 199087, 483195, 483194, 199084, 483043, 199080, 396441, 199068, 468909, 323518, 482583, 468907, 386859, 468902, 199046, 480981, 132647, 400074, 242350, 468899, 480768, 424989, 424987, 468897, 199040, 230532, 421749, 355845, 199030, 468896, 323514, 199025, 230509, 468894, 424952, 424948, 205753, 468890, 199021, 424925, 480049, 217436, 468888, 480045, 480041, 199017, 480038, 424914, 11938, 11936, 466545, 199012, 468887, 217422, 198997, 107961, 242268, 468882, 386858, 198982, 477911, 198980, 107940, 107930, 198979, 330186, 477219, 198977, 468879, 230320, 477093, 198972, 324918, 323508, 324916, 198934, 476476, 198924, 476383, 198920, 198907, 468877, 217317, 230270, 468876, 468875, 198900, 198895, 242185, 198888, 217266, 386857, 198878, 468868, 468867, 230216, 198869, 230178, 198861, 242159, 242157, 468866, 323507, 198854, 217210, 386855, 424636, 324905, 198846, 242134, 323505, 242110, 198803, 328388, 424558, 468864, 471007, 198775, 471469, 471452, 198769, 424545, 198761, 468863, 322407, 323502, 468861, 198757, 468860, 198740, 470405, 470402, 468858, 424502, 349086, 230097, 230095, 198729, 468856, 453396, 198725, 424495, 330178, 468855, 198721, 386852, 198718, 198714, 468851, 468850, 198709, 242023, 217019, 242017, 252824, 416052, 468848, 198701, 198695, 328377, 323498, 198685, 198681, 467850, 198667, 198664, 468327, 468295, 216972, 216969, 241908, 198661, 386848, 198654, 424398, 241902, 198649, 453384, 450908, 323496, 467855, 330169, 198639, 386845, 467416, 421742, 421741, 198632, 198628, 198618, 466022, 241783, 216898, 466420, 198610, 396438, 466006, 198593, 198590, 453374, 424225, 198587, 421740, 198563, 198561, 323490, 241735, 387715, 198551, 241732, 198547, 465070, 241730, 424164, 198540, 198537, 396436, 464733, 198536, 421730, 323486, 386837, 198522, 323484, 107699, 198500, 198488, 216798, 324886, 323482, 402689, 216789, 462926, 198455, 400072, 323481, 386836, 453369, 424039, 461888, 198443, 229831, 198438, 461476, 461474, 22956, 216740, 198432, 216716, 216712, 198424, 461104, 460768, 386834, 198402, 408528, 396432, 396431, 216703, 198399, 460672, 198392, 453368, 460559, 330147, 198365, 324876, 198358, 198350, 198348, 323479, 459238, 459210, 459149, 198346, 323478, 459142, 423903, 216673, 423897, 107627, 198342, 409695, 458849, 330139, 386831, 330137, 198321, 323476, 325520, 198311, 198304, 456849, 198300, 216642, 330134, 457573, 457550, 457537, 396427, 198294, 198282, 241443, 198273, 386830, 198269, 198267, 110218, 456100, 386829, 323473, 386827, 355814, 216607, 198265, 323472, 456524, 330132, 198260, 453352, 229689, 198256, 349075, 324856, 198248, 198242, 376113, 198239, 386826, 241352, 198230, 229639, 198229, 229603, 455261, 324850, 198222, 455221, 198219, 241325, 216553, 454952, 330130, 198214, 386825, 198204, 324848, 198186, 198185, 617649, 402666, 198182, 323465, 454007, 198178, 361094, 406944, 453855, 198175, 198170, 198168, 323464, 198165, 216480, 241261, 198155, 229521, 452652, 409506, 198141, 386824, 198140, 386822, 198138, 229512, 452165, 198132, 386821, 198131, 229498, 198129, 216442, 402659, 349066, 402657, 198122, 451421, 451901, 324832, 402651, 323462, 371021, 198115, 241185, 386820, 198109, 198104, 396424, 451407, 229471, 229469, 423806, 198101, 107475, 323459, 324824, 198100, 198097, 400067, 450677, 324823, 323457, 198093, 229449, 386819, 198088, 450236, 241140, 198087, 241137, 241134, 216414, 448709, 323456, 198086, 198078, 423798, 198076, 198071, 198061, 198056, 198052, 449308, 198050, 449021, 423793, 198048, 252766, 323451, 198046, 448763, 448463, 448461, 423778, 198039, 448327, 198034, 416046, 411622, 448441, 386816, 448439, 198032, 448066, 448262, 198027, 448143, 448036, 423557, 198026, 423763, 198024, 423758, 423756, 216292, 386815, 198018, 411617, 411615, 411613, 330110, 198013, 198012, 349059, 409771, 198010, 423417, 323446, 330104, 423183, 423181, 198006, 198004, 421641, 386812, 421726, 197996, 229179, 229177, 197994, 386811, 323445, 330100, 330098, 197989, 422316, 422704, 323443, 367091, 197984, 361054, 330097, 421633, 197980, 229138, 229136, 422119, 229132, 216247, 396421, 197976, 197962, 240878, 421571, 197956, 421413, 420840, 197948, 342763, 396420, 386810, 197943, 420251, 420766, 419309, 197939, 420033, 420164, 107362, 323441, 420023, 197937, 240811, 197936, 323440, 197934, 216192, 386809, 419700, 197929, 197916, 229055, 197908, 229041, 386808, 419301, 197906, 240739, 197904, 197896, 323433, 197893, 240731, 418604, 197889, 396418, 216159, 378781, 418584, 197882, 240722, 418540, 197878, 349051, 386806, 197874, 197871, 418150, 378780, 197869, 323431, 386804, 197868, 216127, 323429, 417646, 229014, 197865, 396417, 197864, 411573, 197855, 416107, 240685, 228953, 416104, 197854, 416100, 411064, 240665, 240662, 240660, 240658, 197851, 323428, 416557, 197850, 240618, 393296, 411567, 216069, 197848, 393294, 416035, 228916, 205515, 386802, 197845, 353050, 205513, 197841, 415690, 240586, 415631, 197838, 349036, 415627, 415625, 386799, 396416, 240575, 132137, 415215, 228869, 197803, 197797, 228865, 361050, 324788, 323423, 414586, 414621, 197789, 197787, 240541, 216012, 414418, 414428, 386797, 414416, 414347, 197783, 355754, 378779, 402650, 197780, 355753, 215987, 396414, 396412, 396411, 197778, 386796, 197776, 330083, 197775, 381529, 413295, 240505, 197772, 413226, 386795, 197765, 413096, 413118, 107231, 228798, 386794, 197764, 215933, 411486, 107201, 107192, 228791, 228788, 107183, 228784, 197763, 386793, 411530, 323419, 411483, 197758, 197754, 240460, 367079, 240457, 405301, 215912, 405298, 405296, 396410, 197752, 411014, 240454, 240451, 396409, 240444, 411108, 110143, 402649, 197748, 411056, 330078, 409739, 405287, 215894, 353039, 197740, 405283, 386784, 405276, 197736, 197731, 393919, 240420, 330077, 386783, 396399, 355742, 405268, 197719, 402648, 197716, 323418, 240383, 330071, 405260, 240378, 396396, 324773, 323416, 240370, 197712, 362264, 362262, 323415, 228676, 405246, 197709, 353037, 396392, 386781, 323413, 324767, 197699, 240344, 197692, 409718, 409632, 353034, 409630, 386780, 402647, 197690, 408387, 323412, 408384, 408382, 197682, 197674, 197672, 323411, 240300, 409351, 386779, 215775, 197668, 396390, 215764, 409087, 197661, 228592, 396388, 402641, 386777, 228536, 330069, 330067, 402639, 197650, 408119, 408117, 407112, 408845, 240220, 240218, 228506, 197640, 396381, 197631, 396379, 323410, 197626, 330064, 197623, 215716, 323407, 386776, 228480, 197621, 197611, 354431, 228458, 354429, 197605, 402637, 323406, 197601, 228448, 228446, 333504, 323404, 228443, 228441, 407845, 228437, 197595, 386775, 378773, 107126, 240114, 407780, 400058, 323402, 107117, 400052, 107108, 353031, 402636, 197591, 386774, 197579, 402635, 407539, 197575, 392917, 402634, 323400, 197573, 396378, 396377, 349017, 197551, 323399, 197548, 228344, 386772, 330060, 406686, 197544, 323397, 353027, 400044, 197537, 228304, 355718, 396376, 323395, 402633, 402954, 107044, 197533, 402629, 396375, 330059, 228286, 402627, 323394, 197531, 405673, 228280, 197518, 355716, 402626, 386771, 396374, 197507, 215617, 405136, 323393, 197504, 330057, 197499, 330056, 188143, 188140, 400022, 324736, 353024, 400020, 197483, 405060, 197478, 228225, 323390, 197476, 386766, 402625, 323387, 228223, 404967, 404940, 396371, 197475, 354428, 386764, 323383, 386763, 402621, 215569, 197467, 353020, 402618, 355698, 367055, 396822, 402610, 402602, 197351, 239811, 402059, 396360, 239800, 197349, 396358, 197348, 239775, 401750, 396357, 197345, 401735, 197341, 239769, 239763, 396355, 323359, 197338, 386757, 323356, 197335, 401554, 386756, 197331, 396350, 362183, 362179, 323353, 400937, 228132, 386755, 197326, 362141, 362138, 239678, 400914, 386753, 197324, 323349, 396346, 401363, 401361, 401366, 401359, 239650, 323344, 401067, 197321, 401064, 400012, 401250, 401248, 400840, 401246, 197320, 401060, 401058, 323341, 197315, 197313, 239621, 323337, 400003, 106848, 106847, 197312, 400251, 106844, 215331, 400248, 386751, 197309, 399824, 323331, 197307, 323329, 391770, 239608, 323326, 215322, 197306, 400136, 228078, 398636, 197304, 399756, 197302, 399580, 333461, 399753, 197300, 106825, 106822, 106820, 355673, 323321, 197292, 324690, 399585, 197289, 197287, 399560, 197286, 396345, 197284, 398312, 325764, 197282, 215292, 399519, 398310, 396342, 323317, 398307, 197280, 228032, 228029, 323305, 239549, 197277, 396338, 197275, 398946, 323302, 386750, 396334, 197271, 197265, 398900, 197260, 398291, 398288, 323299, 398279, 197254, 397043, 359859, 227972, 367023, 197252, 323296, 227969, 398574, 197240, 323294, 323285, 106778, 106776, 197232, 398267, 396008, 197228, 197222, 106772, 398221, 397685, 323284, 106770, 398017, 397679, 397674, 396330, 397841, 323282, 397839, 197221, 106768, 396326, 397760, 197213, 197209, 227911, 227908, 215234, 197204, 323280, 106751, 386744, 397606, 323278, 197201, 239441, 397633, 397557, 227896, 106747, 397589, 396325, 323276, 396323, 397566, 323274, 396321, 386121, 323272, 227891, 197200, 397561, 197192, 197190, 397488, 323271, 397092, 396317, 397054, 171666, 197181, 106734, 397052, 106730, 106726, 106724, 396819, 106722, 215217, 396817, 396884, 396813, 396905, 239424, 197180, 396314, 386743, 323270, 197178, 391768, 323269, 394584, 396808, 215215, 215210, 396769, 197173, 106720, 197171, 396309, 205376, 396308, 386740, 197169, 396305, 106719, 106716, 367014, 197159, 239410, 106711, 396299, 396298, 197157, 323268, 197155, 396282, 396289, 197153, 396267, 197143, 323267, 197135, 395967, 395965, 323264, 323262, 323260, 197123, 239375, 197121, 395849, 323256, 323254, 197116, 197113, 197111, 227796, 367010, 323251, 364701, 364697, 323247, 325759, 378766, 323245, 239339, 323243, 323238, 197077, 390023, 395300, 395355, 323236, 378764, 197076, 239322, 378762, 386735, 367006, 197072, 197070, 197068, 323234, 197063, 323232, 227752, 239298, 323230, 197061, 394307, 197057, 394574, 323226, 197055, 197048, 393377, 323222, 394185, 391765, 197046, 323219, 348976, 197044, 394032, 394026, 197041, 367001, 197035, 323214, 323212, 355121, 393644, 387808, 393642, 355600, 197033, 393635, 393890, 393633, 366997, 323208, 393724, 197028, 322249, 323206, 393286, 393360, 393356, 393354, 197021, 393350, 393283, 393316, 366993, 392810, 392983, 315664, 315661, 392271, 392592, 392268, 392266, 392265, 215044, 392392, 392262, 392260, 392259, 197001, 383812, 196998, 392302, 392249, 392243, 196980, 196973, 323196, 106578, 330039, 214894))
Run Time: 0.041703
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1640 | |
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 | | | | | 1640 | |
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 (24888, 24636, 23288, 21923, 21579, 21356, 21075, 20281, 20108, 20080, 20042, 20023, 19855, 19808, 19793, 19768))
Run Time: 0.001216
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 16 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, ز�
Run Time: 0.000199
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.000298
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 158
- 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.000520
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 158
- 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: 1717117298
Run Time: 0.000266
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 17 | 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` >= 1717117298)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000483
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 17 | 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