Абсолютно банальный пост, но не написать не могу. Как мне казалось, проблемы синхронизации времени уже нигде не существует, ведь каждый комп подключен к интернету. Ха! :) В нашей деревне есть еще организации, где самое точное время показывают часы, висящие над вахтершей бабой Клавой.
Наблюдал сегодня своими глазами в небольшой конторе. Парк машин порядка 15 компов. Домена никакого нет. Все компьютеры объеденины в локальную сеть двумя дешевыми китайскими свитчами. Один комп помимо этого имеет подключени к интернету по ADSL. Одмина в конторе нет, точнее он есть, но какой-то приходящий, который там появляется только в день выдачи зарплаты. На всех компах время разное с разбегом в 20 минут. Красота!
Освежим память и расскажем, как сделать порядок в этом вопросе.
Решил глянуть расширенную статистику по блогу. Тут и обнаружил, что размеры мониторов у всех уже давно как подросли, и стандартное разрешение 1024, на которое и был ориентирован шаблон блога, используется редко. Смотрите сами, всего 8%:
Перекроил ширину на 1280 точек. Как вам? Стоит оставить так или вернуть всё в зад?
По сути, изменить область можно только одним способом - сначала удалить её, а затем создать заново. Удалить проще всего, но вот потом заново заводить все хосты в резерв и настройки не самое приятное занятие. Однако, существует способ сделать все быстро и почти автоматически.
Первым делом идем на сам DHCP-сервер и cmd даем следующую команду:
netsh dhcp server \\"Server name" scope "scope subnet" dump>c:\dhcp.txt
где "server name" - имя DHCP-сервера, а "scope subnet" - подсеть нашей области.
В моем примере это будет выглядеть вот так: netsh dhcp server \\serv1 scope 192.168.10.0 dump>c:\dhcp.txt
Получившийся текстовый файл содержит все настройки нашей области, включая зарезервированные узлы. Открываем его в любом текстовом редакторе, находим и правим маску подсети. Попутно можно отредактировать что-нибудь еще, если в этом есть необходимость. Сохраняем.
Теперь на консоли DHCP-сервера удаляем нашу область и в командной строке выполяем следующее:
netsh exec c:\dhcp.txt
Эта команда добавляет область на DHCP-сервер с настройками из нашего файла. Открываем заново консоль DHCP-сервера и смотрим отредактированную область. Маска подсети должна быть уже другой.
Не так давно OpenMediaVault окончательно перешел на версию 0.4.х, а с 30 декабря 2012 года версия 0.3.х больше не поддерживается разработчиками и исправления к ней не выпускаются. Это значит, что обновляться на 0.4 нужно в любом случае.
Для начала попытался выяснить, чем же новая версия принципиально отличается от старой. К сожалению ничего конкретного не нашел, только общие фразы: улучшено то, исправлено то и т.п. Кароче, 0.4 это эволюционное развитие проекта.
Обновиться до 0.4 можно двумя способами: в web-интерфейсе в разделе обновлений или используя консоль. Во втором случае нужно набрать последовательно несколько команд.
Сначала две команды для обновления 0.3 до крайней версии:
apt-get update
apt-get upgrade
Затем одну команду для перехода с 0.3 на 0.4:
omv-release-upgrade
Есть только один важный момент, который надо знать перед обновлением. Все установленные плагины в 0.3 требуют адаптации под 0.4. Плагины из официального репозитория по большей части уже адаптированы, а вот если у вас установлены дополнения сторонних разработчиков, то тут могут возникнуть проблемы. Чтобы избежать трудностей, рекомендуется сначала выключить все плагины, чтобы они не стали причиной сбоя. После обновления системы их можно будет попытаться обновить и запустить.
DELETE FROM `j25_session`
WHERE `time` < '1757499297'
SELECT `session_id`
FROM `j25_session`
WHERE `session_id` = 'a469bf6831ad0a983fdf00082ecdcdd8' 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='sisadminstvo'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
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
SELECT* FROMj25_languages WHERE published=1
ORDERBY ordering ASC
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 10:59:57' 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 10:59:57' 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` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT id, keywords, description, indexing FROM `j25_easyblog_meta` WHERE content_id = '19' and type = 'category'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
select a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a where a.parent_id = '19' 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 = '19'
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` = '19' 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` = '19' 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` = '19' AND a.`issitewide` = '1' AND a.`blogpassword` = "" ORDERBY a.`created` desc LIMIT 5,5
SELECTCOUNT(1) FROM `j25_easyblog_category_acl` WHERE `acl_id` = '1' AND `status` = '1' AND `category_id` = '19' AND `content_id` IN ('1')
SHOWFULLCOLUMNS FROM `j25_easyblog_post`
SELECT* FROMj25_easyblog_users WHERE `id` = '62'
SHOWFULLCOLUMNS FROM `j25_users`
SELECT* FROM `j25_users`
WHERE `id` = 62
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` = 62
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '126' 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` = '126' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='126' AND `published` = '1'
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '127' 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` = '127' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='127' AND `published` = '1'
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '128' 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` = '128' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='128' AND `published` = '1'
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '129' 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` = '129' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='129' AND `published` = '1'
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '130' 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` = '130' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='130' 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` = '19' 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` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT* FROMj25_easyblog_category WHERE `id` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
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` = '19'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='sisadminstvo' AND `id`!='19'
SELECT* FROMj25_easyblog_post WHERE `id` = '126'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=62' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='126'
SHOWFULLCOLUMNS FROM `j25_easyblog_ratings`
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='126' AND `type`='entry' AND `sessionid`='a469bf6831ad0a983fdf00082ecdcdd8'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='126' 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` = '127'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=62' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='127'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='127' AND `type`='entry' AND `sessionid`='a469bf6831ad0a983fdf00082ecdcdd8'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='127' 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` = '128'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=62' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='128'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='128' AND `type`='entry' AND `sessionid`='a469bf6831ad0a983fdf00082ecdcdd8'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='128' 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` = '129'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=62' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='129'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='129' AND `type`='entry' AND `sessionid`='a469bf6831ad0a983fdf00082ecdcdd8'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='129' 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` = '130'
SELECT `id` FROM `j25_menu` WHERE `link`='index.php?option=com_easyblog&view=blogger&layout=listings&id=62' AND `published`='1' AND (`language`='en-GB' OR `language` = '*' ) LIMIT 1
SELECT a.* FROM `j25_easyblog_post` as a WHERE a.`id` ='130'
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='130' AND `type`='entry' AND `sessionid`='a469bf6831ad0a983fdf00082ecdcdd8'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='130' 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/sisadminstvo?start=5' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/categories/listings/sisadminstvo?start=5' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/categories/listings/sisadminstvo?start=5' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/categories/listings/sisadminstvo?start=5' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/categories/listings/sisadminstvo?start=5' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/categories/listings/sisadminstvo?start=5' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/categories/listings/sisadminstvo?start=5' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/categories/listings/sisadminstvo?start=5' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only=0) ) ) AND published=1 ORDERBY ordering
53 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
32 × SELECT a.rules FROMj25_assetsAS a
32 × SELECT id FROMj25_assets
15 × SELECT* FROMj25_easyblog_category
15 × SELECTCOUNT(1) FROM `j25_easyblog_category`
5 × SELECT* FROMj25_easyblog_post
5 × SELECTCOUNT(1) FROM `j25_easyblog_featured`
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_comment`
5 × SELECT `id` FROM `j25_menu`
5 × SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings`
5 × SELECT* FROM `j25_easyblog_ratings`
5 × SELECT a.* FROM `j25_easyblog_post` as a
3 × SELECT id FROMj25_easyblog_category
2 × SELECT* FROMj25_easyblog_configs
1 × SELECT* FROMj25_easyblog_users
1 × SELECTCOUNT(1) FROM `j25_easyblog_post` AS a
1 × SELECTCOUNT(1) FROM `j25_easyblog_category_acl`
1 × SELECT* FROM `j25_users`
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
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` = '19' inner join `j25_easyblog_team_post` as c on a.`id` = c.`post_id`
1 × SELECT* FROMj25_tagmeta_rules
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 × SELECT* FROMj25_komento_configs
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 a.`id`, a.`title`, a.`alias`, a.`private` from `j25_easyblog_category` as a
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* FROMj25_languages
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 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 `session_id` FROM `j25_session`
1 × select distinct a.`id`, a.`private` from `j25_easyblog_category` as a
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, 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 `id` FROM `j25_easyblog_team`
OTHER Tables:
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_post
1 × SHOWFULLCOLUMNS FROM `j25_users
1 × SHOWFULLCOLUMNS FROM `j25_komento_configs
1 × SHOWFULLCOLUMNS FROM `j25_easyblog_ratings
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'