Query Metrics
6
Database Queries
6
Different statements
5.43 ms
Query time
5
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.50 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:
[ "jcvclp2n9iqg4torgn0gm6e2m0" Ramsey\Uuid\Lazy\LazyUuidFromString {#144 : "bc017de8-929c-4a83-820f-060000e9d791" } ] |
| 2 | 0.19 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 0.42 ms |
UPDATE user_stats SET last_update = ?, visited_pages = ? WHERE id = ?
Parameters:
[ "2025-10-31 08:45:28" "["\/cotizaciones\/peso-mexicano","\/cotizaciones\/libra-esterlina","\/cotizaciones\/dolar-taiwanes","\/cotizaciones\/riyal-de-arabia-saudita","\/en\/currency-exchange-offices\/alicante\/benidorm\/eurochange-currency-money-avenida-mediterraneo-benidorm-alicante","\/cotizaciones\/real-brasileo","\/cotizaciones\/dolar-singapur","\/en\/currency-exchange-offices\/alicante\/santa-pola\/change-money-eurochange-santa-pola-alicante","\/cotizaciones\/kwd-billete","\/cotizaciones\/riyal-catari","\/en\/currency-exchange-offices\/alicante\/la-zenia\/change-money-eurochange-la-zenia-alicante","\/cotizaciones\/rupia-indonesia","\/en\/currency-exchange-offices\/alicante\/torrevieja\/change-money-eurochange-torrevieja-alicante","\/cotizaciones\/peso-dominicano","\/cotizaciones\/corona-islandesa","\/cotizaciones\/lek-albanes","\/login"]" 1582 ] |
| 4 | 2.22 ms |
"COMMIT"
Parameters:
[] |
| 5 | 0.41 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" ] |
| 6 | 0.68 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 |
|
| 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\TransaccionAfiliado | No errors. |
| App\Entity\Alerta | 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. |
| 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 |
|
| App\Entity\OficinaTranslation | No errors. |
| App\Entity\ProvinciaTranslation | No errors. |
| App\Entity\LocalidadTranslation | No errors. |
| Sonata\MediaBundle\Entity\BaseGalleryItem | No errors. |
| App\Entity\ImagenxGaleria | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\MenuItem | No errors. |
| App\Entity\MenuItemTranslation | No errors. |