| Queries | Time | Rows |
| SELECT `core_route_controller`
FROM (`core_route`)
WHERE `core_route_alias` = 'o-firmie' | 0.030 | 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_visits` = `base_visit_day_visits` + 1
WHERE `base_visit_day_date` = CURDATE()
AND `base_visit_day_hour` = '00' AND `core_system_type_id` IS NULL | 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.000 | 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 = '132'
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` = '132'
AND `core_lang_id` = '1' | 0.000 | 1 |
|
SELECT `base_menu_show_counter`
FROM `base_menu`
WHERE `base_menu_id` = '132' | 0.000 | 1 |
|
UPDATE `base_menu`
SET `base_menu_show_counter` = 205
WHERE `base_menu_id` = '132' | 0.530 | 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 | 4 |
| SELECT *
FROM (`base_content`)
WHERE `base_content_id` = 18
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` = 18
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` = 18
AND `base_res_type` = 'forms'
AND `base_res_target_table_name` = 'base_content'
| 0.014 | 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` = 18
AND `base_res_target_table_name` = 'base_content'
AND `base_res_type` = 'foto'
AND `base_foto_removed` = 0
ORDER BY `base_res_position` | 0.001 | 0 |
|
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` = 18
AND `base_res_target_table_name` = 'base_content'
AND `base_res_type` = 'file'
AND `base_file_removed` = 0
ORDER BY `base_res_position` | 0.001 | 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` = 18
AND `base_res_target_table_name` = 'base_content'
AND `base_res_type` = 'movie'
AND `base_movie_removed` = 0
ORDER BY `base_res_position` | 0.001 | 0 |
|
UPDATE `base_content`
SET `base_content_show_count` = `base_content_show_count`+1
WHERE `base_content_id` = 18 | 0.043 | 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`, `core_system_type_id`) VALUES ('2012-02-23T00:45:26+01:00', '3877', NULL, 'content', 'show_details', '18', NULL) | 0.000 | 1 |
| Total: 45 | 0.624 | 149 |
