Query Metrics
5
Database Queries
5
Different statements
6.22 ms
Query time
0
Invalid entities
59
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.50 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:
[
9371
]
|
||||||||||||||||||||||||||||
| 2 | 3.67 ms |
SELECT count(DISTINCT f0_.foto_id) AS sclr_0 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = ?
Parameters:
[
9371
]
|
||||||||||||||||||||||||||||
| 3 | 0.54 ms |
SELECT DISTINCT f0_.foto_id AS foto_id_0, f0_.foto_datum AS foto_datum_1, f0_.foto_id AS foto_id_2 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = ? ORDER BY f0_.foto_datum DESC, f0_.foto_id DESC LIMIT 30
Parameters:
[
9371
]
|
||||||||||||||||||||||||||||
| 4 | 1.23 ms |
SELECT f0_.foto_id AS foto_id_0, f0_.foto_soubor AS foto_soubor_1, f0_.foto_autor AS foto_autor_2, f0_.foto_titulek AS foto_titulek_3, f0_.foto_datum AS foto_datum_4, f0_.foto_body AS foto_body_5, f0_.foto_hodnoceni AS foto_hodnoceni_6, f0_.foto_komentaru AS foto_komentaru_7, f0_.foto_pocitadlo AS foto_pocitadlo_8, f0_.foto_kos AS foto_kos_9, f0_.foto_bd_px AS foto_bd_px_10, f0_.foto_bd_col AS foto_bd_col_11, f0_.foto_bg_col AS foto_bg_col_12, f0_.foto_width AS foto_width_13, f0_.foto_height AS foto_height_14, f0_.mazat AS mazat_15, f0_.tagy AS tagy_16, f0_.popis AS popis_17, f0_.foto_technika AS foto_technika_18, f0_.foto_poznamka AS foto_poznamka_19, f0_.foto_prodej AS foto_prodej_20, a1_.autor_id AS autor_id_21, a1_.autor_login AS autor_login_22, a1_.autor_pass AS autor_pass_23, a1_.autor_pass2 AS autor_pass2_24, a1_.autor_mail AS autor_mail_25, a1_.autor_jmeno AS autor_jmeno_26, a1_.autor_prijmeni AS autor_prijmeni_27, a1_.autor_blok AS autor_blok_28, a1_.autor_ikonka AS autor_ikonka_29, a1_.autor_body AS autor_body_30, a1_.autor_fotek AS autor_fotek_31, a1_.autor_komentaru AS autor_komentaru_32, a1_.autor_hodnoceni AS autor_hodnoceni_33, a1_.autor_predplatne AS autor_predplatne_34, a1_.autor_technika AS autor_technika_35, a1_.autor_poznamka AS autor_poznamka_36, a1_.autor_prodejni_info AS autor_prodejni_info_37, a1_.autor_ip AS autor_ip_38, a1_.autor_prihlaseni AS autor_prihlaseni_39, a1_.autor_last_upload AS autor_last_upload_40, a1_.autor_ftp AS autor_ftp_41, a1_.autor_mailpp AS autor_mailpp_42, a1_.autor_posta AS autor_posta_43, a1_.autor_postanew AS autor_postanew_44, a1_.lat AS lat_45, a1_.lon AS lon_46, a1_.heslo_token AS heslo_token_47, a1_.heslo_token_platnost AS heslo_token_platnost_48, a1_.novinky_zasilat AS novinky_zasilat_49, a1_.novinky_token AS novinky_token_50, a1_.autor_flag_bazar AS autor_flag_bazar_51, a1_.autor_flag_bmfoto AS autor_flag_bmfoto_52, a1_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_53, a1_.autor_flag_posta_back AS autor_flag_posta_back_54, a1_.autor_flag_posta_pocet AS autor_flag_posta_pocet_55, a1_.autor_flag_profil AS autor_flag_profil_56, a1_.autor_flag_clanky AS autor_flag_clanky_57, a1_.autor_flag_beztlach AS autor_flag_beztlach_58, a1_.autor_flag_foto_kom AS autor_flag_foto_kom_59, a1_.autor_flag_bmstart AS autor_flag_bmstart_60, a1_.autor_flag_default_bodovani AS autor_flag_default_bodovani_61, a1_.autor_role AS autor_role_62, f0_.foto_autor AS foto_autor_63 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = ? AND f0_.foto_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.foto_datum DESC, f0_.foto_id DESC
Parameters:
[ 9371 353022 317461 249299 247568 235606 213862 204922 186633 184872 162709 161268 159299 158621 157863 154867 152599 151751 149419 147501 128941 127565 126855 113222 112453 111941 109385 103821 102828 102306 101451 ] |
||||||||||||||||||||||||||||
| 5 | 0.27 ms |
SELECT t0.kategorie_id AS kategorie_id_1, t0.kategorie_nazev AS kategorie_nazev_2, t0.url AS url_3, t0.title AS title_4, t0.metadescription AS metadescription_5, t0.h1 AS h1_6, t0.description AS description_7 FROM kategorie t0 ORDER BY t0.kategorie_nazev ASC
Parameters:
[]
|
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\Photo\Photo | 30 |
| App\Entity\Photo\Category | 28 |
| App\Entity\User\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User\User | No errors. |
| App\Entity\Photo\Photo | No errors. |
| App\Entity\Photo\Category | No errors. |