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.000774
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.000313
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` = '1660')
LIMIT 1
Run Time: 0.000579
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.002415
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_1660' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.051782
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 (169862, 302267, 288117, 301949, 302143, 301121, 297413, 297411, 296987, 290054, 295521, 296442, 296984, 297407, 297406, 282991, 282989, 288586, 284430, 282984, 293765, 293764, 284507, 284504, 284501, 282969, 269787, 278085, 272883, 262101, 269559, 269555, 267950, 267949, 260970, 264325, 267947, 267945, 258346, 266966, 266964, 266962, 268032, 268030, 268025, 266676, 266417, 267059, 264399, 143250, 266508, 266671, 266506, 266668, 266504, 263772, 142963, 257855, 266156, 265261, 265562, 261614, 264299, 264298, 264825, 264664, 261761, 258708, 262187, 262284, 262184, 262168, 259830, 260962, 260051, 261517, 257766, 260955, 142956, 254637, 142954, 257949, 259311, 258766, 258655, 160696, 256929, 255470, 255461, 250366, 255425, 255457, 254958, 96782, 254306, 254519, 117531, 253237, 96778, 251067, 250993, 250801, 250570, 251064, 249007, 249239, 249296, 222623, 249235, 248994, 248991, 248697, 222616, 222605, 247463, 222493, 207620, 208098, 117487, 142871, 207438, 117482, 117480, 142869, 207433, 207295, 207430, 204787, 207064, 207292, 142860, 204030, 203924, 203829, 203807, 203805, 203825, 202046, 194738, 201721, 194940, 195242, 195239, 195060, 195071, 195057, 193293, 117462, 193291, 193289, 193964, 194997, 194354, 194801, 194565, 194828, 194149, 194148, 193860, 193281, 120591, 194131, 169715, 184094, 193228, 193500, 191107, 193581, 193493, 193272, 193417, 169709, 192545, 192543, 193175, 192199, 193215, 193214, 193211, 193069, 192015, 192715, 191996, 184079, 191994, 191987, 191975, 191968, 190757, 190756, 190792, 191007, 190846, 190278, 190275, 190410, 189855, 189507, 189929, 187315, 187313, 189982, 189505, 189504, 120054, 187332, 120576, 187106, 185399, 187701, 187149, 187915, 187655, 120561, 120549, 182813, 185460, 185456, 169947, 174996, 185445, 182135, 185440, 185545, 166743, 185070, 183179, 165371, 165370, 172931, 165368, 184856, 169812, 182110, 181998, 182094, 172926, 182081, 172924, 182811, 175585, 183110, 175583, 182058, 164457, 181987, 181699, 173899, 174842, 182332, 175507, 181552, 174658, 173905, 173846, 172871, 173844, 173476, 164443, 164441, 173523, 170246, 173362, 173490, 173461, 170244, 170242, 172674, 172672, 172463, 172461, 172459, 172355, 172101, 167495, 168538, 170662, 171360, 169878, 142548, 163252, 171297, 171848, 171293, 170732, 171407, 171291, 171288, 171405, 165321, 169162, 169152, 170221, 170219, 170217, 169368, 167132, 169925, 169768, 166892, 168010, 167992, 169861, 168916, 169362, 167130, 165754, 167638, 166790, 167498, 166785, 113922, 166859, 167633, 165493, 162531, 166856, 167249, 166805, 166973, 167246, 166532, 159696, 165716, 166626, 162514, 162738, 166493, 134384, 162178, 164724, 164722, 162176, 162492, 162490, 120036, 159406, 162175, 159402, 162173, 162482, 160024, 161954, 160276, 161952, 160849, 162165, 160920, 161950, 157580, 161948, 160975, 157886, 162403, 153385, 161072, 159599, 159597, 159969, 117375, 160438, 160436, 160434, 160430, 120014, 159956, 159667, 159717, 156779, 154141, 154741, 155829, 154132, 154703, 154730, 151639, 151638, 151636, 155659, 155774, 155771, 155769, 155767, 155765, 96110, 155500, 154114, 155763, 142731, 155761, 150644, 150641, 151631, 150037, 151629, 153127, 120398, 154106, 153908, 146908, 154085, 153343, 117344, 147201, 153759, 152770, 117342, 153121, 153119, 153880, 152718, 153113, 153246, 153108, 153106, 153260, 150563, 148367, 153104, 152254, 152603, 142534, 151052, 151083, 151774, 152065, 152130, 151771, 96735, 110787, 149897, 150370, 150255, 150115, 148658, 149875, 148646, 148644, 149532, 149530, 149523, 148365, 119922, 148543, 148362, 119919, 148360, 149493, 148540, 149491, 147210, 147207, 147205, 148537, 148114, 148358, 119917, 148447, 148024, 142506, 148354, 147938, 147936, 146549, 148229, 148211, 146580, 119899, 119897, 147930, 147928, 148209, 147510, 147921, 148134, 147888, 146547, 147860, 147893, 147506, 147505, 147913, 147886, 147869, 119873, 146544, 147548, 147346, 147431, 147540, 146536, 147023, 142701, 147266, 147263, 146039, 146823, 146903, 146897, 145959, 146896, 146894, 146891, 146801, 145927, 119848, 145921, 145919, 146765, 145915, 119846, 145912, 146482, 145603, 141269, 146603, 146239, 146236, 146595, 141960, 141959, 137428, 137527, 145101, 145659, 145097, 137425, 145095, 137423, 144274, 145093, 145091, 144271, 145088, 145086, 96732, 141651, 144114, 143833, 119791, 119787, 144269, 144267, 144258, 144698, 143973, 144220, 119764, 144216, 144214, 143971, 143967, 143966, 112107, 143962, 143961, 142219, 143117, 143792, 119742, 143955, 143654, 143950, 119736, 143563, 141588, 142642, 117312, 142633, 142626, 119731, 141577, 142493, 88148, 141574, 139087, 141437, 128338, 141942, 138984, 119710, 119708, 96095, 128333, 134851, 115739, 96093, 141263, 125695, 141467, 128330, 137965, 141366, 141285, 137186, 137184, 119682, 141300, 140025, 138834, 138625, 140255, 128328, 119661, 119631, 138812, 119624, 127656, 139333, 127651, 139389, 138516, 138513, 119609, 122216, 112949, 134253, 119587, 128320, 18193, 137835, 133815, 133814, 133809, 138103, 137325, 117037, 137552, 137830, 110785, 18172, 137323, 137516, 18170, 133804, 133801, 137568, 137144, 126901, 126900, 137136, 119580, 134334, 137441, 137563, 137264, 137522, 134314, 117285, 119574, 130173, 135979, 135961, 135922, 135528, 135526, 135930, 129561, 135909, 129557, 135686, 135906, 134975, 134973, 129313, 134875, 122676, 135512, 122674, 135509, 122672, 134846, 134844, 135006, 127203, 134842, 129655, 134964, 134702, 129511, 129499, 129697, 88138, 134530, 134661, 134659, 96072, 134287, 129487, 133555, 119, 116, 133579, 129483, 120830, 129475, 133400, 130294, 130196, 129835, 128074, 128072, 130009, 129780, 129818, 129828, 127800, 128573, 129605, 123778, 129383, 129745, 119515, 128067, 128736, 129239, 129280, 124768, 128316, 128314, 127397, 127565, 127545, 128310, 127543, 127903, 127430, 127957, 125727, 127892, 124766, 126844, 125715, 123934, 117241, 119364, 119361, 120145, 123509, 124118, 120368, 117223, 124113, 123924, 93305, 117219, 123278, 122786, 122240, 121520, 122655, 122780, 116868, 116237, 116866, 122182, 116225, 115995, 122177, 121187, 122170, 122194, 121180, 117738, 120898, 120342, 120959, 120327, 117720, 118149, 118147, 120300, 118145, 120298, 120184, 120296, 118143, 118254, 118141, 120292, 120290, 118849, 117839, 115078, 117203, 115076, 115070, 115020, 118172, 115018, 118216, 118006, 116803, 118249, 118114, 118197, 114732, 96716, 117068, 116931, 117827, 114988, 116555, 116929, 96713, 114474, 114472, 116796, 114470, 114969, 113743, 117074, 116829, 100622, 116904, 100614, 113022, 116552, 100609, 114363, 96057, 96055, 114667, 96608, 114435, 114286, 114235, 109484, 97789, 72120, 109472, 101919, 113374, 113264, 80168, 67822, 111410, 85228, 101841, 111790, 111788, 111785, 24197, 111783, 96707, 97261, 88981, 96705, 103238, 103236, 109466, 101199, 100205, 103118, 96930, 24181, 102728, 101820, 101816, 101811, 101728, 100387, 101756, 101112, 99898, 91482, 89067, 101516, 100896, 95718, 100892, 101279, 92474, 100887, 101273, 80159, 101023, 101012, 67801, 99586, 99867, 99855, 100589, 93099, 93093, 98888, 99426, 100071, 99820, 94334, 99419, 99560, 100224, 93601, 94332, 99814, 99812, 96037, 100219, 100211, 100067, 96030, 99808, 100187, 100173, 100062, 99797, 99794, 67766, 96928, 99646, 99785, 100156, 99705, 99653, 99783, 97890, 99764, 97888, 91333, 98697, 99548, 91331, 98695, 99089, 97591, 24149, 96022, 96019, 99000, 98403, 96017, 96688, 96015, 98398, 98394, 98608, 98534, 88975, 98516, 98511, 98488, 98508, 98390, 97582, 97579, 96924, 96922, 97928, 96919, 97923, 97918, 97916, 98065, 97324, 98055, 79822, 97945, 94980, 97776, 97911, 95936, 97905, 97774, 97771, 97546, 95932, 97641, 95231, 97623, 96873, 96677, 96355, 97442, 97275, 96243, 97334, 93251, 96589, 88970, 96587, 88968, 91287, 96585, 96583, 88966, 96581, 91285, 96552, 96275, 96542, 96593, 96618, 88950, 95469, 95156, 94378, 95299, 94376, 94728, 94364, 93864, 94362, 94724, 94429, 94674, 94399, 93477, 93475, 93473, 88192, 87059, 93890, 93239, 87057, 91129, 92964, 90206, 76517, 92962, 93471, 93479, 93185, 91081, 92959, 92958, 92934, 93183, 93168, 93308, 93166, 92931, 90139, 93224, 90137, 91030, 87291, 76354, 93043, 76352, 76514, 76350, 90098, 92557, 92892, 90088, 92814, 89783, 89780, 90987, 89778, 92589, 92586, 90982, 90966, 90960, 90023, 90931, 91833, 90929, 92409, 89703, 89402, 89978, 88878, 89400, 89951, 90868, 79789, 90864, 89931, 89696, 89680, 89210, 87493, 89448, 87939, 87491, 89443, 86856, 88810, 89022, 87935, 74851, 84869, 88833, 88938, 88869, 88622, 88702, 86918, 88609, 86583, 74998, 86309, 87396, 86581, 87055, 84353, 88281, 85453, 85451, 88123, 76848, 85449, 87355, 88370, 88111, 88369, 87943, 87953, 87539, 87558, 76341, 87550, 87552, 76335, 86974, 86177, 86377, 85145, 86165, 86163, 84291, 83919, 83917, 83885, 82711, 77327, 83342, 83864, 78280, 83127, 83276, 79754, 78702, 78697, 78695, 79749, 81899, 79743, 81893, 82648, 82534, 82518, 82349, 81961, 82256, 81885, 82396, 78176, 82325, 82316, 81745, 81743, 81006, 81738, 81004, 81000, 82314, 81829, 82313, 81827, 80245, 80994, 80689, 80777, 81103, 81100, 81098, 81336, 81063, 81092, 78166, 80437, 79209, 74823, 76331, 76329, 76200, 78386, 78428, 76315, 78030, 77875, 78023, 78261, 78064, 76819, 76312, 77755, 76817, 77400, 77753, 77669, 77700, 77780, 77791, 76706, 76794, 76792, 76505, 76053, 76809, 76603, 76048, 76801, 76503, 76045, 76556, 76187, 76445, 75651, 58778, 58776, 75847, 75870, 75571, 75567, 74802, 75562, 75330, 74800, 75384, 75517, 75515, 75381, 68752, 74980, 74820, 75181, 74715, 75179, 18097, 74813, 74160, 74157, 74155, 74347, 74393, 74344, 74390, 64360, 74335, 74323, 74080, 74388, 74319, 74074, 72351, 72349, 74127, 73930, 74054, 74112, 74108, 74106, 74120, 74051, 74118, 74072, 71963, 73908, 71961, 71957, 73655, 73090, 73359, 73255, 73355, 73337, 73130, 69119, 72974, 69117, 73125, 73306, 73110, 71950, 71948, 72965, 66143, 72958, 66140, 72955, 70549, 69111, 69109, 72817, 72484, 72639, 72335, 69311, 67399, 67397, 72078, 71694, 71445, 69402, 71532, 72174, 71530, 72201, 71940, 64321, 70216, 69234, 70452, 64661, 67680, 67678, 67675, 69212, 69199, 69096, 69094, 67362, 23971, 69030, 68838, 69026, 68830, 23966, 68897, 58770, 58768, 58765, 68744, 58763, 68869, 68877, 68716, 68736, 66450, 68713, 66447, 66445, 66443, 68446, 68488, 18066, 68517, 18064, 68432, 68428, 67451, 68160, 68182, 68220, 68157, 23959, 23955, 23953, 68027, 66420, 57922, 68019, 66416, 67706, 66410, 66409, 67834, 66407, 67107, 67560, 67697, 67731, 23943, 66696, 67610, 67449, 64296, 67503, 67441, 67501, 67290, 67289, 67437, 67428, 67421, 67418, 67416, 67414, 67412, 67410, 67408, 67406, 66029, 64231, 64229, 67312, 64082, 45867, 45864, 45862, 45860, 65936, 65934, 64080, 64078, 45858, 66398, 67207, 45856, 45854, 66132, 67073, 45852, 62384, 45848, 62375, 64221, 45844, 45842, 66653, 66365, 66467, 60818, 60816, 66389, 66381, 66648, 64218, 66458, 61809, 62741, 62286, 61806, 61804, 62735, 64209, 64203, 66326, 64201, 64592, 66350, 66025, 64199, 66022, 46815, 60810, 57916, 64195, 46812, 64191, 46808, 46806, 66016, 66011, 66118, 64580, 66086, 46799, 63836, 66080, 66002, 23932, 66000, 65994, 65992, 46793, 65990, 65039, 65988, 23930, 66044, 23928, 65929, 65986, 61669, 65926, 65337, 65374, 65085, 65083, 59254, 23926, 65366, 65080, 65364, 63832, 64966, 65067, 63829, 65065, 63826, 65272, 65063, 65318, 65270, 65061, 65057, 65055, 64997, 65042, 64993, 65051, 65049, 65047, 65045, 64643, 23917, 23908, 23905, 63436, 63434, 63432, 64156, 64154, 60780, 63425, 64758, 64151, 64702, 52984, 64543, 64270, 64267, 64188, 63419, 64183, 64149, 23900, 23898, 45835, 63682, 63679, 52981, 23890, 63306, 61190, 63417, 63614, 62633, 63196, 63586, 63415, 63414, 63584, 57020, 57018, 57015, 23887, 62729, 49978, 23885, 23879, 62750, 58514, 57000, 62212, 56998, 62275, 61798, 60226, 62210, 56990, 61869, 62665, 62208, 61906, 61905, 58328, 54815, 61903, 62200, 59252, 61901, 61900, 52976, 61896, 61890, 54795, 54790, 61887, 50943, 61884, 59357, 60988, 59354, 59351, 59520, 60958, 45807, 56200, 59862, 60213))
Run Time: 0.075240
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1587 | |
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 | | | | | 1587 | |
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 (14788, 14590, 13745, 13699, 13470, 13464, 13391, 13197, 12983, 12880, 12630, 12303, 12235, 12203, 12186, 12098, 11827, 11702, 11344, 11307, 11152, 10736, 10577, 10420, 10366, 10196, 10164, 10155, 10060, 9795, 9786, 9712, 9670, 9669, 9655, 9642, 9499, 9498, 8722, 8465, 8402, 8283, 8238, 8226, 8191, 8132, 8110, 7827, 7819, 7461, 6751, 6686, 6509, 6442, 6434, 6043, 6031, 5962, 5908, 5867, 5798, 5797, 5775, 5731, 5687, 5683, 5589, 5561))
Run Time: 0.003653
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 68 | 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 (169862, 302267, 288117, 301949, 302143, 301121, 297413, 297411, 296987, 290054, 295521, 296442, 296984, 297407, 297406, 282991, 282989, 288586, 284430, 282984, 293765, 293764, 284507, 284504, 284501, 282969, 269787, 278085, 272883, 262101, 269559, 269555, 267950, 267949, 260970, 264325, 267947, 267945, 258346, 266966, 266964, 266962, 268032, 268030, 268025, 266676, 266417, 267059, 264399, 143250, 266508, 266671, 266506, 266668, 266504, 263772, 142963, 257855, 266156, 265261, 265562, 261614, 264299, 264298, 264825, 264664, 261761, 258708, 262187, 262284, 262184, 262168, 259830, 260962, 260051, 261517, 257766, 260955, 142956, 254637, 142954, 257949, 259311, 258766, 258655, 160696, 256929, 255470, 255461, 250366, 255425, 255457, 254958, 96782, 254306, 254519, 117531, 253237, 96778, 251067, 250993, 250801, 250570, 251064, 249007, 249239, 249296, 222623, 249235, 248994, 248991, 248697, 222616, 222605, 247463, 222493, 207620, 208098, 117487, 142871, 207438, 117482, 117480, 142869, 207433, 207295, 207430, 204787, 207064, 207292, 142860, 204030, 203924, 203829, 203807, 203805, 203825, 202046, 194738, 201721, 194940, 195242, 195239, 195060, 195071, 195057, 193293, 117462, 193291, 193289, 193964, 194997, 194354, 194801, 194565, 194828, 194149, 194148, 193860, 193281, 120591, 194131, 169715, 184094, 193228, 193500, 191107, 193581, 193493, 193272, 193417, 169709, 192545, 192543, 193175, 192199, 193215, 193214, 193211, 193069, 192015, 192715, 191996, 184079, 191994, 191987, 191975, 191968, 190757, 190756, 190792, 191007, 190846, 190278, 190275, 190410, 189855, 189507, 189929, 187315, 187313, 189982, 189505, 189504, 120054, 187332, 120576, 187106, 185399, 187701, 187149, 187915, 187655, 120561, 120549, 182813, 185460, 185456, 169947, 174996, 185445, 182135, 185440, 185545, 166743, 185070, 183179, 165371, 165370, 172931, 165368, 184856, 169812, 182110, 181998, 182094, 172926, 182081, 172924, 182811, 175585, 183110, 175583, 182058, 164457, 181987, 181699, 173899, 174842, 182332, 175507, 181552, 174658, 173905, 173846, 172871, 173844, 173476, 164443, 164441, 173523, 170246, 173362, 173490, 173461, 170244, 170242, 172674, 172672, 172463, 172461, 172459, 172355, 172101, 167495, 168538, 170662, 171360, 169878, 142548, 163252, 171297, 171848, 171293, 170732, 171407, 171291, 171288, 171405, 165321, 169162, 169152, 170221, 170219, 170217, 169368, 167132, 169925, 169768, 166892, 168010, 167992, 169861, 168916, 169362, 167130, 165754, 167638, 166790, 167498, 166785, 113922, 166859, 167633, 165493, 162531, 166856, 167249, 166805, 166973, 167246, 166532, 159696, 165716, 166626, 162514, 162738, 166493, 134384, 162178, 164724, 164722, 162176, 162492, 162490, 120036, 159406, 162175, 159402, 162173, 162482, 160024, 161954, 160276, 161952, 160849, 162165, 160920, 161950, 157580, 161948, 160975, 157886, 162403, 153385, 161072, 159599, 159597, 159969, 117375, 160438, 160436, 160434, 160430, 120014, 159956, 159667, 159717, 156779, 154141, 154741, 155829, 154132, 154703, 154730, 151639, 151638, 151636, 155659, 155774, 155771, 155769, 155767, 155765, 96110, 155500, 154114, 155763, 142731, 155761, 150644, 150641, 151631, 150037, 151629, 153127, 120398, 154106, 153908, 146908, 154085, 153343, 117344, 147201, 153759, 152770, 117342, 153121, 153119, 153880, 152718, 153113, 153246, 153108, 153106, 153260, 150563, 148367, 153104, 152254, 152603, 142534, 151052, 151083, 151774, 152065, 152130, 151771, 96735, 110787, 149897, 150370, 150255, 150115, 148658, 149875, 148646, 148644, 149532, 149530, 149523, 148365, 119922, 148543, 148362, 119919, 148360, 149493, 148540, 149491, 147210, 147207, 147205, 148537, 148114, 148358, 119917, 148447, 148024, 142506, 148354, 147938, 147936, 146549, 148229, 148211, 146580, 119899, 119897, 147930, 147928, 148209, 147510, 147921, 148134, 147888, 146547, 147860, 147893, 147506, 147505, 147913, 147886, 147869, 119873, 146544, 147548, 147346, 147431, 147540, 146536, 147023, 142701, 147266, 147263, 146039, 146823, 146903, 146897, 145959, 146896, 146894, 146891, 146801, 145927, 119848, 145921, 145919, 146765, 145915, 119846, 145912, 146482, 145603, 141269, 146603, 146239, 146236, 146595, 141960, 141959, 137428, 137527, 145101, 145659, 145097, 137425, 145095, 137423, 144274, 145093, 145091, 144271, 145088, 145086, 96732, 141651, 144114, 143833, 119791, 119787, 144269, 144267, 144258, 144698, 143973, 144220, 119764, 144216, 144214, 143971, 143967, 143966, 112107, 143962, 143961, 142219, 143117, 143792, 119742, 143955, 143654, 143950, 119736, 143563, 141588, 142642, 117312, 142633, 142626, 119731, 141577, 142493, 88148, 141574, 139087, 141437, 128338, 141942, 138984, 119710, 119708, 96095, 128333, 134851, 115739, 96093, 141263, 125695, 141467, 128330, 137965, 141366, 141285, 137186, 137184, 119682, 141300, 140025, 138834, 138625, 140255, 128328, 119661, 119631, 138812, 119624, 127656, 139333, 127651, 139389, 138516, 138513, 119609, 122216, 112949, 134253, 119587, 128320, 18193, 137835, 133815, 133814, 133809, 138103, 137325, 117037, 137552, 137830, 110785, 18172, 137323, 137516, 18170, 133804, 133801, 137568, 137144, 126901, 126900, 137136, 119580, 134334, 137441, 137563, 137264, 137522, 134314, 117285, 119574, 130173, 135979, 135961, 135922, 135528, 135526, 135930, 129561, 135909, 129557, 135686, 135906, 134975, 134973, 129313, 134875, 122676, 135512, 122674, 135509, 122672, 134846, 134844, 135006, 127203, 134842, 129655, 134964, 134702, 129511, 129499, 129697, 88138, 134530, 134661, 134659, 96072, 134287, 129487, 133555, 119, 116, 133579, 129483, 120830, 129475, 133400, 130294, 130196, 129835, 128074, 128072, 130009, 129780, 129818, 129828, 127800, 128573, 129605, 123778, 129383, 129745, 119515, 128067, 128736, 129239, 129280, 124768, 128316, 128314, 127397, 127565, 127545, 128310, 127543, 127903, 127430, 127957, 125727, 127892, 124766, 126844, 125715, 123934, 117241, 119364, 119361, 120145, 123509, 124118, 120368, 117223, 124113, 123924, 93305, 117219, 123278, 122786, 122240, 121520, 122655, 122780, 116868, 116237, 116866, 122182, 116225, 115995, 122177, 121187, 122170, 122194, 121180, 117738, 120898, 120342, 120959, 120327, 117720, 118149, 118147, 120300, 118145, 120298, 120184, 120296, 118143, 118254, 118141, 120292, 120290, 118849, 117839, 115078, 117203, 115076, 115070, 115020, 118172, 115018, 118216, 118006, 116803, 118249, 118114, 118197, 114732, 96716, 117068, 116931, 117827, 114988, 116555, 116929, 96713, 114474, 114472, 116796, 114470, 114969, 113743, 117074, 116829, 100622, 116904, 100614, 113022, 116552, 100609, 114363, 96057, 96055, 114667, 96608, 114435, 114286, 114235, 109484, 97789, 72120, 109472, 101919, 113374, 113264, 80168, 67822, 111410, 85228, 101841, 111790, 111788, 111785, 24197, 111783, 96707, 97261, 88981, 96705, 103238, 103236, 109466, 101199, 100205, 103118, 96930, 24181, 102728, 101820, 101816, 101811, 101728, 100387, 101756, 101112, 99898, 91482, 89067, 101516, 100896, 95718, 100892, 101279, 92474, 100887, 101273, 80159, 101023, 101012, 67801, 99586, 99867, 99855, 100589, 93099, 93093, 98888, 99426, 100071, 99820, 94334, 99419, 99560, 100224, 93601, 94332, 99814, 99812, 96037, 100219, 100211, 100067, 96030, 99808, 100187, 100173, 100062, 99797, 99794, 67766, 96928, 99646, 99785, 100156, 99705, 99653, 99783, 97890, 99764, 97888, 91333, 98697, 99548, 91331, 98695, 99089, 97591, 24149, 96022, 96019, 99000, 98403, 96017, 96688, 96015, 98398, 98394, 98608, 98534, 88975, 98516, 98511, 98488, 98508, 98390, 97582, 97579, 96924, 96922, 97928, 96919, 97923, 97918, 97916, 98065, 97324, 98055, 79822, 97945, 94980, 97776, 97911, 95936, 97905, 97774, 97771, 97546, 95932, 97641, 95231, 97623, 96873, 96677, 96355, 97442, 97275, 96243, 97334, 93251, 96589, 88970, 96587, 88968, 91287, 96585, 96583, 88966, 96581, 91285, 96552, 96275, 96542, 96593, 96618, 88950, 95469, 95156, 94378, 95299, 94376, 94728, 94364, 93864, 94362, 94724, 94429, 94674, 94399, 93477, 93475, 93473, 88192, 87059, 93890, 93239, 87057, 91129, 92964, 90206, 76517, 92962, 93471, 93479, 93185, 91081, 92959, 92958, 92934, 93183, 93168, 93308, 93166, 92931, 90139, 93224, 90137, 91030, 87291, 76354, 93043, 76352, 76514, 76350, 90098, 92557, 92892, 90088, 92814, 89783, 89780, 90987, 89778, 92589, 92586, 90982, 90966, 90960, 90023, 90931, 91833, 90929, 92409, 89703, 89402, 89978, 88878, 89400, 89951, 90868, 79789, 90864, 89931, 89696, 89680, 89210, 87493, 89448, 87939, 87491, 89443, 86856, 88810, 89022, 87935, 74851, 84869, 88833, 88938, 88869, 88622, 88702, 86918, 88609, 86583, 74998, 86309, 87396, 86581, 87055, 84353, 88281, 85453, 85451, 88123, 76848, 85449, 87355, 88370, 88111, 88369, 87943, 87953, 87539, 87558, 76341, 87550, 87552, 76335, 86974, 86177, 86377, 85145, 86165, 86163, 84291, 83919, 83917, 83885, 82711, 77327, 83342, 83864, 78280, 83127, 83276, 79754, 78702, 78697, 78695, 79749, 81899, 79743, 81893, 82648, 82534, 82518, 82349, 81961, 82256, 81885, 82396, 78176, 82325, 82316, 81745, 81743, 81006, 81738, 81004, 81000, 82314, 81829, 82313, 81827, 80245, 80994, 80689, 80777, 81103, 81100, 81098, 81336, 81063, 81092, 78166, 80437, 79209, 74823, 76331, 76329, 76200, 78386, 78428, 76315, 78030, 77875, 78023, 78261, 78064, 76819, 76312, 77755, 76817, 77400, 77753, 77669, 77700, 77780, 77791, 76706, 76794, 76792, 76505, 76053, 76809, 76603, 76048, 76801, 76503, 76045, 76556, 76187, 76445, 75651, 58778, 58776, 75847, 75870, 75571, 75567, 74802, 75562, 75330, 74800, 75384, 75517, 75515, 75381, 68752, 74980, 74820, 75181, 74715, 75179, 18097, 74813, 74160, 74157, 74155, 74347, 74393, 74344, 74390, 64360, 74335, 74323, 74080, 74388, 74319, 74074, 72351, 72349, 74127, 73930, 74054, 74112, 74108, 74106, 74120, 74051, 74118, 74072, 71963, 73908, 71961, 71957, 73655, 73090, 73359, 73255, 73355, 73337, 73130, 69119, 72974, 69117, 73125, 73306, 73110, 71950, 71948, 72965, 66143, 72958, 66140, 72955, 70549, 69111, 69109, 72817, 72484, 72639, 72335, 69311, 67399, 67397, 72078, 71694, 71445, 69402, 71532, 72174, 71530, 72201, 71940, 64321, 70216, 69234, 70452, 64661, 67680, 67678, 67675, 69212, 69199, 69096, 69094, 67362, 23971, 69030, 68838, 69026, 68830, 23966, 68897, 58770, 58768, 58765, 68744, 58763, 68869, 68877, 68716, 68736, 66450, 68713, 66447, 66445, 66443, 68446, 68488, 18066, 68517, 18064, 68432, 68428, 67451, 68160, 68182, 68220, 68157, 23959, 23955, 23953, 68027, 66420, 57922, 68019, 66416, 67706, 66410, 66409, 67834, 66407, 67107, 67560, 67697, 67731, 23943, 66696, 67610, 67449, 64296, 67503, 67441, 67501, 67290, 67289, 67437, 67428, 67421, 67418, 67416, 67414, 67412, 67410, 67408, 67406, 66029, 64231, 64229, 67312, 64082, 45867, 45864, 45862, 45860, 65936, 65934, 64080, 64078, 45858, 66398, 67207, 45856, 45854, 66132, 67073, 45852, 62384, 45848, 62375, 64221, 45844, 45842, 66653, 66365, 66467, 60818, 60816, 66389, 66381, 66648, 64218, 66458, 61809, 62741, 62286, 61806, 61804, 62735, 64209, 64203, 66326, 64201, 64592, 66350, 66025, 64199, 66022, 46815, 60810, 57916, 64195, 46812, 64191, 46808, 46806, 66016, 66011, 66118, 64580, 66086, 46799, 63836, 66080, 66002, 23932, 66000, 65994, 65992, 46793, 65990, 65039, 65988, 23930, 66044, 23928, 65929, 65986, 61669, 65926, 65337, 65374, 65085, 65083, 59254, 23926, 65366, 65080, 65364, 63832, 64966, 65067, 63829, 65065, 63826, 65272, 65063, 65318, 65270, 65061, 65057, 65055, 64997, 65042, 64993, 65051, 65049, 65047, 65045, 64643, 23917, 23908, 23905, 63436, 63434, 63432, 64156, 64154, 60780, 63425, 64758, 64151, 64702, 52984, 64543, 64270, 64267, 64188, 63419, 64183, 64149, 23900, 23898, 45835, 63682, 63679, 52981, 23890, 63306, 61190, 63417, 63614, 62633, 63196, 63586, 63415, 63414, 63584, 57020, 57018, 57015, 23887, 62729, 49978, 23885, 23879, 62750, 58514, 57000, 62212, 56998, 62275, 61798, 60226, 62210, 56990, 61869, 62665, 62208, 61906, 61905, 58328, 54815, 61903, 62200, 59252, 61901, 61900, 52976, 61896, 61890, 54795, 54790, 61887, 50943, 61884, 59357, 60988, 59354, 59351, 59520, 60958, 45807, 56200, 59862, 60213))
Run Time: 0.031184
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1587 | |
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 | | | | | 1587 | |
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 (14788, 14590, 13745, 13699, 13470, 13464, 13391, 13197, 12983, 12880, 12630, 12303, 12235, 12203, 12186, 12098, 11827, 11702, 11344, 11307, 11152, 10736, 10577, 10420, 10366, 10196, 10164, 10155, 10060, 9795, 9786, 9712, 9670, 9669, 9655, 9642, 9499, 9498, 8722, 8465, 8402, 8283, 8238, 8226, 8191, 8132, 8110, 7827, 7819, 7461, 6751, 6686, 6509, 6442, 6434, 6043, 6031, 5962, 5908, 5867, 5798, 5797, 5775, 5731, 5687, 5683, 5589, 5561))
Run Time: 0.002433
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 68 | 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, t�E
Run Time: 0.000218
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.000353
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 158
- 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.000670
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 158
- 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: 1717145388
Run Time: 0.000335
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 15 | 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` >= 1717145388)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000644
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 15 | 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