Symfony Profiler

SELECT
  count(DISTINCT f0_.foto_id) AS sclr_0
FROM
  foto f0_
  LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id
WHERE
  f0_.foto_kos = 0
  AND f0_.foto_autor = ?

SELECT count(DISTINCT f0_.foto_id) AS sclr_0 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = 17841;

SELECT
  DISTINCT f0_.foto_id AS foto_id_0,
  f0_.foto_datum AS foto_datum_1,
  f0_.foto_id AS foto_id_2
FROM
  foto f0_
  LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id
WHERE
  f0_.foto_kos = 0
  AND f0_.foto_autor = ?
ORDER BY
  f0_.foto_datum DESC,
  f0_.foto_id DESC
LIMIT
  30

SELECT DISTINCT f0_.foto_id AS foto_id_0, f0_.foto_datum AS foto_datum_1, f0_.foto_id AS foto_id_2 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = 17841 ORDER BY f0_.foto_datum DESC, f0_.foto_id DESC LIMIT 30;

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,
  a1_.autor_id AS autor_id_21,
  a1_.autor_login AS autor_login_22,
  a1_.autor_pass AS autor_pass_23,
  a1_.autor_pass2 AS autor_pass2_24,
  a1_.autor_mail AS autor_mail_25,
  a1_.autor_jmeno AS autor_jmeno_26,
  a1_.autor_prijmeni AS autor_prijmeni_27,
  a1_.autor_blok AS autor_blok_28,
  a1_.autor_ikonka AS autor_ikonka_29,
  a1_.autor_body AS autor_body_30,
  a1_.autor_fotek AS autor_fotek_31,
  a1_.autor_komentaru AS autor_komentaru_32,
  a1_.autor_hodnoceni AS autor_hodnoceni_33,
  a1_.autor_predplatne AS autor_predplatne_34,
  a1_.autor_technika AS autor_technika_35,
  a1_.autor_poznamka AS autor_poznamka_36,
  a1_.autor_prodejni_info AS autor_prodejni_info_37,
  a1_.autor_ip AS autor_ip_38,
  a1_.autor_prihlaseni AS autor_prihlaseni_39,
  a1_.autor_last_upload AS autor_last_upload_40,
  a1_.autor_ftp AS autor_ftp_41,
  a1_.autor_mailpp AS autor_mailpp_42,
  a1_.autor_posta AS autor_posta_43,
  a1_.autor_postanew AS autor_postanew_44,
  a1_.lat AS lat_45,
  a1_.lon AS lon_46,
  a1_.heslo_token AS heslo_token_47,
  a1_.heslo_token_platnost AS heslo_token_platnost_48,
  a1_.novinky_zasilat AS novinky_zasilat_49,
  a1_.novinky_token AS novinky_token_50,
  a1_.autor_flag_bazar AS autor_flag_bazar_51,
  a1_.autor_flag_bmfoto AS autor_flag_bmfoto_52,
  a1_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_53,
  a1_.autor_flag_posta_back AS autor_flag_posta_back_54,
  a1_.autor_flag_posta_pocet AS autor_flag_posta_pocet_55,
  a1_.autor_flag_profil AS autor_flag_profil_56,
  a1_.autor_flag_clanky AS autor_flag_clanky_57,
  a1_.autor_flag_beztlach AS autor_flag_beztlach_58,
  a1_.autor_flag_foto_kom AS autor_flag_foto_kom_59,
  a1_.autor_flag_bmstart AS autor_flag_bmstart_60,
  a1_.autor_flag_default_bodovani AS autor_flag_default_bodovani_61,
  a1_.autor_role AS autor_role_62,
  f0_.foto_autor AS foto_autor_63
FROM
  foto f0_
  LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id
WHERE
  f0_.foto_kos = 0
  AND f0_.foto_autor = ?
  AND f0_.foto_id IN (?)
ORDER BY
  f0_.foto_datum DESC,
  f0_.foto_id DESC

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, a1_.autor_id AS autor_id_21, a1_.autor_login AS autor_login_22, a1_.autor_pass AS autor_pass_23, a1_.autor_pass2 AS autor_pass2_24, a1_.autor_mail AS autor_mail_25, a1_.autor_jmeno AS autor_jmeno_26, a1_.autor_prijmeni AS autor_prijmeni_27, a1_.autor_blok AS autor_blok_28, a1_.autor_ikonka AS autor_ikonka_29, a1_.autor_body AS autor_body_30, a1_.autor_fotek AS autor_fotek_31, a1_.autor_komentaru AS autor_komentaru_32, a1_.autor_hodnoceni AS autor_hodnoceni_33, a1_.autor_predplatne AS autor_predplatne_34, a1_.autor_technika AS autor_technika_35, a1_.autor_poznamka AS autor_poznamka_36, a1_.autor_prodejni_info AS autor_prodejni_info_37, a1_.autor_ip AS autor_ip_38, a1_.autor_prihlaseni AS autor_prihlaseni_39, a1_.autor_last_upload AS autor_last_upload_40, a1_.autor_ftp AS autor_ftp_41, a1_.autor_mailpp AS autor_mailpp_42, a1_.autor_posta AS autor_posta_43, a1_.autor_postanew AS autor_postanew_44, a1_.lat AS lat_45, a1_.lon AS lon_46, a1_.heslo_token AS heslo_token_47, a1_.heslo_token_platnost AS heslo_token_platnost_48, a1_.novinky_zasilat AS novinky_zasilat_49, a1_.novinky_token AS novinky_token_50, a1_.autor_flag_bazar AS autor_flag_bazar_51, a1_.autor_flag_bmfoto AS autor_flag_bmfoto_52, a1_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_53, a1_.autor_flag_posta_back AS autor_flag_posta_back_54, a1_.autor_flag_posta_pocet AS autor_flag_posta_pocet_55, a1_.autor_flag_profil AS autor_flag_profil_56, a1_.autor_flag_clanky AS autor_flag_clanky_57, a1_.autor_flag_beztlach AS autor_flag_beztlach_58, a1_.autor_flag_foto_kom AS autor_flag_foto_kom_59, a1_.autor_flag_bmstart AS autor_flag_bmstart_60, a1_.autor_flag_default_bodovani AS autor_flag_default_bodovani_61, a1_.autor_role AS autor_role_62, f0_.foto_autor AS foto_autor_63 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = 17841 AND f0_.foto_id IN (275644) ORDER BY f0_.foto_datum DESC, f0_.foto_id DESC;

SELECT
  t0.kategorie_id AS kategorie_id_1,
  t0.kategorie_nazev AS kategorie_nazev_2,
  t0.url AS url_3,
  t0.title AS title_4,
  t0.metadescription AS metadescription_5,
  t0.h1 AS h1_6,
  t0.description AS description_7
FROM
  kategorie t0
ORDER BY
  t0.kategorie_nazev ASC

SELECT t0.kategorie_id AS kategorie_id_1, t0.kategorie_nazev AS kategorie_nazev_2, t0.url AS url_3, t0.title AS title_4, t0.metadescription AS metadescription_5, t0.h1 AS h1_6, t0.description AS description_7 FROM kategorie t0 ORDER BY t0.kategorie_nazev ASC;

SELECT
  h.hodnoceni_foto_id AS photoId,
  SUM(h.hodnoceni_body) AS recentPoints
FROM
  hodnoceni h
WHERE
  h.hodnoceni_datum > ?
  AND h.hodnoceni_body IS NOT NULL
  AND h.hodnoceni_body > 0
GROUP BY
  h.hodnoceni_foto_id
ORDER BY
  recentPoints DESC
LIMIT
  10

SELECT h.hodnoceni_foto_id AS photoId, SUM(h.hodnoceni_body) AS recentPoints
             FROM hodnoceni h
             WHERE h.hodnoceni_datum > '2026-05-10 22:39:35'
               AND h.hodnoceni_body IS NOT NULL
               AND h.hodnoceni_body > 0
             GROUP BY h.hodnoceni_foto_id
             ORDER BY recentPoints DESC
             LIMIT 10;

SELECT
  h.hodnoceni_foto_id AS photoId,
  SUM(h.hodnoceni_body) AS recentPoints
FROM
  hodnoceni h
WHERE
  h.hodnoceni_datum > ?
  AND h.hodnoceni_body IS NOT NULL
  AND h.hodnoceni_body > 0
GROUP BY
  h.hodnoceni_foto_id
ORDER BY
  recentPoints DESC
LIMIT
  10

SELECT h.hodnoceni_foto_id AS photoId, SUM(h.hodnoceni_body) AS recentPoints
             FROM hodnoceni h
             WHERE h.hodnoceni_datum > '2026-05-07 22:39:35'
               AND h.hodnoceni_body IS NOT NULL
               AND h.hodnoceni_body > 0
             GROUP BY h.hodnoceni_foto_id
             ORDER BY recentPoints DESC
             LIMIT 10;

SELECT
  hodnoceni_autor AS userId,
  SUM(hodnoceni_body) AS totalGiven
FROM
  hodnoceni
WHERE
  hodnoceni_datum > ?
  AND hodnoceni_body IS NOT NULL
  AND hodnoceni_body > 0
GROUP BY
  hodnoceni_autor
ORDER BY
  totalGiven DESC
LIMIT
  10

SELECT hodnoceni_autor AS userId, SUM(hodnoceni_body) AS totalGiven
             FROM hodnoceni
             WHERE hodnoceni_datum > '2026-05-10 22:39:35'
               AND hodnoceni_body IS NOT NULL
               AND hodnoceni_body > 0
             GROUP BY hodnoceni_autor
             ORDER BY totalGiven DESC
             LIMIT 10;

SELECT
  hodnoceni_autor AS userId,
  SUM(hodnoceni_body) AS totalGiven
FROM
  hodnoceni
WHERE
  hodnoceni_datum > ?
  AND hodnoceni_body IS NOT NULL
  AND hodnoceni_body > 0
GROUP BY
  hodnoceni_autor
ORDER BY
  totalGiven DESC
LIMIT
  10

SELECT hodnoceni_autor AS userId, SUM(hodnoceni_body) AS totalGiven
             FROM hodnoceni
             WHERE hodnoceni_datum > '2026-05-07 22:39:35'
               AND hodnoceni_body IS NOT NULL
               AND hodnoceni_body > 0
             GROUP BY hodnoceni_autor
             ORDER BY totalGiven DESC
             LIMIT 10;

SELECT
  hodnoceni_autor AS userId,
  COUNT(*) AS ratingCount
FROM
  hodnoceni
WHERE
  hodnoceni_datum > ?
  AND hodnoceni_body IS NOT NULL
  AND hodnoceni_body > 0
GROUP BY
  hodnoceni_autor
ORDER BY
  ratingCount DESC
LIMIT
  5

SELECT hodnoceni_autor AS userId, COUNT(*) AS ratingCount
             FROM hodnoceni
             WHERE hodnoceni_datum > '2026-05-10 22:39:35'
               AND hodnoceni_body IS NOT NULL
               AND hodnoceni_body > 0
             GROUP BY hodnoceni_autor
             ORDER BY ratingCount DESC
             LIMIT 5;

SELECT
  hodnoceni_autor AS userId,
  COUNT(*) AS ratingCount
FROM
  hodnoceni
WHERE
  hodnoceni_datum > ?
  AND hodnoceni_body IS NOT NULL
  AND hodnoceni_body > 0
GROUP BY
  hodnoceni_autor
ORDER BY
  ratingCount DESC
LIMIT
  5

SELECT hodnoceni_autor AS userId, COUNT(*) AS ratingCount
             FROM hodnoceni
             WHERE hodnoceni_datum > '2026-05-07 22:39:35'
               AND hodnoceni_body IS NOT NULL
               AND hodnoceni_body > 0
             GROUP BY hodnoceni_autor
             ORDER BY ratingCount DESC
             LIMIT 5;

SELECT
  h.hodnoceni_foto_id AS photoId,
  SUM(h.hodnoceni_body) AS recentPoints
FROM
  hodnoceni h
WHERE
  h.hodnoceni_datum > ?
  AND h.hodnoceni_body IS NOT NULL
  AND h.hodnoceni_body > 0
GROUP BY
  h.hodnoceni_foto_id
ORDER BY
  recentPoints DESC
LIMIT
  5

SELECT h.hodnoceni_foto_id AS photoId, SUM(h.hodnoceni_body) AS recentPoints
             FROM hodnoceni h
             WHERE h.hodnoceni_datum > '2026-05-10 22:39:35'
               AND h.hodnoceni_body IS NOT NULL
               AND h.hodnoceni_body > 0
             GROUP BY h.hodnoceni_foto_id
             ORDER BY recentPoints DESC
             LIMIT 5;

SELECT
  h.hodnoceni_foto_id AS photoId,
  SUM(h.hodnoceni_body) AS recentPoints
FROM
  hodnoceni h
WHERE
  h.hodnoceni_datum > ?
  AND h.hodnoceni_body IS NOT NULL
  AND h.hodnoceni_body > 0
GROUP BY
  h.hodnoceni_foto_id
ORDER BY
  recentPoints DESC
LIMIT
  5

SELECT h.hodnoceni_foto_id AS photoId, SUM(h.hodnoceni_body) AS recentPoints
             FROM hodnoceni h
             WHERE h.hodnoceni_datum > '2026-05-07 22:39:35'
               AND h.hodnoceni_body IS NOT NULL
               AND h.hodnoceni_body > 0
             GROUP BY h.hodnoceni_foto_id
             ORDER BY recentPoints DESC
             LIMIT 5;

SELECT
  f0_.fotoesej_tema_id AS fotoesej_tema_id_0,
  f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1,
  f0_.fotoesej_tema_text AS fotoesej_tema_text_2,
  f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3,
  f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4,
  f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5,
  f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6,
  f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7
FROM
  fotoesej_tema f0_
WHERE
  f0_.fotoesej_tema_termin <= ?
  AND f0_.fotoesej_tema_termin > ?
ORDER BY
  f0_.fotoesej_tema_termin DESC
LIMIT
  1

SELECT f0_.fotoesej_tema_id AS fotoesej_tema_id_0, f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1, f0_.fotoesej_tema_text AS fotoesej_tema_text_2, f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3, f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4, f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5, f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6, f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7 FROM fotoesej_tema f0_ WHERE f0_.fotoesej_tema_termin <= '2026-05-11 22:39:35' AND f0_.fotoesej_tema_termin > '2026-05-01 22:39:35' ORDER BY f0_.fotoesej_tema_termin DESC LIMIT 1;

SELECT
  f0_.fotoesej_tema_id AS fotoesej_tema_id_0,
  f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1,
  f0_.fotoesej_tema_text AS fotoesej_tema_text_2,
  f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3,
  f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4,
  f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5,
  f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6,
  f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7
FROM
  fotoesej_tema f0_
WHERE
  f0_.fotoesej_tema_termin > ?
ORDER BY
  f0_.fotoesej_tema_termin ASC
LIMIT
  1

SELECT f0_.fotoesej_tema_id AS fotoesej_tema_id_0, f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1, f0_.fotoesej_tema_text AS fotoesej_tema_text_2, f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3, f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4, f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5, f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6, f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7 FROM fotoesej_tema f0_ WHERE f0_.fotoesej_tema_termin > '2026-05-11 22:39:35' ORDER BY f0_.fotoesej_tema_termin ASC LIMIT 1;

SELECT
  f0_.fotoesej_tema_id AS fotoesej_tema_id_0,
  f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1,
  f0_.fotoesej_tema_text AS fotoesej_tema_text_2,
  f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3,
  f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4,
  f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5,
  f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6,
  f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7
FROM
  fotoesej_tema f0_
WHERE
  f0_.fotoesej_tema_termin <= ?
  AND f0_.fotoesej_tema_fotek > 0
ORDER BY
  f0_.fotoesej_tema_termin DESC
LIMIT
  1

SELECT f0_.fotoesej_tema_id AS fotoesej_tema_id_0, f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1, f0_.fotoesej_tema_text AS fotoesej_tema_text_2, f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3, f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4, f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5, f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6, f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7 FROM fotoesej_tema f0_ WHERE f0_.fotoesej_tema_termin <= '2026-05-01 22:39:35' AND f0_.fotoesej_tema_fotek > 0 ORDER BY f0_.fotoesej_tema_termin DESC LIMIT 1;

SELECT
  h.hodnoceni_id AS rating_id,
  h.hodnoceni_datum AS rating_date,
  h.hodnoceni_text AS rating_text,
  f.foto_id AS photo_id,
  f.foto_titulek AS photo_title,
  f.foto_soubor AS photo_path,
  rater.autor_id AS rater_id,
  rater.autor_jmeno AS rater_first,
  rater.autor_prijmeni AS rater_last
FROM
  hodnoceni h
  JOIN foto f ON f.foto_id = h.hodnoceni_foto_id
  JOIN autor rater ON rater.autor_id = h.hodnoceni_autor
WHERE
  f.foto_kos = 0
  AND f.foto_autor != 3
  AND h.hodnoceni_text IS NOT NULL
  AND CHAR_LENGTH(
    REGEXP_REPLACE(
      h.hodnoceni_text, '[[:space:]]',
      ''
    )
  ) > 2
ORDER BY
  h.hodnoceni_id DESC
LIMIT
  15

SELECT h.hodnoceni_id AS rating_id, h.hodnoceni_datum AS rating_date, h.hodnoceni_text AS rating_text,
                    f.foto_id AS photo_id, f.foto_titulek AS photo_title, f.foto_soubor AS photo_path,
                    rater.autor_id AS rater_id, rater.autor_jmeno AS rater_first, rater.autor_prijmeni AS rater_last
             FROM hodnoceni h
             JOIN foto f ON f.foto_id = h.hodnoceni_foto_id
             JOIN autor rater ON rater.autor_id = h.hodnoceni_autor
             WHERE f.foto_kos = 0 AND f.foto_autor != 3
               AND h.hodnoceni_text IS NOT NULL
               AND CHAR_LENGTH(REGEXP_REPLACE(h.hodnoceni_text, '[[:space:]]', '')) > 2
             ORDER BY h.hodnoceni_id DESC
             LIMIT 15;