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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.18 ms
SELECT d0_.id_doclist AS id_doclist_0, d0_.title AS title_1 FROM doclists d0_
Parameters:
[]
2 12.49 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 17.53 ms
SELECT count(DISTINCT d0_.id_doc) AS sclr_0 FROM documents d0_
Parameters:
[]
4 11.65 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 33350
Parameters:
[]
5 1.58 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:
0 of 0
[ [ 2499 2498 2497 2496 2495 2494 2493 2492 2491 2490 ] ]

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.