GET https://church.agapps.com.br/

Query Metrics

14 Database Queries
11 Different statements
16.67 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

#▲ Time Info
1 3.17 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.active AS active_6, t0.church_id AS church_id_7, t0.member_id AS member_id_8 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  6
]
2 2.06 ms
SELECT COALESCE(SUM(t0_.amount), 0) AS sclr_0 FROM transaction t0_ WHERE (t0_.direction = ? AND (t0_.occurred_at BETWEEN ? AND ?)) AND (t0_.church_id = '1')
Parameters:
[
  "entrada"
  "2026-10-01 00:00:00"
  "2026-10-31 23:59:00"
]
3 1.36 ms
SELECT COALESCE(SUM(t0_.amount), 0) AS sclr_0 FROM transaction t0_ WHERE (t0_.direction = ? AND (t0_.occurred_at BETWEEN ? AND ?)) AND (t0_.church_id = '1')
Parameters:
[
  "saida"
  "2026-10-01 00:00:00"
  "2026-10-31 23:59:00"
]
4 0.69 ms
SELECT COUNT(m0_.id) AS sclr_0 FROM member m0_ WHERE (m0_.status = ?) AND (m0_.church_id = '1')
Parameters:
[
  "ativo"
]
5 0.64 ms
SELECT COUNT(m0_.id) AS sclr_0 FROM member m0_ WHERE (m0_.status = ?) AND (m0_.church_id = '1')
Parameters:
[
  "inativo"
]
6 1.19 ms
SELECT m0_.id AS id_0, m0_.full_name AS full_name_1, m0_.cpf AS cpf_2, m0_.rg AS rg_3, m0_.birth_date AS birth_date_4, m0_.gender AS gender_5, m0_.marital_status AS marital_status_6, m0_.phone AS phone_7, m0_.email AS email_8, m0_.address AS address_9, m0_.baptism_date AS baptism_date_10, m0_.membership_date AS membership_date_11, m0_.entry_type AS entry_type_12, m0_.church_role AS church_role_13, m0_.status AS status_14, m0_.photo_path AS photo_path_15, m0_.documents AS documents_16, m0_.notes AS notes_17, m0_.created_at AS created_at_18, m0_.church_id AS church_id_19 FROM member m0_ WHERE (EXTRACT(MONTH FROM m0_.birth_date) = ?) AND (m0_.church_id = '1') ORDER BY m0_.birth_date ASC
Parameters:
[
  10
]
7 1.59 ms
SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.title AS title_2, s0_.scheduled_at AS scheduled_at_3, s0_.location AS location_4, s0_.notes AS notes_5, s0_.church_id AS church_id_6 FROM schedule s0_ WHERE (s0_.scheduled_at >= ?) AND (s0_.church_id = '1') ORDER BY s0_.scheduled_at ASC LIMIT 8
Parameters:
[
  "2026-10-28 00:00:00"
]
8 1.03 ms
SELECT COALESCE(SUM(t0_.amount), 0) AS sclr_0 FROM transaction t0_ WHERE (t0_.kind = ? AND (t0_.occurred_at BETWEEN ? AND ?)) AND (t0_.church_id = '1')
Parameters:
[
  "dizimo"
  "2026-10-01 00:00:00"
  "2026-10-31 23:59:00"
]
9 1.23 ms
SELECT COALESCE(SUM(t0_.amount), 0) AS sclr_0 FROM transaction t0_ WHERE (t0_.kind = ? AND (t0_.occurred_at BETWEEN ? AND ?)) AND (t0_.church_id = '1')
Parameters:
[
  "oferta"
  "2026-10-01 00:00:00"
  "2026-10-31 23:59:00"
]
10 1.02 ms
SELECT EXTRACT(MONTH FROM t0_.occurred_at) AS sclr_0, t0_.direction AS direction_1, SUM(t0_.amount) AS sclr_2 FROM transaction t0_ WHERE (EXTRACT(YEAR FROM t0_.occurred_at) = ?) AND (t0_.church_id = '1') GROUP BY sclr_0, t0_.direction
Parameters:
[
  2026
]
11 0.67 ms
SELECT t0_.kind AS kind_0, SUM(t0_.amount) AS sclr_1 FROM transaction t0_ WHERE ((t0_.occurred_at BETWEEN ? AND ?) AND t0_.direction = ?) AND (t0_.church_id = '1') GROUP BY t0_.kind
Parameters:
[
  "2026-10-01 00:00:00"
  "2026-10-31 23:59:00"
  "entrada"
]
12 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.cnpj AS cnpj_4, t0.phone AS phone_5, t0.email AS email_6, t0.address AS address_7, t0.plan AS plan_8, t0.active AS active_9, t0.created_at AS created_at_10 FROM church t0 WHERE t0.id = ?
Parameters:
[
  1
]
13 0.77 ms
SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE (n0_.user_id = ? AND n0_.is_read = 0) AND (n0_.church_id = '1')
Parameters:
[
  6
]
14 0.70 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.message AS message_2, n0_.icon AS icon_3, n0_.link AS link_4, n0_.is_read AS is_read_5, n0_.created_at AS created_at_6, n0_.user_id AS user_id_7, n0_.church_id AS church_id_8 FROM notification n0_ WHERE (n0_.user_id = ?) AND (n0_.church_id = '1') ORDER BY n0_.created_at DESC LIMIT 8
Parameters:
[
  6
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 1
App\Entity\Church 1
App\Entity\Member 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Church No errors.
App\Entity\Member No errors.
App\Entity\Transaction No errors.
App\Entity\Schedule No errors.
App\Entity\Notification No errors.