Contatti

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1623607450,
                "last": 1623607450,
                "now": 1623607450
            },
            "token": "qrcBNItdAwihnJrqdn95kw093SWQ7akP"
        },
        "registry": {},
        "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_languagefilter": {
            "language": "it-IT"
        },
        "com_rsform": {
            "recaptchav2Token4": null
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 40.52 ms / 40.52 ms Memoria: 0.824 MB / 1.05 MB Application: afterLoad

Tempo: 379.01 ms / 419.54 ms Memoria: 5.352 MB / 6.40 MB Application: afterInitialise

Tempo: 36.23 ms / 455.77 ms Memoria: 0.397 MB / 6.80 MB Application: Before Access::preloadComponents (all components)

Tempo: 2.11 ms / 457.89 ms Memoria: 0.177 MB / 6.98 MB Application: After Access::preloadComponents (all components)

Tempo: 0.11 ms / 457.99 ms Memoria: 0.000 MB / 6.97 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Tempo: 5.49 ms / 463.48 ms Memoria: 0.025 MB / 6.99 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Tempo: 37.60 ms / 501.08 ms Memoria: 0.245 MB / 7.24 MB Application: afterRoute

Tempo: 0.49 ms / 501.57 ms Memoria: 0.007 MB / 7.25 MB Application: beforeRenderComponent com_rsform

Tempo: 376.65 ms / 878.22 ms Memoria: 0.847 MB / 8.09 MB Application: afterRenderComponent com_rsform

Tempo: 19.09 ms / 897.31 ms Memoria: 0.122 MB / 8.21 MB Application: afterDispatch

Tempo: 52.45 ms / 949.76 ms Memoria: 0.841 MB / 9.05 MB Application: beforeRenderModule mod_custom (Back-inner)

Tempo: 42.61 ms / 992.37 ms Memoria: 0.018 MB / 9.07 MB Application: afterRenderModule mod_custom (Back-inner)

Tempo: 92.13 ms / 1084.50 ms Memoria: 0.087 MB / 9.16 MB Application: beforeRenderModule mod_custom (Logo)

Tempo: 1.74 ms / 1086.24 ms Memoria: 0.009 MB / 9.17 MB Application: afterRenderModule mod_custom (Logo)

Tempo: 2.72 ms / 1088.96 ms Memoria: 0.000 MB / 9.15 MB Application: beforeRenderModule mod_languages (Lingua)

Tempo: 18.90 ms / 1107.86 ms Memoria: 0.031 MB / 9.18 MB Application: afterRenderModule mod_languages (Lingua)

Tempo: 1.46 ms / 1109.32 ms Memoria: 0.025 MB / 9.20 MB Application: beforeRenderModule mod_search (Cerca)

Tempo: 30.15 ms / 1139.47 ms Memoria: 0.032 MB / 9.24 MB Application: afterRenderModule mod_search (Cerca)

Tempo: 16.87 ms / 1156.34 ms Memoria: 0.000 MB / 9.23 MB Application: beforeRenderModule mod_menu (Menu Principale it)

Tempo: 40.30 ms / 1196.64 ms Memoria: 0.208 MB / 9.44 MB Application: afterRenderModule mod_menu (Menu Principale it)

Tempo: 27.35 ms / 1223.98 ms Memoria: 0.126 MB / 9.57 MB Application: beforeRenderModule mod_breadcrumbs (goolgebreadcumbs)

Tempo: 32.50 ms / 1256.48 ms Memoria: 0.042 MB / 9.61 MB Application: afterRenderModule mod_breadcrumbs (goolgebreadcumbs)

Tempo: 17.88 ms / 1274.37 ms Memoria: 0.102 MB / 9.71 MB Application: beforeRenderModule mod_news_pro_gk5 (Eventi e News colonna)

Tempo: 78.04 ms / 1352.41 ms Memoria: 1.590 MB / 11.30 MB Application: afterRenderModule mod_news_pro_gk5 (Eventi e News colonna)

Tempo: 1.29 ms / 1353.70 ms Memoria: 0.000 MB / 11.14 MB Application: beforeRenderModule mod_custom (Loghi)

Tempo: 0.96 ms / 1354.67 ms Memoria: 0.009 MB / 11.15 MB Application: afterRenderModule mod_custom (Loghi)

Tempo: 14.98 ms / 1369.64 ms Memoria: 0.001 MB / 11.15 MB Application: beforeRenderModule mod_menu (Bottm Menu)

Tempo: 17.48 ms / 1387.12 ms Memoria: 0.066 MB / 11.22 MB Application: afterRenderModule mod_menu (Bottm Menu)

Tempo: 13.58 ms / 1400.70 ms Memoria: 0.000 MB / 11.22 MB Application: beforeRenderModule mod_custom (Footer)

Tempo: 1.63 ms / 1402.33 ms Memoria: 0.009 MB / 11.22 MB Application: afterRenderModule mod_custom (Footer)

Tempo: 0.73 ms / 1403.05 ms Memoria: 0.000 MB / 11.22 MB Application: beforeRenderModule mod_nice_social_bookmark (Nice Social)

Tempo: 15.32 ms / 1418.38 ms Memoria: 0.034 MB / 11.26 MB Application: afterRenderModule mod_nice_social_bookmark (Nice Social)

Tempo: 1.92 ms / 1420.30 ms Memoria: 0.000 MB / 11.22 MB Application: beforeRenderModule mod_customcss (Custom CSS)

Tempo: 0.78 ms / 1421.08 ms Memoria: 0.013 MB / 11.24 MB Application: afterRenderModule mod_customcss (Custom CSS)

Tempo: 0.08 ms / 1421.16 ms Memoria: 0.000 MB / 11.23 MB Application: beforeRenderModule mod_customcss (form)

Tempo: 0.23 ms / 1421.39 ms Memoria: 0.009 MB / 11.24 MB Application: afterRenderModule mod_customcss (form)

Tempo: 96.51 ms / 1517.89 ms Memoria: 0.383 MB / 11.63 MB Application: afterRender

Query totali del database: 124.39 ms

Utilizzo memoria

Query Database

70 query eseguite 124.39 ms

Trovati 10 duplicati!

2 duplicati: #9 #10

2 duplicati: #18 #20

2 duplicati: #40 #43

4 duplicati: #58 #59 #60 #61

Tempo della query: 2.11 ms Memoria query: 0.014 MB memoria prima della query: 1.637 MB Righe restituite: 0

SELECT `session_id`

  FROM `hscjz_session`

  WHERE `session_id` = 'hmr72dijnddq8kuu64274cja85' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profilo

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
Opening tables	1.55 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.13 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:767
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:351
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]

