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.000607
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.000251
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` = '5699')
LIMIT 1
Run Time: 0.000658
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.002289
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_5699' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.153393
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 (646193, 646170, 646091, 646062, 646041, 646033, 646025, 646023, 646003, 645978, 645973, 645923, 645908, 645812, 645783, 645778, 645775, 645768, 645767, 645760, 645748, 645747, 645721, 645720, 645716, 645713, 645711, 645699, 645696, 645618, 645615, 645606, 645553, 645549, 645519, 645499, 645497, 645442, 645425, 645419, 645411, 645322, 645177, 645151, 645108, 645093, 645092, 645085, 645065, 645051, 645044, 645043, 645001, 645000, 644922, 644919, 644902, 644882, 644790, 644776, 644669, 644667, 644662, 644635, 644557, 644541, 644528, 644452, 644411, 644403, 644402, 644361, 644360, 644358, 644354, 644348, 644347, 644345, 644193, 644188, 644184, 644171, 644170, 644137, 644091, 644082, 644062, 644000, 643990, 643974, 643973, 643918, 643891, 643879, 643848, 643832, 643831, 643780, 643768, 643766, 643763, 643740, 643734, 643714, 643707, 643686, 643666, 643661, 643640, 643633, 643583, 643566, 643558, 643549, 643548, 643542, 643520, 643514, 643510, 643509, 643502, 643488, 643482, 643480, 643473, 643472, 643430, 643413, 643410, 643405, 643362, 643343, 643297, 643293, 643263, 643259, 643245, 643242, 643222, 643220, 643217, 643216, 643204, 643197, 643163, 643161, 643160, 643152, 643149, 643142, 643113, 643090, 643089, 643083, 643081, 643078, 643055, 643054, 643033, 643032, 643027, 643026, 643025, 643017, 643016, 642998, 642938, 642934, 642920, 642909, 642903, 642900, 642882, 642879, 642844, 642815, 642812, 642811, 642770, 642753, 642749, 642697, 642696, 642695, 642693, 642689, 642543, 642510, 642500, 642493, 642461, 642441, 642439, 642435, 642430, 642429, 642395, 642393, 642347, 642346, 642338, 642337, 642335, 642333, 642306, 642288, 642283, 642275, 642173, 642146, 642078, 642075, 642047, 641996, 641994, 641961, 641948, 641942, 641937, 641935, 641934, 641926, 641901, 641887, 641886, 641869, 641865, 641785, 641752, 641746, 641716, 641695, 641661, 641646, 641518, 641493, 641492, 641489, 641474, 641469, 641454, 641410, 641401, 641392, 641386, 641335, 641330, 641308, 641302, 641298, 641296, 641284, 641283, 641250, 641222, 641179, 641125, 641060, 641058, 641055, 641038, 641037, 641035, 641033, 641000, 640999, 640968, 640960, 640957, 640954, 640932, 640893, 640826, 417944, 640796, 447743, 640762, 640774, 640740, 201208, 640728, 447724, 640679, 640672, 604377, 604375, 604373, 640260, 447714, 640663, 447707, 447705, 640638, 534945, 640586, 640614, 417940, 580760, 580758, 534940, 534938, 417937, 417924, 536428, 534936, 583994, 109278, 447647, 601280, 447642, 447640, 447638, 639776, 640550, 447636, 640548, 447617, 640528, 536426, 447612, 447609, 329415, 447605, 447592, 447585, 623565, 640405, 539609, 539602, 637207, 601273, 639699, 447564, 447560, 539596, 420450, 640328, 640312, 640309, 640245, 640270, 640193, 632223, 640106, 640103, 640098, 601267, 640076, 640073, 447513, 640064, 453827, 601265, 580738, 447496, 628266, 639481, 447492, 536586, 639476, 640004, 640002, 640000, 447432, 447412, 639465, 639946, 639762, 639760, 639754, 639654, 627545, 639426, 541381, 639424, 447291, 635154, 639253, 447275, 599366, 447271, 639082, 447270, 639077, 447266, 447263, 447257, 447254, 599362, 447241, 630897, 447233, 583959, 601255, 601253, 601252, 447198, 601247, 639134, 447182, 626152, 447153, 201202, 447128, 638985, 578049, 583945, 552896, 578041, 447097, 638862, 638835, 638770, 638687, 638750, 552888, 638538, 247275, 580706, 580702, 580698, 601239, 638411, 638447, 638445, 638443, 638440, 638438, 638395, 638388, 638270, 601236, 316879, 446982, 633906, 637910, 638114, 638070, 638016, 638004, 637962, 637956, 637937, 446926, 446920, 446918, 612885, 637886, 446914, 637586, 637850, 637584, 446912, 446899, 637759, 637776, 446898, 632096, 612361, 601230, 632136, 632134, 632132, 632130, 612353, 637725, 637723, 637676, 637667, 446884, 637714, 637661, 446881, 446878, 636469, 446877, 637705, 637659, 637656, 580672, 328449, 637642, 637698, 637696, 637694, 637631, 637688, 615738, 601227, 615731, 580669, 637539, 637602, 637686, 580667, 580665, 637573, 637570, 446861, 637568, 637564, 637562, 344588, 628799, 637581, 637559, 446846, 201196, 637468, 446841, 446838, 601224, 534782, 637547, 601222, 629981, 637460, 446818, 596389, 392238, 632197, 612849, 637400, 637388, 637386, 446811, 636154, 637357, 637335, 637330, 247265, 446796, 637325, 637321, 637347, 446786, 637269, 601216, 634377, 637259, 637114, 201195, 446762, 601215, 453821, 580660, 580658, 635644, 634375, 637238, 637152, 534767, 637142, 596374, 601213, 446753, 334013, 629975, 247261, 636985, 637025, 637036, 637063, 534750, 637016, 636243, 446735, 446732, 596350, 636936, 636948, 636972, 636929, 636926, 636920, 636901, 636846, 636881, 636854, 607026, 636829, 446717, 309834, 636785, 636757, 628597, 446712, 446706, 636701, 309824, 636687, 247250, 247247, 247243, 247241, 610318, 636685, 446703, 446701, 446699, 446697, 601204, 636636, 201191, 636642, 636640, 636490, 636610, 324072, 601202, 601201, 324070, 324066, 324064, 324062, 636599, 201190, 636543, 580625, 446653, 636442, 610317, 635668, 635664, 630250, 636429, 636423, 636408, 416080, 636380, 636418, 606245, 606243, 606241, 636370, 636360, 636358, 636348, 636329, 636325, 626511, 610314, 628265, 446610, 446608, 446606, 446604, 636248, 446545, 636225, 630240, 636161, 636182, 446524, 446517, 636102, 635960, 635958, 636099, 635955, 536417, 635953, 636092, 446483, 446479, 446477, 247215, 446471, 636031, 636028, 635947, 453814, 636006, 635983, 635978, 635976, 635639, 417919, 417917, 635884, 635927, 635918, 325904, 635903, 519629, 544124, 110774, 609074, 635870, 635876, 635851, 635846, 635767, 632252, 635570, 599356, 635230, 623319, 601176, 629963, 635493, 635554, 635547, 635486, 446414, 635484, 635481, 446412, 446409, 601175, 627261, 635531, 613968, 635476, 635033, 635511, 599353, 635432, 635429, 635416, 635343, 110763, 609389, 634859, 247190, 635335, 634135, 635331, 635269, 635265, 446389, 446383, 635234, 635222, 446381, 446375, 626565, 635220, 635186, 612376, 446372, 634993, 389280, 634965, 634798, 634794, 634819, 629955, 634878, 634812, 629953, 601167, 587708, 596188, 634681, 446314, 590142, 247189, 634676, 629651, 634763, 634760, 634727, 634725, 634703, 446309, 559025, 634664, 634647, 634631, 453808, 630852, 634479, 634320, 634453, 634451, 634386, 634449, 634445, 634443, 630209, 634420, 634435, 634424, 634348, 629948, 633855, 633852, 628470, 634337, 634315, 446288, 634296, 446279, 634208, 629943, 601153, 634263, 446275, 634252, 634250, 596172, 633628, 596168, 201178, 634163, 634155, 634126, 634124, 628263, 446243, 201174, 634101, 633762, 632560, 632556, 592740, 634024, 633992, 602476, 633760, 633573, 633803, 633892, 607481, 604771, 629935, 629933, 633795, 446224, 633739, 633779, 446222, 633777, 633769, 633767, 601144, 633765, 506502, 633754, 633672, 593666, 599520, 596152, 601140, 633873, 446193, 446184, 633594, 633592, 633597, 633548, 633502, 633532, 633544, 633517, 583679, 632922, 446175, 446170, 536410, 596132, 446168, 633217, 446166, 536401, 633405, 536396, 633387, 628437, 633395, 633384, 596121, 632884, 633289, 633094, 633193, 633284, 633313, 633309, 633279, 633269, 633253, 608490, 608488, 628484, 446156, 633180, 633078, 446139, 446137, 596104, 446133, 631987, 631981, 247164, 633068, 247162, 633115, 632246, 247160, 633055, 596099, 201171, 633032, 633009, 534536, 632973, 632968, 446081, 632900, 583638, 445984, 632667, 632724, 631631, 631627, 381159, 445954, 632534, 632240, 632487, 416079, 445947, 325217, 632474, 631213, 631211, 632361, 625896, 632323, 632291, 632234, 632080, 247114, 247111, 632167, 632165, 247106, 596096, 247104, 627927, 632084, 632050, 445887, 631939, 631881, 631856, 631784, 631782, 631810, 631760, 631758, 631728, 445777, 631463, 445771, 110753, 631455, 631452, 631448, 445758, 631444, 631441, 631434, 631432, 453793, 580570, 631662, 631655, 631355, 623632, 445748, 631346, 445740, 445738, 445735, 445733, 445726, 445716, 445708, 445704, 631308, 631237, 631326, 445696, 601126, 627918, 627916, 627914, 631262, 627911, 631182, 631225, 631193, 631148, 631145, 631186, 631189, 627906, 631142, 607475, 631157, 331419, 331409, 331398, 606771, 631070, 631060, 445646, 445643, 445636, 445624, 607474, 445615, 445611, 445608, 445604, 445603, 445596, 631003, 445592, 630966, 630964, 630889, 627141, 445589, 607460, 630918, 630930, 630912, 630910, 445583, 630795, 445580, 445577, 445574, 445572, 445567, 445562, 445554, 445552, 630768, 189112, 629884, 630318, 629305, 630607, 445538, 630163, 630604, 629301, 630619, 445533, 630599, 613626, 629881, 605408, 613619, 458305, 613617, 596074, 630570, 458402, 630565, 630092, 629027, 630550, 630521, 453789, 601122, 630512, 630466, 630437, 630421, 630419, 630371, 630368, 540341, 624165, 445499, 629558, 445496, 445488, 445485, 445481, 630143, 630088, 630086, 630084, 445459, 630098, 630023, 445451, 629852, 629849, 612008, 629822, 629811, 329410, 629799, 629767, 629780, 613445, 445427, 381140, 445410, 445403, 629658, 445399, 629654, 445390, 613441, 629569, 629556, 453787, 629609, 613422, 247046, 445381, 629112, 629192, 445364, 629520, 247030, 629501, 629490, 601666, 629468, 629424, 536391, 201144, 536388, 189238, 445342, 628616, 612305, 629282, 376740, 445330, 445327, 445324, 445319, 445310, 324052, 629020, 628988, 609933, 628957, 628953, 601107, 329408, 628851, 201117, 628902, 201111, 201108, 201101, 201099, 628569, 628566, 445287, 628899, 628562, 628896, 628860, 534323, 628425, 628836, 628757, 628771, 578762, 628537, 201091, 201088, 628481, 628699, 628693, 445271, 445269, 445266, 610816, 628467, 628459, 628427, 445248, 601098, 627215, 445245, 628378, 445232, 445227, 445204, 628227, 628332, 628330, 601093, 453781, 628317, 628298, 628255, 453776, 628283, 445178, 628281, 445170, 628242, 628240, 445168, 602014, 445158, 445155, 445153, 445151, 628182, 628130, 628139, 627507, 627504, 628118, 601092, 409666, 601088, 409661, 627985, 601087, 627677, 627674, 627502, 445139, 627940, 627848, 627975, 627969, 627999, 627992, 627988, 627943, 627937, 627885, 627821, 356090, 606386, 627802, 445128, 627840, 610871, 627793, 445120, 445113, 201087, 627532, 627763, 453765, 627738, 627718, 627721, 627693, 627665, 445105, 605672, 445069, 377218, 445051, 445046, 627623, 627290, 445035, 627288, 466846, 615545, 466844, 627384, 595977, 627340, 627328, 627051, 627322, 627272, 444989, 325566, 444983, 444978, 444969, 444965, 627085, 626951, 626870, 626878, 450402, 626791, 626720, 626717, 626709, 595969, 626775, 595967, 626706, 626630, 626730, 626657, 626648, 626626, 626618, 626616, 626614, 419518, 601084, 626417, 444865, 607931, 444858, 601080, 626407, 325428, 325424, 626396, 444846, 444834, 626350, 626347, 444813, 109255, 444803, 626320, 626317, 444771, 626276, 444756, 444750, 444748, 626310, 325216, 626281, 623623, 626300, 626258, 626247, 626239, 607919, 626204, 626162, 246972, 571318, 602750, 626088, 626054, 626069, 626062, 626042, 625992, 625793, 625547, 625965, 444683, 625857, 625416, 625757, 444527, 625734, 603143, 603141, 625695, 625576, 625706, 444498, 444469, 444457, 444448, 444404, 444285, 534137, 325422, 625118, 625112, 625099, 625080, 602749, 624379, 624358, 444210, 444208, 444185, 444176, 444173, 599332, 624296, 624278, 522798, 246924, 624248, 624212, 624008, 444106, 444097, 624022, 624012, 444069, 583245, 623920, 623903, 601067, 421778, 595905, 443970, 623489, 614995, 601065, 443958, 443954, 623262, 608012, 623740, 623732, 623260, 607906, 533968, 623694, 623249, 443859, 612313, 623519, 623475, 606375, 615728, 623397, 615725, 609023, 623386, 443731, 623367, 616322, 616315, 616313, 616252, 443724, 616290, 533911, 443715, 533891, 616234, 533889, 616187, 616172, 325562, 533878, 443640, 611397, 201038, 201036, 616011, 583195, 615933, 615990, 614190, 443549, 443546, 443540, 443531, 443490, 443390, 615644, 443366, 356081, 443346, 615460, 300, 506484, 615506, 615386, 615355, 615351, 389271, 611122, 443200, 615073, 615110, 615106, 606374, 443177, 443173, 615045, 614849, 615034, 419514, 443025, 614901, 580322, 443022, 580318, 442988, 442985, 614840, 442977, 614819, 607004, 442940, 592698, 442881, 601033, 442733, 614000, 601024, 613981, 613955, 613773, 613704, 613722, 613606, 412569, 613671, 442644, 609855, 613495, 609223, 609221, 609219, 593748, 613464, 601015, 613221, 613241, 613235, 442468, 613195, 442462, 613181, 442452, 442443, 533544, 613054, 613044, 442370, 442330, 612814, 442302, 442298, 246780, 442272, 442253, 442227, 442218, 612920, 612918, 612723, 453756, 453754, 609369, 533477, 609357, 612691, 533465, 612615, 442094, 612612, 598572, 612596, 533457, 246777, 442065, 442063, 601006, 420409, 420407, 611374, 442057, 611366, 442055, 601003, 606333, 416078, 611362, 612542, 442033, 442031, 442024, 442021, 533445, 442019, 604198, 442011, 329402, 606281, 612341, 533421, 544204, 441965, 544202, 612365, 533401, 612191, 612161, 612285, 612185, 611353, 611351, 612038, 441922, 441917, 611988, 610889, 606998, 611890, 533364, 611882, 441834, 611796, 611828, 611575, 603048, 611564, 611322, 611179, 611172, 611168, 611135, 611061, 611056, 110745, 441618, 610938, 441581, 222476, 222460, 610919, 610894, 441518, 610846, 610791, 441484, 610745, 610735, 533215, 441474, 441470, 533212, 381138, 441459, 441410, 610509, 610539, 610503, 610397, 610162, 610159, 533144, 609759, 533134, 608230, 441326, 441315, 441310, 609725, 609718, 597239, 597236, 597234, 51335, 329400, 609451, 481379, 597114, 609441, 533083, 372398, 441302, 609273, 609263, 609251, 593645, 133339, 609147, 533064, 608740, 608866, 609126, 608976, 608957, 608826, 608853, 608821, 608779, 417911, 572893, 200963, 603939, 608382, 533031, 607295, 441229, 441213, 608324, 533019, 441190, 608035, 456307, 607964, 607760, 607762, 441135, 607663, 607627, 607587, 607547, 602741, 532971, 441080, 625072, 441062, 607263, 441058, 607285, 607280, 499498, 512006, 532957, 607255, 532945, 603473, 603457, 441043, 597420, 607172, 607107, 606991, 471346, 607140, 532921, 363089, 471340, 607122, 607120, 607060, 606901, 361111, 109251, 532905, 606743, 189235, 440937, 440931, 606700, 532897, 606631, 606614, 606611, 606528, 532892, 606541, 606496, 606539, 606406, 440859, 606298, 606267, 595610, 331387, 606179, 606171, 605811, 329397, 200931, 606064, 606072, 605943, 440815, 324048, 600974, 605852, 605610, 605600, 440774, 440773, 410055, 605771, 324047, 605575, 440728, 532855, 603996, 605283, 605482, 605273, 200916, 604918, 605165, 356072, 605127, 625071, 440683, 325214, 440680, 603095, 535451, 535448, 440675, 535446, 605087, 440642, 605041, 109241, 605031, 109236, 394082, 394079, 200913, 605028, 440632, 604335, 532836, 604989, 604983, 604981, 604973, 604971, 604960, 604958, 600963, 314804, 421771, 421769, 604808, 421767, 532828, 604722, 349612, 246682, 604861, 246680, 200910, 604793, 440565, 532822, 440558, 440556, 600955, 440549, 332856, 604774, 604770, 604766, 604760, 604752, 329394, 604745, 440543, 603929, 603925, 440517, 604388, 329393, 604632, 532793, 189232, 604480, 189230, 246673, 440498, 604383, 440491, 603422, 604447, 604461, 604440, 440473, 440471, 604305, 604301, 603092, 604255, 440460, 604211, 604180, 440451, 604089, 603028, 354514, 604082, 550254, 604056, 604023, 603988, 246670, 603090, 200908, 602240, 603910, 539560, 603899, 557015, 440437, 603845, 603488, 532768, 603418, 440427, 532753, 332854, 353165, 532750, 440422, 440420, 600944, 603341, 329392, 603329, 440414, 603303, 600941, 110736, 440405, 440403, 603194, 449866, 603283, 600940, 589661, 603198, 329390, 603189, 328448, 603154, 603125, 324044, 329388, 603088, 603099, 310580, 532738, 603080, 603055, 603044, 597853, 603039, 593622, 600925, 440363, 325560, 602927, 440347, 602888, 602884, 602865, 440345, 532728, 440337, 602606, 600907, 602433, 440324, 602426, 602421, 602410, 602255, 314790, 532718, 602136, 602128, 602107, 601589, 532707, 601986, 601983, 601972, 314778, 440298, 440281, 532683, 440260, 580191, 601866, 314769, 601763, 600897, 601734, 601731, 600327, 601722, 532676, 601708, 601609, 521083, 601555, 601544, 600503, 601444, 600894, 440219, 550253, 600874, 440201, 440197, 440156, 349231, 599012, 532624, 532618, 600037, 440093, 597637, 593128, 593122, 200896, 200892, 599114, 599112, 599951, 598726, 598723, 599823, 440082, 536359, 440073, 598995, 625069, 469422, 598330, 598327, 440059, 532598, 440040, 599626, 598959, 439968, 599266, 532595, 532592, 599184, 599144, 439930, 599056, 598948, 598806, 142409, 200879, 532572, 598678, 598651, 439845, 453726, 532568, 439841, 598520, 598519, 598416, 439830, 598438, 517442, 328447, 597921, 597919, 557014, 570283, 532563, 598228, 598359, 439789, 439785, 598286, 598283, 592614, 592612, 592610, 598273, 592607, 598263, 310579, 595093, 580156, 597905, 597902, 532552, 598107, 598081, 594713, 582408, 550250, 597859, 597811, 532547, 200869, 439657, 439627, 329386, 532541, 439584, 439573, 439564, 133284, 597379, 532536, 597207, 597204, 532531, 532526, 532522, 597108, 597103, 363086, 439500, 110731, 110729, 439482, 439459, 109214, 596982, 596979, 439457, 596917, 596938, 596936, 420391, 439434, 596755, 439427, 581351, 439423, 439421, 581349, 596823, 439411, 491113, 491108, 532507, 581329, 581321, 594959, 595327, 329385, 581289, 439327, 473640, 557010, 439292, 439288, 595081, 532484, 594484, 594957, 594835, 594789, 532471, 594765, 594679, 532468, 585302, 594597, 594603, 594581, 594573, 585297, 532452, 439254, 582288, 582286, 594418, 594291, 594416, 580133, 593987, 580131, 594301, 439200, 593790, 439151, 593789, 593787, 329382, 593785, 110727, 593910, 110724, 439136, 439126, 439116, 439104, 536336, 532402, 591875, 536334, 532381, 532377, 582230, 593005, 133259, 593000, 592821, 110722, 439018, 532334, 532314, 592185, 592172, 592170, 592165, 591999, 592031, 591943, 591917, 438896, 591651, 591674, 591680, 591645, 532255, 527883, 110721, 110718, 110716, 200851, 110714, 527872, 221928, 532234, 554271, 453721, 532226, 591438, 109204, 139601, 438804, 438797, 438776, 438774, 532165, 367714, 329381, 590236, 590234, 501842, 438665, 591047, 554548, 590885, 438565, 109178, 109173, 438543, 453715, 438430, 246566, 580024, 584875, 580021, 160308, 584865, 200815, 221863, 221860, 584857, 372037, 189212, 579952, 387867, 109156, 578201, 246532, 579911, 622746, 579906, 310578, 438181, 438177, 589464, 590183, 531944, 438149, 579891, 438048, 590230, 590194, 579818, 437979, 437965, 531929, 246509, 590164, 576504, 110703, 246471, 437901, 589223, 200800, 246370, 246336, 590012, 437808, 589780, 485992, 485980, 110702, 531830, 453709, 536248, 437549, 246272, 453707, 579624, 406506, 531797, 437511, 329379, 589445, 156924, 589456, 156922, 156920, 246250, 437322, 437311, 156916, 437296, 109144, 246240, 309806, 589277, 589152, 589114, 246230, 588441, 531733, 588913, 473618, 406469, 406467, 406462, 588410, 588905, 588407, 588404, 531705, 588341, 588855, 588291, 581265, 110698, 579586, 581258, 437236, 588736, 315794, 309801, 588715, 325213, 557930, 309786, 437208, 588172, 588150, 437202, 588135, 588100, 110696, 579572, 417894, 437187, 109139, 581251, 109137, 109129, 587999, 531630, 200767, 587941, 587932, 587930, 189203, 588462, 531621, 581236, 587885, 437078, 536198, 587753, 587750, 587727, 579536, 581225, 581222, 531605, 536194, 587615, 585131, 356043, 347336, 330504, 437032, 531583, 587593, 587596, 437017, 437015, 581202, 587048, 436969, 531573, 453704, 436928, 246153, 531568, 581184, 577822, 453700, 581182, 485964, 587536, 587532, 587044, 587530, 587525, 436906, 436902, 436891, 587349, 349224, 587410, 436825, 531519, 553090, 587280, 200747, 246095, 436748, 324370, 436724, 531500, 536176, 246088, 587088, 436679, 110685, 436674, 246082, 324368, 587022, 586884, 416077, 221714, 436660, 625033, 110674, 110672, 110667, 110662, 585954, 110655, 531462, 456139, 110653, 436624, 436621, 584999, 586457, 436610, 586746, 436600, 436598, 436594, 436589, 536164, 246065, 586516, 586668, 200736, 531436, 586646, 586644, 531429, 322568, 586600, 579478, 586167, 14397, 246061, 585843, 416076, 578404, 578393, 436300, 189196, 585577, 189193, 436287, 246022, 246020, 585478, 246009, 200705, 531340, 585426, 579372, 531335, 200702, 585390, 361100, 436232, 579320, 585123, 109022, 436043, 436037, 200696, 309763, 309761, 585080, 436015, 309758, 585075, 585071, 585066, 389242, 435990, 221583, 324033, 584974, 309746, 309742, 585004, 531289, 584961, 584959, 579299, 531282, 531279, 584892, 435926, 435919, 435905, 435903, 435901, 531273, 435869, 435867, 584619, 584613, 584610, 584608, 435862, 435857, 435853, 109007, 200693, 584709, 584703, 584690, 584733, 584688, 584727, 584680, 245948, 245946, 579278, 581968, 110651, 435804, 200690, 581960, 584504, 245926, 579256, 579250, 579233, 531237, 435785, 435781, 581158, 581156, 584320, 581136, 584311, 584307, 581132, 584305, 200670, 531218, 435740, 575415, 571254, 584263, 584260, 200668, 531212, 435661, 435655, 435640, 435633, 584238, 581012, 435548, 584168, 576179, 500347, 435538, 435534, 499399, 531197, 572637, 435519, 537725, 435511, 435499, 435489, 435487, 110646, 245901, 531175, 245895, 245873, 579178, 575685, 569554, 435375, 578364, 581702, 578360, 435329, 435327, 581699, 581697, 581713, 485955, 435316, 575674, 581428, 581676, 124276, 581674, 578452, 581671, 581631, 579068, 536122, 536120, 579049, 245845, 245822, 579032, 579030, 578989, 578979, 124269, 578972, 124266, 124264, 245809, 578956, 435199, 435196, 124262, 200616, 578909, 577810, 245797, 245795, 245792, 245790, 435161, 531122, 578892, 435154, 200603, 435152, 581120, 526469, 575644, 526453, 563837, 581086, 23519, 578865, 578861, 578856, 578852, 578848, 531088, 580988, 580984, 531081, 200592, 542181, 245774, 542176, 578790, 578189, 435108, 580802, 435093, 578777, 578313, 235147, 578728, 578723, 531046, 221370, 531034, 435048, 235100, 435013, 531008, 435010, 108986, 434990, 530998, 569546, 200575, 412480, 412478, 412476, 412474, 530989, 570859, 570854, 245693, 434960, 578290, 576895, 576889, 245647, 434932, 434927, 434921, 108976, 434918, 530958, 434894, 234992, 577973, 577970, 577966, 577799, 376426, 376423, 577961, 526431, 526429, 434852, 577692, 577438, 285562, 577366, 577363, 577172, 434452, 576162, 434436, 434432, 314685, 530802, 577303, 314683, 361098, 314681, 434426, 200477, 434399, 434378, 625008, 434315, 576861, 234712, 576852, 234627, 576834, 453681, 479227, 200465, 576655, 346850, 346846, 434222, 245477, 245474, 530725, 234543, 234541, 576482, 576310, 576438, 574454, 576186, 471304, 310037, 530697, 245261, 572620, 453673, 417888, 574247, 434060, 200446, 434051, 369208, 434046, 530642, 200437, 530629, 434026, 245230, 245220, 434021, 200432, 200430, 530607, 575397, 575367, 530594, 530591, 553931, 575302, 530579, 433960, 530563, 530536, 530528, 234373, 234318, 245172, 530491, 564004, 564000, 530474, 433742, 234226, 234215, 433676, 234139, 200377, 200367, 536040, 349559, 573812, 200356, 573634, 530302, 245005, 526344, 200349, 244975, 480345, 546991, 470875, 244913, 530196, 530194, 433409, 200328, 233949, 572615, 200323, 530165, 110596, 572448, 433312, 110592, 110589, 244757, 244754, 433183, 571888, 571885, 530100, 433035, 530058, 433001, 432960, 432930, 567627, 244654, 570795, 570790, 432861, 485852, 570970, 371257, 206102, 355939, 200298, 529823, 432733, 432730, 432727, 570462, 570460, 432705, 397369, 200290, 432682, 244598, 569561, 386885, 244587, 432497, 200267, 244570, 432467, 529705, 529701, 355922, 529685, 569135, 535952, 244555, 569129, 568658, 535940, 432370, 566414, 382697, 110539, 206030, 110536, 432316, 432308, 529605, 244528, 529587, 529579, 565751, 565194, 244514, 432133, 432074, 233521, 526041, 624966, 244496, 564458, 200246, 233441, 233436, 431967, 233434, 559661, 233430, 244486, 483416, 529481, 529479, 483398, 564084, 563833, 563975, 563973, 431933, 110529, 624956, 431902, 431898, 431893, 431823, 563255, 529427, 453621, 431759, 322539, 562829, 349198, 529409, 562556, 200236, 233367, 309473, 562200, 485815, 529389, 555964, 555960, 529377, 233311, 244381, 525998, 525996, 233278, 367522, 431676, 529346, 561123, 431674, 525962, 525960, 525958, 431667, 525953, 560264, 560262, 133077, 200228, 529325, 560339, 560408, 554526, 554520, 557658, 244374, 431614, 560376, 560368, 560331, 431585, 559874, 560231, 559592, 431579, 431575, 331352, 554511, 431570, 559921, 360039, 559738, 559581, 559711, 559659, 559306, 620905, 244357, 233194, 535874, 559020, 244327, 529261, 529259, 244305, 431400, 557894, 552973, 431379, 244260, 459890, 431367, 108789, 552959, 552954, 557984, 554497, 552947, 557583, 557525, 557765, 557500, 485783, 557461, 557459, 535864, 529221, 497502, 552399, 538441, 529206, 233040, 624916, 529180, 431124, 529172, 556053, 555957, 431075, 431067, 555642, 555639, 555635, 529160, 431002, 430999, 430995, 453594, 525817, 525802, 525800, 554940, 200198, 554793, 430881, 430875, 529112, 232916, 244209, 430816, 430784, 430730, 430720, 430717, 430701, 430676, 552060, 515461, 396994, 551260, 551606, 525748, 525736, 468321, 550215, 551376, 525727, 551244, 550972, 551242, 396990, 397347, 397328, 430516, 347282, 390579, 550561, 525698, 430477, 527663, 527659, 527656, 430456, 430449, 548987, 450949, 523902, 108744, 450945, 525685, 546305, 200168, 549820, 548863, 473599, 548926, 548921, 548676, 232778, 528992, 548849, 548741, 200144, 546960, 375069, 430254, 430228, 430198, 547700, 232754, 546175, 525587, 232714, 528910, 205961, 525578, 525574, 525556, 244097, 429926, 386884, 545112, 538023, 538015, 453563, 321201, 321196, 528898, 545261, 545144, 543625, 545110, 200104, 429866, 429864, 110466, 528884, 528882, 525446, 525443, 525440, 429834, 429822, 429816, 429815, 244051, 244048, 429788, 200082, 525410, 544385, 429775, 525392, 528865, 542272, 200078, 528853, 429749, 528847, 542542, 325204, 536565, 429726, 537942, 525348, 543879, 543877, 539446, 528829, 429650, 624853, 537687, 412107, 624851, 369127, 323987, 429631, 528822, 429583, 429577, 525281, 543372, 542536, 525247, 429520, 525238, 542533, 542529, 205934, 473588, 542268, 542264, 525230, 429483, 232619, 542517, 528800, 542124, 244004, 525169, 429367, 525158, 525155, 525151, 492538, 525146, 525143, 525137, 541834, 389177, 429344, 541726, 541539, 429339, 429336, 389170, 541601, 525121, 525116, 525114, 525102, 528786, 525089, 243994, 541419, 243992, 541201, 354487, 541199, 624821, 525055, 525048, 232594, 540272, 541196, 540270, 541135, 525021, 528776, 525015, 456256, 525013, 205923, 527416, 540475, 528758, 524976, 524974, 540473, 524967, 200028, 539973, 524942, 524927, 524925, 524923, 539357, 333767, 524916, 524912, 412073, 528727, 243959, 524901, 232539, 539943, 524898, 537155, 412058, 537150, 488393, 539386, 429110, 539354, 453552, 243947, 494725, 243943, 539101, 538826, 243941, 429092, 538815, 524837, 538842, 243931, 132881, 538396, 537988, 538323, 524790, 537904, 450360, 536732, 524604, 536729, 536727, 524552, 471027, 524518, 535304, 376571, 524439, 524425, 524408, 528587, 524329, 524325, 232367, 524291, 333733, 528213, 527076, 428644, 524038, 471174, 522362, 522359, 521093, 522404, 522424, 428290, 517228, 232255, 132798, 514419, 199804, 517115, 517109, 516816, 108455, 243539, 427572, 469005, 485407, 243472, 232036, 218601, 218599, 507770, 427162, 509224, 508856, 508846, 427113, 427105, 231906, 508284, 367343, 401025, 507767, 243333, 231874, 506901, 426920, 426918, 426915, 426888, 426886, 426884, 426870, 243255, 243250, 504839, 426687, 504540, 504342, 426578, 499187, 499182, 426541, 331609, 426334, 426322, 426259, 501395, 500882, 199440, 500693, 500435, 242978, 498935, 426152, 468936, 495539, 468934, 495537, 498914, 498001, 426003, 426000, 425996, 425994, 425992, 488371, 465569, 455398, 497387, 496452, 367273, 473513, 495312, 425772, 425738, 333644, 425719, 425716, 425714, 199323, 493970, 493861, 199309, 363058, 492998, 231052, 493167, 493165, 231040, 493160, 231024, 231021, 231019, 231015, 231013, 231011, 231007, 231001, 230995, 242802, 492987, 230992, 492729, 492510, 254149, 492503, 254115, 492594, 492563, 425652, 230983, 492049, 230924, 485191, 242739, 486961, 488645, 333633, 242733, 132719, 490993, 199246, 199236, 242717, 375051, 375046, 242670, 242667, 489715, 242663, 483377, 199217, 425474, 425469, 488922, 242648, 242646, 242644, 488207, 488821, 488637, 488816, 488635, 488523, 199208, 488204, 488328, 488202, 488227, 488199, 488196, 453447, 367239, 108029, 486644, 425268, 425261, 367229, 199136, 485098, 230677, 132710, 425155, 132705, 476800, 479856, 483336, 242524, 449857, 375968, 483275, 230635, 230633, 242486, 483601, 132679, 483343, 483341, 470833, 479192, 462751, 483031, 483026, 425052, 242416, 479853, 480936, 242362, 424997, 424984, 479849, 479847, 424975, 230510, 230486, 230481, 468889, 424924, 479845, 479842, 479840, 479428, 476729, 479422, 11924, 11913, 11910, 11906, 478348, 479022, 479015, 479013, 478911, 478930, 242261, 477778, 478007, 478004, 230377, 478002, 478134, 230375, 478000, 477997, 230371, 477995, 476662, 477928, 424813, 230350, 477107, 477105, 477103, 477099, 476854, 476467, 476461, 476438, 476430, 476427, 476423, 476398, 198921, 424722, 473481, 476246, 424718, 107866, 424716, 424710, 318328, 107862, 424697, 198910, 475348, 475344, 424668, 475342, 230261, 242195, 396795, 472157, 472155, 198897, 424666, 364154, 364152, 110249, 349496, 474788, 474785, 474777, 198868, 473478, 474592, 474590, 474424, 474247, 198850, 473466, 473381, 473449, 473284, 473340, 469262, 473277, 424609, 424603, 424598, 424596, 468865, 472870, 198838, 472948, 132582, 472327, 242125, 132573, 132571, 424574, 132569, 132558, 471020, 132554, 471018, 471822, 424572, 470358, 420615, 472139, 472065, 397207, 472062, 472060, 472027, 472025, 470356, 198810, 198804, 198784, 471479, 471395, 471046, 424538, 198755, 424519, 468649, 470462, 468647, 468645, 468642, 470352, 424503, 460698, 460795, 469236, 469234, 468637, 198724, 470143, 424494, 468632, 470141, 469731, 469215, 469213, 424482, 198712, 198710, 469504, 198704, 460685, 468222, 468006, 468004, 424392, 468014, 424389, 467987, 468012, 129050, 424385, 198635, 424347, 424345, 424332, 467383, 467380, 424330, 467365, 467359, 467353, 467349, 467131, 424318, 424311, 198623, 424281, 424279, 424275, 424264, 466747, 180957, 424244, 132485, 624462, 424224, 424217, 406373, 624460, 419031, 198579, 198566, 388134, 465566, 456118, 464660, 229927, 464656, 229921, 229917, 465367, 460785, 406340, 465412, 465365, 229911, 464777, 464775, 464772, 367122, 424098, 424096, 424092, 241676, 241674, 198481, 424090, 463752, 132449, 399929, 463047, 107682, 107680, 463045, 461952, 424041, 460771, 461482, 461245, 460893, 458541, 423996, 423979, 423977, 423974, 336247, 423971, 423969, 423966, 423962, 423958, 458070, 423955, 458063, 367105, 198338, 107622, 107619, 457814, 198316, 458436, 458233, 359949, 359946, 397192, 423887, 457272, 457126, 387050, 375849, 205552, 455954, 450240, 345564, 416850, 416848, 416845, 450238, 389133, 198258, 456302, 387039, 387031, 409693, 455945))
Run Time: 0.164282
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3833 | |
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 | | | | | 3833 | |
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 (35553, 35540, 35485, 35311, 35304, 35238, 35130, 34972, 34776, 34775, 34751, 34746, 34742, 34736, 34718, 34717, 34706, 34678, 34670, 34672, 34748, 34663, 34662, 34634, 34598, 34580, 34576, 34568, 34561, 34468, 34465, 34455, 34451, 34431, 34409, 34380, 34379, 34328, 34315, 34309, 34172, 34073, 34072, 33921, 33772, 33681, 33672, 33669, 33648, 33619, 33489, 33482, 33384, 33346, 33202, 33145, 33117, 33073, 33070, 33067, 33039, 32927, 32877, 32858, 32847, 32794, 32697, 32575, 32539, 32453, 32249, 32247, 32240, 32235, 32218, 32194, 32077, 32074, 32068, 32065, 32060, 32053, 32047, 32042, 32038, 32028, 32016, 31931, 31893, 31890, 31778, 31753, 31547, 31510, 31442, 30223, 28848, 28013, 27815, 27692, 26345, 25920, 24960, 24901, 24528, 24472, 23930, 23833, 23372, 22555))
Run Time: 0.009829
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 110 | 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 (646193, 646170, 646091, 646062, 646041, 646033, 646025, 646023, 646003, 645978, 645973, 645923, 645908, 645812, 645783, 645778, 645775, 645768, 645767, 645760, 645748, 645747, 645721, 645720, 645716, 645713, 645711, 645699, 645696, 645618, 645615, 645606, 645553, 645549, 645519, 645499, 645497, 645442, 645425, 645419, 645411, 645322, 645177, 645151, 645108, 645093, 645092, 645085, 645065, 645051, 645044, 645043, 645001, 645000, 644922, 644919, 644902, 644882, 644790, 644776, 644669, 644667, 644662, 644635, 644557, 644541, 644528, 644452, 644411, 644403, 644402, 644361, 644360, 644358, 644354, 644348, 644347, 644345, 644193, 644188, 644184, 644171, 644170, 644137, 644091, 644082, 644062, 644000, 643990, 643974, 643973, 643918, 643891, 643879, 643848, 643832, 643831, 643780, 643768, 643766, 643763, 643740, 643734, 643714, 643707, 643686, 643666, 643661, 643640, 643633, 643583, 643566, 643558, 643549, 643548, 643542, 643520, 643514, 643510, 643509, 643502, 643488, 643482, 643480, 643473, 643472, 643430, 643413, 643410, 643405, 643362, 643343, 643297, 643293, 643263, 643259, 643245, 643242, 643222, 643220, 643217, 643216, 643204, 643197, 643163, 643161, 643160, 643152, 643149, 643142, 643113, 643090, 643089, 643083, 643081, 643078, 643055, 643054, 643033, 643032, 643027, 643026, 643025, 643017, 643016, 642998, 642938, 642934, 642920, 642909, 642903, 642900, 642882, 642879, 642844, 642815, 642812, 642811, 642770, 642753, 642749, 642697, 642696, 642695, 642693, 642689, 642543, 642510, 642500, 642493, 642461, 642441, 642439, 642435, 642430, 642429, 642395, 642393, 642347, 642346, 642338, 642337, 642335, 642333, 642306, 642288, 642283, 642275, 642173, 642146, 642078, 642075, 642047, 641996, 641994, 641961, 641948, 641942, 641937, 641935, 641934, 641926, 641901, 641887, 641886, 641869, 641865, 641785, 641752, 641746, 641716, 641695, 641661, 641646, 641518, 641493, 641492, 641489, 641474, 641469, 641454, 641410, 641401, 641392, 641386, 641335, 641330, 641308, 641302, 641298, 641296, 641284, 641283, 641250, 641222, 641179, 641125, 641060, 641058, 641055, 641038, 641037, 641035, 641033, 641000, 640999, 640968, 640960, 640957, 640954, 640932, 640893, 640826, 417944, 640796, 447743, 640762, 640774, 640740, 201208, 640728, 447724, 640679, 640672, 604377, 604375, 604373, 640260, 447714, 640663, 447707, 447705, 640638, 534945, 640586, 640614, 417940, 580760, 580758, 534940, 534938, 417937, 417924, 536428, 534936, 583994, 109278, 447647, 601280, 447642, 447640, 447638, 639776, 640550, 447636, 640548, 447617, 640528, 536426, 447612, 447609, 329415, 447605, 447592, 447585, 623565, 640405, 539609, 539602, 637207, 601273, 639699, 447564, 447560, 539596, 420450, 640328, 640312, 640309, 640245, 640270, 640193, 632223, 640106, 640103, 640098, 601267, 640076, 640073, 447513, 640064, 453827, 601265, 580738, 447496, 628266, 639481, 447492, 536586, 639476, 640004, 640002, 640000, 447432, 447412, 639465, 639946, 639762, 639760, 639754, 639654, 627545, 639426, 541381, 639424, 447291, 635154, 639253, 447275, 599366, 447271, 639082, 447270, 639077, 447266, 447263, 447257, 447254, 599362, 447241, 630897, 447233, 583959, 601255, 601253, 601252, 447198, 601247, 639134, 447182, 626152, 447153, 201202, 447128, 638985, 578049, 583945, 552896, 578041, 447097, 638862, 638835, 638770, 638687, 638750, 552888, 638538, 247275, 580706, 580702, 580698, 601239, 638411, 638447, 638445, 638443, 638440, 638438, 638395, 638388, 638270, 601236, 316879, 446982, 633906, 637910, 638114, 638070, 638016, 638004, 637962, 637956, 637937, 446926, 446920, 446918, 612885, 637886, 446914, 637586, 637850, 637584, 446912, 446899, 637759, 637776, 446898, 632096, 612361, 601230, 632136, 632134, 632132, 632130, 612353, 637725, 637723, 637676, 637667, 446884, 637714, 637661, 446881, 446878, 636469, 446877, 637705, 637659, 637656, 580672, 328449, 637642, 637698, 637696, 637694, 637631, 637688, 615738, 601227, 615731, 580669, 637539, 637602, 637686, 580667, 580665, 637573, 637570, 446861, 637568, 637564, 637562, 344588, 628799, 637581, 637559, 446846, 201196, 637468, 446841, 446838, 601224, 534782, 637547, 601222, 629981, 637460, 446818, 596389, 392238, 632197, 612849, 637400, 637388, 637386, 446811, 636154, 637357, 637335, 637330, 247265, 446796, 637325, 637321, 637347, 446786, 637269, 601216, 634377, 637259, 637114, 201195, 446762, 601215, 453821, 580660, 580658, 635644, 634375, 637238, 637152, 534767, 637142, 596374, 601213, 446753, 334013, 629975, 247261, 636985, 637025, 637036, 637063, 534750, 637016, 636243, 446735, 446732, 596350, 636936, 636948, 636972, 636929, 636926, 636920, 636901, 636846, 636881, 636854, 607026, 636829, 446717, 309834, 636785, 636757, 628597, 446712, 446706, 636701, 309824, 636687, 247250, 247247, 247243, 247241, 610318, 636685, 446703, 446701, 446699, 446697, 601204, 636636, 201191, 636642, 636640, 636490, 636610, 324072, 601202, 601201, 324070, 324066, 324064, 324062, 636599, 201190, 636543, 580625, 446653, 636442, 610317, 635668, 635664, 630250, 636429, 636423, 636408, 416080, 636380, 636418, 606245, 606243, 606241, 636370, 636360, 636358, 636348, 636329, 636325, 626511, 610314, 628265, 446610, 446608, 446606, 446604, 636248, 446545, 636225, 630240, 636161, 636182, 446524, 446517, 636102, 635960, 635958, 636099, 635955, 536417, 635953, 636092, 446483, 446479, 446477, 247215, 446471, 636031, 636028, 635947, 453814, 636006, 635983, 635978, 635976, 635639, 417919, 417917, 635884, 635927, 635918, 325904, 635903, 519629, 544124, 110774, 609074, 635870, 635876, 635851, 635846, 635767, 632252, 635570, 599356, 635230, 623319, 601176, 629963, 635493, 635554, 635547, 635486, 446414, 635484, 635481, 446412, 446409, 601175, 627261, 635531, 613968, 635476, 635033, 635511, 599353, 635432, 635429, 635416, 635343, 110763, 609389, 634859, 247190, 635335, 634135, 635331, 635269, 635265, 446389, 446383, 635234, 635222, 446381, 446375, 626565, 635220, 635186, 612376, 446372, 634993, 389280, 634965, 634798, 634794, 634819, 629955, 634878, 634812, 629953, 601167, 587708, 596188, 634681, 446314, 590142, 247189, 634676, 629651, 634763, 634760, 634727, 634725, 634703, 446309, 559025, 634664, 634647, 634631, 453808, 630852, 634479, 634320, 634453, 634451, 634386, 634449, 634445, 634443, 630209, 634420, 634435, 634424, 634348, 629948, 633855, 633852, 628470, 634337, 634315, 446288, 634296, 446279, 634208, 629943, 601153, 634263, 446275, 634252, 634250, 596172, 633628, 596168, 201178, 634163, 634155, 634126, 634124, 628263, 446243, 201174, 634101, 633762, 632560, 632556, 592740, 634024, 633992, 602476, 633760, 633573, 633803, 633892, 607481, 604771, 629935, 629933, 633795, 446224, 633739, 633779, 446222, 633777, 633769, 633767, 601144, 633765, 506502, 633754, 633672, 593666, 599520, 596152, 601140, 633873, 446193, 446184, 633594, 633592, 633597, 633548, 633502, 633532, 633544, 633517, 583679, 632922, 446175, 446170, 536410, 596132, 446168, 633217, 446166, 536401, 633405, 536396, 633387, 628437, 633395, 633384, 596121, 632884, 633289, 633094, 633193, 633284, 633313, 633309, 633279, 633269, 633253, 608490, 608488, 628484, 446156, 633180, 633078, 446139, 446137, 596104, 446133, 631987, 631981, 247164, 633068, 247162, 633115, 632246, 247160, 633055, 596099, 201171, 633032, 633009, 534536, 632973, 632968, 446081, 632900, 583638, 445984, 632667, 632724, 631631, 631627, 381159, 445954, 632534, 632240, 632487, 416079, 445947, 325217, 632474, 631213, 631211, 632361, 625896, 632323, 632291, 632234, 632080, 247114, 247111, 632167, 632165, 247106, 596096, 247104, 627927, 632084, 632050, 445887, 631939, 631881, 631856, 631784, 631782, 631810, 631760, 631758, 631728, 445777, 631463, 445771, 110753, 631455, 631452, 631448, 445758, 631444, 631441, 631434, 631432, 453793, 580570, 631662, 631655, 631355, 623632, 445748, 631346, 445740, 445738, 445735, 445733, 445726, 445716, 445708, 445704, 631308, 631237, 631326, 445696, 601126, 627918, 627916, 627914, 631262, 627911, 631182, 631225, 631193, 631148, 631145, 631186, 631189, 627906, 631142, 607475, 631157, 331419, 331409, 331398, 606771, 631070, 631060, 445646, 445643, 445636, 445624, 607474, 445615, 445611, 445608, 445604, 445603, 445596, 631003, 445592, 630966, 630964, 630889, 627141, 445589, 607460, 630918, 630930, 630912, 630910, 445583, 630795, 445580, 445577, 445574, 445572, 445567, 445562, 445554, 445552, 630768, 189112, 629884, 630318, 629305, 630607, 445538, 630163, 630604, 629301, 630619, 445533, 630599, 613626, 629881, 605408, 613619, 458305, 613617, 596074, 630570, 458402, 630565, 630092, 629027, 630550, 630521, 453789, 601122, 630512, 630466, 630437, 630421, 630419, 630371, 630368, 540341, 624165, 445499, 629558, 445496, 445488, 445485, 445481, 630143, 630088, 630086, 630084, 445459, 630098, 630023, 445451, 629852, 629849, 612008, 629822, 629811, 329410, 629799, 629767, 629780, 613445, 445427, 381140, 445410, 445403, 629658, 445399, 629654, 445390, 613441, 629569, 629556, 453787, 629609, 613422, 247046, 445381, 629112, 629192, 445364, 629520, 247030, 629501, 629490, 601666, 629468, 629424, 536391, 201144, 536388, 189238, 445342, 628616, 612305, 629282, 376740, 445330, 445327, 445324, 445319, 445310, 324052, 629020, 628988, 609933, 628957, 628953, 601107, 329408, 628851, 201117, 628902, 201111, 201108, 201101, 201099, 628569, 628566, 445287, 628899, 628562, 628896, 628860, 534323, 628425, 628836, 628757, 628771, 578762, 628537, 201091, 201088, 628481, 628699, 628693, 445271, 445269, 445266, 610816, 628467, 628459, 628427, 445248, 601098, 627215, 445245, 628378, 445232, 445227, 445204, 628227, 628332, 628330, 601093, 453781, 628317, 628298, 628255, 453776, 628283, 445178, 628281, 445170, 628242, 628240, 445168, 602014, 445158, 445155, 445153, 445151, 628182, 628130, 628139, 627507, 627504, 628118, 601092, 409666, 601088, 409661, 627985, 601087, 627677, 627674, 627502, 445139, 627940, 627848, 627975, 627969, 627999, 627992, 627988, 627943, 627937, 627885, 627821, 356090, 606386, 627802, 445128, 627840, 610871, 627793, 445120, 445113, 201087, 627532, 627763, 453765, 627738, 627718, 627721, 627693, 627665, 445105, 605672, 445069, 377218, 445051, 445046, 627623, 627290, 445035, 627288, 466846, 615545, 466844, 627384, 595977, 627340, 627328, 627051, 627322, 627272, 444989, 325566, 444983, 444978, 444969, 444965, 627085, 626951, 626870, 626878, 450402, 626791, 626720, 626717, 626709, 595969, 626775, 595967, 626706, 626630, 626730, 626657, 626648, 626626, 626618, 626616, 626614, 419518, 601084, 626417, 444865, 607931, 444858, 601080, 626407, 325428, 325424, 626396, 444846, 444834, 626350, 626347, 444813, 109255, 444803, 626320, 626317, 444771, 626276, 444756, 444750, 444748, 626310, 325216, 626281, 623623, 626300, 626258, 626247, 626239, 607919, 626204, 626162, 246972, 571318, 602750, 626088, 626054, 626069, 626062, 626042, 625992, 625793, 625547, 625965, 444683, 625857, 625416, 625757, 444527, 625734, 603143, 603141, 625695, 625576, 625706, 444498, 444469, 444457, 444448, 444404, 444285, 534137, 325422, 625118, 625112, 625099, 625080, 602749, 624379, 624358, 444210, 444208, 444185, 444176, 444173, 599332, 624296, 624278, 522798, 246924, 624248, 624212, 624008, 444106, 444097, 624022, 624012, 444069, 583245, 623920, 623903, 601067, 421778, 595905, 443970, 623489, 614995, 601065, 443958, 443954, 623262, 608012, 623740, 623732, 623260, 607906, 533968, 623694, 623249, 443859, 612313, 623519, 623475, 606375, 615728, 623397, 615725, 609023, 623386, 443731, 623367, 616322, 616315, 616313, 616252, 443724, 616290, 533911, 443715, 533891, 616234, 533889, 616187, 616172, 325562, 533878, 443640, 611397, 201038, 201036, 616011, 583195, 615933, 615990, 614190, 443549, 443546, 443540, 443531, 443490, 443390, 615644, 443366, 356081, 443346, 615460, 300, 506484, 615506, 615386, 615355, 615351, 389271, 611122, 443200, 615073, 615110, 615106, 606374, 443177, 443173, 615045, 614849, 615034, 419514, 443025, 614901, 580322, 443022, 580318, 442988, 442985, 614840, 442977, 614819, 607004, 442940, 592698, 442881, 601033, 442733, 614000, 601024, 613981, 613955, 613773, 613704, 613722, 613606, 412569, 613671, 442644, 609855, 613495, 609223, 609221, 609219, 593748, 613464, 601015, 613221, 613241, 613235, 442468, 613195, 442462, 613181, 442452, 442443, 533544, 613054, 613044, 442370, 442330, 612814, 442302, 442298, 246780, 442272, 442253, 442227, 442218, 612920, 612918, 612723, 453756, 453754, 609369, 533477, 609357, 612691, 533465, 612615, 442094, 612612, 598572, 612596, 533457, 246777, 442065, 442063, 601006, 420409, 420407, 611374, 442057, 611366, 442055, 601003, 606333, 416078, 611362, 612542, 442033, 442031, 442024, 442021, 533445, 442019, 604198, 442011, 329402, 606281, 612341, 533421, 544204, 441965, 544202, 612365, 533401, 612191, 612161, 612285, 612185, 611353, 611351, 612038, 441922, 441917, 611988, 610889, 606998, 611890, 533364, 611882, 441834, 611796, 611828, 611575, 603048, 611564, 611322, 611179, 611172, 611168, 611135, 611061, 611056, 110745, 441618, 610938, 441581, 222476, 222460, 610919, 610894, 441518, 610846, 610791, 441484, 610745, 610735, 533215, 441474, 441470, 533212, 381138, 441459, 441410, 610509, 610539, 610503, 610397, 610162, 610159, 533144, 609759, 533134, 608230, 441326, 441315, 441310, 609725, 609718, 597239, 597236, 597234, 51335, 329400, 609451, 481379, 597114, 609441, 533083, 372398, 441302, 609273, 609263, 609251, 593645, 133339, 609147, 533064, 608740, 608866, 609126, 608976, 608957, 608826, 608853, 608821, 608779, 417911, 572893, 200963, 603939, 608382, 533031, 607295, 441229, 441213, 608324, 533019, 441190, 608035, 456307, 607964, 607760, 607762, 441135, 607663, 607627, 607587, 607547, 602741, 532971, 441080, 625072, 441062, 607263, 441058, 607285, 607280, 499498, 512006, 532957, 607255, 532945, 603473, 603457, 441043, 597420, 607172, 607107, 606991, 471346, 607140, 532921, 363089, 471340, 607122, 607120, 607060, 606901, 361111, 109251, 532905, 606743, 189235, 440937, 440931, 606700, 532897, 606631, 606614, 606611, 606528, 532892, 606541, 606496, 606539, 606406, 440859, 606298, 606267, 595610, 331387, 606179, 606171, 605811, 329397, 200931, 606064, 606072, 605943, 440815, 324048, 600974, 605852, 605610, 605600, 440774, 440773, 410055, 605771, 324047, 605575, 440728, 532855, 603996, 605283, 605482, 605273, 200916, 604918, 605165, 356072, 605127, 625071, 440683, 325214, 440680, 603095, 535451, 535448, 440675, 535446, 605087, 440642, 605041, 109241, 605031, 109236, 394082, 394079, 200913, 605028, 440632, 604335, 532836, 604989, 604983, 604981, 604973, 604971, 604960, 604958, 600963, 314804, 421771, 421769, 604808, 421767, 532828, 604722, 349612, 246682, 604861, 246680, 200910, 604793, 440565, 532822, 440558, 440556, 600955, 440549, 332856, 604774, 604770, 604766, 604760, 604752, 329394, 604745, 440543, 603929, 603925, 440517, 604388, 329393, 604632, 532793, 189232, 604480, 189230, 246673, 440498, 604383, 440491, 603422, 604447, 604461, 604440, 440473, 440471, 604305, 604301, 603092, 604255, 440460, 604211, 604180, 440451, 604089, 603028, 354514, 604082, 550254, 604056, 604023, 603988, 246670, 603090, 200908, 602240, 603910, 539560, 603899, 557015, 440437, 603845, 603488, 532768, 603418, 440427, 532753, 332854, 353165, 532750, 440422, 440420, 600944, 603341, 329392, 603329, 440414, 603303, 600941, 110736, 440405, 440403, 603194, 449866, 603283, 600940, 589661, 603198, 329390, 603189, 328448, 603154, 603125, 324044, 329388, 603088, 603099, 310580, 532738, 603080, 603055, 603044, 597853, 603039, 593622, 600925, 440363, 325560, 602927, 440347, 602888, 602884, 602865, 440345, 532728, 440337, 602606, 600907, 602433, 440324, 602426, 602421, 602410, 602255, 314790, 532718, 602136, 602128, 602107, 601589, 532707, 601986, 601983, 601972, 314778, 440298, 440281, 532683, 440260, 580191, 601866, 314769, 601763, 600897, 601734, 601731, 600327, 601722, 532676, 601708, 601609, 521083, 601555, 601544, 600503, 601444, 600894, 440219, 550253, 600874, 440201, 440197, 440156, 349231, 599012, 532624, 532618, 600037, 440093, 597637, 593128, 593122, 200896, 200892, 599114, 599112, 599951, 598726, 598723, 599823, 440082, 536359, 440073, 598995, 625069, 469422, 598330, 598327, 440059, 532598, 440040, 599626, 598959, 439968, 599266, 532595, 532592, 599184, 599144, 439930, 599056, 598948, 598806, 142409, 200879, 532572, 598678, 598651, 439845, 453726, 532568, 439841, 598520, 598519, 598416, 439830, 598438, 517442, 328447, 597921, 597919, 557014, 570283, 532563, 598228, 598359, 439789, 439785, 598286, 598283, 592614, 592612, 592610, 598273, 592607, 598263, 310579, 595093, 580156, 597905, 597902, 532552, 598107, 598081, 594713, 582408, 550250, 597859, 597811, 532547, 200869, 439657, 439627, 329386, 532541, 439584, 439573, 439564, 133284, 597379, 532536, 597207, 597204, 532531, 532526, 532522, 597108, 597103, 363086, 439500, 110731, 110729, 439482, 439459, 109214, 596982, 596979, 439457, 596917, 596938, 596936, 420391, 439434, 596755, 439427, 581351, 439423, 439421, 581349, 596823, 439411, 491113, 491108, 532507, 581329, 581321, 594959, 595327, 329385, 581289, 439327, 473640, 557010, 439292, 439288, 595081, 532484, 594484, 594957, 594835, 594789, 532471, 594765, 594679, 532468, 585302, 594597, 594603, 594581, 594573, 585297, 532452, 439254, 582288, 582286, 594418, 594291, 594416, 580133, 593987, 580131, 594301, 439200, 593790, 439151, 593789, 593787, 329382, 593785, 110727, 593910, 110724, 439136, 439126, 439116, 439104, 536336, 532402, 591875, 536334, 532381, 532377, 582230, 593005, 133259, 593000, 592821, 110722, 439018, 532334, 532314, 592185, 592172, 592170, 592165, 591999, 592031, 591943, 591917, 438896, 591651, 591674, 591680, 591645, 532255, 527883, 110721, 110718, 110716, 200851, 110714, 527872, 221928, 532234, 554271, 453721, 532226, 591438, 109204, 139601, 438804, 438797, 438776, 438774, 532165, 367714, 329381, 590236, 590234, 501842, 438665, 591047, 554548, 590885, 438565, 109178, 109173, 438543, 453715, 438430, 246566, 580024, 584875, 580021, 160308, 584865, 200815, 221863, 221860, 584857, 372037, 189212, 579952, 387867, 109156, 578201, 246532, 579911, 622746, 579906, 310578, 438181, 438177, 589464, 590183, 531944, 438149, 579891, 438048, 590230, 590194, 579818, 437979, 437965, 531929, 246509, 590164, 576504, 110703, 246471, 437901, 589223, 200800, 246370, 246336, 590012, 437808, 589780, 485992, 485980, 110702, 531830, 453709, 536248, 437549, 246272, 453707, 579624, 406506, 531797, 437511, 329379, 589445, 156924, 589456, 156922, 156920, 246250, 437322, 437311, 156916, 437296, 109144, 246240, 309806, 589277, 589152, 589114, 246230, 588441, 531733, 588913, 473618, 406469, 406467, 406462, 588410, 588905, 588407, 588404, 531705, 588341, 588855, 588291, 581265, 110698, 579586, 581258, 437236, 588736, 315794, 309801, 588715, 325213, 557930, 309786, 437208, 588172, 588150, 437202, 588135, 588100, 110696, 579572, 417894, 437187, 109139, 581251, 109137, 109129, 587999, 531630, 200767, 587941, 587932, 587930, 189203, 588462, 531621, 581236, 587885, 437078, 536198, 587753, 587750, 587727, 579536, 581225, 581222, 531605, 536194, 587615, 585131, 356043, 347336, 330504, 437032, 531583, 587593, 587596, 437017, 437015, 581202, 587048, 436969, 531573, 453704, 436928, 246153, 531568, 581184, 577822, 453700, 581182, 485964, 587536, 587532, 587044, 587530, 587525, 436906, 436902, 436891, 587349, 349224, 587410, 436825, 531519, 553090, 587280, 200747, 246095, 436748, 324370, 436724, 531500, 536176, 246088, 587088, 436679, 110685, 436674, 246082, 324368, 587022, 586884, 416077, 221714, 436660, 625033, 110674, 110672, 110667, 110662, 585954, 110655, 531462, 456139, 110653, 436624, 436621, 584999, 586457, 436610, 586746, 436600, 436598, 436594, 436589, 536164, 246065, 586516, 586668, 200736, 531436, 586646, 586644, 531429, 322568, 586600, 579478, 586167, 14397, 246061, 585843, 416076, 578404, 578393, 436300, 189196, 585577, 189193, 436287, 246022, 246020, 585478, 246009, 200705, 531340, 585426, 579372, 531335, 200702, 585390, 361100, 436232, 579320, 585123, 109022, 436043, 436037, 200696, 309763, 309761, 585080, 436015, 309758, 585075, 585071, 585066, 389242, 435990, 221583, 324033, 584974, 309746, 309742, 585004, 531289, 584961, 584959, 579299, 531282, 531279, 584892, 435926, 435919, 435905, 435903, 435901, 531273, 435869, 435867, 584619, 584613, 584610, 584608, 435862, 435857, 435853, 109007, 200693, 584709, 584703, 584690, 584733, 584688, 584727, 584680, 245948, 245946, 579278, 581968, 110651, 435804, 200690, 581960, 584504, 245926, 579256, 579250, 579233, 531237, 435785, 435781, 581158, 581156, 584320, 581136, 584311, 584307, 581132, 584305, 200670, 531218, 435740, 575415, 571254, 584263, 584260, 200668, 531212, 435661, 435655, 435640, 435633, 584238, 581012, 435548, 584168, 576179, 500347, 435538, 435534, 499399, 531197, 572637, 435519, 537725, 435511, 435499, 435489, 435487, 110646, 245901, 531175, 245895, 245873, 579178, 575685, 569554, 435375, 578364, 581702, 578360, 435329, 435327, 581699, 581697, 581713, 485955, 435316, 575674, 581428, 581676, 124276, 581674, 578452, 581671, 581631, 579068, 536122, 536120, 579049, 245845, 245822, 579032, 579030, 578989, 578979, 124269, 578972, 124266, 124264, 245809, 578956, 435199, 435196, 124262, 200616, 578909, 577810, 245797, 245795, 245792, 245790, 435161, 531122, 578892, 435154, 200603, 435152, 581120, 526469, 575644, 526453, 563837, 581086, 23519, 578865, 578861, 578856, 578852, 578848, 531088, 580988, 580984, 531081, 200592, 542181, 245774, 542176, 578790, 578189, 435108, 580802, 435093, 578777, 578313, 235147, 578728, 578723, 531046, 221370, 531034, 435048, 235100, 435013, 531008, 435010, 108986, 434990, 530998, 569546, 200575, 412480, 412478, 412476, 412474, 530989, 570859, 570854, 245693, 434960, 578290, 576895, 576889, 245647, 434932, 434927, 434921, 108976, 434918, 530958, 434894, 234992, 577973, 577970, 577966, 577799, 376426, 376423, 577961, 526431, 526429, 434852, 577692, 577438, 285562, 577366, 577363, 577172, 434452, 576162, 434436, 434432, 314685, 530802, 577303, 314683, 361098, 314681, 434426, 200477, 434399, 434378, 625008, 434315, 576861, 234712, 576852, 234627, 576834, 453681, 479227, 200465, 576655, 346850, 346846, 434222, 245477, 245474, 530725, 234543, 234541, 576482, 576310, 576438, 574454, 576186, 471304, 310037, 530697, 245261, 572620, 453673, 417888, 574247, 434060, 200446, 434051, 369208, 434046, 530642, 200437, 530629, 434026, 245230, 245220, 434021, 200432, 200430, 530607, 575397, 575367, 530594, 530591, 553931, 575302, 530579, 433960, 530563, 530536, 530528, 234373, 234318, 245172, 530491, 564004, 564000, 530474, 433742, 234226, 234215, 433676, 234139, 200377, 200367, 536040, 349559, 573812, 200356, 573634, 530302, 245005, 526344, 200349, 244975, 480345, 546991, 470875, 244913, 530196, 530194, 433409, 200328, 233949, 572615, 200323, 530165, 110596, 572448, 433312, 110592, 110589, 244757, 244754, 433183, 571888, 571885, 530100, 433035, 530058, 433001, 432960, 432930, 567627, 244654, 570795, 570790, 432861, 485852, 570970, 371257, 206102, 355939, 200298, 529823, 432733, 432730, 432727, 570462, 570460, 432705, 397369, 200290, 432682, 244598, 569561, 386885, 244587, 432497, 200267, 244570, 432467, 529705, 529701, 355922, 529685, 569135, 535952, 244555, 569129, 568658, 535940, 432370, 566414, 382697, 110539, 206030, 110536, 432316, 432308, 529605, 244528, 529587, 529579, 565751, 565194, 244514, 432133, 432074, 233521, 526041, 624966, 244496, 564458, 200246, 233441, 233436, 431967, 233434, 559661, 233430, 244486, 483416, 529481, 529479, 483398, 564084, 563833, 563975, 563973, 431933, 110529, 624956, 431902, 431898, 431893, 431823, 563255, 529427, 453621, 431759, 322539, 562829, 349198, 529409, 562556, 200236, 233367, 309473, 562200, 485815, 529389, 555964, 555960, 529377, 233311, 244381, 525998, 525996, 233278, 367522, 431676, 529346, 561123, 431674, 525962, 525960, 525958, 431667, 525953, 560264, 560262, 133077, 200228, 529325, 560339, 560408, 554526, 554520, 557658, 244374, 431614, 560376, 560368, 560331, 431585, 559874, 560231, 559592, 431579, 431575, 331352, 554511, 431570, 559921, 360039, 559738, 559581, 559711, 559659, 559306, 620905, 244357, 233194, 535874, 559020, 244327, 529261, 529259, 244305, 431400, 557894, 552973, 431379, 244260, 459890, 431367, 108789, 552959, 552954, 557984, 554497, 552947, 557583, 557525, 557765, 557500, 485783, 557461, 557459, 535864, 529221, 497502, 552399, 538441, 529206, 233040, 624916, 529180, 431124, 529172, 556053, 555957, 431075, 431067, 555642, 555639, 555635, 529160, 431002, 430999, 430995, 453594, 525817, 525802, 525800, 554940, 200198, 554793, 430881, 430875, 529112, 232916, 244209, 430816, 430784, 430730, 430720, 430717, 430701, 430676, 552060, 515461, 396994, 551260, 551606, 525748, 525736, 468321, 550215, 551376, 525727, 551244, 550972, 551242, 396990, 397347, 397328, 430516, 347282, 390579, 550561, 525698, 430477, 527663, 527659, 527656, 430456, 430449, 548987, 450949, 523902, 108744, 450945, 525685, 546305, 200168, 549820, 548863, 473599, 548926, 548921, 548676, 232778, 528992, 548849, 548741, 200144, 546960, 375069, 430254, 430228, 430198, 547700, 232754, 546175, 525587, 232714, 528910, 205961, 525578, 525574, 525556, 244097, 429926, 386884, 545112, 538023, 538015, 453563, 321201, 321196, 528898, 545261, 545144, 543625, 545110, 200104, 429866, 429864, 110466, 528884, 528882, 525446, 525443, 525440, 429834, 429822, 429816, 429815, 244051, 244048, 429788, 200082, 525410, 544385, 429775, 525392, 528865, 542272, 200078, 528853, 429749, 528847, 542542, 325204, 536565, 429726, 537942, 525348, 543879, 543877, 539446, 528829, 429650, 624853, 537687, 412107, 624851, 369127, 323987, 429631, 528822, 429583, 429577, 525281, 543372, 542536, 525247, 429520, 525238, 542533, 542529, 205934, 473588, 542268, 542264, 525230, 429483, 232619, 542517, 528800, 542124, 244004, 525169, 429367, 525158, 525155, 525151, 492538, 525146, 525143, 525137, 541834, 389177, 429344, 541726, 541539, 429339, 429336, 389170, 541601, 525121, 525116, 525114, 525102, 528786, 525089, 243994, 541419, 243992, 541201, 354487, 541199, 624821, 525055, 525048, 232594, 540272, 541196, 540270, 541135, 525021, 528776, 525015, 456256, 525013, 205923, 527416, 540475, 528758, 524976, 524974, 540473, 524967, 200028, 539973, 524942, 524927, 524925, 524923, 539357, 333767, 524916, 524912, 412073, 528727, 243959, 524901, 232539, 539943, 524898, 537155, 412058, 537150, 488393, 539386, 429110, 539354, 453552, 243947, 494725, 243943, 539101, 538826, 243941, 429092, 538815, 524837, 538842, 243931, 132881, 538396, 537988, 538323, 524790, 537904, 450360, 536732, 524604, 536729, 536727, 524552, 471027, 524518, 535304, 376571, 524439, 524425, 524408, 528587, 524329, 524325, 232367, 524291, 333733, 528213, 527076, 428644, 524038, 471174, 522362, 522359, 521093, 522404, 522424, 428290, 517228, 232255, 132798, 514419, 199804, 517115, 517109, 516816, 108455, 243539, 427572, 469005, 485407, 243472, 232036, 218601, 218599, 507770, 427162, 509224, 508856, 508846, 427113, 427105, 231906, 508284, 367343, 401025, 507767, 243333, 231874, 506901, 426920, 426918, 426915, 426888, 426886, 426884, 426870, 243255, 243250, 504839, 426687, 504540, 504342, 426578, 499187, 499182, 426541, 331609, 426334, 426322, 426259, 501395, 500882, 199440, 500693, 500435, 242978, 498935, 426152, 468936, 495539, 468934, 495537, 498914, 498001, 426003, 426000, 425996, 425994, 425992, 488371, 465569, 455398, 497387, 496452, 367273, 473513, 495312, 425772, 425738, 333644, 425719, 425716, 425714, 199323, 493970, 493861, 199309, 363058, 492998, 231052, 493167, 493165, 231040, 493160, 231024, 231021, 231019, 231015, 231013, 231011, 231007, 231001, 230995, 242802, 492987, 230992, 492729, 492510, 254149, 492503, 254115, 492594, 492563, 425652, 230983, 492049, 230924, 485191, 242739, 486961, 488645, 333633, 242733, 132719, 490993, 199246, 199236, 242717, 375051, 375046, 242670, 242667, 489715, 242663, 483377, 199217, 425474, 425469, 488922, 242648, 242646, 242644, 488207, 488821, 488637, 488816, 488635, 488523, 199208, 488204, 488328, 488202, 488227, 488199, 488196, 453447, 367239, 108029, 486644, 425268, 425261, 367229, 199136, 485098, 230677, 132710, 425155, 132705, 476800, 479856, 483336, 242524, 449857, 375968, 483275, 230635, 230633, 242486, 483601, 132679, 483343, 483341, 470833, 479192, 462751, 483031, 483026, 425052, 242416, 479853, 480936, 242362, 424997, 424984, 479849, 479847, 424975, 230510, 230486, 230481, 468889, 424924, 479845, 479842, 479840, 479428, 476729, 479422, 11924, 11913, 11910, 11906, 478348, 479022, 479015, 479013, 478911, 478930, 242261, 477778, 478007, 478004, 230377, 478002, 478134, 230375, 478000, 477997, 230371, 477995, 476662, 477928, 424813, 230350, 477107, 477105, 477103, 477099, 476854, 476467, 476461, 476438, 476430, 476427, 476423, 476398, 198921, 424722, 473481, 476246, 424718, 107866, 424716, 424710, 318328, 107862, 424697, 198910, 475348, 475344, 424668, 475342, 230261, 242195, 396795, 472157, 472155, 198897, 424666, 364154, 364152, 110249, 349496, 474788, 474785, 474777, 198868, 473478, 474592, 474590, 474424, 474247, 198850, 473466, 473381, 473449, 473284, 473340, 469262, 473277, 424609, 424603, 424598, 424596, 468865, 472870, 198838, 472948, 132582, 472327, 242125, 132573, 132571, 424574, 132569, 132558, 471020, 132554, 471018, 471822, 424572, 470358, 420615, 472139, 472065, 397207, 472062, 472060, 472027, 472025, 470356, 198810, 198804, 198784, 471479, 471395, 471046, 424538, 198755, 424519, 468649, 470462, 468647, 468645, 468642, 470352, 424503, 460698, 460795, 469236, 469234, 468637, 198724, 470143, 424494, 468632, 470141, 469731, 469215, 469213, 424482, 198712, 198710, 469504, 198704, 460685, 468222, 468006, 468004, 424392, 468014, 424389, 467987, 468012, 129050, 424385, 198635, 424347, 424345, 424332, 467383, 467380, 424330, 467365, 467359, 467353, 467349, 467131, 424318, 424311, 198623, 424281, 424279, 424275, 424264, 466747, 180957, 424244, 132485, 624462, 424224, 424217, 406373, 624460, 419031, 198579, 198566, 388134, 465566, 456118, 464660, 229927, 464656, 229921, 229917, 465367, 460785, 406340, 465412, 465365, 229911, 464777, 464775, 464772, 367122, 424098, 424096, 424092, 241676, 241674, 198481, 424090, 463752, 132449, 399929, 463047, 107682, 107680, 463045, 461952, 424041, 460771, 461482, 461245, 460893, 458541, 423996, 423979, 423977, 423974, 336247, 423971, 423969, 423966, 423962, 423958, 458070, 423955, 458063, 367105, 198338, 107622, 107619, 457814, 198316, 458436, 458233, 359949, 359946, 397192, 423887, 457272, 457126, 387050, 375849, 205552, 455954, 450240, 345564, 416850, 416848, 416845, 450238, 389133, 198258, 456302, 387039, 387031, 409693, 455945))
Run Time: 0.103392
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3833 | |
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 | | | | | 3833 | |
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 (35553, 35540, 35485, 35311, 35304, 35238, 35130, 34972, 34776, 34775, 34751, 34746, 34742, 34736, 34718, 34717, 34706, 34678, 34670, 34672, 34748, 34663, 34662, 34634, 34598, 34580, 34576, 34568, 34561, 34468, 34465, 34455, 34451, 34431, 34409, 34380, 34379, 34328, 34315, 34309, 34172, 34073, 34072, 33921, 33772, 33681, 33672, 33669, 33648, 33619, 33489, 33482, 33384, 33346, 33202, 33145, 33117, 33073, 33070, 33067, 33039, 32927, 32877, 32858, 32847, 32794, 32697, 32575, 32539, 32453, 32249, 32247, 32240, 32235, 32218, 32194, 32077, 32074, 32068, 32065, 32060, 32053, 32047, 32042, 32038, 32028, 32016, 31931, 31893, 31890, 31778, 31753, 31547, 31510, 31442, 30223, 28848, 28013, 27815, 27692, 26345, 25920, 24960, 24901, 24528, 24472, 23930, 23833, 23372, 22555))
Run Time: 0.003695
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 110 | 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.000274
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: �ڂ, XF\Pub\Controller\Member, RecentContent, valid, user_id=5699, 1716187752, , 0, �ڂ
Run Time: 0.000138
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000317
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.000454
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1716187452
Run Time: 0.000274
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 15 | 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` >= 1716187452)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000389
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 15 | 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