POST http://shop.omemotors.com/caricaNazioni

Response
200 OK
IP
79.9.224.149
Profiled on
Token
e8dab7

Query Metrics

580 Database Queries
10 Different statements
470.48 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
271.59 ms
(57.73%) 		143 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
81.65 ms
(17.35%) 		144 
SELECT t0.id AS id_1, t0.sigla_iso AS sigla_iso_2, t0.descrizione AS descrizione_3, t0.paese_cee AS paese_cee_4, t0.blacklist AS blacklist_5, t0.data_modifica AS data_modifica_6, t0.data_creazione AS data_creazione_7, t0.utente_id AS utente_id_8 FROM nazioni t0 WHERE t0.sigla_iso = ? LIMIT 1
Parameters: 
[
  "AL"
]
View formatted query    View runnable query    Explain query
67.42 ms
(14.33%) 		140 
UPDATE nazioni SET data_modifica = ? WHERE id = ?
Parameters: 
[
  "2024-09-21 00:59:17"
  5
]
View formatted query    View runnable query    Explain query
35.90 ms
(7.63%) 		143 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
9.30 ms
(1.98%) 		3 
INSERT INTO registro_attivita(utente_id, data, esito, messaggio, client_ip, debug) VALUES(?,NOW(),?,?,?,?);
Parameters: 
[
  null
  1
  "Chiamata effettuata a /caricaNazioni --- Inizio l' importazione dei dati"
  "79.9.224.149"
  ""
]
View formatted query    View runnable query    Explain query
1.18 ms
(0.25%) 		3 
UPDATE nazioni SET descrizione = ?, data_modifica = ? WHERE id = ?
Parameters: 
[
  b"ÖSTERREICH"
  "2024-09-21 00:59:17"
  12
]
View formatted query    View runnable query    Explain query
1.08 ms
(0.23%) 		1 
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.nome_visualizzato AS nome_visualizzato_3, t0.valore AS valore_4, t0.famiglia AS famiglia_5, t0.valori_concessi AS valori_concessi_6, t0.tipo_dato AS tipo_dato_7, t0.data_modifica AS data_modifica_8, t0.utente_modifica_id AS utente_modifica_id_9 FROM impostazioni t0 WHERE t0.famiglia IN (?)
Parameters: 
[
  "Importazioni"
]
View formatted query    View runnable query    Explain query
1.07 ms
(0.23%) 		1 
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.nome_visualizzato AS nome_visualizzato_3, t0.valore AS valore_4, t0.famiglia AS famiglia_5, t0.valori_concessi AS valori_concessi_6, t0.tipo_dato AS tipo_dato_7, t0.data_modifica AS data_modifica_8, t0.utente_modifica_id AS utente_modifica_id_9 FROM impostazioni t0 WHERE t0.nome IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "MailHostSmtp"
  "MailPorta"
  "MailUsername"
  "MailCcComunicazioni"
  "MailPassword"
  "MailCrittografia"
  "IndirizzoMailFromInvioComunicazioni"
  "NomeShop"
  "Logo"
]
View formatted query    View runnable query    Explain query
0.66 ms
(0.14%) 		1 
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.nome_visualizzato AS nome_visualizzato_3, t0.valore AS valore_4, t0.famiglia AS famiglia_5, t0.valori_concessi AS valori_concessi_6, t0.tipo_dato AS tipo_dato_7, t0.data_modifica AS data_modifica_8, t0.utente_modifica_id AS utente_modifica_id_9 FROM impostazioni t0 WHERE t0.nome IN (?)
Parameters: 
[
  "IpAbilitatiChiamateExpImp"
]
View formatted query    View runnable query    Explain query
0.64 ms
(0.13%) 		1 
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.nome_visualizzato AS nome_visualizzato_3, t0.valore AS valore_4, t0.famiglia AS famiglia_5, t0.valori_concessi AS valori_concessi_6, t0.tipo_dato AS tipo_dato_7, t0.data_modifica AS data_modifica_8, t0.utente_modifica_id AS utente_modifica_id_9 FROM impostazioni t0 WHERE t0.nome = ? LIMIT 1
Parameters: 
[
  "PathFileBaseScambioDati"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
searchengine doctrine.dbal.searchengine_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Impostazioni No errors.
App\Entity\User No errors.
App\Entity\Nazioni No errors.
App\Entity\FiltroVisualizzazioneArticoliClienti No errors.