GET https://3.0.oceanexpert.org/documents

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.50 ms
SELECT d0_.doctypename AS doctypename_0, d0_.id_doctype AS id_doctype_1 FROM doctypes d0_ ORDER BY d0_.doctypename ASC
Parameters:
[]
2 1.26 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.98 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 70.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 8.79 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
Parameters:
[]
6 0.76 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:
[
  37673
  37672
  37671
  37670
  37667
  37640
  37638
  37663
  37664
  37662
]

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