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.000730
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.000229
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` = '9814')
LIMIT 1
Run Time: 0.000407
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.002477
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_9814' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.305947
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 (646403, 646290, 646289, 646287, 646249, 646245, 646231, 646155, 646153, 646066, 646058, 646054, 646036, 646015, 646012, 646010, 645989, 645857, 645827, 645824, 645820, 645815, 645806, 645739, 645730, 645687, 645672, 645670, 645668, 645635, 645474, 645445, 645444, 645440, 645339, 645314, 645313, 645248, 645200, 645178, 645126, 645064, 645033, 645029, 644969, 644929, 644872, 644823, 644755, 644723, 644716, 644708, 644697, 644696, 644550, 644507, 644491, 644486, 644472, 644464, 644444, 644443, 644432, 644421, 644401, 644389, 644302, 644286, 644217, 644215, 644177, 644175, 643930, 643924, 643881, 643874, 643840, 643761, 643746, 643708, 643613, 643427, 643328, 643322, 643313, 643309, 643306, 643304, 643302, 643299, 643147, 643124, 643061, 642987, 642979, 642963, 642957, 642919, 642866, 642862, 642823, 642821, 642817, 642813, 642738, 642737, 642719, 642714, 642706, 642703, 642701, 642664, 642660, 642653, 642632, 642584, 642573, 642570, 642562, 642559, 642515, 642498, 642433, 642413, 642406, 642390, 642387, 642385, 642382, 642376, 642374, 642373, 642343, 642341, 642321, 642312, 642280, 642276, 642270, 642265, 642261, 642257, 642253, 642231, 642224, 642217, 642192, 642172, 642154, 642095, 642091, 641972, 641970, 641960, 641931, 641896, 641893, 641890, 641882, 641828, 641820, 641803, 641791, 641771, 641766, 641765, 641728, 641724, 641720, 641718, 641717, 641709, 641703, 641608, 641606, 641600, 641594, 641591, 641475, 641472, 641467, 641465, 641461, 641444, 641409, 641405, 641395, 641390, 641382, 641381, 641378, 641375, 641373, 641372, 641354, 641353, 641345, 641344, 641342, 641339, 641334, 641323, 641294, 641291, 641286, 641219, 641216, 641176, 641172, 641170, 641169, 641159, 641157, 641112, 641102, 641090, 641085, 641059, 641057, 641020, 640998, 640995, 640993, 640953, 640915, 640913, 640912, 640894, 640891, 640868, 640865, 640851, 640594, 447746, 640770, 640758, 640768, 640756, 640754, 201214, 201212, 201210, 201207, 630012, 447736, 447733, 447731, 447729, 447727, 447725, 447723, 447721, 447718, 630011, 640608, 639997, 640676, 640673, 640703, 640660, 640657, 640655, 640652, 447708, 447702, 447700, 640452, 633974, 634017, 633966, 634014, 633963, 633961, 633959, 634012, 633956, 580765, 633949, 633947, 580763, 640588, 534944, 580759, 580757, 580754, 580752, 580750, 580745, 580743, 580741, 640559, 447689, 604369, 447687, 447685, 447682, 447680, 447678, 417936, 417934, 417932, 417930, 639734, 447666, 109281, 109275, 109272, 109270, 109268, 109266, 109263, 109259, 639723, 447658, 447651, 447648, 447646, 447644, 447635, 447633, 447627, 447625, 447623, 640531, 447621, 447619, 640525, 447611, 640131, 639991, 639986, 639984, 640128, 639982, 447606, 639980, 447587, 447584, 447582, 447580, 447577, 447574, 640444, 640442, 640414, 640412, 639607, 639605, 640404, 639603, 640402, 539608, 447567, 539605, 539603, 447557, 640319, 447553, 447551, 447547, 447545, 447542, 640316, 640314, 640311, 640306, 640284, 640233, 640230, 640222, 637058, 639486, 640124, 640122, 640120, 640117, 640116, 640114, 640112, 640110, 640107, 447529, 639111, 640097, 640095, 640093, 640091, 640089, 639109, 640087, 447520, 640085, 309847, 309845, 640083, 640081, 640079, 640077, 640075, 640072, 640070, 640068, 639108, 640066, 640061, 640059, 639107, 640058, 640056, 640053, 639105, 447509, 447507, 639485, 639483, 639104, 447491, 639480, 639479, 640027, 639477, 639475, 639474, 640025, 640023, 640021, 640013, 639472, 447447, 447445, 639470, 447431, 447423, 447419, 639467, 639942, 639939, 639463, 639461, 639459, 639882, 639456, 639454, 580732, 247284, 639448, 639446, 639444, 639442, 247282, 447374, 247280, 639575, 639573, 639439, 639570, 639437, 639435, 639565, 639563, 639560, 639558, 639433, 639431, 639429, 639428, 639425, 639423, 639420, 639418, 639415, 639103, 639413, 447307, 447305, 447300, 447298, 639101, 639099, 447294, 639097, 639095, 447288, 639094, 447285, 447280, 447278, 639093, 639092, 639335, 639331, 639090, 639088, 639087, 639083, 447265, 639074, 447260, 447258, 639072, 639070, 639068, 639066, 639062, 639059, 447251, 635672, 639232, 639056, 639054, 639227, 447238, 639051, 639049, 447236, 639048, 447232, 639047, 447230, 447217, 608173, 639046, 639045, 447213, 639044, 639042, 639040, 639038, 639036, 639032, 639030, 447206, 639027, 639025, 639024, 447177, 447158, 639132, 639023, 639114, 639022, 639020, 580723, 447146, 580719, 580717, 447137, 189143, 638990, 638988, 638986, 578060, 578056, 578053, 578051, 578048, 578046, 578044, 578042, 447114, 447112, 447108, 447106, 247276, 447098, 638823, 638811, 638808, 638732, 637013, 638337, 638553, 534859, 637185, 534858, 583930, 638424, 580712, 580710, 580704, 638422, 638420, 638519, 247273, 638418, 534846, 447074, 447068, 447063, 638415, 638409, 638404, 638397, 638392, 638389, 638386, 638384, 638380, 447025, 447013, 638335, 638333, 638331, 638329, 638327, 638325, 583904, 583903, 580690, 580688, 629989, 638271, 580682, 580679, 633946, 583900, 446987, 612897, 633944, 612895, 536420, 612892, 633941, 633937, 633934, 638213, 638209, 633907, 629986, 625736, 633905, 583891, 583888, 583886, 446973, 446970, 446968, 446966, 446964, 446962, 446960, 446957, 446953, 446951, 446946, 638170, 638104, 583883, 638102, 638100, 638098, 247272, 583880, 583877, 583875, 247266, 638108, 638073, 638017, 638015, 638038, 583867, 606029, 583865, 583863, 638007, 583857, 534810, 638001, 534808, 637996, 637965, 637963, 446936, 637961, 637957, 637934, 446934, 446932, 446929, 446925, 446922, 446919, 446917, 446915, 446905, 637846, 446903, 446900, 637757, 565470, 446894, 637727, 446888, 201197, 637702, 637690, 580670, 637604, 580666, 534786, 446867, 446856, 446851, 446848, 446843, 446839, 446837, 446835, 446829, 534778, 637455, 446826, 446823, 534777, 637446, 446817, 583825, 534772, 534770, 637344, 446806, 637339, 637337, 637331, 637328, 637326, 446791, 446789, 637324, 637322, 446787, 446780, 446777, 446772, 446770, 637266, 534769, 580657, 580654, 580652, 181014, 580650, 637180, 637149, 446761, 637176, 637174, 637172, 446759, 637145, 583814, 446757, 583812, 446755, 637164, 534760, 607950, 201193, 637126, 637124, 637121, 637110, 629976, 580647, 446752, 446750, 247262, 247260, 446748, 446745, 446743, 637050, 446741, 637047, 637045, 247258, 247256, 247254, 637038, 637066, 637035, 637023, 534751, 636242, 446736, 636975, 636954, 636952, 636950, 636946, 636944, 636934, 636932, 636928, 636925, 636942, 636923, 633381, 633378, 633374, 633371, 636859, 636832, 633368, 636826, 309837, 309835, 309829, 636743, 534742, 628595, 628593, 628590, 446710, 309825, 632795, 636650, 632793, 636463, 247252, 247251, 247249, 247246, 247244, 247242, 247240, 446700, 634011, 634009, 634007, 634005, 634002, 633999, 633997, 446684, 633996, 636648, 636637, 636641, 636491, 580643, 580641, 580639, 580637, 636606, 324061, 580633, 580631, 580629, 580627, 580624, 580622, 626748, 636385, 626746, 534730, 636521, 636519, 636516, 446665, 636502, 446662, 636454, 636494, 446656, 446654, 446650, 635666, 446640, 636437, 446637, 636324, 446623, 446603, 201188, 636297, 636295, 636293, 446591, 446586, 446571, 446565, 446550, 630242, 446547, 446541, 247238, 446533, 633904, 446530, 247237, 446523, 247234, 446518, 247231, 446516, 446513, 247229, 534707, 536418, 446501, 446486, 534703, 446480, 446478, 247226, 446474, 247223, 247221, 247218, 247216, 247214, 247210, 601195, 636054, 247204, 580615, 247201, 635816, 635813, 635811, 446445, 635800, 635744, 635742, 635739, 635658, 189137, 634409, 634407, 446433, 446427, 247199, 247197, 247195, 247193, 247191, 602461, 602459, 602456, 635524, 446405, 446403, 635327, 446369, 635219, 635076, 634928, 446349, 634785, 247187, 247184, 247180, 247178, 247175, 634403, 634675, 247171, 534634, 597501, 634621, 634619, 634469, 634601, 446303, 634395, 634393, 446294, 634338, 536416, 580612, 580610, 633300, 446278, 634277, 634286, 634207, 629942, 634205, 446264, 534616, 201179, 446263, 446260, 634228, 634226, 634223, 446256, 446254, 634094, 634090, 247166, 634122, 634116, 446249, 634111, 446247, 446245, 609120, 446242, 632567, 634055, 602490, 602488, 633590, 592742, 592739, 629939, 592737, 634025, 634021, 633989, 633987, 633808, 633985, 633843, 633902, 633899, 633896, 633894, 629937, 629934, 534603, 446219, 633648, 633886, 633884, 633654, 633646, 633882, 633879, 633877, 633874, 446209, 633872, 446207, 611450, 633555, 446177, 633871, 632923, 632915, 633868, 536413, 633866, 536411, 633863, 536409, 629929, 633861, 629927, 633222, 536407, 633433, 629925, 247165, 536402, 536399, 536397, 633365, 536395, 389278, 633363, 446161, 446159, 446130, 633154, 446123, 633031, 633006, 446105, 446103, 534537, 446100, 446092, 446090, 446086, 446075, 446064, 446055, 446053, 189128, 189125, 247153, 446029, 247151, 446027, 247149, 247148, 534525, 534522, 247147, 247145, 247139, 445988, 445981, 583635, 583631, 583629, 445969, 445966, 631619, 631617, 631615, 631612, 631607, 631603, 632658, 632655, 632653, 631591, 189124, 631584, 631582, 632645, 534506, 631578, 631576, 631566, 632500, 631550, 631548, 631542, 247130, 247129, 247128, 325222, 632442, 325220, 632439, 445942, 445940, 632437, 632433, 632430, 632427, 632425, 632423, 632420, 632042, 632407, 632335, 632333, 632405, 632398, 247118, 247107, 632162, 632169, 247105, 189119, 189116, 632148, 247103, 580598, 534491, 580595, 580593, 632092, 247101, 632090, 247098, 580586, 632026, 632024, 632022, 445915, 445912, 445909, 445905, 445903, 445901, 445894, 632020, 632018, 632016, 632013, 445890, 631953, 632008, 445877, 445865, 631539, 445861, 488678, 445859, 445857, 631951, 631947, 445853, 445846, 445842, 445840, 445838, 445813, 445804, 631537, 631859, 631853, 631838, 631844, 631832, 631531, 631846, 534484, 631841, 631829, 631800, 631817, 631813, 631527, 631518, 445800, 631512, 631748, 631743, 631509, 631739, 580577, 631735, 631492, 631488, 631486, 631484, 631730, 631482, 631480, 580574, 580572, 445793, 445791, 445789, 445787, 631470, 445784, 631468, 445776, 110755, 445769, 631461, 631458, 631456, 445766, 607478, 631453, 445761, 445759, 631446, 631412, 631409, 631406, 631402, 631400, 631398, 445756, 580556, 631367, 631365, 630953, 631363, 631358, 445731, 631634, 445728, 445710, 445706, 445701, 445694, 445692, 445689, 445686, 445682, 631291, 445680, 445678, 445672, 445662, 445660, 583545, 583541, 631198, 392481, 580545, 580539, 580537, 580535, 631156, 629338, 247096, 331413, 631079, 606775, 331399, 631077, 606773, 631067, 606770, 445652, 445650, 445648, 606768, 445645, 247094, 445641, 606765, 445626, 534458, 247092, 445612, 580532, 445601, 580530, 445599, 445591, 534451, 607457, 607455, 607452, 607450, 612590, 612588, 589701, 612585, 589698, 612583, 247087, 589696, 607448, 630900, 445586, 589687, 589685, 445584, 589683, 445581, 534449, 445570, 445568, 445563, 445560, 445553, 607431, 607429, 607418, 607415, 607413, 607408, 607406, 630779, 630682, 445550, 445548, 630672, 445546, 445544, 630636, 445537, 630618, 445534, 445532, 445527, 629882, 445525, 630595, 534428, 589681, 596075, 630542, 630537, 630547, 630522, 534422, 629880, 629877, 534420, 630471, 630448, 624177, 624175, 624173, 630420, 630359, 630329, 628068, 201152, 445501, 629869, 189111, 445494, 445492, 445476, 630148, 445469, 629864, 630146, 445465, 247084, 588969, 247082, 588967, 445461, 630131, 630128, 630134, 629717, 445457, 247079, 445455, 445453, 534406, 189110, 629860, 247073, 247071, 629858, 629845, 247068, 629843, 630038, 445447, 629838, 629836, 629816, 629771, 247059, 247052, 247050, 629798, 629764, 630033, 629792, 629761, 629757, 534394, 629742, 629740, 629712, 580526, 580524, 628619, 628617, 445412, 445406, 629664, 629574, 629572, 445400, 445397, 445394, 629638, 596054, 596052, 612580, 247047, 613437, 612578, 629623, 612576, 612574, 629618, 612572, 580521, 613430, 534377, 626699, 613428, 612570, 629603, 613426, 613423, 445384, 445377, 445375, 445372, 445369, 629190, 445361, 445359, 629187, 445357, 629566, 629563, 629561, 580515, 629539, 629525, 629523, 189107, 247038, 247035, 580511, 629503, 580507, 580505, 629489, 614893, 580503, 580501, 534375, 534372, 536392, 536390, 629434, 201147, 580494, 201145, 536386, 536384, 589323, 201138, 445346, 445341, 629321, 247027, 247025, 445339, 445336, 445331, 445329, 445325, 445322, 445318, 445308, 629256, 629252, 629250, 189105, 536379, 629217, 534351, 189102, 189099, 445306, 445304, 629108, 629104, 629100, 629096, 580491, 247021, 247018, 189094, 110750, 189092, 189090, 247014, 580479, 580476, 580474, 580472, 580469, 580467, 580465, 247009, 580459, 580457, 580455, 628931, 201126, 201121, 201119, 247006, 201114, 628583, 201109, 201102, 201100, 201098, 628579, 628576, 628572, 247005, 628570, 445286, 628866, 628561, 580454, 628558, 580452, 628554, 628552, 605228, 628549, 189088, 628804, 445281, 628605, 445276, 628524, 445275, 445256, 445247, 445244, 445241, 246993, 445233, 445231, 445224, 445220, 445218, 445195, 445192, 445188, 445179, 445177, 445175, 445173, 445157, 445129, 189237, 589312, 445126, 445124, 445122, 445118, 445116, 445112, 627489, 445110, 627688, 445104, 605668, 445102, 627655, 445100, 445096, 445094, 445092, 445090, 445086, 445083, 445080, 445077, 445075, 445073, 445070, 445067, 627466, 627294, 445038, 201082, 627444, 627441, 445013, 445009, 445004, 627207, 444982, 534290, 444970, 444968, 627110, 627107, 444966, 444964, 627040, 627073, 627037, 627062, 201081, 627035, 444960, 627031, 627029, 444958, 444956, 627023, 444954, 626885, 626854, 626883, 626850, 626668, 626834, 626830, 626825, 626819, 444919, 444912, 534283, 626763, 201080, 201078, 626666, 626662, 626719, 626716, 626714, 444878, 189070, 444763, 391991, 391989, 391986, 246981, 246978, 607914, 246976, 246971, 626111, 444726, 626107, 626105, 602751, 626064, 444703, 611440, 534242, 625882, 625875, 444654, 444648, 625816, 444642, 444639, 444634, 534229, 625807, 534225, 625626, 625624, 625597, 625622, 625190, 625594, 444618, 616163, 444604, 444576, 444574, 444572, 444551, 444546, 444540, 444538, 444536, 444534, 625668, 625666, 444522, 580432, 625733, 580430, 580426, 580423, 580421, 580419, 580415, 580411, 580409, 580407, 444507, 189059, 444499, 444495, 625662, 611431, 611427, 534214, 444488, 611421, 444483, 246966, 444481, 625605, 444479, 246964, 189056, 246962, 444477, 444466, 444450, 625489, 246950, 607912, 534205, 625451, 534201, 609063, 625449, 625430, 444408, 625304, 246945, 246943, 246941, 246939, 246937, 444394, 444387, 444385, 444383, 534182, 623937, 246753, 246733, 611503, 611328, 611326, 441704, 611319, 441676, 441667, 610910, 611150, 611144, 611175, 611142, 611045, 611043, 611040, 611034, 611028, 611025, 611018, 441614, 533254, 441611, 441595, 610993, 441589, 610972, 610970, 610966, 441582, 441564, 441503, 441479, 441472, 441431, 441429, 441426, 441409, 441405, 580222, 440844, 532878, 440840, 440838, 605525, 440715, 582799, 582797, 602548, 602545, 602532, 602526, 602524, 602521, 582795, 604356, 605286, 440710, 440687, 605105, 535452, 535443, 314803, 314800, 314798, 604845, 314794, 532832, 604842, 604838, 109229, 440563, 440561, 440550, 440546, 440544, 532791, 189229, 246675, 189226, 604431, 354520, 354518, 189223, 604429, 604444, 614738, 604427, 604425, 604439, 440468, 354516, 604281, 440458, 440454, 440452, 246672, 532780, 532773, 532759, 440426, 532749, 532747, 440424, 603326, 603299, 603228, 536362, 536360, 532729, 602574, 602501, 599029, 602610, 602607, 602454, 488699, 602452, 314788, 314786, 602192, 602145, 602140, 602137, 602131, 602129, 601592, 601573, 601564, 532699, 314784, 314780, 532697, 314777, 580196, 601504, 440284, 440282, 532689, 440270, 314773, 601865, 314767, 314765, 314763, 601849, 601847, 600121, 600116, 532675, 440238, 532668, 532666, 440193, 600812, 532657, 532655, 600625, 600623, 600621, 600619, 600588, 600616, 600615, 440180, 440177, 596580, 596578, 600516, 200901, 440166, 600484, 440161, 440154, 600136, 532634, 532631, 440139, 440137, 440132, 440129, 440125, 440123, 440120, 532626, 532623, 440115, 440111, 440103, 532617, 600030, 440092, 440090, 532614, 599968, 595097, 532610, 599925, 599938, 599920, 532608, 599918, 597852, 597849, 614958, 599868, 599820, 599809, 599803, 440081, 440078, 440067, 598346, 598344, 598341, 532600, 189219, 189216, 110734, 440043, 440039, 440035, 440033, 440031, 440025, 440021, 599654, 440008, 440003, 440001, 439999, 599589, 598688, 439972, 439969, 599416, 599391, 469415, 599236, 596726, 439938, 599146, 439934, 439927, 599123, 439925, 439923, 599102, 439916, 439913, 439911, 439909, 439907, 439905, 439902, 532587, 599060, 597545, 532584, 598907, 532583, 598905, 598798, 439887, 598784, 200881, 532577, 532576, 439885, 439880, 439877, 439872, 439870, 439868, 439866, 439863, 598659, 314759, 598598, 598606, 532569, 598596, 597843, 596923, 598453, 439825, 439816, 598436, 439813, 439807, 598393, 532564, 598390, 439804, 598232, 598230, 598226, 598357, 439796, 439781, 598351, 598349, 439775, 439773, 598285, 598282, 598276, 598271, 439762, 439760, 439756, 439731, 439698, 597771, 439668, 536355, 109225, 109223, 109219, 595060, 595057, 597437, 439642, 439640, 439636, 246667, 439632, 597564, 439630, 439625, 439615, 439613, 439609, 597558, 597555, 597551, 597549, 439587, 439585, 597514, 596763, 580155, 580149, 596493, 596489, 439533, 439531, 532532, 439529, 594778, 597148, 597162, 597160, 597064, 110732, 597123, 532525, 532523, 363088, 597092, 597089, 597087, 597083, 597080, 597078, 439523, 597076, 439521, 439516, 439514, 439512, 439510, 439506, 439504, 439501, 439499, 590858, 110730, 439487, 439477, 439475, 439473, 439470, 536350, 439462, 109215, 596980, 532520, 439452, 439450, 439448, 439446, 439444, 420396, 420393, 439436, 439430, 596752, 439422, 596833, 596829, 596827, 439416, 596748, 439414, 439409, 596741, 439403, 596738, 596734, 614731, 614728, 614726, 596651, 532505, 614724, 592667, 614722, 614719, 439398, 439393, 596607, 532497, 532496, 439381, 439379, 439377, 439374, 439372, 439368, 439364, 439361, 439358, 439352, 439347, 439345, 439343, 439341, 594531, 594529, 595253, 473637, 473634, 473632, 439314, 439312, 439305, 532488, 592101, 592099, 592097, 532483, 532481, 532479, 532478, 594902, 532470, 439278, 594780, 439275, 594685, 594683, 594680, 594665, 532465, 594658, 246664, 439260, 527977, 527973, 527967, 527963, 527960, 532457, 532454, 532451, 532449, 439253, 439251, 439241, 439238, 580143, 439236, 439234, 439230, 439228, 314756, 314754, 314752, 580140, 314739, 314736, 594453, 523619, 580135, 592500, 592495, 439212, 592491, 439210, 439208, 532442, 314734, 314732, 593338, 439196, 532436, 594220, 594218, 532434, 532431, 439183, 439181, 439179, 439177, 439175, 473630, 582274, 439173, 594112, 439165, 594108, 594106, 439160, 439154, 593782, 439148, 593776, 582260, 593772, 593896, 593940, 439140, 593888, 593885, 593883, 593879, 439138, 593824, 439135, 439133, 439129, 593875, 439118, 500373, 439109, 592089, 439103, 439090, 439088, 439066, 593704, 439060, 593695, 593742, 439057, 593501, 593499, 593497, 593495, 593492, 593489, 314730, 580121, 580118, 580116, 532411, 593305, 532409, 532406, 593296, 592956, 133261, 592954, 536335, 536333, 536331, 593189, 593186, 593184, 593163, 593160, 593158, 246657, 593148, 593080, 532378, 593078, 593063, 614713, 532357, 200855, 532354, 532353, 532349, 532345, 532340, 532339, 532335, 592488, 439000, 592486, 438994, 438989, 438987, 592566, 592562, 438976, 592078, 592532, 532313, 548372, 592325, 592416, 532309, 536327, 592413, 532307, 592322, 580104, 592320, 592316, 532304, 532297, 532270, 532268, 532264, 532262, 527934, 527930, 527921, 527911, 527909, 527903, 527901, 532250, 110719, 110717, 110715, 110712, 532243, 527864, 580101, 532238, 580099, 580096, 532230, 200848, 532228, 532219, 532216, 532213, 532211, 532204, 532199, 532195, 532191, 532189, 532185, 532183, 532181, 532177, 532167, 532163, 532158, 532142, 532136, 532127, 548331, 590650, 590648, 590645, 590643, 590641, 590639, 556836, 590634, 532053, 590564, 590559, 590519, 590511, 590508, 590503, 590495, 590485, 590481, 590478, 590475, 590471, 590468, 246609, 246603, 246601, 246598, 532043, 532040, 532038, 589899, 589896, 532032, 532030, 589892, 589888, 590430, 589881, 532026, 614694, 614692, 438518, 438510, 438503, 438497, 438494, 438489, 532015, 438469, 532009, 438447, 438440, 438423, 438418, 438415, 590261, 438413, 580062, 580059, 580050, 580038, 580031, 246569, 580027, 531995, 580025, 580020, 580013, 580011, 580003, 580000, 579997, 579995, 579994, 536274, 579992, 246563, 579986, 579983, 579977, 246556, 246553, 614691, 536264, 531980, 584849, 438373, 246545, 536260, 438365, 438363, 536256, 438359, 438354, 579969, 189211, 189207, 189205, 438323, 438318, 438312, 438301, 438290, 579950, 531969, 579944, 531967, 579939, 438251, 438243, 579921, 579919, 579917, 521081, 438173, 438171, 438169, 579902, 531947, 438154, 438150, 438145, 438136, 579897, 438132, 438129, 438127, 579862, 438125, 438121, 438118, 438113, 438108, 438064, 438042, 579837, 579835, 579828, 579824, 437992, 579798, 579790, 531917, 579752, 110705, 437938, 437934, 579745, 246465, 246448, 531902, 531901, 246437, 579733, 579727, 579724, 437880, 579713, 437866, 437860, 437858, 437856, 437854, 531889, 579705, 579692, 200802, 437848, 246401, 246392, 246380, 246354, 246352, 246342, 246338, 246334, 246320, 531868, 246304, 246302, 531856, 246300, 246298, 437812, 246295, 437807, 246293, 437805, 246291, 589861, 589858, 437788, 589852, 589847, 246289, 589845, 437784, 437780, 589818, 200798, 437771, 531843, 437768, 437765, 437758, 133227, 133224, 437756, 579673, 579668, 579665, 531839, 579662, 246288, 246283, 579651, 531831, 110699, 579649, 367689, 367683, 531828, 579647, 579637, 579635, 437727, 367681, 579630, 437723, 200791, 579628, 589572, 437675, 437671, 437665, 437654, 437640, 437637, 437634, 409706, 589570, 437627, 437625, 437623, 531813, 437620, 437617, 200788, 200787, 437607, 437584, 437582, 334007, 334005, 334003, 334000, 333998, 437579, 437576, 437571, 437566, 437561, 437545, 437542, 531806, 437540, 246269, 437537, 437535, 437532, 437530, 536245, 437527, 437522, 536241, 531800, 614675, 579615, 536237, 536235, 536226, 437515, 437512, 589520, 547934, 531791, 437505, 536221, 437499, 531784, 437486, 437483, 437481, 437479, 437477, 437474, 246261, 246259, 437459, 437401, 437397, 437394, 437392, 437390, 437386, 531776, 614673, 156923, 246253, 156921, 246251, 246247, 581270, 246245, 246243, 437365, 437363, 531774, 437332, 437326, 437324, 589397, 531765, 437290, 437287, 589282, 246238, 589198, 589191, 589189, 470904, 437285, 437281, 589170, 589168, 470897, 589161, 589159, 589158, 470895, 531755, 437277, 399376, 573713, 588934, 589278, 589156, 589276, 589274, 531750, 437266, 437264, 589147, 437257, 589143, 589140, 589112, 374220, 587677, 531742, 587675, 589107, 589091, 588697, 588695, 589081, 589079, 246232, 589068, 531736, 588451, 588449, 588693, 570373, 570368, 570366, 570363, 570356, 570354, 531731, 579600, 531729, 588425, 531726, 531723, 579597, 588911, 614666, 588893, 473623, 473617, 531718, 437245, 531715, 246226, 531711, 588416, 588411, 531706, 588395, 588391, 588385, 588382, 369265, 588379, 588890, 588357, 588353, 588349, 588345, 531698, 588324, 531696, 531694, 588301, 588299, 437242, 588297, 588293, 531691, 437240, 581266, 579588, 246224, 570349, 554205, 531688, 570343, 554203, 554191, 554189, 588282, 588276, 588274, 588272, 588268, 531681, 588265, 588263, 588260, 588257, 588251, 588248, 369264, 531678, 588766, 397458, 437237, 421214, 206213, 588227, 588734, 421212, 421210, 531672, 588751, 588748, 437226, 557948, 588214, 531668, 557946, 588212, 557944, 557933, 557928, 557918, 557916, 557914, 557908, 246218, 588198, 246216, 531666, 309793, 588195, 585394, 588190, 531664, 588168, 588104, 531656, 531652, 531649, 588093, 614663, 110697, 246212, 579581, 579579, 579575, 579573, 579570, 579568, 579566, 588089, 579564, 110692, 579561, 588590, 588079, 588588, 588075, 437176, 109134, 437174, 588067, 587310, 588059, 588054, 588053, 587307, 437164, 588040, 588036, 188891, 588030, 188889, 588027, 588024, 437150, 588511, 588500, 200771, 588488, 531636, 437142, 588476, 437140, 588003, 588472, 437137, 587994, 587990, 587987, 587982, 587980, 579555, 437134, 531634, 587977, 437126, 588467, 437124, 587644, 437122, 531632, 538459, 556979, 538457, 587972, 587970, 587968, 587966, 587964, 587961, 531627, 587642, 587958, 587924, 587920, 437114, 579553, 587640, 587889, 587636, 587871, 587868, 587865, 587861, 587858, 587855, 587853, 246205, 587851, 531620, 246203, 587847, 587830, 587827, 587824, 587821, 587819, 587815, 587806, 587799, 587795, 246201, 200762, 587792, 587789, 587786, 531615, 587783, 437084, 587781, 587776, 587773, 587768, 531612, 587764, 246199, 587755, 587747, 587743, 587738, 587735, 587733, 587731, 437071, 531611, 587723, 587721, 587719, 437063, 531608, 437058, 437057, 437047, 587693, 246192, 221761, 536195, 536193, 206211, 531600, 206210, 347348, 206208, 531595, 347346, 206206, 531590, 347341, 587611, 531585, 347334, 347332, 246178, 437013, 437002, 436998, 587584, 436991, 246170, 587580, 579533, 531576, 200755, 587446, 436986, 436968, 436965, 531574, 246167, 436960, 436958, 436938, 246159, 246151, 436921, 436918, 531564, 531558, 436911, 246144, 436904, 436901, 436899, 436897, 531553, 436895, 579529, 246136, 246121, 531547, 189201, 436892, 531545, 531543, 587444, 587442, 587440, 587347, 531538, 189199, 246108, 531533, 200752, 531531, 436878, 436875, 436869, 531526, 436858, 587336, 436853, 436841, 436829, 109123, 436812, 436808, 436797, 436793, 531517, 531514, 436775, 436773, 436771, 436757, 246096, 436754, 436752, 494960, 436750, 436742, 436733, 587270, 531508, 310072, 265552, 265550, 310070, 310067, 531505, 310065, 436727, 310053, 436725, 436723, 531502, 436721, 436719, 436717, 579526, 579524, 436715, 531499, 436710, 531497, 531491, 436704, 536173, 367666, 436701, 536171, 246092, 246087, 246083, 531485, 436687, 436683, 531481, 586921, 531479, 586918, 436678, 436676, 110684, 586915, 586913, 586911, 586902, 531475, 436672, 436670, 587074, 586899, 586881, 586998, 586872, 586985, 586869, 586862, 586968, 586960, 586957, 586859, 586853, 586841, 585994, 585991, 540664, 586818, 586835, 586832, 586383, 586381, 586823, 436650, 586375, 586374, 586372, 110673, 436642, 585984, 436640, 585973, 109111, 109110, 585970, 456143, 456141, 110669, 110666, 110658, 586462, 110656, 110654, 109106, 586460, 585953, 586455, 586452, 585938, 436615, 584997, 109104, 109102, 579514, 579511, 246070, 109085, 109082, 109080, 109077, 586721, 531446, 109074, 200737, 586667, 436556, 200731, 109069, 586423, 200729, 586421, 586510, 436545, 436531, 586507, 436514, 436512, 531428, 586493, 436510, 246063, 531420, 531418, 206201, 586488, 206197, 579461, 206193, 206191, 436487, 586471, 436479, 586469, 436477, 436475, 436452, 436447, 436444, 586357, 436442, 436438, 586354, 436436, 586439, 586437, 436427, 436422, 174373, 436420, 531405, 436417, 436413, 221674, 531400, 436410, 436407, 369258, 174357, 174353, 174352, 174350, 436405, 586394, 174348, 436403, 436387, 436382, 436378, 579442, 585667, 586120, 436361, 586112, 531383, 586108, 579420, 579418, 579412, 579409, 585767, 585760, 531371, 585749, 585746, 585731, 585744, 585728, 585726, 585709, 585707, 585705, 585701, 206185, 436329, 585635, 109058, 531367, 109056, 109054, 436325, 246047, 436318, 531363, 436316, 436314, 578409, 436302, 436297, 189194, 585526, 531359, 436279, 246039, 579388, 246036, 579386, 246034, 246032, 246030, 246018, 246016, 246015, 246012, 531353, 188873, 585486, 531347, 585474, 246010, 585472, 246008, 246006, 579383, 531341, 579375, 531337, 579373, 531333, 579364, 579361, 579355, 579352, 579349, 579340, 531326, 579335, 361102, 436243, 536147, 536142, 531322, 245999, 436234, 531318, 436220, 436218, 436216, 436208, 436187, 436185, 531314, 436183, 245993, 436167, 436165, 436152, 436149, 436129, 436118, 436115, 579308, 585104, 309771, 206182, 206181, 245970, 436017, 585065, 585039, 489036, 489034, 584378, 435998, 585037, 221585, 435996, 435988, 435979, 435968, 435961, 572651, 572649, 435947, 309734, 309730, 221568, 245964, 309727, 245960, 531280, 531278, 435932, 435923, 539534, 435920, 245957, 531272, 435898, 221558, 572869, 435893, 435890, 554055, 435888, 554048, 435878, 221553, 435876, 435873, 435870, 435868, 584616, 435866, 554042, 554040, 584606, 435860, 584245, 578032, 435858, 435855, 578029, 578027, 584597, 435852, 578024, 435849, 578022, 584594, 435843, 584585, 435839, 435837, 109009, 584717, 435834, 584580, 435832, 584712, 245949, 584706, 584694, 584691, 584684, 435821, 539529, 435810, 221525, 200689, 531257, 206175, 245940, 531252, 245938, 531251, 245931, 531246, 200682, 579262, 581624, 531242, 435789, 584365, 584363, 531238, 579237, 579224, 531233, 435775, 221514, 581150, 435764, 531227, 435759, 581142, 584319, 584315, 581137, 584313, 581135, 435756, 584302, 531220, 581127, 435749, 435739, 435711, 579220, 581925, 584285, 578426, 435702, 578424, 435699, 435694, 571258, 578422, 571256, 435676, 435668, 584216, 584208, 584206, 435585, 584197, 584195, 584190, 435556, 435540, 435535, 579204, 245918, 435533, 435529, 531199, 435527, 435524, 536133, 435521, 572635, 435517, 435509, 435500, 435483, 579201, 584014, 531190, 581892, 200663, 245912, 531189, 245909, 581881, 579196, 531181, 245904, 245899, 245893, 245881, 200660, 245876, 579182, 579166, 200656, 200654, 200651, 579159, 435440, 580878, 581758, 435425, 435421, 435416, 579152, 435382, 435368, 435366, 579148, 435359, 579145, 579139, 200640, 221433, 435351, 435345, 435342, 435338, 200633, 245827, 245820, 435219, 531144, 579027, 579021, 412505, 579015, 579006, 579002, 245816, 579000, 578988, 578984, 578982, 435208, 531139, 578980, 399368, 578976, 399364, 578969, 578967, 578965, 578963, 578960, 578958, 578955, 435200, 531135, 221416, 578953, 435195, 435193, 578951, 578945, 578943, 531132, 578939, 578937, 578934, 578931, 578929, 578925, 578923, 578916, 578914, 551139, 465028, 531126, 465026, 551137, 245801, 245798, 434686, 434684, 434682, 434680, 245562, 434677, 434675, 434672, 434668, 577473, 577471, 434663, 434661, 577468, 434656, 577461, 434654, 434652, 412435, 434650, 434648, 434646, 434643, 434640, 108953, 108951, 108948, 434635, 434633, 434631, 434625, 434623, 434621, 434619, 434616, 434612, 434608, 234876, 577488, 234874, 577486, 245560, 434606, 530847, 577455, 530845, 200531, 200527, 200525, 200515, 577427, 577424, 200513, 200510, 200506, 234868, 412422, 245557, 200503, 200496, 434579, 434577, 434575, 576873, 221238, 530839, 245552, 576870, 530836, 245550, 576868, 200490, 530830, 576865, 245548, 434561, 245546, 245538, 530828, 434551, 245535, 434546, 234851, 530826, 530823, 234846, 234833, 577358, 434544, 434541, 434536, 245531, 434534, 577352, 434532, 245530, 245521, 434521, 434519, 434512, 434509, 434504, 434501, 434497, 434491, 434483, 434480, 434478, 234829, 200479, 522671, 522669, 485919, 530805, 234822, 434447, 234814, 434434, 434431, 434423, 434422, 434417, 570840, 434410, 434407, 434405, 530791, 434398, 434395, 434387, 530786, 234801, 434348, 434345, 434342, 434339, 434337, 434335, 434331, 434328, 434326, 434323, 434321, 434316, 434313, 434311, 530784, 434309, 434307, 434304, 576745, 576743, 576738, 434299, 434291, 548619, 548609, 434288, 434285, 530776, 434266, 234793, 234789, 234770, 234768, 234766, 245516, 234764, 434245, 434243, 434240, 434238, 434234, 434232, 434230, 434228, 234729, 234681, 530769, 234675, 234671, 234669, 234664, 234662, 234658, 234655, 234652, 234650, 234646, 234644, 234638, 530765, 485911, 206151, 234622, 530764, 245514, 576687, 245512, 221206, 245510, 234620, 245498, 108898, 374946, 108894, 234616, 108888, 575949, 108886, 108884, 108880, 108873, 530758, 530757, 234602, 245482, 221192, 530755, 412406, 234598, 245480, 245473, 245469, 530748, 245464, 530746, 234589, 221172, 434220, 530735, 234566, 234564, 234562, 530727, 234559, 234546, 434218, 434216, 434214, 434212, 434210, 434206, 234536, 434204, 530718, 434196, 234531, 434193, 434165, 245429, 576463, 522659, 234517, 245422, 530709, 245410, 530707, 576142, 576140, 234497, 576133, 576152, 399343, 245404, 530694, 245391, 245388, 245386, 245374, 245371, 530691, 245368, 574348, 539509, 574344, 245361, 245346, 245344, 245339, 245329, 245327, 245321, 245318, 245316, 245310, 245308, 245304, 245297, 245295, 245293, 245291, 245277, 245275, 245266, 245264, 572632, 381201, 572630, 245259, 369222, 221117, 434133, 434130, 245250, 530664, 575788, 530662, 575785, 530660, 536081, 434120, 369219, 434112, 434107, 530656, 530655, 485906, 310576, 434096, 310574, 434092, 434089, 434087, 434084, 575731, 434082, 434076, 369218, 369216, 369214, 369207, 369205, 526407, 526405, 200445, 200443, 530643, 530638, 530636, 530634, 573868, 573862, 573860, 530631, 245246, 234469, 412386, 530628, 245244, 245242, 200436, 494762, 245239, 188863, 526403, 245234, 245232, 434027, 245229, 434025, 575463, 245227, 575461, 245224, 245221, 200433, 530624, 530622, 245216, 234466, 530618, 530616, 434020, 527765, 245212, 530612, 221089, 573839, 245209, 530610, 245207, 245202, 245200, 245197, 434002, 530604, 433998, 245193, 530601, 433990, 530596, 234460, 433988, 433979, 530593, 234457, 530592, 234455, 234453, 234451, 234446, 234444, 530584, 234441, 221061, 530580, 234439, 530577, 433964, 575274, 433951, 575271, 433947, 433945, 433941, 433939, 433934, 433923, 433915, 530566, 221052, 530564, 245191, 234437, 245189, 530557, 234434, 245186, 234429, 234427, 245184, 234424, 530551, 530549, 530547, 234418, 234413, 234409, 245182, 530545, 245179, 530541, 234407, 433906, 433904, 433901, 234403, 530539, 433897, 234400, 530537, 530531, 234392, 530530, 234388, 433893, 234386, 530523, 234374, 234372, 234370, 485901, 234367, 234364, 234362, 234358, 245174, 234355, 234347, 234345, 234341, 234338, 234335, 433891, 234333, 560870, 234329, 574899, 234327, 574893, 234321, 245173, 245144, 245141, 433884, 245138, 234293, 530499, 245133, 485898, 433877, 433875, 433869, 200401, 433867, 433864, 530489, 433857, 433855, 433848, 433847, 433839, 433820, 245121, 433813, 433809, 433805, 433803, 574790, 245116, 433801, 433793, 530476, 433791, 433789, 573804, 433787, 369198, 433785, 530472, 574382, 574734, 245112, 369195, 245094, 530469, 574726, 245086, 433772, 234281, 234278, 234275, 526396, 530467, 234270, 433770, 234266, 221014, 530465, 221012, 574670, 200398, 433757, 200396, 574668, 471289, 234260, 433755, 433753, 433750, 200393, 433747, 433740, 234258, 471282, 234256, 245083, 433738, 245081, 245078, 485896, 574380, 245076, 530452, 573136, 574218, 530450, 573134, 574378, 572043, 234249, 234245, 234243, 234241, 573129, 574376, 573124, 433731, 234236, 234234, 574372, 433729, 234231, 234220, 234218, 433726, 234216, 234213, 234211, 433723, 433721, 574366, 433719, 397445, 433716, 245073, 570335, 397443, 234201, 433714, 433706, 433703, 433701, 397434, 397431, 397426, 573914, 574187, 433699, 414125, 234199, 536054, 433694, 414123, 234187, 536052, 433691, 536050, 433689, 234182, 530432, 573093, 234180, 234173, 234171, 573090, 574338, 573088, 574233, 574336, 574334, 234169, 574331, 234167, 245058, 574167, 574183, 234152, 574165, 574181, 245056, 245053, 433686, 234137, 574179, 574178, 245050, 234134, 234132, 234130, 234128, 234124, 234122, 234118, 234115, 234112, 572018, 245048, 433671, 433670, 574175, 433667, 433665, 433663, 433656, 433653, 485892, 234100, 433651, 433648, 433640, 433623, 433615, 433588, 530377, 234028, 234026, 530312, 234007, 433501, 573476, 573445, 573441, 245031, 573439, 530300, 245029, 530298, 245023, 245019, 244998, 530288, 234003, 573403, 573393, 530284, 530271, 542782, 572154, 573313, 572152, 244992, 233976, 470876, 233973, 463663, 233970, 433447, 530225, 244931, 530221, 244927, 220934, 530206, 530205, 470874, 530197, 530195, 572662, 530189, 523582, 200333, 244904, 433418, 530186, 569107, 523578, 530184, 433408, 200329, 530182, 433406, 233958, 433404, 530179, 433394, 233947, 244896, 244894, 244892, 244890, 244887, 244885, 244881, 244877, 244873, 244865, 244860, 244853, 244849, 244845, 244839, 244829, 233945, 244808, 568594, 433391, 233939, 433386, 433375, 572361, 233935, 433364, 433361, 433359, 433357, 433355, 433351, 433349, 433347, 433345, 433343, 433341, 433338, 572477, 433336, 572357, 433330, 433323, 571999, 433319, 433315, 571997, 433311, 549179, 571995, 433308, 571993, 433305, 433303, 433300, 433298, 571988, 570990, 570987, 571984, 433293, 571979, 433291, 571976, 570983, 571974, 433289, 572354, 530143, 570978, 572352, 433286, 433276, 433274, 572340, 244773, 530141, 572330, 572327, 433271, 549176, 572325, 244770, 572310, 220916, 530139, 572304, 572302, 572298, 433267, 110593, 572294, 244766, 572291, 572289, 433261, 572287, 572285, 110591, 433258, 433256, 572283, 526342, 530136, 572236, 572281, 433254, 403164, 526339, 572278, 572275, 324023, 433251, 244764, 549173, 571967, 397417, 572387, 244760, 571965, 433244, 233931, 397409, 397401, 397399, 571207, 571955, 397396, 397394, 397391, 397389, 244758, 397387, 220912, 397385, 433242, 397383, 433240, 433233, 433223, 233918, 433221, 233915, 233913, 336337, 233910, 433217, 233906, 571937, 572245, 571935, 244753, 433206, 530128, 571922, 433201, 571920, 433199, 433197, 571918, 572150, 572148, 433195, 571915, 571913, 571911, 571909, 571907, 572146, 433192, 530123, 572171, 572166, 412368, 433181, 572143, 233888, 571899, 244746, 233886, 572140, 244744, 244740, 412366, 244738, 530120, 244736, 571887, 433179, 571875, 233883, 530114, 433169, 530112, 433166, 571858, 530109, 433164, 433162, 433160, 433066, 433057, 433055, 530079, 530073, 233873, 568585, 233868, 568583, 433033, 233866, 233864, 233862, 233860, 530069, 233857, 233853, 530066, 433021, 233844, 530062, 233841, 530061, 233836, 530059, 433016, 233833, 244710, 530056, 244708, 491100, 244706, 544704, 544702, 544700, 432988, 432986, 233831, 233828, 432980, 432975, 432973, 432969, 432967, 432963, 530042, 573550, 565397, 432959, 530037, 530036, 530035, 530032, 432944, 571423, 571417, 530028, 432941, 244703, 530026, 530022, 244700, 547816, 526332, 526328, 432920, 530013, 571363, 526323, 526319, 530010, 526311, 220878, 432913, 526308, 526306, 530008, 526303, 233825, 530006, 526299, 526295, 530001, 526293, 526291, 529999, 529996, 432911, 529994, 547813, 547811, 432908, 547809, 432906, 529992, 432904, 432902, 432900, 200309, 398463, 551942, 529988, 485879, 529982, 485876, 485874, 527749, 200306, 485872, 432898, 485870, 485865, 485863, 571236, 314670, 529974, 570333, 432890, 336329, 565083, 336326, 571227, 529971, 336324, 529966, 547469, 529961, 547467, 529959, 432885, 570323, 553737, 220869, 529954, 220867, 553735, 570321, 529945, 553732, 220864, 529942, 529940, 220862, 529937, 220859, 529932, 188857, 220854, 529930, 220852, 553729, 529928, 110583, 529923, 553726, 553723, 529921, 110580, 220849, 553721, 553719, 220847, 432875, 244677, 529919, 432871, 110578, 553716, 244675, 392184, 529910, 244656, 553711, 551938, 110574, 570797, 570587, 571090, 570585, 529907, 571088, 432868, 570794, 110571, 432866, 571049, 529905, 220838, 571042, 244634, 233789, 571040, 570154, 570152, 402286, 529903, 402282, 402279, 565715, 402277, 402275, 529897, 402273, 529895, 402271, 402269, 529893, 402267, 529891, 402264, 529889, 529886, 36119, 220808, 529877, 36117, 432857, 529868, 432854, 432852, 309657, 309655, 309653, 36113, 309651, 529866, 529862, 369187, 529855, 432834, 529854, 529850, 432826, 432823, 432818, 529848, 541932, 539499, 529828, 220705, 529798, 529797, 220703, 220701, 220699))
Run Time: 0.340018
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4904 | |
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 | | | | | 4904 | |
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 (35406, 35373, 35174, 35147, 35020, 34995, 34948, 34918, 34907, 34832, 34824, 34679, 34623, 34286, 34051, 33623, 33571, 33522, 33512, 33509, 33508, 33507, 33506, 33505, 33504, 33503, 33502, 33501, 33500, 33499, 33498, 33497, 33496, 33495, 33494, 33493, 33322, 30832, 30615, 30011, 29963))
Run Time: 0.003474
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 41 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 180
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (646403, 646290, 646289, 646287, 646249, 646245, 646231, 646155, 646153, 646066, 646058, 646054, 646036, 646015, 646012, 646010, 645989, 645857, 645827, 645824, 645820, 645815, 645806, 645739, 645730, 645687, 645672, 645670, 645668, 645635, 645474, 645445, 645444, 645440, 645339, 645314, 645313, 645248, 645200, 645178, 645126, 645064, 645033, 645029, 644969, 644929, 644872, 644823, 644755, 644723, 644716, 644708, 644697, 644696, 644550, 644507, 644491, 644486, 644472, 644464, 644444, 644443, 644432, 644421, 644401, 644389, 644302, 644286, 644217, 644215, 644177, 644175, 643930, 643924, 643881, 643874, 643840, 643761, 643746, 643708, 643613, 643427, 643328, 643322, 643313, 643309, 643306, 643304, 643302, 643299, 643147, 643124, 643061, 642987, 642979, 642963, 642957, 642919, 642866, 642862, 642823, 642821, 642817, 642813, 642738, 642737, 642719, 642714, 642706, 642703, 642701, 642664, 642660, 642653, 642632, 642584, 642573, 642570, 642562, 642559, 642515, 642498, 642433, 642413, 642406, 642390, 642387, 642385, 642382, 642376, 642374, 642373, 642343, 642341, 642321, 642312, 642280, 642276, 642270, 642265, 642261, 642257, 642253, 642231, 642224, 642217, 642192, 642172, 642154, 642095, 642091, 641972, 641970, 641960, 641931, 641896, 641893, 641890, 641882, 641828, 641820, 641803, 641791, 641771, 641766, 641765, 641728, 641724, 641720, 641718, 641717, 641709, 641703, 641608, 641606, 641600, 641594, 641591, 641475, 641472, 641467, 641465, 641461, 641444, 641409, 641405, 641395, 641390, 641382, 641381, 641378, 641375, 641373, 641372, 641354, 641353, 641345, 641344, 641342, 641339, 641334, 641323, 641294, 641291, 641286, 641219, 641216, 641176, 641172, 641170, 641169, 641159, 641157, 641112, 641102, 641090, 641085, 641059, 641057, 641020, 640998, 640995, 640993, 640953, 640915, 640913, 640912, 640894, 640891, 640868, 640865, 640851, 640594, 447746, 640770, 640758, 640768, 640756, 640754, 201214, 201212, 201210, 201207, 630012, 447736, 447733, 447731, 447729, 447727, 447725, 447723, 447721, 447718, 630011, 640608, 639997, 640676, 640673, 640703, 640660, 640657, 640655, 640652, 447708, 447702, 447700, 640452, 633974, 634017, 633966, 634014, 633963, 633961, 633959, 634012, 633956, 580765, 633949, 633947, 580763, 640588, 534944, 580759, 580757, 580754, 580752, 580750, 580745, 580743, 580741, 640559, 447689, 604369, 447687, 447685, 447682, 447680, 447678, 417936, 417934, 417932, 417930, 639734, 447666, 109281, 109275, 109272, 109270, 109268, 109266, 109263, 109259, 639723, 447658, 447651, 447648, 447646, 447644, 447635, 447633, 447627, 447625, 447623, 640531, 447621, 447619, 640525, 447611, 640131, 639991, 639986, 639984, 640128, 639982, 447606, 639980, 447587, 447584, 447582, 447580, 447577, 447574, 640444, 640442, 640414, 640412, 639607, 639605, 640404, 639603, 640402, 539608, 447567, 539605, 539603, 447557, 640319, 447553, 447551, 447547, 447545, 447542, 640316, 640314, 640311, 640306, 640284, 640233, 640230, 640222, 637058, 639486, 640124, 640122, 640120, 640117, 640116, 640114, 640112, 640110, 640107, 447529, 639111, 640097, 640095, 640093, 640091, 640089, 639109, 640087, 447520, 640085, 309847, 309845, 640083, 640081, 640079, 640077, 640075, 640072, 640070, 640068, 639108, 640066, 640061, 640059, 639107, 640058, 640056, 640053, 639105, 447509, 447507, 639485, 639483, 639104, 447491, 639480, 639479, 640027, 639477, 639475, 639474, 640025, 640023, 640021, 640013, 639472, 447447, 447445, 639470, 447431, 447423, 447419, 639467, 639942, 639939, 639463, 639461, 639459, 639882, 639456, 639454, 580732, 247284, 639448, 639446, 639444, 639442, 247282, 447374, 247280, 639575, 639573, 639439, 639570, 639437, 639435, 639565, 639563, 639560, 639558, 639433, 639431, 639429, 639428, 639425, 639423, 639420, 639418, 639415, 639103, 639413, 447307, 447305, 447300, 447298, 639101, 639099, 447294, 639097, 639095, 447288, 639094, 447285, 447280, 447278, 639093, 639092, 639335, 639331, 639090, 639088, 639087, 639083, 447265, 639074, 447260, 447258, 639072, 639070, 639068, 639066, 639062, 639059, 447251, 635672, 639232, 639056, 639054, 639227, 447238, 639051, 639049, 447236, 639048, 447232, 639047, 447230, 447217, 608173, 639046, 639045, 447213, 639044, 639042, 639040, 639038, 639036, 639032, 639030, 447206, 639027, 639025, 639024, 447177, 447158, 639132, 639023, 639114, 639022, 639020, 580723, 447146, 580719, 580717, 447137, 189143, 638990, 638988, 638986, 578060, 578056, 578053, 578051, 578048, 578046, 578044, 578042, 447114, 447112, 447108, 447106, 247276, 447098, 638823, 638811, 638808, 638732, 637013, 638337, 638553, 534859, 637185, 534858, 583930, 638424, 580712, 580710, 580704, 638422, 638420, 638519, 247273, 638418, 534846, 447074, 447068, 447063, 638415, 638409, 638404, 638397, 638392, 638389, 638386, 638384, 638380, 447025, 447013, 638335, 638333, 638331, 638329, 638327, 638325, 583904, 583903, 580690, 580688, 629989, 638271, 580682, 580679, 633946, 583900, 446987, 612897, 633944, 612895, 536420, 612892, 633941, 633937, 633934, 638213, 638209, 633907, 629986, 625736, 633905, 583891, 583888, 583886, 446973, 446970, 446968, 446966, 446964, 446962, 446960, 446957, 446953, 446951, 446946, 638170, 638104, 583883, 638102, 638100, 638098, 247272, 583880, 583877, 583875, 247266, 638108, 638073, 638017, 638015, 638038, 583867, 606029, 583865, 583863, 638007, 583857, 534810, 638001, 534808, 637996, 637965, 637963, 446936, 637961, 637957, 637934, 446934, 446932, 446929, 446925, 446922, 446919, 446917, 446915, 446905, 637846, 446903, 446900, 637757, 565470, 446894, 637727, 446888, 201197, 637702, 637690, 580670, 637604, 580666, 534786, 446867, 446856, 446851, 446848, 446843, 446839, 446837, 446835, 446829, 534778, 637455, 446826, 446823, 534777, 637446, 446817, 583825, 534772, 534770, 637344, 446806, 637339, 637337, 637331, 637328, 637326, 446791, 446789, 637324, 637322, 446787, 446780, 446777, 446772, 446770, 637266, 534769, 580657, 580654, 580652, 181014, 580650, 637180, 637149, 446761, 637176, 637174, 637172, 446759, 637145, 583814, 446757, 583812, 446755, 637164, 534760, 607950, 201193, 637126, 637124, 637121, 637110, 629976, 580647, 446752, 446750, 247262, 247260, 446748, 446745, 446743, 637050, 446741, 637047, 637045, 247258, 247256, 247254, 637038, 637066, 637035, 637023, 534751, 636242, 446736, 636975, 636954, 636952, 636950, 636946, 636944, 636934, 636932, 636928, 636925, 636942, 636923, 633381, 633378, 633374, 633371, 636859, 636832, 633368, 636826, 309837, 309835, 309829, 636743, 534742, 628595, 628593, 628590, 446710, 309825, 632795, 636650, 632793, 636463, 247252, 247251, 247249, 247246, 247244, 247242, 247240, 446700, 634011, 634009, 634007, 634005, 634002, 633999, 633997, 446684, 633996, 636648, 636637, 636641, 636491, 580643, 580641, 580639, 580637, 636606, 324061, 580633, 580631, 580629, 580627, 580624, 580622, 626748, 636385, 626746, 534730, 636521, 636519, 636516, 446665, 636502, 446662, 636454, 636494, 446656, 446654, 446650, 635666, 446640, 636437, 446637, 636324, 446623, 446603, 201188, 636297, 636295, 636293, 446591, 446586, 446571, 446565, 446550, 630242, 446547, 446541, 247238, 446533, 633904, 446530, 247237, 446523, 247234, 446518, 247231, 446516, 446513, 247229, 534707, 536418, 446501, 446486, 534703, 446480, 446478, 247226, 446474, 247223, 247221, 247218, 247216, 247214, 247210, 601195, 636054, 247204, 580615, 247201, 635816, 635813, 635811, 446445, 635800, 635744, 635742, 635739, 635658, 189137, 634409, 634407, 446433, 446427, 247199, 247197, 247195, 247193, 247191, 602461, 602459, 602456, 635524, 446405, 446403, 635327, 446369, 635219, 635076, 634928, 446349, 634785, 247187, 247184, 247180, 247178, 247175, 634403, 634675, 247171, 534634, 597501, 634621, 634619, 634469, 634601, 446303, 634395, 634393, 446294, 634338, 536416, 580612, 580610, 633300, 446278, 634277, 634286, 634207, 629942, 634205, 446264, 534616, 201179, 446263, 446260, 634228, 634226, 634223, 446256, 446254, 634094, 634090, 247166, 634122, 634116, 446249, 634111, 446247, 446245, 609120, 446242, 632567, 634055, 602490, 602488, 633590, 592742, 592739, 629939, 592737, 634025, 634021, 633989, 633987, 633808, 633985, 633843, 633902, 633899, 633896, 633894, 629937, 629934, 534603, 446219, 633648, 633886, 633884, 633654, 633646, 633882, 633879, 633877, 633874, 446209, 633872, 446207, 611450, 633555, 446177, 633871, 632923, 632915, 633868, 536413, 633866, 536411, 633863, 536409, 629929, 633861, 629927, 633222, 536407, 633433, 629925, 247165, 536402, 536399, 536397, 633365, 536395, 389278, 633363, 446161, 446159, 446130, 633154, 446123, 633031, 633006, 446105, 446103, 534537, 446100, 446092, 446090, 446086, 446075, 446064, 446055, 446053, 189128, 189125, 247153, 446029, 247151, 446027, 247149, 247148, 534525, 534522, 247147, 247145, 247139, 445988, 445981, 583635, 583631, 583629, 445969, 445966, 631619, 631617, 631615, 631612, 631607, 631603, 632658, 632655, 632653, 631591, 189124, 631584, 631582, 632645, 534506, 631578, 631576, 631566, 632500, 631550, 631548, 631542, 247130, 247129, 247128, 325222, 632442, 325220, 632439, 445942, 445940, 632437, 632433, 632430, 632427, 632425, 632423, 632420, 632042, 632407, 632335, 632333, 632405, 632398, 247118, 247107, 632162, 632169, 247105, 189119, 189116, 632148, 247103, 580598, 534491, 580595, 580593, 632092, 247101, 632090, 247098, 580586, 632026, 632024, 632022, 445915, 445912, 445909, 445905, 445903, 445901, 445894, 632020, 632018, 632016, 632013, 445890, 631953, 632008, 445877, 445865, 631539, 445861, 488678, 445859, 445857, 631951, 631947, 445853, 445846, 445842, 445840, 445838, 445813, 445804, 631537, 631859, 631853, 631838, 631844, 631832, 631531, 631846, 534484, 631841, 631829, 631800, 631817, 631813, 631527, 631518, 445800, 631512, 631748, 631743, 631509, 631739, 580577, 631735, 631492, 631488, 631486, 631484, 631730, 631482, 631480, 580574, 580572, 445793, 445791, 445789, 445787, 631470, 445784, 631468, 445776, 110755, 445769, 631461, 631458, 631456, 445766, 607478, 631453, 445761, 445759, 631446, 631412, 631409, 631406, 631402, 631400, 631398, 445756, 580556, 631367, 631365, 630953, 631363, 631358, 445731, 631634, 445728, 445710, 445706, 445701, 445694, 445692, 445689, 445686, 445682, 631291, 445680, 445678, 445672, 445662, 445660, 583545, 583541, 631198, 392481, 580545, 580539, 580537, 580535, 631156, 629338, 247096, 331413, 631079, 606775, 331399, 631077, 606773, 631067, 606770, 445652, 445650, 445648, 606768, 445645, 247094, 445641, 606765, 445626, 534458, 247092, 445612, 580532, 445601, 580530, 445599, 445591, 534451, 607457, 607455, 607452, 607450, 612590, 612588, 589701, 612585, 589698, 612583, 247087, 589696, 607448, 630900, 445586, 589687, 589685, 445584, 589683, 445581, 534449, 445570, 445568, 445563, 445560, 445553, 607431, 607429, 607418, 607415, 607413, 607408, 607406, 630779, 630682, 445550, 445548, 630672, 445546, 445544, 630636, 445537, 630618, 445534, 445532, 445527, 629882, 445525, 630595, 534428, 589681, 596075, 630542, 630537, 630547, 630522, 534422, 629880, 629877, 534420, 630471, 630448, 624177, 624175, 624173, 630420, 630359, 630329, 628068, 201152, 445501, 629869, 189111, 445494, 445492, 445476, 630148, 445469, 629864, 630146, 445465, 247084, 588969, 247082, 588967, 445461, 630131, 630128, 630134, 629717, 445457, 247079, 445455, 445453, 534406, 189110, 629860, 247073, 247071, 629858, 629845, 247068, 629843, 630038, 445447, 629838, 629836, 629816, 629771, 247059, 247052, 247050, 629798, 629764, 630033, 629792, 629761, 629757, 534394, 629742, 629740, 629712, 580526, 580524, 628619, 628617, 445412, 445406, 629664, 629574, 629572, 445400, 445397, 445394, 629638, 596054, 596052, 612580, 247047, 613437, 612578, 629623, 612576, 612574, 629618, 612572, 580521, 613430, 534377, 626699, 613428, 612570, 629603, 613426, 613423, 445384, 445377, 445375, 445372, 445369, 629190, 445361, 445359, 629187, 445357, 629566, 629563, 629561, 580515, 629539, 629525, 629523, 189107, 247038, 247035, 580511, 629503, 580507, 580505, 629489, 614893, 580503, 580501, 534375, 534372, 536392, 536390, 629434, 201147, 580494, 201145, 536386, 536384, 589323, 201138, 445346, 445341, 629321, 247027, 247025, 445339, 445336, 445331, 445329, 445325, 445322, 445318, 445308, 629256, 629252, 629250, 189105, 536379, 629217, 534351, 189102, 189099, 445306, 445304, 629108, 629104, 629100, 629096, 580491, 247021, 247018, 189094, 110750, 189092, 189090, 247014, 580479, 580476, 580474, 580472, 580469, 580467, 580465, 247009, 580459, 580457, 580455, 628931, 201126, 201121, 201119, 247006, 201114, 628583, 201109, 201102, 201100, 201098, 628579, 628576, 628572, 247005, 628570, 445286, 628866, 628561, 580454, 628558, 580452, 628554, 628552, 605228, 628549, 189088, 628804, 445281, 628605, 445276, 628524, 445275, 445256, 445247, 445244, 445241, 246993, 445233, 445231, 445224, 445220, 445218, 445195, 445192, 445188, 445179, 445177, 445175, 445173, 445157, 445129, 189237, 589312, 445126, 445124, 445122, 445118, 445116, 445112, 627489, 445110, 627688, 445104, 605668, 445102, 627655, 445100, 445096, 445094, 445092, 445090, 445086, 445083, 445080, 445077, 445075, 445073, 445070, 445067, 627466, 627294, 445038, 201082, 627444, 627441, 445013, 445009, 445004, 627207, 444982, 534290, 444970, 444968, 627110, 627107, 444966, 444964, 627040, 627073, 627037, 627062, 201081, 627035, 444960, 627031, 627029, 444958, 444956, 627023, 444954, 626885, 626854, 626883, 626850, 626668, 626834, 626830, 626825, 626819, 444919, 444912, 534283, 626763, 201080, 201078, 626666, 626662, 626719, 626716, 626714, 444878, 189070, 444763, 391991, 391989, 391986, 246981, 246978, 607914, 246976, 246971, 626111, 444726, 626107, 626105, 602751, 626064, 444703, 611440, 534242, 625882, 625875, 444654, 444648, 625816, 444642, 444639, 444634, 534229, 625807, 534225, 625626, 625624, 625597, 625622, 625190, 625594, 444618, 616163, 444604, 444576, 444574, 444572, 444551, 444546, 444540, 444538, 444536, 444534, 625668, 625666, 444522, 580432, 625733, 580430, 580426, 580423, 580421, 580419, 580415, 580411, 580409, 580407, 444507, 189059, 444499, 444495, 625662, 611431, 611427, 534214, 444488, 611421, 444483, 246966, 444481, 625605, 444479, 246964, 189056, 246962, 444477, 444466, 444450, 625489, 246950, 607912, 534205, 625451, 534201, 609063, 625449, 625430, 444408, 625304, 246945, 246943, 246941, 246939, 246937, 444394, 444387, 444385, 444383, 534182, 623937, 246753, 246733, 611503, 611328, 611326, 441704, 611319, 441676, 441667, 610910, 611150, 611144, 611175, 611142, 611045, 611043, 611040, 611034, 611028, 611025, 611018, 441614, 533254, 441611, 441595, 610993, 441589, 610972, 610970, 610966, 441582, 441564, 441503, 441479, 441472, 441431, 441429, 441426, 441409, 441405, 580222, 440844, 532878, 440840, 440838, 605525, 440715, 582799, 582797, 602548, 602545, 602532, 602526, 602524, 602521, 582795, 604356, 605286, 440710, 440687, 605105, 535452, 535443, 314803, 314800, 314798, 604845, 314794, 532832, 604842, 604838, 109229, 440563, 440561, 440550, 440546, 440544, 532791, 189229, 246675, 189226, 604431, 354520, 354518, 189223, 604429, 604444, 614738, 604427, 604425, 604439, 440468, 354516, 604281, 440458, 440454, 440452, 246672, 532780, 532773, 532759, 440426, 532749, 532747, 440424, 603326, 603299, 603228, 536362, 536360, 532729, 602574, 602501, 599029, 602610, 602607, 602454, 488699, 602452, 314788, 314786, 602192, 602145, 602140, 602137, 602131, 602129, 601592, 601573, 601564, 532699, 314784, 314780, 532697, 314777, 580196, 601504, 440284, 440282, 532689, 440270, 314773, 601865, 314767, 314765, 314763, 601849, 601847, 600121, 600116, 532675, 440238, 532668, 532666, 440193, 600812, 532657, 532655, 600625, 600623, 600621, 600619, 600588, 600616, 600615, 440180, 440177, 596580, 596578, 600516, 200901, 440166, 600484, 440161, 440154, 600136, 532634, 532631, 440139, 440137, 440132, 440129, 440125, 440123, 440120, 532626, 532623, 440115, 440111, 440103, 532617, 600030, 440092, 440090, 532614, 599968, 595097, 532610, 599925, 599938, 599920, 532608, 599918, 597852, 597849, 614958, 599868, 599820, 599809, 599803, 440081, 440078, 440067, 598346, 598344, 598341, 532600, 189219, 189216, 110734, 440043, 440039, 440035, 440033, 440031, 440025, 440021, 599654, 440008, 440003, 440001, 439999, 599589, 598688, 439972, 439969, 599416, 599391, 469415, 599236, 596726, 439938, 599146, 439934, 439927, 599123, 439925, 439923, 599102, 439916, 439913, 439911, 439909, 439907, 439905, 439902, 532587, 599060, 597545, 532584, 598907, 532583, 598905, 598798, 439887, 598784, 200881, 532577, 532576, 439885, 439880, 439877, 439872, 439870, 439868, 439866, 439863, 598659, 314759, 598598, 598606, 532569, 598596, 597843, 596923, 598453, 439825, 439816, 598436, 439813, 439807, 598393, 532564, 598390, 439804, 598232, 598230, 598226, 598357, 439796, 439781, 598351, 598349, 439775, 439773, 598285, 598282, 598276, 598271, 439762, 439760, 439756, 439731, 439698, 597771, 439668, 536355, 109225, 109223, 109219, 595060, 595057, 597437, 439642, 439640, 439636, 246667, 439632, 597564, 439630, 439625, 439615, 439613, 439609, 597558, 597555, 597551, 597549, 439587, 439585, 597514, 596763, 580155, 580149, 596493, 596489, 439533, 439531, 532532, 439529, 594778, 597148, 597162, 597160, 597064, 110732, 597123, 532525, 532523, 363088, 597092, 597089, 597087, 597083, 597080, 597078, 439523, 597076, 439521, 439516, 439514, 439512, 439510, 439506, 439504, 439501, 439499, 590858, 110730, 439487, 439477, 439475, 439473, 439470, 536350, 439462, 109215, 596980, 532520, 439452, 439450, 439448, 439446, 439444, 420396, 420393, 439436, 439430, 596752, 439422, 596833, 596829, 596827, 439416, 596748, 439414, 439409, 596741, 439403, 596738, 596734, 614731, 614728, 614726, 596651, 532505, 614724, 592667, 614722, 614719, 439398, 439393, 596607, 532497, 532496, 439381, 439379, 439377, 439374, 439372, 439368, 439364, 439361, 439358, 439352, 439347, 439345, 439343, 439341, 594531, 594529, 595253, 473637, 473634, 473632, 439314, 439312, 439305, 532488, 592101, 592099, 592097, 532483, 532481, 532479, 532478, 594902, 532470, 439278, 594780, 439275, 594685, 594683, 594680, 594665, 532465, 594658, 246664, 439260, 527977, 527973, 527967, 527963, 527960, 532457, 532454, 532451, 532449, 439253, 439251, 439241, 439238, 580143, 439236, 439234, 439230, 439228, 314756, 314754, 314752, 580140, 314739, 314736, 594453, 523619, 580135, 592500, 592495, 439212, 592491, 439210, 439208, 532442, 314734, 314732, 593338, 439196, 532436, 594220, 594218, 532434, 532431, 439183, 439181, 439179, 439177, 439175, 473630, 582274, 439173, 594112, 439165, 594108, 594106, 439160, 439154, 593782, 439148, 593776, 582260, 593772, 593896, 593940, 439140, 593888, 593885, 593883, 593879, 439138, 593824, 439135, 439133, 439129, 593875, 439118, 500373, 439109, 592089, 439103, 439090, 439088, 439066, 593704, 439060, 593695, 593742, 439057, 593501, 593499, 593497, 593495, 593492, 593489, 314730, 580121, 580118, 580116, 532411, 593305, 532409, 532406, 593296, 592956, 133261, 592954, 536335, 536333, 536331, 593189, 593186, 593184, 593163, 593160, 593158, 246657, 593148, 593080, 532378, 593078, 593063, 614713, 532357, 200855, 532354, 532353, 532349, 532345, 532340, 532339, 532335, 592488, 439000, 592486, 438994, 438989, 438987, 592566, 592562, 438976, 592078, 592532, 532313, 548372, 592325, 592416, 532309, 536327, 592413, 532307, 592322, 580104, 592320, 592316, 532304, 532297, 532270, 532268, 532264, 532262, 527934, 527930, 527921, 527911, 527909, 527903, 527901, 532250, 110719, 110717, 110715, 110712, 532243, 527864, 580101, 532238, 580099, 580096, 532230, 200848, 532228, 532219, 532216, 532213, 532211, 532204, 532199, 532195, 532191, 532189, 532185, 532183, 532181, 532177, 532167, 532163, 532158, 532142, 532136, 532127, 548331, 590650, 590648, 590645, 590643, 590641, 590639, 556836, 590634, 532053, 590564, 590559, 590519, 590511, 590508, 590503, 590495, 590485, 590481, 590478, 590475, 590471, 590468, 246609, 246603, 246601, 246598, 532043, 532040, 532038, 589899, 589896, 532032, 532030, 589892, 589888, 590430, 589881, 532026, 614694, 614692, 438518, 438510, 438503, 438497, 438494, 438489, 532015, 438469, 532009, 438447, 438440, 438423, 438418, 438415, 590261, 438413, 580062, 580059, 580050, 580038, 580031, 246569, 580027, 531995, 580025, 580020, 580013, 580011, 580003, 580000, 579997, 579995, 579994, 536274, 579992, 246563, 579986, 579983, 579977, 246556, 246553, 614691, 536264, 531980, 584849, 438373, 246545, 536260, 438365, 438363, 536256, 438359, 438354, 579969, 189211, 189207, 189205, 438323, 438318, 438312, 438301, 438290, 579950, 531969, 579944, 531967, 579939, 438251, 438243, 579921, 579919, 579917, 521081, 438173, 438171, 438169, 579902, 531947, 438154, 438150, 438145, 438136, 579897, 438132, 438129, 438127, 579862, 438125, 438121, 438118, 438113, 438108, 438064, 438042, 579837, 579835, 579828, 579824, 437992, 579798, 579790, 531917, 579752, 110705, 437938, 437934, 579745, 246465, 246448, 531902, 531901, 246437, 579733, 579727, 579724, 437880, 579713, 437866, 437860, 437858, 437856, 437854, 531889, 579705, 579692, 200802, 437848, 246401, 246392, 246380, 246354, 246352, 246342, 246338, 246334, 246320, 531868, 246304, 246302, 531856, 246300, 246298, 437812, 246295, 437807, 246293, 437805, 246291, 589861, 589858, 437788, 589852, 589847, 246289, 589845, 437784, 437780, 589818, 200798, 437771, 531843, 437768, 437765, 437758, 133227, 133224, 437756, 579673, 579668, 579665, 531839, 579662, 246288, 246283, 579651, 531831, 110699, 579649, 367689, 367683, 531828, 579647, 579637, 579635, 437727, 367681, 579630, 437723, 200791, 579628, 589572, 437675, 437671, 437665, 437654, 437640, 437637, 437634, 409706, 589570, 437627, 437625, 437623, 531813, 437620, 437617, 200788, 200787, 437607, 437584, 437582, 334007, 334005, 334003, 334000, 333998, 437579, 437576, 437571, 437566, 437561, 437545, 437542, 531806, 437540, 246269, 437537, 437535, 437532, 437530, 536245, 437527, 437522, 536241, 531800, 614675, 579615, 536237, 536235, 536226, 437515, 437512, 589520, 547934, 531791, 437505, 536221, 437499, 531784, 437486, 437483, 437481, 437479, 437477, 437474, 246261, 246259, 437459, 437401, 437397, 437394, 437392, 437390, 437386, 531776, 614673, 156923, 246253, 156921, 246251, 246247, 581270, 246245, 246243, 437365, 437363, 531774, 437332, 437326, 437324, 589397, 531765, 437290, 437287, 589282, 246238, 589198, 589191, 589189, 470904, 437285, 437281, 589170, 589168, 470897, 589161, 589159, 589158, 470895, 531755, 437277, 399376, 573713, 588934, 589278, 589156, 589276, 589274, 531750, 437266, 437264, 589147, 437257, 589143, 589140, 589112, 374220, 587677, 531742, 587675, 589107, 589091, 588697, 588695, 589081, 589079, 246232, 589068, 531736, 588451, 588449, 588693, 570373, 570368, 570366, 570363, 570356, 570354, 531731, 579600, 531729, 588425, 531726, 531723, 579597, 588911, 614666, 588893, 473623, 473617, 531718, 437245, 531715, 246226, 531711, 588416, 588411, 531706, 588395, 588391, 588385, 588382, 369265, 588379, 588890, 588357, 588353, 588349, 588345, 531698, 588324, 531696, 531694, 588301, 588299, 437242, 588297, 588293, 531691, 437240, 581266, 579588, 246224, 570349, 554205, 531688, 570343, 554203, 554191, 554189, 588282, 588276, 588274, 588272, 588268, 531681, 588265, 588263, 588260, 588257, 588251, 588248, 369264, 531678, 588766, 397458, 437237, 421214, 206213, 588227, 588734, 421212, 421210, 531672, 588751, 588748, 437226, 557948, 588214, 531668, 557946, 588212, 557944, 557933, 557928, 557918, 557916, 557914, 557908, 246218, 588198, 246216, 531666, 309793, 588195, 585394, 588190, 531664, 588168, 588104, 531656, 531652, 531649, 588093, 614663, 110697, 246212, 579581, 579579, 579575, 579573, 579570, 579568, 579566, 588089, 579564, 110692, 579561, 588590, 588079, 588588, 588075, 437176, 109134, 437174, 588067, 587310, 588059, 588054, 588053, 587307, 437164, 588040, 588036, 188891, 588030, 188889, 588027, 588024, 437150, 588511, 588500, 200771, 588488, 531636, 437142, 588476, 437140, 588003, 588472, 437137, 587994, 587990, 587987, 587982, 587980, 579555, 437134, 531634, 587977, 437126, 588467, 437124, 587644, 437122, 531632, 538459, 556979, 538457, 587972, 587970, 587968, 587966, 587964, 587961, 531627, 587642, 587958, 587924, 587920, 437114, 579553, 587640, 587889, 587636, 587871, 587868, 587865, 587861, 587858, 587855, 587853, 246205, 587851, 531620, 246203, 587847, 587830, 587827, 587824, 587821, 587819, 587815, 587806, 587799, 587795, 246201, 200762, 587792, 587789, 587786, 531615, 587783, 437084, 587781, 587776, 587773, 587768, 531612, 587764, 246199, 587755, 587747, 587743, 587738, 587735, 587733, 587731, 437071, 531611, 587723, 587721, 587719, 437063, 531608, 437058, 437057, 437047, 587693, 246192, 221761, 536195, 536193, 206211, 531600, 206210, 347348, 206208, 531595, 347346, 206206, 531590, 347341, 587611, 531585, 347334, 347332, 246178, 437013, 437002, 436998, 587584, 436991, 246170, 587580, 579533, 531576, 200755, 587446, 436986, 436968, 436965, 531574, 246167, 436960, 436958, 436938, 246159, 246151, 436921, 436918, 531564, 531558, 436911, 246144, 436904, 436901, 436899, 436897, 531553, 436895, 579529, 246136, 246121, 531547, 189201, 436892, 531545, 531543, 587444, 587442, 587440, 587347, 531538, 189199, 246108, 531533, 200752, 531531, 436878, 436875, 436869, 531526, 436858, 587336, 436853, 436841, 436829, 109123, 436812, 436808, 436797, 436793, 531517, 531514, 436775, 436773, 436771, 436757, 246096, 436754, 436752, 494960, 436750, 436742, 436733, 587270, 531508, 310072, 265552, 265550, 310070, 310067, 531505, 310065, 436727, 310053, 436725, 436723, 531502, 436721, 436719, 436717, 579526, 579524, 436715, 531499, 436710, 531497, 531491, 436704, 536173, 367666, 436701, 536171, 246092, 246087, 246083, 531485, 436687, 436683, 531481, 586921, 531479, 586918, 436678, 436676, 110684, 586915, 586913, 586911, 586902, 531475, 436672, 436670, 587074, 586899, 586881, 586998, 586872, 586985, 586869, 586862, 586968, 586960, 586957, 586859, 586853, 586841, 585994, 585991, 540664, 586818, 586835, 586832, 586383, 586381, 586823, 436650, 586375, 586374, 586372, 110673, 436642, 585984, 436640, 585973, 109111, 109110, 585970, 456143, 456141, 110669, 110666, 110658, 586462, 110656, 110654, 109106, 586460, 585953, 586455, 586452, 585938, 436615, 584997, 109104, 109102, 579514, 579511, 246070, 109085, 109082, 109080, 109077, 586721, 531446, 109074, 200737, 586667, 436556, 200731, 109069, 586423, 200729, 586421, 586510, 436545, 436531, 586507, 436514, 436512, 531428, 586493, 436510, 246063, 531420, 531418, 206201, 586488, 206197, 579461, 206193, 206191, 436487, 586471, 436479, 586469, 436477, 436475, 436452, 436447, 436444, 586357, 436442, 436438, 586354, 436436, 586439, 586437, 436427, 436422, 174373, 436420, 531405, 436417, 436413, 221674, 531400, 436410, 436407, 369258, 174357, 174353, 174352, 174350, 436405, 586394, 174348, 436403, 436387, 436382, 436378, 579442, 585667, 586120, 436361, 586112, 531383, 586108, 579420, 579418, 579412, 579409, 585767, 585760, 531371, 585749, 585746, 585731, 585744, 585728, 585726, 585709, 585707, 585705, 585701, 206185, 436329, 585635, 109058, 531367, 109056, 109054, 436325, 246047, 436318, 531363, 436316, 436314, 578409, 436302, 436297, 189194, 585526, 531359, 436279, 246039, 579388, 246036, 579386, 246034, 246032, 246030, 246018, 246016, 246015, 246012, 531353, 188873, 585486, 531347, 585474, 246010, 585472, 246008, 246006, 579383, 531341, 579375, 531337, 579373, 531333, 579364, 579361, 579355, 579352, 579349, 579340, 531326, 579335, 361102, 436243, 536147, 536142, 531322, 245999, 436234, 531318, 436220, 436218, 436216, 436208, 436187, 436185, 531314, 436183, 245993, 436167, 436165, 436152, 436149, 436129, 436118, 436115, 579308, 585104, 309771, 206182, 206181, 245970, 436017, 585065, 585039, 489036, 489034, 584378, 435998, 585037, 221585, 435996, 435988, 435979, 435968, 435961, 572651, 572649, 435947, 309734, 309730, 221568, 245964, 309727, 245960, 531280, 531278, 435932, 435923, 539534, 435920, 245957, 531272, 435898, 221558, 572869, 435893, 435890, 554055, 435888, 554048, 435878, 221553, 435876, 435873, 435870, 435868, 584616, 435866, 554042, 554040, 584606, 435860, 584245, 578032, 435858, 435855, 578029, 578027, 584597, 435852, 578024, 435849, 578022, 584594, 435843, 584585, 435839, 435837, 109009, 584717, 435834, 584580, 435832, 584712, 245949, 584706, 584694, 584691, 584684, 435821, 539529, 435810, 221525, 200689, 531257, 206175, 245940, 531252, 245938, 531251, 245931, 531246, 200682, 579262, 581624, 531242, 435789, 584365, 584363, 531238, 579237, 579224, 531233, 435775, 221514, 581150, 435764, 531227, 435759, 581142, 584319, 584315, 581137, 584313, 581135, 435756, 584302, 531220, 581127, 435749, 435739, 435711, 579220, 581925, 584285, 578426, 435702, 578424, 435699, 435694, 571258, 578422, 571256, 435676, 435668, 584216, 584208, 584206, 435585, 584197, 584195, 584190, 435556, 435540, 435535, 579204, 245918, 435533, 435529, 531199, 435527, 435524, 536133, 435521, 572635, 435517, 435509, 435500, 435483, 579201, 584014, 531190, 581892, 200663, 245912, 531189, 245909, 581881, 579196, 531181, 245904, 245899, 245893, 245881, 200660, 245876, 579182, 579166, 200656, 200654, 200651, 579159, 435440, 580878, 581758, 435425, 435421, 435416, 579152, 435382, 435368, 435366, 579148, 435359, 579145, 579139, 200640, 221433, 435351, 435345, 435342, 435338, 200633, 245827, 245820, 435219, 531144, 579027, 579021, 412505, 579015, 579006, 579002, 245816, 579000, 578988, 578984, 578982, 435208, 531139, 578980, 399368, 578976, 399364, 578969, 578967, 578965, 578963, 578960, 578958, 578955, 435200, 531135, 221416, 578953, 435195, 435193, 578951, 578945, 578943, 531132, 578939, 578937, 578934, 578931, 578929, 578925, 578923, 578916, 578914, 551139, 465028, 531126, 465026, 551137, 245801, 245798, 434686, 434684, 434682, 434680, 245562, 434677, 434675, 434672, 434668, 577473, 577471, 434663, 434661, 577468, 434656, 577461, 434654, 434652, 412435, 434650, 434648, 434646, 434643, 434640, 108953, 108951, 108948, 434635, 434633, 434631, 434625, 434623, 434621, 434619, 434616, 434612, 434608, 234876, 577488, 234874, 577486, 245560, 434606, 530847, 577455, 530845, 200531, 200527, 200525, 200515, 577427, 577424, 200513, 200510, 200506, 234868, 412422, 245557, 200503, 200496, 434579, 434577, 434575, 576873, 221238, 530839, 245552, 576870, 530836, 245550, 576868, 200490, 530830, 576865, 245548, 434561, 245546, 245538, 530828, 434551, 245535, 434546, 234851, 530826, 530823, 234846, 234833, 577358, 434544, 434541, 434536, 245531, 434534, 577352, 434532, 245530, 245521, 434521, 434519, 434512, 434509, 434504, 434501, 434497, 434491, 434483, 434480, 434478, 234829, 200479, 522671, 522669, 485919, 530805, 234822, 434447, 234814, 434434, 434431, 434423, 434422, 434417, 570840, 434410, 434407, 434405, 530791, 434398, 434395, 434387, 530786, 234801, 434348, 434345, 434342, 434339, 434337, 434335, 434331, 434328, 434326, 434323, 434321, 434316, 434313, 434311, 530784, 434309, 434307, 434304, 576745, 576743, 576738, 434299, 434291, 548619, 548609, 434288, 434285, 530776, 434266, 234793, 234789, 234770, 234768, 234766, 245516, 234764, 434245, 434243, 434240, 434238, 434234, 434232, 434230, 434228, 234729, 234681, 530769, 234675, 234671, 234669, 234664, 234662, 234658, 234655, 234652, 234650, 234646, 234644, 234638, 530765, 485911, 206151, 234622, 530764, 245514, 576687, 245512, 221206, 245510, 234620, 245498, 108898, 374946, 108894, 234616, 108888, 575949, 108886, 108884, 108880, 108873, 530758, 530757, 234602, 245482, 221192, 530755, 412406, 234598, 245480, 245473, 245469, 530748, 245464, 530746, 234589, 221172, 434220, 530735, 234566, 234564, 234562, 530727, 234559, 234546, 434218, 434216, 434214, 434212, 434210, 434206, 234536, 434204, 530718, 434196, 234531, 434193, 434165, 245429, 576463, 522659, 234517, 245422, 530709, 245410, 530707, 576142, 576140, 234497, 576133, 576152, 399343, 245404, 530694, 245391, 245388, 245386, 245374, 245371, 530691, 245368, 574348, 539509, 574344, 245361, 245346, 245344, 245339, 245329, 245327, 245321, 245318, 245316, 245310, 245308, 245304, 245297, 245295, 245293, 245291, 245277, 245275, 245266, 245264, 572632, 381201, 572630, 245259, 369222, 221117, 434133, 434130, 245250, 530664, 575788, 530662, 575785, 530660, 536081, 434120, 369219, 434112, 434107, 530656, 530655, 485906, 310576, 434096, 310574, 434092, 434089, 434087, 434084, 575731, 434082, 434076, 369218, 369216, 369214, 369207, 369205, 526407, 526405, 200445, 200443, 530643, 530638, 530636, 530634, 573868, 573862, 573860, 530631, 245246, 234469, 412386, 530628, 245244, 245242, 200436, 494762, 245239, 188863, 526403, 245234, 245232, 434027, 245229, 434025, 575463, 245227, 575461, 245224, 245221, 200433, 530624, 530622, 245216, 234466, 530618, 530616, 434020, 527765, 245212, 530612, 221089, 573839, 245209, 530610, 245207, 245202, 245200, 245197, 434002, 530604, 433998, 245193, 530601, 433990, 530596, 234460, 433988, 433979, 530593, 234457, 530592, 234455, 234453, 234451, 234446, 234444, 530584, 234441, 221061, 530580, 234439, 530577, 433964, 575274, 433951, 575271, 433947, 433945, 433941, 433939, 433934, 433923, 433915, 530566, 221052, 530564, 245191, 234437, 245189, 530557, 234434, 245186, 234429, 234427, 245184, 234424, 530551, 530549, 530547, 234418, 234413, 234409, 245182, 530545, 245179, 530541, 234407, 433906, 433904, 433901, 234403, 530539, 433897, 234400, 530537, 530531, 234392, 530530, 234388, 433893, 234386, 530523, 234374, 234372, 234370, 485901, 234367, 234364, 234362, 234358, 245174, 234355, 234347, 234345, 234341, 234338, 234335, 433891, 234333, 560870, 234329, 574899, 234327, 574893, 234321, 245173, 245144, 245141, 433884, 245138, 234293, 530499, 245133, 485898, 433877, 433875, 433869, 200401, 433867, 433864, 530489, 433857, 433855, 433848, 433847, 433839, 433820, 245121, 433813, 433809, 433805, 433803, 574790, 245116, 433801, 433793, 530476, 433791, 433789, 573804, 433787, 369198, 433785, 530472, 574382, 574734, 245112, 369195, 245094, 530469, 574726, 245086, 433772, 234281, 234278, 234275, 526396, 530467, 234270, 433770, 234266, 221014, 530465, 221012, 574670, 200398, 433757, 200396, 574668, 471289, 234260, 433755, 433753, 433750, 200393, 433747, 433740, 234258, 471282, 234256, 245083, 433738, 245081, 245078, 485896, 574380, 245076, 530452, 573136, 574218, 530450, 573134, 574378, 572043, 234249, 234245, 234243, 234241, 573129, 574376, 573124, 433731, 234236, 234234, 574372, 433729, 234231, 234220, 234218, 433726, 234216, 234213, 234211, 433723, 433721, 574366, 433719, 397445, 433716, 245073, 570335, 397443, 234201, 433714, 433706, 433703, 433701, 397434, 397431, 397426, 573914, 574187, 433699, 414125, 234199, 536054, 433694, 414123, 234187, 536052, 433691, 536050, 433689, 234182, 530432, 573093, 234180, 234173, 234171, 573090, 574338, 573088, 574233, 574336, 574334, 234169, 574331, 234167, 245058, 574167, 574183, 234152, 574165, 574181, 245056, 245053, 433686, 234137, 574179, 574178, 245050, 234134, 234132, 234130, 234128, 234124, 234122, 234118, 234115, 234112, 572018, 245048, 433671, 433670, 574175, 433667, 433665, 433663, 433656, 433653, 485892, 234100, 433651, 433648, 433640, 433623, 433615, 433588, 530377, 234028, 234026, 530312, 234007, 433501, 573476, 573445, 573441, 245031, 573439, 530300, 245029, 530298, 245023, 245019, 244998, 530288, 234003, 573403, 573393, 530284, 530271, 542782, 572154, 573313, 572152, 244992, 233976, 470876, 233973, 463663, 233970, 433447, 530225, 244931, 530221, 244927, 220934, 530206, 530205, 470874, 530197, 530195, 572662, 530189, 523582, 200333, 244904, 433418, 530186, 569107, 523578, 530184, 433408, 200329, 530182, 433406, 233958, 433404, 530179, 433394, 233947, 244896, 244894, 244892, 244890, 244887, 244885, 244881, 244877, 244873, 244865, 244860, 244853, 244849, 244845, 244839, 244829, 233945, 244808, 568594, 433391, 233939, 433386, 433375, 572361, 233935, 433364, 433361, 433359, 433357, 433355, 433351, 433349, 433347, 433345, 433343, 433341, 433338, 572477, 433336, 572357, 433330, 433323, 571999, 433319, 433315, 571997, 433311, 549179, 571995, 433308, 571993, 433305, 433303, 433300, 433298, 571988, 570990, 570987, 571984, 433293, 571979, 433291, 571976, 570983, 571974, 433289, 572354, 530143, 570978, 572352, 433286, 433276, 433274, 572340, 244773, 530141, 572330, 572327, 433271, 549176, 572325, 244770, 572310, 220916, 530139, 572304, 572302, 572298, 433267, 110593, 572294, 244766, 572291, 572289, 433261, 572287, 572285, 110591, 433258, 433256, 572283, 526342, 530136, 572236, 572281, 433254, 403164, 526339, 572278, 572275, 324023, 433251, 244764, 549173, 571967, 397417, 572387, 244760, 571965, 433244, 233931, 397409, 397401, 397399, 571207, 571955, 397396, 397394, 397391, 397389, 244758, 397387, 220912, 397385, 433242, 397383, 433240, 433233, 433223, 233918, 433221, 233915, 233913, 336337, 233910, 433217, 233906, 571937, 572245, 571935, 244753, 433206, 530128, 571922, 433201, 571920, 433199, 433197, 571918, 572150, 572148, 433195, 571915, 571913, 571911, 571909, 571907, 572146, 433192, 530123, 572171, 572166, 412368, 433181, 572143, 233888, 571899, 244746, 233886, 572140, 244744, 244740, 412366, 244738, 530120, 244736, 571887, 433179, 571875, 233883, 530114, 433169, 530112, 433166, 571858, 530109, 433164, 433162, 433160, 433066, 433057, 433055, 530079, 530073, 233873, 568585, 233868, 568583, 433033, 233866, 233864, 233862, 233860, 530069, 233857, 233853, 530066, 433021, 233844, 530062, 233841, 530061, 233836, 530059, 433016, 233833, 244710, 530056, 244708, 491100, 244706, 544704, 544702, 544700, 432988, 432986, 233831, 233828, 432980, 432975, 432973, 432969, 432967, 432963, 530042, 573550, 565397, 432959, 530037, 530036, 530035, 530032, 432944, 571423, 571417, 530028, 432941, 244703, 530026, 530022, 244700, 547816, 526332, 526328, 432920, 530013, 571363, 526323, 526319, 530010, 526311, 220878, 432913, 526308, 526306, 530008, 526303, 233825, 530006, 526299, 526295, 530001, 526293, 526291, 529999, 529996, 432911, 529994, 547813, 547811, 432908, 547809, 432906, 529992, 432904, 432902, 432900, 200309, 398463, 551942, 529988, 485879, 529982, 485876, 485874, 527749, 200306, 485872, 432898, 485870, 485865, 485863, 571236, 314670, 529974, 570333, 432890, 336329, 565083, 336326, 571227, 529971, 336324, 529966, 547469, 529961, 547467, 529959, 432885, 570323, 553737, 220869, 529954, 220867, 553735, 570321, 529945, 553732, 220864, 529942, 529940, 220862, 529937, 220859, 529932, 188857, 220854, 529930, 220852, 553729, 529928, 110583, 529923, 553726, 553723, 529921, 110580, 220849, 553721, 553719, 220847, 432875, 244677, 529919, 432871, 110578, 553716, 244675, 392184, 529910, 244656, 553711, 551938, 110574, 570797, 570587, 571090, 570585, 529907, 571088, 432868, 570794, 110571, 432866, 571049, 529905, 220838, 571042, 244634, 233789, 571040, 570154, 570152, 402286, 529903, 402282, 402279, 565715, 402277, 402275, 529897, 402273, 529895, 402271, 402269, 529893, 402267, 529891, 402264, 529889, 529886, 36119, 220808, 529877, 36117, 432857, 529868, 432854, 432852, 309657, 309655, 309653, 36113, 309651, 529866, 529862, 369187, 529855, 432834, 529854, 529850, 432826, 432823, 432818, 529848, 541932, 539499, 529828, 220705, 529798, 529797, 220703, 220701, 220699))
Run Time: 0.127700
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4904 | |
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 | | | | | 4904 | |
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 (35406, 35373, 35174, 35147, 35020, 34995, 34948, 34918, 34907, 34832, 34824, 34679, 34623, 34286, 34051, 33623, 33571, 33522, 33512, 33509, 33508, 33507, 33506, 33505, 33504, 33503, 33502, 33501, 33500, 33499, 33498, 33497, 33496, 33495, 33494, 33493, 33322, 30832, 30615, 30011, 29963))
Run Time: 0.002817
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 41 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0,
;=e
Run Time: 0.000271
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000530
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 215
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 158
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (120))
Run Time: 0.000703
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 158
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1717121777
Run Time: 0.000412
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` >= 1717121777)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000719
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