Tempo della query: 1.65 ms Memoria query: 0.023 MB memoria prima della query: 1.588 MB Righe restituite: 0
SELECT `data`
FROM `h06jz_session`
WHERE `session_id` = X'6266366431356264393961386331373363613365323061636439363863396631'
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.18 ms |
checking permissions | 0.06 ms |
Opening tables | 0.08 ms |
After opening tables | 0.05 ms |
System lock | 0.05 ms |
table lock | 0.05 ms |
init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.56 ms |
Preparing | 0.06 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.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 |
---|
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.94 ms Dopo l'ultima query: 8.51 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'6266366431356264393961386331373363613365323061636439363863396631'
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.20 ms |
checking permissions | 0.06 ms |
Opening tables | 0.05 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.06 ms |
Preparing | 0.03 ms |
Executing | 0.03 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.08 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
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.73 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.004 MB memoria prima della query: 1.672 MB
INSERT INTO `h06jz_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6266366431356264393961386331373363613365323061636439363863396631', 1, 1685667265, 0, '', 0)
EXPLAIN non possibile sulla query: INSERT INTO `h06jz_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6266366431356264393961386331373363613365323061636439363863396631', 1, 1685667265, 0, '', 0)
Status | Duration |
---|
Starting | 0.11 ms |
checking permissions | 0.04 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init for update | 0.03 ms |
Update | 1.13 ms |
End of update loop | 0.04 ms |
Query end | 0.02 ms |
Commit | 0.07 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Tempo della query: 1.10 ms Dopo l'ultima query: 37.14 ms Memoria query: 0.021 MB memoria prima della query: 1.838 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.16 ms |
checking permissions | 0.06 ms |
Opening tables | 0.09 ms |
After opening tables | 0.05 ms |
System lock | 0.06 ms |
table lock | 0.06 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.24 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.05 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
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.05 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.021 MB memoria prima della query: 1.850 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.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.45 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 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.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.02 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.26 ms Dopo l'ultima query: 380.15 ms Memoria query: 0.007 MB memoria prima della query: 4.126 MB
UPDATE `h06jz_extensions`
SET `params` = '{\"mediaversion\":\"1888e2a4f0973c252ccc9959eb56b7c4\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN non possibile sulla query: UPDATE `h06jz_extensions`
SET `params` = '{\"mediaversion\":\"1888e2a4f0973c252ccc9959eb56b7c4\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
Starting | 0.22 ms |
checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.05 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init for update | 0.75 ms |
Updating | 0.57 ms |
End of update loop | 0.05 ms |
Query end | 0.02 ms |
Commit | 0.07 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.05 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/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: 3.64 ms Dopo l'ultima query: 24.59 ms Memoria query: 0.020 MB memoria prima della query: 4.363 MB Righe restituite: 1
SELECT params
FROM h06jz_os_gallery
WHERE id=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_os_gallery | system | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | |
Status | Duration |
---|
Starting | 0.21 ms |
checking permissions | 0.06 ms |
Opening tables | 2.45 ms |
After opening tables | 0.08 ms |
System lock | 0.04 ms |
table lock | 0.05 ms |
init | 0.05 ms |
Optimizing | 0.05 ms |
Statistics | 0.19 ms |
Preparing | 0.05 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.02 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.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 |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:183 |
7 | osGalleryHelperSite::displayView() | JROOT/components/com_osgallery/osgallery.php:30 |
6 | require_once JROOT/components/com_osgallery/osgallery.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: 6.97 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.024 MB memoria prima della query: 4.382 MB Righe restituite: 14
SELECT gim.* , gc.fk_cat_id, cat.name as cat_name, gal.id as galId, cat.ordering as cat_ordering
FROM h06jz_os_gallery_img as gim
LEFT JOIN h06jz_os_gallery_connect as gc
ON gim.id=gc.fk_gal_img_id
LEFT JOIN h06jz_os_gallery_categories as cat
ON cat.id=gc.fk_cat_id
LEFT JOIN h06jz_os_gallery as gal
ON gal.id=cat.fk_gal_id
WHERE cat.fk_gal_id =1
AND gal.published=1
AND gim.publish=1
ORDER BY cat.ordering ASC, gim.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | cat | system | PRIMARY,fk_gal_id | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | Using temporary; Using filesort |
1 | SIMPLE | gal | system | PRIMARY | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | |
1 | SIMPLE | gc | ALL | fk_cat_id,fk_gal_img_id | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 14 | Using where |
1 | SIMPLE | gim | eq_ref | PRIMARY | PRIMARY | 4 | u457630568_offic.gc.fk_gal_img_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.15 ms |
checking permissions | 0.07 ms |
Opening tables | 4.80 ms |
After opening tables | 0.10 ms |
System lock | 0.02 ms |
table lock | 0.04 ms |
init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.24 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.06 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.66 ms |
Creating sort index | 0.10 ms |
Removing tmp table | 0.12 ms |
Creating sort index | 0.02 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.05 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 |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
8 | JDatabaseDriver->loadObjectList() | JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:240 |
7 | osGalleryHelperSite::displayView() | JROOT/components/com_osgallery/osgallery.php:30 |
6 | require_once JROOT/components/com_osgallery/osgallery.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.70 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.021 MB memoria prima della query: 4.402 MB Righe restituite: 1
SELECT DISTINCT id,params
FROM h06jz_os_gallery_categories
WHERE fk_gal_id =1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_os_gallery_categories | system | fk_gal_id | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | |
Status | Duration |
---|
Starting | 0.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
8 | JDatabaseDriver->loadObjectList() | JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:315 |
7 | osGalleryHelperSite::displayView() | JROOT/components/com_osgallery/osgallery.php:30 |
6 | require_once JROOT/components/com_osgallery/osgallery.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.45 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 4.408 MB Righe restituite: 14
SELECT DISTINCT galImg.id,galImg.params
FROM h06jz_os_gallery_img as galImg
LEFT JOIN h06jz_os_gallery_connect as galCon
ON galCon.fk_gal_img_id = galImg.id
LEFT JOIN h06jz_os_gallery_categories as cat
ON cat.id = galCon.fk_cat_id
WHERE cat.fk_gal_id =1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | cat | system | PRIMARY,fk_gal_id | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | Using temporary |
1 | SIMPLE | galCon | ALL | fk_cat_id,fk_gal_img_id | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 14 | Using where |
1 | SIMPLE | galImg | eq_ref | PRIMARY | PRIMARY | 4 | u457630568_offic.galCon.fk_gal_img_id | 1 | |
Status | Duration |
---|
Starting | 0.16 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.08 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.43 ms |
Removing tmp table | 0.11 ms |
Sending data | 0.02 ms |
End of update loop | 0.02 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.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 |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
8 | JDatabaseDriver->loadObjectList() | JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:323 |
7 | osGalleryHelperSite::displayView() | JROOT/components/com_osgallery/osgallery.php:30 |
6 | require_once JROOT/components/com_osgallery/osgallery.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.97 ms Dopo l'ultima query: 5.84 ms Memoria query: 0.022 MB memoria prima della query: 4.431 MB Righe restituite: 0
SELECT gim.* , gal.id as galId
FROM `h06jz_os_gallery_img` as gim
LEFT JOIN h06jz_os_gallery_connect as gc
ON gim.id=gc.fk_gal_img_id
LEFT JOIN h06jz_os_gallery_categories as cat
ON cat.id=gc.fk_cat_id
LEFT JOIN h06jz_os_gallery as gal
ON gal.id=cat.fk_gal_id
WHERE gim.id = 0
ORDER BY cat.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
Starting | 0.21 ms |
checking permissions | 0.06 ms |
Opening tables | 0.09 ms |
After opening tables | 0.05 ms |
System lock | 0.04 ms |
table lock | 0.03 ms |
init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.02 ms |
Executing | 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.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
10 | JDatabaseDriver->loadAssoc() | JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:42 |
9 | osGalleryHelperSite::addMetaTags() | JROOT/components/com_osgallery/views/defaultTabs/tmpl/default.php:15 |
8 | require JROOT/components/com_osgallery/views/defaultTabs/tmpl/default.php | JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:448 |
7 | osGalleryHelperSite::displayView() | JROOT/components/com_osgallery/osgallery.php:30 |
6 | require_once JROOT/components/com_osgallery/osgallery.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 5.28 ms Dopo l'ultima query: 67.48 ms Memoria query: 0.056 MB memoria prima della query: 4.593 MB Righe restituite: 16
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM h06jz_modules AS m
LEFT JOIN h06jz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN h06jz_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-06-02 00:54:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-02 00:54:25')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 112 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 44 | Using index condition; Using where; Using filesort |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | u457630568_offic.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | u457630568_offic.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.26 ms |
checking permissions | 0.06 ms |
Opening tables | 0.10 ms |
After opening tables | 0.10 ms |
System lock | 0.05 ms |
table lock | 0.04 ms |
init | 0.10 ms |
Optimizing | 0.08 ms |
Statistics | 0.49 ms |
Preparing | 0.09 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
Creating sort index | 3.43 ms |
End of update loop | 0.06 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.07 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.03 ms |
# | Caller | File e numero di linea |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | Chiamata uguale alla linea sottostante. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/ordasofttemplate-sectiontemplate/index.php:33 |
7 | require JROOT/templates/ordasofttemplate-sectiontemplate/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 8.99 ms Dopo l'ultima query: 76.01 ms Memoria query: 0.025 MB memoria prima della query: 4.783 MB Righe restituite: 0
SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM h06jz_content AS a
LEFT JOIN h06jz_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN h06jz_categories AS c
ON c.id = a.catid
LEFT JOIN h06jz_users AS ua
ON ua.id = a.created_by
LEFT JOIN h06jz_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM h06jz_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN h06jz_categories as parent
ON parent.id = c.parent_id
LEFT JOIN h06jz_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM h06jz_categories AS cat JOIN h06jz_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (8)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-02 00:54:25')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-02 00:54:25')
ORDER BY a.publish_up DESC
LIMIT 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | |
1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | const | 3 | Using where; Using filesort |
1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | u457630568_offic.a.created_by | 1 | Using where |
1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | u457630568_offic.a.modified_by | 1 | Using where |
1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | u457630568_offic.a.created_by | 2 | Using where |
1 | PRIMARY | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | u457630568_offic.a.id | 1 | Using where |
1 | PRIMARY | <derived3> | ref | key0 | key0 | 5 | const | 4 | Using where |
3 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 2 | Using index condition; Using temporary; Using filesort |
3 | DERIVED | cat | index | PRIMARY,idx_left_right | idx_left_right | 8 | NULL | 20 | Using where; Using index; Using join buffer (flat, BNL join) |
2 | DERIVED | contact | ref | idx_state | idx_state | 1 | const | 1 | Using where; Using temporary; Using filesort |
Status | Duration |
---|
Starting | 0.53 ms |
checking permissions | 0.07 ms |
Opening tables | 0.21 ms |
After opening tables | 0.04 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.24 ms |
Optimizing | 0.10 ms |
Optimizing | 0.03 ms |
Statistics | 0.60 ms |
Optimizing | 0.06 ms |
Statistics | 0.34 ms |
Statistics | 1.30 ms |
Preparing | 0.07 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.03 ms |
Preparing | 0.04 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.04 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.07 ms |
Sorting result | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.06 ms |
Creating sort index | 2.71 ms |
Executing | 0.10 ms |
Sending data | 0.97 ms |
Creating sort index | 0.11 ms |
Removing tmp table | 0.06 ms |
Creating sort index | 0.23 ms |
Executing | 0.03 ms |
Sending data | 0.07 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.05 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.02 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.05 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.07 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.10 ms |
Updating status | 0.05 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_tz_portfolio/models/articles.php:542 |
15 | TZ_PortfolioModelArticles->getItems() | JROOT/modules/mod_tz_portfolio_articles_latest/helper.php:107 |
14 | modTZ_PortfolioArticlesLatestHelper::getList() | JROOT/modules/mod_tz_portfolio_articles_latest/mod_tz_portfolio_articles_latest.php:26 |
13 | include JROOT/modules/mod_tz_portfolio_articles_latest/mod_tz_portfolio_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Chiamata uguale alla linea sottostante. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:606 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 4.52 ms Dopo l'ultima query: 13.54 ms Memoria query: 0.025 MB memoria prima della query: 4.824 MB Righe restituite: 1
SELECT *
FROM `h06jz_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder'
AND `extension_view` = 'module'
AND `view_id` = '205'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_sppagebuilder | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 14 | Using where |
Status | Duration |
---|
Starting | 0.18 ms |
checking permissions | 0.06 ms |
Opening tables | 0.10 ms |
After opening tables | 0.05 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.04 ms |
Preparing | 0.05 ms |
Executing | 0.03 ms |
Sending data | 3.26 ms |
End of update loop | 0.09 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.03 ms |
Freeing items | 0.09 ms |
Updating status | 0.05 ms |
Reset for next command | 0.03 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
16 | JDatabaseDriver->loadObject() | JROOT/modules/mod_sppagebuilder/helper.php:46 |
15 | ModSPagebuilderHelper::pageBuilderData() | JROOT/modules/mod_sppagebuilder/helper.php:17 |
14 | ModSPagebuilderHelper::getData() | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 |
13 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Chiamata uguale alla linea sottostante. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.22 ms Dopo l'ultima query: 9.25 ms Memoria query: 0.025 MB memoria prima della query: 4.908 MB Righe restituite: 1
SELECT `template`
FROM `h06jz_template_styles`
WHERE `client_id` = 0
AND `home` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_template_styles | ALL | idx_home | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 6 | Using where |
Status | Duration |
---|
Starting | 0.20 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.03 ms |
init | 0.04 ms |
Optimizing | 0.04 ms |
Statistics | 0.05 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.34 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:622 |
17 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:160 |
16 | AddonParser::getAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:695 |
15 | require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php | JROOT/modules/mod_sppagebuilder/tmpl/default.php:16 |
14 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:20 |
13 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Chiamata uguale alla linea sottostante. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.28 ms Dopo l'ultima query: 49.59 ms Memoria query: 0.024 MB memoria prima della query: 4.928 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.21 ms |
checking permissions | 0.06 ms |
Opening tables | 0.07 ms |
After opening tables | 0.05 ms |
System lock | 0.04 ms |
table lock | 0.05 ms |
init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.10 ms |
Preparing | 0.05 ms |
Executing | 0.04 ms |
Sending data | 0.07 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.04 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 |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/components/com_sppagebuilder/helpers/helper.php:79 |
15 | SppagebuilderHelperSite::getVersion() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:38 |
14 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:20 |
13 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Chiamata uguale alla linea sottostante. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.92 ms Dopo l'ultima query: 0.49 ms Memoria query: 0.025 MB memoria prima della query: 4.938 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.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/components/com_sppagebuilder/helpers/helper.php:79 |
15 | SppagebuilderHelperSite::getVersion() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:39 |
14 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:20 |
13 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Chiamata uguale alla linea sottostante. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 8.00 ms Dopo l'ultima query: 2.12 ms Memoria query: 0.025 MB memoria prima della query: 5.000 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.17 ms |
checking permissions | 0.04 ms |
Opening tables | 0.06 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 6.78 ms |
Preparing | 0.15 ms |
Executing | 0.07 ms |
Sending data | 0.10 ms |
End of update loop | 0.05 ms |
Query end | 0.05 ms |
Commit | 0.05 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:44 |
17 | SpPgaeBuilderBase::getTemplateName() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:52 |
16 | SpPgaeBuilderBase::loadAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:198 |
15 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:43 |
14 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:20 |
13 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Chiamata uguale alla linea sottostante. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.50 ms Dopo l'ultima query: 166.91 ms Memoria query: 0.026 MB memoria prima della query: 5.425 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.19 ms |
checking permissions | 0.05 ms |
closing tables | 0.05 ms |
Opening tables | 0.28 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.03 ms |
Filling schema table | 0.03 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
checking permissions | 0.06 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.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.10 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 |
---|
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.77 ms Dopo l'ultima query: 2.74 ms Memoria query: 0.024 MB memoria prima della query: 5.443 MB Righe restituite: 1
SELECT *
FROM h06jz_gsd_config
WHERE `name` = 'config'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | h06jz_gsd_config | system | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | |
Status | Duration |
---|
Starting | 0.13 ms |
checking permissions | 0.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.04 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 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.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.05 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
18 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
17 | Joomla\CMS\Table\Table->load() | JROOT/administrator/components/com_gsd/GSD/Helper.php:415 |
16 | GSD\Helper::getParams() | JROOT/plugins/system/gsd/gsd.php:363 |
15 | plgSystemGSD->setup() | JROOT/plugins/system/gsd/gsd.php:391 |
14 | plgSystemGSD->getHelper() | JROOT/plugins/system/gsd/gsd.php:65 |
13 | plgSystemGSD->init() | JROOT/plugins/system/gsd/gsd.php:54 |
12 | plgSystemGSD->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
2 × SELECT `template`
FROM `h06jz_template_styles`
2 × SELECT e.manifest_cache,`e`.`manifest_cache`
FROM `h06jz_extensions` AS `e`
1 × SELECT `data`
FROM `h06jz_session`
1 × SELECT `session_id`
FROM `h06jz_session`
1 × SELECT id, rules
FROM `h06jz_viewlevels
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 params
FROM h06jz_os_gallery
1 × SELECT gim.* , gc.fk_cat_id, cat.name as cat_name, gal.id as galId, cat.ordering as cat_ordering
FROM h06jz_os_gallery_img as gim
LEFT JOIN h06jz_os_gallery_connect as gc
ON gim.id=gc.fk_gal_img_id
LEFT JOIN h06jz_os_gallery_categories as cat
ON cat.id=gc.fk_cat_id
LEFT JOIN h06jz_os_gallery as gal
ON gal.id=cat.fk_gal_id
1 × SELECT DISTINCT id,params
FROM h06jz_os_gallery_categories
1 × SELECT DISTINCT galImg.id,galImg.params
FROM h06jz_os_gallery_img as galImg
LEFT JOIN h06jz_os_gallery_connect as galCon
ON galCon.fk_gal_img_id = galImg.id
LEFT JOIN h06jz_os_gallery_categories as cat
ON cat.id = galCon.fk_cat_id
1 × SELECT gim.* , gal.id as galId
FROM `h06jz_os_gallery_img` as gim
LEFT JOIN h06jz_os_gallery_connect as gc
ON gim.id=gc.fk_gal_img_id
LEFT JOIN h06jz_os_gallery_categories as cat
ON cat.id=gc.fk_cat_id
LEFT JOIN h06jz_os_gallery as gal
ON gal.id=cat.fk_gal_id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM h06jz_modules AS m
LEFT JOIN h06jz_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN h06jz_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT a.id, a.title, a.alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM h06jz_content AS a
LEFT JOIN h06jz_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN h06jz_categories AS c
ON c.id = a.catid
LEFT JOIN h06jz_users AS ua
ON ua.id = a.created_by
LEFT JOIN h06jz_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM h06jz_contact_details AS contact
1 × SELECT *
FROM `h06jz_sppagebuilder`
1 × SELECT *
FROM h06jz_gsd_config