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_.quantity AS quantity_6,
  f0_.card_type AS card_type_7,
  f0_.greeting_title AS greeting_title_8,
  f0_.greeting_message AS greeting_message_9,
  f0_.first_name AS first_name_10,
  f0_.last_name AS last_name_11,
  f0_.email AS email_12,
  f0_.phone AS phone_13,
  f0_.company_name AS company_name_14,
  f0_.vat_number AS vat_number_15,
  f0_.shipping_same_as_billing AS shipping_same_as_billing_16,
  f0_.stripe_session_id AS stripe_session_id_17,
  f0_.stripe_payment_intent_id AS stripe_payment_intent_id_18,
  f0_.stripe_paid_at AS stripe_paid_at_19,
  f0_.stripe_payment_method AS stripe_payment_method_20,
  f0_.stripe_refunded_at AS stripe_refunded_at_21,
  f0_.stripe_refund_id AS stripe_refund_id_22,
  f0_.stripe_refund_amount AS stripe_refund_amount_23,
  f0_.accepted_terms AS accepted_terms_24,
  f0_.accepted_privacy AS accepted_privacy_25,
  f0_.resume_token AS resume_token_26,
  f0_.resume_token_sent_at AS resume_token_sent_at_27,
  f0_.created_at AS created_at_28,
  f0_.updated_at AS updated_at_29,
  f0_.completed_at AS completed_at_30,
  f0_.locked_at AS locked_at_31,
  f0_.product_digital_id AS product_digital_id_32,
  f0_.product_analog_id AS product_analog_id_33,
  f0_.product_template_id AS product_template_id_34,
  f0_.billing_address_id AS billing_address_id_35,
  f0_.shipping_address_id AS shipping_address_id_36,
  f0_.shipping_option_id AS shipping_option_id_37
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_.quantity AS quantity_6, f0_.card_type AS card_type_7, f0_.greeting_title AS greeting_title_8, f0_.greeting_message AS greeting_message_9, f0_.first_name AS first_name_10, f0_.last_name AS last_name_11, f0_.email AS email_12, f0_.phone AS phone_13, f0_.company_name AS company_name_14, f0_.vat_number AS vat_number_15, f0_.shipping_same_as_billing AS shipping_same_as_billing_16, f0_.stripe_session_id AS stripe_session_id_17, f0_.stripe_payment_intent_id AS stripe_payment_intent_id_18, f0_.stripe_paid_at AS stripe_paid_at_19, f0_.stripe_payment_method AS stripe_payment_method_20, f0_.stripe_refunded_at AS stripe_refunded_at_21, f0_.stripe_refund_id AS stripe_refund_id_22, f0_.stripe_refund_amount AS stripe_refund_amount_23, f0_.accepted_terms AS accepted_terms_24, f0_.accepted_privacy AS accepted_privacy_25, f0_.resume_token AS resume_token_26, f0_.resume_token_sent_at AS resume_token_sent_at_27, f0_.created_at AS created_at_28, f0_.updated_at AS updated_at_29, f0_.completed_at AS completed_at_30, f0_.locked_at AS locked_at_31, f0_.product_digital_id AS product_digital_id_32, f0_.product_analog_id AS product_analog_id_33, f0_.product_template_id AS product_template_id_34, f0_.billing_address_id AS billing_address_id_35, f0_.shipping_address_id AS shipping_address_id_36, f0_.shipping_option_id AS shipping_option_id_37 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
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.product_price AS product_price_4,
  t0.template_image_id AS template_image_id_5,
  t0.product_image_id AS product_image_id_6,
  t0.background_image_id AS background_image_id_7,
  t0.eye_catcher_image_id AS eye_catcher_image_id_8,
  t0.print_preview_image_id AS print_preview_image_id_9,
  t0.hero_section AS hero_section_10,
  t0.is_active AS is_active_11,
  t0.active_from AS active_from_12,
  t0.active_to AS active_to_13,
  t0.sort_order AS sort_order_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.created_by_user_id AS created_by_user_id_17,
  t0.updated_by_user_id AS updated_by_user_id_18
FROM
  product_digital t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.product_price AS product_price_4, t0.template_image_id AS template_image_id_5, t0.product_image_id AS product_image_id_6, t0.background_image_id AS background_image_id_7, t0.eye_catcher_image_id AS eye_catcher_image_id_8, t0.print_preview_image_id AS print_preview_image_id_9, t0.hero_section AS hero_section_10, t0.is_active AS is_active_11, t0.active_from AS active_from_12, t0.active_to AS active_to_13, t0.sort_order AS sort_order_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.created_by_user_id AS created_by_user_id_17, t0.updated_by_user_id AS updated_by_user_id_18 FROM product_digital t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  product_digital_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM product_digital_translation t0 WHERE t0.object_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  country t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM country t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  country t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM country t0;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.zip AS zip_3,
  t0.city AS city_4,
  t0.salutation AS salutation_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.company_name AS company_name_8,
  t0.vat_number AS vat_number_9,
  t0.country_id AS country_id_10
FROM
  frontend_address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.zip AS zip_3, t0.city AS city_4, t0.salutation AS salutation_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.company_name AS company_name_8, t0.vat_number AS vat_number_9, t0.country_id AS country_id_10 FROM frontend_address t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.image_file_name AS image_file_name_2,
  t0.image_updated_at AS image_updated_at_3,
  t0.caption AS caption_4,
  t0.alt_text AS alt_text_5,
  t0.sort_order AS sort_order_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.company_id AS company_id_9,
  t0.uploaded_by_user_id AS uploaded_by_user_id_10
