https://api.unda.co/me?fields=control_gate%2Caddress%2Cnotification_setting

Query Metrics

10 Database Queries
8 Different statements
9.68 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.33 ms
(24.01%)
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.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:
[
  407
]
2.06 ms
(21.27%)
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:
[
  "b87ee417c6205985ae9f8a2da41d7bcfe0f75881fa0019f2c8b37aefd6cccbafca2411689b45ce1e85305b517fd39a6c0b4aa7b11c8d930446b1779608939969"
]
1.13 ms
(11.63%)
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.uuid = ? LIMIT 1
Parameters:
[
  "cbf039b9-80f3-4b6c-b065-46b4f53551bb"
]
1.02 ms
(10.49%)
1
SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.status AS status_2, a0_.date_created AS date_created_3, a0_.date_modified AS date_modified_4, a0_.name AS name_5, a0_.street AS street_6, a0_.outdoor_number AS outdoor_number_7, a0_.interior_number AS interior_number_8, a0_.residential_id AS residential_id_9, u1_.permission AS permission_10, u1_.color AS color_11 FROM address a0_ INNER JOIN user_has_address u1_ ON ((u1_.address_id = a0_.id) AND (u1_.user_id = ?) AND (u1_.status = ?)) LIMIT 10 OFFSET 0
Parameters:
[
  407
  1
]
0.88 ms
(9.13%)
1
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.status AS status_2, c0_.date_created AS date_created_3, c0_.date_modified AS date_modified_4, c0_.name AS name_5, c0_.residential_id AS residential_id_6, u1_.permission AS permission_7 FROM control_gate c0_ INNER JOIN user_has_control_gate u1_ ON ((u1_.control_gate_id = c0_.id) AND (u1_.user_id = ?) AND (u1_.status = ?)) LIMIT 10 OFFSET 0
Parameters:
[
  407
  1
]
0.82 ms
(8.43%)
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.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:
[
  "3bd88690-adc5-4bef-bf00-3e30b98859b3"
]
0.75 ms
(7.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.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 = ?
Parameters:
[
  15
]
0.71 ms
(7.29%)
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.other_user AS other_user_6, t0.news AS news_7, t0.new_events AS new_events_8, t0.invited_entry AS invited_entry_9, t0.invited_confirmation AS invited_confirmation_10, t0.user_id AS user_id_11, t0.address_id AS address_id_12, t0.control_gate_id AS control_gate_id_13 FROM notification_setting t0 WHERE t0.user_id = ? AND t0.address_id = ? LIMIT 1
Parameters:
[
  407
  276
]

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\ControlGate No errors.
Hona\AdminBundle\Entity\Relationship No errors.
Hona\AdminBundle\Entity\UserHasControlGate No errors.
Hona\AdminBundle\Entity\Address No errors.
Hona\AdminBundle\Entity\UserHasAddress No errors.
Hona\AdminBundle\Entity\Residential No errors.
Hona\AdminBundle\Entity\NotificationSetting No errors.