Query Metrics

251 Database Queries
8 Different statements
82.00 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
69.12 ms
(84.29%)
241
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM pais_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
7.98 ms
(9.73%)
1
"COMMIT"
Parameters:
[]
1.62 ms
(1.97%)
1
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:
[
  "pipvufdmlqm73bajo7mb9r5clf"
  Ramsey\Uuid\Lazy\LazyUuidFromString {#144
    __toString(): "9a3516fb-0b42-4a18-abc7-28c21ff83ec6"
  }
]
1.11 ms
(1.35%)
1
SELECT t0_.id AS id_0, t0_.codigo AS codigo_1 FROM tipo_documento t0_
Parameters:
[]
1.08 ms
(1.32%)
4
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM tipo_documento_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
0.62 ms
(0.75%)
1
SELECT p0_.id AS id_0, p0_.isonum AS isonum_1, p0_.iso2 AS iso2_2, p0_.iso3 AS iso3_3 FROM pais p0_
Parameters:
[]
0.31 ms
(0.37%)
1
UPDATE user_stats SET last_update = ?, visited_pages = ?, locale = ? WHERE id = ?
Parameters:
[
  "2025-10-30 21:34:32"
  "["\/en\/cms\/politica-de-privacidad-23","\/registro"]"
  "es"
  1557
]
0.18 ms
(0.22%)
1
"START TRANSACTION"
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\Pais No errors.
App\Entity\TipoDocumento No errors.
App\Entity\PaisTranslation No errors.
App\Entity\TipoDocumentoTranslation No errors.