Directorio

Arrecife Tours

Es una organización que funciona desde el 11 septiembre del 2001, teniendo siempre ...

BAST

Somos una empresa de arte y producción audiovisual.

Enjabonarte Honduras

Elaboramos jabones artesanales , verdaderamente 100% naturales.

Envasados Karlita

Envasados Karlita elabora productos con ingredientes frescos, de calidad gourmet...

Envios Express HN

Ofrecemos el servicios de encomiendas de HN-USA...

Guacamaya Films

Guacamaya Films es una productora de cine basada...

Servitodo S. de R.L.

Compañía dedicada al Alquiler de Toldos, Sillas ...

Sunday SkateShop

Skate boards y mas ... Sunday Skateshop los mejores y más...

Villa Montecarlo

Su más bella opción para que su día sea inolvidable !

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732172264,
                "last": 1732172264,
                "now": 1732172264
            },
            "client": {
                "forwarded": "3.138.126.124"
            },
            "token": "2uHynLIE73Lp31f72zGYp2SN9JvLHvin"
        },
        "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"
        }
    }
}

Información del perfil

Fecha y hora

Memoria

Fecha y hora: 13.27 ms / 13.27 ms Memoria: 0.864 MB / 1.09 MB Application: afterLoad

Fecha y hora: 72.83 ms / 86.10 ms Memoria: 2.518 MB / 3.61 MB Application: afterInitialise

Fecha y hora: 7.51 ms / 93.61 ms Memoria: 0.219 MB / 3.83 MB Application: afterRoute

Fecha y hora: 3.12 ms / 96.73 ms Memoria: 0.105 MB / 3.93 MB Application: beforeRenderComponent com_zoo

Fecha y hora: 15.24 ms / 111.97 ms Memoria: 0.528 MB / 4.46 MB Application: Before Access::preloadComponents (all components)

Fecha y hora: 1.60 ms / 113.57 ms Memoria: 0.097 MB / 4.56 MB Application: After Access::preloadComponents (all components)

Fecha y hora: 0.05 ms / 113.62 ms Memoria: -0.005 MB / 4.55 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Fecha y hora: 0.48 ms / 114.10 ms Memoria: 0.019 MB / 4.57 MB Application: After Access::getAssetRules (id:1 name:root.1)

Fecha y hora: 90.61 ms / 204.71 ms Memoria: 1.892 MB / 6.46 MB Application: afterRenderComponent com_zoo

Fecha y hora: 3.18 ms / 207.89 ms Memoria: 0.072 MB / 6.53 MB Application: afterDispatch

Fecha y hora: 7.71 ms / 215.60 ms Memoria: 0.426 MB / 6.96 MB Application: beforeRenderModule mod_gtranslate (GTranslate)

Fecha y hora: 4.92 ms / 220.52 ms Memoria: 0.075 MB / 7.03 MB Application: afterRenderModule mod_gtranslate (GTranslate)

Fecha y hora: 1.60 ms / 222.12 ms Memoria: -0.075 MB / 6.96 MB Application: beforeRenderModule mod_custom (Directorio Social Buttons)

Fecha y hora: 1.08 ms / 223.19 ms Memoria: 0.011 MB / 6.97 MB Application: afterRenderModule mod_custom (Directorio Social Buttons)

Fecha y hora: 0.80 ms / 224.00 ms Memoria: -0.002 MB / 6.97 MB Application: beforeRenderModule mod_custom (Directorio Social Button Twitter)

Fecha y hora: 0.41 ms / 224.41 ms Memoria: 0.007 MB / 6.98 MB Application: afterRenderModule mod_custom (Directorio Social Button Twitter)

Fecha y hora: 1.41 ms / 225.82 ms Memoria: 0.006 MB / 6.98 MB Application: beforeRenderModule mod_menu (Main Menu)

Fecha y hora: 4.17 ms / 229.99 ms Memoria: 0.064 MB / 7.04 MB Application: afterRenderModule mod_menu (Main Menu)

Fecha y hora: 3.50 ms / 233.50 ms Memoria: 0.116 MB / 7.16 MB Application: beforeRenderModule mod_search (Buscar)

Fecha y hora: 7.01 ms / 240.51 ms Memoria: 0.028 MB / 7.19 MB Application: afterRenderModule mod_search (Buscar)

Fecha y hora: 2.29 ms / 242.80 ms Memoria: -0.001 MB / 7.19 MB Application: beforeRenderModule mod_menu (Otros Servicios - Blog - Videos)

Fecha y hora: 1.88 ms / 244.68 ms Memoria: 0.020 MB / 7.21 MB Application: afterRenderModule mod_menu (Otros Servicios - Blog - Videos)

Fecha y hora: 10.02 ms / 254.70 ms Memoria: 0.139 MB / 7.35 MB Application: afterRender

Total de consultas a la base de datos: 21.68 ms

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

#	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

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	Using index

#	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:51

'Explicar' no es posible en la consulta: INSERT INTO `nfojm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6768626e70693463706c656a32326c3272303866336e65736137', 1, 1732172264, 0, '', 0)

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.08 ms
end	0.00 ms
query end	0.86 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
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:51

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

Tiempo de la consulta: 0.43 ms Después de la última consulta: 2.88 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 1.894 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.03 ms
checking permissions	0.00 ms
Opening tables	0.21 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.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/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.]

Tiempo de la consulta: 0.57 ms Después de la última consulta: 0.28 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 1.918 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.27 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 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.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.]

Tiempo de la consulta: 0.54 ms Después de la última consulta: 39.01 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.932 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.27 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.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: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.]

Tiempo de la consulta: 0.77 ms Después de la última consulta: 21.89 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.841 MB

UPDATE `nfojm_extensions`

  SET `params` = '{\"mediaversion\":\"ee8e7df16b27c30027f78ff85dbab41d\"}'

  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.05 ms
checking permissions	0.00 ms
Opening tables	0.33 ms
init	0.02 ms
System lock	0.11 ms
updating	0.07 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.02 ms
freeing items	0.03 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.]

Tiempo de la consulta: 1.19 ms Después de la última consulta: 6.85 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 4.193 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.05 ms
checking permissions	0.00 ms
Opening tables	0.61 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.30 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.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
12	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php: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:83
7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:54

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

Tiempo de la consulta: 1.01 ms Después de la última consulta: 9.10 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 4.466 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.07 ms
checking permissions	0.01 ms
Opening tables	0.31 ms
init	0.05 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.26 ms
end	0.00 ms
query end	0.01 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/components/com_zoo/controllers/default.php:214
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.14 ms Después de la última consulta: 1.21 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.605 MB


  SET SESSION group_concat_max_len = 1048576

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/category.php:183
15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:432
14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:456
13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 3.01 ms Después de la última consulta: 0.55 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 4.640 MB Filas devueltas: 2

SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM nfojm_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN nfojm_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN nfojm_zoo_item AS i USE INDEX (MULTI_INDEX2) 
  ON ci.item_id = i.id 
  AND i.access IN (1,5) 
  AND i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-21 06:57:44') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-21 06:57:44') 
  WHERE c.application_id = 1 
  AND c.published = 1 
  GROUP BY c.id

Explicar

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

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.89 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.07 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.62 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.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
19	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
18	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
17	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
16	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:209
15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:432
14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:456
13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 2.33 ms Después de la última consulta: 1.47 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 4.744 MB Filas devueltas: 12

SELECT a.* 
  FROM nfojm_zoo_item AS a 
  LEFT JOIN nfojm_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 1 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-21 06:57:44') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 06:57:44') 
  AND b.category_id  = 0 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.name 
  LIMIT 0,15

Explicar

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

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 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.39 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	1.24 ms
Creating sort index	0.25 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.06 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
15	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
14	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:467
13	ItemTable->getByCategory()	JROOT/components/com_zoo/controllers/default.php:235
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.70 ms Después de la última consulta: 1.92 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 5.102 MB Filas devueltas: 12

SELECT a.id 
  FROM nfojm_zoo_item AS a 
  LEFT JOIN nfojm_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 1 
  AND b.category_id  = 0 
  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 06:57:44') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 06:57:44') 
  GROUP BY a.id

Explicar

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

Perfil

Status	Duration
starting	0.06 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.02 ms
statistics	0.16 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
Creating sort index	0.02 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.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
14	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
13	ItemTable->getItemCountFromCategory()	JROOT/components/com_zoo/controllers/default.php:236
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 1.51 ms Después de la última consulta: 10.30 ms Consulta a la memoria: 0.044 MB memoria antes de la consulta: 5.500 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 nfojm_fields AS a

  LEFT JOIN `nfojm_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN nfojm_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN nfojm_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN nfojm_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN nfojm_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_zoo.application.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 index condition; Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	empresas_jmln11.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	empresas_jmln11.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	empresas_jmln11.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	empresas_jmln11.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	empresas_jmln11.a.group_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.14 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.71 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.17 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.02 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
29	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
28	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
27	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
26	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
25	PlgSystemFields->onContentPrepare()	Lo mismo que llamada de la línea de abajo.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	Lo mismo que llamada de la línea de abajo.
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:181
17	ZooHelper->triggerContentPlugins()	JROOT/administrator/components/com_zoo/classes/application.php:800
16	Application->getText()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:55
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.83 ms Después de la última consulta: 15.41 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 5.919 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=25 
  AND b.published = 1 UNION SELECT 0 
  FROM nfojm_zoo_category_item AS a 
  WHERE a.item_id=25 
  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.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 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.29 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.02 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.43 ms Después de la última consulta: 11.28 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 6.072 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.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 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.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.02 ms
