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.000699
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.000431
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` = '2061')
LIMIT 1
Run Time: 0.000739
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.002630
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_2061' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.055573
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 (147316, 147842, 136752, 136750, 147592, 147658, 96104, 146537, 142714, 147608, 147604, 147586, 142707, 119868, 147570, 147123, 147025, 147002, 147574, 147568, 142702, 147484, 136748, 119867, 119865, 136746, 119863, 119860, 136738, 147424, 119858, 136736, 136733, 136731, 147354, 147352, 119855, 136730, 147297, 136727, 136725, 144311, 145648, 144309, 147340, 144307, 145344, 136723, 142573, 142584, 144305, 147121, 147203, 147261, 146077, 145971, 145968, 145967, 145835, 145831, 145827, 145825, 145818, 145817, 145810, 146592, 146590, 146585, 136715, 146576, 136707, 146567, 146565, 136704, 119833, 136702, 145793, 136699, 136697, 96101, 136695, 146485, 145768, 145698, 119831, 145717, 145696, 145714, 145693, 136692, 143126, 136690, 143125, 145688, 119826, 145559, 146214, 145103, 137429, 141958, 146212, 145686, 136688, 141956, 145641, 119824, 136686, 144281, 136684, 96099, 145633, 145544, 145666, 145539, 144275, 119817, 119815, 145092, 119813, 145531, 145089, 145529, 119811, 145525, 119809, 145087, 145622, 145620, 119805, 145651, 145315, 145477, 143852, 136680, 143850, 136678, 143848, 137419, 119802, 137417, 119800, 145311, 144119, 144117, 141756, 119788, 145306, 145055, 136675, 119786, 136671, 119777, 119771, 119768, 145031, 145070, 136667, 145066, 136663, 145061, 136661, 136658, 136656, 136654, 144894, 144990, 144891, 144889, 144988, 142277, 119765, 144983, 144882, 144226, 144225, 144878, 144876, 136652, 136650, 144221, 144870, 142275, 144598, 144595, 144630, 119763, 144627, 144623, 144695, 142273, 144676, 144674, 119761, 144671, 144669, 136645, 144666, 144664, 136643, 119755, 141752, 144371, 144200, 136641, 144316, 144198, 136639, 136637, 136635, 144182, 136631, 119747, 136628, 144178, 136623, 119745, 136621, 136612, 119738, 142272, 142316, 139095, 142136, 142266, 142264, 139065, 142262, 139063, 142134, 142259, 142132, 142130, 141927, 139039, 136587, 139037, 136585, 139035, 141646, 139033, 119727, 100350, 139031, 119725, 139029, 142110, 136583, 136580, 136577, 136575, 139022, 139020, 142095, 119722, 141396, 96098, 136573, 119713, 136569, 119711, 136566, 141386, 136539, 140547, 136537, 141817, 138963, 119705, 136536, 138960, 141799, 96094, 96091, 96088, 96086, 119699, 136534, 141613, 96082, 96081, 96079, 96076, 141622, 138940, 141619, 119696, 138914, 138910, 119685, 138908, 138859, 140451, 140731, 140448, 136377, 136375, 140728, 140556, 140726, 119675, 136528, 119673, 136526, 140526, 119664, 140104, 138482, 140202, 115339, 140100, 137964, 136524, 115337, 136518, 119647, 136514, 136512, 136510, 119645, 119642, 136508, 137961, 119637, 136503, 138824, 127657, 119625, 138813, 129771, 136500, 139648, 127655, 138774, 138153, 139556, 138731, 119620, 119617, 138475, 119615, 122218, 138715, 138517, 119613, 136468, 119603, 136461, 136206, 136459, 18207, 136454, 137073, 119592, 129852, 136418, 119589, 136191, 18176, 129766, 129764, 119584, 137453, 136183, 18174, 126913, 133813, 138286, 138104, 136104, 126909, 137559, 137015, 136181, 138275, 88146, 138143, 138135, 137324, 137831, 138093, 136178, 138068, 120852, 137952, 120850, 124377, 120847, 120844, 135587, 120842, 137513, 137950, 120840, 137375, 124371, 138000, 137353, 137566, 137350, 129762, 137348, 119581, 136174, 119579, 135584, 122681, 137564, 136096, 137006, 137004, 136082, 137002, 136078, 136075, 136070, 136414, 136066, 136062, 120836, 137610, 136412, 136410, 136408, 134315, 137561, 95828, 120832, 136050, 136121, 136119, 136117, 137520, 137321, 136044, 95825, 134751, 136029, 136027, 137164, 130176, 137318, 136167, 137296, 136404, 129845, 127626, 137167, 137106, 119573, 136997, 130038, 135977, 136370, 135972, 136389, 119565, 135967, 135965, 119560, 135518, 82586, 136246, 136163, 135943, 135904, 135939, 135934, 133383, 130033, 119556, 117280, 135325, 135156, 135065, 129546, 135154, 135152, 135265, 129543, 133675, 135091, 135059, 134581, 129530, 135147, 133673, 135053, 135009, 135020, 128751, 115330, 134986, 127202, 135004, 119554, 127200, 134867, 133668, 134957, 129515, 129512, 129510, 134741, 129508, 119552, 134653, 129501, 134664, 96074, 134651, 134660, 119549, 134395, 129631, 134292, 130269, 129629, 127621, 134290, 127619, 123948, 134286, 134247, 134244, 134151, 134241, 134392, 129986, 133759, 124368, 133372, 130321, 130188, 128077, 123647, 129422, 129954, 129830, 119535, 128739, 119532, 119530, 128574, 129606, 129381, 119528, 119524, 119519, 129373, 119517, 115733, 129343, 128064, 129747, 129601, 119514, 129706, 119510, 129685, 129693, 119507, 119505, 129332, 119503, 129330, 129592, 119500, 128730, 129327, 119498, 119496, 119494, 119491, 129170, 119488, 128725, 129256, 128723, 127398, 128721, 128719, 128420, 128711, 119486, 119484, 119482, 8011, 121554, 128682, 125679, 119480, 119478, 119476, 128542, 119474, 128551, 121551, 127982, 119470, 128531, 119466, 128414, 116302, 127933, 122660, 128409, 119462, 128352, 127917, 119457, 100848, 120396, 119455, 120394, 127979, 127977, 127786, 127886, 119433, 127424, 127446, 126628, 127271, 127269, 127413, 127267, 127406, 127262, 127265, 127371, 120389, 124365, 124363, 126599, 126597, 127134, 127131, 124361, 124764, 115327, 113148, 113146, 119430, 126606, 119428, 119426, 125985, 119424, 126322, 119418, 124834, 123379, 126248, 125190, 125186, 125665, 126088, 124813, 125323, 119416, 119411, 119398, 119393, 119378, 119374, 119372, 119367, 124541, 125258, 125264, 119363, 119358, 119356, 124359, 119352, 119349, 124796, 124722, 124794, 124716, 120386, 120383, 119344, 120381, 124525, 122939, 124518, 124444, 112938, 122937, 117229, 119340, 119339, 112936, 36767, 122935, 120378, 120376, 120369, 119332, 120247, 121564, 123928, 119323, 119320, 124115, 119318, 123925, 119315, 119311, 120367, 119309, 122775, 124106, 123907, 123839, 116658, 119301, 123899, 119296, 100321, 82341, 123894, 119288, 123827, 123600, 123598, 123821, 123817, 116655, 122143, 119286, 105, 119284, 103, 119282, 123587, 119277, 119275, 123582, 123782, 119273, 123578, 123789, 123787, 123575, 123571, 123496, 119271, 123529, 120928, 119268, 123567, 123546, 123088, 119266, 123289, 123535, 123565, 119264, 36760, 119258, 119255, 119252, 119244, 119242, 119240, 119235, 119232, 119223, 123067, 123204, 123182, 123107, 115272, 123103, 115270, 123110, 123101, 123099, 123047, 123114, 119216, 123077, 123097, 123043, 123075, 119211, 122214, 122948, 123036, 119208, 119205, 119203, 122958, 115716, 119198, 119196, 119192, 119190, 119188, 122757, 112774, 122195, 116865, 115544, 122190, 122712, 116858, 119184, 119182, 122650, 119179, 119176, 119172, 119166, 119164, 119162, 119160, 122225, 121636, 115994, 119153, 115542, 119150, 121380, 121489, 119148, 121364, 121563, 119142, 119140, 121356, 121358, 115597, 121354, 120365, 117865, 119138, 117863, 120363, 119135, 121212, 117860, 119133, 119129, 117739, 115215, 121209, 120164, 119127, 92398, 121229, 92393, 119125, 120162, 121227, 119121, 120359, 121199, 121136, 92391, 119119, 120160, 119117, 92389, 120357, 120355, 117857, 120351, 92387, 121131, 120348, 119114, 119112, 120346, 119110, 120344, 121018, 92385, 120341, 120339, 92383, 120337, 120939, 120936, 116963, 120893, 120334, 119105, 119101, 120890, 92381, 120328, 120931, 120158, 120325, 119099, 119097, 120323, 119095, 119093, 119091, 120320, 120318, 119089, 120316, 119086, 120888, 120140, 120137, 120312, 92378, 120309, 116961, 120857, 115540, 120305, 120802, 120301, 118146, 120299, 118144, 120297, 118142, 120294, 120291, 118855, 120288, 115187, 115185, 120286, 119080, 115183, 120284, 119078, 115180, 115173, 115170, 115167, 120156, 119076, 115536, 92376, 116708, 120154, 119073, 120152, 119070, 120128, 119068, 115534, 115532, 119064, 120108, 114589, 119062, 115530, 120097, 81332, 119005, 115528, 118818, 92374, 115146, 115526, 118815, 115523, 118845, 119002, 116706, 117844, 118899, 118897, 118838, 92372, 92370, 113962, 116704, 118788, 92368, 115139, 92365, 92363, 92361, 118813, 115127, 115125, 116578, 115122, 92356, 92355, 92353, 118795, 92351, 92347, 111526, 118783, 116700, 118473, 118444, 111223, 118469, 118542, 115520, 118135, 114327, 118467, 118133, 118077, 92345, 118441, 118129, 118127, 117195, 116957, 92343, 92341, 116952, 116605, 116948, 116603, 113328, 116946, 118204, 116935, 115008, 115003, 81329, 115514, 92339, 118242, 118176, 116598, 116595, 116498, 118073, 111019, 116496, 118071, 111221, 118069, 111219, 113218, 117767, 116698, 117765, 116490, 118021, 118019, 113769, 118017, 113766, 118014, 117763, 97363, 118011, 96719, 117831, 114992, 118009, 116696, 92337, 118005, 116694, 96714, 113359, 116756, 117825, 116926, 117823, 116924, 117760, 117062, 92335, 113757, 117050, 116916, 117073, 114564, 116733, 116833, 116692, 116671, 113742, 116912, 113953, 116760, 116765, 116627, 113711, 116187, 115694, 116508, 116506, 116416, 116291, 115325, 116289, 116423, 92328, 116198, 113689, 92326, 114881, 115891, 115889, 115958, 115501, 92320, 115886, 92319, 114861, 114635, 115773, 115851, 102762, 115474, 92316, 114841, 114838, 115429, 115457, 113569, 115452, 115311, 114820, 113562, 113560, 91513, 114815, 92314, 115322, 115298, 114800, 114798, 115277, 113555, 114500, 36753, 114453, 114115, 92312, 112084, 114439, 114337, 112081, 114230, 113643, 114092, 92307, 92304, 91507, 113637, 102911, 114083, 112746, 113887, 113632, 92302, 98201, 92297, 92295, 92293, 92291, 113627, 91505, 112076, 113433, 113475, 113421, 113419, 113394, 113366, 113339, 98196, 112073, 101906, 113297, 92270, 112920, 102201, 112916, 101863, 101861, 112070, 112068, 101855, 92268, 112622, 113042, 92265, 112901, 101847, 112899, 92262, 112721, 101843, 111214, 112708, 112065, 112536, 112838, 112533, 112530, 112061, 98194, 112528, 112059, 112833, 112208, 112290, 92254, 112288, 112282, 112687, 92249, 112280, 111187, 112682, 111183, 112692, 92246, 67823, 112052, 67819, 111170, 112605, 92244, 111165, 67817, 67814, 92242, 92239, 112276, 112274, 112583, 112523, 112521, 112271, 112519, 112517, 112514, 112479, 92236, 112046, 92234, 112543, 92232, 112267, 112509, 112473, 112506, 112471, 112469, 110837, 92230, 92228, 112440, 112206, 92225, 92219, 101833, 92215, 111083, 101831, 112349, 112197, 112017, 112263, 92213, 112195, 112096, 92210, 112254, 112204, 112252, 110928, 112010, 101305, 111667, 111013, 111908, 111901, 110960, 111639, 92197, 111055, 103318, 103317, 103315, 103313, 103312, 103311, 110814, 92192, 91499, 103304, 102380, 102907, 102905, 102865, 101768, 102351, 102347, 102345, 102773, 102729, 101989, 92188, 102339, 101986, 101984, 102192, 98615, 101398, 102329, 101766, 102505, 102490, 102364, 102082, 102488, 92186, 92184, 102378, 102325, 102077, 91621, 92182, 102257, 92180, 92178, 92176, 101133, 101130, 101602, 92175, 101978, 101975, 101972, 101970, 100388, 102163, 101968, 102089, 102161, 102152, 91497, 101598, 102150, 102147, 102004, 92171, 92169, 101993, 91494, 102034, 101818, 92166, 91490, 91488, 101966, 101964, 91486, 101962, 101960, 95725, 92165, 101957, 101760, 101727, 101806, 101942, 102011, 101955, 91483, 101676, 101108, 101488, 101104, 101102, 92163, 101099, 101486, 101481, 91481, 91479, 91476, 92161, 91474, 92160, 92157, 92154, 92152, 92149, 100957, 97601, 93115, 95234, 86048, 86046, 91472, 100953, 91470, 86044, 100951, 91468, 91466, 91464, 100891, 91462, 98711, 100782, 99885, 101268, 100882, 101266, 101264, 92147, 92145, 91456, 101262, 92143, 91454, 91452, 101251, 100835, 101233, 91450, 92141, 100833, 100950, 100948, 100946, 101225, 100944, 100939, 100933, 100931, 88750, 92140, 100973, 99574, 100304, 100804, 100861, 100800, 100078, 91449, 100797, 100775, 100697, 100773, 100794, 91445, 93111, 79858, 93107, 93105, 93103, 93101, 79851, 100514, 100512, 100510, 91437, 91431, 100567, 91428, 91425, 93095, 91423, 99831, 91420, 91417, 100288, 100552, 91411, 91408, 73723, 91406, 73721, 100483, 91404, 67792, 100336, 100235, 100265, 73719, 91401, 99964, 79845, 79843, 100216, 99950, 99947, 79841, 100209, 96031, 92138, 99810, 91394, 92136, 92134, 100064, 99903, 99936, 92132, 91392, 99926, 96941, 91380, 92130, 99662, 99648, 99908, 92128, 91376, 99837, 99782, 99780, 98576, 91374, 99777, 99774, 99771, 99768, 97897, 91372, 97891, 99765, 91370, 99762, 98325, 91368, 98323, 92125, 98321, 91366, 92123, 92118, 92116, 91364, 91362, 97883, 91360, 91358, 91355, 91353, 99634, 99631, 97972, 99629, 99612, 99627, 86368, 91350, 99609, 91348, 97970, 91346, 97968, 98574, 91344, 98564, 98960, 98176, 98562, 97717, 98559, 98557, 99555, 98698, 97955, 99578, 98553, 97953, 91339, 91327, 91325, 98696, 91322, 91316, 91313, 99387, 99505, 99383, 99497, 99105, 99493, 24154, 99378, 91310, 99101, 98168, 99098, 99372, 99237, 97596, 99235, 99231, 99225, 99220, 99214, 79833, 99211, 92110, 97594, 92109, 99207, 99202, 92108, 99200, 99197, 99192, 99188, 99182, 99177, 99173, 99168, 99166, 99090, 97592, 99146, 92106, 96024, 97951, 99078, 98545, 98930, 98882, 98928, 99002, 98543, 98709, 96014, 98501, 72098, 98160, 98158, 98499, 98300, 79826, 98879, 96012, 96011, 98603, 98515, 98636, 98513, 98489, 90828, 90826, 90817, 98296, 97283, 92097, 98294, 92095, 97631, 97800, 97628, 98415, 98147, 92079, 92073, 90802, 95989, 95985, 90800, 95983, 90797, 90795, 95981, 92068, 90790, 90784, 97872, 95976, 90781, 97869, 94330, 90766, 97703, 90764, 98045, 90762, 90759, 95969, 90749, 90746, 98140, 90744, 95963, 96682, 90722, 90719, 95957, 90710, 95951, 90708, 95949, 95946, 98060, 90700, 95943, 95940, 90694, 98035, 98054, 95938, 90689, 95937, 90670, 90663, 97941, 97695, 97907, 97862, 97859, 97625, 96246, 97401, 92062, 90650, 91295, 83999, 97070, 93260, 97317, 97313, 97265, 97068, 91293, 97066, 97064, 97028, 83990, 97026, 95512, 97024, 93875, 97022, 83986, 90625, 91278, 90622, 97109, 95915, 97021, 96488, 97009, 96548, 96483, 96480, 84176, 96546, 97003, 96354, 96478, 96289, 96892, 95846, 96999, 96287, 96352, 88962, 96285, 96281, 95330, 94133, 96995, 96993, 93674, 96977, 96889, 96462, 91275, 92058, 96524, 96459, 90599, 88951, 96269, 96457, 96266, 96346, 96641, 96344, 96638, 96332, 96327, 96514, 95486, 96449, 96447, 96437, 96325, 96434, 91273, 96494, 90566, 96432, 96425, 96322, 96423, 96422, 96418, 95479, 96319, 96317, 96315, 95477, 92056, 96312, 92050, 95659, 92047, 92045, 96261, 92041, 95901, 96237, 95537, 90562, 95567, 90560, 96194, 91271, 92039, 90558, 90556, 96192, 86874, 96190, 90552, 87030, 90547, 90523, 95711, 90521, 90517, 95873, 95708, 90515, 95893, 95703, 90510, 95315, 95870, 90506, 90503, 92038, 90501, 90498, 93869, 92035, 90491, 90487, 91270, 92032, 90485, 95732, 91268, 92030, 90483, 95727, 90481, 95583, 95466, 90443, 90436, 90434, 90432, 92026, 90430, 95532, 91265, 94729, 95559, 95557, 95529, 90428, 90426, 91261, 91256, 94559, 94557, 90422, 94554, 95152, 90419, 94552, 92024, 90417, 92022, 94548, 94544, 90411, 90405, 91244, 91242, 91239, 90402, 91233, 91231, 90396, 91228, 90392, 94374, 90390, 91226, 91224, 92021, 90388, 95297, 90386, 92019, 91222, 94975, 94860, 91220, 91217, 91215, 95550, 95527, 95548, 95464, 95545, 81322, 95221, 95524, 81320, 95462, 81317, 85690, 81315, 94973, 81313, 81310, 94971, 95000, 91213, 94770, 94969, 94967, 95459, 95456, 95216, 95446, 95442, 94329, 95439, 95078, 93922, 94964, 91211, 94541, 94962, 94960, 94537, 94535, 94533, 91209, 95431, 93918, 95428, 95212, 91207, 95426, 94529, 91205, 94526, 91203, 91202, 91200, 95209, 94521, 94517, 94515, 94513, 94510, 94620, 94508, 91196, 94953, 91194, 90384, 92017, 92015, 90378, 92013, 91187, 92011, 91184, 91181, 94498, 94496, 94494, 91178, 92010, 92008, 92006, 92004, 92001, 94491, 95040, 95071, 94489, 95069, 95068, 95066, 91999, 95063, 91997, 95051, 94326, 93863, 91995, 91993, 94324, 94486, 93861, 94483, 95036, 91991, 94480, 93858, 93855, 94322, 93853, 94317, 93850, 94614, 94611, 36744, 94609, 94313, 94478, 91176, 90372, 94607, 94994, 91174, 90370, 94121, 94119, 90366, 94605, 86870, 36742, 93846, 94602, 94600, 94107, 93829, 94928, 90361, 94921, 94906, 94475, 36739, 94473, 94587, 94904, 94470, 94469, 93910, 90348, 90346, 89314, 90343, 94462, 90341, 93816, 91172, 90339, 91170, 94457, 90337, 91168, 94455, 90335, 91990, 90329, 91166, 90327, 94585, 91164, 94583, 90321, 36737, 36736, 94443, 94679, 36727, 36725, 90318, 36723, 94427, 90316, 94673, 94425, 90312, 36721, 90304, 91987, 94311, 90300, 94309, 94414, 90292, 94307, 93774, 94305, 93772, 91985, 93770, 90288, 91983, 90286, 90284, 91981, 91979, 90282, 93763, 94410, 94302, 91158, 88196, 94294, 91974, 90275, 90273, 91972, 79806, 90270, 91970, 91968, 90266, 90264, 91966, 90262, 90260, 91963, 91134, 91132, 94085, 88193, 90258, 90256, 94062, 90254, 90252, 93960, 93984, 90250, 93086, 90248, 90244, 93956, 90241, 91961, 93986, 93761, 91958, 90229, 91130, 90227, 93889, 91124, 93083, 36712, 90219, 93079, 91122, 90216, 93077, 91118, 90213, 93587, 91115, 90208, 91949, 91113, 91111, 93279, 93276, 91109, 91947, 90205, 88186, 90203, 93571, 91107, 91939, 90194, 90192, 91937, 91935, 90190, 93553, 90188, 91933, 90186, 91097, 88178, 91930, 91095, 90182, 93197, 81241, 83978, 93195, 80509, 78370, 93270, 91928, 90179, 93193, 91093, 83976, 92867, 83974, 91090, 83972, 91088, 83970, 93191, 93362, 90177, 91926, 93188, 76358, 91923, 93366, 93360, 91080, 90174, 93358, 90160, 91078, 91913, 93170, 90157, 93309, 93167, 93236, 93165, 93181, 92854, 91075, 92852, 91073, 90152, 91071, 90150, 90147, 92850, 92846, 92843, 91069, 91066, 91063, 92925, 91061, 92923, 91057, 92921, 90144, 92840, 93072, 90134, 90132, 93178, 91907, 90130, 90127, 91905, 75052, 75049, 90123, 92909, 93067, 90121, 90117, 75045, 90115, 90113, 91033, 93047, 91031, 91901, 90111, 92838, 90109, 93044, 76351, 93042, 91897, 92834, 92830, 93039, 91895, 88176, 91892, 90107, 91890, 75036, 89789, 92827, 90105, 90103, 76512, 91029, 92900, 92824, 92822, 92898, 7975, 90097, 91023, 90094, 89787, 90092, 91884, 90090, 90086, 91020, 92815, 89785, 90084, 91017, 79804, 91881, 90082, 92812, 91015, 92810, 91013, 90080, 91879, 79802, 91870, 91009, 90075, 91866, 91005, 91863, 91861, 92687, 90069, 91003, 90067, 92680, 92684, 91859, 90065, 89784, 91000, 90994, 89782, 90061, 92678, 92682, 91856, 90058, 90990, 90056, 89779, 89777, 86698, 89775, 90983, 89862, 89773, 90979, 92540, 88575, 88514, 92538, 91691, 91693, 92555, 88747, 90053, 90050, 90047, 90045, 89771, 89860, 90043, 90976, 91853, 90041, 90039, 90974, 90035, 91850, 90969, 90033, 87028, 87026, 89766, 89764, 90949, 89762, 89760, 91848, 90945, 91845, 90944, 91843, 90942, 89706, 90940, 91841, 90938, 91838, 90936, 91836, 90933, 90930, 74359, 74357, 91831, 91826, 92408, 90928, 91822, 90926, 91820, 89759, 90924, 90019, 91817, 91814, 91809, 89757, 90921, 91802, 89754, 90918, 91799, 90016, 89752, 91796, 91793, 89750, 91791, 89856, 89850, 91789, 91787, 90014, 92406, 90010, 88173, 90915, 91663, 91610, 90007, 90002, 91660, 91608, 92402, 88663, 89025, 91613, 88661, 90877, 91604, 89949, 89925, 79786, 89923, 89920, 90861, 89918, 89916, 90859, 90854, 89914, 89912, 89910, 90852, 89739, 89908, 89395, 88739, 89736, 89733, 89729, 89393, 88736, 89801, 89892, 88165, 89649, 89683, 89389, 88657, 89699, 89791, 78875, 78873, 89480, 89478, 89442, 89470, 89177, 88814, 89437, 88655, 89354, 89383, 89352, 89381, 89379, 89350, 89377, 89344, 89375, 88653, 78366, 78364, 89293, 89291, 88651, 89166, 88640, 89163, 86526, 89160, 88633, 89021, 74852, 81841, 87934, 84865, 88628, 87929, 88824, 88792, 85925, 76860, 88822, 76859, 86193, 88617, 88818, 88710, 88613, 88790, 88698, 86585, 86582, 88693, 87450, 88595, 88580, 88578, 83966, 88511, 88509, 88507, 85454, 85452, 76856, 76853, 88504, 76846, 88233, 84852, 88372, 76842, 88259, 88368, 88251, 76839, 88229, 87346, 76836, 87548, 76833, 87546, 87542, 86397, 88131, 85124, 88129, 88069, 87919, 88067, 88126, 88053, 87917, 85121, 87890, 87673, 86280, 88041, 87888, 87739, 87373, 87082, 87024, 87080, 85443, 87173, 84352, 87671, 87169, 87540, 76342, 86443, 87167, 86441, 87165, 86439, 87163, 86437, 87161, 87160, 87475, 87440, 86434, 87158, 76338, 87437, 87556, 87370, 36708, 36706, 86432, 87021, 36704, 87368, 76336, 73058, 87252, 85988, 87248, 87077, 87245, 87257, 86191, 87073, 85091, 87018, 85087, 85085, 87012, 86989, 86909, 79266, 76713, 86900, 86706, 86523, 86385, 74844, 86702, 76540, 86587, 86561, 86607, 86189, 86580, 86579, 86184, 79768, 86060, 78190, 86422, 79765, 86174, 74841, 74839, 86417, 74837, 74835, 85390, 81908, 84667, 84665, 86217, 85600, 85598, 86325, 86031, 85787, 81025, 85105, 85797, 85785, 85103, 85676, 85101, 85671, 85782, 85669, 86150, 78187, 86168, 85099, 85667, 86164, 85664, 85683, 85682, 69013, 69011, 86147, 69006, 69004, 69002, 69000, 68998, 68996, 85653, 68994, 73703, 68992, 73701, 74833, 86073, 86069, 86071, 86067, 85639, 83286, 85637, 84801, 72232, 72230, 73662, 78185, 72228, 74831, 86065, 86064, 86058, 86062, 86028, 86025, 85895, 84662, 68988, 85980, 79676, 85888, 79674, 85374, 78183, 84779, 85432, 85778, 84389, 85742, 67764, 73860, 73465, 79981, 67761, 79672, 79979, 85705, 71652, 85476, 84387, 73852, 83284, 73699, 76538, 84777, 82329, 68986, 85430, 83303, 85630, 82122, 85621, 69920, 71254, 85469, 85580, 60909, 84610, 85357, 85350, 79920, 72226, 85370, 78251, 85061, 79918, 83261, 76461, 59135, 18146, 70125, 83561, 85058, 85041, 85096, 83038, 85037, 85052, 83282, 78180, 80213, 83242, 67749, 18138, 83560, 83558, 84242, 36698, 84201, 84760, 73891, 84571, 84478, 36696, 36694, 72868, 84772, 81019, 81810, 84549, 84236, 84565, 84337, 84233, 84620, 84198, 84608, 82082, 83035, 84168, 77832, 59133, 74995, 17340, 83516, 77250, 80761, 80398, 78250, 84102, 84155, 84289, 84015, 84205, 72919, 78533, 78532, 83032, 84129, 83133, 84187, 84196, 84185, 78288, 76026, 84142, 83693, 83965))
Run Time: 0.088979
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2870 | |
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 | | | | | 2870 | |
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 (10017, 10008, 9997, 9808, 9767, 9631, 9619, 9348, 9260, 9226, 9101, 9071, 9041, 9033, 9031, 9012, 8970, 8917, 8853, 8847, 8769, 8647, 8619, 8566, 8429, 8422, 8340, 8314, 8306, 8305, 8297, 8290, 8289, 8281, 8272, 8270, 8269, 8268, 8239, 8233, 8231, 8228, 8218, 8150, 8131, 8115, 8099, 8096, 8075, 8027, 8026, 8011, 8002, 7997, 7983, 7981, 7962, 7961, 7926, 7892, 7862, 7847, 7835, 7830, 7825, 7792, 7658, 7656, 7619, 7618, 7615, 7614, 7546, 7509, 7508, 7502, 7454, 7429, 7407, 7391, 7386, 7350, 7342, 7317, 7316))
Run Time: 0.004964
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 85 | 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 (147316, 147842, 136752, 136750, 147592, 147658, 96104, 146537, 142714, 147608, 147604, 147586, 142707, 119868, 147570, 147123, 147025, 147002, 147574, 147568, 142702, 147484, 136748, 119867, 119865, 136746, 119863, 119860, 136738, 147424, 119858, 136736, 136733, 136731, 147354, 147352, 119855, 136730, 147297, 136727, 136725, 144311, 145648, 144309, 147340, 144307, 145344, 136723, 142573, 142584, 144305, 147121, 147203, 147261, 146077, 145971, 145968, 145967, 145835, 145831, 145827, 145825, 145818, 145817, 145810, 146592, 146590, 146585, 136715, 146576, 136707, 146567, 146565, 136704, 119833, 136702, 145793, 136699, 136697, 96101, 136695, 146485, 145768, 145698, 119831, 145717, 145696, 145714, 145693, 136692, 143126, 136690, 143125, 145688, 119826, 145559, 146214, 145103, 137429, 141958, 146212, 145686, 136688, 141956, 145641, 119824, 136686, 144281, 136684, 96099, 145633, 145544, 145666, 145539, 144275, 119817, 119815, 145092, 119813, 145531, 145089, 145529, 119811, 145525, 119809, 145087, 145622, 145620, 119805, 145651, 145315, 145477, 143852, 136680, 143850, 136678, 143848, 137419, 119802, 137417, 119800, 145311, 144119, 144117, 141756, 119788, 145306, 145055, 136675, 119786, 136671, 119777, 119771, 119768, 145031, 145070, 136667, 145066, 136663, 145061, 136661, 136658, 136656, 136654, 144894, 144990, 144891, 144889, 144988, 142277, 119765, 144983, 144882, 144226, 144225, 144878, 144876, 136652, 136650, 144221, 144870, 142275, 144598, 144595, 144630, 119763, 144627, 144623, 144695, 142273, 144676, 144674, 119761, 144671, 144669, 136645, 144666, 144664, 136643, 119755, 141752, 144371, 144200, 136641, 144316, 144198, 136639, 136637, 136635, 144182, 136631, 119747, 136628, 144178, 136623, 119745, 136621, 136612, 119738, 142272, 142316, 139095, 142136, 142266, 142264, 139065, 142262, 139063, 142134, 142259, 142132, 142130, 141927, 139039, 136587, 139037, 136585, 139035, 141646, 139033, 119727, 100350, 139031, 119725, 139029, 142110, 136583, 136580, 136577, 136575, 139022, 139020, 142095, 119722, 141396, 96098, 136573, 119713, 136569, 119711, 136566, 141386, 136539, 140547, 136537, 141817, 138963, 119705, 136536, 138960, 141799, 96094, 96091, 96088, 96086, 119699, 136534, 141613, 96082, 96081, 96079, 96076, 141622, 138940, 141619, 119696, 138914, 138910, 119685, 138908, 138859, 140451, 140731, 140448, 136377, 136375, 140728, 140556, 140726, 119675, 136528, 119673, 136526, 140526, 119664, 140104, 138482, 140202, 115339, 140100, 137964, 136524, 115337, 136518, 119647, 136514, 136512, 136510, 119645, 119642, 136508, 137961, 119637, 136503, 138824, 127657, 119625, 138813, 129771, 136500, 139648, 127655, 138774, 138153, 139556, 138731, 119620, 119617, 138475, 119615, 122218, 138715, 138517, 119613, 136468, 119603, 136461, 136206, 136459, 18207, 136454, 137073, 119592, 129852, 136418, 119589, 136191, 18176, 129766, 129764, 119584, 137453, 136183, 18174, 126913, 133813, 138286, 138104, 136104, 126909, 137559, 137015, 136181, 138275, 88146, 138143, 138135, 137324, 137831, 138093, 136178, 138068, 120852, 137952, 120850, 124377, 120847, 120844, 135587, 120842, 137513, 137950, 120840, 137375, 124371, 138000, 137353, 137566, 137350, 129762, 137348, 119581, 136174, 119579, 135584, 122681, 137564, 136096, 137006, 137004, 136082, 137002, 136078, 136075, 136070, 136414, 136066, 136062, 120836, 137610, 136412, 136410, 136408, 134315, 137561, 95828, 120832, 136050, 136121, 136119, 136117, 137520, 137321, 136044, 95825, 134751, 136029, 136027, 137164, 130176, 137318, 136167, 137296, 136404, 129845, 127626, 137167, 137106, 119573, 136997, 130038, 135977, 136370, 135972, 136389, 119565, 135967, 135965, 119560, 135518, 82586, 136246, 136163, 135943, 135904, 135939, 135934, 133383, 130033, 119556, 117280, 135325, 135156, 135065, 129546, 135154, 135152, 135265, 129543, 133675, 135091, 135059, 134581, 129530, 135147, 133673, 135053, 135009, 135020, 128751, 115330, 134986, 127202, 135004, 119554, 127200, 134867, 133668, 134957, 129515, 129512, 129510, 134741, 129508, 119552, 134653, 129501, 134664, 96074, 134651, 134660, 119549, 134395, 129631, 134292, 130269, 129629, 127621, 134290, 127619, 123948, 134286, 134247, 134244, 134151, 134241, 134392, 129986, 133759, 124368, 133372, 130321, 130188, 128077, 123647, 129422, 129954, 129830, 119535, 128739, 119532, 119530, 128574, 129606, 129381, 119528, 119524, 119519, 129373, 119517, 115733, 129343, 128064, 129747, 129601, 119514, 129706, 119510, 129685, 129693, 119507, 119505, 129332, 119503, 129330, 129592, 119500, 128730, 129327, 119498, 119496, 119494, 119491, 129170, 119488, 128725, 129256, 128723, 127398, 128721, 128719, 128420, 128711, 119486, 119484, 119482, 8011, 121554, 128682, 125679, 119480, 119478, 119476, 128542, 119474, 128551, 121551, 127982, 119470, 128531, 119466, 128414, 116302, 127933, 122660, 128409, 119462, 128352, 127917, 119457, 100848, 120396, 119455, 120394, 127979, 127977, 127786, 127886, 119433, 127424, 127446, 126628, 127271, 127269, 127413, 127267, 127406, 127262, 127265, 127371, 120389, 124365, 124363, 126599, 126597, 127134, 127131, 124361, 124764, 115327, 113148, 113146, 119430, 126606, 119428, 119426, 125985, 119424, 126322, 119418, 124834, 123379, 126248, 125190, 125186, 125665, 126088, 124813, 125323, 119416, 119411, 119398, 119393, 119378, 119374, 119372, 119367, 124541, 125258, 125264, 119363, 119358, 119356, 124359, 119352, 119349, 124796, 124722, 124794, 124716, 120386, 120383, 119344, 120381, 124525, 122939, 124518, 124444, 112938, 122937, 117229, 119340, 119339, 112936, 36767, 122935, 120378, 120376, 120369, 119332, 120247, 121564, 123928, 119323, 119320, 124115, 119318, 123925, 119315, 119311, 120367, 119309, 122775, 124106, 123907, 123839, 116658, 119301, 123899, 119296, 100321, 82341, 123894, 119288, 123827, 123600, 123598, 123821, 123817, 116655, 122143, 119286, 105, 119284, 103, 119282, 123587, 119277, 119275, 123582, 123782, 119273, 123578, 123789, 123787, 123575, 123571, 123496, 119271, 123529, 120928, 119268, 123567, 123546, 123088, 119266, 123289, 123535, 123565, 119264, 36760, 119258, 119255, 119252, 119244, 119242, 119240, 119235, 119232, 119223, 123067, 123204, 123182, 123107, 115272, 123103, 115270, 123110, 123101, 123099, 123047, 123114, 119216, 123077, 123097, 123043, 123075, 119211, 122214, 122948, 123036, 119208, 119205, 119203, 122958, 115716, 119198, 119196, 119192, 119190, 119188, 122757, 112774, 122195, 116865, 115544, 122190, 122712, 116858, 119184, 119182, 122650, 119179, 119176, 119172, 119166, 119164, 119162, 119160, 122225, 121636, 115994, 119153, 115542, 119150, 121380, 121489, 119148, 121364, 121563, 119142, 119140, 121356, 121358, 115597, 121354, 120365, 117865, 119138, 117863, 120363, 119135, 121212, 117860, 119133, 119129, 117739, 115215, 121209, 120164, 119127, 92398, 121229, 92393, 119125, 120162, 121227, 119121, 120359, 121199, 121136, 92391, 119119, 120160, 119117, 92389, 120357, 120355, 117857, 120351, 92387, 121131, 120348, 119114, 119112, 120346, 119110, 120344, 121018, 92385, 120341, 120339, 92383, 120337, 120939, 120936, 116963, 120893, 120334, 119105, 119101, 120890, 92381, 120328, 120931, 120158, 120325, 119099, 119097, 120323, 119095, 119093, 119091, 120320, 120318, 119089, 120316, 119086, 120888, 120140, 120137, 120312, 92378, 120309, 116961, 120857, 115540, 120305, 120802, 120301, 118146, 120299, 118144, 120297, 118142, 120294, 120291, 118855, 120288, 115187, 115185, 120286, 119080, 115183, 120284, 119078, 115180, 115173, 115170, 115167, 120156, 119076, 115536, 92376, 116708, 120154, 119073, 120152, 119070, 120128, 119068, 115534, 115532, 119064, 120108, 114589, 119062, 115530, 120097, 81332, 119005, 115528, 118818, 92374, 115146, 115526, 118815, 115523, 118845, 119002, 116706, 117844, 118899, 118897, 118838, 92372, 92370, 113962, 116704, 118788, 92368, 115139, 92365, 92363, 92361, 118813, 115127, 115125, 116578, 115122, 92356, 92355, 92353, 118795, 92351, 92347, 111526, 118783, 116700, 118473, 118444, 111223, 118469, 118542, 115520, 118135, 114327, 118467, 118133, 118077, 92345, 118441, 118129, 118127, 117195, 116957, 92343, 92341, 116952, 116605, 116948, 116603, 113328, 116946, 118204, 116935, 115008, 115003, 81329, 115514, 92339, 118242, 118176, 116598, 116595, 116498, 118073, 111019, 116496, 118071, 111221, 118069, 111219, 113218, 117767, 116698, 117765, 116490, 118021, 118019, 113769, 118017, 113766, 118014, 117763, 97363, 118011, 96719, 117831, 114992, 118009, 116696, 92337, 118005, 116694, 96714, 113359, 116756, 117825, 116926, 117823, 116924, 117760, 117062, 92335, 113757, 117050, 116916, 117073, 114564, 116733, 116833, 116692, 116671, 113742, 116912, 113953, 116760, 116765, 116627, 113711, 116187, 115694, 116508, 116506, 116416, 116291, 115325, 116289, 116423, 92328, 116198, 113689, 92326, 114881, 115891, 115889, 115958, 115501, 92320, 115886, 92319, 114861, 114635, 115773, 115851, 102762, 115474, 92316, 114841, 114838, 115429, 115457, 113569, 115452, 115311, 114820, 113562, 113560, 91513, 114815, 92314, 115322, 115298, 114800, 114798, 115277, 113555, 114500, 36753, 114453, 114115, 92312, 112084, 114439, 114337, 112081, 114230, 113643, 114092, 92307, 92304, 91507, 113637, 102911, 114083, 112746, 113887, 113632, 92302, 98201, 92297, 92295, 92293, 92291, 113627, 91505, 112076, 113433, 113475, 113421, 113419, 113394, 113366, 113339, 98196, 112073, 101906, 113297, 92270, 112920, 102201, 112916, 101863, 101861, 112070, 112068, 101855, 92268, 112622, 113042, 92265, 112901, 101847, 112899, 92262, 112721, 101843, 111214, 112708, 112065, 112536, 112838, 112533, 112530, 112061, 98194, 112528, 112059, 112833, 112208, 112290, 92254, 112288, 112282, 112687, 92249, 112280, 111187, 112682, 111183, 112692, 92246, 67823, 112052, 67819, 111170, 112605, 92244, 111165, 67817, 67814, 92242, 92239, 112276, 112274, 112583, 112523, 112521, 112271, 112519, 112517, 112514, 112479, 92236, 112046, 92234, 112543, 92232, 112267, 112509, 112473, 112506, 112471, 112469, 110837, 92230, 92228, 112440, 112206, 92225, 92219, 101833, 92215, 111083, 101831, 112349, 112197, 112017, 112263, 92213, 112195, 112096, 92210, 112254, 112204, 112252, 110928, 112010, 101305, 111667, 111013, 111908, 111901, 110960, 111639, 92197, 111055, 103318, 103317, 103315, 103313, 103312, 103311, 110814, 92192, 91499, 103304, 102380, 102907, 102905, 102865, 101768, 102351, 102347, 102345, 102773, 102729, 101989, 92188, 102339, 101986, 101984, 102192, 98615, 101398, 102329, 101766, 102505, 102490, 102364, 102082, 102488, 92186, 92184, 102378, 102325, 102077, 91621, 92182, 102257, 92180, 92178, 92176, 101133, 101130, 101602, 92175, 101978, 101975, 101972, 101970, 100388, 102163, 101968, 102089, 102161, 102152, 91497, 101598, 102150, 102147, 102004, 92171, 92169, 101993, 91494, 102034, 101818, 92166, 91490, 91488, 101966, 101964, 91486, 101962, 101960, 95725, 92165, 101957, 101760, 101727, 101806, 101942, 102011, 101955, 91483, 101676, 101108, 101488, 101104, 101102, 92163, 101099, 101486, 101481, 91481, 91479, 91476, 92161, 91474, 92160, 92157, 92154, 92152, 92149, 100957, 97601, 93115, 95234, 86048, 86046, 91472, 100953, 91470, 86044, 100951, 91468, 91466, 91464, 100891, 91462, 98711, 100782, 99885, 101268, 100882, 101266, 101264, 92147, 92145, 91456, 101262, 92143, 91454, 91452, 101251, 100835, 101233, 91450, 92141, 100833, 100950, 100948, 100946, 101225, 100944, 100939, 100933, 100931, 88750, 92140, 100973, 99574, 100304, 100804, 100861, 100800, 100078, 91449, 100797, 100775, 100697, 100773, 100794, 91445, 93111, 79858, 93107, 93105, 93103, 93101, 79851, 100514, 100512, 100510, 91437, 91431, 100567, 91428, 91425, 93095, 91423, 99831, 91420, 91417, 100288, 100552, 91411, 91408, 73723, 91406, 73721, 100483, 91404, 67792, 100336, 100235, 100265, 73719, 91401, 99964, 79845, 79843, 100216, 99950, 99947, 79841, 100209, 96031, 92138, 99810, 91394, 92136, 92134, 100064, 99903, 99936, 92132, 91392, 99926, 96941, 91380, 92130, 99662, 99648, 99908, 92128, 91376, 99837, 99782, 99780, 98576, 91374, 99777, 99774, 99771, 99768, 97897, 91372, 97891, 99765, 91370, 99762, 98325, 91368, 98323, 92125, 98321, 91366, 92123, 92118, 92116, 91364, 91362, 97883, 91360, 91358, 91355, 91353, 99634, 99631, 97972, 99629, 99612, 99627, 86368, 91350, 99609, 91348, 97970, 91346, 97968, 98574, 91344, 98564, 98960, 98176, 98562, 97717, 98559, 98557, 99555, 98698, 97955, 99578, 98553, 97953, 91339, 91327, 91325, 98696, 91322, 91316, 91313, 99387, 99505, 99383, 99497, 99105, 99493, 24154, 99378, 91310, 99101, 98168, 99098, 99372, 99237, 97596, 99235, 99231, 99225, 99220, 99214, 79833, 99211, 92110, 97594, 92109, 99207, 99202, 92108, 99200, 99197, 99192, 99188, 99182, 99177, 99173, 99168, 99166, 99090, 97592, 99146, 92106, 96024, 97951, 99078, 98545, 98930, 98882, 98928, 99002, 98543, 98709, 96014, 98501, 72098, 98160, 98158, 98499, 98300, 79826, 98879, 96012, 96011, 98603, 98515, 98636, 98513, 98489, 90828, 90826, 90817, 98296, 97283, 92097, 98294, 92095, 97631, 97800, 97628, 98415, 98147, 92079, 92073, 90802, 95989, 95985, 90800, 95983, 90797, 90795, 95981, 92068, 90790, 90784, 97872, 95976, 90781, 97869, 94330, 90766, 97703, 90764, 98045, 90762, 90759, 95969, 90749, 90746, 98140, 90744, 95963, 96682, 90722, 90719, 95957, 90710, 95951, 90708, 95949, 95946, 98060, 90700, 95943, 95940, 90694, 98035, 98054, 95938, 90689, 95937, 90670, 90663, 97941, 97695, 97907, 97862, 97859, 97625, 96246, 97401, 92062, 90650, 91295, 83999, 97070, 93260, 97317, 97313, 97265, 97068, 91293, 97066, 97064, 97028, 83990, 97026, 95512, 97024, 93875, 97022, 83986, 90625, 91278, 90622, 97109, 95915, 97021, 96488, 97009, 96548, 96483, 96480, 84176, 96546, 97003, 96354, 96478, 96289, 96892, 95846, 96999, 96287, 96352, 88962, 96285, 96281, 95330, 94133, 96995, 96993, 93674, 96977, 96889, 96462, 91275, 92058, 96524, 96459, 90599, 88951, 96269, 96457, 96266, 96346, 96641, 96344, 96638, 96332, 96327, 96514, 95486, 96449, 96447, 96437, 96325, 96434, 91273, 96494, 90566, 96432, 96425, 96322, 96423, 96422, 96418, 95479, 96319, 96317, 96315, 95477, 92056, 96312, 92050, 95659, 92047, 92045, 96261, 92041, 95901, 96237, 95537, 90562, 95567, 90560, 96194, 91271, 92039, 90558, 90556, 96192, 86874, 96190, 90552, 87030, 90547, 90523, 95711, 90521, 90517, 95873, 95708, 90515, 95893, 95703, 90510, 95315, 95870, 90506, 90503, 92038, 90501, 90498, 93869, 92035, 90491, 90487, 91270, 92032, 90485, 95732, 91268, 92030, 90483, 95727, 90481, 95583, 95466, 90443, 90436, 90434, 90432, 92026, 90430, 95532, 91265, 94729, 95559, 95557, 95529, 90428, 90426, 91261, 91256, 94559, 94557, 90422, 94554, 95152, 90419, 94552, 92024, 90417, 92022, 94548, 94544, 90411, 90405, 91244, 91242, 91239, 90402, 91233, 91231, 90396, 91228, 90392, 94374, 90390, 91226, 91224, 92021, 90388, 95297, 90386, 92019, 91222, 94975, 94860, 91220, 91217, 91215, 95550, 95527, 95548, 95464, 95545, 81322, 95221, 95524, 81320, 95462, 81317, 85690, 81315, 94973, 81313, 81310, 94971, 95000, 91213, 94770, 94969, 94967, 95459, 95456, 95216, 95446, 95442, 94329, 95439, 95078, 93922, 94964, 91211, 94541, 94962, 94960, 94537, 94535, 94533, 91209, 95431, 93918, 95428, 95212, 91207, 95426, 94529, 91205, 94526, 91203, 91202, 91200, 95209, 94521, 94517, 94515, 94513, 94510, 94620, 94508, 91196, 94953, 91194, 90384, 92017, 92015, 90378, 92013, 91187, 92011, 91184, 91181, 94498, 94496, 94494, 91178, 92010, 92008, 92006, 92004, 92001, 94491, 95040, 95071, 94489, 95069, 95068, 95066, 91999, 95063, 91997, 95051, 94326, 93863, 91995, 91993, 94324, 94486, 93861, 94483, 95036, 91991, 94480, 93858, 93855, 94322, 93853, 94317, 93850, 94614, 94611, 36744, 94609, 94313, 94478, 91176, 90372, 94607, 94994, 91174, 90370, 94121, 94119, 90366, 94605, 86870, 36742, 93846, 94602, 94600, 94107, 93829, 94928, 90361, 94921, 94906, 94475, 36739, 94473, 94587, 94904, 94470, 94469, 93910, 90348, 90346, 89314, 90343, 94462, 90341, 93816, 91172, 90339, 91170, 94457, 90337, 91168, 94455, 90335, 91990, 90329, 91166, 90327, 94585, 91164, 94583, 90321, 36737, 36736, 94443, 94679, 36727, 36725, 90318, 36723, 94427, 90316, 94673, 94425, 90312, 36721, 90304, 91987, 94311, 90300, 94309, 94414, 90292, 94307, 93774, 94305, 93772, 91985, 93770, 90288, 91983, 90286, 90284, 91981, 91979, 90282, 93763, 94410, 94302, 91158, 88196, 94294, 91974, 90275, 90273, 91972, 79806, 90270, 91970, 91968, 90266, 90264, 91966, 90262, 90260, 91963, 91134, 91132, 94085, 88193, 90258, 90256, 94062, 90254, 90252, 93960, 93984, 90250, 93086, 90248, 90244, 93956, 90241, 91961, 93986, 93761, 91958, 90229, 91130, 90227, 93889, 91124, 93083, 36712, 90219, 93079, 91122, 90216, 93077, 91118, 90213, 93587, 91115, 90208, 91949, 91113, 91111, 93279, 93276, 91109, 91947, 90205, 88186, 90203, 93571, 91107, 91939, 90194, 90192, 91937, 91935, 90190, 93553, 90188, 91933, 90186, 91097, 88178, 91930, 91095, 90182, 93197, 81241, 83978, 93195, 80509, 78370, 93270, 91928, 90179, 93193, 91093, 83976, 92867, 83974, 91090, 83972, 91088, 83970, 93191, 93362, 90177, 91926, 93188, 76358, 91923, 93366, 93360, 91080, 90174, 93358, 90160, 91078, 91913, 93170, 90157, 93309, 93167, 93236, 93165, 93181, 92854, 91075, 92852, 91073, 90152, 91071, 90150, 90147, 92850, 92846, 92843, 91069, 91066, 91063, 92925, 91061, 92923, 91057, 92921, 90144, 92840, 93072, 90134, 90132, 93178, 91907, 90130, 90127, 91905, 75052, 75049, 90123, 92909, 93067, 90121, 90117, 75045, 90115, 90113, 91033, 93047, 91031, 91901, 90111, 92838, 90109, 93044, 76351, 93042, 91897, 92834, 92830, 93039, 91895, 88176, 91892, 90107, 91890, 75036, 89789, 92827, 90105, 90103, 76512, 91029, 92900, 92824, 92822, 92898, 7975, 90097, 91023, 90094, 89787, 90092, 91884, 90090, 90086, 91020, 92815, 89785, 90084, 91017, 79804, 91881, 90082, 92812, 91015, 92810, 91013, 90080, 91879, 79802, 91870, 91009, 90075, 91866, 91005, 91863, 91861, 92687, 90069, 91003, 90067, 92680, 92684, 91859, 90065, 89784, 91000, 90994, 89782, 90061, 92678, 92682, 91856, 90058, 90990, 90056, 89779, 89777, 86698, 89775, 90983, 89862, 89773, 90979, 92540, 88575, 88514, 92538, 91691, 91693, 92555, 88747, 90053, 90050, 90047, 90045, 89771, 89860, 90043, 90976, 91853, 90041, 90039, 90974, 90035, 91850, 90969, 90033, 87028, 87026, 89766, 89764, 90949, 89762, 89760, 91848, 90945, 91845, 90944, 91843, 90942, 89706, 90940, 91841, 90938, 91838, 90936, 91836, 90933, 90930, 74359, 74357, 91831, 91826, 92408, 90928, 91822, 90926, 91820, 89759, 90924, 90019, 91817, 91814, 91809, 89757, 90921, 91802, 89754, 90918, 91799, 90016, 89752, 91796, 91793, 89750, 91791, 89856, 89850, 91789, 91787, 90014, 92406, 90010, 88173, 90915, 91663, 91610, 90007, 90002, 91660, 91608, 92402, 88663, 89025, 91613, 88661, 90877, 91604, 89949, 89925, 79786, 89923, 89920, 90861, 89918, 89916, 90859, 90854, 89914, 89912, 89910, 90852, 89739, 89908, 89395, 88739, 89736, 89733, 89729, 89393, 88736, 89801, 89892, 88165, 89649, 89683, 89389, 88657, 89699, 89791, 78875, 78873, 89480, 89478, 89442, 89470, 89177, 88814, 89437, 88655, 89354, 89383, 89352, 89381, 89379, 89350, 89377, 89344, 89375, 88653, 78366, 78364, 89293, 89291, 88651, 89166, 88640, 89163, 86526, 89160, 88633, 89021, 74852, 81841, 87934, 84865, 88628, 87929, 88824, 88792, 85925, 76860, 88822, 76859, 86193, 88617, 88818, 88710, 88613, 88790, 88698, 86585, 86582, 88693, 87450, 88595, 88580, 88578, 83966, 88511, 88509, 88507, 85454, 85452, 76856, 76853, 88504, 76846, 88233, 84852, 88372, 76842, 88259, 88368, 88251, 76839, 88229, 87346, 76836, 87548, 76833, 87546, 87542, 86397, 88131, 85124, 88129, 88069, 87919, 88067, 88126, 88053, 87917, 85121, 87890, 87673, 86280, 88041, 87888, 87739, 87373, 87082, 87024, 87080, 85443, 87173, 84352, 87671, 87169, 87540, 76342, 86443, 87167, 86441, 87165, 86439, 87163, 86437, 87161, 87160, 87475, 87440, 86434, 87158, 76338, 87437, 87556, 87370, 36708, 36706, 86432, 87021, 36704, 87368, 76336, 73058, 87252, 85988, 87248, 87077, 87245, 87257, 86191, 87073, 85091, 87018, 85087, 85085, 87012, 86989, 86909, 79266, 76713, 86900, 86706, 86523, 86385, 74844, 86702, 76540, 86587, 86561, 86607, 86189, 86580, 86579, 86184, 79768, 86060, 78190, 86422, 79765, 86174, 74841, 74839, 86417, 74837, 74835, 85390, 81908, 84667, 84665, 86217, 85600, 85598, 86325, 86031, 85787, 81025, 85105, 85797, 85785, 85103, 85676, 85101, 85671, 85782, 85669, 86150, 78187, 86168, 85099, 85667, 86164, 85664, 85683, 85682, 69013, 69011, 86147, 69006, 69004, 69002, 69000, 68998, 68996, 85653, 68994, 73703, 68992, 73701, 74833, 86073, 86069, 86071, 86067, 85639, 83286, 85637, 84801, 72232, 72230, 73662, 78185, 72228, 74831, 86065, 86064, 86058, 86062, 86028, 86025, 85895, 84662, 68988, 85980, 79676, 85888, 79674, 85374, 78183, 84779, 85432, 85778, 84389, 85742, 67764, 73860, 73465, 79981, 67761, 79672, 79979, 85705, 71652, 85476, 84387, 73852, 83284, 73699, 76538, 84777, 82329, 68986, 85430, 83303, 85630, 82122, 85621, 69920, 71254, 85469, 85580, 60909, 84610, 85357, 85350, 79920, 72226, 85370, 78251, 85061, 79918, 83261, 76461, 59135, 18146, 70125, 83561, 85058, 85041, 85096, 83038, 85037, 85052, 83282, 78180, 80213, 83242, 67749, 18138, 83560, 83558, 84242, 36698, 84201, 84760, 73891, 84571, 84478, 36696, 36694, 72868, 84772, 81019, 81810, 84549, 84236, 84565, 84337, 84233, 84620, 84198, 84608, 82082, 83035, 84168, 77832, 59133, 74995, 17340, 83516, 77250, 80761, 80398, 78250, 84102, 84155, 84289, 84015, 84205, 72919, 78533, 78532, 83032, 84129, 83133, 84187, 84196, 84185, 78288, 76026, 84142, 83693, 83965))
Run Time: 0.049980
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2870 | |
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 | | | | | 2870 | |
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 (10017, 10008, 9997, 9808, 9767, 9631, 9619, 9348, 9260, 9226, 9101, 9071, 9041, 9033, 9031, 9012, 8970, 8917, 8853, 8847, 8769, 8647, 8619, 8566, 8429, 8422, 8340, 8314, 8306, 8305, 8297, 8290, 8289, 8281, 8272, 8270, 8269, 8268, 8239, 8233, 8231, 8228, 8218, 8150, 8131, 8115, 8099, 8096, 8075, 8027, 8026, 8011, 8002, 7997, 7983, 7981, 7962, 7961, 7926, 7892, 7862, 7847, 7835, 7830, 7825, 7792, 7658, 7656, 7619, 7618, 7615, 7614, 7546, 7509, 7508, 7502, 7454, 7429, 7407, 7391, 7386, 7350, 7342, 7317, 7316))
Run Time: 0.002317
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 85 | 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, �?r
Run Time: 0.000213
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: �?r, XF\Pub\Controller\Member, RecentContent, valid, user_id=2061, 1716210774, , 0, �?r
Run Time: 0.000149
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000346
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.000531
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: 1716210474
Run Time: 0.000743
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 16 | 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` >= 1716210474)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000614
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 16 | 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