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 = '' AND f0_.status NOT IN ('completed', 'abandoned') ORDER BY f0_.created_at DESC LIMIT 1;

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 = '23' 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 = '110' 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 = '187' 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 = '188' 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 = '189' 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 = '190' 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 = '191' 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 = '192' 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 = '111' 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 = '193' 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 = '194' 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 = '195' 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 = '196' 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 = '197' 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 = ?