Symfony Profiler

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

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;

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

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

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 = 'sincfdg2359nir29staq7t4rbu' OR u0_.uuid = 'a9339f2a-289a-4f12-b506-e76f6cb7ee25' LIMIT 1;

SELECT
  c.precioCompra,
  c.precioVenta,
  c.dia,
  d.title
FROM
  cotizaciones c,
  divisa d
WHERE
  c.dia >= DATE_ADD(
    LAST_DAY(
      DATE_SUB(
        NOW(),
        INTERVAL 2 MONTH
      )
    ),
    INTERVAL 1 DAY
  )
  AND d.id = c.shortName
  AND d.id = ?
  AND c.oficina = ?
ORDER BY
  c.dia ASC

SELECT c.precioCompra, c.precioVenta, c.dia, d.title
                FROM cotizaciones c, divisa d
                WHERE c.dia >= DATE_ADD( LAST_DAY( DATE_SUB( NOW( ) , INTERVAL 2 MONTH ) ) , INTERVAL 1 DAY )
                AND d.id=c.shortName
                AND d.id= 16
                AND c.oficina= 0
                ORDER BY c.dia ASC;

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

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

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

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

"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 = 66 ORDER BY d1_.peso DESC;

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

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

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

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

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 ('sincfdg2359nir29staq7t4rbu', 'a9339f2a-289a-4f12-b506-e76f6cb7ee25', '2025-10-30 21:26:21', '2025-10-30 21:26:22', '[\"\\/cotizaciones\\/de-euro-a-corona-noruega\"]', 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);

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

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;

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

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 = 1 AND m0_.zona = 'principal';

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

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;

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

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;

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.slug = ?
  AND t0.locale = ?
LIMIT
  1

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.slug = 'de-euro-a-corona-noruega' AND t0.locale = 'es' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.posicion AS posicion_3,
  t0.tipo_cookies AS tipo_cookies_4,
  t0.codigo AS codigo_5,
  t0.activo AS activo_6
FROM
  cookies t0
WHERE
  t0.tipo_cookies = ?
  AND t0.activo = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.posicion AS posicion_3, t0.tipo_cookies AS tipo_cookies_4, t0.codigo AS codigo_5, t0.activo AS activo_6 FROM cookies t0 WHERE t0.tipo_cookies = 'preferencias' AND t0.activo = 1 LIMIT 1;

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.slug = ?
  AND t0.locale = ?
LIMIT
  1

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.slug = 'de-euro-a-corona-noruega' AND t0.locale = 'es' 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

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;

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_

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_;

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

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 = 'es' AND t0.popular = '1';

SELECT
  o0_.id AS id_0,
  o0_.nombre AS nombre_1,
  o0_.alt AS alt_2,
  o0_.latitud AS latitud_3,
  o0_.longitud AS longitud_4,
  o0_.telefono AS telefono_5,
  o0_.direccion AS direccion_6,
  o0_.codigo_postal AS codigo_postal_7,
  o0_.peso AS peso_8,
  o0_.activo AS activo_9,
  o0_.url_google AS url_google_10,
  o0_.provincia AS provincia_11,
  o0_.localidad AS localidad_12,
  o0_.oficinaERP AS oficinaERP_13,
  o0_.imagen_id AS imagen_id_14,
  o0_.imagen_mapa_id AS imagen_mapa_id_15
FROM
  oficina o0_

SELECT o0_.id AS id_0, o0_.nombre AS nombre_1, o0_.alt AS alt_2, o0_.latitud AS latitud_3, o0_.longitud AS longitud_4, o0_.telefono AS telefono_5, o0_.direccion AS direccion_6, o0_.codigo_postal AS codigo_postal_7, o0_.peso AS peso_8, o0_.activo AS activo_9, o0_.url_google AS url_google_10, o0_.provincia AS provincia_11, o0_.localidad AS localidad_12, o0_.oficinaERP AS oficinaERP_13, o0_.imagen_id AS imagen_id_14, o0_.imagen_mapa_id AS imagen_mapa_id_15 FROM oficina o0_;

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;

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

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 = 'es';

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

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 = 'es' AND t0.active = '1' ORDER BY t0.name ASC;

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 = '2'
ORDER BY
  m0_.path ASC