{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1790753871,
                "last": 1790753871,
                "now": 1790753871
            }
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "es-ES"
        }
    }
}

Fecha y hora

Memoria

52 consultas registradas 29.75 ms

1. Tiempo de la consulta: 0.26 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.017 MB Filas devueltas: 0

   SELECT `data`
   
     FROM `z2msh_session`
   
     WHERE `session_id` = X'396a6f6238696f756a6367677161337534733876637666676e62'

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	z2msh_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Perfil

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Lo mismo que llamada de la línea de abajo.
   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:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

2. Tiempo de la consulta: 0.13 ms Después de la última consulta: 0.84 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 4.125 MB Filas devueltas: 0

   SELECT `session_id`
   
     FROM `z2msh_session`
   
     WHERE `session_id` = X'396a6f6238696f756a6367677161337534733876637666676e62' 
     LIMIT 1

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	z2msh_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   Perfil

   Status	Duration
   starting	0.02 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

3. Tiempo de la consulta: 5.39 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 4.131 MB

   INSERT INTO `z2msh_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'396a6f6238696f756a6367677161337534733876637666676e62', 1, 1790753871, 0, '', 0)

   Explicar

   'Explicar' no es posible en la consulta: INSERT INTO `z2msh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'396a6f6238696f756a6367677161337534733876637666676e62', 1, 1790753871, 0, '', 0)

   Perfil

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.01 ms
   update	0.12 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	5.15 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

4. Tiempo de la consulta: 0.40 ms Después de la última consulta: 1.59 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 4.339 MB Filas devueltas: 42

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `z2msh_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	z2msh_extensions	NULL	ref	extension	extension	82	const	43	1.00	Using where

   Perfil

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.16 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Lo mismo que llamada de la línea de abajo.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

5. Tiempo de la consulta: 0.15 ms Después de la última consulta: 1.42 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.614 MB Filas devueltas: 5

   SELECT id, rules
   
     FROM `z2msh_viewlevels`

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	z2msh_viewlevels	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	5	100.00	NULL

   Perfil

   Status	Duration
   starting	0.02 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

6. Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.626 MB Filas devueltas: 2

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

   Explicar

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

   Perfil

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.02 ms
   executing	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

7. Tiempo de la consulta: 0.78 ms Después de la última consulta: 0.46 ms Consulta a la memoria: 0.046 MB memoria antes de la consulta: 4.696 MB Filas devueltas: 107

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

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	z2msh_extensions	NULL	ref	extension	extension	82	const	130	0.60	Using where; Usando 'filesort'

   Perfil

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.02 ms
   executing	0.57 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Lo mismo que llamada de la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

8. Tiempo de la consulta: 0.32 ms Después de la última consulta: 9.23 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 6.076 MB Filas devueltas: 2

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

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	z2msh_languages	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	2	50.00	Using where; Usando 'filesort'

   Perfil

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.05 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

9. Tiempo de la consulta: 0.22 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 6.085 MB Filas devueltas: 4

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

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	z2msh_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using where

   Perfil

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.04 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
   8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

10. Tiempo de la consulta: 0.93 ms Después de la última consulta: 9.43 ms Consulta a la memoria: 0.097 MB memoria antes de la consulta: 6.827 MB Filas devueltas: 73

    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 z2msh_menu AS m
    
      LEFT JOIN z2msh_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

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	No pudo usarse una clave de índice	NULL	NULL	144	7.50	Using where; Usando 'filesort'
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	doazafrandelamancha.m.component_id	1	100.00	Using where

    Perfil

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.66 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Lo mismo que llamada de la línea de abajo.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
    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/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

11. Tiempo de la consulta: 0.26 ms Después de la última consulta: 13.67 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 8.658 MB Filas devueltas: 18

    SELECT * 
      FROM z2msh_rokcandy 
      WHERE published=1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_rokcandy	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	18	10.00	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
    13	RokCandyHelper::getUserMacros()	Lo mismo que llamada de la línea de abajo.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    10	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
    9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
    8	plgSystemRokCandy->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

12. Tiempo de la consulta: 0.32 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 8.672 MB Filas devueltas: 3

    SELECT id, home, template, s.params
    
      FROM z2msh_template_styles as s
    
      LEFT JOIN z2msh_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

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	doazafrandelamancha.e.element	1	60.00	Using index condition; Using where

    Perfil

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:53
    14	RokCandyHelper::readIniFile()	Lo mismo que llamada de la línea de abajo.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:44
    10	RokCandyHelper::getTemplateOverrides()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:18
    9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
    8	plgSystemRokCandy->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

13. Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 8.701 MB Filas devueltas: 1

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

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    Perfil

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Lo mismo que llamada de la línea de abajo.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

14. Tiempo de la consulta: 3.09 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 8.691 MB

    UPDATE `z2msh_extensions`
    
      SET `params` = '{\"mediaversion\":\"dd65f5b61868be01b17927d46fa4d2a9\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explicar

    'Explicar' no es posible en la consulta: UPDATE `z2msh_extensions` SET `params` = '{\"mediaversion\":\"dd65f5b61868be01b17927d46fa4d2a9\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Perfil

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.05 ms
    updating	0.11 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	2.82 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

15. Tiempo de la consulta: 1.48 ms Después de la última consulta: 5.60 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 9.425 MB Filas devueltas: 1

    SELECT * 
      FROM z2msh_zoo_application 
      WHERE id = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_application	NULL	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	1	100.00	NULL

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	1.22 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.06 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    13	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    12	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:397
    11	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    10	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:141
    9	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:83
    7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

16. Tiempo de la consulta: 0.65 ms Después de la última consulta: 4.48 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 9.938 MB Filas devueltas: 42

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `z2msh_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_allvideoshare','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contenttemplater','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nonumbermanager','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_weblinks','com_wrapper','com_zoo')

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_assets	NULL	ALL	idx_asset_name	No pudo usarse una clave de índice	NULL	NULL	221	19.46	Using where

    Perfil

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.29 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    13	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
    12	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
    11	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:214
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

