GET https://senbillets.com/cosama

Query Metrics

5 Database Queries
3 Different statements
8.13 ms Query time
0 Invalid entities
23 Managed entities

Queries

Group similar statements

# Time Info
1 2.30 ms
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:
[]
2 3.48 ms
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"
]
3 0.80 ms
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:
[
  "Ziguinchor"
  "programme"
]
4 1.03 ms
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
]
5 0.52 ms
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:
[
  2
]

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