Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.parent_id AS parent_id_3
FROM
  category c0_
  LEFT JOIN infographic_category i2_ ON c0_.id = i2_.category_id
  LEFT JOIN infographic i1_ ON i1_.id = i2_.infographic_id
WHERE
  i1_.id IS NOT NULL
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS parent_id_3 FROM category c0_ LEFT JOIN infographic_category i2_ ON c0_.id = i2_.category_id LEFT JOIN infographic i1_ ON i1_.id = i2_.infographic_id WHERE i1_.id IS NOT NULL ORDER BY c0_.name ASC;

SELECT
  i0_.id AS id_0,
  i0_.title AS title_1,
  i0_.description AS description_2,
  i0_.created_at AS created_at_3,
  i0_.updated_at AS updated_at_4,
  i0_.thumbnail AS thumbnail_5,
  i0_.document AS document_6,
  i0_.promoted AS promoted_7,
  i0_.theme AS theme_8,
  i0_.published_at AS published_at_9,
  i0_.slug AS slug_10,
  i0_.type AS type_11,
  i0_.price AS price_12,
  i0_.is_purchasable AS is_purchasable_13,
  i0_.additional_infos AS additional_infos_14,
  i0_.position_on_home AS position_on_home_15,
  i0_.main_pdf AS main_pdf_16,
  i0_.bonus_docs AS bonus_docs_17,
  i0_.available_on_premium AS available_on_premium_18,
  i0_.deleted_at AS deleted_at_19,
  i0_.customer_id AS customer_id_20,
  i0_.parent_id AS parent_id_21
FROM
  infographic i0_
WHERE
  i0_.deleted_at IS NULL
  AND i0_.type IN (?, ?, ?)
ORDER BY
  i0_.published_at DESC

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.description AS description_2, i0_.created_at AS created_at_3, i0_.updated_at AS updated_at_4, i0_.thumbnail AS thumbnail_5, i0_.document AS document_6, i0_.promoted AS promoted_7, i0_.theme AS theme_8, i0_.published_at AS published_at_9, i0_.slug AS slug_10, i0_.type AS type_11, i0_.price AS price_12, i0_.is_purchasable AS is_purchasable_13, i0_.additional_infos AS additional_infos_14, i0_.position_on_home AS position_on_home_15, i0_.main_pdf AS main_pdf_16, i0_.bonus_docs AS bonus_docs_17, i0_.available_on_premium AS available_on_premium_18, i0_.deleted_at AS deleted_at_19, i0_.customer_id AS customer_id_20, i0_.parent_id AS parent_id_21 FROM infographic i0_ WHERE i0_.deleted_at IS NULL AND i0_.type IN ('credits', 'hors_pack', 'freemium') ORDER BY i0_.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
  INNER JOIN infographic_category ON t0.id = infographic_category.category_id
WHERE
  infographic_category.infographic_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = 25;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
  INNER JOIN infographic_category ON t0.id = infographic_category.category_id
WHERE
  infographic_category.infographic_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = 103;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
  INNER JOIN infographic_category ON t0.id = infographic_category.category_id
WHERE
  infographic_category.infographic_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = 104;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
  INNER JOIN infographic_category ON t0.id = infographic_category.category_id
WHERE
  infographic_category.infographic_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = 136;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
  INNER JOIN infographic_category ON t0.id = infographic_category.category_id
WHERE
  infographic_category.infographic_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = 133;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
  INNER JOIN infographic_category ON t0.id = infographic_category.category_id
WHERE
  infographic_category.infographic_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = 134;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
  INNER JOIN infographic_category ON t0.id = infographic_category.category_id
WHERE
  infographic_category.infographic_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = 19;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
  INNER JOIN infographic_category ON t0.id = infographic_category.category_id
WHERE
  infographic_category.infographic_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = 47;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.parent_id AS parent_id_4
FROM
  category t0
  INNER JOIN infographic_category ON t0.id = infographic_category.category_id
WHERE
  infographic_category.infographic_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = 65;