Symfony Profiler

SELECT
  f0_.id AS id_0,
  f0_.session_id AS session_id_1,
  f0_.status AS status_2,
  f0_.customer_type AS customer_type_3,
  f0_.amount AS amount_4,
  f0_.bonus_amount AS bonus_amount_5,
  f0_.card_type AS card_type_6,
  f0_.greeting_title AS greeting_title_7,
  f0_.greeting_message AS greeting_message_8,
  f0_.first_name AS first_name_9,
  f0_.last_name AS last_name_10,
  f0_.email AS email_11,
  f0_.phone AS phone_12,
  f0_.company_name AS company_name_13,
  f0_.vat_number AS vat_number_14,
  f0_.shipping_same_as_billing AS shipping_same_as_billing_15,
  f0_.stripe_session_id AS stripe_session_id_16,
  f0_.stripe_payment_intent_id AS stripe_payment_intent_id_17,
  f0_.accepted_terms AS accepted_terms_18,
  f0_.accepted_privacy AS accepted_privacy_19,
  f0_.resume_token AS resume_token_20,
  f0_.resume_token_sent_at AS resume_token_sent_at_21,
  f0_.created_at AS created_at_22,
  f0_.updated_at AS updated_at_23,
  f0_.completed_at AS completed_at_24,
  f0_.product_digital_id AS product_digital_id_25,
  f0_.product_analog_id AS product_analog_id_26,
  f0_.product_template_id AS product_template_id_27,
  f0_.billing_address_id AS billing_address_id_28,
  f0_.shipping_address_id AS shipping_address_id_29,
  f0_.shipping_option_id AS shipping_option_id_30,
  f0_.gift_card_id AS gift_card_id_31
FROM
  frontend_card_order f0_
WHERE
  f0_.session_id = ?
  AND f0_.status NOT IN (?, ?)
ORDER BY
  f0_.created_at DESC
LIMIT
  1

SELECT f0_.id AS id_0, f0_.session_id AS session_id_1, f0_.status AS status_2, f0_.customer_type AS customer_type_3, f0_.amount AS amount_4, f0_.bonus_amount AS bonus_amount_5, f0_.card_type AS card_type_6, f0_.greeting_title AS greeting_title_7, f0_.greeting_message AS greeting_message_8, f0_.first_name AS first_name_9, f0_.last_name AS last_name_10, f0_.email AS email_11, f0_.phone AS phone_12, f0_.company_name AS company_name_13, f0_.vat_number AS vat_number_14, f0_.shipping_same_as_billing AS shipping_same_as_billing_15, f0_.stripe_session_id AS stripe_session_id_16, f0_.stripe_payment_intent_id AS stripe_payment_intent_id_17, f0_.accepted_terms AS accepted_terms_18, f0_.accepted_privacy AS accepted_privacy_19, f0_.resume_token AS resume_token_20, f0_.resume_token_sent_at AS resume_token_sent_at_21, f0_.created_at AS created_at_22, f0_.updated_at AS updated_at_23, f0_.completed_at AS completed_at_24, f0_.product_digital_id AS product_digital_id_25, f0_.product_analog_id AS product_analog_id_26, f0_.product_template_id AS product_template_id_27, f0_.billing_address_id AS billing_address_id_28, f0_.shipping_address_id AS shipping_address_id_29, f0_.shipping_option_id AS shipping_option_id_30, f0_.gift_card_id AS gift_card_id_31 FROM frontend_card_order f0_ WHERE f0_.session_id = '0aa774e4027b5fbd0f8aa983d5626260' AND f0_.status NOT IN ('completed', 'abandoned') ORDER BY f0_.created_at DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO frontend_card_order (
  session_id, status, customer_type,
  amount, bonus_amount, card_type,
  greeting_title, greeting_message,
  first_name, last_name, email, phone,
  company_name, vat_number, shipping_same_as_billing,
  stripe_session_id, stripe_payment_intent_id,
  accepted_terms, accepted_privacy,
  resume_token, resume_token_sent_at,
  created_at, updated_at, completed_at,
  product_digital_id, product_analog_id,
  product_template_id, billing_address_id,
  shipping_address_id, shipping_option_id,
  gift_card_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO frontend_card_order (session_id, status, customer_type, amount, bonus_amount, card_type, greeting_title, greeting_message, first_name, last_name, email, phone, company_name, vat_number, shipping_same_as_billing, stripe_session_id, stripe_payment_intent_id, accepted_terms, accepted_privacy, resume_token, resume_token_sent_at, created_at, updated_at, completed_at, product_digital_id, product_analog_id, product_template_id, billing_address_id, shipping_address_id, shipping_option_id, gift_card_id) VALUES ('0aa774e4027b5fbd0f8aa983d5626260', 'step_1_customer_type', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, 0, NULL, NULL, '2026-03-13 16:13:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.icon AS icon_4,
  c0_.active AS active_5,
  c0_.sort_order AS sort_order_6,
  c1_.id AS id_7,
  c1_.name AS name_8,
  c1_.slug AS slug_9,
  c1_.description AS description_10,
  c1_.active AS active_11,
  c1_.sort_order AS sort_order_12,
  c2_.id AS id_13,
  c2_.name AS name_14,
  c2_.slug AS slug_15,
  c2_.description AS description_16,
  c2_.icon AS icon_17,
  c2_.active AS active_18,
  c2_.sort_order AS sort_order_19,
  c1_.main_category_id AS main_category_id_20,
  c2_.sub_category_id AS sub_category_id_21
FROM
  course_main_category c0_
  LEFT JOIN course_sub_category c1_ ON c0_.id = c1_.main_category_id
  AND (c1_.active = ?)
  LEFT JOIN course_topic c2_ ON c1_.id = c2_.sub_category_id
  AND (c2_.active = ?)
WHERE
  c0_.active = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC,
  c1_.sort_order ASC,
  c1_.name ASC,
  c2_.sort_order ASC,
  c2_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.icon AS icon_4, c0_.active AS active_5, c0_.sort_order AS sort_order_6, c1_.id AS id_7, c1_.name AS name_8, c1_.slug AS slug_9, c1_.description AS description_10, c1_.active AS active_11, c1_.sort_order AS sort_order_12, c2_.id AS id_13, c2_.name AS name_14, c2_.slug AS slug_15, c2_.description AS description_16, c2_.icon AS icon_17, c2_.active AS active_18, c2_.sort_order AS sort_order_19, c1_.main_category_id AS main_category_id_20, c2_.sub_category_id AS sub_category_id_21 FROM course_main_category c0_ LEFT JOIN course_sub_category c1_ ON c0_.id = c1_.main_category_id AND (c1_.active = 1) LEFT JOIN course_topic c2_ ON c1_.id = c2_.sub_category_id AND (c2_.active = 1) WHERE c0_.active = 1 ORDER BY c0_.sort_order ASC, c0_.name ASC, c1_.sort_order ASC, c1_.name ASC, c2_.sort_order ASC, c2_.name ASC;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '8' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseMainCategory';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '13' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseSubCategory';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '10' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseSubCategory';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '38' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseTopic';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '40' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseTopic';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '41' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseTopic';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '39' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseTopic';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '42' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseTopic';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '44' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseTopic';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '43' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseTopic';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '6' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseSubCategory';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '7' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseTopic';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '5' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseTopic';