Query Metrics
6
Database Queries
6
Different statements
5.90 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.65 ms (44.89%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.69 ms (28.60%) |
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:
[ "c58a38qo6oppv2kustlr1lk5e0" Ramsey\Uuid\Lazy\LazyUuidFromString {#144 : "08bfd112-8231-47cf-8498-23c33faede9d" } ] |
|
0.50 ms (8.43%) |
1 |
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:
[
11
]
|
|
0.44 ms (7.41%) |
1 |
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.id = ? AND t0.tipo IN ('servicio') LIMIT 1
Parameters:
[ 1 11 ] |
|
0.39 ms (6.60%) |
1 |
UPDATE user_stats SET last_update = ?, visited_pages = ?, locale = ? WHERE id = ?
Parameters:
[ "2025-10-31 02:27:18" "["\/en\/exchange-rates\/de-libra-esterlina-a-euro","\/oficinas-cambio-moneda\/alicante\/torrevieja\/cambio-divisas-eurochange-torrevieja-alicante","\/oficinas-cambio-moneda\/alicante\/la-zenia\/cambio-divisas-eurochange-la-zenia-alicante","\/en\/currency-exchange-offices\/barcelona","\/oficinas-cambio-moneda\/alicante\/benidorm\/tienda-online","\/en\/currency-exchange-offices\/murcia","\/oficinas-cambio-moneda\/alicante\/benidorm\/eurochange-cambio-divisas-avenida-mediterraneo-benidorm-alicante","\/en\/currency-exchange-offices\/alicante\/campoamor","\/en\/exchange-rates\/de-euro-a-libra-esterlina","\/servicios\/pago-de-tax-free-11"]" "es" 1579 ] |
|
0.24 ms (4.07%) |
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 |
|
| App\Entity\Reserva | No errors. |
| App\Entity\Transaccion |
|
| App\Entity\Oficina |
|
| App\Entity\Provincia | No errors. |
| App\Entity\Localidad |
|
| 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\PaginaTranslation | No errors. |
| App\Entity\HomeTranslation | No errors. |
| App\Entity\ContenidoServicioTranslation | No errors. |