Query Metrics
6
Database Queries
6
Different statements
3.10 ms
Query time
0
Invalid entities
Grouped Statements
polymorph connection
No database queries were performed.
bddg connection
| Time▼ | Count | Info |
|---|---|---|
|
0.76 ms (24.61%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.71 ms (23.00%) |
1 |
SELECT t0.ID_TERMINAL AS ID_TERMINAL_1, t0.ID_TERMINAL_PARENT AS ID_TERMINAL_PARENT_2, t0.NOM_TERMINAL AS NOM_TERMINAL_3, t0.NOM_BORNE AS NOM_BORNE_4, t0.GPS_TERMINAL AS GPS_TERMINAL_5, t0.IP AS IP_6, t0.ID_TYPE_CONTROL AS ID_TYPE_CONTROL_7, t0.COMMENTAIRE_TERMINAL AS COMMENTAIRE_TERMINAL_8, t0.ETAT_TERMINAL AS ETAT_TERMINAL_9, t0.ID_MODE_PAIEMENT AS ID_MODE_PAIEMENT_10, t0.ID_TYPE_CONTROL AS ID_TYPE_CONTROL_11, t0.ID_TERMINAL_PARENT AS ID_TERMINAL_PARENT_12 FROM BDDG.terminal t0 WHERE t0.ID_TERMINAL = ? LIMIT 1
Parameters:
[
"28"
]
|
|
0.61 ms (19.61%) |
1 |
SELECT t0.ID_TERMINAL AS ID_TERMINAL_1, t0.ID_ERREUR AS ID_ERREUR_2, t0.DATE_REMONTEE AS DATE_REMONTEE_3, t0.VISIBILITE AS VISIBILITE_4 FROM BDDG.terminal_erreur t0 WHERE t0.ID_TERMINAL = ?
Parameters:
[
"28"
]
|
|
0.41 ms (13.34%) |
1 |
SELECT t0.ID_TERMINAL AS ID_TERMINAL_1, t0.ID_ERREUR AS ID_ERREUR_2, t0.DATE_REMONTEE AS DATE_REMONTEE_3, t0.VISIBILITE AS VISIBILITE_4 FROM BDDG.terminal_erreur t0 WHERE t0.ID_TERMINAL = ? AND t0.ID_ERREUR = ?
Parameters:
[ "28" "20" ] |
|
0.37 ms (11.89%) |
1 |
UPDATE BDDG.terminal_erreur SET DATE_REMONTEE = ? WHERE ID_TERMINAL = ? AND ID_ERREUR = ?
Parameters:
[ "2025-04-29 10:32:34" 28 20 ] |
|
0.23 ms (7.55%) |
1 |
"START TRANSACTION"
Parameters:
[] |
isipay connection
No database queries were performed.
Database Connections
| Name | Service |
|---|---|
| polymorph | doctrine.dbal.polymorph_connection |
| bddg | doctrine.dbal.bddg_connection |
| isipay | doctrine.dbal.isipay_connection |
Entity Managers
| Name | Service |
|---|---|
| polymorph | doctrine.orm.polymorph_entity_manager |
| bddg | doctrine.orm.bddg_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
polymorph entity manager
No loaded entities.
bddg entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\BDDG\Terminal | No errors. |
| App\Entity\BDDG\TypeControl | No errors. |
| App\Entity\BDDG\TerminalService | No errors. |
| App\Entity\BDDG\ZoneTerminal | No errors. |
| App\Entity\BDDG\TerminalClient | No errors. |
| App\Entity\BDDG\TerminalErreur | No errors. |