Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.mobile_phone AS mobile_phone_9, t0.updated_at AS updated_at_10, t0.color AS color_11, t0.website_language_id AS website_language_id_12 FROM user t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.phone AS phone_8,
  t0.mobile_phone AS mobile_phone_9,
  t0.updated_at AS updated_at_10,
  t0.color AS color_11,
  t0.website_language_id AS website_language_id_12
FROM
  user 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.username AS username_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.mobile_phone AS mobile_phone_9, t0.updated_at AS updated_at_10, t0.color AS color_11, t0.website_language_id AS website_language_id_12 FROM user t0 WHERE t0.id = 1;

SELECT COUNT(p0_.id) AS sclr_0 FROM pratica p0_

[]

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  pratica p0_

SELECT COUNT(p0_.id) AS sclr_0 FROM pratica p0_;

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, status_1 FROM (SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.name AS name_2, p0_.description AS description_3, p0_.start_date AS start_date_4, p0_.end_date AS end_date_5, p0_.estimated_hours AS estimated_hours_6, p0_.created_at AS created_at_7, p0_.last_modified_at AS last_modified_at_8, p0_.trashed_at AS trashed_at_9, c1_.id AS id_10, c1_.name AS name_11, c1_.email AS email_12, c1_.website AS website_13, c1_.phone AS phone_14, c1_.fax AS fax_15, c1_.fiscal_code AS fiscal_code_16, c1_.vat_number AS vat_number_17, c1_.sdi AS sdi_18, c1_.iban AS iban_19, c1_.bic_swift AS bic_swift_20, c1_.pec AS pec_21, c1_.type AS type_22, c1_.ads_adv AS ads_adv_23, c1_.fb_adv AS fb_adv_24, c1_.external_id AS external_id_25, c1_.created_at AS created_at_26, c1_.last_modified_at AS last_modified_at_27, c1_.trashed_at AS trashed_at_28, u2_.id AS id_29, u2_.email AS email_30, u2_.roles AS roles_31, u2_.password AS password_32, u2_.username AS username_33, u2_.first_name AS first_name_34, u2_.last_name AS last_name_35, u2_.phone AS phone_36, u2_.mobile_phone AS mobile_phone_37, u2_.updated_at AS updated_at_38, u2_.color AS color_39, a3_.id AS id_40, a3_.name AS name_41, a3_.description AS description_42, a3_.start_date AS start_date_43, a3_.end_date AS end_date_44, a3_.estimated_hours AS estimated_hours_45, a3_.priorita AS priorita_46, a3_.status AS status_47, a3_.created_at AS created_at_48, a3_.last_modified_at AS last_modified_at_49, a3_.trashed_at AS trashed_at_50, t4_.id AS id_51, t4_.start_date AS start_date_52, t4_.end_date AS end_date_53, t4_.duration AS duration_54, t4_.note AS note_55, t4_.status AS status_56, t4_.created_at AS created_at_57 FROM pratica p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id LEFT JOIN user u2_ ON p0_.manager_id = u2_.id LEFT JOIN attivita a3_ ON p0_.id = a3_.project_id LEFT JOIN tempo_lavoro t4_ ON a3_.id = t4_.activity_id) dctrn_result_inner ORDER BY status_1 ASC) dctrn_result LIMIT 20

