Query Metrics
12
Database Queries
10
Different statements
14.80 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.27 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:
[
"c6440f25728ba0966dce07552d5b22ddc5593a94aaa72e30ef374c45a0199707d33375ea0cdaf28df501e228c9979aa5391c8bbc7ffb962643f0b065185c5c7f"
]
|
2 | 0.91 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:
[
379
]
|
3 | 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.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:
[
"521cb7fb-4b51-4095-9d92-51d2933080dd"
]
|
4 | 0.91 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:
[ 379 255 1 ] |
5 | 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.uuid = ? LIMIT 1
Parameters:
[
"be71fcbb-9a54-48c9-a8eb-1e475917b1e5"
]
|
6 | 0.93 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:
[
"521cb7fb-4b51-4095-9d92-51d2933080dd"
]
|
7 | 0.93 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 FROM address a0_ INNER JOIN user_has_address u1_ ON ((u1_.address_id = a0_.id) AND (u1_.user_id = ?)) WHERE (a0_.id = ?) AND (a0_.status = ?) LIMIT 1
Parameters:
[ 379 255 1 ] |
8 | 0.62 ms |
"START TRANSACTION"
Parameters:
[] |
9 | 2.76 ms |
INSERT INTO invitation (uuid, status, date_created, date_modified, name, last_name, code, image_code_path, type, subtype, date_invitation, date_start, date_end, event_id, address_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "d5c966d3-bc8c-447c-a656-1d6822f70ca2" 2 => 1 3 => "2024-12-26 16:55:13" 4 => "2024-12-26 16:55:13" 5 => "Eugenia" 6 => "Ruiz" 7 => "049276" 8 => "/invitation/dc3a79d6fb0007582c31e641aabe58a6b972fbe1.jpg" 9 => 1 10 => null 11 => "2024-12-27 15:00:00" 12 => null 13 => null 14 => null 15 => 255 16 => 379 ] |
10 | 3.18 ms |
"COMMIT"
Parameters:
[] |
11 | 0.83 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:
[
379
]
|
12 | 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.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.id = ? LIMIT 1
Parameters:
[
255
]
|
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\Invitation | No errors. |