Консоль отладки Joomla!

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1508508267,
                "last": 1508508267,
                "now": 1508508267
            },
            "token": "7QBFXRJIkkicfhUQNuASvIiFHv6zGdkT"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__easyblog": {
        "easyblog": {
            "callback": "s:74:\"https:\/\/gloriamusic.org.ua\/sobytiya-i-novosty\/551-trening-ya-i-moi-emotsii\";"
        }
    }
}

Time

Memory

31 SQL-запросов зафиксировано 59.91 ms

1. Query Time: 0.69 ms Query memory: 0.004 MB Memory before query: 2.353 MB

   DELETE 
   
     FROM `jos_session`
   
     WHERE `time` < '1508497467'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:818
   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:412
   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.50 ms After last query: 2.71 ms Query memory: 0.023 MB Memory before query: 2.448 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `jos_session`
   
     WHERE `session_id` = '4gijqhb1grtoos1qqvt0jgsv44' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 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:827
   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:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 0.61 ms After last query: 0.18 ms Query memory: 0.005 MB Memory before query: 2.454 MB

   INSERT INTO `jos_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('4gijqhb1grtoos1qqvt0jgsv44', 1, '1508508267', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('4gijqhb1grtoos1qqvt0jgsv44', 1, '1508508267', 0, '', 0)

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.06 ms
   end	0.00 ms
   query end	0.03 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 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:827
   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:412
   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.54 ms After last query: 10.92 ms Query memory: 0.024 MB Memory before query: 2.894 MB Rows returned: 1

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

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   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.]

   ---

5. Query Time: 0.43 ms After last query: 1.12 ms Query memory: 0.024 MB Memory before query: 3.005 MB Rows returned: 4

   SELECT id, rules
   
     FROM `jos_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   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.60 ms After last query: 38.41 ms Query memory: 0.008 MB Memory before query: 4.840 MB

   UPDATE `jos_extensions`
   
     SET `params` = '{\"mediaversion\":\"9fa4c1aa88800af129fbaafaea5fd7a4\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:115
   12	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
   11	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
   10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   8	JFactory::getDocument()	JROOT/plugins/system/easyblogcomposer/easyblogcomposer.php:27
   7	plgSystemEasyblogComposer->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 0.43 ms After last query: 46.61 ms Query memory: 0.024 MB Memory before query: 8.364 MB Rows returned: 1

   SELECT count(1)
   
     FROM `jos_session`
   
     WHERE `session_id` = '' 
     AND client_id = 1 
     AND guest = 0

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:53
   8	plgSystemARKtypography->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 10.47 ms After last query: 19.90 ms Query memory: 0.040 MB Memory before query: 9.340 MB Rows returned: 2
   Duplicate queries: #23

   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 jos_categories as c
   
     LEFT JOIN  (SELECT cat.id as id 
     FROM jos_categories AS cat JOIN jos_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt 
     WHERE parent.extension = 'com_content' 
     AND parent.published != 1 
     GROUP BY cat.id) AS badcats 
     ON badcats.id = c.id
   
     LEFT JOIN jos_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 badcats.id is null 
     AND s.id=79
   
     GROUP BY 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
   
     ORDER BY c.lft

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
   1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	237	23.21	Using where
   1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	gloriamu_db.c.id	137	100.00	Using where; Not exists; Using index
   2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	137	100.00	Using index condition; Using temporary; Using filesort
   2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	237	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

   Profile

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

   Call Stack

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:307
   13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
   12	JCategories->get()	JROOT/components/com_content/router.php:154
   11	ContentRouter->getCategoryId()	JROOT/libraries/cms/component/router/rules/standard.php:88
   10	JComponentRouterRulesStandard->parse()	JROOT/libraries/cms/component/router/view.php:263
   9	JComponentRouterView->parse()	JROOT/libraries/cms/router/site.php:432
   8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
   7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
   6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
   5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
   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.51 ms After last query: 4.03 ms Query memory: 0.026 MB Memory before query: 9.466 MB Rows returned: 1

   SELECT `id`, `alias`, `catid`, `language`
   
     FROM jos_content
   
     WHERE `id` = 551 
     LIMIT 1

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
   10	JDatabaseDriver->loadObject()	JROOT/plugins/system/jlnodoubles/helpers/com_content.php:37
   9	JLNodoubles_com_content_helper->go()	JROOT/plugins/system/jlnodoubles/jlnodoubles.php:140
   8	plgSystemJlnodoubles->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
   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.]

   ---

