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

Response
200 OK
IP
79.9.224.149
Profiled on
Token
34087b

Query Metrics

808 Database Queries
10 Different statements
778.36 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
430.37 ms
(55.29%) 		200 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
159.25 ms
(20.46%) 		201 
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.codice AS codice_3, t0.descrizione AS descrizione_4, t0.codice_esportazione AS codice_esportazione_5, t0.data_creazione AS data_creazione_6, t0.data_modifica AS data_modifica_7, t0.utente_modifica_id AS utente_modifica_id_8 FROM pagamenti t0 WHERE t0.codice = ? LIMIT 1
Parameters: 
[
  "01"
]
View formatted query    View runnable query    Explain query
112.38 ms
(14.44%) 		197 
UPDATE pagamenti SET data_modifica = ? WHERE id = ?
Parameters: 
[
  "2024-12-23 05:59:43"
  22
]
View formatted query    View runnable query    Explain query
63.06 ms
(8.10%) 		200 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
7.98 ms
(1.03%) 		3 
INSERT INTO registro_attivita(utente_id, data, esito, messaggio, client_ip, debug, collegamento, categoria1, categoria2) VALUES(?,NOW(),?,?,?,?,?,?,?);
Parameters: 
[
  null
  1
  "Chiamata effettuata a /caricaPagamenti --- Inizio l' importazione dei dati"
  "79.9.224.149"
  ""
  "254d3ae5c88ee3ec3172"
  "ImportazioneController"
  "caricaPagamenti"
]
View formatted query    View runnable query    Explain query
1.44 ms
(0.19%) 		3 
UPDATE pagamenti SET nome = ?, descrizione = ?, data_modifica = ? WHERE id = ?
Parameters: 
[
  b"L/C60 Days+Account €5000.00"
  b"L/C60 Days+Account €5000.00"
  "2024-12-23 05:59:44"
  168
]
View formatted query    View runnable query    Explain query
1.40 ms
(0.18%) 		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
0.92 ms
(0.12%) 		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.84 ms
(0.11%) 		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
0.73 ms
(0.09%) 		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

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\Pagamenti No errors.
App\Entity\FiltroVisualizzazioneArticoliClienti No errors.