Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.locales AS locales_2,
  c0_.active AS active_3,
  c0_.code AS code_4,
  c0_.deleted_at AS deleted_at_5,
  c0_.currency_id AS currency_id_6
FROM
  country c0_
WHERE
  (c0_.slug = ?)
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.slug = 'RU') AND (c0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.sign AS sign_3,
  t0.active AS active_4,
  t0.deleted_at AS deleted_at_5
FROM
  currency t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.sign AS sign_3, t0.active AS active_4, t0.deleted_at AS deleted_at_5 FROM currency t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.locales AS locales_2,
  c0_.active AS active_3,
  c0_.code AS code_4,
  c0_.deleted_at AS deleted_at_5,
  c0_.currency_id AS currency_id_6
FROM
  country c0_
WHERE
  (c0_.slug = ?)
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.slug = 'RU') AND (c0_.deleted_at IS NULL);

SELECT
  o0_.id AS id_0,
  o0_.promo_code AS promo_code_1,
  o0_.status AS status_2,
  o0_.cancel_reason AS cancel_reason_3,
  o0_.state AS state_4,
  o0_.tax_invoice AS tax_invoice_5,
  o0_.country AS country_6,
  o0_.city AS city_7,
  o0_.fiscal_number AS fiscal_number_8,
  o0_.event_hash AS event_hash_9,
  o0_.price AS price_10,
  o0_.insurance_amount AS insurance_amount_11,
  o0_.total AS total_12,
  o0_.discount AS discount_13,
  o0_.paid_amount AS paid_amount_14,
  o0_.fee AS fee_15,
  o0_.net AS net_16,
  o0_.commission AS commission_17,
  o0_.profit AS profit_18,
  o0_.paid AS paid_19,
  o0_.paid_at AS paid_at_20,
  o0_.created_at AS created_at_21,
  o0_.published_at AS published_at_22,
  o0_.expired_at AS expired_at_23,
  o0_.canceled_at AS canceled_at_24,
  o0_.edited_at AS edited_at_25,
  o0_.deleted_at AS deleted_at_26,
  o0_.hash AS hash_27,
  o0_.user_id AS user_id_28,
  o0_.currency_id AS currency_id_29,
  o0_.payment_method_id AS payment_method_id_30
FROM
  `order` o0_
WHERE
  (o0_.hash = ?)
  AND (o0_.deleted_at IS NULL)

SELECT o0_.id AS id_0, o0_.promo_code AS promo_code_1, o0_.status AS status_2, o0_.cancel_reason AS cancel_reason_3, o0_.state AS state_4, o0_.tax_invoice AS tax_invoice_5, o0_.country AS country_6, o0_.city AS city_7, o0_.fiscal_number AS fiscal_number_8, o0_.event_hash AS event_hash_9, o0_.price AS price_10, o0_.insurance_amount AS insurance_amount_11, o0_.total AS total_12, o0_.discount AS discount_13, o0_.paid_amount AS paid_amount_14, o0_.fee AS fee_15, o0_.net AS net_16, o0_.commission AS commission_17, o0_.profit AS profit_18, o0_.paid AS paid_19, o0_.paid_at AS paid_at_20, o0_.created_at AS created_at_21, o0_.published_at AS published_at_22, o0_.expired_at AS expired_at_23, o0_.canceled_at AS canceled_at_24, o0_.edited_at AS edited_at_25, o0_.deleted_at AS deleted_at_26, o0_.hash AS hash_27, o0_.user_id AS user_id_28, o0_.currency_id AS currency_id_29, o0_.payment_method_id AS payment_method_id_30 FROM `order` o0_ WHERE (o0_.hash = 'dfdf-22-august-2024') AND (o0_.deleted_at IS NULL);

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.locales AS locales_2,
  c0_.active AS active_3,
  c0_.code AS code_4,
  c0_.deleted_at AS deleted_at_5,
  c0_.currency_id AS currency_id_6
FROM
  country c0_
WHERE
  (c0_.slug = ?)
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.slug = 'RU') AND (c0_.deleted_at IS NULL);

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.active AS active_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.name AS name_5,
  p0_.deleted_at AS deleted_at_6,
  p0_.materialized_path AS materialized_path_7,
  p0_.template_id AS template_id_8
FROM
  page p0_
WHERE
  (
    p0_.code = ?
    AND p0_.active = ?
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.active AS active_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.name AS name_5, p0_.deleted_at AS deleted_at_6, p0_.materialized_path AS materialized_path_7, p0_.template_id AS template_id_8 FROM page p0_ WHERE (p0_.code = 'event' AND p0_.active = 1) AND (p0_.deleted_at IS NULL);

SELECT
  p0_.id AS id_0,
  p0_.deleted_at AS deleted_at_1,
  p1_.id AS id_2,
  p1_.content AS content_3,
  p1_.locale AS locale_4,
  p0_.page_id AS page_id_5,
  p0_.country_id AS country_id_6,
  p1_.translatable_id AS translatable_id_7
FROM
  page_data p0_
  LEFT JOIN page_data_translation p1_ ON p0_.id = p1_.translatable_id
WHERE
  (
    p0_.page_id = ?
    AND p0_.country_id = ?
    AND p1_.locale = ?
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  1

SELECT p0_.id AS id_0, p0_.deleted_at AS deleted_at_1, p1_.id AS id_2, p1_.content AS content_3, p1_.locale AS locale_4, p0_.page_id AS page_id_5, p0_.country_id AS country_id_6, p1_.translatable_id AS translatable_id_7 FROM page_data p0_ LEFT JOIN page_data_translation p1_ ON p0_.id = p1_.translatable_id WHERE (p0_.page_id = 7 AND p0_.country_id = 1 AND p1_.locale = 'en') AND (p0_.deleted_at IS NULL) LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.sign AS sign_2,
  c0_.active AS active_3,
  c0_.deleted_at AS deleted_at_4
FROM
  currency c0_
WHERE
  (c0_.code = ?)
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.sign AS sign_2, c0_.active AS active_3, c0_.deleted_at AS deleted_at_4 FROM currency c0_ WHERE (c0_.code = 'EUR') AND (c0_.deleted_at IS NULL);

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.locales AS locales_2,
  c0_.active AS active_3,
  c0_.code AS code_4,
  c0_.deleted_at AS deleted_at_5,
  c0_.currency_id AS currency_id_6
FROM
  country c0_
WHERE
  (c0_.active = ?)
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.active = 1) AND (c0_.deleted_at IS NULL);

SELECT
  m0_.id AS id_0,
  m0_.deleted_at AS deleted_at_1,
  m0_.country_id AS country_id_2,
  m0_.template_id AS template_id_3,
  m0_.page_id AS page_id_4
FROM
  meta_data m0_
  LEFT JOIN meta_data_translation m1_ ON m0_.id = m1_.translatable_id
WHERE
  (
    m0_.page_id = ?
    AND m0_.country_id = ?
    AND m1_.locale = ?
  )
  AND (m0_.deleted_at IS NULL)
LIMIT
  1

SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.country_id AS country_id_2, m0_.template_id AS template_id_3, m0_.page_id AS page_id_4 FROM meta_data m0_ LEFT JOIN meta_data_translation m1_ ON m0_.id = m1_.translatable_id WHERE (m0_.page_id = 7 AND m0_.country_id = 1 AND m1_.locale = 'en') AND (m0_.deleted_at IS NULL) LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.deleted_at AS deleted_at_1,
  m0_.country_id AS country_id_2,
  m0_.template_id AS template_id_3,
  m0_.page_id AS page_id_4
FROM
  meta_data m0_
  LEFT JOIN meta_data_translation m1_ ON m0_.id = m1_.translatable_id
WHERE
  (
    m0_.template_id = ?
    AND m0_.country_id = ?
    AND m1_.locale = ?
  )
  AND (m0_.deleted_at IS NULL)
LIMIT
  1

SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.country_id AS country_id_2, m0_.template_id AS template_id_3, m0_.page_id AS page_id_4 FROM meta_data m0_ LEFT JOIN meta_data_translation m1_ ON m0_.id = m1_.translatable_id WHERE (m0_.template_id = 10 AND m0_.country_id = 1 AND m1_.locale = 'en') AND (m0_.deleted_at IS NULL) LIMIT 1;