Tempo della query: 2.13 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.010 MB memoria prima della query: 1.654 MB

INSERT INTO `hscjz_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('hmr72dijnddq8kuu64274cja85', 1, 1623607451, 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `hscjz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('hmr72dijnddq8kuu64274cja85', 1, 1623607451, 0, '', 0)

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
update	0.07 ms
Waiting for query cache lock	0.00 ms
update	0.01 ms
end	0.00 ms
query end	1.81 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:767
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:351
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]

Tempo della query: 2.13 ms Dopo l'ultima query: 18.05 ms Memoria query: 0.015 MB memoria prima della query: 1.882 MB Righe restituite: 5

SELECT id, rules

  FROM `hscjz_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_viewlevels	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5

Profilo

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	1.59 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.17 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 2.72 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.015 MB memoria prima della query: 1.906 MB Righe restituite: 2

SELECT b.id

  FROM hscjz_usergroups AS a

  LEFT JOIN hscjz_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

Profilo

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	2.10 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.07 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.18 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
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:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 2.10 ms Dopo l'ultima query: 14.47 ms Memoria query: 0.017 MB memoria prima della query: 2.401 MB Righe restituite: 0

SELECT `path`

  FROM hscjz_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsfirewall_ignored	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using where

Profilo

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
Opening tables	1.45 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.24 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 2.05 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.017 MB memoria prima della query: 2.418 MB Righe restituite: 0

SELECT `file`

  FROM hscjz_rsfirewall_hashes

  WHERE `type`='protect'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsfirewall_hashes	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	80	Using where

Profilo

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	1.51 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.05 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 1.84 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.023 MB memoria prima della query: 2.433 MB Righe restituite: 65

SELECT *

  FROM hscjz_rsfirewall_configuration

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsfirewall_configuration	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	65

Profilo

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	1.34 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.07 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	1.22 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 4.46 ms Dopo l'ultima query: 13.64 ms Memoria query: 0.024 MB memoria prima della query: 2.823 MB Righe restituite: 10

SHOW FULL COLUMNS 
  FROM `hscjz_rsfirewall_logs`

Explain

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

Profilo

Status	Duration
starting	0.25 ms
checking permissions	0.02 ms
closing tables	0.01 ms
Opening tables	0.60 ms
After opening tables	0.01 ms
System lock	0.01 ms
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
Opening tables	2.63 ms
After opening tables	0.02 ms
checking permissions	0.08 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.02 ms
executing	0.01 ms
Sending data	0.10 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
Unlocking tables	0.01 ms
freeing items	0.16 ms
updating status	0.05 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:47
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 3.51 ms Dopo l'ultima query: 24.26 ms Memoria query: 0.020 MB memoria prima della query: 3.261 MB Righe restituite: 1

Query duplicate: #10

SELECT template

  FROM hscjz_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_home	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	Using where

Profilo

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
Opening tables	2.67 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.04 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
Unlocking tables	0.02 ms
freeing items	0.12 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 0.21 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.021 MB memoria prima della query: 3.281 MB Righe restituite: 1

Query duplicate: #9

SELECT template

  FROM hscjz_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_home	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	Using where

Profilo

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.08 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 4.00 ms Dopo l'ultima query: 9.57 ms Memoria query: 0.016 MB memoria prima della query: 3.487 MB Righe restituite: 2

SELECT extension, file, type

  FROM hscjz_rokcommon_configs

  ORDER BY priority

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rokcommon_configs	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	Using filesort

Profilo

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.01 ms
Opening tables	3.12 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.05 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 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
Unlocking tables	0.02 ms
freeing items	0.11 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.36 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 5.88 ms Dopo l'ultima query: 107.81 ms Memoria query: 0.018 MB memoria prima della query: 5.099 MB

UPDATE `hscjz_extensions`

  SET `params` = '{\"mediaversion\":\"dc0c132e9b7b26ea398a8d3f0007629f\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profilo

Status	Duration
starting	0.24 ms
checking permissions	0.02 ms
Opening tables	2.71 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.17 ms
updating	0.11 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	2.29 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.12 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:47
9	plgSystemK2->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:633
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 2.08 ms Dopo l'ultima query: 43.19 ms Memoria query: 0.019 MB memoria prima della query: 5.913 MB Righe restituite: 35

SELECT *

  FROM hscjz_rsform_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_config	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	35

Profilo

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	1.51 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.17 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
12	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
11	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
10	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
9	plgSystemRsformdeletesubmissions->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:633
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 0.28 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.014 MB memoria prima della query: 5.940 MB

UPDATE hscjz_rsform_config

  SET `SettingValue`='1623607451'

  WHERE `SettingName`='deleteafter.last_run'

Explain

EXPLAIN non possibile sulla query: UPDATE hscjz_rsform_config SET `SettingValue`='1623607451' WHERE `SettingName`='deleteafter.last_run'

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.03 ms
updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_rsform/helpers/config.php:90
10	RSFormProConfig->set()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:37
9	plgSystemRsformdeletesubmissions->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:633
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 1.71 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.015 MB memoria prima della query: 5.955 MB Righe restituite: 0

SELECT `FormId`,`DeleteSubmissionsAfter`

  FROM `hscjz_rsform_forms`

  WHERE `DeleteSubmissionsAfter` > '0'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_forms	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	Using where

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	1.31 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.10 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:47
9	plgSystemRsformdeletesubmissions->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:633
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 0.58 ms Dopo l'ultima query: 1.29 ms Memoria query: 0.024 MB memoria prima della query: 5.993 MB Righe restituite: 18

SHOW FULL COLUMNS 
  FROM `hscjz_extensions`

Explain

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

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
closing tables	0.01 ms
Opening tables	0.18 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.03 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
11	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:633
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 0.48 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.016 MB memoria prima della query: 6.056 MB Righe restituite: 1

SELECT `extension_id`

  FROM `hscjz_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.16 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:49
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:633
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 0.39 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.020 MB memoria prima della query: 6.074 MB Righe restituite: 1