[]

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      status_1
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.status AS status_1,
          p0_.name AS name_2,
          p0_.description AS description_3,
          p0_.start_date AS start_date_4,
          p0_.end_date AS end_date_5,
          p0_.estimated_hours AS estimated_hours_6,
          p0_.created_at AS created_at_7,
          p0_.last_modified_at AS last_modified_at_8,
          p0_.trashed_at AS trashed_at_9,
          c1_.id AS id_10,
          c1_.name AS name_11,
          c1_.email AS email_12,
          c1_.website AS website_13,
          c1_.phone AS phone_14,
          c1_.fax AS fax_15,
          c1_.fiscal_code AS fiscal_code_16,
          c1_.vat_number AS vat_number_17,
          c1_.sdi AS sdi_18,
          c1_.iban AS iban_19,
          c1_.bic_swift AS bic_swift_20,
          c1_.pec AS pec_21,
          c1_.type AS type_22,
          c1_.ads_adv AS ads_adv_23,
          c1_.fb_adv AS fb_adv_24,
          c1_.external_id AS external_id_25,
          c1_.created_at AS created_at_26,
          c1_.last_modified_at AS last_modified_at_27,
          c1_.trashed_at AS trashed_at_28,
          u2_.id AS id_29,
          u2_.email AS email_30,
          u2_.roles AS roles_31,
          u2_.password AS password_32,
          u2_.username AS username_33,
          u2_.first_name AS first_name_34,
          u2_.last_name AS last_name_35,
          u2_.phone AS phone_36,
          u2_.mobile_phone AS mobile_phone_37,
          u2_.updated_at AS updated_at_38,
          u2_.color AS color_39,
          a3_.id AS id_40,
          a3_.name AS name_41,
          a3_.description AS description_42,
          a3_.start_date AS start_date_43,
          a3_.end_date AS end_date_44,
          a3_.estimated_hours AS estimated_hours_45,
          a3_.priorita AS priorita_46,
          a3_.status AS status_47,
          a3_.created_at AS created_at_48,
          a3_.last_modified_at AS last_modified_at_49,
          a3_.trashed_at AS trashed_at_50,
          t4_.id AS id_51,
          t4_.start_date AS start_date_52,
          t4_.end_date AS end_date_53,
          t4_.duration AS duration_54,
          t4_.note AS note_55,
          t4_.status AS status_56,
          t4_.created_at AS created_at_57
        FROM
          pratica p0_
          LEFT JOIN company c1_ ON p0_.company_id = c1_.id
          LEFT JOIN user u2_ ON p0_.manager_id = u2_.id
          LEFT JOIN attivita a3_ ON p0_.id = a3_.project_id
          LEFT JOIN tempo_lavoro t4_ ON a3_.id = t4_.activity_id
      ) dctrn_result_inner
    ORDER BY
      status_1 ASC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, status_1 FROM (SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.name AS name_2, p0_.description AS description_3, p0_.start_date AS start_date_4, p0_.end_date AS end_date_5, p0_.estimated_hours AS estimated_hours_6, p0_.created_at AS created_at_7, p0_.last_modified_at AS last_modified_at_8, p0_.trashed_at AS trashed_at_9, c1_.id AS id_10, c1_.name AS name_11, c1_.email AS email_12, c1_.website AS website_13, c1_.phone AS phone_14, c1_.fax AS fax_15, c1_.fiscal_code AS fiscal_code_16, c1_.vat_number AS vat_number_17, c1_.sdi AS sdi_18, c1_.iban AS iban_19, c1_.bic_swift AS bic_swift_20, c1_.pec AS pec_21, c1_.type AS type_22, c1_.ads_adv AS ads_adv_23, c1_.fb_adv AS fb_adv_24, c1_.external_id AS external_id_25, c1_.created_at AS created_at_26, c1_.last_modified_at AS last_modified_at_27, c1_.trashed_at AS trashed_at_28, u2_.id AS id_29, u2_.email AS email_30, u2_.roles AS roles_31, u2_.password AS password_32, u2_.username AS username_33, u2_.first_name AS first_name_34, u2_.last_name AS last_name_35, u2_.phone AS phone_36, u2_.mobile_phone AS mobile_phone_37, u2_.updated_at AS updated_at_38, u2_.color AS color_39, a3_.id AS id_40, a3_.name AS name_41, a3_.description AS description_42, a3_.start_date AS start_date_43, a3_.end_date AS end_date_44, a3_.estimated_hours AS estimated_hours_45, a3_.priorita AS priorita_46, a3_.status AS status_47, a3_.created_at AS created_at_48, a3_.last_modified_at AS last_modified_at_49, a3_.trashed_at AS trashed_at_50, t4_.id AS id_51, t4_.start_date AS start_date_52, t4_.end_date AS end_date_53, t4_.duration AS duration_54, t4_.note AS note_55, t4_.status AS status_56, t4_.created_at AS created_at_57 FROM pratica p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id LEFT JOIN user u2_ ON p0_.manager_id = u2_.id LEFT JOIN attivita a3_ ON p0_.id = a3_.project_id LEFT JOIN tempo_lavoro t4_ ON a3_.id = t4_.activity_id) dctrn_result_inner ORDER BY status_1 ASC) dctrn_result LIMIT 20;