JOB AGENCY, NVJ-EU s.r.o., agentura práce

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config
  userAgent56e44b44ee4eb3b7167bb1faff3442bd
  time2256432871
  countdown10
  languagecze
- Menu
  menu
  0
  Menu
  id1
  titleAdministrační menu
  keyadmin-menu
  can_delete0
  dir_prefix
  MenuItem
  0
  id7
  titleAdministrace
  url/admin/admin_manager/administration
  parent_id(null)
  menu_id1
  lft0
  rght1
  Parent(empty)
  Children(empty)
  1
  id6
  titleObsah
  url/admin/content_manager/contents
  parent_id(null)
  menu_id1
  lft2
  rght3
  Parent(empty)
  Children(empty)
  2
  id13
  titleMedia manager
  url/admin/media_manager/MediaCategories/user_index
  parent_id(null)
  menu_id1
  lft4
  rght5
  Parent(empty)
  Children(empty)
  3
  id69
  titleJídelní lístky
  url/admin/jidelni_listek/menu_lists/user_index
  parent_id(null)
  menu_id1
  lft6
  rght7
  Parent(empty)
  Children(empty)
  4
  id31
  titleOdhlásit se
  url/authake/user/logout
  parent_id(null)
  menu_id1
  lft8
  rght9
  Parent(empty)
  Children(empty)
  5
  id71
  titleŘemesla
  url/admin/khk/crafts
  parent_id(null)
  menu_id1
  lft10
  rght11
  Parent(empty)
  Children(empty)
  6
  id75
  titleCRM
  url/admin/crm/dashboard
  parent_id(null)
  menu_id1
  lft12
  rght13
  Parent(empty)
  Children(empty)
  children(empty)
  1
  Menu
  id18
  titleTop menu
  keytop-menu-cze
  can_delete1
  dir_prefix
  MenuItem
  0
  id84
  titlePředstavení společnosti
  url/predstaveni-spolecnosti
  parent_id(null)
  menu_id18
  lft18
  rght19
  Parent(empty)
  Children(empty)
  1
  id76
  titleProč využít naše služby
  url/proc-vyuzit-nase-sluzby
  parent_id(null)
  menu_id18
  lft20
  rght21
  Parent(empty)
  Children(empty)
  2
  id85
  titlePro firmy
  url/pro-firmy
  parent_id(null)
  menu_id18
  lft22
  rght23
  Parent(empty)
  Children(empty)
  3
  id77
  titleKontakty
  url/kontakty
  parent_id(null)
  menu_id18
  lft24
  rght25
  Parent(empty)
  Children(empty)
  children(empty)
  2
  Menu
  id25
  titleHlavní menu DE
  keyhlavni-menu-deu
  can_delete1
  dir_prefix
  MenuItem
  0
  id95
  titleHome
  url/
  parent_id(null)
  menu_id25
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id118
  titleUnsere Gesellschaft
  url/unsere-gesellschaft
  parent_id(null)
  menu_id25
  lft3
  rght4
  Parent(empty)
  Children(empty)
  children(empty)
  3
  Menu
  id26
  titleHome menu
  keyhome-menu-cze
  can_delete1
  dir_prefix
  MenuItem
  0
  id86
  titleVolná pracovní místa
  url/volna-pracovni-mista
  parent_id(null)
  menu_id26
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id108
  titleVolná pracovní místa v zahraničí
  url/volna-pracovni-mista-v-zahranici
  parent_id(null)
  menu_id26
  lft3
  rght4
  Parent(empty)
  Children(empty)
  2
  id87
  titlePovolení MPSV
  url/povoleni-mpsv
  parent_id(null)
  menu_id26
  lft5
  rght6
  Parent(empty)
  Children(empty)
  3
  id88
  titlePojištění proti úpadku
  url/ftp/pojistna-smlouva.pdf
  parent_id(null)
  menu_id26
  lft7
  rght8
  Parent(empty)
  Children(empty)
  children(empty)
  4
  Menu
  id27
  titleHlavní menu
  keyhlavni-menu-cze
  can_delete1
  dir_prefix
  MenuItem
  0
  id89
  titleÚvodní stránka
  url/
  parent_id(null)
  menu_id27
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id90
  titlePředstavení společnosti
  url/predstaveni-spolecnosti
  parent_id(null)
  menu_id27
  lft3
  rght4
  Parent(empty)
  Children(empty)
  children(empty)
  5
  Menu
  id28
  titleHlavní menu 2
  keyhlavni-menu2-cze
  can_delete1
  dir_prefix
  MenuItem
  0
  id91
  titleProč využít naše služby
  url/proc-vyuzit-nase-sluzby
  parent_id(null)
  menu_id28
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id92
  titleNabídka služeb
  url/nabidka-sluzeb
  parent_id(null)
  menu_id28
  lft3
  rght4
  Parent(empty)
  Children(empty)
  2
  id93
  titleZprostředkování zaměstnanců v oborech
  url/zprostredkovani-zamestnancu-v-oborech
  parent_id(null)
  menu_id28
  lft5
  rght18
  Parent(empty)
  Children
  0
  id94
  titleAutomobilový průmysl
  url/automobilovy-prumysl
  parent_id93
  menu_id28
  lft6
  rght7
  Parent
  id93
  titleZprostředkování zaměstnanců v oborech
  url/zprostredkovani-zamestnancu-v-oborech
  parent_id(null)
  menu_id28
  lft5
  rght18
  1
  id116
  titleOperátoři výrobních linek
  url/operatori-vyrobnich-linek
  parent_id93
  menu_id28
  lft8
  rght9
  Parent
  id93
  titleZprostředkování zaměstnanců v oborech
  url/zprostredkovani-zamestnancu-v-oborech
  parent_id(null)
  menu_id28
  lft5
  rght18
  2
  id112
  titleStrojírenství, kovovýroba a hutnictví
  url/strojirenstvi-kovovyroba-a-hutnictvi
  parent_id93
  menu_id28
  lft10
  rght11
  Parent
  id93
  titleZprostředkování zaměstnanců v oborech
  url/zprostredkovani-zamestnancu-v-oborech
  parent_id(null)
  menu_id28
  lft5
  rght18
  3
  id113
  titleDoprava a logistika
  url/doprava-a-logistika
  parent_id93
  menu_id28
  lft12
  rght13
  Parent
  id93
  titleZprostředkování zaměstnanců v oborech
  url/zprostredkovani-zamestnancu-v-oborech
  parent_id(null)
  menu_id28
  lft5
  rght18
  4
  id114
  titleElektronický a elektrotechnický průmysl
  url/elektronicky-a-elektrotechnicky-prumysl
  parent_id93
  menu_id28
  lft14
  rght15
  Parent
  id93
  titleZprostředkování zaměstnanců v oborech
  url/zprostredkovani-zamestnancu-v-oborech
  parent_id(null)
  menu_id28
  lft5
  rght18
  5
  id115
  titlePotravinářský průmysl
  url/potravinarsky-prumysl
  parent_id93
  menu_id28
  lft16
  rght17
  Parent
  id93
  titleZprostředkování zaměstnanců v oborech
  url/zprostredkovani-zamestnancu-v-oborech
  parent_id(null)
  menu_id28
  lft5
  rght18
  3
  id98
  titlePro zaměstnance
  url/pro-zamestnance
  parent_id(null)
  menu_id28
  lft19
  rght20
  Parent(empty)
  Children(empty)
  children(empty)
  6
  Menu
  id29
  titleTop menu DE
  keytop-menu-deu
  can_delete1
  dir_prefix
  MenuItem
  0
  id96
  titleUNSERE GESELLSCHAFT
  url/unsere-gesellschaft
  parent_id(null)
  menu_id29
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id104
  titleWARUM UNSERE DIENSTE
  url/warum-sollten-sie-unsere-dienste
  parent_id(null)
  menu_id29
  lft3
  rght4
  Parent(empty)
  Children(empty)
  2
  id105
  titleFÜR FIRMEN
  url/fur-firmen
  parent_id(null)
  menu_id29
  lft5
  rght6
  Parent(empty)
  Children(empty)
  3
  id106
  titleKONTAKTE
  url/kontakte
  parent_id(null)
  menu_id29
  lft7
  rght8
  Parent(empty)
  Children(empty)
  children(empty)
  7
  Menu
  id30
  titleHome menu DE
  keyhome-menu-deu
  can_delete1
  dir_prefix
  MenuItem
  0
  id117
  titleJobangebot
  url/jobvermittlung
  parent_id(null)
  menu_id30
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id109
  titleGenehmigung vom MAS
  url/genehmigung-vom-mas
  parent_id(null)
  menu_id30
  lft3
  rght4
  Parent(empty)
  Children(empty)
  2
  id97
  titleKonkursversicherung
  url/ftp/konkursversicherung.pdf
  parent_id(null)
  menu_id30
  lft5
  rght6
  Parent(empty)
  Children(empty)
  children(empty)
  8
  Menu
  id31
  titleHlavní menu 3
  keyhlavni-menu3-cze
  can_delete1
  dir_prefix
  MenuItem
  0
  id99
  titleVolná pracovní místa
  url/volna-pracovni-mista
  parent_id(null)
  menu_id31
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id110
  titleVolná pracovní místa - Německo
  url/volna-pracovni-mista-v-zahranici
  parent_id(null)
  menu_id31
  lft3
  rght4
  Parent(empty)
  Children(empty)
  children(empty)
  9
  Menu
  id32
  titleHlavní menu 4
  keyhlavni-menu4-cze
  can_delete1
  dir_prefix
  MenuItem
  0
  id100
  titlePro firmy
  url/pro-firmy
  parent_id(null)
  menu_id32
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id101
  titleReference
  url/reference
  parent_id(null)
  menu_id32
  lft3
  rght4
  Parent(empty)
  Children(empty)
  2
  id102
  titleSponzoring
  url/sponzoring
  parent_id(null)
  menu_id32
  lft5
  rght6
  Parent(empty)
  Children(empty)
  3
  id103
  titleKontakty
  url/kontakty
  parent_id(null)
  menu_id32
  lft7
  rght8
  Parent(empty)
  Children(empty)
  children(empty)
  10
  Menu
  id33
  titleHlavní menu2 DE
  keyhlavni-menu2-deu
  can_delete1
  dir_prefix
  MenuItem
  0
  id119
  titleWarum unsere Dienste
  url/warum-sollten-sie-unsere-dienste
  parent_id(null)
  menu_id33
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id120
  titleDienstleistungsangebot
  url/dienstleistungsangebot
  parent_id(null)
  menu_id33
  lft3
  rght4
  Parent(empty)
  Children(empty)
  2
  id121
  titleIndustriebranchen
  url/industriebranchen
  parent_id(null)
  menu_id33
  lft5
  rght18
  Parent(empty)
  Children
  0
  id128
  titleAutomobilindustrie
  url/automobilindustrie
  parent_id121
  menu_id33
  lft6
  rght7
  Parent
  id121
  titleIndustriebranchen
  url/industriebranchen
  parent_id(null)
  menu_id33
  lft5
  rght18
  1
  id129
  titleFertigungslinienmitarbeiter und Hilfsarbeiten
  url/fertigungslinienmitarbeiter-und-hilfsarbeiten
  parent_id121
  menu_id33
  lft8
  rght9
  Parent
  id121
  titleIndustriebranchen
  url/industriebranchen
  parent_id(null)
  menu_id33
  lft5
  rght18
  2
  id130
  titleMaschinenbau, Metallwirtschaft, Metallurgie
  url/maschinenbau-metallwirtschaft-und-metallurgie
  parent_id121
  menu_id33
  lft10
  rght11
  Parent
  id121
  titleIndustriebranchen
  url/industriebranchen
  parent_id(null)
  menu_id33
  lft5
  rght18
  3
  id131
  titleElektronik- und elektrotechnische Industrie
  url/elektronik-und-elektrotechnische-industrie
  parent_id121
  menu_id33
  lft12
  rght13
  Parent
  id121
  titleIndustriebranchen
  url/industriebranchen
  parent_id(null)
  menu_id33
  lft5
  rght18
  4
  id132
  titleTransport und Logistik
  url/transport-und-logistik
  parent_id121
  menu_id33
  lft14
  rght15
  Parent
  id121
  titleIndustriebranchen
  url/industriebranchen
  parent_id(null)
  menu_id33
  lft5
  rght18
  5
  id133
  titleLebensmittelindustrie
  url/lebensmittelindustrie
  parent_id121
  menu_id33
  lft16
  rght17
  Parent
  id121
  titleIndustriebranchen
  url/industriebranchen
  parent_id(null)
  menu_id33
  lft5
  rght18
  3
  id122
  titleFür Arbeitnehmer
  url/fur-arbeitnehmer
  parent_id(null)
  menu_id33
  lft19
  rght20
  Parent(empty)
  Children(empty)
  children(empty)
  11
  Menu
  id34
  titleHlavní menu3 DE
  keyhlavni-menu3-deu
  can_delete1
  dir_prefix
  MenuItem
  0
  id123
  titleJobvermittlung
  url/jobvermittlung
  parent_id(null)
  menu_id34
  lft1
  rght2
  Parent(empty)
  Children(empty)
  children(empty)
  12
  Menu
  id35
  titleHlavní menu4 DE
  keyhlavni-menu4-deu
  can_delete1
  dir_prefix
  MenuItem
  0
  id124
  titleFür Firmen
  url/fur-firmen
  parent_id(null)
  menu_id35
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id125
  titleReferenzen
  url/referenzen
  parent_id(null)
  menu_id35
  lft3
  rght4
  Parent(empty)
  Children(empty)
  2
  id126
  titleSponsoring
  url/sponsoring
  parent_id(null)
  menu_id35
  lft5
  rght6
  Parent(empty)
  Children(empty)
  3
  id127
  titleKontakte
  url/kontakte
  parent_id(null)
  menu_id35
  lft7
  rght8
  Parent(empty)
  Children(empty)
  children(empty)
  13
  Menu
  id36
  titleTop menu ENG
  keytop-menu-eng
  can_delete1
  dir_prefix
  MenuItem
  0
  id134
  titleAbout us
  url/about-us
  parent_id(null)
  menu_id36
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id135
  titleWhy use our services
  url/why-use-our-services
  parent_id(null)
  menu_id36
  lft3
  rght4
  Parent(empty)
  Children(empty)
  2
  id136
  titleFor companies
  url/for-companies
  parent_id(null)
  menu_id36
  lft5
  rght6
  Parent(empty)
  Children(empty)
  3
  id137
  titleContact us
  url/contact-us
  parent_id(null)
  menu_id36
  lft7
  rght8
  Parent(empty)
  Children(empty)
  children(empty)
  14
  Menu
  id37
  titleHome menu ENG
  keyhome-menu-eng
  can_delete1
  dir_prefix
  MenuItem
  0
  id140
  titlePermission from MLSA
  url/permission-from-mlsa
  parent_id(null)
  menu_id37
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id160
  titleInsurance against bankruptcy
  urlhttp://www.jobnvj.eu/ftp/konkursversicherung.pdf
  parent_id(null)
  menu_id37
  lft3
  rght4
  Parent(empty)
  Children(empty)
  children(empty)
  15
  Menu
  id38
  titleHlavní menu ENG
  keyhlavni-menu-eng
  can_delete1
  dir_prefix
  MenuItem
  0
  id142
  titleHome
  url/
  parent_id(null)
  menu_id38
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id143
  titleOur company
  url/our-company
  parent_id(null)
  menu_id38
  lft3
  rght4
  Parent(empty)
  Children(empty)
  children(empty)
  16
  Menu
  id39
  titleHlavní menu2 ENG
  keyhlavni-menu2-eng
  can_delete1
  dir_prefix
  MenuItem
  0
  id144
  titleWhy use our services
  url/why-use-our-services
  parent_id(null)
  menu_id39
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id145
  titleOur services
  url/our-services
  parent_id(null)
  menu_id39
  lft3
  rght4
  Parent(empty)
  Children(empty)
  2
  id146
  titleRecruiting workers
  url/recruiting-workers
  parent_id(null)
  menu_id39
  lft5
  rght18
  Parent(empty)
  Children
  0
  id147
  titleAutomotive industry
  url/automotive-industry
  parent_id146
  menu_id39
  lft6
  rght7
  Parent
  id146
  titleRecruiting workers
  url/recruiting-workers
  parent_id(null)
  menu_id39
  lft5
  rght18
  1
  id148
  titleProduction line operators
  url/production-line-operators
  parent_id146
  menu_id39
  lft8
  rght9
  Parent
  id146
  titleRecruiting workers
  url/recruiting-workers
  parent_id(null)
  menu_id39
  lft5
  rght18
  2
  id149
  titleEngineering, metal production and metallurgy
  url/engineerin-metal-production-and-metallurgy
  parent_id146
  menu_id39
  lft10
  rght11
  Parent
  id146
  titleRecruiting workers
  url/recruiting-workers
  parent_id(null)
  menu_id39
  lft5
  rght18
  3
  id150
  titleTransport and logistic
  url/transport-and-logistic
  parent_id146
  menu_id39
  lft12
  rght13
  Parent
  id146
  titleRecruiting workers
  url/recruiting-workers
  parent_id(null)
  menu_id39
  lft5
  rght18
  4
  id151
  titleElectronic and electrical industry
  url/electronic-and-electrical-industry
  parent_id146
  menu_id39
  lft14
  rght15
  Parent
  id146
  titleRecruiting workers
  url/recruiting-workers
  parent_id(null)
  menu_id39
  lft5
  rght18
  5
  id152
  titleFood industry
  url/food-industry
  parent_id146
  menu_id39
  lft16
  rght17
  Parent
  id146
  titleRecruiting workers
  url/recruiting-workers
  parent_id(null)
  menu_id39
  lft5
  rght18
  3
  id153
  titleFor employees
  url/for-employees
  parent_id(null)
  menu_id39
  lft19
  rght20
  Parent(empty)
  Children(empty)
  children(empty)
  17
  Menu
  id40
  titleHlavní menu3 ENG
  keyhlavni-menu3-eng
  can_delete1
  dir_prefix
  MenuItem
  0
  id154
  titleJob vacancies
  url/job-vacancies
  parent_id(null)
  menu_id40
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id155
  titleJob vacancies in Germany
  url/job-vacancies-in-germany
  parent_id(null)
  menu_id40
  lft3
  rght4
  Parent(empty)
  Children(empty)
  children(empty)
  18
  Menu
  id41
  titleHlavní menu4 ENG
  keyhlavni-menu4-eng
  can_delete1
  dir_prefix
  MenuItem
  0
  id156
  titleFor companies
  url/for-companies
  parent_id(null)
  menu_id41
  lft1
  rght2
  Parent(empty)
  Children(empty)
  1
  id157
  titleReferences
  url/references
  parent_id(null)
  menu_id41
  lft3
  rght4
  Parent(empty)
  Children(empty)
  2
  id158
  titleSponsorship and humanitarion work
  url/sponsorship-charity-and-humanitarion-work
  parent_id(null)
  menu_id41
  lft5
  rght6
  Parent(empty)
  Children(empty)
  3
  id159
  titleContact us
  url/contact-us
  parent_id(null)
  menu_id41
  lft7
  rght8
  Parent(empty)
  Children(empty)
  children(empty)
- Authake
  previousUrl(null)
  cacheRules
  0
  Rule
  id4
  namePovoleno pro všechny
  group_id(null)
  order(null)
  action.*
  permissionAllow
  forward
  messageAccess denied!
  Group
  id(null)
  name(null)
  1
  Rule
  id8
  nameZákaz administrace
  group_id(null)
  order0
  action\/admin\/.*
  permission
  forward
  message
  Group
  id(null)
  name(null)
  2
  Rule
  id6
  nameDisplay a message for denied admin page
  group_id(null)
  order100
  action\/authake(\/index)?|\/authake\/users.*|\/authake\/groups.*|\/authake\/rules.*
  permission
  forward
  messageYou are not allowed to access the administration page!
  Group
  id(null)
  name(null)
  3
  Rule
  id2
  nameAllow anybody to see the home page, the error page, to register, to log in, see profile and log out
  group_id(null)
  order101
  action\/|\/authake\/user\/.*|\/register|\/login|\/logout|\/lost-password|\/verify(\/)?.*|\/pass(\/)?.*|\/profile|\/denied|\/pages(\/)?.*|\/\/pages\/.*
  permissionDeny
  forward
  message
  Group
  id(null)
  name(null)
  4
  Rule
  id7
  nameMenu builder allowed for everyone
  group_id(null)
  order705
  action\/menu_builder\/.*
  permissionDeny
  forward
  message
  Group
  id(null)
  name(null)
  cacheRulesTime1656432931
