VLAKAF - Hansbeekse Dorpskrant De grote FUSIE ENQUETE BOEK 20 euro (te verkrijgen bij de redactie) De grote FUSIE ENQUETE

Lees hier de resultaten van de grote FUSIE ENQUETE

De enquête over hoe de Hansbekenaren de fusie met Deinze ervaren, werd op 14/2/2022 afgesloten. Er waren meer dan 150 inzendingen, wat ruim voldoende is om een mooi beeld te geven over de mening van de Hansbekenaren.

De nieuwbouw aan het cultuurhuis wordt positief onthaald

Informatie en participatie scoren ondermaats

Fiere Hansbekenaar voelt zich niet verbonden met Deinze

Samenvattend resultaat lees je HIER.
Detailresultaat per vraag lees je HIER.
Losse commentaren uit de enquête lees je HIER.

Grafisch overzicht resultaten

BART DE WULF werd Zjaloezigen Zjeraar 2021.

Als stichtend lid van Afrit 12, Dorpsraad en actief kernlid van Tuupetegoare, toont Bart zijn engagement voor ons dorp.

Ook zijn verbindende communicatie is een echte troef voor ons dorp!

Fiets- of wandelroutes in Hansbeke

Corona-tijden maken wandelen en fietsen populairder dan ooit. Geniet van onze landelijke gemeente en kies je activiteit uit:

WANDELING Drijvelden - 8 km --> beschrijving

DIVERSE WANDELINGEN tussen de 4 en de 7 km --> beschrijving

FIETSROUTE 'lus door Hansbeke" - 17 km (ook langs aardewegeltjes!) --> beschrijving

MOUNTAINBIKEROUTE --> beschrijving

FIETSROUTE NEVELLANDROUTE - 50 km --> beschrijving (deze route is bewegwijzerd)

--------OPGELET voor heel het jaar 2021 --------:
door de spoorwegwerken die momenteel aan de gang zijn in Hansbeke (uitbreiding spoorweg met een 3e en 4e spoor) zijn de aarden parallelwegen langs de spoorweg niet toegankelijk voor fietsers (ook nauwelijks voor mountainbikers omdat er soms een nieuw aangelegde gracht moet overgesprongen worden!) Voor heel sportieve wandelaars die niet bang zijn van modderschoenen en de nodige springpartijen, is de wandeling wel nog technisch mogelijk, maar hou rekening dat er op bepaalde zones verbodstekens aangebracht zijn door Infrabel.
Infrabel heeft helaas niet de verantwoordelijkheidszin om alternatieve routes aan te duiden of enige indicatie te geven aan wandelaars om omleggingswegen te volgen. Zorg dus dat je google-maps op je gsm bij de hand hebt. Of vraag de weg aan de Hansbekenaren, die je met veel plezier zullen verder helpen. Op afstand blijven natuurlijk (Corona, weet je wel) ---------

PLANNEN RONDWEG HANSBEKE

We ontvingen de plannen van de rondweg in Hansbeke, en delen deze graag met jullie.

Plan Rondweg van Vaartstraat tot Rondpunt aan de Doornbosstraat: HIER

Plan Rondweg van Rondpunt Doornbosstraat tot Spoorweg Merendreestraat: HIER

Plan Rondweg van Spoorweg tot rondpunt Rattenkasteel: HIER

Joomla! Foutopsporingsconsole

Sessie

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1680253833,
                "last": 1680253833,
                "now": 1680253833
            },
            "token": "gwBQikQQqic5Z6ha5Z1BuOUli6HMOZuK"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "fce7b8fb1dd0c50ddcf09cbe14ede87bd5c24576": {
                    "link": "http:\/\/vlakaf.be\/index.php\/44-enquete-3-jaar-fusie-hansbeke-in-deinze-jouw-mening-telt",
                    "expiry": 1680253833
                },
                "0445acffa0a48e4b568a6e26aa5bb57ec863b1b7": {
                    "link": "http:\/\/vlakaf.be\/index.php\/43-zjaloezigen-zjeraar-2021",
                    "expiry": 1680253833
                },
                "bb00324b169437a8f5d877b2eef4daffe2016357": {
                    "link": "http:\/\/vlakaf.be\/index.php\/40-wandelingen",
                    "expiry": 1680253833
                },
                "b20ff13762d77e1ae772298142c5f0cf88d35b2a": {
                    "link": "http:\/\/vlakaf.be\/index.php\/29-rondweg-hansbeke-de-plannen",
                    "expiry": 1680253833
                }
            }
        }
    }
}

Profielinformatie

Geheugengebruik

Database zoekopdrachten

22 zoekopdrachten gelogd 203.22 ms

Tijd zoekopdracht: 1.40 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 1.024 MB Regels teruggegeven: 0

SELECT `data`

  FROM `kemnz_session`

  WHERE `session_id` = '039be5290a5d59ac782b03eaa2eb1522'

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Zelfde als de call in onderstaande regel.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:765
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:351
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[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: 0.36 ms Zoekopdracht geheugen: 0.020 MB geheugen voor zoekopdracht: 1.038 MB Regels teruggegeven: 0

SELECT `session_id`

  FROM `kemnz_session`

  WHERE `session_id` = '039be5290a5d59ac782b03eaa2eb1522' 
  LIMIT 1

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:767
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:351
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tijd zoekopdracht: 7.36 ms Na de laatste zoekopdracht: 0.07 ms Zoekopdracht geheugen: 0.004 MB geheugen voor zoekopdracht: 1.043 MB

INSERT INTO `kemnz_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('039be5290a5d59ac782b03eaa2eb1522', 1, 1680253833, 0, '', 0)

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO `kemnz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('039be5290a5d59ac782b03eaa2eb1522', 1, 1680253833, 0, '', 0)

Profiel

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.02 ms
Update	6.54 ms
End of update loop	0.04 ms
Query end	0.02 ms
Commit	0.32 ms
closing tables	0.04 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.08 ms
Updating status	0.02 ms
Reset for next command	0.02 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:767
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:351
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tijd zoekopdracht: 12.80 ms Na de laatste zoekopdracht: 0.48 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 1.074 MB Regels teruggegeven: 36

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

  FROM `kemnz_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	kemnz_extensions	ref	extension	extension	82	const	36	Using index condition; Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:203
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.90 ms Na de laatste zoekopdracht: 0.74 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 1.100 MB Regels teruggegeven: 4

SELECT id, rules

  FROM `kemnz_viewlevels`

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 11.01 ms Na de laatste zoekopdracht: 0.16 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 1.112 MB Regels teruggegeven: 2

SELECT b.id

  FROM kemnz_usergroups AS a

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

  WHERE a.id = 9

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	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.16 ms
checking permissions	0.03 ms
Opening tables	0.12 ms
After opening tables	0.04 ms
System lock	0.04 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	9.80 ms
Preparing	0.07 ms
Unlocking tables	0.03 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.04 ms
Query end	0.05 ms
Commit	0.02 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.08 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 1.86 ms Na de laatste zoekopdracht: 0.27 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 1.133 MB Regels teruggegeven: 79

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

  FROM kemnz_extensions

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

  ORDER BY ordering

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Zelfde als de call in onderstaande regel.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.23 ms Na de laatste zoekopdracht: 6.35 ms Zoekopdracht geheugen: 0.048 MB geheugen voor zoekopdracht: 1.549 MB Regels teruggegeven: 22

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

  LEFT JOIN kemnz_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	22	Using index condition; Using where; Gebruikt bestandssortering
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.m.component_id	1	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Zelfde als de call in onderstaande regel.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:382
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:498
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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.90 ms Na de laatste zoekopdracht: 2.11 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 1.714 MB Regels teruggegeven: 1

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

  FROM `kemnz_extensions`

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

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Zelfde als de call in onderstaande regel.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.95 ms Na de laatste zoekopdracht: 0.13 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 1.767 MB

UPDATE `kemnz_extensions`

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

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

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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: 9.38 ms Na de laatste zoekopdracht: 0.41 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 1.795 MB Regels teruggegeven: 2

SELECT *

  FROM kemnz_languages

  WHERE published=1

  ORDER BY ordering ASC

Verklaren

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

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:203
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: 9.58 ms Na de laatste zoekopdracht: 0.32 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 1.809 MB Regels teruggegeven: 4

SELECT id, home, template, s.params

  FROM kemnz_template_styles as s

  LEFT JOIN kemnz_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	INDEX KEY ONTBREEKT	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	deb41643n2_joomla.s.template,const	1	Using index condition; Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:203
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: 9.70 ms Na de laatste zoekopdracht: 1.98 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 1.907 MB Regels teruggegeven: 36

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

  FROM `kemnz_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kemnz_assets	ALL	idx_asset_name	INDEX KEY ONTBREEKT	NULL	NULL	100	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:440
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:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.88 ms Na de laatste zoekopdracht: 0.24 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 2.017 MB Regels teruggegeven: 53

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

  FROM `kemnz_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	kemnz_assets	ALL	idx_asset_name,idx_parent_id	INDEX KEY ONTBREEKT	NULL	NULL	100	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:440
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:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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: 20.12 ms Na de laatste zoekopdracht: 0.71 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 2.084 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 `kemnz_content` AS `i`

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

  FROM `kemnz_categories` AS `s`

  INNER JOIN `kemnz_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 = 10

  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	ALL	cat_idx,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	16	Using where; Gebruikt bestandssortering
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	deb41643n2_joomla.c.id	4	Using index condition; Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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: 26.17 ms Na de laatste zoekopdracht: 0.91 ms Zoekopdracht geheugen: 0.043 MB geheugen voor zoekopdracht: 2.123 MB Regels teruggegeven: 4

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,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 kemnz_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 10 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-31 09:10:33') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-31 09:10:33')

  ORDER BY  c.lft,   
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END DESC ,  a.created   
  LIMIT 9

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_state,idx_catid	1,4	NULL	15	Using intersect(idx_state,idx_catid); Using where; Gebruikt bestandssortering
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.id	1	Using where

Profiel

Status	Duration
Starting	0.40 ms
checking permissions	0.03 ms
Opening tables	0.15 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.10 ms
Optimizing	0.06 ms
Statistics	0.22 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.06 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	24.45 ms
End of update loop	0.12 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.08 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
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:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.08 ms Na de laatste zoekopdracht: 0.70 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 2.207 MB Regels teruggegeven: 1

SELECT COUNT(*)

  FROM kemnz_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 10 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-31 09:10:33') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-31 09:10:33')

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_state,idx_catid	1,4	NULL	15	Using intersect(idx_state,idx_catid); Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
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:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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: 24.80 ms Na de laatste zoekopdracht: 0.34 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 2.214 MB Regels teruggegeven: 0

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

  FROM `kemnz_contentitem_tag_map` AS m 

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

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

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	deb41643n2_joomla.m.tag_id	1	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.16 ms Na de laatste zoekopdracht: 1.01 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 2.254 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 `kemnz_categories` AS `s`

  INNER JOIN `kemnz_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,5) 
  AND c.published = 1 
  AND s.id = 10

  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	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	16	Using where; Gebruikt bestandssortering

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
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:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.13 ms Na de laatste zoekopdracht: 0.16 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 2.271 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 kemnz_fields AS a

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

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

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

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

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

  LEFT JOIN `kemnz_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 (10,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  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	deb41643n2_joomla.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.id	1	Using where; Using index; Distinct

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
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:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
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:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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.37 ms Na de laatste zoekopdracht: 3.57 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 2.399 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 kemnz_fields AS a

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

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

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

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

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

  LEFT JOIN `kemnz_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 (10,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  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	deb41643n2_joomla.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	deb41643n2_joomla.a.id	1	Using where; Using index; Distinct

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
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:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/tmpl/blog.php:19
15	require JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/templates/casinotime/html/com_content/category/blog.php:17
14	include JROOT/templates/casinotime/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:203
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: 26.91 ms Na de laatste zoekopdracht: 5.04 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 2.481 MB Regels teruggegeven: 6

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

  FROM kemnz_modules AS m

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

  LEFT JOIN kemnz_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-03-31 09:10:33') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-31 09:10:33') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 435 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	mm	index	PRIMARY	PRIMARY	8	NULL	23	Using where; Using index; Using temporary; Gebruikt bestandssortering
1	SIMPLE	m	eq_ref	PRIMARY,published,newsfeeds	PRIMARY	4	deb41643n2_joomla.mm.moduleid	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	deb41643n2_joomla.m.module,const	1	Using index condition; Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	Zelfde als de call in onderstaande regel.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/casinotime/functions.php:4
8	require JROOT/templates/casinotime/functions.php	JROOT/templates/casinotime/index.php:12
7	require JROOT/templates/casinotime/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1037
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

19 zoekopdrachttypes gelogd, gesorteerd op weergave

SELECTEER Tabellen:

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

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `kemnz_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 kemnz_fields AS a 
  LEFT JOIN `kemnz_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN kemnz_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN kemnz_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN kemnz_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN kemnz_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `kemnz_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT `data` 
  FROM `kemnz_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 
  FROM `kemnz_categories` AS `s` 
  INNER JOIN `kemnz_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 `m`.`tag_id`,`t`.* 
  FROM `kemnz_contentitem_tag_map` AS m  
  INNER JOIN `kemnz_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT COUNT(*) 
  FROM kemnz_content AS a 
  LEFT JOIN kemnz_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN kemnz_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN kemnz_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN kemnz_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN kemnz_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,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 kemnz_content AS a 
  LEFT JOIN kemnz_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN kemnz_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN kemnz_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN kemnz_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN kemnz_content_rating AS v 
  ON a.id = v.content_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,( SELECT COUNT(i.`id`) 
  FROM `kemnz_content` AS `i`

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

1 × SELECT `session_id` 
  FROM `kemnz_session`

```
1 × SELECT * 
  FROM kemnz_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 kemnz_menu AS m 
  LEFT JOIN kemnz_extensions AS e 
  ON m.component_id = e.extension_id

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

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

1 × SELECT id, rules 
  FROM `kemnz_viewlevels

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

ANDERE Tabellen:

1 × INSERT INTO `kemnz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('039be5290a5d59ac782b03eaa2eb1522', 1, 1680253833, 0, '', 0

1 × UPDATE `kemnz_extensions` 
  SET `params` = '{\"mediaversion\":\"fd38ff0353f085a67b29ae70637f69fd\"}'