17. Tiempo de la consulta: 0.07 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 10.091 MB

    
      SET SESSION group_concat_max_len = 1048576

    Explicar

    'Explicar' no es posible en la consulta: SET SESSION group_concat_max_len = 1048576

    Perfil

    Status	Duration
    starting	0.02 ms
    Opening tables	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    14	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/category.php:193
    13	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:432
    12	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:456
    11	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

18. Tiempo de la consulta: 2.16 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 10.184 MB Filas devueltas: 3

    SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
      FROM z2msh_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
      LEFT JOIN z2msh_zoo_category_item as ci 
      ON ci.category_id = c.id 
      LEFT JOIN z2msh_zoo_item AS i USE INDEX (MULTI_INDEX2) 
      ON ci.item_id = i.id 
      AND i.access IN (1,5) 
      AND i.state = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-09-30 07:37:51') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-09-30 07:37:51') 
      WHERE c.application_id = 1 
      AND c.published = 1 
      GROUP BY c.id

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ref	APPLICATIONID_ID_INDEX	APPLICATIONID_ID_INDEX	5	const,const	3	100.00	NULL
    1	SIMPLE	ci	NULL	ref	PRIMARY,CATEGORYID_INDEX	PRIMARY	4	doazafrandelamancha.c.id	1	100.00	Using index
    1	SIMPLE	i	NULL	ref	MULTI_INDEX2	MULTI_INDEX2	4	doazafrandelamancha.ci.item_id	1	100.00	Using where; Using index

    Perfil

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	1.62 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.05 ms
    executing	0.15 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.10 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    18	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    17	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
    16	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
    15	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
    14	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:219
    13	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:432
    12	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:456
    11	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

19. Tiempo de la consulta: 0.94 ms Después de la última consulta: 1.50 ms Consulta a la memoria: 0.171 MB memoria antes de la consulta: 10.391 MB Filas devueltas: 15

    SELECT a.* 
      FROM z2msh_zoo_item AS a 
      LEFT JOIN z2msh_zoo_category_item AS b 
      ON a.id = b.item_id 
      WHERE a.application_id = 1 
      AND a.access IN (1,5) 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-30 07:37:51') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-30 07:37:51') 
      AND b.category_id  = 1 
      GROUP BY a.id 
      ORDER BY a.priority DESC, a.publish_up DESC 
      LIMIT 15,15

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	STATE_INDEX	1	const	40	39.04	Using where; Using temporary; Usando 'filesort'
    1	SIMPLE	b	NULL	eq_ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,doazafrandelamancha.a.id	1	100.00	Using index

    Perfil

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    executing	0.57 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    13	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
    12	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:484
    11	ItemTable->getByCategory()	JROOT/components/com_zoo/controllers/default.php:234
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

20. Tiempo de la consulta: 0.49 ms Después de la última consulta: 6.17 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 11.373 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=71 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=71 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.17 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

