Servicios de construcción y mantenimiento de azoteas o techos verdes en Coyoacán, CDMX.

Consola de depuración de Joomla!

Sesión

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_session	const	PRIMARY	PRIMARY	194	const	1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_session	const	PRIMARY	PRIMARY	194	const	1	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 `seraku52_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3437656465373366643233646232353964336566356561643032633035613363', 1, 1714563883, 0, '', 0)

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.01 ms
Update	0.18 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.66 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

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

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

Tiempo de la consulta: 1.18 ms Después de la última consulta: 2.89 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 4.434 MB Filas devueltas: 52

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

  FROM `seraku52_extensions`

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_extensions	ref	extension	extension	82	const	52	Using index condition; Using where

Perfil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.16 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.64 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.04 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

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

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

Tiempo de la consulta: 0.39 ms Después de la última consulta: 2.98 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.701 MB Filas devueltas: 3

SELECT id, rules

  FROM `seraku52_viewlevels`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_viewlevels	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	3

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

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

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

Tiempo de la consulta: 0.48 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.713 MB Filas devueltas: 1

SELECT b.id

  FROM seraku52_usergroups AS a

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

  WHERE a.id = 1

Explicar

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

Perfil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 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: 1.59 ms Después de la última consulta: 0.80 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.781 MB Filas devueltas: 112

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

  FROM seraku52_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_extensions	ref	extension	extension	82	const	148	Using index condition; Using where; Usando 'filesort'

Perfil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	1.13 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.03 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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: 0.14 ms Después de la última consulta: 16.84 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 6.424 MB


  SET SQL_BIG_SELECTS=1

Explicar

'Explicar' no es posible en la consulta: SET SQL_BIG_SELECTS=1

Perfil

Status	Duration
Starting	0.03 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/jomcomdev/jomcomdev.php:50
7	plgSystemJomcomdev->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.47 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 6.465 MB Filas devueltas: 1

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

  FROM `seraku52_extensions`

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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/libraries/src/Helper/LibraryHelper.php:167
16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Lo mismo que llamada de la línea de abajo.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomcomdev/jomcomdev.php:52
7	plgSystemJomcomdev->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.79 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 6.458 MB

UPDATE `seraku52_extensions`

  SET `params` = '{\"mediaversion\":\"7e6e1d61cc20f68c4aa8accb29d0f93f\"}'

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

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.07 ms
Updating	0.10 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.44 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomcomdev/jomcomdev.php:52
7	plgSystemJomcomdev->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.54 ms Después de la última consulta: 12.75 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 7.247 MB Filas devueltas: 1

Consultas duplicadas: #12

SELECT template

  FROM seraku52_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	9	Using where

Perfil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.15 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	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/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.34 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 7.254 MB Filas devueltas: 1

Consultas duplicadas: #11

SELECT template

  FROM seraku52_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	9	Using where

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.36 ms Después de la última consulta: 4.02 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 7.498 MB Filas devueltas: 4

SELECT extension, file, type

  FROM seraku52_rokcommon_configs

  ORDER BY priority

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_rokcommon_configs	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	4	Usando 'filesort'

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

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

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

Tiempo de la consulta: 1.28 ms Después de la última consulta: 25.76 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 8.795 MB Filas devueltas: 18

SHOW FULL COLUMNS 
  FROM `seraku52_extensions`

Explicar

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

Perfil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.40 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.18 ms
Closing tables	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Removing tmp table	0.20 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 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/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->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.76 ms Después de la última consulta: 0.75 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 8.845 MB Filas devueltas: 1

SELECT `extension_id`

  FROM `seraku52_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

Perfil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.05 ms
Statistics	0.16 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->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.60 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 8.852 MB Filas devueltas: 1

Consultas duplicadas: #18

SELECT *

  FROM seraku52_extensions

  WHERE `extension_id` = '10007'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_extensions	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->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.65 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 8.858 MB Filas devueltas: 1

SELECT `extension_id`

  FROM `seraku52_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

Perfil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->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.57 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 8.864 MB Filas devueltas: 1

Consultas duplicadas: #16

SELECT *

  FROM seraku52_extensions

  WHERE `extension_id` = '10007'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_extensions	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->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: 3.92 ms Después de la última consulta: 24.42 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 9.451 MB Filas devueltas: 137

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 seraku52_menu AS m

  LEFT JOIN seraku52_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	265	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.m.component_id	1	Using where

Perfil

Status	Duration
Starting	0.11 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	3.27 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	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: 7.37 ms Después de la última consulta: 20.15 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 11.095 MB Filas devueltas: 1

Consultas duplicadas: #25

SELECT a.*, b.title AS categoryTitle, c.email AS userEmail

  FROM seraku52_cddir_content AS a

  INNER JOIN seraku52_cddir_categories AS b 
  ON a.categories_id = b.id

  LEFT JOIN seraku52_users AS c 
  ON a.users_id = c.id

  WHERE a.alias = 'servicios-de-construccion-y-mantenimiento-de-azoteas-o-techos-verdes-en-coyoacan-cdmx' 
  AND a.published = 1 
  AND a.access IN (1,1) 
  AND b.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	fk_aku86q5_cddir_content_k86q5_categories	No pudo usarse una clave de índice	NULL	NULL	627	Using where
1	SIMPLE	b	eq_ref	PRIMARY,idx_access	PRIMARY	4	zoemcomm_servicios1.a.categories_id	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.users_id	1	Using where

Perfil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	2.10 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	4.68 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	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_jomdirectory/models/item.php:361
11	JomdirectoryModelItem->getItem()	JROOT/components/com_jomdirectory/router.php:89
10	jomdirectoryParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.72 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 11.099 MB Filas devueltas: 9

SELECT id, home, template, s.params

  FROM seraku52_template_styles as s

  LEFT JOIN seraku52_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	9
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	zoemcomm_servicios1.s.template,const	1	Using index condition; Using where

Perfil

Status	Duration
Starting	0.09 ms
Checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.03 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:257
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:108
8	plgSystemGantry5->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.58 ms Después de la última consulta: 21.38 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 13.182 MB Filas devueltas: 1

SELECT s.id, s.template, s.home, s.title AS long_title, s.params

  FROM seraku52_template_styles AS s

  WHERE s.client_id = 0 
  AND s.template = 'g5_myriad'

  ORDER BY s.id

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	const	1	Using index condition; Using where

Perfil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69
14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63
13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301
12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99
11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86
10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:315
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:108
8	plgSystemGantry5->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.33 ms Después de la última consulta: 5.33 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 13.739 MB Filas devueltas: 9

SELECT * 
  FROM seraku52_rokcandy 
  WHERE published=1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_rokcandy	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	9	Using where

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

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

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

Tiempo de la consulta: 0.40 ms Después de la última consulta: 0.52 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 13.764 MB Filas devueltas: 1

SELECT *

  FROM seraku52_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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: 2.83 ms Después de la última consulta: 8.61 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 14.259 MB Filas devueltas: 1

Consultas duplicadas: #20

SELECT a.*, b.title AS categoryTitle, c.email AS userEmail

  FROM seraku52_cddir_content AS a

  INNER JOIN seraku52_cddir_categories AS b 
  ON a.categories_id = b.id

  LEFT JOIN seraku52_users AS c 
  ON a.users_id = c.id

  WHERE a.alias = 'servicios-de-construccion-y-mantenimiento-de-azoteas-o-techos-verdes-en-coyoacan-cdmx' 
  AND a.published = 1 
  AND a.access IN (1,1) 
  AND b.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	fk_aku86q5_cddir_content_k86q5_categories	No pudo usarse una clave de índice	NULL	NULL	627	Using where
1	SIMPLE	b	eq_ref	PRIMARY,idx_access	PRIMARY	4	zoemcomm_servicios1.a.categories_id	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.users_id	1	Using where

Perfil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.08 ms
Optimizing	0.06 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	2.23 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.03 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_jomdirectory/models/item.php:361
12	JomdirectoryModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/item/view.html.php:43
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 1.02 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 14.274 MB Filas devueltas: 0

SELECT a.*, IF(a.user_id > 0, b.name, a.username) AS username 

  FROM seraku52_cddir_reviews AS a

  LEFT JOIN seraku52_users AS b 
  ON b.id=a.user_id

  WHERE a.content_id = '644' 
  AND a.extension = "com_jomdirectory" 
  AND a.published = 1 
  AND a.approved = 1

  ORDER BY a.id DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	content_id	content_id	4	const	1	Using where
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.user_id	1	Using where

Perfil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.60 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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_jomdirectory/models/item.php:235
11	JomdirectoryModelItem->getReviews()	JROOT/components/com_jomdirectory/views/item/view.html.php:51
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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.37 ms Después de la última consulta: 14.78 ms Consulta a la memoria: 0.011 MB memoria antes de la consulta: 15.121 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM seraku52_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_jomdirectory.item.reviews.data' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

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

Perfil

Status	Duration
Starting	0.11 ms
Checking permissions	0.01 ms
Opening tables	1.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.19 ms
Preparing	0.05 ms
Creating tmp table	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.39 ms
Creating sort index	0.03 ms
Removing tmp table	0.10 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_jomdirectory/models/item.php:97
13	JomdirectoryModelItem->loadForm()	JROOT/components/com_jomdirectory/models/item.php:46
12	JomdirectoryModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/item/view.html.php:52
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 1.11 ms Después de la última consulta: 3.32 ms Consulta a la memoria: 0.011 MB memoria antes de la consulta: 15.135 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM seraku52_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_jomdirectory.item.tellafriend.data' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

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

Perfil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.33 ms
Creating sort index	0.05 ms
Removing tmp table	0.11 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_jomdirectory/models/item.php:97
13	JomdirectoryModelItem->loadForm()	JROOT/components/com_jomdirectory/models/item.php:129
12	JomdirectoryModelItem->getFormTellAFriend()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/item/view.html.php:53
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 1.04 ms Después de la última consulta: 2.80 ms Consulta a la memoria: 0.011 MB memoria antes de la consulta: 15.148 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM seraku52_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_jomdirectory.item.contact.data' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

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

Perfil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.32 ms
Creating sort index	0.03 ms
Removing tmp table	0.10 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_jomdirectory/models/item.php:97
13	JomdirectoryModelItem->loadForm()	JROOT/components/com_jomdirectory/models/item.php:141
12	JomdirectoryModelItem->getFormContact()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/item/view.html.php:54
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 1.38 ms Después de la última consulta: 1.54 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.223 MB Filas devueltas: 0

SELECT this.*

  FROM seraku52_cddir_connections AS a

  INNER JOIN seraku52_content AS this 
  ON a.com_content_article_id = this.id

  WHERE a.directory_id = '644' 
  AND a.extension = 'com_jomdirectory'

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	directory_id	directory_id	4	const	1	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	this	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.com_content_article_id	1

Perfil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.78 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.13 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	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_jomdirectory/models/item.php:171
11	JomdirectoryModelItem->getArticle()	JROOT/components/com_jomdirectory/views/item/view.html.php:56
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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.66 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.228 MB Filas devueltas: 0

SELECT a.*

  FROM seraku52_cddir_service AS a

  WHERE a.items_id = '644'

  ORDER BY a.title ASC

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.33 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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_jomdirectory/models/item.php:188
11	JomdirectoryModelItem->getService()	JROOT/components/com_jomdirectory/views/item/view.html.php:59
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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.70 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.234 MB Filas devueltas: 0

SELECT id 

  FROM seraku52_cddir_calendar 

  WHERE content_id = '644' 
  AND extension = "com_jomdirectory"

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_cddir_calendar	ref	content_id	content_id	4	const	1	Using where

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.37 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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_jomdirectory/models/item.php:320
11	JomdirectoryModelItem->getCalendar()	JROOT/components/com_jomdirectory/views/item/view.html.php:60
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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.78 ms Después de la última consulta: 0.55 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.271 MB Filas devueltas: 0

SELECT a.*, b.title AS typeTitle, b.alias AS typeAlias

  FROM seraku52_cddir_file AS a

  INNER JOIN seraku52_cddir_categories AS b 
  ON b.id = a.type_id

  WHERE a.extension = 'com_jomdirectory' 
  AND a.content_id = 644

  ORDER BY a.ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	content_id	content_id	4	const	1	Using where; Usando 'filesort'
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.type_id	1

Perfil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.34 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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_jomcomdev/libraries/Main/File.php:35
11	Main_File::get()	JROOT/components/com_jomdirectory/views/item/view.html.php:63
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 3.07 ms Después de la última consulta: 2.89 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.459 MB Filas devueltas: 2

SELECT c.*, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM seraku52_cddir_categories as c

  LEFT JOIN seraku52_cddir_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM seraku52_cddir_categories AS cat JOIN seraku52_cddir_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_jomdirectory.jomdirectory' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_jomdirectory.jomdirectory' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=197 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
 			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
		 	c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
 			c.path, c.published, c.rgt, c.title, c.modified_user_id

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Usando 'filesort'
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	157	NULL	13	Using index condition; Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	zoemcomm_servicios1.c.id	2	Using where
2	LATERAL DERIVED	cat	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	zoemcomm_servicios1.c.id	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152	const	80	Using index condition; Using where

Perfil

Status	Duration
Starting	0.17 ms
Checking permissions	0.01 ms
Opening tables	0.18 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.11 ms
Optimizing	0.04 ms
Optimizing	0.01 ms
Statistics	0.08 ms
Statistics	0.17 ms
Preparing	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.10 ms
Executing	0.01 ms
Sending data	1.05 ms
Executing	0.01 ms
Sending data	0.54 ms
Creating sort index	0.07 ms
Removing tmp table	0.15 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jomcomdev/libraries/Joomla/Application/Categories.php:121
13	Joomla_Application_Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
12	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jomcomdev/libraries/Main/FieldsSite.php:135
11	Main_FieldsSite->getFields()	JROOT/components/com_jomdirectory/views/item/view.html.php:68
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 1.11 ms Después de la última consulta: 0.71 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.500 MB Filas devueltas: 3

SELECT a.*,b.title AS type_title,c.title AS type_value,d.title AS type_group, d.id AS type_id

  FROM seraku52_cddir_fields AS a

  INNER JOIN seraku52_cddir_categories AS b 
  ON b.id = a.categories_type_id

  INNER JOIN seraku52_cddir_categories AS c 
  ON c.id = a.categories_value_id

  INNER JOIN seraku52_cddir_categories AS d 
  ON d.id = a.categories_group_id

  LEFT JOIN seraku52_cddir_categories AS e 
  ON e.id = a.categories_id

  WHERE a.published = 1 
  AND a.extension = 'com_jomdirectory' 
  AND (a.categories_id IN (197) OR a.categories_id IS NULL)  
  AND a.language in ('es-ES','*')

  ORDER BY d.id,a.ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	fk_aku86q5_cddir_fields_k86q5_cddir_categories1,fk_aku86q5_cddir_fields_k86q5_cddir_categories2,fk_aku86q5_cddir_fields_k86q5_cddir_categories3,categories_id	No pudo usarse una clave de índice	NULL	NULL	4	Using where; Usando 'filesort'
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.categories_type_id	1
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.categories_value_id	1
1	SIMPLE	d	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.categories_group_id	1

Perfil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.46 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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_jomcomdev/libraries/Main/FieldsSite.php:156
11	Main_FieldsSite->getFields()	JROOT/components/com_jomdirectory/views/item/view.html.php:68
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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.11 ms Después de la última consulta: 1.12 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.561 MB


  SET SESSION group_concat_max_len = 10000000

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_jomcomdev/libraries/Main/FieldsSite.php:777
12	Main_FieldsSite->getValues()	JROOT/components/com_jomcomdev/libraries/Main/FieldsSite.php:166
11	Main_FieldsSite->getFields()	JROOT/components/com_jomdirectory/views/item/view.html.php:68
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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.11 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.569 MB Filas devueltas: 3

SELECT GROUP_CONCAT(DISTINCT a.value_string SEPARATOR ',') AS value_string, GROUP_CONCAT(DISTINCT a.value_int SEPARATOR ',') AS value_int , a.value_decimal, a.fields_id,  a.content_id

  FROM seraku52_cddir_content_has_fields AS a

  WHERE a.fields_id  IN (1,2,3) 
  AND a.content_id = 644

  GROUP BY a.fields_id

Explicar

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

Perfil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.29 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.01 ms
Preparing	0.24 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	1.05 ms
End of update loop	0.01 ms
Removing tmp table	0.10 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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_jomcomdev/libraries/Main/FieldsSite.php:797
12	Main_FieldsSite->getValues()	JROOT/components/com_jomcomdev/libraries/Main/FieldsSite.php:166
11	Main_FieldsSite->getFields()	JROOT/components/com_jomdirectory/views/item/view.html.php:68
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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.97 ms Después de la última consulta: 0.57 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.588 MB Filas devueltas: 4

SELECT c.*, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM seraku52_cddir_categories as c

  LEFT JOIN seraku52_cddir_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM seraku52_cddir_categories AS cat JOIN seraku52_cddir_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_jomcomdev.address' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_jomcomdev.address' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=236 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
 			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
		 	c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
 			c.path, c.published, c.rgt, c.title, c.modified_user_id

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Usando 'filesort'
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	No pudo usarse una clave de índice	NULL	NULL	239	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	zoemcomm_servicios1.c.id	11	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	14	Using index condition; Using temporary; Usando 'filesort'
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	239	Using where; Using index; Using join buffer (flat, BNL join)

Perfil

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.10 ms
Optimizing	0.08 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Statistics	0.15 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.74 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.99 ms
Creating sort index	0.08 ms
Removing tmp table	0.13 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jomcomdev/libraries/Joomla/Application/Categories.php:121
13	Joomla_Application_Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
12	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jomcomdev/libraries/Main/Address.php:45
11	Main_Address->getAddress()	JROOT/components/com_jomdirectory/views/item/view.html.php:73
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 1.21 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.614 MB Filas devueltas: 15

SELECT a.*, b.alias

  FROM seraku52_cddir_images AS a

  LEFT JOIN seraku52_cddir_categories AS b 
  ON b.id=a.categories_id

  WHERE `content_id` = 644 
  AND `a`.`extension` = 'com_jomdirectory' 

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	fk_aku86q5_cddir_images_k86q5_cddir_content1	fk_aku86q5_cddir_images_k86q5_cddir_content1	5	const	15	Using where; Usando 'filesort'
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.categories_id	1	Using where

Perfil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.54 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.24 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	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_jomcomdev/libraries/Main/Image/DbAdapter/Joomla.php:48
12	Main_Image_DbAdapter_Joomla->getImagesInContent()	JROOT/components/com_jomcomdev/libraries/Main/Image.php:51
11	Main_Image->__call()	JROOT/components/com_jomdirectory/views/item/view.html.php:79
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 9.15 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.694 MB Filas devueltas: 0

SELECT a.*, b.alias

  FROM seraku52_cddir_images AS a

  LEFT JOIN seraku52_cddir_categories AS b 
  ON b.id=a.categories_id

  WHERE `users_id` = 615 
  AND `a`.`extension` = '' 

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	13400	Using where; Usando 'filesort'
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.categories_id	1	Using where

Perfil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	8.75 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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_jomcomdev/libraries/Main/Image/DbAdapter/Joomla.php:46
12	Main_Image_DbAdapter_Joomla->getImagesInContent()	JROOT/components/com_jomcomdev/libraries/Main/Image.php:51
11	Main_Image->__call()	JROOT/components/com_jomdirectory/views/item/view.html.php:106
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 1.55 ms Después de la última consulta: 4.67 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 16.055 MB Filas devueltas: 0

SELECT a.id AS id, a.title AS title, a.alias, a.users_id, a.featured, a.introtext, a.price, a.company_id, a.price_old, c.id AS categoryId, c.title AS categoryTitle, c.alias AS categoryAlias, d.view_item

  FROM `seraku52_cddir_products` AS a

  LEFT JOIN seraku52_cddir_categories AS c 
  ON c.id = a.categories_id

  LEFT JOIN seraku52_cddir_statistic AS d 
  ON (d.item_id = a.id 
  AND d.extension='com_jomdirectory.products')

  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.language in ('es-ES','*') 
  AND a.company_id =644

  GROUP BY a.id

  ORDER BY a.date_publish DESC 
  LIMIT 1000

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	company_id	company_id	5	const	1	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.categories_id	1
1	SIMPLE	d	ref	item_id	item_id	4	zoemcomm_servicios1.a.id	29	Using where

Perfil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.54 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting for group	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.31 ms
Creating sort index	0.03 ms
Removing tmp table	0.13 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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_jomdirectory/models/products.php:506
11	JomdirectoryModelProducts->getItemsForModule()	JROOT/components/com_jomdirectory/views/item/view.html.php:113
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 1.16 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 16.058 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM seraku52_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_jomdirectory.item' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

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

Perfil

Status	Duration
Starting	0.11 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.36 ms
Creating sort index	0.03 ms
Removing tmp table	0.10 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_jomdirectory/views/item/view.html.php:147
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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.76 ms Después de la última consulta: 2.55 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 16.269 MB Filas devueltas: 8

SHOW FULL COLUMNS 
  FROM `seraku52_cddir_statistic`

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.26 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
Checking permissions	0.07 ms
Closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Removing tmp table	0.12 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jomcomdev/tables/statistic.php:29
12	JomcomdevTableStatistic->__construct()	JROOT/libraries/src/Table/Table.php:328
11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jomdirectory/views/item/view.html.php:179
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 1.34 ms Después de la última consulta: 0.28 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 16.293 MB Filas devueltas: 1

SELECT *

  FROM seraku52_cddir_statistic

  WHERE `item_id` = '644' 
  AND `extension` = 'com_jomdirectory' 
  AND `date_year` = '2024' 
  AND `date_month` = '05'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_cddir_statistic	ref	item_id	item_id	4	const	46	Using where

Perfil

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.97 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jomcomdev/tables/statistic.php:54
11	JomcomdevTableStatistic->addViewItemStats()	JROOT/components/com_jomdirectory/views/item/view.html.php:180
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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.82 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 16.299 MB

UPDATE `seraku52_cddir_statistic` 
  SET `item_id`='644',`view_in_list`='1',`view_item`='1',`add_favorite`='0',`date_year`='2024',`date_month`='5',`extension`='com_jomdirectory' 
  WHERE `id` = '47219'

Explicar

'Explicar' no es posible en la consulta: UPDATE `seraku52_cddir_statistic` SET `item_id`='644',`view_in_list`='1',`view_item`='1',`add_favorite`='0',`date_year`='2024',`date_month`='5',`extension`='com_jomdirectory' WHERE `id` = '47219'

Perfil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.04 ms
Updating	0.09 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.50 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
14	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
13	Joomla\CMS\Table\Table->store()	JROOT/libraries/src/Table/Table.php:933
12	Joomla\CMS\Table\Table->save()	JROOT/administrator/components/com_jomcomdev/tables/statistic.php:64
11	JomcomdevTableStatistic->addViewItemStats()	JROOT/components/com_jomdirectory/views/item/view.html.php:180
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 5.53 ms Después de la última consulta: 2.03 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 16.435 MB Filas devueltas: 8

SELECT `m`.`tag_id`,`t`.*

  FROM `seraku52_contentitem_tag_map` AS m 

  INNER JOIN `seraku52_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_jomdirectory.content' 
  AND `m`.`content_item_id` = 644 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	No pudo usarse una clave de índice	NULL	NULL	401	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	zoemcomm_servicios1.t.id	8	Using index condition; Using where

Perfil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	1.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	3.96 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	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/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_jomdirectory/views/item/view.html.php:202
10	JomdirectoryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jomdirectory/controller.php:50
8	JomdirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jomdirectory/jomdirectory.php:64
6	require_once JROOT/components/com_jomdirectory/jomdirectory.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: 3.49 ms Después de la última consulta: 2911.93 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 55.552 MB Filas devueltas: 5

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

  FROM seraku52_modules AS m

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

  LEFT JOIN seraku52_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-05-01 11:44:46') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-01 11:44:46') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 329 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	21	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	zoemcomm_servicios1.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.m.id	1	Using where; Using index

Perfil

Status	Duration
Starting	0.18 ms
Checking permissions	0.01 ms
Opening tables	1.57 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.07 ms
Optimizing	0.07 ms
Statistics	0.16 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.00 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	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()	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/ModuleHelper.php:441
10	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
9	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
8	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45
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: 1.22 ms Después de la última consulta: 2.40 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 55.640 MB Filas devueltas: 8

SHOW FULL COLUMNS 
  FROM `seraku52_template_styles`

Explicar

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

Perfil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.41 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.11 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.15 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->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.48 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 55.664 MB Filas devueltas: 1

SELECT *

  FROM seraku52_template_styles

  WHERE `id` = '15'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_template_styles	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.15 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->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.94 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 55.718 MB Filas devueltas: 1

SELECT `value`

  FROM `seraku52_extrawatch_settings`

  WHERE `key` = 'extrawatch-projectId' 
  LIMIT 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_extrawatch_settings	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	4	Using where

Perfil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.58 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_extrawatch/ew-plg-common/cms/ExtraWatchJoomlaSpecific.php:74
15	ExtraWatchJoomlaSpecific->getValue()	JROOT/administrator/components/com_extrawatch/ew-plg-common/cms/ExtraWatchJoomlaSpecific.php:41
14	ExtraWatchJoomlaSpecific->getPluginOptionProjectId()	JROOT/plugins/system/extrawatch_agent/extrawatch_agent.php:74
13	plgSystemExtraWatch_Agent->findProjectId()	JROOT/plugins/system/extrawatch_agent/extrawatch_agent.php:45
12	plgSystemExtraWatch_Agent->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: 1.85 ms Después de la última consulta: 4.27 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 55.901 MB Filas devueltas: 50

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

  FROM `seraku52_assets`

  WHERE `name` IN ('root.1','com_aclmanager','com_actionlogs','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_extplorer','com_extrawatch','com_fields','com_finder','com_gantry','com_gantry5','com_installer','com_jce','com_jevents','com_jomcomdev','com_jomdirectory','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_rokgallery','com_roksprocket','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	seraku52_assets	range	idx_asset_name	idx_asset_name	202	NULL	50	Using index condition

Perfil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.12 ms
Optimizing	0.02 ms
Statistics	0.22 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	1.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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/plugins/system/aclmanager/aclmanager.php:121
7	plgSystemAclmanager->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.]

