https://dev.oceanexpert.org/documents?dir=asc&page=188&sort=d.createdAt

Query Metrics

5 Database Queries
5 Different statements
43.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
18.02 ms
(41.90%)
1
SELECT count(DISTINCT d0_.id_doc) AS sclr_0 FROM documents d0_
Parameters:
[]
11.75 ms
(27.32%)
1
SELECT DISTINCT d0_.id_doc AS id_doc_0, d0_.created_at AS created_at_1 FROM documents d0_ ORDER BY d0_.created_at ASC LIMIT 10 OFFSET 1870
Parameters:
[]
11.00 ms
(25.58%)
1
SELECT d0_.id AS id_0, d0_.id_doclist AS id_doclist_1, d0_.id_doc AS id_doc_2 FROM doclist_documents d0_
Parameters:
[]
1.15 ms
(2.67%)
1
SELECT d0_.id_doclist AS id_doclist_0, d0_.title AS title_1 FROM doclists d0_
Parameters:
[]
1.08 ms
(2.52%)
1
SELECT d0_.id_doc AS id_doc_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM documents d0_ WHERE d0_.id_doc IN (?) ORDER BY d0_.created_at ASC
Parameters:
[
  [
    1995
    1996
    1997
    1998
    1999
    2000
    2001
    2002
    2003
    2004
  ]
]

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
OceanExpertBundle\Entity\Doclists No errors.
OceanExpertBundle\Entity\DoclistDocuments No errors.
OceanExpertBundle\Entity\Documents No errors.