GET https://inakibus.movilium.com/notifications/unread-count

Query Metrics

5 Database Queries
5 Different statements
3.83 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.locale AS locale_5, t0.descuento_traslados AS descuento_traslados_6, t0.descuento_disposiciones AS descuento_disposiciones_7, t0.descuento_cenas AS descuento_cenas_8, t0.descuento_excursiones AS descuento_excursiones_9, t0.descuento_circuitos AS descuento_circuitos_10, t0.entidad_id AS entidad_id_11 FROM `users` t0 WHERE t0.id = ?
Parameters:
[
  33
]
2 0.47 ms
SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.dominio AS dominio_2, e0_.email AS email_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.n_bases AS n_bases_6, e0_.n_vehiculos AS n_vehiculos_7, e0_.validado AS validado_8 FROM entidades e0_ WHERE e0_.dominio = ? AND e0_.validado = ?
Parameters:
[
  "inakibus.movilium.com"
  1
]
3 0.50 ms
SELECT c0_.id AS id_0, c0_.color_principal AS color_principal_1, c0_.color_secundario AS color_secundario_2, c0_.logo_filename AS logo_filename_3, c0_.entidad_id AS entidad_id_4 FROM configuration c0_ WHERE c0_.entidad_id = ? AND c0_.entidad_id = ?
Parameters:
[
  5
  5
]
4 0.50 ms
SELECT COUNT(l0_.id) AS sclr_0 FROM log l0_ WHERE l0_.leido = 0 AND l0_.entidad_id = ?
Parameters:
[
  5
]
5 1.83 ms
SELECT l0_.id AS id_0, l0_.titulo AS titulo_1, l0_.tipo AS tipo_2, l0_.notificacion AS notificacion_3, l0_.descripcion AS descripcion_4, l0_.urldestino AS urldestino_5, l0_.leido AS leido_6, l0_.entidad_id AS entidad_id_7, l0_.privado AS privado_8, l0_.created_at AS created_at_9 FROM log l0_ WHERE l0_.leido = 0 AND l0_.entidad_id = ? ORDER BY l0_.created_at DESC LIMIT 3
Parameters:
[
  5
]

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
  • The field 'App\Entity\User#descuentoTraslados' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\User#descuentoDisposiciones' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\User#descuentoCenas' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\User#descuentoExcursiones' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\User#descuentoCircuitos' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Entidad
  • The field App\Entity\Entidad#usuarios is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#entidad does not contain the required 'inversedBy="usuarios"' attribute.
App\Entity\GvServicio No errors.
App\Entity\Configuration No errors.
App\Entity\Log No errors.