Query | Affected | Num. rows | Took (ms) | Actions |
---|
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 | |