Symfony Profiler

SELECT
  w0_.id AS id_0,
  w0_.trans_id AS trans_id_1,
  w0_.jogszabaly_id AS jogszabaly_id_2,
  w0_.evszam AS evszam_3,
  w0_.sorszam AS sorszam_4,
  w0_.cim AS cim_5,
  w0_.alcim AS alcim_6,
  w0_.hatba AS hatba_7,
  w0_.hatki AS hatki_8,
  w0_.kihirdetes AS kihirdetes_9,
  w0_.uploaded AS uploaded_10,
  w0_.publicated AS publicated_11,
  w0_.khstat AS khstat_12,
  w0_.loclex_id AS loclex_id_13,
  h1_.id AS id_14,
  h1_.trans_id AS trans_id_15,
  h1_.nev AS nev_16,
  h1_.cim AS cim_17,
  h1_.pirszam AS pirszam_18,
  h1_.kshszam AS kshszam_19,
  h1_.statusz AS statusz_20,
  v2_.id AS id_21,
  v2_.trans_id AS trans_id_22,
  v2_.jogszabaly_id AS jogszabaly_id_23,
  v2_.alaprendelet AS alaprendelet_24,
  v2_.hatba AS hatba_25,
  v2_.hatki AS hatki_26,
  v2_.statusz AS statusz_27,
  v2_.uploaded AS uploaded_28,
  v2_.modified AS modified_29,
  v2_.publicated AS publicated_30,
  v2_.loclex_id AS loclex_id_31,
  v2_.verzio AS verzio_32,
  v2_.archive AS archive_33,
  v2_.html AS html_34,
  j3_.id AS id_35,
  j3_.trans_id AS trans_id_36,
  j3_.nev AS nev_37,
  j3_.rovidnev AS rovidnev_38,
  j3_.kod AS kod_39,
  w0_.jtipus_id AS jtipus_id_40,
  w0_.hivatal_id AS hivatal_id_41,
  h1_.megye_id AS megye_id_42,
  h1_.telep_id AS telep_id_43,
  h1_.hivtip_id AS hivtip_id_44,
  v2_.wadmin_id AS wadmin_id_45
FROM
  wadmin w0_
  INNER JOIN hivatal h1_ ON w0_.hivatal_id = h1_.id
  INNER JOIN valtozat v2_ ON w0_.id = v2_.wadmin_id
  AND (v2_.statusz = ?)
  INNER JOIN jogtipus j3_ ON w0_.jtipus_id = j3_.id
WHERE
  h1_.trans_id IN ('259')
  AND j3_.kod IN ('SP')
  AND v2_.archive = ?
ORDER BY
  h1_.nev ASC,
  w0_.evszam DESC,
  w0_.sorszam DESC,
  v2_.alaprendelet DESC,
  v2_.hatba ASC,
  j3_.kod ASC
LIMIT
  2000

SELECT w0_.id AS id_0, w0_.trans_id AS trans_id_1, w0_.jogszabaly_id AS jogszabaly_id_2, w0_.evszam AS evszam_3, w0_.sorszam AS sorszam_4, w0_.cim AS cim_5, w0_.alcim AS alcim_6, w0_.hatba AS hatba_7, w0_.hatki AS hatki_8, w0_.kihirdetes AS kihirdetes_9, w0_.uploaded AS uploaded_10, w0_.publicated AS publicated_11, w0_.khstat AS khstat_12, w0_.loclex_id AS loclex_id_13, h1_.id AS id_14, h1_.trans_id AS trans_id_15, h1_.nev AS nev_16, h1_.cim AS cim_17, h1_.pirszam AS pirszam_18, h1_.kshszam AS kshszam_19, h1_.statusz AS statusz_20, v2_.id AS id_21, v2_.trans_id AS trans_id_22, v2_.jogszabaly_id AS jogszabaly_id_23, v2_.alaprendelet AS alaprendelet_24, v2_.hatba AS hatba_25, v2_.hatki AS hatki_26, v2_.statusz AS statusz_27, v2_.uploaded AS uploaded_28, v2_.modified AS modified_29, v2_.publicated AS publicated_30, v2_.loclex_id AS loclex_id_31, v2_.verzio AS verzio_32, v2_.archive AS archive_33, v2_.html AS html_34, j3_.id AS id_35, j3_.trans_id AS trans_id_36, j3_.nev AS nev_37, j3_.rovidnev AS rovidnev_38, j3_.kod AS kod_39, w0_.jtipus_id AS jtipus_id_40, w0_.hivatal_id AS hivatal_id_41, h1_.megye_id AS megye_id_42, h1_.telep_id AS telep_id_43, h1_.hivtip_id AS hivtip_id_44, v2_.wadmin_id AS wadmin_id_45 FROM wadmin w0_ INNER JOIN hivatal h1_ ON w0_.hivatal_id = h1_.id INNER JOIN valtozat v2_ ON w0_.id = v2_.wadmin_id AND (v2_.statusz = 'P') INNER JOIN jogtipus j3_ ON w0_.jtipus_id = j3_.id WHERE h1_.trans_id IN ('259') AND j3_.kod IN ('SP') AND v2_.archive = 0 ORDER BY h1_.nev ASC, w0_.evszam DESC, w0_.sorszam DESC, v2_.alaprendelet DESC, v2_.hatba ASC, j3_.kod ASC LIMIT 2000;

SELECT
  COUNT(DISTINCT w0_.id) AS sclr_0
FROM
  wadmin w0_
  INNER JOIN hivatal h1_ ON w0_.hivatal_id = h1_.id
  INNER JOIN valtozat v2_ ON w0_.id = v2_.wadmin_id
  AND (v2_.statusz = ?)
  INNER JOIN jogtipus j3_ ON w0_.jtipus_id = j3_.id
WHERE
  h1_.trans_id IN ('259')
  AND j3_.kod IN ('SP')
  AND v2_.archive = ?

SELECT COUNT(DISTINCT w0_.id) AS sclr_0 FROM wadmin w0_ INNER JOIN hivatal h1_ ON w0_.hivatal_id = h1_.id INNER JOIN valtozat v2_ ON w0_.id = v2_.wadmin_id AND (v2_.statusz = 'P') INNER JOIN jogtipus j3_ ON w0_.jtipus_id = j3_.id WHERE h1_.trans_id IN ('259') AND j3_.kod IN ('SP') AND v2_.archive = 0;

SELECT
  t0.id AS id_1,
  t0.trans_id AS trans_id_2,
  t0.nev AS nev_3,
  t0.testulet_id AS testulet_id_4,
  t0.hivatal_id AS hivatal_id_5
FROM
  kibocsato t0
WHERE
  t0.hivatal_id = ?

SELECT t0.id AS id_1, t0.trans_id AS trans_id_2, t0.nev AS nev_3, t0.testulet_id AS testulet_id_4, t0.hivatal_id AS hivatal_id_5 FROM kibocsato t0 WHERE t0.hivatal_id = 33;