GET https://3.0.oceanexpert.org/index.php/documents?dir=desc&page=4

Query Metrics

6 Database Queries
6 Different statements
170.57 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 0.65 ms
SELECT d0_.doctypename AS doctypename_0, d0_.id_doctype AS id_doctype_1 FROM doctypes d0_ ORDER BY d0_.doctypename ASC
Parameters:
[]
2 0.74 ms
SELECT d0_.id_doclist AS id_doclist_0, d0_.title AS title_1 FROM doclists d0_ ORDER BY d0_.title ASC
Parameters:
[]
3 4.16 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:
[]
4 152.92 ms
SELECT count(DISTINCT d0_.id_doc) AS sclr_0 FROM documents d0_ LEFT JOIN doctypes d1_ ON (d0_.id_doctype = d1_.id_doctype)
Parameters:
[]
5 11.23 ms
SELECT DISTINCT d0_.id_doc AS id_doc_0, d0_.created_at AS created_at_1 FROM documents d0_ LEFT JOIN doctypes d1_ ON (d0_.id_doctype = d1_.id_doctype) ORDER BY d0_.created_at DESC LIMIT 10 OFFSET 30
Parameters:
[]
6 0.87 ms
SELECT d0_.id_doc AS id_doc_0, d0_.title AS title_1, d0_.created_at AS created_at_2, d1_.doctypename AS doctypename_3 FROM documents d0_ LEFT JOIN doctypes d1_ ON (d0_.id_doctype = d1_.id_doctype) WHERE d0_.id_doc IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.created_at DESC
Parameters:
[
  37644
  37643
  37642
  37641
  7682
  17716
  37639
  37637
  37636
  37635
]

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
OceanExpertBundle\Entity\Doctypes 10