Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.price AS price_1,
  p0_.iva AS iva_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.reference AS reference_5,
  p0_.image AS image_6,
  p0_.hidden AS hidden_7,
  p1_.id AS id_8,
  p1_.locale AS locale_9,
  p1_.name AS name_10,
  p1_.slug AS slug_11,
  p1_.description AS description_12,
  p1_.specifications AS specifications_13,
  p1_.directions AS directions_14,
  a2_.id AS id_15,
  a2_.contact_phone_number AS contact_phone_number_16,
  a2_.contact_address_line1 AS contact_address_line1_17,
  a2_.contact_address_line2 AS contact_address_line2_18,
  a2_.contact_postal_code AS contact_postal_code_19,
  a2_.contact_city AS contact_city_20,
  a2_.billing_email AS billing_email_21,
  a2_.billing_name AS billing_name_22,
  a2_.billing_phone_number AS billing_phone_number_23,
  a2_.billing_address_line1 AS billing_address_line1_24,
  a2_.billing_address_line2 AS billing_address_line2_25,
  a2_.billing_postal_code AS billing_postal_code_26,
  a2_.billing_city AS billing_city_27,
  a2_.nif AS nif_28,
  a2_.updated_at AS updated_at_29,
  a2_.preferences AS preferences_30,
  a2_.is_billing_data_complete AS is_billing_data_complete_31,
  p0_.brand_id AS brand_id_32,
  p0_.family_type_id AS family_type_id_33,
  p1_.product_id AS product_id_34,
  a2_.contact_country_id AS contact_country_id_35,
  a2_.contact_province_id AS contact_province_id_36,
  a2_.billing_country_id AS billing_country_id_37,
  a2_.billing_province_id AS billing_province_id_38,
  a2_.user_id AS user_id_39
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_.iva AS iva_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.reference AS reference_5, p0_.image AS image_6, p0_.hidden AS hidden_7, p1_.id AS id_8, p1_.locale AS locale_9, p1_.name AS name_10, p1_.slug AS slug_11, p1_.description AS description_12, p1_.specifications AS specifications_13, p1_.directions AS directions_14, a2_.id AS id_15, a2_.contact_phone_number AS contact_phone_number_16, a2_.contact_address_line1 AS contact_address_line1_17, a2_.contact_address_line2 AS contact_address_line2_18, a2_.contact_postal_code AS contact_postal_code_19, a2_.contact_city AS contact_city_20, a2_.billing_email AS billing_email_21, a2_.billing_name AS billing_name_22, a2_.billing_phone_number AS billing_phone_number_23, a2_.billing_address_line1 AS billing_address_line1_24, a2_.billing_address_line2 AS billing_address_line2_25, a2_.billing_postal_code AS billing_postal_code_26, a2_.billing_city AS billing_city_27, a2_.nif AS nif_28, a2_.updated_at AS updated_at_29, a2_.preferences AS preferences_30, a2_.is_billing_data_complete AS is_billing_data_complete_31, p0_.brand_id AS brand_id_32, p0_.family_type_id AS family_type_id_33, p1_.product_id AS product_id_34, a2_.contact_country_id AS contact_country_id_35, a2_.contact_province_id AS contact_province_id_36, a2_.billing_country_id AS billing_country_id_37, a2_.billing_province_id AS billing_province_id_38, a2_.user_id AS user_id_39 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 = 'es' AND f5_.code = 'angle-30o' AND p0_.hidden = 0 ORDER BY b3_.display_order ASC, p1_.name ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.is_default AS is_default_4
FROM
  user_types t0
WHERE
  t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.is_default AS is_default_4 FROM user_types t0 WHERE t0.is_default = 1 LIMIT 1;

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 = 'angle-30o' 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 = 0x019CDDA5FEA87765BFAE45A1B3BC4C69;

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 = 0x019CDDA5F39B7461958608A96EE1A9A4;