Query Metrics
11
Database Queries
9
Different statements
3.93 ms
Query time
0
Invalid entities
12
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.58 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_id = ? AND f0_.foto_kos = 0
Parameters:
[
477710
]
|
||||||||||||||||||||||||||||||
| 2 | 0.15 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 3 | 0.41 ms |
UPDATE foto SET foto_pocitadlo = ? WHERE foto_id = ?
Parameters:
[ 64 477710 ]
|
||||||||||||||||||||||||||||||
| 4 | 0.23 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 5 | 0.49 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, f0_.foto_autor AS foto_autor_21 FROM foto f0_ WHERE f0_.foto_kos = 0 AND f0_.foto_id <> ? AND (f0_.foto_datum > ? OR (f0_.foto_datum = ? AND f0_.foto_id > ?)) ORDER BY f0_.foto_datum ASC, f0_.foto_id ASC LIMIT 1
Parameters:
[ 477710 "2026-02-19 21:29:04" "2026-02-19 21:29:04" 477710 ]
|
||||||||||||||||||||||||||||||
| 6 | 0.40 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, f0_.foto_autor AS foto_autor_21 FROM foto f0_ WHERE f0_.foto_kos = 0 AND f0_.foto_id <> ? AND (f0_.foto_datum < ? OR (f0_.foto_datum = ? AND f0_.foto_id < ?)) ORDER BY f0_.foto_datum DESC, f0_.foto_id DESC LIMIT 1
Parameters:
[ 477710 "2026-02-19 21:29:04" "2026-02-19 21:29:04" 477710 ]
|
||||||||||||||||||||||||||||||
| 7 | 0.29 ms |
SELECT t0.hodnoceni_id AS hodnoceni_id_1, t0.hodnoceni_autor AS hodnoceni_autor_2, t0.hodnoceni_foto_id AS hodnoceni_foto_id_3, t0.hodnoceni_foto_autor AS hodnoceni_foto_autor_4, t0.hodnoceni_body AS hodnoceni_body_5, t0.hodnoceni_text AS hodnoceni_text_6, t0.hodnoceni_datum AS hodnoceni_datum_7, t0.foto_soubor AS foto_soubor_8, t0.hodnoceni_autor AS hodnoceni_autor_9, t0.hodnoceni_foto_id AS hodnoceni_foto_id_10, t0.hodnoceni_foto_autor AS hodnoceni_foto_autor_11 FROM hodnoceni t0 WHERE t0.hodnoceni_foto_id = ? ORDER BY t0.hodnoceni_datum DESC
Parameters:
[
477710
]
|
||||||||||||||||||||||||||||||
| 8 | 0.28 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 INNER JOIN foto_kategorie ON t0.kategorie_id = foto_kategorie.kategorie_id WHERE foto_kategorie.foto_id = ?
Parameters:
[
477710
]
|
||||||||||||||||||||||||||||||
| 9 | 0.47 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:
[
117504
]
|
||||||||||||||||||||||||||||||
| 10 | 0.30 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:
[
17530
]
|
||||||||||||||||||||||||||||||
| 11 | 0.31 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:
[
2153
]
|
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 | 5 |
| App\Entity\Photo\Photo | 3 |
| App\Entity\Photo\Rating | 3 |
| App\Entity\Photo\Category | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Photo\Photo | No errors. |
| App\Entity\User\User | No errors. |
| App\Entity\Photo\Category | No errors. |
| App\Entity\Photo\Rating | No errors. |