Schaakvereniging Leiderdorp

A'dam Beserkers - Leiderdorp 3½ -4½

Onze allereerste wedstrijd in de landelijke 2e klasse, en dan meteen tegen het op papier sterkste team... Het werd een sensationele middag !

Lees meer: A'dam Beserkers - Leiderdorp 3½ -4½

Schaken leren voor volwassenen, schrijf je snel in !

Schaakvereniging Leiderdorp doet mee aan de landelijke actie NederlandSchaakt.

Wil je leren schaken? Of kun je al schaken maar wil je beter worden? Dan kun je binnenkort terecht bij schaakclub Leiderdorp! Wij doen namelijk mee met NederlandSchaakt. In dit nieuwe initiatief wordt schaakles aangeboden aan beginnende volwassenen :

* Schaken leren voor beginners

OF:
* Beter schaken voor gevorderden

Hoe werkt het?
Elke module wordt gegeven in 6 lessen van 1,5 uur op woensdag tussen 6 september en 11 oktober. Voor deze 6 (!) lessen betaalt u slechts 99 euro.

De lessen beginnen telkens om 20.15 in De Brink, Kastanjelaan 6 te Leiderdorp. De lessen worden gegeven door een professionele trainer.

Meer weten?

Ga naar nederlandschaakt.nl voor meer informatie of geef je op voor de cursus bij schaakclub Leiderdorp.
* Schaken leren klik hier

OF (als je al kunt schaken) :

* Beter schaken klik hier

Leiderdorp - VAS3 4½ - 3½

We zijn kampioen ! ! !

We moesten minstens gelijkspelen om met zekerheid kampioen te worden, het werd een nipte overwinning op het Amsterdamse VAS.

Lees meer: Leiderdorp - VAS3 4½ - 3½

Voorschoten2 - Leiderdorp 4 ½ - 3½

We togen naar Voorschoten in de wetenschap dat bij minimaal een 4-4 uitslag we ons kampioen mochten noemen . . .

Lees meer: Voorschoten2 - Leiderdorp 4 ½ - 3½

JCC E team plaatst zich voor NK!

Op zaterdag 18 maart werden in Voorschoten de kwalificatiewedstrijden gespeeld voor het nationaal JCC-E kampioenschap. Voor het eerst sinds jaren hadden we weer een team in die leeftijdscategorie.

Lees meer: JCC E team plaatst zich voor NK!

Leiderdorp - LSG3 4 - 4

We staan fier aan kop en moesten nu tegen het sterke LSG3 (4e plaats), waar we vorig jaar nog van hadden verloren. Zelfverzekerd maar ook een beetje gespannen gingen we de slag aan.

Lees meer: Leiderdorp - LSG3 4 - 4

Schaakhuis - Leiderdorp 2 ½ - 5 ½

Net als vorig seizoen mochten we weer een uitwedstrijd spelen in Den Haag tegen Schaakhuis. Een tegenstander die voor elke ploeg gevaarlijk blijkt, dus ook wij wisten dat we alert moesten zijn!

Lees meer: Schaakhuis - Leiderdorp 2 ½ - 5 ½

Joomla! Foutopsporingsconsole

Sessie

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695791227,
                "last": 1695791227,
                "now": 1695791227
            }
        },
        "registry": {
            "jevents": {
                "moduleid118": {
                    "shownEventIds": [],
                    "page": 0,
                    "firstEventDate": false
                }
            },
            "published_fv_ses": "0"
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "45ee515de2594f18bb1a16ea542748659478651a": {
                    "link": "http://svleiderdorp.nl/index.php/artikels/alles/459-a-dam-beserkers-leiderdorp-3-4",
                    "expiry": 1695791227
                },
                "abb5a7b407fcc39fa219c7a9ae4c21a6f06656e9": {
                    "link": "http://svleiderdorp.nl/index.php/artikels/alles/458-schaken-leren-voor-volwassenen-schrijf-je-snel-in",
                    "expiry": 1695791227
                },
                "f6c25f7c511cd8c3382bbf9132650432621dab42": {
                    "link": "http://svleiderdorp.nl/index.php/artikels/alles/457-leiderdorp-vas3-4-3",
                    "expiry": 1695791227
                },
                "ccdedb0cd0814bc125659d113a99c26e2ab1864a": {
                    "link": "http://svleiderdorp.nl/index.php/artikels/alles/456-voorschoten2-leiderdorp-4-3",
                    "expiry": 1695791227
                },
                "f2314c5bc1a9fbc82d6e449c1dcb82feb8a9d9f4": {
                    "link": "http://svleiderdorp.nl/index.php/jeugdn/verslagenjeugd2/455-jjce-opdreef",
                    "expiry": 1695791227
                },
                "74f8e9d4c832fb4f3b8e989135e84dcb61447f38": {
                    "link": "http://svleiderdorp.nl/index.php/artikels/alles/452-leiderdorp-lsg3-4-4",
                    "expiry": 1695791227
                },
                "06ef7e0fd9d6c7e94b8797e8deefcf8a30500408": {
                    "link": "http://svleiderdorp.nl/index.php/artikels/alles/451-schaakhuis-leiderdorp-2-5",
                    "expiry": 1695791227
                }
            }
        }
    }
}

Profielinformatie

Tijd

Geheugen

Tijd: 30.53 ms / 30.53 ms Geheugen: 2.042 MB / 2.42 MB Application: afterLoad

Tijd: 116.27 ms / 146.81 ms Geheugen: 5.441 MB / 7.86 MB Application: afterInitialise

Tijd: 24.84 ms / 171.65 ms Geheugen: 0.832 MB / 8.69 MB Application: afterRoute

Tijd: 9.80 ms / 181.45 ms Geheugen: 0.241 MB / 8.93 MB Application: beforeRenderComponent com_content

Tijd: 13.48 ms / 194.92 ms Geheugen: 0.688 MB / 9.62 MB Application: Before Access::preloadComponents (all components)

Tijd: 1.69 ms / 196.62 ms Geheugen: 0.067 MB / 9.69 MB Application: After Access::preloadComponents (all components)

Tijd: 0.03 ms / 196.64 ms Geheugen: -0.005 MB / 9.68 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tijd: 0.69 ms / 197.34 ms Geheugen: 0.026 MB / 9.71 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tijd: 136.71 ms / 334.05 ms Geheugen: 3.050 MB / 12.76 MB Application: afterRenderComponent com_content

Tijd: 2.38 ms / 336.43 ms Geheugen: 0.006 MB / 12.77 MB Application: afterDispatch

Tijd: 24.28 ms / 360.71 ms Geheugen: 0.419 MB / 13.18 MB Application: beforeRenderModule mod_articles_category (Aankondigingen)

Tijd: 21.24 ms / 381.95 ms Geheugen: 0.121 MB / 13.31 MB Application: afterRenderRawModule mod_articles_category (Aankondigingen)

Tijd: 0.03 ms / 381.98 ms Geheugen: -0.001 MB / 13.31 MB Application: beforeRenderModule mod_articles_category (Aankondigingen)

Tijd: 2.06 ms / 384.04 ms Geheugen: 0.048 MB / 13.35 MB Application: afterRenderModule mod_articles_category (Aankondigingen)

