GET https://bni-asistencia.capacitacioninformatica.com/attendance

Query Metrics

43 Database Queries
6 Different statements
9.84 ms Query time
0 Invalid entities
44 Managed entities

Queries

Group similar statements

# Time Info
1 0.74 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  54
]
2 0.62 ms
SELECT a0_.id AS id_0, a0_.status AS status_1, a0_.type AS type_2, a0_.business_closed AS business_closed_3, a0_.referrals_given AS referrals_given_4, a0_.guest_name AS guest_name_5, a0_.guest_company AS guest_company_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.deleted_at AS deleted_at_9, a0_.user_id AS user_id_10, a0_.meeting_id AS meeting_id_11, a0_.invited_by_id AS invited_by_id_12 FROM attendance a0_ INNER JOIN meeting m1_ ON a0_.meeting_id = m1_.id WHERE (m1_.date BETWEEN ? AND ?) AND a0_.deleted_at IS NULL AND m1_.bni_group_id = ? ORDER BY m1_.date DESC
Parameters:
[
  "2026-03-01"
  "2026-03-31"
  1
]
3 0.34 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  12
]
4 0.28 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  12
]
5 0.22 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  1
]
6 0.19 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  1
]
7 0.23 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  6
]
8 0.19 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  6
]
9 0.20 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  11
]
10 0.19 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  11
]
11 0.22 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  5
]
12 0.22 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  5
]
13 0.23 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  10
]
14 0.22 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  10
]
15 0.21 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  4
]
16 0.22 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  4
]
17 0.23 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  9
]
18 0.22 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  9
]
19 0.21 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  3
]
20 0.19 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  3
]
21 0.19 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  8
]
22 0.19 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  8
]
23 0.19 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  13
]
24 0.18 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  13
]
25 0.20 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  2
]
26 0.19 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  2
]
27 0.21 ms
SELECT t0.id AS id_1, t0.contact_name AS contact_name_2, t0.contact_phone AS contact_phone_3, t0.description AS description_4, t0.referred_user_id AS referred_user_id_5, t0.attendance_id AS attendance_id_6 FROM reference t0 WHERE t0.attendance_id = ?
Parameters:
[
  7
]
28 0.19 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.description AS description_3, t0.attendance_id AS attendance_id_4, t0.received_by_id AS received_by_id_5 FROM business_done t0 WHERE t0.attendance_id = ?
Parameters:
[
  7
]
29 0.30 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5 FROM bni_group t0 WHERE t0.id = ?
Parameters:
[
  1
]
30 0.21 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  27
]
31 0.20 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.qr_token AS qr_token_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.start_time AS start_time_8, t0.bni_group_id AS bni_group_id_9 FROM meeting t0 WHERE t0.id = ?
Parameters:
[
  1
]
32 0.19 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  44
]
33 0.20 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  13
]
34 0.19 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  37
]
35 0.20 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  40
]
36 0.19 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  4
]
37 0.16 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  19
]
38 0.15 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  8
]
39 0.20 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  50
]
40 0.19 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  39
]
41 0.19 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  23
]
42 0.20 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  36
]
43 0.19 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.apaterno AS apaterno_6, t0.amaterno AS amaterno_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.specialty AS specialty_12, t0.company AS company_13, t0.phone AS phone_14, t0.sphere_id AS sphere_id_15, t0.bni_group_id AS bni_group_id_16 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  46
]

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 16
App\Entity\Attendance 13
App\Entity\Sphere 7
App\Entity\Reference 3
App\Entity\BusinessDone 3
App\Entity\BniGroup 1
App\Entity\Meeting 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Sphere No errors.
App\Entity\BniGroup No errors.
App\Entity\Attendance No errors.
App\Entity\Meeting No errors.
App\Entity\Reference No errors.
App\Entity\BusinessDone No errors.