Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.token_hash AS token_hash_1,
  u0_.created_at AS created_at_2,
  u0_.expires_at AS expires_at_3,
  u0_.last_used_at AS last_used_at_4,
  u0_.revoked_at AS revoked_at_5,
  u0_.user_agent_hash AS user_agent_hash_6,
  u0_.ip_hash AS ip_hash_7,
  u0_.user_id AS user_id_8
FROM
  user_auth_token u0_
WHERE
  u0_.token_hash = ?
  AND u0_.revoked_at IS NULL
  AND u0_.expires_at > ?

SELECT u0_.id AS id_0, u0_.token_hash AS token_hash_1, u0_.created_at AS created_at_2, u0_.expires_at AS expires_at_3, u0_.last_used_at AS last_used_at_4, u0_.revoked_at AS revoked_at_5, u0_.user_agent_hash AS user_agent_hash_6, u0_.ip_hash AS ip_hash_7, u0_.user_id AS user_id_8 FROM user_auth_token u0_ WHERE u0_.token_hash = '828d4ca222a1e4cf5abd3d4911a39836b495af4d2febb7ad0889d67f64a45264' AND u0_.revoked_at IS NULL AND u0_.expires_at > 1785396175;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.country AS country_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone_number AS phone_number_7,
  t0.biography AS biography_8,
  t0.profile_picture AS profile_picture_9,
  t0.cv AS cv_10,
  t0.linkedin AS linkedin_11,
  t0.password AS password_12,
  t0.api_token AS api_token_13,
  t0.ethereum_address AS ethereum_address_14,
  t0.ethereum_private_key AS ethereum_private_key_15,
  t0.is_email_verified AS is_email_verified_16,
  t0.resend_verification_email_count AS resend_verification_email_count_17,
  t0.last_resend_verification_email_at AS last_resend_verification_email_at_18,
  t0.reset_password_request_count AS reset_password_request_count_19,
  t0.last_reset_password_request_at AS last_reset_password_request_at_20,
  t0.is_first_configuration_done AS is_first_configuration_done_21,
  t0.recieve_weekly_recommandation_emails AS recieve_weekly_recommandation_emails_22,
  t0.main_career_goal AS main_career_goal_23,
  t0.language AS language_24,
  t0.premium_subscription_date AS premium_subscription_date_25,
  t0.billing_plan AS billing_plan_26,
  t0.premium_subscription_period_started_at AS premium_subscription_period_started_at_27,
  t0.premium_subscription_period_ends_at AS premium_subscription_period_ends_at_28,
  t0.paypal_subscription_id AS paypal_subscription_id_29,
  t0.paypal_subscription_status AS paypal_subscription_status_30,
  t0.stripe_customer_id AS stripe_customer_id_31,
  t0.stripe_subscription_id AS stripe_subscription_id_32,
  t0.stripe_subscription_status AS stripe_subscription_status_33,
  t0.show_email_on_profile AS show_email_on_profile_34,
  t0.show_phone_on_profile AS show_phone_on_profile_35,
  t0.career_advice_outdated AS career_advice_outdated_36,
  t0.is_external_candidate_placeholder AS is_external_candidate_placeholder_37,
  t0.external_candidate_activated_at AS external_candidate_activated_at_38,
  t0.account_provisioning_source AS account_provisioning_source_39,
  t40.id AS id_41,
  t40.career_summary AS career_summary_42,
  t40.key_recommendations AS key_recommendations_43,
  t40.skill_development AS skill_development_44,
  t40.next_steps AS next_steps_45,
  t40.recommended_resources AS recommended_resources_46,
  t40.created_at AS created_at_47,
  t40.user_id AS user_id_48
FROM
  `user` t0
  LEFT JOIN career_advice t40 ON t40.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.country AS country_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone_number AS phone_number_7, t0.biography AS biography_8, t0.profile_picture AS profile_picture_9, t0.cv AS cv_10, t0.linkedin AS linkedin_11, t0.password AS password_12, t0.api_token AS api_token_13, t0.ethereum_address AS ethereum_address_14, t0.ethereum_private_key AS ethereum_private_key_15, t0.is_email_verified AS is_email_verified_16, t0.resend_verification_email_count AS resend_verification_email_count_17, t0.last_resend_verification_email_at AS last_resend_verification_email_at_18, t0.reset_password_request_count AS reset_password_request_count_19, t0.last_reset_password_request_at AS last_reset_password_request_at_20, t0.is_first_configuration_done AS is_first_configuration_done_21, t0.recieve_weekly_recommandation_emails AS recieve_weekly_recommandation_emails_22, t0.main_career_goal AS main_career_goal_23, t0.language AS language_24, t0.premium_subscription_date AS premium_subscription_date_25, t0.billing_plan AS billing_plan_26, t0.premium_subscription_period_started_at AS premium_subscription_period_started_at_27, t0.premium_subscription_period_ends_at AS premium_subscription_period_ends_at_28, t0.paypal_subscription_id AS paypal_subscription_id_29, t0.paypal_subscription_status AS paypal_subscription_status_30, t0.stripe_customer_id AS stripe_customer_id_31, t0.stripe_subscription_id AS stripe_subscription_id_32, t0.stripe_subscription_status AS stripe_subscription_status_33, t0.show_email_on_profile AS show_email_on_profile_34, t0.show_phone_on_profile AS show_phone_on_profile_35, t0.career_advice_outdated AS career_advice_outdated_36, t0.is_external_candidate_placeholder AS is_external_candidate_placeholder_37, t0.external_candidate_activated_at AS external_candidate_activated_at_38, t0.account_provisioning_source AS account_provisioning_source_39, t40.id AS id_41, t40.career_summary AS career_summary_42, t40.key_recommendations AS key_recommendations_43, t40.skill_development AS skill_development_44, t40.next_steps AS next_steps_45, t40.recommended_resources AS recommended_resources_46, t40.created_at AS created_at_47, t40.user_id AS user_id_48 FROM `user` t0 LEFT JOIN career_advice t40 ON t40.user_id = t0.id WHERE t0.id = 1;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  course c0_
  LEFT JOIN weekly_recommandation w1_ ON c0_.weekly_recommandation_id = w1_.id
  LEFT JOIN `user` u2_ ON w1_.user_id = u2_.id
  LEFT JOIN company_employee_future_skill c3_ ON c0_.future_skill_id = c3_.id
  LEFT JOIN company_employee c4_ ON c3_.company_employee_id = c4_.id
  LEFT JOIN `user` u5_ ON c4_.user_id = u5_.id
  LEFT JOIN user_purchased_course u6_ ON (u6_.course_id = c0_.id)
  LEFT JOIN `user` u7_ ON u6_.user_id = u7_.id
WHERE
  (
    (
      (
        c0_.is_progressive = 0
        AND c0_.course IS NOT NULL
      )
      OR (
        c0_.is_progressive = 1
        AND c0_.structure_generated_at IS NOT NULL
        AND EXISTS (
          SELECT
            c8_.id
          FROM
            course_chapter c8_
          WHERE
            c8_.course_id = c0_.id
        )
        AND NOT EXISTS (
          SELECT
            c9_.id
          FROM
            course_chapter c9_
          WHERE
            c9_.course_id = c0_.id
            AND c9_.status <> ?
        )
      )
    )
  )
  AND c0_.company_document_id IS NULL
  AND c0_.publicly_shared = 1

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM course c0_ LEFT JOIN weekly_recommandation w1_ ON c0_.weekly_recommandation_id = w1_.id LEFT JOIN `user` u2_ ON w1_.user_id = u2_.id LEFT JOIN company_employee_future_skill c3_ ON c0_.future_skill_id = c3_.id LEFT JOIN company_employee c4_ ON c3_.company_employee_id = c4_.id LEFT JOIN `user` u5_ ON c4_.user_id = u5_.id LEFT JOIN user_purchased_course u6_ ON (u6_.course_id = c0_.id) LEFT JOIN `user` u7_ ON u6_.user_id = u7_.id WHERE (((c0_.is_progressive = 0 AND c0_.course IS NOT NULL) OR (c0_.is_progressive = 1 AND c0_.structure_generated_at IS NOT NULL AND EXISTS (SELECT c8_.id FROM course_chapter c8_ WHERE c8_.course_id = c0_.id) AND NOT EXISTS (SELECT c9_.id FROM course_chapter c9_ WHERE c9_.course_id = c0_.id AND c9_.status <> 'ready')))) AND c0_.company_document_id IS NULL AND c0_.publicly_shared = 1;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.level AS level_2,
  c0_.description AS description_3,
  c0_.course AS course_4,
  c0_.is_completed AS is_completed_5,
  c0_.completed_at AS completed_at_6,
  c0_.level_code AS level_code_7,
  c0_.is_progressive AS is_progressive_8,
  c0_.structure_generated_at AS structure_generated_at_9,
  c0_.language AS language_10,
  c0_.subject AS subject_11,
  c0_.rating_average AS rating_average_12,
  c0_.rating_count AS rating_count_13,
  c0_.public_view_count AS public_view_count_14,
  c0_.publicly_shared AS publicly_shared_15,
  CASE WHEN w1_.id IS NOT NULL THEN
    'weekly'
  WHEN c2_.id IS NOT NULL THEN
    'roadmap'
  WHEN u3_.id IS NOT NULL THEN
    'purchased'
  ELSE
    'unknown'
  END AS sclr_16,
  COALESCE(u4_.id, u5_.id, u6_.id) AS sclr_17,
  COALESCE(u4_.email, u5_.email, u6_.email) AS sclr_18,
  COALESCE(
    u4_.first_name, u5_.first_name, u6_.first_name
  ) AS sclr_19,
  COALESCE(
    u4_.last_name, u5_.last_name, u6_.last_name
  ) AS sclr_20,
  c0_.weekly_recommandation_id AS weekly_recommandation_id_21,
  c0_.future_skill_id AS future_skill_id_22,
  c0_.company_document_id AS company_document_id_23
FROM
  course c0_
  LEFT JOIN weekly_recommandation w1_ ON c0_.weekly_recommandation_id = w1_.id
  LEFT JOIN `user` u4_ ON w1_.user_id = u4_.id
  LEFT JOIN company_employee_future_skill c2_ ON c0_.future_skill_id = c2_.id
  LEFT JOIN company_employee c7_ ON c2_.company_employee_id = c7_.id
  LEFT JOIN `user` u5_ ON c7_.user_id = u5_.id
  LEFT JOIN user_purchased_course u3_ ON (u3_.course_id = c0_.id)
  LEFT JOIN `user` u6_ ON u3_.user_id = u6_.id
WHERE
  (
    (
      (
        c0_.is_progressive = 0
        AND c0_.course IS NOT NULL
      )
      OR (
        c0_.is_progressive = 1
        AND c0_.structure_generated_at IS NOT NULL
        AND EXISTS (
          SELECT
            c8_.id
          FROM
            course_chapter c8_
          WHERE
            c8_.course_id = c0_.id
        )
        AND NOT EXISTS (
          SELECT
            c9_.id
          FROM
            course_chapter c9_
          WHERE
            c9_.course_id = c0_.id
            AND c9_.status <> ?
        )
      )
    )
  )
  AND c0_.company_document_id IS NULL
  AND c0_.publicly_shared = 1
ORDER BY
  c0_.id DESC
LIMIT
  12

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.level AS level_2, c0_.description AS description_3, c0_.course AS course_4, c0_.is_completed AS is_completed_5, c0_.completed_at AS completed_at_6, c0_.level_code AS level_code_7, c0_.is_progressive AS is_progressive_8, c0_.structure_generated_at AS structure_generated_at_9, c0_.language AS language_10, c0_.subject AS subject_11, c0_.rating_average AS rating_average_12, c0_.rating_count AS rating_count_13, c0_.public_view_count AS public_view_count_14, c0_.publicly_shared AS publicly_shared_15, CASE WHEN w1_.id IS NOT NULL THEN 'weekly' WHEN c2_.id IS NOT NULL THEN 'roadmap' WHEN u3_.id IS NOT NULL THEN 'purchased' ELSE 'unknown' END AS sclr_16, COALESCE(u4_.id, u5_.id, u6_.id) AS sclr_17, COALESCE(u4_.email, u5_.email, u6_.email) AS sclr_18, COALESCE(u4_.first_name, u5_.first_name, u6_.first_name) AS sclr_19, COALESCE(u4_.last_name, u5_.last_name, u6_.last_name) AS sclr_20, c0_.weekly_recommandation_id AS weekly_recommandation_id_21, c0_.future_skill_id AS future_skill_id_22, c0_.company_document_id AS company_document_id_23 FROM course c0_ LEFT JOIN weekly_recommandation w1_ ON c0_.weekly_recommandation_id = w1_.id LEFT JOIN `user` u4_ ON w1_.user_id = u4_.id LEFT JOIN company_employee_future_skill c2_ ON c0_.future_skill_id = c2_.id LEFT JOIN company_employee c7_ ON c2_.company_employee_id = c7_.id LEFT JOIN `user` u5_ ON c7_.user_id = u5_.id LEFT JOIN user_purchased_course u3_ ON (u3_.course_id = c0_.id) LEFT JOIN `user` u6_ ON u3_.user_id = u6_.id WHERE (((c0_.is_progressive = 0 AND c0_.course IS NOT NULL) OR (c0_.is_progressive = 1 AND c0_.structure_generated_at IS NOT NULL AND EXISTS (SELECT c8_.id FROM course_chapter c8_ WHERE c8_.course_id = c0_.id) AND NOT EXISTS (SELECT c9_.id FROM course_chapter c9_ WHERE c9_.course_id = c0_.id AND c9_.status <> 'ready')))) AND c0_.company_document_id IS NULL AND c0_.publicly_shared = 1 ORDER BY c0_.id DESC LIMIT 12;