Tijd: 0.09 ms / 384.13 ms Geheugen: 0.001 MB / 13.35 MB Application: beforeRenderModule mod_sigplus (Foto's)

Tijd: 284.16 ms / 668.30 ms Geheugen: 0.275 MB / 13.63 MB Application: afterRenderRawModule mod_sigplus (Foto's)

Tijd: 0.02 ms / 668.32 ms Geheugen: -0.045 MB / 13.58 MB Application: beforeRenderModule mod_sigplus (Foto's)

Tijd: 0.71 ms / 669.03 ms Geheugen: 0.003 MB / 13.59 MB Application: afterRenderModule mod_sigplus (Foto's)

Tijd: 0.04 ms / 669.07 ms Geheugen: -0.009 MB / 13.58 MB Application: beforeRenderModule mod_chesspuzzle (Puzzel van de dag)

Tijd: 1.03 ms / 670.10 ms Geheugen: 0.011 MB / 13.59 MB Application: afterRenderRawModule mod_chesspuzzle (Puzzel van de dag)

Tijd: 0.01 ms / 670.11 ms Geheugen: -0.000 MB / 13.59 MB Application: beforeRenderModule mod_chesspuzzle (Puzzel van de dag)

Tijd: 0.56 ms / 670.67 ms Geheugen: 0.002 MB / 13.59 MB Application: afterRenderModule mod_chesspuzzle (Puzzel van de dag)

Tijd: 0.04 ms / 670.71 ms Geheugen: 0.045 MB / 13.64 MB Application: beforeRenderModule mod_menu (Sponsors)

Tijd: 4.03 ms / 674.74 ms Geheugen: 0.067 MB / 13.70 MB Application: afterRenderRawModule mod_menu (Sponsors)

Tijd: 0.02 ms / 674.75 ms Geheugen: -0.001 MB / 13.70 MB Application: beforeRenderModule mod_menu (Sponsors)

Tijd: 0.58 ms / 675.33 ms Geheugen: 0.002 MB / 13.70 MB Application: afterRenderModule mod_menu (Sponsors)

Tijd: 0.08 ms / 675.41 ms Geheugen: 0.010 MB / 13.71 MB Application: beforeRenderModule mod_jevents_latest (Agenda)

Tijd: 21.01 ms / 696.43 ms Geheugen: 1.861 MB / 15.58 MB Application: Before Access::getAssetRules (id:310 name:com_jevents)

Tijd: 0.06 ms / 696.49 ms Geheugen: 0.007 MB / 15.58 MB Application: After Access::getAssetRules (id:310 name:com_jevents)

Tijd: 37.50 ms / 733.99 ms Geheugen: 1.535 MB / 17.12 MB Application: afterRenderRawModule mod_jevents_latest (Agenda)

Tijd: 0.03 ms / 734.02 ms Geheugen: -0.004 MB / 17.11 MB Application: beforeRenderModule mod_jevents_latest (Agenda)

Tijd: 0.85 ms / 734.87 ms Geheugen: 0.002 MB / 17.11 MB Application: afterRenderModule mod_jevents_latest (Agenda)

Tijd: 0.06 ms / 734.93 ms Geheugen: 0.002 MB / 17.12 MB Application: beforeRenderModule mod_sp_tweet (Twitter)

Tijd: 210.38 ms / 945.31 ms Geheugen: 0.086 MB / 17.20 MB Application: afterRenderRawModule mod_sp_tweet (Twitter)

Tijd: 0.02 ms / 945.33 ms Geheugen: -0.003 MB / 17.20 MB Application: beforeRenderModule mod_sp_tweet (Twitter)

Tijd: 0.84 ms / 946.17 ms Geheugen: 0.002 MB / 17.20 MB Application: afterRenderModule mod_sp_tweet (Twitter)

Tijd: 0.09 ms / 946.26 ms Geheugen: -0.002 MB / 17.20 MB Application: beforeRenderModule mod_custom (Fotohome)

Tijd: 3.99 ms / 950.26 ms Geheugen: 0.005 MB / 17.20 MB Application: afterRenderRawModule mod_custom (Fotohome)

Tijd: 0.02 ms / 950.28 ms Geheugen: -0.001 MB / 17.20 MB Application: beforeRenderModule mod_custom (Fotohome)

Tijd: 0.59 ms / 950.87 ms Geheugen: 0.003 MB / 17.21 MB Application: afterRenderModule mod_custom (Fotohome)

Tijd: 0.08 ms / 950.95 ms Geheugen: 0.001 MB / 17.21 MB Application: beforeRenderModule mod_menu (KNSB)

Tijd: 2.36 ms / 953.31 ms Geheugen: 0.011 MB / 17.22 MB Application: afterRenderRawModule mod_menu (KNSB)

Tijd: 0.01 ms / 953.32 ms Geheugen: -0.000 MB / 17.22 MB Application: beforeRenderModule mod_menu (KNSB)

Tijd: 0.55 ms / 953.87 ms Geheugen: 0.002 MB / 17.22 MB Application: afterRenderModule mod_menu (KNSB)

Tijd: 10.20 ms / 964.07 ms Geheugen: 0.748 MB / 17.97 MB Application: afterRender

Totaal aantal database zoekopdrachten: 64.36 ms

Geheugengebruik

Database zoekopdrachten

35 zoekopdrachten gelogd 64.36 ms

Tijd zoekopdracht: 0.72 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 4.149 MB Regels teruggegeven: 0

SELECT `data`

  FROM `u5143d10207_session`

  WHERE `session_id` = X'3934366233313362663335633536343434386333363066666666333331323062'

Verklaren

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

Profiel

Status	Duration
Starting	0.16 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.03 ms
Optimizing	0.03 ms
Statistics	0.05 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.05 ms
Updating status	0.03 ms
Reset for next command	0.02 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.81 ms Na de laatste zoekopdracht: 2.76 ms Zoekopdracht geheugen: 0.004 MB geheugen voor zoekopdracht: 4.244 MB Regels teruggegeven: 0

SELECT `session_id`

  FROM `u5143d10207_session`

  WHERE `session_id` = X'3934366233313362663335633536343434386333363066666666333331323062' 
  LIMIT 1

Verklaren

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

Profiel

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.04 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.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.08 ms
Updating status	0.04 ms
Reset for next command	0.02 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.85 ms Na de laatste zoekopdracht: 0.14 ms Zoekopdracht geheugen: 0.004 MB geheugen voor zoekopdracht: 4.250 MB

INSERT INTO `u5143d10207_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3934366233313362663335633536343434386333363066666666333331323062', 1, 1695791227, 0, '', 0)

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO `u5143d10207_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3934366233313362663335633536343434386333363066666666333331323062', 1, 1695791227, 0, '', 0)

Profiel

Status	Duration
Starting	0.17 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init for update	0.04 ms
Update	0.13 ms
Waiting for query cache lock	0.03 ms
Update	0.02 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	3.95 ms
Closing tables	0.07 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.08 ms
Updating status	0.04 ms
Reset for next command	0.03 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.45 ms Na de laatste zoekopdracht: 3.28 ms Zoekopdracht geheugen: 0.006 MB geheugen voor zoekopdracht: 4.439 MB Regels teruggegeven: 41

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

  FROM `u5143d10207_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	u5143d10207_extensions	ref	extension	extension	82	const	41	Using index condition; Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Zelfde als de call in onderstaande regel.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.87 ms Na de laatste zoekopdracht: 4.02 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 4.719 MB Regels teruggegeven: 4

SELECT id, rules

  FROM `u5143d10207_viewlevels`

Verklaren

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

Profiel

Status	Duration
Starting	0.19 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.49 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.07 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.03 ms
Starting cleanup	0.03 ms
Freeing items	0.07 ms
Updating status	0.04 ms
Reset for next command	0.03 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: 1.00 ms Na de laatste zoekopdracht: 0.20 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 4.730 MB Regels teruggegeven: 1

SELECT b.id

  FROM u5143d10207_usergroups AS a

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

  WHERE a.id = 1

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	1	Using where; Using index

Profiel

Status	Duration
Starting	0.12 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.02 ms
Unlocking tables	0.03 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.03 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: 2.10 ms Na de laatste zoekopdracht: 0.85 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 4.799 MB Regels teruggegeven: 94

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

  FROM u5143d10207_extensions

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

  ORDER BY ordering

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	u5143d10207_extensions	ref	extension	extension	82	const	120	Using index condition; Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.13 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.06 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.03 ms
Creating sort index	1.05 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.03 ms
Starting cleanup	0.03 ms
Freeing items	0.08 ms
Updating status	0.04 ms
Reset for next command	0.03 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: 2.92 ms Na de laatste zoekopdracht: 52.48 ms Zoekopdracht geheugen: 0.010 MB geheugen voor zoekopdracht: 7.281 MB Regels teruggegeven: 146

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

  LEFT JOIN u5143d10207_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	ALL	idx_client_id_parent_id_alias_language	INDEX KEY ONTBREEKT	NULL	NULL	223	Using where; Gebruikt bestandssortering
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	u5143d10207_svleiderdorp.m.component_id	1	Using where

Profiel

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

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Zelfde als de call in onderstaande regel.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/jumirouter/jumirouter.php:36
8	plgSystemJumiRouter->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: 0.87 ms Na de laatste zoekopdracht: 20.69 ms Zoekopdracht geheugen: 0.006 MB geheugen voor zoekopdracht: 8.432 MB Regels teruggegeven: 2

select id, title, alias 
  from u5143d10207_jumi 
  where published = 1

Verklaren

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

Profiel

Status	Duration
Starting	0.22 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.06 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.04 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
12	JDatabaseDriver->loadRowList()	JROOT/plugins/system/jumirouter/jumirouter.php:57
11	parseJumiRouter()	Zelfde als de call in onderstaande regel.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.98 ms Na de laatste zoekopdracht: 0.29 ms Zoekopdracht geheugen: 0.006 MB geheugen voor zoekopdracht: 8.443 MB Regels teruggegeven: 11

SELECT id, home, template, s.params

  FROM u5143d10207_template_styles as s

  LEFT JOIN u5143d10207_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	14	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	u5143d10207_svleiderdorp.s.template,const	1	Using index condition; Using where

Profiel

Status	Duration
Starting	0.11 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.18 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.04 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/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:348
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
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.95 ms Na de laatste zoekopdracht: 5.15 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 8.726 MB Regels teruggegeven: 1

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

  FROM `u5143d10207_extensions`

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

Verklaren

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

Profiel

Status	Duration
Starting	0.20 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.06 ms
Executing	0.02 ms
Sending data	0.06 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.02 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

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

UPDATE `u5143d10207_extensions`

  SET `params` = '{\"mediaversion\":\"8a9f157539946b03a99ed191009577a7\"}'

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

Verklaren

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

Profiel

Status	Duration
Starting	0.09 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 for update	0.08 ms
Updating	0.10 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.02 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	1.75 ms
Closing tables	0.04 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.08 ms
Updating status	0.04 ms
Reset for next command	0.03 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:1137
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: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.93 ms Na de laatste zoekopdracht: 3.23 ms Zoekopdracht geheugen: 0.003 MB geheugen voor zoekopdracht: 8.902 MB Regels teruggegeven: 2

SELECT *

  FROM u5143d10207_languages

  WHERE published=1

  ORDER BY ordering ASC

Verklaren

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

Profiel

Status	Duration
Starting	0.16 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.06 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.10 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.03 ms
Reset for next command	0.03 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: 1.41 ms Na de laatste zoekopdracht: 15.11 ms Zoekopdracht geheugen: 0.010 MB geheugen voor zoekopdracht: 9.626 MB Regels teruggegeven: 41

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

  FROM `u5143d10207_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_flexicontact','com_installer','com_jaextmanager','com_jevents','com_joomlaupdate','com_jumi','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_scheduler','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	u5143d10207_assets	range	idx_asset_name	idx_asset_name	202	NULL	42	Using index condition

Profiel

Status	Duration
Starting	0.23 ms
Checking permissions	0.03 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.03 ms
Statistics	0.17 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.41 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.04 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:45
13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->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: 4.29 ms Na de laatste zoekopdracht: 1.97 ms Zoekopdracht geheugen: 0.008 MB geheugen voor zoekopdracht: 9.829 MB Regels teruggegeven: 7

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 u5143d10207_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-27 05:07:07') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-27 05:07:07')

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref\|filter	idx_access,idx_state,idx_catid,idx_featured_catid	idx_state\|idx_featured_catid	1\|1	const	103 (37%)	Using where; Using temporary; Gebruikt bestandssortering; Using rowid filter
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	u5143d10207_svleiderdorp.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	u5143d10207_svleiderdorp.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	u5143d10207_svleiderdorp.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	u5143d10207_svleiderdorp.c.parent_id	1	Using where
1	SIMPLE	v	ALL	PRIMARY	INDEX KEY ONTBREEKT	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

Profiel

Status	Duration
Starting	0.28 ms
Checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.11 ms
Optimizing	0.06 ms
Statistics	0.17 ms
Preparing	0.07 ms
Creating tmp table	0.11 ms
Sorting result	0.05 ms
Executing	0.02 ms
Sending data	1.88 ms
Creating sort index	0.27 ms
Removing tmp table	0.69 ms
Creating sort index	0.04 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.02 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.10 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->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.97 ms Na de laatste zoekopdracht: 2.85 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 10.119 MB Regels teruggegeven: 0

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

  FROM `u5143d10207_contentitem_tag_map` AS m 

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

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

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

Profiel

Status	Duration
Starting	0.18 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.03 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.06 ms
Executing	0.02 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.03 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.04 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->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.75 ms Na de laatste zoekopdracht: 0.21 ms Zoekopdracht geheugen: 0.008 MB geheugen voor zoekopdracht: 10.137 MB Regels teruggegeven: 0

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

  FROM `u5143d10207_contentitem_tag_map` AS m 

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

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

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

Profiel

Status	Duration
Starting	0.10 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.03 ms
Statistics	0.07 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.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->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.73 ms Na de laatste zoekopdracht: 0.15 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 10.155 MB Regels teruggegeven: 0

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

  FROM `u5143d10207_contentitem_tag_map` AS m 

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

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

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

Profiel

Status	Duration
Starting	0.09 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.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 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.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->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.72 ms Na de laatste zoekopdracht: 0.15 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 10.171 MB Regels teruggegeven: 0

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

  FROM `u5143d10207_contentitem_tag_map` AS m 

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

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

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

Profiel

Status	Duration
Starting	0.09 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.03 ms
Statistics	0.06 ms
Preparing	0.03 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.02 ms
Starting cleanup	0.03 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->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.73 ms Na de laatste zoekopdracht: 0.15 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 10.188 MB Regels teruggegeven: 0

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

  FROM `u5143d10207_contentitem_tag_map` AS m 

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

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

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

Profiel

Status	Duration
Starting	0.09 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.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.06 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.03 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->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.70 ms Na de laatste zoekopdracht: 0.15 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 10.205 MB Regels teruggegeven: 0

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

  FROM `u5143d10207_contentitem_tag_map` AS m 

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

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

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

Profiel

Status	Duration
Starting	0.09 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.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.04 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.03 ms
Reset for next command	0.02 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->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.69 ms Na de laatste zoekopdracht: 0.15 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 10.222 MB Regels teruggegeven: 0

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

  FROM `u5143d10207_contentitem_tag_map` AS m 

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

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

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

Profiel

Status	Duration
Starting	0.10 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.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.04 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.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->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.49 ms Na de laatste zoekopdracht: 1.69 ms Zoekopdracht geheugen: 0.007 MB geheugen voor zoekopdracht: 10.325 MB Regels teruggegeven: 1

SELECT COUNT(*)

  FROM u5143d10207_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-27 05:07:07') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-27 05:07:07')

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref\|filter	idx_access,idx_state,idx_catid,idx_featured_catid	idx_state\|idx_featured_catid	1\|1	const	103 (37%)	Using where; Using rowid filter
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	u5143d10207_svleiderdorp.a.catid	1	Using where

Profiel

Status	Duration
Starting	0.14 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.05 ms
Optimizing	0.05 ms
Statistics	0.15 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.06 ms
Executing	0.02 ms
Sending data	0.50 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.08 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
10	ContentViewFeatured->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.04 ms Na de laatste zoekopdracht: 31.26 ms Zoekopdracht geheugen: 0.010 MB geheugen voor zoekopdracht: 11.500 MB Regels teruggegeven: 11

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 `u5143d10207_categories` AS `s`

  INNER JOIN `u5143d10207_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) 
  AND c.published = 1 
  AND s.id = 33

  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	12 (26%)	Using index condition; Using where; Using rowid filter

Profiel

Status	Duration
Starting	0.37 ms
Checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.11 ms
Optimizing	0.07 ms
Statistics	0.28 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.07 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.34 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.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.09 ms
Updating status	0.04 ms
Reset for next command	0.03 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/featured/view.html.php:102
10	ContentViewFeatured->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: 6.46 ms Na de laatste zoekopdracht: 0.95 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 11.589 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 u5143d10207_fields AS a

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

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

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

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

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

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

Profiel

Status	Duration
Starting	0.23 ms
Checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.06 ms
Creating tmp table	0.08 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	4.85 ms
Creating sort index	0.13 ms
Removing tmp table	0.13 ms
Creating sort index	0.05 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.03 ms
Closing tables	0.06 ms
Starting cleanup	0.03 ms
Freeing items	0.11 ms
Updating status	0.05 ms
Reset for next command	0.03 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/featured/view.html.php:102
10	ContentViewFeatured->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.64 ms Na de laatste zoekopdracht: 6.53 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 11.952 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 u5143d10207_fields AS a

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

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

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

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

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

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

Profiel

Status	Duration
Starting	0.44 ms
Checking permissions	0.03 ms
Opening tables	0.11 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.12 ms
Optimizing	0.10 ms
Statistics	0.24 ms
Preparing	0.10 ms
Creating tmp table	0.12 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	0.51 ms
Creating sort index	0.07 ms
Removing tmp table	0.12 ms
Creating sort index	0.04 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.04 ms
Starting cleanup	0.03 ms
Freeing items	0.09 ms
Updating status	0.03 ms
Reset for next command	0.03 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/featured/view.html.php:102
10	ContentViewFeatured->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.42 ms Na de laatste zoekopdracht: 81.20 ms Zoekopdracht geheugen: 0.010 MB geheugen voor zoekopdracht: 13.140 MB Regels teruggegeven: 19

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

  FROM u5143d10207_modules AS m

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

  LEFT JOIN u5143d10207_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-09-27 05:07:07') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-27 05:07:07') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 191 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	36	Using index condition; Using where; Gebruikt bestandssortering
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	u5143d10207_svleiderdorp.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	u5143d10207_svleiderdorp.m.module,const	1	Using index condition; Using where

Profiel

Status	Duration
Starting	0.31 ms
Checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.08 ms
Optimizing	0.09 ms
Statistics	0.16 ms
Preparing	0.11 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.98 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.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.09 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	Zelfde als de call in onderstaande regel.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:441
16	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:371
15	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:87
14	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:653
12	T3Template->countModules()	JROOT/templates/purity_iii/tpls/blocks/header.php:62
11	include JROOT/templates/purity_iii/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:200
10	T3Template->loadBlock()	JROOT/templates/purity_iii/tpls/default-content-left.php:37
9	include JROOT/templates/purity_iii/tpls/default-content-left.php	JROOT/plugins/system/t3/includes/core/template.php:226
8	T3Template->loadLayout()	JROOT/templates/purity_iii/index.php:35
7	require JROOT/templates/purity_iii/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: 3.09 ms Na de laatste zoekopdracht: 27.49 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 13.322 MB Regels teruggegeven: 3

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 `u5143d10207_content` AS `i`

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

  FROM `u5143d10207_categories` AS `s`

  INNER JOIN `u5143d10207_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) 
  AND c.published = 1 
  AND s.id = 50

  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\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	11 (26%)	Using index condition; Using where; Using rowid filter
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	u5143d10207_svleiderdorp.c.id	8	Using index condition; Using where

Profiel

Status	Duration
Starting	0.42 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.03 ms
Init	0.13 ms
Optimizing	0.07 ms
Statistics	0.28 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.07 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.07 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.19 ms
Executing	0.03 ms
Sending data	0.08 ms
Executing	0.03 ms
Sending data	0.50 ms
Executing	0.03 ms
Sending data	0.17 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.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Removing tmp table	0.03 ms
Freeing items	0.09 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
18	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
17	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/categories.php:115
16	ContentModelCategories->getItems()	JROOT/modules/mod_articles_category/helper.php:142
15	ModArticlesCategoryHelper::getList()	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/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:566
12	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
11	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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.16 ms Na de laatste zoekopdracht: 0.48 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 13.344 MB Regels teruggegeven: 0

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 u5143d10207_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (50) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-27 05:07:07') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-27 05:07:07') 
  AND a.created >= DATE_ADD('2023-09-27 05:07:07', INTERVAL -30 DAY)

  ORDER BY a.created DESC 
  LIMIT 2

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	4	Using intersect(idx_catid,idx_state); Using where; Gebruikt bestandssortering
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	u5143d10207_svleiderdorp.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	u5143d10207_svleiderdorp.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	u5143d10207_svleiderdorp.a.id	1	Using where

Profiel

Status	Duration
Starting	0.37 ms
Checking permissions	0.03 ms
Opening tables	0.09 ms
After opening tables	0.03 ms
System lock	0.04 ms
Table lock	0.03 ms
Init	0.14 ms
Optimizing	0.08 ms
Statistics	0.20 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.11 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.06 ms
Creating sort index	0.31 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.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.09 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
16	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:224
15	ModArticlesCategoryHelper::getList()	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/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:566
12	Joomla\CMS\Helper\_ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
11	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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: 1.79 ms Na de laatste zoekopdracht: 333.52 ms Zoekopdracht geheugen: 0.011 MB geheugen voor zoekopdracht: 16.848 MB Regels teruggegeven: 18

SHOW FULL COLUMNS 
  FROM `u5143d10207_jev_users`

Verklaren

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

Profiel

Status	Duration
Starting	0.18 ms
Checking permissions	0.03 ms
Closing tables	0.02 ms
Opening tables	0.39 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Filling schema table	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.12 ms
Closing tables	0.04 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.15 ms
Closing tables	0.03 ms
Unlocking tables	0.03 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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
21	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
20	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1616
19	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1471
18	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:61
17	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
16	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
15	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1297
14	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634
13	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
12	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
11	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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: 1.95 ms Na de laatste zoekopdracht: 4.16 ms Zoekopdracht geheugen: 0.011 MB geheugen voor zoekopdracht: 16.975 MB Regels teruggegeven: 17

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 `u5143d10207_categories` AS `c`

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1

  ORDER BY c.lft

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	cat_idx,idx_access	cat_idx	207	NULL	17	Using index condition; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.33 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.10 ms
Optimizing	0.06 ms
Statistics	0.14 ms
Preparing	0.06 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.05 ms
Creating sort index	0.46 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.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.09 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
21	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
20	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:411
19	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1020
18	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
17	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
16	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
15	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1297
14	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634
13	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
12	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
11	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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: 1.51 ms Na de laatste zoekopdracht: 0.66 ms Zoekopdracht geheugen: 0.010 MB geheugen voor zoekopdracht: 17.071 MB Regels teruggegeven: 4

