GET https://beta22.photopost.cz/autor/111621/fototema

Response
200 OK
IP
216.73.217.0
Profiled on
Token
11e4e6

Query Metrics

3 Database Queries
3 Different statements
1.30 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.46 ms 
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 = ?
Parameters: 
[
  111621
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.42 ms 
SELECT COUNT(*) FROM fotoesej_foto WHERE fotoesej_foto_autorid = ?
Parameters: 
[
  111621
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.42 ms 
SELECT f.fotoesej_foto_id AS photo_id, f.fotoesej_foto_url AS file_path, f.fotoesej_foto_hlasu AS vote_count,
                    t.fotoesej_tema_id AS theme_id, t.fotoesej_tema_nazev AS theme_title,
                    t.fotoesej_tema_datum AS theme_start, t.fotoesej_tema_termin AS theme_deadline,
                    CASE WHEN f.fotoesej_foto_hlasu = 0 THEN NULL ELSE
                        (SELECT COUNT(DISTINCT f2.fotoesej_foto_hlasu) + 1 FROM fotoesej_foto f2
                         WHERE f2.fotoesej_foto_temaid = f.fotoesej_foto_temaid
                           AND f2.fotoesej_foto_hlasu > f.fotoesej_foto_hlasu)
                    END AS rank_in_theme
             FROM fotoesej_foto f
             JOIN fotoesej_tema t ON t.fotoesej_tema_id = f.fotoesej_foto_temaid
             WHERE f.fotoesej_foto_autorid = ?
             ORDER BY t.fotoesej_tema_termin DESC, f.fotoesej_foto_id DESC
             LIMIT 30 OFFSET 0
Parameters: 
[
  111621
]
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\User\User 1

Entities Mapping

Class Mapping errors
App\Entity\User\User No errors.