Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.description AS description_2,
  t0_.status AS status_3,
  t0_.generated_prompt AS generated_prompt_4,
  t0_.git_branch AS git_branch_5,
  t0_.last_commit_sha AS last_commit_sha_6,
  t0_.last_checked_at AS last_checked_at_7,
  t0_.created_at AS created_at_8,
  p1_.id AS id_9,
  p1_.name AS name_10,
  p1_.description AS description_11,
  p1_.github_repo_url AS github_repo_url_12,
  p1_.status AS status_13,
  p1_.created_at AS created_at_14,
  a2_.id AS id_15,
  a2_.name AS name_16,
  a2_.role AS role_17,
  a2_.system_prompt AS system_prompt_18,
  a2_.execution_mode AS execution_mode_19,
  a2_.created_at AS created_at_20,
  t0_.project_id AS project_id_21,
  t0_.agent_id AS agent_id_22
FROM
  task t0_
  LEFT JOIN project p1_ ON t0_.project_id = p1_.id
  LEFT JOIN agent a2_ ON t0_.agent_id = a2_.id
WHERE
  t0_.status = ?
ORDER BY
  t0_.last_checked_at DESC,
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.status AS status_3, t0_.generated_prompt AS generated_prompt_4, t0_.git_branch AS git_branch_5, t0_.last_commit_sha AS last_commit_sha_6, t0_.last_checked_at AS last_checked_at_7, t0_.created_at AS created_at_8, p1_.id AS id_9, p1_.name AS name_10, p1_.description AS description_11, p1_.github_repo_url AS github_repo_url_12, p1_.status AS status_13, p1_.created_at AS created_at_14, a2_.id AS id_15, a2_.name AS name_16, a2_.role AS role_17, a2_.system_prompt AS system_prompt_18, a2_.execution_mode AS execution_mode_19, a2_.created_at AS created_at_20, t0_.project_id AS project_id_21, t0_.agent_id AS agent_id_22 FROM task t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id LEFT JOIN agent a2_ ON t0_.agent_id = a2_.id WHERE t0_.status = 'to_validate' ORDER BY t0_.last_checked_at DESC, t0_.created_at DESC;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.description AS description_2,
  t0_.status AS status_3,
  t0_.generated_prompt AS generated_prompt_4,
  t0_.git_branch AS git_branch_5,
  t0_.last_commit_sha AS last_commit_sha_6,
  t0_.last_checked_at AS last_checked_at_7,
  t0_.created_at AS created_at_8,
  p1_.id AS id_9,
  p1_.name AS name_10,
  p1_.description AS description_11,
  p1_.github_repo_url AS github_repo_url_12,
  p1_.status AS status_13,
  p1_.created_at AS created_at_14,
  a2_.id AS id_15,
  a2_.name AS name_16,
  a2_.role AS role_17,
  a2_.system_prompt AS system_prompt_18,
  a2_.execution_mode AS execution_mode_19,
  a2_.created_at AS created_at_20,
  t0_.project_id AS project_id_21,
  t0_.agent_id AS agent_id_22
FROM
  task t0_
  LEFT JOIN project p1_ ON t0_.project_id = p1_.id
  LEFT JOIN agent a2_ ON t0_.agent_id = a2_.id
ORDER BY
  t0_.last_checked_at DESC,
  t0_.created_at DESC
