Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.symbol AS symbol_2,
  c0_.rounding AS rounding_3,
  c0_.is_default AS is_default_4,
  c0_.default_locale AS default_locale_5,
  c0_.is_symbol_left AS is_symbol_left_6,
  c0_.is_deleted AS is_deleted_7
FROM
  currency c0_
WHERE
  c0_.default_locale = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = 'en' LIMIT 1;

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.is_default = ?
LIMIT
  1

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.is_default = 1 LIMIT 1;

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;

SELECT
  p0_.id AS id_0,
  COALESCE(t1_.content, p0_.name) AS name_1,
  COALESCE(t2_.content, p0_.menu_name) AS menu_name_2,
  COALESCE(t3_.content, p0_.description) AS description_3,
  COALESCE(t4_.content, p0_.title) AS title_4,
  COALESCE(t5_.content, p0_.slug) AS slug_5,
  p0_.is_active AS is_active_6,
  p0_.is_visible AS is_visible_7,
  p0_.sequence AS sequence_8,
  p0_.javascript AS javascript_9,
  COALESCE(t6_.content, p0_.text_general) AS text_general_10,
  p0_.state AS state_11,
  p0_.external_id AS external_id_12,
  p0_.is_indexable AS is_indexable_13,
  COALESCE(
    t7_.content, p0_.meta_description
  ) AS meta_description_14,
  p0_.has_variant_picture AS has_variant_picture_15,
  p0_.sold_amount AS sold_amount_16,
  p0_.producer_id AS producer_id_17,
  p0_.upload_id AS upload_id_18,
  p0_.product_type_id AS product_type_id_19,
  p0_.product_view_type_id AS product_view_type_id_20
FROM
  product p0_
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'name'
  AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product'
  AND t1_.foreign_key = p0_.id
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'en'
  AND t2_.field = 'menu_name'
  AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product'
  AND t2_.foreign_key = p0_.id
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'en'
  AND t3_.field = 'description'
  AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product'
  AND t3_.foreign_key = p0_.id
  LEFT JOIN ext_translations t4_ ON t4_.locale = 'en'
  AND t4_.field = 'title'
  AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product'
  AND t4_.foreign_key = p0_.id
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'en'
  AND t5_.field = 'slug'
  AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product'
  AND t5_.foreign_key = p0_.id
  LEFT JOIN ext_translations t6_ ON t6_.locale = 'en'
  AND t6_.field = 'textGeneral'
  AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product'
  AND t6_.foreign_key = p0_.id
  LEFT JOIN ext_translations t7_ ON t7_.locale = 'en'
  AND t7_.field = 'metaDescription'
  AND t7_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product'
  AND t7_.foreign_key = p0_.id
WHERE
  (
    COALESCE(t5_.content, p0_.slug) = ?
  )
  AND (p0_.is_active = true)

SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.title) AS title_4, COALESCE(t5_.content, p0_.slug) AS slug_5, p0_.is_active AS is_active_6, p0_.is_visible AS is_visible_7, p0_.sequence AS sequence_8, p0_.javascript AS javascript_9, COALESCE(t6_.content, p0_.text_general) AS text_general_10, p0_.state AS state_11, p0_.external_id AS external_id_12, p0_.is_indexable AS is_indexable_13, COALESCE(t7_.content, p0_.meta_description) AS meta_description_14, p0_.has_variant_picture AS has_variant_picture_15, p0_.sold_amount AS sold_amount_16, p0_.producer_id AS producer_id_17, p0_.upload_id AS upload_id_18, p0_.product_type_id AS product_type_id_19, p0_.product_view_type_id AS product_view_type_id_20 FROM product p0_ LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'title' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'slug' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'textGeneral' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t6_.foreign_key = p0_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'metaDescription' AND t7_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Product' AND t7_.foreign_key = p0_.id WHERE (COALESCE(t5_.content, p0_.slug) = 'hene-lasery') AND (p0_.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.product_id AS product_id_8,
  t0.availability_id AS availability_id_9,
  t0.upload_id AS upload_id_10
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.product_id AS product_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10 FROM product_variant t0 WHERE t0.product_id = 132 AND ((t0.is_active = true));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.class AS class_4,
  t0.is_purchasable AS is_purchasable_5,
  t0.sequence AS sequence_6
FROM
  availability t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.class AS class_4, t0.is_purchasable AS is_purchasable_5, t0.sequence AS sequence_6 FROM availability t0 WHERE t0.id = 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_
WHERE
  a0_.is_purchasable = 1
ORDER BY
  a0_.sequence DESC
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_ WHERE a0_.is_purchasable = 1 ORDER BY a0_.sequence DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.vat AS vat_3,
  t0.minimal_amount AS minimal_amount_4,
  t0.discount AS discount_5,
  t0.valid_from AS valid_from_6,
  t0.valid_until AS valid_until_7,
  t0.created AS created_8,
  t0.is_package AS is_package_9,
  t0.min_price AS min_price_10,
  t0.product_variant_id AS product_variant_id_11,
  t0.event_id AS event_id_12,
  t13.id AS id_14,
  t13.amount AS amount_15,
  t13.state AS state_16,
  t13.delivery_from AS delivery_from_17,
  t13.delivery_until AS delivery_until_18,
  t13.purchase_id AS purchase_id_19,
  t13.product_variant_id AS product_variant_id_20,
  t13.price_id AS price_id_21
FROM
  price t0
  LEFT JOIN purchase_product_variant t13 ON t13.price_id = t0.id
WHERE
  t0.product_variant_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.vat AS vat_3, t0.minimal_amount AS minimal_amount_4, t0.discount AS discount_5, t0.valid_from AS valid_from_6, t0.valid_until AS valid_until_7, t0.created AS created_8, t0.is_package AS is_package_9, t0.min_price AS min_price_10, t0.product_variant_id AS product_variant_id_11, t0.event_id AS event_id_12, t13.id AS id_14, t13.amount AS amount_15, t13.state AS state_16, t13.delivery_from AS delivery_from_17, t13.delivery_until AS delivery_until_18, t13.purchase_id AS purchase_id_19, t13.product_variant_id AS product_variant_id_20, t13.price_id AS price_id_21 FROM price t0 LEFT JOIN purchase_product_variant t13 ON t13.price_id = t0.id WHERE t0.product_variant_id = 106;

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

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;

SELECT
  c0_.id AS id_0,
  c0_.created AS created_1,
  c0_.valid_from AS valid_from_2,
  c0_.rate AS rate_3,
  c0_.currency_id AS currency_id_4
FROM
  conversion_rate c0_
WHERE
  c0_.currency_id = ?
  AND c0_.valid_from <= ?
ORDER BY
  c0_.valid_from DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = 1 AND c0_.valid_from <= '2026-02-27 21:20:44' ORDER BY c0_.valid_from DESC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.price AS price_1,
  p0_.vat AS vat_2,
  p0_.minimal_amount AS minimal_amount_3,
  p0_.discount AS discount_4,
  p0_.valid_from AS valid_from_5,
  p0_.valid_until AS valid_until_6,
  p0_.created AS created_7,
  p0_.is_package AS is_package_8,
  p0_.min_price AS min_price_9,
  p0_.product_variant_id AS product_variant_id_10,
  p0_.event_id AS event_id_11
FROM
  price p0_
WHERE
  p0_.product_variant_id = ?
  AND p0_.valid_from <= ?
  AND (
    p0_.valid_until >= ?
    OR p0_.valid_until IS NULL
  )
ORDER BY
  p0_.minimal_amount ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, p0_.product_variant_id AS product_variant_id_10, p0_.event_id AS event_id_11 FROM price p0_ WHERE p0_.product_variant_id = 106 AND p0_.valid_from <= '2026-02-27 21:20:44' AND (p0_.valid_until >= '2026-02-27 21:20:44' OR p0_.valid_until IS NULL) ORDER BY p0_.minimal_amount ASC LIMIT 1;

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 = 1086;

SELECT
  t0.id AS id_1,
  t0.data AS data_2,
  t0.sequence AS sequence_3,
  t0.parameter_group_id AS parameter_group_id_4,
  t0.category_id AS category_id_5,
  t0.product_variant_id AS product_variant_id_6,
  t0.person_id AS person_id_7
FROM
  parameter t0
WHERE
  t0.product_variant_id = ?

SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = 106;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.vat AS vat_3,
  t0.minimal_amount AS minimal_amount_4,
  t0.discount AS discount_5,
  t0.valid_from AS valid_from_6,
  t0.valid_until AS valid_until_7,
  t0.created AS created_8,
  t0.is_package AS is_package_9,
  t0.min_price AS min_price_10,
  t0.product_variant_id AS product_variant_id_11,
  t0.event_id AS event_id_12,
  t13.id AS id_14,
  t13.amount AS amount_15,
  t13.state AS state_16,
  t13.delivery_from AS delivery_from_17,
  t13.delivery_until AS delivery_until_18,
  t13.purchase_id AS purchase_id_19,
  t13.product_variant_id AS product_variant_id_20,
  t13.price_id AS price_id_21
FROM
  price t0
  LEFT JOIN purchase_product_variant t13 ON t13.price_id = t0.id
WHERE
  t0.product_variant_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.vat AS vat_3, t0.minimal_amount AS minimal_amount_4, t0.discount AS discount_5, t0.valid_from AS valid_from_6, t0.valid_until AS valid_until_7, t0.created AS created_8, t0.is_package AS is_package_9, t0.min_price AS min_price_10, t0.product_variant_id AS product_variant_id_11, t0.event_id AS event_id_12, t13.id AS id_14, t13.amount AS amount_15, t13.state AS state_16, t13.delivery_from AS delivery_from_17, t13.delivery_until AS delivery_until_18, t13.purchase_id AS purchase_id_19, t13.product_variant_id AS product_variant_id_20, t13.price_id AS price_id_21 FROM price t0 LEFT JOIN purchase_product_variant t13 ON t13.price_id = t0.id WHERE t0.product_variant_id = 106;

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

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;