Query Metrics
15
Database Queries
13
Different statements
9.55 ms
Query time
0
Invalid entities
12
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.31 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:
[
"6233226"
]
|
||||||||||||||||||||||||||||||
| 2 | 0.18 ms |
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_sekce t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 3 | 0.16 ms |
SELECT t0.id AS id_1, t0.label AS label_2 FROM ad_co_inzerat_stat t0 WHERE t0.id = ?
Parameters:
[
88
]
|
||||||||||||||||||||||||||||||
| 4 | 0.19 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:
[
530841
]
|
||||||||||||||||||||||||||||||
| 5 | 0.18 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:
[
216
]
|
||||||||||||||||||||||||||||||
| 6 | 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"
]
|
||||||||||||||||||||||||||||||
| 7 | 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:
[
29
]
|
||||||||||||||||||||||||||||||
| 8 | 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:
[
1
]
|
||||||||||||||||||||||||||||||
| 9 | 0.20 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:
[
2862003
]
|
||||||||||||||||||||||||||||||
| 10 | 0.10 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 11 | 0.42 ms |
INSERT INTO ad_inzerat (id_zdroje, uzivatele_id_zdroje, oznaceni, titulek_cs, popis_cs, pozadujeme_cs, nabizime_cs, adresa_pracoviste_adresa, adresa_pracoviste_id_mesta, mzda_od, mzda_do, pocet_dni, vhodne_pro, uvazek, emaily, zobraz_telefon, is_deleted, created_at, id_sekce, id_statu, id_mesta, id_pozice, termin_od, mzda_typ, mzda_mena, pocet_mist, id_min_vzdelani, uzivatel_zdroj_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 6233226 2862003 "" "Obsluha čerpací stanice Netvořice / Neveklov nástup IHNED BRIGÁDNĚ 140,- čistého" """ obsluha zákazníků\n \n příjem zboží, uskladňování a doplňování zboží\n \n úklid čerpací stanice """ "komunikativní, zodpovědnou a ochotnou osobu s příjemným vystupováním a čistým TR" """ práci na DPP\n \n zajímavou a odpovědnou práci\n \n přátelský kolektiv\n \n motivující finanční ohodnocení\n \n bonusy k platu\n \n pracovní oděv """ "Netvořice 307" 530841 "" "" 15 "["6","5","4","3","1"]" null "["netvorice@vspetrol.cz"]" 1 0 null 1 88 530841 216 1 29 1 null null 226 ]
|
||||||||||||||||||||||||||||||
| 12 | 3.57 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 13 | 0.11 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 14 | 0.28 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[6233226]]></id_zdroje>\n
<uzivatele_id_zdroje><![CDATA[2862003]]></uzivatele_id_zdroje>\n
<oznaceni><![CDATA[]]></oznaceni>\n
<titulek_cs><![CDATA[Obsluha čerpací stanice Netvořice / Neveklov nástup IHNED BRIGÁDNĚ 140,- čistého]]></titulek_cs>\n
<popis_cs><![CDATA[obsluha zákazníků\r\n
\r\n
příjem zboží, uskladňování a doplňování zboží\r\n
\r\n
úklid čerpací stanice]]></popis_cs>\n
<pozadujeme_cs><![CDATA[komunikativní, zodpovědnou a ochotnou osobu s příjemným vystupováním a čistým TR]]></pozadujeme_cs>\n
<nabizime_cs><![CDATA[práci na DPP\r\n
\r\n
zajímavou a odpovědnou práci\r\n
\r\n
přátelský kolektiv\r\n
\r\n
motivující finanční ohodnocení\r\n
\r\n
bonusy k platu\r\n
\r\n
pracovní oděv]]></nabizime_cs>\n
<id_statu><![CDATA[88]]></id_statu>\n
<id_mesta><![CDATA[530841]]></id_mesta>\n
<id_pozice><![CDATA[216]]></id_pozice>\n
<adresa_pracoviste_adresa><![CDATA[Netvořice 307]]></adresa_pracoviste_adresa>\n
<adresa_pracoviste_id_mesta><![CDATA[530841]]></adresa_pracoviste_id_mesta>\n
<id_kategorie_brigad><![CDATA[3]]></id_kategorie_brigad>\n
<termin_od><![CDATA[1]]></termin_od>\n
<termin_do><![CDATA[]]></termin_do>\n
<mzda_od><![CDATA[]]></mzda_od>\n
<mzda_do><![CDATA[]]></mzda_do>\n
<mzda_typ><![CDATA[29]]></mzda_typ>\n
<mzda_mena><![CDATA[1]]></mzda_mena>\n
<pocet_mist><![CDATA[1]]></pocet_mist>\n
<pocet_dni><![CDATA[15]]></pocet_dni>\n
<vhodne_pro>\n
<h><![CDATA[6]]></h>\n
<h><![CDATA[5]]></h>\n
<h><![CDATA[4]]></h>\n
<h><![CDATA[3]]></h>\n
<h><![CDATA[1]]></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[netvorice@vspetrol.cz]]></h>\n
</emaily>\n
<zobraz_telefon><![CDATA[1]]></zobraz_telefon>\n
</pridani>\n
</inzeraty>\n
"""
1
"2026-02-25 09:00:15"
null
]
|
||||||||||||||||||||||||||||||
| 15 | 3.37 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\coInzeratSekce | 1 |
| App\Entity\Ad\coInzeratStat | 1 |
| App\Entity\Ad\coInzeratMesto | 1 |
| App\Entity\Ad\coInzeratPozice | 1 |
| App\Entity\Ad\coInzeratObor | 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\Inzerat | 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\coInzeratObor | No errors. |
| App\Entity\Ad\Firma | No errors. |
| App\Entity\Ad\ApiBuffer | No errors. |