Symfony Profiler

SELECT
  e.id,
  e.subject,
  e.email_to_reply_id,
  e.receiver_type
FROM
  email e
WHERE
  e.receiver_id = :userId
  AND e.seen = false
  AND e.deleted_by_receiver IS NULL
  AND NOT EXISTS (
    SELECT
      1
    FROM
      email last_reply
    WHERE
      last_reply.email_to_reply_id = e.id
    HAVING
      MAX(last_reply.id) = (
        SELECT
          MAX(id)
        FROM
          email
        WHERE
          email_to_reply_id = e.id
          AND sender_id = :userId
          AND deleted_by_sender IS NULL
      )
  )

SELECT e.id, e.subject, e.email_to_reply_id, e.receiver_type
            FROM email e
            WHERE e.receiver_id = 201 AND e.seen = false AND e.deleted_by_receiver IS NULL
              AND NOT EXISTS (
                SELECT 1
                FROM email last_reply
                WHERE last_reply.email_to_reply_id = e.id
                HAVING MAX(last_reply.id) = (
                    SELECT MAX(id)
                    FROM email
                    WHERE email_to_reply_id = e.id
                      AND sender_id = 201
                      AND deleted_by_sender IS NULL
                )
            );

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.two_factor_code AS two_factor_code_6,
  t0.two_factor_code_expires_at AS two_factor_code_expires_at_7,
  t0.two_factor_temp_token AS two_factor_temp_token_8,
  t0.name AS name_9,
  t0.firstname AS firstname_10,
  t0.telephone AS telephone_11,
  t0.address AS address_12,
  t0.status AS status_13,
  t0.resettoken AS resettoken_14,
  t0.tradingname AS tradingname_15,
  t0.sir AS sir_16,
  t0.tva AS tva_17,
  t0.dispomon AS dispomon_18,
  t0.dispotue AS dispotue_19,
  t0.dispowed AS dispowed_20,
  t0.dispothu AS dispothu_21,
  t0.dispofri AS dispofri_22,
  t0.disposat AS disposat_23,
  t0.disposun AS disposun_24,
  t0.stripe_customer_id AS stripe_customer_id_25,
  t0.mgp_user_id AS mgp_user_id_26,
  t0.mgp_wallet_id AS mgp_wallet_id_27,
  t0.mgp_card_id AS mgp_card_id_28,
  t0.logo AS logo_29,
  t0.gender AS gender_30,
  t0.num_national_register AS num_national_register_31,
  t0.iban AS iban_32,
  t0.longitude AS longitude_33,
  t0.latitude AS latitude_34,
  t0.client_sales_agreement_discussions AS client_sales_agreement_discussions_35,
  t0.client_deed_of_sale_discussions AS client_deed_of_sale_discussions_36,
  t0.committee_avatar AS committee_avatar_37,
  t0.committee_surname AS committee_surname_38,
  t0.is_admin AS is_admin_39,
  t0.admin_id AS admin_id_40,
  t0.house_number AS house_number_41,
  t0.house_addition AS house_addition_42,
  t0.last_notification AS last_notification_43,
  t0.device_token AS device_token_44,
  t0.region AS region_45,
  t0.municipality AS municipality_46,
  t0.country AS country_47,
  t0.imported AS imported_48,
  t0.is_moving_company AS is_moving_company_49,
  t0.mail_id AS mail_id_50,
  t0.mail_mini AS mail_mini_51,
  t0.check_sum AS check_sum_52,
  t0.personnal_abonnement AS personnal_abonnement_53,
  t0.certification_area AS certification_area_54,
  t0.inbox_id AS inbox_id_55,
  t0.inbox_email AS inbox_email_56,
  t0.supplier_id AS supplier_id_57,
  t0.code_client AS code_client_58,
  t0.created AS created_59,
  t0.updated AS updated_60,
  t61.id AS id_62,
  t61.created AS created_63,
  t61.updated AS updated_64,
  t61.syndic_id AS syndic_id_65,
  t66.id AS id_67,
  t66.study AS study_68,
  t66.associate_name AS associate_name_69,
  t66.associate_firstname AS associate_firstname_70,
  t66.associate_email AS associate_email_71,
  t66.address AS address_72,
  t66.fax AS fax_73,
  t66.site AS site_74,
  t66.telephone AS telephone_75,
  t66.bce AS bce_76,
  t66.check_sum AS check_sum_77,
  t66.name AS name_78,
  t66.firstname AS firstname_79,
  t66.email AS email_80,
  t66.postal_code AS postal_code_81,
  t66.municipality AS municipality_82,
  t66.street AS street_83,
  t66.country AS country_84,
  t66.latitude AS latitude_85,
  t66.longitude AS longitude_86,
  t66.region AS region_87,
  t66.user_id AS user_id_88
