Symfony Profiler

SELECT
  dia
FROM
  cotizaciones
WHERE
  oficina = ?
  AND dia = (
    SELECT
      MAX(dia)
    FROM
      cotizaciones
    WHERE
      oficina = ?
  )

SELECT dia
            FROM cotizaciones
            WHERE oficina = 57
            AND dia = (
                SELECT MAX(dia)
                FROM cotizaciones
                WHERE oficina = 57
            );

"COMMIT"

"COMMIT";

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

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 = '2023-11-17' AND c0_.oficina = 57 ORDER BY d1_.peso DESC;

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

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 = 'vs050oll5toeesk78bvig71b6o' OR u0_.uuid = '58b9b954-6fed-44a1-b8a1-1bd598c72cf4' LIMIT 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.slug = ?
  AND t0.locale = ?
LIMIT
  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.slug = 'cambio-moneda-cala-de-mijas' AND t0.locale = 'es' LIMIT 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

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 = 29 LIMIT 1;

UPDATE
  user_stats
SET
  last_update = ?,
  visited_pages = ?,
  locale = ?
WHERE
  id = ?

UPDATE user_stats SET last_update = '2025-10-31 02:19:13', visited_pages = '[\"\\/en\\/currency-exchange-offices\\/murcia\\/mazarron\",\"\\/en\\/exchange-rates\\/de-dolar-estados-unidos-a-euro\",\"\\/oficinas-cambio-moneda\\/malaga\\/marbella\\/casa-de-cambio-de-moneda-en-marbella-puerto-banus\",\"\\/en\\/currency-exchange-offices\\/zaragoza\\/zaragoza\",\"\\/en\\/currency-exchange-offices\\/malaga\\/Calahonda\",\"\\/en\\/currency-exchange-offices\",\"\\/servicios\\/planet-tax-free-32\",\"\\/en\\/currency-exchange-offices\\/alicante\\/benidorm\",\"\\/oficinas-cambio-moneda\\/alicante\\/javea\\/oficina-cambio-divisas-javea-alicante\",\"\\/en\\/currency-exchange-offices\\/alicante\\/javea\",\"\\/en\\/cms\\/eurochange-club-21\",\"\\/oficinas-cambio-moneda\\/murcia\\/los-alcazares\\/cambio-divisas-eurochange-los-alcazares-murcia\",\"\\/en\\/cms\\/anunciantes-30\",\"\\/carro2\",\"\\/oficinas-cambio-moneda\\/bizkaia\\/bilbao\\/casa-de-cambio-de-moneda-en-bilbao\",\"\\/oficinas-cambio-moneda\\/alicante\\/ciudad-quesada\\/cambio-divisas-eurochange-ciudad-quesada-alicante\",\"\\/oficinas-cambio-moneda\\/malaga\\/Calahonda\\/oficina-de-cambio-de-moneda-calahonda\",\"\\/verCarro\",\"\\/en\",\"\\/oficinas-cambio-moneda\\/malaga\\/calle-de-mijas\\/cambio-moneda-cala-de-mijas\"]', locale = 'es' WHERE id = 1564;

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

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 = 29 ORDER BY t0.peso DESC;

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

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 = 'calle-de-mijas' LIMIT 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 = ?
  AND t0.locale = ?
LIMIT
  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 = 57 AND t0.locale = 'es' LIMIT 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

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 = 'malaga' AND t0.locale = 'es' LIMIT 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.id = ?
LIMIT
  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.id = 57 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";