Parameter | Value |
---|---|
lang |
en |
hash |
NULL
|
id |
NULL
|
page |
3 |
Matched? | Class | Mask | Defaults | Module | Request |
---|---|---|---|---|---|
no | CliRouter |
|
|
|
|
no | Route |
agreement/new/<kandidatId>/<hash> |
presenter = Agreement |
|
|
no | Route |
homepage/content/<content> |
presenter = Homepage |
|
|
no | Route |
contact/detail/<contact> |
presenter = Contact |
|
|
yes | HashRoute |
[<lang>/][<presenter>/<action>][/<id>/<hash>] |
presenter = Homepage |
|
Inzeraty:vypis |
Time ms | SQL Statement | Params | Rows | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0.279 explain ► | SELECT * FROM `c_ridici_urovne`
| 3 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.316 explain ► | SELECT * FROM `c_obory`
| 27 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.368 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`
| 22 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.308 explain ► | SELECT * FROM `c_countries` WHERE (`id` IN (56, 189))
| 2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
8.630 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
| 1
| 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.260 explain ► | SELECT * FROM `c_countries` WHERE (`id` = ?)
| "56" (2)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0.252 explain ► | SELECT * FROM `c_countries` WHERE (`id` = ?)
| "189" (3)
| 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
7.728 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
| 1
| 5 |
no identity
Time ms | SQL Statement | Params | Rows |
---|---|---|---|
1.481 | SHOW FULL COLUMNS FROM `app_log`.../export/boreas/app/models/TableAbstract.php | 7 | |
0.383 | INSERT INTO `app_log` (`date`, `ip`, `username`, `presenter`, `action`, `url`, `referer`) VALUES (?, '3.16.50.158', NULL, 'Inzeraty', 'vypis', ?, NULL).../export/boreas/app/models/TableAbstract.php | "2025-01-21T16:23:59+0100" (24)
Nette\Http\UrlScript(10)
| 1 |