Query Metrics
8
Database Queries
8
Different statements
2.83 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.88 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nomen AS nomen_3, t0.aeroport AS aeroport_4, t0.latitudedepart AS latitudedepart_5, t0.longitudedepart AS longitudedepart_6, t0.latitudedestination AS latitudedestination_7, t0.longitudedestination AS longitudedestination_8, t0.tarif AS tarif_9, t0.heuredepart AS heuredepart_10, t0.ligne AS ligne_11, t0.actif AS actif_12, t0.date AS date_13, t0.pickup AS pickup_14, t0.slug AS slug_15, t0.places AS places_16, t0.allerretour AS allerretour_17, t0.datedepart AS datedepart_18, t0.statut AS statut_19, t0.placesdispo AS placesdispo_20, t0.go AS go_21, t0.relax AS relax_22, t0.infos AS infos_23, t0.origine AS origine_24, t0.destination AS destination_25, t0.termine AS termine_26, t0.annule AS annule_27, t0.taxe AS taxe_28, t0.raison AS raison_29, t0.distance AS distance_30, t0.duration AS duration_31, t0.localiteorigine AS localiteorigine_32, t0.localitedestination AS localitedestination_33, t0.regionorigine AS regionorigine_34, t0.regiondestination AS regiondestination_35, t0.top AS top_36, t0.versaibd AS versaibd_37, t0.typevoiture_id AS typevoiture_id_38, t0.lieudepart_id AS lieudepart_id_39, t0.chauffeur_id AS chauffeur_id_40, t0.user_id AS user_id_41, t0.voiture_id AS voiture_id_42 FROM itineraire t0 WHERE t0.aeroport = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||
2 | 0.45 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nomen AS nomen_3, t0.aeroport AS aeroport_4, t0.latitudedepart AS latitudedepart_5, t0.longitudedepart AS longitudedepart_6, t0.latitudedestination AS latitudedestination_7, t0.longitudedestination AS longitudedestination_8, t0.tarif AS tarif_9, t0.heuredepart AS heuredepart_10, t0.ligne AS ligne_11, t0.actif AS actif_12, t0.date AS date_13, t0.pickup AS pickup_14, t0.slug AS slug_15, t0.places AS places_16, t0.allerretour AS allerretour_17, t0.datedepart AS datedepart_18, t0.statut AS statut_19, t0.placesdispo AS placesdispo_20, t0.go AS go_21, t0.relax AS relax_22, t0.infos AS infos_23, t0.origine AS origine_24, t0.destination AS destination_25, t0.termine AS termine_26, t0.annule AS annule_27, t0.taxe AS taxe_28, t0.raison AS raison_29, t0.distance AS distance_30, t0.duration AS duration_31, t0.localiteorigine AS localiteorigine_32, t0.localitedestination AS localitedestination_33, t0.regionorigine AS regionorigine_34, t0.regiondestination AS regiondestination_35, t0.top AS top_36, t0.versaibd AS versaibd_37, t0.typevoiture_id AS typevoiture_id_38, t0.lieudepart_id AS lieudepart_id_39, t0.chauffeur_id AS chauffeur_id_40, t0.user_id AS user_id_41, t0.voiture_id AS voiture_id_42 FROM itineraire t0 WHERE t0.ligne = ? ORDER BY t0.datedepart ASC LIMIT 10
Parameters:
[
1
]
|
||||||||||||||||||||||||
3 | 0.24 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.tarif4x4 AS tarif4x4_3, t0.tarifberline AS tarifberline_4, t0.tarifbus AS tarifbus_5, t0.tarifminibus AS tarifminibus_6, t0.region_id AS region_id_7 FROM departement t0
Parameters:
[]
|
||||||||||||||||||||||||
4 | 0.23 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.nomen AS nomen_4, t0.descriptionen AS descriptionen_5 FROM service t0
Parameters:
[]
|
||||||||||||||||||||||||
5 | 0.21 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.nomen AS nomen_4, t0.descriptionen AS descriptionen_5 FROM bloc t0
Parameters:
[]
|
||||||||||||||||||||||||
6 | 0.26 ms |
SELECT t0.id AS id_1, t0.texttop AS texttop_2, t0.titre2 AS titre2_3, t0.titreflotte AS titreflotte_4, t0.descriptionflotte AS descriptionflotte_5, t0.textadresse AS textadresse_6, t0.textnbrepassager AS textnbrepassager_7, t0.textnbrebagage AS textnbrebagage_8, t0.textbouton AS textbouton_9, t0.description2 AS description2_10, t0.texttopen AS texttopen_11, t0.titre2en AS titre2en_12, t0.titreflotteen AS titreflotteen_13, t0.descriptionflotteen AS descriptionflotteen_14, t0.textadresseen AS textadresseen_15, t0.textnbrepassageren AS textnbrepassageren_16, t0.textnbrebagageen AS textnbrebagageen_17, t0.textboutonen AS textboutonen_18, t0.description2en AS description2en_19, t0.titre AS titre_20, t0.titreen AS titreen_21, t0.image_name AS image_name_22, t0.image_size AS image_size_23, t0.updated_at AS updated_at_24 FROM paramaccueil t0 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||
7 | 0.29 ms |
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.nbrepassagers AS nbrepassagers_3, t0.nbrebagages AS nbrebagages_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.updated_at AS updated_at_7, t0.annee AS annee_8, t0.location AS location_9, t0.tarifheure AS tarifheure_10, t0.tarifjour AS tarifjour_11, t0.tarifmois AS tarifmois_12, t0.nom AS nom_13, t0.sieges AS sieges_14, t0.portes AS portes_15, t0.description AS description_16, t0.slug AS slug_17, t0.nomen AS nomen_18, t0.descriptionen AS descriptionen_19, t0.latitude AS latitude_20, t0.longitude AS longitude_21, t0.isaccepted AS isaccepted_22, t0.plaque AS plaque_23, t0.couleur AS couleur_24, t0.mark AS mark_25, t0.relax AS relax_26, t0.taxi AS taxi_27, t0.typevoiture_id AS typevoiture_id_28, t0.marque_id AS marque_id_29, t0.transmission_id AS transmission_id_30, t0.fuel_id AS fuel_id_31, t0.user_id AS user_id_32 FROM voiture t0 LIMIT 6
Parameters:
[]
|
||||||||||||||||||||||||
8 | 0.27 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.description AS description_4, t0.copyright AS copyright_5, t0.telephone1 AS telephone1_6, t0.telephone2 AS telephone2_7, t0.email AS email_8, t0.descriptionen AS descriptionen_9, t0.expopushtoken AS expopushtoken_10, t0.conditionschauffeur AS conditionschauffeur_11, t0.codepromo AS codepromo_12, t0.taux AS taux_13, t0.codepromoclient AS codepromoclient_14, t0.covoiturage AS covoiturage_15, t0.taxe AS taxe_16, t0.infos AS infos_17 FROM param t0 LIMIT 1
Parameters:
[] |
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Itineraire | No errors. |
App\Entity\Typevoiture | No errors. |
App\Entity\Ville |
|
App\Entity\User | No errors. |
App\Entity\Voiture | No errors. |
App\Entity\Reservation | No errors. |
App\Entity\Modepaiement | No errors. |
App\Entity\Rating |
|
App\Entity\Departement |
|
App\Entity\Region | No errors. |
App\Entity\Client | No errors. |
App\Entity\Service | No errors. |
App\Entity\Bloc | No errors. |
App\Entity\Paramaccueil | No errors. |
App\Entity\Marque | No errors. |
App\Entity\Transmission | No errors. |
App\Entity\Fuel | No errors. |
App\Entity\Equipement | No errors. |
App\Entity\Photovoiture | No errors. |
App\Entity\Location | No errors. |
App\Entity\Commodite | No errors. |
App\Entity\Param | No errors. |