Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.extension AS extension_2,
  u0_.mime AS mime_3,
  u0_.title AS title_4,
  u0_.short_description AS short_description_5,
  u0_.description AS description_6,
  u0_.created AS created_7,
  u0_.path AS path_8,
  u0_.original_name AS original_name_9,
  u0_.width AS width_10,
  u0_.height AS height_11,
  u0_.sequence AS sequence_12,
  u0_.restriction AS restriction_13,
  u0_.upload_group_id AS upload_group_id_14,
  u0_.upload_type_id AS upload_type_id_15
FROM
  upload u0_
  LEFT JOIN upload_group u1_ ON u0_.upload_group_id = u1_.id
  LEFT JOIN product_variant_upload_group p2_ ON u1_.id = p2_.upload_group_id
WHERE
  u1_.type = ?
  AND u0_.upload_type_id = ?
  AND p2_.product_variant_id = ?

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.restriction AS restriction_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ LEFT JOIN upload_group u1_ ON u0_.upload_group_id = u1_.id LEFT JOIN product_variant_upload_group p2_ ON u1_.id = p2_.upload_group_id WHERE u1_.type = 0 AND u0_.upload_type_id = 4 AND p2_.product_variant_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.extension AS extension_3,
  t0.mime AS mime_4,
  t0.title AS title_5,
  t0.short_description AS short_description_6,
  t0.description AS description_7,
  t0.created AS created_8,
  t0.path AS path_9,
  t0.original_name AS original_name_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.sequence AS sequence_13,
  t0.restriction AS restriction_14,
  t0.upload_group_id AS upload_group_id_15,
  t0.upload_type_id AS upload_type_id_16
FROM
  upload t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = 4246;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.menu_name AS menu_name_3,
  t0.description AS description_4,
  t0.title AS title_5,
  t0.slug AS slug_6,
  t0.is_active AS is_active_7,
  t0.is_visible AS is_visible_8,
  t0.sequence AS sequence_9,
  t0.javascript AS javascript_10,
  t0.text_general AS text_general_11,
  t0.state AS state_12,
  t0.external_id AS external_id_13,
  t0.is_indexable AS is_indexable_14,
  t0.meta_description AS meta_description_15,
  t0.has_variant_picture AS has_variant_picture_16,
  t0.sold_amount AS sold_amount_17,
  t0.additional_data AS additional_data_18,
  t0.is_deleted AS is_deleted_19,
  t0.producer_id AS producer_id_20,
  t0.upload_id AS upload_id_21,
  t0.product_type_id AS product_type_id_22,
  t0.product_view_type_id AS product_view_type_id_23
FROM
  product t0
WHERE
  t0.id = ?
  AND (
    (t0.is_active = true)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = '3' AND ((t0.is_active = true)) LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.class AS class_3,
  a0_.is_purchasable AS is_purchasable_4,
  a0_.sequence AS sequence_5
FROM
  availability a0_
  LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id
  AND (p1_.is_active = true)
WHERE
  p1_.product_id = ?
ORDER BY
  a0_.sequence ASC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = 3 ORDER BY a0_.sequence ASC LIMIT 1;

SELECT
  p0_.data AS data_0,
  p1_.name AS name_1
FROM
  parameter p0_
  LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id
  AND (p2_.is_active = true)
  LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id
WHERE
  p2_.product_id = ?

SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.rounding AS rounding_4,
  t0.is_default AS is_default_5,
  t0.default_locale AS default_locale_6,
  t0.is_symbol_left AS is_symbol_left_7,
  t0.is_deleted AS is_deleted_8
FROM
  currency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.rounding AS rounding_4, t0.is_default AS is_default_5, t0.default_locale AS default_locale_6, t0.is_symbol_left AS is_symbol_left_7, t0.is_deleted AS is_deleted_8 FROM currency t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stock AS stock_3,
  t0.external_id AS external_id_4,
  t0.avg_restock_days AS avg_restock_days_5,
  t0.expected_restock_date AS expected_restock_date_6,
  t0.is_active AS is_active_7,
  t0.is_deleted AS is_deleted_8,
  t0.product_id AS product_id_9,
  t0.availability_id AS availability_id_10,
  t0.upload_id AS upload_id_11
FROM
  product_variant t0
WHERE
  t0.product_id = ?
  AND (
    (t0.is_active = true)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.expected_restock_date AS expected_restock_date_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.product_id AS product_id_9, t0.availability_id AS availability_id_10, t0.upload_id AS upload_id_11 FROM product_variant t0 WHERE t0.product_id = 3 AND ((t0.is_active = true));

SELECT
  s0_.value AS value_0
FROM
  settings s0_
WHERE
  s0_.name = ?
ORDER BY
  s0_.name ASC
LIMIT
  1

SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = 'after_registration_discount' ORDER BY s0_.name ASC LIMIT 1;