Symfony Profiler

SELECT
  t0.type AS type_1,
  t0.warranty_years AS warranty_years_2,
  t0.new AS new_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.principal_category_id AS principal_category_id_7,
  t0.principal_image_id AS principal_image_id_8,
  t0.manufacturer_id AS manufacturer_id_9,
  t0.product_class_id AS product_class_id_10,
  t0.stock_id AS stock_id_11,
  t12.sku AS sku_13,
  t12.quantity AS quantity_14,
  t12.quantity_unit AS quantity_unit_15,
  t12.ean_code AS ean_code_16,
  t12.availability AS availability_17,
  t12.`condition` AS condition_18,
  t12.importable AS importable_19,
  t12.tax_transferable AS tax_transferable_20,
  t12.sale_count AS sale_count_21,
  t12.disabled_at AS disabled_at_22,
  t12.id AS id_23,
  t12.created_at AS created_at_24,
  t12.updated_at AS updated_at_25,
  t12.enabled AS enabled_26,
  t12.group_id AS group_id_27
FROM
  product t0
  LEFT JOIN stock t12 ON t0.stock_id = t12.id
WHERE
  t0.stock_id = ?

SELECT t0.type AS type_1, t0.warranty_years AS warranty_years_2, t0.new AS new_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_category_id AS principal_category_id_7, t0.principal_image_id AS principal_image_id_8, t0.manufacturer_id AS manufacturer_id_9, t0.product_class_id AS product_class_id_10, t0.stock_id AS stock_id_11, t12.sku AS sku_13, t12.quantity AS quantity_14, t12.quantity_unit AS quantity_unit_15, t12.ean_code AS ean_code_16, t12.availability AS availability_17, t12.`condition` AS condition_18, t12.importable AS importable_19, t12.tax_transferable AS tax_transferable_20, t12.sale_count AS sale_count_21, t12.disabled_at AS disabled_at_22, t12.id AS id_23, t12.created_at AS created_at_24, t12.updated_at AS updated_at_25, t12.enabled AS enabled_26, t12.group_id AS group_id_27 FROM product t0 LEFT JOIN stock t12 ON t0.stock_id = t12.id WHERE t0.stock_id = 7175;

SELECT
  m0_.alias AS alias_0,
  m0_.lft AS lft_1,
  m0_.rgt AS rgt_2,
  m0_.lvl AS lvl_3,
  m0_.root AS root_4,
  m0_.id AS id_5,
  c1_.main_template AS main_template_6,
  c1_.product_template AS product_template_7,
  c1_.filterable AS filterable_8,
  c1_.id AS id_9,
  c1_.created_at AS created_at_10,
  c1_.updated_at AS updated_at_11,
  c2_.slug AS slug_12,
  c2_.title AS title_13,
  c2_.h1 AS h1_14,
  c2_.perex AS perex_15,
  c2_.description AS description_16,
  c2_.meta_title AS meta_title_17,
  c2_.meta_description AS meta_description_18,
  c2_.meta_keywords AS meta_keywords_19,
  c2_.locale AS locale_20,
  c2_.id AS id_21,
  i3_.name AS name_22,
  i3_.original_name AS original_name_23,
  i3_.mime_type AS mime_type_24,
  i3_.size AS size_25,
  i3_.width AS width_26,
  i3_.height AS height_27,
  i3_.id AS id_28,
  i3_.created_at AS created_at_29,
  i3_.updated_at AS updated_at_30,
  i4_.title AS title_31,
  i4_.keywords AS keywords_32,
  i4_.locale AS locale_33,
  i4_.id AS id_34,
  m0_.category_id AS category_id_35,
  m0_.parent_id AS parent_id_36,
  c1_.principal_image_id AS principal_image_id_37,
  c2_.translatable_id AS translatable_id_38,
  i4_.translatable_id AS translatable_id_39
FROM
  menu_sk m0_
  LEFT JOIN category c1_ ON m0_.category_id = c1_.id
  LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id
  AND (
    c2_.locale IN (?)
  )
  LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id
  LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id
  AND (
    i4_.locale IN (?)
  )
ORDER BY
  m0_.lft ASC

SELECT m0_.alias AS alias_0, m0_.lft AS lft_1, m0_.rgt AS rgt_2, m0_.lvl AS lvl_3, m0_.root AS root_4, m0_.id AS id_5, c1_.main_template AS main_template_6, c1_.product_template AS product_template_7, c1_.filterable AS filterable_8, c1_.id AS id_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c2_.slug AS slug_12, c2_.title AS title_13, c2_.h1 AS h1_14, c2_.perex AS perex_15, c2_.description AS description_16, c2_.meta_title AS meta_title_17, c2_.meta_description AS meta_description_18, c2_.meta_keywords AS meta_keywords_19, c2_.locale AS locale_20, c2_.id AS id_21, i3_.name AS name_22, i3_.original_name AS original_name_23, i3_.mime_type AS mime_type_24, i3_.size AS size_25, i3_.width AS width_26, i3_.height AS height_27, i3_.id AS id_28, i3_.created_at AS created_at_29, i3_.updated_at AS updated_at_30, i4_.title AS title_31, i4_.keywords AS keywords_32, i4_.locale AS locale_33, i4_.id AS id_34, m0_.category_id AS category_id_35, m0_.parent_id AS parent_id_36, c1_.principal_image_id AS principal_image_id_37, c2_.translatable_id AS translatable_id_38, i4_.translatable_id AS translatable_id_39 FROM menu_sk m0_ LEFT JOIN category c1_ ON m0_.category_id = c1_.id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale IN ('sk')) LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN ('sk')) ORDER BY m0_.lft ASC;

SELECT
  RAND() AS sclr_0,
  p0_.type AS type_1,
  p0_.warranty_years AS warranty_years_2,
  p0_.new AS new_3,
  p0_.id AS id_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6,
  s1_.sku AS sku_7,
  s1_.quantity AS quantity_8,
  s1_.quantity_unit AS quantity_unit_9,
  s1_.ean_code AS ean_code_10,
  s1_.availability AS availability_11,
  s1_.`condition` AS condition_12,
  s1_.importable AS importable_13,
  s1_.tax_transferable AS tax_transferable_14,
  s1_.sale_count AS sale_count_15,
  s1_.disabled_at AS disabled_at_16,
  s1_.id AS id_17,
  s1_.created_at AS created_at_18,
  s1_.updated_at AS updated_at_19,
  s1_.enabled AS enabled_20,
  v2_.id AS id_21,
  v2_.position AS position_22,
  v2_.created_at AS created_at_23,
  v2_.updated_at AS updated_at_24,
  s3_.amount AS amount_25,
  s3_.tax_amount AS tax_amount_26,
  s3_.previous_amount AS previous_amount_27,
  s3_.previous_tax_amount AS previous_tax_amount_28,
  s3_.id AS id_29,
  s3_.created_at AS created_at_30,
  s3_.updated_at AS updated_at_31,
  t4_.rate AS rate_32,
  t4_.`precision` AS precision_33,
  t4_.id AS id_34,
  p5_.title AS title_35,
  p5_.h1 AS h1_36,
  p5_.perex AS perex_37,
  p5_.description AS description_38,
  p5_.text AS text_39,
  p5_.meta_title AS meta_title_40,
  p5_.meta_description AS meta_description_41,
  p5_.meta_keywords AS meta_keywords_42,
  p5_.slug AS slug_43,
  p5_.locale AS locale_44,
  p5_.id AS id_45,
  i6_.name AS name_46,
  i6_.original_name AS original_name_47,
  i6_.mime_type AS mime_type_48,
  i6_.size AS size_49,
  i6_.width AS width_50,
  i6_.height AS height_51,
  i6_.id AS id_52,
  i6_.created_at AS created_at_53,
  i6_.updated_at AS updated_at_54,
  i7_.title AS title_55,
  i7_.keywords AS keywords_56,
  i7_.locale AS locale_57,
  i7_.id AS id_58,
  p0_.principal_category_id AS principal_category_id_59,
  p0_.principal_image_id AS principal_image_id_60,
  p0_.manufacturer_id AS manufacturer_id_61,
  p0_.product_class_id AS product_class_id_62,
  p0_.stock_id AS stock_id_63,
  s1_.group_id AS group_id_64,
  v2_.principal_image_id AS principal_image_id_65,
  v2_.product_id AS product_id_66,
  v2_.stock_id AS stock_id_67,
  s3_.stock_id AS stock_id_68,
  s3_.store_id AS store_id_69,
  s3_.user_id AS user_id_70,
  s3_.tax_rate_id AS tax_rate_id_71,
  s3_.previous_tax_rate_id AS previous_tax_rate_id_72,
  t4_.store_id AS store_id_73,
  p5_.translatable_id AS translatable_id_74,
  i7_.translatable_id AS translatable_id_75
FROM
  product p0_
  INNER JOIN stock s1_ ON p0_.stock_id = s1_.id
  LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id
  INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id
  AND (s3_.store_id = ?)
  INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id
  INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id
  AND (
    p5_.locale IN (?)
  )
  LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id
  LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id
  AND (
    i7_.locale IN (?)
  )
  INNER JOIN product_category p8_ ON p0_.id = p8_.product_id
  INNER JOIN category c9_ ON p8_.category_id = c9_.id
  INNER JOIN recommended_category_category r11_ ON c9_.id = r11_.category_id
  INNER JOIN category c10_ ON c10_.id = r11_.recommended_id
  AND (
    c10_.id IN (?)
  )
WHERE
  s1_.enabled = 1
  AND p0_.id NOT IN (?)
GROUP BY
  s1_.id
ORDER BY
  sclr_0 ASC
LIMIT
  12

SELECT RAND() AS sclr_0, p0_.type AS type_1, p0_.warranty_years AS warranty_years_2, p0_.new AS new_3, p0_.id AS id_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, s1_.sku AS sku_7, s1_.quantity AS quantity_8, s1_.quantity_unit AS quantity_unit_9, s1_.ean_code AS ean_code_10, s1_.availability AS availability_11, s1_.`condition` AS condition_12, s1_.importable AS importable_13, s1_.tax_transferable AS tax_transferable_14, s1_.sale_count AS sale_count_15, s1_.disabled_at AS disabled_at_16, s1_.id AS id_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, s1_.enabled AS enabled_20, v2_.id AS id_21, v2_.position AS position_22, v2_.created_at AS created_at_23, v2_.updated_at AS updated_at_24, s3_.amount AS amount_25, s3_.tax_amount AS tax_amount_26, s3_.previous_amount AS previous_amount_27, s3_.previous_tax_amount AS previous_tax_amount_28, s3_.id AS id_29, s3_.created_at AS created_at_30, s3_.updated_at AS updated_at_31, t4_.rate AS rate_32, t4_.`precision` AS precision_33, t4_.id AS id_34, p5_.title AS title_35, p5_.h1 AS h1_36, p5_.perex AS perex_37, p5_.description AS description_38, p5_.text AS text_39, p5_.meta_title AS meta_title_40, p5_.meta_description AS meta_description_41, p5_.meta_keywords AS meta_keywords_42, p5_.slug AS slug_43, p5_.locale AS locale_44, p5_.id AS id_45, i6_.name AS name_46, i6_.original_name AS original_name_47, i6_.mime_type AS mime_type_48, i6_.size AS size_49, i6_.width AS width_50, i6_.height AS height_51, i6_.id AS id_52, i6_.created_at AS created_at_53, i6_.updated_at AS updated_at_54, i7_.title AS title_55, i7_.keywords AS keywords_56, i7_.locale AS locale_57, i7_.id AS id_58, p0_.principal_category_id AS principal_category_id_59, p0_.principal_image_id AS principal_image_id_60, p0_.manufacturer_id AS manufacturer_id_61, p0_.product_class_id AS product_class_id_62, p0_.stock_id AS stock_id_63, s1_.group_id AS group_id_64, v2_.principal_image_id AS principal_image_id_65, v2_.product_id AS product_id_66, v2_.stock_id AS stock_id_67, s3_.stock_id AS stock_id_68, s3_.store_id AS store_id_69, s3_.user_id AS user_id_70, s3_.tax_rate_id AS tax_rate_id_71, s3_.previous_tax_rate_id AS previous_tax_rate_id_72, t4_.store_id AS store_id_73, p5_.translatable_id AS translatable_id_74, i7_.translatable_id AS translatable_id_75 FROM product p0_ INNER JOIN stock s1_ ON p0_.stock_id = s1_.id LEFT JOIN variant v2_ ON s1_.id = v2_.stock_id INNER JOIN stock_price s3_ ON s1_.id = s3_.stock_id AND (s3_.store_id = 1) INNER JOIN tax_rate t4_ ON s3_.tax_rate_id = t4_.id INNER JOIN product_translation p5_ ON p0_.id = p5_.translatable_id AND (p5_.locale IN ('sk')) LEFT JOIN image i6_ ON p0_.principal_image_id = i6_.id LEFT JOIN image_translation i7_ ON i6_.id = i7_.translatable_id AND (i7_.locale IN ('sk')) INNER JOIN product_category p8_ ON p0_.id = p8_.product_id INNER JOIN category c9_ ON p8_.category_id = c9_.id INNER JOIN recommended_category_category r11_ ON c9_.id = r11_.category_id INNER JOIN category c10_ ON c10_.id = r11_.recommended_id AND (c10_.id IN (129)) WHERE s1_.enabled = 1 AND p0_.id NOT IN (4468) GROUP BY s1_.id ORDER BY sclr_0 ASC LIMIT 12;

SELECT
  t0.sku AS sku_1,
  t0.quantity AS quantity_2,
  t0.quantity_unit AS quantity_unit_3,
  t0.ean_code AS ean_code_4,
  t0.availability AS availability_5,
  t0.`condition` AS condition_6,
  t0.importable AS importable_7,
  t0.tax_transferable AS tax_transferable_8,
  t0.sale_count AS sale_count_9,
  t0.disabled_at AS disabled_at_10,
  t0.id AS id_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.enabled AS enabled_14,
  t0.group_id AS group_id_15,
  t16.type AS type_17,
  t16.warranty_years AS warranty_years_18,
  t16.new AS new_19,
  t16.id AS id_20,
  t16.created_at AS created_at_21,
  t16.updated_at AS updated_at_22,
  t16.principal_category_id AS principal_category_id_23,
  t16.principal_image_id AS principal_image_id_24,
  t16.manufacturer_id AS manufacturer_id_25,
  t16.product_class_id AS product_class_id_26,
  t16.stock_id AS stock_id_27,
  t28.id AS id_29,
  t28.position AS position_30,
  t28.created_at AS created_at_31,
  t28.updated_at AS updated_at_32,
  t28.principal_image_id AS principal_image_id_33,
  t28.product_id AS product_id_34,
  t28.stock_id AS stock_id_35
FROM
  stock t0
  LEFT JOIN product t16 ON t16.stock_id = t0.id
  LEFT JOIN variant t28 ON t28.stock_id = t0.id
WHERE
  t0.id = ?

SELECT t0.sku AS sku_1, t0.quantity AS quantity_2, t0.quantity_unit AS quantity_unit_3, t0.ean_code AS ean_code_4, t0.availability AS availability_5, t0.`condition` AS condition_6, t0.importable AS importable_7, t0.tax_transferable AS tax_transferable_8, t0.sale_count AS sale_count_9, t0.disabled_at AS disabled_at_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.enabled AS enabled_14, t0.group_id AS group_id_15, t16.type AS type_17, t16.warranty_years AS warranty_years_18, t16.new AS new_19, t16.id AS id_20, t16.created_at AS created_at_21, t16.updated_at AS updated_at_22, t16.principal_category_id AS principal_category_id_23, t16.principal_image_id AS principal_image_id_24, t16.manufacturer_id AS manufacturer_id_25, t16.product_class_id AS product_class_id_26, t16.stock_id AS stock_id_27, t28.id AS id_29, t28.position AS position_30, t28.created_at AS created_at_31, t28.updated_at AS updated_at_32, t28.principal_image_id AS principal_image_id_33, t28.product_id AS product_id_34, t28.stock_id AS stock_id_35 FROM stock t0 LEFT JOIN product t16 ON t16.stock_id = t0.id LEFT JOIN variant t28 ON t28.stock_id = t0.id WHERE t0.id = 905;

SELECT
  t0.amount AS amount_1,
  t0.tax_amount AS tax_amount_2,
  t0.previous_amount AS previous_amount_3,
  t0.previous_tax_amount AS previous_tax_amount_4,
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.stock_id AS stock_id_8,
  t0.store_id AS store_id_9,
  t0.user_id AS user_id_10,
  t0.tax_rate_id AS tax_rate_id_11,
  t0.previous_tax_rate_id AS previous_tax_rate_id_12
FROM
  stock_price t0
WHERE
  t0.stock_id = ?

SELECT t0.amount AS amount_1, t0.tax_amount AS tax_amount_2, t0.previous_amount AS previous_amount_3, t0.previous_tax_amount AS previous_tax_amount_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.stock_id AS stock_id_8, t0.store_id AS store_id_9, t0.user_id AS user_id_10, t0.tax_rate_id AS tax_rate_id_11, t0.previous_tax_rate_id AS previous_tax_rate_id_12 FROM stock_price t0 WHERE t0.stock_id = 905;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.principal_image_id AS principal_image_id_5,
  t0.product_id AS product_id_6,
  t0.stock_id AS stock_id_7,
  t8.sku AS sku_9,
  t8.quantity AS quantity_10,
  t8.quantity_unit AS quantity_unit_11,
  t8.ean_code AS ean_code_12,
  t8.availability AS availability_13,
  t8.`condition` AS condition_14,
  t8.importable AS importable_15,
  t8.tax_transferable AS tax_transferable_16,
  t8.sale_count AS sale_count_17,
  t8.disabled_at AS disabled_at_18,
  t8.id AS id_19,
  t8.created_at AS created_at_20,
  t8.updated_at AS updated_at_21,
  t8.enabled AS enabled_22,
  t8.group_id AS group_id_23
FROM
  variant t0
  LEFT JOIN stock t8 ON t0.stock_id = t8.id
WHERE
  t0.product_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.principal_image_id AS principal_image_id_5, t0.product_id AS product_id_6, t0.stock_id AS stock_id_7, t8.sku AS sku_9, t8.quantity AS quantity_10, t8.quantity_unit AS quantity_unit_11, t8.ean_code AS ean_code_12, t8.availability AS availability_13, t8.`condition` AS condition_14, t8.importable AS importable_15, t8.tax_transferable AS tax_transferable_16, t8.sale_count AS sale_count_17, t8.disabled_at AS disabled_at_18, t8.id AS id_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t8.enabled AS enabled_22, t8.group_id AS group_id_23 FROM variant t0 LEFT JOIN stock t8 ON t0.stock_id = t8.id WHERE t0.product_id = 3802 ORDER BY t0.position ASC;

SELECT
  t0.position AS position_1,
  t0.variant_id AS variant_id_2,
  t0.attribute_option_id AS attribute_option_id_3
FROM
  variant_attribute t0
WHERE
  t0.variant_id = ?
ORDER BY
  t0.position ASC

SELECT t0.position AS position_1, t0.variant_id AS variant_id_2, t0.attribute_option_id AS attribute_option_id_3 FROM variant_attribute t0 WHERE t0.variant_id = 1637 ORDER BY t0.position ASC;

SELECT
  t0.title AS title_1,
  t0.keywords AS keywords_2,
  t0.locale AS locale_3,
  t0.id AS id_4,
  t0.translatable_id AS translatable_id_5
FROM
  image_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.title AS title_1, t0.keywords AS keywords_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM image_translation t0 WHERE t0.translatable_id = 9241;

SELECT
  t0.name AS name_1,
  t0.original_name AS original_name_2,
  t0.mime_type AS mime_type_3,
  t0.size AS size_4,
  t0.width AS width_5,
  t0.height AS height_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  image t0
WHERE
  t0.id = ?