GET https://tigafrdb.tiga-sys.com/financial-report/view/513

Query Metrics

23 Database Queries
6 Different statements
3.35 ms Query time
2 Invalid entities
40 Managed entities

Queries

Group similar statements

# Time Info
1 0.50 ms
SELECT t0.id AS id_1, t0.doc_entry AS doc_entry_2, t0.template AS template_3, t0.notes AS notes_4, t0.validation_status AS validation_status_5, t0.created_by AS created_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.company_id AS company_id_9, t0.exercise_id AS exercise_id_10, t0.financial_state_template_id AS financial_state_template_id_11 FROM ofrp t0 WHERE t0.id = ?
Parameters:
[
  513
]
2 0.21 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.amount AS amount_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.financial_statement_id AS financial_statement_id_6, t0.financial_state_template_line_id AS financial_state_template_line_id_7 FROM frp1 t0 WHERE t0.financial_statement_id = ?
Parameters:
[
  513
]
3 0.12 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.created_by AS created_by_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM ofrm t0 WHERE t0.id = ?
Parameters:
[
  71
]
4 0.10 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:
[
  104
]
5 0.11 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:
[
  160
]
6 0.10 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2188
]
7 0.09 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2191
]
8 0.11 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2192
]
9 0.19 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2196
]
10 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2197
]
11 0.67 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2198
]
12 0.14 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2199
]
13 0.10 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2200
]
14 0.08 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2201
]
15 0.09 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2202
]
16 0.08 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2203
]
17 0.08 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2204
]
18 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2205
]
19 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2206
]
20 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2207
]
21 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2210
]
22 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2213
]
23 0.07 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.label AS label_4, t0.type AS type_5, t0.totalization_reference AS totalization_reference_6, t0.totalization_sign AS totalization_sign_7, t0.created_by AS created_by_8, t0.financial_state_template_id AS financial_state_template_id_9 FROM frm1 t0 WHERE t0.id = ?
Parameters:
[
  2215
]

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\FinancialStateLine 18
App\Entity\FinancialStateTemplateLine 18
App\Entity\FinancialStatement 1
App\Entity\Company 1
App\Entity\Exercise 1
App\Entity\FinancialStateTemplate 1

Entities Mapping

Class Mapping errors
App\Entity\FinancialStatement No errors.
App\Entity\Company
  • The mappings App\Entity\Company#accreditations and App\Entity\Accreditation#company are inconsistent with each other.
App\Entity\Exercise No errors.
App\Entity\FinancialStateTemplate No errors.
App\Entity\FinancialStateLine No errors.
App\Entity\FinancialStateTemplateLine No errors.
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\Shareholder No errors.
App\Entity\ExerciseInfo No errors.