Home

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685488972,
                "last": 1685488972,
                "now": 1685488972
            },
            "token": "EiAc5tE0LNb54XtAH6oBR6wv8FVPlq1a"
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "jevents": {
                "moduleid115": {
                    "shownEventIds": [
                        [
                            "608",
                            "632",
                            "609"
                        ]
                    ],
                    "page": 0,
                    "firstEventDate": "2023-06-03 00:00:00",
                    "lastEventDate": "2023-06-22 00:00:00"
                }
            },
            "published_fv_ses": "0"
        },
        "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
        },
        "jsn_original_id": 0,
        "redirectAfterLogin": null,
        "btl_captcha_image_path": "bHQxa3Z1OWo2ZjkyMjhhYXE2ZjVuYmZiZTUxNjg1NDg4OTc2.png",
        "btl_captcha": "tpPsLh"
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 154.50 ms / 154.50 ms Memoria: 0.567 MB / 0.95 MB Application: afterLoad

Tempo: 354.36 ms / 508.85 ms Memoria: 1.175 MB / 2.13 MB Application: afterInitialise

Tempo: 336.60 ms / 845.45 ms Memoria: 0.560 MB / 2.69 MB Application: Before Access::preloadComponents (all components)

Tempo: 1.39 ms / 846.84 ms Memoria: 0.062 MB / 2.75 MB Application: After Access::preloadComponents (all components)

Tempo: 0.05 ms / 846.89 ms Memoria: 0.000 MB / 2.75 MB Application: Before Access::getAssetRules (id:24 name:com_users)

Tempo: 3.39 ms / 850.28 ms Memoria: 0.074 MB / 2.82 MB Application: After Access::getAssetRules (id:24 name:com_users)

Tempo: 5.87 ms / 856.15 ms Memoria: 0.028 MB / 2.85 MB Application: afterRoute

Tempo: 17.18 ms / 873.33 ms Memoria: 0.114 MB / 2.96 MB Application: beforeRenderComponent com_content

Tempo: 42.03 ms / 915.36 ms Memoria: 0.157 MB / 3.12 MB Application: afterRenderComponent com_content

Tempo: 16.54 ms / 931.90 ms Memoria: 0.017 MB / 3.14 MB Application: afterDispatch

Tempo: 40.32 ms / 972.22 ms Memoria: 0.277 MB / 3.42 MB Application: beforeRenderModule mod_menu (Supporto)

Tempo: 26.56 ms / 998.78 ms Memoria: 0.040 MB / 3.46 MB Application: afterRenderModule mod_menu (Supporto)

Tempo: 85.54 ms / 1084.32 ms Memoria: 0.262 MB / 3.72 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Tempo: 0.11 ms / 1084.43 ms Memoria: 0.009 MB / 3.73 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Tempo: 0.17 ms / 1084.60 ms Memoria: 0.077 MB / 3.80 MB Application: beforeRenderModule mod_nice_social_bookmark (Social Bookmark )

Tempo: 2.26 ms / 1086.86 ms Memoria: 0.029 MB / 3.83 MB Application: afterRenderModule mod_nice_social_bookmark (Social Bookmark )

Tempo: 0.06 ms / 1086.92 ms Memoria: 0.000 MB / 3.81 MB Application: beforeRenderModule mod_creativecontactform (Contattaci)

Tempo: 15.33 ms / 1102.25 ms Memoria: 0.126 MB / 3.93 MB Application: afterRenderModule mod_creativecontactform (Contattaci)

Tempo: 0.13 ms / 1102.38 ms Memoria: 0.000 MB / 3.90 MB Application: beforeRenderModule mod_igallery (Immagini casuali)

Tempo: 2338.35 ms / 3440.72 ms Memoria: 2.404 MB / 6.30 MB Application: afterRenderModule mod_igallery (Immagini casuali)

Tempo: 9.81 ms / 3450.54 ms Memoria: 0.452 MB / 6.75 MB Application: beforeRenderModule mod_jevents_latest (Prossimi eventi)

Tempo: 35.09 ms / 3485.63 ms Memoria: 0.051 MB / 6.81 MB Application: Before Access::getAssetRules (id:132 name:com_jevents)

Tempo: 0.08 ms / 3485.71 ms Memoria: 0.010 MB / 6.81 MB Application: After Access::getAssetRules (id:132 name:com_jevents)

Tempo: 336.81 ms / 3822.53 ms Memoria: 2.199 MB / 9.01 MB Application: afterRenderModule mod_jevents_latest (Prossimi eventi)

Tempo: 0.15 ms / 3822.68 ms Memoria: 0.000 MB / 8.97 MB Application: beforeRenderModule mod_bt_login (Utente)

Tempo: 24.65 ms / 3847.32 ms Memoria: 0.070 MB / 9.04 MB Application: afterRenderModule mod_bt_login (Utente)

Tempo: 77.33 ms / 3924.66 ms Memoria: 2.166 MB / 11.21 MB Application: afterRender

Query totali del database: 200.88 ms

Utilizzo memoria

Query Database

101 query eseguite 200.88 ms

Trovati 45 duplicati!

2 duplicati: #2 #9

2 duplicati: #10 #13

2 duplicati: #11 #14

2 duplicati: #12 #15

2 duplicati: #29 #97

3 duplicati: #32 #53 #77

2 duplicati: #37 #39

2 duplicati: #41 #49

10 duplicati: #47 #50 #61 #68 #71 #74 #85 #88 #91 #94

2 duplicati: #48 #51

2 duplicati: #56 #70

2 duplicati: #62 #72

2 duplicati: #63 #73

2 duplicati: #69 #75

2 duplicati: #80 #90

2 duplicati: #86 #92

2 duplicati: #87 #93

2 duplicati: #89 #95

Tempo della query: 0.43 ms Memoria query: 0.025 MB memoria prima della query: 1.225 MB Righe restituite: 0

SELECT `data`

  FROM `un5gf_session`

  WHERE `session_id` = 'lt1kvu9j6f9228aaq6f5nbfbe5'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	un5gf_session	const	PRIMARY	PRIMARY	194	const	1

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
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:765
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: 0.42 ms Dopo l'ultima query: 6.28 ms Memoria query: 0.022 MB memoria prima della query: 1.303 MB Righe restituite: 0

Query duplicate: #9

SELECT `session_id`

  FROM `un5gf_session`

  WHERE `session_id` = 'lt1kvu9j6f9228aaq6f5nbfbe5' 
  LIMIT 1

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
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: 0.42 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.004 MB memoria prima della query: 1.308 MB

INSERT INTO `un5gf_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('lt1kvu9j6f9228aaq6f5nbfbe5', 1, 1685488972, 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `un5gf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('lt1kvu9j6f9228aaq6f5nbfbe5', 1, 1685488972, 0, '', 0)

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.01 ms
update	0.05 ms
Waiting for query cache lock	0.00 ms
update	0.00 ms
end	0.00 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 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: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: 0.40 ms Dopo l'ultima query: 42.08 ms Memoria query: 0.023 MB memoria prima della query: 1.421 MB Righe restituite: 7

SELECT id, rules

  FROM `un5gf_viewlevels`

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
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: 0.40 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.022 MB memoria prima della query: 1.434 MB Righe restituite: 2

SELECT b.id

  FROM un5gf_usergroups AS a

  LEFT JOIN un5gf_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	8	Using where; Using index

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
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: 0.53 ms Dopo l'ultima query: 415.08 ms Memoria query: 0.006 MB memoria prima della query: 2.527 MB

UPDATE `un5gf_extensions`

  SET `params` = '{\"mediaversion\":\"479a03fc2b6cc9ebc0197c7fb80f6c82\"}'

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

Explain

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

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.06 ms
Updating	0.06 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.00 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1129
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.09 ms Dopo l'ultima query: 141.43 ms Memoria query: 0.030 MB memoria prima della query: 2.694 MB Righe restituite: 44

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

  FROM `un5gf_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_fields','com_finder','com_gantry','com_igallery','com_installer','com_jce','com_jcomments','com_jevents','com_joomlaupdate','com_jsn','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_rsvppro','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/jsn_system/jsn_system.php:140
8	plgSystemJsn_System->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1129
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.17 ms Dopo l'ultima query: 124.24 ms Memoria query: 0.028 MB memoria prima della query: 3.388 MB Righe restituite: 1

SELECT id, title, module, position, content, showtitle, params

  FROM un5gf_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 <= '2023-05-30 23:22:53') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-30 23:22:53') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

  ORDER BY position, ordering

Explain

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

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 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.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:627
16	SboostMenu->loadModule()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:253
15	SboostMenu->loadSubContent()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:236
14	SboostMenu->genMenuItem()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:558
13	SboostMenu->genMenuItems()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:479
12	SboostMenu->genMenu()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:510
11	SboostMenu->showMenu()	JROOT/templates/mx_joomla180/lib/framework/features/hormenu.php:13
10	require_once JROOT/templates/mx_joomla180/lib/framework/features/hormenu.php	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:54
9	sboostHelper->import()	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:146
8	sboostHelper->addFeatures()	JROOT/templates/mx_joomla180/index.php:86
7	require JROOT/templates/mx_joomla180/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: 0.43 ms Dopo l'ultima query: 83.65 ms Memoria query: 0.025 MB memoria prima della query: 3.691 MB Righe restituite: 1

Query duplicate: #2

SELECT `session_id`

  FROM `un5gf_session`

  WHERE `session_id` = 'lt1kvu9j6f9228aaq6f5nbfbe5' 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 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.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
13	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
12	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:767
11	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
10	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
9	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:220
8	sboostHelper->showSlideItem()	JROOT/templates/mx_joomla180/index.php:95
7	require JROOT/templates/mx_joomla180/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.01 ms Dopo l'ultima query: 37.66 ms Memoria query: 0.024 MB memoria prima della query: 3.830 MB Righe restituite: 4

Query duplicate: #13

SELECT
					sp.id,
					st.name as type
					
  FROM
					`un5gf_creative_fields` sp
					JOIN `un5gf_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '1'
					
  ORDER BY sp.ordering,sp.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	sp	ref	id_form	id_form	3	const	3	Using where; Using filesort
1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.sp.id_type	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
12	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:739
11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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.23 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.042 MB memoria prima della query: 3.840 MB Righe restituite: 1

Query duplicate: #14

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`un5gf_creative_forms` sp
					
  LEFT JOIN `un5gf_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	sp	system	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1
1	SIMPLE	st	const	PRIMARY	PRIMARY	3	const	1

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.56 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.02 ms
freeing items	0.04 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
13	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
12	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:739
11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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: 0.79 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.041 MB memoria prima della query: 3.863 MB Righe restituite: 4

Query duplicate: #15

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					st.name as type
				
  FROM
					`un5gf_creative_fields` sp
				JOIN `un5gf_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '1'
				
  ORDER BY sp.ordering,sp.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	sp	ref	id_form	id_form	3	const	3	Using where; Using filesort
1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.sp.id_type	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:344
12	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:739
11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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: 0.52 ms Dopo l'ultima query: 1.35 ms Memoria query: 0.025 MB memoria prima della query: 3.926 MB Righe restituite: 4

Query duplicate: #10

SELECT
					sp.id,
					st.name as type
					
  FROM
					`un5gf_creative_fields` sp
					JOIN `un5gf_creative_field_types` st 
  ON st.id = sp.id_type
					
  WHERE sp.published = '1'
					
  AND sp.id_form = '1'
					
  ORDER BY sp.ordering,sp.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	sp	ref	id_form	id_form	3	const	3	Using where; Using filesort
1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.sp.id_type	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
14	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
13	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:430
12	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:947
11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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: 0.65 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.036 MB memoria prima della query: 3.937 MB Righe restituite: 1

Query duplicate: #11

SELECT
					sp.`id_template`,
					sp.name,
					sp.top_text,
					sp.pre_text,
					sp.thank_you_text,
					sp.send_text,
					sp.send_new_text,
					sp.close_alert_text,
					sp.form_width,
					sp.redirect,
					sp.redirect_itemid,
					sp.redirect_url,
					sp.redirect_delay,
					sp.shake_count,
					sp.shake_distanse,
					sp.send_copy_enable,
					sp.send_copy_text,
					sp.shake_duration,
					sp.custom_css,
					st.styles,

					sp.render_type,
					sp.popup_button_text,
					sp.static_button_position,
					sp.static_button_offset,
					sp.appear_animation_type,
					sp.check_token,
					sp.next_button_text,
					sp.prev_button_text

					
  FROM
					`un5gf_creative_forms` sp
					
  LEFT JOIN `un5gf_contact_templates` st 
  ON st.id = sp.id_template
					
  WHERE sp.published = '1'
					
  AND sp.id = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	sp	system	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1
1	SIMPLE	st	const	PRIMARY	PRIMARY	3	const	1

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.02 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.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
13	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:430
12	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:947
11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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: 0.78 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.041 MB memoria prima della query: 3.954 MB Righe restituite: 4

Query duplicate: #12

