GET http://demo.novaimaging.co/api/v1/types-document/obtain/00000000

Query Metrics

9 Database Queries
7 Different statements
10.90 ms Query time
4 Invalid entities
29 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 2.78 ms
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"
]
2 0.36 ms
"START TRANSACTION"
Parameters:
[]
3 0.91 ms
UPDATE users SET session_token = ? WHERE id = ?
Parameters:
[
  "7699eb10ab8ad33050bf6b552980209fdc6c0d3193107c435628e9e787751b5e"
  "71000f8c-8a05-4e66-b0ed-a1e0bc33c963"
]
4 1.58 ms
"COMMIT"
Parameters:
[]
5 0.30 ms
"START TRANSACTION"
Parameters:
[]
6 1.08 ms
INSERT INTO client_info (id, ip, browser, browser_version, os, user_agent, type_registration, created_at, owner_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "019b6de8-bb58-7d01-82e2-6a88f90fd244"
  "34.125.173.201"
  "Symfony"
  "HttpClient"
  null
  "Symfony HttpClient (Curl)"
  "Inicio de session"
  "2025-12-30 06:18:47"
  "71000f8c-8a05-4e66-b0ed-a1e0bc33c963"
]
7 1.45 ms
"COMMIT"
Parameters:
[]
8 1.09 ms
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"
]
9 1.37 ms
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
    __toString(): "01899e1e-21a0-7304-a426-5bd029b560d1"
  }
]

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
  • The field App\Entity\Users#usersAuthorized is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Users#usersAuthorized does not contain the required 'mappedBy="usersAuthorized"' attribute.
  • The association App\Entity\Users#accessLinks refers to the owning side field App\Entity\AccessLink#owner which does not exist.
App\Entity\DocumentType No errors.
App\Entity\Company
  • The mappings App\Entity\Company#patients and App\Entity\Patient#company are inconsistent with each other.
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
  • The mappings App\Entity\Solicitude#agreement and App\Entity\Agreement#solicitudes are inconsistent with each other.
  • The mappings App\Entity\Solicitude#insurance and App\Entity\Insurance#solicitudes are inconsistent with each other.
  • The mappings App\Entity\Solicitude#DiagnosisOut and App\Entity\Cie10#solicitudes are inconsistent with each other.
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
  • The association App\Entity\Patient#company refers to the inverse side field App\Entity\Company#patient which does not exist.
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.