{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1524419869,
                "last": 1524419869,
                "now": 1524419869
            },
            "token": "Wh3KjZTpQNe3RKWY36BPUe7NfgOMJWF8"
        },
        "registry": {
            "com_sobipro": {
                "messages-queue": []
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_notificationary": null,
        "plg_system_languagefilter": {
            "language": "it-IT"
        }
    },
    "__JPluginGJFields": {
        "DefaultParams": {
            "{notificationgroup": "JGLOBAL_ARTICLES",
            "isenabled": "1",
            "ausers_notifyon": "0",
            "status_action_to_notify": "always",
            "ausers_notifyonlyifcanview": "1",
            "oncontentchangestate": "1",
            "context_or_contenttype": "content_type",
            "context": "",
            "content_type": "1",
            "ausers_articlegroups": "0",
            "allow_subscribe": "1",
            "allow_subscribe_default": "1",
            "content_language": "always",
            "ausers_articles": "0",
            "ausers_notifyusergroups": "1",
            "ausers_notifyusers": "0",
            "ausers_excludeusers": "arygroup@gmail.com",
            "author_notifyonaction": "6",
            "author_foranyuserchanges": "1",
            "author_mailbody_type": "inherit",
            "ausers_notifymodifier": "0",
            "modifier_mailbody_type": "inherit",
            "ausers_allowusergroups": "0",
            "ausers_allowusers": "0",
            "shownotificationswitch": "1",
            "notificationswitchdefault": "1",
            "notificationswitchfrontend": "1",
            "notificationswitchaddconfirmation": "0",
            "ausers_allowswitchforusergroups": "0",
            "ausers_allowswitchforusers": "0",
            "sender_name": "",
            "sender_email": "",
            "replyto_name": "",
            "replyto_email": "",
            "emailformat": "plaintext",
            "attachpreviousversion": "0",
            "attachdiffinfo": "0",
            "messagebodysource": "hardcoded",
            "strip_plugin_tags": "1",
            "make_image_path_absolute": "absolute",
            "personalize": "0",
            "ausers_includearticletitle": "1",
            "ausers_includecontenttype": "0",
            "ausers_includecategorytree": "1",
            "ausers_includeauthorname": "1",
            "ausers_includemodifiername": "1",
            "ausers_includecreateddate": "1",
            "ausers_includemodifieddate": "1",
            "ausers_includeintrotext": "1",
            "ausers_includefulltext": "1",
            "includediffinfo_text": "none",
            "includediffinfo_html": "none",
            "ausers_includefrontendviewlink": "1",
            "ausers_includefrontendeditlink": "1",
            "ausers_includebackendeditlink": "1",
            "ausers_includeunsubscribelink": "1",
            "manage_subscription_link": "",
            "messagesubjectcustom": "PLG_SYSTEM_NOTIFICATIONARY_FIELD_MESSAGE_SUBJECT_PLACEHOLDERS_DEFAULT",
            "add_menu_item": "1",
            "replacement_type": "default",
            "useajax": "0",
            "verbose": "0",
            "ajax_allow_to_cancel": "0",
            "ajax_allowusergroups": "0",
            "ajax_allowusers": "0",
            "ajax_delay": "0",
            "mails_per_iteration": "3",
            "forceNotTimeLimit": "0",
            "showsuccessmessage": "0",
            "successmessage": "PLG_SYSTEM_NOTIFICATIONARY_FIELD_MAIL_HAS_BEEN_SENT",
            "successmessagenumberofusers": "0",
            "showerrormessage": "0",
            "errormessage": "PLG_SYSTEM_NOTIFICATIONARY_FIELD_MAIL_COULD_NOT_BE_SENT",
            "showContext": "0",
            "debug": "0",
            "generatefakeusers": "0",
            "fakeusersnumber": "1"
        }
    },
    "__vm": {
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"it-IT\",\"pricesCurrency\":\"47\",\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"orderdoneHtml\":false,\"virtuemart_order_id\":false}"
    },
    "__notificationary": {
        "AjaxHash": null
    }
}

