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
В свое время, когда я только начал интересоваться сетевыми технологиями и не было абсолютно никакого опыта в этой сфере, у меня уходило довольно много времени не только на изучение материалов, но и на их поиски. Приходилось читать все подряд и уже по ходу оценивать степень полезности прочитанного. Конечно можно заплатить n-ю сумму денег и пойти на специализированные сертификационные курсы, где все объяснят, покажут, дадут что-нибудь настроить и т.д. Однако, как я уже сказал, это стоит денег, поэтому многие специалисты (в том числе и я) решают заняться изучением самостоятельно, не прибегая к помощи специалистов за деньги. Вот именно для таких людей я и решил написать эту статью. Я решил собрать список материалов и советов начинающим специалистам в области сетевых технологий. Если вам интересно, то данная статья для вас.
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
Создание пакетов или packet crafting — это техника, которая позволяет сетевым инженерам или пентестерам исследовать сети, проверять правила фаерволлов и находить уязвимые места.
Делается это обычно вручную, отправляя пакеты на различные устройства в сети.
В качестве цели может быть брандмауэр, системы обнаружения вторжений (IDS), маршрутизаторы и любые другие участники сети.
Создание пакетов вручную не означает, что нужно писать код на каком-либо высокоуровневом языке программирования, можно воспользоваться готовым инструментом, например, Scapy.
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
Периодически у системных администраторов или у пользователей возникает необходимость подключить свой компьютер сразу в несколько сетей (VLAN-ов). Ставить отдельную сетевую карту для каждого VLAN-а не самый удобный и не самый дешевый способ решить такого рода задачу, поэтому я решил разобрать ситуацию когда наш компьютер подключен к сети через единственную физическую сетевую карту и при этом компьютер будет одновременно подключен сразу к несклольким логическим подсетям (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
Думаю каждый ИТ специалист когда-либо встречался с таким понятием как резервирование и отказоустойчивость. Представьте себе вы поддерживаете работу небольшого офиса, с одним маршрутизатором cisco в качестве шлюза в интернети несколькими коммутаторами уровня доступа. Все у вас замечательно и тут упал провайдер, который выпускал ваших сотрудников в интернет (думаю ситуация знакома каждому)...
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 очень простая. Для начала создается список доступа по какому-либо критерию, а потом применяется для той или иной функции.
Существует два вида списков доступа: стандартный и расширенный.
Для начала начнем с стандартного списка доступа. Давайте зайдем на маршрутизатор и создадим какой-нибудь список.
SELECT `session_id`
FROM `j25_session`
WHERE `session_id` = '51e5f0f5ee9d771a1f023ab0853814df' 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` = ' set' OR `title` = ' set' OR `alias` = ' set') 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:39:29' 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:39:29' 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` = '14'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`=' set' AND `id`!='14'
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 = '14' 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 = '14' 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 = '14' 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` = '14' 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` = '535' 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` = '535' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='535' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '535' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECT* FROMj25_easyblog_users WHERE `id` = '895'
SELECT* FROM `j25_users`
WHERE `id` = 895
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` = 895
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '439' 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` = '439' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='439' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '439' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '508' 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` = '508' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='508' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '508' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '424' 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` = '424' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='424' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '424' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '422' 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` = '422' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='422' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '422' 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
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` = '7'
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 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* FROMj25_easyblog_post WHERE `id` = '535'
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` ='535'
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` = '71'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='network' AND `id`!='71'
SELECT* FROMj25_easyblog_tag WHERE `id` = '14'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`=' set' AND `id`!='14'
SHOWFULLCOLUMNS FROM `j25_easyblog_ratings`
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='535' AND `type`='entry' AND `sessionid`='51e5f0f5ee9d771a1f023ab0853814df'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='535' 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` = '439'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=895' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='439'
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` = '6'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='bezopasnost' AND `id`!='6'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='439' AND `type`='entry' AND `sessionid`='51e5f0f5ee9d771a1f023ab0853814df'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='439' 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` = '508'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=895' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='508'
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` = '78'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='wifi' AND `id`!='78'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='508' AND `type`='entry' AND `sessionid`='51e5f0f5ee9d771a1f023ab0853814df'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='508' 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` = '424'
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` ='424'
SELECT* FROMj25_easyblog_category WHERE `id` = '7'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='operating-systems' AND `id`!='7'
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` = '20'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='linux' AND `id`!='20'
SELECT* FROMj25_easyblog_tag WHERE `id` = '72'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='operatsionnye-sistemy' AND `id`!='72'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='424' AND `type`='entry' AND `sessionid`='51e5f0f5ee9d771a1f023ab0853814df'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='424' 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` = '422'
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` ='422'
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` = '56'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='router' AND `id`!='56'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='422' AND `type`='entry' AND `sessionid`='51e5f0f5ee9d771a1f023ab0853814df'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='422' 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` = '13'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='nastrojka' AND `id`!='13'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='178' AND `type`='entry' AND `sessionid`='51e5f0f5ee9d771a1f023ab0853814df'
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`='51e5f0f5ee9d771a1f023ab0853814df'
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`='51e5f0f5ee9d771a1f023ab0853814df'
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`='51e5f0f5ee9d771a1f023ab0853814df'
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`='51e5f0f5ee9d771a1f023ab0853814df'
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_tag WHERE `id` = '14'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`=' set' AND `id`!='14'
SELECT* FROMj25_easyblog_tag WHERE `id` = '14'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`=' set' AND `id`!='14'
SELECT* FROMj25_easyblog_tag WHERE `id` = '14'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`=' set' AND `id`!='14'
SELECT* FROMj25_easyblog_tag WHERE `id` = '14'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`=' set' AND `id`!='14'
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 ( ( ('/easyblog/tags/tag/ set' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/easyblog/tags/tag/ set' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/ set' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/ set' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/easyblog/tags/tag/ set' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/easyblog/tags/tag/ set' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/ set' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/ set' 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:
47 × SELECT id FROMj25_assets
47 × SELECT a.rules FROMj25_assetsAS a
15 × SELECT* FROMj25_easyblog_tag
15 × SELECTCOUNT(1) FROM `j25_easyblog_tag`
10 × SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id`
10 × SELECTCOUNT(1) FROM `j25_easyblog_comment`
10 × SELECTCOUNT(1) FROM `j25_easyblog_featured`
10 × SELECT* FROM `j25_easyblog_ratings`
10 × 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`
10 × SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings`
10 × SELECT `id` FROM `j25_menu`
10 × SELECT* FROMj25_easyblog_post
10 × SELECT a.* FROM `j25_easyblog_post` as a
10 × 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` = '14'
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'