| Queries | Time | Rows |
| SELECT `core_route_controller`
FROM (`core_route`)
WHERE `core_route_alias` = 'porto-vromi-zakynthos' | 0.000 | 1 |
|
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.001 | 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('1446443', NULL, NULL, ' ', NULL, NULL, 0, '3.238.118.27', 0, 0, 0, '2023-06-07T23:58:18+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` = '1446443' | 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.002 | 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` = '1446443' | 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` >= '2023-06-01 00:00:00'
AND `base_visit_day_date` <= '2023-06-07 23:58:18' | 0.001 | 1 |
|
SELECT SUM(`base_visit_day_visits`) count
FROM `base_visit_day` | 0.016 | 1 |
|
SELECT COUNT(*) count
FROM `base_visit`
LEFT JOIN `base_visit_details` USING (`base_visit_user_id`)
WHERE `base_visit_time` >= '2023-06-07 23:43:18'
AND `base_visit_time` <= '2023-06-07 23:58:18'
AND `base_visit_details_bot` IS NULL
GROUP BY `base_visit_user_id` | 0.000 | 3 |
|
SELECT SUM(`base_visit_day_visits`) count
FROM `base_visit_day`
WHERE
`base_visit_day_date` >= '2023-06-07 00:00:00'
AND `base_visit_day_date` <= '2023-06-07 23:58:18' | 0.000 | 1 |
| SELECT *
FROM (`base_menu`)
WHERE `core_lang_id` = '1'
AND `base_menu_name` = 'ROOT' | 0.000 | 1 |
|
SELECT
`base_menu_id`
FROM `base_menu_conn`
WHERE `base_menu_conn_item_id` = 30
AND `base_menu_conn_item_table_name` = 'base_content' | 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.001 | 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.001 | 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.001 | 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_show_counter`
FROM `base_menu`
WHERE `base_menu_id` = '142' | 0.000 | 1 |
|
UPDATE `base_menu`
SET `base_menu_show_counter` = 17561
WHERE `base_menu_id` = '142' | 0.000 | 1 |
|
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.000 | 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 *
FROM (`base_content`)
WHERE `base_content_id` = '30'
AND `base_content_visible` = 1
AND `base_content_removed` = 0
AND `core_lang_id` = '1' | 0.000 | 1 |
| SELECT `base_table_record_name` AS `record_name`, `base_table_record_value` AS `record_value`
FROM (`base_table_record`)
WHERE `base_table_record_target_id` = '30'
AND `base_table_record_target_table_name` = 'base_content'
ORDER BY `base_table_record_position` ASC | 0.000 | 0 |
|
SELECT
`base_res_id`
FROM `base_res_conn`
WHERE
`base_target_id` = 30
AND `base_res_type` = 'forms'
AND `base_res_target_table_name` = 'base_content'
| 0.000 | 1 |
|
SELECT
`base_foto`.`base_foto_id` id,
`base_foto_file_name` file_name,
`base_foto_file_name_org` file_name_org,
`base_foto_lang_desc` lang_desc,
`base_foto_author` author
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_target_id` = '30'
AND `base_res_target_table_name` = 'base_content'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 10 |
|
SELECT
`base_file_id` id,
`base_file_name` file_name,
`base_file_name_org` file_name_org,
`base_file_size` file_size,
`base_file_lang_desc` lang_desc
FROM `base_res_conn`
JOIN `base_file` ON(`base_res_id` = `base_file_id`)
LEFT JOIN (
SELECT
`base_file_id`,
`base_file_lang_desc`
FROM `base_file_lang`
WHERE `core_lang_id` = '1'
) file_desc USING(`base_file_id`)
WHERE `base_target_id` = '30'
AND `base_res_target_table_name` = 'base_content'
AND `base_res_type` = 'file'
AND `base_file_removed` = 0
ORDER BY `base_res_position` | 0.000 | 0 |
|
SELECT
`base_movie_id` id,
`base_movie_thumb_file_name` thumb_file_name,
`base_movie_file_name` file_name,
`base_movie_file_name_org` file_name_org,
`base_movie_lang_desc` lang_desc
FROM `base_res_conn`
JOIN `base_movie` ON(`base_res_id` = `base_movie_id`)
LEFT JOIN (
SELECT
`base_movie_id`,
`base_movie_lang_desc`
FROM `base_movie_lang`
WHERE `core_lang_id` = '1'
) movie_desc USING(`base_movie_id`)
WHERE `base_target_id` = '30'
AND `base_res_target_table_name` = 'base_content'
AND `base_res_type` = 'movie'
AND `base_movie_removed` = 0
ORDER BY `base_res_position` | 0.000 | 0 |
|
SELECT
`base_tag_id` id,
`base_tag_name` name
FROM `base_res_conn`
JOIN `base_tag` ON(`base_res_id` = `base_tag_id`)
WHERE `base_target_id` = '30'
AND `base_res_target_table_name` = 'base_content'
AND `base_res_type` = 'tag'
ORDER BY `base_res_position` | 0.000 | 6 |
|
UPDATE `base_content`
SET `base_content_show_count` = `base_content_show_count`+1
WHERE `base_content_id` = '30' | 0.000 | 1 |
| INSERT INTO `base_visit` (`base_visit_time`, `base_visit_user_id`, `base_member_id`, `base_visit_module`, `base_visit_action`, `base_visit_action_row_id`) VALUES ('2023-06-07T23:58:18+02:00', '1446443', NULL, 'content', 'show_details', '30') | 0.000 | 1 |
| Total: 154 | 0.054 | 379 |
