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

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 = 5399 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 = 5399 AND f0_.foto_id IN (79548, 79107, 78200, 77891, 77054, 75554, 75205, 74376, 73980, 68426, 65829, 63839, 62624, 61657, 61195, 60664, 59622, 59110, 58032, 57659, 57226, 56791, 56118, 55649, 55259, 54232, 53800, 53455, 52990, 52739) 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-11 00:34:33'
               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-08 00:34:33'
               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-11 00:34:33'
               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-08 00:34:33'
               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-11 00:34:33'
               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-08 00:34:33'
               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-11 00:34:33'
               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-08 00:34:33'
               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-12 00:34:33' AND f0_.fotoesej_tema_termin > '2026-05-02 00:34:33' 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-12 00:34:33' 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-02 00:34:33' 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;