Query Metrics
5
Database Queries
3
Different statements
8.13 ms
Query time
0
Invalid entities
23
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.28 ms (52.63%) |
2 |
SELECT c0_.id AS id_0, c0_.date_depart AS date_depart_1, c0_.heure_depart AS heure_depart_2, c0_.heure_arrivee AS heure_arrivee_3, c0_.places_disponibles AS places_disponibles_4, c0_.capacite_max AS capacite_max_5, c0_.statut AS statut_6, c0_.liaison_id AS liaison_id_7, c0_.bateau_id AS bateau_id_8 FROM cosama_traversees c0_ INNER JOIN cosama_liaisons c1_ ON c0_.liaison_id = c1_.id INNER JOIN cosama_ports c2_ ON c1_.port_depart_id = c2_.id WHERE c2_.ville = ? AND c0_.statut = ?
Parameters:
[ "Dakar" "programme" ] |
|
2.30 ms (28.24%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.pays AS pays_4, t0.adresse AS adresse_5 FROM cosama_ports t0
Parameters:
[] |
|
1.56 ms (19.13%) |
2 |
SELECT t0.id AS id_1, t0.prix_economique AS prix_economique_2, t0.prix_vip AS prix_vip_3, t0.duree_estimee AS duree_estimee_4, t0.compagnie_id AS compagnie_id_5, t0.port_depart_id AS port_depart_id_6, t0.port_arrivee_id AS port_arrivee_id_7 FROM cosama_liaisons t0 WHERE t0.id = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\CosamaTraversee | 14 |
| App\Entity\CosamaPort | 4 |
| App\Entity\CosamaLiaison | 2 |
| App\Entity\CosamamBateau | 2 |
| App\Entity\CosamaCompagnie | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\CosamaPort | No errors. |
| App\Entity\CosamaTraversee | No errors. |
| App\Entity\CosamaLiaison | No errors. |
| App\Entity\CosamamBateau | No errors. |
| App\Entity\CosamaReservation | No errors. |
| App\Entity\CosamaCompagnie | No errors. |