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 | 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`.`slug` = 'pro-firmy' LIMIT 1 | 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` = 12 | 1 | 1 | 1 | |
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` = (95) | 0 | 0 | 0 | |