Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.lastname AS lastname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.preferred_locale AS preferred_locale_9,
  t0.tryton_id AS tryton_id_10,
  t0.nobel AS nobel_11,
  t12.id AS id_13,
  t12.contact_phone_number AS contact_phone_number_14,
  t12.contact_address AS contact_address_15,
  t12.billing_email AS billing_email_16,
  t12.billing_name AS billing_name_17,
  t12.billing_phone_number AS billing_phone_number_18,
  t12.billing_address AS billing_address_19,
  t12.nif AS nif_20,
  t12.updated_at AS updated_at_21,
  t12.preferences AS preferences_22,
  t12.user_id AS user_id_23
FROM
  user t0
  LEFT JOIN accounts t12 ON t12.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.preferred_locale AS preferred_locale_9, t0.tryton_id AS tryton_id_10, t0.nobel AS nobel_11, t12.id AS id_13, t12.contact_phone_number AS contact_phone_number_14, t12.contact_address AS contact_address_15, t12.billing_email AS billing_email_16, t12.billing_name AS billing_name_17, t12.billing_phone_number AS billing_phone_number_18, t12.billing_address AS billing_address_19, t12.nif AS nif_20, t12.updated_at AS updated_at_21, t12.preferences AS preferences_22, t12.user_id AS user_id_23 FROM user t0 LEFT JOIN accounts t12 ON t12.user_id = t0.id WHERE t0.id = 0x019BB74F267879FE8FE00A228A17E56C;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.locale AS locale_3,
  t0.account_id AS account_id_4
FROM
  carts t0
WHERE
  t0.account_id = ?

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.locale AS locale_3, t0.account_id AS account_id_4 FROM carts t0 WHERE t0.account_id = 0x019BB74F26797A22B3635ADD8F7E1A26;

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 AS contact_address_17,
  a2_.billing_email AS billing_email_18,
  a2_.billing_name AS billing_name_19,
  a2_.billing_phone_number AS billing_phone_number_20,
  a2_.billing_address AS billing_address_21,
  a2_.nif AS nif_22,
  a2_.updated_at AS updated_at_23,
  a2_.preferences AS preferences_24,
  p0_.brand_id AS brand_id_25,
  p1_.product_id AS product_id_26,
  a2_.user_id AS user_id_27
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 AS contact_address_17, a2_.billing_email AS billing_email_18, a2_.billing_name AS billing_name_19, a2_.billing_phone_number AS billing_phone_number_20, a2_.billing_address AS billing_address_21, a2_.nif AS nif_22, a2_.updated_at AS updated_at_23, a2_.preferences AS preferences_24, p0_.brand_id AS brand_id_25, p1_.product_id AS product_id_26, a2_.user_id AS user_id_27 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 = 'brand-bti-r' AND p0_.hidden = 0 ORDER BY b3_.display_order ASC, p1_.name ASC;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.locale AS locale_3,
  t0.account_id AS account_id_4
FROM
  carts t0
WHERE
  t0.account_id = ?

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.locale AS locale_3, t0.account_id AS account_id_4 FROM carts t0 WHERE t0.account_id = 0x0196AB7B00FD7029849F927AFB496926;

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 = 'brand-bti-r' 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 = 0x01983E6ADEEC7FA89BAC999824E7A3AF;