GET https://www.recette-app.animal-care-madagascar.com/admin/prestation/3ebb123b37abfe3142ab5da29e041e6e/detail

Query Metrics

9 Database Queries
9 Different statements
6.56 ms Query time
0 Invalid entities
23 Managed entities

Queries

Group similar statements

# Time Info
1 0.20 ms
SELECT t0.right_name AS right_name_1, t0.right_code AS right_code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM rights t0 WHERE t0.right_code = ? LIMIT 1
Parameters:
[
  "admin_prestation_show"
]
2 0.22 ms
SELECT t0.rendez_vous_id AS rendez_vous_id_1, t0.service_propose_id AS service_propose_id_2, t0.date_realisation AS date_realisation_3, t0.cout_total AS cout_total_4, t0.statut AS statut_5, t0.id AS id_6 FROM prestation t0 WHERE t0.id = ?
Parameters:
[
  "3ebb123b37abfe3142ab5da29e041e6e"
]
3 3.58 ms
SELECT t0.client_id AS client_id_1, t0.animal_id AS animal_id_2, t0.prestataire_id AS prestataire_id_3, t0.service_propose_id AS service_propose_id_4, t0.date_rdv AS date_rdv_5, t0.statut AS statut_6, t0.commentaires AS commentaires_7, t0.id AS id_8, t0.heure_debut AS heure_debut_9, t0.heure_fin AS heure_fin_10, t0.duree_minutes AS duree_minutes_11 FROM rendez_vous t0 WHERE t0.id = ?
Parameters:
[
  "49bbdc6a968f8b42e8c3b3b7b0699761"
]
4 1.26 ms
SELECT t0.prestataire_id AS prestataire_id_1, t0.service_id AS service_id_2, t0.actif AS actif_3, t0.description AS description_4, t0.id AS id_5 FROM service_propose t0 WHERE t0.id = ?
Parameters:
[
  "b2659f6b5cd07fd025d7a065f0d7d4cd"
]
5 0.30 ms
SELECT t0.nom AS nom_1, t0.code AS code_2, t0.description AS description_3, t0.duree_default_minutes AS duree_default_minutes_4, t0.necessite_acompte_default AS necessite_acompte_default_5, t0.actif AS actif_6, t0.id AS id_7, t0.montant AS montant_8, t0.devise AS devise_9, t0.date_application AS date_application_10, t0.categorie_id AS categorie_id_11 FROM service t0 WHERE t0.id = ?
Parameters:
[
  "a5f85aed3f53df690c9de50789e58dca"
]
6 0.27 ms
SELECT t0.nom AS nom_1, t0.prenom AS prenom_2, t0.email AS email_3, t0.telephone AS telephone_4, t0.ville AS ville_5, t0.id AS id_6 FROM client t0 WHERE t0.id = ?
Parameters:
[
  "e328141444215e88cd83203fa9498252"
]
7 0.23 ms
SELECT t0.nom AS nom_1, t0.espece AS espece_2, t0.race AS race_3, t0.date_naissance AS date_naissance_4, t0.proprietaire_id AS proprietaire_id_5, t0.poids AS poids_6, t0.id AS id_7 FROM animal t0 WHERE t0.id = ?
Parameters:
[
  "b7943130033ef8407c82f43d619ea37d"
]
8 0.23 ms
SELECT t0.nom AS nom_1, t0.type_champ AS type_champ_2, t0.description AS description_3, t0.obligatoire_global AS obligatoire_global_4, t0.id AS id_5 FROM service_champ t0
Parameters:
[]
9 0.27 ms
SELECT t0.valeur AS valeur_1, t0.type_valeur AS type_valeur_2, t0.document_id AS document_id_3, t0.service_champ_id AS service_champ_id_4, t0.prestation_id AS prestation_id_5 FROM prestation_valeur_champ t0 WHERE t0.prestation_id = ?
Parameters:
[
  "3ebb123b37abfe3142ab5da29e041e6e"
]

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
Domain\Service\Entity\ServiceChamp 16
Domain\Prestation\Entity\Prestation 1
Domain\RendezVous\Entity\RendezVous 1
Domain\Prestataire\Entity\ServicePropose 1
Domain\Service\Entity\Service 1
Domain\Service\Entity\ServiceCategorie 1
Domain\Client\Entity\Client 1
Domain\Animal\Entity\Animal 1