Rentals Availability Calendar

Events Calendar


By Year	By Month	By Week	Today	Search	Jump to month

Events for

Wednesday 25 May 2022
09:00am	09:00am - 09:45am Energy to Burn by This email address is being protected from spambots. You need JavaScript enabled to view it. :: Facility Rentals
10:00am	10:15am - 11:00am Ageless Energy by This email address is being protected from spambots. You need JavaScript enabled to view it. :: Facility Rentals
06:00pm	06:00pm - 09:00pm Karate by This email address is being protected from spambots. You need JavaScript enabled to view it. :: Facility Rentals

____________________________

Upcoming Events

July 6 & 7 - Casino Fundraiser

July 8 - Play Strong Girls

July 10 - Stampede BBQ

July 13 - Lot Levy Vote

Aug. 13 - Movie in the Park

Aug. 27 - Community Clean-up

________________________

Social Media:

Alberta Emergency Alert - Current

Calgary - Weather - Environment Canada

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1656849712,
                "last": 1656849712,
                "now": 1656849712
            },
            "token": "5CRSj4wKONTris6OtBDKP1J239eoRweU"
        },
        "registry": {
            "published_fv_ses": "0",
            "justmine_fv_ses": "0"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "0624937440edcdcdc8d65d9a3287b5e09ae1bd82": {
                    "link": "https://www.citadelca.ab.ca/CCA/index.php/rentals/rentals-availability-calendar/day.listevents/2022/05/25/-",
                    "expiry": 1656849712
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 5.96 ms / 5.96 ms Memory: 2.438 MB / 2.81 MB Application: afterLoad

Time: 35.52 ms / 41.47 ms Memory: 6.386 MB / 9.19 MB Application: Before Access::preloadComponents (all components)

Time: 1.42 ms / 42.89 ms Memory: 0.105 MB / 9.30 MB Application: After Access::preloadComponents (all components)

Time: 0.02 ms / 42.91 ms Memory: -0.015 MB / 9.28 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.25 ms / 43.16 ms Memory: 0.010 MB / 9.29 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 4.90 ms / 48.06 ms Memory: 0.661 MB / 9.95 MB Application: afterInitialise

Time: 16.62 ms / 64.68 ms Memory: 2.442 MB / 12.40 MB Application: afterRoute

Time: 1.14 ms / 65.83 ms Memory: 0.068 MB / 12.47 MB Application: beforeRenderComponent com_jevents

Time: 8.98 ms / 74.81 ms Memory: 2.022 MB / 14.49 MB Application: Before Access::getAssetRules (id:52 name:com_jevents)

Time: 0.02 ms / 74.83 ms Memory: 0.002 MB / 14.49 MB Application: After Access::getAssetRules (id:52 name:com_jevents)

Time: 38.20 ms / 113.03 ms Memory: 5.859 MB / 20.35 MB Application: afterRenderComponent com_jevents

Time: 0.61 ms / 113.65 ms Memory: 0.005 MB / 20.35 MB Application: afterDispatch

Time: 1.27 ms / 114.92 ms Memory: 1.283 MB / 21.64 MB Application: beforeRenderModule mod_cblogin (Member Login)

Time: 23.55 ms / 138.47 ms Memory: 5.963 MB / 27.60 MB Application: afterRenderModule mod_cblogin (Member Login)

Time: 0.06 ms / 138.53 ms Memory: -0.014 MB / 27.59 MB Application: beforeRenderModule mod_custom (Citadel Highlights)

Time: 2.16 ms / 140.68 ms Memory: 0.018 MB / 27.60 MB Application: afterRenderModule mod_custom (Citadel Highlights)

Time: 0.04 ms / 140.72 ms Memory: 0.023 MB / 27.63 MB Application: beforeRenderModule mod_thick_rss (City of Calgary)

Time: 27.92 ms / 168.64 ms Memory: 2.919 MB / 30.54 MB Application: afterRenderModule mod_thick_rss (City of Calgary)

Time: 0.09 ms / 168.73 ms Memory: -0.006 MB / 30.54 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.41 ms / 170.13 ms Memory: 0.034 MB / 30.57 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.07 ms / 170.21 ms Memory: -0.003 MB / 30.57 MB Application: beforeRenderModule mod_custom (Image)

Time: 0.24 ms / 170.45 ms Memory: 0.003 MB / 30.57 MB Application: afterRenderModule mod_custom (Image)

Time: 0.02 ms / 170.47 ms Memory: -0.000 MB / 30.57 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 5.67 ms / 176.14 ms Memory: 1.483 MB / 32.06 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.06 ms / 176.20 ms Memory: 0.001 MB / 32.06 MB Application: beforeRenderModule mod_search (Search)

Time: 0.69 ms / 176.90 ms Memory: 0.012 MB / 32.07 MB Application: afterRenderModule mod_search (Search)

Time: 181.57 ms / 358.47 ms Memory: 1.567 MB / 33.64 MB Application: afterRender

Database queries total: 37.78 ms

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

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN not possible on query: INSERT INTO `cca_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3331646666343865363964353635373136646162613463316533313138356535', 1, 1656849712, 0, '', 0)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.12 ms
end	0.01 ms
query end	0.07 ms
closing tables	0.02 ms
freeing items	0.04 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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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.82 ms After last query: 0.87 ms Query memory: 0.046 MB Memory before query: 4.845 MB Rows returned: 66

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

  FROM `cca_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	cca_extensions	NULL	ref	extension	extension	82	const	70	1.00	Using where

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.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.43 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:225
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: 1.03 ms Query memory: 0.021 MB Memory before query: 5.217 MB Rows returned: 4

SELECT id, rules

  FROM `cca_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 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.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
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:318
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:225
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.50 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 5.229 MB Rows returned: 2

SELECT b.id

  FROM cca_usergroups AS a

  LEFT JOIN cca_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.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 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.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
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:318
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:225
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.62 ms After last query: 0.22 ms Query memory: 0.051 MB Memory before query: 5.251 MB Rows returned: 131

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

  FROM cca_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	cca_extensions	NULL	ref	extension	extension	82	const	247	0.60	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.14 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.05 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
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:356
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:225
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.59 ms After last query: 4.00 ms Query memory: 0.032 MB Memory before query: 6.893 MB Rows returned: 129

SELECT `config_key`,`config_value`

  FROM cca_osmembership_configs

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.10 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.20 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmembership/libraries/mpf/config/config.php:39
10	MPFConfig->__construct()	JROOT/components/com_osmembership/helper/helper.php:44
9	OSMembershipHelper::getConfig()	JROOT/administrator/components/com_osmembership/loader.php:76
8	require_once JROOT/administrator/components/com_osmembership/loader.php	JROOT/plugins/system/membershippro/membershippro.php:43
7	plgSystemMembershipPro->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.14 ms After last query: 16.01 ms Query memory: 0.032 MB Memory before query: 9.207 MB Rows returned: 66

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

  FROM `cca_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_adsmanager','com_ajax','com_associations','com_autotweet','com_banners','com_booking','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_comprofiler','com_config','com_content','com_contenthistory','com_cpanel','com_digistore','com_djleague','com_ecwid','com_edocman','com_eshop','com_fields','com_finder','com_formmaker','com_formtomail','com_installer','com_jce','com_jevents','com_jgrid','com_joomgallery','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_mshahfrontendusermanager','com_osmembership','com_pfcomments','com_pffields','com_pfforum','com_pfmilestones','com_pfprojects','com_pfrepo','com_pftasks','com_pftime','com_pfusers','com_plugins','com_postinstall','com_privacy','com_profiler','com_profiles','com_projectfork','com_redirect','com_search','com_swmenufree','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_zweather')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/osmembershipurls/osmembershipurls.php:191
8	plgSystemOSMembershipUrls->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:668
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:225
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.47 ms Query memory: 0.021 MB Memory before query: 9.293 MB Rows returned: 0

SELECT plan_id

  FROM cca_osmembership_urls

  WHERE `url` = 'https://citadelca.ab.ca/CCA/index.php/rentals/rentals-availability-calendar/day.listevents/2022/05/25/-'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/osmembershipurls/osmembershipurls.php:322
9	plgSystemOSMembershipUrls->getRequiredPlanIds()	JROOT/plugins/system/osmembershipurls/osmembershipurls.php:209
8	plgSystemOSMembershipUrls->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:668
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:225
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: 0.05 ms Query memory: 0.020 MB Memory before query: 9.298 MB Rows returned: 0

SELECT id

  FROM cca_osmembership_plans

  WHERE published = 0

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.00 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.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/osmembershipurls/osmembershipurls.php:217
8	plgSystemOSMembershipUrls->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:668
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:225
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.16 ms After last query: 0.97 ms Query memory: 0.082 MB Memory before query: 9.689 MB Rows returned: 73

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

  LEFT JOIN cca_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	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	331	4.80	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:78
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:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
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:65
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:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/communitybuilder/communitybuilder.php:300
8	plgSystemCommunityBuilder->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:668
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:225
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: 1.05 ms Query memory: 0.020 MB Memory before query: 9.944 MB Rows returned: 1

SELECT count(*)

  FROM `cca_cwgears_schedule`

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	Select tables optimized away

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.00 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:102
8	plgSystemCwgears->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:668
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:225
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.21 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 9.949 MB Rows returned: 1

SELECT count(*)

  FROM `cca_cwgears_schedule`

  WHERE time + '3600'<'1656849712'

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	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.03 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.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:145
8	plgSystemCwgears->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:668
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:225
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.53 ms After last query: 3.14 ms Query memory: 0.022 MB Memory before query: 10.711 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM cca_template_styles as s

  LEFT JOIN cca_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	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	citadel4_CCA.e.element	1	66.67	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
9	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_adsmanager/lib/core.php:76
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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.44 ms After last query: 0.16 ms Query memory: 0.041 MB Memory before query: 10.716 MB Rows returned: 1

SELECT * 
  FROM cca_adsmanager_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/components/com_adsmanager/lib/core.php:86
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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: 0.25 ms Query memory: 0.026 MB Memory before query: 10.759 MB Rows returned: 1

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

  FROM `cca_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	cca_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 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.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/components/com_adsmanager/lib/core.php:119
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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: 0.15 ms Query memory: 0.007 MB Memory before query: 10.753 MB

UPDATE `cca_extensions`

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	cca_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.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.09 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/components/com_adsmanager/lib/core.php:119
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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.41 ms After last query: 9.67 ms Query memory: 0.020 MB Memory before query: 12.384 MB Rows returned: 0

SELECT ip

  FROM `cca_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

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.05 ms
checking permissions	0.01 ms
Opening tables	0.18 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.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:180
8	plgSystemCwtrafficCount->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:1190
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:225
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.14 ms After last query: 0.07 ms Query memory: 0.020 MB Memory before query: 12.389 MB Rows returned: 0

SELECT botname

  FROM `cca_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

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.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:208
8	plgSystemCwtrafficCount->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:1190
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:225
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.66 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 12.394 MB Rows returned: 1

SELECT count(*)

  FROM `cca_cwtraffic`

  WHERE iphash = UNHEX(SHA1('34.239.167.149')) 
  AND tm + '3600'>'1656849712'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cca_cwtraffic	NULL	ref	idx_iphash,idx_iphashtm	idx_iphashtm	21	const	4	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:264
8	plgSystemCwtrafficCount->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:1190
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:225
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: 1.10 ms Query memory: 0.020 MB Memory before query: 12.452 MB Rows returned: 1

SELECT *

  FROM cca_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	cca_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 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.07 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:225
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.79 ms After last query: 11.59 ms Query memory: 0.036 MB Memory before query: 15.352 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `cca_content`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
21	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
20	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:15
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.00 ms After last query: 6.70 ms Query memory: 0.030 MB Memory before query: 18.393 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM cca_fields AS a

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

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

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

  LEFT JOIN cca_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN cca_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_content.article' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	citadel4_CCA.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.a.group_id	1	100.00	Using where

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.02 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.19 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.00 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
26	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
25	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
24	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
23	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
20	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.15 ms After last query: 0.74 ms Query memory: 0.078 MB Memory before query: 18.436 MB Rows returned: 7

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

  FROM cca_modules AS m

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

  LEFT JOIN cca_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 <= '2022-07-03 12:01:52') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-07-03 12:01:52') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 859 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	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	88	1.14	Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	citadel4_CCA.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	citadel4_CCA.m.id	3	40.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	Same as call in the line below.
29	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
28	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
27	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
26	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
25	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:169
24	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
23	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
20	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.67 ms After last query: 5.44 ms Query memory: 0.033 MB Memory before query: 18.557 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `cca_jev_users`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.16 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.10 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.04 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.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
28	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
27	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
26	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
25	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1599
24	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1454
23	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:61
22	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2807
19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2754
18	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:813
17	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:9
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.55 ms After last query: 1.00 ms Query memory: 0.034 MB Memory before query: 18.605 MB Rows returned: 9

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

  FROM `cca_categories` AS `c`

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	25	44.00	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
27	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
26	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:409
24	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1020
23	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
22	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2807
19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2754
18	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:813
17	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:9
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.32 ms After last query: 0.38 ms Query memory: 0.029 MB Memory before query: 18.664 MB Rows returned: 1

SELECT c.id

  FROM cca_categories AS c

  WHERE c.access   IN (1,1,5)
 
  AND c.published = 1
  
  AND c.language in ('en-GB','*')
 
  AND c.extension = 'com_jevents'
 
  AND ((c.lft>=47 
  AND c.rgt<=48 ))

  ORDER BY c.lft asc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right,idx_language	idx_left_right	4	NULL	1	12.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 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.09 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 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
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:522
24	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1020
23	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
22	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2807
19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2754
18	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:813
17	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:9
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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: 3.33 ms After last query: 0.34 ms Query memory: 0.053 MB Memory before query: 18.684 MB Rows returned: 3

SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM cca_jevents_repetition as rpt
 
  INNER JOIN cca_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN cca_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN cca_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN cca_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,25)
 
  AND rpt.endrepeat >= '2022-05-25 00:00:00' 
  AND rpt.startrepeat <= '2022-05-25 23:59:59'
 
  AND NOT (rpt.startrepeat < '2022-05-25 00:00:00' 
  AND det.multiday=0)  
  AND ev.state=1
 
  AND ev.access IN (1,1,5)  
  AND icsf.state=1 
  AND icsf.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	NULL	ALL	PRIMARY,stateidx	NO INDEX KEY COULD BE USED	NULL	NULL	3	50.00	Using where
1	SIMPLE	ev	NULL	ref	PRIMARY,icsid,stateidx,evaccess	icsid	4	citadel4_CCA.icsf.ics_id	109	19.33	Using where
1	SIMPLE	rpt	NULL	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	citadel4_CCA.ev.ev_id	3	12.83	Using where
1	SIMPLE	rr	NULL	ref	eventid	eventid	4	citadel4_CCA.ev.ev_id	1	100.00	NULL
1	SIMPLE	det	NULL	eq_ref	PRIMARY,multiday	PRIMARY	4	citadel4_CCA.rpt.eventdetail_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:3083
20	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3019
19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2754
18	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:813
17	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:9
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.41 ms After last query: 1.34 ms Query memory: 0.031 MB Memory before query: 20.035 MB Rows returned: 8

SELECT c.* 
  FROM cca_categories as c 
  WHERE extension='com_jevents' 
  order by c.lft asc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	cat_idx	cat_idx	202	const	8	100.00	Using index condition; Using filesort

Profile

Status	Duration
starting	0.03 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.03 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/commonfunctions.php:191
19	JEV_CommonFunctions::getCategoryData()	JROOT/components/com_jevents/libraries/commonfunctions.php:144
18	JEV_CommonFunctions::setColor()	JROOT/components/com_jevents/libraries/jeventcal.php:598
17	jEventCal->bgcolor()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:58
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.32 ms After last query: 0.79 ms Query memory: 0.027 MB Memory before query: 20.068 MB Rows returned: 8

SELECT a.id, a.parent_id

  FROM cca_categories AS a

  WHERE a.parent_id > 0 
  AND a.extension = "com_jevents" 
  AND a.published = 1 
  AND a.language in ('en-GB','*')

  ORDER BY a.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	cat_idx,idx_language	cat_idx	203	const,const	8	33.33	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:41
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.04 ms Query memory: 0.026 MB Memory before query: 20.083 MB Rows returned: 0

SELECT * 
  FROM cca_jev_defaults 
  WHERE state=1 
  AND name= 'icalevent.list_row' 
  AND value<>'' 
  AND language in ('en-GB','*')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cca_jev_defaults	NULL	ref	name,langcodename	name	52	const	9	9.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:63
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.47 ms After last query: 0.71 ms Query memory: 0.029 MB Memory before query: 20.114 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `cca_menu` AS `c`

  INNER JOIN `cca_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `cca_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `cca_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 859

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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
executing	0.01 ms
end	0.00 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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
21	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
20	MenusHelper::getAssociations()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:292
19	jIcalEventRepeat->viewDetailLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:520
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.52 ms After last query: 1.07 ms Query memory: 0.028 MB Memory before query: 20.192 MB Rows returned: 0

SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,  
  CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,  
  CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug  
 
  FROM cca_users AS ju
 
  LEFT JOIN cca_contact_details AS cd 
  ON cd.user_id = ju.id 
 
  LEFT JOIN cca_categories AS cat 
  ON cat.id = cd.catid 
 
  WHERE block ='0'
 
  AND cd.published =1 
 
  AND cd.access   IN (1,1,5)
 
  AND cat.access   IN (1,1,5)
 
  AND ju.id = 251

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ju	NULL	const	PRIMARY,idx_block	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	cd	NULL	ref	idx_access,idx_state,idx_catid	idx_state	1	const	1	5.00	Using where
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	citadel4_CCA.cd.catid	1	100.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 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.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/libraries/helper.php:2704
21	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:767
20	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/jeventcal.php:405
19	jEventCal->contactLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1685
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.05 ms Query memory: 0.028 MB Memory before query: 20.207 MB Rows returned: 1

SELECT `id`

  FROM `cca_users`

  WHERE `id` = '251' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.00 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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/components/com_jevents/libraries/helper.php:2763
22	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2709
21	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:767
20	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/jeventcal.php:405
19	jEventCal->contactLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1685
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.52 ms After last query: 0.28 ms Query memory: 0.035 MB Memory before query: 20.225 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `cca_users`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
31	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
30	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
29	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
28	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
27	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
26	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
25	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
24	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
23	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2770
22	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2709
21	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:767
20	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/jeventcal.php:405
19	jEventCal->contactLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1685
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.13 ms Query memory: 0.030 MB Memory before query: 20.262 MB Rows returned: 1

SELECT *

  FROM `cca_users`

  WHERE `id` = 251

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
28	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
27	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
26	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
25	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
24	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
23	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2770
22	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2709
21	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:767
20	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/jeventcal.php:405
19	jEventCal->contactLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1685
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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: 0.77 ms Query memory: 0.030 MB Memory before query: 20.291 MB Rows returned: 3

SELECT `g`.`id`,`g`.`title`

  FROM `cca_usergroups` AS g

  INNER JOIN `cca_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 251

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	3	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.m.group_id	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
27	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
26	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
25	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
24	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
23	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2770
22	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2709
21	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:767
20	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/jeventcal.php:405
19	jEventCal->contactLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1685
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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: 0.27 ms Query memory: 0.029 MB Memory before query: 20.302 MB Rows returned: 8

SELECT cat.id, cat.title as name, pcat.title as pname, cat.description, cat.params  
  FROM cca_categories  as cat 
  LEFT JOIN cca_categories as pcat 
  on pcat.id=cat.parent_id 
  WHERE cat.extension='com_jevents' 
  ORDER BY cat.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat	NULL	ref	cat_idx	cat_idx	202	const	8	100.00	Using index condition; Using filesort
1	SIMPLE	pcat	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.cat.parent_id	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.00 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.00 ms
Creating sort index	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/jeventcal.php:507
22	jEventCal->getCategoryData()	JROOT/components/com_jevents/libraries/jeventcal.php:477
21	jEventCal->getCategoryName()	JROOT/components/com_jevents/libraries/jicaleventdb.php:667
20	jIcalEventDB->getCategoryName()	JROOT/components/com_jevents/libraries/jeventcal.php:467
19	jEventCal->catname()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:607
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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: 1.43 ms Query memory: 0.027 MB Memory before query: 20.320 MB Rows returned: 0

SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,  
  CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,  
  CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug  
 
  FROM cca_users AS ju
 
  LEFT JOIN cca_contact_details AS cd 
  ON cd.user_id = ju.id 
 
  LEFT JOIN cca_categories AS cat 
  ON cat.id = cd.catid 
 
  WHERE block ='0'
 
  AND cd.published =1 
 
  AND cd.access   IN (1,1,5)
 
  AND cat.access   IN (1,1,5)
 
  AND ju.id = 171

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ju	NULL	const	PRIMARY,idx_block	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	cd	NULL	ref	idx_access,idx_state,idx_catid	idx_state	1	const	1	5.00	Using where
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	citadel4_CCA.cd.catid	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 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.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/libraries/helper.php:2704
21	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:767
20	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/jeventcal.php:405
19	jEventCal->contactLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1685
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.05 ms Query memory: 0.028 MB Memory before query: 20.334 MB Rows returned: 1

SELECT `id`

  FROM `cca_users`

  WHERE `id` = '171' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
end	0.00 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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/components/com_jevents/libraries/helper.php:2763
22	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2709
21	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:767
20	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/jeventcal.php:405
19	jEventCal->contactLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1685
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.030 MB Memory before query: 20.350 MB Rows returned: 1

SELECT *

  FROM `cca_users`

  WHERE `id` = 171

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
28	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
27	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
26	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
25	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
24	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
23	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2770
22	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2709
21	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:767
20	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/jeventcal.php:405
19	jEventCal->contactLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1685
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.07 ms Query memory: 0.030 MB Memory before query: 20.367 MB Rows returned: 3

SELECT `g`.`id`,`g`.`title`

  FROM `cca_usergroups` AS g

  INNER JOIN `cca_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 171

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	3	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.m.group_id	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 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.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
28	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
27	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
26	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
25	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
24	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
23	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2770
22	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2709
21	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:767
20	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/jeventcal.php:405
19	jEventCal->contactLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1685
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:61
16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:130
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:89
8	DayController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:348
6	require_once JROOT/components/com_jevents/jevents.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:225
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.46 ms After last query: 8.64 ms Query memory: 0.028 MB Memory before query: 23.068 MB Rows returned: 1

SELECT `params`
 
  FROM `cca_comprofiler_plugin`
 
  WHERE `id` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cca_comprofiler_plugin	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.18 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.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
27	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
26	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
25	CB\Application\CBConfig::getConfig()	JROOT/libraries/CBLib/CB/Application/CBApplication.php:47
24	CB\Application\CBApplication::CB\Application\{closure}()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/CBLib/CBLib/Application/Config.php:38
22	CBLib\Application\Config::setMainConfig()	JROOT/libraries/CBLib/CBLib/Core/CBLib.php:78
21	CBLib\Core\CBLib::CBLib\Core\{closure}()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:607
20	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
19	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/Application/Application.php:212
18	CBLib\Application\Application::__callStatic()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
17	CB\Application\CBConfig::loadLegacyCBueConfig()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:102
16	CB\Legacy\LegacyFoundationFunctions->__construct()	Same as call in the line below.
15	ReflectionClass->newInstanceArgs()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:645
14	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
13	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:134
12	CBLib\DependencyInjection\Container->get()	JROOT/administrator/components/com_comprofiler/plugin.foundation.php:34
11	include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php	JROOT/modules/mod_cblogin/mod_cblogin.php:22
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.20 ms After last query: 3.84 ms Query memory: 0.038 MB Memory before query: 24.425 MB Rows returned: 23

SELECT f.* 
  FROM cca_comprofiler_fields f
 
  INNER JOIN cca_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE f.published = 1
 
  ORDER BY t.position, t.ordering, f.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ref	tabid_pub_prof_order,published_ordering	published_ordering	1	const	22	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.f.tabid	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
18	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
17	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1037
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332
15	CBuser->getField()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1123
14	CBuser->{closure}()	Same as call in the line below.
13	preg_replace_callback()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1174
12	CBuser->evaluateFields()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:650
11	CBuser->replaceUserVars()	JROOT/modules/mod_cblogin/mod_cblogin.php:133
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.36 ms After last query: 0.35 ms Query memory: 0.027 MB Memory before query: 24.541 MB Rows returned: 6

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `cca_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1,5)
 
  AND `type` = 'user'
 
  ORDER BY `ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cca_comprofiler_plugin	NULL	ref	type_pub_order,idx_folder,published_ordering	type_pub_order	304	const,const	5	22.22	Using index condition; Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 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.06 ms
end	0.00 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
19	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
18	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
17	cbPluginHandler->loadPluginGroup()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1083
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332
15	CBuser->getField()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1123
14	CBuser->{closure}()	Same as call in the line below.
13	preg_replace_callback()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1174
12	CBuser->evaluateFields()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:650
11	CBuser->replaceUserVars()	JROOT/modules/mod_cblogin/mod_cblogin.php:133
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.26 ms After last query: 5.42 ms Query memory: 0.023 MB Memory before query: 27.554 MB Rows returned: 1

SELECT `id`
 
  FROM `cca_menu`
 
  WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'en-GB', '*', '' )
 
  AND `client_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cca_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	160	0.54	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:233
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967
12	CBframework->viewUrl()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:826
11	CBframework->userProfileUrl()	JROOT/modules/mod_cblogin/mod_cblogin.php:207
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.94 ms After last query: 1.99 ms Query memory: 0.023 MB Memory before query: 27.586 MB Rows returned: 1

SELECT `id`
 
  FROM `cca_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'en-GB', '*', '' )
 
  AND `client_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cca_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	160	0.42	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:213
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/bootstrap.php:15
11	require JROOT/modules/mod_cblogin/tmpl/bootstrap.php	JROOT/modules/mod_cblogin/mod_cblogin.php:232
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.96 ms After last query: 0.51 ms Query memory: 0.023 MB Memory before query: 27.597 MB Rows returned: 1

SELECT `id`
 
  FROM `cca_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=lostpassword%' OR `link` LIKE 'index.php?option=com_comprofiler&task=lostpassword%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'en-GB', '*', '' )
 
  AND `client_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cca_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	160	0.42	Using index condition; 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.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.59 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:213
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/bootstrap.php:154
11	require JROOT/modules/mod_cblogin/tmpl/bootstrap.php	JROOT/modules/mod_cblogin/mod_cblogin.php:232
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.92 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 27.606 MB Rows returned: 1

SELECT `id`
 
  FROM `cca_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=registers%' OR `link` LIKE 'index.php?option=com_comprofiler&task=registers%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'en-GB', '*', '' )
 
  AND `client_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cca_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	160	0.42	Using index condition; 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.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.60 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:213
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/bootstrap.php:168
11	require JROOT/modules/mod_cblogin/tmpl/bootstrap.php	JROOT/modules/mod_cblogin/mod_cblogin.php:232
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.22 ms After last query: 0.90 ms Query memory: 0.026 MB Memory before query: 27.612 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM cca_fields AS a

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

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

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

  LEFT JOIN cca_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN cca_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	citadel4_CCA.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	citadel4_CCA.a.group_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.65 ms After last query: 37.04 ms Query memory: 0.022 MB Memory before query: 32.072 MB Rows returned: 0

SELECT uikit

  FROM `cca_cwgears`

  WHERE url = 'https://www.citadelca.ab.ca/CCA/index.php/rentals/rentals-availability-calendar/day.listevents/2022/05/25/-'

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.12 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:337
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.09 ms Query memory: 0.022 MB Memory before query: 32.078 MB Rows returned: 0

SELECT uikit_plus

  FROM `cca_cwgears`

  WHERE url = 'https://www.citadelca.ab.ca/CCA/index.php/rentals/rentals-availability-calendar/day.listevents/2022/05/25/-'

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.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:346
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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: 4.18 ms After last query: 5.26 ms Query memory: 0.038 MB Memory before query: 33.477 MB Rows returned: 483

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
14	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/fof/database/driver/joomla.php:252
13	FOFDatabaseDriverJoomla->getTableList()	JROOT/libraries/fof/table/table.php:2085
12	FOFTable->getTableFields()	JROOT/libraries/fof/table/table.php:536
11	FOFTable->__construct()	JROOT/administrator/components/com_autotweet/tables/automator.php:33
10	AutotweetTableAutomator->__construct()	JROOT/libraries/fof/table/table.php:433
9	FOFTable::getAnInstance()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:106
8	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:232
7	PlgSystemAutotweetAutomator->onAfterRender()	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/CMSApplication.php:1118
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:231
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.87 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 33.527 MB Rows returned: 3

SHOW FULL COLUMNS 
  FROM `cca_autotweet_automator`

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.26 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.15 ms
checking permissions	0.09 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof/database/driver/joomla.php:230
13	FOFDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/fof/table/table.php:2170
12	FOFTable->getTableFields()	JROOT/libraries/fof/table/table.php:536
11	FOFTable->__construct()	JROOT/administrator/components/com_autotweet/tables/automator.php:33
10	AutotweetTableAutomator->__construct()	JROOT/libraries/fof/table/table.php:433
9	FOFTable::getAnInstance()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:106
8	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:232
7	PlgSystemAutotweetAutomator->onAfterRender()	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/CMSApplication.php:1118
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:231
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.32 ms After last query: 0.57 ms Query memory: 0.021 MB Memory before query: 33.557 MB Rows returned: 1

SELECT cca_autotweet_automator.*

  FROM cca_autotweet_automator

  WHERE `cca_autotweet_automator`.`plugin` = 'automator'

Explain

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

Profile

Status	Duration
starting	0.05 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.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/fof/database/driver/joomla.php:292
10	FOFDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/fof/table/table.php:949
9	FOFTable->load()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:112
8	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:232
7	PlgSystemAutotweetAutomator->onAfterRender()	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/CMSApplication.php:1118
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:231
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.23 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 33.563 MB Rows returned: 1

SELECT cca_autotweet_automator.*

  FROM cca_autotweet_automator

  WHERE `cca_autotweet_automator`.`plugin` = 'content'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 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.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/fof/database/driver/joomla.php:292
11	FOFDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/fof/table/table.php:949
10	FOFTable->load()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:521
9	PlgAutotweetBase->executeContentPolling()	JROOT/plugins/system/autotweetcontent/autotweetcontent.php:137
8	PlgSystemAutotweetContent->onContentPolling()	JROOT/plugins/system/autotweetcontent/autotweetcontent.php:472
7	PlgSystemAutotweetContent->onAfterRender()	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/CMSApplication.php:1118
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:231
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.]

47 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
4 × SELECT `id`  
  FROM `cca_menu`
```

2 × SELECT cca_autotweet_automator.* 
  FROM cca_autotweet_automator

2 × SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,  
  CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,  
  CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug    
  FROM cca_users AS ju  
  LEFT JOIN cca_contact_details AS cd 
  ON cd.user_id = ju.id   
  LEFT JOIN cca_categories AS cat 
  ON cat.id = cd.catid

```
2 × SELECT `id` 
  FROM `cca_users`
```
```
2 × SELECT * 
  FROM `cca_users`
```

2 × SELECT `g`.`id`,`g`.`title` 
  FROM `cca_usergroups` AS g 
  INNER JOIN `cca_user_usergroup_map` AS m 
  ON m.group_id = g.id

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

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM cca_fields AS a 
  LEFT JOIN `cca_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN cca_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN cca_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN cca_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN cca_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
  FROM `cca_comprofiler_plugin`

1 × SELECT f.* 
  FROM cca_comprofiler_fields f  
  INNER JOIN cca_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)

1 × SELECT `params`  
  FROM `cca_comprofiler_plugin`

1 × SELECT cat.id, cat.title as name, pcat.title as pname, cat.description, cat.params  
  FROM cca_categories  as cat 
  LEFT JOIN cca_categories as pcat 
  on pcat.id=cat.parent_id

1 × SELECT c.id 
  FROM cca_categories AS c

1 × SELECT uikit 
  FROM `cca_cwgears`

1 × SELECT uikit_plus 
  FROM `cca_cwgears`

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `cca_menu` AS `c` 
  INNER JOIN `cca_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `cca_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `cca_menu` AS `c2` 
  ON a2.id = c2.`id`

```
1 × SELECT * 
  FROM cca_jev_defaults
```

1 × SELECT a.id, a.parent_id 
  FROM cca_categories AS a

1 × SELECT c.* 
  FROM cca_categories as c

1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
  FROM cca_jevents_repetition as rpt  
  INNER JOIN cca_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN cca_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN cca_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN cca_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

1 × SELECT `data` 
  FROM `cca_session`

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

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

1 × SELECT id, rules 
  FROM `cca_viewlevels

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

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

1 × SELECT `config_key`,`config_value` 
  FROM cca_osmembership_config

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

1 × SELECT plan_id 
  FROM cca_osmembership_urls

1 × SELECT id 
  FROM cca_osmembership_plans

1 × SELECT count(*) 
  FROM `cca_cwgears_schedule

1 × SELECT `session_id` 
  FROM `cca_session`

1 × SELECT count(*) 
  FROM `cca_cwgears_schedule`

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

1 × SELECT * 
  FROM cca_adsmanager_confi

1 × SELECT ip 
  FROM `cca_cwtraffic_knownips`

1 × SELECT botname 
  FROM `cca_cwtraffic_knownips`

1 × SELECT count(*) 
  FROM `cca_cwtraffic`

```
1 × SELECT * 
  FROM cca_languages
```

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

OTHER Tables:

1 × INSERT INTO `cca_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3331646666343865363964353635373136646162613463316533313138356535', 1, 1656849712, 0, '', 0

1 × UPDATE `cca_extensions` 
  SET `params` = '{\"mediaversion\":\"b2a91ddff6e0a8583b98c63e16c3484d\"}'

1 × SHOW FULL COLUMNS 
  FROM `cca_content

1 × SHOW FULL COLUMNS 
  FROM `cca_jev_users

1 × SHOW FULL COLUMNS 
  FROM `cca_users

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM `cca_autotweet_automator

Events Calendar

Member Login

City of Calgary

Alberta Emergency Alert - Current

Calgary - Weather - Environment Canada

City of Calgary Newsroom

City of Calgary Newsroom

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

57 Queries Logged 37.78 ms

47 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: