Tempo della query: 1.66 ms Memoria query: 0.023 MB memoria prima della query: 1.587 MB Righe restituite: 0
SELECT `data`
FROM `h06jz_session`
WHERE `session_id` = X'3139336662656364626462363162633765353061393230616239303539323036'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_session | const | PRIMARY | PRIMARY | 602 | const | 1 | |
Status | Duration |
---|
Starting | 0.21 ms |
checking permissions | 0.06 ms |
Opening tables | 0.09 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
table lock | 0.05 ms |
init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.62 ms |
Preparing | 0.05 ms |
Executing | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 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.97 ms Dopo l'ultima query: 4.04 ms Memoria query: 0.020 MB memoria prima della query: 1.666 MB Righe restituite: 0
SELECT `session_id`
FROM `h06jz_session`
WHERE `session_id` = X'3139336662656364626462363162633765353061393230616239303539323036'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_session | const | PRIMARY | PRIMARY | 602 | const | 1 | Using index |
Status | Duration |
---|
Starting | 0.17 ms |
checking permissions | 0.05 ms |
Opening tables | 0.06 ms |
After opening tables | 0.04 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init | 0.05 ms |
Optimizing | 0.05 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.03 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Tempo della query: 1.53 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.004 MB memoria prima della query: 1.671 MB
INSERT INTO `h06jz_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3139336662656364626462363162633765353061393230616239303539323036', 1, 1685666450, 0, '', 0)
EXPLAIN non possibile sulla query: INSERT INTO `h06jz_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3139336662656364626462363162633765353061393230616239303539323036', 1, 1685666450, 0, '', 0)
Status | Duration |
---|
Starting | 0.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init for update | 0.03 ms |
Update | 0.97 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.07 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Tempo della query: 3.06 ms Dopo l'ultima query: 12.76 ms Memoria query: 0.040 MB memoria prima della query: 1.723 MB Righe restituite: 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `h06jz_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 | h06jz_extensions | ref | extension | extension | 62 | const | 44 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.21 ms |
checking permissions | 0.06 ms |
Opening tables | 0.08 ms |
After opening tables | 0.04 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.04 ms |
Statistics | 0.33 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 1.89 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 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: 1.11 ms Dopo l'ultima query: 7.79 ms Memoria query: 0.021 MB memoria prima della query: 1.836 MB Righe restituite: 5
SELECT id, rules
FROM `h06jz_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_viewlevels | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 5 | |
Status | Duration |
---|
Starting | 0.18 ms |
checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.04 ms |
System lock | 0.04 ms |
table lock | 0.03 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.04 ms |
Executing | 0.03 ms |
Sending data | 0.23 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 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: 1.32 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 1.848 MB Righe restituite: 2
SELECT b.id
FROM h06jz_usergroups AS a
LEFT JOIN h06jz_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 | 2 | Using where; Using index |
Status | Duration |
---|
Starting | 0.14 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.51 ms |
Preparing | 0.03 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.06 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.06 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.08 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 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: 2.43 ms Dopo l'ultima query: 2.62 ms Memoria query: 0.030 MB memoria prima della query: 1.881 MB Righe restituite: 89
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM h06jz_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 | h06jz_extensions | ALL | extension | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 256 | Using where; Using filesort |
Status | Duration |
---|
Starting | 0.15 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
Creating sort index | 1.60 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 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: 14.44 ms Dopo l'ultima query: 112.73 ms Memoria query: 0.060 MB memoria prima della query: 3.885 MB Righe restituite: 13
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 h06jz_menu AS m
LEFT JOIN h06jz_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 | 40 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | u457630568_offic.m.component_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.20 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 7.40 ms |
Preparing | 0.15 ms |
Sorting result | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.07 ms |
Creating sort index | 5.79 ms |
End of update loop | 0.10 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.08 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 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: 66.70 ms Dopo l'ultima query: 171.47 ms Memoria query: 0.025 MB memoria prima della query: 4.174 MB Righe restituite: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `h06jz_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.20 ms |
checking permissions | 0.06 ms |
Opening tables | 0.06 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
table lock | 0.05 ms |
init | 0.06 ms |
Optimizing | 0.06 ms |
Statistics | 65.29 ms |
Preparing | 0.14 ms |
Executing | 0.05 ms |
Sending data | 0.11 ms |
End of update loop | 0.06 ms |
Query end | 0.04 ms |
Commit | 0.04 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.09 ms |
Updating status | 0.05 ms |
Reset for next command | 0.03 ms |
# | Caller | File e numero di linea |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
20 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
19 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Chiamata uguale alla linea sottostante. |
18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
16 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
15 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
14 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
11 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/nrframework/NRFramework/Functions.php:336 |
10 | NRFramework\Functions::isFeed() | JROOT/plugins/system/convertforms/convertforms.php:457 |
9 | PlgSystemConvertForms->getHelper() | JROOT/plugins/system/convertforms/convertforms.php:101 |
8 | PlgSystemConvertForms->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.78 ms Dopo l'ultima query: 0.41 ms Memoria query: 0.007 MB memoria prima della query: 4.168 MB
UPDATE `h06jz_extensions`
SET `params` = '{\"mediaversion\":\"ab5affcd45170d12a6551a2b5d76dc73\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN non possibile sulla query: UPDATE `h06jz_extensions`
SET `params` = '{\"mediaversion\":\"ab5affcd45170d12a6551a2b5d76dc73\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
Starting | 0.13 ms |
checking permissions | 0.03 ms |
Opening tables | 0.04 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.03 ms |
init for update | 0.10 ms |
Updating | 0.10 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.06 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
15 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
14 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
13 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
12 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
11 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/nrframework/NRFramework/Functions.php:336 |
10 | NRFramework\Functions::isFeed() | JROOT/plugins/system/convertforms/convertforms.php:457 |
9 | PlgSystemConvertForms->getHelper() | JROOT/plugins/system/convertforms/convertforms.php:101 |
8 | PlgSystemConvertForms->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: 24.36 ms Dopo l'ultima query: 8.12 ms Memoria query: 0.021 MB memoria prima della query: 4.348 MB Righe restituite: 4
SELECT id, home, template, s.params
FROM h06jz_template_styles as s
LEFT JOIN h06jz_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 | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 6 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | u457630568_offic.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.27 ms |
checking permissions | 0.06 ms |
Opening tables | 0.08 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
table lock | 0.03 ms |
init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.09 ms |
Preparing | 0.05 ms |
Executing | 0.02 ms |
Sending data | 22.93 ms |
End of update loop | 0.10 ms |
Query end | 0.05 ms |
Commit | 0.06 ms |
closing tables | 0.05 ms |
Unlocking tables | 0.04 ms |
closing tables | 0.06 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.09 ms |
Updating status | 0.05 ms |
Reset for next command | 0.03 ms |
# | Caller | File e numero di linea |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/plazart/includes/core/plazart.php:230 |
9 | Plazart::detect() | JROOT/plugins/system/plazart/plazart.php:55 |
8 | plgSystemPlazart->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: 31.32 ms Dopo l'ultima query: 3.08 ms Memoria query: 0.020 MB memoria prima della query: 4.387 MB Righe restituite: 2
SELECT *
FROM h06jz_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_languages | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 2 | Using where; Using filesort |
Status | Duration |
---|
Starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
Creating sort index | 30.30 ms |
End of update loop | 0.11 ms |
Query end | 0.06 ms |
Commit | 0.06 ms |
closing tables | 0.05 ms |
Unlocking tables | 0.05 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.10 ms |
Updating status | 0.06 ms |
Reset for next command | 0.04 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: 19.29 ms Dopo l'ultima query: 19.86 ms Memoria query: 0.028 MB memoria prima della query: 4.541 MB Righe restituite: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `h06jz_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_fields','com_finder','com_formmaker','com_gsd','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend_installer','com_osgallery','com_osmap','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_smartslider3','com_sppagebuilder','com_tags','com_templates','com_tz_portfolio','com_users','com_weblinks','com_wrapper','com_zhgooglemap')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_assets | ALL | idx_asset_name | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 265 | Using where |
Status | Duration |
---|
Starting | 0.24 ms |
checking permissions | 0.06 ms |
Opening tables | 0.09 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
table lock | 0.05 ms |
init | 0.10 ms |
Optimizing | 0.05 ms |
Statistics | 0.12 ms |
Preparing | 0.05 ms |
Executing | 0.04 ms |
Sending data | 17.90 ms |
End of update loop | 0.12 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_sppagebuilder/models/page.php:45 |
11 | SppagebuilderModelPage->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_sppagebuilder/models/page.php:159 |
9 | SppagebuilderModelPage->hit() | JROOT/components/com_sppagebuilder/controller.php:43 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.25 ms Dopo l'ultima query: 2.65 ms Memoria query: 0.027 MB memoria prima della query: 4.604 MB Righe restituite: 25
SHOW FULL COLUMNS
FROM `h06jz_sppagebuilder`
EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `h06jz_sppagebuilder`
Status | Duration |
---|
Starting | 0.14 ms |
checking permissions | 0.04 ms |
closing tables | 0.03 ms |
Opening tables | 0.23 ms |
After opening tables | 0.03 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
Filling schema table | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
checking permissions | 0.12 ms |
closing tables | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.06 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.09 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_sppagebuilder/tables/page.php:19 |
11 | SppagebuilderTablePage->__construct() | JROOT/libraries/src/Table/Table.php:328 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_sppagebuilder/models/page.php:160 |
9 | SppagebuilderModelPage->hit() | JROOT/components/com_sppagebuilder/controller.php:43 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 108.25 ms Dopo l'ultima query: 1.14 ms Memoria query: 0.038 MB memoria prima della query: 4.643 MB Righe restituite: 1
SELECT *
FROM h06jz_sppagebuilder
WHERE `id` = '8'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_sppagebuilder | const | PRIMARY | PRIMARY | 8 | const | 1 | |
Status | Duration |
---|
Starting | 0.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 107.20 ms |
Preparing | 0.14 ms |
Unlocking tables | 0.05 ms |
Preparing | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.10 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
10 | Joomla\CMS\Table\Table->load() | JROOT/components/com_sppagebuilder/models/page.php:161 |
9 | SppagebuilderModelPage->hit() | JROOT/components/com_sppagebuilder/controller.php:43 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.71 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.005 MB memoria prima della query: 4.662 MB
UPDATE h06jz_sppagebuilder
SET `hits` = (`hits` + 1)
WHERE `id` = '8'
EXPLAIN non possibile sulla query: UPDATE h06jz_sppagebuilder
SET `hits` = (`hits` + 1)
WHERE `id` = '8'
Status | Duration |
---|
Starting | 0.14 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
table lock | 0.02 ms |
init for update | 0.07 ms |
Updating | 0.09 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.07 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1264 |
10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_sppagebuilder/models/page.php:162 |
9 | SppagebuilderModelPage->hit() | JROOT/components/com_sppagebuilder/controller.php:43 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 66.92 ms Dopo l'ultima query: 2.76 ms Memoria query: 0.039 MB memoria prima della query: 4.730 MB Righe restituite: 1
SELECT a.*,l.title AS language_title,ua.name AS author_name
FROM h06jz_sppagebuilder as a
LEFT JOIN `h06jz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN h06jz_users AS ua
ON ua.id = a.created_by
WHERE a.id = 8
AND a.published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 8 | const | 1 | |
1 | SIMPLE | l | const | idx_langcode | idx_langcode | 21 | const | 0 | Unique row not found |
1 | SIMPLE | ua | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.15 ms |
checking permissions | 0.03 ms |
Opening tables | 0.07 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 65.66 ms |
Preparing | 0.12 ms |
Unlocking tables | 0.05 ms |
Preparing | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.12 ms |
End of update loop | 0.05 ms |
Query end | 0.04 ms |
Commit | 0.04 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.08 ms |
Updating status | 0.05 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/models/page.php:107 |
12 | SppagebuilderModelPage->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_sppagebuilder/views/page/view.html.php:43 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 26.16 ms Dopo l'ultima query: 0.94 ms Memoria query: 0.023 MB memoria prima della query: 4.754 MB Righe restituite: 1
SELECT `id`
FROM `h06jz_menu`
WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=8%'
AND `published` = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_menu | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 129 | Using where |
Status | Duration |
---|
Starting | 0.14 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 25.10 ms |
End of update loop | 0.11 ms |
Query end | 0.06 ms |
Commit | 0.07 ms |
closing tables | 0.06 ms |
Unlocking tables | 0.05 ms |
closing tables | 0.06 ms |
Starting cleanup | 0.06 ms |
Freeing items | 0.10 ms |
Updating status | 0.06 ms |
Reset for next command | 0.04 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_sppagebuilder/helpers/route.php:95 |
14 | SppagebuilderHelperRoute::getMenuItemId() | JROOT/components/com_sppagebuilder/helpers/route.php:52 |
13 | SppagebuilderHelperRoute::getPageRoute() | JROOT/components/com_sppagebuilder/models/page.php:126 |
12 | SppagebuilderModelPage->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_sppagebuilder/views/page/view.html.php:43 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 0.95 ms Memoria query: 0.023 MB memoria prima della query: 4.771 MB Righe restituite: 1
SELECT `id`
FROM `h06jz_menu`
WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=8%'
AND `published` = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_menu | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 129 | Using where |
Status | Duration |
---|
Starting | 0.12 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.26 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_sppagebuilder/helpers/route.php:95 |
14 | SppagebuilderHelperRoute::getMenuItemId() | JROOT/components/com_sppagebuilder/helpers/route.php:74 |
13 | SppagebuilderHelperRoute::getFormRoute() | JROOT/components/com_sppagebuilder/models/page.php:127 |
12 | SppagebuilderModelPage->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_sppagebuilder/views/page/view.html.php:43 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.87 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.023 MB memoria prima della query: 4.779 MB Righe restituite: 1
SELECT `id`
FROM `h06jz_menu`
WHERE `link` LIKE '%option=com_sppagebuilder&view=page&id=8%'
AND `published` = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_menu | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 129 | Using where |
Status | Duration |
---|
Starting | 0.12 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.28 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_sppagebuilder/helpers/route.php:95 |
14 | SppagebuilderHelperRoute::getMenuItemId() | JROOT/components/com_sppagebuilder/helpers/route.php:76 |
13 | SppagebuilderHelperRoute::getFormRoute() | JROOT/components/com_sppagebuilder/models/page.php:127 |
12 | SppagebuilderModelPage->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_sppagebuilder/views/page/view.html.php:43 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 74.25 ms Dopo l'ultima query: 0.30 ms Memoria query: 0.025 MB memoria prima della query: 4.786 MB Righe restituite: 14
SELECT `id`,`name`,`rules`,`parent_id`
FROM `h06jz_assets`
WHERE `name` LIKE 'com_sppagebuilder.%' OR `name` = 'com_sppagebuilder' OR `parent_id` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_assets | ALL | idx_asset_name,idx_parent_id | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 265 | Using where |
Status | Duration |
---|
Starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 73.02 ms |
Preparing | 0.12 ms |
Executing | 0.06 ms |
Sending data | 0.32 ms |
End of update loop | 0.05 ms |
Query end | 0.04 ms |
Commit | 0.04 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.09 ms |
Updating status | 0.05 ms |
Reset for next command | 0.03 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
15 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
14 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
13 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
12 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
11 | Joomla\CMS\User\User->authorise() | JROOT/components/com_sppagebuilder/views/page/view.html.php:45 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.41 ms Dopo l'ultima query: 6.15 ms Memoria query: 0.023 MB memoria prima della query: 4.839 MB Righe restituite: 1
SELECT e.manifest_cache,`e`.`manifest_cache`
FROM `h06jz_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 302 | const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.22 ms |
checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
table lock | 0.05 ms |
init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.12 ms |
Preparing | 0.06 ms |
Executing | 0.04 ms |
Sending data | 0.10 ms |
End of update loop | 0.05 ms |
Query end | 0.04 ms |
Commit | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.04 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.09 ms |
Updating status | 0.05 ms |
Reset for next command | 0.03 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_sppagebuilder/helpers/helper.php:79 |
14 | SppagebuilderHelperSite::getVersion() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:41 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.76 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.023 MB memoria prima della query: 4.846 MB Righe restituite: 1
SELECT e.manifest_cache,`e`.`manifest_cache`
FROM `h06jz_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 302 | const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.10 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.06 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_sppagebuilder/helpers/helper.php:79 |
14 | SppagebuilderHelperSite::getVersion() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:42 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 6.94 ms Memoria query: 0.025 MB memoria prima della query: 4.860 MB Righe restituite: 1
SELECT `template`
FROM `h06jz_template_styles`
WHERE `client_id` = 0
AND `home` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_template_styles | ALL | idx_home | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 6 | Using where |
Status | Duration |
---|
Starting | 0.20 ms |
checking permissions | 0.06 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.04 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.08 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.08 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
17 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:622 |
16 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:160 |
15 | AddonParser::getAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:695 |
14 | require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:59 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.87 ms Dopo l'ultima query: 36.37 ms Memoria query: 0.025 MB memoria prima della query: 5.033 MB Righe restituite: 1
SELECT `template`
FROM `h06jz_template_styles`
WHERE `client_id` = '0'
AND `home` = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_template_styles | ref | idx_home | idx_home | 21 | const | 2 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.20 ms |
checking permissions | 0.05 ms |
Opening tables | 0.06 ms |
After opening tables | 0.04 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.84 ms |
Preparing | 0.05 ms |
Executing | 0.03 ms |
Sending data | 0.07 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.02 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
17 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:44 |
16 | SpPgaeBuilderBase::getTemplateName() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:52 |
15 | SpPgaeBuilderBase::loadAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:198 |
14 | AddonParser::viewAddons() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:91 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.81 ms Dopo l'ultima query: 36.97 ms Memoria query: 0.025 MB memoria prima della query: 5.409 MB Righe restituite: 1
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM h06jz_modules AS m
WHERE m.published = 1
AND m.id = 183
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up IS NULL OR m.publish_up <= '2023-06-02 00:40:50')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down IS NULL OR m.publish_down >= '2023-06-02 00:40:50')
AND m.access IN (1,1,5)
AND m.client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | const | PRIMARY,published | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.23 ms |
checking permissions | 0.05 ms |
Opening tables | 0.07 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.07 ms |
Optimizing | 0.06 ms |
Statistics | 2.70 ms |
Preparing | 0.05 ms |
Unlocking tables | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.04 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.09 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_sppagebuilder/addons/module/site.php:104 |
17 | SppagebuilderAddonModule::getModules() | JROOT/components/com_sppagebuilder/addons/module/site.php:31 |
16 | SppagebuilderAddonModule->render() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:463 |
15 | AddonParser::getAddonHtmlView() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:290 |
14 | AddonParser::viewAddons() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:91 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 28.78 ms Dopo l'ultima query: 8.72 ms Memoria query: 0.025 MB memoria prima della query: 5.436 MB Righe restituite: 1
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM h06jz_modules AS m
WHERE m.published = 1
AND m.id = 160
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up IS NULL OR m.publish_up <= '2023-06-02 00:40:50')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down IS NULL OR m.publish_down >= '2023-06-02 00:40:50')
AND m.access IN (1,1,5)
AND m.client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | const | PRIMARY,published | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.23 ms |
checking permissions | 0.05 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.05 ms |
Statistics | 27.48 ms |
Preparing | 0.10 ms |
Unlocking tables | 0.05 ms |
Preparing | 0.08 ms |
Executing | 0.04 ms |
Sending data | 0.06 ms |
End of update loop | 0.04 ms |
Query end | 0.04 ms |
Commit | 0.04 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.04 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.10 ms |
Updating status | 0.05 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_sppagebuilder/addons/module/site.php:104 |
17 | SppagebuilderAddonModule::getModules() | JROOT/components/com_sppagebuilder/addons/module/site.php:31 |
16 | SppagebuilderAddonModule->render() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:463 |
15 | AddonParser::getAddonHtmlView() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:290 |
14 | AddonParser::viewAddons() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:91 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 41.96 ms Dopo l'ultima query: 7.50 ms Memoria query: 0.089 MB memoria prima della query: 5.482 MB Righe restituite: 1
SELECT h.*, c.title as category
FROM h06jz_zhgooglemaps_maps as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
WHERE h.id=2
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h | system | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
Status | Duration |
---|
Starting | 0.20 ms |
checking permissions | 0.05 ms |
Opening tables | 0.09 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.12 ms |
Optimizing | 0.04 ms |
Statistics | 40.66 ms |
Preparing | 0.11 ms |
Unlocking tables | 0.04 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.12 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.08 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
21 | JDatabaseDriver->loadObject() | JROOT/components/com_zhgooglemap/helpers/map_data.php:32 |
20 | comZhGoogleMapData::getMap() | JROOT/modules/mod_zhgooglemap/tmpl/default.php:44 |
19 | require JROOT/modules/mod_zhgooglemap/tmpl/default.php | JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:17 |
18 | include JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
17 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_sppagebuilder/addons/module/site.php:51 |
16 | SppagebuilderAddonModule->render() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:463 |
15 | AddonParser::getAddonHtmlView() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:290 |
14 | AddonParser::viewAddons() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:91 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.27 ms Dopo l'ultima query: 1.75 ms Memoria query: 0.087 MB memoria prima della query: 5.529 MB Righe restituite: 0
SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, g.iconofsetx as groupiconofsetx, g.iconofsety as groupiconofsety, bub.disableanimation, bub.shadowstyle, bub.padding, bub.borderradius, bub.borderwidth, bub.bordercolor, bub.backgroundcolor, bub.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.arrowsize, bub.arrowposition, bub.arrowstyle, bub.disableautopan, bub.hideclosebutton, bub.backgroundclassname, bub.published infobubblepublished
FROM h06jz_zhgooglemaps_markers as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
LEFT JOIN h06jz_zhgooglemaps_markergroups as g
ON h.markergroup=g.id
LEFT JOIN h06jz_zhgooglemaps_infobubbles as bub
ON h.tabid=bub.id
WHERE 1=1
and h.mapid=2
and h.published=1
AND (h.publish_up = '0000-00-00 00:00:00' OR h.publish_up <= '2023-06-02 00:40:50')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2023-06-02 00:40:50')
ORDER BY h.title
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.26 ms |
checking permissions | 0.03 ms |
Opening tables | 0.15 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.14 ms |
Optimizing | 0.07 ms |
Statistics | 0.07 ms |
Preparing | 0.02 ms |
Executing | 0.11 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.08 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:356 |
20 | comZhGoogleMapData::getMarkers() | JROOT/modules/mod_zhgooglemap/tmpl/default.php:112 |
19 | require JROOT/modules/mod_zhgooglemap/tmpl/default.php | JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:17 |
18 | include JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
17 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_sppagebuilder/addons/module/site.php:51 |
16 | SppagebuilderAddonModule->render() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:463 |
15 | AddonParser::getAddonHtmlView() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:290 |
14 | AddonParser::viewAddons() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:91 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.73 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.028 MB memoria prima della query: 5.538 MB Righe restituite: 0
SELECT h.*, c.title as category
FROM h06jz_zhgooglemaps_paths as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
WHERE h.published=1
and h.mapid=2
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.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.07 ms |
Optimizing | 0.04 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.05 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:1492 |
20 | comZhGoogleMapData::getPaths() | JROOT/modules/mod_zhgooglemap/tmpl/default.php:114 |
19 | require JROOT/modules/mod_zhgooglemap/tmpl/default.php | JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:17 |
18 | include JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
17 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_sppagebuilder/addons/module/site.php:51 |
16 | SppagebuilderAddonModule->render() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:463 |
15 | AddonParser::getAddonHtmlView() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:290 |
14 | AddonParser::viewAddons() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:91 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.66 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.027 MB memoria prima della query: 5.550 MB Righe restituite: 0
SELECT h.*, c.title as category
FROM h06jz_zhgooglemaps_routers as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
WHERE h.published=1
and h.mapid=2
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.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:505 |
20 | comZhGoogleMapData::getRouters() | JROOT/modules/mod_zhgooglemap/tmpl/default.php:121 |
19 | require JROOT/modules/mod_zhgooglemap/tmpl/default.php | JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:17 |
18 | include JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
17 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_sppagebuilder/addons/module/site.php:51 |
16 | SppagebuilderAddonModule->render() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:463 |
15 | AddonParser::getAddonHtmlView() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:290 |
14 | AddonParser::viewAddons() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:91 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.64 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.027 MB memoria prima della query: 5.561 MB Righe restituite: 0
SELECT h.*, c.title as category
FROM h06jz_zhgooglemaps_maptypes as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
WHERE h.published=1
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.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.06 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:1510 |
20 | comZhGoogleMapData::getMapTypes() | JROOT/modules/mod_zhgooglemap/tmpl/default.php:122 |
19 | require JROOT/modules/mod_zhgooglemap/tmpl/default.php | JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:17 |
18 | include JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
17 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_sppagebuilder/addons/module/site.php:51 |
16 | SppagebuilderAddonModule->render() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:463 |
15 | AddonParser::getAddonHtmlView() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:290 |
14 | AddonParser::viewAddons() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:91 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.70 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.028 MB memoria prima della query: 5.580 MB Righe restituite: 0
SELECT h.*, c.title as category
FROM h06jz_zhgooglemaps_markergroups as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
WHERE EXISTS (SELECT 1
FROM h06jz_zhgooglemaps_markers as m
WHERE m.markergroup=h.id
and m.mapid=2
and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-06-02 00:40:50')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-02 00:40:50'))
ORDER BY h.title
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | 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.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.06 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.08 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:706 |
20 | comZhGoogleMapData::getMarkerGroups() | JROOT/modules/mod_zhgooglemap/tmpl/default.php:125 |
19 | require JROOT/modules/mod_zhgooglemap/tmpl/default.php | JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:17 |
18 | include JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
17 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_sppagebuilder/addons/module/site.php:51 |
16 | SppagebuilderAddonModule->render() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:463 |
15 | AddonParser::getAddonHtmlView() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:290 |
14 | AddonParser::viewAddons() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:91 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.63 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.027 MB memoria prima della query: 5.592 MB Righe restituite: 0
SELECT h.*, c.title as category
FROM h06jz_zhgooglemaps_markergroups as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
WHERE EXISTS (SELECT 1
FROM h06jz_zhgooglemaps_markers as m
WHERE m.markergroup=h.id
and m.mapid=2
and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-06-02 00:40:50')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-02 00:40:50'))
ORDER BY h.title
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
Starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.06 ms |
Optimizing | 0.06 ms |
Statistics | 0.06 ms |
Preparing | 0.02 ms |
Executing | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/components/com_zhgooglemap/helpers/map_data.php:1315 |
20 | comZhGoogleMapData::getMarkerGroupsManage() | JROOT/modules/mod_zhgooglemap/tmpl/default.php:126 |
19 | require JROOT/modules/mod_zhgooglemap/tmpl/default.php | JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:17 |
18 | include JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
17 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_sppagebuilder/addons/module/site.php:51 |
16 | SppagebuilderAddonModule->render() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:463 |
15 | AddonParser::getAddonHtmlView() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:290 |
14 | AddonParser::viewAddons() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:91 |
13 | include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:60 |
10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:68 |
8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:18 |
6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 18.62 ms Dopo l'ultima query: 40.73 ms Memoria query: 0.056 MB memoria prima della query: 5.616 MB Righe restituite: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM h06jz_modules AS m
LEFT JOIN h06jz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN h06jz_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 <= '2023-06-02 00:40:50')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-02 00:40:50')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 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 | 44 | Using index condition; Using where; Using filesort |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | u457630568_offic.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | u457630568_offic.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.23 ms |
checking permissions | 0.06 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.05 ms |
Statistics | 15.03 ms |
Preparing | 0.17 ms |
Sorting result | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.06 ms |
Creating sort index | 2.19 ms |
End of update loop | 0.08 ms |
Query end | 0.04 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.11 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 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/ordasofttemplate-sectiontemplate/index.php:33 |
7 | require JROOT/templates/ordasofttemplate-sectiontemplate/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 |
Tempo della query: 26.08 ms Dopo l'ultima query: 19.80 ms Memoria query: 0.025 MB memoria prima della query: 5.735 MB Righe restituite: 0
SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM h06jz_content AS a
LEFT JOIN h06jz_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN h06jz_categories AS c
ON c.id = a.catid
LEFT JOIN h06jz_users AS ua
ON ua.id = a.created_by
LEFT JOIN h06jz_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM h06jz_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN h06jz_categories as parent
ON parent.id = c.parent_id
LEFT JOIN h06jz_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM h06jz_categories AS cat JOIN h06jz_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (8)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-02 00:40:50')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-02 00:40:50')
ORDER BY a.publish_up DESC
LIMIT 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | |
1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | const | 3 | Using where; Using filesort |
1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | u457630568_offic.a.created_by | 1 | Using where |
1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | u457630568_offic.a.modified_by | 1 | Using where |
1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | u457630568_offic.a.created_by | 2 | Using where |
1 | PRIMARY | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | u457630568_offic.a.id | 1 | Using where |
1 | PRIMARY | <derived3> | ref | key0 | key0 | 5 | const | 4 | Using where |
3 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 2 | Using index condition; Using temporary; Using filesort |
3 | DERIVED | cat | index | PRIMARY,idx_left_right | idx_left_right | 8 | NULL | 20 | Using where; Using index; Using join buffer (flat, BNL join) |
2 | DERIVED | contact | ref | idx_state | idx_state | 1 | const | 1 | Using where; Using temporary; Using filesort |
Status | Duration |
---|
Starting | 0.46 ms |
checking permissions | 0.06 ms |
Opening tables | 0.20 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
table lock | 0.04 ms |
init | 0.26 ms |
Optimizing | 0.09 ms |
Optimizing | 0.02 ms |
Statistics | 20.94 ms |
Optimizing | 0.13 ms |
Statistics | 0.39 ms |
Statistics | 0.81 ms |
Preparing | 0.07 ms |
Creating tmp table | 0.07 ms |
Sorting result | 0.03 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.04 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.08 ms |
Sorting result | 0.07 ms |
Executing | 0.02 ms |
Sending data | 0.06 ms |
Creating sort index | 0.75 ms |
Executing | 0.03 ms |
Sending data | 0.25 ms |
Creating sort index | 0.05 ms |
Removing tmp table | 0.05 ms |
Creating sort index | 0.22 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.02 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.04 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.06 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.10 ms |
Updating status | 0.05 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_tz_portfolio/models/articles.php:542 |
15 | TZ_PortfolioModelArticles->getItems() | JROOT/modules/mod_tz_portfolio_articles_latest/helper.php:107 |
14 | modTZ_PortfolioArticlesLatestHelper::getList() | JROOT/modules/mod_tz_portfolio_articles_latest/mod_tz_portfolio_articles_latest.php:26 |
13 | include JROOT/modules/mod_tz_portfolio_articles_latest/mod_tz_portfolio_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Chiamata uguale alla linea sottostante. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:606 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 27.09 ms Dopo l'ultima query: 4.97 ms Memoria query: 0.024 MB memoria prima della query: 5.771 MB Righe restituite: 1
SELECT *
FROM `h06jz_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder'
AND `extension_view` = 'module'
AND `view_id` = '205'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_sppagebuilder | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 14 | Using where |
Status | Duration |
---|
Starting | 0.17 ms |
checking permissions | 0.05 ms |
Opening tables | 0.06 ms |
After opening tables | 0.05 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.05 ms |
Preparing | 0.05 ms |
Executing | 0.03 ms |
Sending data | 25.96 ms |
End of update loop | 0.11 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.10 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
16 | JDatabaseDriver->loadObject() | JROOT/modules/mod_sppagebuilder/helper.php:46 |
15 | ModSPagebuilderHelper::pageBuilderData() | JROOT/modules/mod_sppagebuilder/helper.php:17 |
14 | ModSPagebuilderHelper::getData() | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 |
13 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Chiamata uguale alla linea sottostante. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.64 ms Dopo l'ultima query: 0.69 ms Memoria query: 0.024 MB memoria prima della query: 5.790 MB Righe restituite: 1
SELECT e.manifest_cache,`e`.`manifest_cache`
FROM `h06jz_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 302 | const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/components/com_sppagebuilder/helpers/helper.php:79 |
15 | SppagebuilderHelperSite::getVersion() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:38 |
14 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:20 |
13 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Chiamata uguale alla linea sottostante. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.50 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.024 MB memoria prima della query: 5.799 MB Righe restituite: 1
SELECT e.manifest_cache,`e`.`manifest_cache`
FROM `h06jz_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 302 | const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.02 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.03 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/components/com_sppagebuilder/helpers/helper.php:79 |
15 | SppagebuilderHelperSite::getVersion() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:39 |
14 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:20 |
13 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Chiamata uguale alla linea sottostante. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.54 ms Dopo l'ultima query: 0.40 ms Memoria query: 0.025 MB memoria prima della query: 5.851 MB Righe restituite: 1
SELECT `template`
FROM `h06jz_template_styles`
WHERE `client_id` = '0'
AND `home` = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_template_styles | ref | idx_home | idx_home | 21 | const | 2 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:44 |
17 | SpPgaeBuilderBase::getTemplateName() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:52 |
16 | SpPgaeBuilderBase::loadAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:198 |
15 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:43 |
14 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:20 |
13 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Chiamata uguale alla linea sottostante. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.83 ms Dopo l'ultima query: 43.56 ms Memoria query: 0.026 MB memoria prima della query: 5.973 MB Righe restituite: 2
SHOW FULL COLUMNS
FROM `h06jz_gsd_config`
EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `h06jz_gsd_config`
Status | Duration |
---|
Starting | 0.21 ms |
checking permissions | 0.05 ms |
closing tables | 0.08 ms |
Opening tables | 0.38 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.03 ms |
Optimizing | 0.04 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.03 ms |
Filling schema table | 0.03 ms |
Opening tables | 0.07 ms |
After opening tables | 0.02 ms |
checking permissions | 0.09 ms |
closing tables | 0.03 ms |
Executing | 0.06 ms |
Sending data | 0.06 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.13 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
21 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
20 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
19 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_gsd/tables/config.php:26 |
18 | GSDTableConfig->__construct() | JROOT/libraries/src/Table/Table.php:328 |
17 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_gsd/GSD/Helper.php:414 |
16 | GSD\Helper::getParams() | JROOT/plugins/system/gsd/gsd.php:363 |
15 | plgSystemGSD->setup() | JROOT/plugins/system/gsd/gsd.php:391 |
14 | plgSystemGSD->getHelper() | JROOT/plugins/system/gsd/gsd.php:65 |
13 | plgSystemGSD->init() | JROOT/plugins/system/gsd/gsd.php:54 |
12 | plgSystemGSD->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.69 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.024 MB memoria prima della query: 5.988 MB Righe restituite: 1
SELECT *
FROM h06jz_gsd_config
WHERE `name` = 'config'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_gsd_config | system | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | |
Status | Duration |
---|
Starting | 0.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.01 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
18 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
17 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_gsd/GSD/Helper.php:415 |
16 | GSD\Helper::getParams() | JROOT/plugins/system/gsd/gsd.php:363 |
15 | plgSystemGSD->setup() | JROOT/plugins/system/gsd/gsd.php:391 |
14 | plgSystemGSD->getHelper() | JROOT/plugins/system/gsd/gsd.php:65 |
13 | plgSystemGSD->init() | JROOT/plugins/system/gsd/gsd.php:54 |
12 | plgSystemGSD->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
4 × SELECT e.manifest_cache,`e`.`manifest_cache`
FROM `h06jz_extensions` AS `e`
3 × SELECT `id`
FROM `h06jz_menu`
3 × SELECT `template`
FROM `h06jz_template_styles`
2 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM h06jz_modules AS m
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `h06jz_extensions`
2 × SELECT h.*, c.title as category
FROM h06jz_zhgooglemaps_markergroups as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `h06jz_assets`
1 × SELECT *
FROM `h06jz_sppagebuilder`
1 × SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM h06jz_content AS a
LEFT JOIN h06jz_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN h06jz_categories AS c
ON c.id = a.catid
LEFT JOIN h06jz_users AS ua
ON ua.id = a.created_by
LEFT JOIN h06jz_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM h06jz_contact_details AS contact
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM h06jz_modules AS m
LEFT JOIN h06jz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN h06jz_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT h.*, c.title as category
FROM h06jz_zhgooglemaps_maptypes as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
1 × SELECT h.*, c.title as category
FROM h06jz_zhgooglemaps_routers as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
1 × SELECT h.*, c.title as category
FROM h06jz_zhgooglemaps_paths as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
1 × SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, g.iconofsetx as groupiconofsetx, g.iconofsety as groupiconofsety, bub.disableanimation, bub.shadowstyle, bub.padding, bub.borderradius, bub.borderwidth, bub.bordercolor, bub.backgroundcolor, bub.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.arrowsize, bub.arrowposition, bub.arrowstyle, bub.disableautopan, bub.hideclosebutton, bub.backgroundclassname, bub.published infobubblepublished
FROM h06jz_zhgooglemaps_markers as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
LEFT JOIN h06jz_zhgooglemaps_markergroups as g
ON h.markergroup=g.id
LEFT JOIN h06jz_zhgooglemaps_infobubbles as bub
ON h.tabid=bub.id
1 × SELECT h.*, c.title as category
FROM h06jz_zhgooglemaps_maps as h
LEFT JOIN h06jz_categories as c
ON h.catid=c.id
1 × SELECT `data`
FROM `h06jz_session`
1 × SELECT `session_id`
FROM `h06jz_session`
1 × SELECT a.*,l.title AS language_title,ua.name AS author_name
FROM h06jz_sppagebuilder as a
LEFT JOIN `h06jz_languages` AS l
ON l.lang_code = a.language
LEFT JOIN h06jz_users AS ua
ON ua.id = a.created_by
1 × SELECT *
FROM h06jz_sppagebuilder
1 × SELECT *
FROM h06jz_languages
1 × SELECT id, home, template, s.params
FROM h06jz_template_styles as s
LEFT JOIN h06jz_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM h06jz_menu AS m
LEFT JOIN h06jz_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM h06jz_extensions
1 × SELECT b.id
FROM h06jz_usergroups AS a
LEFT JOIN h06jz_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `h06jz_viewlevels
1 × SELECT *
FROM h06jz_gsd_config