Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
Представим следующую ситуацию. Сидите вы мирно за компьютером, попивая кофе и читая новости с networkdoc.ru :) Сеть у вас настроена, с несколькими VLAN-ами, с NAT-ом, DHCP, списками доступа, блекджеком и т.д. Тут к вам приходит начальник и говорит следующее: "Наша компания движется вперед и мы вскоре откроем филиал в Урюпинске, где будет сидеть 5 калек, но им крайне важно для бизнеса компании иметь доступ к корпоративной почте, 1с и прочей лабуде" Естественно это должно быть безопасно и все ваши сервера находятся как полагается в серверной в главном здании. Начальник готов купить маршрутизатор, хаб или че там вам ИТшникам надо что бы это сделать.
Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
В предыдущих постах мы провели базовую настройку маршрутизатора, так же настроили NAT для выхода в интернет и DHCP что бы упростить задачу выдачи ip адресов пользователям. По сути дела базовые вещи для работы нашей сети готовы. Что же будем делать дальше? Предлагаю рассмотреть такой вопрос как настройка VLAN-ов на коммутаторах и заодно рассмотреть зачем нам это нужно.
Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
В предыдущей статье мы настроили нашим офисным сотрудникам доступ в интернет посредством NAT. При этом параметры ip address, mask, default-gateway и т.д. на компьютерах приходилось настраивать статически. Когда у нас в офисе 5 сотрудников это не является большой проблемой, однако представим, что у нас 50 или более пользователей, тогда настройка этих параметров на каждом компьютере будет трудозатратной.
Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
Что такое NAT и зачем он нужен? Давайте посмотрим что по этому поводу нам говорит Википедия.
NAT (от англ.Network Address Translation — «преобразование сетевых адресов») — это механизм в сетяхTCP/IP, позволяющий преобразовывать IP-адреса транзитных пакетов. Также имеет названия IP Masquerading, Network Masquerading и Native Address Translation.
Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
В маршрутизаторах фирмы Cisco существует возможность управления трафиком посредством списков доступа (ACL).
Важной особенностью является то, что они используются не только для управления доступом, а так же как для настройки таких вещей как NAT, IPSec туннелей, QoS и т.д.
Предлагаю перейти к практике и по ходу дела все разъяснится.
Идеалогия работы с ACL очень простая. Для начала создается список доступа по какому-либо критерию, а потом применяется для той или иной функции.
Существует два вида списков доступа: стандартный и расширенный.
Для начала начнем с стандартного списка доступа. Давайте зайдем на маршрутизатор и создадим какой-нибудь список.
Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
Notice: Trying to get property of non-object in /var/www/networkdoc/libraries/joomla/factory.php on line 223
Если вы в первый раз сталкнулись с оборудование cisco, то совершенно очевидно, что необходимо понять как с ним обращаться, создать своего первого пользователя, задать имя вашего устройства, задать время, настроить возможность удаленного подключения и т.д.
Данную статью я решил посвятить ряду подобных вопросов и как результат решил назвать ее "Первоначальная настройка маршрутизаторов Cisco". Сразу хочу заметить, что мы не будем вдаваться в настройки детально, а просто пройдемся по ряду опций, что бы иметь необходимое представление по теме.
Перед тем как устанавливать ISA сервер вам необходимо настроить сетевые интерфейсы на вашем сервере. Ошибки в настройках сетевых карт могут повлечь за собой серьезные перебои или полную неработоспособность ISA сервера, так как сервис firewall работает на том же уровне , что и драйвера в системе. В данной статье рассматривается пошаговая настройка сетевых интерфейсов при работе с Microsoft ISA server.
SELECT `session_id`
FROM `j25_session`
WHERE `session_id` = 'c9bf155ac335a4563f05d8c961335fec' 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_tag`
SELECT* FROM `j25_easyblog_tag` WHERE (`title` = 'nastrojka' OR `title` = 'nastrojka' OR `alias` = 'nastrojka') LIMIT 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-09 19:43:02' 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-09 19:43:02' 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_tag WHERE `id` = '13'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='nastrojka' AND `id`!='13'
SELECT id, keywords, description, indexing FROM `j25_easyblog_meta` WHERE content_id = '3' and type = 'view'
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') )
SELECT b.*, c.`title` as `category` FROM `j25_easyblog_post_tag` AS a INNERJOIN `j25_easyblog_post` AS b ON a.post_id=b.id LEFTJOIN `j25_easyblog_category` AS c ON b.category_id = c.id WHERE a.tag_id = '13' AND b.`published` = '1' AND b.`private` = '0' AND b.`issitewide` = '1' ORDERBY b.`created` desc LIMIT 0,10
SELECTCOUNT(1) FROM (SELECT b.*, c.`title` as `category` FROM `j25_easyblog_post_tag` AS a INNERJOIN `j25_easyblog_post` AS b ON a.post_id=b.id LEFTJOIN `j25_easyblog_category` AS c ON b.category_id = c.id WHERE a.tag_id = '13' AND b.`published` = '1' AND b.`private` = '0' AND b.`issitewide` = '1' ORDERBY b.`created` desc) as x
SELECTCOUNT(1) FROM (SELECT b.*, c.`title` as `category` FROM `j25_easyblog_post_tag` AS a INNERJOIN `j25_easyblog_post` AS b ON a.post_id=b.id LEFTJOIN `j25_easyblog_category` AS c ON b.category_id = c.id WHERE a.tag_id = '13' AND b.`published` = '1' AND b.`private` = '0' AND b.`issitewide` = '1' ORDERBY b.`created` desc) as x
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') )
select count(1) from `j25_easyblog_post` as a inner join `j25_easyblog_post_tag` as b on a.`id` = b.`post_id` and b.`tag_id` = '13' where a.`private` = '1'
SHOWFULLCOLUMNS FROM `j25_easyblog_post`
SELECT* FROMj25_easyblog_users WHERE `id` = '81'
SHOWFULLCOLUMNS FROM `j25_users`
SELECT* FROM `j25_users`
WHERE `id` = 81
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` = 81
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '182' 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` = '182' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='182' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '182' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '178' 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` = '178' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='178' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '178' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '177' 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` = '177' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='177' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '177' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '176' 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` = '176' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='176' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '176' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '174' 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` = '174' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='174' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '174' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '172' 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` = '172' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='172' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '172' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '170' 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` = '170' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='170' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '170' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECT* FROMj25_easyblog_users WHERE `id` = '64'
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` = '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'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '88' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '10'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '10'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '10'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '10'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '10'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '10'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '10'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '17'
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_tag WHERE `id` = '13'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='nastrojka' AND `id`!='13'
SELECT* FROMj25_easyblog_post WHERE `id` = '182'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=81' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='182'
SHOWFULLCOLUMNS FROM `j25_easyblog_category`
SELECT* FROMj25_easyblog_category WHERE `id` = '10'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='network' AND `id`!='10'
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_tag WHERE `id` = '28'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='cisco' AND `id`!='28'
SELECT* FROMj25_easyblog_tag WHERE `id` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='bezopasnost' AND `id`!='6'
SELECT* FROMj25_easyblog_tag WHERE `id` = '13'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='nastrojka' AND `id`!='13'
SHOWFULLCOLUMNS FROM `j25_easyblog_ratings`
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='182' AND `type`='entry' AND `sessionid`='c9bf155ac335a4563f05d8c961335fec'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='182' 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` = '178'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=81' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='178'
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_tag WHERE `id` = '14'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`=' set' AND `id`!='14'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='178' AND `type`='entry' AND `sessionid`='c9bf155ac335a4563f05d8c961335fec'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='178' 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` = '177'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=81' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='177'
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* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='177' AND `type`='entry' AND `sessionid`='c9bf155ac335a4563f05d8c961335fec'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='177' 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` = '176'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=81' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='176'
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* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='176' AND `type`='entry' AND `sessionid`='c9bf155ac335a4563f05d8c961335fec'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='176' 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` = '174'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=81' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='174'
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* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='174' AND `type`='entry' AND `sessionid`='c9bf155ac335a4563f05d8c961335fec'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='174' 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` = '172'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=81' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='172'
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* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='172' AND `type`='entry' AND `sessionid`='c9bf155ac335a4563f05d8c961335fec'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='172' 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` = '170'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=81' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='170'
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* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='170' AND `type`='entry' AND `sessionid`='c9bf155ac335a4563f05d8c961335fec'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='170' 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'
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_tag WHERE `id` = '12'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='microsoft-isa-server' AND `id`!='12'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='88' AND `type`='entry' AND `sessionid`='c9bf155ac335a4563f05d8c961335fec'
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_tag WHERE `id` = '13'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='nastrojka' AND `id`!='13'
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 ( ( ('/easyblog/tags/tag/nastrojka' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/easyblog/tags/tag/nastrojka' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/nastrojka' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/nastrojka' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/easyblog/tags/tag/nastrojka' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/easyblog/tags/tag/nastrojka' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/nastrojka' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/nastrojka' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only=0) ) ) AND published=1 ORDERBY ordering
51 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
41 × SELECT id FROMj25_assets
41 × SELECT a.rules FROMj25_assetsAS a
8 × SELECTCOUNT(1) FROM `j25_easyblog_comment`
8 × SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id`
8 × 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`
8 × SELECTCOUNT(1) FROM `j25_easyblog_featured`
8 × SELECTCOUNT(1) FROM `j25_easyblog_tag`
8 × SELECT* FROMj25_easyblog_tag
8 × SELECT* FROM `j25_easyblog_ratings`
8 × SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings`
8 × SELECT `id` FROM `j25_menu`
8 × SELECT* FROMj25_easyblog_post
8 × SELECT a.* FROM `j25_easyblog_post` as a
8 × SELECT `title`, `id` FROM `j25_easyblog_category`
2 × SELECT* FROM `j25_users`
2 × SELECT* FROMj25_easyblog_users
2 × SELECT `g`.`id`,`g`.`title` FROM `j25_usergroups` AS g INNERJOIN `j25_user_usergroup_map` AS m ON m.group_id = g.id
2 × SELECTCOUNT(1) FROM `j25_easyblog_category`
2 × SELECTCOUNT(1) FROM (SELECT b.*, c.`title` as `category` FROM `j25_easyblog_post_tag` AS a INNERJOIN `j25_easyblog_post` AS b ON a.post_id=b.id LEFTJOIN `j25_easyblog_category` AS c ON b.category_id = c.id
2 × SELECT* FROMj25_easyblog_category
2 × 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'
2 × SELECT* FROMj25_easyblog_configs
1 × SELECT* FROM `j25_easyblog_tag`
1 × SELECT `id` FROM `j25_easyblog_mailq`
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* FROMj25_tagmeta_rules
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* FROM `j25_easyblog_post`
1 × SELECT b.rules FROMj25_assetsAS a LEFTJOINj25_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × select `id` FROM `j25_easyblog_team`
1 × SELECT `session_id` FROM `j25_session`
1 × select count(1) from `j25_easyblog_post` as a inner join `j25_easyblog_post_tag` as b on a.`id` = b.`post_id` and b.`tag_id` = '13'
1 × SELECT id, keywords, description, indexing FROM `j25_easyblog_meta`
1 × SELECT* FROM `j25_easyblog_acl_group`
1 × SELECTCOUNT(*) FROM `j25_easyblog_configs`
1 × SELECT* FROM `j25_easyblog_acl`
1 × SELECT* FROMj25_komento_configs
1 × SELECT b.*, c.`title` as `category` FROM `j25_easyblog_post_tag` AS a INNERJOIN `j25_easyblog_post` AS b ON a.post_id=b.id LEFTJOIN `j25_easyblog_category` AS c ON b.category_id = c.id
OTHER Tables:
1 × SHOWFULLCOLUMNS FROM `j25_users
1 × SHOWFULLCOLUMNS FROM `j25_komento_configs
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_category
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_ratings
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_post
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_users
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_tag
1 × DELETE FROM `j25_easyblog_mailq`
1 × UPDATE `j25_easyblog_post` SET `published` = '0'