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.000620
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.000265
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` = '1545')
LIMIT 1
Run Time: 0.000471
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.001615
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_1545' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.223363
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 (513372, 513371, 513366, 513363, 513362, 513358, 513183, 513182, 513181, 513176, 513353, 513060, 323978, 513349, 513348, 513345, 511874, 513155, 511872, 511870, 513153, 513151, 511868, 513194, 512661, 511866, 348087, 348084, 511864, 512658, 512657, 511860, 511856, 511855, 348079, 348078, 512133, 495649, 397262, 484494, 323973, 387482, 387481, 511502, 511501, 495570, 501760, 269945, 502242, 494011, 494010, 510919, 510509, 494007, 348075, 509020, 250267, 250251, 250245, 253102, 250236, 250235, 250231, 250220, 250215, 250213, 250212, 250207, 250203, 250193, 250190, 250177, 250567, 250566, 249959, 253105, 250563, 250175, 251055, 250158, 251053, 247508, 250153, 252978, 250989, 251051, 204286, 250557, 251048, 250555, 251046, 252976, 250138, 252953, 250134, 250132, 250130, 252949, 250126, 250111, 250108, 250103, 250101, 203012, 250095, 250974, 250076, 250067, 143234, 250061, 250789, 248346, 250377, 250540, 250056, 203007, 250652, 250649, 204282, 203003, 250441, 250440, 249938, 250451, 250450, 203002, 249899, 250435, 250432, 249898, 249897, 250407, 250406, 202997, 250394, 247507, 250392, 250044, 204276, 192805, 204274, 249881, 249980, 249951, 249931, 249928, 249877, 193663, 193661, 248081, 152329, 192803, 248344, 248342, 248341, 152327, 249491, 247735, 248926, 248923, 248921, 249448, 249487, 248917, 249483, 249482, 248998, 249457, 249478, 249455, 249476, 248904, 204271, 249290, 117506, 163607, 248996, 249242, 117503, 204267, 36847, 249078, 204260, 249063, 204256, 248956, 248955, 204254, 204252, 36838, 204244, 247859, 248782, 36835, 204240, 248781, 248931, 204236, 248929, 248339, 248884, 204235, 204234, 204231, 191213, 191212, 247734, 193755, 248778, 204229, 248775, 248792, 204224, 143233, 248768, 248766, 248762, 204217, 202995, 202992, 222617, 204215, 247505, 204214, 204211, 248300, 247846, 247844, 248295, 248525, 222611, 222315, 207240, 222609, 248336, 163601, 247839, 247838, 247835, 247828, 248117, 247825, 142923, 248085, 247817, 192802, 142921, 247908, 247903, 247721, 192800, 247814, 247813, 247805, 208273, 247689, 222689, 207298, 222687, 247714, 222685, 194411, 208178, 247684, 222683, 208327, 192798, 192796, 192795, 142917, 142915, 192794, 143227, 208504, 208502, 142911, 142908, 247370, 247502, 247500, 247495, 222529, 247493, 172018, 247490, 142906, 142905, 172014, 247458, 208498, 247301, 222543, 247299, 222672, 201485, 208093, 194409, 152322, 152320, 152318, 152317, 222222, 222526, 202989, 208177, 222583, 172004, 222581, 194402, 208176, 222667, 222645, 222643, 143214, 222247, 194400, 222522, 222518, 222515, 222491, 222537, 222496, 222535, 143210, 222546, 222513, 222482, 208123, 222242, 222240, 222264, 222310, 208484, 222278, 208480, 222261, 222235, 171346, 222269, 222259, 171344, 152311, 142893, 142891, 142890, 222116, 142887, 222114, 142885, 222110, 222109, 222107, 222104, 222102, 171335, 207905, 222058, 208362, 207963, 207961, 208563, 208163, 208517, 208516, 208513, 208452, 208534, 208161, 208283, 18261, 208308, 208354, 208348, 208346, 207959, 208339, 207119, 163600, 208152, 208193, 208191, 142875, 208186, 208184, 208147, 117488, 208145, 163595, 202433, 163593, 208142, 208140, 163590, 208139, 208138, 202430, 208026, 208109, 208024, 208134, 208089, 207465, 208021, 208087, 208019, 208016, 206565, 117485, 117483, 171998, 36831, 207442, 171333, 207974, 207929, 171331, 171329, 207972, 207950, 207946, 117481, 207891, 207920, 207918, 207726, 207708, 207879, 207870, 206560, 204760, 204757, 202987, 207867, 207722, 207615, 206553, 206452, 142866, 206548, 142863, 203922, 207108, 206542, 202984, 202982, 194838, 203920, 202981, 202978, 207192, 184636, 207010, 204584, 202972, 202969, 207002, 117478, 202967, 202966, 117476, 206918, 117475, 117473, 117472, 206846, 165402, 206835, 206449, 206829, 206828, 127055, 204750, 193480, 193479, 202963, 193477, 206775, 181645, 206752, 204582, 206766, 204579, 206443, 206441, 206744, 171323, 206739, 202961, 204779, 206529, 206242, 206240, 201515, 201513, 127044, 206438, 204771, 202956, 206435, 16554, 16551, 192793, 204825, 204823, 204814, 204745, 204743, 204569, 16540, 204044, 203916, 203912, 203910, 16536, 203907, 204198, 201796, 201918, 204196, 204566, 204347, 204560, 204342, 204341, 204337, 204334, 204332, 204329, 203777, 202936, 165397, 203900, 203775, 203774, 203897, 203766, 203893, 203764, 203890, 203762, 203761, 203887, 203883, 203584, 203936, 203934, 203879, 203872, 203867, 203866, 203864, 203861, 203757, 203747, 203745, 203737, 202486, 203453, 202485, 203450, 203446, 203440, 203436, 203432, 203429, 203424, 203422, 202474, 202040, 202913, 202808, 202886, 202880, 202782, 202778, 167083, 202728, 202754, 202726, 202912, 202875, 202775, 202272, 202773, 190605, 202266, 190603, 184775, 202264, 202259, 202255, 202254, 202908, 194341, 120075, 120073, 202244, 202240, 202239, 202237, 120071, 193660, 202232, 184767, 202804, 202815, 202752, 202719, 202736, 190600, 183197, 202667, 202703, 190023, 194796, 202464, 202381, 202451, 160135, 167081, 202340, 195134, 167078, 202383, 202335, 202190, 202329, 201916, 163587, 163585, 163584, 202064, 202026, 202052, 202058, 202057, 202001, 190014, 190011, 201986, 201787, 96766, 201976, 193295, 96762, 201971, 201785, 201822, 201761, 201883, 201951, 165393, 191086, 201709, 173394, 201777, 201775, 201706, 201703, 201478, 201701, 163583, 163582, 201699, 201826, 96758, 120748, 201801, 192333, 201741, 120746, 201695, 201693, 201738, 201691, 120743, 201769, 201543, 201686, 201541, 190934, 173508, 120711, 195245, 193747, 120708, 201352, 192626, 192622, 192621, 120703, 193744, 117467, 195044, 194729, 195043, 193738, 193727, 120692, 193725, 195196, 193719, 190599, 190597, 190596, 120673, 193707, 193706, 193705, 120671, 120070, 193702, 195191, 195189, 191367, 143197, 191364, 191361, 191359, 194823, 120650, 120647, 120645, 194821, 193963, 120643, 194717, 195055, 120639, 142842, 120637, 195051, 187249, 194755, 142839, 183529, 195011, 193955, 194979, 193953, 193951, 194977, 193946, 193943, 193941, 192792, 193939, 194932, 194969, 194023, 152308, 183525, 18258, 18257, 192822, 194913, 193437, 193286, 191498, 193284, 194876, 142835, 193937, 193935, 193932, 193930, 194171, 193699, 193689, 193825, 193235, 193927, 193233, 193823, 193685, 194281, 193683, 193926, 194138, 193280, 96756, 194084, 194157, 193920, 193918, 193681, 193807, 193853, 190802, 193915, 194133, 193679, 193805, 193804, 194130, 193913, 160662, 185501, 190616, 192790, 193657, 193852, 193677, 194030, 194012, 194016, 192382, 117458, 193873, 193904, 193655, 184101, 169723, 193621, 160658, 193650, 193648, 160656, 160654, 193409, 184090, 185497, 190612, 193099, 184088, 192876, 192239, 192900, 193067, 165390, 193090, 165388, 192929, 192784, 192927, 192782, 192911, 192780, 192908, 192894, 192906, 192872, 192778, 192145, 165386, 192776, 142813, 192523, 143172, 192723, 192013, 192718, 192009, 192005, 165384, 192520, 192003, 190101, 189934, 192637, 186069, 192001, 192000, 191999, 165382, 192133, 192131, 191984, 192129, 191982, 191977, 192127, 192235, 192232, 192070, 192069, 186066, 192066, 192064, 192125, 192062, 189664, 192123, 191344, 192060, 192059, 192121, 143638, 192052, 192117, 191446, 192050, 186065, 192046, 190595, 191960, 192041, 186062, 192039, 186060, 190749, 191585, 191583, 191326, 186055, 186041, 190729, 190339, 190322, 190589, 120059, 190319, 190317, 190315, 190588, 190585, 190313, 190581, 184042, 190362, 190546, 190543, 120057, 187237, 152306, 152305, 152303, 190336, 152301, 184040, 190312, 190334, 190354, 152299, 190310, 189918, 190341, 189856, 190332, 190269, 190267, 190295, 190292, 190290, 190263, 189854, 189916, 189808, 188294, 187923, 188364, 190144, 190090, 184068, 190086, 189928, 184058, 189986, 189984, 189656, 155235, 189847, 189834, 187448, 144159, 183776, 144156, 189677, 189674, 144150, 189669, 144145, 186099, 189652, 188360, 189509, 188582, 117437, 189157, 120053, 160125, 187445, 169853, 187660, 161430, 186900, 188522, 188272, 16531, 183450, 187707, 183447, 188354, 187917, 187706, 120572, 120570, 187234, 185488, 187300, 187230, 187229, 187226, 187225, 182640, 182639, 182635, 187362, 187218, 182631, 187357, 187279, 187244, 144531, 187273, 187336, 187290, 187265, 187262, 182629, 187216, 187215, 187210, 187209, 183773, 187206, 187203, 187096, 187197, 182626, 187188, 187171, 183767, 182614, 186957, 187142, 144526, 184038, 185455, 183760, 184036, 183756, 186039, 185471, 149455, 185469, 185777, 185516, 185514, 185508, 185482, 185529, 185480, 185398, 183196, 183194, 183192, 185427, 185425, 185422, 184121, 149448, 144517, 182115, 185391, 185063, 185086, 185195, 144515, 184033, 185062, 183191, 183189, 144510, 183989, 183187, 183184, 185188, 183182, 165375, 183987, 165373, 183181, 144502, 183177, 183175, 165369, 170296, 183984, 185036, 172930, 183174, 165366, 183514, 185016, 172928, 170249, 185032, 171995, 184357, 184354, 184340, 149443, 184339, 144485, 184222, 183439, 182107, 182106, 182104, 184025, 182090, 182087, 184023, 172927, 184018, 182082, 174896, 172925, 183433, 184014, 172923, 183720, 144468, 184012, 161628, 173945, 161626, 182078, 161624, 183972, 183508, 183557, 183504, 183555, 183671, 183167, 183163, 183162, 183158, 183157, 144461, 183155, 182301, 144459, 183471, 183151, 183272, 172921, 183550, 183501, 183149, 183499, 183497, 183145, 183143, 183373, 183415, 183139, 183137, 182581, 183364, 183134, 182578, 183129, 183362, 183124, 183119, 182570, 181990, 182549, 172941, 172920, 172918, 182597, 182595, 181779, 172916, 181985, 170856, 182546, 182374, 168212, 160117, 144454, 144452, 144450, 144447, 144443, 181323, 181296, 175575, 174964, 170851, 144435, 173556, 175527, 174963, 173554, 181222, 174961, 181208, 175234, 174949, 174742, 159681, 161507, 165521, 165520, 165974, 165973, 165970, 165517, 165515, 165967, 165510, 165961, 165960, 165956, 165953, 165898, 113915, 148279, 148278, 165547, 165872, 165776, 113908, 165626, 165544, 165789, 120979, 165438, 165454, 165696, 165534, 165445, 120977, 165623, 165531, 117392, 117386, 165503, 117383, 163943, 165416, 164839, 164382, 165256, 164380, 165002, 120042, 164820, 163830, 120974, 164512, 164650, 164815, 120037, 164763, 120035, 164510, 164473, 163810, 164498, 163808, 163806, 163417, 150183, 157583, 163415, 162360, 164394, 96154, 150181, 120031, 164384, 120029, 164330, 160851, 163413, 16523, 164290, 163411, 164288, 159405, 164286, 120027, 159403, 150177, 150173, 163733, 120024, 163693, 163690, 163933, 163932, 163930, 154056, 123671, 163688, 163795, 120022, 163792, 163898, 163789, 163764, 163782, 163682, 163681, 163645, 163675, 163622, 163577, 96151, 159401, 159397, 162926, 162924, 162920, 8021, 163334, 163331, 159395, 141667, 159393, 159391, 152297, 162918, 162415, 162938, 162728, 161073, 162915, 162413, 162815, 162410, 162758, 162723, 162808, 162755, 162753, 162717, 156714, 153914, 159615, 162405, 154900, 162296, 142751, 159604, 162099, 160847, 160846, 134505, 159033, 153393, 161601, 162092, 153389, 161591, 134502, 134500, 161581, 141662, 161481, 161499, 161495, 159598, 161296, 161295, 160842, 161068, 161066, 161140, 161064, 161082, 159596, 159595, 141656, 160837, 160835, 161046, 161033, 159053, 161011, 161008, 160981, 142744, 142742, 142739, 159051, 142737, 160825, 120012, 120010, 158516, 120008, 160020, 120004, 159581, 149439, 152636, 149429, 149427, 149426, 159570, 152628, 159566, 159562, 149420, 159557, 157927, 159553, 159550, 159545, 159542, 159534, 158509, 159046, 141654, 120002, 159044, 151065, 120000, 149418, 149416, 158146, 158143, 158141, 158138, 149414, 158135, 158127, 158119, 148272, 149412, 149410, 149407, 151260, 149405, 158196, 157997, 149403, 158182, 157983, 157982, 157979, 157977, 157975, 151064, 149396, 157918, 157828, 149394, 157807, 157795, 149391, 93736, 154551, 149385, 157695, 149383, 155884, 149382, 149380, 149378, 149377, 149375, 149372, 149370, 157527, 149368, 149366, 149364, 156781, 157666, 141340, 157539, 152111, 157512, 157522, 157537, 96135, 156712, 155880, 96133, 149353, 157011, 157010, 157007, 156709, 150863, 156776, 149350, 149348, 156771, 156770, 149345, 156767, 156764, 96126, 156397, 128294, 155869, 149340, 134722, 149338, 156183, 156181, 156177, 149336, 156172, 156165, 96122, 155784, 152295, 152294, 149333, 156107, 149330, 155846, 155844, 155842, 155839, 155781, 154731, 155837, 149326, 96118, 155776, 155772, 153789, 96116, 155770, 155766, 155764, 155755, 149318, 150654, 155753, 96109, 155748, 149316, 154071, 155651, 142729, 150649, 150647, 119992, 150645, 150642, 150640, 150639, 150637, 155560, 150035, 150034, 150031, 119990, 143146, 119986, 154727, 154722, 147129, 152107, 152105, 154065, 149307, 149303, 149302, 154353, 149300, 154349, 149292, 149290, 149287, 154974, 149285, 149282, 149280, 149278, 154346, 154048, 154811, 154650, 154891, 149273, 149272, 149271, 153776, 154647, 154815, 134720, 153126, 134718, 153124, 154525, 154642, 154701, 154343, 149266, 154340, 149260, 149259, 149258, 149257, 154042, 149251, 149250, 154530, 154528, 154325, 154037, 149234, 149233, 149232, 149231, 149230, 149221, 149216, 154088, 149214, 154033, 154032, 149212, 149210, 154316, 154029, 154028, 149208, 152619, 149206, 149203, 149199, 149197, 119981, 148269, 152291, 153886, 152289, 149177, 150821, 153846, 153844, 153842, 153840, 153836, 153769, 152742, 152741, 153609, 152736, 153723, 153742, 153721, 152731, 152730, 147820, 152725, 152724, 152722, 152100, 152720, 153710, 153703, 147817, 152097, 153689, 152615, 152095, 152717, 119977, 153606, 153604, 153229, 152715, 152714, 153499, 152712, 152711, 153568, 152709, 153118, 153116, 152707, 153114, 153493, 153492, 134498, 152705, 152703, 152701, 152698, 152695, 152693, 123186, 152691, 134491, 153372, 153112, 148696, 134485, 153305, 153326, 153278, 153110, 153107, 147861, 153105, 153261, 152688, 152687, 134483, 153228, 152288, 152287, 153183, 152949, 153181, 153179, 152471, 153177, 152286, 152285, 153173, 152685, 153171, 152930, 144406, 152681, 152677, 152278, 152277, 152675, 152274, 152989, 142465, 152041, 151897, 152470, 150804, 151088, 152652, 151762, 152648, 152270, 152268, 152265, 151761, 152607, 150556, 152605, 143145, 152263, 148261, 152261, 139286, 149170, 149169, 151054, 147805, 139284, 147800, 147794, 147790, 139282, 149153, 149151, 149148, 150612, 149142, 149138, 152039, 152038, 149136, 152355, 152034, 100147, 100146, 152032, 149131, 149128, 147787, 149121, 149119, 147785, 152259, 149117, 147782, 152257, 116261, 151327, 147779, 148662, 149111, 152125, 149109, 149107, 149966, 149105, 152023, 152021, 152019, 149100, 96964, 151322, 149092, 149090, 149087, 149084, 151832, 149082, 151350, 149072, 149071, 149069, 149067, 149060, 151453, 119971, 149686, 151345, 119967, 119965, 151446, 148693, 149034, 151185, 151250, 147776, 149018, 148989, 150710, 150947, 148974, 148972, 148970, 150907, 148967, 148966, 148964, 148963, 148959, 148957, 149917, 148955, 148953, 149914, 119947, 149910, 119944, 150854, 150740, 96733, 150762, 150703, 148950, 139277, 150699, 150553, 150692, 148937, 148930, 139275, 148928, 148926, 143139, 147774, 148921, 148920, 150171, 143137, 148917, 150364, 148914, 148912, 148909, 148896, 148894, 148892, 148891, 148888, 148886, 148882, 148881, 148879, 148875, 148874, 148872, 148871, 150025, 148867, 148866, 148863, 148861, 148851, 148848, 148845, 148841, 148838, 148834, 148831, 148829, 149671, 148801, 148799, 149534, 139262, 148795, 148791, 149803, 149526, 149738, 148782, 148781, 149716, 148778, 119924, 139259, 148775, 149514, 148772, 149512, 149655, 149619, 149647, 149616, 148757, 148545, 149501, 148752, 147208, 148724, 148639, 119914, 148577, 148633, 148573, 148566, 148564, 148399, 119909, 119907, 148519, 148517, 143133, 119905, 119904, 119902, 139258, 147536, 147531, 147529, 139256, 148257, 142505, 148413, 145144, 148432, 136800, 136797, 148407, 147525, 148164, 137472, 135083, 148161, 139254, 139253, 147939, 139247, 139246, 139242, 139238, 147520, 139236, 147767, 147515, 148254, 148252, 148251, 148250, 148248, 148244, 148206, 148149, 148147, 148204, 119894, 148143, 148051, 147511, 147761, 147758, 148137, 148202, 143130, 148181, 147895, 147855, 148006, 144759, 147755, 146546, 147852, 147899, 147892, 147897, 119871, 147751, 147550, 142717, 147749, 147747, 147745, 147851, 147499, 147741, 147739, 147736, 147734, 146105, 147732, 146102, 146101, 147496, 147726, 147669, 147724, 134481, 147722, 147317, 147720, 144084, 147681, 146099, 144082, 144080, 147602, 142711, 146093, 146092, 147004, 135078, 147581, 142709, 147579, 135075, 142705, 147024, 142703, 147483, 144369, 146904, 146087, 147428, 147426, 147313, 147307, 146083, 146523, 147095, 147093, 147087, 147114, 146515, 147084, 146621, 147262, 147181, 147256, 147080, 147179, 147079, 147078, 146080, 118035, 146078, 118033, 147220, 118031, 118029, 146073, 146071, 146697, 146695, 146068, 119854, 146838, 145342, 146836, 146835, 145341, 146066, 147071, 146064, 147019, 147016, 146047, 146042, 146033, 146825, 146026, 115549, 146820, 146902, 119852, 146815, 146010, 146006, 146001, 145997, 146810, 145982, 145976, 145974, 145970, 145966, 145965, 145963, 146890, 146802, 145933, 145931, 145924, 146792, 145920, 145918, 145913, 145910, 145907, 145905, 145898, 145890, 145884, 144142, 145879, 126575, 145877, 145876, 145871, 139226, 119839, 146606, 145864, 145605, 115546, 145861, 145859, 145858, 145842, 145834, 146237, 145814, 146578, 145794, 145791, 145785, 145780, 145774, 145773, 146479, 145770, 146474, 145587, 145579, 145765, 145576, 146348, 146347, 145755, 145753, 145752, 145744, 145741, 145736, 145735, 145722, 145712, 145568, 146223, 144138, 144136, 145395, 145102, 145593, 145546, 145543, 145541, 145538, 145537, 145658, 145521, 119806, 119804, 145652, 145516, 121104, 119797, 121101, 121100, 121099, 121097, 119794, 119792, 145129, 145125, 139220, 145381, 139218, 137404, 145300, 145119, 145112, 145110, 119784, 112118, 119781, 112116, 119779, 112114, 119775, 139216, 112112, 145071, 144240, 139208, 144236, 139205, 143985, 144804, 144890, 144887, 144886, 144755, 144753, 144884, 144881, 144860, 144748, 144877, 144746, 144866, 144855, 142463, 144744, 144853, 144594, 144626, 144742, 144741, 144822, 144798, 142461, 144735, 142459, 119759, 143970, 144610, 143968, 144608, 144587, 119756, 134693, 103599, 141751, 103597, 103594, 142452, 119754, 119752, 142450, 142449, 139202, 139201, 139200, 139199, 142446, 144110, 144372, 144286, 119749, 142444, 142443, 144127, 119743, 144100, 144074, 139193, 139191, 139189, 142693, 142047, 142045, 143881, 142031, 139186, 139185, 142028, 143947, 119737, 143940, 144004, 143937, 137720, 137400, 143879, 85530, 137397, 143861, 137719, 142686, 119733, 143113, 142680, 139178, 142673, 139176, 142669, 139174, 143109, 138488, 138486, 142665, 143650, 142661, 142660, 139172, 139171, 143611, 141594, 142647, 141592, 141590, 139168, 139164, 139157, 139156, 139155, 139152, 139150, 139149, 139146, 139145, 139144, 139142, 139140, 142637, 142636, 139135, 139134, 143041, 139132, 142631, 129857, 142628, 141317, 95338, 139129, 141310, 141308, 139125, 139117, 119730, 139113, 139102, 141447, 139090, 141435, 139076, 141428, 139062, 142186, 142184, 142183, 141421, 141420, 141416, 141414, 141412, 139060, 141410, 139059, 141408, 141404, 141403, 141401, 139056, 139051, 139044, 139042, 139041, 137196, 139038, 139036, 119728, 139034, 119726, 139030, 139028, 139026, 141982, 142085, 139011, 119715, 139002, 141388, 138999, 138986, 136538, 141379, 141377, 139851, 126566, 139848, 139847, 139846, 141767, 138979, 138977, 141765, 138974, 138973, 119709, 141818, 139842, 141264, 138956, 138953, 96087, 141771, 119700, 96084, 138938, 139836, 119694, 138935, 119692, 141491, 79888, 138932, 138930, 138926, 119687, 141287, 141466, 138905, 138904, 119681, 141352, 141284, 141350, 141349, 138901, 138899, 119678, 138894, 138893, 138892, 141251, 141249, 141248, 141247, 141246, 138871, 140467, 140466, 140464, 140457, 140456, 140455, 124773, 140564, 140724, 140555, 140444, 140553, 140440, 140243, 140026, 140408, 119670, 140404, 119668, 119667, 140401, 140398, 119665, 140024, 139832, 139829, 119659, 119657, 140199, 139822, 140189, 140197, 119650, 119648, 140124, 140019, 140122, 136507, 140117, 119641, 140091, 140015, 138556, 138826, 119639, 119632, 119630, 138822, 138820, 139813, 138814, 137956, 138805, 138802, 138798, 138795, 139800, 119623, 139798, 139795, 138787, 126241, 126240, 138784, 138782, 138780, 138779, 138775, 135601, 139625, 138770, 124951, 139557, 139634, 124949, 124947, 138766, 138765, 124945, 124943, 138761, 138759, 138748, 138742, 138740, 124939, 124936, 124934, 124933, 138734, 138732, 124930, 124928, 124926, 119618, 124923, 124922, 124921, 124916, 124914, 139315, 134356, 134354, 134352, 134350, 134347, 134344, 134342, 138721, 138719, 138717, 138714, 119610, 138017, 138016, 138006, 138005, 126835, 119608, 119606, 119604, 138214, 138543, 18218, 136464, 18215, 138559, 18213, 138210, 18211, 18204, 119599, 119597, 138329, 138327, 119594, 138535, 119590, 138205, 18197, 127507, 18190, 18186, 138466, 18182, 138200, 138465, 138464, 18180, 18177, 138444, 137380, 119585, 137834, 138124, 138292, 138290, 138287, 138194, 138186, 138336, 138278, 138184, 138101, 138181, 138179, 138175, 138171, 138166, 138095, 138162, 138158, 137377, 18168, 18165, 134339, 137372, 120838, 137370, 134336, 137829, 137818, 137827, 137366, 137772, 134715, 137363, 137942, 137941, 137940, 16507, 137359, 137358, 137791, 137505, 137351, 119582, 134332, 119577, 134330, 126564, 134327, 117035, 126562, 137130, 134316, 136407, 136406, 137260, 137438, 137436, 137446, 133586, 137206, 137330, 136170, 137383, 137327, 137116, 130174, 137114, 137080, 126747, 119576, 134455, 137108, 137077, 119572, 136262, 136260, 134954, 136258, 136256, 129567, 119570, 135534, 136252, 136327, 135531, 119567, 129563, 126730, 126729, 119558, 135517, 136247, 136267, 136243, 126558, 126551, 126549, 126547, 126545, 136162, 126543, 126542, 136156, 135715, 135713, 135711, 135136, 135705, 135704, 129554, 135697, 129550, 129549, 135689, 135684, 126833, 126831, 135368, 133784, 135614, 135510, 126829, 119555, 126827, 126527, 126523, 135198, 126521, 135073, 126519, 134451, 135110, 135108, 135330, 134448, 126504, 135193, 135104, 135061, 135060, 135125, 134308, 135057, 135100, 134445, 135049, 134991, 135021, 134967, 134712, 115331, 135005, 89139, 129521, 129519, 134301, 134707, 134705, 133460, 134703, 134699, 119551, 134221, 134735, 134422, 134531, 134219, 134411, 134401, 134399, 129945, 134216, 125792, 134214, 134289, 134284, 129942, 126492, 129940, 134390, 126489, 126481, 134388, 134210, 129934, 129931, 134207, 126477, 134205, 133571, 126475, 134199, 125788, 133455, 125786, 129929, 125784, 129927, 129920, 129918, 126471, 129915, 125779, 125776, 124042, 129626, 133647, 133665, 119547, 126450, 133566, 133589, 133435, 116004, 128749, 129480, 129478, 133562, 129304, 120828, 133559, 126448, 128746, 133494, 129913, 133432, 126442, 126432, 129175, 133363, 133361, 129466, 129462, 130397, 130348, 129820, 130394, 129909, 124912, 125774, 130201, 128744, 129907, 130151, 130017, 129442, 127023, 129901, 129899, 130194, 130149, 129897, 130179, 129879, 130057, 119544, 119541, 129801, 119539, 126723, 126721, 129956, 129953, 129829, 129799, 129825, 126718, 129796, 129794, 129714, 124909, 126706, 129744, 119511, 96071, 126704, 129675, 129704, 129690, 129709, 129687, 129670, 129162, 125770, 129664, 129588, 125768, 129217, 128733, 129582, 124905, 126824, 126822, 129358, 126820, 119497, 129214, 129301, 116002, 119492, 124769, 119490, 126816, 128709, 129209, 127588, 127587, 129144, 128703, 128419, 128701, 128219, 128699, 127585, 128217, 128215, 124899, 128406, 127582, 127579, 124898, 124896, 119479, 119477, 121552, 123636, 119471, 128450, 127577, 127575, 128154, 127573, 127570, 127567, 128446, 128448, 128413, 128441, 119463, 119458, 125763, 124893, 124891, 128212, 127562, 127561, 127559, 127556, 127554, 127552, 127550, 125751, 127546, 125750, 127544, 128210, 128209, 125669, 128121, 127896, 126407, 119454, 128149, 119451, 127540, 127539, 126404, 127536, 128116, 127534, 119444, 128032, 127383, 119441, 127532, 127531, 125747, 126813, 126400, 125744, 126811, 127529, 127528, 126398, 126396, 119437, 119435, 126393, 126389, 127839, 127757, 124887, 127755, 127524, 127498, 124885, 127186, 126947, 127458, 127523, 127486, 127515, 127521, 127453, 124883, 127450, 127493, 126386, 126808, 126807, 126805, 124881, 124880, 126383, 127447, 124877, 123766, 126801, 123759, 124872, 126798, 126373, 127252, 126372, 127248, 126797, 126646, 127179, 124870, 124867, 126954, 126795, 127173, 126642, 126640, 126370, 126952, 124364, 126793, 120821, 126943, 126940, 124844, 126362, 126856, 126773, 126772, 124842, 126763, 126357, 126694, 126635, 125499, 126343, 126046, 119422, 126338, 126335, 126326, 125328, 125495, 126095, 124826, 124824, 125493, 126092, 124821, 125492, 126063, 126059, 125302, 124817, 124815, 125324, 124812, 125484, 125482, 125656, 125478, 125476, 125475, 125473, 124756, 125471, 125419, 125735, 124747, 125653, 124745, 125650, 125648, 125416, 125562, 119399, 125412, 125557, 125407, 125402, 125400, 125399, 125396, 125332, 125310, 125293, 115998, 119369, 125287, 125012, 124804, 125284, 124738, 124863, 125321, 124736, 125010, 125279, 124802, 125256, 125253, 85301, 125248, 124730, 124861, 124859, 124474, 124539, 124537, 85293, 119357, 85291, 125157, 125003, 112814, 95867, 124799, 124727, 124855, 121197, 124974, 124853, 124725, 119350, 124723, 124795, 124793, 124720, 124719, 85285, 124714, 115920, 124524, 124523, 124442, 124455, 79873, 124461, 121529, 124039, 100549, 124451, 120811, 124448, 117795, 124181, 84367, 124037, 124020, 124015, 124013, 124011, 124007, 124006, 123752, 124002, 124158, 123998, 123993, 121194, 123988, 124116, 123750, 124154, 123746, 124152, 123744, 123986, 123911, 123739, 93302, 123732, 123731, 123726, 123487, 123319, 123307, 119243, 121525, 123281, 119239, 119221, 93298, 120237, 115263, 115260, 122946, 122725, 85693, 116867, 118942, 122734, 115545, 122189, 122187, 122716, 116864, 122184, 121193, 116861, 119178, 122212, 116233, 122180, 116232, 122206, 122203, 122201, 121818, 121184, 118931, 122199, 122156, 121183, 122169, 118925, 115543, 121832, 121826, 121384, 117959, 117957, 121382, 115541, 121627, 121176, 121417, 121456, 121486, 121174, 112772, 121586, 121548, 121484, 117866, 121214, 112769, 121208, 112765, 112763, 121167, 117855, 121132, 121066, 116968, 116966, 120933, 117721, 114330, 118239, 117715, 115539, 117710, 120855, 115537, 120805, 94651, 120083, 118909, 116707, 120078, 117850, 118905, 118903, 118851, 120102, 120100, 115524, 118253, 117847, 98894, 117845, 116702, 117838, 117837, 117703, 116699, 111224, 117700, 117698, 117697, 118701, 118471, 114482, 115518, 115516, 118175, 118167, 116596, 115512, 116592, 116801, 117946, 117940, 117934, 117925, 118025, 117920, 117916, 117070, 117913, 117833, 117818, 117065, 117783, 117063, 117058, 117169, 117044, 116920, 115712, 116849, 112656, 116918, 114463, 113744, 116847, 116830, 115989, 116905, 116902, 116900, 116898, 116818, 116816, 116813, 116560, 116810, 116809, 115982, 115979, 116791, 76967, 116410, 96054, 115456, 115285, 95806, 113652, 81325, 114741, 114682, 114622, 113513, 114276, 109478, 114272, 114270, 114324, 114323, 113498, 114260, 113495, 109471, 72115, 113634, 113629, 97, 113381, 89010, 113470, 113378, 97739, 113332, 102199, 111185, 112677, 112670, 111178, 112668, 111174, 111171, 111168, 112604, 100465, 111891, 112307, 112304, 112302, 112105, 92676, 111889, 109458, 109455, 109450, 16484, 112453, 112413, 112449, 85231, 112158, 85229, 112190, 112099, 101444, 112295, 101442, 112179, 102127, 112211, 101438, 112137, 80425, 111069, 112134, 101434, 97736, 111826, 111824, 92675, 111815, 111813, 111799, 111794, 111721, 111717, 111463, 92672, 111659, 111144, 101426, 111656, 101423, 111613, 101419, 111547, 111536, 101693, 101301, 111452, 80458, 111487, 103021, 111447, 110950, 103018, 111396, 110945, 110943, 111112, 111354, 103016, 111134, 111129, 101206, 101203, 101297, 110874, 110934, 110871, 110794, 102552, 98976, 101189, 102342, 102338, 102335, 100536, 97733, 97731, 101186, 100515, 100488, 100259, 99607, 99582, 97669, 97456, 97711, 91321, 91317, 91315, 99501, 99496, 99305, 99379, 99298, 99367, 99296, 99352, 99292, 99345, 99342, 92670, 99174, 99148, 98694, 99080, 98164, 98161, 95336, 97704, 95995, 98496, 98492, 95993, 98490, 95991, 84544, 98532, 84539, 98525, 98523, 98514, 97101, 98218, 97285, 98215, 95987, 95986, 95977, 98275, 96923, 98213, 98212, 98211, 98210, 98209, 98208, 98207, 90755, 98142, 90753, 95974, 95972, 95967, 95964, 95961, 95958, 95954, 97098, 94977, 88973, 90668, 90666, 97998, 77263, 97773, 77261, 97843, 95421, 97835, 97834, 95419, 97864, 97857, 97764, 97049, 97047, 97537, 97406, 96874, 97532, 97455, 97395, 97410, 97369, 97266, 92669, 97234, 97158, 92667, 97152, 92665, 92664, 92661, 97088, 97030, 96290, 96288, 96286, 96284, 96280, 96276, 96474, 96471, 96466, 96880, 95415, 96862, 90595, 96454, 95327, 96613, 95413, 96421, 96407, 95411, 95082, 93891, 95409, 95407, 95887, 95318, 95898, 95896, 95884, 95881, 95832, 95877, 95308, 95305, 95304, 94634, 81676, 95672, 94867, 91263, 95399, 95398, 95392, 95386, 95384, 95381, 95283, 95251, 81307, 81301, 81299, 95076, 89578, 81296, 95073, 94848, 94838, 94831, 94829, 94817, 94814, 81273, 81268, 85685, 94186, 93946, 94142, 93286, 94032, 94030, 87064, 93938, 93712, 93924, 36716, 93884, 93706, 24113, 93702, 93698, 81262, 81260, 92659, 93685, 81257, 81255, 81250, 93600, 93284, 93281, 91108, 93274, 91091, 93265, 93375, 93420, 91087, 91085, 93416, 89122, 81236, 93174, 92611, 92608, 91048, 91043, 91040, 93124, 93136, 92829, 92715, 92685, 91001, 92581, 90985, 90978, 92556, 92554, 90972, 92503, 90970, 92500, 90030, 90967, 90962, 90959, 90957, 90021, 90955, 91668, 89859, 85209, 92461, 89854, 89845, 90891, 89841, 89839, 89982, 91735, 89828, 89824, 89962, 89960, 89812, 89810, 89946, 90875, 90849, 89894, 89574, 89206, 89267, 89234, 89197, 89111, 74853, 74850, 88984, 88037, 88481, 88475, 87347, 87756, 87417, 87433, 87422, 87420, 87401, 85205, 87263, 85202, 85198, 85196, 85195, 59624, 85187, 85737, 85735, 85732, 84734, 85178, 86425, 85728, 84731, 84729, 86134, 86410, 86166, 73707, 85633, 86027, 85172, 84728, 85813, 85167, 85721, 84727, 85719, 85753, 85752, 85746, 84725, 84724, 84721, 85158, 85355, 84717, 85328, 85148, 84712, 84710, 84707, 84706, 84704, 84697, 84695, 84693, 84690, 84443, 84441, 84688, 84686, 84436, 84430, 82260, 84417, 84598, 84407, 83119, 83116, 83114, 83895, 84034, 84251, 83751, 84270, 84031, 83762, 83703, 83108, 83106, 83101, 83371, 83098, 83096, 83546, 82688, 83415, 83410, 82787, 82929, 83091, 83089, 83088, 83082, 82957, 82996, 82909, 82369, 79744, 77894, 82851, 79737, 81789, 82402, 82363, 82230, 81659, 81642, 81638, 81633, 81621, 81567, 81616, 81718, 72723, 72722, 81607, 81599, 81590, 81494, 81493, 72745, 81204, 81194, 81111, 81137, 58783, 80602, 80717, 80798, 80711, 79720, 77269, 80387, 80334, 80332, 79710, 80326, 80198, 70931, 76710, 80306, 80196, 80224, 80126, 79913, 79912, 70929, 79694, 79682, 70926, 78652, 70924, 79429, 78645, 78642, 78638, 78634, 79178, 78620, 78613, 78612, 77721, 78610, 78606, 78604, 77719, 79017, 78890, 77714, 78861, 78666, 78584, 78582, 78580, 78578, 78577, 78573, 78571, 78451, 78516, 78448, 78512, 78504, 78510, 78509, 78498, 78494, 77786, 78029, 77850, 78122, 78118, 78018, 78266, 77783, 77699, 77778, 76135, 77660, 76953, 76952, 76881, 77253, 75135, 75133, 75129, 75127, 76227, 70415, 72732, 76732, 76716, 76552, 76678, 75126, 76222, 76495, 76528, 76283, 76282, 76208, 68423, 76034, 75942, 75940, 58774, 75771, 75770, 75840, 75853, 75586, 72716, 75306, 75321, 72710, 74917, 74795, 75267, 74717, 75123, 75122, 74405, 74403, 71492, 73971, 72708, 72704, 73459, 73695, 73362, 73682, 73241, 73680, 73240, 73523, 72695, 73237, 72693, 72692, 73232, 73329, 73415, 73369, 73443, 73393, 73397, 73411, 73399, 73133, 64505, 72729, 72727, 72687, 73105, 72916, 72961, 72943, 72684, 72672, 72795, 72794, 71490, 72655, 71489, 72653, 72645, 72644, 72466, 72464, 70413, 67003, 66999, 66998, 71761, 71757, 71935, 71723, 71398, 71397, 71289, 66981, 71108, 71102, 66975, 71099, 71047, 66965, 70968, 67578, 70971, 70768, 70943, 70197, 70195, 70192, 65979, 66953, 67065, 70779, 69977, 70690, 69970, 70634, 66944, 66942, 69966, 70570, 70406, 70393, 70391, 70455, 70389, 70306, 68398, 70142, 57238, 69961, 69337, 64657, 66038, 60889, 69874, 69790, 67688, 69702, 60885, 69472, 69408, 69370, 67682, 67676, 68851, 68850, 69305, 69208, 69207, 67672, 69198, 68621, 68617, 66920, 68847, 66918, 68842, 68203, 69125, 69091, 69028, 69090, 68903, 68807, 68805, 66914, 68803, 66907, 66449, 68188, 68657, 68606, 18067, 18065, 68604, 68543, 68588, 68516, 68514, 66442, 68389, 68386, 68384, 18061, 66433, 66431, 68122, 66422, 68087, 66415, 65944, 67957, 67705, 67962, 67860, 66413, 66412, 67858, 67896, 67741, 67892, 67853, 67850, 67842, 67841, 64820, 64816, 64810, 64807, 66901, 64797, 64792, 64791, 64790, 64788, 64786, 66881, 64782, 64778, 64774, 67306, 67321, 67241, 67240, 67045, 66372, 66026, 66495, 66314, 66311, 66019, 65532, 66012, 66010, 66006, 66005, 66081, 65762, 65985, 65983, 65963, 65950, 65705, 63471, 63469, 64287, 60092, 65267, 60089, 60087, 65190, 61705, 64022, 63817, 64012, 64990, 64988, 64979, 56970, 62943, 63810, 63420, 63052, 63050, 64006, 63049, 62939, 62531, 63621, 39915, 63304, 62934, 63302, 62931, 63298, 59564, 63218, 63592, 63591, 59562, 63294, 63590, 63459, 62928, 63413, 25756, 63457, 63411, 62921, 62919, 61568, 62918, 63450, 57017, 63448, 57008, 57004, 60838, 63409, 62914, 62901, 62897, 62896, 62521, 63205, 62515, 62513, 62892, 62888, 62887, 62885, 62865, 62507, 62707, 62498, 62497, 57465, 62492, 62102, 62699, 62489, 62486, 62478, 62473, 62098, 61626, 62467, 62572, 62463, 62455, 62603, 62452, 62450, 57463, 57453, 62427, 62415, 62302, 62228, 62165, 62226, 62045, 62043, 62052, 61598, 61566, 54792, 62041, 61939, 62027, 61593, 61701, 61591, 61699, 61784, 61643, 61663, 61522, 61689, 61520, 61681, 61518, 61581, 61564, 61576, 60847, 61114, 61111, 61103, 60620, 60618, 60400, 60449, 60447, 58256, 60266, 60052, 59980, 59938, 59934, 59924, 59799, 59798, 59796, 58042, 59578, 59340, 59529, 58980, 58706, 58978, 56513, 58184, 58070, 58249, 58275, 58299, 58247, 58273, 45695, 58063, 58164, 58162, 58159, 57477, 58006, 58055, 58035, 58053, 58051, 58032, 58029, 58027, 58001, 57999, 57955, 57446, 57795, 57866, 57865, 57786, 57618, 57563, 57444, 57439, 50222, 57436, 49973, 50220, 57288, 57726, 57725, 57613, 57722, 57609, 39907, 57678, 57662, 57630, 57433, 57430, 57660, 57561, 57428, 50215, 56392, 57557, 50212, 57426, 57545, 57583, 57422, 57421, 56932, 57415, 57542, 56706, 49963, 57413, 54572, 56609, 49960, 57411, 57165, 57471, 57342, 57409, 57468, 57382, 57163, 49958, 57324, 57338, 57161, 57320, 57333, 57331, 57278, 57191, 57187, 56607, 56982, 57159, 53990, 57183, 57179, 56696, 56966, 56951, 56892, 56682, 56752, 56978, 56887, 56810, 56859, 56410, 56806, 56748, 56743, 56702, 56656, 56639, 56737, 56734, 56654, 56579, 55499))
Run Time: 0.247618
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4484 | |
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 | | | | | 4484 | |
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 (26340, 26339, 26338, 26257, 26242, 26215, 26214, 26159, 12835, 12815, 12781, 12777, 12771, 12749, 12748, 12746, 12745, 12731, 12721, 12717, 12710, 12659, 12658, 12656, 12649, 12647, 12639, 12638, 12624, 12603, 12566, 12498, 12436, 12399, 12398, 12346, 12341, 12331, 12330, 12321, 12299, 12297, 12289, 12288, 12280, 12271, 12269, 12215, 12197, 12184, 12114, 12047, 12038, 12028, 12010, 11975, 11969, 11888, 11887, 11873, 11818, 11817, 11741, 11719, 11709, 10975, 10968, 10964, 10928, 10923, 10868, 10832, 10798, 10795, 10794, 10783, 10759, 10728, 10687, 10662, 10652, 10610, 10524, 10515, 10511, 10500, 10496, 10448, 10411, 10376, 10374, 10343, 10280, 10213, 10206, 10175, 10167, 10158, 10137, 10136, 10132, 10129, 10113, 10107, 10085, 10083, 10077, 10020, 10009, 9988, 9952, 9941, 9929, 9910, 9909, 9879, 9866, 9865, 9836, 9826, 9777, 9758, 9735, 9719, 9704, 9690, 9686, 9676, 9661, 9659, 9632, 9621, 9607, 9604, 9595, 9582, 9545, 9502, 9484, 9452, 9442, 9415, 9414, 9410, 9409, 9405, 9386, 9379, 9377, 9373, 9371, 9365, 9362, 9327, 9313, 9307, 9281, 9245, 9219, 9197, 9177, 9162, 9159, 9138, 9132, 9129, 9087, 9080, 8953, 8936, 8934, 8896, 8823, 8771, 8743, 8742, 8651, 8630, 8505, 8495, 8485, 8484, 8468, 8450, 8440, 8438, 8376, 8210, 8201, 8195, 8189, 8170, 8141, 8125, 8108, 8105, 8084, 8049, 8042, 8021, 7977, 7971, 7894, 7889, 7882, 7877, 7861, 7837, 7829, 7828, 7800, 7796, 7787, 7770, 7758, 7732, 7701, 7680, 7661, 7593, 7592, 7496, 7495, 7476, 7460, 7450, 7423, 7420, 7394, 7393, 7358, 7330, 7324, 7215, 7207, 7206, 7200, 7186, 7141, 7128, 7122, 7112, 7111, 7109, 7100, 7088, 7072, 7051, 7026, 7022, 7015, 7005, 7002, 7000, 6958, 6944, 6943, 6940, 6912, 6905, 6885, 6883, 6881, 6880, 6857, 6855, 6843, 6842, 6840, 6801, 6798, 6790, 6776, 6759, 6745, 6736, 6721, 6678, 6677, 6676, 6652, 6629, 6628, 6624, 6612, 6600, 6597, 6453, 6448, 6438, 6429, 6428, 6420, 6396, 6395, 6379, 6373, 6365, 6334, 6270, 6261, 6259, 6241, 6218, 6214, 6183, 6090, 6066, 6064, 6059, 5959, 5956, 5895, 5792, 5741, 5684, 5668, 5631, 5602, 5538, 5537, 5393, 5375, 5352, 5269, 5230, 5153, 5147, 5145, 5140))
Run Time: 0.018520
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 330 | 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 (513372, 513371, 513366, 513363, 513362, 513358, 513183, 513182, 513181, 513176, 513353, 513060, 323978, 513349, 513348, 513345, 511874, 513155, 511872, 511870, 513153, 513151, 511868, 513194, 512661, 511866, 348087, 348084, 511864, 512658, 512657, 511860, 511856, 511855, 348079, 348078, 512133, 495649, 397262, 484494, 323973, 387482, 387481, 511502, 511501, 495570, 501760, 269945, 502242, 494011, 494010, 510919, 510509, 494007, 348075, 509020, 250267, 250251, 250245, 253102, 250236, 250235, 250231, 250220, 250215, 250213, 250212, 250207, 250203, 250193, 250190, 250177, 250567, 250566, 249959, 253105, 250563, 250175, 251055, 250158, 251053, 247508, 250153, 252978, 250989, 251051, 204286, 250557, 251048, 250555, 251046, 252976, 250138, 252953, 250134, 250132, 250130, 252949, 250126, 250111, 250108, 250103, 250101, 203012, 250095, 250974, 250076, 250067, 143234, 250061, 250789, 248346, 250377, 250540, 250056, 203007, 250652, 250649, 204282, 203003, 250441, 250440, 249938, 250451, 250450, 203002, 249899, 250435, 250432, 249898, 249897, 250407, 250406, 202997, 250394, 247507, 250392, 250044, 204276, 192805, 204274, 249881, 249980, 249951, 249931, 249928, 249877, 193663, 193661, 248081, 152329, 192803, 248344, 248342, 248341, 152327, 249491, 247735, 248926, 248923, 248921, 249448, 249487, 248917, 249483, 249482, 248998, 249457, 249478, 249455, 249476, 248904, 204271, 249290, 117506, 163607, 248996, 249242, 117503, 204267, 36847, 249078, 204260, 249063, 204256, 248956, 248955, 204254, 204252, 36838, 204244, 247859, 248782, 36835, 204240, 248781, 248931, 204236, 248929, 248339, 248884, 204235, 204234, 204231, 191213, 191212, 247734, 193755, 248778, 204229, 248775, 248792, 204224, 143233, 248768, 248766, 248762, 204217, 202995, 202992, 222617, 204215, 247505, 204214, 204211, 248300, 247846, 247844, 248295, 248525, 222611, 222315, 207240, 222609, 248336, 163601, 247839, 247838, 247835, 247828, 248117, 247825, 142923, 248085, 247817, 192802, 142921, 247908, 247903, 247721, 192800, 247814, 247813, 247805, 208273, 247689, 222689, 207298, 222687, 247714, 222685, 194411, 208178, 247684, 222683, 208327, 192798, 192796, 192795, 142917, 142915, 192794, 143227, 208504, 208502, 142911, 142908, 247370, 247502, 247500, 247495, 222529, 247493, 172018, 247490, 142906, 142905, 172014, 247458, 208498, 247301, 222543, 247299, 222672, 201485, 208093, 194409, 152322, 152320, 152318, 152317, 222222, 222526, 202989, 208177, 222583, 172004, 222581, 194402, 208176, 222667, 222645, 222643, 143214, 222247, 194400, 222522, 222518, 222515, 222491, 222537, 222496, 222535, 143210, 222546, 222513, 222482, 208123, 222242, 222240, 222264, 222310, 208484, 222278, 208480, 222261, 222235, 171346, 222269, 222259, 171344, 152311, 142893, 142891, 142890, 222116, 142887, 222114, 142885, 222110, 222109, 222107, 222104, 222102, 171335, 207905, 222058, 208362, 207963, 207961, 208563, 208163, 208517, 208516, 208513, 208452, 208534, 208161, 208283, 18261, 208308, 208354, 208348, 208346, 207959, 208339, 207119, 163600, 208152, 208193, 208191, 142875, 208186, 208184, 208147, 117488, 208145, 163595, 202433, 163593, 208142, 208140, 163590, 208139, 208138, 202430, 208026, 208109, 208024, 208134, 208089, 207465, 208021, 208087, 208019, 208016, 206565, 117485, 117483, 171998, 36831, 207442, 171333, 207974, 207929, 171331, 171329, 207972, 207950, 207946, 117481, 207891, 207920, 207918, 207726, 207708, 207879, 207870, 206560, 204760, 204757, 202987, 207867, 207722, 207615, 206553, 206452, 142866, 206548, 142863, 203922, 207108, 206542, 202984, 202982, 194838, 203920, 202981, 202978, 207192, 184636, 207010, 204584, 202972, 202969, 207002, 117478, 202967, 202966, 117476, 206918, 117475, 117473, 117472, 206846, 165402, 206835, 206449, 206829, 206828, 127055, 204750, 193480, 193479, 202963, 193477, 206775, 181645, 206752, 204582, 206766, 204579, 206443, 206441, 206744, 171323, 206739, 202961, 204779, 206529, 206242, 206240, 201515, 201513, 127044, 206438, 204771, 202956, 206435, 16554, 16551, 192793, 204825, 204823, 204814, 204745, 204743, 204569, 16540, 204044, 203916, 203912, 203910, 16536, 203907, 204198, 201796, 201918, 204196, 204566, 204347, 204560, 204342, 204341, 204337, 204334, 204332, 204329, 203777, 202936, 165397, 203900, 203775, 203774, 203897, 203766, 203893, 203764, 203890, 203762, 203761, 203887, 203883, 203584, 203936, 203934, 203879, 203872, 203867, 203866, 203864, 203861, 203757, 203747, 203745, 203737, 202486, 203453, 202485, 203450, 203446, 203440, 203436, 203432, 203429, 203424, 203422, 202474, 202040, 202913, 202808, 202886, 202880, 202782, 202778, 167083, 202728, 202754, 202726, 202912, 202875, 202775, 202272, 202773, 190605, 202266, 190603, 184775, 202264, 202259, 202255, 202254, 202908, 194341, 120075, 120073, 202244, 202240, 202239, 202237, 120071, 193660, 202232, 184767, 202804, 202815, 202752, 202719, 202736, 190600, 183197, 202667, 202703, 190023, 194796, 202464, 202381, 202451, 160135, 167081, 202340, 195134, 167078, 202383, 202335, 202190, 202329, 201916, 163587, 163585, 163584, 202064, 202026, 202052, 202058, 202057, 202001, 190014, 190011, 201986, 201787, 96766, 201976, 193295, 96762, 201971, 201785, 201822, 201761, 201883, 201951, 165393, 191086, 201709, 173394, 201777, 201775, 201706, 201703, 201478, 201701, 163583, 163582, 201699, 201826, 96758, 120748, 201801, 192333, 201741, 120746, 201695, 201693, 201738, 201691, 120743, 201769, 201543, 201686, 201541, 190934, 173508, 120711, 195245, 193747, 120708, 201352, 192626, 192622, 192621, 120703, 193744, 117467, 195044, 194729, 195043, 193738, 193727, 120692, 193725, 195196, 193719, 190599, 190597, 190596, 120673, 193707, 193706, 193705, 120671, 120070, 193702, 195191, 195189, 191367, 143197, 191364, 191361, 191359, 194823, 120650, 120647, 120645, 194821, 193963, 120643, 194717, 195055, 120639, 142842, 120637, 195051, 187249, 194755, 142839, 183529, 195011, 193955, 194979, 193953, 193951, 194977, 193946, 193943, 193941, 192792, 193939, 194932, 194969, 194023, 152308, 183525, 18258, 18257, 192822, 194913, 193437, 193286, 191498, 193284, 194876, 142835, 193937, 193935, 193932, 193930, 194171, 193699, 193689, 193825, 193235, 193927, 193233, 193823, 193685, 194281, 193683, 193926, 194138, 193280, 96756, 194084, 194157, 193920, 193918, 193681, 193807, 193853, 190802, 193915, 194133, 193679, 193805, 193804, 194130, 193913, 160662, 185501, 190616, 192790, 193657, 193852, 193677, 194030, 194012, 194016, 192382, 117458, 193873, 193904, 193655, 184101, 169723, 193621, 160658, 193650, 193648, 160656, 160654, 193409, 184090, 185497, 190612, 193099, 184088, 192876, 192239, 192900, 193067, 165390, 193090, 165388, 192929, 192784, 192927, 192782, 192911, 192780, 192908, 192894, 192906, 192872, 192778, 192145, 165386, 192776, 142813, 192523, 143172, 192723, 192013, 192718, 192009, 192005, 165384, 192520, 192003, 190101, 189934, 192637, 186069, 192001, 192000, 191999, 165382, 192133, 192131, 191984, 192129, 191982, 191977, 192127, 192235, 192232, 192070, 192069, 186066, 192066, 192064, 192125, 192062, 189664, 192123, 191344, 192060, 192059, 192121, 143638, 192052, 192117, 191446, 192050, 186065, 192046, 190595, 191960, 192041, 186062, 192039, 186060, 190749, 191585, 191583, 191326, 186055, 186041, 190729, 190339, 190322, 190589, 120059, 190319, 190317, 190315, 190588, 190585, 190313, 190581, 184042, 190362, 190546, 190543, 120057, 187237, 152306, 152305, 152303, 190336, 152301, 184040, 190312, 190334, 190354, 152299, 190310, 189918, 190341, 189856, 190332, 190269, 190267, 190295, 190292, 190290, 190263, 189854, 189916, 189808, 188294, 187923, 188364, 190144, 190090, 184068, 190086, 189928, 184058, 189986, 189984, 189656, 155235, 189847, 189834, 187448, 144159, 183776, 144156, 189677, 189674, 144150, 189669, 144145, 186099, 189652, 188360, 189509, 188582, 117437, 189157, 120053, 160125, 187445, 169853, 187660, 161430, 186900, 188522, 188272, 16531, 183450, 187707, 183447, 188354, 187917, 187706, 120572, 120570, 187234, 185488, 187300, 187230, 187229, 187226, 187225, 182640, 182639, 182635, 187362, 187218, 182631, 187357, 187279, 187244, 144531, 187273, 187336, 187290, 187265, 187262, 182629, 187216, 187215, 187210, 187209, 183773, 187206, 187203, 187096, 187197, 182626, 187188, 187171, 183767, 182614, 186957, 187142, 144526, 184038, 185455, 183760, 184036, 183756, 186039, 185471, 149455, 185469, 185777, 185516, 185514, 185508, 185482, 185529, 185480, 185398, 183196, 183194, 183192, 185427, 185425, 185422, 184121, 149448, 144517, 182115, 185391, 185063, 185086, 185195, 144515, 184033, 185062, 183191, 183189, 144510, 183989, 183187, 183184, 185188, 183182, 165375, 183987, 165373, 183181, 144502, 183177, 183175, 165369, 170296, 183984, 185036, 172930, 183174, 165366, 183514, 185016, 172928, 170249, 185032, 171995, 184357, 184354, 184340, 149443, 184339, 144485, 184222, 183439, 182107, 182106, 182104, 184025, 182090, 182087, 184023, 172927, 184018, 182082, 174896, 172925, 183433, 184014, 172923, 183720, 144468, 184012, 161628, 173945, 161626, 182078, 161624, 183972, 183508, 183557, 183504, 183555, 183671, 183167, 183163, 183162, 183158, 183157, 144461, 183155, 182301, 144459, 183471, 183151, 183272, 172921, 183550, 183501, 183149, 183499, 183497, 183145, 183143, 183373, 183415, 183139, 183137, 182581, 183364, 183134, 182578, 183129, 183362, 183124, 183119, 182570, 181990, 182549, 172941, 172920, 172918, 182597, 182595, 181779, 172916, 181985, 170856, 182546, 182374, 168212, 160117, 144454, 144452, 144450, 144447, 144443, 181323, 181296, 175575, 174964, 170851, 144435, 173556, 175527, 174963, 173554, 181222, 174961, 181208, 175234, 174949, 174742, 159681, 161507, 165521, 165520, 165974, 165973, 165970, 165517, 165515, 165967, 165510, 165961, 165960, 165956, 165953, 165898, 113915, 148279, 148278, 165547, 165872, 165776, 113908, 165626, 165544, 165789, 120979, 165438, 165454, 165696, 165534, 165445, 120977, 165623, 165531, 117392, 117386, 165503, 117383, 163943, 165416, 164839, 164382, 165256, 164380, 165002, 120042, 164820, 163830, 120974, 164512, 164650, 164815, 120037, 164763, 120035, 164510, 164473, 163810, 164498, 163808, 163806, 163417, 150183, 157583, 163415, 162360, 164394, 96154, 150181, 120031, 164384, 120029, 164330, 160851, 163413, 16523, 164290, 163411, 164288, 159405, 164286, 120027, 159403, 150177, 150173, 163733, 120024, 163693, 163690, 163933, 163932, 163930, 154056, 123671, 163688, 163795, 120022, 163792, 163898, 163789, 163764, 163782, 163682, 163681, 163645, 163675, 163622, 163577, 96151, 159401, 159397, 162926, 162924, 162920, 8021, 163334, 163331, 159395, 141667, 159393, 159391, 152297, 162918, 162415, 162938, 162728, 161073, 162915, 162413, 162815, 162410, 162758, 162723, 162808, 162755, 162753, 162717, 156714, 153914, 159615, 162405, 154900, 162296, 142751, 159604, 162099, 160847, 160846, 134505, 159033, 153393, 161601, 162092, 153389, 161591, 134502, 134500, 161581, 141662, 161481, 161499, 161495, 159598, 161296, 161295, 160842, 161068, 161066, 161140, 161064, 161082, 159596, 159595, 141656, 160837, 160835, 161046, 161033, 159053, 161011, 161008, 160981, 142744, 142742, 142739, 159051, 142737, 160825, 120012, 120010, 158516, 120008, 160020, 120004, 159581, 149439, 152636, 149429, 149427, 149426, 159570, 152628, 159566, 159562, 149420, 159557, 157927, 159553, 159550, 159545, 159542, 159534, 158509, 159046, 141654, 120002, 159044, 151065, 120000, 149418, 149416, 158146, 158143, 158141, 158138, 149414, 158135, 158127, 158119, 148272, 149412, 149410, 149407, 151260, 149405, 158196, 157997, 149403, 158182, 157983, 157982, 157979, 157977, 157975, 151064, 149396, 157918, 157828, 149394, 157807, 157795, 149391, 93736, 154551, 149385, 157695, 149383, 155884, 149382, 149380, 149378, 149377, 149375, 149372, 149370, 157527, 149368, 149366, 149364, 156781, 157666, 141340, 157539, 152111, 157512, 157522, 157537, 96135, 156712, 155880, 96133, 149353, 157011, 157010, 157007, 156709, 150863, 156776, 149350, 149348, 156771, 156770, 149345, 156767, 156764, 96126, 156397, 128294, 155869, 149340, 134722, 149338, 156183, 156181, 156177, 149336, 156172, 156165, 96122, 155784, 152295, 152294, 149333, 156107, 149330, 155846, 155844, 155842, 155839, 155781, 154731, 155837, 149326, 96118, 155776, 155772, 153789, 96116, 155770, 155766, 155764, 155755, 149318, 150654, 155753, 96109, 155748, 149316, 154071, 155651, 142729, 150649, 150647, 119992, 150645, 150642, 150640, 150639, 150637, 155560, 150035, 150034, 150031, 119990, 143146, 119986, 154727, 154722, 147129, 152107, 152105, 154065, 149307, 149303, 149302, 154353, 149300, 154349, 149292, 149290, 149287, 154974, 149285, 149282, 149280, 149278, 154346, 154048, 154811, 154650, 154891, 149273, 149272, 149271, 153776, 154647, 154815, 134720, 153126, 134718, 153124, 154525, 154642, 154701, 154343, 149266, 154340, 149260, 149259, 149258, 149257, 154042, 149251, 149250, 154530, 154528, 154325, 154037, 149234, 149233, 149232, 149231, 149230, 149221, 149216, 154088, 149214, 154033, 154032, 149212, 149210, 154316, 154029, 154028, 149208, 152619, 149206, 149203, 149199, 149197, 119981, 148269, 152291, 153886, 152289, 149177, 150821, 153846, 153844, 153842, 153840, 153836, 153769, 152742, 152741, 153609, 152736, 153723, 153742, 153721, 152731, 152730, 147820, 152725, 152724, 152722, 152100, 152720, 153710, 153703, 147817, 152097, 153689, 152615, 152095, 152717, 119977, 153606, 153604, 153229, 152715, 152714, 153499, 152712, 152711, 153568, 152709, 153118, 153116, 152707, 153114, 153493, 153492, 134498, 152705, 152703, 152701, 152698, 152695, 152693, 123186, 152691, 134491, 153372, 153112, 148696, 134485, 153305, 153326, 153278, 153110, 153107, 147861, 153105, 153261, 152688, 152687, 134483, 153228, 152288, 152287, 153183, 152949, 153181, 153179, 152471, 153177, 152286, 152285, 153173, 152685, 153171, 152930, 144406, 152681, 152677, 152278, 152277, 152675, 152274, 152989, 142465, 152041, 151897, 152470, 150804, 151088, 152652, 151762, 152648, 152270, 152268, 152265, 151761, 152607, 150556, 152605, 143145, 152263, 148261, 152261, 139286, 149170, 149169, 151054, 147805, 139284, 147800, 147794, 147790, 139282, 149153, 149151, 149148, 150612, 149142, 149138, 152039, 152038, 149136, 152355, 152034, 100147, 100146, 152032, 149131, 149128, 147787, 149121, 149119, 147785, 152259, 149117, 147782, 152257, 116261, 151327, 147779, 148662, 149111, 152125, 149109, 149107, 149966, 149105, 152023, 152021, 152019, 149100, 96964, 151322, 149092, 149090, 149087, 149084, 151832, 149082, 151350, 149072, 149071, 149069, 149067, 149060, 151453, 119971, 149686, 151345, 119967, 119965, 151446, 148693, 149034, 151185, 151250, 147776, 149018, 148989, 150710, 150947, 148974, 148972, 148970, 150907, 148967, 148966, 148964, 148963, 148959, 148957, 149917, 148955, 148953, 149914, 119947, 149910, 119944, 150854, 150740, 96733, 150762, 150703, 148950, 139277, 150699, 150553, 150692, 148937, 148930, 139275, 148928, 148926, 143139, 147774, 148921, 148920, 150171, 143137, 148917, 150364, 148914, 148912, 148909, 148896, 148894, 148892, 148891, 148888, 148886, 148882, 148881, 148879, 148875, 148874, 148872, 148871, 150025, 148867, 148866, 148863, 148861, 148851, 148848, 148845, 148841, 148838, 148834, 148831, 148829, 149671, 148801, 148799, 149534, 139262, 148795, 148791, 149803, 149526, 149738, 148782, 148781, 149716, 148778, 119924, 139259, 148775, 149514, 148772, 149512, 149655, 149619, 149647, 149616, 148757, 148545, 149501, 148752, 147208, 148724, 148639, 119914, 148577, 148633, 148573, 148566, 148564, 148399, 119909, 119907, 148519, 148517, 143133, 119905, 119904, 119902, 139258, 147536, 147531, 147529, 139256, 148257, 142505, 148413, 145144, 148432, 136800, 136797, 148407, 147525, 148164, 137472, 135083, 148161, 139254, 139253, 147939, 139247, 139246, 139242, 139238, 147520, 139236, 147767, 147515, 148254, 148252, 148251, 148250, 148248, 148244, 148206, 148149, 148147, 148204, 119894, 148143, 148051, 147511, 147761, 147758, 148137, 148202, 143130, 148181, 147895, 147855, 148006, 144759, 147755, 146546, 147852, 147899, 147892, 147897, 119871, 147751, 147550, 142717, 147749, 147747, 147745, 147851, 147499, 147741, 147739, 147736, 147734, 146105, 147732, 146102, 146101, 147496, 147726, 147669, 147724, 134481, 147722, 147317, 147720, 144084, 147681, 146099, 144082, 144080, 147602, 142711, 146093, 146092, 147004, 135078, 147581, 142709, 147579, 135075, 142705, 147024, 142703, 147483, 144369, 146904, 146087, 147428, 147426, 147313, 147307, 146083, 146523, 147095, 147093, 147087, 147114, 146515, 147084, 146621, 147262, 147181, 147256, 147080, 147179, 147079, 147078, 146080, 118035, 146078, 118033, 147220, 118031, 118029, 146073, 146071, 146697, 146695, 146068, 119854, 146838, 145342, 146836, 146835, 145341, 146066, 147071, 146064, 147019, 147016, 146047, 146042, 146033, 146825, 146026, 115549, 146820, 146902, 119852, 146815, 146010, 146006, 146001, 145997, 146810, 145982, 145976, 145974, 145970, 145966, 145965, 145963, 146890, 146802, 145933, 145931, 145924, 146792, 145920, 145918, 145913, 145910, 145907, 145905, 145898, 145890, 145884, 144142, 145879, 126575, 145877, 145876, 145871, 139226, 119839, 146606, 145864, 145605, 115546, 145861, 145859, 145858, 145842, 145834, 146237, 145814, 146578, 145794, 145791, 145785, 145780, 145774, 145773, 146479, 145770, 146474, 145587, 145579, 145765, 145576, 146348, 146347, 145755, 145753, 145752, 145744, 145741, 145736, 145735, 145722, 145712, 145568, 146223, 144138, 144136, 145395, 145102, 145593, 145546, 145543, 145541, 145538, 145537, 145658, 145521, 119806, 119804, 145652, 145516, 121104, 119797, 121101, 121100, 121099, 121097, 119794, 119792, 145129, 145125, 139220, 145381, 139218, 137404, 145300, 145119, 145112, 145110, 119784, 112118, 119781, 112116, 119779, 112114, 119775, 139216, 112112, 145071, 144240, 139208, 144236, 139205, 143985, 144804, 144890, 144887, 144886, 144755, 144753, 144884, 144881, 144860, 144748, 144877, 144746, 144866, 144855, 142463, 144744, 144853, 144594, 144626, 144742, 144741, 144822, 144798, 142461, 144735, 142459, 119759, 143970, 144610, 143968, 144608, 144587, 119756, 134693, 103599, 141751, 103597, 103594, 142452, 119754, 119752, 142450, 142449, 139202, 139201, 139200, 139199, 142446, 144110, 144372, 144286, 119749, 142444, 142443, 144127, 119743, 144100, 144074, 139193, 139191, 139189, 142693, 142047, 142045, 143881, 142031, 139186, 139185, 142028, 143947, 119737, 143940, 144004, 143937, 137720, 137400, 143879, 85530, 137397, 143861, 137719, 142686, 119733, 143113, 142680, 139178, 142673, 139176, 142669, 139174, 143109, 138488, 138486, 142665, 143650, 142661, 142660, 139172, 139171, 143611, 141594, 142647, 141592, 141590, 139168, 139164, 139157, 139156, 139155, 139152, 139150, 139149, 139146, 139145, 139144, 139142, 139140, 142637, 142636, 139135, 139134, 143041, 139132, 142631, 129857, 142628, 141317, 95338, 139129, 141310, 141308, 139125, 139117, 119730, 139113, 139102, 141447, 139090, 141435, 139076, 141428, 139062, 142186, 142184, 142183, 141421, 141420, 141416, 141414, 141412, 139060, 141410, 139059, 141408, 141404, 141403, 141401, 139056, 139051, 139044, 139042, 139041, 137196, 139038, 139036, 119728, 139034, 119726, 139030, 139028, 139026, 141982, 142085, 139011, 119715, 139002, 141388, 138999, 138986, 136538, 141379, 141377, 139851, 126566, 139848, 139847, 139846, 141767, 138979, 138977, 141765, 138974, 138973, 119709, 141818, 139842, 141264, 138956, 138953, 96087, 141771, 119700, 96084, 138938, 139836, 119694, 138935, 119692, 141491, 79888, 138932, 138930, 138926, 119687, 141287, 141466, 138905, 138904, 119681, 141352, 141284, 141350, 141349, 138901, 138899, 119678, 138894, 138893, 138892, 141251, 141249, 141248, 141247, 141246, 138871, 140467, 140466, 140464, 140457, 140456, 140455, 124773, 140564, 140724, 140555, 140444, 140553, 140440, 140243, 140026, 140408, 119670, 140404, 119668, 119667, 140401, 140398, 119665, 140024, 139832, 139829, 119659, 119657, 140199, 139822, 140189, 140197, 119650, 119648, 140124, 140019, 140122, 136507, 140117, 119641, 140091, 140015, 138556, 138826, 119639, 119632, 119630, 138822, 138820, 139813, 138814, 137956, 138805, 138802, 138798, 138795, 139800, 119623, 139798, 139795, 138787, 126241, 126240, 138784, 138782, 138780, 138779, 138775, 135601, 139625, 138770, 124951, 139557, 139634, 124949, 124947, 138766, 138765, 124945, 124943, 138761, 138759, 138748, 138742, 138740, 124939, 124936, 124934, 124933, 138734, 138732, 124930, 124928, 124926, 119618, 124923, 124922, 124921, 124916, 124914, 139315, 134356, 134354, 134352, 134350, 134347, 134344, 134342, 138721, 138719, 138717, 138714, 119610, 138017, 138016, 138006, 138005, 126835, 119608, 119606, 119604, 138214, 138543, 18218, 136464, 18215, 138559, 18213, 138210, 18211, 18204, 119599, 119597, 138329, 138327, 119594, 138535, 119590, 138205, 18197, 127507, 18190, 18186, 138466, 18182, 138200, 138465, 138464, 18180, 18177, 138444, 137380, 119585, 137834, 138124, 138292, 138290, 138287, 138194, 138186, 138336, 138278, 138184, 138101, 138181, 138179, 138175, 138171, 138166, 138095, 138162, 138158, 137377, 18168, 18165, 134339, 137372, 120838, 137370, 134336, 137829, 137818, 137827, 137366, 137772, 134715, 137363, 137942, 137941, 137940, 16507, 137359, 137358, 137791, 137505, 137351, 119582, 134332, 119577, 134330, 126564, 134327, 117035, 126562, 137130, 134316, 136407, 136406, 137260, 137438, 137436, 137446, 133586, 137206, 137330, 136170, 137383, 137327, 137116, 130174, 137114, 137080, 126747, 119576, 134455, 137108, 137077, 119572, 136262, 136260, 134954, 136258, 136256, 129567, 119570, 135534, 136252, 136327, 135531, 119567, 129563, 126730, 126729, 119558, 135517, 136247, 136267, 136243, 126558, 126551, 126549, 126547, 126545, 136162, 126543, 126542, 136156, 135715, 135713, 135711, 135136, 135705, 135704, 129554, 135697, 129550, 129549, 135689, 135684, 126833, 126831, 135368, 133784, 135614, 135510, 126829, 119555, 126827, 126527, 126523, 135198, 126521, 135073, 126519, 134451, 135110, 135108, 135330, 134448, 126504, 135193, 135104, 135061, 135060, 135125, 134308, 135057, 135100, 134445, 135049, 134991, 135021, 134967, 134712, 115331, 135005, 89139, 129521, 129519, 134301, 134707, 134705, 133460, 134703, 134699, 119551, 134221, 134735, 134422, 134531, 134219, 134411, 134401, 134399, 129945, 134216, 125792, 134214, 134289, 134284, 129942, 126492, 129940, 134390, 126489, 126481, 134388, 134210, 129934, 129931, 134207, 126477, 134205, 133571, 126475, 134199, 125788, 133455, 125786, 129929, 125784, 129927, 129920, 129918, 126471, 129915, 125779, 125776, 124042, 129626, 133647, 133665, 119547, 126450, 133566, 133589, 133435, 116004, 128749, 129480, 129478, 133562, 129304, 120828, 133559, 126448, 128746, 133494, 129913, 133432, 126442, 126432, 129175, 133363, 133361, 129466, 129462, 130397, 130348, 129820, 130394, 129909, 124912, 125774, 130201, 128744, 129907, 130151, 130017, 129442, 127023, 129901, 129899, 130194, 130149, 129897, 130179, 129879, 130057, 119544, 119541, 129801, 119539, 126723, 126721, 129956, 129953, 129829, 129799, 129825, 126718, 129796, 129794, 129714, 124909, 126706, 129744, 119511, 96071, 126704, 129675, 129704, 129690, 129709, 129687, 129670, 129162, 125770, 129664, 129588, 125768, 129217, 128733, 129582, 124905, 126824, 126822, 129358, 126820, 119497, 129214, 129301, 116002, 119492, 124769, 119490, 126816, 128709, 129209, 127588, 127587, 129144, 128703, 128419, 128701, 128219, 128699, 127585, 128217, 128215, 124899, 128406, 127582, 127579, 124898, 124896, 119479, 119477, 121552, 123636, 119471, 128450, 127577, 127575, 128154, 127573, 127570, 127567, 128446, 128448, 128413, 128441, 119463, 119458, 125763, 124893, 124891, 128212, 127562, 127561, 127559, 127556, 127554, 127552, 127550, 125751, 127546, 125750, 127544, 128210, 128209, 125669, 128121, 127896, 126407, 119454, 128149, 119451, 127540, 127539, 126404, 127536, 128116, 127534, 119444, 128032, 127383, 119441, 127532, 127531, 125747, 126813, 126400, 125744, 126811, 127529, 127528, 126398, 126396, 119437, 119435, 126393, 126389, 127839, 127757, 124887, 127755, 127524, 127498, 124885, 127186, 126947, 127458, 127523, 127486, 127515, 127521, 127453, 124883, 127450, 127493, 126386, 126808, 126807, 126805, 124881, 124880, 126383, 127447, 124877, 123766, 126801, 123759, 124872, 126798, 126373, 127252, 126372, 127248, 126797, 126646, 127179, 124870, 124867, 126954, 126795, 127173, 126642, 126640, 126370, 126952, 124364, 126793, 120821, 126943, 126940, 124844, 126362, 126856, 126773, 126772, 124842, 126763, 126357, 126694, 126635, 125499, 126343, 126046, 119422, 126338, 126335, 126326, 125328, 125495, 126095, 124826, 124824, 125493, 126092, 124821, 125492, 126063, 126059, 125302, 124817, 124815, 125324, 124812, 125484, 125482, 125656, 125478, 125476, 125475, 125473, 124756, 125471, 125419, 125735, 124747, 125653, 124745, 125650, 125648, 125416, 125562, 119399, 125412, 125557, 125407, 125402, 125400, 125399, 125396, 125332, 125310, 125293, 115998, 119369, 125287, 125012, 124804, 125284, 124738, 124863, 125321, 124736, 125010, 125279, 124802, 125256, 125253, 85301, 125248, 124730, 124861, 124859, 124474, 124539, 124537, 85293, 119357, 85291, 125157, 125003, 112814, 95867, 124799, 124727, 124855, 121197, 124974, 124853, 124725, 119350, 124723, 124795, 124793, 124720, 124719, 85285, 124714, 115920, 124524, 124523, 124442, 124455, 79873, 124461, 121529, 124039, 100549, 124451, 120811, 124448, 117795, 124181, 84367, 124037, 124020, 124015, 124013, 124011, 124007, 124006, 123752, 124002, 124158, 123998, 123993, 121194, 123988, 124116, 123750, 124154, 123746, 124152, 123744, 123986, 123911, 123739, 93302, 123732, 123731, 123726, 123487, 123319, 123307, 119243, 121525, 123281, 119239, 119221, 93298, 120237, 115263, 115260, 122946, 122725, 85693, 116867, 118942, 122734, 115545, 122189, 122187, 122716, 116864, 122184, 121193, 116861, 119178, 122212, 116233, 122180, 116232, 122206, 122203, 122201, 121818, 121184, 118931, 122199, 122156, 121183, 122169, 118925, 115543, 121832, 121826, 121384, 117959, 117957, 121382, 115541, 121627, 121176, 121417, 121456, 121486, 121174, 112772, 121586, 121548, 121484, 117866, 121214, 112769, 121208, 112765, 112763, 121167, 117855, 121132, 121066, 116968, 116966, 120933, 117721, 114330, 118239, 117715, 115539, 117710, 120855, 115537, 120805, 94651, 120083, 118909, 116707, 120078, 117850, 118905, 118903, 118851, 120102, 120100, 115524, 118253, 117847, 98894, 117845, 116702, 117838, 117837, 117703, 116699, 111224, 117700, 117698, 117697, 118701, 118471, 114482, 115518, 115516, 118175, 118167, 116596, 115512, 116592, 116801, 117946, 117940, 117934, 117925, 118025, 117920, 117916, 117070, 117913, 117833, 117818, 117065, 117783, 117063, 117058, 117169, 117044, 116920, 115712, 116849, 112656, 116918, 114463, 113744, 116847, 116830, 115989, 116905, 116902, 116900, 116898, 116818, 116816, 116813, 116560, 116810, 116809, 115982, 115979, 116791, 76967, 116410, 96054, 115456, 115285, 95806, 113652, 81325, 114741, 114682, 114622, 113513, 114276, 109478, 114272, 114270, 114324, 114323, 113498, 114260, 113495, 109471, 72115, 113634, 113629, 97, 113381, 89010, 113470, 113378, 97739, 113332, 102199, 111185, 112677, 112670, 111178, 112668, 111174, 111171, 111168, 112604, 100465, 111891, 112307, 112304, 112302, 112105, 92676, 111889, 109458, 109455, 109450, 16484, 112453, 112413, 112449, 85231, 112158, 85229, 112190, 112099, 101444, 112295, 101442, 112179, 102127, 112211, 101438, 112137, 80425, 111069, 112134, 101434, 97736, 111826, 111824, 92675, 111815, 111813, 111799, 111794, 111721, 111717, 111463, 92672, 111659, 111144, 101426, 111656, 101423, 111613, 101419, 111547, 111536, 101693, 101301, 111452, 80458, 111487, 103021, 111447, 110950, 103018, 111396, 110945, 110943, 111112, 111354, 103016, 111134, 111129, 101206, 101203, 101297, 110874, 110934, 110871, 110794, 102552, 98976, 101189, 102342, 102338, 102335, 100536, 97733, 97731, 101186, 100515, 100488, 100259, 99607, 99582, 97669, 97456, 97711, 91321, 91317, 91315, 99501, 99496, 99305, 99379, 99298, 99367, 99296, 99352, 99292, 99345, 99342, 92670, 99174, 99148, 98694, 99080, 98164, 98161, 95336, 97704, 95995, 98496, 98492, 95993, 98490, 95991, 84544, 98532, 84539, 98525, 98523, 98514, 97101, 98218, 97285, 98215, 95987, 95986, 95977, 98275, 96923, 98213, 98212, 98211, 98210, 98209, 98208, 98207, 90755, 98142, 90753, 95974, 95972, 95967, 95964, 95961, 95958, 95954, 97098, 94977, 88973, 90668, 90666, 97998, 77263, 97773, 77261, 97843, 95421, 97835, 97834, 95419, 97864, 97857, 97764, 97049, 97047, 97537, 97406, 96874, 97532, 97455, 97395, 97410, 97369, 97266, 92669, 97234, 97158, 92667, 97152, 92665, 92664, 92661, 97088, 97030, 96290, 96288, 96286, 96284, 96280, 96276, 96474, 96471, 96466, 96880, 95415, 96862, 90595, 96454, 95327, 96613, 95413, 96421, 96407, 95411, 95082, 93891, 95409, 95407, 95887, 95318, 95898, 95896, 95884, 95881, 95832, 95877, 95308, 95305, 95304, 94634, 81676, 95672, 94867, 91263, 95399, 95398, 95392, 95386, 95384, 95381, 95283, 95251, 81307, 81301, 81299, 95076, 89578, 81296, 95073, 94848, 94838, 94831, 94829, 94817, 94814, 81273, 81268, 85685, 94186, 93946, 94142, 93286, 94032, 94030, 87064, 93938, 93712, 93924, 36716, 93884, 93706, 24113, 93702, 93698, 81262, 81260, 92659, 93685, 81257, 81255, 81250, 93600, 93284, 93281, 91108, 93274, 91091, 93265, 93375, 93420, 91087, 91085, 93416, 89122, 81236, 93174, 92611, 92608, 91048, 91043, 91040, 93124, 93136, 92829, 92715, 92685, 91001, 92581, 90985, 90978, 92556, 92554, 90972, 92503, 90970, 92500, 90030, 90967, 90962, 90959, 90957, 90021, 90955, 91668, 89859, 85209, 92461, 89854, 89845, 90891, 89841, 89839, 89982, 91735, 89828, 89824, 89962, 89960, 89812, 89810, 89946, 90875, 90849, 89894, 89574, 89206, 89267, 89234, 89197, 89111, 74853, 74850, 88984, 88037, 88481, 88475, 87347, 87756, 87417, 87433, 87422, 87420, 87401, 85205, 87263, 85202, 85198, 85196, 85195, 59624, 85187, 85737, 85735, 85732, 84734, 85178, 86425, 85728, 84731, 84729, 86134, 86410, 86166, 73707, 85633, 86027, 85172, 84728, 85813, 85167, 85721, 84727, 85719, 85753, 85752, 85746, 84725, 84724, 84721, 85158, 85355, 84717, 85328, 85148, 84712, 84710, 84707, 84706, 84704, 84697, 84695, 84693, 84690, 84443, 84441, 84688, 84686, 84436, 84430, 82260, 84417, 84598, 84407, 83119, 83116, 83114, 83895, 84034, 84251, 83751, 84270, 84031, 83762, 83703, 83108, 83106, 83101, 83371, 83098, 83096, 83546, 82688, 83415, 83410, 82787, 82929, 83091, 83089, 83088, 83082, 82957, 82996, 82909, 82369, 79744, 77894, 82851, 79737, 81789, 82402, 82363, 82230, 81659, 81642, 81638, 81633, 81621, 81567, 81616, 81718, 72723, 72722, 81607, 81599, 81590, 81494, 81493, 72745, 81204, 81194, 81111, 81137, 58783, 80602, 80717, 80798, 80711, 79720, 77269, 80387, 80334, 80332, 79710, 80326, 80198, 70931, 76710, 80306, 80196, 80224, 80126, 79913, 79912, 70929, 79694, 79682, 70926, 78652, 70924, 79429, 78645, 78642, 78638, 78634, 79178, 78620, 78613, 78612, 77721, 78610, 78606, 78604, 77719, 79017, 78890, 77714, 78861, 78666, 78584, 78582, 78580, 78578, 78577, 78573, 78571, 78451, 78516, 78448, 78512, 78504, 78510, 78509, 78498, 78494, 77786, 78029, 77850, 78122, 78118, 78018, 78266, 77783, 77699, 77778, 76135, 77660, 76953, 76952, 76881, 77253, 75135, 75133, 75129, 75127, 76227, 70415, 72732, 76732, 76716, 76552, 76678, 75126, 76222, 76495, 76528, 76283, 76282, 76208, 68423, 76034, 75942, 75940, 58774, 75771, 75770, 75840, 75853, 75586, 72716, 75306, 75321, 72710, 74917, 74795, 75267, 74717, 75123, 75122, 74405, 74403, 71492, 73971, 72708, 72704, 73459, 73695, 73362, 73682, 73241, 73680, 73240, 73523, 72695, 73237, 72693, 72692, 73232, 73329, 73415, 73369, 73443, 73393, 73397, 73411, 73399, 73133, 64505, 72729, 72727, 72687, 73105, 72916, 72961, 72943, 72684, 72672, 72795, 72794, 71490, 72655, 71489, 72653, 72645, 72644, 72466, 72464, 70413, 67003, 66999, 66998, 71761, 71757, 71935, 71723, 71398, 71397, 71289, 66981, 71108, 71102, 66975, 71099, 71047, 66965, 70968, 67578, 70971, 70768, 70943, 70197, 70195, 70192, 65979, 66953, 67065, 70779, 69977, 70690, 69970, 70634, 66944, 66942, 69966, 70570, 70406, 70393, 70391, 70455, 70389, 70306, 68398, 70142, 57238, 69961, 69337, 64657, 66038, 60889, 69874, 69790, 67688, 69702, 60885, 69472, 69408, 69370, 67682, 67676, 68851, 68850, 69305, 69208, 69207, 67672, 69198, 68621, 68617, 66920, 68847, 66918, 68842, 68203, 69125, 69091, 69028, 69090, 68903, 68807, 68805, 66914, 68803, 66907, 66449, 68188, 68657, 68606, 18067, 18065, 68604, 68543, 68588, 68516, 68514, 66442, 68389, 68386, 68384, 18061, 66433, 66431, 68122, 66422, 68087, 66415, 65944, 67957, 67705, 67962, 67860, 66413, 66412, 67858, 67896, 67741, 67892, 67853, 67850, 67842, 67841, 64820, 64816, 64810, 64807, 66901, 64797, 64792, 64791, 64790, 64788, 64786, 66881, 64782, 64778, 64774, 67306, 67321, 67241, 67240, 67045, 66372, 66026, 66495, 66314, 66311, 66019, 65532, 66012, 66010, 66006, 66005, 66081, 65762, 65985, 65983, 65963, 65950, 65705, 63471, 63469, 64287, 60092, 65267, 60089, 60087, 65190, 61705, 64022, 63817, 64012, 64990, 64988, 64979, 56970, 62943, 63810, 63420, 63052, 63050, 64006, 63049, 62939, 62531, 63621, 39915, 63304, 62934, 63302, 62931, 63298, 59564, 63218, 63592, 63591, 59562, 63294, 63590, 63459, 62928, 63413, 25756, 63457, 63411, 62921, 62919, 61568, 62918, 63450, 57017, 63448, 57008, 57004, 60838, 63409, 62914, 62901, 62897, 62896, 62521, 63205, 62515, 62513, 62892, 62888, 62887, 62885, 62865, 62507, 62707, 62498, 62497, 57465, 62492, 62102, 62699, 62489, 62486, 62478, 62473, 62098, 61626, 62467, 62572, 62463, 62455, 62603, 62452, 62450, 57463, 57453, 62427, 62415, 62302, 62228, 62165, 62226, 62045, 62043, 62052, 61598, 61566, 54792, 62041, 61939, 62027, 61593, 61701, 61591, 61699, 61784, 61643, 61663, 61522, 61689, 61520, 61681, 61518, 61581, 61564, 61576, 60847, 61114, 61111, 61103, 60620, 60618, 60400, 60449, 60447, 58256, 60266, 60052, 59980, 59938, 59934, 59924, 59799, 59798, 59796, 58042, 59578, 59340, 59529, 58980, 58706, 58978, 56513, 58184, 58070, 58249, 58275, 58299, 58247, 58273, 45695, 58063, 58164, 58162, 58159, 57477, 58006, 58055, 58035, 58053, 58051, 58032, 58029, 58027, 58001, 57999, 57955, 57446, 57795, 57866, 57865, 57786, 57618, 57563, 57444, 57439, 50222, 57436, 49973, 50220, 57288, 57726, 57725, 57613, 57722, 57609, 39907, 57678, 57662, 57630, 57433, 57430, 57660, 57561, 57428, 50215, 56392, 57557, 50212, 57426, 57545, 57583, 57422, 57421, 56932, 57415, 57542, 56706, 49963, 57413, 54572, 56609, 49960, 57411, 57165, 57471, 57342, 57409, 57468, 57382, 57163, 49958, 57324, 57338, 57161, 57320, 57333, 57331, 57278, 57191, 57187, 56607, 56982, 57159, 53990, 57183, 57179, 56696, 56966, 56951, 56892, 56682, 56752, 56978, 56887, 56810, 56859, 56410, 56806, 56748, 56743, 56702, 56656, 56639, 56737, 56734, 56654, 56579, 55499))
Run Time: 0.108404
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 4484 | |
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 | | | | | 4484 | |
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 (26340, 26339, 26338, 26257, 26242, 26215, 26214, 26159, 12835, 12815, 12781, 12777, 12771, 12749, 12748, 12746, 12745, 12731, 12721, 12717, 12710, 12659, 12658, 12656, 12649, 12647, 12639, 12638, 12624, 12603, 12566, 12498, 12436, 12399, 12398, 12346, 12341, 12331, 12330, 12321, 12299, 12297, 12289, 12288, 12280, 12271, 12269, 12215, 12197, 12184, 12114, 12047, 12038, 12028, 12010, 11975, 11969, 11888, 11887, 11873, 11818, 11817, 11741, 11719, 11709, 10975, 10968, 10964, 10928, 10923, 10868, 10832, 10798, 10795, 10794, 10783, 10759, 10728, 10687, 10662, 10652, 10610, 10524, 10515, 10511, 10500, 10496, 10448, 10411, 10376, 10374, 10343, 10280, 10213, 10206, 10175, 10167, 10158, 10137, 10136, 10132, 10129, 10113, 10107, 10085, 10083, 10077, 10020, 10009, 9988, 9952, 9941, 9929, 9910, 9909, 9879, 9866, 9865, 9836, 9826, 9777, 9758, 9735, 9719, 9704, 9690, 9686, 9676, 9661, 9659, 9632, 9621, 9607, 9604, 9595, 9582, 9545, 9502, 9484, 9452, 9442, 9415, 9414, 9410, 9409, 9405, 9386, 9379, 9377, 9373, 9371, 9365, 9362, 9327, 9313, 9307, 9281, 9245, 9219, 9197, 9177, 9162, 9159, 9138, 9132, 9129, 9087, 9080, 8953, 8936, 8934, 8896, 8823, 8771, 8743, 8742, 8651, 8630, 8505, 8495, 8485, 8484, 8468, 8450, 8440, 8438, 8376, 8210, 8201, 8195, 8189, 8170, 8141, 8125, 8108, 8105, 8084, 8049, 8042, 8021, 7977, 7971, 7894, 7889, 7882, 7877, 7861, 7837, 7829, 7828, 7800, 7796, 7787, 7770, 7758, 7732, 7701, 7680, 7661, 7593, 7592, 7496, 7495, 7476, 7460, 7450, 7423, 7420, 7394, 7393, 7358, 7330, 7324, 7215, 7207, 7206, 7200, 7186, 7141, 7128, 7122, 7112, 7111, 7109, 7100, 7088, 7072, 7051, 7026, 7022, 7015, 7005, 7002, 7000, 6958, 6944, 6943, 6940, 6912, 6905, 6885, 6883, 6881, 6880, 6857, 6855, 6843, 6842, 6840, 6801, 6798, 6790, 6776, 6759, 6745, 6736, 6721, 6678, 6677, 6676, 6652, 6629, 6628, 6624, 6612, 6600, 6597, 6453, 6448, 6438, 6429, 6428, 6420, 6396, 6395, 6379, 6373, 6365, 6334, 6270, 6261, 6259, 6241, 6218, 6214, 6183, 6090, 6066, 6064, 6059, 5959, 5956, 5895, 5792, 5741, 5684, 5668, 5631, 5602, 5538, 5537, 5393, 5375, 5352, 5269, 5230, 5153, 5147, 5145, 5140))
Run Time: 0.009107
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 330 | 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, �k�
Run Time: 0.000468
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.000529
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.000647
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: 1716229935
Run Time: 0.000405
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 20 | 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` >= 1716229935)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000570
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 20 | 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