Query Metrics
5
Database Queries
5
Different statements
19.45 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
8.73 ms (44.87%) |
1 |
SELECT t0.id AS id_1, t0.wording AS wording_2, t0.long_wording AS long_wording_3, t0.description AS description_4, t0.duration AS duration_5, t0.color AS color_6, t0.max_student AS max_student_7, t0.price AS price_8, t0.image AS image_9, t0.update_at AS update_at_10, t0.certificat AS certificat_11, t0.attestation AS attestation_12, t0.diplome AS diplome_13, t0.carte AS carte_14, t0.objectif AS objectif_15, t0.wordingdiplome AS wordingdiplome_16, t0.formateur AS formateur_17, t0.longformation AS longformation_18, t0.typeformation AS typeformation_19, t0.demande_id AS demande_id_20 FROM formation t0 INNER JOIN carte_formation ON t0.id = carte_formation.formation_id WHERE carte_formation.carte_id = ?
Parameters:
[
49
]
|
4.25 ms (21.84%) |
1 |
SELECT t0.id AS id_1, t0.pricepersonal AS pricepersonal_2, t0.pricecompany AS pricecompany_3, t0.pricecpf AS pricecpf_4, t0.wording AS wording_5, t0.pricecollectivite AS pricecollectivite_6, t0.libellelibre AS libellelibre_7, t0.typecarte AS typecarte_8, t0.modeapprentissage AS modeapprentissage_9, t0.is_activate AS is_activate_10, t0.heureconduite AS heureconduite_11, t0.duree AS duree_12, t0.thinkific_formation_id AS thinkific_formation_id_13, t0.prerequis AS prerequis_14, t0.site_id AS site_id_15, t0.rattacheaformation_id AS rattacheaformation_id_16, t0.optioncategorie_id AS optioncategorie_id_17 FROM carte t0 WHERE t0.id = ?
Parameters:
[
"49"
]
|
2.62 ms (13.46%) |
1 |
SELECT t0.id AS id_1, t0.dateexamen AS dateexamen_2, t0.lieu AS lieu_3, t0.createdat AS createdat_4, t0.is_archived AS is_archived_5 FROM examen t0 WHERE t0.is_archived = ?
Parameters:
[
0
]
|
2.17 ms (11.17%) |
1 |
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.exam AS exam_4, t0.pricepersonal AS pricepersonal_5, t0.pricecompany AS pricecompany_6, t0.pricecpf AS pricecpf_7, t0.priceexamen AS priceexamen_8, t0.modeapprentissage AS modeapprentissage_9, t0.pricecollectivite AS pricecollectivite_10, t0.status_id AS status_id_11, t0.site_id AS site_id_12, t0.formation_id AS formation_id_13 FROM session t0 WHERE t0.formation_id = ? AND t0.status_id IN (?, ?) AND t0.modeapprentissage = ?
Parameters:
[ 11 1 2 1 ] |
1.68 ms (8.66%) |
1 |
SELECT t0.id AS id_1, t0.wording AS wording_2 FROM option_categorie_inscrit 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\Inscrit | No errors. |
App\Entity\Site | No errors. |
App\Entity\Formation | No errors. |
App\Entity\TypeInscrit | No errors. |
App\Entity\Reglement | No errors. |
App\Entity\Tier | No errors. |
App\Entity\Organisme | No errors. |
App\Entity\StatusInscrit | No errors. |
App\Entity\Carte | No errors. |
App\Entity\OptionCategorieInscrit | No errors. |
App\Entity\Demande | No errors. |
App\Entity\Status | No errors. |
App\Entity\MoyPaiement | No errors. |
App\Entity\CondRegle | No errors. |
App\Entity\SourceFinance | No errors. |
App\Entity\Session | No errors. |
App\Entity\UniteInscription | No errors. |
App\Entity\Examen | No errors. |
App\Entity\Elearning | No errors. |
App\Entity\Entreprise | No errors. |
App\Entity\Message | No errors. |
App\Entity\Task | No errors. |
App\Entity\User | No errors. |
App\Entity\OptionCategorie | No errors. |
App\Entity\JustifForm | No errors. |
App\Entity\Diplome | No errors. |
App\Entity\Formateur | No errors. |