Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.datum AS datum_1,
          p0_.url AS url_2,
          p0_.title AS title_3,
          p0_.foto AS foto_4,
          p0_.status AS status_5,
          p0_.subtitle AS subtitle_6,
          p0_.scientists AS scientists_7,
          p0_.tags AS tags_8,
          p0_.pdffile AS pdffile_9,
          p0_.challange AS challange_10,
          p0_.technology AS technology_11,
          p0_.opportunity AS opportunity_12,
          p0_.develstatus AS develstatus_13,
          p0_.categories2 AS categories2_14,
          p0_.readings AS readings_15,
          p0_.created AS created_16,
          p0_.updated AS updated_17,
          p0_.published AS published_18
        FROM
          project p0_
        WHERE
          p0_.published IS NOT NULL
          AND p0_.published <= ?
        ORDER BY
          p0_.datum DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.datum AS datum_1, p0_.url AS url_2, p0_.title AS title_3, p0_.foto AS foto_4, p0_.status AS status_5, p0_.subtitle AS subtitle_6, p0_.scientists AS scientists_7, p0_.tags AS tags_8, p0_.pdffile AS pdffile_9, p0_.challange AS challange_10, p0_.technology AS technology_11, p0_.opportunity AS opportunity_12, p0_.develstatus AS develstatus_13, p0_.categories2 AS categories2_14, p0_.readings AS readings_15, p0_.created AS created_16, p0_.updated AS updated_17, p0_.published AS published_18 FROM project p0_ WHERE p0_.published IS NOT NULL AND p0_.published <= '2026-02-05 10:09:16' ORDER BY p0_.datum DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lang AS lang_3,
  t0.url AS url_4,
  t0.created AS created_5,
  t0.updated AS updated_6,
  t0.published AS published_7,
  t0.meta AS meta_8,
  t0.metaimage AS metaimage_9
FROM
  page t0
WHERE
  t0.url = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.lang AS lang_3, t0.url AS url_4, t0.created AS created_5, t0.updated AS updated_6, t0.published AS published_7, t0.meta AS meta_8, t0.metaimage AS metaimage_9 FROM page t0 WHERE t0.url = 'projects' AND t0.lang = 'en' LIMIT 1;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      datum_1
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.datum AS datum_1,
          p0_.url AS url_2,
          p0_.title AS title_3,
          p0_.foto AS foto_4,
          p0_.status AS status_5,
          p0_.subtitle AS subtitle_6,
          p0_.scientists AS scientists_7,
          p0_.tags AS tags_8,
          p0_.pdffile AS pdffile_9,
          p0_.challange AS challange_10,
          p0_.technology AS technology_11,
          p0_.opportunity AS opportunity_12,
          p0_.develstatus AS develstatus_13,
          p0_.categories2 AS categories2_14,
          p0_.readings AS readings_15,
          p0_.created AS created_16,
          p0_.updated AS updated_17,
          p0_.published AS published_18
        FROM
          project p0_
        WHERE
          p0_.published IS NOT NULL
          AND p0_.published <= ?
      ) dctrn_result_inner
    ORDER BY
      datum_1 DESC
  ) dctrn_result
LIMIT
  999999

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, datum_1 FROM (SELECT p0_.id AS id_0, p0_.datum AS datum_1, p0_.url AS url_2, p0_.title AS title_3, p0_.foto AS foto_4, p0_.status AS status_5, p0_.subtitle AS subtitle_6, p0_.scientists AS scientists_7, p0_.tags AS tags_8, p0_.pdffile AS pdffile_9, p0_.challange AS challange_10, p0_.technology AS technology_11, p0_.opportunity AS opportunity_12, p0_.develstatus AS develstatus_13, p0_.categories2 AS categories2_14, p0_.readings AS readings_15, p0_.created AS created_16, p0_.updated AS updated_17, p0_.published AS published_18 FROM project p0_ WHERE p0_.published IS NOT NULL AND p0_.published <= '2026-02-05 10:09:16') dctrn_result_inner ORDER BY datum_1 DESC) dctrn_result LIMIT 999999;

SELECT
  p0_.id AS id_0,
  p0_.datum AS datum_1,
  p0_.url AS url_2,
  p0_.title AS title_3,
  p0_.foto AS foto_4,
  p0_.status AS status_5,
  p0_.subtitle AS subtitle_6,
  p0_.scientists AS scientists_7,
  p0_.tags AS tags_8,
  p0_.pdffile AS pdffile_9,
  p0_.challange AS challange_10,
  p0_.technology AS technology_11,
  p0_.opportunity AS opportunity_12,
  p0_.develstatus AS develstatus_13,
  p0_.categories2 AS categories2_14,
  p0_.readings AS readings_15,
  p0_.created AS created_16,
  p0_.updated AS updated_17,
  p0_.published AS published_18
FROM
  project p0_
WHERE
  p0_.published IS NOT NULL
  AND p0_.published <= ?
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.datum DESC

SELECT p0_.id AS id_0, p0_.datum AS datum_1, p0_.url AS url_2, p0_.title AS title_3, p0_.foto AS foto_4, p0_.status AS status_5, p0_.subtitle AS subtitle_6, p0_.scientists AS scientists_7, p0_.tags AS tags_8, p0_.pdffile AS pdffile_9, p0_.challange AS challange_10, p0_.technology AS technology_11, p0_.opportunity AS opportunity_12, p0_.develstatus AS develstatus_13, p0_.categories2 AS categories2_14, p0_.readings AS readings_15, p0_.created AS created_16, p0_.updated AS updated_17, p0_.published AS published_18 FROM project p0_ WHERE p0_.published IS NOT NULL AND p0_.published <= '2026-02-05 10:09:16' AND p0_.id IN (4, 5, 13, 14, 15, 16, 17, 10) ORDER BY p0_.datum DESC;

SELECT
  t0.id AS id_1,
  t0.typ AS typ_2,
  t0.klic AS klic_3,
  t0.obsah AS obsah_4,
  t0.page_id AS page_id_5
FROM
  block t0
WHERE
  (
    t0.klic = ?
    AND t0.page_id = ?
  )

SELECT t0.id AS id_1, t0.typ AS typ_2, t0.klic AS klic_3, t0.obsah AS obsah_4, t0.page_id AS page_id_5 FROM block t0 WHERE (t0.klic = 'top-text' AND t0.page_id = 3);

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      datum_1
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.datum AS datum_1,
          p0_.url AS url_2,
          p0_.title AS title_3,
          p0_.foto AS foto_4,
          p0_.status AS status_5,
          p0_.subtitle AS subtitle_6,
          p0_.scientists AS scientists_7,
          p0_.tags AS tags_8,
          p0_.pdffile AS pdffile_9,
          p0_.challange AS challange_10,
          p0_.technology AS technology_11,
          p0_.opportunity AS opportunity_12,
          p0_.develstatus AS develstatus_13,
          p0_.categories2 AS categories2_14,
          p0_.readings AS readings_15,
          p0_.created AS created_16,
          p0_.updated AS updated_17,
          p0_.published AS published_18
        FROM
          project p0_
        WHERE
          p0_.published IS NOT NULL
          AND p0_.published <= ?
      ) dctrn_result_inner
    ORDER BY
      datum_1 DESC
  ) dctrn_result
LIMIT
  999999

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, datum_1 FROM (SELECT p0_.id AS id_0, p0_.datum AS datum_1, p0_.url AS url_2, p0_.title AS title_3, p0_.foto AS foto_4, p0_.status AS status_5, p0_.subtitle AS subtitle_6, p0_.scientists AS scientists_7, p0_.tags AS tags_8, p0_.pdffile AS pdffile_9, p0_.challange AS challange_10, p0_.technology AS technology_11, p0_.opportunity AS opportunity_12, p0_.develstatus AS develstatus_13, p0_.categories2 AS categories2_14, p0_.readings AS readings_15, p0_.created AS created_16, p0_.updated AS updated_17, p0_.published AS published_18 FROM project p0_ WHERE p0_.published IS NOT NULL AND p0_.published <= '2026-02-05 10:09:16') dctrn_result_inner ORDER BY datum_1 DESC) dctrn_result LIMIT 999999;

SELECT
  p0_.id AS id_0,
  p0_.datum AS datum_1,
  p0_.url AS url_2,
  p0_.title AS title_3,
  p0_.foto AS foto_4,
  p0_.status AS status_5,
  p0_.subtitle AS subtitle_6,
  p0_.scientists AS scientists_7,
  p0_.tags AS tags_8,
  p0_.pdffile AS pdffile_9,
  p0_.challange AS challange_10,
  p0_.technology AS technology_11,
  p0_.opportunity AS opportunity_12,
  p0_.develstatus AS develstatus_13,
  p0_.categories2 AS categories2_14,
  p0_.readings AS readings_15,
  p0_.created AS created_16,
  p0_.updated AS updated_17,
  p0_.published AS published_18
FROM
  project p0_
WHERE
  p0_.published IS NOT NULL
  AND p0_.published <= ?
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.datum DESC

SELECT p0_.id AS id_0, p0_.datum AS datum_1, p0_.url AS url_2, p0_.title AS title_3, p0_.foto AS foto_4, p0_.status AS status_5, p0_.subtitle AS subtitle_6, p0_.scientists AS scientists_7, p0_.tags AS tags_8, p0_.pdffile AS pdffile_9, p0_.challange AS challange_10, p0_.technology AS technology_11, p0_.opportunity AS opportunity_12, p0_.develstatus AS develstatus_13, p0_.categories2 AS categories2_14, p0_.readings AS readings_15, p0_.created AS created_16, p0_.updated AS updated_17, p0_.published AS published_18 FROM project p0_ WHERE p0_.published IS NOT NULL AND p0_.published <= '2026-02-05 10:09:16' AND p0_.id IN (4, 5, 13, 14, 15, 16, 17, 10) ORDER BY p0_.datum DESC;