Joomla! Debug Console
⇒{"__default":{"session":{"counter":1,"timer":{"start":1714727320,"last":1714727320,"now":1714727320},"token":"820e520d50098c473c86e41a709ad9d4"},"registry":{},"user":{"id":0,"name":null,"username":null,"email":null,"password":null,"password_clear":"","usertype":null,"block":null,"sendEmail":0,"registerDate":null,"lastvisitDate":null,"activation":null,"params":null,"groups":[],"guest":1,"lastResetTime":null,"resetCount":null,"aid":0}},"__easyblog":{"site":{"messages":null}}}
21.01 MB (22,030,504 Bytes)
160 Queries Logged
SELECT `data`
FROM `p3sae_session`
WHERE `session_id` = 'ec4b259b68667e4d63efa82d2a2b48b8'SELECT `session_id`
FROM `p3sae_session`
WHERE `session_id` = 'ec4b259b68667e4d63efa82d2a2b48b8'
LIMIT 0, 1INSERT INTO `p3sae_session`
(`session_id`, `client_id`, `time`)
VALUES
('ec4b259b68667e4d63efa82d2a2b48b8', 0, '1714727320')SELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT b.id
FROM p3sae_usergroups AS a
LEFT JOIN p3sae_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT id, rules
FROM `p3sae_viewlevels`SELECT folder AS type, element AS name, params
FROM p3sae_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT `query`
FROM `p3sae_admintools_wafexceptions`
WHERE (`option` IS NULL OR `option` = '')
AND (`view` IS NULL OR `view` = '')
GROUP BY `query`
ORDER BY `query` ASCSELECT `value`
FROM `p3sae_admintools_storage`
WHERE `key` = 'cparams'SELECT *
FROM `p3sae_admintools_ipautoban`
WHERE `ip` = '3.138.179.119'SELECT `source`,`keepurlparams`
FROM `p3sae_admintools_redirects`
WHERE ((`dest` = 'index.php/blog/tags/security') OR (`dest` = 'index.php/blog/tags/security?start=130') OR ('index.php/blog/tags/security?start=130' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 0, 1SELECT 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
FROM p3sae_menu AS m
LEFT JOIN p3sae_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSELECT *
FROM p3sae_easyblog_configs
WHERE `name` = 'config'SELECT *
FROM `p3sae_easyblog_tag`
WHERE ( BINARY `title`='security' OR BINARY `alias`='security' )SELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions
WHERE `type` = 'component'
AND `element` = 'com_rereplacer'SELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions
WHERE `type` = 'component'
AND `element` = 'com_easyblog'SELECT *
FROM p3sae_languages
WHERE published=1
ORDER BY ordering ASCSELECT id, home, template, s.params
FROM p3sae_template_styles as s
LEFT JOIN p3sae_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 = 1DELETE
FROM `p3sae_easyblog_mailq`
WHERE `status`='1'
AND DATEDIFF(NOW(), `created`) >='7'SELECT `id`
FROM `p3sae_easyblog_mailq`
WHERE `status`='0'
ORDER BY `created` ASC
LIMIT 5SELECT *
FROM `p3sae_easyblog_post`
WHERE `publish_up`<='2024-05-03 09:08:40'
AND `published`='2'
AND `state`='0'
ORDER BY `id`
LIMIT 5SELECT id, created_by
FROM`p3sae_easyblog_post`
WHERE `publish_down` > `publish_up`
AND `publish_down` <= '2024-05-03 09:08:40'
AND `publish_down` != '0000-00-00 00:00:00'
AND `published` = '1'
AND `state` = '0'SELECT *
FROM `p3sae_easyblog_uploader_tmp`
WHERE `created` <= DATE_SUB('2024-05-03 09:08:40' , INTERVAL 120 MINUTE)delete a, b
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_revisions` as b
on a.`id` = b.`post_id`
where a.`published` = '9'
and a.`created` <= DATE_SUB('2024-05-03 09:08:40', INTERVAL 3 DAY)SELECT *
FROM `p3sae_menu`
WHERE `published`='1'
AND `link` LIKE 'index.php?option=com_easyblog%'SELECT *
FROM `p3sae_easyblog_acl`
WHERE `published`='1'
ORDER BY `id` ASCSELECT *
FROM `p3sae_easyblog_acl_group`
WHERE `content_id`='1'
AND `type`='
group'SELECT a.rules
FROM p3sae_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSHOW FULL COLUMNS
FROM `p3sae_assets`SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT b.rules
FROM p3sae_assets AS a
LEFT JOIN p3sae_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '34'SELECT *
FROM p3sae_easyblog_meta
WHERE `content_id` = '3'
AND `type` = 'view'SELECT b.*
FROM `p3sae_easyblog_post_tag` AS a
INNER JOIN `p3sae_easyblog_post` AS b
ON a.post_id=b.id
WHERE a.`tag_id` = '34'
AND b.`published` = '1'
AND b.`state`='0'
AND ( (b.`source_type` = 'easyblog.sitewide') )
AND b.`access` = '0'
AND (1 <= (select count(1)
from `p3sae_easyblog_post_category` AS acp
INNER JOIN `p3sae_easyblog_category` as cat
on acp.`category_id` = cat.`id`
where acp.`post_id` = b.`id`
and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1)
and (0 > 0) ) OR ( (cat.`private` = 2)
and ( (select count(1)
from `p3sae_easyblog_category_acl` as cacl
where cacl.`category_id` = cat.id
and cacl.`acl_id` = 1
and cacl.`content_id` in (1)) > 0 ) ) ) ))
ORDER BY b.`created` desc
LIMIT 130,5SELECT COUNT(1)
FROM (SELECT b.*
FROM `p3sae_easyblog_post_tag` AS a
INNER JOIN `p3sae_easyblog_post` AS b
ON a.post_id=b.id
WHERE a.`tag_id` = '34'
AND b.`published` = '1'
AND b.`state`='0'
AND ( (b.`source_type` = 'easyblog.sitewide') )
AND b.`access` = '0'
AND (1 <= (select count(1)
from `p3sae_easyblog_post_category` AS acp
INNER JOIN `p3sae_easyblog_category` as cat
on acp.`category_id` = cat.`id`
where acp.`post_id` = b.`id`
and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1)
and (0 > 0) ) OR ( (cat.`private` = 2)
and ( (select count(1)
from `p3sae_easyblog_category_acl` as cacl
where cacl.`category_id` = cat.id
and cacl.`acl_id` = 1
and cacl.`content_id` in (1)) > 0 ) ) ) ))
ORDER BY b.`created` desc) as xselect count(1)
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`post_id`
and b.`tag_id` = '34'
where a.`access` = '1'
AND (1 <= (select count(1)
from `p3sae_easyblog_post_category` AS acp
INNER JOIN `p3sae_easyblog_category` as cat
on acp.`category_id` = cat.`id`
where acp.`post_id` = a.`id`
and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1)
and (0 > 0) ) OR ( (cat.`private` = 2)
and ( (select count(1)
from `p3sae_easyblog_category_acl` as cacl
where cacl.`category_id` = cat.id
and cacl.`acl_id` = 1
and cacl.`content_id` in (1)) > 0 ) ) ) ))select count(1)
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`post_id`
where b.`tag_id` = '34'
and (a.`source_type` = 'easyblog.team')SELECT COUNT(1) as `voted`, `uid`
FROM `p3sae_easyblog_ratings`
WHERE `uid` IN (68,67,66,63,59)
AND `type`='entry'
AND `created_by`='0'
AND (`sessionid` = 'ec4b259b68667e4d63efa82d2a2b48b8' OR `ip` = '3.138.179.119')
GROUP BY `uid`
ORDER BY NULLSELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid`
FROM `p3sae_easyblog_ratings` AS a
WHERE a.`uid` IN(68,67,66,63,59)
AND `type`='entry'
GROUP BY `uid`
ORDER BY NULLSELECT a.*
FROM `p3sae_easyblog_comment` AS a
WHERE a.`post_id` IN(68,67,66,63,59)
AND a.`published`='1'SELECT a.`post_id`, COUNT(1) AS `count`
FROM `p3sae_easyblog_comment` AS a
WHERE a.`post_id` IN(68,67,66,63,59)
AND a.`published`='1'
GROUP BY a.`post_id`select a.*, b.`post_id`, b.`primary`
from `p3sae_easyblog_category` as a
inner join `p3sae_easyblog_post_category` as b
on a.`id` = b.`category_id`
where b.`post_id` IN ( 68,67,66,63,59)select a.*, b.`post_id`
from `p3sae_easyblog_tag` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`tag_id`
where b.`post_id` IN ( 68,67,66,63,59)select a.*
from `p3sae_easyblog_revisions` as a
where a.`id` IN ( 428,398,15,128,386)select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`
from `p3sae_users` as u
left join `p3sae_easyblog_users` as e
ON u.`id` = e.`id`
where u.`id` IN (284,295)SHOW FULL COLUMNS
FROM `p3sae_users`SELECT *
FROM `p3sae_users`
WHERE `id` = 284SELECT `g`.`id`,`g`.`title`
FROM `p3sae_usergroups` AS g
INNER JOIN `p3sae_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 284SELECT *
FROM `p3sae_users`
WHERE `id` = 295SELECT `g`.`id`,`g`.`title`
FROM `p3sae_usergroups` AS g
INNER JOIN `p3sae_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 295select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value`
from `p3sae_easyblog_category_fields_groups` as a
inner join `p3sae_easyblog_post_category` as p
on `a`.`category_id` = `p`.`category_id`
inner join `p3sae_easyblog_fields_groups` as fg
on `a`.`group_id` = `fg`.`id`
inner join `p3sae_easyblog_fields` as f
on `fg`.`id` = `f`.`group_id`
left join `p3sae_easyblog_fields_values` as fv
on `fv`.`field_id` = `f`.`id`
and `fv`.`post_id` = `p`.`post_id`
where p.post_id IN (68,67,66,63,59)select *
from `p3sae_easyblog_meta`
where `content_id` in (68,67,66,63,59)
and `type` = 'post'SELECT *
FROM `p3sae_easyblog_featured`
WHERE `content_id` IN(68,67,66,63,59)
AND `type`='post'select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`
from `p3sae_users` as u
left join `p3sae_easyblog_users` as e
ON u.`id` = e.`id`
where u.`id` = 296SELECT `group_id`
FROM `p3sae_easyblog_category_fields_groups`
WHERE `category_id`='3'SELECT a.*
FROM `p3sae_easyblog_fields` AS a
INNER JOIN `p3sae_easyblog_category_fields_groups` AS b
ON a.`group_id`= b.`group_id`
WHERE b.`category_id`='3'
AND a.`state`='1'
ORDER BY a.`created` DESCSELECT `group_id`
FROM `p3sae_easyblog_category_fields_groups`
WHERE `category_id`='9'SELECT a.*
FROM `p3sae_easyblog_fields` AS a
INNER JOIN `p3sae_easyblog_category_fields_groups` AS b
ON a.`group_id`= b.`group_id`
WHERE b.`category_id`='9'
AND a.`state`='1'
ORDER BY a.`created` DESCSELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '34'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM p3sae_modules AS m
LEFT JOIN p3sae_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN p3sae_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-03 09:08:40')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-03 09:08:40')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 155 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT r.*
FROM p3sae_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'articles')
ORDER BY r.ordering, r.idSELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '41'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '82'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT a.*
FROM `p3sae_easyblog_comment` a
INNER JOIN p3sae_users AS c
ON a.`created_by` = c.`id`
WHERE a.`post_id` = '68'
AND a.`published` = 1
ORDER BY a.`lft` asc
LIMIT 3SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `group_id`
FROM `p3sae_user_usergroup_map`
WHERE `user_id` = '295'SELECT *
FROM `p3sae_easyblog_acl_group`
WHERE `content_id` IN (2, 3)
AND `type`='
group'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '80'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '81'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT a.*
FROM `p3sae_easyblog_comment` a
INNER JOIN p3sae_users AS c
ON a.`created_by` = c.`id`
WHERE a.`post_id` = '67'
AND a.`published` = 1
ORDER BY a.`lft` asc
LIMIT 3SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '62'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '79'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT a.*
FROM `p3sae_easyblog_comment` a
INNER JOIN p3sae_users AS c
ON a.`created_by` = c.`id`
WHERE a.`post_id` = '66'
AND a.`published` = 1
ORDER BY a.`lft` asc
LIMIT 3SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '75'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT a.*
FROM `p3sae_easyblog_comment` a
INNER JOIN p3sae_users AS c
ON a.`created_by` = c.`id`
WHERE a.`post_id` = '63'
AND a.`published` = 1
ORDER BY a.`lft` asc
LIMIT 3SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '33'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '66'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT a.*
FROM `p3sae_easyblog_comment` a
INNER JOIN p3sae_users AS c
ON a.`created_by` = c.`id`
WHERE a.`post_id` = '59'
AND a.`published` = 1
ORDER BY a.`lft` asc
LIMIT 3SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT r.*
FROM p3sae_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'component')
ORDER BY r.ordering, r.idSELECT r.*
FROM p3sae_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'body')
ORDER BY r.ordering, r.idSELECT r.*
FROM p3sae_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'everywhere')
ORDER BY r.ordering, r.idUPDATE `p3sae_session`
SET `data` = 'joomla|s:1392:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzE0NzI3MzIwO3M6NDoibGFzdCI7aToxNzE0NzI3MzIwO3M6Mzoibm93IjtpOjE3MTQ3MjczMjA7fXM6NToidG9rZW4iO3M6MzI6IjgyMGU1MjBkNTAwOThjNDczYzg2ZTQxYTcwOWFkOWQ0Ijt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fX1zOjEwOiJfX2Vhc3libG9nIjtPOjg6InN0ZENsYXNzIjoxOntzOjQ6InNpdGUiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoibWVzc2FnZXMiO047fX19fQ==\";'
, `time` = '1714727320'
WHERE `session_id` = 'ec4b259b68667e4d63efa82d2a2b48b8'
57 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
62 × SELECT `template`
FROM `p3sae_template_styles`17 × SELECT id
FROM p3sae_assets11 × SELECT *
FROM p3sae_easyblog_tag5 × SELECT a.*
FROM `p3sae_easyblog_comment` a
INNER JOIN p3sae_users AS c
ON a.`created_by` = c.`id`4 × SELECT r.*
FROM p3sae_rereplacer AS r4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions2 × SELECT `g`.`id`,`g`.`title`
FROM `p3sae_usergroups` AS g
INNER JOIN `p3sae_user_usergroup_map` AS m
ON m.group_id = g.id2 × select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`
from `p3sae_users` as u
left join `p3sae_easyblog_users` as e
ON u.`id` = e.`id`2 × SELECT *
FROM `p3sae_easyblog_acl_group`2 × SELECT `group_id`
FROM `p3sae_easyblog_category_fields_groups`2 × SELECT *
FROM `p3sae_users`2 × SELECT a.*
FROM `p3sae_easyblog_fields` AS a
INNER JOIN `p3sae_easyblog_category_fields_groups` AS b
ON a.`group_id`= b.`group_id`1 × SELECT `group_id`
FROM `p3sae_user_usergroup_map`1 × SELECT a.*
FROM `p3sae_easyblog_comment` AS a1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM p3sae_modules AS m
LEFT JOIN p3sae_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN p3sae_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid`
FROM `p3sae_easyblog_ratings` AS a1 × SELECT COUNT(1) as `voted`, `uid`
FROM `p3sae_easyblog_ratings`1 × select count(1)
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`post_id`
and b.`tag_id` = '34'1 × select count(1)
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`post_id`1 × SELECT a.`post_id`, COUNT(1) AS `count`
FROM `p3sae_easyblog_comment` AS a1 × select a.*, b.`post_id`, b.`primary`
from `p3sae_easyblog_category` as a
inner join `p3sae_easyblog_post_category` as b
on a.`id` = b.`category_id`1 × select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value`
from `p3sae_easyblog_category_fields_groups` as a
inner join `p3sae_easyblog_post_category` as p
on `a`.`category_id` = `p`.`category_id`
inner join `p3sae_easyblog_fields_groups` as fg
on `a`.`group_id` = `fg`.`id`
inner join `p3sae_easyblog_fields` as f
on `fg`.`id` = `f`.`group_id`
left join `p3sae_easyblog_fields_values` as fv
on `fv`.`field_id` = `f`.`id`
and `fv`.`post_id` = `p`.`post_id`1 × select *
from `p3sae_easyblog_meta`1 × SELECT COUNT(1)
FROM (SELECT b.*
FROM `p3sae_easyblog_post_tag` AS a
INNER JOIN `p3sae_easyblog_post` AS b
ON a.post_id=b.id1 × SELECT `session_id`
FROM `p3sae_session`1 × select a.*, b.`post_id`
from `p3sae_easyblog_tag` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`tag_id`1 × select a.*
from `p3sae_easyblog_revisions` as a1 × SELECT *
FROM `p3sae_easyblog_featured`1 × SELECT *
FROM p3sae_easyblog_meta1 × 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
FROM p3sae_menu AS m
LEFT JOIN p3sae_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM p3sae_easyblog_configs1 × SELECT *
FROM `p3sae_easyblog_tag`1 × SELECT *
FROM p3sae_languages1 × SELECT `source`,`keepurlparams`
FROM `p3sae_admintools_redirects`1 × SELECT *
FROM `p3sae_admintools_ipautoban`1 × SELECT id, rules
FROM `p3sae_viewlevels1 × SELECT folder AS type, element AS name, params
FROM p3sae_extensions1 × SELECT `query`
FROM `p3sae_admintools_wafexceptions`1 × SELECT `value`
FROM `p3sae_admintools_storage`1 × SELECT id, home, template, s.params
FROM p3sae_template_styles as s
LEFT JOIN p3sae_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `id`
FROM `p3sae_easyblog_mailq`1 × SELECT a.rules
FROM p3sae_assets AS a1 × SELECT b.rules
FROM p3sae_assets AS a
LEFT JOIN p3sae_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `data`
FROM `p3sae_session`1 × SELECT b.id
FROM p3sae_usergroups AS a
LEFT JOIN p3sae_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM `p3sae_easyblog_acl`1 × SELECT *
FROM `p3sae_menu`1 × SELECT *
FROM `p3sae_easyblog_post`1 × SELECT id, created_by
FROM`p3sae_easyblog_post`1 × SELECT *
FROM `p3sae_easyblog_uploader_tmp`1 × SELECT b.*
FROM `p3sae_easyblog_post_tag` AS a
INNER JOIN `p3sae_easyblog_post` AS b
ON a.post_id=b.id
OTHER Tables:
1 × SHOW FULL COLUMNS
FROM `p3sae_users1 × UPDATE `p3sae_session`
SET `data` = 'joomla|s:1392:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzE0NzI3MzIwO3M6NDoibGFzdCI7aToxNzE0NzI3MzIwO3M6Mzoibm93IjtpOjE3MTQ3MjczMjA7fXM6NToidG9rZW4iO3M6MzI6IjgyMGU1MjBkNTAwOThjNDczYzg2ZTQxYTcwOWFkOWQ0Ijt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fX1zOjEwOiJfX2Vhc3libG9nIjtPOjg6InN0ZENsYXNzIjoxOntzOjQ6InNpdGUiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoibWVzc2FnZXMiO047fX19fQ==\";' , `time` = '1714727320'1 × SHOW FULL COLUMNS
FROM `p3sae_assets1 × delete a, b
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_revisions` as b
on a.`id` = b.`post_id`1 × DELETE
FROM `p3sae_easyblog_mailq`1 × INSERT INTO `p3sae_session` (`session_id`, `client_id`, `time`)
VALUES ('ec4b259b68667e4d63efa82d2a2b48b8', 0, '1714727320'
Firewalls are the first thing companies think of when it comes to data security. What is the last security risk on an organization's mind? Your most tech-savvy employee. If someone were to "get to" the employee overseeing your network, they would be able to do some serious damage. What are you doing to protect your data from the employees you trust the most?
Many websites around the world are still suffering from the nasty little bug called Heartbleed that we covered last month. This prompted over 30,000 TLS/SSL certificates to be revoked and reissued, but many of them were reissued with the same keys. If this was going to happen, why revoke and reissue them in the first place? They're still just as vulnerable as before, since Heartbleed could have leaked those same keys weeks ago.
eBay issued an official declaration on Wednesday, May 21, 2014 that one of its databases had been hacked. The worst part? This database, which housed users' passwords, was compromised. But, there is a silver lining to all of this - no information has been stolen.
Think your data is safe when you lock your phone? Thanks to a newly discovered vulnerability with iOS 7.1.1 (the latest version), a hacker has the ability to bypass your lock screen and easily access your contact information.
It's no secret that the Internet is full of dangerous activity. Too many people think their networks are safe without any kind of protection. We don't mean to say that the Internet isn't safe, but that it's only as safe as you make it for yourself. In order to keep your small business safe, you should implement protective software, like a firewall. A firewall can help keep your company safe from online threats, and believe us when we say that a little bit of protection goes a long way.