Query Metrics
40
Database Queries
5
Different statements
55.49 ms
Query time
0
Invalid entities
20
Managed entities
Queries
microtechG2 connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.53 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.ZahlBed AS ZahlBed_20, t0.StatusKonstruktion AS StatusKonstruktion_21, t0.GPreisNt AS GPreisNt_22, t0.GPreisSt AS GPreisSt_23, t0.GPreisBt AS GPreisBt_24, t0.NachlBet AS NachlBet_25, t0.Bezahlt AS Bezahlt_26, t0.GebuchtKz AS GebuchtKz_27, t0.ErstDat AS ErstDat_28, t0.AendDat AS AendDat_29, t0.ErstBzr AS ErstBzr_30, t0.AendBzr AS AendBzr_31, t0.TblVorgang AS TblVorgang_32, t0.TblVorgangArchiv AS TblVorgangArchiv_33, t0.GspKz AS GspKz_34, t0.GspDat AS GspDat_35, t0.Waehr AS Waehr_36, t0.FrWFak AS FrWFak_37, t0.GRabNt AS GRabNt_38, t0.GRabBt AS GRabBt_39, t0.LiefDat AS LiefDat_40, t0.LiefBed AS LiefBed_41, t0.GRabSz AS GRabSz_42, t0.GspInfo AS GspInfo_43, t0.Memo AS Memo_44, t0.GemailtKz AS GemailtKz_45, t0.MemoDat AS MemoDat_46, t0.LiNa1 AS LiNa1_47, t0.LiNa2 AS LiNa2_48, t0.LiNa3 AS LiNa3_49, t0.LiStr AS LiStr_50, t0.LiPlz AS LiPlz_51, t0.LiOrt AS LiOrt_52, t0.LiLandBez AS LiLandBez_53, t0.LiEMail1 AS LiEMail1_54, t0.LiTel AS LiTel_55, t0.UStId AS UStId_56, t0.UStKat AS UStKat_57, t0.IklStKz AS IklStKz_58, t0.update_date AS update_date_59 FROM microtechBWO.Vorgang t0 WHERE t0.AuftrNr = ?
Parameters:
[
"AN22600038"
]
|
| 2 | 1.76 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.ZahlBed AS ZahlBed_20, t0.StatusKonstruktion AS StatusKonstruktion_21, t0.GPreisNt AS GPreisNt_22, t0.GPreisSt AS GPreisSt_23, t0.GPreisBt AS GPreisBt_24, t0.NachlBet AS NachlBet_25, t0.Bezahlt AS Bezahlt_26, t0.GebuchtKz AS GebuchtKz_27, t0.ErstDat AS ErstDat_28, t0.AendDat AS AendDat_29, t0.ErstBzr AS ErstBzr_30, t0.AendBzr AS AendBzr_31, t0.TblVorgang AS TblVorgang_32, t0.TblVorgangArchiv AS TblVorgangArchiv_33, t0.GspKz AS GspKz_34, t0.GspDat AS GspDat_35, t0.Waehr AS Waehr_36, t0.FrWFak AS FrWFak_37, t0.GRabNt AS GRabNt_38, t0.GRabBt AS GRabBt_39, t0.LiefDat AS LiefDat_40, t0.LiefBed AS LiefBed_41, t0.GRabSz AS GRabSz_42, t0.GspInfo AS GspInfo_43, t0.Memo AS Memo_44, t0.GemailtKz AS GemailtKz_45, t0.MemoDat AS MemoDat_46, t0.LiNa1 AS LiNa1_47, t0.LiNa2 AS LiNa2_48, t0.LiNa3 AS LiNa3_49, t0.LiStr AS LiStr_50, t0.LiPlz AS LiPlz_51, t0.LiOrt AS LiOrt_52, t0.LiLandBez AS LiLandBez_53, t0.LiEMail1 AS LiEMail1_54, t0.LiTel AS LiTel_55, t0.UStId AS UStId_56, t0.UStKat AS UStKat_57, t0.IklStKz AS IklStKz_58, t0.update_date AS update_date_59 FROM microtechBWO.Vorgang t0 WHERE t0.AuftrNr = ?
Parameters:
[
"AN22600276"
]
|
| 3 | 1.99 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.ZahlBed AS ZahlBed_20, t0.StatusKonstruktion AS StatusKonstruktion_21, t0.GPreisNt AS GPreisNt_22, t0.GPreisSt AS GPreisSt_23, t0.GPreisBt AS GPreisBt_24, t0.NachlBet AS NachlBet_25, t0.Bezahlt AS Bezahlt_26, t0.GebuchtKz AS GebuchtKz_27, t0.ErstDat AS ErstDat_28, t0.AendDat AS AendDat_29, t0.ErstBzr AS ErstBzr_30, t0.AendBzr AS AendBzr_31, t0.TblVorgang AS TblVorgang_32, t0.TblVorgangArchiv AS TblVorgangArchiv_33, t0.GspKz AS GspKz_34, t0.GspDat AS GspDat_35, t0.Waehr AS Waehr_36, t0.FrWFak AS FrWFak_37, t0.GRabNt AS GRabNt_38, t0.GRabBt AS GRabBt_39, t0.LiefDat AS LiefDat_40, t0.LiefBed AS LiefBed_41, t0.GRabSz AS GRabSz_42, t0.GspInfo AS GspInfo_43, t0.Memo AS Memo_44, t0.GemailtKz AS GemailtKz_45, t0.MemoDat AS MemoDat_46, t0.LiNa1 AS LiNa1_47, t0.LiNa2 AS LiNa2_48, t0.LiNa3 AS LiNa3_49, t0.LiStr AS LiStr_50, t0.LiPlz AS LiPlz_51, t0.LiOrt AS LiOrt_52, t0.LiLandBez AS LiLandBez_53, t0.LiEMail1 AS LiEMail1_54, t0.LiTel AS LiTel_55, t0.UStId AS UStId_56, t0.UStKat AS UStKat_57, t0.IklStKz AS IklStKz_58, t0.update_date AS update_date_59 FROM microtechBWO.Vorgang t0 WHERE t0.AuftrNr = ?
Parameters:
[
"AN22600668"
]
|
| 4 | 1.87 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.ZahlBed AS ZahlBed_20, t0.StatusKonstruktion AS StatusKonstruktion_21, t0.GPreisNt AS GPreisNt_22, t0.GPreisSt AS GPreisSt_23, t0.GPreisBt AS GPreisBt_24, t0.NachlBet AS NachlBet_25, t0.Bezahlt AS Bezahlt_26, t0.GebuchtKz AS GebuchtKz_27, t0.ErstDat AS ErstDat_28, t0.AendDat AS AendDat_29, t0.ErstBzr AS ErstBzr_30, t0.AendBzr AS AendBzr_31, t0.TblVorgang AS TblVorgang_32, t0.TblVorgangArchiv AS TblVorgangArchiv_33, t0.GspKz AS GspKz_34, t0.GspDat AS GspDat_35, t0.Waehr AS Waehr_36, t0.FrWFak AS FrWFak_37, t0.GRabNt AS GRabNt_38, t0.GRabBt AS GRabBt_39, t0.LiefDat AS LiefDat_40, t0.LiefBed AS LiefBed_41, t0.GRabSz AS GRabSz_42, t0.GspInfo AS GspInfo_43, t0.Memo AS Memo_44, t0.GemailtKz AS GemailtKz_45, t0.MemoDat AS MemoDat_46, t0.LiNa1 AS LiNa1_47, t0.LiNa2 AS LiNa2_48, t0.LiNa3 AS LiNa3_49, t0.LiStr AS LiStr_50, t0.LiPlz AS LiPlz_51, t0.LiOrt AS LiOrt_52, t0.LiLandBez AS LiLandBez_53, t0.LiEMail1 AS LiEMail1_54, t0.LiTel AS LiTel_55, t0.UStId AS UStId_56, t0.UStKat AS UStKat_57, t0.IklStKz AS IklStKz_58, t0.update_date AS update_date_59 FROM microtechBWO.Vorgang t0 WHERE t0.AuftrNr = ?
Parameters:
[
"AN22601037"
]
|
| 5 | 1.96 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.ZahlBed AS ZahlBed_20, t0.StatusKonstruktion AS StatusKonstruktion_21, t0.GPreisNt AS GPreisNt_22, t0.GPreisSt AS GPreisSt_23, t0.GPreisBt AS GPreisBt_24, t0.NachlBet AS NachlBet_25, t0.Bezahlt AS Bezahlt_26, t0.GebuchtKz AS GebuchtKz_27, t0.ErstDat AS ErstDat_28, t0.AendDat AS AendDat_29, t0.ErstBzr AS ErstBzr_30, t0.AendBzr AS AendBzr_31, t0.TblVorgang AS TblVorgang_32, t0.TblVorgangArchiv AS TblVorgangArchiv_33, t0.GspKz AS GspKz_34, t0.GspDat AS GspDat_35, t0.Waehr AS Waehr_36, t0.FrWFak AS FrWFak_37, t0.GRabNt AS GRabNt_38, t0.GRabBt AS GRabBt_39, t0.LiefDat AS LiefDat_40, t0.LiefBed AS LiefBed_41, t0.GRabSz AS GRabSz_42, t0.GspInfo AS GspInfo_43, t0.Memo AS Memo_44, t0.GemailtKz AS GemailtKz_45, t0.MemoDat AS MemoDat_46, t0.LiNa1 AS LiNa1_47, t0.LiNa2 AS LiNa2_48, t0.LiNa3 AS LiNa3_49, t0.LiStr AS LiStr_50, t0.LiPlz AS LiPlz_51, t0.LiOrt AS LiOrt_52, t0.LiLandBez AS LiLandBez_53, t0.LiEMail1 AS LiEMail1_54, t0.LiTel AS LiTel_55, t0.UStId AS UStId_56, t0.UStKat AS UStKat_57, t0.IklStKz AS IklStKz_58, t0.update_date AS update_date_59 FROM microtechBWO.Vorgang t0 WHERE t0.AuftrNr = ?
Parameters:
[
"AN22602827"
]
|
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\ApiGpPipelineLog | 10 |
| App\Entity\HubspotVorgangDealControl | 5 |
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 |
|---|
microtechG2_em entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\MicrotechG2\microtechG2\Vorgang | 5 |
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\HubspotVorgangDealControl | No errors. |
| App\Entity\ApiGpPipelineLog | No errors. |
wearefox_em entity manager
No loaded entities.
glasprofi_em entity manager
No loaded entities.
microtech_em entity manager
No loaded entities.
microtechG2_em entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\MicrotechG2\microtechG2\Vorgang | No errors. |
| App\Entity\MicrotechG2\microtechG2\Adressen | No errors. |