Tempo della query: 0.44 ms Memoria query: 0.028 MB memoria prima della query: 1.260 MB Righe restituite: 1
SELECT `data`
FROM `lr1xn_session`
WHERE `session_id` = X'6d3138766c7135383930327162347239366d6a32663632717637'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | lr1xn_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Chiamata uguale alla linea sottostante. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Tempo della query: 0.88 ms Dopo l'ultima query: 0.99 ms Memoria query: 0.038 MB memoria prima della query: 1.313 MB Righe restituite: 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `lr1xn_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | lr1xn_extensions | ref | extension | extension | 82 | const | 45 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.24 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 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}() | Chiamata uguale alla linea sottostante. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.34 ms Dopo l'ultima query: 0.78 ms Memoria query: 0.025 MB memoria prima della query: 1.364 MB Righe restituite: 5
SELECT id, rules
FROM `lr1xn_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | lr1xn_viewlevels | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 5 | |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.36 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.025 MB memoria prima della query: 1.378 MB Righe restituite: 2
SELECT b.id
FROM lr1xn_usergroups AS a
LEFT JOIN lr1xn_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.87 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.039 MB memoria prima della query: 1.465 MB Righe restituite: 113
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM lr1xn_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | lr1xn_extensions | ref | extension | extension | 82 | const | 166 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.82 ms |
| Sending data | 0.40 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Chiamata uguale alla linea sottostante. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.48 ms Dopo l'ultima query: 33.08 ms Memoria query: 0.025 MB memoria prima della query: 2.148 MB Righe restituite: 1
SELECT `template`
FROM `lr1xn_template_styles`
WHERE `client_id` = 0
AND `home` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | lr1xn_template_styles | ALL | idx_client_id,idx_client_id_home | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 3 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 10 | JDatabaseDriver->loadObject() | JROOT/plugins/system/helix3/helix3.php:247 |
| 9 | plgSystemHelix3->getTemplateName() | JROOT/plugins/system/helix3/helix3.php:41 |
| 8 | plgSystemHelix3->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.31 ms Dopo l'ultima query: 0.92 ms Memoria query: 0.080 MB memoria prima della query: 2.192 MB Righe restituite: 29
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 lr1xn_menu AS m
LEFT JOIN lr1xn_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 90 | Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.m.component_id | 1 | |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.28 ms |
| Sending data | 0.30 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.03 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 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}() | Chiamata uguale alla linea sottostante. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
| 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
| 10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
| 8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.61 ms Dopo l'ultima query: 3.25 ms Memoria query: 0.030 MB memoria prima della query: 2.499 MB Righe restituite: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `lr1xn_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | lr1xn_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.04 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 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}() | Chiamata uguale alla linea sottostante. |
| 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/j2store/j2store.php:36 |
| 8 | plgSystemJ2Store->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.47 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.009 MB memoria prima della query: 2.496 MB
UPDATE `lr1xn_extensions`
SET `params` = '{\"mediaversion\":\"d2eda6aa08aaa6e0f6e3079e939d7021\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN non possibile sulla query: UPDATE `lr1xn_extensions`
SET `params` = '{\"mediaversion\":\"d2eda6aa08aaa6e0f6e3079e939d7021\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| init | 0.06 ms |
| Updating | 0.08 ms |
| end | 0.01 ms |
| query end | 0.06 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 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/j2store/j2store.php:36 |
| 8 | plgSystemJ2Store->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.59 ms Dopo l'ultima query: 0.67 ms Memoria query: 0.026 MB memoria prima della query: 2.632 MB Righe restituite: 2
SELECT *
FROM lr1xn_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | lr1xn_languages | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| System lock | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.10 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.84 ms Dopo l'ultima query: 0.41 ms Memoria query: 0.030 MB memoria prima della query: 2.655 MB Righe restituite: 4
SELECT id, home, template, s.params
FROM lr1xn_template_styles as s
LEFT JOIN lr1xn_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 3 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | Sql732136_1.s.template,const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.12 ms |
| executing | 0.01 ms |
| Sending data | 0.15 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File e numero di linea |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 9.29 ms Dopo l'ultima query: 13.46 ms Memoria query: 0.033 MB memoria prima della query: 2.761 MB Righe restituite: 4
SELECT c.*, img.fullname AS item_image, img.caption AS image_caption, img.path as image_path, img.fullpath as image_fullpath,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug
FROM lr1xn_djc2_categories AS c
LEFT JOIN (select im1.fullname, im1.caption, im1.type, im1.item_id, im1.path, im1.fullpath
from lr1xn_djc2_images as im1, (select item_id, type, min(ordering) as lowest_order
from lr1xn_djc2_images
group by item_id, type) as im2
where im1.item_id = im2.item_id
and im1.type=im2.type
and im1.ordering = im2.lowest_order
group by im1.type, im1.item_id, im1.path, im1.fullpath) AS img
ON img.item_id = c.id
AND img.type='category'
ORDER BY c.parent_id ASC, c.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 4 | Using temporary; Using filesort |
| 1 | PRIMARY | <derived2> | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 37 | |
| 2 | DERIVED | <derived3> | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 37 | Using temporary; Using filesort |
| 2 | DERIVED | im1 | ref | type_item,item_type | type_item | 198 | im2.type,im2.item_id | 5 | Using where |
| 3 | DERIVED | lr1xn_djc2_images | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 175 | Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.19 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| System lock | 0.12 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.03 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.97 ms |
| Sorting result | 0.05 ms |
| Sending data | 0.47 ms |
| optimizing | 0.03 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.46 ms |
| executing | 0.01 ms |
| Copying to tmp table | 2.76 ms |
| Sorting result | 0.13 ms |
| Sending data | 0.68 ms |
| removing tmp table | 0.01 ms |
| Sending data | 0.01 ms |
| removing tmp table | 0.29 ms |
| Sending data | 0.01 ms |
| init | 0.06 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.44 ms |
| executing | 0.01 ms |
| Copying to tmp table | 0.51 ms |
| Sorting result | 0.04 ms |
| Sending data | 0.11 ms |
| end | 0.01 ms |
| removing tmp table | 0.19 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File e numero di linea |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:223 |
| 13 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:105 |
| 12 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:141 |
| 11 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/helpers/djcatalog2.php:63 |
| 10 | Djcatalog2Helper::getParams() | JROOT/components/com_djcatalog2/helpers/theme.php:39 |
| 9 | DJCatalog2ThemeHelper::setThemeAssets() | JROOT/components/com_djcatalog2/controller.php:57 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.60 ms Dopo l'ultima query: 28.88 ms Memoria query: 0.024 MB memoria prima della query: 2.893 MB Righe restituite: 0
select alias
from lr1xn_djc2_items_extra_fields
where type='checkbox' or type='radio' or type='select'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| System lock | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File e numero di linea |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/components/com_djcatalog2/controller.php:84 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 8.84 ms Dopo l'ultima query: 10.32 ms Memoria query: 0.033 MB memoria prima della query: 2.930 MB Righe restituite: 3
SELECT c.*, img.fullname AS item_image, img.caption AS image_caption, img.path as image_path, img.fullpath as image_fullpath,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug
FROM lr1xn_djc2_categories AS c
LEFT JOIN (select im1.fullname, im1.caption, im1.type, im1.item_id, im1.path, im1.fullpath
from lr1xn_djc2_images as im1, (select item_id, type, min(ordering) as lowest_order
from lr1xn_djc2_images
group by item_id, type) as im2
where im1.item_id = im2.item_id
and im1.type=im2.type
and im1.ordering = im2.lowest_order
group by im1.type, im1.item_id, im1.path, im1.fullpath) AS img
ON img.item_id = c.id
AND img.type='category'
WHERE c.published=1
ORDER BY c.parent_id ASC, c.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 4 | Using where; Using temporary; Using filesort |
| 1 | PRIMARY | <derived2> | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 37 | |
| 2 | DERIVED | <derived3> | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 37 | Using temporary; Using filesort |
| 2 | DERIVED | im1 | ref | type_item,item_type | type_item | 198 | im2.type,im2.item_id | 5 | Using where |
| 3 | DERIVED | lr1xn_djc2_images | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 175 | Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.19 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| System lock | 0.14 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| executing | 0.01 ms |
| Copying to tmp table | 1.49 ms |
| Sorting result | 0.05 ms |
| Sending data | 0.91 ms |
| optimizing | 0.03 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.37 ms |
| executing | 0.00 ms |
| Copying to tmp table | 1.76 ms |
| Sorting result | 0.10 ms |
| Sending data | 0.99 ms |
| removing tmp table | 0.01 ms |
| Sending data | 0.00 ms |
| removing tmp table | 0.31 ms |
| Sending data | 0.01 ms |
| init | 0.05 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.26 ms |
| executing | 0.00 ms |
| Copying to tmp table | 1.00 ms |
| Sorting result | 0.04 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| removing tmp table | 0.23 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:223 |
| 13 | Djc2Categories->getCategories() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:105 |
| 12 | Djc2Categories->__construct() | JROOT/administrator/components/com_djcatalog2/lib/categories.php:141 |
| 11 | Djc2Categories::getInstance() | JROOT/components/com_djcatalog2/views/items/view.html.php:93 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.86 ms Dopo l'ultima query: 1.21 ms Memoria query: 0.032 MB memoria prima della query: 2.970 MB Righe restituite: 0
SELECT f.*, group_concat(fo.id
order by fo.ordering asc separator '|') as options
FROM lr1xn_djc2_items_extra_fields as f
LEFT JOIN lr1xn_djc2_items_extra_fields_options as fo
ON fo.field_id=f.id
WHERE f.published = 1
GROUP BY f.id
ORDER BY f.group_id asc, f.ordering asc, fo.ordering asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.17 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| System lock | 0.03 ms |
| init | 0.05 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.00 ms |
| executing | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File e numero di linea |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:519 |
| 15 | DJCatalog2ModelItems->getAttributes() | JROOT/components/com_djcatalog2/models/items.php:222 |
| 14 | DJCatalog2ModelItems->buildQuery() | JROOT/components/com_djcatalog2/models/items.php:190 |
| 13 | DJCatalog2ModelItems->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
| 12 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/components/com_djcatalog2/models/items.php:170 |
| 11 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:107 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 5.71 ms Dopo l'ultima query: 0.40 ms Memoria query: 0.099 MB memoria prima della query: 2.982 MB Righe restituite: 13
SELECT distinct i.*,
CASE WHEN (i.special_price > 0.0
AND i.special_price < i.price) THEN special_price ELSE price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email
FROM lr1xn_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM lr1xn_djc2_items_categories AS ic
INNER JOIN lr1xn_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND ic.category_id =1) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN lr1xn_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN lr1xn_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN lr1xn_users AS ua
ON ua.id = i.created_by
WHERE i.published = 1
ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | p | system | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 0 | const row not found |
| 1 | PRIMARY | <derived2> | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 21 | Using temporary; Using filesort |
| 1 | PRIMARY | i | eq_ref | PRIMARY | PRIMARY | 4 | category_filter.item_id | 1 | Using where |
| 1 | PRIMARY | c | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.i.cat_id | 1 | |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.i.created_by | 1 | |
| 2 | DERIVED | c | const | PRIMARY | PRIMARY | 4 | | 1 | |
| 2 | DERIVED | ic | ref | PRIMARY | PRIMARY | 4 | | 20 | Using index |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.10 ms |
| System lock | 0.06 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 1.50 ms |
| init | 0.07 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.49 ms |
| executing | 0.00 ms |
| Copying to tmp table | 1.28 ms |
| Sorting result | 0.12 ms |
| Sending data | 0.84 ms |
| end | 0.01 ms |
| removing tmp table | 0.40 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.05 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File e numero di linea |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:154 |
| 12 | DJCatalog2ModelItems->_getList() | JROOT/components/com_djcatalog2/models/items.php:172 |
| 11 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:107 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.65 ms Dopo l'ultima query: 0.76 ms Memoria query: 0.029 MB memoria prima della query: 3.128 MB Righe restituite: 0
SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value
FROM lr1xn_djc2_items_extra_fields_values_int as fieldvalues
INNER JOIN lr1xn_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN lr1xn_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
LEFT JOIN lr1xn_djc2_items_extra_fields_options as fieldoptions
ON fieldoptions.id = fieldvalues.value
AND fieldoptions.field_id = fields.id
WHERE fieldvalues.item_id IN (1,3,12,15,19,21,32,33,8,17,18,30,27)
AND (fields.visibility = 2 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fieldvalues.field_id asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| System lock | 0.01 ms |
| init | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:563 |
| 12 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:184 |
| 11 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:107 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.52 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.029 MB memoria prima della query: 3.139 MB Righe restituite: 0
SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM lr1xn_djc2_items_extra_fields_values_text as fieldvalues
INNER JOIN lr1xn_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN lr1xn_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
WHERE fieldvalues.item_id IN (1,3,12,15,19,21,32,33,8,17,18,30,27)
AND (fields.visibility = 2 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fieldvalues.field_id asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:566 |
| 12 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:184 |
| 11 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:107 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.51 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.029 MB memoria prima della query: 3.149 MB Righe restituite: 0
SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM lr1xn_djc2_items_extra_fields_values_date as fieldvalues
INNER JOIN lr1xn_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN lr1xn_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
WHERE fieldvalues.item_id IN (1,3,12,15,19,21,32,33,8,17,18,30,27)
AND (fields.visibility = 2 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fieldvalues.field_id asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:569 |
| 12 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:184 |
| 11 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:107 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 11.04 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.029 MB memoria prima della query: 3.162 MB Righe restituite: 13
SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM lr1xn_djc2_items as i
INNER JOIN (select im1.fullname, im1.caption, im1.type, im1.item_id, im1.path, im1.fullpath
from lr1xn_djc2_images as im1, (select item_id, type, min(ordering) as lowest_order
from lr1xn_djc2_images
group by item_id, type) as im2
where im1.item_id = im2.item_id
and im1.type=im2.type
and im1.ordering = im2.lowest_order
group by im1.type, im1.item_id, im1.path, im1.fullpath) AS img
ON img.item_id = i.id
AND img.type='item'
WHERE i.id IN (1,3,12,15,19,21,32,33,8,17,18,30,27)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | <derived2> | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 37 | Using where |
| 1 | PRIMARY | i | eq_ref | PRIMARY | PRIMARY | 4 | img.item_id | 1 | Using index |
| 2 | DERIVED | <derived3> | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 37 | Using temporary; Using filesort |
| 2 | DERIVED | im1 | ref | type_item,item_type | type_item | 198 | im2.type,im2.item_id | 5 | Using where |
| 3 | DERIVED | lr1xn_djc2_images | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 175 | Using temporary; Using filesort |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| System lock | 0.07 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| Creating tmp table | 0.02 ms |
| executing | 0.00 ms |
| Copying to tmp table | 3.71 ms |
| Sorting result | 0.13 ms |
| Sending data | 1.60 ms |
| optimizing | 0.04 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.52 ms |
| executing | 0.00 ms |
| Copying to tmp table | 1.54 ms |
| Sorting result | 0.18 ms |
| Sending data | 1.82 ms |
| removing tmp table | 0.02 ms |
| Sending data | 0.01 ms |
| removing tmp table | 0.51 ms |
| Sending data | 0.01 ms |
| init | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.06 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:597 |
| 12 | DJCatalog2ModelItems->bindAttributes() | JROOT/components/com_djcatalog2/models/items.php:184 |
| 11 | DJCatalog2ModelItems->getItems() | JROOT/components/com_djcatalog2/views/items/view.html.php:107 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 5.09 ms Dopo l'ultima query: 1.70 ms Memoria query: 0.027 MB memoria prima della query: 3.175 MB Righe restituite: 1
SELECT COUNT(distinct (i.id))
FROM lr1xn_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM lr1xn_djc2_items_categories AS ic
INNER JOIN lr1xn_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND ic.category_id =1) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN lr1xn_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN lr1xn_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN lr1xn_users AS ua
ON ua.id = i.created_by
WHERE i.published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | p | system | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 0 | const row not found |
| 1 | PRIMARY | <derived2> | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 21 | |
| 1 | PRIMARY | i | eq_ref | PRIMARY | PRIMARY | 4 | category_filter.item_id | 1 | Using where |
| 1 | PRIMARY | c | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.i.cat_id | 1 | Using index |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.i.created_by | 1 | Using index |
| 2 | DERIVED | c | const | PRIMARY | PRIMARY | 4 | | 1 | |
| 2 | DERIVED | ic | ref | PRIMARY | PRIMARY | 4 | | 20 | Using index |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.06 ms |
| System lock | 0.08 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 2.35 ms |
| init | 0.06 ms |
| optimizing | 0.04 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.17 ms |
| Sending data | 1.62 ms |
| end | 0.01 ms |
| removing tmp table | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.04 ms |
| freeing items | 0.05 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File e numero di linea |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 14 | JDatabaseDriver->loadResult() | JROOT/components/com_djcatalog2/models/items.php:206 |
| 13 | DJCatalog2ModelItems->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:289 |
| 12 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:239 |
| 11 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_djcatalog2/views/items/view.html.php:109 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.69 ms Dopo l'ultima query: 1.35 ms Memoria query: 0.026 MB memoria prima della query: 3.183 MB Righe restituite: 0
SELECT DISTINCT p.id, p.name as text,
CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as value
FROM lr1xn_djc2_producers as p
INNER JOIN lr1xn_djc2_items AS i
ON p.id = i.producer_id
INNER JOIN lr1xn_djc2_items_categories AS c
ON c.item_id = i.id
WHERE c.category_id IN (1)
AND p.published=1
GROUP BY p.id, p.name
ORDER BY p.name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.20 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.02 ms |
| init | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:639 |
| 11 | DJCatalog2ModelItems->getProducers() | JROOT/components/com_djcatalog2/views/items/view.html.php:146 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.38 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.026 MB memoria prima della query: 3.192 MB Righe restituite: 0
SELECT DISTINCT p.id, p.name as text,
CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as value
FROM lr1xn_djc2_producers as p
INNER JOIN lr1xn_djc2_items AS i
ON p.id = i.producer_id
INNER JOIN lr1xn_djc2_items_categories AS c
ON c.item_id = i.id
WHERE c.category_id IN (1)
AND p.published=1
GROUP BY p.id, p.name
ORDER BY p.name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:640 |
| 11 | DJCatalog2ModelItems->getProducers() | JROOT/components/com_djcatalog2/views/items/view.html.php:146 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.38 ms Dopo l'ultima query: 0.56 ms Memoria query: 0.030 MB memoria prima della query: 3.222 MB Righe restituite: 0
SELECT f.*, group_concat(fo.id
order by fo.ordering asc separator '|') as options
FROM lr1xn_djc2_items_extra_fields as f
LEFT JOIN lr1xn_djc2_items_extra_fields_options as fo
ON fo.field_id=f.id
WHERE f.published = 1
GROUP BY f.id
ORDER BY f.group_id asc, f.ordering asc, fo.ordering asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:519 |
| 13 | DJCatalog2ModelItems->getAttributes() | JROOT/components/com_djcatalog2/models/items.php:222 |
| 12 | DJCatalog2ModelItems->buildQuery() | JROOT/components/com_djcatalog2/models/items.php:738 |
| 11 | DJCatalog2ModelItems->getIndexCount() | JROOT/components/com_djcatalog2/views/items/view.html.php:150 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 13.44 ms Dopo l'ultima query: 0.52 ms Memoria query: 0.031 MB memoria prima della query: 3.244 MB Righe restituite: 1
SELECT count(a.id) as a, count(b.id) as b, count(c.id) as c, count(d.id) as d, count(e.id) as e, count(f.id) as f, count(g.id) as g, count(h.id) as h, count(i.id) as i, count(j.id) as j, count(k.id) as k, count(l.id) as l, count(m.id) as m, count(n.id) as n, count(o.id) as o, count(p.id) as p, count(q.id) as q, count(r.id) as r, count(s.id) as s, count(t.id) as t, count(u.id) as u, count(v.id) as v, count(w.id) as w, count(x.id) as x, count(y.id) as y, count(z.id) as z
FROM lr1xn_djc2_items as items
left join lr1xn_djc2_items as a
on a.id = items.id
and lower(a.name) like 'a%'
left join lr1xn_djc2_items as b
on b.id = items.id
and lower(b.name) like 'b%'
left join lr1xn_djc2_items as c
on c.id = items.id
and lower(c.name) like 'c%'
left join lr1xn_djc2_items as d
on d.id = items.id
and lower(d.name) like 'd%'
left join lr1xn_djc2_items as e
on e.id = items.id
and lower(e.name) like 'e%'
left join lr1xn_djc2_items as f
on f.id = items.id
and lower(f.name) like 'f%'
left join lr1xn_djc2_items as g
on g.id = items.id
and lower(g.name) like 'g%'
left join lr1xn_djc2_items as h
on h.id = items.id
and lower(h.name) like 'h%'
left join lr1xn_djc2_items as i
on i.id = items.id
and lower(i.name) like 'i%'
left join lr1xn_djc2_items as j
on j.id = items.id
and lower(j.name) like 'j%'
left join lr1xn_djc2_items as k
on k.id = items.id
and lower(k.name) like 'k%'
left join lr1xn_djc2_items as l
on l.id = items.id
and lower(l.name) like 'l%'
left join lr1xn_djc2_items as m
on m.id = items.id
and lower(m.name) like 'm%'
left join lr1xn_djc2_items as n
on n.id = items.id
and lower(n.name) like 'n%'
left join lr1xn_djc2_items as o
on o.id = items.id
and lower(o.name) like 'o%'
left join lr1xn_djc2_items as p
on p.id = items.id
and lower(p.name) like 'p%'
left join lr1xn_djc2_items as q
on q.id = items.id
and lower(q.name) like 'q%'
left join lr1xn_djc2_items as r
on r.id = items.id
and lower(r.name) like 'r%'
left join lr1xn_djc2_items as s
on s.id = items.id
and lower(s.name) like 's%'
left join lr1xn_djc2_items as t
on t.id = items.id
and lower(t.name) like 't%'
left join lr1xn_djc2_items as u
on u.id = items.id
and lower(u.name) like 'u%'
left join lr1xn_djc2_items as v
on v.id = items.id
and lower(v.name) like 'v%'
left join lr1xn_djc2_items as w
on w.id = items.id
and lower(w.name) like 'w%'
left join lr1xn_djc2_items as x
on x.id = items.id
and lower(x.name) like 'x%'
left join lr1xn_djc2_items as y
on y.id = items.id
and lower(y.name) like 'y%'
left join lr1xn_djc2_items as z
on z.id = items.id
and lower(z.name) like 'z%'
where items.id in (
SELECT i.id
FROM lr1xn_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM lr1xn_djc2_items_categories AS ic
INNER JOIN lr1xn_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND ic.category_id =1) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN lr1xn_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN lr1xn_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN lr1xn_users AS ua
ON ua.id = i.created_by
WHERE i.published = 1
ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | items | index | NULL | PRIMARY | 4 | NULL | 35 | Using where; Using index |
| 1 | PRIMARY | a | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | b | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | c | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | d | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | e | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | f | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | g | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | h | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | i | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | j | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | k | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | l | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | m | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | n | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | o | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | p | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | q | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | r | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | s | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | t | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | u | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | w | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | x | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | y | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 1 | PRIMARY | z | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.items.id | 1 | |
| 2 | DEPENDENT SUBQUERY | p | system | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 0 | const row not found |
| 2 | DEPENDENT SUBQUERY | <derived3> | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 21 | Using where |
| 2 | DEPENDENT SUBQUERY | i | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | Using where |
| 2 | DEPENDENT SUBQUERY | c | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.i.cat_id | 1 | |
| 2 | DEPENDENT SUBQUERY | ua | eq_ref | PRIMARY | PRIMARY | 4 | Sql732136_1.i.created_by | 1 | Using where; Using index |
| 3 | DERIVED | c | const | PRIMARY | PRIMARY | 4 | | 1 | |
| 3 | DERIVED | ic | ref | PRIMARY | PRIMARY | 4 | | 20 | Using index |
| Status | Duration |
|---|
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.38 ms |
| System lock | 0.17 ms |
| optimizing | 0.02 ms |
| statistics | 0.12 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 1.48 ms |
| init | 0.29 ms |
| optimizing | 0.05 ms |
| statistics | 0.09 ms |
| preparing | 0.19 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.43 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.16 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.19 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.17 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.42 ms |
| executing | 0.01 ms |
| Sending data | 0.73 ms |
| executing | 0.01 ms |
| Sending data | 1.24 ms |
| executing | 0.02 ms |
| Sending data | 1.27 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.79 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 1.00 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.27 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.31 ms |
| executing | 0.00 ms |
| Sending data | 0.26 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.12 ms |
| freeing items | 0.16 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 12 | JDatabaseDriver->loadAssoc() | JROOT/components/com_djcatalog2/models/items.php:750 |
| 11 | DJCatalog2ModelItems->getIndexCount() | JROOT/components/com_djcatalog2/views/items/view.html.php:150 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.93 ms Dopo l'ultima query: 1.29 ms Memoria query: 0.029 MB memoria prima della query: 3.232 MB Righe restituite: 0
SELECT f.*, group_concat(fo.id
order by fo.ordering asc separator '|') as options
FROM lr1xn_djc2_items_extra_fields as f
LEFT JOIN lr1xn_djc2_items_extra_fields_options as fo
ON fo.field_id=f.id
WHERE (f.visibility = 2 or f.visibility = 3)
and f.published = 1
GROUP BY f.id
ORDER BY f.group_id asc, f.ordering asc, fo.ordering asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.18 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| System lock | 0.02 ms |
| init | 0.08 ms |
| optimizing | 0.04 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.12 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File e numero di linea |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/models/items.php:519 |
| 11 | DJCatalog2ModelItems->getAttributes() | JROOT/components/com_djcatalog2/views/items/view.html.php:169 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.66 ms Dopo l'ultima query: 10.41 ms Memoria query: 0.029 MB memoria prima della query: 3.378 MB Righe restituite: 1
SELECT *
FROM lr1xn_djc2_images
WHERE item_id=1
AND type='category'
ORDER BY ordering ASC, name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | lr1xn_djc2_images | ref | type_item,item_type | type_item | 198 | const,const | 1 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.14 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| System lock | 0.03 ms |
| init | 0.06 ms |
| optimizing | 0.02 ms |
| statistics | 0.20 ms |
| preparing | 0.06 ms |
| executing | 0.02 ms |
| Sorting result | 0.30 ms |
| Sending data | 0.15 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.04 ms |
| freeing items | 0.14 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File e numero di linea |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_djcatalog2/helpers/image.php:195 |
| 12 | DJCatalog2ImageHelper::getImages() | JROOT/components/com_djcatalog2/views/items/view.html.php:288 |
| 11 | DJCatalog2ViewItems->_prepareDocument() | JROOT/components/com_djcatalog2/views/items/view.html.php:170 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.43 ms Dopo l'ultima query: 2.96 ms Memoria query: 0.032 MB memoria prima della query: 3.427 MB Righe restituite: 26
select id, producer_id
from lr1xn_djc2_items
where published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | lr1xn_djc2_items | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 35 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File e numero di linea |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_djcatalog2/helpers/route.php:65 |
| 16 | DJCatalogHelperRoute::getItemRoute() | JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php:73 |
| 15 | include JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 14 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/components/com_djcatalog2/views/items/tmpl/default.php:123 |
| 13 | include JROOT/components/com_djcatalog2/views/items/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_djcatalog2/views/items/view.html.php:172 |
| 10 | DJCatalog2ViewItems->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_djcatalog2/controller.php:94 |
| 8 | DJCatalog2Controller->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_djcatalog2/djcatalog2.php:55 |
| 6 | require_once JROOT/components/com_djcatalog2/djcatalog2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 3.00 ms Dopo l'ultima query: 50.26 ms Memoria query: 0.070 MB memoria prima della query: 3.512 MB Righe restituite: 46
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM lr1xn_modules AS m
LEFT JOIN lr1xn_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN lr1xn_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 <= '2025-04-28 07:17:22')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-28 07:17:22')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 204 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 60 | Using where; Using filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | Sql732136_1.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | Sql732136_1.m.module,const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.01 ms |
| init | 0.05 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sorting result | 1.40 ms |
| Sending data | 0.68 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.05 ms |
| freeing items | 0.07 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File e numero di linea |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | Chiamata uguale alla linea sottostante. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
| 11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
| 10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
| 8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/protostar/index.php:91 |
| 7 | require JROOT/templates/protostar/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
3 × SELECT f.*, group_concat(fo.id
order by fo.ordering asc separator '|') as options
FROM lr1xn_djc2_items_extra_fields as f
LEFT JOIN lr1xn_djc2_items_extra_fields_options as fo
ON fo.field_id=f.id
2 × SELECT DISTINCT p.id, p.name as text,
CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as value
FROM lr1xn_djc2_producers as p
INNER JOIN lr1xn_djc2_items AS i
ON p.id = i.producer_id
INNER JOIN lr1xn_djc2_items_categories AS c
ON c.item_id = i.id
2 × SELECT c.*, img.fullname AS item_image, img.caption AS image_caption, img.path as image_path, img.fullpath as image_fullpath,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug
FROM lr1xn_djc2_categories AS c
LEFT JOIN (select im1.fullname, im1.caption, im1.type, im1.item_id, im1.path, im1.fullpath
from lr1xn_djc2_images as im1, (select item_id, type, min(ordering) as lowest_order
from lr1xn_djc2_images
group by item_id, type) as im2
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `lr1xn_extensions`
1 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value
FROM lr1xn_djc2_items_extra_fields_values_int as fieldvalues
INNER JOIN lr1xn_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN lr1xn_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
LEFT JOIN lr1xn_djc2_items_extra_fields_options as fieldoptions
ON fieldoptions.id = fieldvalues.value
AND fieldoptions.field_id = fields.id
1 × select id, producer_id
from lr1xn_djc2_items
1 × SELECT *
FROM lr1xn_djc2_images
1 × SELECT count(a.id) as a, count(b.id) as b, count(c.id) as c, count(d.id) as d, count(e.id) as e, count(f.id) as f, count(g.id) as g, count(h.id) as h, count(i.id) as i, count(j.id) as j, count(k.id) as k, count(l.id) as l, count(m.id) as m, count(n.id) as n, count(o.id) as o, count(p.id) as p, count(q.id) as q, count(r.id) as r, count(s.id) as s, count(t.id) as t, count(u.id) as u, count(v.id) as v, count(w.id) as w, count(x.id) as x, count(y.id) as y, count(z.id) as z
FROM lr1xn_djc2_items as items
left join lr1xn_djc2_items as a
on a.id = items.id
and lower(a.name) like 'a%'
left join lr1xn_djc2_items as b
on b.id = items.id
and lower(b.name) like 'b%'
left join lr1xn_djc2_items as c
on c.id = items.id
and lower(c.name) like 'c%'
left join lr1xn_djc2_items as d
on d.id = items.id
and lower(d.name) like 'd%'
left join lr1xn_djc2_items as e
on e.id = items.id
and lower(e.name) like 'e%'
left join lr1xn_djc2_items as f
on f.id = items.id
and lower(f.name) like 'f%'
left join lr1xn_djc2_items as g
on g.id = items.id
and lower(g.name) like 'g%'
left join lr1xn_djc2_items as h
on h.id = items.id
and lower(h.name) like 'h%'
left join lr1xn_djc2_items as i
on i.id = items.id
and lower(i.name) like 'i%'
left join lr1xn_djc2_items as j
on j.id = items.id
and lower(j.name) like 'j%'
left join lr1xn_djc2_items as k
on k.id = items.id
and lower(k.name) like 'k%'
left join lr1xn_djc2_items as l
on l.id = items.id
and lower(l.name) like 'l%'
left join lr1xn_djc2_items as m
on m.id = items.id
and lower(m.name) like 'm%'
left join lr1xn_djc2_items as n
on n.id = items.id
and lower(n.name) like 'n%'
left join lr1xn_djc2_items as o
on o.id = items.id
and lower(o.name) like 'o%'
left join lr1xn_djc2_items as p
on p.id = items.id
and lower(p.name) like 'p%'
left join lr1xn_djc2_items as q
on q.id = items.id
and lower(q.name) like 'q%'
left join lr1xn_djc2_items as r
on r.id = items.id
and lower(r.name) like 'r%'
left join lr1xn_djc2_items as s
on s.id = items.id
and lower(s.name) like 's%'
left join lr1xn_djc2_items as t
on t.id = items.id
and lower(t.name) like 't%'
left join lr1xn_djc2_items as u
on u.id = items.id
and lower(u.name) like 'u%'
left join lr1xn_djc2_items as v
on v.id = items.id
and lower(v.name) like 'v%'
left join lr1xn_djc2_items as w
on w.id = items.id
and lower(w.name) like 'w%'
left join lr1xn_djc2_items as x
on x.id = items.id
and lower(x.name) like 'x%'
left join lr1xn_djc2_items as y
on y.id = items.id
and lower(y.name) like 'y%'
left join lr1xn_djc2_items as z
on z.id = items.id
and lower(z.name) like 'z%'
1 × SELECT COUNT(distinct (i.id))
FROM lr1xn_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM lr1xn_djc2_items_categories AS ic
INNER JOIN lr1xn_djc2_categories AS c
ON c.id=ic.category_id
1 × SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM lr1xn_djc2_items as i
INNER JOIN (select im1.fullname, im1.caption, im1.type, im1.item_id, im1.path, im1.fullpath
from lr1xn_djc2_images as im1, (select item_id, type, min(ordering) as lowest_order
from lr1xn_djc2_images
group by item_id, type) as im2
1 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM lr1xn_djc2_items_extra_fields_values_date as fieldvalues
INNER JOIN lr1xn_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN lr1xn_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
1 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM lr1xn_djc2_items_extra_fields_values_text as fieldvalues
INNER JOIN lr1xn_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN lr1xn_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
1 × SELECT `data`
FROM `lr1xn_session`
1 × SELECT distinct i.*,
CASE WHEN (i.special_price > 0.0
AND i.special_price < i.price) THEN special_price ELSE price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email
FROM lr1xn_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM lr1xn_djc2_items_categories AS ic
INNER JOIN lr1xn_djc2_categories AS c
ON c.id=ic.category_id
1 × select alias
from lr1xn_djc2_items_extra_fields
1 × SELECT id, home, template, s.params
FROM lr1xn_template_styles as s
LEFT JOIN lr1xn_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM lr1xn_languages
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 lr1xn_menu AS m
LEFT JOIN lr1xn_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `template`
FROM `lr1xn_template_styles`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM lr1xn_extensions
1 × SELECT b.id
FROM lr1xn_usergroups AS a
LEFT JOIN lr1xn_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `lr1xn_viewlevels
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM lr1xn_modules AS m
LEFT JOIN lr1xn_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN lr1xn_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
