Symfony Profiler

SELECT
  count(DISTINCT b0_.bazar_id) AS sclr_0
FROM
  bazar b0_
  LEFT JOIN autor a1_ ON b0_.bazar_autor = a1_.autor_id
WHERE
  b0_.bazar_kategorie = ?

SELECT count(DISTINCT b0_.bazar_id) AS sclr_0 FROM bazar b0_ LEFT JOIN autor a1_ ON b0_.bazar_autor = a1_.autor_id WHERE b0_.bazar_kategorie = 1;

SELECT
  DISTINCT b0_.bazar_id AS bazar_id_0,
  b0_.bazar_datum AS bazar_datum_1
FROM
  bazar b0_
  LEFT JOIN autor a1_ ON b0_.bazar_autor = a1_.autor_id
WHERE
  b0_.bazar_kategorie = ?
ORDER BY
  b0_.bazar_datum DESC
LIMIT
  30

SELECT DISTINCT b0_.bazar_id AS bazar_id_0, b0_.bazar_datum AS bazar_datum_1 FROM bazar b0_ LEFT JOIN autor a1_ ON b0_.bazar_autor = a1_.autor_id WHERE b0_.bazar_kategorie = 1 ORDER BY b0_.bazar_datum DESC LIMIT 30;

SELECT
  b0_.bazar_id AS bazar_id_0,
  b0_.bazar_kategorie AS bazar_kategorie_1,
  b0_.bazar_titulek AS bazar_titulek_2,
  b0_.bazar_text AS bazar_text_3,
  b0_.bazar_datum AS bazar_datum_4,
  a1_.autor_id AS autor_id_5,
  a1_.autor_login AS autor_login_6,
  a1_.autor_pass AS autor_pass_7,
  a1_.autor_pass2 AS autor_pass2_8,
  a1_.autor_mail AS autor_mail_9,
  a1_.autor_jmeno AS autor_jmeno_10,
  a1_.autor_prijmeni AS autor_prijmeni_11,
  a1_.autor_blok AS autor_blok_12,
  a1_.autor_ikonka AS autor_ikonka_13,
  a1_.autor_body AS autor_body_14,
  a1_.autor_fotek AS autor_fotek_15,
  a1_.autor_komentaru AS autor_komentaru_16,
  a1_.autor_hodnoceni AS autor_hodnoceni_17,
  a1_.autor_predplatne AS autor_predplatne_18,
  a1_.autor_technika AS autor_technika_19,
  a1_.autor_poznamka AS autor_poznamka_20,
  a1_.autor_prodejni_info AS autor_prodejni_info_21,
  a1_.autor_ip AS autor_ip_22,
  a1_.autor_prihlaseni AS autor_prihlaseni_23,
  a1_.autor_last_upload AS autor_last_upload_24,
  a1_.autor_ftp AS autor_ftp_25,
  a1_.autor_mailpp AS autor_mailpp_26,
  a1_.autor_posta AS autor_posta_27,
  a1_.autor_postanew AS autor_postanew_28,
  a1_.lat AS lat_29,
  a1_.lon AS lon_30,
  a1_.heslo_token AS heslo_token_31,
  a1_.heslo_token_platnost AS heslo_token_platnost_32,
  a1_.novinky_zasilat AS novinky_zasilat_33,
  a1_.novinky_token AS novinky_token_34,
  a1_.autor_flag_bazar AS autor_flag_bazar_35,
  a1_.autor_flag_bmfoto AS autor_flag_bmfoto_36,
  a1_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_37,
  a1_.autor_flag_posta_back AS autor_flag_posta_back_38,
  a1_.autor_flag_posta_pocet AS autor_flag_posta_pocet_39,
  a1_.autor_flag_profil AS autor_flag_profil_40,
  a1_.autor_flag_clanky AS autor_flag_clanky_41,
  a1_.autor_flag_beztlach AS autor_flag_beztlach_42,
  a1_.autor_flag_foto_kom AS autor_flag_foto_kom_43,
  a1_.autor_flag_bmstart AS autor_flag_bmstart_44,
  a1_.autor_flag_default_bodovani AS autor_flag_default_bodovani_45,
  a1_.autor_role AS autor_role_46,
  b0_.bazar_autor AS bazar_autor_47
FROM
  bazar b0_
  LEFT JOIN autor a1_ ON b0_.bazar_autor = a1_.autor_id
WHERE
  b0_.bazar_kategorie = ?
  AND b0_.bazar_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  b0_.bazar_datum DESC

SELECT b0_.bazar_id AS bazar_id_0, b0_.bazar_kategorie AS bazar_kategorie_1, b0_.bazar_titulek AS bazar_titulek_2, b0_.bazar_text AS bazar_text_3, b0_.bazar_datum AS bazar_datum_4, a1_.autor_id AS autor_id_5, a1_.autor_login AS autor_login_6, a1_.autor_pass AS autor_pass_7, a1_.autor_pass2 AS autor_pass2_8, a1_.autor_mail AS autor_mail_9, a1_.autor_jmeno AS autor_jmeno_10, a1_.autor_prijmeni AS autor_prijmeni_11, a1_.autor_blok AS autor_blok_12, a1_.autor_ikonka AS autor_ikonka_13, a1_.autor_body AS autor_body_14, a1_.autor_fotek AS autor_fotek_15, a1_.autor_komentaru AS autor_komentaru_16, a1_.autor_hodnoceni AS autor_hodnoceni_17, a1_.autor_predplatne AS autor_predplatne_18, a1_.autor_technika AS autor_technika_19, a1_.autor_poznamka AS autor_poznamka_20, a1_.autor_prodejni_info AS autor_prodejni_info_21, a1_.autor_ip AS autor_ip_22, a1_.autor_prihlaseni AS autor_prihlaseni_23, a1_.autor_last_upload AS autor_last_upload_24, a1_.autor_ftp AS autor_ftp_25, a1_.autor_mailpp AS autor_mailpp_26, a1_.autor_posta AS autor_posta_27, a1_.autor_postanew AS autor_postanew_28, a1_.lat AS lat_29, a1_.lon AS lon_30, a1_.heslo_token AS heslo_token_31, a1_.heslo_token_platnost AS heslo_token_platnost_32, a1_.novinky_zasilat AS novinky_zasilat_33, a1_.novinky_token AS novinky_token_34, a1_.autor_flag_bazar AS autor_flag_bazar_35, a1_.autor_flag_bmfoto AS autor_flag_bmfoto_36, a1_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_37, a1_.autor_flag_posta_back AS autor_flag_posta_back_38, a1_.autor_flag_posta_pocet AS autor_flag_posta_pocet_39, a1_.autor_flag_profil AS autor_flag_profil_40, a1_.autor_flag_clanky AS autor_flag_clanky_41, a1_.autor_flag_beztlach AS autor_flag_beztlach_42, a1_.autor_flag_foto_kom AS autor_flag_foto_kom_43, a1_.autor_flag_bmstart AS autor_flag_bmstart_44, a1_.autor_flag_default_bodovani AS autor_flag_default_bodovani_45, a1_.autor_role AS autor_role_46, b0_.bazar_autor AS bazar_autor_47 FROM bazar b0_ LEFT JOIN autor a1_ ON b0_.bazar_autor = a1_.autor_id WHERE b0_.bazar_kategorie = 1 AND b0_.bazar_id IN (5421, 5420, 5419, 5418, 5415, 5414, 5413, 5410, 5409, 5404, 5402, 5388, 5387, 5386, 5371, 5370, 5365, 5364, 5363, 5362, 5361, 5360, 5353, 5352, 5350, 5336, 5335, 5325, 5324, 5322) ORDER BY b0_.bazar_datum DESC;

SELECT
  b0_.bazar_foto_id AS bazar_foto_id_0,
  b0_.bazar_foto_soubor AS bazar_foto_soubor_1,
  b0_.bazar_foto_poradi AS bazar_foto_poradi_2,
  b0_.bazar_foto_datum AS bazar_foto_datum_3,
  b0_.bazar_foto_bazar AS bazar_foto_bazar_4
FROM
  bazar_foto b0_
WHERE
  b0_.bazar_foto_bazar IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  b0_.bazar_foto_poradi ASC

SELECT b0_.bazar_foto_id AS bazar_foto_id_0, b0_.bazar_foto_soubor AS bazar_foto_soubor_1, b0_.bazar_foto_poradi AS bazar_foto_poradi_2, b0_.bazar_foto_datum AS bazar_foto_datum_3, b0_.bazar_foto_bazar AS bazar_foto_bazar_4 FROM bazar_foto b0_ WHERE b0_.bazar_foto_bazar IN (5421, 5420, 5419, 5418, 5415, 5414, 5413, 5410, 5409, 5404, 5402, 5388, 5387, 5386, 5371, 5370, 5365, 5364, 5363, 5362, 5361, 5360, 5353, 5352, 5350, 5336, 5335, 5325, 5324, 5322) ORDER BY b0_.bazar_foto_poradi ASC;