https://erp.nolimit-web.ro/admin/app/project/project_list/?_=1776770447695

Query Metrics

145 Database Queries
5 Different statements
56.46 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

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
  • The association App\Entity\Project#company refers to the inverse side field App\Entity\Company#projects which does not exist.
App\Entity\Company
  • The association App\Entity\Company#payments refers to the owning side field App\Entity\Payment#company which does not exist.
  • The association App\Entity\Company#county refers to the inverse side field App\Entity\County#clients which does not exist.
  • The association App\Entity\Company#city refers to the inverse side field App\Entity\City#clients which does not exist.
App\Entity\ProjectType
  • The association App\Entity\ProjectType#contracts refers to the owning side field App\Entity\Contract#contractType which does not exist.
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
  • The mappings App\Entity\Contract#projectType and App\Entity\ProjectType#contracts are inconsistent with each other.
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.