SELECT
					sp.id,
					sp.name,
					sp.tooltip_text,
					sp.required,
					sp.ordering_field,
					sp.select_default_text,
					sp.show_parent_label,
					sp.select_no_match_text,
					sp.width,
					sp.field_margin_top,
					sp.select_show_scroll_after,
					sp.select_show_search_after,
					sp.upload_button_text,
					sp.upload_minfilesize,
					sp.upload_maxfilesize,
					sp.upload_acceptfiletypes,
					sp.upload_minfilesize_message,
					sp.upload_maxfilesize_message,
					sp.upload_acceptfiletypes_message,
					sp.captcha_wrong_message,

					sp.datepicker_date_format,
					sp.datepicker_animation,
					sp.datepicker_style,
					sp.datepicker_icon_style,
					sp.datepicker_show_icon,
					sp.datepicker_input_readonly,
					sp.datepicker_number_months,
					sp.datepicker_mindate,
					sp.datepicker_maxdate,
					sp.datepicker_changemonths,
					sp.datepicker_changeyears,
					sp.column_type,
					sp.custom_html,
					sp.google_maps,
					sp.heading,
					sp.recaptcha_site_key,
					sp.recaptcha_wrong_message,
					sp.recaptcha_theme,
					sp.recaptcha_type,
					sp.contact_data,
					sp.contact_data_width,
					sp.creative_popup,
					sp.creative_popup_embed,

					st.name as type
				
  FROM
					`un5gf_creative_fields` sp
				JOIN `un5gf_creative_field_types` st 
  ON st.id = sp.id_type
				
  WHERE sp.published = '1'
				
  AND sp.id_form = '1'
				
  ORDER BY sp.ordering,sp.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	sp	ref	id_form	id_form	3	const	3	Using where; Using filesort
1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.sp.id_type	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
14	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:344
13	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:430
12	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:947
11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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: 0.78 ms Dopo l'ultima query: 0.57 ms Memoria query: 0.025 MB memoria prima della query: 3.994 MB Righe restituite: 4

SELECT
 							spo.name,
 							spo.id,
 							spo.value,
 							spo.selected
							
  FROM
								`un5gf_creative_form_options` spo
							
  WHERE spo.id_parent = '4'
							
  AND spo.showrow = '1'
							
  ORDER BY spo.ordering

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:575
12	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:947
11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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.21 ms Dopo l'ultima query: 74.08 ms Memoria query: 0.033 MB memoria prima della query: 4.178 MB Righe restituite: 1

SELECT c.*,u.name AS displayname, u.username

  FROM un5gf_igallery AS c

  LEFT JOIN `un5gf_users` AS u 
  ON c.user = u.id

  WHERE c.id = 2 
  AND c.published = 1 
  AND c.moderate = 1 
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-05-30 23:22:53') 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-05-30 23:22:53')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,published,publish_up,publish_down,moderate	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1

Profilo

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
System lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.34 ms
preparing	0.03 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.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/models/category.php:45
15	igalleryModelcategory->getCategory()	JROOT/components/com_igallery/views/category/view.html.php:46
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:143
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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.56 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.079 MB memoria prima della query: 4.188 MB Righe restituite: 1

SELECT * 
  FROM un5gf_igallery_profiles 
  WHERE published = 1 
  AND id = 1

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.12 ms
optimizing	0.01 ms
statistics	0.40 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.54 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/models/category.php:59
15	igalleryModelcategory->getProfile()	JROOT/components/com_igallery/views/category/view.html.php:54
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:143
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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: 0.44 ms Dopo l'ultima query: 12.24 ms Memoria query: 0.025 MB memoria prima della query: 4.241 MB Righe restituite: 1

SELECT id 
  FROM un5gf_igallery 
  WHERE parent = 0 
  ORDER BY ordering 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	un5gf_igallery	index	NULL	ordering	4	NULL	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
15	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/views/category/view.html.php:77
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:143
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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: 0.73 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.045 MB memoria prima della query: 4.251 MB Righe restituite: 28

SELECT * 
  FROM un5gf_igallery 
  ORDER BY parent, ordering

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_igallery/helpers/static.php:15
17	igStaticHelper::getCategories()	JROOT/components/com_igallery/models/category.php:619
16	igalleryModelcategory->getChildIds()	JROOT/components/com_igallery/models/category.php:551
15	igalleryModelcategory->getRandomList()	JROOT/components/com_igallery/views/category/view.html.php:126
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:143
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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: 7.62 ms Dopo l'ultima query: 2.02 ms Memoria query: 0.221 MB memoria prima della query: 4.411 MB Righe restituite: 4048

SELECT id

  FROM un5gf_igallery_img as i

  WHERE FIND_IN_SET(i.gallery_id,"31,30,29,27,26,25,24,23,22,21,20,19,18,17,16,6,7,5,4,8,9,10,11,12,13,14,15,2") 
  AND i.published = 1 
  AND i.moderate = 1 
  AND i.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ALL	access,published,moderate	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4048	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_igallery/models/category.php:565
15	igalleryModelcategory->getRandomList()	JROOT/components/com_igallery/views/category/view.html.php:126
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:143
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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: 48.39 ms Dopo l'ultima query: 4.54 ms Memoria query: 0.122 MB memoria prima della query: 6.300 MB Righe restituite: 150

SELECT i.*,c.name,p.thumb_pagination_amount, p.thumb_pagination,u.name AS displayname, u.username,ROUND( SUM(r.rating)/COUNT(r.rating), 1) AS rating_average, COUNT(r.rating) as rating_count

  FROM un5gf_igallery_img AS i

  INNER JOIN `un5gf_igallery` AS c 
  ON c.id = i.gallery_id

  INNER JOIN `un5gf_igallery_profiles` AS p 
  ON p.id = c.profile

  LEFT JOIN `un5gf_users` AS u 
  ON i.user = u.id

  LEFT JOIN `un5gf_igallery_ratings` AS r 
  ON i.id = r.image_id 
  AND r.published = 1

  WHERE FIND_IN_SET(i.id,"36,49,45,99,105,138,165,189,200,238,243,246,273,295,306,313,353,356,374,375,398,457,481,499,540,546,582,593,638,645,702,715,719,746,762,773,785,832,858,934,938,979,984,991,1053,1099,1103,1127,1224,1263,1273,1323,1370,1378,1392,1395,1438,1488,1491,1532,1590,1626,1645,1646,1713,1749,1817,1836,1871,1901,1922,1970,1978,1985,1986,2004,2086,2088,2091,2097,2102,2129,2182,2185,2210,2241,2315,2331,2363,2365,2368,2376,2469,2498,2528,2542,2569,2587,2626,2668,2714,2724,2743,2765,2786,2828,3044,3052,3108,3119,3146,3165,3254,3258,3280,3310,3345,3349,3379,3457,3472,3490,3503,3549,3574,3625,3645,3650,3656,3677,3684,3740,3755,3766,3808,3819,3849,3906,3980,4003,3995,3992,4016,4020,4042,4104,4120,4123,4145,4165") 
  AND FIND_IN_SET(i.gallery_id,"31,30,29,27,26,25,24,23,22,21,20,19,18,17,16,6,7,5,4,8,9,10,11,12,13,14,15,2") 
  AND i.published = 1 
  AND i.moderate = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 23:22:53') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 23:22:53') 
  AND i.access IN (1,1,5)

  GROUP BY i.id

  ORDER BY RAND()

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	system	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using temporary; Using filesort
1	SIMPLE	c	ref	PRIMARY,profile	profile	4	const	27	Using where
1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	Sql936528_1.c.id	62	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.i.user	1
1	SIMPLE	r	ref	image_id,published	image_id	4	Sql936528_1.i.id	2

Profilo

Status	Duration
starting	0.13 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
Opening tables	0.04 ms
System lock	0.01 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.23 ms
preparing	0.03 ms
Creating tmp table	0.28 ms
executing	0.00 ms
Copying to tmp table	45.46 ms
Sorting result	0.10 ms
Sending data	0.87 ms
end	0.00 ms
removing tmp table	0.65 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.04 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_igallery/models/category.php:446
16	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:582
15	igalleryModelcategory->getRandomList()	JROOT/components/com_igallery/views/category/view.html.php:126
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:143
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
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: 45.97 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.123 MB memoria prima della query: 6.300 MB Righe restituite: 150
</

Create an account

Un tuffo nel passato

Le due Rocche

Dolomiti Beer Trail

Prossimi eventi

Supporto

Documentazione

Social

CRA GENERALI A.S.D.

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

101 query eseguite 200.88 ms

Trovati 45 duplicati!

Login to your account

Create an account

Un tuffo nel passato

Le due Rocche

Dolomiti Beer Trail

Prossimi eventi

Supporto

Documentazione

Social

CRA GENERALI A.S.D.

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

101 query eseguite 200.88 ms

Trovati 45 duplicati!