Tempo

Memoria

63 query eseguite 101.71 ms

1. 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'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jcg62_session	const	PRIMARY	PRIMARY	766	const	1

   Profilo

   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

   Call Stack

   #	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

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

2. 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

   Explain

   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

   Profilo

   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

   Call Stack

   #	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

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

3. 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

   EXPLAIN non possibile sulla query: INSERT INTO `jcg62_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('h6976hv27v5sa88us7glo2qvj7', 1, '1524419869', 0, '', 0)

   Profilo

   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

   Call Stack

   #	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

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

4. 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`

   Explain

   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

   Profilo

   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

   Call Stack

   #	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

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

5. 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

   Explain

   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

   Profilo

   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

   Call Stack

   #	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

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

6. 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'

   Explain

   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

   Profilo

   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

   Call Stack

   #	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

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

7. 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'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jcg62_ak_storage	const	PRIMARY	PRIMARY	402	const	1

   Profilo

   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

   Call Stack

   #	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

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

8. 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

   EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `jcg62_content_types`

   Profilo

   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

   Call Stack

   #	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

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

9. 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'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jcg62_content_types	const	PRIMARY	PRIMARY	4	const	1

   Profilo

   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

   Call Stack

   #	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

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

10. 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'

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

11. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

12. 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

    EXPLAIN non possibile sulla query: UPDATE `jcg62_extensions` SET `params` = '{\"mediaversion\":\"accd4e221fa246b280e0d133b93803d4\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

13. 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' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jcg62_sobipro_object	const	PRIMARY	PRIMARY	4	const	1

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

14. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

15. 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' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jcg62_sobipro_field	const	PRIMARY	PRIMARY	4	const	1

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

16. 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
    Query duplicate: #32

    SELECT pid 
      FROM jcg62_sobipro_plugins 
      WHERE  ( enabled ='1' )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

17. 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' ) )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

18. 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
    Query duplicate: #34

    SELECT pid 
      FROM jcg62_sobipro_plugin_section 
      WHERE  ( section ='54' )  
      AND  ( enabled ='1' )  
      AND  ( pid  IN ( 'notifications' ) )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

19. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

20. 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' )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

21. 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' )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

22. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

23. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

24. 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 ='[]' )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

25. 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 ='[]' )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

26. 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' )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

27. 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

    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'

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

28. 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')

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

29. 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 )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

30. 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' ) )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

31. 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' )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

32. 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
    Query duplicate: #16

    SELECT pid 
      FROM jcg62_sobipro_plugins 
      WHERE  ( enabled ='1' )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

33. 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' ) )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

34. 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
    Query duplicate: #18

    SELECT pid 
      FROM jcg62_sobipro_plugin_section 
      WHERE  ( section ='54' )  
      AND  ( enabled ='1' )  
      AND  ( pid  IN ( 'notifications' ) )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

35. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

36. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

37. 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' )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

38. 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' ) )

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

39. 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

    EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `jcg62_template_styles`

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

40. 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'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jcg62_template_styles	const	PRIMARY	PRIMARY	4	const	1

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

41. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

42. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

43. 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

    EXPLAIN non possibile sulla query: SHOW TABLES LIKE "jcg62_virtuemart_configs"

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

44. 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";

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

45. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

46. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

47. 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)

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

48. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

50. 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"

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

51. 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"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jcg62_virtuemart_shoppergroups	const	PRIMARY	PRIMARY	4	const	1

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

52. 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"

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

53. 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"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jcg62_virtuemart_currencies	const	PRIMARY	PRIMARY	4	const	1

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

54. 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

    EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `jcg62_virtuemart_userfields`

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

55. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

56. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	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

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

57. 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

    Explain

    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

    Profilo

    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

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli