Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      publication_date_3
    FROM
      (
        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,
          n1_.news_id AS news_id_15
        FROM
          news n0_
          LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id
        WHERE
          COALESCE(n1_.title, '') <> ''
          AND n0_.active = 1
          AND n0_.publication_date <= ?
          AND n1_.cod_lang = ?
      ) dctrn_result_inner
    ORDER BY
      publication_date_3 DESC
  ) dctrn_result
LIMIT
  24 OFFSET 576

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, publication_date_3 FROM (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, n1_.news_id AS news_id_15 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id WHERE COALESCE(n1_.title, '') <> '' AND n0_.active = 1 AND n0_.publication_date <= '2025-10-19 04:54:09' AND n1_.cod_lang = 'cn') dctrn_result_inner ORDER BY publication_date_3 DESC) dctrn_result LIMIT 24 OFFSET 576;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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,
          n1_.news_id AS news_id_15
        FROM
          news n0_
          LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id
        WHERE
          COALESCE(n1_.title, '') <> ''
          AND n0_.active = 1
          AND n0_.publication_date <= ?
          AND n1_.cod_lang = ?
        ORDER BY
          n0_.publication_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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, n1_.news_id AS news_id_15 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id WHERE COALESCE(n1_.title, '') <> '' AND n0_.active = 1 AND n0_.publication_date <= '2025-10-19 04:54:09' AND n1_.cod_lang = 'cn' ORDER BY n0_.publication_date DESC) dctrn_result) dctrn_table;

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 = 9504 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.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.sort AS sort_4,
  t0.active AS active_5,
  t0.banner_id AS banner_id_6
FROM
  news_category t0
  INNER JOIN news_news_category ON t0.id = news_news_category.news_category_id
WHERE
  news_news_category.news_id = ?

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_modified AS date_modified_3, t0.sort AS sort_4, t0.active AS active_5, t0.banner_id AS banner_id_6 FROM news_category t0 INNER JOIN news_news_category ON t0.id = news_news_category.news_category_id WHERE news_news_category.news_id = 9504;

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,
  n0_.banner_id AS banner_id_15,
  n0_.banner2_id AS banner2_id_16,
  n1_.news_id AS news_id_17
FROM
  news n0_
  LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id
WHERE
  COALESCE(n1_.title, '') <> ''
  AND n0_.active = 1
  AND n0_.publication_date <= ?
  AND n1_.cod_lang = ?
  AND n0_.id IN (?)
ORDER BY
  n0_.publication_date DESC

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, n0_.banner_id AS banner_id_15, n0_.banner2_id AS banner2_id_16, n1_.news_id AS news_id_17 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id WHERE COALESCE(n1_.title, '') <> '' AND n0_.active = 1 AND n0_.publication_date <= '2025-10-19 04:54:09' AND n1_.cod_lang = 'cn' AND n0_.id IN (9504, 9505, 9449, 9503, 9501, 9496, 9486, 9485, 9463, 9455, 9453, 9451, 9448, 9436, 9421, 9411, 9385, 9397, 9396, 9381, 9378, 9366, 9362, 9354) ORDER BY n0_.publication_date DESC;

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 = 'cn' AND t0_.sort IS NOT NULL ORDER BY t0_.sort ASC, t1_.cod_lang 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 = 'cn' AND s0_.active = 1 AND s0_.code = 'news';

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 = 'cn' ORDER BY n0_.sort 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
  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 = 'cn' ORDER BY s0_.sort ASC;

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;