GET https://xkodev.dot11.cz/prace/detail/api/782

Query Metrics

20 Database Queries
14 Different statements
4.19 ms Query time
0 Invalid entities
33 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.16 ms
(27.58%)
7
SELECT t0.id AS id_1, t0.file AS file_2, t0.updated_at AS updated_at_3 FROM uploaded t0 WHERE t0.id = ?
Parameters:
[
  473
]
0.42 ms
(10.11%)
1
SELECT t0.id AS id_1, t0.id_zdroje AS id_zdroje_2, t0.uzivatele_id_zdroje AS uzivatele_id_zdroje_3, t0.oznaceni AS oznaceni_4, t0.titulek_cs AS titulek_cs_5, t0.popis_cs AS popis_cs_6, t0.pozadujeme_cs AS pozadujeme_cs_7, t0.nabizime_cs AS nabizime_cs_8, t0.adresa_pracoviste_adresa AS adresa_pracoviste_adresa_9, t0.adresa_pracoviste_id_mesta AS adresa_pracoviste_id_mesta_10, t0.mzda_od AS mzda_od_11, t0.mzda_do AS mzda_do_12, t0.pocet_dni AS pocet_dni_13, t0.vhodne_pro AS vhodne_pro_14, t0.uvazek AS uvazek_15, t0.emaily AS emaily_16, t0.zobraz_telefon AS zobraz_telefon_17, t0.is_deleted AS is_deleted_18, t0.created_at AS created_at_19, t0.id_sekce AS id_sekce_20, t0.id_statu AS id_statu_21, t0.id_mesta AS id_mesta_22, t0.id_pozice AS id_pozice_23, t0.termin_od AS termin_od_24, t0.mzda_typ AS mzda_typ_25, t0.mzda_mena AS mzda_mena_26, t0.pocet_mist AS pocet_mist_27, t0.id_min_vzdelani AS id_min_vzdelani_28, t0.uzivatel_zdroj_id AS uzivatel_zdroj_id_29 FROM ad_inzerat t0 WHERE t0.id = ?
Parameters:
[
  782
]
0.29 ms
(6.94%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.id_oboru AS id_oboru_3, t0.is_brigada AS is_brigada_4, t0.is_pozice AS is_pozice_5, t0.id_oboru AS id_oboru_6 FROM ad_co_inzerat_pozice t0 WHERE t0.id = ?
Parameters:
[
  501
]
0.25 ms
(6.03%)
1
SELECT t0.id AS id_1, t0.id_zdroje AS id_zdroje_2, t0.nazev AS nazev_3, t0.ico AS ico_4, t0.dic AS dic_5, t0.ulice AS ulice_6, t0.mesto AS mesto_7, t0.url AS url_8, t0.popis AS popis_9, t0.logo_source AS logo_source_10, t0.id_inzerenta AS id_inzerenta_11, t0.is_deleted AS is_deleted_12, t0.logo_id AS logo_id_13 FROM ad_firma t0 WHERE t0.id = ?
Parameters:
[
  18
]
0.25 ms
(6.01%)
1
SELECT t0.id AS id_1, t0.id_zdroje AS id_zdroje_2, t0.firmy_id_zdroje AS firmy_id_zdroje_3, t0.email AS email_4, t0.jmeno AS jmeno_5, t0.prijmeni AS prijmeni_6, t0.predvolba_telefon AS predvolba_telefon_7, t0.telefon AS telefon_8, t0.is_deleted AS is_deleted_9, t0.firma_zdroj_id AS firma_zdroj_id_10 FROM ad_uzivatel t0 WHERE t0.id = ?
Parameters:
[
  19
]
0.25 ms
(5.97%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.general_partner AS general_partner_3, t0.web_url AS web_url_4, t0.poradi AS poradi_5, t0.logo_id AS logo_id_6 FROM partners t0 ORDER BY t0.poradi ASC
Parameters:
[]
0.25 ms
(5.92%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.active AS active_4, t0.poradi AS poradi_5 FROM main_menu_items t0 WHERE t0.active = ? ORDER BY t0.poradi ASC
Parameters:
[
  1
]
0.24 ms
(5.63%)
1
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_mzda_mena t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.20 ms
(4.70%)
1
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_obor t0 WHERE t0.id = ?
Parameters:
[
  196
]
0.20 ms
(4.70%)
1
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_mzda_typ t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.20 ms
(4.68%)
1
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_termin t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.18 ms
(4.20%)
1
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_min_vzdelani t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.16 ms
(3.91%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.id_kraje AS id_kraje_3, t0.id_okresu AS id_okresu_4 FROM ad_co_inzerat_mesto t0 WHERE t0.id = ?
Parameters:
[
  573094
]
0.15 ms
(3.62%)
1
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_sekce t0 WHERE t0.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\Partners 7
App\Entity\Uploaded 7
App\Entity\MainMenuItems 7
App\Entity\Ad\Inzerat 1
App\Entity\Ad\coInzeratSekce 1
App\Entity\Ad\coInzeratStat 1
App\Entity\Ad\coInzeratMesto 1
App\Entity\Ad\coInzeratPozice 1
App\Entity\Ad\coInzeratTermin 1
App\Entity\Ad\coInzeratMzdaTyp 1
App\Entity\Ad\coInzeratMzdaMena 1
App\Entity\Ad\coInzeratMinVzdelani 1
App\Entity\Ad\Uzivatel 1
App\Entity\Ad\coInzeratObor 1
App\Entity\Ad\Firma 1