Symfony Profiler

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  contract c0_

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM contract c0_;

SELECT
  t0.id AS id_1,
  t0.nume AS nume_2,
  t0.tag AS tag_3,
  t0.actions AS actions_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  rol t0
WHERE
  t0.tag = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nume AS nume_2, t0.tag AS tag_3, t0.actions AS actions_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM rol t0 WHERE t0.tag = 'ROLE_SUPER_ADMINISTRATOR' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  setare t0
WHERE
  t0.tag = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM setare t0 WHERE t0.tag = 'GLOBAL_PERMISION_MENU' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nume AS nume_2,
  t0.tag AS tag_3,
  t0.actions AS actions_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  rol t0
WHERE
  t0.tag IN (?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.nume AS nume_2, t0.tag AS tag_3, t0.actions AS actions_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM rol t0 WHERE t0.tag IN ('ROLE_SUPER_ADMINISTRATOR', 'ROLE_CETATEAN', 'ROLE_ADMINISTRATOR_MUNICIPAL', 'ROLE_OPERATOR_PARCARI', 'ROLE_OPERATOR_FINANCIAR', 'ROLE_POLITIA_LOCALA', 'EDITOR');

SELECT
  c0_.id AS id_0,
  c0_.id_unic_parcare AS id_unic_parcare_1,
  c0_.numar_document AS numar_document_2,
  c0_.status AS status_3,
  u1_.email AS email_4,
  c0_.email AS email_5,
  c0_.data_start AS data_start_6,
  c0_.data_stop AS data_stop_7,
  c0_.cnp AS cnp_8,
  c0_.cui AS cui_9,
  c0_.nume AS nume_10,
  c0_.prenume AS prenume_11,
  c0_.denumire_societate AS denumire_societate_12,
  c0_.telefon AS telefon_13,
  c0_.id_loc_parcare AS id_loc_parcare_14,
  c0_.handicap AS handicap_15,
  b2_.nume AS nume_16,
  p3_.numar_loc AS numar_loc_17,
  c0_.sincronizare_atribuire AS sincronizare_atribuire_18,
  c0_.sincronizare_prelungire AS sincronizare_prelungire_19,
  c0_.sincronizare_plata AS sincronizare_plata_20,
  c0_.loc_parcare_provizoriu AS loc_parcare_provizoriu_21,
  c0_.tip AS tip_22,
  c0_.incetat_at AS incetat_at_23,
  c0_.termen_limita AS termen_limita_24,
  u4_.email AS email_25,
  p5_.order_id AS order_id_26,
  (
    SELECT
      COUNT(e6_.id) AS sclr_28
    FROM
      eroare e6_
    WHERE
      e6_.contract_id = c0_.id
  ) AS sclr_27,
  (
    SELECT
      MAX(e7_.mesaj) AS sclr_30
    FROM
      eroare e7_
    WHERE
      e7_.contract_id = c0_.id
  ) AS sclr_29
FROM
  contract c0_
  LEFT JOIN user u1_ ON c0_.user_id = u1_.id
  LEFT JOIN user u4_ ON c0_.operator_id = u4_.id
  LEFT JOIN parcare p3_ ON (
    c0_.id_loc_parcare = p3_.id_extern
  )
  LEFT JOIN baterie b2_ ON p3_.baterie_id = b2_.id
  LEFT JOIN plata p5_ ON c0_.id = p5_.contract_id
ORDER BY
  c0_.id DESC
LIMIT
  10

SELECT c0_.id AS id_0, c0_.id_unic_parcare AS id_unic_parcare_1, c0_.numar_document AS numar_document_2, c0_.status AS status_3, u1_.email AS email_4, c0_.email AS email_5, c0_.data_start AS data_start_6, c0_.data_stop AS data_stop_7, c0_.cnp AS cnp_8, c0_.cui AS cui_9, c0_.nume AS nume_10, c0_.prenume AS prenume_11, c0_.denumire_societate AS denumire_societate_12, c0_.telefon AS telefon_13, c0_.id_loc_parcare AS id_loc_parcare_14, c0_.handicap AS handicap_15, b2_.nume AS nume_16, p3_.numar_loc AS numar_loc_17, c0_.sincronizare_atribuire AS sincronizare_atribuire_18, c0_.sincronizare_prelungire AS sincronizare_prelungire_19, c0_.sincronizare_plata AS sincronizare_plata_20, c0_.loc_parcare_provizoriu AS loc_parcare_provizoriu_21, c0_.tip AS tip_22, c0_.incetat_at AS incetat_at_23, c0_.termen_limita AS termen_limita_24, u4_.email AS email_25, p5_.order_id AS order_id_26, (SELECT COUNT(e6_.id) AS sclr_28 FROM eroare e6_ WHERE e6_.contract_id = c0_.id) AS sclr_27, (SELECT MAX(e7_.mesaj) AS sclr_30 FROM eroare e7_ WHERE e7_.contract_id = c0_.id) AS sclr_29 FROM contract c0_ LEFT JOIN user u1_ ON c0_.user_id = u1_.id LEFT JOIN user u4_ ON c0_.operator_id = u4_.id LEFT JOIN parcare p3_ ON (c0_.id_loc_parcare = p3_.id_extern) LEFT JOIN baterie b2_ ON p3_.baterie_id = b2_.id LEFT JOIN plata p5_ ON c0_.id = p5_.contract_id ORDER BY c0_.id DESC LIMIT 10;

SELECT
  p0_.id AS id_0,
  p0_.nume_encrypted AS nume_encrypted_1,
  p0_.nume_index AS nume_index_2,
  p0_.prenume_encrypted AS prenume_encrypted_3,
  p0_.prenume_index AS prenume_index_4,
  p0_.telefon_prefix AS telefon_prefix_5,
  p0_.telefon_prefix_country AS telefon_prefix_country_6,
  p0_.telefon_encrypted AS telefon_encrypted_7,
  p0_.telefon_index AS telefon_index_8,
  p0_.cnp_encrypted AS cnp_encrypted_9,
  p0_.cnp_index AS cnp_index_10,
  p0_.serie_ci_encrypted AS serie_ci_encrypted_11,
  p0_.serie_ci_index AS serie_ci_index_12,
  p0_.numar_ci_encrypted AS numar_ci_encrypted_13,
  p0_.numar_ci_index AS numar_ci_index_14,
  p0_.eliberat_de_encrypted AS eliberat_de_encrypted_15,
  p0_.eliberat_de_index AS eliberat_de_index_16,
  p0_.valabilitate AS valabilitate_17,
  p0_.denumire_societate_encrypted AS denumire_societate_encrypted_18,
  p0_.denumire_societate_index AS denumire_societate_index_19,
  p0_.cui_encrypted AS cui_encrypted_20,
  p0_.cui_index AS cui_index_21,
  p0_.nr_reg_com_encrypted AS nr_reg_com_encrypted_22,
  p0_.nr_reg_com_index AS nr_reg_com_index_23,
  p0_.status AS status_24,
  p0_.cetatean_strain AS cetatean_strain_25,
  p0_.adrese_json AS adrese_json_26,
  p0_.exceptie AS exceptie_27,
  p0_.settings AS settings_28,
  p0_.created_at AS created_at_29,
  p0_.updated_at AS updated_at_30,
  p0_.user_id AS user_id_31
FROM
  profil p0_
WHERE
  p0_.user_id = ?
  AND p0_.status IN (?, ?)
ORDER BY
  p0_.updated_at DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.nume_encrypted AS nume_encrypted_1, p0_.nume_index AS nume_index_2, p0_.prenume_encrypted AS prenume_encrypted_3, p0_.prenume_index AS prenume_index_4, p0_.telefon_prefix AS telefon_prefix_5, p0_.telefon_prefix_country AS telefon_prefix_country_6, p0_.telefon_encrypted AS telefon_encrypted_7, p0_.telefon_index AS telefon_index_8, p0_.cnp_encrypted AS cnp_encrypted_9, p0_.cnp_index AS cnp_index_10, p0_.serie_ci_encrypted AS serie_ci_encrypted_11, p0_.serie_ci_index AS serie_ci_index_12, p0_.numar_ci_encrypted AS numar_ci_encrypted_13, p0_.numar_ci_index AS numar_ci_index_14, p0_.eliberat_de_encrypted AS eliberat_de_encrypted_15, p0_.eliberat_de_index AS eliberat_de_index_16, p0_.valabilitate AS valabilitate_17, p0_.denumire_societate_encrypted AS denumire_societate_encrypted_18, p0_.denumire_societate_index AS denumire_societate_index_19, p0_.cui_encrypted AS cui_encrypted_20, p0_.cui_index AS cui_index_21, p0_.nr_reg_com_encrypted AS nr_reg_com_encrypted_22, p0_.nr_reg_com_index AS nr_reg_com_index_23, p0_.status AS status_24, p0_.cetatean_strain AS cetatean_strain_25, p0_.adrese_json AS adrese_json_26, p0_.exceptie AS exceptie_27, p0_.settings AS settings_28, p0_.created_at AS created_at_29, p0_.updated_at AS updated_at_30, p0_.user_id AS user_id_31 FROM profil p0_ WHERE p0_.user_id = 48 AND p0_.status IN (1, 2) ORDER BY p0_.updated_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.status AS status_3,
  t0.tip AS tip_4,
  t0.roles AS roles_5,
  t0.settings AS settings_6,
  t0.password AS password_7,
  t0.confirmation_token AS confirmation_token_8,
  t0.password_requested_at AS password_requested_at_9,
  t0.last_activity_at AS last_activity_at_10,
  t0.last_login_at AS last_login_at_11,
  t0.termen_limita AS termen_limita_12,
  t0.file_avatar_name AS file_avatar_name_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.status AS status_3, t0.tip AS tip_4, t0.roles AS roles_5, t0.settings AS settings_6, t0.password AS password_7, t0.confirmation_token AS confirmation_token_8, t0.password_requested_at AS password_requested_at_9, t0.last_activity_at AS last_activity_at_10, t0.last_login_at AS last_login_at_11, t0.termen_limita AS termen_limita_12, t0.file_avatar_name AS file_avatar_name_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM user t0 WHERE t0.id = 48;