Tempo della query: 1.32 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'6364666535396466626461666131626136636164366462376334646338333865'
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.27 ms |
checking permissions | 0.11 ms |
Opening tables | 0.09 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.28 ms |
Preparing | 0.04 ms |
Executing | 0.03 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.08 ms |
Updating status | 0.04 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/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.85 ms Dopo l'ultima query: 2.13 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'6364666535396466626461666131626136636164366462376334646338333865'
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.16 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 | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Executing | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.09 ms |
Updating status | 0.05 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.20 ms Dopo l'ultima query: 0.11 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'6364666535396466626461666131626136636164366462376334646338333865', 1, 1679392864, 0, '', 0)
EXPLAIN non possibile sulla query: INSERT INTO `h06jz_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6364666535396466626461666131626136636164366462376334646338333865', 1, 1679392864, 0, '', 0)
Status | Duration |
---|
Starting | 0.12 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init for update | 0.04 ms |
Update | 0.52 ms |
End of update loop | 0.04 ms |
Query end | 0.02 ms |
Commit | 0.08 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.04 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.27 ms Dopo l'ultima query: 7.52 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.26 ms |
checking permissions | 0.04 ms |
Opening tables | 0.09 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.31 ms |
Preparing | 0.06 ms |
Executing | 0.03 ms |
Sending data | 1.89 ms |
End of update loop | 0.05 ms |
Query end | 0.03 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.06 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.09 ms |
Updating status | 0.04 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/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.47 ms Dopo l'ultima query: 5.11 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.23 ms |
checking permissions | 0.08 ms |
Opening tables | 0.13 ms |
After opening tables | 0.07 ms |
System lock | 0.05 ms |
table lock | 0.04 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.04 ms |
Executing | 0.03 ms |
Sending data | 0.34 ms |
End of update loop | 0.05 ms |
Query end | 0.03 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.07 ms |
Updating status | 0.04 ms |
Reset for next command | 0.03 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.48 ms Dopo l'ultima query: 0.09 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.11 ms |
checking permissions | 0.03 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.05 ms |
init | 0.04 ms |
Optimizing | 0.04 ms |
Statistics | 0.55 ms |
Preparing | 0.04 ms |
Unlocking tables | 0.03 ms |
Preparing | 0.05 ms |
Executing | 0.03 ms |
Sending data | 0.05 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.03 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.06 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.08 ms |
Updating status | 0.04 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.54 ms Dopo l'ultima query: 2.56 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.20 ms |
checking permissions | 0.06 ms |
Opening tables | 0.04 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.03 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.03 ms |
Creating sort index | 1.46 ms |
End of update loop | 0.05 ms |
Query end | 0.03 ms |
Commit | 0.05 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.04 ms |
Reset for next command | 0.03 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: 1.72 ms Dopo l'ultima query: 110.51 ms Memoria query: 0.007 MB memoria prima della query: 4.137 MB
UPDATE `h06jz_extensions`
SET `params` = '{\"mediaversion\":\"466e096826cb3a903146aee731339baf\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN non possibile sulla query: UPDATE `h06jz_extensions`
SET `params` = '{\"mediaversion\":\"466e096826cb3a903146aee731339baf\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
Starting | 0.24 ms |
checking permissions | 0.09 ms |
Opening tables | 0.09 ms |
After opening tables | 0.07 ms |
System lock | 0.06 ms |
table lock | 0.06 ms |
init for update | 0.52 ms |
Updating | 0.16 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.08 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.07 ms |
Updating status | 0.04 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: 2.55 ms Dopo l'ultima query: 28.28 ms Memoria query: 0.028 MB memoria prima della query: 4.474 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.26 ms |
checking permissions | 0.08 ms |
Opening tables | 0.14 ms |
After opening tables | 0.06 ms |
System lock | 0.06 ms |
table lock | 0.06 ms |
init | 0.10 ms |
Optimizing | 0.06 ms |
Statistics | 0.13 ms |
Preparing | 0.06 ms |
Executing | 0.05 ms |
Sending data | 0.99 ms |
End of update loop | 0.06 ms |
Query end | 0.04 ms |
Commit | 0.04 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.08 ms |
Updating status | 0.04 ms |
Reset for next command | 0.03 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.88 ms Dopo l'ultima query: 3.43 ms Memoria query: 0.027 MB memoria prima della query: 4.538 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.17 ms |
checking permissions | 0.07 ms |
closing tables | 0.05 ms |
Opening tables | 0.25 ms |
After opening tables | 0.05 ms |
System lock | 0.03 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 |
Filling schema table | 0.03 ms |
Opening tables | 0.16 ms |
After opening tables | 0.03 ms |
checking permissions | 0.22 ms |
closing tables | 0.03 ms |
Executing | 0.03 ms |
Sending data | 0.09 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.11 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: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: 1.53 ms Dopo l'ultima query: 1.95 ms Memoria query: 0.038 MB memoria prima della query: 4.577 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.14 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.06 ms |
Optimizing | 0.03 ms |
Statistics | 0.62 ms |
Preparing | 0.03 ms |
Unlocking tables | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.06 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.03 ms |
Freeing items | 0.06 ms |
Updating status | 0.04 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.67 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.005 MB memoria prima della query: 4.595 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.08 ms |
checking permissions | 0.03 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init for update | 0.05 ms |
Updating | 0.08 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.06 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/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: 2.07 ms Dopo l'ultima query: 3.59 ms Memoria query: 0.038 MB memoria prima della query: 4.662 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.21 ms |
checking permissions | 0.06 ms |
Opening tables | 0.22 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
table lock | 0.05 ms |
init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.58 ms |
Preparing | 0.07 ms |
Unlocking tables | 0.04 ms |
Preparing | 0.05 ms |
Executing | 0.04 ms |
Sending data | 0.09 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.06 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.08 ms |
Updating status | 0.04 ms |
Reset for next command | 0.03 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: 2.68 ms Dopo l'ultima query: 0.86 ms Memoria query: 0.023 MB memoria prima della query: 4.684 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.11 ms |
checking permissions | 0.03 ms |
Opening tables | 0.13 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 1.71 ms |
End of update loop | 0.07 ms |
Query end | 0.04 ms |
Commit | 0.05 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.07 ms |
Updating status | 0.04 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: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.82 ms Dopo l'ultima query: 1.78 ms Memoria query: 0.023 MB memoria prima della query: 4.702 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.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.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.17 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.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: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.80 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.023 MB memoria prima della query: 4.710 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.06 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.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.16 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.03 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/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: 1.44 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.026 MB memoria prima della query: 4.719 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.14 ms |
checking permissions | 0.03 ms |
Opening tables | 0.04 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.45 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.22 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 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: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.43 ms Dopo l'ultima query: 6.23 ms Memoria query: 0.023 MB memoria prima della query: 4.772 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.27 ms |
checking permissions | 0.07 ms |
Opening tables | 0.08 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
table lock | 0.05 ms |
init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.10 ms |
Preparing | 0.05 ms |
Executing | 0.04 ms |
Sending data | 0.08 ms |
End of update loop | 0.04 ms |
Query end | 0.03 ms |
Commit | 0.06 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.08 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.72 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.023 MB memoria prima della query: 4.780 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.08 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 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.03 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: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: 1.44 ms Dopo l'ultima query: 7.51 ms Memoria query: 0.025 MB memoria prima della query: 4.793 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.24 ms |
checking permissions | 0.06 ms |
Opening tables | 0.15 ms |
After opening tables | 0.05 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.05 ms |
Preparing | 0.05 ms |
Executing | 0.03 ms |
Sending data | 0.25 ms |
End of update loop | 0.04 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.07 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.42 ms Dopo l'ultima query: 35.90 ms Memoria query: 0.025 MB memoria prima della query: 4.967 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.25 ms |
checking permissions | 0.06 ms |
Opening tables | 0.05 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.28 ms |
Preparing | 0.06 ms |
Executing | 0.03 ms |
Sending data | 0.09 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.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.08 ms |
Updating status | 0.04 ms |
Reset for next command | 0.03 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: 1.81 ms Dopo l'ultima query: 85.29 ms Memoria query: 0.025 MB memoria prima della query: 5.342 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-03-21 10:01:04')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down IS NULL OR m.publish_down >= '2023-03-21 10:01:04')
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.25 ms |
checking permissions | 0.08 ms |
Opening tables | 0.15 ms |
After opening tables | 0.06 ms |
System lock | 0.05 ms |
table lock | 0.05 ms |
init | 0.07 ms |
Optimizing | 0.08 ms |
Statistics | 0.52 ms |
Preparing | 0.04 ms |
Unlocking tables | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 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.03 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 |
---|
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: 1.60 ms Dopo l'ultima query: 44.77 ms Memoria query: 0.025 MB memoria prima della query: 5.369 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-03-21 10:01:04')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down IS NULL OR m.publish_down >= '2023-03-21 10:01:04')
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.30 ms |
checking permissions | 0.10 ms |
Opening tables | 0.10 ms |
After opening tables | 0.07 ms |
System lock | 0.05 ms |
table lock | 0.03 ms |
init | 0.08 ms |
Optimizing | 0.06 ms |
Statistics | 0.28 ms |
Preparing | 0.03 ms |
Unlocking tables | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.04 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.04 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.08 ms |
Updating status | 0.04 ms |
Reset for next command | 0.03 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: 2.01 ms Dopo l'ultima query: 31.30 ms Memoria query: 0.089 MB memoria prima della query: 5.415 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.08 ms |
Opening tables | 0.46 ms |
After opening tables | 0.09 ms |
System lock | 0.06 ms |
table lock | 0.06 ms |
init | 0.12 ms |
Optimizing | 0.04 ms |
Statistics | 0.27 ms |
Preparing | 0.03 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.03 ms |
Executing | 0.03 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.07 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.76 ms Dopo l'ultima query: 3.63 ms Memoria query: 0.087 MB memoria prima della query: 5.463 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-03-21 10:01:04')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2023-03-21 10:01:04')
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.25 ms |
checking permissions | 0.05 ms |
Opening tables | 0.58 ms |
After opening tables | 0.06 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.12 ms |
Optimizing | 0.06 ms |
Statistics | 0.06 ms |
Preparing | 0.02 ms |
Executing | 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.07 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: 1.18 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.028 MB memoria prima della query: 5.472 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.10 ms |
checking permissions | 0.04 ms |
Opening tables | 0.27 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.05 ms |
Preparing | 0.03 ms |
Executing | 0.06 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.07 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.09 ms |
Updating status | 0.06 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: 1.09 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.027 MB memoria prima della query: 5.483 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.14 ms |
checking permissions | 0.03 ms |
Opening tables | 0.24 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.05 ms |
Preparing | 0.03 ms |
Executing | 0.05 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.04 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 |
---|
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.98 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.027 MB memoria prima della query: 5.494 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.03 ms |
Opening tables | 0.19 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.05 ms |
Preparing | 0.03 ms |
Executing | 0.05 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.04 ms |
Reset for next command | 0.03 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.99 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.027 MB memoria prima della query: 5.507 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-03-21 10:01:04')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-21 10:01:04'))
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.14 ms |
checking permissions | 0.04 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.08 ms |
Optimizing | 0.09 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.04 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.08 ms |
Updating status | 0.04 ms |
Reset for next command | 0.03 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.89 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.027 MB memoria prima della query: 5.518 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-03-21 10:01:04')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-21 10:01:04'))
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.14 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.06 ms |
Optimizing | 0.07 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.04 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.03 ms |
Freeing items | 0.08 ms |
Updating status | 0.05 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: 1.82 ms Dopo l'ultima query: 195.32 ms Memoria query: 0.026 MB memoria prima della query: 5.575 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.03 ms |
closing tables | 0.02 ms |
Opening tables | 0.30 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.03 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Filling schema table | 0.03 ms |
Opening tables | 0.29 ms |
After opening tables | 0.03 ms |
checking permissions | 0.07 ms |
closing tables | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
End of update loop | 0.02 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.13 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.07 ms |
Updating status | 0.04 ms |
Reset for next command | 0.03 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.85 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.024 MB memoria prima della query: 5.591 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.12 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.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Unlocking tables | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.03 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.03 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.03 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 |
3 × SELECT `id`
FROM `h06jz_menu`
2 × SELECT e.manifest_cache,`e`.`manifest_cache`
FROM `h06jz_extensions` AS `e`
2 × SELECT `template`
FROM `h06jz_template_styles`
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`
2 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM h06jz_modules AS m
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 `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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `h06jz_extensions`
1 × SELECT *
FROM h06jz_gsd_config