Query Metrics
10
Database Queries
8
Different statements
4.51 ms
Query time
0
Invalid entities
Queries
polymorph connection
No database queries were performed.
bddg connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.67 ms |
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_ISIPAY AS NOM_ISIPAY_4, t0.NOM_BORNE AS NOM_BORNE_5, t0.GPS_TERMINAL AS GPS_TERMINAL_6, t0.IP AS IP_7, t0.ID_TYPE_CONTROL AS ID_TYPE_CONTROL_8, t0.COMMENTAIRE_TERMINAL AS COMMENTAIRE_TERMINAL_9, t0.ETAT_TERMINAL AS ETAT_TERMINAL_10, t0.ID_MODE_PAIEMENT AS ID_MODE_PAIEMENT_11, t0.PRODUCTION AS PRODUCTION_12, t0.ID_TYPE_CONTROL AS ID_TYPE_CONTROL_13, t0.ID_TERMINAL_PARENT AS ID_TERMINAL_PARENT_14 FROM BDDG.terminal t0 WHERE t0.ID_TERMINAL = ? LIMIT 1
Parameters:
[
"1697"
]
|
| 2 | 0.51 ms |
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:
[
"1697"
]
|
| 3 | 0.20 ms |
"START TRANSACTION"
Parameters:
[] |
| 4 | 0.38 ms |
UPDATE BDDG.terminal_erreur SET DATE_REMONTEE = ? WHERE ID_TERMINAL = ? AND ID_ERREUR = ?
Parameters:
[ "2025-12-16 04:33:12" 1697 0 ] |
| 5 | 0.67 ms |
"COMMIT"
Parameters:
[] |
| 6 | 0.34 ms |
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:
[ "1697" "0" ] |
| 7 | 0.41 ms |
SELECT t0.ID_TERMINAL AS ID_TERMINAL_1, t0.ID_COMPOSANT AS ID_COMPOSANT_2, t0.ETAT_ERREUR AS ETAT_ERREUR_3, t0.DATE_REMONTEE AS DATE_REMONTEE_4 FROM BDDG.terminal_composant t0 WHERE t0.ID_TERMINAL = ? AND t0.ID_COMPOSANT = ? LIMIT 1
Parameters:
[ "1697" 0 ] |
| 8 | 0.24 ms |
"START TRANSACTION"
Parameters:
[] |
| 9 | 0.40 ms |
UPDATE BDDG.terminal_composant SET ETAT_ERREUR = ?, DATE_REMONTEE = ? WHERE ID_TERMINAL = ? AND ID_COMPOSANT = ?
Parameters:
[ "0" "2025-12-16 04:33:12" 1697 0 ] |
| 10 | 0.68 ms |
"COMMIT"
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. |
| App\Entity\BDDG\TerminalComposant | No errors. |