| 2 |
3.17 ms |
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.charging_price_ac AS charging_price_ac_2, o0_.charging_price_dc AS charging_price_dc_3, o0_.price_monthly AS price_monthly_4, o0_.price_promo AS price_promo_5, o0_.promo_valid_until AS promo_valid_until_6, o0_.enabled AS enabled_7, o0_.created_at AS created_at_8, o0_.updated_at AS updated_at_9 FROM operator_subscription o0_ INNER JOIN operator_subscription_operator o1_ ON (o1_.subscription_id = o0_.id) WHERE o1_.operator_id IN (?, ?, ?) AND o0_.enabled = 1 GROUP BY o0_.id ORDER BY o0_.id ASC
Parameters: [
5
1834
1850
]
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.charging_price_ac AS charging_price_ac_2, o0_.charging_price_dc AS charging_price_dc_3, o0_.price_monthly AS price_monthly_4, o0_.price_promo AS price_promo_5, o0_.promo_valid_until AS promo_valid_until_6, o0_.enabled AS enabled_7, o0_.created_at AS created_at_8, o0_.updated_at AS updated_at_9 FROM operator_subscription o0_ INNER JOIN operator_subscription_operator o1_ ON (o1_.subscription_id = o0_.id) WHERE o1_.operator_id IN (5, 1834, 1850) AND o0_.enabled = 1 GROUP BY o0_.id ORDER BY o0_.id ASC;
|
| 4 |
2.30 ms |
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.charging_price_ac AS charging_price_ac_2, o0_.charging_price_dc AS charging_price_dc_3, o0_.price_monthly AS price_monthly_4, o0_.price_promo AS price_promo_5, o0_.promo_valid_until AS promo_valid_until_6, o0_.enabled AS enabled_7, o0_.created_at AS created_at_8, o0_.updated_at AS updated_at_9 FROM operator_subscription o0_ INNER JOIN operator_subscription_operator o1_ ON (o1_.subscription_id = o0_.id) WHERE o1_.operator_id IN (?) AND o0_.enabled = 1 GROUP BY o0_.id ORDER BY o0_.id ASC
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.charging_price_ac AS charging_price_ac_2, o0_.charging_price_dc AS charging_price_dc_3, o0_.price_monthly AS price_monthly_4, o0_.price_promo AS price_promo_5, o0_.promo_valid_until AS promo_valid_until_6, o0_.enabled AS enabled_7, o0_.created_at AS created_at_8, o0_.updated_at AS updated_at_9 FROM operator_subscription o0_ INNER JOIN operator_subscription_operator o1_ ON (o1_.subscription_id = o0_.id) WHERE o1_.operator_id IN (420) AND o0_.enabled = 1 GROUP BY o0_.id ORDER BY o0_.id ASC;
|