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 Meraki Systems Manager. Зачастую, основной заработок многих компаний зависит непосредственно от качества работы мобильных пользователей. К примеру фармацевтические компании зарабатывают тем, что их медицинские представители разъезжают по врачам и аптекам, и рассказывают какие хорошие препараты производит именно их фармацевтическая компания. Аналогично страховые агенты всегда готовы приехать к вам домой, хоть ночью, и застраховать что-нибудь типа автомобиля. Ну или какой-нибудь системный интегратор всегда готов отправить к вам в офис делегацию специалистов, который расскажут как здорово они могут продать вам серверов, софта и сетевого оборудование, да при этом еще и настроят за «символические» деньги. Совершенно естественно, что всем этим продавцам может потребоваться показать вам какую-нибудь презентацию, таблицы с цифрами, веселую картинку и прочую «полезную» информацию. Опция backpack в системе Cisco Meraki Systems Manager как раз и призвана помочь передать нужные документы этим специалистам на их мобильные устройства. Если интересно как, это статья для вас.
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
Продолжаем цикл статей по работе с системой Mobile Device Management под названием Cisco Meraki Systems Manager. В предыдущих постах мы зарегистрировали аккаунт в этой системе, прикрепили к системе управление мобильное устройство, а так же разобрали вопрос централизованной установки приложений. Прочитать эти статьи можно по ссылкам ниже:
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 Meraki Systems Manager, а так же подключили к этой системе одно мобильное устройство (iPad). Почитать эти статьи можно по следующим ссылкам:
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
В предыдущей статье (https://networkdoc.ru/entry/mobajl/mdm-cisco-meraki-systems-manager-chast1-sozdanie-akkaunta) я написал о такой системе как Cisco Meraki Systems Manager и описал как зарегистрировать в ней свой аккаунта, а так же прикрепить к ней AppleID. В этой статье я собираюсь описать как добавлять новые мобильные устройства, которыми мы будем в последствии управлять. Мы с вами прикрепим к нашей системе управления iPad и отобразим его характеристики, установленные приложения, а так же определим его расположение на google map.
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
Для начала немного слов о том, что такое MDM (Mobile Device Management) и зачем вообще это нужно. Мобильные устройства не так давно просто ворвались в нашу жизнь и сейчас практически у каждого человека есть какой-нибудь iPad, Nexus ну или хотя бы самый «задрипаный» телефон под управлением ОС Android. Планшет или до боли умный телефон есть практически у каждого и что бы в этом убедиться достаточно просто разок проехаться в Московском метро. А главное, что интересно, это то, что мобильные устройства начинают активно прорываться в корпоративный сегмент, и многие компании всерьез задумываются о том, что бы активно использовать мобильные устройства в работе, наравне с привычными всем портативными компьютерами. При этом всплывают такие резонные вопросы как обеспечить информационную безопасность при пользовании такого рода устройствами, как обеспечить доступ к контенту, к корпоративной почте, как контролировать мобильные устройства, как осуществлять техническую поддержку в конце концов. К тому же совершенно естественным в данной ситуации, является желание делать это все централизованно. Система Cisco Meraki Systems Manager одна из систем, которая призвана решать все эти задачи. Если вам интересна данная тема, то эта статья для вас.
SELECT `session_id`
FROM `j25_session`
WHERE `session_id` = '81514af8dda60aac74f6228f6ff40f0e' 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` = 'ciscomerakimdm-lp13' OR `title` = 'ciscomerakimdm lp13' OR `alias` = 'ciscomerakimdm-lp13') 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-10 07:51:14' 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 07:51:14' 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` = '80'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='ciscomerakimdm-lp13' AND `id`!='80'
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 = '80' 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 = '80' 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 = '80' 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` = '80' 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` = '525' 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` = '525' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='525' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '525' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '519' 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` = '519' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='519' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '519' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '517' 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` = '517' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='517' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '517' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '515' 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` = '515' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='515' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '515' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECTCOUNT(1) FROM `j25_easyblog_featured` WHERE `content_id` = '514' 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` = '514' AND a.`published` = '1' ORDERBY a.`title` ASC
SELECTCOUNT(1) FROM `j25_easyblog_comment` WHERE `post_id`='514' AND `published` = '1'
SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '514' AND a.`published` = 1 ORDERBY a.`rgt` desc LIMIT 3
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '25'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '25'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '25'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '25'
SELECT `title`, `id` FROM `j25_easyblog_category` WHERE `id` = '25'
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` = '80'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='ciscomerakimdm-lp13' AND `id`!='80'
SELECT* FROMj25_easyblog_post WHERE `id` = '525'
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` ='525'
SHOWFULLCOLUMNS FROM `j25_easyblog_category`
SELECT* FROMj25_easyblog_category WHERE `id` = '25'
SELECTCOUNT(1) FROM `j25_easyblog_category` WHERE `alias`='mobajl' AND `id`!='25'
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` = '80'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='ciscomerakimdm-lp13' AND `id`!='80'
SELECT* FROMj25_easyblog_tag WHERE `id` = '81'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='mobajl' AND `id`!='81'
SHOWFULLCOLUMNS FROM `j25_easyblog_ratings`
SELECT* FROM `j25_easyblog_ratings` WHERE `created_by`='0' AND `uid`='525' AND `type`='entry' AND `sessionid`='81514af8dda60aac74f6228f6ff40f0e'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='525' 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` = '519'
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` ='519'
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`='519' AND `type`='entry' AND `sessionid`='81514af8dda60aac74f6228f6ff40f0e'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='519' 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` = '517'
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` ='517'
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`='517' AND `type`='entry' AND `sessionid`='81514af8dda60aac74f6228f6ff40f0e'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='517' 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` = '515'
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` ='515'
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`='515' AND `type`='entry' AND `sessionid`='81514af8dda60aac74f6228f6ff40f0e'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='515' 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` = '514'
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` ='514'
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`='514' AND `type`='entry' AND `sessionid`='81514af8dda60aac74f6228f6ff40f0e'
SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings` WHERE `uid`='514' 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` = '80'
SELECTCOUNT(1) FROM `j25_easyblog_tag` WHERE `alias`='ciscomerakimdm-lp13' AND `id`!='80'
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/ciscomerakimdm-lp13' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/easyblog/tags/tag/ciscomerakimdm-lp13' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/ciscomerakimdm-lp13' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/ciscomerakimdm-lp13' REGEXPBINARY url)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/easyblog/tags/tag/ciscomerakimdm-lp13' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/easyblog/tags/tag/ciscomerakimdm-lp13' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/ciscomerakimdm-lp13' REGEXP url)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://networkdoc.ru/easyblog/tags/tag/ciscomerakimdm-lp13' 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:
36 × SELECT a.rules FROMj25_assetsAS a
36 × SELECT id FROMj25_assets
6 × SELECT* FROMj25_easyblog_tag
6 × SELECTCOUNT(1) FROM `j25_easyblog_tag`
5 × SELECTCOUNT(1) FROM `j25_easyblog_comment`
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 × SELECT a.* FROM `j25_easyblog_comment` a INNERJOINj25_usersAS c ON a.`created_by` = c.`id`
5 × SELECT* FROM `j25_easyblog_ratings`
5 × SELECTAVG(value) AS ratings, COUNT(1) AS total FROM `j25_easyblog_ratings`
5 × SELECT `title`, `id` FROM `j25_easyblog_category`
5 × SELECT a.* FROM `j25_easyblog_post` as a
5 × SELECT `id` FROM `j25_menu`
5 × SELECT* FROMj25_easyblog_post
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 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 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* FROM `j25_easyblog_tag`
1 × SELECT `id` FROM `j25_easyblog_mailq`
1 × SELECT* FROM `j25_easyblog_post`
1 × SELECT folder AS type, element AS name, params FROMj25_extensions
1 × SELECT* FROMj25_easyblog_category
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 × SELECTCOUNT(1) FROM `j25_easyblog_category`
1 × SELECT b.rules FROMj25_assetsAS a LEFTJOINj25_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
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
1 × SELECT `session_id` FROM `j25_session`
1 × select `id` FROM `j25_easyblog_team`
1 × SELECT id, keywords, description, indexing FROM `j25_easyblog_meta`
1 × SELECT* FROM `j25_easyblog_acl`
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` = '80'
1 × SELECTCOUNT(*) FROM `j25_easyblog_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* FROM `j25_users`
1 × SELECT* FROMj25_easyblog_users
1 × SELECT* FROM `j25_easyblog_acl_group`
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'