SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000139
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 1197
- XF\Entity\User->hasPermission() in src/addons/Snog/Forms/XF/Entity/User.php at line 16
- Snog\Forms\XF\Entity\User->canViewAdvancedForms() in src/addons/Snog/Forms/Listener.php at line 131
- Snog\Forms\Listener::appPubStartEnd() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 2853
- XF\App->fire() in src/XF/Pub/App.php at line 201
- XF\Pub\App->start() in src/XF/App.php at line 2347
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_forum_ChaptersForum_2`.*, `xf_forum_ParentChaptersForum_3`.*, `xf_tl_group_forum_GroupForum_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_forum`
INNER JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_forum` AS `xf_forum_ChaptersForum_2` ON (`xf_forum_ChaptersForum_2`.`node_id` = `xf_forum`.`ozzmodz_tct_node_id`)
LEFT JOIN `xf_forum` AS `xf_forum_ParentChaptersForum_3` ON (`xf_forum_ParentChaptersForum_3`.`ozzmodz_tct_node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_tl_group_forum` AS `xf_tl_group_forum_GroupForum_4` ON (`xf_tl_group_forum_GroupForum_4`.`node_id` = `xf_forum`.`node_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_1`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_forum`.`node_id` = '37')
LIMIT 1
Run Time: 0.000934
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_forum_ChaptersForum_2 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_forum_ParentChaptersForum_3 | ALL | | | | | 240 | Using where |
SIMPLE | xf_tl_group_forum_GroupForum_4 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,const | 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 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/Forum.php at line 1276
- XF\Pub\Controller\Forum->assertViewableForum() in src/XF/Pub/Controller/Forum.php at line 198
- XF\Pub\Controller\Forum->actionForum() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 103
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.`thread_id`
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_2` ON (`xf_user_LastPoster_2`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_thread`.`node_id` = 37) AND ((`xf_thread`.`discussion_state` IN ('visible')))
ORDER BY `xf_thread`.`last_post_date` DESC
Run Time: 0.003032
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | node_id_last_post_date | 4 | const | 1366 | 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 1431
- XF\Mvc\Entity\Finder->fetchRaw() in src/XF/Mvc/Entity/Finder.php at line 1446
- XF\Mvc\Entity\Finder->fetchColumns() in src/addons/AL/FilterFramework/Service/ContextProvider.php at line 750
- AL\FilterFramework\Service\ContextProvider->executeFacetedSearch() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 239
- AL\ThreadFilter\XF\Pub\Controller\Forum->applyDateLimitFilters() in src/addons/SV/RedisCache/XF/Pub/Controller/Forum.php at line 12
- SV\RedisCache\XF\Pub\Controller\Forum->applyDateLimitFilters() in src/XF/Pub/Controller/Forum.php at line 243
- XF\Pub\Controller\Forum->actionForum() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 103
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT content_id,
field_id,
field_value,
field_location_country_code,
field_location_state_id,
field_location_city_id
FROM xf_alff_field_index
WHERE content_type=?
AND content_id IN(183580, 183579, 183505, 80163, 182192, 183130, 183109, 183018, 183012, 182955, 180065, 181970, 182872, 182877, 182618, 164687, 86417, 134998, 97904, 87658, 86689, 182527, 182514, 179091, 179092, 182491, 180762, 29677, 179402, 182224, 182200, 181124, 181151, 182112, 180402, 182062, 181996, 181990, 181993, 181981, 181808, 181659, 181714, 180424, 180574, 180068, 180572, 180071, 180067, 178439, 179660, 180069, 179403, 180066, 181362, 181332, 180689, 181287, 180202, 181210, 181200, 181129, 181068, 181065, 181016, 180747, 180381, 180581, 180613, 156701, 180131, 180130, 179405, 179349, 152791, 154655, 156698, 154672, 179258, 178632, 178433, 179103, 179049, 178914, 178707, 178296, 178444, 178602, 178375, 178542, 178373, 178136, 178075, 177915, 177597, 177602, 177718, 177720, 176893, 176972, 176976, 177185, 177369, 177164, 177122, 177076, 177061, 176993, 169675, 176760, 176865, 176862, 176746, 176747, 176698, 176247, 176179, 175967, 175908, 175754, 175443, 175453, 174511, 147415, 167558, 154417, 173712, 173659, 173576, 173575, 173574, 173573, 173571, 173508, 169678, 168949, 173009, 172818, 172803, 172625, 172581, 172582, 172541, 172386, 172379, 172242, 171792, 171722, 171720, 170883, 170664, 170599, 169725, 169722, 169635, 169584, 169097, 146575, 168961, 168858, 168765, 168856, 168736, 168670, 155455, 154597, 168009, 167844, 167846, 167848, 167826, 167768, 167737, 167385, 149995, 166841, 166495, 166390, 166377, 166254, 166192, 166177, 166076, 165935, 165905, 165588, 165413, 165407, 165189, 165185, 165167, 165130, 165014, 164887, 164923, 164897, 164873, 164834, 164808, 164807, 164810, 164813, 164800, 164646, 164710, 164708, 164633, 164647, 164576, 163927, 164258, 164160, 164111, 164102, 163912, 163829, 163831, 163771, 163762, 163765, 163442, 163403, 163389, 163239, 163102, 162941, 162648, 162855, 162692, 162641, 162633, 162594, 162591, 162586, 162584, 162547, 162543, 162516, 162485, 162489, 162499, 162493, 162274, 162239, 162214, 162446, 162479, 157512, 162286, 162344, 162336, 162298, 162142, 162048, 161405, 161321, 161273, 161129, 161080, 161006, 161028, 161027, 161026, 158391, 161087, 161024, 161019, 161000, 160913, 160853, 160852, 160701, 160851, 160850, 160849, 160848, 160847, 160846, 160844, 160843, 160842, 160841, 160840, 160839, 160838, 160837, 159306, 159081, 159005, 158833, 158825, 158596, 155744, 157425, 157411, 157317, 157183, 157019, 156974, 156783, 156791, 154447, 156756, 156760, 156757, 156380, 156728, 141238, 156672, 142366, 156185, 143426, 142421, 142422, 143420, 156410, 136367, 120939, 155284, 156316, 156315, 101871, 156207, 140114, 139794, 130887, 156206, 86694, 150688, 149742, 156145, 156095, 156088, 156051, 156040, 155986, 153459, 155694, 87660, 154636, 124733, 155673, 145150, 136044, 135000, 135045, 155696, 155693, 155676, 155394, 155562, 155268, 154836, 155141, 155345, 99769, 155314, 155044, 154983, 154994, 154962, 144596, 154954, 154808, 154802, 154582, 98820, 154345, 87229, 153959, 152356, 153408, 153846, 98505, 87228, 153790, 153779, 153683, 153613, 153625, 153621, 86616, 105034, 86415, 86413, 153427, 153532, 139994, 139995, 139774, 153524, 153157, 153159, 153069, 153053, 153057, 153056, 153023, 153022, 152939, 152911, 152815, 152736, 152718, 152717, 152716, 152380, 152551, 142805, 152452, 152443, 152420, 152416, 152390, 152388, 152378, 152287, 152269, 152254, 152199, 152039, 151872, 152000, 151983, 151935, 151681, 151225, 149569, 151251, 151214, 151201, 150748, 149029, 150700, 150277, 150132, 128979, 148368, 150309, 150361, 130728, 150208, 150064, 150023, 137027, 149956, 149963, 149514, 148521, 149513, 149648, 149515, 149555, 148532, 148054, 149105, 148513, 145537, 144934, 146454, 146492, 143225, 146138, 146158, 146156, 114084, 146002, 126284, 144319, 100322, 145878, 121092, 121094, 145307, 145833, 145766, 145455, 145767, 145768, 145459, 145769, 145642, 145306, 145171, 144896, 144794, 145224, 145273, 144814, 144821, 144938, 144937, 144752, 144780, 144663, 144522, 144560, 144463, 144449, 144318, 144108, 144040, 144029, 143892, 143723, 143696, 140931, 143717, 143382, 143428, 143285, 143264, 143301, 142800, 142743, 143058, 142508, 142507, 142506, 142963, 142505, 142461, 142145, 142487, 142079, 141692, 141691, 142135, 142128, 142014, 131312, 141158, 141156, 141141, 140378, 140967, 141064, 141004, 140333, 140331, 140751, 140048, 139836, 140113, 138761, 139026, 139335, 139104, 139101, 139075, 139156, 138931, 137607, 136334, 137273, 137404, 138580, 138532, 139103, 138096, 138455, 138456, 137352, 138195, 137351, 138120, 137818, 136904, 137760, 137759, 137758, 137757, 137496, 136584, 137373, 136991, 137264, 137238, 135705, 137161, 137224, 137144, 137088, 137018, 135458, 136593, 136823, 136968, 136999, 136868, 136816, 136843, 136747, 136595, 136541, 136456, 136449, 135715, 136180, 135648, 135650, 136402, 136112, 136113, 135928, 135663, 136196, 136135, 136134, 135985, 135970, 135957, 135761, 135570, 135474, 135585, 135467, 135440, 132337, 132336, 135321, 135328, 135300, 135120, 134974, 134877, 134689, 134717, 134742, 134640, 134582, 134510, 133361, 134315, 133823, 134174, 134061, 133521, 133600, 133428, 133329, 123021, 132333, 132970, 132943, 131151, 131254, 131493, 131270, 131252, 131241, 131243, 131071, 131019, 130672, 130426, 130223, 130151, 130125, 130019, 130023, 129795, 129748, 129242, 125837, 112977, 107979, 112903, 109477, 119318, 129033, 129032, 129029, 128320, 127938, 127730, 127725, 127714, 127707, 127635, 127634, 127284, 127110, 127003, 127033, 127038, 126441, 126396, 126188, 126187, 126186, 126168, 126344, 124742, 125565, 125371, 124849, 124778, 125216, 125217, 124828, 124515, 124357, 124273, 124176, 124138, 124092, 123877, 122876, 122348, 123495, 123492, 123450, 123348, 123306, 123298, 123212, 123211, 123204, 123101, 122807, 122430, 122408, 122358, 121854, 106146, 105826, 101300, 101196, 122776, 122356, 122328, 119410, 122204, 122028, 121974, 121973, 121891, 121836, 121688, 121648, 121635, 121508, 121487, 121468, 121436, 121434, 121403, 121334, 121158, 121010, 122193, 120983, 120843, 120832, 121087, 121027, 121024, 120842, 120761, 120749, 120704, 120697, 120085, 120431, 120083, 120155, 120204, 120291, 120222, 120201, 120151, 120137, 120087, 120073, 119689, 119620, 119825, 119821, 119679, 119684, 119549, 119293, 119268, 118761, 118805, 118754, 118053, 117840, 117814, 117565, 117553, 117548, 117384, 117336, 117249, 117202, 117169, 117099, 117164, 117013, 115766, 115746, 115684, 115650, 115638, 115637, 115395, 115197, 115194, 114817, 114767, 114502, 112798, 114418, 114334, 114193, 114175, 114092, 113646, 113645, 113301, 113335, 113455, 113441, 113311, 113328, 113322, 113300, 113185, 113060, 112788, 112986, 112810, 112987, 112720, 112582, 112598, 112599, 112572, 112247, 112329, 111895, 112520, 112501, 112462, 112437, 112252, 111961, 111872, 111765, 111270, 111294, 111689, 111625, 111593, 111591, 111394, 111037, 111036, 110751, 110578, 110315, 110074, 110130, 109667, 109450, 109384, 109295, 109269, 109109, 108756, 108667, 108627, 108595, 108551, 107940, 107956, 107967, 108055, 107457, 107746, 107798, 107754, 107091, 107236, 106670, 107012, 107011, 106943, 106852, 106778, 106737, 106491, 106474, 106442, 106242, 105970, 105972, 105978, 105866, 105863, 105861, 105623, 105620, 105618, 104541, 105396, 105363, 105281, 105311, 105229, 105222, 104600, 105075, 104928, 104781, 105053, 105001, 104705, 104775, 104666, 104395, 103728, 104443, 104452, 104323, 104298, 104282, 104264, 104268, 104361, 104162, 104058, 103577, 103873, 103865, 103809, 103718, 103373, 103211, 103262, 103205, 103264, 103263, 103259, 102067, 101886, 101379, 101398, 101364, 101200, 101054, 101181, 100896, 100920, 100922, 100779, 100653, 100572, 100575, 100367, 99721, 99259, 99059, 98444, 98599, 98507, 97929, 97954, 97664, 97700, 97552, 97277, 97224, 97255, 97251, 96216, 96137, 96136, 95843, 95853, 95821, 95571, 95590, 95670, 95656, 95328, 95302, 95287, 94775, 95232, 95136, 95030, 94709, 94752, 94539, 94115, 94101, 93909, 94071, 93978, 92380, 92496, 92506, 92492, 92298, 92760, 92571, 92330, 92480, 92553, 91854, 92168, 91835, 81737, 91857, 91780, 91622, 91778, 91751, 91748, 91745, 91741, 91567, 91520, 91516, 91377, 91460, 91392, 91403, 91060, 90981, 90887, 90953, 87659, 90702, 90665, 90620, 90619, 90618, 90201, 89121, 90278, 90361, 87801, 89432, 89125, 89212, 89105, 87171, 87227, 87261, 86844, 86917, 86892, 86808, 86561, 86434, 86184, 86099, 86063, 86165, 85924, 78364, 85400, 85750, 85747, 85642, 85475, 85254, 85250, 85249, 85015, 83546, 83290, 83262, 83059, 82876, 82679, 82706, 82684, 82541, 82611, 82434, 82317, 82316, 82249, 82171, 81431, 81385, 81386, 81298, 81010, 81177, 80969, 80668, 80499, 80365, 80232, 80093, 80014, 79997, 79690, 79570, 79217, 78962, 78927, 78924, 78666, 78624, 78155, 78541, 78123, 77980, 77876, 77776, 77748, 77718, 77707, 77643, 77221, 76956, 77577, 76439, 76390, 76393, 76046, 75378, 75882, 75683, 75618, 75519, 75435, 75497, 75516, 75414, 75461, 75105, 75010, 74722, 74735, 74659, 74591, 74487, 74458, 74350, 74137, 74132, 74135, 74066, 74038, 73511, 73395, 73439, 73428, 73190, 73090, 73064, 73061, 73016, 72696, 72659, 72584, 72581, 72580, 71666, 70802, 71576, 71270, 71269, 71267, 71266, 71263, 71146, 71128, 71113, 70471, 70465, 70084, 70023, 68833, 68836, 68780, 68297, 68245, 68295, 67929, 67292, 66984, 66533, 66352, 65801, 63170, 61418, 61311, 60986, 60179, 59879, 58531, 58405, 58269, 58236, 58110, 57992, 57967, 57944, 57266, 57596, 57416, 57132, 57111, 56584, 55574, 56144, 55940, 55564, 55498, 55713, 54926, 54399, 54563, 54539, 54325, 54262, 54188, 53686, 53470, 53276, 52405, 52026, 51583, 51215, 50797, 50279, 50106, 49473, 49410, 49273, 48921, 48570, 48551, 48550, 48223, 47741, 47462, 47179, 47028, 46954, 46464, 45899, 46209, 46052, 45847, 45359, 45494, 44821, 44426, 43314, 43815, 43054, 42693, 42668, 42617, 42431, 42398, 42172, 41864, 42145, 42156, 42082, 41935, 41931, 41068, 39524, 39206, 38960, 38280, 38068, 37124, 37197, 37224, 37137, 36967, 36299, 36204, 35958, 36150, 35961, 35864, 35315, 35310, 34894, 34814, 33795, 33794, 33789, 33889, 32893, 32814, 32167, 31978, 30146, 31411, 31156, 30933, 30938, 30872, 29182, 30831, 30196, 29687, 30092, 30051, 30038, 29782, 29112, 29096, 28738, 28717, 28443, 28391, 27943, 27716, 27611, 27180, 27508, 27411, 27367, 8038, 2697)
AND field_id IN('tech_modular', 'tech_movement', 'tech_vehicletype', 'tech_vehicle_role', 'tech_defenses', 'tech_traction', 'tech_top_speed', 'tech_brakingpower', 'tech_corner_speed', 'tech_average_speed', 'acceleration_rating', 'tech_balance_rating', 'maneuverability_rating', 'tech_energyresistance', 'tech_kinetic_resistances', 'tech_sonicresist', 'tech_thermalresist', 'tech_radiationresist', 'tech_cargo_capacity', 'tech_marketstatus', 'tech_production', 'tech_weight', 'tech_blastersize')
LIMIT 50000
Params: thread
Run Time: 0.005042
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_alff_field_index | ALL | content_field,content_id_content_type | | | | 163 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/addons/AL/FilterFramework/Service/MySqlSource.php at line 73
- AL\FilterFramework\Service\MySqlSource->countFacets() in src/addons/AL/ThreadFilter/XF/Search/Source/MySqlFtTrait.php at line 46
- AL\ThreadFilter\XF\Search\Source\XF22\MySqlFt->countFacetsByThreadIds() in src/addons/AL/ThreadFilter/XF/Search/Search.php at line 65
- AL\ThreadFilter\XF\Search\Search->countFacetsByThreadIds() in src/addons/AL/ThreadFilter/Service/ContentTypeProvider.php at line 143
- AL\ThreadFilter\Service\ContentTypeProvider->countFacetsByDiscussionIds() in src/addons/AL/FilterFramework/Service/FacetedSearchProvider.php at line 147
- AL\FilterFramework\Service\FacetedSearchProvider->getFacetCounts() in src/addons/AL/FilterFramework/Service/ContextProvider.php at line 759
- AL\FilterFramework\Service\ContextProvider->executeFacetedSearch() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 239
- AL\ThreadFilter\XF\Pub\Controller\Forum->applyDateLimitFilters() in src/addons/SV/RedisCache/XF/Pub/Controller/Forum.php at line 12
- SV\RedisCache\XF\Pub\Controller\Forum->applyDateLimitFilters() in src/XF/Pub/Controller/Forum.php at line 243
- XF\Pub\Controller\Forum->actionForum() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 103
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_user_LastPoster_2`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_2` ON (`xf_user_LastPoster_2`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_thread`.`node_id` = 37) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`sticky` = 0)
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 20 OFFSET 40
Run Time: 0.000691
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | node_id_sticky_state_last_post | 6 | const,const,const | 1330 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_user_LastPoster_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.last_post_user_id | 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 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Forum.php at line 249
- XF\Pub\Controller\Forum->actionForum() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 103
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_thread_prefix`.*
FROM `xf_thread_prefix`
WHERE (`xf_thread_prefix`.`prefix_id` IN (60, 59, 110, 111, 109, 108, 61, 62, 58, 15, 49, 23, 21))
ORDER BY `xf_thread_prefix`.`materialized_order` ASC
Run Time: 0.000149
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread_prefix | range | PRIMARY | PRIMARY | 4 | | 13 | 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/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Entity/Forum.php at line 297
- XF\Entity\Forum->getPrefixes() in src/XF/Mvc/Entity/Entity.php at line 160
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 112
- XF\Mvc\Entity\Entity->__get() in src/addons/AL/ThreadFilter/Service/ForumRequestHelper.php at line 49
- AL\ThreadFilter\Service\ForumRequestHelper->getFieldParams() in src/addons/AL/ThreadFilter/Service/ContentTypeProvider.php at line 389
- AL\ThreadFilter\Service\ContentTypeProvider->getParamsForLocation() in src/addons/AL/FilterFramework/Service/ContextProvider.php at line 725
- AL\FilterFramework\Service\ContextProvider->setupViewParams() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 123
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_forum`
INNER 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')
WHERE (`xf_forum`.`node_id` = '37')
LIMIT 1
Run Time: 0.000231
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_permission_cache_content_Permissions_2 | 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 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/Forum.php at line 1276
- XF\Pub\Controller\Forum->assertViewableForum() in src/XF/Pub/Controller/Forum.php at line 543
- XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 65
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT 1
FROM xf_xa_ams_category
WHERE thread_node_id = ?
LIMIT 1
Params: 37
Run Time: 0.000056
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xa_ams_category | ALL | | | | | 8 | 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 152
- XF\Db\AbstractAdapter->fetchOne() in src/addons/XenAddons/AMS/XF/ForumType/Discussion.php at line 34
- XenAddons\AMS\XF\ForumType\Discussion->getFilterableThreadTypes() in src/XF/Pub/Controller/Forum.php at line 566
- XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 65
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_forum_ChaptersForum_2`.*, `xf_forum_ParentChaptersForum_3`.*, `xf_tl_group_forum_GroupForum_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_forum`
INNER JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_forum` AS `xf_forum_ChaptersForum_2` ON (`xf_forum_ChaptersForum_2`.`node_id` = `xf_forum`.`ozzmodz_tct_node_id`)
LEFT JOIN `xf_forum` AS `xf_forum_ParentChaptersForum_3` ON (`xf_forum_ParentChaptersForum_3`.`ozzmodz_tct_node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_tl_group_forum` AS `xf_tl_group_forum_GroupForum_4` ON (`xf_tl_group_forum_GroupForum_4`.`node_id` = `xf_forum`.`node_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_1`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_forum`.`node_id` = '37')
LIMIT 1
Run Time: 0.000855
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_forum_ChaptersForum_2 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_forum_ParentChaptersForum_3 | ALL | | | | | 240 | Using where |
SIMPLE | xf_tl_group_forum_GroupForum_4 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,const | 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 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/Forum.php at line 1276
- XF\Pub\Controller\Forum->assertViewableForum() in src/XF/Pub/Controller/Forum.php at line 198
- XF\Pub\Controller\Forum->actionForum() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 103
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/addons/AL/FilterFramework/Service/TotalCountCalculator.php at line 69
- AL\FilterFramework\Service\TotalCountCalculator->getTotalCount() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 88
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.`thread_id`
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_2` ON (`xf_user_LastPoster_2`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_thread`.`node_id` = 37) AND ((`xf_thread`.`discussion_state` IN ('visible')))
ORDER BY `xf_thread`.`last_post_date` DESC
Run Time: 0.002094
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | node_id_last_post_date | 4 | const | 1366 | 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 1431
- XF\Mvc\Entity\Finder->fetchRaw() in src/XF/Mvc/Entity/Finder.php at line 1446
- XF\Mvc\Entity\Finder->fetchColumns() in src/addons/AL/FilterFramework/Service/ContextProvider.php at line 750
- AL\FilterFramework\Service\ContextProvider->executeFacetedSearch() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 239
- AL\ThreadFilter\XF\Pub\Controller\Forum->applyDateLimitFilters() in src/addons/SV/RedisCache/XF/Pub/Controller/Forum.php at line 12
- SV\RedisCache\XF\Pub\Controller\Forum->applyDateLimitFilters() in src/XF/Pub/Controller/Forum.php at line 243
- XF\Pub\Controller\Forum->actionForum() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 103
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/addons/AL/FilterFramework/Service/TotalCountCalculator.php at line 69
- AL\FilterFramework\Service\TotalCountCalculator->getTotalCount() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 88
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT content_id,
field_id,
field_value,
field_location_country_code,
field_location_state_id,
field_location_city_id
FROM xf_alff_field_index
WHERE content_type=?
AND content_id IN(183580, 183579, 183505, 80163, 182192, 183130, 183109, 183018, 183012, 182955, 180065, 181970, 182872, 182877, 182618, 164687, 86417, 134998, 97904, 87658, 86689, 182527, 182514, 179091, 179092, 182491, 180762, 29677, 179402, 182224, 182200, 181124, 181151, 182112, 180402, 182062, 181996, 181990, 181993, 181981, 181808, 181659, 181714, 180424, 180574, 180068, 180572, 180071, 180067, 178439, 179660, 180069, 179403, 180066, 181362, 181332, 180689, 181287, 180202, 181210, 181200, 181129, 181068, 181065, 181016, 180747, 180381, 180581, 180613, 156701, 180131, 180130, 179405, 179349, 152791, 154655, 156698, 154672, 179258, 178632, 178433, 179103, 179049, 178914, 178707, 178296, 178444, 178602, 178375, 178542, 178373, 178136, 178075, 177915, 177597, 177602, 177718, 177720, 176893, 176972, 176976, 177185, 177369, 177164, 177122, 177076, 177061, 176993, 169675, 176760, 176865, 176862, 176746, 176747, 176698, 176247, 176179, 175967, 175908, 175754, 175443, 175453, 174511, 147415, 167558, 154417, 173712, 173659, 173576, 173575, 173574, 173573, 173571, 173508, 169678, 168949, 173009, 172818, 172803, 172625, 172581, 172582, 172541, 172386, 172379, 172242, 171792, 171722, 171720, 170883, 170664, 170599, 169725, 169722, 169635, 169584, 169097, 146575, 168961, 168858, 168765, 168856, 168736, 168670, 155455, 154597, 168009, 167844, 167846, 167848, 167826, 167768, 167737, 167385, 149995, 166841, 166495, 166390, 166377, 166254, 166192, 166177, 166076, 165935, 165905, 165588, 165413, 165407, 165189, 165185, 165167, 165130, 165014, 164887, 164923, 164897, 164873, 164834, 164808, 164807, 164810, 164813, 164800, 164646, 164710, 164708, 164633, 164647, 164576, 163927, 164258, 164160, 164111, 164102, 163912, 163829, 163831, 163771, 163762, 163765, 163442, 163403, 163389, 163239, 163102, 162941, 162648, 162855, 162692, 162641, 162633, 162594, 162591, 162586, 162584, 162547, 162543, 162516, 162485, 162489, 162499, 162493, 162274, 162239, 162214, 162446, 162479, 157512, 162286, 162344, 162336, 162298, 162142, 162048, 161405, 161321, 161273, 161129, 161080, 161006, 161028, 161027, 161026, 158391, 161087, 161024, 161019, 161000, 160913, 160853, 160852, 160701, 160851, 160850, 160849, 160848, 160847, 160846, 160844, 160843, 160842, 160841, 160840, 160839, 160838, 160837, 159306, 159081, 159005, 158833, 158825, 158596, 155744, 157425, 157411, 157317, 157183, 157019, 156974, 156783, 156791, 154447, 156756, 156760, 156757, 156380, 156728, 141238, 156672, 142366, 156185, 143426, 142421, 142422, 143420, 156410, 136367, 120939, 155284, 156316, 156315, 101871, 156207, 140114, 139794, 130887, 156206, 86694, 150688, 149742, 156145, 156095, 156088, 156051, 156040, 155986, 153459, 155694, 87660, 154636, 124733, 155673, 145150, 136044, 135000, 135045, 155696, 155693, 155676, 155394, 155562, 155268, 154836, 155141, 155345, 99769, 155314, 155044, 154983, 154994, 154962, 144596, 154954, 154808, 154802, 154582, 98820, 154345, 87229, 153959, 152356, 153408, 153846, 98505, 87228, 153790, 153779, 153683, 153613, 153625, 153621, 86616, 105034, 86415, 86413, 153427, 153532, 139994, 139995, 139774, 153524, 153157, 153159, 153069, 153053, 153057, 153056, 153023, 153022, 152939, 152911, 152815, 152736, 152718, 152717, 152716, 152380, 152551, 142805, 152452, 152443, 152420, 152416, 152390, 152388, 152378, 152287, 152269, 152254, 152199, 152039, 151872, 152000, 151983, 151935, 151681, 151225, 149569, 151251, 151214, 151201, 150748, 149029, 150700, 150277, 150132, 128979, 148368, 150309, 150361, 130728, 150208, 150064, 150023, 137027, 149956, 149963, 149514, 148521, 149513, 149648, 149515, 149555, 148532, 148054, 149105, 148513, 145537, 144934, 146454, 146492, 143225, 146138, 146158, 146156, 114084, 146002, 126284, 144319, 100322, 145878, 121092, 121094, 145307, 145833, 145766, 145455, 145767, 145768, 145459, 145769, 145642, 145306, 145171, 144896, 144794, 145224, 145273, 144814, 144821, 144938, 144937, 144752, 144780, 144663, 144522, 144560, 144463, 144449, 144318, 144108, 144040, 144029, 143892, 143723, 143696, 140931, 143717, 143382, 143428, 143285, 143264, 143301, 142800, 142743, 143058, 142508, 142507, 142506, 142963, 142505, 142461, 142145, 142487, 142079, 141692, 141691, 142135, 142128, 142014, 131312, 141158, 141156, 141141, 140378, 140967, 141064, 141004, 140333, 140331, 140751, 140048, 139836, 140113, 138761, 139026, 139335, 139104, 139101, 139075, 139156, 138931, 137607, 136334, 137273, 137404, 138580, 138532, 139103, 138096, 138455, 138456, 137352, 138195, 137351, 138120, 137818, 136904, 137760, 137759, 137758, 137757, 137496, 136584, 137373, 136991, 137264, 137238, 135705, 137161, 137224, 137144, 137088, 137018, 135458, 136593, 136823, 136968, 136999, 136868, 136816, 136843, 136747, 136595, 136541, 136456, 136449, 135715, 136180, 135648, 135650, 136402, 136112, 136113, 135928, 135663, 136196, 136135, 136134, 135985, 135970, 135957, 135761, 135570, 135474, 135585, 135467, 135440, 132337, 132336, 135321, 135328, 135300, 135120, 134974, 134877, 134689, 134717, 134742, 134640, 134582, 134510, 133361, 134315, 133823, 134174, 134061, 133521, 133600, 133428, 133329, 123021, 132333, 132970, 132943, 131151, 131254, 131493, 131270, 131252, 131241, 131243, 131071, 131019, 130672, 130426, 130223, 130151, 130125, 130019, 130023, 129795, 129748, 129242, 125837, 112977, 107979, 112903, 109477, 119318, 129033, 129032, 129029, 128320, 127938, 127730, 127725, 127714, 127707, 127635, 127634, 127284, 127110, 127003, 127033, 127038, 126441, 126396, 126188, 126187, 126186, 126168, 126344, 124742, 125565, 125371, 124849, 124778, 125216, 125217, 124828, 124515, 124357, 124273, 124176, 124138, 124092, 123877, 122876, 122348, 123495, 123492, 123450, 123348, 123306, 123298, 123212, 123211, 123204, 123101, 122807, 122430, 122408, 122358, 121854, 106146, 105826, 101300, 101196, 122776, 122356, 122328, 119410, 122204, 122028, 121974, 121973, 121891, 121836, 121688, 121648, 121635, 121508, 121487, 121468, 121436, 121434, 121403, 121334, 121158, 121010, 122193, 120983, 120843, 120832, 121087, 121027, 121024, 120842, 120761, 120749, 120704, 120697, 120085, 120431, 120083, 120155, 120204, 120291, 120222, 120201, 120151, 120137, 120087, 120073, 119689, 119620, 119825, 119821, 119679, 119684, 119549, 119293, 119268, 118761, 118805, 118754, 118053, 117840, 117814, 117565, 117553, 117548, 117384, 117336, 117249, 117202, 117169, 117099, 117164, 117013, 115766, 115746, 115684, 115650, 115638, 115637, 115395, 115197, 115194, 114817, 114767, 114502, 112798, 114418, 114334, 114193, 114175, 114092, 113646, 113645, 113301, 113335, 113455, 113441, 113311, 113328, 113322, 113300, 113185, 113060, 112788, 112986, 112810, 112987, 112720, 112582, 112598, 112599, 112572, 112247, 112329, 111895, 112520, 112501, 112462, 112437, 112252, 111961, 111872, 111765, 111270, 111294, 111689, 111625, 111593, 111591, 111394, 111037, 111036, 110751, 110578, 110315, 110074, 110130, 109667, 109450, 109384, 109295, 109269, 109109, 108756, 108667, 108627, 108595, 108551, 107940, 107956, 107967, 108055, 107457, 107746, 107798, 107754, 107091, 107236, 106670, 107012, 107011, 106943, 106852, 106778, 106737, 106491, 106474, 106442, 106242, 105970, 105972, 105978, 105866, 105863, 105861, 105623, 105620, 105618, 104541, 105396, 105363, 105281, 105311, 105229, 105222, 104600, 105075, 104928, 104781, 105053, 105001, 104705, 104775, 104666, 104395, 103728, 104443, 104452, 104323, 104298, 104282, 104264, 104268, 104361, 104162, 104058, 103577, 103873, 103865, 103809, 103718, 103373, 103211, 103262, 103205, 103264, 103263, 103259, 102067, 101886, 101379, 101398, 101364, 101200, 101054, 101181, 100896, 100920, 100922, 100779, 100653, 100572, 100575, 100367, 99721, 99259, 99059, 98444, 98599, 98507, 97929, 97954, 97664, 97700, 97552, 97277, 97224, 97255, 97251, 96216, 96137, 96136, 95843, 95853, 95821, 95571, 95590, 95670, 95656, 95328, 95302, 95287, 94775, 95232, 95136, 95030, 94709, 94752, 94539, 94115, 94101, 93909, 94071, 93978, 92380, 92496, 92506, 92492, 92298, 92760, 92571, 92330, 92480, 92553, 91854, 92168, 91835, 81737, 91857, 91780, 91622, 91778, 91751, 91748, 91745, 91741, 91567, 91520, 91516, 91377, 91460, 91392, 91403, 91060, 90981, 90887, 90953, 87659, 90702, 90665, 90620, 90619, 90618, 90201, 89121, 90278, 90361, 87801, 89432, 89125, 89212, 89105, 87171, 87227, 87261, 86844, 86917, 86892, 86808, 86561, 86434, 86184, 86099, 86063, 86165, 85924, 78364, 85400, 85750, 85747, 85642, 85475, 85254, 85250, 85249, 85015, 83546, 83290, 83262, 83059, 82876, 82679, 82706, 82684, 82541, 82611, 82434, 82317, 82316, 82249, 82171, 81431, 81385, 81386, 81298, 81010, 81177, 80969, 80668, 80499, 80365, 80232, 80093, 80014, 79997, 79690, 79570, 79217, 78962, 78927, 78924, 78666, 78624, 78155, 78541, 78123, 77980, 77876, 77776, 77748, 77718, 77707, 77643, 77221, 76956, 77577, 76439, 76390, 76393, 76046, 75378, 75882, 75683, 75618, 75519, 75435, 75497, 75516, 75414, 75461, 75105, 75010, 74722, 74735, 74659, 74591, 74487, 74458, 74350, 74137, 74132, 74135, 74066, 74038, 73511, 73395, 73439, 73428, 73190, 73090, 73064, 73061, 73016, 72696, 72659, 72584, 72581, 72580, 71666, 70802, 71576, 71270, 71269, 71267, 71266, 71263, 71146, 71128, 71113, 70471, 70465, 70084, 70023, 68833, 68836, 68780, 68297, 68245, 68295, 67929, 67292, 66984, 66533, 66352, 65801, 63170, 61418, 61311, 60986, 60179, 59879, 58531, 58405, 58269, 58236, 58110, 57992, 57967, 57944, 57266, 57596, 57416, 57132, 57111, 56584, 55574, 56144, 55940, 55564, 55498, 55713, 54926, 54399, 54563, 54539, 54325, 54262, 54188, 53686, 53470, 53276, 52405, 52026, 51583, 51215, 50797, 50279, 50106, 49473, 49410, 49273, 48921, 48570, 48551, 48550, 48223, 47741, 47462, 47179, 47028, 46954, 46464, 45899, 46209, 46052, 45847, 45359, 45494, 44821, 44426, 43314, 43815, 43054, 42693, 42668, 42617, 42431, 42398, 42172, 41864, 42145, 42156, 42082, 41935, 41931, 41068, 39524, 39206, 38960, 38280, 38068, 37124, 37197, 37224, 37137, 36967, 36299, 36204, 35958, 36150, 35961, 35864, 35315, 35310, 34894, 34814, 33795, 33794, 33789, 33889, 32893, 32814, 32167, 31978, 30146, 31411, 31156, 30933, 30938, 30872, 29182, 30831, 30196, 29687, 30092, 30051, 30038, 29782, 29112, 29096, 28738, 28717, 28443, 28391, 27943, 27716, 27611, 27180, 27508, 27411, 27367, 8038, 2697)
AND field_id IN('tech_modular', 'tech_movement', 'tech_vehicletype', 'tech_vehicle_role', 'tech_defenses', 'tech_traction', 'tech_top_speed', 'tech_brakingpower', 'tech_corner_speed', 'tech_average_speed', 'acceleration_rating', 'tech_balance_rating', 'maneuverability_rating', 'tech_energyresistance', 'tech_kinetic_resistances', 'tech_sonicresist', 'tech_thermalresist', 'tech_radiationresist', 'tech_cargo_capacity', 'tech_marketstatus', 'tech_production', 'tech_weight', 'tech_blastersize')
LIMIT 50000
Params: thread
Run Time: 0.004966
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_alff_field_index | ALL | content_field,content_id_content_type | | | | 163 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/addons/AL/FilterFramework/Service/MySqlSource.php at line 73
- AL\FilterFramework\Service\MySqlSource->countFacets() in src/addons/AL/ThreadFilter/XF/Search/Source/MySqlFtTrait.php at line 46
- AL\ThreadFilter\XF\Search\Source\XF22\MySqlFt->countFacetsByThreadIds() in src/addons/AL/ThreadFilter/XF/Search/Search.php at line 65
- AL\ThreadFilter\XF\Search\Search->countFacetsByThreadIds() in src/addons/AL/ThreadFilter/Service/ContentTypeProvider.php at line 143
- AL\ThreadFilter\Service\ContentTypeProvider->countFacetsByDiscussionIds() in src/addons/AL/FilterFramework/Service/FacetedSearchProvider.php at line 147
- AL\FilterFramework\Service\FacetedSearchProvider->getFacetCounts() in src/addons/AL/FilterFramework/Service/ContextProvider.php at line 759
- AL\FilterFramework\Service\ContextProvider->executeFacetedSearch() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 239
- AL\ThreadFilter\XF\Pub\Controller\Forum->applyDateLimitFilters() in src/addons/SV/RedisCache/XF/Pub/Controller/Forum.php at line 12
- SV\RedisCache\XF\Pub\Controller\Forum->applyDateLimitFilters() in src/XF/Pub/Controller/Forum.php at line 243
- XF\Pub\Controller\Forum->actionForum() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 103
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/addons/AL/FilterFramework/Service/TotalCountCalculator.php at line 69
- AL\FilterFramework\Service\TotalCountCalculator->getTotalCount() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 88
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_user_LastPoster_2`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_2` ON (`xf_user_LastPoster_2`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_thread`.`node_id` = 37) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`sticky` = 0)
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 20 OFFSET 40
Run Time: 0.000638
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score,node_id_last_threadmark_date_last_post_date | node_id_sticky_state_last_post | 6 | const,const,const | 1330 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_user_LastPoster_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.last_post_user_id | 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 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Forum.php at line 249
- XF\Pub\Controller\Forum->actionForum() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 103
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/addons/AL/FilterFramework/Service/TotalCountCalculator.php at line 69
- AL\FilterFramework\Service\TotalCountCalculator->getTotalCount() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 88
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_forum`
INNER 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')
WHERE (`xf_forum`.`node_id` = '37')
LIMIT 1
Run Time: 0.000240
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_permission_cache_content_Permissions_2 | 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 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/Forum.php at line 1276
- XF\Pub\Controller\Forum->assertViewableForum() in src/XF/Pub/Controller/Forum.php at line 543
- XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 65
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/addons/AL/FilterFramework/Service/TotalCountCalculator.php at line 69
- AL\FilterFramework\Service\TotalCountCalculator->getTotalCount() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 88
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT 1
FROM xf_xa_ams_category
WHERE thread_node_id = ?
LIMIT 1
Params: 37
Run Time: 0.000054
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xa_ams_category | ALL | | | | | 8 | 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 152
- XF\Db\AbstractAdapter->fetchOne() in src/addons/XenAddons/AMS/XF/ForumType/Discussion.php at line 34
- XenAddons\AMS\XF\ForumType\Discussion->getFilterableThreadTypes() in src/XF/Pub/Controller/Forum.php at line 566
- XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 65
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/addons/AL/FilterFramework/Service/TotalCountCalculator.php at line 69
- AL\FilterFramework\Service\TotalCountCalculator->getTotalCount() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 88
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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.000062
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 134
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 16
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/addons/SV/UserActivity/XF/Repository/SessionActivity.php at line 39
- SV\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 163
- SV\UserActivity\XF\Pub\Controller\Forum->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
- XF\Pub\Controller\AbstractController->postDispatchType() in src/addons/SV/UserActivity/UserCountActivityInjector.php at line 27
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatchType() in src/XF/Mvc/Controller.php at line 289
- XF\Mvc\Controller->postDispatch() in src/addons/SV/UserActivity/UserActivityInjector.php at line 71
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/addons/AL/FilterFramework/Service/TotalCountCalculator.php at line 69
- AL\FilterFramework\Service\TotalCountCalculator->getTotalCount() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 88
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: , XF\Pub\Controller\Forum, Forum, valid, node_id=37&page=3, 1716207306, , 0,
Run Time: 0.000046
- 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 227
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 16
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/addons/SV/UserActivity/XF/Repository/SessionActivity.php at line 39
- SV\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 163
- SV\UserActivity\XF\Pub\Controller\Forum->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
- XF\Pub\Controller\AbstractController->postDispatchType() in src/addons/SV/UserActivity/UserCountActivityInjector.php at line 27
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatchType() in src/XF/Mvc/Controller.php at line 289
- XF\Mvc\Controller->postDispatch() in src/addons/SV/UserActivity/UserActivityInjector.php at line 71
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/addons/AL/FilterFramework/Service/TotalCountCalculator.php at line 69
- AL\FilterFramework\Service\TotalCountCalculator->getTotalCount() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 88
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionFilters() in src/addons/AL/ThreadFilter/XF/Pub/Controller/Forum.php at line 136
- AL\ThreadFilter\XF\Pub\Controller\Forum->actionForum() in src/addons/OzzModz/ThreadChapterThreads/XF/Pub/Controller/Forum.php at line 12
- OzzModz\ThreadChapterThreads\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 21
- SV\UserActivity\XF\Pub\Controller\Forum->actionForum() in src/addons/Truonglv/Groups/XF/Pub/Controller/Forum.php at line 37
- Truonglv\Groups\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/OptimizedListQueries/XF/Pub/Controller/Forum.php at line 31
- SV\OptimizedListQueries\XF\Pub\Controller\Forum->actionForum() in src/addons/SV/StandardLib/XF/Pub/Controller/Forum.php at line 21
- SV\StandardLib\XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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.000041
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 134
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 16
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/addons/SV/UserActivity/XF/Repository/SessionActivity.php at line 39
- SV\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 163
- SV\UserActivity\XF\Pub\Controller\Forum->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
- XF\Pub\Controller\AbstractController->postDispatchType() in src/addons/SV/UserActivity/UserCountActivityInjector.php at line 27
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatchType() in src/XF/Mvc/Controller.php at line 289
- XF\Mvc\Controller->postDispatch() in src/addons/SV/UserActivity/UserActivityInjector.php at line 71
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_cv6_dice`.*
FROM `xf_cv6_dice`
WHERE (`xf_cv6_dice`.`active` = '1')
ORDER BY `xf_cv6_dice`.`display_order` ASC
Run Time: 0.000091
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_cv6_dice | ALL | | | | | 6 | 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/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/addons/cv6/DiceRoller/Repository/Dice.php at line 50
- cv6\DiceRoller\Repository\Dice->getDiceForThreadView() in src/addons/cv6/DiceRoller/Listener.php at line 85
- cv6\DiceRoller\Listener::globalTemplateData() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 2853
- XF\App->fire() in src/XF/App.php at line 2076
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1946
- XF\App->preRender() in src/XF/Pub/App.php at line 450
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
- XF\App->run() in src/XF.php at line 517
- 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 (184))
Run Time: 0.000235
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 1387
- 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 949
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7491
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 577
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 528
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2149
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_page`.*, `xf_node_Node_1`.*
FROM `xf_page`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_page`.`node_id`)
WHERE (`xf_page`.`node_id` IN (184))
Run Time: 0.000143
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | 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 1387
- 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/addons/SV/OptimizedListQueries/XF/Repository/Node.php at line 77
- SV\OptimizedListQueries\XF\Repository\Node->loadNodeTypeDataForNodes() in src/addons/Truonglv/Groups/XF/Repository/Node.php at line 24
- Truonglv\Groups\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 949
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7491
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 577
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 528
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2149
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20