Symfony Profiler

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,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.title AS title_4,
  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,
  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,
  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_
WHERE
  (p0_.slug = ?)
  AND (p0_.is_active = true)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.title AS title_4, 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, 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, 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_ WHERE (p0_.slug = 'ochranna-laserova-bunka') AND (p0_.is_active = true);

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.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 = 56001 AND ((t0.is_active = true));

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,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  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 p1_ ON p0_.id = p1_.category_sub_id
  LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p1_.id IS NULL
  AND c2_.menu_type_id = ?
ORDER BY
  c2_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, 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 p1_ ON p0_.id = p1_.category_sub_id LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p1_.id IS NULL AND c2_.menu_type_id = 4 ORDER BY c2_.sequence ASC;

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 = '1';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  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 p1_ ON p0_.id = p1_.category_sub_id
  LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p1_.id IS NULL
  AND c2_.menu_type_id = ?
ORDER BY
  c2_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, 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 p1_ ON p0_.id = p1_.category_sub_id LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p1_.id IS NULL AND c2_.menu_type_id = 1 ORDER BY c2_.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.template AS template_3,
  t0.controller_name AS controller_name_4
FROM
  sub_menu_type t0
  INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id
WHERE
  category_sub_menu_type.category_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 sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id WHERE category_sub_menu_type.category_id = 2141;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  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,
  u1_.id AS id_18,
  u1_.name AS name_19,
  u1_.extension AS extension_20,
  u1_.mime AS mime_21,
  u1_.title AS title_22,
  u1_.short_description AS short_description_23,
  u1_.description AS description_24,
  u1_.created AS created_25,
  u1_.path AS path_26,
  u1_.original_name AS original_name_27,
  u1_.width AS width_28,
  u1_.height AS height_29,
  u1_.sequence AS sequence_30,
  u1_.restriction AS restriction_31,
  p0_.category_type_id AS category_type_id_32,
  p0_.upload_id AS upload_id_33,
  u1_.upload_group_id AS upload_group_id_34,
  u1_.upload_type_id AS upload_type_id_35
FROM
  p_category p0_
  LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id
  LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id
  LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id
  LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p0_.id <> ?
  AND p4_.category_super_id = ?
  AND s2_.id = ?
  AND p0_.category_type_id IN (?)
ORDER BY
  p4_.sequence ASC,
  p0_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, 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, u1_.id AS id_18, u1_.name AS name_19, u1_.extension AS extension_20, u1_.mime AS mime_21, u1_.title AS title_22, u1_.short_description AS short_description_23, u1_.description AS description_24, u1_.created AS created_25, u1_.path AS path_26, u1_.original_name AS original_name_27, u1_.width AS width_28, u1_.height AS height_29, u1_.sequence AS sequence_30, u1_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u1_.upload_group_id AS upload_group_id_34, u1_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p0_.id <> 2141 AND p4_.category_super_id = 2141 AND s2_.id = 1 AND p0_.category_type_id IN (2) ORDER BY p4_.sequence ASC, p0_.sequence ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  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,
  u1_.id AS id_18,
  u1_.name AS name_19,
  u1_.extension AS extension_20,
  u1_.mime AS mime_21,
  u1_.title AS title_22,
  u1_.short_description AS short_description_23,
  u1_.description AS description_24,
  u1_.created AS created_25,
  u1_.path AS path_26,
  u1_.original_name AS original_name_27,
  u1_.width AS width_28,
  u1_.height AS height_29,
  u1_.sequence AS sequence_30,
  u1_.restriction AS restriction_31,
  p0_.category_type_id AS category_type_id_32,
  p0_.upload_id AS upload_id_33,
  u1_.upload_group_id AS upload_group_id_34,
  u1_.upload_type_id AS upload_type_id_35
FROM
  p_category p0_
  LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id
  LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id
  LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id
  LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p0_.id <> ?
  AND p4_.category_super_id = ?
  AND s2_.id = ?
  AND p0_.category_type_id NOT IN (?)
ORDER BY
  p4_.sequence ASC,
  p0_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, 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, u1_.id AS id_18, u1_.name AS name_19, u1_.extension AS extension_20, u1_.mime AS mime_21, u1_.title AS title_22, u1_.short_description AS short_description_23, u1_.description AS description_24, u1_.created AS created_25, u1_.path AS path_26, u1_.original_name AS original_name_27, u1_.width AS width_28, u1_.height AS height_29, u1_.sequence AS sequence_30, u1_.restriction AS restriction_31, p0_.category_type_id AS category_type_id_32, p0_.upload_id AS upload_id_33, u1_.upload_group_id AS upload_group_id_34, u1_.upload_type_id AS upload_type_id_35 FROM p_category p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id LEFT JOIN category_sub_menu_type c3_ ON p0_.id = c3_.category_id LEFT JOIN sub_menu_type s2_ ON s2_.id = c3_.sub_menu_type_id LEFT JOIN p_category_category p4_ ON p0_.id = p4_.category_sub_id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p0_.id <> 2141 AND p4_.category_super_id = 2141 AND s2_.id = 1 AND p0_.category_type_id NOT IN (2) ORDER BY p4_.sequence ASC, p0_.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.template AS template_3,
  t0.controller_name AS controller_name_4
FROM
  sub_menu_type t0
  INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id
WHERE
  category_sub_menu_type.category_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 sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id WHERE category_sub_menu_type.category_id = 2143;