41 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

4 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM seraku52_fields AS a 
  LEFT JOIN `seraku52_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN seraku52_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN seraku52_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN seraku52_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN seraku52_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT * 
  FROM seraku52_extensions

2 × SELECT a.*, b.title AS categoryTitle, c.email AS userEmail 
  FROM seraku52_cddir_content AS a 
  INNER JOIN seraku52_cddir_categories AS b 
  ON a.categories_id = b.id 
  LEFT JOIN seraku52_users AS c 
  ON a.users_id = c.id

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

2 × SELECT c.*, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM seraku52_cddir_categories as c 
  LEFT JOIN seraku52_cddir_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM seraku52_cddir_categories AS cat JOIN seraku52_cddir_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT template 
  FROM seraku52_template_styles as s

2 × SELECT `extension_id` 
  FROM `seraku52_extensions`

2 × SELECT a.*, b.alias 
  FROM seraku52_cddir_images AS a 
  LEFT JOIN seraku52_cddir_categories AS b 
  ON b.id=a.categories_id

1 × SELECT a.*,b.title AS type_title,c.title AS type_value,d.title AS type_group, d.id AS type_id 
  FROM seraku52_cddir_fields AS a 
  INNER JOIN seraku52_cddir_categories AS b 
  ON b.id = a.categories_type_id 
  INNER JOIN seraku52_cddir_categories AS c 
  ON c.id = a.categories_value_id 
  INNER JOIN seraku52_cddir_categories AS d 
  ON d.id = a.categories_group_id 
  LEFT JOIN seraku52_cddir_categories AS e 
  ON e.id = a.categories_id

1 × SELECT GROUP_CONCAT(DISTINCT a.value_string SEPARATOR ',') AS value_string, GROUP_CONCAT(DISTINCT a.value_int SEPARATOR ',') AS value_int , a.value_decimal, a.fields_id,  a.content_id 
  FROM seraku52_cddir_content_has_fields AS a

1 × SELECT a.id AS id, a.title AS title, a.alias, a.users_id, a.featured, a.introtext, a.price, a.company_id, a.price_old, c.id AS categoryId, c.title AS categoryTitle, c.alias AS categoryAlias, d.view_item 
  FROM `seraku52_cddir_products` AS a 
  LEFT JOIN seraku52_cddir_categories AS c 
  ON c.id = a.categories_id 
  LEFT JOIN seraku52_cddir_statistic AS d 
  ON (d.item_id = a.id 
  AND d.extension='com_jomdirectory.products')

1 × SELECT `data` 
  FROM `seraku52_session`

1 × SELECT * 
  FROM seraku52_cddir_statistic

1 × SELECT id  
  FROM seraku52_cddir_calendar

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `seraku52_contentitem_tag_map` AS m  
  INNER JOIN `seraku52_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

1 × SELECT * 
  FROM seraku52_template_styles

1 × SELECT `value` 
  FROM `seraku52_extrawatch_settings`

1 × SELECT a.*, b.title AS typeTitle, b.alias AS typeAlias 
  FROM seraku52_cddir_file AS a 
  INNER JOIN seraku52_cddir_categories AS b 
  ON b.id = a.type_id

1 × SELECT a.*, IF(a.user_id > 0, b.name, a.username) AS username  
  FROM seraku52_cddir_reviews AS a 
  LEFT JOIN seraku52_users AS b 
  ON b.id=a.user_id

1 × SELECT a.* 
  FROM seraku52_cddir_service AS a

1 × SELECT this.* 
  FROM seraku52_cddir_connections AS a 
  INNER JOIN seraku52_content AS this 
  ON a.com_content_article_id = this.id

1 × SELECT `session_id` 
  FROM `seraku52_session`

1 × SELECT * 
  FROM seraku52_languages

1 × SELECT * 
  FROM seraku52_rokcandy

1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params 
  FROM seraku52_template_styles AS s

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

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 seraku52_menu AS m 
  LEFT JOIN seraku52_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT extension, file, type 
  FROM seraku52_rokcommon_configs

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

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

1 × SELECT id, rules 
  FROM `seraku52_viewlevels

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

OTRAS tablas:

1 × INSERT INTO `seraku52_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3437656465373366643233646232353964336566356561643032633035613363', 1, 1714563883, 0, '', 0

```
1 × 
  SET SQL_BIG_SELECTS=
```

1 × UPDATE `seraku52_extensions` 
  SET `params` = '{\"mediaversion\":\"7e6e1d61cc20f68c4aa8accb29d0f93f\"}'

1 × SHOW FULL COLUMNS 
  FROM `seraku52_extensions

1 × 
  SET SESSION group_concat_max_len = 1000000

1 × SHOW FULL COLUMNS 
  FROM `seraku52_cddir_statistic

1 × UPDATE `seraku52_cddir_statistic` 
  SET `item_id`='644',`view_in_list`='1',`view_item`='1',`add_favorite`='0',`date_year`='2024',`date_month`='5',`extension`='com_jomdirectory'

1 × SHOW FULL COLUMNS 
  FROM `seraku52_template_styles

Detalles

Ubicación

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

51 consultas registradas 75.88 ms

¡ 6 duplicaciones detectadas!

41 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: