Query Metrics

7 Database Queries
6 Different statements
0.85 ms Query time
0 Invalid entities
22 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.26 ms
(29.96%)
1
SELECT p0_.kod AS kod_0, p0_.varsymb AS varsymb_1, p0_.farico AS farico_2, p0_.okr AS okr_3, p0_.dek AS dek_4, p0_.d01 AS d01_5, p0_.farnost AS farnost_6, p0_.prevod AS prevod_7, p0_.prispevek AS prispevek_8, p0_.uhrazeno AS uhrazeno_9, p0_.status AS status_10, p0_.pocetplaticich AS pocetplaticich_11, p0_.pocetplaticich2020 AS pocetplaticich2020_12, p0_.email AS email_13, p0_.mailingresult AS mailingresult_14, p0_.fotobanner AS fotobanner_15, p0_.fotohlavni AS fotohlavni_16, p0_.fotodetail AS fotodetail_17, p0_.farar AS farar_18, p0_.funkce AS funkce_19 FROM puls_farnosti p0_ WHERE p0_.farico IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.farnost ASC
Parameters:
[
  45215405
  64125637
  66185157
  64125777
  48430226
  48808041
  47861177
  48808032
  66185165
  64125645
  49590944
  64095592
  69987211
  48426458
  48426440
  48003581
  66185092
  47810378
  45239894
  66182310
]
0.24 ms
(28.54%)
1
SELECT DISTINCT p0_.farico AS farico_0, p0_.farnost AS farnost_1 FROM puls_farnosti p0_ ORDER BY p0_.farnost ASC LIMIT 20
Parameters:
[]
0.20 ms
(23.74%)
2
SELECT t0.dek AS dek_1, t0.dekanstvi AS dekanstvi_2 FROM puls_dekanstvi t0
Parameters:
[]
0.07 ms
(7.73%)
1
SELECT t0.iduser AS iduser_1, t0.idprogram AS idprogram_2, t0.typ AS typ_3, t0.status AS status_4, t0.souhlasou AS souhlasou_5, t0.castka AS castka_6, t0.datumsouhlasu AS datumsouhlasu_7, t0.ipadresa AS ipadresa_8, t0.varsymb AS varsymb_9, t0.specsymb AS specsymb_10, t0.farnost AS farnost_11, t0.jmeno AS jmeno_12, t0.prijmeni AS prijmeni_13, t0.Email AS Email_14, t0.telefon AS telefon_15, t0.PWDHash AS PWDHash_16, t0.firma AS firma_17, t0.ic AS ic_18, t0.ulice AS ulice_19, t0.mesto AS mesto_20, t0.psc AS psc_21, t0.korespjinaadresa AS korespjinaadresa_22, t0.korespulice AS korespulice_23, t0.korespmesto AS korespmesto_24, t0.koresppsc AS koresppsc_25, t0.rc AS rc_26, t0.pocetosobrodina AS pocetosobrodina_27, t0.pomoc AS pomoc_28, t0.guid AS guid_29, t0.popis AS popis_30, t0.aktualizovano AS aktualizovano_31, t0.pravnistatus AS pravnistatus_32, t0.cislokarty AS cislokarty_33, t0.skupina AS skupina_34, t0.datumodbaveni AS datumodbaveni_35, t0.role AS role_36, t0.mailingresult AS mailingresult_37, t0.mailingresultspiritual AS mailingresultspiritual_38, t0.sipo AS sipo_39, t0.sipocastka AS sipocastka_40, t0.zaslatslozenku AS zaslatslozenku_41, t0.parameters AS parameters_42, t0.apicheck AS apicheck_43, t0.flags AS flags_44, t0.bez_farnosti AS bez_farnosti_45, t0.muz2_zena1 AS muz2_zena1_46, t0.jmeno_koresp_rodina AS jmeno_koresp_rodina_47, t0.id_kontaktni_osoba AS id_kontaktni_osoba_48, t0.is_sms_auth_enabled AS is_sms_auth_enabled_49, t0.sms_auth_recipient AS sms_auth_recipient_50, t0.sms_auth_code AS sms_auth_code_51, t0.sms_auth_code_expires_at AS sms_auth_code_expires_at_52 FROM puls_users t0 WHERE t0.iduser = ?
Parameters:
[
  2
]
0.05 ms
(5.97%)
1
SELECT count(*) AS sclr_0 FROM puls_farnosti p0_
Parameters:
[]
0.03 ms
(4.07%)
1
SELECT t0.idoptions AS idoptions_1, t0.sbirkadatum AS sbirkadatum_2, t0.kasickarok AS kasickarok_3, t0.mujpulsfarnostrok AS mujpulsfarnostrok_4, t0.googletag AS googletag_5, t0.ogtitle AS ogtitle_6, t0.ogimage AS ogimage_7, t0.ogdescription AS ogdescription_8, t0.metadescription AS metadescription_9, t0.bannerfile AS bannerfile_10, t0.bannerlink AS bannerlink_11, t0.bannertext AS bannertext_12, t0.bannerstandard AS bannerstandard_13, t0.farnostivyuctovanisend AS farnostivyuctovanisend_14, t0.farnostivyuctovanirok AS farnostivyuctovanirok_15, t0.RozsahVarSymb AS RozsahVarSymb_16 FROM puls_options t0 LIMIT 1
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\PulsFarnosti 20
App\Entity\PulsUsers 1
App\Entity\PulsOptions 1

Entities Mapping

Class Mapping errors
App\Entity\PulsUsers No errors.
App\Entity\PulsFarnosti No errors.
App\Entity\PulsDekanstvi No errors.
App\Entity\PulsOptions No errors.