Query duplicate: #20

SELECT *

  FROM hscjz_extensions

  WHERE `extension_id` = '10065'

Explain

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

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.17 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:633
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 0.26 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.016 MB memoria prima della query: 6.089 MB Righe restituite: 1

SELECT `extension_id`

  FROM `hscjz_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.18 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:72
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:633
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 0.12 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.020 MB memoria prima della query: 6.105 MB Righe restituite: 1

Query duplicate: #18

SELECT *

  FROM hscjz_extensions

  WHERE `extension_id` = '10065'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:633
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 0.89 ms Dopo l'ultima query: 61.74 ms Memoria query: 0.024 MB memoria prima della query: 6.352 MB Righe restituite: 1

SELECT extension_id AS id, element AS "option", params, enabled

  FROM hscjz_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_advancedmodules'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profilo

Status	Duration
starting	0.11 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	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
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.10 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.13 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
17	JDatabaseDriver->loadObject()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:92
16	RokSprocket_Addon_AdvancedModuleManager->isComponentEnabled()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:17
15	RokSprocket_Addon_AdvancedModuleManager->__construct()	Same as call in the line below.
14	ReflectionClass->newInstanceArgs()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:248
13	RokCommon_Service_Container_Builder->createService()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:86
12	RokCommon_Service_Container_Builder->getService()	JROOT/libraries/rokcommon/RokCommon/Service/ContainerImpl.php:377
11	RokCommon_Service_ContainerImpl->__get()	JROOT/plugins/system/roksprocket/roksprocket.php:225
10	plgSystemRokSprocket->loadAddons()	JROOT/plugins/system/roksprocket/roksprocket.php:91
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	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:633
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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:203
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]

Tempo della query: 0.54 ms Dopo l'ultima query: 29.46 ms Memoria query: 0.016 MB memoria prima della query: 6.691 MB Righe restituite: 0

SELECT *

  FROM hscjz_rsfirewall_hashes

  WHERE (`type`='3.9.0' OR `type`='protect') 
  AND `flag`!='C'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsfirewall_hashes	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	80	Using where

Profilo

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1034
9	plgSystemRsfirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1126
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 1.93 ms Dopo l'ultima query: 0.90 ms Memoria query: 0.017 MB memoria prima della query: 6.711 MB Righe restituite: 1

SELECT *

  FROM hscjz_rsfirewall_snapshots

  WHERE `type`='protect'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsfirewall_snapshots	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using where

Profilo

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	1.54 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
10	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1057
9	plgSystemRsfirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1126
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 1.49 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.018 MB memoria prima della query: 6.727 MB Righe restituite: 1

SELECT *

  FROM `hscjz_users`

  WHERE `id` = '289'

Explain

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

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	1.17 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1072
9	plgSystemRsfirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1126
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 1.25 ms Dopo l'ultima query: 0.37 ms Memoria query: 0.017 MB memoria prima della query: 6.748 MB Righe restituite: 0

SELECT `ip`,`reason`

  FROM hscjz_rsfirewall_lists

  WHERE (`ip`='3.236.118.7' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsfirewall_lists	ref	published,type,ip	type	1	const	1	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.93 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
11	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
10	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1093
9	plgSystemRsfirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1126
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 0.26 ms Dopo l'ultima query: 0.34 ms Memoria query: 0.017 MB memoria prima della query: 6.765 MB Righe restituite: 0

SELECT `ip`,`reason`

  FROM hscjz_rsfirewall_lists

  WHERE (`ip`='3.236.118.7' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsfirewall_lists	ALL	published,type,ip	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
11	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:134
10	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1097
9	plgSystemRsfirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1126
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 1.05 ms Dopo l'ultima query: 0.89 ms Memoria query: 0.018 MB memoria prima della query: 6.785 MB Righe restituite: 0

SELECT *

  FROM hscjz_rsfirewall_exceptions

  WHERE `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsfirewall_exceptions	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using where

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.79 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:695
10	plgSystemRsfirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1228
9	plgSystemRsfirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1126
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 1.40 ms Dopo l'ultima query: 2.12 ms Memoria query: 0.028 MB memoria prima della query: 6.808 MB Righe restituite: 49

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `hscjz_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gdpr','com_gsd','com_installer','com_jce','com_jmap','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_offlajn_installer','com_plugins','com_postinstall','com_privacy','com_redirect','com_rereplacer','com_roksprocket','com_rsfirewall','com_rsform','com_search','com_searchsource','com_sigpro','com_tags','com_templates','com_uniterevolution2','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_assets	ALL	idx_asset_name	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	122	Using where

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	0.81 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.17 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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/plugins/system/advancedmodules/src/Document.php:28
13	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
12	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Same as call in the line below.
11	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
10	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:64
9	PlgSystemAdvancedModules->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	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:1126
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 1.50 ms Dopo l'ultima query: 135.47 ms Memoria query: 0.054 MB memoria prima della query: 7.429 MB Righe restituite: 1

SELECT *

  FROM `hscjz_rsform_forms`

  WHERE `FormId`='4'

Explain

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

Profilo

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.08 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
Waiting for query cache lock	0.02 ms
init	0.09 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.18 ms
Waiting for query cache lock	0.01 ms
Sending data	0.44 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.13 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsform/helpers/rsform.php:3387
15	RSFormProHelper::getForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:215
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 0.85 ms Dopo l'ultima query: 0.72 ms Memoria query: 0.023 MB memoria prima della query: 7.496 MB Righe restituite: 1

SELECT `Lang`

  FROM hscjz_rsform_forms

  WHERE `FormId` = '4'

Explain

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

Profilo

Status	Duration
starting	0.14 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	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
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
Unlocking tables	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
Unlocking tables	0.02 ms
freeing items	0.09 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsform/helpers/rsform.php:2841
15	RSFormProHelper::getTranslations()	JROOT/administrator/components/com_rsform/helpers/rsform.php:272
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 6.52 ms Dopo l'ultima query: 0.49 ms Memoria query: 0.025 MB memoria prima della query: 7.519 MB Righe restituite: 15

SELECT *

  FROM hscjz_rsform_translations

  WHERE `form_id` = '4' 
  AND `lang_code` = 'it-IT' 
  AND `reference` = 'forms'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_translations	ref	form_id,lang_code,reference,lang_search	lang_search	869	const,const,const	15	Using index condition

Profilo

Status	Duration
starting	0.11 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	4.12 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.68 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.87 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.11 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/rsform.php:2876
15	RSFormProHelper::getTranslations()	JROOT/administrator/components/com_rsform/helpers/rsform.php:272
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 4.83 ms Dopo l'ultima query: 8.35 ms Memoria query: 0.024 MB memoria prima della query: 7.562 MB Righe restituite: 0

SELECT `ComponentId`

  FROM `hscjz_rsform_components`

  WHERE `ComponentTypeId` IN (6) 
  AND `FormId` = '4' 
  AND `Published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	2	Using where

