Symfony Profiler

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
  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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.level AS level_5,
  t0.active AS active_6,
  t0.sort_order AS sort_order_7
FROM
  course_niveau t0
  INNER JOIN my_course_niveau ON t0.id = my_course_niveau.course_niveau_id
WHERE
  my_course_niveau.my_course_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.level AS level_5, t0.active AS active_6, t0.sort_order AS sort_order_7 FROM course_niveau t0 INNER JOIN my_course_niveau ON t0.id = my_course_niveau.course_niveau_id WHERE my_course_niveau.my_course_id = 48;

SELECT
  AVG(c0_.rating) AS sclr_0
FROM
  company_review c0_
WHERE
  c0_.company_id = ?
  AND c0_.status = ?

SELECT AVG(c0_.rating) AS sclr_0 FROM company_review c0_ WHERE c0_.company_id = 20 AND c0_.status = 'verified';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.active AS active_4,
  t0.sort_order AS sort_order_5,
  t0.usage_count AS usage_count_6
FROM
  course_tag t0
  INNER JOIN my_course_tags ON t0.id = my_course_tags.course_tag_id
WHERE
  my_course_tags.my_course_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.sort_order AS sort_order_5, t0.usage_count AS usage_count_6 FROM course_tag t0 INNER JOIN my_course_tags ON t0.id = my_course_tags.course_tag_id WHERE my_course_tags.my_course_id = 48;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.active AS active_4,
  t0.sort_order AS sort_order_5
FROM
  course_language t0
  INNER JOIN my_course_language ON t0.id = my_course_language.course_language_id
WHERE
  my_course_language.my_course_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.active AS active_4, t0.sort_order AS sort_order_5 FROM course_language t0 INNER JOIN my_course_language ON t0.id = my_course_language.course_language_id WHERE my_course_language.my_course_id = 48;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.street AS street_4,
  t0.zip AS zip_5,
  t0.city AS city_6,
  t0.vat_number AS vat_number_7,
  t0.email AS email_8,
  t0.telephone AS telephone_9,
  t0.longitude AS longitude_10,
  t0.latitude AS latitude_11,
  t0.is_visible AS is_visible_12,
  t0.onboarding_completed AS onboarding_completed_13,
  t0.created_via AS created_via_14,
  t0.invitation_sent_at AS invitation_sent_at_15,
  t0.stripe_customer_id AS stripe_customer_id_16,
  t0.stripe_subscription_id AS stripe_subscription_id_17,
  t0.average_rating AS average_rating_18,
  t0.review_count AS review_count_19,
  t0.additional_discount AS additional_discount_20,
  t0.vme_discount AS vme_discount_21,
  t0.country_id AS country_id_22,
  t0.created_by_sales_user_id AS created_by_sales_user_id_23,
  t0.edu_package_id AS edu_package_id_24,
  t25.id AS id_26,
  t25.slogan AS slogan_27,
  t25.short_description AS short_description_28,
  t25.long_description AS long_description_29,
  t25.website AS website_30,
  t25.facebook_link AS facebook_link_31,
  t25.instagram_link AS instagram_link_32,
  t25.linkedin_link AS linkedin_link_33,
  t25.vimeo_video_id AS vimeo_video_id_34,
  t25.vimeo_thumbnail_url AS vimeo_thumbnail_url_35,
  t25.created_at AS created_at_36,
  t25.updated_at AS updated_at_37,
  t25.company_id AS company_id_38,
  t25.logo_image_id AS logo_image_id_39,
  t25.main_image_id AS main_image_id_40
FROM
  company t0
  LEFT JOIN company_detail t25 ON t25.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.street AS street_4, t0.zip AS zip_5, t0.city AS city_6, t0.vat_number AS vat_number_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.is_visible AS is_visible_12, t0.onboarding_completed AS onboarding_completed_13, t0.created_via AS created_via_14, t0.invitation_sent_at AS invitation_sent_at_15, t0.stripe_customer_id AS stripe_customer_id_16, t0.stripe_subscription_id AS stripe_subscription_id_17, t0.average_rating AS average_rating_18, t0.review_count AS review_count_19, t0.additional_discount AS additional_discount_20, t0.vme_discount AS vme_discount_21, t0.country_id AS country_id_22, t0.created_by_sales_user_id AS created_by_sales_user_id_23, t0.edu_package_id AS edu_package_id_24, t25.id AS id_26, t25.slogan AS slogan_27, t25.short_description AS short_description_28, t25.long_description AS long_description_29, t25.website AS website_30, t25.facebook_link AS facebook_link_31, t25.instagram_link AS instagram_link_32, t25.linkedin_link AS linkedin_link_33, t25.vimeo_video_id AS vimeo_video_id_34, t25.vimeo_thumbnail_url AS vimeo_thumbnail_url_35, t25.created_at AS created_at_36, t25.updated_at AS updated_at_37, t25.company_id AS company_id_38, t25.logo_image_id AS logo_image_id_39, t25.main_image_id AS main_image_id_40 FROM company t0 LEFT JOIN company_detail t25 ON t25.company_id = t0.id WHERE t0.id = 20;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.external_link AS external_link_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.user_id AS user_id_8,
  t0.company_id AS company_id_9,
  t0.course_main_image_library_id AS course_main_image_library_id_10,
  t0.main_category_id AS main_category_id_11,
  t0.sub_category_id AS sub_category_id_12,
  t0.topic_id AS topic_id_13