====
Request
+
Request

Cake Params
- plugin(null)
- controllerpages
- actiondisplay
- pagevolna-pracovni-mista-v-zahranici
- named(empty)
- pass
  0volna-pracovni-mista-v-zahranici
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys
  0page
- options
  page_automobilovy-prumysl|_odvetvi-prumyslu|_predstaveni-spolecnosti|_proc-vyuzit-nase-sluzby|jobvermittlung|volna-pracovni-mista-v-zahranici|volna-pracovni-mista|zasady-pouzivani-cookies
  pass
  0page
- defaults
  controllerpages
  actiondisplay
  plugin(null)
- template/:page
====

Sql Logs

default

Total Time: 9 ms
Total Queries: 119 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Content`.`slug` FROM `jobnvj`.`contents` AS `Content` WHERE 1 = 1	67	67	2
SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`key`, `Menu`.`can_delete`, `Menu`.`dir_prefix` FROM `jobnvj`.`menus` AS `Menu` WHERE 1 = 1	19	19	2	maybe slow
SELECT `MenuItem`.`id`, `MenuItem`.`title`, `MenuItem`.`url`, `MenuItem`.`parent_id`, `MenuItem`.`menu_id`, `MenuItem`.`lft`, `MenuItem`.`rght` FROM `jobnvj`.`menu_items` AS `MenuItem` WHERE `parent_id` IS NULL AND `MenuItem`.`menu_id` IN (1, 18, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41) ORDER BY `MenuItem`.`lft` asc	63	63	0
SELECT `Children`.`id`, `Children`.`title`, `Children`.`url`, `Children`.`parent_id`, `Children`.`menu_id`, `Children`.`lft`, `Children`.`rght` FROM `jobnvj`.`menu_items` AS `Children` WHERE `Children`.`parent_id` IN (7, 86, 89, 91, 95, 96, 99, 100, 117, 119, 123, 124, 134, 140, 142, 144, 154, 156, 6, 90, 92, 118, 101, 104, 108, 109, 110, 120, 125, 135, 143, 160, 145, 155, 157, 13, 87, 93, 97, 102, 105, 121, 126, 136, 146, 158, 69, 88, 103, 106, 127, 137, 159, 31, 71, 75, 84, 98, 122, 153, 76, 85, 77) ORDER BY `Children`.`lft` asc	18	18	1	maybe slow
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Children`.`id`, `Children`.`title`, `Children`.`url`, `Children`.`parent_id`, `Children`.`menu_id`, `Children`.`lft`, `Children`.`rght` FROM `jobnvj`.`menu_items` AS `Children` WHERE `Children`.`parent_id` IN (94, 128, 147, 116, 129, 148, 112, 130, 149, 113, 131, 150, 114, 132, 151, 115, 133, 152) ORDER BY `Children`.`lft` asc	0	0	0
SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`key`, `Menu`.`can_delete`, `Menu`.`dir_prefix` FROM `jobnvj`.`menus` AS `Menu` WHERE 1 = 1	19	19	0
SELECT `MenuItem`.`id`, `MenuItem`.`title`, `MenuItem`.`url`, `MenuItem`.`parent_id`, `MenuItem`.`menu_id`, `MenuItem`.`lft`, `MenuItem`.`rght` FROM `jobnvj`.`menu_items` AS `MenuItem` WHERE `parent_id` IS NULL AND `MenuItem`.`menu_id` IN (1, 18, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41) ORDER BY `MenuItem`.`lft` asc	63	63	0
SELECT `Children`.`id`, `Children`.`title`, `Children`.`url`, `Children`.`parent_id`, `Children`.`menu_id`, `Children`.`lft`, `Children`.`rght` FROM `jobnvj`.`menu_items` AS `Children` WHERE `Children`.`parent_id` IN (7, 86, 89, 91, 95, 96, 99, 100, 117, 119, 123, 124, 134, 140, 142, 144, 154, 156, 6, 90, 92, 118, 101, 104, 108, 109, 110, 120, 125, 135, 143, 160, 145, 155, 157, 13, 87, 93, 97, 102, 105, 121, 126, 136, 146, 158, 69, 88, 103, 106, 127, 137, 159, 31, 71, 75, 84, 98, 122, 153, 76, 85, 77) ORDER BY `Children`.`lft` asc	18	18	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Children`.`id`, `Children`.`title`, `Children`.`url`, `Children`.`parent_id`, `Children`.`menu_id`, `Children`.`lft`, `Children`.`rght` FROM `jobnvj`.`menu_items` AS `Children` WHERE `Children`.`parent_id` IN (94, 128, 147, 116, 129, 148, 112, 130, 149, 113, 131, 150, 114, 132, 151, 115, 133, 152) ORDER BY `Children`.`lft` asc	0	0	0
SELECT `Content`.`id`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`keywords`, `Content`.`description`, `Content`.`title`, `Content`.`body`, `Content`.`created`, `Content`.`updated`, `Content`.`content_type_id`, `Content`.`www`, `Content`.`email`, `Content`.`perex`, `Content`.`varchar_1`, `Content`.`varchar_2`, `Content`.`varchar_3`, `Content`.`text_1`, `Content`.`text_2`, `Content`.`text_3`, `Content`.`date_1`, `Content`.`date_2`, `Content`.`date_3`, `Content`.`datetime_1`, `Content`.`datetime_2`, `Content`.`datetime_3`, `Content`.`checkbox_1`, `Content`.`checkbox_2`, `Content`.`checkbox_3`, `Content`.`top`, `Content`.`active`, `Content`.`attach_1`, `Content`.`attach_1_title`, `Content`.`attach_2`, `Content`.`attach_2_title`, `Content`.`attach_3`, `Content`.`attach_3_title`, `Content`.`image_1`, `Content`.`image_1_title`, `Content`.`image_2`, `Content`.`image_2_title`, `Content`.`image_3`, `Content`.`image_3_title`, `Content`.`date_from`, `Content`.`date_to`, `Content`.`m002gallery_id`, `Content`.`parent_content_id`, `Content`.`number_1`, `Content`.`number_2`, `Content`.`number_3`, `ContentType`.`id`, `ContentType`.`title`, `ContentType`.`created`, `ContentType`.`show_body`, `ContentType`.`show_title`, `ContentType`.`show_www`, `ContentType`.`show_email`, `ContentType`.`show_perex`, `ContentType`.`count_view`, `ContentType`.`date_last_view`, `ContentType`.`varchar_1`, `ContentType`.`varchar_2`, `ContentType`.`varchar_3`, `ContentType`.`text_1`, `ContentType`.`text_2`, `ContentType`.`text_3`, `ContentType`.`date_1`, `ContentType`.`date_2`, `ContentType`.`date_3`, `ContentType`.`datetime_1`, `ContentType`.`datetime_2`, `ContentType`.`datetime_3`, `ContentType`.`checkbox_1`, `ContentType`.`checkbox_2`, `ContentType`.`checkbox_3`, `ContentType`.`show_top`, `ContentType`.`show_active`, `ContentType`.`attach_1`, `ContentType`.`attach_2`, `ContentType`.`attach_3`, `ContentType`.`image_1`, `ContentType`.`image_2`, `ContentType`.`image_3`, `ContentType`.`admin_order_by`, `ContentType`.`show_date_from`, `ContentType`.`show_date_to`, `ContentType`.`all_content`, `ContentType`.`column_list`, `ContentType`.`description`, `ContentType`.`sort_by`, `ContentType`.`show_media`, `ContentType`.`children_content_type_id`, `ContentType`.`content_type_date_id`, `ContentType`.`number_1`, `ContentType`.`number_2`, `ContentType`.`number_3`, `ContentType`.`show_slug`, `ContentType`.`sort`, `ContentType`.`can_item_delete`, `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`created`, `Gallery`.`autor`, `Gallery`.`typ`, `Gallery`.`text`, `Gallery`.`key`, `Gallery`.`zkraceny`, `Gallery`.`sort`, `Gallery`.`slug`, `Gallery`.`media_category_id` FROM `jobnvj`.`contents` AS `Content` LEFT JOIN `jobnvj`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `jobnvj`.`m002gallery` AS `Gallery` ON (`Content`.`m002gallery_id` = `Gallery`.`id`) WHERE `content_type_id` = 21 ORDER BY `Content`.`date_from` asc LIMIT 10	0	0	1	maybe slow
SELECT COUNT(*) AS `count` FROM `jobnvj`.`contents` AS `Content` LEFT JOIN `jobnvj`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `jobnvj`.`m002gallery` AS `Gallery` ON (`Content`.`m002gallery_id` = `Gallery`.`id`) WHERE `content_type_id` = 21	1	1	0
SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`key`, `Menu`.`can_delete`, `Menu`.`dir_prefix` FROM `jobnvj`.`menus` AS `Menu` WHERE 1 = 1	19	19	0
SELECT `MenuItem`.`id`, `MenuItem`.`title`, `MenuItem`.`url`, `MenuItem`.`parent_id`, `MenuItem`.`menu_id`, `MenuItem`.`lft`, `MenuItem`.`rght` FROM `jobnvj`.`menu_items` AS `MenuItem` WHERE `parent_id` IS NULL AND `MenuItem`.`menu_id` IN (1, 18, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41) ORDER BY `MenuItem`.`lft` asc	63	63	0
SELECT `Children`.`id`, `Children`.`title`, `Children`.`url`, `Children`.`parent_id`, `Children`.`menu_id`, `Children`.`lft`, `Children`.`rght` FROM `jobnvj`.`menu_items` AS `Children` WHERE `Children`.`parent_id` IN (7, 86, 89, 91, 95, 96, 99, 100, 117, 119, 123, 124, 134, 140, 142, 144, 154, 156, 6, 90, 92, 118, 101, 104, 108, 109, 110, 120, 125, 135, 143, 160, 145, 155, 157, 13, 87, 93, 97, 102, 105, 121, 126, 136, 146, 158, 69, 88, 103, 106, 127, 137, 159, 31, 71, 75, 84, 98, 122, 153, 76, 85, 77) ORDER BY `Children`.`lft` asc	18	18	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Children`.`id`, `Children`.`title`, `Children`.`url`, `Children`.`parent_id`, `Children`.`menu_id`, `Children`.`lft`, `Children`.`rght` FROM `jobnvj`.`menu_items` AS `Children` WHERE `Children`.`parent_id` IN (94, 128, 147, 116, 129, 148, 112, 130, 149, 113, 131, 150, 114, 132, 151, 115, 133, 152) ORDER BY `Children`.`lft` asc	0	0	0
SELECT `Content`.`id`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`keywords`, `Content`.`description`, `Content`.`title`, `Content`.`body`, `Content`.`created`, `Content`.`updated`, `Content`.`content_type_id`, `Content`.`www`, `Content`.`email`, `Content`.`perex`, `Content`.`varchar_1`, `Content`.`varchar_2`, `Content`.`varchar_3`, `Content`.`text_1`, `Content`.`text_2`, `Content`.`text_3`, `Content`.`date_1`, `Content`.`date_2`, `Content`.`date_3`, `Content`.`datetime_1`, `Content`.`datetime_2`, `Content`.`datetime_3`, `Content`.`checkbox_1`, `Content`.`checkbox_2`, `Content`.`checkbox_3`, `Content`.`top`, `Content`.`active`, `Content`.`attach_1`, `Content`.`attach_1_title`, `Content`.`attach_2`, `Content`.`attach_2_title`, `Content`.`attach_3`, `Content`.`attach_3_title`, `Content`.`image_1`, `Content`.`image_1_title`, `Content`.`image_2`, `Content`.`image_2_title`, `Content`.`image_3`, `Content`.`image_3_title`, `Content`.`date_from`, `Content`.`date_to`, `Content`.`m002gallery_id`, `Content`.`parent_content_id`, `Content`.`number_1`, `Content`.`number_2`, `Content`.`number_3`, `ContentType`.`id`, `ContentType`.`title`, `ContentType`.`created`, `ContentType`.`show_body`, `ContentType`.`show_title`, `ContentType`.`show_www`, `ContentType`.`show_email`, `ContentType`.`show_perex`, `ContentType`.`count_view`, `ContentType`.`date_last_view`, `ContentType`.`varchar_1`, `ContentType`.`varchar_2`, `ContentType`.`varchar_3`, `ContentType`.`text_1`, `ContentType`.`text_2`, `ContentType`.`text_3`, `ContentType`.`date_1`, `ContentType`.`date_2`, `ContentType`.`date_3`, `ContentType`.`datetime_1`, `ContentType`.`datetime_2`, `ContentType`.`datetime_3`, `ContentType`.`checkbox_1`, `ContentType`.`checkbox_2`, `ContentType`.`checkbox_3`, `ContentType`.`show_top`, `ContentType`.`show_active`, `ContentType`.`attach_1`, `ContentType`.`attach_2`, `ContentType`.`attach_3`, `ContentType`.`image_1`, `ContentType`.`image_2`, `ContentType`.`image_3`, `ContentType`.`admin_order_by`, `ContentType`.`show_date_from`, `ContentType`.`show_date_to`, `ContentType`.`all_content`, `ContentType`.`column_list`, `ContentType`.`description`, `ContentType`.`sort_by`, `ContentType`.`show_media`, `ContentType`.`children_content_type_id`, `ContentType`.`content_type_date_id`, `ContentType`.`number_1`, `ContentType`.`number_2`, `ContentType`.`number_3`, `ContentType`.`show_slug`, `ContentType`.`sort`, `ContentType`.`can_item_delete`, `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`created`, `Gallery`.`autor`, `Gallery`.`typ`, `Gallery`.`text`, `Gallery`.`key`, `Gallery`.`zkraceny`, `Gallery`.`sort`, `Gallery`.`slug`, `Gallery`.`media_category_id` FROM `jobnvj`.`contents` AS `Content` LEFT JOIN `jobnvj`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `jobnvj`.`m002gallery` AS `Gallery` ON (`Content`.`m002gallery_id` = `Gallery`.`id`) WHERE `content_type_id` = 22 ORDER BY `Content`.`date_from` asc LIMIT 10	0	0	1	maybe slow
SELECT COUNT(*) AS `count` FROM `jobnvj`.`contents` AS `Content` LEFT JOIN `jobnvj`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `jobnvj`.`m002gallery` AS `Gallery` ON (`Content`.`m002gallery_id` = `Gallery`.`id`) WHERE `content_type_id` = 22	1	1	0
SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`key`, `Menu`.`can_delete`, `Menu`.`dir_prefix` FROM `jobnvj`.`menus` AS `Menu` WHERE 1 = 1	19	19	0
SELECT `MenuItem`.`id`, `MenuItem`.`title`, `MenuItem`.`url`, `MenuItem`.`parent_id`, `MenuItem`.`menu_id`, `MenuItem`.`lft`, `MenuItem`.`rght` FROM `jobnvj`.`menu_items` AS `MenuItem` WHERE `parent_id` IS NULL AND `MenuItem`.`menu_id` IN (1, 18, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41) ORDER BY `MenuItem`.`lft` asc	63	63	0
SELECT `Children`.`id`, `Children`.`title`, `Children`.`url`, `Children`.`parent_id`, `Children`.`menu_id`, `Children`.`lft`, `Children`.`rght` FROM `jobnvj`.`menu_items` AS `Children` WHERE `Children`.`parent_id` IN (7, 86, 89, 91, 95, 96, 99, 100, 117, 119, 123, 124, 134, 140, 142, 144, 154, 156, 6, 90, 92, 118, 101, 104, 108, 109, 110, 120, 125, 135, 143, 160, 145, 155, 157, 13, 87, 93, 97, 102, 105, 121, 126, 136, 146, 158, 69, 88, 103, 106, 127, 137, 159, 31, 71, 75, 84, 98, 122, 153, 76, 85, 77) ORDER BY `Children`.`lft` asc	18	18	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Children`.`id`, `Children`.`title`, `Children`.`url`, `Children`.`parent_id`, `Children`.`menu_id`, `Children`.`lft`, `Children`.`rght` FROM `jobnvj`.`menu_items` AS `Children` WHERE `Children`.`parent_id` IN (94, 128, 147, 116, 129, 148, 112, 130, 149, 113, 131, 150, 114, 132, 151, 115, 133, 152) ORDER BY `Children`.`lft` asc	0	0	0
SELECT `Content`.`id`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`keywords`, `Content`.`description`, `Content`.`title`, `Content`.`body`, `Content`.`created`, `Content`.`updated`, `Content`.`content_type_id`, `Content`.`www`, `Content`.`email`, `Content`.`perex`, `Content`.`varchar_1`, `Content`.`varchar_2`, `Content`.`varchar_3`, `Content`.`text_1`, `Content`.`text_2`, `Content`.`text_3`, `Content`.`date_1`, `Content`.`date_2`, `Content`.`date_3`, `Content`.`datetime_1`, `Content`.`datetime_2`, `Content`.`datetime_3`, `Content`.`checkbox_1`, `Content`.`checkbox_2`, `Content`.`checkbox_3`, `Content`.`top`, `Content`.`active`, `Content`.`attach_1`, `Content`.`attach_1_title`, `Content`.`attach_2`, `Content`.`attach_2_title`, `Content`.`attach_3`, `Content`.`attach_3_title`, `Content`.`image_1`, `Content`.`image_1_title`, `Content`.`image_2`, `Content`.`image_2_title`, `Content`.`image_3`, `Content`.`image_3_title`, `Content`.`date_from`, `Content`.`date_to`, `Content`.`m002gallery_id`, `Content`.`parent_content_id`, `Content`.`number_1`, `Content`.`number_2`, `Content`.`number_3`, `ContentType`.`id`, `ContentType`.`title`, `ContentType`.`created`, `ContentType`.`show_body`, `ContentType`.`show_title`, `ContentType`.`show_www`, `ContentType`.`show_email`, `ContentType`.`show_perex`, `ContentType`.`count_view`, `ContentType`.`date_last_view`, `ContentType`.`varchar_1`, `ContentType`.`varchar_2`, `ContentType`.`varchar_3`, `ContentType`.`text_1`, `ContentType`.`text_2`, `ContentType`.`text_3`, `ContentType`.`date_1`, `ContentType`.`date_2`, `ContentType`.`date_3`, `ContentType`.`datetime_1`, `ContentType`.`datetime_2`, `ContentType`.`datetime_3`, `ContentType`.`checkbox_1`, `ContentType`.`checkbox_2`, `ContentType`.`checkbox_3`, `ContentType`.`show_top`, `ContentType`.`show_active`, `ContentType`.`attach_1`, `ContentType`.`attach_2`, `ContentType`.`attach_3`, `ContentType`.`image_1`, `ContentType`.`image_2`, `ContentType`.`image_3`, `ContentType`.`admin_order_by`, `ContentType`.`show_date_from`, `ContentType`.`show_date_to`, `ContentType`.`all_content`, `ContentType`.`column_list`, `ContentType`.`description`, `ContentType`.`sort_by`, `ContentType`.`show_media`, `ContentType`.`children_content_type_id`, `ContentType`.`content_type_date_id`, `ContentType`.`number_1`, `ContentType`.`number_2`, `ContentType`.`number_3`, `ContentType`.`show_slug`, `ContentType`.`sort`, `ContentType`.`can_item_delete`, `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`created`, `Gallery`.`autor`, `Gallery`.`typ`, `Gallery`.`text`, `Gallery`.`key`, `Gallery`.`zkraceny`, `Gallery`.`sort`, `Gallery`.`slug`, `Gallery`.`media_category_id` FROM `jobnvj`.`contents` AS `Content` LEFT JOIN `jobnvj`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `jobnvj`.`m002gallery` AS `Gallery` ON (`Content`.`m002gallery_id` = `Gallery`.`id`) WHERE `content_type_id` = 23 ORDER BY `Content`.`date_from` asc LIMIT 10	0	0	1	maybe slow
SELECT COUNT(*) AS `count` FROM `jobnvj`.`contents` AS `Content` LEFT JOIN `jobnvj`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `jobnvj`.`m002gallery` AS `Gallery` ON (`Content`.`m002gallery_id` = `Gallery`.`id`) WHERE `content_type_id` = 23	1	1	0
SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`key`, `Menu`.`can_delete`, `Menu`.`dir_prefix` FROM `jobnvj`.`menus` AS `Menu` WHERE 1 = 1	19	19	0
SELECT `MenuItem`.`id`, `MenuItem`.`title`, `MenuItem`.`url`, `MenuItem`.`parent_id`, `MenuItem`.`menu_id`, `MenuItem`.`lft`, `MenuItem`.`rght` FROM `jobnvj`.`menu_items` AS `MenuItem` WHERE `parent_id` IS NULL AND `MenuItem`.`menu_id` IN (1, 18, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41) ORDER BY `MenuItem`.`lft` asc	63	63	0
SELECT `Children`.`id`, `Children`.`title`, `Children`.`url`, `Children`.`parent_id`, `Children`.`menu_id`, `Children`.`lft`, `Children`.`rght` FROM `jobnvj`.`menu_items` AS `Children` WHERE `Children`.`parent_id` IN (7, 86, 89, 91, 95, 96, 99, 100, 117, 119, 123, 124, 134, 140, 142, 144, 154, 156, 6, 90, 92, 118, 101, 104, 108, 109, 110, 120, 125, 135, 143, 160, 145, 155, 157, 13, 87, 93, 97, 102, 105, 121, 126, 136, 146, 158, 69, 88, 103, 106, 127, 137, 159, 31, 71, 75, 84, 98, 122, 153, 76, 85, 77) ORDER BY `Children`.`lft` asc	18	18	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 93	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 121	1	1	0
SELECT `Parent`.`id`, `Parent`.`title`, `Parent`.`url`, `Parent`.`parent_id`, `Parent`.`menu_id`, `Parent`.`lft`, `Parent`.`rght` FROM `jobnvj`.`menu_items` AS `Parent` WHERE `Parent`.`id` = 146	1	1	0
SELECT `Children`.`id`, `Children`.`title`, `Children`.`url`, `Children`.`parent_id`, `Children`.`menu_id`, `Children`.`lft`, `Children`.`rght` FROM `jobnvj`.`menu_items` AS `Children` WHERE `Children`.`parent_id` IN (94, 128, 147, 116, 129, 148, 112, 130, 149, 113, 131, 150, 114, 132, 151, 115, 133, 152) ORDER BY `Children`.`lft` asc	0	0	0
SELECT `Content`.`id`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`keywords`, `Content`.`description`, `Content`.`title`, `Content`.`body`, `Content`.`created`, `Content`.`updated`, `Content`.`content_type_id`, `Content`.`www`, `Content`.`email`, `Content`.`perex`, `Content`.`varchar_1`, `Content`.`varchar_2`, `Content`.`varchar_3`, `Content`.`text_1`, `Content`.`text_2`, `Content`.`text_3`, `Content`.`date_1`, `Content`.`date_2`, `Content`.`date_3`, `Content`.`datetime_1`, `Content`.`datetime_2`, `Content`.`datetime_3`, `Content`.`checkbox_1`, `Content`.`checkbox_2`, `Content`.`checkbox_3`, `Content`.`top`, `Content`.`active`, `Content`.`attach_1`, `Content`.`attach_1_title`, `Content`.`attach_2`, `Content`.`attach_2_title`, `Content`.`attach_3`, `Content`.`attach_3_title`, `Content`.`image_1`, `Content`.`image_1_title`, `Content`.`image_2`, `Content`.`image_2_title`, `Content`.`image_3`, `Content`.`image_3_title`, `Content`.`date_from`, `Content`.`date_to`, `Content`.`m002gallery_id`, `Content`.`parent_content_id`, `Content`.`number_1`, `Content`.`number_2`, `Content`.`number_3`, `ContentType`.`id`, `ContentType`.`title`, `ContentType`.`created`, `ContentType`.`show_body`, `ContentType`.`show_title`, `ContentType`.`show_www`, `ContentType`.`show_email`, `ContentType`.`show_perex`, `ContentType`.`count_view`, `ContentType`.`date_last_view`, `ContentType`.`varchar_1`, `ContentType`.`varchar_2`, `ContentType`.`varchar_3`, `ContentType`.`text_1`, `ContentType`.`text_2`, `ContentType`.`text_3`, `ContentType`.`date_1`, `ContentType`.`date_2`, `ContentType`.`date_3`, `ContentType`.`datetime_1`, `ContentType`.`datetime_2`, `ContentType`.`datetime_3`, `ContentType`.`checkbox_1`, `ContentType`.`checkbox_2`, `ContentType`.`checkbox_3`, `ContentType`.`show_top`, `ContentType`.`show_active`, `ContentType`.`attach_1`, `ContentType`.`attach_2`, `ContentType`.`attach_3`, `ContentType`.`image_1`, `ContentType`.`image_2`, `ContentType`.`image_3`, `ContentType`.`admin_order_by`, `ContentType`.`show_date_from`, `ContentType`.`show_date_to`, `ContentType`.`all_content`, `ContentType`.`column_list`, `ContentType`.`description`, `ContentType`.`sort_by`, `ContentType`.`show_media`, `ContentType`.`children_content_type_id`, `ContentType`.`content_type_date_id`, `ContentType`.`number_1`, `ContentType`.`number_2`, `ContentType`.`number_3`, `ContentType`.`show_slug`, `ContentType`.`sort`, `ContentType`.`can_item_delete`, `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`created`, `Gallery`.`autor`, `Gallery`.`typ`, `Gallery`.`text`, `Gallery`.`key`, `Gallery`.`zkraceny`, `Gallery`.`sort`, `Gallery`.`slug`, `Gallery`.`media_category_id` FROM `jobnvj`.`contents` AS `Content` LEFT JOIN `jobnvj`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `jobnvj`.`m002gallery` AS `Gallery` ON (`Content`.`m002gallery_id` = `Gallery`.`id`) WHERE `content_type_id` = 24 ORDER BY `Content`.`date_from` asc LIMIT 10	0	0	1	maybe slow
SELECT COUNT(*) AS `count` FROM `jobnvj`.`contents` AS `Content` LEFT JOIN `jobnvj`.`content_types` AS `ContentType` ON (`Content`.`content_type_id` = `ContentType`.`id`) LEFT JOIN `jobnvj`.`m002gallery` AS `Gallery` ON (`Content`.`m002gallery_id` = `Gallery`.`id`) WHERE `content_type_id` = 24	1	1	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

authake

Total Time: 0 ms
Total Queries: 5 queries

Query	Affected	Num. rows
SELECT `Rule`.`id`, `Rule`.`name`, `Rule`.`group_id`, `Rule`.`order`, `Rule`.`action`, `Rule`.`permission`, `Rule`.`forward`, `Rule`.`message`, `Group`.`id`, `Group`.`name` FROM `jobnvj`.`authake_rules` AS `Rule` LEFT JOIN `jobnvj`.`authake_groups` AS `Group` ON (`Rule`.`group_id` = `Group`.`id`) WHERE `Rule`.`group_id` is NULL ORDER BY `Rule`.`order` ASC, `Rule`.`group_id` ASC, `Rule`.`order` ASC	5	5
SELECT `Rule`.`id`, `Rule`.`name`, `Rule`.`group_id`, `Rule`.`order`, `Rule`.`action`, `Rule`.`permission`, `Rule`.`forward`, `Rule`.`message`, `Group`.`id`, `Group`.`name` FROM `jobnvj`.`authake_rules` AS `Rule` LEFT JOIN `jobnvj`.`authake_groups` AS `Group` ON (`Rule`.`group_id` = `Group`.`id`) WHERE `Rule`.`group_id` is NULL ORDER BY `Rule`.`order` ASC, `Rule`.`group_id` ASC, `Rule`.`order` ASC	5	5
SELECT `Rule`.`id`, `Rule`.`name`, `Rule`.`group_id`, `Rule`.`order`, `Rule`.`action`, `Rule`.`permission`, `Rule`.`forward`, `Rule`.`message`, `Group`.`id`, `Group`.`name` FROM `jobnvj`.`authake_rules` AS `Rule` LEFT JOIN `jobnvj`.`authake_groups` AS `Group` ON (`Rule`.`group_id` = `Group`.`id`) WHERE `Rule`.`group_id` is NULL ORDER BY `Rule`.`order` ASC, `Rule`.`group_id` ASC, `Rule`.`order` ASC	5	5
SELECT `Rule`.`id`, `Rule`.`name`, `Rule`.`group_id`, `Rule`.`order`, `Rule`.`action`, `Rule`.`permission`, `Rule`.`forward`, `Rule`.`message`, `Group`.`id`, `Group`.`name` FROM `jobnvj`.`authake_rules` AS `Rule` LEFT JOIN `jobnvj`.`authake_groups` AS `Group` ON (`Rule`.`group_id` = `Group`.`id`) WHERE `Rule`.`group_id` is NULL ORDER BY `Rule`.`order` ASC, `Rule`.`group_id` ASC, `Rule`.`order` ASC	5	5
SELECT `Rule`.`id`, `Rule`.`name`, `Rule`.`group_id`, `Rule`.`order`, `Rule`.`action`, `Rule`.`permission`, `Rule`.`forward`, `Rule`.`message`, `Group`.`id`, `Group`.`name` FROM `jobnvj`.`authake_rules` AS `Rule` LEFT JOIN `jobnvj`.`authake_groups` AS `Group` ON (`Rule`.`group_id` = `Group`.`id`) WHERE `Rule`.`group_id` is NULL ORDER BY `Rule`.`order` ASC, `Rule`.`group_id` ASC, `Rule`.`order` ASC	5	5

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 16.29 MB

Message	Memory use
Component initialization	5.25 MB
Controller action start	6.84 MB
Controller render start	6.90 MB
Component initialization #2	9.61 MB
Controller action start #2	10.04 MB
Component initialization #3	10.66 MB
Controller action start #3	10.81 MB
Component initialization #4	10.84 MB
Controller action start #4	10.99 MB
Component initialization #5	11.01 MB
Controller action start #5	11.16 MB
View render complete	11.12 MB

Timers

Total Request Time: 427 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	49.26
Component initialization and startup	56.51
Controller action	0.20
Render Controller Action	177.36
» Rendering View	176.38
» » Rendering APP/View/Pages/volna-pracovni-mista-v-zahranici.ctp	155.49
» » » Rendering APP/View/Elements/content_manager_volna_pracovni_mista.ctp	154.48
» » » » Component initialization and startup #2	16.65
Controller action #2	0.00
» » » » » Component initialization and startup #3	16.20
Controller action #3	0.00
» » » » » » Component initialization and startup #4	15.93
Controller action #4	0.00
» » » » » » » Component initialization and startup #5	15.77
Controller action #5	0.00
» » » » » » Rendering APP/View/Layouts/default.ctp	2.10

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- pagevolna-pracovni-mista-v-zahranici
- subpage(null)
- title_for_layoutVolna-pracovni-mista-v-zahranici
- menuAktivniPolozky(empty)
- menu
  admin-menu
  0
  url/admin/admin_manager/administration
  titleAdministrace
  1
  url/admin/content_manager/contents
  titleObsah
  2
  url/admin/media_manager/MediaCategories/user_index
  titleMedia manager
  3
  url/admin/jidelni_listek/menu_lists/user_index
  titleJídelní lístky
  4
  url/authake/user/logout
  titleOdhlásit se
  5
  url/admin/khk/crafts
  titleŘemesla
  6
  url/admin/crm/dashboard
  titleCRM
  top-menu-cze
  0
  url/predstaveni-spolecnosti
  titlePředstavení společnosti
  1
  url/proc-vyuzit-nase-sluzby
  titleProč využít naše služby
  2
  url/pro-firmy
  titlePro firmy
  3
  url/kontakty
  titleKontakty
  hlavni-menu-deu
  0
  url/
  titleHome
  1
  url/unsere-gesellschaft
  titleUnsere Gesellschaft
  home-menu-cze
  0
  url/volna-pracovni-mista
  titleVolná pracovní místa
  1
  url/volna-pracovni-mista-v-zahranici
  titleVolná pracovní místa v zahraničí
  2
  url/povoleni-mpsv
  titlePovolení MPSV
  3
  url/ftp/pojistna-smlouva.pdf
  titlePojištění proti úpadku
  hlavni-menu-cze
  0
  url/
  titleÚvodní stránka
  1
  url/predstaveni-spolecnosti
  titlePředstavení společnosti
  hlavni-menu2-cze
  0
  url/proc-vyuzit-nase-sluzby
  titleProč využít naše služby
  1
  url/nabidka-sluzeb
  titleNabídka služeb
  2
  url/zprostredkovani-zamestnancu-v-oborech
  titleZprostředkování zaměstnanců v oborech
  children
  0
  url/automobilovy-prumysl
  titleAutomobilový průmysl
  1
  url/operatori-vyrobnich-linek
  titleOperátoři výrobních linek
  2
  url/strojirenstvi-kovovyroba-a-hutnictvi
  titleStrojírenství, kovovýroba a hutnictví
  3
  url/doprava-a-logistika
  titleDoprava a logistika
  4
  url/elektronicky-a-elektrotechnicky-prumysl
  titleElektronický a elektrotechnický průmysl
  5
  url/potravinarsky-prumysl
  titlePotravinářský průmysl
  3
  url/pro-zamestnance
  titlePro zaměstnance
  top-menu-deu
  0
  url/unsere-gesellschaft
  titleUNSERE GESELLSCHAFT
  1
  url/warum-sollten-sie-unsere-dienste
  titleWARUM UNSERE DIENSTE
  2
  url/fur-firmen
  titleFÜR FIRMEN
  3
  url/kontakte
  titleKONTAKTE
  home-menu-deu
  0
  url/jobvermittlung
  titleJobangebot
  1
  url/genehmigung-vom-mas
  titleGenehmigung vom MAS
  2
  url/ftp/konkursversicherung.pdf
  titleKonkursversicherung
  hlavni-menu3-cze
  0
  url/volna-pracovni-mista
  titleVolná pracovní místa
  1
  url/volna-pracovni-mista-v-zahranici
  titleVolná pracovní místa - Německo
  hlavni-menu4-cze
  0
  url/pro-firmy
  titlePro firmy
  1
  url/reference
  titleReference
  2
  url/sponzoring
  titleSponzoring
  3
  url/kontakty
  titleKontakty
  hlavni-menu2-deu
  0
  url/warum-sollten-sie-unsere-dienste
  titleWarum unsere Dienste
  1
  url/dienstleistungsangebot
  titleDienstleistungsangebot
  2
  url/industriebranchen
  titleIndustriebranchen
  children
  0
  url/automobilindustrie
  titleAutomobilindustrie
  1
  url/fertigungslinienmitarbeiter-und-hilfsarbeiten
  titleFertigungslinienmitarbeiter und Hilfsarbeiten
  2
  url/maschinenbau-metallwirtschaft-und-metallurgie
  titleMaschinenbau, Metallwirtschaft, Metallurgie
  3
  url/elektronik-und-elektrotechnische-industrie
  titleElektronik- und elektrotechnische Industrie
  4
  url/transport-und-logistik
  titleTransport und Logistik
  5
  url/lebensmittelindustrie
  titleLebensmittelindustrie
  3
  url/fur-arbeitnehmer
  titleFür Arbeitnehmer
  hlavni-menu3-deu
  0
  url/jobvermittlung
  titleJobvermittlung
  hlavni-menu4-deu
  0
  url/fur-firmen
  titleFür Firmen
  1
  url/referenzen
  titleReferenzen
  2
  url/sponsoring
  titleSponsoring
  3
  url/kontakte
  titleKontakte
  top-menu-eng
  0
  url/about-us
  titleAbout us
  1
  url/why-use-our-services
  titleWhy use our services
  2
  url/for-companies
  titleFor companies
  3
  url/contact-us
  titleContact us
  home-menu-eng
  0
  url/permission-from-mlsa
  titlePermission from MLSA
  1
  urlhttp://www.jobnvj.eu/ftp/konkursversicherung.pdf
  titleInsurance against bankruptcy
  hlavni-menu-eng
  0
  url/
  titleHome
  1
  url/our-company
  titleOur company
  hlavni-menu2-eng
  0
  url/why-use-our-services
  titleWhy use our services
  1
  url/our-services
  titleOur services
  2
  url/recruiting-workers
  titleRecruiting workers
  children
  0
  url/automotive-industry
  titleAutomotive industry
  1
  url/production-line-operators
  titleProduction line operators
  2
  url/engineerin-metal-production-and-metallurgy
  titleEngineering, metal production and metallurgy
  3
  url/transport-and-logistic
  titleTransport and logistic
  4
  url/electronic-and-electrical-industry
  titleElectronic and electrical industry
  5
  url/food-industry
  titleFood industry
  3
  url/for-employees
  titleFor employees
  hlavni-menu3-eng
  0
  url/job-vacancies
  titleJob vacancies
  1
  url/job-vacancies-in-germany
  titleJob vacancies in Germany
  hlavni-menu4-eng
  0
  url/for-companies
  titleFor companies
  1
  url/references
  titleReferences
  2
  url/sponsorship-charity-and-humanitarion-work
  titleSponsorship and humanitarion work
  3
  url/contact-us
  titleContact us
- $request->data(empty)
- $this->validationErrors
  Content(empty)
  Menu(empty)
  MenuItem(empty)
  Parent(empty)
  Children(empty)
  Rule(empty)
  Group(empty)
- Loaded Helpers
  0MenuBuilder
  1Html
  2Form
  3Time
  4Session
  5ImageLink
  6Slimbox
  7Fck
  8Js
  9Ajax
  10DatePicker
  11Authake
  12Image
  13Paginator
  14Toolbar
  15Number
  16SimpleGraph
  17HtmlToolbar
====
Include
+
Included Files

Include Paths
- 0/srv/http/adent.cz/jobnvj.cz/lib
- 2/usr/share/php
- 3/usr/share/pear
- 4-> /srv/http/adent.cz/lib/cakephp/cakephp-2.1/lib/Cake/
Included Files
- core
  Behavior
  0CORE/Model/BehaviorCollection.php
  1CORE/Model/Behavior/TreeBehavior.php
  2CORE/Model/ModelBehavior.php
  Cache
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component
  0CORE/Controller/ComponentCollection.php
  1CORE/Controller/Component/RequestHandlerComponent.php
  2CORE/Controller/Component.php
  3CORE/Controller/Component/SessionComponent.php
  Config
  0CORE/Core/Configure.php
  1CORE/Config/routes.php
  Controller
  0CORE/Controller/Controller.php
  Datasource
  0CORE/Model/Datasource/Database/Mysql.php
  1CORE/Model/Datasource/DboSource.php
  2CORE/Model/Datasource/DataSource.php
  3CORE/Model/Datasource/CakeSession.php
  Error
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log
  0CORE/Log/CakeLog.php
  1CORE/Log/Engine/FileLog.php
  2CORE/Log/CakeLogInterface.php
  Model
  0CORE/Model/Model.php
  1CORE/Model/ConnectionManager.php
  Network
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Object.php
  4CORE/Event/CakeEventListener.php
  5CORE/Event/CakeEvent.php
  6CORE/Event/CakeEventManager.php
  Plugin
  0CORE/Core/CakePlugin.php
  1CORE/Routing/Route/PluginShortRoute.php
  Routing
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Router.php
  2CORE/Routing/Route/RedirectRoute.php
  3CORE/Routing/Route/CakeRoute.php
  Utility
  0CORE/Utility/Inflector.php
  1CORE/Utility/ClassRegistry.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Set.php
  View
  0CORE/View/View.php
  1CORE/View/HelperCollection.php
- app
  Config
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller
  0APP/Controller/PagesController.php
  1APP/Controller/AppController.php
  Model
  0APP/Model/AppModel.php
  Other
  0APP/webroot/index.php
- plugins
  Authake
  Component
  0Authake/Controller/Component/AuthakeComponent.php
  Model
  0Authake/Model/Rule.php
  1Authake/Model/AuthakeAppModel.php
  2Authake/Model/Group.php
  ContentManager
  Plugin
  0ContentManager/Lib/ContentRoute.php
  Model
  0ContentManager/Model/Content.php
  1ContentManager/Model/ContentManagerAppModel.php
  MenuBuilder
  Model
  0MenuBuilder/Model/Menu.php
  1MenuBuilder/Model/MenuBuilderAppModel.php
  2MenuBuilder/Model/MenuItem.php
====

Volná pracovní místa v zahraničí

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 9 ms Total Queries: 119 queries

Query Explain:

authake

Total Time: 0 ms Total Queries: 5 queries

Query Explain:

Memory

Timers

Logs

View Variables

Included Files

Include Paths

Included Files

Total Time: 9 ms
Total Queries: 119 queries

Total Time: 0 ms
Total Queries: 5 queries