Symfony Profiler

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  appuntamento a0_
  LEFT JOIN cliente c1_ ON a0_.cliente_id = c1_.id
  AND (
    c1_.deleted_at IS NULL
    OR c1_.deleted_at >= CURRENT_TIMESTAMP
  )
  LEFT JOIN appuntamento_utente a3_ ON a0_.id = a3_.appuntamento_id
  LEFT JOIN utente u2_ ON u2_.id = a3_.utente_id
  AND (
    u2_.deleted_at IS NULL
    OR u2_.deleted_at >= CURRENT_TIMESTAMP
  )

SELECT COUNT(a0_.id) AS sclr_0 FROM appuntamento a0_ LEFT JOIN cliente c1_ ON a0_.cliente_id = c1_.id AND (c1_.deleted_at IS NULL OR c1_.deleted_at >= CURRENT_TIMESTAMP) LEFT JOIN appuntamento_utente a3_ ON a0_.id = a3_.appuntamento_id LEFT JOIN utente u2_ ON u2_.id = a3_.utente_id AND (u2_.deleted_at IS NULL OR u2_.deleted_at >= CURRENT_TIMESTAMP);

SELECT
  a0_.id AS id_0,
  a0_.data_inizio_programmata AS data_inizio_programmata_1,
  a0_.data_fine_programmata AS data_fine_programmata_2,
  a0_.data_inizio_reale AS data_inizio_reale_3,
  a0_.data_fine_reale AS data_fine_reale_4,
  a0_.tipologia AS tipologia_5,
  a0_.chiuso AS chiuso_6,
  a0_.note AS note_7,
  a0_.ore_per_operatore AS ore_per_operatore_8,
  a0_.link_maps AS link_maps_9,
  c1_.id AS id_10,
  c1_.codice_cliente AS codice_cliente_11,
  c1_.ragione_sociale AS ragione_sociale_12,
  c1_.indirizzo AS indirizzo_13,
  c1_.localita AS localita_14,
  c1_.cap AS cap_15,
  c1_.provincia AS provincia_16,
  c1_.partita_iva AS partita_iva_17,
  c1_.codice_fiscale AS codice_fiscale_18,
  c1_.email AS email_19,
  c1_.pec AS pec_20,
  c1_.codice_sdi AS codice_sdi_21,
  c1_.iban AS iban_22,
  c1_.telefono AS telefono_23,
  c1_.referente AS referente_24,
  c1_.descrizione_contratto AS descrizione_contratto_25,
  c1_.contratto_attivo AS contratto_attivo_26,
  c1_.costo_orario_contratto AS costo_orario_contratto_27,
  c1_.ore_settimanali_contratto AS ore_settimanali_contratto_28,
  c1_.data_inizio_contratto AS data_inizio_contratto_29,
  c1_.ricavo_fisso_mensile AS ricavo_fisso_mensile_30,
  c1_.link_maps AS link_maps_31,
  c1_.documento_to_do AS documento_to_do_32,
  c1_.minimo_ore_appuntamento AS minimo_ore_appuntamento_33,
  c1_.deleted_at AS deleted_at_34,
  u2_.id AS id_35,
  u2_.username AS username_36,
  u2_.roles AS roles_37,
  u2_.password AS password_38,
  u2_.nome AS nome_39,
  u2_.cognome AS cognome_40,
  u2_.indirizzo AS indirizzo_41,
  u2_.localita AS localita_42,
  u2_.cap AS cap_43,
  u2_.provincia AS provincia_44,
  u2_.codice_fiscale AS codice_fiscale_45,
  u2_.email AS email_46,
  u2_.cellulare AS cellulare_47,
  u2_.data_assunzione AS data_assunzione_48,
  u2_.colore AS colore_49,
  u2_.costo_orario AS costo_orario_50,
  u2_.data_nascita AS data_nascita_51,
  u2_.ore_settimanali AS ore_settimanali_52,
  u2_.disabilitato AS disabilitato_53,
  u2_.deleted_at AS deleted_at_54,
  a0_.cliente_id AS cliente_id_55,
  c1_.condizione_pagamento_id AS condizione_pagamento_id_56
FROM
  appuntamento a0_
  LEFT JOIN cliente c1_ ON a0_.cliente_id = c1_.id
  AND (
    c1_.deleted_at IS NULL
    OR c1_.deleted_at >= CURRENT_TIMESTAMP
  )
  LEFT JOIN appuntamento_utente a3_ ON a0_.id = a3_.appuntamento_id
  LEFT JOIN utente u2_ ON u2_.id = a3_.utente_id
  AND (
    u2_.deleted_at IS NULL
    OR u2_.deleted_at >= CURRENT_TIMESTAMP
  )
ORDER BY
  a0_.id ASC
LIMIT
  20

SELECT a0_.id AS id_0, a0_.data_inizio_programmata AS data_inizio_programmata_1, a0_.data_fine_programmata AS data_fine_programmata_2, a0_.data_inizio_reale AS data_inizio_reale_3, a0_.data_fine_reale AS data_fine_reale_4, a0_.tipologia AS tipologia_5, a0_.chiuso AS chiuso_6, a0_.note AS note_7, a0_.ore_per_operatore AS ore_per_operatore_8, a0_.link_maps AS link_maps_9, c1_.id AS id_10, c1_.codice_cliente AS codice_cliente_11, c1_.ragione_sociale AS ragione_sociale_12, c1_.indirizzo AS indirizzo_13, c1_.localita AS localita_14, c1_.cap AS cap_15, c1_.provincia AS provincia_16, c1_.partita_iva AS partita_iva_17, c1_.codice_fiscale AS codice_fiscale_18, c1_.email AS email_19, c1_.pec AS pec_20, c1_.codice_sdi AS codice_sdi_21, c1_.iban AS iban_22, c1_.telefono AS telefono_23, c1_.referente AS referente_24, c1_.descrizione_contratto AS descrizione_contratto_25, c1_.contratto_attivo AS contratto_attivo_26, c1_.costo_orario_contratto AS costo_orario_contratto_27, c1_.ore_settimanali_contratto AS ore_settimanali_contratto_28, c1_.data_inizio_contratto AS data_inizio_contratto_29, c1_.ricavo_fisso_mensile AS ricavo_fisso_mensile_30, c1_.link_maps AS link_maps_31, c1_.documento_to_do AS documento_to_do_32, c1_.minimo_ore_appuntamento AS minimo_ore_appuntamento_33, c1_.deleted_at AS deleted_at_34, u2_.id AS id_35, u2_.username AS username_36, u2_.roles AS roles_37, u2_.password AS password_38, u2_.nome AS nome_39, u2_.cognome AS cognome_40, u2_.indirizzo AS indirizzo_41, u2_.localita AS localita_42, u2_.cap AS cap_43, u2_.provincia AS provincia_44, u2_.codice_fiscale AS codice_fiscale_45, u2_.email AS email_46, u2_.cellulare AS cellulare_47, u2_.data_assunzione AS data_assunzione_48, u2_.colore AS colore_49, u2_.costo_orario AS costo_orario_50, u2_.data_nascita AS data_nascita_51, u2_.ore_settimanali AS ore_settimanali_52, u2_.disabilitato AS disabilitato_53, u2_.deleted_at AS deleted_at_54, a0_.cliente_id AS cliente_id_55, c1_.condizione_pagamento_id AS condizione_pagamento_id_56 FROM appuntamento a0_ LEFT JOIN cliente c1_ ON a0_.cliente_id = c1_.id AND (c1_.deleted_at IS NULL OR c1_.deleted_at >= CURRENT_TIMESTAMP) LEFT JOIN appuntamento_utente a3_ ON a0_.id = a3_.appuntamento_id LEFT JOIN utente u2_ ON u2_.id = a3_.utente_id AND (u2_.deleted_at IS NULL OR u2_.deleted_at >= CURRENT_TIMESTAMP) ORDER BY a0_.id ASC LIMIT 20;

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

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

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nome AS nome_5,
  t0.cognome AS cognome_6,
  t0.indirizzo AS indirizzo_7,
  t0.localita AS localita_8,
  t0.cap AS cap_9,
  t0.provincia AS provincia_10,
  t0.codice_fiscale AS codice_fiscale_11,
  t0.email AS email_12,
  t0.cellulare AS cellulare_13,
  t0.data_assunzione AS data_assunzione_14,
  t0.colore AS colore_15,
  t0.costo_orario AS costo_orario_16,
  t0.data_nascita AS data_nascita_17,
  t0.ore_settimanali AS ore_settimanali_18,
  t0.disabilitato AS disabilitato_19,
  t0.deleted_at AS deleted_at_20
FROM
  utente t0
WHERE
  t0.id = ?
  AND (
    (
      t0.deleted_at IS NULL
      OR t0.deleted_at >= CURRENT_TIMESTAMP
    )
  )

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nome AS nome_5, t0.cognome AS cognome_6, t0.indirizzo AS indirizzo_7, t0.localita AS localita_8, t0.cap AS cap_9, t0.provincia AS provincia_10, t0.codice_fiscale AS codice_fiscale_11, t0.email AS email_12, t0.cellulare AS cellulare_13, t0.data_assunzione AS data_assunzione_14, t0.colore AS colore_15, t0.costo_orario AS costo_orario_16, t0.data_nascita AS data_nascita_17, t0.ore_settimanali AS ore_settimanali_18, t0.disabilitato AS disabilitato_19, t0.deleted_at AS deleted_at_20 FROM utente t0 WHERE t0.id = 2 AND ((t0.deleted_at IS NULL OR t0.deleted_at >= CURRENT_TIMESTAMP));