SENIOR RHINOSSerie C 2017/2018

Rhinos SeniorSerie C 2018/2019

Parliamo di Senior

I Senior puro agonismo

Il Campionato 2016/2017 segna la ripartenza dopo qualche stagione senza un formazione Senior.
La Nuova Serie C ci permette di presentarci con una formazione composta dai nostri atleti all'ultimo anno di giovanile e atleti prestati della Hockey Sacile .

Continua...

Essere Rhinos

Allenamenti

Gli allenamenti dei Senior si svolgono da settembre a giugno inoltrato nel pattinodromo di via cartieretta a Treviso quartiere Santa Maria del Rovere zona Acquette nelle giornate del martedi dalle 20:30 alle 22:30 e il giovedi dalle 20:00 alle 21:30

NEWS SENIOR

18 Agosto 2018

30/08 Inizio Attività stagione 2018/2019

See All Notice

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1632747764,
                "last": 1632747764,
                "now": 1632747764
            },
            "token": "ippEEHqg9gcJXeeu82OyzJOMqs81AYAx"
        },
        "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
        },
        "fabrik": {
            "js": {
                "scripts": null,
                "cacheids": null,
                "head": {
                    "scripts": null,
                    "cache": {
                        "7f3a88d11ea80c9b8d33327086b60631": "{\"\\/joomla\\/sthockey\\/media\\/jui\\/js\\/jquery.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\/joomla\\/sthockey\\/media\\/jui\\/js\\/jquery-noconflict.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}},\"\\/joomla\\/sthockey\\/media\\/jui\\/js\\/jquery-migrate.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\/joomla\\/sthockey\\/components\\/com_sppagebuilder\\/assets\\/js\\/jquery.parallax.js\":{\"type\":\"text\\/javascript\",\"options\":[]},\"\\/joomla\\/sthockey\\/components\\/com_sppagebuilder\\/assets\\/js\\/jquery.mb.YTPlayer.min.js\":{\"type\":\"text\\/javascript\",\"options\":[]},\"\\/joomla\\/sthockey\\/components\\/com_sppagebuilder\\/assets\\/js\\/jquery.mb.vimeo_player.min.js\":{\"type\":\"text\\/javascript\",\"options\":[]},\"\\/joomla\\/sthockey\\/components\\/com_sppagebuilder\\/assets\\/js\\/sppagebuilder.js\":{\"type\":\"text\\/javascript\",\"options\":[]},\"https:\\/\\/www.hockeytreviso.it\\/joomla\\/sthockey\\/\\/templates\\/shaper_educon\\/js\\/owl.carousel.min.js\":{\"type\":\"text\\/javascript\",\"options\":[]},\"https:\\/\\/www.hockeytreviso.it\\/joomla\\/sthockey\\/\\/templates\\/shaper_educon\\/js\\/addon.slider.js\":{\"type\":\"text\\/javascript\",\"options\":[]},\"\\/joomla\\/sthockey\\/media\\/jui\\/js\\/bootstrap.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"detectDebug\":\"1\",\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true}},\"\\/joomla\\/sthockey\\/templates\\/shaper_educon\\/js\\/bootstrap.min.js\":{\"type\":\"text\\/javascript\",\"options\":[]},\"\\/joomla\\/sthockey\\/templates\\/shaper_educon\\/js\\/jquery.sticky.js\":{\"type\":\"text\\/javascript\",\"options\":[]},\"\\/joomla\\/sthockey\\/templates\\/shaper_educon\\/js\\/main.js\":{\"type\":\"text\\/javascript\",\"options\":[]},\"\\/joomla\\/sthockey\\/templates\\/shaper_educon\\/js\\/frontend-edit.js\":{\"type\":\"text\\/javascript\",\"options\":[]},\"\\/joomla\\/sthockey\\/media\\/system\\/js\\/core-uncompressed.js\":{\"type\":\"text\\/javascript\",\"options\":{\"version\":\"auto\",\"relative\":true,\"framework\":false,\"pathOnly\":false,\"detectBrowser\":true,\"detectDebug\":true}}}"
                    }
                },
                "config": null,
                "shim": null,
                "jlayouts": null
            }
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 15.20 ms / 15.20 ms Memoria: 1.843 MB / 2.23 MB Application: afterLoad

Tempo: 70.12 ms / 85.32 ms Memoria: 6.872 MB / 9.10 MB Application: afterInitialise

Tempo: 13.37 ms / 98.69 ms Memoria: 1.101 MB / 10.20 MB Application: afterRoute

Tempo: 8.21 ms / 106.90 ms Memoria: 0.479 MB / 10.68 MB Application: beforeRenderComponent com_sppagebuilder

Tempo: 5.33 ms / 112.23 ms Memoria: 0.418 MB / 11.10 MB Application: Before Access::preloadComponents (all components)

Tempo: 1.24 ms / 113.47 ms Memoria: 0.067 MB / 11.17 MB Application: After Access::preloadComponents (all components)

Tempo: 0.03 ms / 113.50 ms Memoria: -0.003 MB / 11.16 MB Application: Before Access::getAssetRules (id:65 name:com_sppagebuilder)

Tempo: 0.48 ms / 113.98 ms Memoria: 0.030 MB / 11.19 MB Application: After Access::getAssetRules (id:65 name:com_sppagebuilder)

Tempo: 77.20 ms / 191.17 ms Memoria: 4.992 MB / 16.19 MB Application: beforeRenderModule mod_articles_latest (News Senior)

Tempo: 2.36 ms / 193.53 ms Memoria: 0.198 MB / 16.38 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tempo: 0.05 ms / 193.58 ms Memoria: 0.007 MB / 16.39 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tempo: 22.30 ms / 215.88 ms Memoria: 0.130 MB / 16.52 MB Application: afterRenderModule mod_articles_latest (News Senior)

Tempo: 2.70 ms / 218.58 ms Memoria: 0.022 MB / 16.54 MB Application: Before Access::preloadPermissions (com_sppagebuilder)

Tempo: 0.66 ms / 219.25 ms Memoria: 0.034 MB / 16.58 MB Application: After Access::preloadPermissions (com_sppagebuilder)

Tempo: 0.02 ms / 219.27 ms Memoria: -0.001 MB / 16.58 MB Application: Before Access::getAssetRules (id:71 name:com_sppagebuilder.page.3)

Tempo: 0.01 ms / 219.28 ms Memoria: 0.002 MB / 16.58 MB Application: After Access::getAssetRules (id:71 name:com_sppagebuilder.page.3)

Tempo: 0.07 ms / 219.35 ms Memoria: -0.127 MB / 16.45 MB Application: afterRenderComponent com_sppagebuilder

Tempo: 10.58 ms / 229.92 ms Memoria: 0.133 MB / 16.58 MB Application: afterDispatch

Tempo: 26.83 ms / 256.76 ms Memoria: 1.136 MB / 17.72 MB Application: afterRender

Query totali del database: 58.78 ms

Utilizzo memoria

Query Database

29 query eseguite 58.78 ms

Trovati 2 duplicati!

2 duplicati: #18 #20

Tempo della query: 0.43 ms Memoria query: 0.007 MB memoria prima della query: 3.965 MB Righe restituite: 0

SELECT `data`

  FROM `bhw7m_session`

  WHERE `session_id` = X'6334623132383137313064663165643763366638643762346631643935633264'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.18 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
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:414
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: 0.23 ms Dopo l'ultima query: 1.20 ms Memoria query: 0.004 MB memoria prima della query: 4.061 MB Righe restituite: 0

SELECT `session_id`

  FROM `bhw7m_session`

  WHERE `session_id` = X'6334623132383137313064663165643763366638643762346631643935633264' 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
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:414
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: 0.31 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.004 MB memoria prima della query: 4.066 MB

INSERT INTO `bhw7m_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6334623132383137313064663165643763366638643762346631643935633264', 1, 1632747764, 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `bhw7m_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6334623132383137313064663165643763366638643762346631643935633264', 1, 1632747764, 0, '', 0)

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.06 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.00 ms
query end	0.04 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
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:414
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: 0.62 ms Dopo l'ultima query: 2.62 ms Memoria query: 0.006 MB memoria prima della query: 4.285 MB Righe restituite: 39

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

  FROM `bhw7m_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_extensions	ref	extension	extension	62	const	39	100.00	Using index condition; Using where

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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: 2.21 ms Memoria query: 0.005 MB memoria prima della query: 4.484 MB Righe restituite: 5

SELECT id, rules

  FROM `bhw7m_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_viewlevels	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	100.00	NULL

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	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.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.51 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.005 MB memoria prima della query: 4.496 MB Righe restituite: 2

SELECT b.id

  FROM bhw7m_usergroups AS a

  LEFT JOIN bhw7m_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	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.02 ms
System lock	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.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.30 ms Dopo l'ultima query: 0.62 ms Memoria query: 0.005 MB memoria prima della query: 4.565 MB Righe restituite: 127

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM bhw7m_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_extensions	ref	extension	extension	62	const	151	100.00	Using index condition; Using where; Using filesort

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.67 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.57 ms Dopo l'ultima query: 43.47 ms Memoria query: 0.009 MB memoria prima della query: 9.354 MB Righe restituite: 41

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM bhw7m_menu AS m

  LEFT JOIN bhw7m_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	49	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	hk23tv9s_sthockey.m.component_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.19 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.56 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.14 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1169
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.42 ms Dopo l'ultima query: 10.10 ms Memoria query: 0.007 MB memoria prima della query: 10.238 MB Righe restituite: 1

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

  FROM `bhw7m_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using index condition

Profilo

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.15 ms Memoria query: 0.005 MB memoria prima della query: 10.229 MB

UPDATE `bhw7m_extensions`

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.05 ms
updating	0.05 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.05 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 2.82 ms Memoria query: 0.003 MB memoria prima della query: 10.496 MB Righe restituite: 2

SELECT *

  FROM bhw7m_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_languages	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using where; Using filesort

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.13 ms

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.00 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.003 MB memoria prima della query: 10.509 MB Righe restituite: 16

SELECT id, home, template, s.params

  FROM bhw7m_template_styles as s

  LEFT JOIN bhw7m_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	62	const	5	100.00	Using index condition; Using where
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	152	hk23tv9s_sthockey.e.element	1	100.00	Using index condition; Using where

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.49 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.03 ms Dopo l'ultima query: 7.76 ms Memoria query: 0.010 MB memoria prima della query: 11.104 MB Righe restituite: 39

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

  FROM `bhw7m_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','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_fabrik','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_speasyimagegallery','com_splms','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_assets	ALL	idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	187	21.39	Using where

Profilo

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.14 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.36 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.80 ms Dopo l'ultima query: 0.93 ms Memoria query: 0.007 MB memoria prima della query: 11.205 MB Righe restituite: 1

SELECT a.*,l.title AS language_title,ua.name AS author_name

  FROM bhw7m_sppagebuilder as a

  LEFT JOIN `bhw7m_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN bhw7m_users AS ua 
  ON ua.id = a.created_by

  WHERE a.id = 3 
  AND a.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL
1	SIMPLE	l	const	idx_langcode	idx_langcode	21	const	0	0.00	unique row not found
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.56 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.79 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:82
12	SppagebuilderModelPage->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 14.77 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.009 MB memoria prima della query: 11.237 MB Righe restituite: 24

SHOW FULL COLUMNS 
  FROM `bhw7m_sppagebuilder`

Explain

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

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	11.82 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 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
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
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
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	2.37 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:17
13	SppagebuilderTablePage->__construct()	JROOT/libraries/src/Table/Table.php:320
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:176
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.34 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.007 MB memoria prima della query: 11.298 MB Righe restituite: 1

SELECT *

  FROM bhw7m_sppagebuilder

  WHERE `id` = '3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_sppagebuilder	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_sppagebuilder/models/page.php:177
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.36 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.007 MB memoria prima della query: 11.323 MB

UPDATE bhw7m_sppagebuilder

  SET `hits` = (`hits` + 1)

  WHERE `id` = '3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_sppagebuilder	range	PRIMARY	PRIMARY	8	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.03 ms
updating	0.06 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.10 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1256
12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_sppagebuilder/models/page.php:178
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.35 ms Dopo l'ultima query: 2.36 ms Memoria query: 0.009 MB memoria prima della query: 11.490 MB Righe restituite: 1

Query duplicate: #20

SELECT `template`

  FROM `bhw7m_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	16	100.00	Using where

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:553
16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:152
15	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:597
14	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:14
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:40
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.29 ms Dopo l'ultima query: 21.45 ms Memoria query: 0.011 MB memoria prima della query: 14.267 MB Righe restituite: 1

SELECT `title`

  FROM `bhw7m_sppagebuilder`

  WHERE id = '3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_sppagebuilder	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	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
freeing items	0.05 ms
cleaning up	0.08 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_sppagebuilder/router.php:126
21	SppagebuilderRouter->getPageSegment()	JROOT/components/com_sppagebuilder/router.php:66
20	SppagebuilderRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:66
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:40
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.34 ms Dopo l'ultima query: 0.83 ms Memoria query: 0.009 MB memoria prima della query: 14.326 MB Righe restituite: 1

Query duplicate: #18

SELECT `template`

  FROM `bhw7m_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	16	100.00	Using where

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
16	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:190
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:40
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.41 ms Dopo l'ultima query: 2.83 ms Memoria query: 0.010 MB memoria prima della query: 14.583 MB Righe restituite: 0

SELECT a.enabled

  FROM `bhw7m_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	267	100.00	Using where

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:491
17	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:61
16	require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:190
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:40
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.40 ms Dopo l'ultima query: 9.35 ms Memoria query: 0.010 MB memoria prima della query: 15.421 MB Righe restituite: 0

SELECT a.enabled

  FROM `bhw7m_extensions` AS `a`

  WHERE `a`.`name` = 'AcyMailing'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	267	100.00	Using where

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:458
17	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:162
16	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:190
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:40
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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: 18.48 ms Memoria query: 0.009 MB memoria prima della query: 16.108 MB Righe restituite: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM bhw7m_modules AS m

  WHERE m.published = 1 
  AND m.id = 131 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-09-27 13:02:44') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-09-27 13:02:44') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 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.02 ms
