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

Query Metrics

8 Database Queries
8 Different statements
2.71 ms Query time
0 Invalid entities
64 Managed entities

Queries

Group similar statements

# Time Info
1 0.46 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:
[
  51
]
2 0.40 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.bni_group_id = ? AND t0.status = ? LIMIT 1
Parameters:
[
  1
  "OPEN"
]
3 0.31 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.type AS type_3, t0.business_closed AS business_closed_4, t0.referrals_given AS referrals_given_5, t0.guest_name AS guest_name_6, t0.guest_company AS guest_company_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.user_id AS user_id_11, t0.meeting_id AS meeting_id_12, t0.invited_by_id AS invited_by_id_13 FROM attendance t0 WHERE t0.user_id = ? AND t0.meeting_id = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
  51
  1
]
4 0.13 ms
"START TRANSACTION"
Parameters:
[]
5 0.29 ms
INSERT INTO attendance (status, type, business_closed, referrals_given, guest_name, guest_company, created_at, updated_at, deleted_at, user_id, meeting_id, invited_by_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "LATE"
  "MEMBER"
  "0.00"
  0
  null
  null
  "2026-03-18 07:45:50"
  null
  null
  51
  1
  null
]
6 0.13 ms
"COMMIT"
Parameters:
[]
7 0.52 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nombre AS nombre_4, u0_.apaterno AS apaterno_5, u0_.amaterno AS amaterno_6, u0_.email AS email_7, u0_.created_at AS created_at_8, u0_.updated_at AS updated_at_9, u0_.deleted_at AS deleted_at_10, u0_.specialty AS specialty_11, u0_.company AS company_12, u0_.phone AS phone_13, u0_.sphere_id AS sphere_id_14, u0_.bni_group_id AS bni_group_id_15 FROM `user` u0_ WHERE u0_.deleted_at IS NULL AND u0_.sphere_id = ? AND u0_.id <> ? ORDER BY u0_.nombre ASC
Parameters:
[
  11
  51
]
8 0.46 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nombre AS nombre_4, u0_.apaterno AS apaterno_5, u0_.amaterno AS amaterno_6, u0_.email AS email_7, u0_.created_at AS created_at_8, u0_.updated_at AS updated_at_9, u0_.deleted_at AS deleted_at_10, u0_.specialty AS specialty_11, u0_.company AS company_12, u0_.phone AS phone_13, u0_.sphere_id AS sphere_id_14, u0_.bni_group_id AS bni_group_id_15 FROM `user` u0_ WHERE u0_.deleted_at IS NULL AND u0_.bni_group_id = ? ORDER BY u0_.nombre ASC
Parameters:
[
  1
]

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 52
App\Entity\Sphere 9
App\Entity\BniGroup 1
App\Entity\Meeting 1
App\Entity\Attendance 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.