Query Metrics
29
Database Queries
9
Different statements
9.19 ms
Query time
4
Invalid entities
Grouped Statements
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 |
|
App\AgileGo\Core\Entity\Common\Project |
|
App\AgileGo\Core\Entity\Agile\Estimation\Time | No errors. |
App\AgileGo\Core\Entity\Common\State\Value | No errors. |
App\AgileGo\Core\Entity\Agile\Role |
|
App\AgileGo\Core\Entity\Agile\Role\Type |
|