Profilo

Status	Duration
starting	0.17 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
Opening tables	3.54 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.04 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.14 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1469
16	RSFormProHelper::componentExists()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1532
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 0.46 ms Dopo l'ultima query: 0.46 ms Memoria query: 0.025 MB memoria prima della query: 7.586 MB Righe restituite: 0

SELECT `ComponentId`

  FROM `hscjz_rsform_components`

  WHERE `ComponentTypeId` IN (411) 
  AND `FormId` = '4' 
  AND `Published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	Using where

Profilo

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1469
16	RSFormProHelper::componentExists()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1533
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 0.39 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.024 MB memoria prima della query: 7.610 MB Righe restituite: 0

SELECT `ComponentId`

  FROM `hscjz_rsform_components`

  WHERE `ComponentTypeId` IN (355) 
  AND `FormId` = '4' 
  AND `Published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	Using where

Profilo

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1469
16	RSFormProHelper::componentExists()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1534
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 6.94 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.026 MB memoria prima della query: 7.638 MB Righe restituite: 9

SELECT `p`.`PropertyValue` AS `name`,`c`.`ComponentId`,`c`.`ComponentTypeId`,`ct`.`ComponentTypeName`,`c`.`
  Order`

  FROM `hscjz_rsform_properties` AS `p`

  LEFT JOIN `hscjz_rsform_components` AS `c` 
  ON (`c`.`ComponentId` = `p`.`ComponentId`)

  LEFT JOIN `hscjz_rsform_component_types` AS `ct` 
  ON (`ct`.`ComponentTypeId` = `c`.`ComponentTypeId`)

  WHERE `c`.`FormId` = '4' 
  AND `p`.`PropertyName` = 'NAME' 
  AND `c`.`Published` = '1'

  ORDER BY `c`.`
  Order` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ComponentId,FormId	FormId	4	const	9	Using where; Using filesort
1	SIMPLE	ct	eq_ref	PRIMARY	PRIMARY	4	h184345_effe.c.ComponentTypeId	1
1	SIMPLE	p	ref	ComponentId	ComponentId	4	h184345_effe.c.ComponentId	7	Using where

Profilo

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	5.06 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.08 ms
Sending data	1.31 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/rsform.php:2531
16	RSFormProHelper::getComponents()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1542
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 1.38 ms Dopo l'ultima query: 56.45 ms Memoria query: 0.028 MB memoria prima della query: 7.689 MB Righe restituite: 97

SELECT `PropertyName`,`PropertyValue`,`ComponentId`

  FROM `hscjz_rsform_properties`

  WHERE `ComponentId` IN (41,37,38,39,40,42,43,48,44)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_properties	ALL	ComponentId	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	408	Using where

Profilo

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.63 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/rsform.php:643
16	RSFormProHelper::getComponentProperties()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1606
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 0.97 ms Dopo l'ultima query: 3.08 ms Memoria query: 0.025 MB memoria prima della query: 7.811 MB Righe restituite: 1

SELECT `FormId`

  FROM `hscjz_rsform_components`

  WHERE `ComponentId`='41'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_components	const	ComponentId	ComponentId	4	const	1

Profilo

Status	Duration
starting	0.13 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.13 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
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.14 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsform/helpers/rsform.php:658
16	RSFormProHelper::getComponentProperties()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1606
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 1.66 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.029 MB memoria prima della query: 7.839 MB Righe restituite: 29

