Query Metrics

13 Database Queries
13 Different statements
8.53 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 1.39 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:
[
  "si1r6cllujr3s487p5j65ahh4f"
  Ramsey\Uuid\Lazy\LazyUuidFromString {#144
    __toString(): "5dac23fa-a3fb-4020-8679-4894f0b2c1c0"
  }
]
2 0.19 ms
"START TRANSACTION"
Parameters:
[]
3 0.30 ms
UPDATE user_stats SET last_update = ?, visited_pages = ? WHERE id = ?
Parameters:
[
  "2025-10-30 21:29:33"
  "["\/oficinas-cambio-moneda\/islas-baleares\/magaluf","\/cms\/recursos-humanos-33","\/oficinas-cambio-moneda\/gipuzkoa\/san-sebastian"]"
  1552
]
4 2.68 ms
"COMMIT"
Parameters:
[]
5 0.45 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:
[
  "gipuzkoa"
  "es"
]
6 0.35 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:
[
  20
]
7 0.40 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:
[
  20
]
8 0.33 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:
[
  "san-sebastian"
]
9 0.60 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:
[
  50
  "es"
]
10 0.39 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:
[
  50
  1
]
11 0.50 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:
[
  50
]
12 0.38 ms
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.activo AS activo_2, m0_.zona AS zona_3 FROM menu m0_ WHERE m0_.activo = ? AND m0_.zona = ?
Parameters:
[
  1
  "principal"
]
13 0.57 ms
SELECT m0_.id AS id_0, m0_.path AS path_1, m0_.lvl AS lvl_2, m0_.position AS position_3, m0_.tipo AS tipo_4, m0_.target AS target_5, m0_.contenido AS contenido_6, m0_.activo AS activo_7, m1_.titulo AS titulo_8, m1_.url AS url_9, m1_.id AS id_10, m1_.locale AS locale_11, i2_.name AS name_12, i2_.description AS description_13, i2_.enabled AS enabled_14, i2_.provider_name AS provider_name_15, i2_.provider_status AS provider_status_16, i2_.provider_reference AS provider_reference_17, i2_.provider_metadata AS provider_metadata_18, i2_.width AS width_19, i2_.height AS height_20, i2_.length AS length_21, i2_.content_type AS content_type_22, i2_.content_size AS content_size_23, i2_.copyright AS copyright_24, i2_.author_name AS author_name_25, i2_.context AS context_26, i2_.cdn_is_flushable AS cdn_is_flushable_27, i2_.cdn_flush_identifier AS cdn_flush_identifier_28, i2_.cdn_flush_at AS cdn_flush_at_29, i2_.cdn_status AS cdn_status_30, i2_.updated_at AS updated_at_31, i2_.created_at AS created_at_32, i2_.id AS id_33 FROM menu_item m0_ INNER JOIN menu_item_translation m1_ ON m0_.id = m1_.translatable_id LEFT JOIN imagen i2_ ON m0_.imagen_id = i2_.id WHERE m0_.menu_id = '1' ORDER BY m0_.path 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\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.
App\Entity\TransaccionAfiliado No errors.
App\Entity\HistorialDevolucion No errors.
App\Entity\ReservaLinea No errors.
App\Entity\TransaccionLinea No errors.
App\Entity\Nacex No errors.
App\Entity\EmailTransaccionAbandonada No errors.
Sonata\MediaBundle\Entity\BaseGalleryItem No errors.
App\Entity\ImagenxGaleria No errors.
App\Entity\Divisa
  • The field App\Entity\Divisa#origenConversiones is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DivisaConversion#divisaOrigen does not contain the required 'inversedBy="origenConversiones"' attribute.
  • The field App\Entity\Divisa#destinoConversiones is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DivisaConversion#divisaDestino does not contain the required 'inversedBy="destinoConversiones"' attribute.
App\Entity\FranjaHoras No errors.
App\Entity\FranjaDiasTranslation No errors.
App\Entity\ServicioTranslation No errors.
App\Entity\HorarioReducido No errors.
App\Entity\Menu No errors.
App\Entity\MenuItem No errors.
App\Entity\MenuItemTranslation No errors.