Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

1.55 ms Query time

2 Invalid entities

11 Managed entities

Queries

Group similar statements

master connection

#▲	Time	Info
1	0.19 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.google_auth_enabled AS google_auth_enabled_10, t0.email_auth_code AS email_auth_code_11, t0.email_auth_enabled AS email_auth_enabled_12, t0.company_id AS company_id_13 FROM users t0 WHERE t0.email = ? LIMIT 1 Parameters: [`"contact@carteblanche67.fr"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.google_auth_enabled AS google_auth_enabled_10, t0.email_auth_code AS email_auth_code_11, t0.email_auth_enabled AS email_auth_enabled_12, t0.company_id AS company_id_13 FROM users 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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.google_auth_enabled AS google_auth_enabled_10, t0.email_auth_code AS email_auth_code_11, t0.email_auth_enabled AS email_auth_enabled_12, t0.company_id AS company_id_13 FROM users t0 WHERE t0.email = 'contact@carteblanche67.fr' LIMIT 1;
2	0.39 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t6.id AS id_7, t6.logo AS logo_8, t6.primary_color AS primary_color_9, t6.secondary_color AS secondary_color_10, t6.address AS address_11, t6.phone AS phone_12, t6.email AS email_13, t6.siret AS siret_14, t6.tva_number AS tva_number_15, t6.footer_text AS footer_text_16, t6.legal_form AS legal_form_17, t6.capital AS capital_18, t6.rcs AS rcs_19, t6.iban AS iban_20, t6.bic AS bic_21, t6.bank_name AS bank_name_22, t6.website AS website_23, t6.invoice_prefix AS invoice_prefix_24, t6.quote_prefix AS quote_prefix_25, t6.quote_reference_template AS quote_reference_template_26, t6.invoice_reference_template AS invoice_reference_template_27, t6.credit_note_reference_template AS credit_note_reference_template_28, t6.order_reference_template AS order_reference_template_29, t6.pdf_template AS pdf_template_30, t6.show_signature AS show_signature_31, t6.show_iban AS show_iban_32, t6.payment_delay AS payment_delay_33, t6.payment_methods AS payment_methods_34, t6.default_tva_rate AS default_tva_rate_35, t6.smtp_enabled AS smtp_enabled_36, t6.smtp_host AS smtp_host_37, t6.smtp_port AS smtp_port_38, t6.smtp_user AS smtp_user_39, t6.smtp_password_encrypted AS smtp_password_encrypted_40, t6.smtp_encryption AS smtp_encryption_41, t6.smtp_from_email AS smtp_from_email_42, t6.smtp_from_name AS smtp_from_name_43, t6.cgv_texte AS cgv_texte_44, t6.cgv_devis AS cgv_devis_45, t6.cgv_commande AS cgv_commande_46, t6.cgv_facture AS cgv_facture_47, t6.cgv_avoir AS cgv_avoir_48, t6.company_id AS company_id_49 FROM companies t0 LEFT JOIN company_configs t6 ON t6.company_id = t0.id WHERE t0.id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t6.id AS id_7, t6.logo AS logo_8, t6.primary_color AS primary_color_9, t6.secondary_color AS secondary_color_10, t6.address AS address_11, t6.phone AS phone_12, t6.email AS email_13, t6.siret AS siret_14, t6.tva_number AS tva_number_15, t6.footer_text AS footer_text_16, t6.legal_form AS legal_form_17, t6.capital AS capital_18, t6.rcs AS rcs_19, t6.iban AS iban_20, t6.bic AS bic_21, t6.bank_name AS bank_name_22, t6.website AS website_23, t6.invoice_prefix AS invoice_prefix_24, t6.quote_prefix AS quote_prefix_25, t6.quote_reference_template AS quote_reference_template_26, t6.invoice_reference_template AS invoice_reference_template_27, t6.credit_note_reference_template AS credit_note_reference_template_28, t6.order_reference_template AS order_reference_template_29, t6.pdf_template AS pdf_template_30, t6.show_signature AS show_signature_31, t6.show_iban AS show_iban_32, t6.payment_delay AS payment_delay_33, t6.payment_methods AS payment_methods_34, t6.default_tva_rate AS default_tva_rate_35, t6.smtp_enabled AS smtp_enabled_36, t6.smtp_host AS smtp_host_37, t6.smtp_port AS smtp_port_38, t6.smtp_user AS smtp_user_39, t6.smtp_password_encrypted AS smtp_password_encrypted_40, t6.smtp_encryption AS smtp_encryption_41, t6.smtp_from_email AS smtp_from_email_42, t6.smtp_from_name AS smtp_from_name_43, t6.cgv_texte AS cgv_texte_44, t6.cgv_devis AS cgv_devis_45, t6.cgv_commande AS cgv_commande_46, t6.cgv_facture AS cgv_facture_47, t6.cgv_avoir AS cgv_avoir_48, t6.company_id AS company_id_49 FROM companies t0 LEFT JOIN company_configs t6 ON t6.company_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t6.id AS id_7, t6.logo AS logo_8, t6.primary_color AS primary_color_9, t6.secondary_color AS secondary_color_10, t6.address AS address_11, t6.phone AS phone_12, t6.email AS email_13, t6.siret AS siret_14, t6.tva_number AS tva_number_15, t6.footer_text AS footer_text_16, t6.legal_form AS legal_form_17, t6.capital AS capital_18, t6.rcs AS rcs_19, t6.iban AS iban_20, t6.bic AS bic_21, t6.bank_name AS bank_name_22, t6.website AS website_23, t6.invoice_prefix AS invoice_prefix_24, t6.quote_prefix AS quote_prefix_25, t6.quote_reference_template AS quote_reference_template_26, t6.invoice_reference_template AS invoice_reference_template_27, t6.credit_note_reference_template AS credit_note_reference_template_28, t6.order_reference_template AS order_reference_template_29, t6.pdf_template AS pdf_template_30, t6.show_signature AS show_signature_31, t6.show_iban AS show_iban_32, t6.payment_delay AS payment_delay_33, t6.payment_methods AS payment_methods_34, t6.default_tva_rate AS default_tva_rate_35, t6.smtp_enabled AS smtp_enabled_36, t6.smtp_host AS smtp_host_37, t6.smtp_port AS smtp_port_38, t6.smtp_user AS smtp_user_39, t6.smtp_password_encrypted AS smtp_password_encrypted_40, t6.smtp_encryption AS smtp_encryption_41, t6.smtp_from_email AS smtp_from_email_42, t6.smtp_from_name AS smtp_from_name_43, t6.cgv_texte AS cgv_texte_44, t6.cgv_devis AS cgv_devis_45, t6.cgv_commande AS cgv_commande_46, t6.cgv_facture AS cgv_facture_47, t6.cgv_avoir AS cgv_avoir_48, t6.company_id AS company_id_49 FROM companies t0 LEFT JOIN company_configs t6 ON t6.company_id = t0.id WHERE t0.id = 7;
3	0.27 ms	SELECT t0.id AS id_1, t0.logo AS logo_2, t0.primary_color AS primary_color_3, t0.secondary_color AS secondary_color_4, t0.address AS address_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.footer_text AS footer_text_10, t0.legal_form AS legal_form_11, t0.capital AS capital_12, t0.rcs AS rcs_13, t0.iban AS iban_14, t0.bic AS bic_15, t0.bank_name AS bank_name_16, t0.website AS website_17, t0.invoice_prefix AS invoice_prefix_18, t0.quote_prefix AS quote_prefix_19, t0.quote_reference_template AS quote_reference_template_20, t0.invoice_reference_template AS invoice_reference_template_21, t0.credit_note_reference_template AS credit_note_reference_template_22, t0.order_reference_template AS order_reference_template_23, t0.pdf_template AS pdf_template_24, t0.show_signature AS show_signature_25, t0.show_iban AS show_iban_26, t0.payment_delay AS payment_delay_27, t0.payment_methods AS payment_methods_28, t0.default_tva_rate AS default_tva_rate_29, t0.smtp_enabled AS smtp_enabled_30, t0.smtp_host AS smtp_host_31, t0.smtp_port AS smtp_port_32, t0.smtp_user AS smtp_user_33, t0.smtp_password_encrypted AS smtp_password_encrypted_34, t0.smtp_encryption AS smtp_encryption_35, t0.smtp_from_email AS smtp_from_email_36, t0.smtp_from_name AS smtp_from_name_37, t0.cgv_texte AS cgv_texte_38, t0.cgv_devis AS cgv_devis_39, t0.cgv_commande AS cgv_commande_40, t0.cgv_facture AS cgv_facture_41, t0.cgv_avoir AS cgv_avoir_42, t0.company_id AS company_id_43 FROM company_configs t0 WHERE t0.company_id = ? LIMIT 1 Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.logo AS logo_2, t0.primary_color AS primary_color_3, t0.secondary_color AS secondary_color_4, t0.address AS address_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.footer_text AS footer_text_10, t0.legal_form AS legal_form_11, t0.capital AS capital_12, t0.rcs AS rcs_13, t0.iban AS iban_14, t0.bic AS bic_15, t0.bank_name AS bank_name_16, t0.website AS website_17, t0.invoice_prefix AS invoice_prefix_18, t0.quote_prefix AS quote_prefix_19, t0.quote_reference_template AS quote_reference_template_20, t0.invoice_reference_template AS invoice_reference_template_21, t0.credit_note_reference_template AS credit_note_reference_template_22, t0.order_reference_template AS order_reference_template_23, t0.pdf_template AS pdf_template_24, t0.show_signature AS show_signature_25, t0.show_iban AS show_iban_26, t0.payment_delay AS payment_delay_27, t0.payment_methods AS payment_methods_28, t0.default_tva_rate AS default_tva_rate_29, t0.smtp_enabled AS smtp_enabled_30, t0.smtp_host AS smtp_host_31, t0.smtp_port AS smtp_port_32, t0.smtp_user AS smtp_user_33, t0.smtp_password_encrypted AS smtp_password_encrypted_34, t0.smtp_encryption AS smtp_encryption_35, t0.smtp_from_email AS smtp_from_email_36, t0.smtp_from_name AS smtp_from_name_37, t0.cgv_texte AS cgv_texte_38, t0.cgv_devis AS cgv_devis_39, t0.cgv_commande AS cgv_commande_40, t0.cgv_facture AS cgv_facture_41, t0.cgv_avoir AS cgv_avoir_42, t0.company_id AS company_id_43 FROM company_configs t0 WHERE t0.company_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.logo AS logo_2, t0.primary_color AS primary_color_3, t0.secondary_color AS secondary_color_4, t0.address AS address_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.footer_text AS footer_text_10, t0.legal_form AS legal_form_11, t0.capital AS capital_12, t0.rcs AS rcs_13, t0.iban AS iban_14, t0.bic AS bic_15, t0.bank_name AS bank_name_16, t0.website AS website_17, t0.invoice_prefix AS invoice_prefix_18, t0.quote_prefix AS quote_prefix_19, t0.quote_reference_template AS quote_reference_template_20, t0.invoice_reference_template AS invoice_reference_template_21, t0.credit_note_reference_template AS credit_note_reference_template_22, t0.order_reference_template AS order_reference_template_23, t0.pdf_template AS pdf_template_24, t0.show_signature AS show_signature_25, t0.show_iban AS show_iban_26, t0.payment_delay AS payment_delay_27, t0.payment_methods AS payment_methods_28, t0.default_tva_rate AS default_tva_rate_29, t0.smtp_enabled AS smtp_enabled_30, t0.smtp_host AS smtp_host_31, t0.smtp_port AS smtp_port_32, t0.smtp_user AS smtp_user_33, t0.smtp_password_encrypted AS smtp_password_encrypted_34, t0.smtp_encryption AS smtp_encryption_35, t0.smtp_from_email AS smtp_from_email_36, t0.smtp_from_name AS smtp_from_name_37, t0.cgv_texte AS cgv_texte_38, t0.cgv_devis AS cgv_devis_39, t0.cgv_commande AS cgv_commande_40, t0.cgv_facture AS cgv_facture_41, t0.cgv_avoir AS cgv_avoir_42, t0.company_id AS company_id_43 FROM company_configs t0 WHERE t0.company_id = 7 LIMIT 1;

#▲

Time

Info

0.19 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.google_auth_enabled AS google_auth_enabled_10, t0.email_auth_code AS email_auth_code_11, t0.email_auth_enabled AS email_auth_enabled_12, t0.company_id AS company_id_13 FROM users t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "contact@carteblanche67.fr"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.is_active AS is_active_7,
  t0.created_at AS created_at_8,
  t0.google_authenticator_secret AS google_authenticator_secret_9,
  t0.google_auth_enabled AS google_auth_enabled_10,
  t0.email_auth_code AS email_auth_code_11,
  t0.email_auth_enabled AS email_auth_enabled_12,
  t0.company_id AS company_id_13
FROM
  users 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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.google_auth_enabled AS google_auth_enabled_10, t0.email_auth_code AS email_auth_code_11, t0.email_auth_enabled AS email_auth_enabled_12, t0.company_id AS company_id_13 FROM users t0 WHERE t0.email = 'contact@carteblanche67.fr' LIMIT 1;

0.39 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t6.id AS id_7, t6.logo AS logo_8, t6.primary_color AS primary_color_9, t6.secondary_color AS secondary_color_10, t6.address AS address_11, t6.phone AS phone_12, t6.email AS email_13, t6.siret AS siret_14, t6.tva_number AS tva_number_15, t6.footer_text AS footer_text_16, t6.legal_form AS legal_form_17, t6.capital AS capital_18, t6.rcs AS rcs_19, t6.iban AS iban_20, t6.bic AS bic_21, t6.bank_name AS bank_name_22, t6.website AS website_23, t6.invoice_prefix AS invoice_prefix_24, t6.quote_prefix AS quote_prefix_25, t6.quote_reference_template AS quote_reference_template_26, t6.invoice_reference_template AS invoice_reference_template_27, t6.credit_note_reference_template AS credit_note_reference_template_28, t6.order_reference_template AS order_reference_template_29, t6.pdf_template AS pdf_template_30, t6.show_signature AS show_signature_31, t6.show_iban AS show_iban_32, t6.payment_delay AS payment_delay_33, t6.payment_methods AS payment_methods_34, t6.default_tva_rate AS default_tva_rate_35, t6.smtp_enabled AS smtp_enabled_36, t6.smtp_host AS smtp_host_37, t6.smtp_port AS smtp_port_38, t6.smtp_user AS smtp_user_39, t6.smtp_password_encrypted AS smtp_password_encrypted_40, t6.smtp_encryption AS smtp_encryption_41, t6.smtp_from_email AS smtp_from_email_42, t6.smtp_from_name AS smtp_from_name_43, t6.cgv_texte AS cgv_texte_44, t6.cgv_devis AS cgv_devis_45, t6.cgv_commande AS cgv_commande_46, t6.cgv_facture AS cgv_facture_47, t6.cgv_avoir AS cgv_avoir_48, t6.company_id AS company_id_49 FROM companies t0 LEFT JOIN company_configs t6 ON t6.company_id = t0.id WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t6.id AS id_7,
  t6.logo AS logo_8,
  t6.primary_color AS primary_color_9,
  t6.secondary_color AS secondary_color_10,
  t6.address AS address_11,
  t6.phone AS phone_12,
  t6.email AS email_13,
  t6.siret AS siret_14,
  t6.tva_number AS tva_number_15,
  t6.footer_text AS footer_text_16,
  t6.legal_form AS legal_form_17,
  t6.capital AS capital_18,
  t6.rcs AS rcs_19,
  t6.iban AS iban_20,
  t6.bic AS bic_21,
  t6.bank_name AS bank_name_22,
  t6.website AS website_23,
  t6.invoice_prefix AS invoice_prefix_24,
  t6.quote_prefix AS quote_prefix_25,
  t6.quote_reference_template AS quote_reference_template_26,
  t6.invoice_reference_template AS invoice_reference_template_27,
  t6.credit_note_reference_template AS credit_note_reference_template_28,
  t6.order_reference_template AS order_reference_template_29,
  t6.pdf_template AS pdf_template_30,
  t6.show_signature AS show_signature_31,
  t6.show_iban AS show_iban_32,
  t6.payment_delay AS payment_delay_33,
  t6.payment_methods AS payment_methods_34,
  t6.default_tva_rate AS default_tva_rate_35,
  t6.smtp_enabled AS smtp_enabled_36,
  t6.smtp_host AS smtp_host_37,
  t6.smtp_port AS smtp_port_38,
  t6.smtp_user AS smtp_user_39,
  t6.smtp_password_encrypted AS smtp_password_encrypted_40,
  t6.smtp_encryption AS smtp_encryption_41,
  t6.smtp_from_email AS smtp_from_email_42,
  t6.smtp_from_name AS smtp_from_name_43,
  t6.cgv_texte AS cgv_texte_44,
  t6.cgv_devis AS cgv_devis_45,
  t6.cgv_commande AS cgv_commande_46,
  t6.cgv_facture AS cgv_facture_47,
  t6.cgv_avoir AS cgv_avoir_48,
  t6.company_id AS company_id_49
FROM
  companies t0
  LEFT JOIN company_configs t6 ON t6.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t6.id AS id_7, t6.logo AS logo_8, t6.primary_color AS primary_color_9, t6.secondary_color AS secondary_color_10, t6.address AS address_11, t6.phone AS phone_12, t6.email AS email_13, t6.siret AS siret_14, t6.tva_number AS tva_number_15, t6.footer_text AS footer_text_16, t6.legal_form AS legal_form_17, t6.capital AS capital_18, t6.rcs AS rcs_19, t6.iban AS iban_20, t6.bic AS bic_21, t6.bank_name AS bank_name_22, t6.website AS website_23, t6.invoice_prefix AS invoice_prefix_24, t6.quote_prefix AS quote_prefix_25, t6.quote_reference_template AS quote_reference_template_26, t6.invoice_reference_template AS invoice_reference_template_27, t6.credit_note_reference_template AS credit_note_reference_template_28, t6.order_reference_template AS order_reference_template_29, t6.pdf_template AS pdf_template_30, t6.show_signature AS show_signature_31, t6.show_iban AS show_iban_32, t6.payment_delay AS payment_delay_33, t6.payment_methods AS payment_methods_34, t6.default_tva_rate AS default_tva_rate_35, t6.smtp_enabled AS smtp_enabled_36, t6.smtp_host AS smtp_host_37, t6.smtp_port AS smtp_port_38, t6.smtp_user AS smtp_user_39, t6.smtp_password_encrypted AS smtp_password_encrypted_40, t6.smtp_encryption AS smtp_encryption_41, t6.smtp_from_email AS smtp_from_email_42, t6.smtp_from_name AS smtp_from_name_43, t6.cgv_texte AS cgv_texte_44, t6.cgv_devis AS cgv_devis_45, t6.cgv_commande AS cgv_commande_46, t6.cgv_facture AS cgv_facture_47, t6.cgv_avoir AS cgv_avoir_48, t6.company_id AS company_id_49 FROM companies t0 LEFT JOIN company_configs t6 ON t6.company_id = t0.id WHERE t0.id = 7;

0.27 ms

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.primary_color AS primary_color_3, t0.secondary_color AS secondary_color_4, t0.address AS address_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.footer_text AS footer_text_10, t0.legal_form AS legal_form_11, t0.capital AS capital_12, t0.rcs AS rcs_13, t0.iban AS iban_14, t0.bic AS bic_15, t0.bank_name AS bank_name_16, t0.website AS website_17, t0.invoice_prefix AS invoice_prefix_18, t0.quote_prefix AS quote_prefix_19, t0.quote_reference_template AS quote_reference_template_20, t0.invoice_reference_template AS invoice_reference_template_21, t0.credit_note_reference_template AS credit_note_reference_template_22, t0.order_reference_template AS order_reference_template_23, t0.pdf_template AS pdf_template_24, t0.show_signature AS show_signature_25, t0.show_iban AS show_iban_26, t0.payment_delay AS payment_delay_27, t0.payment_methods AS payment_methods_28, t0.default_tva_rate AS default_tva_rate_29, t0.smtp_enabled AS smtp_enabled_30, t0.smtp_host AS smtp_host_31, t0.smtp_port AS smtp_port_32, t0.smtp_user AS smtp_user_33, t0.smtp_password_encrypted AS smtp_password_encrypted_34, t0.smtp_encryption AS smtp_encryption_35, t0.smtp_from_email AS smtp_from_email_36, t0.smtp_from_name AS smtp_from_name_37, t0.cgv_texte AS cgv_texte_38, t0.cgv_devis AS cgv_devis_39, t0.cgv_commande AS cgv_commande_40, t0.cgv_facture AS cgv_facture_41, t0.cgv_avoir AS cgv_avoir_42, t0.company_id AS company_id_43 FROM company_configs t0 WHERE t0.company_id = ? LIMIT 1

Parameters:

[
  7
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.primary_color AS primary_color_3,
  t0.secondary_color AS secondary_color_4,
  t0.address AS address_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.siret AS siret_8,
  t0.tva_number AS tva_number_9,
  t0.footer_text AS footer_text_10,
  t0.legal_form AS legal_form_11,
  t0.capital AS capital_12,
  t0.rcs AS rcs_13,
  t0.iban AS iban_14,
  t0.bic AS bic_15,
  t0.bank_name AS bank_name_16,
  t0.website AS website_17,
  t0.invoice_prefix AS invoice_prefix_18,
  t0.quote_prefix AS quote_prefix_19,
  t0.quote_reference_template AS quote_reference_template_20,
  t0.invoice_reference_template AS invoice_reference_template_21,
  t0.credit_note_reference_template AS credit_note_reference_template_22,
  t0.order_reference_template AS order_reference_template_23,
  t0.pdf_template AS pdf_template_24,
  t0.show_signature AS show_signature_25,
  t0.show_iban AS show_iban_26,
  t0.payment_delay AS payment_delay_27,
  t0.payment_methods AS payment_methods_28,
  t0.default_tva_rate AS default_tva_rate_29,
  t0.smtp_enabled AS smtp_enabled_30,
  t0.smtp_host AS smtp_host_31,
  t0.smtp_port AS smtp_port_32,
  t0.smtp_user AS smtp_user_33,
  t0.smtp_password_encrypted AS smtp_password_encrypted_34,
  t0.smtp_encryption AS smtp_encryption_35,
  t0.smtp_from_email AS smtp_from_email_36,
  t0.smtp_from_name AS smtp_from_name_37,
  t0.cgv_texte AS cgv_texte_38,
  t0.cgv_devis AS cgv_devis_39,
  t0.cgv_commande AS cgv_commande_40,
  t0.cgv_facture AS cgv_facture_41,
  t0.cgv_avoir AS cgv_avoir_42,
  t0.company_id AS company_id_43
FROM
  company_configs t0
WHERE
  t0.company_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.primary_color AS primary_color_3, t0.secondary_color AS secondary_color_4, t0.address AS address_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.footer_text AS footer_text_10, t0.legal_form AS legal_form_11, t0.capital AS capital_12, t0.rcs AS rcs_13, t0.iban AS iban_14, t0.bic AS bic_15, t0.bank_name AS bank_name_16, t0.website AS website_17, t0.invoice_prefix AS invoice_prefix_18, t0.quote_prefix AS quote_prefix_19, t0.quote_reference_template AS quote_reference_template_20, t0.invoice_reference_template AS invoice_reference_template_21, t0.credit_note_reference_template AS credit_note_reference_template_22, t0.order_reference_template AS order_reference_template_23, t0.pdf_template AS pdf_template_24, t0.show_signature AS show_signature_25, t0.show_iban AS show_iban_26, t0.payment_delay AS payment_delay_27, t0.payment_methods AS payment_methods_28, t0.default_tva_rate AS default_tva_rate_29, t0.smtp_enabled AS smtp_enabled_30, t0.smtp_host AS smtp_host_31, t0.smtp_port AS smtp_port_32, t0.smtp_user AS smtp_user_33, t0.smtp_password_encrypted AS smtp_password_encrypted_34, t0.smtp_encryption AS smtp_encryption_35, t0.smtp_from_email AS smtp_from_email_36, t0.smtp_from_name AS smtp_from_name_37, t0.cgv_texte AS cgv_texte_38, t0.cgv_devis AS cgv_devis_39, t0.cgv_commande AS cgv_commande_40, t0.cgv_facture AS cgv_facture_41, t0.cgv_avoir AS cgv_avoir_42, t0.company_id AS company_id_43 FROM company_configs t0 WHERE t0.company_id = 7 LIMIT 1;

tenant connection

#▲	Time	Info
1	0.17 ms	SELECT t0.id AS id_1, t0.reference AS reference_2, t0.objet AS objet_3, t0.societe AS societe_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.adresse AS adresse_7, t0.code_postal AS code_postal_8, t0.ville AS ville_9, t0.date_facture AS date_facture_10, t0.date_paiement AS date_paiement_11, t0.date_echeance AS date_echeance_12, t0.statut AS statut_13, t0.remise AS remise_14, t0.mode_paiement AS mode_paiement_15, t0.observations_internes AS observations_internes_16, t0.conditions_paiement AS conditions_paiement_17, t0.mentions_legales AS mentions_legales_18, t0.notes_publiques AS notes_publiques_19, t0.siret_client AS siret_client_20, t0.tva_intracom AS tva_intracom_21, t0.est_avoir AS est_avoir_22, t0.infos_client AS infos_client_23, t0.created_at AS created_at_24, t0.client_id AS client_id_25, t0.devis_origine_id AS devis_origine_id_26, t0.commande_origine_id AS commande_origine_id_27, t0.facture_avoir_de_id AS facture_avoir_de_id_28 FROM factures t0 WHERE t0.id = ? Parameters: [`486`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reference AS reference_2, t0.objet AS objet_3, t0.societe AS societe_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.adresse AS adresse_7, t0.code_postal AS code_postal_8, t0.ville AS ville_9, t0.date_facture AS date_facture_10, t0.date_paiement AS date_paiement_11, t0.date_echeance AS date_echeance_12, t0.statut AS statut_13, t0.remise AS remise_14, t0.mode_paiement AS mode_paiement_15, t0.observations_internes AS observations_internes_16, t0.conditions_paiement AS conditions_paiement_17, t0.mentions_legales AS mentions_legales_18, t0.notes_publiques AS notes_publiques_19, t0.siret_client AS siret_client_20, t0.tva_intracom AS tva_intracom_21, t0.est_avoir AS est_avoir_22, t0.infos_client AS infos_client_23, t0.created_at AS created_at_24, t0.client_id AS client_id_25, t0.devis_origine_id AS devis_origine_id_26, t0.commande_origine_id AS commande_origine_id_27, t0.facture_avoir_de_id AS facture_avoir_de_id_28 FROM factures t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.reference AS reference_2, t0.objet AS objet_3, t0.societe AS societe_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.adresse AS adresse_7, t0.code_postal AS code_postal_8, t0.ville AS ville_9, t0.date_facture AS date_facture_10, t0.date_paiement AS date_paiement_11, t0.date_echeance AS date_echeance_12, t0.statut AS statut_13, t0.remise AS remise_14, t0.mode_paiement AS mode_paiement_15, t0.observations_internes AS observations_internes_16, t0.conditions_paiement AS conditions_paiement_17, t0.mentions_legales AS mentions_legales_18, t0.notes_publiques AS notes_publiques_19, t0.siret_client AS siret_client_20, t0.tva_intracom AS tva_intracom_21, t0.est_avoir AS est_avoir_22, t0.infos_client AS infos_client_23, t0.created_at AS created_at_24, t0.client_id AS client_id_25, t0.devis_origine_id AS devis_origine_id_26, t0.commande_origine_id AS commande_origine_id_27, t0.facture_avoir_de_id AS facture_avoir_de_id_28 FROM factures t0 WHERE t0.id = 486;
2	0.18 ms	SELECT t0.id AS id_1, t0.regroupement AS regroupement_2, t0.description AS description_3, t0.designation AS designation_4, t0.quantite AS quantite_5, t0.unite AS unite_6, t0.prix_unitaire_ht AS prix_unitaire_ht_7, t0.prix_achat AS prix_achat_8, t0.taux_tva AS taux_tva_9, t0.remise_article AS remise_article_10, t0.position AS position_11, t0.facture_id AS facture_id_12, t0.produit_id AS produit_id_13, t0.taux_tva_entity_id AS taux_tva_entity_id_14 FROM facture_lignes t0 WHERE t0.facture_id = ? ORDER BY t0.position ASC Parameters: [`486`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.regroupement AS regroupement_2, t0.description AS description_3, t0.designation AS designation_4, t0.quantite AS quantite_5, t0.unite AS unite_6, t0.prix_unitaire_ht AS prix_unitaire_ht_7, t0.prix_achat AS prix_achat_8, t0.taux_tva AS taux_tva_9, t0.remise_article AS remise_article_10, t0.position AS position_11, t0.facture_id AS facture_id_12, t0.produit_id AS produit_id_13, t0.taux_tva_entity_id AS taux_tva_entity_id_14 FROM facture_lignes t0 WHERE t0.facture_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.regroupement AS regroupement_2, t0.description AS description_3, t0.designation AS designation_4, t0.quantite AS quantite_5, t0.unite AS unite_6, t0.prix_unitaire_ht AS prix_unitaire_ht_7, t0.prix_achat AS prix_achat_8, t0.taux_tva AS taux_tva_9, t0.remise_article AS remise_article_10, t0.position AS position_11, t0.facture_id AS facture_id_12, t0.produit_id AS produit_id_13, t0.taux_tva_entity_id AS taux_tva_entity_id_14 FROM facture_lignes t0 WHERE t0.facture_id = 486 ORDER BY t0.position ASC;
3	0.18 ms	SELECT t0.id AS id_1, t0.montant AS montant_2, t0.date_paiement AS date_paiement_3, t0.reference AS reference_4, t0.notes AS notes_5, t0.created_at AS created_at_6, t0.facture_id AS facture_id_7, t0.mode_reglement_id AS mode_reglement_id_8 FROM paiements t0 WHERE t0.facture_id = ? Parameters: [`486`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.montant AS montant_2, t0.date_paiement AS date_paiement_3, t0.reference AS reference_4, t0.notes AS notes_5, t0.created_at AS created_at_6, t0.facture_id AS facture_id_7, t0.mode_reglement_id AS mode_reglement_id_8 FROM paiements t0 WHERE t0.facture_id = ? SELECT t0.id AS id_1, t0.montant AS montant_2, t0.date_paiement AS date_paiement_3, t0.reference AS reference_4, t0.notes AS notes_5, t0.created_at AS created_at_6, t0.facture_id AS facture_id_7, t0.mode_reglement_id AS mode_reglement_id_8 FROM paiements t0 WHERE t0.facture_id = 486;
4	0.17 ms	SELECT t0.id AS id_1, t0.societe AS societe_2, t0.civilite AS civilite_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.adresse AS adresse_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.pays AS pays_9, t0.compte_comptable AS compte_comptable_10, t0.telephone AS telephone_11, t0.portable AS portable_12, t0.email AS email_13, t0.infos_suppl AS infos_suppl_14, t0.siret AS siret_15, t0.tva_intracom AS tva_intracom_16, t0.categorie AS categorie_17, t0.actif AS actif_18, t0.created_at AS created_at_19 FROM clients t0 WHERE t0.id = ? Parameters: [`146`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.societe AS societe_2, t0.civilite AS civilite_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.adresse AS adresse_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.pays AS pays_9, t0.compte_comptable AS compte_comptable_10, t0.telephone AS telephone_11, t0.portable AS portable_12, t0.email AS email_13, t0.infos_suppl AS infos_suppl_14, t0.siret AS siret_15, t0.tva_intracom AS tva_intracom_16, t0.categorie AS categorie_17, t0.actif AS actif_18, t0.created_at AS created_at_19 FROM clients t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.societe AS societe_2, t0.civilite AS civilite_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.adresse AS adresse_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.pays AS pays_9, t0.compte_comptable AS compte_comptable_10, t0.telephone AS telephone_11, t0.portable AS portable_12, t0.email AS email_13, t0.infos_suppl AS infos_suppl_14, t0.siret AS siret_15, t0.tva_intracom AS tva_intracom_16, t0.categorie AS categorie_17, t0.actif AS actif_18, t0.created_at AS created_at_19 FROM clients t0 WHERE t0.id = 146;

Database Connections

Name	Service
master	doctrine.dbal.master_connection
tenant	doctrine.dbal.tenant_connection

Entity Managers

Name	Service
master	doctrine.orm.master_entity_manager
tenant	doctrine.orm.tenant_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

master entity manager

Class	Amount of managed objects
App\Entity\Master\User	1
App\Entity\Master\Company	1
App\Entity\Master\CompanyConfig	1

tenant entity manager

Class	Amount of managed objects
App\Entity\Tenant\FactureLigne	3
App\Entity\Tenant\Facture	1
App\Entity\Tenant\Client	1
App\Entity\Tenant\Devis	1
App\Entity\Tenant\Paiement	1
App\Entity\Tenant\ModeReglement	1

Entities Mapping

master entity manager

Class	Mapping errors
App\Entity\Master\User	No errors.
App\Entity\Master\Company	No errors.
App\Entity\Master\CompanyConfig	The field 'App\Entity\Master\CompanyConfig#defaultTvaRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Master\CompanyDomain	No errors.
App\Entity\Master\CompanyModule	No errors.

tenant entity manager

Class	Mapping errors
App\Entity\Tenant\Facture	No errors.
App\Entity\Tenant\Client	No errors.
App\Entity\Tenant\Devis	No errors.
App\Entity\Tenant\Commande	No errors.
App\Entity\Tenant\FactureLigne	No errors.
App\Entity\Tenant\ModeReglement	No errors.
App\Entity\Tenant\Paiement	The field 'App\Entity\Tenant\Paiement#montant' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Tenant\Produit	No errors.
App\Entity\Tenant\TauxTva	No errors.

Symfony Profiler

GET https://gestion.carteblanche67.fr/api/factures/486/pdf

Configuration Settings

Theme

Page Width

Query Metrics

Queries

master connection

tenant connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

master entity manager

tenant entity manager

Entities Mapping

master entity manager

tenant entity manager