Query Metrics
5
Database Queries
5
Different statements
43.00 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
18.02 ms (41.90%) |
1 |
SELECT count(DISTINCT d0_.id_doc) AS sclr_0 FROM documents d0_
Parameters:
[] |
11.75 ms (27.32%) |
1 |
SELECT DISTINCT d0_.id_doc AS id_doc_0, d0_.created_at AS created_at_1 FROM documents d0_ ORDER BY d0_.created_at ASC LIMIT 10 OFFSET 1870
Parameters:
[] |
11.00 ms (25.58%) |
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:
[] |
1.15 ms (2.67%) |
1 |
SELECT d0_.id_doclist AS id_doclist_0, d0_.title AS title_1 FROM doclists d0_
Parameters:
[] |
1.08 ms (2.52%) |
1 |
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 ASC
Parameters:
[ [ 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 ] ] |
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. |