https://erp.nolimit-web.ro/admin/app/contract/contract_tranche_task_items?_=1789569207431&project_id=131&tranche_id=0

Query Metrics

4 Database Queries
3 Different statements
2.07 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
0.95 ms
(45.66%)
1
SELECT t0_.name AS name_0, t0_.technical_description AS technical_description_1, t0_.scheduled_hours AS scheduled_hours_2, t0_.priotity AS priotity_3, t0_.schedule_date AS schedule_date_4, t0_.offer_value AS offer_value_5, t0_.billable_value AS billable_value_6, t0_.worked_minutes AS worked_minutes_7, t0_.not_used AS not_used_8, t0_.not_used_minutes AS not_used_minutes_9, t0_.finished_date AS finished_date_10, t0_.order_task AS order_task_11, t0_.id AS id_12, t0_.created_at AS created_at_13, t0_.updated_at AS updated_at_14, t0_.task_owner_id AS task_owner_id_15, t0_.assigned_user_id AS assigned_user_id_16, t0_.task_status_id AS task_status_id_17, t0_.project_id AS project_id_18, t0_.currency_id AS currency_id_19, t0_.task_type_id AS task_type_id_20, t0_.offer_body_id AS offer_body_id_21, t0_.tranche_id AS tranche_id_22, t0_.not_used_parent_id AS not_used_parent_id_23 FROM task t0_ WHERE t0_.tranche_id IS NULL AND t0_.project_id = ? AND t0_.task_status_id = ? AND t0_.task_type_id <> ? ORDER BY t0_.order_task ASC
Parameters:
[
  131
  3
  4
]
0.79 ms
(37.89%)
1
SELECT t0.name AS name_1, t0.price AS price_2, t0.scheduled_hours AS scheduled_hours_3, t0.worked_hours AS worked_hours_4, t0.url AS url_5, t0.end_date AS end_date_6, t0.description AS description_7, t0.security_data AS security_data_8, t0.deadline AS deadline_9, t0.hourly_rate AS hourly_rate_10, t0.contact_person_name AS contact_person_name_11, t0.contact_person_email AS contact_person_email_12, t0.contact_person_phone AS contact_person_phone_13, t0.id AS id_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.company_id AS company_id_17, t0.project_type_id AS project_type_id_18, t0.status_id AS status_id_19, t0.currency_id AS currency_id_20, t0.project_manager_id AS project_manager_id_21 FROM project t0 WHERE t0.id = ?
Parameters:
[
  131
]
0.34 ms
(16.45%)
2
SELECT t0.id AS id_1, t0.name AS name_2 FROM task_type t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\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\ProjectStatus No errors.
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\TaskStatus No errors.
App\Entity\TaskType No errors.
App\Entity\OfferBody No errors.
App\Entity\Tranche No errors.
App\Entity\TaskLog No errors.