GET https://relaxtransfert.com/en

Query Metrics

20 Database Queries
13 Different statements
4.78 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 0.76 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.37 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.22 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.15 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.19 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.24 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.68 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:
[]
9 0.33 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nomen AS nomen_3, t0.tarif AS tarif_4, t0.nbreplaces AS nbreplaces_5, t0.image_name AS image_name_6, t0.image_size AS image_size_7, t0.updated_at AS updated_at_8, t0.description AS description_9, t0.contenu AS contenu_10, t0.nbrebagages AS nbrebagages_11, t0.suv AS suv_12, t0.berline AS berline_13, t0.minibus AS minibus_14, t0.bus AS bus_15, t0.tarifkm AS tarifkm_16 FROM typevoiture t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.17 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 0.16 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nomen AS nomen_3 FROM fuel t0 WHERE t0.id = ?
Parameters:
[
  3
]
12 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nomen AS nomen_3 FROM transmission t0 WHERE t0.id = ?
Parameters:
[
  1
]
13 0.13 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  3
]
14 0.12 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nomen AS nomen_3 FROM fuel t0 WHERE t0.id = ?
Parameters:
[
  2
]
15 0.15 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nomen AS nomen_3 FROM fuel t0 WHERE t0.id = ?
Parameters:
[
  1
]
16 0.17 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nomen AS nomen_3 FROM transmission t0 WHERE t0.id = ?
Parameters:
[
  3
]
17 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  2
]
18 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  6
]
19 0.12 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM marque t0 WHERE t0.id = ?
Parameters:
[
  7
]
20 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.contenu AS contenu_4, t0.nomen AS nomen_5, t0.contenuen AS contenuen_6 FROM PAGE t0
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
  • The association App\Entity\Ville#itinerairesdestination refers to the owning side field App\Entity\Itineraire#destination which is not defined as association, but as field.
  • The association App\Entity\Ville#itinerairesdestination refers to the owning side field App\Entity\Itineraire#destination which does not exist.
App\Entity\User No errors.
App\Entity\Voiture No errors.
App\Entity\Reservation No errors.
App\Entity\Modepaiement No errors.
App\Entity\Rating
  • The mappings App\Entity\Rating#user and App\Entity\User#ratings are inconsistent with each other.
App\Entity\Departement
  • The association App\Entity\Departement#clients refers to the owning side field App\Entity\Client#departement which does not exist.
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.
App\Entity\Messagechat
  • The mappings App\Entity\Messagechat#receiver and App\Entity\User#messagechats are inconsistent with each other.
App\Entity\Option No errors.
App\Entity\Compagnie No errors.
App\Entity\Typetransfert No errors.
App\Entity\Entreprise No errors.
App\Entity\Annonce No errors.
App\Entity\Transaction No errors.
App\Entity\Typeannonce No errors.
App\Entity\Typeprix No errors.
App\Entity\Paramtransfert No errors.
App\Entity\Email No errors.
App\Entity\Chauffeur No errors.
App\Entity\Assistant No errors.
App\Entity\Raison No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\Page No errors.
App\Entity\NewsletterEmail No errors.
App\Entity\Invitation
  • The association App\Entity\Invitation#sender refers to the inverse side field App\Entity\User#invitations which does not exist.
App\Entity\Appareils No errors.
App\Entity\Paramlocation No errors.
App\Entity\Notification No errors.
App\Entity\Newsletter No errors.
App\Entity\Annulation No errors.
App\Entity\City No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\Paramtransfertprive No errors.
App\Entity\Message No errors.
Vich\UploaderBundle\Entity\File No errors.