Query Metrics
6
Database Queries
6
Different statements
20.82 ms
Query time
0
Invalid entities
10
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.44 ms |
SELECT d0_.doctypename AS doctypename_0, d0_.id_doctype AS id_doctype_1 FROM doctypes d0_ ORDER BY d0_.doctypename ASC
Parameters:
[] |
| 2 | 0.72 ms |
SELECT d0_.id_doclist AS id_doclist_0, d0_.title AS title_1 FROM doclists d0_ ORDER BY d0_.title ASC
Parameters:
[] |
| 3 | 3.53 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 | 6.02 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 | 9.44 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 40
Parameters:
[] |
| 6 | 0.66 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:
[ 37631 37630 37629 37628 37627 37626 37625 37624 37622 37623 ] |
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. |