Teachers

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1731953826,
                "last": 1731953826,
                "now": 1731953826
            },
            "token": "Mw6hVEjRWkOVzn3IZKjciwsCTMIItw5D"
        },
        "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
        }
    }
}

Información del perfil

Fecha y hora

Memoria

Fecha y hora: 12.87 ms / 12.87 ms Memoria: 2.006 MB / 2.38 MB Application: afterLoad

Fecha y hora: 66.93 ms / 79.80 ms Memoria: 6.653 MB / 9.04 MB Application: afterInitialise

Fecha y hora: 13.76 ms / 93.56 ms Memoria: 1.414 MB / 10.45 MB Application: afterRoute

Fecha y hora: 4.41 ms / 97.96 ms Memoria: 0.279 MB / 10.73 MB Application: beforeRenderComponent com_splms

Fecha y hora: 33.56 ms / 131.52 ms Memoria: 1.680 MB / 12.41 MB Application: afterRenderComponent com_splms

Fecha y hora: 6.88 ms / 138.41 ms Memoria: 0.723 MB / 13.13 MB Application: afterDispatch

Fecha y hora: 21.34 ms / 159.75 ms Memoria: 1.817 MB / 14.95 MB Application: Before Access::preloadComponents (all components)

Fecha y hora: 1.61 ms / 161.36 ms Memoria: 0.054 MB / 15.00 MB Application: After Access::preloadComponents (all components)

Fecha y hora: 0.02 ms / 161.38 ms Memoria: -0.003 MB / 15.00 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Fecha y hora: 0.38 ms / 161.76 ms Memoria: 0.027 MB / 15.03 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Fecha y hora: 0.07 ms / 161.83 ms Memoria: 0.003 MB / 15.03 MB Application: beforeRenderModule mod_helix3_options (Helix3 Options)

Fecha y hora: 0.25 ms / 162.08 ms Memoria: 0.025 MB / 15.05 MB Application: afterRenderModule mod_helix3_options (Helix3 Options)

Fecha y hora: 0.05 ms / 162.13 ms Memoria: 0.000 MB / 15.05 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Fecha y hora: 5.55 ms / 167.68 ms Memoria: 0.267 MB / 15.32 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Fecha y hora: 0.02 ms / 167.71 ms Memoria: -0.018 MB / 15.30 MB Application: beforeRenderModule mod_search (Search)

Fecha y hora: 0.54 ms / 168.24 ms Memoria: 0.016 MB / 15.32 MB Application: afterRenderModule mod_search (Search)

Fecha y hora: 0.07 ms / 168.31 ms Memoria: 0.003 MB / 15.32 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 1.06 ms / 169.37 ms Memoria: 0.058 MB / 15.38 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 15.25 ms / 184.62 ms Memoria: 1.204 MB / 16.59 MB Application: afterRender

Total de consultas a la base de datos: 41.80 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b9q1w_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:46

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 1.82 ms Después de la última consulta: 1.82 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 4.489 MB Filas devueltas: 41

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `b9q1w_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 1.32 ms Después de la última consulta: 1.70 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.682 MB Filas devueltas: 7

SELECT id, rules

  FROM `b9q1w_viewlevels`

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 1.31 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.696 MB Filas devueltas: 1

SELECT b.id

  FROM b9q1w_usergroups AS a

  LEFT JOIN b9q1w_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

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	1	100.00	Using where; Using index

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 0.95 ms Después de la última consulta: 0.46 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 4.764 MB Filas devueltas: 120

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM b9q1w_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 1.39 ms Después de la última consulta: 21.85 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 7.574 MB Filas devueltas: 1

SELECT `template`

  FROM `b9q1w_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	b9q1w_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	10	10.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
8	plgSystemHelix3->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.94 ms Después de la última consulta: 8.06 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 8.669 MB Filas devueltas: 28

