We built the agency brick by brick, good person by good person, helping dozens and dozens of young players fulfill their NFL dreams and helping make good players into great NFL player. We did it through treating each player like family.

Welcome to Rich Sports Management

We attribute our success to hard work, honesty, a passion for the game, and our total commitment
to our clients. Honesty and integrity are values that should never be sacrificed

What Sets Us Apart

We ONLY

do football - Your agent should know football

We DON'T

do hand offs to younger or less experienced agents

We ONLY

take one player at each position, per Draft class

We DON'T

represent more than 6 clients in a Draft class

DAVID E. Rich

"I promise all of the players I represent that I will stick with them to the end of their dream, until they tell me they no longer wish to play football at any level."

NOT JUST A NUMBER

Every player IS more than just a number, never a Player #13B

TREATED LIKE A PRO

Every player IS treated like they are the first pick in the NFL Draft

BE GOOD TO PEOPLE

If you are good to people, you will be paid back in loyalty, personal gratification and in money.

CHECK OUT OUR AWESOME PLAYERS

Current and Former Players Represented by Rich Sports Management
Every player is more than just a number, never a player #13B

SOME OF THE RICH SPORTS TEAM

In addition to our two NFLPA certified and three CFLPA certified contract advisers, we also have on our staff additional full time employees, including secretaries, personal assistants, travel coordinators, bookkeepers, associates and marketing personnel. We are a full-service agency capable of handling all of our players' needs.

Ricco HughesDirector of Football Operations / Player Development CFLPA Certified Agent

Trey McFarlinSouth & Southeast Territory Agent NFLPA / CFLPA Certified Agent

Chris AdkinsDirector of College Scouting / Recruiting Coordinator

Zach PillerDirector of Post Career Counseling & Player Relations / CFLPA Certified Agent

See All Of The Rich Sports Team

OUR AMAZING SKILLS

100%

Contract Negotiation

100%

Legal Assistance, Advice and Representation

100%

NFL Combine Training

100%

G.M. and Player Personnel Interviewing Skills Session

Clients Testimonials

Notice: Trying to get property of non-object in /home/rsmsite2015/public_html/modules/mod_k2_content/mod_k2_content.php on line 33

Notice: Trying to get property of non-object in /home/rsmsite2015/public_html/modules/mod_k2_content/mod_k2_content.php on line 35

Recent News

Stay current with Rich Sports Management News, Rich Sports News,
and any other general Things to Know in the
Rich Sports Management NFL Agent world.
View All The News

VIDEO: Lucky Whitehead surprises his mother at the Manassas Boys and Girls Club with a new car

Osbourn High School graduate Lucky Whitehead…

Matt Brei Joins Rich Sports as Midwest Region Agent

Rich Sports is excited to announce…

Recent News

Stay current with Rich Sports Management News, Rich Sports News,
and any other general Things to Know in the
Rich Sports Management NFL Agent world.
View All The News

The NFL Combine 5 Year Draft Averages by Position

The NFL Combine 5 year draft…

Popular Brands

Office Locations

Charleston, WV
Cincinnati, OH
Columbus, OH
Dayton, OH
Lexington, KY

Morgantown, KY
Pittsburgh, PA
Minneapolis/St. Paul, MN

Stay In Touch

Who We Are

Joomla! Debug Console

Session

Profile Information

Time

Memory

**Time**: 0.0 ms / 0.0 ms **Memory**: 0.747 MB / 0.75 MB Application: afterLoad

**Time**: 285.1 ms / 285.1 ms **Memory**: 7.704 MB / 8.45 MB Application: afterInitialise

**Time**: 233.3 ms / 518.5 ms **Memory**: 12.669 MB / 21.12 MB Application: afterRoute

**Time**: 86.5 ms / 605.0 ms **Memory**: 3.008 MB / 24.13 MB Application: afterDispatch

**Time**: 8.9 ms / 613.9 ms **Memory**: 0.407 MB / 24.53 MB Application: beforeRenderModule mod_unite_revolution2 (Home Page1 slider)

**Time**: 52.4 ms / 666.3 ms **Memory**: 3.443 MB / 27.98 MB Application: afterRenderModule mod_unite_revolution2 (Home Page1 slider)

**Time**: 0.4 ms / 666.7 ms **Memory**: 0.000 MB / 27.93 MB Application: beforeRenderModule mod_custom (Welcome To Our Intensy - Rich)

**Time**: 8.8 ms / 675.5 ms **Memory**: 0.022 MB / 27.95 MB Application: afterRenderModule mod_custom (Welcome To Our Intensy - Rich)

**Time**: 0.4 ms / 675.9 ms **Memory**: 0.000 MB / 27.96 MB Application: beforeRenderModule mod_custom (Service Module Home Page - Rich)

**Time**: 7.3 ms / 683.2 ms **Memory**: 0.017 MB / 27.97 MB Application: afterRenderModule mod_custom (Service Module Home Page - Rich)

**Time**: 0.3 ms / 683.5 ms **Memory**: 0.000 MB / 27.97 MB Application: beforeRenderModule mod_custom (David E Rich - Rich)

**Time**: 17.4 ms / 700.9 ms **Memory**: 0.013 MB / 27.98 MB Application: afterRenderModule mod_custom (David E Rich - Rich)

**Time**: 0.3 ms / 701.2 ms **Memory**: 0.000 MB / 27.99 MB Application: beforeRenderModule mod_custom (Check Out Our Awesome Players)

**Time**: 4627.2 ms / 5328.5 ms **Memory**: 0.161 MB / 28.15 MB Application: afterRenderModule mod_custom (Check Out Our Awesome Players)

