Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.unlock_how AS unlock_how_4,
  t0.unlocked AS unlocked_5,
  t0.level AS level_6,
  t0.step_value AS step_value_7,
  t0.position AS position_8,
  t0.type_id AS type_id_9
FROM
  badge t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.images AS images_2,
  t0.video AS video_3,
  t0.html AS html_4,
  t0.theme AS theme_5,
  t0.to_do AS to_do_6,
  t0.how_to AS how_to_7,
  t0.when_to AS when_to_8,
  t0.attention_to AS attention_to_9,
  t0.success_how AS success_how_10,
  t0.duration AS duration_11,
  t0.subtitle AS subtitle_12,
  t0.is_permanent AS is_permanent_13,
  t0.is_weekly AS is_weekly_14,
  t0.completed_count AS completed_count_15,
  t0.last_completed_date AS last_completed_date_16,
  t0.completed AS completed_17,
  t0.total_elapsed_seconds AS total_elapsed_seconds_18,
  t0.to_do_count AS to_do_count_19,
  t0.daily_completed_count AS daily_completed_count_20,
  t0.position AS position_21,
  t0.template_id AS template_id_22,
  t0.user_id AS user_id_23
FROM
  exercise t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent AS is_permanent_13, t0.is_weekly AS is_weekly_14, t0.completed_count AS completed_count_15, t0.last_completed_date AS last_completed_date_16, t0.completed AS completed_17, t0.total_elapsed_seconds AS total_elapsed_seconds_18, t0.to_do_count AS to_do_count_19, t0.daily_completed_count AS daily_completed_count_20, t0.position AS position_21, t0.template_id AS template_id_22, t0.user_id AS user_id_23 FROM exercise t0 WHERE t0.user_id = 133;

SELECT
  t0.id AS id_1,
  t0.images AS images_2,
  t0.video AS video_3,
  t0.html AS html_4,
  t0.theme AS theme_5,
  t0.to_do AS to_do_6,
  t0.how_to AS how_to_7,
  t0.when_to AS when_to_8,
  t0.attention_to AS attention_to_9,
  t0.success_how AS success_how_10,
  t0.duration AS duration_11,
  t0.subtitle AS subtitle_12,
  t0.is_permanent AS is_permanent_13,
  t0.is_weekly AS is_weekly_14,
  t0.completed_count AS completed_count_15,
  t0.last_completed_date AS last_completed_date_16,
  t0.completed AS completed_17,
  t0.total_elapsed_seconds AS total_elapsed_seconds_18,
  t0.to_do_count AS to_do_count_19,
  t0.daily_completed_count AS daily_completed_count_20,
  t0.position AS position_21,
  t0.template_id AS template_id_22,
  t0.user_id AS user_id_23
FROM
  exercise t0
WHERE
  t0.user_id = ?
  AND t0.is_weekly = ?
  AND t0.completed = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent AS is_permanent_13, t0.is_weekly AS is_weekly_14, t0.completed_count AS completed_count_15, t0.last_completed_date AS last_completed_date_16, t0.completed AS completed_17, t0.total_elapsed_seconds AS total_elapsed_seconds_18, t0.to_do_count AS to_do_count_19, t0.daily_completed_count AS daily_completed_count_20, t0.position AS position_21, t0.template_id AS template_id_22, t0.user_id AS user_id_23 FROM exercise t0 WHERE t0.user_id = 133 AND t0.is_weekly = 1 AND t0.completed = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.seen AS seen_2,
  t0.earned AS earned_3,
  t0.earned_date AS earned_date_4,
  t0.user_id AS user_id_5,
  t0.badge_id AS badge_id_6
FROM
  user_badge t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.seen AS seen_2, t0.earned AS earned_3, t0.earned_date AS earned_date_4, t0.user_id AS user_id_5, t0.badge_id AS badge_id_6 FROM user_badge t0 WHERE t0.user_id = 133;

SELECT
  t0.id AS id_1,
  t0.images AS images_2,
  t0.video AS video_3,
  t0.html AS html_4,
  t0.theme AS theme_5,
  t0.to_do AS to_do_6,
  t0.how_to AS how_to_7,
  t0.when_to AS when_to_8,
  t0.attention_to AS attention_to_9,
  t0.success_how AS success_how_10,
  t0.duration AS duration_11,
  t0.subtitle AS subtitle_12,
  t0.is_permanent AS is_permanent_13,
  t0.is_weekly AS is_weekly_14,
  t0.completed_count AS completed_count_15,
  t0.last_completed_date AS last_completed_date_16,
  t0.completed AS completed_17,
  t0.total_elapsed_seconds AS total_elapsed_seconds_18,
  t0.to_do_count AS to_do_count_19,
  t0.daily_completed_count AS daily_completed_count_20,
  t0.position AS position_21,
  t0.template_id AS template_id_22,
  t0.user_id AS user_id_23
FROM
  exercise t0
WHERE
  t0.user_id = ?
  AND t0.completed = ?

SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent AS is_permanent_13, t0.is_weekly AS is_weekly_14, t0.completed_count AS completed_count_15, t0.last_completed_date AS last_completed_date_16, t0.completed AS completed_17, t0.total_elapsed_seconds AS total_elapsed_seconds_18, t0.to_do_count AS to_do_count_19, t0.daily_completed_count AS daily_completed_count_20, t0.position AS position_21, t0.template_id AS template_id_22, t0.user_id AS user_id_23 FROM exercise t0 WHERE t0.user_id = 133 AND t0.completed = 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.total_completed_days AS total_completed_days_5,
  t0.creation_date AS creation_date_6,
  t0.starting_date AS starting_date_7,
  t0.week_completed_percents AS week_completed_percents_8,
  t0.notes AS notes_9,
  t0.max_completed_days AS max_completed_days_10
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.total_completed_days AS total_completed_days_5, t0.creation_date AS creation_date_6, t0.starting_date AS starting_date_7, t0.week_completed_percents AS week_completed_percents_8, t0.notes AS notes_9, t0.max_completed_days AS max_completed_days_10 FROM user t0 WHERE t0.username = 'Nanou.1430' LIMIT 1;

SELECT
  sum(e0_.to_do_count) AS sclr_0
FROM
  exercise e0_
WHERE
  e0_.user_id = ?
  AND e0_.completed = 0
  AND (
    e0_.is_weekly = 1
    OR e0_.is_permanent = 1
  )

SELECT sum(e0_.to_do_count) AS sclr_0 FROM exercise e0_ WHERE e0_.user_id = 133 AND e0_.completed = 0 AND (e0_.is_weekly = 1 OR e0_.is_permanent = 1);

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.raw_value AS raw_value_3
FROM
  avatar_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.raw_value AS raw_value_3 FROM avatar_type t0 WHERE t0.id = 2;

SELECT
  sum(e0_.daily_completed_count) AS sclr_0
FROM
  exercise e0_
WHERE
  e0_.user_id = ?
  AND e0_.completed = 0
  AND (
    e0_.is_weekly = 1
    OR e0_.is_permanent = 1
  )

SELECT sum(e0_.daily_completed_count) AS sclr_0 FROM exercise e0_ WHERE e0_.user_id = 133 AND e0_.completed = 0 AND (e0_.is_weekly = 1 OR e0_.is_permanent = 1);

SELECT
  t0.id AS id_1,
  t0.seen AS seen_2,
  t0.earned AS earned_3,
  t0.earned_date AS earned_date_4,
  t0.accessory_id AS accessory_id_5,
  t0.user_id AS user_id_6
FROM
  user_accessory t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.seen AS seen_2, t0.earned AS earned_3, t0.earned_date AS earned_date_4, t0.accessory_id AS accessory_id_5, t0.user_id AS user_id_6 FROM user_accessory t0 WHERE t0.user_id = 133;

SELECT
  t0.id AS id_1,
  t0.images AS images_2,
  t0.video AS video_3,
  t0.html AS html_4,
  t0.theme AS theme_5,
  t0.to_do AS to_do_6,
  t0.how_to AS how_to_7,
  t0.when_to AS when_to_8,
  t0.attention_to AS attention_to_9,
  t0.success_how AS success_how_10,
  t0.duration AS duration_11,
  t0.subtitle AS subtitle_12,
  t0.is_permanent_by_default AS is_permanent_by_default_13,
  t0.is_weekly_by_default AS is_weekly_by_default_14,
  t0.to_do_count AS to_do_count_15,
  t0.added_value AS added_value_16,
  t0.position AS position_17,
  t0.type_id AS type_id_18,
  t0.badge_type_id AS badge_type_id_19,
  t0.linked_badge_id AS linked_badge_id_20
FROM
  exercise_template t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent_by_default AS is_permanent_by_default_13, t0.is_weekly_by_default AS is_weekly_by_default_14, t0.to_do_count AS to_do_count_15, t0.added_value AS added_value_16, t0.position AS position_17, t0.type_id AS type_id_18, t0.badge_type_id AS badge_type_id_19, t0.linked_badge_id AS linked_badge_id_20 FROM exercise_template t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.title AS title_3,
  t0.unlock_how AS unlock_how_4,
  t0.avatar_id AS avatar_id_5,
  t0.badge_id AS badge_id_6
FROM
  accessory t0
WHERE
  t0.avatar_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.unlock_how AS unlock_how_4, t0.avatar_id AS avatar_id_5, t0.badge_id AS badge_id_6 FROM accessory t0 WHERE t0.avatar_id = 4;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.unlock_how AS unlock_how_4,
  t0.level AS level_5,
  t0.avatar_type_id AS avatar_type_id_6,
  t0.badge_id AS badge_id_7
FROM
  avatar t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.level AS level_5, t0.avatar_type_id AS avatar_type_id_6, t0.badge_id AS badge_id_7 FROM avatar t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.seen AS seen_2,
  t0.earned AS earned_3,
  t0.earned_date AS earned_date_4,
  t0.user_id AS user_id_5,
  t0.avatar_id AS avatar_id_6
FROM
  user_avatar t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.seen AS seen_2, t0.earned AS earned_3, t0.earned_date AS earned_date_4, t0.user_id AS user_id_5, t0.avatar_id AS avatar_id_6 FROM user_avatar t0 WHERE t0.user_id = 133;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.position AS position_3
FROM
  exercise_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3 FROM exercise_type t0 WHERE t0.id = 5;