Tempo della query: 0.58 ms Memoria query: 0.027 MB memoria prima della query: 1.154 MB Righe restituite: 0
SELECT `data`
FROM `jcg62_session`
WHERE `session_id` = 'h6976hv27v5sa88us7glo2qvj7'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_session | const | PRIMARY | PRIMARY | 766 | const | 1 | |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
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:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:755 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
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:343 |
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.41 ms Dopo l'ultima query: 1.91 ms Memoria query: 0.023 MB memoria prima della query: 1.172 MB Righe restituite: 0
SELECT `session_id`
FROM `jcg62_session`
WHERE `session_id` = 'h6976hv27v5sa88us7glo2qvj7'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:152 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
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:343 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Tempo della query: 9.85 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.005 MB memoria prima della query: 1.179 MB
INSERT INTO `jcg62_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('h6976hv27v5sa88us7glo2qvj7', 1, '1524419869', 0, '', 0)
EXPLAIN non possibile sulla query: INSERT INTO `jcg62_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('h6976hv27v5sa88us7glo2qvj7', 1, '1524419869', 0, '', 0)
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
update | 0.09 ms |
end | 0.01 ms |
query end | 9.44 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 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:152 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
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:343 |
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.57 ms Dopo l'ultima query: 7.66 ms Memoria query: 0.025 MB memoria prima della query: 1.351 MB Righe restituite: 10
SELECT id, rules
FROM `jcg62_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_viewlevels | ALL | NULL | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 10 | |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
executing | 0.04 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
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:310 |
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:606 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.58 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.025 MB memoria prima della query: 1.368 MB Righe restituite: 2
SELECT b.id
FROM jcg62_usergroups AS a
LEFT JOIN jcg62_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 18
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 | index | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 8 | NULL | 14 | Using where; Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.13 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
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:310 |
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:606 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.78 ms Dopo l'ultima query: 23.03 ms Memoria query: 0.024 MB memoria prima della query: 1.850 MB Righe restituite: 1
SELECT `enabled`
FROM `jcg62_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.02 ms |
init | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
8 | JDatabaseDriver->loadResult() | JROOT/plugins/system/backuponupdate/backuponupdate.php:74 |
7 | require_once JROOT/plugins/system/backuponupdate/backuponupdate.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:622 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.76 ms Dopo l'ultima query: 40.89 ms Memoria query: 0.024 MB memoria prima della query: 2.227 MB Righe restituite: 1
SELECT `lastupdate`
FROM `jcg62_ak_storage`
WHERE `tag` = 'akeebaupdatecheck_lastrun'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_ak_storage | const | PRIMARY | PRIMARY | 402 | const | 1 | |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.02 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
9 | JDatabaseDriver->loadResult() | JROOT/plugins/system/akeebaupdatecheck/akeebaupdatecheck.php:116 |
8 | plgSystemAkeebaupdatecheck->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:623 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.73 ms Dopo l'ultima query: 9.29 ms Memoria query: 0.032 MB memoria prima della query: 2.275 MB Righe restituite: 8
SHOW FULL COLUMNS
FROM `jcg62_content_types`
EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `jcg62_content_types`
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.61 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.02 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Filling schema table | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
checking permissions | 0.06 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.04 ms |
closing tables | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.14 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
15 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
14 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
13 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/ContentType.php:29 |
12 | Joomla\CMS\Table\ContentType->__construct() | JROOT/libraries/src/Table/Table.php:312 |
11 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/notificationary/notificationary.php:468 |
10 | PlgSystemNotificationaryCore->_getExtensionInfo() | JROOT/plugins/system/notificationary/notificationary.php:314 |
9 | PlgSystemNotificationaryCore->_prepareParams() | JROOT/plugins/system/notificationary/notificationary.php:6449 |
8 | PlgSystemNotificationaryCore->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:623 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.53 ms Dopo l'ultima query: 1.62 ms Memoria query: 0.030 MB memoria prima della query: 2.369 MB Righe restituite: 1
SELECT *
FROM jcg62_content_types
WHERE `type_id` = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_content_types | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
12 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
11 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/notificationary/notificationary.php:469 |
10 | PlgSystemNotificationaryCore->_getExtensionInfo() | JROOT/plugins/system/notificationary/notificationary.php:314 |
9 | PlgSystemNotificationaryCore->_prepareParams() | JROOT/plugins/system/notificationary/notificationary.php:6449 |
8 | PlgSystemNotificationaryCore->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:623 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.61 ms Dopo l'ultima query: 0.99 ms Memoria query: 0.028 MB memoria prima della query: 2.387 MB Righe restituite: 1
SELECT *
FROM jcg62_content_types
WHERE `type_alias` = 'com_content.category'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_content_types | ref | idx_alias | idx_alias | 402 | const | 1 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.09 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
12 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
11 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/notificationary/notificationary.php:509 |
10 | PlgSystemNotificationaryCore->_getExtensionInfo() | JROOT/plugins/system/notificationary/notificationary.php:314 |
9 | PlgSystemNotificationaryCore->_prepareParams() | JROOT/plugins/system/notificationary/notificationary.php:6449 |
8 | PlgSystemNotificationaryCore->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:623 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.57 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.025 MB memoria prima della query: 2.394 MB Righe restituite: 0
SELECT `id`
FROM `jcg62_users`
WHERE `email` = ''
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_users | ref | email | email | 402 | const | 1 | Using where; Using index |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.07 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.08 ms |
# | Caller | File e numero di linea |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
11 | JDatabaseDriver->loadResult() | JROOT/plugins/system/notificationary/helpers/helper.php:406 |
10 | NotificationAryHelper::getUserByEmail() | JROOT/plugins/system/notificationary/notificationary.php:434 |
9 | PlgSystemNotificationaryCore->_prepareParams() | JROOT/plugins/system/notificationary/notificationary.php:6449 |
8 | PlgSystemNotificationaryCore->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:623 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 7.51 ms Dopo l'ultima query: 30.25 ms Memoria query: 0.007 MB memoria prima della query: 3.032 MB
UPDATE `jcg62_extensions`
SET `params` = '{\"mediaversion\":\"accd4e221fa246b280e0d133b93803d4\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN non possibile sulla query: UPDATE `jcg62_extensions`
SET `params` = '{\"mediaversion\":\"accd4e221fa246b280e0d133b93803d4\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.15 ms |
Updating | 0.10 ms |
end | 0.02 ms |
query end | 6.79 ms |
closing tables | 0.03 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1113 |
4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.78 ms Dopo l'ultima query: 31.78 ms Memoria query: 0.037 MB memoria prima della query: 3.450 MB Righe restituite: 1
SELECT *
FROM jcg62_sobipro_object
WHERE ( id ='54' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_object | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.12 ms |
optimizing | 0.03 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
11 | JDatabaseDriver->loadObject() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:912 |
10 | Sobi\Database\MySQLi->loadObject() | JROOT/components/com_sobipro/lib/base/factory.php:202 |
9 | SPFactory::object() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:185 |
8 | SobiProCtrl->getSection() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:88 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.31 ms Dopo l'ultima query: 3.70 ms Memoria query: 0.039 MB memoria prima della query: 3.504 MB Righe restituite: 95
SELECT cSection AS configsection,sKey AS sKey,sValue AS sValue
FROM jcg62_sobipro_config
WHERE ( section IN ( '0','54' ) )
ORDER BY section, configsection
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_config | ALL | NULL | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 173 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sorting result | 0.31 ms |
Sending data | 0.44 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
11 | JDatabaseDriver->loadObjectList() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:941 |
10 | Sobi\Database\MySQLi->loadObjectList() | JROOT/components/com_sobipro/lib/base/config.php:192 |
9 | SPConfig->addTable() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:168 |
8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.70 ms Dopo l'ultima query: 2.76 ms Memoria query: 0.039 MB memoria prima della query: 3.594 MB Righe restituite: 1
SELECT *
FROM jcg62_sobipro_field
WHERE ( fid ='17' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_field | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.04 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.07 ms |
# | Caller | File e numero di linea |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
12 | JDatabaseDriver->loadObject() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:912 |
11 | Sobi\Database\MySQLi->loadObject() | JROOT/components/com_sobipro/lib/models/field.php:379 |
10 | SPField->init() | JROOT/components/com_sobipro/lib/base/config.php:76 |
9 | SPConfig->init() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:172 |
8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.58 ms Dopo l'ultima query: 1.76 ms Memoria query: 0.029 MB memoria prima della query: 3.618 MB Righe restituite: 22
SELECT pid
FROM jcg62_sobipro_plugins
WHERE ( enabled ='1' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_plugins | ALL | NULL | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 22 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.02 ms |
init | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
15 | JDatabaseDriver->loadColumn() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:872 |
14 | Sobi\Database\MySQLi->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:55 |
13 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:158 |
12 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:240 |
11 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/models/field.php:380 |
10 | SPField->init() | JROOT/components/com_sobipro/lib/base/config.php:76 |
9 | SPConfig->init() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:172 |
8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.76 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.028 MB memoria prima della query: 3.633 MB Righe restituite: 1
SELECT pid
FROM jcg62_sobipro_plugin_task
WHERE ( onAction IN ( '*','*' ) )
AND ( pid IN ( 'bank_transfer','paypal','chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','it-IT','profile_field','aggregation_field','download_field','im_ex','notifications','gallery_field','calendar_field','button' ) )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_plugin_task | index | pid | pid | 757 | NULL | 15 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.04 ms |
optimizing | 0.02 ms |
statistics | 0.28 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
15 | JDatabaseDriver->loadColumn() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:872 |
14 | Sobi\Database\MySQLi->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:65 |
13 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:158 |
12 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:240 |
11 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/models/field.php:380 |
10 | SPField->init() | JROOT/components/com_sobipro/lib/base/config.php:76 |
9 | SPConfig->init() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:172 |
8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.51 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.028 MB memoria prima della query: 3.645 MB Righe restituite: 1
SELECT pid
FROM jcg62_sobipro_plugin_section
WHERE ( section ='54' )
AND ( enabled ='1' )
AND ( pid IN ( 'notifications' ) )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_plugin_section | ref | PRIMARY | PRIMARY | 156 | const,const | 1 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
15 | JDatabaseDriver->loadColumn() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:872 |
14 | Sobi\Database\MySQLi->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:75 |
13 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:158 |
12 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:240 |
11 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/models/field.php:380 |
10 | SPField->init() | JROOT/components/com_sobipro/lib/base/config.php:76 |
9 | SPConfig->init() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:172 |
8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 2.03 ms Dopo l'ultima query: 9.41 ms Memoria query: 0.028 MB memoria prima della query: 3.678 MB Righe restituite: 6
SELECT sValue,sKey
FROM jcg62_sobipro_language
WHERE ( fid ='17' )
AND ( sKey IN ( 'name','description','suffix' ) )
AND ( oType ='field' )
ORDER BY FIELD( language, 'it-IT', '%' ) ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_language | ALL | PRIMARY,sKey | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1765 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.62 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sorting result | 0.81 ms |
Sending data | 0.14 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
14 | JDatabaseDriver->loadAssocList() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:893 |
13 | Sobi\Database\MySQLi->loadAssocList() | JROOT/components/com_sobipro/lib/models/field.php:504 |
12 | SPField->loadTables() | JROOT/components/com_sobipro/lib/models/field.php:400 |
11 | SPField->extend() | JROOT/components/com_sobipro/lib/models/field.php:384 |
10 | SPField->init() | JROOT/components/com_sobipro/lib/base/config.php:76 |
9 | SPConfig->init() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:172 |
8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:94 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 3.56 ms Dopo l'ultima query: 18.89 ms Memoria query: 0.026 MB memoria prima della query: 3.703 MB Righe restituite: 2
SELECT id AS id, sKey AS label, sValue AS value, language
FROM jcg62_sobipro_language
WHERE ( id ='54' )
AND ( oType ='section' )
AND ( sKey IN ( 'name' ) )
ORDER BY FIELD( language, 'it-IT', 'it-IT' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_language | ref | PRIMARY,sKey | sKey | 602 | const | 76 | Using index condition; Using where; Using filesort |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.36 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sorting result | 2.61 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
10 | JDatabaseDriver->loadAssocList() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:893 |
9 | Sobi\Database\MySQLi->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:708 |
8 | SPJoomlaLang::translateObject() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:133 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.77 ms Dopo l'ultima query: 0.41 ms Memoria query: 0.028 MB memoria prima della query: 3.718 MB Righe restituite: 0
SELECT rel.gid
FROM jcg62_sobipro_user_group AS grp
LEFT JOIN jcg62_sobipro_users_relation AS rel
ON grp.gid = rel.gid
WHERE ( ( rel.validUntil > '2018-04-22 17:57:49' OR rel.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND ( rel.validSince < '2018-04-22 17:57:49' OR rel.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND grp.enabled = 1 )
AND ( uid ='0' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | grp | ALL | PRIMARY | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | Using where |
1 | SIMPLE | rel | ref | PRIMARY | PRIMARY | 8 | const,db_portal.grp.gid | 1 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.04 ms |
optimizing | 0.03 ms |
statistics | 0.08 ms |
preparing | 0.09 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
15 | JDatabaseDriver->loadColumn() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:872 |
14 | Sobi\Database\MySQLi->loadResultArray() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:101 |
13 | SPJoomlaUser->spGroups() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:43 |
12 | SPUser->__construct() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:388 |
11 | SPJoomlaUser::getCurrent() | JROOT/components/com_sobipro/lib/base/factory.php:116 |
10 | SPFactory::user() | JROOT/components/com_sobipro/lib/sobi.php:493 |
9 | Sobi::My() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:259 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.41 ms Dopo l'ultima query: 1.26 ms Memoria query: 0.030 MB memoria prima della query: 3.801 MB Righe restituite: 1
SELECT count(id)
FROM jcg62_usergroups
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_usergroups | index | NULL | idx_usergroup_adjacency_lookup | 4 | NULL | 14 | Using index |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
18 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Helper/UserGroupsHelper.php:203 |
17 | Joomla\CMS\Helper\UserGroupsHelper->total() | JROOT/libraries/src/Helper/UserGroupsHelper.php:150 |
16 | Joomla\CMS\Helper\UserGroupsHelper->getAll() | JROOT/libraries/src/Access/Access.php:501 |
15 | Joomla\CMS\Access\Access::getGroupPath() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:221 |
14 | SAccess::parentGroups() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:78 |
13 | SPUser->parentGids() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:45 |
12 | SPUser->__construct() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:388 |
11 | SPJoomlaUser::getCurrent() | JROOT/components/com_sobipro/lib/base/factory.php:116 |
10 | SPFactory::user() | JROOT/components/com_sobipro/lib/sobi.php:493 |
9 | Sobi::My() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:259 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.48 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.033 MB memoria prima della query: 3.814 MB Righe restituite: 14
SELECT *
FROM jcg62_usergroups
ORDER BY lft ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_usergroups | ALL | NULL | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 14 | Using filesort |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sorting result | 0.07 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/UserGroupsHelper.php:259 |
17 | Joomla\CMS\Helper\UserGroupsHelper->loadAll() | JROOT/libraries/src/Helper/UserGroupsHelper.php:152 |
16 | Joomla\CMS\Helper\UserGroupsHelper->getAll() | JROOT/libraries/src/Access/Access.php:501 |
15 | Joomla\CMS\Access\Access::getGroupPath() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:221 |
14 | SAccess::parentGroups() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:78 |
13 | SPUser->parentGids() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:45 |
12 | SPUser->__construct() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:388 |
11 | SPJoomlaUser::getCurrent() | JROOT/components/com_sobipro/lib/base/factory.php:116 |
10 | SPFactory::user() | JROOT/components/com_sobipro/lib/sobi.php:493 |
9 | Sobi::My() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:259 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.58 ms Dopo l'ultima query: 1.47 ms Memoria query: 0.026 MB memoria prima della query: 3.847 MB Righe restituite: 0
SELECT fileName,template,configFile,cid
FROM jcg62_sobipro_view_cache
WHERE ( section ='54' )
AND ( sid ='54' )
AND ( task ='entry.details' )
AND ( site ='1' )
AND ( request ='{Itemid:716}' )
AND ( language ='it-IT' )
AND ( userGroups ='[]' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_view_cache | ref | sid,section,language,task,request,site,userGroups | task | 302 | const | 1 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.14 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1763 |
11 | JDatabaseDriver->loadRow() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:960 |
10 | Sobi\Database\MySQLi->loadRow() | JROOT/components/com_sobipro/lib/base/cache.php:724 |
9 | SPCache->view() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:266 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.61 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.026 MB memoria prima della query: 3.855 MB Righe restituite: 1
SELECT fileName,template,configFile,cid
FROM jcg62_sobipro_view_cache
WHERE ( section ='54' )
AND ( sid ='54' )
AND ( task ='' )
AND ( site ='1' )
AND ( request ='[]' )
AND ( language ='it-IT' )
AND ( userGroups ='[]' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_view_cache | ref | sid,section,language,task,request,site,userGroups | sid | 4 | const | 32 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.16 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1763 |
11 | JDatabaseDriver->loadRow() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:960 |
10 | Sobi\Database\MySQLi->loadRow() | JROOT/components/com_sobipro/lib/base/cache.php:730 |
9 | SPCache->view() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:266 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 4.72 ms Dopo l'ultima query: 5.61 ms Memoria query: 0.031 MB memoria prima della query: 3.883 MB Righe restituite: 26
SELECT id AS id, sKey AS label, sValue AS value, language
FROM jcg62_sobipro_language
WHERE ( id ='54' )
AND ( sKey IN ( 'description','name','metaKeys','metaDesc','sfMetaKeys','sfMetaDesc','efMetaKeys','efMetaDesc','efDesc','sfDesc','efTitle','sfTitle','nid','metaDesc','metaKeys' ) )
ORDER BY FIELD( language, 'it-IT', 'it-IT' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_language | ALL | PRIMARY,sKey | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1765 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.04 ms |
optimizing | 0.04 ms |
statistics | 2.66 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sorting result | 0.97 ms |
Sending data | 0.52 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
15 | JDatabaseDriver->loadAssocList() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:893 |
14 | Sobi\Database\MySQLi->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:708 |
13 | SPJoomlaLang::translateObject() | JROOT/components/com_sobipro/lib/models/dbobject.php:794 |
12 | SPDBObject->translate() | JROOT/components/com_sobipro/lib/models/dbobject.php:785 |
11 | SPDBObject->loadTable() | JROOT/components/com_sobipro/lib/models/dbobject.php:705 |
10 | SPDBObject->extend() | JROOT/components/com_sobipro/lib/ctrl/controller.php:76 |
9 | SPController->extend() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:297 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 11.82 ms Dopo l'ultima query: 0.55 ms Memoria query: 0.009 MB memoria prima della query: 3.896 MB
INSERT INTO jcg62_sobipro_counter (`sid`,`counter`,`lastUpdate`)
VALUES ('54','1','2018-04-22 17:57:49')
ON DUPLICATE KEY UPDATE sid = '54',counter = '1',lastUpdate = '2018-04-22 17:57:49'
EXPLAIN non possibile sulla query: INSERT INTO jcg62_sobipro_counter (`sid`,`counter`,`lastUpdate`) VALUES ('54','1','2018-04-22 17:57:49') ON DUPLICATE KEY UPDATE sid = '54',counter = '1',lastUpdate = '2018-04-22 17:57:49'
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
update | 0.10 ms |
end | 0.01 ms |
query end | 11.32 ms |
closing tables | 0.03 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
14 | JDatabaseDriverMysqli->execute() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:841 |
13 | Sobi\Database\MySQLi->query() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:1023 |
12 | Sobi\Database\MySQLi->exec() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:803 |
11 | Sobi\Database\MySQLi->insertUpdate() | JROOT/components/com_sobipro/lib/models/dbobject.php:554 |
10 | SPDBObject->countVisit() | JROOT/components/com_sobipro/lib/ctrl/controller.php:78 |
9 | SPController->extend() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:297 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.81 ms Dopo l'ultima query: 0.67 ms Memoria query: 0.038 MB memoria prima della query: 3.913 MB Righe restituite: 51
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jcg62_assets`
WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_awocoupon','com_banners','com_cache','com_categories','com_cc_juserexport','com_checkin','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_contentpress','com_cpanel','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phpmyjoomla','com_plugins','com_postinstall','com_quicklogout','com_redirect','com_search','com_simplefilemanager','com_sitemapgenerator','com_sobipro','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 52 | Using index condition |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.12 ms |
optimizing | 0.03 ms |
statistics | 0.32 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.82 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:151 |
13 | SPUser->isAdmin() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:197 |
12 | SPJoomlaUser->authorisePermission() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180 |
11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:268 |
10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:354 |
9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:334 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.92 ms Dopo l'ultima query: 2.56 ms Memoria query: 0.028 MB memoria prima della query: 3.986 MB Righe restituite: 5
SELECT DISTINCT sprl.rid
FROM jcg62_sobipro_permissions_groups AS spgr
LEFT JOIN jcg62_sobipro_permissions_rules AS sprl
ON spgr.rid = sprl.rid
WHERE ( ( sprl.validUntil > '2018-04-22 17:57:49' OR sprl.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND ( sprl.validSince < '2018-04-22 17:57:49' OR sprl.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND state = 1 )
AND spgr.gid in( 0 )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | sprl | ALL | PRIMARY | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 6 | Using where; Using temporary |
1 | SIMPLE | spgr | eq_ref | PRIMARY | PRIMARY | 8 | db_portal.sprl.rid,const | 1 | Using index; Distinct |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.05 ms |
optimizing | 0.04 ms |
statistics | 0.06 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Creating tmp table | 0.03 ms |
Copying to tmp table | 0.14 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
removing tmp table | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
15 | JDatabaseDriver->loadColumn() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:872 |
14 | Sobi\Database\MySQLi->loadResultArray() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:182 |
13 | SPUser->getPermissions() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:240 |
12 | SPJoomlaUser->authorisePermission() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180 |
11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:268 |
10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:354 |
9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:334 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.50 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.028 MB memoria prima della query: 3.996 MB Righe restituite: 8
SELECT pid
FROM jcg62_sobipro_permissions_map
WHERE ( sid ='54' )
AND ( rid IN ( '1','3','4','5','6' ) )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_permissions_map | index | PRIMARY | PRIMARY | 12 | NULL | 24 | Using where; Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.05 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
15 | JDatabaseDriver->loadColumn() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:872 |
14 | Sobi\Database\MySQLi->loadResultArray() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:190 |
13 | SPUser->getPermissions() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:240 |
12 | SPJoomlaUser->authorisePermission() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180 |
11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:268 |
10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:354 |
9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:334 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.49 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.033 MB memoria prima della query: 4.007 MB Righe restituite: 24
SELECT *
FROM jcg62_sobipro_permissions
WHERE ( site ='front' )
AND ( published ='1' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_permissions | ALL | NULL | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 44 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.11 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
15 | JDatabaseDriver->loadAssocList() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:893 |
14 | Sobi\Database\MySQLi->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:198 |
13 | SPUser->getPermissions() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:240 |
12 | SPJoomlaUser->authorisePermission() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180 |
11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:268 |
10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:354 |
9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:334 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.52 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.030 MB memoria prima della query: 4.043 MB Righe restituite: 22
SELECT pid
FROM jcg62_sobipro_plugins
WHERE ( enabled ='1' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_plugins | ALL | NULL | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 22 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
16 | JDatabaseDriver->loadColumn() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:872 |
15 | Sobi\Database\MySQLi->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:55 |
14 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:158 |
13 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:240 |
12 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182 |
11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:268 |
10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:354 |
9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:334 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.76 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.030 MB memoria prima della query: 4.065 MB Righe restituite: 1
SELECT pid
FROM jcg62_sobipro_plugin_task
WHERE ( onAction IN ( '*','section.view','section.*' ) )
AND ( pid IN ( 'bank_transfer','paypal','chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','info','it-IT','profile_field','aggregation_field','download_field','im_ex','notifications','gallery_field','calendar_field','button' ) )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_plugin_task | index | pid | pid | 757 | NULL | 15 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.04 ms |
optimizing | 0.02 ms |
statistics | 0.29 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
16 | JDatabaseDriver->loadColumn() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:872 |
15 | Sobi\Database\MySQLi->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:65 |
14 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:158 |
13 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:240 |
12 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182 |
11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:268 |
10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:354 |
9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:334 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.46 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.029 MB memoria prima della query: 4.078 MB Righe restituite: 1
SELECT pid
FROM jcg62_sobipro_plugin_section
WHERE ( section ='54' )
AND ( enabled ='1' )
AND ( pid IN ( 'notifications' ) )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_plugin_section | ref | PRIMARY | PRIMARY | 156 | const,const | 1 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
16 | JDatabaseDriver->loadColumn() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:872 |
15 | Sobi\Database\MySQLi->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:75 |
14 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:158 |
13 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:240 |
12 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182 |
11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:268 |
10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:354 |
9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:334 |
8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145 |
7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:46 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.84 ms Dopo l'ultima query: 22.68 ms Memoria query: 0.029 MB memoria prima della query: 4.134 MB Righe restituite: 1
SELECT *
FROM jcg62_sobipro_registry
WHERE ( section ='messages' )
ORDER BY value
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_registry | ALL | NULL | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 93 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.04 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sorting result | 0.22 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:941 |
14 | Sobi\Database\MySQLi->loadObjectList() | JROOT/components/com_sobipro/lib/base/registry.php:140 |
13 | SPRegistry->loadDBSection() | JROOT/components/com_sobipro/lib/base/message.php:40 |
12 | SPMessage->__construct() | JROOT/components/com_sobipro/lib/base/message.php:185 |
11 | SPMessage::getInstance() | JROOT/components/com_sobipro/lib/base/factory.php:167 |
10 | SPFactory::message() | JROOT/components/com_sobipro/lib/views/cache.php:160 |
9 | SPCachedView->parseXml() | JROOT/components/com_sobipro/lib/views/cache.php:82 |
8 | SPCachedView->cachedView() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:543 |
7 | SobiProCtrl->execute() | JROOT/components/com_sobipro/sobipro.php:47 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.61 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.029 MB memoria prima della query: 4.149 MB Righe restituite: 1
SELECT *
FROM jcg62_sobipro_registry
WHERE ( section ='reports' )
ORDER BY value
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_registry | ALL | NULL | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 93 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sorting result | 0.19 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:941 |
14 | Sobi\Database\MySQLi->loadObjectList() | JROOT/components/com_sobipro/lib/base/registry.php:140 |
13 | SPRegistry->loadDBSection() | JROOT/components/com_sobipro/lib/base/message.php:50 |
12 | SPMessage->__construct() | JROOT/components/com_sobipro/lib/base/message.php:185 |
11 | SPMessage::getInstance() | JROOT/components/com_sobipro/lib/base/factory.php:167 |
10 | SPFactory::message() | JROOT/components/com_sobipro/lib/views/cache.php:160 |
9 | SPCachedView->parseXml() | JROOT/components/com_sobipro/lib/views/cache.php:82 |
8 | SPCachedView->cachedView() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:543 |
7 | SobiProCtrl->execute() | JROOT/components/com_sobipro/sobipro.php:47 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.69 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.027 MB memoria prima della query: 4.202 MB Righe restituite: 24
SELECT sid
FROM jcg62_sobipro_view_cache_relation
WHERE ( cid ='1312' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_view_cache_relation | ref | PRIMARY | PRIMARY | 4 | const | 24 | Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
11 | JDatabaseDriver->loadColumn() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:872 |
10 | Sobi\Database\MySQLi->loadResultArray() | JROOT/components/com_sobipro/lib/views/cache.php:91 |
9 | SPCachedView->validateData() | JROOT/components/com_sobipro/lib/views/cache.php:83 |
8 | SPCachedView->cachedView() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:543 |
7 | SobiProCtrl->execute() | JROOT/components/com_sobipro/sobipro.php:47 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.50 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.028 MB memoria prima della query: 4.212 MB Righe restituite: 24
SELECT counter,sid
FROM jcg62_sobipro_counter
WHERE ( sid IN ( '54','65','66','67','68','69','70','71','72','73','74','76','78','81','119','120','121','122','123','124','125','126','127','128' ) )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_sobipro_counter | range | PRIMARY | PRIMARY | 4 | NULL | 24 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.02 ms |
# | Caller | File e numero di linea |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
12 | JDatabaseDriver->loadAssocList() | phar:JROOT/libraries/sobi/Sobi-1.0.3.phar.tar.gz/Database/MySQLi.php:893 |
11 | Sobi\Database\MySQLi->loadAssocList() | JROOT/components/com_sobipro/lib/views/view.php:832 |
10 | SPFrontView->loadNonStaticData() | JROOT/components/com_sobipro/lib/views/cache.php:93 |
9 | SPCachedView->validateData() | JROOT/components/com_sobipro/lib/views/cache.php:83 |
8 | SPCachedView->cachedView() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:543 |
7 | SobiProCtrl->execute() | JROOT/components/com_sobipro/sobipro.php:47 |
6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 9.17 ms Dopo l'ultima query: 26.30 ms Memoria query: 0.029 MB memoria prima della query: 4.297 MB Righe restituite: 6
SHOW FULL COLUMNS
FROM `jcg62_template_styles`
EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `jcg62_template_styles`
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.60 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
checking permissions | 0.06 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
closing tables | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.16 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
12 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
11 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
10 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_templates/tables/style.php:30 |
9 | TemplatesTableStyle->__construct() | JROOT/libraries/src/Table/Table.php:312 |
8 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/helix3/helix3.php:37 |
7 | plgSystemHelix3->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.50 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.035 MB memoria prima della query: 4.320 MB Righe restituite: 1
SELECT *
FROM jcg62_template_styles
WHERE `id` = '13'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_template_styles | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
9 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
8 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/helix3/helix3.php:38 |
7 | plgSystemHelix3->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 9.20 ms Dopo l'ultima query: 5.46 ms Memoria query: 0.024 MB memoria prima della query: 4.377 MB Righe restituite: 3
SELECT language,id
FROM `jcg62_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_menu | ALL | idx_client_id_parent_id_alias_language | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 376 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.06 ms |
optimizing | 0.03 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:718 |
7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.64 ms Dopo l'ultima query: 1.55 ms Memoria query: 0.025 MB memoria prima della query: 4.392 MB Righe restituite: 2
SELECT `c2`.`language`,`c2`.`id`
FROM `jcg62_menu` AS `c`
INNER JOIN `jcg62_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `jcg62_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `jcg62_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 716
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
1 | SIMPLE | a | const | PRIMARY,idx_key | PRIMARY | 206 | const,const | 1 | |
1 | SIMPLE | a2 | ref | idx_key | idx_key | 128 | const | 2 | Using index |
1 | SIMPLE | c2 | eq_ref | PRIMARY | PRIMARY | 4 | db_portal.a2.id | 1 | |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:104 |
9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
8 | MenusHelper::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:735 |
7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.13 ms Dopo l'ultima query: 67.48 ms Memoria query: 0.034 MB memoria prima della query: 4.950 MB Righe restituite: 1
SHOW TABLES LIKE "jcg62_virtuemart_configs"
EXPLAIN non possibile sulla query: SHOW TABLES LIKE "jcg62_virtuemart_configs"
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Filling schema table | 0.02 ms |
checking permissions | 0.51 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
25 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:717 |
24 | VmTable::checkTableExists() | JROOT/administrator/components/com_virtuemart/models/config.php:573 |
23 | VirtueMartModelConfig::checkConfigTableExists() | JROOT/administrator/components/com_virtuemart/helpers/config.php:940 |
22 | VmConfig::loadConfig() | JROOT/components/com_virtuemart/router.php:884 |
21 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:27 |
20 | virtuemartBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
19 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
18 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
17 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
16 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
14 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/helix3/core/classes/menu.php:112 |
13 | Helix3Menu->initMenu() | JROOT/plugins/system/helix3/core/classes/menu.php:31 |
12 | Helix3Menu->__construct() | JROOT/plugins/system/helix3/core/helix3.php:838 |
11 | Helix3::loadMegaMenu() | JROOT/templates/shaper_tixon/features/menu.php:28 |
10 | Helix3FeatureMenu->renderFeature() | JROOT/plugins/system/helix3/core/helix3.php:204 |
9 | Helix3::importFeatures() | JROOT/plugins/system/helix3/core/helix3.php:246 |
8 | Helix3::generatelayout() | JROOT/templates/shaper_tixon/index.php:170 |
7 | require JROOT/templates/shaper_tixon/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1027 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.55 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.033 MB memoria prima della query: 4.966 MB Righe restituite: 1
SELECT `config`
FROM `jcg62_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_virtuemart_configs | system | PRIMARY | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.02 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.04 ms |
cleaning up | 0.02 ms |
# | Caller | File e numero di linea |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
23 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/helpers/config.php:988 |
22 | VmConfig::loadConfig() | JROOT/components/com_virtuemart/router.php:884 |
21 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:27 |
20 | virtuemartBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
19 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
18 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
17 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
16 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
14 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/helix3/core/classes/menu.php:112 |
13 | Helix3Menu->initMenu() | JROOT/plugins/system/helix3/core/classes/menu.php:31 |
12 | Helix3Menu->__construct() | JROOT/plugins/system/helix3/core/helix3.php:838 |
11 | Helix3::loadMegaMenu() | JROOT/templates/shaper_tixon/features/menu.php:28 |
10 | Helix3FeatureMenu->renderFeature() | JROOT/plugins/system/helix3/core/helix3.php:204 |
9 | Helix3::importFeatures() | JROOT/plugins/system/helix3/core/helix3.php:246 |
8 | Helix3::generatelayout() | JROOT/templates/shaper_tixon/index.php:170 |
7 | require JROOT/templates/shaper_tixon/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1027 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.38 ms Dopo l'ultima query: 2.85 ms Memoria query: 0.040 MB memoria prima della query: 5.046 MB Righe restituite: 1
SELECT *
FROM `jcg62_menu`
WHERE `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "it-IT" )
AND ( access="1" OR access="10" )
ORDER BY `language` DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_menu | ALL | idx_client_id_parent_id_alias_language,idx_language | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 376 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.05 ms |
optimizing | 0.03 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sorting result | 0.65 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
24 | JDatabaseDriver->loadObjectList() | JROOT/components/com_virtuemart/router.php:1274 |
23 | vmrouterHelper->setMenuItemId() | JROOT/components/com_virtuemart/router.php:860 |
22 | vmrouterHelper->__construct() | JROOT/components/com_virtuemart/router.php:889 |
21 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:27 |
20 | virtuemartBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
19 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
18 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
17 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
16 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
15 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
14 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/helix3/core/classes/menu.php:112 |
13 | Helix3Menu->initMenu() | JROOT/plugins/system/helix3/core/classes/menu.php:31 |
12 | Helix3Menu->__construct() | JROOT/plugins/system/helix3/core/helix3.php:838 |
11 | Helix3::loadMegaMenu() | JROOT/templates/shaper_tixon/features/menu.php:28 |
10 | Helix3FeatureMenu->renderFeature() | JROOT/plugins/system/helix3/core/helix3.php:204 |
9 | Helix3::importFeatures() | JROOT/plugins/system/helix3/core/helix3.php:246 |
8 | Helix3::generatelayout() | JROOT/templates/shaper_tixon/index.php:170 |
7 | require JROOT/templates/shaper_tixon/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1027 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.65 ms Dopo l'ultima query: 2.87 ms Memoria query: 0.031 MB memoria prima della query: 5.085 MB Righe restituite: 1
SELECT id, title, module, position, content, showtitle, params
FROM jcg62_modules AS m
WHERE m.published = 1
AND m.id = 128
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-04-22 17:57:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-04-22 17:57:49')
AND m.access IN (1,1,10)
AND m.client_id = 0
AND m.language IN ('it-IT','*')
ORDER BY position, ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | const | PRIMARY,published,idx_language | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.05 ms |
optimizing | 0.03 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/helix3/core/classes/menu.php:511 |
17 | Helix3Menu->load_module() | JROOT/plugins/system/helix3/core/classes/menu.php:352 |
16 | Helix3Menu->mega() | JROOT/plugins/system/helix3/core/classes/menu.php:201 |
15 | Helix3Menu->getItem() | JROOT/plugins/system/helix3/core/classes/menu.php:189 |
14 | Helix3Menu->navigation() | JROOT/plugins/system/helix3/core/classes/menu.php:132 |
13 | Helix3Menu->render() | JROOT/plugins/system/helix3/core/classes/menu.php:32 |
12 | Helix3Menu->__construct() | JROOT/plugins/system/helix3/core/helix3.php:838 |
11 | Helix3::loadMegaMenu() | JROOT/templates/shaper_tixon/features/menu.php:28 |
10 | Helix3FeatureMenu->renderFeature() | JROOT/plugins/system/helix3/core/helix3.php:204 |
9 | Helix3::importFeatures() | JROOT/plugins/system/helix3/core/helix3.php:246 |
8 | Helix3::generatelayout() | JROOT/templates/shaper_tixon/index.php:170 |
7 | require JROOT/templates/shaper_tixon/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1027 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.55 ms Dopo l'ultima query: 3.61 ms Memoria query: 0.043 MB memoria prima della query: 5.145 MB Righe restituite: 0
SELECT *
FROM jcg62_banners
WHERE '2018-04-22 17:57:49' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | Impossible WHERE |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.05 ms |
optimizing | 0.03 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
21 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_banners/helpers/banners.php:79 |
20 | BannersHelper::updateReset() | JROOT/modules/mod_banners/mod_banners.php:19 |
19 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
18 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/plugins/system/helix3/core/classes/menu.php:526 |
17 | Helix3Menu->load_module() | JROOT/plugins/system/helix3/core/classes/menu.php:352 |
16 | Helix3Menu->mega() | JROOT/plugins/system/helix3/core/classes/menu.php:201 |
15 | Helix3Menu->getItem() | JROOT/plugins/system/helix3/core/classes/menu.php:189 |
14 | Helix3Menu->navigation() | JROOT/plugins/system/helix3/core/classes/menu.php:132 |
13 | Helix3Menu->render() | JROOT/plugins/system/helix3/core/classes/menu.php:32 |
12 | Helix3Menu->__construct() | JROOT/plugins/system/helix3/core/helix3.php:838 |
11 | Helix3::loadMegaMenu() | JROOT/templates/shaper_tixon/features/menu.php:28 |
10 | Helix3FeatureMenu->renderFeature() | JROOT/plugins/system/helix3/core/helix3.php:204 |
9 | Helix3::importFeatures() | JROOT/plugins/system/helix3/core/helix3.php:246 |
8 | Helix3::generatelayout() | JROOT/templates/shaper_tixon/index.php:170 |
7 | require JROOT/templates/shaper_tixon/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1027 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.76 ms Dopo l'ultima query: 2.57 ms Memoria query: 0.036 MB memoria prima della query: 5.176 MB Righe restituite: 0
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jcg62_banners as a
LEFT JOIN jcg62_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 17:57:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 17:57:49')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (88)
AND a.language in ('it-IT','*')
ORDER BY a.sticky DESC,a.ordering
LIMIT 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_banner_catid,idx_language | idx_state | 1 | const | 1 | Using where; Using filesort |
1 | SIMPLE | cl | eq_ref | PRIMARY | PRIMARY | 4 | db_portal.a.cid | 1 | |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.05 ms |
optimizing | 0.04 ms |
statistics | 0.14 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sorting result | 0.06 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
23 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
22 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_banners/models/banners.php:205 |
21 | BannersModelBanners->getItems() | JROOT/modules/mod_banners/helper.php:44 |
20 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
19 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
18 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/plugins/system/helix3/core/classes/menu.php:526 |
17 | Helix3Menu->load_module() | JROOT/plugins/system/helix3/core/classes/menu.php:352 |
16 | Helix3Menu->mega() | JROOT/plugins/system/helix3/core/classes/menu.php:201 |
15 | Helix3Menu->getItem() | JROOT/plugins/system/helix3/core/classes/menu.php:189 |
14 | Helix3Menu->navigation() | JROOT/plugins/system/helix3/core/classes/menu.php:132 |
13 | Helix3Menu->render() | JROOT/plugins/system/helix3/core/classes/menu.php:32 |
12 | Helix3Menu->__construct() | JROOT/plugins/system/helix3/core/helix3.php:838 |
11 | Helix3::loadMegaMenu() | JROOT/templates/shaper_tixon/features/menu.php:28 |
10 | Helix3FeatureMenu->renderFeature() | JROOT/plugins/system/helix3/core/helix3.php:204 |
9 | Helix3::importFeatures() | JROOT/plugins/system/helix3/core/helix3.php:246 |
8 | Helix3::generatelayout() | JROOT/templates/shaper_tixon/index.php:170 |
7 | require JROOT/templates/shaper_tixon/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1027 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 2.34 ms Dopo l'ultima query: 5.64 ms Memoria query: 0.034 MB memoria prima della query: 5.184 MB Righe restituite: 15
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jcg62_modules AS m
LEFT JOIN jcg62_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jcg62_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 <= '2018-04-22 17:57:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-04-22 17:57:49')
AND m.access IN (1,1,10)
AND m.client_id = 0
AND (mm.menuid = 716 OR mm.menuid <= 0)
AND m.language IN ('it-IT','*')
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,idx_language | published | 1 | const | 38 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | db_portal.m.module,const | 1 | Using index condition; Using where |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | db_portal.m.id | 2 | Using where; Using index |
Status | Duration |
---|
starting | 0.13 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.06 ms |
optimizing | 0.05 ms |
statistics | 0.13 ms |
preparing | 0.08 ms |
executing | 0.01 ms |
Sorting result | 0.42 ms |
Sending data | 0.97 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.04 ms |
cleaning up | 0.02 ms |
# | Caller | File e numero di linea |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | Chiamata uguale alla linea sottostante. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:433 |
14 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 |
13 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
12 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
11 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/helix3/core/helix3.php:512 |
10 | Helix3::countModules() | JROOT/plugins/system/helix3/core/helix3.php:459 |
9 | Helix3::rowColumns() | JROOT/plugins/system/helix3/core/helix3.php:268 |
8 | Helix3::generatelayout() | JROOT/templates/shaper_tixon/index.php:170 |
7 | require JROOT/templates/shaper_tixon/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1027 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.86 ms Dopo l'ultima query: 165.21 ms Memoria query: 0.035 MB memoria prima della query: 5.624 MB Righe restituite: 1
SELECT *
FROM `jcg62_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_virtuemart_shoppergroups | ref | virtuemart_vendor_id,shared,published | published | 1 | const | 2 | Using where |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.04 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.05 ms |
optimizing | 0.03 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102 |
15 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 |
14 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:163 |
13 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:114 |
12 | VirtueMartModelUser->getCurrentUser() | JROOT/components/com_virtuemart/helpers/cart.php:133 |
11 | VirtueMartCart::getCart() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:23 |
10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.48 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.036 MB memoria prima della query: 5.657 MB Righe restituite: 1
SELECT `jcg62_virtuemart_shoppergroups`.*
FROM `jcg62_virtuemart_shoppergroups`
WHERE `jcg62_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_virtuemart_shoppergroups | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
19 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1036 |
18 | VmTable->load() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1031 |
17 | VmModel->getData() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52 |
16 | VirtueMartModelShopperGroup->getShopperGroup() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107 |
15 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 |
14 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:163 |
13 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:114 |
12 | VirtueMartModelUser->getCurrentUser() | JROOT/components/com_virtuemart/helpers/cart.php:133 |
11 | VirtueMartCart::getCart() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:23 |
10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.72 ms Dopo l'ultima query: 7.06 ms Memoria query: 0.043 MB memoria prima della query: 5.840 MB Righe restituite: 1
SELECT *
FROM `jcg62_virtuemart_currencies` AS c
LEFT JOIN `jcg62_virtuemart_vendors` AS v
ON c.virtuemart_currency_id = v.vendor_currency
WHERE v.virtuemart_vendor_id = "1"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | v | system | PRIMARY,vendor_currency | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 1 | |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.04 ms |
optimizing | 0.03 ms |
statistics | 0.09 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
19 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/vendor.php:264 |
18 | VirtueMartModelVendor::getVendorCurrency() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53 |
17 | CurrencyDisplay->__construct() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103 |
16 | CurrencyDisplay::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 |
15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 0.57 ms Dopo l'ultima query: 1.89 ms Memoria query: 0.038 MB memoria prima della query: 5.890 MB Righe restituite: 1
SELECT `jcg62_virtuemart_currencies`.*
FROM `jcg62_virtuemart_currencies`
WHERE `jcg62_virtuemart_currencies`.`virtuemart_currency_id` = "47"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_virtuemart_currencies | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
19 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1036 |
18 | VmTable->load() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1031 |
17 | VmModel->getData() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119 |
16 | CurrencyDisplay::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 |
15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.92 ms Dopo l'ultima query: 1.48 ms Memoria query: 0.046 MB memoria prima della query: 5.939 MB Righe restituite: 31
SHOW FULL COLUMNS
FROM `jcg62_virtuemart_userfields`
EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `jcg62_virtuemart_userfields`
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.55 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
checking permissions | 0.06 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.04 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
closing tables | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.11 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.14 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
26 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:678 |
25 | VmTable->showFullColumns() | JROOT/administrator/components/com_virtuemart/tables/userfields.php:43 |
24 | TableUserfields->__construct() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:221 |
23 | VmTable::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:434 |
22 | VmModel->_createTable() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:396 |
21 | VmModel->getTable() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:602 |
20 | VmModel->setMainTable() | JROOT/administrator/components/com_virtuemart/models/userfields.php:52 |
19 | VirtueMartModelUserfields->__construct() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:554 |
18 | VmModel::getModel() | JROOT/components/com_virtuemart/helpers/cart.php:256 |
17 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 |
16 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.26 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.056 MB memoria prima della query: 6.004 MB Righe restituite: 20
SELECT *
FROM `jcg62_virtuemart_userfields`
WHERE 1 = 1
AND `account`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type') = 0
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_virtuemart_userfields | ref | published,account | account | 1 | const | 21 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.04 ms |
optimizing | 0.03 ms |
statistics | 0.06 ms |
preparing | 0.03 ms |
executing | 0.07 ms |
Sorting result | 0.33 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
21 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499 |
20 | VmModel->_getList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:619 |
19 | VirtueMartModelUserfields->getUserFields() | JROOT/administrator/components/com_virtuemart/models/userfields.php:503 |
18 | VirtueMartModelUserfields->getUserFieldsFor() | JROOT/components/com_virtuemart/helpers/cart.php:267 |
17 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 |
16 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.77 ms Dopo l'ultima query: 1.87 ms Memoria query: 0.107 MB memoria prima della query: 6.126 MB Righe restituite: 246
SELECT *
FROM `jcg62_virtuemart_countries`
WHERE `published` = 1
ORDER BY country_name ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_virtuemart_countries | ALL | published | NON E' POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 246 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sorting result | 0.54 ms |
Sending data | 0.57 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
22 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:859 |
21 | VmModel->exeSortSearchListQuery() | JROOT/administrator/components/com_virtuemart/models/country.php:113 |
20 | VirtueMartModelCountry->getCountries() | JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:146 |
19 | shopFunctionsF::renderCountryList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:857 |
18 | VirtueMartModelUserfields->getUserFieldsFilled() | JROOT/components/com_virtuemart/helpers/cart.php:271 |
17 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274 |
16 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90 |
15 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105 |
14 | calculationHelper::getInstance() | JROOT/components/com_virtuemart/helpers/cart.php:1561 |
13 | VirtueMartCart->getCartPrices() | JROOT/components/com_virtuemart/helpers/cart.php:1664 |
12 | VirtueMartCart->prepareCartData() | JROOT/components/com_virtuemart/helpers/cart.php:1792 |
11 | VirtueMartCart->prepareAjaxData() | JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30 |
10 | include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
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:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tempo della query: 1.17 ms Dopo l'ultima query: 6.00 ms Memoria query: 0.052 MB memoria prima della query: 6.637 MB Righe restituite: 12
SELECT *
FROM `jcg62_virtuemart_userfields`
WHERE 1 = 1
AND `shipment`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jcg62_virtuemart_userfields | ref | published,shipment | shipment | 1 | const | 12 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
init | 0.06 ms |
optimizing | 0.03 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sorting result | 0.23 ms |
Sending data | 0.26 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File e numero di linea |
---|
22 | JDatabaseDriverMysqli |