Encuentra aquí el producto o servicio para embellecer tu casa

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1733691711,
                "last": 1733691711,
                "now": 1733691711
            },
            "token": "F7HGztVGm9J4yyv25woGJL0iojHwxuC4"
        },
        "registry": {
            "com_jomdirectory": {
                "items": {
                    "list": {
                        "limitstart": "0"
                    },
                    "filter": {
                        "categories_address_id": "228"
                    }
                }
            }
        },
        "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
        }
    }
}

Fecha y hora

Memoria

100 consultas registradas 243.68 ms

1. Tiempo de la consulta: 0.46 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 4.144 MB Filas devueltas: 0

   SELECT `data`
   
     FROM `seraku52_session`
   
     WHERE `session_id` = X'3961393963626635616532653563623235393333323031313765323235313865'

   Explicar

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

   Perfil

   No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

   Llamada de pila

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

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

   ---

2. Tiempo de la consulta: 0.35 ms Después de la última consulta: 1.48 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 4.240 MB Filas devueltas: 0

   SELECT `session_id`
   
     FROM `seraku52_session`
   
     WHERE `session_id` = X'3961393963626635616532653563623235393333323031313765323235313865' 
     LIMIT 1

   Explicar

   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

   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.01 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 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.01 ms
   Reset for next command	0.01 ms

   Llamada de pila

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

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

   ---

3. Tiempo de la consulta: 2.37 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 4.245 MB

   INSERT INTO `seraku52_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3961393963626635616532653563623235393333323031313765323235313865', 1, 1733691711, 0, '', 0)

   Explicar

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

   Perfil

   Status	Duration
   Starting	0.05 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.15 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	1.97 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.01 ms
   Reset for next command	0.02 ms

   Llamada de pila

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

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

   ---

4. Tiempo de la consulta: 1.06 ms Después de la última consulta: 2.80 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.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.03 ms
   Executing	0.01 ms
   Sending data	0.62 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.01 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.]

   ---

5. Tiempo de la consulta: 0.33 ms Después de la última consulta: 2.86 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.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.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.]

   ---

6. Tiempo de la consulta: 0.51 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.712 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.13 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.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.03 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:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Tiempo de la consulta: 1.48 ms Después de la última consulta: 0.77 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.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.04 ms
   Preparing	0.03 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	1.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Closing tables	0.02 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
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Lo mismo que llamada de la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Tiempo de la consulta: 0.15 ms Después de la última consulta: 16.13 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.04 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.01 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.]

   ---

9. Tiempo de la consulta: 0.51 ms Después de la última consulta: 0.44 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.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.03 ms
   Optimizing	0.02 ms
   Statistics	0.13 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.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
   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.]

   ---

10. Tiempo de la consulta: 0.84 ms Después de la última consulta: 0.21 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 6.457 MB

    UPDATE `seraku52_extensions`
    
      SET `params` = '{\"mediaversion\":\"8e1221de09c2e911add1e2aeb96b7cb3\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explicar

    'Explicar' no es posible en la consulta: UPDATE `seraku52_extensions` SET `params` = '{\"mediaversion\":\"8e1221de09c2e911add1e2aeb96b7cb3\"}' 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.47 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.]

    ---

11. Tiempo de la consulta: 0.73 ms Después de la última consulta: 12.75 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 7.246 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.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.12 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.15 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.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 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: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.]

    ---

12. Tiempo de la consulta: 0.37 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 7.253 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.03 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.03 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.01 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.]

    ---

13. Tiempo de la consulta: 0.51 ms Después de la última consulta: 4.04 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 7.497 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.03 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.10 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.05 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.]

    ---

14. Tiempo de la consulta: 1.18 ms Después de la última consulta: 26.47 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 8.794 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.06 ms
    Checking permissions	0.01 ms
    Closing tables	0.01 ms
    Opening tables	0.38 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.02 ms
    After opening tables	0.01 ms
    Checking permissions	0.13 ms
    Closing tables	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
    Removing tmp table	0.16 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: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.]

    ---

15. Tiempo de la consulta: 0.68 ms Después de la última consulta: 0.83 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 8.844 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.01 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.14 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.08 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.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
    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.]

    ---

16. Tiempo de la consulta: 0.53 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 8.851 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.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.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 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.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: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.]

    ---

17. Tiempo de la consulta: 0.52 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 8.857 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.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
    Executing	0.01 ms
    Sending data	0.06 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.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: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.]

    ---

18. Tiempo de la consulta: 0.48 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 8.863 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.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.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 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.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: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.]

    ---

19. Tiempo de la consulta: 3.87 ms Después de la última consulta: 22.20 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 9.450 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.09 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.03 ms
    Optimizing	0.03 ms
    Statistics	0.16 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	3.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.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.]

    ---

20. Tiempo de la consulta: 0.87 ms Después de la última consulta: 17.16 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 10.789 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.08 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.15 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.22 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.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
    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.]

    ---

21. Tiempo de la consulta: 0.64 ms Después de la última consulta: 21.51 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 12.310 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.09 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.13 ms
    Preparing	0.04 ms
    Sorting result	0.02 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.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
    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.]

    ---

22. Tiempo de la consulta: 0.43 ms Después de la última consulta: 6.28 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 13.430 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.05 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 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.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/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.]

    ---

23. Tiempo de la consulta: 0.43 ms Después de la última consulta: 0.62 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 13.454 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.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.01 ms
    Statistics	0.01 ms
    Preparing	0.02 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.02 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
    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.]

    ---

24. Tiempo de la consulta: 1.10 ms Después de la última consulta: 15.02 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 14.431 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.06 ms
    Checking permissions	0.01 ms
    Closing tables	0.01 ms
    Opening tables	0.35 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.08 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.09 ms
    Closing tables	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.01 ms
    Closing tables	0.01 ms
    Removing tmp table	0.14 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
    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_jomcomdev/tables/statistic.php:29
    16	JomcomdevTableStatistic->__construct()	JROOT/libraries/src/Table/Table.php:328
    15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jomdirectory/models/items.php:98
    14	JomdirectoryModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/items/view.html.php:43
    10	JomdirectoryViewItems->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.]

    ---

25. Tiempo de la consulta: 2.91 ms Después de la última consulta: 0.47 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 14.462 MB Filas devueltas: 1

    SELECT *
    
      FROM seraku52_cddir_statistic
    
      WHERE `item_id` = '228' 
      AND `extension` = 'com_jomdirectory.location' 
      AND `date_year` = '2024' 
      AND `date_month` = '12'

    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	149	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.15 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	2.39 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    16	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jomcomdev/tables/statistic.php:54
    15	JomcomdevTableStatistic->addViewItemStats()	JROOT/components/com_jomdirectory/models/items.php:166
    14	JomdirectoryModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/items/view.html.php:43
    10	JomdirectoryViewItems->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.]

    ---

26. Tiempo de la consulta: 2.44 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 14.470 MB

    UPDATE `seraku52_cddir_statistic` 
      SET `item_id`='228',`view_in_list`='0',`view_item`='3',`add_favorite`='0',`date_year`='2024',`date_month`='12',`extension`='com_jomdirectory.location' 
      WHERE `id` = '53385'

    Explicar

    'Explicar' no es posible en la consulta: UPDATE `seraku52_cddir_statistic` SET `item_id`='228',`view_in_list`='0',`view_item`='3',`add_favorite`='0',`date_year`='2024',`date_month`='12',`extension`='com_jomdirectory.location' WHERE `id` = '53385'

    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 for update	0.05 ms
    Updating	0.08 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	2.06 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
    18	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    17	Joomla\CMS\Table\Table->store()	JROOT/libraries/src/Table/Table.php:933
    16	Joomla\CMS\Table\Table->save()	JROOT/administrator/components/com_jomcomdev/tables/statistic.php:64
    15	JomcomdevTableStatistic->addViewItemStats()	JROOT/components/com_jomdirectory/models/items.php:166
    14	JomdirectoryModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/items/view.html.php:43
    10	JomdirectoryViewItems->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.]

    ---

27. Tiempo de la consulta: 1.08 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 14.477 MB Filas devueltas: 28

    SHOW FULL COLUMNS 
      FROM `seraku52_cddir_categories`

    Explicar

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

    Perfil

    Status	Duration
    Starting	0.03 ms
    Checking permissions	0.02 ms
    Closing tables	0.01 ms
    Opening tables	0.34 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.03 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.17 ms
    Closing tables	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
    Removing tmp table	0.14 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
    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_jomcomdev/tables/category.php:32
    16	JomcomdevTableCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
    15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jomdirectory/models/items.php:168
    14	JomdirectoryModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/items/view.html.php:43
    10	JomdirectoryViewItems->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.]

    ---

28. Tiempo de la consulta: 0.54 ms Después de la última consulta: 0.21 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 14.530 MB Filas devueltas: 1
    Consultas duplicadas: #30  #85

    SELECT *
    
      FROM seraku52_cddir_categories
    
      WHERE `id` = '228'

    Explicar

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

    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.04 ms
    Optimizing	0.02 ms
    Statistics	0.14 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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/components/com_jomdirectory/models/items.php:169
    14	JomdirectoryModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/items/view.html.php:43
    10	JomdirectoryViewItems->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.]

    ---

29. Tiempo de la consulta: 34.68 ms Después de la última consulta: 1.03 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 14.646 MB Filas devueltas: 8

    SELECT a.id AS id, a.title AS title, a.alias AS alias, a.users_id, a.featured, a.fulladdress, a.published AS published, a.categories_address_id, a.categories_id AS categories_id, a.introtext, a.date_publish AS date_publish, a.date_publish_down AS date_publish_down, l.view_item,c.title AS category_title, c.color AS category_color,COUNT(d.id) AS rateHow, SUM(d.rate) AS rateSum, SUM(d.rate)/COUNT(d.id) as rateSort,COUNT(Distinct d.id) AS rateHowD,u.name AS username
    
      FROM `seraku52_cddir_content` AS a
    
      LEFT JOIN seraku52_cddir_categories AS c 
      ON c.id = a.categories_id
    
      LEFT JOIN seraku52_cddir_categories AS e 
      ON e.id = a.categories_address_id
    
      LEFT JOIN seraku52_cddir_reviews AS d 
      ON (a.id = d.content_id 
      AND d.published=1 
      AND d.approved=1 
      AND d.extension = "com_jomdirectory")
    
      LEFT JOIN seraku52_users AS u 
      ON u.id = a.users_id
    
      LEFT JOIN seraku52_cddir_statistic AS l 
      ON (l.item_id = a.id 
      AND l.extension='com_jomdirectory')
    
      WHERE a.published = 1 
      AND a.approved = 1 
      AND (a.date_publish <= '2024-12-08 21:01:52' OR a.date_publish IS NULL) 
      AND (a.date_publish_down >= '2024-12-08 21:01:52' OR a.date_publish_down IS NULL) 
      AND e.lft >= 446 
      AND e.rgt <= 451 
      AND a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND a.language in ('es-ES','*')
    
      GROUP BY a.id
    
      ORDER BY a.featured DESC, a.date_publish DESC, a.title 
      LIMIT 8

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	15	Using where; Using index; Using temporary; Usando 'filesort'
    1	SIMPLE	a	ref	fk_aku86q5_cddir_content_k86q5_categories,categories_address_id	categories_address_id	5	zoemcomm_servicios1.e.id	3	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	zoemcomm_servicios1.a.categories_id	1	Using where
    1	SIMPLE	d	ALL	content_id	No pudo usarse una clave de índice	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.users_id	1	Using where
    1	SIMPLE	l	ref	item_id	item_id	4	zoemcomm_servicios1.a.id	29	Using where

    Perfil

    Status	Duration
    Starting	0.16 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.08 ms
    Optimizing	0.05 ms
    Statistics	0.17 ms
    Preparing	0.08 ms
    Creating tmp table	0.07 ms
    Creating tmp table	0.05 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	20.74 ms
    Creating sort index	5.68 ms
    Creating sort index	0.19 ms
    Removing tmp table	6.72 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.21 ms
    Creating sort index	0.03 ms
    End of update loop	0.03 ms
    Removing tmp table	0.01 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.04 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Removing tmp table	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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/items/view.html.php:43
    10	JomdirectoryViewItems->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.]

    ---

30. Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.39 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 14.703 MB Filas devueltas: 1
    Consultas duplicadas: #28  #85

    SELECT *
    
      FROM seraku52_cddir_categories
    
      WHERE `id` = '228'

    Explicar

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

    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.04 ms
    Optimizing	0.02 ms
    Statistics	0.07 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.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.02 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/components/com_jomdirectory/models/items.php:169
    13	JomdirectoryModelItems->getListQuery()	JROOT/components/com_jomdirectory/models/items.php:45
    12	JomdirectoryModelItems->getItemsForMap()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/items/view.html.php:44
    10	JomdirectoryViewItems->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.]

    ---

31. Tiempo de la consulta: 19.50 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 14.703 MB Filas devueltas: 8

    SELECT a.id AS id, a.title AS title, a.alias AS alias, a.users_id, a.featured, a.categories_id AS categories_id, a.maps_lat, a.maps_lng,COUNT(d.id) AS rateHow, SUM(d.rate) AS rateSum, SUM(d.rate)/COUNT(d.id) as rateSort,COUNT(Distinct d.id) AS rateHowD
    
      FROM `seraku52_cddir_content` AS a
    
      LEFT JOIN seraku52_cddir_categories AS c 
      ON c.id = a.categories_id
    
      LEFT JOIN seraku52_cddir_categories AS e 
      ON e.id = a.categories_address_id
    
      LEFT JOIN seraku52_cddir_reviews AS d 
      ON (a.id = d.content_id 
      AND d.published=1 
      AND d.approved=1 
      AND d.extension = "com_jomdirectory")
    
      LEFT JOIN seraku52_users AS u 
      ON u.id = a.users_id
    
      LEFT JOIN seraku52_cddir_statistic AS l 
      ON (l.item_id = a.id 
      AND l.extension='com_jomdirectory')
    
      WHERE a.published = 1 
      AND a.approved = 1 
      AND (a.date_publish <= '2024-12-08 21:01:52' OR a.date_publish IS NULL) 
      AND (a.date_publish_down >= '2024-12-08 21:01:52' OR a.date_publish_down IS NULL) 
      AND e.lft >= 446 
      AND e.rgt <= 451 
      AND a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND a.language in ('es-ES','*')
    
      GROUP BY a.id
    
      ORDER BY a.featured DESC, a.date_publish DESC, a.title 
      LIMIT 8

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	15	Using where; Using index; Using temporary; Usando 'filesort'
    1	SIMPLE	a	ref	fk_aku86q5_cddir_content_k86q5_categories,categories_address_id	categories_address_id	5	zoemcomm_servicios1.e.id	3	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	zoemcomm_servicios1.a.categories_id	1	Using where
    1	SIMPLE	d	ALL	content_id	No pudo usarse una clave de índice	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	l	ref	item_id	item_id	4	zoemcomm_servicios1.a.id	29	Using where

    Perfil

    Status	Duration
    Starting	0.14 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.07 ms
    Optimizing	0.05 ms
    Statistics	0.13 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.07 ms
    Creating tmp table	0.06 ms
    Creating tmp table	0.04 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	16.14 ms
    Creating sort index	2.15 ms
    Creating sort index	0.16 ms
    Removing tmp table	0.02 ms
    Creating sort index	0.01 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.02 ms
    Removing tmp table	0.01 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.04 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Removing tmp table	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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_jomdirectory/models/items.php:48
    12	JomdirectoryModelItems->getItemsForMap()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/items/view.html.php:44
    10	JomdirectoryViewItems->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.]

    ---

32. Tiempo de la consulta: 30.70 ms Después de la última consulta: 1.80 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 14.810 MB Filas devueltas: 30

    SELECT a.id AS id, a.title AS title, a.alias AS alias, a.users_id, a.featured, a.fulladdress, a.published AS published, a.categories_address_id, a.categories_id AS categories_id, a.introtext, a.date_publish AS date_publish, a.date_publish_down AS date_publish_down, l.view_item,c.title AS category_title, c.color AS category_color,COUNT(d.id) AS rateHow, SUM(d.rate) AS rateSum, SUM(d.rate)/COUNT(d.id) as rateSort,COUNT(Distinct d.id) AS rateHowD,u.name AS username
    
      FROM `seraku52_cddir_content` AS a
    
      LEFT JOIN seraku52_cddir_categories AS c 
      ON c.id = a.categories_id
    
      LEFT JOIN seraku52_cddir_categories AS e 
      ON e.id = a.categories_address_id
    
      LEFT JOIN seraku52_cddir_reviews AS d 
      ON (a.id = d.content_id 
      AND d.published=1 
      AND d.approved=1 
      AND d.extension = "com_jomdirectory")
    
      LEFT JOIN seraku52_users AS u 
      ON u.id = a.users_id
    
      LEFT JOIN seraku52_cddir_statistic AS l 
      ON (l.item_id = a.id 
      AND l.extension='com_jomdirectory')
    
      WHERE a.published = 1 
      AND a.approved = 1 
      AND (a.date_publish <= '2024-12-08 21:01:52' OR a.date_publish IS NULL) 
      AND (a.date_publish_down >= '2024-12-08 21:01:52' OR a.date_publish_down IS NULL) 
      AND e.lft >= 446 
      AND e.rgt <= 451 
      AND a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND a.language in ('es-ES','*')
    
      GROUP BY a.id

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	15	Using where; Using index; Using temporary; Usando 'filesort'
    1	SIMPLE	a	ref	fk_aku86q5_cddir_content_k86q5_categories,categories_address_id	categories_address_id	5	zoemcomm_servicios1.e.id	3	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	zoemcomm_servicios1.a.categories_id	1	Using where
    1	SIMPLE	d	ALL	content_id	No pudo usarse una clave de índice	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.users_id	1	Using where
    1	SIMPLE	l	ref	item_id	item_id	4	zoemcomm_servicios1.a.id	29	Using where

    Perfil

    Status	Duration
    Starting	0.23 ms
    Checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.13 ms
    Optimizing	0.09 ms
    Statistics	0.17 ms
    Preparing	0.09 ms
    Creating tmp table	0.13 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	17.52 ms
    Creating sort index	5.15 ms
    Removing tmp table	6.69 ms
    Creating sort index	0.04 ms
    End of update loop	0.02 ms
    Removing tmp table	0.01 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.03 ms
    Removing tmp table	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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
    13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
    12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jomdirectory/views/items/view.html.php:46
    10	JomdirectoryViewItems->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.]

    ---

33. Tiempo de la consulta: 0.85 ms Después de la última consulta: 1.87 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 14.923 MB Filas devueltas: 0
    Consultas duplicadas: #37  #41  #44  #47  #50  #53  #56

    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.categories_group_id IN (24,81) 
      AND a.published = 1 
      AND a.extension = 'com_jomdirectory' 
      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	No pudo usarse una clave de índice	NULL	NULL	4	Using where; Usando 'filesort'
    1	SIMPLE	d	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.categories_group_id	1
    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

    Perfil

    Status	Duration
    Starting	0.12 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.07 ms
    Optimizing	0.04 ms
    Statistics	0.17 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.06 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.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
    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/items/view.html.php:74
    10	JomdirectoryViewItems->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.]

    ---

34. Tiempo de la consulta: 0.69 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 14.930 MB Filas devueltas: 6
    Consultas duplicadas: #38  #42  #45  #48  #51  #54  #57

    SELECT id,title
    
      FROM seraku52_cddir_categories
    
      WHERE extension = 'com_jomcomdev.type' 
      AND title IN ('COM_JOMCOMDEV_TYPE_FIELDS_GROUP_ITEM','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_ITEMS','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_TABS','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_FEATURES','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_PAIDITEM','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_PAIDITEMS','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_STATE','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_SHIPPING')

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	seraku52_cddir_categories	ref	cat_idx	cat_idx	152	const	37	Using index condition; 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.07 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.32 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:83
    11	Main_FieldsSite->getGroupsIDs()	JROOT/components/com_jomdirectory/views/items/view.html.php:78
    10	JomdirectoryViewItems->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.]

    ---

35. Tiempo de la consulta: 0.54 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 14.940 MB Filas devueltas: 0
    Consultas duplicadas: #39  #43  #46  #49  #52  #55  #58

    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.categories_group_id = '81' 
      AND a.published = 1 
      AND a.extension = 'com_jomdirectory' 
      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	ref	fk_aku86q5_cddir_fields_k86q5_cddir_categories1,fk_aku86q5_cddir_fields_k86q5_cddir_categories2,fk_aku86q5_cddir_fields_k86q5_cddir_categories3	fk_aku86q5_cddir_fields_k86q5_cddir_categories2	4	const	1	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.07 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.06 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	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.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/items/view.html.php:80
    10	JomdirectoryViewItems->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.]

    ---

36. Tiempo de la consulta: 3.22 ms Después de la última consulta: 1.93 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.022 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=280 
      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.14 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.04 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Statistics	0.16 ms
    Preparing	0.03 ms
    Creating tmp table	0.03 ms
    Sorting result	0.02 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.05 ms
    Executing	0.01 ms
    Sending data	0.76 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.01 ms
    Creating sort index	1.03 ms
    Creating sort index	0.10 ms
    Removing tmp table	0.17 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/items/view.html.php:83
    10	JomdirectoryViewItems->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.]

    ---

37. Tiempo de la consulta: 0.69 ms Después de la última consulta: 0.85 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.078 MB Filas devueltas: 0
    Consultas duplicadas: #33  #41  #44  #47  #50  #53  #56

    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.categories_group_id IN (24,81) 
      AND a.published = 1 
      AND a.extension = 'com_jomdirectory' 
      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	No pudo usarse una clave de índice	NULL	NULL	4	Using where; Usando 'filesort'
    1	SIMPLE	d	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.categories_group_id	1
    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

    Perfil

    Status	Duration
    Starting	0.09 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.04 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.06 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	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.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 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/items/view.html.php:74
    10	JomdirectoryViewItems->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.]

    ---

38. Tiempo de la consulta: 0.52 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.083 MB Filas devueltas: 6
    Consultas duplicadas: #34  #42  #45  #48  #51  #54  #57

    SELECT id,title
    
      FROM seraku52_cddir_categories
    
      WHERE extension = 'com_jomcomdev.type' 
      AND title IN ('COM_JOMCOMDEV_TYPE_FIELDS_GROUP_ITEM','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_ITEMS','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_TABS','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_FEATURES','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_PAIDITEM','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_PAIDITEMS','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_STATE','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_SHIPPING')

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	seraku52_cddir_categories	ref	cat_idx	cat_idx	152	const	37	Using index condition; Using where

    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.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.23 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:83
    11	Main_FieldsSite->getGroupsIDs()	JROOT/components/com_jomdirectory/views/items/view.html.php:78
    10	JomdirectoryViewItems->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.]

    ---

39. Tiempo de la consulta: 0.52 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.093 MB Filas devueltas: 0
    Consultas duplicadas: #35  #43  #46  #49  #52  #55  #58

    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.categories_group_id = '81' 
      AND a.published = 1 
      AND a.extension = 'com_jomdirectory' 
      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	ref	fk_aku86q5_cddir_fields_k86q5_cddir_categories1,fk_aku86q5_cddir_fields_k86q5_cddir_categories2,fk_aku86q5_cddir_fields_k86q5_cddir_categories3	fk_aku86q5_cddir_fields_k86q5_cddir_categories2	4	const	1	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.06 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.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	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.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/items/view.html.php:80
    10	JomdirectoryViewItems->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.]

    ---

40. Tiempo de la consulta: 2.93 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.101 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=279 
      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.11 ms
    Optimizing	0.04 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Statistics	0.13 ms
    Preparing	0.04 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.05 ms
    Executing	0.01 ms
    Sending data	0.71 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.97 ms
    Creating sort index	0.10 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/Address.php:45
    11	Main_Address->getAddress()	JROOT/components/com_jomdirectory/views/items/view.html.php:83
    10	JomdirectoryViewItems->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.]

    ---

41. Tiempo de la consulta: 0.59 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.114 MB Filas devueltas: 0
    Consultas duplicadas: #33  #37  #44  #47  #50  #53  #56

    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.categories_group_id IN (24,81) 
      AND a.published = 1 
      AND a.extension = 'com_jomdirectory' 
      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	No pudo usarse una clave de índice	NULL	NULL	4	Using where; Usando 'filesort'
    1	SIMPLE	d	eq_ref	PRIMARY	PRIMARY	4	zoemcomm_servicios1.a.categories_group_id	1
    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

    Perfil

    Status	Duration
    Starting	0.07 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.08 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.05 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	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
    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/items/view.html.php:74
    10	JomdirectoryViewItems->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.]

    ---

42. Tiempo de la consulta: 0.52 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.119 MB Filas devueltas: 6
    Consultas duplicadas: #34  #38  #45  #48  #51  #54  #57

    SELECT id,title
    
      FROM seraku52_cddir_categories
    
      WHERE extension = 'com_jomcomdev.type' 
      AND title IN ('COM_JOMCOMDEV_TYPE_FIELDS_GROUP_ITEM','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_ITEMS','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_TABS','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_FEATURES','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_PAIDITEM','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_PAIDITEMS','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_STATE','COM_JOMCOMDEV_TYPE_FIELDS_GROUP_SHIPPING')

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	seraku52_cddir_categories	ref	cat_idx	cat_idx	152	const	37	Using index condition; Using where

    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.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.22 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:83
    11	Main_FieldsSite->getGroupsIDs()	JROOT/components/com_jomdirectory/views/items/view.html.php:78
    10	JomdirectoryViewItems->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.]

    ---

43. Tiempo de la consulta: 0.53 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.129 MB Filas devueltas: 0