FROM
  my_course t0
WHERE
  t0.main_category_id = ?
ORDER BY
  t0.created_at DESC
LIMIT
  8

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.external_link AS external_link_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8, t0.company_id AS company_id_9, t0.course_main_image_library_id AS course_main_image_library_id_10, t0.main_category_id AS main_category_id_11, t0.sub_category_id AS sub_category_id_12, t0.topic_id AS topic_id_13 FROM my_course t0 WHERE t0.main_category_id = 25 ORDER BY t0.created_at DESC LIMIT 8;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.email_verification_token AS email_verification_token_6,
  t0.email_verification_token_expires_at AS email_verification_token_expires_at_7,
  t0.totp_secret AS totp_secret_8,
  t0.totp_verified AS totp_verified_9,
  t0.first_name AS first_name_10,
  t0.last_name AS last_name_11,
  t0.created_at AS created_at_12,
  t0.terms_and_conditions_at AS terms_and_conditions_at_13,
  t0.reminder_unsubscribed AS reminder_unsubscribed_14,
  t0.deleted AS deleted_15,
  t0.deleted_at AS deleted_at_16,
  t0.company_id AS company_id_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.email_verification_token AS email_verification_token_6, t0.email_verification_token_expires_at AS email_verification_token_expires_at_7, t0.totp_secret AS totp_secret_8, t0.totp_verified AS totp_verified_9, t0.first_name AS first_name_10, t0.last_name AS last_name_11, t0.created_at AS created_at_12, t0.terms_and_conditions_at AS terms_and_conditions_at_13, t0.reminder_unsubscribed AS reminder_unsubscribed_14, t0.deleted AS deleted_15, t0.deleted_at AS deleted_at_16, t0.company_id AS company_id_17 FROM user t0 WHERE t0.id = 0x019F4B3EAB97795EA8AF5F52AD5A9DF0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.price AS price_5,
  t0.billing_cycle AS billing_cycle_6,
  t0.coins_per_month AS coins_per_month_7,
  t0.max_course_images AS max_course_images_8,
  t0.max_course_search_terms AS max_course_search_terms_9,
  t0.allow_course_external_link AS allow_course_external_link_10,
  t0.allow_social_media_links AS allow_social_media_links_11,
  t0.allow_company_video AS allow_company_video_12,
  t0.tier AS tier_13,
  t0.stripe_price_id AS stripe_price_id_14
FROM
  edu_package t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4, t0.price AS price_5, t0.billing_cycle AS billing_cycle_6, t0.coins_per_month AS coins_per_month_7, t0.max_course_images AS max_course_images_8, t0.max_course_search_terms AS max_course_search_terms_9, t0.allow_course_external_link AS allow_course_external_link_10, t0.allow_social_media_links AS allow_social_media_links_11, t0.allow_company_video AS allow_company_video_12, t0.tier AS tier_13, t0.stripe_price_id AS stripe_price_id_14 FROM edu_package t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.external_link AS external_link_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.user_id AS user_id_8,
  t0.company_id AS company_id_9,
  t0.course_main_image_library_id AS course_main_image_library_id_10,
  t0.main_category_id AS main_category_id_11,
  t0.sub_category_id AS sub_category_id_12,
  t0.topic_id AS topic_id_13
FROM
  my_course t0
ORDER BY
  t0.created_at DESC
LIMIT
  8

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.external_link AS external_link_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8, t0.company_id AS company_id_9, t0.course_main_image_library_id AS course_main_image_library_id_10, t0.main_category_id AS main_category_id_11, t0.sub_category_id AS sub_category_id_12, t0.topic_id AS topic_id_13 FROM my_course t0 ORDER BY t0.created_at DESC LIMIT 8;

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 = ?
  AND (
    (
      p0_.active_from IS NULL
      OR p0_.active_from <= ?
    )
  )
  AND (
    (
      p0_.active_to IS NULL
      OR p0_.active_to >= ?
    )
  )
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 AND ((p0_.active_from IS NULL OR p0_.active_from <= '2026-07-11 13:53:24')) AND ((p0_.active_to IS NULL OR p0_.active_to >= '2026-07-11 13:53:24')) ORDER BY p0_.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.external_link AS external_link_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.user_id AS user_id_8,
  t0.company_id AS company_id_9,
  t0.course_main_image_library_id AS course_main_image_library_id_10,
  t0.main_category_id AS main_category_id_11,
  t0.sub_category_id AS sub_category_id_12,
  t0.topic_id AS topic_id_13
FROM
  my_course t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.external_link AS external_link_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8, t0.company_id AS company_id_9, t0.course_main_image_library_id AS course_main_image_library_id_10, t0.main_category_id AS main_category_id_11, t0.sub_category_id AS sub_category_id_12, t0.topic_id AS topic_id_13 FROM my_course t0 WHERE t0.id IN (4);

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.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
WHERE
  t0.id IN (?, ?)

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 WHERE t0.id IN (5, 4);