Symfony Profiler

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.telefono AS telefono_7,
  t0.email AS email_8,
  t0.is_attivo AS is_attivo_9,
  t0.permission AS permission_10
FROM
  `core_users` t0
WHERE
  t0.username = ?
LIMIT
  1

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.telefono AS telefono_7, t0.email AS email_8, t0.is_attivo AS is_attivo_9, t0.permission AS permission_10 FROM `core_users` t0 WHERE t0.username = 'isa_api' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.codice AS codice_2,
  t0.rag_soc AS rag_soc_3,
  t0.cf AS cf_4,
  t0.piva AS piva_5,
  t0.logo AS logo_6,
  t0.indirizzo AS indirizzo_7,
  t0.cap AS cap_8,
  t0.comune AS comune_9,
  t0.prov AS prov_10,
  t0.rea AS rea_11,
  t0.cciaa AS cciaa_12,
  t0.rappresentante AS rappresentante_13,
  t0.web AS web_14,
  t0.email AS email_15,
  t0.pec AS pec_16,
  t0.tel AS tel_17,
  t0.tel_alt AS tel_alt_18,
  t0.fax AS fax_19,
  t0.descrizione AS descrizione_20,
  t0.referente AS referente_21,
  t0.referente_tel AS referente_tel_22,
  t0.stato_lavori AS stato_lavori_23
FROM
  `settings_azienda` t0
WHERE
  t0.piva = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.codice AS codice_2, t0.rag_soc AS rag_soc_3, t0.cf AS cf_4, t0.piva AS piva_5, t0.logo AS logo_6, t0.indirizzo AS indirizzo_7, t0.cap AS cap_8, t0.comune AS comune_9, t0.prov AS prov_10, t0.rea AS rea_11, t0.cciaa AS cciaa_12, t0.rappresentante AS rappresentante_13, t0.web AS web_14, t0.email AS email_15, t0.pec AS pec_16, t0.tel AS tel_17, t0.tel_alt AS tel_alt_18, t0.fax AS fax_19, t0.descrizione AS descrizione_20, t0.referente AS referente_21, t0.referente_tel AS referente_tel_22, t0.stato_lavori AS stato_lavori_23 FROM `settings_azienda` t0 WHERE t0.piva = '02140860764' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.codice AS codice_2,
  t0.guid AS guid_3,
  t0.cf AS cf_4,
  t0.stato_id AS stato_id_5,
  t0.nome AS nome_6,
  t0.cognome AS cognome_7,
  t0.nascita_luogo AS nascita_luogo_8,
  t0.nascita_data AS nascita_data_9,
  t0.res_indirizzo AS res_indirizzo_10,
  t0.res_cap AS res_cap_11,
  t0.res_comune AS res_comune_12,
  t0.res_prov AS res_prov_13,
  t0.badge AS badge_14,
  t0.badge_stato_id AS badge_stato_id_15,
  t0.badge_codice AS badge_codice_16,
  t0.is_distacco AS is_distacco_17,
  t0.distacco_impresa AS distacco_impresa_18,
  t0.badge_scadenza AS badge_scadenza_19,
  t0.cod_commessa AS cod_commessa_20,
  t0.etichette AS etichette_21,
  t0.tag_id AS tag_id_22,
  t0.azienda_id AS azienda_id_23
FROM
  `settings_lavoratore` t0
WHERE
  t0.guid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.codice AS codice_2, t0.guid AS guid_3, t0.cf AS cf_4, t0.stato_id AS stato_id_5, t0.nome AS nome_6, t0.cognome AS cognome_7, t0.nascita_luogo AS nascita_luogo_8, t0.nascita_data AS nascita_data_9, t0.res_indirizzo AS res_indirizzo_10, t0.res_cap AS res_cap_11, t0.res_comune AS res_comune_12, t0.res_prov AS res_prov_13, t0.badge AS badge_14, t0.badge_stato_id AS badge_stato_id_15, t0.badge_codice AS badge_codice_16, t0.is_distacco AS is_distacco_17, t0.distacco_impresa AS distacco_impresa_18, t0.badge_scadenza AS badge_scadenza_19, t0.cod_commessa AS cod_commessa_20, t0.etichette AS etichette_21, t0.tag_id AS tag_id_22, t0.azienda_id AS azienda_id_23 FROM `settings_lavoratore` t0 WHERE t0.guid = 'L_aa0043d6-b6e7-4ba6-a858-ae39d0de1934' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  `settings_lavoratore`
