SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_profile_Profile_2`.*
FROM `xf_user`
INNER JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` IN (124, 11506, 29323, 12807, 1879, 13604, 12655, 1, 62, 4739, 16473, 56, 890, 2400, 687, 1696, 22999, 4058, 2511, 1592, 22939, 3295, 1473, 2217, 372, 3623, 4657, 603, 162, 9432, 11, 9427, 11309, 1313, 5270, 15847, 475, 23378, 1752, 2384, 12557, 11379, 2356, 1446, 15384, 2539, 8380, 1795, 21108, 10100, 17116, 1661, 118, 510, 1975, 34140, 29066, 5956, 26615, 369, 8483, 17029, 272, 27739, 435, 14652, 4759, 14197, 3743, 6304, 2749, 7995, 7581, 16238, 16619, 17408, 15350, 2799, 6853, 18610, 13873, 5008, 12287, 22097, 19375, 14642, 2678, 9198, 12922, 10029, 14566, 23090, 7122, 13303, 16807, 31114, 20558, 6485, 15345, 10762, 409, 11514, 10614, 14545, 554, 18034, 2052, 9, 23153, 8405, 15705, 332, 32303, 14746, 10566, 17662, 22793, 109, 22164, 21608, 17909, 2104, 10229, 17197, 30699, 12440, 19442, 14447, 17679, 12396, 14380, 903, 13053, 17746, 22353, 24108, 7432, 12596, 20970, 879, 21397, 3244, 30612, 32635, 21275, 12771, 19966, 21817, 12925, 23765, 23270, 27097, 20046, 916, 18127, 15307, 1663, 2392, 360, 5174, 2037, 6642, 19826, 20608, 16428, 15515, 6676, 4974, 15336, 1034, 9281, 338, 937, 19155, 1453, 18254, 13778, 7099, 15470, 3, 1886, 1299, 748, 20490, 8529, 2736, 2063, 420, 135, 71, 27386, 19794, 13681, 7067, 3435, 23839, 22950, 22085, 19191, 16467, 11560, 7230, 34430, 31653, 30704, 27228, 21873, 21741, 21362, 21214, 21206, 20540, 19060, 18905, 18302, 17824, 17581, 17291, 16570, 16316, 16103, 15578, 15383, 15178, 15055, 14558, 14283, 14005, 13721, 13593, 359, 1318, 104, 1103, 12469, 3632, 85, 79, 18, 5735, 4339, 7839, 703, 2244, 73, 74, 666, 1917, 2530, 13084, 596, 3985, 1848, 1574, 9838, 782, 1842, 78, 1169, 1660, 900, 2911)) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
Run Time: 0.017147
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | range | PRIMARY,user_state | PRIMARY | 4 | | 262 | Using where |
SIMPLE | xf_user_option_Option_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_user.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_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/XF/Pub/Controller/Member.php at line 134
- XF\Pub\Controller\Member->actionIndex() 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