Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1576320594,
                "last": 1576320594,
                "now": 1576320594
            }
        },
        "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": {
                "96c6308bd73ecebe8831377285a5fb55b43464d9": {
                    "link": "http:\/\/phoenixcitygrille.com\/index.php\/events\/icalrepeat.detail\/2019\/04\/19\/9498\/-\/-",
                    "expiry": 1576320595
                }
            }
        }
    }
}

Time

Memory

46 Queries Logged 393.50 ms

1. Query Time: 0.78 ms Query memory: 0.010 MB Memory before query: 0.723 MB Rows returned: 0

   SELECT `data`
   
     FROM `igl_session`
   
     WHERE `session_id` = 'p3r68q2eju0k1cce2an87cpfg5'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	igl_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

   Status	Duration
   starting	0.09 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.19 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.05 ms
   init	0.03 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.07 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.01 ms
   storing result in query cache	0.84 ms
   logging slow query	0.01 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.]

   ---

2. Query Time: 0.74 ms After last query: 0.56 ms Query memory: 0.005 MB Memory before query: 0.742 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `igl_session`
   
     WHERE `session_id` = 'p3r68q2eju0k1cce2an87cpfg5' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	igl_session	const	PRIMARY	PRIMARY	194	const	1	Using index

   Profile

   Status	Duration
   starting	0.07 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.03 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.01 ms
   storing result in query cache	0.12 ms
   logging slow query	0.01 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.]

   ---

3. Query Time: 6.97 ms After last query: 0.14 ms Query memory: 0.005 MB Memory before query: 0.748 MB

   INSERT INTO `igl_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('p3r68q2eju0k1cce2an87cpfg5', 1, '1576320594', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `igl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('p3r68q2eju0k1cce2an87cpfg5', 1, '1576320594', 0, '', 0)

   Profile

   Status	Duration
   starting	0.14 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.02 ms
   update	0.09 ms
   Waiting for query cache lock	0.01 ms
   update	0.05 ms
   end	0.01 ms
   query end	6.44 ms
   closing tables	0.03 ms
   freeing items	0.10 ms
   logging slow query	0.01 ms
   cleaning up	0.01 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.]

   ---

4. Query Time: 0.33 ms After last query: 0.75 ms Query memory: 0.007 MB Memory before query: 0.777 MB Rows returned: 32

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `igl_extensions`
   
     WHERE `type` = 'component'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	igl_extensions	ref	extension	extension	82	const	32	Using where

   Profile

   Status	Duration
   starting	0.12 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.11 ms
   logging slow query	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
   8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
   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.]

   ---

