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.000526
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.000166
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` = '1249')
LIMIT 1
Run Time: 0.000397
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.002156
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_1249' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.112216
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 (561726, 565963, 557384, 561714, 557380, 561702, 561700, 561693, 561690, 561685, 561682, 561679, 561674, 561671, 557365, 561666, 557363, 560781, 561664, 561653, 560778, 557361, 557359, 557355, 557350, 556719, 557348, 557332, 557315, 557314, 557312, 557309, 557307, 502317, 557305, 328053, 548835, 557302, 548806, 502280, 384075, 375418, 376704, 375373, 364236, 357546, 317530, 317529, 316147, 316019, 314218, 315156, 315154, 314276, 313556, 313707, 314210, 313701, 312594, 310734, 311130, 306868, 308200, 306866, 307285, 306822, 306819, 306566, 305742, 301354, 304848, 270509, 270502, 301397, 305095, 305093, 18294, 304573, 300509, 288121, 284993, 299408, 284989, 301014, 301085, 301133, 302953, 302946, 302443, 302401, 301129, 301070, 300894, 300505, 299489, 18292, 18290, 299405, 299403, 18287, 18285, 296444, 297483, 297306, 295424, 291006, 296439, 282720, 288107, 288103, 293766, 288136, 293761, 288134, 288131, 288129, 293840, 290700, 288731, 291637, 288729, 273119, 288725, 172022, 28569, 288723, 291227, 287926, 290081, 290073, 28567, 289735, 288717, 286573, 282972, 28563, 288040, 123435, 287924, 287403, 287661, 287500, 285729, 285727, 285005, 285720, 285940, 282714, 282711, 282707, 282704, 284845, 284841, 284466, 284464, 269617, 284424, 284456, 284422, 279980, 282809, 282808, 183916, 279477, 277702, 279475, 18269, 277698, 277685, 267611, 273547, 273544, 270231, 263609, 270225, 183905, 273108, 274075, 274073, 274071, 271320, 271570, 268071, 271566, 271562, 271560, 271541, 271317, 270752, 270728, 270748, 270746, 270995, 270817, 268687, 270938, 270815, 268683, 270796, 268681, 268680, 270674, 270672, 270670, 269589, 269902, 270589, 269900, 269899, 270587, 270186, 268149, 270294, 270050, 270209, 268060, 268058, 269963, 268794, 269720, 268054, 268145, 264622, 268143, 268479, 268476, 83470, 268029, 183199, 268045, 268042, 267913, 267403, 266479, 267282, 267394, 267269, 266937, 266935, 266673, 266933, 266959, 266669, 266930, 263771, 259504, 266667, 266514, 266169, 266166, 264810, 264788, 264654, 264264, 264245, 263896, 264372, 264135, 262375, 139295, 263239, 262200, 262186, 262181, 260963, 262164, 261588, 113981, 126122, 259804, 113979, 261418, 254726, 259798, 260473, 260471, 259305, 259418, 259303, 259501, 259499, 258455, 259299, 259316, 259310, 258327, 258216, 258110, 258104, 258099, 257926, 258097, 257617, 257607, 257226, 256878, 256556, 256402, 255474, 255471, 256386, 256384, 249924, 250286, 250223, 250174, 250559, 249921, 251025, 249919, 252982, 249915, 250799, 252921, 250102, 251022, 251019, 250064, 249984, 247638, 249939, 250434, 250408, 249895, 250405, 250039, 249006, 222321, 249488, 249454, 248912, 249294, 248992, 36848, 36846, 36834, 247373, 191214, 248883, 248704, 248702, 248303, 222232, 191211, 247919, 247912, 247810, 247634, 191210, 142913, 142909, 247371, 247369, 222603, 247499, 247341, 172017, 247339, 142907, 247468, 222677, 247337, 192585, 172006, 222654, 222549, 222301, 222246, 222497, 222295, 142889, 207908, 222083, 222063, 208518, 221964, 208511, 208510, 206570, 171332, 194850, 191208, 204135, 193259, 207290, 207107, 207236, 206536, 207018, 194837, 206928, 202742, 206821, 206750, 171324, 127046, 194960, 203814, 204815, 204793, 204369, 204367, 204343, 204190, 204331, 204330, 202048, 204094, 203833, 203932, 203803, 203826, 203573, 202281, 203542, 203425, 203540, 203487, 202481, 202472, 202469, 195360, 194740, 202246, 202234, 195358, 202459, 195356, 202457, 202380, 167080, 202202, 201724, 202066, 202024, 201977, 201711, 201975, 201824, 201803, 201745, 194948, 201799, 201737, 201523, 201357, 201521, 201497, 195244, 195351, 192618, 193724, 195063, 195059, 195175, 193709, 195173, 193960, 194715, 194936, 194919, 193438, 193436, 194880, 194806, 193929, 194834, 194699, 194689, 193696, 193866, 190933, 85568, 193819, 193857, 193921, 193910, 193433, 193428, 193906, 193798, 193796, 193850, 194011, 193511, 193671, 193224, 193496, 185500, 193413, 185498, 193077, 192901, 185496, 192930, 192811, 192892, 192146, 192237, 192729, 192807, 192016, 192572, 192569, 192516, 192566, 175597, 192454, 192300, 192137, 184078, 191989, 191988, 192056, 191973, 192118, 175645, 191584, 191324, 191200, 191198, 175634, 175626, 187709, 189649, 190931, 175623, 175621, 175619, 175618, 190360, 190356, 175612, 190580, 175609, 190270, 190265, 190260, 190145, 190091, 190088, 189979, 187312, 189914, 189645, 144147, 189156, 183451, 187956, 187861, 187858, 185490, 153636, 185487, 182634, 182627, 184657, 187195, 182624, 182264, 186953, 184146, 186891, 184144, 184142, 165057, 185078, 185433, 185481, 185058, 185387, 185049, 185045, 183990, 183988, 185020, 183178, 185038, 184787, 184225, 184358, 184055, 184117, 170620, 184109, 184026, 183357, 182291, 182288, 183565, 183171, 183421, 174848, 174846, 183112, 172944, 183101, 182367, 181981, 182539, 182280, 182192, 181739, 168211, 181718, 144455, 173874, 181082, 174831, 175523, 174958, 175521, 83179, 174955, 167166, 174952, 18252, 174741, 175127, 174977, 170287, 174937, 174806, 174933, 18249, 172793, 173056, 172790, 171986, 173840, 173535, 173092, 173076, 173087, 173070, 154888, 172897, 172767, 154885, 172821, 154883, 172511, 171052, 172505, 172286, 172321, 163255, 171310, 172126, 172124, 172122, 3039, 172120, 171959, 163251, 170933, 163249, 171836, 171141, 171139, 171137, 171283, 171279, 171275, 170650, 170583, 150658, 170930, 170696, 170928, 170578, 170647, 170383, 169872, 170375, 18239, 170264, 168497, 170442, 170232, 170230, 170193, 169364, 169265, 155204, 169963, 170056, 169989, 169528, 165750, 169469, 169523, 155202, 169334, 169144, 168008, 169138, 169400, 167381, 168945, 169011, 168493, 168658, 168484, 167990, 123681, 123679, 167247, 166913, 166985, 166911, 164046, 166779, 166777, 166835, 166831, 166507, 166649, 166498, 161359, 160614, 134381, 134375, 164300, 166177, 166172, 165088, 164714, 165781, 113910, 165536, 165697, 164816, 164378, 164508, 164497, 163807, 163794, 163678, 163333, 155694, 163279, 163276, 162957, 155692, 162955, 163224, 162942, 162724, 162810, 18233, 162323, 18230, 162720, 18228, 18227, 161557, 134507, 162062, 162185, 141663, 162087, 141660, 141658, 161574, 160980, 160494, 159961, 158685, 83157, 148678, 159591, 153823, 157088, 159858, 159576, 159651, 159536, 159045, 158506, 159297, 159026, 159015, 159011, 156481, 156479, 158205, 156152, 157353, 157919, 156982, 149371, 157460, 157015, 96134, 157321, 156975, 157014, 156772, 96127, 96125, 154163, 154158, 156185, 156174, 156167, 155782, 155662, 155643, 155728, 155487, 154347, 153954, 149295, 154893, 153950, 149263, 149255, 154095, 154094, 150877, 153773, 153943, 153941, 152758, 152754, 152739, 151588, 139290, 153725, 153712, 152098, 153488, 153280, 134487, 153241, 153068, 152679, 152654, 147796, 152463, 152460, 149161, 149159, 149155, 149141, 151166, 151164, 151162, 151813, 149808, 151255, 151810, 151145, 152084, 96966, 151835, 149095, 149073, 151801, 149055, 151451, 151576, 151080, 150602, 150597, 149823, 150760, 149025, 148381, 151078, 149928, 149007, 150935, 148979, 150792, 148947, 139276, 148941, 150531, 148923, 150258, 148919, 147197, 148899, 139273, 149950, 139271, 148797, 148786, 148784, 148776, 149518, 149516, 148773, 133920, 148750, 148500, 148583, 148579, 148460, 148575, 147826, 148022, 148454, 146741, 147537, 148415, 147534, 148386, 148395, 148410, 145142, 148392, 148018, 147526, 147523, 139251, 146548, 148210, 127953, 148159, 148155, 139244, 148153, 139240, 139239, 139237, 139234, 139233, 139231, 147992, 139229, 148042, 147366, 113904, 147545, 146104, 147542, 146098, 147193, 147361, 147096, 147091, 147085, 147111, 147081, 147073, 146063, 147009, 146046, 146900, 146946, 146017, 146893, 144144, 146646, 144141, 146507, 145423, 144757, 144828, 145421, 146186, 94657, 145656, 145391, 145417, 144120, 139223, 145074, 144813, 144811, 139211, 139209, 139207, 139204, 145014, 143981, 143979, 143977, 144740, 144663, 143963, 143959, 144172, 143793, 142054, 142052, 142050, 114532, 143656, 142038, 142032, 143945, 137401, 143943, 85532, 137398, 143790, 121857, 126571, 126569, 143652, 143560, 143647, 134361, 142497, 143350, 139159, 139154, 139147, 129858, 129856, 142625, 139086, 139083, 141433, 141427, 71658, 139058, 134467, 139043, 142076, 141393, 137188, 140263, 141267, 138531, 138529, 138526, 141473, 141478, 141256, 141254, 140530, 140739, 140406, 140397, 138477, 128326, 140131, 128325, 140121, 140017, 137958, 138560, 138810, 139579, 138804, 124953, 139632, 124942, 138149, 134358, 133466, 138271, 114528, 114527, 18222, 18201, 138206, 138201, 133818, 138308, 18189, 138446, 18173, 133812, 133807, 138193, 138191, 138102, 137378, 137376, 18166, 18163, 137346, 126563, 136993, 127629, 134585, 136172, 126891, 137384, 136032, 127627, 134955, 134953, 135970, 135423, 136323, 135958, 135876, 135912, 135874, 129633, 126518, 126512, 126508, 135266, 134310, 135145, 127035, 134997, 135149, 133464, 134579, 135045, 127030, 127205, 135008, 135016, 133831, 127201, 134302, 133461, 133861, 128399, 134665, 134418, 133459, 113156, 123053, 129648, 134576, 130171, 134236, 134274, 123051, 134285, 130303, 134283, 129941, 133762, 133760, 133447, 133444, 133689, 133441, 129625, 129623, 116005, 133439, 133434, 130403, 130399, 129910, 130141, 129894, 130184, 129883, 129882, 130056, 128582, 128068, 128579, 128577, 116003, 129602, 129662, 129702, 118001, 129585, 129289, 126414, 59641, 128152, 120822, 125670, 127897, 128122, 127873, 124866, 114525, 126368, 126868, 123386, 124864, 126935, 126858, 126363, 126361, 124836, 126094, 125663, 126062, 126039, 125300, 125421, 125644, 125641, 116001, 125413, 125559, 125408, 125405, 125404, 125317, 125458, 125353, 125298, 125313, 125308, 125275, 124471, 124800, 125006, 85298, 124709, 79874, 121420, 124038, 123668, 123666, 85702, 124379, 123510, 124022, 85700, 124233, 123662, 121195, 123995, 124117, 123987, 122787, 123612, 59150, 123743, 93303, 123341, 123288, 93300, 123109, 122213, 86080, 121802, 121491, 121216, 121481, 121388, 117858, 117955, 121210, 118447, 117852, 120109, 118776, 114481, 118442, 114478, 116922, 117821, 117047, 114460, 116846, 116914, 116174, 76968, 116376, 116374, 116392, 100602, 116371, 115924, 113677, 115855, 114303, 102631, 114299, 115834, 115682, 115831, 102617, 102615, 102613, 114695, 113121, 114403, 114761, 113564, 114552, 114759, 114734, 113546, 113539, 113518, 113504, 114400, 101308, 114229, 114135, 114220, 113614, 112744, 91626, 102144, 113490, 113452, 102137, 112933, 112927, 113338, 112923, 112915, 112738, 112616, 102135, 112730, 112614, 112908, 113000, 112903, 112883, 112714, 112881, 112837, 112788, 112704, 112316, 112701, 112699, 112694, 111892, 112476, 112300, 83292, 83290, 112200, 112216, 101829, 103329, 111883, 80428, 111880, 111876, 111840, 18157, 111835, 101304, 18155, 111869, 111900, 111823, 100917, 100915, 111816, 109290, 111147, 111471, 97254, 111448, 110949, 111325, 111136, 111343, 111116, 111131, 111027, 109342, 103300, 109333, 103342, 101200, 103259, 97242, 98978, 103011, 102514, 98975, 102511, 100730, 102449, 101767, 101650, 102117, 102115, 100547, 100543, 100538, 101498, 101493, 84398, 100509, 97105, 97710, 98151, 97099, 96603, 98349, 97933, 97445, 97626, 97617, 97339, 97322, 97319, 97168, 97061, 88965, 97056, 95666, 92943, 88955, 96270, 96660, 96259, 95899, 94808, 94806, 81308, 95436, 81292, 81279, 94160, 93717, 81263, 93710, 81240, 93266, 93036, 92853, 92718, 92836, 92725, 92506, 89852, 79800, 79795, 91682, 89800, 88931, 87749, 89361, 88728, 89200, 79784, 79780, 88632, 85924, 84512, 85923, 84500, 88490, 88486, 86500, 88477, 59638, 87443, 84492, 87348, 88134, 76831, 87544, 88128, 87732, 59635, 87415, 59631, 87413, 87412, 59629, 87344, 59625, 87265, 85736, 87042, 86614, 86687, 86887, 86886, 76714, 85734, 86426, 86076, 85731, 86553, 86132, 86074, 73700, 85879, 85720, 84833, 85385, 85343, 79921, 85465, 83267, 84828, 84850, 84785, 84893, 84887, 84781, 84803, 84486, 83887, 82555, 83865, 83780, 83446, 81388, 80948, 83280, 83586, 82684, 83442, 83130, 82752, 82384, 82383, 83274, 83093, 82784, 83016, 82998, 82993, 81386, 79747, 82542, 79745, 82539, 79742, 82896, 81382, 82533, 82646, 80922, 82368, 81777, 72747, 81123, 81548, 81859, 81944, 81724, 81650, 81933, 81630, 81622, 81614, 81532, 81208, 80755, 80754, 81425, 80750, 81196, 80748, 81059, 80938, 80936, 79462, 80737, 80630, 79721, 80393, 80137, 80391, 80386, 80359, 80077, 79715, 79486, 79705, 64895, 79457, 77723, 78221, 79256, 79418, 79438, 79395, 77256, 79245, 78940, 78938, 78646, 78640, 78891, 78930, 78633, 78928, 78627, 79140, 78624, 78985, 78617, 79009, 78603, 77718, 78976, 76088, 79045, 64507, 18134, 77119, 78515, 78411, 78116, 78102, 76313, 77681, 77668, 77066, 76954, 77654, 76726, 74754, 77247, 77266, 77012, 76995, 76058, 76791, 76894, 76662, 76592, 76680, 18109, 76437, 76398, 76039, 76393, 76372, 75833, 76211, 74644, 76181, 75867, 75636, 75798, 70107, 75878, 75795, 75869, 75735, 75308, 70098, 75315, 75578, 75495, 75304, 75328, 74722, 74718, 75180, 74398, 74537, 66197, 74534, 73563, 72523, 72521, 64357, 74406, 74404, 74298, 74332, 73931, 73555, 74189, 72885, 73488, 73487, 73550, 69313, 73156, 73993, 73152, 72699, 73545, 73543, 73476, 73571, 73623, 73585, 73508, 73242, 73364, 73357, 73582, 72360, 73043, 66195, 71710, 69150, 63252, 72453, 72779, 72353, 70336, 67402, 72337, 72267, 72177, 71817, 71688, 64331, 60894, 71577, 71575, 71367, 69044, 71905, 71748, 71561, 68209, 71522, 69037, 69899, 70774, 71364, 71282, 60435, 71052, 70951, 70311, 70207, 70206, 70205, 70949, 70200, 70946, 70407, 70510, 70405, 70402, 70388, 70010, 70350, 69992, 70177, 70050, 70140, 70123, 70070, 69988, 67394, 67163, 69542, 67686, 69561, 69738, 69705, 69532, 67574, 68345, 68626, 67572, 69293, 67392, 69322, 67388, 64884, 68723, 68866, 68609, 68006, 68715, 67989, 68187, 68433, 18068, 67986, 67623, 63010, 67386, 67533, 67544, 67369, 67366, 66722, 65975, 67096, 66659, 67077, 65874, 66190, 66233, 66051, 66049, 66070, 65776, 60208, 57026, 65075, 64874, 59598, 64514, 63428, 59593, 64699, 63629, 62681, 59588, 62677, 62675, 59745, 59585, 63143, 39675, 63463, 63462, 63458, 63452, 62705, 61188, 62702, 45709, 61698, 54148, 61043, 61182, 60194, 61178, 60214, 60622, 60724, 60590, 60430, 60455, 57706, 58251, 60187, 60267, 56757, 59583, 56755, 56754, 58737, 58237, 59035, 57704, 58321, 58420, 58192, 58072, 57478, 57620, 57733, 57824, 57864, 57568, 57441, 57440, 57694, 50221, 57721, 57367, 57365, 57431, 56902, 55555, 53873, 55830, 44299, 41460, 56250, 56266, 56263, 56132, 54465, 55875, 55817, 56025, 35347, 44292, 55909, 18036, 18035, 55812, 55907, 55810, 18031, 55808, 45509, 18019, 18017, 54095, 54948, 54491, 18012, 54087, 53134, 53125, 43133, 53019, 34900, 35334, 52518, 52764, 52785, 50401, 52135, 52739, 52494, 51933, 52351, 51625, 48504, 50700, 34897, 50965, 49856, 48834, 50485, 39653, 49164, 49684, 39651, 48574, 39649, 49370, 49020, 34885, 34871, 43044, 48494, 47433, 3024, 47147, 3021, 47052, 46736, 36297, 39592, 36554, 46745, 36552, 42835, 46538, 46496, 45523, 42296, 42293, 40248, 40247, 40245, 40243, 46173, 37278, 40316, 43907, 45969, 41564, 45884, 44268, 44677, 44965, 45613, 45514, 45512, 42283, 44956, 34157, 45316, 41065, 42313, 43496, 44717, 44496, 43009, 43007, 44491, 44489, 44231, 42640, 43905, 42995, 33475, 43487, 43623, 43483, 43621, 44062, 43563, 35020, 43555, 43355, 30104, 43352, 43039, 39634, 43074, 43037, 43065, 42169, 25284, 39281, 39630, 42847, 41115, 40101, 40099, 32810, 27358, 35179, 39620, 41449, 41443, 41663, 39616, 39611, 34996, 40235, 39897, 39608, 40230, 34865, 39445, 34862, 39604, 34859, 39442, 39441, 39602, 33591, 39598, 25729, 36341, 31636, 31635, 40935, 35508))
Run Time: 0.108046
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2026 | |
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 | | | | | 2026 | |
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 (28936, 19302, 18795, 17516, 15535, 15386, 15356, 14971, 14692, 14353, 13940, 13910, 13825, 13821, 13772, 13480, 13427, 12990, 12870, 12805, 12559, 12530, 12485, 12382, 12370, 12349, 12304, 12253, 12217, 12160, 12065, 11960, 11864, 11854, 11726, 11591, 11473, 11464, 11453, 11449, 11436, 11412, 11317, 11161, 11129, 11073, 11024, 10895, 10787, 10775, 10520, 10485, 10474, 10310, 10284, 10197, 10121, 10104, 10084, 10005, 9937, 9925, 9916, 9904, 9780, 9744, 9729, 9635, 9628, 9618, 9615, 9556, 9528, 9527, 9450, 9425, 9192, 9179, 9158, 9125, 9089, 9023, 9020, 8967, 8961, 8945, 8794, 8706, 8677, 8607, 8578, 8523, 8503, 8421, 8319, 8250, 8154, 8151, 8074, 8010, 8005, 8000, 7843, 7811, 7778, 7604, 7543, 7530, 7504, 7417, 7403, 7289, 7232, 7199, 7187, 7157, 7079, 6769, 6726, 6703, 6697, 6661, 6646, 6498, 6484, 6480, 6414, 6359, 6358, 6304, 6301, 6294, 6287, 6195, 6146, 6061, 6050, 6000, 5957, 5587, 5586, 5583, 5549, 5449, 5432, 5364, 5196, 5072, 4680, 4496, 4464, 4404, 4201, 4166, 4016, 4012, 3983, 3973, 3875, 3841))
Run Time: 0.008801
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 160 | 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 (561726, 565963, 557384, 561714, 557380, 561702, 561700, 561693, 561690, 561685, 561682, 561679, 561674, 561671, 557365, 561666, 557363, 560781, 561664, 561653, 560778, 557361, 557359, 557355, 557350, 556719, 557348, 557332, 557315, 557314, 557312, 557309, 557307, 502317, 557305, 328053, 548835, 557302, 548806, 502280, 384075, 375418, 376704, 375373, 364236, 357546, 317530, 317529, 316147, 316019, 314218, 315156, 315154, 314276, 313556, 313707, 314210, 313701, 312594, 310734, 311130, 306868, 308200, 306866, 307285, 306822, 306819, 306566, 305742, 301354, 304848, 270509, 270502, 301397, 305095, 305093, 18294, 304573, 300509, 288121, 284993, 299408, 284989, 301014, 301085, 301133, 302953, 302946, 302443, 302401, 301129, 301070, 300894, 300505, 299489, 18292, 18290, 299405, 299403, 18287, 18285, 296444, 297483, 297306, 295424, 291006, 296439, 282720, 288107, 288103, 293766, 288136, 293761, 288134, 288131, 288129, 293840, 290700, 288731, 291637, 288729, 273119, 288725, 172022, 28569, 288723, 291227, 287926, 290081, 290073, 28567, 289735, 288717, 286573, 282972, 28563, 288040, 123435, 287924, 287403, 287661, 287500, 285729, 285727, 285005, 285720, 285940, 282714, 282711, 282707, 282704, 284845, 284841, 284466, 284464, 269617, 284424, 284456, 284422, 279980, 282809, 282808, 183916, 279477, 277702, 279475, 18269, 277698, 277685, 267611, 273547, 273544, 270231, 263609, 270225, 183905, 273108, 274075, 274073, 274071, 271320, 271570, 268071, 271566, 271562, 271560, 271541, 271317, 270752, 270728, 270748, 270746, 270995, 270817, 268687, 270938, 270815, 268683, 270796, 268681, 268680, 270674, 270672, 270670, 269589, 269902, 270589, 269900, 269899, 270587, 270186, 268149, 270294, 270050, 270209, 268060, 268058, 269963, 268794, 269720, 268054, 268145, 264622, 268143, 268479, 268476, 83470, 268029, 183199, 268045, 268042, 267913, 267403, 266479, 267282, 267394, 267269, 266937, 266935, 266673, 266933, 266959, 266669, 266930, 263771, 259504, 266667, 266514, 266169, 266166, 264810, 264788, 264654, 264264, 264245, 263896, 264372, 264135, 262375, 139295, 263239, 262200, 262186, 262181, 260963, 262164, 261588, 113981, 126122, 259804, 113979, 261418, 254726, 259798, 260473, 260471, 259305, 259418, 259303, 259501, 259499, 258455, 259299, 259316, 259310, 258327, 258216, 258110, 258104, 258099, 257926, 258097, 257617, 257607, 257226, 256878, 256556, 256402, 255474, 255471, 256386, 256384, 249924, 250286, 250223, 250174, 250559, 249921, 251025, 249919, 252982, 249915, 250799, 252921, 250102, 251022, 251019, 250064, 249984, 247638, 249939, 250434, 250408, 249895, 250405, 250039, 249006, 222321, 249488, 249454, 248912, 249294, 248992, 36848, 36846, 36834, 247373, 191214, 248883, 248704, 248702, 248303, 222232, 191211, 247919, 247912, 247810, 247634, 191210, 142913, 142909, 247371, 247369, 222603, 247499, 247341, 172017, 247339, 142907, 247468, 222677, 247337, 192585, 172006, 222654, 222549, 222301, 222246, 222497, 222295, 142889, 207908, 222083, 222063, 208518, 221964, 208511, 208510, 206570, 171332, 194850, 191208, 204135, 193259, 207290, 207107, 207236, 206536, 207018, 194837, 206928, 202742, 206821, 206750, 171324, 127046, 194960, 203814, 204815, 204793, 204369, 204367, 204343, 204190, 204331, 204330, 202048, 204094, 203833, 203932, 203803, 203826, 203573, 202281, 203542, 203425, 203540, 203487, 202481, 202472, 202469, 195360, 194740, 202246, 202234, 195358, 202459, 195356, 202457, 202380, 167080, 202202, 201724, 202066, 202024, 201977, 201711, 201975, 201824, 201803, 201745, 194948, 201799, 201737, 201523, 201357, 201521, 201497, 195244, 195351, 192618, 193724, 195063, 195059, 195175, 193709, 195173, 193960, 194715, 194936, 194919, 193438, 193436, 194880, 194806, 193929, 194834, 194699, 194689, 193696, 193866, 190933, 85568, 193819, 193857, 193921, 193910, 193433, 193428, 193906, 193798, 193796, 193850, 194011, 193511, 193671, 193224, 193496, 185500, 193413, 185498, 193077, 192901, 185496, 192930, 192811, 192892, 192146, 192237, 192729, 192807, 192016, 192572, 192569, 192516, 192566, 175597, 192454, 192300, 192137, 184078, 191989, 191988, 192056, 191973, 192118, 175645, 191584, 191324, 191200, 191198, 175634, 175626, 187709, 189649, 190931, 175623, 175621, 175619, 175618, 190360, 190356, 175612, 190580, 175609, 190270, 190265, 190260, 190145, 190091, 190088, 189979, 187312, 189914, 189645, 144147, 189156, 183451, 187956, 187861, 187858, 185490, 153636, 185487, 182634, 182627, 184657, 187195, 182624, 182264, 186953, 184146, 186891, 184144, 184142, 165057, 185078, 185433, 185481, 185058, 185387, 185049, 185045, 183990, 183988, 185020, 183178, 185038, 184787, 184225, 184358, 184055, 184117, 170620, 184109, 184026, 183357, 182291, 182288, 183565, 183171, 183421, 174848, 174846, 183112, 172944, 183101, 182367, 181981, 182539, 182280, 182192, 181739, 168211, 181718, 144455, 173874, 181082, 174831, 175523, 174958, 175521, 83179, 174955, 167166, 174952, 18252, 174741, 175127, 174977, 170287, 174937, 174806, 174933, 18249, 172793, 173056, 172790, 171986, 173840, 173535, 173092, 173076, 173087, 173070, 154888, 172897, 172767, 154885, 172821, 154883, 172511, 171052, 172505, 172286, 172321, 163255, 171310, 172126, 172124, 172122, 3039, 172120, 171959, 163251, 170933, 163249, 171836, 171141, 171139, 171137, 171283, 171279, 171275, 170650, 170583, 150658, 170930, 170696, 170928, 170578, 170647, 170383, 169872, 170375, 18239, 170264, 168497, 170442, 170232, 170230, 170193, 169364, 169265, 155204, 169963, 170056, 169989, 169528, 165750, 169469, 169523, 155202, 169334, 169144, 168008, 169138, 169400, 167381, 168945, 169011, 168493, 168658, 168484, 167990, 123681, 123679, 167247, 166913, 166985, 166911, 164046, 166779, 166777, 166835, 166831, 166507, 166649, 166498, 161359, 160614, 134381, 134375, 164300, 166177, 166172, 165088, 164714, 165781, 113910, 165536, 165697, 164816, 164378, 164508, 164497, 163807, 163794, 163678, 163333, 155694, 163279, 163276, 162957, 155692, 162955, 163224, 162942, 162724, 162810, 18233, 162323, 18230, 162720, 18228, 18227, 161557, 134507, 162062, 162185, 141663, 162087, 141660, 141658, 161574, 160980, 160494, 159961, 158685, 83157, 148678, 159591, 153823, 157088, 159858, 159576, 159651, 159536, 159045, 158506, 159297, 159026, 159015, 159011, 156481, 156479, 158205, 156152, 157353, 157919, 156982, 149371, 157460, 157015, 96134, 157321, 156975, 157014, 156772, 96127, 96125, 154163, 154158, 156185, 156174, 156167, 155782, 155662, 155643, 155728, 155487, 154347, 153954, 149295, 154893, 153950, 149263, 149255, 154095, 154094, 150877, 153773, 153943, 153941, 152758, 152754, 152739, 151588, 139290, 153725, 153712, 152098, 153488, 153280, 134487, 153241, 153068, 152679, 152654, 147796, 152463, 152460, 149161, 149159, 149155, 149141, 151166, 151164, 151162, 151813, 149808, 151255, 151810, 151145, 152084, 96966, 151835, 149095, 149073, 151801, 149055, 151451, 151576, 151080, 150602, 150597, 149823, 150760, 149025, 148381, 151078, 149928, 149007, 150935, 148979, 150792, 148947, 139276, 148941, 150531, 148923, 150258, 148919, 147197, 148899, 139273, 149950, 139271, 148797, 148786, 148784, 148776, 149518, 149516, 148773, 133920, 148750, 148500, 148583, 148579, 148460, 148575, 147826, 148022, 148454, 146741, 147537, 148415, 147534, 148386, 148395, 148410, 145142, 148392, 148018, 147526, 147523, 139251, 146548, 148210, 127953, 148159, 148155, 139244, 148153, 139240, 139239, 139237, 139234, 139233, 139231, 147992, 139229, 148042, 147366, 113904, 147545, 146104, 147542, 146098, 147193, 147361, 147096, 147091, 147085, 147111, 147081, 147073, 146063, 147009, 146046, 146900, 146946, 146017, 146893, 144144, 146646, 144141, 146507, 145423, 144757, 144828, 145421, 146186, 94657, 145656, 145391, 145417, 144120, 139223, 145074, 144813, 144811, 139211, 139209, 139207, 139204, 145014, 143981, 143979, 143977, 144740, 144663, 143963, 143959, 144172, 143793, 142054, 142052, 142050, 114532, 143656, 142038, 142032, 143945, 137401, 143943, 85532, 137398, 143790, 121857, 126571, 126569, 143652, 143560, 143647, 134361, 142497, 143350, 139159, 139154, 139147, 129858, 129856, 142625, 139086, 139083, 141433, 141427, 71658, 139058, 134467, 139043, 142076, 141393, 137188, 140263, 141267, 138531, 138529, 138526, 141473, 141478, 141256, 141254, 140530, 140739, 140406, 140397, 138477, 128326, 140131, 128325, 140121, 140017, 137958, 138560, 138810, 139579, 138804, 124953, 139632, 124942, 138149, 134358, 133466, 138271, 114528, 114527, 18222, 18201, 138206, 138201, 133818, 138308, 18189, 138446, 18173, 133812, 133807, 138193, 138191, 138102, 137378, 137376, 18166, 18163, 137346, 126563, 136993, 127629, 134585, 136172, 126891, 137384, 136032, 127627, 134955, 134953, 135970, 135423, 136323, 135958, 135876, 135912, 135874, 129633, 126518, 126512, 126508, 135266, 134310, 135145, 127035, 134997, 135149, 133464, 134579, 135045, 127030, 127205, 135008, 135016, 133831, 127201, 134302, 133461, 133861, 128399, 134665, 134418, 133459, 113156, 123053, 129648, 134576, 130171, 134236, 134274, 123051, 134285, 130303, 134283, 129941, 133762, 133760, 133447, 133444, 133689, 133441, 129625, 129623, 116005, 133439, 133434, 130403, 130399, 129910, 130141, 129894, 130184, 129883, 129882, 130056, 128582, 128068, 128579, 128577, 116003, 129602, 129662, 129702, 118001, 129585, 129289, 126414, 59641, 128152, 120822, 125670, 127897, 128122, 127873, 124866, 114525, 126368, 126868, 123386, 124864, 126935, 126858, 126363, 126361, 124836, 126094, 125663, 126062, 126039, 125300, 125421, 125644, 125641, 116001, 125413, 125559, 125408, 125405, 125404, 125317, 125458, 125353, 125298, 125313, 125308, 125275, 124471, 124800, 125006, 85298, 124709, 79874, 121420, 124038, 123668, 123666, 85702, 124379, 123510, 124022, 85700, 124233, 123662, 121195, 123995, 124117, 123987, 122787, 123612, 59150, 123743, 93303, 123341, 123288, 93300, 123109, 122213, 86080, 121802, 121491, 121216, 121481, 121388, 117858, 117955, 121210, 118447, 117852, 120109, 118776, 114481, 118442, 114478, 116922, 117821, 117047, 114460, 116846, 116914, 116174, 76968, 116376, 116374, 116392, 100602, 116371, 115924, 113677, 115855, 114303, 102631, 114299, 115834, 115682, 115831, 102617, 102615, 102613, 114695, 113121, 114403, 114761, 113564, 114552, 114759, 114734, 113546, 113539, 113518, 113504, 114400, 101308, 114229, 114135, 114220, 113614, 112744, 91626, 102144, 113490, 113452, 102137, 112933, 112927, 113338, 112923, 112915, 112738, 112616, 102135, 112730, 112614, 112908, 113000, 112903, 112883, 112714, 112881, 112837, 112788, 112704, 112316, 112701, 112699, 112694, 111892, 112476, 112300, 83292, 83290, 112200, 112216, 101829, 103329, 111883, 80428, 111880, 111876, 111840, 18157, 111835, 101304, 18155, 111869, 111900, 111823, 100917, 100915, 111816, 109290, 111147, 111471, 97254, 111448, 110949, 111325, 111136, 111343, 111116, 111131, 111027, 109342, 103300, 109333, 103342, 101200, 103259, 97242, 98978, 103011, 102514, 98975, 102511, 100730, 102449, 101767, 101650, 102117, 102115, 100547, 100543, 100538, 101498, 101493, 84398, 100509, 97105, 97710, 98151, 97099, 96603, 98349, 97933, 97445, 97626, 97617, 97339, 97322, 97319, 97168, 97061, 88965, 97056, 95666, 92943, 88955, 96270, 96660, 96259, 95899, 94808, 94806, 81308, 95436, 81292, 81279, 94160, 93717, 81263, 93710, 81240, 93266, 93036, 92853, 92718, 92836, 92725, 92506, 89852, 79800, 79795, 91682, 89800, 88931, 87749, 89361, 88728, 89200, 79784, 79780, 88632, 85924, 84512, 85923, 84500, 88490, 88486, 86500, 88477, 59638, 87443, 84492, 87348, 88134, 76831, 87544, 88128, 87732, 59635, 87415, 59631, 87413, 87412, 59629, 87344, 59625, 87265, 85736, 87042, 86614, 86687, 86887, 86886, 76714, 85734, 86426, 86076, 85731, 86553, 86132, 86074, 73700, 85879, 85720, 84833, 85385, 85343, 79921, 85465, 83267, 84828, 84850, 84785, 84893, 84887, 84781, 84803, 84486, 83887, 82555, 83865, 83780, 83446, 81388, 80948, 83280, 83586, 82684, 83442, 83130, 82752, 82384, 82383, 83274, 83093, 82784, 83016, 82998, 82993, 81386, 79747, 82542, 79745, 82539, 79742, 82896, 81382, 82533, 82646, 80922, 82368, 81777, 72747, 81123, 81548, 81859, 81944, 81724, 81650, 81933, 81630, 81622, 81614, 81532, 81208, 80755, 80754, 81425, 80750, 81196, 80748, 81059, 80938, 80936, 79462, 80737, 80630, 79721, 80393, 80137, 80391, 80386, 80359, 80077, 79715, 79486, 79705, 64895, 79457, 77723, 78221, 79256, 79418, 79438, 79395, 77256, 79245, 78940, 78938, 78646, 78640, 78891, 78930, 78633, 78928, 78627, 79140, 78624, 78985, 78617, 79009, 78603, 77718, 78976, 76088, 79045, 64507, 18134, 77119, 78515, 78411, 78116, 78102, 76313, 77681, 77668, 77066, 76954, 77654, 76726, 74754, 77247, 77266, 77012, 76995, 76058, 76791, 76894, 76662, 76592, 76680, 18109, 76437, 76398, 76039, 76393, 76372, 75833, 76211, 74644, 76181, 75867, 75636, 75798, 70107, 75878, 75795, 75869, 75735, 75308, 70098, 75315, 75578, 75495, 75304, 75328, 74722, 74718, 75180, 74398, 74537, 66197, 74534, 73563, 72523, 72521, 64357, 74406, 74404, 74298, 74332, 73931, 73555, 74189, 72885, 73488, 73487, 73550, 69313, 73156, 73993, 73152, 72699, 73545, 73543, 73476, 73571, 73623, 73585, 73508, 73242, 73364, 73357, 73582, 72360, 73043, 66195, 71710, 69150, 63252, 72453, 72779, 72353, 70336, 67402, 72337, 72267, 72177, 71817, 71688, 64331, 60894, 71577, 71575, 71367, 69044, 71905, 71748, 71561, 68209, 71522, 69037, 69899, 70774, 71364, 71282, 60435, 71052, 70951, 70311, 70207, 70206, 70205, 70949, 70200, 70946, 70407, 70510, 70405, 70402, 70388, 70010, 70350, 69992, 70177, 70050, 70140, 70123, 70070, 69988, 67394, 67163, 69542, 67686, 69561, 69738, 69705, 69532, 67574, 68345, 68626, 67572, 69293, 67392, 69322, 67388, 64884, 68723, 68866, 68609, 68006, 68715, 67989, 68187, 68433, 18068, 67986, 67623, 63010, 67386, 67533, 67544, 67369, 67366, 66722, 65975, 67096, 66659, 67077, 65874, 66190, 66233, 66051, 66049, 66070, 65776, 60208, 57026, 65075, 64874, 59598, 64514, 63428, 59593, 64699, 63629, 62681, 59588, 62677, 62675, 59745, 59585, 63143, 39675, 63463, 63462, 63458, 63452, 62705, 61188, 62702, 45709, 61698, 54148, 61043, 61182, 60194, 61178, 60214, 60622, 60724, 60590, 60430, 60455, 57706, 58251, 60187, 60267, 56757, 59583, 56755, 56754, 58737, 58237, 59035, 57704, 58321, 58420, 58192, 58072, 57478, 57620, 57733, 57824, 57864, 57568, 57441, 57440, 57694, 50221, 57721, 57367, 57365, 57431, 56902, 55555, 53873, 55830, 44299, 41460, 56250, 56266, 56263, 56132, 54465, 55875, 55817, 56025, 35347, 44292, 55909, 18036, 18035, 55812, 55907, 55810, 18031, 55808, 45509, 18019, 18017, 54095, 54948, 54491, 18012, 54087, 53134, 53125, 43133, 53019, 34900, 35334, 52518, 52764, 52785, 50401, 52135, 52739, 52494, 51933, 52351, 51625, 48504, 50700, 34897, 50965, 49856, 48834, 50485, 39653, 49164, 49684, 39651, 48574, 39649, 49370, 49020, 34885, 34871, 43044, 48494, 47433, 3024, 47147, 3021, 47052, 46736, 36297, 39592, 36554, 46745, 36552, 42835, 46538, 46496, 45523, 42296, 42293, 40248, 40247, 40245, 40243, 46173, 37278, 40316, 43907, 45969, 41564, 45884, 44268, 44677, 44965, 45613, 45514, 45512, 42283, 44956, 34157, 45316, 41065, 42313, 43496, 44717, 44496, 43009, 43007, 44491, 44489, 44231, 42640, 43905, 42995, 33475, 43487, 43623, 43483, 43621, 44062, 43563, 35020, 43555, 43355, 30104, 43352, 43039, 39634, 43074, 43037, 43065, 42169, 25284, 39281, 39630, 42847, 41115, 40101, 40099, 32810, 27358, 35179, 39620, 41449, 41443, 41663, 39616, 39611, 34996, 40235, 39897, 39608, 40230, 34865, 39445, 34862, 39604, 34859, 39442, 39441, 39602, 33591, 39598, 25729, 36341, 31636, 31635, 40935, 35508))
Run Time: 0.051408
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2026 | |
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 | | | | | 2026 | |
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 (28936, 19302, 18795, 17516, 15535, 15386, 15356, 14971, 14692, 14353, 13940, 13910, 13825, 13821, 13772, 13480, 13427, 12990, 12870, 12805, 12559, 12530, 12485, 12382, 12370, 12349, 12304, 12253, 12217, 12160, 12065, 11960, 11864, 11854, 11726, 11591, 11473, 11464, 11453, 11449, 11436, 11412, 11317, 11161, 11129, 11073, 11024, 10895, 10787, 10775, 10520, 10485, 10474, 10310, 10284, 10197, 10121, 10104, 10084, 10005, 9937, 9925, 9916, 9904, 9780, 9744, 9729, 9635, 9628, 9618, 9615, 9556, 9528, 9527, 9450, 9425, 9192, 9179, 9158, 9125, 9089, 9023, 9020, 8967, 8961, 8945, 8794, 8706, 8677, 8607, 8578, 8523, 8503, 8421, 8319, 8250, 8154, 8151, 8074, 8010, 8005, 8000, 7843, 7811, 7778, 7604, 7543, 7530, 7504, 7417, 7403, 7289, 7232, 7199, 7187, 7157, 7079, 6769, 6726, 6703, 6697, 6661, 6646, 6498, 6484, 6480, 6414, 6359, 6358, 6304, 6301, 6294, 6287, 6195, 6146, 6061, 6050, 6000, 5957, 5587, 5586, 5583, 5549, 5449, 5432, 5364, 5196, 5072, 4680, 4496, 4464, 4404, 4201, 4166, 4016, 4012, 3983, 3973, 3875, 3841))
Run Time: 0.004482
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 160 | 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.000243
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: ���, XF\Pub\Controller\Member, RecentContent, valid, user_id=1249, 1716167546, , 0, ���
Run Time: 0.000125
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000277
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.000517
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: 1716167246
Run Time: 0.000361
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 29 | 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` >= 1716167246)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000472
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 29 | 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