21. Tiempo de la consulta: 0.69 ms Después de la última consulta: 14.72 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 12.662 MB Filas devueltas: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM z2msh_fields AS a
    
      LEFT JOIN `z2msh_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN z2msh_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN z2msh_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN z2msh_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN z2msh_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_zoo.element.textarea' 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explicar

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

    Perfil

    Status	Duration
    starting	0.13 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    executing	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.04 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    32	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    31	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    30	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    29	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    28	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    27	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    26	JEventDispatcher->trigger()	JROOT/administrator/components/com_zoo/helpers/zoo.php:197
    25	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
    24	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
    23	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:57
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

22. Tiempo de la consulta: 1.19 ms Después de la última consulta: 12.15 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 13.907 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 71 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.80 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.07 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

23. Tiempo de la consulta: 0.32 ms Después de la última consulta: 0.40 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 13.922 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=70 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=70 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    optimizing	0.00 ms
    statistics	0.00 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
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

24. Tiempo de la consulta: 0.26 ms Después de la última consulta: 9.51 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 13.945 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 70 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

25. Tiempo de la consulta: 0.31 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 13.961 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=69 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=69 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

26. Tiempo de la consulta: 0.33 ms Después de la última consulta: 5.93 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.047 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 69 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

27. Tiempo de la consulta: 0.30 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.063 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=68 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=68 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

28. Tiempo de la consulta: 0.30 ms Después de la última consulta: 7.83 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.155 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 68 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

29. Tiempo de la consulta: 0.37 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.167 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=67 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=67 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

30. Tiempo de la consulta: 0.25 ms Después de la última consulta: 8.91 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.190 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 67 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

31. Tiempo de la consulta: 0.48 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.206 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=66 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=66 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

32. Tiempo de la consulta: 0.30 ms Después de la última consulta: 7.66 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.229 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 66 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	15.38	Using where

    Perfil

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

33. Tiempo de la consulta: 0.30 ms Después de la última consulta: 0.38 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 14.251 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=65 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=65 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

34. Tiempo de la consulta: 0.21 ms Después de la última consulta: 4.62 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.276 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 65 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

35. Tiempo de la consulta: 0.23 ms Después de la última consulta: 7.94 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.300 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 62 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

36. Tiempo de la consulta: 0.28 ms Después de la última consulta: 0.38 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.312 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=61 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=61 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

37. Tiempo de la consulta: 0.22 ms Después de la última consulta: 5.21 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.335 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 61 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

38. Tiempo de la consulta: 0.35 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.350 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=60 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=60 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

39. Tiempo de la consulta: 0.24 ms Después de la última consulta: 6.26 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.374 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 60 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

40. Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.389 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=59 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=59 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

41. Tiempo de la consulta: 0.22 ms Después de la última consulta: 5.30 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.413 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 59 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

42. Tiempo de la consulta: 0.26 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.424 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=58 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=58 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

43. Tiempo de la consulta: 0.22 ms Después de la última consulta: 6.29 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.447 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 58 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

44. Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.463 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=57 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=57 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

45. Tiempo de la consulta: 0.32 ms Después de la última consulta: 10.98 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.486 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 57 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

46. Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.501 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=56 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=56 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

47. Tiempo de la consulta: 0.22 ms Después de la última consulta: 4.47 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.525 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 56 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

48. Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.34 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.541 MB Filas devueltas: 1

    SELECT b.id 
      FROM z2msh_zoo_category_item AS a JOIN z2msh_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=55 
      AND b.published = 1 UNION SELECT 0 
      FROM z2msh_zoo_category_item AS a 
      WHERE a.item_id=55 
      AND a.category_id = 0

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	doazafrandelamancha.a.category_id	1	50.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table
    3	UNION RESULT	<union1,2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Using temporary

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:25
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

49. Tiempo de la consulta: 0.26 ms Después de la última consulta: 7.59 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.565 MB Filas devueltas: 0

    SELECT id 
      FROM z2msh_zoo_comment 
      WHERE item_id = 55 
      AND state = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_zoo_comment	NULL	ref	STATE_INDEX,ITEMID_INDEX,ITEMID_STATE_INDEX	STATE_INDEX	1	const	1	7.69	Using where

    Perfil

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    27	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
    26	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:710
    25	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:54
    24	ElementItemCommentsLink->render()	JROOT/components/com_zoo/renderer/element/pipe.php:23
    23	include JROOT/components/com_zoo/renderer/element/pipe.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php:71
    20	include JROOT/media/zoo/applications/blog/templates/doazafran/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    18	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/doazafran/_item.php:18
    17	include JROOT/media/zoo/applications/blog/templates/doazafran/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/_items.php:40
    15	include JROOT/media/zoo/applications/blog/templates/doazafran/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    14	AppView->partial()	JROOT/media/zoo/applications/blog/templates/doazafran/category.php:69
    13	include JROOT/media/zoo/applications/blog/templates/doazafran/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

50. Tiempo de la consulta: 0.54 ms Después de la última consulta: 6.41 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 14.629 MB Filas devueltas: 3

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

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	z2msh_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	109	1.00	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.28 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    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/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

51. Tiempo de la consulta: 1.01 ms Después de la última consulta: 2.46 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 14.885 MB Filas devueltas: 12

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM z2msh_modules AS m
    
      LEFT JOIN z2msh_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN z2msh_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 <= '2026-09-30 07:37:51') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-30 07:37:51') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 134 OR mm.menuid <= 0) 
      AND m.language IN ('es-ES','*')
    
      ORDER BY m.position, m.ordering

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds,idx_language	No pudo usarse una clave de índice	NULL	NULL	67	1.49	Using where; Usando 'filesort'
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	doazafrandelamancha.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	doazafrandelamancha.m.id	1	40.00	Using where; Using index

    Perfil

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.04 ms
    executing	0.58 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	Lo mismo que llamada de la línea de abajo.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/dopazafranlamancha/includes/params.php:47
    8	include JROOT/templates/dopazafranlamancha/includes/params.php	JROOT/templates/dopazafranlamancha/index.php:15
    7	require JROOT/templates/dopazafranlamancha/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

52. Tiempo de la consulta: 0.26 ms Después de la última consulta: 3.70 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 15.119 MB Filas devueltas: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `z2msh_menu` AS `c`
    
      INNER JOIN `z2msh_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `z2msh_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `z2msh_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 134

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

    Perfil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	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.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
    11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---