**Time**: 0.3 ms / 5328.7 ms **Memory**: 0.000 MB / 28.15 MB Application: beforeRenderModule mod_custom (Rich Sports Team)

**Time**: 5.9 ms / 5334.7 ms **Memory**: 0.036 MB / 28.18 MB Application: afterRenderModule mod_custom (Rich Sports Team)

**Time**: 0.2 ms / 5334.9 ms **Memory**: 0.000 MB / 28.18 MB Application: beforeRenderModule mod_custom (Our amazing skill - Rich)

**Time**: 6.5 ms / 5341.4 ms **Memory**: 0.021 MB / 28.20 MB Application: afterRenderModule mod_custom (Our amazing skill - Rich)

**Time**: 0.3 ms / 5341.8 ms **Memory**: 0.017 MB / 28.22 MB Application: beforeRenderModule mod_k2_content (Recent News)

**Time**: 31.3 ms / 5373.1 ms **Memory**: 1.230 MB / 29.45 MB Application: afterRenderModule mod_k2_content (Recent News)

**Time**: 0.3 ms / 5373.4 ms **Memory**: 0.000 MB / 29.38 MB Application: beforeRenderModule mod_custom (Testimonial Module Home Page - Rich)

**Time**: 3.0 ms / 5376.3 ms **Memory**: 0.014 MB / 29.39 MB Application: afterRenderModule mod_custom (Testimonial Module Home Page - Rich)

**Time**: 0.2 ms / 5376.5 ms **Memory**: 0.000 MB / 29.39 MB Application: beforeRenderModule mod_custom (Our Populer Brands - Rich)

**Time**: 4.2 ms / 5380.7 ms **Memory**: 0.011 MB / 29.40 MB Application: afterRenderModule mod_custom (Our Populer Brands - Rich)

**Time**: 0.2 ms / 5380.9 ms **Memory**: 0.000 MB / 29.40 MB Application: beforeRenderModule mod_custom (Office Locations)

**Time**: 1.7 ms / 5382.6 ms **Memory**: 0.007 MB / 29.41 MB Application: afterRenderModule mod_custom (Office Locations)

**Time**: 0.1 ms / 5382.7 ms **Memory**: 0.000 MB / 29.41 MB Application: beforeRenderModule mod_custom (Stay In Touch)

**Time**: 2.2 ms / 5384.9 ms **Memory**: 0.009 MB / 29.42 MB Application: afterRenderModule mod_custom (Stay In Touch)

**Time**: 0.1 ms / 5385.0 ms **Memory**: 0.000 MB / 29.42 MB Application: beforeRenderModule mod_custom (Who We Are)

**Time**: 1.1 ms / 5386.1 ms **Memory**: 0.007 MB / 29.42 MB Application: afterRenderModule mod_custom (Who We Are)

**Time**: 6.3 ms / 5392.4 ms **Memory**: 0.230 MB / 29.65 MB Application: beforeRenderModule mod_bdthemes_logo (Logo Module (2))

**Time**: 3.2 ms / 5395.6 ms **Memory**: 0.013 MB / 29.67 MB Application: afterRenderModule mod_bdthemes_logo (Logo Module (2))

**Time**: 1.0 ms / 5396.6 ms **Memory**: 0.000 MB / 29.66 MB Application: beforeRenderModule mod_menu (Main Menu)

**Time**: 10.5 ms / 5407.1 ms **Memory**: 0.123 MB / 29.79 MB Application: afterRenderModule mod_menu (Main Menu)

**Time**: 8.3 ms / 5415.4 ms **Memory**: 0.303 MB / 30.09 MB Application: beforeRenderModule mod_bdthemes_logo (Logo Small)

**Time**: 0.5 ms / 5415.9 ms **Memory**: 0.009 MB / 30.10 MB Application: afterRenderModule mod_bdthemes_logo (Logo Small)

**Time**: 13.8 ms / 5429.7 ms **Memory**: 0.091 MB / 30.19 MB Application: beforeRenderModule mod_custom (Footer Left Module)

**Time**: 1.2 ms / 5430.9 ms **Memory**: 0.007 MB / 30.20 MB Application: afterRenderModule mod_custom (Footer Left Module)

**Time**: 0.9 ms / 5431.8 ms **Memory**: 0.000 MB / 30.20 MB Application: beforeRenderModule mod_custom (Footer Right Module)

**Time**: 1.3 ms / 5433.0 ms **Memory**: 0.007 MB / 30.20 MB Application: afterRenderModule mod_custom (Footer Right Module)

**Time**: 1.5 ms / 5434.6 ms **Memory**: 0.003 MB / 30.21 MB Application: beforeRenderModule mod_menu (Offcanvas Menu)

**Time**: 5.9 ms / 5440.5 ms **Memory**: 0.014 MB / 30.22 MB Application: afterRenderModule mod_menu (Offcanvas Menu)

**Time**: 0.1 ms / 5440.6 ms **Memory**: 0.000 MB / 30.21 MB Application: beforeRenderModule mod_custom (Offcanvas Social Module)

**Time**: 2.3 ms / 5442.9 ms **Memory**: 0.008 MB / 30.22 MB Application: afterRenderModule mod_custom (Offcanvas Social Module)

**Time**: 533.8 ms / 5976.8 ms **Memory**: 1.077 MB / 31.30 MB Application: afterRender

**Database queries total: 43.8 ms**

Memory Usage

Database Queries

48 Queries Logged 43.8 ms

10 duplicate found!

**2 duplicates**: #12 #16

**2 duplicates**: #13 #17

**2 duplicates**: #14 #18

**4 duplicates**: #36 #37 #38 #39

**Query Time: 0.45 ms** **Query memory: 0.013 MB Memory before query: 2.476 MB** **Rows returned: 0**

SELECT `data`

  FROM `nczdx_session`

  WHERE `session_id` = '1qusbl0370objti1jgc7adcmg7'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_session	const	PRIMARY	PRIMARY	602	const	1	100.00	NULL

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/joomla/session/storage/database.php:44

JROOT/libraries/joomla/session/session.php:665

JROOT/libraries/joomla/session/session.php:603

JROOT/libraries/cms/application/cms.php:739

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:399

JROOT/libraries/joomla/factory.php:125

JROOT/index.php:42

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.42 ms** **After last query: 3.24 ms** **Query memory: 0.010 MB Memory before query: 2.666 MB** **Rows returned: 0**

SELECT `session_id`

  FROM `nczdx_session`

  WHERE `session_id` = '1qusbl0370objti1jgc7adcmg7' 
  LIMIT 0, 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_session	const	PRIMARY	PRIMARY	602	const	1	100.00	Using index

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/cms/application/cms.php:176

JROOT/libraries/cms/application/cms.php:765

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:399

JROOT/libraries/joomla/factory.php:125

JROOT/index.php:42

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.43 ms** **After last query: 0.19 ms** **Query memory: 0.009 MB Memory before query: 2.678 MB**

INSERT INTO `nczdx_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('1qusbl0370objti1jgc7adcmg7', 0, '1576205448')

**Explain**

**EXPLAIN not possible on query: INSERT INTO `nczdx_session` (`session_id`, `client_id`, `time`) VALUES ('1qusbl0370objti1jgc7adcmg7', 0, '1576205448')**

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
update	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/cms/application/cms.php:208

JROOT/libraries/cms/application/cms.php:765

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:399

JROOT/libraries/joomla/factory.php:125

JROOT/index.php:42

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 8.95 ms** **After last query: 5.43 ms** **Query memory: 0.012 MB Memory before query: 3.046 MB** **Rows returned: 36**

SELECT extension_id AS id, element AS "option", params, enabled

  FROM nczdx_extensions

  WHERE `type` = 'component'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_extensions	ref	extension	extension	62	const	36	100.00	Using index condition

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.3 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/component/helper.php:435

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:120

JROOT/libraries/cms/application/site.php:568

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.54 ms** **After last query: 2.15 ms** **Query memory: 0.012 MB Memory before query: 3.209 MB** **Rows returned: 2**

SELECT b.id

  FROM nczdx_usergroups AS a

  LEFT JOIN nczdx_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/joomla/access/access.php:332

JROOT/libraries/joomla/access/access.php:401

JROOT/libraries/joomla/user/user.php:453

JROOT/libraries/cms/plugin/helper.php:296

JROOT/libraries/cms/plugin/helper.php:163

JROOT/libraries/cms/application/site.php:573

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.42 ms** **After last query: 0.82 ms** **Query memory: 0.011 MB Memory before query: 3.265 MB** **Rows returned: 5**

SELECT id, rules

  FROM `nczdx_viewlevels`

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	NULL

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/joomla/access/access.php:418

JROOT/libraries/joomla/user/user.php:453

JROOT/libraries/cms/plugin/helper.php:296

JROOT/libraries/cms/plugin/helper.php:163

JROOT/libraries/cms/application/site.php:573

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.45 ms** **After last query: 0.26 ms** **Query memory: 0.009 MB Memory before query: 3.284 MB** **Rows returned: 87**

SELECT folder AS type, element AS name, params

  FROM nczdx_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_extensions	ref	extension	extension	62	const	194	100.00	Using index condition; Using where; Using filesort

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.9 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/cms/plugin/helper.php:310

JROOT/libraries/cms/plugin/helper.php:163

JROOT/libraries/cms/application/site.php:573

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.63 ms** **After last query: 170.36 ms** **Query memory: 0.016 MB Memory before query: 7.469 MB** **Rows returned: 0**

SELECT `storage_value`

  FROM `nczdx_securitycheckpro_storage`

  WHERE `storage_key` = 'pro_plugin'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_securitycheckpro/models/protection.php:103

JROOT/administrator/components/com_securitycheckpro/models/protection.php:68

JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1307

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.60 ms** **After last query: 2.77 ms** **Query memory: 0.015 MB Memory before query: 7.656 MB** **Rows returned: 0**

SELECT `storage_value`

  FROM `nczdx_securitycheckpro_storage`

  WHERE `storage_key` = 'geoblock'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_securitycheckpro/models/geoblock.php:73

JROOT/administrator/components/com_securitycheckpro/models/geoblock.php:38

JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1335

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.55 ms** **After last query: 0.17 ms** **Query memory: 0.015 MB Memory before query: 7.671 MB**

DELETE 
  FROM `nczdx_securitycheckpro_dynamic_blacklist` 
  WHERE (DATE_ADD(`timeattempt`, INTERVAL 600 SECOND)) < NOW();

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_securitycheckpro_dynamic_blacklist	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	100.00	Using where

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/plugins/system/securitycheckpro/securitycheckpro.php:664

JROOT/plugins/system/securitycheckpro/securitycheckpro.php:699

JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1395

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.55 ms** **After last query: 0.12 ms** **Query memory: 0.016 MB Memory before query: 7.686 MB** **Rows returned: 1**

SELECT COUNT(*) 
  from `nczdx_securitycheckpro_dynamic_blacklist` 
  WHERE (`ip` = '3.214.184.124' 
  AND `counter` >= 5)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/plugins/system/securitycheckpro/securitycheckpro.php:639

JROOT/plugins/system/securitycheckpro/securitycheckpro.php:701

JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1395

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.59 ms** **After last query: 5.68 ms** **Query memory: 0.015 MB Memory before query: 8.042 MB** **Rows returned: 0**

**Duplicate queries**: #16

SELECT `storage_value`

  FROM `nczdx_securitycheckpro_storage`

  WHERE `storage_key` = 'filemanager_resume'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:199

JROOT/libraries/legacy/model/legacy.php:199

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.55 ms** **After last query: 0.18 ms** **Query memory: 0.015 MB Memory before query: 8.058 MB** **Rows returned: 0**

**Duplicate queries**: #17

SELECT `storage_value`

  FROM `nczdx_securitycheckpro_storage`

  WHERE `storage_key` = 'fileintegrity_resume'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:207

JROOT/libraries/legacy/model/legacy.php:199

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.54 ms** **After last query: 0.16 ms** **Query memory: 0.015 MB Memory before query: 8.074 MB** **Rows returned: 0**

**Duplicate queries**: #18

SELECT `storage_value`

  FROM `nczdx_securitycheckpro_storage`

  WHERE `storage_key` = 'malwarescan_resume'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:215

JROOT/libraries/legacy/model/legacy.php:199

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.54 ms** **After last query: 0.17 ms** **Query memory: 0.015 MB Memory before query: 8.089 MB** **Rows returned: 0**

SELECT `storage_value`

  FROM `nczdx_securitycheckpro_storage`

  WHERE `storage_key` = 'cron_plugin'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_securitycheckpro/models/protection.php:103

JROOT/administrator/components/com_securitycheckpro/models/protection.php:68

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:160

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.51 ms** **After last query: 0.30 ms** **Query memory: 0.017 MB Memory before query: 8.111 MB** **Rows returned: 0**

**Duplicate queries**: #12

SELECT `storage_value`

  FROM `nczdx_securitycheckpro_storage`

  WHERE `storage_key` = 'filemanager_resume'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:199

JROOT/libraries/legacy/model/legacy.php:199

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.51 ms** **After last query: 0.15 ms** **Query memory: 0.017 MB Memory before query: 8.129 MB** **Rows returned: 0**

**Duplicate queries**: #13

SELECT `storage_value`

  FROM `nczdx_securitycheckpro_storage`

  WHERE `storage_key` = 'fileintegrity_resume'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:207

JROOT/libraries/legacy/model/legacy.php:199

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.51 ms** **After last query: 0.15 ms** **Query memory: 0.017 MB Memory before query: 8.146 MB** **Rows returned: 0**

**Duplicate queries**: #14

SELECT `storage_value`

  FROM `nczdx_securitycheckpro_storage`

  WHERE `storage_key` = 'malwarescan_resume'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:215

JROOT/libraries/legacy/model/legacy.php:199

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.49 ms** **After last query: 0.14 ms** **Query memory: 0.014 MB Memory before query: 8.162 MB** **Rows returned: 1**

SELECT `last_task`

  FROM `nczdx_securitycheckpro_file_manager`

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_securitycheckpro_file_manager	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:102

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.50 ms** **After last query: 0.12 ms** **Query memory: 0.014 MB Memory before query: 8.177 MB** **Rows returned: 1**

SELECT `last_check_integrity`

  FROM `nczdx_securitycheckpro_file_manager`

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_securitycheckpro_file_manager	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:110

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.41 ms** **After last query: 0.24 ms** **Query memory: 0.013 MB Memory before query: 8.185 MB** **Rows returned: 1**

SELECT cron_tasks_launched 
  FROM nczdx_securitycheckpro_file_manager 
  WHERE id=1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_securitycheckpro_file_manager	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:177

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:654

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.23 ms** **After last query: 17.73 ms** **Query memory: 0.018 MB Memory before query: 8.691 MB** **Rows returned: 25**

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 nczdx_menu AS m

  LEFT JOIN nczdx_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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	60	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	rsm2015.m.component_id	1	100.00	Using where

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.6 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/cms/menu/site.php:45

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:424

JROOT/libraries/cms/application/site.php:272

JROOT/libraries/cms/router/site.php:57

JROOT/libraries/cms/router/router.php:196

JROOT/libraries/cms/application/cms.php:520

JROOT/libraries/cms/application/site.php:407

JROOT/libraries/cms/application/cms.php:1088

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.60 ms** **After last query: 13.75 ms** **Query memory: 0.022 MB Memory before query: 9.075 MB** **Rows returned: 1**

SELECT extension_id AS id, element AS "option", params, enabled

  FROM nczdx_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using index condition

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/library/helper.php:156

JROOT/libraries/cms/library/helper.php:47

JROOT/libraries/cms/library/helper.php:90

JROOT/libraries/cms/version/version.php:189

JROOT/libraries/joomla/factory.php:736

JROOT/libraries/joomla/factory.php:216

JROOT/plugins/system/k2/k2.php:52

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.52 ms** **After last query: 2.79 ms** **Query memory: 0.017 MB Memory before query: 9.199 MB**

UPDATE `nczdx_extensions`

  SET `params` = '{\"mediaversion\":\"16e8ad0789ede08b9558472d52bdf188\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
updating	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/cms/library/helper.php:119

JROOT/libraries/cms/version/version.php:240

JROOT/libraries/cms/version/version.php:199

JROOT/libraries/joomla/factory.php:736

JROOT/libraries/joomla/factory.php:216

JROOT/plugins/system/k2/k2.php:52

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.52 ms** **After last query: 5.57 ms** **Query memory: 0.018 MB Memory before query: 9.595 MB** **Rows returned: 1**

SELECT *

  FROM nczdx_languages

  WHERE published=1

  ORDER BY ordering ASC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/joomla/language/helper.php:164

JROOT/libraries/cms/application/site.php:329

JROOT/components/com_k2/helpers/utilities.php:315

JROOT/administrator/components/com_k2/helpers/html.php:56

JROOT/plugins/system/k2/k2.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.64 ms** **After last query: 4.55 ms** **Query memory: 0.024 MB Memory before query: 9.907 MB** **Rows returned: 3**

SELECT id, home, template, s.params

  FROM nczdx_template_styles as s

  LEFT JOIN nczdx_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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	rsm2015.s.template,const	1	100.00	Using index condition; Using where

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/cms/application/site.php:484

JROOT/libraries/cms/html/html.php:334

JROOT/libraries/cms/html/html.php:680

JROOT/libraries/cms/html/html.php:236

JROOT/libraries/cms/html/html.php:138

JROOT/libraries/cms/html/behavior.php:61

JROOT/libraries/cms/html/html.php:236

JROOT/libraries/cms/html/html.php:138

JROOT/administrator/components/com_k2/helpers/html.php:76

JROOT/plugins/system/k2/k2.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.57 ms** **After last query: 220.32 ms** **Query memory: 0.023 MB Memory before query: 22.035 MB** **Rows returned: 1**

SELECT a.rules

  FROM nczdx_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/joomla/access/access.php:246

JROOT/libraries/joomla/user/user.php:384

JROOT/components/com_content/models/articles.php:107

JROOT/components/com_content/models/featured.php:42

JROOT/libraries/legacy/model/legacy.php:431

JROOT/libraries/legacy/view/legacy.php:401

JROOT/components/com_content/views/featured/view.html.php:46

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.14 ms** **After last query: 1.42 ms** **Query memory: 0.024 MB Memory before query: 22.093 MB** **Rows returned: 2**

SELECT b.rules

  FROM nczdx_assets AS a

  LEFT JOIN nczdx_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	13	100.00	Using where

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.3 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/joomla/access/access.php:246

JROOT/libraries/joomla/access/access.php:107

JROOT/libraries/joomla/user/user.php:393

JROOT/components/com_content/models/articles.php:107

JROOT/components/com_content/models/featured.php:42

JROOT/libraries/legacy/model/legacy.php:431

JROOT/libraries/legacy/view/legacy.php:401

JROOT/components/com_content/views/featured/view.html.php:46

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 2.27 ms** **After last query: 1.66 ms** **Query memory: 0.021 MB Memory before query: 22.167 MB** **Rows returned: 1**

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM nczdx_content AS a

  LEFT JOIN nczdx_categories AS c 
  ON c.id = a.catid

  LEFT JOIN nczdx_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN nczdx_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN nczdx_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN nczdx_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM nczdx_categories AS cat JOIN nczdx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  INNER JOIN nczdx_content_frontpage AS fp 
  ON fp.content_id = a.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-13 02:50:49') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-13 02:50:49')

  ORDER BY c.lft,  a.featured DESC, fp.ordering,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created DESC   
  LIMIT 0, 4

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	fp	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using temporary; Using filesort
1	PRIMARY	a	eq_ref	PRIMARY,idx_access,idx_catid	PRIMARY	4	rsm2015.fp.content_id	1	100.00	Using where
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	rsm2015.a.catid	1	100.00	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	rsm2015.a.created_by	1	100.00	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	rsm2015.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	rsm2015.c.parent_id	1	100.00	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	rsm2015.a.id	1	100.00	Using where
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	rsm2015.c.id	3	100.00	Using where; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	18	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

**Profile**

Status	Duration
starting	0.4 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.2 ms
preparing	0.1 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
removing tmp table	0.0 ms
Creating sort index	0.4 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/legacy/model/legacy.php:304

JROOT/libraries/legacy/model/list.php:169

JROOT/components/com_content/models/articles.php:537

JROOT/components/com_content/models/featured.php:90

JROOT/libraries/legacy/view/legacy.php:401

JROOT/components/com_content/views/featured/view.html.php:47

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.68 ms** **After last query: 4.10 ms** **Query memory: 0.020 MB Memory before query: 22.438 MB** **Rows returned: 0**

SELECT `m`.`tag_id`,`t`.*

  FROM `nczdx_contentitem_tag_map` AS m 

  INNER JOIN `nczdx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 49 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	rsm2015.m.tag_id	1	100.00	Using where

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/cms/helper/tags.php:426

