Query Metrics

11 Database Queries
11 Different statements
9.86 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 2.33 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:
[
  "vs050oll5toeesk78bvig71b6o"
  Ramsey\Uuid\Lazy\LazyUuidFromString {#144
    __toString(): "58b9b954-6fed-44a1-b8a1-1bd598c72cf4"
  }
]
2 0.22 ms
"START TRANSACTION"
Parameters:
[]
3 0.48 ms
UPDATE user_stats SET last_update = ?, visited_pages = ?, locale = ? WHERE id = ?
Parameters:
[
  "2025-10-31 02:19:07"
  "["\/en\/currency-exchange-offices\/murcia\/mazarron","\/en\/exchange-rates\/de-dolar-estados-unidos-a-euro","\/oficinas-cambio-moneda\/malaga\/marbella\/casa-de-cambio-de-moneda-en-marbella-puerto-banus","\/en\/currency-exchange-offices\/zaragoza\/zaragoza","\/en\/currency-exchange-offices\/malaga\/Calahonda","\/en\/currency-exchange-offices","\/servicios\/planet-tax-free-32","\/en\/currency-exchange-offices\/alicante\/benidorm"]"
  "en"
  1564
]
4 3.34 ms
"COMMIT"
Parameters:
[]
5 0.46 ms
SELECT t0.id AS id_1, t0.texto AS texto_2, t0.alt AS alt_3, t0.titulo AS titulo_4, t0.meta_keywords AS meta_keywords_5, t0.meta_description AS meta_description_6, t0.meta_title AS meta_title_7, t0.descripcion_imagen AS descripcion_imagen_8, t0.slug AS slug_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM provincia_translation t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "alicante"
  "en"
]
6 0.49 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.gastos AS gastos_3, t0.peso AS peso_4, t0.imagen_cabecera_id AS imagen_cabecera_id_5, t0.imagen_banner_id AS imagen_banner_id_6 FROM provincia t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  3
]
7 0.50 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.peso AS peso_3, t0.slug AS slug_4, t0.provincia AS provincia_5 FROM localidad t0 WHERE t0.provincia = ? ORDER BY t0.peso DESC
Parameters:
[
  3
]
8 0.41 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.peso AS peso_3, t0.slug AS slug_4, t0.provincia AS provincia_5 FROM localidad t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "benidorm"
]
9 0.53 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_keywords AS meta_keywords_3, t0.meta_description AS meta_description_4, t0.meta_title AS meta_title_5, t0.texto AS texto_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM localidad_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  1
  "en"
]
10 0.54 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.alt AS alt_3, t0.latitud AS latitud_4, t0.longitud AS longitud_5, t0.telefono AS telefono_6, t0.direccion AS direccion_7, t0.codigo_postal AS codigo_postal_8, t0.peso AS peso_9, t0.activo AS activo_10, t0.url_google AS url_google_11, t0.provincia AS provincia_12, t0.localidad AS localidad_13, t0.oficinaERP AS oficinaERP_14, t0.imagen_id AS imagen_id_15, t0.imagen_mapa_id AS imagen_mapa_id_16 FROM oficina t0 WHERE t0.localidad = ? AND t0.activo = ? ORDER BY t0.peso DESC
Parameters:
[
  1
  1
]
11 0.56 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_keywords AS meta_keywords_3, t0.meta_description AS meta_description_4, t0.meta_title AS meta_title_5, t0.texto AS texto_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM localidad_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]

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\ProvinciaTranslation No errors.
App\Entity\LocalidadTranslation No errors.
App\Entity\Cotizaciones No errors.
App\Entity\FranjaDias No errors.
App\Entity\Servicio No errors.
App\Entity\Stock No errors.
App\Entity\Existencia No errors.
App\Entity\DayOff
  • The field App\Entity\DayOff#horarioReducidos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\HorarioReducido#dayoff does not contain the required 'inversedBy="horarioReducidos"' attribute.
App\Entity\Alerta No errors.
App\Entity\OficinaTranslation No errors.