GET https://beta22.photopost.cz/fototema/foto/4264

Response
200 OK
Browse referrer URL
IP
74.7.241.34
Profiled on
Token
52feef

Query Metrics

4 Database Queries
4 Different statements
2.29 ms Query time
0 Invalid entities
7 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.50 ms 
SELECT f0_.fotoesej_foto_id AS fotoesej_foto_id_0, f0_.fotoesej_foto_url AS fotoesej_foto_url_1, f0_.fotoesej_foto_hlasu AS fotoesej_foto_hlasu_2, a1_.autor_id AS autor_id_3, a1_.autor_login AS autor_login_4, a1_.autor_pass AS autor_pass_5, a1_.autor_pass2 AS autor_pass2_6, a1_.autor_mail AS autor_mail_7, a1_.autor_jmeno AS autor_jmeno_8, a1_.autor_prijmeni AS autor_prijmeni_9, a1_.autor_blok AS autor_blok_10, a1_.autor_ikonka AS autor_ikonka_11, a1_.autor_body AS autor_body_12, a1_.autor_fotek AS autor_fotek_13, a1_.autor_komentaru AS autor_komentaru_14, a1_.autor_hodnoceni AS autor_hodnoceni_15, a1_.autor_predplatne AS autor_predplatne_16, a1_.autor_technika AS autor_technika_17, a1_.autor_poznamka AS autor_poznamka_18, a1_.autor_prodejni_info AS autor_prodejni_info_19, a1_.autor_ip AS autor_ip_20, a1_.autor_prihlaseni AS autor_prihlaseni_21, a1_.autor_last_upload AS autor_last_upload_22, a1_.autor_ftp AS autor_ftp_23, a1_.autor_mailpp AS autor_mailpp_24, a1_.autor_posta AS autor_posta_25, a1_.autor_postanew AS autor_postanew_26, a1_.lat AS lat_27, a1_.lon AS lon_28, a1_.heslo_token AS heslo_token_29, a1_.heslo_token_platnost AS heslo_token_platnost_30, a1_.novinky_zasilat AS novinky_zasilat_31, a1_.novinky_token AS novinky_token_32, a1_.autor_flag_bazar AS autor_flag_bazar_33, a1_.autor_flag_bmfoto AS autor_flag_bmfoto_34, a1_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_35, a1_.autor_flag_posta_back AS autor_flag_posta_back_36, a1_.autor_flag_posta_pocet AS autor_flag_posta_pocet_37, a1_.autor_flag_profil AS autor_flag_profil_38, a1_.autor_flag_clanky AS autor_flag_clanky_39, a1_.autor_flag_beztlach AS autor_flag_beztlach_40, a1_.autor_flag_foto_kom AS autor_flag_foto_kom_41, a1_.autor_flag_bmstart AS autor_flag_bmstart_42, a1_.autor_flag_default_bodovani AS autor_flag_default_bodovani_43, a1_.autor_role AS autor_role_44, f2_.fotoesej_tema_id AS fotoesej_tema_id_45, f2_.fotoesej_tema_nazev AS fotoesej_tema_nazev_46, f2_.fotoesej_tema_text AS fotoesej_tema_text_47, f2_.fotoesej_tema_datum AS fotoesej_tema_datum_48, f2_.fotoesej_tema_termin AS fotoesej_tema_termin_49, f2_.fotoesej_tema_fotek AS fotoesej_tema_fotek_50, f2_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_51, f0_.fotoesej_foto_autorid AS fotoesej_foto_autorid_52, f0_.fotoesej_foto_temaid AS fotoesej_foto_temaid_53, f2_.fotoesej_tema_autorid AS fotoesej_tema_autorid_54 FROM fotoesej_foto f0_ LEFT JOIN autor a1_ ON f0_.fotoesej_foto_autorid = a1_.autor_id LEFT JOIN fotoesej_tema f2_ ON f0_.fotoesej_foto_temaid = f2_.fotoesej_tema_id WHERE f0_.fotoesej_foto_id = ?
Parameters: 
[
  4264
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.47 ms 
SELECT f0_.fotoesej_foto_id AS fotoesej_foto_id_0, f0_.fotoesej_foto_url AS fotoesej_foto_url_1, f0_.fotoesej_foto_hlasu AS fotoesej_foto_hlasu_2, f0_.fotoesej_foto_autorid AS fotoesej_foto_autorid_3, f0_.fotoesej_foto_temaid AS fotoesej_foto_temaid_4 FROM fotoesej_foto f0_ WHERE f0_.fotoesej_foto_temaid = ? AND f0_.fotoesej_foto_id <> ? AND ((f0_.fotoesej_foto_hlasu > ? OR (f0_.fotoesej_foto_hlasu = ? AND f0_.fotoesej_foto_id > ?))) ORDER BY f0_.fotoesej_foto_hlasu ASC, f0_.fotoesej_foto_id ASC LIMIT 1
Parameters: 
[
  138
  4264
  6
  6
  4264
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.34 ms 
SELECT f0_.fotoesej_foto_id AS fotoesej_foto_id_0, f0_.fotoesej_foto_url AS fotoesej_foto_url_1, f0_.fotoesej_foto_hlasu AS fotoesej_foto_hlasu_2, f0_.fotoesej_foto_autorid AS fotoesej_foto_autorid_3, f0_.fotoesej_foto_temaid AS fotoesej_foto_temaid_4 FROM fotoesej_foto f0_ WHERE f0_.fotoesej_foto_temaid = ? AND f0_.fotoesej_foto_id <> ? AND ((f0_.fotoesej_foto_hlasu < ? OR (f0_.fotoesej_foto_hlasu = ? AND f0_.fotoesej_foto_id < ?))) ORDER BY f0_.fotoesej_foto_hlasu DESC, f0_.fotoesej_foto_id DESC LIMIT 1
Parameters: 
[
  138
  4264
  6
  6
  4264
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.97 ms 
SELECT f0_.fotoesej_hlasovani_id AS fotoesej_hlasovani_id_0, a1_.autor_id AS autor_id_1, a1_.autor_login AS autor_login_2, a1_.autor_pass AS autor_pass_3, a1_.autor_pass2 AS autor_pass2_4, a1_.autor_mail AS autor_mail_5, a1_.autor_jmeno AS autor_jmeno_6, a1_.autor_prijmeni AS autor_prijmeni_7, a1_.autor_blok AS autor_blok_8, a1_.autor_ikonka AS autor_ikonka_9, a1_.autor_body AS autor_body_10, a1_.autor_fotek AS autor_fotek_11, a1_.autor_komentaru AS autor_komentaru_12, a1_.autor_hodnoceni AS autor_hodnoceni_13, a1_.autor_predplatne AS autor_predplatne_14, a1_.autor_technika AS autor_technika_15, a1_.autor_poznamka AS autor_poznamka_16, a1_.autor_prodejni_info AS autor_prodejni_info_17, a1_.autor_ip AS autor_ip_18, a1_.autor_prihlaseni AS autor_prihlaseni_19, a1_.autor_last_upload AS autor_last_upload_20, a1_.autor_ftp AS autor_ftp_21, a1_.autor_mailpp AS autor_mailpp_22, a1_.autor_posta AS autor_posta_23, a1_.autor_postanew AS autor_postanew_24, a1_.lat AS lat_25, a1_.lon AS lon_26, a1_.heslo_token AS heslo_token_27, a1_.heslo_token_platnost AS heslo_token_platnost_28, a1_.novinky_zasilat AS novinky_zasilat_29, a1_.novinky_token AS novinky_token_30, a1_.autor_flag_bazar AS autor_flag_bazar_31, a1_.autor_flag_bmfoto AS autor_flag_bmfoto_32, a1_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_33, a1_.autor_flag_posta_back AS autor_flag_posta_back_34, a1_.autor_flag_posta_pocet AS autor_flag_posta_pocet_35, a1_.autor_flag_profil AS autor_flag_profil_36, a1_.autor_flag_clanky AS autor_flag_clanky_37, a1_.autor_flag_beztlach AS autor_flag_beztlach_38, a1_.autor_flag_foto_kom AS autor_flag_foto_kom_39, a1_.autor_flag_bmstart AS autor_flag_bmstart_40, a1_.autor_flag_default_bodovani AS autor_flag_default_bodovani_41, a1_.autor_role AS autor_role_42, f0_.fotoesej_hlasovani_autorid AS fotoesej_hlasovani_autorid_43, f0_.fotoesej_hlasovani_fotkaid AS fotoesej_hlasovani_fotkaid_44, f0_.fotoesej_hlasovani_temaid AS fotoesej_hlasovani_temaid_45 FROM fotoesej_hlasovani f0_ LEFT JOIN autor a1_ ON f0_.fotoesej_hlasovani_autorid = a1_.autor_id WHERE f0_.fotoesej_hlasovani_fotkaid = ? ORDER BY a1_.autor_prijmeni ASC, a1_.autor_jmeno ASC
Parameters: 
[
  4264
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Contest\ContestPhoto 3
App\Entity\User\User 3
App\Entity\Contest\Theme 1

Entities Mapping

Class Mapping errors
App\Entity\Contest\ContestPhoto No errors.
App\Entity\User\User No errors.
App\Entity\Contest\Theme No errors.
App\Entity\Contest\Vote No errors.