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.000815
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.000189
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` = '2561')
LIMIT 1
Run Time: 0.000505
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.001482
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_2561' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.384448
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 (563408, 423318, 431849, 526010, 526006, 244397, 431685, 333853, 529367, 244387, 323618, 333846, 244384, 233313, 529364, 539490, 560472, 233277, 525989, 529349, 529348, 525987, 220142, 525970, 525965, 529340, 525963, 525955, 525952, 325863, 220136, 529337, 525949, 431660, 525945, 252871, 525937, 220130, 529335, 529332, 529330, 414563, 529328, 560511, 560509, 560507, 408802, 408801, 310564, 355911, 233272, 502986, 503445, 353147, 353146, 322630, 502984, 325862, 414552, 529323, 220123, 529321, 220121, 431643, 560615, 560610, 560608, 233262, 233260, 431636, 529318, 553334, 557445, 431634, 529316, 560600, 557670, 560598, 333836, 333833, 333830, 333828, 529315, 333826, 560696, 312328, 560694, 312326, 560673, 560337, 518720, 560579, 560574, 431619, 312322, 312320, 312318, 431615, 537699, 431611, 537696, 312316, 431609, 347967, 537694, 431601, 549986, 560222, 331354, 518713, 323616, 529263, 405790, 431362, 557995, 551100, 367508, 529241, 557988, 405785, 524556, 243855, 524537, 535588, 535577, 384230, 535575, 624800, 524523, 524502, 388272, 524496, 528615, 524393, 524391, 524388, 524385, 524381, 526568, 219315, 524377, 524368, 524365, 219310, 219309, 524360, 528601, 333750, 333747, 333745, 333743, 467643, 524352, 527423, 524338, 232372, 419460, 428778, 528260, 219298, 528238, 528310, 524309, 524303, 524301, 428762, 526557, 524298, 528272, 524290, 524286, 524284, 524282, 524280, 524276, 524272, 524270, 524268, 428760, 524251, 528150, 524248, 479691, 524244, 524241, 524235, 524232, 524230, 524222, 524217, 243803, 309321, 524215, 428757, 428751, 309318, 527410, 527404, 526911, 527240, 328424, 219255, 527231, 527229, 526712, 522780, 524192, 354475, 354473, 457674, 219237, 453519, 199922, 527083, 323591, 323589, 323587, 323585, 323583, 428705, 485554, 354472, 428703, 219233, 414870, 219229, 219226, 108587, 219214, 404700, 404698, 412034, 412031, 509203, 518475, 509103, 509198, 509192, 509187, 509185, 509181, 480587, 480579, 322626, 375963, 323513, 618331, 337004, 421748, 468891, 242330, 408783, 468885, 322624, 355844, 476570, 230422, 110309, 217428, 365208, 11900, 474851, 478940, 217373, 217369, 107947, 107936, 107934, 107928, 107923, 230351, 107917, 230343, 468880, 458787, 466107, 216908, 56448, 464747, 464744, 464741, 464732, 464433, 463988, 463985, 326950, 326948, 326945, 241645, 241642, 241639, 241637, 241634, 241632, 241629, 241626, 365191, 241624, 461869, 229812, 216750, 216748, 459596, 216745, 458554, 459594, 216743, 216741, 241606, 459591, 216739, 459589, 216737, 458550, 241602, 241594, 216710, 458544, 241590, 458542, 216707, 461358, 461054, 459650, 461116, 460922, 460213, 460211, 460920, 460720, 461045, 461043, 461039, 460916, 216697, 423257, 241568, 216695, 458537, 241565, 460654, 423255, 458534, 460370, 460366, 460360, 229774, 450816, 450815, 454326, 454323, 355822, 375297, 356394, 459838, 457444, 459835, 385838, 458261, 617914, 617903, 132353, 457163, 454145, 454123, 454118, 453001, 408308, 408257, 382101, 215425, 396980, 401280, 393535, 401277, 396976, 400943, 384528, 401253, 215403, 400899, 228113, 401215, 401274, 399977, 215293, 395728, 395983, 395725, 390115, 393370, 392280, 394186, 302055, 394328, 238905, 308747, 384519, 308722, 381496, 156245, 106463, 383537, 376839, 106459, 365162, 238688, 238631, 382808, 227368, 227366, 227364, 384723, 94281, 347881, 376074, 369639, 384706, 94280, 94278, 384594, 384663, 188116, 384121, 384118, 384116, 384114, 363002, 308689, 214625, 227353, 238620, 308687, 384583, 363000, 384514, 384112, 227347, 379763, 357962, 238611, 214618, 320286, 308678, 308673, 214131, 374902, 374515, 373067, 214057, 373100, 373020, 373018, 372520, 372491, 348849, 308600, 348846, 326942, 326939, 364808, 371114, 370961, 365113, 369710, 370411, 370409, 326936, 205298, 370401, 326934, 205296, 326932, 326931, 326929, 326926, 326924, 326922, 326920, 326916, 326914, 369631, 326909, 369629, 326907, 326904, 326900, 326894, 364804, 326892, 362003, 303222, 237992, 369365, 366396, 368499, 213668, 350278, 366796, 366794, 366787, 237933, 237927, 366606, 180813, 237903, 365826, 333378, 366426, 237898, 309923, 366394, 226502, 226500, 365815, 365645, 364801, 226480, 359798, 364799, 361028, 364797, 364057, 361084, 364794, 226453, 261215, 226451, 213506, 328834, 364051, 364792, 226448, 226442, 105943, 364531, 364844, 213494, 364790, 364788, 364842, 360697, 105941, 364785, 364529, 364782, 364525, 364522, 364534, 364519, 226429, 303177, 303175, 354402, 303173, 328247, 361553, 354400, 335677, 277455, 277453, 363661, 363645, 363539, 363502, 17715, 360691, 226348, 360683, 360674, 362483, 226243, 237576, 226239, 361065, 357092, 360845, 360542, 360841, 341095, 360539, 341093, 333352, 341091, 341089, 356772, 341086, 356770, 356768, 350320, 360537, 335781, 205288, 213256, 348233, 358942, 360604, 360599, 360602, 360534, 226161, 333348, 346797, 360596, 346795, 360319, 360391, 360549, 303080, 358868, 237485, 237483, 358866, 359567, 358863, 357038, 359365, 226019, 359363, 226017, 359546, 56796, 226011, 359543, 357748, 358858, 237476, 359405, 359541, 359539, 226009, 226008, 358194, 226005, 359404, 237471, 357746, 359399, 358190, 359358, 357980, 359028, 356246, 180746, 105713, 105700, 359025, 180744, 357978, 356244, 356242, 180741, 359016, 358784, 356598, 358782, 354710, 207502, 213161, 225975, 358779, 213158, 207500, 359041, 225971, 359011, 358705, 308521, 213155, 358777, 358774, 354851, 358772, 358770, 354849, 17709, 354848, 237439, 358764, 213125, 128957, 225962, 358760, 354844, 225959, 213119, 225955, 358849, 354841, 358754, 358752, 354839, 358748, 358581, 358577, 358575, 358574, 237410, 358568, 336004, 225932, 237406, 358280, 358557, 237397, 225928, 358606, 237395, 56794, 357995, 355490, 294190, 358315, 213060, 358179, 358172, 356765, 358162, 357692, 356762, 357690, 352799, 357688, 357720, 357670, 357823, 357821, 357798, 357667, 357718, 357022, 212999, 356755, 357716, 180739, 357565, 356436, 333307, 355464, 356851, 356957, 357013, 357237, 357159, 315996, 355219, 237282, 355453, 357233, 357225, 357003, 355451, 356840, 356839, 356836, 356832, 355449, 356830, 225804, 356827, 355444, 355440, 356824, 348225, 356751, 225797, 355438, 355436, 337399, 356820, 356817, 337397, 357069, 356814, 356936, 356812, 356746, 348222, 237277, 354704, 225791, 356802, 354702, 356799, 105656, 225789, 105654, 348219, 225786, 105652, 212957, 328241, 327149, 356549, 356481, 355104, 355101, 355099, 355097, 355095, 354308, 352661, 180721, 237259, 333292, 354835, 180713, 212897, 212895, 225737, 225733, 355217, 225729, 356533, 212891, 180704, 180700, 191796, 212889, 356228, 343348, 343346, 355215, 356528, 191794, 180691, 355213, 343341, 355211, 105632, 105628, 237246, 105626, 105624, 225712, 212868, 225708, 212866, 191785, 356221, 105622, 212862, 105620, 225703, 212856, 105617, 333291, 191782, 105614, 333289, 191780, 333287, 191778, 333285, 356431, 237238, 212846, 333282, 354387, 333279, 212835, 252506, 212833, 355206, 356208, 212830, 225657, 346200, 354306, 354828, 354383, 212828, 355431, 354826, 355514, 237218, 355426, 356193, 225647, 354819, 354379, 180684, 237212, 225645, 237210, 180682, 180679, 354376, 354817, 237208, 225638, 225636, 225634, 225632, 237200, 350072, 225617, 350069, 354303, 350067, 354375, 350065, 346793, 191763, 354750, 225588, 355186, 355177, 355085, 354814, 266853, 354374, 354075, 354691, 354805, 180649, 180647, 348819, 354667, 354661, 225569, 354659, 354657, 354655, 348817, 354747, 348815, 354371, 354370, 354653, 354651, 348813, 353582, 105606, 268857, 354611, 237191, 225564, 59843, 191759, 353579, 225561, 105592, 105590, 105586, 212766, 237179, 353576, 225554, 353571, 59841, 105584, 237173, 44851, 348805, 225548, 237164, 180640, 180638, 348803, 354369, 308487, 348801, 354365, 308485, 347461, 348799, 348796, 352652, 352912, 354300, 352910, 310307, 348793, 354321, 237155, 225540, 354318, 225538, 225536, 354298, 354060, 353569, 352650, 354296, 354294, 354290, 354325, 354226, 354180, 180611, 180609, 352903, 310305, 180607, 352647, 354008, 334646, 353440, 180596, 352769, 180585, 353812, 105541, 105539, 348791, 105536, 352767, 256190, 345122, 347716, 352765, 347592, 237138, 348789, 345115, 256706, 180560, 191751, 352895, 237132, 191749, 191747, 191745, 191743, 353632, 351346, 353774, 351345, 353624, 261211, 353621, 353604, 225500, 353730, 353602, 353600, 353598, 353564, 353562, 59833, 105523, 346772, 346770, 346768, 352950, 59831, 348782, 346766, 105513, 353290, 225496, 348779, 310111, 338604, 352853, 252478, 180559, 352645, 310293, 349882, 349880, 353389, 353420, 105512, 212714, 349875, 212711, 212709, 352947, 352642, 352881, 310281, 352639, 351361, 105504, 347455, 352637, 105502, 352848, 352632, 105500, 353202, 105496, 352995, 352993, 353197, 353194, 352991, 353191, 352943, 353189, 352989, 105488, 352987, 212704, 180552, 180549, 180547, 180545, 180541, 180536, 180534, 180532, 180524, 180522, 180520, 322615, 352983, 352869, 352841, 237106, 225454, 180503, 352751, 225452, 180501, 352749, 237102, 237100, 310269, 225450, 348777, 352745, 237097, 237095, 352695, 352609, 350302, 212690, 350517, 310264, 212685, 348775, 225425, 351769, 351767, 351765, 212652, 350274, 350001, 303066, 352084, 352080, 212647, 237046, 303063, 351964, 351962, 352070, 352001, 268806, 351679, 351920, 225393, 351992, 351989, 345274, 351955, 351915, 237038, 345272, 345270, 225377, 345268, 225374, 345266, 338592, 351594, 237021, 351443, 351574, 338588, 338586, 339260, 350273, 105436, 225319, 351500, 339258, 350127, 105432, 350271, 350125, 225316, 351341, 351338, 303054, 303052, 348774, 351369, 225296, 112993, 112990, 112988, 349857, 252449, 350504, 345336, 303044, 345333, 345331, 333245, 105423, 346180, 180452, 350414, 105417, 327142, 350656, 350654, 225249, 350652, 350650, 252440, 350648, 350646, 350600, 350644, 350113, 350598, 350111, 350463, 225238, 350413, 350365, 350242, 350240, 225236, 350423, 327133, 327131, 350291, 347589, 350107, 350232, 347585, 350227, 349998, 350146, 327129, 347582, 349996, 347580, 350190, 347576, 349993, 212547, 212545, 212536, 347573, 349988, 277414, 350100, 59824, 212529, 180451, 236993, 350023, 334640, 349981, 59820, 334632, 349974, 333228, 333226, 333224, 212526, 212524, 212521, 349871, 131682, 349885, 349869, 225206, 349840, 343430, 333219, 347568, 333215, 333210, 333207, 191735, 349684, 333205, 347555, 348154, 348152, 347549, 348904, 348880, 348878, 348898, 348894, 346173, 346170, 348875, 348891, 348889, 344159, 310239, 334314, 347545, 348479, 310235, 348477, 348717, 348715, 348714, 212507, 212505, 310233, 326491, 348645, 212502, 348643, 326488, 347544, 347069, 348513, 348511, 348474, 348543, 348541, 348539, 348537, 236956, 212499, 236954, 348534, 333204, 348531, 343426, 348468, 343424, 348466, 348464, 344232, 236951, 236949, 348462, 344225, 344222, 348459, 348525, 348457, 347448, 212493, 344220, 236947, 344009, 258860, 344007, 212490, 334690, 212488, 258858, 348453, 273852, 348131, 348130, 348109, 277390, 236913, 236910, 236908, 225127, 225120, 333202, 333200, 347790, 347787, 347783, 343410, 347777, 225106, 347761, 347775, 347758, 347773, 347711, 347709, 347771, 345011, 347707, 236893, 347430, 347426, 347391, 343994, 346717, 321641, 346556, 333193, 346554, 346552, 225060, 346636, 346549, 345742, 346545, 225058, 346601, 346599, 346581, 205255, 344614, 333178, 337917, 346432, 346068, 236841, 252375, 345829, 345851, 225012, 345401, 212339, 212336, 105394, 212334, 212332, 212326, 345078, 345209, 345008, 345004, 345002, 345144, 345000, 340834, 343992, 344991, 342680, 344985, 344680, 344791, 236813, 344604, 212309, 236811, 342669, 342663, 273834, 212295, 342660, 236808, 342658, 236806, 342656, 344591, 295961, 295959, 344081, 344421, 344108, 344105, 344102, 344272, 342654, 341071, 224881, 341069, 331880, 341919, 224861, 224859, 342509, 342505, 224857, 342502, 236740, 342500, 224854, 342495, 342492, 236736, 342488, 342296, 236733, 262876, 236731, 342399, 342478, 342293, 256158, 212180, 341552, 340215, 273809, 340212, 273806, 205243, 212039, 340120, 224661, 340475, 340461, 252286, 211983, 211979, 252285, 211977, 252283, 211971, 338256, 338843, 105266, 338840, 236477, 236475, 308414, 339490, 339488, 339421, 339255, 339419, 339417, 339604, 339607, 338520, 338252, 339140, 339037, 338518, 338516, 338250, 338249, 339240, 338514, 236450, 339224, 339236, 325264, 109855, 236448, 339222, 339220, 338512, 339206, 338851, 339102, 339136, 338509, 339100, 339134, 338061, 334516, 277369, 334513, 252207, 252206, 338678, 236429, 328663, 211892, 211890, 338157, 205205, 224541, 224538, 205202, 324123, 205200, 205198, 338501, 205193, 338408, 205191, 338406, 205185, 338148, 338434, 338387, 211840, 338357, 338244, 338242, 337556, 336081, 252186, 337553, 336079, 224523, 337887, 224521, 337884, 331681, 337880, 337550, 252183, 337878, 252180, 338240, 338202, 205178, 205176, 211820, 279063, 338027, 224519, 337528, 224517, 338138, 211800, 277359, 224514, 315626, 211788, 105256, 211783, 329451, 335641, 211779, 337875, 277357, 205175, 105254, 338051, 277355, 277353, 337872, 337906, 105247, 337737, 180406, 330752, 224501, 337781, 211744, 105243, 333156, 337735, 333154, 313652, 236347, 337441, 236345, 337439, 161697, 337402, 224491, 337369, 332220, 332214, 336945, 336935, 336931, 205163, 336917, 205161, 333142, 333138, 333135, 236323, 277347, 333133, 336899, 277346, 277342, 336094, 277340, 277334, 236304, 328815, 336352, 335919, 336074, 336344, 336083, 336342, 195989, 195987, 98413, 300820, 334871, 336022, 252156, 335462, 211643, 236264, 333129, 328811, 252152, 277332, 333127, 236252, 334197, 277330, 277328, 236248, 236244, 236242, 335587, 335302, 57093, 335579, 335716, 292892, 335714, 236219, 335577, 335573, 335571, 335569, 331547, 335403, 335564, 335562, 335401, 335084, 335399, 335397, 335752, 335082, 334417, 335712, 335557, 335393, 299618, 315189, 236186, 335383, 224441, 224438, 57081, 57078, 180368, 335078, 334412, 236181, 236179, 335359, 180366, 236177, 180364, 335293, 236173, 335289, 310150, 310148, 310144, 334407, 334404, 310142, 334400, 334397, 335379, 105215, 236171, 335336, 335376, 328807, 334313, 137938, 335072, 137935, 328805, 335372, 180348, 224411, 156218, 180331, 335312, 335310, 335281, 236157, 236155, 335094, 236153, 211562, 236145, 332586, 105163, 211549, 211547, 277325, 236133, 211537, 236130, 334974, 236126, 334819, 236122, 131542, 224384, 224382, 297883, 224365, 334794, 297881, 334860, 236082, 297877, 334565, 334777, 224359, 297871, 332990, 334557, 334259, 334554, 334747, 334551, 334548, 128907, 128905, 224352, 224349, 224347, 333014, 333011, 224342, 333009, 333007, 334603, 334601, 334715, 334312, 128901, 331764, 300813, 331762, 331759, 224337, 236077, 224335, 236075, 332549, 334149, 334144, 334311, 334142, 334310, 334374, 334309, 334372, 334140, 334308, 334369, 334540, 334307, 334367, 334364, 334138, 334136, 334306, 333122, 334132, 334305, 334304, 334130, 333116, 333114, 333109, 300806, 224304, 332544, 332542, 332539, 332537, 332535, 236038, 224300, 211421, 332918, 332519, 128892, 224296, 332515, 236035, 332512, 224286, 332508, 332506, 332953, 332503, 224281, 311752, 300801, 332912, 311739, 224274, 300798, 311737, 332873, 332871, 331540, 236025, 211399, 236022, 236020, 236018, 236015, 236012, 211394, 236010, 211391, 224260, 331200, 332643, 332456, 332453, 211373, 211371, 202641, 326692, 332614, 224250, 202639, 224247, 332284, 266092, 310506, 322604, 332564, 330885, 195945, 330883, 332430, 332426, 224243, 224241, 332423, 224236, 236000, 235997, 235995, 105101, 235993, 105099, 317865, 332381, 332365, 332379, 235991, 332319, 211346, 235989, 235987, 332202, 211344, 181437, 235985, 211342, 266090, 313976, 332299, 332296, 332146, 211329, 332143, 211325, 330619, 330615, 312583, 128879, 328274, 332257, 224211, 327105, 332200, 326891, 282753, 330877, 282751, 330875, 282749, 235974, 332197, 328802, 326886, 327103, 326884, 326883, 328799, 327101, 224097, 211189, 211186, 282790, 327699, 327697, 252083, 252081, 327577, 327575, 314391, 327573, 327695, 327422, 307571, 326662, 307569, 327693, 327688, 327717, 327680, 327600, 92769, 306907, 314387, 326837, 327255, 326624, 327571, 327563, 327569, 327561, 204023, 205107, 327097, 263057, 263055, 327095, 327091, 252066, 235885, 326875, 327090, 327089, 318534, 326872, 263052, 263050, 326868, 327006, 326866, 327003, 326827, 324403, 326861, 326860, 326856, 324401, 326824, 326853, 325949, 325262, 318255, 260930, 326352, 223963, 320113, 325944, 306899, 252059, 223962, 223959, 260908, 325625, 128866, 128864, 223944, 306891, 223941, 308380, 308378, 325260, 308376, 325258, 320096, 306888, 325332, 325256, 12601, 325438, 325330, 325254, 223934, 325236, 223921, 325252, 325276, 325250, 325234, 223918, 223916, 325231, 325228, 180287, 211101, 211098, 324399, 325131, 325129, 325127, 305613, 12599, 180283, 310109, 324397, 180277, 180275, 324388, 180273, 180271, 324386, 180267, 324384, 180265, 180261, 180256, 180253, 180250, 323670, 180245, 322993, 322991, 322986, 322982, 180244, 180241, 180238, 322958, 322956, 322593, 322954, 322979, 322592, 322591, 322590, 223914, 264064, 211094, 211092, 322588, 322587, 322586, 322585, 322584, 322686, 322582, 235858, 235856, 211090, 211088, 180231, 211086, 180226, 211084, 319474, 319472, 211082, 180221, 319468, 321618, 321750, 211079, 321906, 321904, 321839, 319454, 211077, 319452, 211073, 321616, 319450, 180219, 319448, 321633, 321823, 223902, 321819, 223900, 321614, 321608, 314561, 314559, 294961, 211069, 211066, 294960, 223892, 294950, 235842, 235840, 223882, 235837, 223875, 321631, 321367, 211053, 223871, 223869, 235835, 235833, 223867, 235831, 223866, 235829, 195872, 211051, 235827, 211047, 195869, 235825, 235823, 235821, 195865, 235819, 311781, 316899, 211042, 235817, 235814, 316896, 223864, 223856, 211032, 211029, 321595, 321593, 321590, 321588, 321586, 264052, 180203, 180201, 180199, 304711, 180195, 235812, 180193, 304701, 180191, 304698, 223854, 180189, 252045, 223852, 180186, 180184, 105035, 304696, 320059, 320057, 264038, 105033, 211016, 235802, 223838, 223836, 223832, 320045, 195855, 320151, 195853, 320082, 260896, 320074, 180177, 180175, 180170, 211003, 260894, 260892, 180168, 260890, 223819, 235786, 319811, 211000, 104985, 252035, 252034, 210998, 210996, 319898, 210994, 252033, 210992, 104980, 319809, 319873, 319871, 319869, 223816, 223814, 311239, 235766, 235764, 252025, 316719, 317076, 235759, 319135, 305888, 319130, 235758, 235199, 223786, 223772, 210979, 318974, 235752, 210963, 223766, 210960, 305885, 210957, 210955, 210953, 223764, 305883, 305881, 223761, 235750, 223759, 223757, 210951, 317703, 318812, 316967, 235748, 223754, 210947, 318808, 318805, 210936, 210934, 210932, 210929, 210926, 223743, 235746, 317062, 317060, 173274, 317057, 317053, 317051, 318491, 260875, 260870, 317393, 318143, 318392, 223731, 223729, 317579, 317115, 311234, 317576, 173270, 317517, 317515, 317513, 317509, 317507, 173268, 317505, 317503, 173266, 317107, 173264, 317500, 317097, 316857, 210886, 307545, 223723, 307537, 173257, 173255, 316174, 173253, 173251, 173249, 210869, 173247, 316067, 252006, 316854, 316713, 316710, 235711, 223710, 316700, 223684, 223682, 180065, 180064, 210830, 180062, 316041, 210826, 316035, 312877, 277295, 223671, 223669, 315958, 315975, 315956, 315973, 315870, 315868, 315866, 315954, 315565, 315864, 251967, 315499, 251965, 251963, 315501, 251962, 277291, 210784, 315474, 315469, 266064, 235680, 235678, 251946, 223637, 235671, 180051, 305209, 193461, 223633, 210755, 305206, 223631, 312539, 180046, 180044, 314883, 314881, 314878, 180041, 251944, 251941, 180030, 180028, 180026, 312530, 104947, 265332, 104945, 180024, 180021, 265329, 104944, 180019, 104939, 104937, 223624, 314456, 223622, 223620, 314948, 223614, 314497, 251937, 314493, 235657, 251935, 251933, 314446, 251930, 314444, 314442, 313442, 266052, 235654, 235652, 223613, 266050, 251928, 223606, 251923, 223603, 251920, 251917, 210740, 210736, 311632, 277282, 223595, 195824, 313862, 277675, 313923, 277673, 314150, 314144, 311228, 314074, 313687, 314021, 195823, 314072, 223586, 223584, 223579, 251903, 314018, 235611, 131451, 131449, 131447, 131445, 313918, 131443, 131441, 313997, 311226, 210734, 313995, 311221, 313949, 313944, 313981, 313842, 257189, 313839, 235595, 313837, 313835, 257186, 313832, 223578, 313830, 261691, 313914, 235592, 313886, 261689, 313760, 313758, 261687, 313883, 251899, 251897, 104923, 312784, 210726, 223574, 104921, 235591, 313820, 313818, 131428, 104920, 104918, 104915, 104913, 313856, 251895, 104911, 180002, 312520, 313744, 313742, 223573, 257184, 235589, 223569, 312361, 318834, 264024, 313679, 313677, 223565, 312875, 223563, 313628, 313378, 223561, 311720, 179996, 313738, 313736, 210712, 210711, 210707, 210705, 313588, 311717, 179992, 210703, 251885, 251883, 251881, 311712, 251879, 235584, 235582, 277280, 277278, 313404, 300790, 279891, 277276, 277273, 313425, 311710, 210698, 313505, 312873, 308364, 312871, 223560, 210681, 312869, 223557, 210679, 277671, 210677, 210674, 277669, 179985, 313663, 257170, 313660, 313618, 313615, 104910, 311700, 223552, 223550, 313496, 223547, 308356, 210669, 210667, 313489, 313485, 257156, 313583, 313483, 313392, 194587, 312576, 312574, 614335, 104907, 312567, 104903, 104901, 235581, 104899, 235579, 313476, 251871, 104897, 312564, 104895, 312782, 104893, 104890, 304675, 179977, 304672, 304670, 304667, 261686, 261684, 313333, 261682, 313331, 313329, 223546, 312867, 104881, 223530, 312763, 223528, 210628, 312760, 312758, 312756, 210626, 235571, 223524, 312515, 223522, 210621, 307531, 312512, 251846, 223514, 251845, 251844, 235566, 312670, 235564, 251843, 312247, 302010, 302008, 235561, 312553, 312502, 104853, 104850, 210600, 261197, 312499, 305593, 210589, 311912, 311908, 306154, 311904, 311618, 305199, 311901, 312121, 205051, 223463, 305197, 205048, 305195, 223457, 223454, 307523, 312231, 206999, 311668, 311616, 307521, 205045, 306152, 306150, 305193, 312228, 308170, 306148, 179957, 210582, 306146, 306144, 305190, 311611, 308168, 311598, 311597, 223440, 311804, 251835, 310491, 210554, 311595, 311771, 310489, 311593, 311757, 289975, 210552, 223430, 223428, 104832, 235551, 311585, 307496, 311658, 235548, 311468, 307494, 223420, 235536, 235534, 104821, 305169, 251827, 104816, 310485, 308325, 206996, 310481, 251825, 272964, 251824, 251823, 264022, 264020, 104814, 310401, 104812, 104811, 306665, 308136, 206994, 308308, 308130, 309853, 272962, 308305, 272955, 206992, 235533, 235529, 307634, 308299, 308298, 307647, 260853, 223402, 307227, 307691, 307628, 307224, 307487, 307689, 307685, 307653, 307682, 307485, 307484, 210520, 307679, 307677, 307387, 307218, 307481, 235520, 305484, 307671, 307624, 307667, 210514, 210512, 307436, 210510, 307400, 307479, 307398, 305475, 235516, 307427, 258497, 307392, 307390, 307348, 307346, 251815, 251812, 251811, 251809, 305464, 223388, 305460, 305458, 306611, 251808, 235514, 223386, 251806, 307252, 179935, 307210, 307175, 235513, 235511, 223375, 307013, 251802, 307006, 251800, 210505, 278091, 307000, 251798, 251796, 251793, 179931, 179929, 614311, 306113, 306239, 251788, 223338, 305576, 301935, 306222, 179926, 210496, 109699, 306218, 179924, 223321, 223319, 223318, 306213, 235508, 223315, 306211, 263998, 306106, 306200, 306104, 306103, 179921, 306100, 305844, 306098, 305841, 305997, 123455, 123453, 305873, 305871, 305837, 305832, 305869, 305868, 305866, 210492, 305864, 305862, 210489, 223310, 235504, 223305, 305557, 223301, 223300, 223298, 223296, 223295, 179909, 223292, 223289, 179907, 223288, 223287, 223286, 223285, 223284, 223283, 299548, 299546, 210464, 305727, 235498, 235496, 235492, 235490, 210460, 305523, 305521, 305546, 304151, 303628, 179899, 210458, 179897, 179895, 179894, 179892, 266047, 179890, 305519, 266045, 266044, 210456, 223268, 179888, 223266, 305251, 210454, 305439, 305246, 210449, 173239, 173237, 302620, 223252, 305069, 305067, 304147, 303583, 304145, 300772, 303581, 223230, 223225, 304964, 302617, 179883, 302613, 302612, 253262, 251741, 304815, 253259, 253257, 304546, 304661, 210427, 235464, 253251, 262851, 253248, 253245, 303670, 304658, 304867, 304753, 251738, 304749, 301709, 304747, 304745, 304743, 21993, 21991, 304734, 251733, 304516, 304514, 210421, 304633, 210414, 235461, 303574, 235459, 235457, 304524, 235455, 301803, 98847, 301801, 191723, 303625, 210395, 303623, 303621, 210393, 210391, 299780, 299777, 299776, 303958, 299774, 62121, 303782, 303780, 303956, 303778, 303776, 303954, 304187, 303038, 210389, 210385, 303571, 303952, 210382, 304120, 303036, 210381, 300922, 300919, 251707, 301997, 303644, 210370, 302499, 303635, 303566, 300911, 303619, 303032, 303687, 303655, 266034, 300907, 303557, 300905, 210365, 210363, 300903, 251705, 301583, 251702, 210361, 261112, 302392, 303617, 302388, 303554, 303552, 303550, 302260, 302258, 210356, 210354, 210352, 210350, 302256, 300902, 179873, 191720, 191718, 303027, 191716, 302963, 210348, 210345, 210340, 303025, 303023, 303021, 303019, 303018, 303015, 303499, 179865, 179863, 303012, 303010, 251696, 302369, 302493, 302491, 302633, 288018, 141122, 302628, 302893, 288014, 302254, 302889, 302586, 288011, 302584, 302886, 302579, 210336, 302883, 302366, 302252, 294615, 302622, 302573, 302364, 210334, 302361, 251693, 179859, 301836, 302245, 179853, 302243, 302385, 210309, 302232, 302230, 302228, 210305, 179847, 251688, 251686, 302219, 302218, 302216, 210298, 302204, 302202, 302026, 301831, 301793, 266033, 266032, 251685, 251684, 266031, 266029, 210292, 262843, 301578, 301576, 301827, 301917, 301915, 301914, 301910, 301824, 301908, 301906, 301902, 301885, 301882, 210287, 210286, 210285, 267897, 301678, 301786, 301675, 301784, 301673, 301779, 301671, 301669, 301668, 301666, 300985, 301642, 299875, 21977, 251630, 291206, 300977, 300972, 269212, 291203, 179834, 300621, 300883, 298965, 298962, 300898, 267230, 267228, 210236, 267226, 267224, 299332, 299330, 267220, 299126, 299124, 299122, 299121, 267218, 300727, 299119, 299118, 300603, 179826, 299326, 299320, 299319, 179812, 299107, 299105, 299653, 299651, 251598, 299643, 251586, 299528, 299526, 299293, 299307, 298773, 299097, 299290, 299302, 298995, 262838, 223165, 179806, 179805, 298102, 298100, 298404, 179796, 298762, 298754, 298752, 298750, 298745, 298741, 210203, 266022, 266021, 266020, 210200, 223145, 296929, 296927, 223143, 104731, 104730, 210182, 298381, 298374, 298371, 298261, 298259, 210172, 298368, 210169, 210167, 210165, 294614, 179792, 297780, 179790, 251573, 179789, 297778, 179787, 179786, 179785, 179784, 179782, 179781, 179780, 179778, 179777, 179776, 297775, 297773, 265318, 296147, 297197, 251565, 298087, 298085, 297603, 298083, 298081, 288009, 298079, 288007, 297601, 297457, 298257, 298252, 210152, 288004, 266009, 266007, 296273, 266005, 266004, 279769, 266002, 298196, 279766, 266000, 279763, 179757, 265997, 265996, 265995, 179755, 265993, 265991, 265988, 298193, 265986, 210142, 265984, 265983, 265982, 265979, 210127, 296270, 265976, 296268, 298176, 265974, 296266, 265972, 288003, 297569, 297567, 297565, 297132, 297172, 297169, 297166, 297162, 297161, 265960, 297125, 265956, 265954, 265952, 265950, 205016, 265946, 294100, 251561, 210093, 210091, 296258, 210086, 210084, 210082, 210080, 205011, 291970, 295995, 295943, 295941, 295993, 183038, 174175, 173224, 210052, 174173, 104725, 295930, 210046, 174171, 183035, 295799, 174169, 183029, 295750, 295743, 295741, 295739, 251546, 295728, 291963, 251544, 251542, 251540, 251539, 295306, 287996, 191712, 287994, 295302, 287992, 223128, 251529, 291958, 295488, 295470, 294770, 295467, 291955, 251518, 295460, 295068, 293912, 295062, 293910, 109682, 175391, 295053, 261194, 261192, 261190, 173213, 109674, 109671, 195684, 295028, 251509, 251506, 251505, 294290, 223123, 293906, 294750, 294927, 109669, 294765, 262828, 294688, 294748, 292874, 109667, 294745, 109662, 294741, 294737, 109660, 109658, 294270, 294268, 294671, 294669, 294266, 109656, 294666, 294587, 261187, 109651, 109650, 210006, 294427, 174151, 294425, 294423, 294412, 174149, 294096, 174146, 294094, 174144, 292050, 293860, 294064, 262827, 104701, 262825, 291611, 131320, 291608, 291601, 291597, 104694, 104691, 291594, 262823, 291592, 291591, 291588, 291586, 251497, 179694, 104677, 292504, 292502, 292499, 292495, 269203, 160766, 173207, 173205, 291419, 292016, 292060, 292058, 291683, 209988, 292146, 292045, 291681, 292014, 291520, 291679, 292005, 291518, 209983, 292040, 292035, 287986, 291676, 287249, 287246, 288257, 287241, 287238, 284589, 284587, 287236, 284584, 288253, 291506, 288251, 288249, 288247, 288245, 291582, 291580, 284582, 291577, 291575, 284580, 291674, 288239, 291287, 289961, 291274, 291256, 291250, 268655, 268650, 209966, 287228, 290190, 290188, 104628, 179669, 288635, 104603, 288633, 288631, 290351, 290347, 285811, 289931, 285807, 179665, 290344, 290342, 290340, 290407, 104583, 290338, 290337, 290405, 285802, 104581, 285799, 104577, 104575, 290400, 290334, 290398, 290319, 104569, 290317, 290394, 290298, 288629, 290392, 290295, 290289, 290390, 290329, 290186, 288627, 290285, 289266, 290184, 288625, 288623, 284555, 104561, 183930, 104558, 209947, 185325, 179656, 289972, 188645, 209942, 289969, 289966, 209938, 268635, 268633, 289701, 289964, 289897, 289893, 289258, 289891, 289256, 289751, 289881, 289876, 289873, 185317, 185311, 289866, 289224, 289220, 263095, 289793, 288608, 289746, 289790, 289788, 289253, 289744, 289203, 263093, 289192, 263090, 288878, 209933, 263087, 288873, 288871, 173203, 288863, 185297, 223117, 287225, 288614, 262819, 288212, 262817, 288210, 223106, 223104, 223101, 183025, 185291, 223097, 195669, 257152, 257149, 257147, 257144, 287332, 195667, 179649, 179647, 287921, 287982, 288037, 288204, 209923, 287974, 273117, 287971, 287969, 288035, 262816, 284550, 287967, 262814, 287914, 263480, 288033, 287965, 104533, 288030, 287961, 285780, 287959, 288028, 287956, 209906, 288026, 287954, 287908, 204990, 204988, 179632, 285778, 263477, 179630, 204986, 285776, 179624, 287592, 287590, 287894, 104511, 287897, 173198, 104508, 204983, 104501, 204980, 209885, 179616, 209883, 179612, 209880, 179595, 287580, 179593, 209862, 179591, 209860, 173196, 173193, 179562, 266849, 173191, 173190, 173179, 209839, 183016, 173173, 173170, 209824, 285044, 173168, 183008, 179529, 209814, 285751, 183006, 209805, 209803, 182996, 209801, 285740, 182994, 131270, 131266, 262322, 131255, 285243, 284635, 182989, 182987, 131247, 173167, 270179, 262804, 209785, 284974, 173165, 173161, 284613, 284756, 284173, 173159, 284529, 173156, 284527, 173154, 173152, 275752, 284525, 284353, 259413, 209774, 209703, 276471, 262802, 279612, 279609, 209690, 179433, 276463, 179431, 276461, 276459, 278925, 278333, 278330, 278328, 278914, 278325, 279449, 279447, 278322, 276586, 279399, 278317, 277556, 262798, 209684, 209680, 278870, 209675, 209673, 266844, 266841, 278315, 279161, 266839, 279156, 278964, 278311, 261039, 261037, 261034, 266838, 209651, 266836, 277528, 277523, 277520, 277518, 277615, 277601, 277500, 277498, 267051, 277492, 209634, 156663, 277481, 277479, 277477, 269200, 269198, 269196, 269194, 179355, 276449, 209630, 277049, 277035, 209626, 261775, 276433, 179330, 104485, 104483, 104481, 276528, 104476, 104474, 276428, 261772, 104471, 276426, 104470, 261770, 276413, 179325, 266833, 179295, 179293, 209620, 262795, 262793, 141057, 266831, 266829, 141055, 262791, 266827, 262789, 271129, 262787, 262785, 266822, 271128, 271296, 266820, 262783, 272943, 202580, 272941, 209609, 266817, 266815, 266814, 266812, 266808, 266807, 272008, 209594, 272073, 272005, 271260, 272003, 272001, 272068, 209592, 271123, 259707, 262780, 259704, 141026, 262773, 271597, 266803, 262770, 262769, 266799, 266792, 179227, 268221, 179225, 262767, 179223, 265842, 265832, 265824, 271282, 265820, 265818, 271280, 271278, 207489, 265816, 223038, 179213, 179209, 179207, 223036, 207487, 183887, 271120, 262761, 262759, 271115, 271113, 156658, 179202, 207419, 156654, 156652, 271098, 271092, 207406, 209555, 268336, 266272, 122617, 179133, 269536, 266789, 267040, 267037, 266787, 179113, 265788, 267035, 179109, 179106, 266785, 179104, 179102, 266783, 209539, 179099, 179097, 266252, 174135, 179085, 270305, 270396, 269806, 270352, 267026, 269371, 179050, 141005, 270302, 141000, 178989, 178987, 202575, 178986, 178985, 178984, 178982, 178981, 266249, 256494, 182983, 202573, 262058, 262755, 262753, 270160, 262751, 262749, 235243, 262741, 262739, 262736, 262734, 270153, 270131, 270124, 178942, 178939, 270122, 178934, 269983, 178917, 186796, 178903, 209525, 262725, 178871, 178870, 178868, 178864, 178862, 178861, 209497, 143025, 268212, 178860, 209495, 209493, 143023, 269348, 269346, 183863, 183861, 143019, 269432, 269426, 81695, 269417, 182974, 182969, 209446, 269338, 182965, 269295, 269135, 269192, 269290, 143005, 269245, 269189, 209426, 206504, 182964, 269240, 269236, 269234, 269124, 269186, 269232, 269231, 269121, 269227, 269225, 182963, 269184, 269220, 182961, 269119, 182959, 269182, 269218, 269216, 269180, 269214, 269178, 182958, 182956, 182955, 182953, 262709, 262705, 182951, 209423, 209421, 262693, 262691, 209400, 209397, 268456, 268454, 178733, 268451, 268449, 268436, 268447, 268446, 268441, 268404, 178722, 178719, 70272, 178717, 268325, 268322, 268356, 268320, 268318, 268315, 264970, 261959, 261957, 261952, 264955, 264952, 261949, 261947, 261945, 261942, 235376, 209379, 178639, 104268, 178634, 104264, 104262, 266662, 268284, 268295, 178631, 268135, 266546, 268085, 267768, 268129, 263464, 182948, 182946, 268083, 182944, 268078, 209370, 267765, 267762, 267761, 267756, 268017, 263459, 267095, 267752, 267748, 263453, 267746, 267744, 267742, 267961, 267959, 267957, 267736, 209359, 178576, 178570, 178568, 209353, 267733, 178556, 178554, 265693, 267779, 267731, 265691, 178547, 178545, 178543, 178540, 178538, 267008, 249410, 267211, 267209, 266781, 267207, 266778, 263876, 267199, 263874, 265684, 178517, 178515, 178513, 265678, 266988, 265674, 178511, 265669, 265667, 265660, 265656, 265654, 265650, 178500, 178498, 267082, 235370, 266983, 266978, 265647, 266976, 267105, 265645, 267103, 235351, 235349, 178493, 178489, 266776, 178487, 266685, 266775, 266773, 266891, 266869, 249398, 266867, 266154, 266865, 266863, 259688, 178480, 266769, 266738, 259686, 259680, 265620, 178475, 178473, 178471, 178467, 265616, 178464, 178463, 266634, 178461, 265614, 265611, 109573, 109571, 266632, 209342, 209339, 266529, 178456, 178454, 256298, 266629, 209336, 259678, 259676, 259160, 259158, 209331, 266453, 266451, 266385, 266151, 178299, 266370, 178296, 266148, 178268, 178266, 178262, 178259, 209322, 209319, 266207, 266200, 266145, 266241, 254005, 178213, 178211, 254003, 254001, 261873, 253999, 266181, 265293, 178203, 247580, 266142, 265605, 178202, 258281, 265291, 265567, 265565, 265558, 265282, 261867, 253978, 261370, 262676, 264209, 261865, 209303, 262668, 262666, 262664, 262663, 262662, 262661, 262660, 262659, 178101, 262658, 262657, 261366, 262656, 262655, 262654, 262653, 262651, 265077, 178098, 261364, 178095, 178093, 258276, 178092, 258273, 178090, 258269, 203728, 265170, 258267, 178089, 258265, 253959, 265138, 253953, 265125, 253950, 261861, 253948, 195624, 178074, 178072, 131163, 178070, 178068, 178066, 265074, 251384, 261176, 178063, 178051, 253940, 253939, 253936, 261853, 257423, 257421, 257419, 253933, 253931, 186791, 186784, 186780, 253929, 186778, 186773, 186770, 178030, 186768, 178028, 260418, 257409, 186765, 178025, 178023, 257406, 186763, 178015, 178013, 186762, 178011, 257402, 186761, 186759, 257400, 186758, 253927, 253925, 253923, 253921, 253919, 257398, 253917, 186755, 253915, 257396, 257394, 257393, 257389, 253913, 253911, 253908, 186754, 186752, 209299, 186750, 186748, 209295, 177971, 186742, 186741, 104226, 177968, 186738, 104213, 258260, 209292, 104210, 177938, 258251, 258249, 177866, 177863, 177861, 177858, 177855, 177839, 264526, 264522, 264521, 264518, 264516, 264514, 264582, 264512, 261836, 264510, 262158, 177827, 264507, 104199, 261832, 177824, 262149, 259203, 131135, 131132, 259193, 262141, 262134, 177795, 262131, 177793, 264190, 263421, 264146, 122600, 122598, 263171, 263169, 263821, 263860, 263816, 263845, 263843, 263840, 263837, 263831, 209289, 263082, 263807, 209287, 209285, 177756, 177752, 209282, 209280, 263703, 263145, 177737, 177734, 256524, 263745, 263743, 262650, 262649, 263541, 177731, 177729, 177727, 177721, 177717, 209272, 185773, 263662, 186723, 262647, 186720, 185770, 186718, 177691, 263407, 263599, 186710, 185764, 177683, 186702, 263535, 263532, 263529, 262646, 209269, 186699, 262643, 263505, 263401, 263399, 263397, 263394, 263392, 263390, 262578, 263383, 209261, 262642, 263380, 262640, 263378, 263376, 186696, 262572, 261815, 209257, 186694, 262570, 263042, 262910, 261806, 261803, 262638, 262636, 263250, 261801, 262635, 262634, 186692, 186691, 262553, 263106, 262627, 263034, 186683, 262625, 177639, 186681, 177637, 263077, 186680, 262281, 262530, 262623, 262279, 262528, 262622, 262907, 262621, 177634, 262526, 262615, 262614, 186679, 262521, 262607, 262886, 262604, 262508, 262883, 254827, 262602, 262600, 262599, 262593, 262502, 177615, 222932, 257728, 257724, 177607, 209248, 261940, 262360, 222930, 222928, 261976, 318854, 262357, 261937, 262023, 177589, 262258, 262256, 262300, 262296, 262253, 262345, 177587, 177585, 262342, 262340, 177567, 177565, 177563, 261133, 177556, 177547, 261930, 261928, 261926, 185752, 260363, 261914, 261912, 261968, 318846, 261910, 209215, 262052, 262049, 261583, 261737, 255953, 260359, 260357, 255949, 260355, 260345, 261670, 177487, 177482, 177477, 177475, 256702, 186663, 186660, 186658, 177474, 186656, 259058, 186653, 185745, 185743, 186649, 185740, 260691, 177466, 259051, 186640, 256697, 260324, 256695, 260321, 260311, 260308, 261579, 261403, 261401, 261398, 260689, 261489, 250705, 260687, 177405, 260683, 183708, 177400, 209192, 209190, 261347, 260681, 261435, 260268, 261345, 222901, 261342, 261340, 261337, 261394, 261334, 260260, 261357, 131053, 222896, 260258, 209188, 209185, 260255, 131049, 261388, 257697, 261355, 261386, 186615, 257695, 186612, 177378, 222894, 222892, 257690, 177367, 177365, 259148, 177354, 261333, 260248, 209179, 261175, 261171, 251289, 177351, 260243, 235348, 260213, 209171, 209169, 261170, 260207, 209167, 259634, 186604, 186602, 186599, 195591, 259632, 186596, 261167, 261165, 186593, 261130, 261128, 261161, 209164, 260192, 104138, 186583, 260190, 260846, 261021, 235343, 261119, 235341, 235339, 261019, 261117, 259348, 260842, 235325, 260509, 235321, 186581, 235319, 260186, 260504, 260183, 260832, 260180, 193208, 260177, 260829, 260501, 260825, 260173, 235311, 186578, 260170, 235308, 235306, 260166, 259346, 209158, 186577, 260608, 209154, 259343, 235304, 209152, 104097, 260485, 104092, 259341, 235290, 104085, 186571, 260482, 260478, 177268, 259339, 177266, 177264, 177259, 177256, 177254, 260133, 260130, 177249, 177245, 209149, 260121, 186553, 258399, 186551, 209146, 186549, 259337, 209141, 177239, 177236, 259868, 209139, 260078, 255946, 260074, 260028, 255944, 260059, 260055, 260019, 177196, 260016, 259191, 209133, 186542, 259896, 259992, 259189, 259943, 259940, 209129, 186536, 186534, 258023, 258021, 259136, 177150, 259888, 258841, 258795, 204509, 186530, 259852, 259850, 259848, 186519, 259784, 259782, 128853, 128852, 259780, 186512, 186507, 259674, 259672, 259615, 204499, 204497, 259670, 259574, 259602, 259666, 259280, 259600, 259268, 259032, 186484, 259263, 259564, 259174, 186482, 259029, 259562, 259560, 259334, 259332, 259474, 259472, 259471, 259465, 259462, 259459, 259457, 259330, 249392, 249390, 249389, 209125, 186443, 186440, 249386, 259353, 259326, 256483, 257999, 259119, 176994, 209114, 209112, 258986, 259064, 176988, 176981, 259062, 258983, 176976, 176975, 258979, 176972, 257995, 258974, 258884, 258838, 258543, 258541, 258539, 258835, 258834, 258833, 258832, 258831, 258830, 258829, 222874, 258538, 257375, 256470, 222871, 258536, 202541, 258533, 256465, 222867, 222865, 256460, 254583, 128841, 251261, 258439, 258430, 256014, 258376, 258301, 258374, 209069, 176919, 257338, 249206, 209057, 258358, 209049, 258354, 209039, 258247, 209035, 130977, 130974, 256345, 253095, 249629, 130971, 257462, 257984, 257980, 176899, 176897, 176895, 258036, 258191, 176865, 176816, 176814, 257875, 257819, 222850, 222825, 209022, 222822, 222807, 184597, 184593, 257276, 222805, 254281, 254582, 257274, 256440, 256438, 209012, 257539, 176784, 257475, 257259, 257500, 255587, 257451, 256431, 257448, 222798, 222796, 257446, 257006, 176774, 257004, 257444, 257002, 257442, 222794, 256842, 256617, 222792, 257480, 255584, 209003, 257248, 208999, 256429, 256578, 257440, 255940, 254278, 256094, 204917, 256029, 255037, 204915, 186296, 204913, 255936, 250911, 255934, 255144, 140922, 255033, 186291, 255930, 207715, 255879, 255102, 255966, 255964, 255876, 255928, 255567, 255562, 255832, 255097, 255341, 130880, 222753, 255782, 255132, 255130, 255537, 255780, 255777, 255535, 255532, 255774, 255770, 255529, 255029, 255271, 255088, 201234, 255027, 255086, 255025, 255023, 255216, 255079, 255077, 255210, 255068, 255113, 255064, 254979, 255018, 204484, 255016, 255047, 254241, 254929, 254928, 254925, 254918, 254916, 254912, 254905, 254901, 254793, 192093, 253904, 192091, 249125, 254788, 249123, 249120, 253893, 254475, 254806, 254867, 254818, 254231, 253887, 254226, 254572, 254570, 254218, 254565, 247538, 191522, 249607, 254498, 254459, 254495, 186266, 254207, 254493, 254491, 186264, 254480, 186261, 254205, 186260, 186252, 254203, 222745, 250897, 253322, 250895, 250893, 250891, 250889, 254197, 250886, 250884, 250882, 206649, 186228, 250876, 176647, 250874, 250872, 253851, 248635, 250870, 253846, 206644, 253844, 176645, 248631, 176642, 248625, 248623, 253084, 250868, 253430, 253390, 253081, 253388, 253427, 186223, 253079, 208906, 208904, 253117, 251115, 253186, 253202, 253134, 253199, 253070, 253068, 250862, 250852, 249840, 250834, 251081, 250832, 251079, 250823, 250821, 250909, 250819, 250817, 188607, 250813, 188604, 188602, 249651, 250747, 248262, 250741, 250673, 250627, 249648, 249645, 207604, 176529, 207602, 184982, 184980, 208830, 207600, 249825, 184973, 249362, 130802, 249784, 184968, 249811, 249575, 186168, 249349, 207598, 249632, 249565, 248536, 249439, 249437, 249115, 176492, 248858, 248499, 248487, 249310, 176487, 248484, 248481, 248478, 176477, 207595, 176462, 248844, 249074, 248173, 176458, 176457, 249100, 130763, 249096, 249093, 248142, 248140, 248462, 248460, 248429, 248135, 176415, 248458, 192645, 176316, 206598, 207221, 207217, 185738, 207169, 207165, 185736, 206502, 206589, 206813, 206877, 206904, 206916, 182522, 185733, 206914, 182520, 206911, 182518, 206869, 206901, 206278, 206276, 182512, 206798, 206274, 191899, 204873, 185730, 204547, 202529, 204545, 202526, 204407, 204678, 204542, 191669, 202521, 173150, 202830, 176297, 185717, 176294, 202410, 203999, 203160, 188052, 203157, 202408, 203509, 203316, 202403, 203309, 202503, 201662, 202400, 202398, 202396, 202391, 202389, 190927, 181186, 201430, 176281, 176279, 176277, 201411, 173615, 201289, 194064, 195338, 181182, 189830, 195336, 195331, 194041, 194038, 194035, 195328, 195228, 195281, 195225, 195291, 195293, 195266, 195108, 195106, 195218, 195157, 195104, 195102, 159265, 195084, 195206, 195153, 195149, 195202, 195136, 194857, 195098, 195081, 195078, 181178, 195075, 194633, 174704, 181176, 181173, 194631, 195016, 181171, 194763, 156635, 194682, 156633, 156631, 194680, 194678, 156629, 194675, 156626, 156624, 194672, 194670, 194669, 194665, 194663, 194661, 194330, 194599, 194597, 194629, 194593, 194615, 193968, 193641, 193538, 193536, 193309, 193254, 193250, 193457, 193248, 192445, 193305, 193246, 193455, 193125, 193528, 192709, 192441, 192473, 192707, 192471, 192704, 192702, 192665, 192663, 181168, 181166, 192643, 188471, 188468, 103762, 188466, 103760, 192553, 192488, 192461, 103748, 103746, 192439, 103744, 156622, 192424, 192435, 192429, 192418, 192400, 192398, 156620, 156618, 156616, 103741, 156614, 176254, 173148, 191074, 156612, 191072, 173146, 176251, 176249, 191070, 192290, 192394, 173145, 156610, 156609, 156607, 192270, 191618, 191613, 191611, 192080, 192265, 192186, 191607, 192251, 176248, 176246, 190924, 191601, 187803, 173613, 176244, 176243, 143512, 176239, 176236, 176233, 176231, 176229, 191912, 173142, 176226, 173140, 190914, 176223, 176221, 176219, 173138, 191384, 190912, 191382, 191852, 190910, 190873, 191591, 191836, 191312, 191850, 191570, 191878, 191380, 190900, 190153, 190421, 176051, 190397, 176049, 176047, 176043, 190197, 176041, 163881, 176039, 187786, 185138, 187777, 176026, 182480, 187775, 189842, 176002, 189702, 175999, 188008, 189906, 188006, 189840, 189904, 186968, 188003, 187999, 189900, 187997, 187994, 187992, 182465, 189835, 189845, 182463, 189817, 175996, 189694, 182460, 189175, 189692, 189173, 175993, 189524, 189521, 189171, 188048, 189680, 189679, 189699, 175992, 189685, 189311, 175987, 174601, 181164, 181162, 188218, 188591, 189307, 187980, 189673, 189672, 189670, 166583, 166580, 189305, 189502, 188588, 189518, 181158, 166374, 188216, 188044, 181156, 188324, 188323, 188321, 188368, 188317, 188314, 188085, 188308, 172603, 188241, 172601, 187949, 166363, 188239, 188038, 188211, 188237, 188235, 188209, 188194, 188206, 187977, 187975, 188204, 188074, 188072, 188069, 185011, 185009, 188034, 187743, 187990, 187740, 175971, 175969, 187986, 187940, 187938, 187931, 153637, 187825, 175963, 187715, 187452, 175956, 175954, 185714, 185712, 175952, 175950, 155944, 155942, 155940, 163050, 186907, 186905, 186903, 185904, 185895, 155443, 185851, 185847, 185832, 185628, 185626, 185709, 185624, 185623, 185706, 175919, 155437, 155934, 183643, 185620, 185566, 185642, 155435, 185640, 183640, 185579, 185517, 184925, 185515, 185563, 184523, 155431, 184521, 184517, 174544, 185510, 174536, 174534, 174531, 155427, 155425, 170861, 182801, 155423, 182799, 175914, 184513, 163037, 184512, 185224, 184508, 163035, 185218, 175902, 184923, 175900, 175898, 175897, 185416, 181543, 185406, 184693, 185403, 185372, 185369, 185213, 185182, 185004, 182877, 185002, 185000, 183991, 185175, 185173, 183986, 184915, 184896, 185153, 185109, 183638, 184966, 185117, 185104, 184965, 184963, 183983, 184912, 175891, 175889, 175887, 184910, 162278, 175885, 172590, 175883, 172588, 172583, 172581, 175881, 184908, 175879, 175877, 172579, 172577, 184818, 184903, 172574, 175873, 172572, 184815, 184900, 184813, 184898, 184890, 184729, 175871, 175869, 184792, 184810, 184718, 184586, 184490, 184488, 184807, 184680, 184710, 184468, 184315, 184463, 184644, 184641, 184452, 184440, 184434, 184422, 184418, 184411, 184409, 184404, 184389, 184371, 184366, 184311, 175867, 163032, 168069, 168066, 183595, 168063, 183687, 183621, 183681, 182851, 182849, 183571, 183593, 183256, 181141, 181139, 181136, 182792, 181133, 183218, 183251, 183249, 183216, 181131, 181128, 181126, 172430, 182219, 173137, 182214, 173135, 175845, 182777, 182355, 175843, 175841, 182352, 181469, 175839, 182697, 182210, 182773, 182769, 182767, 168059, 182761, 182692, 182691, 182687, 182686, 182425, 172715, 182759, 182757, 182755, 182751, 182676, 182533, 182414, 181459, 182410, 182407, 182531, 182346, 175832, 175278, 182342, 175830, 163553, 163551, 175829, 175828, 175367, 163574, 182178, 163571, 175822, 103647, 163569, 181456, 181607, 175818, 175302, 175300, 163567, 175298, 175296, 181964, 175294, 175801, 175799, 181961, 175794, 181124, 181122, 181120, 181117, 181115, 163565, 181576, 181258, 181255, 175771, 175767, 181250, 181338, 181248, 181451, 181447, 181443, 181111, 163562, 181236, 181108, 175755, 175747, 181228, 163558, 175719, 175718, 175707, 175186, 175184, 175182, 175660, 175246, 175180, 175658, 175178, 175655, 175176, 175244, 175362, 175095, 175360, 173866, 175356, 175335, 175353, 175332, 175321, 175291, 175158, 175093, 175288, 173747, 175091, 175243, 175156, 174450, 174790, 137922, 174448, 174787, 175018, 173817, 174785, 174783, 173815, 174441, 174916, 174091, 174495, 157647, 174913, 174492, 174087, 174907, 174490, 174903, 157645, 157643, 174436, 174487, 150486, 174434, 174484, 150484, 174073, 174038, 173407, 173601, 173722, 137921, 173635, 173133, 173598, 173131, 173595, 173593, 173334, 173322, 173128, 173319, 173126, 173124, 173315, 173122, 173120, 173312, 173311, 173289, 162004, 161999, 173011, 172971, 172969, 100006, 173006, 173118, 173117, 173284, 173114, 172961, 161994, 168241, 173112, 173111, 172711, 168238, 168236, 168234, 172705, 172702, 172700, 172419, 140674, 172698, 172696, 172694, 172693, 171617, 172690, 168480, 171599, 168477, 168474, 172412, 172394, 172407, 172405, 171590, 172435, 172384, 137906, 171954, 157639, 157638, 171527, 137904, 171525, 137901, 171523, 137898, 171521, 172309, 157636, 172224, 170087, 171570, 168225, 171558, 171950, 168032, 166964, 163021, 157634, 167209, 157632, 166361, 166938, 168418, 168417, 168414, 168410, 168408, 168025, 168405, 168259, 168402, 168023, 168314, 167205, 168113, 166355, 168110, 168109, 166353, 168106, 166351, 164795, 164794, 164793, 167202, 153151, 167335, 167199, 167196, 167237, 167192, 167185, 167220, 166934, 166927, 103638, 166575, 166445, 166441, 166439, 166435, 165556, 164554, 163215, 164175, 163210, 163209, 164035, 163207, 163200, 164033, 163877, 163198, 163191, 163014, 163507, 163506, 163362, 163502, 163107, 163121, 163088, 163009, 43783, 162038, 162035, 162593, 161977, 162137, 162393, 162135, 162047, 144785, 162028, 162041, 162026, 162025, 162024, 162022, 162020, 162017, 159894, 161971, 161902, 161443, 161379, 158943, 161323, 161372, 161366, 149478, 161318, 161311, 159253, 143772, 160337, 160335, 160063, 160060, 160058, 159802, 159800, 159798, 160053, 160049, 159796, 160048, 160046, 160045, 160042, 160040, 160039, 160037, 160035, 157629, 157627, 155952, 159708, 159706, 157625, 157622, 157619, 159496, 157617, 159136, 157615, 157612, 157611, 157717, 157679, 157064, 157609, 157062, 157607, 157605, 157714, 123009, 157270, 157677, 157602, 156738, 156735, 156733, 156962, 43779, 156731, 156800, 156797, 156794, 156791, 156725, 156044, 156594, 156043, 156363, 156361, 156041, 156592, 156038, 156359, 156036, 156035, 152890, 156033, 156596, 152888, 152886, 152884, 152882, 156277, 156342, 156339, 156334, 156332, 156328, 156324, 156321, 156317, 156193, 156272, 156271, 152880, 153932, 153982, 155948, 156061, 150474, 152852, 152878, 152876, 152874, 152872, 152870, 154912, 154422, 154417, 153058, 152868, 152867, 152864, 154436, 154432, 154430, 154402, 154399, 152861, 153876, 152859, 152854, 153620, 146142, 153463, 153018, 137753, 137613, 151749, 151747, 151745, 151742, 151740, 146140, 146139, 137751, 146137, 151736, 151528, 151527, 151526, 151510, 151505, 152052, 137248, 152050, 151733, 151502, 149643, 151500, 146135, 151371, 151721, 151242, 151482, 151719, 151478, 151363, 151476, 151474, 151472, 151468, 151466, 151464, 151463, 151360, 151407, 151218, 151355, 151405, 151352, 151402, 151216, 151290, 147246))
Run Time: 0.533748
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 6352 | |
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 | | | | | 6352 | |
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 (27137, 26033, 17799, 17706, 16765, 16465, 16442, 16130, 16119, 16018, 15521, 15843, 14093, 13964, 13693, 13483, 13407, 13316, 13280, 12947, 12863, 12569, 12387, 12147, 12127, 11963, 11768, 11599, 11508, 11482, 11451, 11415, 11066, 10813, 10755, 10754, 10593, 10591, 10434, 10336, 10332, 10326, 10318))
Run Time: 0.003080
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 43 | 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 (563408, 423318, 431849, 526010, 526006, 244397, 431685, 333853, 529367, 244387, 323618, 333846, 244384, 233313, 529364, 539490, 560472, 233277, 525989, 529349, 529348, 525987, 220142, 525970, 525965, 529340, 525963, 525955, 525952, 325863, 220136, 529337, 525949, 431660, 525945, 252871, 525937, 220130, 529335, 529332, 529330, 414563, 529328, 560511, 560509, 560507, 408802, 408801, 310564, 355911, 233272, 502986, 503445, 353147, 353146, 322630, 502984, 325862, 414552, 529323, 220123, 529321, 220121, 431643, 560615, 560610, 560608, 233262, 233260, 431636, 529318, 553334, 557445, 431634, 529316, 560600, 557670, 560598, 333836, 333833, 333830, 333828, 529315, 333826, 560696, 312328, 560694, 312326, 560673, 560337, 518720, 560579, 560574, 431619, 312322, 312320, 312318, 431615, 537699, 431611, 537696, 312316, 431609, 347967, 537694, 431601, 549986, 560222, 331354, 518713, 323616, 529263, 405790, 431362, 557995, 551100, 367508, 529241, 557988, 405785, 524556, 243855, 524537, 535588, 535577, 384230, 535575, 624800, 524523, 524502, 388272, 524496, 528615, 524393, 524391, 524388, 524385, 524381, 526568, 219315, 524377, 524368, 524365, 219310, 219309, 524360, 528601, 333750, 333747, 333745, 333743, 467643, 524352, 527423, 524338, 232372, 419460, 428778, 528260, 219298, 528238, 528310, 524309, 524303, 524301, 428762, 526557, 524298, 528272, 524290, 524286, 524284, 524282, 524280, 524276, 524272, 524270, 524268, 428760, 524251, 528150, 524248, 479691, 524244, 524241, 524235, 524232, 524230, 524222, 524217, 243803, 309321, 524215, 428757, 428751, 309318, 527410, 527404, 526911, 527240, 328424, 219255, 527231, 527229, 526712, 522780, 524192, 354475, 354473, 457674, 219237, 453519, 199922, 527083, 323591, 323589, 323587, 323585, 323583, 428705, 485554, 354472, 428703, 219233, 414870, 219229, 219226, 108587, 219214, 404700, 404698, 412034, 412031, 509203, 518475, 509103, 509198, 509192, 509187, 509185, 509181, 480587, 480579, 322626, 375963, 323513, 618331, 337004, 421748, 468891, 242330, 408783, 468885, 322624, 355844, 476570, 230422, 110309, 217428, 365208, 11900, 474851, 478940, 217373, 217369, 107947, 107936, 107934, 107928, 107923, 230351, 107917, 230343, 468880, 458787, 466107, 216908, 56448, 464747, 464744, 464741, 464732, 464433, 463988, 463985, 326950, 326948, 326945, 241645, 241642, 241639, 241637, 241634, 241632, 241629, 241626, 365191, 241624, 461869, 229812, 216750, 216748, 459596, 216745, 458554, 459594, 216743, 216741, 241606, 459591, 216739, 459589, 216737, 458550, 241602, 241594, 216710, 458544, 241590, 458542, 216707, 461358, 461054, 459650, 461116, 460922, 460213, 460211, 460920, 460720, 461045, 461043, 461039, 460916, 216697, 423257, 241568, 216695, 458537, 241565, 460654, 423255, 458534, 460370, 460366, 460360, 229774, 450816, 450815, 454326, 454323, 355822, 375297, 356394, 459838, 457444, 459835, 385838, 458261, 617914, 617903, 132353, 457163, 454145, 454123, 454118, 453001, 408308, 408257, 382101, 215425, 396980, 401280, 393535, 401277, 396976, 400943, 384528, 401253, 215403, 400899, 228113, 401215, 401274, 399977, 215293, 395728, 395983, 395725, 390115, 393370, 392280, 394186, 302055, 394328, 238905, 308747, 384519, 308722, 381496, 156245, 106463, 383537, 376839, 106459, 365162, 238688, 238631, 382808, 227368, 227366, 227364, 384723, 94281, 347881, 376074, 369639, 384706, 94280, 94278, 384594, 384663, 188116, 384121, 384118, 384116, 384114, 363002, 308689, 214625, 227353, 238620, 308687, 384583, 363000, 384514, 384112, 227347, 379763, 357962, 238611, 214618, 320286, 308678, 308673, 214131, 374902, 374515, 373067, 214057, 373100, 373020, 373018, 372520, 372491, 348849, 308600, 348846, 326942, 326939, 364808, 371114, 370961, 365113, 369710, 370411, 370409, 326936, 205298, 370401, 326934, 205296, 326932, 326931, 326929, 326926, 326924, 326922, 326920, 326916, 326914, 369631, 326909, 369629, 326907, 326904, 326900, 326894, 364804, 326892, 362003, 303222, 237992, 369365, 366396, 368499, 213668, 350278, 366796, 366794, 366787, 237933, 237927, 366606, 180813, 237903, 365826, 333378, 366426, 237898, 309923, 366394, 226502, 226500, 365815, 365645, 364801, 226480, 359798, 364799, 361028, 364797, 364057, 361084, 364794, 226453, 261215, 226451, 213506, 328834, 364051, 364792, 226448, 226442, 105943, 364531, 364844, 213494, 364790, 364788, 364842, 360697, 105941, 364785, 364529, 364782, 364525, 364522, 364534, 364519, 226429, 303177, 303175, 354402, 303173, 328247, 361553, 354400, 335677, 277455, 277453, 363661, 363645, 363539, 363502, 17715, 360691, 226348, 360683, 360674, 362483, 226243, 237576, 226239, 361065, 357092, 360845, 360542, 360841, 341095, 360539, 341093, 333352, 341091, 341089, 356772, 341086, 356770, 356768, 350320, 360537, 335781, 205288, 213256, 348233, 358942, 360604, 360599, 360602, 360534, 226161, 333348, 346797, 360596, 346795, 360319, 360391, 360549, 303080, 358868, 237485, 237483, 358866, 359567, 358863, 357038, 359365, 226019, 359363, 226017, 359546, 56796, 226011, 359543, 357748, 358858, 237476, 359405, 359541, 359539, 226009, 226008, 358194, 226005, 359404, 237471, 357746, 359399, 358190, 359358, 357980, 359028, 356246, 180746, 105713, 105700, 359025, 180744, 357978, 356244, 356242, 180741, 359016, 358784, 356598, 358782, 354710, 207502, 213161, 225975, 358779, 213158, 207500, 359041, 225971, 359011, 358705, 308521, 213155, 358777, 358774, 354851, 358772, 358770, 354849, 17709, 354848, 237439, 358764, 213125, 128957, 225962, 358760, 354844, 225959, 213119, 225955, 358849, 354841, 358754, 358752, 354839, 358748, 358581, 358577, 358575, 358574, 237410, 358568, 336004, 225932, 237406, 358280, 358557, 237397, 225928, 358606, 237395, 56794, 357995, 355490, 294190, 358315, 213060, 358179, 358172, 356765, 358162, 357692, 356762, 357690, 352799, 357688, 357720, 357670, 357823, 357821, 357798, 357667, 357718, 357022, 212999, 356755, 357716, 180739, 357565, 356436, 333307, 355464, 356851, 356957, 357013, 357237, 357159, 315996, 355219, 237282, 355453, 357233, 357225, 357003, 355451, 356840, 356839, 356836, 356832, 355449, 356830, 225804, 356827, 355444, 355440, 356824, 348225, 356751, 225797, 355438, 355436, 337399, 356820, 356817, 337397, 357069, 356814, 356936, 356812, 356746, 348222, 237277, 354704, 225791, 356802, 354702, 356799, 105656, 225789, 105654, 348219, 225786, 105652, 212957, 328241, 327149, 356549, 356481, 355104, 355101, 355099, 355097, 355095, 354308, 352661, 180721, 237259, 333292, 354835, 180713, 212897, 212895, 225737, 225733, 355217, 225729, 356533, 212891, 180704, 180700, 191796, 212889, 356228, 343348, 343346, 355215, 356528, 191794, 180691, 355213, 343341, 355211, 105632, 105628, 237246, 105626, 105624, 225712, 212868, 225708, 212866, 191785, 356221, 105622, 212862, 105620, 225703, 212856, 105617, 333291, 191782, 105614, 333289, 191780, 333287, 191778, 333285, 356431, 237238, 212846, 333282, 354387, 333279, 212835, 252506, 212833, 355206, 356208, 212830, 225657, 346200, 354306, 354828, 354383, 212828, 355431, 354826, 355514, 237218, 355426, 356193, 225647, 354819, 354379, 180684, 237212, 225645, 237210, 180682, 180679, 354376, 354817, 237208, 225638, 225636, 225634, 225632, 237200, 350072, 225617, 350069, 354303, 350067, 354375, 350065, 346793, 191763, 354750, 225588, 355186, 355177, 355085, 354814, 266853, 354374, 354075, 354691, 354805, 180649, 180647, 348819, 354667, 354661, 225569, 354659, 354657, 354655, 348817, 354747, 348815, 354371, 354370, 354653, 354651, 348813, 353582, 105606, 268857, 354611, 237191, 225564, 59843, 191759, 353579, 225561, 105592, 105590, 105586, 212766, 237179, 353576, 225554, 353571, 59841, 105584, 237173, 44851, 348805, 225548, 237164, 180640, 180638, 348803, 354369, 308487, 348801, 354365, 308485, 347461, 348799, 348796, 352652, 352912, 354300, 352910, 310307, 348793, 354321, 237155, 225540, 354318, 225538, 225536, 354298, 354060, 353569, 352650, 354296, 354294, 354290, 354325, 354226, 354180, 180611, 180609, 352903, 310305, 180607, 352647, 354008, 334646, 353440, 180596, 352769, 180585, 353812, 105541, 105539, 348791, 105536, 352767, 256190, 345122, 347716, 352765, 347592, 237138, 348789, 345115, 256706, 180560, 191751, 352895, 237132, 191749, 191747, 191745, 191743, 353632, 351346, 353774, 351345, 353624, 261211, 353621, 353604, 225500, 353730, 353602, 353600, 353598, 353564, 353562, 59833, 105523, 346772, 346770, 346768, 352950, 59831, 348782, 346766, 105513, 353290, 225496, 348779, 310111, 338604, 352853, 252478, 180559, 352645, 310293, 349882, 349880, 353389, 353420, 105512, 212714, 349875, 212711, 212709, 352947, 352642, 352881, 310281, 352639, 351361, 105504, 347455, 352637, 105502, 352848, 352632, 105500, 353202, 105496, 352995, 352993, 353197, 353194, 352991, 353191, 352943, 353189, 352989, 105488, 352987, 212704, 180552, 180549, 180547, 180545, 180541, 180536, 180534, 180532, 180524, 180522, 180520, 322615, 352983, 352869, 352841, 237106, 225454, 180503, 352751, 225452, 180501, 352749, 237102, 237100, 310269, 225450, 348777, 352745, 237097, 237095, 352695, 352609, 350302, 212690, 350517, 310264, 212685, 348775, 225425, 351769, 351767, 351765, 212652, 350274, 350001, 303066, 352084, 352080, 212647, 237046, 303063, 351964, 351962, 352070, 352001, 268806, 351679, 351920, 225393, 351992, 351989, 345274, 351955, 351915, 237038, 345272, 345270, 225377, 345268, 225374, 345266, 338592, 351594, 237021, 351443, 351574, 338588, 338586, 339260, 350273, 105436, 225319, 351500, 339258, 350127, 105432, 350271, 350125, 225316, 351341, 351338, 303054, 303052, 348774, 351369, 225296, 112993, 112990, 112988, 349857, 252449, 350504, 345336, 303044, 345333, 345331, 333245, 105423, 346180, 180452, 350414, 105417, 327142, 350656, 350654, 225249, 350652, 350650, 252440, 350648, 350646, 350600, 350644, 350113, 350598, 350111, 350463, 225238, 350413, 350365, 350242, 350240, 225236, 350423, 327133, 327131, 350291, 347589, 350107, 350232, 347585, 350227, 349998, 350146, 327129, 347582, 349996, 347580, 350190, 347576, 349993, 212547, 212545, 212536, 347573, 349988, 277414, 350100, 59824, 212529, 180451, 236993, 350023, 334640, 349981, 59820, 334632, 349974, 333228, 333226, 333224, 212526, 212524, 212521, 349871, 131682, 349885, 349869, 225206, 349840, 343430, 333219, 347568, 333215, 333210, 333207, 191735, 349684, 333205, 347555, 348154, 348152, 347549, 348904, 348880, 348878, 348898, 348894, 346173, 346170, 348875, 348891, 348889, 344159, 310239, 334314, 347545, 348479, 310235, 348477, 348717, 348715, 348714, 212507, 212505, 310233, 326491, 348645, 212502, 348643, 326488, 347544, 347069, 348513, 348511, 348474, 348543, 348541, 348539, 348537, 236956, 212499, 236954, 348534, 333204, 348531, 343426, 348468, 343424, 348466, 348464, 344232, 236951, 236949, 348462, 344225, 344222, 348459, 348525, 348457, 347448, 212493, 344220, 236947, 344009, 258860, 344007, 212490, 334690, 212488, 258858, 348453, 273852, 348131, 348130, 348109, 277390, 236913, 236910, 236908, 225127, 225120, 333202, 333200, 347790, 347787, 347783, 343410, 347777, 225106, 347761, 347775, 347758, 347773, 347711, 347709, 347771, 345011, 347707, 236893, 347430, 347426, 347391, 343994, 346717, 321641, 346556, 333193, 346554, 346552, 225060, 346636, 346549, 345742, 346545, 225058, 346601, 346599, 346581, 205255, 344614, 333178, 337917, 346432, 346068, 236841, 252375, 345829, 345851, 225012, 345401, 212339, 212336, 105394, 212334, 212332, 212326, 345078, 345209, 345008, 345004, 345002, 345144, 345000, 340834, 343992, 344991, 342680, 344985, 344680, 344791, 236813, 344604, 212309, 236811, 342669, 342663, 273834, 212295, 342660, 236808, 342658, 236806, 342656, 344591, 295961, 295959, 344081, 344421, 344108, 344105, 344102, 344272, 342654, 341071, 224881, 341069, 331880, 341919, 224861, 224859, 342509, 342505, 224857, 342502, 236740, 342500, 224854, 342495, 342492, 236736, 342488, 342296, 236733, 262876, 236731, 342399, 342478, 342293, 256158, 212180, 341552, 340215, 273809, 340212, 273806, 205243, 212039, 340120, 224661, 340475, 340461, 252286, 211983, 211979, 252285, 211977, 252283, 211971, 338256, 338843, 105266, 338840, 236477, 236475, 308414, 339490, 339488, 339421, 339255, 339419, 339417, 339604, 339607, 338520, 338252, 339140, 339037, 338518, 338516, 338250, 338249, 339240, 338514, 236450, 339224, 339236, 325264, 109855, 236448, 339222, 339220, 338512, 339206, 338851, 339102, 339136, 338509, 339100, 339134, 338061, 334516, 277369, 334513, 252207, 252206, 338678, 236429, 328663, 211892, 211890, 338157, 205205, 224541, 224538, 205202, 324123, 205200, 205198, 338501, 205193, 338408, 205191, 338406, 205185, 338148, 338434, 338387, 211840, 338357, 338244, 338242, 337556, 336081, 252186, 337553, 336079, 224523, 337887, 224521, 337884, 331681, 337880, 337550, 252183, 337878, 252180, 338240, 338202, 205178, 205176, 211820, 279063, 338027, 224519, 337528, 224517, 338138, 211800, 277359, 224514, 315626, 211788, 105256, 211783, 329451, 335641, 211779, 337875, 277357, 205175, 105254, 338051, 277355, 277353, 337872, 337906, 105247, 337737, 180406, 330752, 224501, 337781, 211744, 105243, 333156, 337735, 333154, 313652, 236347, 337441, 236345, 337439, 161697, 337402, 224491, 337369, 332220, 332214, 336945, 336935, 336931, 205163, 336917, 205161, 333142, 333138, 333135, 236323, 277347, 333133, 336899, 277346, 277342, 336094, 277340, 277334, 236304, 328815, 336352, 335919, 336074, 336344, 336083, 336342, 195989, 195987, 98413, 300820, 334871, 336022, 252156, 335462, 211643, 236264, 333129, 328811, 252152, 277332, 333127, 236252, 334197, 277330, 277328, 236248, 236244, 236242, 335587, 335302, 57093, 335579, 335716, 292892, 335714, 236219, 335577, 335573, 335571, 335569, 331547, 335403, 335564, 335562, 335401, 335084, 335399, 335397, 335752, 335082, 334417, 335712, 335557, 335393, 299618, 315189, 236186, 335383, 224441, 224438, 57081, 57078, 180368, 335078, 334412, 236181, 236179, 335359, 180366, 236177, 180364, 335293, 236173, 335289, 310150, 310148, 310144, 334407, 334404, 310142, 334400, 334397, 335379, 105215, 236171, 335336, 335376, 328807, 334313, 137938, 335072, 137935, 328805, 335372, 180348, 224411, 156218, 180331, 335312, 335310, 335281, 236157, 236155, 335094, 236153, 211562, 236145, 332586, 105163, 211549, 211547, 277325, 236133, 211537, 236130, 334974, 236126, 334819, 236122, 131542, 224384, 224382, 297883, 224365, 334794, 297881, 334860, 236082, 297877, 334565, 334777, 224359, 297871, 332990, 334557, 334259, 334554, 334747, 334551, 334548, 128907, 128905, 224352, 224349, 224347, 333014, 333011, 224342, 333009, 333007, 334603, 334601, 334715, 334312, 128901, 331764, 300813, 331762, 331759, 224337, 236077, 224335, 236075, 332549, 334149, 334144, 334311, 334142, 334310, 334374, 334309, 334372, 334140, 334308, 334369, 334540, 334307, 334367, 334364, 334138, 334136, 334306, 333122, 334132, 334305, 334304, 334130, 333116, 333114, 333109, 300806, 224304, 332544, 332542, 332539, 332537, 332535, 236038, 224300, 211421, 332918, 332519, 128892, 224296, 332515, 236035, 332512, 224286, 332508, 332506, 332953, 332503, 224281, 311752, 300801, 332912, 311739, 224274, 300798, 311737, 332873, 332871, 331540, 236025, 211399, 236022, 236020, 236018, 236015, 236012, 211394, 236010, 211391, 224260, 331200, 332643, 332456, 332453, 211373, 211371, 202641, 326692, 332614, 224250, 202639, 224247, 332284, 266092, 310506, 322604, 332564, 330885, 195945, 330883, 332430, 332426, 224243, 224241, 332423, 224236, 236000, 235997, 235995, 105101, 235993, 105099, 317865, 332381, 332365, 332379, 235991, 332319, 211346, 235989, 235987, 332202, 211344, 181437, 235985, 211342, 266090, 313976, 332299, 332296, 332146, 211329, 332143, 211325, 330619, 330615, 312583, 128879, 328274, 332257, 224211, 327105, 332200, 326891, 282753, 330877, 282751, 330875, 282749, 235974, 332197, 328802, 326886, 327103, 326884, 326883, 328799, 327101, 224097, 211189, 211186, 282790, 327699, 327697, 252083, 252081, 327577, 327575, 314391, 327573, 327695, 327422, 307571, 326662, 307569, 327693, 327688, 327717, 327680, 327600, 92769, 306907, 314387, 326837, 327255, 326624, 327571, 327563, 327569, 327561, 204023, 205107, 327097, 263057, 263055, 327095, 327091, 252066, 235885, 326875, 327090, 327089, 318534, 326872, 263052, 263050, 326868, 327006, 326866, 327003, 326827, 324403, 326861, 326860, 326856, 324401, 326824, 326853, 325949, 325262, 318255, 260930, 326352, 223963, 320113, 325944, 306899, 252059, 223962, 223959, 260908, 325625, 128866, 128864, 223944, 306891, 223941, 308380, 308378, 325260, 308376, 325258, 320096, 306888, 325332, 325256, 12601, 325438, 325330, 325254, 223934, 325236, 223921, 325252, 325276, 325250, 325234, 223918, 223916, 325231, 325228, 180287, 211101, 211098, 324399, 325131, 325129, 325127, 305613, 12599, 180283, 310109, 324397, 180277, 180275, 324388, 180273, 180271, 324386, 180267, 324384, 180265, 180261, 180256, 180253, 180250, 323670, 180245, 322993, 322991, 322986, 322982, 180244, 180241, 180238, 322958, 322956, 322593, 322954, 322979, 322592, 322591, 322590, 223914, 264064, 211094, 211092, 322588, 322587, 322586, 322585, 322584, 322686, 322582, 235858, 235856, 211090, 211088, 180231, 211086, 180226, 211084, 319474, 319472, 211082, 180221, 319468, 321618, 321750, 211079, 321906, 321904, 321839, 319454, 211077, 319452, 211073, 321616, 319450, 180219, 319448, 321633, 321823, 223902, 321819, 223900, 321614, 321608, 314561, 314559, 294961, 211069, 211066, 294960, 223892, 294950, 235842, 235840, 223882, 235837, 223875, 321631, 321367, 211053, 223871, 223869, 235835, 235833, 223867, 235831, 223866, 235829, 195872, 211051, 235827, 211047, 195869, 235825, 235823, 235821, 195865, 235819, 311781, 316899, 211042, 235817, 235814, 316896, 223864, 223856, 211032, 211029, 321595, 321593, 321590, 321588, 321586, 264052, 180203, 180201, 180199, 304711, 180195, 235812, 180193, 304701, 180191, 304698, 223854, 180189, 252045, 223852, 180186, 180184, 105035, 304696, 320059, 320057, 264038, 105033, 211016, 235802, 223838, 223836, 223832, 320045, 195855, 320151, 195853, 320082, 260896, 320074, 180177, 180175, 180170, 211003, 260894, 260892, 180168, 260890, 223819, 235786, 319811, 211000, 104985, 252035, 252034, 210998, 210996, 319898, 210994, 252033, 210992, 104980, 319809, 319873, 319871, 319869, 223816, 223814, 311239, 235766, 235764, 252025, 316719, 317076, 235759, 319135, 305888, 319130, 235758, 235199, 223786, 223772, 210979, 318974, 235752, 210963, 223766, 210960, 305885, 210957, 210955, 210953, 223764, 305883, 305881, 223761, 235750, 223759, 223757, 210951, 317703, 318812, 316967, 235748, 223754, 210947, 318808, 318805, 210936, 210934, 210932, 210929, 210926, 223743, 235746, 317062, 317060, 173274, 317057, 317053, 317051, 318491, 260875, 260870, 317393, 318143, 318392, 223731, 223729, 317579, 317115, 311234, 317576, 173270, 317517, 317515, 317513, 317509, 317507, 173268, 317505, 317503, 173266, 317107, 173264, 317500, 317097, 316857, 210886, 307545, 223723, 307537, 173257, 173255, 316174, 173253, 173251, 173249, 210869, 173247, 316067, 252006, 316854, 316713, 316710, 235711, 223710, 316700, 223684, 223682, 180065, 180064, 210830, 180062, 316041, 210826, 316035, 312877, 277295, 223671, 223669, 315958, 315975, 315956, 315973, 315870, 315868, 315866, 315954, 315565, 315864, 251967, 315499, 251965, 251963, 315501, 251962, 277291, 210784, 315474, 315469, 266064, 235680, 235678, 251946, 223637, 235671, 180051, 305209, 193461, 223633, 210755, 305206, 223631, 312539, 180046, 180044, 314883, 314881, 314878, 180041, 251944, 251941, 180030, 180028, 180026, 312530, 104947, 265332, 104945, 180024, 180021, 265329, 104944, 180019, 104939, 104937, 223624, 314456, 223622, 223620, 314948, 223614, 314497, 251937, 314493, 235657, 251935, 251933, 314446, 251930, 314444, 314442, 313442, 266052, 235654, 235652, 223613, 266050, 251928, 223606, 251923, 223603, 251920, 251917, 210740, 210736, 311632, 277282, 223595, 195824, 313862, 277675, 313923, 277673, 314150, 314144, 311228, 314074, 313687, 314021, 195823, 314072, 223586, 223584, 223579, 251903, 314018, 235611, 131451, 131449, 131447, 131445, 313918, 131443, 131441, 313997, 311226, 210734, 313995, 311221, 313949, 313944, 313981, 313842, 257189, 313839, 235595, 313837, 313835, 257186, 313832, 223578, 313830, 261691, 313914, 235592, 313886, 261689, 313760, 313758, 261687, 313883, 251899, 251897, 104923, 312784, 210726, 223574, 104921, 235591, 313820, 313818, 131428, 104920, 104918, 104915, 104913, 313856, 251895, 104911, 180002, 312520, 313744, 313742, 223573, 257184, 235589, 223569, 312361, 318834, 264024, 313679, 313677, 223565, 312875, 223563, 313628, 313378, 223561, 311720, 179996, 313738, 313736, 210712, 210711, 210707, 210705, 313588, 311717, 179992, 210703, 251885, 251883, 251881, 311712, 251879, 235584, 235582, 277280, 277278, 313404, 300790, 279891, 277276, 277273, 313425, 311710, 210698, 313505, 312873, 308364, 312871, 223560, 210681, 312869, 223557, 210679, 277671, 210677, 210674, 277669, 179985, 313663, 257170, 313660, 313618, 313615, 104910, 311700, 223552, 223550, 313496, 223547, 308356, 210669, 210667, 313489, 313485, 257156, 313583, 313483, 313392, 194587, 312576, 312574, 614335, 104907, 312567, 104903, 104901, 235581, 104899, 235579, 313476, 251871, 104897, 312564, 104895, 312782, 104893, 104890, 304675, 179977, 304672, 304670, 304667, 261686, 261684, 313333, 261682, 313331, 313329, 223546, 312867, 104881, 223530, 312763, 223528, 210628, 312760, 312758, 312756, 210626, 235571, 223524, 312515, 223522, 210621, 307531, 312512, 251846, 223514, 251845, 251844, 235566, 312670, 235564, 251843, 312247, 302010, 302008, 235561, 312553, 312502, 104853, 104850, 210600, 261197, 312499, 305593, 210589, 311912, 311908, 306154, 311904, 311618, 305199, 311901, 312121, 205051, 223463, 305197, 205048, 305195, 223457, 223454, 307523, 312231, 206999, 311668, 311616, 307521, 205045, 306152, 306150, 305193, 312228, 308170, 306148, 179957, 210582, 306146, 306144, 305190, 311611, 308168, 311598, 311597, 223440, 311804, 251835, 310491, 210554, 311595, 311771, 310489, 311593, 311757, 289975, 210552, 223430, 223428, 104832, 235551, 311585, 307496, 311658, 235548, 311468, 307494, 223420, 235536, 235534, 104821, 305169, 251827, 104816, 310485, 308325, 206996, 310481, 251825, 272964, 251824, 251823, 264022, 264020, 104814, 310401, 104812, 104811, 306665, 308136, 206994, 308308, 308130, 309853, 272962, 308305, 272955, 206992, 235533, 235529, 307634, 308299, 308298, 307647, 260853, 223402, 307227, 307691, 307628, 307224, 307487, 307689, 307685, 307653, 307682, 307485, 307484, 210520, 307679, 307677, 307387, 307218, 307481, 235520, 305484, 307671, 307624, 307667, 210514, 210512, 307436, 210510, 307400, 307479, 307398, 305475, 235516, 307427, 258497, 307392, 307390, 307348, 307346, 251815, 251812, 251811, 251809, 305464, 223388, 305460, 305458, 306611, 251808, 235514, 223386, 251806, 307252, 179935, 307210, 307175, 235513, 235511, 223375, 307013, 251802, 307006, 251800, 210505, 278091, 307000, 251798, 251796, 251793, 179931, 179929, 614311, 306113, 306239, 251788, 223338, 305576, 301935, 306222, 179926, 210496, 109699, 306218, 179924, 223321, 223319, 223318, 306213, 235508, 223315, 306211, 263998, 306106, 306200, 306104, 306103, 179921, 306100, 305844, 306098, 305841, 305997, 123455, 123453, 305873, 305871, 305837, 305832, 305869, 305868, 305866, 210492, 305864, 305862, 210489, 223310, 235504, 223305, 305557, 223301, 223300, 223298, 223296, 223295, 179909, 223292, 223289, 179907, 223288, 223287, 223286, 223285, 223284, 223283, 299548, 299546, 210464, 305727, 235498, 235496, 235492, 235490, 210460, 305523, 305521, 305546, 304151, 303628, 179899, 210458, 179897, 179895, 179894, 179892, 266047, 179890, 305519, 266045, 266044, 210456, 223268, 179888, 223266, 305251, 210454, 305439, 305246, 210449, 173239, 173237, 302620, 223252, 305069, 305067, 304147, 303583, 304145, 300772, 303581, 223230, 223225, 304964, 302617, 179883, 302613, 302612, 253262, 251741, 304815, 253259, 253257, 304546, 304661, 210427, 235464, 253251, 262851, 253248, 253245, 303670, 304658, 304867, 304753, 251738, 304749, 301709, 304747, 304745, 304743, 21993, 21991, 304734, 251733, 304516, 304514, 210421, 304633, 210414, 235461, 303574, 235459, 235457, 304524, 235455, 301803, 98847, 301801, 191723, 303625, 210395, 303623, 303621, 210393, 210391, 299780, 299777, 299776, 303958, 299774, 62121, 303782, 303780, 303956, 303778, 303776, 303954, 304187, 303038, 210389, 210385, 303571, 303952, 210382, 304120, 303036, 210381, 300922, 300919, 251707, 301997, 303644, 210370, 302499, 303635, 303566, 300911, 303619, 303032, 303687, 303655, 266034, 300907, 303557, 300905, 210365, 210363, 300903, 251705, 301583, 251702, 210361, 261112, 302392, 303617, 302388, 303554, 303552, 303550, 302260, 302258, 210356, 210354, 210352, 210350, 302256, 300902, 179873, 191720, 191718, 303027, 191716, 302963, 210348, 210345, 210340, 303025, 303023, 303021, 303019, 303018, 303015, 303499, 179865, 179863, 303012, 303010, 251696, 302369, 302493, 302491, 302633, 288018, 141122, 302628, 302893, 288014, 302254, 302889, 302586, 288011, 302584, 302886, 302579, 210336, 302883, 302366, 302252, 294615, 302622, 302573, 302364, 210334, 302361, 251693, 179859, 301836, 302245, 179853, 302243, 302385, 210309, 302232, 302230, 302228, 210305, 179847, 251688, 251686, 302219, 302218, 302216, 210298, 302204, 302202, 302026, 301831, 301793, 266033, 266032, 251685, 251684, 266031, 266029, 210292, 262843, 301578, 301576, 301827, 301917, 301915, 301914, 301910, 301824, 301908, 301906, 301902, 301885, 301882, 210287, 210286, 210285, 267897, 301678, 301786, 301675, 301784, 301673, 301779, 301671, 301669, 301668, 301666, 300985, 301642, 299875, 21977, 251630, 291206, 300977, 300972, 269212, 291203, 179834, 300621, 300883, 298965, 298962, 300898, 267230, 267228, 210236, 267226, 267224, 299332, 299330, 267220, 299126, 299124, 299122, 299121, 267218, 300727, 299119, 299118, 300603, 179826, 299326, 299320, 299319, 179812, 299107, 299105, 299653, 299651, 251598, 299643, 251586, 299528, 299526, 299293, 299307, 298773, 299097, 299290, 299302, 298995, 262838, 223165, 179806, 179805, 298102, 298100, 298404, 179796, 298762, 298754, 298752, 298750, 298745, 298741, 210203, 266022, 266021, 266020, 210200, 223145, 296929, 296927, 223143, 104731, 104730, 210182, 298381, 298374, 298371, 298261, 298259, 210172, 298368, 210169, 210167, 210165, 294614, 179792, 297780, 179790, 251573, 179789, 297778, 179787, 179786, 179785, 179784, 179782, 179781, 179780, 179778, 179777, 179776, 297775, 297773, 265318, 296147, 297197, 251565, 298087, 298085, 297603, 298083, 298081, 288009, 298079, 288007, 297601, 297457, 298257, 298252, 210152, 288004, 266009, 266007, 296273, 266005, 266004, 279769, 266002, 298196, 279766, 266000, 279763, 179757, 265997, 265996, 265995, 179755, 265993, 265991, 265988, 298193, 265986, 210142, 265984, 265983, 265982, 265979, 210127, 296270, 265976, 296268, 298176, 265974, 296266, 265972, 288003, 297569, 297567, 297565, 297132, 297172, 297169, 297166, 297162, 297161, 265960, 297125, 265956, 265954, 265952, 265950, 205016, 265946, 294100, 251561, 210093, 210091, 296258, 210086, 210084, 210082, 210080, 205011, 291970, 295995, 295943, 295941, 295993, 183038, 174175, 173224, 210052, 174173, 104725, 295930, 210046, 174171, 183035, 295799, 174169, 183029, 295750, 295743, 295741, 295739, 251546, 295728, 291963, 251544, 251542, 251540, 251539, 295306, 287996, 191712, 287994, 295302, 287992, 223128, 251529, 291958, 295488, 295470, 294770, 295467, 291955, 251518, 295460, 295068, 293912, 295062, 293910, 109682, 175391, 295053, 261194, 261192, 261190, 173213, 109674, 109671, 195684, 295028, 251509, 251506, 251505, 294290, 223123, 293906, 294750, 294927, 109669, 294765, 262828, 294688, 294748, 292874, 109667, 294745, 109662, 294741, 294737, 109660, 109658, 294270, 294268, 294671, 294669, 294266, 109656, 294666, 294587, 261187, 109651, 109650, 210006, 294427, 174151, 294425, 294423, 294412, 174149, 294096, 174146, 294094, 174144, 292050, 293860, 294064, 262827, 104701, 262825, 291611, 131320, 291608, 291601, 291597, 104694, 104691, 291594, 262823, 291592, 291591, 291588, 291586, 251497, 179694, 104677, 292504, 292502, 292499, 292495, 269203, 160766, 173207, 173205, 291419, 292016, 292060, 292058, 291683, 209988, 292146, 292045, 291681, 292014, 291520, 291679, 292005, 291518, 209983, 292040, 292035, 287986, 291676, 287249, 287246, 288257, 287241, 287238, 284589, 284587, 287236, 284584, 288253, 291506, 288251, 288249, 288247, 288245, 291582, 291580, 284582, 291577, 291575, 284580, 291674, 288239, 291287, 289961, 291274, 291256, 291250, 268655, 268650, 209966, 287228, 290190, 290188, 104628, 179669, 288635, 104603, 288633, 288631, 290351, 290347, 285811, 289931, 285807, 179665, 290344, 290342, 290340, 290407, 104583, 290338, 290337, 290405, 285802, 104581, 285799, 104577, 104575, 290400, 290334, 290398, 290319, 104569, 290317, 290394, 290298, 288629, 290392, 290295, 290289, 290390, 290329, 290186, 288627, 290285, 289266, 290184, 288625, 288623, 284555, 104561, 183930, 104558, 209947, 185325, 179656, 289972, 188645, 209942, 289969, 289966, 209938, 268635, 268633, 289701, 289964, 289897, 289893, 289258, 289891, 289256, 289751, 289881, 289876, 289873, 185317, 185311, 289866, 289224, 289220, 263095, 289793, 288608, 289746, 289790, 289788, 289253, 289744, 289203, 263093, 289192, 263090, 288878, 209933, 263087, 288873, 288871, 173203, 288863, 185297, 223117, 287225, 288614, 262819, 288212, 262817, 288210, 223106, 223104, 223101, 183025, 185291, 223097, 195669, 257152, 257149, 257147, 257144, 287332, 195667, 179649, 179647, 287921, 287982, 288037, 288204, 209923, 287974, 273117, 287971, 287969, 288035, 262816, 284550, 287967, 262814, 287914, 263480, 288033, 287965, 104533, 288030, 287961, 285780, 287959, 288028, 287956, 209906, 288026, 287954, 287908, 204990, 204988, 179632, 285778, 263477, 179630, 204986, 285776, 179624, 287592, 287590, 287894, 104511, 287897, 173198, 104508, 204983, 104501, 204980, 209885, 179616, 209883, 179612, 209880, 179595, 287580, 179593, 209862, 179591, 209860, 173196, 173193, 179562, 266849, 173191, 173190, 173179, 209839, 183016, 173173, 173170, 209824, 285044, 173168, 183008, 179529, 209814, 285751, 183006, 209805, 209803, 182996, 209801, 285740, 182994, 131270, 131266, 262322, 131255, 285243, 284635, 182989, 182987, 131247, 173167, 270179, 262804, 209785, 284974, 173165, 173161, 284613, 284756, 284173, 173159, 284529, 173156, 284527, 173154, 173152, 275752, 284525, 284353, 259413, 209774, 209703, 276471, 262802, 279612, 279609, 209690, 179433, 276463, 179431, 276461, 276459, 278925, 278333, 278330, 278328, 278914, 278325, 279449, 279447, 278322, 276586, 279399, 278317, 277556, 262798, 209684, 209680, 278870, 209675, 209673, 266844, 266841, 278315, 279161, 266839, 279156, 278964, 278311, 261039, 261037, 261034, 266838, 209651, 266836, 277528, 277523, 277520, 277518, 277615, 277601, 277500, 277498, 267051, 277492, 209634, 156663, 277481, 277479, 277477, 269200, 269198, 269196, 269194, 179355, 276449, 209630, 277049, 277035, 209626, 261775, 276433, 179330, 104485, 104483, 104481, 276528, 104476, 104474, 276428, 261772, 104471, 276426, 104470, 261770, 276413, 179325, 266833, 179295, 179293, 209620, 262795, 262793, 141057, 266831, 266829, 141055, 262791, 266827, 262789, 271129, 262787, 262785, 266822, 271128, 271296, 266820, 262783, 272943, 202580, 272941, 209609, 266817, 266815, 266814, 266812, 266808, 266807, 272008, 209594, 272073, 272005, 271260, 272003, 272001, 272068, 209592, 271123, 259707, 262780, 259704, 141026, 262773, 271597, 266803, 262770, 262769, 266799, 266792, 179227, 268221, 179225, 262767, 179223, 265842, 265832, 265824, 271282, 265820, 265818, 271280, 271278, 207489, 265816, 223038, 179213, 179209, 179207, 223036, 207487, 183887, 271120, 262761, 262759, 271115, 271113, 156658, 179202, 207419, 156654, 156652, 271098, 271092, 207406, 209555, 268336, 266272, 122617, 179133, 269536, 266789, 267040, 267037, 266787, 179113, 265788, 267035, 179109, 179106, 266785, 179104, 179102, 266783, 209539, 179099, 179097, 266252, 174135, 179085, 270305, 270396, 269806, 270352, 267026, 269371, 179050, 141005, 270302, 141000, 178989, 178987, 202575, 178986, 178985, 178984, 178982, 178981, 266249, 256494, 182983, 202573, 262058, 262755, 262753, 270160, 262751, 262749, 235243, 262741, 262739, 262736, 262734, 270153, 270131, 270124, 178942, 178939, 270122, 178934, 269983, 178917, 186796, 178903, 209525, 262725, 178871, 178870, 178868, 178864, 178862, 178861, 209497, 143025, 268212, 178860, 209495, 209493, 143023, 269348, 269346, 183863, 183861, 143019, 269432, 269426, 81695, 269417, 182974, 182969, 209446, 269338, 182965, 269295, 269135, 269192, 269290, 143005, 269245, 269189, 209426, 206504, 182964, 269240, 269236, 269234, 269124, 269186, 269232, 269231, 269121, 269227, 269225, 182963, 269184, 269220, 182961, 269119, 182959, 269182, 269218, 269216, 269180, 269214, 269178, 182958, 182956, 182955, 182953, 262709, 262705, 182951, 209423, 209421, 262693, 262691, 209400, 209397, 268456, 268454, 178733, 268451, 268449, 268436, 268447, 268446, 268441, 268404, 178722, 178719, 70272, 178717, 268325, 268322, 268356, 268320, 268318, 268315, 264970, 261959, 261957, 261952, 264955, 264952, 261949, 261947, 261945, 261942, 235376, 209379, 178639, 104268, 178634, 104264, 104262, 266662, 268284, 268295, 178631, 268135, 266546, 268085, 267768, 268129, 263464, 182948, 182946, 268083, 182944, 268078, 209370, 267765, 267762, 267761, 267756, 268017, 263459, 267095, 267752, 267748, 263453, 267746, 267744, 267742, 267961, 267959, 267957, 267736, 209359, 178576, 178570, 178568, 209353, 267733, 178556, 178554, 265693, 267779, 267731, 265691, 178547, 178545, 178543, 178540, 178538, 267008, 249410, 267211, 267209, 266781, 267207, 266778, 263876, 267199, 263874, 265684, 178517, 178515, 178513, 265678, 266988, 265674, 178511, 265669, 265667, 265660, 265656, 265654, 265650, 178500, 178498, 267082, 235370, 266983, 266978, 265647, 266976, 267105, 265645, 267103, 235351, 235349, 178493, 178489, 266776, 178487, 266685, 266775, 266773, 266891, 266869, 249398, 266867, 266154, 266865, 266863, 259688, 178480, 266769, 266738, 259686, 259680, 265620, 178475, 178473, 178471, 178467, 265616, 178464, 178463, 266634, 178461, 265614, 265611, 109573, 109571, 266632, 209342, 209339, 266529, 178456, 178454, 256298, 266629, 209336, 259678, 259676, 259160, 259158, 209331, 266453, 266451, 266385, 266151, 178299, 266370, 178296, 266148, 178268, 178266, 178262, 178259, 209322, 209319, 266207, 266200, 266145, 266241, 254005, 178213, 178211, 254003, 254001, 261873, 253999, 266181, 265293, 178203, 247580, 266142, 265605, 178202, 258281, 265291, 265567, 265565, 265558, 265282, 261867, 253978, 261370, 262676, 264209, 261865, 209303, 262668, 262666, 262664, 262663, 262662, 262661, 262660, 262659, 178101, 262658, 262657, 261366, 262656, 262655, 262654, 262653, 262651, 265077, 178098, 261364, 178095, 178093, 258276, 178092, 258273, 178090, 258269, 203728, 265170, 258267, 178089, 258265, 253959, 265138, 253953, 265125, 253950, 261861, 253948, 195624, 178074, 178072, 131163, 178070, 178068, 178066, 265074, 251384, 261176, 178063, 178051, 253940, 253939, 253936, 261853, 257423, 257421, 257419, 253933, 253931, 186791, 186784, 186780, 253929, 186778, 186773, 186770, 178030, 186768, 178028, 260418, 257409, 186765, 178025, 178023, 257406, 186763, 178015, 178013, 186762, 178011, 257402, 186761, 186759, 257400, 186758, 253927, 253925, 253923, 253921, 253919, 257398, 253917, 186755, 253915, 257396, 257394, 257393, 257389, 253913, 253911, 253908, 186754, 186752, 209299, 186750, 186748, 209295, 177971, 186742, 186741, 104226, 177968, 186738, 104213, 258260, 209292, 104210, 177938, 258251, 258249, 177866, 177863, 177861, 177858, 177855, 177839, 264526, 264522, 264521, 264518, 264516, 264514, 264582, 264512, 261836, 264510, 262158, 177827, 264507, 104199, 261832, 177824, 262149, 259203, 131135, 131132, 259193, 262141, 262134, 177795, 262131, 177793, 264190, 263421, 264146, 122600, 122598, 263171, 263169, 263821, 263860, 263816, 263845, 263843, 263840, 263837, 263831, 209289, 263082, 263807, 209287, 209285, 177756, 177752, 209282, 209280, 263703, 263145, 177737, 177734, 256524, 263745, 263743, 262650, 262649, 263541, 177731, 177729, 177727, 177721, 177717, 209272, 185773, 263662, 186723, 262647, 186720, 185770, 186718, 177691, 263407, 263599, 186710, 185764, 177683, 186702, 263535, 263532, 263529, 262646, 209269, 186699, 262643, 263505, 263401, 263399, 263397, 263394, 263392, 263390, 262578, 263383, 209261, 262642, 263380, 262640, 263378, 263376, 186696, 262572, 261815, 209257, 186694, 262570, 263042, 262910, 261806, 261803, 262638, 262636, 263250, 261801, 262635, 262634, 186692, 186691, 262553, 263106, 262627, 263034, 186683, 262625, 177639, 186681, 177637, 263077, 186680, 262281, 262530, 262623, 262279, 262528, 262622, 262907, 262621, 177634, 262526, 262615, 262614, 186679, 262521, 262607, 262886, 262604, 262508, 262883, 254827, 262602, 262600, 262599, 262593, 262502, 177615, 222932, 257728, 257724, 177607, 209248, 261940, 262360, 222930, 222928, 261976, 318854, 262357, 261937, 262023, 177589, 262258, 262256, 262300, 262296, 262253, 262345, 177587, 177585, 262342, 262340, 177567, 177565, 177563, 261133, 177556, 177547, 261930, 261928, 261926, 185752, 260363, 261914, 261912, 261968, 318846, 261910, 209215, 262052, 262049, 261583, 261737, 255953, 260359, 260357, 255949, 260355, 260345, 261670, 177487, 177482, 177477, 177475, 256702, 186663, 186660, 186658, 177474, 186656, 259058, 186653, 185745, 185743, 186649, 185740, 260691, 177466, 259051, 186640, 256697, 260324, 256695, 260321, 260311, 260308, 261579, 261403, 261401, 261398, 260689, 261489, 250705, 260687, 177405, 260683, 183708, 177400, 209192, 209190, 261347, 260681, 261435, 260268, 261345, 222901, 261342, 261340, 261337, 261394, 261334, 260260, 261357, 131053, 222896, 260258, 209188, 209185, 260255, 131049, 261388, 257697, 261355, 261386, 186615, 257695, 186612, 177378, 222894, 222892, 257690, 177367, 177365, 259148, 177354, 261333, 260248, 209179, 261175, 261171, 251289, 177351, 260243, 235348, 260213, 209171, 209169, 261170, 260207, 209167, 259634, 186604, 186602, 186599, 195591, 259632, 186596, 261167, 261165, 186593, 261130, 261128, 261161, 209164, 260192, 104138, 186583, 260190, 260846, 261021, 235343, 261119, 235341, 235339, 261019, 261117, 259348, 260842, 235325, 260509, 235321, 186581, 235319, 260186, 260504, 260183, 260832, 260180, 193208, 260177, 260829, 260501, 260825, 260173, 235311, 186578, 260170, 235308, 235306, 260166, 259346, 209158, 186577, 260608, 209154, 259343, 235304, 209152, 104097, 260485, 104092, 259341, 235290, 104085, 186571, 260482, 260478, 177268, 259339, 177266, 177264, 177259, 177256, 177254, 260133, 260130, 177249, 177245, 209149, 260121, 186553, 258399, 186551, 209146, 186549, 259337, 209141, 177239, 177236, 259868, 209139, 260078, 255946, 260074, 260028, 255944, 260059, 260055, 260019, 177196, 260016, 259191, 209133, 186542, 259896, 259992, 259189, 259943, 259940, 209129, 186536, 186534, 258023, 258021, 259136, 177150, 259888, 258841, 258795, 204509, 186530, 259852, 259850, 259848, 186519, 259784, 259782, 128853, 128852, 259780, 186512, 186507, 259674, 259672, 259615, 204499, 204497, 259670, 259574, 259602, 259666, 259280, 259600, 259268, 259032, 186484, 259263, 259564, 259174, 186482, 259029, 259562, 259560, 259334, 259332, 259474, 259472, 259471, 259465, 259462, 259459, 259457, 259330, 249392, 249390, 249389, 209125, 186443, 186440, 249386, 259353, 259326, 256483, 257999, 259119, 176994, 209114, 209112, 258986, 259064, 176988, 176981, 259062, 258983, 176976, 176975, 258979, 176972, 257995, 258974, 258884, 258838, 258543, 258541, 258539, 258835, 258834, 258833, 258832, 258831, 258830, 258829, 222874, 258538, 257375, 256470, 222871, 258536, 202541, 258533, 256465, 222867, 222865, 256460, 254583, 128841, 251261, 258439, 258430, 256014, 258376, 258301, 258374, 209069, 176919, 257338, 249206, 209057, 258358, 209049, 258354, 209039, 258247, 209035, 130977, 130974, 256345, 253095, 249629, 130971, 257462, 257984, 257980, 176899, 176897, 176895, 258036, 258191, 176865, 176816, 176814, 257875, 257819, 222850, 222825, 209022, 222822, 222807, 184597, 184593, 257276, 222805, 254281, 254582, 257274, 256440, 256438, 209012, 257539, 176784, 257475, 257259, 257500, 255587, 257451, 256431, 257448, 222798, 222796, 257446, 257006, 176774, 257004, 257444, 257002, 257442, 222794, 256842, 256617, 222792, 257480, 255584, 209003, 257248, 208999, 256429, 256578, 257440, 255940, 254278, 256094, 204917, 256029, 255037, 204915, 186296, 204913, 255936, 250911, 255934, 255144, 140922, 255033, 186291, 255930, 207715, 255879, 255102, 255966, 255964, 255876, 255928, 255567, 255562, 255832, 255097, 255341, 130880, 222753, 255782, 255132, 255130, 255537, 255780, 255777, 255535, 255532, 255774, 255770, 255529, 255029, 255271, 255088, 201234, 255027, 255086, 255025, 255023, 255216, 255079, 255077, 255210, 255068, 255113, 255064, 254979, 255018, 204484, 255016, 255047, 254241, 254929, 254928, 254925, 254918, 254916, 254912, 254905, 254901, 254793, 192093, 253904, 192091, 249125, 254788, 249123, 249120, 253893, 254475, 254806, 254867, 254818, 254231, 253887, 254226, 254572, 254570, 254218, 254565, 247538, 191522, 249607, 254498, 254459, 254495, 186266, 254207, 254493, 254491, 186264, 254480, 186261, 254205, 186260, 186252, 254203, 222745, 250897, 253322, 250895, 250893, 250891, 250889, 254197, 250886, 250884, 250882, 206649, 186228, 250876, 176647, 250874, 250872, 253851, 248635, 250870, 253846, 206644, 253844, 176645, 248631, 176642, 248625, 248623, 253084, 250868, 253430, 253390, 253081, 253388, 253427, 186223, 253079, 208906, 208904, 253117, 251115, 253186, 253202, 253134, 253199, 253070, 253068, 250862, 250852, 249840, 250834, 251081, 250832, 251079, 250823, 250821, 250909, 250819, 250817, 188607, 250813, 188604, 188602, 249651, 250747, 248262, 250741, 250673, 250627, 249648, 249645, 207604, 176529, 207602, 184982, 184980, 208830, 207600, 249825, 184973, 249362, 130802, 249784, 184968, 249811, 249575, 186168, 249349, 207598, 249632, 249565, 248536, 249439, 249437, 249115, 176492, 248858, 248499, 248487, 249310, 176487, 248484, 248481, 248478, 176477, 207595, 176462, 248844, 249074, 248173, 176458, 176457, 249100, 130763, 249096, 249093, 248142, 248140, 248462, 248460, 248429, 248135, 176415, 248458, 192645, 176316, 206598, 207221, 207217, 185738, 207169, 207165, 185736, 206502, 206589, 206813, 206877, 206904, 206916, 182522, 185733, 206914, 182520, 206911, 182518, 206869, 206901, 206278, 206276, 182512, 206798, 206274, 191899, 204873, 185730, 204547, 202529, 204545, 202526, 204407, 204678, 204542, 191669, 202521, 173150, 202830, 176297, 185717, 176294, 202410, 203999, 203160, 188052, 203157, 202408, 203509, 203316, 202403, 203309, 202503, 201662, 202400, 202398, 202396, 202391, 202389, 190927, 181186, 201430, 176281, 176279, 176277, 201411, 173615, 201289, 194064, 195338, 181182, 189830, 195336, 195331, 194041, 194038, 194035, 195328, 195228, 195281, 195225, 195291, 195293, 195266, 195108, 195106, 195218, 195157, 195104, 195102, 159265, 195084, 195206, 195153, 195149, 195202, 195136, 194857, 195098, 195081, 195078, 181178, 195075, 194633, 174704, 181176, 181173, 194631, 195016, 181171, 194763, 156635, 194682, 156633, 156631, 194680, 194678, 156629, 194675, 156626, 156624, 194672, 194670, 194669, 194665, 194663, 194661, 194330, 194599, 194597, 194629, 194593, 194615, 193968, 193641, 193538, 193536, 193309, 193254, 193250, 193457, 193248, 192445, 193305, 193246, 193455, 193125, 193528, 192709, 192441, 192473, 192707, 192471, 192704, 192702, 192665, 192663, 181168, 181166, 192643, 188471, 188468, 103762, 188466, 103760, 192553, 192488, 192461, 103748, 103746, 192439, 103744, 156622, 192424, 192435, 192429, 192418, 192400, 192398, 156620, 156618, 156616, 103741, 156614, 176254, 173148, 191074, 156612, 191072, 173146, 176251, 176249, 191070, 192290, 192394, 173145, 156610, 156609, 156607, 192270, 191618, 191613, 191611, 192080, 192265, 192186, 191607, 192251, 176248, 176246, 190924, 191601, 187803, 173613, 176244, 176243, 143512, 176239, 176236, 176233, 176231, 176229, 191912, 173142, 176226, 173140, 190914, 176223, 176221, 176219, 173138, 191384, 190912, 191382, 191852, 190910, 190873, 191591, 191836, 191312, 191850, 191570, 191878, 191380, 190900, 190153, 190421, 176051, 190397, 176049, 176047, 176043, 190197, 176041, 163881, 176039, 187786, 185138, 187777, 176026, 182480, 187775, 189842, 176002, 189702, 175999, 188008, 189906, 188006, 189840, 189904, 186968, 188003, 187999, 189900, 187997, 187994, 187992, 182465, 189835, 189845, 182463, 189817, 175996, 189694, 182460, 189175, 189692, 189173, 175993, 189524, 189521, 189171, 188048, 189680, 189679, 189699, 175992, 189685, 189311, 175987, 174601, 181164, 181162, 188218, 188591, 189307, 187980, 189673, 189672, 189670, 166583, 166580, 189305, 189502, 188588, 189518, 181158, 166374, 188216, 188044, 181156, 188324, 188323, 188321, 188368, 188317, 188314, 188085, 188308, 172603, 188241, 172601, 187949, 166363, 188239, 188038, 188211, 188237, 188235, 188209, 188194, 188206, 187977, 187975, 188204, 188074, 188072, 188069, 185011, 185009, 188034, 187743, 187990, 187740, 175971, 175969, 187986, 187940, 187938, 187931, 153637, 187825, 175963, 187715, 187452, 175956, 175954, 185714, 185712, 175952, 175950, 155944, 155942, 155940, 163050, 186907, 186905, 186903, 185904, 185895, 155443, 185851, 185847, 185832, 185628, 185626, 185709, 185624, 185623, 185706, 175919, 155437, 155934, 183643, 185620, 185566, 185642, 155435, 185640, 183640, 185579, 185517, 184925, 185515, 185563, 184523, 155431, 184521, 184517, 174544, 185510, 174536, 174534, 174531, 155427, 155425, 170861, 182801, 155423, 182799, 175914, 184513, 163037, 184512, 185224, 184508, 163035, 185218, 175902, 184923, 175900, 175898, 175897, 185416, 181543, 185406, 184693, 185403, 185372, 185369, 185213, 185182, 185004, 182877, 185002, 185000, 183991, 185175, 185173, 183986, 184915, 184896, 185153, 185109, 183638, 184966, 185117, 185104, 184965, 184963, 183983, 184912, 175891, 175889, 175887, 184910, 162278, 175885, 172590, 175883, 172588, 172583, 172581, 175881, 184908, 175879, 175877, 172579, 172577, 184818, 184903, 172574, 175873, 172572, 184815, 184900, 184813, 184898, 184890, 184729, 175871, 175869, 184792, 184810, 184718, 184586, 184490, 184488, 184807, 184680, 184710, 184468, 184315, 184463, 184644, 184641, 184452, 184440, 184434, 184422, 184418, 184411, 184409, 184404, 184389, 184371, 184366, 184311, 175867, 163032, 168069, 168066, 183595, 168063, 183687, 183621, 183681, 182851, 182849, 183571, 183593, 183256, 181141, 181139, 181136, 182792, 181133, 183218, 183251, 183249, 183216, 181131, 181128, 181126, 172430, 182219, 173137, 182214, 173135, 175845, 182777, 182355, 175843, 175841, 182352, 181469, 175839, 182697, 182210, 182773, 182769, 182767, 168059, 182761, 182692, 182691, 182687, 182686, 182425, 172715, 182759, 182757, 182755, 182751, 182676, 182533, 182414, 181459, 182410, 182407, 182531, 182346, 175832, 175278, 182342, 175830, 163553, 163551, 175829, 175828, 175367, 163574, 182178, 163571, 175822, 103647, 163569, 181456, 181607, 175818, 175302, 175300, 163567, 175298, 175296, 181964, 175294, 175801, 175799, 181961, 175794, 181124, 181122, 181120, 181117, 181115, 163565, 181576, 181258, 181255, 175771, 175767, 181250, 181338, 181248, 181451, 181447, 181443, 181111, 163562, 181236, 181108, 175755, 175747, 181228, 163558, 175719, 175718, 175707, 175186, 175184, 175182, 175660, 175246, 175180, 175658, 175178, 175655, 175176, 175244, 175362, 175095, 175360, 173866, 175356, 175335, 175353, 175332, 175321, 175291, 175158, 175093, 175288, 173747, 175091, 175243, 175156, 174450, 174790, 137922, 174448, 174787, 175018, 173817, 174785, 174783, 173815, 174441, 174916, 174091, 174495, 157647, 174913, 174492, 174087, 174907, 174490, 174903, 157645, 157643, 174436, 174487, 150486, 174434, 174484, 150484, 174073, 174038, 173407, 173601, 173722, 137921, 173635, 173133, 173598, 173131, 173595, 173593, 173334, 173322, 173128, 173319, 173126, 173124, 173315, 173122, 173120, 173312, 173311, 173289, 162004, 161999, 173011, 172971, 172969, 100006, 173006, 173118, 173117, 173284, 173114, 172961, 161994, 168241, 173112, 173111, 172711, 168238, 168236, 168234, 172705, 172702, 172700, 172419, 140674, 172698, 172696, 172694, 172693, 171617, 172690, 168480, 171599, 168477, 168474, 172412, 172394, 172407, 172405, 171590, 172435, 172384, 137906, 171954, 157639, 157638, 171527, 137904, 171525, 137901, 171523, 137898, 171521, 172309, 157636, 172224, 170087, 171570, 168225, 171558, 171950, 168032, 166964, 163021, 157634, 167209, 157632, 166361, 166938, 168418, 168417, 168414, 168410, 168408, 168025, 168405, 168259, 168402, 168023, 168314, 167205, 168113, 166355, 168110, 168109, 166353, 168106, 166351, 164795, 164794, 164793, 167202, 153151, 167335, 167199, 167196, 167237, 167192, 167185, 167220, 166934, 166927, 103638, 166575, 166445, 166441, 166439, 166435, 165556, 164554, 163215, 164175, 163210, 163209, 164035, 163207, 163200, 164033, 163877, 163198, 163191, 163014, 163507, 163506, 163362, 163502, 163107, 163121, 163088, 163009, 43783, 162038, 162035, 162593, 161977, 162137, 162393, 162135, 162047, 144785, 162028, 162041, 162026, 162025, 162024, 162022, 162020, 162017, 159894, 161971, 161902, 161443, 161379, 158943, 161323, 161372, 161366, 149478, 161318, 161311, 159253, 143772, 160337, 160335, 160063, 160060, 160058, 159802, 159800, 159798, 160053, 160049, 159796, 160048, 160046, 160045, 160042, 160040, 160039, 160037, 160035, 157629, 157627, 155952, 159708, 159706, 157625, 157622, 157619, 159496, 157617, 159136, 157615, 157612, 157611, 157717, 157679, 157064, 157609, 157062, 157607, 157605, 157714, 123009, 157270, 157677, 157602, 156738, 156735, 156733, 156962, 43779, 156731, 156800, 156797, 156794, 156791, 156725, 156044, 156594, 156043, 156363, 156361, 156041, 156592, 156038, 156359, 156036, 156035, 152890, 156033, 156596, 152888, 152886, 152884, 152882, 156277, 156342, 156339, 156334, 156332, 156328, 156324, 156321, 156317, 156193, 156272, 156271, 152880, 153932, 153982, 155948, 156061, 150474, 152852, 152878, 152876, 152874, 152872, 152870, 154912, 154422, 154417, 153058, 152868, 152867, 152864, 154436, 154432, 154430, 154402, 154399, 152861, 153876, 152859, 152854, 153620, 146142, 153463, 153018, 137753, 137613, 151749, 151747, 151745, 151742, 151740, 146140, 146139, 137751, 146137, 151736, 151528, 151527, 151526, 151510, 151505, 152052, 137248, 152050, 151733, 151502, 149643, 151500, 146135, 151371, 151721, 151242, 151482, 151719, 151478, 151363, 151476, 151474, 151472, 151468, 151466, 151464, 151463, 151360, 151407, 151218, 151355, 151405, 151352, 151402, 151216, 151290, 147246))
Run Time: 0.126926
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 6352 | |
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 | | | | | 6352 | |
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 (27137, 26033, 17799, 17706, 16765, 16465, 16442, 16130, 16119, 16018, 15521, 15843, 14093, 13964, 13693, 13483, 13407, 13316, 13280, 12947, 12863, 12569, 12387, 12147, 12127, 11963, 11768, 11599, 11508, 11482, 11451, 11415, 11066, 10813, 10755, 10754, 10593, 10591, 10434, 10336, 10332, 10326, 10318))
Run Time: 0.001905
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 43 | 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, ��Z
Run Time: 0.000225
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: ��Z, XF\Pub\Controller\Member, RecentContent, valid, user_id=2561, 1716242771, , 0, ��Z
Run Time: 0.000128
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000315
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.000655
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: 1716242471
Run Time: 0.000302
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 12 | 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` >= 1716242471)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000542
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 12 | 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