GET https://staging.stein.systems/user/providers/19/approve

Query Metrics

12 Database Queries
9 Different statements
40.80 ms Query time
1 Invalid entities
132 Managed entities

Queries

Group similar statements

# Time Info
1 0.91 ms
SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.mother_lastname AS mother_lastname_7, t0.password AS password_8, t0.email AS email_9, t0.last_login AS last_login_10, t0.roles AS roles_11, t0.succesful_login AS succesful_login_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.system_role_id AS system_role_id_15, t0.client_id AS client_id_16, t0.provider_id AS provider_id_17 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.89 ms
SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.description AS description_6, t0.slug AS slug_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.parent_id AS parent_id_10 FROM system_role t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.82 ms
SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.description AS description_6, t0.slug AS slug_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.parent_id AS parent_id_10 FROM system_role t0
Parameters:
[]
4 0.86 ms
SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.mother_lastname AS mother_lastname_7, t0.password AS password_8, t0.email AS email_9, t0.last_login AS last_login_10, t0.roles AS roles_11, t0.succesful_login AS succesful_login_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.system_role_id AS system_role_id_15, t0.client_id AS client_id_16, t0.provider_id AS provider_id_17 FROM user t0 WHERE t0.id = ?
Parameters:
[
  "19"
]
5 1.10 ms
SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.icon AS icon_6, t0.position AS position_7, t0.app_route AS app_route_8, t0.button AS button_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.parent_id AS parent_id_12 FROM menu t0
Parameters:
[]
6 1.05 ms
SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.description AS description_6, t0.slug AS slug_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.parent_id AS parent_id_10 FROM system_role t0 INNER JOIN menu_system_role ON t0.id = menu_system_role.system_role_id WHERE menu_system_role.menu_id = ?
Parameters:
[
  23
]
7 0.88 ms
"START TRANSACTION"
Parameters:
[]
8 1.25 ms
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:51:\"Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\":2:{s:60:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0message\";O:39:\"Symfony\\Bridge\\Twig\\Mime\\TemplatedEmail\":5:{i:0;s:31:\"mailer/_user_creation.html.twig\";i:1;N;i:2;a:4:{s:4:\"name\";s:5:\"nuevo\";s:8:\"password\";s:12:\"?F1A46Qz99nW\";s:9:\"userEmail\";s:24:\"mariokarim1109@gmail.com\";s:10:\"login_link\";s:35:\"https://staging.stein.systems/login\";}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\"Symfony\\Component\\Mime\\Header\\Headers\":2:{s:46:\"\0Symfony\\Component\\Mime\\Header\\Headers\0headers\";a:3:{s:4:\"from\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:4:\"From\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:24:\"contacto@ilegalmezcal.mx\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}s:2:\"to\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:2:\"To\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:24:\"mariokarim1109@gmail.com\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}s:7:\"subject\";a:1:{i:0;O:48:\"Symfony\\Component\\Mime\\Header\\UnstructuredHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:7:\"Subject\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:55:\"\0Symfony\\Component\\Mime\\Header\\UnstructuredHeader\0value\";s:18:\"Bienvenido a STEIN\";}}}s:49:\"\0Symfony\\Component\\Mime\\Header\\Headers\0lineLength\";i:76;}i:1;N;}}i:4;N;}s:61:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0envelope\";N;}}"
  "[]"
  "default"
  "2026-06-02 19:58:05"
  "2026-06-02 19:58:05"
]
9 20.09 ms
"COMMIT"
Parameters:
[]
10 0.73 ms
"START TRANSACTION"
Parameters:
[]
11 0.97 ms
UPDATE user SET status = ?, password = ?, updated_at = ?, updated_by_id = ? WHERE id = ?
Parameters:
[
  1
  "$2y$13$hL9HL8wvxftZz967pHhm.uWZDkEpQ5vouA75CPl2g4sc/LPJD86ru"
  "2026-06-02 19:58:05"
  1
  19
]
12 11.25 ms
"COMMIT"
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Menu 115
App\Entity\SystemRole 13
App\Entity\User 3
App\Entity\Provider\Provider 1

Entities Mapping

Class Mapping errors
App\Entity\BaseEntity No errors.
App\Entity\User No errors.
App\Entity\SystemRole No errors.
App\Entity\Client No errors.
App\Entity\Provider\Provider No errors.
App\Entity\Warehouse
  • The field 'App\Entity\Warehouse#latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Warehouse#longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Menu No errors.