FRET - Inzet datums

Joomla! Foutopsporingsconsole

Sessie

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1563767972,
                "last": 1563767972,
                "now": 1563767972
            },
            "token": "kYHbW50cjn01AHCYtzNzoLolOBibU8jz"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "gantry-7189cf414d48a690776737a33d505f89-name": null,
        "gantry-7189cf414d48a690776737a33d505f89-logo-type": null,
        "gantry-7189cf414d48a690776737a33d505f89-logo-custom-image": null,
        "gantry-7189cf414d48a690776737a33d505f89-headerstyle": null,
        "gantry-7189cf414d48a690776737a33d505f89-headerthema": null,
        "gantry-7189cf414d48a690776737a33d505f89-footerthema": null,
        "gantry-7189cf414d48a690776737a33d505f89-featurecolor": null,
        "gantry-7189cf414d48a690776737a33d505f89-featurebordercolor": null,
        "gantry-7189cf414d48a690776737a33d505f89-linkcolor": null,
        "gantry-7189cf414d48a690776737a33d505f89-font-family": null,
        "gantry-7189cf414d48a690776737a33d505f89-font-size-is": null,
        "gantry-7189cf414d48a690776737a33d505f89-menu-type": null,
        "gantry-7189cf414d48a690776737a33d505f89-layout-mode": null
    }
}

Profielinformatie

Tijd

Geheugen

Tijd: 31.53 ms / 31.53 ms Geheugen: 1.796 MB / 2.18 MB Application: afterLoad

Tijd: 121.32 ms / 152.85 ms Geheugen: 6.511 MB / 8.69 MB Application: afterInitialise

Tijd: 32.85 ms / 185.70 ms Geheugen: 1.090 MB / 9.78 MB Application: Before Access::preloadComponents (all components)

Tijd: 1.39 ms / 187.09 ms Geheugen: 0.068 MB / 9.85 MB Application: After Access::preloadComponents (all components)

Tijd: 0.04 ms / 187.13 ms Geheugen: 0.000 MB / 9.85 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Tijd: 0.92 ms / 188.06 ms Geheugen: 0.026 MB / 9.87 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Tijd: 2.07 ms / 190.13 ms Geheugen: 0.106 MB / 9.98 MB Application: afterRoute

Tijd: 11.01 ms / 201.14 ms Geheugen: 0.289 MB / 10.27 MB Application: beforeRenderComponent com_dpcalendar

Tijd: 19.00 ms / 220.14 ms Geheugen: 0.897 MB / 11.17 MB Application: Before Access::preloadPermissions (com_dpcalendar)

Tijd: 0.81 ms / 220.95 ms Geheugen: 0.017 MB / 11.18 MB Application: After Access::preloadPermissions (com_dpcalendar)

Tijd: 0.03 ms / 220.99 ms Geheugen: 0.000 MB / 11.18 MB Application: Before Access::getAssetRules (id:120 name:com_dpcalendar.category.18)

Tijd: 0.06 ms / 221.05 ms Geheugen: 0.007 MB / 11.19 MB Application: After Access::getAssetRules (id:120 name:com_dpcalendar.category.18)

Tijd: 6.17 ms / 227.21 ms Geheugen: 0.108 MB / 11.30 MB Application: Before Access::getAssetRules (id:117 name:com_dpcalendar.category.15)

Tijd: 0.05 ms / 227.26 ms Geheugen: 0.002 MB / 11.30 MB Application: After Access::getAssetRules (id:117 name:com_dpcalendar.category.15)

Tijd: 1.59 ms / 228.85 ms Geheugen: 0.014 MB / 11.31 MB Application: Before Access::getAssetRules (id:118 name:com_dpcalendar.category.16)

Tijd: 0.04 ms / 228.89 ms Geheugen: 0.002 MB / 11.31 MB Application: After Access::getAssetRules (id:118 name:com_dpcalendar.category.16)

Tijd: 1.42 ms / 230.32 ms Geheugen: 0.013 MB / 11.33 MB Application: Before Access::getAssetRules (id:119 name:com_dpcalendar.category.17)

Tijd: 0.03 ms / 230.34 ms Geheugen: 0.003 MB / 11.33 MB Application: After Access::getAssetRules (id:119 name:com_dpcalendar.category.17)

Tijd: 40.80 ms / 271.14 ms Geheugen: 0.736 MB / 12.07 MB Application: Before Access::getAssetRules (id:112 name:com_dpcalendar)

Tijd: 0.03 ms / 271.17 ms Geheugen: 0.002 MB / 12.07 MB Application: After Access::getAssetRules (id:112 name:com_dpcalendar)

Tijd: 1.64 ms / 272.81 ms Geheugen: 0.014 MB / 12.08 MB Application: Before Access::getAssetRules (id:149 name:com_dpcalendar.category.19)

Tijd: 0.04 ms / 272.85 ms Geheugen: 0.002 MB / 12.08 MB Application: After Access::getAssetRules (id:149 name:com_dpcalendar.category.19)

Tijd: 37.52 ms / 310.36 ms Geheugen: 0.773 MB / 12.86 MB Application: afterRenderComponent com_dpcalendar

Tijd: 16.05 ms / 326.41 ms Geheugen: 1.264 MB / 14.12 MB Application: afterDispatch

Tijd: 73.07 ms / 399.48 ms Geheugen: 2.581 MB / 16.70 MB Application: beforeRenderModule mod_roknavmenu ()

Tijd: 32.12 ms / 431.60 ms Geheugen: 0.911 MB / 17.61 MB Application: afterRenderModule mod_roknavmenu ()

Tijd: 7.55 ms / 439.15 ms Geheugen: 0.028 MB / 17.64 MB Application: beforeRenderModule mod_scoutingcopyright (Scouting Copyright)

Tijd: 1.14 ms / 440.29 ms Geheugen: 0.011 MB / 17.65 MB Application: afterRenderModule mod_scoutingcopyright (Scouting Copyright)

Tijd: 0.07 ms / 440.36 ms Geheugen: 0.000 MB / 17.65 MB Application: beforeRenderModule mod_scoutlogin (Mijn Scouting:)

Tijd: 1.79 ms / 442.15 ms Geheugen: 0.018 MB / 17.67 MB Application: afterRenderModule mod_scoutlogin (Mijn Scouting:)

Tijd: 0.09 ms / 442.24 ms Geheugen: 0.000 MB / 17.67 MB Application: beforeRenderModule mod_breadcrumbs (Kruimelpad)

Tijd: 3.01 ms / 445.25 ms Geheugen: 0.061 MB / 17.73 MB Application: afterRenderModule mod_breadcrumbs (Kruimelpad)

Tijd: 0.07 ms / 445.32 ms Geheugen: 0.000 MB / 17.72 MB Application: beforeRenderModule mod_scoutingfotolijn (Scouting Fotolijn)

Tijd: 0.83 ms / 446.15 ms Geheugen: 0.008 MB / 17.73 MB Application: afterRenderModule mod_scoutingfotolijn (Scouting Fotolijn)

Tijd: 29.13 ms / 475.28 ms Geheugen: 0.474 MB / 18.20 MB Application: afterRender

Totaal aantal database zoekopdrachten: 40.14 ms

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

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Zelfde als de call in onderstaande regel.
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:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Caller	Bestand en regelnummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO `joslb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('937ab98bd842c03e85b601292ab05428', 1, 1563767972, 0, '', 0)

Profiel

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.02 ms
Update	0.10 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	3.46 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.96 ms Na de laatste zoekopdracht: 4.36 ms Zoekopdracht geheugen: 0.006 MB geheugen voor zoekopdracht: 4.252 MB Regels teruggegeven: 45

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

  FROM `joslb_extensions`

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joslb_extensions	ref	extension	extension	82	const	45	100.00	Using index condition; Using where

Profiel

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.03 ms
Statistics	0.16 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.31 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Zelfde als de call in onderstaande regel.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.42 ms Na de laatste zoekopdracht: 3.66 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 4.468 MB Regels teruggegeven: 7

SELECT id, rules

  FROM `joslb_viewlevels`

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joslb_viewlevels	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	7	100.00

Profiel

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.48 ms Na de laatste zoekopdracht: 0.10 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 4.481 MB Regels teruggegeven: 2

SELECT b.id

  FROM joslb_usergroups AS a

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

  WHERE a.id = 9

Verklaren

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

Profiel

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 1.32 ms Na de laatste zoekopdracht: 0.82 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 4.611 MB Regels teruggegeven: 113

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

  FROM joslb_extensions

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

  ORDER BY ordering

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joslb_extensions	ref	extension	extension	82	const	143	100.00	Using index condition; Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.11 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.76 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Zelfde als de call in onderstaande regel.
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 10.01 ms Na de laatste zoekopdracht: 71.80 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 8.878 MB Regels teruggegeven: 41

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

  FROM joslb_menu AS m

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

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

  ORDER BY m.lft

Verklaren

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

Profiel

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.58 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Zelfde als de call in onderstaande regel.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 1.12 ms Na de laatste zoekopdracht: 19.38 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 9.787 MB Regels teruggegeven: 45

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

  FROM `joslb_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_gantry','com_icebreaker','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_openid','com_osmap','com_phocadownload','com_phocafavicon','com_plugins','com_postinstall','com_privacy','com_redirect','com_regularlabsmanager','com_search','com_tags','com_templates','com_users','com_wrapper')

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joslb_assets	ALL	idx_asset_name	INDEX KEY ONTBREEKT	NULL	NULL	148	31.08	Using where

Profiel

Status	Duration
Starting	0.11 ms
Checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.10 ms
Optimizing	0.02 ms
Statistics	0.20 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.34 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
12	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:33
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Zelfde als de call in onderstaande regel.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:105
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:62
8	PlgSystemAdvancedModules->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.49 ms Na de laatste zoekopdracht: 3.79 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 10.014 MB Regels teruggegeven: 1

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

  FROM `joslb_extensions`

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

Verklaren

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

Profiel

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Zelfde als de call in onderstaande regel.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 3.77 ms Na de laatste zoekopdracht: 0.18 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 10.004 MB

UPDATE `joslb_extensions`

  SET `params` = '{\"mediaversion\":\"930ac489564d6c95e91df2dbe32122db\"}'

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joslb_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	NULL	1	100.00	Using where

Profiel

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.07 ms
Updating	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	3.36 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.48 ms Na de laatste zoekopdracht: 2.84 ms Zoekopdracht geheugen: 0.003 MB geheugen voor zoekopdracht: 10.207 MB Regels teruggegeven: 1

SELECT *

  FROM joslb_languages

  WHERE published=1

  ORDER BY ordering ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joslb_languages	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	1	100.00	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.57 ms Na de laatste zoekopdracht: 0.48 ms Zoekopdracht geheugen: 0.003 MB geheugen voor zoekopdracht: 10.233 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #24 #25

SELECT id, home, template, s.params

  FROM joslb_template_styles as s

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

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1	100.00
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	fret19_jo747.s.template,const	1	100.00	Using index condition; Using where

Profiel

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

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

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 1.00 ms Na de laatste zoekopdracht: 18.75 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 11.118 MB Regels teruggegeven: 2

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

  FROM `joslb_categories` AS `s`

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

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

  ORDER BY c.lft

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	20	40.00	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.13 ms
Checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.15 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
17	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
16	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41
15	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:67
14	DPCalendarModelCalendar->getItems()	JROOT/components/com_dpcalendar/models/calendar.php:110
13	DPCalendarModelCalendar->getAllItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_dpcalendar/views/calendar/view.html.php:17
11	DPCalendarViewCalendar->init()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/View/BaseView.php:80
10	DPCalendar\View\BaseView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_dpcalendar/controller.php:45
8	DPCalendarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_dpcalendar/dpcalendar.php:25
6	require_once JROOT/components/com_dpcalendar/dpcalendar.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.62 ms Na de laatste zoekopdracht: 0.95 ms Zoekopdracht geheugen: 0.010 MB geheugen voor zoekopdracht: 11.166 MB Regels teruggegeven: 8

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

  FROM `joslb_assets`

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joslb_assets	ALL	idx_asset_name,idx_parent_id	INDEX KEY ONTBREEKT	NULL	NULL	148	100.00	Using where

Profiel

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.20 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
20	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:53
15	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:67
14	DPCalendarModelCalendar->getItems()	JROOT/components/com_dpcalendar/models/calendar.php:110
13	DPCalendarModelCalendar->getAllItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_dpcalendar/views/calendar/view.html.php:17
11	DPCalendarViewCalendar->init()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/View/BaseView.php:80
10	DPCalendar\View\BaseView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_dpcalendar/controller.php:45
8	DPCalendarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_dpcalendar/dpcalendar.php:25
6	require_once JROOT/components/com_dpcalendar/dpcalendar.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 2.32 ms Na de laatste zoekopdracht: 2.31 ms Zoekopdracht geheugen: 0.011 MB geheugen voor zoekopdracht: 11.296 MB Regels teruggegeven: 0

Identieke zoekopdrachten: #21 #23

SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access

  FROM `joslb_dpcalendar_caldav_calendarinstances` c

  LEFT 
  OUTER JOIN joslb_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri

  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from joslb_dpcalendar_caldav_principals memberp
				
  inner join joslb_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id
				
  inner join joslb_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp
				
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

  WHERE (mainp.external_id = 0 or mp.member_external_id = 0)

  ORDER BY c.displayname ASC 
  LIMIT 20

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	1	100.00	Gebruikt bestandssortering
1	SIMPLE	mainp	eq_ref	uri	uri	202	fret19_jo747.c.principaluri	1	100.00	Using where
1	SIMPLE	m	index	principal_id	principal_id	8	NULL	1	100.00	Using where; Using index
1	SIMPLE	memberp	eq_ref	PRIMARY	PRIMARY	4	fret19_jo747.m.member_id	1	100.00	Using where
1	SIMPLE	linkp	eq_ref	PRIMARY	PRIMARY	4	fret19_jo747.m.principal_id	1	100.00	Using where

Profiel

Status	Duration
Starting	0.14 ms
Checking permissions	0.01 ms
Opening tables	1.23 ms
After opening tables	0.04 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.13 ms
Optimizing	0.06 ms
Statistics	0.06 ms
Preparing	0.11 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.16 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/profile.php:36
20	DPCalendarModelProfile->getItems()	JROOT/plugins/system/dpcalendar/dpcalendar.php:304
19	PlgSystemDpcalendar->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:436
18	DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_dpcalendar/models/calendar.php:93
14	DPCalendarModelCalendar->getItems()	JROOT/components/com_dpcalendar/models/calendar.php:110
13	DPCalendarModelCalendar->getAllItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_dpcalendar/views/calendar/view.html.php:17
11	DPCalendarViewCalendar->init()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/View/BaseView.php:80
10	DPCalendar\View\BaseView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_dpcalendar/controller.php:45
8	DPCalendarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_dpcalendar/dpcalendar.php:25
6	require_once JROOT/components/com_dpcalendar/dpcalendar.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 1.20 ms Na de laatste zoekopdracht: 0.27 ms Zoekopdracht geheugen: 0.008 MB geheugen voor zoekopdracht: 11.284 MB Regels teruggegeven: 2

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

  FROM `joslb_categories` AS `s`

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

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

  ORDER BY c.lft

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	20	40.00	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.19 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.12 ms
Optimizing	0.05 ms
Statistics	0.18 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.16 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41
12	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/views/calendar/view.html.php:33
11	DPCalendarViewCalendar->init()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/View/BaseView.php:80
10	DPCalendar\View\BaseView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_dpcalendar/controller.php:45
8	DPCalendarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_dpcalendar/dpcalendar.php:25
6	require_once JROOT/components/com_dpcalendar/dpcalendar.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 1.19 ms Na de laatste zoekopdracht: 0.48 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 11.300 MB Regels teruggegeven: 2

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

  FROM `joslb_categories` AS `s`

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

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

  ORDER BY c.lft

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	20	40.00	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.17 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.23 ms
Preparing	0.02 ms
Unlocking tables	0.05 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.15 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41
12	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/views/calendar/view.html.php:33
11	DPCalendarViewCalendar->init()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/View/BaseView.php:80
10	DPCalendar\View\BaseView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_dpcalendar/controller.php:45
8	DPCalendarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_dpcalendar/dpcalendar.php:25
6	require_once JROOT/components/com_dpcalendar/dpcalendar.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 1.06 ms Na de laatste zoekopdracht: 0.42 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 11.315 MB Regels teruggegeven: 2

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

  FROM `joslb_categories` AS `s`

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

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

  ORDER BY c.lft

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	20	40.00	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.20 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.17 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.15 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41
12	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/views/calendar/view.html.php:33
11	DPCalendarViewCalendar->init()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/View/BaseView.php:80
10	DPCalendar\View\BaseView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_dpcalendar/controller.php:45
8	DPCalendarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_dpcalendar/dpcalendar.php:25
6	require_once JROOT/components/com_dpcalendar/dpcalendar.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 1.42 ms Na de laatste zoekopdracht: 41.10 ms Zoekopdracht geheugen: 0.010 MB geheugen voor zoekopdracht: 12.068 MB Regels teruggegeven: 5

Identieke zoekopdrachten: #22

SELECT c.id AS id, a.name AS asset_name

  FROM (
SELECT id,asset_id

  FROM joslb_categories

  WHERE extension = 'com_dpcalendar' 
  AND published = 1) AS c

  INNER JOIN joslb_assets AS a 
  ON c.asset_id = a.id

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joslb_categories	ref	cat_idx	cat_idx	203	const,const	5	100.00	Using index condition
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	fret19_jo747.joslb_categories.asset_id	1	100.00

Profiel

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.10 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.38 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.20 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/User/User.php:428
17	Joomla\CMS\User\User->getAuthorisedCategories()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:836
16	DPCalendar\Helper\DPCalendarHelper::canCreateEvent()	JROOT/components/com_dpcalendar/views/calendar/tmpl/default_options.php:189
15	include JROOT/components/com_dpcalendar/views/calendar/tmpl/default_options.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_dpcalendar/views/calendar/tmpl/default.php:20
13	include JROOT/components/com_dpcalendar/views/calendar/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/View/BaseView.php:109
10	DPCalendar\View\BaseView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_dpcalendar/controller.php:45
8	DPCalendarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_dpcalendar/dpcalendar.php:25
6	require_once JROOT/components/com_dpcalendar/dpcalendar.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 1.01 ms Na de laatste zoekopdracht: 0.53 ms Zoekopdracht geheugen: 0.012 MB geheugen voor zoekopdracht: 12.082 MB Regels teruggegeven: 0

Identieke zoekopdrachten: #16 #23

SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access

  FROM `joslb_dpcalendar_caldav_calendarinstances` c

  LEFT 
  OUTER JOIN joslb_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri

  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from joslb_dpcalendar_caldav_principals memberp
				
  inner join joslb_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id
				
  inner join joslb_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp
				
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

  WHERE (mainp.external_id = 0 or mp.member_external_id = 0)

  ORDER BY c.displayname ASC 
  LIMIT 20

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	1	100.00	Gebruikt bestandssortering
1	SIMPLE	mainp	eq_ref	uri	uri	202	fret19_jo747.c.principaluri	1	100.00	Using where
1	SIMPLE	m	index	principal_id	principal_id	8	NULL	1	100.00	Using where; Using index
1	SIMPLE	memberp	eq_ref	PRIMARY	PRIMARY	4	fret19_jo747.m.member_id	1	100.00	Using where
1	SIMPLE	linkp	eq_ref	PRIMARY	PRIMARY	4	fret19_jo747.m.principal_id	1	100.00	Using where

Profiel

Status	Duration
Starting	0.16 ms
Checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.10 ms
Optimizing	0.05 ms
Statistics	0.06 ms
Preparing	0.08 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/profile.php:36
22	DPCalendarModelProfile->getItems()	JROOT/plugins/system/dpcalendar/dpcalendar.php:304
21	PlgSystemDpcalendar->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:436
20	DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch()	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/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:840
16	DPCalendar\Helper\DPCalendarHelper::canCreateEvent()	JROOT/components/com_dpcalendar/views/calendar/tmpl/default_options.php:189
15	include JROOT/components/com_dpcalendar/views/calendar/tmpl/default_options.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_dpcalendar/views/calendar/tmpl/default.php:20
13	include JROOT/components/com_dpcalendar/views/calendar/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/View/BaseView.php:109
10	DPCalendar\View\BaseView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_dpcalendar/controller.php:45
8	DPCalendarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_dpcalendar/dpcalendar.php:25
6	require_once JROOT/components/com_dpcalendar/dpcalendar.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.55 ms Na de laatste zoekopdracht: 34.69 ms Zoekopdracht geheugen: 0.010 MB geheugen voor zoekopdracht: 12.879 MB Regels teruggegeven: 5

Identieke zoekopdrachten: #20

SELECT c.id AS id, a.name AS asset_name

  FROM (
SELECT id,asset_id

  FROM joslb_categories

  WHERE extension = 'com_dpcalendar' 
  AND published = 1) AS c

  INNER JOIN joslb_assets AS a 
  ON c.asset_id = a.id

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joslb_categories	ref	cat_idx	cat_idx	203	const,const	5	100.00	Using index condition
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	fret19_jo747.joslb_categories.asset_id	1	100.00

Profiel

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/User/User.php:428
17	Joomla\CMS\User\User->getAuthorisedCategories()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:836
16	DPCalendar\Helper\DPCalendarHelper::canCreateEvent()	JROOT/components/com_dpcalendar/views/calendar/tmpl/default_quickadd.php:11
15	include JROOT/components/com_dpcalendar/views/calendar/tmpl/default_quickadd.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_dpcalendar/views/calendar/tmpl/default.php:38
13	include JROOT/components/com_dpcalendar/views/calendar/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/View/BaseView.php:109
10	DPCalendar\View\BaseView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_dpcalendar/controller.php:45
8	DPCalendarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_dpcalendar/dpcalendar.php:25
6	require_once JROOT/components/com_dpcalendar/dpcalendar.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.63 ms Na de laatste zoekopdracht: 0.22 ms Zoekopdracht geheugen: 0.012 MB geheugen voor zoekopdracht: 12.890 MB Regels teruggegeven: 0

Identieke zoekopdrachten: #16 #21

SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access

  FROM `joslb_dpcalendar_caldav_calendarinstances` c

  LEFT 
  OUTER JOIN joslb_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri

  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from joslb_dpcalendar_caldav_principals memberp
				
  inner join joslb_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id
				
  inner join joslb_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp
				
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

  WHERE (mainp.external_id = 0 or mp.member_external_id = 0)

  ORDER BY c.displayname ASC 
  LIMIT 20

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	1	100.00	Gebruikt bestandssortering
1	SIMPLE	mainp	eq_ref	uri	uri	202	fret19_jo747.c.principaluri	1	100.00	Using where
1	SIMPLE	m	index	principal_id	principal_id	8	NULL	1	100.00	Using where; Using index
1	SIMPLE	memberp	eq_ref	PRIMARY	PRIMARY	4	fret19_jo747.m.member_id	1	100.00	Using where
1	SIMPLE	linkp	eq_ref	PRIMARY	PRIMARY	4	fret19_jo747.m.principal_id	1	100.00	Using where

Profiel

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Removing tmp table	0.04 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/profile.php:36
22	DPCalendarModelProfile->getItems()	JROOT/plugins/system/dpcalendar/dpcalendar.php:304
21	PlgSystemDpcalendar->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:436
20	DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch()	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/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:840
16	DPCalendar\Helper\DPCalendarHelper::canCreateEvent()	JROOT/components/com_dpcalendar/views/calendar/tmpl/default_quickadd.php:11
15	include JROOT/components/com_dpcalendar/views/calendar/tmpl/default_quickadd.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_dpcalendar/views/calendar/tmpl/default.php:38
13	include JROOT/components/com_dpcalendar/views/calendar/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/View/BaseView.php:109
10	DPCalendar\View\BaseView->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_dpcalendar/controller.php:45
8	DPCalendarController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_dpcalendar/dpcalendar.php:25
6	require_once JROOT/components/com_dpcalendar/dpcalendar.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.69 ms Na de laatste zoekopdracht: 35.41 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 15.758 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #13 #25

SELECT id, home, template, s.params

  FROM joslb_template_styles as s

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

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1	100.00
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	fret19_jo747.s.template,const	1	100.00	Using index condition; Using where

Profiel

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
16	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
15	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/scouting-tc3/lib/gantry/gantry.php:21
8	require_once JROOT/templates/scouting-tc3/lib/gantry/gantry.php	JROOT/templates/scouting-tc3/index.php:22
7	require JROOT/templates/scouting-tc3/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:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.49 ms Na de laatste zoekopdracht: 0.62 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 15.772 MB Regels teruggegeven: 1

Identieke zoekopdrachten: #13 #24

SELECT id, home, template, s.params

  FROM joslb_template_styles as s

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

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1	100.00
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	fret19_jo747.s.template,const	1	100.00	Using index condition; Using where

