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.006496
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_alff_field_index | ALL | content_field,content_id_content_type | | | | 772 | 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