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
  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) = ?

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) = 'okenni-pevna-sit-proti-hmyzu-ext-16';

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 = ?

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

SELECT
  DISTINCT p0_.minimal_amount AS minimal_amount_0
FROM
  price p0_
WHERE
  p0_.product_variant_id = ?
  AND p0_.valid_from <= ?
  AND (
    p0_.valid_until IS NULL
    OR p0_.valid_until >= ?
  )
ORDER BY
  p0_.minimal_amount ASC

SELECT DISTINCT p0_.minimal_amount AS minimal_amount_0 FROM price p0_ WHERE p0_.product_variant_id = 64 AND p0_.valid_from <= '2026-03-30 03:18:32' AND (p0_.valid_until IS NULL OR p0_.valid_until >= '2026-03-30 03:18:32') ORDER BY p0_.minimal_amount ASC;

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 = 2 AND c0_.valid_from <= '2026-03-30 03:18:32' 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 = 64 AND p0_.valid_from <= '2026-03-30 03:18:32' AND (p0_.valid_until >= '2026-03-30 03:18:32' 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 = 4216;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unit AS unit_3,
  t0.class AS class_4,
  t0.is_filter AS is_filter_5,
  t0.type_id AS type_id_6,
  t0.parameter_group_filter_type_id AS parameter_group_filter_type_id_7,
  t0.parameter_group_format_id AS parameter_group_format_id_8
FROM
  parameter_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.class AS class_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6, t0.parameter_group_filter_type_id AS parameter_group_filter_type_id_7, t0.parameter_group_format_id AS parameter_group_format_id_8 FROM parameter_group t0 WHERE t0.id = 3;

SELECT
  DISTINCT p0_.minimal_amount AS minimal_amount_0
FROM
  price p0_
WHERE
  p0_.product_variant_id = ?
  AND p0_.valid_from <= ?
  AND (
    p0_.valid_until IS NULL
    OR p0_.valid_until >= ?
  )
ORDER BY
  p0_.minimal_amount ASC

SELECT DISTINCT p0_.minimal_amount AS minimal_amount_0 FROM price p0_ WHERE p0_.product_variant_id = 64 AND p0_.valid_from <= '2026-03-30 03:18:33' AND (p0_.valid_until IS NULL OR p0_.valid_until >= '2026-03-30 03:18:33') ORDER BY p0_.minimal_amount ASC;

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 = 2 AND c0_.valid_from <= '2026-03-30 03:18:33' 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 = 64 AND p0_.valid_from <= '2026-03-30 03:18:33' AND (p0_.valid_until >= '2026-03-30 03:18:33' 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.template AS template_3
FROM
  product_view_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3 FROM product_view_type t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.template AS template_3,
  t0.controller_name AS controller_name_4
FROM
  menu_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM menu_type t0 WHERE t0.id = '4';

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_.html) AS html_4,
  COALESCE(t5_.content, p0_.title) AS title_5,
  p0_.is_active AS is_active_6,
  COALESCE(t6_.content, p0_.slug) AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14,
  p0_.is_indexable AS is_indexable_15,
  p0_.created_at AS created_at_16,
  p0_.published_at AS published_at_17,
  p0_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
FROM
  p_category p0_
  LEFT JOIN p_category_category p7_ ON p0_.id = p7_.category_sub_id
  LEFT JOIN category_menu_type c8_ ON p0_.id = c8_.category_id
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'name'
  AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  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\\Category'
  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\\Category'
  AND t3_.foreign_key = p0_.id
  LEFT JOIN ext_translations t4_ ON t4_.locale = 'en'
  AND t4_.field = 'html'
  AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t4_.foreign_key = p0_.id
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'en'
  AND t5_.field = 'title'
  AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t5_.foreign_key = p0_.id
  LEFT JOIN ext_translations t6_ ON t6_.locale = 'en'
  AND t6_.field = 'slug'
  AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category'
  AND t6_.foreign_key = p0_.id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p7_.id IS NULL
  AND c8_.menu_type_id = ?
ORDER BY
  c8_.sequence ASC