Symfony Profiler

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 = ?

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 = 'tokiarivelo@digidom.pro' OR a0_.phone_number = 'tokiarivelo@digidom.pro';

SELECT
  s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.price_without_tax AS price_without_tax_2,
  s0_.trial AS trial_3,
  s0_.remove_after_trial AS remove_after_trial_4,
  s0_.trial_period_length AS trial_period_length_5,
  s0_.created_at AS created_at_6,
  p1_.id AS id_7,
  p1_.name AS name_8,
  p1_.alternate_name AS alternate_name_9,
  p1_.price_without_tax AS price_without_tax_10,
  p1_.description AS description_11,
  p1_.active AS active_12,
  p1_.meta_description AS meta_description_13,
  p1_.meta_title AS meta_title_14,
  p1_.url AS url_15,
  p1_.created_at AS created_at_16,
  p1_.subscription_type AS subscription_type_17,
  p1_.unique_key AS unique_key_18,
  p1_.is_displayed AS is_displayed_19,
  p1_.is_archived AS is_archived_20,
  p1_.is_subscription_component AS is_subscription_component_21,
  s0_.product_id AS product_id_22,
  s0_.subscription_id AS subscription_id_23,
  s0_.subscription_model_id AS subscription_model_id_24,
  p1_.category_id AS category_id_25,
  p1_.category_for_billing_report_id AS category_for_billing_report_id_26
FROM
  service s0_
  INNER JOIN product p1_ ON s0_.product_id = p1_.id
WHERE
  s0_.subscription_id = ?
ORDER BY
  s0_.id ASC
LIMIT
  30

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.price_without_tax AS price_without_tax_2, s0_.trial AS trial_3, s0_.remove_after_trial AS remove_after_trial_4, s0_.trial_period_length AS trial_period_length_5, s0_.created_at AS created_at_6, p1_.id AS id_7, p1_.name AS name_8, p1_.alternate_name AS alternate_name_9, p1_.price_without_tax AS price_without_tax_10, p1_.description AS description_11, p1_.active AS active_12, p1_.meta_description AS meta_description_13, p1_.meta_title AS meta_title_14, p1_.url AS url_15, p1_.created_at AS created_at_16, p1_.subscription_type AS subscription_type_17, p1_.unique_key AS unique_key_18, p1_.is_displayed AS is_displayed_19, p1_.is_archived AS is_archived_20, p1_.is_subscription_component AS is_subscription_component_21, s0_.product_id AS product_id_22, s0_.subscription_id AS subscription_id_23, s0_.subscription_model_id AS subscription_model_id_24, p1_.category_id AS category_id_25, p1_.category_for_billing_report_id AS category_for_billing_report_id_26 FROM service s0_ INNER JOIN product p1_ ON s0_.product_id = p1_.id WHERE s0_.subscription_id = 36182 ORDER BY s0_.id ASC LIMIT 30;

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.price AS price_3,
  t0.type AS type_4,
  t0.subscription_deposit AS subscription_deposit_5,
  t0.created_at AS created_at_6,
  t0.discount_without_tax AS discount_without_tax_7,
  t0.payment_dates AS payment_dates_8,
  t0.price_without_tax AS price_without_tax_9,
  t0.stored_total_price_without_tax AS stored_total_price_without_tax_10,
  t0.is_updated_price AS is_updated_price_11,
  t0.next_payment AS next_payment_12,
  t0.pack_history AS pack_history_13,
  t0.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_14,
  t0.invoice_generation_date AS invoice_generation_date_15,
  t0.month_number AS month_number_16,
  t0.authorized_reccurency AS authorized_reccurency_17,
  t0.is_cancel_using_offer AS is_cancel_using_offer_18,
  t0.is_digipack_offer AS is_digipack_offer_19,
  t0.deadline_offered AS deadline_offered_20,
  t0.prepaid_months AS prepaid_months_21,
  t0.has_blocked_service AS has_blocked_service_22,
  t0.document_recovery_delay AS document_recovery_delay_23,
  t0.updated_at AS updated_at_24,
  t0.organization_id AS organization_id_25,
  t26.id AS id_27,
  t26.name AS name_28,
  t26.price AS price_29,
  t26.focus AS focus_30,
  t26.price_without_tax AS price_without_tax_31,
  t26.vat_rate AS vat_rate_32,
  t26.discount AS discount_33,
  t26.unique_key AS unique_key_34,
  t26.automation AS automation_35,
  t26.is_published AS is_published_36,
  t26.is_subscription AS is_subscription_37,
  t26.published_name AS published_name_38,
  t26.is_published_pack AS is_published_pack_39,
  t26.type AS type_40,
  t26.legal_status AS legal_status_41,
  t26.created_at AS created_at_42,
  t26.association_pack_id AS association_pack_id_43,
  t26.category_id AS category_id_44,
  t26.recurring_invoice_id AS recurring_invoice_id_45,
  t26.initial_invoice_id AS initial_invoice_id_46,
  t26.subscription_id AS subscription_id_47
FROM
  subscription t0
  LEFT JOIN pack t26 ON t26.subscription_id = t0.id
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.active AS active_2, t0.price AS price_3, t0.type AS type_4, t0.subscription_deposit AS subscription_deposit_5, t0.created_at AS created_at_6, t0.discount_without_tax AS discount_without_tax_7, t0.payment_dates AS payment_dates_8, t0.price_without_tax AS price_without_tax_9, t0.stored_total_price_without_tax AS stored_total_price_without_tax_10, t0.is_updated_price AS is_updated_price_11, t0.next_payment AS next_payment_12, t0.pack_history AS pack_history_13, t0.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_14, t0.invoice_generation_date AS invoice_generation_date_15, t0.month_number AS month_number_16, t0.authorized_reccurency AS authorized_reccurency_17, t0.is_cancel_using_offer AS is_cancel_using_offer_18, t0.is_digipack_offer AS is_digipack_offer_19, t0.deadline_offered AS deadline_offered_20, t0.prepaid_months AS prepaid_months_21, t0.has_blocked_service AS has_blocked_service_22, t0.document_recovery_delay AS document_recovery_delay_23, t0.updated_at AS updated_at_24, t0.organization_id AS organization_id_25, t26.id AS id_27, t26.name AS name_28, t26.price AS price_29, t26.focus AS focus_30, t26.price_without_tax AS price_without_tax_31, t26.vat_rate AS vat_rate_32, t26.discount AS discount_33, t26.unique_key AS unique_key_34, t26.automation AS automation_35, t26.is_published AS is_published_36, t26.is_subscription AS is_subscription_37, t26.published_name AS published_name_38, t26.is_published_pack AS is_published_pack_39, t26.type AS type_40, t26.legal_status AS legal_status_41, t26.created_at AS created_at_42, t26.association_pack_id AS association_pack_id_43, t26.category_id AS category_id_44, t26.recurring_invoice_id AS recurring_invoice_id_45, t26.initial_invoice_id AS initial_invoice_id_46, t26.subscription_id AS subscription_id_47 FROM subscription t0 LEFT JOIN pack t26 ON t26.subscription_id = t0.id WHERE t0.id IN (36182);

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  service s0_
  INNER JOIN product p1_ ON s0_.product_id = p1_.id
WHERE
  s0_.subscription_id = ?

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM service s0_ INNER JOIN product p1_ ON s0_.product_id = p1_.id WHERE s0_.subscription_id = 36182;