Symfony Profiler

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;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE user_stats SET last_update = '2025-10-31 02:19:14', 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\",\"\\/en\\/cms\\/contacto-24\"]', locale = 'en' WHERE id = 1564;

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.estado AS estado_1,
  c0_.fecha_alta AS fecha_alta_2,
  c0_.fecha_modificacion AS fecha_modificacion_3,
  c0_.fecha_publicacion AS fecha_publicacion_4,
  c0_.locales AS locales_5,
  c0_.error AS error_6,
  c0_.clave AS clave_7,
  c0_.position AS position_8,
  c0_.tipo AS tipo_9,
  c0_.imagen_id AS imagen_id_10,
  c0_.galeria_id AS galeria_id_11,
  c0_.ruta_id AS ruta_id_12
FROM
  contenido c0_
WHERE
  (
    (
      c0_.id = ?
      AND c0_.locales LIKE ?
    )
    AND c0_.tipo IN (?)
    AND c0_.estado = ?
  )
  AND c0_.tipo IN (
    'contenido', 'pagina', 'home', 'servicio'
  )

SELECT c0_.id AS id_0, c0_.estado AS estado_1, c0_.fecha_alta AS fecha_alta_2, c0_.fecha_modificacion AS fecha_modificacion_3, c0_.fecha_publicacion AS fecha_publicacion_4, c0_.locales AS locales_5, c0_.error AS error_6, c0_.clave AS clave_7, c0_.position AS position_8, c0_.tipo AS tipo_9, c0_.imagen_id AS imagen_id_10, c0_.galeria_id AS galeria_id_11, c0_.ruta_id AS ruta_id_12 FROM contenido c0_ WHERE ((c0_.id = 24 AND c0_.locales LIKE '%\"en\"%') AND c0_.tipo IN ('Pagina') AND c0_.estado = 1) AND c0_.tipo IN ('contenido', 'pagina', 'home', 'servicio');

SELECT
  t0.id AS id_1,
  t0.titulo AS titulo_2,
  t0.texto AS texto_3,
  t0.intro AS intro_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.meta_robots AS meta_robots_8,
  t0.canonical AS canonical_9,
  t0.config AS config_10,
  t0.slug AS slug_11,
  t0.locale AS locale_12,
  t0.imagen_cabecera_id AS imagen_cabecera_id_13,
  t0.translatable_id AS translatable_id_14,
  t0.tipo
FROM
  contenido_translation t0
WHERE
  t0.translatable_id = ?
  AND t0.tipo IN (
    'contenido', 'pagina', 'home', 'servicio'
  )

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.texto AS texto_3, t0.intro AS intro_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.meta_keywords AS meta_keywords_7, t0.meta_robots AS meta_robots_8, t0.canonical AS canonical_9, t0.config AS config_10, t0.slug AS slug_11, t0.locale AS locale_12, t0.imagen_cabecera_id AS imagen_cabecera_id_13, t0.translatable_id AS translatable_id_14, t0.tipo FROM contenido_translation t0 WHERE t0.translatable_id = 24 AND t0.tipo IN ('contenido', 'pagina', 'home', 'servicio');

SELECT
  t0.id AS id_1
FROM
  ruta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM ruta t0 WHERE t0.id = 'pagina_url';

SELECT
  t0.id AS id_1,
  t0.ruta AS ruta_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.meta_keywords AS meta_keywords_5,
  t0.locale AS locale_6,
  t0.translatable_id AS translatable_id_7
FROM
  ruta_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.ruta AS ruta_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM ruta_translation t0 WHERE t0.translatable_id = 'pagina_url';

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

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

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

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