Consola de Joomla! Debug

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1545195699,
                "last": 1545195699,
                "now": 1545195699
            }
        },
        "registry": {
            "published_fv_ses": "0",
            "justmine_fv_ses": "0"
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "4f1dc5c7aa6f349be4782ef410771b28474b7979": {
                    "link": "http:\/\/aytoelherradon-lacanada.es\/index.php\/component\/jevents\/day.listevents\/2018\/10\/18\/-?Itemid=1",
                    "expiry": 1545195699
                }
            }
        }
    }
}

Time

Memory

24 Registro Consultas 35.85 ms

1. Query Time: 0.50 ms Query memory: 0.008 MB Memory before query: 3.033 MB

   DELETE 
   
     FROM `zkb58_session`
   
     WHERE `time` < '1545194799'

   Explain

   EXPLAIN not possible on query: DELETE FROM `zkb58_session` WHERE `time` < '1545194799'

   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.03 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

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

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

   ---

2. Query Time: 0.42 ms After last query: 0.54 ms Query memory: 0.021 MB Memory before query: 3.064 MB Rows returned: 0

   SELECT `data`
   
     FROM `zkb58_session`
   
     WHERE `session_id` = '085c54b8f36c3a0acda52a4620c7f9a6'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	zkb58_session	const	PRIMARY	PRIMARY	575	const	1

   Profile

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 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.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.00 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

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

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

   ---

3. Query Time: 0.48 ms After last query: 1.89 ms Query memory: 0.012 MB Memory before query: 3.207 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `zkb58_session`
   
     WHERE `session_id` = '085c54b8f36c3a0acda52a4620c7f9a6' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   Waiting for query cache lock	0.02 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.00 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 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:831
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 1.44 ms After last query: 0.24 ms Query memory: 0.009 MB Memory before query: 3.223 MB

   INSERT INTO `zkb58_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('085c54b8f36c3a0acda52a4620c7f9a6', 1, '1545195699', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `zkb58_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('085c54b8f36c3a0acda52a4620c7f9a6', 1, '1545195699', 0, '', 0)

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.01 ms
   update	0.04 ms
   Waiting for query cache lock	0.00 ms
   update	0.01 ms
   end	0.00 ms
   query end	1.00 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   logging slow query	0.00 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:831
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

5. Query Time: 0.94 ms After last query: 3.46 ms Query memory: 0.023 MB Memory before query: 3.472 MB Rows returned: 38

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	zkb58_extensions	ref	extension	extension	62	const	38	Using where

   Profile

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   Waiting for query cache lock	0.02 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.16 ms
   end	0.02 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.08 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
   9	JComponentHelper::{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 0.67 ms After last query: 3.71 ms Query memory: 0.015 MB Memory before query: 3.759 MB Rows returned: 4

   SELECT id, rules
   
     FROM `zkb58_viewlevels`

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

7. Query Time: 0.31 ms After last query: 0.23 ms Query memory: 0.016 MB Memory before query: 3.783 MB Rows returned: 2

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

   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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

   Profile

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

   Call Stack

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

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

   ---

8. Query Time: 0.98 ms After last query: 1.13 ms Query memory: 0.017 MB Memory before query: 3.878 MB Rows returned: 57

   SELECT `folder` AS `type`,`element` AS `name`,`params`
   
     FROM zkb58_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	zkb58_extensions	ref	extension	extension	62	const	83	Using where; Using filesort

   Profile

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.01 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.00 ms
   Sorting result	0.18 ms
   Sending data	0.18 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
   9	JPluginHelper::{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 3.84 ms After last query: 9.51 ms Query memory: 0.013 MB Memory before query: 4.494 MB Rows returned: 1

   SELECT `enabled`
   
     FROM `zkb58_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:252
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 1.22 ms After last query: 15.82 ms Query memory: 0.032 MB Memory before query: 5.607 MB Rows returned: 24

    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 zkb58_menu AS m
    
      LEFT JOIN zkb58_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	36	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db548991047.m.component_id	1

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 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.01 ms
    executing	0.00 ms
    Sorting result	0.09 ms
    Sending data	0.17 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.37 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 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/cms/menu/site.php:88
    17	JMenuSite->{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
    15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
    14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
    11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
    10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
    8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
    7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
    6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
    5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 1.73 ms After last query: 17.24 ms Query memory: 0.020 MB Memory before query: 6.699 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    14	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
    13	JLibraryHelper::{closure}()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
    11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
    10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
    9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
    8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 1.48 ms After last query: 0.41 ms Query memory: 0.013 MB Memory before query: 6.702 MB

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

    Explain

    EXPLAIN not possible on query: UPDATE `zkb58_extensions` SET `params` = '{\"mediaversion\":\"9f8db16dc4fc8974cf6d9ca64007fae0\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.43 ms After last query: 3.52 ms Query memory: 0.014 MB Memory before query: 7.023 MB Rows returned: 2

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

    Explain

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

    Profile

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

    ---

14. Query Time: 0.72 ms After last query: 0.50 ms Query memory: 0.010 MB Memory before query: 7.047 MB Rows returned: 4

    SELECT id, home, template, s.params
    
      FROM zkb58_template_styles as s
    
      LEFT JOIN zkb58_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	6	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	db548991047.s.template,const	1	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.00 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.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 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.61 ms After last query: 45.73 ms Query memory: 0.031 MB Memory before query: 9.959 MB Rows returned: 37

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `zkb58_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_easyjoomlabackup','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Explain

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

    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.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
    20	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
    19	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
    18	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    17	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    16	JUser->authorise()	JROOT/components/com_jevents/libraries/helper.php:2265
    15	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:2347
    14	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:40
    13	JEventsDataModel->__construct()	JROOT/components/com_jevents/views/default/abstract/abstract.php:59
    12	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/flat/abstract/abstract.php:30
    11	JEventsFlatView->__construct()	JROOT/libraries/legacy/controller/legacy.php:597
    10	JControllerLegacy->createView()	JROOT/libraries/legacy/controller/legacy.php:843
    9	JControllerLegacy->getView()	JROOT/components/com_jevents/controllers/day.php:64
    8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 1.51 ms After last query: 17.11 ms Query memory: 0.043 MB Memory before query: 11.360 MB Rows returned: 30

    SHOW FULL COLUMNS 
      FROM `zkb58_content`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    31	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    30	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    29	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    28	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
    27	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
    26	JTable::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:11
    25	DefaultLoadModules()	Same as call in the line below.
    24	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    23	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10
    22	flatViewDay->loadModules()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10
    21	FlatViewHelperHeader16()	Same as call in the line below.
    20	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    19	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5
    18	flatViewDay->_header16()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5
    17	FlatViewHelperHeader()	Same as call in the line below.
    16	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4
    14	flatViewDay->_header()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php	JROOT/libraries/legacy/view/legacy.php:694
    11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
    10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:81
    8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 1.74 ms After last query: 10.99 ms Query memory: 0.046 MB Memory before query: 12.276 MB Rows returned: 18

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM zkb58_modules AS m
    
      LEFT JOIN zkb58_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN zkb58_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-12-19 05:01:39') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-12-19 05:01:39') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 1 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.07 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 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.03 ms
    executing	0.00 ms
    Sorting result	0.20 ms
    Sending data	0.62 ms
    end	0.03 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.06 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    36	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    35	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
    34	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
    33	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
    32	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    31	JModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:137
    30	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
    29	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
    28	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    27	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    26	JEventDispatcher->trigger()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:19
    25	DefaultLoadModules()	Same as call in the line below.
    24	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    23	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10
    22	flatViewDay->loadModules()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10
    21	FlatViewHelperHeader16()	Same as call in the line below.
    20	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    19	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5
    18	flatViewDay->_header16()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5
    17	FlatViewHelperHeader()	Same as call in the line below.
    16	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
    15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4
    14	flatViewDay->_header()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:4
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php	JROOT/libraries/legacy/view/legacy.php:694
    11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
    10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:81
    8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 2.41 ms After last query: 22.80 ms Query memory: 0.041 MB Memory before query: 13.263 MB Rows returned: 18

    SHOW FULL COLUMNS 
      FROM `zkb58_jev_users`

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.15 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.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.03 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.06 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    26	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    25	JTable->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:69
    24	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:2205
    23	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1098
    22	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:50
    21	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
    20	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
    19	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
    18	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2679
    17	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:705
    16	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/flat/day/tmpl/listevents_body.php:6
    15	include JROOT/components/com_jevents/views/flat/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php	JROOT/libraries/legacy/view/legacy.php:694
    11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
    10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:81
    8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 4.09 ms After last query: 3.91 ms Query memory: 0.044 MB Memory before query: 13.568 MB Rows returned: 5

    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 zkb58_categories as c
    
      WHERE (c.extension='com_jevents' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1
    
      ORDER BY c.lft

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    26	JCategories->_load()	JROOT/components/com_jevents/helpers/category.php:47
    25	JEventsCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    24	JCategories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:90
    23	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
    22	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
    21	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
    20	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
    19	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
    18	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2679
    17	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:705
    16	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/flat/day/tmpl/listevents_body.php:6
    15	include JROOT/components/com_jevents/views/flat/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php	JROOT/libraries/legacy/view/legacy.php:694
    11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
    10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:81
    8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 3.27 ms After last query: 0.71 ms Query memory: 0.033 MB Memory before query: 13.642 MB Rows returned: 4

    SELECT c.id
    
      FROM zkb58_categories AS c
    
      WHERE c.access   IN (1,1,5)
     
      AND c.published = 1
      
      AND c.language in ('es-ES','*')
     
      AND c.extension = 'com_jevents'
     
    
      ORDER BY c.lft asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	cat_idx,idx_access,idx_language	cat_idx	153	const,const	5	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.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    24	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:172
    23	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
    22	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
    21	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
    20	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
    19	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
    18	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2679
    17	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:705
    16	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/flat/day/tmpl/listevents_body.php:6
    15	include JROOT/components/com_jevents/views/flat/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php	JROOT/libraries/legacy/view/legacy.php:694
    11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
    10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:81
    8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 2.00 ms After last query: 1.24 ms Query memory: 0.048 MB Memory before query: 13.710 MB Rows returned: 0

    SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created 
     , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
     , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
     , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
     , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
     
      FROM zkb58_jevents_repetition as rpt
     
      INNER JOIN zkb58_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN zkb58_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      INNER JOIN zkb58_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN zkb58_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,8,16,17,18)
     
      AND rpt.endrepeat >= '2018-10-18 00:00:00' 
      AND rpt.startrepeat <= '2018-10-18 23:59:59'
     
      AND NOT (rpt.startrepeat < '2018-10-18 00:00:00' 
      AND det.multiday=0)  
      AND ev.state=1
     
      AND ev.access IN (1,1,5)  
      AND icsf.state=1 
      AND icsf.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	Using where
    1	SIMPLE	ev	ALL	PRIMARY,icsid,stateidx,evaccess	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where; Using join buffer
    1	SIMPLE	rpt	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	db548991047.ev.ev_id	1	Using where
    1	SIMPLE	rr	ref	eventid	eventid	4	db548991047.rpt.eventid	1
    1	SIMPLE	det	ALL	PRIMARY,multiday	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where; Using join buffer

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2569
    19	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2518
    18	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2679
    17	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:705
    16	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/flat/day/tmpl/listevents_body.php:6
    15	include JROOT/components/com_jevents/views/flat/day/tmpl/listevents_body.php	JROOT/libraries/legacy/view/legacy.php:694
    14	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/day/tmpl/listevents.php:7
    13	include JROOT/components/com_jevents/views/default/day/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php:4
    12	include JROOT/components/com_jevents/views/flat/day/tmpl/listevents.php	JROOT/libraries/legacy/view/legacy.php:694
    11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
    10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:81
    8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:299
    6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.65 ms After last query: 20.20 ms Query memory: 0.043 MB Memory before query: 14.278 MB Rows returned: 0

    SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created 
     , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
     , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
     , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
     , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
     
      FROM zkb58_jevents_repetition as rpt
     
      INNER JOIN zkb58_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN zkb58_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      INNER JOIN zkb58_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN zkb58_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,8,16,17,18)
     
      AND rpt.endrepeat >= '2018-12-01 00:00:00' 
      AND rpt.startrepeat <= '2018-12-31 23:59:59'
     
      AND NOT (rpt.startrepeat < '2018-12-01 00:00:00' 
      AND det.multiday=0)  
      AND ev.state=1
     
      AND ev.access IN (1,1,5)  
      AND icsf.state=1 
      AND icsf.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	Using where
    1	SIMPLE	ev	ALL	PRIMARY,icsid,stateidx,evaccess	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where; Using join buffer
    1	SIMPLE	rpt	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	db548991047.ev.ev_id	1	Using where
    1	SIMPLE	rr	ref	eventid	eventid	4	db548991047.rpt.eventid	1
    1	SIMPLE	det	ALL	PRIMARY,multiday	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where; Using join buffer

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2569
    16	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2518
    15	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2693
    14	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:243
    13	JEventsDataModel->getCalendarData()	JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:78
    12	FlatModCalView->_displayCalendarMod()	JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:491
    11	DefaultModCalView->getCal()	JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46
    10	include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 1.97 ms After last query: 19.47 ms Query memory: 0.032 MB Memory before query: 14.678 MB Rows returned: 5

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM zkb58_content AS a
    
      LEFT JOIN zkb58_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN zkb58_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN zkb58_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN zkb58_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN zkb58_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-19 05:01:39') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-19 05:01:39')
    
      ORDER BY a.created DESC 
      LIMIT 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	55	Using where; Using filesort
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	db548991047.a.catid	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db548991047.a.created_by	1
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	db548991047.a.modified_by	1
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	db548991047.c.parent_id	1
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	db548991047.a.id	1

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.23 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.06 ms
    init	0.12 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sorting result	0.32 ms
    Sending data	0.28 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.12 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.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 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_content/models/articles.php:536
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:116
    11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.41 ms After last query: 2.53 ms Query memory: 0.037 MB Memory before query: 14.988 MB Rows returned: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM zkb58_categories as c
    
      LEFT JOIN zkb58_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,5) 
      AND c.published = 1 
      AND s.id=2
    
      ORDER BY c.lft

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    21	JCategories->get()	JROOT/components/com_content/router.php:72
    20	ContentRouter->getCategorySegment()	Same as call in the line below.
    19	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
    18	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    17	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    16	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    15	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    12	JRoute::_()	JROOT/modules/mod_articles_latest/helper.php:128
    11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `zkb58_extensions`