5. Query Time: 0.19 ms After last query: 0.97 ms Query memory: 0.007 MB Memory before query: 0.810 MB Rows returned: 3

   SELECT id, rules
   
     FROM `igl_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.06 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.02 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.08 ms
   logging slow query	0.01 ms
   cleaning up	0.01 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.20 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 0.824 MB Rows returned: 1

   SELECT b.id
   
     FROM igl_usergroups AS a
   
     LEFT JOIN igl_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	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	8	Using index

   Profile

   Status	Duration
   starting	0.06 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.08 ms
   logging slow query	0.01 ms
   cleaning up	0.01 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: 0.27 ms Query memory: 0.007 MB Memory before query: 0.847 MB Rows returned: 83

   SELECT `folder` AS `type`,`element` AS `name`,`params`
   
     FROM igl_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	igl_extensions	ref	extension	extension	82	const	96	Using where; Using filesort

   Profile

   Status	Duration
   starting	0.08 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.08 ms
   logging slow query	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
   8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
   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.]

   ---

8. Query Time: 0.37 ms After last query: 6.17 ms Query memory: 0.012 MB Memory before query: 1.332 MB Rows returned: 91
   Duplicate queries: #44

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM igl_menu AS m
   
     LEFT JOIN igl_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	248	Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	phoeni62.m.component_id	1

   Profile

   Status	Duration
   starting	0.07 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.18 ms
   logging slow query	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
   16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
   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.21 ms After last query: 6.36 ms Query memory: 0.009 MB Memory before query: 1.907 MB Rows returned: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `igl_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

   Status	Duration
   starting	0.07 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.02 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.09 ms
   logging slow query	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
   13	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
   12	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
   10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
   9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
   8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
   7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
   6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
   4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
   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: 5.78 ms After last query: 0.22 ms Query memory: 0.007 MB Memory before query: 1.901 MB

    UPDATE `igl_extensions`
    
      SET `params` = '{\"mediaversion\":\"44414f023eca2fe15458ccdfa1cd41ac\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `igl_extensions` SET `params` = '{\"mediaversion\":\"44414f023eca2fe15458ccdfa1cd41ac\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    init	0.12 ms
    Updating	0.11 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.37 ms
    query end	4.80 ms
    closing tables	0.02 ms
    freeing items	0.10 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    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.21 ms After last query: 0.70 ms Query memory: 0.005 MB Memory before query: 1.979 MB Rows returned: 1

    SELECT *
    
      FROM igl_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.08 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    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: 0.83 ms After last query: 0.30 ms Query memory: 0.004 MB Memory before query: 1.992 MB Rows returned: 6

    SELECT id, home, template, s.params
    
      FROM igl_template_styles as s
    
      LEFT JOIN igl_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	12	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	phoeni62.s.template,const	1	Using where

    Profile

    Status	Duration
    starting	0.06 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.04 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.16 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.32 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    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.25 ms After last query: 13.43 ms Query memory: 0.012 MB Memory before query: 2.376 MB Rows returned: 32

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `igl_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	igl_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	187	Using where

    Profile

    Status	Duration
    starting	0.08 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.02 ms
    sending cached result to clien	0.09 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:2403
    11	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:2485
    10	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:38
    9	JEventsDataModel->__construct()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:36
    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.]

    ---

14. Query Time: 0.19 ms After last query: 5.28 ms Query memory: 0.010 MB Memory before query: 2.519 MB Rows returned: 1

    SELECT `id`
    
      FROM `igl_finder_types`
    
      WHERE `title` = 'Event'

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.08 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:40
    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.]

    ---

15. Query Time: 0.21 ms After last query: 5.19 ms Query memory: 0.009 MB Memory before query: 2.541 MB Rows returned: 1

    SELECT `id`
    
      FROM `igl_finder_types`
    
      WHERE `title` = 'Tag'

    Explain

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

    Profile

    Status	Duration
    starting	0.08 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.21 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:40
    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.]

    ---

16. Query Time: 0.28 ms After last query: 1.48 ms Query memory: 0.009 MB Memory before query: 2.557 MB Rows returned: 1

    SELECT `id`
    
      FROM `igl_finder_types`
    
      WHERE `title` = 'Category'

    Explain

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

    Profile

    Status	Duration
    starting	0.15 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.11 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:40
    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.]

    ---

17. Query Time: 0.23 ms After last query: 1.53 ms Query memory: 0.010 MB Memory before query: 2.575 MB Rows returned: 1

    SELECT `id`
    
      FROM `igl_finder_types`
    
      WHERE `title` = 'Contact'

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.08 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:40
    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.]

    ---

18. Query Time: 0.21 ms After last query: 1.41 ms Query memory: 0.009 MB Memory before query: 2.653 MB Rows returned: 1

    SELECT `id`
    
      FROM `igl_finder_types`
    
      WHERE `title` = 'Article'

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.08 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:40
    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.]

    ---

19. Query Time: 0.18 ms After last query: 1.29 ms Query memory: 0.009 MB Memory before query: 2.668 MB Rows returned: 1

    SELECT `id`
    
      FROM `igl_finder_types`
    
      WHERE `title` = 'News Feed'

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.08 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:40
    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.]

    ---

20. Query Time: 0.19 ms After last query: 1.32 ms Query memory: 0.009 MB Memory before query: 2.683 MB Rows returned: 1

    SELECT `id`
    
      FROM `igl_finder_types`
    
      WHERE `title` = 'Web Link'

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.08 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:40
    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.]

    ---

21. Query Time: 319.66 ms After last query: 3.01 ms Query memory: 0.013 MB Memory before query: 2.768 MB Rows returned: 18

    SHOW FULL COLUMNS 
      FROM `igl_jev_users`

    Explain

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

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    Opening tables	318.18 ms
    System lock	0.03 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    Opening tables	0.03 ms
    checking permissions	0.06 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    Sending data	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.17 ms
    closing tables	0.02 ms
    freeing items	2.32 ms
    logging slow query	0.02 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:2343
    14	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1727
    13	JEVHelper::isEventPublisher()	JROOT/components/com_jevents/libraries/dbmodel.php:3237
    12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:724
    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:151
    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.]

    ---

22. Query Time: 3.53 ms After last query: 2.04 ms Query memory: 0.014 MB Memory before query: 2.904 MB Rows returned: 11
    Duplicate queries: #23

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM igl_modules AS m
    
      LEFT JOIN igl_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN igl_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-12-14 10:49:55') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-14 10:49:55') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 270 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	24	Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	phoeni62.m.module,const	1	Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	phoeni62.m.id	1	Using where; Using index

    Profile

    Status	Duration
    starting	0.09 ms
    Waiting for query cache lock	0.76 ms
    checking query cache for query	0.23 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.06 ms
    init	0.09 ms
    optimizing	0.05 ms
    statistics	0.13 ms
    preparing	0.08 ms
    executing	0.02 ms
    Sorting result	0.37 ms
    Sending data	1.16 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.10 ms
    Waiting for query cache lock	0.01 ms
    freeing items	1.09 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    19	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
    18	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
    17	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:332
    16	JModuleHelper::_load()	JROOT/components/com_jevents/libraries/jevmodulehelper.php:22
    15	JevModuleHelper::getVisibleModules()	JROOT/components/com_jevents/libraries/filters.php:54
    14	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
    13	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3263
    12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:724
    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:151
    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.]

    ---

23. Query Time: 0.51 ms After last query: 0.86 ms Query memory: 0.014 MB Memory before query: 2.943 MB Rows returned: 11
    Duplicate queries: #22

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM igl_modules AS m
    
      LEFT JOIN igl_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN igl_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-12-14 10:49:55') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-14 10:49:55') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 270 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	24	Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	phoeni62.m.module,const	1	Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	phoeni62.m.id	1	Using where; Using index

    Profile

    Status	Duration
    starting	0.15 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	1.13 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    20	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
    19	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
    18	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:34
    17	JModuleHelper::getModule()	JROOT/components/com_jevents/libraries/filters.php:307
    16	jevFilter->__construct()	JROOT/components/com_jevents/libraries/filters/Justmine.php:44
    15	jevJustmineFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
    14	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
    13	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3263
    12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:724
    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:151
    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.]

    ---

24. Query Time: 0.43 ms After last query: 1.69 ms Query memory: 0.012 MB Memory before query: 2.977 MB Rows returned: 6

    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 igl_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	Extra
    1	SIMPLE	c	range	cat_idx,idx_access	cat_idx	208	NULL	6	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.10 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.11 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:77
    13	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:3270
    12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:724
    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:151
    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.]

    ---

25. Query Time: 0.43 ms After last query: 0.56 ms Query memory: 0.010 MB Memory before query: 3.017 MB Rows returned: 5

    SELECT c.id
    
      FROM igl_categories AS c
    
      WHERE c.access   IN (1,1)
     
      AND c.published = 1
      
      AND c.language in ('en-GB','*')
     
      AND c.extension = 'com_jevents'
     
    
      ORDER BY c.lft asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	208	NULL	5	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.14 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.11 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:186
    13	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:3270
    12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:724
    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:151
    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.]

    ---

26. Query Time: 2.13 ms After last query: 0.26 ms Query memory: 0.009 MB Memory before query: 3.026 MB Rows returned: 1

    SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , 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 (igl_jevents_vevent as ev )
     
      INNER JOIN igl_jevents_repetition as rpt 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN igl_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN igl_jevents_rrule as rr 
      ON rr.eventid = ev.ev_id
     
      INNER JOIN igl_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      WHERE ev.catid IN(-1,50,51,57,58,59)
     
      AND ev.access IN (1,1) 
      AND icsf.access IN (1,1)
     
      AND rpt.rp_id = '9498'
     
      GROUP BY rpt.rp_id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rpt	const	PRIMARY,eventid,eventstart,eventend,eventdetail	PRIMARY	4	const	1
    1	SIMPLE	det	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	ev	const	PRIMARY,icsid,evaccess	PRIMARY	4	const	1
    1	SIMPLE	icsf	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	rr	ref	eventid	eventid	4	const	1

    Profile

    Status	Duration
    starting	0.09 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.30 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
    Opening tables	0.06 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.08 ms
    init	0.17 ms
    optimizing	0.05 ms
    statistics	0.27 ms
    preparing	0.08 ms
    executing	0.06 ms
    Sending data	0.24 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.11 ms
    Waiting for query cache lock	0.01 ms
    freeing items	1.63 ms
    Waiting for query cache lock	2.21 ms
    freeing items	0.02 ms
    storing result in query cache	0.02 ms
    logging slow query	0.01 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:3316
    12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:724
    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:151
    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.]

    ---

27. Query Time: 3.11 ms After last query: 1.15 ms Query memory: 0.010 MB Memory before query: 3.149 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 igl_users AS ju
     
      LEFT JOIN igl_contact_details AS cd 
      ON cd.user_id = ju.id 
     
      LEFT JOIN igl_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 = 554

    Explain

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

    Profile

    Status	Duration
    starting	0.11 ms
    Waiting for query cache lock	0.05 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.28 ms
    sending cached result to clien	0.12 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:2278
    13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:635
    12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:756
    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:151
    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.]

    ---

28. Query Time: 0.28 ms After last query: 0.22 ms Query memory: 0.010 MB Memory before query: 3.161 MB Rows returned: 1

    SELECT `id`
    
      FROM `igl_users`
    
      WHERE `id` = '554' 
      LIMIT 1

    Explain

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

    Profile

    Status	Duration
    starting	0.09 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.59 ms
    logging slow query	0.01 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/components/com_jevents/libraries/helper.php:3220
    14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2285
    13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:635
    12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:756
    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:151
    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.]

    ---

29. Query Time: 15.52 ms After last query: 0.39 ms Query memory: 0.016 MB Memory before query: 3.178 MB Rows returned: 16

    SHOW FULL COLUMNS 
      FROM `igl_users`

    Explain

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

    Profile

    Status	Duration
    starting	0.16 ms
    checking permissions	0.02 ms
    Opening tables	13.76 ms
    System lock	0.03 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.02 ms
    Opening tables	0.03 ms
    checking permissions	0.10 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    Sending data	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.17 ms
    closing tables	0.02 ms
    freeing items	0.90 ms
    logging slow query	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:3226
    14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2285
    13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:635
    12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:756
    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:151
    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.]

    ---

30. Query Time: 0.31 ms After last query: 0.42 ms Query memory: 0.014 MB Memory before query: 3.219 MB Rows returned: 1

    SELECT *
    
      FROM `igl_users`
    
      WHERE `id` = 554

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	igl_users	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    starting	0.08 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.02 ms
    sending cached result to clien	0.83 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:3226
    14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2285
    13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:635
    12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:756
    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:151
    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.]

    ---

31. Query Time: 0.48 ms After last query: 0.62 ms Query memory: 0.014 MB Memory before query: 3.239 MB Rows returned: 1

    SELECT `g`.`id`,`g`.`title`
    
      FROM `igl_usergroups` AS g
    
      INNER JOIN `igl_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 554

    Explain

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

    Profile

    Status	Duration
    starting	0.18 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	3.01 ms
    logging slow query	0.02 ms
    cleaning up	0.01 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:3226
    14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2285
    13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:635
    12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:756
    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:151
    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.]

    ---

32. Query Time: 11.45 ms After last query: 3.24 ms Query memory: 0.008 MB Memory before query: 3.279 MB

    UPDATE igl_jevents_vevdetail 
      SET hits=(hits+1) 
      WHERE evdet_id='308'

    Explain

    EXPLAIN not possible on query: UPDATE igl_jevents_vevdetail SET hits=(hits+1) WHERE evdet_id='308'

    Profile

    Status	Duration
    starting	0.16 ms
    checking permissions	0.01 ms
    Opening tables	0.13 ms
    System lock	0.02 ms
    init	0.07 ms
    Updating	0.19 ms
    end	0.11 ms
    Waiting for query cache lock	0.01 ms
    end	2.54 ms
    query end	7.82 ms
    closing tables	0.03 ms
    freeing items	3.42 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:846
    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:151
    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.]

    ---

33. Query Time: 0.32 ms After last query: 3.20 ms Query memory: 0.014 MB Memory before query: 3.418 MB Rows returned: 5

    SELECT a.id, a.parent_id
    
      FROM igl_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	Extra
    1	SIMPLE	a	ref	cat_idx,idx_language	cat_idx	203	const,const	5	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.09 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.38 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:27
    16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
    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:151
    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.]

    ---

34. Query Time: 0.38 ms After last query: 0.18 ms Query memory: 0.013 MB Memory before query: 3.435 MB Rows returned: 0

    SELECT * 
      FROM igl_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	Extra
    1	SIMPLE	igl_jev_defaults	ref	name,langcodename	name	152	const	6	Using where

    Profile

    Status	Duration
    starting	0.09 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.02 ms
    sending cached result to clien	0.15 ms
    logging slow query	0.04 ms
    cleaning up	0.01 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:49
    16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
    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:151
    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.]

    ---

35. Query Time: 0.38 ms After last query: 0.66 ms Query memory: 0.016 MB Memory before query: 3.459 MB Rows returned: 21

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `igl_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	Extra
    1	SIMPLE	igl_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	187	Using where

    Profile

    Status	Duration
    starting	0.15 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.02 ms
    sending cached result to clien	0.89 ms
    logging slow query	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/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:2708
    18	JEVHelper::authoriseCategories()	JROOT/components/com_jevents/libraries/helper.php:2191
    17	JEVHelper::canDeleteEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:825
    16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
    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:151
    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.]

    ---

36. Query Time: 1.16 ms After last query: 2.25 ms Query memory: 0.014 MB Memory before query: 3.506 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 igl_jevents_repetition  as rpt
    			 
      LEFT JOIN igl_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id 
      WHERE rpt.eventid=308 
      AND rpt.rp_id <> 9498 
      AND rpt.startrepeat<='2019-04-19 16:00:00' 
      ORDER BY rpt.startrepeat DESC 
      limit 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rpt	ref	PRIMARY,eventid,eventstart,eventend,startrepeat,startend	eventstart	4	const	1	Using where
    1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	phoeni62.rpt.eventdetail_id	1

    Profile

    Status	Duration
    starting	0.09 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.19 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.05 ms
    init	0.06 ms
    optimizing	0.03 ms
    statistics	0.22 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sorting result	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.09 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.28 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.71 ms
    logging slow query	0.01 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:415
    19	jIcalEventRepeat->getAdjacentRepeats()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:378
    18	jIcalEventRepeat->prevRepeat()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:327
    17	jIcalEventRepeat->previousnextLinks()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1298
    16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
    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:151
    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.]

    ---

37. Query Time: 2.58 ms After last query: 0.14 ms Query memory: 0.014 MB Memory before query: 3.521 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 igl_jevents_repetition  as rpt
    			 
      LEFT JOIN igl_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id 
      WHERE rpt.eventid=308 
      AND rpt.rp_id <> 9498 
      AND rpt.startrepeat>='2019-04-19 16:00:00' 
      ORDER BY rpt.startrepeat ASC 
      limit 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rpt	ref	PRIMARY,eventid,eventstart,eventend,startrepeat,startend	eventstart	4	const	1	Using where
    1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	phoeni62.rpt.eventdetail_id	1

    Profile

    Status	Duration
    starting	0.09 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.52 ms
    init	0.09 ms
    optimizing	0.06 ms
    statistics	0.31 ms
    preparing	0.07 ms
    executing	0.02 ms
    Sorting result	0.01 ms
    Sending data	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.15 ms
    Waiting for query cache lock	0.01 ms
    freeing items	3.01 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.01 ms
    storing result in query cache	0.46 ms
    logging slow query	0.01 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:431
    19	jIcalEventRepeat->getAdjacentRepeats()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:378
    18	jIcalEventRepeat->prevRepeat()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:327
    17	jIcalEventRepeat->previousnextLinks()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1298
    16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
    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:151
    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.]

    ---

38. Query Time: 3.10 ms After last query: 3.84 ms Query memory: 0.016 MB Memory before query: 3.505 MB Rows returned: 31

    SHOW FULL COLUMNS 
      FROM `igl_content`

    Explain

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

    Profile

    Status	Duration
    starting	0.43 ms
    checking permissions	0.02 ms
    Opening tables	0.81 ms
    System lock	0.02 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	0.04 ms
    checking permissions	0.07 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.18 ms
    closing tables	0.02 ms
    freeing items	2.72 ms
    logging slow query	0.02 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:160
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:13
    16	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
    15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
    14	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
    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:151
    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.]

    ---

39. Query Time: 0.75 ms After last query: 2.47 ms Query memory: 0.017 MB Memory before query: 3.592 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 igl_fields AS a
    
      LEFT JOIN `igl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN igl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN igl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN igl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN igl_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	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	phoeni62.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	phoeni62.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	phoeni62.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	phoeni62.a.created_user_id	1
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	phoeni62.a.group_id	1	Using where

    Profile

    Status	Duration
    starting	0.10 ms
    Waiting for query cache lock	0.35 ms
    checking query cache for query	0.03 ms
    checking privileges on cached	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 cached result to clien	2.64 ms
    logging slow query	0.01 ms
    cleaning up	0.01 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:160
    17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:13
    16	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
    15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
    14	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
    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:151
    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.]

    ---

