Hattemse Golf & Country Club

CORONA MAATREGELEN

Er is nog altijd een aantal maatregelen van toepassing.

Gasten en greenfee-spelers zijn welkom op de Hattemse. Leden, greenfee-spelers en gasten mogen weer rondes van 18 holes per dag spelen.

Indien men wil golfen dan dient tevoren een starttijd gereserveerd te worden. Reserveren kan dagelijks tussen 09:00 en 13:00 uur telefonisch via 038-444 1909. Leden van de Hattemse kunnen via Intogolf/Proware digitaal een starttijd boeken.

Om zoveel mogelijk golfers de gelegenheid te geven om een ronde te spelen wordt de voorkeur gegeven aan drieballen. Iedereen is verplicht zich bij de receptie te melden alvorens te gaan golfen.

HATTEMSE HOEVE weer open

Elke dag tussen 09:00 tot 22:00 uur zijn gasten welkom op het terras van de Hattemse Hoeve. Iedereen wordt aan tafel bediend. Het is niet de bedoeling zelf naar binnen te lopen voor een bestelling. De stoelen mogen niet verplaatst worden.

Ook binnen is weer plaats voor maximaal 30 personen, met bediening aan tafel. De keuken is open van woensdag t/m maandag van 11:30 tot 20:00 uur. Op dinsdag dus niet.

Iedereen dient de bekende anderhalve meter afstand in acht te nemen en binnen een mondkapje te dragen. In het clubhuis zijn looplijnen uitgezet naar de receptie, de toiletruimte en de uitgang. Iedereen wordt dringend verzocht deze in acht te nemen.

Ook het Take Away plein aan de zijkant van het clubhuis is van 09:00 tot 20:00 uur open. Hier is geen bediening. Leden en gasten kunnen door de zij-ingang van het clubhuis naar binnen gaan om een bestelling door te geven aan de bar. De consumpties worden mee naar buiten genomen en genuttigd op het Take Away plein, waar banken, tafels en stoelen staan.

Over de Hattemse Golf & Country Club

De Hattemse Golf & Country Club ligt in de bosrijke omgeving van het charmante Hanzestadje Hattem. De uitdagende 9-holes baan combineert bos- en parkholes en is voor een deel in heuvelachtig terrein gelegen. De holes volgen de natuurlijke glooiingen van zandruggen die in de ijstijd zijn ontstaan. De baan van de Hattemse Golf dateert van 1930 en is in Nederland één van de zestien golfbanen die voor de oorlog ontworpen zijn.

Lees meer: Over de Hattemse Golf & Country Club

DAAROM GOLFEN OP DE HATTEMSE...

Hans Lambrechts heeft meegedaan aan de inloopavond en de clinic die onlangs is gehouden en heeft daarvan samen met cameraman Henk Tabois een mooie filmreportage gemaakt over de Hattemse:

Joomla! Foutopsporingsconsole

Sessie

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1686173600,
                "last": 1686173600,
                "now": 1686173600
            },
            "token": "38MrVYQi0cbVvs909o64CmQE1wIUPxBG"
        },
        "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
        }
    }
}

Profielinformatie

Tijd

Geheugen

Tijd: 1468.42 ms / 1468.42 ms Geheugen: 2.029 MB / 2.44 MB Application: afterLoad

Tijd: 2709.43 ms / 4177.85 ms Geheugen: 5.204 MB / 7.64 MB Application: afterInitialise

Tijd: 732.83 ms / 4910.68 ms Geheugen: 1.174 MB / 8.81 MB Application: afterRoute

Tijd: 17.52 ms / 4928.20 ms Geheugen: 0.124 MB / 8.94 MB Application: beforeRenderComponent com_content

Tijd: 347.65 ms / 5275.84 ms Geheugen: 0.747 MB / 9.68 MB Application: Before Access::preloadComponents (all components)

Tijd: 1.84 ms / 5277.68 ms Geheugen: 0.066 MB / 9.75 MB Application: After Access::preloadComponents (all components)

Tijd: 0.03 ms / 5277.71 ms Geheugen: -0.005 MB / 9.74 MB Application: Before Access::preloadPermissions (com_content)

Tijd: 11.29 ms / 5289.00 ms Geheugen: 0.674 MB / 10.42 MB Application: After Access::preloadPermissions (com_content)

Tijd: 0.07 ms / 5289.07 ms Geheugen: -0.034 MB / 10.38 MB Application: Before Access::getAssetRules (id:53 name:com_content.category.15)

Tijd: 33.45 ms / 5322.52 ms Geheugen: 0.026 MB / 10.41 MB Application: After Access::getAssetRules (id:53 name:com_content.category.15)

Tijd: 124.82 ms / 5447.34 ms Geheugen: 0.287 MB / 10.70 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tijd: 0.06 ms / 5447.40 ms Geheugen: 0.006 MB / 10.70 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tijd: 713.35 ms / 6160.75 ms Geheugen: 1.719 MB / 12.42 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Tijd: 0.05 ms / 6160.80 ms Geheugen: 0.004 MB / 12.43 MB Application: After Access::getAssetRules (id:1 name:root.1)

Tijd: 931.68 ms / 7092.48 ms Geheugen: 0.995 MB / 13.42 MB Application: afterRenderComponent com_content

Tijd: 57.33 ms / 7149.82 ms Geheugen: 0.730 MB / 14.15 MB Application: afterDispatch

Tijd: 208.72 ms / 7358.54 ms Geheugen: 0.185 MB / 14.34 MB Application: beforeRenderModule mod_custom (Footer - frontpage only)

Tijd: 65.18 ms / 7423.72 ms Geheugen: 0.061 MB / 14.40 MB Application: beforeRenderModule mod_banners (Banners-frontpage)

Tijd: 332.13 ms / 7755.85 ms Geheugen: 0.175 MB / 14.57 MB Application: afterRenderModule mod_banners (Banners-frontpage)

Tijd: 15.40 ms / 7771.25 ms Geheugen: -0.044 MB / 14.53 MB Application: afterRenderModule mod_custom (Footer - frontpage only)

Tijd: 0.14 ms / 7771.39 ms Geheugen: 0.000 MB / 14.53 MB Application: beforeRenderModule mod_wrapper (Baanstatus)

Tijd: 66.57 ms / 7837.96 ms Geheugen: 0.017 MB / 14.55 MB Application: afterRenderModule mod_wrapper (Baanstatus)

Tijd: 0.12 ms / 7838.08 ms Geheugen: -0.003 MB / 14.54 MB Application: beforeRenderModule mod_menu (Gasten - Menu Linkerzijde)

Tijd: 123.71 ms / 7961.79 ms Geheugen: 0.178 MB / 14.72 MB Application: afterRenderModule mod_menu (Gasten - Menu Linkerzijde)

Tijd: 0.14 ms / 7961.92 ms Geheugen: -0.002 MB / 14.72 MB Application: beforeRenderModule mod_ariimageslider (Header slideshow)

Tijd: 430.53 ms / 8392.46 ms Geheugen: 0.438 MB / 15.16 MB Application: afterRenderModule mod_ariimageslider (Header slideshow)

Tijd: 0.13 ms / 8392.59 ms Geheugen: -0.023 MB / 15.13 MB Application: beforeRenderModule mod_search (Zoek)

Tijd: 47.65 ms / 8440.24 ms Geheugen: 0.015 MB / 15.15 MB Application: afterRenderModule mod_search (Zoek)

Tijd: 0.11 ms / 8440.35 ms Geheugen: -0.002 MB / 15.15 MB Application: beforeRenderModule mod_menu (Gasten - Menu Bovenzijde)

Tijd: 18.69 ms / 8459.04 ms Geheugen: 0.018 MB / 15.17 MB Application: afterRenderModule mod_menu (Gasten - Menu Bovenzijde)

Tijd: 136.70 ms / 8595.74 ms Geheugen: 0.217 MB / 15.38 MB Application: afterRender

Totaal aantal database zoekopdrachten: 116.64 ms

Geheugengebruik

Database zoekopdrachten

36 zoekopdrachten gelogd 116.64 ms

Tijd zoekopdracht: 0.95 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 4.206 MB Regels teruggegeven: 0

SELECT `data`

  FROM `hgcc_session`

  WHERE `session_id` = X'3232623537616666666337336536656265306136396565613262616131663738'

Verklaren

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

Profiel

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.18 ms
After opening tables	0.05 ms
System lock	0.03 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.14 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	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:661
9	Joomla\CMS\Session\Session->_start()	JROOT\libraries\src\Session\Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT\libraries\src\Session\Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT\libraries\src\Session\Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT\libraries\src\Application\CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:386
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.54 ms Na de laatste zoekopdracht: 68.51 ms Zoekopdracht geheugen: 0.020 MB geheugen voor zoekopdracht: 4.302 MB Regels teruggegeven: 0

SELECT `session_id`

  FROM `hgcc_session`

  WHERE `session_id` = X'3232623537616666666337336536656265306136396565613262616131663738' 
  LIMIT 1

Verklaren

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

Profiel

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:386
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: 4.36 ms Na de laatste zoekopdracht: 0.10 ms Zoekopdracht geheugen: 0.004 MB geheugen voor zoekopdracht: 4.307 MB

INSERT INTO `hgcc_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3232623537616666666337336536656265306136396565613262616131663738', 1, 1686173600, 0, '', 0)

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO `hgcc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3232623537616666666337336536656265306136396565613262616131663738', 1, 1686173600, 0, '', 0)

Profiel

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.19 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	3.91 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:386
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: 1.34 ms Na de laatste zoekopdracht: 155.38 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 4.496 MB Regels teruggegeven: 48

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

  FROM `hgcc_extensions`

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hgcc_extensions	ref	extension	extension	82	const	50	Using index condition; Using where

Profiel

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.16 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.47 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.10 ms
Reset for next command	0.03 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:225
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.75 ms Na de laatste zoekopdracht: 161.64 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 4.756 MB Regels teruggegeven: 17

SELECT id, rules

  FROM `hgcc_viewlevels`

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hgcc_viewlevels	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	17

Profiel

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
After opening tables	0.02 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.15 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.00 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:318
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:225
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: 0.11 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 4.772 MB Regels teruggegeven: 2

SELECT b.id

  FROM hgcc_usergroups AS a

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

  WHERE a.id = 23

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	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.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.15 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.03 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 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:318
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:225
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.76 ms Na de laatste zoekopdracht: 27.69 ms Zoekopdracht geheugen: 0.051 MB geheugen voor zoekopdracht: 4.841 MB Regels teruggegeven: 152

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

  FROM hgcc_extensions

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

  ORDER BY ordering

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hgcc_extensions	ALL	extension	INDEX KEY ONTBREEKT	NULL	NULL	375	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.04 ms
init	0.09 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
Creating sort index	0.89 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.08 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:351
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:356
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:225
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.80 ms Na de laatste zoekopdracht: 891.07 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 6.449 MB Regels teruggegeven: 1

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

  FROM `hgcc_extensions`

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

Verklaren

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

Profiel

Status	Duration
Starting	0.09 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.16 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT\libraries\src\Helper\LibraryHelper.php:167
16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Zelfde als de call in onderstaande regel.
15	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT\libraries\src\Version.php:321
10	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT\plugins\system\baforms\baforms.php:27
7	plgSystemBaforms->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
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:225
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.53 ms Na de laatste zoekopdracht: 0.32 ms Zoekopdracht geheugen: 0.006 MB geheugen voor zoekopdracht: 6.442 MB

UPDATE `hgcc_extensions`

  SET `params` = '{\"mediaversion\":\"da9d5a86084533818a5c1f99a2fa98da\"}'

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

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: UPDATE `hgcc_extensions` SET `params` = '{\"mediaversion\":\"da9d5a86084533818a5c1f99a2fa98da\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profiel

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.05 ms
Updating	0.10 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	3.16 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Helper\LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT\libraries\src\Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT\libraries\src\Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT\plugins\system\baforms\baforms.php:27
7	plgSystemBaforms->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
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:225
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.87 ms Na de laatste zoekopdracht: 482.57 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 7.354 MB Regels teruggegeven: 1

SELECT template

  FROM hgcc_template_styles

  WHERE `client_id`=0 
  AND `home`=1

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hgcc_template_styles	ALL	idx_client_id,idx_client_id_home	INDEX KEY ONTBREEKT	NULL	NULL	13	Using where

Profiel

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.11 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.14 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT\plugins\system\baforms\baforms.php:56
9	plgSystemBaforms->checkOverride()	JROOT\plugins\system\baforms\baforms.php:39
8	plgSystemBaforms->onAfterInitialise()	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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
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:225
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.36 ms Na de laatste zoekopdracht: 208.78 ms Zoekopdracht geheugen: 0.135 MB geheugen voor zoekopdracht: 7.829 MB Regels teruggegeven: 96

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 hgcc_menu AS m

  LEFT JOIN hgcc_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	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	191	Using index condition; Using where; Gebruikt bestandssortering
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.m.component_id	1	Using where

Profiel

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.18 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.18 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.39 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 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.00 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:78
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:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:417
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:65
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:533
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:1141
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:225
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.92 ms Na de laatste zoekopdracht: 631.59 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 8.825 MB Regels teruggegeven: 1

SELECT *

  FROM hgcc_languages

  WHERE published=1

  ORDER BY ordering ASC

Verklaren

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

Profiel

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.14 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.06 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:225
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.61 ms Na de laatste zoekopdracht: 0.63 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 8.843 MB Regels teruggegeven: 10

SELECT id, home, template, s.params

  FROM hgcc_template_styles as s

  LEFT JOIN hgcc_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	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX KEY ONTBREEKT	NULL	NULL	13	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	golfclub-2.s.template,const	1	Using index condition; Using where

