GET https://www.metfp.gov.mg/formation/ressource

Query Metrics

6 Database Queries
5 Different statements
2.44 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 0.64 ms
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM document_media d0_ INNER JOIN type_document t1_ ON d0_.type_id = t1_.id WHERE t1_.type IN (?, ?)
Parameters:
[
  "Référentiels"
  "Ressources pédagogiques"
]
2 0.36 ms
SELECT DISTINCT d0_.id AS id_0, d0_.date AS date_1 FROM document_media d0_ INNER JOIN type_document t1_ ON d0_.type_id = t1_.id WHERE t1_.type IN (?, ?) ORDER BY d0_.date DESC LIMIT 9
Parameters:
[
  "Référentiels"
  "Ressources pédagogiques"
]
3 0.83 ms
SELECT d0_.id AS id_0, d0_.titre AS titre_1, d0_.description AS description_2, d0_.date AS date_3, d0_.nbtelechargement AS nbtelechargement_4, d0_.photo AS photo_5, d0_.fichier AS fichier_6, d0_.updated_at AS updated_at_7, d0_.tags AS tags_8, d0_.type_id AS type_id_9 FROM document_media d0_ INNER JOIN type_document t1_ ON d0_.type_id = t1_.id WHERE t1_.type IN (?, ?) AND d0_.id IN (?, ?) ORDER BY d0_.date DESC
Parameters:
[
  "Référentiels"
  "Ressources pédagogiques"
  15
  13
]
4 0.25 ms
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.type AS type_3 FROM type_document t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.21 ms
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.type AS type_3 FROM type_document t0 WHERE t0.id = ?
Parameters:
[
  2
]
6 0.16 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date AS date_4, t0.nbtelechargement AS nbtelechargement_5, t0.photo AS photo_6, t0.fichier AS fichier_7, t0.updated_at AS updated_at_8, t0.tags AS tags_9, t0.type_id AS type_id_10 FROM document_media t0 ORDER BY t0.nbtelechargement DESC LIMIT 3
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\DocumentMedia 2
App\Entity\TypeDocument 2

Entities Mapping

Class Mapping errors
App\Entity\DocumentMedia No errors.
App\Entity\TypeDocument No errors.