Query Metrics

6 Database Queries
6 Different statements
7.56 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 1.49 ms
SELECT u0_.id AS id_0, u0_.session_id AS session_id_1, u0_.uuid AS uuid_2, u0_.session_start AS session_start_3, u0_.last_update AS last_update_4, u0_.visited_pages AS visited_pages_5, u0_.referer AS referer_6, u0_.ip AS ip_7, u0_.device AS device_8, u0_.country AS country_9, u0_.region AS region_10, u0_.city AS city_11, u0_.zip AS zip_12, u0_.locale AS locale_13, u0_.user AS user_14 FROM user_stats u0_ WHERE u0_.session_id = ? OR u0_.uuid = ? LIMIT 1
Parameters:
[
  "tkpmiqhm4jstgb2g7s3h7v7sd3"
  Ramsey\Uuid\Lazy\LazyUuidFromString {#144
    __toString(): "44c4a5f7-913e-457d-802f-3393bdc2d977"
  }
]
2 0.19 ms
"START TRANSACTION"
Parameters:
[]
3 0.38 ms
UPDATE user_stats SET last_update = ?, visited_pages = ? WHERE id = ?
Parameters:
[
  "2025-10-30 21:39:40"
  "["\/cms\/mapa-web-26","\/cms\/programa-afiliados-29"]"
  1560
]
4 4.47 ms
"COMMIT"
Parameters:
[]
5 0.46 ms
SELECT c0_.id AS id_0, c0_.estado AS estado_1, c0_.fecha_alta AS fecha_alta_2, c0_.fecha_modificacion AS fecha_modificacion_3, c0_.fecha_publicacion AS fecha_publicacion_4, c0_.locales AS locales_5, c0_.error AS error_6, c0_.clave AS clave_7, c0_.position AS position_8, c0_.tipo AS tipo_9, c0_.imagen_id AS imagen_id_10, c0_.galeria_id AS galeria_id_11, c0_.ruta_id AS ruta_id_12 FROM contenido c0_ WHERE ((c0_.id = ? AND c0_.locales LIKE ?) AND c0_.tipo IN (?) AND c0_.estado = ?) AND c0_.tipo IN ('contenido', 'pagina', 'home', 'servicio')
Parameters:
[
  29
  "%"es"%"
  "Pagina"
  1
]
6 0.57 ms
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.texto AS texto_3, t0.intro AS intro_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.meta_keywords AS meta_keywords_7, t0.meta_robots AS meta_robots_8, t0.canonical AS canonical_9, t0.config AS config_10, t0.slug AS slug_11, t0.locale AS locale_12, t0.imagen_cabecera_id AS imagen_cabecera_id_13, t0.translatable_id AS translatable_id_14, t0.tipo FROM contenido_translation t0 WHERE t0.translatable_id = ? AND t0.tipo IN ('contenido', 'pagina', 'home', 'servicio')
Parameters:
[
  29
]

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\UserStats No errors.
FOS\UserBundle\Model\User No errors.
App\Entity\User
  • The field App\Entity\User#userStats is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserStats#user does not contain the required 'inversedBy="userStats"' attribute.
App\Entity\Reserva No errors.
App\Entity\Transaccion
  • The association App\Entity\Transaccion#usuarioAfiliado refers to the inverse side field App\Entity\User#transaccionesAfiliadas which does not exist.
  • The field App\Entity\Transaccion#emailTransaccionAbandonada is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\EmailTransaccionAbandonada#transaccion does not contain the required 'inversedBy="emailTransaccionAbandonada"' attribute.
App\Entity\Oficina
  • The field App\Entity\Oficina#alerts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Alerta#oficina does not contain the required 'inversedBy="alerts"' attribute.
App\Entity\Provincia No errors.
App\Entity\Localidad
  • The field App\Entity\Localidad#oficinas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Oficina#localidad does not contain the required 'inversedBy="oficinas"' attribute.
App\Entity\OficinaErp No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Entity\Imagen No errors.
App\Entity\Contenido No errors.
App\Entity\Pagina No errors.
App\Entity\Home No errors.
App\Entity\ContenidoServicio No errors.
Sonata\MediaBundle\Entity\BaseGallery No errors.
App\Entity\Galeria No errors.
App\Entity\Ruta No errors.
App\Entity\ContenidoTranslation No errors.
App\Entity\PaginaTranslation No errors.
App\Entity\HomeTranslation No errors.
App\Entity\ContenidoServicioTranslation No errors.