Raccolta immagini

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685495160,
                "last": 1685495160,
                "now": 1685495160
            },
            "token": "9eNDpw0heaAA36T7wXTQBRSYgyUEiKOi"
        },
        "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": "N2xyaDVtZW80ZjZ2YW0wYmplNzZjaXAwdXMxNjg1NDk1MTYx.png",
        "btl_captcha": "QLW7Xc"
    }
}

Informazioni profilo

Tempo

Memoria

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

Tempo: 255.53 ms / 382.27 ms Memoria: 1.166 MB / 2.12 MB Application: afterInitialise

Tempo: 96.67 ms / 478.94 ms Memoria: 0.425 MB / 2.54 MB Application: Before Access::preloadComponents (all components)

Tempo: 1.49 ms / 480.43 ms Memoria: 0.061 MB / 2.60 MB Application: After Access::preloadComponents (all components)

Tempo: 0.04 ms / 480.47 ms Memoria: 0.000 MB / 2.60 MB Application: Before Access::getAssetRules (id:24 name:com_users)

Tempo: 2.99 ms / 483.46 ms Memoria: 0.011 MB / 2.61 MB Application: After Access::getAssetRules (id:24 name:com_users)

Tempo: 6.83 ms / 490.30 ms Memoria: 0.090 MB / 2.70 MB Application: afterRoute

Tempo: 18.29 ms / 508.59 ms Memoria: 0.226 MB / 2.93 MB Application: beforeRenderComponent com_igallery

Tempo: 322.00 ms / 830.58 ms Memoria: 0.702 MB / 3.63 MB Application: afterRenderComponent com_igallery

Tempo: 4.37 ms / 834.96 ms Memoria: 0.010 MB / 3.64 MB Application: afterDispatch

Tempo: 51.81 ms / 886.77 ms Memoria: 0.282 MB / 3.92 MB Application: beforeRenderModule mod_menu (Supporto)

Tempo: 34.02 ms / 920.78 ms Memoria: 0.028 MB / 3.95 MB Application: afterRenderModule mod_menu (Supporto)

Tempo: 89.05 ms / 1009.83 ms Memoria: 0.277 MB / 4.23 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Tempo: 0.08 ms / 1009.91 ms Memoria: 0.009 MB / 4.24 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Tempo: 0.10 ms / 1010.01 ms Memoria: 0.015 MB / 4.25 MB Application: beforeRenderModule mod_nice_social_bookmark (Social Bookmark )

Tempo: 2.41 ms / 1012.42 ms Memoria: 0.030 MB / 4.28 MB Application: afterRenderModule mod_nice_social_bookmark (Social Bookmark )

Tempo: 0.03 ms / 1012.45 ms Memoria: 0.000 MB / 4.26 MB Application: beforeRenderModule mod_creativecontactform (Contattaci)

Tempo: 13.05 ms / 1025.50 ms Memoria: 0.123 MB / 4.38 MB Application: afterRenderModule mod_creativecontactform (Contattaci)

Tempo: 7.82 ms / 1033.33 ms Memoria: 0.050 MB / 4.43 MB Application: beforeRenderModule mod_menu (Social)

Tempo: 13.55 ms / 1046.87 ms Memoria: 0.021 MB / 4.45 MB Application: afterRenderModule mod_menu (Social)

Tempo: 8.79 ms / 1055.66 ms Memoria: 0.000 MB / 4.45 MB Application: beforeRenderModule mod_menu (Documentazione)

Tempo: 12.47 ms / 1068.13 ms Memoria: 0.040 MB / 4.49 MB Application: afterRenderModule mod_menu (Documentazione)

Tempo: 9.56 ms / 1077.68 ms Memoria: 0.000 MB / 4.49 MB Application: beforeRenderModule mod_menu (Supporto)

Tempo: 7.89 ms / 1085.57 ms Memoria: 0.028 MB / 4.52 MB Application: afterRenderModule mod_menu (Supporto)

Tempo: 4.75 ms / 1090.31 ms Memoria: 0.000 MB / 4.48 MB Application: beforeRenderModule mod_jevents_latest (Prossimi eventi)

Tempo: 38.07 ms / 1128.38 ms Memoria: 0.051 MB / 4.53 MB Application: Before Access::getAssetRules (id:132 name:com_jevents)

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

Tempo: 471.46 ms / 1599.93 ms Memoria: 2.215 MB / 6.75 MB Application: afterRenderModule mod_jevents_latest (Prossimi eventi)

Tempo: 0.10 ms / 1600.03 ms Memoria: 0.000 MB / 6.71 MB Application: beforeRenderModule mod_bt_login (Utente)

Tempo: 27.69 ms / 1627.72 ms Memoria: 0.209 MB / 6.92 MB Application: afterRenderModule mod_bt_login (Utente)

Tempo: 6.04 ms / 1633.76 ms Memoria: 0.023 MB / 6.94 MB Application: beforeRenderModule mod_breadcrumbs (Percorso)

Tempo: 12.75 ms / 1646.51 ms Memoria: 0.010 MB / 6.95 MB Application: afterRenderModule mod_breadcrumbs (Percorso)

Tempo: 64.52 ms / 1711.03 ms Memoria: 0.766 MB / 7.72 MB Application: afterRender

Query totali del database: 218.35 ms

Utilizzo memoria

Query Database

114 query eseguite 218.35 ms

Trovati 45 duplicati!

2 duplicati: #2 #25

2 duplicati: #26 #29

2 duplicati: #27 #30

2 duplicati: #28 #31

2 duplicati: #37 #105

3 duplicati: #40 #61 #85

2 duplicati: #45 #47

2 duplicati: #49 #57

10 duplicati: #55 #58 #69 #76 #79 #82 #93 #96 #99 #102

2 duplicati: #56 #59

2 duplicati: #64 #78

2 duplicati: #70 #80

2 duplicati: #71 #81

2 duplicati: #77 #83

2 duplicati: #88 #98

2 duplicati: #94 #100

2 duplicati: #95 #101

2 duplicati: #97 #103

Tempo della query: 0.41 ms Memoria query: 0.025 MB memoria prima della query: 1.224 MB Righe restituite: 0

SELECT `data`

  FROM `un5gf_session`

  WHERE `session_id` = '7lrh5meo4f6vam0bje76cip0us'

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.43 ms Dopo l'ultima query: 4.59 ms Memoria query: 0.022 MB memoria prima della query: 1.302 MB Righe restituite: 0

Query duplicate: #25

SELECT `session_id`

  FROM `un5gf_session`

  WHERE `session_id` = '7lrh5meo4f6vam0bje76cip0us' 
  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.77 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.004 MB memoria prima della query: 1.307 MB

INSERT INTO `un5gf_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('7lrh5meo4f6vam0bje76cip0us', 1, 1685495160, 0, '', 0)

Explain

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

Profilo

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

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.42 ms Dopo l'ultima query: 31.20 ms Memoria query: 0.023 MB memoria prima della query: 1.419 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

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

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.43 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 1.433 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

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

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: 2.17 ms Dopo l'ultima query: 6.28 ms Memoria query: 0.036 MB memoria prima della query: 1.519 MB Righe restituite: 121

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

  FROM un5gf_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	Extra
1	SIMPLE	un5gf_extensions	ref	extension	extension	82	const	160	Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
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:359
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.87 ms Dopo l'ultima query: 219.30 ms Memoria query: 0.006 MB memoria prima della query: 2.519 MB

UPDATE `un5gf_extensions`

  SET `params` = '{\"mediaversion\":\"5bce0312ff9cec693aff99af61b87f99\"}'

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

Explain

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

Profilo

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

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.25 ms Dopo l'ultima query: 4.99 ms Memoria query: 0.029 MB memoria prima della query: 2.549 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

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

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: 2.16 ms Dopo l'ultima query: 71.34 ms Memoria query: 0.030 MB memoria prima della query: 3.125 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-31 01:06:00') 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-05-31 01:06:00')

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

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/models/category.php:45
11	igalleryModelcategory->getCategory()	JROOT/components/com_igallery/views/category/view.html.php:46
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 2.48 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.077 MB memoria prima della query: 3.133 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

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/models/category.php:59
11	igalleryModelcategory->getProfile()	JROOT/components/com_igallery/views/category/view.html.php:54
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.75 ms Dopo l'ultima query: 11.89 ms Memoria query: 0.023 MB memoria prima della query: 3.184 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

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
11	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/views/category/view.html.php:77
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 65.92 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.047 MB memoria prima della query: 3.209 MB Righe restituite: 27

SELECT c.*,p.menu_max_width, p.menu_max_height, p.img_quality, p.menu_access,u.name AS displayname, u.username,COUNT(i.id) AS numimages

  FROM un5gf_igallery AS c

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

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

  LEFT JOIN un5gf_igallery_img AS i 
  ON (i.gallery_id = c.id 
  AND i.published = 1 
  AND i.moderate = 1)

  WHERE c.published = 1 
  AND c.moderate = 1 
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-05-31 01:06:00') 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-05-31 01:06:00') 
  AND p.menu_access IN (1,1,5) 
  AND c.parent = 2

  GROUP BY c.id

  ORDER BY ordering

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	published,publish_up,publish_down,moderate,profile	published	1	const	27	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.c.user	1
1	SIMPLE	i	ref	gallery_id,published,moderate	gallery_id	4	Sql936528_1.c.id	62

Profilo

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_igallery/models/category.php:221
11	igalleryModelcategory->getCategoryChildren()	JROOT/components/com_igallery/views/category/view.html.php:115
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 68.78 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.047 MB memoria prima della query: 3.207 MB Righe restituite: 20

SELECT c.*,p.menu_max_width, p.menu_max_height, p.img_quality, p.menu_access,u.name AS displayname, u.username,COUNT(i.id) AS numimages

  FROM un5gf_igallery AS c

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

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

  LEFT JOIN un5gf_igallery_img AS i 
  ON (i.gallery_id = c.id 
  AND i.published = 1 
  AND i.moderate = 1)

  WHERE c.published = 1 
  AND c.moderate = 1 
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-05-31 01:06:00') 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-05-31 01:06:00') 
  AND p.menu_access IN (1,1,5) 
  AND c.parent = 2

  GROUP BY c.id

  ORDER BY ordering 
  LIMIT 20

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	published,publish_up,publish_down,moderate,profile	published	1	const	27	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.c.user	1
1	SIMPLE	i	ref	gallery_id,published,moderate	gallery_id	4	Sql936528_1.c.id	62

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:225
11	igalleryModelcategory->getCategoryChildren()	JROOT/components/com_igallery/views/category/view.html.php:115
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.91 ms Dopo l'ultima query: 0.40 ms Memoria query: 0.026 MB memoria prima della query: 3.284 MB Righe restituite: 11

SELECT c.id,i.filename AS selected_menu_filename, i.rotation as selected_menu_rotation

  FROM un5gf_igallery AS c

  INNER JOIN `un5gf_igallery_img` AS i 
  ON (i.gallery_id = c.id 
  AND i.published = 1 
  AND i.moderate = 1 
  AND i.menu_image = 1)

  WHERE FIND_IN_SET(c.id,"31,30,29,27,26,25,24,23,22,21,20,19,18,17,16,6,7,5,4,8")

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	gallery_id,published,menu_image,moderate	menu_image	4	const	13	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.i.gallery_id	1	Using index

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:311
12	igalleryModelcategory->addSelectedMenuImages()	JROOT/components/com_igallery/models/category.php:236
11	igalleryModelcategory->getCategoryChildren()	JROOT/components/com_igallery/views/category/view.html.php:115
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.54 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.026 MB memoria prima della query: 3.292 MB Righe restituite: 20

SELECT c.id,i.filename AS first_menu_filename, i.rotation as first_menu_rotation

  FROM un5gf_igallery AS c

  INNER JOIN `un5gf_igallery_img` AS i 
  ON (i.gallery_id = c.id 
  AND i.published = 1 
  AND i.moderate = 1 
  AND i.ordering = 1)

  WHERE FIND_IN_SET(c.id,"31,30,29,27,26,25,24,23,22,21,20,19,18,17,16,6,7,5,4,8")

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	gallery_id,ordering,published,moderate	ordering	4	const	26	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.i.gallery_id	1	Using index

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:346
12	igalleryModelcategory->addFirstMenuImages()	JROOT/components/com_igallery/models/category.php:237
11	igalleryModelcategory->getCategoryChildren()	JROOT/components/com_igallery/views/category/view.html.php:115
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.09 ms Dopo l'ultima query: 61.18 ms Memoria query: 0.032 MB memoria prima della query: 3.303 MB Righe restituite: 21

SHOW FULL COLUMNS 
  FROM `un5gf_igallery`

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.21 ms
System lock	0.01 ms
init	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 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
checking permissions	0.00 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.00 ms
checking permissions	0.01 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.30 ms
closing tables	0.00 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_igallery/tables/igallery.php:10
15	Tableigallery->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_igallery/models/category.php:644
13	igalleryModelcategory->getTable()	JROOT/components/com_igallery/models/category.php:368
12	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:508
11	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:130
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.90 ms Dopo l'ultima query: 11.28 ms Memoria query: 0.031 MB memoria prima della query: 3.417 MB Righe restituite: 1

SELECT *

  FROM un5gf_igallery

  WHERE `id` = '2'

Explain

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

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.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.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:1459
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_igallery/models/category.php:369
12	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:508
11	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:130
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.35 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.006 MB memoria prima della query: 3.423 MB

UPDATE un5gf_igallery

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

  WHERE `id` = '2'

Explain

EXPLAIN non possibile sulla query: UPDATE un5gf_igallery SET `hits` = (`hits` + 1) WHERE `id` = '2'

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.02 ms
Updating	0.08 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.47 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/Table/Table.php:1245
13	Joomla\CMS\Table\Table->hit()	JROOT/components/com_igallery/models/category.php:370
12	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:508
11	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:130
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.38 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.034 MB memoria prima della query: 3.444 MB Righe restituite: 0

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 i.gallery_id = 2 
  AND i.gallery_id = 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-31 01:06:00') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-31 01:06:00') 
  AND i.access IN (1,1,5)

  GROUP BY i.id

  ORDER BY i.ordering

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	const	PRIMARY,profile	PRIMARY	4	const	1
1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	const	1	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.08 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.03 ms
System lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.04 ms
Creating tmp table	0.24 ms
executing	0.00 ms
Copying to tmp table	0.03 ms
Sorting result	0.01 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.29 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/src/MVC/Model/BaseDatabaseModel.php:353
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_igallery/models/category.php:446
12	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:537
11	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:130
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.03 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.035 MB memoria prima della query: 3.441 MB Righe restituite: 0

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 i.gallery_id = 2 
  AND i.gallery_id = 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-31 01:06:00') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-31 01:06:00') 
  AND i.access IN (1,1,5)

  GROUP BY i.id

  ORDER BY i.ordering 
  LIMIT 1000

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	const	PRIMARY,profile	PRIMARY	4	const	1
1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	const	1	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.08 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.02 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.18 ms
executing	0.00 ms
Copying to tmp table	0.02 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 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:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:456
12	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:537
11	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:130
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.36 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.026 MB memoria prima della query: 3.442 MB Righe restituite: 0

SELECT co.*,u.name AS comments_displayname, u.username AS comments_username

  FROM un5gf_igallery_comments AS co

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

  WHERE FIND_IN_SET(co.image_id,"") 
  AND co.published =  1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Status	Duration
starting	0.03 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.01 ms
preparing	0.00 ms
executing	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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:488
11	igalleryModelcategory->addComments()	JROOT/components/com_igallery/views/category/view.html.php:140
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.82 ms Dopo l'ultima query: 25.57 ms Memoria query: 0.043 MB memoria prima della query: 3.471 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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.02 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.04 ms
Sending data	0.27 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 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:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_igallery/helpers/static.php:15
12	igStaticHelper::getCategories()	JROOT/components/com_igallery/helpers/utility.php:66
11	igUtilityHelper::writeBreadcrumbs()	JROOT/components/com_igallery/views/category/view.html.php:387
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:45
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:82
6	require_once JROOT/components/com_igallery/igallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.07 ms Dopo l'ultima query: 58.42 ms Memoria query: 0.033 MB memoria prima della query: 3.771 MB Righe restituite: 14

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

  FROM un5gf_modules AS m

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

  LEFT JOIN un5gf_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 <= '2023-05-31 01:06:00') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-31 01:06:00') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 343 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	17	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql936528_1.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	Sql936528_1.m.module,const	1	Using where

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.16 ms
Sending data	0.24 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:335
12	sboostHelper->hasModule()	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:354
11	sboostHelper->getModules()	JROOT/templates/mx_joomla180/lib/framework/features/cpanel.php:13
10	require_once JROOT/templates/mx_joomla180/lib/framework/features/cpanel.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:65
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.51 ms Dopo l'ultima query: 13.82 ms Memoria query: 0.028 MB memoria prima della query: 3.897 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-31 01:06:00') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-31 01:06:00') 
  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.03 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.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 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.48 ms Dopo l'ultima query: 99.59 ms Memoria query: 0.024 MB memoria prima della query: 4.206 MB Righe restituite: 1

Query duplicate: #2

SELECT `session_id`

  FROM `un5gf_session`

  WHERE `session_id` = '7lrh5meo4f6vam0bje76cip0us' 
  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.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.02 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
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: 0.87 ms Dopo l'ultima query: 31.93 ms Memoria query: 0.024 MB memoria prima della query: 4.280 MB Righe restituite: 4

Query duplicate: #29

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.04 ms
checking permissions	0.00 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.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.27 ms
Sending data	0.17 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.04 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.040 MB memoria prima della query: 4.290 MB Righe restituite: 1

Query duplicate: #30

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.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.51 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
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.95 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.041 MB memoria prima della query: 4.311 MB Righe restituite: 4

Query duplicate: #31

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.04 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.08 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: 0.75 ms Memoria query: 0.025 MB memoria prima della query: 4.373 MB Righe restituite: 4

Query duplicate: #26

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.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 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
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.56 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.036 MB memoria prima della query: 4.384 MB Righe restituite: 1

Query duplicate: #27

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.03 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.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
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.65 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.041 MB memoria prima della query: 4.401 MB Righe restituite: 4

Query duplicate: #28

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.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.06 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.76 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.025 MB memoria prima della query: 4.441 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.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.37 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.22 ms Dopo l'ultima query: 208.13 ms Memoria query: 0.035 MB memoria prima della query: 4.653 MB Righe restituite: 18

SHOW FULL COLUMNS 
  FROM `un5gf_jev_users`

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.21 ms
System lock	0.01 ms
init	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 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
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.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.39 ms
closing tables	0.00 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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
19	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1544
18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1399
17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:61
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1205
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.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.95 ms Dopo l'ultima query: 8.86 ms Memoria query: 0.041 MB memoria prima della query: 4.711 MB Righe restituite: 5

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 `un5gf_categories` AS `c`

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	cat_idx,idx_access	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	28	Using where; Using filesort

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.05 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
21	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
20	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:401
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1019
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1205
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.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.48 ms Dopo l'ultima query: 1.45 ms Memoria query: 0.027 MB memoria prima della query: 4.747 MB Righe restituite: 4

SELECT c.id

  FROM un5gf_categories AS c

  WHERE c.access   IN (1,1,5)
 
  AND c.published = 1
  
  AND c.language in ('it-IT','*')
 
  AND c.extension = 'com_jevents'
 

  ORDER BY c.lft asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	5	Using where; Using filesort

Profilo

Status	Duration
starting	0.03 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.07 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.04 ms
Sending data	0.01 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:514
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1019
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1205
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.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: 6.08 ms Dopo l'ultima query: 16.81 ms Memoria query: 0.059 MB memoria prima della query: 4.803 MB Righe restituite: 3

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , 
 atdcnt.atdcount as attendeeCount, atd.capacity, atd.waitingcapacity, atdcnt.atdcount as registrationguestcount , 
 atd.regopen, atd.regclose, atd.allrepeats,  atd.allowregistration, GROUP_CONCAT(DISTINCT catmapcat.id 
  ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM un5gf_jevents_repetition as rpt
 
  INNER JOIN un5gf_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN un5gf_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN un5gf_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN un5gf_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid 
 
  LEFT JOIN un5gf_jev_attendance as atd 
  ON ev.ev_id=atd.ev_id 
  LEFT JOIN un5gf_jev_invitees as inv 
  ON inv.at_id=atd.id 
 
  LEFT JOIN un5gf_jev_attendeecount as atdcnt 
  ON atdcnt.at_id=atd.id 
  AND (atd.allrepeats=1 OR atdcnt.rp_id=rpt.rp_id)  
 
  LEFT JOIN 
 un5gf_jevents_catmap as catmap 
  ON catmap.evid = rpt.eventid 
 
  LEFT JOIN 
 un5gf_categories AS catmapcat 
  ON catmap.catid = catmapcat.id
 
  WHERE 1 
 
  AND rpt.endrepeat >= '2023-05-31 03:06:01' 
  AND rpt.startrepeat <= '2023-06-30 23:59:59'
 
  AND (rpt.startrepeat >= '2023-05-31 03:06:01' OR  det.multiday=1) 
  AND ev.state=1 
  AND (atd.hidenoninvitees IS NULL
					OR ev.created_by=0
					OR atd.hidenoninvitees=0 
					OR atd.invites=0 
					OR (atd.invites=1 
  AND atd.hidenoninvitees=1 
  AND inv.email_address='FALSE' 
  AND ((atd.allinvites=1 
  AND inv.rp_id=0) OR (atd.allinvites=0 
  AND inv.rp_id=rpt.rp_id)))) 
  AND  catmap.catid IN(-1,44,49,50,51)
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  AND rpt.startrepeat=(
				SELECT MIN(startrepeat) 
  FROM un5gf_jevents_repetition as rpt2
				
  WHERE rpt2.eventid=rpt.eventid
				
  AND  (
					(rpt2.startrepeat >= '2023-05-31 03:06:01' 
  AND rpt2.startrepeat <= '2023-06-30 23:59:59')
					OR (rpt2.startrepeat <= '2023-05-31 03:06:01' 
  AND rpt2.endrepeat  > '2023-05-31 03:06:01'  
  AND det.multiday=1)
					)
				
			) 
			
  GROUP BY ev.ev_id
			
			
  ORDER BY rpt.startrepeat 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	Using where; Using temporary; Using filesort
1	PRIMARY	rpt	range	PRIMARY,eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	8	NULL	7	Using where; Using join buffer
1	PRIMARY	catmap	ref	key_event_category,key_evid	key_event_category	4	Sql936528_1.rpt.eventid	6	Using where; Using index
1	PRIMARY	catmapcat	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.catmap.catid	1
1	PRIMARY	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	Sql936528_1.catmap.evid	1	Using where
1	PRIMARY	det	eq_ref	PRIMARY,multiday	PRIMARY	4	Sql936528_1.rpt.eventdetail_id	1	Using where
1	PRIMARY	rr	ref	eventid	eventid	4	Sql936528_1.ev.ev_id	12
1	PRIMARY	atd	ref	ev_id,ev_id_2,ev_id_3	ev_id_2	4	Sql936528_1.rpt.eventid	11	Using where
1	PRIMARY	inv	ref	at_id,at_id_2	at_id	4	Sql936528_1.atd.id	11	Using where
1	PRIMARY	atdcnt	ref	PRIMARY	PRIMARY	4	Sql936528_1.atd.id	5
2	DEPENDENT SUBQUERY	rpt2	ref	eventid,eventstart,eventend,startrepeat,startend,endrepeat	eventstart	4	Sql936528_1.rpt.eventid	64	Using where

Profilo

Status	Duration
starting	0.24 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
System lock	0.01 ms
init	0.20 ms
optimizing	0.06 ms
statistics	0.22 ms
preparing	0.19 ms
Creating tmp table	0.45 ms
executing	0.00 ms
Copying to tmp table	1.17 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.26 ms
executing	0.00 ms
Sending data	0.39 ms
executing	0.00 ms
Sending data	0.45 ms
Creating sort index	0.03 ms
Copying to group table	0.10 ms
Sorting result	0.02 ms
Sending data	0.15 ms
end	0.00 ms
removing tmp table	0.36 ms
end	0.00 ms
removing tmp table	0.16 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.09 ms
freeing items	0.03 ms
removing tmp table	0.00 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2933
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.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.46 ms Dopo l'ultima query: 2.81 ms Memoria query: 0.029 MB memoria prima della query: 4.947 MB Righe restituite: 0

Query duplicate: #105

SELECT *, summary as title, description as content 
  FROM un5gf_jevents_translation 
  WHERE evdet_id IN(608,632,609) 
  AND language='it-IT'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Status	Duration
starting	0.03 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.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 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/components/com_jevents/libraries/dbmodel.php:708
16	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2968
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.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.63 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.041 MB memoria prima della query: 4.956 MB Righe restituite: 3

SELECT * 
  FROM un5gf_jev_attendance 
  WHERE ev_id in (0,608,632,609)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	un5gf_jev_attendance	range	ev_id,ev_id_2,ev_id_3	ev_id_2	4	NULL	4	Using where

Profilo

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:494
20	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
16	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.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.40 ms Dopo l'ultima query: 7.44 ms Memoria query: 0.028 MB memoria prima della query: 5.075 MB Righe restituite: 1

Create an account