Symfony Profiler

SELECT
  n0_.id AS id_0,
  n0_.date_created AS date_created_1,
  n0_.date_modified AS date_modified_2,
  n0_.publication_date AS publication_date_3,
  n0_.video1 AS video1_4,
  n0_.video2 AS video2_5,
  n0_.besoccer_id AS besoccer_id_6,
  n0_.kaltura_id AS kaltura_id_7,
  n0_.active AS active_8,
  n1_.title AS title_9,
  n1_.cod_lang AS cod_lang_10,
  n1_.text AS text_11,
  n1_.seo_title AS seo_title_12,
  n1_.seo_description AS seo_description_13,
  n1_.subtitle AS subtitle_14,
  n2_.id AS id_15,
  n2_.date_created AS date_created_16,
  n2_.date_modified AS date_modified_17,
  n2_.sort AS sort_18,
  n2_.active AS active_19,
  n0_.banner_id AS banner_id_20,
  n0_.banner2_id AS banner2_id_21,
  n1_.news_id AS news_id_22,
  n2_.banner_id AS banner_id_23
FROM
  news n0_
  LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id
  INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_id
  INNER JOIN news_category n2_ ON n2_.id = n3_.news_category_id
WHERE
  COALESCE(n1_.title, '') <> ''
  AND n1_.cod_lang = ?
  AND n0_.active = 1
  AND n2_.id = ?
  AND n0_.publication_date <= ?
  AND n0_.id <> 4164
ORDER BY
  n0_.publication_date DESC
LIMIT
  5

SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.publication_date AS publication_date_3, n0_.video1 AS video1_4, n0_.video2 AS video2_5, n0_.besoccer_id AS besoccer_id_6, n0_.kaltura_id AS kaltura_id_7, n0_.active AS active_8, n1_.title AS title_9, n1_.cod_lang AS cod_lang_10, n1_.text AS text_11, n1_.seo_title AS seo_title_12, n1_.seo_description AS seo_description_13, n1_.subtitle AS subtitle_14, n2_.id AS id_15, n2_.date_created AS date_created_16, n2_.date_modified AS date_modified_17, n2_.sort AS sort_18, n2_.active AS active_19, n0_.banner_id AS banner_id_20, n0_.banner2_id AS banner2_id_21, n1_.news_id AS news_id_22, n2_.banner_id AS banner_id_23 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_id INNER JOIN news_category n2_ ON n2_.id = n3_.news_category_id WHERE COALESCE(n1_.title, '') <> '' AND n1_.cod_lang = 'ca' AND n0_.active = 1 AND n2_.id = 2 AND n0_.publication_date <= '2025-10-19 14:45:07' AND n0_.id <> 4164 ORDER BY n0_.publication_date DESC LIMIT 5;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.extension AS extension_2,
  f0_.date_created AS date_created_3,
  f0_.date_modified AS date_modified_4,
  f0_.size AS size_5,
  f0_.itemId AS itemId_6,
  f0_.section AS section_7,
  f0_.type AS type_8,
  f0_.sort AS sort_9
FROM
  file f0_
WHERE
  f0_.itemId = ?
  AND f0_.section = ?
  AND f0_.type = ?
ORDER BY
  f0_.sort ASC
LIMIT
  1

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 14278 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.date_created AS date_created_1,
  n0_.date_modified AS date_modified_2,
  n0_.sort AS sort_3,
  n0_.active AS active_4,
  n1_.name AS name_5,
  n1_.cod_lang AS cod_lang_6,
  n0_.banner_id AS banner_id_7,
  n1_.news_category_id AS news_category_id_8
FROM
  news_category n0_
  INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id
  INNER JOIN news n2_ ON n2_.id = n3_.news_id
  LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id
WHERE
  n1_.cod_lang = ?
  AND n2_.id = ?
ORDER BY
  n0_.sort ASC

SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = 'ca' AND n2_.id = 4164 ORDER BY n0_.sort ASC;

SELECT
  title,
  subtitle,
  text,
  seo_title AS seoTitle,
  seo_description AS seoDescription
