Query Metrics
6
Database Queries
5
Different statements
2.80 ms
Query time
0
Invalid entities
39
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.41 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:
[
9036
]
|
||||||||||||||||||||||||||||
| 2 | 0.94 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:
[
9036
]
|
||||||||||||||||||||||||||||
| 3 | 0.42 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:
[
9036
]
|
||||||||||||||||||||||||||||
| 4 | 0.68 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:
[ 9036 123054 123048 123034 123023 123014 123003 123002 122994 122990 122984 122963 122633 122187 122165 122160 122159 122133 122129 121694 121682 121659 121651 121263 120519 119908 119907 119902 119899 119892 119891 ] |
||||||||||||||||||||||||||||
| 5 | 0.20 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:
[
1
]
|
||||||||||||||||||||||||||||
| 6 | 0.15 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:
[
3
]
|
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\Forum\ForumPost | 30 |
| App\Entity\User\User | 4 |
| App\Entity\Forum\ForumThread | 3 |
| App\Entity\Forum\ForumCategory | 2 |
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. |