Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1524406231,
                "last": 1524406231,
                "now": 1524406231
            },
            "token": "WiSgTyy6ildIjUyiOzVSR3tRAgt43uNN"
        },
        "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
        }
    }
}

Time

Memory

36 Queries Logged 956.68 ms

1. Query Time: 184.60 ms Query memory: 0.004 MB Memory before query: 2.766 MB

   DELETE 
   
     FROM `promad_session`
   
     WHERE `time` < '1524405331'

   Explain

   EXPLAIN not possible on query: DELETE FROM `promad_session` WHERE `time` < '1524405331'

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   System lock	0.01 ms
   init	0.06 ms
   updating	0.24 ms
   end	0.01 ms
   Waiting for query cache lock	0.01 ms
   end	0.01 ms
   query end	183.81 ms
   closing tables	0.03 ms
   freeing items	0.08 ms
   logging slow query	0.01 ms
   cleaning up	0.01 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.68 ms After last query: 0.49 ms Query memory: 0.027 MB Memory before query: 2.784 MB Rows returned: 0

   SELECT `data`
   
     FROM `promad_session`
   
     WHERE `session_id` = 'fnje73e9ab4ltj57nb1eoj7ib3'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	promad_session	const	PRIMARY	PRIMARY	766	const	1

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.04 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.08 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.06 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
   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:825
   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.54 ms After last query: 1.14 ms Query memory: 0.023 MB Memory before query: 2.887 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `promad_session`
   
     WHERE `session_id` = 'fnje73e9ab4ltj57nb1eoj7ib3' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.01 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.01 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.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
   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.]

   ---

4. Query Time: 136.31 ms After last query: 0.16 ms Query memory: 0.005 MB Memory before query: 2.893 MB

   INSERT INTO `promad_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('fnje73e9ab4ltj57nb1eoj7ib3', 1, '1524406231', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `promad_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('fnje73e9ab4ltj57nb1eoj7ib3', 1, '1524406231', 0, '', 0)

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.01 ms
   update	0.13 ms
   Waiting for query cache lock	0.01 ms
   update	0.01 ms
   end	0.01 ms
   query end	135.67 ms
   closing tables	0.03 ms
   freeing items	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/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.]

   ---

5. Query Time: 1.06 ms After last query: 2.70 ms Query memory: 0.037 MB Memory before query: 3.085 MB Rows returned: 40

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

   Explain

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

   Profile

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.05 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.06 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.18 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.27 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
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
   8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
   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.]

   ---

6. Query Time: 0.27 ms After last query: 2.62 ms Query memory: 0.024 MB Memory before query: 3.311 MB Rows returned: 1

   SELECT b.id
   
     FROM promad_usergroups AS a
   
     LEFT JOIN promad_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	9	Using index

   Profile

   Status	Duration
   starting	0.02 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.06 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: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.]

   ---

7. Query Time: 0.25 ms After last query: 0.58 ms Query memory: 0.024 MB Memory before query: 3.366 MB Rows returned: 4

   SELECT id, rules
   
     FROM `promad_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.01 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.06 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: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.]

   ---

8. Query Time: 1.08 ms After last query: 0.14 ms Query memory: 0.032 MB Memory before query: 3.395 MB Rows returned: 75

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

   Explain

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

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sorting result	0.31 ms
   Sending data	0.20 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.12 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
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
   8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
   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.]

   ---

9. Query Time: 0.70 ms After last query: 11.51 ms Query memory: 0.028 MB Memory before query: 4.303 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   starting	0.04 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.02 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/joomla/language/helper.php:148
   8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:98
   7	PlgSystemLanguageFilter->__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.]

   ---

10. Query Time: 0.88 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 4.313 MB Rows returned: 4

    SELECT `element`,`name`,`client_id`,`extension_id`
    
      FROM `promad_extensions`
    
      WHERE `type` = 'language' 
      AND `state` = 0 
      AND `enabled` = 1

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.06 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.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.08 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
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
    8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:109
    7	PlgSystemLanguageFilter->__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.]

    ---

11. Query Time: 5.43 ms After last query: 8.79 ms Query memory: 0.091 MB Memory before query: 5.180 MB Rows returned: 65

    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 promad_menu AS m
    
      LEFT JOIN promad_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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	143	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	proydemadrid.m.component_id	1

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.05 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.02 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sorting result	0.28 ms
    Sending data	0.16 ms
    Waiting for query cache lock	0.01 ms
    Sending data	3.18 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.66 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.59 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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
    20	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
    19	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
    18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
    15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
    14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
    12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
    11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:548
    10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
    9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
    8	PlgSystemLanguageFilter->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.]

    ---

12. Query Time: 0.78 ms After last query: 13.12 ms Query memory: 0.030 MB Memory before query: 6.204 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.04 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.07 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    17	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
    16	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
    15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
    14	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
    13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
    12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
    11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:460
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php: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.]

    ---

13. Query Time: 422.93 ms After last query: 0.19 ms Query memory: 0.009 MB Memory before query: 6.199 MB

    UPDATE `promad_extensions`
    
      SET `params` = '{\"mediaversion\":\"3fe6dd6759f9aada496508bdb94b2072\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `promad_extensions` SET `params` = '{\"mediaversion\":\"3fe6dd6759f9aada496508bdb94b2072\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.05 ms
    Updating	0.07 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.09 ms
    query end	422.05 ms
    closing tables	0.04 ms
    freeing items	0.12 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
    13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
    12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
    11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:460
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php: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.]

    ---

14. Query Time: 1.36 ms After last query: 4.69 ms Query memory: 0.023 MB Memory before query: 6.656 MB Rows returned: 5

    SELECT id, home, template, s.params
    
      FROM promad_template_styles as s
    
      LEFT JOIN promad_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	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	proydemadrid.s.template,const	1	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.04 ms
    init	0.05 ms
    optimizing	0.03 ms
    statistics	0.09 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.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.31 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.03 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.]

    ---

15. Query Time: 2.14 ms After last query: 8.19 ms Query memory: 0.036 MB Memory before query: 7.497 MB Rows returned: 38

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `promad_assets`
    
      WHERE `name` IN ('com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventgallery','com_extplorer','com_fields','com_finder','com_installer','com_jce','com_joomgallery','com_joomlaupdate','com_jphotostack','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_offlajn_installer','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

    Explain

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

    Profile

    Status	Duration
    starting	0.02 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.16 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    14	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
    13	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:434
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:65
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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: 3.77 ms After last query: 0.87 ms Query memory: 0.041 MB Memory before query: 7.580 MB Rows returned: 1

    SELECT a.*, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      FROM promad_contact_details AS a
    
      LEFT JOIN promad_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN promad_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.id = 3 
      AND (a.published = 1 OR a.published =2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 14:10:32') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 14:10:32')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.04 ms
    init	0.09 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.22 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 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:1642
    13	JDatabaseDriver->loadObject()	JROOT/components/com_contact/models/contact.php:194
    12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:66
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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.38 ms After last query: 6.33 ms Query memory: 0.038 MB Memory before query: 7.761 MB Rows returned: 0
    Duplicate queries: #25  #26

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `promad_contentitem_tag_map` AS m 
    
      INNER JOIN `promad_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_contact.contact' 
      AND `m`.`content_item_id` = 3 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

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

    Profile

    Status	Duration
    starting	0.02 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.15 ms
    logging slow query	0.01 ms
    cleaning up	0.06 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
    13	JHelperTags->getItemTags()	JROOT/components/com_contact/models/contact.php:218
    12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:66
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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: 1.23 ms After last query: 0.16 ms Query memory: 0.041 MB Memory before query: 7.773 MB Rows returned: 1

    SELECT a.*, cc.access as category_access, cc.title as category_name,  
      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 promad_contact_details AS a
    
      INNER JOIN promad_categories AS cc 
      on cc.id = a.catid
    
      WHERE a.id = 3 
      AND a.published IN (1,2) 
      AND cc.published IN (1,2) 
      AND a.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	const	1
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.55 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.06 ms
    storing result in query cache	0.04 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_contact/models/contact.php:326
    13	ContactModelContact->getContactQuery()	JROOT/components/com_contact/models/contact.php:254
    12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:66
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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.39 ms After last query: 3.49 ms Query memory: 0.037 MB Memory before query: 8.186 MB Rows returned: 16

    SHOW FULL COLUMNS 
      FROM `promad_users`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    19	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
    18	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:311
    17	JTable::getInstance()	JROOT/administrator/components/com_users/models/user.php:64
    16	UsersModelUser->getTable()	JROOT/libraries/legacy/model/admin.php:899
    15	JModelAdmin->getItem()	JROOT/administrator/components/com_users/models/user.php:89
    14	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:431
    13	ContactModelContact->getContactQuery()	JROOT/components/com_contact/models/contact.php:254
    12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:66
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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.37 ms After last query: 0.76 ms Query memory: 0.034 MB Memory before query: 8.245 MB Rows returned: 1

    SELECT *
    
      FROM `promad_users`
    
      WHERE `id` = 945

    Explain

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

    Profile

    Status	Duration
    starting	0.01 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.14 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:1445
    17	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
    16	JTableUser->load()	JROOT/libraries/legacy/model/admin.php:904
    15	JModelAdmin->getItem()	JROOT/administrator/components/com_users/models/user.php:89
    14	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:431
    13	ContactModelContact->getContactQuery()	JROOT/components/com_contact/models/contact.php:254
    12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:66
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.33 ms After last query: 4.53 ms Query memory: 0.030 MB Memory before query: 9.077 MB Rows returned: 2

    SELECT `g`.`id`,`g`.`title`
    
      FROM `promad_usergroups` AS g
    
      INNER JOIN `promad_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 945

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.02 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    17	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:110
    16	JTableUser->load()	JROOT/libraries/legacy/model/admin.php:904
    15	JModelAdmin->getItem()	JROOT/administrator/components/com_users/models/user.php:89
    14	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:431
    13	ContactModelContact->getContactQuery()	JROOT/components/com_contact/models/contact.php:254
    12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:66
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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: 0.40 ms After last query: 0.18 ms Query memory: 0.029 MB Memory before query: 9.087 MB Rows returned: 0

    SELECT `t`.`id`
    
      FROM `promad_tags` AS t 
    
      INNER JOIN `promad_contentitem_tag_map` AS m 
      ON `m`.`tag_id` = `t`.`id` 
      AND `m`.`type_alias` = 'com_users.user' 
      AND `m`.`content_item_id` IN ( 945)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	index	PRIMARY	idx_access	4	NULL	15	Using index
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	proydemadrid.t.id	1	Using where

    Profile

    Status	Duration
    starting	0.01 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.09 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:1530
    16	JDatabaseDriver->loadColumn()	JROOT/libraries/cms/helper/tags.php:502
    15	JHelperTags->getTagIds()	JROOT/administrator/components/com_users/models/user.php:94
    14	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:431
    13	ContactModelContact->getContactQuery()	JROOT/components/com_contact/models/contact.php:254
    12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:66
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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.54 ms After last query: 11.60 ms Query memory: 0.031 MB Memory before query: 9.740 MB Rows returned: 12

    SELECT profile_key, profile_value 
      FROM promad_user_profiles 
      WHERE user_id = 945 
      AND profile_key LIKE 'profile.%' 
      ORDER BY ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	promad_user_profiles	range	idx_user_id_profile_key	idx_user_id_profile_key	406	NULL	12	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.02 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.10 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:1791
    17	JDatabaseDriver->loadRowList()	JROOT/plugins/user/profile/profile.php:85
    16	PlgUserProfile->onContentPrepareData()	JROOT/libraries/joomla/event/event.php:70
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT/components/com_contact/models/contact.php:443
    13	ContactModelContact->getContactQuery()	JROOT/components/com_contact/models/contact.php:254
    12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:66
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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.22 ms After last query: 9.98 ms Query memory: 0.041 MB Memory before query: 10.231 MB Rows returned: 1

    SELECT a.*, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
    
      FROM `promad_contact_details` AS a
    
      LEFT JOIN promad_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN promad_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN promad_users AS uam 
      ON uam.id = a.modified_by
    
      WHERE a.access IN (1,1,5) 
      AND a.catid = 4 
      AND c.access IN (1,1,5) 
      AND a.published = 1
    
      ORDER BY a.name asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using filesort
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	proydemadrid.a.created_by	1
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	proydemadrid.a.modified_by	1	Using index

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.04 ms
    init	0.08 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.07 ms
    Sending data	0.29 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	1.07 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.18 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:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    12	JModelList->getItems()	JROOT/components/com_contact/models/category.php:91
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:84
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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.48 ms After last query: 0.19 ms Query memory: 0.037 MB Memory before query: 10.262 MB Rows returned: 0
    Duplicate queries: #17  #26

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `promad_contentitem_tag_map` AS m 
    
      INNER JOIN `promad_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_contact.contact' 
      AND `m`.`content_item_id` = 3 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

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

    Profile

    Status	Duration
    starting	0.01 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.35 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/libraries/cms/helper/tags.php:450
    12	JHelperTags->getItemTags()	JROOT/components/com_contact/models/category.php:104
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:84
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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: 5.78 ms After last query: 1.20 ms Query memory: 0.037 MB Memory before query: 10.309 MB Rows returned: 0
    Duplicate queries: #17  #25

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `promad_contentitem_tag_map` AS m 
    
      INNER JOIN `promad_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_contact.contact' 
      AND `m`.`content_item_id` = 3 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

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

    Profile

    Status	Duration
    starting	0.01 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.04 ms
    logging slow query	0.01 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_contact/views/contact/view.html.php:244
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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: 1.99 ms After last query: 0.54 ms Query memory: 0.041 MB Memory before query: 10.342 MB Rows returned: 43

    SHOW FULL COLUMNS 
      FROM `promad_contact_details`

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.33 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.09 ms
    closing tables	0.01 ms
    freeing items	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/database/driver/mysqli.php:440
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    14	JTable->__construct()	JROOT/administrator/components/com_contact/tables/contact.php:39
    13	ContactTableContact->__construct()	JROOT/libraries/joomla/table/table.php:311
    12	JTable::getInstance()	JROOT/components/com_contact/models/contact.php:475
    11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:264
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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.89 ms After last query: 1.51 ms Query memory: 0.041 MB Memory before query: 10.492 MB Rows returned: 1

    SELECT *
    
      FROM promad_contact_details
    
      WHERE `id` = '3'

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.03 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.17 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 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:1445
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    12	JTable->load()	JROOT/components/com_contact/models/contact.php:476
    11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:264
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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: 172.56 ms After last query: 0.20 ms Query memory: 0.009 MB Memory before query: 10.501 MB

    UPDATE promad_contact_details
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '3'

    Explain

    EXPLAIN not possible on query: UPDATE promad_contact_details SET `hits` = (`hits` + 1) WHERE `id` = '3'

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    init	0.05 ms
    Updating	0.08 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.06 ms
    query end	171.85 ms
    closing tables	0.04 ms
    freeing items	0.09 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
    12	JTable->hit()	JROOT/components/com_contact/models/contact.php:477
    11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:264
    10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
    8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
    6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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.41 ms After last query: 16.32 ms Query memory: 0.024 MB Memory before query: 11.028 MB Rows returned: 1

    SELECT language,id
    
      FROM `promad_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	promad_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	144	Using where

    Profile

    Status	Duration
    starting	0.02 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.04 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/language/multilang.php:106
    8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:709
    7	PlgSystemLanguageFilter->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.]

    ---

31. Query Time: 0.71 ms After last query: 0.87 ms Query memory: 0.025 MB Memory before query: 11.089 MB Rows returned: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `promad_menu` AS `c`
    
      INNER JOIN `promad_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `promad_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `promad_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 125

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.07 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.01 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.06 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
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    9	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:314
    8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:726
    7	PlgSystemLanguageFilter->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.]

    ---

32. Query Time: 0.69 ms After last query: 0.65 ms Query memory: 0.025 MB Memory before query: 11.110 MB Rows returned: 0

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
    
      FROM `promad_contact_details` AS `c`
    
      INNER JOIN `promad_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_contact.item'
    
      INNER JOIN `promad_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `promad_contact_details` AS `c2` 
      ON a2.id = c2.`id`
    
      INNER JOIN `promad_categories` AS `ca` 
      ON `c2`.`catid` = ca.id 
      AND ca.extension = 'com_contact'
    
      WHERE c.id = 3

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.04 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.09 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.01 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.00 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
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    9	JLanguageAssociations::getAssociations()	JROOT/components/com_contact/helpers/association.php:46
    8	ContactHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:741
    7	PlgSystemLanguageFilter->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.]

    ---

33. Query Time: 1.45 ms After last query: 13.52 ms Query memory: 0.035 MB Memory before query: 11.728 MB Rows returned: 12

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM promad_modules AS m
    
      LEFT JOIN promad_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN promad_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 <= '2018-04-22 14:10:32') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-04-22 14:10:32') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 125 OR mm.menuid <= 0) 
      AND m.language IN ('en-GB','*')
    
      ORDER BY m.position, m.ordering

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.13 ms
    Sending data	0.24 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.23 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.00 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    17	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
    16	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
    15	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
    13	JDocumentHtml->countModules()	JROOT/templates/gk_publisher/lib/framework/helper.api.php:36
    12	GKTemplateAPI->modules()	JROOT/templates/gk_publisher/lib/framework/helper.layout.php:48
    11	GKTemplateLayout->generateLayoutWidths()	JROOT/templates/gk_publisher/layouts/default.php:44
    10	include JROOT/templates/gk_publisher/layouts/default.php	JROOT/templates/gk_publisher/lib/gk.framework.php:145
    9	GKTemplate->getLayout()	JROOT/templates/gk_publisher/lib/gk.framework.php:91
    8	GKTemplate->__construct()	JROOT/templates/gk_publisher/index.php:27
    7	require JROOT/templates/gk_publisher/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: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.]

    ---

34. Query Time: 1.36 ms After last query: 21.76 ms Query memory: 0.040 MB Memory before query: 12.496 MB Rows returned: 2

    SELECT a.*, c.published AS c_published, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.created, "%Y-%m-%d") AS created,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
    
      FROM `promad_weblinks` AS a
    
      LEFT JOIN promad_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN promad_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN promad_users AS uam 
      ON uam.id = a.modified_by
    
      WHERE a.access IN (1,1,5) 
      AND a.catid = 21 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.state != -2 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 14:10:32') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 14:10:32') 
      AND a.language in ('en-GB','*')
    
      ORDER BY title asc 
      LIMIT 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using filesort
    1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid,idx_language	idx_state,idx_catid	1,4	NULL	1	Using intersect(idx_state,idx_catid); Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	proydemadrid.a.created_by	1
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	proydemadrid.a.modified_by	1	Using index

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.04 ms
    init	0.07 ms
    optimizing	0.03 ms
    statistics	0.12 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.14 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.12 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    13	JModelList->getItems()	JROOT/components/com_weblinks/models/category.php:81
    12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
    11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
    10	include JROOT/modules/mod_weblinks/mod_weblinks.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:1112
    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.]

    ---

35. Query Time: 0.39 ms After last query: 0.18 ms Query memory: 0.038 MB Memory before query: 12.531 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `promad_contentitem_tag_map` AS m 
    
      INNER JOIN `promad_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
      AND `m`.`content_item_id` = 7 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

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

    Profile

    Status	Duration
    starting	0.01 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.05 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:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
    13	JHelperTags->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
    12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
    11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
    10	include JROOT/modules/mod_weblinks/mod_weblinks.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:1112
    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.]

    ---

36. Query Time: 0.34 ms After last query: 0.12 ms Query memory: 0.038 MB Memory before query: 12.542 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `promad_contentitem_tag_map` AS m 
    
      INNER JOIN `promad_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
      AND `m`.`content_item_id` = 6 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

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

    Profile

    Status	Duration
    starting	0.01 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.05 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:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
    13	JHelperTags->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
    12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
    11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
    10	include JROOT/modules/mod_weblinks/mod_weblinks.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:1112
    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.]

    ---