https://agilego.bprogrammer.ro/admin/agile/story/list Return to referer URL

Query Metrics

29 Database Queries
9 Different statements
9.19 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.41 ms
(0.00%)
17
SELECT t0.value AS value_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.status AS status_5, t0.story_id AS story_id_6, t0.role_id AS role_id_7 FROM core_agile_est_time t0 WHERE t0.story_id = ? ORDER BY t0.id ASC
Parameters:
[
  12303
]
1.08 ms
(0.00%)
1
SELECT c0_.title AS title_0, c0_.description AS description_1, c0_.jira_key AS jira_key_2, c0_.id AS id_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.status AS status_6, c0_.project_id AS project_id_7 FROM core_agile_story c0_ INNER JOIN core_agile_story_tag_join c2_ ON c0_.id = c2_.story_id INNER JOIN core_common_tag c1_ ON c1_.id = c2_.tag_id WHERE c0_.status = 1 AND c1_.id IN (?) GROUP BY c0_.id ORDER BY c0_.id ASC
Parameters:
[
  [
    876
  ]
]
0.76 ms
(0.00%)
2
SELECT c0_.title AS title_0, c0_.summary AS summary_1, c0_.slug AS slug_2, c0_.id AS id_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.status AS status_6, c0_.group_id AS group_id_7 FROM core_common_tag c0_ WHERE c0_.status = 1 AND c0_.id IN (?) ORDER BY c0_.created_at DESC, c0_.title ASC
Parameters:
[
  [
    "876"
  ]
]
0.74 ms
(0.00%)
1
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.id AS id_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.created_on AS created_on_15, t0.last_activity AS last_activity_16 FROM auth_user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.73 ms
(0.00%)
4
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6 FROM core_agile_role_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.43 ms
(0.00%)
1
SELECT t0.title AS title_1, t0.summary AS summary_2, t0.slug AS slug_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.group_id AS group_id_8 FROM core_common_tag t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  876
]
0.38 ms
(0.00%)
1
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6 FROM core_agile_role_type t0 WHERE t0.slug IN (?)
Parameters:
[
  [
    "customer-proxy"
    "developer-coach"
    "agile-project-manager"
    "architect"
  ]
]
0.36 ms
(0.00%)
1
SELECT t0.ordering AS ordering_1, t0.daily_rate AS daily_rate_2, t0.time_fraction AS time_fraction_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.type_id AS type_id_8, t0.project_id AS project_id_9 FROM core_agile_role t0 WHERE t0.project_id = ? ORDER BY t0.ordering ASC
Parameters:
[
  1
]
0.30 ms
(0.00%)
1
SELECT t0.title AS title_1, t0.slug AS slug_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6 FROM core_common_project t0 WHERE t0.id = ?
Parameters:
[
  1
]

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
FOS\UserBundle\Model\User No errors.
App\AgileGo\Auth\Entity\User No errors.
App\AgileGo\Core\Entity\BaseEntity No errors.
App\AgileGo\Core\Entity\Common\Tag No errors.
App\AgileGo\Core\Entity\Common\Tag\Group No errors.
App\AgileGo\Core\Entity\Agile\Story
  • The field App\AgileGo\Core\Entity\Agile\Story#estimationTimeItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\AgileGo\Core\Entity\Agile\Estimation\Time#story does not contain the required 'inversedBy="estimationTimeItems"' attribute.
App\AgileGo\Core\Entity\Common\Project
  • The field App\AgileGo\Core\Entity\Common\Project#agileRoles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\AgileGo\Core\Entity\Agile\Role#project does not contain the required 'inversedBy="agileRoles"' attribute.
App\AgileGo\Core\Entity\Agile\Estimation\Time No errors.
App\AgileGo\Core\Entity\Common\State\Value No errors.
App\AgileGo\Core\Entity\Agile\Role
  • The field App\AgileGo\Core\Entity\Agile\Role#estimationTimeItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\AgileGo\Core\Entity\Agile\Estimation\Time#role does not contain the required 'inversedBy="estimationTimeItems"' attribute.
App\AgileGo\Core\Entity\Agile\Role\Type
  • The field App\AgileGo\Core\Entity\Agile\Role\Type#roles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\AgileGo\Core\Entity\Agile\Role#type does not contain the required 'inversedBy="roles"' attribute.