| Queries | Time | Rows |
| SELECT `core_route_controller`
FROM (`core_route`)
WHERE `core_route_alias` = 'hosting-zaplecze-techniczne' | 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.000 | 66 |
|
SELECT
`core_lang_id`
,`core_lang_name`
,`core_lang_locale`
FROM `core_lang`
WHERE
`core_lang_locale` = 'pl_PL' | 0.000 | 1 |
| SELECT *
FROM (`base_email_link`)
WHERE `base_email_link_id` = '' | 0.000 | 0 |
|
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 `core_system_type_id` IS NULL AND `base_visit_user_id` = '3877' | 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` = '00' AND `core_system_type_id` IS NULL | 0.000 | 1 |
|
SELECT *
FROM `base_setting`
WHERE
`core_system_type_id` = 0 | 0.000 | 27 |
|
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 | 7 |
|
SELECT *
FROM `base_banner_category`
WHERE `base_banner_category_id` = '3'
| 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
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` = '26'
AND `base_res_target_table_name` = 'base_banner'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 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
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` = '27'
AND `base_res_target_table_name` = 'base_banner'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 1 |
|
SELECT *
FROM `base_banner_category`
WHERE `base_banner_category_id` = '1'
| 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
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` = '24'
AND `base_res_target_table_name` = 'base_banner'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 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
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` = '28'
AND `base_res_target_table_name` = 'base_banner'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 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
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` = '29'
AND `base_res_target_table_name` = 'base_banner'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 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
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_banner'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 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
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` = '25'
AND `base_res_target_table_name` = 'base_banner'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 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 | 10 |
|
SELECT
`base_foto`.*
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
WHERE `base_target_id` = '50'
AND `base_res_target_table_name` = 'base_box'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 0 |
|
SELECT
`base_foto`.*
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
WHERE `base_target_id` = '51'
AND `base_res_target_table_name` = 'base_box'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 0 |
|
SELECT
`base_foto`.*
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
WHERE `base_target_id` = '52'
AND `base_res_target_table_name` = 'base_box'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 0 |
|
SELECT
`base_foto`.*
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
WHERE `base_target_id` = '53'
AND `base_res_target_table_name` = 'base_box'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 0 |
|
SELECT
`base_foto`.*
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
WHERE `base_target_id` = '54'
AND `base_res_target_table_name` = 'base_box'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 1 |
|
SELECT
`base_foto`.*
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
WHERE `base_target_id` = '55'
AND `base_res_target_table_name` = 'base_box'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 1 |
|
SELECT
`base_foto`.*
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
WHERE `base_target_id` = '56'
AND `base_res_target_table_name` = 'base_box'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 1 |
|
SELECT
`base_foto`.*
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
WHERE `base_target_id` = '61'
AND `base_res_target_table_name` = 'base_box'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 0 |
|
SELECT
`base_foto`.*
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
WHERE `base_target_id` = '58'
AND `base_res_target_table_name` = 'base_box'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 1 |
|
SELECT
`base_foto`.*
FROM `base_res_conn`
JOIN `base_foto` ON(`base_res_id` = `base_foto_id`)
WHERE `base_target_id` = '59'
AND `base_res_target_table_name` = 'base_box'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.000 | 0 |
|
SELECT
`base_news`.`base_news_id`,
`base_news_category`.`base_news_category_id`,
`base_news_category`.`base_news_category_name`,
`base_news`.`base_news_name`,
`base_news`.`base_content_id`,
CAST(GROUP_CONCAT(CONCAT(`base_news_table_param_name`, ':', `base_news_table_param_value`) SEPARATOR ';') AS CHAR CHARACTER SET utf8) as table_param
FROM `base_news_category`
JOIN `base_news_category_conn` USING(`base_news_category_id`)
JOIN `base_news` ON (`base_news`.`base_news_id` = `base_news_category_conn`.`base_news_id`)
JOIN `base_news_table_param` ON (`base_news_table_param`.`base_news_id` = `base_news`.`base_news_id`)
WHERE `base_news_category_id` = 6
AND `base_news_visible` = 1
AND `base_news_publish_date` < NOW()
AND (`base_news_always_visible` = 1 OR `base_news_unpublish_date` > NOW())
GROUP BY(`base_news`.`base_news_id`)
ORDER BY `base_news_table_param`.`base_news_table_param_id` ASC
| 0.001 | 5 |
| SELECT *
FROM (`base_menu`)
WHERE `core_lang_id` = '1'
AND `base_menu_name` = 'ROOT' | 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 `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 | 4 |
|
SELECT `base_menu_show_counter`
FROM `base_menu`
WHERE `base_menu_id` = '134' | 0.000 | 1 |
|
UPDATE `base_menu`
SET `base_menu_show_counter` = 145
WHERE `base_menu_id` = '134' | 0.810 | 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.001 | 4 |
|
SELECT
`base_menu_conn_id`
FROM `base_menu_conn`
WHERE
`base_menu_conn_item_id` <> 0
AND `base_menu_id` = 134 | 0.000 | 4 |
| SELECT `base_menu_conn_id`, `base_menu_conn_item_id`, `base_menu_conn_item_table_name`
FROM (`base_menu_conn`)
WHERE `base_menu_id` = '134'
ORDER BY `base_menu_conn_position` ASC
LIMIT 0, 5 | 0.000 | 4 |
| SELECT `base_content_name` AS `name`, `base_content_id` AS `id`, `base_content_desc` AS `desc`, `base_content_short_desc` AS `short_desc`, `base_content_desc_foto_type` AS `desc_foto_type`, `base_content_show_desc_foto` AS `show_desc_foto`
FROM (`base_content`)
WHERE `base_content_id` = '26' | 0.000 | 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_target_id` = '26'
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 | 1 |
| SELECT `base_content_name` AS `name`, `base_content_id` AS `id`, `base_content_desc` AS `desc`, `base_content_short_desc` AS `short_desc`, `base_content_desc_foto_type` AS `desc_foto_type`, `base_content_show_desc_foto` AS `show_desc_foto`
FROM (`base_content`)
WHERE `base_content_id` = '27' | 0.000 | 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_target_id` = '27'
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 | 1 |
| SELECT `base_content_name` AS `name`, `base_content_id` AS `id`, `base_content_desc` AS `desc`, `base_content_short_desc` AS `short_desc`, `base_content_desc_foto_type` AS `desc_foto_type`, `base_content_show_desc_foto` AS `show_desc_foto`
FROM (`base_content`)
WHERE `base_content_id` = '28' | 0.000 | 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_target_id` = '28'
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 | 1 |
| SELECT `base_content_name` AS `name`, `base_content_id` AS `id`, `base_content_desc` AS `desc`, `base_content_short_desc` AS `short_desc`, `base_content_desc_foto_type` AS `desc_foto_type`, `base_content_show_desc_foto` AS `show_desc_foto`
FROM (`base_content`)
WHERE `base_content_id` = '29' | 0.000 | 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_target_id` = '29'
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 | 1 |
|
SELECT
node.`base_menu_id`
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.`base_menu_id` = '134'
AND node.`base_menu_show_up_category` = '1'
AND node.`base_menu_id` <> '134'
AND (
(parent.`core_system_type_id` IS NULL AND node.`core_system_type_id` IS NULL)
OR (node.`core_system_type_id` = parent.`core_system_type_id`)
)
AND node.`core_lang_id` = parent.`core_lang_id`
ORDER BY node.`base_menu_left` | 0.000 | 0 |
| 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`, `core_system_type_id`) VALUES ('2012-02-23T00:52:00+01:00', '3877', NULL, 'content', 'show_category', '26', NULL) | 0.000 | 1 |
| Total: 48 | 0.817 | 164 |
