CRA Generali Runners

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685493202,
                "last": 1685493202,
                "now": 1685493202
            },
            "token": "xcKyYvd5MdZkntU2j7YjGC2CBy6XWhyt"
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "com_contact": {
                "contact": {
                    "data": {
                        "catid": "45"
                    }
                }
            },
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuY3JhZ2VuZXJhbGlydW5uZXJzLml0L2luZGV4LnBocC9jb21wb25lbnQvY29udGFjdC9jb250YWN0LzEwMT9JdGVtaWQ9MTAx"
            },
            "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": "bWU5MGJjc3QzZ25qdWhnOW1yNmg0ZjdhMWgxNjg1NDkzMjEw.png",
        "btl_captcha": "W91E2E"
    }
}

Informazioni profilo

Tempo

Memoria

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

Tempo: 302.18 ms / 585.06 ms Memoria: 1.175 MB / 2.13 MB Application: afterInitialise

Tempo: 187.85 ms / 772.91 ms Memoria: 0.423 MB / 2.55 MB Application: Before Access::preloadComponents (all components)

Tempo: 1.46 ms / 774.38 ms Memoria: 0.062 MB / 2.61 MB Application: After Access::preloadComponents (all components)

Tempo: 0.09 ms / 774.46 ms Memoria: 0.000 MB / 2.61 MB Application: Before Access::getAssetRules (id:24 name:com_users)

Tempo: 9.93 ms / 784.39 ms Memoria: 0.011 MB / 2.62 MB Application: After Access::getAssetRules (id:24 name:com_users)

Tempo: 2.90 ms / 787.29 ms Memoria: 0.090 MB / 2.71 MB Application: afterRoute

Tempo: 20.38 ms / 807.67 ms Memoria: 0.219 MB / 2.93 MB Application: beforeRenderComponent com_contact

Tempo: 202.32 ms / 1009.99 ms Memoria: 0.147 MB / 3.08 MB Application: Before Access::getAssetRules (id:7 name:com_contact)

Tempo: 0.08 ms / 1010.06 ms Memoria: 0.010 MB / 3.09 MB Application: After Access::getAssetRules (id:7 name:com_contact)

Tempo: 1378.21 ms / 2388.27 ms Memoria: 3.664 MB / 6.75 MB Application: afterRenderComponent com_contact

Tempo: 10.15 ms / 2398.42 ms Memoria: 0.005 MB / 6.76 MB Application: afterDispatch

Tempo: 81.31 ms / 2479.73 ms Memoria: 0.209 MB / 6.97 MB Application: beforeRenderModule mod_menu (Supporto)

Tempo: 45.79 ms / 2525.52 ms Memoria: 0.091 MB / 7.06 MB Application: afterRenderModule mod_menu (Supporto)

Tempo: 108.91 ms / 2634.43 ms Memoria: 0.409 MB / 7.47 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Tempo: 0.13 ms / 2634.56 ms Memoria: 0.009 MB / 7.48 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Tempo: 0.21 ms / 2634.77 ms Memoria: 0.015 MB / 7.49 MB Application: beforeRenderModule mod_nice_social_bookmark (Social Bookmark )

Tempo: 1.68 ms / 2636.45 ms Memoria: 0.031 MB / 7.52 MB Application: afterRenderModule mod_nice_social_bookmark (Social Bookmark )

Tempo: 0.06 ms / 2636.51 ms Memoria: 0.000 MB / 7.50 MB Application: beforeRenderModule mod_creativecontactform (Contattaci)

Tempo: 14.64 ms / 2651.14 ms Memoria: 0.118 MB / 7.61 MB Application: afterRenderModule mod_creativecontactform (Contattaci)

Tempo: 0.13 ms / 2651.28 ms Memoria: 0.000 MB / 7.58 MB Application: beforeRenderModule mod_igallery (Immagini casuali)

Tempo: 5067.77 ms / 7719.05 ms Memoria: 2.194 MB / 9.77 MB Application: afterRenderModule mod_igallery (Immagini casuali)

Tempo: 11.21 ms / 7730.26 ms Memoria: 0.461 MB / 10.23 MB Application: beforeRenderModule mod_menu (Social)

Tempo: 37.86 ms / 7768.12 ms Memoria: 0.021 MB / 10.25 MB Application: afterRenderModule mod_menu (Social)

Tempo: 23.66 ms / 7791.77 ms Memoria: 0.000 MB / 10.25 MB Application: beforeRenderModule mod_menu (Documentazione)

Tempo: 33.28 ms / 7825.05 ms Memoria: 0.040 MB / 10.29 MB Application: afterRenderModule mod_menu (Documentazione)

Tempo: 11.80 ms / 7836.85 ms Memoria: 0.000 MB / 10.29 MB Application: beforeRenderModule mod_menu (Supporto)

Tempo: 10.19 ms / 7847.04 ms Memoria: 0.028 MB / 10.32 MB Application: afterRenderModule mod_menu (Supporto)

Tempo: 12.55 ms / 7859.60 ms Memoria: 0.000 MB / 10.28 MB Application: beforeRenderModule mod_jevents_latest (Prossimi eventi)

Tempo: 287.99 ms / 8147.59 ms Memoria: 0.051 MB / 10.33 MB Application: Before Access::getAssetRules (id:132 name:com_jevents)

Tempo: 0.22 ms / 8147.81 ms Memoria: 0.010 MB / 10.34 MB Application: After Access::getAssetRules (id:132 name:com_jevents)

Tempo: 330.56 ms / 8478.36 ms Memoria: 2.056 MB / 12.40 MB Application: afterRenderModule mod_jevents_latest (Prossimi eventi)

Tempo: 0.16 ms / 8478.53 ms Memoria: 0.000 MB / 12.35 MB Application: beforeRenderModule mod_bt_login (Utente)

Tempo: 26.83 ms / 8505.35 ms Memoria: 0.146 MB / 12.50 MB Application: afterRenderModule mod_bt_login (Utente)

Tempo: 5.72 ms / 8511.07 ms Memoria: 0.023 MB / 12.52 MB Application: beforeRenderModule mod_breadcrumbs (Percorso)

Tempo: 44.05 ms / 8555.12 ms Memoria: 0.008 MB / 12.53 MB Application: afterRenderModule mod_breadcrumbs (Percorso)

Tempo: 55.18 ms / 8610.30 ms Memoria: 1.892 MB / 14.42 MB Application: afterRender

Query totali del database: 245.94 ms

Utilizzo memoria

Query Database

226 query eseguite 245.94 ms

Trovati 54 duplicati!

2 duplicati: #2 #134

3 duplicati: #9 #85 #125

2 duplicati: #12 #168

2 duplicati: #13 #169

2 duplicati: #129 #223

2 duplicati: #135 #138

2 duplicati: #136 #139

2 duplicati: #137 #140

2 duplicati: #154 #221

3 duplicati: #157 #177 #201

2 duplicati: #162 #164

2 duplicati: #166 #173

10 duplicati: #171 #174 #185 #192 #195 #198 #209 #212 #215 #218

2 duplicati: #172 #175

2 duplicati: #180 #194

2 duplicati: #186 #196

2 duplicati: #187 #197

2 duplicati: #193 #199

2 duplicati: #204 #214

2 duplicati: #210 #216

2 duplicati: #211 #217

2 duplicati: #213 #219

Tempo della query: 0.36 ms Memoria query: 0.025 MB memoria prima della query: 1.226 MB Righe restituite: 0

SELECT `data`

  FROM `un5gf_session`

  WHERE `session_id` = 'me90bcst3gnjuhg9mr6h4f7a1h'

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

Query duplicate: #134

SELECT `session_id`

  FROM `un5gf_session`

  WHERE `session_id` = 'me90bcst3gnjuhg9mr6h4f7a1h' 
  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.46 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.004 MB memoria prima della query: 1.309 MB

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

Explain

EXPLAIN non possibile sulla query: INSERT INTO `un5gf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('me90bcst3gnjuhg9mr6h4f7a1h', 1, 1685493202, 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.38 ms Dopo l'ultima query: 18.95 ms Memoria query: 0.023 MB memoria prima della query: 1.421 MB Righe restituite: 7

SELECT id, rules

  FROM `un5gf_viewlevels`

Explain

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

Profilo

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.53 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.022 MB memoria prima della query: 1.434 MB Righe restituite: 2

SELECT b.id

  FROM un5gf_usergroups AS a

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

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	8	Using where; Using index

Profilo

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: 0.50 ms Dopo l'ultima query: 324.69 ms Memoria query: 0.006 MB memoria prima della query: 2.527 MB

UPDATE `un5gf_extensions`

  SET `params` = '{\"mediaversion\":\"4e60f903df220a237856fdfa02c3e140\"}'

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

Explain

EXPLAIN non possibile sulla query: UPDATE `un5gf_extensions` SET `params` = '{\"mediaversion\":\"4e60f903df220a237856fdfa02c3e140\"}' 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.10 ms Dopo l'ultima query: 50.33 ms Memoria query: 0.030 MB memoria prima della query: 2.557 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: 0.73 ms Dopo l'ultima query: 236.07 ms Memoria query: 0.039 MB memoria prima della query: 3.094 MB Righe restituite: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM un5gf_contact_details AS a

  LEFT JOIN un5gf_categories AS c 
  on c.id = a.catid

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

  WHERE a.id = 101 
  AND (a.published = 1 OR a.published =2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-05-31 00:33:22') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-31 00:33:22')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/components/com_contact/models/contact.php:225
13	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
11	ContactViewContact->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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.62 ms Dopo l'ultima query: 3.74 ms Memoria query: 0.036 MB memoria prima della query: 3.133 MB Righe restituite: 0

Query duplicate: #85 #125

SELECT `m`.`tag_id`,`t`.*

  FROM `un5gf_contentitem_tag_map` AS m 

  INNER JOIN `un5gf_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 101 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	Sql936528_1.m.tag_id	1	Using where

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:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_contact/models/contact.php:255
13	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
11	ContactViewContact->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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.15 ms Dopo l'ultima query: 0.79 ms Memoria query: 0.028 MB memoria prima della query: 3.143 MB Righe restituite: 6

SELECT a.id,a.title,a.state,a.access,a.catid,a.created,a.language,a.publish_up, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug

  FROM un5gf_content as a

  LEFT JOIN un5gf_categories as c 
  on a.catid=c.id

  WHERE a.created_by = 143 
  AND a.access IN (1,1,5) 
  AND a.state IN (1,2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-05-31 00:33:22') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-31 00:33:22')

  ORDER BY a.publish_up DESC 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_createdby	idx_createdby	4	const	6	Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.a.catid	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:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_contact/models/contact.php:384
14	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
13	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
11	ContactViewContact->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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.95 ms Dopo l'ultima query: 77.67 ms Memoria query: 0.033 MB memoria prima della query: 3.182 MB Righe restituite: 16

SHOW FULL COLUMNS 
  FROM `un5gf_users`

Explain

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

Profilo

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

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/libraries/src/Table/User.php:41
19	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_users/models/user.php:65
17	UsersModelUser->getTable()	JROOT/libraries/src/MVC/Model/AdminModel.php:939
16	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_users/models/user.php:90
15	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:395
14	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
13	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
11	ContactViewContact->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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.47 ms Dopo l'ultima query: 4.06 ms Memoria query: 0.030 MB memoria prima della query: 3.222 MB Righe restituite: 1

Query duplicate: #168

SELECT *

  FROM `un5gf_users`

  WHERE `id` = 143

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	un5gf_users	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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/MVC/Model/AdminModel.php:944
16	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_users/models/user.php:90
15	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:395
14	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
13	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
11	ContactViewContact->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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.49 ms Dopo l'ultima query: 39.34 ms Memoria query: 0.027 MB memoria prima della query: 3.238 MB Righe restituite: 10

Create an account

Errore

Mognato Eros

Contatti-Gruppo atleti

Informazioni sul contatto

Modulo contatti

Link

Articoli

Profilo

Prossimi eventi

Supporto

Documentazione

Social

CRA GENERALI A.S.D.

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

226 query eseguite 245.94 ms

Trovati 54 duplicati!

Login to your account

Create an account

Errore

Mognato Eros

Contatti-Gruppo atleti

Informazioni sul contatto

Modulo contatti

Link

Articoli

Profilo

Prossimi eventi

Supporto

Documentazione

Social

CRA GENERALI A.S.D.

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

226 query eseguite 245.94 ms

Trovati 54 duplicati!