Query Metrics
5
Database Queries
5
Different statements
1.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.42 ms (28.91%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.montant AS montant_3, t0.devise AS devise_4, t0.etat_paiement AS etat_paiement_5, t0.inscription_id AS inscription_id_6 FROM facture_candidat t0 WHERE t0.id = ?
Parameters:
[
"261"
]
|
|
0.29 ms (19.79%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.reset_password_token AS reset_password_token_5, t0.civilite AS civilite_6, t0.cin AS cin_7, t0.nom AS nom_8, t0.prenom AS prenom_9, t0.date_naissance AS date_naissance_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.tel AS tel_14, t0.fax AS fax_15, t0.etat_activation AS etat_activation_16, t0.niveau AS niveau_17, t0.specialite AS specialite_18, t0.experience AS experience_19, t0.type AS type_20, t0.diplome AS diplome_21, t0.institution AS institution_22, t0.poste AS poste_23, t0.nationnalite AS nationnalite_24, t0.cv AS cv_25, t0.photo_de_profil AS photo_de_profil_26, t0.updated_at AS updated_at_27, t0.email AS email_28, t0.organization_id AS organization_id_29 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
512
]
|
|
0.28 ms (18.92%) |
1 |
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.date_debut AS date_debut_3, t0.etat AS etat_4 FROM cycle t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.27 ms (18.64%) |
1 |
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.attestation AS attestation_3, t0.groupe AS groupe_4, t0.candidat_id AS candidat_id_5, t0.cycle_id AS cycle_id_6, t0.session_id AS session_id_7 FROM inscription t0 WHERE t0.id = ?
Parameters:
[
253
]
|
|
0.20 ms (13.74%) |
1 |
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.tarif_particulier AS tarif_particulier_3, t0.tarif_entreprise AS tarif_entreprise_4, t0.tarif_etrange AS tarif_etrange_5, t0.etat AS etat_6, t0.exchange_rate AS exchange_rate_7, t0.vat_rate AS vat_rate_8 FROM session t0 WHERE t0.id = ?
Parameters:
[
5
]
|
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\FactureCandidat | No errors. |
| App\Entity\Inscription | No errors. |
| App\Entity\PaiementCandidat | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Cycle | No errors. |
| App\Entity\Session | No errors. |
| App\Entity\InscriptionModule | No errors. |
| App\Entity\Engagement | No errors. |
| App\Entity\Organization | No errors. |
| App\Entity\Certificat | No errors. |
| App\Entity\ServiceUsage | No errors. |
| App\Entity\Module | No errors. |
| App\Entity\FactureFormateur | No errors. |
| App\Entity\Seance | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Formation | No errors. |
| App\Entity\Images | No errors. |
| App\Entity\Evenement | No errors. |
| App\Billing\Entity\Installment | No errors. |
| App\Billing\Entity\Invoice | No errors. |
| App\Billing\Entity\PaymentSchedule | No errors. |
| App\Billing\Entity\InvoiceLine | No errors. |
| App\Billing\Entity\Payment | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |