GET https://xkodev.dot11.cz/prace/detail/custom/1

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.51 ms
SELECT t0.id AS id_1, t0.oznaceni AS oznaceni_2, t0.titulek_cs AS titulek_cs_3, t0.popis_cs AS popis_cs_4, t0.pozadujeme_cs AS pozadujeme_cs_5, t0.nabizime_cs AS nabizime_cs_6, t0.adresa_pracoviste_adresa AS adresa_pracoviste_adresa_7, t0.adresa_pracoviste_id_mesta AS adresa_pracoviste_id_mesta_8, t0.mzda_od AS mzda_od_9, t0.mzda_do AS mzda_do_10, t0.pocet_dni AS pocet_dni_11, t0.emaily AS emaily_12, t0.zobraz_telefon AS zobraz_telefon_13, t0.is_deleted AS is_deleted_14, t0.created_at AS created_at_15, t0.forma_prace AS forma_prace_16, t0.casova_flexibilita AS casova_flexibilita_17, t0.vhodne_pro AS vhodne_pro_18, t0.typ_omezeni AS typ_omezeni_19, t0.fyzicke_prostredi AS fyzicke_prostredi_20, t0.flexibilita_prace AS flexibilita_prace_21, t0.benefity_podpora AS benefity_podpora_22, t0.pristupnost_pracoviste AS pristupnost_pracoviste_23, t0.specifikace_zdravotni_stav AS specifikace_zdravotni_stav_24, t0.benefity AS benefity_25, t0.smeny AS smeny_26, t0.termin_brigady_od AS termin_brigady_od_27, t0.termin_brigady_do AS termin_brigady_do_28, t0.id_sekce AS id_sekce_29, t0.id_statu AS id_statu_30, t0.id_mesta AS id_mesta_31, t0.id_pozice AS id_pozice_32, t0.termin_od AS termin_od_33, t0.mzda_typ AS mzda_typ_34, t0.mzda_mena AS mzda_mena_35, t0.pocet_mist AS pocet_mist_36, t0.id_min_vzdelani AS id_min_vzdelani_37, t0.uzivatel_zdroj_id AS uzivatel_zdroj_id_38, t0.created_by_id AS created_by_id_39 FROM ad_custom_inzerat t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.32 ms
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:
[
  3
]
3 0.25 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.phone_no AS phone_no_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.is_approved AS is_approved_9, t0.reg_reasons AS reg_reasons_10, t0.updated_by_id AS updated_by_id_11, t0.approved_by_id AS approved_by_id_12, t0.uploadable_id AS uploadable_id_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.86 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.headquarter AS headquarter_4, t0.ico AS ico_5, t0.dic AS dic_6, t0.bank_no AS bank_no_7, t0.correspondece AS correspondece_8, t0.approved AS approved_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.nationwide AS nationwide_12, t0.slug AS slug_13, t0.changes_md_sum AS changes_md_sum_14, t0.approved_by_id AS approved_by_id_15, t0.owner_id AS owner_id_16, t0.logo_id AS logo_id_17 FROM company t0 INNER JOIN user_company ON t0.id = user_company.company_id WHERE user_company.user_id = ?
Parameters:
[
  1
]
5 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.headquarter AS headquarter_4, t0.ico AS ico_5, t0.dic AS dic_6, t0.bank_no AS bank_no_7, t0.correspondece AS correspondece_8, t0.approved AS approved_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.nationwide AS nationwide_12, t0.slug AS slug_13, t0.changes_md_sum AS changes_md_sum_14, t0.approved_by_id AS approved_by_id_15, t0.owner_id AS owner_id_16, t0.logo_id AS logo_id_17 FROM company t0 WHERE t0.owner_id = ? LIMIT 1
Parameters:
[
  1
]
6 0.23 ms
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:
[]
7 0.24 ms
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
]
8 0.23 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_sekce t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.18 ms
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:
[
  500011
]
10 0.17 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_termin t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 0.16 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_mzda_mena t0 WHERE t0.id = ?
Parameters:
[
  2
]
12 0.16 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_mzda_typ t0 WHERE t0.id = ?
Parameters:
[
  28
]
13 0.16 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_pocet_mist t0 WHERE t0.id = ?
Parameters:
[
  2
]
14 0.17 ms
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
]
15 0.16 ms
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:
[
  369
]
16 0.16 ms
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:
[
  370
]
17 0.16 ms
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:
[
  371
]
18 0.16 ms
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:
[
  372
]
19 0.16 ms
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:
[
  373
]
20 0.16 ms
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:
[
  374
]

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\custom\customInzerat 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\coInzeratPocetMist 1
App\Entity\Ad\coInzeratMinVzdelani 1
App\Entity\User 1
App\Entity\Ad\coInzeratObor 1