Explain Query (mysql)
EXPLAIN SELECT
COUNT(s.subscription_id) AS nb_families_with_active_subscription,
SUM(u.family_size) AS nb_adults_and_children,
SUM(IF(s.active = 1, u.family_size-u.numb_children, 0)) AS adults,
SUM(IF(s.active = 1, u.numb_children, 0)) AS children
FROM
subscriptions s
INNER JOIN `users` u ON (u.user_id = s.user_id AND u.charitable_account = 1)
INNER JOIN companies c ON (u.company_id = c.company_id)
WHERE
c.charitable_partner = 1 AND
s.active = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | ALL | PRIMARY | 20 | 10.00 | Using where | ||||
| 1 | SIMPLE | u | ref | PRIMARY, fk_user_company | fk_user_company | 5 | securelufacom.c.company_id | 37278 | 10.00 | Using where | |
| 1 | SIMPLE | s | eq_ref | uniq_sub_per_user, idx_user_id, subscriptions_active_index | uniq_sub_per_user | 4 | securelufacom.u.user_id | 1 | 29.37 | Using where |