Query Metrics
8
Database Queries
7
Different statements
16.60 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.67 ms (34.13%) |
1 |
SELECT t0.client_id AS client_id_1, t0.token AS token_2, t0.expires_at AS expires_at_3, t0.scope AS scope_4, t0.user_id AS user_id_5, t0.data AS data_6 FROM access_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
"917f2e737381dfdb82bfe2d822cfe2a3ed3e04425098dbea9cb666a5717bf179e239ad4216b8021c9f34f8e79d61647a6a5e0d3aa70f007f78df2fe8fce354f0"
]
|
3.13 ms (18.87%) |
1 |
SELECT t0.status AS status_1, t0.date_created AS date_created_2, t0.date_modified AS date_modified_3, t0.user_id AS user_id_4, t0.address_id AS address_id_5, t0.parent_id AS parent_id_6, t0.permission AS permission_7, t0.color AS color_8, t0.rent AS rent_9 FROM user_has_address t0 WHERE t0.user_id = ? AND t0.address_id = ? AND t0.status = ?
Parameters:
[ 456 289 1 ] |
2.29 ms (13.76%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.status AS status_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.name AS name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.password AS password_9, t0.media_path AS media_path_10, t0.thumb_path AS thumb_path_11, t0.curp AS curp_12, t0.phone AS phone_13, t0.email_verification AS email_verification_14, t0.phone_verification AS phone_verification_15 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
456
]
|
1.75 ms (10.55%) |
2 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.status AS status_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.name AS name_6, t0.street AS street_7, t0.outdoor_number AS outdoor_number_8, t0.interior_number AS interior_number_9, t0.residential_id AS residential_id_10 FROM address t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
"0e68cb7a-f1fe-4ab5-8725-9966f6367196"
]
|
1.61 ms (9.71%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.status AS status_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.name AS name_6, t0.id_rule AS id_rule_7, t0.plate_rule AS plate_rule_8, t0.cp AS cp_9, t0.neighborhood AS neighborhood_10, t0.country AS country_11, t0.state AS state_12, t0.city AS city_13 FROM residential t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
1.12 ms (6.74%) |
1 |
SELECT u0_.id AS id_0, u0_.uuid AS uuid_1, u0_.status AS status_2, u0_.date_created AS date_created_3, u0_.date_modified AS date_modified_4, u0_.name AS name_5, u0_.last_name AS last_name_6, u0_.email AS email_7, u0_.password AS password_8, u0_.media_path AS media_path_9, u0_.thumb_path AS thumb_path_10, u0_.curp AS curp_11, u0_.phone AS phone_12, u0_.email_verification AS email_verification_13, u0_.phone_verification AS phone_verification_14, u1_.permission AS permission_15, u1_.color AS color_16 FROM user u0_ INNER JOIN user_has_address u1_ ON ((u1_.user_id = u0_.id) AND (u1_.address_id = ?) AND (u1_.status = ?)) LIMIT 100 OFFSET 0
Parameters:
[ 289 1 ] |
1.03 ms (6.23%) |
1 |
SELECT count(u0_.id) AS sclr_0 FROM user u0_ INNER JOIN user_has_address u1_ ON ((u1_.user_id = u0_.id) AND (u1_.address_id = ?) AND (u1_.status = ?))
Parameters:
[ 289 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 |
---|---|
Hona\AuthBundle\Entity\Token | No errors. |
Hona\AuthBundle\Entity\AccessToken | No errors. |
Hona\AdminBundle\Entity\Entity | No errors. |
Hona\AdminBundle\Entity\User | No errors. |
Hona\AdminBundle\Entity\Address | No errors. |
Hona\AdminBundle\Entity\Relationship | No errors. |
Hona\AdminBundle\Entity\UserHasAddress | No errors. |
Hona\AdminBundle\Entity\Residential | No errors. |