Infradapt Blog

This is some blog description about this site

Sports

Subscribe to this list via RSS

Sports Are a Training Ground for Smart Technology

John Reilly

Friday, 01 June 2018

Infradapt Blog

Sports Are a Training Ground for Smart Technology

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

Smart technology and the whole Internet of Things revolution has been underway now for some time. One vertical market that has embraced this shift was that of sports and fitness. Of course, you’ve heard of (and possibly own) a fitness band that is designed to track your steps, your vitals, and some other things to allow you to be the best version of yourself. This technology has been around for years and, while useful, isn’t transforming the face of sports like the technology you are seeing being introduced today. Today, we’ll take a look at how the IoT is transforming the sporting world.

The Games
Sports are important throughout the world. With so many people claiming to be sports fans, and so much money spent on viewing sporting events annually, it stands to reason that one of the biggest technology trends in history hit the sports world (and athletics as a whole). To this point the Internet of Things has been a conceptual strategy in some industries. Not in sports, where athletes, teams, and leagues are using sensors and smart products to help quantify and track elements of an athlete's performance, while using the immense amount of data that’s produced to formulate plans to make sports safer. The analysis of this data has become big business, and is, in some cases, transforming the games themselves

The National Pastime
One example is happening in baseball. Several years ago, the use of data began to change the way teams value players. Called sabermetrics, it took all the raw data that was collected from the game (and there is an awful large amount of data in every game), plugged it into algorithms that were uses to compare every player to every other player. This provided a map of how to put together a winning team for fewer dollars. Later named “Moneyball”, the strategy began to make its way through the major leagues, into the minor leagues, and beyond. With so much impetus put on the numbers, a lot of teams started finding new algorithmic approaches to try to get an advantage.

When the IoT was in its infancy, the shift toward analysis has only quickened the pace of innovations. Today, so much raw data is taken from a baseball game that all 30 major league teams have come to employ huge analytic departments to sort through and quantify the data. This has not just been used to determine the acquisition (and value) of players, it has been used to determine lineup configuration, defense configuration, pitcher effectiveness, and all in the name of situational advantage.

Once general managers, managers, and players knew what they were looking for, they began to use the newest technologies to track specific parts of a player performance. One way that IoT is working to improve player performance is by introducing technologies like SwingTracker that attaches to the bat and captures a player’s swing in 10,000 separate data points per second, and the mThrow wearable sleeve that pitchers can wear on their arms to measure pitching mechanics. Since millions of dollars are spent on contracts for players, teams are trying to be as diligent as possible as to not waste available capital. Beyond the dollars and cents, these IoT wearables not only help athletes fine-tune their craft, they do it in a way that helps them avoid injury.

Other major sporting leagues including the NFL, MLS, Premier League, NHL, NBA, and PGA all have incorporated IoT devices into the training and reporting strategies trying to both enhance the quality of their product while protecting (as much as they can) their resources (their players).

The Athletes
For the athletes themselves, the IoT has a myriad of potential uses. Today there are smart clothes, including socks, shoes, fabrics, and more designed to help the track and improve performance. Here are some examples of IoT devices that are helping individuals excel in their athletic endeavors:

The connected basketball - Ball handling and shooting are two of the most important offensive skills for a basketball player and there are now basketballs on the on the market that can help you improve your ball handling and shooting by incorporating sensors into the ball itself. The corresponding app presents you options to measure your dribbling and shooting.
The connected hockey stick - Using tape sensors, a hockey stick can help players measure their shot speed, their blade angle, and a player’s stick work.
The connected golf club - Golf has, somewhat ironically, been the one sport that has embraced technology most over the past 50 years. So, it is not really a big surprise that the IoT has already found its way into both clubs, and their grips. Today, there are many options for the tech-savvy golfer to improve their game using IoT technology.
Radio Frequency Identification (RFID) for football - By sticking an RFID sensor in a player’s shoulder pad, coaches can now see where the location of a player, the speed, and the direction they’re going. This allows them to put together smarter game plans and improve team performance.

The Internet of Things is changing the world we live in, and it’s not happening slowly. Have you started using IoT-connected devices? Tell us about your IoT experiences today in the comments section below.

Tags:

Connectivity Internet of Things Sports

0 Comment

Baseball Executive Pleads Guilty to Hacking Rival

John Reilly

Monday, 01 February 2016

Miscellaneous

IT can be like baseball. When a team is up to bat in a game of baseball, the team at bat is allowed to keep two coaches on the field. They are called the first base coach and the third base coach. While both coaches’ responsibilities mostly have to do with baserunning, the third base coach also takes on the responsibility of relaying “signs” from the manager in the dugout to the batter at the plate.

buck ib 1

These signs represent orders or suggestions from the manager, who is in charge of implementing the strategy each pitcher or batter throughout the baseball game. The third base coach is just an intermediary. He relays the orders to the batter, and it’s the batter’s job to execute the direction that’s given. Each team will try incessantly to steal the other team’s signs, as doing so will give them a distinct advantage on the field of play. For instance, if a hitter somehow was tipped off that the pitcher will be throwing a curveball, there is a better chance the player will let the pitch go by because it’s hard to throw a curveball for a strike, and even harder to hit a curveball.

What does this have to do with IT? It suggests just how much your competition gains from having information about your company; the information that only you should have access to. While “sign-stealing” on the diamond is looked on as gamesmanship, stealing information over your business’ network is a crime (or at the very least unethical), and should be thwarted if at all possible. The former scouting director for the St. Louis Cardinals is finding that out the hard way.

Christopher Correa, the former scouting director for the St. Louis Cardinals has plead guilty to five counts of unauthorized access to a private computer for using a former employee's login information to access a Houston Astros’ secure database that was filled with data that could provide useful information. Correa had accessed both employee emails and the team’s database to gain information, an action that he admitted was, “stupid,” to U.S. District Judge Lynn Hughes.

Correa, who accessed information mainly to gain a competitive advantage over a rival team, was fired from the St. Louis organization after his improprieties came to light. Ironically, Houston, who had been playing in the same division with St. Louis since 1994, moved to the American League before any of these hacks had taken place.

Correa’s former boss, and current Astros General Manager, Jeff Luhnow is likely the “Victim A” from the indictment, and the likely owner of the passwords that Correa used to access the Astros’ system. Luhnow seemingly used the same credentials to sign into the Astros’ environment as he did when he handed over his laptop and password to Correa when he left to take the GM job in Houston in 2011. Luhnow made the following statement:

"I absolutely know about password hygiene and best practices. I’m certainly aware of how important passwords are, as well as the importance of keeping them updated. A lot of my job in baseball, as it was in high tech, is to make sure that intellectual property is protected. I take that seriously and hold myself and those who work for me to a very high standard."

In this case, however, Luhnow seemed to be lacking somewhat in his conscientious efforts to protect his organization’s intellectual property by using the same credentials he was using while a member of the St. Louis staff five years prior. When someone leaves your company, especially if he or she is leaving for a competitor, it’s important that you get all the credentials that they used to access all data systems. Conversely, when someone joins your company, it’s important to make sure they understand your organization’s cyber security protocols, to keep you from having to deal with data breaches and other situations that may put your business at risk.

Network security, including password management and intrusion detection are essential for every business that doesn’t want to their network hacked by their competition, or by random hackers out to make a quick buck. For more information about the best practices for comprehensive network security, or to talk with a technician about the options we offer to help you protect your network, call us today at 800.394.2301.

Tags:

Sports Hackers Security

0 Comment

Joomla! Debug Console

111 Queries Logged

