https://api.unda.co/address/0e68cb7a-f1fe-4ab5-8725-9966f6367196/user/100/0

Query Metrics

8 Database Queries
7 Different statements
16.60 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.