Profiel

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.13 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.09 ms
Reset for next command	0.03 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:225
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.56 ms Na de laatste zoekopdracht: 362.83 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 9.687 MB Regels teruggegeven: 48

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

  FROM `hgcc_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admirorgallery','com_ajax','com_akeeba','com_associations','com_baforms','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dbreplacer','com_djimageslider','com_fields','com_finder','com_installer','com_jce','com_joomgallery','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilejoomla','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_quicklogout','com_search','com_securitycheck','com_sitemapgenerator','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xtcronjob')

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hgcc_assets	range	idx_asset_name	idx_asset_name	202	NULL	49	Using index condition

Profiel

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.18 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.70 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT\libraries\src\Access\Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT\components\com_content\models\category.php:139
13	ContentModelCategory->populateState()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT\libraries\src\MVC\View\CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:75
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.11 ms Na de laatste zoekopdracht: 0.17 ms Zoekopdracht geheugen: 0.162 MB geheugen voor zoekopdracht: 9.745 MB Regels teruggegeven: 763

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

  FROM `hgcc_assets`

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hgcc_assets	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	1733	Using sort_union(idx_asset_name,idx_parent_id); Using where

Profiel

Status	Duration
Starting	0.11 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.24 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	9.30 ms
End of update loop	0.03 ms
Query end	0.00 ms
Commit	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT\libraries\src\Access\Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT\components\com_content\models\category.php:139
13	ContentModelCategory->populateState()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT\libraries\src\MVC\View\CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:75
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.30 ms Na de laatste zoekopdracht: 96.62 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 10.472 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,(
SELECT COUNT(i.`id`)

  FROM `hgcc_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `hgcc_categories` AS `s`

  INNER JOIN `hgcc_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_content' OR c.extension='system') 
  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	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	PRIMARY	c	range	cat_idx,idx_left_right	idx_left_right	4	NULL	2	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	golfclub-2.c.id	8	Using index condition; Using where

Profiel

Status	Duration
Starting	0.19 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.07 ms
Statistics	0.24 ms
Preparing	0.02 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Optimizing	0.01 ms
Statistics	0.10 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.10 ms
Executing	0.01 ms
Sending data	0.18 ms
Executing	0.00 ms
Sending data	0.56 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Removing tmp table	0.06 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Categories\Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT\libraries\src\Categories\Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT\components\com_content\models\category.php:355
13	ContentModelCategory->getCategory()	JROOT\libraries\src\MVC\View\HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\libraries\src\MVC\View\CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:75
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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: 14.59 ms Na de laatste zoekopdracht: 60.71 ms Zoekopdracht geheugen: 0.044 MB geheugen voor zoekopdracht: 10.704 MB Regels teruggegeven: 3

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM hgcc_content AS a

  LEFT JOIN hgcc_content_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN hgcc_categories AS c 
  ON c.id = a.catid

  LEFT JOIN hgcc_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN hgcc_users AS uam 
  ON uam.id = a.modified_by

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

  LEFT JOIN hgcc_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,17) 
  AND c.access IN (1,1,17) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 15 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-07 21:33:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-07 21:33:23')

  ORDER BY   a.featured DESC, fp.ordering,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 8

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Gebruikt bestandssortering
1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	18	Using intersect(idx_catid,idx_state); Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.modified_by	1	Using where
1	SIMPLE	fp	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.id	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.id	1	Using where

Profiel

Status	Duration
Starting	0.29 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
After opening tables	0.04 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.12 ms
Optimizing	0.05 ms
Statistics	0.22 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.05 ms
Creating tmp table	0.09 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	12.27 ms
Creating sort index	0.15 ms
Removing tmp table	0.57 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.08 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\src\MVC\Model\BaseDatabaseModel.php:322
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\components\com_content\models\articles.php:576
14	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
13	ContentModelCategory->getItems()	JROOT\libraries\src\MVC\View\HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\libraries\src\MVC\View\CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:75
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.04 ms Na de laatste zoekopdracht: 38.67 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 10.880 MB Regels teruggegeven: 0

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

  FROM `hgcc_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 682 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,17)

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX KEY ONTBREEKT	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	golfclub-2.m.tag_id	1	Using where

Profiel

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
After opening tables	0.01 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.08 ms
Optimizing	0.03 ms
Statistics	0.17 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Helper\TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT\components\com_content\models\articles.php:706
14	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
13	ContentModelCategory->getItems()	JROOT\libraries\src\MVC\View\HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\libraries\src\MVC\View\CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:75
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.35 ms Na de laatste zoekopdracht: 0.37 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 10.900 MB Regels teruggegeven: 0

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

  FROM `hgcc_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,17)

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX KEY ONTBREEKT	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	golfclub-2.m.tag_id	1	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Helper\TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT\components\com_content\models\articles.php:706
14	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
13	ContentModelCategory->getItems()	JROOT\libraries\src\MVC\View\HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\libraries\src\MVC\View\CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:75
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.31 ms Na de laatste zoekopdracht: 0.13 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 10.918 MB Regels teruggegeven: 0

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

  FROM `hgcc_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 654 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,17)

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX KEY ONTBREEKT	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	golfclub-2.m.tag_id	1	Using where

Profiel

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Helper\TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT\components\com_content\models\articles.php:706
14	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
13	ContentModelCategory->getItems()	JROOT\libraries\src\MVC\View\HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\libraries\src\MVC\View\CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:75
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.35 ms Na de laatste zoekopdracht: 26.45 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 11.010 MB Regels teruggegeven: 1

SELECT COUNT(*)

  FROM hgcc_content AS a

  LEFT JOIN hgcc_content_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN hgcc_categories AS c 
  ON c.id = a.catid

  LEFT JOIN hgcc_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN hgcc_users AS uam 
  ON uam.id = a.modified_by

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

  LEFT JOIN hgcc_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,17) 
  AND c.access IN (1,1,17) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 15 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-07 21:33:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-07 21:33:23')

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	18	Using intersect(idx_catid,idx_state); Using where

Profiel

Status	Duration
Starting	0.17 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.06 ms
Optimizing	0.07 ms
Statistics	0.16 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.42 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.03 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:354
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT\libraries\src\MVC\Model\ListModel.php:289
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT\libraries\src\MVC\Model\ListModel.php:239
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT\components\com_content\models\category.php:265
13	ContentModelCategory->getItems()	JROOT\libraries\src\MVC\View\HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\libraries\src\MVC\View\CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:75
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.35 ms Na de laatste zoekopdracht: 0.25 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 11.010 MB Regels teruggegeven: 0

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

  FROM `hgcc_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 15 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,17)

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX KEY ONTBREEKT	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	golfclub-2.m.tag_id	1	Using where

Profiel

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Helper\TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT\libraries\src\MVC\View\CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:75
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.77 ms Na de laatste zoekopdracht: 359.05 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 11.676 MB Regels teruggegeven: 1

SELECT MAX(ordering)

  FROM `hgcc_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hgcc_extensions	ALL	extension	INDEX KEY ONTBREEKT	NULL	NULL	375	Using where

Profiel

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.05 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT\plugins\content\perfect_everything_in_everyway\perfect_everything_in_everyway.php:54
13	PlgContentPerfect_everything_in_everyway->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:280
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\components\com_content\views\category\view.html.php:88
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.37 ms Na de laatste zoekopdracht: 0.08 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 11.683 MB Regels teruggegeven: 1

SELECT `ordering`

  FROM `hgcc_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content' 
  AND `element` = 'perfect_everything_in_everyway'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hgcc_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	Using index condition; Using where

Profiel

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.06 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT\plugins\content\perfect_everything_in_everyway\perfect_everything_in_everyway.php:73
13	PlgContentPerfect_everything_in_everyway->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:280
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\components\com_content\views\category\view.html.php:88
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.22 ms Na de laatste zoekopdracht: 141.49 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 12.015 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 `hgcc_categories` AS `s`

  INNER JOIN `hgcc_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_content' OR c.extension='system') 
  AND c.access IN (1,1,17) 
  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	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	2 (23%)	Using index condition; Using where; Using rowid filter

Profiel