SELECT *

  FROM hscjz_rsform_translations

  WHERE `form_id` = '4' 
  AND `lang_code` = 'it-IT' 
  AND `reference` = 'properties'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_translations	ref	form_id,lang_code,reference,lang_search	lang_search	869	const,const,const	29	Using index condition

Profilo

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 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
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.26 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.75 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.04 ms
freeing items	0.10 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/rsform.php:2876
17	RSFormProHelper::getTranslations()	JROOT/administrator/components/com_rsform/helpers/rsform.php:664
16	RSFormProHelper::getComponentProperties()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1606
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 0.52 ms Dopo l'ultima query: 159.13 ms Memoria query: 0.028 MB memoria prima della query: 7.950 MB Righe restituite: 0

SELECT `ComponentId`

  FROM `hscjz_rsform_components`

  WHERE `ComponentTypeId` IN (41) 
  AND `FormId` = '4' 
  AND `Published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	2	Using where

Profilo

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
20	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1469
19	RSFormProHelper::componentExists()	JROOT/administrator/components/com_rsform/helpers/fields/button.php:146
18	RSFormProFieldButton->getPreviousButton()	JROOT/administrator/components/com_rsform/helpers/fields/submitbutton.php:56
17	RSFormProFieldSubmitButton->getFormInput()	JROOT/administrator/components/com_rsform/helpers/field.php:45
16	RSFormProField->__get()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1717
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 0.37 ms Dopo l'ultima query: 0.41 ms Memoria query: 0.030 MB memoria prima della query: 7.982 MB Righe restituite: 1

Query duplicate: #43

SELECT `ComponentId`

  FROM `hscjz_rsform_components`

  WHERE `ComponentTypeId` IN (2424) 
  AND `FormId` = '4' 
  AND `Published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	2	Using where

Profilo

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
22	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1469
21	RSFormProHelper::componentExists()	JROOT/plugins/system/rsfprecaptchav2/rsfprecaptchav2.php:113
20	plgSystemRsfprecaptchav2->rsfp_f_onInitFormDisplay()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1773
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 0.66 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.030 MB memoria prima della query: 8.011 MB Righe restituite: 0

SELECT `ComponentId`

  FROM `hscjz_rsform_components`

  WHERE `ComponentTypeId` IN (2423) 
  AND `FormId` = '4' 
  AND `Published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	Using where

Profilo

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.01 ms
updating status	0.27 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
22	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1469
21	RSFormProHelper::componentExists()	JROOT/plugins/system/rsfprecaptchav3/rsfprecaptchav3.php:89
20	plgSystemRsfprecaptchav3->rsfp_f_onInitFormDisplay()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1773
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 0.61 ms Dopo l'ultima query: 0.39 ms Memoria query: 0.025 MB memoria prima della query: 8.045 MB Righe restituite: 0

SELECT `ComponentId`

  FROM `hscjz_rsform_components`

  WHERE `ComponentTypeId` IN (9) 
  AND `FormId` = '4' 
  AND `Published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	2	Using where

Profilo

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.36 ms
Waiting for query cache lock	0.22 ms
updating status	0.01 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1469
16	RSFormProHelper::componentExists()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1853
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 0.15 ms Dopo l'ultima query: 3.68 ms Memoria query: 0.030 MB memoria prima della query: 8.076 MB Righe restituite: 1

Query duplicate: #40

