1 |
29.70 ms |
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.phone_number AS phone_number_2, a0_.password AS password_3, a0_.roles AS roles_4, a0_.lastname AS lastname_5, a0_.firstname AS firstname_6, a0_.created_at AS created_at_7, a0_.registration_source AS registration_source_8, a0_.honorific_prefix AS honorific_prefix_9, a0_.reset_token AS reset_token_10, a0_.reset_token_expiration_date AS reset_token_expiration_date_11, a0_.uniq_id AS uniq_id_12, a0_.code_confirmation AS code_confirmation_13, a0_.updated_at AS updated_at_14, a0_.is_active AS is_active_15 FROM app_users a0_ WHERE a0_.email = ? OR a0_.phone_number = ?
Parameters: [
"florian@digidom.pro"
"florian@digidom.pro"
]
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.phone_number AS phone_number_2, a0_.password AS password_3, a0_.roles AS roles_4, a0_.lastname AS lastname_5, a0_.firstname AS firstname_6, a0_.created_at AS created_at_7, a0_.registration_source AS registration_source_8, a0_.honorific_prefix AS honorific_prefix_9, a0_.reset_token AS reset_token_10, a0_.reset_token_expiration_date AS reset_token_expiration_date_11, a0_.uniq_id AS uniq_id_12, a0_.code_confirmation AS code_confirmation_13, a0_.updated_at AS updated_at_14, a0_.is_active AS is_active_15 FROM app_users a0_ WHERE a0_.email = 'florian@digidom.pro' OR a0_.phone_number = 'florian@digidom.pro';
|
2 |
1.15 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.unique_key AS unique_key_2, s0_.security_deposit AS security_deposit_3, s0_.is_active AS is_active_4, s0_.authorized_frequency AS authorized_frequency_5, s0_.created_at AS created_at_6, s0_.update_at AS update_at_7, s0_.price_without_tax AS price_without_tax_8, s0_.product_id AS product_id_9 FROM subscription_model s0_ ORDER BY s0_.id ASC LIMIT 30
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.unique_key AS unique_key_2, s0_.security_deposit AS security_deposit_3, s0_.is_active AS is_active_4, s0_.authorized_frequency AS authorized_frequency_5, s0_.created_at AS created_at_6, s0_.update_at AS update_at_7, s0_.price_without_tax AS price_without_tax_8, s0_.product_id AS product_id_9 FROM subscription_model s0_ ORDER BY s0_.id ASC LIMIT 30;
|
3 |
2.95 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 1;
|
4 |
3.06 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 2;
|
5 |
3.19 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 3;
|
6 |
2.43 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 4;
|
7 |
1.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = 6;
|
8 |
5.80 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 12;
|
9 |
5.45 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 17;
|
10 |
1.83 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 18;
|
11 |
1.67 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 19;
|
12 |
1.58 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 20;
|
13 |
1.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = 16;
|
14 |
1.73 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 21;
|
15 |
1.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = 17;
|
16 |
2.46 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 22;
|
17 |
4.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = 18;
|
18 |
1.53 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 23;
|
19 |
1.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = 15;
|
20 |
10.19 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 24;
|
21 |
1.54 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 25;
|
22 |
1.65 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 26;
|
23 |
1.94 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 27;
|
24 |
1.46 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 28;
|
25 |
1.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = 187;
|
26 |
1.57 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 29;
|
27 |
1.37 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = ?
SELECT
t0.id AS id_1,
t0.type AS type_2,
t0.price_without_tax AS price_without_tax_3,
t0.trial AS trial_4,
t0.remove_after_trial AS remove_after_trial_5,
t0.trial_period_length AS trial_period_length_6,
t0.created_at AS created_at_7,
t0.product_id AS product_id_8,
t9.id AS id_10,
t9.name AS name_11,
t9.alternate_name AS alternate_name_12,
t9.price_without_tax AS price_without_tax_13,
t9.description AS description_14,
t9.active AS active_15,
t9.meta_description AS meta_description_16,
t9.meta_title AS meta_title_17,
t9.url AS url_18,
t9.created_at AS created_at_19,
t9.subscription_type AS subscription_type_20,
t9.unique_key AS unique_key_21,
t9.is_displayed AS is_displayed_22,
t9.is_archived AS is_archived_23,
t9.is_subscription_component AS is_subscription_component_24,
t9.category_id AS category_id_25,
t9.category_for_billing_report_id AS category_for_billing_report_id_26,
t0.subscription_id AS subscription_id_27,
t28.id AS id_29,
t28.active AS active_30,
t28.price AS price_31,
t28.type AS type_32,
t28.subscription_deposit AS subscription_deposit_33,
t28.created_at AS created_at_34,
t28.discount_without_tax AS discount_without_tax_35,
t28.payment_dates AS payment_dates_36,
t28.price_without_tax AS price_without_tax_37,
t28.stored_total_price_without_tax AS stored_total_price_without_tax_38,
t28.is_updated_price AS is_updated_price_39,
t28.next_payment AS next_payment_40,
t28.pack_history AS pack_history_41,
t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42,
t28.invoice_generation_date AS invoice_generation_date_43,
t28.month_number AS month_number_44,
t28.authorized_reccurency AS authorized_reccurency_45,
t28.is_cancel_using_offer AS is_cancel_using_offer_46,
t28.is_digipack_offer AS is_digipack_offer_47,
t28.deadline_offered AS deadline_offered_48,
t28.prepaid_months AS prepaid_months_49,
t28.has_blocked_service AS has_blocked_service_50,
t28.document_recovery_delay AS document_recovery_delay_51,
t28.updated_at AS updated_at_52,
t28.organization_id AS organization_id_53,
t0.subscription_model_id AS subscription_model_id_54
FROM
service t0
INNER JOIN product t9 ON t0.product_id = t9.id
LEFT JOIN subscription t28 ON t0.subscription_id = t28.id
WHERE
t0.subscription_model_id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_model_id = 30;
|
28 |
2.13 ms |
SELECT COUNT(s0_.id) AS sclr_0 FROM subscription_model s0_
SELECT COUNT(s0_.id) AS sclr_0 FROM subscription_model s0_;
|