GET http://84.247.183.216/index.php/sites/registre

Query Metrics

1 Database Queries
1 Different statements
3.28 ms Query time
1 Invalid entities
111 Managed entities

Queries

Group similar statements

# Time Info
1 3.28 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.usage_type AS usage_type_3, s0_.description AS description_4, s0_.comment AS comment_5, s0_.status AS status_6, s0_.is_deleted AS is_deleted_7, s0_.adress AS adress_8, s0_.latitude AS latitude_9, s0_.longitude AS longitude_10, s0_.code AS code_11, s0_.is_owner AS is_owner_12, s0_.full_name AS full_name_13, p1_.id AS id_14, p1_.code AS code_15, p1_.type AS type_16, p1_.is_investment_project AS is_investment_project_17, p1_.planned_budget AS planned_budget_18, p1_.realized_budget AS realized_budget_19, p1_.status AS status_20, p1_.planned_start_date AS planned_start_date_21, p1_.planned_end_date AS planned_end_date_22, p1_.actual_start_date AS actual_start_date_23, p1_.actual_end_date AS actual_end_date_24, p1_.created_at AS created_at_25, p1_.market_type AS market_type_26, p1_.is_deleted AS is_deleted_27, p1_.title AS title_28, p1_.phase AS phase_29, p1_.description AS description_30, p1_.is_sub_project AS is_sub_project_31, s0_.territorial_entity_id AS territorial_entity_id_32, p1_.currency_id AS currency_id_33, p1_.site_id AS site_id_34, p1_.objective_id AS objective_id_35, p1_.administrative_unit_id AS administrative_unit_id_36, p1_.budget_item_id AS budget_item_id_37, p1_.main_project_id AS main_project_id_38 FROM site s0_ LEFT JOIN project p1_ ON s0_.id = p1_.site_id ORDER BY s0_.name ASC
Parameters:
[]

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
App\Entity\Site 83
App\Entity\Pcode 28

Entities Mapping

Class Mapping errors
App\Entity\Site No errors.
App\Entity\Project No errors.
App\Entity\Pcode No errors.
App\Entity\Currency
  • The association App\Entity\Currency#deviseCible refers to the owning side field App\Entity\ConversionDevise#devise_source which does not exist.
App\Entity\Objective No errors.
App\Entity\AdministrativeUnit No errors.
App\Entity\BudgetItem No errors.
App\Entity\RentalAgreement No errors.