GET https://beta22.photopost.cz/autor/9241/fora

Query Metrics

5 Database Queries
5 Different statements
2.26 ms Query time
0 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 0.64 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:
[
  9241
]
2 0.69 ms
SELECT count(DISTINCT a0_.auditorium_id) AS sclr_0 FROM auditorium a0_ LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id WHERE a0_.auditorium_autor_id = ?
Parameters:
[
  9241
]
3 0.30 ms
SELECT DISTINCT a0_.auditorium_id AS auditorium_id_0, a0_.auditorium_datum AS auditorium_datum_1 FROM auditorium a0_ LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id WHERE a0_.auditorium_autor_id = ? ORDER BY a0_.auditorium_datum DESC LIMIT 30
Parameters:
[
  9241
]
4 0.40 ms
SELECT a0_.auditorium_id AS auditorium_id_0, a0_.auditorium_text AS auditorium_text_1, a0_.auditorium_datum AS auditorium_datum_2, a0_.auditorium_obrazek AS auditorium_obrazek_3, a1_.forum_id AS forum_id_4, a1_.forum_nazev AS forum_nazev_5, a1_.forum_popis AS forum_popis_6, a1_.forum_date AS forum_date_7, a1_.forum_status AS forum_status_8, a1_.forum_prispevku AS forum_prispevku_9, a1_.forum_posledni AS forum_posledni_10, a1_.forum_obrazek AS forum_obrazek_11, a1_.auditorium_forum_priv AS auditorium_forum_priv_12, a1_.proneprihlasene AS proneprihlasene_13, a0_.auditorium_autor_id AS auditorium_autor_id_14, a0_.auditorium_forum_id AS auditorium_forum_id_15, a1_.forum_autor_id AS forum_autor_id_16, a1_.forum_kat_id AS forum_kat_id_17 FROM auditorium a0_ LEFT JOIN auditorium_forum a1_ ON a0_.auditorium_forum_id = a1_.forum_id WHERE a0_.auditorium_autor_id = ? AND a0_.auditorium_id IN (?) ORDER BY a0_.auditorium_datum DESC
Parameters:
[
  9241
  610195
]
5 0.24 ms
SELECT t0.auditorium_kat_id AS auditorium_kat_id_1, t0.auditorium_kat_name AS auditorium_kat_name_2, t0.auditorium_kat_desc AS auditorium_kat_desc_3 FROM auditorium_kat t0 WHERE t0.auditorium_kat_id = ?
Parameters:
[
  5
]

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 2
App\Entity\Forum\ForumPost 1
App\Entity\Forum\ForumThread 1
App\Entity\Forum\ForumCategory 1

Entities Mapping

Class Mapping errors
App\Entity\User\User No errors.
App\Entity\Forum\ForumPost No errors.
App\Entity\Forum\ForumThread No errors.
App\Entity\Forum\ForumCategory No errors.