Home

Handige links

Kalender

wo okt 24, 2018 @18:45 - 20:00
Jeugd geen speelavond ivm herfstvakantie

wo okt 24, 2018 @20:00 - 22:30
Senioren Speelavond

wo okt 31, 2018 @18:45 - 20:00
Jeugd

wo okt 31, 2018 @20:00 - 22:30
Senioren Speelavond

wo nov 07, 2018 @20:00 - 22:30
Senioren Speelavond

wo nov 14, 2018 @20:00 - 22:30
Senioren Speelavond

wo nov 21, 2018 @20:00 - 22:30
Senioren Speelavond

wo nov 28, 2018 @20:00 - 22:30
Senioren Speelavond

wo dec 05, 2018 @20:00 - 22:30
Senioren Speelavond

wo dec 12, 2018 @20:00 - 22:30
Senioren Speelavond

Paaseieren-verkoopactie BC Raak'm - Van inzet tot afzet

Door Geert Leijstra
Woensdag 22-03-2017 17:00-20:00
Twee weken geleden werd er door een ijverige ploeg de paaseieren ingepakt. Een week eerder dan aanvankelijk gepland, want vorige week was de kantine ingericht tot stembureau; dus bezet. Voor de verkoop zaten Tjitte en Anneke aan de controle tafel. Sikke had de tassen klaargezet. De routes lagen klaar. Het mooie weer lag er ook. Er waren wel minder jeugdleden. Maar toch ging de verkoop aardig goed. Er werd een beroep gedaan op de senioren. Dat had wel geholpen. Social media stond vol over deze actie. Saskia verkocht al via Facebook. Voor de verkopers stond er na het verkopen patat en ranja klaar. Voor zonsondergang was er ook al veel verkocht. Saskia zou in het winkelcentrum de rest verkopen. Ik verkocht een tas vol op het werk. Zoals Sander en Paul. 23 maart waren ze nagenoeg uitverkocht. Er is dus niks meer b(ei.)

Gegevens: Gepubliceerd: 09 april 2017

Ons oudste en jongste lid bij de senioren

BC Raak'm is een club met een grote groep fanatieke badmintonners in de leeftijd van 8 tot 81 jaar.
Vanaf 16 jaar mag je meespelen met de senioren. Leuk om te zien dat er zo'n verschil in leeftijd is maar dat iedereen op zijn of haar niveau prima mee kan doen bij onze club.
Deze keer zetten we Sido 18 jaar en Bob 81 jaar samen op de foto. Ons jongste en oudste lid bij de senioren.

Gegevens: Gepubliceerd: 01 april 2017

Agenda april 2017

In de laatste maand van ons seizoen staan er nog een tal van activiteiten gepland, pak de agenda er maar bij!

19 april laatste speelavond jeugd (jeugdtoernooi samen met de jeugd van Akkrum)
26 april laatste speelavond senioren, slottoernooi samen met Akkrum (toernooi wordt in 2 avonden gespeeld) Opgeven voor 19 april!!
27 april slottoernooi Akkrum
10 juni uitje senioren

Gegevens: Gepubliceerd: 06 maart 2017

DPC Leeuwarden 2017

Op zaterdag 4 maart werd het jaarlijkse DPC (drie provinciën circuit) gehouden in Leeuwarden. Vier leden van BC Raak'm deden aan dit toernooi mee.
Sophie en Elise speelden singels en dubbels U15, mooie wedstrijden werden er gespeeld maar ze zijn net niet tot de prijzen doorgedrongen.
Avanya en Inger speelden U11/U13 en in de singel wist Inger een gedeelde 3e/4e plaats te behalen en samen wonnen ze in de meisjes dubbel de 2e prijs. Gefeliciteerd!

Gegevens: Gepubliceerd: 06 maart 2017

Het BC Raak'm Pakjestoernooi

Geschreven door Geert Leijstra
Woensdag 15-02-2017 20:30-21:40
Heerlijk avondje was gekomen, het toernooi dat door Peter Post en Jikkemien was bedacht, was het compleet vernieuwde Sint Pitertoernooi. Nu kregen we het niet cadeau, maar moest er om de cadeautjes gestreden worden. Het laatst gekozen cadeautje is het cadeautje voor de deelnemer. Iedereen moest zelf een cadeau meebrengen. Wie dat vergeten was, moest een racketgrip aanschaffen en inzetten als cadeautje. Het werd een gezellig badmintontoernooi. Ook was de zaal versierd. Baannummer-surprises bijvoorbeeld. Er werd twee tegen twee gespeeld. In de eerste ronde werd het pakje meegenomen en naast de baan gelegd. De twee winnaars mochten als eerste een pakje uitkiezen. De twee verliezers kozen de laatste 2 pakjes. Er zouden 4 rondes van 20 minuten gespeeld worden. Dat werd ingekort tot 3 rondes. Dan duurde het wat langer dan een uur. Het laatst gekozen pakje mocht in de kantine uitgepakt worden. Zo wisten we wat er al die tijd in de pakjes schuil ging. De cadeaus konden ook nog van anderen worden bewonderd. Van Sint Peter kreeg elke deelnemer nog een chocoladeletter. Het was een onvergetelijk mooi Sint Pitertoernooi.

BCRaakm150220170008

BCRaakm150220170009 BCRaakm150220170010

BCRaakm150220170011
Paul is heel blij met zijn Sint Piter cadeau, 1/5 staatslot!! Succes bij de trekking Paul!

JEUGD
Ook de jeugd speelden wedstrijdjes met als inzet heel veel Sint Piter snoep. De kinderen werden in twee groepen ingedeeld en de winnaars mochten als eerste iets uitzoeken, ook hier moest het cadeautje weer ingezet worden en pas na de vierde wedstrijd mocht iedereen zijn gewonnen cadeautje houden en opeten. In de kantine kreeg iedereen limonade en werd er nog even gezellig nagezeten en natuurlijk het gewonnen snoep opeten!
SLK

BCRaakm150220170004 BCRaakm150220170005 BCRaakm150220170006 BCRaakm150220170007 BCRaakm150220170003

Gegevens: Gepubliceerd: 16 februari 2017

Start
Vorige
2
3
4
5
6
7
8
9
10
11
Volgende
Einde

Joomla! Foutopsporingsconsole

Sessie

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1540213654,
                "last": 1540213654,
                "now": 1540213654
            },
            "token": "2wRyzQqJ6FGY8Futv44Uf4sRCcvy0iCy"
        },
        "registry": {
            "jevents": {
                "moduleid89": {
                    "shownEventIds": [
                        [
                            "112",
                            "1392",
                            "1401",
                            "1393",
                            "1394",
                            "1395",
                            "1396",
                            "1397",
                            "1398",
                            "1399"
                        ]
                    ],
                    "page": 0,
                    "firstEventDate": "2018-10-24 18:45:00",
                    "lastEventDate": "2018-12-12 20:00:00"
                }
            },
            "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
        }
    }
}

Profielinformatie

Tijd

Geheugen

Tijd: 9.99 ms / 9.99 ms Geheugen: 0.553 MB / 0.90 MB Application: afterLoad

Tijd: 64.54 ms / 74.53 ms Geheugen: 1.209 MB / 2.10 MB Application: afterInitialise

Tijd: 17.72 ms / 92.26 ms Geheugen: 0.616 MB / 2.72 MB Application: afterRoute

Tijd: 2.07 ms / 94.32 ms Geheugen: 0.041 MB / 2.76 MB Application: beforeRenderComponent com_content

Tijd: 9.99 ms / 104.31 ms Geheugen: 0.136 MB / 2.90 MB Application: Before Access::preloadComponents (all components)

Tijd: 0.51 ms / 104.82 ms Geheugen: 0.061 MB / 2.96 MB Application: After Access::preloadComponents (all components)

Tijd: 0.04 ms / 104.87 ms Geheugen: 0.000 MB / 2.96 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tijd: 0.53 ms / 105.40 ms Geheugen: 0.009 MB / 2.97 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tijd: 46.05 ms / 151.45 ms Geheugen: 0.502 MB / 3.47 MB Application: afterRenderComponent com_content

Tijd: 2.62 ms / 154.07 ms Geheugen: 0.023 MB / 3.49 MB Application: afterDispatch

Tijd: 5.55 ms / 159.62 ms Geheugen: 0.056 MB / 3.55 MB Application: beforeRenderModule mod_banners (Advertenties_right)

Tijd: 10.30 ms / 169.93 ms Geheugen: 0.062 MB / 3.61 MB Application: afterRenderModule mod_banners (Advertenties_right)

Tijd: 0.12 ms / 170.05 ms Geheugen: 0.000 MB / 3.60 MB Application: beforeRenderModule mod_menu (Handige links)

Tijd: 2.24 ms / 172.29 ms Geheugen: 0.030 MB / 3.63 MB Application: afterRenderModule mod_menu (Handige links)

Tijd: 0.06 ms / 172.35 ms Geheugen: 0.001 MB / 3.63 MB Application: beforeRenderModule mod_jevents_latest (Kalender)

Tijd: 6.65 ms / 179.00 ms Geheugen: 0.175 MB / 3.80 MB Application: Before Access::getAssetRules (id:416 name:com_jevents)

Tijd: 0.06 ms / 179.05 ms Geheugen: 0.007 MB / 3.81 MB Application: After Access::getAssetRules (id:416 name:com_jevents)

Tijd: 22.09 ms / 201.14 ms Geheugen: 0.644 MB / 4.45 MB Application: afterRenderModule mod_jevents_latest (Kalender)

Tijd: 0.09 ms / 201.23 ms Geheugen: 0.000 MB / 4.31 MB Application: beforeRenderModule mod_banners (Advertenties_left)

Tijd: 47.43 ms / 248.66 ms Geheugen: 0.076 MB / 4.38 MB Application: afterRenderModule mod_banners (Advertenties_left)

Tijd: 0.14 ms / 248.79 ms Geheugen: 0.000 MB / 4.37 MB Application: beforeRenderModule mod_menu (Topmenu)

Tijd: 23.45 ms / 272.24 ms Geheugen: 0.591 MB / 4.96 MB Application: afterRenderModule mod_menu (Topmenu)

Tijd: 0.10 ms / 272.34 ms Geheugen: 0.000 MB / 4.96 MB Application: beforeRenderModule mod_menu (mnuSocial)

Tijd: 0.90 ms / 273.24 ms Geheugen: 0.010 MB / 4.97 MB Application: afterRenderModule mod_menu (mnuSocial)

Tijd: 1.53 ms / 274.76 ms Geheugen: 0.046 MB / 5.02 MB Application: Before Access::getAssetRules (id:431 name:com_categories)

Tijd: 0.07 ms / 274.83 ms Geheugen: 0.007 MB / 5.03 MB Application: After Access::getAssetRules (id:431 name:com_categories)

Tijd: 1.76 ms / 276.60 ms Geheugen: 0.064 MB / 5.09 MB Application: afterRender

Totaal aantal database zoekopdrachten: 101.28 ms

Geheugengebruik

Database zoekopdrachten

40 zoekopdrachten gelogd 101.28 ms

2 identieke gevonden!

2 identieke: #25 #35

Tijd zoekopdracht: 0.56 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 1.169 MB Regels teruggegeven: 0

SELECT `data`

  FROM `gwbmp_session`

  WHERE `session_id` = 'pjl0l05lfie42cgn72g6eoqkk3'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gwbmp_session	const	PRIMARY	PRIMARY	766	const	1

Profiel

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.11 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Zelfde als de call in onderstaande regel.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:755
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.45 ms Na de laatste zoekopdracht: 1.03 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 1.187 MB Regels teruggegeven: 0

SELECT `session_id`

  FROM `gwbmp_session`

  WHERE `session_id` = 'pjl0l05lfie42cgn72g6eoqkk3' 
  LIMIT 1

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.09 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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: 10.12 ms Na de laatste zoekopdracht: 2.18 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 1.194 MB

INSERT INTO `gwbmp_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('pjl0l05lfie42cgn72g6eoqkk3', 1, '1540213654', 0, '', 0)

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO `gwbmp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('pjl0l05lfie42cgn72g6eoqkk3', 1, '1540213654', 0, '', 0)

Profiel

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
update	0.12 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.01 ms
query end	9.63 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.26 ms Na de laatste zoekopdracht: 2.73 ms Zoekopdracht geheugen: 0.038 MB geheugen voor zoekopdracht: 1.295 MB Regels teruggegeven: 36

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

  FROM `gwbmp_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	gwbmp_extensions	ref	extension	extension	82	const	39	Using index condition; Using where

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:425
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:433
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:499
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:596
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:195
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.24 ms Na de laatste zoekopdracht: 2.05 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 1.338 MB Regels teruggegeven: 5

SELECT id, rules

  FROM `gwbmp_viewlevels`

Verklaren

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

Profiel

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.03 ms
checking permissions	0.02 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
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:195
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.21 ms Na de laatste zoekopdracht: 0.16 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 1.353 MB Regels teruggegeven: 2

SELECT b.id

  FROM gwbmp_usergroups AS a

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

  WHERE a.id = 8

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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
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:195
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.27 ms Na de laatste zoekopdracht: 0.40 ms Zoekopdracht geheugen: 0.038 MB geheugen voor zoekopdracht: 1.377 MB Regels teruggegeven: 87

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

  FROM gwbmp_extensions

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

  ORDER BY ordering

Verklaren

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

Profiel

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Zelfde als de call in onderstaande regel.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
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:195
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.19 ms Na de laatste zoekopdracht: 7.64 ms Zoekopdracht geheugen: 0.037 MB geheugen voor zoekopdracht: 1.656 MB Regels teruggegeven: 1

SELECT `value`

  FROM `gwbmp_admintools_storage`

  WHERE `key` = 'cparams'

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gwbmp_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:118
11	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:48
10	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
9	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:270
8	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.18 ms Na de laatste zoekopdracht: 2.69 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 1.773 MB Regels teruggegeven: 0

SELECT *

  FROM `gwbmp_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:555
9	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:469
8	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:99
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.36 ms Na de laatste zoekopdracht: 19.54 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 2.002 MB Regels teruggegeven: 1

SHOW VARIABLES LIKE "collation_database"

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: SHOW VARIABLES LIKE "collation_database"

Profiel

Status	Duration
starting	0.06 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.85 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:338
11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:714
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:127
8	plgSystemAdmintools->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.15 ms Na de laatste zoekopdracht: 0.31 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 2.013 MB Regels teruggegeven: 0

SELECT *

  FROM `gwbmp_admintools_ipautoban`

  WHERE `ip` = '54.162.118.107'

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:32
10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:714
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:127
8	plgSystemAdmintools->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.24 ms Na de laatste zoekopdracht: 0.17 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 2.023 MB Regels teruggegeven: 0

SELECT *

  FROM `gwbmp_admintools_wafblacklists`

  WHERE `verb` IN('','GET') 
  AND `option` IN('') 
  AND `view` IN('') 
  AND `task` IN('')

  GROUP BY `query`

  ORDER BY `query` ASC

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:66
10	AtsystemFeatureWafblacklist->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:714
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:127
8	plgSystemAdmintools->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.50 ms Na de laatste zoekopdracht: 0.63 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 2.033 MB Regels teruggegeven: 0

