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,
          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,
          n1_.news_id AS news_id_20
        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
          n1_.cod_lang = ?
          AND n0_.active = 1
          AND n0_.publication_date <= ?
          AND n2_.id = ?
      ) dctrn_result_inner
    ORDER BY
      publication_date_3 DESC
  ) dctrn_result
LIMIT
  24 OFFSET 1752

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, 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, n1_.news_id AS news_id_20 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 n1_.cod_lang = 'cn' AND n0_.active = 1 AND n0_.publication_date <= '2025-10-19 04:47:57' AND n2_.id = 2) dctrn_result_inner ORDER BY publication_date_3 DESC) dctrn_result LIMIT 24 OFFSET 1752;

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,
          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,
          n1_.news_id AS news_id_20
        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
          n1_.cod_lang = ?
          AND n0_.active = 1
          AND n0_.publication_date <= ?
          AND n2_.id = ?
        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, 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, n1_.news_id AS news_id_20 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 n1_.cod_lang = 'cn' AND n0_.active = 1 AND n0_.publication_date <= '2025-10-19 04:47:57' AND n2_.id = 2 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 = 10367 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 = 'cn' AND n2_.id = 10367 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_.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
  n1_.cod_lang = ?
  AND n0_.active = 1
  AND n0_.publication_date <= ?
  AND n2_.id = ?
  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, 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 n1_.cod_lang = 'cn' AND n0_.active = 1 AND n0_.publication_date <= '2025-10-19 04:47:57' AND n2_.id = 2 AND n0_.id IN (10367, 10368, 10366, 10345, 10362, 10354, 10355, 10353, 10350, 10347, 10349, 10348, 10344, 10332, 10340, 10338, 10334, 10331, 10333, 10330, 10324, 10323, 10325, 10321) 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
  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
  n1_.cod_lang = ?
  AND n0_.active = 1
  AND n0_.id = ?

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 n1_.cod_lang = 'cn' AND n0_.active = 1 AND n0_.id = 2;

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