SELECT c.id

  FROM u5143d10207_categories AS c

  WHERE c.access   IN (1,1)
 
  AND c.published = 1
  
  AND c.language in ('nl-NL','*')
 
  AND c.extension = 'com_jevents'
 
  AND ((c.lft>=104 
  AND c.rgt<=111 ) OR (c.lft>=105 
  AND c.rgt<=106 ) OR (c.lft>=107 
  AND c.rgt<=108 ) OR (c.lft>=109 
  AND c.rgt<=110 ))

  ORDER BY c.lft asc

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	cat_idx,idx_access,idx_left_right,idx_language	cat_idx	203	const,const	16	Using index condition; Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.17 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.06 ms
Optimizing	0.06 ms
Statistics	0.20 ms
Preparing	0.08 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.26 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.03 ms
Starting cleanup	0.03 ms
Freeing items	0.09 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
20	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:547
19	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1020
18	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
17	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
16	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
15	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1297
14	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634
13	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
12	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
11	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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: 1.38 ms Na de laatste zoekopdracht: 1.55 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 17.104 MB Regels teruggegeven: 16

SELECT c.id

  FROM u5143d10207_categories AS c

  WHERE c.access   IN (1,1)
 
  AND c.published = 1
  
  AND c.language in ('nl-NL','*')
 
  AND c.extension = 'com_jevents'
 

  ORDER BY c.lft asc

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	cat_idx,idx_access,idx_language	cat_idx	203	const,const	16	Using index condition; Using where; Gebruikt bestandssortering

Profiel

Status	Duration
Starting	0.16 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.06 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.26 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.03 ms
Starting cleanup	0.03 ms
Freeing items	0.08 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:547
15	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:1342
14	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634
13	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
12	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
11	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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.68 ms Na de laatste zoekopdracht: 0.61 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 17.140 MB Regels teruggegeven: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM u5143d10207_jevents_repetition as rpt
 
  INNER JOIN u5143d10207_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN u5143d10207_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN u5143d10207_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN u5143d10207_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,32,39,40,42,43,44,45,49,51,52,53,54,41,56,57,58)
 
  AND rpt.endrepeat >= '2023-09-27 07:07:08' 
  AND rpt.startrepeat <= '2023-10-27 23:59:59'
 
  AND (rpt.startrepeat >= '2023-09-27 07:07:08' OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
						
						
  ORDER BY rpt.startrepeat ASC 
  LIMIT 4

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	5	NULL	1	Using index condition; Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	u5143d10207_svleiderdorp.rpt.eventid	1	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	u5143d10207_svleiderdorp.ev.icsid	1	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	u5143d10207_svleiderdorp.rpt.eventid	1
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	u5143d10207_svleiderdorp.rpt.eventdetail_id	1	Using where

Profiel

Status	Duration
Starting	0.29 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.03 ms
Init	0.16 ms
Optimizing	0.08 ms
Statistics	0.25 ms
Preparing	0.09 ms
Creating tmp table	0.16 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	0.64 ms
Creating sort index	0.06 ms
Removing tmp table	0.12 ms
Creating sort index	0.03 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.03 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.10 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:3274
16	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
15	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1910
14	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634
13	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
12	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
11	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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: 1.79 ms Na de laatste zoekopdracht: 0.23 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 17.149 MB Regels teruggegeven: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM u5143d10207_jevents_repetition as rpt
 
  INNER JOIN u5143d10207_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN u5143d10207_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN u5143d10207_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN u5143d10207_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,32,39,40,42,43,44,45,49,51,52,53,54,41,56,57,58)
 
  AND rpt.endrepeat >= '2023-09-27 07:07:08' 
  AND rpt.startrepeat <= '2023-09-27 07:07:08'
 
  AND (rpt.startrepeat <= '2023-09-27 07:07:08' OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
							
  ORDER BY rpt.startrepeat asc 
  LIMIT 4

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	5	NULL	1	Using index condition; Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	u5143d10207_svleiderdorp.rpt.eventid	1	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	u5143d10207_svleiderdorp.ev.icsid	1	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	u5143d10207_svleiderdorp.rpt.eventid	1
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	u5143d10207_svleiderdorp.rpt.eventdetail_id	1	Using where

Profiel

Status	Duration
Starting	0.20 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.04 ms
Init	0.08 ms
Optimizing	0.05 ms
Statistics	0.15 ms
Preparing	0.06 ms
Creating tmp table	0.09 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.40 ms
Creating sort index	0.06 ms
Removing tmp table	0.10 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.03 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.07 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:3274
16	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
15	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:2025
14	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634
13	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
12	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
11	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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]

