Query Metrics
12
Database Queries
7
Different statements
22.13 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
9.35 ms (42.23%) |
1 |
SELECT i0_.id AS id_0, i0_.uuid AS uuid_1, i0_.status AS status_2, i0_.date_created AS date_created_3, i0_.date_modified AS date_modified_4, i0_.name AS name_5, i0_.last_name AS last_name_6, i0_.code AS code_7, i0_.image_code_path AS image_code_path_8, i0_.type AS type_9, i0_.subtype AS subtype_10, i0_.date_invitation AS date_invitation_11, i0_.date_start AS date_start_12, i0_.date_end AS date_end_13, i0_.event_id AS event_id_14, i0_.address_id AS address_id_15, i0_.user_id AS user_id_16 FROM invitation i0_ WHERE (i0_.address_id = ?) AND (i0_.status = ?) ORDER BY i0_.date_invitation DESC LIMIT 20 OFFSET 0
Parameters:
[ 270 1 ] |
3.07 ms (13.87%) |
4 |
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:
[
410
]
|
2.52 ms (11.40%) |
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:
[
"a41ce4c3-29d5-4f1f-9146-ae339979667c"
]
|
2.33 ms (10.53%) |
2 |
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:
[
"fcc89790f2f2c2b51bcfffe93757911d91e2eec5277e2e1d345eb2c2a496e66bd9786677b228fcaf6a358ee86113759d37a06e39e94acbbcd4ece98fb5a178c1"
]
|
2.29 ms (10.35%) |
1 |
SELECT count(i0_.id) AS sclr_0 FROM invitation i0_ WHERE (i0_.address_id = ?) AND (i0_.status = ?)
Parameters:
[ 270 1 ] |
1.70 ms (7.70%) |
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:
[
15
]
|
0.87 ms (3.93%) |
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:
[ 410 270 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. |
Hona\AdminBundle\Entity\Invitation | No errors. |