Symfony Profiler

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 = 0x019E44CBE98D70A7A022E12C2CF9F7ED;

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.stripe_customer_id AS stripe_customer_id_14,
  t0.stripe_subscription_id AS stripe_subscription_id_15,
  t0.average_rating AS average_rating_16,
  t0.review_count AS review_count_17,
  t0.additional_discount AS additional_discount_18,
  t0.country_id AS country_id_19,
  t0.edu_package_id AS edu_package_id_20,
  t21.id AS id_22,
  t21.slogan AS slogan_23,
  t21.short_description AS short_description_24,
  t21.long_description AS long_description_25,
  t21.website AS website_26,
  t21.facebook_link AS facebook_link_27,
  t21.instagram_link AS instagram_link_28,
  t21.linkedin_link AS linkedin_link_29,
  t21.vimeo_video_id AS vimeo_video_id_30,
  t21.vimeo_thumbnail_url AS vimeo_thumbnail_url_31,
  t21.created_at AS created_at_32,
  t21.updated_at AS updated_at_33,
  t21.company_id AS company_id_34,
  t21.logo_image_id AS logo_image_id_35,
  t21.main_image_id AS main_image_id_36
FROM
  company t0
  LEFT JOIN company_detail t21 ON t21.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.stripe_customer_id AS stripe_customer_id_14, t0.stripe_subscription_id AS stripe_subscription_id_15, t0.average_rating AS average_rating_16, t0.review_count AS review_count_17, t0.additional_discount AS additional_discount_18, t0.country_id AS country_id_19, t0.edu_package_id AS edu_package_id_20, t21.id AS id_22, t21.slogan AS slogan_23, t21.short_description AS short_description_24, t21.long_description AS long_description_25, t21.website AS website_26, t21.facebook_link AS facebook_link_27, t21.instagram_link AS instagram_link_28, t21.linkedin_link AS linkedin_link_29, t21.vimeo_video_id AS vimeo_video_id_30, t21.vimeo_thumbnail_url AS vimeo_thumbnail_url_31, t21.created_at AS created_at_32, t21.updated_at AS updated_at_33, t21.company_id AS company_id_34, t21.logo_image_id AS logo_image_id_35, t21.main_image_id AS main_image_id_36 FROM company t0 LEFT JOIN company_detail t21 ON t21.company_id = t0.id WHERE t0.id = 28;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  my_course m0_
WHERE
  m0_.company_id = ?

SELECT COUNT(m0_.id) AS sclr_0 FROM my_course m0_ WHERE m0_.company_id = 28;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CREATE_COMPANY' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
  INNER JOIN user_user_actions ON t0.id = user_user_actions.user_actions_id
WHERE
  user_user_actions.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 INNER JOIN user_user_actions ON t0.id = user_user_actions.user_actions_id WHERE user_user_actions.user_id = 0x019E44CBE98D70A7A022E12C2CF9F7ED;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CHOOSE_PACKAGE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CREATE_FIRST_COURSE' LIMIT 1;

SELECT
  COALESCE(
    SUM(c0_.coin_amount),
    0
  ) AS sclr_0
FROM
  coin_transaction c0_
WHERE
  c0_.company_id = ?

SELECT COALESCE(SUM(c0_.coin_amount), 0) AS sclr_0 FROM coin_transaction c0_ WHERE c0_.company_id = 28;

SELECT
  e0_.id AS id_0,
  e0_.datetime AS datetime_1,
  e0_.action AS action_2,
  e0_.details AS details_3,
  e0_.company_id AS company_id_4,
  e0_.edu_package_id AS edu_package_id_5
FROM
  edu_package_log e0_
WHERE
  e0_.company_id = ?
  AND e0_.action IN (?, ?)
ORDER BY
  e0_.datetime DESC
LIMIT
  1

SELECT e0_.id AS id_0, e0_.datetime AS datetime_1, e0_.action AS action_2, e0_.details AS details_3, e0_.company_id AS company_id_4, e0_.edu_package_id AS edu_package_id_5 FROM edu_package_log e0_ WHERE e0_.company_id = 28 AND e0_.action IN ('ORDERED', 'UPGRADED') ORDER BY e0_.datetime DESC LIMIT 1;

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_social_media_links AS allow_social_media_links_10,
  t0.tier AS tier_11,
  t0.stripe_price_id AS stripe_price_id_12
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_social_media_links AS allow_social_media_links_10, t0.tier AS tier_11, t0.stripe_price_id AS stripe_price_id_12 FROM edu_package t0 WHERE t0.id = 2;

SELECT
  e0_.id AS id_0,
  e0_.datetime AS datetime_1,
  e0_.action AS action_2,
  e0_.details AS details_3,
  e0_.company_id AS company_id_4,
  e0_.edu_package_id AS edu_package_id_5
FROM
  edu_package_log e0_
WHERE
  e0_.company_id = ?
  AND e0_.action = ?
  AND e0_.datetime >= ?
ORDER BY
  e0_.datetime DESC
LIMIT
  1

SELECT e0_.id AS id_0, e0_.datetime AS datetime_1, e0_.action AS action_2, e0_.details AS details_3, e0_.company_id AS company_id_4, e0_.edu_package_id AS edu_package_id_5 FROM edu_package_log e0_ WHERE e0_.company_id = 28 AND e0_.action = 'CANCELED' AND e0_.datetime >= '2026-05-20 10:15:09' ORDER BY e0_.datetime DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.is_default AS is_default_5
FROM
  language t0
WHERE
  t0.active = ?
ORDER BY
  t0.code ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.active AS active_4, t0.is_default AS is_default_5 FROM language t0 WHERE t0.active = 1 ORDER BY t0.code ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CREATE_COMPANY' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CHOOSE_PACKAGE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CREATE_FIRST_COURSE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CREATE_COMPANY' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CHOOSE_PACKAGE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CREATE_FIRST_COURSE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CREATE_COMPANY' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.sorting AS sorting_4,
  t0.reminder_delay_days AS reminder_delay_days_5,
  t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6,
  t0.reminder_max_sends AS reminder_max_sends_7,
  t0.mail_template_id AS mail_template_id_8
FROM
  user_actions t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.sorting AS sorting_4, t0.reminder_delay_days AS reminder_delay_days_5, t0.reminder_repeat_interval_days AS reminder_repeat_interval_days_6, t0.reminder_max_sends AS reminder_max_sends_7, t0.mail_template_id AS mail_template_id_8 FROM user_actions t0 WHERE t0.name = 'CHOOSE_PACKAGE' LIMIT 1;