Query Metrics
13
Database Queries
3
Different statements
4.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.22 ms (47.90%) |
6 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.local AS local_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.type AS type_11, t9.demand_id AS demand_id_12, t9.file_id AS file_id_13, t9.company_id AS company_id_14, t15.id AS id_16, t15.type AS type_17, t15.file_id AS file_id_18, t15.company_id AS company_id_19, t0.user_id AS user_id_20, t21.id AS id_22, t21.type AS type_23, t21.tree_id AS tree_id_24, t21.file_id AS file_id_25, t0.demand_tree_id AS demand_tree_id_26 FROM file t0 LEFT JOIN demand_file t9 ON t9.file_id = t0.id LEFT JOIN company_file t15 ON t15.file_id = t0.id LEFT JOIN tree_file t21 ON t21.file_id = t0.id WHERE t0.id = ?
Parameters:
[
79
]
|
|
1.87 ms (40.28%) |
6 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.tree_id AS tree_id_3, t0.file_id AS file_id_4 FROM tree_file t0 WHERE t0.tree_id = ?
Parameters:
[
2
]
|
|
0.55 ms (11.82%) |
1 |
SELECT t0_.id AS id_0, t0_.latin_name AS latin_name_1, t0_.description AS description_2, t0_.characteristics AS characteristics_3, t0_.french_name AS french_name_4, t0_.taxref AS taxref_5, t0_.allowed AS allowed_6, t0_.creole_name AS creole_name_7, t0_.category AS category_8, t0_.stock AS stock_9, t0_.type AS type_10, t0_.created_at AS created_at_11, t0_.updated_at AS updated_at_12 FROM tree t0_ WHERE t0_.category = ? AND t0_.type = ? LIMIT 15
Parameters:
[ "0" 0 ] |
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 |
|---|---|
| App\Entity\Article | No errors. |
| App\Entity\News | No errors. |
| App\Entity\Tree | No errors. |
| App\Entity\TreeFile | No errors. |
| App\Entity\DemandTree | No errors. |
| App\Entity\CompanyDemand | No errors. |
| App\Entity\File | No errors. |
| App\Entity\DemandFile | No errors. |
| App\Entity\Demand | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\CompanyFile | No errors. |
| App\Entity\User | No errors. |