Query Metrics
3
Database Queries
3
Different statements
3.23 ms
Query time
0
Invalid entities
161
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.23 ms |
SELECT t0.fotoesej_tema_id AS fotoesej_tema_id_1, t0.fotoesej_tema_nazev AS fotoesej_tema_nazev_2, t0.fotoesej_tema_text AS fotoesej_tema_text_3, t0.fotoesej_tema_datum AS fotoesej_tema_datum_4, t0.fotoesej_tema_termin AS fotoesej_tema_termin_5, t0.fotoesej_tema_fotek AS fotoesej_tema_fotek_6, t0.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_7, t0.fotoesej_tema_autorid AS fotoesej_tema_autorid_8 FROM fotoesej_tema t0 WHERE t0.fotoesej_tema_id = ?
Parameters:
[
22
]
|
||||||||||||||||||||||||||
| 2 | 1.11 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, f0_.fotoesej_foto_autorid AS fotoesej_foto_autorid_45, f0_.fotoesej_foto_temaid AS fotoesej_foto_temaid_46 FROM fotoesej_foto f0_ LEFT JOIN autor a1_ ON f0_.fotoesej_foto_autorid = a1_.autor_id WHERE f0_.fotoesej_foto_temaid = ? ORDER BY f0_.fotoesej_foto_hlasu DESC
Parameters:
[
22
]
|
||||||||||||||||||||||||||
| 3 | 1.89 ms |
SELECT f0_.fotoesej_diskuze_id AS fotoesej_diskuze_id_0, f0_.fotoesej_diskuze_text AS fotoesej_diskuze_text_1, f0_.fotoesej_diskuze_datum AS fotoesej_diskuze_datum_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, f0_.fotoesej_diskuze_tema_id AS fotoesej_diskuze_tema_id_45, f0_.fotoesej_diskuze_autor_id AS fotoesej_diskuze_autor_id_46 FROM fotoesej_diskuze f0_ LEFT JOIN autor a1_ ON f0_.fotoesej_diskuze_autor_id = a1_.autor_id WHERE f0_.fotoesej_diskuze_tema_id = ? ORDER BY f0_.fotoesej_diskuze_datum DESC
Parameters:
[
22
]
|
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\ThemeComment | 77 |
| App\Entity\User\User | 48 |
| App\Entity\Contest\ContestPhoto | 35 |
| App\Entity\Contest\Theme | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Contest\Theme | No errors. |
| App\Entity\User\User | No errors. |
| App\Entity\Contest\ContestPhoto | No errors. |
| App\Entity\Contest\ThemeComment | No errors. |