freeing items	0.05 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
17	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:40
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 19.14 ms Dopo l'ultima query: 3.30 ms Memoria query: 0.011 MB memoria prima della query: 16.391 MB Righe restituite: 1

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM bhw7m_content AS a

  LEFT JOIN bhw7m_categories AS c 
  ON c.id = a.catid

  LEFT JOIN bhw7m_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN bhw7m_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN bhw7m_categories as parent 
  ON parent.id = c.parent_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (9) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-09-27 13:02:44') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-09-27 13:02:44')

  ORDER BY a.publish_up DESC 
  LIMIT 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	2	100.00	Using where
1	SIMPLE	ua	ALL	PRIMARY	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uam	ALL	PRIMARY	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.38 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	15.57 ms
Creating sort index	0.07 ms
end	0.01 ms
removing tmp table	2.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.10 ms

Call Stack

#	Caller	File e numero di linea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
20	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:123
19	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
18	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:40
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.65 ms Dopo l'ultima query: 1.25 ms Memoria query: 0.016 MB memoria prima della query: 16.470 MB Righe restituite: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `bhw7m_categories` AS `s`

  INNER JOIN `bhw7m_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 9

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	22	36.36	Using where

Profilo

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File e numero di linea
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
31	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
30	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
29	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
28	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
27	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
26	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
25	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
20	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:135
19	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
18	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:424
15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:266
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:40
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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: 3.95 ms Memoria query: 0.010 MB memoria prima della query: 16.542 MB Righe restituite: 30

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

  FROM `bhw7m_assets`

  WHERE `name` LIKE 'com_sppagebuilder.%' OR `name` = 'com_sppagebuilder' OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_assets	ALL	idx_asset_name,idx_parent_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	187	100.00	Using where

Profilo

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:97
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:40
10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:26
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 8.34 ms Dopo l'ultima query: 0.46 ms Memoria query: 0.006 MB memoria prima della query: 16.467 MB Righe restituite: 8

SHOW FULL COLUMNS 
  FROM `bhw7m_template_styles`

Explain

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

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	5.56 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 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
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	2.40 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
12	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
11	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
10	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
9	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:320
8	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/helix3/helix3.php:37
7	plgSystemHelix3->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.31 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.005 MB memoria prima della query: 16.488 MB Righe restituite: 1

SELECT *

  FROM bhw7m_template_styles

  WHERE `id` = '12'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bhw7m_template_styles	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 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.02 ms
freeing items	0.05 ms
cleaning up	0.10 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:739
8	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/helix3/helix3.php:38
7	plgSystemHelix3->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.52 ms Dopo l'ultima query: 19.10 ms Memoria query: 0.009 MB memoria prima della query: 17.497 MB Righe restituite: 10

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM bhw7m_modules AS m

  LEFT JOIN bhw7m_modules_menu AS mm 
  ON mm.moduleid = m.id

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-09-27 13:02:44') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-09-27 13:02:44') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 173 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	24	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	hk23tv9s_sthockey.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	hk23tv9s_sthockey.m.module,const	1	100.00	Using index condition; Using where

Profilo

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.58 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.13 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
8	Helix3::generatelayout()	JROOT/templates/shaper_educon/index.php:189
7	require JROOT/templates/shaper_educon/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

25 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

2 × SELECT `template` 
  FROM `bhw7m_template_styles`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `bhw7m_extensions`

2 × SELECT a.enabled 
  FROM `bhw7m_extensions` AS `a`

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `bhw7m_assets`

1 × SELECT `data` 
  FROM `bhw7m_session`

1 × SELECT * 
  FROM bhw7m_template_styles

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `bhw7m_categories` AS `s` 
  INNER JOIN `bhw7m_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM bhw7m_content AS a 
  LEFT JOIN bhw7m_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN bhw7m_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN bhw7m_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN bhw7m_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params 
  FROM bhw7m_modules AS m

1 × SELECT `title` 
  FROM `bhw7m_sppagebuilder`

1 × SELECT a.*,l.title AS language_title,ua.name AS author_name 
  FROM bhw7m_sppagebuilder as a 
  LEFT JOIN `bhw7m_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN bhw7m_users AS ua 
  ON ua.id = a.created_by

1 × SELECT * 
  FROM bhw7m_sppagebuilder

1 × SELECT `session_id` 
  FROM `bhw7m_session`

1 × SELECT id, home, template, s.params 
  FROM bhw7m_template_styles as s 
  LEFT JOIN bhw7m_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM bhw7m_languages
```

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM bhw7m_menu AS m 
  LEFT JOIN bhw7m_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM bhw7m_extensions

1 × SELECT b.id 
  FROM bhw7m_usergroups AS a 
  LEFT JOIN bhw7m_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `bhw7m_viewlevels

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM bhw7m_modules AS m 
  LEFT JOIN bhw7m_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN bhw7m_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

ALTRE tabelle:

1 × INSERT INTO `bhw7m_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6334623132383137313064663165643763366638643762346631643935633264', 1, 1632747764, 0, '', 0

1 × UPDATE `bhw7m_extensions` 
  SET `params` = '{\"mediaversion\":\"e25f205db991825490c0417f0b37160a\"}'

1 × SHOW FULL COLUMNS 
  FROM `bhw7m_sppagebuilder

1 × UPDATE bhw7m_sppagebuilder 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `bhw7m_template_styles