10. Query Time: 0.66 ms After last query: 2.19 ms Query memory: 0.037 MB Memory before query: 9.510 MB Rows returned: 1

    SELECT params
    
      FROM `jos_extensions`
    
      WHERE `element` = 'com_arkeditor' 
      AND `type` = 'component'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:127
    8	plgSystemARKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
    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.]

    ---

11. Query Time: 7.51 ms After last query: 40.49 ms Query memory: 0.123 MB Memory before query: 11.261 MB Rows returned: 27

    SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos_modules AS m
    
      LEFT JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jos_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 <= '2017-10-20 14:04:27') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-10-20 14:04:27') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 929 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	204	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	gloriamu_db.m.module,const	1	100.00	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	gloriamu_db.m.id	3	100.00	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:382
    16	JModuleHelper::_load()	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:104
    15	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:503
    14	JDocumentHtml->countModules()	JROOT/plugins/system/jat3/jat3/core/template.php:1213
    13	T3Template->countModules()	JROOT/plugins/system/jat3/jat3/core/template.php:710
    12	T3Template->hasBlock()	JROOT/plugins/system/jat3/jat3/core/template.php:1081
    11	T3Template->parseLayout()	JROOT/plugins/system/jat3/jat3/core/template.php:727
    10	T3Template->loadLayout()	JROOT/plugins/system/jat3/jat3/core/framework.php:153
    9	T3Framework::init_layout()	JROOT/plugins/system/jat3/jat3.php:276
    8	plgSystemJAT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
    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.]

    ---

12. Query Time: 0.40 ms After last query: 1.66 ms Query memory: 0.026 MB Memory before query: 11.431 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 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.]

    ---

13. Query Time: 1.09 ms After last query: 11.64 ms Query memory: 0.035 MB Memory before query: 11.863 MB Rows returned: 44

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos_assets`
    
      WHERE `name` IN ('com_acymailing','com_admin','com_ajax','com_arkeditor','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dxfontawesome','com_easyblog','com_fields','com_finder','com_foxcontact','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_nge','com_plugins','com_postinstall','com_redirect','com_rstbox','com_search','com_sitemapgenerator','com_smartslider3','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap') OR `parent_id` = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_assets	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	45	100.00	Using sort_union(idx_asset_name,idx_parent_id); Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
    16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
    15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
    14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:432
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:259
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:710
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:399
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:374
    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.98 ms After last query: 2.29 ms Query memory: 0.039 MB Memory before query: 11.975 MB Rows returned: 30

    SHOW FULL COLUMNS 
      FROM `jos_content`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
    11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
    10	JTable::getInstance()	JROOT/components/com_content/models/article.php:261
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:710
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:399
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:374
    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.54 ms After last query: 4.50 ms Query memory: 0.037 MB Memory before query: 12.214 MB Rows returned: 1
    Duplicate queries: #20

    SELECT *
    
      FROM jos_content
    
      WHERE `id` = '551'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    10	JTable->load()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:710
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:399
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:374
    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.50 ms After last query: 0.14 ms Query memory: 0.007 MB Memory before query: 12.227 MB

    UPDATE jos_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '551'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
    10	JTable->hit()	JROOT/components/com_content/models/article.php:263
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:710
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:399
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:374
    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: 6.49 ms After last query: 1.67 ms Query memory: 0.039 MB Memory before query: 12.293 MB Rows returned: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM jos_content AS a
    
      LEFT JOIN jos_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN jos_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN jos_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jos_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM jos_categories AS cat JOIN jos_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 551 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-20 14:04:27') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-20 14:04:27') 
      AND (a.state = 1 OR a.state =2)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using index
    2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	137	100.00	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	237	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    12	ContentModelArticle->getItem()	JROOT/plugins/system/jat3/jat3/core/joomla/viewlegacy.php:348
    11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:672
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:710
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:399
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:374
    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.56 ms After last query: 1.88 ms Query memory: 0.037 MB Memory before query: 12.459 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos_contentitem_tag_map` AS m 
    
      INNER JOIN `jos_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 551 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	gloriamu_db.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
    11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:180
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:672
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:710
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:399
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:374
    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: 1.38 ms After last query: 18.00 ms Query memory: 0.040 MB Memory before query: 13.573 MB Rows returned: 0

    SELECT a.id, a.title, a.alias, 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 jos_fields AS a
    
      LEFT JOIN `jos_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jos_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jos_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jos_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jos_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `jos_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (79,0)) 
      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)
    
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
    
      ORDER BY a.ordering ASC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:305
    17	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:334
    16	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    15	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:449
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:672
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:710
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:399
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:374
    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.63 ms After last query: 9.97 ms Query memory: 0.039 MB Memory before query: 13.939 MB Rows returned: 1
    Duplicate queries: #15

    SELECT *
    
      FROM jos_content
    
      WHERE `id` = '551'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    14	JTable->load()	JROOT/plugins/content/easyopengraph/easyopengraph.php:30
    13	plgContentEasyOpenGraph->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:196
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:672
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:710
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:399
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:374
    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: 2.98 ms After last query: 0.51 ms Query memory: 0.190 MB Memory before query: 13.959 MB Rows returned: 785

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
    18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    14	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
    13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:196
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:672
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:710
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:399
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:374
    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: 2.51 ms After last query: 1.68 ms Query memory: 0.046 MB Memory before query: 14.597 MB Rows returned: 110

    SELECT a.id, a.title, a.catid, a.language, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
    
      FROM jos_content AS a
    
      LEFT JOIN jos_categories AS cc 
      ON cc.id = a.catid
    
      WHERE a.catid = 79 
      AND a.state = 1 
      AND a.access IN (1,1)  
      AND (a.state = 1 OR a.state = -1) 
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2017-10-20 14:04:27') 
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2017-10-20 14:04:27')
    
      ORDER BY  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	112	100.00	Using where; Using filesort
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:152
    13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:196
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:672
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:710
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:399
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:374
    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: 9.95 ms After last query: 1.80 ms Query memory: 0.038 MB Memory before query: 14.628 MB Rows returned: 2
    Duplicate queries: #8

    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 jos_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM jos_categories AS cat JOIN jos_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN jos_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 badcats.id is null 
      AND s.id=79
    
      GROUP BY 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
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	237	23.21	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	gloriamu_db.c.id	137	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	137	100.00	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	237	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:307
    13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
    12	JCategories->get()	JROOT/components/com_content/views/article/view.html.php:246
    11	ContentViewArticle->_prepareDocument()	JROOT/components/com_content/views/article/view.html.php:205
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:672
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:710
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:399
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:374
    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: 2.81 ms After last query: 16.29 ms Query memory: 0.026 MB Memory before query: 14.912 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rstbox/helpers/helper.php:283
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    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.78 ms After last query: 43.40 ms Query memory: 0.048 MB Memory before query: 16.537 MB Rows returned: 169

    SELECT * 
      FROM jos_acymailing_config

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    17	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
    16	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1371
    15	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:12
    14	require JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:413
    10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
    9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
    8	T3Template->render()	JROOT/templates/ja_university/index.php:19
    7	require JROOT/templates/ja_university/index.php	JROOT/libraries/joomla/document/html.php:580
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:642
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:457
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
    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.]

    ---

26. Query Time: 0.68 ms After last query: 4.82 ms Query memory: 0.037 MB Memory before query: 16.935 MB Rows returned: 9

    SELECT * 
      FROM jos_acymailing_list 
      WHERE type = 'list'  
      ORDER BY ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_acymailing_list	ref	typeorderingindex,typeuseridindex	typeorderingindex	1	const	8	100.00	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
    15	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:104
    14	require JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:413
    10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
    9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
    8	T3Template->render()	JROOT/templates/ja_university/index.php:19
    7	require JROOT/templates/ja_university/index.php	JROOT/libraries/joomla/document/html.php:580
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:642
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:457
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
    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.]

    ---

27. Query Time: 0.68 ms After last query: 28.68 ms Query memory: 0.037 MB Memory before query: 19.202 MB Rows returned: 3

    SELECT * 
      FROM `jos_acymailing_fields` as a 
      WHERE a.`published` = 1 
      AND (a.access = 'all' OR a.access LIKE ('%,1,%')) 
      ORDER BY a.`ordering` ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	orderingindex	orderingindex	1	const	2	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:85
    15	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:200
    14	require JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:413
    10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
    9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
    8	T3Template->render()	JROOT/templates/ja_university/index.php:19
    7	require JROOT/templates/ja_university/index.php	JROOT/libraries/joomla/document/html.php:580
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:642
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:457
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
    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.]

    ---

28. Query Time: 0.63 ms After last query: 0.11 ms Query memory: 0.037 MB Memory before query: 19.226 MB Rows returned: 3

    SELECT * 
      FROM `jos_acymailing_fields`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:101
    15	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:200
    14	require JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:413
    10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
    9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
    8	T3Template->render()	JROOT/templates/ja_university/index.php:19
    7	require JROOT/templates/ja_university/index.php	JROOT/libraries/joomla/document/html.php:580
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:642
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:457
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 1.30 ms After last query: 12.22 ms Query memory: 0.089 MB Memory before query: 19.443 MB Rows returned: 1

    SELECT *
    
      FROM jos_easyblog_configs
    
      WHERE `name` = 'config'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    25	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    24	JTable->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:441
    23	EB::config()	JROOT/components/com_easyblog/router.php:19
    22	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    21	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
    20	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    19	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    16	JRoute::_()	JROOT/modules/mod_menu/helper.php:129
    15	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
    14	require JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:413
    10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
    9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
    8	T3Template->render()	JROOT/templates/ja_university/index.php:19
    7	require JROOT/templates/ja_university/index.php	JROOT/libraries/joomla/document/html.php:580
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:642
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:457
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
    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.]

    ---

30. Query Time: 1.60 ms After last query: 9.57 ms Query memory: 0.045 MB Memory before query: 19.648 MB Rows returned: 0

    SELECT a.id, a.title, a.alias, 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 jos_fields AS a
    
      LEFT JOIN `jos_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jos_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jos_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jos_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jos_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `jos_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_custom.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (79,0)) 
      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)
    
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
    
      ORDER BY a.ordering ASC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:305
    24	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:334
    23	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    22	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:449
    20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
    16	JHtml::call()	JROOT/libraries/cms/html/html.php:140
    15	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    14	require JROOT/modules/mod_custom/mod_custom.php	JROOT/plugins/system/jat3/jat3/core/joomla/modulehelper.php:188
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    11	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:413
    10	JDocumentHtml->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:1676
    9	T3Template->getBuffer()	JROOT/plugins/system/jat3/jat3/core/template.php:795
    8	T3Template->render()	JROOT/templates/ja_university/index.php:19
    7	require JROOT/templates/ja_university/index.php	JROOT/libraries/joomla/document/html.php:580
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:642
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:457
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
    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.]

    ---

31. Query Time: 0.48 ms After last query: 32.31 ms Query memory: 0.025 MB Memory before query: 20.734 MB Rows returned: 1

    SELECT modified, created 
      FROM jos_content 
      WHERE id = 551

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    11	JDatabaseDriver->loadObject()	JROOT/plugins/system/lm_any/plugins/com_content.plugin.php:77
    10	lm_com_content->getContent()	JROOT/plugins/system/lm_any/plugins/com_content.plugin.php:27
    9	lm_com_content->getLM()	JROOT/plugins/system/lm_any/lm_any.php:63
    8	plgSystemLm_any->getUri()	JROOT/plugins/system/lm_any/lm_any.php:34
    7	plgSystemLm_any->onBeforeRender()	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: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.]

    ---