Calendario

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685488615,
                "last": 1685488615,
                "now": 1685488615
            },
            "token": "ckZbkNcP1sZuJwjnWlOPRPI2jDm81cZk"
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuY3JhZ2VuZXJhbGlydW5uZXJzLml0L2luZGV4LnBocC9ldmVudGk%2F"
            },
            "published_fv_ses": "0",
            "justmine_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,
        "com_mailto": {
            "links": {
                "3d2152c0c4cf7f17f152cce8b043f3adea0877e0": {
                    "link": "https:\/\/www.crageneralirunners.it\/index.php\/eventi\/calendariomensile\/2023\/5\/-",
                    "expiry": 1685488616
                }
            }
        },
        "btl_captcha_image_path": "NWVic2lxb3FodDNyMTcwaGV1YTVzazYxOWoxNjg1NDg4NjE4.png",
        "btl_captcha": "fK5KU6"
    }
}

Informazioni profilo

Tempo

Memoria

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

Tempo: 315.15 ms / 476.08 ms Memoria: 1.174 MB / 2.13 MB Application: afterInitialise

Tempo: 107.60 ms / 583.69 ms Memoria: 0.425 MB / 2.55 MB Application: Before Access::preloadComponents (all components)

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

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

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

Tempo: 5.82 ms / 593.84 ms Memoria: 0.090 MB / 2.71 MB Application: afterRoute

Tempo: 18.90 ms / 612.74 ms Memoria: 0.266 MB / 2.98 MB Application: beforeRenderComponent com_jevents

Tempo: 133.47 ms / 746.20 ms Memoria: 0.787 MB / 3.77 MB Application: Before Access::getAssetRules (id:132 name:com_jevents)

Tempo: 0.10 ms / 746.30 ms Memoria: 0.010 MB / 3.78 MB Application: After Access::getAssetRules (id:132 name:com_jevents)

Tempo: 516.25 ms / 1262.55 ms Memoria: 3.397 MB / 7.17 MB Application: afterRenderComponent com_jevents

Tempo: 1.88 ms / 1264.43 ms Memoria: 0.007 MB / 7.18 MB Application: afterDispatch

Tempo: 24.20 ms / 1288.63 ms Memoria: 0.240 MB / 7.42 MB Application: beforeRenderModule mod_menu (Supporto)

Tempo: 28.70 ms / 1317.33 ms Memoria: 0.036 MB / 7.46 MB Application: afterRenderModule mod_menu (Supporto)

Tempo: 22.03 ms / 1339.35 ms Memoria: 0.000 MB / 7.42 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Tempo: 0.06 ms / 1339.42 ms Memoria: 0.009 MB / 7.43 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Tempo: 0.09 ms / 1339.51 ms Memoria: 0.015 MB / 7.45 MB Application: beforeRenderModule mod_nice_social_bookmark (Social Bookmark )

Tempo: 1.90 ms / 1341.41 ms Memoria: 0.031 MB / 7.48 MB Application: afterRenderModule mod_nice_social_bookmark (Social Bookmark )

Tempo: 0.03 ms / 1341.44 ms Memoria: 0.000 MB / 7.45 MB Application: beforeRenderModule mod_creativecontactform (Contattaci)

Tempo: 26.16 ms / 1367.61 ms Memoria: 0.118 MB / 7.57 MB Application: afterRenderModule mod_creativecontactform (Contattaci)

Tempo: 0.07 ms / 1367.68 ms Memoria: 0.000 MB / 7.53 MB Application: beforeRenderModule mod_igallery (Immagini casuali)

Tempo: 1816.91 ms / 3184.59 ms Memoria: 2.122 MB / 9.66 MB Application: afterRenderModule mod_igallery (Immagini casuali)

Tempo: 60.88 ms / 3245.46 ms Memoria: 0.509 MB / 10.16 MB Application: beforeRenderModule mod_bt_login (Utente)

Tempo: 35.94 ms / 3281.40 ms Memoria: 0.069 MB / 10.23 MB Application: afterRenderModule mod_bt_login (Utente)

Tempo: 82.31 ms / 3363.71 ms Memoria: 1.932 MB / 12.17 MB Application: afterRender

Query totali del database: 198.53 ms

