GET http://193.191.134.99/documents?dir=desc&page=5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
9.44 ms
(45.36%)
1
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 40
Parameters:
[]
6.02 ms
(28.92%)
1
SELECT count(DISTINCT d0_.id_doc) AS sclr_0 FROM documents d0_ LEFT JOIN doctypes d1_ ON (d0_.id_doctype = d1_.id_doctype)
Parameters:
[]
3.53 ms
(16.97%)
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:
[]
0.72 ms
(3.47%)
1
SELECT d0_.id_doclist AS id_doclist_0, d0_.title AS title_1 FROM doclists d0_ ORDER BY d0_.title ASC
Parameters:
[]
0.66 ms
(3.15%)
1
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:
[
  37631
  37630
  37629
  37628
  37627
  37626
  37625
  37624
  37622
  37623
]
0.44 ms
(2.13%)
1
SELECT d0_.doctypename AS doctypename_0, d0_.id_doctype AS id_doctype_1 FROM doctypes d0_ ORDER BY d0_.doctypename ASC
Parameters:
[]

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