FROM
  news_i18n
WHERE
  news_id = :news_id
  AND cod_lang = :cod_lang

SELECT title, subtitle, text, seo_title AS seoTitle,
                 seo_description AS seoDescription
          FROM news_i18n 
          WHERE news_id = 4164
            AND cod_lang = 'es';

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.extension AS extension_2,
  f0_.date_created AS date_created_3,
  f0_.date_modified AS date_modified_4,
  f0_.size AS size_5,
  f0_.itemId AS itemId_6,
  f0_.section AS section_7,
  f0_.type AS type_8,
  f0_.sort AS sort_9
FROM
  file f0_
WHERE
  f0_.itemId = ?
  AND f0_.section = ?
  AND f0_.type = ?
ORDER BY
  f0_.sort ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 4164 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC;

SELECT
  n0_.id AS id_0,
  n0_.date_created AS date_created_1,
  n0_.date_modified AS date_modified_2,
  n0_.publication_date AS publication_date_3,
  n0_.video1 AS video1_4,
  n0_.video2 AS video2_5,
  n0_.besoccer_id AS besoccer_id_6,
  n0_.kaltura_id AS kaltura_id_7,
  n0_.active AS active_8,
  n1_.title AS title_9,
  n1_.cod_lang AS cod_lang_10,
  n1_.text AS text_11,
  n1_.seo_title AS seo_title_12,
  n1_.seo_description AS seo_description_13,
  n1_.subtitle AS subtitle_14,
  n2_.id AS id_15,
  n2_.date_created AS date_created_16,
  n2_.date_modified AS date_modified_17,
  n2_.sort AS sort_18,
  n2_.active AS active_19,
  n3_.name AS name_20,
  n3_.cod_lang AS cod_lang_21,
  n0_.banner_id AS banner_id_22,
  n0_.banner2_id AS banner2_id_23,
  n1_.news_id AS news_id_24,
  n2_.banner_id AS banner_id_25,
  n3_.news_category_id AS news_category_id_26
FROM
  news n0_
  LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id
  LEFT JOIN news_news_category n4_ ON n0_.id = n4_.news_id
  LEFT JOIN news_category n2_ ON n2_.id = n4_.news_category_id
  LEFT JOIN news_category_i18n n3_ ON n2_.id = n3_.news_category_id
WHERE
  COALESCE(n1_.title, '') <> ''
  AND n1_.cod_lang = ?
  AND n0_.id = ?
  AND n0_.active = 1
  AND n2_.active = 1
  AND n0_.publication_date <= ?
  AND n3_.cod_lang = ?

SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.publication_date AS publication_date_3, n0_.video1 AS video1_4, n0_.video2 AS video2_5, n0_.besoccer_id AS besoccer_id_6, n0_.kaltura_id AS kaltura_id_7, n0_.active AS active_8, n1_.title AS title_9, n1_.cod_lang AS cod_lang_10, n1_.text AS text_11, n1_.seo_title AS seo_title_12, n1_.seo_description AS seo_description_13, n1_.subtitle AS subtitle_14, n2_.id AS id_15, n2_.date_created AS date_created_16, n2_.date_modified AS date_modified_17, n2_.sort AS sort_18, n2_.active AS active_19, n3_.name AS name_20, n3_.cod_lang AS cod_lang_21, n0_.banner_id AS banner_id_22, n0_.banner2_id AS banner2_id_23, n1_.news_id AS news_id_24, n2_.banner_id AS banner_id_25, n3_.news_category_id AS news_category_id_26 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id LEFT JOIN news_news_category n4_ ON n0_.id = n4_.news_id LEFT JOIN news_category n2_ ON n2_.id = n4_.news_category_id LEFT JOIN news_category_i18n n3_ ON n2_.id = n3_.news_category_id WHERE COALESCE(n1_.title, '') <> '' AND n1_.cod_lang = 'ca' AND n0_.id = 4164 AND n0_.active = 1 AND n2_.active = 1 AND n0_.publication_date <= '2025-10-19 14:45:07' AND n3_.cod_lang = 'ca';

SELECT
  title,
  link
FROM
  news_category_banner_i18n
WHERE
  news_category_banner_id = :news_category_banner_id
  AND cod_lang = :cod_lang

SELECT title, link
          FROM news_category_banner_i18n 
          WHERE news_category_banner_id = 3
            AND cod_lang = 'ca';

SELECT
  t0_.id AS id_0,
  t0_.date_created AS date_created_1,
  t0_.date_modified AS date_modified_2,
  t0_.sort AS sort_3,
  t0_.active AS active_4,
  t0_.besoccer_id AS besoccer_id_5,
  t0_.league_besoccer_id AS league_besoccer_id_6,
  t0_.group_id AS group_id_7,
  t0_.gender AS gender_8,
  t0_.summary AS summary_9,
  t0_.base AS base_10,
  t1_.name AS name_11,
  t1_.cod_lang AS cod_lang_12,
  t1_.stadium AS stadium_13,
  t0_.category_team_id AS category_team_id_14,
  t1_.team_id AS team_id_15
FROM
  team t0_
  LEFT JOIN team_i18n t1_ ON t0_.id = t1_.team_id
WHERE
  t0_.active = 1
  AND t1_.cod_lang = ?
  AND t0_.sort IS NOT NULL
ORDER BY
  t0_.sort ASC,
  t1_.cod_lang ASC

SELECT t0_.id AS id_0, t0_.date_created AS date_created_1, t0_.date_modified AS date_modified_2, t0_.sort AS sort_3, t0_.active AS active_4, t0_.besoccer_id AS besoccer_id_5, t0_.league_besoccer_id AS league_besoccer_id_6, t0_.group_id AS group_id_7, t0_.gender AS gender_8, t0_.summary AS summary_9, t0_.base AS base_10, t1_.name AS name_11, t1_.cod_lang AS cod_lang_12, t1_.stadium AS stadium_13, t0_.category_team_id AS category_team_id_14, t1_.team_id AS team_id_15 FROM team t0_ LEFT JOIN team_i18n t1_ ON t0_.id = t1_.team_id WHERE t0_.active = 1 AND t1_.cod_lang = 'ca' AND t0_.sort IS NOT NULL ORDER BY t0_.sort ASC, t1_.cod_lang ASC;

(
  SELECT
    *
  FROM
    sponsor_header
  WHERE
    fixed = 1
    AND active = 1
  ORDER BY
    sort
  LIMIT
    1
)
UNION
  (
    SELECT
      *
    FROM
      sponsor_header
    WHERE
      fixed <> 1
      AND active = 1
    ORDER BY
      RAND()
      /* , sort ASC Si queremos la característica de que dentro de los 2 escogidos al azar se respete el orden asignado por el cliente  15/06/2022: Ahora sólo será 1 escogido al azar */
    LIMIT
      2
  )

(SELECT * 
                FROM sponsor_header
                WHERE fixed = 1 AND active = 1
                ORDER BY sort
                LIMIT 1)
            UNION
                (SELECT * 
                FROM sponsor_header
                WHERE fixed <> 1 AND active = 1
                ORDER BY RAND() /* , sort ASC Si queremos la característica de que dentro de los 2 escogidos al azar se respete el orden asignado por el cliente  15/06/2022: Ahora sólo será 1 escogido al azar */
                LIMIT 2)
        ;

SELECT
  n0_.id AS id_0,
  n0_.date_created AS date_created_1,
  n0_.date_modified AS date_modified_2,
  n0_.sort AS sort_3,
  n0_.active AS active_4,
  n1_.name AS name_5,
  n1_.cod_lang AS cod_lang_6,
  n0_.banner_id AS banner_id_7,
  n1_.news_category_id AS news_category_id_8
FROM
  news_category n0_
  LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id
WHERE
  n0_.active = 1
  AND n1_.cod_lang = ?
ORDER BY
  n0_.sort ASC

SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n0_.active = 1 AND n1_.cod_lang = 'ca' ORDER BY n0_.sort ASC;

