Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1566252345,
                "last": 1566252345,
                "now": 1566252345
            },
            "token": "bBLHYaMjbhcxvXgi2EtIPOAtUFAU033D"
        },
        "registry": {
            "published_fv_ses": "0",
            "justmine_fv_ses": "0"
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "a846bc1a713b57c5a5eeb3d75f8ba79dbe66de3b": {
                    "link": "http:\/\/antiochschool.org\/joomla_antioch\/index.php\/school-calendar\/day.listevents\/2019\/05\/14\/28",
                    "expiry": 1566252345
                }
            }
        }
    }
}

Time

Memory

25 Queries Logged 9.08 ms

1. Query Time: 0.56 ms Query memory: 0.004 MB Memory before query: 0.703 MB

   DELETE 
   
     FROM `ypscx_session`
   
     WHERE `time` < '1566241545'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ypscx_session	range	time	time	59	const	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.04 ms
   init	0.01 ms
   System lock	0.05 ms
   updating	0.31 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
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
   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.]

   ---

2. Query Time: 0.23 ms After last query: 0.34 ms Query memory: 0.010 MB Memory before query: 0.713 MB Rows returned: 0

   SELECT `data`
   
     FROM `ypscx_session`
   
     WHERE `session_id` = '47477d14b149099a6c7396067079d08a'

   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.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.02 ms
   checking permissions	0.00 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.02 ms
   optimizing	0.01 ms
   statistics	0.09 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	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.00 ms
   storing result in query cache	0.00 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.]

   ---

3. Query Time: 0.17 ms After last query: 0.46 ms Query memory: 0.005 MB Memory before query: 0.731 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `ypscx_session`
   
     WHERE `session_id` = '47477d14b149099a6c7396067079d08a' 
     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.02 ms
   checking permissions	0.00 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.00 ms
   statistics	0.02 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.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.06 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.]

   ---

4. Query Time: 0.20 ms After last query: 0.06 ms Query memory: 0.005 MB Memory before query: 0.738 MB

   INSERT INTO `ypscx_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('47477d14b149099a6c7396067079d08a', 1, '1566252345', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `ypscx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('47477d14b149099a6c7396067079d08a', 1, '1566252345', 0, '', 0)

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.04 ms
   Waiting for query cache lock	0.00 ms
   update	0.01 ms
   end	0.00 ms
   query end	0.07 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.]

   ---

5. Query Time: 0.08 ms After last query: 1.94 ms Query memory: 0.007 MB Memory before query: 0.896 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.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: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.]

   ---

6. Query Time: 0.04 ms After last query: 0.07 ms Query memory: 0.007 MB Memory before query: 0.910 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.]

   ---

7. Query Time: 0.24 ms After last query: 3.88 ms Query memory: 0.006 MB Memory before query: 1.227 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.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.02 ms
   checking permissions	0.00 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.02 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.00 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.]

   ---

8. Query Time: 0.42 ms After last query: 8.50 ms Query memory: 0.009 MB Memory before query: 2.221 MB

   UPDATE `ypscx_extensions`
   
     SET `params` = '{\"mediaversion\":\"cb69a3ae8ee2d4c3ca95ca213e650c0e\"}'
   
     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.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.06 ms
   updating	0.05 ms
   end	0.00 ms
   Waiting for query cache lock	0.13 ms
   end	0.02 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.]

   ---

9. Query Time: 0.08 ms After last query: 8.65 ms Query memory: 0.015 MB Memory before query: 2.773 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.00 ms
   sending cached result to clien	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
   20	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
   19	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
   18	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
   17	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
   16	JUser->authorise()	JROOT/components/com_jevents/libraries/helper.php:2265
   15	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:2347
   14	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:40
   13	JEventsDataModel->__construct()	JROOT/components/com_jevents/views/default/abstract/abstract.php:59
   12	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/geraint/abstract/abstract.php:28
   11	JEventsGeraintView->__construct()	JROOT/libraries/legacy/controller/legacy.php:597
   10	JControllerLegacy->createView()	JROOT/libraries/legacy/controller/legacy.php:843
   9	JControllerLegacy->getView()	JROOT/components/com_jevents/controllers/day.php:64
   8	DayController->listevents()	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.]

   ---

10. Query Time: 2.18 ms After last query: 3.26 ms Query memory: 0.017 MB Memory before query: 2.947 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.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.38 ms
    closing tables	0.00 ms
    freeing items	0.02 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/legacy/table/content.php:33
    21	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
    20	JTable::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:11
    19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:13
    17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
    15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/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/day.php:81
    8	DayController->listevents()	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.]

    ---

11. Query Time: 0.10 ms After last query: 3.31 ms Query memory: 0.018 MB Memory before query: 3.121 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.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
    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
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    26	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
    25	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    24	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    22	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    20	JEventDispatcher->trigger()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:19
    19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:13
    17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
    15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/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/day.php:81
    8	DayController->listevents()	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.]

    ---

12. Query Time: 1.87 ms After last query: 6.29 ms Query memory: 0.020 MB Memory before query: 3.326 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.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	1.20 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.04 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
    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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.31 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    29	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    28	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    27	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    26	JTable->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:69
    25	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:2205
    24	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1098
    23	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:50
    22	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
    21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
    20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
    19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2679
    18	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:705
    17	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:6
    16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/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/day.php:81
    8	DayController->listevents()	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.]

    ---

13. Query Time: 0.10 ms After last query: 0.93 ms Query memory: 0.019 MB Memory before query: 3.392 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.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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/components/com_jevents/helpers/category.php:47
    26	JEventsCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    25	JCategories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:90
    24	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
    23	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
    22	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
    21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
    20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
    19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2679
    18	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:705
    17	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:6
    16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/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/day.php:81
    8	DayController->listevents()	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.]

    ---

14. Query Time: 0.05 ms After last query: 0.32 ms Query memory: 0.018 MB Memory before query: 3.474 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.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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    25	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:172
    24	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
    23	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
    22	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
    21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
    20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
    19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2679
    18	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:705
    17	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:6
    16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/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/day.php:81
    8	DayController->listevents()	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.]

    ---

15. Query Time: 0.04 ms After last query: 0.34 ms Query memory: 0.016 MB Memory before query: 3.508 MB Rows returned: 1

    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>=9 
      AND c.rgt<=10 ))
    
      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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    21	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:172
    20	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:2345
    19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2679
    18	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:705
    17	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:6
    16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/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/day.php:81
    8	DayController->listevents()	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.]

    ---

16. Query Time: 2.00 ms After last query: 0.11 ms Query memory: 0.016 MB Memory before query: 3.523 MB Rows returned: 1

    SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids
     , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
     , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
     , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
     , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
     
      FROM ypscx_jevents_repetition as rpt
     
      INNER JOIN ypscx_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN ypscx_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      INNER JOIN ypscx_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN ypscx_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid 
     
      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 rpt.endrepeat >= '2019-05-14 00:00:00' 
      AND rpt.startrepeat <= '2019-05-14 23:59:59'
     
      AND NOT (rpt.startrepeat < '2019-05-14 00:00:00' 
      AND det.multiday=0)  
      AND ev.state=1 
      AND  catmap.catid IN(-1,28)
     
      AND ev.access IN (1,1)  
      AND icsf.state=1 
      AND icsf.access IN (1,1)
     
      GROUP BY rpt.rp_id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	rpt	range	PRIMARY,duplicatecheck,eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	8	NULL	33	100.00	Using index condition; Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	wikipeds_antioch.rpt.eventid	1	100.00	Using where
    1	SIMPLE	rr	ref	eventid	eventid	4	wikipeds_antioch.rpt.eventid	1	100.00	NULL
    1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	wikipeds_antioch.rpt.eventdetail_id	1	100.00	Using where
    1	SIMPLE	catmap	ref	key_event_category,key_evid	key_event_category	4	wikipeds_antioch.rpt.eventid	1	100.00	Using where; Using index
    1	SIMPLE	catmapcat	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.catmap.catid	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.14 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.09 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.05 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.03 ms
    Creating tmp table	0.10 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.86 ms
    Creating sort index	0.05 ms
    end	0.00 ms
    removing tmp table	0.29 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.02 ms
    removing tmp table	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.00 ms
    cleaning up	0.06 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2569
    20	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2518
    19	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2679
    18	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:705
    17	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:6
    16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/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/day.php:81
    8	DayController->listevents()	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.]

    ---

17. Query Time: 0.07 ms After last query: 1.35 ms Query memory: 0.016 MB Memory before query: 3.662 MB Rows returned: 12

    SELECT c.* 
      FROM ypscx_categories as c 
      WHERE extension='com_jevents' 
      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	cat_idx	202	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
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/commonfunctions.php:92
    19	JEV_CommonFunctions::getCategoryData()	JROOT/components/com_jevents/libraries/commonfunctions.php:117
    18	JEV_CommonFunctions::setColor()	JROOT/components/com_jevents/libraries/jeventcal.php:313
    17	jEventCal->bgcolor()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:55
    16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/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/day.php:81
    8	DayController->listevents()	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.]

    ---

18. Query Time: 0.25 ms After last query: 0.89 ms Query memory: 0.014 MB Memory before query: 3.724 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.19 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:25
    18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:58
    16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/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/day.php:81
    8	DayController->listevents()	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.]

    ---

19. Query Time: 0.04 ms After last query: 0.05 ms Query memory: 0.014 MB Memory before query: 3.746 MB Rows returned: 1

    SELECT * 
      FROM ypscx_jev_defaults 
      WHERE state=1 
      AND name= 'icalevent.list_row' 
      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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:47
    18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:58
    16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/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/day.php:81
    8	DayController->listevents()	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.]

    ---

20. Query Time: 0.05 ms After last query: 1.21 ms Query memory: 0.017 MB Memory before query: 3.833 MB Rows returned: 12

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cat	ref	cat_idx	cat_idx	202	const	12	100.00	Using index condition
    1	SIMPLE	pcat	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.cat.parent_id	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.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
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/jeventcal.php:336
    22	jEventCal->getCategoryData()	JROOT/components/com_jevents/libraries/jeventcal.php:449
    21	jEventCal->getCategoryName()	JROOT/components/com_jevents/libraries/jicaleventdb.php:507
    20	jIcalEventDB->getCategoryName()	JROOT/components/com_jevents/libraries/jeventcal.php:297
    19	jEventCal->catname()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:455
    18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:58
    16	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php:4
    15	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/geraint/day/tmpl/listevents.php	JROOT/libraries/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/day.php:81
    8	DayController->listevents()	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.]

    ---

21. Query Time: 0.06 ms After last query: 2.95 ms Query memory: 0.008 MB Memory before query: 3.873 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.]

    ---

22. Query Time: 0.05 ms After last query: 0.06 ms Query memory: 0.008 MB Memory before query: 3.883 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.]

    ---

23. Query Time: 0.06 ms After last query: 7.65 ms Query memory: 0.009 MB Memory before query: 3.972 MB Rows returned: 0
    Duplicate queries: #24

    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.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
    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.]

    ---

24. Query Time: 0.06 ms After last query: 1.83 ms Query memory: 0.007 MB Memory before query: 4.510 MB Rows returned: 0
    Duplicate queries: #23

    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.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
    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.]

    ---

25. Query Time: 0.09 ms After last query: 64.07 ms Query memory: 0.009 MB Memory before query: 4.797 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.01 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.]

    ---

23 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT c.id 
     FROM ypscx_categories AS c

2. 2 × SELECT menutype  
     FROM  ypscx_menu

3. 1 × SELECT `data` 
     FROM `ypscx_session`

4. 1 × SELECT c.* 
     FROM ypscx_categories as c

5. 1 × SELECT * 
     FROM ypscx_menu

6. 1 × SELECT * 
     FROM ypscx_template_styles

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

8. 1 × SELECT * 
     FROM ypscx_jev_defaults

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

10. 1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids  , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
      FROM ypscx_jevents_repetition as rpt  
      INNER JOIN ypscx_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id  
      INNER JOIN ypscx_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid   
      INNER JOIN ypscx_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id  
      LEFT JOIN ypscx_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid   
      LEFT JOIN   ypscx_jevents_catmap as catmap 
      ON catmap.evid = rpt.eventid   
      LEFT JOIN   ypscx_categories AS catmapcat 
      ON catmap.catid = catmapcat.id

11. 1 × SELECT `session_id` 
      FROM `ypscx_session`

12. 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

13. 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

14. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `ypscx_assets`

15. 1 × SELECT `enabled` 
      FROM `ypscx_extensions`

16. 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

17. 1 × SELECT id, rules 
      FROM `ypscx_viewlevels

18. 1 × SELECT * 
      FROM ypscx_acymailing_confi

OTHER Tables:

1. 1 × DELETE  
     FROM `ypscx_session`

2. 1 × INSERT INTO `ypscx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('47477d14b149099a6c7396067079d08a', 1, '1566252345', 0, '', 0

3. 1 × UPDATE `ypscx_extensions` 
     SET `params` = '{\"mediaversion\":\"cb69a3ae8ee2d4c3ca95ca213e650c0e\"}'

4. 1 × SHOW FULL COLUMNS 
     FROM `ypscx_content

5. 1 × SHOW FULL COLUMNS 
     FROM `ypscx_jev_users