|
- El pago se realizará por períodos anticipados.
- Los materiales fungibles serán por cuenta del ARRENDATARIO
Read more: Condiciones generales
DATA RENT, S.A. informa acerca del uso de las cookies en su página web: www.datarent.es
¿Qué son las cookies?
Las cookies son archivos que se pueden descargar en su equipo a través de las páginas web. Son herramientas que tienen un papel esencial para la prestación de numerosos servicios de la sociedad de la información. Entre otros, permiten a una página web almacenar y recuperar información sobre los hábitos de navegación de un usuario o de su equipo y, dependiendo de la información obtenida, se pueden utilizar para reconocer al usuario y mejorar el servicio ofrecido.
Read more: Política de cookies
Protección de datos de carácter personal según el RGPD
DATA RENT, S.A., en aplicación de la normativa vigente en materia de protección de datos de carácter personal, informa que los datos personales que se recogen a través de los formularios del Sitio web: www.datarent.es, se incluyen en los ficheros automatizados específicos de usuarios de los servicios de DATA RENT, S.A.
Read more: Política de privacidad
Joomla! Debug Console{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1627811380,
"last": 1627811380,
"now": 1627811380
},
"token": "8SNM1a92ECLDSFhu3CT4qx789DMYuDzN"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
TimeMemoryTime: 33.10 ms / 33.10 ms Memory: 0.503 MB / 0.89 MB Application: afterLoad Time: 73.91 ms / 107.01 ms Memory: 1.018 MB / 1.90 MB Application: afterInitialise Time: 30.80 ms / 137.81 ms Memory: 0.347 MB / 2.25 MB Application: afterRoute Time: 2.10 ms / 139.91 ms Memory: 0.027 MB / 2.28 MB Application: beforeRenderComponent com_content Time: 8.62 ms / 148.53 ms Memory: 0.149 MB / 2.43 MB Application: Before Access::preloadComponents (all components) Time: 1.57 ms / 150.09 ms Memory: 0.055 MB / 2.48 MB Application: After Access::preloadComponents (all components) Time: 0.05 ms / 150.14 ms Memory: 0.000 MB / 2.48 MB Application: Before Access::preloadPermissions (com_content) Time: 1.21 ms / 151.36 ms Memory: 0.146 MB / 2.62 MB Application: After Access::preloadPermissions (com_content) Time: 0.04 ms / 151.40 ms Memory: 0.000 MB / 2.61 MB Application: Before Access::getAssetRules (id:39 name:com_content.category.14) Time: 0.97 ms / 152.37 ms Memory: 0.009 MB / 2.62 MB Application: After Access::getAssetRules (id:39 name:com_content.category.14) Time: 6.08 ms / 158.45 ms Memory: 0.108 MB / 2.73 MB Application: Before Access::getAssetRules (id:8 name:com_content) Time: 0.09 ms / 158.54 ms Memory: 0.007 MB / 2.74 MB Application: After Access::getAssetRules (id:8 name:com_content) Time: 65.82 ms / 224.36 ms Memory: 0.428 MB / 3.17 MB Application: afterRenderComponent com_content Time: 5.95 ms / 230.31 ms Memory: 0.015 MB / 3.18 MB Application: afterDispatch Time: 41.74 ms / 272.04 ms Memory: 0.291 MB / 3.47 MB Application: beforeRenderModule mod_custom (Información) Time: 3.69 ms / 275.73 ms Memory: 0.017 MB / 3.49 MB Application: afterRenderModule mod_custom (Información) Time: 3.57 ms / 279.30 ms Memory: 0.000 MB / 3.48 MB Application: beforeRenderModule mod_search (Buscar) Time: 4.32 ms / 283.62 ms Memory: 0.019 MB / 3.50 MB Application: afterRenderModule mod_search (Buscar) Time: 0.04 ms / 283.66 ms Memory: 0.000 MB / 3.50 MB Application: beforeRenderModule mod_custom (Copyrights) Time: 0.98 ms / 284.64 ms Memory: 0.003 MB / 3.50 MB Application: afterRenderModule mod_custom (Copyrights) Time: 0.06 ms / 284.70 ms Memory: 0.001 MB / 3.50 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs) Time: 1.95 ms / 286.65 ms Memory: 0.011 MB / 3.51 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs) Time: 0.06 ms / 286.72 ms Memory: 0.000 MB / 3.51 MB Application: beforeRenderModule mod_djmenu (DJ-Menu) Time: 3.55 ms / 290.27 ms Memory: 0.061 MB / 3.57 MB Application: afterRenderModule mod_djmenu (DJ-Menu) Time: 0.06 ms / 290.33 ms Memory: 0.000 MB / 3.57 MB Application: beforeRenderModule mod_custom (Socials) Time: 0.97 ms / 291.30 ms Memory: 0.003 MB / 3.57 MB Application: afterRenderModule mod_custom (Socials) Time: 0.03 ms / 291.33 ms Memory: 0.000 MB / 3.57 MB Application: beforeRenderModule mod_custom (sello) Time: 0.94 ms / 292.27 ms Memory: 0.003 MB / 3.57 MB Application: afterRenderModule mod_custom (sello) Time: 0.08 ms / 292.35 ms Memory: 0.014 MB / 3.59 MB Application: beforeRenderModule mod_gtranslate (Traductor) Time: 1.97 ms / 294.32 ms Memory: 0.097 MB / 3.68 MB Application: afterRenderModule mod_gtranslate (Traductor) Time: 4.04 ms / 298.36 ms Memory: 0.000 MB / 3.68 MB Application: afterRender Database queries total: 42.78 ms 4.04 MB (4,234,880 Bytes) 30 Queries Logged 42.78 msQuery Time: 0.57 ms Query memory: 0.023 MB Memory before query: 1.249 MB Rows returned: 0 SELECT `data`
FROM `r1o0r_session`
WHERE `session_id` = X'34633163306c6368667631336b6b6d3232636634366a306b7470' | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r1o0r_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.01 ms | | Opening tables | 0.07 ms | | init | 0.03 ms | | System lock | 0.04 ms | | optimizing | 0.02 ms | | statistics | 0.11 ms | | executing | 0.02 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.02 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 | | 14 | JSessionStorageDatabase->read() | Same as call in the line below. | | 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:660 | | 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 | | 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 | | 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 | | 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:758 | | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 | | 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:344 | | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.49 ms After last query: 1.96 ms Query memory: 0.020 MB Memory before query: 1.264 MB Rows returned: 0 SELECT `session_id`
FROM `r1o0r_session`
WHERE `session_id` = X'34633163306c6368667631336b6b6d3232636634366a306b7470'
LIMIT 1 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r1o0r_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.04 ms | | checking permissions | 0.03 ms | | Opening tables | 0.02 ms | | init | 0.03 ms | | System lock | 0.03 ms | | optimizing | 0.01 ms | | statistics | 0.04 ms | | executing | 0.03 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 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:153 | | 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 | | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 | | 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:344 | | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 2.64 ms After last query: 0.16 ms Query memory: 0.004 MB Memory before query: 1.270 MB INSERT INTO `r1o0r_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'34633163306c6368667631336b6b6d3232636634366a306b7470', 1, 1627811380, 0, '', 0) EXPLAIN not possible on query: INSERT INTO `r1o0r_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'34633163306c6368667631336b6b6d3232636634366a306b7470', 1, 1627811380, 0, '', 0) | Status | Duration |
|---|
| starting | 0.06 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.03 ms | | System lock | 0.04 ms | | update | 0.21 ms | | end | 0.01 ms | | query end | 2.06 ms | | closing tables | 0.02 ms | | freeing items | 0.03 ms | | cleaning up | 0.05 ms |
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 | | 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 | | 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 | | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 | | 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:344 | | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.77 ms After last query: 4.27 ms Query memory: 0.024 MB Memory before query: 1.306 MB Rows returned: 37 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `r1o0r_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r1o0r_extensions | NULL | ref | extension | extension | 82 | const | 25 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.02 ms | | Opening tables | 0.07 ms | | init | 0.04 ms | | System lock | 0.04 ms | | optimizing | 0.02 ms | | statistics | 0.26 ms | | preparing | 0.03 ms | | executing | 0.02 ms | | Sending data | 0.87 ms | | end | 0.02 ms | | query end | 0.02 ms | | closing tables | 0.03 ms | | freeing items | 0.05 ms | | cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 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}() | Same as call in the line below. | | 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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.57 ms After last query: 3.44 ms Query memory: 0.021 MB Memory before query: 1.338 MB Rows returned: 5 SELECT id, rules
FROM `r1o0r_viewlevels` | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r1o0r_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.02 ms | | Opening tables | 0.05 ms | | init | 0.03 ms | | System lock | 0.03 ms | | optimizing | 0.02 ms | | statistics | 0.03 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.12 ms | | end | 0.02 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.02 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 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:321 | | 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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.71 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 1.350 MB Rows returned: 2 SELECT b.id
FROM r1o0r_usergroups AS a
LEFT JOIN r1o0r_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL | | 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.02 ms | | checking permissions | 0.01 ms | | Opening tables | 0.09 ms | | init | 0.05 ms | | System lock | 0.03 ms | | optimizing | 0.02 ms | | statistics | 0.16 ms | | preparing | 0.03 ms | | executing | 0.02 ms | | Sending data | 0.05 ms | | end | 0.02 ms | | query end | 0.02 ms | | closing tables | 0.01 ms | | freeing items | 0.02 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 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:321 | | 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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 3.41 ms After last query: 0.50 ms Query memory: 0.030 MB Memory before query: 1.372 MB Rows returned: 89 SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM r1o0r_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r1o0r_extensions | NULL | ref | extension | extension | 82 | const | 144 | 0.43 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.01 ms | | Opening tables | 0.05 ms | | init | 0.03 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.10 ms | | preparing | 0.08 ms | | Sorting result | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.02 ms | | Creating sort index | 2.69 ms | | end | 0.04 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.04 ms | | cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 | | 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. | | 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:359 | | 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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 3.14 ms After last query: 31.72 ms Query memory: 0.052 MB Memory before query: 1.934 MB Rows returned: 30 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 r1o0r_menu AS m
LEFT JOIN r1o0r_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 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 76 | 10.00 | Using index condition; Using where; Using filesort | | 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.10 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.06 ms | | init | 0.06 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.13 ms | | preparing | 0.04 ms | | Sorting result | 0.02 ms | | executing | 0.03 ms | | Sending data | 0.02 ms | | Creating sort index | 2.26 ms | | end | 0.01 ms | | query end | 0.03 ms | | closing tables | 0.03 ms | | freeing items | 0.03 ms | | cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 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}() | Same as call in the line below. | | 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:76 | | 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:131 | | 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 | | 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:64 | | 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:491 | | 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:1073 | | 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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.94 ms After last query: 14.48 ms Query memory: 0.022 MB Memory before query: 2.180 MB Rows returned: 4 SELECT id, home, template, s.params
FROM r1o0r_template_styles as s
LEFT JOIN r1o0r_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 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 3 | 100.00 | NULL | | 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | datarent_DB.s.template,const | 1 | 5.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.06 ms | | init | 0.04 ms | | System lock | 0.03 ms | | optimizing | 0.03 ms | | statistics | 0.15 ms | | preparing | 0.03 ms | | executing | 0.02 ms | | Sending data | 0.23 ms | | end | 0.01 ms | | query end | 0.02 ms | | closing tables | 0.04 ms | | freeing items | 0.03 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 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/jmframework/jmframework.php:103 | | 9 | plgSystemJMFramework->getTemplateName() | JROOT/plugins/system/jmframework/jmframework.php:52 | | 8 | plgSystemJMFramework->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:1122 | | 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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.61 ms After last query: 5.12 ms Query memory: 0.024 MB Memory before query: 2.236 MB Rows returned: 1 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `r1o0r_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla' | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r1o0r_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.02 ms | | System lock | 0.03 ms | | optimizing | 0.02 ms | | statistics | 0.18 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.05 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.02 ms | | cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | | 18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 | | 17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. | | 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 | | 14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 | | 13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 | | 12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 | | 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 | | 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 | | 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/gdpr/gdpr.php:834 | | 8 | plgSystemGdpr->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:1122 | | 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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.61 ms After last query: 0.23 ms Query memory: 0.006 MB Memory before query: 2.229 MB UPDATE `r1o0r_extensions`
SET `params` = '{\"mediaversion\":\"5ddbb430469c78d491f3c5e7d42409e2\"}'
WHERE `type` = 'library'
AND `element` = 'joomla' | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | r1o0r_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms | | checking permissions | 0.03 ms | | Opening tables | 0.02 ms | | init | 0.02 ms | | System lock | 0.16 ms | | updating | 0.12 ms | | end | 0.02 ms | | query end | 0.01 ms | | closing tables | 0.06 ms | | freeing items | 0.02 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 | | 13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 | | 12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 | | 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 | | 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 | | 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/gdpr/gdpr.php:834 | | 8 | plgSystemGdpr->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:1122 | | 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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.67 ms After last query: 3.00 ms Query memory: 0.019 MB Memory before query: 2.264 MB Rows returned: 2 SELECT *
FROM r1o0r_languages
WHERE published=1
ORDER BY ordering ASC | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r1o0r_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 33.33 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.04 ms | | checking permissions | 0.01 ms | | Opening tables | 0.06 ms | | init | 0.04 ms | | System lock | 0.03 ms | | optimizing | 0.02 ms | | statistics | 0.02 ms | | preparing | 0.02 ms | | Sorting result | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.02 ms | | Creating sort index | 0.14 ms | | end | 0.01 ms | | query end | 0.02 ms | | closing tables | 0.01 ms | | freeing items | 0.02 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.30 ms After last query: 9.58 ms Query memory: 0.028 MB Memory before query: 2.431 MB Rows returned: 36 SELECT `id`,`name`,`rules`,`parent_id`
FROM `r1o0r_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_cpanel','com_creativecontactform','com_djcatalog2','com_djimageslider','com_extplorer','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_privacy','com_redirect','com_search','com_tags','com_templates','com_uniform','com_users','com_weblinks','com_wrapper') | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r1o0r_assets | NULL | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 16.74 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.01 ms | | Opening tables | 0.05 ms | | init | 0.11 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.21 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.60 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.02 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 | | 18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 | | 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 | | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 | | 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 | | 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.74 ms After last query: 0.27 ms Query memory: 0.055 MB Memory before query: 2.479 MB Rows returned: 134 SELECT `id`,`name`,`rules`,`parent_id`
FROM `r1o0r_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r1o0r_assets | NULL | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 227 | 22.11 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.02 ms | | System lock | 0.01 ms | | optimizing | 0.01 ms | | statistics | 0.10 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.23 ms | | end | 0.01 ms | | query end | 0.02 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 | | 18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 | | 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 | | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | | 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | | 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 | | 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 | | 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.22 ms After last query: 3.51 ms Query memory: 0.025 MB Memory before query: 2.628 MB Rows returned: 2 SELECT 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, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)
FROM `r1o0r_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `r1o0r_categories` AS `s`
INNER JOIN `r1o0r_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 14
ORDER BY c.lft | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort | | 1 | PRIMARY | c | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 4 | 10.39 | Using index condition; Using where | | 2 | DEPENDENT SUBQUERY | i | NULL | ref | idx_state,idx_catid | idx_catid | 4 | datarent_DB.c.id | 5 | 20.79 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.19 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.12 ms | | init | 0.12 ms | | System lock | 0.05 ms | | optimizing | 0.03 ms | | statistics | 0.30 ms | | preparing | 0.05 ms | | Sorting result | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.06 ms | | preparing | 0.04 ms | | executing | 0.01 ms | | Sending data | 0.03 ms | | Creating sort index | 0.23 ms | | executing | 0.01 ms | | Sending data | 0.05 ms | | executing | 0.01 ms | | Sending data | 0.51 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.07 ms | | freeing items | 0.04 ms | | cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 | | 15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 | | 14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 | | 13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.75 ms After last query: 1.96 ms Query memory: 0.083 MB Memory before query: 2.737 MB Rows returned: 5 SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM r1o0r_content AS a
LEFT JOIN r1o0r_categories AS c
ON c.id = a.catid
LEFT JOIN r1o0r_users AS ua
ON ua.id = a.created_by
LEFT JOIN r1o0r_users AS uam
ON uam.id = a.modified_by
LEFT JOIN r1o0r_categories as parent
ON parent.id = c.parent_id
LEFT JOIN r1o0r_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid = 14
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-01 09:49:40')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-01 09:49:40')
ORDER BY c.lft, a.title, a.created
LIMIT 9 | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using filesort | | 1 | SIMPLE | a | NULL | index_merge | idx_access,idx_state,idx_catid | idx_catid,idx_state | 4,1 | NULL | 2 | 15.84 | Using intersect(idx_catid,idx_state); Using where | | 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.created_by | 1 | 100.00 | Using where | | 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.modified_by | 1 | 100.00 | Using where | | 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where | | 1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.24 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.10 ms | | init | 0.15 ms | | System lock | 0.07 ms | | optimizing | 0.05 ms | | statistics | 0.18 ms | | preparing | 0.05 ms | | Sorting result | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.04 ms | | Creating sort index | 1.39 ms | | end | 0.02 ms | | query end | 0.16 ms | | closing tables | 0.04 ms | | freeing items | 0.06 ms | | cleaning up | 0.07 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 | | 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 | | 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.75 ms After last query: 1.52 ms Query memory: 0.024 MB Memory before query: 2.837 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `r1o0r_contentitem_tag_map` AS m
INNER JOIN `r1o0r_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 102
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | datarent_DB.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.08 ms | | init | 0.06 ms | | System lock | 0.03 ms | | optimizing | 0.02 ms | | statistics | 0.14 ms | | preparing | 0.04 ms | | executing | 0.01 ms | | Sending data | 0.07 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.03 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.51 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 2.857 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `r1o0r_contentitem_tag_map` AS m
INNER JOIN `r1o0r_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 82
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | datarent_DB.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.04 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.07 ms | | preparing | 0.04 ms | | executing | 0.01 ms | | Sending data | 0.04 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.61 ms After last query: 0.43 ms Query memory: 0.024 MB Memory before query: 2.876 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `r1o0r_contentitem_tag_map` AS m
INNER JOIN `r1o0r_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 92
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | datarent_DB.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.06 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.07 ms | | preparing | 0.04 ms | | executing | 0.01 ms | | Sending data | 0.04 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.48 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 2.896 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `r1o0r_contentitem_tag_map` AS m
INNER JOIN `r1o0r_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 101
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | datarent_DB.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.04 ms | | System lock | 0.01 ms | | optimizing | 0.02 ms | | statistics | 0.06 ms | | preparing | 0.04 ms | | executing | 0.01 ms | | Sending data | 0.04 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.02 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.50 ms After last query: 0.25 ms Query memory: 0.024 MB Memory before query: 2.915 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `r1o0r_contentitem_tag_map` AS m
INNER JOIN `r1o0r_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 100
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | datarent_DB.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.04 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.07 ms | | preparing | 0.04 ms | | executing | 0.01 ms | | Sending data | 0.04 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.02 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.31 ms After last query: 1.17 ms Query memory: 0.024 MB Memory before query: 2.925 MB Rows returned: 1 SELECT COUNT(*)
FROM r1o0r_content AS a
LEFT JOIN r1o0r_categories AS c
ON c.id = a.catid
LEFT JOIN r1o0r_users AS ua
ON ua.id = a.created_by
LEFT JOIN r1o0r_users AS uam
ON uam.id = a.modified_by
LEFT JOIN r1o0r_categories as parent
ON parent.id = c.parent_id
LEFT JOIN r1o0r_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid = 14
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-01 09:49:40')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-01 09:49:40') | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | NULL | | 1 | SIMPLE | a | NULL | index_merge | idx_access,idx_state,idx_catid | idx_catid,idx_state | 4,1 | NULL | 2 | 15.84 | Using intersect(idx_catid,idx_state); Using where | | 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.created_by | 1 | 100.00 | Using where; Using index | | 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.modified_by | 1 | 100.00 | Using where; Using index | | 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where; Using index | | 1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.09 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.05 ms | | System lock | 0.02 ms | | optimizing | 0.03 ms | | statistics | 0.15 ms | | preparing | 0.04 ms | | executing | 0.01 ms | | Sending data | 0.58 ms | | end | 0.01 ms | | query end | 0.07 ms | | closing tables | 0.02 ms | | freeing items | 0.03 ms | | cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | | 17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 | | 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 | | 15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 | | 14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 | | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.66 ms After last query: 0.60 ms Query memory: 0.022 MB Memory before query: 2.929 MB Rows returned: 0 SELECT `m`.`tag_id`,`t`.*
FROM `r1o0r_contentitem_tag_map` AS m
INNER JOIN `r1o0r_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 14
AND `t`.`published` = 1
AND t.access IN (1,1) | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where | | 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | datarent_DB.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.04 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.07 ms | | preparing | 0.04 ms | | executing | 0.01 ms | | Sending data | 0.04 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.03 ms | | cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | | 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:229 | | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.98 ms After last query: 5.45 ms Query memory: 0.026 MB Memory before query: 2.971 MB Rows returned: 2 SELECT 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, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `r1o0r_categories` AS `s`
INNER JOIN `r1o0r_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 14
ORDER BY c.lft | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort | | 1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | cat_idx | 207 | NULL | 4 | 10.39 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.12 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.05 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.19 ms | | preparing | 0.03 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.02 ms | | Creating sort index | 0.20 ms | | end | 0.05 ms | | query end | 0.02 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.05 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 | | 19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 | | 18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 | | 17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 | | 16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 | | 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 | | 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 | | 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 | | 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.61 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 2.995 MB Rows returned: 0 SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM r1o0r_fields AS a
LEFT JOIN `r1o0r_languages` AS l
ON l.lang_code = a.language
LEFT JOIN r1o0r_users AS uc
ON uc.id=a.checked_out
LEFT JOIN r1o0r_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN r1o0r_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN r1o0r_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `r1o0r_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (14,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort | | 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | datarent_DB.a.language | 1 | 100.00 | Using where | | 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.checked_out | 1 | 100.00 | NULL | | 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.access | 1 | 100.00 | Using where | | 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.created_user_id | 1 | 100.00 | Using where | | 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.group_id | 1 | 100.00 | Using where | | 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.15 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.13 ms | | init | 0.10 ms | | System lock | 0.04 ms | | optimizing | 0.03 ms | | statistics | 0.23 ms | | preparing | 0.06 ms | | Creating tmp table | 0.11 ms | | Sorting result | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.26 ms | | Creating sort index | 0.05 ms | | end | 0.01 ms | | query end | 0.02 ms | | removing tmp table | 0.05 ms | | query end | 0.01 ms | | closing tables | 0.03 ms | | freeing items | 0.03 ms | | cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 | | 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 | | 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 | | 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 | | 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 | | 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 | | 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.09 ms After last query: 23.25 ms Query memory: 0.027 MB Memory before query: 3.132 MB Rows returned: 0 SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM r1o0r_fields AS a
LEFT JOIN `r1o0r_languages` AS l
ON l.lang_code = a.language
LEFT JOIN r1o0r_users AS uc
ON uc.id=a.checked_out
LEFT JOIN r1o0r_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN r1o0r_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN r1o0r_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `r1o0r_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (14,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort | | 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | datarent_DB.a.language | 1 | 100.00 | Using where | | 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.checked_out | 1 | 100.00 | NULL | | 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.access | 1 | 100.00 | Using where | | 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.created_user_id | 1 | 100.00 | Using where | | 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.group_id | 1 | 100.00 | Using where | | 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.14 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.03 ms | | init | 0.06 ms | | System lock | 0.02 ms | | optimizing | 0.03 ms | | statistics | 0.14 ms | | preparing | 0.05 ms | | Creating tmp table | 0.05 ms | | Sorting result | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.17 ms | | Creating sort index | 0.05 ms | | end | 0.01 ms | | query end | 0.02 ms | | removing tmp table | 0.04 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.03 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 | | 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 | | 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 | | 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 | | 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 | | 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 | | 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 15 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/tmpl/blog.php:19 | | 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 | | 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 | | 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 | | 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 | | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 | | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 | | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | | 6 | require_once JROOT/components/com_content/content.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:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.47 ms After last query: 21.21 ms Query memory: 0.020 MB Memory before query: 3.169 MB Rows returned: 0 SELECT id,placeholder
FROM `r1o0r_gdpr_checkbox` | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | r1o0r_gdpr_checkbox | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms | | checking permissions | 0.01 ms | | Opening tables | 0.05 ms | | init | 0.03 ms | | System lock | 0.02 ms | | optimizing | 0.01 ms | | statistics | 0.01 ms | | preparing | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.07 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.02 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 8 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/gdpr/gdpr.php:1084 | | 7 | plgSystemGdpr->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 | | 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | | 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 | | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 4.95 ms After last query: 25.78 ms Query memory: 0.033 MB Memory before query: 3.324 MB Rows returned: 34 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM r1o0r_modules AS m
LEFT JOIN r1o0r_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN r1o0r_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-08-01 09:49:40')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-08-01 09:49:40')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 475 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 80 | 1.60 | Using index condition; Using where; Using filesort | | 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | datarent_DB.m.module,const | 1 | 10.00 | Using index condition; Using where | | 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | datarent_DB.m.id | 3 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.09 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.08 ms | | init | 0.07 ms | | System lock | 0.04 ms | | optimizing | 0.03 ms | | statistics | 0.12 ms | | preparing | 0.04 ms | | Sorting result | 0.01 ms | | executing | 0.01 ms | | Sending data | 0.01 ms | | Creating sort index | 4.13 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.04 ms | | cleaning up | 0.05 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 17 | JDatabaseDriver->loadObjectList() | Same as call in the line below. | | 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 | | 14 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 | | 13 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 | | 12 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 | | 11 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/jmframework/includes/libraries/template.php:166 | | 10 | JMFTemplate->countModules() | JROOT/templates/jm-renewable-energy/lib/jm_template.php:19 | | 9 | JMTemplateBlank->postSetUp() | JROOT/plugins/system/jmframework/includes/libraries/template.php:58 | | 8 | JMFTemplate->__construct() | JROOT/templates/jm-renewable-energy/index.php:18 | | 7 | require JROOT/templates/jm-renewable-energy/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 | | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 | | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 | | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 | | 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | | 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 4.55 ms After last query: 11.51 ms Query memory: 0.034 MB Memory before query: 3.452 MB Rows returned: 34 SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM r1o0r_modules AS m
LEFT JOIN r1o0r_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN r1o0r_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-08-01 09:49:40')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-08-01 09:49:40')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 475 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 80 | 1.60 | Using index condition; Using where; Using filesort | | 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | datarent_DB.m.module,const | 1 | 10.00 | Using index condition; Using where | | 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | datarent_DB.m.id | 3 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.09 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.02 ms | | init | 0.06 ms | | System lock | 0.02 ms | | optimizing | 0.02 ms | | statistics | 0.09 ms | | preparing | 0.04 ms | | Sorting result | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.02 ms | | Creating sort index | 3.87 ms | | end | 0.01 ms | | query end | 0.01 ms | | closing tables | 0.01 ms | | freeing items | 0.04 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 19 | JDatabaseDriver->loadObjectList() | Same as call in the line below. | | 18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | | 17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 | | 16 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 | | 15 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 | | 14 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:37 | | 13 | DJModuleHelper::renderModules() | JROOT/templates/jm-renewable-energy/tpl/blocks/footer.php:25 | | 12 | include JROOT/templates/jm-renewable-energy/tpl/blocks/footer.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:203 | | 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-renewable-energy/tpl/default.php:36 | | 10 | include JROOT/templates/jm-renewable-energy/tpl/default.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:203 | | 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/jmframework/includes/libraries/template.php:210 | | 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-renewable-energy/index.php:19 | | 7 | require JROOT/templates/jm-renewable-energy/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 | | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 | | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 | | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 | | 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | | 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.17 ms After last query: 1.93 ms Query memory: 0.029 MB Memory before query: 3.493 MB Rows returned: 0 SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM r1o0r_fields AS a
LEFT JOIN `r1o0r_languages` AS l
ON l.lang_code = a.language
LEFT JOIN r1o0r_users AS uc
ON uc.id=a.checked_out
LEFT JOIN r1o0r_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN r1o0r_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN r1o0r_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `r1o0r_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'mod_custom.content'
AND (fc.category_id IS NULL OR fc.category_id IN (14,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort | | 1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | datarent_DB.a.language | 1 | 100.00 | Using where | | 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.checked_out | 1 | 100.00 | NULL | | 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.access | 1 | 100.00 | Using where | | 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.created_user_id | 1 | 100.00 | Using where | | 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.group_id | 1 | 100.00 | Using where | | 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | datarent_DB.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| starting | 0.13 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | checking permissions | 0.01 ms | | Opening tables | 0.04 ms | | init | 0.07 ms | | System lock | 0.02 ms | | optimizing | 0.03 ms | | statistics | 0.15 ms | | preparing | 0.05 ms | | Creating tmp table | 0.06 ms | | Sorting result | 0.02 ms | | executing | 0.01 ms | | Sending data | 0.21 ms | | Creating sort index | 0.07 ms | | end | 0.01 ms | | query end | 0.02 ms | | removing tmp table | 0.06 ms | | query end | 0.01 ms | | closing tables | 0.02 ms | | freeing items | 0.03 ms | | cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | | 27 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 | | 26 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 | | 25 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 | | 24 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 | | 23 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 | | 22 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 | | 21 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | | 20 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 | | 19 | JHtmlContent::prepare() | Same as call in the line below. | | 18 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 | | 17 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 | | 16 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 | | 15 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | | 14 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:56 | | 13 | DJModuleHelper::renderModules() | JROOT/templates/jm-renewable-energy/tpl/blocks/footer.php:25 | | 12 | include JROOT/templates/jm-renewable-energy/tpl/blocks/footer.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:203 | | 11 | JMFTemplate->renderBlock() | JROOT/templates/jm-renewable-energy/tpl/default.php:36 | | 10 | include JROOT/templates/jm-renewable-energy/tpl/default.php | JROOT/plugins/system/jmframework/includes/libraries/template.php:203 | | 9 | JMFTemplate->renderBlock() | JROOT/plugins/system/jmframework/includes/libraries/template.php:210 | | 8 | JMFTemplate->renderScheme() | JROOT/templates/jm-renewable-energy/index.php:19 | | 7 | require JROOT/templates/jm-renewable-energy/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 | | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 | | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 | | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 | | 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | | 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 | | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
20 Query Types Logged, Sorted by Occurrences.SELECT Tables:6 × SELECT `m`.`tag_id`,`t`.*
FROM `r1o0r_contentitem_tag_map` AS m
INNER JOIN `r1o0r_tags` AS t
ON `m`.`tag_id` = `t`.`id` 3 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM r1o0r_fields AS a
LEFT JOIN `r1o0r_languages` AS l
ON l.lang_code = a.language
LEFT JOIN r1o0r_users AS uc
ON uc.id=a.checked_out
LEFT JOIN r1o0r_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN r1o0r_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN r1o0r_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `r1o0r_fields_categories` AS fc
ON fc.field_id = a.id 2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM r1o0r_modules AS m
LEFT JOIN r1o0r_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN r1o0r_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id 2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `r1o0r_assets` 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `r1o0r_extensions` 1 × SELECT b.id
FROM r1o0r_usergroups AS a
LEFT JOIN r1o0r_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM r1o0r_extensions 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM r1o0r_menu AS m
LEFT JOIN r1o0r_extensions AS e
ON m.component_id = e.extension_id 1 × SELECT id, home, template, s.params
FROM r1o0r_template_styles as s
LEFT JOIN r1o0r_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id 1 × SELECT *
FROM r1o0r_languages 1 × SELECT `session_id`
FROM `r1o0r_session` 1 × SELECT 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, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `r1o0r_content` AS `i` 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM r1o0r_content AS a
LEFT JOIN r1o0r_categories AS c
ON c.id = a.catid
LEFT JOIN r1o0r_users AS ua
ON ua.id = a.created_by
LEFT JOIN r1o0r_users AS uam
ON uam.id = a.modified_by
LEFT JOIN r1o0r_categories as parent
ON parent.id = c.parent_id
LEFT JOIN r1o0r_content_rating AS v
ON a.id = v.content_id 1 × SELECT id, rules
FROM `r1o0r_viewlevels 1 × SELECT COUNT(*)
FROM r1o0r_content AS a
LEFT JOIN r1o0r_categories AS c
ON c.id = a.catid
LEFT JOIN r1o0r_users AS ua
ON ua.id = a.created_by
LEFT JOIN r1o0r_users AS uam
ON uam.id = a.modified_by
LEFT JOIN r1o0r_categories as parent
ON parent.id = c.parent_id
LEFT JOIN r1o0r_content_rating AS v
ON a.id = v.content_id 1 × SELECT 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, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `r1o0r_categories` AS `s`
INNER JOIN `r1o0r_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt) 1 × SELECT id,placeholder
FROM `r1o0r_gdpr_checkbox 1 × SELECT `data`
FROM `r1o0r_session`
OTHER Tables:1 × INSERT INTO `r1o0r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'34633163306c6368667631336b6b6d3232636634366a306b7470', 1, 1627811380, 0, '', 0 1 × UPDATE `r1o0r_extensions`
SET `params` = '{\"mediaversion\":\"5ddbb430469c78d491f3c5e7d42409e2\"}'
|
MADRID