FROM
  image t0

SELECT t0.id AS id_1, t0.image_file_name AS image_file_name_2, t0.image_updated_at AS image_updated_at_3, t0.caption AS caption_4, t0.alt_text AS alt_text_5, t0.sort_order AS sort_order_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.company_id AS company_id_9, t0.uploaded_by_user_id AS uploaded_by_user_id_10 FROM image t0;

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 = '4' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\Image';

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\\Image';

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.product_price AS product_price_3,
  p0_.template_image_id AS template_image_id_4,
  p0_.product_image_id AS product_image_id_5,
  p0_.background_image_id AS background_image_id_6,
  p0_.eye_catcher_image_id AS eye_catcher_image_id_7,
  p0_.print_preview_image_id AS print_preview_image_id_8,
  p0_.hero_section AS hero_section_9,
  p0_.is_active AS is_active_10,
  p0_.active_from AS active_from_11,
  p0_.active_to AS active_to_12,
  p0_.sort_order AS sort_order_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.created_by_user_id AS created_by_user_id_16,
  p0_.updated_by_user_id AS updated_by_user_id_17
FROM
  product_digital p0_
WHERE
  p0_.is_active = ?
ORDER BY
  p0_.sort_order ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.product_price AS product_price_3, p0_.template_image_id AS template_image_id_4, p0_.product_image_id AS product_image_id_5, p0_.background_image_id AS background_image_id_6, p0_.eye_catcher_image_id AS eye_catcher_image_id_7, p0_.print_preview_image_id AS print_preview_image_id_8, p0_.hero_section AS hero_section_9, p0_.is_active AS is_active_10, p0_.active_from AS active_from_11, p0_.active_to AS active_to_12, p0_.sort_order AS sort_order_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.created_by_user_id AS created_by_user_id_16, p0_.updated_by_user_id AS updated_by_user_id_17 FROM product_digital p0_ WHERE p0_.is_active = 1 ORDER BY p0_.sort_order ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.product_price AS product_price_3,
  p0_.product_image_id AS product_image_id_4,
  p0_.image_frontal_id AS image_frontal_id_5,
  p0_.is_giftbox AS is_giftbox_6,
  p0_.is_active AS is_active_7,
  p0_.active_from AS active_from_8,
  p0_.active_to AS active_to_9,
  p0_.sort_order AS sort_order_10,
  p0_.created_at AS created_at_11,
  p0_.updated_at AS updated_at_12,
  p0_.created_by_user_id AS created_by_user_id_13,
  p0_.updated_by_user_id AS updated_by_user_id_14
FROM
  product_analog p0_
WHERE
  p0_.is_active = ?
ORDER BY
  p0_.is_giftbox ASC,
  p0_.sort_order ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.product_price AS product_price_3, p0_.product_image_id AS product_image_id_4, p0_.image_frontal_id AS image_frontal_id_5, p0_.is_giftbox AS is_giftbox_6, p0_.is_active AS is_active_7, p0_.active_from AS active_from_8, p0_.active_to AS active_to_9, p0_.sort_order AS sort_order_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_user_id AS created_by_user_id_13, p0_.updated_by_user_id AS updated_by_user_id_14 FROM product_analog p0_ WHERE p0_.is_active = 1 ORDER BY p0_.is_giftbox ASC, p0_.sort_order ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.template_image_id AS template_image_id_2,
  p0_.is_active AS is_active_3,
  p0_.active_from AS active_from_4,
  p0_.active_to AS active_to_5,
  p0_.sort_order AS sort_order_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p0_.created_by_user_id AS created_by_user_id_9,
  p0_.updated_by_user_id AS updated_by_user_id_10
FROM
  product_template p0_
WHERE
  p0_.is_active = ?
ORDER BY
  p0_.sort_order ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.template_image_id AS template_image_id_2, p0_.is_active AS is_active_3, p0_.active_from AS active_from_4, p0_.active_to AS active_to_5, p0_.sort_order AS sort_order_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.created_by_user_id AS created_by_user_id_9, p0_.updated_by_user_id AS updated_by_user_id_10 FROM product_template p0_ WHERE p0_.is_active = 1 ORDER BY p0_.sort_order ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.price AS price_2,
  s0_.active AS active_3,
  s0_.estimated_days AS estimated_days_4,
  s0_.description AS description_5,
  s0_.icon_image_id_id AS icon_image_id_id_6,
  s0_.country_id AS country_id_7
FROM
  shipping_option s0_
WHERE
  s0_.active = ?
ORDER BY
  s0_.price ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.price AS price_2, s0_.active AS active_3, s0_.estimated_days AS estimated_days_4, s0_.description AS description_5, s0_.icon_image_id_id AS icon_image_id_id_6, s0_.country_id AS country_id_7 FROM shipping_option s0_ WHERE s0_.active = 1 ORDER BY s0_.price 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,
  c0_.image_id AS image_id_20,
  c1_.main_category_id AS main_category_id_21,
  c2_.sub_category_id AS sub_category_id_22
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, c0_.image_id AS image_id_20, c1_.main_category_id AS main_category_id_21, c2_.sub_category_id AS sub_category_id_22 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 = '25' 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 = '131' 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 = '296' 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 = '297' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\CourseTopic';