GET https://menci-igen.net/revues?page=1

Query Metrics

6 Database Queries
6 Different statements
7.06 ms Query time
0 Invalid entities
31 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.59 ms
(22.51%)
1
SELECT d0_.libelle AS libelle_0 FROM document d0_ INNER JOIN type_document t1_ ON d0_.fk_type_document_id = t1_.id WHERE t1_.slug = ? ORDER BY d0_.created_at DESC LIMIT 3
Parameters:
[
  "flash-informations"
]
1.58 ms
(22.32%)
1
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
]
1.10 ms
(15.52%)
1
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"
]
1.06 ms
(15.02%)
1
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
]
0.97 ms
(13.69%)
1
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.fk_type_document_id = ?
Parameters:
[
  4
]
0.77 ms
(10.94%)
1
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
]

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.