24 zoekopdrachttypes gelogd, gesorteerd op weergave

SELECTEER Tabellen:

7 × SELECT `m`.`tag_id`,`t`.* 
  FROM `u5143d10207_contentitem_tag_map` AS m  
  INNER JOIN `u5143d10207_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

2 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
  FROM u5143d10207_jevents_repetition as rpt  
  INNER JOIN u5143d10207_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN u5143d10207_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN u5143d10207_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN u5143d10207_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

2 × 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 u5143d10207_content AS a 
  LEFT JOIN u5143d10207_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN u5143d10207_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN u5143d10207_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN u5143d10207_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN u5143d10207_content_rating AS v 
  ON a.id = v.content_id

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

2 × SELECT c.id 
  FROM u5143d10207_categories AS c

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 u5143d10207_fields AS a 
  LEFT JOIN `u5143d10207_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN u5143d10207_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN u5143d10207_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN u5143d10207_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN u5143d10207_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `u5143d10207_fields_categories` AS fc 
  ON fc.field_id = a.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 `u5143d10207_categories` AS `c`

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 `u5143d10207_content` AS `i`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM u5143d10207_modules AS m 
  LEFT JOIN u5143d10207_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN u5143d10207_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 `u5143d10207_categories` AS `s` 
  INNER JOIN `u5143d10207_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 COUNT(*) 
  FROM u5143d10207_content AS a 
  LEFT JOIN u5143d10207_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN u5143d10207_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN u5143d10207_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN u5143d10207_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN u5143d10207_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `data` 
  FROM `u5143d10207_session`

1 × SELECT `session_id` 
  FROM `u5143d10207_session`

1 × SELECT * 
  FROM u5143d10207_languages

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

1 × select id, title, alias 
  from u5143d10207_jumi

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 u5143d10207_menu AS m 
  LEFT JOIN u5143d10207_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 u5143d10207_extensions

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

1 × SELECT id, rules 
  FROM `u5143d10207_viewlevels

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `u5143d10207_assets`

ANDERE Tabellen:

1 × INSERT INTO `u5143d10207_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3934366233313362663335633536343434386333363066666666333331323062', 1, 1695791227, 0, '', 0

1 × UPDATE `u5143d10207_extensions` 
  SET `params` = '{\"mediaversion\":\"8a9f157539946b03a99ed191009577a7\"}'

1 × SHOW FULL COLUMNS 
  FROM `u5143d10207_jev_users