Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.title AS title_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.challenge_type AS challenge_type_6,
  t0.difficulty AS difficulty_7,
  t0.status AS status_8,
  t0.visibility AS visibility_9,
  t0.evaluation_mode AS evaluation_mode_10,
  t0.total_xp AS total_xp_11,
  t0.skill_configuration AS skill_configuration_12,
  t0.registration_start AS registration_start_13,
  t0.registration_end AS registration_end_14,
  t0.execution_start AS execution_start_15,
  t0.execution_end AS execution_end_16,
  t0.time_limit AS time_limit_17,
  t0.is_perpetual AS is_perpetual_18,
  t0.participation_type AS participation_type_19,
  t0.min_team_size AS min_team_size_20,
  t0.max_team_size AS max_team_size_21,
  t0.max_participants AS max_participants_22,
  t0.max_attempts AS max_attempts_23,
  t0.pass_percentage AS pass_percentage_24,
  t0.target_audiences AS target_audiences_25,
  t0.prerequisites AS prerequisites_26,
  t0.knowledge_links AS knowledge_links_27,
  t0.scenario_content AS scenario_content_28,
  t0.badge_icon_class AS badge_icon_class_29,
  t0.featured_image_url AS featured_image_url_30,
  t0.participant_count AS participant_count_31,
  t0.completion_count AS completion_count_32,
  t0.average_score AS average_score_33,
  t0.created_at AS created_at_34,
  t0.updated_at AS updated_at_35,
  t0.published_at AS published_at_36,
  t0.created_by_id AS created_by_id_37
FROM
  challenge t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.title AS title_3, t0.slug AS slug_4, t0.description AS description_5, t0.challenge_type AS challenge_type_6, t0.difficulty AS difficulty_7, t0.status AS status_8, t0.visibility AS visibility_9, t0.evaluation_mode AS evaluation_mode_10, t0.total_xp AS total_xp_11, t0.skill_configuration AS skill_configuration_12, t0.registration_start AS registration_start_13, t0.registration_end AS registration_end_14, t0.execution_start AS execution_start_15, t0.execution_end AS execution_end_16, t0.time_limit AS time_limit_17, t0.is_perpetual AS is_perpetual_18, t0.participation_type AS participation_type_19, t0.min_team_size AS min_team_size_20, t0.max_team_size AS max_team_size_21, t0.max_participants AS max_participants_22, t0.max_attempts AS max_attempts_23, t0.pass_percentage AS pass_percentage_24, t0.target_audiences AS target_audiences_25, t0.prerequisites AS prerequisites_26, t0.knowledge_links AS knowledge_links_27, t0.scenario_content AS scenario_content_28, t0.badge_icon_class AS badge_icon_class_29, t0.featured_image_url AS featured_image_url_30, t0.participant_count AS participant_count_31, t0.completion_count AS completion_count_32, t0.average_score AS average_score_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.published_at AS published_at_36, t0.created_by_id AS created_by_id_37 FROM challenge t0 WHERE t0.slug = 'epilisi-singrouseon-omadhas' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.status AS status_1,
  c0_.registered_at AS registered_at_2,
  c0_.started_at AS started_at_3,
  c0_.submitted_at AS submitted_at_4,
  c0_.completed_at AS completed_at_5,
  c0_.attempt_number AS attempt_number_6,
  c0_.score AS score_7,
  c0_.xp_earned AS xp_earned_8,
  c0_.passed AS passed_9,
  c0_.feedback AS feedback_10,
  c0_.quiz_responses AS quiz_responses_11,
  c0_.decision_tree_path AS decision_tree_path_12,
  c0_.time_spent_seconds AS time_spent_seconds_13,
  c0_.challenge_id AS challenge_id_14,
  c0_.user_id AS user_id_15,
  c0_.team_id AS team_id_16
FROM
  challenge_participation c0_
WHERE
  c0_.challenge_id = ?
  AND c0_.status = ?
  AND c0_.passed = 1
ORDER BY
  c0_.score DESC,
  c0_.time_spent_seconds ASC
LIMIT
  10

SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.registered_at AS registered_at_2, c0_.started_at AS started_at_3, c0_.submitted_at AS submitted_at_4, c0_.completed_at AS completed_at_5, c0_.attempt_number AS attempt_number_6, c0_.score AS score_7, c0_.xp_earned AS xp_earned_8, c0_.passed AS passed_9, c0_.feedback AS feedback_10, c0_.quiz_responses AS quiz_responses_11, c0_.decision_tree_path AS decision_tree_path_12, c0_.time_spent_seconds AS time_spent_seconds_13, c0_.challenge_id AS challenge_id_14, c0_.user_id AS user_id_15, c0_.team_id AS team_id_16 FROM challenge_participation c0_ WHERE c0_.challenge_id = 5 AND c0_.status = 'completed' AND c0_.passed = 1 ORDER BY c0_.score DESC, c0_.time_spent_seconds ASC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.role AS role_6,
  t0.level AS level_7,
  t0.total_xp AS total_xp_8,
  t0.global_rank AS global_rank_9,
  t0.profile_title AS profile_title_10,
  t0.avatar_url AS avatar_url_11,
  t0.bio AS bio_12,
  t0.location AS location_13,
  t0.linkedin_url AS linkedin_url_14,
  t0.github_url AS github_url_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.last_active_at AS last_active_at_18,
  t0.is_active AS is_active_19,
  t0.email_verified AS email_verified_20,
  t0.preferred_locale AS preferred_locale_21,
  t0.password_reset_token AS password_reset_token_22,
  t0.password_reset_requested_at AS password_reset_requested_at_23,
  t0.password_reset_expires_at AS password_reset_expires_at_24
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.role AS role_6, t0.level AS level_7, t0.total_xp AS total_xp_8, t0.global_rank AS global_rank_9, t0.profile_title AS profile_title_10, t0.avatar_url AS avatar_url_11, t0.bio AS bio_12, t0.location AS location_13, t0.linkedin_url AS linkedin_url_14, t0.github_url AS github_url_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.last_active_at AS last_active_at_18, t0.is_active AS is_active_19, t0.email_verified AS email_verified_20, t0.preferred_locale AS preferred_locale_21, t0.password_reset_token AS password_reset_token_22, t0.password_reset_requested_at AS password_reset_requested_at_23, t0.password_reset_expires_at AS password_reset_expires_at_24 FROM user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.deliverable_type AS deliverable_type_4,
  t0.is_required AS is_required_5,
  t0.evaluation_weight AS evaluation_weight_6,
  t0.order_position AS order_position_7,
  t0.configuration AS configuration_8,
  t0.challenge_id AS challenge_id_9
FROM
  challenge_deliverable t0
WHERE
  t0.challenge_id = ?
ORDER BY
  t0.order_position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.deliverable_type AS deliverable_type_4, t0.is_required AS is_required_5, t0.evaluation_weight AS evaluation_weight_6, t0.order_position AS order_position_7, t0.configuration AS configuration_8, t0.challenge_id AS challenge_id_9 FROM challenge_deliverable t0 WHERE t0.challenge_id = 5 ORDER BY t0.order_position ASC;