SELECT `source`,`keepurlparams`

  FROM `gwbmp_admintools_redirects`

  WHERE ((`dest` = '') OR (`dest` = '?start=30') OR ('?start=30' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1763
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:714
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:127
8	plgSystemAdmintools->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.32 ms Na de laatste zoekopdracht: 2.16 ms Zoekopdracht geheugen: 0.139 MB geheugen voor zoekopdracht: 2.134 MB Regels teruggegeven: 104

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

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

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

  ORDER BY m.lft

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.07 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Zelfde als de call in onderstaande regel.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:488
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1070
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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.15 ms Na de laatste zoekopdracht: 7.70 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 2.700 MB Regels teruggegeven: 1

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

  FROM `gwbmp_extensions`

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

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Zelfde als de call in onderstaande regel.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cssconfig/cssconfig.php:53
8	plgSystemCSSConfig->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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.76 ms Na de laatste zoekopdracht: 0.20 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 2.696 MB

UPDATE `gwbmp_extensions`

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

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

Verklaren

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

Profiel

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.13 ms
updating	0.11 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.09 ms
query end	6.14 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cssconfig/cssconfig.php:53
8	plgSystemCSSConfig->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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.25 ms Na de laatste zoekopdracht: 1.17 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 2.740 MB Regels teruggegeven: 1

SELECT *

  FROM gwbmp_languages

  WHERE published=1

  ORDER BY ordering ASC

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
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:195
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.81 ms Na de laatste zoekopdracht: 0.34 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 2.755 MB Regels teruggegeven: 3

SELECT id, home, template, s.params

  FROM gwbmp_template_styles as s

  LEFT JOIN gwbmp_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	INDEX KEY ONTBREEKT	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.09 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
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.21 ms Na de laatste zoekopdracht: 10.57 ms Zoekopdracht geheugen: 0.036 MB geheugen voor zoekopdracht: 2.902 MB Regels teruggegeven: 37

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

  FROM `gwbmp_assets`

  WHERE `name` IN ('root.1','com_aclmanager','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_content','com_contenthistory','com_cpanel','com_fields','com_installer','com_jce','com_jevents','com_jnews','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','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	gwbmp_assets	range	idx_asset_name	idx_asset_name	202	NULL	37	Using index condition

Profiel

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.03 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
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:113
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:54
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 11.44 ms Na de laatste zoekopdracht: 2.33 ms Zoekopdracht geheugen: 0.045 MB geheugen voor zoekopdracht: 3.000 MB Regels teruggegeven: 5

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

  FROM gwbmp_content AS a

  INNER JOIN gwbmp_content_frontpage AS fp 
  ON fp.content_id = a.id

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

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

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

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

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

  WHERE a.access IN (1,1,2,3,6) 
  AND c.access IN (1,1,2,3,6) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-22 13:07:34') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-22 13:07:34')

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	PRIMARY,idx_access	INDEX KEY ONTBREEKT	NULL	NULL	58	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_state,idx_catid	idx_catid	4	db10237_bcraakm.c.id	3	Using index condition; Using where
1	SIMPLE	fp	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.id	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.id	1	Using where

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.30 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Waiting for query cache lock	0.09 ms
init	0.11 ms
optimizing	0.05 ms
statistics	0.24 ms
preparing	0.14 ms
executing	0.01 ms
Creating tmp table	0.50 ms
Copying to tmp table	7.78 ms
Sorting result	1.34 ms
Sending data	0.21 ms
end	0.01 ms
removing tmp table	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.82 ms Na de laatste zoekopdracht: 1.55 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 3.152 MB Regels teruggegeven: 1

SELECT COUNT(*)

  FROM gwbmp_content AS a

  INNER JOIN gwbmp_content_frontpage AS fp 
  ON fp.content_id = a.id

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

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

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

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

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

  WHERE a.access IN (1,1,2,3,6) 
  AND c.access IN (1,1,2,3,6) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-22 13:07:34') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-22 13:07:34')

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	PRIMARY,idx_access	INDEX KEY ONTBREEKT	NULL	NULL	58	Using where
1	SIMPLE	a	ref	PRIMARY,idx_access,idx_state,idx_catid	idx_catid	4	db10237_bcraakm.c.id	3	Using index condition; Using where
1	SIMPLE	fp	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.id	1	Using where; Using index

Profiel

Status	Duration
starting	0.26 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.08 ms
init	0.06 ms
optimizing	0.06 ms
statistics	0.16 ms
preparing	0.01 ms
Unlocking tables	0.07 ms
executing	0.01 ms
Sending data	2.44 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.20 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.20 ms Na de laatste zoekopdracht: 2.98 ms Zoekopdracht geheugen: 0.043 MB geheugen voor zoekopdracht: 3.261 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

  FROM `gwbmp_categories` AS `s`

  INNER JOIN `gwbmp_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,2,3,6) 
  AND c.published = 1 
  AND s.id = 47

  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	Gebruikt bestandssortering
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY ONTBREEKT	NULL	NULL	58	Using where

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
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:197
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
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:98
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.21 ms Na de laatste zoekopdracht: 0.44 ms Zoekopdracht geheugen: 0.041 MB geheugen voor zoekopdracht: 3.291 MB Regels teruggegeven: 0

SELECT 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 gwbmp_fields AS a

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

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

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

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

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

  LEFT JOIN `gwbmp_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)) 
  AND a.access IN (1,1,2,3,6) 
  AND (a.group_id = 0 OR g.access IN (1,1,2,3,6)) 
  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; Gebruikt bestandssortering
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	db10237_bcraakm.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.id	1	Using where; Using index

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.02 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
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:98
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.03 ms Na de laatste zoekopdracht: 29.68 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 3.541 MB Regels teruggegeven: 6

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

  FROM gwbmp_modules AS m

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

  LEFT JOIN gwbmp_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 <= '2018-10-22 13:07:34') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-10-22 13:07:34') 
  AND m.access IN (1,1,2,3,6) 
  AND m.client_id = 0 
  AND (mm.menuid = 2 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	ALL	PRIMARY,published,newsfeeds	INDEX KEY ONTBREEKT	NULL	NULL	34	Using where; Gebruikt bestandssortering
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	db10237_bcraakm.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db10237_bcraakm.m.id	6	Using where; Using index

Profiel

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.09 ms
Sending data	0.23 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

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

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

Tijd zoekopdracht: 0.41 ms Na de laatste zoekopdracht: 2.03 ms Zoekopdracht geheugen: 0.038 MB geheugen voor zoekopdracht: 3.570 MB Regels teruggegeven: 0

Identieke zoekopdrachten: #35

SELECT *

  FROM gwbmp_banners

  WHERE '2018-10-22 13:07:34' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.02 ms Na de laatste zoekopdracht: 0.50 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 3.589 MB Regels teruggegeven: 5

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

  FROM gwbmp_banners as a

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

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-22 13:07:34') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-22 13:07:34') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (34)

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	idx_state,idx_banner_catid	INDEX KEY ONTBREEKT	NULL	NULL	16	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.cid	1

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Creating tmp table	0.22 ms
Copying to tmp table	0.14 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.70 ms Na de laatste zoekopdracht: 0.16 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 3.615 MB

UPDATE gwbmp_banners

  SET impmade = (impmade + 1)

  WHERE id IN (6,10,1,4,8)

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: UPDATE gwbmp_banners SET impmade = (impmade + 1) WHERE id IN (6,10,1,4,8)

Profiel

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
updating	0.09 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	6.30 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:249
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.89 ms Na de laatste zoekopdracht: 13.41 ms Zoekopdracht geheugen: 0.038 MB geheugen voor zoekopdracht: 3.932 MB Regels teruggegeven: 18

SHOW FULL COLUMNS 
  FROM `gwbmp_jev_users`

Verklaren

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

Profiel

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.24 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:69
19	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:2308
18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1201
17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:50
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:923
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:27
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.13 ms Na de laatste zoekopdracht: 1.65 ms Zoekopdracht geheugen: 0.046 MB geheugen voor zoekopdracht: 4.000 MB Regels teruggegeven: 6

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

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1,2,3,6) 
  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	ALL	cat_idx,idx_access	INDEX KEY ONTBREEKT	NULL	NULL	58	Using where; Gebruikt bestandssortering

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
21	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:47
20	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:77
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:923
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:27
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.13 ms Na de laatste zoekopdracht: 0.23 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 4.042 MB Regels teruggegeven: 5

SELECT c.id

  FROM gwbmp_categories AS c

  WHERE c.access   IN (1,1,2,3,6)
 
  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	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	8	Using index condition; Using where; Gebruikt bestandssortering

Profiel

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:186
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:923
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:27
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.35 ms Na de laatste zoekopdracht: 0.67 ms Zoekopdracht geheugen: 0.070 MB geheugen voor zoekopdracht: 4.080 MB Regels teruggegeven: 10

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 gwbmp_jevents_repetition as rpt
 
  INNER JOIN gwbmp_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN gwbmp_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN gwbmp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN gwbmp_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,92,93,94,95,96)
 
  AND rpt.endrepeat >= '2018-10-22 15:07:34' 
  AND rpt.startrepeat <= '2019-05-10 23:59:59'
 
  AND (rpt.startrepeat >= '2018-10-22 15:07:34' OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1,2,3,6)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,2,3,6)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
						
  ORDER BY rpt.startrepeat ASC 
  LIMIT 10

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.10 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.01 ms
Unlocking tables	0.06 ms
executing	0.01 ms
Creating tmp table	1.19 ms
Copying to tmp table	0.94 ms
Sorting result	0.06 ms
Sending data	0.15 ms
Waiting for query cache lock	0.01 ms
Sending data	0.07 ms
end	0.01 ms
removing tmp table	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2584
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1423
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:27
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.72 ms Na de laatste zoekopdracht: 0.95 ms Zoekopdracht geheugen: 0.054 MB geheugen voor zoekopdracht: 4.325 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 gwbmp_jevents_repetition as rpt
 
  INNER JOIN gwbmp_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN gwbmp_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN gwbmp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN gwbmp_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,92,93,94,95,96)
 
  AND rpt.endrepeat >= '2018-10-22 15:07:34' 
  AND rpt.startrepeat <= '2018-10-22 15:07:34'
 
  AND (rpt.startrepeat >= '2018-10-22 15:07:34' OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1,2,3,6)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,2,3,6)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
  ORDER BY rpt.startrepeat desc 
  LIMIT 10

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.07 ms
optimizing	0.05 ms
statistics	0.10 ms
preparing	0.01 ms
Unlocking tables	0.05 ms
executing	0.01 ms
Creating tmp table	0.32 ms
Copying to tmp table	0.10 ms
Sorting result	0.02 ms
Sending data	0.11 ms
end	0.01 ms
removing tmp table	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.40 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2584
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1466
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:27
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.45 ms Na de laatste zoekopdracht: 0.18 ms Zoekopdracht geheugen: 0.067 MB geheugen voor zoekopdracht: 4.344 MB Regels teruggegeven: 6

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 gwbmp_jevents_repetition as rpt
 
  INNER JOIN gwbmp_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN gwbmp_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN gwbmp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN gwbmp_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,92,93,94,95,96)
 
  AND rpt.endrepeat >= '2018-10-22 15:07:34' 
  AND rpt.startrepeat <= '2018-10-22 15:07:34'
 
  AND (rpt.startrepeat <= '2018-10-22 15:07:34'OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1,2,3,6)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,2,3,6)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
  ORDER BY rpt.startrepeat asc 
  LIMIT 10

Verklaren

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

Profiel

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.01 ms
Unlocking tables	0.05 ms
executing	0.01 ms
Creating tmp table	0.29 ms
Copying to tmp table	0.19 ms
Sorting result	0.03 ms
Sending data	0.12 ms
end	0.01 ms
removing tmp table	0.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2584
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1508
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:27
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.13 ms Na de laatste zoekopdracht: 3.65 ms Zoekopdracht geheugen: 0.037 MB geheugen voor zoekopdracht: 4.419 MB Regels teruggegeven: 6

SELECT c.* 
  FROM gwbmp_categories as c 
  WHERE 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	cat_idx	202	const	6	Using index condition; Using where; Gebruikt bestandssortering

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/commonfunctions.php:92
14	JEV_CommonFunctions::getCategoryData()	JROOT/components/com_jevents/libraries/commonfunctions.php:117
13	JEV_CommonFunctions::setColor()	JROOT/components/com_jevents/libraries/jeventcal.php:313
12	jEventCal->bgcolor()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:92
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.41 ms Na de laatste zoekopdracht: 3.83 ms Zoekopdracht geheugen: 0.038 MB geheugen voor zoekopdracht: 4.329 MB Regels teruggegeven: 0

Identieke zoekopdrachten: #25

SELECT *

  FROM gwbmp_banners

  WHERE '2018-10-22 13:07:34' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Verklaren

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

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 0.99 ms Na de laatste zoekopdracht: 0.19 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 4.342 MB Regels teruggegeven: 4

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

  FROM gwbmp_banners as a

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

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-22 13:07:34') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-22 13:07:34') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (35)

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

Verklaren

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	idx_state,idx_banner_catid	INDEX KEY ONTBREEKT	NULL	NULL	16	Using where; Using temporary; Gebruikt bestandssortering
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	db10237_bcraakm.a.cid	1

Profiel

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.05 ms
executing	0.01 ms
Creating tmp table	0.22 ms
Copying to tmp table	0.14 ms
Sorting result	0.04 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tijd zoekopdracht: 9.92 ms Na de laatste zoekopdracht: 0.15 ms Zoekopdracht geheugen: 0.009 MB geheugen voor zoekopdracht: 4.366 MB

UPDATE gwbmp_banners

  SET impmade = (impmade + 1)

  WHERE id IN (15,17,3,16)

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: UPDATE gwbmp_banners SET impmade = (impmade + 1) WHERE id IN (15,17,3,16)

Profiel

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
updating	0.09 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	9.55 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:249
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.72 ms Na de laatste zoekopdracht: 0.13 ms Zoekopdracht geheugen: 0.008 MB geheugen voor zoekopdracht: 4.375 MB

UPDATE gwbmp_banner_tracks

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

  WHERE track_type=1 
  AND banner_id=15 
  AND track_date='2018-10-22 13'

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: UPDATE gwbmp_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=15 AND track_date='2018-10-22 13'

Profiel

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.14 ms
updating	0.06 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	6.24 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:287
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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: 7.43 ms Na de laatste zoekopdracht: 0.13 ms Zoekopdracht geheugen: 0.008 MB geheugen voor zoekopdracht: 4.383 MB

UPDATE gwbmp_banner_tracks

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

  WHERE track_type=1 
  AND banner_id=17 
  AND track_date='2018-10-22 13'

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: UPDATE gwbmp_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=17 AND track_date='2018-10-22 13'

Profiel

Status	Duration
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.10 ms
updating	0.05 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	7.04 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:287
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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: 19.94 ms Na de laatste zoekopdracht: 0.13 ms Zoekopdracht geheugen: 0.008 MB geheugen voor zoekopdracht: 4.392 MB

UPDATE gwbmp_banner_tracks

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

  WHERE track_type=1 
  AND banner_id=16 
  AND track_date='2018-10-22 13'

Verklaren

VERKLAREN niet mogelijk voor zoekopdracht: UPDATE gwbmp_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=16 AND track_date='2018-10-22 13'

Profiel

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.12 ms
updating	3.76 ms
end	0.02 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	15.64 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.03 ms
cleaning up	0.05 ms

Gestapelde oproeplijst

#	Caller	Bestand en regelnummer
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:287
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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]

32 zoekopdrachttypes gelogd, gesorteerd op weergave

SELECTEER Tabellen:

3 × 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 gwbmp_jevents_repetition as rpt  
  INNER JOIN gwbmp_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN gwbmp_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN gwbmp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN gwbmp_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

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

2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM gwbmp_banners as a 
  LEFT JOIN gwbmp_banner_clients AS cl 
  ON cl.id = a.cid

```
2 × SELECT * 
  FROM gwbmp_banners
```

1 × SELECT `data` 
  FROM `gwbmp_session`

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

1 × SELECT c.id 
  FROM gwbmp_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 
  FROM `gwbmp_categories` AS `c`

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

1 × SELECT 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 gwbmp_fields AS a 
  LEFT JOIN `gwbmp_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN gwbmp_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN gwbmp_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN gwbmp_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN gwbmp_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `gwbmp_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 `gwbmp_categories` AS `s` 
  INNER JOIN `gwbmp_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 gwbmp_content AS a 
  INNER JOIN gwbmp_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN gwbmp_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN gwbmp_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN gwbmp_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN gwbmp_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN gwbmp_content_rating AS v 
  ON a.id = v.content_id

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

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

1 × SELECT `session_id` 
  FROM `gwbmp_session`

```
1 × SELECT * 
  FROM gwbmp_languages
```

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

1 × SELECT `source`,`keepurlparams` 
  FROM `gwbmp_admintools_redirects`

1 × SELECT * 
  FROM `gwbmp_admintools_wafblacklists`

1 × SELECT * 
  FROM `gwbmp_admintools_ipautoban`

1 × SELECT * 
  FROM `gwbmp_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `gwbmp_admintools_storage`

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

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

1 × SELECT id, rules 
  FROM `gwbmp_viewlevels

1 × SELECT c.* 
  FROM gwbmp_categories as c

ANDERE Tabellen:

3 × UPDATE gwbmp_banner_tracks 
  SET `count` = (`count` + 1)

2 × UPDATE gwbmp_banners 
  SET impmade = (impmade + 1)

1 × INSERT INTO `gwbmp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('pjl0l05lfie42cgn72g6eoqkk3', 1, '1540213654', 0, '', 0

1 × SHOW VARIABLES LIKE "collation_database

1 × UPDATE `gwbmp_extensions` 
  SET `params` = '{\"mediaversion\":\"c763a94cb11e11fddb7d66b5d50ec3db\"}'

1 × SHOW FULL COLUMNS 
  FROM `gwbmp_jev_users