Status	Duration
Starting	0.18 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.22 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.20 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.07 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\src\Categories\Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT\libraries\src\Categories\Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT\administrator\components\com_fields\models\fields.php:203
17	FieldsModelFields->getListQuery()	JROOT\libraries\src\MVC\Model\ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT\libraries\src\MVC\Model\ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:136
14	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\category\view.html.php:113
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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: 11.43 ms Na de laatste zoekopdracht: 0.33 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 12.031 MB Regels teruggegeven: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM hgcc_fields AS a

  LEFT JOIN `hgcc_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN hgcc_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN hgcc_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN hgcc_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN hgcc_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `hgcc_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (15,0)) 
  AND a.access IN (1,1,17) 
  AND (a.group_id = 0 OR g.access IN (1,1,17)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	golfclub-2.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	golfclub-2.a.id	1	Using where; Using index; Distinct

Profiel

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.19 ms
Statistics	0.24 ms
Preparing	0.03 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
Executing	0.02 ms
Sending data	9.42 ms
Creating sort index	0.21 ms
Removing tmp table	0.40 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.09 ms
Reset for next command	0.02 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\administrator\components\com_fields\models\fields.php:333
16	FieldsModelFields->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:136
14	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\category\view.html.php:113
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.26 ms Na de laatste zoekopdracht: 637.17 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 13.250 MB Regels teruggegeven: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM hgcc_fields AS a

  LEFT JOIN `hgcc_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN hgcc_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN hgcc_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN hgcc_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN hgcc_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_content.categories' 
  AND a.access IN (1,1,17) 
  AND (a.group_id = 0 OR g.access IN (1,1,17)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	golfclub-2.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.group_id	1	Using where

Profiel

Status	Duration
Starting	0.17 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.06 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.03 ms
Executing	0.00 ms
Sending data	8.77 ms
Creating sort index	0.13 ms
Removing tmp table	0.35 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
23	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\administrator\components\com_fields\models\fields.php:333
20	FieldsModelFields->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:136
18	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\components\com_content\views\category\tmpl\blog.php:19
14	include JROOT\components\com_content\views\category\tmpl\blog.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\libraries\src\MVC\View\CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT\components\com_content\views\category\view.html.php:250
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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: 5.49 ms Na de laatste zoekopdracht: 1.18 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 13.270 MB Regels teruggegeven: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM hgcc_fields AS a

  LEFT JOIN `hgcc_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN hgcc_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN hgcc_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN hgcc_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN hgcc_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `hgcc_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.categories' 
  AND (fc.category_id IS NULL OR fc.category_id IN (15,0)) 
  AND a.access IN (1,1,17) 
  AND (a.group_id = 0 OR g.access IN (1,1,17)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	golfclub-2.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	golfclub-2.a.id	1	Using where; Using index; Distinct

Profiel

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.13 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	4.01 ms
Creating sort index	0.16 ms
Removing tmp table	0.35 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.08 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:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\administrator\components\com_fields\models\fields.php:333
21	FieldsModelFields->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:136
19	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:404
18	PlgSystemFields->display()	JROOT\plugins\system\fields\fields.php:324
17	PlgSystemFields->onContentAfterTitle()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\components\com_content\views\category\tmpl\blog.php:22
14	include JROOT\components\com_content\views\category\tmpl\blog.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\libraries\src\MVC\View\CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT\components\com_content\views\category\view.html.php:250
10	ContentViewCategory->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:118
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.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:225
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.71 ms Na de laatste zoekopdracht: 536.46 ms Zoekopdracht geheugen: 0.043 MB geheugen voor zoekopdracht: 14.290 MB Regels teruggegeven: 29

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

  FROM hgcc_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-06-07 21:33:23') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-07 21:33:23') 
  AND m.access IN (1,1,17) 
  AND m.client_id = 0 
  AND (mm.menuid = 116 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	31	Using index condition; Using where; Gebruikt bestandssortering
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	golfclub-2.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	golfclub-2.m.module,const	1	Using index condition; Using where

Profiel

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.10 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.62 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
14	JDatabaseDriver->loadObjectList()	Zelfde als de call in onderstaande regel.
13	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT\libraries\src\Helper\ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT\libraries\src\Helper\ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT\libraries\src\Document\HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT\templates\hgcc\index.php:4
7	require JROOT\templates\hgcc\index.php	JROOT\libraries\src\Document\HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1098
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:231
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: 5.38 ms Na de laatste zoekopdracht: 179.38 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 14.366 MB Regels teruggegeven: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM hgcc_fields AS a

  LEFT JOIN `hgcc_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN hgcc_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN hgcc_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN hgcc_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN hgcc_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,17) 
  AND (a.group_id = 0 OR g.access IN (1,1,17)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	golfclub-2.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.group_id	1	Using where

Profiel

Status	Duration
Starting	0.18 ms
checking permissions	0.01 ms
Opening tables	0.16 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.27 ms
Preparing	0.10 ms
Creating tmp table	0.10 ms
Sorting result	0.08 ms
Executing	0.01 ms
Sending data	3.46 ms
Creating sort index	0.20 ms
Removing tmp table	0.31 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.19 ms
Reset for next command	0.04 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
23	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\administrator\components\com_fields\models\fields.php:333
20	FieldsModelFields->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:136
18	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\libraries\cms\html\content.php:41
14	JHtmlContent::prepare()	Zelfde als de call in onderstaande regel.
13	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\modules\mod_custom\mod_custom.php:15
10	include JROOT\modules\mod_custom\mod_custom.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1112
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:231
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.41 ms Na de laatste zoekopdracht: 55.88 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 14.447 MB Regels teruggegeven: 0

SELECT *

  FROM hgcc_banners

  WHERE '2023-06-07 21:33:23' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	NULL	Impossible WHERE

Profiel

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
24	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_banners\helpers\banners.php:79
22	BannersHelper::updateReset()	JROOT\modules\mod_banners\mod_banners.php:19
21	include JROOT\modules\mod_banners\mod_banners.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\plugins\content\loadmodule\loadmodule.php:215
18	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:120
17	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\libraries\cms\html\content.php:41
14	JHtmlContent::prepare()	Zelfde als de call in onderstaande regel.
13	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\modules\mod_custom\mod_custom.php:15
10	include JROOT\modules\mod_custom\mod_custom.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1112
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:231
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: 18.83 ms Na de laatste zoekopdracht: 31.02 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 14.516 MB Regels teruggegeven: 1

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM hgcc_banners as a

  LEFT JOIN hgcc_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-07 21:33:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-07 21:33:23') 
  AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
  AND a.catid IN (3)

  ORDER BY a.sticky DESC, RAND()  
  LIMIT 1

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_state,idx_banner_catid	idx_state	1	NULL	6	Using index condition; Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	golfclub-2.a.cid	1

Profiel

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.15 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	17.37 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Removing tmp table	0.48 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
27	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:322
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:194
24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\components\com_banners\models\banners.php:222
23	BannersModelBanners->getItems()	JROOT\modules\mod_banners\helper.php:48
22	ModBannersHelper::getList()	JROOT\modules\mod_banners\mod_banners.php:20
21	include JROOT\modules\mod_banners\mod_banners.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\plugins\content\loadmodule\loadmodule.php:215
18	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:120
17	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\libraries\cms\html\content.php:41
14	JHtmlContent::prepare()	Zelfde als de call in onderstaande regel.
13	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\modules\mod_custom\mod_custom.php:15
10	include JROOT\modules\mod_custom\mod_custom.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1112
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:231
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: 5.90 ms Na de laatste zoekopdracht: 0.30 ms Zoekopdracht geheugen: 0.012 MB geheugen voor zoekopdracht: 14.540 MB

UPDATE hgcc_banners

  SET impmade = (impmade + 1)

  WHERE id IN (9)

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: UPDATE hgcc_banners SET impmade = (impmade + 1) WHERE id IN (9)

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.00 ms
table lock	0.01 ms
init for update	0.07 ms
Updating	0.14 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	5.31 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
24	JDatabaseDriverMysqli->execute()	JROOT\components\com_banners\models\banners.php:268
23	BannersModelBanners->impress()	JROOT\modules\mod_banners\helper.php:54
22	ModBannersHelper::getList()	JROOT\modules\mod_banners\mod_banners.php:20
21	include JROOT\modules\mod_banners\mod_banners.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\plugins\content\loadmodule\loadmodule.php:215
18	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:120
17	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\libraries\cms\html\content.php:41
14	JHtmlContent::prepare()	Zelfde als de call in onderstaande regel.
13	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\modules\mod_custom\mod_custom.php:15
10	include JROOT\modules\mod_custom\mod_custom.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1112
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:231
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.74 ms Na de laatste zoekopdracht: 0.20 ms Zoekopdracht geheugen: 0.011 MB geheugen voor zoekopdracht: 14.552 MB

UPDATE hgcc_banner_tracks

  SET `count` = (`count` + 1)

  WHERE track_type=1 
  AND banner_id=9 
  AND track_date='2023-06-07 21:00:00'

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: UPDATE hgcc_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=9 AND track_date='2023-06-07 21:00:00'

Profiel

Status	Duration
Starting	0.08 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.35 ms
Updating	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
24	JDatabaseDriverMysqli->execute()	JROOT\components\com_banners\models\banners.php:306
23	BannersModelBanners->impress()	JROOT\modules\mod_banners\helper.php:54
22	ModBannersHelper::getList()	JROOT\modules\mod_banners\mod_banners.php:20
21	include JROOT\modules\mod_banners\mod_banners.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\plugins\content\loadmodule\loadmodule.php:215
18	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:120
17	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\libraries\cms\html\content.php:41
14	JHtmlContent::prepare()	Zelfde als de call in onderstaande regel.
13	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\modules\mod_custom\mod_custom.php:15
10	include JROOT\modules\mod_custom\mod_custom.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1112
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:231
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.09 ms Na de laatste zoekopdracht: 0.20 ms Zoekopdracht geheugen: 0.011 MB geheugen voor zoekopdracht: 14.563 MB

INSERT INTO hgcc_banner_tracks
(`count`,`track_type`,`banner_id`,`track_date`) 
  VALUES 
(1, 1, 9, '2023-06-07 21:00:00')

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO hgcc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`) VALUES (1, 1, 9, '2023-06-07 21:00:00')

Profiel

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.16 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	1.68 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
24	JDatabaseDriverMysqli->execute()	JROOT\components\com_banners\models\banners.php:331
23	BannersModelBanners->impress()	JROOT\modules\mod_banners\helper.php:54
22	ModBannersHelper::getList()	JROOT\modules\mod_banners\mod_banners.php:20
21	include JROOT\modules\mod_banners\mod_banners.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\plugins\content\loadmodule\loadmodule.php:215
18	PlgContentLoadmodule->_loadmod()	JROOT\plugins\content\loadmodule\loadmodule.php:120
17	PlgContentLoadmodule->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\libraries\cms\html\content.php:41
14	JHtmlContent::prepare()	Zelfde als de call in onderstaande regel.
13	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\modules\mod_custom\mod_custom.php:15
10	include JROOT\modules\mod_custom\mod_custom.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1112
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:231
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.61 ms Na de laatste zoekopdracht: 997.73 ms Zoekopdracht geheugen: 0.020 MB geheugen voor zoekopdracht: 15.332 MB Regels teruggegeven: 0

SELECT * 
  from hgcc_xtcronjob_tasks 
  WHERE ran_at < '2023-06-07 21:33:26' 
  AND published=1

Verklaren

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

Profiel

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.10 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.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.00 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
9	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\xtcronjob\xtcronjob.php:60
7	PlgSystemXTCronjob->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
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:231
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]

29 zoekopdrachttypes gelogd, gesorteerd op weergave

SELECTEER Tabellen:

4 × SELECT `m`.`tag_id`,`t`.*
 
  FROM `hgcc_contentitem_tag_map` AS m 
 
  INNER JOIN `hgcc_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
 
  FROM hgcc_fields AS a
 
  LEFT JOIN `hgcc_languages` AS l 
  ON l.lang_code = a.language
 
  LEFT JOIN hgcc_users AS uc 
  ON uc.id=a.checked_out
 
  LEFT JOIN hgcc_viewlevels AS ag 
  ON ag.id = a.access
 
  LEFT JOIN hgcc_users AS ua 
  ON ua.id = a.created_user_id
 
  LEFT JOIN hgcc_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
 
  FROM hgcc_fields AS a
 
  LEFT JOIN `hgcc_languages` AS l 
  ON l.lang_code = a.language
 
  LEFT JOIN hgcc_users AS uc 
  ON uc.id=a.checked_out
 
  LEFT JOIN hgcc_viewlevels AS ag 
  ON ag.id = a.access
 
  LEFT JOIN hgcc_users AS ua 
  ON ua.id = a.created_user_id
 
  LEFT JOIN hgcc_fields_groups AS g 
  ON g.id = a.group_id
 
  LEFT JOIN `hgcc_fields_categories` AS fc 
  ON fc.field_id = a.id

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

1 × SELECT `data`
 
  FROM `hgcc_session`

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
 
  FROM hgcc_banners as a
 
  LEFT JOIN hgcc_banner_clients AS cl 
  ON cl.id = a.cid

```
1 × SELECT *
 
  FROM hgcc_banners
```

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
 
  FROM hgcc_modules AS m
 
  LEFT JOIN hgcc_modules_menu AS mm 
  ON mm.moduleid = m.id
 
  LEFT JOIN hgcc_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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

1 × SELECT `ordering`
 
  FROM `hgcc_extensions`

1 × SELECT MAX(ordering)
 
  FROM `hgcc_extensions`

1 × SELECT COUNT(*)
 
  FROM hgcc_content AS a
 
  LEFT JOIN hgcc_content_frontpage AS fp 
  ON fp.content_id = a.id
 
  LEFT JOIN hgcc_categories AS c 
  ON c.id = a.catid
 
  LEFT JOIN hgcc_users AS ua 
  ON ua.id = a.created_by
 
  LEFT JOIN hgcc_users AS uam 
  ON uam.id = a.modified_by
 
  LEFT JOIN hgcc_categories as parent 
  ON parent.id = c.parent_id
 
  LEFT JOIN hgcc_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
 
  FROM hgcc_content AS a
 
  LEFT JOIN hgcc_content_frontpage AS fp 
  ON fp.content_id = a.id
 
  LEFT JOIN hgcc_categories AS c 
  ON c.id = a.catid
 
  LEFT JOIN hgcc_users AS ua 
  ON ua.id = a.created_by
 
  LEFT JOIN hgcc_users AS uam 
  ON uam.id = a.modified_by
 
  LEFT JOIN hgcc_categories as parent 
  ON parent.id = c.parent_id
 
  LEFT JOIN hgcc_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `session_id`
 
  FROM `hgcc_session`

1 × 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,(
 SELECT COUNT(i.`id`)
 
  FROM `hgcc_content` AS `i`

1 × SELECT id, home, template, s.params
 
  FROM hgcc_template_styles as s
 
  LEFT JOIN hgcc_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT *
 
  FROM hgcc_languages
```

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 hgcc_menu AS m
 
  LEFT JOIN hgcc_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT template
 
  FROM hgcc_template_styles

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

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

1 × SELECT id, rules
 
  FROM `hgcc_viewlevels

1 × SELECT * 
  from hgcc_xtcronjob_tasks

ANDERE Tabellen:

1 × INSERT INTO `hgcc_session`
 (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
 (X'3232623537616666666337336536656265306136396565613262616131663738', 1, 1686173600, 0, '', 0

1 × UPDATE `hgcc_extensions`
 
  SET `params` = '{\"mediaversion\":\"da9d5a86084533818a5c1f99a2fa98da\"}'

1 × UPDATE hgcc_banners
 
  SET impmade = (impmade + 1)

1 × UPDATE hgcc_banner_tracks
 
  SET `count` = (`count` + 1)

1 × INSERT INTO hgcc_banner_tracks
 (`count`,`track_type`,`banner_id`,`track_date`) 
  VALUES 
 (1, 1, 9, '2023-06-07 21:00:00'