Query Metrics
11
Database Queries
4
Different statements
24.24 ms
Query time
0
Invalid entities
48
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.30 ms |
SELECT t0_.id AS id_0, t0_.created_date AS created_date_1, t0_.updated_date AS updated_date_2, t0_.last_updated_ip_address AS last_updated_ip_address_3, t0_.title AS title_4, t0_.title_fr AS title_fr_5, t0_.active AS active_6, t0_.ingredient_id AS ingredient_id_7, t0_.form_id AS form_id_8, t0_.last_updated_by_user_id AS last_updated_by_user_id_9 FROM tier3 t0_ LEFT JOIN ingredients i1_ ON t0_.ingredient_id = i1_.id LEFT JOIN forms f2_ ON t0_.form_id = f2_.id WHERE t0_.active = ? ORDER BY t0_.title ASC LIMIT 20
Parameters:
[
1
]
|
| 2 | 5.91 ms |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.last_updated_operation AS last_updated_operation_3, t0.last_updated_ip AS last_updated_ip_4, t0.form_code AS form_code_5, t0.en_pharm_form AS en_pharm_form_6, t0.fr_pharm_form AS fr_pharm_form_7, t0.parent_object_id AS parent_object_id_8, t0.last_updated_user_id AS last_updated_user_id_9 FROM forms t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 3 | 2.79 ms |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.last_updated_operation AS last_updated_operation_3, t0.last_updated_ip AS last_updated_ip_4, t0.form_code AS form_code_5, t0.en_pharm_form AS en_pharm_form_6, t0.fr_pharm_form AS fr_pharm_form_7, t0.parent_object_id AS parent_object_id_8, t0.last_updated_user_id AS last_updated_user_id_9 FROM forms t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 4 | 2.82 ms |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.last_updated_operation AS last_updated_operation_3, t0.last_updated_ip AS last_updated_ip_4, t0.form_code AS form_code_5, t0.en_pharm_form AS en_pharm_form_6, t0.fr_pharm_form AS fr_pharm_form_7, t0.parent_object_id AS parent_object_id_8, t0.last_updated_user_id AS last_updated_user_id_9 FROM forms t0 WHERE t0.id = ?
Parameters:
[
24
]
|
| 5 | 0.31 ms |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.last_updated_operation AS last_updated_operation_3, t0.last_updated_ip AS last_updated_ip_4, t0.form_code AS form_code_5, t0.en_pharm_form AS en_pharm_form_6, t0.fr_pharm_form AS fr_pharm_form_7, t0.parent_object_id AS parent_object_id_8, t0.last_updated_user_id AS last_updated_user_id_9 FROM forms t0 WHERE t0.id = ?
Parameters:
[
180
]
|
| 6 | 0.25 ms |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.last_updated_operation AS last_updated_operation_3, t0.last_updated_ip AS last_updated_ip_4, t0.form_code AS form_code_5, t0.en_pharm_form AS en_pharm_form_6, t0.fr_pharm_form AS fr_pharm_form_7, t0.parent_object_id AS parent_object_id_8, t0.last_updated_user_id AS last_updated_user_id_9 FROM forms t0 WHERE t0.id = ?
Parameters:
[
36
]
|
| 7 | 0.28 ms |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.last_updated_operation AS last_updated_operation_3, t0.last_updated_ip AS last_updated_ip_4, t0.form_code AS form_code_5, t0.en_pharm_form AS en_pharm_form_6, t0.fr_pharm_form AS fr_pharm_form_7, t0.parent_object_id AS parent_object_id_8, t0.last_updated_user_id AS last_updated_user_id_9 FROM forms t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 8 | 3.38 ms |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.last_updated_operation AS last_updated_operation_3, t0.last_updated_ip AS last_updated_ip_4, t0.form_code AS form_code_5, t0.en_pharm_form AS en_pharm_form_6, t0.fr_pharm_form AS fr_pharm_form_7, t0.parent_object_id AS parent_object_id_8, t0.last_updated_user_id AS last_updated_user_id_9 FROM forms t0 WHERE t0.id = ?
Parameters:
[
56
]
|
| 9 | 0.30 ms |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.last_updated_operation AS last_updated_operation_3, t0.last_updated_ip AS last_updated_ip_4, t0.form_code AS form_code_5, t0.en_pharm_form AS en_pharm_form_6, t0.fr_pharm_form AS fr_pharm_form_7, t0.parent_object_id AS parent_object_id_8, t0.last_updated_user_id AS last_updated_user_id_9 FROM forms t0 WHERE t0.id = ?
Parameters:
[
12
]
|
| 10 | 3.55 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.created_date AS created_date_1, t0_.updated_date AS updated_date_2, t0_.last_updated_ip_address AS last_updated_ip_address_3, t0_.title AS title_4, t0_.title_fr AS title_fr_5, t0_.active AS active_6 FROM tier3 t0_ LEFT JOIN ingredients i1_ ON t0_.ingredient_id = i1_.id LEFT JOIN forms f2_ ON t0_.form_id = f2_.id WHERE t0_.active = ? ORDER BY t0_.title ASC) dctrn_result) dctrn_table
Parameters:
[
1
]
|
| 11 | 0.35 ms |
SELECT count(DISTINCT t0_.ingredient_id) AS sclr_0 FROM tier3 t0_ WHERE t0_.active = ?
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| BaseBundle\Entity\Tier3 | 20 |
| BaseBundle\Entity\Ingredient | 18 |
| BaseBundle\Entity\Form | 8 |
| BaseBundle\Entity\User | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| BaseBundle\Entity\APIObject | No errors. |
| BaseBundle\Entity\Tier3 | No errors. |
| BaseBundle\Entity\Ingredient | No errors. |
| BaseBundle\Entity\Form | No errors. |
| BaseBundle\Entity\User | No errors. |
| BaseBundle\Entity\Tier3DrugReport | No errors. |
| BaseBundle\Entity\DrugForm | No errors. |