Query Metrics
44
Database Queries
3
Different statements
389.20 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
328.44 ms (84.39%) |
30 |
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:
[
1
]
|
55.39 ms (14.23%) |
12 |
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.site_id = ? AND t0.optioncategorie_id = ? AND t0.is_activate = ? ORDER BY t0.wording ASC
Parameters:
[ 2 4 1 ] |
5.37 ms (1.38%) |
2 |
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.site_id IN (?) AND t0.optioncategorie_id = ? AND t0.is_activate = ? ORDER BY t0.id ASC
Parameters:
[ 3 14 1 ] |
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\Carte | No errors. |
App\Entity\Site | No errors. |
App\Entity\Formation | No errors. |
App\Entity\OptionCategorie | No errors. |
App\Entity\UniteInscription | No errors. |
App\Entity\Demande | No errors. |
App\Entity\Session | No errors. |
App\Entity\JustifForm | No errors. |
App\Entity\Message | No errors. |
App\Entity\Task | No errors. |
App\Entity\User | No errors. |