Symfony Profiler

SELECT
  d.id,
  d.peso,
  d.sht as shortName,
  d.nombre,
  d.SLG as slug,
  tt.precioCompra,
  tt.precioVenta,
  d.numDecimales,
  d.MaxDateTime,
  d.redondeoMinimo,
  d.compraMinima,
  d.altFlag
FROM
  cotizaciones tt
  INNER JOIN (
    SELECT
      cot.shortName,
      MAX(dia) AS MaxDateTime,
      d.peso,
      d.id,
      d.numDecimales,
      d.redondeoMinimo,
      d.compraMinima,
      d.shortName as sht,
      di.nombre,
      di.slug as SLG,
      d.altFlag
    FROM
      cotizaciones cot,
      divisa d,
      divisa_translation di
    WHERE
      cot.shortName = d.id
      AND di.locale = "66"
      AND d.visible = 1
      AND d.maestro = 0
      AND di.translatable_id = d.id
    GROUP BY
      cot.shortName
    ORDER BY
      d.peso DESC,
      di.nombre ASC
  ) d ON tt.shortName = d.shortName
  AND tt.dia = d.MaxDateTime
ORDER BY
  d.peso DESC,
  d.nombre ASC

SELECT
				d.id,
				d.peso,
				d.sht as shortName,
				d.nombre,
				d.SLG as slug,
				tt.precioCompra,
				tt.precioVenta,
				d.numDecimales,
				d.MaxDateTime,
				d.redondeoMinimo,
				d.compraMinima,
				d.altFlag
			FROM cotizaciones tt
				INNER JOIN (
				SELECT  cot.shortName, MAX( dia ) AS MaxDateTime,
				        d.peso,
						d.id,
						d.numDecimales,
						d.redondeoMinimo,
						d.compraMinima,
						d.shortName as sht,
						di.nombre,
						di.slug as SLG,
						d.altFlag
 				FROM cotizaciones cot, divisa d, divisa_translation di
				WHERE cot.shortName = d.id
				AND di.locale = "66"
				AND d.visible=1
				AND d.maestro=0
				AND di.translatable_id=d.id
				GROUP BY cot.shortName
				ORDER BY d.peso DESC, di.nombre ASC
			)d ON tt.shortName = d.shortName
			AND tt.dia = d.MaxDateTime
			ORDER BY d.peso DESC, d.nombre ASC;

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 = ?

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

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 = ?

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 = 2;

"COMMIT"

"COMMIT";

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

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

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.visible = ?

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.visible = 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

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 = '10ghhgvh6hm0h0djksa7meugpd' OR u0_.uuid = 'efa2198e-f60a-4f17-a526-e1796e622075' LIMIT 1;

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 = ?
LIMIT
  1

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 = 10 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,
  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

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;

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

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;

INSERT INTO user_stats (
  session_id, uuid, session_start, last_update,
  visited_pages, referer, ip, device,
  country, region, city, zip, locale,
  user
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user_stats (session_id, uuid, session_start, last_update, visited_pages, referer, ip, device, country, region, city, zip, locale, user) VALUES ('10ghhgvh6hm0h0djksa7meugpd', 'efa2198e-f60a-4f17-a526-e1796e622075', '2025-10-30 21:36:57', '2025-10-30 21:36:57', '[\"\\/verCarro\"]', NULL, '216.73.216.144', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', NULL, NULL, NULL, NULL, 'es', NULL);

"START TRANSACTION"

"START TRANSACTION";