Query Metrics
3
Database Queries
2
Different statements
1.90 ms
Query time
0
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.37 ms (72.23%) |
2 |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.taxdown_id AS taxdown_id_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.nif AS nif_7, t0.birth_date AS birth_date_8, t0.nationality AS nationality_9, t0.mobile AS mobile_10, t0.email AS email_11, t0.id_cliente_sefide AS id_cliente_sefide_12, t0.updated_at AS updated_at_13, t0.sso_id AS sso_id_14, t0.sso_metadata AS sso_metadata_15, t0.created_at AS created_at_16, t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_17, t18.naturaleza_juridica AS naturaleza_juridica_19, t18.situacion_juridica AS situacion_juridica_20, t18.cnae AS cnae_21, t18.iae AS iae_22, t18.inscrita_en AS inscrita_en_23, t18.num_inscripcion_registral AS num_inscripcion_registral_24, t18.fec_inscripcion_registral AS fec_inscripcion_registral_25, t18.nivel_rrpp AS nivel_rrpp_26, t18.nivel_ingresos AS nivel_ingresos_27, t18.volumen_ventas AS volumen_ventas_28, t18.objeto_social AS objeto_social_29, t18.numero_sucursales AS numero_sucursales_30, t18.paises_donde_opera AS paises_donde_opera_31, t18.created_at AS created_at_32, t18.updated_at AS updated_at_33, t18.id AS id_34, t18.skip_inform_to_tax_down AS skip_inform_to_tax_down_35, t18.applicant_id AS applicant_id_36 FROM applicant t0 LEFT JOIN legal_entity t18 ON t18.applicant_id = t0.id WHERE t0.id = ?
Parameters:
[
"biotech3d-2024"
]
|
||||||||||||||||||||||||||||||||||
|
0.53 ms (27.77%) |
1 |
SELECT t0.id AS id_1, t0.taxdown_id AS taxdown_id_2, t0.timestamp AS timestamp_3, t0.user_ip AS user_ip_4, t0.occupation AS occupation_5, t0.bank_account_iban_user AS bank_account_iban_user_6, t0.income_tax_draft AS income_tax_draft_7, t0.income_tax_draft_final AS income_tax_draft_final_8, t0.tax_debt_certificate AS tax_debt_certificate_9, t0.tax_return_file AS tax_return_file_10, t0.requested_money AS requested_money_11, t0.returned_money_hacienda AS returned_money_hacienda_12, t0.wallet_available_money AS wallet_available_money_13, t0.incidence_details AS incidence_details_14, t0.hard_custom_incidence_details AS hard_custom_incidence_details_15, t0.hard_custom_incidence_comments AS hard_custom_incidence_comments_16, t0.soft_custom_incidence_details AS soft_custom_incidence_details_17, t0.is_record_account_canceled AS is_record_account_canceled_18, t0.sms_validation_trigger AS sms_validation_trigger_19, t0.video_trigger AS video_trigger_20, t0.emoney_account_creation_trigger AS emoney_account_creation_trigger_21, t0.contract_trigger AS contract_trigger_22, t0.document_submission_trigger AS document_submission_trigger_23, t0.documento_esa_id AS documento_esa_id_24, t0.sms_validation_otp_code AS sms_validation_otp_code_25, t0.nivel_ingresos AS nivel_ingresos_26, t0.pais_residencia AS pais_residencia_27, t0.via AS via_28, t0.numero AS numero_29, t0.codigo_postal AS codigo_postal_30, t0.localidad AS localidad_31, t0.postal AS postal_32, t0.residencia AS residencia_33, t0.fiscal AS fiscal_34, t0.date_money_lend AS date_money_lend_35, t0.date_money_charge AS date_money_charge_36, t0.id_operacion AS id_operacion_37, t0.contract_is_confirmed AS contract_is_confirmed_38, t0.sms_validation_is_confirmed AS sms_validation_is_confirmed_39, t0.video_is_confirmed AS video_is_confirmed_40, t0.id_documento AS id_documento_41, t0.id_wallet AS id_wallet_42, t0.wallet_status AS wallet_status_43, t0.video_status AS video_status_44, t0.bank_account_iban_sefide AS bank_account_iban_sefide_45, t0.kyc_level AS kyc_level_46, t0.contract_signed AS contract_signed_47, t0.contract_signing_date AS contract_signing_date_48, t0.advance_payment_status AS advance_payment_status_49, t0.tax_office_payment_received AS tax_office_payment_received_50, t0.incidence_existence AS incidence_existence_51, t0.operation_finished AS operation_finished_52, t0.sefide_contract_url AS sefide_contract_url_53, t0.sefide_video_url AS sefide_video_url_54, t0.id_documento_fcl AS id_documento_fcl_55, t0.operation_status AS operation_status_56, t0.signed_contract_date AS signed_contract_date_57, t0.is_taxdown_ok AS is_taxdown_ok_58, t0.alias AS alias_59, t0.created_at AS created_at_60, t0.updated_at AS updated_at_61, t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_62, t0.applicant_id AS applicant_id_63 FROM record t0 WHERE t0.applicant_id = ?
Parameters:
[
"biotech3d-2024"
]
|
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\Applicant | 2 |
| App\Entity\Record | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Applicant | No errors. |
| App\Entity\LegalEntity | No errors. |
| App\Entity\Record | No errors. |
| App\Entity\ScheduledOperation | No errors. |
| App\Entity\Beneficiario | No errors. |