Symfony Profiler

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 = ?
      AND m0_.notification_read = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  5

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' AND m0_.notification_read = 0) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 5;

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
  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_.notification_read = ?
  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_.notification_read = 0 AND m0_.id IN (159550, 159545, 159540, 159534, 159529) ORDER BY m0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.referent AS referent_3,
  t0.hubspot_id AS hubspot_id_4,
  t0.company_id AS company_id_5,
  t0.user_id AS user_id_6,
  t0.known_id AS known_id_7
FROM
  user_company t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.referent AS referent_3, t0.hubspot_id AS hubspot_id_4, t0.company_id AS company_id_5, t0.user_id AS user_id_6, t0.known_id AS known_id_7 FROM user_company t0 WHERE t0.user_id = 637;