Utilizzo memoria

Query Database

125 query eseguite 198.53 ms

Trovati 56 duplicati!

2 duplicati: #2 #107

4 duplicati: #15 #66 #76 #90

2 duplicati: #20 #22

2 duplicati: #24 #53

14 duplicati: #30 #37 #44 #51 #54 #57 #60 #63 #70 #73 #84 #87 #94 #97

2 duplicati: #31 #55

2 duplicati: #32 #56

2 duplicati: #38 #58

2 duplicati: #39 #59

2 duplicati: #45 #61

2 duplicati: #46 #62

2 duplicati: #52 #64

2 duplicati: #69 #72

2 duplicati: #71 #74

2 duplicati: #79 #86

2 duplicati: #85 #88

2 duplicati: #93 #96

2 duplicati: #95 #98

2 duplicati: #108 #111

2 duplicati: #109 #112

2 duplicati: #110 #113

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

SELECT `data`

  FROM `un5gf_session`

  WHERE `session_id` = '5ebsiqoqht3r170heua5sk619j'

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

Query duplicate: #107

SELECT `session_id`

  FROM `un5gf_session`

  WHERE `session_id` = '5ebsiqoqht3r170heua5sk619j' 
  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.14 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 
('5ebsiqoqht3r170heua5sk619j', 1, 1685488615, 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `un5gf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('5ebsiqoqht3r170heua5sk619j', 1, 1685488615, 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.39 ms Dopo l'ultima query: 44.26 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.41 ms Dopo l'ultima query: 0.14 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: 0.56 ms Dopo l'ultima query: 261.46 ms Memoria query: 0.006 MB memoria prima della query: 2.527 MB

UPDATE `un5gf_extensions`

  SET `params` = '{\"mediaversion\":\"756209754f7a191b3be033e70f2e07b3\"}'

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

Explain

EXPLAIN non possibile sulla query: UPDATE `un5gf_extensions` SET `params` = '{\"mediaversion\":\"756209754f7a191b3be033e70f2e07b3\"}' 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.90 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: 1.06 ms Dopo l'ultima query: 286.14 ms Memoria query: 0.034 MB memoria prima della query: 3.936 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

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/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:2666
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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.77 ms Dopo l'ultima query: 17.27 ms Memoria query: 0.041 MB memoria prima della query: 3.993 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

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

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:2666
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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.67 ms Dopo l'ultima query: 1.54 ms Memoria query: 0.027 MB memoria prima della query: 4.029 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

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

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:2666
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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: 12.14 ms Dopo l'ultima query: 17.21 ms Memoria query: 0.120 MB memoria prima della query: 4.069 MB Righe restituite: 4

SELECT det.evdet_id as detailid, 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-01 00:00:00' 
  AND rpt.startrepeat <= '2023-05-31 23:59:59'
 
  AND NOT (rpt.startrepeat < '2023-05-01 00:00:00' 
  AND det.multiday=0)  
  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)
 
  GROUP BY rpt.rp_id

Explain

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

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_jevents/libraries/dbmodel.php:2933
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2869
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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.40 ms Dopo l'ultima query: 3.30 ms Memoria query: 0.028 MB memoria prima della query: 4.268 MB Righe restituite: 0

SELECT *, summary as title, description as content 
  FROM un5gf_jevents_translation 
  WHERE evdet_id IN(620,629,633,634) 
  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

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

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:708
15	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2968
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2869
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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.56 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.041 MB memoria prima della query: 4.279 MB Righe restituite: 4

SELECT * 
  FROM un5gf_jev_attendance 
  WHERE ev_id in (0,620,629,633,634)

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	5	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:494
19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2869
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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.41 ms Dopo l'ultima query: 11.01 ms Memoria query: 0.028 MB memoria prima della query: 4.407 MB Righe restituite: 1

SELECT atdcount 
  FROM un5gf_jev_attendeecount as a 
  WHERE a.at_id=620

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:324
21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2869
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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.25 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.028 MB memoria prima della query: 4.418 MB Righe restituite: 1

Query duplicate: #66 #76 #90

Select params 
  from un5gf_jev_rsvp_templates 
  where id=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	un5gf_jev_rsvp_templates	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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:344
21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2869
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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.68 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.028 MB memoria prima della query: 4.435 MB Righe restituite: 1

SELECT sum(atdees.atdcount) as waitingcount  
  FROM un5gf_jev_attendees AS atdees 
  WHERE atdees.at_id =620 
  and atdees.waiting=1 
  and atdees.rp_id=0 
  AND (atdees.attendstate=1 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	atdees	ref	at_id,at_id_2	at_id	4	const	4	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:358
21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2869
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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.64 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.034 MB memoria prima della query: 4.448 MB Righe restituite: 4

SELECT u.name as name, u.username, a.* 
  FROM un5gf_jev_attendees as a 
  LEFT JOIN un5gf_users as u 
  on u.id=a.user_id 
  WHERE a.at_id=620 
  and a.attendstate!=2 
  and a.attendstate!=3 
  and a.attendstate!=0 
  ORDER BY a.confirmed DESC, a.created asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	at_id,at_id_2	at_id	4	const	4	Using where; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.a.user_id	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:432
21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2869
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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.55 ms Dopo l'ultima query: 10.46 ms Memoria query: 0.033 MB memoria prima della query: 4.511 MB Righe restituite: 1

SELECT w.* 
  FROM un5gf_jev_rsvp_templates AS w 
  WHERE w.id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	w	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
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
26	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsvppro/models/template.php:417
25	TemplatesModelTemplate->_loadData()	JROOT/administrator/components/com_rsvppro/models/template.php:98
24	TemplatesModelTemplate->getData()	JROOT/administrator/components/com_rsvppro/models/template.php:582
23	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
22	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2869
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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.27 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.038 MB memoria prima della query: 4.530 MB Righe restituite: 16

SHOW FULL COLUMNS 
  FROM `un5gf_jev_rsvp_templates`

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
31	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
30	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsvppro/tables/template.php:94
29	TableTemplate->__construct()	JROOT/libraries/src/Table/Table.php:312
28	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:382
27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:468
26	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/administrator/components/com_rsvppro/models/template.php:421
25	TemplatesModelTemplate->_loadData()	JROOT/administrator/components/com_rsvppro/models/template.php:98
24	TemplatesModelTemplate->getData()	JROOT/administrator/components/com_rsvppro/models/template.php:582
23	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
22	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2869
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3001
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/flat/month/view.html.php:39
10	flatViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:75
8	MonthController->calendar()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
6	require_once JROOT/components/com_jevents/jevents.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.00 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.036 MB memoria prima della query: 4.571 MB Righe restituite: 1

1 Monday, 1 May 2023	2 Tuesday, 2 May 2023	3 Wednesday, 3 May 2023	4 Thursday, 4 May 2023	5 Friday, 5 May 2023	6 Saturday, 6 May 2023 18:00 Comacchio Half ...	7 Sunday, 7 May 2023
8 Monday, 8 May 2023	9 Tuesday, 9 May 2023	10 Wednesday, 10 May 2023	11 Thursday, 11 May 2023	12 Friday, 12 May 2023	13 Saturday, 13 May 2023	14 Sunday, 14 May 2023 09:30 12° Maratonina ...
15 Monday, 15 May 2023	16 Tuesday, 16 May 2023	17 Wednesday, 17 May 2023	18 Thursday, 18 May 2023	19 Friday, 19 May 2023	20 Saturday, 20 May 2023 19:45 Jesolo Moonligh ...	21 Sunday, 21 May 2023
22 Monday, 22 May 2023	23 Tuesday, 23 May 2023	24 Wednesday, 24 May 2023	25 Thursday, 25 May 2023	26 Friday, 26 May 2023 21:00 7° GRAN PREMIO ...	27 Saturday, 27 May 2023	28 Sunday, 28 May 2023
29 Monday, 29 May 2023	30 Tuesday, 30 May 2023	31 Wednesday, 31 May 2023	1	2	3	4

Create an account

Supporto

Documentazione

Social

CRA GENERALI A.S.D.

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

125 query eseguite 198.53 ms

Trovati 56 duplicati!

Login to your account

Create an account

Supporto

Documentazione

Social

CRA GENERALI A.S.D.

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

125 query eseguite 198.53 ms

Trovati 56 duplicati!