Query Metrics
4
Database Queries
4
Different statements
23.25 ms
Query time
0
Invalid entities
2
Managed entities
Queries
microtech connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 9.39 ms |
SELECT t0.Art AS Art_1, t0.AdrNr AS AdrNr_2, t0.AuftrNr AS AuftrNr_3, t0.BelegNr AS BelegNr_4, t0.BelegNrVon AS BelegNrVon_5, t0.BelegNrVonStatus AS BelegNrVonStatus_6, t0.StorniertKz AS StorniertKz_7, t0.Dat AS Dat_8, t0.Verk AS Verk_9, t0.VsdArt AS VsdArt_10, t0.ReNa1 AS ReNa1_11, t0.ReNa2 AS ReNa2_12, t0.ReNa3 AS ReNa3_13, t0.ReOrt AS ReOrt_14, t0.RePlz AS RePlz_15, t0.ReStr AS ReStr_16, t0.ReLandBez AS ReLandBez_17, t0.ReEMail1 AS ReEMail1_18, t0.ReTel AS ReTel_19, t0.LiNa1 AS LiNa1_20, t0.LiNa2 AS LiNa2_21, t0.LiNa3 AS LiNa3_22, t0.LiStr AS LiStr_23, t0.LiPlz AS LiPlz_24, t0.LiOrt AS LiOrt_25, t0.LiLandBez AS LiLandBez_26, t0.LiEMail1 AS LiEMail1_27, t0.LiTel AS LiTel_28, t0.ZahlBed AS ZahlBed_29, t0.StatusKonstruktion AS StatusKonstruktion_30, t0.GPreisNt AS GPreisNt_31, t0.GPreisSt AS GPreisSt_32, t0.GPreisBt AS GPreisBt_33, t0.GebuchtKz AS GebuchtKz_34, t0.ErstDat AS ErstDat_35, t0.AendDat AS AendDat_36, t0.ErstBzr AS ErstBzr_37, t0.AendBzr AS AendBzr_38, t0.TblVorgang AS TblVorgang_39, t0.TblVorgangArchiv AS TblVorgangArchiv_40, t0.GspKz AS GspKz_41, t0.GspDat AS GspDat_42, t0.Waehr AS Waehr_43, t0.FrWFak AS FrWFak_44, t0.GRabNt AS GRabNt_45, t0.GRabBt AS GRabBt_46, t0.LiefDat AS LiefDat_47, t0.GRabSz AS GRabSz_48, t0.GspInfo AS GspInfo_49, t0.Memo AS Memo_50, t0.GemailtKz AS GemailtKz_51, t0.lieferdatum_glas AS lieferdatum_glas_52, t0.lieferdatum_fremdfertigung AS lieferdatum_fremdfertigung_53, t0.lieferdatum_auftragsvorbereitung AS lieferdatum_auftragsvorbereitung_54, t0.lieferdatum_beschichtung AS lieferdatum_beschichtung_55, t0.lieferdatum_kunde AS lieferdatum_kunde_56, t0.GlasBestellt AS GlasBestellt_57, t0.GlasEingegangen AS GlasEingegangen_58, t0.hubspot_id AS hubspot_id_59, t0.Versanddatum AS Versanddatum_60, t0.Sendungsnummer AS Sendungsnummer_61, t0.Spedition AS Spedition_62, t0.AbwTelSpedition AS AbwTelSpedition_63 FROM Vorgang t0 WHERE t0.AuftrNr = ? AND t0.Art = ?
Parameters:
[ "AN42600461" 231 ] |
default connection
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| wearefox | doctrine.dbal.wearefox_connection |
| glasprofi | doctrine.dbal.glasprofi_connection |
| microtech | doctrine.dbal.microtech_connection |
| microtechG2 | doctrine.dbal.microtechG2_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| wearefox_em | doctrine.orm.wearefox_em_entity_manager |
| glasprofi_em | doctrine.orm.glasprofi_em_entity_manager |
| microtech_em | doctrine.orm.microtech_em_entity_manager |
| microtechG2_em | doctrine.orm.microtechG2_em_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\ApiPantherPipelineLog | 1 |
wearefox_em entity manager
| Class | Amount of managed objects |
|---|
glasprofi_em entity manager
| Class | Amount of managed objects |
|---|
microtech_em entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Microtech\microtechP2\Vorgang | 1 |
microtechG2_em entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\ApiPantherPipelineLog | No errors. |
wearefox_em entity manager
No loaded entities.
glasprofi_em entity manager
No loaded entities.
microtech_em entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Microtech\microtechP2\Vorgang | No errors. |
| App\Entity\Microtech\microtechP2\Adressen | No errors. |
microtechG2_em entity manager
No loaded entities.