Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1563505824,
                "last": 1563505824,
                "now": 1563505824
            },
            "token": "dzOzXhobTYTCbmk86wDvdTRoXth7wOnr"
        },
        "registry": {
            "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": {
                "37e697f5b38068eeee9c5978c7a4c11c64e3217c": {
                    "link": "http:\/\/antiochschool.org\/joomla_antioch\/index.php\/school-calendar\/icalrepeat.detail\/2018\/11\/29\/516\/27|37|28|29|38|39|40\/-",
                    "expiry": 1563505824
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 2.97 ms / 2.97 ms Memory: 0.059 MB / 0.39 MB Application: afterLoad

Time: 18.31 ms / 21.28 ms Memory: 1.008 MB / 1.40 MB Application: afterInitialise

Time: 7.99 ms / 29.27 ms Memory: 0.918 MB / 2.32 MB Application: afterRoute

Time: 0.30 ms / 29.56 ms Memory: 0.054 MB / 2.37 MB Application: beforeRenderComponent com_jevents

Time: 5.33 ms / 34.89 ms Memory: 0.346 MB / 2.72 MB Application: Before JAccess::preloadComponents (all components)

Time: 0.26 ms / 35.15 ms Memory: 0.067 MB / 2.78 MB Application: After JAccess::preloadComponents (all components)

Time: 0.02 ms / 35.17 ms Memory: 0.000 MB / 2.78 MB Application: Before JAccess::getAssetRules (id:129 name:com_jevents)

Time: 0.20 ms / 35.37 ms Memory: 0.009 MB / 2.79 MB Application: After JAccess::getAssetRules (id:129 name:com_jevents)

Time: 32.68 ms / 68.05 ms Memory: 0.977 MB / 3.77 MB Application: Before JAccess::preloadPermissions (com_jevents)

Time: 0.18 ms / 68.23 ms Memory: 0.034 MB / 3.80 MB Application: After JAccess::preloadPermissions (com_jevents)

Time: 0.04 ms / 68.27 ms Memory: 0.000 MB / 3.80 MB Application: Before JAccess::getAssetRules (id:137 name:com_jevents.category.28)

Time: 0.04 ms / 68.32 ms Memory: 0.007 MB / 3.81 MB Application: After JAccess::getAssetRules (id:137 name:com_jevents.category.28)

Time: 11.32 ms / 79.63 ms Memory: 0.206 MB / 4.01 MB Application: afterRenderComponent com_jevents

Time: 0.32 ms / 79.95 ms Memory: 0.006 MB / 4.02 MB Application: afterDispatch

Time: 17.40 ms / 97.35 ms Memory: 0.266 MB / 4.28 MB Application: beforeRenderModule mod_s5_box (S5 Box)

Time: 0.33 ms / 97.68 ms Memory: 0.025 MB / 4.31 MB Application: beforeRenderModule mod_login (Login)

Time: 2.03 ms / 99.71 ms Memory: 0.024 MB / 4.33 MB Application: afterRenderModule mod_login (Login)

Time: 0.02 ms / 99.73 ms Memory: 0.000 MB / 4.33 MB Application: beforeRenderModule mod_s5_register (Register)

Time: 4.18 ms / 103.91 ms Memory: 0.106 MB / 4.44 MB Application: afterRenderModule mod_s5_register (Register)

Time: 0.17 ms / 104.08 ms Memory: 0.000 MB / 4.42 MB Application: afterRenderModule mod_s5_box (S5 Box)

Time: 0.21 ms / 104.29 ms Memory: 0.006 MB / 4.42 MB Application: beforeRenderModule mod_s5_quick_contact (Quick Contact)

Time: 2.45 ms / 106.73 ms Memory: 0.021 MB / 4.44 MB Application: afterRenderModule mod_s5_quick_contact (Quick Contact)

Time: 48.03 ms / 154.76 ms Memory: 0.711 MB / 5.16 MB Application: afterRender

Database queries total: 17.38 ms

Memory Usage

Database Queries

37 Queries Logged 17.38 ms

2 duplicate found!

2 duplicates: #35 #36

Query Time: 0.36 ms Query memory: 0.010 MB Memory before query: 0.707 MB Rows returned: 0

SELECT `data`

  FROM `ypscx_session`

  WHERE `session_id` = '73cf29d34954eb3a87dbbd9abab8777a'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.15 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.15 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.91 ms After last query: 0.48 ms Query memory: 0.005 MB Memory before query: 0.725 MB Rows returned: 0

SELECT `session_id`

  FROM `ypscx_session`

  WHERE `session_id` = '73cf29d34954eb3a87dbbd9abab8777a' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.65 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.17 ms After last query: 0.13 ms Query memory: 0.005 MB Memory before query: 0.732 MB

INSERT INTO `ypscx_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('73cf29d34954eb3a87dbbd9abab8777a', 1, '1563505824', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `ypscx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('73cf29d34954eb3a87dbbd9abab8777a', 1, '1563505824', 0, '', 0)

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
update	0.04 ms
Waiting for query cache lock	0.00 ms
update	0.02 ms
end	0.00 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.06 ms After last query: 2.09 ms Query memory: 0.007 MB Memory before query: 0.892 MB Rows returned: 3

SELECT id, rules

  FROM `ypscx_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.04 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 0.906 MB Rows returned: 1

SELECT b.id

  FROM ypscx_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 4.04 ms Query memory: 0.006 MB Memory before query: 1.224 MB Rows returned: 1

SELECT `enabled`

  FROM `ypscx_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:74
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:252
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 8.77 ms Query memory: 0.009 MB Memory before query: 2.218 MB

UPDATE `ypscx_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:460
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 8.01 ms Query memory: 0.012 MB Memory before query: 2.720 MB Rows returned: 39

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

  FROM `ypscx_assets`

  WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyappointment','com_fields','com_finder','com_installer','com_jevents','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
12	JUser->authorise()	JROOT/components/com_jevents/libraries/helper.php:2265
11	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:2347
10	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:40
9	JEventsDataModel->__construct()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:37
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:20
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:249
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.06 ms After last query: 2.33 ms Query memory: 0.010 MB Memory before query: 2.873 MB Rows returned: 1

SELECT `id`

  FROM `ypscx_finder_types`

  WHERE `title` = 'Event'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_finder_types	const	title	title	402	const	1	100.00	Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
13	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
12	FinderIndexerAdapter->__construct()	JROOT/plugins/finder/jevents/jevents.php:81
11	plgFinderJEvents->__construct()	JROOT/libraries/cms/plugin/helper.php:271
10	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
9	JPluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:41
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:20
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:249
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.08 ms After last query: 1.49 ms Query memory: 0.009 MB Memory before query: 2.894 MB Rows returned: 1

SELECT `id`

  FROM `ypscx_finder_types`

  WHERE `title` = 'Tag'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_finder_types	const	title	title	402	const	1	100.00	Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/cms/plugin/helper.php:271
10	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
9	JPluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:41
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:20
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:249
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.09 ms After last query: 0.46 ms Query memory: 0.009 MB Memory before query: 2.910 MB Rows returned: 1

SELECT `id`

  FROM `ypscx_finder_types`

  WHERE `title` = 'Category'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_finder_types	const	title	title	402	const	1	100.00	Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/cms/plugin/helper.php:271
10	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
9	JPluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:41
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:20
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:249
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 0.44 ms Query memory: 0.009 MB Memory before query: 2.925 MB Rows returned: 1

SELECT `id`

  FROM `ypscx_finder_types`

  WHERE `title` = 'Contact'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_finder_types	const	title	title	402	const	1	100.00	Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/cms/plugin/helper.php:271
10	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
9	JPluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:41
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:20
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:249
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 0.46 ms Query memory: 0.009 MB Memory before query: 2.941 MB Rows returned: 1

SELECT `id`

  FROM `ypscx_finder_types`

  WHERE `title` = 'Article'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_finder_types	const	title	title	402	const	1	100.00	Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/cms/plugin/helper.php:271
10	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
9	JPluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:41
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:20
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:249
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 0.40 ms Query memory: 0.009 MB Memory before query: 2.956 MB Rows returned: 1

SELECT `id`

  FROM `ypscx_finder_types`

  WHERE `title` = 'News Feed'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_finder_types	const	title	title	402	const	1	100.00	Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/cms/plugin/helper.php:271
10	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
9	JPluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:41
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:20
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:249
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.08 ms After last query: 0.42 ms Query memory: 0.009 MB Memory before query: 2.972 MB Rows returned: 1

SELECT `id`

  FROM `ypscx_finder_types`

  WHERE `title` = 'Web Link'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_finder_types	const	title	title	402	const	1	100.00	Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/cms/plugin/helper.php:271
10	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
9	JPluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:41
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:20
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:249
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.03 ms After last query: 2.74 ms Query memory: 0.013 MB Memory before query: 3.119 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `ypscx_jev_users`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.46 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.01 ms
checking permissions	0.02 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.00 ms
checking permissions	0.00 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.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.30 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
16	JTable->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:69
15	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:2205
14	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1589
13	JEVHelper::isEventPublisher()	JROOT/components/com_jevents/libraries/dbmodel.php:3077
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:723
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:36
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.08 ms After last query: 2.15 ms Query memory: 0.013 MB Memory before query: 3.244 MB Rows returned: 13

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 ypscx_categories as c

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

  ORDER BY c.lft

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
16	JCategories->_load()	JROOT/components/com_jevents/helpers/category.php:47
15	JEventsCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:90
13	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:3110
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:723
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:36
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.05 ms After last query: 0.21 ms Query memory: 0.010 MB Memory before query: 3.320 MB Rows returned: 7

SELECT c.id

  FROM ypscx_categories AS c

  WHERE c.access   IN (1,1)
 
  AND c.published = 1
  
  AND c.language in ('en-GB','*')
 
  AND c.extension = 'com_jevents'
 
  AND ((c.lft>=3 
  AND c.rgt<=4 ) OR (c.lft>=5 
  AND c.rgt<=6 ) OR (c.lft>=9 
  AND c.rgt<=10 ) OR (c.lft>=13 
  AND c.rgt<=14 ) OR (c.lft>=17 
  AND c.rgt<=18 ) OR (c.lft>=21 
  AND c.rgt<=22 ) OR (c.lft>=25 
  AND c.rgt<=26 ))

  ORDER BY c.lft asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	cat_idx,idx_access,idx_left_right,idx_language	cat_idx	203	const,const	12	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
14	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:172
13	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:3110
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:723
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:36
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.73 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 3.328 MB Rows returned: 1

SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids, 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 
 , ev.state as state 
 
  FROM (ypscx_jevents_vevent as ev )
 
  INNER JOIN ypscx_jevents_repetition as rpt 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN ypscx_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN ypscx_jevents_rrule as rr 
  ON rr.eventid = ev.ev_id
 
  INNER JOIN ypscx_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid  
 
  LEFT JOIN 
 ypscx_jevents_catmap as catmap 
  ON catmap.evid = rpt.eventid 
 
  LEFT JOIN 
 ypscx_categories AS catmapcat 
  ON catmap.catid = catmapcat.id
 
  WHERE 1 
 
  AND ev.access IN (1,1) 
  AND icsf.access IN (1,1) 
  AND  catmap.catid IN(-1,27,37,28,29,38,39,40)
 
  AND rpt.rp_id = '516'
 
  GROUP BY rpt.rp_id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rpt	const	PRIMARY,eventid,eventstart,eventend,eventdetail	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	det	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ev	const	PRIMARY,icsid,evaccess	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	icsf	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	rr	ref	eventid	eventid	4	const	1	100.00	NULL
1	SIMPLE	catmap	range	key_event_category,key_evid	key_evid	8	NULL	8	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
1	SIMPLE	catmapcat	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.catmap.catid	1	100.00	Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	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
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.68 ms
preparing	0.06 ms
executing	0.00 ms
Sending data	0.43 ms
end	0.01 ms
removing tmp table	0.00 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:3156
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:723
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:36
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.06 ms After last query: 1.38 ms Query memory: 0.010 MB Memory before query: 3.451 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 ypscx_users AS ju
 
  LEFT JOIN ypscx_contact_details AS cd 
  ON cd.user_id = ju.id 
 
  LEFT JOIN ypscx_categories AS cat 
  ON cat.id = cd.catid 
 
  WHERE block ='0'
 
  AND cd.published =1 
 
  AND cd.access   IN (1,1)
 
  AND cat.access   IN (1,1)
 
  AND ju.id = 987

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/libraries/helper.php:2140
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:557
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:755
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:36
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.04 ms After last query: 0.06 ms Query memory: 0.010 MB Memory before query: 3.463 MB Rows returned: 1

SELECT `id`

  FROM `ypscx_users`

  WHERE `id` = '987' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/components/com_jevents/libraries/helper.php:3077
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2147
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:557
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:755
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:36
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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: 0.24 ms Query memory: 0.016 MB Memory before query: 3.479 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `ypscx_users`

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.69 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 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.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.29 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
23	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
22	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
21	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:311
20	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:598
19	JUser::getTable()	JROOT/libraries/joomla/user/user.php:875
18	JUser->load()	JROOT/libraries/joomla/user/user.php:243
17	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
16	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
15	JFactory::getUser()	JROOT/components/com_jevents/libraries/helper.php:3083
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2147
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:557
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:755
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:36
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.05 ms After last query: 0.10 ms Query memory: 0.014 MB Memory before query: 3.521 MB Rows returned: 1

SELECT *

  FROM `ypscx_users`

  WHERE `id` = 987

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
19	JTableUser->load()	JROOT/libraries/joomla/user/user.php:878
18	JUser->load()	JROOT/libraries/joomla/user/user.php:243
17	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
16	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
15	JFactory::getUser()	JROOT/components/com_jevents/libraries/helper.php:3083
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2147
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:557
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:755
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:36
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 1.01 ms Query memory: 0.014 MB Memory before query: 3.541 MB Rows returned: 1

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

  FROM `ypscx_usergroups` AS g

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

  WHERE `m`.`user_id` = 987

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:110
19	JTableUser->load()	JROOT/libraries/joomla/user/user.php:878
18	JUser->load()	JROOT/libraries/joomla/user/user.php:243
17	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
16	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
15	JFactory::getUser()	JROOT/components/com_jevents/libraries/helper.php:3083
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2147
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:557
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:755
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:36
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 5.98 ms After last query: 4.03 ms Query memory: 0.008 MB Memory before query: 3.648 MB

UPDATE ypscx_jevents_vevdetail 
  SET hits=(hits+1) 
  WHERE evdet_id='324'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_jevents_vevdetail	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.02 ms
updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	5.77 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_jevents/libraries/jicaleventdb.php:831
12	jIcalEventDB->updateHits()	JROOT/components/com_jevents/libraries/datamodel.php:845
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:36
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 1.58 ms Query memory: 0.013 MB Memory before query: 3.711 MB Rows returned: 12

SELECT a.id, a.parent_id

  FROM ypscx_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	cat_idx,idx_language	cat_idx	203	const,const	12	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:25
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php:38
14	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php	JROOT/libraries/legacy/view/legacy.php:694
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.04 ms After last query: 0.05 ms Query memory: 0.013 MB Memory before query: 3.731 MB Rows returned: 1

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_jev_defaults	ref	name,langcodename	name	152	const	13	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:47
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php:38
14	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php	JROOT/libraries/legacy/view/legacy.php:694
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.05 ms After last query: 1.44 ms Query memory: 0.016 MB Memory before query: 3.769 MB Rows returned: 14

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

  FROM `ypscx_assets`

  WHERE `name` LIKE 'com_jevents.%' OR `name` = 'com_jevents' OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	402	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
23	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
22	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
21	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
20	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
19	JUser->authorise()	JROOT/components/com_jevents/libraries/helper.php:2565
18	JEVHelper::authoriseCategories()	JROOT/components/com_jevents/libraries/helper.php:2053
17	JEVHelper::canDeleteEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:753
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php:38
14	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php	JROOT/libraries/legacy/view/legacy.php:694
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 0.67 ms Query memory: 0.014 MB Memory before query: 3.810 MB Rows returned: 0

SELECT rpt.*,det.summary as title , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM ypscx_jevents_repetition  as rpt
			 
  LEFT JOIN ypscx_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id 
  WHERE rpt.eventid=323 
  AND rpt.rp_id <> 516 
  AND rpt.startrepeat<='2018-11-29 12:15:00' 
  ORDER BY rpt.startrepeat DESC 
  limit 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rpt	range	PRIMARY,eventid,eventstart,eventend,startrepeat,startend	eventstart	12	NULL	1	100.00	Using index condition
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.rpt.eventdetail_id	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
20	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:409
19	jIcalEventRepeat->getAdjacentRepeats()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:372
18	jIcalEventRepeat->prevRepeat()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:321
17	jIcalEventRepeat->previousnextLinks()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1201
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php:38
14	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php	JROOT/libraries/legacy/view/legacy.php:694
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.06 ms Query memory: 0.014 MB Memory before query: 3.824 MB Rows returned: 0

SELECT rpt.*,det.summary as title, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM ypscx_jevents_repetition  as rpt
			 
  LEFT JOIN ypscx_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id 
  WHERE rpt.eventid=323 
  AND rpt.rp_id <> 516 
  AND rpt.startrepeat>='2018-11-29 12:15:00' 
  ORDER BY rpt.startrepeat ASC 
  limit 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rpt	range	PRIMARY,eventid,eventstart,eventend,startrepeat,startend	eventstart	12	NULL	1	100.00	Using index condition
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.rpt.eventdetail_id	1	100.00	NULL

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 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.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
20	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:425
19	jIcalEventRepeat->getAdjacentRepeats()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:372
18	jIcalEventRepeat->prevRepeat()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:321
17	jIcalEventRepeat->previousnextLinks()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1201
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php:38
14	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php	JROOT/libraries/legacy/view/legacy.php:694
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.99 ms After last query: 1.37 ms Query memory: 0.016 MB Memory before query: 3.818 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `ypscx_content`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.33 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 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
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.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.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
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.30 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
21	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
20	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
19	JTable::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:11
18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:13
16	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
14	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:8
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php	JROOT/libraries/legacy/view/legacy.php:694
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 1.67 ms Query memory: 0.017 MB Memory before query: 3.965 MB Rows returned: 0

SELECT 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

  FROM ypscx_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	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
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
25	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
24	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
23	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
21	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:19
18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:13
16	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
14	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:8
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php	JROOT/libraries/legacy/view/legacy.php:694
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:143
8	ICalRepeatController->detail()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 6.06 ms Query memory: 0.009 MB Memory before query: 4.055 MB Rows returned: 1

SELECT * 
  FROM ypscx_template_styles 
  WHERE template = 'oasis';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_template_styles	ref	idx_template	idx_template	202	const	1	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
10	JDatabaseDriver->loadAssocList()	JROOT/templates/oasis/vertex/parameters.php:19
9	getTemplateName()	JROOT/templates/oasis/vertex/parameters.php:167
8	require_once JROOT/templates/oasis/vertex/parameters.php	JROOT/templates/oasis/index.php:21
7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.05 ms After last query: 0.06 ms Query memory: 0.008 MB Memory before query: 4.066 MB Rows returned: 0

SELECT * 
  FROM ypscx_menu 
  WHERE template_style_id IN (13) 
  AND alias = 'school-calendar'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_menu	ref	idx_alias	idx_alias	402	const	1	100.00	Using where

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
10	JDatabaseDriver->loadAssocList()	JROOT/templates/oasis/vertex/parameters.php:40
9	getTemplateName()	JROOT/templates/oasis/vertex/parameters.php:167
8	require_once JROOT/templates/oasis/vertex/parameters.php	JROOT/templates/oasis/index.php:21
7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.06 ms After last query: 7.99 ms Query memory: 0.009 MB Memory before query: 4.155 MB Rows returned: 0

Duplicate queries: #36

SELECT menutype  
  FROM  ypscx_menu 
  WHERE language = 'en-GB' 
  AND home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_menu	ref	idx_language	idx_language	28	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php:139
10	include JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php:85
9	require JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php	JROOT/templates/oasis/vertex/includes/vertex_includes_top.php:12
8	require_once JROOT/templates/oasis/vertex/includes/vertex_includes_top.php	JROOT/templates/oasis/index.php:593
7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.05 ms After last query: 2.06 ms Query memory: 0.007 MB Memory before query: 4.702 MB Rows returned: 0

Duplicate queries: #35

SELECT menutype  
  FROM  ypscx_menu 
  WHERE language = 'en-GB' 
  AND home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_menu	ref	idx_language	idx_language	28	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
9	JDatabaseDriver->loadResult()	JROOT/templates/oasis/vertex/s5flex_menu/default.php:45
8	include JROOT/templates/oasis/vertex/s5flex_menu/default.php	JROOT/templates/oasis/index.php:612
7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 61.91 ms Query memory: 0.009 MB Memory before query: 4.989 MB Rows returned: 160

SELECT * 
  FROM ypscx_acymailing_config

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
11	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
10	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1371
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:21
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:145
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

7 × SELECT `id` 
  FROM `ypscx_finder_types`

2 × SELECT menutype  
  FROM  ypscx_menu

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ypscx_assets`

1 × SELECT `data` 
  FROM `ypscx_session`

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `ypscx_usergroups` AS g 
  INNER JOIN `ypscx_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM ypscx_menu
```

1 × SELECT * 
  FROM ypscx_template_styles

1 × SELECT 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 
  FROM ypscx_fields AS a 
  LEFT JOIN `ypscx_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ypscx_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ypscx_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ypscx_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ypscx_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT rpt.*,det.summary as title, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM ypscx_jevents_repetition  as rpt     
  LEFT JOIN ypscx_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id

1 × SELECT rpt.*,det.summary as title , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM ypscx_jevents_repetition  as rpt     
  LEFT JOIN ypscx_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id

1 × SELECT * 
  FROM ypscx_jev_defaults

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

```
1 × SELECT `id` 
  FROM `ypscx_users`
```
```
1 × SELECT * 
  FROM `ypscx_users`
```

1 × SELECT `session_id` 
  FROM `ypscx_session`

1 × 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 ypscx_users AS ju  
  LEFT JOIN ypscx_contact_details AS cd 
  ON cd.user_id = ju.id   
  LEFT JOIN ypscx_categories AS cat 
  ON cat.id = cd.catid

1 × SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids, 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   , ev.state as state   
  FROM (ypscx_jevents_vevent as ev )  
  INNER JOIN ypscx_jevents_repetition as rpt 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN ypscx_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN ypscx_jevents_rrule as rr 
  ON rr.eventid = ev.ev_id  
  INNER JOIN ypscx_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid    
  LEFT JOIN   ypscx_jevents_catmap as catmap 
  ON catmap.evid = rpt.eventid   
  LEFT JOIN   ypscx_categories AS catmapcat 
  ON catmap.catid = catmapcat.id

1 × SELECT c.id 
  FROM ypscx_categories AS c

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 ypscx_categories as c

1 × SELECT `enabled` 
  FROM `ypscx_extensions`

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

1 × SELECT id, rules 
  FROM `ypscx_viewlevels

1 × SELECT * 
  FROM ypscx_acymailing_confi

OTHER Tables:

1 × INSERT INTO `ypscx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('73cf29d34954eb3a87dbbd9abab8777a', 1, '1563505824', 0, '', 0

1 × UPDATE `ypscx_extensions` 
  SET `params` = '{\"mediaversion\":\"e0ef6c9c0d2d77bb94c5779dc8edf52d\"}'

1 × SHOW FULL COLUMNS 
  FROM `ypscx_jev_users

1 × SHOW FULL COLUMNS 
  FROM `ypscx_users

1 × UPDATE ypscx_jevents_vevdetail 
  SET hits=(hits+1)

1 × SHOW FULL COLUMNS 
  FROM `ypscx_content

Events Calendar

Quick Contact

Login

Register

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

37 Queries Logged 17.38 ms

2 duplicate found!

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: