Symfony Profiler

SELECT
  count(u0_.id) AS sclr_0
FROM
  user_review u0_
  LEFT JOIN user u1_ ON u0_.review_creator_id = u1_.id
  AND (u1_.deleted_date IS NULL)
WHERE
  (
    u0_.user_id IS NULL
    AND (
      (
        u0_.review_status = ?
        OR u0_.review_status = ?
      )
    )
  )
  AND (u0_.deleted_date IS NULL)

SELECT count(u0_.id) AS sclr_0 FROM user_review u0_ LEFT JOIN user u1_ ON u0_.review_creator_id = u1_.id AND (u1_.deleted_date IS NULL) WHERE (u0_.user_id IS NULL AND ((u0_.review_status = 'approved' OR u0_.review_status = 'pending'))) AND (u0_.deleted_date IS NULL);

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.name AS name_2,
  s0_.country_id AS country_id_3
FROM
  state s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.name AS name_2, s0_.country_id AS country_id_3 FROM state s0_ ORDER BY s0_.name ASC;

SELECT
  o0_.id AS id_0,
  o0_.require_review AS require_review_1,
  o0_.name AS name_2,
  o0_.email AS email_3,
  o0_.address AS address_4,
  o0_.zip_code AS zip_code_5,
  o0_.city AS city_6,
  o0_.phone AS phone_7,
  o0_.credit_limit AS credit_limit_8,
  o0_.notes AS notes_9,
  o0_.domains AS domains_10,
  o0_.status AS status_11,
  o0_.created_by AS created_by_12,
  o0_.updated_by AS updated_by_13,
  o0_.deleted_date AS deleted_date_14,
  o0_.created_date AS created_date_15,
  o0_.updated_date AS updated_date_16,
  o0_.state_id AS state_id_17
FROM
  organization o0_
WHERE
  (o0_.deleted_date IS NULL)
ORDER BY
  o0_.name ASC

SELECT o0_.id AS id_0, o0_.require_review AS require_review_1, o0_.name AS name_2, o0_.email AS email_3, o0_.address AS address_4, o0_.zip_code AS zip_code_5, o0_.city AS city_6, o0_.phone AS phone_7, o0_.credit_limit AS credit_limit_8, o0_.notes AS notes_9, o0_.domains AS domains_10, o0_.status AS status_11, o0_.created_by AS created_by_12, o0_.updated_by AS updated_by_13, o0_.deleted_date AS deleted_date_14, o0_.created_date AS created_date_15, o0_.updated_date AS updated_date_16, o0_.state_id AS state_id_17 FROM organization o0_ WHERE (o0_.deleted_date IS NULL) ORDER BY o0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name AS name_2
FROM
  country c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2 FROM country c0_ ORDER BY c0_.name ASC;

SELECT
  count(u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN country c1_ ON u0_.country_id = c1_.id
  LEFT JOIN municipality m2_ ON u0_.municipality_id = m2_.id
  AND (m2_.deleted_date IS NULL)
  LEFT JOIN organization o3_ ON u0_.organization_id = o3_.id
  AND (o3_.deleted_date IS NULL)
WHERE
  (u0_.deleted_date IS NULL)

SELECT count(u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN country c1_ ON u0_.country_id = c1_.id LEFT JOIN municipality m2_ ON u0_.municipality_id = m2_.id AND (m2_.deleted_date IS NULL) LEFT JOIN organization o3_ ON u0_.organization_id = o3_.id AND (o3_.deleted_date IS NULL) WHERE (u0_.deleted_date IS NULL);

SELECT
  t0.id AS id_1,
  t0.require_review AS require_review_2,
  t0.name AS name_3,
  t0.email AS email_4,
  t0.address AS address_5,
  t0.zip_code AS zip_code_6,
  t0.city AS city_7,
  t0.phone AS phone_8,
  t0.credit_limit AS credit_limit_9,
  t0.notes AS notes_10,
  t0.domains AS domains_11,
  t0.status AS status_12,
  t0.created_by AS created_by_13,
  t0.updated_by AS updated_by_14,
  t0.deleted_date AS deleted_date_15,
  t0.created_date AS created_date_16,
  t0.updated_date AS updated_date_17,
  t0.state_id AS state_id_18
FROM
  organization t0
WHERE
  t0.name = ?
  AND (
    (t0.deleted_date IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.require_review AS require_review_2, t0.name AS name_3, t0.email AS email_4, t0.address AS address_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.phone AS phone_8, t0.credit_limit AS credit_limit_9, t0.notes AS notes_10, t0.domains AS domains_11, t0.status AS status_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.deleted_date AS deleted_date_15, t0.created_date AS created_date_16, t0.updated_date AS updated_date_17, t0.state_id AS state_id_18 FROM organization t0 WHERE t0.name = 'Other Registering Party (Organization)' AND ((t0.deleted_date IS NULL)) LIMIT 1;