Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.company AS company_1,
          a0_.category AS category_2,
          a0_.adress AS adress_3,
          a0_.box AS box_4,
          a0_.zip AS zip_5,
          a0_.city AS city_6,
          a0_.facebook AS facebook_7,
          a0_.twitter AS twitter_8,
          a0_.linkedin AS linkedin_9,
          a0_.date AS date_10,
          a0_.phones AS phones_11,
          a0_.slug AS slug_12
        FROM
          advertiser a0_
        WHERE
          a0_.company NOT LIKE 'ZZZ%'
        ORDER BY
          a0_.company ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.company AS company_1, a0_.category AS category_2, a0_.adress AS adress_3, a0_.box AS box_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.facebook AS facebook_7, a0_.twitter AS twitter_8, a0_.linkedin AS linkedin_9, a0_.date AS date_10, a0_.phones AS phones_11, a0_.slug AS slug_12 FROM advertiser a0_ WHERE a0_.company NOT LIKE 'ZZZ%' ORDER BY a0_.company ASC) dctrn_result) dctrn_table;

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 18:58:04' 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 18:58:04' BETWEEN c0_.dtfrom AND c0_.dtto ORDER BY c0_.id DESC LIMIT 2;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      company_1
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.company AS company_1,
          a0_.category AS category_2,
          a0_.adress AS adress_3,
          a0_.box AS box_4,
          a0_.zip AS zip_5,
          a0_.city AS city_6,
          a0_.facebook AS facebook_7,
          a0_.twitter AS twitter_8,
          a0_.linkedin AS linkedin_9,
          a0_.date AS date_10,
          a0_.phones AS phones_11,
          a0_.slug AS slug_12
        FROM
          advertiser a0_
        WHERE
          a0_.company NOT LIKE 'ZZZ%'
      ) dctrn_result_inner
    ORDER BY
      company_1 ASC
  ) dctrn_result
LIMIT
  20 OFFSET 80

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, company_1 FROM (SELECT a0_.id AS id_0, a0_.company AS company_1, a0_.category AS category_2, a0_.adress AS adress_3, a0_.box AS box_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.facebook AS facebook_7, a0_.twitter AS twitter_8, a0_.linkedin AS linkedin_9, a0_.date AS date_10, a0_.phones AS phones_11, a0_.slug AS slug_12 FROM advertiser a0_ WHERE a0_.company NOT LIKE 'ZZZ%') dctrn_result_inner ORDER BY company_1 ASC) dctrn_result LIMIT 20 OFFSET 80;

SELECT
  a0_.id AS id_0,
  a0_.company AS company_1,
  a0_.category AS category_2,
  a0_.adress AS adress_3,
  a0_.box AS box_4,
  a0_.zip AS zip_5,
  a0_.city AS city_6,
  a0_.facebook AS facebook_7,
  a0_.twitter AS twitter_8,
  a0_.linkedin AS linkedin_9,
  a0_.date AS date_10,
  a0_.phones AS phones_11,
  a0_.slug AS slug_12,
  a0_.logobig_id AS logobig_id_13,
  a0_.logosmall_id AS logosmall_id_14,
  a0_.loyalty_id AS loyalty_id_15
FROM
  advertiser a0_
WHERE
  a0_.company NOT LIKE 'ZZZ%'
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  a0_.company ASC

SELECT a0_.id AS id_0, a0_.company AS company_1, a0_.category AS category_2, a0_.adress AS adress_3, a0_.box AS box_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.facebook AS facebook_7, a0_.twitter AS twitter_8, a0_.linkedin AS linkedin_9, a0_.date AS date_10, a0_.phones AS phones_11, a0_.slug AS slug_12, a0_.logobig_id AS logobig_id_13, a0_.logosmall_id AS logosmall_id_14, a0_.loyalty_id AS loyalty_id_15 FROM advertiser a0_ WHERE a0_.company NOT LIKE 'ZZZ%' AND a0_.id IN (24, 190, 25, 26, 111, 100, 27, 28, 145, 88, 110, 91, 109, 139, 30, 130, 137, 31, 125, 32) ORDER BY a0_.company ASC;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id
WHERE
  a1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = 24 AND ('2025-12-09 18:58:04' 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
  image 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 image t0 WHERE t0.id = 47;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id
WHERE
  a1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = 190 AND ('2025-12-09 18:58:04' 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
  image 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 image t0 WHERE t0.id = 379;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id
WHERE
  a1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = 25 AND ('2025-12-09 18:58:04' 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
  image 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 image t0 WHERE t0.id = 49;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id
WHERE
  a1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = 26 AND ('2025-12-09 18:58:04' 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
  image 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 image t0 WHERE t0.id = 51;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id
WHERE
  a1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = 111 AND ('2025-12-09 18:58:04' 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
  image 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 image t0 WHERE t0.id = 221;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id
WHERE
  a1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = 100 AND ('2025-12-09 18:58:04' 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
  image 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 image t0 WHERE t0.id = 199;

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id
WHERE
  a1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = 27 AND ('2025-12-09 18:58:04' 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
  image 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 image t0 WHERE t0.id = 53;