JROOT/components/com_content/models/articles.php:663

JROOT/components/com_content/models/featured.php:90

JROOT/libraries/legacy/view/legacy.php:401

JROOT/components/com_content/views/featured/view.html.php:47

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.24 ms** **After last query: 2.78 ms** **Query memory: 0.020 MB Memory before query: 22.566 MB** **Rows returned: 1**

SELECT COUNT(*)

  FROM nczdx_content AS a

  LEFT JOIN nczdx_categories AS c 
  ON c.id = a.catid

  LEFT JOIN nczdx_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN nczdx_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN nczdx_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN nczdx_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM nczdx_categories AS cat JOIN nczdx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  INNER JOIN nczdx_content_frontpage AS fp 
  ON fp.content_id = a.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-13 02:50:49') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-13 02:50:49')

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	fp	index	PRIMARY	PRIMARY	4	NULL	1	100.00	Using index
1	PRIMARY	a	eq_ref	PRIMARY,idx_access,idx_catid	PRIMARY	4	rsm2015.fp.content_id	1	100.00	Using where
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	rsm2015.a.catid	1	100.00	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	rsm2015.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	rsm2015.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	rsm2015.c.parent_id	1	100.00	Using where; Using index
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	rsm2015.a.id	1	100.00	Using where; Using index
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	rsm2015.c.id	3	100.00	Using where; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	18	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
removing tmp table	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/legacy/model/legacy.php:333