SELECT *

  FROM b9q1w_rsform_config

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 2.16 ms Después de la última consulta: 4.52 ms Consulta a la memoria: 0.108 MB memoria antes de la consulta: 9.225 MB Filas devueltas: 65

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM b9q1w_menu AS m

  LEFT JOIN b9q1w_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.33 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.55 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Lo mismo que llamada de la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.48 ms Después de la última consulta: 7.37 ms Consulta a la memoria: 0.100 MB memoria antes de la consulta: 10.219 MB Filas devueltas: 10

SELECT id, home, template, s.params

  FROM b9q1w_template_styles as s

  LEFT JOIN b9q1w_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:266
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:216
9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:245
8	PlgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.22 ms Después de la última consulta: 1.56 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 10.356 MB Filas devueltas: 1

Consultas duplicadas: #47 #48 #49 #50 #51 #52

SELECT *

  FROM `b9q1w_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '13'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b9q1w_template_styles	NULL	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
11	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:216
9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:245
8	PlgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.26 ms Después de la última consulta: 0.80 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 10.486 MB Filas devueltas: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `b9q1w_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 0.54 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 10.477 MB

UPDATE `b9q1w_extensions`

  SET `params` = '{\"mediaversion\":\"8fca49ff42da9c849a61d1a8c5674884\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explicar

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

Perfil

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

Llamada de pila

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

