Symfony Profiler

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  message m0_
  LEFT JOIN folder f1_ ON m0_.folder_id = f1_.id
WHERE
  m0_.archived = ?
  AND m0_.registered_recipient_id = ?
  AND f1_.companie_id = ?
  AND m0_.type = ?

SELECT COUNT(m0_.id) AS sclr_0 FROM message m0_ LEFT JOIN folder f1_ ON m0_.folder_id = f1_.id WHERE m0_.archived = 0 AND m0_.registered_recipient_id = 637 AND f1_.companie_id = 864 AND m0_.type = 'mercure';

SELECT
  t0.id AS id_1,
  t0.registration AS registration_2,
  t0.registration_normalized AS registration_normalized_3,
  t0.vehicle_model AS vehicle_model_4,
  t0.insurance_name AS insurance_name_5,
  t0.appointment AS appointment_6,
  t0.appointment_end AS appointment_end_7,
  t0.status AS status_8,
  t0.windscreen AS windscreen_9,
  t0.insurance_card AS insurance_card_10,
  t0.vehicle_card AS vehicle_card_11,
  t0.created_at AS created_at_12,
  t0.professional AS professional_13,
  t0.tva_subject AS tva_subject_14,
  t0.sensor AS sensor_15,
  t0.athermal AS athermal_16,
  t0.camera AS camera_17,
  t0.glass AS glass_18,
  t0.sinister_date AS sinister_date_19,
  t0.declare_date AS declare_date_20,
  t0.sinister_reason AS sinister_reason_21,
  t0.sinister_circ AS sinister_circ_22,
  t0.sinister_location AS sinister_location_23,
  t0.travel_reason AS travel_reason_24,
  t0.invoice_due AS invoice_due_25,
  t0.deductible_amount AS deductible_amount_26,
  t0.verified_deductible AS verified_deductible_27,
  t0.insurance_number AS insurance_number_28,
  t0.cca AS cca_29,
  t0.procedure AS procedure_30,
  t0.signed AS signed_31,
  t0.signed_date AS signed_date_32,
  t0.file AS file_33,
  t0.known_by AS known_by_34,
  t0.gift AS gift_35,
  t0.adresse_pose AS adresse_pose_36,
  t0.task AS task_37,
  t0.updated_at AS updated_at_38,
  t0.relance_at AS relance_at_39,
  t0.is_paid AS is_paid_40,
  t0.sinister_number AS sinister_number_41,
  t0.is_assured AS is_assured_42,
  t0.is_send_folder AS is_send_folder_43,
  t0.is_send_invoice AS is_send_invoice_44,
  t0.cancellation_reason AS cancellation_reason_45,
  t0.cover AS cover_46,
  t0.status_command AS status_command_47,
  t0.ref AS ref_48,
  t0.ref_client AS ref_client_49,
  t0.km AS km_50,
  t0.member_client AS member_client_51,
  t0.member_garage AS member_garage_52,
  t0.is_gift_send AS is_gift_send_53,
  t0.status_updated AS status_updated_54,
  t0.pattern_cover AS pattern_cover_55,
  t0.judicial AS judicial_56,
  t0.relance_updated_at AS relance_updated_at_57,
  t0.relance_created_at AS relance_created_at_58,
  t0.relance_after_at AS relance_after_at_59,
  t0.sms_balance AS sms_balance_60,
  t0.brand AS brand_61,
  t0.mine_type AS mine_type_62,
  t0.serial_number AS serial_number_63,
  t0.wan_code AS wan_code_64,
  t0.audatex_code AS audatex_code_65,
  t0.euro_code AS euro_code_66,
  t0.vin_identified AS vin_identified_67,
  t0.sidexa_state AS sidexa_state_68,
  t0.sidexa_vehicle_model AS sidexa_vehicle_model_69,
  t0.data_updated AS data_updated_70,
  t0.category AS category_71,
  t0.department AS department_72,
  t0.complexity AS complexity_73,
  t0.repar AS repar_74,
  t0.marge AS marge_75,
  t0.appointment_update_reason AS appointment_update_reason_76,
  t0.closing_date AS closing_date_77,
  t0.planif_date AS planif_date_78,
  t0.gap AS gap_79,
  t0.offset_pose AS offset_pose_80,
  t0.duplicate AS duplicate_81,
  t0.couriers_parent_number AS couriers_parent_number_82,
  t0.state AS state_83,
  t0.quiz_sent_folder_submited AS quiz_sent_folder_submited_84,
  t0.prime_date AS prime_date_85,
  t0.insurance_card_added_at AS insurance_card_added_at_86,
  t0.vehicle_card_added_at AS vehicle_card_added_at_87,
  t0.windscreen_added_at AS windscreen_added_at_88,
  t0.last_agent_update_at AS last_agent_update_at_89,
  t0.openai_thread_id AS openai_thread_id_90,
  t0.vehicle_description AS vehicle_description_91,
  t0.has_partial_payment AS has_partial_payment_92,
  t0.paid_gap_amount AS paid_gap_amount_93,
  t0.gap_declarate_date AS gap_declarate_date_94,
  t0.hubspot_id AS hubspot_id_95,
  t0.ht_repair_order AS ht_repair_order_96,
  t0.task_verif_closed_date AS task_verif_closed_date_97,
  t0.first_signature_date AS first_signature_date_98,
  t0.companie_id AS companie_id_99,
  t0.customer_id AS customer_id_100,
  t0.gestionnaire_id AS gestionnaire_id_101,
  t0.created_by AS created_by_102,
  t0.updated_by AS updated_by_103,
  t0.technician_id AS technician_id_104,
  t0.service_client_id AS service_client_id_105,
  t0.agent_id AS agent_id_106,
  t0.relanceur_id AS relanceur_id_107,
  t0.recouvreur_id AS recouvreur_id_108,
  t0.status_folder_id AS status_folder_id_109,
  t0.insurance_name_new_id AS insurance_name_new_id_110,
  t0.recovery_id AS recovery_id_111,
  t0.known_id AS known_id_112
FROM
  folder t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.registration AS registration_2, t0.registration_normalized AS registration_normalized_3, t0.vehicle_model AS vehicle_model_4, t0.insurance_name AS insurance_name_5, t0.appointment AS appointment_6, t0.appointment_end AS appointment_end_7, t0.status AS status_8, t0.windscreen AS windscreen_9, t0.insurance_card AS insurance_card_10, t0.vehicle_card AS vehicle_card_11, t0.created_at AS created_at_12, t0.professional AS professional_13, t0.tva_subject AS tva_subject_14, t0.sensor AS sensor_15, t0.athermal AS athermal_16, t0.camera AS camera_17, t0.glass AS glass_18, t0.sinister_date AS sinister_date_19, t0.declare_date AS declare_date_20, t0.sinister_reason AS sinister_reason_21, t0.sinister_circ AS sinister_circ_22, t0.sinister_location AS sinister_location_23, t0.travel_reason AS travel_reason_24, t0.invoice_due AS invoice_due_25, t0.deductible_amount AS deductible_amount_26, t0.verified_deductible AS verified_deductible_27, t0.insurance_number AS insurance_number_28, t0.cca AS cca_29, t0.procedure AS procedure_30, t0.signed AS signed_31, t0.signed_date AS signed_date_32, t0.file AS file_33, t0.known_by AS known_by_34, t0.gift AS gift_35, t0.adresse_pose AS adresse_pose_36, t0.task AS task_37, t0.updated_at AS updated_at_38, t0.relance_at AS relance_at_39, t0.is_paid AS is_paid_40, t0.sinister_number AS sinister_number_41, t0.is_assured AS is_assured_42, t0.is_send_folder AS is_send_folder_43, t0.is_send_invoice AS is_send_invoice_44, t0.cancellation_reason AS cancellation_reason_45, t0.cover AS cover_46, t0.status_command AS status_command_47, t0.ref AS ref_48, t0.ref_client AS ref_client_49, t0.km AS km_50, t0.member_client AS member_client_51, t0.member_garage AS member_garage_52, t0.is_gift_send AS is_gift_send_53, t0.status_updated AS status_updated_54, t0.pattern_cover AS pattern_cover_55, t0.judicial AS judicial_56, t0.relance_updated_at AS relance_updated_at_57, t0.relance_created_at AS relance_created_at_58, t0.relance_after_at AS relance_after_at_59, t0.sms_balance AS sms_balance_60, t0.brand AS brand_61, t0.mine_type AS mine_type_62, t0.serial_number AS serial_number_63, t0.wan_code AS wan_code_64, t0.audatex_code AS audatex_code_65, t0.euro_code AS euro_code_66, t0.vin_identified AS vin_identified_67, t0.sidexa_state AS sidexa_state_68, t0.sidexa_vehicle_model AS sidexa_vehicle_model_69, t0.data_updated AS data_updated_70, t0.category AS category_71, t0.department AS department_72, t0.complexity AS complexity_73, t0.repar AS repar_74, t0.marge AS marge_75, t0.appointment_update_reason AS appointment_update_reason_76, t0.closing_date AS closing_date_77, t0.planif_date AS planif_date_78, t0.gap AS gap_79, t0.offset_pose AS offset_pose_80, t0.duplicate AS duplicate_81, t0.couriers_parent_number AS couriers_parent_number_82, t0.state AS state_83, t0.quiz_sent_folder_submited AS quiz_sent_folder_submited_84, t0.prime_date AS prime_date_85, t0.insurance_card_added_at AS insurance_card_added_at_86, t0.vehicle_card_added_at AS vehicle_card_added_at_87, t0.windscreen_added_at AS windscreen_added_at_88, t0.last_agent_update_at AS last_agent_update_at_89, t0.openai_thread_id AS openai_thread_id_90, t0.vehicle_description AS vehicle_description_91, t0.has_partial_payment AS has_partial_payment_92, t0.paid_gap_amount AS paid_gap_amount_93, t0.gap_declarate_date AS gap_declarate_date_94, t0.hubspot_id AS hubspot_id_95, t0.ht_repair_order AS ht_repair_order_96, t0.task_verif_closed_date AS task_verif_closed_date_97, t0.first_signature_date AS first_signature_date_98, t0.companie_id AS companie_id_99, t0.customer_id AS customer_id_100, t0.gestionnaire_id AS gestionnaire_id_101, t0.created_by AS created_by_102, t0.updated_by AS updated_by_103, t0.technician_id AS technician_id_104, t0.service_client_id AS service_client_id_105, t0.agent_id AS agent_id_106, t0.relanceur_id AS relanceur_id_107, t0.recouvreur_id AS recouvreur_id_108, t0.status_folder_id AS status_folder_id_109, t0.insurance_name_new_id AS insurance_name_new_id_110, t0.recovery_id AS recovery_id_111, t0.known_id AS known_id_112 FROM folder t0 WHERE t0.id = 20451;

SELECT
  t0.id AS id_1,
  t0.siret AS siret_2,
  t0.name AS name_3,
  t0.trade_name AS trade_name_4,
  t0.iban AS iban_5,
  t0.tva_number AS tva_number_6,
  t0.created_at AS created_at_7,
  t0.email AS email_8,
  t0.logo AS logo_9,
  t0.phone AS phone_10,
  t0.bic AS bic_11,
  t0.price AS price_12,
  t0.price_no_decla AS price_no_decla_13,
  t0.stripe_id AS stripe_id_14,
  t0.jeton AS jeton_15,
  t0.is_supplier AS is_supplier_16,
  t0.is_prospect AS is_prospect_17,
  t0.is_active AS is_active_18,
  t0.comment AS comment_19,
  t0.invoice_number_prefix AS invoice_number_prefix_20,
  t0.invoice_number_start_counter AS invoice_number_start_counter_21,
  t0.invoice_number_reset_counter AS invoice_number_reset_counter_22,
  t0.number_of_digits_for_invoice_number AS number_of_digits_for_invoice_number_23,
  t0.quotation_number_prefix AS quotation_number_prefix_24,
  t0.quotation_number_start_counter AS quotation_number_start_counter_25,
  t0.quotation_number_reset_counter AS quotation_number_reset_counter_26,
  t0.number_of_digits_for_quotation_number AS number_of_digits_for_quotation_number_27,
  t0.is_no_same_number AS is_no_same_number_28,
  t0.credit_number_prefix AS credit_number_prefix_29,
  t0.lat AS lat_30,
  t0.lng AS lng_31,
  t0.identite_recto AS identite_recto_32,
  t0.identite_verso AS identite_verso_33,
  t0.kbis AS kbis_34,
  t0.rib AS rib_35,
  t0.unsubmit_tva AS unsubmit_tva_36,
  t0.supplier_hello_glass AS supplier_hello_glass_37,
  t0.ape AS ape_38,
  t0.difficulty AS difficulty_39,
  t0.stripe_tax_rate_id AS stripe_tax_rate_id_40,
  t0.tax_rate AS tax_rate_41,
  t0.clearbus AS clearbus_42,
  t0.morning_start AS morning_start_43,
  t0.morning_end AS morning_end_44,
  t0.afternoon_start AS afternoon_start_45,
  t0.afternoon_end AS afternoon_end_46,
  t0.morning_saturday_start AS morning_saturday_start_47,
  t0.morning_saturday_end AS morning_saturday_end_48,
  t0.afternoon_saturday_start AS afternoon_saturday_start_49,
  t0.afternoon_saturday_end AS afternoon_saturday_end_50,
  t0.prime AS prime_51,
  t0.verso_invoice AS verso_invoice_52,
  t0.charge_folder AS charge_folder_53,
  t0.comment_update AS comment_update_54,
  t0.known_name AS known_name_55,
  t0.gifts AS gifts_56,
  t0.customer_authorisation AS customer_authorisation_57,
  t0.garage_type AS garage_type_58,
  t0.contractual_franchise AS contractual_franchise_59,
  t0.other_authorisation AS other_authorisation_60,
  t0.other_gifts AS other_gifts_61,
  t0.blocked AS blocked_62,
  t0.id_garage AS id_garage_63,
  t0.email_api AS email_api_64,
  t0.paid_date_day AS paid_date_day_65,
  t0.payment_method AS payment_method_66,
  t0.acquisition_source AS acquisition_source_67,
  t0.acquisition_source_detail AS acquisition_source_detail_68,
  t0.is_premium AS is_premium_69,
  t0.legal_form AS legal_form_70,
  t0.tax_regime AS tax_regime_71,
  t0.share_capital AS share_capital_72,
  t0.rcs AS rcs_73,
  t0.terms_and_conditions_file AS terms_and_conditions_file_74,
  t0.apply_terms_for_invoice AS apply_terms_for_invoice_75,
  t0.apply_terms_for_quote AS apply_terms_for_quote_76,
  t0.apply_terms_for_repair_order AS apply_terms_for_repair_order_77,
  t0.hubspot_id AS hubspot_id_78,
  t0.supplier_id AS supplier_id_79,
  t0.commercial_id AS commercial_id_80,
  t0.category_id AS category_id_81,
  t0.configuration_id AS configuration_id_82,
  t0.bridge_user_id AS bridge_user_id_83,
  t0.franchise_id AS franchise_id_84,
  t0.franchise_supplier_id AS franchise_supplier_id_85,
  t86.id AS id_87,
  t86.provider AS provider_88,
  t86.email AS email_89,
  t86.access_token AS access_token_90,
  t86.refresh_token AS refresh_token_91,
  t86.token_expires_at AS token_expires_at_92,
  t86.company_id AS company_id_93
FROM
  companie t0
  LEFT JOIN email_credential t86 ON t86.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.siret AS siret_2, t0.name AS name_3, t0.trade_name AS trade_name_4, t0.iban AS iban_5, t0.tva_number AS tva_number_6, t0.created_at AS created_at_7, t0.email AS email_8, t0.logo AS logo_9, t0.phone AS phone_10, t0.bic AS bic_11, t0.price AS price_12, t0.price_no_decla AS price_no_decla_13, t0.stripe_id AS stripe_id_14, t0.jeton AS jeton_15, t0.is_supplier AS is_supplier_16, t0.is_prospect AS is_prospect_17, t0.is_active AS is_active_18, t0.comment AS comment_19, t0.invoice_number_prefix AS invoice_number_prefix_20, t0.invoice_number_start_counter AS invoice_number_start_counter_21, t0.invoice_number_reset_counter AS invoice_number_reset_counter_22, t0.number_of_digits_for_invoice_number AS number_of_digits_for_invoice_number_23, t0.quotation_number_prefix AS quotation_number_prefix_24, t0.quotation_number_start_counter AS quotation_number_start_counter_25, t0.quotation_number_reset_counter AS quotation_number_reset_counter_26, t0.number_of_digits_for_quotation_number AS number_of_digits_for_quotation_number_27, t0.is_no_same_number AS is_no_same_number_28, t0.credit_number_prefix AS credit_number_prefix_29, t0.lat AS lat_30, t0.lng AS lng_31, t0.identite_recto AS identite_recto_32, t0.identite_verso AS identite_verso_33, t0.kbis AS kbis_34, t0.rib AS rib_35, t0.unsubmit_tva AS unsubmit_tva_36, t0.supplier_hello_glass AS supplier_hello_glass_37, t0.ape AS ape_38, t0.difficulty AS difficulty_39, t0.stripe_tax_rate_id AS stripe_tax_rate_id_40, t0.tax_rate AS tax_rate_41, t0.clearbus AS clearbus_42, t0.morning_start AS morning_start_43, t0.morning_end AS morning_end_44, t0.afternoon_start AS afternoon_start_45, t0.afternoon_end AS afternoon_end_46, t0.morning_saturday_start AS morning_saturday_start_47, t0.morning_saturday_end AS morning_saturday_end_48, t0.afternoon_saturday_start AS afternoon_saturday_start_49, t0.afternoon_saturday_end AS afternoon_saturday_end_50, t0.prime AS prime_51, t0.verso_invoice AS verso_invoice_52, t0.charge_folder AS charge_folder_53, t0.comment_update AS comment_update_54, t0.known_name AS known_name_55, t0.gifts AS gifts_56, t0.customer_authorisation AS customer_authorisation_57, t0.garage_type AS garage_type_58, t0.contractual_franchise AS contractual_franchise_59, t0.other_authorisation AS other_authorisation_60, t0.other_gifts AS other_gifts_61, t0.blocked AS blocked_62, t0.id_garage AS id_garage_63, t0.email_api AS email_api_64, t0.paid_date_day AS paid_date_day_65, t0.payment_method AS payment_method_66, t0.acquisition_source AS acquisition_source_67, t0.acquisition_source_detail AS acquisition_source_detail_68, t0.is_premium AS is_premium_69, t0.legal_form AS legal_form_70, t0.tax_regime AS tax_regime_71, t0.share_capital AS share_capital_72, t0.rcs AS rcs_73, t0.terms_and_conditions_file AS terms_and_conditions_file_74, t0.apply_terms_for_invoice AS apply_terms_for_invoice_75, t0.apply_terms_for_quote AS apply_terms_for_quote_76, t0.apply_terms_for_repair_order AS apply_terms_for_repair_order_77, t0.hubspot_id AS hubspot_id_78, t0.supplier_id AS supplier_id_79, t0.commercial_id AS commercial_id_80, t0.category_id AS category_id_81, t0.configuration_id AS configuration_id_82, t0.bridge_user_id AS bridge_user_id_83, t0.franchise_id AS franchise_id_84, t0.franchise_supplier_id AS franchise_supplier_id_85, t86.id AS id_87, t86.provider AS provider_88, t86.email AS email_89, t86.access_token AS access_token_90, t86.refresh_token AS refresh_token_91, t86.token_expires_at AS token_expires_at_92, t86.company_id AS company_id_93 FROM companie t0 LEFT JOIN email_credential t86 ON t86.company_id = t0.id WHERE t0.id = 864;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.firstname AS firstname_6,
  t0.name AS name_7,
  t0.is_active AS is_active_8,
  t0.partenaire AS partenaire_9,
  t0.last_login AS last_login_10,
  t0.is_ready AS is_ready_11,
  t0.referent AS referent_12,
  t0.difficulty AS difficulty_13,
  t0.is_premium AS is_premium_14,
  t0.is_gold AS is_gold_15,
  t0.tokens_invalidated_at AS tokens_invalidated_at_16,
  t0.hubspot_id AS hubspot_id_17,
  t0.service_id AS service_id_18,
  t0.notif_configuration_id AS notif_configuration_id_19,
  t0.mail_configuration_id AS mail_configuration_id_20