JROOT/libraries/legacy/model/list.php:274

JROOT/libraries/legacy/model/list.php:219

JROOT/libraries/legacy/view/legacy.php:401

JROOT/components/com_content/views/featured/view.html.php:48

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 2.18 ms** **After last query: 36.55 ms** **Query memory: 0.028 MB Memory before query: 23.779 MB** **Rows returned: 2**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM nczdx_categories as c

  LEFT JOIN nczdx_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM nczdx_categories AS cat JOIN nczdx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=2 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	18	77.78	Using where
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	rsm2015.c.id	3	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	18	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

**Profile**

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.1 ms
statistics	0.2 ms
preparing	0.1 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
removing tmp table	0.0 ms
Creating sort index	0.5 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/legacy/categories/categories.php:292

JROOT/libraries/legacy/categories/categories.php:184

JROOT/components/com_content/helpers/route.php:44

JROOT/templates/intensy/warp/systems/joomla/layouts/com_content/featured/default_item.php:19

JROOT/templates/intensy/html/com_content/featured/default_item.php:12

JROOT/libraries/legacy/view/legacy.php:670

JROOT/templates/intensy/warp/systems/joomla/layouts/com_content/featured/default.php:30

JROOT/templates/intensy/html/com_content/featured/default.php:12

JROOT/libraries/legacy/view/legacy.php:670

JROOT/libraries/legacy/view/legacy.php:209

JROOT/components/com_content/views/featured/view.html.php:152

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 2.10 ms** **After last query: 16.15 ms** **Query memory: 0.022 MB Memory before query: 24.432 MB** **Rows returned: 38**

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM nczdx_modules AS m

  LEFT JOIN nczdx_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN nczdx_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 <= '2019-12-13 02:50:49') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-13 02:50:49') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	76	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	rsm2015.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	rsm2015.m.id	1	100.00	Using where; Using index

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	1.3 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/cms/module/helper.php:408

JROOT/libraries/cms/module/helper.php:351

JROOT/libraries/cms/module/helper.php:84

JROOT/libraries/joomla/document/html/html.php:501

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54

JROOT/templates/intensy/layouts/theme.config.php:28

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.59 ms** **After last query: 47.50 ms** **Query memory: 0.028 MB Memory before query: 27.753 MB** **Rows returned: 1**

select * 
  from nczdx_revslider_sliders 
  where id=7

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_revslider_sliders	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:223

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:76

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:119

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:1909

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.56 ms** **After last query: 0.71 ms** **Query memory: 0.029 MB Memory before query: 27.809 MB** **Rows returned: 3**

select * 
  from nczdx_revslider_slides 
  where slider_id=7 
  order by slide_order

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_revslider_slides	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	16	100.00	Using where; Using filesort

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1452

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1345

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1531

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:260

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.41 ms** **After last query: 0.84 ms** **Query memory: 0.028 MB Memory before query: 27.865 MB** **Rows returned: 3**

**Duplicate queries**: #37 #38 #39

select * 
  from nczdx_revslider_layer_animations

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_revslider_layer_animations	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	NULL

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.40 ms** **After last query: 0.22 ms** **Query memory: 0.028 MB Memory before query: 27.894 MB** **Rows returned: 3**

**Duplicate queries**: #36 #38 #39

select * 
  from nczdx_revslider_layer_animations

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_revslider_layer_animations	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	NULL

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.40 ms** **After last query: 0.35 ms** **Query memory: 0.028 MB Memory before query: 27.922 MB** **Rows returned: 3**

**Duplicate queries**: #36 #37 #39

select * 
  from nczdx_revslider_layer_animations

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_revslider_layer_animations	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	NULL

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.38 ms** **After last query: 0.22 ms** **Query memory: 0.028 MB Memory before query: 27.951 MB** **Rows returned: 3**

**Duplicate queries**: #36 #37 #38

select * 
  from nczdx_revslider_layer_animations

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_revslider_layer_animations	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	NULL

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 3.47 ms** **After last query: 38.91 ms** **Query memory: 0.039 MB Memory before query: 28.089 MB** **Rows returned: 45**

SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.alias AS categoryalias,c.name AS category_title, c.alias AS category_alias,ua.name AS author_name

  FROM nczdx_k2_items AS a

  LEFT JOIN `nczdx_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN nczdx_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN nczdx_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN nczdx_k2_categories AS c 
  ON c.id = a.catid

  LEFT JOIN nczdx_users AS ua 
  ON ua.id = a.created_by

  WHERE a.published IN (1) 
  AND a.trash = 0 
  AND a.catid IN (21,22,23,24,28,29)

  ORDER BY a.hits desc  
  LIMIT 0, 45

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	item,catid	item	2	const	55	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	l	ALL	idx_langcode	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	rsm2015.a.checked_out	1	100.00	Using where
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	rsm2015.a.access	1	100.00	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	rsm2015.a.catid	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	rsm2015.a.created_by	1	100.00	NULL

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.1 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	1.5 ms
Creating sort index	0.9 ms
end	0.0 ms
removing tmp table	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:622

JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:791

JROOT/plugins/system/bdthemes_shortcodes/shortcodes/showcase/shortcode.php:53

JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:77

JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:42

JROOT/plugins/system/bdthemes_shortcodes/shortcodes/section/shortcode.php:163

JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:77

JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:42

JROOT/plugins/system/bdthemes_shortcodes/bdthemes_shortcodes.php:116

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/cms/html/content.php:41

JROOT/libraries/cms/html/html.php:236

JROOT/libraries/cms/html/html.php:104

JROOT/modules/mod_custom/mod_custom.php:15

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.61 ms** **After last query: 4653.38 ms** **Query memory: 0.023 MB Memory before query: 28.706 MB** **Rows returned: 3**

SELECT id
						
  FROM nczdx_k2_categories 
						
  WHERE parent IN (1) 
						
  AND id NOT IN (1) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1,5)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_k2_categories	range	PRIMARY,category,parent,published,access,trash	parent	9	NULL	9	100.00	Using index condition; Using where

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/components/com_k2/models/itemlist.php:642

JROOT/modules/mod_k2_content/helper.php:140

JROOT/modules/mod_k2_content/mod_k2_content.php:51

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.49 ms** **After last query: 0.13 ms** **Query memory: 0.023 MB Memory before query: 28.730 MB** **Rows returned: 0**

SELECT id
						
  FROM nczdx_k2_categories 
						
  WHERE parent IN (25,26,27) 
						
  AND id NOT IN (25,26,27) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1,5)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_k2_categories	ref	PRIMARY,category,parent,published,access,trash	category	2	const	22	100.00	Using index condition; Using where

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/components/com_k2/models/itemlist.php:642

JROOT/modules/mod_k2_content/helper.php:140

JROOT/modules/mod_k2_content/mod_k2_content.php:51

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.78 ms** **After last query: 0.14 ms** **Query memory: 0.022 MB Memory before query: 28.754 MB** **Rows returned: 3**

SELECT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM nczdx_k2_items as i RIGHT JOIN nczdx_k2_categories c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1,5) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1,5)  
  AND c.trash = 0 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-12-13 02:50:49' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-12-13 02:50:49' ) 
  AND i.catid IN (1,25,26,27) 
  AND i.featured != 1 
  ORDER BY i.publish_up DESC 
  LIMIT 0, 5

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	ALL	item,catid,featured	NO INDEX KEY COULD BE USED	NULL	NULL	33	18.18	Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	rsm2015.i.catid	1	100.00	Using where

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/modules/mod_k2_content/helper.php:268

JROOT/modules/mod_k2_content/mod_k2_content.php:51

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.38 ms** **After last query: 5.39 ms** **Query memory: 0.023 MB Memory before query: 29.352 MB** **Rows returned: 1**

SELECT COUNT(*) 
  FROM nczdx_k2_comments 
  WHERE itemID=119 
  AND published=1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/components/com_k2/models/item.php:1688

JROOT/modules/mod_k2_content/helper.php:376

JROOT/modules/mod_k2_content/mod_k2_content.php:51

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.31 ms** **After last query: 1.70 ms** **Query memory: 0.023 MB Memory before query: 29.415 MB** **Rows returned: 1**

SELECT COUNT(*) 
  FROM nczdx_k2_comments 
  WHERE itemID=86 
  AND published=1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/components/com_k2/models/item.php:1688

JROOT/modules/mod_k2_content/helper.php:376

JROOT/modules/mod_k2_content/mod_k2_content.php:51

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.30 ms** **After last query: 1.06 ms** **Query memory: 0.023 MB Memory before query: 29.446 MB** **Rows returned: 1**

SELECT COUNT(*) 
  FROM nczdx_k2_comments 
  WHERE itemID=87 
  AND published=1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/components/com_k2/models/item.php:1688

JROOT/modules/mod_k2_content/helper.php:376

JROOT/modules/mod_k2_content/mod_k2_content.php:51

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/templates/intensy/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/intensy/layouts/theme.config.php:76

JROOT/templates/intensy/layouts/theme.php:9

JROOT/templates/intensy/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/intensy/index.php:16

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.40 ms** **After last query: 246.73 ms** **Query memory: 0.016 MB Memory before query: 31.066 MB** **Rows returned: 78**

SELECT * 
  FROM nczdx_acymailing_config

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_acymailing_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	78	100.00	NULL

**Profile**

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/administrator/components/com_acymailing/classes/cpanel.php:17

JROOT/administrator/components/com_acymailing/helpers/helper.php:451

JROOT/administrator/components/com_acymailing/helpers/helper.php:958

JROOT/plugins/system/regacymailing/regacymailing.php:140

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1065

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.52 ms** **After last query: 357.81 ms** **Query memory: 0.003 MB Memory before query: 31.291 MB**

UPDATE `nczdx_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1576205448;s:18:\"session.timer.last\";i:1576205448;s:17:\"session.timer.now\";i:1576205448;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:1:{s:40:\"cc280ffdffab87aad84f81be8d8262495ffcf7dd\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"http://richsportsmgmt.com/index.php/2-uncategorised/49-featured-article\";s:6:\"expiry\";i:1576205449;}}}'
	, `time` = '1576205454'

  WHERE `session_id` = '1qusbl0370objti1jgc7adcmg7'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nczdx_session	range	PRIMARY	PRIMARY	602	const	1	100.00	Using where

**Profile**

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

**Call Stack**

JROOT/libraries/joomla/session/storage/database.php:84

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

**9 × SELECT `storage_value` 
  FROM `nczdx_securitycheckpro_storage`**

**4 × select * 
  from nczdx_revslider_layer_animation**

**3 × SELECT COUNT(*) 
  FROM nczdx_k2_comments**

**2 × SELECT id       
  FROM nczdx_k2_categories**

**2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM nczdx_extensions**

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM nczdx_modules AS m 
  LEFT JOIN nczdx_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN nczdx_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM nczdx_categories as c 
  LEFT JOIN nczdx_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM nczdx_categories AS cat JOIN nczdx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt**

**1 × SELECT COUNT(*) 
  FROM nczdx_content AS a 
  LEFT JOIN nczdx_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN nczdx_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN nczdx_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN nczdx_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN nczdx_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM nczdx_categories AS cat JOIN nczdx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt**

**1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `nczdx_contentitem_tag_map` AS m  
  INNER JOIN `nczdx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`**

