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

Query Metrics

6 Database Queries
6 Different statements
5.26 ms Query time
0 Invalid entities
7 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.14 ms
(21.67%)
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:
[
  33
  18
  1
]
1.07 ms
(20.44%)
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:
[
  7
  33
  18
  1
]
0.98 ms
(18.70%)
1
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.fk_type_document_id = ?
Parameters:
[
  7
]
0.81 ms
(15.34%)
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"
]
0.73 ms
(13.92%)
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:
[
  "autres-documents"
]
0.52 ms
(9.93%)
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 9
Parameters:
[
  7
]

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

Entities Mapping

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