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, 9059, 16570, 7230, 5714, 8469, 1574, 890, 8194, 3362, 2012, 666, 85, 7957, 2244, 10100, 878, 2400, 3083, 4339, 6534, 3295, 12469, 5047, 2217, 8979, 7293, 62, 9838, 9580, 14545, 5642, 1158, 8624, 1592, 6642, 2966, 8186, 4219, 16428, 6676, 7213, 17, 4974, 420, 2048, 3077, 3572, 11141, 475, 1660, 1235, 5879, 2530, 1842, 5808, 687, 9867, 5956, 3126, 5389, 15055, 8698, 1313, 79, 14520, 2911, 12925, 782, 8898, 1975, 4851, 7839, 8079, 3699, 9881, 1848, 900, 5893, 3014, 15593, 2114, 4467, 9366, 6523, 10143, 10667, 1917, 4365, 781, 124, 49, 3617, 16473, 5171, 359, 4223, 6757, 1103, 125, 4202, 4659, 5755, 8167, 9417, 4630, 4653, 6358, 1446, 9449, 5751, 3329, 6995, 9918, 2438, 8641, 8181, 4058, 5340, 16103, 6896, 9240, 2749, 326, 5773, 6598, 13543, 5671, 7122, 3055, 6789, 8483, 596, 800, 4237, 2119, 7465, 15112, 4739, 3621, 6112, 9839, 10145, 2780, 7917, 15307, 489, 3387, 2549, 5236, 7099, 7581, 7463, 5516, 8166, 8136, 12582, 3898, 4691, 5436, 10948, 5815, 12147, 2595, 7271, 7464, 9979, 9486, 13328, 15073, 6830, 784, 7053, 8054, 9251, 3851, 3342, 9002, 391, 4928, 5521, 2047, 11755, 461, 5672, 3590, 12290, 14462, 4222, 5276, 8203, 3697, 2486, 6660, 7705, 4772, 5376, 6353, 2301, 7143, 5916, 11560, 2430, 1929, 4362, 5190, 7453, 8217, 14250, 5980, 6361, 8370, 8701, 9411, 7382, 11513, 14259, 5082, 820, 5562, 9198, 7977, 3747, 1761, 3996, 4649, 2560, 2466, 7582, 11912, 14185, 3263, 71, 5049, 3509, 3632, 6561, 5939, 738, 450, 17029, 2476, 5680, 6545, 7878, 8178, 5007, 14308, 35294, 3784, 4860, 577, 3834, 4917, 360, 5592, 638, 4657, 1611, 1879, 7401, 5681, 1013, 5632, 1696, 8115, 2736, 4123, 9906, 1970, 2356, 5387, 6278, 6962, 8974, 9345, 10558, 13604, 15974, 16211, 3685, 10762, 7816, 10223, 10641, 9044, 3446, 3280, 4890, 3523, 6291, 1926, 4951, 8497, 8897, 10081, 16516, 11178, 10146, 1, 4151, 1130, 2394, 4197, 6362, 7474, 3399, 7734, 8154, 6209, 8729, 9589, 9621, 11786, 11563, 12429, 13824, 2120, 2087, 3547, 5629, 7894, 7783, 8521, 8150, 2360, 9905, 11131, 10684, 11895, 15362, 1864, 56, 6964, 7149, 8518, 9505, 3623, 11797, 1897, 4621, 1494, 4882, 6770, 7228, 8532, 9819, 8476, 11389, 3497, 5745, 2961, 6721, 8611, 9607, 10094, 1659, 11799, 11747, 13112, 13776, 14617, 15366, 6175, 17392, 25261, 5330, 7200, 3933, 8277, 8763, 8875, 9204, 9438, 9427, 10566, 11624, 10686, 7702, 15207, 2232, 6289, 7144, 7682, 8227, 8276, 8015, 8969, 9700, 12839, 11726, 12922, 8978, 751, 4510, 4637, 529, 1218, 7517, 9464, 9890, 5732, 770, 11654, 6513, 12557, 12596, 8475, 11456, 6341, 12268, 12098, 17408, 3343, 4511, 2978, 5477, 6096, 3384, 7961, 8169, 8448, 10825, 12482, 13064, 4781, 5369, 2921, 5643, 5921, 6060, 5870, 5675, 7511, 7654, 372, 8133, 9736, 937, 14642, 10624, 11309, 5604, 13798, 15676, 16390, 17023, 3693, 4717, 5781, 6089, 2367, 5730, 6515, 7901, 12660, 3935, 10132, 15463, 17109, 17485, 20126, 3253, 1744, 1886, 6076, 6448, 6499, 7420, 7323, 15431, 6540, 7860, 6106, 8876, 9439, 9850, 2214, 3969, 846, 4392, 9281, 8058, 10059, 903, 621, 12021, 13046, 6800, 5241, 6484, 1223, 3435, 18, 9578, 10723, 2318, 3949, 4100, 3802, 1797, 4740, 5482, 5534, 5779, 839, 6643, 2748, 6936, 1758, 7203, 7169, 7536, 7675, 3899, 562, 338, 8259, 7432, 6619, 7278, 2868, 9063, 8320, 8665, 5909, 10049, 10225, 5588, 9766, 4018, 11441, 11606, 11148, 12337, 12504, 12739, 13011, 1770, 13518, 13339, 14156, 1966, 13715, 14829, 15121, 15317, 15318, 3594, 15986, 15180, 16481, 16880, 15890, 18559, 26058, 22999, 40781, 4248, 4433, 2361, 4773, 2448, 581, 4626, 5077, 5373, 5313, 5473, 5967, 4578, 4755, 525, 1076, 6829, 7033, 7251, 3506, 7583, 6172, 3744, 8424, 6290, 8550, 8346, 1034, 9931, 10063, 10342, 9462, 10984, 10941, 11223, 11757, 11908, 12126, 12303, 12513, 13037, 13379, 13236, 13989, 12501, 14753, 14132, 12396, 15504, 15728, 16041, 16251, 16490, 16963, 16609, 18976, 26843, 8038, 2874, 3300, 1726, 3730, 2007, 3773, 4218, 4620, 4977, 1024, 3707, 5486, 5485, 5208, 3771, 1727, 5096, 6332, 6657, 3756, 7168, 7372, 3743, 7622, 7727, 2702, 8428, 3598, 8593, 4333, 162, 9591, 9915, 10469, 7539, 10576, 11302, 11496, 10250, 7067, 12791, 13186, 13626, 13992, 10895, 12888, 10142, 14965, 227, 15551, 15746, 13407, 16280, 3006, 16980, 16646, 13053, 21108, 34809, 3742, 4295, 4357, 4910, 5021, 5404, 5325, 118, 3780, 5880, 5881, 6525, 6616, 6772, 5123, 7016, 7125, 7519, 7504, 8007, 8160, 8168, 6115, 8430, 8435, 8734, 9152, 8558, 9858, 7359, 8681, 10489, 9574, 11526, 4631, 12010, 11994, 12558, 12786, 13067, 9504, 12115, 8658, 14229, 2995, 13386, 15160, 15359, 15502, 11295, 716, 13873, 15721, 6853, 17343, 20041, 25830, 14828, 3774, 3947, 2617, 4275, 4409, 1258, 5032, 594, 2524, 5578, 5650, 774, 6118, 6302, 6429, 6047, 4399, 6100, 7472, 4155, 7745, 7854, 8121, 8171, 8067, 1148, 7115, 8664, 7242, 9126, 9954, 1882, 7680, 10497, 10697, 11033, 11396, 11785, 12169, 12112, 12577, 10507, 9275, 13258, 12410, 10093, 14620, 14783, 15014, 8648, 13668, 2511, 17451, 11408, 16194, 17006, 15487, 18918, 27048, 35277, 3630, 4759, 4285, 4480, 4647, 4776, 4280, 5037, 1242, 5324, 5405, 6133, 5683, 348, 7048, 7378, 7611, 7844, 8019, 7496, 8199, 4592, 8356, 8446, 8473, 2037, 9947, 10201, 10543, 9919, 10708, 7312, 11951, 12201, 12590, 12833, 13321, 13682, 70, 11561, 15004, 12287, 15646, 16241, 15976, 7995, 20202, 27943, 1656, 3051, 3718, 2317, 389, 4912, 4797, 4722, 4133, 2243, 6142, 6094, 6242, 5993, 4352, 5717, 6859, 5444, 5524, 7487, 3800, 7773, 6486, 8084, 3979, 6833, 8680, 9605, 9654, 5270, 10229, 8644, 4729, 11047, 11017, 11308, 1520, 2202, 510, 12840, 1206, 13697, 2661, 14254, 12543, 15025, 15423, 15620, 15789, 5207, 8866, 16984, 17291, 21170, 25312, 35292, 797, 3663, 893, 4756, 4866, 4921, 5339, 1745, 5693, 1720, 5972, 6121, 4654, 6360, 6443, 6752, 5022, 6952, 7062, 7499, 7612, 7780, 74, 7618, 8375, 8195, 5878, 2305, 9212, 9393, 9421, 9965, 1198, 1303, 9610, 8309, 10084, 11185, 11436, 11321, 8247, 12219, 5674, 5124, 13168, 2886, 12900, 14238, 14658, 12844, 15021, 15213, 16094, 16308, 16785, 8775, 26874, 27658, 3214, 4000, 4343, 3636, 4700, 15159, 5192, 5467, 5598, 5237, 5278, 6201, 6328, 5539, 613, 7077, 407, 4837, 7636, 3727, 7826, 8103, 8279, 7975, 8467, 2714, 8720, 9217, 9414, 10129, 10076, 10427, 11052, 11030, 11197, 11118, 11931, 12375, 12642, 12743, 13160, 8715, 10788, 14636, 14857, 15388, 15641, 15937, 401, 16786, 16775, 17056, 17431, 15847, 14171, 3217, 3262, 3680, 1755, 936, 4030, 4534, 3971, 4338, 4936, 5036, 1256, 5343, 4768, 5528, 5586, 5580, 5746, 5061, 5974, 6253, 6369, 6536, 3125, 6982, 6028, 5115, 7828, 3554, 7846, 6838, 5167, 8214, 7348, 8586, 8613, 8765, 9323, 1055, 9057, 10062, 10022, 10445, 7105, 2330, 5008, 5228, 10596, 11442, 12691, 12803, 6, 12503, 12726, 12366, 14341, 14652, 11233, 15216, 10639, 15647, 9933, 13063, 16344, 16791, 16027, 24014, 17824, 36106, 1319, 3690, 3918, 3567, 3430, 3645, 1025, 1766, 4872, 215, 3696, 5768, 2655, 297, 2, 6206, 5991, 2685, 6588, 748, 1651, 7647, 1084, 2550, 8003, 8250, 8299, 8111, 7958, 8458, 7963, 8798, 9025, 9521, 9759, 9655, 9991, 10441, 10616, 10987, 10661, 11462, 6758, 11135, 1265, 12873, 10570, 12733, 13721, 13872, 14869, 15453, 15650, 15918, 15923, 16352, 16783, 14537, 17455, 17662, 29875, 23102, 3900, 4180, 3038, 2897, 4942, 4803, 5310, 4199, 4397, 6728, 6720, 3660, 7127, 3450, 6052, 1211, 8602, 8461, 9518, 4315, 9131, 10440, 10876, 9752, 11229, 11810, 3088, 11918, 12320, 10680, 12896, 13238, 13535, 14099, 14902, 14755, 2061, 14447, 15959, 16134, 17500, 17477, 15291, 23414, 21362, 944, 554, 4064, 795, 938, 4160, 4924, 5223, 5396, 3833, 4809, 5398, 6205, 3960, 6910, 7007, 7138, 7408, 7801, 7907, 435, 6940, 8392, 8488, 17048, 8776, 9279, 9249, 3468, 9998, 10322, 8216, 10575, 10880, 11024, 11139, 11479, 9450, 11837, 17655, 12137, 12489, 872, 12916, 12626, 13571, 13800, 12123, 9364, 14948, 13276, 15203, 15677, 15808, 15312, 16391, 16812, 30633, 27853, 1221, 3855, 4663, 3950, 3235, 5219, 4764, 3948, 5787, 2739, 5930, 3257, 6334, 3946, 6701, 6812, 4038, 4227, 7513, 530, 7948, 8265, 8496, 8546, 9278, 370, 10009, 10158, 10442, 4412, 15852, 11076, 11281, 11511, 102, 11658, 9001, 11976, 12198, 12728, 12960, 13206, 13391, 10409, 14101, 11032, 14700, 6214, 15094, 13605, 10939, 15658, 14436, 16157, 11077, 16803, 16832, 17539, 24126, 31104, 25260, 3245, 3701, 4567, 4854, 2234, 5362, 5709, 5859, 5086, 5959, 4188, 6335, 6628, 6553, 6807, 5557, 1473, 3656, 7261, 4948, 2852, 2555, 7093, 8193, 1453, 2388, 8409, 3010, 8614, 8709, 8880, 9302, 9325, 9171, 7245, 1878, 3736, 9872, 11088, 9681, 11505, 1072, 8141, 12762, 13595, 13951, 14432, 2759, 15106, 15247, 15296, 15707, 15884, 16896, 17166, 16875, 13409, 31151, 38624, 332, 2842, 3805, 4573, 4730, 4805, 356, 5378, 5456, 5708, 5582, 1490, 5601, 5990, 6204, 1426, 129, 6751, 4842, 7086, 7425, 7316, 2396, 3905, 8378, 3637, 2320, 8882, 8014, 9267, 1129, 9418, 2678, 9938, 9531, 1264, 11535, 11657, 11904, 12131, 12506, 1503, 13021, 13369, 13430, 11284, 14043, 4820, 14934, 14283, 15279, 15472, 14113, 15952, 11537, 16442, 16918, 17144, 17860, 26052, 17670, 34737))
LIMIT 20
Run Time: 0.003263
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | range | PRIMARY | PRIMARY | 4 | | 1427 | 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