| Queries | Time | Rows |
|
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 `base_visit_user_id`
FROM `base_visit_details`
LEFT JOIN `base_visit` USING(`base_visit_user_id`)
WHERE DATE_SUB(NOW(), INTERVAL 15 MINUTE) < `base_visit_time`
AND `base_visit_details_ip` = '38.107.179.228'
AND `base_visit_details_browser` = ' ' | 0.001 | 0 |
|
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 ('2043', NULL, NULL, ' ', NULL, NULL, 0, '38.107.179.228', 0, 0, 0, '2012-01-28T11:58:50+01: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 `core_system_type_id` IS NULL AND `base_visit_user_id` = '2043' | 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` = '11' 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` = '11' 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.001 | 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` = '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_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_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 | 3 |
|
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_controller`
FROM (`core_route`)
WHERE `core_route_alias` = 'home' | 0.000 | 0 |
| SELECT `core_route_controller`
FROM (`core_route`)
WHERE `core_route_alias` = 'index' | 0.000 | 0 |
| SELECT *
FROM (`base_menu`)
WHERE `core_lang_id` = '1'
AND `base_menu_name` = 'ROOT' | 0.000 | 1 |
| SELECT `base_menu`.`base_menu_skin`, `base_menu`.`base_menu_name` AS `menu_name`, `base_menu`.`base_menu_id` AS `menu_id`, `base_menu`.`base_menu_type` AS `menu_type`, `base_menu`.`base_menu_out_link`, `base_menu`.`base_menu_up`, `base_menu`.`base_menu_category`, `base_menu`.`base_menu_category_title` AS `title`, `base_menu`.`base_menu_category_desc` AS `category_desc`, `base_menu`.`base_menu_category_footer` AS `category_footer`, `base_menu`.`base_menu_category_type` AS `category_type`, `base_menu`.`base_menu_category_page_size` AS `category_page_size`, `base_menu`.`base_menu_seo_title` AS `seo_title`, `base_menu`.`base_menu_seo_keys` AS `seo_keys`, `base_menu`.`base_menu_seo_desc` AS `seo_desc`, `base_menu_conn_item_table_name` AS `menu_content_type`, `base_menu`.`base_menu_show_counter` AS `menu_show_counter`, `base_menu_conn_item_id` AS `menu_content_id`
FROM (`base_menu`)
LEFT JOIN `base_menu_conn` ON (`base_menu_conn`.`base_menu_id` = `base_menu`.`base_menu_id`)
WHERE base_menu.base_menu_id IS NULL
AND `core_lang_id` = '1' | 0.000 | 0 |
|
SELECT
`base_link`.*
,`base_content`.`base_content_name`
FROM `base_link`
LEFT JOIN `base_content` USING (`base_content_id`)
WHERE TRUE
AND `base_link`.`core_lang_id` = '1'
ORDER BY
`base_link_position` ASC;
| 0.000 | 3 |
| 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-01-28T11:58:50+01:00', '2043', NULL, 'home', 'index', NULL, NULL) | 0.000 | 1 |
| Total: 38 | 0.012 | 72 |
