Symfony Profiler

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.rf_access_token AS rf_access_token_18,
  t0.rf_refresh_token AS rf_refresh_token_19,
  t0.service_id AS service_id_20,
  t0.notif_configuration_id AS notif_configuration_id_21,
  t0.mail_configuration_id AS mail_configuration_id_22
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.rf_access_token AS rf_access_token_18, t0.rf_refresh_token AS rf_refresh_token_19, t0.service_id AS service_id_20, t0.notif_configuration_id AS notif_configuration_id_21, t0.mail_configuration_id AS mail_configuration_id_22 FROM admin t0 WHERE t0.email = 'adel.oustad@gmail.com' LIMIT 1;

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.glazings_order AS glazings_order_79,
  t0.glazings_supplier_token_created_at AS glazings_supplier_token_created_at_80,
  t0.glazings_supplier_token AS glazings_supplier_token_81,
  t0.glazings_supplier_ship_code AS glazings_supplier_ship_code_82,
  t0.glace_order_option AS glace_order_option_83,
  t0.pilkington_id AS pilkington_id_84,
  t0.pilkington_password AS pilkington_password_85,
  t0.rf_organisation_id AS rf_organisation_id_86,
  t0.use_reseau_facture AS use_reseau_facture_87,
  t0.account_pilkington_id AS account_pilkington_id_88,
  t0.is_subscribed AS is_subscribed_89,
  t0.is_pre_subscription AS is_pre_subscription_90,
  t0.supplier_id AS supplier_id_91,
  t0.commercial_id AS commercial_id_92,
  t0.csm_id AS csm_id_93,
  t0.category_id AS category_id_94,
  t0.configuration_id AS configuration_id_95,
  t0.bridge_user_id AS bridge_user_id_96,
  t0.franchise_id AS franchise_id_97,
  t0.franchise_supplier_id AS franchise_supplier_id_98,
  t0.email_credential_id AS email_credential_id_99,
  t100.id AS id_101,
  t100.provider AS provider_102,
  t100.email AS email_103,
  t100.access_token AS access_token_104,
  t100.refresh_token AS refresh_token_105,
  t100.token_expires_at AS token_expires_at_106,
  t0.glace_order_adresse_id AS glace_order_adresse_id_107,
  t0.pilkington_account_request_id AS pilkington_account_request_id_108,
  t109.id AS id_110,
  t109.status AS status_111,
  t109.payment_method AS payment_method_112,
  t109.trial_start_date AS trial_start_date_113,
  t109.trial_end_date AS trial_end_date_114,
  t109.billing_mode AS billing_mode_115,
  t109.monthly_amount AS monthly_amount_116,
  t109.tax_rate AS tax_rate_117,
  t109.stripe_customer_id AS stripe_customer_id_118,
  t109.stripe_subscription_id AS stripe_subscription_id_119,
  t109.stripe_price_id AS stripe_price_id_120,
  t109.sepa_iban AS sepa_iban_121,
  t109.sepa_bic AS sepa_bic_122,
  t109.mandate_reference AS mandate_reference_123,
  t109.mandate_signature_date AS mandate_signature_date_124,
  t109.current_period_start AS current_period_start_125,
  t109.current_period_end AS current_period_end_126,
  t109.renewal_date AS renewal_date_127,
  t109.last_renewal_attempt AS last_renewal_attempt_128,
  t109.last_renewal_error AS last_renewal_error_129,
  t109.first_invoice_id AS first_invoice_id_130,
  t109.created_at AS created_at_131,
  t109.updated_at AS updated_at_132,
  t109.company_id AS company_id_133,
  t109.created_by_id AS created_by_id_134,
  t135.id AS id_136,
  t135.created_at AS created_at_137,
  t135.company_id AS company_id_138,
  t135.validated_by_id AS validated_by_id_139
