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.000772
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.000463
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` = '10841')
LIMIT 1
Run Time: 0.000563
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.002547
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_10841' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.255377
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 (635915, 598953, 632348, 632330, 632346, 632344, 632342, 632328, 632322, 632305, 632317, 632294, 453805, 632274, 630168, 631990, 632237, 445934, 445931, 610282, 629895, 629893, 629891, 630167, 247116, 632188, 632081, 247113, 632186, 632109, 629889, 630166, 629887, 601128, 189121, 601127, 632156, 610277, 632147, 632106, 632104, 632116, 580600, 580599, 445920, 580597, 580594, 373135, 247100, 632085, 580591, 631259, 631035, 66643, 548500, 580589, 580584, 580581, 631033, 247097, 632038, 632036, 632052, 445908, 630872, 630870, 632032, 445889, 445885, 445881, 445878, 630868, 445864, 445862, 445855, 488677, 631994, 631878, 596094, 631898, 628993, 596092, 631872, 445850, 445848, 445845, 445843, 631944, 631893, 631942, 631890, 445826, 631868, 445824, 445820, 631937, 631933, 631280, 445812, 445809, 445807, 631271, 631837, 631268, 453798, 453796, 631834, 631786, 631825, 631781, 631812, 631808, 631791, 631772, 631770, 631754, 631752, 631744, 631741, 631738, 631499, 631497, 631491, 631489, 631487, 631485, 631483, 631481, 631477, 631475, 631473, 580573, 445795, 445794, 631722, 631700, 445785, 631696, 445765, 445762, 631674, 445760, 631691, 596086, 631428, 631423, 631420, 631415, 631411, 631685, 445754, 631395, 631664, 580571, 580567, 580565, 631385, 580563, 580561, 631383, 580559, 580555, 586611, 631369, 631366, 630952, 631643, 631332, 580973, 631207, 631640, 445693, 445690, 631302, 631300, 445683, 445681, 631298, 445679, 631296, 445675, 631289, 445673, 445669, 631253, 445667, 445663, 445658, 445654, 631235, 631231, 631202, 631199, 610276, 392478, 580549, 580544, 631229, 631226, 580534, 627909, 631191, 631173, 631169, 631138, 631133, 631130, 629339, 631155, 331433, 331426, 247095, 331422, 331417, 331412, 630165, 331407, 606776, 331400, 631078, 606774, 631052, 606772, 555211, 606769, 181008, 606766, 445637, 181006, 181004, 445625, 181002, 631044, 606762, 589707, 589705, 589703, 201161, 630409, 630994, 631011, 445614, 630402, 630947, 607463, 630935, 630400, 609944, 630388, 630921, 596079, 630916, 596077, 589695, 630866, 630877, 630844, 445559, 627703, 630836, 630613, 627701, 445555, 630846, 630823, 630805, 630774, 607425, 630786, 607421, 607405, 607402, 630675, 398421, 630642, 445540, 628021, 630615, 630601, 630589, 630587, 605406, 605400, 630568, 630161, 610275, 630553, 630561, 445516, 630559, 630544, 630540, 630534, 386096, 630485, 630483, 630356, 629750, 630480, 630523, 630478, 630475, 445514, 628697, 609316, 629878, 629876, 630469, 630467, 624179, 630440, 613965, 624174, 630428, 630426, 630417, 630414, 630383, 630378, 625388, 630160, 596070, 630372, 630347, 625383, 201155, 629873, 630365, 540342, 630341, 540340, 630328, 596067, 445509, 445506, 445504, 445502, 630159, 629872, 630308, 630158, 629870, 629868, 630157, 629866, 445491, 628257, 629581, 629579, 610274, 630048, 596057, 629865, 629863, 630142, 445460, 629715, 630102, 630100, 445456, 630022, 445454, 630067, 630045, 247075, 629856, 629851, 629848, 629844, 630019, 629842, 630040, 445448, 629839, 629837, 630035, 628312, 629835, 629833, 629819, 629817, 629808, 247060, 247054, 247051, 247049, 629790, 630032, 629763, 629730, 629778, 629783, 629746, 629727, 629744, 629725, 629723, 629711, 629689, 629686, 629691, 580528, 580525, 629684, 445426, 445424, 445422, 445420, 628620, 445419, 445413, 445408, 445405, 445398, 445396, 613443, 596055, 613436, 613432, 596048, 580520, 628882, 613427, 613424, 445378, 445376, 445373, 445371, 629110, 445367, 445363, 445360, 445355, 601668, 629536, 445348, 629420, 629417, 629542, 629414, 629546, 629544, 629534, 601116, 247044, 247042, 247040, 247037, 247028, 608472, 607398, 629507, 580509, 629500, 607397, 629487, 607395, 629481, 629477, 629464, 629462, 596043, 580499, 580497, 580495, 601113, 201148, 629404, 201142, 629402, 629399, 201139, 589324, 589321, 589319, 601111, 629367, 445343, 201136, 629363, 629347, 624152, 629329, 629327, 624150, 445337, 445335, 445333, 629296, 629284, 629279, 629288, 445320, 445316, 445314, 629275, 376734, 612303, 376732, 612301, 445311, 534356, 612299, 629264, 629262, 629253, 534352, 629208, 201130, 629211, 23526, 23524, 629202, 629041, 629038, 608471, 583491, 629167, 629165, 445301, 606394, 629105, 629101, 629097, 588954, 247020, 247016, 629088, 629034, 189095, 462504, 445297, 580480, 629055, 354535, 629053, 629070, 629061, 629059, 629057, 612707, 612705, 580471, 580466, 580463, 445294, 583478, 628986, 386093, 609931, 609929, 628975, 628972, 628955, 628951, 628194, 628910, 628892, 628890, 628906, 628917, 628904, 628915, 628913, 626952, 201118, 201116, 201112, 628584, 596026, 453783, 201097, 628577, 628575, 628571, 628568, 445284, 628865, 628888, 628885, 628830, 628559, 628845, 628824, 628553, 609385, 628550, 609383, 628542, 628539, 189085, 628768, 628810, 596023, 596021, 628782, 534315, 628779, 628762, 628741, 628755, 628746, 626583, 628737, 445277, 628729, 628725, 628713, 628707, 628703, 628695, 247003, 628604, 628669, 628665, 628663, 628535, 628658, 628532, 628601, 628513, 628528, 445273, 445270, 628516, 445267, 626322, 445263, 445261, 623629, 609379, 609377, 628505, 628479, 445259, 628422, 628491, 628448, 628380, 445250, 601099, 628420, 628407, 628417, 601095, 607393, 628397, 628395, 606388, 445242, 445237, 246995, 445230, 628373, 445222, 445219, 628339, 628357, 445215, 628354, 445210, 445205, 445202, 445198, 599344, 628229, 504897, 628225, 445189, 605681, 605678, 445187, 605674, 445184, 445182, 453778, 412582, 453773, 412579, 596016, 628289, 628177, 628280, 578480, 628251, 628274, 628272, 628270, 627651, 628249, 628247, 596014, 445171, 445167, 628211, 445163, 627522, 627519, 613420, 628206, 628204, 628202, 580449, 628200, 445160, 628198, 628185, 628189, 628183, 628180, 628174, 628170, 453770, 445149, 626696, 628131, 628138, 628160, 628147, 628145, 628142, 628112, 628125, 628109, 628107, 596010, 596008, 628122, 628105, 628120, 628116, 601090, 409664, 409662, 628100, 628097, 628092, 628079, 627498, 610270, 627854, 628048, 445133, 628043, 609923, 628036, 628028, 628006, 628026, 627850, 627998, 627959, 627952, 627901, 627493, 627892, 627884, 627882, 627817, 627880, 627878, 627838, 627836, 596001, 595999, 595997, 626974, 627833, 595994, 627829, 627809, 627798, 595989, 610876, 610874, 610872, 627790, 627788, 453768, 627091, 627488, 627485, 627483, 627776, 627534, 627669, 627730, 627712, 627691, 627667, 627234, 627649, 627646, 627643, 605667, 445087, 445084, 445082, 445079, 567915, 627640, 627590, 627633, 627300, 445048, 627297, 627295, 627291, 627607, 627458, 627289, 627286, 627283, 627281, 627442, 627434, 627379, 627376, 445019, 445007, 610269, 627054, 627307, 627304, 627177, 627120, 627117, 627115, 444986, 627209, 627202, 627206, 627200, 627195, 595974, 627193, 444974, 444972, 580445, 627173, 627042, 444963, 627050, 627039, 627078, 627074, 627024, 444949, 626992, 444939, 627000, 626987, 626766, 609916, 626976, 626935, 626858, 626924, 626886, 626884, 626673, 626672, 626849, 608210, 626831, 626829, 626827, 626820, 626824, 444920, 626816, 626813, 450404, 626811, 444915, 450401, 626795, 201079, 201077, 626664, 626761, 453763, 626661, 626715, 444900, 444897, 626708, 444892, 444887, 595966, 626773, 595963, 626729, 626725, 564957, 564955, 626685, 626687, 626681, 626654, 626625, 626613, 626607, 605452, 610265, 626595, 626599, 611092, 626505, 606385, 444877, 626532, 611088, 626538, 626510, 626529, 609908, 589492, 626487, 595956, 626482, 611445, 611443, 609906, 601081, 626374, 453762, 444869, 444868, 625170, 444861, 580443, 589303, 589299, 626436, 589290, 626414, 626422, 606384, 606382, 444853, 626398, 626395, 626391, 626382, 626370, 613785, 444827, 626352, 444821, 626348, 444816, 444812, 444806, 608468, 444800, 613415, 626260, 444793, 625934, 625929, 444785, 444783, 444780, 534264, 444778, 444776, 444774, 625925, 444770, 444765, 626275, 626311, 246982, 626035, 444744, 610262, 589017, 623624, 623622, 626298, 626257, 595946, 595944, 626267, 595942, 626251, 626244, 626227, 444741, 609901, 626144, 625801, 625799, 626141, 626138, 626136, 626134, 626132, 626130, 626128, 616095, 391992, 626191, 616093, 625795, 444728, 626119, 22835, 444722, 626051, 626077, 607382, 626075, 626015, 626010, 626022, 626005, 626001, 625998, 625996, 625981, 625554, 625951, 625949, 625792, 625989, 625971, 625969, 625715, 625958, 625942, 444685, 444681, 625916, 625904, 444677, 444672, 444670, 625867, 625788, 610260, 444667, 444661, 625863, 625861, 625418, 444650, 623620, 625850, 604476, 625811, 625774, 625770, 625768, 625766, 625603, 625779, 625194, 625192, 625595, 625188, 444614, 444606, 444597, 444594, 444590, 444583, 625639, 625637, 625727, 444555, 444545, 444542, 444539, 444537, 444529, 444525, 625667, 444520, 625698, 625577, 625722, 625574, 625703, 444502, 625584, 625660, 625643, 611428, 444487, 611420, 625535, 625541, 625608, 246963, 625509, 246958, 444453, 625507, 625490, 625500, 625342, 625338, 625482, 625477, 610259, 607380, 610256, 625459, 625450, 607378, 609062, 623614, 444416, 623612, 625433, 623609, 623606, 625375, 625306, 625303, 625369, 444392, 625325, 444389, 444384, 444381, 625353, 625320, 625351, 625349, 625271, 625347, 610244, 444377, 444374, 625344, 623935, 444370, 625277, 610241, 580394, 625243, 625249, 625217, 580373, 625196, 610240, 625181, 610237, 610235, 625156, 625152, 598818, 625147, 571135, 607230, 607376, 444318, 444309, 625131, 625127, 506491, 444307, 444306, 625109, 625119, 625114, 625117, 625104, 625101, 625091, 534133, 625077, 624417, 624414, 624412, 624356, 610234, 624368, 444257, 624340, 444219, 444214, 444198, 444196, 612296, 605662, 610233, 444182, 444178, 624298, 444152, 608461, 608453, 605398, 624270, 624250, 624209, 624191, 624189, 615785, 607371, 580350, 623968, 623966, 444098, 606377, 624011, 623957, 623889, 623887, 623885, 623927, 444065, 623906, 623500, 615007, 623922, 623901, 595928, 444058, 601073, 601071, 623897, 623894, 623892, 444047, 623876, 623868, 623858, 623853, 623871, 624105, 444032, 623803, 623800, 444004, 421781, 605397, 595924, 595920, 595913, 595910, 534000, 443992, 623604, 595907, 624098, 624095, 614998, 624091, 443964, 443956, 443943, 443927, 623782, 443916, 443913, 443909, 580345, 443906, 443899, 623763, 623761, 595892, 623755, 616086, 623751, 623749, 616160, 623747, 623733, 616084, 616082, 623731, 616079, 623710, 623708, 623587, 623688, 607370, 623440, 623252, 443872, 623678, 623439, 443864, 443862, 595887, 595885, 623435, 443853, 443851, 443840, 443834, 623432, 189030, 623429, 615717, 615713, 615976, 615968, 615966, 443824, 615964, 623426, 623658, 623656, 623411, 443813, 443810, 443802, 443798, 623668, 623466, 623662, 443783, 443781, 623462, 615956, 623457, 623649, 624088, 589016, 612315, 615950, 623534, 623532, 623530, 615944, 623527, 623517, 623513, 623507, 443762, 443758, 443756, 623452, 623450, 488934, 488932, 488927, 623423, 624085, 443745, 623391, 623405, 623346, 624076, 624072, 623381, 623378, 623375, 623373, 623370, 623339, 616334, 201047, 616332, 616253, 580340, 580338, 580337, 616304, 613538, 443722, 616286, 443718, 616284, 605442, 443712, 605440, 608439, 616271, 616266, 616264, 616262, 616259, 443708, 616250, 443701, 616248, 616226, 443699, 616244, 533897, 616240, 616220, 613089, 616218, 443689, 443685, 443682, 616215, 616211, 616209, 616207, 616204, 616201, 610232, 616199, 616195, 443675, 549763, 443670, 443668, 616193, 616191, 180994, 616139, 616137, 180989, 180987, 180983, 443656, 616149, 616127, 616124, 616118, 616116, 616112, 616109, 443647, 615903, 443633, 615991, 443630, 443627, 443625, 616074, 611404, 611402, 616030, 606022, 616007, 583199, 583197, 610231, 616001, 615928, 614214, 615893, 615898, 614209, 614202, 614200, 595874, 443559, 609270, 443555, 443537, 614183, 615870, 443512, 615858, 615867, 615854, 615851, 601054, 443496, 615809, 389720, 615599, 389717, 615773, 615596, 615771, 623238, 610228, 615797, 615768, 443461, 615705, 615754, 615695, 615689, 580328, 612277, 607864, 607367, 601049, 601047, 443404, 246905, 246902, 246897, 246890, 246875, 443386, 443384, 201023, 443380, 595868, 443377, 615632, 246870, 443365, 615619, 614941, 615595, 443349, 615608, 615612, 246863, 615606, 615593, 609860, 615587, 615583, 614135, 614133, 612845, 443329, 443325, 443308, 615535, 615533, 443300, 443295, 610226, 615474, 615468, 615462, 443279, 443276, 443272, 303, 286, 301, 284, 280, 278, 4717, 443266, 443263, 443255, 615518, 615514, 4711, 4709, 610223, 615454, 615485, 615452, 615434, 615422, 615420, 615411, 615501, 615498, 615495, 615493, 615408, 615406, 443231, 443229, 443226, 615404, 615401, 615397, 615392, 615390, 615387, 615383, 615379, 615368, 615359, 610220, 615354, 615085, 615081, 615078, 615349, 611121, 615071, 615066, 615064, 615062, 615055, 443196, 615050, 443193, 615047, 443187, 615107, 443185, 615105, 443180, 615099, 614926, 615096, 605646, 605639, 614922, 605637, 443163, 605634, 443155, 443148, 443145, 443142, 443140, 614916, 443136, 443131, 443127, 610219, 479232, 443114, 443106, 614992, 443103, 443093, 603946, 606373, 603944, 607013, 608540, 614973, 613950, 614938, 614936, 613947, 613938, 613936, 613934, 595864, 573735, 573733, 614049, 443049, 443041, 614863, 610216, 604738, 610214, 610211, 610208, 610205, 604734, 614860, 614903, 614845, 580321, 443021, 443009, 443000, 592734, 614883, 614868, 608537, 442983, 442979, 608534, 457964, 614878, 610203, 607008, 607005, 614813, 614803, 614798, 606372, 592727, 592724, 614786, 592714, 592709, 592707, 592705, 614774, 614772, 442950, 624053, 624052, 614784, 614767, 614770, 593651, 593649, 442925, 442915, 246841, 613527, 442873, 614063, 442861, 442859, 442855, 614061, 599514, 442832, 442826, 608942, 613821, 614047, 180976, 180965, 601030, 442814, 614043, 201011, 442800, 201009, 201007, 614039, 613718, 442771, 442767, 173632, 173630, 442761, 442756, 442753, 442751, 442749, 442746, 613992, 614036, 442744, 442741, 442736, 614017, 442722, 613890, 613885, 613882, 613879, 613987, 613874, 608437, 613977, 613862, 613960, 612496, 613954, 595859, 608434, 613597, 613908, 613906, 606368, 613522, 613518, 601023, 609371, 613594, 613852, 613849, 442690, 613845, 580305, 442688, 246830, 613574, 613572, 246827, 610201, 610199, 613809, 580296, 613807, 580291, 442685, 613569, 613799, 613796, 613792, 613789, 613754, 610601, 613727, 607366, 442678, 608934, 608932, 554443, 601020, 554440, 246823, 606365, 580289, 188973, 442653, 417916, 554439, 613685, 554436, 613511, 613677, 595851, 610196, 412568, 613674, 613669, 581356, 595849, 442631, 442628, 595846, 442622, 609858, 613586, 442610, 442608, 442602, 572900, 572897, 609848, 613555, 613551, 442593, 608928, 442590, 606362, 613488, 609225, 442583, 442580, 593749, 442578, 442574, 608429, 613404, 442572, 608427, 442565, 606356, 442563, 606355, 595837, 442552, 442550, 605323, 595835, 608421, 608418, 393077, 608412, 595831, 613385, 613087, 613381, 613377, 613375, 583114, 613370, 613367, 442526, 442517, 613356, 609529, 609527, 609525, 606351, 606349, 606347, 606345, 580279, 633425, 580277, 606341, 612387, 442513, 442510, 580270, 580266, 580260, 580257, 580253, 613316, 613286, 580246, 613284, 612837, 393073, 393072, 613281, 442500, 613291, 609842, 442496, 442495, 442490, 609840, 595830, 613266, 592142, 613261, 605627, 605626, 608347, 613186, 613157, 613164, 613108, 613151, 613149, 580240, 613131, 613126, 613112, 442434, 442431, 442412, 442410, 612982, 442404, 442402, 442400, 602026, 442379, 613039, 442376, 613037, 613029, 188966, 442349, 442344, 442339, 612976, 442328, 442315, 611297, 612941, 612950, 246788, 246787, 612477, 246785, 612471, 612927, 612469, 612465, 246783, 442258, 442256, 442250, 442245, 442217, 442216, 442212, 442209, 612915, 442197, 442193, 442189, 612681, 611473, 442186, 632285, 499606, 611469, 632283, 632280, 633419, 633415, 612758, 612807, 612787, 612753, 612732, 612784, 612782, 612776, 612772, 612748, 442155, 612746, 612728, 612745, 442133, 442131, 442129, 609367, 442127, 632785, 442122, 612533, 612739, 610525, 612737, 612688, 442113, 608955, 612651, 612660, 612618, 612641, 612616, 612639, 608921, 608918, 608911, 598567, 442078, 606337, 608092, 606334, 611378, 611372, 612555, 442056, 611369, 612546, 612273, 612271, 612256, 442050, 606330, 612526, 612524, 608907, 612521, 612519, 612517, 612250, 606327, 608905, 442037, 606324, 608903, 606323, 609516, 609512, 609510, 609508, 609502, 609497, 609494, 442008, 442006, 612499, 612243, 612493, 612241, 612453, 612448, 607360, 612339, 612446, 612444, 605392, 595813, 612233, 612335, 612333, 612231, 595805, 612329, 612324, 441966, 605382, 606177, 612212, 612209, 612205, 612203, 604683, 604677, 612171, 608898, 611356, 612192, 441947, 331884, 612023, 612141, 612131, 612126, 441944, 612124, 612111, 611621, 612103, 612099, 493216, 493214, 612096, 493212, 612093, 612090, 612086, 493204, 612064, 612060, 612057, 612018, 441896, 611977, 608204, 441880, 611930, 611935, 611601, 296292, 611928, 611916, 611924, 605378, 441867, 611907, 441865, 611879, 421775, 441845, 611840, 610803, 610801, 611846, 441829, 533333, 611599, 207581, 611565, 441782, 441779, 441771, 441767, 611213, 611212, 608757, 611209, 608755, 611206, 608753, 608751, 605309, 608746, 611531, 605369, 608743, 605367, 441753, 133351, 611517, 611523, 611199, 611197, 200989, 611488, 611486, 200987, 393067, 608346, 611329, 611327, 611477, 611465, 611461, 611323, 441697, 611316, 441688, 441685, 611304, 140333, 493193, 605303, 441673, 441669, 441665, 441663, 605300, 441661, 441659, 441657, 605295, 554431, 611249, 611246, 611074, 611068, 611242, 611238, 400767, 611118, 610909, 453157, 610907, 610904, 610901, 611192, 611184, 611182, 610898, 611132, 611159, 441639, 441637, 441635, 611064, 441631, 611047, 611041, 611039, 611037, 611033, 611113, 611111, 611106, 611104, 611024, 611022, 611020, 608626, 608624, 611002, 441598, 608185, 441592, 441580, 441577, 441575, 222474, 441572, 222468, 610928, 222457, 441570, 610925, 441563, 441560, 441555, 595759, 441552, 200984, 610893, 200982, 610542, 441541, 200980, 441534, 441528, 441516, 441512, 472708, 441501, 610835, 610830, 441493, 595754, 595751, 610682, 246727, 597370, 610787, 610859, 595748, 222455, 610672, 597368, 597366, 595744, 610782, 536469, 578256, 597361, 595740, 597357, 597355, 536467, 536465, 610828, 610825, 597350, 578252, 610772, 610770, 610821, 610768, 610811, 386084, 441481, 607358, 610760, 610757, 604000, 603998, 449870, 441473, 595733, 595729, 595727, 578241, 610726, 441465, 449867, 441463, 441456, 441454, 200972, 610629, 610512, 441428, 554428, 441416, 441404, 441402, 441396, 610484, 623160, 610364, 610413, 611752, 611735, 378182, 608077, 603426, 611728, 611725, 610403, 610401, 610398, 610388, 610385, 610435, 610378, 611720, 610375, 582987, 605820, 597248, 533161, 608565, 608563, 602854, 610192, 608557, 608554, 608552, 602846, 600990, 602843, 610189, 611710, 610187, 611707, 611698, 611696, 600987, 455500, 455495, 441362, 455492, 466839, 455487, 609643, 466836, 610158, 609134, 441355, 363568, 441353, 610150, 610146, 610144, 595715, 610140, 610136, 610098, 610096, 414245, 609634, 414243, 414241, 610091, 610002, 609097, 610087, 378181, 441345, 441343, 609750, 610050, 610027, 610025, 26407, 600849, 133348, 610034, 610021, 609625, 610039, 610019, 610031, 610016, 610013, 441327, 610009, 609993, 609720, 441317, 441314, 609740, 441311, 607357, 441308, 609724, 597240, 609734, 609717, 609683, 609547, 609545, 609543, 609541, 609539, 609537, 609680, 608894, 609695, 396182, 396180, 609702, 609700, 609675, 609535, 609672, 576523, 596594, 576521, 609611, 609609, 609570, 609566, 609564, 609598, 609593, 609556, 596587, 609580, 609554, 596584, 609578, 609576, 609574, 596582, 609572, 609550, 609534, 609460, 597117, 609531, 51336, 51332, 51330, 609491, 609489, 609487, 441305, 609479, 481383, 481381, 609445, 609309, 609413, 609438, 609300, 609434, 609419, 609409, 609339, 609329, 441295, 609302, 609290, 605360, 608312, 609284, 601964, 606322, 609249, 608406, 608404, 608402, 608400, 608397, 598029, 609054, 609195, 609160, 608891, 578103, 609153, 598027, 609048, 609043, 607576, 133343, 133341, 133337, 133333, 609144, 133331, 133327, 441272, 133325, 388375, 608739, 608736, 608863, 608861, 609129, 590066, 609091, 607354, 609088, 624036, 606807, 441251, 606803, 608997, 606801, 593920, 609034, 595703, 595700, 606517, 595698, 582969, 595696, 441245, 608859, 608968, 595695, 441242, 608873, 554425, 600986, 608974, 582966, 608832, 608729, 608619, 608396, 608825, 608856, 608850, 608848, 608818, 608657, 608788, 608785, 595689, 594560, 595684, 608781, 608720, 608595, 608771, 607348, 608714, 608072, 608703, 608614, 608646, 453742, 608604, 608639, 604360, 608592, 608608, 608601, 608581, 603938, 608393, 608391, 608388, 603932, 608570, 334657, 334655, 334653, 608379, 608374, 607710, 608067, 608526, 608524, 608371, 607063, 608357, 598096, 607294, 605816, 608331, 441223, 607291, 441220, 441217, 597232, 607289, 441215, 441210, 441207, 604475, 608322, 600804, 600798, 600796, 600793, 441192, 441189, 441186, 441183, 200957, 606442, 608289, 608296, 608152, 595679, 612695, 608063, 441173, 608132, 608130, 608128, 441159, 608124, 608117, 608115, 608221, 608220, 608218, 533001, 608136, 608105, 608048, 606057, 608036, 441147, 608025, 608021, 607804, 441145, 133317, 133315, 607764, 607959, 607775, 607972, 607970, 607772, 607641, 607129, 607127, 607767, 607344, 441140, 607788, 441136, 200955, 607759, 607633, 582933, 607752, 607629, 615530, 604474, 607715, 607688, 354526, 607696, 607692, 188950, 606318, 607682, 554420, 607669, 592694, 188946, 188944, 607658, 607661, 607655, 607624, 441127, 589014, 592692, 605355, 441124, 441122, 441117, 592212, 607586, 582922, 441114, 582919, 605624, 441112, 607571, 607569, 441109, 607567, 441107, 441105, 607565, 607543, 607559, 349626, 605353, 441101, 605349, 441087, 441085, 607342, 441084, 441082, 441079, 606279, 606019, 377216, 441074, 441068, 441065, 607264, 606437, 607260, 499500, 441053, 596954, 603481, 607227, 607249, 603467, 607195, 603465, 603463, 603454, 606759, 607224, 607192, 200951, 607188, 607186, 347351, 441016, 607184, 200946, 607180, 607178, 607142, 607057, 607052, 607091, 607088, 607086, 607083, 606799, 606973, 607036, 603930, 607034, 601393, 600713, 606972, 440991, 606874, 440982, 606937, 440980, 440977, 606872, 606869, 606893, 606900, 606889, 606883, 606836, 606866, 595655, 440969, 595652, 606788, 440965, 440963, 440961, 440959, 595648, 554414, 440956, 595643, 109250, 440950, 440948, 440946, 595641, 606051, 600710, 606757, 606755, 440943, 600707, 600702, 600699, 606715, 407983, 440939, 554412, 606671, 606668, 440927, 604358, 606712, 605346, 606665, 606661, 606554, 440922, 606653, 440917, 606639, 440914, 602005, 440908, 414217, 440902, 440898, 606573, 603450, 606566, 440888, 606564, 606513, 606509, 606560, 440883, 606314, 606500, 606311, 606498, 604357, 606236, 606234, 414211, 414209, 606486, 600978, 440879, 606478, 606193, 595626, 606274, 440878, 595624, 606305, 440875, 440873, 606302, 606434, 604473, 440869, 606452, 606263, 606429, 606424, 606296, 600976, 440857, 606294, 595620, 595618, 595616, 554392, 602737, 606228, 554390, 440846, 595608, 554388, 595600, 133312, 606184, 602043, 606152, 331392, 200933, 580219, 606199, 606180, 606166, 602040, 606173, 606163, 440843, 605813, 606134, 440839, 606149, 440837, 329398, 133310, 440835, 606139, 597229, 597224, 606074, 605997, 246709, 606067, 246698, 605994, 605951, 246697, 605986, 595594, 595592, 603447, 246691, 600043, 246687, 440827, 532875, 605967, 605886, 605940, 133307, 600040, 605879, 605875, 605931, 605918, 133304, 532872, 582842, 605902, 605859, 582837, 440794, 440792, 440789, 605836, 440780, 582833, 605802, 605602, 605799, 605597, 605595, 605795, 440776, 605792, 605773, 605791, 605536, 605533, 582829, 605780, 605706, 600479, 582824, 582821, 582814, 582812, 440755, 440746, 605545, 554379, 605574, 600461, 605529, 605543, 605117, 440724, 440722, 605549, 440719, 440717, 605522, 603997, 582798, 602546, 602544, 602541, 602539, 602537, 602535, 602533, 440713, 602529, 602527, 602525, 602523, 599508, 604354, 604471, 599506, 602512, 440709, 605518, 605282, 604470, 604469, 605514, 605512, 605506, 605500, 605498, 599504, 440706, 605475, 605473, 605466, 604413, 605275, 605328, 440698, 605172, 605170, 605266, 605222, 605167, 440691, 440690, 605164, 440688, 599502, 604352, 440686, 599499, 599497, 604349, 605094, 604916, 604914, 604409, 605136, 604407, 604405, 605089, 602166, 604347, 604345, 535453, 440678, 535450, 440676, 604046, 605085, 604340, 535444, 605016, 440669, 604338, 604911, 535441, 604042, 605050, 602251, 440662, 440660, 599315, 600447, 440652, 600444, 604903, 604402, 604900, 604221, 604400, 440639, 109245, 587600, 605032, 605039, 109237, 605036, 605010, 604869, 440635, 532839, 394078, 440629, 604337, 605027, 604866, 604334, 440622, 532837, 440620, 605023, 604864, 200912, 604862, 603993, 440616, 605008, 604987, 440614, 440613, 361106, 602734, 604940, 602710, 580216, 580213, 604928, 580211, 580207, 440592, 604763, 604761, 421770, 421768, 604907, 394075, 604840, 604468, 200911, 604807, 394071, 604264, 604892, 378802, 604852, 604801, 604858, 604821, 604798, 604796, 246679, 440578, 440570, 587598, 440559, 440557, 440555, 604332, 440553, 440551, 600437, 600435, 604782, 604775, 604726, 604757, 596931, 604330, 604328, 604754, 604325, 604748, 604322, 604746, 604319, 604744, 440535, 603927, 603924, 604391, 604466, 604164, 604384, 604649, 532805, 532803, 532802, 532800, 600433, 440510, 440504, 604633, 595577, 595575, 595573, 604500, 440501, 189224, 440493, 440489, 604310, 440484, 604428, 539561, 604434, 592465, 604442, 604426, 440469, 592691, 189221, 604262, 440462, 599036, 604218, 604273, 604144, 604138, 604259, 604257, 604123, 604188, 604117, 604115, 599034, 604113, 604096, 604181, 603919, 604064, 440453, 246671, 603030, 604091, 603991, 603989, 604067, 604078, 604075, 604054, 604062, 604060, 604026, 440441, 603986, 603903, 590062, 602250, 602248, 602246, 603949, 602244, 599493, 603916, 603914, 603091, 592690, 623077, 599490, 603495, 599488, 582713, 602237, 603232, 602952, 603362, 603387, 603855, 603490, 603438, 603380, 603324, 603499, 603414, 603417, 603360, 600945, 603358, 532764, 572891, 603379, 603376, 532756, 603025, 603355, 603334, 603346, 603348, 603212, 532748, 440423, 440416, 603340, 532746, 603309, 603306, 603304, 532745, 603320, 602925, 603328, 440413, 603302, 603297, 596731, 440407, 602155, 602153, 602150, 582699, 603227, 582696, 603289, 603284, 603193, 440401, 603224, 589662, 495591, 603191, 603163, 603160, 603156, 440399, 603152, 603148, 329389, 603112, 601737, 603075, 440397, 603073, 440391, 603067, 603078, 440389, 440387, 440379, 486321, 593633, 603058, 602236, 532734, 440373, 440371, 602031, 440370, 597854, 593624, 600926, 532732, 440369, 520747, 602949, 602978, 602943, 602955, 600431, 440364, 602938, 600421, 600418, 600410, 440353, 599068, 602929, 601375, 440349, 602899, 602897, 602893, 595199, 440346, 602877, 602887, 602885, 595196, 602810, 602862, 602793, 602790, 602788, 602671, 602669, 602233, 602664, 602662, 602231, 602229, 602227, 602656, 602224, 602724, 602222, 602653, 602651, 602649, 600406, 532726, 602768, 602765, 602732, 602729, 532725, 599486, 602510, 602506, 599484, 599482, 602030, 600920, 602575, 582644, 600918, 602505, 602503, 602648, 602500, 372045, 602624, 600916, 602612, 582637, 582633, 599028, 440336, 582631, 440333, 602608, 602604, 602583, 602581, 582619, 602601, 602589, 602598, 602595, 602587, 602592, 440330, 602447, 602445, 589383, 602556, 602554, 600914, 600912, 602568, 602441, 602566, 602436, 602432, 440326, 602496, 554378, 602429, 602424, 602473, 602469, 602418, 602416, 602411, 602453, 602407, 602401, 488694, 602398, 602396, 600034, 602394, 602390, 440323, 602385, 602377, 602261, 602290, 602220, 602339, 602213, 602275, 602211, 602303, 593227, 602334, 602331, 602329, 602325, 600397, 601599, 593224, 602259, 554372, 602257, 602161, 600392, 602209, 602312, 602204, 314787, 602197, 602195, 602141, 601595, 602138, 602134, 602130, 600386, 602127, 599019, 601883, 554370, 554366, 599016, 602079, 602108, 602101, 602072, 602068, 601989, 602054, 532705, 601572, 582526, 601975, 601568, 601566, 601967, 440305, 601427, 314783, 314776, 599479, 440303, 497512, 440300, 601951, 544200, 544198, 580200, 600368, 575847, 575845, 600362, 601426, 601941, 600355, 600352, 580197, 600349, 580195, 601919, 440288, 440279, 440277, 440275, 600341, 440269, 601422, 601420, 314771, 599475, 601615, 601909, 601868, 601418, 580189, 314766, 601864, 516759, 601880, 600131, 601878, 601876, 582454, 601853, 600330, 440259, 601799, 601817, 601797, 600109, 601740, 600899, 601726, 601729, 601724, 601721, 601719, 600326, 600319, 601709, 601713, 601637, 601633, 601631, 600313, 601628, 601416, 601471, 601561, 601414, 506478, 601469, 601467, 601412, 554754, 440257, 601556, 599473, 599471, 599013, 440256, 601549, 601540, 600308, 600302, 206236, 440254, 601539, 601483, 600300, 600298, 440250, 440247, 440245, 601499, 601494, 601492, 601477, 601490, 601411, 601409, 601487, 601459, 601407, 601473, 440239, 440237, 601404, 601402, 601456, 601400, 601388, 601451, 440234, 601445, 601429, 593205, 600895, 601440, 601438, 601432, 601398, 440232, 601361, 595563, 440223, 601396, 440218, 595559, 601382, 595557, 595553, 599910, 595550, 595548, 601367, 601356, 601352, 77208, 77206, 601319, 601317, 77204, 440209, 600887, 600292, 600289, 601309, 600284, 601295, 601293, 600881, 600867, 600720, 600872, 440203, 440199, 440196, 600786, 600781, 600763, 600600, 600690, 599466, 440178, 508149, 600567, 600549, 599649, 596577, 596568, 596565, 596562, 596559, 600512, 599978, 596556, 600280, 596553, 600278, 600276, 200900, 600533, 600490, 600523, 600493, 440162, 600270, 440157, 600195, 548404, 200899, 600102, 599464, 440151, 599011, 599461, 440147, 440145, 600076, 594635, 440142, 599996, 440140, 599008, 440135, 599006, 600057, 440121, 440118, 598212, 600017, 440114, 440109, 440101, 600023, 599004, 599970, 600007, 460068, 599992, 599989, 593127, 595189, 593125, 593120, 591786, 593115, 593114, 599715, 200895, 599948, 599945, 599459, 599905, 599954, 599935, 599932, 597851, 597846, 599891, 614959, 614951, 599887, 599458, 599824, 614949, 599819, 599812, 599457, 532603, 599711, 599776, 440075, 440071, 599455, 599003, 440069, 599001, 440066, 598342, 599705, 599644, 598339, 599633, 404747, 599435, 599667, 440037, 599629, 599659, 599614, 439998, 580179, 599427, 598984, 598978, 598973, 595177, 580177, 580174, 598966, 349609, 349607, 598960, 580171, 349605, 599393, 597629, 598956, 439966, 439964, 392955, 392953, 392951, 392945, 392943, 392938, 439956, 599389, 599405, 599386, 599384, 599377, 599381, 599370, 596730, 596728, 599238, 599234, 599230, 599221, 599219, 599216, 439941, 439939, 532590, 439937, 595170, 595167, 473646, 599122, 569047, 439915, 439912, 599099, 439908, 439906, 439901, 439897, 409708, 599090, 596617, 597544, 598949, 597542, 200885, 598927, 598901, 439893, 598940, 439891, 597923, 598925, 596615, 598921, 598915, 592189, 598840, 598833, 580162, 598811, 584661, 598785, 598582, 598781, 517457, 200878, 200876, 598764, 439875, 598633, 597801, 597798, 597794, 598609, 439847, 439844, 598597, 439843, 591761, 439838, 598501, 598493, 597842, 598484, 598482, 592106, 598424, 598476, 598480, 597840, 598398, 439811, 597920, 597918, 439808, 439805, 439803, 439791, 592617, 592615, 592613, 439764, 439759, 439758, 598258, 439755, 439753, 598255, 439751, 439748, 439745, 439740, 439739, 439736, 597912, 598184, 598182, 597906, 597903, 597901, 597898, 597622, 597891, 594535, 597889, 439728, 598100, 597836, 597821, 597863, 200868, 597612, 439635, 439633, 439631, 246665, 439628, 597547, 595150, 439576, 439572, 439560, 580152, 580148, 597210, 597205, 595499, 439532, 439530, 439526, 597286, 594737, 439495, 439488, 439476, 439471, 439469, 439467, 439464, 439461, 439458, 532518, 439455, 596911, 596909, 596905, 439454, 439451, 439449, 439447, 439445, 439443, 439431, 439428, 596825, 596821, 596817, 596795, 439410, 491111, 596792, 491109, 596789, 594354, 594350, 439400, 596735, 596656, 596463, 596629, 596457, 596454, 581331, 439370, 581320, 596444, 595481, 439348, 595330, 581311, 581309, 581296, 535440, 581293, 581287, 581285, 581272, 439329, 439315, 595238, 588784, 595235, 588782, 595233, 473633, 439313, 595126, 439303, 439301, 439296, 439294, 595073, 133277, 594444, 133271, 595031, 594438, 133264, 595018, 594991, 439281, 554281, 594781, 594705, 594674, 594663, 594598, 594594, 594587, 527975, 527970, 527968, 527966, 527964, 527961, 527958, 591032, 591030, 580145, 594366, 580125, 594167, 592656, 594163, 439166, 439163, 593777, 593964, 593939, 593937, 439139, 439134, 593822, 593872, 439127, 439123, 593766, 593763, 439110, 439106, 439101, 439099, 439092, 439089, 439074, 439072, 439068, 439063, 439061, 439056, 593693, 593686, 580123, 580117, 580114, 593467, 593464, 593105, 593214, 593198, 593168, 593165, 246658, 593162, 593159, 593103, 590717, 246655, 593013, 593008, 593002, 592944, 592942, 592996, 592940, 439037, 439033, 439028, 439025, 592635, 592631, 378170, 592624, 439012, 439010, 439006, 439004, 439002, 439001, 438966, 438960, 592437, 592414, 592462, 592432, 592408, 577838, 438944, 592282, 438942, 438936, 592182, 438934, 592179, 438914, 200852, 527915, 527912, 527910, 527905, 527902, 591338, 527898, 527896, 527893, 527891, 527889, 561633, 527876, 527874, 527869, 527865, 200849, 527851, 493334, 527843, 527841, 591332, 246648, 397463, 397461, 246647, 586128, 586126, 438791, 438777, 517424, 438760, 133242, 517422, 438737, 591194, 590999, 554258, 590296, 590294, 589928, 438613, 438609, 438598, 589925, 589916, 438580, 589912, 589910, 438577, 438575, 438570, 532061, 590578, 554236, 589906, 589889, 589884, 589875, 246583, 438467, 438456, 438448, 438444, 580034, 580030, 246570, 580018, 438406, 580015, 590319, 438337, 438331, 438322, 438319, 438317, 438315, 438310, 438308, 438299, 438293, 438291, 579960, 586740, 387869, 387864, 387862, 387859, 387857, 586738, 438195, 438180, 438178, 438175, 579842, 576511, 579817, 579781, 246503, 590179, 590106, 590103, 590101, 590100, 590095, 437875, 590093, 590091, 590089, 590087, 437851, 437823, 589856, 589854, 589851, 589989, 589987, 589838, 589826, 589809, 579674, 579672, 579663, 406502, 625044, 589184, 589182, 589125, 589120, 578681, 589036, 570358, 579596, 579594, 406477, 406475, 579592, 579590, 406471, 406466, 406460, 406458, 588414, 588386, 588377, 588375, 588372, 570350, 554213, 588866, 588864, 554211, 554209, 588862, 554201, 588851, 588201, 588170, 588158, 588155, 588598, 587311, 587309, 188888, 437118, 587638, 587759, 437070, 587722, 587720, 437064, 437055, 587660, 437053, 587697, 437043, 437010, 437008, 437001, 436993, 436966, 436894, 246138, 587412, 436860, 436857, 436765, 573531, 587039, 586917, 586908, 200744, 587027, 587001, 586999, 586996, 586994, 586992, 586990, 586987, 586980, 586974, 586972, 586970, 586966, 586963, 586959, 586955, 174383, 579521, 109096, 579518, 586725, 109079, 586546, 221688, 398842, 585045, 586531, 586588, 586583, 436478, 436473, 436330, 578392, 436268, 579382, 562877, 579337, 361101, 585367, 109042, 436231, 471329, 471327, 436206, 436202, 579332, 579330, 436181, 436174, 436170, 436162, 436158, 436147, 436145, 436141, 436135, 585234, 585206, 585232, 436124, 436117, 309777, 309775, 309755, 585078, 585069, 558073, 584800, 579298, 435871, 584721, 584368, 584714, 584707, 584704, 584702, 584699, 584693, 584679, 579288, 369254, 584568, 584440, 435803, 435801, 435799, 579265, 584438, 584436, 576909, 581950, 579255, 435791, 579047, 435231, 435229, 124265, 124263, 124261, 481796, 481793, 578845, 578842, 578831, 542178, 578798, 578794, 578766, 542173, 245753, 435042, 435037, 485947, 435006, 549753, 578604, 79565, 578600, 578548, 578184, 578181, 578211, 578180, 578169, 578167, 578163, 578161, 434939, 314693, 314688, 434773, 549746, 549744, 549742, 234958, 234955, 527777, 234953, 234945, 234943, 577360, 314684, 314678, 527766, 377199, 221087))
Run Time: 0.200644
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4470 | |
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 | | | | | 4470 | |
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 (34523, 34118, 34108, 34079, 34056, 34050, 34042, 33905, 33886, 33880, 33800, 33729, 33721, 33719, 33718, 33703, 33701, 33689, 33686, 33684, 33588, 33554, 33538, 33475, 33463, 33439, 33428, 33399, 33398, 33386, 33380, 33359, 33342, 33317, 33313, 33292, 33282, 33270, 33210, 33208, 33195, 33175, 33157, 33142, 33133, 33110, 33002, 32987, 32864, 32859, 32796, 32789, 32765, 32718, 32696, 32699, 32624, 32615, 32607, 32583, 32582, 32552, 32526, 33080, 32509, 32502, 32473, 32452, 32438, 32391, 32393, 32390, 32386, 32385, 32381, 32380, 32379, 32372, 32351, 32326, 32309, 32295, 32298, 32308, 32296, 32297, 35116, 32284, 32285, 32286, 32287, 35117, 35118, 35119, 35120, 35121, 35122, 35125, 35126, 32261, 32246, 32236, 32201, 32200, 32199, 32193, 32192, 32191, 32234, 32190, 32172, 32169, 32228, 32163, 32162, 32156, 32132, 32130, 32129, 32091, 32089, 32079, 32075, 32052, 32213, 32051, 32039, 32037, 32034, 32033, 32027, 32024, 32022, 32019, 32007, 32003, 32002, 32001, 31990, 31986, 32233, 31984, 31979, 31973, 31965, 31952, 31950, 31948, 31942, 32232, 31927, 31926, 31923, 31919, 31901, 31895, 31888, 31887, 31883, 31882, 31880, 31858, 31829, 33665, 31809, 31808, 31795, 31788, 31777, 31769, 31762, 31740, 31726, 31720, 31719, 31700, 31662, 31661, 31635, 31552, 31539, 31500, 31477, 31416, 31195, 31160, 31118, 31088, 30989, 30943, 30880, 30868, 30712, 30683, 30603, 30531, 30374, 30291))
Run Time: 0.015971
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 198 | 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 (635915, 598953, 632348, 632330, 632346, 632344, 632342, 632328, 632322, 632305, 632317, 632294, 453805, 632274, 630168, 631990, 632237, 445934, 445931, 610282, 629895, 629893, 629891, 630167, 247116, 632188, 632081, 247113, 632186, 632109, 629889, 630166, 629887, 601128, 189121, 601127, 632156, 610277, 632147, 632106, 632104, 632116, 580600, 580599, 445920, 580597, 580594, 373135, 247100, 632085, 580591, 631259, 631035, 66643, 548500, 580589, 580584, 580581, 631033, 247097, 632038, 632036, 632052, 445908, 630872, 630870, 632032, 445889, 445885, 445881, 445878, 630868, 445864, 445862, 445855, 488677, 631994, 631878, 596094, 631898, 628993, 596092, 631872, 445850, 445848, 445845, 445843, 631944, 631893, 631942, 631890, 445826, 631868, 445824, 445820, 631937, 631933, 631280, 445812, 445809, 445807, 631271, 631837, 631268, 453798, 453796, 631834, 631786, 631825, 631781, 631812, 631808, 631791, 631772, 631770, 631754, 631752, 631744, 631741, 631738, 631499, 631497, 631491, 631489, 631487, 631485, 631483, 631481, 631477, 631475, 631473, 580573, 445795, 445794, 631722, 631700, 445785, 631696, 445765, 445762, 631674, 445760, 631691, 596086, 631428, 631423, 631420, 631415, 631411, 631685, 445754, 631395, 631664, 580571, 580567, 580565, 631385, 580563, 580561, 631383, 580559, 580555, 586611, 631369, 631366, 630952, 631643, 631332, 580973, 631207, 631640, 445693, 445690, 631302, 631300, 445683, 445681, 631298, 445679, 631296, 445675, 631289, 445673, 445669, 631253, 445667, 445663, 445658, 445654, 631235, 631231, 631202, 631199, 610276, 392478, 580549, 580544, 631229, 631226, 580534, 627909, 631191, 631173, 631169, 631138, 631133, 631130, 629339, 631155, 331433, 331426, 247095, 331422, 331417, 331412, 630165, 331407, 606776, 331400, 631078, 606774, 631052, 606772, 555211, 606769, 181008, 606766, 445637, 181006, 181004, 445625, 181002, 631044, 606762, 589707, 589705, 589703, 201161, 630409, 630994, 631011, 445614, 630402, 630947, 607463, 630935, 630400, 609944, 630388, 630921, 596079, 630916, 596077, 589695, 630866, 630877, 630844, 445559, 627703, 630836, 630613, 627701, 445555, 630846, 630823, 630805, 630774, 607425, 630786, 607421, 607405, 607402, 630675, 398421, 630642, 445540, 628021, 630615, 630601, 630589, 630587, 605406, 605400, 630568, 630161, 610275, 630553, 630561, 445516, 630559, 630544, 630540, 630534, 386096, 630485, 630483, 630356, 629750, 630480, 630523, 630478, 630475, 445514, 628697, 609316, 629878, 629876, 630469, 630467, 624179, 630440, 613965, 624174, 630428, 630426, 630417, 630414, 630383, 630378, 625388, 630160, 596070, 630372, 630347, 625383, 201155, 629873, 630365, 540342, 630341, 540340, 630328, 596067, 445509, 445506, 445504, 445502, 630159, 629872, 630308, 630158, 629870, 629868, 630157, 629866, 445491, 628257, 629581, 629579, 610274, 630048, 596057, 629865, 629863, 630142, 445460, 629715, 630102, 630100, 445456, 630022, 445454, 630067, 630045, 247075, 629856, 629851, 629848, 629844, 630019, 629842, 630040, 445448, 629839, 629837, 630035, 628312, 629835, 629833, 629819, 629817, 629808, 247060, 247054, 247051, 247049, 629790, 630032, 629763, 629730, 629778, 629783, 629746, 629727, 629744, 629725, 629723, 629711, 629689, 629686, 629691, 580528, 580525, 629684, 445426, 445424, 445422, 445420, 628620, 445419, 445413, 445408, 445405, 445398, 445396, 613443, 596055, 613436, 613432, 596048, 580520, 628882, 613427, 613424, 445378, 445376, 445373, 445371, 629110, 445367, 445363, 445360, 445355, 601668, 629536, 445348, 629420, 629417, 629542, 629414, 629546, 629544, 629534, 601116, 247044, 247042, 247040, 247037, 247028, 608472, 607398, 629507, 580509, 629500, 607397, 629487, 607395, 629481, 629477, 629464, 629462, 596043, 580499, 580497, 580495, 601113, 201148, 629404, 201142, 629402, 629399, 201139, 589324, 589321, 589319, 601111, 629367, 445343, 201136, 629363, 629347, 624152, 629329, 629327, 624150, 445337, 445335, 445333, 629296, 629284, 629279, 629288, 445320, 445316, 445314, 629275, 376734, 612303, 376732, 612301, 445311, 534356, 612299, 629264, 629262, 629253, 534352, 629208, 201130, 629211, 23526, 23524, 629202, 629041, 629038, 608471, 583491, 629167, 629165, 445301, 606394, 629105, 629101, 629097, 588954, 247020, 247016, 629088, 629034, 189095, 462504, 445297, 580480, 629055, 354535, 629053, 629070, 629061, 629059, 629057, 612707, 612705, 580471, 580466, 580463, 445294, 583478, 628986, 386093, 609931, 609929, 628975, 628972, 628955, 628951, 628194, 628910, 628892, 628890, 628906, 628917, 628904, 628915, 628913, 626952, 201118, 201116, 201112, 628584, 596026, 453783, 201097, 628577, 628575, 628571, 628568, 445284, 628865, 628888, 628885, 628830, 628559, 628845, 628824, 628553, 609385, 628550, 609383, 628542, 628539, 189085, 628768, 628810, 596023, 596021, 628782, 534315, 628779, 628762, 628741, 628755, 628746, 626583, 628737, 445277, 628729, 628725, 628713, 628707, 628703, 628695, 247003, 628604, 628669, 628665, 628663, 628535, 628658, 628532, 628601, 628513, 628528, 445273, 445270, 628516, 445267, 626322, 445263, 445261, 623629, 609379, 609377, 628505, 628479, 445259, 628422, 628491, 628448, 628380, 445250, 601099, 628420, 628407, 628417, 601095, 607393, 628397, 628395, 606388, 445242, 445237, 246995, 445230, 628373, 445222, 445219, 628339, 628357, 445215, 628354, 445210, 445205, 445202, 445198, 599344, 628229, 504897, 628225, 445189, 605681, 605678, 445187, 605674, 445184, 445182, 453778, 412582, 453773, 412579, 596016, 628289, 628177, 628280, 578480, 628251, 628274, 628272, 628270, 627651, 628249, 628247, 596014, 445171, 445167, 628211, 445163, 627522, 627519, 613420, 628206, 628204, 628202, 580449, 628200, 445160, 628198, 628185, 628189, 628183, 628180, 628174, 628170, 453770, 445149, 626696, 628131, 628138, 628160, 628147, 628145, 628142, 628112, 628125, 628109, 628107, 596010, 596008, 628122, 628105, 628120, 628116, 601090, 409664, 409662, 628100, 628097, 628092, 628079, 627498, 610270, 627854, 628048, 445133, 628043, 609923, 628036, 628028, 628006, 628026, 627850, 627998, 627959, 627952, 627901, 627493, 627892, 627884, 627882, 627817, 627880, 627878, 627838, 627836, 596001, 595999, 595997, 626974, 627833, 595994, 627829, 627809, 627798, 595989, 610876, 610874, 610872, 627790, 627788, 453768, 627091, 627488, 627485, 627483, 627776, 627534, 627669, 627730, 627712, 627691, 627667, 627234, 627649, 627646, 627643, 605667, 445087, 445084, 445082, 445079, 567915, 627640, 627590, 627633, 627300, 445048, 627297, 627295, 627291, 627607, 627458, 627289, 627286, 627283, 627281, 627442, 627434, 627379, 627376, 445019, 445007, 610269, 627054, 627307, 627304, 627177, 627120, 627117, 627115, 444986, 627209, 627202, 627206, 627200, 627195, 595974, 627193, 444974, 444972, 580445, 627173, 627042, 444963, 627050, 627039, 627078, 627074, 627024, 444949, 626992, 444939, 627000, 626987, 626766, 609916, 626976, 626935, 626858, 626924, 626886, 626884, 626673, 626672, 626849, 608210, 626831, 626829, 626827, 626820, 626824, 444920, 626816, 626813, 450404, 626811, 444915, 450401, 626795, 201079, 201077, 626664, 626761, 453763, 626661, 626715, 444900, 444897, 626708, 444892, 444887, 595966, 626773, 595963, 626729, 626725, 564957, 564955, 626685, 626687, 626681, 626654, 626625, 626613, 626607, 605452, 610265, 626595, 626599, 611092, 626505, 606385, 444877, 626532, 611088, 626538, 626510, 626529, 609908, 589492, 626487, 595956, 626482, 611445, 611443, 609906, 601081, 626374, 453762, 444869, 444868, 625170, 444861, 580443, 589303, 589299, 626436, 589290, 626414, 626422, 606384, 606382, 444853, 626398, 626395, 626391, 626382, 626370, 613785, 444827, 626352, 444821, 626348, 444816, 444812, 444806, 608468, 444800, 613415, 626260, 444793, 625934, 625929, 444785, 444783, 444780, 534264, 444778, 444776, 444774, 625925, 444770, 444765, 626275, 626311, 246982, 626035, 444744, 610262, 589017, 623624, 623622, 626298, 626257, 595946, 595944, 626267, 595942, 626251, 626244, 626227, 444741, 609901, 626144, 625801, 625799, 626141, 626138, 626136, 626134, 626132, 626130, 626128, 616095, 391992, 626191, 616093, 625795, 444728, 626119, 22835, 444722, 626051, 626077, 607382, 626075, 626015, 626010, 626022, 626005, 626001, 625998, 625996, 625981, 625554, 625951, 625949, 625792, 625989, 625971, 625969, 625715, 625958, 625942, 444685, 444681, 625916, 625904, 444677, 444672, 444670, 625867, 625788, 610260, 444667, 444661, 625863, 625861, 625418, 444650, 623620, 625850, 604476, 625811, 625774, 625770, 625768, 625766, 625603, 625779, 625194, 625192, 625595, 625188, 444614, 444606, 444597, 444594, 444590, 444583, 625639, 625637, 625727, 444555, 444545, 444542, 444539, 444537, 444529, 444525, 625667, 444520, 625698, 625577, 625722, 625574, 625703, 444502, 625584, 625660, 625643, 611428, 444487, 611420, 625535, 625541, 625608, 246963, 625509, 246958, 444453, 625507, 625490, 625500, 625342, 625338, 625482, 625477, 610259, 607380, 610256, 625459, 625450, 607378, 609062, 623614, 444416, 623612, 625433, 623609, 623606, 625375, 625306, 625303, 625369, 444392, 625325, 444389, 444384, 444381, 625353, 625320, 625351, 625349, 625271, 625347, 610244, 444377, 444374, 625344, 623935, 444370, 625277, 610241, 580394, 625243, 625249, 625217, 580373, 625196, 610240, 625181, 610237, 610235, 625156, 625152, 598818, 625147, 571135, 607230, 607376, 444318, 444309, 625131, 625127, 506491, 444307, 444306, 625109, 625119, 625114, 625117, 625104, 625101, 625091, 534133, 625077, 624417, 624414, 624412, 624356, 610234, 624368, 444257, 624340, 444219, 444214, 444198, 444196, 612296, 605662, 610233, 444182, 444178, 624298, 444152, 608461, 608453, 605398, 624270, 624250, 624209, 624191, 624189, 615785, 607371, 580350, 623968, 623966, 444098, 606377, 624011, 623957, 623889, 623887, 623885, 623927, 444065, 623906, 623500, 615007, 623922, 623901, 595928, 444058, 601073, 601071, 623897, 623894, 623892, 444047, 623876, 623868, 623858, 623853, 623871, 624105, 444032, 623803, 623800, 444004, 421781, 605397, 595924, 595920, 595913, 595910, 534000, 443992, 623604, 595907, 624098, 624095, 614998, 624091, 443964, 443956, 443943, 443927, 623782, 443916, 443913, 443909, 580345, 443906, 443899, 623763, 623761, 595892, 623755, 616086, 623751, 623749, 616160, 623747, 623733, 616084, 616082, 623731, 616079, 623710, 623708, 623587, 623688, 607370, 623440, 623252, 443872, 623678, 623439, 443864, 443862, 595887, 595885, 623435, 443853, 443851, 443840, 443834, 623432, 189030, 623429, 615717, 615713, 615976, 615968, 615966, 443824, 615964, 623426, 623658, 623656, 623411, 443813, 443810, 443802, 443798, 623668, 623466, 623662, 443783, 443781, 623462, 615956, 623457, 623649, 624088, 589016, 612315, 615950, 623534, 623532, 623530, 615944, 623527, 623517, 623513, 623507, 443762, 443758, 443756, 623452, 623450, 488934, 488932, 488927, 623423, 624085, 443745, 623391, 623405, 623346, 624076, 624072, 623381, 623378, 623375, 623373, 623370, 623339, 616334, 201047, 616332, 616253, 580340, 580338, 580337, 616304, 613538, 443722, 616286, 443718, 616284, 605442, 443712, 605440, 608439, 616271, 616266, 616264, 616262, 616259, 443708, 616250, 443701, 616248, 616226, 443699, 616244, 533897, 616240, 616220, 613089, 616218, 443689, 443685, 443682, 616215, 616211, 616209, 616207, 616204, 616201, 610232, 616199, 616195, 443675, 549763, 443670, 443668, 616193, 616191, 180994, 616139, 616137, 180989, 180987, 180983, 443656, 616149, 616127, 616124, 616118, 616116, 616112, 616109, 443647, 615903, 443633, 615991, 443630, 443627, 443625, 616074, 611404, 611402, 616030, 606022, 616007, 583199, 583197, 610231, 616001, 615928, 614214, 615893, 615898, 614209, 614202, 614200, 595874, 443559, 609270, 443555, 443537, 614183, 615870, 443512, 615858, 615867, 615854, 615851, 601054, 443496, 615809, 389720, 615599, 389717, 615773, 615596, 615771, 623238, 610228, 615797, 615768, 443461, 615705, 615754, 615695, 615689, 580328, 612277, 607864, 607367, 601049, 601047, 443404, 246905, 246902, 246897, 246890, 246875, 443386, 443384, 201023, 443380, 595868, 443377, 615632, 246870, 443365, 615619, 614941, 615595, 443349, 615608, 615612, 246863, 615606, 615593, 609860, 615587, 615583, 614135, 614133, 612845, 443329, 443325, 443308, 615535, 615533, 443300, 443295, 610226, 615474, 615468, 615462, 443279, 443276, 443272, 303, 286, 301, 284, 280, 278, 4717, 443266, 443263, 443255, 615518, 615514, 4711, 4709, 610223, 615454, 615485, 615452, 615434, 615422, 615420, 615411, 615501, 615498, 615495, 615493, 615408, 615406, 443231, 443229, 443226, 615404, 615401, 615397, 615392, 615390, 615387, 615383, 615379, 615368, 615359, 610220, 615354, 615085, 615081, 615078, 615349, 611121, 615071, 615066, 615064, 615062, 615055, 443196, 615050, 443193, 615047, 443187, 615107, 443185, 615105, 443180, 615099, 614926, 615096, 605646, 605639, 614922, 605637, 443163, 605634, 443155, 443148, 443145, 443142, 443140, 614916, 443136, 443131, 443127, 610219, 479232, 443114, 443106, 614992, 443103, 443093, 603946, 606373, 603944, 607013, 608540, 614973, 613950, 614938, 614936, 613947, 613938, 613936, 613934, 595864, 573735, 573733, 614049, 443049, 443041, 614863, 610216, 604738, 610214, 610211, 610208, 610205, 604734, 614860, 614903, 614845, 580321, 443021, 443009, 443000, 592734, 614883, 614868, 608537, 442983, 442979, 608534, 457964, 614878, 610203, 607008, 607005, 614813, 614803, 614798, 606372, 592727, 592724, 614786, 592714, 592709, 592707, 592705, 614774, 614772, 442950, 624053, 624052, 614784, 614767, 614770, 593651, 593649, 442925, 442915, 246841, 613527, 442873, 614063, 442861, 442859, 442855, 614061, 599514, 442832, 442826, 608942, 613821, 614047, 180976, 180965, 601030, 442814, 614043, 201011, 442800, 201009, 201007, 614039, 613718, 442771, 442767, 173632, 173630, 442761, 442756, 442753, 442751, 442749, 442746, 613992, 614036, 442744, 442741, 442736, 614017, 442722, 613890, 613885, 613882, 613879, 613987, 613874, 608437, 613977, 613862, 613960, 612496, 613954, 595859, 608434, 613597, 613908, 613906, 606368, 613522, 613518, 601023, 609371, 613594, 613852, 613849, 442690, 613845, 580305, 442688, 246830, 613574, 613572, 246827, 610201, 610199, 613809, 580296, 613807, 580291, 442685, 613569, 613799, 613796, 613792, 613789, 613754, 610601, 613727, 607366, 442678, 608934, 608932, 554443, 601020, 554440, 246823, 606365, 580289, 188973, 442653, 417916, 554439, 613685, 554436, 613511, 613677, 595851, 610196, 412568, 613674, 613669, 581356, 595849, 442631, 442628, 595846, 442622, 609858, 613586, 442610, 442608, 442602, 572900, 572897, 609848, 613555, 613551, 442593, 608928, 442590, 606362, 613488, 609225, 442583, 442580, 593749, 442578, 442574, 608429, 613404, 442572, 608427, 442565, 606356, 442563, 606355, 595837, 442552, 442550, 605323, 595835, 608421, 608418, 393077, 608412, 595831, 613385, 613087, 613381, 613377, 613375, 583114, 613370, 613367, 442526, 442517, 613356, 609529, 609527, 609525, 606351, 606349, 606347, 606345, 580279, 633425, 580277, 606341, 612387, 442513, 442510, 580270, 580266, 580260, 580257, 580253, 613316, 613286, 580246, 613284, 612837, 393073, 393072, 613281, 442500, 613291, 609842, 442496, 442495, 442490, 609840, 595830, 613266, 592142, 613261, 605627, 605626, 608347, 613186, 613157, 613164, 613108, 613151, 613149, 580240, 613131, 613126, 613112, 442434, 442431, 442412, 442410, 612982, 442404, 442402, 442400, 602026, 442379, 613039, 442376, 613037, 613029, 188966, 442349, 442344, 442339, 612976, 442328, 442315, 611297, 612941, 612950, 246788, 246787, 612477, 246785, 612471, 612927, 612469, 612465, 246783, 442258, 442256, 442250, 442245, 442217, 442216, 442212, 442209, 612915, 442197, 442193, 442189, 612681, 611473, 442186, 632285, 499606, 611469, 632283, 632280, 633419, 633415, 612758, 612807, 612787, 612753, 612732, 612784, 612782, 612776, 612772, 612748, 442155, 612746, 612728, 612745, 442133, 442131, 442129, 609367, 442127, 632785, 442122, 612533, 612739, 610525, 612737, 612688, 442113, 608955, 612651, 612660, 612618, 612641, 612616, 612639, 608921, 608918, 608911, 598567, 442078, 606337, 608092, 606334, 611378, 611372, 612555, 442056, 611369, 612546, 612273, 612271, 612256, 442050, 606330, 612526, 612524, 608907, 612521, 612519, 612517, 612250, 606327, 608905, 442037, 606324, 608903, 606323, 609516, 609512, 609510, 609508, 609502, 609497, 609494, 442008, 442006, 612499, 612243, 612493, 612241, 612453, 612448, 607360, 612339, 612446, 612444, 605392, 595813, 612233, 612335, 612333, 612231, 595805, 612329, 612324, 441966, 605382, 606177, 612212, 612209, 612205, 612203, 604683, 604677, 612171, 608898, 611356, 612192, 441947, 331884, 612023, 612141, 612131, 612126, 441944, 612124, 612111, 611621, 612103, 612099, 493216, 493214, 612096, 493212, 612093, 612090, 612086, 493204, 612064, 612060, 612057, 612018, 441896, 611977, 608204, 441880, 611930, 611935, 611601, 296292, 611928, 611916, 611924, 605378, 441867, 611907, 441865, 611879, 421775, 441845, 611840, 610803, 610801, 611846, 441829, 533333, 611599, 207581, 611565, 441782, 441779, 441771, 441767, 611213, 611212, 608757, 611209, 608755, 611206, 608753, 608751, 605309, 608746, 611531, 605369, 608743, 605367, 441753, 133351, 611517, 611523, 611199, 611197, 200989, 611488, 611486, 200987, 393067, 608346, 611329, 611327, 611477, 611465, 611461, 611323, 441697, 611316, 441688, 441685, 611304, 140333, 493193, 605303, 441673, 441669, 441665, 441663, 605300, 441661, 441659, 441657, 605295, 554431, 611249, 611246, 611074, 611068, 611242, 611238, 400767, 611118, 610909, 453157, 610907, 610904, 610901, 611192, 611184, 611182, 610898, 611132, 611159, 441639, 441637, 441635, 611064, 441631, 611047, 611041, 611039, 611037, 611033, 611113, 611111, 611106, 611104, 611024, 611022, 611020, 608626, 608624, 611002, 441598, 608185, 441592, 441580, 441577, 441575, 222474, 441572, 222468, 610928, 222457, 441570, 610925, 441563, 441560, 441555, 595759, 441552, 200984, 610893, 200982, 610542, 441541, 200980, 441534, 441528, 441516, 441512, 472708, 441501, 610835, 610830, 441493, 595754, 595751, 610682, 246727, 597370, 610787, 610859, 595748, 222455, 610672, 597368, 597366, 595744, 610782, 536469, 578256, 597361, 595740, 597357, 597355, 536467, 536465, 610828, 610825, 597350, 578252, 610772, 610770, 610821, 610768, 610811, 386084, 441481, 607358, 610760, 610757, 604000, 603998, 449870, 441473, 595733, 595729, 595727, 578241, 610726, 441465, 449867, 441463, 441456, 441454, 200972, 610629, 610512, 441428, 554428, 441416, 441404, 441402, 441396, 610484, 623160, 610364, 610413, 611752, 611735, 378182, 608077, 603426, 611728, 611725, 610403, 610401, 610398, 610388, 610385, 610435, 610378, 611720, 610375, 582987, 605820, 597248, 533161, 608565, 608563, 602854, 610192, 608557, 608554, 608552, 602846, 600990, 602843, 610189, 611710, 610187, 611707, 611698, 611696, 600987, 455500, 455495, 441362, 455492, 466839, 455487, 609643, 466836, 610158, 609134, 441355, 363568, 441353, 610150, 610146, 610144, 595715, 610140, 610136, 610098, 610096, 414245, 609634, 414243, 414241, 610091, 610002, 609097, 610087, 378181, 441345, 441343, 609750, 610050, 610027, 610025, 26407, 600849, 133348, 610034, 610021, 609625, 610039, 610019, 610031, 610016, 610013, 441327, 610009, 609993, 609720, 441317, 441314, 609740, 441311, 607357, 441308, 609724, 597240, 609734, 609717, 609683, 609547, 609545, 609543, 609541, 609539, 609537, 609680, 608894, 609695, 396182, 396180, 609702, 609700, 609675, 609535, 609672, 576523, 596594, 576521, 609611, 609609, 609570, 609566, 609564, 609598, 609593, 609556, 596587, 609580, 609554, 596584, 609578, 609576, 609574, 596582, 609572, 609550, 609534, 609460, 597117, 609531, 51336, 51332, 51330, 609491, 609489, 609487, 441305, 609479, 481383, 481381, 609445, 609309, 609413, 609438, 609300, 609434, 609419, 609409, 609339, 609329, 441295, 609302, 609290, 605360, 608312, 609284, 601964, 606322, 609249, 608406, 608404, 608402, 608400, 608397, 598029, 609054, 609195, 609160, 608891, 578103, 609153, 598027, 609048, 609043, 607576, 133343, 133341, 133337, 133333, 609144, 133331, 133327, 441272, 133325, 388375, 608739, 608736, 608863, 608861, 609129, 590066, 609091, 607354, 609088, 624036, 606807, 441251, 606803, 608997, 606801, 593920, 609034, 595703, 595700, 606517, 595698, 582969, 595696, 441245, 608859, 608968, 595695, 441242, 608873, 554425, 600986, 608974, 582966, 608832, 608729, 608619, 608396, 608825, 608856, 608850, 608848, 608818, 608657, 608788, 608785, 595689, 594560, 595684, 608781, 608720, 608595, 608771, 607348, 608714, 608072, 608703, 608614, 608646, 453742, 608604, 608639, 604360, 608592, 608608, 608601, 608581, 603938, 608393, 608391, 608388, 603932, 608570, 334657, 334655, 334653, 608379, 608374, 607710, 608067, 608526, 608524, 608371, 607063, 608357, 598096, 607294, 605816, 608331, 441223, 607291, 441220, 441217, 597232, 607289, 441215, 441210, 441207, 604475, 608322, 600804, 600798, 600796, 600793, 441192, 441189, 441186, 441183, 200957, 606442, 608289, 608296, 608152, 595679, 612695, 608063, 441173, 608132, 608130, 608128, 441159, 608124, 608117, 608115, 608221, 608220, 608218, 533001, 608136, 608105, 608048, 606057, 608036, 441147, 608025, 608021, 607804, 441145, 133317, 133315, 607764, 607959, 607775, 607972, 607970, 607772, 607641, 607129, 607127, 607767, 607344, 441140, 607788, 441136, 200955, 607759, 607633, 582933, 607752, 607629, 615530, 604474, 607715, 607688, 354526, 607696, 607692, 188950, 606318, 607682, 554420, 607669, 592694, 188946, 188944, 607658, 607661, 607655, 607624, 441127, 589014, 592692, 605355, 441124, 441122, 441117, 592212, 607586, 582922, 441114, 582919, 605624, 441112, 607571, 607569, 441109, 607567, 441107, 441105, 607565, 607543, 607559, 349626, 605353, 441101, 605349, 441087, 441085, 607342, 441084, 441082, 441079, 606279, 606019, 377216, 441074, 441068, 441065, 607264, 606437, 607260, 499500, 441053, 596954, 603481, 607227, 607249, 603467, 607195, 603465, 603463, 603454, 606759, 607224, 607192, 200951, 607188, 607186, 347351, 441016, 607184, 200946, 607180, 607178, 607142, 607057, 607052, 607091, 607088, 607086, 607083, 606799, 606973, 607036, 603930, 607034, 601393, 600713, 606972, 440991, 606874, 440982, 606937, 440980, 440977, 606872, 606869, 606893, 606900, 606889, 606883, 606836, 606866, 595655, 440969, 595652, 606788, 440965, 440963, 440961, 440959, 595648, 554414, 440956, 595643, 109250, 440950, 440948, 440946, 595641, 606051, 600710, 606757, 606755, 440943, 600707, 600702, 600699, 606715, 407983, 440939, 554412, 606671, 606668, 440927, 604358, 606712, 605346, 606665, 606661, 606554, 440922, 606653, 440917, 606639, 440914, 602005, 440908, 414217, 440902, 440898, 606573, 603450, 606566, 440888, 606564, 606513, 606509, 606560, 440883, 606314, 606500, 606311, 606498, 604357, 606236, 606234, 414211, 414209, 606486, 600978, 440879, 606478, 606193, 595626, 606274, 440878, 595624, 606305, 440875, 440873, 606302, 606434, 604473, 440869, 606452, 606263, 606429, 606424, 606296, 600976, 440857, 606294, 595620, 595618, 595616, 554392, 602737, 606228, 554390, 440846, 595608, 554388, 595600, 133312, 606184, 602043, 606152, 331392, 200933, 580219, 606199, 606180, 606166, 602040, 606173, 606163, 440843, 605813, 606134, 440839, 606149, 440837, 329398, 133310, 440835, 606139, 597229, 597224, 606074, 605997, 246709, 606067, 246698, 605994, 605951, 246697, 605986, 595594, 595592, 603447, 246691, 600043, 246687, 440827, 532875, 605967, 605886, 605940, 133307, 600040, 605879, 605875, 605931, 605918, 133304, 532872, 582842, 605902, 605859, 582837, 440794, 440792, 440789, 605836, 440780, 582833, 605802, 605602, 605799, 605597, 605595, 605795, 440776, 605792, 605773, 605791, 605536, 605533, 582829, 605780, 605706, 600479, 582824, 582821, 582814, 582812, 440755, 440746, 605545, 554379, 605574, 600461, 605529, 605543, 605117, 440724, 440722, 605549, 440719, 440717, 605522, 603997, 582798, 602546, 602544, 602541, 602539, 602537, 602535, 602533, 440713, 602529, 602527, 602525, 602523, 599508, 604354, 604471, 599506, 602512, 440709, 605518, 605282, 604470, 604469, 605514, 605512, 605506, 605500, 605498, 599504, 440706, 605475, 605473, 605466, 604413, 605275, 605328, 440698, 605172, 605170, 605266, 605222, 605167, 440691, 440690, 605164, 440688, 599502, 604352, 440686, 599499, 599497, 604349, 605094, 604916, 604914, 604409, 605136, 604407, 604405, 605089, 602166, 604347, 604345, 535453, 440678, 535450, 440676, 604046, 605085, 604340, 535444, 605016, 440669, 604338, 604911, 535441, 604042, 605050, 602251, 440662, 440660, 599315, 600447, 440652, 600444, 604903, 604402, 604900, 604221, 604400, 440639, 109245, 587600, 605032, 605039, 109237, 605036, 605010, 604869, 440635, 532839, 394078, 440629, 604337, 605027, 604866, 604334, 440622, 532837, 440620, 605023, 604864, 200912, 604862, 603993, 440616, 605008, 604987, 440614, 440613, 361106, 602734, 604940, 602710, 580216, 580213, 604928, 580211, 580207, 440592, 604763, 604761, 421770, 421768, 604907, 394075, 604840, 604468, 200911, 604807, 394071, 604264, 604892, 378802, 604852, 604801, 604858, 604821, 604798, 604796, 246679, 440578, 440570, 587598, 440559, 440557, 440555, 604332, 440553, 440551, 600437, 600435, 604782, 604775, 604726, 604757, 596931, 604330, 604328, 604754, 604325, 604748, 604322, 604746, 604319, 604744, 440535, 603927, 603924, 604391, 604466, 604164, 604384, 604649, 532805, 532803, 532802, 532800, 600433, 440510, 440504, 604633, 595577, 595575, 595573, 604500, 440501, 189224, 440493, 440489, 604310, 440484, 604428, 539561, 604434, 592465, 604442, 604426, 440469, 592691, 189221, 604262, 440462, 599036, 604218, 604273, 604144, 604138, 604259, 604257, 604123, 604188, 604117, 604115, 599034, 604113, 604096, 604181, 603919, 604064, 440453, 246671, 603030, 604091, 603991, 603989, 604067, 604078, 604075, 604054, 604062, 604060, 604026, 440441, 603986, 603903, 590062, 602250, 602248, 602246, 603949, 602244, 599493, 603916, 603914, 603091, 592690, 623077, 599490, 603495, 599488, 582713, 602237, 603232, 602952, 603362, 603387, 603855, 603490, 603438, 603380, 603324, 603499, 603414, 603417, 603360, 600945, 603358, 532764, 572891, 603379, 603376, 532756, 603025, 603355, 603334, 603346, 603348, 603212, 532748, 440423, 440416, 603340, 532746, 603309, 603306, 603304, 532745, 603320, 602925, 603328, 440413, 603302, 603297, 596731, 440407, 602155, 602153, 602150, 582699, 603227, 582696, 603289, 603284, 603193, 440401, 603224, 589662, 495591, 603191, 603163, 603160, 603156, 440399, 603152, 603148, 329389, 603112, 601737, 603075, 440397, 603073, 440391, 603067, 603078, 440389, 440387, 440379, 486321, 593633, 603058, 602236, 532734, 440373, 440371, 602031, 440370, 597854, 593624, 600926, 532732, 440369, 520747, 602949, 602978, 602943, 602955, 600431, 440364, 602938, 600421, 600418, 600410, 440353, 599068, 602929, 601375, 440349, 602899, 602897, 602893, 595199, 440346, 602877, 602887, 602885, 595196, 602810, 602862, 602793, 602790, 602788, 602671, 602669, 602233, 602664, 602662, 602231, 602229, 602227, 602656, 602224, 602724, 602222, 602653, 602651, 602649, 600406, 532726, 602768, 602765, 602732, 602729, 532725, 599486, 602510, 602506, 599484, 599482, 602030, 600920, 602575, 582644, 600918, 602505, 602503, 602648, 602500, 372045, 602624, 600916, 602612, 582637, 582633, 599028, 440336, 582631, 440333, 602608, 602604, 602583, 602581, 582619, 602601, 602589, 602598, 602595, 602587, 602592, 440330, 602447, 602445, 589383, 602556, 602554, 600914, 600912, 602568, 602441, 602566, 602436, 602432, 440326, 602496, 554378, 602429, 602424, 602473, 602469, 602418, 602416, 602411, 602453, 602407, 602401, 488694, 602398, 602396, 600034, 602394, 602390, 440323, 602385, 602377, 602261, 602290, 602220, 602339, 602213, 602275, 602211, 602303, 593227, 602334, 602331, 602329, 602325, 600397, 601599, 593224, 602259, 554372, 602257, 602161, 600392, 602209, 602312, 602204, 314787, 602197, 602195, 602141, 601595, 602138, 602134, 602130, 600386, 602127, 599019, 601883, 554370, 554366, 599016, 602079, 602108, 602101, 602072, 602068, 601989, 602054, 532705, 601572, 582526, 601975, 601568, 601566, 601967, 440305, 601427, 314783, 314776, 599479, 440303, 497512, 440300, 601951, 544200, 544198, 580200, 600368, 575847, 575845, 600362, 601426, 601941, 600355, 600352, 580197, 600349, 580195, 601919, 440288, 440279, 440277, 440275, 600341, 440269, 601422, 601420, 314771, 599475, 601615, 601909, 601868, 601418, 580189, 314766, 601864, 516759, 601880, 600131, 601878, 601876, 582454, 601853, 600330, 440259, 601799, 601817, 601797, 600109, 601740, 600899, 601726, 601729, 601724, 601721, 601719, 600326, 600319, 601709, 601713, 601637, 601633, 601631, 600313, 601628, 601416, 601471, 601561, 601414, 506478, 601469, 601467, 601412, 554754, 440257, 601556, 599473, 599471, 599013, 440256, 601549, 601540, 600308, 600302, 206236, 440254, 601539, 601483, 600300, 600298, 440250, 440247, 440245, 601499, 601494, 601492, 601477, 601490, 601411, 601409, 601487, 601459, 601407, 601473, 440239, 440237, 601404, 601402, 601456, 601400, 601388, 601451, 440234, 601445, 601429, 593205, 600895, 601440, 601438, 601432, 601398, 440232, 601361, 595563, 440223, 601396, 440218, 595559, 601382, 595557, 595553, 599910, 595550, 595548, 601367, 601356, 601352, 77208, 77206, 601319, 601317, 77204, 440209, 600887, 600292, 600289, 601309, 600284, 601295, 601293, 600881, 600867, 600720, 600872, 440203, 440199, 440196, 600786, 600781, 600763, 600600, 600690, 599466, 440178, 508149, 600567, 600549, 599649, 596577, 596568, 596565, 596562, 596559, 600512, 599978, 596556, 600280, 596553, 600278, 600276, 200900, 600533, 600490, 600523, 600493, 440162, 600270, 440157, 600195, 548404, 200899, 600102, 599464, 440151, 599011, 599461, 440147, 440145, 600076, 594635, 440142, 599996, 440140, 599008, 440135, 599006, 600057, 440121, 440118, 598212, 600017, 440114, 440109, 440101, 600023, 599004, 599970, 600007, 460068, 599992, 599989, 593127, 595189, 593125, 593120, 591786, 593115, 593114, 599715, 200895, 599948, 599945, 599459, 599905, 599954, 599935, 599932, 597851, 597846, 599891, 614959, 614951, 599887, 599458, 599824, 614949, 599819, 599812, 599457, 532603, 599711, 599776, 440075, 440071, 599455, 599003, 440069, 599001, 440066, 598342, 599705, 599644, 598339, 599633, 404747, 599435, 599667, 440037, 599629, 599659, 599614, 439998, 580179, 599427, 598984, 598978, 598973, 595177, 580177, 580174, 598966, 349609, 349607, 598960, 580171, 349605, 599393, 597629, 598956, 439966, 439964, 392955, 392953, 392951, 392945, 392943, 392938, 439956, 599389, 599405, 599386, 599384, 599377, 599381, 599370, 596730, 596728, 599238, 599234, 599230, 599221, 599219, 599216, 439941, 439939, 532590, 439937, 595170, 595167, 473646, 599122, 569047, 439915, 439912, 599099, 439908, 439906, 439901, 439897, 409708, 599090, 596617, 597544, 598949, 597542, 200885, 598927, 598901, 439893, 598940, 439891, 597923, 598925, 596615, 598921, 598915, 592189, 598840, 598833, 580162, 598811, 584661, 598785, 598582, 598781, 517457, 200878, 200876, 598764, 439875, 598633, 597801, 597798, 597794, 598609, 439847, 439844, 598597, 439843, 591761, 439838, 598501, 598493, 597842, 598484, 598482, 592106, 598424, 598476, 598480, 597840, 598398, 439811, 597920, 597918, 439808, 439805, 439803, 439791, 592617, 592615, 592613, 439764, 439759, 439758, 598258, 439755, 439753, 598255, 439751, 439748, 439745, 439740, 439739, 439736, 597912, 598184, 598182, 597906, 597903, 597901, 597898, 597622, 597891, 594535, 597889, 439728, 598100, 597836, 597821, 597863, 200868, 597612, 439635, 439633, 439631, 246665, 439628, 597547, 595150, 439576, 439572, 439560, 580152, 580148, 597210, 597205, 595499, 439532, 439530, 439526, 597286, 594737, 439495, 439488, 439476, 439471, 439469, 439467, 439464, 439461, 439458, 532518, 439455, 596911, 596909, 596905, 439454, 439451, 439449, 439447, 439445, 439443, 439431, 439428, 596825, 596821, 596817, 596795, 439410, 491111, 596792, 491109, 596789, 594354, 594350, 439400, 596735, 596656, 596463, 596629, 596457, 596454, 581331, 439370, 581320, 596444, 595481, 439348, 595330, 581311, 581309, 581296, 535440, 581293, 581287, 581285, 581272, 439329, 439315, 595238, 588784, 595235, 588782, 595233, 473633, 439313, 595126, 439303, 439301, 439296, 439294, 595073, 133277, 594444, 133271, 595031, 594438, 133264, 595018, 594991, 439281, 554281, 594781, 594705, 594674, 594663, 594598, 594594, 594587, 527975, 527970, 527968, 527966, 527964, 527961, 527958, 591032, 591030, 580145, 594366, 580125, 594167, 592656, 594163, 439166, 439163, 593777, 593964, 593939, 593937, 439139, 439134, 593822, 593872, 439127, 439123, 593766, 593763, 439110, 439106, 439101, 439099, 439092, 439089, 439074, 439072, 439068, 439063, 439061, 439056, 593693, 593686, 580123, 580117, 580114, 593467, 593464, 593105, 593214, 593198, 593168, 593165, 246658, 593162, 593159, 593103, 590717, 246655, 593013, 593008, 593002, 592944, 592942, 592996, 592940, 439037, 439033, 439028, 439025, 592635, 592631, 378170, 592624, 439012, 439010, 439006, 439004, 439002, 439001, 438966, 438960, 592437, 592414, 592462, 592432, 592408, 577838, 438944, 592282, 438942, 438936, 592182, 438934, 592179, 438914, 200852, 527915, 527912, 527910, 527905, 527902, 591338, 527898, 527896, 527893, 527891, 527889, 561633, 527876, 527874, 527869, 527865, 200849, 527851, 493334, 527843, 527841, 591332, 246648, 397463, 397461, 246647, 586128, 586126, 438791, 438777, 517424, 438760, 133242, 517422, 438737, 591194, 590999, 554258, 590296, 590294, 589928, 438613, 438609, 438598, 589925, 589916, 438580, 589912, 589910, 438577, 438575, 438570, 532061, 590578, 554236, 589906, 589889, 589884, 589875, 246583, 438467, 438456, 438448, 438444, 580034, 580030, 246570, 580018, 438406, 580015, 590319, 438337, 438331, 438322, 438319, 438317, 438315, 438310, 438308, 438299, 438293, 438291, 579960, 586740, 387869, 387864, 387862, 387859, 387857, 586738, 438195, 438180, 438178, 438175, 579842, 576511, 579817, 579781, 246503, 590179, 590106, 590103, 590101, 590100, 590095, 437875, 590093, 590091, 590089, 590087, 437851, 437823, 589856, 589854, 589851, 589989, 589987, 589838, 589826, 589809, 579674, 579672, 579663, 406502, 625044, 589184, 589182, 589125, 589120, 578681, 589036, 570358, 579596, 579594, 406477, 406475, 579592, 579590, 406471, 406466, 406460, 406458, 588414, 588386, 588377, 588375, 588372, 570350, 554213, 588866, 588864, 554211, 554209, 588862, 554201, 588851, 588201, 588170, 588158, 588155, 588598, 587311, 587309, 188888, 437118, 587638, 587759, 437070, 587722, 587720, 437064, 437055, 587660, 437053, 587697, 437043, 437010, 437008, 437001, 436993, 436966, 436894, 246138, 587412, 436860, 436857, 436765, 573531, 587039, 586917, 586908, 200744, 587027, 587001, 586999, 586996, 586994, 586992, 586990, 586987, 586980, 586974, 586972, 586970, 586966, 586963, 586959, 586955, 174383, 579521, 109096, 579518, 586725, 109079, 586546, 221688, 398842, 585045, 586531, 586588, 586583, 436478, 436473, 436330, 578392, 436268, 579382, 562877, 579337, 361101, 585367, 109042, 436231, 471329, 471327, 436206, 436202, 579332, 579330, 436181, 436174, 436170, 436162, 436158, 436147, 436145, 436141, 436135, 585234, 585206, 585232, 436124, 436117, 309777, 309775, 309755, 585078, 585069, 558073, 584800, 579298, 435871, 584721, 584368, 584714, 584707, 584704, 584702, 584699, 584693, 584679, 579288, 369254, 584568, 584440, 435803, 435801, 435799, 579265, 584438, 584436, 576909, 581950, 579255, 435791, 579047, 435231, 435229, 124265, 124263, 124261, 481796, 481793, 578845, 578842, 578831, 542178, 578798, 578794, 578766, 542173, 245753, 435042, 435037, 485947, 435006, 549753, 578604, 79565, 578600, 578548, 578184, 578181, 578211, 578180, 578169, 578167, 578163, 578161, 434939, 314693, 314688, 434773, 549746, 549744, 549742, 234958, 234955, 527777, 234953, 234945, 234943, 577360, 314684, 314678, 527766, 377199, 221087))
Run Time: 0.102221
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4470 | |
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 | | | | | 4470 | |
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 (34523, 34118, 34108, 34079, 34056, 34050, 34042, 33905, 33886, 33880, 33800, 33729, 33721, 33719, 33718, 33703, 33701, 33689, 33686, 33684, 33588, 33554, 33538, 33475, 33463, 33439, 33428, 33399, 33398, 33386, 33380, 33359, 33342, 33317, 33313, 33292, 33282, 33270, 33210, 33208, 33195, 33175, 33157, 33142, 33133, 33110, 33002, 32987, 32864, 32859, 32796, 32789, 32765, 32718, 32696, 32699, 32624, 32615, 32607, 32583, 32582, 32552, 32526, 33080, 32509, 32502, 32473, 32452, 32438, 32391, 32393, 32390, 32386, 32385, 32381, 32380, 32379, 32372, 32351, 32326, 32309, 32295, 32298, 32308, 32296, 32297, 35116, 32284, 32285, 32286, 32287, 35117, 35118, 35119, 35120, 35121, 35122, 35125, 35126, 32261, 32246, 32236, 32201, 32200, 32199, 32193, 32192, 32191, 32234, 32190, 32172, 32169, 32228, 32163, 32162, 32156, 32132, 32130, 32129, 32091, 32089, 32079, 32075, 32052, 32213, 32051, 32039, 32037, 32034, 32033, 32027, 32024, 32022, 32019, 32007, 32003, 32002, 32001, 31990, 31986, 32233, 31984, 31979, 31973, 31965, 31952, 31950, 31948, 31942, 32232, 31927, 31926, 31923, 31919, 31901, 31895, 31888, 31887, 31883, 31882, 31880, 31858, 31829, 33665, 31809, 31808, 31795, 31788, 31777, 31769, 31762, 31740, 31726, 31720, 31719, 31700, 31662, 31661, 31635, 31552, 31539, 31500, 31477, 31416, 31195, 31160, 31118, 31088, 30989, 30943, 30880, 30868, 30712, 30683, 30603, 30531, 30374, 30291))
Run Time: 0.006126
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 198 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | my_webapp.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,my_webapp.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, ه
Run Time: 0.000285
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.000479
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.000566
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: 1716175843
Run Time: 0.000399
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 36 | 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` >= 1716175843)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000706
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 36 | 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