SELECT `ComponentId`

  FROM `hscjz_rsform_components`

  WHERE `ComponentTypeId` IN (2424) 
  AND `FormId` = '4' 
  AND `Published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	2	Using where

Profilo

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
22	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1469
21	RSFormProHelper::componentExists()	JROOT/plugins/system/rsfprecaptchav2/rsfprecaptchav2.php:87
20	plgSystemRsfprecaptchav2->rsfp_f_onAJAXScriptCreate()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1920
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 1.19 ms Dopo l'ultima query: 13.30 ms Memoria query: 0.026 MB memoria prima della query: 8.109 MB Righe restituite: 9

SELECT `p`.`PropertyValue` AS `ComponentName`,`p`.`ComponentId`

  FROM `hscjz_rsform_components` AS `c`

  LEFT JOIN `hscjz_rsform_properties` AS `p` 
  ON (`c`.`ComponentId`=`p`.`ComponentId`)

  WHERE `c`.`FormId`='4' 
  AND `p`.`PropertyName`='NAME' 
  AND `c`.`Published` = '1'

  ORDER BY `c`.`
  Order` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ComponentId,FormId	FormId	4	const	9	Using where; Using filesort
1	SIMPLE	p	ref	ComponentId	ComponentId	4	h184345_effe.c.ComponentId	7	Using where

Profilo

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.09 ms
checking permissions	0.00 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
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.05 ms
Sending data	0.30 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.30 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/conditions.php:36
17	RSFormProConditions::getFields()	JROOT/administrator/components/com_rsform/helpers/conditions.php:72
16	RSFormProConditions::getConditions()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1943
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 4.08 ms Dopo l'ultima query: 0.30 ms Memoria query: 0.026 MB memoria prima della query: 8.139 MB Righe restituite: 0

SELECT *

  FROM `hscjz_rsform_conditions`

  WHERE `form_id` = '4' 
  AND `lang_code` = 'it-IT'

  ORDER BY `id` ASC

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 noticed after reading const tables

Profilo

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	3.33 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.35 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/conditions.php:82
16	RSFormProConditions::getConditions()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1943
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 3.34 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.025 MB memoria prima della query: 8.162 MB Righe restituite: 0

SELECT *

  FROM `hscjz_rsform_calculations`

  WHERE `formId` = '4'

  ORDER BY `ordering`

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 noticed after reading const tables

Profilo

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	2.93 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.04 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/rsform.php:3354
16	RSFormProHelper::getCalculations()	JROOT/administrator/components/com_rsform/helpers/rsform.php:1949
15	RSFormProHelper::showForm()	JROOT/administrator/components/com_rsform/helpers/rsform.php:369
14	RSFormProHelper::displayForm()	JROOT/components/com_rsform/views/rsform/tmpl/default.php:13
13	include JROOT/components/com_rsform/views/rsform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rsform/views/rsform/view.html.php:43
10	RsformViewRsform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rsform/controller.php:434
8	RsformController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rsform/rsform.php:39
6	require_once JROOT/components/com_rsform/rsform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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]

Tempo della query: 1.74 ms Dopo l'ultima query: 1.29 ms Memoria query: 0.014 MB memoria prima della query: 8.108 MB Righe restituite: 0

SELECT id,placeholder

  FROM `hscjz_gdpr_checkbox`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_gdpr_checkbox	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1

Profilo

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	1.41 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/gdpr/gdpr.php:1084
8	plgSystemGdpr->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	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:203
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]

Tempo della query: 1.69 ms Dopo l'ultima query: 2.58 ms Memoria query: 0.016 MB memoria prima della query: 8.135 MB Righe restituite: 3

SELECT language,id

  FROM `hscjz_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	hscjz_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	55	Using where

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	1.24 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.26 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	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:203
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]

Tempo della query: 2.74 ms Dopo l'ultima query: 3.88 ms Memoria query: 0.017 MB memoria prima della query: 8.177 MB Righe restituite: 2

SELECT `c2`.`language`,`c2`.`id`

  FROM `hscjz_menu` AS `c`

  INNER JOIN `hscjz_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `hscjz_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `hscjz_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 164

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	h184345_effe.a2.id	1

Profilo

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	2.20 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
10	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	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:203
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]

Tempo della query: 4.06 ms Dopo l'ultima query: 22.61 ms Memoria query: 0.032 MB memoria prima della query: 8.458 MB Righe restituite: 23

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM hscjz_modules AS m

  LEFT JOIN hscjz_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  LEFT JOIN hscjz_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 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	published,newsfeeds,idx_language	published	1	const	33	Using index condition; Using where; Using filesort
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	h184345_effe.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	h184345_effe.m.module,const	1	Using index condition; Using where

Profilo

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	2.15 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.05 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.00 ms
Sorting result	0.24 ms
Sending data	0.32 ms
Waiting for query cache lock	0.01 ms
Sending data	0.18 ms
Waiting for query cache lock	0.01 ms
Sending data	0.34 ms
Waiting for query cache lock	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.06 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:554
19	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:155
18	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_eat/layouts/theme.config.php:26
10	include JROOT/templates/yoo_eat/layouts/theme.config.php	JROOT/templates/yoo_eat/layouts/theme.php:10
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/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:1037
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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]

Tempo della query: 1.32 ms Dopo l'ultima query: 371.65 ms Memoria query: 0.030 MB memoria prima della query: 10.039 MB Righe restituite: 1

select enabled 
  from hscjz_extensions 
  where type="component" 
  and element = "com_k2"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hscjz_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profilo

Status	Duration
starting	0.11 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	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
Waiting for query cache lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.09 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.42 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
21	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:80
20	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
19	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:630
15	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_eat/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_eat/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_eat/layouts/theme.php:163
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/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:1037
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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]

Tempo della query: 4.64 ms Dopo l'ultima query: 2.38 ms Memoria query: 0.032 MB memoria prima della query: 10.074 MB Righe restituite: 7

SELECT
					c.id AS CID
				
  FROM
					hscjz_k2_categories AS c
				
  LEFT JOIN
					hscjz_k2_items AS content
					
  ON
					c.id = content.catid
				
				
  WHERE
					1=1
					 
  AND ( c.id = 3) 
					
  AND
					c.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,category,published	PRIMARY	4	const	1
1	SIMPLE	content	ref	catid	catid	4	const	7	Using index

Profilo

Status	Duration
starting	0.10 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	3.15 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.05 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.11 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.61 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:82
22	NSP_GK5_com_k2_Model::getSources()	Same as call in the line below.
21	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:106
20	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31
19	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:630
15	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_eat/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_eat/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_eat/layouts/theme.php:163
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/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:1037
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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]

Tempo della query: 1.50 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.031 MB memoria prima della query: 10.107 MB Righe restituite: 2

SELECT
			content.id AS id
		
  FROM
			hscjz_k2_items AS content
			
			
		
  WHERE
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5) 
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2021-06-13 20:04:12' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2021-06-13 20:04:12' )
			 
  AND (  content.catid = 3 ) 
			 
  AND content.language in ('it-IT','*') 
			
			
			

		

		
  ORDER BY
			 content.created DESC 
		
  LIMIT
			0,2;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	ref	item,catid,language	catid	4	const	7	Using where; Using filesort

Profilo

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.13 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
Waiting for query cache lock	0.03 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.13 ms
preparing	0.06 ms
executing	0.01 ms
Sorting result	0.18 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.04 ms
freeing items	0.11 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.42 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
23	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:267
22	NSP_GK5_com_k2_Model::getArticles()	Same as call in the line below.
21	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:125
20	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31
19	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:630
15	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_eat/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_eat/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_eat/layouts/theme.php:163
9	include JROOT/templates/yoo_eat/layouts/theme.php	JROOT/templates/yoo_eat/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_eat/index.php:16
7	require JROOT/templates/yoo_eat/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:1037
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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]

Tempo della query: 3.17 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.036 MB memoria prima della query: 10.141 MB Righe restituite: 2

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title,
			content.introtext AS text,
			content.created AS date,
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage,
			content.access AS access,
			content.catid AS cid,
			content.video AS video,
			content.plugins AS plugins,
			categories.name AS catname,
			categories.image AS cat_image,
			categories.alias AS cat_alias,
			users.email AS author_email,
			content.created_by_alias AS author_alias,
			users.name AS author_username,
			content.created_by AS author_id,
			content_rating.rating_sum AS rating_sum,
			content_rating.rating_count AS rating_count
		
  FROM
			hscjz_k2_items AS content
			
  LEFT JOIN
				hscjz_k2_categories AS categories
				
  ON categories.id = content.catid
			
  LEFT JOIN
				hscjz_users AS users
				
  ON users.id = content.created_by
			
  LEFT JOIN
				hscjz_k2_rating AS content_rating
				
  ON content_rating.itemID = content.id
		
  WHERE
			1=1
			 
  AND ( content.id = 39 OR  content.id = 38)
		
  ORDER BY
			 content.created DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	range	PRIMARY	PRIMARY	4	NULL	2	Using where; Using filesort
1	SIMPLE	categories	eq_ref	PRIMARY	PRIMARY	4	h184345_effe.content.catid	1	Using where
1	SIMPLE	users	eq_ref	PRIMARY	PRIMARY	4	h184345_effe.content.created_by	1
1	SIMPLE	content_rating	eq_ref	PRIMARY	PRIMARY	4	h184345_effe.content.id	1

Profilo

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.20 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	2.21 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.05 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.07 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
23	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:326
22	NSP_GK5_com_k2_Model::getArticles()	Same as call in the line below.
21	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:125
20	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31
19	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
18	Joomla\CMS\Helper\ModuleHelper::renderModule()	Sam

Politica per la Qualità

Certificazione ISO 9001:2015

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

70 query eseguite 124.39 ms

Trovati 10 duplicati!