[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.27 ms Después de la última consulta: 1.39 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 10.652 MB Filas devueltas: 2

SELECT *

  FROM b9q1w_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 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
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 7.05 ms Después de la última consulta: 7.92 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 11.753 MB Filas devueltas: 8

SELECT a.*,
  CASE WHEN courses.count IS NULL THEN 0 ELSE courses.count END as courses,
  CASE WHEN lessons.count IS NULL THEN 0 ELSE lessons.count END as lessons,
  CASE WHEN followers.count IS NULL THEN 0 ELSE followers.count END as followers

  FROM `b9q1w_splms_teachers` AS `a`

  LEFT JOIN ( SELECT b.teacher_id, COUNT(b.course_id) AS count 
  FROM b9q1w_splms_lessons b 
  WHERE b.published = 1 
  GROUP BY b.teacher_id ) AS courses 
  ON a.id = courses.teacher_id

  LEFT JOIN ( SELECT c.teacher_id, COUNT(c.id) AS count 
  FROM b9q1w_splms_lessons c 
  WHERE c.published = 1 
  GROUP BY c.teacher_id ) AS lessons 
  ON a.id = lessons.teacher_id

  LEFT JOIN ( SELECT d.teacher, COUNT(d.id) AS count 
  FROM b9q1w_splms_followers d 
  WHERE d.status = 1 
  GROUP BY d.teacher ) AS followers 
  ON a.id = followers.teacher

  WHERE a.access IN (1,1) 
  AND a.language in ('es-ES','*') 
  AND `a`.`published` = '1'

  ORDER BY `a`.`ordering` DESC 
  LIMIT 9

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	8	12.50	Using where; Usando 'filesort'
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	sitio38_web2020.a.id	2	100.00	Using where
1	PRIMARY	<derived3>	NULL	ref	<auto_key0>	<auto_key0>	4	sitio38_web2020.a.id	2	100.00	Using where
1	PRIMARY	<derived4>	NULL	ref	<auto_key0>	<auto_key0>	8	sitio38_web2020.a.id	2	100.00	Using where
4	DERIVED	d	NULL	index	teacher	teacher	8	NULL	1	100.00	Using where
3	DERIVED	c	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary
2	DERIVED	b	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_splms/models/teachers.php:83
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.22 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.782 MB Filas devueltas: 0

SELECT `a`.`status`

  FROM `b9q1w_splms_followers` AS `a`

  WHERE `a`.`teacher` = '1' 
  AND `a`.`student` = '0'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	teacher,student	teacher	8	const	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_splms/models/teachers.php:138
12	SplmsModelTeachers->isFollowing()	JROOT/components/com_splms/models/teachers.php:87
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 2.04 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 11.792 MB Filas devueltas: 1

SELECT 
  CASE WHEN reviews.ratings IS NULL THEN 0 ELSE reviews.ratings END as ratings, 
  CASE WHEN reviews.count IS NULL THEN 0 ELSE reviews.count END as count

  FROM `b9q1w_splms_lessons` AS `a`

  LEFT JOIN ( SELECT b.course_id, SUM(b.rating) AS ratings, COUNT(b.id) AS count 
  FROM b9q1w_splms_reviews b 
  WHERE b.published = 1 ) AS reviews 
  ON a.course_id = reviews.course_id

  WHERE `published` = 1 
  AND `a`.`teacher_id` = '1'

  GROUP BY a.course_id

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary
1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
2	DERIVED	b	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	2	50.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/teachers.php:109
12	SplmsModelTeachers->getRatings()	JROOT/components/com_splms/models/teachers.php:88
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.32 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.798 MB Filas devueltas: 0

SELECT `a`.`status`

  FROM `b9q1w_splms_followers` AS `a`

  WHERE `a`.`teacher` = '2' 
  AND `a`.`student` = '0'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	teacher,student	teacher	8	const	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_splms/models/teachers.php:138
12	SplmsModelTeachers->isFollowing()	JROOT/components/com_splms/models/teachers.php:87
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.39 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.807 MB Filas devueltas: 0

SELECT 
  CASE WHEN reviews.ratings IS NULL THEN 0 ELSE reviews.ratings END as ratings, 
  CASE WHEN reviews.count IS NULL THEN 0 ELSE reviews.count END as count

  FROM `b9q1w_splms_lessons` AS `a`

  LEFT JOIN ( SELECT b.course_id, SUM(b.rating) AS ratings, COUNT(b.id) AS count 
  FROM b9q1w_splms_reviews b 
  WHERE b.published = 1 ) AS reviews 
  ON a.course_id = reviews.course_id

  WHERE `published` = 1 
  AND `a`.`teacher_id` = '2'

  GROUP BY a.course_id

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary
1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
2	DERIVED	b	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	2	50.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/teachers.php:109
12	SplmsModelTeachers->getRatings()	JROOT/components/com_splms/models/teachers.php:88
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.812 MB Filas devueltas: 0

SELECT `a`.`status`

  FROM `b9q1w_splms_followers` AS `a`

  WHERE `a`.`teacher` = '3' 
  AND `a`.`student` = '0'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	teacher,student	teacher	8	const	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_splms/models/teachers.php:138
12	SplmsModelTeachers->isFollowing()	JROOT/components/com_splms/models/teachers.php:87
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.34 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.820 MB Filas devueltas: 0

SELECT 
  CASE WHEN reviews.ratings IS NULL THEN 0 ELSE reviews.ratings END as ratings, 
  CASE WHEN reviews.count IS NULL THEN 0 ELSE reviews.count END as count

  FROM `b9q1w_splms_lessons` AS `a`

  LEFT JOIN ( SELECT b.course_id, SUM(b.rating) AS ratings, COUNT(b.id) AS count 
  FROM b9q1w_splms_reviews b 
  WHERE b.published = 1 ) AS reviews 
  ON a.course_id = reviews.course_id

  WHERE `published` = 1 
  AND `a`.`teacher_id` = '3'

  GROUP BY a.course_id

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary
1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
2	DERIVED	b	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	2	50.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/teachers.php:109
12	SplmsModelTeachers->getRatings()	JROOT/components/com_splms/models/teachers.php:88
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.826 MB Filas devueltas: 0

SELECT `a`.`status`

  FROM `b9q1w_splms_followers` AS `a`

  WHERE `a`.`teacher` = '4' 
  AND `a`.`student` = '0'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	teacher,student	teacher	8	const	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_splms/models/teachers.php:138
12	SplmsModelTeachers->isFollowing()	JROOT/components/com_splms/models/teachers.php:87
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.32 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.834 MB Filas devueltas: 0

SELECT 
  CASE WHEN reviews.ratings IS NULL THEN 0 ELSE reviews.ratings END as ratings, 
  CASE WHEN reviews.count IS NULL THEN 0 ELSE reviews.count END as count

  FROM `b9q1w_splms_lessons` AS `a`

  LEFT JOIN ( SELECT b.course_id, SUM(b.rating) AS ratings, COUNT(b.id) AS count 
  FROM b9q1w_splms_reviews b 
  WHERE b.published = 1 ) AS reviews 
  ON a.course_id = reviews.course_id

  WHERE `published` = 1 
  AND `a`.`teacher_id` = '4'

  GROUP BY a.course_id

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary
1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
2	DERIVED	b	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	2	50.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/teachers.php:109
12	SplmsModelTeachers->getRatings()	JROOT/components/com_splms/models/teachers.php:88
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.840 MB Filas devueltas: 0

SELECT `a`.`status`

  FROM `b9q1w_splms_followers` AS `a`

  WHERE `a`.`teacher` = '5' 
  AND `a`.`student` = '0'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	teacher,student	teacher	8	const	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_splms/models/teachers.php:138
12	SplmsModelTeachers->isFollowing()	JROOT/components/com_splms/models/teachers.php:87
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.35 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.848 MB Filas devueltas: 0

SELECT 
  CASE WHEN reviews.ratings IS NULL THEN 0 ELSE reviews.ratings END as ratings, 
  CASE WHEN reviews.count IS NULL THEN 0 ELSE reviews.count END as count

  FROM `b9q1w_splms_lessons` AS `a`

  LEFT JOIN ( SELECT b.course_id, SUM(b.rating) AS ratings, COUNT(b.id) AS count 
  FROM b9q1w_splms_reviews b 
  WHERE b.published = 1 ) AS reviews 
  ON a.course_id = reviews.course_id

  WHERE `published` = 1 
  AND `a`.`teacher_id` = '5'

  GROUP BY a.course_id

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary
1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
2	DERIVED	b	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	2	50.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/teachers.php:109
12	SplmsModelTeachers->getRatings()	JROOT/components/com_splms/models/teachers.php:88
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.854 MB Filas devueltas: 0

SELECT `a`.`status`

  FROM `b9q1w_splms_followers` AS `a`

  WHERE `a`.`teacher` = '6' 
  AND `a`.`student` = '0'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	teacher,student	teacher	8	const	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_splms/models/teachers.php:138
12	SplmsModelTeachers->isFollowing()	JROOT/components/com_splms/models/teachers.php:87
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.36 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.862 MB Filas devueltas: 0

SELECT 
  CASE WHEN reviews.ratings IS NULL THEN 0 ELSE reviews.ratings END as ratings, 
  CASE WHEN reviews.count IS NULL THEN 0 ELSE reviews.count END as count

  FROM `b9q1w_splms_lessons` AS `a`

  LEFT JOIN ( SELECT b.course_id, SUM(b.rating) AS ratings, COUNT(b.id) AS count 
  FROM b9q1w_splms_reviews b 
  WHERE b.published = 1 ) AS reviews 
  ON a.course_id = reviews.course_id

  WHERE `published` = 1 
  AND `a`.`teacher_id` = '6'

  GROUP BY a.course_id

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary
1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
2	DERIVED	b	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	2	50.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/teachers.php:109
12	SplmsModelTeachers->getRatings()	JROOT/components/com_splms/models/teachers.php:88
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.868 MB Filas devueltas: 0

SELECT `a`.`status`

  FROM `b9q1w_splms_followers` AS `a`

  WHERE `a`.`teacher` = '7' 
  AND `a`.`student` = '0'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	teacher,student	teacher	8	const	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_splms/models/teachers.php:138
12	SplmsModelTeachers->isFollowing()	JROOT/components/com_splms/models/teachers.php:87
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.36 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.876 MB Filas devueltas: 0

SELECT 
  CASE WHEN reviews.ratings IS NULL THEN 0 ELSE reviews.ratings END as ratings, 
  CASE WHEN reviews.count IS NULL THEN 0 ELSE reviews.count END as count

  FROM `b9q1w_splms_lessons` AS `a`

  LEFT JOIN ( SELECT b.course_id, SUM(b.rating) AS ratings, COUNT(b.id) AS count 
  FROM b9q1w_splms_reviews b 
  WHERE b.published = 1 ) AS reviews 
  ON a.course_id = reviews.course_id

  WHERE `published` = 1 
  AND `a`.`teacher_id` = '7'

  GROUP BY a.course_id

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary
1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
2	DERIVED	b	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	2	50.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/teachers.php:109
12	SplmsModelTeachers->getRatings()	JROOT/components/com_splms/models/teachers.php:88
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.882 MB Filas devueltas: 0

SELECT `a`.`status`

  FROM `b9q1w_splms_followers` AS `a`

  WHERE `a`.`teacher` = '8' 
  AND `a`.`student` = '0'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	teacher,student	teacher	8	const	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_splms/models/teachers.php:138
12	SplmsModelTeachers->isFollowing()	JROOT/components/com_splms/models/teachers.php:87
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.35 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 11.890 MB Filas devueltas: 0

SELECT 
  CASE WHEN reviews.ratings IS NULL THEN 0 ELSE reviews.ratings END as ratings, 
  CASE WHEN reviews.count IS NULL THEN 0 ELSE reviews.count END as count

  FROM `b9q1w_splms_lessons` AS `a`

  LEFT JOIN ( SELECT b.course_id, SUM(b.rating) AS ratings, COUNT(b.id) AS count 
  FROM b9q1w_splms_reviews b 
  WHERE b.published = 1 ) AS reviews 
  ON a.course_id = reviews.course_id

  WHERE `published` = 1 
  AND `a`.`teacher_id` = '8'

  GROUP BY a.course_id

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary
1	PRIMARY	<derived2>	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
2	DERIVED	b	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	2	50.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/teachers.php:109
12	SplmsModelTeachers->getRatings()	JROOT/components/com_splms/models/teachers.php:88
11	SplmsModelTeachers->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:29
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.61 ms Después de la última consulta: 0.88 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 11.990 MB Filas devueltas: 1

SELECT COUNT(*)

  FROM `b9q1w_splms_teachers` AS `a`

  LEFT JOIN ( SELECT b.teacher_id, COUNT(b.course_id) AS count 
  FROM b9q1w_splms_lessons b 
  WHERE b.published = 1 
  GROUP BY b.teacher_id ) AS courses 
  ON a.id = courses.teacher_id

  LEFT JOIN ( SELECT c.teacher_id, COUNT(c.id) AS count 
  FROM b9q1w_splms_lessons c 
  WHERE c.published = 1 
  GROUP BY c.teacher_id ) AS lessons 
  ON a.id = lessons.teacher_id

  LEFT JOIN ( SELECT d.teacher, COUNT(d.id) AS count 
  FROM b9q1w_splms_followers d 
  WHERE d.status = 1 
  GROUP BY d.teacher ) AS followers 
  ON a.id = followers.teacher

  WHERE a.access IN (1,1) 
  AND a.language in ('es-ES','*') 
  AND `a`.`published` = '1'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	8	12.50	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	sitio38_web2020.a.id	2	100.00	Using where
1	PRIMARY	<derived3>	NULL	ref	<auto_key0>	<auto_key0>	4	sitio38_web2020.a.id	2	100.00	Using where
1	PRIMARY	<derived4>	NULL	ref	<auto_key0>	<auto_key0>	8	sitio38_web2020.a.id	2	100.00	Using where
4	DERIVED	d	NULL	index	teacher	teacher	8	NULL	1	100.00	Using where
3	DERIVED	c	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary
2	DERIVED	b	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where; Using temporary

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
12	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
11	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:30
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 11.998 MB Filas devueltas: 8

SELECT DISTINCT(a.specialist_in) AS skills

  FROM `b9q1w_splms_teachers` AS `a`

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/teachers.php:196
11	SplmsModelTeachers->getSkills()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_splms/views/teachers/view.html.php:47
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.22 ms Después de la última consulta: 2.06 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.304 MB Filas devueltas: 1

SELECT `id`,`title`,`alias`,`course_id`,`video_duration`,`created`,`lesson_type`

  FROM `b9q1w_splms_lessons`

  WHERE `published` = 1 
  AND `teacher_id` = '1'

  ORDER BY ordering DESC

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.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/components/com_splms/models/lessons.php:125
10	SplmsModelLessons::getTeacherLessons()	JROOT/components/com_splms/views/teachers/view.html.php:61
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.62 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.313 MB Filas devueltas: 2

Consultas duplicadas: #37

SELECT `id`

  FROM `b9q1w_menu`

  WHERE `link` LIKE '%option=com_splms&view=courses%' 
  AND `client_id` = '0' 
  AND `published` = '1'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b9q1w_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	71	1.11	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_splms/helpers/helper.php:30
11	SplmsHelper::getItemid()	JROOT/components/com_splms/models/lessons.php:128
10	SplmsModelLessons::getTeacherLessons()	JROOT/components/com_splms/views/teachers/view.html.php:61
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 4.09 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.322 MB Filas devueltas: 1

SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`image`,`a`.`course_time`,`a`.`price`,`a`.`sale_price`,`b`.`title` AS `category_name`

  FROM `b9q1w_splms_courses` AS `a`

  LEFT JOIN `b9q1w_splms_coursescategories` AS `b` 
  ON (`a`.`id` = `b`.`id`)

  WHERE `a`.`published` = 1 
  AND `a`.`id` = '2'

  ORDER BY a.ordering DESC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL
1	SIMPLE	b	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_splms/models/courses.php:205
11	SplmsModelCourses::getCourse()	JROOT/components/com_splms/models/lessons.php:129
10	SplmsModelLessons::getTeacherLessons()	JROOT/components/com_splms/views/teachers/view.html.php:61
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.46 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.331 MB Filas devueltas: 2

Consultas duplicadas: #35

SELECT `id`

  FROM `b9q1w_menu`

  WHERE `link` LIKE '%option=com_splms&view=courses%' 
  AND `client_id` = '0' 
  AND `published` = '1'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b9q1w_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	71	1.11	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_splms/helpers/helper.php:30
12	SplmsHelper::getItemid()	JROOT/components/com_splms/models/courses.php:208
11	SplmsModelCourses::getCourse()	JROOT/components/com_splms/models/lessons.php:129
10	SplmsModelLessons::getTeacherLessons()	JROOT/components/com_splms/views/teachers/view.html.php:61
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.32 ms Después de la última consulta: 0.21 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.334 MB Filas devueltas: 0

SELECT `id`,`title`,`alias`,`course_id`,`video_duration`,`created`,`lesson_type`

  FROM `b9q1w_splms_lessons`

  WHERE `published` = 1 
  AND `teacher_id` = '2'

  ORDER BY ordering DESC

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/lessons.php:125
10	SplmsModelLessons::getTeacherLessons()	JROOT/components/com_splms/views/teachers/view.html.php:61
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.344 MB Filas devueltas: 0

SELECT `id`,`title`,`alias`,`course_id`,`video_duration`,`created`,`lesson_type`

  FROM `b9q1w_splms_lessons`

  WHERE `published` = 1 
  AND `teacher_id` = '3'

  ORDER BY ordering DESC

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/lessons.php:125
10	SplmsModelLessons::getTeacherLessons()	JROOT/components/com_splms/views/teachers/view.html.php:61
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.18 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.351 MB Filas devueltas: 0

SELECT `id`,`title`,`alias`,`course_id`,`video_duration`,`created`,`lesson_type`

  FROM `b9q1w_splms_lessons`

  WHERE `published` = 1 
  AND `teacher_id` = '4'

  ORDER BY ordering DESC

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/lessons.php:125
10	SplmsModelLessons::getTeacherLessons()	JROOT/components/com_splms/views/teachers/view.html.php:61
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.359 MB Filas devueltas: 0

SELECT `id`,`title`,`alias`,`course_id`,`video_duration`,`created`,`lesson_type`

  FROM `b9q1w_splms_lessons`

  WHERE `published` = 1 
  AND `teacher_id` = '5'

  ORDER BY ordering DESC

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/lessons.php:125
10	SplmsModelLessons::getTeacherLessons()	JROOT/components/com_splms/views/teachers/view.html.php:61
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.368 MB Filas devueltas: 0

SELECT `id`,`title`,`alias`,`course_id`,`video_duration`,`created`,`lesson_type`

  FROM `b9q1w_splms_lessons`

  WHERE `published` = 1 
  AND `teacher_id` = '6'

  ORDER BY ordering DESC

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_splms/models/lessons.php:125
10	SplmsModelLessons::getTeacherLessons()	JROOT/components/com_splms/views/teachers/view.html.php:61
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.376 MB Filas devueltas: 0

SELECT `id`,`title`,`alias`,`course_id`,`video_duration`,`created`,`lesson_type`

  FROM `b9q1w_splms_lessons`

  WHERE `published` = 1 
  AND `teacher_id` = '7'

  ORDER BY ordering DESC

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.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/components/com_splms/models/lessons.php:125
10	SplmsModelLessons::getTeacherLessons()	JROOT/components/com_splms/views/teachers/view.html.php:61
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 12.385 MB Filas devueltas: 0

SELECT `id`,`title`,`alias`,`course_id`,`video_duration`,`created`,`lesson_type`

  FROM `b9q1w_splms_lessons`

  WHERE `published` = 1 
  AND `teacher_id` = '8'

  ORDER BY ordering DESC

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.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/components/com_splms/models/lessons.php:125
10	SplmsModelLessons::getTeacherLessons()	JROOT/components/com_splms/views/teachers/view.html.php:61
9	SplmsViewTeachers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_splms/splms.php:44
6	require_once JROOT/components/com_splms/splms.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 2.55 ms Después de la última consulta: 22.01 ms Consulta a la memoria: 0.043 MB memoria antes de la consulta: 14.811 MB Filas devueltas: 23

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM b9q1w_modules AS m

  LEFT JOIN b9q1w_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN b9q1w_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-18 18:17:06') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-18 18:17:06') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 548 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicar

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

Perfil

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

Llamada de pila

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

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

Tiempo de la consulta: 1.48 ms Después de la última consulta: 4.05 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 14.952 MB Filas devueltas: 41

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `b9q1w_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_speasyimagegallery','com_splms','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
12	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
11	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
10	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
9	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
8	Joomla\CMS\User\User->authorise()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:43
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.23 ms Después de la última consulta: 8.62 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 15.413 MB Filas devueltas: 1

Consultas duplicadas: #11 #48 #49 #50 #51 #52

SELECT *

  FROM `b9q1w_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '13'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b9q1w_template_styles	NULL	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
14	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
13	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:390
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.18 ms Después de la última consulta: 1.52 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 15.658 MB Filas devueltas: 1

Consultas duplicadas: #11 #47 #49 #50 #51 #52

SELECT *

  FROM `b9q1w_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '13'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b9q1w_template_styles	NULL	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
15	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
14	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:119
13	HelixUltimate\Framework\Core\HelixUltimate->__construct()	JROOT/plugins/system/helixultimate/helixultimate.php:402
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 15.692 MB Filas devueltas: 1

Consultas duplicadas: #11 #47 #48 #50 #51 #52

SELECT *

  FROM `b9q1w_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '13'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b9q1w_template_styles	NULL	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1989
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:148
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:425
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 15.700 MB Filas devueltas: 1

Consultas duplicadas: #11 #47 #48 #49 #51 #52

SELECT *

  FROM `b9q1w_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '13'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b9q1w_template_styles	NULL	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1989
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:148
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:426
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 15.708 MB Filas devueltas: 1

Consultas duplicadas: #11 #47 #48 #49 #50 #52

SELECT *

  FROM `b9q1w_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '13'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b9q1w_template_styles	NULL	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1989
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:148
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:427
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.23 ms Después de la última consulta: 0.75 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 15.722 MB Filas devueltas: 1

Consultas duplicadas: #11 #47 #48 #49 #50 #51

SELECT *

  FROM `b9q1w_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '13'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b9q1w_template_styles	NULL	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
9	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
8	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:563
7	PlgSystemHelixultimate->onAfterRender()	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/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.90 ms Después de la última consulta: 3.67 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 16.299 MB Filas devueltas: 132

SELECT * 
  FROM b9q1w_acymailing_config

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:464
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:803
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->onAfterRender()	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/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

24 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

8 × SELECT `a`.`status` 
  FROM `b9q1w_splms_followers` AS `a`

8 × SELECT 
  CASE WHEN reviews.ratings IS NULL THEN 0 ELSE reviews.ratings END as ratings, 
  CASE WHEN reviews.count IS NULL THEN 0 ELSE reviews.count END as count 
  FROM `b9q1w_splms_lessons` AS `a` 
  LEFT JOIN ( SELECT b.course_id, SUM(b.rating) AS ratings, COUNT(b.id) AS count 
  FROM b9q1w_splms_reviews b

8 × SELECT `id`,`title`,`alias`,`course_id`,`video_duration`,`created`,`lesson_type` 
  FROM `b9q1w_splms_lessons`

7 × SELECT * 
  FROM `b9q1w_template_styles`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `b9q1w_extensions`

```
2 × SELECT `id` 
  FROM `b9q1w_menu`
```

1 × SELECT `session_id` 
  FROM `b9q1w_session`

1 × SELECT id, rules 
  FROM `b9q1w_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM b9q1w_extensions

1 × SELECT `template` 
  FROM `b9q1w_template_styles`

1 × SELECT * 
  FROM b9q1w_rsform_confi

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM b9q1w_menu AS m 
  LEFT JOIN b9q1w_extensions AS e 
  ON m.component_id = e.extension_id

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

```
1 × SELECT * 
  FROM b9q1w_languages
```

1 × SELECT a.*,
  CASE WHEN courses.count IS NULL THEN 0 ELSE courses.count END as courses,
  CASE WHEN lessons.count IS NULL THEN 0 ELSE lessons.count END as lessons,
  CASE WHEN followers.count IS NULL THEN 0 ELSE followers.count END as followers 
  FROM `b9q1w_splms_teachers` AS `a` 
  LEFT JOIN ( SELECT b.teacher_id, COUNT(b.course_id) AS count 
  FROM b9q1w_splms_lessons b

1 × SELECT COUNT(*) 
  FROM `b9q1w_splms_teachers` AS `a` 
  LEFT JOIN ( SELECT b.teacher_id, COUNT(b.course_id) AS count 
  FROM b9q1w_splms_lessons b

1 × SELECT DISTINCT(a.specialist_in) AS skills 
  FROM `b9q1w_splms_teachers` AS `a

1 × SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`image`,`a`.`course_time`,`a`.`price`,`a`.`sale_price`,`b`.`title` AS `category_name` 
  FROM `b9q1w_splms_courses` AS `a` 
  LEFT JOIN `b9q1w_splms_coursescategories` AS `b` 
  ON (`a`.`id` = `b`.`id`)

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM b9q1w_modules AS m 
  LEFT JOIN b9q1w_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN b9q1w_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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

1 × SELECT * 
  FROM b9q1w_acymailing_confi

OTRAS tablas:

1 × INSERT INTO `b9q1w_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6230633563633536323262376532623662626364373766653533323037383333', 1, 1731953826, 0, '', 0

1 × UPDATE `b9q1w_extensions` 
  SET `params` = '{\"mediaversion\":\"8fca49ff42da9c849a61d1a8c5674884\"}'

Teachers

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliquaenim ad minim veniam

Search

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

53 consultas registradas 41.80 ms

¡ 9 duplicaciones detectadas!

24 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: