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.000659
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.000191
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` = '13837')
LIMIT 1
Run Time: 0.000400
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.002390
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_13837' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.144040
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 (646204, 646158, 646131, 646128, 646126, 646112, 646111, 646073, 646071, 646052, 646050, 646049, 646034, 646008, 645988, 645971, 645970, 645969, 645916, 645915, 645889, 645885, 645883, 645862, 645861, 645855, 645854, 645849, 645826, 645813, 645810, 645808, 645802, 645800, 645799, 645742, 645734, 645731, 645725, 645708, 645692, 645688, 645664, 645655, 645654, 645624, 645613, 645590, 645589, 645568, 645567, 645556, 645555, 645543, 645494, 645437, 645423, 645421, 645406, 645405, 645404, 645402, 645395, 645394, 645390, 645388, 645384, 645361, 645351, 645347, 645329, 645309, 645308, 645307, 645289, 645288, 645287, 645286, 645274, 645238, 645237, 645236, 645207, 645201, 645189, 645166, 645163, 645162, 645069, 645067, 645014, 644895, 644867, 644858, 644842, 644839, 644837, 644826, 644825, 644820, 644819, 644804, 644789, 644784, 644783, 644772, 644739, 644733, 644725, 644711, 644705, 644704, 644703, 644527, 644525, 644510, 644509, 644476, 644474, 644446, 644445, 644436, 644363, 644349, 644344, 644340, 644339, 644338, 644337, 644278, 644197, 644196, 644192, 644191, 644041, 644040, 643817, 643408, 643356, 643355, 642967, 642966, 642842, 642765, 642764, 642711, 642698, 642601, 642599, 642598, 642597, 642550, 642549, 642392, 642366, 642305, 642256, 642213, 642202, 642176, 642167, 642141, 642139, 642132, 642125, 642122, 642084, 642061, 641988, 641911, 641910, 641871, 641870, 641592, 641576, 641575, 641552, 641500, 641453, 641437, 641435, 641433, 641416, 641384, 641251, 641248, 641212, 641211, 641150, 641144, 641130, 641129, 641094, 641093, 641086, 640948, 640925, 640921, 640917, 640914, 640911, 640910, 447662, 640539, 630295, 534933, 640130, 447608, 534931, 635391, 635389, 447602, 640463, 640490, 583987, 639629, 447598, 639627, 639620, 640484, 447589, 639614, 447572, 640446, 640425, 447569, 639974, 627570, 627567, 637060, 638917, 637054, 536425, 534928, 640086, 534916, 640020, 640016, 640009, 534914, 447433, 447426, 447421, 534911, 447413, 447410, 534908, 447408, 639921, 639919, 639916, 627551, 639914, 639761, 639753, 639591, 639585, 541384, 639497, 639416, 636079, 420434, 420431, 639394, 420428, 636073, 636070, 636063, 639375, 638137, 639372, 602018, 601706, 638780, 534888, 599365, 639069, 639065, 638582, 639222, 534887, 639218, 639216, 548415, 639213, 548410, 580726, 447212, 580724, 447210, 639034, 623647, 601250, 447197, 601248, 447190, 639135, 639194, 639186, 447165, 639124, 639116, 534881, 534878, 634934, 447150, 635139, 635136, 635134, 347175, 580720, 347173, 635129, 189144, 447132, 638909, 447122, 638991, 638886, 638851, 638849, 638845, 638901, 638842, 638897, 638879, 583940, 638830, 638837, 631928, 638778, 638734, 534874, 638806, 520514, 638796, 614975, 552890, 552886, 638743, 534869, 534865, 638653, 637011, 638624, 638637, 201199, 638492, 638486, 580696, 638478, 638476, 601240, 453823, 638407, 638448, 638400, 638441, 534843, 447038, 638276, 638387, 56470, 638382, 447028, 447020, 447009, 447007, 446999, 638324, 453175, 638295, 638309, 638305, 580691, 534839, 638302, 638289, 633731, 534838, 534836, 580685, 534834, 638264, 638281, 534832, 637579, 633943, 534830, 633926, 633911, 633723, 638175, 534826, 638118, 638151, 638077, 638116, 534824, 534821, 602759, 638047, 638043, 446944, 446942, 638029, 583859, 534811, 534809, 637999, 637993, 534801, 534797, 637855, 637888, 615745, 615742, 615740, 637778, 637761, 637670, 637521, 637518, 636468, 637709, 637700, 580674, 637654, 580671, 637633, 637643, 328450, 637697, 637636, 637693, 615739, 615736, 637575, 615734, 637605, 637687, 615730, 637571, 446866, 602757, 635620, 446864, 344589, 534785, 637514, 637457, 534775, 628653, 628651, 637408, 637366, 637364, 446815, 446813, 637361, 637340, 446801, 637346, 637310, 637318, 637307, 446783, 602756, 637264, 637261, 637258, 637154, 580655, 580651, 637222, 181013, 534765, 637197, 534764, 637188, 637141, 534762, 637139, 637134, 637007, 534758, 247263, 534756, 637033, 637024, 479704, 534752, 637021, 636984, 534749, 636997, 636847, 534747, 479702, 633377, 636834, 633369, 636830, 596338, 633367, 309839, 628649, 628647, 636790, 636788, 628645, 636766, 636786, 636756, 636747, 47080, 635116, 635103, 534743, 632803, 635100, 635097, 632801, 309818, 309816, 309812, 534740, 446690, 446688, 634000, 446686, 324063, 636594, 636130, 636591, 636127, 534734, 636541, 636539, 608519, 534732, 608515, 636523, 636383, 534729, 446660, 446651, 635670, 636381, 636379, 636377, 636365, 636362, 534726, 636355, 636352, 534724, 596275, 596265, 636298, 636267, 201186, 636249, 446567, 446558, 446551, 534717, 446546, 636221, 601196, 446515, 636180, 636178, 635991, 534704, 534701, 446476, 636051, 446472, 636014, 601189, 635935, 635984, 635381, 534695, 635660, 571180, 601187, 446466, 634322, 446464, 446462, 534691, 446458, 635868, 632232, 446455, 534688, 446453, 635849, 635834, 534685, 459893, 601182, 534683, 635680, 635228, 635090, 635226, 635559, 630227, 635706, 635695, 635687, 630224, 534681, 446429, 247198, 635606, 635634, 247196, 635603, 635630, 599355, 534677, 629964, 583731, 635550, 635546, 608512, 534673, 635528, 635029, 635509, 635471, 635459, 623727, 635438, 623725, 534671, 635339, 635333, 634134, 534667, 446407, 635307, 601173, 446396, 635262, 635244, 635249, 446390, 635021, 635242, 635236, 634244, 534662, 596197, 534660, 635013, 534659, 635010, 635197, 534657, 534656, 635166, 635169, 634237, 635066, 635063, 635061, 635003, 634999, 634841, 534653, 634982, 634795, 634833, 534649, 534643, 634823, 634603, 634736, 634733, 596185, 634683, 446313, 634768, 623722, 623720, 629650, 634762, 629006, 623718, 534641, 634728, 634741, 601166, 634695, 634726, 634704, 534637, 634693, 534635, 597502, 634627, 597500, 634615, 634400, 634575, 446301, 634503, 534630, 632580, 634478, 634422, 534629, 634429, 634418, 634425, 601159, 634333, 634331, 634300, 634349, 634328, 534625, 446289, 634310, 446286, 634294, 634265, 446281, 446277, 633642, 634287, 534622, 629944, 634274, 629941, 534619, 534618, 634251, 446269, 634248, 446267, 446265, 356103, 634229, 534614, 534612, 446253, 634149, 634160, 247167, 534611, 634125, 534609, 634087, 534607, 634123, 634072, 446244, 446241, 632569, 446238, 634068, 201175, 534605, 446236, 634057, 634048, 601150, 633984, 633782, 633823, 534602, 534599, 534596, 534595, 446216, 628639, 446212, 446210, 601139, 446195, 633568, 446189, 446186, 633563, 633560, 534592, 633533, 534588, 633528, 633495, 633499, 534585, 446178, 633111, 632924, 534582, 623638, 633393, 630183, 189133, 633324, 534580, 633350, 633285, 534575, 630114, 633316, 633092, 633087, 633277, 633275, 534573, 608498, 446157, 608487, 446154, 534570, 446153, 633085, 633082, 628635, 633242, 633077, 633075, 534563, 633172, 628683, 628681, 534562, 583662, 571335, 583660, 534561, 534557, 583655, 633136, 534555, 386528, 633133, 534550, 633016, 633116, 534547, 633036, 534543, 629597, 534540, 608484, 632940, 608482, 632965, 631909, 632997, 632934, 632932, 632986, 632929, 446080, 534534, 632962, 446063, 632960, 632892, 324056, 247156, 632876, 534532, 632906, 189127, 446034, 632899, 632890, 632897, 534530, 445998, 632828, 329414, 534523, 632746, 628631, 247142, 534520, 534519, 445985, 632670, 632725, 632668, 632664, 445979, 247133, 632661, 247131, 445976, 445973, 583633, 583630, 632697, 583623, 534516, 625145, 534514, 631602, 534507, 632639, 534505, 445964, 445959, 627249, 632605, 627247, 189123, 632552, 632520, 632518, 325223, 632440, 325218, 445945, 534496, 629900, 632438, 632435, 632428, 632426, 632421, 632418, 632364, 632414, 632400, 632292, 632295, 632299, 445936, 247117, 629888, 632143, 580605, 580602, 632100, 580582, 445918, 631871, 628991, 631955, 631940, 534486, 630976, 631862, 453799, 201162, 631842, 583573, 534483, 580975, 534481, 631793, 631775, 631773, 534479, 534477, 445790, 445788, 445786, 631469, 445783, 631698, 445773, 445763, 602755, 628628, 534472, 445755, 631659, 580560, 631663, 534471, 631371, 628623, 631336, 534465, 445688, 631290, 631287, 596083, 627923, 605414, 631258, 631197, 392479, 392475, 534462, 392473, 631192, 631146, 631171, 631168, 631124, 354538, 631118, 534460, 631115, 331432, 631076, 631053, 445644, 606767, 631049, 631016, 410140, 631007, 630961, 627164, 627162, 630973, 445597, 609945, 534452, 607458, 607456, 607454, 607451, 534450, 247089, 609938, 630928, 630915, 630909, 201160, 630879, 628621, 607446, 445582, 630796, 630881, 601123, 629221, 445569, 630842, 630837, 534445, 629304, 630617, 630313, 630602, 534442, 630597, 630585, 630583, 534435, 605405, 458306, 630571, 589675, 630535, 630532, 630526, 630524, 629752, 630482, 630476, 630473, 630511, 609317, 630465, 614947, 201157, 630424, 624169, 630413, 534419, 614945, 630374, 534413, 630104, 630081, 630079, 445452, 534408, 534405, 534403, 189108, 534400, 629820, 629803, 629769, 534396, 629797, 629765, 453788, 629789, 629787, 629762, 629784, 629743, 445440, 629720, 629696, 534392, 601118, 11709, 580527, 580523, 628618, 445418, 445416, 16663, 629667, 629674, 629665, 629670, 534388, 629661, 445391, 629653, 596051, 629621, 596049, 629619, 629612, 534384, 445379, 629111, 588962, 445366, 201150, 628253, 366064, 325430, 629600, 629595, 629593, 602753, 629591, 629564, 629562, 325109, 629421, 445351, 445349, 601115, 247032, 534376, 629484, 629478, 629475, 629471, 596044, 625143, 629460, 580504, 629411, 580500, 534374, 623826, 629408, 629393, 629425, 629435, 534371, 601112, 201143, 534368, 596035, 109258, 445344, 201135, 629352, 588959, 354537, 534365, 629325, 445340, 534363, 445334, 628614, 629286, 629293, 624140, 629278, 534360, 629266, 534355, 605822, 534353, 189106, 536381, 189104, 629219, 602752, 629174, 629201, 629185, 629198, 629172, 534346, 629179, 629169, 534344, 445307, 629107, 534341, 189098, 414284, 580489, 580486, 601333, 534333, 629079, 608469, 189093, 445298, 189091, 324053, 629071, 629051, 324050, 354534, 629063, 580473, 583485, 629031, 580470, 247012, 580464, 201129, 580461, 247010, 445296, 628066, 628984, 609932, 386090, 386087, 628934, 628932, 628963, 628974, 534329, 628958, 601109, 628970, 628961, 628947, 601108, 356095, 329409, 329407, 201124, 583475, 628893, 628850, 628908, 628891, 626953, 628873, 624131, 583468, 201105, 201096, 606393, 583464, 601106, 628574, 628869, 445289, 445288, 628900, 628563, 628857, 628887, 580453, 354533, 628839, 583460, 534320, 534318, 628548, 609381, 628544, 534317, 628540, 189087, 189084, 628769, 628767, 628811, 628802, 628797, 628781, 596020, 628776, 628795, 628747, 628753, 628749, 534314, 628735, 628730, 628724, 628714, 628676, 201093, 628711, 628719, 201090, 628497, 247004, 601101, 628689, 628611, 628662, 628659, 534311, 628602, 628512, 628526, 628523, 445268, 628515, 623631, 610817, 445255, 628462, 445253, 628460, 534309, 627216, 626046, 628233, 628383, 628429, 453779, 627887, 627737, 627232, 627644, 445108, 201085, 627681, 445106, 534302, 605671, 445097, 445093, 445081, 445062, 627635, 627614, 445056, 445049, 445047, 445045, 627299, 627296, 627293, 626679, 627464, 627588, 534300, 627605, 627456, 445036, 627453, 445034, 534298, 627599, 627597, 627585, 534297, 201084, 625158, 627284, 627282, 627280, 626770, 534293, 627440, 586339, 627374, 615546, 445030, 603140, 22832, 444505, 444501, 625657, 625655, 625619, 625646, 534213, 611425, 611424, 444476, 189054, 246959, 444473, 444470, 625572, 444460, 444456, 580404, 625533, 625523, 625520, 625312, 625518, 625504, 625516, 444442, 625341, 625488, 625486, 625484, 534211, 610257, 444430, 444424, 625463, 625446, 623607, 534188, 189049, 534185, 625296, 534180, 625140, 625281, 625285, 625258, 444363, 625254, 610614, 444361, 534176, 625262, 444353, 444347, 189048, 444343, 534162, 625210, 534158, 602049, 201060, 580376, 419516, 534156, 625177, 625182, 580362, 625138, 246934, 583314, 580357, 246932, 444324, 444322, 444315, 625133, 583309, 583308, 534147, 201057, 625130, 625126, 615789, 444297, 534144, 583305, 444284, 534142, 444278, 583303, 583301, 583298, 583295, 583293, 615092, 583291, 534138, 625110, 625108, 583289, 615090, 625103, 615087, 624317, 624419, 444269, 624405, 611415, 623503, 421791, 624315, 189042, 624386, 534129, 444262, 615919, 444260, 616295, 624373, 444256, 534119, 444242, 624367, 444232, 444229, 444227, 189037, 615917, 624338, 444199, 534103, 201054, 444183, 444172, 624330, 444166, 444164, 624327, 624307, 534097, 624299, 624295, 624288, 534093, 534091, 583269, 583267, 534085, 534083, 534081, 534079, 534074, 608463, 444161, 534067, 534065, 608460, 624283, 608458, 444148, 444146, 444144, 608455, 201052, 603096, 557027, 161168, 624207, 412577, 624204, 624198, 412573, 623970, 534047, 534045, 444105, 624021, 624013, 624019, 624016, 444091, 624006, 444088, 444086, 444082, 444078, 534035, 623950, 534032, 534030, 623994, 534025, 444063, 623905, 615010, 324422, 623879, 534007, 571402, 444027, 534004, 444025, 421785, 595917, 533999, 533995, 533993, 443975, 624094, 443971, 615002, 614997, 533992, 533990, 443955, 533985, 443948, 623775, 607909, 623773, 533976, 443907, 443905, 595896, 595894, 623765, 623601, 443893, 623758, 623736, 616157, 623739, 616154, 623715, 623589, 623695, 533963, 623691, 602047, 571272, 571270, 571268, 623447, 533959, 443857, 533955, 533953, 189028, 533951, 580344, 580342, 443817, 443814, 533946, 623470, 594324, 623661, 443796, 443792, 615958, 443788, 443785, 623464, 614256, 601061, 614252, 470879, 615953, 612311, 623582, 615949, 443770, 533940, 623516, 533938, 623511, 533933, 325421, 354532, 488931, 488929, 623420, 623418, 623349, 608444, 533928, 623401, 615727, 623347, 615726, 624077, 623387, 623380, 623376, 443728, 624069, 533925, 624066, 609893, 609887, 624063, 443717, 624058, 533912, 616278, 624056, 605441, 533906, 616245, 616256, 401131, 616212, 616202, 615602, 549765, 533885, 443667, 615908, 533883, 533882, 616123, 443649, 533879, 533874, 611409, 611407, 616009, 533864, 443592, 443590, 615480, 616000, 615998, 615930, 615987, 443577, 615984, 443566, 615889, 533851, 443538, 443521, 533841, 615860, 607320, 443491, 443486, 443476, 188993, 533833, 201029, 389718, 389716, 615837, 610230, 615807, 443451, 615701, 615755, 443446, 443442, 533825, 615699, 615766, 443440, 443432, 580334, 580330, 443426, 615680, 443422, 580326, 443419, 615666, 607368, 443410, 443406, 201026, 443400, 201024, 246891, 246883, 246880, 246874, 443391, 609870, 443379, 615625, 356086, 533807, 533801, 615621, 533797, 246869, 443352, 609866, 615609, 533795, 443343, 609864, 609862, 615604, 615572, 601046, 533788, 615552, 188990, 533786, 615472, 443291, 533780, 443280, 4719, 615016, 443109, 614990, 614986, 614983, 188988, 613948, 614971, 613942, 613940, 595866, 614968, 601042, 443071, 443055, 533762, 443037, 443034, 614905, 443026, 443017, 443003, 533760, 592732, 533758, 614870, 614881, 533757, 442980, 614879, 614826, 442975, 614824, 442968, 614812, 614806, 533752, 614801, 533750, 592722, 442959, 442949, 624054, 592701, 533743, 442913, 533738, 442894, 442889, 442886, 533733, 601039, 442875, 580315, 442866, 533730, 442863, 442856, 442848, 533729, 201020, 533727, 442841, 614298, 613828, 614268, 533718, 613826, 180977, 601036, 180974, 533717, 180972, 613813, 442785, 533711, 442770, 601026, 614024, 614022, 442740, 614020, 614016, 442734, 533704, 188985, 607843, 613895, 613775, 613886, 533701, 188983, 442702, 613989, 442699, 613979, 613877, 533699, 354531, 613873, 608436, 246838, 613710, 613956, 613985, 613871, 533698, 613865, 610354, 533696, 613524, 613521, 613307, 533694, 613694, 613853, 442691, 613850, 613304, 442689, 595856, 595854, 533691, 246831, 613839, 613832, 613575, 246828, 533689, 580301, 613098, 580299, 601021, 580294, 613734, 533683, 613765, 608933, 608931, 188978, 188976, 533679, 533678, 554441, 606366, 613691, 533676, 533674, 533672, 442664, 580288, 188974, 188971, 533670, 246816, 533668, 412570, 613513, 533667, 442650, 609857, 533661, 201005, 533659, 442606, 613583, 572902, 612996, 557024, 533655, 533649, 533648, 442585, 608431, 613480, 533640, 442579, 613405, 533638, 442576, 442570, 613403, 533635, 442558, 595834, 605322, 533625, 201002, 442532, 613359, 442524, 533622, 442519, 200998, 533621, 533619, 533618, 608926, 533616, 442508, 442506, 533612, 533609, 533608, 533602, 613301, 613298, 613314, 533585, 533583, 613276, 442501, 613292, 533576, 613262, 533572, 246804, 533571, 533570, 442475, 533566, 533563, 442466, 442464, 613185, 533561, 442461, 442460, 442456, 613162, 533559, 533558, 613145, 442445, 613082, 613143, 613140, 533555, 442439, 533554, 613122, 533553, 246793, 533543, 442430, 533542, 533540, 600088, 600086, 533537, 414264, 442416, 533534, 611299, 612984, 442405, 442401, 612981, 533532, 442356, 533530, 533527, 442340, 188960, 188958, 442324, 533521, 442320, 442318, 442316, 603131, 580236, 533518, 612944, 580233, 580231, 442311, 442309, 533516, 533515, 612937, 612932, 612468, 442297, 533509, 533505, 533503, 442293, 200995, 442291, 442276, 442241, 442239, 442237, 354529, 602045, 583073, 612916, 499611, 611468, 499605, 632281, 533492, 533491, 612831, 608172, 389257, 612754, 612824, 533486, 442164, 366062, 442162, 533484, 609799, 601009, 442144, 442125, 533474, 442110, 533466, 442105, 612620, 442099, 612600, 608916, 598568, 598564, 533460, 442088, 595822, 533456, 611642, 442070, 442066, 601007, 442062, 442060, 608169, 601004, 611377, 608089, 533454, 608087, 246775, 611375, 533452, 612549, 611367, 612547, 601002, 442054, 612262, 612540, 612516, 442045, 533450, 606328, 442039, 442036, 624042, 442034, 442032, 442029, 442027, 533448, 442022, 533446, 533444, 442018, 594540, 442015, 329403, 609504, 609500, 354528, 612505, 442013, 533440, 442010, 442003, 612244, 612487, 533437, 533435, 604688, 600999, 604685, 612435, 441995, 441991, 609351, 612409, 605390, 612337, 612392, 441986, 533425, 441978, 533422, 605388, 441972, 612325, 612368, 533419, 441968, 605381, 441961, 441959, 612218, 557019, 533415, 533413, 441950, 604681, 604679, 533412, 604675, 612175, 441948, 533410, 612173, 611357, 612169, 533402, 611355, 612166, 612162, 612155, 612287, 612153, 612149, 612284, 493225, 612070, 612142, 612067, 441941, 441937, 612089, 493209, 493206, 612084, 612042, 441934, 533392, 414255, 246764, 612035, 414253, 612032, 612022, 533390, 441912, 612027, 441904, 441902, 611997, 533383, 441893, 611987, 610888, 610104, 441891, 611976, 611983, 533380, 611339, 611895, 441890, 421777, 441884, 441881, 533375, 611921, 533369, 611915, 604670, 441872, 441869, 611903, 611884, 611878, 441849, 607746, 610808, 611854, 610805, 414248, 611577, 610799, 611848, 533359, 533357, 611843, 533355, 533352, 533350, 610796, 533348, 611790, 533342, 441807, 611640, 611659, 611672, 246745, 611634, 207569, 533328, 441791, 441787, 441777, 611585, 533325, 611205, 611568, 441758, 605372, 611547, 441755, 611540, 441684, 441680, 611302, 441671, 611264, 605297, 605294, 611247, 605290, 611230, 611069, 611237, 441654, 400766, 611151, 611219, 600994, 533274, 441649, 610906, 611193, 200986, 533271, 611174, 611130, 611162, 611065, 595783, 441627, 533259, 611114, 611053, 110747, 611112, 110743, 611105, 611103, 441624, 611030, 441621, 611023, 441620, 595778, 611017, 610941, 611010, 441610, 611003, 610998, 610939, 533250, 610934, 441602, 608188, 533248, 608183, 533245, 441588, 595768, 610969, 595766, 222458, 533240, 441566, 583005, 583003, 610923, 441551, 610943, 441533, 441527, 441525, 625074, 533230, 441514, 609787, 441502, 610829, 610827, 533223, 610820, 610812, 578249, 533218, 533216, 610746, 610732, 441469, 610730, 610717, 441436, 441407, 610495, 610489, 610492, 610485, 610457, 610361, 610415, 608083, 611748, 610444, 610408, 611744, 610442, 610440, 608080, 611733, 608078, 610083, 603427, 608076, 611726, 608073, 441383, 610402, 609776, 608567, 610193, 599847, 602855, 533157, 602850, 611715, 608555, 455503, 533155, 610342, 611702, 441374, 610167, 533153, 441372, 441369, 533150, 441364, 455493, 533148, 441358, 466837, 533145, 590081, 533143, 609762, 610141, 595716, 595713, 441352, 363567, 533140, 610080, 610088, 441349, 610070, 533129, 609752, 533126, 441342, 441340, 302999, 600852, 133347, 610036, 610033, 609628, 441336, 329401, 609989, 610015, 609995, 533110, 609982, 609969, 593953, 609746, 602745, 441312, 609726, 609684, 609682, 533105, 609706, 602743, 533102, 609690, 576525, 576522, 596595, 576519, 396167, 533098, 609604, 609612, 200968, 554426, 609601, 609590, 609581, 51338, 533092, 51326, 609490, 441303, 609486, 609423, 609421, 609408, 609337, 533082, 609335, 609297, 533080, 441288, 609291, 609303, 609207, 533075, 609205, 441285, 441279, 533072, 609158, 607579, 609152, 593644, 533069, 609149, 133334, 133328, 133326, 133324, 388376, 533060, 609136, 608733, 533058, 580227, 608869, 441264, 533052, 441261, 441259, 441255, 533050, 441253, 608878, 608864, 590067, 609087, 624037, 608663, 624032, 609000, 608998, 609021, 609019, 609037, 608995, 609013, 606520, 608992, 606518, 608990, 441244, 607353, 608964, 441241, 608837, 608660, 200967, 608831, 600984, 603942, 608854, 608846, 453744, 608820, 608816, 441237, 608814, 441235, 608801, 608791, 200966, 607350, 608716, 536377, 608584, 608651, 533038, 605520, 608682, 608645, 608643, 608649, 200964, 608638, 608633, 608602, 608594, 608610, 603936, 608394, 603934, 603931, 533030, 608380, 608359, 608377, 608533, 608375, 605738, 533024, 608335, 441230, 607293, 441218, 441212, 533021, 441205, 441203, 441201, 608262, 441199, 600805, 600794, 600791, 441194, 441188, 608309, 200961, 441185, 592124, 592120, 35121, 592117, 608303, 608301, 441182, 592965, 533014, 608297, 608295, 608286, 608249, 608267, 608153, 608257, 533009, 612697, 536373, 536371, 608240, 441180, 441175, 441170, 608225, 608138, 608054, 608107, 608039, 441155, 441153, 607984, 608033, 532996, 441152, 441148, 582939, 133321, 606055, 607807, 607707, 607722, 354525, 389712, 607694, 607690, 188951, 554422, 441134, 188949, 606321, 532983, 607683, 607657, 607653, 536367, 607651, 607646, 441128, 188934, 200953, 441126, 188932, 589015, 532973, 606534, 606532, 607616, 441125, 607614, 441123, 607590, 441121, 607610, 441119, 607550, 441108, 441106, 615526, 607545, 532972, 607510, 599512, 607322, 607308, 607306, 607266, 607303, 607262, 377211, 441057, 532966, 607288, 532963, 314806, 592210, 607278, 532959, 499495, 596953, 607253, 607250, 607244, 582908, 607240, 532944, 188928, 603478, 441051, 532939, 441044, 441027, 607209, 528499, 528497, 200950, 528494, 597422, 597419, 606009, 200948, 441011, 532926, 606962, 607199, 607110, 607159, 607153, 607098, 607059, 607056, 607094, 325902, 441001, 606984, 606981, 607037, 440996, 532918, 606797, 440985, 606942, 440978, 606933, 606922, 606914, 550256, 532914, 606672, 606648, 606644, 606636, 606615, 595631, 606590, 606301, 606432, 606258, 606231, 606255, 331391, 580221, 606170, 599131, 606156, 602033, 606102, 606151, 440836, 532876, 440824, 605908, 605887, 440817, 605882, 605922, 554383, 440811, 440809, 605864, 605899, 440805, 532870, 605857, 605855, 603120, 605839, 605849, 605844, 605837, 603424, 605808, 605805, 605831, 605797, 605785, 532865, 605776, 440770, 582823, 600471, 605728, 582818, 600469, 582816, 605744, 440761, 419513, 440759, 605726, 440757, 440750, 605699, 115397, 539564, 200925, 440744, 115395, 605576, 208382, 532862, 600454, 532859, 600451, 440736, 605565, 440734, 440729, 388372, 532857, 388370, 440723, 605541, 440720, 605548, 521085, 605527, 605524, 602547, 600972, 605517, 605513, 200919, 605511, 605474, 605472, 605336, 532853, 605334, 605278, 605485, 605464, 602989, 605179, 440696, 600969, 604351, 602639, 605140, 605155, 605133, 605131, 453733, 605114, 605106, 605110, 604047, 440672, 605015, 440670, 605055, 603093, 604339, 604913, 599038, 605053, 440664, 605048, 605059, 200915, 532844, 593639, 600446, 595584, 604223, 532841, 604270, 604664, 590170, 605012, 590168, 109246, 604268, 604661, 604266, 605035, 440633, 605029, 440630, 604980, 604453, 604451, 361109, 604924, 602735, 440606, 361107, 604977, 604972, 582757, 600964, 580210, 188916, 440599, 604727, 440598, 440595, 440593, 440590, 599312, 421773, 604908, 604927, 532831, 604854, 604265, 604893, 604827, 604822, 604825, 600959, 440573, 604813, 440568, 440566, 109231, 440548, 600436, 604780, 532819, 604767, 604765, 602973, 602971, 604718, 602969, 604759, 580205, 604329, 580204, 604326, 580203, 604324, 604713, 604321, 440541, 599037, 532810, 246678, 604467, 604392, 604390, 604387, 604653, 440514, 604648, 604642, 604639, 440511, 440509, 440506, 604161, 604491, 440502, 188912, 440487, 604463, 603421, 604441, 603419, 440480, 604446, 614740, 440464, 604303, 604148, 604280, 604219, 604274, 604145, 200909, 604216, 604140, 604213, 604137, 440459, 604127, 604208, 604210, 604125, 600950, 604122, 599035, 604187, 599033, 604185, 604182, 532786, 440455, 440446, 604083, 600948, 440442, 550255, 604028, 602249, 602247, 603917, 602245, 599496, 603915, 532777, 599492, 557016, 603901, 603497, 400757, 603046, 532770, 603500, 600946, 603489, 440432, 603359, 440428, 603406, 603401, 532765, 532762, 603024, 603353, 603364, 499825, 532751, 603349, 603211, 440419, 603344, 603311, 603308, 602924, 603319, 600943, 603294, 440408, 603229, 603285, 440402, 603222, 324045, 603215, 602919, 599309, 495590, 495588, 324382, 329391, 603188, 603177, 603171, 600939, 603157, 603126, 603115, 440398, 532739, 440396, 603101, 603070, 440375, 602986, 600932, 603041, 600929, 593628, 603027, 602985, 602967, 602983, 602962, 602960, 602965, 602950, 559110, 602976, 602956, 602947, 440361, 602940, 599078, 599076, 559108, 602904, 440352, 602932, 599073, 599071, 602930, 599069, 602898, 602907, 602875, 602809, 600924, 602864, 602803, 602801, 602791, 602785, 582662, 582659, 602228, 582657, 548406, 602771, 602733, 601935, 440341, 601933, 600676, 600673, 600923, 602731, 440339, 602763, 602761, 602728, 600667, 600664, 602508, 602680, 602630, 582641, 602644, 582638, 582635, 582625, 582623, 602590, 602579, 602596, 589381, 600915, 602029, 582610, 554377, 602428, 602471, 532722, 602468, 602419, 488700, 488698, 488696, 602399, 488693, 602451, 602386, 602384, 602378, 602376, 575804, 602371, 602218, 314791, 602338, 602208, 554557, 602142, 582581, 602133, 602170, 602158, 532714, 554554, 602126, 601895, 601892, 602121, 601886, 440319, 246668, 599017, 602104, 532711, 601987, 601985, 601979, 582525, 600382, 601968, 440307, 497513, 589234, 589232, 314782, 592687, 601957, 580199, 601921, 601846, 601745, 599014, 601541, 601463, 601406, 601476, 601452, 601386, 601449, 600502, 601446, 601434, 595564, 440233, 601339, 600201, 440215, 601373, 440213, 601290, 600863, 200903, 440195, 600820, 599295, 600787, 600815, 600808, 600692, 600644, 600659, 600651, 600649, 440181, 440175, 532646, 554354, 554353, 600555, 532642, 598790, 596574, 600545, 596571, 596567, 200902, 440170, 596554, 600528, 440163, 532638, 598558, 440158, 600262, 440152, 600135, 600133, 600096, 600106, 600101, 532630, 200898, 440146, 600078, 532620, 440113, 600015, 200897, 600011, 600000, 532616, 460069, 599991, 597635, 440089, 593118, 532613, 599964, 599953, 599915, 599110, 599871, 597847, 599903, 599896, 532606, 599892, 614960, 614957, 614954, 593111, 599799, 599816, 440084, 599807, 440080, 599801, 599779, 599763, 599453, 440068, 599000, 598997, 598994, 598992, 532599, 554345, 599706, 598337, 598335, 599641, 599636, 599700, 189220, 598319, 599434, 599677, 200888, 599607, 599605, 440057, 440055, 440051, 599603, 440048, 599671, 440041, 440029, 440026, 440016, 599625, 599613, 440007, 440005, 599430, 599596, 554552, 580181, 599585, 599428, 599425, 599422, 599420, 598687, 598985, 599546, 598982, 439991, 598980, 598974, 599562, 598971, 599539, 439986, 599537, 598968, 599535, 439982, 598964, 349603, 439977, 596438, 580169, 580167, 439971, 599450, 599440, 597624, 599285, 598958, 599283, 532596, 589230, 392948, 331373, 439962, 392935, 439960, 439953, 439950, 439946, 599390, 469419, 599410, 599401, 469417, 599375, 599373, 599371, 599382, 589288, 596729, 599273, 599271, 599268, 599232, 599173, 532593, 599171, 589650, 599223, 439943, 589648, 599211, 599244, 439940, 439936, 597973, 599181, 599162, 599166, 439928, 439924, 376266, 473645, 569049, 599121, 599119, 439917, 599117, 599101, 599108, 439910, 439903, 439898, 599095, 599093, 599087, 599091, 599065, 599063, 532586, 599052, 599050, 598955, 597543, 598950, 439896, 594888, 598945, 532585, 598900, 597926, 598942, 439892, 595381, 595379, 200883, 439889, 580161, 598805, 598802, 592543, 598795, 598792, 592539, 598787, 598783, 598780, 598579, 324042, 598777, 532579, 200880, 200877, 532575, 598647, 439883, 598645, 439881, 439855, 598682, 598667, 598656, 598652, 598616, 598614, 598608, 439850, 598604, 200874, 598550, 598541, 598530, 598535, 206234, 598526, 517449, 439834, 548402, 548400, 598418, 598454, 439826, 439823, 587481, 439821, 598448, 439815, 598442, 598431, 396525, 439814, 554314, 598392, 598381, 570281, 517440, 439802, 596543, 439798, 554309, 439794, 567218, 439787, 439784, 439779, 439777, 598301, 596510, 554305, 598206, 598205, 598203, 592605, 574253, 598194, 554750, 554748, 554746, 598074, 598264, 597915, 439743, 439741, 439737, 598246, 439734, 598239, 439732, 598222, 598235, 439730, 554743, 598188, 598070, 580157, 598158, 598144, 598142, 532553, 597896, 597893, 598086, 597886, 439726, 594725, 482154, 594723, 598068, 598065, 598101, 594890, 598040, 439722, 439720, 439718, 439716, 597835, 483642, 598024, 597509, 482144, 382702, 550251, 532551, 439700, 597962, 597949, 597945, 597824, 597943, 439696, 597867, 597813, 597864, 439685, 439683, 439681, 572528, 597804, 572525, 597782, 596764, 597780, 597778, 597761, 597705, 597756, 439665, 597688, 597686, 597677, 596435, 597644, 439652, 439651, 439649, 597601, 595066, 591112, 439623, 439620, 439618, 597586, 597576, 439604, 439601, 439596, 439590, 597526, 595147, 597495, 597492, 597490, 597337, 386060, 597475, 596762, 596761, 133283, 597341, 580154, 597374, 597302, 439534, 596487, 596760, 596758, 597044, 597155, 597095, 597106, 597101, 590859, 597029, 597049, 597026, 597036, 597002, 590857, 597013, 596843, 596841, 439496, 439493, 596996, 596981, 596974, 596967, 596959, 596757, 439424, 596753, 596751, 562800, 596824, 596869, 596818, 532513, 596814, 439412, 491112, 596790, 491110, 596746, 596743, 491105, 439406, 596742, 596736, 594351, 439401, 596719, 596658, 625066, 596655, 596653, 581341, 596635, 581339, 596633, 596645, 420972, 532500, 420965, 596631, 596623, 596620, 439386, 596610, 589213, 589211, 595366, 532495, 595360, 581324, 595354, 581317, 595352, 596428, 596425, 595342, 439349, 439339, 439336, 581308, 581302, 581300, 581292, 595299, 595296, 581282, 581279, 581275, 594527, 594622, 439330, 594613, 595267, 594611, 439328, 439321, 595251, 582346, 595249, 595246, 595047, 532490, 206221, 439307, 595037, 595035, 595122, 595088, 133268, 595011, 595017, 595015, 595009, 595003, 523620, 592974, 594972, 532482, 594964, 594962, 439287, 439283, 594908, 532477, 594898, 594856, 594752, 532475, 594852, 594517, 594874, 594811, 582305, 594843, 594837, 594831, 594865, 622925, 594862, 594826, 594796, 536339, 594809, 594805, 594813, 594746, 594788, 594608, 594786, 13460, 582299, 582294, 594580, 594549, 594546, 527962, 373424, 532456, 585298, 591018, 594507, 591015, 593579, 589644, 589636, 593975, 439258, 439256, 532441, 594285, 594311, 594294, 594306, 532433, 582266, 582264, 439145, 593966, 593962, 593909, 593848, 593820, 439117, 593817, 593839, 593576, 591881, 593574, 593611, 532415, 593429, 593569, 593421, 439048, 593534, 590720, 593517, 593512, 593323, 593509, 585518, 575329, 593410, 593407, 330534, 521680, 532396, 589802, 590716, 590714, 532387, 580113, 591607, 593066, 593031, 592976, 568656, 592909, 592896, 592645, 439029, 614708, 614706, 532342, 592757, 592752, 439013, 592621, 592269, 592454, 592433, 532285, 438895, 438891, 532278, 591869, 591887, 591703, 591068, 554276, 527947, 585090, 367721, 527943, 527941, 527939, 591629, 591604, 532261, 591602, 575357, 527906, 591600, 532254, 591443, 591598, 532248, 532245, 625056, 561631, 110711, 539549, 532242, 527859, 485994, 532240, 591548, 532237, 591545, 438859, 527853, 580098, 367719, 527847, 438854, 532235, 527844, 532231, 453722, 527839, 527836, 589532, 589530, 532220, 367716, 591377, 591375, 589937, 589935, 356065, 554270, 324377, 324374, 532212, 532207, 438816, 438814, 438812, 438809, 109198, 591369, 590710, 536317, 345573, 532171, 133243, 591298, 590854, 591296, 591272, 591290, 591269, 540670, 200836, 532140, 438728, 438727, 591249, 221905, 591246, 367707, 591239, 591237, 591235, 517417, 517415, 532134, 591187, 591167, 517412, 517410, 517408, 517405, 591165, 591003, 532125, 438630, 438625, 532093, 589924, 438438, 554232, 438433, 438429, 481825, 590363, 481815, 590325, 481813, 481812, 481809, 531985, 481806, 481804, 521082, 590322, 590314, 590312, 367694, 501840, 531946, 590270, 576513, 531934, 324040, 324038, 576509, 531865, 531853, 590019, 473625, 324036, 366056, 570191, 531819, 589569, 589567, 246268, 586362, 156918, 156917, 156915, 221806))
Run Time: 0.181081
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4087 | |
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 | | | | | 4087 | |
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 (35148, 34921, 34920, 34844, 34810, 34784, 34677, 34657, 34640, 34562, 34551, 34426, 34368, 34330, 34296, 34081, 34046, 33989, 33841, 33822, 33805, 33804, 33803, 33765, 33737, 33724, 33713, 33603, 33249, 33240, 33239, 33190, 33187, 33173, 33135, 33134, 33099, 33090, 33089, 33015, 32997, 32972, 32857, 32800, 32758, 32737, 32720, 32658, 32623, 32596, 32550, 32549, 32548, 32547, 32513, 32498, 32469, 32375, 32265, 32251, 32241, 32224, 32222, 32220, 32197, 32173, 32167, 32158, 32107, 32093, 32088, 32050, 32035, 32032, 32030, 31988, 31983, 31971, 31928, 31885, 31869, 31848, 31794, 31793, 31792, 31727, 31717, 31703, 31693, 31690, 31598, 31566, 31555, 31498, 31421, 31417, 31413, 31374, 31365, 31333, 31330, 31306, 31215, 31211, 31203, 31114, 31113, 31002, 30970, 30934, 30903, 30902, 30852))
Run Time: 0.008122
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 113 | 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 (646204, 646158, 646131, 646128, 646126, 646112, 646111, 646073, 646071, 646052, 646050, 646049, 646034, 646008, 645988, 645971, 645970, 645969, 645916, 645915, 645889, 645885, 645883, 645862, 645861, 645855, 645854, 645849, 645826, 645813, 645810, 645808, 645802, 645800, 645799, 645742, 645734, 645731, 645725, 645708, 645692, 645688, 645664, 645655, 645654, 645624, 645613, 645590, 645589, 645568, 645567, 645556, 645555, 645543, 645494, 645437, 645423, 645421, 645406, 645405, 645404, 645402, 645395, 645394, 645390, 645388, 645384, 645361, 645351, 645347, 645329, 645309, 645308, 645307, 645289, 645288, 645287, 645286, 645274, 645238, 645237, 645236, 645207, 645201, 645189, 645166, 645163, 645162, 645069, 645067, 645014, 644895, 644867, 644858, 644842, 644839, 644837, 644826, 644825, 644820, 644819, 644804, 644789, 644784, 644783, 644772, 644739, 644733, 644725, 644711, 644705, 644704, 644703, 644527, 644525, 644510, 644509, 644476, 644474, 644446, 644445, 644436, 644363, 644349, 644344, 644340, 644339, 644338, 644337, 644278, 644197, 644196, 644192, 644191, 644041, 644040, 643817, 643408, 643356, 643355, 642967, 642966, 642842, 642765, 642764, 642711, 642698, 642601, 642599, 642598, 642597, 642550, 642549, 642392, 642366, 642305, 642256, 642213, 642202, 642176, 642167, 642141, 642139, 642132, 642125, 642122, 642084, 642061, 641988, 641911, 641910, 641871, 641870, 641592, 641576, 641575, 641552, 641500, 641453, 641437, 641435, 641433, 641416, 641384, 641251, 641248, 641212, 641211, 641150, 641144, 641130, 641129, 641094, 641093, 641086, 640948, 640925, 640921, 640917, 640914, 640911, 640910, 447662, 640539, 630295, 534933, 640130, 447608, 534931, 635391, 635389, 447602, 640463, 640490, 583987, 639629, 447598, 639627, 639620, 640484, 447589, 639614, 447572, 640446, 640425, 447569, 639974, 627570, 627567, 637060, 638917, 637054, 536425, 534928, 640086, 534916, 640020, 640016, 640009, 534914, 447433, 447426, 447421, 534911, 447413, 447410, 534908, 447408, 639921, 639919, 639916, 627551, 639914, 639761, 639753, 639591, 639585, 541384, 639497, 639416, 636079, 420434, 420431, 639394, 420428, 636073, 636070, 636063, 639375, 638137, 639372, 602018, 601706, 638780, 534888, 599365, 639069, 639065, 638582, 639222, 534887, 639218, 639216, 548415, 639213, 548410, 580726, 447212, 580724, 447210, 639034, 623647, 601250, 447197, 601248, 447190, 639135, 639194, 639186, 447165, 639124, 639116, 534881, 534878, 634934, 447150, 635139, 635136, 635134, 347175, 580720, 347173, 635129, 189144, 447132, 638909, 447122, 638991, 638886, 638851, 638849, 638845, 638901, 638842, 638897, 638879, 583940, 638830, 638837, 631928, 638778, 638734, 534874, 638806, 520514, 638796, 614975, 552890, 552886, 638743, 534869, 534865, 638653, 637011, 638624, 638637, 201199, 638492, 638486, 580696, 638478, 638476, 601240, 453823, 638407, 638448, 638400, 638441, 534843, 447038, 638276, 638387, 56470, 638382, 447028, 447020, 447009, 447007, 446999, 638324, 453175, 638295, 638309, 638305, 580691, 534839, 638302, 638289, 633731, 534838, 534836, 580685, 534834, 638264, 638281, 534832, 637579, 633943, 534830, 633926, 633911, 633723, 638175, 534826, 638118, 638151, 638077, 638116, 534824, 534821, 602759, 638047, 638043, 446944, 446942, 638029, 583859, 534811, 534809, 637999, 637993, 534801, 534797, 637855, 637888, 615745, 615742, 615740, 637778, 637761, 637670, 637521, 637518, 636468, 637709, 637700, 580674, 637654, 580671, 637633, 637643, 328450, 637697, 637636, 637693, 615739, 615736, 637575, 615734, 637605, 637687, 615730, 637571, 446866, 602757, 635620, 446864, 344589, 534785, 637514, 637457, 534775, 628653, 628651, 637408, 637366, 637364, 446815, 446813, 637361, 637340, 446801, 637346, 637310, 637318, 637307, 446783, 602756, 637264, 637261, 637258, 637154, 580655, 580651, 637222, 181013, 534765, 637197, 534764, 637188, 637141, 534762, 637139, 637134, 637007, 534758, 247263, 534756, 637033, 637024, 479704, 534752, 637021, 636984, 534749, 636997, 636847, 534747, 479702, 633377, 636834, 633369, 636830, 596338, 633367, 309839, 628649, 628647, 636790, 636788, 628645, 636766, 636786, 636756, 636747, 47080, 635116, 635103, 534743, 632803, 635100, 635097, 632801, 309818, 309816, 309812, 534740, 446690, 446688, 634000, 446686, 324063, 636594, 636130, 636591, 636127, 534734, 636541, 636539, 608519, 534732, 608515, 636523, 636383, 534729, 446660, 446651, 635670, 636381, 636379, 636377, 636365, 636362, 534726, 636355, 636352, 534724, 596275, 596265, 636298, 636267, 201186, 636249, 446567, 446558, 446551, 534717, 446546, 636221, 601196, 446515, 636180, 636178, 635991, 534704, 534701, 446476, 636051, 446472, 636014, 601189, 635935, 635984, 635381, 534695, 635660, 571180, 601187, 446466, 634322, 446464, 446462, 534691, 446458, 635868, 632232, 446455, 534688, 446453, 635849, 635834, 534685, 459893, 601182, 534683, 635680, 635228, 635090, 635226, 635559, 630227, 635706, 635695, 635687, 630224, 534681, 446429, 247198, 635606, 635634, 247196, 635603, 635630, 599355, 534677, 629964, 583731, 635550, 635546, 608512, 534673, 635528, 635029, 635509, 635471, 635459, 623727, 635438, 623725, 534671, 635339, 635333, 634134, 534667, 446407, 635307, 601173, 446396, 635262, 635244, 635249, 446390, 635021, 635242, 635236, 634244, 534662, 596197, 534660, 635013, 534659, 635010, 635197, 534657, 534656, 635166, 635169, 634237, 635066, 635063, 635061, 635003, 634999, 634841, 534653, 634982, 634795, 634833, 534649, 534643, 634823, 634603, 634736, 634733, 596185, 634683, 446313, 634768, 623722, 623720, 629650, 634762, 629006, 623718, 534641, 634728, 634741, 601166, 634695, 634726, 634704, 534637, 634693, 534635, 597502, 634627, 597500, 634615, 634400, 634575, 446301, 634503, 534630, 632580, 634478, 634422, 534629, 634429, 634418, 634425, 601159, 634333, 634331, 634300, 634349, 634328, 534625, 446289, 634310, 446286, 634294, 634265, 446281, 446277, 633642, 634287, 534622, 629944, 634274, 629941, 534619, 534618, 634251, 446269, 634248, 446267, 446265, 356103, 634229, 534614, 534612, 446253, 634149, 634160, 247167, 534611, 634125, 534609, 634087, 534607, 634123, 634072, 446244, 446241, 632569, 446238, 634068, 201175, 534605, 446236, 634057, 634048, 601150, 633984, 633782, 633823, 534602, 534599, 534596, 534595, 446216, 628639, 446212, 446210, 601139, 446195, 633568, 446189, 446186, 633563, 633560, 534592, 633533, 534588, 633528, 633495, 633499, 534585, 446178, 633111, 632924, 534582, 623638, 633393, 630183, 189133, 633324, 534580, 633350, 633285, 534575, 630114, 633316, 633092, 633087, 633277, 633275, 534573, 608498, 446157, 608487, 446154, 534570, 446153, 633085, 633082, 628635, 633242, 633077, 633075, 534563, 633172, 628683, 628681, 534562, 583662, 571335, 583660, 534561, 534557, 583655, 633136, 534555, 386528, 633133, 534550, 633016, 633116, 534547, 633036, 534543, 629597, 534540, 608484, 632940, 608482, 632965, 631909, 632997, 632934, 632932, 632986, 632929, 446080, 534534, 632962, 446063, 632960, 632892, 324056, 247156, 632876, 534532, 632906, 189127, 446034, 632899, 632890, 632897, 534530, 445998, 632828, 329414, 534523, 632746, 628631, 247142, 534520, 534519, 445985, 632670, 632725, 632668, 632664, 445979, 247133, 632661, 247131, 445976, 445973, 583633, 583630, 632697, 583623, 534516, 625145, 534514, 631602, 534507, 632639, 534505, 445964, 445959, 627249, 632605, 627247, 189123, 632552, 632520, 632518, 325223, 632440, 325218, 445945, 534496, 629900, 632438, 632435, 632428, 632426, 632421, 632418, 632364, 632414, 632400, 632292, 632295, 632299, 445936, 247117, 629888, 632143, 580605, 580602, 632100, 580582, 445918, 631871, 628991, 631955, 631940, 534486, 630976, 631862, 453799, 201162, 631842, 583573, 534483, 580975, 534481, 631793, 631775, 631773, 534479, 534477, 445790, 445788, 445786, 631469, 445783, 631698, 445773, 445763, 602755, 628628, 534472, 445755, 631659, 580560, 631663, 534471, 631371, 628623, 631336, 534465, 445688, 631290, 631287, 596083, 627923, 605414, 631258, 631197, 392479, 392475, 534462, 392473, 631192, 631146, 631171, 631168, 631124, 354538, 631118, 534460, 631115, 331432, 631076, 631053, 445644, 606767, 631049, 631016, 410140, 631007, 630961, 627164, 627162, 630973, 445597, 609945, 534452, 607458, 607456, 607454, 607451, 534450, 247089, 609938, 630928, 630915, 630909, 201160, 630879, 628621, 607446, 445582, 630796, 630881, 601123, 629221, 445569, 630842, 630837, 534445, 629304, 630617, 630313, 630602, 534442, 630597, 630585, 630583, 534435, 605405, 458306, 630571, 589675, 630535, 630532, 630526, 630524, 629752, 630482, 630476, 630473, 630511, 609317, 630465, 614947, 201157, 630424, 624169, 630413, 534419, 614945, 630374, 534413, 630104, 630081, 630079, 445452, 534408, 534405, 534403, 189108, 534400, 629820, 629803, 629769, 534396, 629797, 629765, 453788, 629789, 629787, 629762, 629784, 629743, 445440, 629720, 629696, 534392, 601118, 11709, 580527, 580523, 628618, 445418, 445416, 16663, 629667, 629674, 629665, 629670, 534388, 629661, 445391, 629653, 596051, 629621, 596049, 629619, 629612, 534384, 445379, 629111, 588962, 445366, 201150, 628253, 366064, 325430, 629600, 629595, 629593, 602753, 629591, 629564, 629562, 325109, 629421, 445351, 445349, 601115, 247032, 534376, 629484, 629478, 629475, 629471, 596044, 625143, 629460, 580504, 629411, 580500, 534374, 623826, 629408, 629393, 629425, 629435, 534371, 601112, 201143, 534368, 596035, 109258, 445344, 201135, 629352, 588959, 354537, 534365, 629325, 445340, 534363, 445334, 628614, 629286, 629293, 624140, 629278, 534360, 629266, 534355, 605822, 534353, 189106, 536381, 189104, 629219, 602752, 629174, 629201, 629185, 629198, 629172, 534346, 629179, 629169, 534344, 445307, 629107, 534341, 189098, 414284, 580489, 580486, 601333, 534333, 629079, 608469, 189093, 445298, 189091, 324053, 629071, 629051, 324050, 354534, 629063, 580473, 583485, 629031, 580470, 247012, 580464, 201129, 580461, 247010, 445296, 628066, 628984, 609932, 386090, 386087, 628934, 628932, 628963, 628974, 534329, 628958, 601109, 628970, 628961, 628947, 601108, 356095, 329409, 329407, 201124, 583475, 628893, 628850, 628908, 628891, 626953, 628873, 624131, 583468, 201105, 201096, 606393, 583464, 601106, 628574, 628869, 445289, 445288, 628900, 628563, 628857, 628887, 580453, 354533, 628839, 583460, 534320, 534318, 628548, 609381, 628544, 534317, 628540, 189087, 189084, 628769, 628767, 628811, 628802, 628797, 628781, 596020, 628776, 628795, 628747, 628753, 628749, 534314, 628735, 628730, 628724, 628714, 628676, 201093, 628711, 628719, 201090, 628497, 247004, 601101, 628689, 628611, 628662, 628659, 534311, 628602, 628512, 628526, 628523, 445268, 628515, 623631, 610817, 445255, 628462, 445253, 628460, 534309, 627216, 626046, 628233, 628383, 628429, 453779, 627887, 627737, 627232, 627644, 445108, 201085, 627681, 445106, 534302, 605671, 445097, 445093, 445081, 445062, 627635, 627614, 445056, 445049, 445047, 445045, 627299, 627296, 627293, 626679, 627464, 627588, 534300, 627605, 627456, 445036, 627453, 445034, 534298, 627599, 627597, 627585, 534297, 201084, 625158, 627284, 627282, 627280, 626770, 534293, 627440, 586339, 627374, 615546, 445030, 603140, 22832, 444505, 444501, 625657, 625655, 625619, 625646, 534213, 611425, 611424, 444476, 189054, 246959, 444473, 444470, 625572, 444460, 444456, 580404, 625533, 625523, 625520, 625312, 625518, 625504, 625516, 444442, 625341, 625488, 625486, 625484, 534211, 610257, 444430, 444424, 625463, 625446, 623607, 534188, 189049, 534185, 625296, 534180, 625140, 625281, 625285, 625258, 444363, 625254, 610614, 444361, 534176, 625262, 444353, 444347, 189048, 444343, 534162, 625210, 534158, 602049, 201060, 580376, 419516, 534156, 625177, 625182, 580362, 625138, 246934, 583314, 580357, 246932, 444324, 444322, 444315, 625133, 583309, 583308, 534147, 201057, 625130, 625126, 615789, 444297, 534144, 583305, 444284, 534142, 444278, 583303, 583301, 583298, 583295, 583293, 615092, 583291, 534138, 625110, 625108, 583289, 615090, 625103, 615087, 624317, 624419, 444269, 624405, 611415, 623503, 421791, 624315, 189042, 624386, 534129, 444262, 615919, 444260, 616295, 624373, 444256, 534119, 444242, 624367, 444232, 444229, 444227, 189037, 615917, 624338, 444199, 534103, 201054, 444183, 444172, 624330, 444166, 444164, 624327, 624307, 534097, 624299, 624295, 624288, 534093, 534091, 583269, 583267, 534085, 534083, 534081, 534079, 534074, 608463, 444161, 534067, 534065, 608460, 624283, 608458, 444148, 444146, 444144, 608455, 201052, 603096, 557027, 161168, 624207, 412577, 624204, 624198, 412573, 623970, 534047, 534045, 444105, 624021, 624013, 624019, 624016, 444091, 624006, 444088, 444086, 444082, 444078, 534035, 623950, 534032, 534030, 623994, 534025, 444063, 623905, 615010, 324422, 623879, 534007, 571402, 444027, 534004, 444025, 421785, 595917, 533999, 533995, 533993, 443975, 624094, 443971, 615002, 614997, 533992, 533990, 443955, 533985, 443948, 623775, 607909, 623773, 533976, 443907, 443905, 595896, 595894, 623765, 623601, 443893, 623758, 623736, 616157, 623739, 616154, 623715, 623589, 623695, 533963, 623691, 602047, 571272, 571270, 571268, 623447, 533959, 443857, 533955, 533953, 189028, 533951, 580344, 580342, 443817, 443814, 533946, 623470, 594324, 623661, 443796, 443792, 615958, 443788, 443785, 623464, 614256, 601061, 614252, 470879, 615953, 612311, 623582, 615949, 443770, 533940, 623516, 533938, 623511, 533933, 325421, 354532, 488931, 488929, 623420, 623418, 623349, 608444, 533928, 623401, 615727, 623347, 615726, 624077, 623387, 623380, 623376, 443728, 624069, 533925, 624066, 609893, 609887, 624063, 443717, 624058, 533912, 616278, 624056, 605441, 533906, 616245, 616256, 401131, 616212, 616202, 615602, 549765, 533885, 443667, 615908, 533883, 533882, 616123, 443649, 533879, 533874, 611409, 611407, 616009, 533864, 443592, 443590, 615480, 616000, 615998, 615930, 615987, 443577, 615984, 443566, 615889, 533851, 443538, 443521, 533841, 615860, 607320, 443491, 443486, 443476, 188993, 533833, 201029, 389718, 389716, 615837, 610230, 615807, 443451, 615701, 615755, 443446, 443442, 533825, 615699, 615766, 443440, 443432, 580334, 580330, 443426, 615680, 443422, 580326, 443419, 615666, 607368, 443410, 443406, 201026, 443400, 201024, 246891, 246883, 246880, 246874, 443391, 609870, 443379, 615625, 356086, 533807, 533801, 615621, 533797, 246869, 443352, 609866, 615609, 533795, 443343, 609864, 609862, 615604, 615572, 601046, 533788, 615552, 188990, 533786, 615472, 443291, 533780, 443280, 4719, 615016, 443109, 614990, 614986, 614983, 188988, 613948, 614971, 613942, 613940, 595866, 614968, 601042, 443071, 443055, 533762, 443037, 443034, 614905, 443026, 443017, 443003, 533760, 592732, 533758, 614870, 614881, 533757, 442980, 614879, 614826, 442975, 614824, 442968, 614812, 614806, 533752, 614801, 533750, 592722, 442959, 442949, 624054, 592701, 533743, 442913, 533738, 442894, 442889, 442886, 533733, 601039, 442875, 580315, 442866, 533730, 442863, 442856, 442848, 533729, 201020, 533727, 442841, 614298, 613828, 614268, 533718, 613826, 180977, 601036, 180974, 533717, 180972, 613813, 442785, 533711, 442770, 601026, 614024, 614022, 442740, 614020, 614016, 442734, 533704, 188985, 607843, 613895, 613775, 613886, 533701, 188983, 442702, 613989, 442699, 613979, 613877, 533699, 354531, 613873, 608436, 246838, 613710, 613956, 613985, 613871, 533698, 613865, 610354, 533696, 613524, 613521, 613307, 533694, 613694, 613853, 442691, 613850, 613304, 442689, 595856, 595854, 533691, 246831, 613839, 613832, 613575, 246828, 533689, 580301, 613098, 580299, 601021, 580294, 613734, 533683, 613765, 608933, 608931, 188978, 188976, 533679, 533678, 554441, 606366, 613691, 533676, 533674, 533672, 442664, 580288, 188974, 188971, 533670, 246816, 533668, 412570, 613513, 533667, 442650, 609857, 533661, 201005, 533659, 442606, 613583, 572902, 612996, 557024, 533655, 533649, 533648, 442585, 608431, 613480, 533640, 442579, 613405, 533638, 442576, 442570, 613403, 533635, 442558, 595834, 605322, 533625, 201002, 442532, 613359, 442524, 533622, 442519, 200998, 533621, 533619, 533618, 608926, 533616, 442508, 442506, 533612, 533609, 533608, 533602, 613301, 613298, 613314, 533585, 533583, 613276, 442501, 613292, 533576, 613262, 533572, 246804, 533571, 533570, 442475, 533566, 533563, 442466, 442464, 613185, 533561, 442461, 442460, 442456, 613162, 533559, 533558, 613145, 442445, 613082, 613143, 613140, 533555, 442439, 533554, 613122, 533553, 246793, 533543, 442430, 533542, 533540, 600088, 600086, 533537, 414264, 442416, 533534, 611299, 612984, 442405, 442401, 612981, 533532, 442356, 533530, 533527, 442340, 188960, 188958, 442324, 533521, 442320, 442318, 442316, 603131, 580236, 533518, 612944, 580233, 580231, 442311, 442309, 533516, 533515, 612937, 612932, 612468, 442297, 533509, 533505, 533503, 442293, 200995, 442291, 442276, 442241, 442239, 442237, 354529, 602045, 583073, 612916, 499611, 611468, 499605, 632281, 533492, 533491, 612831, 608172, 389257, 612754, 612824, 533486, 442164, 366062, 442162, 533484, 609799, 601009, 442144, 442125, 533474, 442110, 533466, 442105, 612620, 442099, 612600, 608916, 598568, 598564, 533460, 442088, 595822, 533456, 611642, 442070, 442066, 601007, 442062, 442060, 608169, 601004, 611377, 608089, 533454, 608087, 246775, 611375, 533452, 612549, 611367, 612547, 601002, 442054, 612262, 612540, 612516, 442045, 533450, 606328, 442039, 442036, 624042, 442034, 442032, 442029, 442027, 533448, 442022, 533446, 533444, 442018, 594540, 442015, 329403, 609504, 609500, 354528, 612505, 442013, 533440, 442010, 442003, 612244, 612487, 533437, 533435, 604688, 600999, 604685, 612435, 441995, 441991, 609351, 612409, 605390, 612337, 612392, 441986, 533425, 441978, 533422, 605388, 441972, 612325, 612368, 533419, 441968, 605381, 441961, 441959, 612218, 557019, 533415, 533413, 441950, 604681, 604679, 533412, 604675, 612175, 441948, 533410, 612173, 611357, 612169, 533402, 611355, 612166, 612162, 612155, 612287, 612153, 612149, 612284, 493225, 612070, 612142, 612067, 441941, 441937, 612089, 493209, 493206, 612084, 612042, 441934, 533392, 414255, 246764, 612035, 414253, 612032, 612022, 533390, 441912, 612027, 441904, 441902, 611997, 533383, 441893, 611987, 610888, 610104, 441891, 611976, 611983, 533380, 611339, 611895, 441890, 421777, 441884, 441881, 533375, 611921, 533369, 611915, 604670, 441872, 441869, 611903, 611884, 611878, 441849, 607746, 610808, 611854, 610805, 414248, 611577, 610799, 611848, 533359, 533357, 611843, 533355, 533352, 533350, 610796, 533348, 611790, 533342, 441807, 611640, 611659, 611672, 246745, 611634, 207569, 533328, 441791, 441787, 441777, 611585, 533325, 611205, 611568, 441758, 605372, 611547, 441755, 611540, 441684, 441680, 611302, 441671, 611264, 605297, 605294, 611247, 605290, 611230, 611069, 611237, 441654, 400766, 611151, 611219, 600994, 533274, 441649, 610906, 611193, 200986, 533271, 611174, 611130, 611162, 611065, 595783, 441627, 533259, 611114, 611053, 110747, 611112, 110743, 611105, 611103, 441624, 611030, 441621, 611023, 441620, 595778, 611017, 610941, 611010, 441610, 611003, 610998, 610939, 533250, 610934, 441602, 608188, 533248, 608183, 533245, 441588, 595768, 610969, 595766, 222458, 533240, 441566, 583005, 583003, 610923, 441551, 610943, 441533, 441527, 441525, 625074, 533230, 441514, 609787, 441502, 610829, 610827, 533223, 610820, 610812, 578249, 533218, 533216, 610746, 610732, 441469, 610730, 610717, 441436, 441407, 610495, 610489, 610492, 610485, 610457, 610361, 610415, 608083, 611748, 610444, 610408, 611744, 610442, 610440, 608080, 611733, 608078, 610083, 603427, 608076, 611726, 608073, 441383, 610402, 609776, 608567, 610193, 599847, 602855, 533157, 602850, 611715, 608555, 455503, 533155, 610342, 611702, 441374, 610167, 533153, 441372, 441369, 533150, 441364, 455493, 533148, 441358, 466837, 533145, 590081, 533143, 609762, 610141, 595716, 595713, 441352, 363567, 533140, 610080, 610088, 441349, 610070, 533129, 609752, 533126, 441342, 441340, 302999, 600852, 133347, 610036, 610033, 609628, 441336, 329401, 609989, 610015, 609995, 533110, 609982, 609969, 593953, 609746, 602745, 441312, 609726, 609684, 609682, 533105, 609706, 602743, 533102, 609690, 576525, 576522, 596595, 576519, 396167, 533098, 609604, 609612, 200968, 554426, 609601, 609590, 609581, 51338, 533092, 51326, 609490, 441303, 609486, 609423, 609421, 609408, 609337, 533082, 609335, 609297, 533080, 441288, 609291, 609303, 609207, 533075, 609205, 441285, 441279, 533072, 609158, 607579, 609152, 593644, 533069, 609149, 133334, 133328, 133326, 133324, 388376, 533060, 609136, 608733, 533058, 580227, 608869, 441264, 533052, 441261, 441259, 441255, 533050, 441253, 608878, 608864, 590067, 609087, 624037, 608663, 624032, 609000, 608998, 609021, 609019, 609037, 608995, 609013, 606520, 608992, 606518, 608990, 441244, 607353, 608964, 441241, 608837, 608660, 200967, 608831, 600984, 603942, 608854, 608846, 453744, 608820, 608816, 441237, 608814, 441235, 608801, 608791, 200966, 607350, 608716, 536377, 608584, 608651, 533038, 605520, 608682, 608645, 608643, 608649, 200964, 608638, 608633, 608602, 608594, 608610, 603936, 608394, 603934, 603931, 533030, 608380, 608359, 608377, 608533, 608375, 605738, 533024, 608335, 441230, 607293, 441218, 441212, 533021, 441205, 441203, 441201, 608262, 441199, 600805, 600794, 600791, 441194, 441188, 608309, 200961, 441185, 592124, 592120, 35121, 592117, 608303, 608301, 441182, 592965, 533014, 608297, 608295, 608286, 608249, 608267, 608153, 608257, 533009, 612697, 536373, 536371, 608240, 441180, 441175, 441170, 608225, 608138, 608054, 608107, 608039, 441155, 441153, 607984, 608033, 532996, 441152, 441148, 582939, 133321, 606055, 607807, 607707, 607722, 354525, 389712, 607694, 607690, 188951, 554422, 441134, 188949, 606321, 532983, 607683, 607657, 607653, 536367, 607651, 607646, 441128, 188934, 200953, 441126, 188932, 589015, 532973, 606534, 606532, 607616, 441125, 607614, 441123, 607590, 441121, 607610, 441119, 607550, 441108, 441106, 615526, 607545, 532972, 607510, 599512, 607322, 607308, 607306, 607266, 607303, 607262, 377211, 441057, 532966, 607288, 532963, 314806, 592210, 607278, 532959, 499495, 596953, 607253, 607250, 607244, 582908, 607240, 532944, 188928, 603478, 441051, 532939, 441044, 441027, 607209, 528499, 528497, 200950, 528494, 597422, 597419, 606009, 200948, 441011, 532926, 606962, 607199, 607110, 607159, 607153, 607098, 607059, 607056, 607094, 325902, 441001, 606984, 606981, 607037, 440996, 532918, 606797, 440985, 606942, 440978, 606933, 606922, 606914, 550256, 532914, 606672, 606648, 606644, 606636, 606615, 595631, 606590, 606301, 606432, 606258, 606231, 606255, 331391, 580221, 606170, 599131, 606156, 602033, 606102, 606151, 440836, 532876, 440824, 605908, 605887, 440817, 605882, 605922, 554383, 440811, 440809, 605864, 605899, 440805, 532870, 605857, 605855, 603120, 605839, 605849, 605844, 605837, 603424, 605808, 605805, 605831, 605797, 605785, 532865, 605776, 440770, 582823, 600471, 605728, 582818, 600469, 582816, 605744, 440761, 419513, 440759, 605726, 440757, 440750, 605699, 115397, 539564, 200925, 440744, 115395, 605576, 208382, 532862, 600454, 532859, 600451, 440736, 605565, 440734, 440729, 388372, 532857, 388370, 440723, 605541, 440720, 605548, 521085, 605527, 605524, 602547, 600972, 605517, 605513, 200919, 605511, 605474, 605472, 605336, 532853, 605334, 605278, 605485, 605464, 602989, 605179, 440696, 600969, 604351, 602639, 605140, 605155, 605133, 605131, 453733, 605114, 605106, 605110, 604047, 440672, 605015, 440670, 605055, 603093, 604339, 604913, 599038, 605053, 440664, 605048, 605059, 200915, 532844, 593639, 600446, 595584, 604223, 532841, 604270, 604664, 590170, 605012, 590168, 109246, 604268, 604661, 604266, 605035, 440633, 605029, 440630, 604980, 604453, 604451, 361109, 604924, 602735, 440606, 361107, 604977, 604972, 582757, 600964, 580210, 188916, 440599, 604727, 440598, 440595, 440593, 440590, 599312, 421773, 604908, 604927, 532831, 604854, 604265, 604893, 604827, 604822, 604825, 600959, 440573, 604813, 440568, 440566, 109231, 440548, 600436, 604780, 532819, 604767, 604765, 602973, 602971, 604718, 602969, 604759, 580205, 604329, 580204, 604326, 580203, 604324, 604713, 604321, 440541, 599037, 532810, 246678, 604467, 604392, 604390, 604387, 604653, 440514, 604648, 604642, 604639, 440511, 440509, 440506, 604161, 604491, 440502, 188912, 440487, 604463, 603421, 604441, 603419, 440480, 604446, 614740, 440464, 604303, 604148, 604280, 604219, 604274, 604145, 200909, 604216, 604140, 604213, 604137, 440459, 604127, 604208, 604210, 604125, 600950, 604122, 599035, 604187, 599033, 604185, 604182, 532786, 440455, 440446, 604083, 600948, 440442, 550255, 604028, 602249, 602247, 603917, 602245, 599496, 603915, 532777, 599492, 557016, 603901, 603497, 400757, 603046, 532770, 603500, 600946, 603489, 440432, 603359, 440428, 603406, 603401, 532765, 532762, 603024, 603353, 603364, 499825, 532751, 603349, 603211, 440419, 603344, 603311, 603308, 602924, 603319, 600943, 603294, 440408, 603229, 603285, 440402, 603222, 324045, 603215, 602919, 599309, 495590, 495588, 324382, 329391, 603188, 603177, 603171, 600939, 603157, 603126, 603115, 440398, 532739, 440396, 603101, 603070, 440375, 602986, 600932, 603041, 600929, 593628, 603027, 602985, 602967, 602983, 602962, 602960, 602965, 602950, 559110, 602976, 602956, 602947, 440361, 602940, 599078, 599076, 559108, 602904, 440352, 602932, 599073, 599071, 602930, 599069, 602898, 602907, 602875, 602809, 600924, 602864, 602803, 602801, 602791, 602785, 582662, 582659, 602228, 582657, 548406, 602771, 602733, 601935, 440341, 601933, 600676, 600673, 600923, 602731, 440339, 602763, 602761, 602728, 600667, 600664, 602508, 602680, 602630, 582641, 602644, 582638, 582635, 582625, 582623, 602590, 602579, 602596, 589381, 600915, 602029, 582610, 554377, 602428, 602471, 532722, 602468, 602419, 488700, 488698, 488696, 602399, 488693, 602451, 602386, 602384, 602378, 602376, 575804, 602371, 602218, 314791, 602338, 602208, 554557, 602142, 582581, 602133, 602170, 602158, 532714, 554554, 602126, 601895, 601892, 602121, 601886, 440319, 246668, 599017, 602104, 532711, 601987, 601985, 601979, 582525, 600382, 601968, 440307, 497513, 589234, 589232, 314782, 592687, 601957, 580199, 601921, 601846, 601745, 599014, 601541, 601463, 601406, 601476, 601452, 601386, 601449, 600502, 601446, 601434, 595564, 440233, 601339, 600201, 440215, 601373, 440213, 601290, 600863, 200903, 440195, 600820, 599295, 600787, 600815, 600808, 600692, 600644, 600659, 600651, 600649, 440181, 440175, 532646, 554354, 554353, 600555, 532642, 598790, 596574, 600545, 596571, 596567, 200902, 440170, 596554, 600528, 440163, 532638, 598558, 440158, 600262, 440152, 600135, 600133, 600096, 600106, 600101, 532630, 200898, 440146, 600078, 532620, 440113, 600015, 200897, 600011, 600000, 532616, 460069, 599991, 597635, 440089, 593118, 532613, 599964, 599953, 599915, 599110, 599871, 597847, 599903, 599896, 532606, 599892, 614960, 614957, 614954, 593111, 599799, 599816, 440084, 599807, 440080, 599801, 599779, 599763, 599453, 440068, 599000, 598997, 598994, 598992, 532599, 554345, 599706, 598337, 598335, 599641, 599636, 599700, 189220, 598319, 599434, 599677, 200888, 599607, 599605, 440057, 440055, 440051, 599603, 440048, 599671, 440041, 440029, 440026, 440016, 599625, 599613, 440007, 440005, 599430, 599596, 554552, 580181, 599585, 599428, 599425, 599422, 599420, 598687, 598985, 599546, 598982, 439991, 598980, 598974, 599562, 598971, 599539, 439986, 599537, 598968, 599535, 439982, 598964, 349603, 439977, 596438, 580169, 580167, 439971, 599450, 599440, 597624, 599285, 598958, 599283, 532596, 589230, 392948, 331373, 439962, 392935, 439960, 439953, 439950, 439946, 599390, 469419, 599410, 599401, 469417, 599375, 599373, 599371, 599382, 589288, 596729, 599273, 599271, 599268, 599232, 599173, 532593, 599171, 589650, 599223, 439943, 589648, 599211, 599244, 439940, 439936, 597973, 599181, 599162, 599166, 439928, 439924, 376266, 473645, 569049, 599121, 599119, 439917, 599117, 599101, 599108, 439910, 439903, 439898, 599095, 599093, 599087, 599091, 599065, 599063, 532586, 599052, 599050, 598955, 597543, 598950, 439896, 594888, 598945, 532585, 598900, 597926, 598942, 439892, 595381, 595379, 200883, 439889, 580161, 598805, 598802, 592543, 598795, 598792, 592539, 598787, 598783, 598780, 598579, 324042, 598777, 532579, 200880, 200877, 532575, 598647, 439883, 598645, 439881, 439855, 598682, 598667, 598656, 598652, 598616, 598614, 598608, 439850, 598604, 200874, 598550, 598541, 598530, 598535, 206234, 598526, 517449, 439834, 548402, 548400, 598418, 598454, 439826, 439823, 587481, 439821, 598448, 439815, 598442, 598431, 396525, 439814, 554314, 598392, 598381, 570281, 517440, 439802, 596543, 439798, 554309, 439794, 567218, 439787, 439784, 439779, 439777, 598301, 596510, 554305, 598206, 598205, 598203, 592605, 574253, 598194, 554750, 554748, 554746, 598074, 598264, 597915, 439743, 439741, 439737, 598246, 439734, 598239, 439732, 598222, 598235, 439730, 554743, 598188, 598070, 580157, 598158, 598144, 598142, 532553, 597896, 597893, 598086, 597886, 439726, 594725, 482154, 594723, 598068, 598065, 598101, 594890, 598040, 439722, 439720, 439718, 439716, 597835, 483642, 598024, 597509, 482144, 382702, 550251, 532551, 439700, 597962, 597949, 597945, 597824, 597943, 439696, 597867, 597813, 597864, 439685, 439683, 439681, 572528, 597804, 572525, 597782, 596764, 597780, 597778, 597761, 597705, 597756, 439665, 597688, 597686, 597677, 596435, 597644, 439652, 439651, 439649, 597601, 595066, 591112, 439623, 439620, 439618, 597586, 597576, 439604, 439601, 439596, 439590, 597526, 595147, 597495, 597492, 597490, 597337, 386060, 597475, 596762, 596761, 133283, 597341, 580154, 597374, 597302, 439534, 596487, 596760, 596758, 597044, 597155, 597095, 597106, 597101, 590859, 597029, 597049, 597026, 597036, 597002, 590857, 597013, 596843, 596841, 439496, 439493, 596996, 596981, 596974, 596967, 596959, 596757, 439424, 596753, 596751, 562800, 596824, 596869, 596818, 532513, 596814, 439412, 491112, 596790, 491110, 596746, 596743, 491105, 439406, 596742, 596736, 594351, 439401, 596719, 596658, 625066, 596655, 596653, 581341, 596635, 581339, 596633, 596645, 420972, 532500, 420965, 596631, 596623, 596620, 439386, 596610, 589213, 589211, 595366, 532495, 595360, 581324, 595354, 581317, 595352, 596428, 596425, 595342, 439349, 439339, 439336, 581308, 581302, 581300, 581292, 595299, 595296, 581282, 581279, 581275, 594527, 594622, 439330, 594613, 595267, 594611, 439328, 439321, 595251, 582346, 595249, 595246, 595047, 532490, 206221, 439307, 595037, 595035, 595122, 595088, 133268, 595011, 595017, 595015, 595009, 595003, 523620, 592974, 594972, 532482, 594964, 594962, 439287, 439283, 594908, 532477, 594898, 594856, 594752, 532475, 594852, 594517, 594874, 594811, 582305, 594843, 594837, 594831, 594865, 622925, 594862, 594826, 594796, 536339, 594809, 594805, 594813, 594746, 594788, 594608, 594786, 13460, 582299, 582294, 594580, 594549, 594546, 527962, 373424, 532456, 585298, 591018, 594507, 591015, 593579, 589644, 589636, 593975, 439258, 439256, 532441, 594285, 594311, 594294, 594306, 532433, 582266, 582264, 439145, 593966, 593962, 593909, 593848, 593820, 439117, 593817, 593839, 593576, 591881, 593574, 593611, 532415, 593429, 593569, 593421, 439048, 593534, 590720, 593517, 593512, 593323, 593509, 585518, 575329, 593410, 593407, 330534, 521680, 532396, 589802, 590716, 590714, 532387, 580113, 591607, 593066, 593031, 592976, 568656, 592909, 592896, 592645, 439029, 614708, 614706, 532342, 592757, 592752, 439013, 592621, 592269, 592454, 592433, 532285, 438895, 438891, 532278, 591869, 591887, 591703, 591068, 554276, 527947, 585090, 367721, 527943, 527941, 527939, 591629, 591604, 532261, 591602, 575357, 527906, 591600, 532254, 591443, 591598, 532248, 532245, 625056, 561631, 110711, 539549, 532242, 527859, 485994, 532240, 591548, 532237, 591545, 438859, 527853, 580098, 367719, 527847, 438854, 532235, 527844, 532231, 453722, 527839, 527836, 589532, 589530, 532220, 367716, 591377, 591375, 589937, 589935, 356065, 554270, 324377, 324374, 532212, 532207, 438816, 438814, 438812, 438809, 109198, 591369, 590710, 536317, 345573, 532171, 133243, 591298, 590854, 591296, 591272, 591290, 591269, 540670, 200836, 532140, 438728, 438727, 591249, 221905, 591246, 367707, 591239, 591237, 591235, 517417, 517415, 532134, 591187, 591167, 517412, 517410, 517408, 517405, 591165, 591003, 532125, 438630, 438625, 532093, 589924, 438438, 554232, 438433, 438429, 481825, 590363, 481815, 590325, 481813, 481812, 481809, 531985, 481806, 481804, 521082, 590322, 590314, 590312, 367694, 501840, 531946, 590270, 576513, 531934, 324040, 324038, 576509, 531865, 531853, 590019, 473625, 324036, 366056, 570191, 531819, 589569, 589567, 246268, 586362, 156918, 156917, 156915, 221806))
Run Time: 0.092795
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4087 | |
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 | | | | | 4087 | |
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 (35148, 34921, 34920, 34844, 34810, 34784, 34677, 34657, 34640, 34562, 34551, 34426, 34368, 34330, 34296, 34081, 34046, 33989, 33841, 33822, 33805, 33804, 33803, 33765, 33737, 33724, 33713, 33603, 33249, 33240, 33239, 33190, 33187, 33173, 33135, 33134, 33099, 33090, 33089, 33015, 32997, 32972, 32857, 32800, 32758, 32737, 32720, 32658, 32623, 32596, 32550, 32549, 32548, 32547, 32513, 32498, 32469, 32375, 32265, 32251, 32241, 32224, 32222, 32220, 32197, 32173, 32167, 32158, 32107, 32093, 32088, 32050, 32035, 32032, 32030, 31988, 31983, 31971, 31928, 31885, 31869, 31848, 31794, 31793, 31792, 31727, 31717, 31703, 31693, 31690, 31598, 31566, 31555, 31498, 31421, 31417, 31413, 31374, 31365, 31333, 31330, 31306, 31215, 31211, 31203, 31114, 31113, 31002, 30970, 30934, 30903, 30902, 30852))
Run Time: 0.005133
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 113 | 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, �G�
Run Time: 0.000289
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: �G�, XF\Pub\Controller\Member, RecentContent, valid, user_id=13837, 1716180354, , 0, �G�
Run Time: 0.000316
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000461
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 215
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (120))
Run Time: 0.000500
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1716180054
Run Time: 0.000358
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 17 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
- XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Repository/SessionActivity.php at line 62
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*, `xf_user_User_1`.*
FROM `xf_session_activity`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1716180054)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000578
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 17 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | my_webapp.xf_session_activity.user_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivity.php at line 43
- XF\Repository\SessionActivity->getOnlineUsersList() in src/XF/Repository/SessionActivity.php at line 63
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20