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

Response
200 OK
IP
20.171.207.118
Profiled on
Token
632718

Query Metrics

828 Database Queries
10 Different statements
1206.24 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
515.74 ms
(42.76%) 		205 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
255.31 ms
(21.17%) 		206 
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
235.37 ms
(19.51%) 		202 
UPDATE pagamenti SET data_modifica = ? WHERE id = ?
Parameters: 
[
  "2025-09-19 01:00:51"
  22
]
View formatted query    View runnable query    Explain query
180.29 ms
(14.95%) 		205 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
8.61 ms
(0.71%) 		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"
  "20.171.207.118"
  ""
  "fec29420ddd2f5509688"
  "ImportazioneController"
  "caricaPagamenti"
]
View formatted query    View runnable query    Explain query
3.10 ms
(0.26%) 		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
2.52 ms
(0.21%) 		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
2.41 ms
(0.20%) 		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"
  "2025-09-19 01:00:52"
  168
]
View formatted query    View runnable query    Explain query
1.65 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
1.24 ms
(0.10%) 		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.