>
>
>
>
>
zobrazit >>
s.id=>76
s.kontroler=>inzeraty/vypis/hlavni/i.vypis.hlavni.php
s.kontroler1=>inzeraty/vypis/hlavni/k.i.vypis.hlavni.php
s.uri_cs=>/brigady/*
s.nazev_cz=>Inzeráty výpis
s.titulek_cz=>Inzeráty výpis
s.popis_cz=>Inzeráty výpis
s.nazev_sk=>Inzeráty výpis
s.titulek_sk=>Inzeráty výpis
s.popis_sk=>Inzeráty výpis
s.autorizovany_uchazec=>vse
titulek=>Inzeráty výpis
popis=>Podívej se na největší nabídku ve zvolené lokalitě a najdi si u nás brigádu snů. Máme vždy ručně ověřené a aktuální inzeráty z různých odvětví, ze kterých si určitě vybereš.
1) 0.02398
select nazev_cz as nazev, nazev_cz `nazev_cz`, nazev_sk `nazev_sk`, ident `ident`, id_sekce `id_sekce` from preklady where zobraz_cz = "1"
2) 0.001744
select presm.id `presm.id`, presm.cil `presm.cil`, presm.status `presm.status` from presmerovani presm where (presm.zdroj = "https://www.fajn-brigady.cz/brigady/dobrovice/animator/" and presm.shoda = "presna" ) or (locate(presm.zdroj, "https://www.fajn-brigady.cz/brigady/dobrovice/animator/%") > 0 and presm.shoda = "volna" )
3) 0.000633
select ip `ip` from ip_blokace where ip = "216.73.216.117" and archiv = "0"
4) 0.002304
select hled_vyr.id `hled_vyr.id`, hled_vyr.`poz.id` `hled_vyr.poz.id`, hled_vyr.`vhod.id` `hled_vyr.vhod.id`, hled_vyr.`benef.id` `hled_vyr.benef.id`, hled_vyr.titulek_cz `hled_vyr.titulek_cz` from hledane_vyrazy hled_vyr where (hled_vyr.ident_cz = "/brigady/dobrovice/animator/" or hled_vyr.ident_sk = "/brigady/dobrovice/animator/" )
5) 0.001234
select s.id `s.id`, s.uri_cs `s.uri_cs` from stranky s where 1 and s.archiv = "0" and s.`pr.id` = "1" and s.stara_url_fb = "0" and s.id not in (10)
6) 0.00149
select s.id `s.id`, s.kontroler `s.kontroler`, s.kontroler1 `s.kontroler1`, s.uri_cs `s.uri_cs`, s.nazev_cz `s.nazev_cz`, s.titulek_cz `s.titulek_cz`, s.popis_cz `s.popis_cz`, s.nazev_sk `s.nazev_sk`, s.titulek_sk `s.titulek_sk`, s.popis_sk `s.popis_sk`, s.autorizovany_uchazec `s.autorizovany_uchazec` from stranky s where 1 and s.archiv = "0" and s.stara_url_fb = "0" and s.id = "76" and s.`pr.id`="1"
7) 0.00236
select `i.st.id2` `i.st.id` from inzeraty_select i where `i.st.id2` not in ("1","2") and `i.titulek_sk`="" and `i.web` = "1" group by `i.st.id2`
8) 0.00202
select menu_pol.nazev_cs `menu_pol.nazev`, s.id `s.id`, s.uri_cs1 `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_jaz.id` = "1"
9) 0.022081
select SQL_CALC_FOUND_ROWS * from ( (select 1 rank, `i.titulek_cz`, `i.popis_cz`, `i.titulek_sk`, `i.popis_sk`, `i.st.id2`, `i.se_i.id`, `i.kr.id`, `i.okr.id`, `i.ob.id`, `i.kat_brig.id`, `i.obor.id`, `i.poz.id`, `i.uvaz.id`, `i.mzda_od_mesicne_float`, `i.mzda_do_mesicne`, `i.datum_schvaleni`, `i.datum_upravy`, `i.datum_aktualizace`, `i.vek.ids`, `i.min_vzd.id`, `i.inzer.id`, `fi.koncovka1`, `i.poh.ids`, `u.id`, `fi.id`, `fi.nazev`, `fi.overena_firma_1`, `fi.odpovime_ihned`, `i.firma_nazev`, `i.id`, `i.cela_cr`, `i.cela_sk`, `poradi`, `poradi_datum`, `i.zdroj`, `zvyh.top`, `zvyh.vip`, `i.datum` from inzeraty_select i where 1=1 and `i.web` = "1" and `i.st.id2`="1" and `i.se_i.id` = "1" and `i.jaz_cs` = "1" and `i.okr.id` = "3207" and `i.kr.id` = "27" and `i.ob.id` in("535672") and `i.poz.id` in(",283,",",0,") and `i.jaz_cs`="1" ) union all (select 2 rank, `i.titulek_cz`, `i.popis_cz`, `i.titulek_sk`, `i.popis_sk`, `i.st.id2`, `i.se_i.id`, `i.kr.id`, `i.okr.id`, `i.ob.id`, `i.kat_brig.id`, `i.obor.id`, `i.poz.id`, `i.uvaz.id`, `i.mzda_od_mesicne_float`, `i.mzda_do_mesicne`, `i.datum_schvaleni`, `i.datum_upravy`, `i.datum_aktualizace`, `i.vek.ids`, `i.min_vzd.id`, `i.inzer.id`, `fi.koncovka1`, `i.poh.ids`, `u.id`, `fi.id`, `fi.nazev`, `fi.overena_firma_1`, `fi.odpovime_ihned`, `i.firma_nazev`, `i.id`, `i.cela_cr`, `i.cela_sk`, `poradi`, `poradi_datum`, `i.zdroj`, `zvyh.top`, `zvyh.vip`, `i.datum` from inzeraty_select i where 1=1 and `i.web` = "1" and `i.ob.id` != "535672" and `i.st.id2`="1" and `i.se_i.id` = "1" and `i.jaz_cs` = "1" and `i.okr.id` = "3207" and `i.kr.id` = "27" and `i.poz.id` in(",283,",",0,") and `i.jaz_cs`="1" ) union all (select 3 rank, `i.titulek_cz`, `i.popis_cz`, `i.titulek_sk`, `i.popis_sk`, `i.st.id2`, `i.se_i.id`, `i.kr.id`, `i.okr.id`, `i.ob.id`, `i.kat_brig.id`, `i.obor.id`, `i.poz.id`, `i.uvaz.id`, `i.mzda_od_mesicne_float`, `i.mzda_do_mesicne`, `i.datum_schvaleni`, `i.datum_upravy`, `i.datum_aktualizace`, `i.vek.ids`, `i.min_vzd.id`, `i.inzer.id`, `fi.koncovka1`, `i.poh.ids`, `u.id`, `fi.id`, `fi.nazev`, `fi.overena_firma_1`, `fi.odpovime_ihned`, `i.firma_nazev`, `i.id`, `i.cela_cr`, `i.cela_sk`, `poradi`, `poradi_datum`, `i.zdroj`, `zvyh.top`, `zvyh.vip`, `i.datum` from inzeraty_select i where 1=1 and (`zvyh.top`="1" or `zvyh.vip`="1") and `i.web` = "1" and `i.ob.id` != "535672" and `i.okr.id` != "3207" and `i.st.id2`="1" and `i.se_i.id` = "1" and `i.jaz_cs` = "1" and `i.kr.id` = "27" and `i.poz.id` in(",283,",",0,") and `i.jaz_cs`="1" limit 5 ) union all (select 4 rank, `i.titulek_cz`, `i.popis_cz`, `i.titulek_sk`, `i.popis_sk`, `i.st.id2`, `i.se_i.id`, `i.kr.id`, `i.okr.id`, `i.ob.id`, `i.kat_brig.id`, `i.obor.id`, `i.poz.id`, `i.uvaz.id`, `i.mzda_od_mesicne_float`, `i.mzda_do_mesicne`, `i.datum_schvaleni`, `i.datum_upravy`, `i.datum_aktualizace`, `i.vek.ids`, `i.min_vzd.id`, `i.inzer.id`, `fi.koncovka1`, `i.poh.ids`, `u.id`, `fi.id`, `fi.nazev`, `fi.overena_firma_1`, `fi.odpovime_ihned`, `i.firma_nazev`, `i.id`, `i.cela_cr`, `i.cela_sk`, `poradi`, `poradi_datum`, `i.zdroj`, `zvyh.top`, `zvyh.vip`, `i.datum` from inzeraty_select i where 1=1 and `i.se_i.id`="1" and `i.web` = "1" and (`zvyh.top`="1" or `zvyh.vip`="1") and `i.cela_cr` = "1" and `i.jaz_cs`="1" limit 3 ) ) a group by (a.`i.id`) order by rank asc, poradi asc, poradi_datum desc, `i.cela_cr`="0" desc, `i.cela_sk`="0" desc limit 0, 40
10) 0.000525
SELECT FOUND_ROWS()
11) 0.000949
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` = "1" and seo_text.`ob.id` = "535672" and seo_text.`kr.id` = "27" and seo_text.`st.id1` = "1" and seo_text. `okr.id` = "3207" and seo_text.`se_i.id` = "1" and seo_text.`obor.id` is null and seo_text.`vhod.id` is null and seo_text.`uvaz.id` is null and seo_text.`benefity.id` is null and seo_text.`poz.id` = "283" and seo_text.`kat_brig.id` is null
12) 0.002741
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 cl where cl.`jaz.ids` REGEXP ",1," and cl.zobraz_cz = "1" and cl.datum_publikace <= "2025-09-24" and cl.`ident_cs` != "" order by rand() limit 2
13) 0.001661
select vid.id `vid.id`, vid.ident_cz `vid.ident_cz`, vid.nazev_cz `vid.nazev_cz`, vid.`se_vid.id` `vid.se_vid.id`, vid.obrazek1 `vid.obrazek1` from (select * from videa where zobraz_cz = "1" and `pr.id` = "1" order by `zobrazeni` desc limit 20) vid where vid.zobraz_cz = "1" and vid.`pr.id` = "1" and vid.archiv = "0" order by rand() limit 3
14) 0.001566
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`, rekl_ban.script_reklama `rekl_ban.script_reklama` from reklamni_bannery rekl_ban where rekl_ban.reklamni_bannery_umisteni_id = 34 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 ",535672," or (kraje = "" and okresy = "" and mesta = "") or case when okresy != "" then okresy REGEXP ",3207," end or case when kraje != "" then kraje REGEXP ",27," end ) and rekl_ban.zahranici = "0" order by rand() limit 1
15) 0.003819
select rekl_ban.id `rekl_ban.id`, rekl_ban.url `rekl_ban.url`, rekl_ban.nazev `rekl_ban.nazev`, 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.titulek_cz `rekl_ban.titulek_cz`, 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.nofollow `rekl_ban.nofollow` from reklamni_bannery rekl_ban where rekl_ban.reklamni_bannery_umisteni_id = 32 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 ",535672," or (kraje = "" and okresy = "" and mesta = "") or case when okresy != "" then okresy REGEXP ",3207," end or case when kraje != "" then kraje REGEXP ",27," end ) and case when sekce = "" then 1 else sekce like "%,1,%" end order by rand() limit 1
16) 0.001903
select `i.poz.id`, count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="535672" and `i.se_i.id` = "1" and `i.st.id2` = "1" group by `i.poz.id`
17) 0.316918
select option_id `option_id`, pocty_json_brigady_cz `pocty_json_brigady_cz` from podpodsekce_option where pocty_json_brigady_cz != ""
18) 0.036608
select `i.ob.id`, count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id` in ("536067","536580","599557","536326","535559","535818","571148","570893","536334","535567","571156","599573","566039","565784","536857","535834","535583","536351","566047","536610","571938","565539","571172","571946","570923","535605","536121","536377","565563","536636","570940","535869","565822","565571","571971","535621","536652","565580","535630","536661","571989","536407","571997","570974","536164","570982","535656","536938","536172","572012","536431","570991","535923","536181","572021","535672","536440","535419","535931","565628","570753","535427","565636","536709","570761","536202","536458","536971","565644","536717","570770","535443","536211","565652","535702","571032","535451","536989","565661","535966","571806","535711","565920","570788","536997","535974","571814","536491","535729","535478","529591","571067","535486","536768","535745","570818","571075","529605","536261","536008","571849","570826","529613","536270","535508","536024","571865","599514","570842","535516","565725","598241","599522","565733","557030","536041","571881","599531","571121","565750") and `i.se_i.id` = "1" and `i.poz.id` = ",283," group by `i.ob.id`
19) 0.005579
select `i.kat_brig.id`, count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="535672" and `i.se_i.id` = "1" and `i.st.id2` = "1" group by `i.kat_brig.id`
20) 0.005251
select `i.benefity` from inzeraty_select i where 1 and `i.ob.id`="535672" and `i.se_i.id` = "1" and `i.st.id2` = "1" and `i.benefity` is not null and `i.benefity` != "" and `i.web` = "1"
21) 0.005529
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="535672" and `i.se_i.id` = "1" and `i.st.id2` = "1" and `i.vhod.id` REGEXP ",1,"
22) 0.005409
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="535672" and `i.se_i.id` = "1" and `i.st.id2` = "1" and `i.vhod.id` REGEXP ",4,"
23) 0.005579
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="535672" and `i.se_i.id` = "1" and `i.st.id2` = "1" and `i.vhod.id` REGEXP ",5,"
24) 0.00598
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="535672" and `i.se_i.id` = "1" and `i.st.id2` = "1" and `i.vhod.id` REGEXP ",6,"
25) 0.002058
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="535672" and `i.se_i.id` = "1" and `i.st.id2` = "1" and `i.vhod.id` REGEXP ",8,"
26) 0.001729
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="535672" and `i.se_i.id` = "1" and `i.st.id2` = "1" and `i.vhod.id` REGEXP ",9,"
27) 0.002268
select count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.ob.id`="535672" and `i.se_i.id` = "3" and `i.vhod.id` REGEXP ",3,"
28) 0.00348
select fi.id `fi.id`, fi.nazev `fi.nazev`, fi.ident `fi.ident`, fi.pocet_1 `fi.pocet_1`, (select count(`i.id`) from inzeraty_select where `fi.id`=fi.id and `i.web` = "1" and `i.ob.id`="535672" and `i.se_i.id` = "1") `fi.pocet` from firmy fi where fi.id in (2268, 3303, 2069, 115, 2490) order by fi.id DESC limit 5
29) 0.01964
select `i.okr.id`, count(`i.id`) `i.pocet_nabidek` from inzeraty_select i where 1 and `i.web` = "1" and `i.se_i.id` = "1" and `i.st.id2` = "1" and `i.st.id2` = "1" group by `i.okr.id`
30) 0.003023
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 = 7 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 ",535672," or (kraje = "" and okresy = "" and mesta = "") or case when okresy != "" then okresy REGEXP ",3207," end or case when kraje != "" then kraje REGEXP ",27," end ) order by rand() limit 1
31) 0.000674
select form.csrf `form.csrf` from formulare form where form.id = "48"
0.001302
insert `pozadavky` (`id`) values (null)
Array
(
[str] => Array
(
[uri] => /brigady/dobrovice/animator/
)
[auto_prepend_file_old] => 0
[new] => a1
[f48] => Array
(
[i.se_i.id.1] => 1
[i.okr.id.1] => 3207
[i.kr.id.1] => 27
[i.ob.id.2] => Array
(
[0] => 535672
)
[i.poz.id.5] => Array
(
[0] => 283
)
)
)
Array ( )
Array
(
[csrf] => 68d39be70c7d41.62557626
)
Array
(
[PHPSESSID] => b0da46d5dea7ee6b6d1b9e4f27efcfa9
)
Array
(
[magick_temporary_path] => /www/hosting/fajn-brigady.cz/tmp
[magick_tmp_path] => /www/hosting/fajn-brigady.cz/tmp
[magick_tmpdir] => /www/hosting/fajn-brigady.cz/tmp
[sys_temp_dir] => /www/hosting/fajn-brigady.cz/tmp
[sys_tmp_dir] => /www/hosting/fajn-brigady.cz/tmp
[HOME] => /www/hosting/fajn-brigady.cz
[USER] => www-data
[HTTP_COOKIE] => PHPSESSID=b0da46d5dea7ee6b6d1b9e4f27efcfa9
[HTTP_REFERER] => https://www.fajn-brigady.cz/brigady/dobrovice/animator
[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] => www.fajn-brigady.cz
[KOREN] => /www/hosting/verze/
[STAT] => cz
[PROJEKT] => fb
[PATH_INFO] => /index.php
[SCRIPT_FILENAME] => /www/hosting/verze/index.php
[REDIRECT_STATUS] => 200
[SERVER_NAME] => www.fajn-brigady.cz
[SERVER_PORT] => 443
[SERVER_ADDR] => 46.234.101.49
[REMOTE_USER] =>
[REMOTE_PORT] => 51257
[REMOTE_ADDR] => 216.73.216.117
[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/verze
[DOCUMENT_URI] => /index.php
[REQUEST_URI] => /brigady/dobrovice/animator/
[SCRIPT_NAME] => /index.php
[CONTENT_LENGTH] =>
[CONTENT_TYPE] =>
[REQUEST_METHOD] => GET
[QUERY_STRING] => str[uri]=/brigady/dobrovice/animator/&auto_prepend_file_old=0&new=a1
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /index.php/index.php
[REQUEST_TIME_FLOAT] => 1758698476.6695
[REQUEST_TIME] => 1758698476
[cr.id] =>
)