Query Metrics

559 Database Queries
6 Different statements
812.46 ms Query time
0 Invalid entities
278 Managed entities

Grouped Statements

Show all queries

microtechG2 connection

Time Count Info
149.23 ms
(18.37%)
70
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:
[
  "AN2511786"
]

default connection

Time Count Info
368.02 ms
(45.30%)
140
"COMMIT"
Parameters:
[]
193.28 ms
(23.79%)
69
SELECT t0.id AS id_1, t0.deal_id AS deal_id_2, t0.pg_auftr_nr AS pg_auftr_nr_3, t0.date_first_looked_at AS date_first_looked_at_4, t0.gp_auftr_nr AS gp_auftr_nr_5 FROM hubspot_vorgang_deal_control t0 WHERE t0.deal_id = ? AND t0.gp_auftr_nr = ? LIMIT 1
Parameters:
[
  280737217780
  "AN2511786"
]
55.90 ms
(6.88%)
140
"START TRANSACTION"
Parameters:
[]
45.73 ms
(5.63%)
139
INSERT INTO api_gp_pipeline_log (deal_id, gp_auftr_nr, status, message) VALUES (?, ?, ?, ?)
Parameters:
[
  "280737217780"
  "AN2511786"
  "Info"
  "Deal is not older than 2 weeks."
]
0.29 ms
(0.04%)
1
INSERT INTO api_gp_call_log (hubspot_id, gp_auftr_nr, message, type, file, line) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  "443118416113"
  "AN22600333"
  "Kein Vorgang zur AN gefunden."
  "Error"
  "GPHubspotApiService.php"
  "39"
]

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 139
App\Entity\HubspotVorgangDealControl 69
App\Entity\ApiGpCallLog 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

microtechG2_em entity manager

Class Amount of managed objects
App\Entity\MicrotechG2\microtechG2\Vorgang 69

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\HubspotVorgangDealControl No errors.
App\Entity\ApiGpPipelineLog No errors.
App\Entity\ApiGpCallLog 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.