https://erp.nolimit-web.ro/admin/app/task/task_edit/ Return to referer URL

Query Metrics

6 Database Queries
6 Different statements
2.80 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 0.56 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.phone AS phone_16 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  6
]
2 0.43 ms
SELECT t0.name AS name_1, t0.technical_description AS technical_description_2, t0.scheduled_hours AS scheduled_hours_3, t0.priotity AS priotity_4, t0.schedule_date AS schedule_date_5, t0.offer_value AS offer_value_6, t0.billable_value AS billable_value_7, t0.worked_minutes AS worked_minutes_8, t0.not_used AS not_used_9, t0.not_used_minutes AS not_used_minutes_10, t0.finished_date AS finished_date_11, t0.order_task AS order_task_12, t0.id AS id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.task_owner_id AS task_owner_id_16, t0.assigned_user_id AS assigned_user_id_17, t0.task_status_id AS task_status_id_18, t0.project_id AS project_id_19, t0.currency_id AS currency_id_20, t0.task_type_id AS task_type_id_21, t0.offer_body_id AS offer_body_id_22, t0.tranche_id AS tranche_id_23, t0.not_used_parent_id AS not_used_parent_id_24 FROM task t0 WHERE t0.id = ?
Parameters:
[
  "3947"
]
3 0.94 ms
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 NOT IN (6, 8) ORDER BY p0_.status_id DESC
Parameters:
[]
4 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM task_status t0
Parameters:
[]
5 0.32 ms
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.name AS name_15, t0.phone AS phone_16 FROM user t0
Parameters:
[]
6 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM task_type 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
Sonata\UserBundle\Entity\BaseUser No errors.
App\Entity\User No errors.
App\Entity\Base\AbstractEntity No errors.
App\Entity\Base\AbstractTimestampableEntity No errors.
App\Entity\Task No errors.
App\Entity\TaskLog No errors.
App\Entity\CashOut No errors.
App\Entity\AnualLeave No errors.
App\Entity\TaskStatus 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\Currency No errors.
App\Entity\TaskType No errors.
App\Entity\OfferBody No errors.
App\Entity\Tranche No errors.
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\Offer 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.