| Queries | Time | Rows |
| SELECT `core_route_controller`
FROM (`core_route`)
WHERE `core_route_alias` = 'tag' | 0.000 | 0 |
| SELECT `core_route_controller`
FROM (`core_route`)
WHERE `core_route_alias` = 'gerakas-zakynthos' | 0.000 | 0 |
| SELECT `core_route_controller`
FROM (`core_route`)
WHERE `core_route_alias` = '35' | 0.000 | 0 |
|
SELECT
sum(IFNULL(length(`core_route_alias`),0))+
sum(IFNULL(length(`core_route_controller`),0))
FROM `core_route`
WHERE `core_route_controller` <> "/" | 0.000 | 1 |
| SELECT `core_route_alias`, `core_route_controller`
FROM (`core_route`)
WHERE `core_route_controller` <> '/'
AND `core_route_archive` = 0
ORDER BY `core_route_controller` DESC | 0.001 | 78 |
|
SELECT
`core_lang_id`
,`core_lang_name`
,`core_lang_locale`
FROM `core_lang`
WHERE
`core_lang_locale` = 'pl_PL' | 0.000 | 1 |
|
SELECT MAX(`base_visit_user_id`)+1 visit_user_id
FROM `base_visit_details`
| 0.000 | 1 |
| INSERT INTO `base_visit_details` (
`base_visit_user_id`
,`base_visit_details_search_engine`
,`base_visit_details_os`
,`base_visit_details_browser`
,`base_visit_details_keys`
,`base_visit_details_bot`
,`base_visit_details_referer`
,`base_visit_details_ip`
,`base_visit_details_ip_hostname`
,`base_visit_details_ip_proxy`
,`base_visit_details_ip_proxyhost`
,`base_visit_details_time`
)
VALUES('1614439', NULL, NULL, 'Mozilla 5.0', NULL, NULL, 0, '3.128.94.171', 0, 0, 0, '2024-04-19T23:44:50+02:00')
| 0.000 | 1 |
|
SELECT COUNT(*) count
FROM `base_visit`
LEFT JOIN `base_visit_details` USING(`base_visit_user_id`)
WHERE DATE_FORMAT(NOW(), '%Y-%m-%d') = DATE_FORMAT(`base_visit_time`, '%Y-%m-%d') AND `base_visit_user_id` = '1614439' | 0.000 | 1 |
|
UPDATE `base_visit_day`
SET `base_visit_day_visits` = `base_visit_day_visits` + 1
WHERE `base_visit_day_date` = CURDATE()
AND `base_visit_day_hour` = '23' | 0.000 | 1 |
|
UPDATE `base_visit_day`
SET `base_visit_day_views` = `base_visit_day_views` + 1
WHERE `base_visit_day_date` = CURDATE()
AND `base_visit_day_hour` = '23' | 0.000 | 1 |
|
SELECT *
FROM `base_setting`
WHERE
`core_system_type_id` = 0 | 0.000 | 38 |
|
SELECT *
FROM `base_banner`
WHERE `core_lang_id` = '1'
AND
(
(`base_banner_date_start` IS NOT NULL AND `base_banner_date_start` <= NOW())
OR `base_banner_date_start` IS NULL
)
AND
(
(`base_banner_date_stop` IS NOT NULL AND `base_banner_date_stop` >= NOW())
OR `base_banner_date_stop` IS NULL
)
AND
(
(`base_banner_count_limit` = 1 AND `base_banner_count_limit_value` >0)
OR `base_banner_count_limit` = 0
)
AND `core_system_type_id` IS NULL
ORDER BY `base_banner_position` | 0.000 | 8 |
|
SELECT
*, `base_foto`.`base_foto_id`
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
LEFT JOIN (`base_foto_lang`) ON(
`base_foto`.`base_foto_id` = `base_foto_lang`.`base_foto_id`
AND `base_foto_lang`.`core_lang_id` = '1'
)
WHERE (`base_res_target_table_name` = 'base_banner'
AND `base_target_id` = 14) OR (`base_res_target_table_name` = 'base_banner'
AND `base_target_id` = 13) OR (`base_res_target_table_name` = 'base_banner'
AND `base_target_id` = 10) OR (`base_res_target_table_name` = 'base_banner'
AND `base_target_id` = 15) OR (`base_res_target_table_name` = 'base_banner'
AND `base_target_id` = 22) OR (`base_res_target_table_name` = 'base_banner'
AND `base_target_id` = 23) OR (`base_res_target_table_name` = 'base_banner'
AND `base_target_id` = 11) OR (`base_res_target_table_name` = 'base_banner'
AND `base_target_id` = 12)
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position`
| 0.001 | 8 |
|
SELECT *
FROM `base_banner_category`
WHERE `base_banner_category_id` = '2'
| 0.000 | 1 |
|
SELECT *
FROM `base_banner_category`
WHERE `base_banner_category_id` = '1'
| 0.000 | 1 |
| SELECT *
FROM (`base_box`)
WHERE `core_lang_id` = '1'
AND core_system_type_id IS NULL
ORDER BY `base_box_position` ASC | 0.000 | 7 |
|
SELECT
*, `base_foto`.`base_foto_id`
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
LEFT JOIN (`base_foto_lang`) ON(
`base_foto`.`base_foto_id` = `base_foto_lang`.`base_foto_id`
AND `base_foto_lang`.`core_lang_id` = '1'
)
WHERE (`base_res_target_table_name` = 'base_box'
AND `base_target_id` = 18) OR (`base_res_target_table_name` = 'base_box'
AND `base_target_id` = 51) OR (`base_res_target_table_name` = 'base_box'
AND `base_target_id` = 33) OR (`base_res_target_table_name` = 'base_box'
AND `base_target_id` = 27) OR (`base_res_target_table_name` = 'base_box'
AND `base_target_id` = 26) OR (`base_res_target_table_name` = 'base_box'
AND `base_target_id` = 23) OR (`base_res_target_table_name` = 'base_box'
AND `base_target_id` = 50)
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position`
| 0.001 | 0 |
| SELECT *
FROM (`base_sounder`)
WHERE `base_sounder_id` = '1'
AND `base_sounder_visible` = 1
AND `core_lang_id` = '1' | 0.000 | 1 |
| SELECT *
FROM (`base_sounder_vote`)
WHERE `base_sounder_id` = '1'
AND `base_visit_user_id` = '1614439' | 0.000 | 0 |
| SELECT *
FROM (`base_sounder_answer`)
WHERE `base_sounder_id` = '1' | 0.000 | 6 |
|
SELECT SUM(`base_visit_day_visits`) count
FROM `base_visit_day`
WHERE
`base_visit_day_date` >= '2024-04-01 00:00:00'
AND `base_visit_day_date` <= '2024-04-19 23:44:50' | 0.001 | 1 |
|
SELECT SUM(`base_visit_day_visits`) count
FROM `base_visit_day` | 0.017 | 1 |
|
SELECT COUNT(*) count
FROM `base_visit`
LEFT JOIN `base_visit_details` USING (`base_visit_user_id`)
WHERE `base_visit_time` >= '2024-04-19 23:29:50'
AND `base_visit_time` <= '2024-04-19 23:44:50'
AND `base_visit_details_bot` IS NULL
GROUP BY `base_visit_user_id` | 0.000 | 2 |
|
SELECT SUM(`base_visit_day_visits`) count
FROM `base_visit_day`
WHERE
`base_visit_day_date` >= '2024-04-19 00:00:00'
AND `base_visit_day_date` <= '2024-04-19 23:44:50' | 0.000 | 1 |
| SELECT *
FROM (`base_menu`)
WHERE `core_lang_id` = '1'
AND `base_menu_name` = 'ROOT' | 0.000 | 1 |
|
SELECT node.base_menu_id, node.base_menu_id, node.base_menu_name, node.base_menu_type, node.base_menu_out_link, node.base_menu_category, node.base_menu_page_desc_id, node.base_menu_show_counter, node.base_menu_show_only_logged, node.base_menu_disabled,
node.base_menu_id,
(COUNT(parent.base_menu_id) - 2) AS depth,
CONCAT( REPEAT('--- ', COUNT(parent.base_menu_id) - 2), node.base_menu_name, ' (id:', node.base_menu_id, ')') AS base_menu_name_
FROM base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left AND parent.base_menu_right
AND parent.`core_lang_id` = '1'
AND node.`core_lang_id` = '1'
AND node.base_menu_id <> '1'
GROUP BY node.base_menu_id
ORDER BY node.base_menu_left; | 0.001 | 25 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '36'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '36'
ORDER BY parent.base_menu_left;
| 0.000 | 2 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '36'
AND `core_route_archive` = 0 | 0.000 | 0 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '36'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '133'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '133'
ORDER BY parent.base_menu_left;
| 0.000 | 2 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '133'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '133'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '134'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '134'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '134'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '134'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '135'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '135'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '135'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '135'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '136'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '136'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '136'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '136'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '137'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '137'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '137'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '137'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '138'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '138'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '138'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '138'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '139'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '139'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '139'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '139'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '140'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '140'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '140'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '140'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '150'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '150'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '150'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '150'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '142'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '142'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '142'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '142'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '143'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '143'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '143'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '143'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '154'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '154'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '154'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '154'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '144'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '144'
ORDER BY parent.base_menu_left;
| 0.000 | 2 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '144'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '144'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '145'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '145'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '145'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '145'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '146'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '146'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '146'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '146'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '147'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '147'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '147'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '147'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '148'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '148'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '148'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '148'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '149'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '149'
ORDER BY parent.base_menu_left;
| 0.000 | 3 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '149'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '149'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '131'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '131'
ORDER BY parent.base_menu_left;
| 0.000 | 2 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '131'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '131'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '132'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '132'
ORDER BY parent.base_menu_left;
| 0.000 | 2 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '132'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '132'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '141'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '141'
ORDER BY parent.base_menu_left;
| 0.000 | 2 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '141'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '141'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '151'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '151'
ORDER BY parent.base_menu_left;
| 0.000 | 2 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '151'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '151'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '152'
AND `core_lang_id` = '1' | 0.000 | 13 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '152'
ORDER BY parent.base_menu_left;
| 0.000 | 2 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '152'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '152'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE `base_menu`.`base_menu_id` = '153'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT parent.base_menu_id, parent.base_menu_id, parent.base_menu_name
FROM
base_menu AS node,
base_menu AS parent
WHERE node.base_menu_left BETWEEN parent.base_menu_left
AND parent.base_menu_right
AND node.`core_lang_id` = '1'
AND parent.`core_lang_id` = '1'
AND node.base_menu_id = '153'
ORDER BY parent.base_menu_left;
| 0.000 | 2 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_menu'
AND `core_route_item_id` = '153'
AND `core_route_archive` = 0 | 0.000 | 1 |
|
SELECT
max(pl) parent_l,
nl node_l,
nr node_r,
pr parent_r,
pi parent_id
FROM (
SELECT
node.`base_menu_left` AS nl,
node.`base_menu_right` AS nr,
parent.`base_menu_left` AS pl,
parent.`base_menu_right` AS pr,
parent.`base_menu_id` AS pi,
parent.`core_lang_id`,
parent.`core_system_type_id`
FROM
`base_menu` node,
`base_menu` parent
WHERE
node.`base_menu_id` != parent.`base_menu_id`
AND node.`base_menu_id` = '153'
AND parent.`base_menu_id` != '1'
AND parent.`core_lang_id` = '1'
ORDER BY pl DESC
) B WHERE nl > pl AND nr < pr;
| 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE base_menu.base_menu_id IS NULL
AND `core_lang_id` = '1' | 0.000 | 0 |
|
SELECT
`base_link`.*
,`base_content`.`base_content_name`
FROM `base_link`
LEFT JOIN `base_content` USING (`base_content_id`)
WHERE TRUE
AND `base_link`.`core_lang_id` = '1'
ORDER BY
`base_link_position` ASC;
| 0.001 | 13 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '13'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '20'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT *
FROM (`base_menu`)
WHERE `base_menu_id` = '148' | 0.000 | 1 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '26'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '27'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '28'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '14'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '48'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '16'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '22'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT *
FROM (`base_menu`)
WHERE `base_menu_id` = '152' | 0.000 | 1 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '17'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '23'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT *
FROM (`base_menu`)
WHERE `base_menu_id` = '36' | 0.000 | 1 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '49'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT `core_route_alias`
FROM (`core_route`)
WHERE `core_route_table_name` = 'base_link'
AND `core_route_item_id` = '18'
AND `core_route_archive` = 0 | 0.000 | 0 |
| SELECT `base_tag_name`
FROM (`base_tag`)
WHERE `base_tag_id` = '35' | 0.000 | 1 |
|
SELECT COUNT(*) count
FROM `base_content`
LEFT JOIN `base_res_conn` ON(
`base_content_id` = `base_target_id`
AND `base_res_target_table_name` = 'base_content'
AND `base_res_type` = 'tag'
)
WHERE `core_lang_id` = '1'
AND `base_content_visible` = 1
AND `base_content_removed` <> 1
AND `base_res_id` = '35'
| 0.001 | 1 |
|
SELECT COUNT(*) count
FROM `base_news`
LEFT JOIN `base_res_conn` ON(
`base_news_id` = `base_target_id`
AND `base_res_target_table_name` = 'base_news'
AND `base_res_type` = 'tag'
)
WHERE `core_lang_id` = '1'
AND `base_news_visible` = '1'
AND `base_news_publish_date` < NOW()
AND (`base_news_always_visible` = '1' OR `base_news_unpublish_date` > NOW())
AND `base_res_id` = '35'
| 0.001 | 1 |
|
SELECT
`base_content_id` id
,`base_content_name` name
,`base_content_desc` 'desc'
,`base_content_short_desc` short_desc
,`base_content_show_desc_foto` show_desc_foto
,`base_content_desc_foto_type` desc_foto_type
,'content' as 'type'
FROM `base_content`
LEFT JOIN `base_res_conn` ON(
`base_content_id` = `base_target_id`
AND `base_res_target_table_name` = 'base_content'
AND `base_res_type` = 'tag'
)
WHERE `core_lang_id` = '1'
AND `base_content_visible` = 1
AND `base_content_removed` <> 1
AND `base_res_id` = '35'
UNION
SELECT
`base_news_id` id
,`base_news_name` name
,`base_news_desc` 'desc'
,`base_news_short_desc` short_desc
,`base_news_show_desc_foto` show_desc_foto
,`base_news_desc_foto_type` desc_foto_type
,'news' as 'type'
FROM `base_news`
LEFT JOIN `base_res_conn` ON(
`base_news_id` = `base_target_id`
AND `base_res_target_table_name` = 'base_news'
AND `base_res_type` = 'tag'
)
WHERE `core_lang_id` = '1'
AND `base_news_visible` = '1'
AND `base_news_publish_date` < NOW()
AND (`base_news_always_visible` = '1' OR `base_news_unpublish_date` > NOW())
AND `base_res_id` = '35'
AND `base_news_more` = 'desc'
LIMIT 10 OFFSET 0 | 0.002 | 1 |
|
SELECT
*, `base_foto`.`base_foto_id`
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
LEFT JOIN (`base_foto_lang`) ON(
`base_foto`.`base_foto_id` = `base_foto_lang`.`base_foto_id`
AND `base_foto_lang`.`core_lang_id` = '1'
)
WHERE (`base_res_target_table_name` = 'base_content'
AND `base_target_id` = 23)
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position`
| 0.001 | 10 |
|
SELECT
*, `base_foto`.`base_foto_id`
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
LEFT JOIN (`base_foto_lang`) ON(
`base_foto`.`base_foto_id` = `base_foto_lang`.`base_foto_id`
AND `base_foto_lang`.`core_lang_id` = '1'
)
WHERE (`base_res_target_table_name` = 'base_news'
AND `base_target_id` = 23)
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position`
| 0.001 | 1 |
| Total: 151 | 0.063 | 369 |
