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.000797
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.000406
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` = '3584')
LIMIT 1
Run Time: 0.000718
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.003031
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_3584' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.145297
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_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 (33567, 33077, 32195, 30529, 30045, 29488, 29198, 28503, 28464, 28377, 28205, 27789, 27496, 26860, 25457, 24801, 24783, 24722, 24619, 24592, 24409, 24407, 24262, 24211, 22925, 22859, 22843, 22836, 22739, 22562, 22418, 22155, 22154, 22138, 22130, 21913, 21902, 21873, 21677, 21465, 21302, 21170, 21169, 21164, 21149, 20915, 20772, 20747, 20561, 20534, 20384, 20323, 20299, 20077, 20019, 19982, 19838, 19754, 19629, 19627, 19624, 19580, 19488, 19427, 19090, 18272, 18085, 18059, 18056, 18010, 18000, 17939, 17910, 17909, 17907, 17889, 17756, 17726, 17597, 17563, 17448, 17430, 17429, 17390, 17135, 16952, 16800, 16789, 16739, 16723, 16663, 16566, 16461, 16410, 16368, 16337, 16296, 16245, 16244, 16195, 16151, 16124, 16111, 16034, 16001, 15818, 15795))
Run Time: 0.012820
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 107 | 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 (606966, 336718, 533888, 443683, 615934, 443583, 443581, 615988, 443579, 615925, 533860, 615488, 615503, 443240, 533777, 615484, 443222, 443219, 443217, 443211, 613578, 614101, 610868, 610573, 533196, 533194, 610570, 441422, 441420, 441415, 533190, 533188, 533186, 441413, 533184, 609781, 533172, 609778, 589969, 584551, 343199, 531104, 573629, 433426, 573624, 573617, 548266, 549663, 432879, 549661, 560752, 432723, 569424, 569825, 336316, 336311, 569823, 560748, 565222, 565234, 565115, 565337, 564928, 564925, 564860, 432011, 554668, 554666, 493702, 554664, 133095, 431980, 563702, 562221, 562219, 333859, 333857, 333852, 333850, 333848, 551561, 547912, 557962, 200218, 529185, 551556, 430993, 555349, 555343, 555295, 555235, 354494, 554802, 554629, 552564, 552562, 551931, 552507, 544231, 303386, 552250, 303383, 430702, 430698, 552205, 552171, 552119, 552160, 450388, 289782, 289779, 289777, 552100, 552147, 552117, 552111, 405778, 355904, 355903, 333804, 333802, 333799, 529071, 551928, 551923, 551921, 551919, 551917, 549077, 549069, 549066, 549052, 551623, 549043, 549040, 549027, 549025, 551514, 551553, 551551, 551548, 355901, 551509, 548238, 543631, 545146, 544662, 544660, 542833, 542831, 544381, 542828, 429736, 542826, 542823, 511002, 543577, 518979, 542818, 542816, 429582, 542813, 543514, 542811, 542809, 542807, 542895, 542804, 542802, 542798, 429263, 457637, 485595, 232509, 538575, 538573, 199887, 199875, 521294, 427853, 108425, 325050, 505189, 427592, 380427, 448815, 510083, 510070, 510067, 510110, 509913, 333697, 509196, 509193, 411934, 402726, 333686, 333680, 427107, 199618, 333676, 427082, 385881, 385879, 427074, 460848, 614579, 614577, 508273, 460846, 614574, 614571, 385876, 385874, 385873, 330279, 309286, 460844, 460842, 460840, 505734, 309235, 309233, 325400, 413771, 426834, 505178, 426659, 426628, 108279, 426555, 426489, 493446, 199461, 337017, 380371, 426248, 500907, 500905, 337014, 337012, 309005, 337010, 500050, 337008, 242996, 337006, 325837, 483203, 483202, 231426, 501163, 325007, 242991, 231423, 500900, 500879, 500873, 500871, 500867, 500865, 108225, 500049, 500861, 500856, 242966, 231302, 426119, 426117, 499308, 499306, 426114, 426107, 426104, 426102, 426100, 426097, 426092, 386276, 184559, 184556, 368197, 333656, 496112, 496108, 496103, 496100, 496089, 496082, 496073, 171816, 425901, 425894, 425890, 425885, 425879, 199375, 495607, 493915, 333648, 493911, 496071, 493903, 639871, 455363, 425864, 495666, 495664, 495661, 425847, 199358, 494039, 492460, 492270, 199275, 492232, 411797, 492140, 492148, 491006, 491209, 492094, 491798, 491796, 492008, 492005, 492003, 217843, 425617, 491668, 491664, 230907, 476837, 199257, 425578, 491270, 425576, 199255, 217807, 425570, 491379, 491377, 399263, 356368, 356366, 491235, 491233, 491230, 491228, 132721, 354209, 354207, 490883, 425526, 490087, 199239, 489015, 489013, 425513, 490881, 490084, 490878, 471930, 471927, 484215, 490082, 490045, 490043, 490866, 490863, 199234, 207530, 230868, 488164, 490466, 489930, 489949, 490376, 490308, 425499, 199231, 490124, 230826, 199229, 230823, 490068, 489920, 472587, 242676, 489201, 267668, 320977, 489871, 489779, 199226, 336269, 336266, 336263, 336261, 489744, 489148, 380337, 489742, 380335, 489758, 380332, 242666, 489727, 489740, 320973, 489738, 425482, 489605, 199220, 199219, 487826, 380329, 308925, 308916, 489231, 489228, 489225, 489223, 485159, 230791, 230789, 488778, 380327, 320949, 380325, 488949, 230786, 488366, 409162, 305711, 488981, 488767, 488360, 489062, 354452, 488758, 489060, 488578, 488576, 488754, 488979, 425447, 354448, 488985, 476258, 391725, 489056, 380322, 488977, 488991, 489004, 488885, 217746, 488973, 385855, 217744, 488358, 199213, 386169, 488873, 488353, 425436, 488237, 199209, 488749, 355860, 488508, 349111, 488492, 487126, 336258, 488485, 488228, 488225, 488223, 487124, 425415, 108051, 408787, 308869, 308866, 308863, 308858, 487095, 217704, 305705, 488214, 488211, 488209, 217692, 488117, 199197, 230779, 230777, 487975, 488081, 408048, 337564, 487972, 488096, 488094, 488075, 488071, 488068, 425381, 249705, 488038, 488007, 421751, 199190, 199188, 487843, 199186, 487880, 425319, 486686, 486682, 380311, 487877, 108033, 108031, 217646, 401309, 402703, 487580, 485145, 485143, 447760, 425269, 485138, 484862, 487407, 408125, 487404, 484859, 484857, 487401, 487119, 487561, 487558, 487115, 487111, 453444, 487538, 199165, 487536, 425255, 425251, 425249, 314421, 425245, 486043, 486981, 230706, 486954, 487034, 486950, 453440, 453438, 486947, 487086, 487031, 487084, 425230, 425227, 421851, 421847, 486998, 484163, 58635, 58633, 58631, 58629, 380301, 425190, 484159, 462138, 486434, 380285, 486283, 486333, 486281, 486278, 199102, 484089, 484042, 414331, 230609, 230607, 230605, 618493, 230601, 230599, 483947, 483902, 242483, 483717, 483714, 483243, 483705, 199090, 470835, 483236, 483233, 425100, 482822, 217539, 482778, 482761, 330200, 217537, 482759, 482525, 199057, 425047, 475311, 475307, 230260, 456125, 380238, 380236, 475186, 475045, 475043, 424525, 469476, 241970, 241963, 241959, 468766, 367145, 468582, 355833, 468554, 468463, 320753, 241739, 465536, 465534, 464357, 463028, 333608, 456116, 333606, 413084, 333604, 459696, 465513, 465511, 324894, 333601, 375040, 465047, 198542, 464413, 457616, 464537, 457614, 464532, 464530, 403927, 464894, 464913, 323489, 464911, 464926, 464908, 205637, 464625, 241719, 216824, 411670, 456112, 463992, 324891, 333598, 396437, 216814, 464759, 241714, 463139, 463890, 464219, 463982, 464201, 463980, 463402, 463965, 413746, 463387, 408045, 323483, 460988, 460985, 460983, 399927, 463377, 460980, 460977, 463373, 107694, 463370, 461686, 463368, 463366, 463364, 463362, 459694, 455091, 461422, 460975, 463175, 320713, 320711, 463173, 402694, 380233, 380232, 417719, 462130, 402669, 462427, 107684, 107681, 107679, 198463, 462128, 463135, 463132, 463128, 463124, 413743, 324289, 354151, 461694, 461640, 461691, 461528, 461637, 216747, 424008, 461364, 461362, 461478, 461360, 459597, 461516, 461243, 198416, 423998, 460959, 461216, 461213, 423991, 461109, 320684, 241577, 241575, 324880, 460683, 460168, 460838, 198403, 460166, 423918, 336227, 456768, 336217, 456766, 458203, 458841, 458839, 458201, 458896, 241495, 198326, 458731, 229720, 458445, 423889, 458343, 458341, 198310, 458308, 458195, 458226, 458193, 458282, 324869, 458112, 368080, 457802, 216643, 456101, 368078, 355818, 396429, 396428, 451148, 457177, 380216, 457598, 457260, 259364, 457399, 457057, 457055, 457053, 457019, 423873, 457017, 456990, 456986, 241436, 415183, 456974, 408775, 456657, 423864, 241410, 456755, 387042, 456632, 355813, 132301, 456484, 355812, 355811, 456526, 456478, 336213, 380203, 385832, 455739, 455715, 455737, 455711, 455734, 455519, 455215, 392557, 417101, 417098, 229581, 417096, 417094, 423836, 417092, 423831, 454131, 455068, 455038, 454967, 132273, 454126, 324849, 336209, 241317, 454355, 454530, 161834, 216522, 336206, 336204, 336202, 454121, 453986, 406585, 453977, 453975, 380192, 205546, 320651, 452036, 452034, 451470, 453965, 453962, 241284, 241281, 151573, 453835, 198173, 388116, 448418, 388113, 450681, 388110, 453245, 411653, 216485, 391722, 453243, 453238, 341109, 391720, 453289, 453235, 453233, 452236, 453068, 453192, 453066, 324843, 452230, 452596, 198166, 198163, 452996, 452762, 198157, 198152, 452760, 241253, 320643, 452633, 452632, 365166, 241247, 451560, 241237, 452453, 452601, 452451, 451252, 451250, 451248, 407165, 107526, 198143, 107524, 414806, 107520, 330121, 107518, 330120, 107516, 377254, 414800, 406576, 422294, 452322, 229516, 452253, 452251, 452089, 452248, 402957, 452158, 452217, 452086, 452052, 452047, 452082, 380180, 265480, 452068, 452043, 451426, 355800, 451905, 451423, 451763, 355798, 107502, 360399, 241217, 241215, 451418, 241213, 229485, 355796, 355794, 229480, 451820, 229475, 355790, 414787, 451691, 414781, 451699, 451436, 324830, 451697, 451695, 449547, 188729, 241176, 449545, 451552, 451413, 451410, 451408, 107493, 451402, 451400, 451397, 451392, 229470, 229468, 451389, 241173, 241171, 241169, 241167, 324829, 451434, 451328, 451326, 229466, 451387, 451375, 451373, 188726, 188724, 188722, 451384, 451371, 451369, 451222, 451366, 188720, 451316, 188718, 451337, 451313, 451324, 188716, 451311, 451285, 451282, 324827, 451278, 367100, 324825, 450183, 241154, 320613, 451176, 451113, 450167, 355788, 241132, 285505, 393033, 393031, 393029, 450016, 450013, 216387, 333568, 420867, 333563, 416690, 198063, 449347, 448701, 449496, 449494, 448697, 449491, 355783, 241104, 355782, 417268, 216366, 241102, 448689, 448231, 449253, 449229, 323452, 241099, 449168, 241096, 449312, 449422, 449420, 449062, 449323, 449060, 449318, 449305, 449302, 229379, 229377, 229374, 449057, 216343, 449100, 449054, 412843, 449052, 449235, 449043, 418908, 418906, 241079, 448876, 216313, 411628, 448443, 448221, 448313, 325804, 447848, 448121, 308794, 308791, 308788, 448202, 198030, 198028, 448421, 448297, 448154, 448398, 448286, 448282, 448280, 423577, 448394, 448385, 448184, 448267, 448240, 448345, 378016, 448172, 229339, 383272, 229337, 447792, 448137, 229335, 614480, 614478, 447916, 423733, 447914, 423731, 423687, 380132, 216297, 447836, 216295, 240988, 447832, 447825, 240980, 380119, 229226, 229224, 362706, 422327, 229222, 380116, 229215, 423615, 423613, 216271, 423589, 423587, 421305, 423584, 423581, 409762, 614467, 421302, 323447, 423530, 423514, 423501, 380114, 423433, 423087, 423085, 421819, 423175, 423081, 423079, 423171, 423227, 423167, 423160, 396141, 423378, 107386, 423376, 423373, 396139, 380110, 380107, 380105, 393023, 422723, 380103, 423067, 320571, 423138, 229191, 333557, 240925, 421707, 320568, 333555, 423005, 240923, 380098, 423000, 422571, 422998, 422566, 422763, 380095, 320542, 422319, 229144, 416679, 229141, 229140, 380087, 229131, 416672, 362926, 132232, 197967, 240890, 422097, 422220, 132215, 416667, 355776, 422217, 422162, 240877, 421723, 421593, 421591, 421584, 421232, 419680, 408231, 240865, 240863, 408229, 421537, 229097, 421528, 419678, 419676, 421418, 421525, 421523, 421230, 419674, 420892, 421005, 362921, 421320, 420040, 420038, 421223, 349374, 421008, 197940, 420920, 369035, 420849, 420847, 420884, 420882, 420880, 420878, 420876, 419707, 407153, 420130, 420126, 420016, 419990, 407148, 407144, 419668, 419554, 419550, 419547, 419539, 419537, 419534, 419528, 419523, 229051, 419493, 229046, 419490, 240780, 419488, 419362, 216181, 419384, 419411, 419406, 419357, 419355, 419282, 411070, 411068, 411601, 419200, 380070, 418162, 411594, 380067, 418723, 380059, 418647, 254092, 418637, 417134, 380057, 418527, 414326, 414323, 418576, 418560, 333544, 333541, 413733, 417198, 418018, 364822, 418219, 364820, 418272, 416796, 418270, 364818, 380048, 417647, 380043, 617322, 417604, 417642, 417640, 417636, 229012, 407141, 417602, 417600, 380039, 417598, 417415, 229010, 417595, 417593, 417591, 395943, 417588, 417539, 216118, 417585, 407137, 416290, 417349, 417342, 617302, 617300, 417207, 229002, 416118, 132157, 415890, 417127, 416897, 228995, 228993, 617289, 228991, 417067, 228988, 228986, 415180, 417119, 417114, 417104, 415887, 417076, 417063, 416923, 216092, 416921, 415175, 416892, 228981, 415171, 228979, 417071, 380037, 617281, 412840, 416184, 416917, 416182, 308784, 417008, 415150, 410976, 417006, 417004, 413731, 369026, 380032, 416360, 380030, 413730, 413728, 415750, 416788, 416665, 240648, 240645, 416693, 416533, 240641, 416617, 410845, 416010, 416008, 416521, 416519, 216072, 416453, 416451, 416496, 416424, 398939, 416168, 416281, 416279, 416277, 393289, 411562, 406645, 416275, 416267, 415883, 416266, 416264, 415880, 416262, 415876, 228919, 416259, 415873, 416139, 412911, 412908, 415747, 416082, 416032, 413375, 413372, 385822, 385820, 385817, 415741, 414539, 216062, 414537, 415832, 385814, 323426, 416006, 415863, 415826, 415859, 415824, 415847, 415822, 415733, 415797, 415779, 412905, 228901, 415588, 415789, 228898, 415687, 414711, 414708, 415616, 415614, 413549, 415509, 361603, 414531, 415606, 415573, 415124, 364814, 413727, 414683, 380028, 414681, 380026, 414672, 413990, 414695, 414668, 414665, 197793, 197791, 413678, 414630, 414004, 414627, 413724, 414619, 413722, 414616, 414523, 380021, 240544, 414488, 343444, 414486, 413459, 414315, 414484, 413714, 414002, 414309, 414306, 413981, 216010, 161830, 161827, 414426, 413975, 413707, 396135, 414304, 413705, 413701, 413698, 413994, 413695, 414339, 414337, 413495, 413971, 413969, 413836, 413693, 413833, 413831, 380018, 380016, 216004, 413491, 413672, 413564, 380014, 413635, 353043, 353042, 252762, 215982, 315693, 369402, 315689, 413552, 376799, 215976, 413366, 411264, 355750, 397809, 404150, 413361, 412837, 197773, 380011, 413028, 228838, 413355, 228834, 409536, 413319, 413384, 413352, 413317, 413350, 413315, 240503, 413140, 412675, 413126, 413124, 411221, 411219, 404090, 411216, 240480, 404088, 404086, 380003, 617205, 413101, 404084, 380001, 412834, 413076, 240478, 412832, 404082, 398364, 412830, 385806, 367084, 411487, 408034, 161825, 410734, 215908, 410888, 411139, 411023, 411102, 385801, 320468, 411099, 385799, 410725, 410999, 385797, 410723, 411045, 408596, 408594, 411019, 355745, 410882, 410718, 410711, 410992, 410990, 405291, 410987, 639785, 410705, 409744, 410957, 410961, 410600, 410691, 396403, 396400, 410315, 407134, 410561, 407131, 324776, 285494, 379987, 407557, 379985, 379983, 407555, 407551, 379981, 379979, 407126, 410519, 410584, 408579, 407118, 215873, 410557, 362273, 410492, 410205, 410303, 228704, 410299, 240386, 357422, 107160, 394816, 407116, 357420, 240357, 240353, 228680, 410058, 410136, 396395, 410134, 396393, 408738, 407548, 357418, 240330, 240327, 240324, 409961, 215830, 215828, 409843, 409724, 320448, 409578, 320441, 215820, 409670, 409631, 240316, 409593, 197689, 409369, 197675, 406297, 409365, 409440, 215782, 401266, 197673, 408875, 409431, 409429, 408009, 409301, 409297, 409346, 409281, 408997, 409204, 409223, 215773, 215770, 409220, 409112, 409196, 197664, 402247, 409070, 215765, 408988, 408982, 405409, 228594, 407995, 215759, 408732, 188703, 197656, 228587, 408976, 408970, 408946, 355735, 408936, 408934, 408928, 228560, 228551, 228546, 228541, 228540, 379976, 228528, 188700, 408825, 408823, 408852, 408821, 408819, 240238, 240236, 240233, 240231, 240229, 240227, 240225, 408846, 240219, 407110, 197634, 240199, 408380, 315687, 408377, 240178, 404995, 408368, 240176, 408478, 240170, 228487, 407883, 407881, 408136, 407970, 407879, 407872, 197598, 407919, 215689, 407829, 407897, 368064, 407853, 407826, 240116, 407622, 240100, 405471, 240098, 197590, 407545, 407565, 407543, 401202, 407542, 268912, 343565, 407538, 407106, 197578, 614450, 405469, 343563, 368058, 405466, 614446, 614444, 614442, 240090, 310332, 404656, 407330, 407337, 407335, 401917, 240055, 240051, 357393, 357391, 175284, 407012, 197564, 379974, 197562, 407010, 240026, 107083, 197553, 407104, 407006, 407190, 385793, 42905, 333497, 385790, 215657, 385786, 385784, 385782, 385780, 197528, 228278, 385775, 405039, 405037, 228275, 406107, 406026, 405523, 228273, 228270, 406087, 228266, 406085, 228264, 406083, 161814, 405586, 406024, 228257, 405996, 405519, 406018, 215628, 274616, 405978, 405973, 333495, 405970, 405968, 274612, 405583, 274610, 228251, 228248, 274606, 399711, 399709, 399707, 228246, 399705, 399703, 405503, 405646, 385772, 405934, 10550, 405500, 405498, 405496, 405579, 405493, 399701, 399698, 404558, 405389, 404248, 405462, 405460, 215611, 402994, 386770, 405555, 320433, 302071, 274600, 405455, 197487, 385768, 355707, 197484, 215588, 405099, 385766, 215583, 405062, 385764, 405013, 379970, 379968, 405011, 404999, 404990, 197477, 333492, 404612, 404885, 404930, 379962, 404155, 404265, 50395, 404251, 394527, 379957, 171727, 171724, 171722, 171716, 392318, 171714, 215534, 403903, 402407, 379951, 385459, 379949, 402243, 403772, 403333, 403143, 197427, 197423, 403716, 403714, 383567, 403647, 379947, 197419, 383564, 403566, 36075, 403353, 403326, 106930, 106926, 403302, 403283, 403298, 239864, 403233, 403153, 401825, 403140, 398210, 36073, 403151, 400517, 403138, 338666, 396369, 197394, 400971, 403126, 397807, 106909, 197384, 197382, 403045, 355696, 402988, 401656, 401987, 352970, 355694, 377586, 197368, 400967, 381741, 355691, 381739, 130225, 400808, 402919, 355688, 402907, 402901, 309977, 402869, 400788, 402828, 402597, 402819, 402564, 402562, 402810, 273357, 386940, 402803, 20193, 402587, 402557, 130221, 402583, 294388, 399196, 215470, 402369, 401600, 239815, 402240, 197340, 239733, 239731, 44934, 215445, 197336, 401547, 197332, 239692, 197328, 401376, 205454, 397483, 205451, 228125, 394515, 239662, 239660, 401372, 239658, 239656, 205450, 239654, 239652, 398638, 401357, 400014, 401299, 129011, 215415, 397800, 215407, 400904, 239635, 401278, 401218, 401254, 228114, 401216, 401213, 401183, 401180, 401207, 401260, 400221, 401258, 401205, 382877, 382875, 401170, 401145, 400879, 401143, 401141, 401166, 401139, 400696, 132031, 400709, 400688, 400685, 215374, 400437, 400576, 377576, 387165, 44914, 400554, 215369, 400550, 400525, 399685, 171702, 274586, 274584, 205442, 399862, 274582, 400224, 399675, 23392, 239617, 399666, 274576, 399851, 215318, 399958, 399780, 399777, 323323, 399802, 376847, 399770, 399650, 355677, 355674, 205426, 336962, 197299, 336960, 323320, 398309, 323308, 398359, 398357, 399474, 399126, 399121, 399119, 399116, 399111, 399108, 386456, 228031, 228026, 239563, 228024, 228022, 399459, 106809, 355665, 239556, 239553, 398304, 398300, 398298, 398977, 398875, 320410, 398800, 323300, 239529, 398909, 398906, 398904, 398895, 398293, 197261, 398892, 398290, 318291, 396653, 396641, 398593, 197258, 398282, 398781, 197253, 398524, 215277, 131974, 393446, 398748, 398756, 393444, 227981, 398746, 344803, 197248, 398518, 197245, 239494, 320402, 395931, 239492, 320400, 320394, 239486, 394642, 239484, 323292, 398277, 398514, 323288, 398506, 398503, 239477, 227958, 398433, 227956, 398431, 389675, 398272, 320387, 320385, 398270, 215256, 227950, 320383, 239464, 396956, 386746, 397671, 385762, 397742, 397755, 396841, 369010, 369008, 367021, 197211, 197208, 254060, 205395, 227915, 227904, 227902, 323279, 106749, 397607, 397601, 397586, 106743, 397125, 393904, 396940, 197188, 397511, 355612, 397101, 397055, 397086, 397467, 396132, 197182, 396608, 396933, 396605, 396927, 396924, 392613, 396902, 396898, 396129, 396126, 395863, 395979, 396678, 396675, 396670, 215198, 396667, 396665, 396663, 396661, 396590, 396296, 396294, 396559, 227840, 239405, 396553, 395817, 396551, 379939, 396280, 239402, 395925, 396278, 395922, 227830, 197152, 239399, 215188, 396270, 379937, 396265, 379934, 396263, 383316, 379932, 197144, 395814, 227828, 396260, 395812, 215180, 197138, 197131, 379930, 215178, 379929, 395976, 395700, 395973, 395971, 379926, 395964, 396077, 131948, 131946, 396073, 171653, 197124, 266665, 395893, 323263, 227807, 379923, 395805, 323261, 395952, 215169, 395918, 383311, 294249, 294246, 395856, 379921, 395845, 323257, 161802, 395835, 379919, 395877, 392645, 379917, 395800, 379915, 379913, 333457, 395747, 106669, 239363, 197098, 395616, 395745, 395743, 395685, 395684, 395682, 395679, 395479, 395677, 395661, 395668, 215153, 106663, 395573, 239350, 239348, 215147, 106641, 394794, 394791, 389314, 331567, 197074, 394908, 394904, 385758, 394844, 385756, 394750, 394747, 379909, 394806, 254035, 390796, 394313, 390794, 379907, 390792, 394803, 394801, 227770, 227766, 394733, 394731, 392524, 379905, 227762, 227754, 227750, 215121, 215120, 23384, 239289, 394373, 239285, 394369, 348984, 355603, 23378, 23376, 393384, 227736, 394571, 239279, 394354, 394463, 394412, 394410, 394187, 320366, 355130, 239262, 394267, 323220, 394264, 394262, 394142, 394140, 394258, 394134, 394131, 355128, 227718, 394124, 323218, 227716, 394244, 394241, 394223, 394239, 394120, 394045, 394113, 393616, 394110, 394043, 394099, 215097, 394041, 394039, 393418, 394038, 239258, 227714, 388434, 215093, 227711, 227709, 394035, 271752, 394030, 394027, 394024, 378295, 355125, 378293, 355123, 393414, 215091, 197039, 393412, 393367, 394007, 394002, 323216, 323213, 393643, 393641, 393598, 393986, 355112, 393636, 379903, 393881, 393877, 393595, 393594, 393631, 392430, 366996, 393629, 393272, 393361, 323203, 393230, 393268, 393504, 393588, 197020, 392667, 393187, 197019, 315666, 392741, 325757, 392712, 392710, 315660, 392686, 227674, 161783, 391928, 161781, 325755, 325754, 392632, 392704, 392702, 239214, 239212, 271747, 392630, 239210, 239208, 392628, 392681, 392679, 315656, 161779, 392663, 315654, 360790, 392587, 239204, 215047, 197013, 392582, 392580, 215043, 197010, 315652, 239202, 344780, 239199, 227669, 320362, 392516, 392385, 392569, 349365, 392567, 389443, 392565, 197005, 392563, 392553, 315649, 392551, 392382, 392559, 315647, 392314, 315645, 383810, 392486, 383808, 392311, 392309, 376612, 196994, 392335, 392301, 385750, 385748, 106595, 390725, 161775, 391876, 391811, 391806, 391800, 391776, 391789, 391744, 239105, 391625, 389411, 391718, 389833, 387010, 391740, 385745, 391399, 385743, 391282, 390848, 239040, 323191, 239035, 174227, 390915, 391277, 390715, 391275, 227630, 391271, 391253, 227621, 616680, 390831, 174216, 174214, 616675, 616673, 390829, 616671, 379901, 214971, 390901, 389518, 388609, 389510, 390386, 250018, 389437, 390383, 389435, 227590, 390086, 387698, 387789, 390375, 227586, 389955, 388607, 390327, 390373, 375630, 375626, 196964, 383582, 614432, 196962, 390280, 239013, 389826, 390199, 389823, 386433, 253720, 106559, 308758, 308756, 389993, 238989, 389842, 238972, 387774, 389819, 110101, 389804, 238951, 238949, 196947, 389573, 106526, 386166, 238941, 389801, 238935, 238933, 271743, 387694, 382119, 271740, 389752, 382116, 384965, 238923, 196939, 271737, 238921, 271735, 271731, 271729, 23366, 389359, 320326, 389293, 389097, 388330, 388599, 375754, 387249, 387431, 387429, 387004, 387247, 378760, 386236, 388577, 383754, 389080, 387958, 387427, 387426, 375751, 308731, 385737, 214903, 387243, 388442, 388671, 388575, 109326, 388559, 385492, 196917, 388322, 238866, 388320, 387936, 238862, 387500, 387595, 227545, 214860, 196907, 387363, 387361, 214842, 386936, 387284, 214834, 384364, 387200, 308714, 386565, 106505, 387177, 369643, 386559, 386630, 384272, 386955, 386953, 386894, 386927, 386628, 386925, 386919, 386978, 386689, 227497, 308702, 214811, 161754, 227489, 379896, 227486, 381286, 348415, 386512, 386547, 196899, 386591, 379893, 386521, 196898, 386519, 227456, 386307, 227450, 227447, 383718, 227445, 183057, 183055, 227443, 214781, 376566, 348333, 256347, 238806, 348324, 238801, 386360, 385735, 379891, 385607, 385605, 379887, 350333, 350331, 385429, 385334, 385427, 324222, 384921, 385372, 324220, 308699, 379884, 196888, 385258, 385254, 385251, 385250, 323178, 383305, 323176, 238598, 384063, 366968, 383383, 303255, 379873, 384332, 366961, 377985, 214559, 359088, 383373, 359086, 359083, 383894, 383916, 383427, 383425, 359077, 383885, 365145, 274553, 383647, 274550, 383828, 383826, 377436, 330860, 330856, 330854, 330852, 330850, 383349, 303232, 383066, 383049, 382982, 382716, 383063, 383059, 383089, 378424, 382644, 379859, 382462, 214506, 377429, 333444, 382225, 379857, 379855, 333443, 333441, 370435, 379211, 376008, 379209, 378379, 333438, 378370, 196824, 196823, 378367, 378357, 333436, 370433, 379374, 379372, 379370, 308668, 196820, 381215, 381213, 370429, 330843, 320271, 320269, 320267, 196819, 378746, 378744, 370427, 214471, 370425, 333433, 379852, 196816, 370423, 333431, 379848, 379835, 238453, 379833, 379649, 379633, 379578, 379677, 379707, 379704, 379628, 379673, 379642, 379625, 379477, 379130, 379199, 379431, 379126, 333418, 333416, 350019, 196773, 238119, 368755, 237967, 237960, 237939, 196432, 364773, 285440, 323139, 365839, 362914, 365837, 324608, 365428, 105973, 331275, 237856, 237853, 365090, 226508, 365835, 362912, 325366, 365818, 365087, 226489, 237829, 365776, 365740, 365738, 365736, 237826, 323136, 237824, 213566, 365083, 213563, 213561, 196430, 213559, 196427, 237821, 213557, 105965, 237819, 365707, 237817, 328902, 252619, 328901, 226477, 328899, 328897, 226475, 360713, 328894, 360705, 360701, 332340, 213534, 213532, 364361, 213530, 364358, 364761, 196415, 303212, 303207, 364795, 332337, 196411, 196410, 357370, 196409, 364938, 364791, 357356, 364789, 350576, 339595, 357354, 360698, 364787, 364783, 357351, 357349, 362942, 364775, 303193, 303179, 277441, 226276, 361081, 196376, 237654, 361716, 361077, 196375, 196373, 196371, 350324, 252584, 359691, 237561, 237556, 361018, 226183, 303125, 359688, 361016, 226179, 360295, 323127, 358286, 323124, 360849, 360200, 303114, 614422, 196350, 360945, 355551, 325354, 303111, 360846, 335786, 360863, 360861, 360859, 360858, 213253, 213248, 303102, 344489, 344488, 303100, 360257, 303096, 226135, 360253, 341668, 360249, 196347, 226125, 226123, 360557, 196343, 350316, 226107, 325350, 237505, 196342, 358812, 359683, 213212, 196331, 360241, 105763, 359667, 359665, 327155, 358810, 196328, 226053, 237488, 354853, 333312, 355548, 237460, 225986, 105745, 348939, 105743, 105739, 105735, 105732, 324558, 237453, 358246, 355545, 359177, 359175, 237446, 359173, 359266, 359169, 354716, 358713, 358711, 358709, 358707, 358974, 358238, 358236, 225968, 213145, 225966, 346882, 358220, 213140, 358284, 358217, 358215, 358773, 358771, 213136, 328286, 213130, 358767, 237441, 196321, 358209, 128958, 237433, 354842, 237426, 213094, 331249, 237422, 213091, 331247, 358701, 225950, 237418, 358749, 237416, 237414, 358699, 344484, 358691, 237412, 358282, 237371, 237369, 358033, 252544, 358268, 358266, 237362, 355482, 358265, 358264, 237360, 358092, 105685, 358181, 355479, 348933, 358140, 328283, 358138, 357574, 358031, 350562, 358177, 350559, 350557, 324174, 357572, 323111, 358173, 358171, 237357, 358169, 237354, 358090, 354575, 354573, 354571, 354568, 225890, 357968, 357836, 237343, 225887, 325483, 196290, 354391, 354390, 196289, 357665, 196286, 342693, 357332, 196282, 196280, 196279, 356180, 196277, 196276, 237323, 329934, 329933, 329931, 329929, 329927, 329924, 329922, 329921, 329918, 329915, 329913, 329911, 357594, 357589, 357077, 357563, 342690, 196274, 355526, 196272, 357316, 357309, 357257, 333306, 357303, 357301, 357299, 357294, 333303, 355523, 333302, 333300, 333297, 344020, 357231, 355516, 355515, 212970, 357158, 212968, 131757, 355450, 357220, 212964, 357182, 131747, 225803, 357177, 196270, 356466, 356464, 356462, 356460, 356750, 225796, 357150, 357073, 212951, 225778, 225769, 333294, 225767, 237262, 355395, 353854, 348884, 237249, 196245, 356131, 356130, 196242, 342244, 348881, 356128, 196239, 196238, 333288, 191781, 196237, 333284, 212853, 322619, 333281, 354833, 348207, 355384, 355430, 356199, 353828, 354305, 354825, 354377, 237209, 339591, 355419, 350076, 355416, 354815, 354302, 346788, 332851, 355046, 310313, 310311, 128945, 346777, 310309, 212786, 354810, 354808, 196214, 332849, 212770, 354800, 207344, 354666, 354664, 354663, 348818, 348816, 348188, 348811, 354134, 212768, 196211, 268852, 268850, 354550, 268848, 268846, 268844, 268842, 354363, 212764, 354544, 333274, 128938, 354542, 333273, 352654, 348806, 237174, 237172, 333271, 237168, 348804, 237162, 354295, 354357, 354291, 352907, 333269, 352901, 310303, 352897, 267255, 333267, 334647, 315643, 225531, 252496, 353824, 353822, 105560, 315641, 350307, 353718, 334644, 225529, 315639, 237146, 105558, 237143, 105556, 333264, 353816, 212735, 353709, 353707, 252491, 237141, 252489, 225519, 237139, 105540, 353810, 105538, 105535, 353886, 353807, 267242, 352764, 333256, 353597, 338664, 303070, 352885, 353414, 353411, 196200, 347459, 353263, 350896, 353261, 352984, 352846, 350276, 351946, 352085, 350778, 350776, 350002, 350772, 350300, 333253, 352083, 351762, 268825, 268819, 338779, 352082, 352081, 268809, 268807, 237040, 212645, 351922, 351914, 351912, 351910, 342686, 225383, 351510, 225381, 338774, 196186, 351544, 196176, 196175, 338582, 196166, 277437, 350298, 277435, 351178, 303045, 351175, 225270, 225268, 131715, 131712, 212585, 350938, 333241, 350937, 340068, 346750, 346009, 350812, 350710, 350811, 350342, 350707, 350699, 350422, 350340, 350419, 332835, 350339, 225226, 252438, 350391, 350295, 350293, 350287, 350235, 350233, 347587, 347578, 350180, 349279, 350177, 349992, 212537, 212534, 205269, 324535, 349987, 349983, 225216, 349277, 334642, 59825, 196155, 225212, 349753, 350006, 349851, 349977, 334631, 349846, 225210, 334627, 236990, 349972, 347653, 347651, 348583, 349750, 196152, 349748, 310249, 348577, 225200, 225198, 225196, 349427, 225192, 349272, 349735, 131679, 349649, 196149, 349733, 225191, 314398, 349713, 349711, 347450, 347566, 225174, 349709, 196147, 196146, 349647, 331559, 346735, 349631, 349357, 348566, 348563, 348562, 347646, 348650, 348558, 346731, 346725, 252427, 348913, 348895, 196136, 345321, 252417, 310227, 338766, 348114, 131634, 347443, 236904, 347411, 346550, 346634, 346645, 196130, 346624, 346541, 332722, 344611, 333181, 184929, 128923, 345317, 345315, 332720, 332719, 345050, 344921, 344915, 329557, 342678, 196111, 196109, 310197, 310195, 310192, 310185, 310184, 310181, 310179, 310176, 310175, 323070, 343867, 343375, 343907, 343903, 343901, 343897, 339567, 343203, 339563, 331698, 196064, 196062, 341794, 341965, 341962, 341960, 339557, 341904, 341901, 339553, 341595, 339512, 339510, 262894, 339508, 339506, 339504, 341870, 341864, 236643, 128922, 341416, 340644, 340019, 340459, 340457, 340456, 340454, 340366, 339551, 340168, 339550, 236534, 340072, 340049, 340047, 236530, 236528, 224606, 236526, 340029, 339922, 339903, 339549, 339810, 339668, 339612, 339545, 339541, 196032, 339534, 336124, 265383, 252218, 317656, 338662, 338750, 338660, 338645, 252203, 252198, 338643, 323053, 335775, 338024, 337699, 337818, 337816, 337692, 337507, 313654, 313651, 337504, 336949, 337500, 336098, 336939, 333041, 333039, 7603, 265366, 336937, 333150, 265364, 333147, 334509, 333145, 333144, 337172, 236340, 211710, 337265, 333139, 336579, 224481, 224479, 277351, 236330, 236326, 337152, 336910, 285435, 334481, 334479, 336093, 334470, 334467, 336088, 335872, 333130, 335870, 334438, 335586, 334419, 335068, 334843, 315616, 334790, 334788, 334778, 334702, 334699, 332206, 332204, 334321, 224326, 334319, 334358, 332899, 334356, 332738, 317655, 334125, 211435, 195964, 333111, 195960, 314126, 333108, 333106, 314124, 314121, 332540, 332203, 332538, 332529, 332935, 332714, 332711, 252124, 332709, 332867, 332865, 332804, 332501, 332802, 332800, 332498, 224263, 332798, 332795, 332751, 332497, 332494, 332491, 332466, 332465, 332462, 332641, 332452, 332249, 332112, 332446, 128886, 205116, 332295, 332145, 330620, 105095, 105093, 278128, 332247, 323024, 330613, 330880, 29987, 332196, 325650, 325648, 331153, 328467, 331647, 331718, 323020, 331639, 306266, 330606, 330603, 297841, 330601, 329518, 328874, 328864, 195916, 314578, 287313, 195913, 328651, 328668, 327796, 328643, 314574, 323016, 314572, 310140, 328013, 328011, 310138, 305420, 328009, 328127, 328100, 328005, 211151, 327789, 327787, 327785, 282793, 327783, 327780, 327566, 327565, 327562, 318546, 318542, 310133, 131477, 131474, 263056, 326763, 310130, 326622, 252067, 326996, 326995, 326991, 326987, 324402, 326859, 326858, 326616, 326614, 310128, 318529, 326742, 304728, 321755, 321754, 321746, 318527, 307468, 210861, 278124))
Run Time: 0.213475
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3920 | |
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 | | | | | 3920 | |
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 (33567, 33077, 32195, 30529, 30045, 29488, 29198, 28503, 28464, 28377, 28205, 27789, 27496, 26860, 25457, 24801, 24783, 24722, 24619, 24592, 24409, 24407, 24262, 24211, 22925, 22859, 22843, 22836, 22739, 22562, 22418, 22155, 22154, 22138, 22130, 21913, 21902, 21873, 21677, 21465, 21302, 21170, 21169, 21164, 21149, 20915, 20772, 20747, 20561, 20534, 20384, 20323, 20299, 20077, 20019, 19982, 19838, 19754, 19629, 19627, 19624, 19580, 19488, 19427, 19090, 18272, 18085, 18059, 18056, 18010, 18000, 17939, 17910, 17909, 17907, 17889, 17756, 17726, 17597, 17563, 17448, 17430, 17429, 17390, 17135, 16952, 16800, 16789, 16739, 16723, 16663, 16566, 16461, 16410, 16368, 16337, 16296, 16245, 16244, 16195, 16151, 16124, 16111, 16034, 16001, 15818, 15795))
Run Time: 0.003737
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 107 | 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 `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 (606966, 336718, 533888, 443683, 615934, 443583, 443581, 615988, 443579, 615925, 533860, 615488, 615503, 443240, 533777, 615484, 443222, 443219, 443217, 443211, 613578, 614101, 610868, 610573, 533196, 533194, 610570, 441422, 441420, 441415, 533190, 533188, 533186, 441413, 533184, 609781, 533172, 609778, 589969, 584551, 343199, 531104, 573629, 433426, 573624, 573617, 548266, 549663, 432879, 549661, 560752, 432723, 569424, 569825, 336316, 336311, 569823, 560748, 565222, 565234, 565115, 565337, 564928, 564925, 564860, 432011, 554668, 554666, 493702, 554664, 133095, 431980, 563702, 562221, 562219, 333859, 333857, 333852, 333850, 333848, 551561, 547912, 557962, 200218, 529185, 551556, 430993, 555349, 555343, 555295, 555235, 354494, 554802, 554629, 552564, 552562, 551931, 552507, 544231, 303386, 552250, 303383, 430702, 430698, 552205, 552171, 552119, 552160, 450388, 289782, 289779, 289777, 552100, 552147, 552117, 552111, 405778, 355904, 355903, 333804, 333802, 333799, 529071, 551928, 551923, 551921, 551919, 551917, 549077, 549069, 549066, 549052, 551623, 549043, 549040, 549027, 549025, 551514, 551553, 551551, 551548, 355901, 551509, 548238, 543631, 545146, 544662, 544660, 542833, 542831, 544381, 542828, 429736, 542826, 542823, 511002, 543577, 518979, 542818, 542816, 429582, 542813, 543514, 542811, 542809, 542807, 542895, 542804, 542802, 542798, 429263, 457637, 485595, 232509, 538575, 538573, 199887, 199875, 521294, 427853, 108425, 325050, 505189, 427592, 380427, 448815, 510083, 510070, 510067, 510110, 509913, 333697, 509196, 509193, 411934, 402726, 333686, 333680, 427107, 199618, 333676, 427082, 385881, 385879, 427074, 460848, 614579, 614577, 508273, 460846, 614574, 614571, 385876, 385874, 385873, 330279, 309286, 460844, 460842, 460840, 505734, 309235, 309233, 325400, 413771, 426834, 505178, 426659, 426628, 108279, 426555, 426489, 493446, 199461, 337017, 380371, 426248, 500907, 500905, 337014, 337012, 309005, 337010, 500050, 337008, 242996, 337006, 325837, 483203, 483202, 231426, 501163, 325007, 242991, 231423, 500900, 500879, 500873, 500871, 500867, 500865, 108225, 500049, 500861, 500856, 242966, 231302, 426119, 426117, 499308, 499306, 426114, 426107, 426104, 426102, 426100, 426097, 426092, 386276, 184559, 184556, 368197, 333656, 496112, 496108, 496103, 496100, 496089, 496082, 496073, 171816, 425901, 425894, 425890, 425885, 425879, 199375, 495607, 493915, 333648, 493911, 496071, 493903, 639871, 455363, 425864, 495666, 495664, 495661, 425847, 199358, 494039, 492460, 492270, 199275, 492232, 411797, 492140, 492148, 491006, 491209, 492094, 491798, 491796, 492008, 492005, 492003, 217843, 425617, 491668, 491664, 230907, 476837, 199257, 425578, 491270, 425576, 199255, 217807, 425570, 491379, 491377, 399263, 356368, 356366, 491235, 491233, 491230, 491228, 132721, 354209, 354207, 490883, 425526, 490087, 199239, 489015, 489013, 425513, 490881, 490084, 490878, 471930, 471927, 484215, 490082, 490045, 490043, 490866, 490863, 199234, 207530, 230868, 488164, 490466, 489930, 489949, 490376, 490308, 425499, 199231, 490124, 230826, 199229, 230823, 490068, 489920, 472587, 242676, 489201, 267668, 320977, 489871, 489779, 199226, 336269, 336266, 336263, 336261, 489744, 489148, 380337, 489742, 380335, 489758, 380332, 242666, 489727, 489740, 320973, 489738, 425482, 489605, 199220, 199219, 487826, 380329, 308925, 308916, 489231, 489228, 489225, 489223, 485159, 230791, 230789, 488778, 380327, 320949, 380325, 488949, 230786, 488366, 409162, 305711, 488981, 488767, 488360, 489062, 354452, 488758, 489060, 488578, 488576, 488754, 488979, 425447, 354448, 488985, 476258, 391725, 489056, 380322, 488977, 488991, 489004, 488885, 217746, 488973, 385855, 217744, 488358, 199213, 386169, 488873, 488353, 425436, 488237, 199209, 488749, 355860, 488508, 349111, 488492, 487126, 336258, 488485, 488228, 488225, 488223, 487124, 425415, 108051, 408787, 308869, 308866, 308863, 308858, 487095, 217704, 305705, 488214, 488211, 488209, 217692, 488117, 199197, 230779, 230777, 487975, 488081, 408048, 337564, 487972, 488096, 488094, 488075, 488071, 488068, 425381, 249705, 488038, 488007, 421751, 199190, 199188, 487843, 199186, 487880, 425319, 486686, 486682, 380311, 487877, 108033, 108031, 217646, 401309, 402703, 487580, 485145, 485143, 447760, 425269, 485138, 484862, 487407, 408125, 487404, 484859, 484857, 487401, 487119, 487561, 487558, 487115, 487111, 453444, 487538, 199165, 487536, 425255, 425251, 425249, 314421, 425245, 486043, 486981, 230706, 486954, 487034, 486950, 453440, 453438, 486947, 487086, 487031, 487084, 425230, 425227, 421851, 421847, 486998, 484163, 58635, 58633, 58631, 58629, 380301, 425190, 484159, 462138, 486434, 380285, 486283, 486333, 486281, 486278, 199102, 484089, 484042, 414331, 230609, 230607, 230605, 618493, 230601, 230599, 483947, 483902, 242483, 483717, 483714, 483243, 483705, 199090, 470835, 483236, 483233, 425100, 482822, 217539, 482778, 482761, 330200, 217537, 482759, 482525, 199057, 425047, 475311, 475307, 230260, 456125, 380238, 380236, 475186, 475045, 475043, 424525, 469476, 241970, 241963, 241959, 468766, 367145, 468582, 355833, 468554, 468463, 320753, 241739, 465536, 465534, 464357, 463028, 333608, 456116, 333606, 413084, 333604, 459696, 465513, 465511, 324894, 333601, 375040, 465047, 198542, 464413, 457616, 464537, 457614, 464532, 464530, 403927, 464894, 464913, 323489, 464911, 464926, 464908, 205637, 464625, 241719, 216824, 411670, 456112, 463992, 324891, 333598, 396437, 216814, 464759, 241714, 463139, 463890, 464219, 463982, 464201, 463980, 463402, 463965, 413746, 463387, 408045, 323483, 460988, 460985, 460983, 399927, 463377, 460980, 460977, 463373, 107694, 463370, 461686, 463368, 463366, 463364, 463362, 459694, 455091, 461422, 460975, 463175, 320713, 320711, 463173, 402694, 380233, 380232, 417719, 462130, 402669, 462427, 107684, 107681, 107679, 198463, 462128, 463135, 463132, 463128, 463124, 413743, 324289, 354151, 461694, 461640, 461691, 461528, 461637, 216747, 424008, 461364, 461362, 461478, 461360, 459597, 461516, 461243, 198416, 423998, 460959, 461216, 461213, 423991, 461109, 320684, 241577, 241575, 324880, 460683, 460168, 460838, 198403, 460166, 423918, 336227, 456768, 336217, 456766, 458203, 458841, 458839, 458201, 458896, 241495, 198326, 458731, 229720, 458445, 423889, 458343, 458341, 198310, 458308, 458195, 458226, 458193, 458282, 324869, 458112, 368080, 457802, 216643, 456101, 368078, 355818, 396429, 396428, 451148, 457177, 380216, 457598, 457260, 259364, 457399, 457057, 457055, 457053, 457019, 423873, 457017, 456990, 456986, 241436, 415183, 456974, 408775, 456657, 423864, 241410, 456755, 387042, 456632, 355813, 132301, 456484, 355812, 355811, 456526, 456478, 336213, 380203, 385832, 455739, 455715, 455737, 455711, 455734, 455519, 455215, 392557, 417101, 417098, 229581, 417096, 417094, 423836, 417092, 423831, 454131, 455068, 455038, 454967, 132273, 454126, 324849, 336209, 241317, 454355, 454530, 161834, 216522, 336206, 336204, 336202, 454121, 453986, 406585, 453977, 453975, 380192, 205546, 320651, 452036, 452034, 451470, 453965, 453962, 241284, 241281, 151573, 453835, 198173, 388116, 448418, 388113, 450681, 388110, 453245, 411653, 216485, 391722, 453243, 453238, 341109, 391720, 453289, 453235, 453233, 452236, 453068, 453192, 453066, 324843, 452230, 452596, 198166, 198163, 452996, 452762, 198157, 198152, 452760, 241253, 320643, 452633, 452632, 365166, 241247, 451560, 241237, 452453, 452601, 452451, 451252, 451250, 451248, 407165, 107526, 198143, 107524, 414806, 107520, 330121, 107518, 330120, 107516, 377254, 414800, 406576, 422294, 452322, 229516, 452253, 452251, 452089, 452248, 402957, 452158, 452217, 452086, 452052, 452047, 452082, 380180, 265480, 452068, 452043, 451426, 355800, 451905, 451423, 451763, 355798, 107502, 360399, 241217, 241215, 451418, 241213, 229485, 355796, 355794, 229480, 451820, 229475, 355790, 414787, 451691, 414781, 451699, 451436, 324830, 451697, 451695, 449547, 188729, 241176, 449545, 451552, 451413, 451410, 451408, 107493, 451402, 451400, 451397, 451392, 229470, 229468, 451389, 241173, 241171, 241169, 241167, 324829, 451434, 451328, 451326, 229466, 451387, 451375, 451373, 188726, 188724, 188722, 451384, 451371, 451369, 451222, 451366, 188720, 451316, 188718, 451337, 451313, 451324, 188716, 451311, 451285, 451282, 324827, 451278, 367100, 324825, 450183, 241154, 320613, 451176, 451113, 450167, 355788, 241132, 285505, 393033, 393031, 393029, 450016, 450013, 216387, 333568, 420867, 333563, 416690, 198063, 449347, 448701, 449496, 449494, 448697, 449491, 355783, 241104, 355782, 417268, 216366, 241102, 448689, 448231, 449253, 449229, 323452, 241099, 449168, 241096, 449312, 449422, 449420, 449062, 449323, 449060, 449318, 449305, 449302, 229379, 229377, 229374, 449057, 216343, 449100, 449054, 412843, 449052, 449235, 449043, 418908, 418906, 241079, 448876, 216313, 411628, 448443, 448221, 448313, 325804, 447848, 448121, 308794, 308791, 308788, 448202, 198030, 198028, 448421, 448297, 448154, 448398, 448286, 448282, 448280, 423577, 448394, 448385, 448184, 448267, 448240, 448345, 378016, 448172, 229339, 383272, 229337, 447792, 448137, 229335, 614480, 614478, 447916, 423733, 447914, 423731, 423687, 380132, 216297, 447836, 216295, 240988, 447832, 447825, 240980, 380119, 229226, 229224, 362706, 422327, 229222, 380116, 229215, 423615, 423613, 216271, 423589, 423587, 421305, 423584, 423581, 409762, 614467, 421302, 323447, 423530, 423514, 423501, 380114, 423433, 423087, 423085, 421819, 423175, 423081, 423079, 423171, 423227, 423167, 423160, 396141, 423378, 107386, 423376, 423373, 396139, 380110, 380107, 380105, 393023, 422723, 380103, 423067, 320571, 423138, 229191, 333557, 240925, 421707, 320568, 333555, 423005, 240923, 380098, 423000, 422571, 422998, 422566, 422763, 380095, 320542, 422319, 229144, 416679, 229141, 229140, 380087, 229131, 416672, 362926, 132232, 197967, 240890, 422097, 422220, 132215, 416667, 355776, 422217, 422162, 240877, 421723, 421593, 421591, 421584, 421232, 419680, 408231, 240865, 240863, 408229, 421537, 229097, 421528, 419678, 419676, 421418, 421525, 421523, 421230, 419674, 420892, 421005, 362921, 421320, 420040, 420038, 421223, 349374, 421008, 197940, 420920, 369035, 420849, 420847, 420884, 420882, 420880, 420878, 420876, 419707, 407153, 420130, 420126, 420016, 419990, 407148, 407144, 419668, 419554, 419550, 419547, 419539, 419537, 419534, 419528, 419523, 229051, 419493, 229046, 419490, 240780, 419488, 419362, 216181, 419384, 419411, 419406, 419357, 419355, 419282, 411070, 411068, 411601, 419200, 380070, 418162, 411594, 380067, 418723, 380059, 418647, 254092, 418637, 417134, 380057, 418527, 414326, 414323, 418576, 418560, 333544, 333541, 413733, 417198, 418018, 364822, 418219, 364820, 418272, 416796, 418270, 364818, 380048, 417647, 380043, 617322, 417604, 417642, 417640, 417636, 229012, 407141, 417602, 417600, 380039, 417598, 417415, 229010, 417595, 417593, 417591, 395943, 417588, 417539, 216118, 417585, 407137, 416290, 417349, 417342, 617302, 617300, 417207, 229002, 416118, 132157, 415890, 417127, 416897, 228995, 228993, 617289, 228991, 417067, 228988, 228986, 415180, 417119, 417114, 417104, 415887, 417076, 417063, 416923, 216092, 416921, 415175, 416892, 228981, 415171, 228979, 417071, 380037, 617281, 412840, 416184, 416917, 416182, 308784, 417008, 415150, 410976, 417006, 417004, 413731, 369026, 380032, 416360, 380030, 413730, 413728, 415750, 416788, 416665, 240648, 240645, 416693, 416533, 240641, 416617, 410845, 416010, 416008, 416521, 416519, 216072, 416453, 416451, 416496, 416424, 398939, 416168, 416281, 416279, 416277, 393289, 411562, 406645, 416275, 416267, 415883, 416266, 416264, 415880, 416262, 415876, 228919, 416259, 415873, 416139, 412911, 412908, 415747, 416082, 416032, 413375, 413372, 385822, 385820, 385817, 415741, 414539, 216062, 414537, 415832, 385814, 323426, 416006, 415863, 415826, 415859, 415824, 415847, 415822, 415733, 415797, 415779, 412905, 228901, 415588, 415789, 228898, 415687, 414711, 414708, 415616, 415614, 413549, 415509, 361603, 414531, 415606, 415573, 415124, 364814, 413727, 414683, 380028, 414681, 380026, 414672, 413990, 414695, 414668, 414665, 197793, 197791, 413678, 414630, 414004, 414627, 413724, 414619, 413722, 414616, 414523, 380021, 240544, 414488, 343444, 414486, 413459, 414315, 414484, 413714, 414002, 414309, 414306, 413981, 216010, 161830, 161827, 414426, 413975, 413707, 396135, 414304, 413705, 413701, 413698, 413994, 413695, 414339, 414337, 413495, 413971, 413969, 413836, 413693, 413833, 413831, 380018, 380016, 216004, 413491, 413672, 413564, 380014, 413635, 353043, 353042, 252762, 215982, 315693, 369402, 315689, 413552, 376799, 215976, 413366, 411264, 355750, 397809, 404150, 413361, 412837, 197773, 380011, 413028, 228838, 413355, 228834, 409536, 413319, 413384, 413352, 413317, 413350, 413315, 240503, 413140, 412675, 413126, 413124, 411221, 411219, 404090, 411216, 240480, 404088, 404086, 380003, 617205, 413101, 404084, 380001, 412834, 413076, 240478, 412832, 404082, 398364, 412830, 385806, 367084, 411487, 408034, 161825, 410734, 215908, 410888, 411139, 411023, 411102, 385801, 320468, 411099, 385799, 410725, 410999, 385797, 410723, 411045, 408596, 408594, 411019, 355745, 410882, 410718, 410711, 410992, 410990, 405291, 410987, 639785, 410705, 409744, 410957, 410961, 410600, 410691, 396403, 396400, 410315, 407134, 410561, 407131, 324776, 285494, 379987, 407557, 379985, 379983, 407555, 407551, 379981, 379979, 407126, 410519, 410584, 408579, 407118, 215873, 410557, 362273, 410492, 410205, 410303, 228704, 410299, 240386, 357422, 107160, 394816, 407116, 357420, 240357, 240353, 228680, 410058, 410136, 396395, 410134, 396393, 408738, 407548, 357418, 240330, 240327, 240324, 409961, 215830, 215828, 409843, 409724, 320448, 409578, 320441, 215820, 409670, 409631, 240316, 409593, 197689, 409369, 197675, 406297, 409365, 409440, 215782, 401266, 197673, 408875, 409431, 409429, 408009, 409301, 409297, 409346, 409281, 408997, 409204, 409223, 215773, 215770, 409220, 409112, 409196, 197664, 402247, 409070, 215765, 408988, 408982, 405409, 228594, 407995, 215759, 408732, 188703, 197656, 228587, 408976, 408970, 408946, 355735, 408936, 408934, 408928, 228560, 228551, 228546, 228541, 228540, 379976, 228528, 188700, 408825, 408823, 408852, 408821, 408819, 240238, 240236, 240233, 240231, 240229, 240227, 240225, 408846, 240219, 407110, 197634, 240199, 408380, 315687, 408377, 240178, 404995, 408368, 240176, 408478, 240170, 228487, 407883, 407881, 408136, 407970, 407879, 407872, 197598, 407919, 215689, 407829, 407897, 368064, 407853, 407826, 240116, 407622, 240100, 405471, 240098, 197590, 407545, 407565, 407543, 401202, 407542, 268912, 343565, 407538, 407106, 197578, 614450, 405469, 343563, 368058, 405466, 614446, 614444, 614442, 240090, 310332, 404656, 407330, 407337, 407335, 401917, 240055, 240051, 357393, 357391, 175284, 407012, 197564, 379974, 197562, 407010, 240026, 107083, 197553, 407104, 407006, 407190, 385793, 42905, 333497, 385790, 215657, 385786, 385784, 385782, 385780, 197528, 228278, 385775, 405039, 405037, 228275, 406107, 406026, 405523, 228273, 228270, 406087, 228266, 406085, 228264, 406083, 161814, 405586, 406024, 228257, 405996, 405519, 406018, 215628, 274616, 405978, 405973, 333495, 405970, 405968, 274612, 405583, 274610, 228251, 228248, 274606, 399711, 399709, 399707, 228246, 399705, 399703, 405503, 405646, 385772, 405934, 10550, 405500, 405498, 405496, 405579, 405493, 399701, 399698, 404558, 405389, 404248, 405462, 405460, 215611, 402994, 386770, 405555, 320433, 302071, 274600, 405455, 197487, 385768, 355707, 197484, 215588, 405099, 385766, 215583, 405062, 385764, 405013, 379970, 379968, 405011, 404999, 404990, 197477, 333492, 404612, 404885, 404930, 379962, 404155, 404265, 50395, 404251, 394527, 379957, 171727, 171724, 171722, 171716, 392318, 171714, 215534, 403903, 402407, 379951, 385459, 379949, 402243, 403772, 403333, 403143, 197427, 197423, 403716, 403714, 383567, 403647, 379947, 197419, 383564, 403566, 36075, 403353, 403326, 106930, 106926, 403302, 403283, 403298, 239864, 403233, 403153, 401825, 403140, 398210, 36073, 403151, 400517, 403138, 338666, 396369, 197394, 400971, 403126, 397807, 106909, 197384, 197382, 403045, 355696, 402988, 401656, 401987, 352970, 355694, 377586, 197368, 400967, 381741, 355691, 381739, 130225, 400808, 402919, 355688, 402907, 402901, 309977, 402869, 400788, 402828, 402597, 402819, 402564, 402562, 402810, 273357, 386940, 402803, 20193, 402587, 402557, 130221, 402583, 294388, 399196, 215470, 402369, 401600, 239815, 402240, 197340, 239733, 239731, 44934, 215445, 197336, 401547, 197332, 239692, 197328, 401376, 205454, 397483, 205451, 228125, 394515, 239662, 239660, 401372, 239658, 239656, 205450, 239654, 239652, 398638, 401357, 400014, 401299, 129011, 215415, 397800, 215407, 400904, 239635, 401278, 401218, 401254, 228114, 401216, 401213, 401183, 401180, 401207, 401260, 400221, 401258, 401205, 382877, 382875, 401170, 401145, 400879, 401143, 401141, 401166, 401139, 400696, 132031, 400709, 400688, 400685, 215374, 400437, 400576, 377576, 387165, 44914, 400554, 215369, 400550, 400525, 399685, 171702, 274586, 274584, 205442, 399862, 274582, 400224, 399675, 23392, 239617, 399666, 274576, 399851, 215318, 399958, 399780, 399777, 323323, 399802, 376847, 399770, 399650, 355677, 355674, 205426, 336962, 197299, 336960, 323320, 398309, 323308, 398359, 398357, 399474, 399126, 399121, 399119, 399116, 399111, 399108, 386456, 228031, 228026, 239563, 228024, 228022, 399459, 106809, 355665, 239556, 239553, 398304, 398300, 398298, 398977, 398875, 320410, 398800, 323300, 239529, 398909, 398906, 398904, 398895, 398293, 197261, 398892, 398290, 318291, 396653, 396641, 398593, 197258, 398282, 398781, 197253, 398524, 215277, 131974, 393446, 398748, 398756, 393444, 227981, 398746, 344803, 197248, 398518, 197245, 239494, 320402, 395931, 239492, 320400, 320394, 239486, 394642, 239484, 323292, 398277, 398514, 323288, 398506, 398503, 239477, 227958, 398433, 227956, 398431, 389675, 398272, 320387, 320385, 398270, 215256, 227950, 320383, 239464, 396956, 386746, 397671, 385762, 397742, 397755, 396841, 369010, 369008, 367021, 197211, 197208, 254060, 205395, 227915, 227904, 227902, 323279, 106749, 397607, 397601, 397586, 106743, 397125, 393904, 396940, 197188, 397511, 355612, 397101, 397055, 397086, 397467, 396132, 197182, 396608, 396933, 396605, 396927, 396924, 392613, 396902, 396898, 396129, 396126, 395863, 395979, 396678, 396675, 396670, 215198, 396667, 396665, 396663, 396661, 396590, 396296, 396294, 396559, 227840, 239405, 396553, 395817, 396551, 379939, 396280, 239402, 395925, 396278, 395922, 227830, 197152, 239399, 215188, 396270, 379937, 396265, 379934, 396263, 383316, 379932, 197144, 395814, 227828, 396260, 395812, 215180, 197138, 197131, 379930, 215178, 379929, 395976, 395700, 395973, 395971, 379926, 395964, 396077, 131948, 131946, 396073, 171653, 197124, 266665, 395893, 323263, 227807, 379923, 395805, 323261, 395952, 215169, 395918, 383311, 294249, 294246, 395856, 379921, 395845, 323257, 161802, 395835, 379919, 395877, 392645, 379917, 395800, 379915, 379913, 333457, 395747, 106669, 239363, 197098, 395616, 395745, 395743, 395685, 395684, 395682, 395679, 395479, 395677, 395661, 395668, 215153, 106663, 395573, 239350, 239348, 215147, 106641, 394794, 394791, 389314, 331567, 197074, 394908, 394904, 385758, 394844, 385756, 394750, 394747, 379909, 394806, 254035, 390796, 394313, 390794, 379907, 390792, 394803, 394801, 227770, 227766, 394733, 394731, 392524, 379905, 227762, 227754, 227750, 215121, 215120, 23384, 239289, 394373, 239285, 394369, 348984, 355603, 23378, 23376, 393384, 227736, 394571, 239279, 394354, 394463, 394412, 394410, 394187, 320366, 355130, 239262, 394267, 323220, 394264, 394262, 394142, 394140, 394258, 394134, 394131, 355128, 227718, 394124, 323218, 227716, 394244, 394241, 394223, 394239, 394120, 394045, 394113, 393616, 394110, 394043, 394099, 215097, 394041, 394039, 393418, 394038, 239258, 227714, 388434, 215093, 227711, 227709, 394035, 271752, 394030, 394027, 394024, 378295, 355125, 378293, 355123, 393414, 215091, 197039, 393412, 393367, 394007, 394002, 323216, 323213, 393643, 393641, 393598, 393986, 355112, 393636, 379903, 393881, 393877, 393595, 393594, 393631, 392430, 366996, 393629, 393272, 393361, 323203, 393230, 393268, 393504, 393588, 197020, 392667, 393187, 197019, 315666, 392741, 325757, 392712, 392710, 315660, 392686, 227674, 161783, 391928, 161781, 325755, 325754, 392632, 392704, 392702, 239214, 239212, 271747, 392630, 239210, 239208, 392628, 392681, 392679, 315656, 161779, 392663, 315654, 360790, 392587, 239204, 215047, 197013, 392582, 392580, 215043, 197010, 315652, 239202, 344780, 239199, 227669, 320362, 392516, 392385, 392569, 349365, 392567, 389443, 392565, 197005, 392563, 392553, 315649, 392551, 392382, 392559, 315647, 392314, 315645, 383810, 392486, 383808, 392311, 392309, 376612, 196994, 392335, 392301, 385750, 385748, 106595, 390725, 161775, 391876, 391811, 391806, 391800, 391776, 391789, 391744, 239105, 391625, 389411, 391718, 389833, 387010, 391740, 385745, 391399, 385743, 391282, 390848, 239040, 323191, 239035, 174227, 390915, 391277, 390715, 391275, 227630, 391271, 391253, 227621, 616680, 390831, 174216, 174214, 616675, 616673, 390829, 616671, 379901, 214971, 390901, 389518, 388609, 389510, 390386, 250018, 389437, 390383, 389435, 227590, 390086, 387698, 387789, 390375, 227586, 389955, 388607, 390327, 390373, 375630, 375626, 196964, 383582, 614432, 196962, 390280, 239013, 389826, 390199, 389823, 386433, 253720, 106559, 308758, 308756, 389993, 238989, 389842, 238972, 387774, 389819, 110101, 389804, 238951, 238949, 196947, 389573, 106526, 386166, 238941, 389801, 238935, 238933, 271743, 387694, 382119, 271740, 389752, 382116, 384965, 238923, 196939, 271737, 238921, 271735, 271731, 271729, 23366, 389359, 320326, 389293, 389097, 388330, 388599, 375754, 387249, 387431, 387429, 387004, 387247, 378760, 386236, 388577, 383754, 389080, 387958, 387427, 387426, 375751, 308731, 385737, 214903, 387243, 388442, 388671, 388575, 109326, 388559, 385492, 196917, 388322, 238866, 388320, 387936, 238862, 387500, 387595, 227545, 214860, 196907, 387363, 387361, 214842, 386936, 387284, 214834, 384364, 387200, 308714, 386565, 106505, 387177, 369643, 386559, 386630, 384272, 386955, 386953, 386894, 386927, 386628, 386925, 386919, 386978, 386689, 227497, 308702, 214811, 161754, 227489, 379896, 227486, 381286, 348415, 386512, 386547, 196899, 386591, 379893, 386521, 196898, 386519, 227456, 386307, 227450, 227447, 383718, 227445, 183057, 183055, 227443, 214781, 376566, 348333, 256347, 238806, 348324, 238801, 386360, 385735, 379891, 385607, 385605, 379887, 350333, 350331, 385429, 385334, 385427, 324222, 384921, 385372, 324220, 308699, 379884, 196888, 385258, 385254, 385251, 385250, 323178, 383305, 323176, 238598, 384063, 366968, 383383, 303255, 379873, 384332, 366961, 377985, 214559, 359088, 383373, 359086, 359083, 383894, 383916, 383427, 383425, 359077, 383885, 365145, 274553, 383647, 274550, 383828, 383826, 377436, 330860, 330856, 330854, 330852, 330850, 383349, 303232, 383066, 383049, 382982, 382716, 383063, 383059, 383089, 378424, 382644, 379859, 382462, 214506, 377429, 333444, 382225, 379857, 379855, 333443, 333441, 370435, 379211, 376008, 379209, 378379, 333438, 378370, 196824, 196823, 378367, 378357, 333436, 370433, 379374, 379372, 379370, 308668, 196820, 381215, 381213, 370429, 330843, 320271, 320269, 320267, 196819, 378746, 378744, 370427, 214471, 370425, 333433, 379852, 196816, 370423, 333431, 379848, 379835, 238453, 379833, 379649, 379633, 379578, 379677, 379707, 379704, 379628, 379673, 379642, 379625, 379477, 379130, 379199, 379431, 379126, 333418, 333416, 350019, 196773, 238119, 368755, 237967, 237960, 237939, 196432, 364773, 285440, 323139, 365839, 362914, 365837, 324608, 365428, 105973, 331275, 237856, 237853, 365090, 226508, 365835, 362912, 325366, 365818, 365087, 226489, 237829, 365776, 365740, 365738, 365736, 237826, 323136, 237824, 213566, 365083, 213563, 213561, 196430, 213559, 196427, 237821, 213557, 105965, 237819, 365707, 237817, 328902, 252619, 328901, 226477, 328899, 328897, 226475, 360713, 328894, 360705, 360701, 332340, 213534, 213532, 364361, 213530, 364358, 364761, 196415, 303212, 303207, 364795, 332337, 196411, 196410, 357370, 196409, 364938, 364791, 357356, 364789, 350576, 339595, 357354, 360698, 364787, 364783, 357351, 357349, 362942, 364775, 303193, 303179, 277441, 226276, 361081, 196376, 237654, 361716, 361077, 196375, 196373, 196371, 350324, 252584, 359691, 237561, 237556, 361018, 226183, 303125, 359688, 361016, 226179, 360295, 323127, 358286, 323124, 360849, 360200, 303114, 614422, 196350, 360945, 355551, 325354, 303111, 360846, 335786, 360863, 360861, 360859, 360858, 213253, 213248, 303102, 344489, 344488, 303100, 360257, 303096, 226135, 360253, 341668, 360249, 196347, 226125, 226123, 360557, 196343, 350316, 226107, 325350, 237505, 196342, 358812, 359683, 213212, 196331, 360241, 105763, 359667, 359665, 327155, 358810, 196328, 226053, 237488, 354853, 333312, 355548, 237460, 225986, 105745, 348939, 105743, 105739, 105735, 105732, 324558, 237453, 358246, 355545, 359177, 359175, 237446, 359173, 359266, 359169, 354716, 358713, 358711, 358709, 358707, 358974, 358238, 358236, 225968, 213145, 225966, 346882, 358220, 213140, 358284, 358217, 358215, 358773, 358771, 213136, 328286, 213130, 358767, 237441, 196321, 358209, 128958, 237433, 354842, 237426, 213094, 331249, 237422, 213091, 331247, 358701, 225950, 237418, 358749, 237416, 237414, 358699, 344484, 358691, 237412, 358282, 237371, 237369, 358033, 252544, 358268, 358266, 237362, 355482, 358265, 358264, 237360, 358092, 105685, 358181, 355479, 348933, 358140, 328283, 358138, 357574, 358031, 350562, 358177, 350559, 350557, 324174, 357572, 323111, 358173, 358171, 237357, 358169, 237354, 358090, 354575, 354573, 354571, 354568, 225890, 357968, 357836, 237343, 225887, 325483, 196290, 354391, 354390, 196289, 357665, 196286, 342693, 357332, 196282, 196280, 196279, 356180, 196277, 196276, 237323, 329934, 329933, 329931, 329929, 329927, 329924, 329922, 329921, 329918, 329915, 329913, 329911, 357594, 357589, 357077, 357563, 342690, 196274, 355526, 196272, 357316, 357309, 357257, 333306, 357303, 357301, 357299, 357294, 333303, 355523, 333302, 333300, 333297, 344020, 357231, 355516, 355515, 212970, 357158, 212968, 131757, 355450, 357220, 212964, 357182, 131747, 225803, 357177, 196270, 356466, 356464, 356462, 356460, 356750, 225796, 357150, 357073, 212951, 225778, 225769, 333294, 225767, 237262, 355395, 353854, 348884, 237249, 196245, 356131, 356130, 196242, 342244, 348881, 356128, 196239, 196238, 333288, 191781, 196237, 333284, 212853, 322619, 333281, 354833, 348207, 355384, 355430, 356199, 353828, 354305, 354825, 354377, 237209, 339591, 355419, 350076, 355416, 354815, 354302, 346788, 332851, 355046, 310313, 310311, 128945, 346777, 310309, 212786, 354810, 354808, 196214, 332849, 212770, 354800, 207344, 354666, 354664, 354663, 348818, 348816, 348188, 348811, 354134, 212768, 196211, 268852, 268850, 354550, 268848, 268846, 268844, 268842, 354363, 212764, 354544, 333274, 128938, 354542, 333273, 352654, 348806, 237174, 237172, 333271, 237168, 348804, 237162, 354295, 354357, 354291, 352907, 333269, 352901, 310303, 352897, 267255, 333267, 334647, 315643, 225531, 252496, 353824, 353822, 105560, 315641, 350307, 353718, 334644, 225529, 315639, 237146, 105558, 237143, 105556, 333264, 353816, 212735, 353709, 353707, 252491, 237141, 252489, 225519, 237139, 105540, 353810, 105538, 105535, 353886, 353807, 267242, 352764, 333256, 353597, 338664, 303070, 352885, 353414, 353411, 196200, 347459, 353263, 350896, 353261, 352984, 352846, 350276, 351946, 352085, 350778, 350776, 350002, 350772, 350300, 333253, 352083, 351762, 268825, 268819, 338779, 352082, 352081, 268809, 268807, 237040, 212645, 351922, 351914, 351912, 351910, 342686, 225383, 351510, 225381, 338774, 196186, 351544, 196176, 196175, 338582, 196166, 277437, 350298, 277435, 351178, 303045, 351175, 225270, 225268, 131715, 131712, 212585, 350938, 333241, 350937, 340068, 346750, 346009, 350812, 350710, 350811, 350342, 350707, 350699, 350422, 350340, 350419, 332835, 350339, 225226, 252438, 350391, 350295, 350293, 350287, 350235, 350233, 347587, 347578, 350180, 349279, 350177, 349992, 212537, 212534, 205269, 324535, 349987, 349983, 225216, 349277, 334642, 59825, 196155, 225212, 349753, 350006, 349851, 349977, 334631, 349846, 225210, 334627, 236990, 349972, 347653, 347651, 348583, 349750, 196152, 349748, 310249, 348577, 225200, 225198, 225196, 349427, 225192, 349272, 349735, 131679, 349649, 196149, 349733, 225191, 314398, 349713, 349711, 347450, 347566, 225174, 349709, 196147, 196146, 349647, 331559, 346735, 349631, 349357, 348566, 348563, 348562, 347646, 348650, 348558, 346731, 346725, 252427, 348913, 348895, 196136, 345321, 252417, 310227, 338766, 348114, 131634, 347443, 236904, 347411, 346550, 346634, 346645, 196130, 346624, 346541, 332722, 344611, 333181, 184929, 128923, 345317, 345315, 332720, 332719, 345050, 344921, 344915, 329557, 342678, 196111, 196109, 310197, 310195, 310192, 310185, 310184, 310181, 310179, 310176, 310175, 323070, 343867, 343375, 343907, 343903, 343901, 343897, 339567, 343203, 339563, 331698, 196064, 196062, 341794, 341965, 341962, 341960, 339557, 341904, 341901, 339553, 341595, 339512, 339510, 262894, 339508, 339506, 339504, 341870, 341864, 236643, 128922, 341416, 340644, 340019, 340459, 340457, 340456, 340454, 340366, 339551, 340168, 339550, 236534, 340072, 340049, 340047, 236530, 236528, 224606, 236526, 340029, 339922, 339903, 339549, 339810, 339668, 339612, 339545, 339541, 196032, 339534, 336124, 265383, 252218, 317656, 338662, 338750, 338660, 338645, 252203, 252198, 338643, 323053, 335775, 338024, 337699, 337818, 337816, 337692, 337507, 313654, 313651, 337504, 336949, 337500, 336098, 336939, 333041, 333039, 7603, 265366, 336937, 333150, 265364, 333147, 334509, 333145, 333144, 337172, 236340, 211710, 337265, 333139, 336579, 224481, 224479, 277351, 236330, 236326, 337152, 336910, 285435, 334481, 334479, 336093, 334470, 334467, 336088, 335872, 333130, 335870, 334438, 335586, 334419, 335068, 334843, 315616, 334790, 334788, 334778, 334702, 334699, 332206, 332204, 334321, 224326, 334319, 334358, 332899, 334356, 332738, 317655, 334125, 211435, 195964, 333111, 195960, 314126, 333108, 333106, 314124, 314121, 332540, 332203, 332538, 332529, 332935, 332714, 332711, 252124, 332709, 332867, 332865, 332804, 332501, 332802, 332800, 332498, 224263, 332798, 332795, 332751, 332497, 332494, 332491, 332466, 332465, 332462, 332641, 332452, 332249, 332112, 332446, 128886, 205116, 332295, 332145, 330620, 105095, 105093, 278128, 332247, 323024, 330613, 330880, 29987, 332196, 325650, 325648, 331153, 328467, 331647, 331718, 323020, 331639, 306266, 330606, 330603, 297841, 330601, 329518, 328874, 328864, 195916, 314578, 287313, 195913, 328651, 328668, 327796, 328643, 314574, 323016, 314572, 310140, 328013, 328011, 310138, 305420, 328009, 328127, 328100, 328005, 211151, 327789, 327787, 327785, 282793, 327783, 327780, 327566, 327565, 327562, 318546, 318542, 310133, 131477, 131474, 263056, 326763, 310130, 326622, 252067, 326996, 326995, 326991, 326987, 324402, 326859, 326858, 326616, 326614, 310128, 318529, 326742, 304728, 321755, 321754, 321746, 318527, 307468, 210861, 278124))
Run Time: 0.085427
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 3920 | |
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 | | | | | 3920 | |
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 view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, v2�
Run Time: 0.000421
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000569
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.000792
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