Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.name AS name_4,
  t0.surname AS surname_5,
  t0.roles AS roles_6,
  t0.mobile_phone AS mobile_phone_7,
  t0.address AS address_8,
  t0.city AS city_9,
  t0.zip_code AS zip_code_10,
  t0.state AS state_11,
  t0.country AS country_12,
  t0.price_modifier AS price_modifier_13,
  t0.password AS password_14,
  t0.reset_password_token AS reset_password_token_15,
  t0.locale AS locale_16,
  t0.double_factor_method AS double_factor_method_17,
  t0.auth_code AS auth_code_18,
  t0.google_authenticator_secret AS google_authenticator_secret_19,
  t0.disabled_at AS disabled_at_20,
  t0.last_login_at AS last_login_at_21,
  t0.last_login_ip AS last_login_ip_22,
  t0.previous_login_at AS previous_login_at_23,
  t0.previous_login_ip AS previous_login_ip_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.surname AS surname_5, t0.roles AS roles_6, t0.mobile_phone AS mobile_phone_7, t0.address AS address_8, t0.city AS city_9, t0.zip_code AS zip_code_10, t0.state AS state_11, t0.country AS country_12, t0.price_modifier AS price_modifier_13, t0.password AS password_14, t0.reset_password_token AS reset_password_token_15, t0.locale AS locale_16, t0.double_factor_method AS double_factor_method_17, t0.auth_code AS auth_code_18, t0.google_authenticator_secret AS google_authenticator_secret_19, t0.disabled_at AS disabled_at_20, t0.last_login_at AS last_login_at_21, t0.last_login_ip AS last_login_ip_22, t0.previous_login_at AS previous_login_at_23, t0.previous_login_ip AS previous_login_ip_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM users t0 WHERE t0.id = 'e1d213a7-a827-410f-8a36-623e68f7991b';

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.name AS name_4,
  t0.surname AS surname_5,
  t0.roles AS roles_6,
  t0.mobile_phone AS mobile_phone_7,
  t0.address AS address_8,
  t0.city AS city_9,
  t0.zip_code AS zip_code_10,
  t0.state AS state_11,
  t0.country AS country_12,
  t0.price_modifier AS price_modifier_13,
  t0.password AS password_14,
  t0.reset_password_token AS reset_password_token_15,
  t0.locale AS locale_16,
  t0.double_factor_method AS double_factor_method_17,
  t0.auth_code AS auth_code_18,
  t0.google_authenticator_secret AS google_authenticator_secret_19,
  t0.disabled_at AS disabled_at_20,
  t0.last_login_at AS last_login_at_21,
  t0.last_login_ip AS last_login_ip_22,
  t0.previous_login_at AS previous_login_at_23,
  t0.previous_login_ip AS previous_login_ip_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.surname AS surname_5, t0.roles AS roles_6, t0.mobile_phone AS mobile_phone_7, t0.address AS address_8, t0.city AS city_9, t0.zip_code AS zip_code_10, t0.state AS state_11, t0.country AS country_12, t0.price_modifier AS price_modifier_13, t0.password AS password_14, t0.reset_password_token AS reset_password_token_15, t0.locale AS locale_16, t0.double_factor_method AS double_factor_method_17, t0.auth_code AS auth_code_18, t0.google_authenticator_secret AS google_authenticator_secret_19, t0.disabled_at AS disabled_at_20, t0.last_login_at AS last_login_at_21, t0.last_login_ip AS last_login_ip_22, t0.previous_login_at AS previous_login_at_23, t0.previous_login_ip AS previous_login_ip_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM users t0 WHERE t0.id = 'dc2353b0-9c21-4c38-b703-d18dba3445d6';

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.category_id AS category_id_6
FROM
  category_translations t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.category_id AS category_id_6 FROM category_translations t0 WHERE t0.name = 'Ofertas' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.category_id AS category_id_6
FROM
  category_translations t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.category_id AS category_id_6 FROM category_translations t0 WHERE t0.name = 'Ofertas' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c1_.locale AS locale_1,
  c1_.name AS name_2,
  COUNT(DISTINCT p2_.id) AS sclr_3
FROM
  products p2_
  INNER JOIN category_product c4_ ON p2_.id = c4_.product_id
  INNER JOIN categories c3_ ON c3_.id = c4_.category_id
  AND (c3_.id = ?)
  INNER JOIN category_product c5_ ON p2_.id = c5_.product_id
  INNER JOIN categories c0_ ON c0_.id = c5_.category_id
  LEFT JOIN category_translations c1_ ON c0_.id = c1_.category_id
WHERE
  p2_.enabled = 1
GROUP BY
  c0_.id,
  c1_.locale,
  c1_.name

SELECT c0_.id AS id_0, c1_.locale AS locale_1, c1_.name AS name_2, COUNT(DISTINCT p2_.id) AS sclr_3 FROM products p2_ INNER JOIN category_product c4_ ON p2_.id = c4_.product_id INNER JOIN categories c3_ ON c3_.id = c4_.category_id AND (c3_.id = 'f7f8446a-ed24-55af-87f2-f00a96e0c06a') INNER JOIN category_product c5_ ON p2_.id = c5_.product_id INNER JOIN categories c0_ ON c0_.id = c5_.category_id LEFT JOIN category_translations c1_ ON c0_.id = c1_.category_id WHERE p2_.enabled = 1 GROUP BY c0_.id, c1_.locale, c1_.name;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.category_id AS category_id_6
FROM
  category_translations t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.category_id AS category_id_6 FROM category_translations t0 WHERE t0.name = 'Ofertas' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.sku AS sku_2,
  COUNT(DISTINCT p1_.id) AS sclr_3
FROM
  products p1_
  INNER JOIN category_product c3_ ON p1_.id = c3_.product_id
  INNER JOIN categories c2_ ON c2_.id = c3_.category_id
  AND (c2_.id = ?)
  LEFT JOIN machine_product_relations m4_ ON (m4_.product_id = p1_.id)
  LEFT JOIN product_relations p5_ ON (p5_.related_id = p1_.id)
  LEFT JOIN products p6_ ON p5_.product_id = p6_.id
  LEFT JOIN set_details s7_ ON p6_.id = s7_.product_id
  LEFT JOIN set_detail_machine s9_ ON s7_.id = s9_.set_detail_id
  LEFT JOIN machines m8_ ON m8_.id = s9_.machine_id
  INNER JOIN machines m0_ ON (
    m0_.id = m4_.machine_id
    OR m0_.id = m8_.id
  )
WHERE
  p1_.enabled = 1
GROUP BY
  m0_.id,
  m0_.name,
  m0_.sku

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sku AS sku_2, COUNT(DISTINCT p1_.id) AS sclr_3 FROM products p1_ INNER JOIN category_product c3_ ON p1_.id = c3_.product_id INNER JOIN categories c2_ ON c2_.id = c3_.category_id AND (c2_.id = 'f7f8446a-ed24-55af-87f2-f00a96e0c06a') LEFT JOIN machine_product_relations m4_ ON (m4_.product_id = p1_.id) LEFT JOIN product_relations p5_ ON (p5_.related_id = p1_.id) LEFT JOIN products p6_ ON p5_.product_id = p6_.id LEFT JOIN set_details s7_ ON p6_.id = s7_.product_id LEFT JOIN set_detail_machine s9_ ON s7_.id = s9_.set_detail_id LEFT JOIN machines m8_ ON m8_.id = s9_.machine_id INNER JOIN machines m0_ ON (m0_.id = m4_.machine_id OR m0_.id = m8_.id) WHERE p1_.enabled = 1 GROUP BY m0_.id, m0_.name, m0_.sku;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.sku AS sku_1,
          p0_.name AS name_2,
          p0_.description AS description_3,
          p0_.price_including_vat AS price_including_vat_4,
          p0_.featured AS featured_5,
          p0_.price AS price_6,
          p0_.currency AS currency_7,
          p0_.vat_rate AS vat_rate_8,
          p0_.enabled AS enabled_9,
          p0_.stock AS stock_10,
          p0_.image_path AS image_path_11,
          p0_.show_title AS show_title_12,
          p0_.show_content AS show_content_13,
          p0_.imported AS imported_14,
          p0_.imported_code AS imported_code_15,
          p0_.is_set AS is_set_16,
          p0_.obsolete AS obsolete_17,
          p0_.visibility_role AS visibility_role_18,
          p0_.metadata AS metadata_19,
          p0_.created_at AS created_at_20,
          p0_.updated_at AS updated_at_21,
          c1_.id AS id_22,
          c1_.category_usage AS category_usage_23,
          c1_.created_at AS created_at_24,
          c1_.updated_at AS updated_at_25
        FROM
          products p0_
          INNER JOIN category_product c2_ ON p0_.id = c2_.product_id
          INNER JOIN categories c1_ ON c1_.id = c2_.category_id
          AND (c1_.id = ?)
        WHERE
          p0_.enabled = 1
      ) dctrn_result_inner
    ORDER BY
      id_0 ASC
  ) dctrn_result
LIMIT
  4

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.description AS description_3, p0_.price_including_vat AS price_including_vat_4, p0_.featured AS featured_5, p0_.price AS price_6, p0_.currency AS currency_7, p0_.vat_rate AS vat_rate_8, p0_.enabled AS enabled_9, p0_.stock AS stock_10, p0_.image_path AS image_path_11, p0_.show_title AS show_title_12, p0_.show_content AS show_content_13, p0_.imported AS imported_14, p0_.imported_code AS imported_code_15, p0_.is_set AS is_set_16, p0_.obsolete AS obsolete_17, p0_.visibility_role AS visibility_role_18, p0_.metadata AS metadata_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, c1_.id AS id_22, c1_.category_usage AS category_usage_23, c1_.created_at AS created_at_24, c1_.updated_at AS updated_at_25 FROM products p0_ INNER JOIN category_product c2_ ON p0_.id = c2_.product_id INNER JOIN categories c1_ ON c1_.id = c2_.category_id AND (c1_.id = 'f7f8446a-ed24-55af-87f2-f00a96e0c06a') WHERE p0_.enabled = 1) dctrn_result_inner ORDER BY id_0 ASC) dctrn_result LIMIT 4;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.sku AS sku_1,
          p0_.name AS name_2,
          p0_.description AS description_3,
          p0_.price_including_vat AS price_including_vat_4,
          p0_.featured AS featured_5,
          p0_.price AS price_6,
          p0_.currency AS currency_7,
          p0_.vat_rate AS vat_rate_8,
          p0_.enabled AS enabled_9,
          p0_.stock AS stock_10,
          p0_.image_path AS image_path_11,
          p0_.show_title AS show_title_12,
          p0_.show_content AS show_content_13,
          p0_.imported AS imported_14,
          p0_.imported_code AS imported_code_15,
          p0_.is_set AS is_set_16,
          p0_.obsolete AS obsolete_17,
          p0_.visibility_role AS visibility_role_18,
          p0_.metadata AS metadata_19,
          p0_.created_at AS created_at_20,
          p0_.updated_at AS updated_at_21
        FROM
          products p0_
          INNER JOIN category_product c2_ ON p0_.id = c2_.product_id
          INNER JOIN categories c1_ ON c1_.id = c2_.category_id
          AND (c1_.id = ?)
        WHERE
          p0_.enabled = 1
        ORDER BY
          p0_.id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.description AS description_3, p0_.price_including_vat AS price_including_vat_4, p0_.featured AS featured_5, p0_.price AS price_6, p0_.currency AS currency_7, p0_.vat_rate AS vat_rate_8, p0_.enabled AS enabled_9, p0_.stock AS stock_10, p0_.image_path AS image_path_11, p0_.show_title AS show_title_12, p0_.show_content AS show_content_13, p0_.imported AS imported_14, p0_.imported_code AS imported_code_15, p0_.is_set AS is_set_16, p0_.obsolete AS obsolete_17, p0_.visibility_role AS visibility_role_18, p0_.metadata AS metadata_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21 FROM products p0_ INNER JOIN category_product c2_ ON p0_.id = c2_.product_id INNER JOIN categories c1_ ON c1_.id = c2_.category_id AND (c1_.id = 'f7f8446a-ed24-55af-87f2-f00a96e0c06a') WHERE p0_.enabled = 1 ORDER BY p0_.id ASC) dctrn_result) dctrn_table;