Query Metrics
4
Database Queries
4
Different statements
2.44 ms
Query time
0
Invalid entities
36
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.39 ms (56.98%) |
1 |
SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.nom AS nom_2, l0_.nom_lieu AS nom_lieu_3, l0_.adresse AS adresse_4, l0_.latitude AS latitude_5, l0_.longitude AS longitude_6, l0_.image_base64 AS image_base64_7, l0_.actif AS actif_8, l0_.created_at AS created_at_9, l0_.updated_at AS updated_at_10 FROM lieu_depart l0_ WHERE l0_.actif = ? ORDER BY l0_.nom ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.38 ms (15.40%) |
1 |
SELECT t0_.creneau_id AS sclr_0, COUNT(t0_.id) AS sclr_1 FROM trajet_billet t0_ WHERE t0_.creneau_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY t0_.creneau_id
Parameters:
[ "019c9410-5fbc-759f-9db1-65f6aa52264c" "019c941c-70a2-77df-8469-27f77fedb56a" "019c941c-92fe-7060-b00c-a71bb38d9139" "019c941c-b877-7f3a-af20-6dad27cb1fcd" "019c941c-cd4c-796b-9bfe-54d74ad64651" "019c941c-f43f-7ecd-98f7-a92e45ef1f80" "019c9438-e6f1-7615-9030-38297e353f99" "019c9439-0765-703f-93bb-bb66c8f7bd48" "019c9439-1a62-7ce9-a1c2-1f4b61138601" "019c9439-3263-70eb-be8b-06797d3cdadc" "019c9439-7424-7955-8cd4-00b3b1c009f6" "019c9439-8f6b-7f76-a606-c2beab75400f" "019c9439-b342-78dd-ada7-815e13aa7dfe" "019c9439-d85e-78ec-8182-9899e6f907fe" "019c9439-f114-7582-b9f2-44480833e345" "019c943a-3eb4-757f-a290-8e22aa855968" "019c943a-7507-7846-9e72-b26ac0a20531" "019c943a-b5d4-7bbd-9de3-70e213c27bb1" "019c943a-ce53-708e-bef1-c0ea5f0bf11a" "019c9448-023f-7e25-a2bf-a9ff14b624e8" "019c9448-3fc6-74e2-b938-e688123be218" "019c9448-6147-7685-8418-1af6fbec55cb" "019c9448-9075-709a-8f21-4ae653f89c80" "019c9448-bafd-7e79-8afd-217ea20f1754" "019c9448-d5a0-7585-93e7-84a53beb9b02" "019c9448-f349-73a1-81aa-a6f717315164" "019c9449-0ed6-7c1b-8319-37cd868048a0" "019c944e-72f1-7951-b591-281cc7a87cfa" "019c944e-d8dc-703f-b10a-2a17a33090c9" "019c944e-fd58-7ee2-bd7c-3a1140312ae0" "019c9452-bdff-7136-b9ce-8419d5c75b0c" "019cdd90-c815-7309-9f3a-e6e00d49a302" ]
|
||||||||||||||||||||||||||||||
|
0.35 ms (14.41%) |
1 |
SELECT p0_.id AS id_0, p0_.nom_evenement AS nom_evenement_1, p0_.sous_titre_evenement AS sous_titre_evenement_2, p0_.date_debut_evenement AS date_debut_evenement_3, p0_.date_fin_evenement AS date_fin_evenement_4, p0_.jours_evenement AS jours_evenement_5, p0_.nom_lieu_arrivee AS nom_lieu_arrivee_6, p0_.nom_exact_lieu_arrivee AS nom_exact_lieu_arrivee_7, p0_.adresse_lieu_arrivee AS adresse_lieu_arrivee_8, p0_.latitude_lieu_arrivee AS latitude_lieu_arrivee_9, p0_.longitude_lieu_arrivee AS longitude_lieu_arrivee_10, p0_.introduction_html AS introduction_html_11, p0_.cgv_html AS cgv_html_12, p0_.billetterie_ouverte AS billetterie_ouverte_13, p0_.message_billetterie_fermee AS message_billetterie_fermee_14, p0_.billets_maximum_par_commande AS billets_maximum_par_commande_15, p0_.date_limite_annulation AS date_limite_annulation_16, p0_.prix_aller AS prix_aller_17, p0_.prix_retour AS prix_retour_18, p0_.prix_aller_retour AS prix_aller_retour_19, p0_.montant_empreinte AS montant_empreinte_20, p0_.email_contact AS email_contact_21, p0_.telephone_contact AS telephone_contact_22, p0_.adresse_contact AS adresse_contact_23, p0_.stripe_cle_publique AS stripe_cle_publique_24, p0_.stripe_cle_secrete AS stripe_cle_secrete_25, p0_.stripe_webhook_secret AS stripe_webhook_secret_26, p0_.fuseau_horaire AS fuseau_horaire_27, p0_.created_at AS created_at_28, p0_.updated_at AS updated_at_29 FROM parametrage_billetterie p0_ ORDER BY p0_.created_at ASC LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.32 ms (13.21%) |
1 |
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.date_trajet AS date_trajet_3, t0.heure AS heure_4, t0.capacite_totale AS capacite_totale_5, t0.groupe_mutualise_id AS groupe_mutualise_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.lieu_depart_id AS lieu_depart_id_9 FROM creneau_transport 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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\CreneauTransport | 32 |
| App\Entity\LieuDepart | 3 |
| App\Entity\ParametrageBilletterie | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ParametrageBilletterie | No errors. |
| App\Entity\LieuDepart | No errors. |
| App\Entity\CreneauTransport | No errors. |
| App\Entity\TrajetBillet | No errors. |