Symfony Profiler

SELECT
  t0.autor_id AS autor_id_1,
  t0.autor_login AS autor_login_2,
  t0.autor_pass AS autor_pass_3,
  t0.autor_pass2 AS autor_pass2_4,
  t0.autor_mail AS autor_mail_5,
  t0.autor_jmeno AS autor_jmeno_6,
  t0.autor_prijmeni AS autor_prijmeni_7,
  t0.autor_blok AS autor_blok_8,
  t0.autor_ikonka AS autor_ikonka_9,
  t0.autor_body AS autor_body_10,
  t0.autor_fotek AS autor_fotek_11,
  t0.autor_komentaru AS autor_komentaru_12,
  t0.autor_hodnoceni AS autor_hodnoceni_13,
  t0.autor_predplatne AS autor_predplatne_14,
  t0.autor_technika AS autor_technika_15,
  t0.autor_poznamka AS autor_poznamka_16,
  t0.autor_prodejni_info AS autor_prodejni_info_17,
  t0.autor_ip AS autor_ip_18,
  t0.autor_prihlaseni AS autor_prihlaseni_19,
  t0.autor_last_upload AS autor_last_upload_20,
  t0.autor_ftp AS autor_ftp_21,
  t0.autor_mailpp AS autor_mailpp_22,
  t0.autor_posta AS autor_posta_23,
  t0.autor_postanew AS autor_postanew_24,
  t0.lat AS lat_25,
  t0.lon AS lon_26,
  t0.heslo_token AS heslo_token_27,
  t0.heslo_token_platnost AS heslo_token_platnost_28,
  t0.novinky_zasilat AS novinky_zasilat_29,
  t0.novinky_token AS novinky_token_30,
  t0.autor_flag_bazar AS autor_flag_bazar_31,
  t0.autor_flag_bmfoto AS autor_flag_bmfoto_32,
  t0.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_33,
  t0.autor_flag_posta_back AS autor_flag_posta_back_34,
  t0.autor_flag_posta_pocet AS autor_flag_posta_pocet_35,
  t0.autor_flag_profil AS autor_flag_profil_36,
  t0.autor_flag_clanky AS autor_flag_clanky_37,
  t0.autor_flag_beztlach AS autor_flag_beztlach_38,
  t0.autor_flag_foto_kom AS autor_flag_foto_kom_39,
  t0.autor_flag_bmstart AS autor_flag_bmstart_40,
  t0.autor_flag_default_bodovani AS autor_flag_default_bodovani_41,
  t0.autor_role AS autor_role_42
FROM
  autor t0
WHERE
  t0.autor_id = ?

SELECT t0.autor_id AS autor_id_1, t0.autor_login AS autor_login_2, t0.autor_pass AS autor_pass_3, t0.autor_pass2 AS autor_pass2_4, t0.autor_mail AS autor_mail_5, t0.autor_jmeno AS autor_jmeno_6, t0.autor_prijmeni AS autor_prijmeni_7, t0.autor_blok AS autor_blok_8, t0.autor_ikonka AS autor_ikonka_9, t0.autor_body AS autor_body_10, t0.autor_fotek AS autor_fotek_11, t0.autor_komentaru AS autor_komentaru_12, t0.autor_hodnoceni AS autor_hodnoceni_13, t0.autor_predplatne AS autor_predplatne_14, t0.autor_technika AS autor_technika_15, t0.autor_poznamka AS autor_poznamka_16, t0.autor_prodejni_info AS autor_prodejni_info_17, t0.autor_ip AS autor_ip_18, t0.autor_prihlaseni AS autor_prihlaseni_19, t0.autor_last_upload AS autor_last_upload_20, t0.autor_ftp AS autor_ftp_21, t0.autor_mailpp AS autor_mailpp_22, t0.autor_posta AS autor_posta_23, t0.autor_postanew AS autor_postanew_24, t0.lat AS lat_25, t0.lon AS lon_26, t0.heslo_token AS heslo_token_27, t0.heslo_token_platnost AS heslo_token_platnost_28, t0.novinky_zasilat AS novinky_zasilat_29, t0.novinky_token AS novinky_token_30, t0.autor_flag_bazar AS autor_flag_bazar_31, t0.autor_flag_bmfoto AS autor_flag_bmfoto_32, t0.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_33, t0.autor_flag_posta_back AS autor_flag_posta_back_34, t0.autor_flag_posta_pocet AS autor_flag_posta_pocet_35, t0.autor_flag_profil AS autor_flag_profil_36, t0.autor_flag_clanky AS autor_flag_clanky_37, t0.autor_flag_beztlach AS autor_flag_beztlach_38, t0.autor_flag_foto_kom AS autor_flag_foto_kom_39, t0.autor_flag_bmstart AS autor_flag_bmstart_40, t0.autor_flag_default_bodovani AS autor_flag_default_bodovani_41, t0.autor_role AS autor_role_42 FROM autor t0 WHERE t0.autor_id = 6102;

SELECT
  t0.online_autor_id AS online_autor_id_1,
  t0.online_datum AS online_datum_2,
  t0.online_url AS online_url_3,
  t0.online_ip AS online_ip_4
FROM
  online t0
WHERE
  t0.online_autor_id = ?

SELECT t0.online_autor_id AS online_autor_id_1, t0.online_datum AS online_datum_2, t0.online_url AS online_url_3, t0.online_ip AS online_ip_4 FROM online t0 WHERE t0.online_autor_id = 6102;

SELECT
  f0_.foto_id AS foto_id_0,
  f0_.foto_soubor AS foto_soubor_1,
  f0_.foto_autor AS foto_autor_2,
  f0_.foto_titulek AS foto_titulek_3,
  f0_.foto_datum AS foto_datum_4,
  f0_.foto_body AS foto_body_5,
  f0_.foto_hodnoceni AS foto_hodnoceni_6,
  f0_.foto_komentaru AS foto_komentaru_7,
  f0_.foto_pocitadlo AS foto_pocitadlo_8,
  f0_.foto_kos AS foto_kos_9,
  f0_.foto_bd_px AS foto_bd_px_10,
  f0_.foto_bd_col AS foto_bd_col_11,
  f0_.foto_bg_col AS foto_bg_col_12,
  f0_.foto_width AS foto_width_13,
  f0_.foto_height AS foto_height_14,
  f0_.mazat AS mazat_15,
  f0_.tagy AS tagy_16,
  f0_.popis AS popis_17,
  f0_.foto_technika AS foto_technika_18,
  f0_.foto_poznamka AS foto_poznamka_19,
  f0_.foto_prodej AS foto_prodej_20,
  f0_.foto_autor AS foto_autor_21
FROM
  foto f0_
WHERE
  f0_.foto_autor = ?
  AND f0_.foto_kos = 0
ORDER BY
  f0_.foto_datum DESC
LIMIT
  10

SELECT f0_.foto_id AS foto_id_0, f0_.foto_soubor AS foto_soubor_1, f0_.foto_autor AS foto_autor_2, f0_.foto_titulek AS foto_titulek_3, f0_.foto_datum AS foto_datum_4, f0_.foto_body AS foto_body_5, f0_.foto_hodnoceni AS foto_hodnoceni_6, f0_.foto_komentaru AS foto_komentaru_7, f0_.foto_pocitadlo AS foto_pocitadlo_8, f0_.foto_kos AS foto_kos_9, f0_.foto_bd_px AS foto_bd_px_10, f0_.foto_bd_col AS foto_bd_col_11, f0_.foto_bg_col AS foto_bg_col_12, f0_.foto_width AS foto_width_13, f0_.foto_height AS foto_height_14, f0_.mazat AS mazat_15, f0_.tagy AS tagy_16, f0_.popis AS popis_17, f0_.foto_technika AS foto_technika_18, f0_.foto_poznamka AS foto_poznamka_19, f0_.foto_prodej AS foto_prodej_20, f0_.foto_autor AS foto_autor_21 FROM foto f0_ WHERE f0_.foto_autor = 6102 AND f0_.foto_kos = 0 ORDER BY f0_.foto_datum DESC LIMIT 10;

SELECT
  COUNT(*)
FROM
  bmautor t0
WHERE
  t0.bmautor_autor = ?

SELECT COUNT(*) FROM bmautor t0 WHERE t0.bmautor_autor = 6102;

SELECT
  AVG(h.hodnoceni_body) AS avg_rating,
  COUNT(*) AS rating_count
FROM
  hodnoceni h
  JOIN foto f ON f.foto_id = h.hodnoceni_foto_id
WHERE
  f.foto_autor = ?
  AND f.foto_autor != 3
  AND f.foto_kos = 0
  AND f.foto_body >= 0
  AND h.hodnoceni_body IS NOT NULL
  AND h.hodnoceni_body > 0
  AND h.hodnoceni_datum >= DATE_SUB(
    NOW(),
    INTERVAL 10 YEAR
  )

SELECT AVG(h.hodnoceni_body) AS avg_rating, COUNT(*) AS rating_count
             FROM hodnoceni h
             JOIN foto f ON f.foto_id = h.hodnoceni_foto_id
             WHERE f.foto_autor = 6102 AND f.foto_autor != 3 AND f.foto_kos = 0 AND f.foto_body >= 0 AND h.hodnoceni_body IS NOT NULL AND h.hodnoceni_body > 0 AND h.hodnoceni_datum >= DATE_SUB(NOW(), INTERVAL 10 YEAR);