Query Metrics
6
Database Queries
6
Different statements
87.21 ms
Query time
0
Invalid entities
10
Managed entities
Queries
| #▲ | 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 |
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. |