FROM
  companie t0
  LEFT JOIN email_credential t100 ON t0.email_credential_id = t100.id
  LEFT JOIN subscription t109 ON t109.company_id = t0.id
  LEFT JOIN company_validation t135 ON t135.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.glazings_order AS glazings_order_79, t0.glazings_supplier_token_created_at AS glazings_supplier_token_created_at_80, t0.glazings_supplier_token AS glazings_supplier_token_81, t0.glazings_supplier_ship_code AS glazings_supplier_ship_code_82, t0.glace_order_option AS glace_order_option_83, t0.pilkington_id AS pilkington_id_84, t0.pilkington_password AS pilkington_password_85, t0.rf_organisation_id AS rf_organisation_id_86, t0.use_reseau_facture AS use_reseau_facture_87, t0.account_pilkington_id AS account_pilkington_id_88, t0.is_subscribed AS is_subscribed_89, t0.is_pre_subscription AS is_pre_subscription_90, t0.supplier_id AS supplier_id_91, t0.commercial_id AS commercial_id_92, t0.csm_id AS csm_id_93, t0.category_id AS category_id_94, t0.configuration_id AS configuration_id_95, t0.bridge_user_id AS bridge_user_id_96, t0.franchise_id AS franchise_id_97, t0.franchise_supplier_id AS franchise_supplier_id_98, t0.email_credential_id AS email_credential_id_99, t100.id AS id_101, t100.provider AS provider_102, t100.email AS email_103, t100.access_token AS access_token_104, t100.refresh_token AS refresh_token_105, t100.token_expires_at AS token_expires_at_106, t0.glace_order_adresse_id AS glace_order_adresse_id_107, t0.pilkington_account_request_id AS pilkington_account_request_id_108, t109.id AS id_110, t109.status AS status_111, t109.payment_method AS payment_method_112, t109.trial_start_date AS trial_start_date_113, t109.trial_end_date AS trial_end_date_114, t109.billing_mode AS billing_mode_115, t109.monthly_amount AS monthly_amount_116, t109.tax_rate AS tax_rate_117, t109.stripe_customer_id AS stripe_customer_id_118, t109.stripe_subscription_id AS stripe_subscription_id_119, t109.stripe_price_id AS stripe_price_id_120, t109.sepa_iban AS sepa_iban_121, t109.sepa_bic AS sepa_bic_122, t109.mandate_reference AS mandate_reference_123, t109.mandate_signature_date AS mandate_signature_date_124, t109.current_period_start AS current_period_start_125, t109.current_period_end AS current_period_end_126, t109.renewal_date AS renewal_date_127, t109.last_renewal_attempt AS last_renewal_attempt_128, t109.last_renewal_error AS last_renewal_error_129, t109.first_invoice_id AS first_invoice_id_130, t109.created_at AS created_at_131, t109.updated_at AS updated_at_132, t109.company_id AS company_id_133, t109.created_by_id AS created_by_id_134, t135.id AS id_136, t135.created_at AS created_at_137, t135.company_id AS company_id_138, t135.validated_by_id AS validated_by_id_139 FROM companie t0 LEFT JOIN email_credential t100 ON t0.email_credential_id = t100.id LEFT JOIN subscription t109 ON t109.company_id = t0.id LEFT JOIN company_validation t135 ON t135.company_id = t0.id WHERE t0.id = 412;

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 = 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_.lleida_checked_at AS lleida_checked_at_14,
  m0_.sent_at AS sent_at_15,
  m0_.delivered_at AS delivered_at_16,
  m0_.opened_at AS opened_at_17,
  m0_.status AS status_18,
  f1_.id AS id_19,
  f1_.registration AS registration_20,
  f1_.registration_normalized AS registration_normalized_21,
  f1_.vehicle_model AS vehicle_model_22,
  f1_.insurance_name AS insurance_name_23,
  f1_.appointment AS appointment_24,
  f1_.appointment_end AS appointment_end_25,
  f1_.status AS status_26,
  f1_.windscreen AS windscreen_27,
  f1_.insurance_card AS insurance_card_28,
  f1_.vehicle_card AS vehicle_card_29,
  f1_.created_at AS created_at_30,
  f1_.professional AS professional_31,
  f1_.tva_subject AS tva_subject_32,
  f1_.sensor AS sensor_33,
  f1_.athermal AS athermal_34,
  f1_.camera AS camera_35,
  f1_.glass AS glass_36,
  f1_.sinister_date AS sinister_date_37,
  f1_.declare_date AS declare_date_38,
  f1_.sinister_reason AS sinister_reason_39,
  f1_.sinister_circ AS sinister_circ_40,
  f1_.sinister_location AS sinister_location_41,
  f1_.travel_reason AS travel_reason_42,
  f1_.invoice_due AS invoice_due_43,
  f1_.deductible_amount AS deductible_amount_44,
  f1_.verified_deductible AS verified_deductible_45,
  f1_.insurance_number AS insurance_number_46,
  f1_.cca AS cca_47,
  f1_.procedure AS procedure_48,
  f1_.signed AS signed_49,
  f1_.signed_date AS signed_date_50,
  f1_.file AS file_51,
  f1_.known_by AS known_by_52,
  f1_.gift AS gift_53,
  f1_.adresse_pose AS adresse_pose_54,
  f1_.task AS task_55,
  f1_.updated_at AS updated_at_56,
  f1_.relance_at AS relance_at_57,
  f1_.is_paid AS is_paid_58,
  f1_.sinister_number AS sinister_number_59,
  f1_.is_assured AS is_assured_60,
  f1_.is_send_folder AS is_send_folder_61,
  f1_.is_send_invoice AS is_send_invoice_62,
  f1_.cancellation_reason AS cancellation_reason_63,
  f1_.cover AS cover_64,
  f1_.status_command AS status_command_65,
  f1_.ref AS ref_66,
  f1_.ref_client AS ref_client_67,
  f1_.km AS km_68,
  f1_.member_client AS member_client_69,
  f1_.member_garage AS member_garage_70,
  f1_.is_gift_send AS is_gift_send_71,
  f1_.status_updated AS status_updated_72,
  f1_.pattern_cover AS pattern_cover_73,
  f1_.judicial AS judicial_74,
  f1_.relance_updated_at AS relance_updated_at_75,
  f1_.relance_created_at AS relance_created_at_76,
  f1_.relance_after_at AS relance_after_at_77,
  f1_.sms_balance AS sms_balance_78,
  f1_.brand AS brand_79,
  f1_.mine_type AS mine_type_80,
  f1_.serial_number AS serial_number_81,
  f1_.wan_code AS wan_code_82,
  f1_.audatex_code AS audatex_code_83,
  f1_.euro_code AS euro_code_84,
  f1_.vin_identified AS vin_identified_85,
  f1_.sidexa_state AS sidexa_state_86,
  f1_.sidexa_vehicle_model AS sidexa_vehicle_model_87,
  f1_.data_updated AS data_updated_88,
  f1_.category AS category_89,
  f1_.department AS department_90,
  f1_.complexity AS complexity_91,
  f1_.repar AS repar_92,
  f1_.marge AS marge_93,
  f1_.appointment_update_reason AS appointment_update_reason_94,
  f1_.closing_date AS closing_date_95,
  f1_.planif_date AS planif_date_96,
  f1_.gap AS gap_97,
  f1_.offset_pose AS offset_pose_98,
  f1_.duplicate AS duplicate_99,
  f1_.couriers_parent_number AS couriers_parent_number_100,
  f1_.state AS state_101,
  f1_.quiz_sent_folder_submited AS quiz_sent_folder_submited_102,
  f1_.prime_date AS prime_date_103,
  f1_.insurance_card_added_at AS insurance_card_added_at_104,
  f1_.vehicle_card_added_at AS vehicle_card_added_at_105,
  f1_.windscreen_added_at AS windscreen_added_at_106,
  f1_.last_agent_update_at AS last_agent_update_at_107,
  f1_.openai_thread_id AS openai_thread_id_108,
  f1_.vehicle_description AS vehicle_description_109,
  f1_.has_partial_payment AS has_partial_payment_110,
  f1_.paid_gap_amount AS paid_gap_amount_111,
  f1_.gap_declarate_date AS gap_declarate_date_112,
  f1_.hubspot_id AS hubspot_id_113,
  f1_.ht_repair_order AS ht_repair_order_114,
  f1_.task_verif_closed_date AS task_verif_closed_date_115,
  f1_.first_signature_date AS first_signature_date_116,
  m0_.folder_id AS folder_id_117,
  m0_.recovery_id AS recovery_id_118,
  m0_.created_by_id AS created_by_id_119,
  m0_.registered_recipient_id AS registered_recipient_id_120,
  f1_.companie_id AS companie_id_121,
  f1_.customer_id AS customer_id_122,
  f1_.gestionnaire_id AS gestionnaire_id_123,
  f1_.created_by AS created_by_124,
  f1_.updated_by AS updated_by_125,
  f1_.technician_id AS technician_id_126,
  f1_.service_client_id AS service_client_id_127,
  f1_.agent_id AS agent_id_128,
  f1_.relanceur_id AS relanceur_id_129,
  f1_.recouvreur_id AS recouvreur_id_130,
  f1_.status_folder_id AS status_folder_id_131,
  f1_.insurance_name_new_id AS insurance_name_new_id_132,
  f1_.recovery_id AS recovery_id_133,
  f1_.known_id AS known_id_134
FROM
  message m0_
  LEFT JOIN folder f1_ ON m0_.folder_id = f1_.id
WHERE
  m0_.archived = ?
  AND m0_.registered_recipient_id = ?
  AND m0_.type = ?
  AND m0_.notification_read = ?
ORDER BY
  m0_.created_at DESC
LIMIT
  5

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_.lleida_checked_at AS lleida_checked_at_14, m0_.sent_at AS sent_at_15, m0_.delivered_at AS delivered_at_16, m0_.opened_at AS opened_at_17, m0_.status AS status_18, f1_.id AS id_19, f1_.registration AS registration_20, f1_.registration_normalized AS registration_normalized_21, f1_.vehicle_model AS vehicle_model_22, f1_.insurance_name AS insurance_name_23, f1_.appointment AS appointment_24, f1_.appointment_end AS appointment_end_25, f1_.status AS status_26, f1_.windscreen AS windscreen_27, f1_.insurance_card AS insurance_card_28, f1_.vehicle_card AS vehicle_card_29, f1_.created_at AS created_at_30, f1_.professional AS professional_31, f1_.tva_subject AS tva_subject_32, f1_.sensor AS sensor_33, f1_.athermal AS athermal_34, f1_.camera AS camera_35, f1_.glass AS glass_36, f1_.sinister_date AS sinister_date_37, f1_.declare_date AS declare_date_38, f1_.sinister_reason AS sinister_reason_39, f1_.sinister_circ AS sinister_circ_40, f1_.sinister_location AS sinister_location_41, f1_.travel_reason AS travel_reason_42, f1_.invoice_due AS invoice_due_43, f1_.deductible_amount AS deductible_amount_44, f1_.verified_deductible AS verified_deductible_45, f1_.insurance_number AS insurance_number_46, f1_.cca AS cca_47, f1_.procedure AS procedure_48, f1_.signed AS signed_49, f1_.signed_date AS signed_date_50, f1_.file AS file_51, f1_.known_by AS known_by_52, f1_.gift AS gift_53, f1_.adresse_pose AS adresse_pose_54, f1_.task AS task_55, f1_.updated_at AS updated_at_56, f1_.relance_at AS relance_at_57, f1_.is_paid AS is_paid_58, f1_.sinister_number AS sinister_number_59, f1_.is_assured AS is_assured_60, f1_.is_send_folder AS is_send_folder_61, f1_.is_send_invoice AS is_send_invoice_62, f1_.cancellation_reason AS cancellation_reason_63, f1_.cover AS cover_64, f1_.status_command AS status_command_65, f1_.ref AS ref_66, f1_.ref_client AS ref_client_67, f1_.km AS km_68, f1_.member_client AS member_client_69, f1_.member_garage AS member_garage_70, f1_.is_gift_send AS is_gift_send_71, f1_.status_updated AS status_updated_72, f1_.pattern_cover AS pattern_cover_73, f1_.judicial AS judicial_74, f1_.relance_updated_at AS relance_updated_at_75, f1_.relance_created_at AS relance_created_at_76, f1_.relance_after_at AS relance_after_at_77, f1_.sms_balance AS sms_balance_78, f1_.brand AS brand_79, f1_.mine_type AS mine_type_80, f1_.serial_number AS serial_number_81, f1_.wan_code AS wan_code_82, f1_.audatex_code AS audatex_code_83, f1_.euro_code AS euro_code_84, f1_.vin_identified AS vin_identified_85, f1_.sidexa_state AS sidexa_state_86, f1_.sidexa_vehicle_model AS sidexa_vehicle_model_87, f1_.data_updated AS data_updated_88, f1_.category AS category_89, f1_.department AS department_90, f1_.complexity AS complexity_91, f1_.repar AS repar_92, f1_.marge AS marge_93, f1_.appointment_update_reason AS appointment_update_reason_94, f1_.closing_date AS closing_date_95, f1_.planif_date AS planif_date_96, f1_.gap AS gap_97, f1_.offset_pose AS offset_pose_98, f1_.duplicate AS duplicate_99, f1_.couriers_parent_number AS couriers_parent_number_100, f1_.state AS state_101, f1_.quiz_sent_folder_submited AS quiz_sent_folder_submited_102, f1_.prime_date AS prime_date_103, f1_.insurance_card_added_at AS insurance_card_added_at_104, f1_.vehicle_card_added_at AS vehicle_card_added_at_105, f1_.windscreen_added_at AS windscreen_added_at_106, f1_.last_agent_update_at AS last_agent_update_at_107, f1_.openai_thread_id AS openai_thread_id_108, f1_.vehicle_description AS vehicle_description_109, f1_.has_partial_payment AS has_partial_payment_110, f1_.paid_gap_amount AS paid_gap_amount_111, f1_.gap_declarate_date AS gap_declarate_date_112, f1_.hubspot_id AS hubspot_id_113, f1_.ht_repair_order AS ht_repair_order_114, f1_.task_verif_closed_date AS task_verif_closed_date_115, f1_.first_signature_date AS first_signature_date_116, m0_.folder_id AS folder_id_117, m0_.recovery_id AS recovery_id_118, m0_.created_by_id AS created_by_id_119, m0_.registered_recipient_id AS registered_recipient_id_120, f1_.companie_id AS companie_id_121, f1_.customer_id AS customer_id_122, f1_.gestionnaire_id AS gestionnaire_id_123, f1_.created_by AS created_by_124, f1_.updated_by AS updated_by_125, f1_.technician_id AS technician_id_126, f1_.service_client_id AS service_client_id_127, f1_.agent_id AS agent_id_128, f1_.relanceur_id AS relanceur_id_129, f1_.recouvreur_id AS recouvreur_id_130, f1_.status_folder_id AS status_folder_id_131, f1_.insurance_name_new_id AS insurance_name_new_id_132, f1_.recovery_id AS recovery_id_133, f1_.known_id AS known_id_134 FROM message m0_ LEFT JOIN folder f1_ ON m0_.folder_id = f1_.id WHERE m0_.archived = 0 AND m0_.registered_recipient_id = 1 AND m0_.type = 'mercure' AND m0_.notification_read = 0 ORDER BY m0_.created_at DESC LIMIT 5;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  task t0_
WHERE
  t0_.category = ?
  AND t0_.status IN (?, ?)

SELECT COUNT(t0_.id) AS sclr_0 FROM task t0_ WHERE t0_.category = 2 AND t0_.status IN ('open', 'in progress');