Query Metrics
145
Database Queries
5
Different statements
56.46 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
29.45 ms (52.17%) |
76 |
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.project_id = ?
Parameters:
[
127
]
|
|
23.69 ms (41.97%) |
63 |
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:
[
102
]
|
|
2.13 ms (3.77%) |
4 |
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:
[
4
]
|
|
0.79 ms (1.40%) |
1 |
SELECT p0_.name AS name_0, p0_.price AS price_1, p0_.scheduled_hours AS scheduled_hours_2, p0_.worked_hours AS worked_hours_3, p0_.url AS url_4, p0_.end_date AS end_date_5, p0_.description AS description_6, p0_.security_data AS security_data_7, p0_.deadline AS deadline_8, p0_.hourly_rate AS hourly_rate_9, p0_.contact_person_name AS contact_person_name_10, p0_.contact_person_email AS contact_person_email_11, p0_.contact_person_phone AS contact_person_phone_12, p0_.id AS id_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.company_id AS company_id_16, p0_.project_type_id AS project_type_id_17, p0_.status_id AS status_id_18, p0_.currency_id AS currency_id_19, p0_.project_manager_id AS project_manager_id_20 FROM project p0_ WHERE p0_.status_id IN (1, 2, 3, 4, 5) ORDER BY p0_.deadline DESC
Parameters:
[] |
|
0.39 ms (0.68%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM project_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\ProjectStatus | No errors. |
| App\Entity\Base\AbstractEntity | No errors. |
| App\Entity\Base\AbstractTimestampableEntity | No errors. |
| App\Entity\Project |
|
| App\Entity\Company |
|
| App\Entity\ProjectType |
|
| App\Entity\Currency | No errors. |
| Sonata\UserBundle\Entity\BaseUser | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Offer | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\Contract |
|
| App\Entity\CashIn | No errors. |
| App\Entity\CashOut | 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\ContractStatus | No errors. |
| App\Entity\Language | No errors. |
| App\Entity\Tranche | No errors. |