GET https://tigafrdb.tiga-sys.com/core/company/103/edit

Query Metrics

5 Database Queries
5 Different statements
1.66 ms Query time
2 Invalid entities
12 Managed entities

Queries

Group similar statements

# Time Info
1 0.57 ms
SELECT t0.id AS id_1, t0.company_code AS company_code_2, t0.company_name AS company_name_3, t0.sector_of_activity AS sector_of_activity_4, t0.legal_form AS legal_form_5, t0.administration_method AS administration_method_6, t0.year_of_creation AS year_of_creation_7, t0.created_by AS created_by_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM ocmp t0 WHERE t0.id = ?
Parameters:
[
  "103"
]
2 0.22 ms
SELECT t0.id AS id_1, t0.company_code AS company_code_2, t0.men_squad AS men_squad_3, t0.women_squad AS women_squad_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.exercise_id AS exercise_id_7, t0.company_id AS company_id_8 FROM cmp2 t0 WHERE t0.company_id = ?
Parameters:
[
  103
]
3 0.30 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.contribution AS contribution_4, t0.company_id AS company_id_5 FROM cmp1 t0 WHERE t0.company_id = ?
Parameters:
[
  103
]
4 0.33 ms
SELECT t0.id AS id_1, t0.exercise AS exercise_2, t0.name AS name_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.created_by AS created_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM ofyr t0 WHERE t0.id = ?
Parameters:
[
  162
]
5 0.25 ms
SELECT o0_.id AS id_0, o0_.exercise AS exercise_1, o0_.name AS name_2, o0_.start_date AS start_date_3, o0_.end_date AS end_date_4, o0_.created_by AS created_by_5, o0_.created_at AS created_at_6, o0_.updated_at AS updated_at_7 FROM ofyr o0_
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\Exercise 9
App\Entity\Company 1
App\Entity\ExerciseInfo 1
App\Entity\Shareholder 1

Entities Mapping

Class Mapping errors
App\Entity\Company
  • The mappings App\Entity\Company#accreditations and App\Entity\Accreditation#company are inconsistent with each other.
App\Entity\Accreditation
  • The association App\Entity\Accreditation#company refers to the inverse side field App\Entity\Company#accreditation which does not exist.
App\Entity\FinancialStatement No errors.
App\Entity\Shareholder No errors.
App\Entity\ExerciseInfo No errors.
App\Entity\Exercise No errors.