SET
  nascita_data = ?
WHERE
  id = ?

UPDATE `settings_lavoratore` SET nascita_data = '2004-03-27' WHERE id = 9172;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.politica_accesso AS politica_accesso_3,
  t0.is_default AS is_default_4,
  t0.commesse AS commesse_5
FROM
  `accessi_profilo` t0
WHERE
  t0.is_default = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.politica_accesso AS politica_accesso_3, t0.is_default AS is_default_4, t0.commesse AS commesse_5 FROM `accessi_profilo` t0 WHERE t0.is_default = 1;

SELECT
  t0.is_attivo AS is_attivo_1,
  t0.profilo_id AS profilo_id_2,
  t0.lavoratore_id AS lavoratore_id_3
FROM
  `accessi_profilo_x_lavoratore` t0
WHERE
  t0.lavoratore_id = ?
  AND t0.profilo_id = ?
LIMIT
  1

SELECT t0.is_attivo AS is_attivo_1, t0.profilo_id AS profilo_id_2, t0.lavoratore_id AS lavoratore_id_3 FROM `accessi_profilo_x_lavoratore` t0 WHERE t0.lavoratore_id = 9172 AND t0.profilo_id = 3 LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.nome AS nome_1,
  a0_.indirizzo_ip AS indirizzo_ip_2,
  a0_.connessione_server_porta AS connessione_server_porta_3,
  a0_.connessione_server_ip AS connessione_server_ip_4,
  a0_.connessione_client_ip AS connessione_client_ip_5,
  a0_.connessione_client_script AS connessione_client_script_6,
  a0_.tipologia AS tipologia_7,
  a0_.posizione AS posizione_8,
  a0_.codice AS codice_9,
  a0_.is_attivo AS is_attivo_10,
  a0_.connessione_client_porta AS connessione_client_porta_11,
  a0_.tipo AS tipo_12,
  a0_.connessione_db_ip AS connessione_db_ip_13,
  a0_.connessione_db_porta AS connessione_db_porta_14,
  a0_.connessione_db_dbname AS connessione_db_dbname_15,
  a0_.connessione_db_username AS connessione_db_username_16,
  a0_.connessione_db_password AS connessione_db_password_17,
  a0_.tipo_invio AS tipo_invio_18,
  a0_.stato_id AS stato_id_19,
  a1_.id AS id_20,
  a0_.gruppo_id AS gruppo_id_21
FROM
  `accessi_dispositivo` a0_
  LEFT JOIN `accessi_gruppo_dispositivo` a2_ ON a0_.gruppo_id = a2_.id
  LEFT JOIN `accessi_profilo_x_gruppo` a3_ ON a2_.id = a3_.gruppo_id
  LEFT JOIN `accessi_profilo` a1_ ON (a1_.id = a3_.profilo_id)
  LEFT JOIN `accessi_profilo_x_lavoratore` a4_ ON a1_.id = a4_.profilo_id
WHERE
  a4_.lavoratore_id = ?

SELECT a0_.id AS id_0, a0_.nome AS nome_1, a0_.indirizzo_ip AS indirizzo_ip_2, a0_.connessione_server_porta AS connessione_server_porta_3, a0_.connessione_server_ip AS connessione_server_ip_4, a0_.connessione_client_ip AS connessione_client_ip_5, a0_.connessione_client_script AS connessione_client_script_6, a0_.tipologia AS tipologia_7, a0_.posizione AS posizione_8, a0_.codice AS codice_9, a0_.is_attivo AS is_attivo_10, a0_.connessione_client_porta AS connessione_client_porta_11, a0_.tipo AS tipo_12, a0_.connessione_db_ip AS connessione_db_ip_13, a0_.connessione_db_porta AS connessione_db_porta_14, a0_.connessione_db_dbname AS connessione_db_dbname_15, a0_.connessione_db_username AS connessione_db_username_16, a0_.connessione_db_password AS connessione_db_password_17, a0_.tipo_invio AS tipo_invio_18, a0_.stato_id AS stato_id_19, a1_.id AS id_20, a0_.gruppo_id AS gruppo_id_21 FROM `accessi_dispositivo` a0_ LEFT JOIN `accessi_gruppo_dispositivo` a2_ ON a0_.gruppo_id = a2_.id LEFT JOIN `accessi_profilo_x_gruppo` a3_ ON a2_.id = a3_.gruppo_id LEFT JOIN `accessi_profilo` a1_ ON (a1_.id = a3_.profilo_id) LEFT JOIN `accessi_profilo_x_lavoratore` a4_ ON a1_.id = a4_.profilo_id WHERE a4_.lavoratore_id = 9172;

SELECT
  t0.is_attivo AS is_attivo_1,
  t0.profilo_id AS profilo_id_2,
  t0.lavoratore_id AS lavoratore_id_3
FROM
  `accessi_profilo_x_lavoratore` t0
WHERE
  t0.lavoratore_id = ?
  AND t0.profilo_id = ?
LIMIT
  1

SELECT t0.is_attivo AS is_attivo_1, t0.profilo_id AS profilo_id_2, t0.lavoratore_id AS lavoratore_id_3 FROM `accessi_profilo_x_lavoratore` t0 WHERE t0.lavoratore_id = 9172 AND t0.profilo_id = 5 LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.nome AS nome_1,
  a0_.indirizzo_ip AS indirizzo_ip_2,
  a0_.connessione_server_porta AS connessione_server_porta_3,
  a0_.connessione_server_ip AS connessione_server_ip_4,
  a0_.connessione_client_ip AS connessione_client_ip_5,
  a0_.connessione_client_script AS connessione_client_script_6,
  a0_.tipologia AS tipologia_7,
  a0_.posizione AS posizione_8,
  a0_.codice AS codice_9,
  a0_.is_attivo AS is_attivo_10,
  a0_.connessione_client_porta AS connessione_client_porta_11,
  a0_.tipo AS tipo_12,
  a0_.connessione_db_ip AS connessione_db_ip_13,
  a0_.connessione_db_porta AS connessione_db_porta_14,
  a0_.connessione_db_dbname AS connessione_db_dbname_15,
  a0_.connessione_db_username AS connessione_db_username_16,
  a0_.connessione_db_password AS connessione_db_password_17,
  a0_.tipo_invio AS tipo_invio_18,
  a0_.stato_id AS stato_id_19,
  a1_.id AS id_20,
  a0_.gruppo_id AS gruppo_id_21
FROM
  `accessi_dispositivo` a0_
  LEFT JOIN `accessi_gruppo_dispositivo` a2_ ON a0_.gruppo_id = a2_.id
  LEFT JOIN `accessi_profilo_x_gruppo` a3_ ON a2_.id = a3_.gruppo_id
  LEFT JOIN `accessi_profilo` a1_ ON (a1_.id = a3_.profilo_id)
  LEFT JOIN `accessi_profilo_x_lavoratore` a4_ ON a1_.id = a4_.profilo_id
WHERE
  a4_.lavoratore_id = ?

SELECT a0_.id AS id_0, a0_.nome AS nome_1, a0_.indirizzo_ip AS indirizzo_ip_2, a0_.connessione_server_porta AS connessione_server_porta_3, a0_.connessione_server_ip AS connessione_server_ip_4, a0_.connessione_client_ip AS connessione_client_ip_5, a0_.connessione_client_script AS connessione_client_script_6, a0_.tipologia AS tipologia_7, a0_.posizione AS posizione_8, a0_.codice AS codice_9, a0_.is_attivo AS is_attivo_10, a0_.connessione_client_porta AS connessione_client_porta_11, a0_.tipo AS tipo_12, a0_.connessione_db_ip AS connessione_db_ip_13, a0_.connessione_db_porta AS connessione_db_porta_14, a0_.connessione_db_dbname AS connessione_db_dbname_15, a0_.connessione_db_username AS connessione_db_username_16, a0_.connessione_db_password AS connessione_db_password_17, a0_.tipo_invio AS tipo_invio_18, a0_.stato_id AS stato_id_19, a1_.id AS id_20, a0_.gruppo_id AS gruppo_id_21 FROM `accessi_dispositivo` a0_ LEFT JOIN `accessi_gruppo_dispositivo` a2_ ON a0_.gruppo_id = a2_.id LEFT JOIN `accessi_profilo_x_gruppo` a3_ ON a2_.id = a3_.gruppo_id LEFT JOIN `accessi_profilo` a1_ ON (a1_.id = a3_.profilo_id) LEFT JOIN `accessi_profilo_x_lavoratore` a4_ ON a1_.id = a4_.profilo_id WHERE a4_.lavoratore_id = 9172;