SELECT
  s0_.id AS id_0,
  s0_.date_created AS date_created_1,
  s0_.date_modified AS date_modified_2,
  s0_.sort AS sort_3,
  s0_.active AS active_4,
  s0_.highlighted AS highlighted_5,
  s0_.hide_by_ip AS hide_by_ip_6,
  s1_.link AS link_7,
  s1_.title AS title_8,
  s1_.cod_lang AS cod_lang_9,
  s0_.category_sponsor_id AS category_sponsor_id_10,
  s1_.sponsor_id AS sponsor_id_11
FROM
  sponsor s0_
  LEFT JOIN sponsor_i18n s1_ ON s0_.id = s1_.sponsor_id
WHERE
  s0_.highlighted = 1
  AND s0_.active = 1
  AND s1_.cod_lang = ?
ORDER BY
  s0_.sort ASC

SELECT s0_.id AS id_0, s0_.date_created AS date_created_1, s0_.date_modified AS date_modified_2, s0_.sort AS sort_3, s0_.active AS active_4, s0_.highlighted AS highlighted_5, s0_.hide_by_ip AS hide_by_ip_6, s1_.link AS link_7, s1_.title AS title_8, s1_.cod_lang AS cod_lang_9, s0_.category_sponsor_id AS category_sponsor_id_10, s1_.sponsor_id AS sponsor_id_11 FROM sponsor s0_ LEFT JOIN sponsor_i18n s1_ ON s0_.id = s1_.sponsor_id WHERE s0_.highlighted = 1 AND s0_.active = 1 AND s1_.cod_lang = 'ca' ORDER BY s0_.sort ASC;

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.active AS active_2,
  s0_.sort AS sort_3,
  s0_.date_created AS date_created_4,
  s0_.date_modified AS date_modified_5,
  s1_.title AS title_6,
  s1_.second_title AS second_title_7,
  s1_.description AS description_8,
  s1_.seo_title AS seo_title_9,
  s1_.seo_description AS seo_description_10,
  s1_.cod_lang AS cod_lang_11,
  s0_.parent_id AS parent_id_12,
  s1_.section_id AS section_id_13
FROM
  section s0_
  LEFT JOIN section_i18n s1_ ON s0_.id = s1_.section_id
WHERE
  s1_.cod_lang = ?
  AND s0_.active = 1
  AND s0_.code = ?

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.active AS active_2, s0_.sort AS sort_3, s0_.date_created AS date_created_4, s0_.date_modified AS date_modified_5, s1_.title AS title_6, s1_.second_title AS second_title_7, s1_.description AS description_8, s1_.seo_title AS seo_title_9, s1_.seo_description AS seo_description_10, s1_.cod_lang AS cod_lang_11, s0_.parent_id AS parent_id_12, s1_.section_id AS section_id_13 FROM section s0_ LEFT JOIN section_i18n s1_ ON s0_.id = s1_.section_id WHERE s1_.cod_lang = 'ca' AND s0_.active = 1 AND s0_.code = 'news';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.extension AS extension_3,
  t0.date_created AS date_created_4,
  t0.date_modified AS date_modified_5,
  t0.size AS size_6,
  t0.itemId AS itemId_7,
  t0.section AS section_8,
  t0.type AS type_9,
  t0.sort AS sort_10
FROM
  file t0
WHERE
  t0.itemId = ?
  AND t0.section = ?
  AND t0.type = ?
ORDER BY
  t0.sort ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.size AS size_6, t0.itemId AS itemId_7, t0.section AS section_8, t0.type AS type_9, t0.sort AS sort_10 FROM file t0 WHERE t0.itemId = 3 AND t0.section = 'newscategorybanner' AND t0.type = 'image_ca' ORDER BY t0.sort ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date_created AS date_created_2,
  t0.date_modified AS date_modified_3,
  t0.kaltura_id AS kaltura_id_4,
  t0.active AS active_5
FROM
  audio t0
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_modified AS date_modified_3, t0.kaltura_id AS kaltura_id_4, t0.active AS active_5 FROM audio t0 WHERE t0.active = 1 LIMIT 1;