Query Metrics
9
Database Queries
7
Different statements
11.53 ms
Query time
4
Invalid entities
29
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
3.22 ms (27.90%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.user_name AS user_name_6, t0.user_lastname AS user_lastname_7, t0.title AS title_8, t0.configurations AS configurations_9, t0.status AS status_10, t0.medical_registration AS medical_registration_11, t0.phone AS phone_12, t0.signature AS signature_13, t0.profile_picture AS profile_picture_14, t0.user_address AS user_address_15, t0.group_roles AS group_roles_16, t0.signature_specialty AS signature_specialty_17, t0.num_document AS num_document_18, t0.code AS code_19, t0.autovalidator AS autovalidator_20, t0.session_token AS session_token_21, t0.nusa_user_id AS nusa_user_id_22, t0.nusa_application_name AS nusa_application_name_23, t0.nusa_language AS nusa_language_24, t0.nusa_topic AS nusa_topic_25, t0.document_type_id AS document_type_id_26 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"api_user@novaimaging.co"
]
|
|
3.10 ms (26.86%) |
2 |
"COMMIT"
Parameters:
[] |
|
1.49 ms (12.92%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2, d0_.acronym AS acronym_3, d0_.created_at AS created_at_4, d0_.status AS status_5, d0_.company_id AS company_id_6 FROM document_type d0_ WHERE d0_.company_id = ? OR d0_.company_id IS NULL ORDER BY d0_.created_at ASC
Parameters:
[ Symfony\Component\Uid\UuidV7 {#1225 : "01899e1e-21a0-7304-a426-5bd029b560d1" } ] |
|
1.11 ms (9.60%) |
1 |
INSERT INTO client_info (id, ip, browser, browser_version, os, user_agent, type_registration, created_at, owner_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "019b6de7-ea23-7a8a-8831-89d2367df93a" "34.125.173.201" "Symfony" "HttpClient" null "Symfony HttpClient (Curl)" "Inicio de session" "2025-12-30 06:17:53" "71000f8c-8a05-4e66-b0ed-a1e0bc33c963" ] |
|
1.00 ms (8.65%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.address AS address_4, t0.created_at AS created_at_5, t0.status AS status_6, t0.configurations AS configurations_7 FROM company t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"00000000"
]
|
|
0.92 ms (8.02%) |
1 |
UPDATE users SET session_token = ? WHERE id = ?
Parameters:
[ "077a07a814e4590268ff078c38bce04889cecd6089b90913ebf02edf97eba655" "71000f8c-8a05-4e66-b0ed-a1e0bc33c963" ] |
|
0.70 ms (6.04%) |
2 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| customer | doctrine.dbal.customer_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| customer | doctrine.orm.customer_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\DocumentType | 26 |
| App\Entity\Users | 1 |
| App\Entity\ClientInfo | 1 |
| App\Entity\Company | 1 |
customer entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Users |
|
| App\Entity\DocumentType | No errors. |
| App\Entity\Company |
|
| App\Entity\Specialty | No errors. |
| App\Entity\BodyPart | No errors. |
| App\Entity\PasswordRecovery | No errors. |
| App\Entity\Logs | No errors. |
| App\Entity\Site | No errors. |
| App\Entity\Solicitude |
|
| App\Entity\WorkFlow | No errors. |
| App\Entity\Forms | No errors. |
| App\Entity\Records | No errors. |
| App\Entity\EnterpriseWorkflow | No errors. |
| App\Entity\EvidenceDocument | No errors. |
| App\Entity\SurveyData | No errors. |
| App\Entity\StructuredTemplates | No errors. |
| App\Entity\ClientInfo | No errors. |
| App\Entity\AccessLink | No errors. |
| App\Entity\Modality | No errors. |
| App\Entity\Procedure | No errors. |
| App\Entity\FormVariables | No errors. |
| App\Entity\EvidenceType | No errors. |
| App\Entity\Indication | No errors. |
| App\Entity\Patient |
|
| App\Entity\ReferralPhysician | No errors. |
| App\Entity\Worksheet | No errors. |
| App\Entity\Cie10 | No errors. |
| App\Entity\Equipment | No errors. |
| App\Entity\Insurance | No errors. |
| App\Entity\Agreement | No errors. |
| App\Entity\BiologicalSex | No errors. |
| App\Entity\BloodType | No errors. |
| App\Entity\City | No errors. |
| App\Entity\EthnicGroup | No errors. |
| App\Entity\MaritalStatus | No errors. |
| App\Entity\Ocupation | No errors. |
| App\Entity\ResidencialZone | No errors. |
| App\Entity\Origin | No errors. |
| App\Entity\Afiliation | No errors. |
| App\Entity\BookingGroup | No errors. |
| App\Entity\Reason | No errors. |
| App\Entity\Diagnostic | No errors. |
| App\Entity\Purpose | No errors. |
| App\Entity\Orientation | No errors. |
| App\Entity\Priority | No errors. |
| App\Entity\CancelationReason | No errors. |
| App\Entity\Survey | No errors. |
| App\Entity\RejectReason | No errors. |
| App\Entity\ProcedureCode | No errors. |
customer entity manager
No loaded entities.