SELECT `xf_user`.*, `xf_user_profile_Profile_1`.*, `xf_user_option_Option_2`.*
FROM `xf_user`
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_1` ON (`xf_user_profile_Profile_1`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` IN (0, 878, 360, 4974, 71, 1574, 12469, 16473, 890, 359, 1, 666, 16103, 9838, 17, 13668, 1685, 3632, 2048, 12557, 17291, 56, 74, 18, 774, 2047, 2244, 7067, 5675, 1842, 102, 7230, 14755, 1592, 4365, 7099, 6830, 5270, 703, 1077, 79, 1473, 7053, 1942, 12137, 1770, 3077, 8518, 5123, 118, 5956, 738, 4653, 14944, 3280, 9059, 2012, 3295, 6474, 3996, 11148, 4339, 85, 9580, 7957, 937, 7571, 782, 908, 1696, 4476, 510, 1797, 5674, 13604, 1744, 5714, 14545, 3969, 60, 68, 5436, 5673, 3623, 11560, 15942, 11, 6429, 8558, 5387, 1528, 3006, 3126, 4767, 11379, 1318, 596, 356, 12596, 2511, 1313, 3743, 62, 1917, 5751, 3435, 5047, 6515, 5363, 5237, 6800, 9281, 900, 5632, 4951, 12660, 5793, 6335, 667, 1745, 751, 586, 5916, 124, 73, 475, 297, 10100, 15593, 4213, 3362, 12287, 8529, 10029, 10475, 929, 1752, 4803, 13543, 1103, 2400, 12147, 8054, 2107, 1660, 4851, 9811, 12299, 15705, 2037, 1848, 1446, 1879, 11370, 8469, 14495, 795, 6439, 1928, 8153, 806, 645, 906, 162, 14594, 5398, 13593, 4745, 4637, 14642, 2099, 3985, 1453, 515, 638, 8405, 2911, 8150, 14393, 11309, 2356, 125, 3674, 11141, 1926, 4739, 27444, 15178, 1206, 8700, 5642, 13873, 797, 3055, 2217, 3784, 6660, 4759, 287, 2120, 13573, 332, 1542, 5007, 9610, 10043, 15353, 4768, 2966, 2539, 13902, 15073, 12655, 781, 2360, 5522, 1229, 326, 7090, 8326, 11339, 10614, 2540, 5389, 7293, 5735, 3250, 14266, 5732, 1211, 916, 5925, 5208, 9952, 14737, 1864, 3707, 7993, 7271, 2995, 9432, 2250, 2219, 7901, 408, 687, 4058, 9130, 4657, 12148, 1886, 12317, 16602, 21206, 35294, 498, 2063, 4481, 5492, 104, 2438, 358, 3289, 8136, 1034, 1929, 564, 9934, 12916, 29066, 49, 2119, 3971, 6106, 525, 2560, 12908, 2799, 2301, 9525, 12274, 14746, 420, 7995, 15927, 17098, 5915, 5082, 9449, 1779, 15314, 938, 5616, 5836, 8608, 9417, 15121, 21462, 3492, 3562, 6852, 14838, 5663, 5808, 12410, 7122, 554, 3088, 5802, 6880, 10533, 3125, 2275, 5111, 1712, 7977, 6789, 603, 12930, 6, 2184, 1795, 1681, 461, 1943, 5444, 450, 16250, 16339, 46, 534, 9505, 227, 5895, 15871, 21515, 114, 621, 755, 784, 6896, 15008, 568, 4162, 16632, 18905, 2488, 2550, 3397, 1966, 3014, 4030, 8300, 14553, 195, 3643, 3648, 2061, 6471, 13681, 2625, 14386, 1786, 5989, 8452, 12807, 13331, 20490, 2114, 2024, 2092, 5671, 4018, 6100, 3989, 6044, 9923, 17595, 348, 399, 2655, 3430, 6676, 7878, 7581, 9766, 9955, 14794, 15090, 35774, 4961, 6151, 6247, 6958, 4928, 9906, 4232, 10178, 15384, 467, 1144, 2723, 644, 12634, 12599, 14250, 11572, 14949, 372, 1656, 9057, 2815, 10225, 9752, 14197, 14996, 15318, 590, 429, 1726, 4389, 3263, 6898, 7093, 877, 8876, 11836, 14293, 350, 699, 820, 3509, 2678, 1494, 5592, 800, 1080, 7839, 14460, 11355, 16206, 734, 1038, 1768, 1055, 909, 3621, 5521, 6101, 11314, 6983, 10729, 14287, 16334, 1138, 17199, 37959, 5520, 3139, 6228, 5562, 9822, 9411, 10223, 11854, 13407, 16921, 18188, 12771, 127, 1683, 323, 2897, 5939, 4954, 6853, 8138, 5020, 8898, 8729, 5051, 5719, 11957, 11895, 5008, 10421, 16218, 16918, 17824, 618, 2852, 3851, 2617, 8083, 6485, 13311, 14718, 16914, 657, 8141, 12144, 13328, 13778, 63, 338, 1025, 827, 2628, 5643, 1747, 12503, 19155, 813, 1882, 1024, 3131, 594, 5680, 1937, 2161, 5228, 12319, 15239, 11506, 22999, 280, 4761, 769, 1499, 1335, 974, 1750, 2552, 1023, 3773, 810, 1351, 3083, 1541, 5645, 6484, 3752, 8356, 3387, 10099, 9450, 11458, 376, 12399, 12289, 5852, 5584, 11963, 15106, 14906, 12925, 16393, 16463, 14523, 1468, 21018, 23839, 26230, 35738, 122, 4, 144, 571, 1675, 874, 2157, 373, 3100, 1897, 9, 4786, 1664, 2207, 6915, 6897, 6049, 7940, 15852, 8144, 5365, 9366, 3948, 10457, 11045, 8115, 11595, 12777, 11514, 12198, 14964, 15089, 15483, 16040, 4706, 11590, 16807, 17265, 16851, 23270, 31926, 35292, 130, 289, 368, 1004, 1641, 1575, 2247, 1772, 2186, 2685, 3611, 1980, 5875, 6098, 4164, 10931, 7134, 8698, 78, 3468, 9877, 2381, 11501, 12549, 12005, 13186, 642, 13028, 14419, 14615, 14132, 15570, 9198, 16157, 16369, 16477, 3244, 17198, 23620, 24792, 27149, 22922, 45, 1223, 1682, 901, 2151, 2449, 722, 4014, 2007, 5474, 5884, 109, 5672, 3089, 6553, 1218, 7975, 9397, 8547, 9953, 11240, 7034, 12845, 13300, 17157, 12951, 8032, 6685, 8658, 14910, 15203, 13550, 15515, 9093, 9744, 11264, 16995, 12844, 21528, 32180, 565, 322, 939, 1311, 1158, 2133, 2233, 2954, 994, 1140, 1843, 105, 4237, 5531, 5573, 7232, 8024, 272, 9950, 3399, 10693, 12336, 11730, 9520, 13897, 14238, 12332, 11319, 14950, 8648, 13858, 15721, 15897, 16108, 12758, 17335, 23966, 17600, 17739, 20126, 36199, 386, 701, 999, 1561, 1372, 982, 2193, 2351, 3234, 2158, 4044, 1868, 4550, 693, 2530, 981, 460, 7242, 7798, 9807, 9909, 8168, 8272, 10592, 798, 12970, 13295, 10686, 13931, 14137, 14626, 15405, 15453, 16139, 16455, 16010, 14060, 16528, 24108, 27178, 20540, 36819, 164, 128, 665, 1374, 995, 2478, 129, 4999, 2367, 6384, 4560, 5448, 1932, 7449, 8055, 8475, 8724, 9206, 10553, 11302, 12049, 9574, 11513, 12957, 12885, 6669, 14630, 8875, 15938, 15269, 16020, 16762, 16844, 16149, 18401, 25442, 18918, 33178, 34140, 705, 942, 1796, 1938, 839, 2585, 3369, 529, 5524, 6175, 7538, 7572, 3010, 2134, 8665, 10143, 530, 12559, 13692, 3379, 14278, 14637, 12266, 15027, 15031, 15388, 13525, 15974, 17014, 16716, 20856, 7816, 28502, 33051, 33314, 89, 380, 476, 978, 1120, 2444, 2318, 423, 1558, 4082, 4683, 1766, 4890, 773, 6112, 7030, 7020, 807, 8276, 8365, 7012, 9302, 9881, 11284, 1728, 13048, 13653, 10624, 14636, 13574, 12390, 14537, 13420, 6279, 1975, 16875, 17118, 17059, 23805, 15470, 28586, 28058, 27900, 1503, 792, 1755, 4467, 3862, 6531, 3129, 7038, 7149, 7224, 6385, 8451, 8448, 2104, 9813, 11652, 2641, 13099, 13390, 15581, 1345, 15469, 13409, 16281, 16388, 16874, 17523, 19794, 21638, 28625, 34313, 406, 728, 2014, 933, 5161, 5695, 4663, 6870, 7746, 3342, 2017, 8348, 6940, 10920, 12375, 13064, 13707, 13112, 11256, 13437, 14477, 11857, 15531, 15842, 17030, 17809, 26042, 17909, 1604, 2004, 411, 3085, 3097, 107, 4205, 4950, 5308, 5456, 5042, 4632, 6718, 4202, 8057, 11345, 9938, 12434, 10635, 4975, 13020, 10142, 1707, 14919, 15104, 15601, 15703, 16571, 16863, 3906, 23182, 26069, 14741, 37036, 245, 4763, 1546, 984, 1695, 1865, 2031, 692, 2446, 1972, 2760, 1651, 2973, 2961, 4516, 3409, 2749, 4112, 5236, 1130, 5539, 7048, 6250, 8434, 8663, 293, 9677, 2476, 8011, 10567, 11397, 7016, 872, 11776, 13727, 12913, 14522, 14885, 15012, 14993, 12281, 15055, 15578, 15168, 17211, 18077, 26559, 29551, 14828, 35186, 1665, 2034, 1505, 2389, 2935, 1628, 3227, 852, 5349, 5379, 3446, 5840, 6118, 5943, 1172, 6621, 6557, 7730, 11858, 8555, 489, 9691, 3569, 10502, 10684, 10089, 10505, 9399, 12739, 748, 6964, 14176, 2759, 13479, 15317, 11785, 15295, 15484, 5815, 16257, 16739, 14960, 18743, 29593, 24795, 1308, 1507, 1773, 1748, 2882, 3402, 3606, 3737, 2789, 4997, 5325, 6094, 4973, 4847, 7758, 8072, 7213, 8509, 7371, 6383, 9924, 4979, 8979, 11268, 12197, 12515, 9483, 12964, 14101, 12086, 14716, 11454, 13614, 14708, 14798, 15528, 16051, 4837, 15693, 17164, 13785, 29917, 35419, 1615, 803, 1319, 4151, 5352, 2866, 2595, 6145, 6361, 7504, 8146, 7270, 3610, 10098, 7917, 10114, 9308, 7680, 8064, 12974, 13579, 9979, 9894, 6086, 14842, 2756, 3637, 16091, 15724, 16608, 16837, 11285, 23135, 26938, 12011))
LIMIT 20
Run Time: 0.003095
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | range | PRIMARY | PRIMARY | 4 | | 1154 | Using where |
SIMPLE | xf_user_profile_Profile_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_user.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_user.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/addons/AVForums/TagEssentials/XF/Repository/Tag.php at line 112
- AVForums\TagEssentials\XF\Repository\Tag->getTopUsers() in src/addons/AVForums/TagEssentials/XF/Pub/Controller/Tag.php at line 211
- AVForums\TagEssentials\XF\Pub\Controller\Tag->actionTopUsers() 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