Query Metrics
193
Database Queries
6
Different statements
184.70 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
91.62 ms (49.61%) |
109 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.payment_date AS payment_date_3, t0.execution_date AS execution_date_4, t0.billable_value AS billable_value_5, t0.factura_row_txt AS factura_row_txt_6, t0.contract_id AS contract_id_7, t0.unit_id AS unit_id_8 FROM tranche t0 WHERE t0.contract_id = ?
Parameters:
[
114
]
|
|
68.61 ms (37.15%) |
65 |
SELECT t0.name AS name_1, t0.cod_fiscal AS cod_fiscal_2, t0.nr_reg_com AS nr_reg_com_3, t0.address AS address_4, t0.banca AS banca_5, t0.cont_bancar AS cont_bancar_6, t0.contact_person AS contact_person_7, t0.contact_person_title AS contact_person_title_8, t0.tel AS tel_9, t0.email AS email_10, t0.type AS type_11, t0.deleted AS deleted_12, t0.payer_tva AS payer_tva_13, t0.bill_with_tva AS bill_with_tva_14, t0.zero_tva AS zero_tva_15, t0.anaf_str AS anaf_str_16, t0.anaf_nr AS anaf_nr_17, t0.anaf_loc AS anaf_loc_18, t0.anaf_denumire_jud AS anaf_denumire_jud_19, t0.anaf_cod_jud AS anaf_cod_jud_20, t0.anaf_detalii_addresa AS anaf_detalii_addresa_21, t0.anaf_cod_postal AS anaf_cod_postal_22, t0.id AS id_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.country_id AS country_id_26, t0.county_id AS county_id_27, t0.city_id AS city_id_28, t0.company_type_id AS company_type_id_29 FROM company t0 WHERE t0.id = ?
Parameters:
[
22
]
|
|
14.30 ms (7.74%) |
12 |
SELECT t0.seria AS seria_1, t0.nr AS nr_2, t0.data_din AS data_din_3, t0.contrac_txt AS contrac_txt_4, t0.anexa AS anexa_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.total_paid AS total_paid_8, t0.unit_price AS unit_price_9, t0.interval_of_unit_price AS interval_of_unit_price_10, t0.duration_mounth AS duration_mounth_11, t0.indefinite AS indefinite_12, t0.exchange_rate AS exchange_rate_13, t0.hourly_rate AS hourly_rate_14, t0.contracted_hour AS contracted_hour_15, t0.contract_parent_value AS contract_parent_value_16, t0.id AS id_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.project_type_id AS project_type_id_20, t0.company_id AS company_id_21, t0.contract_status_id AS contract_status_id_22, t0.project_id AS project_id_23, t0.currency_id AS currency_id_24, t0.contract_parent_id AS contract_parent_id_25, t0.language_id AS language_id_26 FROM contract t0 WHERE t0.contract_parent_id = ?
Parameters:
[
118
]
|
|
5.98 ms (3.24%) |
5 |
SELECT t0.name AS name_1, t0.content_ro AS content_ro_2, t0.content_hu AS content_hu_3, t0.content_en AS content_en_4, t0.deleted AS deleted_5, t0.anexa_ro AS anexa_ro_6, t0.anexa_hu AS anexa_hu_7, t0.anexa_en AS anexa_en_8, t0.comment AS comment_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM project_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
2.80 ms (1.51%) |
1 |
SELECT c0_.seria AS seria_0, c0_.nr AS nr_1, c0_.data_din AS data_din_2, c0_.contrac_txt AS contrac_txt_3, c0_.anexa AS anexa_4, c0_.start_date AS start_date_5, c0_.end_date AS end_date_6, c0_.total_paid AS total_paid_7, c0_.unit_price AS unit_price_8, c0_.interval_of_unit_price AS interval_of_unit_price_9, c0_.duration_mounth AS duration_mounth_10, c0_.indefinite AS indefinite_11, c0_.exchange_rate AS exchange_rate_12, c0_.hourly_rate AS hourly_rate_13, c0_.contracted_hour AS contracted_hour_14, c0_.contract_parent_value AS contract_parent_value_15, c0_.id AS id_16, c0_.created_at AS created_at_17, c0_.updated_at AS updated_at_18, c0_.project_type_id AS project_type_id_19, c0_.company_id AS company_id_20, c0_.contract_status_id AS contract_status_id_21, c0_.project_id AS project_id_22, c0_.currency_id AS currency_id_23, c0_.contract_parent_id AS contract_parent_id_24, c0_.language_id AS language_id_25 FROM contract c0_ WHERE c0_.contract_status_id IN (1, 2, 3, 4, 6) ORDER BY c0_.end_date DESC
Parameters:
[] |
|
1.38 ms (0.75%) |
1 |
SELECT t0.name AS name_1, t0.id AS id_2 FROM contract_status t0
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Base\AbstractEntity | No errors. |
| App\Entity\ContractStatus | No errors. |
| App\Entity\Base\AbstractTimestampableEntity | No errors. |
| App\Entity\Contract |
|
| App\Entity\ProjectType |
|
| App\Entity\Company |
|
| App\Entity\Project |
|
| App\Entity\Currency | No errors. |
| App\Entity\Language | No errors. |
| App\Entity\Tranche | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\County | No errors. |
| App\Entity\City | No errors. |
| App\Entity\CompanyType | No errors. |
| App\Entity\FacturiHeader | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\CashIn | No errors. |
| App\Entity\CashOut | No errors. |
| App\Entity\Unit | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\FacturaBody | No errors. |