Query Metrics
6
Database Queries
6
Different statements
86.13 ms
Query time
0
Invalid entities
10
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.66 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.90 ms |
SELECT d0_.id_doclist AS id_doclist_0, d0_.title AS title_1 FROM doclists d0_ ORDER BY d0_.title ASC
Parameters:
[] |
| 3 | 7.41 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 | 52.42 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 | 19.00 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 36490
Parameters:
[] |
| 6 | 4.74 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:
[ 47 46 45 44 43 42 41 34 37 32 ] |
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 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| OceanExpertBundle\Entity\Doctypes | No errors. |
| OceanExpertBundle\Entity\Doclists | No errors. |
| OceanExpertBundle\Entity\DoclistDocuments | No errors. |
| OceanExpertBundle\Entity\Documents | No errors. |