Profiel

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
16	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
15	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/scouting-tc3/lib/gantry/gantry.php:21
8	require_once JROOT/templates/scouting-tc3/lib/gantry/gantry.php	JROOT/templates/scouting-tc3/index.php:22
7	require JROOT/templates/scouting-tc3/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:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 1.15 ms Na de laatste zoekopdracht: 38.99 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 16.291 MB Regels teruggegeven: 13

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM joslb_modules AS m

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

  LEFT JOIN joslb_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	published,newsfeeds	published	1	const	20	100.00	Using index condition; Using where; Gebruikt bestandssortering
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	fret19_jo747.m.id	1	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	fret19_jo747.m.module,const	1	100.00	Using index condition; Using where

Profiel

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.50 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:413
16	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:127
15	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
14	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
13	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:357
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
8	Gantry->countModules()	JROOT/templates/scouting-tc3/index.php:87
7	require JROOT/templates/scouting-tc3/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:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.53 ms Na de laatste zoekopdracht: 22.11 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 17.253 MB Regels teruggegeven: 0

SELECT ts.template

  FROM joslb_template_styles AS ts

  INNER JOIN joslb_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 248 
  AND m.template_style_id != 0

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profiel

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Executing	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.03 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/scouting-tc3/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/scouting-tc3/index.php:110
7	require JROOT/templates/scouting-tc3/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:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.43 ms Na de laatste zoekopdracht: 0.10 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 17.261 MB Regels teruggegeven: 1

SELECT template

  FROM joslb_template_styles

  WHERE home = 1 
  AND client_id = 0

Verklaren

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

Profiel

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:116
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/scouting-tc3/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/scouting-tc3/index.php:110
7	require JROOT/templates/scouting-tc3/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:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.99 ms Na de laatste zoekopdracht: 36.71 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 17.805 MB Regels teruggegeven: 6

SHOW FULL COLUMNS 
  FROM `joslb_template_styles`

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: SHOW FULL COLUMNS FROM `joslb_template_styles`

Profiel

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.37 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.02 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.12 ms
Closing tables	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.05 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

Tijd zoekopdracht: 0.36 ms Na de laatste zoekopdracht: 1.19 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 17.842 MB Regels teruggegeven: 1

SELECT *

  FROM joslb_template_styles

  WHERE `id` = '9'

Verklaren

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

Profiel

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Voeg xdebug.file_link_format regel toe aan uw php.ini bestand voor de links naar bestanden]

20 zoekopdrachttypes gelogd, gesorteerd op weergave

SELECTEER Tabellen:

4 × 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 `joslb_categories` AS `s` 
  INNER JOIN `joslb_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

3 × SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access 
  FROM `joslb_dpcalendar_caldav_calendarinstances` c 
  LEFT 
  OUTER JOIN joslb_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri 
  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from joslb_dpcalendar_caldav_principals memberp     
  inner join joslb_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id     
  inner join joslb_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp     
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

3 × SELECT id, home, template, s.params 
  FROM joslb_template_styles as s 
  LEFT JOIN joslb_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

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

2 × SELECT c.id AS id, a.name AS asset_name 
  FROM ( SELECT id,asset_id 
  FROM joslb_categories

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

1 × SELECT `data` 
  FROM `joslb_session`

1 × SELECT template 
  FROM joslb_template_styles

1 × SELECT ts.template 
  FROM joslb_template_styles AS ts 
  INNER JOIN joslb_menu AS m 
  ON ts.id=m.template_style_id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM joslb_modules AS m 
  LEFT JOIN joslb_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN joslb_advancedmodules as am 
  ON am.moduleid = m.id

```
1 × SELECT * 
  FROM joslb_languages
```

1 × SELECT `session_id` 
  FROM `joslb_session`

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

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

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

1 × SELECT id, rules 
  FROM `joslb_viewlevels

1 × SELECT * 
  FROM joslb_template_styles

ANDERE Tabellen:

1 × INSERT INTO `joslb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('937ab98bd842c03e85b601292ab05428', 1, 1563767972, 0, '', 0

1 × UPDATE `joslb_extensions` 
  SET `params` = '{\"mediaversion\":\"930ac489564d6c95e91df2dbe32122db\"}'

1 × SHOW FULL COLUMNS 
  FROM `joslb_template_styles

Mijn Scouting:

Joomla! Foutopsporingsconsole

Sessie

Profielinformatie

Tijd

Geheugen

Geheugengebruik

Database zoekopdrachten

30 zoekopdrachten gelogd 40.14 ms

8 identieke gevonden!

20 zoekopdrachttypes gelogd, gesorteerd op weergave

SELECTEER Tabellen:

ANDERE Tabellen: