Call CIADA

Vendor Spotlight

CIADA Dealer Membership Application

Are you looking to join as an Associate / Vendor Member?

Dealer Membership

CIADA *

Dealer Member

Dealer Member (2 yr)

NIADA *

Membership (included)

Total Amount

On Behalf Of Organization

Additional Customer Information

Please Enter Comments Below

Credit Card

Card Type

Card Number *

Security Code *

Expiration Date *

Billing Name and Address

Billing First Name *

Billing Middle Name

Billing Last Name *

Street Address *

City *

Country *

State/Province *

Postal Code *

Dealer Membership Benefits

Member Education

We are your source for Continuing Education requirements. We also provide workshops, seminars, compliance updates and a bi-monthly news magazine so that you can stay informed about the industry.

The 65th Annual Conventions & Expo

Share in the excitement as we come together for education, open forums, key speakers, and a chance to talk to fellow car dealers from across the country.

Your state association arranges special promotions on behalf of its members such as the Auction Coupon app.Over $5,000 in savingsoff your buy/sell fees at the auctions in North & South Carolina, as well as out of state auctions.

Dealer News & Updates

All members are provided the opportunity to receive regular updates via email. These emails cover all issues ie: Federal FTC & Consumer Financial Protection Bureau, State DMV, IRS, NTSB Recalls and much more.

Legislative Updates

We monitor both states General Assembly to advocate for and fight on your behalf against potential legislation that impacts your dealership and the used car industry. Remember .. "If you are not at the negotiating table, you might be on the table"

Vendor Referrals

CIADA and NIADA work diligently to pair together members and vendors for a successful and profitable association.

CIADA Auto Dealer News

Our bi-monthly magazine provides you with the latest news, regulation changes and information about the used car industry from a variety of expert and guest columnists.

NIADA Membership

CIADA pays your dues to include your dealership as a member of the NIADA, your National Association.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1618570041,
                "last": 1618570041,
                "now": 1618570041
            },
            "token": "HK281Gdto5TGxWF4uk4d27PtQNW0NCoM"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Profile Information

Time

Memory

Time: 23.88 ms / 23.88 ms Memory: 0.702 MB / 1.07 MB Application: afterLoad

Time: 139.05 ms / 162.92 ms Memory: 3.336 MB / 4.41 MB Application: afterInitialise

Time: 62.58 ms / 225.50 ms Memory: 1.290 MB / 5.70 MB Application: afterRoute

Time: 0.53 ms / 226.03 ms Memory: 0.012 MB / 5.71 MB Application: beforeRenderComponent com_civicrm

Time: 172.97 ms / 399.01 ms Memory: 3.457 MB / 9.17 MB Application: Before Access::preloadComponents (all components)

Time: 0.96 ms / 399.97 ms Memory: 0.063 MB / 9.23 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 399.99 ms Memory: 0.000 MB / 9.23 MB Application: Before Access::getAssetRules (id:731 name:com_civicrm)

Time: 0.83 ms / 400.82 ms Memory: 0.044 MB / 9.27 MB Application: After Access::getAssetRules (id:731 name:com_civicrm)

Time: 361.35 ms / 762.18 ms Memory: 6.177 MB / 15.45 MB Application: afterRenderComponent com_civicrm

Time: 2.39 ms / 764.56 ms Memory: 0.009 MB / 15.46 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.04 ms / 764.61 ms Memory: 0.007 MB / 15.46 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 12.10 ms / 776.70 ms Memory: 0.288 MB / 15.75 MB Application: afterDispatch

Time: 72.63 ms / 849.33 ms Memory: 1.781 MB / 17.53 MB Application: beforeRenderModule mod_widgetkit (Vendor Spotlight)

Time: 30.88 ms / 880.21 ms Memory: 1.028 MB / 18.56 MB Application: afterRenderModule mod_widgetkit (Vendor Spotlight)

Time: 0.34 ms / 880.55 ms Memory: 0.000 MB / 18.56 MB Application: beforeRenderModule mod_custom (Carolinas Independent Automobile Dealers Association)

Time: 0.37 ms / 880.92 ms Memory: 0.006 MB / 18.57 MB Application: afterRenderModule mod_custom (Carolinas Independent Automobile Dealers Association)

Time: 0.17 ms / 881.10 ms Memory: 0.000 MB / 18.56 MB Application: beforeRenderModule mod_custom (Become a Member)

Time: 0.06 ms / 881.16 ms Memory: 0.004 MB / 18.57 MB Application: afterRenderModule mod_custom (Become a Member)

Time: 1.50 ms / 882.66 ms Memory: 0.009 MB / 18.58 MB Application: beforeRenderModule mod_widgetkit (Dealer Membership Benefits)

Time: 7.06 ms / 889.72 ms Memory: 0.655 MB / 19.23 MB Application: afterRenderModule mod_widgetkit (Dealer Membership Benefits)

Time: 1.37 ms / 891.09 ms Memory: 0.011 MB / 19.24 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 0.07 ms / 891.17 ms Memory: 0.003 MB / 19.25 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 0.14 ms / 891.30 ms Memory: 0.000 MB / 19.25 MB Application: beforeRenderModule mod_custom (Download our App!)

Time: 0.06 ms / 891.37 ms Memory: 0.003 MB / 19.25 MB Application: afterRenderModule mod_custom (Download our App!)

Time: 0.13 ms / 891.50 ms Memory: 0.000 MB / 19.25 MB Application: beforeRenderModule mod_custom (Become a Member)

Time: 0.07 ms / 891.57 ms Memory: 0.003 MB / 19.25 MB Application: afterRenderModule mod_custom (Become a Member)

Time: 0.14 ms / 891.72 ms Memory: 0.000 MB / 19.25 MB Application: beforeRenderModule mod_widgetkit (Vendor Spotlight)

Time: 1.42 ms / 893.14 ms Memory: 0.062 MB / 19.31 MB Application: afterRenderModule mod_widgetkit (Vendor Spotlight)

Time: 60.12 ms / 953.25 ms Memory: 1.085 MB / 20.40 MB Application: afterRender

Database queries total: 17.47 ms

Memory Usage

Database Queries

40 Queries Logged 17.47 ms

4 duplicate found!

2 duplicates: #32 #39

2 duplicates: #34 #40

Query Time: 0.30 ms Query memory: 0.022 MB Memory before query: 1.606 MB Rows returned: 0

SELECT `session_id`

  FROM `ccroe_session`

  WHERE `session_id` = 'a7eba336bff2f06eb30fffb4bb722ebf' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ccroe_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.95 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 1.612 MB

INSERT INTO `ccroe_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('a7eba336bff2f06eb30fffb4bb722ebf', 1, 1618570041, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `ccroe_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('a7eba336bff2f06eb30fffb4bb722ebf', 1, 1618570041, 0, '', 0)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.05 ms
end	0.00 ms
query end	0.76 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.46 ms After last query: 4.12 ms Query memory: 0.059 MB Memory before query: 1.648 MB Rows returned: 43

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

  FROM `ccroe_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ccroe_extensions	NULL	ref	extension	extension	82	const	43	1.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 3.48 ms Query memory: 0.023 MB Memory before query: 1.777 MB Rows returned: 6

SELECT id, rules

  FROM `ccroe_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.07 ms Query memory: 0.022 MB Memory before query: 1.790 MB Rows returned: 2

SELECT b.id

  FROM ccroe_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.16 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 1.26 ms Query memory: 0.039 MB Memory before query: 1.812 MB Rows returned: 143

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM ccroe_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ccroe_extensions	NULL	ref	extension	extension	82	const	174	0.60	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.49 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 7.55 ms Query memory: 0.023 MB Memory before query: 2.171 MB Rows returned: 0

SELECT `path`

  FROM ccroe_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 2.177 MB Rows returned: 0

SELECT `file`

  FROM ccroe_rsfirewall_hashes

  WHERE `type`='protect'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.028 MB Memory before query: 2.183 MB Rows returned: 57

SELECT *

  FROM ccroe_rsfirewall_configuration

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 6.26 ms Query memory: 0.028 MB Memory before query: 2.411 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `ccroe_rsfirewall_logs`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ccroe_rsfirewall_logs`

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.07 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:47
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.09 ms After last query: 30.13 ms Query memory: 0.091 MB Memory before query: 2.993 MB Rows returned: 90

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

  LEFT JOIN ccroe_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	101	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	theciada_prodemo.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.65 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/shlib/shlib_runtime.php:70
8	plgSystemShlib->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 17.08 ms Query memory: 0.027 MB Memory before query: 3.745 MB Rows returned: 1

SELECT id,template 
  FROM ccroe_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ccroe_template_styles	NULL	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	14.29	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
8	plgSystemWidgetkit->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 11.48 ms Query memory: 0.028 MB Memory before query: 3.965 MB Rows returned: 1

SELECT *

  FROM ccroe_languages

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:215
12	Sh404sefHelperLanguage::getAllContentLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:167
11	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84
10	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100
9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:63
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 12.97 ms Query memory: 0.024 MB Memory before query: 4.187 MB Rows returned: 1

SELECT `params` 
  FROM ccroe_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ccroe_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:160
11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:665
10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121
9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:86
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 29.52 ms Query memory: 0.028 MB Memory before query: 4.741 MB Rows returned: 0

SELECT * 
  FROM `ccroe_sh404sef_aliases` 
  WHERE `state` = 1 
  and (`alias` = 'index.php?option=com_civicrm&view=Contributions&task=civicrm/contribute/transact&id=1&reset=1&Itemid=268&lang=en' or `alias` = 'index.php?option=com_civicrm&amp;view=Contributions&amp;task=civicrm/contribute/transact&amp;id=1&amp;reset=1&amp;Itemid=268&amp;lang=en') 
  order by `ordering` asc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ccroe_sh404sef_aliases	NULL	range	state,alias	alias	573	NULL	2	95.45	Using where; Using filesort

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
16	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/models/redirector.php:221
15	Sh404sefModelRedirector->findHardcodedMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:115
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:86
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:681
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:280
10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 4.749 MB Rows returned: 0

SELECT * 
  FROM ccroe_sh404sef_aliases 
  WHERE state = 1 
  and (type = 1 or type = 2);

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ccroe_sh404sef_aliases	NULL	range	type,state	type	1	NULL	2	95.45	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/redirector.php:285
15	Sh404sefModelRedirector->findWildcardMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:116
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:86
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:681
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:280
10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.74 ms Query memory: 0.024 MB Memory before query: 4.764 MB Rows returned: 0

SELECT *

  FROM ccroe_rsfirewall_hashes

  WHERE (`type`='3.9.8' OR `type`='protect') 
  AND `flag`!='C'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1008
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.57 ms Query memory: 0.023 MB Memory before query: 4.771 MB Rows returned: 0

SELECT *

  FROM ccroe_rsfirewall_snapshots

  WHERE `type`='protect'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1031
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 4.777 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM ccroe_rsfirewall_lists

  WHERE (`ip`='18.204.2.190' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
9	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1067
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 4.783 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM ccroe_rsfirewall_lists

  WHERE (`ip`='18.204.2.190' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:134
9	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1071
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.96 ms Query memory: 0.024 MB Memory before query: 4.789 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM ccroe_template_styles as s

  LEFT JOIN ccroe_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	7	14.29	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	theciada_prodemo.s.template,const	1	4.41	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:195
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 19.13 ms Query memory: 0.029 MB Memory before query: 5.263 MB Rows returned: 1

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

  FROM `ccroe_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ccroe_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
23	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
22	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
19	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
18	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
17	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
14	Joomla\CMS\Factory::getDocument()	JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163
13	Gantry\Framework\Theme->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67
12	Gantry\Component\Theme\AbstractTheme->__construct()	JROOT/templates/rt_zenith/includes/theme.php:28
11	plgSystemGantry5->{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118
10	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:234
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.83 ms After last query: 0.13 ms Query memory: 0.008 MB Memory before query: 5.258 MB

UPDATE `ccroe_extensions`

  SET `params` = '{\"mediaversion\":\"ee8a1a0eab791add62cc87c7b4a4b76d\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ccroe_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.04 ms
updating	0.05 ms
end	0.01 ms
query end	0.59 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
18	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
17	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
14	Joomla\CMS\Factory::getDocument()	JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163
13	Gantry\Framework\Theme->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67
12	Gantry\Component\Theme\AbstractTheme->__construct()	JROOT/templates/rt_zenith/includes/theme.php:28
11	plgSystemGantry5->{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118
10	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:234
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 7.91 ms Query memory: 0.025 MB Memory before query: 5.431 MB Rows returned: 3

SELECT s.id, s.template, s.home, s.title AS long_title, s.params

  FROM ccroe_template_styles AS s

  WHERE s.client_id = 0 
  AND s.template = 'rt_zenith'

  ORDER BY s.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	index	idx_template	PRIMARY	4	NULL	7	14.29	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46
14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50
13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:303
12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104
11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91
10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:246
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 10.06 ms Query memory: 0.025 MB Memory before query: 5.699 MB Rows returned: 1

SELECT *

  FROM ccroe_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 173.18 ms Query memory: 0.031 MB Memory before query: 9.170 MB Rows returned: 43

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `ccroe_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_civicrm','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsfirewall','com_rstbox','com_search','com_sh404sef','com_tags','com_templates','com_users','com_widgetkit','com_wrapper','com_zcalendar','com_zoo')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ccroe_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	44	100.00	Using index condition

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.35 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Permission/Joomla.php:74
11	CRM_Core_Permission_Joomla->check()	JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Permission.php:122
10	CRM_Core_Permission::check()	JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Resources.php:756
9	CRM_Core_Resources->coreResourceList()	JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Resources.php:601
8	CRM_Core_Resources->addCoreResources()	JROOT/components/com_civicrm/civicrm.php:90
7	civicrm_invoke()	JROOT/components/com_civicrm/civicrm.php:11
6	require_once JROOT/components/com_civicrm/civicrm.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 364.75 ms Query memory: 0.024 MB Memory before query: 15.461 MB Rows returned: 0

select b.* 
  from ccroe_rstbox b 
  where b.published = 1  
  AND b.testmode=0

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rstbox/helpers/helper.php:242
8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 10.49 ms Query memory: 0.037 MB Memory before query: 15.677 MB Rows returned: 36

SHOW FULL COLUMNS 
  FROM `ccroe_sh404sef_metas`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ccroe_sh404sef_metas`

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.12 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:138
14	Sh404sefTableMetas->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:37
12	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
11	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:118
10	Sh404sefHelperMetadata::getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:190
9	Sh404sefHelperMetadata::getFinalizedCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:389
8	Sh404sefHelperMetadata::insertMetaData()	JROOT/plugins/system/sh404sef/sh404sef.php:238
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.10 ms Query memory: 0.039 MB Memory before query: 15.743 MB Rows returned: 0

SELECT * 
  FROM ccroe_sh404sef_metas 
  WHERE `newurl`='index.php?option=com_civicrm&Itemid=268&id=1&lang=en&reset=1&task=civicrm/contribute/transact&view=Contributions';

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
15	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
14	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
13	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:38
12	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
11	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:118
10	Sh404sefHelperMetadata::getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:190
9	Sh404sefHelperMetadata::getFinalizedCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:389
8	Sh404sefHelperMetadata::insertMetaData()	JROOT/plugins/system/sh404sef/sh404sef.php:238
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 56.09 ms Query memory: 0.039 MB Memory before query: 17.080 MB Rows returned: 3

SELECT a.menutype

  FROM ccroe_menu_types AS a

  WHERE a.client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	33.33	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
51	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_menus/helpers/menus.php:154
50	MenusHelper::getMenuTypes()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71
49	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115
48	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/26/2619b53881db39fe41cbd0c55570d66ed09dfc87da99f5b1de45c711c935d861.php:46
46	__TwigTemplate_c5b53c0ffa438ee7b43b3036b125eaf59ca0957167bd0bb9684f846a0dc0d818->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_zenith/twig/96/96a10cd75d06f45e1906d68a1a9f53fceec7da502718fa841ee950c43ef28656.php:73
44	__TwigTemplate_72980bb5c4dee0864bd865e5433b0eaa57a4b2010099f5139bf2ae2163baa879->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/26/2619b53881db39fe41cbd0c55570d66ed09dfc87da99f5b1de45c711c935d861.php:36
41	__TwigTemplate_c5b53c0ffa438ee7b43b3036b125eaf59ca0957167bd0bb9684f846a0dc0d818->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/44/4489b6638a79fe0494c926a955e8d4bd8a5765006d418d6285018a5eacd8f9f0.php:71
38	__TwigTemplate_baa99ada4f2f04a0f421a4ffaf7d034705035f393b28cf6561d005c5243a62a2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/e1/e115e15b7afc7be8fa0760d7238614bd34f9c9c6038781dbc9d8d6b4009f39d1.php:47
20	__TwigTemplate_2a78621a090cc0f25207fd2ae1e5a4ec08c738c722d73b33ecf017d1865192c1->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/46/464ae1ee08e3f27a273d603331ec193708e1bc2ca1d7c2744fe80eed0b0a6f26.php:35
17	__TwigTemplate_126d5021e40b11667324636531dc8e4846dfcae23d9f18b23547ca2200822947->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/a9/a9b7c1be1a7f81f5aeee3f3d1537bc192544451fcc51b322b79c808b869fd5b9.php:35
14	__TwigTemplate_2b44cdb8eb26fe3dc7f035a50a421519d186995b29bc78a3f843ba6b67e00753->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_zenith/index.php:23
7	require JROOT/templates/rt_zenith/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.35 ms After last query: 14.40 ms Query memory: 0.044 MB Memory before query: 17.513 MB Rows returned: 8

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

  FROM ccroe_modules AS m

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

  LEFT JOIN ccroe_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 <= '2021-04-16 10:47:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-16 10:47:21') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 268 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	84	1.60	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	theciada_prodemo.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	theciada_prodemo.m.id	1	40.00	Using where; Using index

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.81 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
54	JDatabaseDriver->loadObjectList()	Same as call in the line below.
53	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
52	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
51	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
50	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
49	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:43
46	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_zenith/twig/96/96a10cd75d06f45e1906d68a1a9f53fceec7da502718fa841ee950c43ef28656.php:73
44	__TwigTemplate_72980bb5c4dee0864bd865e5433b0eaa57a4b2010099f5139bf2ae2163baa879->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:35
41	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/67/672e8f5136c71ccc255853ae76ab57593a0f6bb61f286f7b65d197470b8a6170.php:53
38	__TwigTemplate_7ec6e0365de7d68d77ce9f8b9dc462c1d79cf16d631d33c28bb51c341637e2ff->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/e1/e115e15b7afc7be8fa0760d7238614bd34f9c9c6038781dbc9d8d6b4009f39d1.php:47
20	__TwigTemplate_2a78621a090cc0f25207fd2ae1e5a4ec08c738c722d73b33ecf017d1865192c1->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/46/464ae1ee08e3f27a273d603331ec193708e1bc2ca1d7c2744fe80eed0b0a6f26.php:35
17	__TwigTemplate_126d5021e40b11667324636531dc8e4846dfcae23d9f18b23547ca2200822947->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/a9/a9b7c1be1a7f81f5aeee3f3d1537bc192544451fcc51b322b79c808b869fd5b9.php:35
14	__TwigTemplate_2b44cdb8eb26fe3dc7f035a50a421519d186995b29bc78a3f843ba6b67e00753->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_zenith/index.php:23
7	require JROOT/templates/rt_zenith/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 1.84 ms Query memory: 0.043 MB Memory before query: 17.618 MB Rows returned: 1

Duplicate queries: #39

SELECT * 
  FROM ccroe_widgetkit 
  WHERE id = "31"

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
60	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
59	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/Database.php:35
58	YOOtheme\Framework\Joomla\Database->fetchAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Database/Database.php:88
57	YOOtheme\Framework\Database\Database->fetchObject()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:44
56	YOOtheme\Widgetkit\Content\ContentProvider->find()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:30
55	YOOtheme\Widgetkit\Content\ContentProvider->get()	JROOT/administrator/components/com_widgetkit/src/Application.php:151
54	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
53	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
52	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:43
46	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_zenith/twig/96/96a10cd75d06f45e1906d68a1a9f53fceec7da502718fa841ee950c43ef28656.php:73
44	__TwigTemplate_72980bb5c4dee0864bd865e5433b0eaa57a4b2010099f5139bf2ae2163baa879->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:35
41	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/67/672e8f5136c71ccc255853ae76ab57593a0f6bb61f286f7b65d197470b8a6170.php:53
38	__TwigTemplate_7ec6e0365de7d68d77ce9f8b9dc462c1d79cf16d631d33c28bb51c341637e2ff->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/e1/e115e15b7afc7be8fa0760d7238614bd34f9c9c6038781dbc9d8d6b4009f39d1.php:47
20	__TwigTemplate_2a78621a090cc0f25207fd2ae1e5a4ec08c738c722d73b33ecf017d1865192c1->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/46/464ae1ee08e3f27a273d603331ec193708e1bc2ca1d7c2744fe80eed0b0a6f26.php:35
17	__TwigTemplate_126d5021e40b11667324636531dc8e4846dfcae23d9f18b23547ca2200822947->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/a9/a9b7c1be1a7f81f5aeee3f3d1537bc192544451fcc51b322b79c808b869fd5b9.php:35
14	__TwigTemplate_2b44cdb8eb26fe3dc7f035a50a421519d186995b29bc78a3f843ba6b67e00753->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_zenith/index.php:23
7	require JROOT/templates/rt_zenith/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 5.63 ms Query memory: 0.047 MB Memory before query: 17.778 MB Rows returned: 1

SELECT * 
  FROM ccroe_zoo_application 
  WHERE id = 8

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
64	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
63	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
62	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
61	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
60	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
59	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/module.php:106
58	ModuleHelper->getItems()	JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:38
57	YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems()	JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102
56	YOOtheme\Widgetkit\Content\Content->getItems()	JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44
55	YOOtheme\Widgetkit\Widget\Widget->render()	JROOT/administrator/components/com_widgetkit/src/Application.php:163
54	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
53	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
52	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:43
46	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_zenith/twig/96/96a10cd75d06f45e1906d68a1a9f53fceec7da502718fa841ee950c43ef28656.php:73
44	__TwigTemplate_72980bb5c4dee0864bd865e5433b0eaa57a4b2010099f5139bf2ae2163baa879->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:35
41	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/67/672e8f5136c71ccc255853ae76ab57593a0f6bb61f286f7b65d197470b8a6170.php:53
38	__TwigTemplate_7ec6e0365de7d68d77ce9f8b9dc462c1d79cf16d631d33c28bb51c341637e2ff->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/e1/e115e15b7afc7be8fa0760d7238614bd34f9c9c6038781dbc9d8d6b4009f39d1.php:47
20	__TwigTemplate_2a78621a090cc0f25207fd2ae1e5a4ec08c738c722d73b33ecf017d1865192c1->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/46/464ae1ee08e3f27a273d603331ec193708e1bc2ca1d7c2744fe80eed0b0a6f26.php:35
17	__TwigTemplate_126d5021e40b11667324636531dc8e4846dfcae23d9f18b23547ca2200822947->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/a9/a9b7c1be1a7f81f5aeee3f3d1537bc192544451fcc51b322b79c808b869fd5b9.php:35
14	__TwigTemplate_2b44cdb8eb26fe3dc7f035a50a421519d186995b29bc78a3f843ba6b67e00753->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_zenith/index.php:23
7	require JROOT/templates/rt_zenith/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.74 ms After last query: 5.22 ms Query memory: 0.048 MB Memory before query: 17.904 MB Rows returned: 1

Duplicate queries: #40

SELECT a.* 
  FROM ccroe_zoo_item AS a 
  LEFT JOIN ccroe_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 8 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-16 10:47:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-16 10:47:21') 
  AND b.category_id  = 46 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.name 
  LIMIT 0,1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	1	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	theciada_prodemo.b.item_id	1	17.73	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.16 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
62	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
61	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
60	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:467
59	ItemTable->getByCategory()	JROOT/administrator/components/com_zoo/helpers/module.php:125
58	ModuleHelper->getItems()	JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:38
57	YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems()	JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102
56	YOOtheme\Widgetkit\Content\Content->getItems()	JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44
55	YOOtheme\Widgetkit\Widget\Widget->render()	JROOT/administrator/components/com_widgetkit/src/Application.php:163
54	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
53	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
52	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:43
46	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_zenith/twig/96/96a10cd75d06f45e1906d68a1a9f53fceec7da502718fa841ee950c43ef28656.php:73
44	__TwigTemplate_72980bb5c4dee0864bd865e5433b0eaa57a4b2010099f5139bf2ae2163baa879->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:35
41	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/67/672e8f5136c71ccc255853ae76ab57593a0f6bb61f286f7b65d197470b8a6170.php:53
38	__TwigTemplate_7ec6e0365de7d68d77ce9f8b9dc462c1d79cf16d631d33c28bb51c341637e2ff->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/e1/e115e15b7afc7be8fa0760d7238614bd34f9c9c6038781dbc9d8d6b4009f39d1.php:47
20	__TwigTemplate_2a78621a090cc0f25207fd2ae1e5a4ec08c738c722d73b33ecf017d1865192c1->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/46/464ae1ee08e3f27a273d603331ec193708e1bc2ca1d7c2744fe80eed0b0a6f26.php:35
17	__TwigTemplate_126d5021e40b11667324636531dc8e4846dfcae23d9f18b23547ca2200822947->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/a9/a9b7c1be1a7f81f5aeee3f3d1537bc192544451fcc51b322b79c808b869fd5b9.php:35
14	__TwigTemplate_2b44cdb8eb26fe3dc7f035a50a421519d186995b29bc78a3f843ba6b67e00753->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_zenith/index.php:23
7	require JROOT/templates/rt_zenith/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 7.57 ms Query memory: 0.057 MB Memory before query: 18.451 MB Rows returned: 18

SELECT * 
  FROM ccroe_zoo_category 
  WHERE application_id = 8 
  AND published = 1 
  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ccroe_zoo_category	NULL	ref	PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	APPLICATIONID_ID_INDEX	5	const,const	18	100.00	Using index condition; Using filesort

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.18 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
70	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
69	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
68	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
67	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
66	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:230
65	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
64	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
63	Application->getCategoryTree()	JROOT/administrator/components/com_zoo/helpers/route.php:295
62	RouteHelper->item()	JROOT/plugins/system/widgetkit_zoo/plugin/src/Transformer.php:46
61	YOOtheme\Widgetkit\Joomla\Zoo\Transformer->renderItemlink()	Same as call in the line below.
60	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
59	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:132
58	YOOtheme\Framework\Application->trigger()	JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:56
57	YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems()	JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102
56	YOOtheme\Widgetkit\Content\Content->getItems()	JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44
55	YOOtheme\Widgetkit\Widget\Widget->render()	JROOT/administrator/components/com_widgetkit/src/Application.php:163
54	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
53	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
52	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:43
46	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_zenith/twig/96/96a10cd75d06f45e1906d68a1a9f53fceec7da502718fa841ee950c43ef28656.php:73
44	__TwigTemplate_72980bb5c4dee0864bd865e5433b0eaa57a4b2010099f5139bf2ae2163baa879->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:35
41	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/67/672e8f5136c71ccc255853ae76ab57593a0f6bb61f286f7b65d197470b8a6170.php:53
38	__TwigTemplate_7ec6e0365de7d68d77ce9f8b9dc462c1d79cf16d631d33c28bb51c341637e2ff->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/e1/e115e15b7afc7be8fa0760d7238614bd34f9c9c6038781dbc9d8d6b4009f39d1.php:47
20	__TwigTemplate_2a78621a090cc0f25207fd2ae1e5a4ec08c738c722d73b33ecf017d1865192c1->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/46/464ae1ee08e3f27a273d603331ec193708e1bc2ca1d7c2744fe80eed0b0a6f26.php:35
17	__TwigTemplate_126d5021e40b11667324636531dc8e4846dfcae23d9f18b23547ca2200822947->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/a9/a9b7c1be1a7f81f5aeee3f3d1537bc192544451fcc51b322b79c808b869fd5b9.php:35
14	__TwigTemplate_2b44cdb8eb26fe3dc7f035a50a421519d186995b29bc78a3f843ba6b67e00753->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_zenith/index.php:23
7	require JROOT/templates/rt_zenith/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 11.90 ms Query memory: 0.044 MB Memory before query: 18.629 MB Rows returned: 1

SELECT * 
  FROM ccroe_widgetkit 
  WHERE id = "9"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
63	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
62	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/Database.php:35
61	YOOtheme\Framework\Joomla\Database->fetchAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Database/Database.php:88
60	YOOtheme\Framework\Database\Database->fetchObject()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:44
59	YOOtheme\Widgetkit\Content\ContentProvider->find()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:30
58	YOOtheme\Widgetkit\Content\ContentProvider->get()	JROOT/administrator/components/com_widgetkit/src/Application.php:151
57	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
56	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
55	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
54	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
53	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
52	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
51	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
50	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:43
49	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
48	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_zenith/twig/96/96a10cd75d06f45e1906d68a1a9f53fceec7da502718fa841ee950c43ef28656.php:73
47	__TwigTemplate_72980bb5c4dee0864bd865e5433b0eaa57a4b2010099f5139bf2ae2163baa879->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
46	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
45	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:35
44	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/67/672e8f5136c71ccc255853ae76ab57593a0f6bb61f286f7b65d197470b8a6170.php:53
41	__TwigTemplate_7ec6e0365de7d68d77ce9f8b9dc462c1d79cf16d631d33c28bb51c341637e2ff->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
38	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
37	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
36	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
35	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
34	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
33	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
32	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
31	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
30	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/e1/e115e15b7afc7be8fa0760d7238614bd34f9c9c6038781dbc9d8d6b4009f39d1.php:47
20	__TwigTemplate_2a78621a090cc0f25207fd2ae1e5a4ec08c738c722d73b33ecf017d1865192c1->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/46/464ae1ee08e3f27a273d603331ec193708e1bc2ca1d7c2744fe80eed0b0a6f26.php:35
17	__TwigTemplate_126d5021e40b11667324636531dc8e4846dfcae23d9f18b23547ca2200822947->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/a9/a9b7c1be1a7f81f5aeee3f3d1537bc192544451fcc51b322b79c808b869fd5b9.php:35
14	__TwigTemplate_2b44cdb8eb26fe3dc7f035a50a421519d186995b29bc78a3f843ba6b67e00753->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_zenith/index.php:23
7	require JROOT/templates/rt_zenith/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.14 ms Query memory: 0.052 MB Memory before query: 18.679 MB Rows returned: 1

SELECT * 
  FROM ccroe_zoo_application 
  WHERE id = 6

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
67	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
66	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
65	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
64	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
63	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
62	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/module.php:106
61	ModuleHelper->getItems()	JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:38
60	YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems()	JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102
59	YOOtheme\Widgetkit\Content\Content->getItems()	JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44
58	YOOtheme\Widgetkit\Widget\Widget->render()	JROOT/administrator/components/com_widgetkit/src/Application.php:163
57	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
56	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
55	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
54	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
53	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
52	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
51	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
50	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:43
49	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
48	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_zenith/twig/96/96a10cd75d06f45e1906d68a1a9f53fceec7da502718fa841ee950c43ef28656.php:73
47	__TwigTemplate_72980bb5c4dee0864bd865e5433b0eaa57a4b2010099f5139bf2ae2163baa879->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
46	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
45	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:35
44	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/67/672e8f5136c71ccc255853ae76ab57593a0f6bb61f286f7b65d197470b8a6170.php:53
41	__TwigTemplate_7ec6e0365de7d68d77ce9f8b9dc462c1d79cf16d631d33c28bb51c341637e2ff->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
38	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
37	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
36	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
35	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
34	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
33	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
32	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
31	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
30	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/e1/e115e15b7afc7be8fa0760d7238614bd34f9c9c6038781dbc9d8d6b4009f39d1.php:47
20	__TwigTemplate_2a78621a090cc0f25207fd2ae1e5a4ec08c738c722d73b33ecf017d1865192c1->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/46/464ae1ee08e3f27a273d603331ec193708e1bc2ca1d7c2744fe80eed0b0a6f26.php:35
17	__TwigTemplate_126d5021e40b11667324636531dc8e4846dfcae23d9f18b23547ca2200822947->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/a9/a9b7c1be1a7f81f5aeee3f3d1537bc192544451fcc51b322b79c808b869fd5b9.php:35
14	__TwigTemplate_2b44cdb8eb26fe3dc7f035a50a421519d186995b29bc78a3f843ba6b67e00753->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_zenith/index.php:23
7	require JROOT/templates/rt_zenith/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.71 ms After last query: 0.51 ms Query memory: 0.057 MB Memory before query: 18.723 MB Rows returned: 8

SELECT a.* 
  FROM ccroe_zoo_item AS a 
  LEFT JOIN ccroe_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 6 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-16 10:47:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-16 10:47:21') 
  AND b.category_id  = 10 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.name 
  LIMIT 0,10

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	7	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	theciada_prodemo.b.item_id	1	5.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.20 ms
Creating sort index	0.07 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
65	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
64	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
63	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:467
62	ItemTable->getByCategory()	JROOT/administrator/components/com_zoo/helpers/module.php:125
61	ModuleHelper->getItems()	JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:38
60	YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems()	JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102
59	YOOtheme\Widgetkit\Content\Content->getItems()	JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44
58	YOOtheme\Widgetkit\Widget\Widget->render()	JROOT/administrator/components/com_widgetkit/src/Application.php:163
57	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
56	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
55	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
54	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
53	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
52	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
51	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
50	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:43
49	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
48	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_zenith/twig/96/96a10cd75d06f45e1906d68a1a9f53fceec7da502718fa841ee950c43ef28656.php:73
47	__TwigTemplate_72980bb5c4dee0864bd865e5433b0eaa57a4b2010099f5139bf2ae2163baa879->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
46	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
45	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:35
44	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/67/672e8f5136c71ccc255853ae76ab57593a0f6bb61f286f7b65d197470b8a6170.php:53
41	__TwigTemplate_7ec6e0365de7d68d77ce9f8b9dc462c1d79cf16d631d33c28bb51c341637e2ff->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
38	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
37	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
36	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
35	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
34	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
33	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
32	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
31	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
30	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/e1/e115e15b7afc7be8fa0760d7238614bd34f9c9c6038781dbc9d8d6b4009f39d1.php:47
20	__TwigTemplate_2a78621a090cc0f25207fd2ae1e5a4ec08c738c722d73b33ecf017d1865192c1->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/46/464ae1ee08e3f27a273d603331ec193708e1bc2ca1d7c2744fe80eed0b0a6f26.php:35
17	__TwigTemplate_126d5021e40b11667324636531dc8e4846dfcae23d9f18b23547ca2200822947->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/a9/a9b7c1be1a7f81f5aeee3f3d1537bc192544451fcc51b322b79c808b869fd5b9.php:35
14	__TwigTemplate_2b44cdb8eb26fe3dc7f035a50a421519d186995b29bc78a3f843ba6b67e00753->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_zenith/index.php:23
7	require JROOT/templates/rt_zenith/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 7.21 ms Query memory: 0.043 MB Memory before query: 19.234 MB Rows returned: 1

Duplicate queries: #32

SELECT * 
  FROM ccroe_widgetkit 
  WHERE id = "31"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
60	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
59	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/Database.php:35
58	YOOtheme\Framework\Joomla\Database->fetchAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Database/Database.php:88
57	YOOtheme\Framework\Database\Database->fetchObject()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:44
56	YOOtheme\Widgetkit\Content\ContentProvider->find()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:30
55	YOOtheme\Widgetkit\Content\ContentProvider->get()	JROOT/administrator/components/com_widgetkit/src/Application.php:151
54	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
53	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
52	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:43
46	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_zenith/twig/96/96a10cd75d06f45e1906d68a1a9f53fceec7da502718fa841ee950c43ef28656.php:73
44	__TwigTemplate_72980bb5c4dee0864bd865e5433b0eaa57a4b2010099f5139bf2ae2163baa879->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:35
41	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/67/672e8f5136c71ccc255853ae76ab57593a0f6bb61f286f7b65d197470b8a6170.php:53
38	__TwigTemplate_7ec6e0365de7d68d77ce9f8b9dc462c1d79cf16d631d33c28bb51c341637e2ff->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/e1/e115e15b7afc7be8fa0760d7238614bd34f9c9c6038781dbc9d8d6b4009f39d1.php:47
20	__TwigTemplate_2a78621a090cc0f25207fd2ae1e5a4ec08c738c722d73b33ecf017d1865192c1->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/46/464ae1ee08e3f27a273d603331ec193708e1bc2ca1d7c2744fe80eed0b0a6f26.php:35
17	__TwigTemplate_126d5021e40b11667324636531dc8e4846dfcae23d9f18b23547ca2200822947->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/a9/a9b7c1be1a7f81f5aeee3f3d1537bc192544451fcc51b322b79c808b869fd5b9.php:35
14	__TwigTemplate_2b44cdb8eb26fe3dc7f035a50a421519d186995b29bc78a3f843ba6b67e00753->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_zenith/index.php:23
7	require JROOT/templates/rt_zenith/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.18 ms Query memory: 0.048 MB Memory before query: 19.289 MB Rows returned: 1

Duplicate queries: #34

SELECT a.* 
  FROM ccroe_zoo_item AS a 
  LEFT JOIN ccroe_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 8 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-16 10:47:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-16 10:47:21') 
  AND b.category_id  = 46 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.name 
  LIMIT 0,1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	1	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	theciada_prodemo.b.item_id	1	17.73	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
62	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
61	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
60	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:467
59	ItemTable->getByCategory()	JROOT/administrator/components/com_zoo/helpers/module.php:125
58	ModuleHelper->getItems()	JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:38
57	YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems()	JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102
56	YOOtheme\Widgetkit\Content\Content->getItems()	JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44
55	YOOtheme\Widgetkit\Widget\Widget->render()	JROOT/administrator/components/com_widgetkit/src/Application.php:163
54	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
53	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
52	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:43
46	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_zenith/twig/96/96a10cd75d06f45e1906d68a1a9f53fceec7da502718fa841ee950c43ef28656.php:73
44	__TwigTemplate_72980bb5c4dee0864bd865e5433b0eaa57a4b2010099f5139bf2ae2163baa879->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/63/638379be3a5502cd0cde99c110fcc577b89027ad50d69a7ab9f4be787f3d3071.php:35
41	__TwigTemplate_3c30929696110bedfcc62bff9088cb2305b1778882bed2d0f33f3be1b679f232->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/67/672e8f5136c71ccc255853ae76ab57593a0f6bb61f286f7b65d197470b8a6170.php:53
38	__TwigTemplate_7ec6e0365de7d68d77ce9f8b9dc462c1d79cf16d631d33c28bb51c341637e2ff->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_zenith/twig/e1/e115e15b7afc7be8fa0760d7238614bd34f9c9c6038781dbc9d8d6b4009f39d1.php:47
20	__TwigTemplate_2a78621a090cc0f25207fd2ae1e5a4ec08c738c722d73b33ecf017d1865192c1->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/46/464ae1ee08e3f27a273d603331ec193708e1bc2ca1d7c2744fe80eed0b0a6f26.php:35
17	__TwigTemplate_126d5021e40b11667324636531dc8e4846dfcae23d9f18b23547ca2200822947->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/rt_zenith/twig/a9/a9b7c1be1a7f81f5aeee3f3d1537bc192544451fcc51b322b79c808b869fd5b9.php:35
14	__TwigTemplate_2b44cdb8eb26fe3dc7f035a50a421519d186995b29bc78a3f843ba6b67e00753->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_zenith/index.php:23
7	require JROOT/templates/rt_zenith/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

3 × SELECT a.* 
  FROM ccroe_zoo_item AS a 
  LEFT JOIN ccroe_zoo_category_item AS b 
  ON a.id = b.item_id

```
3 × SELECT * 
  FROM ccroe_widgetkit
```

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `ccroe_extensions`

2 × SELECT * 
  FROM ccroe_zoo_application

```
2 × SELECT * 
  FROM ccroe_languages
```

2 × SELECT `ip`,`reason` 
  FROM ccroe_rsfirewall_lists

1 × SELECT `session_id` 
  FROM `ccroe_session`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ccroe_modules AS m 
  LEFT JOIN ccroe_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ccroe_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT a.menutype 
  FROM ccroe_menu_types AS a

1 × SELECT * 
  FROM ccroe_sh404sef_metas

```
1 × select b.* 
  from ccroe_rstbox b
```

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ccroe_assets`

1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params 
  FROM ccroe_template_styles AS s

1 × SELECT id, home, template, s.params 
  FROM ccroe_template_styles as s 
  LEFT JOIN ccroe_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT * 
  FROM ccroe_rsfirewall_hashes

1 × SELECT * 
  FROM ccroe_rsfirewall_snapshots

1 × SELECT * 
  FROM ccroe_sh404sef_aliases

1 × SELECT * 
  FROM `ccroe_sh404sef_aliases`

1 × SELECT `params` 
  FROM ccroe_extensions

1 × SELECT id,template 
  FROM ccroe_template_styles

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 ccroe_menu AS m 
  LEFT JOIN ccroe_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT * 
  FROM ccroe_rsfirewall_configuratio

1 × SELECT `file` 
  FROM ccroe_rsfirewall_hashes

1 × SELECT `path` 
  FROM ccroe_rsfirewall_ignored

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM ccroe_extensions

1 × SELECT b.id 
  FROM ccroe_usergroups AS a 
  LEFT JOIN ccroe_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `ccroe_viewlevels

1 × SELECT * 
  FROM ccroe_zoo_category

OTHER Tables:

1 × INSERT INTO `ccroe_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('a7eba336bff2f06eb30fffb4bb722ebf', 1, 1618570041, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `ccroe_rsfirewall_logs

1 × UPDATE `ccroe_extensions` 
  SET `params` = '{\"mediaversion\":\"ee8a1a0eab791add62cc87c7b4a4b76d\"}'

1 × SHOW FULL COLUMNS 
  FROM `ccroe_sh404sef_metas

Vendor Spotlight

CIADA Dealer Membership Application

Company Information

Additional Customer Information

Member Education

Member Education

The 65th Annual Conventions & Expo

The 65th Annual Conventions & Expo

Auction Coupon App

Auction Coupon App

Dealer News & Updates

Dealer News & Updates

Legislative Updates

Legislative Updates

Vendor Referrals

Vendor Referrals

CIADA Auto Dealer News

CIADA Auto Dealer News

NIADA Membership

NIADA Membership

Contact Us

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

40 Queries Logged 17.47 ms

4 duplicate found!

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: