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.000693
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.000169
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` = '2549')
LIMIT 1
Run Time: 0.000466
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.001495
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_2549' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.154961
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 (575260, 585441, 584388, 575294, 572519, 514661, 133185, 450391, 429448, 232602, 485680, 537630, 427956, 458270, 388129, 465021, 395941, 393771, 240293, 388026, 227805, 393721, 392510, 391294, 227609, 389433, 387972, 387969, 214955, 308754, 389987, 389841, 390081, 308752, 308730, 308723, 308716, 214815, 308701, 8494, 227481, 214802, 161748, 385631, 214794, 161745, 386371, 364650, 348337, 214782, 106477, 252749, 106471, 348283, 227398, 385191, 385283, 106467, 106465, 385189, 106448, 383527, 214678, 106422, 384779, 303264, 106405, 214669, 346342, 214666, 214664, 106402, 227371, 346340, 303262, 227362, 384623, 384725, 364641, 384720, 214658, 196875, 196873, 376075, 106395, 214653, 357963, 384621, 214635, 214634, 238627, 106392, 106390, 308694, 227355, 214632, 308692, 227344, 227330, 238563, 227310, 227289, 106360, 227287, 227282, 106357, 382491, 238522, 106353, 214526, 382534, 382489, 381679, 382486, 616433, 214518, 378074, 382531, 382528, 238518, 214516, 227276, 360385, 377430, 238515, 227268, 214503, 330024, 227253, 378895, 336189, 330023, 382147, 382061, 372464, 361808, 336187, 381263, 361805, 378749, 376015, 361803, 377628, 375595, 379259, 227251, 238506, 382089, 214497, 308671, 382085, 214479, 238490, 308662, 308661, 227248, 238486, 381677, 381898, 227240, 381465, 227237, 227235, 379787, 227229, 376060, 379785, 252729, 361797, 330841, 378742, 361795, 214468, 381701, 381211, 320263, 377562, 227196, 379482, 214454, 308659, 379758, 378625, 379104, 271350, 227187, 214426, 227181, 214411, 378738, 305684, 227146, 36055, 378711, 378472, 377505, 305682, 214376, 227133, 371147, 238338, 214370, 106306, 377782, 363771, 377420, 214350, 227104, 214310, 336878, 252689, 376485, 214308, 106253, 370530, 327038, 278018, 214271, 238191, 375901, 226963, 327035, 278015, 372148, 214266, 238188, 238186, 106245, 106216, 106188, 375078, 106180, 106177, 327029, 362111, 106170, 238144, 362097, 374809, 374593, 308606, 373492, 362070, 106098, 214000, 366319, 213998, 362068, 372904, 226869, 213995, 370907, 361311, 369394, 327170, 372868, 308603, 213993, 308598, 366883, 370928, 326906, 226637, 213724, 367770, 368682, 369474, 362004, 213685, 366298, 368603, 368876, 369473, 226601, 252641, 226596, 368495, 359456, 362001, 237985, 213678, 368973, 180865, 363857, 237979, 237973, 226587, 237970, 368796, 252640, 368349, 237946, 366091, 277462, 106028, 106024, 367976, 180827, 213622, 213606, 237940, 366895, 367744, 329961, 226545, 226543, 226538, 366605, 106018, 364768, 366644, 364637, 366289, 365459, 365600, 361086, 237896, 213587, 366455, 309922, 226529, 365665, 309918, 365457, 261991, 342730, 226520, 106001, 365663, 330790, 365104, 365660, 213580, 237876, 365891, 226514, 237863, 226486, 364729, 365641, 364727, 226476, 161455, 328896, 226463, 226459, 213527, 363455, 237795, 308570, 237793, 237791, 361988, 213522, 303199, 180803, 213516, 213511, 180801, 196413, 252615, 237783, 226443, 213496, 350575, 364722, 237776, 318879, 364757, 252608, 364508, 350571, 213486, 213484, 364713, 213482, 364449, 308560, 105935, 213474, 361280, 346835, 213461, 105926, 308548, 196396, 363640, 237739, 213363, 363638, 226337, 363093, 362908, 226329, 308534, 237703, 361984, 213323, 361980, 362961, 363122, 213312, 213309, 105891, 363156, 105889, 361974, 361972, 180780, 180774, 361959, 128979, 237679, 361232, 361082, 361957, 358588, 180756, 361935, 361933, 361929, 180754, 226267, 361927, 360661, 213303, 226254, 361209, 361539, 361195, 105819, 361072, 155138, 361373, 226248, 105811, 353862, 105809, 226245, 252581, 360644, 252578, 226242, 155135, 361364, 237575, 237573, 226234, 237570, 213289, 226231, 360600, 361175, 360330, 361149, 226199, 226196, 105806, 303139, 361011, 226194, 237560, 105803, 347594, 303137, 213281, 361171, 303135, 361070, 361169, 105798, 361066, 237558, 226191, 360216, 237550, 226181, 105792, 361002, 360213, 105790, 237546, 226176, 303121, 226172, 226168, 226166, 237534, 213259, 105787, 360208, 347813, 237521, 226130, 237520, 359561, 226122, 196345, 360310, 294192, 105783, 226121, 360555, 226120, 303093, 360328, 360553, 237519, 226115, 213240, 226098, 226095, 213219, 105774, 213210, 359418, 359718, 303088, 358514, 44877, 360156, 360205, 213204, 226067, 213201, 360153, 105764, 213199, 360203, 226048, 359578, 308531, 226046, 213190, 105756, 226024, 237486, 213188, 226016, 359359, 226014, 237480, 350011, 44870, 105754, 305526, 225983, 105731, 273856, 213163, 359012, 225977, 225960, 213111, 213083, 225943, 213081, 225940, 225936, 358455, 358627, 225931, 358561, 213077, 237405, 213072, 358637, 358000, 358625, 279819, 356977, 358549, 213070, 353858, 237388, 225922, 213067, 358448, 213065, 105694, 225917, 358314, 225905, 358093, 105688, 225902, 225900, 357571, 357035, 357031, 237356, 357569, 237351, 358087, 350553, 213049, 225897, 213039, 213036, 358058, 356764, 358056, 105679, 357025, 225892, 105677, 268863, 105675, 213034, 268861, 358015, 105672, 213025, 237340, 213012, 356758, 237336, 225883, 357668, 237334, 225881, 356756, 348060, 105670, 308514, 308512, 213000, 105668, 357824, 252535, 237326, 105664, 212995, 252533, 357017, 225850, 237298, 225792, 356932, 212960, 44853, 356744, 105657, 356914, 105653, 225788, 212958, 356555, 225784, 212954, 105650, 212952, 105643, 356737, 105639, 225760, 356548, 180722, 212938, 237264, 356385, 131737, 180719, 212913, 196261, 212911, 196259, 266109, 308510, 212905, 196257, 212902, 266105, 180716, 212900, 308505, 212896, 308501, 196255, 180711, 180709, 225735, 291439, 225731, 180707, 212894, 356449, 355434, 355216, 355414, 354366, 156892, 180701, 105638, 356530, 180698, 105636, 308498, 212888, 309903, 353851, 131730, 308493, 131728, 225720, 308491, 212883, 212880, 355300, 237250, 212878, 105634, 225717, 212876, 356476, 355393, 212869, 225710, 212867, 105623, 237243, 212861, 105619, 212857, 225702, 212854, 105616, 225680, 356381, 237227, 212844, 191771, 225671, 225669, 237222, 191768, 356202, 355386, 237220, 225667, 356377, 225656, 212827, 354821, 237215, 356112, 356105, 225646, 212818, 343269, 354195, 354327, 268126, 346196, 225644, 237211, 180683, 212816, 355412, 180674, 355408, 225626, 346189, 225624, 310118, 212808, 225610, 225598, 180655, 310316, 354686, 225567, 180646, 225559, 105589, 105585, 225556, 354543, 354541, 212763, 237175, 105582, 180644, 180627, 105578, 105575, 212761, 225535, 180617, 105565, 212744, 105563, 354011, 180599, 350538, 354009, 353298, 354104, 267249, 180594, 237144, 105557, 350530, 180592, 237142, 105554, 225528, 353820, 353710, 212736, 105547, 353896, 345125, 191755, 225522, 237140, 105534, 353885, 353565, 225510, 294174, 105526, 294172, 225508, 353630, 212732, 105524, 212729, 212726, 105522, 353559, 105515, 352760, 310112, 310110, 225488, 225485, 303071, 105511, 237117, 353417, 225483, 353415, 105509, 353227, 353405, 212713, 105507, 105461, 225427, 105459, 350507, 212634, 225367, 105457, 346758, 350871, 105452, 212631, 212618, 212605, 105449, 237020, 237017, 225335, 351580, 225284, 350505, 212592, 348767, 212590, 225281, 105422, 350497, 345841, 225269, 105416, 350345, 350104, 350289, 350195, 349280, 332832, 212552, 350209, 212528, 334638, 349786, 334628, 349849, 347674, 349847, 350004, 349845, 349781, 349843, 348390, 348037, 345015, 277396, 348035, 212469, 205263, 252390, 225092, 347169, 347025, 225090, 225085, 131620, 347083, 347020, 225083, 273850, 225074, 212454, 347136, 273847, 308457, 346129, 212439, 252385, 346534, 333183, 252373, 345434, 319343, 345423, 344978, 225006, 105414, 345429, 345396, 344603, 273840, 236812, 212311, 310178, 212293, 224957, 224953, 212291, 343621, 344121, 224921, 344029, 224903, 236797, 343610, 212255, 330769, 343554, 236782, 212253, 180445, 343502, 343481, 212214, 224870, 236749, 212150, 224805, 236680, 336855, 236665, 224794, 212145, 341771, 341566, 338113, 224773, 341767, 252326, 236657, 252323, 224771, 105338, 308439, 224766, 341643, 341641, 341428, 212127, 308430, 212125, 105330, 341472, 212122, 224758, 224755, 340554, 340552, 224744, 212098, 340945, 236616, 224730, 224728, 212082, 279078, 23290, 23288, 340548, 105329, 212072, 340397, 205244, 236601, 105326, 180438, 224716, 212059, 294163, 341169, 224663, 340718, 252301, 294005, 273814, 340715, 236555, 212028, 224649, 340620, 340469, 236553, 105318, 105310, 224648, 105306, 211996, 339913, 236502, 211988, 211981, 339909, 336146, 105269, 236497, 236495, 105261, 236492, 308419, 236489, 236485, 211959, 339661, 339655, 339648, 339643, 339640, 236476, 308415, 236474, 308412, 338883, 211925, 236436, 180427, 337908, 338050, 211773, 236378, 180386, 236332, 252160, 335853, 336090, 252159, 211666, 195983, 195980, 195978, 331657, 331655, 335757, 236246, 224458, 224456, 252148, 331650, 252146, 334979, 335500, 335456, 224453, 252144, 180385, 57102, 224451, 335582, 236238, 224449, 285825, 224447, 211640, 265358, 211611, 180367, 180353, 224422, 211579, 224409, 224407, 156217, 224405, 156214, 180339, 105195, 105191, 335321, 224395, 180336, 180334, 224380, 236116, 334277, 224367, 211517, 334075, 236098, 297880, 236088, 334391, 224357, 211492, 224354, 236080, 332567, 224338, 332210, 211475, 236071, 224332, 236063, 224327, 211473, 105139, 331747, 236059, 224319, 105127, 211457, 211429, 334058, 333115, 224306, 332627, 211419, 211412, 277318, 332680, 211395, 326697, 236019, 224246, 211358, 332382, 332394, 205115, 328962, 332392, 105105, 252118, 266091, 131506, 235999, 105103, 224226, 224224, 105100, 235994, 23282, 235992, 105098, 224222, 211349, 235980, 211338, 29984, 235973, 331852, 331850, 326885, 181429, 211293, 211291, 331844, 327893, 211288, 327887, 331840, 194108, 331906, 331838, 180329, 326687, 328489, 211285, 326685, 328487, 301721, 329550, 331195, 331148, 181422, 181420, 181412, 331916, 331902, 329547, 327265, 328485, 181409, 195937, 331824, 252112, 331813, 328483, 331728, 331808, 330925, 331806, 328023, 331803, 331146, 195931, 331801, 331800, 331790, 264111, 328479, 331787, 328022, 331144, 328477, 277307, 331029, 211247, 224149, 331022, 224140, 331042, 224138, 331010, 224136, 105065, 224134, 224117, 211241, 235950, 235948, 329441, 195922, 329455, 235942, 224100, 329453, 235937, 252100, 235935, 211212, 329144, 319802, 211198, 328147, 328630, 327971, 328674, 211176, 159274, 224073, 235926, 328145, 328120, 211169, 328266, 328207, 328192, 235902, 211165, 252092, 252089, 328111, 328134, 328126, 328131, 235899, 328006, 305643, 328004, 327881, 224049, 224047, 327879, 308382, 235895, 211163, 224045, 224040, 205108, 327075, 327461, 277303, 327457, 327394, 326764, 305635, 305630, 260942, 131470, 252073, 131465, 327011, 327247, 252069, 310131, 205093, 327093, 318539, 205091, 180313, 235888, 327245, 326878, 195888, 327072, 224025, 326977, 318532, 318530, 307561, 327007, 326760, 326862, 211138, 326752, 326750, 252065, 326540, 325612, 211129, 312002, 312000, 318415, 306903, 277301, 277299, 306900, 223964, 326345, 323685, 301448, 180304, 235872, 180301, 325606, 260922, 235867, 235864, 277297, 306898, 306896, 318247, 180297, 180293, 195876, 306894, 318244, 325586, 325468, 252062, 12602, 325584, 262984, 301445, 320110, 318239, 260912, 252058, 211109, 325279, 306892, 223957, 320106, 318232, 323681, 223953, 105044, 195874, 223946, 325914, 306890, 105040, 235860, 308379, 223937, 308377, 325329, 325437, 223933, 223931, 112987, 223915, 180286, 211102, 180269, 295332, 323673, 180260, 180258, 180251, 180247, 180242, 180240, 320242, 223912, 180229, 235852, 321830, 211085, 180227, 294964, 223910, 223906, 223903, 180224, 211083, 180222, 319481, 319463, 211081, 264061, 211063, 202613, 294958, 211061, 279798, 223888, 211059, 202609, 307558, 299814, 202603, 180213, 235845, 294953, 223883, 180207, 202585, 264057, 264054, 321340, 321417, 321415, 264048, 180202, 180200, 105038, 180198, 264046, 321579, 252044, 252042, 321352, 321350, 321407, 264036, 320240, 105032, 205077, 211019, 211012, 320221, 180179, 223829, 211009, 180176, 189617, 180174, 105004, 223826, 211004, 180172, 104998, 311996, 318409, 104994, 180169, 189614, 235788, 223822, 211001, 104988, 104982, 210999, 180162, 319508, 319378, 319578, 180159, 180157, 319504, 319570, 319340, 235781, 223818, 210988, 319376, 131463, 319193, 235762, 260882, 235760, 223806, 223796, 205070, 223793, 180149, 223790, 235756, 223788, 210954, 223763, 318402, 305882, 223760, 235749, 210952, 223758, 318628, 223755, 210950, 223744, 223742, 308374, 223737, 223735, 180142, 318202, 318142, 318197, 316954, 180138, 235739, 235737, 235735, 223728, 223724, 235729, 210902, 210900, 312699, 210898, 180131, 23271, 314539, 317044, 180129, 205065, 23269, 252012, 316932, 180128, 317470, 316077, 316071, 307542, 141140, 316069, 210883, 180102, 180099, 316838, 180092, 316715, 251992, 316060, 316802, 316055, 180078, 316701, 223717, 235714, 210856, 235700, 180070, 251985, 316279, 180063, 210828, 223681, 210825, 316030, 223677, 315840, 210820, 277294, 316028, 315838, 315971, 210818, 315836, 308372, 223675, 223651, 306885, 315505, 315490, 277285, 104977, 315317, 235679, 315314, 315307, 315303, 315286, 223646, 251959, 251957, 314520, 314517, 251951, 315229, 251949, 104974, 315176, 104971, 210771, 104968, 104964, 315174, 104961, 104958, 314972, 180052, 223643, 210766, 312540, 312687, 235675, 104953, 210764, 314514, 210758, 235666, 313509, 314466, 210756, 180050, 312533, 223628, 251943, 104946, 180023, 314464, 314461, 104938, 314459, 314457, 223623, 104933, 223621, 314454, 223619, 104928, 314451, 314448, 266056, 251938, 210748, 210746, 314503, 314362, 307716, 223604, 251927, 251919, 180014, 313438, 251913, 313435, 223601, 223598, 314070, 131455, 311633, 314089, 235631, 235629, 314160, 235618, 313982, 235616, 235614, 223585, 195822, 223582, 314019, 313919, 311630, 235612, 251906, 223580, 195815, 235602, 235598, 223575, 210729, 104917, 313816, 104914, 307707, 195801, 264029, 257182, 235588, 223571, 306161, 313429, 223567, 180000, 210720, 210706, 210704, 251888, 311715, 251880, 279890, 277275, 312581, 313424, 313672, 210691, 311708, 311703, 313503, 313375, 311626, 210684, 308361, 311624, 305202, 223558, 257173, 308358, 210670, 223554, 179980, 104906, 312565, 104902, 235580, 104898, 251870, 104896, 210661, 313369, 312563, 313366, 104891, 210659, 104886, 312779, 313363, 304673, 179978, 104883, 313458, 210651, 104879, 210649, 223544, 251862, 313358, 313419, 313347, 223541, 235576, 313354, 279888, 104876, 277668, 104874, 308353, 312848, 223537, 308351, 179976, 104868, 294139, 210647, 308349, 312734, 308346, 179967, 223516, 210618, 223511, 210612, 312552, 210604, 195784, 210602, 104856, 308172, 223492, 223487, 223483, 312458, 223481, 312464, 265326, 312453, 309861, 312451, 265324, 195779, 307526, 312416, 312238, 210594, 305587, 104838, 104834, 312229, 205044, 306151, 306149, 205042, 294125, 210584, 251840, 251837, 311843, 311776, 235556, 210558, 223439, 308167, 308165, 301181, 251834, 210543, 311301, 307443, 104830, 310666, 235542, 279043, 310664, 311245, 311091, 210526, 311086, 310631, 310659, 104826, 210524, 310656, 267630, 310626, 235535, 271344, 310654, 251830, 307699, 104822, 104818, 310456, 307492, 310349, 308319, 104813, 223411, 104807, 310099, 307489, 223408, 104805, 251821, 104802, 309851, 195768, 235532, 308301, 223405, 308293, 310120, 264009, 264007, 310087, 307837, 310084, 307646, 306657, 223401, 260850, 306652, 279040, 283287, 307654, 223396, 235528, 307226, 235525, 306644, 307626, 306641, 307222, 306639, 307835, 179941, 307434, 305480, 307623, 195767, 210507, 307642, 307364, 223394, 307377, 251814, 305470, 307255, 305818, 179936, 305446, 307116, 307176, 223373, 307011, 251801, 307004, 251799, 223365, 251797, 251795, 179930, 223360, 223355, 283279, 223353, 195761, 283276, 305814, 235510, 614305, 223350, 223348, 306740, 303790, 306722, 306706, 251790, 306599, 306718, 305812, 306702, 223345, 223342, 306595, 306592, 223337, 251784, 210500, 223331, 179922, 263999, 306102, 306195, 305839, 123454, 305992, 251781, 251779, 305735, 123448, 263996, 179919, 271585, 210493, 305807, 305828, 210486, 210484, 223308, 262854, 305804, 305802, 179915, 299551, 210471, 305730, 279035, 174185, 210463, 305724, 305573, 304159, 305569, 179903, 223273, 223270, 305528, 210453, 305249, 305242, 299531, 251759, 160799, 303586, 191733, 179887, 302979, 305281, 191731, 251755, 251752, 304665, 302643, 266042, 301715, 266040, 195743, 305236, 195741, 305269, 223243, 253266, 302037, 305234, 223241, 223240, 223234, 266038, 305143, 266036, 223232, 195739, 223226, 303696, 210443, 223222, 210438, 235466, 303694, 302604, 304910, 210429, 304517, 104800, 235462, 104798, 210426, 251730, 210415, 251727, 251724, 104793, 210409, 210407, 304114, 304131, 303974, 304531, 302513, 304128, 179881, 235449, 299786, 210402, 263992, 288123, 304126, 251722, 251720, 251718, 304511, 303971, 210399, 304085, 304075, 191725, 303963, 301700, 235443, 299670, 303035, 303664, 303706, 303683, 303651, 303642, 303634, 303563, 303630, 210367, 303561, 251704, 223197, 223190, 179870, 191717, 302962, 210347, 251700, 251699, 302406, 303511, 210342, 303020, 302958, 302901, 303016, 303509, 303504, 179867, 303496, 179864, 303013, 303011, 191715, 288017, 288015, 302627, 302625, 302587, 288012, 302888, 294620, 302580, 210337, 294617, 302571, 302568, 302559, 301953, 210331, 302555, 210329, 301324, 210327, 301685, 301683, 210320, 179857, 301681, 210318, 302517, 251692, 210314, 301991, 160784, 210311, 301051, 104791, 299756, 104789, 104787, 300981, 36026, 36024, 301608, 251664, 266028, 299745, 301596, 301458, 104775, 251652, 301315, 104772, 251645, 301145, 301294, 210268, 235438, 235436, 301256, 300769, 301197, 291216, 300890, 291211, 251635, 251631, 296203, 301065, 296201, 301043, 251629, 301029, 291205, 210243, 301058, 269211, 299729, 291202, 179833, 104763, 300624, 210239, 299329, 267221, 251624, 300606, 251622, 298779, 297801, 299325, 251618, 299515, 300491, 298959, 298957, 223169, 223167, 298412, 299864, 287790, 251615, 251605, 131414, 179820, 298777, 299461, 299322, 299452, 123441, 299871, 299861, 299869, 251602, 294123, 205036, 131412, 287594, 299509, 299652, 299316, 298410, 210226, 299649, 299313, 251581, 251579, 251577, 266019, 210199, 223153, 223150, 195710, 104734, 210190, 251575, 210179, 104729, 298291, 298286, 266017, 297203, 210168, 297201, 287785, 297621, 297614, 210159, 179773, 210157, 297196, 251563, 210155, 210153, 288006, 298076, 179760, 210126, 295952, 287999, 210111, 297189, 293941, 210108, 251559, 296693, 179741, 296263, 297184, 296431, 297075, 179738, 251557, 296048, 251555, 183034, 183032, 295751, 179730, 295872, 195694, 104723, 251553, 294752, 251548, 295730, 295266, 174164, 174162, 223126, 174159, 195690, 174156, 251526, 251517, 295193, 251514, 179725, 295034, 251512, 210025, 251508, 251502, 251501, 294742, 294714, 294702, 287677, 294697, 294680, 294667, 293836, 104719, 104715, 104714, 210020, 104710, 294585, 210017, 294581, 210012, 204995, 179715, 174153, 267868, 174145, 267865, 293902, 294260, 293898, 294258, 179712, 179710, 293895, 294256, 294110, 209996, 294108, 209994, 294103, 179707, 291626, 294085, 293869, 291624, 291322, 293863, 195680, 179699, 291622, 293858, 293854, 131325, 291318, 291315, 104702, 291312, 291584, 204993, 251496, 104689, 195677, 104684, 104681, 104679, 131293, 251488, 209979, 291501, 131291, 179691, 104654, 287828, 291252, 291259, 209968, 179685, 195675, 265940, 287825, 265936, 289959, 104633, 265934, 290379, 291027, 289956, 265930, 269686, 269684, 290990, 291012, 285809, 188646, 290302, 290154, 251475, 287983, 287977, 287973, 104544, 179628, 251464, 179626, 251461, 287795, 287776, 204981, 287774, 287643, 284540, 287588, 104503, 284533, 287520, 287516, 287566, 209847, 16593, 279955, 279952, 179585, 179570, 179550, 209825, 285755, 251457, 285888, 272061, 182999, 277562, 285583, 285040, 126150, 209809, 285743, 262324, 131256, 285411, 262317, 131249, 268623, 285404, 278885, 179525, 262312, 283274, 273802, 179517, 179511, 223091, 284568, 278945, 262310, 179365, 273253, 273251, 265913, 265910, 269197, 273248, 269195, 269193, 179361, 273791, 223080, 273244, 179339, 276441, 273234, 143034, 179331, 277040, 276435, 179329, 276431, 104388, 271133, 270441, 270438, 270828, 268605, 270430, 179175, 179172, 270421, 104320, 270417, 104314, 104305, 179159, 104303, 104295, 179150, 179148, 104293, 223030, 270759, 191694, 270383, 270649, 270756, 266262, 270646, 270412, 209543, 223027, 270381, 266260, 104286, 223025, 191692, 191690, 270643, 178912, 186794, 269144, 178824, 222935, 222933, 178687, 178684, 178681, 178673, 266300, 178667, 178661, 264953, 263883, 265249, 178649, 263881, 265247, 263879, 178641, 266292, 266290, 178586, 267115, 265618, 256300, 178472, 265169, 204972, 178086, 131175, 178082, 204970, 131172, 178080, 204967, 178077, 204965, 195625, 186793, 178061, 257425, 178059, 178057, 178055, 178053, 178049, 178045, 140976, 178042, 257420, 178040, 178036, 257416, 186790, 186785, 257412, 186779, 186777, 178034, 186774, 186771, 178032, 186769, 262039, 186766, 178027, 186764, 257408, 178024, 260417, 178021, 257404, 178019, 178018, 257388, 178007, 265026, 178004, 260415, 264849, 177996, 195623, 209301, 258262, 251379, 260402, 186749, 177981, 209297, 257553, 186743, 177969, 177966, 186737, 104224, 186733, 264982, 264595, 177960, 131159, 177942, 264593, 131158, 104205, 131156, 264678, 177887, 177885, 260400, 131154, 177884, 263739, 131148, 263736, 177872, 131146, 261986, 318864, 261843, 186731, 264590, 177870, 177859, 177857, 260381, 260379, 251366, 104203, 251362, 264491, 263206, 104200, 177848, 264584, 263146, 177735, 186728, 177732, 263143, 261979, 318857, 263536, 177726, 263141, 209277, 177716, 263199, 177648, 260365, 177613, 262009, 222916, 254424, 262041, 177528, 255693, 177524, 177497, 260350, 255688, 260347, 256282, 260344, 177491, 255685, 256274, 186665, 256270, 131083, 256268, 254417, 261668, 182921, 222908, 260341, 251322, 177473, 255680, 186654, 251307, 186638, 256265, 131077, 256263, 104183, 177461, 261408, 182916, 256698, 256260, 131073, 177459, 251304, 260332, 177456, 251302, 177449, 177445, 104180, 260323, 177430, 256257, 177427, 260302, 177424, 260299, 209200, 261404, 222158, 177420, 260297, 222156, 261396, 259641, 186632, 259639, 186628, 260281, 131054, 260279, 261452, 222153, 250703, 260995, 261451, 260277, 104176, 177404, 186623, 261360, 261467, 186621, 222150, 222902, 261461, 209197, 104172, 260270, 261458, 209195, 177346, 104162, 260238, 104160, 104156, 260234, 257382, 177335, 177332, 260231, 104153, 260228, 177320, 260221, 222148, 186606, 260218, 260215, 260209, 261169, 209166, 260205, 260821, 186603, 186601, 186594, 260721, 122594, 255675, 186591, 261162, 186589, 255673, 186587, 260718, 261159, 104139, 261157, 260202, 177307, 122591, 258411, 260984, 260716, 260189, 186582, 195585, 131037, 104137, 260164, 186559, 177278, 186557, 258403, 131001, 260152, 235285, 251280, 260150, 177275, 177273, 251278, 260148, 177271, 186554, 258400, 177269, 260144, 258397, 251276, 177237, 258391, 260115, 260113, 177226, 260104, 177220, 260101, 260096, 260420, 260020, 177192, 260009, 186537, 209131, 177181, 255370, 177178, 122576, 186532, 259930, 177175, 259141, 255365, 249213, 259139, 249210, 258920, 255363, 258918, 186526, 204503, 259582, 128860, 104071, 258906, 259728, 128854, 186515, 259760, 104060, 104057, 259757, 259753, 204500, 259577, 186509, 177132, 259746, 177123, 177121, 259721, 14527, 259571, 186496, 177116, 177113, 186490, 177105, 259569, 251271, 177101, 259035, 195564, 259033, 177090, 186486, 259563, 177087, 222891, 251269, 186480, 251268, 104052, 259496, 195558, 258009, 195556, 259494, 195554, 104048, 259492, 104042, 104040, 259484, 259022, 259482, 104037, 259480, 258968, 259478, 104034, 259020, 259475, 257105, 259129, 257103, 186465, 257101, 258388, 186463, 195552, 259473, 259469, 258385, 259467, 177034, 259450, 259464, 186460, 104032, 177031, 259083, 186458, 259259, 177029, 104030, 259447, 104026, 259127, 104024, 104022, 104020, 257096, 259370, 259386, 259361, 259073, 259368, 259359, 177024, 259071, 177021, 258002, 259069, 253373, 259067, 256488, 258000, 256486, 259065, 186445, 259017, 259014, 195538, 259012, 186442, 222890, 177017, 259356, 259354, 177015, 259010, 259352, 186438, 195536, 130998, 259120, 176999, 176995, 258898, 176992, 209113, 257092, 176990, 209111, 258938, 257496, 258935, 258960, 258895, 258847, 176969, 176967, 258930, 258999, 258957, 253370, 176965, 209105, 186422, 176956, 256475, 253367, 258891, 176954, 258889, 209100, 258953, 258887, 176952, 254898, 176949, 253365, 186419, 258922, 253363, 255668, 186417, 253361, 176947, 248671, 253356, 253355, 253354, 253353, 253352, 253351, 253350, 253349, 253348, 253347, 248669, 128846, 176945, 257380, 222884, 258885, 258881, 258879, 258877, 257378, 209098, 258873, 204959, 258871, 222876, 255664, 257089, 255662, 256473, 258591, 257376, 176941, 209096, 257363, 258584, 257679, 258582, 248667, 258579, 257086, 186413, 176937, 258577, 248662, 257083, 203640, 257081, 195534, 256450, 257357, 258571, 195531, 258569, 257991, 257079, 258564, 257350, 257076, 256444, 256018, 258610, 195527, 258608, 258486, 195524, 256147, 258315, 256144, 256141, 195522, 257344, 258560, 258197, 258603, 258434, 257072, 258553, 258551, 209088, 258549, 257070, 256133, 255658, 195513, 176931, 257066, 257064, 256129, 256127, 255650, 256125, 257061, 257058, 204644, 257340, 176928, 195507, 222861, 204642, 204634, 255646, 258421, 195496, 176923, 258195, 257051, 258381, 130988, 258308, 249207, 130986, 209080, 176921, 209076, 209074, 130981, 176912, 209059, 258362, 257337, 249205, 249202, 140940, 257324, 204630, 257319, 130966, 258177, 140937, 130963, 257845, 255636, 257460, 204628, 257842, 203952, 195491, 176882, 203950, 204625, 186408, 257674, 248658, 209029, 203948, 176879, 248656, 176874, 258174, 249200, 203944, 257316, 176871, 248654, 248651, 176868, 255632, 248642, 257967, 251249, 176860, 176856, 257825, 176852, 186405, 257822, 176847, 257899, 176844, 257971, 184618, 257804, 176837, 176833, 257897, 176831, 143240, 257891, 248639, 257889, 257802, 128838, 257887, 128836, 257962, 258028, 176824, 257043, 257458, 255624, 184616, 257313, 209027, 257820, 176820, 257814, 257309, 176812, 251242, 222843, 176810, 222840, 257306, 222837, 257302, 222834, 257668, 195464, 257296, 257665, 257038, 195462, 209024, 222832, 257293, 195460, 257291, 222828, 257286, 257036, 255620, 195445, 176804, 257648, 257645, 222813, 249379, 176799, 176797, 222810, 257557, 222808, 255608, 184602, 222806, 257277, 184600, 249377, 254280, 186403, 257030, 255599, 222804, 204950, 204948, 249801, 186396, 257273, 204946, 257022, 255594, 257019, 257271, 204944, 257017, 255592, 204942, 257269, 257513, 257547, 255590, 257015, 122559, 257584, 176795, 257568, 122556, 257566, 257266, 176791, 257564, 204940, 257263, 204938, 257260, 176789, 257510, 257011, 209017, 256867, 256864, 204935, 204933, 176781, 256434, 257502, 257255, 255588, 257455, 176779, 257253, 209009, 255586, 257007, 257450, 257447, 256580, 257487, 222795, 209006, 257250, 204931, 251227, 256995, 256993, 257242, 256343, 254942, 186394, 256913, 256861, 256989, 256911, 256612, 256985, 186392, 256907, 186382, 256975, 251224, 186380, 256973, 256971, 186378, 186374, 254947, 254269, 256892, 256852, 256890, 186369, 255241, 186367, 255239, 186362, 186360, 255237, 186354, 251220, 186351, 186349, 255235, 186343, 256848, 251217, 186341, 186334, 256680, 256678, 251204, 256605, 256603, 251202, 195436, 256600, 256636, 256634, 251199, 256595, 222213, 176766, 204927, 251194, 176764, 208984, 204925, 222209, 251192, 186325, 186323, 254261, 186321, 186319, 254259, 256517, 256577, 254257, 130954, 186315, 255170, 254251, 256515, 130950, 255167, 186313, 255165, 186311, 255163, 186308, 255161, 186305, 256511, 186303, 256339, 208977, 186299, 208975, 203114, 186297, 256337, 256428, 256519, 256335, 130946, 256080, 255156, 256412, 204922, 176761, 256410, 256508, 176759, 256506, 256078, 208970, 176755, 256063, 247794, 176753, 255151, 176751, 256237, 256235, 176747, 256229, 256050, 204919, 176743, 256048, 208964, 256107, 176736, 256104, 256102, 256099, 130935, 256097, 176734, 130931, 176732, 256034, 222790, 256031, 130927, 256028, 256026, 204916, 255583, 204914, 130923, 176730, 256007, 255035, 255580, 176726, 176721, 176719, 255911, 176717, 255909, 255856, 130920, 140925, 204912, 256023, 130918, 140923, 255577, 140917, 255575, 255854, 254938, 140914, 255852, 255902, 255932, 255032, 255995, 140912, 222784, 208960, 255139, 255573, 186295, 186292, 130912, 255830, 255348, 255558, 130898, 255093, 255556, 130896, 130894, 255553, 130890, 255550, 130887, 255342, 255136, 130885, 130883, 222754, 255548, 255771, 255530, 255273, 130873, 255127, 255525, 255334, 204908, 104017, 130871, 249366, 255224, 130858, 255061, 130856, 130841, 255116, 130839, 176715, 255220, 255082, 255114, 249142, 255218, 104015, 176713, 204905, 104013, 176711, 255058, 255022, 255056, 255054, 104010, 130832, 176709, 208955, 255252, 255213, 208952, 104008, 176706, 254932, 254233, 186288, 254930, 254970, 251176, 251174, 249138, 254927, 249134, 254919, 254913, 254904, 254902, 249132, 253903, 249130, 253900, 251165, 249128, 251163, 249121, 176683, 176681, 251161, 254474, 253890, 253888, 251158, 254821, 249119, 195414, 176678, 254819, 186285, 186283, 253880, 254761, 103994, 254229, 235282, 208945, 103991, 186279, 254225, 254555, 249871, 235280, 176676, 103971, 249868, 253874, 254567, 254216, 247542, 253861, 254541, 191525, 253859, 254214, 254538, 191523, 247540, 251149, 191520, 254212, 247535, 254405, 253857, 208938, 254533, 249604, 254403, 235277, 250700, 247533, 250698, 208936, 247531, 250696, 254462, 254396, 186272, 235273, 254458, 235267, 254393, 254391, 186270, 235265, 251143, 176661, 186265, 176659, 251141, 251137, 186253, 254454, 251135, 254389, 253474, 222405, 254201, 203259, 254387, 253472, 254198, 222750, 222748, 186250, 186248, 186246, 253050, 186244, 254178, 186242, 253324, 222742, 176654, 186240, 195113, 250694, 254175, 208921, 186236, 254173, 208918, 222740, 254170, 222737, 254161, 208916, 206650, 248056, 254166, 248637, 176651, 253456, 206647, 253443, 186229, 253484, 248626, 253469, 248621, 248619, 253432, 253465, 130822, 253481, 250867, 186225, 253463, 176638, 253083, 253389, 253428, 253080, 253425, 253460, 253423, 249859, 253421, 251124, 176635, 251122, 253310, 253419, 103961, 248616, 253417, 248614, 252929, 253308, 248612, 253414, 176631, 253382, 248610, 176629, 253346, 195111, 249857, 248608, 253306, 253191, 253078, 253304, 130819, 253302, 253344, 253166, 253341, 208913, 208911, 253164, 253297, 208909, 248044, 251121, 248040, 253162, 176625, 176623, 251118, 208902, 253204, 252919, 176610, 253201, 176608, 186220, 208891, 253160, 176606, 208889, 253156, 186217, 176603, 208873, 253060, 251095, 251091, 252916, 252914, 253019, 253017, 253013, 253052, 176592, 253009, 253007, 184992, 253002, 250478, 250940, 192112, 186213, 249771, 250476, 186210, 248016, 186208, 130815, 176591, 186206, 250855, 249843, 248011, 186203, 195408, 249841, 251090, 249839, 250847, 250028, 176578, 186199, 176576, 208862, 250471, 250838, 248606, 251082, 208858, 250780, 208853, 250466, 206638, 208851, 176564, 250760, 250922, 176560, 208849, 250691, 176549, 250686, 194489, 250682, 194486, 250753, 248268, 250765, 208842, 248266, 208840, 186194, 248264, 201341, 194481, 192110, 250630, 206635, 248261, 103957, 103955, 250676, 250620, 194473, 206633, 248253, 103952, 248595, 176543, 208838, 250667, 250492, 248586, 208833, 128832, 103941, 184990, 103939, 194469, 103935, 176527, 184986, 248236, 249590, 176524, 176521, 184983, 249554, 249581, 249360, 176517, 103929, 130809, 222735, 208826, 248226, 250389, 208822, 186173, 248217, 103923, 248213, 249544, 249356, 250024, 103921, 249766, 208252, 249639, 193164, 193162, 103919, 249816, 208793, 249812, 191443, 184971, 103916, 249664, 186171, 208790, 103912, 249810, 249662, 130800, 249760, 103910, 249573, 208786, 249660, 249752, 176503, 191436, 128824, 249750, 103907, 176501, 103905, 103903, 176499, 103901, 249745, 130798, 208781, 176497, 249635, 248877, 249534, 249568, 249339, 249741, 176495, 248875, 176493, 206299, 249529, 248871, 249524, 248868, 249443, 249117, 249440, 248863, 249431, 248495, 249114, 175386, 249331, 248857, 249427, 248855, 248493, 248853, 248491, 249328, 249326, 249323, 249319, 249314, 248488, 194106, 249312, 176489, 176484, 248477, 176482, 248473, 248851, 191435, 176479, 176470, 249258, 130790, 176467, 176465, 130783, 248849, 248194, 130781, 248847, 248846, 248845, 248182, 248174, 130776, 207589, 248725, 130774, 130772, 248078, 208776, 248843, 208774, 248840, 192229, 206630, 248838, 247792, 248836, 247790, 248834, 248168, 192226, 208766, 208763, 248980, 249109, 249171, 193044, 249166, 208753, 249164, 249163, 208751, 193037, 248822, 249106, 248820, 206621, 248818, 103899, 130762, 208748, 248977, 615236, 248813, 248811, 249069, 208745, 248975, 248758, 248972, 248158, 248156, 247636, 202209, 207306, 248122, 248147, 248968, 248465, 248755, 248145, 248143, 176455, 176452, 176449, 248808, 248806, 128817, 176447, 248804, 176444, 128814, 176442, 176436, 176433, 248799, 176431, 248795, 208735, 176428, 248463, 176421, 176420, 176413, 248455, 248718, 176411, 208729, 176407, 176405, 248412, 206609, 248521, 206604, 206602, 206600, 208721, 248564, 248516, 248561, 248133, 208717, 247999, 247994, 248128, 247992, 248402, 248400, 247989, 207357, 247671, 103890, 247987, 247802, 247983, 103888, 247453, 247799, 247976, 207388, 247775, 247773, 103881, 247518, 193034, 247756, 247754, 247753, 193029, 247740, 247738, 193027, 207386, 207384, 247604, 203105, 207382, 130752, 247664, 247601, 247708, 247599, 247662, 247660, 247698, 247650, 247596, 247594, 247648, 247592, 247644, 208500, 203179, 247642, 203173, 222143, 247590, 130743, 130741, 247588, 247587, 130739, 208690, 247585, 222142, 222140, 222138, 130737, 103874, 208439, 103861, 208436, 222376, 130734, 103855, 130727, 235263, 208682, 222374, 235259, 208679, 190839, 208677, 235256, 207842, 207829, 207828, 207825, 207824, 207819, 207817, 207814, 204449, 208237, 204447, 207810, 103823, 208234, 204444, 208369, 208230, 208229, 208226, 208222, 615231, 207796, 208216, 207780, 207761, 204441, 207758, 204438, 207743, 615213, 207738, 207737, 103798, 207729, 103791, 207695, 207693, 103787, 207691, 207690, 207689, 207688, 207684, 207855, 207682, 207681, 207853, 207672, 207669, 207848, 207667, 207664, 207658, 175385, 203722, 206790, 207186, 175383, 615198, 204423, 188057, 204894, 185737, 202173, 185734, 203718, 185731, 204883, 188054, 206807, 206787, 204879, 206785, 204414, 185721, 204409, 191426, 202530, 204471, 204402, 615187, 202517, 202662, 202158, 189407, 202658, 170893, 202094, 202197, 202656, 202156, 189405, 156641, 201669, 194737, 156639, 202152, 615162, 189401, 201667, 201664, 201570, 615160, 189399, 194788, 201568, 201658, 191422, 190022, 615158, 202502, 202498, 615154, 615153, 190020, 190018, 189397, 190009, 201558, 201426, 201656, 201553, 201654, 201550, 201652, 194097, 201421, 201419, 201418, 201414, 201410, 193152, 191639, 192861, 189829, 193150, 193135, 182748, 192854, 172344, 192255, 192502, 193119, 182744, 192690, 192852, 192497, 193117, 173454, 193114, 190835, 193112, 103773, 192849, 182742, 103770, 175372, 192687, 192676, 192847, 172342, 182735, 175368, 192494, 192844, 192253, 192674, 191636, 192765, 192763, 192440, 192666, 192368, 191408, 189392, 190887, 103759, 192366, 103757, 103756, 189389, 190884, 191917, 191916, 190881, 191403, 192218, 192217, 192213, 189581, 185882, 189385, 189579, 189822, 189381, 185125, 189994, 189820, 189819, 185877, 185876, 182473, 187569, 185874, 185873, 187565, 182471, 185871, 145256, 182466, 182458, 188594, 188592, 188580, 188570, 189365, 189354, 186884, 187542, 185925, 186882, 185866, 174569, 185864, 184317, 184314, 181474, 169891, 174524, 182712, 170997, 182709, 181465, 182706, 182704, 181461, 170982, 181458, 181389, 181452, 181378, 181448, 150488, 173453, 173446, 173441, 173439, 173436, 173428, 173424, 173417, 173415, 173414, 160625, 160621, 170792, 170760, 170754, 32759, 158778, 158777, 32754, 166043, 166039, 166037, 166033, 158954, 166268, 163216, 163214, 150482, 158101, 160962, 161546, 158098, 158097, 150480, 153101, 163208, 16522, 160956, 160954, 158241, 135479, 135470, 150298, 130390, 135793))
Run Time: 0.181568
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4504 | |
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 | | | | | 4504 | |
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 (28465, 19002, 18057, 16813, 15808, 15630, 15567, 15513, 15392, 15302, 14407, 14330, 13822, 13576, 13374, 13326, 13301, 13282, 13281, 13194, 13133, 13098, 13063, 13058, 13003, 12937, 12928, 12886, 12865, 12846, 12818, 12790, 12788, 12778, 12776, 12615, 12393, 12327, 12151, 12109, 11832, 11758, 11697, 11645, 11496, 11335, 10838, 10248))
Run Time: 0.002927
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 48 | 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 (575260, 585441, 584388, 575294, 572519, 514661, 133185, 450391, 429448, 232602, 485680, 537630, 427956, 458270, 388129, 465021, 395941, 393771, 240293, 388026, 227805, 393721, 392510, 391294, 227609, 389433, 387972, 387969, 214955, 308754, 389987, 389841, 390081, 308752, 308730, 308723, 308716, 214815, 308701, 8494, 227481, 214802, 161748, 385631, 214794, 161745, 386371, 364650, 348337, 214782, 106477, 252749, 106471, 348283, 227398, 385191, 385283, 106467, 106465, 385189, 106448, 383527, 214678, 106422, 384779, 303264, 106405, 214669, 346342, 214666, 214664, 106402, 227371, 346340, 303262, 227362, 384623, 384725, 364641, 384720, 214658, 196875, 196873, 376075, 106395, 214653, 357963, 384621, 214635, 214634, 238627, 106392, 106390, 308694, 227355, 214632, 308692, 227344, 227330, 238563, 227310, 227289, 106360, 227287, 227282, 106357, 382491, 238522, 106353, 214526, 382534, 382489, 381679, 382486, 616433, 214518, 378074, 382531, 382528, 238518, 214516, 227276, 360385, 377430, 238515, 227268, 214503, 330024, 227253, 378895, 336189, 330023, 382147, 382061, 372464, 361808, 336187, 381263, 361805, 378749, 376015, 361803, 377628, 375595, 379259, 227251, 238506, 382089, 214497, 308671, 382085, 214479, 238490, 308662, 308661, 227248, 238486, 381677, 381898, 227240, 381465, 227237, 227235, 379787, 227229, 376060, 379785, 252729, 361797, 330841, 378742, 361795, 214468, 381701, 381211, 320263, 377562, 227196, 379482, 214454, 308659, 379758, 378625, 379104, 271350, 227187, 214426, 227181, 214411, 378738, 305684, 227146, 36055, 378711, 378472, 377505, 305682, 214376, 227133, 371147, 238338, 214370, 106306, 377782, 363771, 377420, 214350, 227104, 214310, 336878, 252689, 376485, 214308, 106253, 370530, 327038, 278018, 214271, 238191, 375901, 226963, 327035, 278015, 372148, 214266, 238188, 238186, 106245, 106216, 106188, 375078, 106180, 106177, 327029, 362111, 106170, 238144, 362097, 374809, 374593, 308606, 373492, 362070, 106098, 214000, 366319, 213998, 362068, 372904, 226869, 213995, 370907, 361311, 369394, 327170, 372868, 308603, 213993, 308598, 366883, 370928, 326906, 226637, 213724, 367770, 368682, 369474, 362004, 213685, 366298, 368603, 368876, 369473, 226601, 252641, 226596, 368495, 359456, 362001, 237985, 213678, 368973, 180865, 363857, 237979, 237973, 226587, 237970, 368796, 252640, 368349, 237946, 366091, 277462, 106028, 106024, 367976, 180827, 213622, 213606, 237940, 366895, 367744, 329961, 226545, 226543, 226538, 366605, 106018, 364768, 366644, 364637, 366289, 365459, 365600, 361086, 237896, 213587, 366455, 309922, 226529, 365665, 309918, 365457, 261991, 342730, 226520, 106001, 365663, 330790, 365104, 365660, 213580, 237876, 365891, 226514, 237863, 226486, 364729, 365641, 364727, 226476, 161455, 328896, 226463, 226459, 213527, 363455, 237795, 308570, 237793, 237791, 361988, 213522, 303199, 180803, 213516, 213511, 180801, 196413, 252615, 237783, 226443, 213496, 350575, 364722, 237776, 318879, 364757, 252608, 364508, 350571, 213486, 213484, 364713, 213482, 364449, 308560, 105935, 213474, 361280, 346835, 213461, 105926, 308548, 196396, 363640, 237739, 213363, 363638, 226337, 363093, 362908, 226329, 308534, 237703, 361984, 213323, 361980, 362961, 363122, 213312, 213309, 105891, 363156, 105889, 361974, 361972, 180780, 180774, 361959, 128979, 237679, 361232, 361082, 361957, 358588, 180756, 361935, 361933, 361929, 180754, 226267, 361927, 360661, 213303, 226254, 361209, 361539, 361195, 105819, 361072, 155138, 361373, 226248, 105811, 353862, 105809, 226245, 252581, 360644, 252578, 226242, 155135, 361364, 237575, 237573, 226234, 237570, 213289, 226231, 360600, 361175, 360330, 361149, 226199, 226196, 105806, 303139, 361011, 226194, 237560, 105803, 347594, 303137, 213281, 361171, 303135, 361070, 361169, 105798, 361066, 237558, 226191, 360216, 237550, 226181, 105792, 361002, 360213, 105790, 237546, 226176, 303121, 226172, 226168, 226166, 237534, 213259, 105787, 360208, 347813, 237521, 226130, 237520, 359561, 226122, 196345, 360310, 294192, 105783, 226121, 360555, 226120, 303093, 360328, 360553, 237519, 226115, 213240, 226098, 226095, 213219, 105774, 213210, 359418, 359718, 303088, 358514, 44877, 360156, 360205, 213204, 226067, 213201, 360153, 105764, 213199, 360203, 226048, 359578, 308531, 226046, 213190, 105756, 226024, 237486, 213188, 226016, 359359, 226014, 237480, 350011, 44870, 105754, 305526, 225983, 105731, 273856, 213163, 359012, 225977, 225960, 213111, 213083, 225943, 213081, 225940, 225936, 358455, 358627, 225931, 358561, 213077, 237405, 213072, 358637, 358000, 358625, 279819, 356977, 358549, 213070, 353858, 237388, 225922, 213067, 358448, 213065, 105694, 225917, 358314, 225905, 358093, 105688, 225902, 225900, 357571, 357035, 357031, 237356, 357569, 237351, 358087, 350553, 213049, 225897, 213039, 213036, 358058, 356764, 358056, 105679, 357025, 225892, 105677, 268863, 105675, 213034, 268861, 358015, 105672, 213025, 237340, 213012, 356758, 237336, 225883, 357668, 237334, 225881, 356756, 348060, 105670, 308514, 308512, 213000, 105668, 357824, 252535, 237326, 105664, 212995, 252533, 357017, 225850, 237298, 225792, 356932, 212960, 44853, 356744, 105657, 356914, 105653, 225788, 212958, 356555, 225784, 212954, 105650, 212952, 105643, 356737, 105639, 225760, 356548, 180722, 212938, 237264, 356385, 131737, 180719, 212913, 196261, 212911, 196259, 266109, 308510, 212905, 196257, 212902, 266105, 180716, 212900, 308505, 212896, 308501, 196255, 180711, 180709, 225735, 291439, 225731, 180707, 212894, 356449, 355434, 355216, 355414, 354366, 156892, 180701, 105638, 356530, 180698, 105636, 308498, 212888, 309903, 353851, 131730, 308493, 131728, 225720, 308491, 212883, 212880, 355300, 237250, 212878, 105634, 225717, 212876, 356476, 355393, 212869, 225710, 212867, 105623, 237243, 212861, 105619, 212857, 225702, 212854, 105616, 225680, 356381, 237227, 212844, 191771, 225671, 225669, 237222, 191768, 356202, 355386, 237220, 225667, 356377, 225656, 212827, 354821, 237215, 356112, 356105, 225646, 212818, 343269, 354195, 354327, 268126, 346196, 225644, 237211, 180683, 212816, 355412, 180674, 355408, 225626, 346189, 225624, 310118, 212808, 225610, 225598, 180655, 310316, 354686, 225567, 180646, 225559, 105589, 105585, 225556, 354543, 354541, 212763, 237175, 105582, 180644, 180627, 105578, 105575, 212761, 225535, 180617, 105565, 212744, 105563, 354011, 180599, 350538, 354009, 353298, 354104, 267249, 180594, 237144, 105557, 350530, 180592, 237142, 105554, 225528, 353820, 353710, 212736, 105547, 353896, 345125, 191755, 225522, 237140, 105534, 353885, 353565, 225510, 294174, 105526, 294172, 225508, 353630, 212732, 105524, 212729, 212726, 105522, 353559, 105515, 352760, 310112, 310110, 225488, 225485, 303071, 105511, 237117, 353417, 225483, 353415, 105509, 353227, 353405, 212713, 105507, 105461, 225427, 105459, 350507, 212634, 225367, 105457, 346758, 350871, 105452, 212631, 212618, 212605, 105449, 237020, 237017, 225335, 351580, 225284, 350505, 212592, 348767, 212590, 225281, 105422, 350497, 345841, 225269, 105416, 350345, 350104, 350289, 350195, 349280, 332832, 212552, 350209, 212528, 334638, 349786, 334628, 349849, 347674, 349847, 350004, 349845, 349781, 349843, 348390, 348037, 345015, 277396, 348035, 212469, 205263, 252390, 225092, 347169, 347025, 225090, 225085, 131620, 347083, 347020, 225083, 273850, 225074, 212454, 347136, 273847, 308457, 346129, 212439, 252385, 346534, 333183, 252373, 345434, 319343, 345423, 344978, 225006, 105414, 345429, 345396, 344603, 273840, 236812, 212311, 310178, 212293, 224957, 224953, 212291, 343621, 344121, 224921, 344029, 224903, 236797, 343610, 212255, 330769, 343554, 236782, 212253, 180445, 343502, 343481, 212214, 224870, 236749, 212150, 224805, 236680, 336855, 236665, 224794, 212145, 341771, 341566, 338113, 224773, 341767, 252326, 236657, 252323, 224771, 105338, 308439, 224766, 341643, 341641, 341428, 212127, 308430, 212125, 105330, 341472, 212122, 224758, 224755, 340554, 340552, 224744, 212098, 340945, 236616, 224730, 224728, 212082, 279078, 23290, 23288, 340548, 105329, 212072, 340397, 205244, 236601, 105326, 180438, 224716, 212059, 294163, 341169, 224663, 340718, 252301, 294005, 273814, 340715, 236555, 212028, 224649, 340620, 340469, 236553, 105318, 105310, 224648, 105306, 211996, 339913, 236502, 211988, 211981, 339909, 336146, 105269, 236497, 236495, 105261, 236492, 308419, 236489, 236485, 211959, 339661, 339655, 339648, 339643, 339640, 236476, 308415, 236474, 308412, 338883, 211925, 236436, 180427, 337908, 338050, 211773, 236378, 180386, 236332, 252160, 335853, 336090, 252159, 211666, 195983, 195980, 195978, 331657, 331655, 335757, 236246, 224458, 224456, 252148, 331650, 252146, 334979, 335500, 335456, 224453, 252144, 180385, 57102, 224451, 335582, 236238, 224449, 285825, 224447, 211640, 265358, 211611, 180367, 180353, 224422, 211579, 224409, 224407, 156217, 224405, 156214, 180339, 105195, 105191, 335321, 224395, 180336, 180334, 224380, 236116, 334277, 224367, 211517, 334075, 236098, 297880, 236088, 334391, 224357, 211492, 224354, 236080, 332567, 224338, 332210, 211475, 236071, 224332, 236063, 224327, 211473, 105139, 331747, 236059, 224319, 105127, 211457, 211429, 334058, 333115, 224306, 332627, 211419, 211412, 277318, 332680, 211395, 326697, 236019, 224246, 211358, 332382, 332394, 205115, 328962, 332392, 105105, 252118, 266091, 131506, 235999, 105103, 224226, 224224, 105100, 235994, 23282, 235992, 105098, 224222, 211349, 235980, 211338, 29984, 235973, 331852, 331850, 326885, 181429, 211293, 211291, 331844, 327893, 211288, 327887, 331840, 194108, 331906, 331838, 180329, 326687, 328489, 211285, 326685, 328487, 301721, 329550, 331195, 331148, 181422, 181420, 181412, 331916, 331902, 329547, 327265, 328485, 181409, 195937, 331824, 252112, 331813, 328483, 331728, 331808, 330925, 331806, 328023, 331803, 331146, 195931, 331801, 331800, 331790, 264111, 328479, 331787, 328022, 331144, 328477, 277307, 331029, 211247, 224149, 331022, 224140, 331042, 224138, 331010, 224136, 105065, 224134, 224117, 211241, 235950, 235948, 329441, 195922, 329455, 235942, 224100, 329453, 235937, 252100, 235935, 211212, 329144, 319802, 211198, 328147, 328630, 327971, 328674, 211176, 159274, 224073, 235926, 328145, 328120, 211169, 328266, 328207, 328192, 235902, 211165, 252092, 252089, 328111, 328134, 328126, 328131, 235899, 328006, 305643, 328004, 327881, 224049, 224047, 327879, 308382, 235895, 211163, 224045, 224040, 205108, 327075, 327461, 277303, 327457, 327394, 326764, 305635, 305630, 260942, 131470, 252073, 131465, 327011, 327247, 252069, 310131, 205093, 327093, 318539, 205091, 180313, 235888, 327245, 326878, 195888, 327072, 224025, 326977, 318532, 318530, 307561, 327007, 326760, 326862, 211138, 326752, 326750, 252065, 326540, 325612, 211129, 312002, 312000, 318415, 306903, 277301, 277299, 306900, 223964, 326345, 323685, 301448, 180304, 235872, 180301, 325606, 260922, 235867, 235864, 277297, 306898, 306896, 318247, 180297, 180293, 195876, 306894, 318244, 325586, 325468, 252062, 12602, 325584, 262984, 301445, 320110, 318239, 260912, 252058, 211109, 325279, 306892, 223957, 320106, 318232, 323681, 223953, 105044, 195874, 223946, 325914, 306890, 105040, 235860, 308379, 223937, 308377, 325329, 325437, 223933, 223931, 112987, 223915, 180286, 211102, 180269, 295332, 323673, 180260, 180258, 180251, 180247, 180242, 180240, 320242, 223912, 180229, 235852, 321830, 211085, 180227, 294964, 223910, 223906, 223903, 180224, 211083, 180222, 319481, 319463, 211081, 264061, 211063, 202613, 294958, 211061, 279798, 223888, 211059, 202609, 307558, 299814, 202603, 180213, 235845, 294953, 223883, 180207, 202585, 264057, 264054, 321340, 321417, 321415, 264048, 180202, 180200, 105038, 180198, 264046, 321579, 252044, 252042, 321352, 321350, 321407, 264036, 320240, 105032, 205077, 211019, 211012, 320221, 180179, 223829, 211009, 180176, 189617, 180174, 105004, 223826, 211004, 180172, 104998, 311996, 318409, 104994, 180169, 189614, 235788, 223822, 211001, 104988, 104982, 210999, 180162, 319508, 319378, 319578, 180159, 180157, 319504, 319570, 319340, 235781, 223818, 210988, 319376, 131463, 319193, 235762, 260882, 235760, 223806, 223796, 205070, 223793, 180149, 223790, 235756, 223788, 210954, 223763, 318402, 305882, 223760, 235749, 210952, 223758, 318628, 223755, 210950, 223744, 223742, 308374, 223737, 223735, 180142, 318202, 318142, 318197, 316954, 180138, 235739, 235737, 235735, 223728, 223724, 235729, 210902, 210900, 312699, 210898, 180131, 23271, 314539, 317044, 180129, 205065, 23269, 252012, 316932, 180128, 317470, 316077, 316071, 307542, 141140, 316069, 210883, 180102, 180099, 316838, 180092, 316715, 251992, 316060, 316802, 316055, 180078, 316701, 223717, 235714, 210856, 235700, 180070, 251985, 316279, 180063, 210828, 223681, 210825, 316030, 223677, 315840, 210820, 277294, 316028, 315838, 315971, 210818, 315836, 308372, 223675, 223651, 306885, 315505, 315490, 277285, 104977, 315317, 235679, 315314, 315307, 315303, 315286, 223646, 251959, 251957, 314520, 314517, 251951, 315229, 251949, 104974, 315176, 104971, 210771, 104968, 104964, 315174, 104961, 104958, 314972, 180052, 223643, 210766, 312540, 312687, 235675, 104953, 210764, 314514, 210758, 235666, 313509, 314466, 210756, 180050, 312533, 223628, 251943, 104946, 180023, 314464, 314461, 104938, 314459, 314457, 223623, 104933, 223621, 314454, 223619, 104928, 314451, 314448, 266056, 251938, 210748, 210746, 314503, 314362, 307716, 223604, 251927, 251919, 180014, 313438, 251913, 313435, 223601, 223598, 314070, 131455, 311633, 314089, 235631, 235629, 314160, 235618, 313982, 235616, 235614, 223585, 195822, 223582, 314019, 313919, 311630, 235612, 251906, 223580, 195815, 235602, 235598, 223575, 210729, 104917, 313816, 104914, 307707, 195801, 264029, 257182, 235588, 223571, 306161, 313429, 223567, 180000, 210720, 210706, 210704, 251888, 311715, 251880, 279890, 277275, 312581, 313424, 313672, 210691, 311708, 311703, 313503, 313375, 311626, 210684, 308361, 311624, 305202, 223558, 257173, 308358, 210670, 223554, 179980, 104906, 312565, 104902, 235580, 104898, 251870, 104896, 210661, 313369, 312563, 313366, 104891, 210659, 104886, 312779, 313363, 304673, 179978, 104883, 313458, 210651, 104879, 210649, 223544, 251862, 313358, 313419, 313347, 223541, 235576, 313354, 279888, 104876, 277668, 104874, 308353, 312848, 223537, 308351, 179976, 104868, 294139, 210647, 308349, 312734, 308346, 179967, 223516, 210618, 223511, 210612, 312552, 210604, 195784, 210602, 104856, 308172, 223492, 223487, 223483, 312458, 223481, 312464, 265326, 312453, 309861, 312451, 265324, 195779, 307526, 312416, 312238, 210594, 305587, 104838, 104834, 312229, 205044, 306151, 306149, 205042, 294125, 210584, 251840, 251837, 311843, 311776, 235556, 210558, 223439, 308167, 308165, 301181, 251834, 210543, 311301, 307443, 104830, 310666, 235542, 279043, 310664, 311245, 311091, 210526, 311086, 310631, 310659, 104826, 210524, 310656, 267630, 310626, 235535, 271344, 310654, 251830, 307699, 104822, 104818, 310456, 307492, 310349, 308319, 104813, 223411, 104807, 310099, 307489, 223408, 104805, 251821, 104802, 309851, 195768, 235532, 308301, 223405, 308293, 310120, 264009, 264007, 310087, 307837, 310084, 307646, 306657, 223401, 260850, 306652, 279040, 283287, 307654, 223396, 235528, 307226, 235525, 306644, 307626, 306641, 307222, 306639, 307835, 179941, 307434, 305480, 307623, 195767, 210507, 307642, 307364, 223394, 307377, 251814, 305470, 307255, 305818, 179936, 305446, 307116, 307176, 223373, 307011, 251801, 307004, 251799, 223365, 251797, 251795, 179930, 223360, 223355, 283279, 223353, 195761, 283276, 305814, 235510, 614305, 223350, 223348, 306740, 303790, 306722, 306706, 251790, 306599, 306718, 305812, 306702, 223345, 223342, 306595, 306592, 223337, 251784, 210500, 223331, 179922, 263999, 306102, 306195, 305839, 123454, 305992, 251781, 251779, 305735, 123448, 263996, 179919, 271585, 210493, 305807, 305828, 210486, 210484, 223308, 262854, 305804, 305802, 179915, 299551, 210471, 305730, 279035, 174185, 210463, 305724, 305573, 304159, 305569, 179903, 223273, 223270, 305528, 210453, 305249, 305242, 299531, 251759, 160799, 303586, 191733, 179887, 302979, 305281, 191731, 251755, 251752, 304665, 302643, 266042, 301715, 266040, 195743, 305236, 195741, 305269, 223243, 253266, 302037, 305234, 223241, 223240, 223234, 266038, 305143, 266036, 223232, 195739, 223226, 303696, 210443, 223222, 210438, 235466, 303694, 302604, 304910, 210429, 304517, 104800, 235462, 104798, 210426, 251730, 210415, 251727, 251724, 104793, 210409, 210407, 304114, 304131, 303974, 304531, 302513, 304128, 179881, 235449, 299786, 210402, 263992, 288123, 304126, 251722, 251720, 251718, 304511, 303971, 210399, 304085, 304075, 191725, 303963, 301700, 235443, 299670, 303035, 303664, 303706, 303683, 303651, 303642, 303634, 303563, 303630, 210367, 303561, 251704, 223197, 223190, 179870, 191717, 302962, 210347, 251700, 251699, 302406, 303511, 210342, 303020, 302958, 302901, 303016, 303509, 303504, 179867, 303496, 179864, 303013, 303011, 191715, 288017, 288015, 302627, 302625, 302587, 288012, 302888, 294620, 302580, 210337, 294617, 302571, 302568, 302559, 301953, 210331, 302555, 210329, 301324, 210327, 301685, 301683, 210320, 179857, 301681, 210318, 302517, 251692, 210314, 301991, 160784, 210311, 301051, 104791, 299756, 104789, 104787, 300981, 36026, 36024, 301608, 251664, 266028, 299745, 301596, 301458, 104775, 251652, 301315, 104772, 251645, 301145, 301294, 210268, 235438, 235436, 301256, 300769, 301197, 291216, 300890, 291211, 251635, 251631, 296203, 301065, 296201, 301043, 251629, 301029, 291205, 210243, 301058, 269211, 299729, 291202, 179833, 104763, 300624, 210239, 299329, 267221, 251624, 300606, 251622, 298779, 297801, 299325, 251618, 299515, 300491, 298959, 298957, 223169, 223167, 298412, 299864, 287790, 251615, 251605, 131414, 179820, 298777, 299461, 299322, 299452, 123441, 299871, 299861, 299869, 251602, 294123, 205036, 131412, 287594, 299509, 299652, 299316, 298410, 210226, 299649, 299313, 251581, 251579, 251577, 266019, 210199, 223153, 223150, 195710, 104734, 210190, 251575, 210179, 104729, 298291, 298286, 266017, 297203, 210168, 297201, 287785, 297621, 297614, 210159, 179773, 210157, 297196, 251563, 210155, 210153, 288006, 298076, 179760, 210126, 295952, 287999, 210111, 297189, 293941, 210108, 251559, 296693, 179741, 296263, 297184, 296431, 297075, 179738, 251557, 296048, 251555, 183034, 183032, 295751, 179730, 295872, 195694, 104723, 251553, 294752, 251548, 295730, 295266, 174164, 174162, 223126, 174159, 195690, 174156, 251526, 251517, 295193, 251514, 179725, 295034, 251512, 210025, 251508, 251502, 251501, 294742, 294714, 294702, 287677, 294697, 294680, 294667, 293836, 104719, 104715, 104714, 210020, 104710, 294585, 210017, 294581, 210012, 204995, 179715, 174153, 267868, 174145, 267865, 293902, 294260, 293898, 294258, 179712, 179710, 293895, 294256, 294110, 209996, 294108, 209994, 294103, 179707, 291626, 294085, 293869, 291624, 291322, 293863, 195680, 179699, 291622, 293858, 293854, 131325, 291318, 291315, 104702, 291312, 291584, 204993, 251496, 104689, 195677, 104684, 104681, 104679, 131293, 251488, 209979, 291501, 131291, 179691, 104654, 287828, 291252, 291259, 209968, 179685, 195675, 265940, 287825, 265936, 289959, 104633, 265934, 290379, 291027, 289956, 265930, 269686, 269684, 290990, 291012, 285809, 188646, 290302, 290154, 251475, 287983, 287977, 287973, 104544, 179628, 251464, 179626, 251461, 287795, 287776, 204981, 287774, 287643, 284540, 287588, 104503, 284533, 287520, 287516, 287566, 209847, 16593, 279955, 279952, 179585, 179570, 179550, 209825, 285755, 251457, 285888, 272061, 182999, 277562, 285583, 285040, 126150, 209809, 285743, 262324, 131256, 285411, 262317, 131249, 268623, 285404, 278885, 179525, 262312, 283274, 273802, 179517, 179511, 223091, 284568, 278945, 262310, 179365, 273253, 273251, 265913, 265910, 269197, 273248, 269195, 269193, 179361, 273791, 223080, 273244, 179339, 276441, 273234, 143034, 179331, 277040, 276435, 179329, 276431, 104388, 271133, 270441, 270438, 270828, 268605, 270430, 179175, 179172, 270421, 104320, 270417, 104314, 104305, 179159, 104303, 104295, 179150, 179148, 104293, 223030, 270759, 191694, 270383, 270649, 270756, 266262, 270646, 270412, 209543, 223027, 270381, 266260, 104286, 223025, 191692, 191690, 270643, 178912, 186794, 269144, 178824, 222935, 222933, 178687, 178684, 178681, 178673, 266300, 178667, 178661, 264953, 263883, 265249, 178649, 263881, 265247, 263879, 178641, 266292, 266290, 178586, 267115, 265618, 256300, 178472, 265169, 204972, 178086, 131175, 178082, 204970, 131172, 178080, 204967, 178077, 204965, 195625, 186793, 178061, 257425, 178059, 178057, 178055, 178053, 178049, 178045, 140976, 178042, 257420, 178040, 178036, 257416, 186790, 186785, 257412, 186779, 186777, 178034, 186774, 186771, 178032, 186769, 262039, 186766, 178027, 186764, 257408, 178024, 260417, 178021, 257404, 178019, 178018, 257388, 178007, 265026, 178004, 260415, 264849, 177996, 195623, 209301, 258262, 251379, 260402, 186749, 177981, 209297, 257553, 186743, 177969, 177966, 186737, 104224, 186733, 264982, 264595, 177960, 131159, 177942, 264593, 131158, 104205, 131156, 264678, 177887, 177885, 260400, 131154, 177884, 263739, 131148, 263736, 177872, 131146, 261986, 318864, 261843, 186731, 264590, 177870, 177859, 177857, 260381, 260379, 251366, 104203, 251362, 264491, 263206, 104200, 177848, 264584, 263146, 177735, 186728, 177732, 263143, 261979, 318857, 263536, 177726, 263141, 209277, 177716, 263199, 177648, 260365, 177613, 262009, 222916, 254424, 262041, 177528, 255693, 177524, 177497, 260350, 255688, 260347, 256282, 260344, 177491, 255685, 256274, 186665, 256270, 131083, 256268, 254417, 261668, 182921, 222908, 260341, 251322, 177473, 255680, 186654, 251307, 186638, 256265, 131077, 256263, 104183, 177461, 261408, 182916, 256698, 256260, 131073, 177459, 251304, 260332, 177456, 251302, 177449, 177445, 104180, 260323, 177430, 256257, 177427, 260302, 177424, 260299, 209200, 261404, 222158, 177420, 260297, 222156, 261396, 259641, 186632, 259639, 186628, 260281, 131054, 260279, 261452, 222153, 250703, 260995, 261451, 260277, 104176, 177404, 186623, 261360, 261467, 186621, 222150, 222902, 261461, 209197, 104172, 260270, 261458, 209195, 177346, 104162, 260238, 104160, 104156, 260234, 257382, 177335, 177332, 260231, 104153, 260228, 177320, 260221, 222148, 186606, 260218, 260215, 260209, 261169, 209166, 260205, 260821, 186603, 186601, 186594, 260721, 122594, 255675, 186591, 261162, 186589, 255673, 186587, 260718, 261159, 104139, 261157, 260202, 177307, 122591, 258411, 260984, 260716, 260189, 186582, 195585, 131037, 104137, 260164, 186559, 177278, 186557, 258403, 131001, 260152, 235285, 251280, 260150, 177275, 177273, 251278, 260148, 177271, 186554, 258400, 177269, 260144, 258397, 251276, 177237, 258391, 260115, 260113, 177226, 260104, 177220, 260101, 260096, 260420, 260020, 177192, 260009, 186537, 209131, 177181, 255370, 177178, 122576, 186532, 259930, 177175, 259141, 255365, 249213, 259139, 249210, 258920, 255363, 258918, 186526, 204503, 259582, 128860, 104071, 258906, 259728, 128854, 186515, 259760, 104060, 104057, 259757, 259753, 204500, 259577, 186509, 177132, 259746, 177123, 177121, 259721, 14527, 259571, 186496, 177116, 177113, 186490, 177105, 259569, 251271, 177101, 259035, 195564, 259033, 177090, 186486, 259563, 177087, 222891, 251269, 186480, 251268, 104052, 259496, 195558, 258009, 195556, 259494, 195554, 104048, 259492, 104042, 104040, 259484, 259022, 259482, 104037, 259480, 258968, 259478, 104034, 259020, 259475, 257105, 259129, 257103, 186465, 257101, 258388, 186463, 195552, 259473, 259469, 258385, 259467, 177034, 259450, 259464, 186460, 104032, 177031, 259083, 186458, 259259, 177029, 104030, 259447, 104026, 259127, 104024, 104022, 104020, 257096, 259370, 259386, 259361, 259073, 259368, 259359, 177024, 259071, 177021, 258002, 259069, 253373, 259067, 256488, 258000, 256486, 259065, 186445, 259017, 259014, 195538, 259012, 186442, 222890, 177017, 259356, 259354, 177015, 259010, 259352, 186438, 195536, 130998, 259120, 176999, 176995, 258898, 176992, 209113, 257092, 176990, 209111, 258938, 257496, 258935, 258960, 258895, 258847, 176969, 176967, 258930, 258999, 258957, 253370, 176965, 209105, 186422, 176956, 256475, 253367, 258891, 176954, 258889, 209100, 258953, 258887, 176952, 254898, 176949, 253365, 186419, 258922, 253363, 255668, 186417, 253361, 176947, 248671, 253356, 253355, 253354, 253353, 253352, 253351, 253350, 253349, 253348, 253347, 248669, 128846, 176945, 257380, 222884, 258885, 258881, 258879, 258877, 257378, 209098, 258873, 204959, 258871, 222876, 255664, 257089, 255662, 256473, 258591, 257376, 176941, 209096, 257363, 258584, 257679, 258582, 248667, 258579, 257086, 186413, 176937, 258577, 248662, 257083, 203640, 257081, 195534, 256450, 257357, 258571, 195531, 258569, 257991, 257079, 258564, 257350, 257076, 256444, 256018, 258610, 195527, 258608, 258486, 195524, 256147, 258315, 256144, 256141, 195522, 257344, 258560, 258197, 258603, 258434, 257072, 258553, 258551, 209088, 258549, 257070, 256133, 255658, 195513, 176931, 257066, 257064, 256129, 256127, 255650, 256125, 257061, 257058, 204644, 257340, 176928, 195507, 222861, 204642, 204634, 255646, 258421, 195496, 176923, 258195, 257051, 258381, 130988, 258308, 249207, 130986, 209080, 176921, 209076, 209074, 130981, 176912, 209059, 258362, 257337, 249205, 249202, 140940, 257324, 204630, 257319, 130966, 258177, 140937, 130963, 257845, 255636, 257460, 204628, 257842, 203952, 195491, 176882, 203950, 204625, 186408, 257674, 248658, 209029, 203948, 176879, 248656, 176874, 258174, 249200, 203944, 257316, 176871, 248654, 248651, 176868, 255632, 248642, 257967, 251249, 176860, 176856, 257825, 176852, 186405, 257822, 176847, 257899, 176844, 257971, 184618, 257804, 176837, 176833, 257897, 176831, 143240, 257891, 248639, 257889, 257802, 128838, 257887, 128836, 257962, 258028, 176824, 257043, 257458, 255624, 184616, 257313, 209027, 257820, 176820, 257814, 257309, 176812, 251242, 222843, 176810, 222840, 257306, 222837, 257302, 222834, 257668, 195464, 257296, 257665, 257038, 195462, 209024, 222832, 257293, 195460, 257291, 222828, 257286, 257036, 255620, 195445, 176804, 257648, 257645, 222813, 249379, 176799, 176797, 222810, 257557, 222808, 255608, 184602, 222806, 257277, 184600, 249377, 254280, 186403, 257030, 255599, 222804, 204950, 204948, 249801, 186396, 257273, 204946, 257022, 255594, 257019, 257271, 204944, 257017, 255592, 204942, 257269, 257513, 257547, 255590, 257015, 122559, 257584, 176795, 257568, 122556, 257566, 257266, 176791, 257564, 204940, 257263, 204938, 257260, 176789, 257510, 257011, 209017, 256867, 256864, 204935, 204933, 176781, 256434, 257502, 257255, 255588, 257455, 176779, 257253, 209009, 255586, 257007, 257450, 257447, 256580, 257487, 222795, 209006, 257250, 204931, 251227, 256995, 256993, 257242, 256343, 254942, 186394, 256913, 256861, 256989, 256911, 256612, 256985, 186392, 256907, 186382, 256975, 251224, 186380, 256973, 256971, 186378, 186374, 254947, 254269, 256892, 256852, 256890, 186369, 255241, 186367, 255239, 186362, 186360, 255237, 186354, 251220, 186351, 186349, 255235, 186343, 256848, 251217, 186341, 186334, 256680, 256678, 251204, 256605, 256603, 251202, 195436, 256600, 256636, 256634, 251199, 256595, 222213, 176766, 204927, 251194, 176764, 208984, 204925, 222209, 251192, 186325, 186323, 254261, 186321, 186319, 254259, 256517, 256577, 254257, 130954, 186315, 255170, 254251, 256515, 130950, 255167, 186313, 255165, 186311, 255163, 186308, 255161, 186305, 256511, 186303, 256339, 208977, 186299, 208975, 203114, 186297, 256337, 256428, 256519, 256335, 130946, 256080, 255156, 256412, 204922, 176761, 256410, 256508, 176759, 256506, 256078, 208970, 176755, 256063, 247794, 176753, 255151, 176751, 256237, 256235, 176747, 256229, 256050, 204919, 176743, 256048, 208964, 256107, 176736, 256104, 256102, 256099, 130935, 256097, 176734, 130931, 176732, 256034, 222790, 256031, 130927, 256028, 256026, 204916, 255583, 204914, 130923, 176730, 256007, 255035, 255580, 176726, 176721, 176719, 255911, 176717, 255909, 255856, 130920, 140925, 204912, 256023, 130918, 140923, 255577, 140917, 255575, 255854, 254938, 140914, 255852, 255902, 255932, 255032, 255995, 140912, 222784, 208960, 255139, 255573, 186295, 186292, 130912, 255830, 255348, 255558, 130898, 255093, 255556, 130896, 130894, 255553, 130890, 255550, 130887, 255342, 255136, 130885, 130883, 222754, 255548, 255771, 255530, 255273, 130873, 255127, 255525, 255334, 204908, 104017, 130871, 249366, 255224, 130858, 255061, 130856, 130841, 255116, 130839, 176715, 255220, 255082, 255114, 249142, 255218, 104015, 176713, 204905, 104013, 176711, 255058, 255022, 255056, 255054, 104010, 130832, 176709, 208955, 255252, 255213, 208952, 104008, 176706, 254932, 254233, 186288, 254930, 254970, 251176, 251174, 249138, 254927, 249134, 254919, 254913, 254904, 254902, 249132, 253903, 249130, 253900, 251165, 249128, 251163, 249121, 176683, 176681, 251161, 254474, 253890, 253888, 251158, 254821, 249119, 195414, 176678, 254819, 186285, 186283, 253880, 254761, 103994, 254229, 235282, 208945, 103991, 186279, 254225, 254555, 249871, 235280, 176676, 103971, 249868, 253874, 254567, 254216, 247542, 253861, 254541, 191525, 253859, 254214, 254538, 191523, 247540, 251149, 191520, 254212, 247535, 254405, 253857, 208938, 254533, 249604, 254403, 235277, 250700, 247533, 250698, 208936, 247531, 250696, 254462, 254396, 186272, 235273, 254458, 235267, 254393, 254391, 186270, 235265, 251143, 176661, 186265, 176659, 251141, 251137, 186253, 254454, 251135, 254389, 253474, 222405, 254201, 203259, 254387, 253472, 254198, 222750, 222748, 186250, 186248, 186246, 253050, 186244, 254178, 186242, 253324, 222742, 176654, 186240, 195113, 250694, 254175, 208921, 186236, 254173, 208918, 222740, 254170, 222737, 254161, 208916, 206650, 248056, 254166, 248637, 176651, 253456, 206647, 253443, 186229, 253484, 248626, 253469, 248621, 248619, 253432, 253465, 130822, 253481, 250867, 186225, 253463, 176638, 253083, 253389, 253428, 253080, 253425, 253460, 253423, 249859, 253421, 251124, 176635, 251122, 253310, 253419, 103961, 248616, 253417, 248614, 252929, 253308, 248612, 253414, 176631, 253382, 248610, 176629, 253346, 195111, 249857, 248608, 253306, 253191, 253078, 253304, 130819, 253302, 253344, 253166, 253341, 208913, 208911, 253164, 253297, 208909, 248044, 251121, 248040, 253162, 176625, 176623, 251118, 208902, 253204, 252919, 176610, 253201, 176608, 186220, 208891, 253160, 176606, 208889, 253156, 186217, 176603, 208873, 253060, 251095, 251091, 252916, 252914, 253019, 253017, 253013, 253052, 176592, 253009, 253007, 184992, 253002, 250478, 250940, 192112, 186213, 249771, 250476, 186210, 248016, 186208, 130815, 176591, 186206, 250855, 249843, 248011, 186203, 195408, 249841, 251090, 249839, 250847, 250028, 176578, 186199, 176576, 208862, 250471, 250838, 248606, 251082, 208858, 250780, 208853, 250466, 206638, 208851, 176564, 250760, 250922, 176560, 208849, 250691, 176549, 250686, 194489, 250682, 194486, 250753, 248268, 250765, 208842, 248266, 208840, 186194, 248264, 201341, 194481, 192110, 250630, 206635, 248261, 103957, 103955, 250676, 250620, 194473, 206633, 248253, 103952, 248595, 176543, 208838, 250667, 250492, 248586, 208833, 128832, 103941, 184990, 103939, 194469, 103935, 176527, 184986, 248236, 249590, 176524, 176521, 184983, 249554, 249581, 249360, 176517, 103929, 130809, 222735, 208826, 248226, 250389, 208822, 186173, 248217, 103923, 248213, 249544, 249356, 250024, 103921, 249766, 208252, 249639, 193164, 193162, 103919, 249816, 208793, 249812, 191443, 184971, 103916, 249664, 186171, 208790, 103912, 249810, 249662, 130800, 249760, 103910, 249573, 208786, 249660, 249752, 176503, 191436, 128824, 249750, 103907, 176501, 103905, 103903, 176499, 103901, 249745, 130798, 208781, 176497, 249635, 248877, 249534, 249568, 249339, 249741, 176495, 248875, 176493, 206299, 249529, 248871, 249524, 248868, 249443, 249117, 249440, 248863, 249431, 248495, 249114, 175386, 249331, 248857, 249427, 248855, 248493, 248853, 248491, 249328, 249326, 249323, 249319, 249314, 248488, 194106, 249312, 176489, 176484, 248477, 176482, 248473, 248851, 191435, 176479, 176470, 249258, 130790, 176467, 176465, 130783, 248849, 248194, 130781, 248847, 248846, 248845, 248182, 248174, 130776, 207589, 248725, 130774, 130772, 248078, 208776, 248843, 208774, 248840, 192229, 206630, 248838, 247792, 248836, 247790, 248834, 248168, 192226, 208766, 208763, 248980, 249109, 249171, 193044, 249166, 208753, 249164, 249163, 208751, 193037, 248822, 249106, 248820, 206621, 248818, 103899, 130762, 208748, 248977, 615236, 248813, 248811, 249069, 208745, 248975, 248758, 248972, 248158, 248156, 247636, 202209, 207306, 248122, 248147, 248968, 248465, 248755, 248145, 248143, 176455, 176452, 176449, 248808, 248806, 128817, 176447, 248804, 176444, 128814, 176442, 176436, 176433, 248799, 176431, 248795, 208735, 176428, 248463, 176421, 176420, 176413, 248455, 248718, 176411, 208729, 176407, 176405, 248412, 206609, 248521, 206604, 206602, 206600, 208721, 248564, 248516, 248561, 248133, 208717, 247999, 247994, 248128, 247992, 248402, 248400, 247989, 207357, 247671, 103890, 247987, 247802, 247983, 103888, 247453, 247799, 247976, 207388, 247775, 247773, 103881, 247518, 193034, 247756, 247754, 247753, 193029, 247740, 247738, 193027, 207386, 207384, 247604, 203105, 207382, 130752, 247664, 247601, 247708, 247599, 247662, 247660, 247698, 247650, 247596, 247594, 247648, 247592, 247644, 208500, 203179, 247642, 203173, 222143, 247590, 130743, 130741, 247588, 247587, 130739, 208690, 247585, 222142, 222140, 222138, 130737, 103874, 208439, 103861, 208436, 222376, 130734, 103855, 130727, 235263, 208682, 222374, 235259, 208679, 190839, 208677, 235256, 207842, 207829, 207828, 207825, 207824, 207819, 207817, 207814, 204449, 208237, 204447, 207810, 103823, 208234, 204444, 208369, 208230, 208229, 208226, 208222, 615231, 207796, 208216, 207780, 207761, 204441, 207758, 204438, 207743, 615213, 207738, 207737, 103798, 207729, 103791, 207695, 207693, 103787, 207691, 207690, 207689, 207688, 207684, 207855, 207682, 207681, 207853, 207672, 207669, 207848, 207667, 207664, 207658, 175385, 203722, 206790, 207186, 175383, 615198, 204423, 188057, 204894, 185737, 202173, 185734, 203718, 185731, 204883, 188054, 206807, 206787, 204879, 206785, 204414, 185721, 204409, 191426, 202530, 204471, 204402, 615187, 202517, 202662, 202158, 189407, 202658, 170893, 202094, 202197, 202656, 202156, 189405, 156641, 201669, 194737, 156639, 202152, 615162, 189401, 201667, 201664, 201570, 615160, 189399, 194788, 201568, 201658, 191422, 190022, 615158, 202502, 202498, 615154, 615153, 190020, 190018, 189397, 190009, 201558, 201426, 201656, 201553, 201654, 201550, 201652, 194097, 201421, 201419, 201418, 201414, 201410, 193152, 191639, 192861, 189829, 193150, 193135, 182748, 192854, 172344, 192255, 192502, 193119, 182744, 192690, 192852, 192497, 193117, 173454, 193114, 190835, 193112, 103773, 192849, 182742, 103770, 175372, 192687, 192676, 192847, 172342, 182735, 175368, 192494, 192844, 192253, 192674, 191636, 192765, 192763, 192440, 192666, 192368, 191408, 189392, 190887, 103759, 192366, 103757, 103756, 189389, 190884, 191917, 191916, 190881, 191403, 192218, 192217, 192213, 189581, 185882, 189385, 189579, 189822, 189381, 185125, 189994, 189820, 189819, 185877, 185876, 182473, 187569, 185874, 185873, 187565, 182471, 185871, 145256, 182466, 182458, 188594, 188592, 188580, 188570, 189365, 189354, 186884, 187542, 185925, 186882, 185866, 174569, 185864, 184317, 184314, 181474, 169891, 174524, 182712, 170997, 182709, 181465, 182706, 182704, 181461, 170982, 181458, 181389, 181452, 181378, 181448, 150488, 173453, 173446, 173441, 173439, 173436, 173428, 173424, 173417, 173415, 173414, 160625, 160621, 170792, 170760, 170754, 32759, 158778, 158777, 32754, 166043, 166039, 166037, 166033, 158954, 166268, 163216, 163214, 150482, 158101, 160962, 161546, 158098, 158097, 150480, 153101, 163208, 16522, 160956, 160954, 158241, 135479, 135470, 150298, 130390, 135793))
Run Time: 0.085339
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4504 | |
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 | | | | | 4504 | |
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 (28465, 19002, 18057, 16813, 15808, 15630, 15567, 15513, 15392, 15302, 14407, 14330, 13822, 13576, 13374, 13326, 13301, 13282, 13281, 13194, 13133, 13098, 13063, 13058, 13003, 12937, 12928, 12886, 12865, 12846, 12818, 12790, 12788, 12778, 12776, 12615, 12393, 12327, 12151, 12109, 11832, 11758, 11697, 11645, 11496, 11335, 10838, 10248))
Run Time: 0.002393
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 48 | 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, �n�
Run Time: 0.000227
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000374
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.000557
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: 1716143720
Run Time: 0.000400
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 19 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
- XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Repository/SessionActivity.php at line 62
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*, `xf_user_User_1`.*
FROM `xf_session_activity`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1716143720)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000708
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 19 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | my_webapp.xf_session_activity.user_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivity.php at line 43
- XF\Repository\SessionActivity->getOnlineUsersList() in src/XF/Repository/SessionActivity.php at line 63
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7722
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1968
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s18/public/PAGE_CONTAINER.php at line 1333
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1654
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20