**1 × select * 
  from nczdx_revslider_sliders**

**1 × SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.alias AS categoryalias,c.name AS category_title, c.alias AS category_alias,ua.name AS author_name 
  FROM nczdx_k2_items AS a 
  LEFT JOIN `nczdx_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN nczdx_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN nczdx_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN nczdx_k2_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN nczdx_users AS ua 
  ON ua.id = a.created_by**

**1 × SELECT * 
  FROM nczdx_acymailing_confi**

**1 × SELECT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
  FROM nczdx_k2_items as i RIGHT JOIN nczdx_k2_categories c 
  ON c.id = i.catid**

**1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM nczdx_content AS a 
  LEFT JOIN nczdx_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN nczdx_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN nczdx_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN nczdx_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN nczdx_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM nczdx_categories AS cat JOIN nczdx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt**

**1 × select * 
  from nczdx_revslider_slides**

**1 × SELECT a.rules 
  FROM nczdx_assets AS a**

**1 × SELECT folder AS type, element AS name, params 
  FROM nczdx_extensions**

**1 × SELECT COUNT(*) 
  from `nczdx_securitycheckpro_dynamic_blacklist`**

**1 × SELECT id, rules 
  FROM `nczdx_viewlevels**

**1 × SELECT b.id 
  FROM nczdx_usergroups AS a 
  LEFT JOIN nczdx_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt**

**1 × SELECT `session_id` 
  FROM `nczdx_session`**

**1 × SELECT `last_task` 
  FROM `nczdx_securitycheckpro_file_manager**

**1 × SELECT `last_check_integrity` 
  FROM `nczdx_securitycheckpro_file_manager**

**1 × SELECT id, home, template, s.params 
  FROM nczdx_template_styles as s 
  LEFT JOIN nczdx_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id**

**1 × SELECT `data` 
  FROM `nczdx_session`**

**1 × SELECT * 
  FROM nczdx_languages**

**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 nczdx_menu AS m 
  LEFT JOIN nczdx_extensions AS e 
  ON m.component_id = e.extension_id**

**1 × SELECT cron_tasks_launched 
  FROM nczdx_securitycheckpro_file_manager**

**1 × SELECT b.rules 
  FROM nczdx_assets AS a 
  LEFT JOIN nczdx_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt**

OTHER Tables:

**1 × UPDATE `nczdx_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1576205448;s:18:\"session.timer.last\";i:1576205448;s:17:\"session.timer.now\";i:1576205448;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:1:{s:40:\"cc280ffdffab87aad84f81be8d8262495ffcf7dd\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"http://richsportsmgmt.com/index.php/2-uncategorised/49-featured-article\";s:6:\"expiry\";i:1576205449;}}}'  , `time` = '1576205454'**

**1 × UPDATE `nczdx_extensions` 
  SET `params` = '{\"mediaversion\":\"16e8ad0789ede08b9558472d52bdf188\"}'**

**1 × DELETE 
  FROM `nczdx_securitycheckpro_dynamic_blacklist`**

**1 × INSERT INTO `nczdx_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('1qusbl0370objti1jgc7adcmg7', 0, '1576205448'**


# JROOT/plugins/system/bdthemes_shortcodes/config/data.php

HERE_YOU_CAN_SPECIFY_WMODE_VALUE_FOR_THE_EMBED_URL_BR_EXAMPLE_VALUES_BVALUETRANSPARENTB_BVALUEOPAQUEB="you can specify wmode value for the embed URL. 
 Example values: transparent, opaque"
PLG_SYSTEM_BDTHEMES_SHORTCODES_ADD_CODE="SYSTEM BDTHEMES SHORTCODES ADD CODE"
PLG_SYSTEM_BDTHEMES_SHORTCODES_ADD_CODE_DESC="SYSTEM BDTHEMES SHORTCODES ADD CODE DESC"
PLG_SYSTEM_BDTHEMES_SHORTCODES_CSS="SYSTEM BDTHEMES SHORTCODES CSS"
PLG_SYSTEM_BDTHEMES_SHORTCODES_FANCY_TEXT_TYPE_DESC="SYSTEM BDTHEMES SHORTCODES FANCY TEXT TYPE DESC"
PLG_SYSTEM_BDTHEMES_SHORTCODES_JS="SYSTEM BDTHEMES SHORTCODES JS"
URL="URL"
WMODE="WMode"

Welcome to Rich Sports Management

What Sets Us Apart

We ONLY

We DON'T

We ONLY

We DON'T

DAVID E. Rich

NOT JUST A NUMBER

TREATED LIKE A PRO

BE GOOD TO PEOPLE

CHECK OUT OUR AWESOME PLAYERS

SOME OF THE RICH SPORTS TEAM

OUR AMAZING SKILLS

Contract Negotiation

Legal Assistance, Advice and Representation

NFL Combine Training

G.M. and Player Personnel Interviewing Skills Session

Clients Testimonials

Recent News

VIDEO: Lucky Whitehead surprises his mother at the Manassas Boys and Girls Club with a new car

Matt Brei Joins Rich Sports as Midwest Region Agent

Recent News

The NFL Combine 5 Year Draft Averages by Position

Popular Brands

Office Locations

Stay In Touch

Who We Are

KEEP IN TOUCH

**Joomla! Debug Console**

**Session**

__default

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**48 Queries Logged** 43.8 ms

**10 duplicate found!**

**33 Query Types Logged, Sorted by Occurrences.**

**SELECT Tables:**

**OTHER Tables:**

**Parsing errors in language files**

**Language Files Loaded**

**Untranslated Strings**

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

48 Queries Logged 43.8 ms

10 duplicate found!

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings