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.000637
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.000251
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` = '2275')
LIMIT 1
Run Time: 0.000567
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.002382
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_2275' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.132654
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 (577773, 577770, 577768, 367629, 577766, 526411, 234968, 577764, 234966, 234960, 577576, 468730, 577742, 577691, 622187, 221297, 576786, 614655, 577709, 577706, 576783, 245577, 245575, 572857, 200556, 577690, 513477, 200554, 245573, 614653, 572854, 572852, 221294, 572850, 571505, 346874, 346872, 614651, 245572, 576774, 577702, 576769, 513475, 577700, 314694, 279868, 577688, 346867, 577687, 570849, 434778, 545963, 434772, 434768, 434766, 545960, 434763, 434761, 577671, 577678, 434758, 549748, 549745, 349583, 549743, 542214, 434747, 360077, 570847, 349582, 434743, 349580, 434741, 349578, 434735, 577625, 349576, 234948, 234942, 487419, 234940, 367624, 349573, 434722, 234932, 434718, 527770, 622178, 234925, 234923, 530893, 234920, 221261, 349572, 575296, 61959, 376406, 575292, 234917, 234914, 349570, 576010, 349568, 349567, 349562, 234910, 539517, 234907, 420298, 369232, 420293, 234902, 577568, 234900, 570400, 434712, 376393, 234896, 530881, 577573, 376391, 234894, 391979, 576691, 391977, 376389, 391975, 368305, 530880, 514660, 368303, 234890, 376387, 434707, 514658, 550007, 368301, 577562, 550005, 346855, 550003, 576943, 576941, 577555, 577552, 530879, 577550, 539513, 434701, 434699, 530878, 530876, 485929, 234877, 577489, 234875, 577454, 166598, 166596, 166594, 412427, 377207, 166591, 412424, 555278, 555276, 166588, 555274, 576750, 377205, 221248, 200509, 368299, 412419, 221243, 576665, 577406, 562872, 200498, 412414, 577395, 200494, 577391, 234861, 221239, 576874, 335894, 221237, 221235, 434574, 434572, 434570, 434568, 434566, 434564, 530838, 200493, 576871, 200491, 577373, 200488, 434559, 434557, 434555, 434553, 245545, 200486, 245543, 530827, 434550, 234854, 576864, 434548, 234852, 434545, 221233, 200485, 573358, 573356, 221230, 234849, 234847, 221228, 577378, 522681, 200483, 522680, 269082, 269080, 200480, 269078, 234828, 522674, 577328, 485920, 522668, 577324, 554710, 485917, 434467, 485915, 522666, 530810, 485913, 221225, 434460, 434458, 434456, 434454, 614637, 570340, 434451, 434449, 570338, 434444, 434440, 570336, 434438, 577143, 434428, 530803, 530801, 574847, 221221, 245518, 549739, 234813, 369452, 369450, 369448, 369446, 434420, 549737, 530798, 434418, 369444, 434415, 434412, 570841, 614634, 576158, 434408, 221218, 368298, 234804, 570838, 514644, 523608, 200474, 554708, 200472, 434393, 577242, 434390, 577239, 434385, 614632, 434382, 234802, 577202, 577200, 577092, 434269, 536698, 415114, 576608, 576605, 200464, 346851, 576638, 368296, 200461, 245495, 576601, 374945, 576621, 576585, 576226, 576617, 576615, 556771, 485895, 333933, 566666, 566663, 566641, 424501, 301187, 196016, 180416, 301183, 195770, 279047, 301180, 305732, 179913, 179862, 302358, 179850, 302355, 179846, 302221, 179844, 302027, 195731, 263989, 210301, 179843, 262844, 251689, 223183, 267234, 300751, 267217, 299718, 179829, 300474, 179810, 299613, 210228, 21974, 195721, 279777, 262836, 179618, 179610, 179572, 270037, 270022, 179007, 203644, 182981, 270120, 270112, 270110, 265780, 270086, 262729, 262727, 178916, 178914, 178913, 270002, 270001, 43801, 209527, 256915, 122613, 209519, 209510, 269651, 269829, 269819, 178887, 269817, 269814, 178884, 235410, 184546, 269798, 269796, 262724, 178879, 262718, 269639, 188341, 178855, 209490, 178852, 269340, 269553, 269488, 257116, 182979, 269447, 209449, 182973, 266309, 178820, 178818, 269411, 178810, 266306, 209419, 268726, 262698, 209401, 268527, 222945, 222939, 268517, 266303, 268285, 178633, 268261, 268280, 178621, 178620, 268240, 268238, 178615, 268228, 178604, 182950, 268018, 267097, 266541, 263460, 267017, 267798, 268075, 263457, 209354, 267813, 266917, 267792, 267732, 267790, 249414, 267011, 267787, 267784, 178529, 249406, 266914, 254836, 266912, 266999, 266603, 267197, 266990, 267084, 265672, 267195, 265668, 266907, 266601, 267389, 267193, 267265, 267188, 209348, 265666, 267184, 267130, 266653, 266597, 266595, 209346, 266593, 178499, 235369, 20182, 235367, 194506, 267081, 266590, 131201, 235359, 235357, 266904, 266899, 266582, 265632, 263312, 263310, 263309, 266861, 266860, 266740, 266771, 266858, 266856, 263304, 615251, 77358, 109580, 266730, 266695, 266719, 266690, 251419, 266526, 266523, 256297, 259218, 266576, 259214, 259212, 178451, 259210, 178448, 266487, 263953, 178405, 178403, 178401, 178395, 254020, 266457, 266455, 178364, 178362, 178360, 178357, 51284, 178332, 178328, 178326, 178320, 178318, 265305, 265302, 266371, 263184, 178283, 209327, 178280, 263178, 178278, 178275, 266211, 209320, 266206, 266204, 209316, 178246, 182940, 182938, 266277, 178236, 178234, 261988, 318866, 178232, 266244, 178230, 178219, 266183, 178205, 265604, 178176, 253989, 143530, 104253, 178153, 178151, 178148, 178145, 178143, 178139, 178137, 261380, 261377, 261374, 182935, 253986, 253984, 261486, 253966, 209307, 256754, 262652, 178100, 178097, 615249, 265139, 615247, 265136, 253957, 615245, 178081, 204968, 253954, 257424, 265071, 178056, 253943, 178054, 253941, 178046, 253937, 178044, 253935, 178041, 257422, 178009, 186756, 104229, 209298, 177980, 257552, 186745, 186735, 177961, 177953, 264897, 177950, 264895, 264979, 177948, 177946, 104222, 264880, 264877, 264874, 264996, 264872, 104220, 264869, 264902, 264842, 177906, 251370, 177878, 177868, 177818, 259207, 264462, 259205, 264453, 264451, 259202, 259199, 262145, 262139, 177814, 260087, 264395, 260766, 264187, 260763, 263415, 263413, 264184, 177781, 177780, 177775, 177773, 177771, 263939, 247578, 263819, 263937, 263859, 262035, 263855, 177759, 209284, 260758, 260756, 260754, 262091, 318892, 256529, 263663, 263604, 262125, 263531, 263080, 263591, 202118, 263503, 263501, 263566, 209265, 182929, 262590, 177680, 202115, 263129, 262580, 263386, 262577, 262573, 209259, 262641, 263123, 263375, 260751, 260743, 262633, 263194, 262629, 263190, 263188, 262536, 262628, 262626, 262520, 262613, 262612, 262611, 177618, 262500, 177551, 177548, 261911, 262010, 261965, 318843, 177526, 261898, 177504, 209209, 177496, 182925, 261784, 255687, 256280, 261676, 256276, 256273, 261674, 256271, 182922, 261620, 256269, 261672, 177484, 186655, 177472, 259056, 259054, 177471, 251316, 259052, 261635, 261638, 256261, 177455, 177454, 256258, 177422, 261472, 261470, 177414, 177355, 209182, 209180, 209177, 177353, 261329, 131040, 260730, 260727, 260722, 261129, 260720, 260497, 260493, 260484, 177280, 260476, 259429, 177098, 193017, 259000, 259253, 209120, 259235, 177001, 176959, 258892, 258890, 258886, 204957, 258200, 202558, 202555, 202550, 202547, 257369, 258732, 257085, 248664, 203641, 256451, 258145, 258611, 255648, 258194, 257982, 257981, 258135, 248645, 258033, 258031, 258026, 257961, 257877, 257816, 257282, 257280, 255612, 176806, 184595, 184591, 254276, 257239, 195443, 186393, 256010, 186389, 251226, 256909, 256978, 186368, 208989, 256725, 251208, 251207, 256715, 256784, 251206, 256739, 256665, 256676, 256654, 256647, 222211, 254244, 256546, 256510, 176723, 255976, 255971, 255138, 130901, 255125, 176699, 255052, 254972, 254969, 254869, 253412, 253404, 222406, 254179, 254167, 253457, 222401, 253449, 253448, 248630, 248629, 103962, 251123, 253385, 208579, 208899, 253048, 176621, 176619, 176617, 253143, 253045, 253044, 253124, 249961, 250933, 253121, 251092, 253027, 252917, 252962, 248605, 176544, 176540, 249789, 249351, 249243, 248418, 176463, 176460, 248414, 208739, 615228, 615224, 207674, 204535, 191660, 204373, 191657, 204361, 204355, 191651, 204121, 130692, 204012, 203748, 203617, 202866, 174629, 174627, 202859, 203320, 202847, 202199, 203217, 615182, 615176, 203215, 202721, 195271, 202151, 202500, 615156, 202146, 202088, 201565, 202110, 201563, 201559, 201982, 201404, 201753, 201549, 140859, 140853, 201355, 193558, 201438, 195387, 195384, 191643, 191641, 195324, 195168, 195282, 195261, 195259, 195256, 195254, 195252, 195250, 195213, 195211, 193142, 194216, 195161, 195159, 193140, 195156, 194213, 194865, 194860, 195142, 194858, 195139, 195089, 195077, 195074, 159260, 194952, 194295, 193313, 194785, 194779, 194771, 189862, 194766, 194765, 194609, 161684, 194602, 194333, 194327, 194324, 194320, 161681, 615152, 615150, 194094, 194091, 193983, 194053, 122549, 189394, 193540, 122547, 193310, 193308, 193129, 193306, 193518, 192757, 192303, 192299, 192344, 192297, 192246, 187812, 192179, 192244, 189387, 191377, 191152, 176205, 176203, 191236, 158996, 191146, 174608, 189569, 191051, 189566, 176176, 189564, 176167, 190689, 176129, 190759, 187626, 190620, 189551, 189549, 176116, 176111, 176107, 176103, 176097, 176093, 176091, 176086, 176084, 176081, 176079, 182483, 176078, 190222, 176075, 190079, 176071, 190570, 190563, 190559, 190554, 187436, 190382, 156603, 163884, 190214, 163882, 190194, 190191, 190190, 190188, 190179, 182910, 190042, 190050, 189902, 189837, 189874, 158103, 189461, 189865, 175984, 175983, 188217, 188587, 188549, 189303, 189362, 188544, 188533, 188262, 188530, 188384, 186138, 188406, 188403, 188325, 188380, 188400, 188195, 188079, 188023, 187742, 188021, 187942, 181851, 187393, 187442, 175970, 187440, 181848, 187431, 187426, 187515, 187721, 187694, 187482, 182235, 174594, 187451, 174591, 187421, 174589, 175955, 175953, 174586, 187419, 181145, 187364, 165023, 186877, 184837, 175947, 175941, 186113, 186799, 185995, 185977, 185993, 185988, 141908, 145204, 185910, 185908, 185973, 175928, 185905, 185631, 185629, 185653, 185785, 185649, 175921, 182889, 185645, 185584, 185641, 155434, 185582, 182886, 175917, 174539, 155428, 175675, 184273, 175672, 185251, 182878, 175670, 185212, 175893, 185155, 175874, 161233, 184795, 184811, 184264, 184780, 184728, 184677, 184725, 183633, 184477, 184716, 184316, 184257, 184582, 184643, 184457, 184455, 184573, 184571, 184639, 184623, 184449, 184569, 184442, 184437, 184297, 184307, 184195, 184192, 181837, 182868, 182867, 184245, 181833, 182864, 182860, 182857, 157261, 183241, 183690, 183233, 183458, 182836, 182783, 175847, 182213, 182819, 175838, 182763, 137697, 168057, 175835, 182688, 122513, 122510, 182189, 182177, 175047, 175813, 175797, 181823, 175787, 181584, 181265, 181573, 175780, 181655, 175766, 181380, 174118, 181041, 174788, 175071, 174522, 175149, 174101, 175025, 174512, 174498, 174015, 174781, 174735, 174701, 174733, 174471, 173999, 173972, 130676, 173861, 173855, 173836, 172840, 172987, 173016, 173421, 130653, 130649, 130643, 130640, 173413, 172977, 130638, 130632, 130630, 161992, 168353, 172527, 155343, 168348, 171173, 172049, 171566, 172046, 122438, 171103, 170950, 170778, 170885, 170774, 170770, 170762, 170329, 168850, 145189, 170499, 160391, 170128, 168835, 168343, 168341, 169728, 140663, 164579, 168331, 169375, 167342, 169204, 168328, 168326, 168732, 168637, 169242, 168632, 169193, 168630, 169186, 168794, 164567, 168556, 166667, 168765, 167434, 165987, 166303, 168390, 167432, 167544, 166300, 168323, 166665, 166297, 166663, 168382, 155988, 168549, 168541, 168425, 168267, 168320, 168377, 168375, 168397, 168369, 168246, 168357, 168131, 167791, 164560, 167569, 166918, 32756, 167531, 167464, 167334, 122383, 164923, 166820, 167235, 167453, 167419, 167316, 162263, 162261, 162259, 162256, 123399, 167058, 167048, 166265, 166262, 166574, 158017, 158275, 160966, 165978, 165430, 165918, 165428, 164280, 164279, 165802, 165801, 165817, 165684, 165676, 165554, 165674, 165570, 164987, 165436, 158267, 163993, 164170, 125155, 164088, 161669, 127779, 164166, 163973, 161667, 163365, 162986, 127767, 127764, 154805, 163186, 163150, 163348, 161657, 162554, 163080, 163141, 163078, 163071, 163068, 163087, 163056, 163066, 162980, 125143, 143332, 162674, 162427, 161652, 159911, 162367, 159906, 162216, 161647, 144779, 161642, 161640, 158263, 161406, 161404, 158260, 161545, 161543, 161218, 161510, 161491, 161520, 144775, 161377, 158255, 161374, 161397, 161209, 158653, 158652, 161369, 160405, 158647, 161305, 158645, 161165, 161313, 150846, 161206, 161205, 160890, 158941, 161202, 161163, 159755, 160761, 161298, 161280, 161187, 161158, 161185, 158638, 159254, 160361, 160357, 158925, 159250, 160885, 161122, 157834, 160283, 160882, 143771, 161058, 159245, 159244, 160998, 160757, 123026, 160945, 161032, 159241, 159885, 122351, 159239, 159751, 159227, 160752, 159216, 160327, 160897, 160350, 160057, 159525, 159677, 158917, 159881, 160031, 160047, 160044, 160041, 159783, 160038, 160036, 160029, 159455, 159451, 155969, 155956, 158478, 157203, 158730, 122345, 159506, 159315, 158898, 159624, 158237, 159621, 158890, 159515, 155322, 159180, 142388, 158882, 157620, 130578, 159177, 159482, 159173, 159494, 159309, 159330, 159328, 159165, 142380, 159144, 142370, 159142, 159140, 159083, 142358, 159069, 158096, 159067, 158589, 158635, 158632, 158854, 158852, 158847, 158576, 158574, 158379, 158724, 158787, 158563, 158617, 158093, 158706, 158089, 158175, 158547, 134147, 158419, 158426, 158409, 155719, 158169, 158396, 158167, 158164, 152404, 158248, 158246, 157186, 158244, 152397, 158161, 158159, 152395, 158086, 150476, 155898, 157272, 157595, 157441, 155316, 157051, 157541, 157049, 157538, 155311, 157045, 157409, 156805, 156211, 156932, 155309, 157041, 156719, 156042, 156593, 156037, 156034, 156674, 156598, 151686, 155594, 156078, 156578, 156200, 156068, 156030, 156276, 156274, 156265, 156255, 156253, 155307, 155304, 155302, 155044, 155300, 155004, 154995, 154632, 154911, 154791, 154419, 154627, 154789, 154702, 154453, 154451, 154620, 154442, 154390, 148339, 154382, 154438, 134146, 134145, 154401, 154398, 122330, 148334, 153974, 130541, 153972, 130535, 153873, 152847, 153970, 153035, 152857, 153871, 153938, 153968, 153930, 153868, 153693, 152843, 146150, 152839, 153681, 143495, 146148, 153616, 143493, 153514, 146145, 143491, 153439, 153092, 153437, 153507, 153433, 153431, 153417, 153415, 153428, 153468, 153465, 153215, 153407, 153425, 153404, 138267, 153422, 153400, 152504, 153085, 152590, 137867, 153082, 152390, 152983, 152981, 152586, 153009, 151756, 152978, 152388, 130520, 152976, 137863, 152970, 152994, 137854, 143489, 152957, 137619, 134140, 137617, 152555, 152822, 152816, 152499, 152549, 152378, 152570, 152523, 152497, 152529, 152376, 152367, 152422, 151397, 150300, 151524, 150438, 122314, 140796, 152240, 151710, 140791, 151671, 147063, 151491, 151389, 103630, 150472, 152068, 151955, 150469, 151382, 150205, 152048, 150982, 152045, 151380, 151377, 151979, 151680, 151942, 151368, 151861, 151678, 148331, 151702, 151609, 150464, 151653, 151607, 151600, 151603, 150462, 151437, 151435, 151433, 150572, 151429, 103621, 150458, 150296, 151427, 151361, 151359, 151356, 151353, 151404, 151297, 151400, 151295, 148240, 151205, 150294, 151232, 151230, 103615, 148085, 150546, 148083, 137644, 134137, 137642, 151197, 137640, 148081, 151246, 151244, 145183, 151226, 150799, 150342, 150340, 148236, 150729, 150288, 150794, 150836, 150727, 150522, 148327, 148326, 150680, 150723, 150678, 150721, 150453, 150514, 150200, 150198, 150505, 148079, 148322, 149602, 149600, 148319, 144322, 149587, 149584, 148317, 148315, 148076, 149578, 103603, 148313, 148074, 149575, 149469, 138394, 148728, 148445, 147706, 148602, 148553, 148310, 148299, 146410, 148405, 148297, 148224, 148073, 148292, 148071, 148171, 147881, 112809, 143484, 147646, 145437, 122289, 122283, 147414, 146715, 147411, 143551, 143549, 122279, 143388, 146920, 147043, 145169, 146918, 86492, 86490, 134132, 146916, 146877, 146976, 146972, 146021, 146970, 146912, 146013, 146681, 140628, 146874, 145994, 145990, 146403, 145986, 140625, 146805, 146676, 146399, 146173, 146674, 146397, 137977, 146644, 146771, 146633, 134127, 146607, 145225, 134125, 134123, 100003, 141791, 142480, 145223, 43773, 145221, 146306, 146391, 146559, 146388, 146386, 146375, 146372, 146163, 146369, 146357, 146355, 146351, 146126, 146248, 146122, 144934, 144932, 144930, 144928, 146179, 146159, 143769, 146228, 146116, 144925, 143385, 146176, 143267, 88027, 143480, 146109, 145459, 145163, 143478, 144919, 145159, 144917, 143764, 143472, 143324, 145456, 145210, 145356, 145207, 143322, 88019, 145373, 145402, 145351, 145156, 143760, 143927, 143752, 143925, 143748, 143746, 122275, 143737, 143731, 144849, 125056, 144830, 125051, 144770, 144793, 144764, 143468, 143466, 141899, 143463, 143461, 144382, 142140, 103598, 125927, 103587, 103584, 103569, 103566, 143918, 143916, 142355, 144045, 138265, 144043, 143416, 144014, 137722, 144041, 143899, 142353, 143819, 143406, 141787, 140389, 143300, 143261, 143258, 143063, 139467, 139770, 127740, 142978, 140609, 142613, 142558, 142605, 142601, 141697, 142327, 139460, 141695, 141692, 141690, 139458, 141892, 141785, 139456, 141741, 139454, 142476, 139450, 141853, 139989, 139987, 139985, 141843, 142206, 139439, 138260, 140280, 140277, 142126, 142124, 137232, 142122, 141688, 141889, 142089, 141683, 141884, 141883, 141838, 141914, 141679, 141879, 141863, 141934, 141968, 141931, 141835, 141965, 141830, 141861, 141821, 141724, 141715, 141674, 141713, 140275, 141708, 141706, 140077, 141704, 141729, 141511, 139719, 140075, 137586, 140272, 139716, 140754, 140268, 140598, 137584, 137582, 140049, 140148, 139937, 140145, 139694, 122913, 139757, 139539, 138259, 122902, 138256, 139871, 139368, 118771, 138248, 122894, 139410, 138246, 122890, 139528, 139407, 139514, 118769, 139512, 138245, 122887, 138379, 139400, 118766, 139364, 122884, 139362, 116351, 135781, 139311, 116349, 86485, 139309, 137496, 138412, 137494, 138241, 138239, 138237, 138235, 138051, 137983, 138233, 135775, 138231, 138228, 138048, 134080, 138046, 138041, 138039, 137747, 138037, 138226, 138034, 137783, 137970, 137968, 137743, 137781, 137780, 137636, 137759, 137777, 134608, 137313, 130478, 137730, 137728, 135635, 137715, 137627, 137489, 137625, 136232, 137536, 137534, 137481, 137475, 123395, 137308, 135836, 135408, 135834, 135406, 135401, 136237, 135633, 121785, 135631, 135629, 135627, 135623, 135446, 135825, 135823, 135621, 135675, 126110, 85526, 135673, 135619, 135728, 135499, 135559, 135494, 135491, 135440, 135303, 126264, 135301, 123229, 135351, 125050, 135396, 135247, 135223, 135220, 135233, 135205, 135218, 135201, 128199, 128195, 135099, 128193, 134913, 134677, 134908, 134906, 134902, 134878, 134059, 134597, 134182, 128678, 134569, 134158, 134055, 134564, 134591, 134603, 134155, 134518, 133481, 134515, 134116, 134048, 134045, 128259, 128257, 134224, 128255, 133478, 133979, 134114, 134176, 134112, 121775, 134154, 134109, 121753, 121751, 121749, 134097, 130124, 134042, 134095, 134008, 134092, 134006, 134005, 133993, 133528, 134040, 133525, 133957, 128496, 133517, 128494, 133968, 133515, 133955, 128492, 128491, 129205, 133951, 133513, 133938, 133510, 133731, 133507, 133713, 133533, 130377, 130286, 130317, 128484, 130255, 133472, 130284, 130282, 121720, 130340, 121718, 130338, 130371, 130367, 130330, 121703, 130279, 130121, 130315, 130312, 130250, 130277, 130248, 130246, 130244, 130275, 130096, 130272, 130116, 125904, 128482, 125610, 130206, 130203, 130012, 130090, 130003, 130001, 126271, 129999, 129997, 129786, 129356, 129353, 129968, 129784, 128778, 128636, 129347, 128469, 129639, 127148, 129346, 128635, 128774, 128772, 128632, 127146, 128630, 128657, 128629, 128625, 128769, 128621, 128650, 128619, 128467, 128767, 128616, 128465, 128608, 129136, 129103, 128762, 129134, 128760, 129101, 129095, 128606, 128539, 128143, 94666, 128141, 128187, 128139, 116299, 128249, 127295, 128134, 128133, 128131, 127829, 128005, 127820, 127818, 97140, 97138, 127762, 112023, 127155, 127143, 127095, 125135, 126255, 114077, 125133, 126174, 125131, 116149, 125553, 125552, 125550, 126161, 125450, 125129, 125803, 125126, 125124, 125546, 125543, 125634, 125541, 125632, 125346, 88566, 125539, 125537, 125123, 123296, 117165, 124636, 125567, 125564, 125339, 125239, 125118, 125117, 125115, 125113, 125112, 125111, 125110, 125108, 125236, 125221, 125234, 125106, 125028, 125102, 124782, 124781, 117161, 124428, 117157, 121606, 118678, 117143, 118677, 118762, 121113, 118759, 118758, 116040, 116453, 118753, 118748, 118741))
Run Time: 0.174319
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2488 | |
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 | | | | | 2488 | |
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 (30340, 30334, 29481, 13761, 13706, 13679, 13595, 13584, 20026, 12057, 11927, 11895, 11894, 11822, 11765, 11547, 11180, 10841, 10817, 10816, 10786, 10689, 10600, 10599, 10488, 10345, 10271, 10147, 10098, 10064, 10061, 9981, 9973, 9954, 9862, 9674, 9656, 9648, 9640, 9547, 9483, 9468, 9462, 9411, 9375, 9329, 9316, 9275, 9155, 9149, 8914, 8884, 8826))
Run Time: 0.012091
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 53 | 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 (577773, 577770, 577768, 367629, 577766, 526411, 234968, 577764, 234966, 234960, 577576, 468730, 577742, 577691, 622187, 221297, 576786, 614655, 577709, 577706, 576783, 245577, 245575, 572857, 200556, 577690, 513477, 200554, 245573, 614653, 572854, 572852, 221294, 572850, 571505, 346874, 346872, 614651, 245572, 576774, 577702, 576769, 513475, 577700, 314694, 279868, 577688, 346867, 577687, 570849, 434778, 545963, 434772, 434768, 434766, 545960, 434763, 434761, 577671, 577678, 434758, 549748, 549745, 349583, 549743, 542214, 434747, 360077, 570847, 349582, 434743, 349580, 434741, 349578, 434735, 577625, 349576, 234948, 234942, 487419, 234940, 367624, 349573, 434722, 234932, 434718, 527770, 622178, 234925, 234923, 530893, 234920, 221261, 349572, 575296, 61959, 376406, 575292, 234917, 234914, 349570, 576010, 349568, 349567, 349562, 234910, 539517, 234907, 420298, 369232, 420293, 234902, 577568, 234900, 570400, 434712, 376393, 234896, 530881, 577573, 376391, 234894, 391979, 576691, 391977, 376389, 391975, 368305, 530880, 514660, 368303, 234890, 376387, 434707, 514658, 550007, 368301, 577562, 550005, 346855, 550003, 576943, 576941, 577555, 577552, 530879, 577550, 539513, 434701, 434699, 530878, 530876, 485929, 234877, 577489, 234875, 577454, 166598, 166596, 166594, 412427, 377207, 166591, 412424, 555278, 555276, 166588, 555274, 576750, 377205, 221248, 200509, 368299, 412419, 221243, 576665, 577406, 562872, 200498, 412414, 577395, 200494, 577391, 234861, 221239, 576874, 335894, 221237, 221235, 434574, 434572, 434570, 434568, 434566, 434564, 530838, 200493, 576871, 200491, 577373, 200488, 434559, 434557, 434555, 434553, 245545, 200486, 245543, 530827, 434550, 234854, 576864, 434548, 234852, 434545, 221233, 200485, 573358, 573356, 221230, 234849, 234847, 221228, 577378, 522681, 200483, 522680, 269082, 269080, 200480, 269078, 234828, 522674, 577328, 485920, 522668, 577324, 554710, 485917, 434467, 485915, 522666, 530810, 485913, 221225, 434460, 434458, 434456, 434454, 614637, 570340, 434451, 434449, 570338, 434444, 434440, 570336, 434438, 577143, 434428, 530803, 530801, 574847, 221221, 245518, 549739, 234813, 369452, 369450, 369448, 369446, 434420, 549737, 530798, 434418, 369444, 434415, 434412, 570841, 614634, 576158, 434408, 221218, 368298, 234804, 570838, 514644, 523608, 200474, 554708, 200472, 434393, 577242, 434390, 577239, 434385, 614632, 434382, 234802, 577202, 577200, 577092, 434269, 536698, 415114, 576608, 576605, 200464, 346851, 576638, 368296, 200461, 245495, 576601, 374945, 576621, 576585, 576226, 576617, 576615, 556771, 485895, 333933, 566666, 566663, 566641, 424501, 301187, 196016, 180416, 301183, 195770, 279047, 301180, 305732, 179913, 179862, 302358, 179850, 302355, 179846, 302221, 179844, 302027, 195731, 263989, 210301, 179843, 262844, 251689, 223183, 267234, 300751, 267217, 299718, 179829, 300474, 179810, 299613, 210228, 21974, 195721, 279777, 262836, 179618, 179610, 179572, 270037, 270022, 179007, 203644, 182981, 270120, 270112, 270110, 265780, 270086, 262729, 262727, 178916, 178914, 178913, 270002, 270001, 43801, 209527, 256915, 122613, 209519, 209510, 269651, 269829, 269819, 178887, 269817, 269814, 178884, 235410, 184546, 269798, 269796, 262724, 178879, 262718, 269639, 188341, 178855, 209490, 178852, 269340, 269553, 269488, 257116, 182979, 269447, 209449, 182973, 266309, 178820, 178818, 269411, 178810, 266306, 209419, 268726, 262698, 209401, 268527, 222945, 222939, 268517, 266303, 268285, 178633, 268261, 268280, 178621, 178620, 268240, 268238, 178615, 268228, 178604, 182950, 268018, 267097, 266541, 263460, 267017, 267798, 268075, 263457, 209354, 267813, 266917, 267792, 267732, 267790, 249414, 267011, 267787, 267784, 178529, 249406, 266914, 254836, 266912, 266999, 266603, 267197, 266990, 267084, 265672, 267195, 265668, 266907, 266601, 267389, 267193, 267265, 267188, 209348, 265666, 267184, 267130, 266653, 266597, 266595, 209346, 266593, 178499, 235369, 20182, 235367, 194506, 267081, 266590, 131201, 235359, 235357, 266904, 266899, 266582, 265632, 263312, 263310, 263309, 266861, 266860, 266740, 266771, 266858, 266856, 263304, 615251, 77358, 109580, 266730, 266695, 266719, 266690, 251419, 266526, 266523, 256297, 259218, 266576, 259214, 259212, 178451, 259210, 178448, 266487, 263953, 178405, 178403, 178401, 178395, 254020, 266457, 266455, 178364, 178362, 178360, 178357, 51284, 178332, 178328, 178326, 178320, 178318, 265305, 265302, 266371, 263184, 178283, 209327, 178280, 263178, 178278, 178275, 266211, 209320, 266206, 266204, 209316, 178246, 182940, 182938, 266277, 178236, 178234, 261988, 318866, 178232, 266244, 178230, 178219, 266183, 178205, 265604, 178176, 253989, 143530, 104253, 178153, 178151, 178148, 178145, 178143, 178139, 178137, 261380, 261377, 261374, 182935, 253986, 253984, 261486, 253966, 209307, 256754, 262652, 178100, 178097, 615249, 265139, 615247, 265136, 253957, 615245, 178081, 204968, 253954, 257424, 265071, 178056, 253943, 178054, 253941, 178046, 253937, 178044, 253935, 178041, 257422, 178009, 186756, 104229, 209298, 177980, 257552, 186745, 186735, 177961, 177953, 264897, 177950, 264895, 264979, 177948, 177946, 104222, 264880, 264877, 264874, 264996, 264872, 104220, 264869, 264902, 264842, 177906, 251370, 177878, 177868, 177818, 259207, 264462, 259205, 264453, 264451, 259202, 259199, 262145, 262139, 177814, 260087, 264395, 260766, 264187, 260763, 263415, 263413, 264184, 177781, 177780, 177775, 177773, 177771, 263939, 247578, 263819, 263937, 263859, 262035, 263855, 177759, 209284, 260758, 260756, 260754, 262091, 318892, 256529, 263663, 263604, 262125, 263531, 263080, 263591, 202118, 263503, 263501, 263566, 209265, 182929, 262590, 177680, 202115, 263129, 262580, 263386, 262577, 262573, 209259, 262641, 263123, 263375, 260751, 260743, 262633, 263194, 262629, 263190, 263188, 262536, 262628, 262626, 262520, 262613, 262612, 262611, 177618, 262500, 177551, 177548, 261911, 262010, 261965, 318843, 177526, 261898, 177504, 209209, 177496, 182925, 261784, 255687, 256280, 261676, 256276, 256273, 261674, 256271, 182922, 261620, 256269, 261672, 177484, 186655, 177472, 259056, 259054, 177471, 251316, 259052, 261635, 261638, 256261, 177455, 177454, 256258, 177422, 261472, 261470, 177414, 177355, 209182, 209180, 209177, 177353, 261329, 131040, 260730, 260727, 260722, 261129, 260720, 260497, 260493, 260484, 177280, 260476, 259429, 177098, 193017, 259000, 259253, 209120, 259235, 177001, 176959, 258892, 258890, 258886, 204957, 258200, 202558, 202555, 202550, 202547, 257369, 258732, 257085, 248664, 203641, 256451, 258145, 258611, 255648, 258194, 257982, 257981, 258135, 248645, 258033, 258031, 258026, 257961, 257877, 257816, 257282, 257280, 255612, 176806, 184595, 184591, 254276, 257239, 195443, 186393, 256010, 186389, 251226, 256909, 256978, 186368, 208989, 256725, 251208, 251207, 256715, 256784, 251206, 256739, 256665, 256676, 256654, 256647, 222211, 254244, 256546, 256510, 176723, 255976, 255971, 255138, 130901, 255125, 176699, 255052, 254972, 254969, 254869, 253412, 253404, 222406, 254179, 254167, 253457, 222401, 253449, 253448, 248630, 248629, 103962, 251123, 253385, 208579, 208899, 253048, 176621, 176619, 176617, 253143, 253045, 253044, 253124, 249961, 250933, 253121, 251092, 253027, 252917, 252962, 248605, 176544, 176540, 249789, 249351, 249243, 248418, 176463, 176460, 248414, 208739, 615228, 615224, 207674, 204535, 191660, 204373, 191657, 204361, 204355, 191651, 204121, 130692, 204012, 203748, 203617, 202866, 174629, 174627, 202859, 203320, 202847, 202199, 203217, 615182, 615176, 203215, 202721, 195271, 202151, 202500, 615156, 202146, 202088, 201565, 202110, 201563, 201559, 201982, 201404, 201753, 201549, 140859, 140853, 201355, 193558, 201438, 195387, 195384, 191643, 191641, 195324, 195168, 195282, 195261, 195259, 195256, 195254, 195252, 195250, 195213, 195211, 193142, 194216, 195161, 195159, 193140, 195156, 194213, 194865, 194860, 195142, 194858, 195139, 195089, 195077, 195074, 159260, 194952, 194295, 193313, 194785, 194779, 194771, 189862, 194766, 194765, 194609, 161684, 194602, 194333, 194327, 194324, 194320, 161681, 615152, 615150, 194094, 194091, 193983, 194053, 122549, 189394, 193540, 122547, 193310, 193308, 193129, 193306, 193518, 192757, 192303, 192299, 192344, 192297, 192246, 187812, 192179, 192244, 189387, 191377, 191152, 176205, 176203, 191236, 158996, 191146, 174608, 189569, 191051, 189566, 176176, 189564, 176167, 190689, 176129, 190759, 187626, 190620, 189551, 189549, 176116, 176111, 176107, 176103, 176097, 176093, 176091, 176086, 176084, 176081, 176079, 182483, 176078, 190222, 176075, 190079, 176071, 190570, 190563, 190559, 190554, 187436, 190382, 156603, 163884, 190214, 163882, 190194, 190191, 190190, 190188, 190179, 182910, 190042, 190050, 189902, 189837, 189874, 158103, 189461, 189865, 175984, 175983, 188217, 188587, 188549, 189303, 189362, 188544, 188533, 188262, 188530, 188384, 186138, 188406, 188403, 188325, 188380, 188400, 188195, 188079, 188023, 187742, 188021, 187942, 181851, 187393, 187442, 175970, 187440, 181848, 187431, 187426, 187515, 187721, 187694, 187482, 182235, 174594, 187451, 174591, 187421, 174589, 175955, 175953, 174586, 187419, 181145, 187364, 165023, 186877, 184837, 175947, 175941, 186113, 186799, 185995, 185977, 185993, 185988, 141908, 145204, 185910, 185908, 185973, 175928, 185905, 185631, 185629, 185653, 185785, 185649, 175921, 182889, 185645, 185584, 185641, 155434, 185582, 182886, 175917, 174539, 155428, 175675, 184273, 175672, 185251, 182878, 175670, 185212, 175893, 185155, 175874, 161233, 184795, 184811, 184264, 184780, 184728, 184677, 184725, 183633, 184477, 184716, 184316, 184257, 184582, 184643, 184457, 184455, 184573, 184571, 184639, 184623, 184449, 184569, 184442, 184437, 184297, 184307, 184195, 184192, 181837, 182868, 182867, 184245, 181833, 182864, 182860, 182857, 157261, 183241, 183690, 183233, 183458, 182836, 182783, 175847, 182213, 182819, 175838, 182763, 137697, 168057, 175835, 182688, 122513, 122510, 182189, 182177, 175047, 175813, 175797, 181823, 175787, 181584, 181265, 181573, 175780, 181655, 175766, 181380, 174118, 181041, 174788, 175071, 174522, 175149, 174101, 175025, 174512, 174498, 174015, 174781, 174735, 174701, 174733, 174471, 173999, 173972, 130676, 173861, 173855, 173836, 172840, 172987, 173016, 173421, 130653, 130649, 130643, 130640, 173413, 172977, 130638, 130632, 130630, 161992, 168353, 172527, 155343, 168348, 171173, 172049, 171566, 172046, 122438, 171103, 170950, 170778, 170885, 170774, 170770, 170762, 170329, 168850, 145189, 170499, 160391, 170128, 168835, 168343, 168341, 169728, 140663, 164579, 168331, 169375, 167342, 169204, 168328, 168326, 168732, 168637, 169242, 168632, 169193, 168630, 169186, 168794, 164567, 168556, 166667, 168765, 167434, 165987, 166303, 168390, 167432, 167544, 166300, 168323, 166665, 166297, 166663, 168382, 155988, 168549, 168541, 168425, 168267, 168320, 168377, 168375, 168397, 168369, 168246, 168357, 168131, 167791, 164560, 167569, 166918, 32756, 167531, 167464, 167334, 122383, 164923, 166820, 167235, 167453, 167419, 167316, 162263, 162261, 162259, 162256, 123399, 167058, 167048, 166265, 166262, 166574, 158017, 158275, 160966, 165978, 165430, 165918, 165428, 164280, 164279, 165802, 165801, 165817, 165684, 165676, 165554, 165674, 165570, 164987, 165436, 158267, 163993, 164170, 125155, 164088, 161669, 127779, 164166, 163973, 161667, 163365, 162986, 127767, 127764, 154805, 163186, 163150, 163348, 161657, 162554, 163080, 163141, 163078, 163071, 163068, 163087, 163056, 163066, 162980, 125143, 143332, 162674, 162427, 161652, 159911, 162367, 159906, 162216, 161647, 144779, 161642, 161640, 158263, 161406, 161404, 158260, 161545, 161543, 161218, 161510, 161491, 161520, 144775, 161377, 158255, 161374, 161397, 161209, 158653, 158652, 161369, 160405, 158647, 161305, 158645, 161165, 161313, 150846, 161206, 161205, 160890, 158941, 161202, 161163, 159755, 160761, 161298, 161280, 161187, 161158, 161185, 158638, 159254, 160361, 160357, 158925, 159250, 160885, 161122, 157834, 160283, 160882, 143771, 161058, 159245, 159244, 160998, 160757, 123026, 160945, 161032, 159241, 159885, 122351, 159239, 159751, 159227, 160752, 159216, 160327, 160897, 160350, 160057, 159525, 159677, 158917, 159881, 160031, 160047, 160044, 160041, 159783, 160038, 160036, 160029, 159455, 159451, 155969, 155956, 158478, 157203, 158730, 122345, 159506, 159315, 158898, 159624, 158237, 159621, 158890, 159515, 155322, 159180, 142388, 158882, 157620, 130578, 159177, 159482, 159173, 159494, 159309, 159330, 159328, 159165, 142380, 159144, 142370, 159142, 159140, 159083, 142358, 159069, 158096, 159067, 158589, 158635, 158632, 158854, 158852, 158847, 158576, 158574, 158379, 158724, 158787, 158563, 158617, 158093, 158706, 158089, 158175, 158547, 134147, 158419, 158426, 158409, 155719, 158169, 158396, 158167, 158164, 152404, 158248, 158246, 157186, 158244, 152397, 158161, 158159, 152395, 158086, 150476, 155898, 157272, 157595, 157441, 155316, 157051, 157541, 157049, 157538, 155311, 157045, 157409, 156805, 156211, 156932, 155309, 157041, 156719, 156042, 156593, 156037, 156034, 156674, 156598, 151686, 155594, 156078, 156578, 156200, 156068, 156030, 156276, 156274, 156265, 156255, 156253, 155307, 155304, 155302, 155044, 155300, 155004, 154995, 154632, 154911, 154791, 154419, 154627, 154789, 154702, 154453, 154451, 154620, 154442, 154390, 148339, 154382, 154438, 134146, 134145, 154401, 154398, 122330, 148334, 153974, 130541, 153972, 130535, 153873, 152847, 153970, 153035, 152857, 153871, 153938, 153968, 153930, 153868, 153693, 152843, 146150, 152839, 153681, 143495, 146148, 153616, 143493, 153514, 146145, 143491, 153439, 153092, 153437, 153507, 153433, 153431, 153417, 153415, 153428, 153468, 153465, 153215, 153407, 153425, 153404, 138267, 153422, 153400, 152504, 153085, 152590, 137867, 153082, 152390, 152983, 152981, 152586, 153009, 151756, 152978, 152388, 130520, 152976, 137863, 152970, 152994, 137854, 143489, 152957, 137619, 134140, 137617, 152555, 152822, 152816, 152499, 152549, 152378, 152570, 152523, 152497, 152529, 152376, 152367, 152422, 151397, 150300, 151524, 150438, 122314, 140796, 152240, 151710, 140791, 151671, 147063, 151491, 151389, 103630, 150472, 152068, 151955, 150469, 151382, 150205, 152048, 150982, 152045, 151380, 151377, 151979, 151680, 151942, 151368, 151861, 151678, 148331, 151702, 151609, 150464, 151653, 151607, 151600, 151603, 150462, 151437, 151435, 151433, 150572, 151429, 103621, 150458, 150296, 151427, 151361, 151359, 151356, 151353, 151404, 151297, 151400, 151295, 148240, 151205, 150294, 151232, 151230, 103615, 148085, 150546, 148083, 137644, 134137, 137642, 151197, 137640, 148081, 151246, 151244, 145183, 151226, 150799, 150342, 150340, 148236, 150729, 150288, 150794, 150836, 150727, 150522, 148327, 148326, 150680, 150723, 150678, 150721, 150453, 150514, 150200, 150198, 150505, 148079, 148322, 149602, 149600, 148319, 144322, 149587, 149584, 148317, 148315, 148076, 149578, 103603, 148313, 148074, 149575, 149469, 138394, 148728, 148445, 147706, 148602, 148553, 148310, 148299, 146410, 148405, 148297, 148224, 148073, 148292, 148071, 148171, 147881, 112809, 143484, 147646, 145437, 122289, 122283, 147414, 146715, 147411, 143551, 143549, 122279, 143388, 146920, 147043, 145169, 146918, 86492, 86490, 134132, 146916, 146877, 146976, 146972, 146021, 146970, 146912, 146013, 146681, 140628, 146874, 145994, 145990, 146403, 145986, 140625, 146805, 146676, 146399, 146173, 146674, 146397, 137977, 146644, 146771, 146633, 134127, 146607, 145225, 134125, 134123, 100003, 141791, 142480, 145223, 43773, 145221, 146306, 146391, 146559, 146388, 146386, 146375, 146372, 146163, 146369, 146357, 146355, 146351, 146126, 146248, 146122, 144934, 144932, 144930, 144928, 146179, 146159, 143769, 146228, 146116, 144925, 143385, 146176, 143267, 88027, 143480, 146109, 145459, 145163, 143478, 144919, 145159, 144917, 143764, 143472, 143324, 145456, 145210, 145356, 145207, 143322, 88019, 145373, 145402, 145351, 145156, 143760, 143927, 143752, 143925, 143748, 143746, 122275, 143737, 143731, 144849, 125056, 144830, 125051, 144770, 144793, 144764, 143468, 143466, 141899, 143463, 143461, 144382, 142140, 103598, 125927, 103587, 103584, 103569, 103566, 143918, 143916, 142355, 144045, 138265, 144043, 143416, 144014, 137722, 144041, 143899, 142353, 143819, 143406, 141787, 140389, 143300, 143261, 143258, 143063, 139467, 139770, 127740, 142978, 140609, 142613, 142558, 142605, 142601, 141697, 142327, 139460, 141695, 141692, 141690, 139458, 141892, 141785, 139456, 141741, 139454, 142476, 139450, 141853, 139989, 139987, 139985, 141843, 142206, 139439, 138260, 140280, 140277, 142126, 142124, 137232, 142122, 141688, 141889, 142089, 141683, 141884, 141883, 141838, 141914, 141679, 141879, 141863, 141934, 141968, 141931, 141835, 141965, 141830, 141861, 141821, 141724, 141715, 141674, 141713, 140275, 141708, 141706, 140077, 141704, 141729, 141511, 139719, 140075, 137586, 140272, 139716, 140754, 140268, 140598, 137584, 137582, 140049, 140148, 139937, 140145, 139694, 122913, 139757, 139539, 138259, 122902, 138256, 139871, 139368, 118771, 138248, 122894, 139410, 138246, 122890, 139528, 139407, 139514, 118769, 139512, 138245, 122887, 138379, 139400, 118766, 139364, 122884, 139362, 116351, 135781, 139311, 116349, 86485, 139309, 137496, 138412, 137494, 138241, 138239, 138237, 138235, 138051, 137983, 138233, 135775, 138231, 138228, 138048, 134080, 138046, 138041, 138039, 137747, 138037, 138226, 138034, 137783, 137970, 137968, 137743, 137781, 137780, 137636, 137759, 137777, 134608, 137313, 130478, 137730, 137728, 135635, 137715, 137627, 137489, 137625, 136232, 137536, 137534, 137481, 137475, 123395, 137308, 135836, 135408, 135834, 135406, 135401, 136237, 135633, 121785, 135631, 135629, 135627, 135623, 135446, 135825, 135823, 135621, 135675, 126110, 85526, 135673, 135619, 135728, 135499, 135559, 135494, 135491, 135440, 135303, 126264, 135301, 123229, 135351, 125050, 135396, 135247, 135223, 135220, 135233, 135205, 135218, 135201, 128199, 128195, 135099, 128193, 134913, 134677, 134908, 134906, 134902, 134878, 134059, 134597, 134182, 128678, 134569, 134158, 134055, 134564, 134591, 134603, 134155, 134518, 133481, 134515, 134116, 134048, 134045, 128259, 128257, 134224, 128255, 133478, 133979, 134114, 134176, 134112, 121775, 134154, 134109, 121753, 121751, 121749, 134097, 130124, 134042, 134095, 134008, 134092, 134006, 134005, 133993, 133528, 134040, 133525, 133957, 128496, 133517, 128494, 133968, 133515, 133955, 128492, 128491, 129205, 133951, 133513, 133938, 133510, 133731, 133507, 133713, 133533, 130377, 130286, 130317, 128484, 130255, 133472, 130284, 130282, 121720, 130340, 121718, 130338, 130371, 130367, 130330, 121703, 130279, 130121, 130315, 130312, 130250, 130277, 130248, 130246, 130244, 130275, 130096, 130272, 130116, 125904, 128482, 125610, 130206, 130203, 130012, 130090, 130003, 130001, 126271, 129999, 129997, 129786, 129356, 129353, 129968, 129784, 128778, 128636, 129347, 128469, 129639, 127148, 129346, 128635, 128774, 128772, 128632, 127146, 128630, 128657, 128629, 128625, 128769, 128621, 128650, 128619, 128467, 128767, 128616, 128465, 128608, 129136, 129103, 128762, 129134, 128760, 129101, 129095, 128606, 128539, 128143, 94666, 128141, 128187, 128139, 116299, 128249, 127295, 128134, 128133, 128131, 127829, 128005, 127820, 127818, 97140, 97138, 127762, 112023, 127155, 127143, 127095, 125135, 126255, 114077, 125133, 126174, 125131, 116149, 125553, 125552, 125550, 126161, 125450, 125129, 125803, 125126, 125124, 125546, 125543, 125634, 125541, 125632, 125346, 88566, 125539, 125537, 125123, 123296, 117165, 124636, 125567, 125564, 125339, 125239, 125118, 125117, 125115, 125113, 125112, 125111, 125110, 125108, 125236, 125221, 125234, 125106, 125028, 125102, 124782, 124781, 117161, 124428, 117157, 121606, 118678, 117143, 118677, 118762, 121113, 118759, 118758, 116040, 116453, 118753, 118748, 118741))
Run Time: 0.048197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2488 | |
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 | | | | | 2488 | |
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 (30340, 30334, 29481, 13761, 13706, 13679, 13595, 13584, 20026, 12057, 11927, 11895, 11894, 11822, 11765, 11547, 11180, 10841, 10817, 10816, 10786, 10689, 10600, 10599, 10488, 10345, 10271, 10147, 10098, 10064, 10061, 9981, 9973, 9954, 9862, 9674, 9656, 9648, 9640, 9547, 9483, 9468, 9462, 9411, 9375, 9329, 9316, 9275, 9155, 9149, 8914, 8884, 8826))
Run Time: 0.002307
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 53 | 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, ��s
Run Time: 0.000201
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: ��s, XF\Pub\Controller\Member, RecentContent, valid, user_id=2275, 1717147656, , 0, ��s
Run Time: 0.000115
- 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.000485
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.000523
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: 1717147356
Run Time: 0.000353
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 19 | 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` >= 1717147356)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000805
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 19 | 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