Job offers

Zavřít
Zavřít
Česká republika
Slovensko
Nalezeno celkem 10 inzerátů.  Stránky:  1 2
RSS Feed
 

Inzeraty:vypis changePage!

Parameter Value
lang en
hash
NULL
id
NULL
page 3

Routers

Matched? Class Mask Defaults Module Request
no CliRouter
no Route agreement/new/<kandidatId>/<hash> presenter = Agreement
action = new
no Route homepage/content/<content> presenter = Homepage
action = content
no Route contact/detail/<contact> presenter = Contact
action = detail
yes HashRoute [<lang>/][<presenter>/<action>][/<id>/<hash>] presenter = Homepage
action = default
hash = 
NULL

id = 
NULL

lang = 
NULL

Inzeraty:vypis
lang = en
hash = 
NULL

id = 
NULL

do = changePage
page = 3
¤ ×

Queries: 8, time: 19.568 ms

Time msSQL StatementParamsRows
0.720
explain ►
SELECT * 
FROM `c_ridici_urovne`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEc_ridici_urovneALL3
.../export/boreas/app/models/Table/cRidiciUrovne.php
3
0.391
explain ►
SELECT * 
FROM `c_obory`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEc_oboryALL27
.../export/boreas/app/models/Table/cObory.php
27
0.384
explain ►
SELECT `c_kraje`.* 
FROM `c_kraje` 
LEFT JOIN `c_countries` ON `c_kraje`.`c_countries_id` = `c_countries`.`id` 
ORDER BY `c_countries`.`name`, `c_kraje`.`nazev`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEc_krajeALL22Using temporary; Using filesort
1SIMPLEc_countrieseq_refPRIMARYPRIMARY4boreas_db.c_kraje.c_countries_id1Using where
.../export/boreas/app/models/Table/cKraje.php
22
0.238
explain ►
SELECT * 
FROM `c_countries` 
WHERE (`id` IN (56, 189))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEc_countriesrangePRIMARYPRIMARY42Using where
.../export/boreas/app/models/Table/cKraje.php
2
8.539
explain ►
SELECT `inzeraty_detaily`.`nazev` AS `nazev`,`inzeraty_detaily`.`uvod` AS
`uvod`,`inzeraty_detaily`.`popis_pozice` AS `popis_pozice`,`inzeraty`.`id` AS
`iId`,`inzeraty`.`ref_cislo` AS `ref_cislo`,`inzeraty`.`datum_pocatku` AS
`datum_pocatku`,`c_okresy`.`nazev` AS `okres`,`c_kraje`.`nazev` AS `kraj` 
FROM `inzeraty_detaily` 
LEFT JOIN `inzeraty` ON `inzeraty_detaily`.`inzeraty_id` = `inzeraty`.`id` 
INNER JOIN `c_inzeraty_stavy` ON `inzeraty`.`c_inzeraty_stavy_id` = `c_inzeraty_stavy`.`id` 
LEFT JOIN `c_okresy` ON `inzeraty`.`c_okresy_id` = `c_okresy`.`id` 
LEFT JOIN `c_kraje` ON `c_okresy`.`c_kraje_id` = `c_kraje`.`id` 
WHERE (`c_inzeraty_stavy`.`zobrazit` = ?) AND (`inzeraty`.`datum_expirace` > CURDATE()) 
GROUP BY `inzeraty`.`id` 
ORDER BY `inzeraty`.`datum_pocatku` DESC, `inzeraty_detaily`.`id` ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEinzeraty_detailyALLinzeraty_id738Using temporary; Using filesort
1SIMPLEinzeratyeq_refPRIMARY,c_inzeraty_stavy_idPRIMARY4boreas_db.inzeraty_detaily.inzeraty_id1Using where
1SIMPLEc_okresyeq_refPRIMARYPRIMARY4boreas_db.inzeraty.c_okresy_id1
1SIMPLEc_krajeeq_refPRIMARYPRIMARY4boreas_db.c_okresy.c_kraje_id1Using where
1SIMPLEc_inzeraty_stavyALLPRIMARY5Using where; Using join buffer (flat, BNL join)
.../export/boreas/app/presenters/InzeratyPresenter.php
1
10
0.602
explain ►
SELECT * 
FROM `c_countries` 
WHERE (`id` = ?)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEc_countriesconstPRIMARYPRIMARY4const1
.../export/boreas/app/models/Forms/Inzerat/Vypis.php
"56" (2)
1
0.220
explain ►
SELECT * 
FROM `c_countries` 
WHERE (`id` = ?)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEc_countriesconstPRIMARYPRIMARY4const1
.../export/boreas/app/models/Forms/Inzerat/Vypis.php
"189" (3)
1
8.474
explain ►
SELECT `inzeraty_detaily`.`nazev` AS `nazev`,`inzeraty_detaily`.`uvod` AS
`uvod`,`inzeraty_detaily`.`popis_pozice` AS `popis_pozice`,`inzeraty`.`id` AS
`iId`,`inzeraty`.`ref_cislo` AS `ref_cislo`,`inzeraty`.`datum_pocatku` AS
`datum_pocatku`,`c_okresy`.`nazev` AS `okres`,`c_kraje`.`nazev` AS `kraj` 
FROM `inzeraty_detaily` 
LEFT JOIN `inzeraty` ON `inzeraty_detaily`.`inzeraty_id` = `inzeraty`.`id` 
INNER JOIN `c_inzeraty_stavy` ON `inzeraty`.`c_inzeraty_stavy_id` = `c_inzeraty_stavy`.`id` 
LEFT JOIN `c_okresy` ON `inzeraty`.`c_okresy_id` = `c_okresy`.`id` 
LEFT JOIN `c_kraje` ON `c_okresy`.`c_kraje_id` = `c_kraje`.`id` 
WHERE (`c_inzeraty_stavy`.`zobrazit` = ?) AND (`inzeraty`.`datum_expirace` > CURDATE()) 
GROUP BY `inzeraty`.`id` 
ORDER BY `inzeraty`.`datum_pocatku` DESC, `inzeraty_detaily`.`id` ASC 
LIMIT 5 
OFFSET 5
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEinzeraty_detailyALLinzeraty_id738Using temporary; Using filesort
1SIMPLEinzeratyeq_refPRIMARY,c_inzeraty_stavy_idPRIMARY4boreas_db.inzeraty_detaily.inzeraty_id1Using where
1SIMPLEc_okresyeq_refPRIMARYPRIMARY4boreas_db.inzeraty.c_okresy_id1
1SIMPLEc_krajeeq_refPRIMARYPRIMARY4boreas_db.c_okresy.c_kraje_id1Using where
1SIMPLEc_inzeraty_stavyALLPRIMARY5Using where; Using join buffer (flat, BNL join)
.../export/boreas/temp/cache/_Nette.FileTemplate/_Inzeraty.vypis.latte-d54767c0eab81d9462408ad2f8cd4242.php
1
5
¤ ×

Unlogged

no identity

¤ ×

Queries: 2, time: 2.115 ms

Time msSQL StatementParamsRows
1.690
SHOW FULL COLUMNS 
FROM `app_log`
.../export/boreas/app/models/TableAbstract.php
7
0.425
INSERT INTO `app_log` (`date`, `ip`, `username`, `presenter`, `action`, `url`, `referer`) 
VALUES (?, '3.143.255.57', NULL, 'Inzeraty', 'vypis', ?, NULL)
.../export/boreas/app/models/TableAbstract.php
"2025-01-21T16:28:19+0100" (24)
Nette\Http\UrlScript(10) {
   scriptPath private => "/"
   scheme private => "https" (5)
   user private => ""
   pass private => ""
   host private => "kienbaum-jobportal.cz" (21)
   port private => 443
   path private => "/en/inzeraty/vypis" (18)
   query private => "do=changePage&page=3" (20)
   fragment private => ""
   frozen private => TRUE
}
1
¤ ×