FROM
  user t0
  LEFT JOIN co_ownership t61 ON t61.syndic_id = t0.id
  LEFT JOIN notary t66 ON t66.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.two_factor_code AS two_factor_code_6, t0.two_factor_code_expires_at AS two_factor_code_expires_at_7, t0.two_factor_temp_token AS two_factor_temp_token_8, t0.name AS name_9, t0.firstname AS firstname_10, t0.telephone AS telephone_11, t0.address AS address_12, t0.status AS status_13, t0.resettoken AS resettoken_14, t0.tradingname AS tradingname_15, t0.sir AS sir_16, t0.tva AS tva_17, t0.dispomon AS dispomon_18, t0.dispotue AS dispotue_19, t0.dispowed AS dispowed_20, t0.dispothu AS dispothu_21, t0.dispofri AS dispofri_22, t0.disposat AS disposat_23, t0.disposun AS disposun_24, t0.stripe_customer_id AS stripe_customer_id_25, t0.mgp_user_id AS mgp_user_id_26, t0.mgp_wallet_id AS mgp_wallet_id_27, t0.mgp_card_id AS mgp_card_id_28, t0.logo AS logo_29, t0.gender AS gender_30, t0.num_national_register AS num_national_register_31, t0.iban AS iban_32, t0.longitude AS longitude_33, t0.latitude AS latitude_34, t0.client_sales_agreement_discussions AS client_sales_agreement_discussions_35, t0.client_deed_of_sale_discussions AS client_deed_of_sale_discussions_36, t0.committee_avatar AS committee_avatar_37, t0.committee_surname AS committee_surname_38, t0.is_admin AS is_admin_39, t0.admin_id AS admin_id_40, t0.house_number AS house_number_41, t0.house_addition AS house_addition_42, t0.last_notification AS last_notification_43, t0.device_token AS device_token_44, t0.region AS region_45, t0.municipality AS municipality_46, t0.country AS country_47, t0.imported AS imported_48, t0.is_moving_company AS is_moving_company_49, t0.mail_id AS mail_id_50, t0.mail_mini AS mail_mini_51, t0.check_sum AS check_sum_52, t0.personnal_abonnement AS personnal_abonnement_53, t0.certification_area AS certification_area_54, t0.inbox_id AS inbox_id_55, t0.inbox_email AS inbox_email_56, t0.supplier_id AS supplier_id_57, t0.code_client AS code_client_58, t0.created AS created_59, t0.updated AS updated_60, t61.id AS id_62, t61.created AS created_63, t61.updated AS updated_64, t61.syndic_id AS syndic_id_65, t66.id AS id_67, t66.study AS study_68, t66.associate_name AS associate_name_69, t66.associate_firstname AS associate_firstname_70, t66.associate_email AS associate_email_71, t66.address AS address_72, t66.fax AS fax_73, t66.site AS site_74, t66.telephone AS telephone_75, t66.bce AS bce_76, t66.check_sum AS check_sum_77, t66.name AS name_78, t66.firstname AS firstname_79, t66.email AS email_80, t66.postal_code AS postal_code_81, t66.municipality AS municipality_82, t66.street AS street_83, t66.country AS country_84, t66.latitude AS latitude_85, t66.longitude AS longitude_86, t66.region AS region_87, t66.user_id AS user_id_88 FROM user t0 LEFT JOIN co_ownership t61 ON t61.syndic_id = t0.id LEFT JOIN notary t66 ON t66.user_id = t0.id WHERE t0.email = 'hasin@yopmail.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.stripe_subscription_id AS stripe_subscription_id_2,
  t0.status AS status_3,
  t0.current_period_start AS current_period_start_4,
  t0.current_period_end AS current_period_end_5,
  t0.cancel_at_period_end AS cancel_at_period_end_6,
  t0.cancellation_reason AS cancellation_reason_7,
  t0.canceled_at AS canceled_at_8,
  t0.plan_id AS plan_id_9,
  t0.user_id AS user_id_10
FROM
  plan_subscription t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.stripe_subscription_id AS stripe_subscription_id_2, t0.status AS status_3, t0.current_period_start AS current_period_start_4, t0.current_period_end AS current_period_end_5, t0.cancel_at_period_end AS cancel_at_period_end_6, t0.cancellation_reason AS cancellation_reason_7, t0.canceled_at AS canceled_at_8, t0.plan_id AS plan_id_9, t0.user_id AS user_id_10 FROM plan_subscription t0 WHERE t0.user_id = 201;