Query Metrics
10
Database Queries
8
Different statements
9.68 ms
Query time
0
Invalid entities
Grouped Statements
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. |