SELECT `data` FROM `p3sae_session` WHERE `session_id` = 'f853d3324ccbbc578221b0139b2227d4'
DELETE FROM `p3sae_session` WHERE `time` < '1714159621'
SELECT `session_id` FROM `p3sae_session` WHERE `session_id` = 'f853d3324ccbbc578221b0139b2227d4' LIMIT 0, 1
INSERT INTO `p3sae_session` (`session_id`, `client_id`, `time`) VALUES ('f853d3324ccbbc578221b0139b2227d4', 0, '1714168621')
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.141.24.134'
SELECT `source`,`keepurlparams` FROM `p3sae_admintools_redirects` WHERE ((`dest` = 'index.php/blog/tags/sports') OR (`dest` = 'index.php/blog/tags/sports') OR ('index.php/blog/tags/sports' 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_tag` WHERE ( BINARY `title`='sports' OR BINARY `alias`='sports' )
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-26 21:57:01' 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-26 21:57:01' 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-26 21:57:01' , 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-26 21:57:01', 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` ASC
SELECT * 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.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_tag WHERE `id` = '234'
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` = '234' 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,5
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.id WHERE a.`tag_id` = '234' 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 x
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` = '234' 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` = '234' and (a.`source_type` = 'easyblog.team')
SELECT COUNT(1) as `voted`, `uid` FROM `p3sae_easyblog_ratings` WHERE `uid` IN (914,418) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = 'f853d3324ccbbc578221b0139b2227d4' OR `ip` = '3.141.24.134') 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(914,418) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `p3sae_easyblog_comment` AS a WHERE a.`post_id` IN(914,418) AND a.`published`='1'
SELECT a.`post_id`, COUNT(1) AS `count` FROM `p3sae_easyblog_comment` AS a WHERE a.`post_id` IN(914,418) 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 ( 914,418)
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 ( 914,418)
select a.* from `p3sae_easyblog_revisions` as a where a.`id` IN ( 7913,51)
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 IN (914,418)
select * from `p3sae_easyblog_meta` where `content_id` in (914,418) and `type` = 'post'
SELECT * FROM `p3sae_easyblog_featured` WHERE `content_id` IN(914,418) AND `type`='post'
SELECT `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` DESC
SELECT `group_id` FROM `p3sae_easyblog_category_fields_groups` WHERE `category_id`='10'
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`='10' AND a.`state`='1' ORDER BY a.`created` DESC
SELECT * FROM p3sae_easyblog_tag WHERE `id` = '234'
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-26 21:57:01') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 21:57:01') 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 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 `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.id
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT * FROM p3sae_easyblog_tag WHERE `id` = '411'
SELECT * FROM p3sae_easyblog_tag WHERE `id` = '242'
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` = '914' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3
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 * FROM p3sae_easyblog_tag WHERE `id` = '106'
SELECT * FROM p3sae_easyblog_tag WHERE `id` = '34'
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` = '418' AND a.`published` = 1 ORDER BY a.`lft` asc LIMIT 3
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 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:1392:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzE0MTY4NjIxO3M6NDoibGFzdCI7aToxNzE0MTY4NjIxO3M6Mzoibm93IjtpOjE3MTQxNjg2MjE7fXM6NToidG9rZW4iO3M6MzI6IjA4ODRlNGJmM2JmM2Q0ZWU2ZjEyZGIwMWNlMzUxZjJjIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fX1zOjEwOiJfX2Vhc3libG9nIjtPOjg6InN0ZENsYXNzIjoxOntzOjQ6InNpdGUiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoibWVzc2FnZXMiO047fX19fQ==\";' , `time` = '1714168622' WHERE `session_id` = 'f853d3324ccbbc578221b0139b2227d4'

58 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

30 × SELECT `template` FROM `p3sae_template_styles`
10 × SELECT id FROM p3sae_assets
6 × SELECT * FROM p3sae_easyblog_tag
4 × SELECT extension_id AS id, element AS "option", params, enabled FROM p3sae_extensions
4 × SELECT r.* FROM p3sae_rereplacer AS r
2 × SELECT * FROM `p3sae_easyblog_acl_group`
2 × SELECT `group_id` FROM `p3sae_easyblog_category_fields_groups`
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`
2 × SELECT a.* FROM `p3sae_easyblog_comment` a INNER JOIN p3sae_users AS c ON a.`created_by` = c.`id`
1 × SELECT a.`post_id`, COUNT(1) AS `count` FROM `p3sae_easyblog_comment` AS a
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`
1 × SELECT a.* FROM `p3sae_easyblog_comment` AS a
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` = '234'
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`
1 × SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `p3sae_easyblog_ratings` AS a
1 × SELECT COUNT(1) as `voted`, `uid` FROM `p3sae_easyblog_ratings`
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_id
1 × 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.id
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 a.* from `p3sae_easyblog_revisions` as a
1 × SELECT * FROM p3sae_easyblog_meta
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_tag`
1 × SELECT * FROM p3sae_languages
1 × SELECT `source`,`keepurlparams` FROM `p3sae_admintools_redirects`
1 × SELECT * FROM `p3sae_admintools_ipautoban`
1 × SELECT id, rules FROM `p3sae_viewlevels
1 × SELECT folder AS type, element AS name, params FROM p3sae_extensions
1 × 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_id
1 × SELECT `id` FROM `p3sae_easyblog_mailq`
1 × SELECT a.rules FROM p3sae_assets AS a
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 `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.rgt
1 × 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_users
1 × UPDATE `p3sae_session` SET `data` = 'joomla|s:1392:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzE0MTY4NjIxO3M6NDoibGFzdCI7aToxNzE0MTY4NjIxO3M6Mzoibm93IjtpOjE3MTQxNjg2MjE7fXM6NToidG9rZW4iO3M6MzI6IjA4ODRlNGJmM2JmM2Q0ZWU2ZjEyZGIwMWNlMzUxZjJjIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fX1zOjEwOiJfX2Vhc3libG9nIjtPOjg6InN0ZENsYXNzIjoxOntzOjQ6InNpdGUiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoibWVzc2FnZXMiO047fX19fQ==\";' , `time` = '1714168622'
1 × SHOW FULL COLUMNS FROM `p3sae_assets
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 ('f853d3324ccbbc578221b0139b2227d4', 0, '1714168621'
1 × DELETE FROM `p3sae_easyblog_mailq`
1 × DELETE FROM `p3sae_session`

Infradapt Blog

Sports

Sports Are a Training Ground for Smart Technology

Baseball Executive Pleads Guilty to Hacking Rival

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

111 Queries Logged

58 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: