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.000613
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 39 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 136
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/App.php at line 2040
- XF\App->preLoadData() in src/XF/App.php at line 2028
- XF\App->setup() in src/XF/Pub/App.php at line 94
- XF\Pub\App->setup() in src/XF.php at line 497
- XF::setupApp() in src/XF.php at line 520
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000265
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1219
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 245
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_profile_Profile_3`.*
FROM `xf_user`
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` = '2584')
LIMIT 1
Run Time: 0.000393
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.001765
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_2584' IN BOOLEAN MODE)
ORDER BY search_index.item_date DESC
LIMIT 10000
Run Time: 0.050358
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 (105612, 237181, 353445, 225506, 353505, 237127, 266104, 346881, 266101, 353436, 332843, 237036, 338590, 196188, 350096, 351399, 350157, 350246, 310252, 350145, 350143, 310250, 350139, 350093, 350092, 350091, 334636, 348909, 334634, 180449, 225213, 59819, 131681, 131671, 348907, 131670, 347234, 224882, 342981, 105353, 340667, 340660, 340657, 341918, 340373, 342461, 224866, 340490, 341655, 342477, 342398, 342395, 236719, 256156, 335653, 335650, 256153, 224816, 341913, 341925, 341882, 236662, 341651, 341648, 212131, 308431, 341545, 224750, 212109, 341460, 340943, 128920, 224738, 224735, 236628, 236624, 236621, 236618, 212079, 341275, 340651, 339048, 340648, 340936, 297935, 339046, 294021, 340889, 294018, 276362, 340792, 339045, 188680, 340877, 340884, 188678, 340822, 308428, 308426, 265403, 265401, 340077, 188675, 340631, 188672, 224662, 294000, 340244, 339962, 336139, 338838, 336134, 252262, 252259, 265394, 338043, 338068, 339632, 265388, 180431, 308413, 339621, 293952, 339486, 339466, 339463, 339461, 293950, 339459, 339456, 339453, 338521, 224584, 314599, 314597, 339181, 224573, 339394, 339387, 8478, 109861, 339038, 339268, 277375, 339035, 339264, 314594, 339108, 23285, 252224, 334515, 205231, 205229, 339033, 339031, 205222, 339030, 205218, 332822, 211893, 338342, 335774, 236412, 335772, 224546, 311821, 236409, 224544, 224542, 224539, 224536, 205196, 335644, 205194, 205189, 205187, 337374, 205184, 338403, 331692, 338204, 211799, 131565, 105250, 236367, 337965, 337963, 337524, 337961, 180415, 326712, 180409, 337300, 337777, 337734, 337775, 55181, 337773, 55174, 336497, 337731, 337767, 336495, 337729, 336493, 55172, 55169, 211740, 330751, 330749, 55164, 330747, 180405, 330745, 55161, 55154, 55152, 317976, 330743, 332223, 55142, 55138, 55136, 55133, 55131, 55128, 337681, 337373, 337679, 55126, 55121, 55118, 180402, 337296, 180398, 337513, 180395, 336100, 337443, 332813, 180393, 332221, 180391, 332811, 337440, 337437, 336096, 337435, 329860, 337433, 337449, 57121, 335603, 224490, 332215, 7606, 265367, 265365, 105240, 205168, 265362, 105238, 205167, 211727, 332212, 211725, 337173, 337171, 236341, 211711, 337166, 337293, 236334, 337290, 337109, 332808, 336578, 337157, 211690, 109834, 336402, 277336, 336400, 336677, 109816, 297908, 336356, 335503, 160801, 109805, 336384, 109803, 109801, 109799, 297906, 330741, 330739, 320065, 330737, 330735, 320063, 333036, 205149, 297899, 335271, 336574, 334463, 330721, 320061, 335822, 330719, 336380, 336572, 336378, 330717, 336376, 330715, 264124, 181439, 335727, 335725, 236287, 236284, 336061, 334456, 336416, 236279, 335595, 205145, 141207, 141205, 236272, 336058, 336084, 336345, 335922, 335463, 335442, 331652, 325680, 335704, 236206, 335552, 236202, 335491, 335548, 236200, 236197, 236195, 335545, 211632, 335543, 335541, 325676, 180373, 236192, 335387, 211624, 180372, 335385, 315194, 329849, 315192, 329846, 180371, 211619, 211616, 180365, 334405, 332561, 329844, 180362, 105214, 137937, 335330, 224425, 211585, 332559, 224423, 211578, 224421, 131553, 180351, 224402, 180341, 224399, 131549, 105201, 105199, 156213, 105197, 105193, 335069, 335317, 329840, 334845, 105174, 309885, 309883, 205137, 211531, 334825, 334822, 105153, 105151, 317930, 297890, 332578, 105149, 131523, 332573, 105147, 205131, 224379, 224376, 205127, 205125, 205123, 309870, 211527, 211524, 211522, 329827, 334588, 334812, 334810, 334808, 309864, 334078, 334805, 325662, 236114, 334802, 325659, 334585, 334583, 236108, 315618, 334881, 236103, 211516, 334787, 236087, 236085, 211504, 334750, 334784, 297878, 334782, 334774, 266094, 312362, 211497, 326700, 334682, 334772, 334760, 334389, 211488, 29993, 195969, 334559, 211486, 334678, 334613, 334556, 334676, 334552, 211482, 332670, 334672, 334383, 334380, 332667, 300815, 334604, 332208, 332548, 236073, 156889, 156887, 331471, 293946, 331469, 331467, 331465, 334147, 292107, 334145, 331457, 236068, 105143, 334366, 334137, 331455, 334135, 334361, 105137, 334359, 105135, 334067, 334066, 332898, 332922, 334063, 333076, 105132, 105130, 224322, 224320, 334222, 333071, 128898, 332954, 332914, 331649, 211416, 211414, 211413, 236030, 224271, 295905, 331202, 211330, 211327, 332266, 332272, 332270, 332256, 128877, 301723, 128875, 331733, 254846, 128872, 224209, 254844, 224206, 211314, 327268, 29990, 211312, 282754, 327928, 224184, 328234, 325958, 331865, 328232, 327921, 211304, 332116, 211302, 328230, 328228, 331911, 327907, 328221, 327905, 328219, 328216, 328213, 325652, 326689, 331908, 327898, 181434, 327896, 331929, 331928, 331528, 325956, 195935, 252113, 181405, 224179, 181403, 181401, 327263, 331191, 181399, 331189, 235966, 318172, 156881, 156879, 308392, 181395, 181393, 181392, 181390, 156877, 235964, 211284, 264107, 105089, 211265, 224176, 312863, 211261, 330917, 303601, 211257, 224174, 105068, 312861, 303597, 330915, 224143, 312860, 235956, 297829, 211196, 328019, 211185, 326790, 319799, 328872, 314577, 328657, 308389, 328211, 328627, 322595, 325307, 328625, 328620, 328615, 328671, 235930, 195907, 224081, 327057, 326787, 224062, 327582, 224060, 224055, 324097, 321980, 324092, 325343, 325642, 321973, 323690, 325341, 266082, 180188, 314547, 105023, 318166, 318732, 308373, 223741, 223739, 317455, 195841, 317452, 318495, 180145, 318146, 318386, 316961, 131462, 131459, 317451, 23277, 311235, 317114, 316948, 311233, 311231, 23275, 317110, 180134, 317108, 317433, 317410, 313639, 317400, 316074, 317096, 316305, 316063, 316297, 316687, 313319, 180081, 316049, 180079, 313317, 315523, 180073, 313312, 180071, 316047, 314374, 316286, 180068, 266071, 266068, 266066, 180066, 316103, 210821, 316033, 223680, 279057, 316031, 104864, 306156, 311917, 311914, 223476, 308336, 311906, 308334, 311381, 305588, 305586, 312214, 179959, 312205, 312194, 306257, 301718, 179958, 306147, 311379, 305188, 312112, 179798, 205034, 298769, 104746, 298802, 297475, 205031, 205029, 104741, 298749, 298783, 298731, 298387, 195716, 223158, 195714, 223155, 210197, 210194, 195711, 297465, 210185, 297463, 298683, 297461, 298681, 271489, 223141, 195708, 298262, 210183, 291344, 298289, 195703, 210170, 265317, 179754, 131398, 296694, 265942, 131392, 131378, 296430, 296964, 296424, 296959, 296058, 296056, 287783, 296046, 295800, 295871, 295099, 295310, 294299, 295305, 294297, 277143, 294594, 293914, 294293, 131358, 131355, 294783, 294781, 262831, 122627, 293905, 179722, 262829, 292875, 295095, 295093, 295002, 295089, 295087, 294288, 294286, 294766, 294284, 294555, 16974, 294566, 287674, 284586, 288236, 291396, 290381, 290362, 290301, 268637, 289907, 289699, 289697, 289257, 289255, 289752, 289885, 289861, 289305, 289749, 288858, 283755, 257154, 270488, 288146, 288143, 318836, 287912, 287942, 287666, 287637, 285904, 287663, 285917, 284802, 183005, 284794, 285896, 179527, 182997, 285742, 284786, 262331, 284783, 131269, 284777, 284177, 131251, 285403, 209790, 278197, 131239, 272057, 131235, 284619, 131232, 262315, 262313, 284615, 173162, 262311, 284770, 270480, 270478, 284606, 284627, 273798, 283257, 283061, 283059, 283023, 261059, 279929, 209748, 209745, 279920, 282803, 209734, 279371, 209731, 209727, 279725, 282638, 279029, 279632, 179450, 278929, 278332, 278331, 278915, 278324, 278911, 261183, 279443, 279367, 262305, 266842, 255748, 278955, 278953, 255739, 278300, 277234, 277206, 277134, 277131, 277883, 277129, 277126, 277124, 277707, 277118, 277617, 277586, 269201, 273255, 272931, 277540, 273794, 277110, 263474, 179357, 276440, 263472, 277048, 273790, 276538, 273784, 273750, 273746, 273743, 263962, 273732, 273727, 273721, 273715, 273666, 273664, 273660, 273611, 272016, 191699, 267825, 270467, 267823, 270463, 271582, 270446, 270444, 270848, 270415, 104289, 270766, 270764, 270761, 270757, 267046, 179111, 179107, 174133, 270402, 270327, 270036, 263956, 179026, 265787, 270140, 268585, 268583, 270084, 265776, 265774, 270073, 270000, 178907, 269996, 270007, 270004, 269824, 269800, 269820, 269533, 269438, 269433, 143011, 269428, 263285, 269254, 269252, 269188, 269249, 268575, 265708, 269106, 269101, 263277, 268416, 268405, 268401, 268351, 268344, 268342, 264968, 268314, 178677, 264965, 264963, 178675, 267834, 266297, 20628, 268021, 178527, 267643, 266498, 131212, 267640, 265664, 131206, 266491, 178298, 154966, 265295, 265607, 254004, 265595, 178178, 253991, 265160, 265206, 265023, 253909, 265020, 257555, 264998, 255110, 264888, 264935, 264931, 264837, 264585, 264508, 261829, 264503, 263419, 263871, 247576, 263936, 247574, 263803, 263864, 263811, 263809, 261822, 261820, 185771, 262943, 185768, 185766, 185765, 185762, 185760, 263525, 263079, 262916, 263136, 263523, 263372, 262885, 260372, 262273, 262503, 82182, 185754, 131116, 262020, 82171, 255712, 131114, 255708, 131112, 82167, 185750, 185748, 82164, 261921, 175695, 175692, 131091, 261585, 255956, 261788, 255951, 255691, 209207, 260358, 260356, 260354, 261783, 255682, 260342, 251319, 185746, 185739, 182918, 177467, 260338, 255679, 183710, 186646, 186644, 186642, 260337, 222159, 222157, 260688, 222155, 186598, 260204, 260198, 186586, 260175, 186579, 260662, 260703, 260163, 186575, 259870, 260122, 259867, 186547, 186545, 186506, 248672, 259282, 258149, 104031, 255665, 255045, 256019, 255659, 248668, 257373, 256148, 255043, 257371, 254822, 257355, 257352, 204647, 204640, 256017, 258478, 256112, 130926, 130924, 256025, 255036, 130922, 256006, 249141, 254987, 255217, 255257, 255081, 130834, 254803, 255253, 255173, 254983, 255049, 255067, 255019, 254980, 176679, 254786, 253049, 186241, 253319, 253318, 194493, 208845, 250829, 249837, 250827, 248600, 250495, 194475, 249826, 249647, 248597, 248485, 247328, 140895, 201329, 140887, 222575, 235205, 222719, 103838, 130709, 222706, 222702, 222699, 235162, 235160, 235159, 222572, 203694, 222183, 222181, 207999, 221984, 208643, 221982, 222179, 222137, 208560, 208608, 222030, 208606, 207841, 222027, 207838, 201444, 222022, 208603, 208601, 208599, 201440, 208597, 208594, 208593, 208240, 208589, 208238, 208235, 103820, 207131, 208524, 103815, 103813, 103809, 208403, 103807, 208315, 208228, 208225, 208223, 208221, 208312, 190674, 208218, 208210, 207793, 193006, 207379, 207781, 207331, 207642, 207739, 176326, 207989, 176324, 207326, 207732, 207663, 128804, 207174, 206810, 193157, 201651, 201316, 201314, 194226, 201436, 201409, 201298, 195169, 195279, 195260, 195258, 195265, 195166, 195255, 195208, 195220, 195204, 194784, 194781, 194769, 194338, 194761, 182493, 194656, 194465, 194461, 193001, 194459, 193550, 193549, 194455, 194080, 194452, 194078, 194449, 193134, 193131, 192408, 192407, 192886, 192670, 188457, 192489, 188446, 192404, 192419, 192402, 176252, 187799, 187795, 190531, 191046, 190696, 176165, 190529, 158986, 158971, 103738, 190680, 190228, 186996, 103727, 103725, 186992, 186988, 190609, 103721, 190403, 186982, 151130, 151126, 103693, 190220, 190470, 190432, 190401, 190136, 190388, 190130, 187826, 183590, 182846, 181293, 183229, 182680, 165193, 170992, 182362, 170990, 181463, 182670, 182669, 137694, 182448, 170986, 182347, 182359, 137691, 137688, 181970, 137686, 165183, 175826, 103656, 182183, 182197, 137683, 181967, 175795, 181887, 181941, 137676, 181865, 181502, 181249, 181382, 181363, 181360, 155351, 171935, 171933, 175728, 156841, 181074, 181072, 181058, 156839, 175717, 175715, 181033, 156837, 175542, 175363, 175236, 175042, 175039, 175037, 173448, 173445, 174088, 173443, 174775, 173440, 174474, 174416, 173829, 173427, 171930, 171926, 172983, 171924, 130642, 173412, 172445, 172398, 172610, 172371, 172608, 172441, 172562, 172396, 172340, 172336, 122474, 155336, 155334, 172252, 155332, 172249, 172225, 170143, 172244, 172169, 171947, 168347, 171563, 168229, 130621, 171944, 171487, 171470, 168853, 172040, 171942, 171951, 171552, 171207, 130607, 171010, 170960, 171202, 170597, 170783, 171081, 128795, 171079, 170944, 170942, 170340, 170895, 170751, 170590, 168849, 169885, 168847, 170318, 170133, 168842, 170130, 170123, 170090, 170111, 170109, 169416, 168831, 169414, 169411, 169897, 130597, 168793, 166299, 168132, 166295, 168129, 167895, 164559, 167407, 167471, 167466, 167517, 167528, 166824, 167460, 167523, 167448, 167400, 167398, 167332, 167195, 167330, 167327, 167191, 164921, 167063, 167189, 167187, 165609, 164918, 166290, 166040, 166929, 166034, 166286, 158021, 166815, 158019, 166264, 166277, 103637, 166654, 166310, 166242, 166218, 158949, 166118, 166111, 165925, 165690, 166030, 165923, 165687, 165678, 165672, 164915, 164913, 155468, 164910, 165551, 165072, 164887, 164884, 164880, 164127, 164790, 164527, 164787, 154366, 154364, 164028, 164025, 154362, 163633, 163188, 163375, 163373, 163361, 163134, 163103, 163054, 125145, 163052, 162877, 162875, 162902, 162859, 162629, 162615, 162392, 162134, 162130, 161899, 161521, 161376, 161337, 161332, 161330, 161326, 161325, 161182, 161191, 161178, 158923, 160884, 160999, 160997, 160753, 158915, 159458, 159814, 159739, 159806, 157213, 159713, 159470, 159467, 157624, 159317, 158899, 157688, 159630, 158896, 142372, 159007, 159071, 158858, 158795, 155791, 158716, 158570, 158371, 158568, 158311, 158353, 158309, 158620, 158711, 158306, 156742, 158303, 158709, 158296, 158174, 158172, 158349, 158441, 158072, 157175, 158009, 158007, 130574, 157137, 130571, 157730, 157681, 157061, 157713, 157712, 130565, 157450, 157056, 157600, 157044, 156806, 156103, 156803, 156090, 156729, 156088, 156796, 156727, 156929, 156203, 156723, 147067, 130559, 156070, 130557, 154545))
Run Time: 0.088528
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1681 | |
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 | | | | | 1681 | |
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 (17643, 16938, 16749, 16614, 16542, 16347, 16248, 16207, 15807, 15773, 14419, 14418, 15844, 13801, 13076, 12340, 12308, 12306, 12125, 11999, 11644, 11393, 11279, 11257, 11124, 11062, 11020, 10981, 10853, 10822, 10735, 10611, 10607, 10499))
Run Time: 0.003071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 34 | 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 (105612, 237181, 353445, 225506, 353505, 237127, 266104, 346881, 266101, 353436, 332843, 237036, 338590, 196188, 350096, 351399, 350157, 350246, 310252, 350145, 350143, 310250, 350139, 350093, 350092, 350091, 334636, 348909, 334634, 180449, 225213, 59819, 131681, 131671, 348907, 131670, 347234, 224882, 342981, 105353, 340667, 340660, 340657, 341918, 340373, 342461, 224866, 340490, 341655, 342477, 342398, 342395, 236719, 256156, 335653, 335650, 256153, 224816, 341913, 341925, 341882, 236662, 341651, 341648, 212131, 308431, 341545, 224750, 212109, 341460, 340943, 128920, 224738, 224735, 236628, 236624, 236621, 236618, 212079, 341275, 340651, 339048, 340648, 340936, 297935, 339046, 294021, 340889, 294018, 276362, 340792, 339045, 188680, 340877, 340884, 188678, 340822, 308428, 308426, 265403, 265401, 340077, 188675, 340631, 188672, 224662, 294000, 340244, 339962, 336139, 338838, 336134, 252262, 252259, 265394, 338043, 338068, 339632, 265388, 180431, 308413, 339621, 293952, 339486, 339466, 339463, 339461, 293950, 339459, 339456, 339453, 338521, 224584, 314599, 314597, 339181, 224573, 339394, 339387, 8478, 109861, 339038, 339268, 277375, 339035, 339264, 314594, 339108, 23285, 252224, 334515, 205231, 205229, 339033, 339031, 205222, 339030, 205218, 332822, 211893, 338342, 335774, 236412, 335772, 224546, 311821, 236409, 224544, 224542, 224539, 224536, 205196, 335644, 205194, 205189, 205187, 337374, 205184, 338403, 331692, 338204, 211799, 131565, 105250, 236367, 337965, 337963, 337524, 337961, 180415, 326712, 180409, 337300, 337777, 337734, 337775, 55181, 337773, 55174, 336497, 337731, 337767, 336495, 337729, 336493, 55172, 55169, 211740, 330751, 330749, 55164, 330747, 180405, 330745, 55161, 55154, 55152, 317976, 330743, 332223, 55142, 55138, 55136, 55133, 55131, 55128, 337681, 337373, 337679, 55126, 55121, 55118, 180402, 337296, 180398, 337513, 180395, 336100, 337443, 332813, 180393, 332221, 180391, 332811, 337440, 337437, 336096, 337435, 329860, 337433, 337449, 57121, 335603, 224490, 332215, 7606, 265367, 265365, 105240, 205168, 265362, 105238, 205167, 211727, 332212, 211725, 337173, 337171, 236341, 211711, 337166, 337293, 236334, 337290, 337109, 332808, 336578, 337157, 211690, 109834, 336402, 277336, 336400, 336677, 109816, 297908, 336356, 335503, 160801, 109805, 336384, 109803, 109801, 109799, 297906, 330741, 330739, 320065, 330737, 330735, 320063, 333036, 205149, 297899, 335271, 336574, 334463, 330721, 320061, 335822, 330719, 336380, 336572, 336378, 330717, 336376, 330715, 264124, 181439, 335727, 335725, 236287, 236284, 336061, 334456, 336416, 236279, 335595, 205145, 141207, 141205, 236272, 336058, 336084, 336345, 335922, 335463, 335442, 331652, 325680, 335704, 236206, 335552, 236202, 335491, 335548, 236200, 236197, 236195, 335545, 211632, 335543, 335541, 325676, 180373, 236192, 335387, 211624, 180372, 335385, 315194, 329849, 315192, 329846, 180371, 211619, 211616, 180365, 334405, 332561, 329844, 180362, 105214, 137937, 335330, 224425, 211585, 332559, 224423, 211578, 224421, 131553, 180351, 224402, 180341, 224399, 131549, 105201, 105199, 156213, 105197, 105193, 335069, 335317, 329840, 334845, 105174, 309885, 309883, 205137, 211531, 334825, 334822, 105153, 105151, 317930, 297890, 332578, 105149, 131523, 332573, 105147, 205131, 224379, 224376, 205127, 205125, 205123, 309870, 211527, 211524, 211522, 329827, 334588, 334812, 334810, 334808, 309864, 334078, 334805, 325662, 236114, 334802, 325659, 334585, 334583, 236108, 315618, 334881, 236103, 211516, 334787, 236087, 236085, 211504, 334750, 334784, 297878, 334782, 334774, 266094, 312362, 211497, 326700, 334682, 334772, 334760, 334389, 211488, 29993, 195969, 334559, 211486, 334678, 334613, 334556, 334676, 334552, 211482, 332670, 334672, 334383, 334380, 332667, 300815, 334604, 332208, 332548, 236073, 156889, 156887, 331471, 293946, 331469, 331467, 331465, 334147, 292107, 334145, 331457, 236068, 105143, 334366, 334137, 331455, 334135, 334361, 105137, 334359, 105135, 334067, 334066, 332898, 332922, 334063, 333076, 105132, 105130, 224322, 224320, 334222, 333071, 128898, 332954, 332914, 331649, 211416, 211414, 211413, 236030, 224271, 295905, 331202, 211330, 211327, 332266, 332272, 332270, 332256, 128877, 301723, 128875, 331733, 254846, 128872, 224209, 254844, 224206, 211314, 327268, 29990, 211312, 282754, 327928, 224184, 328234, 325958, 331865, 328232, 327921, 211304, 332116, 211302, 328230, 328228, 331911, 327907, 328221, 327905, 328219, 328216, 328213, 325652, 326689, 331908, 327898, 181434, 327896, 331929, 331928, 331528, 325956, 195935, 252113, 181405, 224179, 181403, 181401, 327263, 331191, 181399, 331189, 235966, 318172, 156881, 156879, 308392, 181395, 181393, 181392, 181390, 156877, 235964, 211284, 264107, 105089, 211265, 224176, 312863, 211261, 330917, 303601, 211257, 224174, 105068, 312861, 303597, 330915, 224143, 312860, 235956, 297829, 211196, 328019, 211185, 326790, 319799, 328872, 314577, 328657, 308389, 328211, 328627, 322595, 325307, 328625, 328620, 328615, 328671, 235930, 195907, 224081, 327057, 326787, 224062, 327582, 224060, 224055, 324097, 321980, 324092, 325343, 325642, 321973, 323690, 325341, 266082, 180188, 314547, 105023, 318166, 318732, 308373, 223741, 223739, 317455, 195841, 317452, 318495, 180145, 318146, 318386, 316961, 131462, 131459, 317451, 23277, 311235, 317114, 316948, 311233, 311231, 23275, 317110, 180134, 317108, 317433, 317410, 313639, 317400, 316074, 317096, 316305, 316063, 316297, 316687, 313319, 180081, 316049, 180079, 313317, 315523, 180073, 313312, 180071, 316047, 314374, 316286, 180068, 266071, 266068, 266066, 180066, 316103, 210821, 316033, 223680, 279057, 316031, 104864, 306156, 311917, 311914, 223476, 308336, 311906, 308334, 311381, 305588, 305586, 312214, 179959, 312205, 312194, 306257, 301718, 179958, 306147, 311379, 305188, 312112, 179798, 205034, 298769, 104746, 298802, 297475, 205031, 205029, 104741, 298749, 298783, 298731, 298387, 195716, 223158, 195714, 223155, 210197, 210194, 195711, 297465, 210185, 297463, 298683, 297461, 298681, 271489, 223141, 195708, 298262, 210183, 291344, 298289, 195703, 210170, 265317, 179754, 131398, 296694, 265942, 131392, 131378, 296430, 296964, 296424, 296959, 296058, 296056, 287783, 296046, 295800, 295871, 295099, 295310, 294299, 295305, 294297, 277143, 294594, 293914, 294293, 131358, 131355, 294783, 294781, 262831, 122627, 293905, 179722, 262829, 292875, 295095, 295093, 295002, 295089, 295087, 294288, 294286, 294766, 294284, 294555, 16974, 294566, 287674, 284586, 288236, 291396, 290381, 290362, 290301, 268637, 289907, 289699, 289697, 289257, 289255, 289752, 289885, 289861, 289305, 289749, 288858, 283755, 257154, 270488, 288146, 288143, 318836, 287912, 287942, 287666, 287637, 285904, 287663, 285917, 284802, 183005, 284794, 285896, 179527, 182997, 285742, 284786, 262331, 284783, 131269, 284777, 284177, 131251, 285403, 209790, 278197, 131239, 272057, 131235, 284619, 131232, 262315, 262313, 284615, 173162, 262311, 284770, 270480, 270478, 284606, 284627, 273798, 283257, 283061, 283059, 283023, 261059, 279929, 209748, 209745, 279920, 282803, 209734, 279371, 209731, 209727, 279725, 282638, 279029, 279632, 179450, 278929, 278332, 278331, 278915, 278324, 278911, 261183, 279443, 279367, 262305, 266842, 255748, 278955, 278953, 255739, 278300, 277234, 277206, 277134, 277131, 277883, 277129, 277126, 277124, 277707, 277118, 277617, 277586, 269201, 273255, 272931, 277540, 273794, 277110, 263474, 179357, 276440, 263472, 277048, 273790, 276538, 273784, 273750, 273746, 273743, 263962, 273732, 273727, 273721, 273715, 273666, 273664, 273660, 273611, 272016, 191699, 267825, 270467, 267823, 270463, 271582, 270446, 270444, 270848, 270415, 104289, 270766, 270764, 270761, 270757, 267046, 179111, 179107, 174133, 270402, 270327, 270036, 263956, 179026, 265787, 270140, 268585, 268583, 270084, 265776, 265774, 270073, 270000, 178907, 269996, 270007, 270004, 269824, 269800, 269820, 269533, 269438, 269433, 143011, 269428, 263285, 269254, 269252, 269188, 269249, 268575, 265708, 269106, 269101, 263277, 268416, 268405, 268401, 268351, 268344, 268342, 264968, 268314, 178677, 264965, 264963, 178675, 267834, 266297, 20628, 268021, 178527, 267643, 266498, 131212, 267640, 265664, 131206, 266491, 178298, 154966, 265295, 265607, 254004, 265595, 178178, 253991, 265160, 265206, 265023, 253909, 265020, 257555, 264998, 255110, 264888, 264935, 264931, 264837, 264585, 264508, 261829, 264503, 263419, 263871, 247576, 263936, 247574, 263803, 263864, 263811, 263809, 261822, 261820, 185771, 262943, 185768, 185766, 185765, 185762, 185760, 263525, 263079, 262916, 263136, 263523, 263372, 262885, 260372, 262273, 262503, 82182, 185754, 131116, 262020, 82171, 255712, 131114, 255708, 131112, 82167, 185750, 185748, 82164, 261921, 175695, 175692, 131091, 261585, 255956, 261788, 255951, 255691, 209207, 260358, 260356, 260354, 261783, 255682, 260342, 251319, 185746, 185739, 182918, 177467, 260338, 255679, 183710, 186646, 186644, 186642, 260337, 222159, 222157, 260688, 222155, 186598, 260204, 260198, 186586, 260175, 186579, 260662, 260703, 260163, 186575, 259870, 260122, 259867, 186547, 186545, 186506, 248672, 259282, 258149, 104031, 255665, 255045, 256019, 255659, 248668, 257373, 256148, 255043, 257371, 254822, 257355, 257352, 204647, 204640, 256017, 258478, 256112, 130926, 130924, 256025, 255036, 130922, 256006, 249141, 254987, 255217, 255257, 255081, 130834, 254803, 255253, 255173, 254983, 255049, 255067, 255019, 254980, 176679, 254786, 253049, 186241, 253319, 253318, 194493, 208845, 250829, 249837, 250827, 248600, 250495, 194475, 249826, 249647, 248597, 248485, 247328, 140895, 201329, 140887, 222575, 235205, 222719, 103838, 130709, 222706, 222702, 222699, 235162, 235160, 235159, 222572, 203694, 222183, 222181, 207999, 221984, 208643, 221982, 222179, 222137, 208560, 208608, 222030, 208606, 207841, 222027, 207838, 201444, 222022, 208603, 208601, 208599, 201440, 208597, 208594, 208593, 208240, 208589, 208238, 208235, 103820, 207131, 208524, 103815, 103813, 103809, 208403, 103807, 208315, 208228, 208225, 208223, 208221, 208312, 190674, 208218, 208210, 207793, 193006, 207379, 207781, 207331, 207642, 207739, 176326, 207989, 176324, 207326, 207732, 207663, 128804, 207174, 206810, 193157, 201651, 201316, 201314, 194226, 201436, 201409, 201298, 195169, 195279, 195260, 195258, 195265, 195166, 195255, 195208, 195220, 195204, 194784, 194781, 194769, 194338, 194761, 182493, 194656, 194465, 194461, 193001, 194459, 193550, 193549, 194455, 194080, 194452, 194078, 194449, 193134, 193131, 192408, 192407, 192886, 192670, 188457, 192489, 188446, 192404, 192419, 192402, 176252, 187799, 187795, 190531, 191046, 190696, 176165, 190529, 158986, 158971, 103738, 190680, 190228, 186996, 103727, 103725, 186992, 186988, 190609, 103721, 190403, 186982, 151130, 151126, 103693, 190220, 190470, 190432, 190401, 190136, 190388, 190130, 187826, 183590, 182846, 181293, 183229, 182680, 165193, 170992, 182362, 170990, 181463, 182670, 182669, 137694, 182448, 170986, 182347, 182359, 137691, 137688, 181970, 137686, 165183, 175826, 103656, 182183, 182197, 137683, 181967, 175795, 181887, 181941, 137676, 181865, 181502, 181249, 181382, 181363, 181360, 155351, 171935, 171933, 175728, 156841, 181074, 181072, 181058, 156839, 175717, 175715, 181033, 156837, 175542, 175363, 175236, 175042, 175039, 175037, 173448, 173445, 174088, 173443, 174775, 173440, 174474, 174416, 173829, 173427, 171930, 171926, 172983, 171924, 130642, 173412, 172445, 172398, 172610, 172371, 172608, 172441, 172562, 172396, 172340, 172336, 122474, 155336, 155334, 172252, 155332, 172249, 172225, 170143, 172244, 172169, 171947, 168347, 171563, 168229, 130621, 171944, 171487, 171470, 168853, 172040, 171942, 171951, 171552, 171207, 130607, 171010, 170960, 171202, 170597, 170783, 171081, 128795, 171079, 170944, 170942, 170340, 170895, 170751, 170590, 168849, 169885, 168847, 170318, 170133, 168842, 170130, 170123, 170090, 170111, 170109, 169416, 168831, 169414, 169411, 169897, 130597, 168793, 166299, 168132, 166295, 168129, 167895, 164559, 167407, 167471, 167466, 167517, 167528, 166824, 167460, 167523, 167448, 167400, 167398, 167332, 167195, 167330, 167327, 167191, 164921, 167063, 167189, 167187, 165609, 164918, 166290, 166040, 166929, 166034, 166286, 158021, 166815, 158019, 166264, 166277, 103637, 166654, 166310, 166242, 166218, 158949, 166118, 166111, 165925, 165690, 166030, 165923, 165687, 165678, 165672, 164915, 164913, 155468, 164910, 165551, 165072, 164887, 164884, 164880, 164127, 164790, 164527, 164787, 154366, 154364, 164028, 164025, 154362, 163633, 163188, 163375, 163373, 163361, 163134, 163103, 163054, 125145, 163052, 162877, 162875, 162902, 162859, 162629, 162615, 162392, 162134, 162130, 161899, 161521, 161376, 161337, 161332, 161330, 161326, 161325, 161182, 161191, 161178, 158923, 160884, 160999, 160997, 160753, 158915, 159458, 159814, 159739, 159806, 157213, 159713, 159470, 159467, 157624, 159317, 158899, 157688, 159630, 158896, 142372, 159007, 159071, 158858, 158795, 155791, 158716, 158570, 158371, 158568, 158311, 158353, 158309, 158620, 158711, 158306, 156742, 158303, 158709, 158296, 158174, 158172, 158349, 158441, 158072, 157175, 158009, 158007, 130574, 157137, 130571, 157730, 157681, 157061, 157713, 157712, 130565, 157450, 157056, 157600, 157044, 156806, 156103, 156803, 156090, 156729, 156088, 156796, 156727, 156929, 156203, 156723, 147067, 130559, 156070, 130557, 154545))
Run Time: 0.039627
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1681 | |
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 | | | | | 1681 | |
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 (17643, 16938, 16749, 16614, 16542, 16347, 16248, 16207, 15807, 15773, 14419, 14418, 15844, 13801, 13076, 12340, 12308, 12306, 12125, 11999, 11644, 11393, 11279, 11257, 11124, 11062, 11020, 10981, 10853, 10822, 10735, 10611, 10607, 10499))
Run Time: 0.001615
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 34 | 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.000239
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (120))
Run Time: 0.000566
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.000624
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: 1716146582
Run Time: 0.000331
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 22 | 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` >= 1716146582)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000729
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 22 | 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