-
- History
-
Session +
Session
- Config
- userAgent56e44b44ee4eb3b7167bb1faff3442bd
- time2206719548
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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
- 0
- 3
- id98
- titlePro zaměstnance
- url/pro-zamestnance
- parent_id(null)
- menu_id28
- lft19
- rght20
- Parent(empty)
- Children(empty)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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
- 0
- 3
- id122
- titleFür Arbeitnehmer
- url/fur-arbeitnehmer
- parent_id(null)
- menu_id33
- lft19
- rght20
- Parent(empty)
- Children(empty)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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
- 0
- 3
- id153
- titleFor employees
- url/for-employees
- parent_id(null)
- menu_id39
- lft19
- rght20
- Parent(empty)
- Children(empty)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 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)
- 0
- children(empty)
- Menu
- 0
- menu
- 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)
- Rule
- 1
- Rule
- id8
- nameZákaz administrace
- group_id(null)
- order0
- action\/admin\/.*
- permission
- forward
- message
- Group
- id(null)
- name(null)
- Rule
- 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)
- Rule
- 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)
- Rule
- 4
- Rule
- id7
- nameMenu builder allowed for everyone
- group_id(null)
- order705
- action\/menu_builder\/.*
- permissionDeny
- forward
- message
- Group
- id(null)
- name(null)
- Rule
- 0
- cacheRulesTime1606719609
==== - Config
-
Request +
Request
Cake Params
- plugin(null)
- controllerpages
- actiondisplay
- pagevolna-pracovni-mista
- named(empty)
- pass
- 0volna-pracovni-mista
- 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
- pass
- 0page
- defaults
- controllerpages
- actiondisplay
- plugin(null)
- template/:page
==== -
Sql Log +
Sql Logs
default
Total Time: 11 ms
Total Queries: 143 queriesQuery Affected Num. rows Took (ms) Actions SELECT `Content`.`slug` FROM `jobnvj`.`contents` AS `Content` WHERE 1 = 1 67 67 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 `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` = 17 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` = 17 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` = 18 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` = 18 1 1 1 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` = 19 ORDER BY `Content`.`date_from` asc LIMIT 10 1 1 1 SELECT `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` FROM `jobnvj`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 19 1 1 0 SELECT `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`.`m002gallery` AS `Gallery` WHERE `Gallery`.`id` = 0 0 0 0 SELECT `Children`.`id`, `Children`.`slug`, `Children`.`parent_id`, `Children`.`keywords`, `Children`.`description`, `Children`.`title`, `Children`.`body`, `Children`.`created`, `Children`.`updated`, `Children`.`content_type_id`, `Children`.`www`, `Children`.`email`, `Children`.`perex`, `Children`.`varchar_1`, `Children`.`varchar_2`, `Children`.`varchar_3`, `Children`.`text_1`, `Children`.`text_2`, `Children`.`text_3`, `Children`.`date_1`, `Children`.`date_2`, `Children`.`date_3`, `Children`.`datetime_1`, `Children`.`datetime_2`, `Children`.`datetime_3`, `Children`.`checkbox_1`, `Children`.`checkbox_2`, `Children`.`checkbox_3`, `Children`.`top`, `Children`.`active`, `Children`.`attach_1`, `Children`.`attach_1_title`, `Children`.`attach_2`, `Children`.`attach_2_title`, `Children`.`attach_3`, `Children`.`attach_3_title`, `Children`.`image_1`, `Children`.`image_1_title`, `Children`.`image_2`, `Children`.`image_2_title`, `Children`.`image_3`, `Children`.`image_3_title`, `Children`.`date_from`, `Children`.`date_to`, `Children`.`m002gallery_id`, `Children`.`parent_content_id`, `Children`.`number_1`, `Children`.`number_2`, `Children`.`number_3` FROM `jobnvj`.`contents` AS `Children` WHERE `Children`.`parent_content_id` = (128) 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` = 19 1 1 1 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` = 20 ORDER BY `Content`.`date_from` asc LIMIT 10 10 10 2 maybe slow SELECT `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` FROM `jobnvj`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 20 1 1 1 SELECT `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` FROM `jobnvj`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 20 1 1 0 SELECT `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` FROM `jobnvj`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 20 1 1 0 SELECT `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` FROM `jobnvj`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 20 1 1 0 SELECT `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` FROM `jobnvj`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 20 1 1 0 SELECT `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` FROM `jobnvj`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 20 1 1 0 SELECT `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` FROM `jobnvj`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 20 1 1 0 SELECT `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` FROM `jobnvj`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 20 1 1 0 SELECT `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` FROM `jobnvj`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 20 1 1 0 SELECT `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` FROM `jobnvj`.`content_types` AS `ContentType` WHERE `ContentType`.`id` = 20 1 1 0 SELECT `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`.`m002gallery` AS `Gallery` WHERE `Gallery`.`id` = 0 0 0 0 SELECT `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`.`m002gallery` AS `Gallery` WHERE `Gallery`.`id` = 0 0 0 0 SELECT `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`.`m002gallery` AS `Gallery` WHERE `Gallery`.`id` = 0 0 0 0 SELECT `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`.`m002gallery` AS `Gallery` WHERE `Gallery`.`id` = 0 0 0 0 SELECT `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`.`m002gallery` AS `Gallery` WHERE `Gallery`.`id` = 0 0 0 0 SELECT `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`.`m002gallery` AS `Gallery` WHERE `Gallery`.`id` = 0 0 0 0 SELECT `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`.`m002gallery` AS `Gallery` WHERE `Gallery`.`id` = 0 0 0 0 SELECT `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`.`m002gallery` AS `Gallery` WHERE `Gallery`.`id` = 0 0 0 0 SELECT `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`.`m002gallery` AS `Gallery` WHERE `Gallery`.`id` = 0 0 0 0 SELECT `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`.`m002gallery` AS `Gallery` WHERE `Gallery`.`id` = 0 0 0 0 SELECT `Children`.`id`, `Children`.`slug`, `Children`.`parent_id`, `Children`.`keywords`, `Children`.`description`, `Children`.`title`, `Children`.`body`, `Children`.`created`, `Children`.`updated`, `Children`.`content_type_id`, `Children`.`www`, `Children`.`email`, `Children`.`perex`, `Children`.`varchar_1`, `Children`.`varchar_2`, `Children`.`varchar_3`, `Children`.`text_1`, `Children`.`text_2`, `Children`.`text_3`, `Children`.`date_1`, `Children`.`date_2`, `Children`.`date_3`, `Children`.`datetime_1`, `Children`.`datetime_2`, `Children`.`datetime_3`, `Children`.`checkbox_1`, `Children`.`checkbox_2`, `Children`.`checkbox_3`, `Children`.`top`, `Children`.`active`, `Children`.`attach_1`, `Children`.`attach_1_title`, `Children`.`attach_2`, `Children`.`attach_2_title`, `Children`.`attach_3`, `Children`.`attach_3_title`, `Children`.`image_1`, `Children`.`image_1_title`, `Children`.`image_2`, `Children`.`image_2_title`, `Children`.`image_3`, `Children`.`image_3_title`, `Children`.`date_from`, `Children`.`date_to`, `Children`.`m002gallery_id`, `Children`.`parent_content_id`, `Children`.`number_1`, `Children`.`number_2`, `Children`.`number_3` FROM `jobnvj`.`contents` AS `Children` WHERE `Children`.`parent_content_id` IN (122, 135, 123, 124, 125, 126, 127, 136, 137, 138) 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` = 20 1 1 1 Query Explain:
authake
Total Time: 0 ms
Total Queries: 5 queriesQuery Affected Num. rows Took (ms) Actions 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 0 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 0 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 0 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 0 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 0 Query Explain:
==== -
Timer +
Memory
Peak Memory Use 9.27 MB
Message Memory use Component initialization 1.97 MB Controller action start 3.02 MB Controller render start 3.07 MB Component initialization #2 4.48 MB Controller action start #2 4.86 MB Component initialization #3 5.36 MB Controller action start #3 5.50 MB Component initialization #4 5.53 MB Controller action start #4 5.68 MB Component initialization #5 5.73 MB Controller action start #5 5.88 MB View render complete 6.08 MB Timers
Total Request Time: 1201 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 805.11 Component initialization and startup 83.68 Controller action 0.23 Render Controller Action 180.44 » Rendering View 179.40 » » Rendering APP/View/Pages/volna-pracovni-mista.ctp 167.82 » » » Rendering APP/View/Elements/content_manager_volna_pracovni_mista.ctp 167.29 » » » » Component initialization and startup #2 16.61 Controller action #2 0.00 » » » » » Component initialization and startup #3 16.27 Controller action #3 0.00 » » » » » » Component initialization and startup #4 17.03 Controller action #4 0.00 » » » » » » » Component initialization and startup #5 16.62 Controller action #5 0.00 » » » » » » Rendering APP/View/Layouts/default.ctp 2.18 ==== - Log
-
Variables +
View Variables
- pagevolna-pracovni-mista
- subpage(null)
- title_for_layoutVolna-pracovni-mista
- 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
- 0
- 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
- 0
- hlavni-menu-deu
- 0
- url/
- titleHome
- 1
- url/unsere-gesellschaft
- titleUnsere Gesellschaft
- 0
- 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
- 0
- hlavni-menu-cze
- 0
- url/
- titleÚvodní stránka
- 1
- url/predstaveni-spolecnosti
- titlePředstavení společnosti
- 0
- 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
- 0
- 3
- url/pro-zamestnance
- titlePro zaměstnance
- 0
- 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
- 0
- home-menu-deu
- 0
- url/jobvermittlung
- titleJobangebot
- 1
- url/genehmigung-vom-mas
- titleGenehmigung vom MAS
- 2
- url/ftp/konkursversicherung.pdf
- titleKonkursversicherung
- 0
- 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
- 0
- hlavni-menu4-cze
- 0
- url/pro-firmy
- titlePro firmy
- 1
- url/reference
- titleReference
- 2
- url/sponzoring
- titleSponzoring
- 3
- url/kontakty
- titleKontakty
- 0
- 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
- 0
- 3
- url/fur-arbeitnehmer
- titleFür Arbeitnehmer
- 0
- hlavni-menu3-deu
- 0
- url/jobvermittlung
- titleJobvermittlung
- 0
- hlavni-menu4-deu
- 0
- url/fur-firmen
- titleFür Firmen
- 1
- url/referenzen
- titleReferenzen
- 2
- url/sponsoring
- titleSponsoring
- 3
- url/kontakte
- titleKontakte
- 0
- 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
- 0
- home-menu-eng
- 0
- url/permission-from-mlsa
- titlePermission from MLSA
- 1
- urlhttp://www.jobnvj.eu/ftp/konkursversicherung.pdf
- titleInsurance against bankruptcy
- 0
- hlavni-menu-eng
- 0
- url/
- titleHome
- 1
- url/our-company
- titleOur company
- 0
- 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
- 0
- 3
- url/for-employees
- titleFor employees
- 0
- hlavni-menu3-eng
- 0
- url/job-vacancies
- titleJob vacancies
- 1
- url/job-vacancies-in-germany
- titleJob vacancies in Germany
- 0
- 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
- 0
- admin-menu
- $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
- Behavior
- 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
- Config
- plugins
- Authake
- Component
- 0Authake/Controller/Component/AuthakeComponent.php
- Model
- 0Authake/Model/Rule.php
- 1Authake/Model/AuthakeAppModel.php
- 2Authake/Model/Group.php
- Component
- ContentManager
- Plugin
- 0ContentManager/Lib/ContentRoute.php
- Model
- 0ContentManager/Model/Content.php
- 1ContentManager/Model/ContentManagerAppModel.php
- Plugin
- MenuBuilder
- Model
- 0MenuBuilder/Model/Menu.php
- 1MenuBuilder/Model/MenuBuilderAppModel.php
- 2MenuBuilder/Model/MenuItem.php
- Model
- Authake
====