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:53:29' 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:53:29' 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
  10 OFFSET 20

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 10 OFFSET 20;

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 (171, 10, 175, 73, 107, 67, 138, 76, 96, 70) ORDER BY a0_.company ASC;

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 = 341;

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 = 19;

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 = 349;

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 = 145;

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 = 213;

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 = 133;

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 = 275;

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 = 151;

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 = 191;

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 = 139;

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_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.category_id
  INNER JOIN catalog c1_ ON c1_.id = c2_.catalog_id
WHERE
  ? BETWEEN c1_.dtfrom
  AND c1_.dtto
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_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.category_id INNER JOIN catalog c1_ ON c1_.id = c2_.catalog_id WHERE '2025-12-09 18:53:29' BETWEEN c1_.dtfrom AND c1_.dtto ORDER BY c0_.caption ASC;