FROM
  admin t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.firstname AS firstname_6, t0.name AS name_7, t0.is_active AS is_active_8, t0.partenaire AS partenaire_9, t0.last_login AS last_login_10, t0.is_ready AS is_ready_11, t0.referent AS referent_12, t0.difficulty AS difficulty_13, t0.is_premium AS is_premium_14, t0.is_gold AS is_gold_15, t0.tokens_invalidated_at AS tokens_invalidated_at_16, t0.hubspot_id AS hubspot_id_17, t0.service_id AS service_id_18, t0.notif_configuration_id AS notif_configuration_id_19, t0.mail_configuration_id AS mail_configuration_id_20 FROM admin t0 WHERE t0.email = 'poseuradmin@reseauglass.fr' LIMIT 1;

SELECT
  DISTINCT id_0,
  MIN(sclr_18) AS dctrn_minrownum
FROM
  (
    SELECT
      m0_.id AS id_0,
      m0_.type AS type_1,
      m0_.recipient_email AS recipient_email_2,
      m0_.subject AS subject_3,
      m0_.content AS content_4,
      m0_.created_at AS created_at_5,
      m0_.notification_read AS notification_read_6,
      m0_.link AS link_7,
      m0_.archived AS archived_8,
      m0_.couriers_parent_number AS couriers_parent_number_9,
      m0_.type_folder AS type_folder_10,
      m0_.sms_count AS sms_count_11,
      m0_.external_id AS external_id_12,
      m0_.last_update AS last_update_13,
      m0_.sent_at AS sent_at_14,
      m0_.delivered_at AS delivered_at_15,
      m0_.opened_at AS opened_at_16,
      m0_.status AS status_17,
      ROW_NUMBER() OVER(
        ORDER BY
          m0_.created_at DESC
      ) AS sclr_18
    FROM
      message m0_
      INNER JOIN folder f1_ ON m0_.folder_id = f1_.id
    WHERE
      m0_.archived = ?
      AND m0_.registered_recipient_id = ?
      AND f1_.companie_id = ?
      AND m0_.type = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  10

SELECT DISTINCT id_0, MIN(sclr_18) AS dctrn_minrownum FROM (SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.recipient_email AS recipient_email_2, m0_.subject AS subject_3, m0_.content AS content_4, m0_.created_at AS created_at_5, m0_.notification_read AS notification_read_6, m0_.link AS link_7, m0_.archived AS archived_8, m0_.couriers_parent_number AS couriers_parent_number_9, m0_.type_folder AS type_folder_10, m0_.sms_count AS sms_count_11, m0_.external_id AS external_id_12, m0_.last_update AS last_update_13, m0_.sent_at AS sent_at_14, m0_.delivered_at AS delivered_at_15, m0_.opened_at AS opened_at_16, m0_.status AS status_17, ROW_NUMBER() OVER(ORDER BY m0_.created_at DESC) AS sclr_18 FROM message m0_ INNER JOIN folder f1_ ON m0_.folder_id = f1_.id WHERE m0_.archived = 0 AND m0_.registered_recipient_id = 637 AND f1_.companie_id = 864 AND m0_.type = 'mercure') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.firstname AS firstname_3,
  t0.email AS email_4,
  t0.address AS address_5,
  t0.phone AS phone_6,
  t0.postal_code AS postal_code_7,
  t0.town AS town_8,
  t0.siret AS siret_9,
  t0.rcs AS rcs_10,
  t0.tva_number AS tva_number_11,
  t0.derogation_regime AS derogation_regime_12,
  t0.is_professional AS is_professional_13,
  t0.is_tva_subject AS is_tva_subject_14
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.email AS email_4, t0.address AS address_5, t0.phone AS phone_6, t0.postal_code AS postal_code_7, t0.town AS town_8, t0.siret AS siret_9, t0.rcs AS rcs_10, t0.tva_number AS tva_number_11, t0.derogation_regime AS derogation_regime_12, t0.is_professional AS is_professional_13, t0.is_tva_subject AS is_tva_subject_14 FROM customer t0 WHERE t0.id = 23288;

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.recipient_email AS recipient_email_2,
  m0_.subject AS subject_3,
  m0_.content AS content_4,
  m0_.created_at AS created_at_5,
  m0_.notification_read AS notification_read_6,
  m0_.link AS link_7,
  m0_.archived AS archived_8,
  m0_.couriers_parent_number AS couriers_parent_number_9,
  m0_.type_folder AS type_folder_10,
  m0_.sms_count AS sms_count_11,
  m0_.external_id AS external_id_12,
  m0_.last_update AS last_update_13,
  m0_.sent_at AS sent_at_14,
  m0_.delivered_at AS delivered_at_15,
  m0_.opened_at AS opened_at_16,
  m0_.status AS status_17,
  m0_.folder_id AS folder_id_18,
  m0_.recovery_id AS recovery_id_19,
  m0_.created_by_id AS created_by_id_20,
  m0_.registered_recipient_id AS registered_recipient_id_21
FROM
  message m0_
  INNER JOIN folder f1_ ON m0_.folder_id = f1_.id
WHERE
  m0_.archived = ?
  AND m0_.registered_recipient_id = ?
  AND f1_.companie_id = ?
  AND m0_.type = ?
  AND m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.recipient_email AS recipient_email_2, m0_.subject AS subject_3, m0_.content AS content_4, m0_.created_at AS created_at_5, m0_.notification_read AS notification_read_6, m0_.link AS link_7, m0_.archived AS archived_8, m0_.couriers_parent_number AS couriers_parent_number_9, m0_.type_folder AS type_folder_10, m0_.sms_count AS sms_count_11, m0_.external_id AS external_id_12, m0_.last_update AS last_update_13, m0_.sent_at AS sent_at_14, m0_.delivered_at AS delivered_at_15, m0_.opened_at AS opened_at_16, m0_.status AS status_17, m0_.folder_id AS folder_id_18, m0_.recovery_id AS recovery_id_19, m0_.created_by_id AS created_by_id_20, m0_.registered_recipient_id AS registered_recipient_id_21 FROM message m0_ INNER JOIN folder f1_ ON m0_.folder_id = f1_.id WHERE m0_.archived = 0 AND m0_.registered_recipient_id = 637 AND f1_.companie_id = 864 AND m0_.type = 'mercure' AND m0_.id IN (159550, 159545, 159540, 159534, 159529, 159524, 159519, 159512, 159506, 159500) ORDER BY m0_.created_at DESC;