Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /var/www/html/jc.infradapt.com/libraries/joomla/html/parameter.php on line 512

Infradapt Blog

This is some blog description about this site

Font size: + –

Bookmark

3 Big Data Solutions for Modern Businesses

Monday, 22 September 2014

John Reilly

Cloud

0 Comment

Big Data is an important part of any business. Without understanding trends in the consumer populace, how can you hope to sell your product? Unfortunately, many companies don't know how to handle big data, and this holds back their earning potential significantly.

What Big Data comes down to is the analysis of mostly unstructured information and data to spot trends in business, or to track individual customer action and develop business intelligence that can be used to take advantage of these trends. This clearly has its advantages for businesses, and it can be a valuable asset in taking on the modern-day workplace. But muddling through a sea of data can be difficult at times. Here are three tips that can help you get your Big Data vessel back on course.

Scrub Your Big Data Clean
Before you can reap the benefits of using Big Data for your business, you first need to take that Big Data and break it down in a process known as "scrubbing." Just try to picture fitting terabytes of information in an Excel spreadsheet - it just doesn't work. The Big Data must be cleaned and formatted to fit in a usable medium.

Some ways that data scientists clean up the Big Data mess is to get rid of incomplete or inconsistent records, as they are rarely useful when compared to the massive amount of other, complete data. Data scientists can also run various algorithms to reduce a data set and make it far easier to handle, though being familiar with the database and query methods can't hurt, either.

Study the Trends Behind the Data
By taking a mathematical approach to your data, you'll be able to analyze it like statistics. By using a mathematical model to map out your big data, you'll notice that there are relationships between particular parts of data. This can be done in many ways by looking specifically at a number of variables that could have affected the results of the data, such as what influences consumers to buy particular products or become repeat customers.

Examining these trends allows your business to take advantage of them and knock the competition out of the water. You'll be able to understand what makes the consumer tick, so to speak, and what they are looking for a product and why.

Use Data Visualization Tools
When it comes to Big Data, you need the right tools to analyze it. You need to work around the models that you have built to house your data in order to help you best visualize what trends are found in the information. There are a lot of tools available for you to use for this purpose, but not all of them will provide you with the quality identification and visualization that you expect for your business's big data.

To make matters more complicated, some of these tools only have niche uses and will be good for one thing, and nothing else. So, how do you know which tools are right for your company? One way is to call Infradapt and discuss the topic of Big Data with our technical professionals. We'll help you analyze your Big Data and identify trends that your business can take advantage of. You'll be miles ahead of your competitors before you know it.

Tags:

About the author

John Reilly

View author's profile More posts from author

John Reilly is Managing Partner at Infradapt, LLC. Prior to joining Infradapt, he was the President of Vital IT Solutions, Inc., where among other roles, he developed a methodology and approach for performing risk and compliance assessments.

Prior to Infradapt, Mr. Reilly founded Vital IT Solutions, Inc., Mr. Reilly worked with Expanets, Inc., as a Senior Converged Account Executive, specializing in VoIP and Security, and a Subject Matter Expert (SME) on HIPAA. His Expanets’ achievements included national Sales awards including Millionaire’s Club and pioneering VoIP deployments for regional clients.

Mr. Reilly also has direct work experience in the banking industry, where he worked in Sales and Management, and in manufacturing, where he worked as an Accountant. John earned his BS in Accounting at Gwynedd-Mercy College, while also studying Negotiation, Decision Making, and Creative Problem Solving. He holds a SANS GIAC security certification and is a member of the Philadelphia Chapter of InfraGard.

Author's recent posts

Tuesday, 19 June 2018 EHR and Other Technologies Moving Healthcare Forward

Friday, 15 June 2018 How Much Time Do You Spend on These Websites?

Wednesday, 13 June 2018 Tip of the Week: How to Improve Your Invoicing Processes

Comments

No comments made yet. Be the first to submit a comment

Joomla! Debug Console

163 Queries Logged

SELECT `data` FROM `p3sae_session` WHERE `session_id` = '53681731fa3ee1a18c4f1cb33d99d56c'
SELECT `session_id` FROM `p3sae_session` WHERE `session_id` = '53681731fa3ee1a18c4f1cb33d99d56c' LIMIT 0, 1
INSERT INTO `p3sae_session` (`session_id`, `client_id`, `time`) VALUES ('53681731fa3ee1a18c4f1cb33d99d56c', 0, '1713495686')
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 = 1
SELECT 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 ordering
SELECT 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` ASC
SELECT `value` FROM `p3sae_admintools_storage` WHERE `key` = 'cparams'
SELECT * FROM `p3sae_admintools_ipautoban` WHERE `ip` = '3.128.79.88'
SELECT `source`,`keepurlparams` FROM `p3sae_admintools_redirects` WHERE ((`dest` = 'index.php/blog/entry/3-big-data-solutions-for-modern-businesses') OR (`dest` = 'index.php/blog/entry/3-big-data-solutions-for-modern-businesses') OR ('index.php/blog/entry/3-big-data-solutions-for-modern-businesses' LIKE `dest`)) AND `published` = '1' ORDER BY `ordering` DESC LIMIT 0, 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 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.lft
SELECT * FROM p3sae_easyblog_configs WHERE `name` = 'config'
SELECT * FROM `p3sae_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC
SELECT * FROM `p3sae_easyblog_acl_group` WHERE `content_id`='1' AND `type`=' group'
SELECT `id` FROM `p3sae_easyblog_post` WHERE `permalink`='3:big-data-solutions-for-modern-businesses'
SELECT `id` FROM `p3sae_easyblog_post` WHERE `permalink`='3-big-data-solutions-for-modern-businesses'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '134'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '390'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='134'
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 ASC
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_id WHERE s.client_id = 0 AND e.enabled = 1
DELETE 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 5
SELECT * FROM `p3sae_easyblog_post` WHERE `publish_up`<='2024-04-19 03:01:27' AND `published`='2' AND `state`='0' ORDER BY `id` LIMIT 5
SELECT id, created_by FROM`p3sae_easyblog_post` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2024-04-19 03:01:27' 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-19 03:01:27' , 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-19 03:01:27', INTERVAL 3 DAY)
SELECT * FROM `p3sae_menu` WHERE `published`='1' AND `link` LIKE 'index.php?option=com_easyblog%'
SELECT a.rules FROM p3sae_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SHOW FULL COLUMNS FROM `p3sae_assets`
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT 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.lft
SELECT * FROM p3sae_easyblog_post WHERE `id` = '134'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '390'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='134'
SELECT COUNT(1) as `voted`, `uid` FROM `p3sae_easyblog_ratings` WHERE `uid` = '134' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '53681731fa3ee1a18c4f1cb33d99d56c' OR `ip` = '3.128.79.88') GROUP BY `uid` ORDER BY NULL
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `p3sae_easyblog_ratings` AS a WHERE a.`uid` IN(134) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `p3sae_easyblog_comment` AS a WHERE a.`post_id` IN(134) AND a.`published`='1'
SELECT a.`post_id`, COUNT(1) AS `count` FROM `p3sae_easyblog_comment` AS a WHERE a.`post_id` IN(134) 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 ( 134)
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 ( 134)
select a.* from `p3sae_easyblog_revisions` as a where a.`id` IN ( 390)
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` = 295
SHOW FULL COLUMNS FROM `p3sae_users`
SELECT * FROM `p3sae_users` WHERE `id` = 295
SELECT `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` = 295
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` where `p`.`post_id` = '134'
select * from `p3sae_easyblog_meta` where `content_id` in (134) and `type` = 'post'
SELECT * FROM p3sae_easyblog_meta WHERE `content_id` = '134' AND `type` = 'post'
SELECT r.* FROM p3sae_rereplacer AS r WHERE r.published = 1 AND (r.area = 'articles') ORDER BY r.ordering, r.id
UPDATE p3sae_easyblog_post SET `hits` = (`hits` + 1) WHERE id = '134'
SELECT COUNT(1) FROM `p3sae_easyblog_featured` WHERE `content_id`='134' AND `type`='post'
SELECT COUNT(1) FROM `p3sae_easyblog_comment` WHERE `post_id`='134' AND `published`='1'
SELECT `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` DESC
SELECT `key`,`value` FROM `p3sae_easyblog_post_assets` WHERE `post_id`='134'
SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `p3sae_easyblog_post` AS a LEFT JOIN `p3sae_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND a.`created_by` = '295' 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 ) ) ) )) AND ( (a.`source_type` = 'easyblog.sitewide') ) ORDER BY a.`created` desc LIMIT 3
SELECT `id` FROM `p3sae_menu` WHERE ( `link` LIKE 'index.php?option=com_easyblog&view=entry&id=134%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=134%' ) AND `published`='1' AND (`language`='en-GB' OR `language`='' OR `language`='*') LIMIT 1
SELECT a.`id`, a.`title` FROM `p3sae_easyblog_post` AS `a` WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND a.`source_type`='easyblog.sitewide' AND a.`created` < '2014-09-22 14:37:21' ORDER BY a.`created` DESC LIMIT 1
SELECT a.`id`, a.`title` FROM `p3sae_easyblog_post` AS `a` WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND a.`source_type`='easyblog.sitewide' AND a.`created` > '2014-09-22 14:37:21' ORDER BY a.`created` ASC LIMIT 1
SELECT * FROM p3sae_easyblog_post WHERE `id` = '133'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '84'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='133'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '135'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '213'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='135'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '135'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '213'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='135'
select `id` FROM `p3sae_easyblog_adsense` where user_id = '295'
SELECT * FROM p3sae_easyblog_adsense WHERE `id` = '2'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT id FROM p3sae_assets WHERE parent_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 id FROM p3sae_assets WHERE parent_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 id FROM p3sae_assets WHERE parent_id = 0
SELECT `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-19 03:01:27') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 03:01:27') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 155 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
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 id FROM p3sae_assets WHERE parent_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 id FROM p3sae_assets WHERE parent_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 id FROM p3sae_assets WHERE parent_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 id FROM p3sae_assets WHERE parent_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 id FROM p3sae_assets WHERE parent_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 id FROM p3sae_assets WHERE parent_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 `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT * FROM p3sae_easyblog_tag WHERE `id` = '127'
SELECT * FROM p3sae_easyblog_tag WHERE `id` = '80'
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 `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_post WHERE `id` = '921'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '7886'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='921'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '925'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '8236'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='925'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '924'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '8237'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='924'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT COUNT(1) FROM (SELECT a.*, (count(b.id) - 1) AS `depth` FROM `p3sae_easyblog_comment` AS a INNER JOIN `p3sae_easyblog_comment` AS b LEFT JOIN `p3sae_users` AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '134' AND b.`post_id` = '134' AND a.`published` = 1 AND b.`published` = 1 AND a.`lft` BETWEEN b.`lft` AND b.`rgt` GROUP BY a.`id`) AS x
SELECT a.*, (count(b.id) - 1) AS `depth` FROM `p3sae_easyblog_comment` AS a INNER JOIN `p3sae_easyblog_comment` AS b LEFT JOIN `p3sae_users` AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '134' AND b.`post_id` = '134' AND a.`published` = 1 AND b.`published` = 1 AND a.`lft` BETWEEN b.`lft` AND b.`rgt` GROUP BY a.`id` ORDER BY a.`lft` asc LIMIT 0,20
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 id FROM p3sae_assets WHERE parent_id = 0
SELECT id FROM p3sae_assets WHERE parent_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 id FROM p3sae_assets WHERE parent_id = 0
SELECT * FROM p3sae_easyblog_post WHERE `id` = '134'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT id FROM p3sae_assets WHERE parent_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 `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.id
SELECT r.* FROM p3sae_rereplacer AS r WHERE r.published = 1 AND (r.area = 'body') ORDER BY r.ordering, r.id
SELECT r.* FROM p3sae_rereplacer AS r WHERE r.published = 1 AND (r.area = 'everywhere') ORDER BY r.ordering, r.id
UPDATE `p3sae_session` SET `data` = 'joomla|s:1448:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzEzNDk1Njg2O3M6NDoibGFzdCI7aToxNzEzNDk1Njg2O3M6Mzoibm93IjtpOjE3MTM0OTU2ODY7fXM6NToidG9rZW4iO3M6MzI6ImU5OTAyMTg1MjUxZTliZmNkMTU0YTdmNWJhMjJlNDQzIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MzI6Ijc5NmIwMWUwNzc5NGQ3YmYyMjcxZGQzMmI4MDc2ZDYyIjtpOjE7fXM6MTA6Il9fZWFzeWJsb2ciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoic2l0ZSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo4OiJtZXNzYWdlcyI7Tjt9fX19\";' , `time` = '1713495687' WHERE `session_id` = '53681731fa3ee1a18c4f1cb33d99d56c'

65 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

48 × SELECT `template` FROM `p3sae_template_styles`
19 × SELECT id FROM p3sae_assets
9 × SELECT * FROM p3sae_easyblog_post
8 × SELECT * FROM p3sae_easyblog_revisions
8 × SELECT * FROM `p3sae_easyblog_meta`
4 × SELECT r.* FROM p3sae_rereplacer AS r
4 × SELECT extension_id AS id, element AS "option", params, enabled FROM p3sae_extensions
3 × SELECT * FROM p3sae_easyblog_tag
2 × SELECT a.`id`, a.`title` FROM `p3sae_easyblog_post` AS `a`
2 × SELECT `id` FROM `p3sae_easyblog_post`
2 × SELECT * FROM `p3sae_easyblog_acl_group`
1 × SELECT * FROM p3sae_easyblog_meta
1 × SELECT COUNT(1) FROM `p3sae_easyblog_featured`
1 × SELECT a.*, (count(b.id) - 1) AS `depth` FROM `p3sae_easyblog_comment` AS a INNER JOIN `p3sae_easyblog_comment` AS b LEFT JOIN `p3sae_users` AS c ON a.`created_by` = c.`id`
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 a.* from `p3sae_easyblog_revisions` as a
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 * FROM `p3sae_users`
1 × SELECT `g`.`id`,`g`.`title` FROM `p3sae_usergroups` AS g INNER JOIN `p3sae_user_usergroup_map` AS m ON m.group_id = g.id
1 × SELECT COUNT(1) FROM `p3sae_easyblog_comment`
1 × SELECT `key`,`value` FROM `p3sae_easyblog_post_assets`
1 × SELECT `id` FROM `p3sae_menu`
1 × select `id` FROM `p3sae_easyblog_adsense`
1 × SELECT * FROM p3sae_easyblog_adsense
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_id
1 × SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `p3sae_easyblog_post` AS a LEFT JOIN `p3sae_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post'
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_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 COUNT(1) FROM (SELECT a.*, (count(b.id) - 1) AS `depth` FROM `p3sae_easyblog_comment` AS a INNER JOIN `p3sae_easyblog_comment` AS b LEFT JOIN `p3sae_users` AS c ON a.`created_by` = c.`id`
1 × SELECT `group_id` FROM `p3sae_easyblog_category_fields_groups`
1 × SELECT COUNT(1) as `voted`, `uid` FROM `p3sae_easyblog_ratings`
1 × SELECT `source`,`keepurlparams` FROM `p3sae_admintools_redirects`
1 × SELECT * FROM `p3sae_admintools_ipautoban`
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 FROM p3sae_menu AS m LEFT JOIN p3sae_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM p3sae_easyblog_configs
1 × SELECT * FROM `p3sae_easyblog_acl`
1 × SELECT `value` FROM `p3sae_admintools_storage`
1 × SELECT `query` FROM `p3sae_admintools_wafexceptions`
1 × SELECT `session_id` 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.rgt
1 × SELECT id, rules FROM `p3sae_viewlevels
1 × SELECT folder AS type, element AS name, params FROM p3sae_extensions
1 × SELECT * FROM p3sae_languages
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_id
1 × SELECT `data` FROM `p3sae_session`
1 × SELECT b.rules FROM p3sae_assets AS a LEFT JOIN p3sae_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `p3sae_easyblog_ratings` AS a
1 × SELECT a.* FROM `p3sae_easyblog_comment` AS a
1 × SELECT a.`post_id`, COUNT(1) AS `count` FROM `p3sae_easyblog_comment` AS a
1 × SELECT a.rules FROM p3sae_assets AS a
1 × SELECT * FROM `p3sae_menu`
1 × SELECT `id` FROM `p3sae_easyblog_mailq`
1 × SELECT * FROM `p3sae_easyblog_post`
1 × SELECT id, created_by FROM`p3sae_easyblog_post`
1 × SELECT * FROM `p3sae_easyblog_uploader_tmp`
1 × 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`

OTHER Tables:

1 × UPDATE p3sae_easyblog_post SET `hits` = (`hits` + 1)
1 × UPDATE `p3sae_session` SET `data` = 'joomla|s:1448:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzEzNDk1Njg2O3M6NDoibGFzdCI7aToxNzEzNDk1Njg2O3M6Mzoibm93IjtpOjE3MTM0OTU2ODY7fXM6NToidG9rZW4iO3M6MzI6ImU5OTAyMTg1MjUxZTliZmNkMTU0YTdmNWJhMjJlNDQzIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MzI6Ijc5NmIwMWUwNzc5NGQ3YmYyMjcxZGQzMmI4MDc2ZDYyIjtpOjE7fXM6MTA6Il9fZWFzeWJsb2ciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoic2l0ZSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo4OiJtZXNzYWdlcyI7Tjt9fX19\";' , `time` = '1713495687'
1 × SHOW FULL COLUMNS FROM `p3sae_users
1 × SHOW FULL COLUMNS FROM `p3sae_assets
1 × DELETE FROM `p3sae_easyblog_mailq`
1 × 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 ('53681731fa3ee1a18c4f1cb33d99d56c', 0, '1713495686'

Infradapt Blog

3 Big Data Solutions for Modern Businesses

About the author

John Reilly

Author's recent posts

Comments

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

163 Queries Logged

65 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: