Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 151
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Workflow
• Redis
• Configuration

Query Metrics

SELECT p0_.created_at AS created_at_0, p0_.id AS id_1, p0_.ecoclient_id AS ecoclient_id_2, p0_.ecoclient_company AS ecoclient_company_3, p0_.ecoclient_backoffice AS ecoclient_backoffice_4, p0_.ecoclient_inspector AS ecoclient_inspector_5, p0_.ecoclient_sales AS ecoclient_sales_6, p0_.project_title AS project_title_7, p0_.project_text AS project_text_8, p0_.project_street AS project_street_9, p0_.project_streetnumber AS project_streetnumber_10, p0_.project_zip AS project_zip_11, p0_.project_city AS project_city_12, p0_.project_country AS project_country_13, st_astext(p0_.project_geocode) AS project_geocode_14, p0_.project_construction_costs AS project_construction_costs_15, p0_.project_note AS project_note_16, p0_.project_status AS project_status_17, p0_.is_deactivated AS is_deactivated_18, p0_.starts_at AS starts_at_19, p0_.ends_at AS ends_at_20, p0_.is_framework_contract AS is_framework_contract_21, p0_.updated_at AS updated_at_22, p0_.deleted_at AS deleted_at_23, u1_.id AS id_24, p0_.company_id AS company_id_25, p0_.user_id AS user_id_26 FROM project p0_ LEFT JOIN project_user p2_ ON p0_.id = p2_.project_id LEFT JOIN user u1_ ON u1_.id = p2_.user_id WHERE (p0_.id = ?) AND (p0_.deleted_at IS NULL)

[
  7194
]

SELECT
  p0_.created_at AS created_at_0,
  p0_.id AS id_1,
  p0_.ecoclient_id AS ecoclient_id_2,
  p0_.ecoclient_company AS ecoclient_company_3,
  p0_.ecoclient_backoffice AS ecoclient_backoffice_4,
  p0_.ecoclient_inspector AS ecoclient_inspector_5,
  p0_.ecoclient_sales AS ecoclient_sales_6,
  p0_.project_title AS project_title_7,
  p0_.project_text AS project_text_8,
  p0_.project_street AS project_street_9,
  p0_.project_streetnumber AS project_streetnumber_10,
  p0_.project_zip AS project_zip_11,
  p0_.project_city AS project_city_12,
  p0_.project_country AS project_country_13,
  st_astext(p0_.project_geocode) AS project_geocode_14,
  p0_.project_construction_costs AS project_construction_costs_15,
  p0_.project_note AS project_note_16,
  p0_.project_status AS project_status_17,
  p0_.is_deactivated AS is_deactivated_18,
  p0_.starts_at AS starts_at_19,
  p0_.ends_at AS ends_at_20,
  p0_.is_framework_contract AS is_framework_contract_21,
  p0_.updated_at AS updated_at_22,
  p0_.deleted_at AS deleted_at_23,
  u1_.id AS id_24,
  p0_.company_id AS company_id_25,
  p0_.user_id AS user_id_26
FROM
  project p0_
  LEFT JOIN project_user p2_ ON p0_.id = p2_.project_id
  LEFT JOIN user u1_ ON u1_.id = p2_.user_id
WHERE
  (p0_.id = ?)
  AND (p0_.deleted_at IS NULL)

SELECT p0_.created_at AS created_at_0, p0_.id AS id_1, p0_.ecoclient_id AS ecoclient_id_2, p0_.ecoclient_company AS ecoclient_company_3, p0_.ecoclient_backoffice AS ecoclient_backoffice_4, p0_.ecoclient_inspector AS ecoclient_inspector_5, p0_.ecoclient_sales AS ecoclient_sales_6, p0_.project_title AS project_title_7, p0_.project_text AS project_text_8, p0_.project_street AS project_street_9, p0_.project_streetnumber AS project_streetnumber_10, p0_.project_zip AS project_zip_11, p0_.project_city AS project_city_12, p0_.project_country AS project_country_13, st_astext(p0_.project_geocode) AS project_geocode_14, p0_.project_construction_costs AS project_construction_costs_15, p0_.project_note AS project_note_16, p0_.project_status AS project_status_17, p0_.is_deactivated AS is_deactivated_18, p0_.starts_at AS starts_at_19, p0_.ends_at AS ends_at_20, p0_.is_framework_contract AS is_framework_contract_21, p0_.updated_at AS updated_at_22, p0_.deleted_at AS deleted_at_23, u1_.id AS id_24, p0_.company_id AS company_id_25, p0_.user_id AS user_id_26 FROM project p0_ LEFT JOIN project_user p2_ ON p0_.id = p2_.project_id LEFT JOIN user u1_ ON u1_.id = p2_.user_id WHERE (p0_.id = 7194) AND (p0_.deleted_at IS NULL);

SELECT t0.id AS id_1, t0.ecoclient_user_id AS ecoclient_user_id_2, t0.username AS username_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.salutation AS salutation_6, t0.email AS email_7, t0.password AS password_8, t0.user_title AS user_title_9, t0.user_mobile AS user_mobile_10, t0.user_landline AS user_landline_11, t0.enable_ldap_authentication AS enable_ldap_authentication_12, t0.image AS image_13, t0.marker_image AS marker_image_14, t0.small_square_image AS small_square_image_15, t0.image_mime_type AS image_mime_type_16, t0.is_non_human AS is_non_human_17, t0.signature AS signature_18, t0.odoo_employee_id AS odoo_employee_id_19, t0.odoo_user_id AS odoo_user_id_20, t0.disabled_at AS disabled_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.deleted_at AS deleted_at_24 FROM user t0 WHERE t0.username = ? LIMIT 1

[
  "reuter"
]

SELECT
  t0.id AS id_1,
  t0.ecoclient_user_id AS ecoclient_user_id_2,
  t0.username AS username_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.salutation AS salutation_6,
  t0.email AS email_7,
  t0.password AS password_8,
  t0.user_title AS user_title_9,
  t0.user_mobile AS user_mobile_10,
  t0.user_landline AS user_landline_11,
  t0.enable_ldap_authentication AS enable_ldap_authentication_12,
  t0.image AS image_13,
  t0.marker_image AS marker_image_14,
  t0.small_square_image AS small_square_image_15,
  t0.image_mime_type AS image_mime_type_16,
  t0.is_non_human AS is_non_human_17,
  t0.signature AS signature_18,
  t0.odoo_employee_id AS odoo_employee_id_19,
  t0.odoo_user_id AS odoo_user_id_20,
  t0.disabled_at AS disabled_at_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.deleted_at AS deleted_at_24
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ecoclient_user_id AS ecoclient_user_id_2, t0.username AS username_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.salutation AS salutation_6, t0.email AS email_7, t0.password AS password_8, t0.user_title AS user_title_9, t0.user_mobile AS user_mobile_10, t0.user_landline AS user_landline_11, t0.enable_ldap_authentication AS enable_ldap_authentication_12, t0.image AS image_13, t0.marker_image AS marker_image_14, t0.small_square_image AS small_square_image_15, t0.image_mime_type AS image_mime_type_16, t0.is_non_human AS is_non_human_17, t0.signature AS signature_18, t0.odoo_employee_id AS odoo_employee_id_19, t0.odoo_user_id AS odoo_user_id_20, t0.disabled_at AS disabled_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.deleted_at AS deleted_at_24 FROM user t0 WHERE t0.username = 'reuter' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?

[
  7
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 7;