Query Metrics
4
Database Queries
4
Different statements
9.66 ms
Query time
2
Invalid entities
Queries
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 |
|
| App\Entity\Idempiere\CBpartner |
|
| 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. |