Query Metrics
2
Database Queries
2
Different statements
0.86 ms
Query time
0
Invalid entities
2
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.33 ms |
SELECT t0_.techkarty_id AS techkarty_id_0, t0_.techkarty_nazev AS techkarty_nazev_1, t0_.techkarty_pic AS techkarty_pic_2, t0_.techkarty_url AS techkarty_url_3, t0_.techkarty_spec AS techkarty_spec_4, t0_.techkarty_hodnoceni AS techkarty_hodnoceni_5, t0_.techkarty_komentare AS techkarty_komentare_6, t0_.techkarty_datum AS techkarty_datum_7, t1_.techkategorie_id AS techkategorie_id_8, t1_.techkategorie_nazev AS techkategorie_nazev_9, t0_.techkarty_kategorie AS techkarty_kategorie_10 FROM techkarty t0_ LEFT JOIN techkategorie t1_ ON t0_.techkarty_kategorie = t1_.techkategorie_id WHERE t0_.techkarty_id = ?
Parameters:
[
75
]
|
||||||||||||||||||||||||||
| 2 | 0.53 ms |
SELECT t0_.techhodnoceni_id AS techhodnoceni_id_0, t0_.techhodnoceni_body AS techhodnoceni_body_1, t0_.techhodnoceni_text AS techhodnoceni_text_2, t0_.techhodnoceni_klady AS techhodnoceni_klady_3, t0_.techhodnoceni_zapory AS techhodnoceni_zapory_4, t0_.techhodnoceni_datum AS techhodnoceni_datum_5, a1_.autor_id AS autor_id_6, a1_.autor_login AS autor_login_7, a1_.autor_pass AS autor_pass_8, a1_.autor_pass2 AS autor_pass2_9, a1_.autor_mail AS autor_mail_10, a1_.autor_jmeno AS autor_jmeno_11, a1_.autor_prijmeni AS autor_prijmeni_12, a1_.autor_blok AS autor_blok_13, a1_.autor_ikonka AS autor_ikonka_14, a1_.autor_body AS autor_body_15, a1_.autor_fotek AS autor_fotek_16, a1_.autor_komentaru AS autor_komentaru_17, a1_.autor_hodnoceni AS autor_hodnoceni_18, a1_.autor_predplatne AS autor_predplatne_19, a1_.autor_technika AS autor_technika_20, a1_.autor_poznamka AS autor_poznamka_21, a1_.autor_prodejni_info AS autor_prodejni_info_22, a1_.autor_ip AS autor_ip_23, a1_.autor_prihlaseni AS autor_prihlaseni_24, a1_.autor_last_upload AS autor_last_upload_25, a1_.autor_ftp AS autor_ftp_26, a1_.autor_mailpp AS autor_mailpp_27, a1_.autor_posta AS autor_posta_28, a1_.autor_postanew AS autor_postanew_29, a1_.lat AS lat_30, a1_.lon AS lon_31, a1_.heslo_token AS heslo_token_32, a1_.heslo_token_platnost AS heslo_token_platnost_33, a1_.novinky_zasilat AS novinky_zasilat_34, a1_.novinky_token AS novinky_token_35, a1_.autor_flag_bazar AS autor_flag_bazar_36, a1_.autor_flag_bmfoto AS autor_flag_bmfoto_37, a1_.autor_flag_odeslana_posta AS autor_flag_odeslana_posta_38, a1_.autor_flag_posta_back AS autor_flag_posta_back_39, a1_.autor_flag_posta_pocet AS autor_flag_posta_pocet_40, a1_.autor_flag_profil AS autor_flag_profil_41, a1_.autor_flag_clanky AS autor_flag_clanky_42, a1_.autor_flag_beztlach AS autor_flag_beztlach_43, a1_.autor_flag_foto_kom AS autor_flag_foto_kom_44, a1_.autor_flag_bmstart AS autor_flag_bmstart_45, a1_.autor_flag_default_bodovani AS autor_flag_default_bodovani_46, a1_.autor_role AS autor_role_47, t0_.techhodnoceni_technika_id AS techhodnoceni_technika_id_48, t0_.techhodnoceni_autor_id AS techhodnoceni_autor_id_49 FROM techhodnoceni t0_ LEFT JOIN autor a1_ ON t0_.techhodnoceni_autor_id = a1_.autor_id WHERE t0_.techhodnoceni_technika_id = ? ORDER BY t0_.techhodnoceni_datum DESC
Parameters:
[
75
]
|
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\Review\TechCard | 1 |
| App\Entity\Review\TechCategory | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Review\TechCard | No errors. |
| App\Entity\Review\TechCategory | No errors. |
| App\Entity\Review\TechReview | No errors. |
| App\Entity\User\User | No errors. |