Query Metrics

4 Database Queries
4 Different statements
23.25 ms Query time
0 Invalid entities
2 Managed entities

Grouped Statements

Show all queries

microtech connection

Time Count Info
9.39 ms
(40.38%)
1
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

Time Count Info
11.71 ms
(50.38%)
1
INSERT INTO api_panther_pipeline_log (deal_id, pg_auftr_nr, status, message) VALUES (?, ?, ?, ?)
Parameters:
[
  "493166293214"
  "AN42600461"
  "SUCCESS"
  "Ended with: Nothing to update."
]
2.03 ms
(8.72%)
1
"COMMIT"
Parameters:
[]
0.12 ms
(0.53%)
1
"START TRANSACTION"
Parameters:
[]

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.