Query Metrics
5
Database Queries
5
Different statements
5.83 ms
Query time
0
Invalid entities
11
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.00 ms |
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_zdroje = ? LIMIT 1
Parameters:
[
"6232041"
]
|
||||||||||||||||||||||||||||
| 2 | 0.41 ms |
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_zdroje = ? LIMIT 1
Parameters:
[
2032212
]
|
||||||||||||||||||||||||||||
| 3 | 0.20 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||
| 4 | 0.36 ms |
INSERT INTO ad_api_buffer (message, status, added, error_message) VALUES (?, ?, ?, ?)
Parameters:
[
"""
<?xml version="1.0" encoding="UTF-8"?>\n
<inzeraty>\n
<prihlaseni>\n
<id>52</id>\n
<heslo>fdJOpgfd66xDa0</heslo>\n
</prihlaseni>\n
<pridani>\n
<id_sekce><![CDATA[1]]></id_sekce>\n
<id_zdroje><![CDATA[6232041]]></id_zdroje>\n
<uzivatele_id_zdroje><![CDATA[2032212]]></uzivatele_id_zdroje>\n
<oznaceni><![CDATA[Globus Fresh]]></oznaceni>\n
<titulek_cs><![CDATA[Bezpečnostní pracovník/ce - prodejna Brno - střed vhodné i pro OZP i OZZ.]]></titulek_cs>\n
<popis_cs><![CDATA[Hledáme spolehlivé a zodpovědné bezpečnostního pracovníky pro zajištění bezpečnosti a ochrany majetku na prodejně v centru Brna. \n
\n
Vaší náplní práce bude: \n
- prevence krádeží. \n
- obchůzková činnost a řešení vzniklých situací. \n
- práce v rámci otevírací doby prodejny.\n
\n
Nabízíme stabilní zaměstnání a férové podmínky.]]></popis_cs>\n
<pozadujeme_cs><![CDATA[- Spolehlivost,\n
- Zodpovědnost\n
- Trestní bezúhonnost. \n
\n
Praxe v oboru vítána, ale není podmínkou.]]></pozadujeme_cs>\n
<nabizime_cs><![CDATA[- Možnost DPP/HPP\n
- Pravidelnou mzdu\n
- Kompletní vystrojení \n
- Odměny za záchytovost]]></nabizime_cs>\n
<id_statu><![CDATA[88]]></id_statu>\n
<id_mesta><![CDATA[582786]]></id_mesta>\n
<id_pozice><![CDATA[47]]></id_pozice>\n
<adresa_pracoviste_adresa><![CDATA[Brno]]></adresa_pracoviste_adresa>\n
<adresa_pracoviste_id_mesta><![CDATA[582786]]></adresa_pracoviste_id_mesta>\n
<id_kategorie_brigad><![CDATA[2]]></id_kategorie_brigad>\n
<termin_od><![CDATA[2]]></termin_od>\n
<termin_do><![CDATA[]]></termin_do>\n
<mzda_od><![CDATA[180]]></mzda_od>\n
<mzda_do><![CDATA[180]]></mzda_do>\n
<mzda_typ><![CDATA[1]]></mzda_typ>\n
<mzda_mena><![CDATA[1]]></mzda_mena>\n
<pocet_mist><![CDATA[3]]></pocet_mist>\n
<pocet_dni><![CDATA[15]]></pocet_dni>\n
<vhodne_pro>\n
<h><![CDATA[4]]></h>\n
</vhodne_pro>\n
<pohlavi>\n
<h><![CDATA[1]]></h>\n
<h><![CDATA[2]]></h>\n
</pohlavi>\n
<vek>\n
<h><![CDATA[5]]></h>\n
<h><![CDATA[6]]></h>\n
<h><![CDATA[7]]></h>\n
<h><![CDATA[8]]></h>\n
</vek>\n
<doplneni>\n
</doplneni>\n
<emaily>\n
<h><![CDATA[toscani@centr.cz]]></h>\n
</emaily>\n
<zobraz_telefon><![CDATA[1]]></zobraz_telefon>\n
</pridani>\n
</inzeraty>\n
"""
1
"2026-02-24 14:41:59"
null
]
|
||||||||||||||||||||||||||||
| 5 | 3.87 ms |
"COMMIT"
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\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\Uzivatel | 1 |
| App\Entity\Ad\Firma | 1 |
| App\Entity\Ad\ApiBuffer | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Ad\Inzerat | No errors. |
| App\Entity\Ad\coInzeratSekce | No errors. |
| App\Entity\Ad\coInzeratStat | No errors. |
| App\Entity\Ad\coInzeratMesto | No errors. |
| App\Entity\Ad\coInzeratPozice | No errors. |
| App\Entity\Ad\coInzeratTermin | No errors. |
| App\Entity\Ad\coInzeratMzdaTyp | No errors. |
| App\Entity\Ad\coInzeratMzdaMena | No errors. |
| App\Entity\Ad\coInzeratPocetMist | No errors. |
| App\Entity\Ad\coInzeratMinVzdelani | No errors. |
| App\Entity\Ad\Uzivatel | No errors. |
| App\Entity\Ad\Firma | No errors. |
| App\Entity\Ad\ApiBuffer | No errors. |