| 1 |
3.58 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.active AS active_3, t0.display_order AS display_order_4, t0.trial_days AS trial_days_5, t0.trial_requires_card AS trial_requires_card_6, t0.created_at AS created_at_7 FROM subscription_plan t0 WHERE t0.active = ? ORDER BY t0.display_order ASC, t0.id ASC
SELECT t0.id AS id_1, t0.code AS code_2, t0.active AS active_3, t0.display_order AS display_order_4, t0.trial_days AS trial_days_5, t0.trial_requires_card AS trial_requires_card_6, t0.created_at AS created_at_7 FROM subscription_plan t0 WHERE t0.active = 1 ORDER BY t0.display_order ASC, t0.id ASC;
|
| 2 |
3.42 ms |
SELECT t0.id AS id_1, t0.version_number AS version_number_2, t0.display_name AS display_name_3, t0.description AS description_4, t0.features AS features_5, t0.limits AS limits_6, t0.included_modules AS included_modules_7, t0.visible AS visible_8, t0.starts_at AS starts_at_9, t0.ends_at AS ends_at_10, t0.created_at AS created_at_11, t0.plan_id AS plan_id_12 FROM subscription_plan_version t0 WHERE t0.plan_id = ? ORDER BY t0.version_number DESC
SELECT t0.id AS id_1, t0.version_number AS version_number_2, t0.display_name AS display_name_3, t0.description AS description_4, t0.features AS features_5, t0.limits AS limits_6, t0.included_modules AS included_modules_7, t0.visible AS visible_8, t0.starts_at AS starts_at_9, t0.ends_at AS ends_at_10, t0.created_at AS created_at_11, t0.plan_id AS plan_id_12 FROM subscription_plan_version t0 WHERE t0.plan_id = 1 ORDER BY t0.version_number DESC;
|
| 3 |
1.90 ms |
SELECT t0.id AS id_1, t0.version_number AS version_number_2, t0.currency AS currency_3, t0.billing_cycle AS billing_cycle_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.effective_to AS effective_to_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.plan_id AS plan_id_10 FROM subscription_price_version t0 WHERE t0.plan_id = ?
SELECT t0.id AS id_1, t0.version_number AS version_number_2, t0.currency AS currency_3, t0.billing_cycle AS billing_cycle_4, t0.amount AS amount_5, t0.effective_from AS effective_from_6, t0.effective_to AS effective_to_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.plan_id AS plan_id_10 FROM subscription_price_version t0 WHERE t0.plan_id = 1;
|