{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1495852089,
                "last": 1495852089,
                "now": 1495852089
            },
            "client": {
                "forwarded": "54.224.162.138"
            },
            "token": "LAZJ3alY7cXfxUjssXW9Yhz1b7UvgSSW"
        },
        "registry": {
            "jevents": {
                "moduleid91": {
                    "shownEventIds": [
                        [
                            "161",
                            "116",
                            "162",
                            "117",
                            "89",
                            "118",
                            "119"
                        ]
                    ],
                    "page": 0,
                    "firstEventDate": "2017-05-30 00:00:00",
                    "lastEventDate": "2017-06-26 00: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
        }
    }
}

Tijd

Geheugen

38 zoekopdrachten gelogd 43.52 ms

1. Tijd zoekopdracht: 0.46 ms Zoekopdracht geheugen: 0.003 MB geheugen voor zoekopdracht: 2.353 MB

   DELETE 
   
     FROM `GBSW_session`
   
     WHERE `time` < '1495850289'

   Verklaren

   VERKLAREN niet mogelijk voor zoekopdracht: DELETE FROM `GBSW_session` WHERE `time` < '1495850289'

   Profiel

   Status	Duration
   starting	0.04 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.09 ms
   updating	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.04 ms
   cleaning up	0.01 ms

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:818
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Tijd zoekopdracht: 0.37 ms Na de laatste zoekopdracht: 0.29 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 2.368 MB Regels teruggegeven: 0

   SELECT `data`
   
     FROM `GBSW_session`
   
     WHERE `session_id` = '054857e5a08bfd3f96a8bfb3df8c6ce0'

   Verklaren

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

   Profiel

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.03 ms
   cleaning up	0.01 ms

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   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:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Tijd zoekopdracht: 0.32 ms Na de laatste zoekopdracht: 0.72 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 2.454 MB Regels teruggegeven: 0

   SELECT `session_id`
   
     FROM `GBSW_session`
   
     WHERE `session_id` = '054857e5a08bfd3f96a8bfb3df8c6ce0' 
     LIMIT 1

   Verklaren

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

   Profiel

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 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.03 ms
   cleaning up	0.02 ms

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Tijd zoekopdracht: 0.87 ms Na de laatste zoekopdracht: 0.13 ms Zoekopdracht geheugen: 0.003 MB geheugen voor zoekopdracht: 2.459 MB

   INSERT INTO `GBSW_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('054857e5a08bfd3f96a8bfb3df8c6ce0', 1, '1495852089', 0, '', 0)

   Verklaren

   VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO `GBSW_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('054857e5a08bfd3f96a8bfb3df8c6ce0', 1, '1495852089', 0, '', 0)

   Profiel

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.01 ms
   update	0.11 ms
   end	0.01 ms
   query end	0.47 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.04 ms
   cleaning up	0.02 ms

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

5. Tijd zoekopdracht: 0.52 ms Na de laatste zoekopdracht: 4.41 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 2.897 MB Regels teruggegeven: 2

   SELECT b.id
   
     FROM GBSW_usergroups AS a
   
     LEFT JOIN GBSW_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Verklaren

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	6	Using where; Using index

   Profiel

   Status	Duration
   starting	0.06 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.01 ms
   optimizing	0.01 ms
   statistics	0.08 ms
   preparing	0.01 ms
   Unlocking tables	0.02 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.03 ms
   cleaning up	0.01 ms

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Tijd zoekopdracht: 0.34 ms Na de laatste zoekopdracht: 0.45 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 3.005 MB Regels teruggegeven: 7

   SELECT id, rules
   
     FROM `GBSW_viewlevels`

   Verklaren

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

   Profiel

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 ms
   freeing items	0.00 ms
   updating status	0.02 ms
   cleaning up	0.01 ms

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Tijd zoekopdracht: 1.14 ms Na de laatste zoekopdracht: 31.25 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 5.707 MB

   UPDATE `GBSW_extensions`
   
     SET `params` = '{\"mediaversion\":\"81f8433e94cbc9a9203735f79d99f8a8\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Verklaren

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

   Profiel

   Status	Duration
   starting	0.08 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.12 ms
   updating	0.08 ms
   end	0.01 ms
   query end	0.25 ms
   closing tables	0.01 ms
   Unlocking tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.04 ms
   cleaning up	0.02 ms

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
   9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
   8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
   7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
   4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Tijd zoekopdracht: 1.84 ms Na de laatste zoekopdracht: 9.42 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 6.515 MB Regels teruggegeven: 35

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `GBSW_assets`
   
     WHERE `name` IN ('com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR `parent_id` = 0

   Verklaren

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	GBSW_assets	ALL	idx_asset_name,idx_parent_id	INDEX KEY ONTBREEKT	NULL	NULL	103	Using where

   Profiel

   Status	Duration
   starting	0.13 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   After opening tables	0.01 ms
   System lock	0.02 ms
   Table lock	0.01 ms
   init	0.09 ms
   optimizing	0.03 ms
   statistics	0.30 ms
   preparing	0.04 ms
   executing	0.01 ms
   Sending data	0.59 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.09 ms
   cleaning up	0.02 ms

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
   16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
   15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
   14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
   13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
   12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
   11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:434
   10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:248
   9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
   8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
   7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
   5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
   4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Tijd zoekopdracht: 2.16 ms Na de laatste zoekopdracht: 0.89 ms Zoekopdracht geheugen: 0.036 MB geheugen voor zoekopdracht: 6.626 MB Regels teruggegeven: 30

   SHOW FULL COLUMNS 
     FROM `GBSW_content`

   Verklaren

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

   Profiel

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   closing tables	0.01 ms
   Opening tables	0.49 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.04 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.06 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.08 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.04 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.04 ms
   checking permissions	0.02 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
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.03 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.02 ms
   closing tables	0.01 ms
   executing	0.00 ms
   Sending data	0.16 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   removing tmp table	0.20 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   freeing items	0.02 ms
   updating status	0.03 ms
   cleaning up	0.01 ms

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
   14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
   13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
   12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
   11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
   10	JTable::getInstance()	JROOT/components/com_content/models/article.php:250
   9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
   8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
   7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
   5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
   4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Tijd zoekopdracht: 2.12 ms Na de laatste zoekopdracht: 2.01 ms Zoekopdracht geheugen: 0.037 MB geheugen voor zoekopdracht: 6.866 MB Regels teruggegeven: 1

    SELECT *
    
      FROM GBSW_content
    
      WHERE `id` = '30'

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	GBSW_content	const	PRIMARY	PRIMARY	4	const	1

    Profiel

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	1.43 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.05 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    10	JTable->load()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Tijd zoekopdracht: 2.10 ms Na de laatste zoekopdracht: 0.20 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 6.875 MB

    UPDATE GBSW_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '30'

    Verklaren

    VERKLAREN niet mogelijk voor zoekopdracht: UPDATE GBSW_content SET `hits` = (`hits` + 1) WHERE `id` = '30'

    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.11 ms
    Table lock	0.01 ms
    init	0.08 ms
    updating	0.17 ms
    end	0.01 ms
    query end	0.25 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
    10	JTable->hit()	JROOT/components/com_content/models/article.php:252
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Tijd zoekopdracht: 1.56 ms Na de laatste zoekopdracht: 12.53 ms Zoekopdracht geheugen: 0.037 MB geheugen voor zoekopdracht: 7.023 MB Regels teruggegeven: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM GBSW_content AS a
    
      INNER JOIN GBSW_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN GBSW_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN GBSW_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN GBSW_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 30 
      AND c.published > 0 
      AND a.language in ('nl-NL','*') 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-05-27 02:28:09') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-05-27 02:28:09') 
      AND (a.state = 1 OR a.state =2)

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

    Profiel

    Status	Duration
    starting	0.46 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.08 ms
    optimizing	0.06 ms
    statistics	0.22 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    executing	0.01 ms
    Sending data	0.09 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.04 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
    13	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:422
    12	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Tijd zoekopdracht: 1.42 ms Na de laatste zoekopdracht: 2.31 ms Zoekopdracht geheugen: 0.040 MB geheugen voor zoekopdracht: 7.253 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 GBSW_categories as c
    
      LEFT JOIN GBSW_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('nl-NL','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=8
    
      GROUP BY 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
    
      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,idx_language	INDEX KEY ONTBREEKT	NULL	NULL	15	Using where

    Profiel

    Status	Duration
    starting	0.42 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.02 ms
    init	0.11 ms
    optimizing	0.06 ms
    statistics	0.23 ms
    preparing	0.01 ms
    Unlocking tables	0.04 ms
    executing	0.01 ms
    Sorting result	0.10 ms
    Sending data	0.10 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.03 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
    21	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
    20	JCategories->get()	JROOT/components/com_content/router.php:70
    19	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
    18	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    17	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    16	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    15	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    12	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Tijd zoekopdracht: 0.86 ms Na de laatste zoekopdracht: 0.32 ms Zoekopdracht geheugen: 0.035 MB geheugen voor zoekopdracht: 7.290 MB Regels teruggegeven: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `GBSW_contentitem_tag_map` AS m 
    
      INNER JOIN `GBSW_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 30 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Verklaren

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

    Profiel

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.24 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
    12	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:180
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Tijd zoekopdracht: 1.47 ms Na de laatste zoekopdracht: 10.26 ms Zoekopdracht geheugen: 0.037 MB geheugen voor zoekopdracht: 8.120 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
    
      FROM GBSW_fields AS a
    
      LEFT JOIN `GBSW_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN GBSW_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN GBSW_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN GBSW_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN GBSW_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `GBSW_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 (8,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
    
      ORDER BY a.ordering

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    18	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    17	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
    11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:98
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Tijd zoekopdracht: 0.65 ms Na de laatste zoekopdracht: 10.64 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 8.789 MB Regels teruggegeven: 1

    SELECT language,id
    
      FROM `GBSW_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	GBSW_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	26	Using where

    Profiel

    Status	Duration
    starting	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
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.14 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.04 ms
    cleaning up	0.01 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
    8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:709
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Tijd zoekopdracht: 0.54 ms Na de laatste zoekopdracht: 0.19 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 8.798 MB Regels teruggegeven: 1

    SELECT `alias`
    
      FROM `GBSW_content`
    
      WHERE id = '30'

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	GBSW_content	const	PRIMARY	PRIMARY	4	const	1

    Profiel

    Status	Duration
    starting	0.03 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.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.01 ms
    Unlocking tables	0.01 ms
    executing	0.01 ms
    Sending data	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.04 ms
    cleaning up	0.01 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:123
    15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
    14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:720
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Tijd zoekopdracht: 0.87 ms Na de laatste zoekopdracht: 0.11 ms Zoekopdracht geheugen: 0.036 MB geheugen voor zoekopdracht: 8.810 MB Regels teruggegeven: 0

    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 GBSW_categories as c
    
      LEFT JOIN GBSW_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('nl-NL','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=30
    
      GROUP BY 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
    
      ORDER BY c.lft

    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.28 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.11 ms
    optimizing	0.05 ms
    statistics	0.08 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
    17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
    16	JCategories->get()	JROOT/components/com_content/router.php:70
    15	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:121
    14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:720
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Tijd zoekopdracht: 0.48 ms Na de laatste zoekopdracht: 0.60 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.843 MB Regels teruggegeven: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `GBSW_menu` AS `c`
    
      INNER JOIN `GBSW_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `GBSW_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `GBSW_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 123

    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.05 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    9	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:314
    8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:726
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Tijd zoekopdracht: 0.52 ms Na de laatste zoekopdracht: 0.50 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 8.862 MB Regels teruggegeven: 0

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
    
      FROM `GBSW_content` AS `c`
    
      INNER JOIN `GBSW_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_content.item'
    
      INNER JOIN `GBSW_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `GBSW_content` AS `c2` 
      ON a2.id = c2.`id`
    
      INNER JOIN `GBSW_categories` AS `ca` 
      ON `c2`.`catid` = ca.id 
      AND ca.extension = 'com_content'
    
      WHERE c.id = 30

    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.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 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.09 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    9	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:43
    8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:741
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Tijd zoekopdracht: 2.18 ms Na de laatste zoekopdracht: 104.50 ms Zoekopdracht geheugen: 0.036 MB geheugen voor zoekopdracht: 9.368 MB Regels teruggegeven: 6

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM GBSW_modules AS m
    
      LEFT JOIN GBSW_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN GBSW_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 <= '2017-05-27 02:28:09') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-05-27 02:28:09') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 123 OR mm.menuid <= 0) 
      AND m.language IN ('nl-NL','*')
    
      ORDER BY m.position, m.ordering

    Verklaren

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

    Profiel

    Status	Duration
    starting	0.19 ms
    checking permissions	0.01 ms
    checking permissions	0.00 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.02 ms
    init	0.08 ms
    optimizing	0.06 ms
    statistics	0.17 ms
    preparing	0.10 ms
    executing	0.06 ms
    Sorting result	0.22 ms
    Sending data	0.30 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.05 ms
    freeing items	0.02 ms
    updating status	0.08 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
    11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
    10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
    8	JDocumentHtml->countModules()	JROOT/templates/favourite/index.php:163
    7	require JROOT/templates/favourite/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Tijd zoekopdracht: 1.43 ms Na de laatste zoekopdracht: 16.67 ms Zoekopdracht geheugen: 0.039 MB geheugen voor zoekopdracht: 9.519 MB Regels teruggegeven: 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,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,
      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 GBSW_content AS a
    
      LEFT JOIN GBSW_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN GBSW_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN GBSW_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN GBSW_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN GBSW_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (16) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-05-27 02:28:09') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-05-27 02:28:09') 
      AND a.language in ('nl-NL','*')
    
      ORDER BY a.publish_up DESC 
      LIMIT 1

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Gebruikt bestandssortering
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	gbswemmel_be.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	gbswemmel_be.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	gbswemmel_be.a.id	1	Using where

    Profiel

    Status	Duration
    starting	0.33 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.11 ms
    optimizing	0.06 ms
    statistics	0.20 ms
    preparing	0.01 ms
    Unlocking tables	0.06 ms
    executing	0.01 ms
    Sorting result	0.07 ms
    Sending data	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.03 ms
    freeing items	0.02 ms
    updating status	0.05 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
    14	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:91
    13	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    12	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:198
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:610
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Tijd zoekopdracht: 0.96 ms Na de laatste zoekopdracht: 0.34 ms Zoekopdracht geheugen: 0.040 MB geheugen voor zoekopdracht: 9.562 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 GBSW_categories as c
    
      LEFT JOIN GBSW_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('nl-NL','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=16
    
      GROUP BY 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
    
      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,idx_language	INDEX KEY ONTBREEKT	NULL	NULL	15	Using where

    Profiel

    Status	Duration
    starting	0.21 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.08 ms
    optimizing	0.03 ms
    statistics	0.15 ms
    preparing	0.01 ms
    Unlocking tables	0.03 ms
    executing	0.00 ms
    Sorting result	0.06 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
    23	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
    22	JCategories->get()	JROOT/components/com_content/router.php:70
    21	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
    20	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    19	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    18	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    17	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    16	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    14	JRoute::_()	JROOT/modules/mod_articles_news/helper.php:104
    13	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    12	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:198
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:610
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Tijd zoekopdracht: 1.56 ms Na de laatste zoekopdracht: 0.74 ms Zoekopdracht geheugen: 0.039 MB geheugen voor zoekopdracht: 9.589 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
    
      FROM GBSW_fields AS a
    
      LEFT JOIN `GBSW_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN GBSW_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN GBSW_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN GBSW_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN GBSW_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `GBSW_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_articles_news.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
    
      ORDER BY a.ordering

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    23	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    22	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    21	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    19	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    16	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
    15	JHtml::call()	JROOT/libraries/cms/html/html.php:140
    14	JHtml::_()	JROOT/modules/mod_articles_news/helper.php:114
    13	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    12	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:198
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:610
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Tijd zoekopdracht: 1.64 ms Na de laatste zoekopdracht: 3.86 ms Zoekopdracht geheugen: 0.038 MB geheugen voor zoekopdracht: 10.353 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
    
      FROM GBSW_fields AS a
    
      LEFT JOIN `GBSW_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN GBSW_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN GBSW_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN GBSW_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN GBSW_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `GBSW_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 (16,0,13)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
    
      ORDER BY a.ordering

    Verklaren

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

    Profiel

    Status	Duration
    starting	0.19 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.09 ms
    optimizing	0.04 ms
    statistics	0.12 ms
    preparing	0.08 ms
    executing	0.01 ms
    Creating tmp table	0.34 ms
    Copying to tmp table	0.05 ms
    Sorting result	0.09 ms
    Sending data	0.06 ms
    end	0.01 ms
    removing tmp table	0.17 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.03 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    21	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    20	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    19	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    14	JApplicationBase->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:124
    13	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    12	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:198
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:610
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. Tijd zoekopdracht: 1.57 ms Na de laatste zoekopdracht: 23.45 ms Zoekopdracht geheugen: 0.034 MB geheugen voor zoekopdracht: 12.186 MB Regels teruggegeven: 18

    SHOW FULL COLUMNS 
      FROM `GBSW_jev_users`

    Verklaren

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

    Profiel

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.34 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    checking permissions	0.05 ms
    checking permissions	0.02 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.01 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    executing	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.11 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    freeing items	0.01 ms
    updating status	0.09 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    20	JTable->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:69
    19	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:2181
    18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1098
    17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:50
    16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:140
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:198
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:901
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:400
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Tijd zoekopdracht: 1.27 ms Na de laatste zoekopdracht: 1.95 ms Zoekopdracht geheugen: 0.039 MB geheugen voor zoekopdracht: 12.323 MB Regels teruggegeven: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM GBSW_categories as c
    
      WHERE (c.extension='com_jevents' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND c.language in ('nl-NL','*')
    
      GROUP BY 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
    
      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,idx_language	INDEX KEY ONTBREEKT	NULL	NULL	15	Using where; Gebruikt bestandssortering

    Profiel

    Status	Duration
    starting	0.19 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.10 ms
    optimizing	0.04 ms
    statistics	0.19 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sorting result	0.10 ms
    Sending data	0.07 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.04 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
    21	JCategories->_load()	JROOT/components/com_jevents/helpers/category.php:47
    20	JEventsCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
    19	JCategories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:90
    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:140
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:198
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:901
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:400
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

28. Tijd zoekopdracht: 0.52 ms Na de laatste zoekopdracht: 0.17 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 12.342 MB Regels teruggegeven: 1

    SELECT c.id
    
      FROM GBSW_categories AS c
    
      WHERE c.access   IN (1,1,5)
     
      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	2	Using index condition; Using where; Gebruikt bestandssortering

    Profiel

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.07 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:165
    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:140
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:198
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:901
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:400
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. Tijd zoekopdracht: 3.11 ms Na de laatste zoekopdracht: 0.81 ms Zoekopdracht geheugen: 0.062 MB geheugen voor zoekopdracht: 12.387 MB Regels teruggegeven: 7

    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 GBSW_jevents_repetition as rpt
     
      LEFT JOIN GBSW_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      LEFT JOIN GBSW_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      LEFT JOIN GBSW_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN GBSW_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,15)
     
      AND rpt.endrepeat >= '2017-05-27 04:28:09' 
      AND rpt.startrepeat <= '2017-06-26 23:59:59' 
      AND ev.state=1
     
      AND ev.access  IN (1,1,5)  
      AND icsf.state=1 
     
      AND icsf.access  IN (1,1,5)
     
      AND rpt.startrepeat=(
    				SELECT MIN(startrepeat) 
      FROM GBSW_jevents_repetition as rpt2
    				
      WHERE rpt2.eventid=rpt.eventid
    				
      AND  (
    					(rpt2.startrepeat >= '2017-05-27 04:28:09' 
      AND rpt2.startrepeat <= '2017-06-26 23:59:59')
    					OR (rpt2.startrepeat <= '2017-05-27 04:28:09' 
      AND rpt2.endrepeat  > '2017-05-27 04:28:09'  )
    					)
    				
    			) 
    			
      GROUP BY ev.ev_id
    			
      ORDER BY rpt.startrepeat 
      LIMIT 10

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	icsf	system	PRIMARY,stateidx	INDEX KEY ONTBREEKT	NULL	NULL	1	Using temporary; Gebruikt bestandssortering
    1	PRIMARY	rpt	range	eventid,eventstart,eventend,startrepeat,startend,endrepeat	endrepeat	5	NULL	19	Using index condition; Using where
    1	PRIMARY	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	gbswemmel_be.rpt.eventid	1	Using where
    1	PRIMARY	det	eq_ref	PRIMARY	PRIMARY	4	gbswemmel_be.rpt.eventdetail_id	1
    1	PRIMARY	rr	ref	eventid	eventid	4	gbswemmel_be.rpt.eventid	1
    2	DEPENDENT SUBQUERY	rpt2	ref	eventid,eventstart,eventend,startrepeat,startend,endrepeat	eventid	4	gbswemmel_be.rpt.eventid	1	Using where

    Profiel

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.12 ms
    optimizing	0.05 ms
    statistics	0.17 ms
    preparing	0.01 ms
    Unlocking tables	0.06 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.04 ms
    executing	0.01 ms
    Creating tmp table	0.57 ms
    Copying to tmp table	0.07 ms
    executing	0.01 ms
    Sending data	0.12 ms
    executing	0.01 ms
    Sending data	0.10 ms
    executing	0.02 ms
    Sending data	0.05 ms
    executing	0.01 ms
    Sending data	0.04 ms
    executing	0.01 ms
    Sending data	0.05 ms
    executing	0.01 ms
    Sending data	0.04 ms
    executing	0.00 ms
    Sending data	0.14 ms
    Sorting result	0.05 ms
    Sending data	0.19 ms
    end	0.01 ms
    removing tmp table	0.13 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.06 ms
    freeing items	0.01 ms
    removing tmp table	0.02 ms
    freeing items	0.02 ms
    updating status	0.09 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2562
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1050
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:400
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. Tijd zoekopdracht: 0.54 ms Na de laatste zoekopdracht: 3.85 ms Zoekopdracht geheugen: 0.029 MB geheugen voor zoekopdracht: 12.840 MB Regels teruggegeven: 0
    Identieke zoekopdrachten: #31

    SELECT *, summary as title, description as content 
      FROM GBSW_jevents_translation 
      WHERE evdet_id IN(161,116,162,117,89,118,119) 
      AND language='nl-NL'

    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.10 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.02 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.02 ms
    updating status	0.04 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2631
    16	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2591
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1050
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:400
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

31. Tijd zoekopdracht: 0.37 ms Na de laatste zoekopdracht: 0.14 ms Zoekopdracht geheugen: 0.027 MB geheugen voor zoekopdracht: 12.833 MB Regels teruggegeven: 0
    Identieke zoekopdrachten: #30

    SELECT *, summary as title, description as content 
      FROM GBSW_jevents_translation 
      WHERE evdet_id IN(161,116,162,117,89,118,119) 
      AND language='nl-NL'

    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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2631
    14	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:1528
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:400
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

32. Tijd zoekopdracht: 0.92 ms Na de laatste zoekopdracht: 3.57 ms Zoekopdracht geheugen: 0.032 MB geheugen voor zoekopdracht: 13.134 MB Regels teruggegeven: 1

    SELECT c.* 
      FROM GBSW_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	1	Using index condition; Using where; Gebruikt bestandssortering

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    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:314
    12	jEventCal->bgcolor()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:92
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. Tijd zoekopdracht: 1.56 ms Na de laatste zoekopdracht: 8.76 ms Zoekopdracht geheugen: 0.041 MB geheugen voor zoekopdracht: 13.091 MB Regels teruggegeven: 2

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,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,
      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 GBSW_content AS a
    
      LEFT JOIN GBSW_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN GBSW_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN GBSW_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN GBSW_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN GBSW_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (14) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-05-27 02:28:09') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-05-27 02:28:09') 
      AND a.language in ('nl-NL','*')
    
      ORDER BY a.ordering DESC 
      LIMIT 3

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Gebruikt bestandssortering
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	3	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	gbswemmel_be.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	gbswemmel_be.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	gbswemmel_be.a.id	1	Using where

    Profiel

    Status	Duration
    starting	0.28 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.12 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.11 ms
    optimizing	0.05 ms
    statistics	0.16 ms
    preparing	0.01 ms
    Unlocking tables	0.08 ms
    executing	0.01 ms
    Sorting result	0.14 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.05 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
    14	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:91
    13	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    12	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:198
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:610
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. Tijd zoekopdracht: 1.38 ms Na de laatste zoekopdracht: 0.78 ms Zoekopdracht geheugen: 0.039 MB geheugen voor zoekopdracht: 13.159 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
    
      FROM GBSW_fields AS a
    
      LEFT JOIN `GBSW_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN GBSW_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN GBSW_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN GBSW_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN GBSW_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `GBSW_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_articles_news.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (16,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
    
      ORDER BY a.ordering

    Verklaren

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

    Profiel

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.06 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.08 ms
    executing	0.01 ms
    Creating tmp table	0.36 ms
    Copying to tmp table	0.04 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    end	0.01 ms
    removing tmp table	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.04 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    23	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    22	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    21	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    19	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    16	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
    15	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    14	JHtml::_()	JROOT/modules/mod_articles_news/helper.php:114
    13	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    12	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:198
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:610
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Tijd zoekopdracht: 1.51 ms Na de laatste zoekopdracht: 0.43 ms Zoekopdracht geheugen: 0.038 MB geheugen voor zoekopdracht: 13.172 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
    
      FROM GBSW_fields AS a
    
      LEFT JOIN `GBSW_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN GBSW_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN GBSW_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN GBSW_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN GBSW_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `GBSW_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 (14,0,8)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
    
      ORDER BY a.ordering

    Verklaren

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

    Profiel

    Status	Duration
    starting	0.16 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.07 ms
    init	0.06 ms
    optimizing	0.04 ms
    statistics	0.09 ms
    preparing	0.08 ms
    executing	0.01 ms
    Creating tmp table	0.30 ms
    Copying to tmp table	0.03 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    end	0.01 ms
    removing tmp table	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.04 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    21	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    20	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    19	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    14	JApplicationBase->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:124
    13	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    12	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:198
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:610
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. Tijd zoekopdracht: 1.18 ms Na de laatste zoekopdracht: 0.72 ms Zoekopdracht geheugen: 0.039 MB geheugen voor zoekopdracht: 13.187 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
    
      FROM GBSW_fields AS a
    
      LEFT JOIN `GBSW_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN GBSW_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN GBSW_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN GBSW_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN GBSW_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `GBSW_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_articles_news.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (14,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
    
      ORDER BY a.ordering

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    23	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    22	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    21	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    19	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    16	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
    15	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    14	JHtml::_()	JROOT/modules/mod_articles_news/helper.php:114
    13	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    12	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:198
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:610
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Tijd zoekopdracht: 0.72 ms Na de laatste zoekopdracht: 1.12 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 13.277 MB Regels teruggegeven: 1

    SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias, 
      CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug 
      FROM GBSW_phocadownload AS a 
      LEFT JOIN GBSW_phocadownload_categories AS c 
      ON a.catid = c.id 
      WHERE a.id = 38

    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	c	const	PRIMARY	PRIMARY	4	const	1

    Profiel

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.08 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.04 ms
    cleaning up	0.02 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    20	JDatabaseDriver->loadObject()	JROOT/plugins/content/phocadownload/phocadownload.php:338
    19	plgContentPhocaDownload->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    16	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
    15	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    14	JHtml::_()	JROOT/modules/mod_articles_news/helper.php:114
    13	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    12	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:198
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:610
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

38. Tijd zoekopdracht: 0.52 ms Na de laatste zoekopdracht: 1.23 ms Zoekopdracht geheugen: 0.031 MB geheugen voor zoekopdracht: 13.355 MB Regels teruggegeven: 1

    SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias, 
      CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug 
      FROM GBSW_phocadownload AS a 
      LEFT JOIN GBSW_phocadownload_categories AS c 
      ON a.catid = c.id 
      WHERE a.id = 39

    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	c	const	PRIMARY	PRIMARY	4	const	1

    Profiel

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.01 ms
    Unlocking tables	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    20	JDatabaseDriver->loadObject()	JROOT/plugins/content/phocadownload/phocadownload.php:338
    19	plgContentPhocaDownload->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    16	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
    15	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    14	JHtml::_()	JROOT/modules/mod_articles_news/helper.php:114
    13	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    12	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:198
    11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:610
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---