Joomla! Debug Console
⇒{"__default":{"session":{"counter":1,"timer":{"start":1714242261,"last":1714242261,"now":1714242261},"token":"efaa18db758814a249978ce01bfd960a"},"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.45 MB (22,490,296 Bytes)
164 Queries Logged
SELECT `data`
FROM `p3sae_session`
WHERE `session_id` = '0d82d561e8e6c3d47dbd00c029ce1e1c'DELETE
FROM `p3sae_session`
WHERE `time` < '1714233261'SELECT `session_id`
FROM `p3sae_session`
WHERE `session_id` = '0d82d561e8e6c3d47dbd00c029ce1e1c'
LIMIT 0, 1INSERT INTO `p3sae_session`
(`session_id`, `client_id`, `time`)
VALUES
('0d82d561e8e6c3d47dbd00c029ce1e1c', 0, '1714242261')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` = '18.217.6.114'SELECT `source`,`keepurlparams`
FROM `p3sae_admintools_redirects`
WHERE ((`dest` = 'index.php/blog/tags/big-data') OR (`dest` = 'index.php/blog/tags/big-data') OR ('index.php/blog/tags/big-data' 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`='big-data' OR BINARY `alias`='big-data' )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-04-27 18:24:21'
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-04-27 18:24:21'
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-04-27 18:24:21' , 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-04-27 18:24:21', 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` = '127'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` = '127'
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 0,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` = '127'
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` = '127'
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` = '127'
and (a.`source_type` = 'easyblog.team')SELECT COUNT(1) as `voted`, `uid`
FROM `p3sae_easyblog_ratings`
WHERE `uid` IN (876,831,297,236,168)
AND `type`='entry'
AND `created_by`='0'
AND (`sessionid` = '0d82d561e8e6c3d47dbd00c029ce1e1c' OR `ip` = '18.217.6.114')
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(876,831,297,236,168)
AND `type`='entry'
GROUP BY `uid`
ORDER BY NULLSELECT a.*
FROM `p3sae_easyblog_comment` AS a
WHERE a.`post_id` IN(876,831,297,236,168)
AND a.`published`='1'SELECT a.`post_id`, COUNT(1) AS `count`
FROM `p3sae_easyblog_comment` AS a
WHERE a.`post_id` IN(876,831,297,236,168)
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 ( 876,831,297,236,168)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 ( 876,831,297,236,168)select a.*
from `p3sae_easyblog_revisions` as a
where a.`id` IN ( 7555,7970,387,202,388)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` = 295SHOW FULL COLUMNS
FROM `p3sae_users`SELECT *
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 (876,831,297,236,168)select *
from `p3sae_easyblog_meta`
where `content_id` in (876,831,297,236,168)
and `type` = 'post'SELECT *
FROM `p3sae_easyblog_featured`
WHERE `content_id` IN(876,831,297,236,168)
AND `type`='post'SELECT `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 `group_id`
FROM `p3sae_easyblog_category_fields_groups`
WHERE `category_id`='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`
WHERE b.`category_id`='2'
AND a.`state`='1'
ORDER BY a.`created` DESCSELECT `group_id`
FROM `p3sae_easyblog_category_fields_groups`
WHERE `category_id`='14'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`='14'
AND a.`state`='1'
ORDER BY a.`created` DESCSELECT `group_id`
FROM `p3sae_easyblog_category_fields_groups`
WHERE `category_id`='5'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`='5'
AND a.`state`='1'
ORDER BY a.`created` DESCSELECT `group_id`
FROM `p3sae_easyblog_category_fields_groups`
WHERE `category_id`='13'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`='13'
AND a.`state`='1'
ORDER BY a.`created` DESCSELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '127'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-04-27 18:24:21')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-27 18:24:21')
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 `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 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` = '333'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '5'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` = '876'
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` = '389'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` = '831'
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` = '190'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '191'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` = '297'
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` = '130'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` = '236'
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` = '3'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '29'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` = '168'
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:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzE0MjQyMjYxO3M6NDoibGFzdCI7aToxNzE0MjQyMjYxO3M6Mzoibm93IjtpOjE3MTQyNDIyNjE7fXM6NToidG9rZW4iO3M6MzI6ImVmYWExOGRiNzU4ODE0YTI0OTk3OGNlMDFiZmQ5NjBhIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fX1zOjEwOiJfX2Vhc3libG9nIjtPOjg6InN0ZENsYXNzIjoxOntzOjQ6InNpdGUiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoibWVzc2FnZXMiO047fX19fQ==\";'
, `time` = '1714242261'
WHERE `session_id` = '0d82d561e8e6c3d47dbd00c029ce1e1c'
58 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 `group_id`
FROM `p3sae_easyblog_category_fields_groups`5 × SELECT a.*
FROM `p3sae_easyblog_fields` AS a
INNER JOIN `p3sae_easyblog_category_fields_groups` AS b
ON a.`group_id`= b.`group_id`5 × SELECT a.*
FROM `p3sae_easyblog_comment` a
INNER JOIN p3sae_users AS c
ON a.`created_by` = c.`id`4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions4 × SELECT r.*
FROM p3sae_rereplacer AS r2 × SELECT *
FROM `p3sae_easyblog_acl_group`1 × SELECT a.*
FROM `p3sae_easyblog_comment` AS a1 × 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 AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid`
FROM `p3sae_easyblog_ratings` AS a1 × 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 COUNT(1) as `voted`, `uid`
FROM `p3sae_easyblog_ratings`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 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` = '127'1 × SELECT *
FROM `p3sae_users`1 × SELECT *
FROM `p3sae_easyblog_featured`1 × SELECT `session_id`
FROM `p3sae_session`1 × 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 `group_id`
FROM `p3sae_user_usergroup_map`1 × select *
from `p3sae_easyblog_meta`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 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`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 `g`.`id`,`g`.`title`
FROM `p3sae_usergroups` AS g
INNER JOIN `p3sae_user_usergroup_map` AS m
ON m.group_id = g.id1 × select a.*
from `p3sae_easyblog_revisions` as a1 × 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:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzE0MjQyMjYxO3M6NDoibGFzdCI7aToxNzE0MjQyMjYxO3M6Mzoibm93IjtpOjE3MTQyNDIyNjE7fXM6NToidG9rZW4iO3M6MzI6ImVmYWExOGRiNzU4ODE0YTI0OTk3OGNlMDFiZmQ5NjBhIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fX1zOjEwOiJfX2Vhc3libG9nIjtPOjg6InN0ZENsYXNzIjoxOntzOjQ6InNpdGUiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoibWVzc2FnZXMiO047fX19fQ==\";' , `time` = '1714242261'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 × INSERT INTO `p3sae_session` (`session_id`, `client_id`, `time`)
VALUES ('0d82d561e8e6c3d47dbd00c029ce1e1c', 0, '1714242261'1 × DELETE
FROM `p3sae_easyblog_mailq`1 × DELETE
FROM `p3sae_session`
When you think about Big Data, thoughts typically turn to how businesses use the technology to collect and analyze massive amounts of information for the purpose of making sweet profit. Although, there's much more to Big Data than making money; scientists are using the technology to help save the rainforest.
IT requires several factors in order to function properly. First of all, it can’t exist without information, and this information can’t exist without data. Technology is what creates data so that your company can take advantage of changes in the industry and business environment. It might seem like a lot to take in, but understanding the flow of data is necessary for a business owner. Otherwise, you won’t be able to take advantage of it to jumpstart sales and profitability.
As the calendar fast approaches 2015, the topic of IT budgeting for the new year is a hot topic. It’s the time to decide how much you will spend in comparison to how much you should spend. Budgeting can be a difficult decision, especially if you’re a small business owner with a limited budget. Thankfully, you don’t have to take on this important part of business alone.