Query Metrics

7 Database Queries
7 Different statements
7.15 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:
[
  "7soafb0nbvnqfc95112kfmtgek"
  Ramsey\Uuid\Lazy\LazyUuidFromString {#144
    __toString(): "c1d9a05f-4244-490b-adc9-a6b839956b62"
  }
]
2 0.18 ms
"START TRANSACTION"
Parameters:
[]
3 0.29 ms
UPDATE user_stats SET last_update = ?, visited_pages = ? WHERE id = ?
Parameters:
[
  "2025-10-30 21:33:25"
  "["\/oficinas-cambio-moneda\/alicante\/ciudad-quesada","\/oficinas-cambio-moneda\/malaga","\/servicios"]"
  1555
]
4 3.78 ms
"COMMIT"
Parameters:
[]
5 0.60 ms
SELECT t0.id AS id_1, t0.estado AS estado_2, t0.fecha_alta AS fecha_alta_3, t0.fecha_modificacion AS fecha_modificacion_4, t0.fecha_publicacion AS fecha_publicacion_5, t0.locales AS locales_6, t0.error AS error_7, t0.clave AS clave_8, t0.position AS position_9, t0.imagen_id AS imagen_id_10, t0.galeria_id AS galeria_id_11, t0.ruta_id AS ruta_id_12, t0.tipo FROM contenido t0 WHERE t0.estado = ? AND t0.tipo IN ('servicio') ORDER BY t0.position ASC
Parameters:
[
  1
]
6 0.36 ms
SELECT t0.id AS id_1 FROM ruta t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "servicio_url"
]
7 0.45 ms
SELECT t0.id AS id_1, t0.ruta AS ruta_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM ruta_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  "servicio_url"
]

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\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\RutaTranslation No errors.