Joint spiralé

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1759744900,
                "last": 1759744900,
                "now": 1759744900
            },
            "client": {
                "forwarded": "216.73.216.88"
            },
            "token": "ZJcIM8WguJdcV0RzovdHQ9aGy6ju6lxA"
        },
        "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

46 consultas registradas 28.39 ms

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

   SELECT `data`
   
     FROM `s66sf_session`
   
     WHERE `session_id` = X'3739393638343834636331623965623430623931636561343263313435353037'

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s66sf_session	NULL	const	PRIMARY	PRIMARY	194	const	1	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.07 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   executing	0.00 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.00 ms
   freeing items	0.03 ms
   cleaning up	0.00 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.27 ms Después de la última consulta: 0.69 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 4.152 MB Filas devueltas: 0

   SELECT `session_id`
   
     FROM `s66sf_session`
   
     WHERE `session_id` = X'3739393638343834636331623965623430623931636561343263313435353037' 
     LIMIT 1

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s66sf_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.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   executing	0.00 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.00 ms
   freeing items	0.03 ms
   cleaning up	0.00 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: 0.70 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 4.157 MB

   INSERT INTO `s66sf_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3739393638343834636331623965623430623931636561343263313435353037', 1, 1759744900, 0, '', 0)

   Explicar

   'Explicar' no es posible en la consulta: INSERT INTO `s66sf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3739393638343834636331623965623430623931636561343263313435353037', 1, 1759744900, 0, '', 0)

   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.00 ms
   update	0.04 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.44 ms
   closing tables	0.00 ms
   freeing items	0.03 ms
   cleaning up	0.00 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.64 ms Después de la última consulta: 1.19 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 4.364 MB Filas devueltas: 47

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `s66sf_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	s66sf_extensions	NULL	ref	extension	extension	82	const	51	1.00	Using where

   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.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.13 ms
   end	0.00 ms
   query end	0.01 ms
   waiting for handler commit	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 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.29 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.658 MB Filas devueltas: 5

   SELECT id, rules
   
     FROM `s66sf_viewlevels`

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s66sf_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.01 ms
   init	0.00 ms
   System lock	0.00 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.00 ms
   closing tables	0.00 ms
   freeing items	0.03 ms
   cleaning up	0.00 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.35 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.670 MB Filas devueltas: 2

   SELECT b.id
   
     FROM s66sf_usergroups AS a
   
     LEFT JOIN s66sf_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.02 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.06 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.00 ms
   freeing items	0.03 ms
   cleaning up	0.00 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: 1.01 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 4.741 MB Filas devueltas: 128

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM s66sf_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	s66sf_extensions	NULL	ref	extension	extension	82	const	313	0.60	Using where; Usando 'filesort'

   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.00 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.68 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.00 ms
   freeing items	0.03 ms
   cleaning up	0.00 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.33 ms Después de la última consulta: 8.37 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 6.656 MB Filas devueltas: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `s66sf_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	s66sf_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.01 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.00 ms
   freeing items	0.03 ms
   cleaning up	0.00 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   20	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   19	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Lo mismo que llamada de la línea de abajo.
   18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   16	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   15	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   14	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   11	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_acymailing/compat/joomla.php:235
   10	acymailing_addScript()	JROOT/administrator/components/com_acymailing/compat/joomla.php:37
   9	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:14
   8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:19
   7	plgSystemRegacymailing->__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.73 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 6.651 MB

   UPDATE `s66sf_extensions`
   
     SET `params` = '{\"mediaversion\":\"5fc24f4dd77be0166109542fe81124a6\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explicar

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

   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.03 ms
   updating	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.44 ms
   closing tables	0.00 ms
   freeing items	0.03 ms
   cleaning up	0.00 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   11	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_acymailing/compat/joomla.php:235
   10	acymailing_addScript()	JROOT/administrator/components/com_acymailing/compat/joomla.php:37
   9	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:14
   8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:19
   7	plgSystemRegacymailing->__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.83 ms Después de la última consulta: 2.49 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 7.320 MB Filas devueltas: 169

    SELECT * 
      FROM s66sf_acymailing_config

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s66sf_acymailing_config	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	169	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.09 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.01 ms
    executing	0.44 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 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/administrator/components/com_acymailing/classes/cpanel.php:17
    10	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
    9	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1371
    8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:19
    7	plgSystemRegacymailing->__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.]

    ---

11. Tiempo de la consulta: 0.56 ms Después de la última consulta: 3.10 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 8.075 MB Filas devueltas: 4

    SELECT *
    
      FROM s66sf_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	s66sf_languages	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	5	20.00	Using where; Usando 'filesort'

    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.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.13 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.00 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.]

    ---

12. Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 8.085 MB Filas devueltas: 10

    SELECT `element`,`name`,`client_id`,`extension_id`
    
      FROM `s66sf_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	s66sf_extensions	NULL	ref	extension	extension	82	const	10	1.00	Using where

    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.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.13 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 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.]

    ---

13. Tiempo de la consulta: 1.41 ms Después de la última consulta: 5.68 ms Consulta a la memoria: 0.320 MB memoria antes de la consulta: 8.820 MB Filas devueltas: 90

    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 s66sf_menu AS m
    
      LEFT JOIN s66sf_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	358	6.09	Using where; Usando 'filesort'
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	sealfranmod1.m.component_id	1	100.00	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.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.85 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	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
    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.]

    ---

14. Tiempo de la consulta: 1.98 ms Después de la última consulta: 9.62 ms Consulta a la memoria: 1.140 MB memoria antes de la consulta: 11.199 MB Filas devueltas: 90

    SELECT id, home, template, s.params
    
      FROM s66sf_template_styles as s
    
      LEFT JOIN s66sf_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	sealfranmod1.e.element	15	100.00	Using index condition; 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
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	1.46 ms
    end	0.02 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 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/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/plazart/includes/core/plazart.php:233
    9	Plazart::detect()	JROOT/plugins/system/plazart/plazart.php:55
    8	plgSystemPlazart->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.]

    ---

15. Tiempo de la consulta: 0.30 ms Después de la última consulta: 10.65 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 12.299 MB Filas devueltas: 5

    SELECT a.id
    
      FROM s66sf_viewlevels AS a
    
      ORDER BY a.ordering ASC, a.id ASC

    Explicar

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

    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.00 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.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:53
    13	Djc2CategoryNode->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:168
    12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
    11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:64
    10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
    9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 1.04 ms Después de la última consulta: 0.02 ms Consulta a la memoria: 0.531 MB memoria antes de la consulta: 12.305 MB Filas devueltas: 23

    SELECT c.*  
      FROM s66sf_djc2_categories AS c  
      ORDER BY c.parent_id ASC, c.ordering ASC

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	23	100.00	Usando 'filesort'

    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.00 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.01 ms
    executing	0.69 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    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_djcatalog2/lib/categories.php:298
    13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
    12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
    11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:64
    10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
    9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.85 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 12.637 MB Filas devueltas: 19
    Consultas duplicadas: #20

    SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
    
      FROM s66sf_djc2_categories as i
    
      INNER JOIN s66sf_djc2_images as img 
      on img.id=(select id 
      from s66sf_djc2_images 
      where type='category' 
      and item_id=i.id 
      order by ordering asc 
      limit 1)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	i	NULL	index	NULL	PRIMARY	4	NULL	23	100.00	Using index
    1	PRIMARY	img	NULL	eq_ref	PRIMARY	PRIMARY	4	func	1	100.00	Using where
    2	DEPENDENT SUBQUERY	s66sf_djc2_images	NULL	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	262	const,sealfranmod1.i.id	1	100.00	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
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.11 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.00 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.00 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.00 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.00 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 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_djcatalog2/lib/categories.php:305
    13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
    12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
    11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:64
    10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
    9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 0.29 ms Después de la última consulta: 2.87 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 13.082 MB Filas devueltas: 0

    select alias 
      from s66sf_djc2_items_extra_fields 
      where type='checkbox' or type='radio' or type='select'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s66sf_djc2_items_extra_fields	NULL	range	idx_type	idx_type	1002	NULL	3	100.00	Using where

    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.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    9	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/controller.php:95
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.69 ms Después de la última consulta: 1.86 ms Consulta a la memoria: 0.500 MB memoria antes de la consulta: 13.514 MB Filas devueltas: 16

    SELECT c.*  
      FROM s66sf_djc2_categories AS c  
      WHERE c.published=1 
      AND c.access IN (1,1,5)  
      ORDER BY c.parent_id ASC, c.ordering ASC

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ref	idx_published,idx_access,idx_published_parent_ordering	idx_published_parent_ordering	4	const	15	100.00	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.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.28 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 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_djcatalog2/lib/categories.php:298
    13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
    12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
    11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/views/item/view.html.php:55
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.76 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 13.809 MB Filas devueltas: 19
    Consultas duplicadas: #17

    SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
    
      FROM s66sf_djc2_categories as i
    
      INNER JOIN s66sf_djc2_images as img 
      on img.id=(select id 
      from s66sf_djc2_images 
      where type='category' 
      and item_id=i.id 
      order by ordering asc 
      limit 1)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	i	NULL	index	NULL	PRIMARY	4	NULL	23	100.00	Using index
    1	PRIMARY	img	NULL	eq_ref	PRIMARY	PRIMARY	4	func	1	100.00	Using where
    2	DEPENDENT SUBQUERY	s66sf_djc2_images	NULL	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	262	const,sealfranmod1.i.id	1	100.00	Usando 'filesort'

    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
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.00 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.00 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.00 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.00 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 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_djcatalog2/lib/categories.php:305
    13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
    12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
    11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/views/item/view.html.php:55
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.55 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 13.847 MB Filas devueltas: 5

    SELECT f.*, group_concat(fo.id separator '|') as options
    
      FROM s66sf_djc2_items_extra_fields as f
    
      LEFT JOIN s66sf_djc2_items_extra_fields_options as fo 
      ON fo.field_id=f.id
    
      WHERE (f.visibility = 1 or f.visibility = 3) 
      and f.published = 1
    
      GROUP BY f.id
    
      ORDER BY f.group_id asc, f.ordering asc

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	fo	NULL	system	idx_field_id	No pudo usarse una clave de índice	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	f	NULL	ref	PRIMARY,idx_published	idx_published	4	const	4	36.00	Using where; Using temporary; Usando 'filesort'

    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
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.15 ms
    preparing	0.01 ms
    Creating tmp table	0.03 ms
    executing	0.07 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 ms
    freeing items	0.03 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/components/com_djcatalog2/models/item.php:240
    13	DJCatalog2ModelItem->getAttributes()	JROOT/components/com_djcatalog2/models/item.php:126
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 0.44 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 13.865 MB Filas devueltas: 1

    SELECT i.*, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name 
    
      FROM s66sf_djc2_items as i
    
      LEFT JOIN s66sf_djc2_categories AS c 
      ON c.id = i.cat_id
    
      LEFT JOIN s66sf_djc2_producers AS p 
      ON p.id = i.producer_id
    
      LEFT JOIN s66sf_users AS ua 
      ON ua.id = i.created_by
    
      LEFT JOIN s66sf_djc2_countries AS countries 
      ON countries.id = i.country
    
      WHERE i.id =20 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-10-06 10:01:40') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-10-06 10:01:40')
    
      GROUP BY i.id

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	p	NULL	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	i	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
    1	SIMPLE	countries	NULL	const	PRIMARY	PRIMARY	2	const	0	0.00	unique row not found

    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
    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.05 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:155
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.35 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.897 MB Filas devueltas: 0
    Consultas duplicadas: #26

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value
    
      FROM s66sf_djc2_items_extra_fields_values_int as fieldvalues
    
      INNER JOIN s66sf_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN s66sf_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      LEFT JOIN s66sf_djc2_items_extra_fields_options as fieldoptions 
      ON fieldoptions.id = fieldvalues.value 
      AND fieldoptions.field_id = fields.id
    
      WHERE fieldvalues.item_id=20 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1
    
      ORDER BY fields.ordering asc, fieldoptions.ordering asc

    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.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
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 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/components/com_djcatalog2/models/item.php:275
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.37 ms Después de la última consulta: 0.02 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.905 MB Filas devueltas: 5
    Consultas duplicadas: #27

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
    
      FROM s66sf_djc2_items_extra_fields_values_text as fieldvalues
    
      INNER JOIN s66sf_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN s66sf_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      WHERE fieldvalues.item_id=20 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	items	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	fields	NULL	ref	PRIMARY,idx_published	idx_published	4	const	4	36.00	Using where
    1	SIMPLE	fieldvalues	NULL	eq_ref	idx_item_field	idx_item_field	8	const,sealfranmod1.fields.id	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
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 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/components/com_djcatalog2/models/item.php:277
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.36 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.915 MB Filas devueltas: 0
    Consultas duplicadas: #28

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
    
      FROM s66sf_djc2_items_extra_fields_values_date as fieldvalues
    
      INNER JOIN s66sf_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN s66sf_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      WHERE fieldvalues.item_id=20 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1
    
      ORDER BY fields.ordering asc

    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.03 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.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 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/components/com_djcatalog2/models/item.php:279
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.31 ms Después de la última consulta: 1.19 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 14.106 MB Filas devueltas: 0
    Consultas duplicadas: #23

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value
    
      FROM s66sf_djc2_items_extra_fields_values_int as fieldvalues
    
      INNER JOIN s66sf_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN s66sf_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      LEFT JOIN s66sf_djc2_items_extra_fields_options as fieldoptions 
      ON fieldoptions.id = fieldvalues.value 
      AND fieldoptions.field_id = fields.id
    
      WHERE fieldvalues.item_id=20 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1
    
      ORDER BY fields.ordering asc, fieldoptions.ordering asc

    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.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
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 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()	JROOT/components/com_djcatalog2/models/item.php:275
    14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
    12	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:61
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.32 ms Después de la última consulta: 0.02 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 14.113 MB Filas devueltas: 5
    Consultas duplicadas: #24

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
    
      FROM s66sf_djc2_items_extra_fields_values_text as fieldvalues
    
      INNER JOIN s66sf_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN s66sf_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      WHERE fieldvalues.item_id=20 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	items	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	fields	NULL	ref	PRIMARY,idx_published	idx_published	4	const	4	36.00	Using where
    1	SIMPLE	fieldvalues	NULL	eq_ref	idx_item_field	idx_item_field	8	const,sealfranmod1.fields.id	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
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 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()	JROOT/components/com_djcatalog2/models/item.php:277
    14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
    12	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:61
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.27 ms Después de la última consulta: 0.02 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 14.125 MB Filas devueltas: 0
    Consultas duplicadas: #25

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
    
      FROM s66sf_djc2_items_extra_fields_values_date as fieldvalues
    
      INNER JOIN s66sf_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN s66sf_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      WHERE fieldvalues.item_id=20 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1
    
      ORDER BY fields.ordering asc

    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.03 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.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 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()	JROOT/components/com_djcatalog2/models/item.php:279
    14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
    12	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:61
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.63 ms Después de la última consulta: 0.47 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 14.164 MB Filas devueltas: 93

    select id, producer_id 
      from s66sf_djc2_items 
      where published=1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s66sf_djc2_items	NULL	ref	idx_published	idx_published	4	const	92	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.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.36 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/route.php:77
    11	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/item/view.html.php:101
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.45 ms Después de la última consulta: 0.43 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 14.194 MB Filas devueltas: 0

    SELECT i.*, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price, c.id AS ccategory_id, c.alias as category_alias, p.id AS pproducer_id, p.alias as producer_alias, c.name AS category, p.name AS producer, p.published as publish_producer  
      FROM s66sf_djc2_items AS i  
      LEFT JOIN s66sf_djc2_categories AS c 
      ON c.id = i.cat_id  
      LEFT JOIN s66sf_djc2_producers AS p 
      ON p.id = i.producer_id  
      WHERE i.published = 1 
      AND i.id IN (SELECT related_item 
      FROM s66sf_djc2_items_related 
      WHERE item_id=20) 
      AND i.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      ORDER BY i.ordering ASC

    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.10 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:196
    11	DJCatalog2ModelItem->getRelatedItems()	JROOT/components/com_djcatalog2/views/item/view.html.php:159
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.79 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 14.202 MB Filas devueltas: 1

    SELECT subq.position 
      FROM (SELECT k.*, @num := @num + 1 AS position 
      FROM (SELECT @num := 0) AS n, (SELECT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
      FROM s66sf_djc2_items AS i  
      LEFT JOIN s66sf_djc2_categories as c 
      ON c.id = i.cat_id  
      LEFT JOIN s66sf_djc2_producers as p 
      ON p.id = i.producer_id  
      WHERE i.published = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-10-06 10:01:40') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-10-06 10:01:40') 
      AND c.published = 1  
      AND i.cat_id=10 
      ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc) as k) as subq 
      WHERE subq.id = 20 
      ORDER BY subq.position DESC 
      LIMIT 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Usando 'filesort'
    2	DERIVED	<derived3>	NULL	system	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	NULL
    2	DERIVED	<derived4>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	10	100.00	NULL
    4	DERIVED	p	NULL	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	0	0.00	const row not found
    4	DERIVED	c	NULL	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1	100.00	Usando 'filesort'
    4	DERIVED	i	NULL	ref	idx_cat_id,idx_published	idx_cat_id	4	const	67	15.66	Using where
    3	DERIVED	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	No tables used

    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.00 ms
    optimizing	0.00 ms
    optimizing	0.00 ms
    optimizing	0.00 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    statistics	0.00 ms
    preparing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.37 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:401
    11	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:161
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.85 ms Después de la última consulta: 0.01 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 14.210 MB Filas devueltas: 1

    SELECT subq.* 
      FROM (SELECT k.*, @num := @num + 1 AS position 
      FROM (SELECT @num := 0) AS n, (SELECT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
      FROM s66sf_djc2_items AS i  
      LEFT JOIN s66sf_djc2_categories as c 
      ON c.id = i.cat_id  
      LEFT JOIN s66sf_djc2_producers as p 
      ON p.id = i.producer_id  
      WHERE i.published = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-10-06 10:01:40') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-10-06 10:01:40') 
      AND c.published = 1  
      AND i.cat_id=10 
      ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc) as k) as subq 
      WHERE subq.position < 18 
      ORDER BY subq.position DESC 
      LIMIT 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	10	33.33	Using where; Usando 'filesort'
    2	DERIVED	<derived3>	NULL	system	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	NULL
    2	DERIVED	<derived4>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	10	100.00	NULL
    4	DERIVED	p	NULL	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	0	0.00	const row not found
    4	DERIVED	c	NULL	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1	100.00	Usando 'filesort'
    4	DERIVED	i	NULL	ref	idx_cat_id,idx_published	idx_cat_id	4	const	67	15.66	Using where
    3	DERIVED	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	No tables used

    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.05 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    optimizing	0.00 ms
    optimizing	0.00 ms
    executing	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    statistics	0.00 ms
    preparing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.45 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:413
    11	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:161
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.71 ms Después de la última consulta: 0.02 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 14.225 MB Filas devueltas: 1

    SELECT subq.* 
      FROM (SELECT k.*, @num := @num + 1 AS position 
      FROM (SELECT @num := 0) AS n, (SELECT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
      FROM s66sf_djc2_items AS i  
      LEFT JOIN s66sf_djc2_categories as c 
      ON c.id = i.cat_id  
      LEFT JOIN s66sf_djc2_producers as p 
      ON p.id = i.producer_id  
      WHERE i.published = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-10-06 10:01:40') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-10-06 10:01:40') 
      AND c.published = 1  
      AND i.cat_id=10 
      ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc) as k) as subq 
      WHERE subq.position > 18 
      ORDER BY subq.position ASC 
      LIMIT 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	10	33.33	Using where; Usando 'filesort'
    2	DERIVED	<derived3>	NULL	system	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	NULL
    2	DERIVED	<derived4>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	10	100.00	NULL
    4	DERIVED	p	NULL	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	0	0.00	const row not found
    4	DERIVED	c	NULL	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1	100.00	Usando 'filesort'
    4	DERIVED	i	NULL	ref	idx_cat_id,idx_published	idx_cat_id	4	const	67	15.66	Using where
    3	DERIVED	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	No tables used

    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.05 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    optimizing	0.00 ms
    optimizing	0.00 ms
    executing	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    statistics	0.00 ms
    preparing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.30 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:421
    11	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:161
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 1.23 ms Después de la última consulta: 1.41 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.566 MB Filas devueltas: 47

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `s66sf_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_commod','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_engine','com_fields','com_finder','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_tz_multipurpose','com_tz_portfolio','com_uniterevolution2','com_users','com_weblinks','com_wrapper','com_xmap')

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s66sf_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	48	100.00	Using index condition

    Perfil

    Status	Duration
    starting	0.69 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.18 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 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/Access/Access.php:429
    21	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    17	Joomla\CMS\User\User->authorise()	JROOT/components/com_djcatalog2/models/items.php:655
    16	DJCatalog2ModelItems->_buildContentWhere()	JROOT/components/com_djcatalog2/models/items.php:258
    15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:231
    14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:211
    12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:474
    11	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:163
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.33 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 14.652 MB Filas devueltas: 5

    SELECT f.*
    
      FROM s66sf_djc2_items_extra_fields as f
    
      WHERE f.published = 1
    
      ORDER BY f.group_id asc, f.ordering asc

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	f	NULL	ref	idx_published	idx_published	4	const	4	100.00	Usando 'filesort'

    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.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:807
    16	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:260
    15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:231
    14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:211
    12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:474
    11	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:163
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.35 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 14.671 MB Filas devueltas: 0

    SELECT o.id, o.field_id
    
      FROM s66sf_djc2_items_extra_fields_options AS o
    
      ORDER BY o.field_id asc, o.ordering asc

    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.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.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    executing	0.00 ms
    end	0.00 ms
    query end	0.13 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:817
    16	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:260
    15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:231
    14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:211
    12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:474
    11	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:163
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.64 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 14.681 MB Filas devueltas: 0

    SELECT distinct i.*, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name,states.name as state_name
    
      FROM s66sf_djc2_items as i
    
      LEFT JOIN s66sf_djc2_categories AS c 
      ON c.id = i.cat_id
    
      LEFT JOIN s66sf_djc2_producers AS p 
      ON p.id = i.producer_id
    
      LEFT JOIN s66sf_users AS ua 
      ON ua.id = i.created_by
    
      LEFT JOIN s66sf_djc2_countries AS countries 
      ON countries.id = i.country
    
      LEFT JOIN s66sf_djc2_countries_states AS states 
      ON states.id = i.state
    
      WHERE c.published = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-10-06 10:01:40') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-10-06 10:01:40') 
      AND i.published = 1 
      AND i.access IN (1,1,5) 
      AND i.parent_id=20
    
      ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	p	NULL	system	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	i	NULL	ref	idx_cat_id,idx_parent_id,idx_published,idx_access	idx_parent_id	4	const	1	15.66	Using where; Using temporary; Usando 'filesort'
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	sealfranmod1.i.created_by	1	100.00	NULL
    1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	sealfranmod1.i.cat_id	1	65.22	Using where
    1	SIMPLE	countries	NULL	eq_ref	PRIMARY	PRIMARY	2	sealfranmod1.i.country	1	100.00	Using index condition
    1	SIMPLE	states	NULL	eq_ref	PRIMARY	PRIMARY	4	sealfranmod1.i.state	1	100.00	NULL

    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
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.02 ms
    Creating tmp table	0.05 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.04 ms
    cleaning up	0.00 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/components/com_djcatalog2/models/items.php:195
    13	DJCatalog2ModelItems->_getList()	JROOT/components/com_djcatalog2/models/items.php:213
    12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:474
    11	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:163
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.32 ms Después de la última consulta: 0.42 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 14.717 MB Filas devueltas: 1

    SELECT *  
      FROM s66sf_djc2_images  
      WHERE item_id=20 	
      AND type='item' 
      AND exclude=0 
      ORDER BY ordering ASC, name ASC

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s66sf_djc2_images	NULL	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	262	const,const	1	10.00	Using where; Usando 'filesort'

    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.00 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
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/helpers/image.php:91
    12	DJCatalog2ImageHelper::getImages()	JROOT/components/com_djcatalog2/views/item/view.html.php:284
    11	DJCatalog2ViewItem->_prepareDocument()	JROOT/components/com_djcatalog2/views/item/view.html.php:182
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.27 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 14.726 MB

    UPDATE s66sf_djc2_items 
      SET hits = hits + 1 
      WHERE id = 20

    Explicar

    'Explicar' no es posible en la consulta: UPDATE s66sf_djc2_items SET hits = hits + 1 WHERE id = 20

    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
    updating	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_djcatalog2/models/item.php:494
    11	DJCatalog2ModelItem->hit()	JROOT/components/com_djcatalog2/views/item/view.html.php:184
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.60 ms Después de la última consulta: 5.23 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 15.536 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 s66sf_fields AS a
    
      LEFT JOIN `s66sf_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN s66sf_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN s66sf_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN s66sf_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN s66sf_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_djcatalog2.item.description' 
      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	sealfranmod1.a.language	1	100.00	NULL
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	sealfranmod1.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	sealfranmod1.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	sealfranmod1.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	sealfranmod1.a.group_id	1	100.00	Using where

    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
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.11 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.03 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.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:212
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.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_djcatalog2/views/item/view.html.php:186
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.42 ms Después de la última consulta: 0.52 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 15.546 MB Filas devueltas: 1

    SELECT *  
      FROM s66sf_djc2_files  
      WHERE item_id=20 	
      AND type='item' 
      ORDER BY ordering ASC, name ASC

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s66sf_djc2_files	NULL	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	262	const,const	1	100.00	Usando 'filesort'

    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.09 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 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()	JROOT/administrator/components/com_djcatalog2/helpers/file.php:81
    14	DJCatalog2FileHelper::getFiles()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:250
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.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_djcatalog2/views/item/view.html.php:186
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:105
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:58
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.72 ms Después de la última consulta: 20.47 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 15.839 MB Filas devueltas: 5

    SELECT language,id
    
      FROM `s66sf_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	s66sf_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	219	1.00	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.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.40 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 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.]

    ---

