Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.name AS name_4,
  t0.alcohol_content AS alcohol_content_5,
  t0.bottle_size AS bottle_size_6,
  t0.image AS image_7,
  t0.is_frontpage AS is_frontpage_8,
  t0.slug AS slug_9,
  t0.price AS price_10,
  t0.status AS status_11,
  t0.fact_sheet AS fact_sheet_12,
  t0.factsheet_fr AS factsheet_fr_13,
  t0.brand_id AS brand_id_14,
  t0.country_id AS country_id_15,
  t0.product_category_id AS product_category_id_16
FROM
  product t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.name AS name_4, t0.alcohol_content AS alcohol_content_5, t0.bottle_size AS bottle_size_6, t0.image AS image_7, t0.is_frontpage AS is_frontpage_8, t0.slug AS slug_9, t0.price AS price_10, t0.status AS status_11, t0.fact_sheet AS fact_sheet_12, t0.factsheet_fr AS factsheet_fr_13, t0.brand_id AS brand_id_14, t0.country_id AS country_id_15, t0.product_category_id AS product_category_id_16 FROM product t0 WHERE t0.slug = 'law-gin-of-ibiza' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.created AS created_1,
  p0_.updated AS updated_2,
  p0_.name AS name_3,
  p0_.alcohol_content AS alcohol_content_4,
  p0_.bottle_size AS bottle_size_5,
  p0_.image AS image_6,
  p0_.is_frontpage AS is_frontpage_7,
  p0_.slug AS slug_8,
  p0_.price AS price_9,
  p0_.status AS status_10,
  p0_.fact_sheet AS fact_sheet_11,
  p0_.factsheet_fr AS factsheet_fr_12,
  p0_.brand_id AS brand_id_13,
  p0_.country_id AS country_id_14,
  p0_.product_category_id AS product_category_id_15
FROM
  product p0_
WHERE
  p0_.id > ?
ORDER BY
  p0_.id ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.updated AS updated_2, p0_.name AS name_3, p0_.alcohol_content AS alcohol_content_4, p0_.bottle_size AS bottle_size_5, p0_.image AS image_6, p0_.is_frontpage AS is_frontpage_7, p0_.slug AS slug_8, p0_.price AS price_9, p0_.status AS status_10, p0_.fact_sheet AS fact_sheet_11, p0_.factsheet_fr AS factsheet_fr_12, p0_.brand_id AS brand_id_13, p0_.country_id AS country_id_14, p0_.product_category_id AS product_category_id_15 FROM product p0_ WHERE p0_.id > 6 ORDER BY p0_.id ASC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.created AS created_1,
  p0_.updated AS updated_2,
  p0_.name AS name_3,
  p0_.alcohol_content AS alcohol_content_4,
  p0_.bottle_size AS bottle_size_5,
  p0_.image AS image_6,
  p0_.is_frontpage AS is_frontpage_7,
  p0_.slug AS slug_8,
  p0_.price AS price_9,
  p0_.status AS status_10,
  p0_.fact_sheet AS fact_sheet_11,
  p0_.factsheet_fr AS factsheet_fr_12,
  p0_.brand_id AS brand_id_13,
  p0_.country_id AS country_id_14,
  p0_.product_category_id AS product_category_id_15
FROM
  product p0_
WHERE
  p0_.id < ?
ORDER BY
  p0_.id DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.updated AS updated_2, p0_.name AS name_3, p0_.alcohol_content AS alcohol_content_4, p0_.bottle_size AS bottle_size_5, p0_.image AS image_6, p0_.is_frontpage AS is_frontpage_7, p0_.slug AS slug_8, p0_.price AS price_9, p0_.status AS status_10, p0_.fact_sheet AS fact_sheet_11, p0_.factsheet_fr AS factsheet_fr_12, p0_.brand_id AS brand_id_13, p0_.country_id AS country_id_14, p0_.product_category_id AS product_category_id_15 FROM product p0_ WHERE p0_.id < 6 ORDER BY p0_.id DESC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.created AS created_1,
  p0_.updated AS updated_2,
  p0_.name AS name_3,
  p0_.alcohol_content AS alcohol_content_4,
  p0_.bottle_size AS bottle_size_5,
  p0_.image AS image_6,
  p0_.is_frontpage AS is_frontpage_7,
  p0_.slug AS slug_8,
  p0_.price AS price_9,
  p0_.status AS status_10,
  p0_.fact_sheet AS fact_sheet_11,
  p0_.factsheet_fr AS factsheet_fr_12,
  p0_.brand_id AS brand_id_13,
  p0_.country_id AS country_id_14,
  p0_.product_category_id AS product_category_id_15
FROM
  product p0_
  INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id
WHERE
  p1_.id = ?
  AND p0_.id <> ?
ORDER BY
  p0_.id DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.updated AS updated_2, p0_.name AS name_3, p0_.alcohol_content AS alcohol_content_4, p0_.bottle_size AS bottle_size_5, p0_.image AS image_6, p0_.is_frontpage AS is_frontpage_7, p0_.slug AS slug_8, p0_.price AS price_9, p0_.status AS status_10, p0_.fact_sheet AS fact_sheet_11, p0_.factsheet_fr AS factsheet_fr_12, p0_.brand_id AS brand_id_13, p0_.country_id AS country_id_14, p0_.product_category_id AS product_category_id_15 FROM product p0_ INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id WHERE p1_.id = 4 AND p0_.id <> 6 ORDER BY p0_.id DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.description AS description_3,
  t0.short_description AS short_description_4,
  t0.packaging AS packaging_5,
  t0.is_good_for AS is_good_for_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 6;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.description AS description_3,
  t0.short_description AS short_description_4,
  t0.packaging AS packaging_5,
  t0.is_good_for AS is_good_for_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 17;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.description AS description_3,
  t0.short_description AS short_description_4,
  t0.packaging AS packaging_5,
  t0.is_good_for AS is_good_for_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 13;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.description AS description_3,
  t0.short_description AS short_description_4,
  t0.packaging AS packaging_5,
  t0.is_good_for AS is_good_for_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 12;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.description AS description_3,
  t0.short_description AS short_description_4,
  t0.packaging AS packaging_5,
  t0.is_good_for AS is_good_for_6,
  t0.product_id AS product_id_7
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.packaging AS packaging_5, t0.is_good_for AS is_good_for_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  product_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM product_category t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.url AS url_6,
  t0.image AS image_7
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.name AS name_4, t0.description AS description_5, t0.url AS url_6, t0.image AS image_7 FROM brand t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.name AS name_4,
  t0.image AS image_5,
  t0.slug AS slug_6,
  t0.is_frontpage AS is_frontpage_7,
  t0.product_id AS product_id_8
FROM
  cocktail t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.name AS name_4, t0.image AS image_5, t0.slug AS slug_6, t0.is_frontpage AS is_frontpage_7, t0.product_id AS product_id_8 FROM cocktail t0 WHERE t0.product_id = 6;