Symfony Profiler

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 = 949;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.extension AS extension_3,
  t0.created_at AS created_at_4,
  t0.title AS title_5,
  t0.name_file AS name_file_6,
  t0.description AS description_7,
  t0.not_visible_by_garage AS not_visible_by_garage_8,
  t0.type AS type_9,
  t0.folder_id AS folder_id_10,
  t0.recovery_id AS recovery_id_11,
  t0.invoice_id AS invoice_id_12,
  t0.created_by_id AS created_by_id_13,
  t0.mail_id AS mail_id_14,
  t0.message_id AS message_id_15
FROM
  document t0
WHERE
  t0.mail_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.created_at AS created_at_4, t0.title AS title_5, t0.name_file AS name_file_6, t0.description AS description_7, t0.not_visible_by_garage AS not_visible_by_garage_8, t0.type AS type_9, t0.folder_id AS folder_id_10, t0.recovery_id AS recovery_id_11, t0.invoice_id AS invoice_id_12, t0.created_by_id AS created_by_id_13, t0.mail_id AS mail_id_14, t0.message_id AS message_id_15 FROM document t0 WHERE t0.mail_id = 2330;

SELECT
  i0_.id AS id_0,
  i0_.read AS read_1,
  i0_.validated AS validated_2,
  i0_.info_id AS info_id_3,
  i0_.admin_id AS admin_id_4
FROM
  info_global_read i0_
  INNER JOIN info_global i1_ ON i0_.info_id = i1_.id
  INNER JOIN admin a2_ ON i0_.admin_id = a2_.id
WHERE
  i1_.published = true
  AND a2_.id = ?
  AND i0_.read = false
ORDER BY
  i1_.created_at DESC

SELECT i0_.id AS id_0, i0_.read AS read_1, i0_.validated AS validated_2, i0_.info_id AS info_id_3, i0_.admin_id AS admin_id_4 FROM info_global_read i0_ INNER JOIN info_global i1_ ON i0_.info_id = i1_.id INNER JOIN admin a2_ ON i0_.admin_id = a2_.id WHERE i1_.published = true AND a2_.id = 806 AND i0_.read = false ORDER BY i1_.created_at DESC;

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

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.id = 806;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.object AS object_3,
  t0.content AS content_4,
  t0.type AS type_5,
  t0.companie_id AS companie_id_6
FROM
  mail t0
WHERE
  t0.type = ?
  AND t0.companie_id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE t0.type = 'mail' AND t0.companie_id IN (949);

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 = 806;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.object AS object_3,
  t0.content AS content_4,
  t0.type AS type_5,
  t0.companie_id AS companie_id_6
FROM
  mail t0
WHERE
  (
    t0.type = ?
    AND t0.companie_id = ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.object AS object_3, t0.content AS content_4, t0.type AS type_5, t0.companie_id AS companie_id_6 FROM mail t0 WHERE (t0.type = 'mail' AND t0.companie_id = 949);