Query Metrics
3
Database Queries
3
Different statements
3.72 ms
Query time
0
Invalid entities
5
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.68 ms (45.19%) |
1 |
SELECT t0.id AS id_1, t0.updated_date AS updated_date_2, t0.publish_date AS publish_date_3, t0.last_updated_operation AS last_updated_operation_4, t0.last_updated_ip AS last_updated_ip_5, t0.en_title AS en_title_6, t0.fr_title AS fr_title_7, t0.en_content AS en_content_8, t0.fr_content AS fr_content_9, t0.active AS active_10, t0.deleted_ip_address AS deleted_ip_address_11, t0.deleted_date AS deleted_date_12, t0.parent_object_id AS parent_object_id_13, t0.last_updated_user_id AS last_updated_user_id_14, t0.deleted_by_user_id AS deleted_by_user_id_15 FROM blogposts t0 WHERE t0.id = ?
Parameters:
[
"2"
]
|
|
1.11 ms (29.94%) |
1 |
SELECT b0_.id AS id_0, b0_.updated_date AS updated_date_1, b0_.publish_date AS publish_date_2, b0_.last_updated_operation AS last_updated_operation_3, b0_.last_updated_ip AS last_updated_ip_4, b0_.en_title AS en_title_5, b0_.fr_title AS fr_title_6, b0_.en_content AS en_content_7, b0_.fr_content AS fr_content_8, b0_.active AS active_9, b0_.deleted_ip_address AS deleted_ip_address_10, b0_.deleted_date AS deleted_date_11, b0_.parent_object_id AS parent_object_id_12, b0_.last_updated_user_id AS last_updated_user_id_13, b0_.deleted_by_user_id AS deleted_by_user_id_14 FROM blogposts b0_ WHERE b0_.parent_object_id IS NULL AND b0_.publish_date > ? ORDER BY b0_.publish_date ASC, b0_.id ASC LIMIT 1
Parameters:
[
"2017-03-15 12:08:00"
]
|
|
0.93 ms (24.87%) |
1 |
SELECT b0_.id AS id_0, b0_.updated_date AS updated_date_1, b0_.publish_date AS publish_date_2, b0_.last_updated_operation AS last_updated_operation_3, b0_.last_updated_ip AS last_updated_ip_4, b0_.en_title AS en_title_5, b0_.fr_title AS fr_title_6, b0_.en_content AS en_content_7, b0_.fr_content AS fr_content_8, b0_.active AS active_9, b0_.deleted_ip_address AS deleted_ip_address_10, b0_.deleted_date AS deleted_date_11, b0_.parent_object_id AS parent_object_id_12, b0_.last_updated_user_id AS last_updated_user_id_13, b0_.deleted_by_user_id AS deleted_by_user_id_14 FROM blogposts b0_ WHERE b0_.parent_object_id IS NULL AND b0_.publish_date < ? ORDER BY b0_.publish_date DESC, b0_.id DESC LIMIT 1
Parameters:
[
"2017-03-15 12:08:00"
]
|
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\BlogPost | 3 |
| BaseBundle\Entity\User | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| BaseBundle\Entity\APIObject | No errors. |
| BaseBundle\Entity\BlogPost | No errors. |
| BaseBundle\Entity\User | No errors. |