Symfony Profiler

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

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  attivita a0_

SELECT COUNT(a0_.id) AS sclr_0 FROM attivita a0_;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      name_1
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.name AS name_1,
          a0_.description AS description_2,
          a0_.start_date AS start_date_3,
          a0_.end_date AS end_date_4,
          a0_.estimated_hours AS estimated_hours_5,
          a0_.priorita AS priorita_6,
          a0_.status AS status_7,
          a0_.created_at AS created_at_8,
          a0_.last_modified_at AS last_modified_at_9,
          a0_.trashed_at AS trashed_at_10,
          p1_.id AS id_11,
          p1_.status AS status_12,
          p1_.name AS name_13,
          p1_.description AS description_14,
          p1_.start_date AS start_date_15,
          p1_.end_date AS end_date_16,
          p1_.estimated_hours AS estimated_hours_17,
          p1_.created_at AS created_at_18,
          p1_.last_modified_at AS last_modified_at_19,
          p1_.trashed_at AS trashed_at_20,
          u2_.id AS id_21,
          u2_.email AS email_22,
          u2_.roles AS roles_23,
          u2_.password AS password_24,
          u2_.username AS username_25,
          u2_.first_name AS first_name_26,
          u2_.last_name AS last_name_27,
          u2_.phone AS phone_28,
          u2_.mobile_phone AS mobile_phone_29,
          u2_.updated_at AS updated_at_30,
          u2_.color AS color_31,
          u3_.id AS id_32,
          u3_.email AS email_33,
          u3_.roles AS roles_34,
          u3_.password AS password_35,
          u3_.username AS username_36,
          u3_.first_name AS first_name_37,
          u3_.last_name AS last_name_38,
          u3_.phone AS phone_39,
          u3_.mobile_phone AS mobile_phone_40,
          u3_.updated_at AS updated_at_41,
          u3_.color AS color_42,
          t4_.id AS id_43,
          t4_.start_date AS start_date_44,
          t4_.end_date AS end_date_45,
          t4_.duration AS duration_46,
          t4_.note AS note_47,
          t4_.status AS status_48,
          t4_.created_at AS created_at_49
        FROM
          attivita a0_
          LEFT JOIN pratica p1_ ON a0_.project_id = p1_.id
          LEFT JOIN attivita_responsabili a5_ ON a0_.id = a5_.attivita_id
          LEFT JOIN user u2_ ON u2_.id = a5_.user_id
          LEFT JOIN attivita_operativi a6_ ON a0_.id = a6_.attivita_id
          LEFT JOIN user u3_ ON u3_.id = a6_.user_id
          LEFT JOIN tempo_lavoro t4_ ON a0_.id = t4_.activity_id
      ) dctrn_result_inner
    ORDER BY
      name_1 ASC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_1 FROM (SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.start_date AS start_date_3, a0_.end_date AS end_date_4, a0_.estimated_hours AS estimated_hours_5, a0_.priorita AS priorita_6, a0_.status AS status_7, a0_.created_at AS created_at_8, a0_.last_modified_at AS last_modified_at_9, a0_.trashed_at AS trashed_at_10, p1_.id AS id_11, p1_.status AS status_12, p1_.name AS name_13, p1_.description AS description_14, p1_.start_date AS start_date_15, p1_.end_date AS end_date_16, p1_.estimated_hours AS estimated_hours_17, p1_.created_at AS created_at_18, p1_.last_modified_at AS last_modified_at_19, p1_.trashed_at AS trashed_at_20, u2_.id AS id_21, u2_.email AS email_22, u2_.roles AS roles_23, u2_.password AS password_24, u2_.username AS username_25, u2_.first_name AS first_name_26, u2_.last_name AS last_name_27, u2_.phone AS phone_28, u2_.mobile_phone AS mobile_phone_29, u2_.updated_at AS updated_at_30, u2_.color AS color_31, u3_.id AS id_32, u3_.email AS email_33, u3_.roles AS roles_34, u3_.password AS password_35, u3_.username AS username_36, u3_.first_name AS first_name_37, u3_.last_name AS last_name_38, u3_.phone AS phone_39, u3_.mobile_phone AS mobile_phone_40, u3_.updated_at AS updated_at_41, u3_.color AS color_42, t4_.id AS id_43, t4_.start_date AS start_date_44, t4_.end_date AS end_date_45, t4_.duration AS duration_46, t4_.note AS note_47, t4_.status AS status_48, t4_.created_at AS created_at_49 FROM attivita a0_ LEFT JOIN pratica p1_ ON a0_.project_id = p1_.id LEFT JOIN attivita_responsabili a5_ ON a0_.id = a5_.attivita_id LEFT JOIN user u2_ ON u2_.id = a5_.user_id LEFT JOIN attivita_operativi a6_ ON a0_.id = a6_.attivita_id LEFT JOIN user u3_ ON u3_.id = a6_.user_id LEFT JOIN tempo_lavoro t4_ ON a0_.id = t4_.activity_id) dctrn_result_inner ORDER BY name_1 ASC) dctrn_result LIMIT 20;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.start_date AS start_date_3,
  a0_.end_date AS end_date_4,
  a0_.estimated_hours AS estimated_hours_5,
  a0_.priorita AS priorita_6,
  a0_.status AS status_7,
  a0_.created_at AS created_at_8,
  a0_.last_modified_at AS last_modified_at_9,
  a0_.trashed_at AS trashed_at_10,
  p1_.id AS id_11,
  p1_.status AS status_12,
  p1_.name AS name_13,
  p1_.description AS description_14,
  p1_.start_date AS start_date_15,
  p1_.end_date AS end_date_16,
  p1_.estimated_hours AS estimated_hours_17,
  p1_.created_at AS created_at_18,
  p1_.last_modified_at AS last_modified_at_19,
  p1_.trashed_at AS trashed_at_20,
  u2_.id AS id_21,
  u2_.email AS email_22,
  u2_.roles AS roles_23,
  u2_.password AS password_24,
  u2_.username AS username_25,
  u2_.first_name AS first_name_26,
  u2_.last_name AS last_name_27,
  u2_.phone AS phone_28,
  u2_.mobile_phone AS mobile_phone_29,
  u2_.updated_at AS updated_at_30,
  u2_.color AS color_31,
  u3_.id AS id_32,
  u3_.email AS email_33,
  u3_.roles AS roles_34,
  u3_.password AS password_35,
  u3_.username AS username_36,
  u3_.first_name AS first_name_37,
  u3_.last_name AS last_name_38,
  u3_.phone AS phone_39,
  u3_.mobile_phone AS mobile_phone_40,
  u3_.updated_at AS updated_at_41,
  u3_.color AS color_42,
  t4_.id AS id_43,
  t4_.start_date AS start_date_44,
  t4_.end_date AS end_date_45,
  t4_.duration AS duration_46,
  t4_.note AS note_47,
  t4_.status AS status_48,
  t4_.created_at AS created_at_49,
  a0_.project_id AS project_id_50,
  a0_.manager_id AS manager_id_51,
  a0_.type_id AS type_id_52,
  a0_.created_by_user_id AS created_by_user_id_53,
  a0_.last_modified_by_user_id AS last_modified_by_user_id_54,
  a0_.trashed_by_id AS trashed_by_id_55,
  p1_.type_id AS type_id_56,
  p1_.manager_id AS manager_id_57,
  p1_.company_id AS company_id_58,
  p1_.created_by_user_id AS created_by_user_id_59,
  p1_.last_modified_by_user_id AS last_modified_by_user_id_60,
  p1_.trashed_by_id AS trashed_by_id_61,
  u2_.website_language_id AS website_language_id_62,
  u3_.website_language_id AS website_language_id_63,
  t4_.activity_id AS activity_id_64,
  t4_.user_id AS user_id_65,
  t4_.created_by_user_id AS created_by_user_id_66
FROM
  attivita a0_
  LEFT JOIN pratica p1_ ON a0_.project_id = p1_.id
  LEFT JOIN attivita_responsabili a5_ ON a0_.id = a5_.attivita_id
  LEFT JOIN user u2_ ON u2_.id = a5_.user_id
  LEFT JOIN attivita_operativi a6_ ON a0_.id = a6_.attivita_id
  LEFT JOIN user u3_ ON u3_.id = a6_.user_id
  LEFT JOIN tempo_lavoro t4_ ON a0_.id = t4_.activity_id
WHERE
  a0_.id IN (?, ?, ?, ?)
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.start_date AS start_date_3, a0_.end_date AS end_date_4, a0_.estimated_hours AS estimated_hours_5, a0_.priorita AS priorita_6, a0_.status AS status_7, a0_.created_at AS created_at_8, a0_.last_modified_at AS last_modified_at_9, a0_.trashed_at AS trashed_at_10, p1_.id AS id_11, p1_.status AS status_12, p1_.name AS name_13, p1_.description AS description_14, p1_.start_date AS start_date_15, p1_.end_date AS end_date_16, p1_.estimated_hours AS estimated_hours_17, p1_.created_at AS created_at_18, p1_.last_modified_at AS last_modified_at_19, p1_.trashed_at AS trashed_at_20, u2_.id AS id_21, u2_.email AS email_22, u2_.roles AS roles_23, u2_.password AS password_24, u2_.username AS username_25, u2_.first_name AS first_name_26, u2_.last_name AS last_name_27, u2_.phone AS phone_28, u2_.mobile_phone AS mobile_phone_29, u2_.updated_at AS updated_at_30, u2_.color AS color_31, u3_.id AS id_32, u3_.email AS email_33, u3_.roles AS roles_34, u3_.password AS password_35, u3_.username AS username_36, u3_.first_name AS first_name_37, u3_.last_name AS last_name_38, u3_.phone AS phone_39, u3_.mobile_phone AS mobile_phone_40, u3_.updated_at AS updated_at_41, u3_.color AS color_42, t4_.id AS id_43, t4_.start_date AS start_date_44, t4_.end_date AS end_date_45, t4_.duration AS duration_46, t4_.note AS note_47, t4_.status AS status_48, t4_.created_at AS created_at_49, a0_.project_id AS project_id_50, a0_.manager_id AS manager_id_51, a0_.type_id AS type_id_52, a0_.created_by_user_id AS created_by_user_id_53, a0_.last_modified_by_user_id AS last_modified_by_user_id_54, a0_.trashed_by_id AS trashed_by_id_55, p1_.type_id AS type_id_56, p1_.manager_id AS manager_id_57, p1_.company_id AS company_id_58, p1_.created_by_user_id AS created_by_user_id_59, p1_.last_modified_by_user_id AS last_modified_by_user_id_60, p1_.trashed_by_id AS trashed_by_id_61, u2_.website_language_id AS website_language_id_62, u3_.website_language_id AS website_language_id_63, t4_.activity_id AS activity_id_64, t4_.user_id AS user_id_65, t4_.created_by_user_id AS created_by_user_id_66 FROM attivita a0_ LEFT JOIN pratica p1_ ON a0_.project_id = p1_.id LEFT JOIN attivita_responsabili a5_ ON a0_.id = a5_.attivita_id LEFT JOIN user u2_ ON u2_.id = a5_.user_id LEFT JOIN attivita_operativi a6_ ON a0_.id = a6_.attivita_id LEFT JOIN user u3_ ON u3_.id = a6_.user_id LEFT JOIN tempo_lavoro t4_ ON a0_.id = t4_.activity_id WHERE a0_.id IN (1, 2, 3, 4) ORDER BY a0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.original_file_name AS original_file_name_3,
  t0.file_path AS file_path_4,
  t0.file_size AS file_size_5,
  t0.mime_type AS mime_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.text_type AS text_type_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11
FROM
  media_file t0
WHERE
  t0.created_by_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_file_name AS original_file_name_3, t0.file_path AS file_path_4, t0.file_size AS file_size_5, t0.mime_type AS mime_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.text_type AS text_type_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM media_file t0 WHERE t0.created_by_id = 1;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.original_file_name AS original_file_name_3,
  t0.file_path AS file_path_4,
  t0.file_size AS file_size_5,
  t0.mime_type AS mime_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.text_type AS text_type_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11
FROM
  media_file t0
WHERE
  t0.created_by_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_file_name AS original_file_name_3, t0.file_path AS file_path_4, t0.file_size AS file_size_5, t0.mime_type AS mime_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.text_type AS text_type_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM media_file t0 WHERE t0.created_by_id = 7;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.original_file_name AS original_file_name_3,
  t0.file_path AS file_path_4,
  t0.file_size AS file_size_5,
  t0.mime_type AS mime_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.text_type AS text_type_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11
FROM
  media_file t0
WHERE
  t0.created_by_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_file_name AS original_file_name_3, t0.file_path AS file_path_4, t0.file_size AS file_size_5, t0.mime_type AS mime_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.text_type AS text_type_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM media_file t0 WHERE t0.created_by_id = 8;