https://formation.ecole-chauffeur-prive.fr/api/carte

Query Metrics

44 Database Queries
3 Different statements
60.30 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
37.69 ms
(62.51%)
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
]
21.31 ms
(35.33%)
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
]
1.30 ms
(2.16%)
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.