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 = 2778;

SELECT
  YEAR(f.foto_datum) AS yr,
  ROUND(
    AVG(h.hodnoceni_body),
    2
  ) AS avg_rating,
  COUNT(*) AS cnt
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
GROUP BY
  yr
ORDER BY
  yr

SELECT YEAR(f.foto_datum) AS yr, ROUND(AVG(h.hodnoceni_body), 2) AS avg_rating, COUNT(*) AS cnt
             FROM hodnoceni h
             JOIN foto f ON f.foto_id = h.hodnoceni_foto_id
             WHERE f.foto_autor = 2778 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
             GROUP BY yr ORDER BY yr;

SELECT
  YEAR(foto_datum) AS yr,
  COUNT(*) AS cnt
FROM
  foto
WHERE
  foto_autor = ?
  AND foto_autor != 3
  AND foto_kos = 0
GROUP BY
  yr
ORDER BY
  yr

SELECT YEAR(foto_datum) AS yr, COUNT(*) AS cnt
             FROM foto
             WHERE foto_autor = 2778 AND foto_autor != 3 AND foto_kos = 0
             GROUP BY yr ORDER BY yr;

SELECT
  YEAR(h.hodnoceni_datum) AS yr,
  ROUND(
    AVG(h.hodnoceni_body),
    2
  ) AS avg_rating,
  COUNT(*) AS cnt
FROM
  hodnoceni h
  JOIN foto f ON f.foto_id = h.hodnoceni_foto_id
WHERE
  h.hodnoceni_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
GROUP BY
  yr
ORDER BY
  yr

SELECT YEAR(h.hodnoceni_datum) AS yr, ROUND(AVG(h.hodnoceni_body), 2) AS avg_rating, COUNT(*) AS cnt
             FROM hodnoceni h
             JOIN foto f ON f.foto_id = h.hodnoceni_foto_id
             WHERE h.hodnoceni_autor = 2778 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
             GROUP BY yr ORDER BY yr;

SELECT
  YEAR(h.hodnoceni_datum) AS yr,
  COUNT(*) AS cnt
FROM
  hodnoceni h
  JOIN foto f ON f.foto_id = h.hodnoceni_foto_id
WHERE
  h.hodnoceni_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
GROUP BY
  yr
ORDER BY
  yr

SELECT YEAR(h.hodnoceni_datum) AS yr, COUNT(*) AS cnt
             FROM hodnoceni h
             JOIN foto f ON f.foto_id = h.hodnoceni_foto_id
             WHERE h.hodnoceni_autor = 2778 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
             GROUP BY yr ORDER BY yr;

SELECT
  LEAST(
    COALESCE(
      (
        SELECT
          MIN(
            YEAR(foto_datum)
          )
        FROM
          foto
        WHERE
          foto_autor = ?
          AND foto_kos = 0
      ),
      9999
    ),
    COALESCE(
      (
        SELECT
          MIN(
            YEAR(hodnoceni_datum)
          )
        FROM
          hodnoceni
        WHERE
          hodnoceni_autor = ?
      ),
      9999
    )
  ) AS first_year

SELECT LEAST(
                COALESCE((SELECT MIN(YEAR(foto_datum)) FROM foto WHERE foto_autor = 2778 AND foto_kos = 0), 9999),
                COALESCE((SELECT MIN(YEAR(hodnoceni_datum)) FROM hodnoceni WHERE hodnoceni_autor = 2778), 9999)
             ) AS first_year;

SELECT
  k.kategorie_nazev AS name,
  COUNT(*) AS cnt
FROM
  foto_kategorie fk
  JOIN foto f ON f.foto_id = fk.foto_id
  JOIN kategorie k ON k.kategorie_id = fk.kategorie_id
WHERE
  f.foto_autor = ?
  AND f.foto_autor != 3
  AND f.foto_kos = 0
GROUP BY
  k.kategorie_id
ORDER BY
  cnt DESC

SELECT k.kategorie_nazev AS name, COUNT(*) AS cnt
             FROM foto_kategorie fk
             JOIN foto f ON f.foto_id = fk.foto_id
             JOIN kategorie k ON k.kategorie_id = fk.kategorie_id
             WHERE f.foto_autor = 2778 AND f.foto_autor != 3 AND f.foto_kos = 0
             GROUP BY k.kategorie_id ORDER BY cnt DESC;