Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.price AS price_1,
  p0_.created_at AS created_at_2,
  p0_.updated_at AS updated_at_3,
  p0_.reference AS reference_4,
  p0_.image AS image_5,
  p0_.hidden AS hidden_6,
  p1_.id AS id_7,
  p1_.locale AS locale_8,
  p1_.name AS name_9,
  p1_.slug AS slug_10,
  p1_.description AS description_11,
  p1_.specifications AS specifications_12,
  p1_.directions AS directions_13,
  a2_.id AS id_14,
  a2_.contact_phone_number AS contact_phone_number_15,
  a2_.contact_address AS contact_address_16,
  a2_.billing_email AS billing_email_17,
  a2_.billing_name AS billing_name_18,
  a2_.billing_phone_number AS billing_phone_number_19,
  a2_.billing_address AS billing_address_20,
  a2_.nif AS nif_21,
  a2_.updated_at AS updated_at_22,
  a2_.preferences AS preferences_23,
  p0_.brand_id AS brand_id_24,
  p1_.product_id AS product_id_25,
  a2_.user_id AS user_id_26
FROM
  products p0_
  INNER JOIN brands b3_ ON p0_.brand_id = b3_.id
  INNER JOIN products_translations p1_ ON p0_.id = p1_.product_id
  LEFT JOIN favorite_products f4_ ON p0_.id = f4_.product_id
  LEFT JOIN accounts a2_ ON a2_.id = f4_.account_id
  INNER JOIN filter_value_product f6_ ON p0_.id = f6_.product_id
  INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id
WHERE
  p1_.locale = ?
  AND f5_.code = ?
  AND p0_.hidden = 0
ORDER BY
  b3_.display_order ASC,
  p1_.name ASC

SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.reference AS reference_4, p0_.image AS image_5, p0_.hidden AS hidden_6, p1_.id AS id_7, p1_.locale AS locale_8, p1_.name AS name_9, p1_.slug AS slug_10, p1_.description AS description_11, p1_.specifications AS specifications_12, p1_.directions AS directions_13, a2_.id AS id_14, a2_.contact_phone_number AS contact_phone_number_15, a2_.contact_address AS contact_address_16, a2_.billing_email AS billing_email_17, a2_.billing_name AS billing_name_18, a2_.billing_phone_number AS billing_phone_number_19, a2_.billing_address AS billing_address_20, a2_.nif AS nif_21, a2_.updated_at AS updated_at_22, a2_.preferences AS preferences_23, p0_.brand_id AS brand_id_24, p1_.product_id AS product_id_25, a2_.user_id AS user_id_26 FROM products p0_ INNER JOIN brands b3_ ON p0_.brand_id = b3_.id INNER JOIN products_translations p1_ ON p0_.id = p1_.product_id LEFT JOIN favorite_products f4_ ON p0_.id = f4_.product_id LEFT JOIN accounts a2_ ON a2_.id = f4_.account_id INNER JOIN filter_value_product f6_ ON p0_.id = f6_.product_id INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id WHERE p1_.locale = 'en' AND f5_.code = 'family-scanbody' AND p0_.hidden = 0 ORDER BY b3_.display_order ASC, p1_.name ASC;

SELECT
  f0_.id AS id_0,
  f1_.code AS code_1,
  f0_.code AS code_2,
  f2_.locale AS locale_3,
  f2_.name AS name_4
FROM
  filter_values f0_
  INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id
  LEFT JOIN filter_value_translations f2_ ON f0_.id = f2_.value_id

SELECT f0_.id AS id_0, f1_.code AS code_1, f0_.code AS code_2, f2_.locale AS locale_3, f2_.name AS name_4 FROM filter_values f0_ INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id LEFT JOIN filter_value_translations f2_ ON f0_.id = f2_.value_id;

SELECT
  f0_.id AS id_0
FROM
  filter_values f0_
  INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id
  INNER JOIN filter_value_product f3_ ON f0_.id = f3_.value_id
  INNER JOIN products p2_ ON p2_.id = f3_.product_id
  AND (p2_.hidden = 0)
WHERE
  EXISTS (
    SELECT
      1 AS sclr_1
    FROM
      products p4_
      INNER JOIN filter_value_product f6_ ON p4_.id = f6_.product_id
      INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id
    WHERE
      f5_.code = ?
      AND p4_.id = p2_.id
  )

SELECT f0_.id AS id_0 FROM filter_values f0_ INNER JOIN filter_types f1_ ON f0_.type_id = f1_.id INNER JOIN filter_value_product f3_ ON f0_.id = f3_.value_id INNER JOIN products p2_ ON p2_.id = f3_.product_id AND (p2_.hidden = 0) WHERE EXISTS (SELECT 1 AS sclr_1 FROM products p4_ INNER JOIN filter_value_product f6_ ON p4_.id = f6_.product_id INNER JOIN filter_values f5_ ON f5_.id = f6_.value_id WHERE f5_.code = 'family-scanbody' AND p4_.id = p2_.id);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.display_order AS display_order_5
FROM
  brands t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = 0x01983E6AE2DD74E0BBCD09A52E8C36CF;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.display_order AS display_order_5
FROM
  brands t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = 0x01983E6AE7AE712D9B0A013AF586BF88;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.display_order AS display_order_5
FROM
  brands t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = 0x01983E6ADEEC7FA89BAC999824E7A3AF;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.display_order AS display_order_5
FROM
  brands t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = 0x01983E6AF67471168ACB4A3D5385DECC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.display_order AS display_order_5
FROM
  brands t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = 0x01983E6AE8967B72A417E021690FBBB0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.display_order AS display_order_5
FROM
  brands t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = 0x01983E6AE1777C69ADBD8172564E2DA5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.display_order AS display_order_5
FROM
  brands t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = 0x01983E6AE4C87D03880ED79E6D8325DA;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.display_order AS display_order_5
FROM
  brands t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = 0x01983E6AE5847BB484FBC8D76D5CD2E6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.display_order AS display_order_5
FROM
  brands t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.display_order AS display_order_5 FROM brands t0 WHERE t0.id = 0x01983E6AF2627BCAA252317FAB74CF03;