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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.61 ms
SELECT d0_.id_doclist AS id_doclist_0, d0_.title AS title_1 FROM doclists d0_
Parameters:
[]
2 25.26 ms
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:
[]
3 23.27 ms
SELECT count(DISTINCT d0_.id_doc) AS sclr_0 FROM documents d0_
Parameters:
[]
4 17.42 ms
SELECT DISTINCT d0_.id_doc AS id_doc_0, d0_.created_at AS created_at_1 FROM documents d0_ ORDER BY d0_.created_at DESC LIMIT 10 OFFSET 960
Parameters:
[]
5 1.57 ms
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 DESC
Parameters:
[
  [
    36139
    36145
    36143
    36142
    36141
    36138
    36137
    36136
    36135
    36134
  ]
]

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.