GET https://menci-igen.net/revues

Query Metrics

5 Database Queries
5 Different statements
4.28 ms Query time
0 Invalid entities
31 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.73 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.libelle AS libelle_3 FROM type_document t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "revues-de-presse"
]
2 0.73 ms
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.fk_type_document_id = ?
Parameters:
[
  4
]
3 0.89 ms
SELECT DISTINCT d0_.id AS id_0, d0_.created_at AS created_at_1, d0_.id AS id_2 FROM document d0_ WHERE d0_.fk_type_document_id = ? ORDER BY d0_.created_at DESC, d0_.id DESC LIMIT 15
Parameters:
[
  4
]
4 0.76 ms
SELECT d0_.id AS id_0, d0_.description AS description_1, d0_.created_at AS created_at_2, d0_.user AS user_3, d0_.libelle AS libelle_4, d0_.fk_type_document_id AS fk_type_document_id_5 FROM document d0_ WHERE d0_.fk_type_document_id = ? AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.created_at DESC, d0_.id DESC
Parameters:
[
  4
  52
  51
  49
  47
  46
  43
  42
  40
  39
  37
  36
  35
  34
  32
  31
]
5 1.17 ms
SELECT d0_.id AS id_0, f1_.id AS id_1, f1_.libelle AS libelle_2, f1_.updated_at AS updated_at_3, d0_.fk_type_document_id AS fk_type_document_id_4, f1_.fk_document_id AS fk_document_id_5 FROM document d0_ LEFT JOIN fichier f1_ ON d0_.id = f1_.fk_document_id WHERE d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f1_.id ASC
Parameters:
[
  52
  51
  49
  47
  46
  43
  42
  40
  39
  37
  36
  35
  34
  32
  31
]

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\Document 15
App\Entity\Fichier 15
App\Entity\TypeDocument 1

Entities Mapping

Class Mapping errors
App\Entity\TypeDocument No errors.
App\Entity\Document No errors.
App\Entity\Fichier No errors.