Redirect 302 redirect from POST @app_login (ff4830)

Query Metrics

7 Database Queries
7 Different statements
2.26 ms Query time
0 Invalid entities
64 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.41 ms
(18.24%)
1
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
]
0.37 ms
(16.39%)
1
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
]
0.35 ms
(15.64%)
1
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
]
0.33 ms
(14.74%)
1
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:
[
  6
  27
]
0.31 ms
(13.51%)
1
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:
[
  27
  1
]
0.26 ms
(11.30%)
1
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.qr_token = ? AND t0.status = ? LIMIT 1
Parameters:
[
  "1cf31d0bf388a0bf3d1a6c3d467664"
  "OPEN"
]
0.23 ms
(10.19%)
1
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
]

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.