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, 666, 359, 2012, 1574, 360, 85, 12469, 2048, 2119, 5808, 372, 5389, 3083, 1842, 1195, 596, 7230, 14393, 3295, 784, 1848, 8476, 504, 3632, 2595, 774, 878, 3562, 4717, 4974, 9059, 2063, 7293, 5047, 908, 17291, 13430, 8979, 1917, 1592, 1235, 74, 16473, 17, 820, 124, 2966, 9906, 3969, 2037, 326, 1077, 5387, 79, 9918, 7067, 16103, 5673, 7099, 1929, 5916, 8898, 1797, 657, 4339, 5714, 1, 62, 9580, 4739, 475, 7957, 3590, 803, 1206, 534, 2759, 2560, 1886, 489, 4691, 8064, 1761, 4592, 2232, 3621, 7464, 3, 3379, 9, 71, 890, 3077, 510, 1158, 1864, 1034, 1975, 2061, 738, 2961, 11141, 12844, 5674, 5363, 2356, 118, 114, 9838, 13074, 2250, 2897, 2852, 5237, 356, 5592, 12557, 15942, 734, 6964, 8558, 3743, 1013, 297, 162, 5773, 14094, 1745, 450, 5671, 1313, 6205, 332, 13959, 687, 4476, 6439, 6513, 7839, 1879, 10475, 1004, 11776, 5675, 14293, 7335, 12660, 8698, 594, 4851, 16570, 7682, 795, 2902, 7090, 1696, 3623, 455, 1843, 272, 2511, 4123, 6515, 642, 11309, 13668, 1772, 15502, 11, 2114, 3126, 6353, 7878, 2911, 3235, 9281, 7734, 5751, 9418, 17157, 373, 4706, 7901, 2462, 4030, 5672, 9681, 1744, 1319, 1483, 2549, 3697, 1942, 10788, 127, 3674, 5495, 6536, 2029, 8529, 9504, 4365, 3362, 12654, 1766, 3218, 9240, 2047, 6557, 1229, 1660, 56, 797, 2120, 7271, 2678, 9366, 60, 348, 1299, 1937, 3435, 7582, 407, 1752, 9432, 6676, 9505, 10459, 14014, 46, 1103, 2548, 89, 1926, 5755, 9839, 9923, 14710, 4630, 4162, 10684, 350, 577, 1426, 909, 4776, 2215, 5375, 14652, 10495, 585, 792, 68, 3343, 6579, 7432, 8193, 9822, 358, 692, 1023, 6151, 5392, 11836, 6896, 5909, 11747, 1681, 4950, 7571, 10446, 2034, 934, 3701, 6800, 12646, 2301, 78, 782, 3342, 5939, 3637, 6830, 102, 12482, 49, 3898, 5270, 5398, 6209, 4659, 4637, 5642, 2921, 5048, 5870, 4257, 7323, 5365, 15777, 1305, 2690, 937, 6180, 6940, 7581, 10698, 11118, 10100, 214, 3773, 3935, 2360, 4467, 4274, 5340, 5664, 5879, 6531, 6863, 7816, 9002, 13902, 2217, 3461, 3865, 4082, 1130, 14520, 9303, 10062, 14642, 14027, 14814, 14665, 573, 1528, 5680, 6028, 8483, 515, 1215, 1778, 3040, 4362, 9489, 406, 2367, 1218, 6100, 4345, 10229, 12064, 15593, 2361, 2476, 2493, 2244, 3851, 15159, 5158, 4961, 6084, 4188, 8346, 9955, 15515, 2832, 554, 3784, 4232, 7053, 9491, 645, 2813, 3399, 916, 3845, 4560, 3125, 10223, 12069, 5956, 2488, 3764, 4550, 5124, 5082, 15431, 8729, 9131, 8215, 15012, 1770, 3876, 3967, 4891, 6642, 1604, 15676, 1773, 2398, 3369, 4975, 6361, 6748, 8509, 9881, 11953, 4759, 4343, 933, 5632, 6089, 2577, 2815, 1755, 5645, 5709, 3771, 4951, 7100, 8019, 7977, 9531, 962, 2785, 4768, 5086, 7316, 8115, 3610, 11966, 9486, 12694, 15646, 4763, 231, 546, 619, 2210, 753, 4384, 4996, 3561, 470, 1837, 4649, 5893, 6720, 6849, 6403, 7457, 6382, 8321, 8870, 9417, 11370, 11268, 16310, 16467, 953, 1863, 1959, 3014, 3441, 3792, 3892, 4395, 5280, 5304, 2044, 6106, 129, 7213, 9278, 10833, 11159, 11448, 12148, 75, 1261, 1057, 1795, 2340, 119, 2400, 751, 4135, 4699, 5001, 4997, 6061, 5436, 6561, 3572, 6304, 8952, 8579, 14250, 13807, 12180, 15858, 73, 566, 1024, 541, 694, 451, 4265, 4446, 4772, 5110, 6096, 4928, 6589, 6261, 6977, 8700, 9070, 11496, 4657, 12137, 13838, 13715, 14755, 15180, 15578, 17282, 215, 1623, 781, 2592, 5022, 4315, 4663, 6247, 4122, 6335, 7768, 6660, 8054, 9411, 11122, 10421, 13197, 13409, 14542, 15586, 238, 1707, 2255, 996, 2668, 3312, 1148, 5562, 5683, 5376, 530, 613, 10320, 338, 12930, 13609, 2320, 4089, 5395, 381, 1652, 1129, 2438, 3329, 1318, 4281, 4168, 1980, 3013, 2842, 4223, 2655, 2532, 7758, 5806, 8467, 4837, 9171, 8974, 9001, 11726, 13479, 13266, 14088, 1114, 640, 2013, 11858, 3178, 2524, 4882, 4921, 5437, 5882, 4197, 4121, 3547, 8100, 8454, 8136, 6406, 12056, 9933, 12636, 15811, 15928, 12, 18, 722, 2347, 2570, 2736, 3463, 4860, 5026, 4151, 1058, 5515, 5786, 7511, 8084, 9691, 13012, 10729, 3971, 13721, 14563, 391, 769, 1687, 716, 1885, 2588, 3330, 4480, 1665, 3280, 1720, 5520, 1908, 6499, 5239, 7039, 8104, 8230, 9210, 9700, 10009, 10507, 12295, 12345, 12629, 13951, 14798, 16461, 264, 590, 1748, 1987, 195, 2233, 3497, 4328, 4803, 5928, 4621, 6588, 8360, 7343, 7, 12403, 12743, 13391, 13914, 15349, 16985, 116, 5921, 8203, 11501, 4566, 6983, 15420, 1829, 2603, 2704, 3289, 5255, 5643, 2965, 6512, 6812, 7654, 8204, 8586, 12486, 11125, 8709, 11321, 11654, 12835, 13558, 13956, 14594, 14944, 108, 1700, 1922, 2415, 2814, 1839, 5732, 7392, 6486, 8380, 7680, 8663, 10872, 11785, 3134, 13798, 13079, 14553, 35294, 69, 226, 2095, 3246, 2162, 1932, 1123, 4842, 8309, 8469, 9931, 10686, 13398, 14811, 16234, 994, 2618, 3384, 2466, 5300, 5853, 6112, 6672, 1659, 8624, 9198, 7382, 9538, 12925, 14545, 699, 1606, 1710, 1786, 1897, 2512, 2744, 2848, 3001, 2993, 1834, 3429, 2853, 3746, 3940, 4038, 4157, 538, 4573, 4782, 4910, 4579, 4112, 5952, 3557, 3861, 5825, 6952, 7404, 7732, 8137, 8402, 8651, 9080, 9396, 9607, 9944, 8153, 10687, 10558, 10043, 11432, 11799, 11475, 12317, 1796, 11356, 12891, 13126, 13311, 13518, 1939, 14003, 13860, 14463, 2863, 5008, 16334, 15505, 13593, 12287, 14210, 21326, 40822, 2107, 298, 463, 279, 703, 1258, 1631, 667, 401, 2330, 2440, 2227, 2617, 2379, 3206, 2918, 3921, 3766, 4165, 4606, 4357, 4866, 4912, 3227, 5103, 5211, 5035, 5604, 4, 6016, 3389, 6354, 6484, 6643, 4501, 7107, 7215, 5880, 7281, 7500, 7866, 7993, 8291, 8560, 8689, 8850, 3229, 9771, 9915, 10033, 9811, 11815, 12000, 1198, 12321, 12894, 12155, 13483, 14222, 14387, 14639, 7702, 14574, 15509, 15739, 16299, 4638, 35, 17415, 21185, 32034, 77, 343, 402, 1498, 2225, 2614, 568, 2888, 1611, 3144, 2256, 3404, 4258, 4443, 4595, 4901, 5056, 5018, 5497, 5584, 5479, 6121, 5993, 2826, 6728, 6956, 7199, 7267, 8042, 7668, 8123, 8178, 8412, 8690, 9085, 8144, 8141, 6853, 9979, 10514, 8710, 10956, 11145, 11457, 2373, 11985, 1055, 12274, 12506, 12738, 12910, 13436, 13610, 13778, 14010, 14348, 16602, 15504, 15813, 15397, 15188, 17366, 21880, 167, 317, 535, 249, 1544, 14266, 2110, 984, 2129, 3015, 1892, 3747, 3961, 4608, 4722, 4840, 4847, 1704, 5330, 5373, 5510, 5579, 5988, 6060, 6098, 6004, 3509, 109, 7128, 7234, 7333, 7288, 7517, 7773, 7896, 773, 8175, 1995, 5859, 8568, 8863, 9621, 8194, 9810, 1878, 10505, 9842, 2780, 1541, 5025, 9912, 11755, 12747, 12914, 13090, 6, 14532, 15576, 16457, 16944, 22471, 224, 412, 496, 1506, 1715, 2088, 2342, 1489, 2073, 1928, 2540, 3033, 3161, 810, 3465, 3397, 3234, 369, 3893, 4125, 4401, 4438, 4872, 4908, 5236, 5338, 5590, 2092, 227, 6191, 5369, 5815, 6736, 6228, 7147, 7143, 7426, 7980, 7860, 8552, 8734, 6962, 8326, 9450, 3646, 10308, 9130, 11032, 798, 1970, 11904, 12029, 12236, 12395, 7917, 12740, 13421, 13603, 14038, 14185, 14571, 14894, 15849, 15873, 16385, 16477, 16992, 17433, 25846, 91, 357, 239, 574, 671, 4767, 2643, 2946, 3153, 3583, 3933, 2995, 4087, 4167, 4436, 4669, 4881, 4924, 5003, 1242, 4954, 4989, 3696, 5528, 5661, 3707, 5969, 5974, 6076, 6242, 6369, 6430, 6701, 7125, 4880, 7232, 7590, 7772, 7922, 8055, 8138, 8276, 8466, 5878, 9176, 9328, 8150, 9930, 10472, 11045, 11505, 3670, 11913, 10944, 12263, 5733, 12729, 13201, 13065, 13846, 70, 4058, 14287, 3163, 12596, 16325, 16607, 14828, 17431, 24972, 244, 362, 800, 1775, 564, 2359, 2219, 2567, 2075, 2954, 1726, 3713, 3816, 3840, 3092, 2792, 4854, 529, 4980, 5360, 5426, 5485, 5772, 4389, 1473, 6376, 6378, 6616, 6768, 3390, 3862, 3656, 7446, 7611, 8111, 8352, 7625, 9439, 9847, 9975, 4524, 794, 11024, 7065, 11164, 12147, 6173, 12560, 638, 12907, 13196, 668, 14045, 12725, 14734, 14884, 14371, 15890, 7519, 16369, 17067, 5544, 15470, 246, 366, 461, 1503, 999, 1737, 1265, 1900, 525, 2539, 2914, 2007, 3338, 3824, 2111, 4306, 4492, 4757, 5032, 5521, 5516, 5650, 5582, 1683, 3996, 3960, 6862, 7027, 420, 7780, 3834, 5123, 8166, 8592, 6233, 9338, 9325, 770, 3468, 10396, 10508, 11076, 10973, 11425, 11754, 11943, 12336, 9322, 586, 16543, 13849, 14558, 14278, 13296, 13278, 15613, 1149, 17071, 11730, 17116, 93, 380, 383, 1676, 1825, 2020, 2150, 2283, 2691, 3162, 3287, 3863, 3361, 4155, 4936, 5368, 3883, 3492, 6360, 839, 4044, 5781, 6799, 6875, 3979, 6202, 7258, 7040, 7423, 5115, 5130, 5167, 5007, 3010, 2651, 8982, 9154, 9329, 9819, 9900, 10162, 9905, 10566, 11047, 11281, 11454, 11523, 11907, 12077, 12285, 12437, 10680, 17655, 13499, 14379, 14547, 14328, 15239, 15617, 14718, 8996, 14495, 16699, 16828, 17455, 20825, 37, 494, 963, 1245, 1750, 1559, 2558, 1372, 2685, 2898, 2935, 3228, 2399, 1627, 1172, 3007, 2004, 5055, 5179, 5464, 5589, 5537, 5964, 6381, 7150, 7224, 7636, 7804, 6047, 8186, 8257, 7242, 7016, 6115, 9938, 10452, 10567, 11263, 5228, 11751, 12791, 13013, 13258, 13523, 13731, 14095, 14600, 7122, 14950, 15388, 9181, 16172, 16733, 16848, 17466, 30704, 436, 498, 1581, 1694, 2156, 1178, 1465, 2590, 2837, 429, 3217, 3521, 2036, 3718, 4205, 4433, 4887, 11300, 1591, 5534, 2486, 5809, 5861, 5980, 6203, 6289, 6391, 6678, 6477, 6897, 7082, 7127, 7256, 7214, 8181, 5020, 8389, 4653, 9513, 8168, 1492, 9952, 10612, 10880, 1264, 11319, 11563, 11944, 12112, 13053, 15471, 13534, 14127, 14368, 14630, 14783, 15055, 15938, 16173, 16450, 16754, 17449, 1345, 8, 497, 448, 337, 1685, 1735, 1846, 2157, 1507, 2487, 2591, 2436, 2850, 2534, 3964, 3223, 4323, 4551, 3636, 4681, 4971, 4194, 5173, 10931, 5378, 5470, 5540, 1039, 5717, 1494, 6007, 4227, 3854, 6231, 2530, 6573, 6936, 7163, 6898, 7322, 7449, 7995, 8128, 8283, 8214, 15852, 8599, 8741, 9251, 9249, 9262, 10031, 10140, 903, 10941, 9958, 11342, 11555, 11712, 4631, 12300, 12476, 12786, 11558, 13451, 8715, 13940, 13781, 14162, 14910, 15935, 16163, 16486, 16775, 16862, 17468, 35547, 266, 501, 243, 665, 827, 897, 2116, 2322, 2802, 2507, 3243, 3456, 3689, 1974, 595, 4130, 621, 4731, 4889, 5046, 5052, 5473, 5111, 4685, 5931, 6102, 6334, 6677, 1661, 4567, 7244, 435, 7403, 7172, 8131, 5629, 8167, 8763, 8775, 9212, 9347, 9512, 9724, 10251, 10445, 10575, 10907, 11713, 8405, 12487, 12680, 467, 13303, 13508, 14099, 13929, 14756, 15041, 15384, 15681, 8925, 16495, 16597, 17253, 18678, 36305, 601, 1777, 1943, 1474, 2707, 2845, 2844, 3385, 2430, 1362, 3944, 3950, 4534, 4719, 4895, 5477, 5551, 5580, 495, 5881, 5694, 6598, 376, 13701, 6109, 7442, 7696, 7849, 8206, 8593, 8732, 8434, 9337, 9435, 9574, 9902, 8880, 10094, 10448, 11121, 6278, 11541, 2723, 12134, 5990, 12407, 10372, 13067, 13313, 13589, 13768, 6392, 15453, 15707, 11331, 16238, 16496, 16807, 17261, 19081, 96, 325, 616, 1490, 1610, 1315, 1938, 1069, 2514, 2597, 2860, 2932, 591, 2080, 3649, 374, 4052, 3487, 3471, 4732, 4883, 4972, 5077, 5203, 3263, 2882, 6037, 6133, 6224, 6345, 6350, 6062, 3985, 64, 6771, 5021, 7302, 7378, 7634, 3474, 2653, 225, 8473, 9025, 8014, 8807, 10207, 9204, 10948, 11148, 11430, 11602, 11960, 12197, 8866, 11613, 12696, 12833, 460, 13339, 13049, 13988, 5735, 13683, 8761, 14472, 14113, 11595, 11258, 16874, 15291, 19079, 14310, 627, 1856, 2097, 2180, 906, 2422, 2463, 2585, 2910, 3048, 1821, 1038, 3853, 1747, 4014, 4103, 4239, 3584, 4714, 4995, 5000, 1025, 5708, 5965, 1712, 6118, 6215, 6630, 900, 5310, 7086, 7174, 7401, 7465, 7713, 7846, 8216, 7826, 2305, 9061, 9698, 9939, 10048, 10480, 2161, 10825, 11132, 11362, 11632, 11797, 12201, 12165, 12884, 12626, 9735, 13666, 13476, 14189, 13604, 14796, 1558, 6235, 10614, 13415, 16665, 17316, 15571, 34637))
LIMIT 20
Run Time: 0.006107
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | range | PRIMARY | PRIMARY | 4 | | 1815 | 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