40. Query Time: 0.67 ms After last query: 18.80 ms Query memory: 0.008 MB Memory before query: 3.773 MB Rows returned: 1

    SELECT * 
      FROM igl_template_styles 
      WHERE template = 'modern_flavor';

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	igl_template_styles	ref	idx_template	idx_template	202	const	1	Using where

    Profile

    Status	Duration
    starting	0.19 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.04 ms
    checking permissions	0.02 ms
    sending cached result to clien	0.24 ms
    logging slow query	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    10	JDatabaseDriver->loadAssocList()	JROOT/templates/modern_flavor/vertex/parameters.php:19
    9	getTemplateName()	JROOT/templates/modern_flavor/vertex/parameters.php:144
    8	require JROOT/templates/modern_flavor/vertex/parameters.php	JROOT/templates/modern_flavor/index.php:50
    7	require JROOT/templates/modern_flavor/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.]

    ---

41. Query Time: 0.43 ms After last query: 0.20 ms Query memory: 0.008 MB Memory before query: 3.783 MB Rows returned: 0

    SELECT * 
      FROM igl_menu 
      WHERE template_style_id IN (16) 
      AND alias = 'events'

    Explain

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

    Profile

    Status	Duration
    starting	0.20 ms
    Waiting for query cache lock	0.03 ms
    checking query cache for query	0.03 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.24 ms
    logging slow query	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    10	JDatabaseDriver->loadAssocList()	JROOT/templates/modern_flavor/vertex/parameters.php:40
    9	getTemplateName()	JROOT/templates/modern_flavor/vertex/parameters.php:144
    8	require JROOT/templates/modern_flavor/vertex/parameters.php	JROOT/templates/modern_flavor/index.php:50
    7	require JROOT/templates/modern_flavor/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.]

    ---

42. Query Time: 0.87 ms After last query: 13.67 ms Query memory: 0.009 MB Memory before query: 3.832 MB Rows returned: 0
    Duplicate queries: #43

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	igl_menu	ref	idx_language	idx_language	28	const	1	Using where

    Profile

    Status	Duration
    starting	0.11 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.12 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    11	JDatabaseDriver->loadResult()	JROOT/templates/modern_flavor/vertex/responsive/responsive_mobile_menu.php:139
    10	include JROOT/templates/modern_flavor/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/modern_flavor/vertex/responsive/responsive_mobile_top_bar.php:75
    9	require JROOT/templates/modern_flavor/vertex/responsive/responsive_mobile_top_bar.php	JROOT/templates/modern_flavor/vertex/includes/vertex_includes_top.php:3
    8	require JROOT/templates/modern_flavor/vertex/includes/vertex_includes_top.php	JROOT/templates/modern_flavor/index.php:177
    7	require JROOT/templates/modern_flavor/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.]

    ---

43. Query Time: 0.79 ms After last query: 20.29 ms Query memory: 0.007 MB Memory before query: 4.063 MB Rows returned: 0
    Duplicate queries: #42

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	igl_menu	ref	idx_language	idx_language	28	const	1	Using where

    Profile

    Status	Duration
    starting	0.12 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.34 ms
    sending cached result to clien	0.13 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    9	JDatabaseDriver->loadResult()	JROOT/templates/modern_flavor/vertex/s5flex_menu/default.php:45
    8	include JROOT/templates/modern_flavor/vertex/s5flex_menu/default.php	JROOT/templates/modern_flavor/index.php:235
    7	require JROOT/templates/modern_flavor/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.]

    ---

