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.000556
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.000184
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` = '8837')
LIMIT 1
Run Time: 0.000763
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.001754
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_8837' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.178083
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 (646182, 646176, 646145, 646135, 646105, 646103, 646100, 646093, 646089, 646045, 646042, 646037, 646007, 646002, 645995, 645987, 645977, 645976, 645975, 645910, 645896, 645894, 645881, 645866, 645860, 645805, 645733, 645717, 645714, 645712, 645678, 645631, 645588, 645518, 645509, 645504, 645469, 645399, 645391, 645383, 645341, 645301, 645297, 645295, 645144, 645102, 644701, 644624, 644383, 644195, 644185, 643982, 643938, 643928, 643927, 643925, 643923, 643843, 643828, 643684, 643593, 643556, 643534, 643530, 643506, 643497, 643481, 643462, 643461, 642889, 642883, 642851, 642786, 642761, 642656, 642654, 642652, 642552, 642551, 642536, 642529, 642495, 642487, 642482, 642480, 642479, 642471, 642469, 642442, 642416, 642404, 642402, 642397, 642391, 642384, 642361, 642225, 642195, 642181, 642121, 642085, 642083, 642022, 642019, 641997, 641843, 641842, 641829, 641825, 641816, 641780, 641713, 641710, 641359, 641336, 641333, 641328, 641290, 641289, 641276, 641256, 641226, 641214, 641210, 641180, 641177, 641097, 641021, 641013, 641007, 640949, 640943, 640941, 640900, 640897, 640895, 640864, 640832, 640831, 640829, 640819, 640593, 640784, 640761, 640753, 640690, 640688, 447740, 447737, 639739, 640685, 640682, 640680, 640670, 640666, 584009, 584008, 640653, 584007, 640647, 584004, 584003, 640589, 640587, 584002, 640577, 580761, 640575, 584000, 534941, 417939, 640496, 583999, 583998, 583997, 583996, 583993, 109264, 109262, 109260, 583992, 583990, 639994, 639992, 583988, 583986, 640472, 447595, 447590, 447588, 640445, 583984, 583983, 627578, 583981, 627574, 627573, 627572, 627566, 627565, 627563, 627561, 627559, 627558, 627556, 627554, 583980, 583979, 640333, 583978, 640214, 640211, 640209, 640207, 640271, 640228, 640224, 632844, 632842, 640188, 637061, 639695, 632222, 637059, 583977, 640118, 447534, 447526, 640096, 640094, 640092, 583976, 640090, 640088, 583975, 583974, 640031, 447523, 640147, 640078, 639522, 640137, 583972, 453832, 640135, 534924, 639514, 639692, 639511, 639509, 639507, 639505, 583971, 447488, 447485, 447483, 447476, 447474, 447468, 539593, 539590, 640034, 640028, 447466, 447462, 539586, 539582, 447459, 447455, 447444, 447440, 447438, 639683, 447436, 447429, 447402, 447400, 447398, 447392, 627550, 583970, 601759, 639677, 583969, 639763, 639759, 639752, 639750, 627549, 627547, 639440, 639436, 627542, 627541, 491360, 447331, 447327, 639427, 639421, 636081, 636077, 639490, 447304, 447302, 447299, 583968, 636071, 534895, 534893, 583967, 639098, 639096, 637442, 583966, 583965, 637438, 637436, 637434, 638584, 638138, 583964, 534889, 639339, 639336, 583963, 583962, 639086, 639075, 639073, 639071, 639064, 447248, 447245, 639057, 583961, 639230, 639055, 639226, 638710, 638707, 639053, 447234, 583960, 447231, 447225, 447223, 447214, 583958, 583957, 638581, 639220, 639215, 634143, 634140, 639214, 583956, 583955, 639164, 639033, 639031, 639029, 447207, 447202, 639197, 447200, 447195, 447188, 639136, 639028, 447185, 583954, 639185, 447174, 447172, 447170, 447167, 534884, 534883, 447163, 447161, 447159, 534882, 639170, 639113, 639021, 583953, 639019, 347180, 347177, 347174, 583952, 447141, 201204, 583951, 534875, 583950, 447130, 447120, 583949, 583947, 583944, 583943, 638902, 638900, 583941, 554448, 583939, 638831, 638829, 447096, 638827, 638824, 638763, 534870, 534868, 636624, 636622, 636620, 583938, 583937, 447094, 447092, 447090, 638615, 583936, 534862, 534861, 638573, 583934, 447084, 447082, 362818, 362815, 583933, 583932, 638496, 638494, 583931, 534855, 534854, 583929, 534853, 638491, 638489, 638545, 534850, 580707, 580705, 580699, 580695, 583928, 453824, 638531, 638529, 534849, 534848, 583927, 583926, 583925, 638518, 583924, 447075, 447072, 447067, 447065, 447062, 583923, 447056, 534844, 583922, 447049, 638405, 572556, 583921, 638396, 447045, 572550, 638393, 447043, 572546, 447040, 583920, 534842, 638390, 583919, 447036, 447033, 638383, 638381, 638379, 447031, 583918, 447027, 583916, 447024, 534841, 133358, 638365, 133356, 583915, 638361, 638351, 583913, 638348, 638340, 583910, 583909, 447005, 583908, 638326, 583907, 638267, 583906, 583905, 583902, 583901, 638265, 583899, 446986, 638244, 583898, 583897, 583896, 583895, 612893, 633935, 638241, 633928, 633924, 583894, 583892, 638163, 534828, 638130, 446978, 638128, 446976, 638222, 583889, 583887, 583885, 446974, 446972, 638084, 638197, 446947, 554447, 583884, 583882, 554446, 583881, 629985, 247270, 583879, 583878, 247268, 583876, 583874, 583873, 636896, 638150, 638111, 638109, 534822, 638107, 534820, 583872, 638069, 638067, 534817, 638019, 583871, 583870, 534816, 601235, 534814, 446941, 638050, 583869, 638036, 638033, 583868, 583866, 583864, 583862, 583861, 638028, 583858, 583856, 638000, 637997, 583853, 583852, 637969, 637951, 637967, 446937, 583851, 583849, 637883, 446935, 637943, 637881, 637941, 637939, 534807, 635035, 580677, 583847, 637874, 637872, 637870, 583846, 637919, 446930, 637918, 534803, 637916, 446923, 565483, 637865, 637863, 637861, 637858, 534802, 534799, 637857, 637900, 637896, 637894, 637892, 637856, 583845, 637887, 565480, 637853, 565477, 623333, 637488, 583844, 446909, 446907, 637482, 583842, 637480, 637763, 565475, 637746, 565473, 583839, 565465, 565463, 583838, 534796, 637622, 637619, 637617, 637613, 534788, 534787, 583837, 637655, 583835, 446874, 583834, 583832, 446869, 446865, 637582, 583831, 583829, 583828, 534780, 637451, 637449, 637447, 637445, 583826, 583824, 583823, 534774, 534773, 583822, 534771, 583821, 583820, 446782, 446775, 583819, 583818, 446765, 446763, 583817, 583815, 534766, 607954, 583813, 607952, 583811, 583810, 583809, 637130, 334014, 334011, 583808, 637128, 201192, 534757, 583807, 637091, 637070, 637089, 637048, 637046, 637044, 637042, 637087, 637041, 637040, 637037, 637034, 583806, 534748, 636244, 446722, 636981, 583805, 636918, 583804, 636844, 583803, 636833, 583802, 583800, 309842, 309840, 446716, 534745, 583799, 583798, 446715, 628599, 628598, 628596, 583797, 628591, 628588, 628586, 446713, 446711, 446707, 583795, 583794, 583793, 583792, 630259, 583791, 446696, 446695, 446692, 446691, 446689, 583790, 583788, 583786, 446641, 583784, 583783, 636425, 636419, 569071, 583782, 636389, 583781, 636387, 583780, 534725, 636350, 583779, 583778, 583776, 583775, 534721, 636332, 446624, 446619, 534720, 583774, 636303, 636271, 201189, 583772, 606402, 636265, 636263, 606400, 606399, 606397, 446584, 446579, 446578, 446575, 583771, 636251, 583770, 534718, 446537, 534714, 583769, 446535, 247239, 583768, 247236, 247233, 583767, 534712, 636164, 446510, 446505, 446500, 636113, 636098, 446497, 446493, 635996, 583766, 635994, 601789, 635992, 534702, 583765, 583764, 247213, 247205, 583763, 636085, 623644, 633510, 583762, 583761, 583760, 636046, 583758, 583757, 583755, 636036, 583753, 583752, 636025, 583751, 534697, 583750, 583748, 583747, 583746, 583744, 601188, 583743, 534692, 630232, 446467, 583742, 635770, 632231, 534689, 635847, 583741, 583740, 635841, 635839, 635830, 446447, 635820, 583739, 446444, 446441, 446439, 583738, 583737, 535651, 635732, 535649, 623643, 446420, 583736, 583735, 583734, 534675, 583733, 583732, 583730, 610304, 583729, 635534, 534672, 635525, 635461, 635508, 583728, 201184, 583726, 635345, 635342, 635340, 635338, 635336, 534666, 634133, 635330, 534665, 446408, 635325, 446400, 629958, 634131, 446397, 446395, 635268, 446393, 604364, 635254, 446391, 446386, 446384, 635237, 446382, 446379, 446377, 446374, 446373, 446370, 446364, 201183, 635077, 635006, 635004, 635000, 634995, 534654, 583725, 583724, 634917, 634915, 634913, 583723, 583722, 534651, 609320, 583721, 583720, 583719, 583718, 583717, 583714, 583713, 583711, 583710, 590143, 583709, 583708, 583707, 634717, 634749, 634715, 583706, 634713, 634712, 583705, 634559, 583704, 583703, 583702, 446300, 634505, 634500, 583701, 605423, 583700, 583699, 634231, 634234, 634225, 634193, 446257, 583698, 634091, 583697, 634088, 634085, 583696, 534606, 634082, 634080, 628264, 634078, 634075, 201176, 634070, 632568, 634109, 634053, 602485, 634051, 602483, 634108, 628262, 628260, 602480, 632563, 583695, 623641, 583694, 633066, 605264, 605263, 605261, 605260, 605258, 605256, 605254, 605252, 605250, 605248, 605246, 605244, 605242, 605240, 605238, 623640, 583693, 583692, 605236, 605235, 605234, 605232, 605230, 583691, 583690, 633603, 583689, 583688, 583687, 446221, 534594, 446217, 446215, 446213, 583686, 583685, 583684, 633881, 515524, 446203, 446201, 534593, 583683, 583682, 583681, 633534, 534589, 623639, 534587, 583680, 633514, 633512, 633509, 633508, 534586, 632919, 583678, 583677, 633869, 583676, 583675, 633231, 583674, 633229, 633439, 633227, 536408, 629924, 629921, 583673, 583672, 583671, 583670, 623635, 633292, 633291, 583669, 623634, 583668, 583667, 583666, 583665, 534572, 534569, 583664, 534564, 583663, 583661, 583659, 583658, 633163, 534559, 583657, 583656, 583654, 583653, 446122, 583652, 631986, 631984, 583651, 583650, 633060, 446115, 446113, 633058, 446108, 583649, 633051, 633046, 583648, 534538, 583647, 632978, 632975, 583646, 632839, 631911, 608480, 608477, 632837, 583645, 446065, 446061, 247158, 583644, 446048, 446045, 446038, 534531, 446035, 189126, 632895, 583643, 446031, 446012, 583642, 446010, 583641, 583640, 534526, 446001, 625687, 445999, 632847, 445997, 445995, 534524, 632825, 632819, 632817, 632815, 632812, 632809, 247144, 247140, 247136, 534518, 445991, 583639, 445982, 583637, 583632, 583628, 583627, 625686, 583625, 583624, 631623, 631621, 583622, 631613, 631610, 583621, 583619, 583617, 631608, 631605, 583615, 583612, 631600, 631596, 631594, 631593, 631589, 631587, 631585, 631583, 583611, 632640, 627253, 632637, 445963, 445960, 445958, 583610, 631573, 631570, 631567, 631565, 631562, 631552, 631547, 632454, 583609, 583608, 325224, 325221, 325219, 583607, 534498, 445948, 631212, 632368, 583606, 583605, 631209, 534495, 632404, 632402, 632306, 583604, 632303, 632319, 632301, 632275, 632273, 632271, 445937, 445935, 583602, 445933, 534494, 583601, 632121, 247110, 583600, 583599, 583598, 583597, 632107, 534493, 534492, 580606, 580604, 583596, 583595, 632093, 445921, 583594, 583592, 583591, 632027, 632073, 445919, 583590, 583589, 445914, 445913, 445910, 445907, 445904, 445902, 445898, 445895, 445893, 632014, 445891, 445888, 445883, 445879, 632001, 632007, 583588, 632005, 445873, 445871, 445868, 445866, 445863, 445860, 445858, 445856, 445854, 631976, 631879, 583587, 583586, 631943, 631891, 631941, 583585, 631869, 445828, 631867, 631279, 631277, 583584, 445814, 631274, 631272, 445805, 631538, 631536, 631835, 631802, 583583, 631533, 583582, 583580, 583578, 583576, 583572, 534482, 583571, 583570, 631798, 631525, 631523, 583569, 631521, 445802, 631519, 631516, 583568, 631514, 583566, 583564, 583563, 534478, 583562, 631737, 631507, 583561, 631478, 631476, 631474, 583560, 631711, 631726, 583559, 583558, 631465, 631693, 445764, 631454, 631451, 583557, 631427, 631418, 631416, 631413, 631404, 583556, 631401, 631396, 631392, 631390, 631665, 580568, 631388, 631380, 583555, 583554, 631378, 631376, 631374, 631372, 583553, 631357, 631353, 631350, 445749, 631348, 445747, 631651, 631649, 445744, 445736, 445734, 631647, 445725, 445722, 445720, 445717, 534467, 583552, 445713, 445711, 583551, 631342, 627100, 627098, 583550, 445702, 445699, 445698, 583549, 445691, 445687, 445685, 445676, 445670, 583548, 445668, 445666, 445664, 445657, 445655, 583547, 583546, 631251, 631232, 583544, 583543, 414287, 583542, 583540, 583539, 392476, 631190, 631180, 631178, 631174, 609955, 609953, 631135, 583538, 631129, 631123, 583537, 631121, 331430, 631114, 631110, 331428, 583536, 583535, 583534, 331423, 331420, 331418, 331416, 331414, 331408, 331406, 331404, 631081, 631075, 583533, 631059, 589998, 445642, 445635, 445633, 445631, 583532, 445629, 583531, 627165, 627159, 627153, 534455, 627146, 627144, 627142, 627140, 627134, 583530, 583529, 607469, 607467, 607465, 534453, 607445, 583528, 583526, 630666, 583524, 583522, 534447, 630821, 630819, 630817, 583521, 583520, 583519, 583518, 583517, 583516, 583515, 629303, 583514, 583513, 583512, 583511, 583509, 630591, 534433, 534427, 583508, 534425, 583507, 583505, 583503, 583502, 630538, 630533, 630357, 453790, 630355, 534424, 583501, 630439, 630436, 630434, 583500, 625389, 630412, 624168, 630354, 630353, 625386, 630342, 628073, 534415, 445500, 445498, 445495, 445493, 445489, 445484, 445482, 445478, 445474, 583499, 630077, 630061, 534404, 629861, 247070, 629855, 583498, 628310, 628309, 629629, 629821, 247066, 247063, 247058, 247056, 445445, 445443, 445441, 445439, 445437, 445435, 445433, 445431, 445429, 445407, 551781, 629635, 629633, 583497, 324055, 583496, 583495, 583494, 628615, 629226, 534349, 583493, 629204, 583492, 629181, 583490, 534342, 583489, 583488, 534336, 628878, 534332, 583487, 354536, 623825, 583486, 629049, 583484, 583483, 583482, 247013, 583481, 580462, 247011, 247008, 580460, 580458, 583480, 580456, 629018, 583479, 628954, 628949, 583477, 201128, 201127, 201125, 583476, 583474, 583473, 201123, 201122, 201120, 628912, 201115, 201113, 583472, 583471, 201110, 583470, 624132, 583469, 583467, 583466, 201106, 201104, 583465, 201103, 583463, 628573, 534325, 624129, 583462, 628831, 628848, 628833, 534322, 583459, 534319, 628555, 628770, 628766, 628764, 628763, 201094, 628761, 628534, 583458, 628531, 628469, 583457, 628455, 628450, 445252, 445234, 445229, 583455, 583453, 628295, 583452, 583451, 628215, 583450, 445150, 628063, 583449, 445141, 445136, 627965, 627962, 583448, 627634, 445052, 445041, 445039, 583447, 627589, 627622, 583446, 583444, 583443, 583442, 583441, 583440, 534294, 583439, 583438, 583437, 583436, 627132, 583435, 583434, 583433, 445005, 534292, 583432, 583430, 189080, 445002, 627344, 627276, 444998, 583429, 583428, 583427, 444987, 627118, 627116, 627113, 444977, 444975, 627129, 627111, 583426, 627108, 583425, 583423, 583422, 627038, 627036, 627047, 626892, 623628, 626890, 583421, 602826, 444942, 583420, 627003, 583419, 583417, 444937, 626945, 583416, 626914, 583415, 583414, 534286, 534285, 444935, 626898, 583413, 583412, 583411, 444930, 444928, 444924, 444922, 534284, 444917, 444914, 626797, 583409, 583408, 626663, 583407, 583406, 626790, 626641, 444906, 444903, 246992, 246990, 246988, 246986, 583405, 583404, 626633, 444884, 583403, 626639, 626731, 626638, 583402, 605451, 583401, 583400, 583399, 583398, 583397, 626587, 626564, 583396, 583395, 583394, 583393, 583392, 201076, 583391, 626455, 583389, 583387, 626443, 444873, 583385, 583384, 583383, 444864, 607924, 626388, 444851, 583382, 583381, 444841, 583380, 444823, 444819, 626349, 444817, 626343, 201072, 109254, 583379, 583378, 444766, 583376, 583375, 623625, 583374, 626237, 583373, 583372, 391981, 246980, 583371, 246977, 583370, 246974, 583369, 583368, 626110, 626067, 396529, 583367, 626084, 625565, 625563, 625560, 583366, 583365, 583364, 625556, 625549, 625546, 583363, 583362, 625966, 583361, 583360, 625941, 583359, 583358, 534245, 583357, 583356, 583354, 534232, 625836, 534230, 625805, 583353, 583352, 583349, 583347, 444623, 625191, 444619, 444615, 444613, 444611, 444607, 444521, 444518, 583345, 625702, 444508, 444503, 583344, 444468, 583343, 246953, 583342, 583340, 583339, 583338, 625487, 583336, 625485, 583333, 583332, 583331, 534203, 583328, 583327, 583326, 583325, 625407, 623610, 625403, 583324, 625310, 625309, 625307, 625300, 444399, 444388, 444386, 583323, 625253, 583321, 583320, 534172, 534170, 201063, 625247, 583319, 625218, 625187, 583318, 583317, 583316, 583313, 583312, 583311, 583310, 583307, 583306, 583302, 583299, 583297, 583296, 583294, 583292, 583290, 583287, 583285, 583281, 583278, 534130, 583277, 583276, 534115, 534114, 583275, 583274, 534111, 583273, 534104, 583272, 624306, 534094, 583270, 583266, 583265, 534064, 583264, 583263, 583262, 583260, 444127, 583259, 583258, 246926, 583257, 583256, 583253, 246920, 246918, 623963, 444081, 623961, 623958, 444075, 583252, 623952, 583251, 583250, 583249, 583247, 623909, 623907, 623904, 583244, 444050, 583243, 444036, 444034, 444028, 624101, 444026, 444022, 623805, 444018, 444013, 595282, 595280, 583241, 583239, 583238, 443994, 443984, 615003, 443945, 443939, 623790, 583237, 583236, 533974, 623754, 623597, 623596, 623593, 608010, 623711, 623699, 583235, 533960, 571273, 571271, 571269, 583234, 443873, 583233, 608008, 608006, 583232, 443867, 443855, 443852, 443847, 443845, 443843, 443836, 583231, 583230, 583228, 533952, 443832, 443827, 533948, 573235, 573233, 443809, 573231, 443807, 443805, 443789, 443787, 443782, 443780, 443778, 443776, 443774, 608004, 608002, 583226, 623399, 583225, 583224, 583223, 623345, 608000, 583222, 583221, 583219, 616318, 616314, 623355, 623341, 583218, 583217, 583216, 583215, 583214, 533921, 616307, 533919, 583213, 583212, 189024, 443723, 443719, 533907, 583210, 533894, 583209, 533890, 616233, 583208, 443680, 616186, 533887, 583207, 533886, 583206, 443663, 616174, 180998, 443653, 443615, 583205, 616063, 616060, 616058, 533873, 583204, 583203, 533872, 583202, 583201, 533869, 583200, 583198, 583196, 583194, 583192, 583190, 583189, 583186, 583184, 583182, 583177, 583176, 583175, 583174, 533849, 583170, 583168, 583166, 583165, 607597, 583163, 612280, 615692, 607879, 615687, 615681, 615677, 615674, 607875, 607872, 615668, 607870, 607868, 607866, 607861, 607858, 607856, 583162, 583161, 583160, 443382, 443375, 443372, 443361, 443359, 583159, 443357, 583158, 583153, 583150, 583147, 583145, 583144, 615509, 443223, 583143, 533771, 583142, 615084, 615080, 583141, 615072, 443122, 443077, 583140, 583139, 201021, 583137, 614864, 246846, 614861, 246843, 442991, 442989, 583136, 533702, 583135, 583134, 613902, 442694, 246834, 583133, 246832, 246829, 246826, 246824, 580302, 580300, 580297, 613803, 580295, 613798, 613735, 583132, 583131, 583130, 583129, 583128, 442674, 583127, 583125, 583124, 583123, 583122, 583121, 583120, 613482, 613407, 613402, 613399, 533629, 533627, 583119, 583116, 583115, 583113, 613357, 583112, 583110, 613325, 613323, 613320, 613317, 583109, 613309, 583108, 613294, 613290, 583107, 583106, 583105, 442476, 583104, 442474, 442473, 442471, 583103, 613074, 613059, 583102, 583101, 583100, 533549, 246795, 583099, 533541, 583098, 442413, 583097, 533536, 583096, 442393, 583095, 442386, 442351, 583094, 583093, 442334, 583092, 442313, 583091, 583090, 583089, 583087, 583086, 583084, 583083, 583082, 583081, 442294, 533502, 583080, 583079, 583078, 583077, 583076, 583075, 583074, 583072, 583071, 583070, 583069, 583068, 583067, 583066, 612785, 612781, 583065, 366063, 583064, 583063, 583062, 583060, 583059, 583058, 583057, 583056, 598573, 598571, 598569, 598565, 583055, 598563, 442092, 442086, 442083, 442081, 442079, 583054, 442077, 583053, 442073, 442071, 442069, 583052, 442064, 583051, 442061, 442059, 533455, 612269, 612265, 612263, 612261, 612259, 612257, 612254, 612251, 612248, 442042, 583050, 442020, 533447, 533443, 583049, 442009, 442004, 442002, 612240, 441998, 583048, 612239, 612237, 583047, 612229, 583046, 583045, 441984, 612224, 612367, 612222, 583044, 612211, 583043, 583042, 612186, 612183, 583041, 612003, 611993, 533386, 612013, 612011, 583040, 583039, 533382, 611894, 583038, 611920, 611917, 441853, 533363, 441851, 611883, 611880, 583037, 611775, 611773, 611816, 611771, 611813, 583036, 611811, 611809, 583035, 583034, 611807, 611803, 611788, 583033, 441804, 611631, 583032, 583031, 609666, 441790, 583030, 583029, 441783, 441780, 441776, 611535, 583028, 583027, 583026, 611529, 441739, 583025, 583024, 583023, 533285, 611131, 611128, 583021, 583020, 533264, 583019, 583018, 583016, 533247, 533246, 610990, 583014, 583013, 610960, 583012, 583010, 583008, 583006, 582999, 582998, 610953, 610944, 441553, 441547, 441544, 582997, 441537, 441529, 441526, 441524, 441522, 441519, 441517, 441515, 441511, 441509, 441507, 200978, 592132, 533224, 610761, 610758, 582996, 582995, 533211, 582994, 582993, 582992, 533206, 441450, 582991, 533202, 441439, 441437, 441435, 533192, 582990, 610411, 610407, 610400, 610396, 582988, 582986, 582984, 582982, 582980, 582979, 582977, 582975, 582973, 582971, 441376, 610168, 441375, 441371, 533152, 441368, 610164, 533151, 441361, 441359, 533147, 441357, 533139, 533138, 441346, 533133, 533130, 533113, 533112, 533107, 533103, 533091, 533090, 609448, 609440, 609405, 609403, 533081, 608320, 441297, 441293, 533077, 441291, 609060, 609058, 609056, 609053, 533074, 609051, 533071, 609049, 533070, 609047, 609045, 533063, 533057, 582970, 582968, 582967, 608822, 582965, 608817, 441234, 582964, 608598, 608597, 582963, 582962, 582961, 582960, 582959, 533043, 582958, 533041, 533039, 582957, 582956, 582955, 608590, 582954, 582953, 582952, 582951, 582950, 441231, 582949, 533022, 441204, 441197, 592118, 533017, 533015, 582947, 533013, 533012, 582946, 608287, 608283, 608281, 533011, 582945, 533003, 441167, 608150, 608148, 582943, 582942, 608146, 608177, 533000, 608060, 608058, 582941, 608056, 607819, 607983, 607981, 582940, 608026, 608023, 582938, 532995, 606054, 607977, 582937, 532991, 582936, 605561, 607347, 607212, 582935, 582934, 582932, 607749, 582931, 582930, 607716, 389713, 582929, 582928, 607656, 188941, 188938, 188936, 582927, 532977, 532975, 582926, 582925, 582924, 582923, 582920, 582918, 582917, 607541, 607535, 607533, 349627, 602742, 582916, 441094, 582915, 582914, 441077, 441072, 441070, 441067, 441061, 582913, 441059, 582912, 582911, 582910, 532958, 582909, 582907, 582905, 532936, 582904, 607221, 606016, 441048, 441045, 582903, 582902, 441026, 441024, 441022, 532930, 441020, 441018, 441014, 441010, 582901, 532927, 582900, 606965, 607173, 582899, 606959, 582898, 582897, 582896, 606954, 582895, 582894, 582893, 582892, 582891, 607054, 582890, 607092, 582889, 607089, 582887, 582886, 582885, 582884, 607051, 582883, 582882, 582881, 582880, 582878, 582876, 606939, 582875, 532913, 582874, 532910, 606831, 582873, 606005, 582872, 532908, 582870, 200937, 532903, 606744, 582869, 532899, 582868, 582867, 582866, 582865, 582863, 606514, 606512, 582862, 532895, 582861, 606508, 606505, 606501, 606499, 582860, 532894, 606494, 606492, 606490, 582859, 582858, 582857, 582856, 599132, 582855, 606154, 606108, 606106, 606104, 606100, 606098, 606096, 582854, 582853, 606093, 606091, 606089, 606116, 606087, 606076, 582852, 582851, 582850, 582849, 605977, 605975, 605971, 582848, 605949, 582847, 582846, 582845, 582844, 582843, 605916, 532871, 582841, 582840, 582838, 605865, 582836, 603425, 582835, 582834, 582831, 582830, 582828, 582827, 582826, 582825, 582822, 582820, 582819, 582817, 582815, 600465, 582813, 582811, 582810, 582808, 605723, 605721, 582806, 605698, 582805, 115393, 582804, 605546, 582803, 605572, 605544, 532863, 532861, 582802, 532856, 605542, 605540, 605526, 582801, 582800, 532854, 582796, 604472, 582794, 582793, 440708, 582792, 532851, 582791, 582790, 605182, 605180, 605178, 582789, 605175, 582788, 582784, 582783, 582782, 582780, 582779, 605156, 605154, 532848, 582777, 582776, 582775, 582774, 605056, 605054, 605052, 582773, 582772, 582771, 582770, 582769, 582768, 604995, 582767, 582766, 109247, 109244, 109242, 582765, 109238, 109235, 440637, 582764, 532838, 582763, 582762, 582761, 582760, 582759, 582758, 582756, 582755, 580209, 582754, 532826, 582753, 582751, 582749, 582747, 582745, 532824, 440581, 440579, 440576, 440574, 440572, 582744, 532812, 582743, 440526, 532808, 582742, 582741, 440512, 532799, 532797, 532796, 532794, 582740, 532790, 582739, 440497, 440495, 582738, 582737, 582735, 582733, 582731, 582730, 604285, 582729, 532785, 582728, 582727, 582726, 582725, 532781, 582724, 582723, 582722, 582721, 582720, 532778, 582719, 582718, 604059, 582717, 582716, 599494, 582715, 582714, 582712, 582711, 582710, 603337, 582709, 532776, 532775, 532774, 582708, 532772, 532771, 603436, 603323, 603433, 532767, 440430, 532766, 603398, 532760, 603378, 603332, 532755, 582707, 582706, 582705, 603330, 582704, 582703, 582702, 582701, 603231, 440404, 582700, 582698, 603195, 582697, 582695, 582694, 582693, 532743, 582692, 582691, 532742, 582690, 582689, 532737, 582687, 603068, 603066, 582686, 597855, 593631, 582685, 582684, 582683, 582682, 582681, 582680, 582679, 582678, 599083, 582677, 440358, 582676, 582675, 440357, 440355, 582674, 582673, 582672, 582671, 582670, 582669, 582668, 582667, 582666, 532731, 582665, 582664, 582663, 602665, 582661, 582660, 582658, 582656, 582655, 602722, 582654, 582653, 582652, 582651, 602687, 602685, 582649, 582648, 602678, 582647, 602676, 582646, 582645, 582643, 582642, 582640, 582639, 582636, 582634, 582632, 582629, 582628, 582627, 602617, 582626, 582624, 601770, 582622, 582621, 582620, 582618, 582617, 602599, 582616, 582615, 582614, 440327, 582613, 582612, 582611, 582609, 582608, 582607, 582606, 602423, 602420, 582605, 602417, 582604, 602409, 582603, 582602, 582601, 582600, 582599, 582598, 582597, 582596, 582595, 602388, 582594, 582593, 582592, 582591, 582590, 582589, 602305, 582588, 582587, 582586, 582585, 602198, 602194, 582584, 582583, 602143, 582582, 602139, 602132, 582580, 582579, 582578, 582577, 582576, 582575, 582574, 582573, 582572, 582571, 582570, 582569, 582568, 582567, 582566, 582565, 582564, 582563, 582562, 582561, 582560, 582559, 582558, 582557, 582556, 582555, 582554, 582553, 582552, 582551, 582550, 582549, 582548, 582547, 582546, 582544, 602109, 602106, 582542, 582540, 601930, 582536, 602062, 582535, 440317, 582534, 440315, 582533, 582531, 582530, 440310, 582529, 582528, 582527, 582524, 582523, 582522, 582521, 582520, 582519, 582517, 582516, 582514, 582513, 582512, 582511, 582510, 582508, 582507, 582506, 582505, 582504, 582503, 582502, 582501, 582500, 532695, 582499, 582498, 592961, 582497, 582496, 582495, 582494, 582493, 582492, 582491, 582490, 582489, 582488, 582487, 582486, 582485, 582484, 582483, 582482, 582481, 582480, 582479, 600347, 582478, 582476, 582474, 582473, 440294, 440292, 582471, 582469, 600345, 582467, 582465, 600340, 582464, 532686, 582462, 582460, 582458, 582456, 580193, 580186, 580184, 582452, 582451, 582449, 580183, 580182, 599933, 599387, 597927, 597924, 597922, 592545, 592542, 592538, 592536, 582448, 582447, 597799, 597797, 536357, 591770, 591765, 582445, 582443, 582442, 532566, 592112, 592110, 592108, 439831, 598468, 598410, 532565, 582441, 582440, 598313, 517439, 582438, 582436, 582434, 582432, 582431, 582429, 582428, 593440, 582424, 582423, 593438, 582421, 582419, 582417, 582415, 582414, 582413, 582412, 598261, 582411, 598236, 598145, 582410, 582409, 482155, 482153, 482151, 594718, 598058, 598056, 582407, 482149, 597831, 598010, 582406, 597961, 597956, 597953, 594885, 597825, 582405, 593608, 582404, 439690, 532550, 439688, 582402, 593606, 582401, 582400, 572524, 532548, 582399, 597711, 572521, 582398, 582397, 532546, 582396, 582395, 597764, 200870, 582394, 582393, 597757, 582391, 582389, 582387, 582386, 582384, 532545, 597670, 582383, 597620, 597618, 597616, 582382, 439658, 597307, 582381, 595067, 439647, 597541, 597539, 439600, 439588, 439571, 439567, 532539, 439559, 439556, 439555, 439553, 439551, 439549, 597472, 532538, 597344, 597377, 532537, 597373, 597319, 597327, 597325, 439542, 597317, 597315, 439539, 597313, 597311, 582380, 596858, 596856, 596851, 582379, 597303, 582378, 572889, 597301, 572887, 596486, 532533, 532530, 597278, 597276, 597270, 554290, 597154, 532527, 200864, 597139, 597126, 597121, 582377, 597097, 597091, 582376, 597022, 439507, 597011, 596891, 582375, 532511, 582374, 582373, 582372, 532508, 592672, 582371, 582370, 592670, 592661, 582369, 614721, 592659, 582367, 532501, 582365, 596648, 439394, 439392, 582364, 532498, 595137, 582363, 582362, 582360, 439388, 596609, 595365, 582359, 595363, 582357, 596456, 596452, 581319, 596447, 582355, 595485, 595409, 593725, 595480, 595432, 582354, 595417, 595398, 595390, 595388, 595277, 581301, 581298, 581288, 582352, 581284, 582350, 581273, 595266, 582348, 582347, 582345, 582344, 439319, 595237, 595232, 582343, 582342, 582341, 582340, 595086, 595118, 532489, 595084, 133281, 595116, 389069, 582339, 133279, 595108, 582338, 133275, 133273, 133270, 133266, 595019, 595014, 582336, 582335, 582333, 582332, 594981, 582330, 582328, 532480, 582326, 582324, 582323, 582322, 594913, 594868, 582321, 582320, 582319, 582317, 582315, 582314, 582313, 582311, 582308, 582306, 582304, 594841, 582303, 582302, 592535, 439274, 594686, 594734, 594681, 594657, 582301, 582300, 582297, 582295, 582293, 582292, 594543, 532462, 591038, 591036, 591028, 582291, 594504, 582290, 594493, 594365, 594363, 439223, 570898, 570896, 582289, 594421, 582287, 582285, 582284, 582283, 580134, 592496, 439215, 594373, 594170, 582282, 582281, 582280, 582279, 570421, 439204, 582278, 439202, 439197, 582277, 439195, 582276, 439189, 439187, 594211, 594209, 582275, 582273, 582272, 594164, 582271, 582270, 582269, 582268, 439161, 582262, 582261, 439156, 593979, 593944, 582259, 593915, 439141, 582258, 593936, 593934, 593928, 582257, 593842, 593818, 593840, 593830, 593828, 582256, 582255, 593222, 593220, 592092, 593216, 592090, 592088, 439086, 582254, 439084, 439082, 439080, 439078, 439076, 593702, 593698, 593620, 593617, 593696, 532417, 582253, 593687, 593612, 593433, 439052, 439050, 593430, 593427, 593425, 593422, 582252, 593537, 582251, 593530, 590724, 593520, 593500, 593498, 593518, 593496, 593491, 532412, 582250, 582248, 580119, 593411, 593405, 582247, 593404, 593402, 593398, 593395, 593393, 593391, 593389, 593388, 592654, 493856, 592652, 592649, 593290, 593257, 593255, 593253, 592914, 593251, 582246, 593249, 532399, 582245, 532394, 582244, 592420, 582243, 582242, 582240, 582238, 582237, 471336, 582236, 532390, 593144, 532388, 582235, 582234, 572885, 572882, 532386, 593081, 582233, 593079, 582231, 582227, 532375, 572878, 572875, 593040, 582224, 582222, 582221, 582220, 548373, 582219, 593051, 582218, 582217, 593049, 592984, 593053, 593047, 582216, 200857, 592973, 582214, 582213, 592931, 580108, 532361, 532360, 582212, 582211, 592924, 582210, 532355, 582209, 582208, 568655, 439035, 592908, 582207, 582205, 582204, 592824, 582203, 592786, 592784, 592782, 592772, 592770, 539553, 582202, 592765, 582201, 592764, 592762, 592632, 582199, 582198, 592576, 532329, 592574, 592572, 592570, 582197, 592568, 438979, 582195, 582194, 582193, 582192, 582190, 582188, 582187, 582186, 582185, 582184, 582182, 592533, 582181, 582180, 582179, 592531, 582178, 582176, 582174, 592519, 582171, 592517, 591752, 548371, 592436, 582170, 582169, 582168, 582167, 591830, 591827, 582165, 592333, 582162, 592429, 582160, 582158, 582155, 582153, 592355, 592353, 582152, 592317, 592328, 571267, 571266, 592314, 592312, 591823, 589960, 592310, 592308, 589955, 582151, 582150, 592306, 582149, 582146, 582145, 582143, 582142, 582141, 582137, 582136, 582135, 582133, 582132, 582131, 582130, 582129, 582127, 592177, 582123, 582122, 573230, 582120, 582119, 582118, 582116, 582115, 582114, 582113, 582112, 438929, 582111, 582110, 438907, 438905, 592034, 582108, 582107, 582106, 582105, 582104, 582103, 582102, 582101, 591708, 582099, 589946, 591974, 591850, 582098, 582097, 582096, 582095, 582094, 582093, 582092, 582090, 582089, 582086, 582084, 582082, 591615, 591613, 582080, 532258, 582079, 582078, 221936, 582075, 582074, 582073, 591392, 591389, 109212, 109207, 590425, 590423, 580090, 438803, 438801, 580088, 438732, 590406, 591159, 591147, 438696, 438694, 582072, 532111, 438666, 532105, 438655, 438651, 536311, 438648, 438637, 438635, 438633, 438628, 591011, 591008, 536309, 536305, 532088, 536298, 536294, 590992, 590827, 590814, 590811, 548362, 548352, 438572, 438558, 438557, 590765, 109175, 590395, 582071, 590392, 582070, 548334, 548332, 438536, 438534, 548330, 548328, 246627, 548322, 246624, 590662, 246621, 590660, 590651, 438528, 246616, 548320, 548316, 582069, 590616, 590589, 590586, 580080, 590584, 590577, 590574, 590544, 590540, 590538, 590536, 590524, 590387, 590522, 590514, 590512, 590506, 590504, 590501, 590499, 590496, 590493, 590488, 590486, 590483, 590476, 590469, 246599, 580078, 532045, 532033, 614696, 580076, 469061, 614693, 532025, 532024, 532023, 532022, 590384, 590376, 532016, 438470, 109170, 438457, 438445, 438427, 590262, 580074, 580071, 580069, 580065, 580063, 580043, 133240, 531992, 584871, 584868, 438405, 582068, 221864, 246562, 246560, 531981, 531972, 438329, 438286, 438275, 582067, 438229, 438224, 438222, 438220, 438189, 438159, 438147, 579898, 579883, 579875, 579873, 579871, 438106, 438095, 438075, 438044, 590198, 438040, 438028, 246514, 437984, 437980, 246511, 579803, 246508, 246505, 579788, 579784, 579772, 579762, 246485, 246483, 437943, 437931, 437928, 246478, 437926, 437920, 437912, 246447, 246445, 246434, 437882, 246424, 246378, 437836, 246364, 246355, 246351, 246346, 246344, 246340, 582066, 246327, 246324, 582065, 582064, 582063, 531847, 200797, 437772, 246287, 582062, 582061, 582060, 582059, 582058, 582057, 582056, 582054, 582053, 582052, 582051, 531826, 570381, 571064, 571062, 571060, 571058, 437687, 437683, 582050, 582049, 582048, 582047, 589544, 333997, 333995, 333993, 587705, 531785, 579612, 437371, 579610, 437367, 437364, 437362, 437360, 437356, 437354, 437352, 437347, 437345, 437334, 437308, 437306, 437302, 437300, 437298, 417907, 417905, 417903, 582046, 417901, 582045, 417899, 417897, 582044, 589199, 589180, 531754, 589361, 588933, 531747, 582042, 588686, 588684, 588682, 588679, 588677, 406487, 406485, 406483, 406481, 406474, 614668, 588916, 588931, 406472, 531700, 588674, 588871, 582041, 582040, 582039, 582038, 588672, 588667, 588660, 588657, 588761, 531676, 588653, 588647, 531671, 309797, 309795, 309792, 246215, 437189, 437185, 437182, 437180, 437177, 437175, 437161, 437157, 588501, 437153, 588499, 588497, 588495, 588493, 588491, 588489, 588484, 588479, 588477, 437141, 588475, 437139, 587998, 437136, 437127, 531631, 437117, 437111, 582037, 568653, 568651, 568650, 531563, 568648, 568646, 436743, 398165, 398163, 398161, 310062, 531503, 531501, 531498, 531494, 531492, 568644, 582036, 582034, 582031, 587118, 587114, 582030, 587110, 587131, 572873, 573229, 569841, 569839, 573227, 569837, 572871, 587077, 587085, 586898, 587073, 568642, 586006, 586003, 582029, 531471, 586000, 585997, 531469, 585995, 585992, 585990, 585988, 582028, 436647, 471331, 531466, 585986, 585983, 109113, 585981, 585977, 585968, 554095, 585966, 582026, 585951, 585941, 109101, 585934, 582024, 586673, 584996, 584994, 584992, 584990, 531432, 531427, 582023, 436464, 582021, 582020, 582019, 531395, 174349, 554065, 582018, 582016, 582015, 586092, 554064, 531381, 582013, 582012, 531375, 554063, 133218, 133217, 585641, 133215, 133211, 585638, 585636, 578403, 578398, 578394, 582011, 582008, 585489, 585487, 582007, 531348, 585476, 109047, 531342, 582005, 582003, 582002, 436256, 582000, 436254, 246004, 109043, 109040, 109038, 109036, 581999, 309772, 581998, 581996, 581994, 531288, 309729, 581993, 581991, 37782, 581990, 581988, 581987, 581986, 531264, 581984, 581982, 581981, 435820, 581980, 576916, 581979, 581978, 581976, 581975, 581974, 581973, 581971, 581969, 581966, 581965, 581962, 206176, 581961, 581958, 581957, 581956, 581955, 581954, 531249, 584078, 584076, 581953, 581952, 581951, 581949, 581947, 581946, 581623, 581944, 581940, 581937, 554024, 581936, 581935, 584303, 531223, 581934, 581933, 581932, 435726, 581931, 581930, 581929, 581928, 581927, 581926, 581924, 581923, 581922, 581921, 581920, 581919, 581918, 584217, 584214, 435588, 584211, 584207, 584205, 581917, 584183, 581916, 584177, 584175, 581915, 581914, 581913, 581912, 581911, 584162, 584160, 584158, 584144, 531201, 581910, 581909, 435532, 435525, 435515, 581908, 581907, 581906, 581905, 581904, 581903, 435508, 581902, 581901, 581900, 435477, 581899, 581898, 581897, 581896, 581895, 581894, 581893, 581891, 581890, 581889, 581888, 581887, 581886, 581885, 581884, 581883, 581882, 581880, 581878, 581877, 581876, 581875, 435466, 435464, 435462, 581834, 435455, 581832, 245905, 531178, 581829, 581826, 581824, 579194, 581821, 531174, 531173, 200657, 200655, 245857, 221442, 245855, 200653, 531168, 531090, 531086, 578135, 553997, 434889, 577878, 206167, 206165, 206163, 206161, 200558, 200555, 553994, 577660, 577655, 530907, 530904, 221267, 200550, 376418, 200548, 376401, 530884, 577564, 577558, 376378, 200546, 376375, 376373, 376370, 434694, 530864, 434678, 434676, 553981, 434674, 434665, 200545, 200543, 200541, 576804, 434637, 434603, 200539, 434600, 434598, 434595, 434593, 577510, 577508, 200537, 200535, 200533, 575405, 577447, 577445, 577443, 200532, 577439, 577436, 200530, 200528, 200526, 200524, 200522, 200520, 200518, 200516, 577426, 200514, 577410, 200512, 200508, 245554, 530835, 530833, 245549, 245541, 245539, 245537, 245534, 530825, 530821, 577311, 573225, 575959, 530818, 434510, 434464, 554707, 434358, 108946, 576747, 434356, 108944, 397449, 434302, 576744, 576740, 560277, 577136, 451956, 451954, 451952, 451950, 451948, 108931, 434290, 577120, 434286, 577107, 434276, 451946, 451943, 451941, 234776, 234772, 434256, 434254, 234761, 234759, 234753, 234751, 234748, 451915, 108921, 434246, 234742, 234709, 576850, 234683, 234672, 234668, 234657, 234649, 234642, 576848, 234635, 553977, 206153, 576929, 576840, 576837, 576832, 576830, 576827, 576821, 576818, 576816, 573795, 453682, 453679, 553976, 108918, 108912, 108910, 530760, 108905, 108903, 108901, 576640, 576637, 576632, 108899, 108896, 245496, 575957, 576568, 576566, 576563, 573283, 576582, 576560, 576558, 576556, 412407, 493619, 493617, 493614, 234595, 234593, 530747, 234591, 234588, 234586, 234584, 530745, 530742, 530740, 530738, 530736, 530733, 530732, 530730, 530728, 530724, 576219, 234549, 576481, 576479, 576309, 576477, 576474, 328444, 576302, 434192, 245443, 576296, 576201, 245439, 576199, 245436, 522664, 576192, 576292, 245432, 245430, 328442, 245427, 245425, 522658, 522656, 245420, 576380, 382290, 576345, 576342, 576267, 245417, 576265, 553964, 553962, 553957, 576217, 576215, 234510, 576087, 576085, 576083, 576081, 576079, 576126, 576076, 576185, 576070, 576067, 434160, 434157, 434155, 434153, 434151, 434148, 530701, 530700, 576147, 399341, 245402, 530699, 245400, 245398, 397447, 245389, 245384, 245380, 575939, 530693, 245372, 245369, 245363, 574349, 401054, 530686, 245360, 245356, 245354, 530684, 573224, 245348, 573222, 245345, 245343, 573220, 245331, 573218, 434139, 573215, 573213, 245325, 573211, 245315, 245311, 576040, 530680, 575920, 245292, 575917, 530676, 530675, 493599, 245278, 245276, 573206, 573204, 573202, 575909, 576038, 572819, 573200, 572817, 530673, 572815, 573198, 573195, 573192, 493590, 573189, 575895, 493587, 576032, 575884, 575873, 434137, 221115, 221112, 434135, 221110, 575796, 573186, 573182, 575837, 573180, 575835, 434126, 434124, 530661, 434115, 574249, 574245, 574243, 530654, 434100, 434090, 434088, 574240, 434085, 434083, 434078, 434073, 575629, 573961, 434052, 573959, 573956, 575621, 575617, 575615, 575612, 575609, 575606, 575604, 573954, 573951, 575595, 493578, 530639, 493576, 573867, 200438, 434032, 542171, 434029, 542169, 221093, 245248, 245215, 245213, 245210, 245208, 245203, 221084, 463705, 463701, 553935, 530597, 341499, 221069, 341496, 574278, 234448, 341493, 573177, 573171, 573169, 200423, 575270, 553921, 200420, 433933, 553918, 553916, 530574, 200418, 200416, 200414, 200412, 200410, 200408, 200405, 530570, 530567, 530565, 245190, 530561, 575200, 575198, 575196, 575194, 245188, 575173, 530558, 234433, 575162, 575160, 234431, 575157, 575151, 325558, 325557, 325556, 325555, 325554, 325553, 325552, 325551, 574973, 575096, 575094, 575073, 530543, 575070, 574955, 574946, 574943, 574940, 575066, 234396, 575050, 234391, 553909, 234385, 575040, 234381, 573167, 575029, 234366, 575027, 575024, 575022, 575020, 575017, 574907, 574891, 574888, 234314, 574884, 574880, 553907, 245164, 245158, 245154, 245152, 245150, 499383, 574853, 573165, 573163, 499379, 499377, 573160, 573157, 573152, 530504, 433882, 530501, 133177, 553901, 433874, 573151, 386011, 573147, 433870, 433866, 245132, 553896, 573942, 245131, 573940, 499375, 573145, 245129, 530483, 564008, 245123, 564006, 245118, 433806, 564003, 563998, 563996, 433798, 433788, 530475, 530473, 245110, 245106, 245104, 245102, 245100, 245097, 530471, 433783, 433779, 563994, 563992, 563989, 530464, 471287, 471285, 471283, 530462, 530461, 530460, 245084, 245082, 530458, 499373, 245079, 245077, 573143, 526390, 573141, 573139, 245075, 499371, 573137, 573135, 530451, 499369, 553890, 573132, 573130, 499366, 573127, 573125, 433733, 433730, 553884, 573122, 573119, 574479, 573116, 573114, 573112, 573108, 234204, 573106, 574469, 574466, 574385, 574367, 433722, 433717, 433715, 573104, 433710, 245068, 433707, 573102, 573100, 573098, 573937, 573095, 573934, 573931, 573928, 234196, 234193, 234184, 573094, 234179, 573092, 234166, 234163, 234161, 234159, 573087, 234157, 573085, 573082, 573080, 573077, 573075, 573072, 433679, 573070, 573068, 573065, 573063, 573061, 573059, 573057, 573056, 573054, 573052, 433659, 573049, 573047, 573045, 573043, 573041, 485890, 530410, 433639, 433637, 433635, 530408, 433633, 573040, 573038, 485888, 573035, 573032, 574053, 573030, 574051, 573028, 234073, 526373, 553872, 573027, 526370, 553869, 234063, 573024, 333927, 563988, 574016, 573022, 553856, 553854, 433581, 553832, 553827, 573021, 573019, 572811, 573014, 433569, 573011, 553825, 573005, 573003, 573001, 572996, 553813, 572994, 553810, 572992, 530366, 571265, 572990, 530363, 572988, 553786, 530339, 549993, 572984, 433525, 573498, 573496, 573494, 433522, 573492, 573490, 573488, 572982, 572980, 433520, 572977, 433513, 572971, 572968, 572964, 572961, 572958, 572955, 572953, 572949, 245037, 573486, 573340, 573480, 573478, 573475, 573473, 573470, 573505, 573468, 573466, 245025, 245022, 245020, 245014, 245009, 245006, 572946, 572943, 572941, 572939, 572937, 530281, 572934, 572931, 572929, 572927, 572925, 244995, 572923, 572920, 572918, 572916, 456136, 572914, 572801, 572912, 572798, 572910, 244988, 572792, 244985, 244983, 244981, 572789, 244979, 572787, 244976, 244970, 244968, 560641, 244965, 244963, 244960, 471277, 471275, 471273, 244953, 471267, 244950, 244944, 471264, 244939, 471262, 433457, 433454, 433448, 433445, 433442, 433440, 433438, 433436, 433434, 244804, 244801, 433387, 433385, 572500, 244783, 244779, 572239, 433335, 452664, 433329, 433275, 572339, 572336, 572333, 572319, 220919, 572315, 572313, 572309, 572307, 572305, 572303, 572301, 244768, 572296, 433269, 433264, 572293, 572286, 433259, 433252, 572274, 433248, 433246, 572264, 572262, 397402, 572254, 530132, 433234, 433231, 433228, 433224, 433222, 433218, 433216, 433214, 433211, 433210, 433209, 433208, 433200, 433198, 433196, 571916, 572175, 433194, 530127, 530125, 433187, 572172, 572169, 244751, 233890, 244747, 244745, 530122, 244743, 323632, 233884, 530115, 433171, 530111, 433168, 233882, 433161, 233879, 244733, 433159, 433154, 433152, 571847, 244725, 433147, 433143, 433139, 433137, 433135, 398477, 548272, 433116, 310028, 571498, 548270, 571496, 349552, 548268, 571742, 571739, 571736, 530105, 553057, 433110, 433106, 571494, 571490, 310026, 571486, 553742, 530095, 571484, 244721, 433100, 553054, 571482, 571479, 530093, 571473, 571470, 433085, 530091, 527761, 527758, 527756, 530087, 433071, 433067, 433065, 433061, 433058, 530081, 530080, 433052, 530078, 433050, 433048, 530075, 530070, 433044, 433042, 233872, 233869, 433040, 433037, 233867, 233855, 244714, 571585, 526335, 233842, 570181, 530060, 233838, 433013, 530057, 515521, 244712, 433011, 530055, 515518, 433009, 515515, 244707, 530054, 530052, 530048, 133147, 328438, 530045, 530044, 432976, 570180, 571429, 571412, 571421, 571410, 517357, 530030, 530027, 571416, 530025, 515514, 515512, 432938, 571408, 530023, 571406, 432932, 530019, 526330, 515509, 515506, 530014, 530012, 515495, 515486, 515484, 526312, 526309, 526307, 526304, 530007, 530005, 526294, 526292, 530000, 380928, 529998, 380923, 380921, 529993, 380919, 529991, 398464, 529989, 529987, 233812, 529984, 485877, 485873, 529980, 571264, 485871, 432897, 529977, 529975, 529972, 529969, 529967, 529965, 571261, 570179, 570176, 529958, 529955, 570324, 570173, 570170, 220868, 529952, 553734, 570168, 553733, 220866, 570322, 529943, 529941, 220863, 529939, 164640, 220861, 553730, 570166, 553727, 164635, 553725, 553720, 432873, 244681, 553718, 244679, 432870, 529916, 529914, 244670, 164631, 244668, 244662, 244658, 570164, 553714, 553710, 570161, 529908, 244655, 164629, 244652, 244650, 244648, 244646, 244643, 244639, 553709, 529906, 164623, 553706, 529904, 164621, 529899, 164615, 402281, 553703, 164612, 529896, 529894, 309682, 529892, 621701, 553694, 570041, 372396, 309676, 402265, 529890, 244620, 529888, 570950, 529885, 553684, 529882, 553681, 553679, 529879, 529871, 309659, 529867, 465841, 553676, 547984, 36111, 367576, 309645, 570038, 309642, 570036, 206099, 309622, 309619, 309617, 570034, 570778, 570776, 206097, 529861, 529857, 432839, 432833, 432830, 432822, 432816, 432813, 432809, 432807, 432805, 432802, 432800, 432798, 432796, 432794, 527746, 553672, 309584, 309579, 309577, 309575, 367570, 432777, 432775, 432773, 432771, 432769, 432767, 432765, 432761, 432759, 553670, 553667, 432749, 570605, 553664, 570601, 553662, 553659, 553654, 553645, 553643, 553641, 553639, 553634, 553633, 553619, 553616, 553607, 553605, 570473, 553600, 570487, 570485, 553596, 553593, 553591, 553587, 553582, 570483, 432729, 570469, 432721, 432708, 569652, 569650, 553572, 220768, 569643, 569640, 220764, 220761, 220759, 569638, 432697, 569634, 569629, 501834, 501832, 328436, 220739, 569620, 569613, 569610, 569608, 569605, 220730, 569603, 220728, 569601, 220726, 569599, 220716, 220714, 220712, 569596, 547182, 328434, 408804, 547180, 547176, 569068, 547173, 471259, 547169, 547168, 547165, 547163, 547161, 220693, 220692, 220690, 471257, 471254, 471250, 471244, 432661, 220677, 432656, 471234, 471230, 471227, 432648, 432644, 432640, 570120))
Run Time: 0.183464
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 5724 | |
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 | | | | | 5724 | |
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 (35528, 35490, 34969, 34734, 34581, 34248, 34184, 33894, 33402, 33273, 32521, 32314, 31398, 31382, 31141, 31106, 30610, 30489, 30368, 30056, 29959, 29938, 29919))
Run Time: 0.001817
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 23 | 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 (646182, 646176, 646145, 646135, 646105, 646103, 646100, 646093, 646089, 646045, 646042, 646037, 646007, 646002, 645995, 645987, 645977, 645976, 645975, 645910, 645896, 645894, 645881, 645866, 645860, 645805, 645733, 645717, 645714, 645712, 645678, 645631, 645588, 645518, 645509, 645504, 645469, 645399, 645391, 645383, 645341, 645301, 645297, 645295, 645144, 645102, 644701, 644624, 644383, 644195, 644185, 643982, 643938, 643928, 643927, 643925, 643923, 643843, 643828, 643684, 643593, 643556, 643534, 643530, 643506, 643497, 643481, 643462, 643461, 642889, 642883, 642851, 642786, 642761, 642656, 642654, 642652, 642552, 642551, 642536, 642529, 642495, 642487, 642482, 642480, 642479, 642471, 642469, 642442, 642416, 642404, 642402, 642397, 642391, 642384, 642361, 642225, 642195, 642181, 642121, 642085, 642083, 642022, 642019, 641997, 641843, 641842, 641829, 641825, 641816, 641780, 641713, 641710, 641359, 641336, 641333, 641328, 641290, 641289, 641276, 641256, 641226, 641214, 641210, 641180, 641177, 641097, 641021, 641013, 641007, 640949, 640943, 640941, 640900, 640897, 640895, 640864, 640832, 640831, 640829, 640819, 640593, 640784, 640761, 640753, 640690, 640688, 447740, 447737, 639739, 640685, 640682, 640680, 640670, 640666, 584009, 584008, 640653, 584007, 640647, 584004, 584003, 640589, 640587, 584002, 640577, 580761, 640575, 584000, 534941, 417939, 640496, 583999, 583998, 583997, 583996, 583993, 109264, 109262, 109260, 583992, 583990, 639994, 639992, 583988, 583986, 640472, 447595, 447590, 447588, 640445, 583984, 583983, 627578, 583981, 627574, 627573, 627572, 627566, 627565, 627563, 627561, 627559, 627558, 627556, 627554, 583980, 583979, 640333, 583978, 640214, 640211, 640209, 640207, 640271, 640228, 640224, 632844, 632842, 640188, 637061, 639695, 632222, 637059, 583977, 640118, 447534, 447526, 640096, 640094, 640092, 583976, 640090, 640088, 583975, 583974, 640031, 447523, 640147, 640078, 639522, 640137, 583972, 453832, 640135, 534924, 639514, 639692, 639511, 639509, 639507, 639505, 583971, 447488, 447485, 447483, 447476, 447474, 447468, 539593, 539590, 640034, 640028, 447466, 447462, 539586, 539582, 447459, 447455, 447444, 447440, 447438, 639683, 447436, 447429, 447402, 447400, 447398, 447392, 627550, 583970, 601759, 639677, 583969, 639763, 639759, 639752, 639750, 627549, 627547, 639440, 639436, 627542, 627541, 491360, 447331, 447327, 639427, 639421, 636081, 636077, 639490, 447304, 447302, 447299, 583968, 636071, 534895, 534893, 583967, 639098, 639096, 637442, 583966, 583965, 637438, 637436, 637434, 638584, 638138, 583964, 534889, 639339, 639336, 583963, 583962, 639086, 639075, 639073, 639071, 639064, 447248, 447245, 639057, 583961, 639230, 639055, 639226, 638710, 638707, 639053, 447234, 583960, 447231, 447225, 447223, 447214, 583958, 583957, 638581, 639220, 639215, 634143, 634140, 639214, 583956, 583955, 639164, 639033, 639031, 639029, 447207, 447202, 639197, 447200, 447195, 447188, 639136, 639028, 447185, 583954, 639185, 447174, 447172, 447170, 447167, 534884, 534883, 447163, 447161, 447159, 534882, 639170, 639113, 639021, 583953, 639019, 347180, 347177, 347174, 583952, 447141, 201204, 583951, 534875, 583950, 447130, 447120, 583949, 583947, 583944, 583943, 638902, 638900, 583941, 554448, 583939, 638831, 638829, 447096, 638827, 638824, 638763, 534870, 534868, 636624, 636622, 636620, 583938, 583937, 447094, 447092, 447090, 638615, 583936, 534862, 534861, 638573, 583934, 447084, 447082, 362818, 362815, 583933, 583932, 638496, 638494, 583931, 534855, 534854, 583929, 534853, 638491, 638489, 638545, 534850, 580707, 580705, 580699, 580695, 583928, 453824, 638531, 638529, 534849, 534848, 583927, 583926, 583925, 638518, 583924, 447075, 447072, 447067, 447065, 447062, 583923, 447056, 534844, 583922, 447049, 638405, 572556, 583921, 638396, 447045, 572550, 638393, 447043, 572546, 447040, 583920, 534842, 638390, 583919, 447036, 447033, 638383, 638381, 638379, 447031, 583918, 447027, 583916, 447024, 534841, 133358, 638365, 133356, 583915, 638361, 638351, 583913, 638348, 638340, 583910, 583909, 447005, 583908, 638326, 583907, 638267, 583906, 583905, 583902, 583901, 638265, 583899, 446986, 638244, 583898, 583897, 583896, 583895, 612893, 633935, 638241, 633928, 633924, 583894, 583892, 638163, 534828, 638130, 446978, 638128, 446976, 638222, 583889, 583887, 583885, 446974, 446972, 638084, 638197, 446947, 554447, 583884, 583882, 554446, 583881, 629985, 247270, 583879, 583878, 247268, 583876, 583874, 583873, 636896, 638150, 638111, 638109, 534822, 638107, 534820, 583872, 638069, 638067, 534817, 638019, 583871, 583870, 534816, 601235, 534814, 446941, 638050, 583869, 638036, 638033, 583868, 583866, 583864, 583862, 583861, 638028, 583858, 583856, 638000, 637997, 583853, 583852, 637969, 637951, 637967, 446937, 583851, 583849, 637883, 446935, 637943, 637881, 637941, 637939, 534807, 635035, 580677, 583847, 637874, 637872, 637870, 583846, 637919, 446930, 637918, 534803, 637916, 446923, 565483, 637865, 637863, 637861, 637858, 534802, 534799, 637857, 637900, 637896, 637894, 637892, 637856, 583845, 637887, 565480, 637853, 565477, 623333, 637488, 583844, 446909, 446907, 637482, 583842, 637480, 637763, 565475, 637746, 565473, 583839, 565465, 565463, 583838, 534796, 637622, 637619, 637617, 637613, 534788, 534787, 583837, 637655, 583835, 446874, 583834, 583832, 446869, 446865, 637582, 583831, 583829, 583828, 534780, 637451, 637449, 637447, 637445, 583826, 583824, 583823, 534774, 534773, 583822, 534771, 583821, 583820, 446782, 446775, 583819, 583818, 446765, 446763, 583817, 583815, 534766, 607954, 583813, 607952, 583811, 583810, 583809, 637130, 334014, 334011, 583808, 637128, 201192, 534757, 583807, 637091, 637070, 637089, 637048, 637046, 637044, 637042, 637087, 637041, 637040, 637037, 637034, 583806, 534748, 636244, 446722, 636981, 583805, 636918, 583804, 636844, 583803, 636833, 583802, 583800, 309842, 309840, 446716, 534745, 583799, 583798, 446715, 628599, 628598, 628596, 583797, 628591, 628588, 628586, 446713, 446711, 446707, 583795, 583794, 583793, 583792, 630259, 583791, 446696, 446695, 446692, 446691, 446689, 583790, 583788, 583786, 446641, 583784, 583783, 636425, 636419, 569071, 583782, 636389, 583781, 636387, 583780, 534725, 636350, 583779, 583778, 583776, 583775, 534721, 636332, 446624, 446619, 534720, 583774, 636303, 636271, 201189, 583772, 606402, 636265, 636263, 606400, 606399, 606397, 446584, 446579, 446578, 446575, 583771, 636251, 583770, 534718, 446537, 534714, 583769, 446535, 247239, 583768, 247236, 247233, 583767, 534712, 636164, 446510, 446505, 446500, 636113, 636098, 446497, 446493, 635996, 583766, 635994, 601789, 635992, 534702, 583765, 583764, 247213, 247205, 583763, 636085, 623644, 633510, 583762, 583761, 583760, 636046, 583758, 583757, 583755, 636036, 583753, 583752, 636025, 583751, 534697, 583750, 583748, 583747, 583746, 583744, 601188, 583743, 534692, 630232, 446467, 583742, 635770, 632231, 534689, 635847, 583741, 583740, 635841, 635839, 635830, 446447, 635820, 583739, 446444, 446441, 446439, 583738, 583737, 535651, 635732, 535649, 623643, 446420, 583736, 583735, 583734, 534675, 583733, 583732, 583730, 610304, 583729, 635534, 534672, 635525, 635461, 635508, 583728, 201184, 583726, 635345, 635342, 635340, 635338, 635336, 534666, 634133, 635330, 534665, 446408, 635325, 446400, 629958, 634131, 446397, 446395, 635268, 446393, 604364, 635254, 446391, 446386, 446384, 635237, 446382, 446379, 446377, 446374, 446373, 446370, 446364, 201183, 635077, 635006, 635004, 635000, 634995, 534654, 583725, 583724, 634917, 634915, 634913, 583723, 583722, 534651, 609320, 583721, 583720, 583719, 583718, 583717, 583714, 583713, 583711, 583710, 590143, 583709, 583708, 583707, 634717, 634749, 634715, 583706, 634713, 634712, 583705, 634559, 583704, 583703, 583702, 446300, 634505, 634500, 583701, 605423, 583700, 583699, 634231, 634234, 634225, 634193, 446257, 583698, 634091, 583697, 634088, 634085, 583696, 534606, 634082, 634080, 628264, 634078, 634075, 201176, 634070, 632568, 634109, 634053, 602485, 634051, 602483, 634108, 628262, 628260, 602480, 632563, 583695, 623641, 583694, 633066, 605264, 605263, 605261, 605260, 605258, 605256, 605254, 605252, 605250, 605248, 605246, 605244, 605242, 605240, 605238, 623640, 583693, 583692, 605236, 605235, 605234, 605232, 605230, 583691, 583690, 633603, 583689, 583688, 583687, 446221, 534594, 446217, 446215, 446213, 583686, 583685, 583684, 633881, 515524, 446203, 446201, 534593, 583683, 583682, 583681, 633534, 534589, 623639, 534587, 583680, 633514, 633512, 633509, 633508, 534586, 632919, 583678, 583677, 633869, 583676, 583675, 633231, 583674, 633229, 633439, 633227, 536408, 629924, 629921, 583673, 583672, 583671, 583670, 623635, 633292, 633291, 583669, 623634, 583668, 583667, 583666, 583665, 534572, 534569, 583664, 534564, 583663, 583661, 583659, 583658, 633163, 534559, 583657, 583656, 583654, 583653, 446122, 583652, 631986, 631984, 583651, 583650, 633060, 446115, 446113, 633058, 446108, 583649, 633051, 633046, 583648, 534538, 583647, 632978, 632975, 583646, 632839, 631911, 608480, 608477, 632837, 583645, 446065, 446061, 247158, 583644, 446048, 446045, 446038, 534531, 446035, 189126, 632895, 583643, 446031, 446012, 583642, 446010, 583641, 583640, 534526, 446001, 625687, 445999, 632847, 445997, 445995, 534524, 632825, 632819, 632817, 632815, 632812, 632809, 247144, 247140, 247136, 534518, 445991, 583639, 445982, 583637, 583632, 583628, 583627, 625686, 583625, 583624, 631623, 631621, 583622, 631613, 631610, 583621, 583619, 583617, 631608, 631605, 583615, 583612, 631600, 631596, 631594, 631593, 631589, 631587, 631585, 631583, 583611, 632640, 627253, 632637, 445963, 445960, 445958, 583610, 631573, 631570, 631567, 631565, 631562, 631552, 631547, 632454, 583609, 583608, 325224, 325221, 325219, 583607, 534498, 445948, 631212, 632368, 583606, 583605, 631209, 534495, 632404, 632402, 632306, 583604, 632303, 632319, 632301, 632275, 632273, 632271, 445937, 445935, 583602, 445933, 534494, 583601, 632121, 247110, 583600, 583599, 583598, 583597, 632107, 534493, 534492, 580606, 580604, 583596, 583595, 632093, 445921, 583594, 583592, 583591, 632027, 632073, 445919, 583590, 583589, 445914, 445913, 445910, 445907, 445904, 445902, 445898, 445895, 445893, 632014, 445891, 445888, 445883, 445879, 632001, 632007, 583588, 632005, 445873, 445871, 445868, 445866, 445863, 445860, 445858, 445856, 445854, 631976, 631879, 583587, 583586, 631943, 631891, 631941, 583585, 631869, 445828, 631867, 631279, 631277, 583584, 445814, 631274, 631272, 445805, 631538, 631536, 631835, 631802, 583583, 631533, 583582, 583580, 583578, 583576, 583572, 534482, 583571, 583570, 631798, 631525, 631523, 583569, 631521, 445802, 631519, 631516, 583568, 631514, 583566, 583564, 583563, 534478, 583562, 631737, 631507, 583561, 631478, 631476, 631474, 583560, 631711, 631726, 583559, 583558, 631465, 631693, 445764, 631454, 631451, 583557, 631427, 631418, 631416, 631413, 631404, 583556, 631401, 631396, 631392, 631390, 631665, 580568, 631388, 631380, 583555, 583554, 631378, 631376, 631374, 631372, 583553, 631357, 631353, 631350, 445749, 631348, 445747, 631651, 631649, 445744, 445736, 445734, 631647, 445725, 445722, 445720, 445717, 534467, 583552, 445713, 445711, 583551, 631342, 627100, 627098, 583550, 445702, 445699, 445698, 583549, 445691, 445687, 445685, 445676, 445670, 583548, 445668, 445666, 445664, 445657, 445655, 583547, 583546, 631251, 631232, 583544, 583543, 414287, 583542, 583540, 583539, 392476, 631190, 631180, 631178, 631174, 609955, 609953, 631135, 583538, 631129, 631123, 583537, 631121, 331430, 631114, 631110, 331428, 583536, 583535, 583534, 331423, 331420, 331418, 331416, 331414, 331408, 331406, 331404, 631081, 631075, 583533, 631059, 589998, 445642, 445635, 445633, 445631, 583532, 445629, 583531, 627165, 627159, 627153, 534455, 627146, 627144, 627142, 627140, 627134, 583530, 583529, 607469, 607467, 607465, 534453, 607445, 583528, 583526, 630666, 583524, 583522, 534447, 630821, 630819, 630817, 583521, 583520, 583519, 583518, 583517, 583516, 583515, 629303, 583514, 583513, 583512, 583511, 583509, 630591, 534433, 534427, 583508, 534425, 583507, 583505, 583503, 583502, 630538, 630533, 630357, 453790, 630355, 534424, 583501, 630439, 630436, 630434, 583500, 625389, 630412, 624168, 630354, 630353, 625386, 630342, 628073, 534415, 445500, 445498, 445495, 445493, 445489, 445484, 445482, 445478, 445474, 583499, 630077, 630061, 534404, 629861, 247070, 629855, 583498, 628310, 628309, 629629, 629821, 247066, 247063, 247058, 247056, 445445, 445443, 445441, 445439, 445437, 445435, 445433, 445431, 445429, 445407, 551781, 629635, 629633, 583497, 324055, 583496, 583495, 583494, 628615, 629226, 534349, 583493, 629204, 583492, 629181, 583490, 534342, 583489, 583488, 534336, 628878, 534332, 583487, 354536, 623825, 583486, 629049, 583484, 583483, 583482, 247013, 583481, 580462, 247011, 247008, 580460, 580458, 583480, 580456, 629018, 583479, 628954, 628949, 583477, 201128, 201127, 201125, 583476, 583474, 583473, 201123, 201122, 201120, 628912, 201115, 201113, 583472, 583471, 201110, 583470, 624132, 583469, 583467, 583466, 201106, 201104, 583465, 201103, 583463, 628573, 534325, 624129, 583462, 628831, 628848, 628833, 534322, 583459, 534319, 628555, 628770, 628766, 628764, 628763, 201094, 628761, 628534, 583458, 628531, 628469, 583457, 628455, 628450, 445252, 445234, 445229, 583455, 583453, 628295, 583452, 583451, 628215, 583450, 445150, 628063, 583449, 445141, 445136, 627965, 627962, 583448, 627634, 445052, 445041, 445039, 583447, 627589, 627622, 583446, 583444, 583443, 583442, 583441, 583440, 534294, 583439, 583438, 583437, 583436, 627132, 583435, 583434, 583433, 445005, 534292, 583432, 583430, 189080, 445002, 627344, 627276, 444998, 583429, 583428, 583427, 444987, 627118, 627116, 627113, 444977, 444975, 627129, 627111, 583426, 627108, 583425, 583423, 583422, 627038, 627036, 627047, 626892, 623628, 626890, 583421, 602826, 444942, 583420, 627003, 583419, 583417, 444937, 626945, 583416, 626914, 583415, 583414, 534286, 534285, 444935, 626898, 583413, 583412, 583411, 444930, 444928, 444924, 444922, 534284, 444917, 444914, 626797, 583409, 583408, 626663, 583407, 583406, 626790, 626641, 444906, 444903, 246992, 246990, 246988, 246986, 583405, 583404, 626633, 444884, 583403, 626639, 626731, 626638, 583402, 605451, 583401, 583400, 583399, 583398, 583397, 626587, 626564, 583396, 583395, 583394, 583393, 583392, 201076, 583391, 626455, 583389, 583387, 626443, 444873, 583385, 583384, 583383, 444864, 607924, 626388, 444851, 583382, 583381, 444841, 583380, 444823, 444819, 626349, 444817, 626343, 201072, 109254, 583379, 583378, 444766, 583376, 583375, 623625, 583374, 626237, 583373, 583372, 391981, 246980, 583371, 246977, 583370, 246974, 583369, 583368, 626110, 626067, 396529, 583367, 626084, 625565, 625563, 625560, 583366, 583365, 583364, 625556, 625549, 625546, 583363, 583362, 625966, 583361, 583360, 625941, 583359, 583358, 534245, 583357, 583356, 583354, 534232, 625836, 534230, 625805, 583353, 583352, 583349, 583347, 444623, 625191, 444619, 444615, 444613, 444611, 444607, 444521, 444518, 583345, 625702, 444508, 444503, 583344, 444468, 583343, 246953, 583342, 583340, 583339, 583338, 625487, 583336, 625485, 583333, 583332, 583331, 534203, 583328, 583327, 583326, 583325, 625407, 623610, 625403, 583324, 625310, 625309, 625307, 625300, 444399, 444388, 444386, 583323, 625253, 583321, 583320, 534172, 534170, 201063, 625247, 583319, 625218, 625187, 583318, 583317, 583316, 583313, 583312, 583311, 583310, 583307, 583306, 583302, 583299, 583297, 583296, 583294, 583292, 583290, 583287, 583285, 583281, 583278, 534130, 583277, 583276, 534115, 534114, 583275, 583274, 534111, 583273, 534104, 583272, 624306, 534094, 583270, 583266, 583265, 534064, 583264, 583263, 583262, 583260, 444127, 583259, 583258, 246926, 583257, 583256, 583253, 246920, 246918, 623963, 444081, 623961, 623958, 444075, 583252, 623952, 583251, 583250, 583249, 583247, 623909, 623907, 623904, 583244, 444050, 583243, 444036, 444034, 444028, 624101, 444026, 444022, 623805, 444018, 444013, 595282, 595280, 583241, 583239, 583238, 443994, 443984, 615003, 443945, 443939, 623790, 583237, 583236, 533974, 623754, 623597, 623596, 623593, 608010, 623711, 623699, 583235, 533960, 571273, 571271, 571269, 583234, 443873, 583233, 608008, 608006, 583232, 443867, 443855, 443852, 443847, 443845, 443843, 443836, 583231, 583230, 583228, 533952, 443832, 443827, 533948, 573235, 573233, 443809, 573231, 443807, 443805, 443789, 443787, 443782, 443780, 443778, 443776, 443774, 608004, 608002, 583226, 623399, 583225, 583224, 583223, 623345, 608000, 583222, 583221, 583219, 616318, 616314, 623355, 623341, 583218, 583217, 583216, 583215, 583214, 533921, 616307, 533919, 583213, 583212, 189024, 443723, 443719, 533907, 583210, 533894, 583209, 533890, 616233, 583208, 443680, 616186, 533887, 583207, 533886, 583206, 443663, 616174, 180998, 443653, 443615, 583205, 616063, 616060, 616058, 533873, 583204, 583203, 533872, 583202, 583201, 533869, 583200, 583198, 583196, 583194, 583192, 583190, 583189, 583186, 583184, 583182, 583177, 583176, 583175, 583174, 533849, 583170, 583168, 583166, 583165, 607597, 583163, 612280, 615692, 607879, 615687, 615681, 615677, 615674, 607875, 607872, 615668, 607870, 607868, 607866, 607861, 607858, 607856, 583162, 583161, 583160, 443382, 443375, 443372, 443361, 443359, 583159, 443357, 583158, 583153, 583150, 583147, 583145, 583144, 615509, 443223, 583143, 533771, 583142, 615084, 615080, 583141, 615072, 443122, 443077, 583140, 583139, 201021, 583137, 614864, 246846, 614861, 246843, 442991, 442989, 583136, 533702, 583135, 583134, 613902, 442694, 246834, 583133, 246832, 246829, 246826, 246824, 580302, 580300, 580297, 613803, 580295, 613798, 613735, 583132, 583131, 583130, 583129, 583128, 442674, 583127, 583125, 583124, 583123, 583122, 583121, 583120, 613482, 613407, 613402, 613399, 533629, 533627, 583119, 583116, 583115, 583113, 613357, 583112, 583110, 613325, 613323, 613320, 613317, 583109, 613309, 583108, 613294, 613290, 583107, 583106, 583105, 442476, 583104, 442474, 442473, 442471, 583103, 613074, 613059, 583102, 583101, 583100, 533549, 246795, 583099, 533541, 583098, 442413, 583097, 533536, 583096, 442393, 583095, 442386, 442351, 583094, 583093, 442334, 583092, 442313, 583091, 583090, 583089, 583087, 583086, 583084, 583083, 583082, 583081, 442294, 533502, 583080, 583079, 583078, 583077, 583076, 583075, 583074, 583072, 583071, 583070, 583069, 583068, 583067, 583066, 612785, 612781, 583065, 366063, 583064, 583063, 583062, 583060, 583059, 583058, 583057, 583056, 598573, 598571, 598569, 598565, 583055, 598563, 442092, 442086, 442083, 442081, 442079, 583054, 442077, 583053, 442073, 442071, 442069, 583052, 442064, 583051, 442061, 442059, 533455, 612269, 612265, 612263, 612261, 612259, 612257, 612254, 612251, 612248, 442042, 583050, 442020, 533447, 533443, 583049, 442009, 442004, 442002, 612240, 441998, 583048, 612239, 612237, 583047, 612229, 583046, 583045, 441984, 612224, 612367, 612222, 583044, 612211, 583043, 583042, 612186, 612183, 583041, 612003, 611993, 533386, 612013, 612011, 583040, 583039, 533382, 611894, 583038, 611920, 611917, 441853, 533363, 441851, 611883, 611880, 583037, 611775, 611773, 611816, 611771, 611813, 583036, 611811, 611809, 583035, 583034, 611807, 611803, 611788, 583033, 441804, 611631, 583032, 583031, 609666, 441790, 583030, 583029, 441783, 441780, 441776, 611535, 583028, 583027, 583026, 611529, 441739, 583025, 583024, 583023, 533285, 611131, 611128, 583021, 583020, 533264, 583019, 583018, 583016, 533247, 533246, 610990, 583014, 583013, 610960, 583012, 583010, 583008, 583006, 582999, 582998, 610953, 610944, 441553, 441547, 441544, 582997, 441537, 441529, 441526, 441524, 441522, 441519, 441517, 441515, 441511, 441509, 441507, 200978, 592132, 533224, 610761, 610758, 582996, 582995, 533211, 582994, 582993, 582992, 533206, 441450, 582991, 533202, 441439, 441437, 441435, 533192, 582990, 610411, 610407, 610400, 610396, 582988, 582986, 582984, 582982, 582980, 582979, 582977, 582975, 582973, 582971, 441376, 610168, 441375, 441371, 533152, 441368, 610164, 533151, 441361, 441359, 533147, 441357, 533139, 533138, 441346, 533133, 533130, 533113, 533112, 533107, 533103, 533091, 533090, 609448, 609440, 609405, 609403, 533081, 608320, 441297, 441293, 533077, 441291, 609060, 609058, 609056, 609053, 533074, 609051, 533071, 609049, 533070, 609047, 609045, 533063, 533057, 582970, 582968, 582967, 608822, 582965, 608817, 441234, 582964, 608598, 608597, 582963, 582962, 582961, 582960, 582959, 533043, 582958, 533041, 533039, 582957, 582956, 582955, 608590, 582954, 582953, 582952, 582951, 582950, 441231, 582949, 533022, 441204, 441197, 592118, 533017, 533015, 582947, 533013, 533012, 582946, 608287, 608283, 608281, 533011, 582945, 533003, 441167, 608150, 608148, 582943, 582942, 608146, 608177, 533000, 608060, 608058, 582941, 608056, 607819, 607983, 607981, 582940, 608026, 608023, 582938, 532995, 606054, 607977, 582937, 532991, 582936, 605561, 607347, 607212, 582935, 582934, 582932, 607749, 582931, 582930, 607716, 389713, 582929, 582928, 607656, 188941, 188938, 188936, 582927, 532977, 532975, 582926, 582925, 582924, 582923, 582920, 582918, 582917, 607541, 607535, 607533, 349627, 602742, 582916, 441094, 582915, 582914, 441077, 441072, 441070, 441067, 441061, 582913, 441059, 582912, 582911, 582910, 532958, 582909, 582907, 582905, 532936, 582904, 607221, 606016, 441048, 441045, 582903, 582902, 441026, 441024, 441022, 532930, 441020, 441018, 441014, 441010, 582901, 532927, 582900, 606965, 607173, 582899, 606959, 582898, 582897, 582896, 606954, 582895, 582894, 582893, 582892, 582891, 607054, 582890, 607092, 582889, 607089, 582887, 582886, 582885, 582884, 607051, 582883, 582882, 582881, 582880, 582878, 582876, 606939, 582875, 532913, 582874, 532910, 606831, 582873, 606005, 582872, 532908, 582870, 200937, 532903, 606744, 582869, 532899, 582868, 582867, 582866, 582865, 582863, 606514, 606512, 582862, 532895, 582861, 606508, 606505, 606501, 606499, 582860, 532894, 606494, 606492, 606490, 582859, 582858, 582857, 582856, 599132, 582855, 606154, 606108, 606106, 606104, 606100, 606098, 606096, 582854, 582853, 606093, 606091, 606089, 606116, 606087, 606076, 582852, 582851, 582850, 582849, 605977, 605975, 605971, 582848, 605949, 582847, 582846, 582845, 582844, 582843, 605916, 532871, 582841, 582840, 582838, 605865, 582836, 603425, 582835, 582834, 582831, 582830, 582828, 582827, 582826, 582825, 582822, 582820, 582819, 582817, 582815, 600465, 582813, 582811, 582810, 582808, 605723, 605721, 582806, 605698, 582805, 115393, 582804, 605546, 582803, 605572, 605544, 532863, 532861, 582802, 532856, 605542, 605540, 605526, 582801, 582800, 532854, 582796, 604472, 582794, 582793, 440708, 582792, 532851, 582791, 582790, 605182, 605180, 605178, 582789, 605175, 582788, 582784, 582783, 582782, 582780, 582779, 605156, 605154, 532848, 582777, 582776, 582775, 582774, 605056, 605054, 605052, 582773, 582772, 582771, 582770, 582769, 582768, 604995, 582767, 582766, 109247, 109244, 109242, 582765, 109238, 109235, 440637, 582764, 532838, 582763, 582762, 582761, 582760, 582759, 582758, 582756, 582755, 580209, 582754, 532826, 582753, 582751, 582749, 582747, 582745, 532824, 440581, 440579, 440576, 440574, 440572, 582744, 532812, 582743, 440526, 532808, 582742, 582741, 440512, 532799, 532797, 532796, 532794, 582740, 532790, 582739, 440497, 440495, 582738, 582737, 582735, 582733, 582731, 582730, 604285, 582729, 532785, 582728, 582727, 582726, 582725, 532781, 582724, 582723, 582722, 582721, 582720, 532778, 582719, 582718, 604059, 582717, 582716, 599494, 582715, 582714, 582712, 582711, 582710, 603337, 582709, 532776, 532775, 532774, 582708, 532772, 532771, 603436, 603323, 603433, 532767, 440430, 532766, 603398, 532760, 603378, 603332, 532755, 582707, 582706, 582705, 603330, 582704, 582703, 582702, 582701, 603231, 440404, 582700, 582698, 603195, 582697, 582695, 582694, 582693, 532743, 582692, 582691, 532742, 582690, 582689, 532737, 582687, 603068, 603066, 582686, 597855, 593631, 582685, 582684, 582683, 582682, 582681, 582680, 582679, 582678, 599083, 582677, 440358, 582676, 582675, 440357, 440355, 582674, 582673, 582672, 582671, 582670, 582669, 582668, 582667, 582666, 532731, 582665, 582664, 582663, 602665, 582661, 582660, 582658, 582656, 582655, 602722, 582654, 582653, 582652, 582651, 602687, 602685, 582649, 582648, 602678, 582647, 602676, 582646, 582645, 582643, 582642, 582640, 582639, 582636, 582634, 582632, 582629, 582628, 582627, 602617, 582626, 582624, 601770, 582622, 582621, 582620, 582618, 582617, 602599, 582616, 582615, 582614, 440327, 582613, 582612, 582611, 582609, 582608, 582607, 582606, 602423, 602420, 582605, 602417, 582604, 602409, 582603, 582602, 582601, 582600, 582599, 582598, 582597, 582596, 582595, 602388, 582594, 582593, 582592, 582591, 582590, 582589, 602305, 582588, 582587, 582586, 582585, 602198, 602194, 582584, 582583, 602143, 582582, 602139, 602132, 582580, 582579, 582578, 582577, 582576, 582575, 582574, 582573, 582572, 582571, 582570, 582569, 582568, 582567, 582566, 582565, 582564, 582563, 582562, 582561, 582560, 582559, 582558, 582557, 582556, 582555, 582554, 582553, 582552, 582551, 582550, 582549, 582548, 582547, 582546, 582544, 602109, 602106, 582542, 582540, 601930, 582536, 602062, 582535, 440317, 582534, 440315, 582533, 582531, 582530, 440310, 582529, 582528, 582527, 582524, 582523, 582522, 582521, 582520, 582519, 582517, 582516, 582514, 582513, 582512, 582511, 582510, 582508, 582507, 582506, 582505, 582504, 582503, 582502, 582501, 582500, 532695, 582499, 582498, 592961, 582497, 582496, 582495, 582494, 582493, 582492, 582491, 582490, 582489, 582488, 582487, 582486, 582485, 582484, 582483, 582482, 582481, 582480, 582479, 600347, 582478, 582476, 582474, 582473, 440294, 440292, 582471, 582469, 600345, 582467, 582465, 600340, 582464, 532686, 582462, 582460, 582458, 582456, 580193, 580186, 580184, 582452, 582451, 582449, 580183, 580182, 599933, 599387, 597927, 597924, 597922, 592545, 592542, 592538, 592536, 582448, 582447, 597799, 597797, 536357, 591770, 591765, 582445, 582443, 582442, 532566, 592112, 592110, 592108, 439831, 598468, 598410, 532565, 582441, 582440, 598313, 517439, 582438, 582436, 582434, 582432, 582431, 582429, 582428, 593440, 582424, 582423, 593438, 582421, 582419, 582417, 582415, 582414, 582413, 582412, 598261, 582411, 598236, 598145, 582410, 582409, 482155, 482153, 482151, 594718, 598058, 598056, 582407, 482149, 597831, 598010, 582406, 597961, 597956, 597953, 594885, 597825, 582405, 593608, 582404, 439690, 532550, 439688, 582402, 593606, 582401, 582400, 572524, 532548, 582399, 597711, 572521, 582398, 582397, 532546, 582396, 582395, 597764, 200870, 582394, 582393, 597757, 582391, 582389, 582387, 582386, 582384, 532545, 597670, 582383, 597620, 597618, 597616, 582382, 439658, 597307, 582381, 595067, 439647, 597541, 597539, 439600, 439588, 439571, 439567, 532539, 439559, 439556, 439555, 439553, 439551, 439549, 597472, 532538, 597344, 597377, 532537, 597373, 597319, 597327, 597325, 439542, 597317, 597315, 439539, 597313, 597311, 582380, 596858, 596856, 596851, 582379, 597303, 582378, 572889, 597301, 572887, 596486, 532533, 532530, 597278, 597276, 597270, 554290, 597154, 532527, 200864, 597139, 597126, 597121, 582377, 597097, 597091, 582376, 597022, 439507, 597011, 596891, 582375, 532511, 582374, 582373, 582372, 532508, 592672, 582371, 582370, 592670, 592661, 582369, 614721, 592659, 582367, 532501, 582365, 596648, 439394, 439392, 582364, 532498, 595137, 582363, 582362, 582360, 439388, 596609, 595365, 582359, 595363, 582357, 596456, 596452, 581319, 596447, 582355, 595485, 595409, 593725, 595480, 595432, 582354, 595417, 595398, 595390, 595388, 595277, 581301, 581298, 581288, 582352, 581284, 582350, 581273, 595266, 582348, 582347, 582345, 582344, 439319, 595237, 595232, 582343, 582342, 582341, 582340, 595086, 595118, 532489, 595084, 133281, 595116, 389069, 582339, 133279, 595108, 582338, 133275, 133273, 133270, 133266, 595019, 595014, 582336, 582335, 582333, 582332, 594981, 582330, 582328, 532480, 582326, 582324, 582323, 582322, 594913, 594868, 582321, 582320, 582319, 582317, 582315, 582314, 582313, 582311, 582308, 582306, 582304, 594841, 582303, 582302, 592535, 439274, 594686, 594734, 594681, 594657, 582301, 582300, 582297, 582295, 582293, 582292, 594543, 532462, 591038, 591036, 591028, 582291, 594504, 582290, 594493, 594365, 594363, 439223, 570898, 570896, 582289, 594421, 582287, 582285, 582284, 582283, 580134, 592496, 439215, 594373, 594170, 582282, 582281, 582280, 582279, 570421, 439204, 582278, 439202, 439197, 582277, 439195, 582276, 439189, 439187, 594211, 594209, 582275, 582273, 582272, 594164, 582271, 582270, 582269, 582268, 439161, 582262, 582261, 439156, 593979, 593944, 582259, 593915, 439141, 582258, 593936, 593934, 593928, 582257, 593842, 593818, 593840, 593830, 593828, 582256, 582255, 593222, 593220, 592092, 593216, 592090, 592088, 439086, 582254, 439084, 439082, 439080, 439078, 439076, 593702, 593698, 593620, 593617, 593696, 532417, 582253, 593687, 593612, 593433, 439052, 439050, 593430, 593427, 593425, 593422, 582252, 593537, 582251, 593530, 590724, 593520, 593500, 593498, 593518, 593496, 593491, 532412, 582250, 582248, 580119, 593411, 593405, 582247, 593404, 593402, 593398, 593395, 593393, 593391, 593389, 593388, 592654, 493856, 592652, 592649, 593290, 593257, 593255, 593253, 592914, 593251, 582246, 593249, 532399, 582245, 532394, 582244, 592420, 582243, 582242, 582240, 582238, 582237, 471336, 582236, 532390, 593144, 532388, 582235, 582234, 572885, 572882, 532386, 593081, 582233, 593079, 582231, 582227, 532375, 572878, 572875, 593040, 582224, 582222, 582221, 582220, 548373, 582219, 593051, 582218, 582217, 593049, 592984, 593053, 593047, 582216, 200857, 592973, 582214, 582213, 592931, 580108, 532361, 532360, 582212, 582211, 592924, 582210, 532355, 582209, 582208, 568655, 439035, 592908, 582207, 582205, 582204, 592824, 582203, 592786, 592784, 592782, 592772, 592770, 539553, 582202, 592765, 582201, 592764, 592762, 592632, 582199, 582198, 592576, 532329, 592574, 592572, 592570, 582197, 592568, 438979, 582195, 582194, 582193, 582192, 582190, 582188, 582187, 582186, 582185, 582184, 582182, 592533, 582181, 582180, 582179, 592531, 582178, 582176, 582174, 592519, 582171, 592517, 591752, 548371, 592436, 582170, 582169, 582168, 582167, 591830, 591827, 582165, 592333, 582162, 592429, 582160, 582158, 582155, 582153, 592355, 592353, 582152, 592317, 592328, 571267, 571266, 592314, 592312, 591823, 589960, 592310, 592308, 589955, 582151, 582150, 592306, 582149, 582146, 582145, 582143, 582142, 582141, 582137, 582136, 582135, 582133, 582132, 582131, 582130, 582129, 582127, 592177, 582123, 582122, 573230, 582120, 582119, 582118, 582116, 582115, 582114, 582113, 582112, 438929, 582111, 582110, 438907, 438905, 592034, 582108, 582107, 582106, 582105, 582104, 582103, 582102, 582101, 591708, 582099, 589946, 591974, 591850, 582098, 582097, 582096, 582095, 582094, 582093, 582092, 582090, 582089, 582086, 582084, 582082, 591615, 591613, 582080, 532258, 582079, 582078, 221936, 582075, 582074, 582073, 591392, 591389, 109212, 109207, 590425, 590423, 580090, 438803, 438801, 580088, 438732, 590406, 591159, 591147, 438696, 438694, 582072, 532111, 438666, 532105, 438655, 438651, 536311, 438648, 438637, 438635, 438633, 438628, 591011, 591008, 536309, 536305, 532088, 536298, 536294, 590992, 590827, 590814, 590811, 548362, 548352, 438572, 438558, 438557, 590765, 109175, 590395, 582071, 590392, 582070, 548334, 548332, 438536, 438534, 548330, 548328, 246627, 548322, 246624, 590662, 246621, 590660, 590651, 438528, 246616, 548320, 548316, 582069, 590616, 590589, 590586, 580080, 590584, 590577, 590574, 590544, 590540, 590538, 590536, 590524, 590387, 590522, 590514, 590512, 590506, 590504, 590501, 590499, 590496, 590493, 590488, 590486, 590483, 590476, 590469, 246599, 580078, 532045, 532033, 614696, 580076, 469061, 614693, 532025, 532024, 532023, 532022, 590384, 590376, 532016, 438470, 109170, 438457, 438445, 438427, 590262, 580074, 580071, 580069, 580065, 580063, 580043, 133240, 531992, 584871, 584868, 438405, 582068, 221864, 246562, 246560, 531981, 531972, 438329, 438286, 438275, 582067, 438229, 438224, 438222, 438220, 438189, 438159, 438147, 579898, 579883, 579875, 579873, 579871, 438106, 438095, 438075, 438044, 590198, 438040, 438028, 246514, 437984, 437980, 246511, 579803, 246508, 246505, 579788, 579784, 579772, 579762, 246485, 246483, 437943, 437931, 437928, 246478, 437926, 437920, 437912, 246447, 246445, 246434, 437882, 246424, 246378, 437836, 246364, 246355, 246351, 246346, 246344, 246340, 582066, 246327, 246324, 582065, 582064, 582063, 531847, 200797, 437772, 246287, 582062, 582061, 582060, 582059, 582058, 582057, 582056, 582054, 582053, 582052, 582051, 531826, 570381, 571064, 571062, 571060, 571058, 437687, 437683, 582050, 582049, 582048, 582047, 589544, 333997, 333995, 333993, 587705, 531785, 579612, 437371, 579610, 437367, 437364, 437362, 437360, 437356, 437354, 437352, 437347, 437345, 437334, 437308, 437306, 437302, 437300, 437298, 417907, 417905, 417903, 582046, 417901, 582045, 417899, 417897, 582044, 589199, 589180, 531754, 589361, 588933, 531747, 582042, 588686, 588684, 588682, 588679, 588677, 406487, 406485, 406483, 406481, 406474, 614668, 588916, 588931, 406472, 531700, 588674, 588871, 582041, 582040, 582039, 582038, 588672, 588667, 588660, 588657, 588761, 531676, 588653, 588647, 531671, 309797, 309795, 309792, 246215, 437189, 437185, 437182, 437180, 437177, 437175, 437161, 437157, 588501, 437153, 588499, 588497, 588495, 588493, 588491, 588489, 588484, 588479, 588477, 437141, 588475, 437139, 587998, 437136, 437127, 531631, 437117, 437111, 582037, 568653, 568651, 568650, 531563, 568648, 568646, 436743, 398165, 398163, 398161, 310062, 531503, 531501, 531498, 531494, 531492, 568644, 582036, 582034, 582031, 587118, 587114, 582030, 587110, 587131, 572873, 573229, 569841, 569839, 573227, 569837, 572871, 587077, 587085, 586898, 587073, 568642, 586006, 586003, 582029, 531471, 586000, 585997, 531469, 585995, 585992, 585990, 585988, 582028, 436647, 471331, 531466, 585986, 585983, 109113, 585981, 585977, 585968, 554095, 585966, 582026, 585951, 585941, 109101, 585934, 582024, 586673, 584996, 584994, 584992, 584990, 531432, 531427, 582023, 436464, 582021, 582020, 582019, 531395, 174349, 554065, 582018, 582016, 582015, 586092, 554064, 531381, 582013, 582012, 531375, 554063, 133218, 133217, 585641, 133215, 133211, 585638, 585636, 578403, 578398, 578394, 582011, 582008, 585489, 585487, 582007, 531348, 585476, 109047, 531342, 582005, 582003, 582002, 436256, 582000, 436254, 246004, 109043, 109040, 109038, 109036, 581999, 309772, 581998, 581996, 581994, 531288, 309729, 581993, 581991, 37782, 581990, 581988, 581987, 581986, 531264, 581984, 581982, 581981, 435820, 581980, 576916, 581979, 581978, 581976, 581975, 581974, 581973, 581971, 581969, 581966, 581965, 581962, 206176, 581961, 581958, 581957, 581956, 581955, 581954, 531249, 584078, 584076, 581953, 581952, 581951, 581949, 581947, 581946, 581623, 581944, 581940, 581937, 554024, 581936, 581935, 584303, 531223, 581934, 581933, 581932, 435726, 581931, 581930, 581929, 581928, 581927, 581926, 581924, 581923, 581922, 581921, 581920, 581919, 581918, 584217, 584214, 435588, 584211, 584207, 584205, 581917, 584183, 581916, 584177, 584175, 581915, 581914, 581913, 581912, 581911, 584162, 584160, 584158, 584144, 531201, 581910, 581909, 435532, 435525, 435515, 581908, 581907, 581906, 581905, 581904, 581903, 435508, 581902, 581901, 581900, 435477, 581899, 581898, 581897, 581896, 581895, 581894, 581893, 581891, 581890, 581889, 581888, 581887, 581886, 581885, 581884, 581883, 581882, 581880, 581878, 581877, 581876, 581875, 435466, 435464, 435462, 581834, 435455, 581832, 245905, 531178, 581829, 581826, 581824, 579194, 581821, 531174, 531173, 200657, 200655, 245857, 221442, 245855, 200653, 531168, 531090, 531086, 578135, 553997, 434889, 577878, 206167, 206165, 206163, 206161, 200558, 200555, 553994, 577660, 577655, 530907, 530904, 221267, 200550, 376418, 200548, 376401, 530884, 577564, 577558, 376378, 200546, 376375, 376373, 376370, 434694, 530864, 434678, 434676, 553981, 434674, 434665, 200545, 200543, 200541, 576804, 434637, 434603, 200539, 434600, 434598, 434595, 434593, 577510, 577508, 200537, 200535, 200533, 575405, 577447, 577445, 577443, 200532, 577439, 577436, 200530, 200528, 200526, 200524, 200522, 200520, 200518, 200516, 577426, 200514, 577410, 200512, 200508, 245554, 530835, 530833, 245549, 245541, 245539, 245537, 245534, 530825, 530821, 577311, 573225, 575959, 530818, 434510, 434464, 554707, 434358, 108946, 576747, 434356, 108944, 397449, 434302, 576744, 576740, 560277, 577136, 451956, 451954, 451952, 451950, 451948, 108931, 434290, 577120, 434286, 577107, 434276, 451946, 451943, 451941, 234776, 234772, 434256, 434254, 234761, 234759, 234753, 234751, 234748, 451915, 108921, 434246, 234742, 234709, 576850, 234683, 234672, 234668, 234657, 234649, 234642, 576848, 234635, 553977, 206153, 576929, 576840, 576837, 576832, 576830, 576827, 576821, 576818, 576816, 573795, 453682, 453679, 553976, 108918, 108912, 108910, 530760, 108905, 108903, 108901, 576640, 576637, 576632, 108899, 108896, 245496, 575957, 576568, 576566, 576563, 573283, 576582, 576560, 576558, 576556, 412407, 493619, 493617, 493614, 234595, 234593, 530747, 234591, 234588, 234586, 234584, 530745, 530742, 530740, 530738, 530736, 530733, 530732, 530730, 530728, 530724, 576219, 234549, 576481, 576479, 576309, 576477, 576474, 328444, 576302, 434192, 245443, 576296, 576201, 245439, 576199, 245436, 522664, 576192, 576292, 245432, 245430, 328442, 245427, 245425, 522658, 522656, 245420, 576380, 382290, 576345, 576342, 576267, 245417, 576265, 553964, 553962, 553957, 576217, 576215, 234510, 576087, 576085, 576083, 576081, 576079, 576126, 576076, 576185, 576070, 576067, 434160, 434157, 434155, 434153, 434151, 434148, 530701, 530700, 576147, 399341, 245402, 530699, 245400, 245398, 397447, 245389, 245384, 245380, 575939, 530693, 245372, 245369, 245363, 574349, 401054, 530686, 245360, 245356, 245354, 530684, 573224, 245348, 573222, 245345, 245343, 573220, 245331, 573218, 434139, 573215, 573213, 245325, 573211, 245315, 245311, 576040, 530680, 575920, 245292, 575917, 530676, 530675, 493599, 245278, 245276, 573206, 573204, 573202, 575909, 576038, 572819, 573200, 572817, 530673, 572815, 573198, 573195, 573192, 493590, 573189, 575895, 493587, 576032, 575884, 575873, 434137, 221115, 221112, 434135, 221110, 575796, 573186, 573182, 575837, 573180, 575835, 434126, 434124, 530661, 434115, 574249, 574245, 574243, 530654, 434100, 434090, 434088, 574240, 434085, 434083, 434078, 434073, 575629, 573961, 434052, 573959, 573956, 575621, 575617, 575615, 575612, 575609, 575606, 575604, 573954, 573951, 575595, 493578, 530639, 493576, 573867, 200438, 434032, 542171, 434029, 542169, 221093, 245248, 245215, 245213, 245210, 245208, 245203, 221084, 463705, 463701, 553935, 530597, 341499, 221069, 341496, 574278, 234448, 341493, 573177, 573171, 573169, 200423, 575270, 553921, 200420, 433933, 553918, 553916, 530574, 200418, 200416, 200414, 200412, 200410, 200408, 200405, 530570, 530567, 530565, 245190, 530561, 575200, 575198, 575196, 575194, 245188, 575173, 530558, 234433, 575162, 575160, 234431, 575157, 575151, 325558, 325557, 325556, 325555, 325554, 325553, 325552, 325551, 574973, 575096, 575094, 575073, 530543, 575070, 574955, 574946, 574943, 574940, 575066, 234396, 575050, 234391, 553909, 234385, 575040, 234381, 573167, 575029, 234366, 575027, 575024, 575022, 575020, 575017, 574907, 574891, 574888, 234314, 574884, 574880, 553907, 245164, 245158, 245154, 245152, 245150, 499383, 574853, 573165, 573163, 499379, 499377, 573160, 573157, 573152, 530504, 433882, 530501, 133177, 553901, 433874, 573151, 386011, 573147, 433870, 433866, 245132, 553896, 573942, 245131, 573940, 499375, 573145, 245129, 530483, 564008, 245123, 564006, 245118, 433806, 564003, 563998, 563996, 433798, 433788, 530475, 530473, 245110, 245106, 245104, 245102, 245100, 245097, 530471, 433783, 433779, 563994, 563992, 563989, 530464, 471287, 471285, 471283, 530462, 530461, 530460, 245084, 245082, 530458, 499373, 245079, 245077, 573143, 526390, 573141, 573139, 245075, 499371, 573137, 573135, 530451, 499369, 553890, 573132, 573130, 499366, 573127, 573125, 433733, 433730, 553884, 573122, 573119, 574479, 573116, 573114, 573112, 573108, 234204, 573106, 574469, 574466, 574385, 574367, 433722, 433717, 433715, 573104, 433710, 245068, 433707, 573102, 573100, 573098, 573937, 573095, 573934, 573931, 573928, 234196, 234193, 234184, 573094, 234179, 573092, 234166, 234163, 234161, 234159, 573087, 234157, 573085, 573082, 573080, 573077, 573075, 573072, 433679, 573070, 573068, 573065, 573063, 573061, 573059, 573057, 573056, 573054, 573052, 433659, 573049, 573047, 573045, 573043, 573041, 485890, 530410, 433639, 433637, 433635, 530408, 433633, 573040, 573038, 485888, 573035, 573032, 574053, 573030, 574051, 573028, 234073, 526373, 553872, 573027, 526370, 553869, 234063, 573024, 333927, 563988, 574016, 573022, 553856, 553854, 433581, 553832, 553827, 573021, 573019, 572811, 573014, 433569, 573011, 553825, 573005, 573003, 573001, 572996, 553813, 572994, 553810, 572992, 530366, 571265, 572990, 530363, 572988, 553786, 530339, 549993, 572984, 433525, 573498, 573496, 573494, 433522, 573492, 573490, 573488, 572982, 572980, 433520, 572977, 433513, 572971, 572968, 572964, 572961, 572958, 572955, 572953, 572949, 245037, 573486, 573340, 573480, 573478, 573475, 573473, 573470, 573505, 573468, 573466, 245025, 245022, 245020, 245014, 245009, 245006, 572946, 572943, 572941, 572939, 572937, 530281, 572934, 572931, 572929, 572927, 572925, 244995, 572923, 572920, 572918, 572916, 456136, 572914, 572801, 572912, 572798, 572910, 244988, 572792, 244985, 244983, 244981, 572789, 244979, 572787, 244976, 244970, 244968, 560641, 244965, 244963, 244960, 471277, 471275, 471273, 244953, 471267, 244950, 244944, 471264, 244939, 471262, 433457, 433454, 433448, 433445, 433442, 433440, 433438, 433436, 433434, 244804, 244801, 433387, 433385, 572500, 244783, 244779, 572239, 433335, 452664, 433329, 433275, 572339, 572336, 572333, 572319, 220919, 572315, 572313, 572309, 572307, 572305, 572303, 572301, 244768, 572296, 433269, 433264, 572293, 572286, 433259, 433252, 572274, 433248, 433246, 572264, 572262, 397402, 572254, 530132, 433234, 433231, 433228, 433224, 433222, 433218, 433216, 433214, 433211, 433210, 433209, 433208, 433200, 433198, 433196, 571916, 572175, 433194, 530127, 530125, 433187, 572172, 572169, 244751, 233890, 244747, 244745, 530122, 244743, 323632, 233884, 530115, 433171, 530111, 433168, 233882, 433161, 233879, 244733, 433159, 433154, 433152, 571847, 244725, 433147, 433143, 433139, 433137, 433135, 398477, 548272, 433116, 310028, 571498, 548270, 571496, 349552, 548268, 571742, 571739, 571736, 530105, 553057, 433110, 433106, 571494, 571490, 310026, 571486, 553742, 530095, 571484, 244721, 433100, 553054, 571482, 571479, 530093, 571473, 571470, 433085, 530091, 527761, 527758, 527756, 530087, 433071, 433067, 433065, 433061, 433058, 530081, 530080, 433052, 530078, 433050, 433048, 530075, 530070, 433044, 433042, 233872, 233869, 433040, 433037, 233867, 233855, 244714, 571585, 526335, 233842, 570181, 530060, 233838, 433013, 530057, 515521, 244712, 433011, 530055, 515518, 433009, 515515, 244707, 530054, 530052, 530048, 133147, 328438, 530045, 530044, 432976, 570180, 571429, 571412, 571421, 571410, 517357, 530030, 530027, 571416, 530025, 515514, 515512, 432938, 571408, 530023, 571406, 432932, 530019, 526330, 515509, 515506, 530014, 530012, 515495, 515486, 515484, 526312, 526309, 526307, 526304, 530007, 530005, 526294, 526292, 530000, 380928, 529998, 380923, 380921, 529993, 380919, 529991, 398464, 529989, 529987, 233812, 529984, 485877, 485873, 529980, 571264, 485871, 432897, 529977, 529975, 529972, 529969, 529967, 529965, 571261, 570179, 570176, 529958, 529955, 570324, 570173, 570170, 220868, 529952, 553734, 570168, 553733, 220866, 570322, 529943, 529941, 220863, 529939, 164640, 220861, 553730, 570166, 553727, 164635, 553725, 553720, 432873, 244681, 553718, 244679, 432870, 529916, 529914, 244670, 164631, 244668, 244662, 244658, 570164, 553714, 553710, 570161, 529908, 244655, 164629, 244652, 244650, 244648, 244646, 244643, 244639, 553709, 529906, 164623, 553706, 529904, 164621, 529899, 164615, 402281, 553703, 164612, 529896, 529894, 309682, 529892, 621701, 553694, 570041, 372396, 309676, 402265, 529890, 244620, 529888, 570950, 529885, 553684, 529882, 553681, 553679, 529879, 529871, 309659, 529867, 465841, 553676, 547984, 36111, 367576, 309645, 570038, 309642, 570036, 206099, 309622, 309619, 309617, 570034, 570778, 570776, 206097, 529861, 529857, 432839, 432833, 432830, 432822, 432816, 432813, 432809, 432807, 432805, 432802, 432800, 432798, 432796, 432794, 527746, 553672, 309584, 309579, 309577, 309575, 367570, 432777, 432775, 432773, 432771, 432769, 432767, 432765, 432761, 432759, 553670, 553667, 432749, 570605, 553664, 570601, 553662, 553659, 553654, 553645, 553643, 553641, 553639, 553634, 553633, 553619, 553616, 553607, 553605, 570473, 553600, 570487, 570485, 553596, 553593, 553591, 553587, 553582, 570483, 432729, 570469, 432721, 432708, 569652, 569650, 553572, 220768, 569643, 569640, 220764, 220761, 220759, 569638, 432697, 569634, 569629, 501834, 501832, 328436, 220739, 569620, 569613, 569610, 569608, 569605, 220730, 569603, 220728, 569601, 220726, 569599, 220716, 220714, 220712, 569596, 547182, 328434, 408804, 547180, 547176, 569068, 547173, 471259, 547169, 547168, 547165, 547163, 547161, 220693, 220692, 220690, 471257, 471254, 471250, 471244, 432661, 220677, 432656, 471234, 471230, 471227, 432648, 432644, 432640, 570120))
Run Time: 0.099813
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 5724 | |
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 | | | | | 5724 | |
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 (35528, 35490, 34969, 34734, 34581, 34248, 34184, 33894, 33402, 33273, 32521, 32314, 31398, 31382, 31141, 31106, 30610, 30489, 30368, 30056, 29959, 29938, 29919))
Run Time: 0.001682
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 23 | 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, v2�
Run Time: 0.000257
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000403
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 215
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (120))
Run Time: 0.000698
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 170
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7695
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1716199245
Run Time: 0.000446
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 18 | 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` >= 1716199245)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000703
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 18 | 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