https://qa.pedido.viogp.com/plantilla/1009827/procesar

Query Metrics

4 Database Queries
4 Different statements
9.66 ms Query time
2 Invalid entities

Queries

Group similar statements

idempiere connection

# Time Info
1 4.52 ms
SELECT t0.ad_user_id AS ad_user_id_1, t0.ad_user_uu AS ad_user_uu_2, t0.ad_client_id AS ad_client_id_3, t0.isactive AS isactive_4, t0.created AS created_5, t0.createdby AS createdby_6, t0.updated AS updated_7, t0.updatedby AS updatedby_8, t0.name AS name_9, t0.description AS description_10, t0.password AS password_11, t0.email AS email_12, t0.phone AS phone_13, t0.birthday AS birthday_14, t0.salt AS salt_15, t0.islocked AS islocked_16, t0.dateaccountlocked AS dateaccountlocked_17, t0.failedlogincount AS failedlogincount_18, t0.datepasswordchanged AS datepasswordchanged_19, t0.datelastlogin AS datelastlogin_20, t0.isexpired AS isexpired_21, t0.securityquestion AS securityquestion_22, t0.answer AS answer_23, t0.c_bpartner_id AS c_bpartner_id_24, t0.c_bpartner_location_id AS c_bpartner_location_id_25, t0.c_activity_id AS c_activity_id_26, t0.salesrep_id AS salesrep_id_27, t0.c_bpartner_id AS c_bpartner_id_28, t0.c_bpartner_location_id AS c_bpartner_location_id_29, t0.c_activity_id AS c_activity_id_30, t31.sm_sales_rep_id AS sm_sales_rep_id_32, t31.c_bpartner_id AS c_bpartner_id_33, t31.salesrep_id AS salesrep_id_34, t31.isactive AS isactive_35, t31.c_bpartner_id AS c_bpartner_id_36, t31.salesrep_id AS salesrep_id_37 FROM ad_user t0 LEFT JOIN sm_sales_rep t31 ON t31.salesrep_id = t0.ad_user_id WHERE t0.ad_user_id = ?
Parameters:
[
  1000359
]
2 1.38 ms
SELECT t0.ad_role_id AS ad_role_id_1, t0.ad_window_id AS ad_window_id_2, t0.ad_window_access_uu AS ad_window_access_uu_3, t0.isactive AS isactive_4, t0.isreadwrite AS isreadwrite_5, t0.ad_window_id AS ad_window_id_6 FROM ad_window_access t0 WHERE t0.ad_window_id = ? AND t0.ad_role_id = ? LIMIT 1
Parameters:
[
  1000174
  1000089
]
3 1.91 ms
SELECT t0.ad_sequence_id AS ad_sequence_id_1, t0.ad_org_id AS ad_org_id_2, t0.isactive AS isactive_3, t0.name AS name_4, t0.currentnext AS currentnext_5, t0.incrementno AS incrementno_6, t0.isorglevelsequence AS isorglevelsequence_7, t0.prefix AS prefix_8 FROM ad_sequence t0 WHERE t0.name = ?
Parameters:
[
  "SM_SalesTemplate"
]
4 1.84 ms
SELECT t0.sm_salestemplate_id AS sm_salestemplate_id_1, t0.ad_client_id AS ad_client_id_2, t0.ad_org_id AS ad_org_id_3, t0.isactive AS isactive_4, t0.created AS created_5, t0.createdby AS createdby_6, t0.updated AS updated_7, t0.updatedby AS updatedby_8, t0.documentno AS documentno_9, t0.description AS description_10, t0.m_pricelist_id AS m_pricelist_id_11, t0.m_warehouse_id AS m_warehouse_id_12, t0.isapproved AS isapproved_13, t0.daterequired AS daterequired_14, t0.totallines AS totallines_15, t0.docaction AS docaction_16, t0.docstatus AS docstatus_17, t0.processed AS processed_18, t0.datedoc AS datedoc_19, t0.c_doctype_id AS c_doctype_id_20, t0.sm_salestemplate_uu AS sm_salestemplate_uu_21, t0.isapproved2 AS isapproved2_22, t0.c_bpartner_id AS c_bpartner_id_23, t0.c_bpartner_location_id AS c_bpartner_location_id_24, t0.salesrep_id AS salesrep_id_25, t0.sm_marca_id AS sm_marca_id_26, t0.isquatation AS isquatation_27, t0.c_paymentterm_id AS c_paymentterm_id_28, t0.sm_document_int AS sm_document_int_29, t0.isapproved3 AS isapproved3_30, t0.processing AS processing_31, t0.processedon AS processedon_32, t0.ad_user_id AS ad_user_id_33, t0.bill_location_id AS bill_location_id_34, t0.isfromweb AS isfromweb_35, t0.ad_org_id AS ad_org_id_36, t0.m_pricelist_id AS m_pricelist_id_37, t0.m_warehouse_id AS m_warehouse_id_38, t0.c_doctype_id AS c_doctype_id_39, t0.c_bpartner_id AS c_bpartner_id_40, t0.c_bpartner_location_id AS c_bpartner_location_id_41, t0.salesrep_id AS salesrep_id_42, t0.sm_marca_id AS sm_marca_id_43, t0.c_paymentterm_id AS c_paymentterm_id_44, t0.bill_location_id AS bill_location_id_45 FROM SM_SalesTemplate t0 WHERE t0.sm_salestemplate_id = ?
Parameters:
[
  "1009827"
]

Database Connections

Name Service
order doctrine.dbal.order_connection
idempiere doctrine.dbal.idempiere_connection

Entity Managers

Name Service
order doctrine.orm.order_entity_manager
idempiere doctrine.orm.idempiere_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

order entity manager

No loaded entities.

idempiere entity manager

Class Mapping errors
App\Entity\Idempiere\AdUser
  • The field App\Entity\Idempiere\AdUser#salesRep is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Idempiere\SmSalesRep#ad_user does not contain the required 'inversedBy="salesRep"' attribute.
App\Entity\Idempiere\CBpartner
  • The mappings App\Entity\Idempiere\CBpartner#address and App\Entity\Idempiere\CBpartnerLocation#c_bpartner are inconsistent with each other.
App\Entity\Idempiere\CBpartnerLocation No errors.
App\Entity\Idempiere\CActivity No errors.
App\Entity\Idempiere\SmSalesRep No errors.
App\Entity\Idempiere\AdUserRoles No errors.
App\Entity\Idempiere\AdUserOrgaccess No errors.
App\Entity\Idempiere\AdWindowAccess No errors.
App\Entity\Idempiere\AdWindow No errors.
App\Entity\Idempiere\SmSalestemplate No errors.
App\Entity\Idempiere\AdSequence No errors.
App\Entity\Idempiere\AdOrg No errors.
App\Entity\Idempiere\MPricelist No errors.
App\Entity\Idempiere\MWarehouse No errors.
App\Entity\Idempiere\CDoctype No errors.
App\Entity\Idempiere\SmMarca No errors.
App\Entity\Idempiere\CPaymentterm No errors.
App\Entity\Idempiere\SmSalestemplateline No errors.
App\Entity\Idempiere\COrder No errors.