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

Don’t Get Trapped in PowerPoint Purgatory

Monday, 21 April 2014

John Reilly

IT Blog

0 Comment

Everyone dreads presentations, but for different reasons. Some people are just afraid of public speaking, or they are just overall unorganized. In the end, well designed presentations are essential for your company's success, whether they are given to clients or to your employees. Thankfully, there are ways to minimize the stress that giving a presentation can cause. One of the best ways to prepare a presentation is to use a Microsoft PowerPoint slideshow as an aid.

However, it's very easy to fall into "PowerPoint Purgatory", a place filled with overburdened slideshows that last for hours on end. The amount of professionals who don't use PowerPoint effectively far outweigh those who do. Infradapt is here to help by providing you with some useful tips to make your presentations both easy for the presenter and for the audience!

Appearance is Everything
1. Cut Down on the Slides - Seriously, how your presentation goes will likely depend on the way that it looks to the audience. When they see that your presentation is 140 slides long, they will sigh and want to take a nap. Use the minimal number of slides to get your point across.

2. Choose a Clear Font Style and Font Size – If the audience can't see what you have put on your slides, they won't learn anything from the presentation. Similarly, if they can't read what you've put on the slides, they still won't get anything out of it. The font color should always be in contrast to what your background color is (i.e. white words on a black background, rather than orange text on a red background). This makes the text clear and easy to spot.

3. Simplicity is Best – Always keep the text simple when you can. The audience's attention should be on you, the presenter, rather than the presentation itself. Always make sure that your slide backgrounds are simple and consistent throughout the slideshow. Don't use anything too distracting, or you risk the audience's attention being lost.

4. Spelling and Grammar Check – Nothing says "unprofessional" like misspelling your company's name on the title slide. It's embarrassing when you know how to spell a word, but perhaps you simply missed a key. Go through it once on your own and pay particularly close attention to the spelling, then let spell/grammar check handle the rest.

The Presentation Itself
1. Be Prepared – the bane of everyone using a PowerPoint presentation is finding out that your presentation won't work with the computer you are working on. Get to venue ahead of time to ensure that all of your equipment is working correctly. Make sure that the resolution of the projector matches the resolution of your presentation; otherwise, there might be display issues that will take away from your presentation.

2. Bring Note Cards – If you get nervous about presenting to a large audience, don't fall into the trap of reading whatever is on the slide. Make note cards for yourself and do not read the slide. This makes the audience concentrate on you and what you have to say. The PowerPoint is merely an aid for what the presenter, you, have to say. It should not be the opposite way. Note cards also help you stay on track and on time, if that is an issue.

3. Turn Off Your Screen Saver – You might think your desktop and screensaver are great, but that doesn't mean that the audience will. You want their full attention, so turn your screen saver off.

For more best practices, contact Infradapt at 800.394.2301. With these easy tips, your next PowerPoint presentation will surely be a winner. Do you have any secrets you would like to share? Let us know in the comments!

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

Tuesday, 12 June 2018 Cyberbullying is a Serious Issue Everywhere

Monday, 11 June 2018 How Does the A.I. in Reality Measure Up to Hollywood’s?

Comments

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

Joomla! Debug Console

170 Queries Logged

SELECT `data` FROM `p3sae_session` WHERE `session_id` = '85f39efcff116c20436a7594b659ea9b'
DELETE FROM `p3sae_session` WHERE `time` < '1713522749'
SELECT `session_id` FROM `p3sae_session` WHERE `session_id` = '85f39efcff116c20436a7594b659ea9b' LIMIT 0, 1
INSERT INTO `p3sae_session` (`session_id`, `client_id`, `time`) VALUES ('85f39efcff116c20436a7594b659ea9b', 0, '1713531749')
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.144.48.135'
SELECT `source`,`keepurlparams` FROM `p3sae_admintools_redirects` WHERE ((`dest` = 'index.php/blog/entry/don-t-get-trapped-in-powerpoint-purgatory') OR (`dest` = 'index.php/blog/entry/don-t-get-trapped-in-powerpoint-purgatory') OR ('index.php/blog/entry/don-t-get-trapped-in-powerpoint-purgatory' 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`='don:t-get-trapped-in-powerpoint-purgatory'
SELECT `id` FROM `p3sae_easyblog_post` WHERE `permalink`='don-t-get-trapped-in-powerpoint-purgatory'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '47'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '137'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='47'
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 13:02:29' 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 13:02:29' 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 13:02:29' , 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 13:02:29', 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` = '47'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '137'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='47'
SELECT COUNT(1) as `voted`, `uid` FROM `p3sae_easyblog_ratings` WHERE `uid` = '47' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '85f39efcff116c20436a7594b659ea9b' OR `ip` = '3.144.48.135') 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(47) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `p3sae_easyblog_comment` AS a WHERE a.`post_id` IN(47) AND a.`published`='1'
SELECT a.`post_id`, COUNT(1) AS `count` FROM `p3sae_easyblog_comment` AS a WHERE a.`post_id` IN(47) 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 ( 47)
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 ( 47)
select a.* from `p3sae_easyblog_revisions` as a where a.`id` IN ( 137)
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` = '47'
select * from `p3sae_easyblog_meta` where `content_id` in (47) and `type` = 'post'
SELECT * FROM p3sae_easyblog_meta WHERE `content_id` = '47' 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 = '47'
SELECT COUNT(1) FROM `p3sae_easyblog_featured` WHERE `content_id`='47' AND `type`='post'
SELECT COUNT(1) FROM `p3sae_easyblog_comment` WHERE `post_id`='47' AND `published`='1'
SELECT `group_id` FROM `p3sae_easyblog_category_fields_groups` WHERE `category_id`='3'
SELECT a.* FROM `p3sae_easyblog_fields` AS a INNER JOIN `p3sae_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`='3' AND a.`state`='1' ORDER BY a.`created` DESC
SELECT `key`,`value` FROM `p3sae_easyblog_post_assets` WHERE `post_id`='47'
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 5
SELECT `id` FROM `p3sae_menu` WHERE ( `link` LIKE 'index.php?option=com_easyblog&view=entry&id=47%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=47%' ) 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-04-21 21:11:12' 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-04-21 21:11:12' ORDER BY a.`created` ASC LIMIT 1
SELECT * FROM p3sae_easyblog_post WHERE `id` = '46'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '321'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='46'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '48'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '350'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='48'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '48'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '350'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='48'
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 13:02:29') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 13:02:29') 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` = '60'
SELECT * FROM p3sae_easyblog_tag WHERE `id` = '41'
SELECT * FROM p3sae_easyblog_tag WHERE `id` = '21'
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 * FROM p3sae_easyblog_post WHERE `id` = '930'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '8239'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='930'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '923'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '8240'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='923'
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` = '47' AND b.`post_id` = '47' 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` = '47' AND b.`post_id` = '47' 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` = '47'
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:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzEzNTMxNzQ5O3M6NDoibGFzdCI7aToxNzEzNTMxNzQ5O3M6Mzoibm93IjtpOjE3MTM1MzE3NDk7fXM6NToidG9rZW4iO3M6MzI6IjhlM2Q0MTE5MDE0Yzk2ZmQ5MTFlNTNlZGEwOWQ1OGViIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MzI6ImIxMmZiZjhmNjkxODVhZDgxMTExOGJlYmIzYTliYzdlIjtpOjE7fXM6MTA6Il9fZWFzeWJsb2ciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoic2l0ZSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo4OiJtZXNzYWdlcyI7Tjt9fX19\";' , `time` = '1713531750' WHERE `session_id` = '85f39efcff116c20436a7594b659ea9b'

66 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

48 × SELECT `template` FROM `p3sae_template_styles`
19 × SELECT id FROM p3sae_assets
11 × SELECT * FROM p3sae_easyblog_post
10 × SELECT * FROM p3sae_easyblog_revisions
10 × 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 × SHOW FULL COLUMNS FROM `p3sae_users
1 × UPDATE p3sae_easyblog_post SET `hits` = (`hits` + 1)
1 × UPDATE `p3sae_session` SET `data` = 'joomla|s:1448:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzEzNTMxNzQ5O3M6NDoibGFzdCI7aToxNzEzNTMxNzQ5O3M6Mzoibm93IjtpOjE3MTM1MzE3NDk7fXM6NToidG9rZW4iO3M6MzI6IjhlM2Q0MTE5MDE0Yzk2ZmQ5MTFlNTNlZGEwOWQ1OGViIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MzI6ImIxMmZiZjhmNjkxODVhZDgxMTExOGJlYmIzYTliYzdlIjtpOjE7fXM6MTA6Il9fZWFzeWJsb2ciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoic2l0ZSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo4OiJtZXNzYWdlcyI7Tjt9fX19\";' , `time` = '1713531750'
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 ('85f39efcff116c20436a7594b659ea9b', 0, '1713531749'
1 × DELETE FROM `p3sae_easyblog_mailq`
1 × DELETE FROM `p3sae_session`

Infradapt Blog

Don’t Get Trapped in PowerPoint Purgatory

About the author

John Reilly

Author's recent posts

Comments

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

170 Queries Logged

66 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: