https://dev.zinvaziv.seyes.dev/les-especes-invasives?category=0

Query Metrics

13 Database Queries
3 Different statements
5.99 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.64 ms
(60.74%)
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.63 ms
(27.13%)
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.73 ms
(12.13%)
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.