GET https://lingevres.ddns.net/lingevres/facture/getListFacture/12/2

Query Metrics

32 Database Queries
6 Different statements
5.67 ms Query time
7 Invalid entities

Queries

Group similar statements

# Time Info
1 0.34 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.initiales AS initiales_7, t0.matricule AS matricule_8, t0.actif AS actif_9, t0.carte_clef_rendu AS carte_clef_rendu_10, t0.rappel_sms AS rappel_sms_11, t0.telephone AS telephone_12, t0.telephone_pro AS telephone_pro_13, t0.ville_id AS ville_id_14, t0.ville_attache_id AS ville_attache_id_15, t0.systeme_client_id AS systeme_client_id_16 FROM user t0 WHERE t0.id = ?
Parameters:
[
  14
]
2 0.40 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.prenom AS prenom_4, u0_.nom AS nom_5, u0_.initiales AS initiales_6, u0_.matricule AS matricule_7, u0_.actif AS actif_8, u0_.carte_clef_rendu AS carte_clef_rendu_9, u0_.rappel_sms AS rappel_sms_10, u0_.telephone AS telephone_11, u0_.telephone_pro AS telephone_pro_12, u0_.ville_id AS ville_id_13, u0_.ville_attache_id AS ville_attache_id_14, u0_.systeme_client_id AS systeme_client_id_15 FROM user u0_ WHERE u0_.roles LIKE ? AND u0_.systeme_client_id = ? AND u0_.actif = 1 ORDER BY u0_.prenom ASC
Parameters:
[
  "%ROLE_CHAUFFEUR%"
  1
]
3 0.54 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.date AS date_3, t0.text AS text_4, t0.valide AS valide_5, t0.vidange AS vidange_6, t0.filtre_huile AS filtre_huile_7, t0.filtre_air AS filtre_air_8, t0.filtre_go AS filtre_go_9, t0.courroie AS courroie_10, t0.prix AS prix_11, t0.heure_moteur AS heure_moteur_12, t0.created_at AS created_at_13, t0.sinistre AS sinistre_14, t0.camion_id AS camion_id_15, t0.remorque_id AS remorque_id_16, t0.divers_id AS divers_id_17 FROM facture t0 WHERE t0.valide = ?
Parameters:
[
  0
]
4 0.19 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.actif AS actif_3, t0.numero AS numero_4, t0.marque AS marque_5, t0.genre AS genre_6, t0.cat AS cat_7, t0.reference_moteur AS reference_moteur_8, t0.date_immat AS date_immat_9, t0.duree_entretien AS duree_entretien_10, t0.nbr_essieux AS nbr_essieux_11, t0.fin_contrat_constructeur AS fin_contrat_constructeur_12, t0.systeme_client_id AS systeme_client_id_13, t0.constructeur_id AS constructeur_id_14 FROM remorque t0 WHERE t0.id = ?
Parameters:
[
  "12"
]
5 0.41 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.date AS date_3, t0.text AS text_4, t0.valide AS valide_5, t0.vidange AS vidange_6, t0.filtre_huile AS filtre_huile_7, t0.filtre_air AS filtre_air_8, t0.filtre_go AS filtre_go_9, t0.courroie AS courroie_10, t0.prix AS prix_11, t0.heure_moteur AS heure_moteur_12, t0.created_at AS created_at_13, t0.sinistre AS sinistre_14, t0.camion_id AS camion_id_15, t0.remorque_id AS remorque_id_16, t0.divers_id AS divers_id_17 FROM facture t0 WHERE t0.remorque_id = ? ORDER BY t0.date DESC
Parameters:
[
  12
]
6 0.19 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  1105
]
7 0.16 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  1178
]
8 0.18 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  1120
]
9 0.17 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  1072
]
10 0.16 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  1022
]
11 0.15 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  1014
]
12 0.14 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  1193
]
13 0.15 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  770
]
14 0.15 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  769
]
15 0.15 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  843
]
16 0.12 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  1148
]
17 0.11 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  642
]
18 0.15 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  920
]
19 0.12 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  468
]
20 0.12 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  412
]
21 0.12 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  317
]
22 0.15 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  548
]
23 0.12 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  316
]
24 0.12 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  258
]
25 0.15 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  106
]
26 0.13 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  79
]
27 0.16 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  170
]
28 0.13 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  44
]
29 0.12 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  75
]
30 0.12 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  74
]
31 0.12 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  72
]
32 0.12 ms
SELECT t0.id AS id_1, t0.name_file AS name_file_2, t0.facture_id AS facture_id_3 FROM facture_document t0 WHERE t0.facture_id = ?
Parameters:
[
  73
]

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\User
  • The association App\Entity\User#camions refers to the owning side field App\Entity\Camion#user which does not exist.
  • The association App\Entity\User#cartePaiements refers to the owning side field App\Entity\CartePaiement#user which does not exist.
App\Entity\VilleFrance No errors.
App\Entity\SystemeClient
  • The association App\Entity\SystemeClient#maintenanceTypes refers to the owning side field App\Entity\MaintenanceType#SystemeClient which does not exist.
App\Entity\Camion
  • The association App\Entity\Camion#cartePaiements refers to the owning side field App\Entity\CartePaiement#camion which does not exist.
  • The association App\Entity\Camion#maintenances refers to the owning side field App\Entity\Maintenance#Camion which does not exist.
  • The association App\Entity\Camion#constructeur refers to the inverse side field App\Entity\Constructeur#constructeur which does not exist.
App\Entity\CamionUser No errors.
App\Entity\Documentation No errors.
App\Entity\CartePaiement No errors.
App\Entity\Absence No errors.
App\Entity\PlanningReccurence No errors.
App\Entity\InfoChauffeur No errors.
App\Entity\InfoChauffeurDate No errors.
App\Entity\PlanningUpdateDateTime No errors.
App\Entity\HoraireExploit No errors.
App\Entity\Facture
  • The mappings App\Entity\Facture#remorque and App\Entity\Remorque#factures are inconsistent with each other.
App\Entity\Remorque
  • The association App\Entity\Remorque#factures refers to the owning side field App\Entity\Facture#Remorque which does not exist.
  • The association App\Entity\Remorque#constructeur refers to the inverse side field App\Entity\Constructeur#constructeur which does not exist.
App\Entity\Divers No errors.
App\Entity\Constructeur
  • The mappings App\Entity\Constructeur#camions and App\Entity\Camion#constructeur are inconsistent with each other.
App\Entity\Maintenance
  • The mappings App\Entity\Maintenance#camion and App\Entity\Camion#maintenances are inconsistent with each other.
App\Entity\PlanningRemorque No errors.
App\Entity\PneuVehicule No errors.
App\Entity\FactureDocument No errors.