Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.date AS date_2,
  c0_.dtfrom AS dtfrom_3,
  c0_.dtto AS dtto_4,
  c0_.link AS link_5,
  c0_.precedence AS precedence_6,
  c0_.statut AS statut_7,
  c0_.label_code AS label_code_8,
  c0_.label_text AS label_text_9,
  c0_.keywords AS keywords_10,
  c0_.slug AS slug_11,
  c0_.cover_id AS cover_id_12,
  c0_.pdf_id AS pdf_id_13,
  c0_.advertiser_id AS advertiser_id_14
FROM
  catalog c0_
WHERE
  c0_.label_code <> 0
  AND c0_.label_code IS NOT NULL
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )
ORDER BY
  c0_.label_code ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE c0_.label_code <> 0 AND c0_.label_code IS NOT NULL AND ('2025-12-09 17:50:54' BETWEEN c0_.dtfrom AND c0_.dtto) ORDER BY c0_.label_code ASC;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.date AS date_2,
  c0_.dtfrom AS dtfrom_3,
  c0_.dtto AS dtto_4,
  c0_.link AS link_5,
  c0_.precedence AS precedence_6,
  c0_.statut AS statut_7,
  c0_.label_code AS label_code_8,
  c0_.label_text AS label_text_9,
  c0_.keywords AS keywords_10,
  c0_.slug AS slug_11,
  c0_.cover_id AS cover_id_12,
  c0_.pdf_id AS pdf_id_13,
  c0_.advertiser_id AS advertiser_id_14
FROM
  catalog c0_
WHERE
  ? BETWEEN c0_.dtfrom
  AND c0_.dtto
ORDER BY
  c0_.id DESC
LIMIT
  2

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE '2025-12-09 17:50:54' BETWEEN c0_.dtfrom AND c0_.dtto ORDER BY c0_.id DESC LIMIT 2;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.caption AS caption_1,
          c0_.font AS font_2,
          c0_.picture AS picture_3,
          c0_.slug AS slug_4
        FROM
          category c0_
        ORDER BY
          c0_.caption ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.caption AS caption_1, c0_.font AS font_2, c0_.picture AS picture_3, c0_.slug AS slug_4 FROM category c0_ ORDER BY c0_.caption ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      caption_1
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.caption AS caption_1,
          c0_.font AS font_2,
          c0_.picture AS picture_3,
          c0_.slug AS slug_4
        FROM
          category c0_
      ) dctrn_result_inner
    ORDER BY
      caption_1 ASC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, caption_1 FROM (SELECT c0_.id AS id_0, c0_.caption AS caption_1, c0_.font AS font_2, c0_.picture AS picture_3, c0_.slug AS slug_4 FROM category c0_) dctrn_result_inner ORDER BY caption_1 ASC) dctrn_result LIMIT 20;

SELECT
  c0_.id AS id_0,
  c0_.caption AS caption_1,
  c0_.font AS font_2,
  c0_.picture AS picture_3,
  c0_.slug AS slug_4,
  c0_.icon_id AS icon_id_5,
  c0_.icon2_id AS icon2_id_6,
  c0_.categorygroup_id AS categorygroup_id_7
FROM
  category c0_
WHERE
  c0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  c0_.caption ASC

SELECT c0_.id AS id_0, c0_.caption AS caption_1, c0_.font AS font_2, c0_.picture AS picture_3, c0_.slug AS slug_4, c0_.icon_id AS icon_id_5, c0_.icon2_id AS icon2_id_6, c0_.categorygroup_id AS categorygroup_id_7 FROM category c0_ WHERE c0_.id IN (4, 5, 7, 30, 35, 8, 3, 1, 9, 10, 11, 31, 12, 13, 36, 32, 14, 15, 16, 17) ORDER BY c0_.caption ASC;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id
  INNER JOIN category c1_ ON c1_.id = c2_.category_id
WHERE
  c1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE c1_.id = 4 AND ('2025-12-09 17:50:54' BETWEEN c0_.dtfrom AND c0_.dtto);

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.alt AS alt_3,
  t0.filename AS filename_4
FROM
  icon t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.filename AS filename_4 FROM icon t0 WHERE t0.id = 18;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id
  INNER JOIN category c1_ ON c1_.id = c2_.category_id
WHERE
  c1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE c1_.id = 5 AND ('2025-12-09 17:50:54' BETWEEN c0_.dtfrom AND c0_.dtto);

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.alt AS alt_3,
  t0.filename AS filename_4
FROM
  icon t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.filename AS filename_4 FROM icon t0 WHERE t0.id = 20;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id
  INNER JOIN category c1_ ON c1_.id = c2_.category_id
WHERE
  c1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE c1_.id = 7 AND ('2025-12-09 17:50:54' BETWEEN c0_.dtfrom AND c0_.dtto);

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.alt AS alt_3,
  t0.filename AS filename_4
FROM
  icon t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.filename AS filename_4 FROM icon t0 WHERE t0.id = 24;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id
  INNER JOIN category c1_ ON c1_.id = c2_.category_id
WHERE
  c1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE c1_.id = 30 AND ('2025-12-09 17:50:54' BETWEEN c0_.dtfrom AND c0_.dtto);

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.alt AS alt_3,
  t0.filename AS filename_4
FROM
  icon t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.filename AS filename_4 FROM icon t0 WHERE t0.id = 70;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id
  INNER JOIN category c1_ ON c1_.id = c2_.category_id
WHERE
  c1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE c1_.id = 35 AND ('2025-12-09 17:50:54' BETWEEN c0_.dtfrom AND c0_.dtto);

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.alt AS alt_3,
  t0.filename AS filename_4
FROM
  icon t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.filename AS filename_4 FROM icon t0 WHERE t0.id = 80;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id
  INNER JOIN category c1_ ON c1_.id = c2_.category_id
WHERE
  c1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE c1_.id = 8 AND ('2025-12-09 17:50:54' BETWEEN c0_.dtfrom AND c0_.dtto);

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.alt AS alt_3,
  t0.filename AS filename_4
FROM
  icon t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.filename AS filename_4 FROM icon t0 WHERE t0.id = 26;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id
  INNER JOIN category c1_ ON c1_.id = c2_.category_id
WHERE
  c1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE c1_.id = 3 AND ('2025-12-09 17:50:54' BETWEEN c0_.dtfrom AND c0_.dtto);

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.alt AS alt_3,
  t0.filename AS filename_4
FROM
  icon t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.filename AS filename_4 FROM icon t0 WHERE t0.id = 16;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id
  INNER JOIN category c1_ ON c1_.id = c2_.category_id
WHERE
  c1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.catalog_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE c1_.id = 1 AND ('2025-12-09 17:50:54' BETWEEN c0_.dtfrom AND c0_.dtto);