Query Metrics
8
Database Queries
8
Different statements
8.28 ms
Query time
0
Invalid entities
Queries
#▲ | 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:
[
"210d21ef3398eef4c1f346924e54bb5a6e51de240bc51a68c09636149a5b98af77cdcabcee2a311cdc39081ba069f88d7a6cce9d8efaf16df5e971a753f2f1f2"
]
|
2 | 0.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.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:
[
415
]
|
3 | 0.97 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.uuid = ? LIMIT 1
Parameters:
[
"e40b213a-4458-4d63-97f6-43a1b0eb81d3"
]
|
4 | 1.08 ms |
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:
[ 415 1 ] |
5 | 1.17 ms |
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:
[ 415 1 ] |
6 | 1.06 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 = ?
Parameters:
[
15
]
|
7 | 0.86 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:
[
"41a3b095-7f6e-4e82-8fca-30136ad268b7"
]
|
8 | 0.89 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.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:
[ 415 261 ] |
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. |