removing tmp table	0.01 ms
query end	0.00 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
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.51 ms Después de la última consulta: 4.13 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 6.117 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=8 
  AND b.published = 1 UNION SELECT 0 
  FROM nfojm_zoo_category_item AS a 
  WHERE a.item_id=8 
  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.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.07 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.01 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 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.02 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
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.44 ms Después de la última consulta: 3.76 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 6.164 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.05 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.02 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.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.55 ms Después de la última consulta: 4.00 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 6.208 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.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 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.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.04 ms
executing	0.00 ms
Sending data	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.02 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.40 ms Después de la última consulta: 4.13 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 6.254 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=33 
  AND b.published = 1 UNION SELECT 0 
  FROM nfojm_zoo_category_item AS a 
  WHERE a.item_id=33 
  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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 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.01 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.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.41 ms Después de la última consulta: 3.27 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 6.299 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.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
init	0.05 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.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 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.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.35 ms Después de la última consulta: 2.91 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 6.343 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=34 
  AND b.published = 1 UNION SELECT 0 
  FROM nfojm_zoo_category_item AS a 
  WHERE a.item_id=34 
  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.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.01 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.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
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.36 ms Después de la última consulta: 2.48 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 6.387 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=2 
  AND b.published = 1 UNION SELECT 0 
  FROM nfojm_zoo_category_item AS a 
  WHERE a.item_id=2 
  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.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.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.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.37 ms Después de la última consulta: 2.45 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 6.432 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.07 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.02 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.01 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.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.39 ms Después de la última consulta: 2.54 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 6.476 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.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.06 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.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.01 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.02 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.33 ms Después de la última consulta: 3.02 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 6.520 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.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.01 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.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
27	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:64
26	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php:16
22	include JROOT/media/zoo/applications/business/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
20	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/default/_item.php:17
19	include JROOT/media/zoo/applications/business/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
18	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/_items.php:27
17	include JROOT/media/zoo/applications/business/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/business/templates/default/frontpage.php:76
15	include JROOT/media/zoo/applications/business/templates/default/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:322
12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
10	DefaultController->display()	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.]

Tiempo de la consulta: 0.57 ms Después de la última consulta: 3.71 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 6.468 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.04 ms
checking permissions	0.00 ms
Opening tables	0.29 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

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

Tiempo de la consulta: 0.51 ms Después de la última consulta: 0.89 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 6.499 MB Filas devueltas: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `nfojm_menu` AS `c`

  INNER JOIN `nfojm_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `nfojm_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `nfojm_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 108

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
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.24 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
10	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
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.]

Tiempo de la consulta: 1.24 ms Después de la última consulta: 4.87 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 6.757 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 06:57:44') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 06:57:44') 
  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.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.31 ms
init	0.04 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.49 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 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.]

18 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

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

1 × 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 nfojm_fields AS a 
  LEFT JOIN `nfojm_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN nfojm_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN nfojm_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN nfojm_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN nfojm_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT a.id 
  FROM nfojm_zoo_item AS a 
  LEFT JOIN nfojm_zoo_category_item AS b 
  ON a.id = b.item_id

1 × SELECT language,id 
  FROM `nfojm_menu`

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

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `nfojm_menu` AS `c` 
  INNER JOIN `nfojm_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `nfojm_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `nfojm_menu` AS `c2` 
  ON a2.id = c2.`id`

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

1 × SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM nfojm_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN nfojm_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN nfojm_zoo_item AS i USE INDEX (MULTI_INDEX2) 
  ON ci.item_id = i.id 
  AND i.access IN (1,5) 
  AND i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-21 06:57:44') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-21 06:57:44')

1 × SELECT id, rules 
  FROM `nfojm_viewlevels

1 × SELECT `session_id` 
  FROM `nfojm_session`

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

1 × SELECT id,template 
  FROM nfojm_template_styles

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

1 × SELECT * 
  FROM nfojm_zoo_application

1 × SELECT `data` 
  FROM `nfojm_session`

OTRAS tablas:

1 × 
  SET SESSION group_concat_max_len = 104857

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

1 × INSERT INTO `nfojm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6768626e70693463706c656a32326c3272303866336e65736137', 1, 1732172264, 0, '', 0

Servicios (1)

Artesanias (1)

Arrecife Tours

BAST

Eco Di Mare Tours

Enjabonarte Honduras

Envasados Karlita

Envios Express HN

Guacamaya Films

Kassandra Colecciones

Kurios Designs

Servitodo S. de R.L.

Sunday SkateShop

Villa Montecarlo

Consola de depuración de Joomla!

Sesión

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

29 consultas registradas 21.68 ms

18 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: