Query Metrics
                227
                Database Queries
            
            
                30
                Different statements
            
            
                73.95 ms
                Query time
            
            
                7
                Invalid entities
            
        Grouped Statements
| Time▼ | Count | Info | 
|---|---|---|
| 15.93 ms (21.55%) | 54 | SELECT t0.id AS id_1, t0.altBanner AS altBanner_2, t0.nombre AS nombre_3, t0.texto1 AS texto1_4, t0.texto2 AS texto2_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.nombrebanco AS nombrebanco_9, t0.mostrarTop AS mostrarTop_10, t0.mostrarFoot AS mostrarFoot_11, t0.slug AS slug_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM divisa_translation t0 WHERE t0.translatable_id = ? 
                                                Parameters:  [
  24
] | 
| 12.64 ms (17.09%) | 54 | SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM imagen t0 WHERE t0.id = ? 
                                                Parameters:  [
  12
] | 
| 12.25 ms (16.56%) | 42 | SELECT t0.id AS id_1, t0.shortName AS shortName_2, t0.altFlag AS altFlag_3, t0.peso AS peso_4, t0.simbolo AS simbolo_5, t0.title AS title_6, t0.bloqueado AS bloqueado_7, t0.maestro AS maestro_8, t0.virtual AS virtual_9, t0.visible AS visible_10, t0.redondeoMinimo AS redondeoMinimo_11, t0.numDecimales AS numDecimales_12, t0.url_organismo_oficial AS url_organismo_oficial_13, t0.compraMinima AS compraMinima_14, t0.imagen_id AS imagen_id_15, t0.banner_id AS banner_id_16 FROM divisa t0 WHERE t0.id = ? 
                                                Parameters:  [
  24
] | 
| 9.37 ms (12.66%) | 42 | SELECT t0.id AS id_1, t0.destino AS destino_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM viaje_translation t0 WHERE t0.translatable_id = ? 
                                                Parameters:  [
  1
] | 
| 4.45 ms (6.02%) | 1 | SELECT dia FROM cotizaciones WHERE oficina = ? AND dia = ( SELECT MAX(dia) FROM cotizaciones WHERE oficina = ? ) 
                                                Parameters:  [ 66 66 ] | 
| 2.75 ms (3.71%) | 1 | SELECT c0_.id AS id_0, c0_.precioCompra AS precioCompra_1, c0_.precioVenta AS precioVenta_2, c0_.dia AS dia_3, c0_.shortName AS shortName_4, c0_.oficina AS oficina_5 FROM cotizaciones c0_, divisa d1_ WHERE c0_.shortName = d1_.id AND d1_.visible = 1 AND c0_.dia = ? AND c0_.oficina = ? ORDER BY d1_.peso DESC 
                                                Parameters:  [ "2023-11-17" 66 ] | 
| 2.42 ms (3.27%) | 1 | "COMMIT"
                                                Parameters:  [] | 
| 1.39 ms (1.89%) | 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:  [ "0leh7kbgd53pq63a2m3vhncp4t" Ramsey\Uuid\Lazy\LazyUuidFromString {#144 : "08266e9e-e1a5-4853-9611-6410398b58ad" } ] | 
| 1.19 ms (1.61%) | 5 | SELECT t0.id AS id_1, t0.descripcion1 AS descripcion1_2, t0.meta_robots AS meta_robots_3, t0.descripcion2 AS descripcion2_4, t0.meta_keywords AS meta_keywords_5, t0.meta_description AS meta_description_6, t0.meta_title AS meta_title_7, t0.slug AS slug_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM divisa_conversion_translation t0 WHERE t0.translatable_id = ? 
                                                Parameters:  [
  42
] | 
| 1.07 ms (1.44%) | 2 | 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:  [] | 
| 0.87 ms (1.17%) | 2 | 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.activo = ? 
                                                Parameters:  [
  1
] | 
| 0.86 ms (1.16%) | 2 | SELECT t0.id AS id_1, t0.peso AS peso_2, t0.cantidadDia AS cantidadDia_3, t0.divisa AS divisa_4 FROM viaje t0 
                                                Parameters:  [] | 
| 0.85 ms (1.15%) | 2 | 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:  [
  45
] | 
| 0.80 ms (1.08%) | 2 | 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" ] | 
| 0.68 ms (0.92%) | 1 | SELECT b0_.id AS id_0, b0_.nombre AS nombre_1, b0_.activo AS activo_2, b0_.zona AS zona_3, b1_.id AS id_4, b1_.fecha_inicio AS fecha_inicio_5, b1_.fecha_fin AS fecha_fin_6, b1_.target AS target_7, b1_.position AS position_8, b1_.locales AS locales_9, b1_.banner_id AS banner_id_10 FROM banner b0_ INNER JOIN banner_item b1_ ON b0_.id = b1_.banner_id WHERE b0_.activo = ? AND b0_.nombre = ? AND (b1_.fecha_inicio < ? AND b1_.fecha_fin > ?) AND b1_.locales LIKE ? ORDER BY b1_.position ASC 
                                                Parameters:  [ 1 "NuestrasOficinas" "2025-10-30 21:41:20" "2025-10-30 21:41:20" "%"es"%" ] | 
| 0.64 ms (0.87%) | 1 | SELECT d0_.id AS id_0, d0_.shortName AS shortName_1, d0_.altFlag AS altFlag_2, d0_.peso AS peso_3, d0_.simbolo AS simbolo_4, d0_.title AS title_5, d0_.bloqueado AS bloqueado_6, d0_.maestro AS maestro_7, d0_.virtual AS virtual_8, d0_.visible AS visible_9, d0_.redondeoMinimo AS redondeoMinimo_10, d0_.numDecimales AS numDecimales_11, d0_.url_organismo_oficial AS url_organismo_oficial_12, d0_.compraMinima AS compraMinima_13, d0_.imagen_id AS imagen_id_14, d0_.banner_id AS banner_id_15 FROM divisa d0_, divisa_translation d1_ WHERE d0_.visible = 1 AND d1_.translatable_id = d0_.id AND d1_.locale = 'es' ORDER BY d0_.peso DESC, d1_.nombre ASC 
                                                Parameters:  [] | 
| 0.58 ms (0.79%) | 1 | SELECT t0.id AS id_1, t0.name AS name_2, t0.list_order AS list_order_3, t0.active AS active_4, t0.idioma AS idioma_5, t0.slug AS slug_6 FROM faq_category t0 WHERE t0.idioma = ? AND t0.active = ? ORDER BY t0.name ASC 
                                                Parameters:  [ "es" "1" ] | 
| 0.51 ms (0.69%) | 1 | 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:  [
  45
] | 
| 0.50 ms (0.68%) | 1 | 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, t7.id AS id_8, t7.nombre AS nombre_9, t7.peso AS peso_10, t7.slug AS slug_11, t7.provincia AS provincia_12 FROM provincia t0 LEFT JOIN localidad t7 ON t7.provincia = t0.id 
                                                Parameters:  [] | 
| 0.49 ms (0.67%) | 1 | 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.provincia = ? AND t0.activo = ? 
                                                Parameters:  [ 45 1 ] | 
| 0.48 ms (0.66%) | 1 | SELECT t0.id AS id_1, t0.indicaciones AS indicaciones_2, t0.alt AS alt_3, t0.serviciosTexto AS serviciosTexto_4, t0.title AS title_5, t0.descripcion AS descripcion_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.meta_title AS meta_title_9, t0.nombre AS nombre_10, t0.slug AS slug_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM oficina_translation t0 WHERE t0.translatable_id = ? 
                                                Parameters:  [
  87
] | 
| 0.45 ms (0.61%) | 1 | 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:  [ "toledo" "es" ] | 
| 0.43 ms (0.58%) | 1 | SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.idioma AS idioma_4, t0.popular AS popular_5, t0.faqcategory_id AS faqcategory_id_6 FROM faq t0 WHERE t0.idioma = ? 
                                                Parameters:  [
  "es"
] | 
| 0.43 ms (0.58%) | 1 | 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.translatable_id = ? 
                                                Parameters:  [
  45
] | 
| 0.39 ms (0.52%) | 1 | SELECT t0.id AS id_1, t0.lunes AS lunes_2, t0.martes AS martes_3, t0.miercoles AS miercoles_4, t0.jueves AS jueves_5, t0.viernes AS viernes_6, t0.sabado AS sabado_7, t0.domingo AS domingo_8, t0.oficina AS oficina_9 FROM franja_dias t0 WHERE t0.oficina = ? 
                                                Parameters:  [
  20
] | 
| 0.37 ms (0.50%) | 1 | SELECT d0_.id AS id_0, d0_.visitas AS visitas_1, d0_.divisaOrigen AS divisaOrigen_2, d0_.divisaDestino AS divisaDestino_3 FROM divisa_conversion d0_ ORDER BY d0_.visitas DESC LIMIT 5 
                                                Parameters:  [] | 
| 0.36 ms (0.49%) | 1 | SELECT t0.id AS id_1, t0.precioCompra AS precioCompra_2, t0.precioVenta AS precioVenta_3, t0.dia AS dia_4, t0.shortName AS shortName_5, t0.oficina AS oficina_6 FROM cotizaciones t0 LIMIT 20 
                                                Parameters:  [] | 
| 0.33 ms (0.45%) | 1 | UPDATE user_stats SET last_update = ?, visited_pages = ? WHERE id = ? 
                                                Parameters:  [ "2025-10-30 21:41:20" "["\/cms\/abre-tu-franquicia-eurochange-28","\/oficinas-cambio-moneda\/islas-baleares","\/oficinas-cambio-moneda\/cordoba\/cordoba","\/oficinas-cambio-moneda\/navarra","\/oficinas-cambio-moneda\/malaga\/fuengirola","\/oficinas-cambio-moneda\/toledo"]" 1561 ] | 
| 0.28 ms (0.38%) | 1 | SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.idioma AS idioma_4, t0.popular AS popular_5, t0.faqcategory_id AS faqcategory_id_6 FROM faq t0 WHERE t0.idioma = ? AND t0.popular = ? 
                                                Parameters:  [ "es" "1" ] | 
| 0.17 ms (0.23%) | 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\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 | 
 | 
| 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 | 
 | 
| 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. | 
| App\Entity\PagoTPV | No errors. | 
| Sonata\MediaBundle\Entity\BaseGallery | No errors. | 
| App\Entity\Galeria | No errors. | 
| App\Entity\DivisaConversion | No errors. | 
| App\Entity\Cupon | 
 | 
| App\Entity\DivisaTranslation | No errors. | 
| App\Entity\FaqCategory | No errors. | 
| App\Entity\Faq | No errors. | 
| App\Entity\DivisaConversionTranslation | No errors. | 
| App\Entity\Viaje | No errors. | 
| App\Entity\ViajeTranslation | No errors. | 
| App\Entity\Banner | No errors. | 
| App\Entity\BannerItem | No errors. | 
| App\Entity\BannerItemTranslation | No errors. |