44. Query Time: 4.56 ms After last query: 0.63 ms Query memory: 0.012 MB Memory before query: 4.094 MB Rows returned: 91
    Duplicate queries: #8

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM igl_menu AS m
    
      LEFT JOIN igl_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	248	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	phoeni62.m.component_id	1

    Profile

    Status	Duration
    starting	0.10 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.21 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.06 ms
    init	0.06 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sorting result	0.50 ms
    Sending data	0.55 ms
    Waiting for query cache lock	0.02 ms
    Sending data	0.55 ms
    Waiting for query cache lock	0.02 ms
    Sending data	0.61 ms
    Waiting for query cache lock	0.02 ms
    Sending data	0.70 ms
    Waiting for query cache lock	0.02 ms
    Sending data	0.57 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.10 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
    15	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
    14	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
    13	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    12	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    11	JMenuSite->__construct()	JROOT/templates/modern_flavor/vertex/s5flex_menu/helpers.php:41
    10	S5modMainMenuHelper::getList()	JROOT/templates/modern_flavor/vertex/s5flex_menu/helpers.php:141
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/modern_flavor/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/modern_flavor/vertex/s5flex_menu/default.php	JROOT/templates/modern_flavor/index.php:235
    7	require JROOT/templates/modern_flavor/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.]

    ---

45. Query Time: 0.56 ms After last query: 20.63 ms Query memory: 0.014 MB Memory before query: 4.158 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 igl_fields AS a
    
      LEFT JOIN `igl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN igl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN igl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN igl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN igl_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_custom.content' 
      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	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	phoeni62.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	phoeni62.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	phoeni62.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	phoeni62.a.created_user_id	1
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	phoeni62.a.group_id	1	Using where

    Profile

    Status	Duration
    starting	0.11 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.03 ms
    checking privileges on cached	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 cached result to clien	0.11 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    20	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
    19	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    18	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    13	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:140
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    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.]

    ---

46. Query Time: 0.51 ms After last query: 14.95 ms Query memory: 0.012 MB Memory before query: 4.453 MB Rows returned: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM igl_categories as c
    
      LEFT JOIN igl_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=53
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	36	Using where

    Profile

    Status	Duration
    starting	0.12 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.12 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    16	JCategories->get()	JROOT/components/com_content/router.php:72
    15	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
    14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->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.]

    ---