Sql: 1
SELECT `id` FROM `users_groups` WHERE `name` = 'Touring Workers' LIMIT 1
0.00020909
Sql: 2
SELECT COUNT(DISTINCT u.`id`) AS `c`
FROM `users` AS u
INNER JOIN `users_groups_members` AS ugm ON ugm.`user_id` = u.`id` AND ugm.`group_id` = 20
WHERE u.`is_active` = 1
0.00030303
Sql: 3
SELECT COUNT(DISTINCT u.`id`) AS `c`
FROM `users` AS u
INNER JOIN `users_groups_members` AS ugm ON ugm.`user_id` = u.`id` AND ugm.`group_id` = 20
INNER JOIN `touring_field_auth` AS tfa ON tfa.`user_id` = u.`id`
AND tfa.`pin_hash` IS NOT NULL AND tfa.`pin_hash` != ''
WHERE u.`is_active` = 1
0.00031114
Sql: 4
SELECT u.`id`, IFNULL(u.`firstname`, '') AS `firstname`, IFNULL(u.`lastname`, '') AS `lastname`
FROM `users` AS u
INNER JOIN `users_groups_members` AS ugm ON ugm.`user_id` = u.`id` AND ugm.`group_id` = 20
INNER JOIN `touring_field_auth` AS tfa ON tfa.`user_id` = u.`id`
AND tfa.`pin_hash` IS NOT NULL AND tfa.`pin_hash` != ''
WHERE u.`is_active` = 1
ORDER BY u.`firstname` ASC, u.`lastname` ASC, u.`id` ASC
0.00032806