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.001083
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.000274
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` = '1682')
LIMIT 1
Run Time: 0.000383
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.001651
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_1682' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.068482
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 (274762, 270234, 273184, 273182, 273180, 273193, 273191, 273178, 265561, 265260, 264173, 263925, 264797, 265041, 265065, 263922, 264610, 261607, 263894, 264242, 264377, 264240, 261559, 261010, 263344, 263578, 263015, 262199, 262451, 261605, 262447, 261545, 261529, 262402, 262371, 261521, 260965, 261515, 262081, 261603, 260961, 260959, 252986, 261656, 259806, 259660, 261752, 261508, 261325, 260462, 260998, 143643, 260951, 260948, 126121, 259961, 259802, 260647, 259800, 260531, 260644, 260528, 259959, 259958, 259955, 260518, 258950, 259883, 258220, 259880, 258329, 258773, 258780, 250947, 258778, 258116, 254704, 258723, 258240, 258720, 258082, 258078, 258074, 258071, 257933, 257918, 257916, 257616, 257851, 257591, 257204, 257199, 160691, 142945, 255469, 255453, 255437, 255396, 255275, 255003, 254610, 254307, 254957, 254520, 254512, 254649, 254647, 253183, 254700, 254446, 250332, 250294, 250290, 253218, 250287, 250282, 250280, 253233, 250256, 253215, 250242, 252973, 250226, 250222, 250183, 250171, 252981, 250790, 250549, 250547, 250543, 183795, 183793, 250653, 250506, 250651, 250662, 250647, 250522, 183790, 250046, 250404, 250375, 249013, 250370, 249268, 249011, 249266, 249005, 248091, 247870, 249493, 249087, 247867, 204263, 248934, 204251, 204249, 36843, 204247, 222337, 204245, 204238, 191215, 204233, 247315, 222335, 247955, 247898, 204204, 247809, 247806, 207302, 191209, 201493, 222668, 142899, 222516, 208454, 208468, 208448, 208387, 208323, 208115, 207901, 208043, 206562, 201766, 207975, 207434, 207611, 207711, 206557, 142867, 207446, 142865, 207289, 207286, 207088, 207037, 207030, 207279, 207085, 206541, 36824, 36821, 142849, 207077, 206848, 191206, 191204, 207197, 206537, 204819, 207062, 207016, 207014, 206534, 204848, 202745, 202743, 207007, 206577, 206844, 206898, 204783, 204782, 206841, 193302, 206837, 206751, 204580, 206749, 201511, 204829, 203846, 16546, 204816, 204812, 16544, 204808, 204767, 204791, 204801, 204765, 203899, 203773, 203765, 203891, 203763, 203810, 203579, 203577, 203701, 203827, 203740, 203738, 203574, 203248, 203732, 202492, 203466, 203520, 202284, 203571, 203434, 203430, 203423, 203414, 203281, 203457, 202928, 203474, 203473, 203410, 202483, 201509, 201508, 203199, 203198, 201867, 202278, 203274, 202902, 202896, 202044, 203266, 202892, 201852, 202276, 202760, 202758, 202877, 195359, 202730, 202755, 201842, 202370, 152226, 152224, 152222, 193297, 201808, 201806, 195353, 195309, 195350, 195346, 190851, 195342, 195299, 195288, 143202, 195070, 152217, 152215, 152213, 194884, 194826, 152205, 194791, 194557, 194694, 152198, 194140, 194280, 193636, 193634, 169722, 193108, 193620, 193277, 193506, 193504, 193499, 189960, 193495, 193269, 187133, 187131, 187129, 187127, 187125, 192202, 193414, 193267, 127696, 193073, 193097, 193094, 187121, 142818, 192730, 192017, 192006, 191004, 192636, 192567, 192593, 192565, 192591, 192512, 192375, 192506, 192302, 191998, 192295, 192321, 189932, 191993, 192293, 191986, 192258, 191482, 191961, 191480, 191340, 186010, 191967, 191478, 191476, 175642, 191330, 191472, 191470, 191012, 175639, 175630, 175628, 144820, 175622, 175620, 189159, 175617, 190548, 187662, 190089, 189851, 16530, 183449, 187160, 187864, 187912, 184000, 187853, 182651, 187405, 187651, 187649, 187647, 185954, 182636, 187360, 187358, 187353, 187148, 187291, 186008, 182263, 186001, 185937, 182136, 185540, 185074, 184126, 185538, 185072, 182134, 185386, 172655, 184863, 184653, 184852, 170208, 184647, 184328, 184629, 161631, 184206, 182102, 182097, 183331, 183510, 184104, 183325, 183432, 182073, 175587, 173670, 173463, 173560, 170245, 173074, 170240, 173295, 172752, 172750, 172184, 172769, 172992, 172746, 172743, 172742, 157369, 172735, 172733, 172859, 172728, 166719, 172718, 171915, 172641, 170283, 171911, 172665, 172506, 172328, 172325, 171316, 172069, 171313, 172211, 171311, 169879, 170739, 154880, 166811, 172083, 142547, 172066, 171830, 170736, 171835, 171409, 163248, 171828, 171451, 171389, 170733, 171446, 171413, 171234, 169551, 169022, 171225, 165310, 170491, 169549, 171084, 170804, 169007, 170800, 170661, 170829, 170622, 170464, 170279, 170461, 142544, 170277, 170263, 170303, 170450, 170446, 170260, 170229, 168184, 169831, 169870, 165751, 169754, 165739, 169751, 169499, 156155, 169481, 169630, 169090, 169678, 169676, 169087, 169623, 169085, 169579, 167386, 169171, 169083, 165724, 169576, 169303, 169390, 169291, 168905, 169331, 169322, 169319, 168984, 169276, 167376, 169122, 161963, 169012, 162341, 162338, 142539, 48349, 48346, 167911, 59177, 168536, 168534, 168448, 168520, 168517, 96741, 162122, 168004, 167594, 167960, 167310, 166872, 167592, 167554, 167245, 161103, 166804, 166713, 166508, 166709, 166506, 166480, 166502, 166500, 165646, 166611, 166416, 152184, 166492, 166403, 166389, 166001, 166160, 165941, 164711, 166080, 165874, 165540, 165700, 164677, 165473, 164351, 165006, 164655, 16525, 161109, 161149, 161147, 157840, 161144, 161017, 160905, 160823, 160023, 155168, 159850, 148681, 159537, 152634, 156568, 159657, 159655, 157930, 157928, 141655, 148674, 159556, 148671, 148669, 141653, 152149, 158505, 152147, 152142, 159028, 157879, 159293, 157481, 157478, 156564, 159016, 156515, 158670, 156502, 155684, 156495, 156491, 158113, 149409, 154282, 156151, 157664, 154252, 157534, 157771, 157922, 157917, 157827, 157865, 157822, 157861, 157817, 157810, 157801, 149386, 157529, 155883, 156979, 156977, 157654, 128302, 157546, 157488, 157511, 157465, 157343, 157341, 157462, 157507, 157459, 157457, 157320, 156458, 157318, 157111, 121534, 156440, 156431, 156413, 156768, 156766, 149344, 156402, 133932, 156143, 156761, 154176, 156390, 156388, 126985, 154167, 126982, 156382, 156187, 154162, 155506, 156149, 154101, 147473, 154820, 154707, 154518, 154041, 152992, 154516, 154039, 150881, 150876, 150874, 154012, 149184, 152768, 153998, 151937, 148451, 153990, 152757, 152753, 153078, 153076, 152748, 152745, 150825, 150823, 153074, 153733, 153071, 153359, 153289, 139598, 152792, 153728, 153624, 153247, 151413, 152458, 151176, 149139, 149137, 152037, 152353, 149126, 149122, 151776, 152129, 152116, 152026, 152058, 149096, 149091, 149088, 149086, 149074, 149691, 151769, 151800, 149838, 147467, 149836, 149834, 149831, 149827, 147464, 151159, 142516, 150536, 142510, 150718, 151149, 150410, 149017, 151034, 148065, 148063, 127949, 148061, 147934, 147931, 147929, 148208, 147926, 147922, 148178, 148013, 147908, 147905, 146545, 147565, 147560, 140260, 147544, 147541, 147458, 147595, 147456, 146088, 147454, 146008, 145960, 145956, 146288, 146286, 146925, 146923, 145953, 145950, 145948, 145936, 146796, 145929, 145880, 145857, 146604, 145849, 146657, 145816, 145806, 146508, 145796, 145769, 146263, 146345, 146190, 134267, 145643, 145730, 145728, 146185, 145420, 145653, 142501, 142655, 141948, 141394, 141385, 141302, 141945, 138105, 138289, 136341, 133811, 138285, 137765, 134325, 134324, 137601, 130041, 88142, 136094, 136091, 136089, 133873, 136991, 136364, 120834, 136359, 137203, 136333, 136984, 136353, 135187, 129558, 135646, 135910, 129322, 135907, 129556, 129317, 133781, 133780, 129315, 135612, 126885, 129311, 129547, 85522, 134971, 129542, 16489, 133674, 133671, 133669, 135001, 133830, 133825, 133378, 127624, 127620, 134288, 127618, 134393, 134246, 133746, 129431, 129429, 130166, 129617, 129615, 129613, 129612, 129644, 129607, 80543, 130159, 129833, 80540, 80536, 128561, 80533, 128312, 128231, 125675, 127471, 128229, 127840, 127566, 127921, 100849, 128308, 100847, 120823, 100846, 128286, 100844, 125730, 125728, 111, 108, 128225, 125671, 128223, 127894, 127469, 112947, 128058, 127876, 128055, 127467, 125726, 128050, 125724, 125722, 127263, 127461, 127443, 127260, 127362, 125720, 125577, 127246, 126645, 127178, 125718, 125716, 126101, 125498, 126099, 125987, 125714, 126090, 125489, 126086, 126084, 126082, 126228, 125981, 126073, 125978, 126071, 125974, 124810, 125521, 125480, 125944, 125942, 124760, 124758, 124755, 121572, 124752, 125573, 123813, 125415, 125259, 125273, 124542, 125257, 125255, 125251, 125249, 124472, 124468, 125161, 123810, 124978, 124536, 124743, 123805, 112941, 124532, 124193, 123799, 123836, 82342, 123896, 123893, 123795, 123833, 123831, 123605, 123829, 123603, 123890, 123573, 82338, 123568, 123547, 123290, 120926, 123366, 122928, 123363, 122926, 121522, 102659, 122950, 122965, 122924, 122762, 122727, 119193, 122760, 121141, 122771, 112775, 122768, 122724, 116231, 87097, 121366, 121181, 118255, 121504, 115237, 115236, 121500, 121381, 121492, 102822, 120862, 117982, 115059, 118237, 118235, 115055, 115053, 118136, 118232, 114996, 118053, 116491, 113770, 113768, 117826, 113358, 116554, 113751, 117174, 116855, 113741, 115707, 113739, 113737, 113735, 113732, 113725, 116910, 117014, 113717, 113715, 115871, 59141, 113020, 116636, 113015, 99690, 116631, 113012, 114871, 112638, 112636, 112632, 112630, 112628, 116137, 114869, 80520, 113577, 115865, 115864, 115861, 113681, 116105, 115959, 115859, 114862, 113679, 113676, 115929, 115842, 115835, 115833, 113571, 115418, 115440, 114743, 113548, 114691, 114687, 113542, 114295, 114287, 114455, 113423, 109492, 114282, 114381, 109489, 114379, 114377, 109486, 109485, 109480, 109476, 113503, 113501, 113499, 114264, 113640, 100405, 100403, 100086, 100084, 80515, 112931, 112929, 101912, 101907, 101903, 101892, 16486, 101889, 112926, 112922, 113209, 112866, 112888, 113031, 112907, 112905, 101848, 112902, 67810, 112240, 67808, 112598, 112595, 112237, 112228, 109453, 112384, 112186, 112142, 102469, 111071, 112139, 98988, 111730, 98986, 98984, 111725, 97253, 99686, 111466, 99684, 101421, 101418, 101702, 101412, 110951, 111394, 110948, 111392, 109344, 110937, 109404, 109401, 109399, 111117, 110982, 111066, 110976, 102572, 109341, 110969, 109379, 110967, 110932, 109371, 110777, 98981, 101295, 103316, 103314, 109338, 110815, 102876, 102872, 102815, 102813, 102999, 102870, 102512, 102855, 102901, 102846, 102843, 102804, 102839, 102834, 100310, 98631, 102831, 98628, 102800, 98626, 98623, 102545, 17342, 98618, 102543, 102540, 102535, 102650, 102507, 102726, 102500, 102647, 102724, 102723, 102720, 102494, 102185, 101796, 102483, 100548, 102176, 101794, 97449, 102173, 101764, 102322, 101823, 101077, 101376, 101283, 84399, 100726, 100974, 100306, 100779, 100303, 77095, 100077, 84397, 100772, 100793, 100715, 99720, 100586, 100518, 100508, 100504, 100564, 100582, 98310, 97884, 97880, 99600, 98306, 99619, 99597, 99595, 98967, 99592, 98963, 99590, 28557, 28555, 98961, 98958, 98554, 98956, 99556, 98303, 99509, 99499, 28553, 99495, 99414, 99412, 99095, 99407, 99400, 99395, 98950, 97588, 98940, 98937, 98925, 98136, 90735, 90684, 98002, 97837, 97659, 97832, 83519, 97942, 96247, 97653, 97622, 97542, 97619, 97538, 97613, 97407, 97536, 90661, 97444, 90657, 97440, 97439, 97437, 97435, 90655, 95919, 89063, 97071, 90629, 89040, 93878, 97058, 90618, 95914, 90611, 97055, 97017, 97014, 96485, 96296, 96294, 96353, 96872, 88957, 96655, 96477, 96651, 96648, 96351, 96349, 96896, 96866, 96468, 90581, 96666, 96450, 96442, 96435, 95699, 95788, 90489, 95733, 94377, 95465, 94809, 95155, 90440, 95560, 95530, 94864, 94562, 90427, 95556, 95151, 90410, 94542, 94528, 95148, 94525, 94518, 94516, 94511, 95145, 94723, 90382, 94917, 94916, 90380, 90376, 90374, 81305, 95141, 28550, 95062, 95053, 95038, 93862, 94719, 93860, 95032, 28548, 94615, 93859, 93857, 94320, 94318, 93851, 94316, 94613, 94314, 79807, 90369, 90367, 94606, 86871, 93849, 94909, 94474, 94471, 94467, 90345, 94463, 94460, 93814, 93812, 93810, 93808, 93806, 93803, 94576, 93799, 94811, 79287, 93794, 93792, 93788, 93786, 79285, 94401, 94447, 94360, 93780, 16478, 93959, 87067, 90246, 93957, 93762, 90239, 93760, 92510, 88223, 93930, 93928, 93953, 93886, 93747, 86868, 93080, 86866, 78877, 90027, 89711, 90025, 89997, 87496, 87494, 86862, 89994, 79799, 89929, 88994, 79787, 89445, 67932, 89366, 80504, 89364, 89415, 80502, 89436, 88813, 67930, 89422, 88654, 88650, 87938, 88647, 89020, 86157, 83308, 87933, 87932, 88796, 88867, 88794, 88793, 88620, 88618, 85922, 85920, 85916, 88607, 84862, 88605, 88596, 79280, 79774, 79278, 79277, 85913, 79274, 85911, 79272, 88115, 88049, 87922, 80495, 80493, 87489, 87920, 88363, 88108, 88211, 88106, 87486, 85909, 87692, 87484, 87483, 87249, 86239, 86616, 87210, 86237, 87076, 86612, 86796, 81411, 86235, 81405, 86498, 85083, 86524, 79267, 86878, 86227, 86225, 85906, 83135, 85904, 86420, 85345, 84392, 85475, 73853, 81397, 81395, 81393, 81391, 84131, 83657, 83964, 78287, 83655, 83651, 84009, 83860, 82551, 83604, 83599, 82694, 83444, 82813, 83007, 82810, 83441, 82807, 83005, 83131, 83259, 83002, 79263, 82546, 76979, 82543, 78242, 80486, 81905, 79425, 81903, 81902, 80483, 81384, 82516, 82327, 82514, 81668, 81786, 70873, 82413, 81577, 81730, 79423, 81955, 78730, 81658, 81145, 81949, 82113, 81143, 63254, 81946, 82118, 81943, 81655, 81065, 74828, 80481, 81722, 81377, 80613, 81563, 67748, 80473, 80814, 78677, 74826, 81373, 81349, 81500, 81372, 80479, 80902, 80898, 80746, 80591, 80320, 80319, 80103, 79667, 78277, 79665, 79664, 79445, 79943, 79656, 79654, 79384, 78238, 79700, 79681, 79644, 77724, 78275, 74766, 77398, 76074, 76986, 76072, 77245, 74750, 76069, 76305, 74747, 76061, 76060, 76816, 74742, 76790, 76788, 76754, 76673, 76641, 76043, 75760, 76301, 75757, 76041, 76196, 76194, 76193, 76297, 76296, 76463, 76190, 76449, 65115, 76030, 75876, 75754, 75784, 75858, 75751, 75748, 75742, 75720, 75597, 75565, 74487, 75477, 75525, 75379, 73630, 74924, 74311, 75473, 75327, 75252, 74502, 74922, 75299, 74557, 75297, 75249, 75183, 74485, 74336, 74295, 73554, 64236, 74114, 74113, 73645, 74050, 74047, 73924, 73818, 73569, 73505, 73639, 73579, 69435, 68327, 73568, 73577, 73085, 73503, 73308, 66333, 73207, 73322, 72978, 73317, 73128, 73313, 73305, 73123, 73104, 69158, 71703, 69107, 72860, 69105, 72592, 72585, 72580, 65105, 69103, 69903, 69901, 72184, 72331, 70382, 71695, 68254, 70380, 72205, 68251, 66221, 71827, 71643, 72199, 72135, 71824, 72165, 70029, 71823, 71763, 71755, 71917, 71821, 71180, 69043, 69494, 69041, 71436, 71178, 71177, 70983, 70716, 69851, 70439, 70430, 68232, 70378, 69027, 68492, 68447, 66661, 67864, 45851, 66651, 44307, 66496, 64216, 64601, 64600, 62746, 44305, 62740, 64206, 64594, 44303, 46814, 64590, 64588, 60809, 64581, 64579, 66202, 44301, 65382, 58721, 60256, 58719, 63243, 65099, 62056, 25752, 63129, 58926, 59729, 59727, 58179, 62053))
Run Time: 0.099683
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1876 | |
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 | | | | | 1876 | |
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 (13526, 13505, 12978, 12913, 12585, 12554, 12532, 12311, 12198, 12050, 11477, 11247, 11065, 10733, 10004, 9315, 9267, 9167, 9118, 9037, 9013, 8680, 8669, 8563, 8541, 8415, 8088, 8054, 8030, 7953, 7666, 7617, 7507, 7501, 7333, 7323, 7288, 7239, 7208, 7168, 7138, 7124, 7091, 7034, 7018, 6795, 6748, 6724, 6682, 6613, 6542, 6511, 6478, 6467, 6437, 6435, 6317, 6268, 6186, 6078, 6075, 5911, 5896, 5801, 5759, 5590, 5575))
Run Time: 0.003869
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 67 | 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 (274762, 270234, 273184, 273182, 273180, 273193, 273191, 273178, 265561, 265260, 264173, 263925, 264797, 265041, 265065, 263922, 264610, 261607, 263894, 264242, 264377, 264240, 261559, 261010, 263344, 263578, 263015, 262199, 262451, 261605, 262447, 261545, 261529, 262402, 262371, 261521, 260965, 261515, 262081, 261603, 260961, 260959, 252986, 261656, 259806, 259660, 261752, 261508, 261325, 260462, 260998, 143643, 260951, 260948, 126121, 259961, 259802, 260647, 259800, 260531, 260644, 260528, 259959, 259958, 259955, 260518, 258950, 259883, 258220, 259880, 258329, 258773, 258780, 250947, 258778, 258116, 254704, 258723, 258240, 258720, 258082, 258078, 258074, 258071, 257933, 257918, 257916, 257616, 257851, 257591, 257204, 257199, 160691, 142945, 255469, 255453, 255437, 255396, 255275, 255003, 254610, 254307, 254957, 254520, 254512, 254649, 254647, 253183, 254700, 254446, 250332, 250294, 250290, 253218, 250287, 250282, 250280, 253233, 250256, 253215, 250242, 252973, 250226, 250222, 250183, 250171, 252981, 250790, 250549, 250547, 250543, 183795, 183793, 250653, 250506, 250651, 250662, 250647, 250522, 183790, 250046, 250404, 250375, 249013, 250370, 249268, 249011, 249266, 249005, 248091, 247870, 249493, 249087, 247867, 204263, 248934, 204251, 204249, 36843, 204247, 222337, 204245, 204238, 191215, 204233, 247315, 222335, 247955, 247898, 204204, 247809, 247806, 207302, 191209, 201493, 222668, 142899, 222516, 208454, 208468, 208448, 208387, 208323, 208115, 207901, 208043, 206562, 201766, 207975, 207434, 207611, 207711, 206557, 142867, 207446, 142865, 207289, 207286, 207088, 207037, 207030, 207279, 207085, 206541, 36824, 36821, 142849, 207077, 206848, 191206, 191204, 207197, 206537, 204819, 207062, 207016, 207014, 206534, 204848, 202745, 202743, 207007, 206577, 206844, 206898, 204783, 204782, 206841, 193302, 206837, 206751, 204580, 206749, 201511, 204829, 203846, 16546, 204816, 204812, 16544, 204808, 204767, 204791, 204801, 204765, 203899, 203773, 203765, 203891, 203763, 203810, 203579, 203577, 203701, 203827, 203740, 203738, 203574, 203248, 203732, 202492, 203466, 203520, 202284, 203571, 203434, 203430, 203423, 203414, 203281, 203457, 202928, 203474, 203473, 203410, 202483, 201509, 201508, 203199, 203198, 201867, 202278, 203274, 202902, 202896, 202044, 203266, 202892, 201852, 202276, 202760, 202758, 202877, 195359, 202730, 202755, 201842, 202370, 152226, 152224, 152222, 193297, 201808, 201806, 195353, 195309, 195350, 195346, 190851, 195342, 195299, 195288, 143202, 195070, 152217, 152215, 152213, 194884, 194826, 152205, 194791, 194557, 194694, 152198, 194140, 194280, 193636, 193634, 169722, 193108, 193620, 193277, 193506, 193504, 193499, 189960, 193495, 193269, 187133, 187131, 187129, 187127, 187125, 192202, 193414, 193267, 127696, 193073, 193097, 193094, 187121, 142818, 192730, 192017, 192006, 191004, 192636, 192567, 192593, 192565, 192591, 192512, 192375, 192506, 192302, 191998, 192295, 192321, 189932, 191993, 192293, 191986, 192258, 191482, 191961, 191480, 191340, 186010, 191967, 191478, 191476, 175642, 191330, 191472, 191470, 191012, 175639, 175630, 175628, 144820, 175622, 175620, 189159, 175617, 190548, 187662, 190089, 189851, 16530, 183449, 187160, 187864, 187912, 184000, 187853, 182651, 187405, 187651, 187649, 187647, 185954, 182636, 187360, 187358, 187353, 187148, 187291, 186008, 182263, 186001, 185937, 182136, 185540, 185074, 184126, 185538, 185072, 182134, 185386, 172655, 184863, 184653, 184852, 170208, 184647, 184328, 184629, 161631, 184206, 182102, 182097, 183331, 183510, 184104, 183325, 183432, 182073, 175587, 173670, 173463, 173560, 170245, 173074, 170240, 173295, 172752, 172750, 172184, 172769, 172992, 172746, 172743, 172742, 157369, 172735, 172733, 172859, 172728, 166719, 172718, 171915, 172641, 170283, 171911, 172665, 172506, 172328, 172325, 171316, 172069, 171313, 172211, 171311, 169879, 170739, 154880, 166811, 172083, 142547, 172066, 171830, 170736, 171835, 171409, 163248, 171828, 171451, 171389, 170733, 171446, 171413, 171234, 169551, 169022, 171225, 165310, 170491, 169549, 171084, 170804, 169007, 170800, 170661, 170829, 170622, 170464, 170279, 170461, 142544, 170277, 170263, 170303, 170450, 170446, 170260, 170229, 168184, 169831, 169870, 165751, 169754, 165739, 169751, 169499, 156155, 169481, 169630, 169090, 169678, 169676, 169087, 169623, 169085, 169579, 167386, 169171, 169083, 165724, 169576, 169303, 169390, 169291, 168905, 169331, 169322, 169319, 168984, 169276, 167376, 169122, 161963, 169012, 162341, 162338, 142539, 48349, 48346, 167911, 59177, 168536, 168534, 168448, 168520, 168517, 96741, 162122, 168004, 167594, 167960, 167310, 166872, 167592, 167554, 167245, 161103, 166804, 166713, 166508, 166709, 166506, 166480, 166502, 166500, 165646, 166611, 166416, 152184, 166492, 166403, 166389, 166001, 166160, 165941, 164711, 166080, 165874, 165540, 165700, 164677, 165473, 164351, 165006, 164655, 16525, 161109, 161149, 161147, 157840, 161144, 161017, 160905, 160823, 160023, 155168, 159850, 148681, 159537, 152634, 156568, 159657, 159655, 157930, 157928, 141655, 148674, 159556, 148671, 148669, 141653, 152149, 158505, 152147, 152142, 159028, 157879, 159293, 157481, 157478, 156564, 159016, 156515, 158670, 156502, 155684, 156495, 156491, 158113, 149409, 154282, 156151, 157664, 154252, 157534, 157771, 157922, 157917, 157827, 157865, 157822, 157861, 157817, 157810, 157801, 149386, 157529, 155883, 156979, 156977, 157654, 128302, 157546, 157488, 157511, 157465, 157343, 157341, 157462, 157507, 157459, 157457, 157320, 156458, 157318, 157111, 121534, 156440, 156431, 156413, 156768, 156766, 149344, 156402, 133932, 156143, 156761, 154176, 156390, 156388, 126985, 154167, 126982, 156382, 156187, 154162, 155506, 156149, 154101, 147473, 154820, 154707, 154518, 154041, 152992, 154516, 154039, 150881, 150876, 150874, 154012, 149184, 152768, 153998, 151937, 148451, 153990, 152757, 152753, 153078, 153076, 152748, 152745, 150825, 150823, 153074, 153733, 153071, 153359, 153289, 139598, 152792, 153728, 153624, 153247, 151413, 152458, 151176, 149139, 149137, 152037, 152353, 149126, 149122, 151776, 152129, 152116, 152026, 152058, 149096, 149091, 149088, 149086, 149074, 149691, 151769, 151800, 149838, 147467, 149836, 149834, 149831, 149827, 147464, 151159, 142516, 150536, 142510, 150718, 151149, 150410, 149017, 151034, 148065, 148063, 127949, 148061, 147934, 147931, 147929, 148208, 147926, 147922, 148178, 148013, 147908, 147905, 146545, 147565, 147560, 140260, 147544, 147541, 147458, 147595, 147456, 146088, 147454, 146008, 145960, 145956, 146288, 146286, 146925, 146923, 145953, 145950, 145948, 145936, 146796, 145929, 145880, 145857, 146604, 145849, 146657, 145816, 145806, 146508, 145796, 145769, 146263, 146345, 146190, 134267, 145643, 145730, 145728, 146185, 145420, 145653, 142501, 142655, 141948, 141394, 141385, 141302, 141945, 138105, 138289, 136341, 133811, 138285, 137765, 134325, 134324, 137601, 130041, 88142, 136094, 136091, 136089, 133873, 136991, 136364, 120834, 136359, 137203, 136333, 136984, 136353, 135187, 129558, 135646, 135910, 129322, 135907, 129556, 129317, 133781, 133780, 129315, 135612, 126885, 129311, 129547, 85522, 134971, 129542, 16489, 133674, 133671, 133669, 135001, 133830, 133825, 133378, 127624, 127620, 134288, 127618, 134393, 134246, 133746, 129431, 129429, 130166, 129617, 129615, 129613, 129612, 129644, 129607, 80543, 130159, 129833, 80540, 80536, 128561, 80533, 128312, 128231, 125675, 127471, 128229, 127840, 127566, 127921, 100849, 128308, 100847, 120823, 100846, 128286, 100844, 125730, 125728, 111, 108, 128225, 125671, 128223, 127894, 127469, 112947, 128058, 127876, 128055, 127467, 125726, 128050, 125724, 125722, 127263, 127461, 127443, 127260, 127362, 125720, 125577, 127246, 126645, 127178, 125718, 125716, 126101, 125498, 126099, 125987, 125714, 126090, 125489, 126086, 126084, 126082, 126228, 125981, 126073, 125978, 126071, 125974, 124810, 125521, 125480, 125944, 125942, 124760, 124758, 124755, 121572, 124752, 125573, 123813, 125415, 125259, 125273, 124542, 125257, 125255, 125251, 125249, 124472, 124468, 125161, 123810, 124978, 124536, 124743, 123805, 112941, 124532, 124193, 123799, 123836, 82342, 123896, 123893, 123795, 123833, 123831, 123605, 123829, 123603, 123890, 123573, 82338, 123568, 123547, 123290, 120926, 123366, 122928, 123363, 122926, 121522, 102659, 122950, 122965, 122924, 122762, 122727, 119193, 122760, 121141, 122771, 112775, 122768, 122724, 116231, 87097, 121366, 121181, 118255, 121504, 115237, 115236, 121500, 121381, 121492, 102822, 120862, 117982, 115059, 118237, 118235, 115055, 115053, 118136, 118232, 114996, 118053, 116491, 113770, 113768, 117826, 113358, 116554, 113751, 117174, 116855, 113741, 115707, 113739, 113737, 113735, 113732, 113725, 116910, 117014, 113717, 113715, 115871, 59141, 113020, 116636, 113015, 99690, 116631, 113012, 114871, 112638, 112636, 112632, 112630, 112628, 116137, 114869, 80520, 113577, 115865, 115864, 115861, 113681, 116105, 115959, 115859, 114862, 113679, 113676, 115929, 115842, 115835, 115833, 113571, 115418, 115440, 114743, 113548, 114691, 114687, 113542, 114295, 114287, 114455, 113423, 109492, 114282, 114381, 109489, 114379, 114377, 109486, 109485, 109480, 109476, 113503, 113501, 113499, 114264, 113640, 100405, 100403, 100086, 100084, 80515, 112931, 112929, 101912, 101907, 101903, 101892, 16486, 101889, 112926, 112922, 113209, 112866, 112888, 113031, 112907, 112905, 101848, 112902, 67810, 112240, 67808, 112598, 112595, 112237, 112228, 109453, 112384, 112186, 112142, 102469, 111071, 112139, 98988, 111730, 98986, 98984, 111725, 97253, 99686, 111466, 99684, 101421, 101418, 101702, 101412, 110951, 111394, 110948, 111392, 109344, 110937, 109404, 109401, 109399, 111117, 110982, 111066, 110976, 102572, 109341, 110969, 109379, 110967, 110932, 109371, 110777, 98981, 101295, 103316, 103314, 109338, 110815, 102876, 102872, 102815, 102813, 102999, 102870, 102512, 102855, 102901, 102846, 102843, 102804, 102839, 102834, 100310, 98631, 102831, 98628, 102800, 98626, 98623, 102545, 17342, 98618, 102543, 102540, 102535, 102650, 102507, 102726, 102500, 102647, 102724, 102723, 102720, 102494, 102185, 101796, 102483, 100548, 102176, 101794, 97449, 102173, 101764, 102322, 101823, 101077, 101376, 101283, 84399, 100726, 100974, 100306, 100779, 100303, 77095, 100077, 84397, 100772, 100793, 100715, 99720, 100586, 100518, 100508, 100504, 100564, 100582, 98310, 97884, 97880, 99600, 98306, 99619, 99597, 99595, 98967, 99592, 98963, 99590, 28557, 28555, 98961, 98958, 98554, 98956, 99556, 98303, 99509, 99499, 28553, 99495, 99414, 99412, 99095, 99407, 99400, 99395, 98950, 97588, 98940, 98937, 98925, 98136, 90735, 90684, 98002, 97837, 97659, 97832, 83519, 97942, 96247, 97653, 97622, 97542, 97619, 97538, 97613, 97407, 97536, 90661, 97444, 90657, 97440, 97439, 97437, 97435, 90655, 95919, 89063, 97071, 90629, 89040, 93878, 97058, 90618, 95914, 90611, 97055, 97017, 97014, 96485, 96296, 96294, 96353, 96872, 88957, 96655, 96477, 96651, 96648, 96351, 96349, 96896, 96866, 96468, 90581, 96666, 96450, 96442, 96435, 95699, 95788, 90489, 95733, 94377, 95465, 94809, 95155, 90440, 95560, 95530, 94864, 94562, 90427, 95556, 95151, 90410, 94542, 94528, 95148, 94525, 94518, 94516, 94511, 95145, 94723, 90382, 94917, 94916, 90380, 90376, 90374, 81305, 95141, 28550, 95062, 95053, 95038, 93862, 94719, 93860, 95032, 28548, 94615, 93859, 93857, 94320, 94318, 93851, 94316, 94613, 94314, 79807, 90369, 90367, 94606, 86871, 93849, 94909, 94474, 94471, 94467, 90345, 94463, 94460, 93814, 93812, 93810, 93808, 93806, 93803, 94576, 93799, 94811, 79287, 93794, 93792, 93788, 93786, 79285, 94401, 94447, 94360, 93780, 16478, 93959, 87067, 90246, 93957, 93762, 90239, 93760, 92510, 88223, 93930, 93928, 93953, 93886, 93747, 86868, 93080, 86866, 78877, 90027, 89711, 90025, 89997, 87496, 87494, 86862, 89994, 79799, 89929, 88994, 79787, 89445, 67932, 89366, 80504, 89364, 89415, 80502, 89436, 88813, 67930, 89422, 88654, 88650, 87938, 88647, 89020, 86157, 83308, 87933, 87932, 88796, 88867, 88794, 88793, 88620, 88618, 85922, 85920, 85916, 88607, 84862, 88605, 88596, 79280, 79774, 79278, 79277, 85913, 79274, 85911, 79272, 88115, 88049, 87922, 80495, 80493, 87489, 87920, 88363, 88108, 88211, 88106, 87486, 85909, 87692, 87484, 87483, 87249, 86239, 86616, 87210, 86237, 87076, 86612, 86796, 81411, 86235, 81405, 86498, 85083, 86524, 79267, 86878, 86227, 86225, 85906, 83135, 85904, 86420, 85345, 84392, 85475, 73853, 81397, 81395, 81393, 81391, 84131, 83657, 83964, 78287, 83655, 83651, 84009, 83860, 82551, 83604, 83599, 82694, 83444, 82813, 83007, 82810, 83441, 82807, 83005, 83131, 83259, 83002, 79263, 82546, 76979, 82543, 78242, 80486, 81905, 79425, 81903, 81902, 80483, 81384, 82516, 82327, 82514, 81668, 81786, 70873, 82413, 81577, 81730, 79423, 81955, 78730, 81658, 81145, 81949, 82113, 81143, 63254, 81946, 82118, 81943, 81655, 81065, 74828, 80481, 81722, 81377, 80613, 81563, 67748, 80473, 80814, 78677, 74826, 81373, 81349, 81500, 81372, 80479, 80902, 80898, 80746, 80591, 80320, 80319, 80103, 79667, 78277, 79665, 79664, 79445, 79943, 79656, 79654, 79384, 78238, 79700, 79681, 79644, 77724, 78275, 74766, 77398, 76074, 76986, 76072, 77245, 74750, 76069, 76305, 74747, 76061, 76060, 76816, 74742, 76790, 76788, 76754, 76673, 76641, 76043, 75760, 76301, 75757, 76041, 76196, 76194, 76193, 76297, 76296, 76463, 76190, 76449, 65115, 76030, 75876, 75754, 75784, 75858, 75751, 75748, 75742, 75720, 75597, 75565, 74487, 75477, 75525, 75379, 73630, 74924, 74311, 75473, 75327, 75252, 74502, 74922, 75299, 74557, 75297, 75249, 75183, 74485, 74336, 74295, 73554, 64236, 74114, 74113, 73645, 74050, 74047, 73924, 73818, 73569, 73505, 73639, 73579, 69435, 68327, 73568, 73577, 73085, 73503, 73308, 66333, 73207, 73322, 72978, 73317, 73128, 73313, 73305, 73123, 73104, 69158, 71703, 69107, 72860, 69105, 72592, 72585, 72580, 65105, 69103, 69903, 69901, 72184, 72331, 70382, 71695, 68254, 70380, 72205, 68251, 66221, 71827, 71643, 72199, 72135, 71824, 72165, 70029, 71823, 71763, 71755, 71917, 71821, 71180, 69043, 69494, 69041, 71436, 71178, 71177, 70983, 70716, 69851, 70439, 70430, 68232, 70378, 69027, 68492, 68447, 66661, 67864, 45851, 66651, 44307, 66496, 64216, 64601, 64600, 62746, 44305, 62740, 64206, 64594, 44303, 46814, 64590, 64588, 60809, 64581, 64579, 66202, 44301, 65382, 58721, 60256, 58719, 63243, 65099, 62056, 25752, 63129, 58926, 59729, 59727, 58179, 62053))
Run Time: 0.037636
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1876 | |
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 | | | | | 1876 | |
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 (13526, 13505, 12978, 12913, 12585, 12554, 12532, 12311, 12198, 12050, 11477, 11247, 11065, 10733, 10004, 9315, 9267, 9167, 9118, 9037, 9013, 8680, 8669, 8563, 8541, 8415, 8088, 8054, 8030, 7953, 7666, 7617, 7507, 7501, 7333, 7323, 7288, 7239, 7208, 7168, 7138, 7124, 7091, 7034, 7018, 6795, 6748, 6724, 6682, 6613, 6542, 6511, 6478, 6467, 6437, 6435, 6317, 6268, 6186, 6078, 6075, 5911, 5896, 5801, 5759, 5590, 5575))
Run Time: 0.002032
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 67 | 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, ���
Run Time: 0.000168
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.000327
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.000618
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: 1716159846
Run Time: 0.000264
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 24 | 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` >= 1716159846)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000448
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 24 | 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