https://pruebassl1.cultura.gob.cl/admin/admin-menu-usuarios-view

Query Metrics

5 Database Queries
5 Different statements
4.56 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.33 ms
(29.12%)
1
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_region u2_ ON u0_.id = u2_.user_id LEFT JOIN region r1_ ON r1_.id = u2_.region_id WHERE u0_.id <> ?
Parameters:
[
  150
]
1.27 ms
(27.95%)
1
SELECT DISTINCT u0_.id AS id_0, u0_.id AS id_1 FROM user u0_ LEFT JOIN user_region u2_ ON u0_.id = u2_.user_id LEFT JOIN region r1_ ON r1_.id = u2_.region_id WHERE u0_.id <> ? ORDER BY u0_.id ASC LIMIT 10
Parameters:
[
  150
]
0.82 ms
(17.95%)
1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nombres AS nombres_4, u0_.activo AS activo_5, u0_.super_admin AS super_admin_6, r1_.id AS id_7, r1_.nombre AS nombre_8, r1_.orden AS orden_9, u0_.region_id AS region_id_10 FROM user u0_ LEFT JOIN user_region u2_ ON u0_.id = u2_.user_id LEFT JOIN region r1_ ON r1_.id = u2_.region_id WHERE u0_.id <> ? AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.id ASC
Parameters:
[
  150
  1
  2
  3
  4
  5
  6
  7
  8
  9
  10
]
0.66 ms
(14.50%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombres AS nombres_5, t0.activo AS activo_6, t0.super_admin AS super_admin_7, t0.region_id AS region_id_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
  150
]
0.48 ms
(10.47%)
1
SELECT r0_.id AS id_0, r0_.nombre AS nombre_1, r0_.orden AS orden_2 FROM region r0_ ORDER BY r0_.orden ASC
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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Region No errors.