{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1660567505,
                "last": 1660567505,
                "now": 1660567505
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Tijd

Geheugen

35 zoekopdrachten gelogd 84.41 ms

1. Tijd zoekopdracht: 0.60 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 1.027 MB Regels teruggegeven: 0

   SELECT `data`
   
     FROM `h1bg2_session`
   
     WHERE `session_id` = X'6c7462746b6d76663061347562323962303072616d30726a726f'

   Verklaren

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

   Profiel

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

   Gestapelde oproeplijst

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

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

   ---

2. Tijd zoekopdracht: 0.44 ms Na de laatste zoekopdracht: 0.98 ms Zoekopdracht geheugen: 0.020 MB geheugen voor zoekopdracht: 1.041 MB Regels teruggegeven: 0

   SELECT `session_id`
   
     FROM `h1bg2_session`
   
     WHERE `session_id` = X'6c7462746b6d76663061347562323962303072616d30726a726f' 
     LIMIT 1

   Verklaren

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

   Profiel

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

   Gestapelde oproeplijst

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

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

   ---

3. Tijd zoekopdracht: 1.48 ms Na de laatste zoekopdracht: 0.09 ms Zoekopdracht geheugen: 0.004 MB geheugen voor zoekopdracht: 1.046 MB

   INSERT INTO `h1bg2_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6c7462746b6d76663061347562323962303072616d30726a726f', 1, 1660567505, 0, '', 0)

   Verklaren

   VERKLAREN niet mogelijk voor zoekopdracht: INSERT INTO `h1bg2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6c7462746b6d76663061347562323962303072616d30726a726f', 1, 1660567505, 0, '', 0)

   Profiel

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

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Tijd zoekopdracht: 0.85 ms Na de laatste zoekopdracht: 1.81 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 1.077 MB Regels teruggegeven: 37

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `h1bg2_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Verklaren

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

   Profiel

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

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Zelfde als de call in onderstaande regel.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Tijd zoekopdracht: 0.35 ms Na de laatste zoekopdracht: 1.49 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 1.104 MB Regels teruggegeven: 5

   SELECT id, rules
   
     FROM `h1bg2_viewlevels`

   Verklaren

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

   Profiel

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.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.04 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Gestapelde oproeplijst

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

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

   ---

6. Tijd zoekopdracht: 0.43 ms Na de laatste zoekopdracht: 0.08 ms Zoekopdracht geheugen: 0.021 MB geheugen voor zoekopdracht: 1.116 MB Regels teruggegeven: 2

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

   Verklaren

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

   Profiel

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

   Gestapelde oproeplijst

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

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

   ---

7. Tijd zoekopdracht: 0.99 ms Na de laatste zoekopdracht: 0.21 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 1.137 MB Regels teruggegeven: 61

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM h1bg2_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Verklaren

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

   Profiel

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

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Zelfde als de call in onderstaande regel.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Tijd zoekopdracht: 0.98 ms Na de laatste zoekopdracht: 24.08 ms Zoekopdracht geheugen: 0.048 MB geheugen voor zoekopdracht: 1.751 MB Regels teruggegeven: 24

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM h1bg2_menu AS m
   
     LEFT JOIN h1bg2_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Verklaren

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

   Profiel

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

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Zelfde als de call in onderstaande regel.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
   8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1169
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Tijd zoekopdracht: 0.73 ms Na de laatste zoekopdracht: 6.71 ms Zoekopdracht geheugen: 0.023 MB geheugen voor zoekopdracht: 1.981 MB Regels teruggegeven: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `h1bg2_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Verklaren

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

   Profiel

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

   Gestapelde oproeplijst

   #	Caller	Bestand en regelnummer
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Zelfde als de call in onderstaande regel.
   12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Tijd zoekopdracht: 4.67 ms Na de laatste zoekopdracht: 0.17 ms Zoekopdracht geheugen: 0.005 MB geheugen voor zoekopdracht: 1.971 MB

    UPDATE `h1bg2_extensions`
    
      SET `params` = '{\"mediaversion\":\"55cbd410cfe99cb1c2ba2e8b159712e9\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Tijd zoekopdracht: 0.52 ms Na de laatste zoekopdracht: 1.04 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 1.991 MB Regels teruggegeven: 1

    SELECT *
    
      FROM h1bg2_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Tijd zoekopdracht: 0.46 ms Na de laatste zoekopdracht: 0.28 ms Zoekopdracht geheugen: 0.019 MB geheugen voor zoekopdracht: 2.002 MB Regels teruggegeven: 3

    SELECT id, home, template, s.params
    
      FROM h1bg2_template_styles as s
    
      LEFT JOIN h1bg2_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	transportenmilieu.s.template,const	1	Using index condition; Using where

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Tijd zoekopdracht: 0.67 ms Na de laatste zoekopdracht: 8.93 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 2.073 MB Regels teruggegeven: 1

    SELECT * 
      FROM h1bg2_zoo_application 
      WHERE id = 1

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	h1bg2_zoo_application	system	PRIMARY	INDEX KEY ONTBREEKT	NULL	NULL	1

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    13	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    12	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
    11	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    10	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
    9	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:83
    7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Tijd zoekopdracht: 0.81 ms Na de laatste zoekopdracht: 5.85 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 2.197 MB Regels teruggegeven: 37

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

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
    14	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
    13	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:217
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Tijd zoekopdracht: 0.18 ms Na de laatste zoekopdracht: 0.76 ms Zoekopdracht geheugen: 0.008 MB geheugen voor zoekopdracht: 2.267 MB

    
      SET SESSION group_concat_max_len = 1048576

    Verklaren

    VERKLAREN niet mogelijk voor zoekopdracht: SET SESSION group_concat_max_len = 1048576

    Profiel

    Status	Duration
    Starting	0.03 ms
    Opening tables	0.00 ms
    After opening tables	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/category.php:191
    15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
    14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
    13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:217
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Tijd zoekopdracht: 5.58 ms Na de laatste zoekopdracht: 0.37 ms Zoekopdracht geheugen: 0.045 MB geheugen voor zoekopdracht: 2.288 MB Regels teruggegeven: 22

    SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
      FROM h1bg2_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
      LEFT JOIN h1bg2_zoo_category_item as ci 
      ON ci.category_id = c.id 
      LEFT JOIN h1bg2_zoo_item AS i USE INDEX (MULTI_INDEX2) 
      ON ci.item_id = i.id 
      AND i.access IN (1,5) 
      AND i.state = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-08-15 12:45:05') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-08-15 12:45:05') 
      WHERE c.application_id = 1 
      AND c.published = 1 
      GROUP BY c.id

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ALL	APPLICATIONID_ID_INDEX	INDEX KEY ONTBREEKT	NULL	NULL	22	Using where; Gebruikt bestandssortering
    1	SIMPLE	ci	ref	PRIMARY,CATEGORYID_INDEX	PRIMARY	4	transportenmilieu.c.id	121	Using index
    1	SIMPLE	i	ref	MULTI_INDEX2	MULTI_INDEX2	4	transportenmilieu.ci.item_id	1	Using where; Using index

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    19	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
    18	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
    17	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
    16	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:217
    15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
    14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
    13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:217
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Tijd zoekopdracht: 28.01 ms Na de laatste zoekopdracht: 1.09 ms Zoekopdracht geheugen: 0.223 MB geheugen voor zoekopdracht: 2.564 MB Regels teruggegeven: 36

    SELECT a.* 
      FROM h1bg2_zoo_item AS a 
      LEFT JOIN h1bg2_zoo_category_item AS b 
      ON a.id = b.item_id 
      WHERE a.application_id = 1 
      AND a.access IN (1,5) 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-15 12:45:05') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-15 12:45:05') 
      AND b.category_id  = 2 
      GROUP BY a.id 
      ORDER BY a.priority DESC, a.publish_up DESC 
      LIMIT 0,36

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	1406	Using where; Using index; Using temporary; Gebruikt bestandssortering
    1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	transportenmilieu.b.item_id	1	Using where

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    16	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    15	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
    14	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:467
    13	ItemTable->getByCategory()	JROOT/components/com_zoo/controllers/default.php:238
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Tijd zoekopdracht: 1.11 ms Na de laatste zoekopdracht: 9.85 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 3.363 MB Regels teruggegeven: 63

    SELECT 
        *
    
      FROM 
        h1bg2_zoo_category_item ci
    
      WHERE
        item_id         IN ('1871','1870','1869','1868','1867','1866','1865','1864','1863','1862','1861','1860','1859','1858','1857','1856','1855','1854','1853','1852','1851','1850','1849','1848','1846','1845','1844','1847','1843','1842','1841','1840','1839','1838','1837','1835')

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ci	range	ITEMID_INDEX	ITEMID_INDEX	4	NULL	102	Using index condition

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php:57
    17	include JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/base/category.php:33
    15	include JROOT/media/zoo/applications/blog/templates/base/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Tijd zoekopdracht: 0.41 ms Na de laatste zoekopdracht: 0.17 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 3.406 MB Regels teruggegeven: 22

    SELECT 
        *
    
      FROM 
        h1bg2_zoo_category

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php:86
    17	include JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/base/category.php:33
    15	include JROOT/media/zoo/applications/blog/templates/base/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Tijd zoekopdracht: 1.30 ms Na de laatste zoekopdracht: 0.65 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 3.457 MB Regels teruggegeven: 3

    SELECT 
                i.id, i.name, i.alias, i.elements, i.publish_up
            
      FROM 
                h1bg2_zoo_category_item ci
            
      LEFT JOIN
                h1bg2_zoo_item i 
      ON ci.item_id=i.id
            
      WHERE
                ci.category_id     = '7'
                
                
      AND i.state        ='1'
                
      AND i.type         = 'news'
                
      AND i.publish_up   <'2022-05-24 10:40:15'
                
      AND (i.publish_down='0000-00-00 00:00:00' OR i.publish_down>='2022-08-15 12:45:05')
            
      ORDER BY publish_up DESC
            
      LIMIT 3

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ci	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	14	Using index; Using temporary; Gebruikt bestandssortering
    1	SIMPLE	i	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,TYPE_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	transportenmilieu.ci.item_id	1	Using where

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php:167
    17	include JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/base/category.php:33
    15	include JROOT/media/zoo/applications/blog/templates/base/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Tijd zoekopdracht: 1.65 ms Na de laatste zoekopdracht: 0.20 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 3.513 MB Regels teruggegeven: 3

    SELECT 
                i.id, i.name, i.alias, i.elements, i.publish_up
            
      FROM 
                h1bg2_zoo_category_item ci
            
      LEFT JOIN
                h1bg2_zoo_item i 
      ON ci.item_id=i.id
            
      WHERE
                ci.category_id     = '8'
                
                
      AND i.state        ='1'
                
      AND i.type         = 'news'
                
      AND i.publish_up   <'2022-05-24 10:40:15'
                
      AND (i.publish_down='0000-00-00 00:00:00' OR i.publish_down>='2022-08-15 12:45:05')
            
      ORDER BY publish_up DESC
            
      LIMIT 3

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ci	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	63	Using index; Using temporary; Gebruikt bestandssortering
    1	SIMPLE	i	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,TYPE_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	transportenmilieu.ci.item_id	1	Using where

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php:167
    17	include JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/base/category.php:33
    15	include JROOT/media/zoo/applications/blog/templates/base/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Tijd zoekopdracht: 1.47 ms Na de laatste zoekopdracht: 0.23 ms Zoekopdracht geheugen: 0.041 MB geheugen voor zoekopdracht: 3.530 MB Regels teruggegeven: 3

    SELECT 
                i.id, i.name, i.alias, i.elements, i.publish_up
            
      FROM 
                h1bg2_zoo_category_item ci
            
      LEFT JOIN
                h1bg2_zoo_item i 
      ON ci.item_id=i.id
            
      WHERE
                ci.category_id     = '10'
                
                
      AND i.state        ='1'
                
      AND i.type         = 'news'
                
      AND i.publish_up   <'2022-05-24 10:40:15'
                
      AND (i.publish_down='0000-00-00 00:00:00' OR i.publish_down>='2022-08-15 12:45:05')
            
      ORDER BY publish_up DESC
            
      LIMIT 3

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ci	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	46	Using index; Using temporary; Gebruikt bestandssortering
    1	SIMPLE	i	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,TYPE_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	transportenmilieu.ci.item_id	1	Using where

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php:167
    17	include JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/base/category.php:33
    15	include JROOT/media/zoo/applications/blog/templates/base/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Tijd zoekopdracht: 1.20 ms Na de laatste zoekopdracht: 0.21 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 3.554 MB Regels teruggegeven: 3

    SELECT 
                i.id, i.name, i.alias, i.elements, i.publish_up
            
      FROM 
                h1bg2_zoo_category_item ci
            
      LEFT JOIN
                h1bg2_zoo_item i 
      ON ci.item_id=i.id
            
      WHERE
                ci.category_id     = '11'
                
                
      AND i.state        ='1'
                
      AND i.type         = 'news'
                
      AND i.publish_up   <'2022-05-24 10:40:15'
                
      AND (i.publish_down='0000-00-00 00:00:00' OR i.publish_down>='2022-08-15 12:45:05')
            
      ORDER BY publish_up DESC
            
      LIMIT 3

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ci	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	33	Using index; Using temporary; Gebruikt bestandssortering
    1	SIMPLE	i	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,TYPE_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	transportenmilieu.ci.item_id	1	Using where

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php:167
    17	include JROOT/media/zoo/applications/blog/templates/base/_category_news_mag.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/base/category.php:33
    15	include JROOT/media/zoo/applications/blog/templates/base/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Tijd zoekopdracht: 1.21 ms Na de laatste zoekopdracht: 6.83 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 3.615 MB Regels teruggegeven: 20

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM h1bg2_modules AS m
    
      LEFT JOIN h1bg2_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN h1bg2_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 <= '2022-08-15 12:45:05') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-08-15 12:45:05') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 109 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	Zelfde als de call in onderstaande regel.
    24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    22	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    21	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    20	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:169
    19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    18	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/media/zoo/applications/blog/templates/base/category.php:45
    15	include JROOT/media/zoo/applications/blog/templates/base/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Tijd zoekopdracht: 0.53 ms Na de laatste zoekopdracht: 1.88 ms Zoekopdracht geheugen: 0.028 MB geheugen voor zoekopdracht: 3.724 MB Regels teruggegeven: 0
    Identieke zoekopdrachten: #32

    SELECT *
    
      FROM h1bg2_banners
    
      WHERE '2022-08-15 12:45:05' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    23	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    22	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    21	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    20	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    18	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/media/zoo/applications/blog/templates/base/category.php:45
    15	include JROOT/media/zoo/applications/blog/templates/base/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Tijd zoekopdracht: 1.06 ms Na de laatste zoekopdracht: 3.99 ms Zoekopdracht geheugen: 0.030 MB geheugen voor zoekopdracht: 4.015 MB Regels teruggegeven: 8

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM h1bg2_banners as a
    
      LEFT JOIN h1bg2_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-15 12:45:05') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-15 12:45:05') 
      AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
      AND a.catid IN (3)
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 12

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	idx_state,idx_banner_catid	idx_banner_catid,idx_state	4,1	NULL	5	Using intersect(idx_banner_catid,idx_state); Using where; Gebruikt bestandssortering
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	transportenmilieu.a.cid	1

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    25	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
    24	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    23	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    22	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    21	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    20	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    18	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/media/zoo/applications/blog/templates/base/category.php:45
    15	include JROOT/media/zoo/applications/blog/templates/base/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Tijd zoekopdracht: 3.74 ms Na de laatste zoekopdracht: 0.15 ms Zoekopdracht geheugen: 0.012 MB geheugen voor zoekopdracht: 4.106 MB

    UPDATE h1bg2_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id IN (1,2,3,4,6,7,8,9)

    Verklaren

    VERKLAREN niet mogelijk voor zoekopdracht: UPDATE h1bg2_banners SET impmade = (impmade + 1) WHERE id IN (1,2,3,4,6,7,8,9)

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    25	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:266
    24	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    23	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    22	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    21	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    20	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    19	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    18	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/media/zoo/applications/blog/templates/base/category.php:45
    15	include JROOT/media/zoo/applications/blog/templates/base/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Tijd zoekopdracht: 0.74 ms Na de laatste zoekopdracht: 9.34 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 4.207 MB Regels teruggegeven: 1

    SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` 
      FROM `h1bg2_chronoengine_extensions` AS `Extension` 
      WHERE `Extension`.`enabled` = '1' 
      ORDER BY `Extension`.`ordering` ASC

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    19	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
    18	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
    17	GCore\Libs\Model->find()	JROOT/libraries/cegcore/libs/gmodel.php:27
    16	GCore\Libs\GModel->find()	JROOT/libraries/cegcore/libs/event.php:18
    15	GCore\Libs\Event::get_extensions()	JROOT/libraries/cegcore/libs/event.php:35
    14	GCore\Libs\Event::trigger()	JROOT/libraries/cegcore/libs/app_j.php:112
    13	GCore\Libs\AppJ->dispatch()	JROOT/libraries/cegcore/libs/app_j.php:444
    12	GCore\Libs\AppJ::call()	JROOT/libraries/cegcore/joomla_gcloader.php:104
    11	JoomlaGCLoader->__construct()	JROOT/modules/mod_chronoforms5/mod_chronoforms5.php:24
    10	include JROOT/modules/mod_chronoforms5/mod_chronoforms5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Tijd zoekopdracht: 0.39 ms Na de laatste zoekopdracht: 1.20 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 4.232 MB Regels teruggegeven: 9

    SELECT `
      Group`.`id` AS `
      Group.id`, `
      Group`.`parent_id` AS `
      Group.parent_id`, `
      Group`.`lft` AS `
      Group.lft`, `
      Group`.`rgt` AS `
      Group.rgt`, `
      Group`.`title` AS `
      Group.title` 
      FROM `h1bg2_usergroups` AS `
      Group` 
      ORDER BY `
      Group`.`parent_id` ASC, `
      Group`.`lft`

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	Group	ALL	NULL	INDEX KEY ONTBREEKT	NULL	NULL	9	Gebruikt bestandssortering

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    17	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
    16	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
    15	GCore\Libs\Model->find()	JROOT/libraries/cegcore/libs/gmodel.php:27
    14	GCore\Libs\GModel->find()	JROOT/libraries/cegcore/libs/app_j.php:155
    13	GCore\Libs\AppJ->dispatch()	JROOT/libraries/cegcore/libs/app_j.php:444
    12	GCore\Libs\AppJ::call()	JROOT/libraries/cegcore/joomla_gcloader.php:104
    11	JoomlaGCLoader->__construct()	JROOT/modules/mod_chronoforms5/mod_chronoforms5.php:24
    10	include JROOT/modules/mod_chronoforms5/mod_chronoforms5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Tijd zoekopdracht: 0.59 ms Na de laatste zoekopdracht: 1.81 ms Zoekopdracht geheugen: 0.026 MB geheugen voor zoekopdracht: 4.292 MB Regels teruggegeven: 1

    SELECT `Form`.`id` AS `Form.id`, `Form`.`title` AS `Form.title`, `Form`.`params` AS `Form.params`, `Form`.`extras` AS `Form.extras`, `Form`.`published` AS `Form.published`, `Form`.`app` AS `Form.app`, `Form`.`form_type` AS `Form.form_type`, `Form`.`content` AS `Form.content` 
      FROM `h1bg2_chronoengine_chronoforms` AS `Form` 
      WHERE `Form`.`title` = 'Newsletter' 
      AND `Form`.`published` = '1'

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    21	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
    20	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
    19	GCore\Libs\Model->find()	JROOT/libraries/cegcore/libs/gmodel.php:27
    18	GCore\Libs\GModel->find()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:51
    17	GCore\Extensions\Chronoforms\Libs\Form->getForm()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:29
    16	GCore\Extensions\Chronoforms\Libs\Form->__construct()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:41
    15	GCore\Extensions\Chronoforms\Libs\Form::getInstance()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:43
    14	GCore\Extensions\Chronoforms\Chronoforms->index()	JROOT/libraries/cegcore/libs/app_j.php:249
    13	GCore\Libs\AppJ->dispatch()	JROOT/libraries/cegcore/libs/app_j.php:444
    12	GCore\Libs\AppJ::call()	JROOT/libraries/cegcore/joomla_gcloader.php:104
    11	JoomlaGCLoader->__construct()	JROOT/modules/mod_chronoforms5/mod_chronoforms5.php:24
    10	include JROOT/modules/mod_chronoforms5/mod_chronoforms5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Tijd zoekopdracht: 0.73 ms Na de laatste zoekopdracht: 3.00 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 4.414 MB Regels teruggegeven: 1

    SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`addon_id` AS `Extension.addon_id`, `Extension`.`name` AS `Extension.name`, `Extension`.`title` AS `Extension.title`, `Extension`.`enabled` AS `Extension.enabled`, `Extension`.`ordering` AS `Extension.ordering`, `Extension`.`settings` AS `Extension.settings` 
      FROM `h1bg2_chronoengine_extensions` AS `Extension` 
      WHERE `Extension`.`name` = 'chronoforms'

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	Extension	ref	name	name	767	const	1	Using index condition

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    19	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore/libs/database_adapters/joomla.php:48
    18	GCore\Libs\DatabaseAdapters\Joomla->loadAssocList()	JROOT/libraries/cegcore/libs/model.php:994
    17	GCore\Libs\Model->find()	JROOT/libraries/cegcore/libs/gmodel.php:27
    16	GCore\Libs\GModel->find()	JROOT/components/com_chronoforms5/chronoforms/libs/form.php:210
    15	GCore\Extensions\Chronoforms\Libs\Form::_settings()	JROOT/components/com_chronoforms5/chronoforms/chronoforms.php:45
    14	GCore\Extensions\Chronoforms\Chronoforms->index()	JROOT/libraries/cegcore/libs/app_j.php:249
    13	GCore\Libs\AppJ->dispatch()	JROOT/libraries/cegcore/libs/app_j.php:444
    12	GCore\Libs\AppJ::call()	JROOT/libraries/cegcore/joomla_gcloader.php:104
    11	JoomlaGCLoader->__construct()	JROOT/modules/mod_chronoforms5/mod_chronoforms5.php:24
    10	include JROOT/modules/mod_chronoforms5/mod_chronoforms5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Tijd zoekopdracht: 0.62 ms Na de laatste zoekopdracht: 6.27 ms Zoekopdracht geheugen: 0.022 MB geheugen voor zoekopdracht: 4.443 MB Regels teruggegeven: 0
    Identieke zoekopdrachten: #25

    SELECT *
    
      FROM h1bg2_banners
    
      WHERE '2022-08-15 12:45:05' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Verklaren

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

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Tijd zoekopdracht: 0.63 ms Na de laatste zoekopdracht: 0.14 ms Zoekopdracht geheugen: 0.024 MB geheugen voor zoekopdracht: 4.460 MB Regels teruggegeven: 0

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM h1bg2_banners as a
    
      LEFT JOIN h1bg2_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-15 12:45:05') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-15 12:45:05') 
      AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
      AND a.catid IN (9)
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 1

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	idx_state,idx_banner_catid	idx_banner_catid,idx_state	4,1	NULL	6	Using intersect(idx_banner_catid,idx_state); Using where; Gebruikt bestandssortering
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	transportenmilieu.a.cid	1

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Tijd zoekopdracht: 3.60 ms Na de laatste zoekopdracht: 3.39 ms Zoekopdracht geheugen: 0.039 MB geheugen voor zoekopdracht: 4.505 MB Regels teruggegeven: 3

    SELECT a.* 
      FROM h1bg2_zoo_item AS a 
      LEFT JOIN h1bg2_zoo_category_item AS b 
      ON a.id = b.item_id 
      WHERE a.application_id = 1 
      AND a.access IN (1,5) 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-15 12:45:05') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-15 12:45:05') 
      AND b.category_id  = 9 
      GROUP BY a.id 
      ORDER BY a.priority DESC, a.publish_up DESC 
      LIMIT 0,3

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	126	Using where; Using index; Using temporary; Gebruikt bestandssortering
    1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	transportenmilieu.b.item_id	1	Using where

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    14	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
    13	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:467
    12	ItemTable->getByCategory()	JROOT/administrator/components/com_zoo/helpers/module.php:125
    11	ModuleHelper->getItems()	JROOT/modules/mod_zooitem_fixed/mod_zooitem_fixed.php:29
    10	include JROOT/modules/mod_zooitem_fixed/mod_zooitem_fixed.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Tijd zoekopdracht: 15.68 ms Na de laatste zoekopdracht: 3.96 ms Zoekopdracht geheugen: 0.025 MB geheugen voor zoekopdracht: 4.631 MB Regels teruggegeven: 50

    SELECT a.name, COUNT(a.item_id) AS items 
      FROM h1bg2_zoo_tag AS a, h1bg2_zoo_item AS b USE INDEX (ID_APPLICATION_INDEX) 
      WHERE 1 
      AND a.item_id = b.id 
      AND b.application_id = 1 
      AND b.state = 1 
      AND b.type = 'news' 
      AND (b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2022-08-15 12:45:05') 
      AND (b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2022-08-15 12:45:05') 
      GROUP BY a.name 
      ORDER BY items DESC 
      LIMIT 0,50

    Verklaren

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ALL	ID_APPLICATION_INDEX	INDEX KEY ONTBREEKT	NULL	NULL	1586	Using where; Using temporary; Gebruikt bestandssortering
    1	SIMPLE	a	ref	PRIMARY	PRIMARY	4	transportenmilieu.b.id	4	Using index

    Profiel

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

    Gestapelde oproeplijst

    #	Caller	Bestand en regelnummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:134
    13	DatabaseHelper->queryObjectList()	JROOT/administrator/components/com_zoo/tables/tag.php:54
    12	TagTable->getAll()	JROOT/modules/mod_zootag/helper.php:41
    11	TagModuleHelper->buildTagCloud()	JROOT/modules/mod_zootag/mod_zootag.php:40
    10	include JROOT/modules/mod_zootag/mod_zootag.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---