Запрет доступа к определенным Web-страницам (ну, например ко всеми любимой порнухе) с использованием Site and Content rules. Это руководство покажет вам, как это делается с помощью Site and content rules. Когда юзера пытаются, пытаются, пытаются куда-то залезть через ISA Server, то он (ISA) сначала проверяет, проверяет, и еще раз проверяет - а не находится ли данное содержимое в Site and Content Rules определенных специально для запрета доступа к этому содержимому (или сайту). Запросы также дозволены если (Site And Content)-правило позволяет клиенту интернет-доступ используя протокол, определенный в правиле.
С момента когда зарелизился Windows Server 2003 многие наверняка сразу попробовали установить ISA Server 2000 на эту платформу. Но Microsoft сразу предупредила, что все не просто так, выпустив сначала один, а потом и второй, более усовершенствованный патч для установки ISA Server. В этой статье я расскажу как правильно поставить Microsoft Security and Acceleration Server 2000 на Microsoft Windows 2003 Server.
Перед тем как устанавливать ISA сервер вам необходимо настроить сетевые интерфейсы на вашем сервере. Ошибки в настройках сетевых карт могут повлечь за собой серьезные перебои или полную неработоспособность ISA сервера, так как сервис firewall работает на том же уровне , что и драйвера в системе. В данной статье рассматривается пошаговая настройка сетевых интерфейсов при работе с Microsoft ISA server.
Рассматривется ISA Server Enterprise Edition в конфигурации массива, если в вашей сети установлен ISA Server в автономной конфигурации, функции мониторинга при этом практически не меняются. Массив обеспечивает централизованное управление несколькими серверами ISA и интеграцию со службой Active Directory (AD); при автономной установке эти возможности недоступны. Кроме того, подбирая примеры для статьи, я исходил из предположения, что ISA Server установлен в режиме Integrated (интегрированный), сочетающем функции служб Firewall (брандмауэр) и Caching (кэширование). Надо отметить, что пакет ISA Server можно устанавливать в режимах Caching, Firewall или Integrated. Чтобы иметь возможность вести журналы с помощью ODBC, нужно установить ODBC-совместимую базу данных. Я описываю функции ODBC для конфигураций с Microsoft SQL Server 2000 и Microsoft Access.
Чтобы полностью освоить все функции ISA Server, может потребоваться немало времени, но инженерам Microsoft удалось упростить базовую процедуру конфигурирования довольно сложного комплексного продукта. Затратив небольшие усилия на подготовку плана действий, можно быстро настроить ISA Server для управления доступом к сети и снизить требования к полосе пропускания канала связи. Можно воспользоваться и многими другими функциями, в том числе простыми средствами обнаружения попыток несанкционированного доступа и надежными инструментами регистрации, составления отчетов и оповещения.
DELETE FROM `j25_session`
WHERE `time` < '1757537287'
SELECT `session_id`
FROM `j25_session`
WHERE `session_id` = '4da2e60150758ef6b2f92a5b33d785a9' LIMIT 0, 1
SELECT b.id
FROMj25_usergroupsAS a
LEFTJOINj25_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `j25_viewlevels`
SELECT folder AS type, element AS name, params
FROMj25_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1)
ORDERBY ordering
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROMj25_menuAS m
LEFTJOINj25_extensionsAS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDERBY m.lft
SHOWFULLCOLUMNS FROM `j25_easyblog_configs`
SELECT* FROMj25_easyblog_configs WHERE `name` = 'config'
SHOWFULLCOLUMNS FROM `j25_easyblog_category`
SELECT id FROMj25_easyblog_category WHERE alias='listings'
SELECT id FROMj25_easyblog_category WHERE alias='listings'
SELECT id FROMj25_easyblog_category WHERE alias='materials'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT id, home, template, s.params
FROMj25_template_styles as s
LEFTJOINj25_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
WHERE s.client_id = 0 AND e.enabled = 1
DELETE FROM `j25_easyblog_mailq` WHERE `status`='1' ANDDATEDIFF(NOW(), `created`) >= 7
SELECT `id` FROM `j25_easyblog_mailq` WHERE `status` = 0 ORDERBY `created` ASC LIMIT 5
SELECT* FROM `j25_easyblog_post` WHERE `publish_up` <= '2025-09-10 21:33:07' AND `published` = '2' AND `ispending` = '0' ORDERBY `id` LIMIT 5
UPDATE `j25_easyblog_post` SET `published` = '0' WHERE `publish_down` > `publish_up` AND `publish_down` <= '2025-09-10 21:33:07' AND `publish_down` != '0000-00-00 00:00:00' AND `published` != '0' AND `published` != '3' AND `ispending` = '0'
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SHOWFULLCOLUMNS FROM `j25_assets`
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT b.rules
FROMj25_assetsAS a
LEFTJOINj25_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SHOWFULLCOLUMNS FROM `j25_easyblog_users`
SELECTCOUNT(*) FROM `j25_easyblog_configs` WHERE `name` = 'default'
SELECT* FROMj25_easyblog_configs WHERE `name` = 'default'
SELECT* FROM `j25_easyblog_acl` WHERE `published`=1 ORDERBY `id` ASC
SELECT* FROM `j25_easyblog_acl_group` WHERE `content_id`='1' AND `type`=' group'
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT id, keywords, description, indexing FROM `j25_easyblog_meta` WHERE content_id = '6' and type = 'category'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '6' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '6'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '7' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '7'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '8' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '8'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '9' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '9'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '10' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '10'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '17' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '17'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '12' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '12'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '11' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '11'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '13' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '13'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '14' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '14'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '16' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '16'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '25' and a.`published` = '1' ORDERBY a.`lft` ASC
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a where (a.`private` = '0' OR a.`id` IN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )) AND a.parent_id = '25'
SELECT* FROMj25_easyblog_category WHERE `id` = '7'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='operating-systems' AND `id`!='7'
SELECT* FROMj25_easyblog_category WHERE `id` = '8'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='virtualizatsiya-terminaly' AND `id`!='8'
SELECT* FROMj25_easyblog_category WHERE `id` = '9'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='email' AND `id`!='9'
SELECT* FROMj25_easyblog_category WHERE `id` = '10'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='network' AND `id`!='10'
SELECT* FROMj25_easyblog_category WHERE `id` = '17'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='the-microsoft-isa-server' AND `id`!='17'
SELECT* FROMj25_easyblog_category WHERE `id` = '12'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='hardware' AND `id`!='12'
SELECT* FROMj25_easyblog_category WHERE `id` = '11'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='administration' AND `id`!='11'
SELECT* FROMj25_easyblog_category WHERE `id` = '13'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='data-bases' AND `id`!='13'
SELECT* FROMj25_easyblog_category WHERE `id` = '14'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='telephony' AND `id`!='14'
SELECT* FROMj25_easyblog_category WHERE `id` = '16'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='security' AND `id`!='16'
SELECT* FROMj25_easyblog_category WHERE `id` = '25'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='mobajl' AND `id`!='25'
SELECTCOUNT(b.`id`) AS `cnt` FROM `j25_easyblog_category` AS `a` LEFTJOIN `j25_easyblog_post` AS b ON a.`id` = b.`category_id` AND b.`published` = '1' AND b.`private` = '0' WHERE a.`published` = 1 AND a.`id` = '6' GROUPBY a.`id` HAVING (COUNT(b.`id`) > 0)
select `id` FROM `j25_easyblog_team` where `access` = '3' and `published` = '1'
select distinct a.`id`, a.`private` from `j25_easyblog_category` as a left join `j25_easyblog_category_acl` as b on a.`id` = b.`category_id` and b.`acl_id` = '1' where a.`private` != '0' and b.`category_id` NOTIN ( SELECT c.category_id FROM `j25_easyblog_category_acl` as c WHERE c.acl_id = '1' AND c.content_id IN ('1') )
SELECTCOUNT(1) FROM `j25_easyblog_post` AS a WHERE a.`published` = 1 AND a.`ispending` = '0' AND a.`private` = '0' AND a.`category_id` IN (6,7,8,9,10,17,12,11,13,14,16,25) AND a.`issitewide` = '1' AND a.`blogpassword` = ""
SELECT a.`id` AS key1, a.*, b.`id` as key2, b.`title` as `category` FROM `j25_easyblog_post` AS a LEFTJOIN `j25_easyblog_category` AS b ON a.category_id = b.id WHERE a.`published` = 1 AND a.`ispending` = '0' AND a.`private` = '0' AND a.`category_id` IN (6,7,8,9,10,17,12,11,13,14,16,25) AND a.`issitewide` = '1' AND a.`blogpassword` = "" ORDERBY a.`created` desc LIMIT 80,5
SELECTCOUNT(1) FROM `j25_easyblog_category_acl` WHERE `acl_id` = '1' AND `status` = '1' AND `category_id` = '6' AND `content_id` IN ('1')
SHOWFULLCOLUMNS FROM `j25_easyblog_post`
SELECT* FROMj25_easyblog_users WHERE `id` = '64'
SHOWFULLCOLUMNS FROM `j25_users`
SELECT* FROM `j25_users`
WHERE `id` = 64
SELECT `g`.`id`,`g`.`title`
FROM `j25_usergroups` AS g
INNERJOIN `j25_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 64
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '90' AND `type` = 'post'
SHOWFULLCOLUMNS FROM `j25_komento_configs`
SELECT* FROMj25_komento_configs WHERE `component` = 'com_komento'
SELECT a.`id`, a.`title`, a.`alias` FROM `j25_easyblog_tag` AS a LEFTJOIN `j25_easyblog_post_tag` AS b ON a.`id` = b.`tag_id` WHERE b.`post_id` = '90' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='90' AND `published` = '1'
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '89' AND `type` = 'post'
SELECT a.`id`, a.`title`, a.`alias` FROM `j25_easyblog_tag` AS a LEFTJOIN `j25_easyblog_post_tag` AS b ON a.`id` = b.`tag_id` WHERE b.`post_id` = '89' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='89' AND `published` = '1'
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '88' AND `type` = 'post'
SELECT a.`id`, a.`title`, a.`alias` FROM `j25_easyblog_tag` AS a LEFTJOIN `j25_easyblog_post_tag` AS b ON a.`id` = b.`tag_id` WHERE b.`post_id` = '88' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='88' AND `published` = '1'
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '87' AND `type` = 'post'
SELECT a.`id`, a.`title`, a.`alias` FROM `j25_easyblog_tag` AS a LEFTJOIN `j25_easyblog_post_tag` AS b ON a.`id` = b.`tag_id` WHERE b.`post_id` = '87' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='87' AND `published` = '1'
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '86' AND `type` = 'post'
SELECT a.`id`, a.`title`, a.`alias` FROM `j25_easyblog_tag` AS a LEFTJOIN `j25_easyblog_post_tag` AS b ON a.`id` = b.`tag_id` WHERE b.`post_id` = '86' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='86' AND `published` = '1'
select count(1) from `j25_easyblog_post` as a inner join `j25_easyblog_category` as b on a.`category_id` = b.`id` and b.`id` = '6' inner join `j25_easyblog_team_post` as c on a.`id` = c.`post_id` where a.`issitewide` = '0'
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_category WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='materials' AND `id`!='6'
SELECT* FROMj25_easyblog_post WHERE `id` = '90'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=64' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='90'
SHOWFULLCOLUMNS FROM `j25_easyblog_ratings`
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='90' AND `type`='entry' AND `sessionid`='4da2e60150758ef6b2f92a5b33d785a9'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='90' AND `type`='entry'
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_post WHERE `id` = '89'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=64' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='89'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='89' AND `type`='entry' AND `sessionid`='4da2e60150758ef6b2f92a5b33d785a9'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='89' AND `type`='entry'
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_post WHERE `id` = '88'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=64' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='88'
SHOWFULLCOLUMNS FROM `j25_easyblog_tag`
SELECT* FROMj25_easyblog_tag WHERE `id` = '12'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='microsoft-isa-server' AND `id`!='12'
SELECT* FROMj25_easyblog_tag WHERE `id` = '13'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='nastrojka' AND `id`!='13'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='88' AND `type`='entry' AND `sessionid`='4da2e60150758ef6b2f92a5b33d785a9'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='88' AND `type`='entry'
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_post WHERE `id` = '87'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=64' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='87'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='87' AND `type`='entry' AND `sessionid`='4da2e60150758ef6b2f92a5b33d785a9'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='87' AND `type`='entry'
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_easyblog_post WHERE `id` = '86'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=64' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='86'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='86' AND `type`='entry' AND `sessionid`='4da2e60150758ef6b2f92a5b33d785a9'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='86' AND `type`='entry'
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT a.rules
FROMj25_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT id
FROMj25_assets WHERE parent_id = 0
SELECT* FROMj25_tagmeta_rules WHERE ( ( ('/categories/listings/materials?start=80' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/categories/listings/materials?start=80' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/categories/listings/materials?start=80' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/categories/listings/materials?start=80' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/categories/listings/materials?start=80' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/categories/listings/materials?start=80' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/categories/listings/materials?start=80' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/categories/listings/materials?start=80' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only=0) ) ) AND published=1 ORDERBY ordering
55 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
32 × SELECT id FROMj25_assets
32 × SELECT a.rules FROMj25_assetsAS a
30 × SELECTCOUNT(1) FROM `j25_easyblog_category`
30 × SELECT* FROMj25_easyblog_category
12 × select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a
12 × select distinct a.`id`, a.`private` from `j25_easyblog_category` as a
5 × SELECT* FROMj25_easyblog_post
5 × SELECT a.`id`, a.`title`, a.`alias` FROM `j25_easyblog_tag` AS a LEFTJOIN `j25_easyblog_post_tag` AS b ON a.`id` = b.`tag_id`
5 × SELECTCOUNT(1) FROM `j25_easyblog_featured`
5 × SELECTCOUNT(1) FROM `j25_easyblog_comment`
5 × SELECT `id` FROM `j25_menu`
5 × SELECT a.* FROM `j25_easyblog_post` as a
5 × SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings`
5 × SELECT* FROM `j25_easyblog_ratings`
3 × SELECT id FROMj25_easyblog_category
2 × SELECT* FROMj25_easyblog_configs
2 × SELECT* FROMj25_easyblog_tag
2 × SELECTCOUNT(1) FROM `j25_easyblog_tag`
1 × SELECT* FROM `j25_users`
1 × SELECT* FROMj25_easyblog_users
1 × SELECT `g`.`id`,`g`.`title` FROM `j25_usergroups` AS g INNERJOIN `j25_user_usergroup_map` AS m ON m.group_id = g.id
1 × SELECT* FROMj25_tagmeta_rules
1 × SELECTCOUNT(1) FROM `j25_easyblog_category_acl`
1 × select count(1) from `j25_easyblog_post` as a inner join `j25_easyblog_category` as b on a.`category_id` = b.`id` and b.`id` = '6' inner join `j25_easyblog_team_post` as c on a.`id` = c.`post_id`
1 × SELECT* FROMj25_komento_configs
1 × SELECTCOUNT(b.`id`) AS `cnt` FROM `j25_easyblog_category` AS `a` LEFTJOIN `j25_easyblog_post` AS b ON a.`id` = b.`category_id` AND b.`published` = '1' AND b.`private` = '0'
1 × SELECT id, home, template, s.params FROMj25_template_styles as s LEFTJOINj25_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT `id` FROM `j25_easyblog_mailq`
1 × SELECT* FROM `j25_easyblog_post`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROMj25_menuAS m LEFTJOINj25_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params FROMj25_extensions
1 × SELECT b.id FROMj25_usergroupsAS a LEFTJOINj25_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, rules FROM `j25_viewlevels
1 × SELECT b.rules FROMj25_assetsAS a LEFTJOINj25_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECTCOUNT(*) FROM `j25_easyblog_configs`
1 × select `id` FROM `j25_easyblog_team`
1 × select distinct a.`id`, a.`private` from `j25_easyblog_category` as a left join `j25_easyblog_category_acl` as b on a.`id` = b.`category_id` and b.`acl_id` = '1'
1 × SELECTCOUNT(1) FROM `j25_easyblog_post` AS a
1 × SELECT `session_id` FROM `j25_session`
1 × SELECT id, keywords, description, indexing FROM `j25_easyblog_meta`
1 × SELECT* FROM `j25_easyblog_acl`
1 × SELECT* FROM `j25_easyblog_acl_group`
1 × SELECT a.`id` AS key1, a.*, b.`id` as key2, b.`title` as `category` FROM `j25_easyblog_post` AS a LEFTJOIN `j25_easyblog_category` AS b ON a.category_id = b.id
OTHER Tables:
1 × SHOWFULLCOLUMNS FROM `j25_users
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_post
1 × SHOWFULLCOLUMNS FROM `j25_komento_configs
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_ratings
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_tag
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_users
1 × SHOWFULLCOLUMNS FROM `j25_assets
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_configs
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_category
1 × DELETE FROM `j25_easyblog_mailq`
1 × UPDATE `j25_easyblog_post` SET `published` = '0'