https://api.unda.co/address/a41ce4c3-29d5-4f1f-9146-ae339979667c/invitation/20/0?order=desc

Query Metrics

12 Database Queries
7 Different statements
22.13 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.30 ms
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 0.84 ms
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
]
3 1.03 ms
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"
]
4 0.59 ms
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
]
5 1.95 ms
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"
]
6 0.87 ms
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
]
7 0.57 ms
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"
]
8 1.70 ms
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
]
9 9.35 ms
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
]
10 2.29 ms
SELECT count(i0_.id) AS sclr_0 FROM invitation i0_ WHERE (i0_.address_id = ?) AND (i0_.status = ?)
Parameters:
[
  270
  1
]
11 0.87 ms
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
]
12 0.77 ms
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:
[
  394
]

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.