LIMIT
  10

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.status AS status_3, t0_.generated_prompt AS generated_prompt_4, t0_.git_branch AS git_branch_5, t0_.last_commit_sha AS last_commit_sha_6, t0_.last_checked_at AS last_checked_at_7, t0_.created_at AS created_at_8, p1_.id AS id_9, p1_.name AS name_10, p1_.description AS description_11, p1_.github_repo_url AS github_repo_url_12, p1_.status AS status_13, p1_.created_at AS created_at_14, a2_.id AS id_15, a2_.name AS name_16, a2_.role AS role_17, a2_.system_prompt AS system_prompt_18, a2_.execution_mode AS execution_mode_19, a2_.created_at AS created_at_20, t0_.project_id AS project_id_21, t0_.agent_id AS agent_id_22 FROM task t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id LEFT JOIN agent a2_ ON t0_.agent_id = a2_.id ORDER BY t0_.last_checked_at DESC, t0_.created_at DESC LIMIT 10;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.description AS description_2,
  t0_.status AS status_3,
  t0_.generated_prompt AS generated_prompt_4,
  t0_.git_branch AS git_branch_5,
  t0_.last_commit_sha AS last_commit_sha_6,
  t0_.last_checked_at AS last_checked_at_7,
  t0_.created_at AS created_at_8,
  p1_.id AS id_9,
  p1_.name AS name_10,
  p1_.description AS description_11,
  p1_.github_repo_url AS github_repo_url_12,
  p1_.status AS status_13,
  p1_.created_at AS created_at_14,
  a2_.id AS id_15,
  a2_.name AS name_16,
  a2_.role AS role_17,
  a2_.system_prompt AS system_prompt_18,
  a2_.execution_mode AS execution_mode_19,
  a2_.created_at AS created_at_20,
  t0_.project_id AS project_id_21,
  t0_.agent_id AS agent_id_22
FROM
  task t0_
  LEFT JOIN project p1_ ON t0_.project_id = p1_.id
  LEFT JOIN agent a2_ ON t0_.agent_id = a2_.id
WHERE
  t0_.status = ?
ORDER BY
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.status AS status_3, t0_.generated_prompt AS generated_prompt_4, t0_.git_branch AS git_branch_5, t0_.last_commit_sha AS last_commit_sha_6, t0_.last_checked_at AS last_checked_at_7, t0_.created_at AS created_at_8, p1_.id AS id_9, p1_.name AS name_10, p1_.description AS description_11, p1_.github_repo_url AS github_repo_url_12, p1_.status AS status_13, p1_.created_at AS created_at_14, a2_.id AS id_15, a2_.name AS name_16, a2_.role AS role_17, a2_.system_prompt AS system_prompt_18, a2_.execution_mode AS execution_mode_19, a2_.created_at AS created_at_20, t0_.project_id AS project_id_21, t0_.agent_id AS agent_id_22 FROM task t0_ LEFT JOIN project p1_ ON t0_.project_id = p1_.id LEFT JOIN agent a2_ ON t0_.agent_id = a2_.id WHERE t0_.status = 'todo' ORDER BY t0_.created_at DESC;

SELECT
  t0_.status AS status_0,
  COUNT(t0_.id) AS sclr_1
FROM
  task t0_
GROUP BY
  t0_.status

SELECT t0_.status AS status_0, COUNT(t0_.id) AS sclr_1 FROM task t0_ GROUP BY t0_.status;

SELECT
  t0_.project_id AS sclr_0,
  t0_.status AS status_1,
  COUNT(t0_.id) AS sclr_2
FROM
  task t0_
  INNER JOIN project p1_ ON t0_.project_id = p1_.id
WHERE
  p1_.status = ?
GROUP BY
  t0_.project_id,
  t0_.status

SELECT t0_.project_id AS sclr_0, t0_.status AS status_1, COUNT(t0_.id) AS sclr_2 FROM task t0_ INNER JOIN project p1_ ON t0_.project_id = p1_.id WHERE p1_.status = 'active' GROUP BY t0_.project_id, t0_.status;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  project p0_
WHERE
  p0_.status = ?

SELECT COUNT(p0_.id) AS sclr_0 FROM project p0_ WHERE p0_.status = 'active';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.github_repo_url AS github_repo_url_3,
  p0_.status AS status_4,
  p0_.created_at AS created_at_5
FROM
  project p0_
WHERE
  p0_.status = ?
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.github_repo_url AS github_repo_url_3, p0_.status AS status_4, p0_.created_at AS created_at_5 FROM project p0_ WHERE p0_.status = 'active' ORDER BY p0_.created_at DESC;