Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.image_name AS image_name_1,
  m0_.image_size AS image_size_2,
  m0_.subtitle AS subtitle_3,
  m0_.title AS title_4,
  m0_.position AS position_5,
  m0_.is_active AS is_active_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8
FROM
  main_slider m0_
WHERE
  m0_.is_active = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.image_name AS image_name_1, m0_.image_size AS image_size_2, m0_.subtitle AS subtitle_3, m0_.title AS title_4, m0_.position AS position_5, m0_.is_active AS is_active_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8 FROM main_slider m0_ WHERE m0_.is_active = 1 ORDER BY m0_.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.icon AS icon_2,
  p0_.project_count AS project_count_3,
  p0_.is_active AS is_active_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6
FROM
  project_category p0_
WHERE
  p0_.is_active = ?
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.icon AS icon_2, p0_.project_count AS project_count_3, p0_.is_active AS is_active_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6 FROM project_category p0_ WHERE p0_.is_active = 1 ORDER BY p0_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.goal AS goal_3,
  p0_.pledged AS pledged_4,
  p0_.image AS image_5,
  p0_.start_date AS start_date_6,
  p0_.end_date AS end_date_7,
  p0_.completed_at AS completed_at_8,
  p0_.slug AS slug_9,
  p0_.is_active AS is_active_10,
  p0_.status AS status_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  COALESCE(
    SUM(e1_.amount),
    0
  ) AS sclr_14,
  p0_.category_id AS category_id_15,
  p0_.creator_id AS creator_id_16,
  p0_.owner_id AS owner_id_17
FROM
  project p0_
  LEFT JOIN "user" u2_ ON p0_.creator_id = u2_.id
  LEFT JOIN donation d3_ ON u2_.id = d3_.donor_id
  LEFT JOIN earning e1_ ON d3_.id = e1_.beneficiary_id
WHERE
  p0_.is_active = ?
GROUP BY
  p0_.id
ORDER BY
  sclr_14 DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.goal AS goal_3, p0_.pledged AS pledged_4, p0_.image AS image_5, p0_.start_date AS start_date_6, p0_.end_date AS end_date_7, p0_.completed_at AS completed_at_8, p0_.slug AS slug_9, p0_.is_active AS is_active_10, p0_.status AS status_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, COALESCE(SUM(e1_.amount), 0) AS sclr_14, p0_.category_id AS category_id_15, p0_.creator_id AS creator_id_16, p0_.owner_id AS owner_id_17 FROM project p0_ LEFT JOIN "user" u2_ ON p0_.creator_id = u2_.id LEFT JOIN donation d3_ ON u2_.id = d3_.donor_id LEFT JOIN earning e1_ ON d3_.id = e1_.beneficiary_id WHERE p0_.is_active = 1 GROUP BY p0_.id ORDER BY sclr_14 DESC LIMIT 3;

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  donation d0_
WHERE
  d0_.payment_status = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM donation d0_ WHERE d0_.payment_status = 'completed';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  "user" u0_

SELECT COUNT(u0_.id) AS sclr_0 FROM "user" u0_;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.goal AS goal_3,
  p0_.pledged AS pledged_4,
  p0_.image AS image_5,
  p0_.start_date AS start_date_6,
  p0_.end_date AS end_date_7,
  p0_.completed_at AS completed_at_8,
  p0_.slug AS slug_9,
  p0_.is_active AS is_active_10,
  p0_.status AS status_11,
  p0_.created_at AS created_at_12,
  p0_.updated_at AS updated_at_13,
  COALESCE(
    SUM(e1_.amount),
    0
  ) AS sclr_14,
  p0_.category_id AS category_id_15,
  p0_.creator_id AS creator_id_16,
  p0_.owner_id AS owner_id_17
FROM
  project p0_
  LEFT JOIN "user" u2_ ON p0_.creator_id = u2_.id
  LEFT JOIN donation d3_ ON u2_.id = d3_.donor_id
  LEFT JOIN earning e1_ ON d3_.id = e1_.beneficiary_id
WHERE
  p0_.is_active = ?
GROUP BY
  p0_.id
ORDER BY
  sclr_14 DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.goal AS goal_3, p0_.pledged AS pledged_4, p0_.image AS image_5, p0_.start_date AS start_date_6, p0_.end_date AS end_date_7, p0_.completed_at AS completed_at_8, p0_.slug AS slug_9, p0_.is_active AS is_active_10, p0_.status AS status_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, COALESCE(SUM(e1_.amount), 0) AS sclr_14, p0_.category_id AS category_id_15, p0_.creator_id AS creator_id_16, p0_.owner_id AS owner_id_17 FROM project p0_ LEFT JOIN "user" u2_ ON p0_.creator_id = u2_.id LEFT JOIN donation d3_ ON u2_.id = d3_.donor_id LEFT JOIN earning e1_ ON d3_.id = e1_.beneficiary_id WHERE p0_.is_active = 1 GROUP BY p0_.id ORDER BY sclr_14 DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3,
  t0.content AS content_4,
  t0.rating AS rating_5,
  t0.image_name AS image_name_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  testimonial t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.content AS content_4, t0.rating AS rating_5, t0.image_name AS image_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM testimonial t0;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.image AS image_3,
  n0_.excerpt AS excerpt_4,
  n0_.content AS content_5,
  n0_.author AS author_6,
  n0_.comments_count AS comments_count_7,
  n0_.tags AS tags_8,
  n0_.created_at AS created_at_9,
  n0_.updated_at AS updated_at_10,
  n0_.category_id AS category_id_11
FROM
  news_article n0_
ORDER BY
  n0_.created_at DESC
LIMIT
  3

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.image AS image_3, n0_.excerpt AS excerpt_4, n0_.content AS content_5, n0_.author AS author_6, n0_.comments_count AS comments_count_7, n0_.tags AS tags_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.category_id AS category_id_11 FROM news_article n0_ ORDER BY n0_.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.comment AS comment_2,
  t0.rating AS rating_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.project_id AS project_id_6,
  t0.author_id AS author_id_7
FROM
  project_review t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.rating AS rating_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.project_id AS project_id_6, t0.author_id AS author_id_7 FROM project_review t0 WHERE t0.project_id = 6;

SELECT
  t0.id AS id_1,
  t0.comment AS comment_2,
  t0.rating AS rating_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.project_id AS project_id_6,
  t0.author_id AS author_id_7
FROM
  project_review t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.rating AS rating_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.project_id AS project_id_6, t0.author_id AS author_id_7 FROM project_review t0 WHERE t0.project_id = 8;

SELECT
  t0.id AS id_1,
  t0.comment AS comment_2,
  t0.rating AS rating_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.project_id AS project_id_6,
  t0.author_id AS author_id_7
FROM
  project_review t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.rating AS rating_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.project_id AS project_id_6, t0.author_id AS author_id_7 FROM project_review t0 WHERE t0.project_id = 9;

SELECT
  t0.id AS id_1,
  t0.comment AS comment_2,
  t0.rating AS rating_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.project_id AS project_id_6,
  t0.author_id AS author_id_7
FROM
  project_review t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.rating AS rating_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.project_id AS project_id_6, t0.author_id AS author_id_7 FROM project_review t0 WHERE t0.project_id = 10;