| Queries | Time | Rows |
| SELECT `core_route_controller`
FROM (`core_route`)
WHERE `core_route_alias` = 'news' | 0.000 | 0 |
| SELECT `core_route_controller`
FROM (`core_route`)
WHERE `core_route_alias` = 'show_category' | 0.000 | 0 |
| SELECT `core_route_controller`
FROM (`core_route`)
WHERE `core_route_alias` = 'cat_id' | 0.000 | 0 |
| SELECT `core_route_controller`
FROM (`core_route`)
WHERE `core_route_alias` = '6' | 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.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
`base_menu_id`
FROM `base_menu_conn`
WHERE `base_menu_conn_item_id` = 6
AND `base_menu_conn_item_table_name` = 'base_news_category' | 0.000 | 0 |
| 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.000 | 4 |
| SELECT *
FROM (`base_news_category`)
WHERE `base_news_category_id` = '6' | 0.000 | 1 |
| SELECT *
FROM (`base_news_category`)
WHERE `base_news_category_id` = 6 | 0.000 | 1 |
|
SELECT COUNT(*) count
FROM `base_news_category`
JOIN `base_news_category_conn` USING(`base_news_category_id`)
JOIN `base_news` USING(`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()) | 0.000 | 1 |
|
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`
,`base_news_more` `more_type`
,`base_content_id` `content_id`
,`base_news_more_url` `more_url`
,`base_news_facebook` `facebook`
FROM `base_news_category`
JOIN `base_news_category_conn` USING(`base_news_category_id`)
JOIN `base_news` USING(`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())
ORDER BY `base_news_publish_date` DESC LIMIT 1 OFFSET 0 | 0.001 | 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_news'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position`
| 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:53:20+01:00', '3877', NULL, 'news', 'show_category', '6', NULL) | 0.000 | 1 |
| Total: 43 | 0.006 | 142 |
