No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Content`.`slug` FROM `jobnvj`.`contents` AS `Content` WHERE 1 = 1 | 67 | 67 | 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 | 1 | |
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` = 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 | 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` = 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 | 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 |
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 |
Total Request Time: 434 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 47.92 | |
Component initialization and startup | 45.34 | |
Controller action | 0.29 | |
Render Controller Action | 179.62 | |
» Rendering View | 178.54 | |
» » Rendering APP/View/Pages/volna-pracovni-mista-v-zahranici.ctp | 157.11 | |
» » » Rendering APP/View/Elements/content_manager_volna_pracovni_mista.ctp | 156.62 | |
» » » » Component initialization and startup #2 | 16.89 | |
Controller action #2 | 0.00 | |
» » » » » Component initialization and startup #3 | 16.30 | |
Controller action #3 | 0.00 | |
» » » » » » Component initialization and startup #4 | 15.67 | |
Controller action #4 | 0.00 | |
» » » » » » » Component initialization and startup #5 | 15.48 | |
Controller action #5 | 0.00 | |
» » » » » » Rendering APP/View/Layouts/default.ctp | 2.18 |