Empresas etiquetadas con: Honduras

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1732195521,
                "last": 1732195521,
                "now": 1732195522
            },
            "client": {
                "forwarded": "3.145.7.253"
            },
            "token": "GxXaWqqQnXwhkeTDyaimPOwKNE3Iklzk"
        },
        "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

18 consultas registradas 12.63 ms

1. Tiempo de la consulta: 0.37 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 1.641 MB Filas devueltas: 1

   SELECT `data`
   
     FROM `nfojm_session`
   
     WHERE `session_id` = X'6b6e67356137736b3361323468356371636c6e76717574396336'

   Explicar

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

   Perfil

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

   Llamada de pila

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

   [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: 2.45 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 1.869 MB Filas devueltas: 5

   SELECT id, rules
   
     FROM `nfojm_viewlevels`

   Explicar

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

   Perfil

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

   Llamada de pila

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

   [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.40 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 1.894 MB Filas devueltas: 2

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

   Explicar

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

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:54

   [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.33 ms Después de la última consulta: 23.15 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.907 MB Filas devueltas: 1

   SELECT id,template 
     FROM nfojm_template_styles 
     WHERE client_id=0 
     AND home=1

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nfojm_template_styles	NULL	ALL	idx_client_id,idx_client_id_home	No pudo usarse una clave de índice	NULL	NULL	7	14.29	Using where

   Perfil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.09 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   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:1662
   18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
   17	plgSystemWidgetkit_zoo->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
   16	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
   15	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Lo mismo que llamada de la línea de abajo.
   14	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
   13	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
   12	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:67
   11	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
   10	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit_zoo/widgetkit_zoo.php:9
   9	plgSystemWidgetkit_zoo->onAfterInitialise()	Lo mismo que llamada de la línea de abajo.
   8	call_user_func_array()	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:54

   [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.42 ms Después de la última consulta: 17.09 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.841 MB

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

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	UPDATE	nfojm_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

   Perfil

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

   Llamada de pila

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

   [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: 1.00 ms Después de la última consulta: 19.64 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 4.197 MB Filas devueltas: 1

   SELECT * 
     FROM nfojm_zoo_application 
     WHERE id = 1

   Explicar

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

   Perfil

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

   Llamada de pila

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

   [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.11 ms Después de la última consulta: 20.29 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 4.511 MB Filas devueltas: 2

   SELECT * 
     FROM nfojm_zoo_category 
     WHERE application_id = 1 
     AND published = 1 
     ORDER BY ordering

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	nfojm_zoo_category	NULL	ref	PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	APPLICATIONID_ID_INDEX	5	const,const	2	100.00	Using index condition; Usando 'filesort'

   Perfil

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

   Llamada de pila

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

   [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.66 ms Después de la última consulta: 6.47 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 4.624 MB Filas devueltas: 38

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `nfojm_assets`
   
     WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contushdvideoshare','com_cpanel','com_fields','com_finder','com_installer','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_users','com_weblinks','com_widgetkit','com_wrapper','com_zoo')

   Explicar

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

   Perfil

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

   Llamada de pila

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

   [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: 3.16 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 4.725 MB Filas devueltas: 7

   SELECT a.* 
     FROM nfojm_zoo_item AS a  
     LEFT JOIN nfojm_zoo_tag AS b 
     ON a.id = b.item_id 
     WHERE a.application_id = 1 
     AND b.name = 'Honduras' 
     AND a.access IN (1,5) 
     AND a.state = 1 
     AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-21 13:25:22') 
     AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 13:25:22') 
     GROUP BY a.id 
     ORDER BY a.priority DESC, a.name

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	range	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	MULTI_INDEX	14	NULL	12	40.00	Using index condition; Using temporary; Usando 'filesort'
   1	SIMPLE	b	NULL	eq_ref	PRIMARY,NAME_ITEMID_INDEX	PRIMARY	771	empresas_jmln11.a.id,const	1	100.00	Using index

   Perfil

   Status	Duration
   starting	0.08 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	1.09 ms
   init	0.04 ms
   System lock	0.00 ms
   optimizing	0.02 ms
   statistics	0.43 ms
   preparing	0.02 ms
   Creating tmp table	0.03 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	1.12 ms
   Creating sort index	0.13 ms
   end	0.00 ms
   query end	0.00 ms
   removing tmp table	0.04 ms
   query end	0.00 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Llamada de pila

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

   [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: 1.22 ms Después de la última consulta: 30.00 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 5.479 MB Filas devueltas: 1

    SELECT b.id 
      FROM nfojm_zoo_category_item AS a JOIN nfojm_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=32 
      AND b.published = 1 UNION SELECT 0 
      FROM nfojm_zoo_category_item AS a 
      WHERE a.item_id=32 
      AND a.category_id = 0

    Explicar

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

    Perfil

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

    Llamada de pila

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

    [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.38 ms Después de la última consulta: 13.34 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 5.640 MB Filas devueltas: 1

    SELECT b.id 
      FROM nfojm_zoo_category_item AS a JOIN nfojm_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=3 
      AND b.published = 1 UNION SELECT 0 
      FROM nfojm_zoo_category_item AS a 
      WHERE a.item_id=3 
      AND a.category_id = 0

    Explicar

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

    Perfil

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

    Llamada de pila

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

    [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.31 ms Después de la última consulta: 2.52 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 5.682 MB Filas devueltas: 2

    SELECT b.id 
      FROM nfojm_zoo_category_item AS a JOIN nfojm_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=35 
      AND b.published = 1 UNION SELECT 0 
      FROM nfojm_zoo_category_item AS a 
      WHERE a.item_id=35 
      AND a.category_id = 0

    Explicar

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

    Perfil

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

    Llamada de pila

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

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

    ---

13. Tiempo de la consulta: 0.31 ms Después de la última consulta: 3.11 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 5.726 MB Filas devueltas: 1

    SELECT b.id 
      FROM nfojm_zoo_category_item AS a JOIN nfojm_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=29 
      AND b.published = 1 UNION SELECT 0 
      FROM nfojm_zoo_category_item AS a 
      WHERE a.item_id=29 
      AND a.category_id = 0

    Explicar

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

    Perfil

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

    Llamada de pila

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

    [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: 0.29 ms Después de la última consulta: 2.49 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 5.768 MB Filas devueltas: 1

    SELECT b.id 
      FROM nfojm_zoo_category_item AS a JOIN nfojm_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=31 
      AND b.published = 1 UNION SELECT 0 
      FROM nfojm_zoo_category_item AS a 
      WHERE a.item_id=31 
      AND a.category_id = 0

    Explicar

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

    Perfil

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

    Llamada de pila

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

    [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.29 ms Después de la última consulta: 2.33 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 5.810 MB Filas devueltas: 1

    SELECT b.id 
      FROM nfojm_zoo_category_item AS a JOIN nfojm_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=28 
      AND b.published = 1 UNION SELECT 0 
      FROM nfojm_zoo_category_item AS a 
      WHERE a.item_id=28 
      AND a.category_id = 0

    Explicar

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

    Perfil

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

    Llamada de pila

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

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

    ---

16. Tiempo de la consulta: 0.28 ms Después de la última consulta: 2.31 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 5.852 MB Filas devueltas: 1

    SELECT b.id 
      FROM nfojm_zoo_category_item AS a JOIN nfojm_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=30 
      AND b.published = 1 UNION SELECT 0 
      FROM nfojm_zoo_category_item AS a 
      WHERE a.item_id=30 
      AND a.category_id = 0

    Explicar

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

    Perfil

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

    Llamada de pila

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

    [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.50 ms Después de la última consulta: 2.57 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 5.794 MB Filas devueltas: 1

    SELECT language,id
    
      FROM `nfojm_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	nfojm_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	28	1.61	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    8	PlgSystemLanguageFilter->onAfterDispatch()	Lo mismo que llamada de la línea de abajo.
    7	call_user_func_array()	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:54

    [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: 1.32 ms Después de la última consulta: 13.21 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 6.061 MB Filas devueltas: 17

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM nfojm_modules AS m
    
      LEFT JOIN nfojm_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN nfojm_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 <= '2024-11-21 13:25:22') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 13:25:22') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 108 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	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	32	1.59	Using index condition; Using where; Usando 'filesort'
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	empresas_jmln11.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	empresas_jmln11.m.id	1	40.00	Using where; Using index

    Perfil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.33 ms
    init	0.04 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.48 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.02 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()	Lo mismo que llamada de la línea de abajo.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:49
    11	ModulesWarpHelper->count()	JROOT/templates/yoo_quantum/layouts/template.config.php:23
    10	include JROOT/templates/yoo_quantum/layouts/template.config.php	JROOT/templates/yoo_quantum/layouts/template.php:10
    9	include JROOT/templates/yoo_quantum/layouts/template.php	JROOT/templates/yoo_quantum/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/yoo_quantum/index.php:19
    7	require JROOT/templates/yoo_quantum/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:54

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

    ---

12 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

1. 7 × SELECT b.id 
     FROM nfojm_zoo_category_item AS a JOIN nfojm_zoo_category AS b 
     ON a.category_id = b.id

2. 1 × SELECT a.* 
     FROM nfojm_zoo_item AS a  
     LEFT JOIN nfojm_zoo_tag AS b 
     ON a.id = b.item_id

3. 1 × SELECT language,id 
     FROM `nfojm_menu`

4. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM nfojm_modules AS m 
     LEFT JOIN nfojm_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN nfojm_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

5. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `nfojm_assets`

6. 1 × SELECT * 
     FROM nfojm_zoo_category

7. 1 × SELECT id, rules 
     FROM `nfojm_viewlevels

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

9. 1 × SELECT id,template 
     FROM nfojm_template_styles

10. 1 × SELECT * 
      FROM nfojm_zoo_application

11. 1 × SELECT `data` 
      FROM `nfojm_session`

OTRAS tablas:

1. 1 × UPDATE `nfojm_extensions` 
     SET `params` = '{\"mediaversion\":\"ccc14886d27092f3c4fdc263e504f5df\"}'