43. Tiempo de la consulta: 0.77 ms Después de la última consulta: 4.80 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 16.497 MB Filas devueltas: 5

    SHOW FULL COLUMNS 
      FROM `s66sf_plazart_styles`

    Explicar

    'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `s66sf_plazart_styles`

    Perfil

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.24 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    executing	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	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.04 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/joomla/database/driver/mysqli.php:448
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    15	Joomla\CMS\Table\Table->__construct()	JROOT/plugins/system/plazart/includes/tables/plazart_styles.php:22
    14	JTablePlazart_Styles->__construct()	JROOT/libraries/src/Table/Table.php:328
    13	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/plazart/includes/core/template.php:1359
    12	PlazartTemplate->get_layout()	JROOT/plugins/system/plazart/includes/core/template.php:1395
    11	PlazartTemplate::layout()	JROOT/templates/tz_jollyness_joomla/layouts/default.php:105
    10	include JROOT/templates/tz_jollyness_joomla/layouts/default.php	JROOT/plugins/system/plazart/includes/core/template.php:138
    9	PlazartTemplate->loadLayout()	JROOT/templates/tz_jollyness_joomla/libraries/plazart.render.php:68
    8	PlazartRender->__construct()	JROOT/templates/tz_jollyness_joomla/index.php:26
    7	require JROOT/templates/tz_jollyness_joomla/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.]

    ---

44. Tiempo de la consulta: 0.37 ms Después de la última consulta: 0.29 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.531 MB Filas devueltas: 1

    SELECT *
    
      FROM s66sf_plazart_styles
    
      WHERE `id` = '12'

    Explicar

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

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    13	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/plazart/includes/core/template.php:1360
    12	PlazartTemplate->get_layout()	JROOT/plugins/system/plazart/includes/core/template.php:1395
    11	PlazartTemplate::layout()	JROOT/templates/tz_jollyness_joomla/layouts/default.php:105
    10	include JROOT/templates/tz_jollyness_joomla/layouts/default.php	JROOT/plugins/system/plazart/includes/core/template.php:138
    9	PlazartTemplate->loadLayout()	JROOT/templates/tz_jollyness_joomla/libraries/plazart.render.php:68
    8	PlazartRender->__construct()	JROOT/templates/tz_jollyness_joomla/index.php:26
    7	require JROOT/templates/tz_jollyness_joomla/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.]

    ---

45. Tiempo de la consulta: 1.68 ms Después de la última consulta: 0.57 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 16.695 MB Filas devueltas: 4

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM s66sf_modules AS m
    
      LEFT JOIN s66sf_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN s66sf_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 <= '2025-10-06 10:01:40') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-10-06 10:01:40') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 539 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	378	0.93	Using where; Usando 'filesort'
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	sealfranmod1.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	sealfranmod1.m.id	6	40.00	Using where; Using index

    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.00 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	1.21 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	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/Helper/ModuleHelper.php:441
    18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    17	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    16	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    15	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/plazart/includes/core/template.php:1422
    14	PlazartTemplate::countModules()	JROOT/plugins/system/plazart/includes/core/template.php:878
    13	PlazartTemplate::showRow()	JROOT/plugins/system/plazart/includes/core/template.php:1002
    12	PlazartTemplate->generatelayout()	JROOT/plugins/system/plazart/includes/core/template.php:1396
    11	PlazartTemplate::layout()	JROOT/templates/tz_jollyness_joomla/layouts/default.php:105
    10	include JROOT/templates/tz_jollyness_joomla/layouts/default.php	JROOT/plugins/system/plazart/includes/core/template.php:138
    9	PlazartTemplate->loadLayout()	JROOT/templates/tz_jollyness_joomla/libraries/plazart.render.php:68
    8	PlazartRender->__construct()	JROOT/templates/tz_jollyness_joomla/index.php:26
    7	require JROOT/templates/tz_jollyness_joomla/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.]

    ---

46. Tiempo de la consulta: 0.45 ms Después de la última consulta: 4.63 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 17.056 MB Filas devueltas: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `s66sf_menu` AS `c`
    
      INNER JOIN `s66sf_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `s66sf_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `s66sf_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 539

    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.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
    checking permissions	0.00 ms
    Opening tables	0.09 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 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.]

    ---