Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT c0_.id AS id_0, c0_.firstname AS firstname_1, c0_.lastname AS lastname_2, c0_.email AS email_3, c0_.phone AS phone_4, c0_.rdv1 AS rdv1_5, c0_.rdv2 AS rdv2_6, c0_.address AS address_7, c0_.city AS city_8, c0_.zipcode AS zipcode_9, c0_.mprcategory AS mprcategory_10, c0_.property_type AS property_type_11, c0_.isolation AS isolation_12, c0_.heating AS heating_13, c0_.pv AS pv_14, c0_.vmc AS vmc_15, c0_.address_lat AS address_lat_16, c0_.address_lng AS address_lng_17, c0_.audit_invoice_sent AS audit_invoice_sent_18, c0_.audit_paid AS audit_paid_19, c0_.granting_invoice_sent AS granting_invoice_sent_20, c0_.granting_invoice_paid AS granting_invoice_paid_21, c0_.has_account_anah AS has_account_anah_22, c0_.has_signed_contract_mar AS has_signed_contract_mar_23, c0_.has_signed_contract_cq AS has_signed_contract_cq_24, c0_.file_number AS file_number_25, c0_.mprpassword AS mprpassword_26, c0_.vt_done AS vt_done_27, c0_.status_rank AS status_rank_28, c0_.created_at AS created_at_29, c0_.updated_at AS updated_at_30, c0_.deleted_at AS deleted_at_31, c0_.status_id AS status_id_32, c0_.company_auditor_extern_id AS company_auditor_extern_id_33, c0_.company_auditor_intern_id AS company_auditor_intern_id_34, c0_.company_installer_admin_id AS company_installer_admin_id_35, c0_.company_installer_collab_id AS company_installer_collab_id_36, c0_.company_mar_id AS company_mar_id_37, c0_.created_by_id AS created_by_id_38, c0_.updated_by_id AS updated_by_id_39 FROM `customer` c0_ WHERE LOWER(c0_.firstname) LIKE ? OR LOWER(c0_.lastname) LIKE ?

[
  "%benchikh%"
  "%benchikh%"
]

SELECT
  c0_.id AS id_0,
  c0_.firstname AS firstname_1,
  c0_.lastname AS lastname_2,
  c0_.email AS email_3,
  c0_.phone AS phone_4,
  c0_.rdv1 AS rdv1_5,
  c0_.rdv2 AS rdv2_6,
  c0_.address AS address_7,
  c0_.city AS city_8,
  c0_.zipcode AS zipcode_9,
  c0_.mprcategory AS mprcategory_10,
  c0_.property_type AS property_type_11,
  c0_.isolation AS isolation_12,
  c0_.heating AS heating_13,
  c0_.pv AS pv_14,
  c0_.vmc AS vmc_15,
  c0_.address_lat AS address_lat_16,
  c0_.address_lng AS address_lng_17,
  c0_.audit_invoice_sent AS audit_invoice_sent_18,
  c0_.audit_paid AS audit_paid_19,
  c0_.granting_invoice_sent AS granting_invoice_sent_20,
  c0_.granting_invoice_paid AS granting_invoice_paid_21,
  c0_.has_account_anah AS has_account_anah_22,
  c0_.has_signed_contract_mar AS has_signed_contract_mar_23,
  c0_.has_signed_contract_cq AS has_signed_contract_cq_24,
  c0_.file_number AS file_number_25,
  c0_.mprpassword AS mprpassword_26,
  c0_.vt_done AS vt_done_27,
  c0_.status_rank AS status_rank_28,
  c0_.created_at AS created_at_29,
  c0_.updated_at AS updated_at_30,
  c0_.deleted_at AS deleted_at_31,
  c0_.status_id AS status_id_32,
  c0_.company_auditor_extern_id AS company_auditor_extern_id_33,
  c0_.company_auditor_intern_id AS company_auditor_intern_id_34,
  c0_.company_installer_admin_id AS company_installer_admin_id_35,
  c0_.company_installer_collab_id AS company_installer_collab_id_36,
  c0_.company_mar_id AS company_mar_id_37,
  c0_.created_by_id AS created_by_id_38,
  c0_.updated_by_id AS updated_by_id_39
FROM
  `customer` c0_
WHERE
  LOWER(c0_.firstname) LIKE ?
  OR LOWER(c0_.lastname) LIKE ?

SELECT c0_.id AS id_0, c0_.firstname AS firstname_1, c0_.lastname AS lastname_2, c0_.email AS email_3, c0_.phone AS phone_4, c0_.rdv1 AS rdv1_5, c0_.rdv2 AS rdv2_6, c0_.address AS address_7, c0_.city AS city_8, c0_.zipcode AS zipcode_9, c0_.mprcategory AS mprcategory_10, c0_.property_type AS property_type_11, c0_.isolation AS isolation_12, c0_.heating AS heating_13, c0_.pv AS pv_14, c0_.vmc AS vmc_15, c0_.address_lat AS address_lat_16, c0_.address_lng AS address_lng_17, c0_.audit_invoice_sent AS audit_invoice_sent_18, c0_.audit_paid AS audit_paid_19, c0_.granting_invoice_sent AS granting_invoice_sent_20, c0_.granting_invoice_paid AS granting_invoice_paid_21, c0_.has_account_anah AS has_account_anah_22, c0_.has_signed_contract_mar AS has_signed_contract_mar_23, c0_.has_signed_contract_cq AS has_signed_contract_cq_24, c0_.file_number AS file_number_25, c0_.mprpassword AS mprpassword_26, c0_.vt_done AS vt_done_27, c0_.status_rank AS status_rank_28, c0_.created_at AS created_at_29, c0_.updated_at AS updated_at_30, c0_.deleted_at AS deleted_at_31, c0_.status_id AS status_id_32, c0_.company_auditor_extern_id AS company_auditor_extern_id_33, c0_.company_auditor_intern_id AS company_auditor_intern_id_34, c0_.company_installer_admin_id AS company_installer_admin_id_35, c0_.company_installer_collab_id AS company_installer_collab_id_36, c0_.company_mar_id AS company_mar_id_37, c0_.created_by_id AS created_by_id_38, c0_.updated_by_id AS updated_by_id_39 FROM `customer` c0_ WHERE LOWER(c0_.firstname) LIKE '%benchikh%' OR LOWER(c0_.lastname) LIKE '%benchikh%';

SELECT t0.id AS id_7, t0.email AS email_8, t0.roles AS roles_9, t0.password AS password_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.dtype FROM `user` t0 LEFT JOIN `user_admin` t1 ON t0.id = t1.id LEFT JOIN `user_installer_admin` t2 ON t0.id = t2.id LEFT JOIN `user_mar` t3 ON t0.id = t3.id LEFT JOIN `user_auditor_extern` t4 ON t0.id = t4.id LEFT JOIN `user_auditor_intern` t5 ON t0.id = t5.id LEFT JOIN `user_installer_collab` t6 ON t0.id = t6.id WHERE t0.email = ? LIMIT 1

[
  "qualifrancerenov@gmail.com"
]

SELECT
  t0.id AS id_7,
  t0.email AS email_8,
  t0.roles AS roles_9,
  t0.password AS password_10,
  t0.firstname AS firstname_11,
  t0.lastname AS lastname_12,
  t0.is_active AS is_active_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.created_by_id AS created_by_id_17,
  t0.updated_by_id AS updated_by_id_18,
  t0.dtype
FROM
  `user` t0
  LEFT JOIN `user_admin` t1 ON t0.id = t1.id
  LEFT JOIN `user_installer_admin` t2 ON t0.id = t2.id
  LEFT JOIN `user_mar` t3 ON t0.id = t3.id
  LEFT JOIN `user_auditor_extern` t4 ON t0.id = t4.id
  LEFT JOIN `user_auditor_intern` t5 ON t0.id = t5.id
  LEFT JOIN `user_installer_collab` t6 ON t0.id = t6.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_7, t0.email AS email_8, t0.roles AS roles_9, t0.password AS password_10, t0.firstname AS firstname_11, t0.lastname AS lastname_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.dtype FROM `user` t0 LEFT JOIN `user_admin` t1 ON t0.id = t1.id LEFT JOIN `user_installer_admin` t2 ON t0.id = t2.id LEFT JOIN `user_mar` t3 ON t0.id = t3.id LEFT JOIN `user_auditor_extern` t4 ON t0.id = t4.id LEFT JOIN `user_auditor_intern` t5 ON t0.id = t5.id LEFT JOIN `user_installer_collab` t6 ON t0.id = t6.id WHERE t0.email = 'qualifrancerenov@gmail.com' LIMIT 1;