string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
string(8) "test dan"
b
bool(false)
string(8) "test dan"
int(1)
string(8) "test dan"
int(1)
>
>
>
>
>
>
>
>
>
>
Stáhni si ZDARMA apku a pojď na to!
s.id=>147
s.kontroler=>inzeraty/vypis/hlavni/i.vypis.hlavni.php
s.uri_cs=>prace/**
s.uri_sk=>
s.nazev_cz=>Inzeráty výpis
s.nazev_sk=>Inzeráty výpis
s.titulek_cz=>Inzeráty výpis
s.titulek_sk=>Inzeráty výpis
s.popis_cz=>Inzeráty výpis
s.popis_sk=>Inzeráty výpis
s.autorizovany_uchazec=>vse
titulek=>Práce firma Františkovy Lázně - volná místa zde - InWork.cz
s.titulek=>Inzeráty výpis
popis=>Inzeráty výpis
s.popis=>Inzeráty výpis
nadpis=>Práce - firma, Františkovy Lázně
1) 0.012128
select nazev_cz as nazev, nazev_cz `nazev_cz`, ident `ident`, id_sekce `id_sekce` from preklady where zobraz_cz = "1"
2) 0.008287
select presm.id `presm.id`, presm.cil `presm.cil`, presm.status `presm.status` from presmerovani presm where (presm.zdroj = "https://www.inwork.cz/prace/karlovarsky-kraj/cheb/frantiskovy-lazne/stavebnictvi-a-reality/svarec/zkraceny/prace-vhodna-i-pro-uprchliky-z-ukrajiny/firma/" and presm.shoda = "presna" ) or (locate(presm.zdroj, "https://www.inwork.cz/prace/karlovarsky-kraj/cheb/frantiskovy-lazne/stavebnictvi-a-reality/svarec/zkraceny/prace-vhodna-i-pro-uprchliky-z-ukrajiny/firma/%") > 0 and presm.shoda = "volna" )
3) 0.000789
select ip `ip` from ip_blokace where ip = "216.73.216.49" and archiv = "0"
4) 0.001962
select s.id `s.id`, s.kontroler `s.kontroler`, s.uri_cs1 `s.uri_cs`, s.uri_sk `s.uri_sk`, s.nazev_cz `s.nazev_cz`, s.nazev_sk `s.nazev_sk`, s.titulek_cz `s.titulek_cz`, s.titulek_sk `s.titulek_sk`, s.popis_cz `s.popis_cz`, s.popis_sk `s.popis_sk`, s.autorizovany_uchazec `s.autorizovany_uchazec` from stranky s where 1 and s.archiv = "0" and s.`pr.id` = "4" order by s.poradi_nacteni desc
5) 0.001279
select menu_pol.nazev_cs `menu_pol.nazev`, s.id `s.id`, s.uri_cs `s.url` from menu_polozky menu_pol join stranky s on s.id = menu_pol.stranky_id where menu_pol.zobraz = "1" and s.autorizovany_uchazec in("vse", "neprihlaseny") and s.`pr.id` = "4"
6) 0.0017
select okr.id `okr.id`, okr.ident_cz `okr.ident`, okr.nazev_cz `okr.nazev`, okr.pocet_3 `okr.pocet_3`, okr.pocet_1 `okr.pocet_1`, okr.pocet_6 `okr.pocet_6`, okr.pocet_7 `okr.pocet_7`, kr.ident_cz `kr.ident`, kr.pocet_3 `kr.pocet_3`, kr.pocet_1 `kr.pocet_1`, kr.pocet_6 `kr.pocet_6`, kr.pocet_7 `kr.pocet_7` from krajecz kr join okresycz okr on okr.id_kraje = kr.id where okr.nabidka_index_4 = "1" order by okr.pozice1_cz
7) 0.004751
select rekl_ban.id `rekl_ban.id`, rekl_ban.url `rekl_ban.url`, rekl_ban.titulek_cz `rekl_ban.titulek_cz`, rekl_ban.prokliku `rekl_ban.prokliku`, rekl_ban.zobrazeni `rekl_ban.zobrazeni`, rekl_ban.max_pocet_zobrazeni `rekl_ban.max_pocet_zobrazeni`, rekl_ban.max_pocet_prokliku `rekl_ban.max_pocet_prokliku`, rekl_ban.popis_cz `rekl_ban.popis_cz`, rekl_ban.obrazek2 `rekl_ban.obrazek2`, rekl_ban.od `rekl_ban.od`, rekl_ban.do `rekl_ban.do`, rekl_ban.zahranici `rekl_ban.zahranici`, rekl_ban.nofollow `rekl_ban.nofollow` from reklamni_bannery rekl_ban where rekl_ban.reklamni_bannery_umisteni_id = 18 and rekl_ban.zobraz = "1" and rekl_ban.archiv = "0" and rekl_ban.smazano = "0" and case when rekl_ban.max_pocet_zobrazeni is null then 1 else rekl_ban.zobrazeni <= rekl_ban.max_pocet_zobrazeni end and case when rekl_ban.max_pocet_prokliku is null then 1 else rekl_ban.prokliku <= rekl_ban.max_pocet_prokliku end and case when rekl_ban.do is null then 1 else rekl_ban.do >= curdate() end and case when rekl_ban.od is null then 1 else rekl_ban.od <= curdate() end and (mesta REGEXP ",554529," or (kraje = "" and okresy = "" and mesta = "") or case when okresy != "" then okresy REGEXP ",3402," end or case when kraje != "" then kraje REGEXP ",51," end ) and case when sekce = "" then 1 else sekce like "%,3,%" end order by rand() limit 1
8) 0.003626
select rekl_ban.id `rekl_ban.id`, rekl_ban.url `rekl_ban.url`, rekl_ban.obrazek1 `rekl_ban.obrazek1`, rekl_ban.prokliku `rekl_ban.prokliku`, rekl_ban.zobrazeni `rekl_ban.zobrazeni`, rekl_ban.max_pocet_zobrazeni `rekl_ban.max_pocet_zobrazeni`, rekl_ban.max_pocet_prokliku `rekl_ban.max_pocet_prokliku`, rekl_ban.od `rekl_ban.od`, rekl_ban.do `rekl_ban.do`, rekl_ban.script_reklama `rekl_ban.script_reklama`, rekl_ban.prepinac `rekl_ban.prepinac` from reklamni_bannery rekl_ban where rekl_ban.reklamni_bannery_umisteni_id = 11 and rekl_ban.zobraz = "1" and rekl_ban.archiv = "0" and rekl_ban.smazano = "0" and case when rekl_ban.max_pocet_zobrazeni is null then 1 else rekl_ban.zobrazeni <= rekl_ban.max_pocet_zobrazeni end and case when rekl_ban.max_pocet_prokliku is null then 1 else rekl_ban.prokliku <= rekl_ban.max_pocet_prokliku end and case when rekl_ban.do is null then 1 else rekl_ban.do >= curdate() end and case when rekl_ban.od is null then 1 else rekl_ban.od <= curdate() end and (mesta REGEXP ",554529," or (kraje = "" and okresy = "" and mesta = "") or case when okresy != "" then okresy REGEXP ",3402," end or case when kraje != "" then kraje REGEXP ",51," end ) order by rand() limit 1
9) 0.002517
select rekl_ban.id `rekl_ban.id`, rekl_ban.url `rekl_ban.url`, rekl_ban.titulek_cz `rekl_ban.titulek_cz`, rekl_ban.prokliku `rekl_ban.prokliku`, rekl_ban.zobrazeni `rekl_ban.zobrazeni`, rekl_ban.max_pocet_zobrazeni `rekl_ban.max_pocet_zobrazeni`, rekl_ban.max_pocet_prokliku `rekl_ban.max_pocet_prokliku`, rekl_ban.popis_cz `rekl_ban.popis_cz`, rekl_ban.obrazek1 `rekl_ban.obrazek1`, rekl_ban.od `rekl_ban.od`, rekl_ban.do `rekl_ban.do`, rekl_ban.zahranici `rekl_ban.zahranici`, rekl_ban.obrazek_editor `rekl_ban.obrazek_editor`, rekl_ban.editor `rekl_ban.editor`, rekl_ban.prepinac `rekl_ban.prepinac` from reklamni_bannery rekl_ban where rekl_ban.reklamni_bannery_umisteni_id = 23 and rekl_ban.zobraz = "1" and rekl_ban.archiv = "0" and rekl_ban.smazano = "0" and case when rekl_ban.max_pocet_zobrazeni is null then 1 else rekl_ban.zobrazeni <= rekl_ban.max_pocet_zobrazeni end and case when rekl_ban.max_pocet_prokliku is null then 1 else rekl_ban.prokliku <= rekl_ban.max_pocet_prokliku end and case when rekl_ban.do is null then 1 else rekl_ban.do >= curdate() end and case when rekl_ban.od is null then 1 else rekl_ban.od <= curdate() end and (mesta REGEXP ",554529," or (kraje = "" and okresy = "" and mesta = "") or case when okresy != "" then okresy REGEXP ",3402," end or case when kraje != "" then kraje REGEXP ",51," end ) and rekl_ban.zahranici = "0" order by rand() limit 1
10) 0.00156
select count(*) from inzeraty_select i where 1=1 and `i.web` = "1" and `i.st.id2`="1" and `i.se_i.id` = "3" and `i.jaz_cs` = "1" and `i.kr.id` = "51" and `i.okr.id` = "3402" and `i.ob.id` in("554529") and `i.obor.id` in(",69,") and `i.poz.id` in(",115,",",96,") and `i.uvaz.id` REGEXP ",2," and `i.vhod.id` REGEXP ",7," and `i.inzer.id` in ("1") and `i.zdroj` != "7"
11) 0.003656
select SQL_CALC_FOUND_ROWS * from ( select 1 rank, i.*, `i.titulek_cz` `i.titulek`, `i.popis_cz` `i.popis` from inzeraty_select i where 1=1 and `i.titulek_sk` = "" and `i.web` = "1" and `i.st.id2`="1" and `i.se_i.id` = "3" and `i.jaz_cs` = "1" and `i.kr.id` = "51" and `i.okr.id` = "3402" and `i.ob.id` in("554529") and `i.obor.id` in(",69,") and `i.poz.id` in(",115,",",96,") and `i.uvaz.id` REGEXP ",2," and `i.vhod.id` REGEXP ",7," and `i.inzer.id` in ("1") and `i.zdroj` != "7" union all select 2 rank, i.*, `i.titulek_cz` `i.titulek`, `i.popis_cz` `i.popis` from inzeraty_select i where 1=1 and `i.titulek_sk` = "" and `i.web` = "1" and `i.st.id2`="1" and `i.se_i.id` = "3" and `i.jaz_cs` = "1" and `i.kr.id` = "51" and `i.okr.id` = "3402" and `i.ob.id` in("554529") and `i.obor.id` in(",69,") and `i.uvaz.id` REGEXP ",2," and `i.vhod.id` REGEXP ",7," and `i.inzer.id` in ("1") and `i.zdroj` != "7" and `i.poz.id` in(",115,") ) a group by (a.`i.id`) order by rank ASC, case when `zvyh.vip_datum` is not null and `zvyh.vip_datum` != "" then 0 else 1 end, case when `zvyh.vip_datum` is not null and `zvyh.vip_datum` != "" then rand() else 0 end, case when `zvyh.top_datum` is not null and `zvyh.top_datum` != "" then 0 else 1 end, case when `zvyh.top_datum` is not null and `zvyh.top_datum` != "" then rand() else 0 end, `i.ob.id` != "0" DESC, `i.zdroj` != "7" DESC, `i.datum_aktualizace` DESC limit 0, 40
12) 0.000677
SELECT FOUND_ROWS()
13) 0.002569
select cl.id `cl.id`, cl.ident_cs `cl.ident_cs`, cl.ident_sk `cl.ident_sk`, cl.nazev_cs `cl.nazev_cs`, cl.nazev_sk `cl.nazev_sk`, cl.`se_cl.id-iw` `cl.se_cl.id-iw`, cl.`se_cl.id-fb` `cl.se_cl.id-fb`, cl.obrazek `cl.obrazek` from clanky_nova cl where cl.`pr.id-detail`="4" and cl.zobraz_cz = "1" and cl.datum_publikace <= "2025-05-23" order by rand() limit 2
14) 0.001321
select seo_text.id `seo_text.id`, seo_text.text_horni_cs `seo_text.text_horni`, seo_text.text_spodni_cs `seo_text.text_spodni`, seo_text.popis_meta_cs `seo_text.popis_meta`, seo_text.titulek_meta_cs `seo_text.titulek_meta`, seo_text.nadpis_h1_cs `seo_text.nadpis_h1` from seo_texty seo_text where seo_text.archiv = "0" and seo_text.`pr.id` = "4" and seo_text.`ob.id` = "554529" and seo_text.`kr.id` = "51" and seo_text.`st.id1` = "1" and seo_text. `okr.id` = "3402" and seo_text.`se_i.id` = "3" and seo_text.`obor.id` = "69" and seo_text.`vhod.id` = "7" and seo_text.`uvaz.id` = "2" and seo_text.`benefity.id` is null and seo_text.`poz.id` = "115" and seo_text.`kat_brig.id` is null
15) 0.00131
select seo_text_vych.id `seo_text.id`, seo_text_vych.text_horni_cs `seo_text.text_horni`, seo_text_vych.text_spodni_cs `seo_text.text_spodni`, seo_text_vych.popis_meta_cs `seo_text.popis_meta`, seo_text_vych.titulek_meta_cs `seo_text.titulek_meta`, seo_text_vych.nadpis_h1_cs `seo_text.nadpis_h1` from seo_texty_vychozi seo_text_vych where seo_text_vych.archiv = "0" and seo_text_vych.`pr.id` = "4" and seo_text_vych.typ_lokality = "mesto" and seo_text_vych.mesto = "1" and seo_text_vych.staty = "0" and seo_text_vych.sekce_inzeraty_id = "3" and seo_text_vych.obory = "1" and seo_text_vych.pozice = "1" and seo_text_vych.vzdelani = "0" and seo_text_vych.benefity = "0" and seo_text_vych.vhodne_pro = "1" and seo_text_vych.kategorie_brigad is null and seo_text_vych.inzerent = "1" and seo_text_vych.uvazek = "1"
16) 0.001008
select form.csrf `form.csrf` from formulare form where form.id = "2"
17) 0.001017
select form.csrf `form.csrf` from formulare form where form.id = "2"
0.001508
insert `pozadavky` (`id`) values (null)
„Ideální práce ve Vašem městě“
Array
(
[stranka] => prace/karlovarsky-kraj/cheb/frantiskovy-lazne/stavebnictvi-a-reality/svarec/zkraceny/prace-vhodna-i-pro-uprchliky-z-ukrajiny/firma
[titulek] => karlovarsky-kraj/cheb/frantiskovy-lazne/stavebnictvi-a-reality/svarec/zkraceny/prace-vhodna-i-pro-uprchliky-z-ukrajiny/firma
[id] => 0
[params] => Array
(
[0] => karlovarsky-kraj/cheb/frantiskovy-lazne/stavebnictvi-a-reality/svarec/zkraceny/prace-vhodna-i-pro-uprchliky-z-ukrajiny/firma
)
[form__id] => f2
[f2] => Array
(
[i.se_i.id.1] => 3
[i.kr.id.1] => 51
[i.okr.id.1] => 3402
[i.ob.id.2] => Array
(
[0] => 554529
)
[i.obor.id.2] => Array
(
[0] => 69
)
[i.poz.id.3] => Array
(
[0] => 115
)
[i.uvaz.id.2] => Array
(
[0] => 2
)
[i.vhod.id.2] => Array
(
[0] => 7
)
[i.inzer.id.2] => Array
(
[0] => 1
)
)
)
Array ( )
Array
(
[csrf] => 68300dbbb85d30.57781373
[vypis_inzeratu] => Array
(
[url] => https://www.inwork.cz/prace/karlovarsky-kraj/cheb/frantiskovy-lazne/stavebnictvi-a-reality/svarec/zkraceny/prace-vhodna-i-pro-uprchliky-z-ukrajiny/firma/
)
)
Array
(
[PHPSESSID] => 3898270b7c8c0d9bad2bc9660c66a0c0
)
Array
(
[magick_temporary_path] => /www/hosting/test-iw.cz/tmp
[magick_tmp_path] => /www/hosting/test-iw.cz/tmp
[magick_tmpdir] => /www/hosting/test-iw.cz/tmp
[sys_temp_dir] => /www/hosting/test-iw.cz/tmp
[sys_tmp_dir] => /www/hosting/test-iw.cz/tmp
[HOME] => /www/hosting/test-iw.cz
[USER] => www-data
[HTTP_COOKIE] => PHPSESSID=3898270b7c8c0d9bad2bc9660c66a0c0
[HTTP_REFERER] => https://stage.cz.www.test-iw.cz/prace/karlovarsky-kraj/cheb/frantiskovy-lazne/stavebnictvi-a-reality/svarec/zkraceny/prace-vhodna-i-pro-uprchliky-z-ukrajiny/firma
[HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate
[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[HTTP_ACCEPT] => */*
[HTTP_HOST] => stage.cz.www.test-iw.cz
[KOREN] => /www/hosting/verzovani/stage/
[STAT] => cz
[PROJEKT] => iw
[PATH_INFO] => /index.php
[SCRIPT_FILENAME] => /www/hosting/verzovani/stage/index.php
[REDIRECT_STATUS] => 200
[SERVER_NAME] => ~^(?(mara|risa|kuba|master|hotfix|stage)).(?(.*)).www.test-iw.cz
[SERVER_PORT] => 443
[SERVER_ADDR] => 95.168.198.11
[REMOTE_USER] =>
[REMOTE_PORT] => 9648
[REMOTE_ADDR] => 216.73.216.49
[SERVER_SOFTWARE] => nginx/1.22.1
[GATEWAY_INTERFACE] => CGI/1.1
[HTTPS] => on
[REQUEST_SCHEME] => https
[SERVER_PROTOCOL] => HTTP/2.0
[DOCUMENT_ROOT] => /www/hosting/verzovani/stage
[DOCUMENT_URI] => /index.php
[REQUEST_URI] => /prace/karlovarsky-kraj/cheb/frantiskovy-lazne/stavebnictvi-a-reality/svarec/zkraceny/prace-vhodna-i-pro-uprchliky-z-ukrajiny/firma/
[SCRIPT_NAME] => /index.php
[CONTENT_LENGTH] =>
[CONTENT_TYPE] =>
[REQUEST_METHOD] => GET
[QUERY_STRING] => stranka=prace/karlovarsky-kraj/cheb/frantiskovy-lazne/stavebnictvi-a-reality/svarec/zkraceny/prace-vhodna-i-pro-uprchliky-z-ukrajiny/firma
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /index.php/index.php
[REQUEST_TIME_FLOAT] => 1747979708.2774
[REQUEST_TIME] => 1747979708
[cr.id] =>
)