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.000675
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 39 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 136
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/App.php at line 2040
- XF\App->preLoadData() in src/XF/App.php at line 2028
- XF\App->setup() in src/XF/Pub/App.php at line 94
- XF\Pub\App->setup() in src/XF.php at line 497
- XF::setupApp() in src/XF.php at line 520
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000191
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1219
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 245
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_profile_Profile_3`.*
FROM `xf_user`
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` = '2030')
LIMIT 1
Run Time: 0.000623
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.003390
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_2030' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.147920
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 (635113, 635108, 636703, 636487, 247253, 636056, 636647, 636550, 636475, 636453, 636473, 636440, 446646, 446644, 446642, 446638, 636232, 446628, 636322, 446625, 446620, 636318, 446617, 446594, 446592, 446590, 446588, 446582, 446580, 446573, 446570, 446568, 446556, 446554, 446552, 446548, 417918, 594640, 635087, 635199, 634925, 446315, 633890, 633888, 446225, 446163, 571168, 633211, 633364, 633207, 633203, 633294, 633362, 633201, 633199, 633194, 633191, 633188, 446131, 571165, 446117, 633039, 633037, 632175, 632244, 446079, 446076, 446074, 632902, 446070, 599031, 599026, 599023, 599018, 592686, 601618, 600505, 599009, 599007, 599005, 599976, 593131, 599974, 593129, 593126, 593123, 593113, 599921, 599936, 599931, 586595, 599002, 598990, 598989, 598987, 598983, 598969, 598967, 598965, 598963, 392949, 599155, 598437, 133299, 598311, 597685, 594626, 595313, 595050, 475414, 595048, 595129, 595119, 595114, 594245, 595041, 594762, 593867, 593864, 593860, 594361, 594169, 594359, 594345, 594230, 594228, 593677, 593589, 593548, 593538, 590726, 590722, 593376, 593371, 593364, 593262, 593232, 590713, 591606, 593003, 578591, 592934, 592891, 592774, 592767, 592628, 378167, 592203, 592040, 592002, 592030, 591998, 591996, 591992, 591806, 591803, 591800, 591796, 527949, 527940, 527925, 527914, 493336, 517435, 527860, 527857, 527849, 493331, 527840, 527838, 527835, 591264, 381038, 381035, 517420, 591316, 381033, 591313, 591310, 591308, 591306, 517411, 517409, 517407, 539544, 517403, 591103, 591096, 591089, 580968, 586088, 586086, 586084, 590292, 588804, 438480, 438459, 438450, 580029, 133237, 387865, 387863, 387858, 387855, 109154, 438207, 109152, 438203, 438199, 438196, 438026, 590111, 437890, 589832, 589562, 589821, 589816, 589560, 589601, 589556, 589593, 589591, 589588, 589586, 437698, 437690, 589352, 412556, 589553, 589183, 589177, 573712, 573700, 589149, 573696, 589270, 589130, 589128, 587633, 246227, 588794, 587340, 381009, 362855, 412548, 331370, 347344, 331368, 246162, 577824, 246149, 587229, 436703, 436698, 436696, 436694, 587031, 586606, 579503, 563843, 436425, 436307, 436304, 246044, 585560, 585556, 585553, 585540, 389026, 389024, 585531, 579359, 363305, 579357, 579338, 585398, 531324, 622441, 580938, 580934, 436140, 585220, 585216, 221626, 511646, 436100, 436092, 489050, 489048, 436046, 579305, 489045, 436042, 245976, 436027, 245972, 436009, 245968, 436005, 578155, 578153, 489032, 489029, 435982, 435975, 435973, 584966, 309744, 309741, 554721, 554718, 309736, 554716, 309732, 309728, 309724, 309719, 556022, 556019, 581574, 581572, 133199, 435882, 584685, 584677, 578236, 580924, 576915, 584625, 511629, 576912, 551852, 435795, 578456, 576907, 435792, 584306, 584298, 435748, 584296, 435746, 581648, 551851, 346863, 434784, 349581, 349574, 434717, 527769, 349571, 349569, 349564, 577560, 550000, 577545, 577520, 367621, 577541, 577499, 412425, 367611, 577372, 234856, 577367, 420957, 420953, 420950, 420947, 420945, 420939, 420933, 434462, 434455, 577298, 577280, 434389, 434364, 502197, 346849, 481775, 493618, 245470, 571163, 571161, 571159, 571157, 571155, 245452, 493607, 234552, 571154, 576004, 469970, 245364, 551691, 551686, 245352, 245350, 234477, 245319, 245317, 245313, 573208, 575900, 575897, 573194, 573193, 573191, 575876, 575872, 575977, 575868, 575857, 573184, 575786, 573657, 575777, 434106, 575759, 575730, 434079, 412393, 412391, 412389, 245243, 574682, 434018, 571151, 571149, 575364, 571147, 463723, 463713, 463702, 575361, 575339, 575337, 574115, 108867, 453667, 575255, 200407, 564943, 575244, 575242, 560756, 355959, 564941, 573148, 433849, 433846, 433825, 433822, 433816, 574789, 574783, 245107, 234282, 511623, 245096, 574219, 234248, 574216, 573133, 573128, 573123, 573117, 574209, 355957, 574204, 574199, 573111, 245061, 574184, 574182, 573079, 433673, 573067, 517369, 433668, 574174, 573062, 433664, 573055, 573053, 573051, 573044, 433645, 433643, 574156, 574152, 200374, 200370, 433619, 553087, 571306, 553798, 573642, 549994, 573775, 133167, 133161, 573769, 572976, 433518, 573638, 570800, 572965, 572963, 573760, 573636, 572960, 573633, 200354, 573485, 573481, 371908, 573467, 573504, 572942, 481763, 573404, 511614, 481760, 388995, 573310, 573301, 244952, 244946, 433444, 463658, 463642, 463637, 244911, 572665, 233964, 572658, 569110, 569106, 433401, 572404, 142256, 403191, 244869, 244856, 403189, 244828, 244822, 244817, 403187, 244776, 572488, 433342, 433340, 572442, 572439, 433301, 433297, 433292, 433290, 570985, 433288, 570980, 572353, 570976, 463606, 572349, 572322, 572413, 572316, 572312, 573609, 570933, 570931, 573582, 553053, 570565, 244717, 573560, 433019, 544701, 544697, 573549, 517355, 517352, 571383, 571381, 551947, 432923, 244697, 233817, 571294, 571291, 571222, 571141, 233802, 244690, 377183, 377181, 377177, 244665, 377175, 244663, 377172, 419815, 526914, 621676, 309661, 380899, 309658, 570783, 309582, 309573, 233781, 309571, 570642, 570637, 570634, 570632, 233772, 570629, 233767, 570614, 333901, 553652, 553650, 553636, 553621, 333899, 233748, 432736, 570471, 419857, 432734, 621567, 309569, 310018, 621551, 570236, 333897, 432702, 615346, 333894, 541709, 482806, 482804, 570445, 541707, 558809, 466962, 397374, 466960, 474176, 466958, 397371, 474174, 432684, 474171, 569970, 570212, 569886, 569966, 365366, 365364, 365355, 515482, 365353, 569742, 569876, 536970, 432587, 365324, 365322, 536682, 365320, 569541, 569538, 233641, 569731, 321242, 321239, 321237, 569536, 432500, 432496, 432491, 412351, 432480, 537713, 412346, 432476, 567998, 567995, 567883, 567877, 569276, 494756, 567992, 25393, 25391, 560742, 560737, 560732, 569184, 569182, 569160, 569158, 569153, 569175, 569149, 390689, 388957, 388954, 560727, 560725, 569102, 233615, 560714, 336304, 432426, 432420, 385992, 615341, 517336, 615338, 517334, 615333, 517331, 615328, 558761, 558755, 405891, 233588, 360071, 514596, 568410, 514589, 551680, 360064, 233575, 432344, 432340, 432338, 382698, 382696, 565205, 565202, 220398, 82892, 58693, 566782, 566664, 244515, 565185, 566284, 405880, 539493, 405869, 615326, 432183, 432180, 565699, 432160, 566023, 564852, 233526, 412338, 412335, 347324, 412325, 412322, 412318, 565112, 565108, 564745, 565102, 564743, 271494, 565098, 564737, 565037, 381825, 564733, 564935, 381820, 381818, 564729, 554685, 564933, 473688, 564864, 233519, 233517, 564724, 432008, 554669, 360052, 431994, 133100, 564584, 563512, 563351, 492444, 492442, 233492, 233484, 233480, 492438, 233476, 233469, 564448, 233450, 564196, 564094, 564089, 483396, 244482, 563930, 563926, 564020, 564057, 563924, 564015, 563914, 563911, 563897, 475025, 405823, 563489, 563810, 563487, 563749, 561182, 563703, 563699, 431903, 563665, 431895, 233397, 553013, 431847, 309500, 563065, 563048, 563019, 453622, 244439, 233376, 133091, 562566, 562669, 407891, 431684, 431683, 562071, 244395, 332597, 333855, 544054, 431680, 561464, 544052, 367520, 453617, 244377, 23495, 481730, 303513, 431648, 554521, 333840, 431633, 380838, 560695, 560691, 312327, 560680, 431627, 431624, 537697, 431612, 312315, 188842, 560200, 560192, 522645, 560188, 560184, 431574, 233242, 522643, 522641, 431560, 360042, 233236, 548685, 431547, 431542, 494744, 494742, 494738, 559243, 417865, 559511, 559518, 559508, 244360, 559241, 549600, 559238, 431514, 559235, 549596, 549594, 549591, 549589, 549587, 558963, 558960, 431485, 557442, 551569, 233174, 551565, 549578, 551563, 233167, 233164, 233157, 549569, 558532, 558528, 549566, 244324, 549564, 558597, 431402, 431395, 549562, 431390, 412284, 556966, 549558, 244294, 558370, 554506, 554503, 554498, 557717, 552936, 133051, 557822, 431335, 431290, 488253, 557755, 557753, 431285, 233092, 555546, 554484, 554481, 554479, 554477, 554475, 554473, 556819, 556817, 431205, 431194, 404732, 306067, 233022, 233019, 556625, 556497, 556495, 431141, 556491, 556489, 555628, 481718, 423308, 378205, 244246, 556000, 244243, 431080, 431079, 431068, 550180, 431065, 431053, 555624, 555537, 380795, 555072, 554979, 554975, 555451, 481708, 551557, 133028, 551047, 551044, 430959, 555029, 550173, 555024, 9784, 550788, 430948, 430943, 430934, 430931, 430922, 430919, 303456, 547753, 430893, 494736, 494734, 303440, 303425, 544671, 494732, 430851, 232929, 554568, 554562, 494729, 552918, 520097, 520087, 520082, 244221, 520077, 244219, 244217, 520074, 520072, 520066, 520063, 520052, 520036, 520032, 520023, 552692, 520020, 552530, 551850, 551847, 539329, 539327, 303408, 303401, 552258, 552256, 430766, 552254, 552252, 303391, 552248, 303373, 303367, 430748, 552272, 430733, 430726, 244191, 430724, 430721, 430718, 232877, 430714, 232872, 358895, 430693, 358891, 552174, 551846, 390621, 514960, 551838, 514958, 552013, 514938, 514935, 405783, 515458, 551914, 551955, 132990, 360030, 549079, 551834, 551627, 551625, 132984, 551615, 551501, 551496, 309457, 309449, 309442, 390591, 548692, 551132, 550639, 430555, 430538, 430534, 102438, 347297, 102436, 102434, 347288, 522625, 522615, 522610, 522608, 550266, 550061, 232800, 550044, 527623, 321214, 271961, 271956, 232792, 548970, 548964, 481681, 549867, 132974, 549923, 527605, 549864, 547222, 548494, 108753, 548939, 549861, 456278, 430409, 547720, 473603, 473601, 539718, 549187, 539712, 548587, 544667, 548573, 548559, 458387, 458385, 548553, 458383, 244133, 458378, 458370, 539707, 430324, 548181, 405766, 548296, 548178, 132944, 548201, 519959, 519956, 519953, 519951, 547956, 547864, 547860, 544141, 547855, 430235, 547588, 430192, 547698, 430190, 546394, 393058, 542102, 543646, 542099, 547425, 515452, 547418, 547414, 547404, 547257, 481663, 430058, 430056, 381811, 546392, 430050, 546997, 430024, 412165, 536677, 546689, 381803, 312483, 546519, 546390, 546517, 380689, 546387, 411348, 481652, 544872, 411345, 429953, 545906, 544870, 429949, 429942, 546034, 546064, 318376, 544860, 544855, 545895, 256222, 544852, 429937, 312308, 244101, 412138, 417862, 545510, 417856, 244094, 417854, 429917, 285545, 511594, 412125, 544211, 545216, 515411, 429883, 515381, 327239, 515348, 544661, 515344, 515336, 543613, 544656, 544654, 544651, 244057, 244054, 244042, 368272, 542083, 536825, 544048, 514554, 543821, 536823, 514552, 232632, 429704, 429702, 543774, 132928, 543769, 360027, 102428, 267260, 536787, 511030, 429644, 543531, 244015, 542806, 505211, 542444, 429472, 481621, 412094, 481600, 481596, 429380, 429378, 541301, 541298, 481593, 540412, 515279, 132907, 161874, 515274, 515271, 429268, 515263, 515261, 469902, 540394, 540410, 429232, 200024, 278067, 278065, 539433, 539430, 514917, 539647, 539633, 539191, 539188, 489127, 428982, 535732, 537217, 232438, 232433, 249722, 232429, 249718, 536674, 536671, 535672, 536669, 428855, 428826, 356303, 380556, 356294, 521960, 356292, 380554, 527322, 528034, 528020, 528016, 514897, 232329, 428516, 356264, 380519, 471944, 380517, 522972, 522238, 321136, 321132, 419803, 521015, 303326, 428235, 520841, 428221, 411990, 108472, 108470, 243594, 243589, 427811, 108466, 427801, 108462, 380465, 512556, 427787, 108453, 456061, 456059, 515730, 515701, 388853, 404382, 388847, 427720, 515175, 514873, 481551, 514448, 514437, 514324, 514320, 513532, 513088, 513793, 513828, 309313, 362392, 312479, 513227, 513705, 501168, 469832, 513703, 427685, 513700, 511561, 499417, 494716, 494714, 513241, 494708, 511343, 506427, 243528, 512325, 506417, 417841, 506414, 417836, 456055, 456053, 427636, 456049, 456043, 511547, 485413, 456039, 502912, 502910, 511784, 511781, 512319, 417832, 303312, 388179, 511188, 511766, 511764, 321130, 321127, 427583, 427566, 417825, 481528, 427562, 417822, 511546, 511540, 427553, 481518, 427527, 427519, 481510, 511449, 481497, 511320, 511312, 321123, 199729, 321114, 392922, 392920, 392918, 411979, 417821, 232012, 417819, 362384, 427429, 463550, 509887, 509884, 509881, 509875, 509872, 393041, 510464, 393038, 455430, 455426, 385889, 385888, 509868, 509865, 509861, 509858, 509857, 509849, 509845, 509843, 509836, 509818, 509728, 447941, 510009, 615303, 509724, 509721, 509719, 509709, 231962, 493484, 411935, 488023, 411923, 380423, 243316, 58684, 58682, 506684, 505971, 309119, 502906, 231834, 309055, 309053, 231832, 309047, 426875, 321090, 502549, 505607, 426853, 505540, 317168, 426792, 231797, 505268, 505266, 504711, 504694, 321073, 504692, 321068, 504902, 504403, 504837, 231734, 426686, 347945, 504139, 502654, 502643, 504398, 504396, 504394, 347939, 231674, 231657, 426637, 426632, 503916, 426626, 503907, 503903, 380378, 380376, 426597, 503899, 243075, 499893, 231557, 231542, 231533, 371219, 405724, 426538, 108246, 194120, 456236, 426529, 502762, 194116, 194114, 502756, 502615, 378125, 218274, 426485, 502152, 378122, 417814, 417812, 417810, 231513, 417806, 417801, 417798, 401099, 370799, 426446, 243027, 337027, 337025, 388826, 485282, 388823, 485278, 268961, 231464, 496261, 231461, 426437, 499559, 132743, 231449, 108241, 231434, 417795, 231432, 494670, 321048, 500105, 494667, 321043, 337022, 426369, 500102, 417785, 458216, 378118, 426212, 426210, 500096, 500094, 417783, 500008, 108218, 500006, 231350, 231344, 500001, 231329, 499929, 231320, 417781, 400084, 499538, 426177, 474313, 242953, 499527, 494047, 231304, 426122, 426084, 378108, 426079, 378105, 308970, 378100, 308962, 378098, 378095, 498436, 380357, 393828, 468933, 426038, 498425, 426033, 495532, 498467, 498422, 495529, 498417, 498406, 498446, 495522, 495520, 497709, 498099, 498111, 496547, 496545, 231187, 497894, 494437, 489956, 489954, 495620, 497395, 411861, 349662, 411859, 184552, 411855, 411853, 425938, 425929, 496535, 455384, 469772, 494660, 494656, 469765, 492306, 494652, 455382, 492297, 455377, 494650, 423289, 496247, 455371, 423285, 496243, 425904, 495614, 455366, 411846, 493305, 455357, 455351, 455348, 455339, 495604, 425859, 495601, 425854, 425850, 495115, 495505, 217988, 495410, 288816, 495443, 495391, 288812, 495438, 411844, 161865, 288808, 411842, 495337, 479210, 494645, 466825, 495293, 485242, 217968, 494428, 494640, 494637, 199354, 494634, 417769, 417766, 417763, 494630, 265531, 417759, 425798, 493384, 417750, 493367, 493363, 425752, 494342, 318350, 425741, 482124, 482122, 494177, 482116, 482114, 318348, 425723, 132732, 494164, 490905, 318346, 411835, 479203, 411831, 399713, 479200, 479198, 242851, 242849, 417748, 362727, 493871, 108073, 242841, 199320, 303308, 493760, 491951, 493758, 199308, 493743, 303295, 493288, 493282, 485231, 242810, 230997, 242804, 411825, 492825, 388813, 492813, 380347, 492732, 380343, 492725, 492722, 425653, 492498, 492455, 492053, 411805, 404668, 492453, 360003, 425640, 230979, 485212, 321000, 492066, 492050, 492043, 425618, 491924, 199265, 485195, 312300, 199256, 488644, 333634, 488642, 411772, 489843, 489841, 425544, 425540, 489819, 490186, 230870, 490389, 489812, 230836, 375045, 368894, 489805, 368891, 485187, 488734, 458670, 489739, 489733, 488728, 320971, 489488, 320965, 320959, 489356, 485162, 489290, 488870, 488765, 488755, 488865, 488636, 488712, 488709, 108062, 488327, 368886, 488121, 482570, 487881, 108032, 482506, 242602, 425277, 425264, 242537, 242533, 242530, 483266, 242503, 388787, 230611, 484036, 484034, 483239, 471099, 482474, 411738, 242408, 481420, 132648, 481412, 388766, 480953, 480951, 242364, 480657, 320896, 320894, 475146, 475142, 365213, 462552, 359987, 479648, 480655, 480489, 230519, 368162, 480484, 480406, 368160, 217453, 476318, 476314, 480356, 480353, 424972, 424959, 368155, 368153, 424957, 424955, 460805, 424946, 424944, 471921, 477186, 480135, 424937, 480152, 230477, 480150, 230475, 480111, 417741, 480055, 480050, 480043, 417739, 480008, 479180, 411718, 424880, 424878, 476746, 479238, 242305, 365206, 365205, 411712, 365203, 365201, 478926, 478923, 479146, 479089, 479086, 479084, 478963, 478959, 479117, 478921, 479020, 305698, 417738, 478157, 477181, 478321, 476682, 478318, 478316, 478894, 478406, 424861, 424859, 424856, 107958, 388148, 107955, 478258, 478140, 230378, 230374, 424845, 230362, 424827, 424823, 424821, 230354, 107950, 477049, 477172, 453416, 458788, 411708, 477091, 132635, 472882, 476650, 462732, 476482, 476271, 474344, 424717, 107868, 476323, 476307, 198919, 470172, 242177, 312290, 464346, 462703, 230228, 474395, 474790, 474836, 474766, 406431, 474387, 474264, 359983, 417736, 471873, 406404, 376141, 474259, 406401, 473683, 473680, 406391, 473815, 424630, 451829, 359958, 473700, 472703, 265513, 473228, 359951, 453408, 423665, 472962, 472751, 411698, 472802, 472799, 472782, 472780, 472699, 472695, 472693, 349091, 132557, 330184, 470664, 132544, 161840, 471812, 471679, 198819, 471054, 471675, 472102, 471438, 471050, 470800, 470786, 466144, 470496, 470494, 470346, 470344, 242038, 242034, 615299, 424439, 468753, 417722, 454886, 468235, 107824, 468208, 468204, 424422, 468191, 468285, 424419, 462681, 424417, 424397, 107819, 241890, 107816, 455097, 230003, 467841, 448381, 241840, 424355, 424350, 467313, 411686, 424269, 466532, 320784, 132483, 180946, 180941, 424226, 229930, 424221, 465938, 406374, 406367, 461268, 461265, 462666, 462663, 462660, 465546, 465633, 465618, 388133, 406352, 375042, 424194, 463423, 463421, 463414, 424176, 229897, 424173, 465044, 424170, 241728, 464326, 464324, 464319, 464317, 464313, 333595, 241707, 241699, 241686, 464226, 367128, 107733, 107721, 107715, 615295, 107708, 241682, 107704, 107701, 458211, 229881, 229874, 320723, 132446, 320719, 241646, 241641, 241615, 461603, 461600, 161835, 365187, 461854, 461850, 461844, 461837, 423267, 461695, 461549, 461542, 461529, 461483, 461416, 107663, 241607, 460919, 460210, 461114, 417714, 460244, 458069, 336238, 423254, 460575, 423252, 423249, 460240, 459834, 460204, 132386, 460236, 241521, 374972, 459675, 229736, 241516, 423911, 229728, 459156, 336232, 132354, 423894, 308805, 241488, 458321, 458317, 458312, 333584, 458109, 458058, 418055, 454636, 349477, 457166, 359947, 241452, 457029, 241433, 241431, 315710, 451261, 347902, 241414, 397067, 8853, 397064, 8850, 8848, 456801, 456774, 451255, 229704, 456399, 132287, 326500, 423848, 454627, 407715, 388725, 107583, 452228, 453047, 241273, 241268, 411434, 359935, 241258, 229523, 229513, 452135, 393036, 393034, 216440, 241219, 451417, 414784, 371025, 198105, 335134, 107491, 417711, 417710, 450157, 388341, 417706, 450481, 450474, 320590, 450226, 449747, 229419, 450007, 448497, 450005, 450003, 388101, 388091, 449980, 449890, 333565, 449776, 229395, 359917, 359914, 354743, 359910, 448778, 448323, 411631, 359906, 448283, 448274, 447932, 240982, 107432, 421307, 421126, 423177, 423379, 421116, 421111, 320569, 413264, 422652, 422034, 357985, 422750, 229157, 421291, 421636, 421422, 419679, 240870, 240855, 418084, 410758, 420174, 418082, 349291, 419958, 407147, 419955, 419949, 419945, 417705, 411607, 411606, 419688, 229050, 107328, 417704, 417548, 418843, 418667, 418835, 418663, 418674, 318303, 418595, 417698, 417693, 412991, 418007, 132166, 107292, 418005, 229020, 417689, 417996, 415354, 417991, 417986, 312286, 417684, 417681, 417637, 375709, 415893, 414649, 415891, 320495, 417123, 415886, 416924, 228982, 359895, 228978, 320491, 416889, 359893, 228973, 359886, 400931, 416949, 416880, 400929, 416947, 228958, 416913, 228954, 240680, 240676, 228945, 416732, 240666, 240663, 416724, 305692, 240633, 404268, 411569, 415881, 228922, 415878, 378089, 415874, 416161, 416036, 415871, 416159, 615287, 411550, 415868, 228881, 615281, 415729, 615279, 240584, 132139, 240572, 414678, 414670, 197792, 413679, 405304, 368068, 413719, 413675, 411341, 411339, 414432, 240537, 413982, 132107, 240521, 107240, 367087, 397808, 397059, 413246, 411250, 413242, 228845, 240510, 228843, 412901, 413221, 240501, 413278, 413213, 240498, 228820, 411240, 411231, 413150, 411228, 413147, 413135, 240482, 411226, 411217, 411215, 412828, 411211, 321678, 412664, 412826, 412716, 412658, 107181, 412708, 411206, 412789, 411427, 412632, 412613, 412611, 411203, 228775, 312280, 312268, 132100, 228762, 240440, 228749, 320459, 320457, 132075, 285492, 362279, 228696, 405237, 409119, 409375, 406302, 409367, 406296, 409355, 409352, 240299, 409344, 393768, 409110, 393765, 393762, 197660, 373589, 406279, 228579, 228573, 228526, 240249, 408815, 228504, 228499, 240198, 408606, 240192, 408604, 390748, 240174, 228493, 408393, 228490, 407885, 402086, 240150, 240146, 407880, 407876, 407911, 197616, 228472, 215706, 228468, 407905, 228460, 407866, 407840, 333502, 407899, 228430, 228429, 368061, 228420, 107120, 407495, 407585, 407571, 240095, 197582, 407566, 359871, 228394, 390746, 407410, 392916, 240091, 240082, 357397, 240074, 310333, 406275, 240069, 404654, 240066, 240061, 406271, 406268, 406266, 240042, 404652, 228368, 406264, 401910, 348855, 240027, 406996, 379289, 397785, 239996, 406241, 107052, 239972, 398807, 239965, 406238, 393452, 373584, 393450, 393449, 392914, 400032, 161822, 161819, 405663, 382104, 382102, 405159, 399699, 405152, 405148, 399694, 404962, 405142, 171759, 405386, 402546, 404837, 404834, 404950, 404947, 404943, 174255, 106998, 404898, 404638, 404636, 228221, 106995, 392910, 404633, 106990, 404162, 402215, 404160, 392903, 402573, 402570, 402568, 378701, 378699, 404034, 404053, 171723, 171721, 404029, 403630, 394520, 106972, 398984, 381756, 382496, 402392, 382494, 106943, 403154, 106925, 397157, 403110, 403104, 381747, 400796, 378681, 378679, 383547, 402373, 377566, 402315, 392890, 399671, 400138, 399665, 399663, 399660, 106834, 392888, 399647, 398616, 399473, 397141, 106805, 399097, 396833, 399044, 239537, 349463, 359863, 228010, 398789, 106791, 359860, 379807, 393436, 398560, 393426, 320407, 398507, 320384, 106775, 227949, 197231, 239469, 239466, 239463, 397682, 398203, 315676, 315673, 395501, 395869, 395494, 396828, 395864, 395862, 239407, 239396, 395471, 395461, 106656, 395451, 395445, 395441, 106633, 239343, 355154, 394768, 394479, 394867, 394839, 394745, 394581, 239300, 227745, 355137, 239288, 394615, 394613, 394608, 394499, 394494, 393896, 392447, 355115, 393886, 393727, 372601, 384143, 161790, 315669, 393096, 393092, 392879, 392875, 392871, 239216, 392603, 227680, 227678, 227676, 315662, 392591, 239205, 392269, 392550, 392561, 239171, 239169, 391661, 390895, 391641, 239153, 239148, 391638, 383788, 392060, 239145, 106601, 389813, 391633, 391627, 390879, 391623, 389409, 214992, 227643, 391322, 389651, 391320, 390863, 239057, 390860, 390855, 214977, 390290, 320353, 390287, 320350, 227591, 390707, 387206, 390003, 387974, 385507, 106537, 389975, 106530, 389805, 389840, 383777, 386116, 389325, 387577, 388500, 389074, 387575, 388576, 308732, 375752, 387462, 388573, 388571, 387763, 388324, 388550, 388478, 278027, 386987, 214892, 388428, 358350, 387108, 387105, 387596, 387593, 387564, 387562, 356566, 387492, 387452, 387310, 214854, 387306, 385648, 161770, 161766, 385229, 386402, 386399, 227527, 335130, 335128, 387345, 387153, 183071, 214844, 385227, 359226, 214833, 387142, 383724, 294226, 386918, 308706, 227495, 161756, 183069, 386449, 183066, 183064, 183063, 106481, 183060, 386422, 183056, 183054, 238787, 382471, 386253, 386251, 238780, 238771, 238768, 238762, 386299, 386245, 335126, 386241, 348404, 383713, 238738, 386113, 386110, 238727, 386107, 348298, 385685, 385611, 385127, 385608, 385682, 354418, 385477, 355109, 385118, 319237, 385421, 227397, 376089, 384923, 358526, 376087, 383699, 227395, 385373, 214719, 385293, 385276, 106461, 385146, 385205, 385202, 365160, 385200, 385272, 382632, 238684, 385142, 384953, 382208, 238654, 227373, 383530, 384657, 106416, 384630, 384783, 335123, 335121, 384627, 382812, 381283, 303263, 384709, 309973, 309966, 384625, 214650, 320289, 308695, 214636, 238602, 366973, 214606, 303257, 384311, 383952, 252736, 383686, 349451, 383949, 227337, 238582, 303250, 303248, 366955, 227332, 384303, 383663, 384297, 274559, 369636, 384292, 381659, 274557, 383658, 383945, 383943, 383937, 384022, 214569, 383934, 214567, 214560, 214557, 106367, 214555, 359087, 383921, 359080, 383886, 214553, 274552, 274548, 303241, 374497, 365138, 382857, 383512, 383106, 383412, 383202, 382855, 348969, 161740, 383192, 383189, 382852, 161738, 303228, 320276, 383009, 382720, 382686, 374486, 383007, 383095, 382684, 303226, 383005, 382980, 379794, 320274, 382937, 382680, 382714, 382935, 308681, 382651, 362761, 383056, 382933, 362758, 383086, 379865, 378082, 379792, 382994, 382927, 382712, 161732, 382710, 308675, 382196, 382575, 106364, 382842, 382187, 382745, 382668, 106359, 106355, 381266, 106352, 382488, 382663, 378079, 378077, 227280, 372471, 382465, 377431, 377427, 382357, 19796, 238511, 382355, 65522, 382227, 346317, 382096, 376017, 376069, 375745, 252731, 370431, 379365, 330846, 375739, 616405, 375737, 227239, 364404, 381702, 227228, 330839, 376054, 381718, 320256, 227216, 381715, 381338, 381636, 381488, 371155, 381277, 379140, 381274, 381271, 379846, 364401, 375735, 379241, 238455, 379684, 379742, 362618, 379483, 308655, 379034, 379031, 379029, 362845, 379027, 379468, 379399, 379197, 379352, 378490, 379350, 379384, 379382, 379086, 378057, 378643, 106333, 379005, 378849, 377882, 376945, 350017, 377626, 369359, 375890, 306799, 377607, 378188, 378217, 378040, 364397, 305680, 363515, 363513, 377494, 274536, 180909, 377643, 377594, 377641, 377418, 377591, 376693, 376931, 376929, 106299, 377104, 376927, 377414, 377382, 375733, 376922, 377039, 377277, 377037, 205305, 377267, 359838, 106275, 374479, 374964, 131830, 375727, 131827, 274523, 227030, 376906, 274521, 106264, 106261, 106259, 359835, 363555, 359831, 376870, 238273, 376844, 359828, 375874, 359825, 238250, 359823, 238248, 227023, 238244, 238229, 376627, 376667, 359819, 376500, 226993, 376640, 372928, 376476, 374961, 238209, 374319, 376466, 196656, 376001, 376491, 375996, 327214, 369343, 374316, 327212, 374313, 214292, 214290, 376026, 375101, 299831, 327044, 373907, 375799, 374958, 374307, 375581, 375579, 214263, 335119, 335117, 374954, 330827, 330824, 330821, 362117, 375025, 335115, 375569, 106208, 106205, 375091, 306777, 373706, 373704, 306773, 335112, 373702, 346252, 346247, 372140, 335110, 308615, 335108, 278008, 214199, 106186, 375084, 372137, 335106, 335103, 374937, 106181, 214149, 106176, 372134, 375074, 305671, 374691, 375020, 274515, 274513, 372131, 374846, 374843, 373697, 374840, 373693, 327025, 374458, 106168, 373690, 106166, 106164, 373349, 374519, 374565, 278000, 335098, 374533, 318473, 374560, 374558, 374530, 374427, 373684, 374415, 374405, 372129, 373797, 372214, 373679, 306760, 372122, 226932, 335095, 374198, 355291, 226930, 373869, 372208, 374194, 374275, 226928, 226927, 371249, 373778, 226924, 373856, 226922, 214107, 374188, 374172, 306750, 372989, 373817, 365760, 373466, 274511, 274509, 373058, 373666, 373682, 373663, 373661, 373605, 373621, 373367, 371334, 65510, 373418, 373359, 371332, 371329, 372730, 65504, 371327, 371325, 106155, 106153, 373281, 370417, 372887, 373275, 362076, 373034, 106126, 372816, 106124, 368021, 373103, 372814, 372683, 370210, 327197, 362072, 362056, 372590, 327165, 372789, 372783, 372778, 372673, 372806, 372776, 372518, 213938, 367869, 372176, 372170, 213908, 277997, 213892, 371407, 372100, 366112, 372160, 277985, 106084, 347847, 371089, 371095, 362019, 347839, 370933, 106052, 366877, 370024, 370022, 370019, 368637, 370155, 369540, 359804, 369893, 213721, 369620, 369605, 213712, 370061, 362587, 370058, 369891, 226618, 345544, 369935, 369533, 180886, 370006, 369600, 367866, 369598, 360724, 369590, 140307, 369655, 361292, 364392, 362013, 345542, 369586, 368634, 362009, 368628, 362007, 367864, 180869, 369481, 367764, 303219, 303217, 369363, 310324, 368483, 310322, 310320, 213673, 329510, 237974, 366655, 368660, 368793, 368565, 140303, 368558, 368556, 368516, 140301, 237958, 362536, 140298, 362533, 362530, 362527, 366801, 180828, 367849, 367846, 367845, 367844, 367843, 366848, 349447, 363505, 367803, 367757, 366776, 367753, 367750, 366792, 366758, 366756, 366785, 366754, 366618, 366783, 366781, 366749, 366615, 366613, 226552, 354856, 366649, 365517, 366598, 365514, 364390, 356985, 106019, 356982, 366576, 364387, 364384, 366386, 364382, 366466, 364380, 261244, 330799, 366362, 106016, 366359, 366383, 106014, 261242, 357751, 365381, 365669, 365667, 366349, 366264, 261230, 106009, 364680, 365109, 363954, 366261, 357539, 105995, 357537, 65464, 237880, 331279, 296252, 364373, 226511, 237859, 365093, 331276, 365836, 365091, 365652, 365810, 237830, 226495, 365647, 105955, 360721, 226485, 226481, 361995, 361993, 303211, 359797, 303209, 303205, 364925, 353963, 350565, 363347, 364669, 364716, 364709, 363345, 364664, 346839, 44898, 44895, 364230, 364505, 364460, 364456, 364434, 44889, 364411, 303190, 303188, 359783, 364407, 364226, 303181, 361279, 363300, 303169, 353395, 363298, 361552, 333375, 333370, 361268, 363295, 363340, 343273, 59854, 361254, 59852, 363852, 346824, 352805, 346817, 363660, 363644, 363291, 363426, 226352, 36030, 226346, 363288, 363287, 363334, 360592, 363283, 349443, 363119, 105894, 359770, 362932, 277446, 346813, 180779, 341388, 362834, 361240, 362565, 361235, 357039, 361083, 361969, 362643, 361962, 361956, 361231, 361953, 362554, 256205, 361942, 256203, 361940, 226268, 358589, 362551, 256200, 256198, 256196, 361837, 361919, 105872, 361835, 361912, 353870, 353868, 361910, 360659, 105869, 361833, 359760, 353865, 361831, 105858, 361692, 105845, 361346, 131798, 361343, 350326, 361340, 131796, 361689, 131792, 131790, 361736, 180751, 360938, 360935, 361076, 360933, 361074, 360378, 361536, 361534, 105820, 155139, 361198, 347824, 360931, 105817, 105815, 67270, 360929, 155136, 344251, 361358, 361184, 360828, 361174, 344247, 344245, 303131, 303109, 343437, 347816, 347811, 359207, 359204, 183048, 358198, 359199, 347805, 355278, 303090, 359725, 359720, 44879, 347802, 347800, 327157, 342719, 359706, 357768, 357581, 359697, 359695, 357579, 359693, 303087, 303084, 226015, 303076, 56795, 358193, 358188, 358185, 359026, 354717, 359020, 358787, 354714, 358780, 358778, 358948, 358183, 358463, 336011, 357737, 354845, 358460, 357086, 352444, 358433, 358430, 155132, 357431, 354707, 357161, 356752, 327151, 327148, 356232, 352664, 356134, 356132, 356126, 352778, 196232, 225682, 353830, 355201, 354616, 354823, 354818, 355198, 350078, 343633, 355193, 355190, 346786, 346784, 346782, 353545, 310310, 346780, 348831, 354690, 348822, 353912, 354674, 348820, 354620, 353535, 348808, 305665, 305663, 59842, 354552, 59840, 353751, 352648, 315202, 353961, 353717, 349285, 343294, 333257, 310117, 303073, 353289, 310301, 352436, 310296, 352757, 352434, 352431, 347495, 310290, 352428, 353224, 310275, 352755, 338787, 306019, 352558, 306016, 338785, 352033, 351942, 350884, 352422, 351933, 351688, 351680, 349330, 349319, 350511, 350872, 351096, 350869, 351066, 350675, 351063, 351579, 350723, 351549, 351541, 350128, 350715, 350053, 347159, 350124, 303056, 350122, 334287, 351366, 349864, 205280, 349859, 349855, 350919, 348589, 303042, 295966, 348586, 351059, 333246, 350265, 351055, 350845, 277426, 346007, 350660, 327140, 350655, 327138, 321658, 327130, 350024, 347655, 343291, 347676, 350007, 349438, 349650, 347670, 347570, 155128, 310248, 349273, 331237, 335235, 310246, 299639, 161713, 310244, 348601, 347143, 348528, 348471, 348461, 343422, 348454, 345757, 273853, 273851, 346565, 338768, 346563, 345089, 277400, 346561, 345084, 277398, 299631, 345082, 348040, 338763, 277395, 338761, 346559, 345498, 343412, 343396, 155123, 344209, 333199, 346746, 273845, 346744, 344203, 273843, 346551, 345833, 314992, 319224, 345535, 345424, 344606, 344601, 344597, 343558, 343556, 343581, 343265, 339570, 339568, 343001, 342996, 342991, 310168, 342299, 339558, 342470, 342056, 340482, 256154, 256152, 331704, 331701, 338717, 341911, 338701, 341798, 341789, 341787, 339556, 341775, 341773, 262895, 339554, 341204, 341200, 341197, 341193, 341548, 341191, 23311, 341361, 341417, 341413, 341355, 279079, 23306, 273825, 340654, 327128, 333161, 340132, 340130, 340734, 340730, 337893, 273810, 273808, 273807, 340474, 161703, 161701, 340536, 336183, 102425, 336181, 161699, 338234, 336173, 340462, 336170, 339114, 336168, 339227, 340460, 340448, 340014, 340280, 340169, 339110, 340270, 279072, 340041, 340039, 340037, 340076, 337393, 340073, 339988, 338741, 339985, 339920, 339983, 339980, 339918, 340005, 338657, 336151, 336148, 339932, 339905, 338837, 338833, 336131, 339468, 339538, 339250, 277380, 336127, 339202, 338511, 338690, 338880, 337828, 338732, 337888, 331679, 315630, 337876, 336121, 336118, 337520, 337510, 336099, 161695, 335762, 335088, 335488, 335093, 277322, 334077, 315613, 315601, 334139, 334134, 305400, 332966, 332963, 332962, 332959, 327285, 332489, 332439, 332429, 328803, 330612, 331933, 194112, 327901, 331909, 194109, 194107, 331193, 329544, 330560, 330602, 328800, 330556, 329521, 327102, 328014, 328839, 328632, 327454, 327453, 327449, 327442, 328122, 328116, 328114, 328128, 327882, 328069, 327578, 319007, 327257, 327096, 324400, 325462, 202625, 202623, 326555, 312010, 321834, 325589, 321267, 325587, 305619, 305615, 319206, 319134, 318806, 317476, 311992, 318625, 318463, 318460, 260876, 260874, 260871, 311983, 318150, 318204, 316317, 316315, 318390, 318200, 318199, 316313, 318136, 317588, 312703, 317380, 317471, 18755, 312048, 317095, 317093, 316119, 316107, 316101, 314103, 314094, 314091, 307711, 313630, 313620, 312579, 312853, 313371, 313362, 312046, 312559, 312845, 312842, 312044, 312248, 312244, 312240, 311916, 312237, 189605, 311962, 307692, 305467, 307343, 306815, 305575, 305809, 300951, 302373, 261105, 303502, 303498, 160791, 302365, 302200, 301842, 302198, 160783, 302195, 302191, 301834, 301680, 301830, 300767, 297199, 297173, 297150, 297147, 295752, 294723, 183027, 278121, 277915, 273772, 272935, 270175, 270173, 271456, 270890, 270170, 270167, 270377, 269404, 269399, 615265, 615262, 615261, 615254, 615252, 267119, 262242, 263747, 263744, 182923, 260490, 258927, 128844, 249383, 249381, 249624, 184609, 249614, 615242, 249375, 222801, 122568, 257544, 257542, 257453, 255941, 222207, 255896, 255329, 130857, 255209, 250936, 248013, 250033, 250031, 248241, 248199, 249336, 249334, 249181, 615237, 248757, 193334, 248753, 248690, 248687, 193578, 193575, 615157, 194215, 195160, 193315, 195097, 195073, 193312, 615151, 185140, 189493, 182904, 185884, 182898, 182895, 182891, 182883, 175676, 185415, 184471, 184454, 184394, 184379, 183253, 182789, 174457, 173433, 172260, 122473, 171541, 170113, 169417, 140668, 168337, 163531, 122393, 140661, 158780, 156817, 137887, 137877, 167233, 167217, 167215, 158953, 165810, 165572, 164991, 162549, 162547, 162542, 162395, 162215, 155984, 159530, 159528, 159523, 159503, 159100, 159093, 159091, 159089, 159084, 152396, 158212, 152394, 158073, 157736, 137874, 137872, 155031, 155029, 155981, 154466, 154625, 153027, 153210, 153022, 153135, 153019, 137870, 137865, 137852, 143487, 151503, 152051, 152049, 152047, 151372, 151606, 151273, 150149, 148325, 148321, 148320, 148307, 148305, 147712, 82160, 143485, 143001, 122278, 146710, 146885, 146706, 146698, 146249, 144924, 143474, 143471, 142214, 144729, 145048, 144724, 144722, 144720, 144716, 144910, 144766, 143464, 139775, 140571, 142985, 140569, 142970, 141701, 141699, 140071, 122914, 122907, 138416, 135852, 135850, 135742, 130280, 118534, 124051, 118528, 122830, 122817, 121411, 119035, 116452, 118986, 114217, 118434, 118510, 118459, 118407, 118457, 118153, 116547, 116543, 117116, 115954, 115947, 115944, 115937, 102411, 102409, 102407, 82152, 82877, 82875, 85958, 91710, 82140, 82137, 77049, 57035))
Run Time: 0.239898
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4423 | |
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 | | | | | 4423 | |
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 (31122, 30717, 30199, 29980, 29796, 29441, 28810, 28438, 28402, 26222, 25132, 21470, 32153, 19765, 19199, 18547, 18390, 17713, 17180, 16860, 16507, 16349, 15715, 13534, 12872, 12860, 11824, 10705, 10365, 9463, 7172))
Run Time: 0.004130
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 31 | 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 (635113, 635108, 636703, 636487, 247253, 636056, 636647, 636550, 636475, 636453, 636473, 636440, 446646, 446644, 446642, 446638, 636232, 446628, 636322, 446625, 446620, 636318, 446617, 446594, 446592, 446590, 446588, 446582, 446580, 446573, 446570, 446568, 446556, 446554, 446552, 446548, 417918, 594640, 635087, 635199, 634925, 446315, 633890, 633888, 446225, 446163, 571168, 633211, 633364, 633207, 633203, 633294, 633362, 633201, 633199, 633194, 633191, 633188, 446131, 571165, 446117, 633039, 633037, 632175, 632244, 446079, 446076, 446074, 632902, 446070, 599031, 599026, 599023, 599018, 592686, 601618, 600505, 599009, 599007, 599005, 599976, 593131, 599974, 593129, 593126, 593123, 593113, 599921, 599936, 599931, 586595, 599002, 598990, 598989, 598987, 598983, 598969, 598967, 598965, 598963, 392949, 599155, 598437, 133299, 598311, 597685, 594626, 595313, 595050, 475414, 595048, 595129, 595119, 595114, 594245, 595041, 594762, 593867, 593864, 593860, 594361, 594169, 594359, 594345, 594230, 594228, 593677, 593589, 593548, 593538, 590726, 590722, 593376, 593371, 593364, 593262, 593232, 590713, 591606, 593003, 578591, 592934, 592891, 592774, 592767, 592628, 378167, 592203, 592040, 592002, 592030, 591998, 591996, 591992, 591806, 591803, 591800, 591796, 527949, 527940, 527925, 527914, 493336, 517435, 527860, 527857, 527849, 493331, 527840, 527838, 527835, 591264, 381038, 381035, 517420, 591316, 381033, 591313, 591310, 591308, 591306, 517411, 517409, 517407, 539544, 517403, 591103, 591096, 591089, 580968, 586088, 586086, 586084, 590292, 588804, 438480, 438459, 438450, 580029, 133237, 387865, 387863, 387858, 387855, 109154, 438207, 109152, 438203, 438199, 438196, 438026, 590111, 437890, 589832, 589562, 589821, 589816, 589560, 589601, 589556, 589593, 589591, 589588, 589586, 437698, 437690, 589352, 412556, 589553, 589183, 589177, 573712, 573700, 589149, 573696, 589270, 589130, 589128, 587633, 246227, 588794, 587340, 381009, 362855, 412548, 331370, 347344, 331368, 246162, 577824, 246149, 587229, 436703, 436698, 436696, 436694, 587031, 586606, 579503, 563843, 436425, 436307, 436304, 246044, 585560, 585556, 585553, 585540, 389026, 389024, 585531, 579359, 363305, 579357, 579338, 585398, 531324, 622441, 580938, 580934, 436140, 585220, 585216, 221626, 511646, 436100, 436092, 489050, 489048, 436046, 579305, 489045, 436042, 245976, 436027, 245972, 436009, 245968, 436005, 578155, 578153, 489032, 489029, 435982, 435975, 435973, 584966, 309744, 309741, 554721, 554718, 309736, 554716, 309732, 309728, 309724, 309719, 556022, 556019, 581574, 581572, 133199, 435882, 584685, 584677, 578236, 580924, 576915, 584625, 511629, 576912, 551852, 435795, 578456, 576907, 435792, 584306, 584298, 435748, 584296, 435746, 581648, 551851, 346863, 434784, 349581, 349574, 434717, 527769, 349571, 349569, 349564, 577560, 550000, 577545, 577520, 367621, 577541, 577499, 412425, 367611, 577372, 234856, 577367, 420957, 420953, 420950, 420947, 420945, 420939, 420933, 434462, 434455, 577298, 577280, 434389, 434364, 502197, 346849, 481775, 493618, 245470, 571163, 571161, 571159, 571157, 571155, 245452, 493607, 234552, 571154, 576004, 469970, 245364, 551691, 551686, 245352, 245350, 234477, 245319, 245317, 245313, 573208, 575900, 575897, 573194, 573193, 573191, 575876, 575872, 575977, 575868, 575857, 573184, 575786, 573657, 575777, 434106, 575759, 575730, 434079, 412393, 412391, 412389, 245243, 574682, 434018, 571151, 571149, 575364, 571147, 463723, 463713, 463702, 575361, 575339, 575337, 574115, 108867, 453667, 575255, 200407, 564943, 575244, 575242, 560756, 355959, 564941, 573148, 433849, 433846, 433825, 433822, 433816, 574789, 574783, 245107, 234282, 511623, 245096, 574219, 234248, 574216, 573133, 573128, 573123, 573117, 574209, 355957, 574204, 574199, 573111, 245061, 574184, 574182, 573079, 433673, 573067, 517369, 433668, 574174, 573062, 433664, 573055, 573053, 573051, 573044, 433645, 433643, 574156, 574152, 200374, 200370, 433619, 553087, 571306, 553798, 573642, 549994, 573775, 133167, 133161, 573769, 572976, 433518, 573638, 570800, 572965, 572963, 573760, 573636, 572960, 573633, 200354, 573485, 573481, 371908, 573467, 573504, 572942, 481763, 573404, 511614, 481760, 388995, 573310, 573301, 244952, 244946, 433444, 463658, 463642, 463637, 244911, 572665, 233964, 572658, 569110, 569106, 433401, 572404, 142256, 403191, 244869, 244856, 403189, 244828, 244822, 244817, 403187, 244776, 572488, 433342, 433340, 572442, 572439, 433301, 433297, 433292, 433290, 570985, 433288, 570980, 572353, 570976, 463606, 572349, 572322, 572413, 572316, 572312, 573609, 570933, 570931, 573582, 553053, 570565, 244717, 573560, 433019, 544701, 544697, 573549, 517355, 517352, 571383, 571381, 551947, 432923, 244697, 233817, 571294, 571291, 571222, 571141, 233802, 244690, 377183, 377181, 377177, 244665, 377175, 244663, 377172, 419815, 526914, 621676, 309661, 380899, 309658, 570783, 309582, 309573, 233781, 309571, 570642, 570637, 570634, 570632, 233772, 570629, 233767, 570614, 333901, 553652, 553650, 553636, 553621, 333899, 233748, 432736, 570471, 419857, 432734, 621567, 309569, 310018, 621551, 570236, 333897, 432702, 615346, 333894, 541709, 482806, 482804, 570445, 541707, 558809, 466962, 397374, 466960, 474176, 466958, 397371, 474174, 432684, 474171, 569970, 570212, 569886, 569966, 365366, 365364, 365355, 515482, 365353, 569742, 569876, 536970, 432587, 365324, 365322, 536682, 365320, 569541, 569538, 233641, 569731, 321242, 321239, 321237, 569536, 432500, 432496, 432491, 412351, 432480, 537713, 412346, 432476, 567998, 567995, 567883, 567877, 569276, 494756, 567992, 25393, 25391, 560742, 560737, 560732, 569184, 569182, 569160, 569158, 569153, 569175, 569149, 390689, 388957, 388954, 560727, 560725, 569102, 233615, 560714, 336304, 432426, 432420, 385992, 615341, 517336, 615338, 517334, 615333, 517331, 615328, 558761, 558755, 405891, 233588, 360071, 514596, 568410, 514589, 551680, 360064, 233575, 432344, 432340, 432338, 382698, 382696, 565205, 565202, 220398, 82892, 58693, 566782, 566664, 244515, 565185, 566284, 405880, 539493, 405869, 615326, 432183, 432180, 565699, 432160, 566023, 564852, 233526, 412338, 412335, 347324, 412325, 412322, 412318, 565112, 565108, 564745, 565102, 564743, 271494, 565098, 564737, 565037, 381825, 564733, 564935, 381820, 381818, 564729, 554685, 564933, 473688, 564864, 233519, 233517, 564724, 432008, 554669, 360052, 431994, 133100, 564584, 563512, 563351, 492444, 492442, 233492, 233484, 233480, 492438, 233476, 233469, 564448, 233450, 564196, 564094, 564089, 483396, 244482, 563930, 563926, 564020, 564057, 563924, 564015, 563914, 563911, 563897, 475025, 405823, 563489, 563810, 563487, 563749, 561182, 563703, 563699, 431903, 563665, 431895, 233397, 553013, 431847, 309500, 563065, 563048, 563019, 453622, 244439, 233376, 133091, 562566, 562669, 407891, 431684, 431683, 562071, 244395, 332597, 333855, 544054, 431680, 561464, 544052, 367520, 453617, 244377, 23495, 481730, 303513, 431648, 554521, 333840, 431633, 380838, 560695, 560691, 312327, 560680, 431627, 431624, 537697, 431612, 312315, 188842, 560200, 560192, 522645, 560188, 560184, 431574, 233242, 522643, 522641, 431560, 360042, 233236, 548685, 431547, 431542, 494744, 494742, 494738, 559243, 417865, 559511, 559518, 559508, 244360, 559241, 549600, 559238, 431514, 559235, 549596, 549594, 549591, 549589, 549587, 558963, 558960, 431485, 557442, 551569, 233174, 551565, 549578, 551563, 233167, 233164, 233157, 549569, 558532, 558528, 549566, 244324, 549564, 558597, 431402, 431395, 549562, 431390, 412284, 556966, 549558, 244294, 558370, 554506, 554503, 554498, 557717, 552936, 133051, 557822, 431335, 431290, 488253, 557755, 557753, 431285, 233092, 555546, 554484, 554481, 554479, 554477, 554475, 554473, 556819, 556817, 431205, 431194, 404732, 306067, 233022, 233019, 556625, 556497, 556495, 431141, 556491, 556489, 555628, 481718, 423308, 378205, 244246, 556000, 244243, 431080, 431079, 431068, 550180, 431065, 431053, 555624, 555537, 380795, 555072, 554979, 554975, 555451, 481708, 551557, 133028, 551047, 551044, 430959, 555029, 550173, 555024, 9784, 550788, 430948, 430943, 430934, 430931, 430922, 430919, 303456, 547753, 430893, 494736, 494734, 303440, 303425, 544671, 494732, 430851, 232929, 554568, 554562, 494729, 552918, 520097, 520087, 520082, 244221, 520077, 244219, 244217, 520074, 520072, 520066, 520063, 520052, 520036, 520032, 520023, 552692, 520020, 552530, 551850, 551847, 539329, 539327, 303408, 303401, 552258, 552256, 430766, 552254, 552252, 303391, 552248, 303373, 303367, 430748, 552272, 430733, 430726, 244191, 430724, 430721, 430718, 232877, 430714, 232872, 358895, 430693, 358891, 552174, 551846, 390621, 514960, 551838, 514958, 552013, 514938, 514935, 405783, 515458, 551914, 551955, 132990, 360030, 549079, 551834, 551627, 551625, 132984, 551615, 551501, 551496, 309457, 309449, 309442, 390591, 548692, 551132, 550639, 430555, 430538, 430534, 102438, 347297, 102436, 102434, 347288, 522625, 522615, 522610, 522608, 550266, 550061, 232800, 550044, 527623, 321214, 271961, 271956, 232792, 548970, 548964, 481681, 549867, 132974, 549923, 527605, 549864, 547222, 548494, 108753, 548939, 549861, 456278, 430409, 547720, 473603, 473601, 539718, 549187, 539712, 548587, 544667, 548573, 548559, 458387, 458385, 548553, 458383, 244133, 458378, 458370, 539707, 430324, 548181, 405766, 548296, 548178, 132944, 548201, 519959, 519956, 519953, 519951, 547956, 547864, 547860, 544141, 547855, 430235, 547588, 430192, 547698, 430190, 546394, 393058, 542102, 543646, 542099, 547425, 515452, 547418, 547414, 547404, 547257, 481663, 430058, 430056, 381811, 546392, 430050, 546997, 430024, 412165, 536677, 546689, 381803, 312483, 546519, 546390, 546517, 380689, 546387, 411348, 481652, 544872, 411345, 429953, 545906, 544870, 429949, 429942, 546034, 546064, 318376, 544860, 544855, 545895, 256222, 544852, 429937, 312308, 244101, 412138, 417862, 545510, 417856, 244094, 417854, 429917, 285545, 511594, 412125, 544211, 545216, 515411, 429883, 515381, 327239, 515348, 544661, 515344, 515336, 543613, 544656, 544654, 544651, 244057, 244054, 244042, 368272, 542083, 536825, 544048, 514554, 543821, 536823, 514552, 232632, 429704, 429702, 543774, 132928, 543769, 360027, 102428, 267260, 536787, 511030, 429644, 543531, 244015, 542806, 505211, 542444, 429472, 481621, 412094, 481600, 481596, 429380, 429378, 541301, 541298, 481593, 540412, 515279, 132907, 161874, 515274, 515271, 429268, 515263, 515261, 469902, 540394, 540410, 429232, 200024, 278067, 278065, 539433, 539430, 514917, 539647, 539633, 539191, 539188, 489127, 428982, 535732, 537217, 232438, 232433, 249722, 232429, 249718, 536674, 536671, 535672, 536669, 428855, 428826, 356303, 380556, 356294, 521960, 356292, 380554, 527322, 528034, 528020, 528016, 514897, 232329, 428516, 356264, 380519, 471944, 380517, 522972, 522238, 321136, 321132, 419803, 521015, 303326, 428235, 520841, 428221, 411990, 108472, 108470, 243594, 243589, 427811, 108466, 427801, 108462, 380465, 512556, 427787, 108453, 456061, 456059, 515730, 515701, 388853, 404382, 388847, 427720, 515175, 514873, 481551, 514448, 514437, 514324, 514320, 513532, 513088, 513793, 513828, 309313, 362392, 312479, 513227, 513705, 501168, 469832, 513703, 427685, 513700, 511561, 499417, 494716, 494714, 513241, 494708, 511343, 506427, 243528, 512325, 506417, 417841, 506414, 417836, 456055, 456053, 427636, 456049, 456043, 511547, 485413, 456039, 502912, 502910, 511784, 511781, 512319, 417832, 303312, 388179, 511188, 511766, 511764, 321130, 321127, 427583, 427566, 417825, 481528, 427562, 417822, 511546, 511540, 427553, 481518, 427527, 427519, 481510, 511449, 481497, 511320, 511312, 321123, 199729, 321114, 392922, 392920, 392918, 411979, 417821, 232012, 417819, 362384, 427429, 463550, 509887, 509884, 509881, 509875, 509872, 393041, 510464, 393038, 455430, 455426, 385889, 385888, 509868, 509865, 509861, 509858, 509857, 509849, 509845, 509843, 509836, 509818, 509728, 447941, 510009, 615303, 509724, 509721, 509719, 509709, 231962, 493484, 411935, 488023, 411923, 380423, 243316, 58684, 58682, 506684, 505971, 309119, 502906, 231834, 309055, 309053, 231832, 309047, 426875, 321090, 502549, 505607, 426853, 505540, 317168, 426792, 231797, 505268, 505266, 504711, 504694, 321073, 504692, 321068, 504902, 504403, 504837, 231734, 426686, 347945, 504139, 502654, 502643, 504398, 504396, 504394, 347939, 231674, 231657, 426637, 426632, 503916, 426626, 503907, 503903, 380378, 380376, 426597, 503899, 243075, 499893, 231557, 231542, 231533, 371219, 405724, 426538, 108246, 194120, 456236, 426529, 502762, 194116, 194114, 502756, 502615, 378125, 218274, 426485, 502152, 378122, 417814, 417812, 417810, 231513, 417806, 417801, 417798, 401099, 370799, 426446, 243027, 337027, 337025, 388826, 485282, 388823, 485278, 268961, 231464, 496261, 231461, 426437, 499559, 132743, 231449, 108241, 231434, 417795, 231432, 494670, 321048, 500105, 494667, 321043, 337022, 426369, 500102, 417785, 458216, 378118, 426212, 426210, 500096, 500094, 417783, 500008, 108218, 500006, 231350, 231344, 500001, 231329, 499929, 231320, 417781, 400084, 499538, 426177, 474313, 242953, 499527, 494047, 231304, 426122, 426084, 378108, 426079, 378105, 308970, 378100, 308962, 378098, 378095, 498436, 380357, 393828, 468933, 426038, 498425, 426033, 495532, 498467, 498422, 495529, 498417, 498406, 498446, 495522, 495520, 497709, 498099, 498111, 496547, 496545, 231187, 497894, 494437, 489956, 489954, 495620, 497395, 411861, 349662, 411859, 184552, 411855, 411853, 425938, 425929, 496535, 455384, 469772, 494660, 494656, 469765, 492306, 494652, 455382, 492297, 455377, 494650, 423289, 496247, 455371, 423285, 496243, 425904, 495614, 455366, 411846, 493305, 455357, 455351, 455348, 455339, 495604, 425859, 495601, 425854, 425850, 495115, 495505, 217988, 495410, 288816, 495443, 495391, 288812, 495438, 411844, 161865, 288808, 411842, 495337, 479210, 494645, 466825, 495293, 485242, 217968, 494428, 494640, 494637, 199354, 494634, 417769, 417766, 417763, 494630, 265531, 417759, 425798, 493384, 417750, 493367, 493363, 425752, 494342, 318350, 425741, 482124, 482122, 494177, 482116, 482114, 318348, 425723, 132732, 494164, 490905, 318346, 411835, 479203, 411831, 399713, 479200, 479198, 242851, 242849, 417748, 362727, 493871, 108073, 242841, 199320, 303308, 493760, 491951, 493758, 199308, 493743, 303295, 493288, 493282, 485231, 242810, 230997, 242804, 411825, 492825, 388813, 492813, 380347, 492732, 380343, 492725, 492722, 425653, 492498, 492455, 492053, 411805, 404668, 492453, 360003, 425640, 230979, 485212, 321000, 492066, 492050, 492043, 425618, 491924, 199265, 485195, 312300, 199256, 488644, 333634, 488642, 411772, 489843, 489841, 425544, 425540, 489819, 490186, 230870, 490389, 489812, 230836, 375045, 368894, 489805, 368891, 485187, 488734, 458670, 489739, 489733, 488728, 320971, 489488, 320965, 320959, 489356, 485162, 489290, 488870, 488765, 488755, 488865, 488636, 488712, 488709, 108062, 488327, 368886, 488121, 482570, 487881, 108032, 482506, 242602, 425277, 425264, 242537, 242533, 242530, 483266, 242503, 388787, 230611, 484036, 484034, 483239, 471099, 482474, 411738, 242408, 481420, 132648, 481412, 388766, 480953, 480951, 242364, 480657, 320896, 320894, 475146, 475142, 365213, 462552, 359987, 479648, 480655, 480489, 230519, 368162, 480484, 480406, 368160, 217453, 476318, 476314, 480356, 480353, 424972, 424959, 368155, 368153, 424957, 424955, 460805, 424946, 424944, 471921, 477186, 480135, 424937, 480152, 230477, 480150, 230475, 480111, 417741, 480055, 480050, 480043, 417739, 480008, 479180, 411718, 424880, 424878, 476746, 479238, 242305, 365206, 365205, 411712, 365203, 365201, 478926, 478923, 479146, 479089, 479086, 479084, 478963, 478959, 479117, 478921, 479020, 305698, 417738, 478157, 477181, 478321, 476682, 478318, 478316, 478894, 478406, 424861, 424859, 424856, 107958, 388148, 107955, 478258, 478140, 230378, 230374, 424845, 230362, 424827, 424823, 424821, 230354, 107950, 477049, 477172, 453416, 458788, 411708, 477091, 132635, 472882, 476650, 462732, 476482, 476271, 474344, 424717, 107868, 476323, 476307, 198919, 470172, 242177, 312290, 464346, 462703, 230228, 474395, 474790, 474836, 474766, 406431, 474387, 474264, 359983, 417736, 471873, 406404, 376141, 474259, 406401, 473683, 473680, 406391, 473815, 424630, 451829, 359958, 473700, 472703, 265513, 473228, 359951, 453408, 423665, 472962, 472751, 411698, 472802, 472799, 472782, 472780, 472699, 472695, 472693, 349091, 132557, 330184, 470664, 132544, 161840, 471812, 471679, 198819, 471054, 471675, 472102, 471438, 471050, 470800, 470786, 466144, 470496, 470494, 470346, 470344, 242038, 242034, 615299, 424439, 468753, 417722, 454886, 468235, 107824, 468208, 468204, 424422, 468191, 468285, 424419, 462681, 424417, 424397, 107819, 241890, 107816, 455097, 230003, 467841, 448381, 241840, 424355, 424350, 467313, 411686, 424269, 466532, 320784, 132483, 180946, 180941, 424226, 229930, 424221, 465938, 406374, 406367, 461268, 461265, 462666, 462663, 462660, 465546, 465633, 465618, 388133, 406352, 375042, 424194, 463423, 463421, 463414, 424176, 229897, 424173, 465044, 424170, 241728, 464326, 464324, 464319, 464317, 464313, 333595, 241707, 241699, 241686, 464226, 367128, 107733, 107721, 107715, 615295, 107708, 241682, 107704, 107701, 458211, 229881, 229874, 320723, 132446, 320719, 241646, 241641, 241615, 461603, 461600, 161835, 365187, 461854, 461850, 461844, 461837, 423267, 461695, 461549, 461542, 461529, 461483, 461416, 107663, 241607, 460919, 460210, 461114, 417714, 460244, 458069, 336238, 423254, 460575, 423252, 423249, 460240, 459834, 460204, 132386, 460236, 241521, 374972, 459675, 229736, 241516, 423911, 229728, 459156, 336232, 132354, 423894, 308805, 241488, 458321, 458317, 458312, 333584, 458109, 458058, 418055, 454636, 349477, 457166, 359947, 241452, 457029, 241433, 241431, 315710, 451261, 347902, 241414, 397067, 8853, 397064, 8850, 8848, 456801, 456774, 451255, 229704, 456399, 132287, 326500, 423848, 454627, 407715, 388725, 107583, 452228, 453047, 241273, 241268, 411434, 359935, 241258, 229523, 229513, 452135, 393036, 393034, 216440, 241219, 451417, 414784, 371025, 198105, 335134, 107491, 417711, 417710, 450157, 388341, 417706, 450481, 450474, 320590, 450226, 449747, 229419, 450007, 448497, 450005, 450003, 388101, 388091, 449980, 449890, 333565, 449776, 229395, 359917, 359914, 354743, 359910, 448778, 448323, 411631, 359906, 448283, 448274, 447932, 240982, 107432, 421307, 421126, 423177, 423379, 421116, 421111, 320569, 413264, 422652, 422034, 357985, 422750, 229157, 421291, 421636, 421422, 419679, 240870, 240855, 418084, 410758, 420174, 418082, 349291, 419958, 407147, 419955, 419949, 419945, 417705, 411607, 411606, 419688, 229050, 107328, 417704, 417548, 418843, 418667, 418835, 418663, 418674, 318303, 418595, 417698, 417693, 412991, 418007, 132166, 107292, 418005, 229020, 417689, 417996, 415354, 417991, 417986, 312286, 417684, 417681, 417637, 375709, 415893, 414649, 415891, 320495, 417123, 415886, 416924, 228982, 359895, 228978, 320491, 416889, 359893, 228973, 359886, 400931, 416949, 416880, 400929, 416947, 228958, 416913, 228954, 240680, 240676, 228945, 416732, 240666, 240663, 416724, 305692, 240633, 404268, 411569, 415881, 228922, 415878, 378089, 415874, 416161, 416036, 415871, 416159, 615287, 411550, 415868, 228881, 615281, 415729, 615279, 240584, 132139, 240572, 414678, 414670, 197792, 413679, 405304, 368068, 413719, 413675, 411341, 411339, 414432, 240537, 413982, 132107, 240521, 107240, 367087, 397808, 397059, 413246, 411250, 413242, 228845, 240510, 228843, 412901, 413221, 240501, 413278, 413213, 240498, 228820, 411240, 411231, 413150, 411228, 413147, 413135, 240482, 411226, 411217, 411215, 412828, 411211, 321678, 412664, 412826, 412716, 412658, 107181, 412708, 411206, 412789, 411427, 412632, 412613, 412611, 411203, 228775, 312280, 312268, 132100, 228762, 240440, 228749, 320459, 320457, 132075, 285492, 362279, 228696, 405237, 409119, 409375, 406302, 409367, 406296, 409355, 409352, 240299, 409344, 393768, 409110, 393765, 393762, 197660, 373589, 406279, 228579, 228573, 228526, 240249, 408815, 228504, 228499, 240198, 408606, 240192, 408604, 390748, 240174, 228493, 408393, 228490, 407885, 402086, 240150, 240146, 407880, 407876, 407911, 197616, 228472, 215706, 228468, 407905, 228460, 407866, 407840, 333502, 407899, 228430, 228429, 368061, 228420, 107120, 407495, 407585, 407571, 240095, 197582, 407566, 359871, 228394, 390746, 407410, 392916, 240091, 240082, 357397, 240074, 310333, 406275, 240069, 404654, 240066, 240061, 406271, 406268, 406266, 240042, 404652, 228368, 406264, 401910, 348855, 240027, 406996, 379289, 397785, 239996, 406241, 107052, 239972, 398807, 239965, 406238, 393452, 373584, 393450, 393449, 392914, 400032, 161822, 161819, 405663, 382104, 382102, 405159, 399699, 405152, 405148, 399694, 404962, 405142, 171759, 405386, 402546, 404837, 404834, 404950, 404947, 404943, 174255, 106998, 404898, 404638, 404636, 228221, 106995, 392910, 404633, 106990, 404162, 402215, 404160, 392903, 402573, 402570, 402568, 378701, 378699, 404034, 404053, 171723, 171721, 404029, 403630, 394520, 106972, 398984, 381756, 382496, 402392, 382494, 106943, 403154, 106925, 397157, 403110, 403104, 381747, 400796, 378681, 378679, 383547, 402373, 377566, 402315, 392890, 399671, 400138, 399665, 399663, 399660, 106834, 392888, 399647, 398616, 399473, 397141, 106805, 399097, 396833, 399044, 239537, 349463, 359863, 228010, 398789, 106791, 359860, 379807, 393436, 398560, 393426, 320407, 398507, 320384, 106775, 227949, 197231, 239469, 239466, 239463, 397682, 398203, 315676, 315673, 395501, 395869, 395494, 396828, 395864, 395862, 239407, 239396, 395471, 395461, 106656, 395451, 395445, 395441, 106633, 239343, 355154, 394768, 394479, 394867, 394839, 394745, 394581, 239300, 227745, 355137, 239288, 394615, 394613, 394608, 394499, 394494, 393896, 392447, 355115, 393886, 393727, 372601, 384143, 161790, 315669, 393096, 393092, 392879, 392875, 392871, 239216, 392603, 227680, 227678, 227676, 315662, 392591, 239205, 392269, 392550, 392561, 239171, 239169, 391661, 390895, 391641, 239153, 239148, 391638, 383788, 392060, 239145, 106601, 389813, 391633, 391627, 390879, 391623, 389409, 214992, 227643, 391322, 389651, 391320, 390863, 239057, 390860, 390855, 214977, 390290, 320353, 390287, 320350, 227591, 390707, 387206, 390003, 387974, 385507, 106537, 389975, 106530, 389805, 389840, 383777, 386116, 389325, 387577, 388500, 389074, 387575, 388576, 308732, 375752, 387462, 388573, 388571, 387763, 388324, 388550, 388478, 278027, 386987, 214892, 388428, 358350, 387108, 387105, 387596, 387593, 387564, 387562, 356566, 387492, 387452, 387310, 214854, 387306, 385648, 161770, 161766, 385229, 386402, 386399, 227527, 335130, 335128, 387345, 387153, 183071, 214844, 385227, 359226, 214833, 387142, 383724, 294226, 386918, 308706, 227495, 161756, 183069, 386449, 183066, 183064, 183063, 106481, 183060, 386422, 183056, 183054, 238787, 382471, 386253, 386251, 238780, 238771, 238768, 238762, 386299, 386245, 335126, 386241, 348404, 383713, 238738, 386113, 386110, 238727, 386107, 348298, 385685, 385611, 385127, 385608, 385682, 354418, 385477, 355109, 385118, 319237, 385421, 227397, 376089, 384923, 358526, 376087, 383699, 227395, 385373, 214719, 385293, 385276, 106461, 385146, 385205, 385202, 365160, 385200, 385272, 382632, 238684, 385142, 384953, 382208, 238654, 227373, 383530, 384657, 106416, 384630, 384783, 335123, 335121, 384627, 382812, 381283, 303263, 384709, 309973, 309966, 384625, 214650, 320289, 308695, 214636, 238602, 366973, 214606, 303257, 384311, 383952, 252736, 383686, 349451, 383949, 227337, 238582, 303250, 303248, 366955, 227332, 384303, 383663, 384297, 274559, 369636, 384292, 381659, 274557, 383658, 383945, 383943, 383937, 384022, 214569, 383934, 214567, 214560, 214557, 106367, 214555, 359087, 383921, 359080, 383886, 214553, 274552, 274548, 303241, 374497, 365138, 382857, 383512, 383106, 383412, 383202, 382855, 348969, 161740, 383192, 383189, 382852, 161738, 303228, 320276, 383009, 382720, 382686, 374486, 383007, 383095, 382684, 303226, 383005, 382980, 379794, 320274, 382937, 382680, 382714, 382935, 308681, 382651, 362761, 383056, 382933, 362758, 383086, 379865, 378082, 379792, 382994, 382927, 382712, 161732, 382710, 308675, 382196, 382575, 106364, 382842, 382187, 382745, 382668, 106359, 106355, 381266, 106352, 382488, 382663, 378079, 378077, 227280, 372471, 382465, 377431, 377427, 382357, 19796, 238511, 382355, 65522, 382227, 346317, 382096, 376017, 376069, 375745, 252731, 370431, 379365, 330846, 375739, 616405, 375737, 227239, 364404, 381702, 227228, 330839, 376054, 381718, 320256, 227216, 381715, 381338, 381636, 381488, 371155, 381277, 379140, 381274, 381271, 379846, 364401, 375735, 379241, 238455, 379684, 379742, 362618, 379483, 308655, 379034, 379031, 379029, 362845, 379027, 379468, 379399, 379197, 379352, 378490, 379350, 379384, 379382, 379086, 378057, 378643, 106333, 379005, 378849, 377882, 376945, 350017, 377626, 369359, 375890, 306799, 377607, 378188, 378217, 378040, 364397, 305680, 363515, 363513, 377494, 274536, 180909, 377643, 377594, 377641, 377418, 377591, 376693, 376931, 376929, 106299, 377104, 376927, 377414, 377382, 375733, 376922, 377039, 377277, 377037, 205305, 377267, 359838, 106275, 374479, 374964, 131830, 375727, 131827, 274523, 227030, 376906, 274521, 106264, 106261, 106259, 359835, 363555, 359831, 376870, 238273, 376844, 359828, 375874, 359825, 238250, 359823, 238248, 227023, 238244, 238229, 376627, 376667, 359819, 376500, 226993, 376640, 372928, 376476, 374961, 238209, 374319, 376466, 196656, 376001, 376491, 375996, 327214, 369343, 374316, 327212, 374313, 214292, 214290, 376026, 375101, 299831, 327044, 373907, 375799, 374958, 374307, 375581, 375579, 214263, 335119, 335117, 374954, 330827, 330824, 330821, 362117, 375025, 335115, 375569, 106208, 106205, 375091, 306777, 373706, 373704, 306773, 335112, 373702, 346252, 346247, 372140, 335110, 308615, 335108, 278008, 214199, 106186, 375084, 372137, 335106, 335103, 374937, 106181, 214149, 106176, 372134, 375074, 305671, 374691, 375020, 274515, 274513, 372131, 374846, 374843, 373697, 374840, 373693, 327025, 374458, 106168, 373690, 106166, 106164, 373349, 374519, 374565, 278000, 335098, 374533, 318473, 374560, 374558, 374530, 374427, 373684, 374415, 374405, 372129, 373797, 372214, 373679, 306760, 372122, 226932, 335095, 374198, 355291, 226930, 373869, 372208, 374194, 374275, 226928, 226927, 371249, 373778, 226924, 373856, 226922, 214107, 374188, 374172, 306750, 372989, 373817, 365760, 373466, 274511, 274509, 373058, 373666, 373682, 373663, 373661, 373605, 373621, 373367, 371334, 65510, 373418, 373359, 371332, 371329, 372730, 65504, 371327, 371325, 106155, 106153, 373281, 370417, 372887, 373275, 362076, 373034, 106126, 372816, 106124, 368021, 373103, 372814, 372683, 370210, 327197, 362072, 362056, 372590, 327165, 372789, 372783, 372778, 372673, 372806, 372776, 372518, 213938, 367869, 372176, 372170, 213908, 277997, 213892, 371407, 372100, 366112, 372160, 277985, 106084, 347847, 371089, 371095, 362019, 347839, 370933, 106052, 366877, 370024, 370022, 370019, 368637, 370155, 369540, 359804, 369893, 213721, 369620, 369605, 213712, 370061, 362587, 370058, 369891, 226618, 345544, 369935, 369533, 180886, 370006, 369600, 367866, 369598, 360724, 369590, 140307, 369655, 361292, 364392, 362013, 345542, 369586, 368634, 362009, 368628, 362007, 367864, 180869, 369481, 367764, 303219, 303217, 369363, 310324, 368483, 310322, 310320, 213673, 329510, 237974, 366655, 368660, 368793, 368565, 140303, 368558, 368556, 368516, 140301, 237958, 362536, 140298, 362533, 362530, 362527, 366801, 180828, 367849, 367846, 367845, 367844, 367843, 366848, 349447, 363505, 367803, 367757, 366776, 367753, 367750, 366792, 366758, 366756, 366785, 366754, 366618, 366783, 366781, 366749, 366615, 366613, 226552, 354856, 366649, 365517, 366598, 365514, 364390, 356985, 106019, 356982, 366576, 364387, 364384, 366386, 364382, 366466, 364380, 261244, 330799, 366362, 106016, 366359, 366383, 106014, 261242, 357751, 365381, 365669, 365667, 366349, 366264, 261230, 106009, 364680, 365109, 363954, 366261, 357539, 105995, 357537, 65464, 237880, 331279, 296252, 364373, 226511, 237859, 365093, 331276, 365836, 365091, 365652, 365810, 237830, 226495, 365647, 105955, 360721, 226485, 226481, 361995, 361993, 303211, 359797, 303209, 303205, 364925, 353963, 350565, 363347, 364669, 364716, 364709, 363345, 364664, 346839, 44898, 44895, 364230, 364505, 364460, 364456, 364434, 44889, 364411, 303190, 303188, 359783, 364407, 364226, 303181, 361279, 363300, 303169, 353395, 363298, 361552, 333375, 333370, 361268, 363295, 363340, 343273, 59854, 361254, 59852, 363852, 346824, 352805, 346817, 363660, 363644, 363291, 363426, 226352, 36030, 226346, 363288, 363287, 363334, 360592, 363283, 349443, 363119, 105894, 359770, 362932, 277446, 346813, 180779, 341388, 362834, 361240, 362565, 361235, 357039, 361083, 361969, 362643, 361962, 361956, 361231, 361953, 362554, 256205, 361942, 256203, 361940, 226268, 358589, 362551, 256200, 256198, 256196, 361837, 361919, 105872, 361835, 361912, 353870, 353868, 361910, 360659, 105869, 361833, 359760, 353865, 361831, 105858, 361692, 105845, 361346, 131798, 361343, 350326, 361340, 131796, 361689, 131792, 131790, 361736, 180751, 360938, 360935, 361076, 360933, 361074, 360378, 361536, 361534, 105820, 155139, 361198, 347824, 360931, 105817, 105815, 67270, 360929, 155136, 344251, 361358, 361184, 360828, 361174, 344247, 344245, 303131, 303109, 343437, 347816, 347811, 359207, 359204, 183048, 358198, 359199, 347805, 355278, 303090, 359725, 359720, 44879, 347802, 347800, 327157, 342719, 359706, 357768, 357581, 359697, 359695, 357579, 359693, 303087, 303084, 226015, 303076, 56795, 358193, 358188, 358185, 359026, 354717, 359020, 358787, 354714, 358780, 358778, 358948, 358183, 358463, 336011, 357737, 354845, 358460, 357086, 352444, 358433, 358430, 155132, 357431, 354707, 357161, 356752, 327151, 327148, 356232, 352664, 356134, 356132, 356126, 352778, 196232, 225682, 353830, 355201, 354616, 354823, 354818, 355198, 350078, 343633, 355193, 355190, 346786, 346784, 346782, 353545, 310310, 346780, 348831, 354690, 348822, 353912, 354674, 348820, 354620, 353535, 348808, 305665, 305663, 59842, 354552, 59840, 353751, 352648, 315202, 353961, 353717, 349285, 343294, 333257, 310117, 303073, 353289, 310301, 352436, 310296, 352757, 352434, 352431, 347495, 310290, 352428, 353224, 310275, 352755, 338787, 306019, 352558, 306016, 338785, 352033, 351942, 350884, 352422, 351933, 351688, 351680, 349330, 349319, 350511, 350872, 351096, 350869, 351066, 350675, 351063, 351579, 350723, 351549, 351541, 350128, 350715, 350053, 347159, 350124, 303056, 350122, 334287, 351366, 349864, 205280, 349859, 349855, 350919, 348589, 303042, 295966, 348586, 351059, 333246, 350265, 351055, 350845, 277426, 346007, 350660, 327140, 350655, 327138, 321658, 327130, 350024, 347655, 343291, 347676, 350007, 349438, 349650, 347670, 347570, 155128, 310248, 349273, 331237, 335235, 310246, 299639, 161713, 310244, 348601, 347143, 348528, 348471, 348461, 343422, 348454, 345757, 273853, 273851, 346565, 338768, 346563, 345089, 277400, 346561, 345084, 277398, 299631, 345082, 348040, 338763, 277395, 338761, 346559, 345498, 343412, 343396, 155123, 344209, 333199, 346746, 273845, 346744, 344203, 273843, 346551, 345833, 314992, 319224, 345535, 345424, 344606, 344601, 344597, 343558, 343556, 343581, 343265, 339570, 339568, 343001, 342996, 342991, 310168, 342299, 339558, 342470, 342056, 340482, 256154, 256152, 331704, 331701, 338717, 341911, 338701, 341798, 341789, 341787, 339556, 341775, 341773, 262895, 339554, 341204, 341200, 341197, 341193, 341548, 341191, 23311, 341361, 341417, 341413, 341355, 279079, 23306, 273825, 340654, 327128, 333161, 340132, 340130, 340734, 340730, 337893, 273810, 273808, 273807, 340474, 161703, 161701, 340536, 336183, 102425, 336181, 161699, 338234, 336173, 340462, 336170, 339114, 336168, 339227, 340460, 340448, 340014, 340280, 340169, 339110, 340270, 279072, 340041, 340039, 340037, 340076, 337393, 340073, 339988, 338741, 339985, 339920, 339983, 339980, 339918, 340005, 338657, 336151, 336148, 339932, 339905, 338837, 338833, 336131, 339468, 339538, 339250, 277380, 336127, 339202, 338511, 338690, 338880, 337828, 338732, 337888, 331679, 315630, 337876, 336121, 336118, 337520, 337510, 336099, 161695, 335762, 335088, 335488, 335093, 277322, 334077, 315613, 315601, 334139, 334134, 305400, 332966, 332963, 332962, 332959, 327285, 332489, 332439, 332429, 328803, 330612, 331933, 194112, 327901, 331909, 194109, 194107, 331193, 329544, 330560, 330602, 328800, 330556, 329521, 327102, 328014, 328839, 328632, 327454, 327453, 327449, 327442, 328122, 328116, 328114, 328128, 327882, 328069, 327578, 319007, 327257, 327096, 324400, 325462, 202625, 202623, 326555, 312010, 321834, 325589, 321267, 325587, 305619, 305615, 319206, 319134, 318806, 317476, 311992, 318625, 318463, 318460, 260876, 260874, 260871, 311983, 318150, 318204, 316317, 316315, 318390, 318200, 318199, 316313, 318136, 317588, 312703, 317380, 317471, 18755, 312048, 317095, 317093, 316119, 316107, 316101, 314103, 314094, 314091, 307711, 313630, 313620, 312579, 312853, 313371, 313362, 312046, 312559, 312845, 312842, 312044, 312248, 312244, 312240, 311916, 312237, 189605, 311962, 307692, 305467, 307343, 306815, 305575, 305809, 300951, 302373, 261105, 303502, 303498, 160791, 302365, 302200, 301842, 302198, 160783, 302195, 302191, 301834, 301680, 301830, 300767, 297199, 297173, 297150, 297147, 295752, 294723, 183027, 278121, 277915, 273772, 272935, 270175, 270173, 271456, 270890, 270170, 270167, 270377, 269404, 269399, 615265, 615262, 615261, 615254, 615252, 267119, 262242, 263747, 263744, 182923, 260490, 258927, 128844, 249383, 249381, 249624, 184609, 249614, 615242, 249375, 222801, 122568, 257544, 257542, 257453, 255941, 222207, 255896, 255329, 130857, 255209, 250936, 248013, 250033, 250031, 248241, 248199, 249336, 249334, 249181, 615237, 248757, 193334, 248753, 248690, 248687, 193578, 193575, 615157, 194215, 195160, 193315, 195097, 195073, 193312, 615151, 185140, 189493, 182904, 185884, 182898, 182895, 182891, 182883, 175676, 185415, 184471, 184454, 184394, 184379, 183253, 182789, 174457, 173433, 172260, 122473, 171541, 170113, 169417, 140668, 168337, 163531, 122393, 140661, 158780, 156817, 137887, 137877, 167233, 167217, 167215, 158953, 165810, 165572, 164991, 162549, 162547, 162542, 162395, 162215, 155984, 159530, 159528, 159523, 159503, 159100, 159093, 159091, 159089, 159084, 152396, 158212, 152394, 158073, 157736, 137874, 137872, 155031, 155029, 155981, 154466, 154625, 153027, 153210, 153022, 153135, 153019, 137870, 137865, 137852, 143487, 151503, 152051, 152049, 152047, 151372, 151606, 151273, 150149, 148325, 148321, 148320, 148307, 148305, 147712, 82160, 143485, 143001, 122278, 146710, 146885, 146706, 146698, 146249, 144924, 143474, 143471, 142214, 144729, 145048, 144724, 144722, 144720, 144716, 144910, 144766, 143464, 139775, 140571, 142985, 140569, 142970, 141701, 141699, 140071, 122914, 122907, 138416, 135852, 135850, 135742, 130280, 118534, 124051, 118528, 122830, 122817, 121411, 119035, 116452, 118986, 114217, 118434, 118510, 118459, 118407, 118457, 118153, 116547, 116543, 117116, 115954, 115947, 115944, 115937, 102411, 102409, 102407, 82152, 82877, 82875, 85958, 91710, 82140, 82137, 77049, 57035))
Run Time: 0.085252
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4423 | |
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 | | | | | 4423 | |
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 (31122, 30717, 30199, 29980, 29796, 29441, 28810, 28438, 28402, 26222, 25132, 21470, 32153, 19765, 19199, 18547, 18390, 17713, 17180, 16860, 16507, 16349, 15715, 13534, 12872, 12860, 11824, 10705, 10365, 9463, 7172))
Run Time: 0.002005
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 31 | 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.000210
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=2030, 1717219303, , 0, �
Run Time: 0.000141
- 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.000305
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 215
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 158
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (120))
Run Time: 0.000497
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 158
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1717219003
Run Time: 0.000302
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 19 | 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` >= 1717219003)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000436
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 19 | 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