2. 2 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
     FROM zkb58_jevents_repetition as rpt  
     INNER JOIN zkb58_jevents_vevent as ev 
     ON rpt.eventid = ev.ev_id  
     INNER JOIN zkb58_jevents_icsfile as icsf 
     ON icsf.ics_id=ev.icsid   
     INNER JOIN zkb58_jevents_vevdetail as det 
     ON det.evdet_id = rpt.eventdetail_id  
     LEFT JOIN zkb58_jevents_rrule as rr 
     ON rr.eventid = rpt.eventid

3. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM zkb58_modules AS m 
     LEFT JOIN zkb58_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN zkb58_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

4. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `zkb58_assets`

5. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
     FROM zkb58_categories as c

6. 1 × SELECT c.id 
     FROM zkb58_categories AS c

7. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN c.published = 2 
     AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
     CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,         COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
     FROM zkb58_content AS a 
     LEFT JOIN zkb58_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN zkb58_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN zkb58_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN zkb58_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN zkb58_content_rating AS v 
     ON a.id = v.content_id

8. 1 × SELECT id, home, template, s.params 
     FROM zkb58_template_styles as s 
     LEFT JOIN zkb58_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id

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

10. 1 × SELECT * 
      FROM zkb58_languages

11. 1 × SELECT id, rules 
      FROM `zkb58_viewlevels

12. 1 × SELECT `session_id` 
      FROM `zkb58_session`

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

14. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
      FROM zkb58_extensions

15. 1 × 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 zkb58_menu AS m 
      LEFT JOIN zkb58_extensions AS e 
      ON m.component_id = e.extension_id

16. 1 × SELECT `enabled` 
      FROM `zkb58_extensions`

17. 1 × SELECT `data` 
      FROM `zkb58_session`

OTRAS Tablas:

1. 1 × SHOW FULL COLUMNS 
     FROM `zkb58_jev_users

2. 1 × SHOW FULL COLUMNS 
     FROM `zkb58_content

3. 1 × UPDATE `zkb58_extensions` 
     SET `params` = '{\"mediaversion\":\"9f8db16dc4fc8974cf6d9ca64007fae0\"}'

4. 1 × INSERT INTO `zkb58_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('085c54b8f36c3a0acda52a4620c7f9a6', 1, '1545195699', 0, '', 0

5. 1 × DELETE  
     FROM `zkb58_session`