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

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.description AS description_2,
  t0_.description_mail AS description_mail_3,
  t0_.description_duration AS description_duration_4,
  t0_.html AS html_5,
  t0_.icon AS icon_6,
  t0_.duration AS duration_7,
  t0_.squence AS squence_8,
  t0_.country AS country_9,
  t0_.state_url AS state_url_10,
  t0_.is_enabled AS is_enabled_11,
  t0_.token AS token_12,
  t0_.secret_key AS secret_key_13,
  t0_.transportation_action AS transportation_action_14,
  t0_.transportation_api AS transportation_api_15,
  t0_.export_names AS export_names_16,
  p1_.id AS id_17,
  p1_.name AS name_18,
  p1_.description AS description_19,
  p1_.descrition_mail AS descrition_mail_20,
  p1_.description_duration AS description_duration_21,
  p1_.html AS html_22,
  p1_.icon AS icon_23,
  p1_.duration AS duration_24,
  p1_.sequence AS sequence_25,
  p1_.country AS country_26,
  p1_.is_enabled AS is_enabled_27,
  p1_.action_group AS action_group_28,
  p1_.account AS account_29,
  p1_.bank_number AS bank_number_30,
  p1_.iban AS iban_31,
  p1_.bank_name AS bank_name_32,
  p1_.payment_technical_action AS payment_technical_action_33,
  p1_.export_names AS export_names_34,
  h2_.id AS id_35,
  h2_.price AS price_36,
  h2_.free_from_price AS free_from_price_37,
  h2_.discount AS discount_38,
  h2_.vat AS vat_39,
  h2_.valid_from AS valid_from_40,
  h2_.valid_until AS valid_until_41,
  h2_.created AS created_42,
  t3_.id AS id_43,
  t3_.name AS name_44,
  t3_.description AS description_45,
  t3_.icon AS icon_46,
  t3_.country AS country_47,
  h2_.transportation_id AS transportation_id_48,
  h2_.payment_type_id AS payment_type_id_49
FROM
  transportation t0_
  LEFT JOIN transportation_payment_type t4_ ON t0_.id = t4_.transportation_id
  LEFT JOIN payment_type p1_ ON p1_.id = t4_.payment_type_id
  LEFT JOIN handling_price h2_ ON t0_.id = h2_.transportation_id
  LEFT JOIN transportation_transportation_group t5_ ON t0_.id = t5_.transportation_id
  LEFT JOIN transportation_group t3_ ON t3_.id = t5_.transportation_group_id
WHERE
  (t0_.id = ?)
  AND (t0_.is_enabled = true)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.description_mail AS description_mail_3, t0_.description_duration AS description_duration_4, t0_.html AS html_5, t0_.icon AS icon_6, t0_.duration AS duration_7, t0_.squence AS squence_8, t0_.country AS country_9, t0_.state_url AS state_url_10, t0_.is_enabled AS is_enabled_11, t0_.token AS token_12, t0_.secret_key AS secret_key_13, t0_.transportation_action AS transportation_action_14, t0_.transportation_api AS transportation_api_15, t0_.export_names AS export_names_16, p1_.id AS id_17, p1_.name AS name_18, p1_.description AS description_19, p1_.descrition_mail AS descrition_mail_20, p1_.description_duration AS description_duration_21, p1_.html AS html_22, p1_.icon AS icon_23, p1_.duration AS duration_24, p1_.sequence AS sequence_25, p1_.country AS country_26, p1_.is_enabled AS is_enabled_27, p1_.action_group AS action_group_28, p1_.account AS account_29, p1_.bank_number AS bank_number_30, p1_.iban AS iban_31, p1_.bank_name AS bank_name_32, p1_.payment_technical_action AS payment_technical_action_33, p1_.export_names AS export_names_34, h2_.id AS id_35, h2_.price AS price_36, h2_.free_from_price AS free_from_price_37, h2_.discount AS discount_38, h2_.vat AS vat_39, h2_.valid_from AS valid_from_40, h2_.valid_until AS valid_until_41, h2_.created AS created_42, t3_.id AS id_43, t3_.name AS name_44, t3_.description AS description_45, t3_.icon AS icon_46, t3_.country AS country_47, h2_.transportation_id AS transportation_id_48, h2_.payment_type_id AS payment_type_id_49 FROM transportation t0_ LEFT JOIN transportation_payment_type t4_ ON t0_.id = t4_.transportation_id LEFT JOIN payment_type p1_ ON p1_.id = t4_.payment_type_id LEFT JOIN handling_price h2_ ON t0_.id = h2_.transportation_id LEFT JOIN transportation_transportation_group t5_ ON t0_.id = t5_.transportation_id LEFT JOIN transportation_group t3_ ON t3_.id = t5_.transportation_group_id WHERE (t0_.id = 6) AND (t0_.is_enabled = 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;

SELECT
  h0_.id AS id_0,
  h0_.price AS price_1,
  h0_.free_from_price AS free_from_price_2,
  h0_.discount AS discount_3,
  h0_.vat AS vat_4,
  h0_.valid_from AS valid_from_5,
  h0_.valid_until AS valid_until_6,
  h0_.created AS created_7,
  h0_.transportation_id AS transportation_id_8,
  h0_.payment_type_id AS payment_type_id_9
FROM
  handling_price h0_
WHERE
  h0_.transportation_id = ?
  AND h0_.valid_from <= ?
  AND (
    h0_.valid_until >= ?
    OR h0_.valid_until IS NULL
  )

SELECT h0_.id AS id_0, h0_.price AS price_1, h0_.free_from_price AS free_from_price_2, h0_.discount AS discount_3, h0_.vat AS vat_4, h0_.valid_from AS valid_from_5, h0_.valid_until AS valid_until_6, h0_.created AS created_7, h0_.transportation_id AS transportation_id_8, h0_.payment_type_id AS payment_type_id_9 FROM handling_price h0_ WHERE h0_.transportation_id = 6 AND h0_.valid_from <= '2026-07-02 21:13:30' AND (h0_.valid_until >= '2026-07-02 21:13:30' OR h0_.valid_until IS NULL);

SELECT
  h0_.id AS id_0,
  h0_.price AS price_1,
  h0_.free_from_price AS free_from_price_2,
  h0_.discount AS discount_3,
  h0_.vat AS vat_4,
  h0_.valid_from AS valid_from_5,
  h0_.valid_until AS valid_until_6,
  h0_.created AS created_7,
  h0_.transportation_id AS transportation_id_8,
  h0_.payment_type_id AS payment_type_id_9
FROM
  handling_price h0_
WHERE
  h0_.transportation_id = ?
  AND h0_.valid_from <= ?
  AND (
    h0_.valid_until >= ?
    OR h0_.valid_until IS NULL
  )

SELECT h0_.id AS id_0, h0_.price AS price_1, h0_.free_from_price AS free_from_price_2, h0_.discount AS discount_3, h0_.vat AS vat_4, h0_.valid_from AS valid_from_5, h0_.valid_until AS valid_until_6, h0_.created AS created_7, h0_.transportation_id AS transportation_id_8, h0_.payment_type_id AS payment_type_id_9 FROM handling_price h0_ WHERE h0_.transportation_id = 6 AND h0_.valid_from <= '2026-07-02 21:13:30' AND (h0_.valid_until >= '2026-07-02 21:13:30' OR h0_.valid_until IS NULL);

SELECT
  h0_.id AS id_0,
  h0_.price AS price_1,
  h0_.free_from_price AS free_from_price_2,
  h0_.discount AS discount_3,
  h0_.vat AS vat_4,
  h0_.valid_from AS valid_from_5,
  h0_.valid_until AS valid_until_6,
  h0_.created AS created_7,
  h0_.transportation_id AS transportation_id_8,
  h0_.payment_type_id AS payment_type_id_9
FROM
  handling_price h0_
WHERE
  h0_.payment_type_id = ?
  AND h0_.valid_from <= ?
  AND (
    h0_.valid_until >= ?
    OR h0_.valid_until IS NULL
  )

SELECT h0_.id AS id_0, h0_.price AS price_1, h0_.free_from_price AS free_from_price_2, h0_.discount AS discount_3, h0_.vat AS vat_4, h0_.valid_from AS valid_from_5, h0_.valid_until AS valid_until_6, h0_.created AS created_7, h0_.transportation_id AS transportation_id_8, h0_.payment_type_id AS payment_type_id_9 FROM handling_price h0_ WHERE h0_.payment_type_id = 1 AND h0_.valid_from <= '2026-07-02 21:13:30' AND (h0_.valid_until >= '2026-07-02 21:13:30' OR h0_.valid_until IS NULL);

SELECT
  h0_.id AS id_0,
  h0_.price AS price_1,
  h0_.free_from_price AS free_from_price_2,
  h0_.discount AS discount_3,
  h0_.vat AS vat_4,
  h0_.valid_from AS valid_from_5,
  h0_.valid_until AS valid_until_6,
  h0_.created AS created_7,
  h0_.transportation_id AS transportation_id_8,
  h0_.payment_type_id AS payment_type_id_9
FROM
  handling_price h0_
WHERE
  h0_.payment_type_id = ?
  AND h0_.valid_from <= ?
  AND (
    h0_.valid_until >= ?
    OR h0_.valid_until IS NULL
  )

SELECT h0_.id AS id_0, h0_.price AS price_1, h0_.free_from_price AS free_from_price_2, h0_.discount AS discount_3, h0_.vat AS vat_4, h0_.valid_from AS valid_from_5, h0_.valid_until AS valid_until_6, h0_.created AS created_7, h0_.transportation_id AS transportation_id_8, h0_.payment_type_id AS payment_type_id_9 FROM handling_price h0_ WHERE h0_.payment_type_id = 2 AND h0_.valid_from <= '2026-07-02 21:13:30' AND (h0_.valid_until >= '2026-07-02 21:13:30' OR h0_.valid_until IS NULL);

SELECT
  h0_.id AS id_0,
  h0_.price AS price_1,
  h0_.free_from_price AS free_from_price_2,
  h0_.discount AS discount_3,
  h0_.vat AS vat_4,
  h0_.valid_from AS valid_from_5,
  h0_.valid_until AS valid_until_6,
  h0_.created AS created_7,
  h0_.transportation_id AS transportation_id_8,
  h0_.payment_type_id AS payment_type_id_9
FROM
  handling_price h0_
WHERE
  h0_.payment_type_id = ?
  AND h0_.valid_from <= ?
  AND (
    h0_.valid_until >= ?
    OR h0_.valid_until IS NULL
  )

SELECT h0_.id AS id_0, h0_.price AS price_1, h0_.free_from_price AS free_from_price_2, h0_.discount AS discount_3, h0_.vat AS vat_4, h0_.valid_from AS valid_from_5, h0_.valid_until AS valid_until_6, h0_.created AS created_7, h0_.transportation_id AS transportation_id_8, h0_.payment_type_id AS payment_type_id_9 FROM handling_price h0_ WHERE h0_.payment_type_id = 3 AND h0_.valid_from <= '2026-07-02 21:13:30' AND (h0_.valid_until >= '2026-07-02 21:13:30' OR h0_.valid_until IS NULL);