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.000582
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.000195
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` = '4040')
LIMIT 1
Run Time: 0.000383
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.002563
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_4040' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.175532
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 (534715, 446520, 446514, 534711, 534710, 593647, 608582, 441104, 607193, 532932, 607190, 607187, 607185, 607183, 607181, 532928, 607179, 607177, 607175, 607171, 607169, 607167, 607165, 607163, 532925, 607161, 607109, 607158, 439524, 594355, 594348, 439279, 532426, 439158, 532423, 592547, 438958, 591378, 580085, 532184, 438753, 438751, 591090, 591087, 591085, 591052, 591071, 469320, 221899, 554543, 554541, 532097, 580966, 580964, 580963, 580962, 438643, 532095, 438620, 438606, 110708, 110706, 438583, 438581, 438578, 438576, 438574, 532072, 438567, 438561, 532068, 246645, 548344, 438538, 246639, 246631, 246618, 438508, 246564, 590338, 438397, 531977, 438350, 437703, 437686, 437632, 437609, 437536, 437534, 437516, 437514, 531782, 437436, 437271, 399372, 437268, 489156, 437227, 437102, 246168, 189198, 436882, 531480, 531477, 587081, 436620, 585943, 585936, 531408, 531399, 586228, 586226, 585445, 584947, 579347, 484804, 585388, 246003, 585385, 436250, 436240, 109030, 585336, 585334, 436137, 585255, 585253, 585178, 403207, 581023, 585076, 585073, 315784, 554715, 221574, 531285, 622427, 353947, 369257, 369255, 435863, 584752, 435829, 584731, 584729, 579291, 579289, 578232, 581019, 581964, 200687, 584514, 580915, 531248, 245932, 245928, 369252, 315780, 531236, 435783, 578423, 124287, 584274, 571250, 124285, 435688, 435686, 435684, 435682, 435679, 584265, 584261, 435669, 584259, 581014, 435658, 435617, 584236, 584219, 584253, 584251, 500359, 584200, 584198, 435555, 435550, 435544, 579207, 584146, 531202, 584142, 531200, 584140, 109001, 108999, 108997, 584138, 221493, 221489, 221487, 221483, 500301, 221481, 221479, 221476, 221473, 221469, 221465, 435523, 369251, 584087, 584082, 584080, 369250, 622357, 584073, 584059, 584043, 580896, 579193, 579184, 435438, 369244, 435377, 581709, 435314, 579066, 579064, 579062, 579058, 536123, 581527, 531149, 245843, 245840, 579043, 581498, 435204, 435194, 435191, 531119, 581103, 200598, 577803, 200597, 580855, 580850, 580845, 578796, 435113, 580834, 337050, 580801, 580794, 580792, 580775, 578767, 531060, 578314, 235141, 235138, 435081, 435078, 435076, 435074, 531049, 576670, 531024, 531018, 435026, 435021, 578671, 578668, 578656, 578654, 408808, 531014, 578666, 108984, 235063, 577730, 245692, 542793, 576901, 576898, 576896, 576894, 576891, 576887, 576881, 108975, 235010, 399355, 530960, 530957, 577992, 577718, 577716, 526430, 577794, 526427, 245611, 434860, 434833, 399353, 399348, 399345, 421957, 546779, 434793, 577712, 245580, 245578, 245574, 245566, 330472, 576940, 576938, 234882, 577535, 577533, 553980, 536101, 234870, 434596, 200504, 573363, 567214, 245533, 573359, 573357, 573354, 573352, 434539, 245524, 530815, 434523, 573350, 434468, 434450, 434448, 234811, 234808, 234803, 530788, 434362, 573348, 234796, 434306, 434303, 576741, 576737, 530778, 548618, 548616, 530777, 576728, 536693, 200466, 434248, 234746, 234740, 576724, 576713, 234717, 576711, 234713, 576709, 234691, 234689, 570202, 576579, 221190, 221187, 530749, 200459, 221165, 530722, 530720, 108870, 576312, 407894, 576198, 530715, 434166, 576439, 576465, 576462, 576437, 572754, 622097, 572752, 576343, 576341, 576339, 234493, 576173, 399339, 551690, 245337, 245335, 434138, 245300, 245273, 245271, 530674, 530670, 434136, 434134, 573462, 536083, 434008, 453668, 575019, 433889, 234322, 245137, 245135, 530492, 200400, 530488, 530485, 530477, 245092, 570833, 234254, 234252, 574644, 234237, 234233, 234192, 234177, 521978, 234151, 234143, 234140, 530409, 574128, 234096, 234094, 234092, 574122, 234090, 234088, 234086, 234080, 433613, 245041, 530380, 433576, 569460, 433560, 530372, 530354, 234024, 530342, 530335, 530323, 200355, 433515, 572974, 530316, 234009, 220969, 234006, 570965, 110605, 573525, 573508, 245034, 536038, 530292, 573410, 573399, 573395, 386003, 234001, 233998, 233996, 233994, 233992, 233990, 233988, 530259, 530257, 530255, 573292, 433486, 6547, 530250, 572796, 530248, 244969, 244966, 433474, 244964, 399337, 530241, 244948, 200338, 572607, 530228, 572721, 433451, 244930, 433435, 108865, 108863, 244919, 244917, 244914, 244912, 530201, 530199, 572672, 433423, 530191, 572657, 548276, 265547, 433399, 433397, 244903, 572601, 220931, 433389, 530173, 530169, 244782, 572497, 572205, 572486, 530148, 220922, 433363, 433354, 433352, 433350, 433348, 433346, 433344, 433339, 469955, 469951, 572350, 572348, 572344, 572341, 572091, 572337, 572320, 572317, 572314, 244763, 244761, 233927, 571956, 530130, 233905, 233902, 572173, 573588, 573586, 570934, 570932, 530121, 244741, 244739, 244737, 570927, 573578, 530117, 323631, 383620, 433172, 433158, 433156, 433150, 244730, 433142, 433115, 571824, 571819, 571814, 571807, 571805, 571803, 571799, 571497, 538653, 571794, 571790, 571740, 571733, 530094, 433099, 433091, 571675, 484793, 484790, 484785, 484782, 484779, 530089, 571671, 530084, 571661, 571659, 571656, 530076, 530074, 233871, 433026, 433024, 530067, 530063, 433020, 433017, 233832, 220896, 530049, 571460, 571455, 530041, 220887, 530024, 571386, 369188, 244696, 530017, 529978, 309694, 546834, 244693, 244664, 244661, 571034, 571082, 526913, 566307, 488088, 309665, 309663, 529869, 621669, 200302, 529864, 309636, 309634, 529860, 570923, 570921, 570919, 570916, 570759, 570756, 569959, 569957, 621643, 570746, 473611, 200300, 529852, 309609, 529844, 570714, 309603, 309583, 309580, 309576, 309574, 309572, 529841, 570635, 570633, 570631, 526280, 526278, 621581, 570612, 529837, 555378, 497505, 553658, 553656, 553653, 553651, 553649, 553646, 553644, 553642, 553640, 553638, 553630, 529832, 555374, 553614, 220780, 220777, 553601, 432742, 529817, 553588, 535999, 419855, 553579, 419853, 479033, 570509, 374345, 310019, 310015, 570465, 569644, 271498, 432698, 570457, 220751, 529811, 570441, 569631, 220748, 569628, 569626, 501833, 569624, 220744, 482802, 220737, 220735, 466967, 569618, 569611, 569609, 108857, 133128, 220732, 569606, 569604, 220729, 569602, 569600, 569598, 570319, 570317, 570315, 570313, 570311, 570416, 529802, 570414, 570411, 466963, 466961, 466959, 553565, 568580, 466957, 466955, 535995, 535991, 220702, 220700, 535987, 418794, 432677, 432675, 418792, 432672, 432670, 547179, 244600, 529793, 547175, 108854, 220698, 108851, 529791, 108849, 108847, 535984, 287290, 108845, 529789, 535980, 535978, 503127, 453647, 547172, 108841, 108839, 108835, 108833, 547167, 547164, 220694, 220691, 471258, 220688, 529787, 220686, 471255, 220684, 471252, 471249, 550917, 108830, 471247, 535973, 471245, 432662, 432659, 108827, 233729, 471239, 558856, 233724, 233719, 558852, 233717, 233715, 471233, 471231, 233713, 482795, 233711, 569941, 233709, 233707, 233705, 220676, 220674, 233703, 233700, 570086, 570184, 570084, 432632, 220666, 529780, 570081, 220663, 570064, 432626, 432624, 220658, 529776, 569931, 432584, 233679, 233677, 233675, 233667, 233656, 529757, 553542, 553533, 553522, 569803, 200276, 233640, 569703, 220594, 569700, 569707, 569698, 569590, 108817, 569587, 569583, 569580, 569657, 569655, 432546, 432524, 108814, 563535, 529731, 244583, 309561, 569504, 569395, 569463, 472774, 569393, 565362, 569391, 569439, 563532, 569437, 621380, 621378, 206044, 206042, 206040, 621372, 220571, 553487, 247431, 244578, 233631, 233626, 568552, 568550, 233622, 553478, 432475, 432472, 568543, 233618, 567179, 542777, 463078, 220563, 244567, 220561, 569338, 569334, 529710, 220550, 569307, 569305, 432463, 569350, 569348, 432460, 569322, 569344, 529706, 371878, 432458, 521975, 569332, 569329, 432456, 569300, 569297, 569320, 200265, 371876, 521972, 529702, 521970, 569315, 569313, 496697, 529699, 568001, 567999, 567997, 567994, 567990, 569272, 569311, 569263, 432449, 529693, 569238, 25395, 25392, 529690, 560741, 561388, 25390, 25388, 25386, 244560, 529688, 569251, 529686, 220535, 560739, 561386, 560736, 560734, 569161, 569159, 569156, 569154, 569152, 529679, 496680, 558788, 569128, 569126, 560730, 569141, 496678, 569063, 244554, 560720, 529672, 560718, 558779, 233606, 529670, 560715, 569056, 529665, 108811, 569013, 432415, 432410, 560700, 432402, 615339, 615337, 615335, 563612, 244548, 568721, 526244, 553466, 568659, 73192, 568532, 110541, 565762, 220509, 423652, 220507, 568346, 529643, 568482, 514603, 514597, 514594, 164594, 514585, 526219, 432376, 543969, 543967, 567921, 567294, 567919, 567289, 529618, 567858, 567854, 567852, 559101, 310567, 529616, 110537, 559099, 567514, 529614, 244537, 567707, 547803, 526206, 526204, 220486, 220484, 526202, 526199, 567512, 432317, 432313, 244534, 561374, 567333, 554900, 567112, 561367, 432274, 567109, 567107, 567105, 432271, 567103, 567100, 220454, 220452, 220450, 432260, 529590, 567118, 432248, 565434, 527731, 529578, 526156, 526154, 484838, 363269, 567387, 567284, 567281, 567278, 529572, 567276, 567273, 567320, 561364, 526149, 567307, 567297, 567040, 561362, 419464, 561360, 561358, 374942, 567036, 432237, 529567, 565750, 554891, 565745, 565211, 565743, 554880, 567017, 554877, 567097, 220416, 567061, 220414, 220412, 567059, 554875, 567056, 567054, 567052, 567045, 565197, 567000, 566650, 432215, 220396, 469934, 621253, 621251, 315766, 529562, 553461, 561353, 529559, 561333, 566646, 566644, 563521, 561330, 561324, 561322, 563518, 561320, 566662, 566640, 220384, 566638, 200255, 529556, 133107, 432199, 133105, 561316, 36109, 565188, 566474, 566472, 405886, 405884, 565524, 566478, 244511, 621207, 621204, 621202, 621200, 269072, 269069, 566298, 566296, 432182, 566294, 527715, 621189, 220362, 621186, 621184, 621180, 621178, 621174, 529549, 432170, 565697, 566224, 566211, 566209, 566205, 565904, 565900, 244508, 565840, 565838, 244506, 546980, 559596, 561313, 432161, 565444, 244503, 538860, 244501, 565385, 432123, 432120, 529533, 561963, 561958, 561955, 565296, 432053, 432048, 432045, 432043, 469931, 432039, 432027, 432025, 432022, 432020, 432018, 432016, 537704, 565183, 565215, 565181, 432014, 565068, 565065, 565059, 554674, 565008, 551105, 564841, 564835, 564839, 564837, 564722, 554671, 564781, 564711, 220305, 220303, 220301, 220299, 360046, 529519, 360044, 529516, 564463, 383617, 431978, 244495, 529503, 529499, 244493, 529495, 564405, 563685, 564343, 233442, 392854, 431954, 469923, 469921, 431952, 563695, 563693, 564193, 483417, 483408, 431944, 483404, 483400, 483397, 200244, 483395, 483393, 475027, 233415, 483390, 431942, 564059, 564055, 564052, 233409, 564050, 233407, 564048, 564046, 529476, 564039, 624960, 564036, 563917, 483385, 563830, 563828, 309556, 563826, 563912, 563910, 563906, 309552, 563903, 309549, 563901, 309547, 309545, 563899, 563896, 563891, 563889, 563887, 563884, 603510, 23504, 23502, 529474, 431940, 23500, 529472, 563756, 563240, 563754, 563745, 563739, 563797, 563795, 563793, 563737, 563791, 563789, 561302, 563727, 561185, 220263, 554539, 431911, 220261, 486931, 392847, 244475, 323619, 244473, 563670, 529460, 551430, 559441, 551428, 535430, 562112, 563662, 563688, 563660, 529457, 220257, 562110, 431890, 431886, 431884, 431882, 431872, 527697, 562105, 369150, 562103, 369148, 233398, 541374, 541369, 541363, 408600, 621069, 529435, 220243, 529430, 541313, 431840, 529428, 431835, 399287, 399284, 526012, 413325, 309517, 309503, 309499, 431792, 535907, 535904, 553418, 563183, 244453, 563252, 529422, 431771, 431767, 200239, 562777, 493548, 244437, 562753, 562751, 562748, 562238, 233378, 562689, 562097, 529411, 233377, 233375, 529407, 562687, 562569, 562567, 220231, 562564, 562562, 529405, 431699, 562488, 562485, 562483, 562478, 309467, 529394, 560212, 496673, 558467, 562395, 492428, 562374, 562372, 561565, 562091, 562089, 562086, 407889, 562290, 529388, 244392, 562082, 562077, 220190, 561929, 561924, 561913, 233335, 412293, 233328, 233319, 561619, 554863, 561617, 554861, 561558, 561556, 561292, 220169, 233292, 220165, 561554, 561563, 554859, 554857, 561552, 554855, 558441, 549832, 535890, 529360, 244379, 561399, 220155, 561290, 233286, 525992, 529353, 529351, 220149, 561206, 561203, 560433, 23494, 541856, 431653, 560785, 529319, 529313, 557656, 560687, 560684, 560682, 560679, 560677, 560675, 315763, 431607, 537695, 431603, 392839, 560393, 560206, 560371, 560204, 560369, 560202, 624939, 624937, 560199, 559760, 385959, 559591, 551662, 560185, 560182, 560180, 331355, 559748, 385953, 518714, 560102, 560048, 220088, 624935, 559878, 559917, 431559, 559914, 559870, 485809, 559868, 559862, 559734, 559782, 559725, 559710, 559707, 559704, 559577, 180964, 559571, 556152, 529294, 559303, 539079, 539074, 556148, 556145, 559563, 559534, 559560, 559532, 220065, 559326, 244364, 550129, 431508, 529281, 559296, 244352, 244350, 529275, 525927, 244341, 540653, 559036, 431471, 405804, 405802, 431468, 233185, 233183, 233179, 529271, 421998, 558271, 333824, 547909, 233149, 233147, 620885, 620883, 549978, 110527, 549973, 558671, 558660, 431424, 431410, 233138, 558510, 554849, 554847, 554844, 431391, 554841, 554839, 558541, 624925, 244303, 558374, 244301, 558481, 244297, 529256, 624923, 244291, 558474, 552995, 244280, 244278, 244276, 244272, 552992, 431386, 244270, 244268, 552990, 431382, 412277, 545047, 558432, 558415, 620863, 412273, 552983, 552980, 552976, 552974, 233132, 557650, 431374, 557648, 233129, 233125, 233122, 180961, 108788, 431361, 405788, 557991, 557980, 558133, 552932, 133050, 558059, 431353, 431342, 431337, 431334, 431331, 431328, 535866, 557585, 431320, 233120, 233117, 309465, 557580, 557578, 525898, 525896, 431291, 525894, 525892, 557572, 452657, 557569, 557566, 557563, 557560, 557553, 557551, 431288, 557523, 557521, 488255, 488254, 488251, 488248, 409704, 557509, 552922, 431281, 540002, 540000, 539998, 539996, 431273, 539993, 233103, 539991, 539989, 233095, 233090, 233088, 556330, 557493, 557490, 557488, 557486, 557483, 233085, 557457, 556326, 529218, 431258, 431255, 315758, 529216, 431251, 520201, 529209, 431200, 477824, 412257, 385951, 477821, 477819, 555406, 556707, 505359, 556702, 233021, 233018, 529187, 556628, 431156, 431154, 529181, 556310, 529179, 555954, 431127, 220001, 219999, 219994, 529176, 219983, 219969, 556303, 556297, 620769, 219966, 244247, 219958, 556133, 556160, 556130, 555951, 431042, 555581, 555579, 555678, 431009, 553122, 555566, 553120, 555367, 553116, 361480, 552197, 552195, 553112, 552191, 545041, 535854, 624910, 452731, 624905, 529127, 624901, 398449, 232966, 232964, 303432, 333817, 333815, 430869, 554578, 554457, 244223, 430825, 529106, 535843, 552535, 244205, 529099, 552366, 232896, 219917, 552364, 200195, 552043, 552506, 519977, 552295, 430768, 430713, 552170, 550017, 219889, 547382, 550656, 529078, 620634, 430673, 551766, 620630, 549086, 549083, 551820, 551745, 549021, 620606, 481688, 549019, 309431, 309429, 551467, 309424, 551403, 551475, 551414, 551412, 551398, 551326, 219858, 430572, 551310, 551307, 551086, 551021, 550478, 550190, 548724, 548722, 548720, 547625, 542747, 527661, 549004, 549395, 219806, 549390, 548890, 219803, 548886, 549945, 549364, 549942, 620537, 108731, 464252, 464250, 464247, 464243, 549270, 309407, 219782, 547595, 620508, 547582, 547579, 620505, 547530, 545838, 465142, 503675, 546857, 546855, 546853, 430038, 620490, 620488, 430034, 620486, 546201, 430001, 536483, 546685, 546729, 546683, 429954, 546044, 546041, 244092, 469909, 429893, 545199, 232702, 232699, 544308, 544629, 544909, 541852, 544650, 542285, 542282, 542279, 542277, 544364, 543945, 535822, 544301, 429751, 429731, 429729, 544075, 429681, 429668, 543780, 543526, 525293, 429609, 429606, 429604, 429601, 429598, 429592, 543517, 219545, 429567, 522783, 108685, 429547, 543371, 542535, 542532, 543334, 542574, 543331, 543329, 542569, 543327, 542565, 132909, 542525, 309357, 309352, 542390, 542418, 542384, 542414, 471210, 542245, 542238, 542235, 497499, 542227, 142407, 142405, 142403, 429413, 429408, 429403, 269034, 269032, 108679, 542112, 108669, 525190, 429392, 488544, 429389, 525168, 541942, 541965, 541952, 525145, 429356, 429354, 541840, 541837, 368265, 541738, 541154, 429324, 540505, 620139, 541210, 540494, 429297, 429294, 429292, 429289, 429287, 429285, 429282, 541132, 429279, 485651, 541030, 429254, 174295, 540923, 540719, 524995, 524988, 524984, 540259, 540116, 540257, 540621, 371792, 524964, 540456, 540450, 539067, 540368, 540101, 406447, 540265, 524946, 331327, 540097, 243969, 132895, 132891, 429169, 243963, 485630, 485627, 514081, 539810, 539807, 538098, 539805, 524889, 539831, 539678, 538261, 524867, 418816, 539630, 524859, 243951, 526622, 232533, 232531, 524846, 471204, 471202, 485618, 538898, 455469, 535416, 539247, 485616, 535691, 535689, 539107, 455466, 528699, 243945, 528439, 200001, 538820, 199998, 538818, 538917, 484451, 538839, 243922, 527198, 243920, 538679, 537069, 322505, 538601, 538586, 497956, 524826, 132884, 528683, 243905, 243903, 538536, 243902, 429015, 62598, 485584, 537592, 537569, 620058, 527579, 620056, 219392, 401323, 537564, 537561, 62596, 537555, 219387, 528438, 535405, 535402, 535399, 535397, 535394, 535392, 624805, 535390, 535381, 537339, 537332, 537329, 108596, 537299, 428971, 524613, 524610, 527251, 362447, 537065, 199964, 315751, 535513, 428844, 528640, 536527, 536524, 528638, 528627, 535177, 374337, 535174, 528576, 528434, 619990, 528430, 528427, 528425, 619986, 619982, 619978, 528419, 325075, 323593, 524333, 528415, 528413, 528408, 528362, 524306, 333736, 528061, 528059, 428755, 526890, 526870, 219204, 414866, 526797, 428660, 526763, 428653, 428648, 219191, 485550, 485548, 526616, 412022, 619946, 526611, 414856, 619943, 526704, 526702, 619940, 219187, 414851, 428643, 519251, 524130, 524127, 524104, 524100, 471179, 524097, 524090, 428614, 524071, 524066, 524055, 524053, 524051, 524047, 524044, 524029, 520778, 520775, 523861, 523859, 523794, 619925, 321144, 619923, 243784, 523314, 523532, 522180, 523303, 243771, 243763, 219168, 219163, 219161, 243756, 243754, 243752, 243750, 243748, 428521, 243738, 243735, 243733, 523298, 619913, 243729, 619911, 523296, 523294, 480418, 480416, 523292, 512244, 523269, 523030, 523025, 523020, 219146, 523018, 522795, 356259, 356257, 428510, 523016, 356254, 519942, 219144, 428492, 522970, 512241, 485511, 517313, 522763, 371759, 522383, 516593, 522166, 516588, 522162, 489799, 219118, 521170, 522092, 521527, 243661, 243659, 243657, 521648, 619827, 521615, 513731, 521414, 513729, 521511, 521412, 521410, 521497, 521495, 243653, 520384, 519728, 520368, 518397, 428065, 428009, 519536, 501673, 164157, 419773, 619688, 518800, 365239, 365233, 132793, 619676, 619673, 619671, 619669, 619667, 411998, 514225, 517281, 619655, 485478, 329564, 517992, 329559, 365228, 512933, 512930, 247625, 427885, 427883, 485473, 518081, 516951, 518112, 518110, 427879, 518108, 517989, 518106, 518104, 185354, 518079, 427877, 518077, 518075, 518073, 518071, 518069, 619650, 517986, 469577, 469575, 517215, 427872, 516947, 517630, 517210, 517208, 517103, 427842, 502728, 516849, 243586, 108403, 516738, 515728, 389702, 481554, 218862, 232125, 492134, 218857, 218854, 619543, 619541, 516122, 501662, 515795, 501660, 404380, 619534, 467109, 467107, 404378, 459732, 619525, 514466, 404372, 353133, 514778, 515147, 333705, 514765, 514207, 513878, 514140, 513991, 513324, 513989, 513987, 513985, 513981, 513979, 513867, 513315, 513829, 474048, 619505, 427687, 510416, 513687, 513685, 389700, 499490, 513489, 218728, 512975, 619488, 512970, 513240, 619482, 513233, 513217, 506425, 511341, 232066, 494812, 513043, 331322, 455436, 344558, 427661, 512916, 218686, 512898, 512859, 512896, 512892, 512853, 506412, 506410, 506408, 506949, 323574, 512454, 309301, 260944, 247615, 427626, 247613, 247611, 218669, 512043, 512041, 512013, 619455, 512000, 511952, 511895, 243507, 511737, 511733, 619447, 619445, 243503, 243494, 45579, 619427, 485395, 315740, 511317, 511338, 479523, 199727, 511173, 510456, 619407, 619405, 619392, 243464, 510878, 510876, 510894, 510892, 510454, 510889, 510874, 510872, 427434, 510818, 510815, 510824, 510822, 510451, 411961, 619384, 411959, 510411, 510810, 619378, 349139, 619376, 510673, 510654, 510652, 510649, 510647, 510645, 188809, 188807, 619371, 510466, 619369, 510521, 509860, 411952, 508761, 509832, 509826, 509824, 509822, 509820, 510432, 362341, 619324, 619303, 509796, 252855, 427251, 427242, 199657, 371738, 509789, 509732, 509190, 231947, 231939, 427133, 108369, 509082, 619256, 508798, 508796, 619254, 508794, 508792, 110385, 509135, 509133, 619252, 108364, 619250, 218577, 231929, 231923, 108338, 427119, 231921, 427117, 108332, 108330, 218574, 108328, 508835, 218570, 619247, 509009, 508706, 508704, 619240, 508127, 508753, 508783, 508751, 508700, 508780, 508749, 468999, 427099, 508747, 508690, 508688, 508684, 508679, 508676, 309283, 309279, 309271, 502364, 427064, 619226, 485348, 427059, 427056, 508132, 427028, 243378, 619208, 218527, 315730, 309234, 411915, 416597, 416595, 416593, 416591, 218518, 619195, 330277, 619192, 619189, 619186, 108313, 493726, 427020, 427017, 427015, 427013, 108310, 508087, 108307, 108305, 243361, 619180, 338967, 508048, 508033, 485340, 426997, 507944, 309232, 507934, 507931, 619174, 507926, 619172, 619168, 507922, 309207, 199593, 619158, 309204, 469795, 371715, 371712, 371708, 619115, 619113, 619110, 507332, 507314, 243317, 243314, 507102, 360812, 411894, 400114, 199563, 426904, 231842, 426900, 400113, 504311, 496232, 426894, 501621, 506058, 504475, 402725, 309092, 489989, 414821, 309088, 309084, 498337, 505825, 421932, 505871, 505869, 505866, 498331, 243190, 231771, 504493, 494801, 504456, 504454, 504452, 504279, 504274, 504290, 504272, 504288, 504269, 108280, 400108, 468314, 618988, 426643, 504039, 231621, 504035, 243125, 504033, 503537, 504031, 426635, 503535, 243120, 363700, 243116, 243112, 504029, 504052, 504049, 363697, 504025, 503954, 504020, 504016, 504010, 504007, 504003, 503999, 503950, 243107, 231605, 503948, 231601, 231586, 108278, 309017, 323550, 426586, 503664, 426584, 503662, 503565, 503563, 503561, 503558, 503661, 218323, 503869, 503863, 503658, 503861, 503656, 503653, 503614, 499183, 503417, 503415, 503346, 502894, 426526, 367297, 426483, 502585, 501934, 501930, 501927, 501924, 450242, 618945, 426413, 624723, 624720, 426279, 371198, 371195, 501425, 501423, 501437, 501398, 501420, 371186, 501303, 242999, 500846, 499623, 499621, 242982, 242980, 231373, 218157, 323542, 500098, 500095, 500076, 500074, 499945, 500089, 624703, 500087, 500085, 500046, 231359, 499787, 426093, 499002, 322461, 498429, 624683, 498473, 498736, 498471, 498968, 498965, 498959, 498963, 498957, 498384, 498734, 231183, 426005, 494796, 231166, 494793, 494791, 231124, 494292, 494830, 494786, 494784, 494782, 494780, 494778, 494612, 321007, 494553, 494551, 494503, 367267, 483499, 494464, 367265, 425806, 618756, 231118, 494460, 367264, 425792, 618754, 494290, 494473, 494348, 494178, 494283, 494280, 494159, 490900, 494056, 490891, 490889, 493966, 493854, 493852, 493849, 490886, 618728, 231071, 397595, 493739, 242812, 492935, 492933, 248358, 492929, 492926, 493004, 425673, 492913, 618699, 492486, 242780, 242778, 483474, 483471, 618671, 618669, 618667, 618664, 618662, 618660, 492064, 618658, 491966, 491958, 491956, 491790, 491786, 491519, 491522, 230919, 618635, 491515, 491507, 491505, 618631, 491478, 491503, 491480, 491300, 491280, 425520, 490132, 491141, 491121, 490991, 491119, 490778, 400079, 484139, 425473, 472573, 108061, 242633, 472569, 262006, 230729, 487333, 242569, 487330, 262003, 487372, 472567, 324944, 618589, 262001, 486956, 487325, 618584, 367232, 425240, 618581, 230710, 230708, 230704, 230703, 242553, 242540, 487083, 487081, 618571, 472565, 108010, 425221, 425218, 425216, 487005, 487002, 421850, 421848, 421846, 486995, 421841, 486990, 486933, 108005, 367227, 185674, 185672, 618563, 185670, 618561, 185664, 185662, 486411, 185660, 486409, 486396, 486378, 341317, 320920, 341308, 485081, 486109, 108002, 107999, 485075, 367223, 484998, 485025, 484996, 485023, 485021, 485019, 485068, 399257, 618557, 485017, 485063, 425164, 485112, 618554, 485061, 485109, 618552, 618550, 618548, 485059, 230680, 618538, 618536, 618534, 618532, 618530, 107995, 472556, 485010, 242525, 484072, 480763, 483872, 483870, 483866, 482792, 618489, 483516, 618471, 618464, 618462, 618460, 387056, 483041, 483038, 483034, 483029, 483025, 483021, 483017, 483016, 483012, 483011, 482993, 483007, 482339, 425075, 482254, 482394, 242430, 482396, 482238, 482234, 482334, 482076, 618427, 618425, 217494, 454891, 482229, 482283, 482281, 482279, 482277, 618422, 482275, 482272, 482270, 413428, 454889, 482071, 482069, 482169, 480664, 217484, 481966, 480887, 425002, 480759, 480942, 480658, 217467, 480774, 479746, 480755, 480777, 480771, 480769, 480767, 480630, 618369, 618367, 480624, 480622, 480551, 480620, 618365, 466572, 480615, 480506, 618359, 618357, 618355, 618353, 480434, 480432, 618351, 618348, 618346, 480545, 618343, 618341, 199037, 618336, 242335, 230505, 480096, 424935, 424930, 424927, 479245, 618319, 618314, 618311, 107971, 107969, 107967, 618309, 479658, 424906, 479943, 242299, 479357, 479355, 479353, 11933, 367178, 479011, 249670, 171792, 478968, 479123, 217403, 479082, 479073, 618253, 479080, 479070, 479023, 479062, 618249, 479059, 479019, 479056, 478313, 477898, 476935, 478006, 476933, 477896, 478142, 618238, 424854, 477234, 477960, 230360, 424842, 477900, 424838, 424836, 424832, 424829, 424824, 471071, 477062, 107933, 107929, 424804, 477056, 477054, 477052, 424801, 424796, 477227, 424794, 618232, 477278, 477047, 477212, 477045, 477209, 477245, 477242, 618230, 459172, 476968, 475306, 475304, 230305, 618220, 424773, 424771, 424770, 322419, 107887, 242221, 476565, 242219, 476578, 476576, 476371, 476562, 476559, 424767, 476554, 424758, 476415, 476411, 476400, 476397, 472179, 457179, 424742, 471605, 249559, 624512, 618180, 462721, 476382, 424731, 472168, 476361, 618177, 424719, 476358, 468580, 618175, 476356, 476351, 476249, 476325, 618172, 424714, 424664, 473861, 217270, 198876, 474944, 424653, 474886, 474881, 230214, 230212, 230210, 406416, 473476, 470511, 474439, 107853, 473653, 107847, 470500, 242139, 323504, 472526, 242112, 371638, 618111, 618109, 217112, 618107, 230124, 618079, 470548, 470545, 470488, 470542, 470539, 470537, 242058, 470535, 470471, 618071, 242055, 470524, 470486, 367148, 470483, 242053, 618068, 242042, 469727, 465475, 424477, 469528, 217024, 217022, 424475, 468713, 468711, 469126, 469151, 469167, 469146, 469068, 618057, 618054, 217011, 468686, 468677, 468683, 466723, 468522, 241921, 241916, 467868, 467866, 467163, 468005, 468059, 468013, 241864, 467638, 424370, 467675, 467636, 467634, 467632, 467630, 424360, 241841, 467096, 467094, 467092, 354153, 466948, 424319, 241806, 180959, 252768, 322396, 241801, 466081, 180956, 424246, 466125, 466418, 463197, 463195, 420596, 463193, 420593, 463191, 463188, 463182, 180949, 466296, 466294, 466292, 466312, 466290, 466071, 466304, 466288, 466069, 466241, 107790, 229947, 229945, 465852, 466059, 466050, 463844, 463842, 463840, 180947, 618000, 241751, 465936, 617997, 107783, 424219, 461287, 461286, 465932, 461283, 461280, 465926, 461278, 465929, 465924, 461272, 315719, 315717, 205657, 465898, 465880, 461005, 456119, 465782, 465780, 617994, 424212, 424207, 424205, 424203, 424202, 107780, 465663, 107778, 420587, 420585, 420583, 216870, 241740, 455621, 465602, 617991, 216860, 624450, 465505, 465378, 465579, 406357, 465467, 465465, 460787, 331711, 465463, 465461, 465459, 406350, 229923, 198549, 465401, 424188, 424184, 424182, 424179, 462088, 424175, 462085, 464754, 464752, 464750, 464488, 464483, 464545, 424165, 198543, 464543, 464540, 457618, 464538, 457615, 464533, 462078, 464529, 464526, 456571, 464481, 464479, 424163, 464898, 463977, 424150, 424148, 464628, 424147, 241721, 241718, 464624, 464622, 624440, 216819, 464742, 241713, 241709, 464611, 464664, 464474, 464609, 464662, 107764, 198528, 464230, 464228, 205616, 205614, 107728, 424131, 424129, 464214, 107706, 463972, 463969, 463966, 107698, 107695, 463918, 261299, 198489, 463913, 463803, 463800, 463797, 463905, 463901, 463793, 463791, 198483, 241675, 462413, 462411, 462409, 462059, 462405, 462402, 320717, 216791, 261296, 402695, 462050, 462298, 132422, 132418, 132416, 132414, 462116, 22958, 461669, 461664, 216736, 216730, 216728, 241604, 216726, 216723, 216718, 241600, 241596, 107655, 22947, 461345, 461340, 461117, 424001, 461113, 461111, 107638, 461107, 461105, 241582, 107634, 241566, 460374, 459982, 459980, 459977, 460298, 198387, 241562, 241560, 229776, 229773, 458292, 617944, 229770, 423935, 617941, 454324, 198380, 454321, 229764, 229762, 229760, 229758, 229756, 229754, 241557, 460443, 460440, 460438, 460435, 460431, 460429, 460048, 229752, 459327, 460425, 460423, 460420, 460456, 460418, 460454, 423930, 459325, 460411, 459975, 241548, 459962, 459960, 367113, 459957, 459955, 459953, 460232, 459950, 459948, 460228, 460226, 460224, 229743, 229741, 241527, 459944, 460103, 460101, 459942, 459939, 459936, 459934, 460041, 460038, 460035, 460031, 460029, 460027, 460024, 459670, 459668, 459906, 459904, 459902, 459899, 617931, 617929, 459558, 459580, 454235, 216682, 229735, 617924, 459826, 459578, 459821, 459860, 36961, 459816, 459316, 459855, 459853, 459314, 459575, 459311, 459659, 241511, 337199, 459634, 337197, 459552, 459550, 459243, 459159, 456760, 459077, 450086, 457490, 457488, 458750, 229721, 458738, 458736, 456860, 458027, 420546, 241464, 449647, 457656, 457652, 457566, 456858, 456856, 456853, 617818, 456519, 617810, 454302, 617783, 617774, 320662, 617770, 617767, 216586, 617763, 617760, 617758, 617753, 617751, 617749, 456075, 456000, 241368, 455929, 455913, 455895, 455909, 455908, 455905, 455903, 455683, 455871, 376092, 455886, 455849, 455865, 455847, 455746, 241360, 455719, 455710, 241354, 455678, 455672, 216573, 617704, 241346, 229624, 229622, 229620, 229617, 229602, 455173, 455629, 229598, 455627, 455625, 216568, 216565, 617701, 423842, 455575, 455268, 617699, 617697, 455232, 617693, 455229, 455227, 454927, 454925, 454923, 454920, 454918, 229577, 454915, 455124, 455122, 198215, 454950, 454166, 454946, 107602, 454505, 454162, 454502, 454380, 454500, 454498, 454158, 454855, 454474, 216541, 216537, 454378, 454470, 454467, 453010, 454375, 454463, 107594, 454455, 216525, 454488, 454451, 454447, 454445, 454442, 198201, 419404, 423826, 229557, 453216, 452191, 454273, 452188, 454270, 420522, 110201, 454254, 241293, 454105, 453298, 205545, 320655, 320650, 107547, 107542, 107540, 216492, 453296, 453277, 453275, 453270, 409690, 453044, 453042, 229539, 229536, 453007, 417231, 417573, 216474, 241252, 617631, 107521, 216458, 452434, 452431, 198135, 198133, 452313, 359931, 452208, 317001, 316999, 422667, 241228, 452265, 402658, 387443, 451424, 241212, 229482, 451416, 329315, 451758, 402654, 414783, 216428, 451440, 241164, 367098, 450660, 450647, 449206, 450144, 450142, 229445, 241147, 450043, 449542, 450134, 450131, 450129, 450127, 450125, 450123, 450120, 450034, 229421, 450117, 450113, 449466, 450111, 449463, 449461, 450108, 449876, 449459, 450106, 450104, 448795, 450101, 450032, 450099, 450097, 216411, 449456, 449454, 449996, 449994, 449992, 216403, 449989, 205532, 449909, 216401, 447856, 449985, 449983, 449979, 216336, 449037, 448904, 448945, 448943, 448936, 411647, 198047, 241068, 448927, 241065, 359916, 448920, 359911, 448901, 241061, 107454, 107452, 198042, 448654, 448649, 448325, 241023, 241019, 241017, 241015, 241013, 308800, 448167, 448444, 448273, 448031, 448028, 240999, 107433, 362711, 216285, 423668, 423100, 107430, 229229, 216283, 416225, 423621, 423619, 216279, 423616, 216276, 617476, 617474, 423426, 423424, 617470, 418693, 413263, 216262, 422042, 197973, 197971, 216242, 421974, 132229, 229124, 197969, 216238, 132223, 132221, 421326, 240884, 197963, 132204, 398640, 422040, 422146, 422139, 422137, 322344, 422135, 422053, 216236, 422029, 421816, 422080, 421814, 422037, 132197, 420067, 421800, 421798, 421599, 421684, 421681, 421679, 420060, 420058, 421554, 421552, 617450, 617448, 421559, 421550, 229098, 617443, 205522, 421526, 229095, 421417, 229093, 421415, 421412, 419738, 419736, 197945, 617432, 421318, 421316, 421314, 421312, 421036, 395540, 240853, 107368, 420188, 420470, 420467, 229085, 229072, 240806, 240790, 419873, 419871, 240786, 419869, 419867, 419698, 419865, 617394, 617392, 617389, 617384, 617382, 617380, 418077, 197928, 419847, 419691, 406902, 229057, 197912, 419566, 419564, 419560, 419558, 419553, 419549, 419427, 107344, 197901, 240734, 418883, 418971, 418876, 418874, 418869, 418864, 216151, 418587, 381553, 361053, 418423, 240718, 617335, 240714, 416976, 417219, 417628, 240711, 417215, 417408, 617307, 617299, 417139, 417111, 417137, 417065, 216095, 228985, 365039, 197858, 216091, 416968, 416183, 416985, 228964, 416179, 416937, 216089, 228951, 416575, 240674, 240672, 216082, 416814, 416812, 416747, 617273, 416738, 416734, 416730, 617270, 416727, 416725, 416720, 416718, 617268, 416716, 416703, 416701, 240649, 240647, 416656, 416654, 416652, 416649, 416646, 416641, 416638, 416636, 416466, 416461, 410847, 413259, 393290, 240606, 228920, 415837, 416148, 203375, 415714, 415710, 415688, 639811, 415271, 415266, 132131, 132129, 132126, 132123, 228870, 617235, 414755, 617232, 414750, 414747, 197816, 197814, 197812, 414441, 415033, 415051, 414763, 197806, 107252, 414674, 414742, 414696, 414740, 216036, 414626, 414615, 216032, 216027, 413504, 413502, 414434, 216016, 240539, 414374, 240536, 414372, 414430, 240531, 414370, 414377, 413590, 413487, 216002, 413485, 413587, 402090, 413585, 413479, 215995, 240525, 240520, 413541, 329499, 413539, 413536, 215975, 107247, 107245, 107243, 107241, 413531, 107237, 617219, 375514, 413440, 413196, 413406, 413444, 413442, 413438, 413403, 413400, 215965, 413397, 617214, 413392, 215960, 215957, 330082, 413228, 330081, 215946, 413293, 413304, 215942, 413210, 197769, 413065, 240488, 240485, 413170, 413145, 413136, 413133, 228804, 228802, 413061, 412959, 107226, 107222, 107211, 338003, 337997, 412719, 107194, 228793, 228786, 228782, 174272, 412782, 412779, 412776, 412772, 240471, 412700, 412698, 350082, 350080, 312281, 312276, 312274, 312271, 312269, 240463, 312267, 617200, 215914, 312265, 312263, 312261, 409270, 409267, 411297, 411295, 322329, 240455, 228478, 408135, 240144, 402079, 402077, 215711, 405193, 402075, 228473, 215700, 228463, 228461, 228459, 240140, 240136, 197608, 228456, 228439, 403387, 228434, 617148, 215686, 325502, 404659, 407781, 407785, 407779, 240111, 323403, 400056, 407497, 400053, 400518, 407729, 400050, 407726, 407718, 240107, 407419, 197589, 403858, 407493, 228397, 197580, 240089, 405681, 407401, 407398, 228382, 215669, 228367, 228363, 228359, 228357, 354725, 354723, 239977, 215637, 406527, 406525, 406161, 406532, 388568, 406522, 406116, 400037, 107042, 322307, 406111, 406106, 228254, 228245, 228243, 23400, 215615, 405381, 405567, 400026, 215604, 215602, 405486, 405484, 239943, 239941, 405022, 228215, 367064, 367057, 404327, 404325, 239898, 197436, 239888, 403384, 403379, 403376, 403374, 403371, 403369, 403367, 228193, 400988, 403296, 106921, 400980, 239865, 402074, 402072, 402070, 402068, 367040, 239844, 402894, 402911, 398965, 106884, 106880, 228178, 400513, 400511, 401819, 401817, 401815, 401811, 215486, 401806, 398963, 215481, 367037, 398959, 398957, 398955, 106874, 106871, 401798, 239820, 239818, 367033, 239814, 402301, 239812, 402169, 402166, 399177, 402164, 402162, 402159, 399174, 399172, 399170, 402157, 364150, 402155, 399167, 402288, 215460, 402151, 400960, 106864, 402148, 402253, 402146, 617032, 402144, 239808, 106862, 402063, 402061, 106860, 402056, 401784, 401782, 402053, 239797, 402051, 402049, 239794, 106856, 239791, 239789, 205470, 401766, 401763, 401759, 401755, 391865, 205467, 401749, 391863, 401744, 401738, 401580, 401734, 401578, 401576, 401728, 401574, 401726, 401571, 401723, 362235, 401720, 401952, 215454, 401950, 239768, 239766, 239764, 401694, 239748, 239745, 239743, 239737, 239735, 401549, 401564, 401562, 362195, 362193, 239708, 401540, 367029, 188128, 132048, 188123, 362184, 362180, 362174, 362172, 362169, 362167, 362164, 362162, 362159, 362155, 362144, 362142, 362140, 362137, 239674, 239669, 239643, 239641, 239639, 215412, 401199, 215408, 401249, 228119, 401247, 400839, 401197, 215405, 401195, 401193, 401283, 228112, 400834, 400828, 400891, 400825, 401171, 401153, 215397, 215394, 400716, 401142, 401151, 401149, 401135, 215391, 401133, 400742, 215389, 400705, 215386, 400868, 400701, 400739, 396975, 400736, 400821, 400769, 396971, 215384, 215382, 400727, 215379, 400725, 400536, 215377, 389678, 400534, 132030, 400530, 400528, 215373, 132027, 132025, 396969, 132019, 400562, 132015, 400560, 325771, 400553, 215370, 215367, 400549, 400545, 400541, 400539, 394727, 394724, 394722, 400493, 394720, 394717, 400490, 396966, 228097, 215352, 215349, 400247, 400241, 400239, 399138, 398635, 398634, 398632, 215311, 398618, 398614, 399105, 239559, 106796, 398976, 394605, 398753, 398751, 398523, 398584, 308779, 398582, 398580, 398572, 398570, 398730, 398566, 398555, 393656, 393654, 393651, 239470, 392505, 239467, 392502, 393902, 397121, 106740, 397032, 106732, 396611, 396094, 397076, 397072, 106729, 397069, 397029, 616944, 616942, 616940, 396891, 396889, 396887, 395519, 395516, 395513, 395511, 616934, 395509, 395507, 396088, 395505, 395503, 396085, 616930, 396870, 616927, 396694, 396777, 396773, 396767, 395645, 329272, 395642, 395400, 227801, 227797, 395672, 395652, 395631, 395650, 239351, 239349, 239347, 395353, 394469, 131915, 131913, 131911, 131909, 393374, 131907, 215101, 394092, 394089, 239265, 394087, 239256, 394085, 393338, 239252, 393336, 393627, 385339, 393648, 393334, 389425, 393718, 393713, 393346, 393624, 389419, 392278, 391848, 392980, 616778, 392391, 349363, 227666, 616764, 616761, 376603, 391839, 392306, 616757, 391834, 391826, 371492, 389648, 389645, 389643, 375628, 238920, 616586, 616584, 238897, 238895, 383029, 227538, 387313, 616520, 214852, 214846, 294241, 387329, 387232, 616517, 616515, 387291, 294238, 214838, 227511, 387222, 214824, 227467, 227463, 238769, 238765, 238737, 385695, 385335, 238699, 385329, 616490, 385349, 385326, 385323, 375917, 384289, 214714, 106462, 106456, 385241, 214701, 385134, 238667, 384736, 385108, 106452, 385061, 227380, 106447, 238657, 384864, 616485, 384862, 214686, 106442, 106428, 106426, 384890, 616481, 384729, 106403, 238630, 616479, 384287, 227360, 616476, 616473, 227340, 214600, 106377, 616469, 106374, 616467, 106372, 106369, 238569, 384281, 384105, 238555, 227327, 382940, 378449, 383020, 378416, 378414, 214501, 616428, 378376, 378365, 371162, 371161, 371158, 371154, 378343, 378341, 279827, 238467, 616379, 214459, 378335, 381428, 205321, 366928, 379843, 379839, 180918, 180917, 238448, 379769, 379717, 379714, 379712, 227195, 366925, 378329, 378327, 366922, 196780, 616371, 616368, 252726, 329268, 106335, 106332, 106330, 106328, 379055, 227176, 238414, 378470, 238381, 378526, 98816, 227143, 214400, 378309, 371462, 238379, 214398, 378467, 238370, 227140, 180914, 359515, 180913, 180912, 238342, 180908, 214347, 364995, 364993, 238281, 238275, 238272, 238270, 350593, 238268, 238266, 238265, 238263, 238261, 238258, 238256, 238254, 238252, 238249, 214318, 227018, 227014, 363550, 238242, 376625, 238217, 329267, 376520, 376517, 376515, 376513, 376510, 376508, 376506, 376443, 110081, 376440, 376314, 376024, 226969, 214287, 366908, 214283, 375846, 375940, 375935, 214280, 346269, 238196, 364990, 364988, 375910, 238190, 375467, 214246, 238183, 238181, 308638, 226960, 308635, 308633, 214235, 226958, 174206, 214232, 214224, 196613, 106230, 362115, 106227, 362113, 106223, 375508, 106220, 375505, 375503, 374939, 370910, 375634, 214210, 214208, 375597, 375464, 226954, 226952, 106207, 106203, 226949, 375456, 106191, 365127, 375158, 346257, 375424, 375155, 238169, 370272, 238167, 375151, 346253, 375145, 346251, 374205, 196611, 375137, 359504, 372391, 214197, 375128, 214195, 346243, 214192, 329266, 372388, 346241, 346239, 346236, 214186, 214184, 214180, 214178, 214175, 214166, 214164, 214162, 238162, 106183, 238156, 374816, 346214, 346205, 346203, 375016, 372387, 238148, 372968, 214143, 214135, 374980, 238132, 238127, 238125, 238122, 360764, 360762, 374445, 359501, 106160, 226941, 374802, 374757, 374795, 374793, 374789, 374785, 374783, 374780, 374439, 374890, 374753, 374882, 374880, 370268, 374747, 374762, 309953, 309951, 350588, 372964, 374605, 372962, 214120, 372309, 372307, 226935, 374263, 374254, 372305, 226933, 372302, 374418, 214116, 372300, 252679, 371456, 298139, 298137, 308607, 363838, 196600, 214094, 373615, 196598, 238101, 131814, 279080, 180907, 180905, 180904, 180902, 238100, 238097, 372298, 362071, 372950, 372948, 214015, 372946, 372681, 347725, 372900, 362063, 347723, 372679, 370243, 347721, 347719, 370594, 371444, 370462, 371442, 362057, 371440, 370460, 372372, 362054, 371438, 362050, 238074, 372368, 180901, 238069, 362048, 180898, 329259, 366854, 213964, 370458, 362044, 370456, 106095, 106092, 196581, 213947, 369384, 369382, 213941, 196572, 196568, 371013, 213932, 371011, 371007, 371005, 371002, 213929, 370453, 213926, 213922, 360744, 372293, 252669, 252667, 372291, 252662, 360737, 372284, 370451, 360734, 372281, 372276, 365671, 371412, 98801, 371410, 372274, 213888, 213886, 213877, 213872, 226811, 238053, 369651, 362039, 362036, 362034, 362032, 362030, 371293, 238047, 213858, 363833, 363831, 370992, 213853, 371242, 196545, 371043, 348252, 348249, 370448, 213848, 196534, 370444, 226758, 226756, 226754, 363822, 226752, 363814, 106050, 226748, 213844, 196525, 196522, 213840, 213834, 213830, 213828, 213825, 196519, 213811, 359481, 213798, 213785, 370592, 213782, 106040, 370438, 226720, 226716, 226705, 196482, 226670, 226668, 370250, 370241, 196465, 213744, 226666, 226664, 213740, 106037, 370124, 226645, 213732, 370122, 213729, 213726, 238011, 238009, 238007, 238005, 369755, 369753, 213701, 359473, 180875, 352523, 180861, 180859, 180857, 180855, 368737, 213664, 356992, 368824, 237969, 368817, 237966, 213648, 213645, 213643, 368494, 237955, 366706, 237953, 180841, 213633, 213630, 213627, 366703, 237945, 367739, 350585, 226571, 350580, 180825, 350579, 367884, 367876, 226569, 367795, 226567, 226565, 226563, 367793, 367882, 367873, 367792, 367871, 367791, 366850, 213611, 367790, 366847, 366844, 366842, 366701, 366837, 366654, 367789, 367788, 237942, 366833, 367787, 367786, 366831, 367785, 367784, 367783, 367782, 367781, 213602, 366697, 252631, 367726, 366695, 366889, 237937, 366862, 366692, 366826, 350578, 366434, 237924, 237922, 237919, 237917, 237915, 237913, 366689, 366687, 237911, 237906, 366600, 298119, 180810, 226526, 322188, 105982, 237874, 322187, 365581, 365859, 365579, 365577, 365856, 365854, 105978, 363616, 105975, 237867, 237865, 365575, 365094, 365883, 365430, 365881, 364919, 365720, 365427, 237854, 365570, 237841, 226505, 237837, 237835, 365849, 365847, 226499, 365845, 226497, 105969, 105967, 180809, 180807, 213553, 226482, 322180, 364986, 213529, 308569, 237792, 226454, 213512, 174204, 110069, 363257, 237787, 237784, 364740, 322175, 105938, 226438, 350573, 364736, 364675, 350570, 350567, 350563, 363344, 364229, 364436, 364435, 364433, 364431, 364428, 364455, 364452, 364450, 213475, 364468, 364427, 364424, 226418, 213467, 364193, 363614, 364188, 363613, 213407, 363729, 237745, 213399, 363726, 363724, 363722, 363863, 363606, 213370, 363603, 363602, 363601, 298114, 363678, 363676, 363674, 363672, 363600, 363599, 363598, 363597, 363668, 363666, 308547, 308540, 213361, 308538, 363594, 237737, 237735, 363592, 237723, 360678, 298110, 360676, 237719, 237715, 298108, 213328, 237713, 363327, 363324, 363319, 363316, 363314, 237707, 363140, 226332, 363138, 363247, 363136, 363244, 226324, 363242, 226318, 180790, 226315, 363032, 226312, 363030, 361650, 363028, 363211, 363025, 363023, 363203, 363105, 363102, 363014, 363013, 180783, 362970, 363006, 226304, 213306, 226302, 285841, 361862, 361920, 361858, 361914, 252587, 213297, 237639, 237636, 105838, 237630, 361671, 361669, 237620, 105823, 361666, 105810, 105808, 237566, 226225, 237563, 226217, 226202, 226200, 226197, 105795, 226185, 360639, 361006, 360910, 298054, 348235, 360837, 213269, 298052, 213265, 226167, 226127, 237509, 348943, 359142, 358400, 298050, 213197, 213194, 226060, 226057, 226056, 356609, 237490, 213192, 213184, 225974, 213147, 359048, 322159, 359045, 322157, 322155, 359033, 213139, 225963, 213128, 237438, 358600, 358641, 213124, 225961, 225956, 225941, 358562, 252550, 225934, 298038, 298036, 298030, 237390, 109997, 252543, 105686, 358267, 237359, 357027, 358155, 237349, 350550, 350548, 350546, 350542, 180735, 180732, 212962, 356928, 191798, 356327, 212885, 191783, 225706, 225704, 105618, 105615, 105613, 356323, 191777, 191774, 225690, 98794, 237229, 191762, 191760, 105610, 105608, 351483, 237182, 237180, 237176, 237171, 237165, 237163, 353385, 252498, 237149, 180612, 353937, 252493, 353935, 353933, 350533, 353819, 351481, 225517, 180588, 252488, 180586, 180584, 180582, 180580, 351478, 353884, 180577, 180575, 180573, 180571, 351950, 180569, 180567, 180565, 353804, 353795, 225515, 353791, 252486, 353383, 353631, 353628, 353622, 353617, 353615, 353613, 353611, 353607, 353605, 353603, 353674, 353594, 353591, 353588, 353586, 212728, 350527, 353512, 353510, 353508, 225493, 252480, 212719, 353464, 353461, 353431, 180558, 105510, 353413, 105508, 351973, 353205, 351477, 225482, 351971, 225479, 351475, 351472, 348733, 352735, 351470, 353196, 180543, 212701, 180535, 180533, 180531, 180529, 180526, 180523, 180521, 180519, 180517, 180515, 180512, 212698, 237107, 180505, 225453, 180502, 180495, 105470, 237096, 237094, 351948, 105467, 180492, 322108, 351945, 237089, 212670, 212667, 212663, 252471, 180474, 180472, 180464, 180458, 237076, 225442, 225440, 180456, 141218, 351934, 141215, 351932, 225418, 351929, 351469, 225405, 225401, 351966, 351467, 351924, 351923, 237039, 212642, 225391, 351913, 351911, 225388, 225385, 225382, 225380, 225378, 225375, 225371, 225370, 225368, 351890, 350510, 105460, 351888, 350508, 105458, 237024, 351886, 105456, 105453, 212630, 252468, 225364, 225362, 225358, 298011, 351465, 225350, 105451, 351711, 351708, 212615, 351706, 351702, 351462, 351460, 351458, 196183, 348730, 351455, 351452, 334289, 351552, 252454, 298009, 351550, 225328, 350129, 351450, 351548, 237016, 351547, 351545, 212600, 351499, 350768, 334284, 338583, 351449, 351447, 225305, 298006, 350154, 237012, 350152, 350120, 350766, 351438, 350117, 351276, 351307, 351357, 105424, 351183, 351182, 351181, 131721, 350408, 350406, 298001, 350761, 350760, 350404, 351088, 350758, 252445, 350756, 237002, 236998, 350487, 252442, 156243, 350844, 212581, 225253, 350482, 350806, 350804, 350480, 350477, 350794, 350475, 350473, 212579, 131686, 212577, 212575, 212573, 344017, 350645, 350599, 350597, 350595, 225243, 350467, 225240, 350465, 225237, 225234, 350395, 225231, 350403, 347415, 350401, 346005, 350399, 350392, 348484, 310257, 350390, 350397))
Run Time: 0.237448
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 5851 | |
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 | | | | | 5851 | |
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 (32588, 32483, 30423, 30245, 29968, 29932, 29715, 29672, 29523, 28735, 27415, 27394, 27268, 26417, 26171, 26064, 25977, 25079, 24806, 24185, 24027, 23256, 23190, 23163, 22479, 21925, 21740, 21463, 21100, 21053, 20725, 20694, 20464, 20349, 20326, 20243, 20124, 19809, 19393, 18807, 18432, 18385, 18259, 18219, 18173, 17955, 17683, 17591, 17552, 17521, 17491, 17484, 17463, 17459, 17453, 17452))
Run Time: 0.008372
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 56 | 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 (534715, 446520, 446514, 534711, 534710, 593647, 608582, 441104, 607193, 532932, 607190, 607187, 607185, 607183, 607181, 532928, 607179, 607177, 607175, 607171, 607169, 607167, 607165, 607163, 532925, 607161, 607109, 607158, 439524, 594355, 594348, 439279, 532426, 439158, 532423, 592547, 438958, 591378, 580085, 532184, 438753, 438751, 591090, 591087, 591085, 591052, 591071, 469320, 221899, 554543, 554541, 532097, 580966, 580964, 580963, 580962, 438643, 532095, 438620, 438606, 110708, 110706, 438583, 438581, 438578, 438576, 438574, 532072, 438567, 438561, 532068, 246645, 548344, 438538, 246639, 246631, 246618, 438508, 246564, 590338, 438397, 531977, 438350, 437703, 437686, 437632, 437609, 437536, 437534, 437516, 437514, 531782, 437436, 437271, 399372, 437268, 489156, 437227, 437102, 246168, 189198, 436882, 531480, 531477, 587081, 436620, 585943, 585936, 531408, 531399, 586228, 586226, 585445, 584947, 579347, 484804, 585388, 246003, 585385, 436250, 436240, 109030, 585336, 585334, 436137, 585255, 585253, 585178, 403207, 581023, 585076, 585073, 315784, 554715, 221574, 531285, 622427, 353947, 369257, 369255, 435863, 584752, 435829, 584731, 584729, 579291, 579289, 578232, 581019, 581964, 200687, 584514, 580915, 531248, 245932, 245928, 369252, 315780, 531236, 435783, 578423, 124287, 584274, 571250, 124285, 435688, 435686, 435684, 435682, 435679, 584265, 584261, 435669, 584259, 581014, 435658, 435617, 584236, 584219, 584253, 584251, 500359, 584200, 584198, 435555, 435550, 435544, 579207, 584146, 531202, 584142, 531200, 584140, 109001, 108999, 108997, 584138, 221493, 221489, 221487, 221483, 500301, 221481, 221479, 221476, 221473, 221469, 221465, 435523, 369251, 584087, 584082, 584080, 369250, 622357, 584073, 584059, 584043, 580896, 579193, 579184, 435438, 369244, 435377, 581709, 435314, 579066, 579064, 579062, 579058, 536123, 581527, 531149, 245843, 245840, 579043, 581498, 435204, 435194, 435191, 531119, 581103, 200598, 577803, 200597, 580855, 580850, 580845, 578796, 435113, 580834, 337050, 580801, 580794, 580792, 580775, 578767, 531060, 578314, 235141, 235138, 435081, 435078, 435076, 435074, 531049, 576670, 531024, 531018, 435026, 435021, 578671, 578668, 578656, 578654, 408808, 531014, 578666, 108984, 235063, 577730, 245692, 542793, 576901, 576898, 576896, 576894, 576891, 576887, 576881, 108975, 235010, 399355, 530960, 530957, 577992, 577718, 577716, 526430, 577794, 526427, 245611, 434860, 434833, 399353, 399348, 399345, 421957, 546779, 434793, 577712, 245580, 245578, 245574, 245566, 330472, 576940, 576938, 234882, 577535, 577533, 553980, 536101, 234870, 434596, 200504, 573363, 567214, 245533, 573359, 573357, 573354, 573352, 434539, 245524, 530815, 434523, 573350, 434468, 434450, 434448, 234811, 234808, 234803, 530788, 434362, 573348, 234796, 434306, 434303, 576741, 576737, 530778, 548618, 548616, 530777, 576728, 536693, 200466, 434248, 234746, 234740, 576724, 576713, 234717, 576711, 234713, 576709, 234691, 234689, 570202, 576579, 221190, 221187, 530749, 200459, 221165, 530722, 530720, 108870, 576312, 407894, 576198, 530715, 434166, 576439, 576465, 576462, 576437, 572754, 622097, 572752, 576343, 576341, 576339, 234493, 576173, 399339, 551690, 245337, 245335, 434138, 245300, 245273, 245271, 530674, 530670, 434136, 434134, 573462, 536083, 434008, 453668, 575019, 433889, 234322, 245137, 245135, 530492, 200400, 530488, 530485, 530477, 245092, 570833, 234254, 234252, 574644, 234237, 234233, 234192, 234177, 521978, 234151, 234143, 234140, 530409, 574128, 234096, 234094, 234092, 574122, 234090, 234088, 234086, 234080, 433613, 245041, 530380, 433576, 569460, 433560, 530372, 530354, 234024, 530342, 530335, 530323, 200355, 433515, 572974, 530316, 234009, 220969, 234006, 570965, 110605, 573525, 573508, 245034, 536038, 530292, 573410, 573399, 573395, 386003, 234001, 233998, 233996, 233994, 233992, 233990, 233988, 530259, 530257, 530255, 573292, 433486, 6547, 530250, 572796, 530248, 244969, 244966, 433474, 244964, 399337, 530241, 244948, 200338, 572607, 530228, 572721, 433451, 244930, 433435, 108865, 108863, 244919, 244917, 244914, 244912, 530201, 530199, 572672, 433423, 530191, 572657, 548276, 265547, 433399, 433397, 244903, 572601, 220931, 433389, 530173, 530169, 244782, 572497, 572205, 572486, 530148, 220922, 433363, 433354, 433352, 433350, 433348, 433346, 433344, 433339, 469955, 469951, 572350, 572348, 572344, 572341, 572091, 572337, 572320, 572317, 572314, 244763, 244761, 233927, 571956, 530130, 233905, 233902, 572173, 573588, 573586, 570934, 570932, 530121, 244741, 244739, 244737, 570927, 573578, 530117, 323631, 383620, 433172, 433158, 433156, 433150, 244730, 433142, 433115, 571824, 571819, 571814, 571807, 571805, 571803, 571799, 571497, 538653, 571794, 571790, 571740, 571733, 530094, 433099, 433091, 571675, 484793, 484790, 484785, 484782, 484779, 530089, 571671, 530084, 571661, 571659, 571656, 530076, 530074, 233871, 433026, 433024, 530067, 530063, 433020, 433017, 233832, 220896, 530049, 571460, 571455, 530041, 220887, 530024, 571386, 369188, 244696, 530017, 529978, 309694, 546834, 244693, 244664, 244661, 571034, 571082, 526913, 566307, 488088, 309665, 309663, 529869, 621669, 200302, 529864, 309636, 309634, 529860, 570923, 570921, 570919, 570916, 570759, 570756, 569959, 569957, 621643, 570746, 473611, 200300, 529852, 309609, 529844, 570714, 309603, 309583, 309580, 309576, 309574, 309572, 529841, 570635, 570633, 570631, 526280, 526278, 621581, 570612, 529837, 555378, 497505, 553658, 553656, 553653, 553651, 553649, 553646, 553644, 553642, 553640, 553638, 553630, 529832, 555374, 553614, 220780, 220777, 553601, 432742, 529817, 553588, 535999, 419855, 553579, 419853, 479033, 570509, 374345, 310019, 310015, 570465, 569644, 271498, 432698, 570457, 220751, 529811, 570441, 569631, 220748, 569628, 569626, 501833, 569624, 220744, 482802, 220737, 220735, 466967, 569618, 569611, 569609, 108857, 133128, 220732, 569606, 569604, 220729, 569602, 569600, 569598, 570319, 570317, 570315, 570313, 570311, 570416, 529802, 570414, 570411, 466963, 466961, 466959, 553565, 568580, 466957, 466955, 535995, 535991, 220702, 220700, 535987, 418794, 432677, 432675, 418792, 432672, 432670, 547179, 244600, 529793, 547175, 108854, 220698, 108851, 529791, 108849, 108847, 535984, 287290, 108845, 529789, 535980, 535978, 503127, 453647, 547172, 108841, 108839, 108835, 108833, 547167, 547164, 220694, 220691, 471258, 220688, 529787, 220686, 471255, 220684, 471252, 471249, 550917, 108830, 471247, 535973, 471245, 432662, 432659, 108827, 233729, 471239, 558856, 233724, 233719, 558852, 233717, 233715, 471233, 471231, 233713, 482795, 233711, 569941, 233709, 233707, 233705, 220676, 220674, 233703, 233700, 570086, 570184, 570084, 432632, 220666, 529780, 570081, 220663, 570064, 432626, 432624, 220658, 529776, 569931, 432584, 233679, 233677, 233675, 233667, 233656, 529757, 553542, 553533, 553522, 569803, 200276, 233640, 569703, 220594, 569700, 569707, 569698, 569590, 108817, 569587, 569583, 569580, 569657, 569655, 432546, 432524, 108814, 563535, 529731, 244583, 309561, 569504, 569395, 569463, 472774, 569393, 565362, 569391, 569439, 563532, 569437, 621380, 621378, 206044, 206042, 206040, 621372, 220571, 553487, 247431, 244578, 233631, 233626, 568552, 568550, 233622, 553478, 432475, 432472, 568543, 233618, 567179, 542777, 463078, 220563, 244567, 220561, 569338, 569334, 529710, 220550, 569307, 569305, 432463, 569350, 569348, 432460, 569322, 569344, 529706, 371878, 432458, 521975, 569332, 569329, 432456, 569300, 569297, 569320, 200265, 371876, 521972, 529702, 521970, 569315, 569313, 496697, 529699, 568001, 567999, 567997, 567994, 567990, 569272, 569311, 569263, 432449, 529693, 569238, 25395, 25392, 529690, 560741, 561388, 25390, 25388, 25386, 244560, 529688, 569251, 529686, 220535, 560739, 561386, 560736, 560734, 569161, 569159, 569156, 569154, 569152, 529679, 496680, 558788, 569128, 569126, 560730, 569141, 496678, 569063, 244554, 560720, 529672, 560718, 558779, 233606, 529670, 560715, 569056, 529665, 108811, 569013, 432415, 432410, 560700, 432402, 615339, 615337, 615335, 563612, 244548, 568721, 526244, 553466, 568659, 73192, 568532, 110541, 565762, 220509, 423652, 220507, 568346, 529643, 568482, 514603, 514597, 514594, 164594, 514585, 526219, 432376, 543969, 543967, 567921, 567294, 567919, 567289, 529618, 567858, 567854, 567852, 559101, 310567, 529616, 110537, 559099, 567514, 529614, 244537, 567707, 547803, 526206, 526204, 220486, 220484, 526202, 526199, 567512, 432317, 432313, 244534, 561374, 567333, 554900, 567112, 561367, 432274, 567109, 567107, 567105, 432271, 567103, 567100, 220454, 220452, 220450, 432260, 529590, 567118, 432248, 565434, 527731, 529578, 526156, 526154, 484838, 363269, 567387, 567284, 567281, 567278, 529572, 567276, 567273, 567320, 561364, 526149, 567307, 567297, 567040, 561362, 419464, 561360, 561358, 374942, 567036, 432237, 529567, 565750, 554891, 565745, 565211, 565743, 554880, 567017, 554877, 567097, 220416, 567061, 220414, 220412, 567059, 554875, 567056, 567054, 567052, 567045, 565197, 567000, 566650, 432215, 220396, 469934, 621253, 621251, 315766, 529562, 553461, 561353, 529559, 561333, 566646, 566644, 563521, 561330, 561324, 561322, 563518, 561320, 566662, 566640, 220384, 566638, 200255, 529556, 133107, 432199, 133105, 561316, 36109, 565188, 566474, 566472, 405886, 405884, 565524, 566478, 244511, 621207, 621204, 621202, 621200, 269072, 269069, 566298, 566296, 432182, 566294, 527715, 621189, 220362, 621186, 621184, 621180, 621178, 621174, 529549, 432170, 565697, 566224, 566211, 566209, 566205, 565904, 565900, 244508, 565840, 565838, 244506, 546980, 559596, 561313, 432161, 565444, 244503, 538860, 244501, 565385, 432123, 432120, 529533, 561963, 561958, 561955, 565296, 432053, 432048, 432045, 432043, 469931, 432039, 432027, 432025, 432022, 432020, 432018, 432016, 537704, 565183, 565215, 565181, 432014, 565068, 565065, 565059, 554674, 565008, 551105, 564841, 564835, 564839, 564837, 564722, 554671, 564781, 564711, 220305, 220303, 220301, 220299, 360046, 529519, 360044, 529516, 564463, 383617, 431978, 244495, 529503, 529499, 244493, 529495, 564405, 563685, 564343, 233442, 392854, 431954, 469923, 469921, 431952, 563695, 563693, 564193, 483417, 483408, 431944, 483404, 483400, 483397, 200244, 483395, 483393, 475027, 233415, 483390, 431942, 564059, 564055, 564052, 233409, 564050, 233407, 564048, 564046, 529476, 564039, 624960, 564036, 563917, 483385, 563830, 563828, 309556, 563826, 563912, 563910, 563906, 309552, 563903, 309549, 563901, 309547, 309545, 563899, 563896, 563891, 563889, 563887, 563884, 603510, 23504, 23502, 529474, 431940, 23500, 529472, 563756, 563240, 563754, 563745, 563739, 563797, 563795, 563793, 563737, 563791, 563789, 561302, 563727, 561185, 220263, 554539, 431911, 220261, 486931, 392847, 244475, 323619, 244473, 563670, 529460, 551430, 559441, 551428, 535430, 562112, 563662, 563688, 563660, 529457, 220257, 562110, 431890, 431886, 431884, 431882, 431872, 527697, 562105, 369150, 562103, 369148, 233398, 541374, 541369, 541363, 408600, 621069, 529435, 220243, 529430, 541313, 431840, 529428, 431835, 399287, 399284, 526012, 413325, 309517, 309503, 309499, 431792, 535907, 535904, 553418, 563183, 244453, 563252, 529422, 431771, 431767, 200239, 562777, 493548, 244437, 562753, 562751, 562748, 562238, 233378, 562689, 562097, 529411, 233377, 233375, 529407, 562687, 562569, 562567, 220231, 562564, 562562, 529405, 431699, 562488, 562485, 562483, 562478, 309467, 529394, 560212, 496673, 558467, 562395, 492428, 562374, 562372, 561565, 562091, 562089, 562086, 407889, 562290, 529388, 244392, 562082, 562077, 220190, 561929, 561924, 561913, 233335, 412293, 233328, 233319, 561619, 554863, 561617, 554861, 561558, 561556, 561292, 220169, 233292, 220165, 561554, 561563, 554859, 554857, 561552, 554855, 558441, 549832, 535890, 529360, 244379, 561399, 220155, 561290, 233286, 525992, 529353, 529351, 220149, 561206, 561203, 560433, 23494, 541856, 431653, 560785, 529319, 529313, 557656, 560687, 560684, 560682, 560679, 560677, 560675, 315763, 431607, 537695, 431603, 392839, 560393, 560206, 560371, 560204, 560369, 560202, 624939, 624937, 560199, 559760, 385959, 559591, 551662, 560185, 560182, 560180, 331355, 559748, 385953, 518714, 560102, 560048, 220088, 624935, 559878, 559917, 431559, 559914, 559870, 485809, 559868, 559862, 559734, 559782, 559725, 559710, 559707, 559704, 559577, 180964, 559571, 556152, 529294, 559303, 539079, 539074, 556148, 556145, 559563, 559534, 559560, 559532, 220065, 559326, 244364, 550129, 431508, 529281, 559296, 244352, 244350, 529275, 525927, 244341, 540653, 559036, 431471, 405804, 405802, 431468, 233185, 233183, 233179, 529271, 421998, 558271, 333824, 547909, 233149, 233147, 620885, 620883, 549978, 110527, 549973, 558671, 558660, 431424, 431410, 233138, 558510, 554849, 554847, 554844, 431391, 554841, 554839, 558541, 624925, 244303, 558374, 244301, 558481, 244297, 529256, 624923, 244291, 558474, 552995, 244280, 244278, 244276, 244272, 552992, 431386, 244270, 244268, 552990, 431382, 412277, 545047, 558432, 558415, 620863, 412273, 552983, 552980, 552976, 552974, 233132, 557650, 431374, 557648, 233129, 233125, 233122, 180961, 108788, 431361, 405788, 557991, 557980, 558133, 552932, 133050, 558059, 431353, 431342, 431337, 431334, 431331, 431328, 535866, 557585, 431320, 233120, 233117, 309465, 557580, 557578, 525898, 525896, 431291, 525894, 525892, 557572, 452657, 557569, 557566, 557563, 557560, 557553, 557551, 431288, 557523, 557521, 488255, 488254, 488251, 488248, 409704, 557509, 552922, 431281, 540002, 540000, 539998, 539996, 431273, 539993, 233103, 539991, 539989, 233095, 233090, 233088, 556330, 557493, 557490, 557488, 557486, 557483, 233085, 557457, 556326, 529218, 431258, 431255, 315758, 529216, 431251, 520201, 529209, 431200, 477824, 412257, 385951, 477821, 477819, 555406, 556707, 505359, 556702, 233021, 233018, 529187, 556628, 431156, 431154, 529181, 556310, 529179, 555954, 431127, 220001, 219999, 219994, 529176, 219983, 219969, 556303, 556297, 620769, 219966, 244247, 219958, 556133, 556160, 556130, 555951, 431042, 555581, 555579, 555678, 431009, 553122, 555566, 553120, 555367, 553116, 361480, 552197, 552195, 553112, 552191, 545041, 535854, 624910, 452731, 624905, 529127, 624901, 398449, 232966, 232964, 303432, 333817, 333815, 430869, 554578, 554457, 244223, 430825, 529106, 535843, 552535, 244205, 529099, 552366, 232896, 219917, 552364, 200195, 552043, 552506, 519977, 552295, 430768, 430713, 552170, 550017, 219889, 547382, 550656, 529078, 620634, 430673, 551766, 620630, 549086, 549083, 551820, 551745, 549021, 620606, 481688, 549019, 309431, 309429, 551467, 309424, 551403, 551475, 551414, 551412, 551398, 551326, 219858, 430572, 551310, 551307, 551086, 551021, 550478, 550190, 548724, 548722, 548720, 547625, 542747, 527661, 549004, 549395, 219806, 549390, 548890, 219803, 548886, 549945, 549364, 549942, 620537, 108731, 464252, 464250, 464247, 464243, 549270, 309407, 219782, 547595, 620508, 547582, 547579, 620505, 547530, 545838, 465142, 503675, 546857, 546855, 546853, 430038, 620490, 620488, 430034, 620486, 546201, 430001, 536483, 546685, 546729, 546683, 429954, 546044, 546041, 244092, 469909, 429893, 545199, 232702, 232699, 544308, 544629, 544909, 541852, 544650, 542285, 542282, 542279, 542277, 544364, 543945, 535822, 544301, 429751, 429731, 429729, 544075, 429681, 429668, 543780, 543526, 525293, 429609, 429606, 429604, 429601, 429598, 429592, 543517, 219545, 429567, 522783, 108685, 429547, 543371, 542535, 542532, 543334, 542574, 543331, 543329, 542569, 543327, 542565, 132909, 542525, 309357, 309352, 542390, 542418, 542384, 542414, 471210, 542245, 542238, 542235, 497499, 542227, 142407, 142405, 142403, 429413, 429408, 429403, 269034, 269032, 108679, 542112, 108669, 525190, 429392, 488544, 429389, 525168, 541942, 541965, 541952, 525145, 429356, 429354, 541840, 541837, 368265, 541738, 541154, 429324, 540505, 620139, 541210, 540494, 429297, 429294, 429292, 429289, 429287, 429285, 429282, 541132, 429279, 485651, 541030, 429254, 174295, 540923, 540719, 524995, 524988, 524984, 540259, 540116, 540257, 540621, 371792, 524964, 540456, 540450, 539067, 540368, 540101, 406447, 540265, 524946, 331327, 540097, 243969, 132895, 132891, 429169, 243963, 485630, 485627, 514081, 539810, 539807, 538098, 539805, 524889, 539831, 539678, 538261, 524867, 418816, 539630, 524859, 243951, 526622, 232533, 232531, 524846, 471204, 471202, 485618, 538898, 455469, 535416, 539247, 485616, 535691, 535689, 539107, 455466, 528699, 243945, 528439, 200001, 538820, 199998, 538818, 538917, 484451, 538839, 243922, 527198, 243920, 538679, 537069, 322505, 538601, 538586, 497956, 524826, 132884, 528683, 243905, 243903, 538536, 243902, 429015, 62598, 485584, 537592, 537569, 620058, 527579, 620056, 219392, 401323, 537564, 537561, 62596, 537555, 219387, 528438, 535405, 535402, 535399, 535397, 535394, 535392, 624805, 535390, 535381, 537339, 537332, 537329, 108596, 537299, 428971, 524613, 524610, 527251, 362447, 537065, 199964, 315751, 535513, 428844, 528640, 536527, 536524, 528638, 528627, 535177, 374337, 535174, 528576, 528434, 619990, 528430, 528427, 528425, 619986, 619982, 619978, 528419, 325075, 323593, 524333, 528415, 528413, 528408, 528362, 524306, 333736, 528061, 528059, 428755, 526890, 526870, 219204, 414866, 526797, 428660, 526763, 428653, 428648, 219191, 485550, 485548, 526616, 412022, 619946, 526611, 414856, 619943, 526704, 526702, 619940, 219187, 414851, 428643, 519251, 524130, 524127, 524104, 524100, 471179, 524097, 524090, 428614, 524071, 524066, 524055, 524053, 524051, 524047, 524044, 524029, 520778, 520775, 523861, 523859, 523794, 619925, 321144, 619923, 243784, 523314, 523532, 522180, 523303, 243771, 243763, 219168, 219163, 219161, 243756, 243754, 243752, 243750, 243748, 428521, 243738, 243735, 243733, 523298, 619913, 243729, 619911, 523296, 523294, 480418, 480416, 523292, 512244, 523269, 523030, 523025, 523020, 219146, 523018, 522795, 356259, 356257, 428510, 523016, 356254, 519942, 219144, 428492, 522970, 512241, 485511, 517313, 522763, 371759, 522383, 516593, 522166, 516588, 522162, 489799, 219118, 521170, 522092, 521527, 243661, 243659, 243657, 521648, 619827, 521615, 513731, 521414, 513729, 521511, 521412, 521410, 521497, 521495, 243653, 520384, 519728, 520368, 518397, 428065, 428009, 519536, 501673, 164157, 419773, 619688, 518800, 365239, 365233, 132793, 619676, 619673, 619671, 619669, 619667, 411998, 514225, 517281, 619655, 485478, 329564, 517992, 329559, 365228, 512933, 512930, 247625, 427885, 427883, 485473, 518081, 516951, 518112, 518110, 427879, 518108, 517989, 518106, 518104, 185354, 518079, 427877, 518077, 518075, 518073, 518071, 518069, 619650, 517986, 469577, 469575, 517215, 427872, 516947, 517630, 517210, 517208, 517103, 427842, 502728, 516849, 243586, 108403, 516738, 515728, 389702, 481554, 218862, 232125, 492134, 218857, 218854, 619543, 619541, 516122, 501662, 515795, 501660, 404380, 619534, 467109, 467107, 404378, 459732, 619525, 514466, 404372, 353133, 514778, 515147, 333705, 514765, 514207, 513878, 514140, 513991, 513324, 513989, 513987, 513985, 513981, 513979, 513867, 513315, 513829, 474048, 619505, 427687, 510416, 513687, 513685, 389700, 499490, 513489, 218728, 512975, 619488, 512970, 513240, 619482, 513233, 513217, 506425, 511341, 232066, 494812, 513043, 331322, 455436, 344558, 427661, 512916, 218686, 512898, 512859, 512896, 512892, 512853, 506412, 506410, 506408, 506949, 323574, 512454, 309301, 260944, 247615, 427626, 247613, 247611, 218669, 512043, 512041, 512013, 619455, 512000, 511952, 511895, 243507, 511737, 511733, 619447, 619445, 243503, 243494, 45579, 619427, 485395, 315740, 511317, 511338, 479523, 199727, 511173, 510456, 619407, 619405, 619392, 243464, 510878, 510876, 510894, 510892, 510454, 510889, 510874, 510872, 427434, 510818, 510815, 510824, 510822, 510451, 411961, 619384, 411959, 510411, 510810, 619378, 349139, 619376, 510673, 510654, 510652, 510649, 510647, 510645, 188809, 188807, 619371, 510466, 619369, 510521, 509860, 411952, 508761, 509832, 509826, 509824, 509822, 509820, 510432, 362341, 619324, 619303, 509796, 252855, 427251, 427242, 199657, 371738, 509789, 509732, 509190, 231947, 231939, 427133, 108369, 509082, 619256, 508798, 508796, 619254, 508794, 508792, 110385, 509135, 509133, 619252, 108364, 619250, 218577, 231929, 231923, 108338, 427119, 231921, 427117, 108332, 108330, 218574, 108328, 508835, 218570, 619247, 509009, 508706, 508704, 619240, 508127, 508753, 508783, 508751, 508700, 508780, 508749, 468999, 427099, 508747, 508690, 508688, 508684, 508679, 508676, 309283, 309279, 309271, 502364, 427064, 619226, 485348, 427059, 427056, 508132, 427028, 243378, 619208, 218527, 315730, 309234, 411915, 416597, 416595, 416593, 416591, 218518, 619195, 330277, 619192, 619189, 619186, 108313, 493726, 427020, 427017, 427015, 427013, 108310, 508087, 108307, 108305, 243361, 619180, 338967, 508048, 508033, 485340, 426997, 507944, 309232, 507934, 507931, 619174, 507926, 619172, 619168, 507922, 309207, 199593, 619158, 309204, 469795, 371715, 371712, 371708, 619115, 619113, 619110, 507332, 507314, 243317, 243314, 507102, 360812, 411894, 400114, 199563, 426904, 231842, 426900, 400113, 504311, 496232, 426894, 501621, 506058, 504475, 402725, 309092, 489989, 414821, 309088, 309084, 498337, 505825, 421932, 505871, 505869, 505866, 498331, 243190, 231771, 504493, 494801, 504456, 504454, 504452, 504279, 504274, 504290, 504272, 504288, 504269, 108280, 400108, 468314, 618988, 426643, 504039, 231621, 504035, 243125, 504033, 503537, 504031, 426635, 503535, 243120, 363700, 243116, 243112, 504029, 504052, 504049, 363697, 504025, 503954, 504020, 504016, 504010, 504007, 504003, 503999, 503950, 243107, 231605, 503948, 231601, 231586, 108278, 309017, 323550, 426586, 503664, 426584, 503662, 503565, 503563, 503561, 503558, 503661, 218323, 503869, 503863, 503658, 503861, 503656, 503653, 503614, 499183, 503417, 503415, 503346, 502894, 426526, 367297, 426483, 502585, 501934, 501930, 501927, 501924, 450242, 618945, 426413, 624723, 624720, 426279, 371198, 371195, 501425, 501423, 501437, 501398, 501420, 371186, 501303, 242999, 500846, 499623, 499621, 242982, 242980, 231373, 218157, 323542, 500098, 500095, 500076, 500074, 499945, 500089, 624703, 500087, 500085, 500046, 231359, 499787, 426093, 499002, 322461, 498429, 624683, 498473, 498736, 498471, 498968, 498965, 498959, 498963, 498957, 498384, 498734, 231183, 426005, 494796, 231166, 494793, 494791, 231124, 494292, 494830, 494786, 494784, 494782, 494780, 494778, 494612, 321007, 494553, 494551, 494503, 367267, 483499, 494464, 367265, 425806, 618756, 231118, 494460, 367264, 425792, 618754, 494290, 494473, 494348, 494178, 494283, 494280, 494159, 490900, 494056, 490891, 490889, 493966, 493854, 493852, 493849, 490886, 618728, 231071, 397595, 493739, 242812, 492935, 492933, 248358, 492929, 492926, 493004, 425673, 492913, 618699, 492486, 242780, 242778, 483474, 483471, 618671, 618669, 618667, 618664, 618662, 618660, 492064, 618658, 491966, 491958, 491956, 491790, 491786, 491519, 491522, 230919, 618635, 491515, 491507, 491505, 618631, 491478, 491503, 491480, 491300, 491280, 425520, 490132, 491141, 491121, 490991, 491119, 490778, 400079, 484139, 425473, 472573, 108061, 242633, 472569, 262006, 230729, 487333, 242569, 487330, 262003, 487372, 472567, 324944, 618589, 262001, 486956, 487325, 618584, 367232, 425240, 618581, 230710, 230708, 230704, 230703, 242553, 242540, 487083, 487081, 618571, 472565, 108010, 425221, 425218, 425216, 487005, 487002, 421850, 421848, 421846, 486995, 421841, 486990, 486933, 108005, 367227, 185674, 185672, 618563, 185670, 618561, 185664, 185662, 486411, 185660, 486409, 486396, 486378, 341317, 320920, 341308, 485081, 486109, 108002, 107999, 485075, 367223, 484998, 485025, 484996, 485023, 485021, 485019, 485068, 399257, 618557, 485017, 485063, 425164, 485112, 618554, 485061, 485109, 618552, 618550, 618548, 485059, 230680, 618538, 618536, 618534, 618532, 618530, 107995, 472556, 485010, 242525, 484072, 480763, 483872, 483870, 483866, 482792, 618489, 483516, 618471, 618464, 618462, 618460, 387056, 483041, 483038, 483034, 483029, 483025, 483021, 483017, 483016, 483012, 483011, 482993, 483007, 482339, 425075, 482254, 482394, 242430, 482396, 482238, 482234, 482334, 482076, 618427, 618425, 217494, 454891, 482229, 482283, 482281, 482279, 482277, 618422, 482275, 482272, 482270, 413428, 454889, 482071, 482069, 482169, 480664, 217484, 481966, 480887, 425002, 480759, 480942, 480658, 217467, 480774, 479746, 480755, 480777, 480771, 480769, 480767, 480630, 618369, 618367, 480624, 480622, 480551, 480620, 618365, 466572, 480615, 480506, 618359, 618357, 618355, 618353, 480434, 480432, 618351, 618348, 618346, 480545, 618343, 618341, 199037, 618336, 242335, 230505, 480096, 424935, 424930, 424927, 479245, 618319, 618314, 618311, 107971, 107969, 107967, 618309, 479658, 424906, 479943, 242299, 479357, 479355, 479353, 11933, 367178, 479011, 249670, 171792, 478968, 479123, 217403, 479082, 479073, 618253, 479080, 479070, 479023, 479062, 618249, 479059, 479019, 479056, 478313, 477898, 476935, 478006, 476933, 477896, 478142, 618238, 424854, 477234, 477960, 230360, 424842, 477900, 424838, 424836, 424832, 424829, 424824, 471071, 477062, 107933, 107929, 424804, 477056, 477054, 477052, 424801, 424796, 477227, 424794, 618232, 477278, 477047, 477212, 477045, 477209, 477245, 477242, 618230, 459172, 476968, 475306, 475304, 230305, 618220, 424773, 424771, 424770, 322419, 107887, 242221, 476565, 242219, 476578, 476576, 476371, 476562, 476559, 424767, 476554, 424758, 476415, 476411, 476400, 476397, 472179, 457179, 424742, 471605, 249559, 624512, 618180, 462721, 476382, 424731, 472168, 476361, 618177, 424719, 476358, 468580, 618175, 476356, 476351, 476249, 476325, 618172, 424714, 424664, 473861, 217270, 198876, 474944, 424653, 474886, 474881, 230214, 230212, 230210, 406416, 473476, 470511, 474439, 107853, 473653, 107847, 470500, 242139, 323504, 472526, 242112, 371638, 618111, 618109, 217112, 618107, 230124, 618079, 470548, 470545, 470488, 470542, 470539, 470537, 242058, 470535, 470471, 618071, 242055, 470524, 470486, 367148, 470483, 242053, 618068, 242042, 469727, 465475, 424477, 469528, 217024, 217022, 424475, 468713, 468711, 469126, 469151, 469167, 469146, 469068, 618057, 618054, 217011, 468686, 468677, 468683, 466723, 468522, 241921, 241916, 467868, 467866, 467163, 468005, 468059, 468013, 241864, 467638, 424370, 467675, 467636, 467634, 467632, 467630, 424360, 241841, 467096, 467094, 467092, 354153, 466948, 424319, 241806, 180959, 252768, 322396, 241801, 466081, 180956, 424246, 466125, 466418, 463197, 463195, 420596, 463193, 420593, 463191, 463188, 463182, 180949, 466296, 466294, 466292, 466312, 466290, 466071, 466304, 466288, 466069, 466241, 107790, 229947, 229945, 465852, 466059, 466050, 463844, 463842, 463840, 180947, 618000, 241751, 465936, 617997, 107783, 424219, 461287, 461286, 465932, 461283, 461280, 465926, 461278, 465929, 465924, 461272, 315719, 315717, 205657, 465898, 465880, 461005, 456119, 465782, 465780, 617994, 424212, 424207, 424205, 424203, 424202, 107780, 465663, 107778, 420587, 420585, 420583, 216870, 241740, 455621, 465602, 617991, 216860, 624450, 465505, 465378, 465579, 406357, 465467, 465465, 460787, 331711, 465463, 465461, 465459, 406350, 229923, 198549, 465401, 424188, 424184, 424182, 424179, 462088, 424175, 462085, 464754, 464752, 464750, 464488, 464483, 464545, 424165, 198543, 464543, 464540, 457618, 464538, 457615, 464533, 462078, 464529, 464526, 456571, 464481, 464479, 424163, 464898, 463977, 424150, 424148, 464628, 424147, 241721, 241718, 464624, 464622, 624440, 216819, 464742, 241713, 241709, 464611, 464664, 464474, 464609, 464662, 107764, 198528, 464230, 464228, 205616, 205614, 107728, 424131, 424129, 464214, 107706, 463972, 463969, 463966, 107698, 107695, 463918, 261299, 198489, 463913, 463803, 463800, 463797, 463905, 463901, 463793, 463791, 198483, 241675, 462413, 462411, 462409, 462059, 462405, 462402, 320717, 216791, 261296, 402695, 462050, 462298, 132422, 132418, 132416, 132414, 462116, 22958, 461669, 461664, 216736, 216730, 216728, 241604, 216726, 216723, 216718, 241600, 241596, 107655, 22947, 461345, 461340, 461117, 424001, 461113, 461111, 107638, 461107, 461105, 241582, 107634, 241566, 460374, 459982, 459980, 459977, 460298, 198387, 241562, 241560, 229776, 229773, 458292, 617944, 229770, 423935, 617941, 454324, 198380, 454321, 229764, 229762, 229760, 229758, 229756, 229754, 241557, 460443, 460440, 460438, 460435, 460431, 460429, 460048, 229752, 459327, 460425, 460423, 460420, 460456, 460418, 460454, 423930, 459325, 460411, 459975, 241548, 459962, 459960, 367113, 459957, 459955, 459953, 460232, 459950, 459948, 460228, 460226, 460224, 229743, 229741, 241527, 459944, 460103, 460101, 459942, 459939, 459936, 459934, 460041, 460038, 460035, 460031, 460029, 460027, 460024, 459670, 459668, 459906, 459904, 459902, 459899, 617931, 617929, 459558, 459580, 454235, 216682, 229735, 617924, 459826, 459578, 459821, 459860, 36961, 459816, 459316, 459855, 459853, 459314, 459575, 459311, 459659, 241511, 337199, 459634, 337197, 459552, 459550, 459243, 459159, 456760, 459077, 450086, 457490, 457488, 458750, 229721, 458738, 458736, 456860, 458027, 420546, 241464, 449647, 457656, 457652, 457566, 456858, 456856, 456853, 617818, 456519, 617810, 454302, 617783, 617774, 320662, 617770, 617767, 216586, 617763, 617760, 617758, 617753, 617751, 617749, 456075, 456000, 241368, 455929, 455913, 455895, 455909, 455908, 455905, 455903, 455683, 455871, 376092, 455886, 455849, 455865, 455847, 455746, 241360, 455719, 455710, 241354, 455678, 455672, 216573, 617704, 241346, 229624, 229622, 229620, 229617, 229602, 455173, 455629, 229598, 455627, 455625, 216568, 216565, 617701, 423842, 455575, 455268, 617699, 617697, 455232, 617693, 455229, 455227, 454927, 454925, 454923, 454920, 454918, 229577, 454915, 455124, 455122, 198215, 454950, 454166, 454946, 107602, 454505, 454162, 454502, 454380, 454500, 454498, 454158, 454855, 454474, 216541, 216537, 454378, 454470, 454467, 453010, 454375, 454463, 107594, 454455, 216525, 454488, 454451, 454447, 454445, 454442, 198201, 419404, 423826, 229557, 453216, 452191, 454273, 452188, 454270, 420522, 110201, 454254, 241293, 454105, 453298, 205545, 320655, 320650, 107547, 107542, 107540, 216492, 453296, 453277, 453275, 453270, 409690, 453044, 453042, 229539, 229536, 453007, 417231, 417573, 216474, 241252, 617631, 107521, 216458, 452434, 452431, 198135, 198133, 452313, 359931, 452208, 317001, 316999, 422667, 241228, 452265, 402658, 387443, 451424, 241212, 229482, 451416, 329315, 451758, 402654, 414783, 216428, 451440, 241164, 367098, 450660, 450647, 449206, 450144, 450142, 229445, 241147, 450043, 449542, 450134, 450131, 450129, 450127, 450125, 450123, 450120, 450034, 229421, 450117, 450113, 449466, 450111, 449463, 449461, 450108, 449876, 449459, 450106, 450104, 448795, 450101, 450032, 450099, 450097, 216411, 449456, 449454, 449996, 449994, 449992, 216403, 449989, 205532, 449909, 216401, 447856, 449985, 449983, 449979, 216336, 449037, 448904, 448945, 448943, 448936, 411647, 198047, 241068, 448927, 241065, 359916, 448920, 359911, 448901, 241061, 107454, 107452, 198042, 448654, 448649, 448325, 241023, 241019, 241017, 241015, 241013, 308800, 448167, 448444, 448273, 448031, 448028, 240999, 107433, 362711, 216285, 423668, 423100, 107430, 229229, 216283, 416225, 423621, 423619, 216279, 423616, 216276, 617476, 617474, 423426, 423424, 617470, 418693, 413263, 216262, 422042, 197973, 197971, 216242, 421974, 132229, 229124, 197969, 216238, 132223, 132221, 421326, 240884, 197963, 132204, 398640, 422040, 422146, 422139, 422137, 322344, 422135, 422053, 216236, 422029, 421816, 422080, 421814, 422037, 132197, 420067, 421800, 421798, 421599, 421684, 421681, 421679, 420060, 420058, 421554, 421552, 617450, 617448, 421559, 421550, 229098, 617443, 205522, 421526, 229095, 421417, 229093, 421415, 421412, 419738, 419736, 197945, 617432, 421318, 421316, 421314, 421312, 421036, 395540, 240853, 107368, 420188, 420470, 420467, 229085, 229072, 240806, 240790, 419873, 419871, 240786, 419869, 419867, 419698, 419865, 617394, 617392, 617389, 617384, 617382, 617380, 418077, 197928, 419847, 419691, 406902, 229057, 197912, 419566, 419564, 419560, 419558, 419553, 419549, 419427, 107344, 197901, 240734, 418883, 418971, 418876, 418874, 418869, 418864, 216151, 418587, 381553, 361053, 418423, 240718, 617335, 240714, 416976, 417219, 417628, 240711, 417215, 417408, 617307, 617299, 417139, 417111, 417137, 417065, 216095, 228985, 365039, 197858, 216091, 416968, 416183, 416985, 228964, 416179, 416937, 216089, 228951, 416575, 240674, 240672, 216082, 416814, 416812, 416747, 617273, 416738, 416734, 416730, 617270, 416727, 416725, 416720, 416718, 617268, 416716, 416703, 416701, 240649, 240647, 416656, 416654, 416652, 416649, 416646, 416641, 416638, 416636, 416466, 416461, 410847, 413259, 393290, 240606, 228920, 415837, 416148, 203375, 415714, 415710, 415688, 639811, 415271, 415266, 132131, 132129, 132126, 132123, 228870, 617235, 414755, 617232, 414750, 414747, 197816, 197814, 197812, 414441, 415033, 415051, 414763, 197806, 107252, 414674, 414742, 414696, 414740, 216036, 414626, 414615, 216032, 216027, 413504, 413502, 414434, 216016, 240539, 414374, 240536, 414372, 414430, 240531, 414370, 414377, 413590, 413487, 216002, 413485, 413587, 402090, 413585, 413479, 215995, 240525, 240520, 413541, 329499, 413539, 413536, 215975, 107247, 107245, 107243, 107241, 413531, 107237, 617219, 375514, 413440, 413196, 413406, 413444, 413442, 413438, 413403, 413400, 215965, 413397, 617214, 413392, 215960, 215957, 330082, 413228, 330081, 215946, 413293, 413304, 215942, 413210, 197769, 413065, 240488, 240485, 413170, 413145, 413136, 413133, 228804, 228802, 413061, 412959, 107226, 107222, 107211, 338003, 337997, 412719, 107194, 228793, 228786, 228782, 174272, 412782, 412779, 412776, 412772, 240471, 412700, 412698, 350082, 350080, 312281, 312276, 312274, 312271, 312269, 240463, 312267, 617200, 215914, 312265, 312263, 312261, 409270, 409267, 411297, 411295, 322329, 240455, 228478, 408135, 240144, 402079, 402077, 215711, 405193, 402075, 228473, 215700, 228463, 228461, 228459, 240140, 240136, 197608, 228456, 228439, 403387, 228434, 617148, 215686, 325502, 404659, 407781, 407785, 407779, 240111, 323403, 400056, 407497, 400053, 400518, 407729, 400050, 407726, 407718, 240107, 407419, 197589, 403858, 407493, 228397, 197580, 240089, 405681, 407401, 407398, 228382, 215669, 228367, 228363, 228359, 228357, 354725, 354723, 239977, 215637, 406527, 406525, 406161, 406532, 388568, 406522, 406116, 400037, 107042, 322307, 406111, 406106, 228254, 228245, 228243, 23400, 215615, 405381, 405567, 400026, 215604, 215602, 405486, 405484, 239943, 239941, 405022, 228215, 367064, 367057, 404327, 404325, 239898, 197436, 239888, 403384, 403379, 403376, 403374, 403371, 403369, 403367, 228193, 400988, 403296, 106921, 400980, 239865, 402074, 402072, 402070, 402068, 367040, 239844, 402894, 402911, 398965, 106884, 106880, 228178, 400513, 400511, 401819, 401817, 401815, 401811, 215486, 401806, 398963, 215481, 367037, 398959, 398957, 398955, 106874, 106871, 401798, 239820, 239818, 367033, 239814, 402301, 239812, 402169, 402166, 399177, 402164, 402162, 402159, 399174, 399172, 399170, 402157, 364150, 402155, 399167, 402288, 215460, 402151, 400960, 106864, 402148, 402253, 402146, 617032, 402144, 239808, 106862, 402063, 402061, 106860, 402056, 401784, 401782, 402053, 239797, 402051, 402049, 239794, 106856, 239791, 239789, 205470, 401766, 401763, 401759, 401755, 391865, 205467, 401749, 391863, 401744, 401738, 401580, 401734, 401578, 401576, 401728, 401574, 401726, 401571, 401723, 362235, 401720, 401952, 215454, 401950, 239768, 239766, 239764, 401694, 239748, 239745, 239743, 239737, 239735, 401549, 401564, 401562, 362195, 362193, 239708, 401540, 367029, 188128, 132048, 188123, 362184, 362180, 362174, 362172, 362169, 362167, 362164, 362162, 362159, 362155, 362144, 362142, 362140, 362137, 239674, 239669, 239643, 239641, 239639, 215412, 401199, 215408, 401249, 228119, 401247, 400839, 401197, 215405, 401195, 401193, 401283, 228112, 400834, 400828, 400891, 400825, 401171, 401153, 215397, 215394, 400716, 401142, 401151, 401149, 401135, 215391, 401133, 400742, 215389, 400705, 215386, 400868, 400701, 400739, 396975, 400736, 400821, 400769, 396971, 215384, 215382, 400727, 215379, 400725, 400536, 215377, 389678, 400534, 132030, 400530, 400528, 215373, 132027, 132025, 396969, 132019, 400562, 132015, 400560, 325771, 400553, 215370, 215367, 400549, 400545, 400541, 400539, 394727, 394724, 394722, 400493, 394720, 394717, 400490, 396966, 228097, 215352, 215349, 400247, 400241, 400239, 399138, 398635, 398634, 398632, 215311, 398618, 398614, 399105, 239559, 106796, 398976, 394605, 398753, 398751, 398523, 398584, 308779, 398582, 398580, 398572, 398570, 398730, 398566, 398555, 393656, 393654, 393651, 239470, 392505, 239467, 392502, 393902, 397121, 106740, 397032, 106732, 396611, 396094, 397076, 397072, 106729, 397069, 397029, 616944, 616942, 616940, 396891, 396889, 396887, 395519, 395516, 395513, 395511, 616934, 395509, 395507, 396088, 395505, 395503, 396085, 616930, 396870, 616927, 396694, 396777, 396773, 396767, 395645, 329272, 395642, 395400, 227801, 227797, 395672, 395652, 395631, 395650, 239351, 239349, 239347, 395353, 394469, 131915, 131913, 131911, 131909, 393374, 131907, 215101, 394092, 394089, 239265, 394087, 239256, 394085, 393338, 239252, 393336, 393627, 385339, 393648, 393334, 389425, 393718, 393713, 393346, 393624, 389419, 392278, 391848, 392980, 616778, 392391, 349363, 227666, 616764, 616761, 376603, 391839, 392306, 616757, 391834, 391826, 371492, 389648, 389645, 389643, 375628, 238920, 616586, 616584, 238897, 238895, 383029, 227538, 387313, 616520, 214852, 214846, 294241, 387329, 387232, 616517, 616515, 387291, 294238, 214838, 227511, 387222, 214824, 227467, 227463, 238769, 238765, 238737, 385695, 385335, 238699, 385329, 616490, 385349, 385326, 385323, 375917, 384289, 214714, 106462, 106456, 385241, 214701, 385134, 238667, 384736, 385108, 106452, 385061, 227380, 106447, 238657, 384864, 616485, 384862, 214686, 106442, 106428, 106426, 384890, 616481, 384729, 106403, 238630, 616479, 384287, 227360, 616476, 616473, 227340, 214600, 106377, 616469, 106374, 616467, 106372, 106369, 238569, 384281, 384105, 238555, 227327, 382940, 378449, 383020, 378416, 378414, 214501, 616428, 378376, 378365, 371162, 371161, 371158, 371154, 378343, 378341, 279827, 238467, 616379, 214459, 378335, 381428, 205321, 366928, 379843, 379839, 180918, 180917, 238448, 379769, 379717, 379714, 379712, 227195, 366925, 378329, 378327, 366922, 196780, 616371, 616368, 252726, 329268, 106335, 106332, 106330, 106328, 379055, 227176, 238414, 378470, 238381, 378526, 98816, 227143, 214400, 378309, 371462, 238379, 214398, 378467, 238370, 227140, 180914, 359515, 180913, 180912, 238342, 180908, 214347, 364995, 364993, 238281, 238275, 238272, 238270, 350593, 238268, 238266, 238265, 238263, 238261, 238258, 238256, 238254, 238252, 238249, 214318, 227018, 227014, 363550, 238242, 376625, 238217, 329267, 376520, 376517, 376515, 376513, 376510, 376508, 376506, 376443, 110081, 376440, 376314, 376024, 226969, 214287, 366908, 214283, 375846, 375940, 375935, 214280, 346269, 238196, 364990, 364988, 375910, 238190, 375467, 214246, 238183, 238181, 308638, 226960, 308635, 308633, 214235, 226958, 174206, 214232, 214224, 196613, 106230, 362115, 106227, 362113, 106223, 375508, 106220, 375505, 375503, 374939, 370910, 375634, 214210, 214208, 375597, 375464, 226954, 226952, 106207, 106203, 226949, 375456, 106191, 365127, 375158, 346257, 375424, 375155, 238169, 370272, 238167, 375151, 346253, 375145, 346251, 374205, 196611, 375137, 359504, 372391, 214197, 375128, 214195, 346243, 214192, 329266, 372388, 346241, 346239, 346236, 214186, 214184, 214180, 214178, 214175, 214166, 214164, 214162, 238162, 106183, 238156, 374816, 346214, 346205, 346203, 375016, 372387, 238148, 372968, 214143, 214135, 374980, 238132, 238127, 238125, 238122, 360764, 360762, 374445, 359501, 106160, 226941, 374802, 374757, 374795, 374793, 374789, 374785, 374783, 374780, 374439, 374890, 374753, 374882, 374880, 370268, 374747, 374762, 309953, 309951, 350588, 372964, 374605, 372962, 214120, 372309, 372307, 226935, 374263, 374254, 372305, 226933, 372302, 374418, 214116, 372300, 252679, 371456, 298139, 298137, 308607, 363838, 196600, 214094, 373615, 196598, 238101, 131814, 279080, 180907, 180905, 180904, 180902, 238100, 238097, 372298, 362071, 372950, 372948, 214015, 372946, 372681, 347725, 372900, 362063, 347723, 372679, 370243, 347721, 347719, 370594, 371444, 370462, 371442, 362057, 371440, 370460, 372372, 362054, 371438, 362050, 238074, 372368, 180901, 238069, 362048, 180898, 329259, 366854, 213964, 370458, 362044, 370456, 106095, 106092, 196581, 213947, 369384, 369382, 213941, 196572, 196568, 371013, 213932, 371011, 371007, 371005, 371002, 213929, 370453, 213926, 213922, 360744, 372293, 252669, 252667, 372291, 252662, 360737, 372284, 370451, 360734, 372281, 372276, 365671, 371412, 98801, 371410, 372274, 213888, 213886, 213877, 213872, 226811, 238053, 369651, 362039, 362036, 362034, 362032, 362030, 371293, 238047, 213858, 363833, 363831, 370992, 213853, 371242, 196545, 371043, 348252, 348249, 370448, 213848, 196534, 370444, 226758, 226756, 226754, 363822, 226752, 363814, 106050, 226748, 213844, 196525, 196522, 213840, 213834, 213830, 213828, 213825, 196519, 213811, 359481, 213798, 213785, 370592, 213782, 106040, 370438, 226720, 226716, 226705, 196482, 226670, 226668, 370250, 370241, 196465, 213744, 226666, 226664, 213740, 106037, 370124, 226645, 213732, 370122, 213729, 213726, 238011, 238009, 238007, 238005, 369755, 369753, 213701, 359473, 180875, 352523, 180861, 180859, 180857, 180855, 368737, 213664, 356992, 368824, 237969, 368817, 237966, 213648, 213645, 213643, 368494, 237955, 366706, 237953, 180841, 213633, 213630, 213627, 366703, 237945, 367739, 350585, 226571, 350580, 180825, 350579, 367884, 367876, 226569, 367795, 226567, 226565, 226563, 367793, 367882, 367873, 367792, 367871, 367791, 366850, 213611, 367790, 366847, 366844, 366842, 366701, 366837, 366654, 367789, 367788, 237942, 366833, 367787, 367786, 366831, 367785, 367784, 367783, 367782, 367781, 213602, 366697, 252631, 367726, 366695, 366889, 237937, 366862, 366692, 366826, 350578, 366434, 237924, 237922, 237919, 237917, 237915, 237913, 366689, 366687, 237911, 237906, 366600, 298119, 180810, 226526, 322188, 105982, 237874, 322187, 365581, 365859, 365579, 365577, 365856, 365854, 105978, 363616, 105975, 237867, 237865, 365575, 365094, 365883, 365430, 365881, 364919, 365720, 365427, 237854, 365570, 237841, 226505, 237837, 237835, 365849, 365847, 226499, 365845, 226497, 105969, 105967, 180809, 180807, 213553, 226482, 322180, 364986, 213529, 308569, 237792, 226454, 213512, 174204, 110069, 363257, 237787, 237784, 364740, 322175, 105938, 226438, 350573, 364736, 364675, 350570, 350567, 350563, 363344, 364229, 364436, 364435, 364433, 364431, 364428, 364455, 364452, 364450, 213475, 364468, 364427, 364424, 226418, 213467, 364193, 363614, 364188, 363613, 213407, 363729, 237745, 213399, 363726, 363724, 363722, 363863, 363606, 213370, 363603, 363602, 363601, 298114, 363678, 363676, 363674, 363672, 363600, 363599, 363598, 363597, 363668, 363666, 308547, 308540, 213361, 308538, 363594, 237737, 237735, 363592, 237723, 360678, 298110, 360676, 237719, 237715, 298108, 213328, 237713, 363327, 363324, 363319, 363316, 363314, 237707, 363140, 226332, 363138, 363247, 363136, 363244, 226324, 363242, 226318, 180790, 226315, 363032, 226312, 363030, 361650, 363028, 363211, 363025, 363023, 363203, 363105, 363102, 363014, 363013, 180783, 362970, 363006, 226304, 213306, 226302, 285841, 361862, 361920, 361858, 361914, 252587, 213297, 237639, 237636, 105838, 237630, 361671, 361669, 237620, 105823, 361666, 105810, 105808, 237566, 226225, 237563, 226217, 226202, 226200, 226197, 105795, 226185, 360639, 361006, 360910, 298054, 348235, 360837, 213269, 298052, 213265, 226167, 226127, 237509, 348943, 359142, 358400, 298050, 213197, 213194, 226060, 226057, 226056, 356609, 237490, 213192, 213184, 225974, 213147, 359048, 322159, 359045, 322157, 322155, 359033, 213139, 225963, 213128, 237438, 358600, 358641, 213124, 225961, 225956, 225941, 358562, 252550, 225934, 298038, 298036, 298030, 237390, 109997, 252543, 105686, 358267, 237359, 357027, 358155, 237349, 350550, 350548, 350546, 350542, 180735, 180732, 212962, 356928, 191798, 356327, 212885, 191783, 225706, 225704, 105618, 105615, 105613, 356323, 191777, 191774, 225690, 98794, 237229, 191762, 191760, 105610, 105608, 351483, 237182, 237180, 237176, 237171, 237165, 237163, 353385, 252498, 237149, 180612, 353937, 252493, 353935, 353933, 350533, 353819, 351481, 225517, 180588, 252488, 180586, 180584, 180582, 180580, 351478, 353884, 180577, 180575, 180573, 180571, 351950, 180569, 180567, 180565, 353804, 353795, 225515, 353791, 252486, 353383, 353631, 353628, 353622, 353617, 353615, 353613, 353611, 353607, 353605, 353603, 353674, 353594, 353591, 353588, 353586, 212728, 350527, 353512, 353510, 353508, 225493, 252480, 212719, 353464, 353461, 353431, 180558, 105510, 353413, 105508, 351973, 353205, 351477, 225482, 351971, 225479, 351475, 351472, 348733, 352735, 351470, 353196, 180543, 212701, 180535, 180533, 180531, 180529, 180526, 180523, 180521, 180519, 180517, 180515, 180512, 212698, 237107, 180505, 225453, 180502, 180495, 105470, 237096, 237094, 351948, 105467, 180492, 322108, 351945, 237089, 212670, 212667, 212663, 252471, 180474, 180472, 180464, 180458, 237076, 225442, 225440, 180456, 141218, 351934, 141215, 351932, 225418, 351929, 351469, 225405, 225401, 351966, 351467, 351924, 351923, 237039, 212642, 225391, 351913, 351911, 225388, 225385, 225382, 225380, 225378, 225375, 225371, 225370, 225368, 351890, 350510, 105460, 351888, 350508, 105458, 237024, 351886, 105456, 105453, 212630, 252468, 225364, 225362, 225358, 298011, 351465, 225350, 105451, 351711, 351708, 212615, 351706, 351702, 351462, 351460, 351458, 196183, 348730, 351455, 351452, 334289, 351552, 252454, 298009, 351550, 225328, 350129, 351450, 351548, 237016, 351547, 351545, 212600, 351499, 350768, 334284, 338583, 351449, 351447, 225305, 298006, 350154, 237012, 350152, 350120, 350766, 351438, 350117, 351276, 351307, 351357, 105424, 351183, 351182, 351181, 131721, 350408, 350406, 298001, 350761, 350760, 350404, 351088, 350758, 252445, 350756, 237002, 236998, 350487, 252442, 156243, 350844, 212581, 225253, 350482, 350806, 350804, 350480, 350477, 350794, 350475, 350473, 212579, 131686, 212577, 212575, 212573, 344017, 350645, 350599, 350597, 350595, 225243, 350467, 225240, 350465, 225237, 225234, 350395, 225231, 350403, 347415, 350401, 346005, 350399, 350392, 348484, 310257, 350390, 350397))
Run Time: 0.121555
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 5851 | |
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 | | | | | 5851 | |
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 (32588, 32483, 30423, 30245, 29968, 29932, 29715, 29672, 29523, 28735, 27415, 27394, 27268, 26417, 26171, 26064, 25977, 25079, 24806, 24185, 24027, 23256, 23190, 23163, 22479, 21925, 21740, 21463, 21100, 21053, 20725, 20694, 20464, 20349, 20326, 20243, 20124, 19809, 19393, 18807, 18432, 18385, 18259, 18219, 18173, 17955, 17683, 17591, 17552, 17521, 17491, 17484, 17463, 17459, 17453, 17452))
Run Time: 0.003056
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 56 | 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.000226
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: ���, XF\Pub\Controller\Member, RecentContent, valid, user_id=4040, 1716172169, , 0, ���
Run Time: 0.000183
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000366
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.000567
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: 1716171869
Run Time: 0.000360
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 33 | 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` >= 1716171869)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000535
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 33 | 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