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 = '07267261217' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.codice AS codice_2,
  t0.cf AS cf_3,
  t0.stato_id AS stato_id_4,
  t0.nome AS nome_5,
  t0.cognome AS cognome_6,
  t0.nascita_luogo AS nascita_luogo_7,
  t0.nascita_data AS nascita_data_8,
  t0.start_at AS start_at_9,
  t0.end_at AS end_at_10,
  t0.auth_at AS auth_at_11,
  t0.auth_ric_at AS auth_ric_at_12,
  t0.motivo_visita AS motivo_visita_13,
  t0.badge AS badge_14,
  t0.badge_stato_id AS badge_stato_id_15,
  t0.badge_codice AS badge_codice_16,
  t0.guid AS guid_17,
  t0.cod_commessa AS cod_commessa_18,
  t0.badge_scadenza AS badge_scadenza_19,
  t0.azienda_id AS azienda_id_20,
  t0.tag_id AS tag_id_21
FROM
  `settings_visitatore` t0
WHERE
  t0.guid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.codice AS codice_2, t0.cf AS cf_3, t0.stato_id AS stato_id_4, t0.nome AS nome_5, t0.cognome AS cognome_6, t0.nascita_luogo AS nascita_luogo_7, t0.nascita_data AS nascita_data_8, t0.start_at AS start_at_9, t0.end_at AS end_at_10, t0.auth_at AS auth_at_11, t0.auth_ric_at AS auth_ric_at_12, t0.motivo_visita AS motivo_visita_13, t0.badge AS badge_14, t0.badge_stato_id AS badge_stato_id_15, t0.badge_codice AS badge_codice_16, t0.guid AS guid_17, t0.cod_commessa AS cod_commessa_18, t0.badge_scadenza AS badge_scadenza_19, t0.azienda_id AS azienda_id_20, t0.tag_id AS tag_id_21 FROM `settings_visitatore` t0 WHERE t0.guid = 'V_c9122bee-26a5-44c1-b4ef-760768eb1514' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO `settings_visitatore` (
  codice, cf, stato_id, nome, cognome,
  nascita_luogo, nascita_data, start_at,
  end_at, auth_at, auth_ric_at, motivo_visita,
  badge, badge_stato_id, badge_codice,
  guid, cod_commessa, badge_scadenza,
  azienda_id, tag_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

INSERT INTO `settings_visitatore` (codice, cf, stato_id, nome, cognome, nascita_luogo, nascita_data, start_at, end_at, auth_at, auth_ric_at, motivo_visita, badge, badge_stato_id, badge_codice, guid, cod_commessa, badge_scadenza, azienda_id, tag_id) VALUES ('V_c9122bee-26a5-44c1-b4ef-760768eb1514', 'FRRGPP96C18F839G', 2, 'GIUSEPPE', 'FERRIGNO', NULL, '1996-03-18', NULL, NULL, NULL, NULL, NULL, '0484CD82F70F90000000', 1, 'V_c9122bee-26a5-44c1-b4ef-760768eb1514', 'V_c9122bee-26a5-44c1-b4ef-760768eb1514', 'TLS001', NULL, 148, NULL);

"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.visitatore_id AS visitatore_id_3
FROM
  `accessi_profilo_x_visitatore` t0
WHERE
  t0.visitatore_id = ?
  AND t0.profilo_id = ?
LIMIT
  1

SELECT t0.is_attivo AS is_attivo_1, t0.profilo_id AS profilo_id_2, t0.visitatore_id AS visitatore_id_3 FROM `accessi_profilo_x_visitatore` t0 WHERE t0.visitatore_id = 1545 AND t0.profilo_id = 3 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO `accessi_profilo_x_visitatore` (
  is_attivo, profilo_id, visitatore_id
)
VALUES
  (?, ?, ?)

INSERT INTO `accessi_profilo_x_visitatore` (is_attivo, profilo_id, visitatore_id) VALUES (1, 3, 1545);

"COMMIT"

"COMMIT";

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_visitatore` a4_ ON a1_.id = a4_.profilo_id
WHERE
  a4_.visitatore_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_visitatore` a4_ ON a1_.id = a4_.profilo_id WHERE a4_.visitatore_id = 1545;

SELECT
  t0.is_attivo AS is_attivo_1,
  t0.profilo_id AS profilo_id_2,
  t0.visitatore_id AS visitatore_id_3
FROM
  `accessi_profilo_x_visitatore` t0
WHERE
  t0.visitatore_id = ?
  AND t0.profilo_id = ?
LIMIT
  1

SELECT t0.is_attivo AS is_attivo_1, t0.profilo_id AS profilo_id_2, t0.visitatore_id AS visitatore_id_3 FROM `accessi_profilo_x_visitatore` t0 WHERE t0.visitatore_id = 1545 AND t0.profilo_id = 5 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO `accessi_profilo_x_visitatore` (
  is_attivo, profilo_id, visitatore_id
)
VALUES
  (?, ?, ?)

INSERT INTO `accessi_profilo_x_visitatore` (is_attivo, profilo_id, visitatore_id) VALUES (1, 5, 1545);

"COMMIT"

"COMMIT";

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_visitatore` a4_ ON a1_.id = a4_.profilo_id
WHERE
  a4_.visitatore_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_visitatore` a4_ ON a1_.id = a4_.profilo_id WHERE a4_.visitatore_id = 1545;